automatic defines
Automatic defines are created by the application with the name and value referencing various columns. They are available in the following areas of the application:
Automatic defines work the same as Global and Local defines; once a value has been created or defined you can reference it elsewhere in your Cost Estimate. Defines can be referenced by typing the ‘#’ symbol into the formula field.
Automatic defines are generated for certain properties of a Cost Estimate line and allow you to use them in complex formula or simply as a reference for another line’s quantity or value. These properties include:
- Quantity
- Estimated Quantity
- Line Quantity
- Line Production
- Line Number (Value)
- Duration
AUTOMATIC DEFINES TYPES
GENERAL
Define Name |
Description |
---|---|
#QTY |
This define references the value in the line Quantity, Matrix Item Quantity or Base Quantity for the Cost Estimate. |
#ESTQTY |
The #ESTQTY define references the value entered in the Estimated Quantity for the Cost Schedule Item. Note: This is only available in Cost Schedule Item Cost Estimates. |
#LQx |
This define references the Quantity value of the Cost Estimate line specified, where x represents the line number to be referenced. Note: Lines referenced must be above the line that the formula is used on. |
#DUR |
The #DUR define references the Duration value entered in the Cost Schedule item. Only available when a Duration and Duration Type has been set on the Cost Schedule. Genesis edition only. |
COST ESTIMATE TIME AND PRODUCTION MODE
Define Name |
Description |
---|---|
#LPx |
References the Production value of the Cost Estimate line specified, where x represents the line number to be referenced. Only available in Production mode Cost Estimates. Genesis edition only. |
#LNx |
Cites the Number value of the Cost Estimate line specified, where x represents the line number to be referenced. Only available in Time or Production mode Cost Estimates. Genesis edition only. |
RESOURCE CALCULATION TEMPLATES
Define Name |
Description |
---|---|
#CYCLEDAYS |
The Total number of days that have been defined within the Template Calendar window. The outcome of this formula will be placed within the result column. Genesis edition only. |
#CYCLEWEEKS |
Produces the Number of cycle days and converts this value to weeks. This value is also the CycleDays divided by Seven to represent a whole calendar week. The outcome of this formula is put into the result column. Genesis edition only. |
#TOTALEQUIVALENT |
This will populate the results column with the Sum of all equivalent ordinary hours in the cycle defined within the Template Calendar. Genesis edition only. |
#TOTALHOURS |
The #TOTALHOURS define will display the total number of hours in the current Template Calendar. Genesis edition only. |
#TOTALORDINARYHOURS |
This define will reference the Total number of ordinary hours in the cycle defined within the Template Calendar window. Genesis edition only. |
#WORKINGDAYS |
This define will calculate the total number of days in the cycle excluding any days that have zero working hours. Genesis edition only. |
#WORKINGWEEKS |
The #WORKINGWEEKS define will use the number of working days in the Template Calendar and divide this by seven to calculate the number of working weeks. Genesis edition only. |