Declaring the values for variables
Note: This functionality is available only if you have the Estimating Module.
Important! The math evaluator requires that you declare all variables. If the math evaluator finds undeclared variables in takeoff formulas, the program proceeds through the calculations using zero for each undeclared variable. Then, it displays a message telling you that you have undeclared variables and lists the lines where they are located in the takeoff so that you can declare them.
To solve a formula, assign a value to each variable in each takeoff grid.
Suppose you entered an assembly for cement in the takeoff grid, and it contains a formula to calculate the cubic yards of cement needed for the project. For each variable, enter a description and the units of measurement. In the Quantity column, enter the value. Then, in the Formula column, set the variable equal to the Quantity column. The values must precede the formulas. Otherwise, Sage 100 Contractor does not use the values.
|
Row |
Assmb# |
Dscrpt |
Unit |
Qty |
Formula |
|---|---|---|---|---|---|
|
1 |
|
Length |
feet |
15 |
L=Q |
|
2 |
|
Width |
feet |
20 |
W=Q |
|
3 |
|
Depth |
feet |
1 |
D=Q |
|
4 |
3001 |
Cement |
CuYd |
11.11 |
Q=L*W*D/27 |
You can declare new values for variables in the same takeoff grid. Some formulas might use the same variables but will require different values. Simply declare the new values on the lines preceding the formula that will use them. In a takeoff grid, Sage 100 Contractor uses the assigned values until you declare new values for those same variables.
Important! Using undeclared variables in takeoffs may result in inconsistent or incorrect calculations. We recommend that you declare all variables in takeoffs in order for the calculations to be correct.