Formulas Overview
Formulas are user-defined equations constructed using variables and are used to calculate an estimate line item's quantity. They can also be referenced in a Work Item and, when added to the estimate, the equation and variables are copied along with the item's cost information. Thus, it is crucial that the unit of measure for the Estimate Line Item and Formula's calculated result are the same.
Example Formula
Concrete - Slad - Cubic Yards
=(SlabL * SlabW * (SladD / 12)) / 27
| Code | Description | Unit |
|---|---|---|
| SlabL | Length of slab |
FT |
| SlabW | Width of slab |
FT |
| SlabD | Depth of slab |
IN |
Important Things To Know
- Variable Codes should not have any spacing. Example 'L S' for Length of Slab.
- Variable Codes should not be a single character. Example W or L.
- If a multiplier is used in a Formula and is less than 1 (eg. 0.33), it must be preceded with a zero (0).
Correct Equation = Length * 0.33
Incorrect Equation = Length * .33