Create formulas

You can create formulas that Tekla PowerFab uses to calculate values. For example, you can create a formula to define the size of an angle used in a parametric assembly or to define the cost of an estimate extra.

Access the Formula dialog

Access the Formula dialog in one of the following ways:

For estimate extras, do the following steps:
- a. Go to Maintenance > Estimating > Labor Maintenance > Estimate Extras.
- b. Click the Formula button on any of the tabs.
For more information, see Create estimate extras.
For parametric assemblies, do the following steps:
- a. Go to Maintenance > Estimating > Parametric Assembly Maintenance.
- b. Select a parametric assembly and click Open.
- c. Click the Formula icon on the right side of any input field.
For more information, see Manage parametric assemblies.
For adjusting labor codes, do the following steps:
- a. Go to Maintenance > Estimating > Labor Maintenance > Labor Codes.
- b. Click the Labor Code Maintenance ribbon tab and select Formula Maintenance.
- c. Click Edit Formula.
For more details, see Add, modify, and delete formulas in Adjust labor codes

The Formula dialog opens.

The formula functions allow you to add the following items to the formula:

Standard Variables: The properties of a material item
Add Variable: Any previously added variables related to the parametric assembly or the estimate extra
IF / THEN / ELSE / ENDIF: IF/THEN/ELSE/ENDIF conditional statements
ANDOR: connectives conjunction and disjunction
=: is equal to
!=: everywhere
<: less than
>: greater than
<=: is less than or equal to
>=: is greater than or equal to
CEILING: rounding function, always rounds up
, FLOOR: rounding function, always rounds down
, ROUND: rounding function, rounds up at half and down by less than half..
SQRT: qquare root
SIN: sine
COS: cosine
TAN: tangent
HYP: hypotenuse
ASIN: arc sine
ACOS: arc cosine
ATAN: arc tangent

Example formula: Calculate the cost of an estimate extra

In this example, we want the estimate extra to add a cost of $100 if the length of the item is less than or equal to 40'. If the length is greater than 40', the added cost should be $150.

In this case, we need the following formula:

IF ([Length] <= 40') THEN (100) ELSE (150) ENDIF

In the Estimate Extra dialog, select the Cost Expression option, and click Formula.
In the Formula dialog, click the IF / THEN / ELSE / ENDIF button.
Go to the parenthesis after IF.
In the Additional Variables list, select Length.
Click Add Variable.

[Length] appears inside the parenthesis after IF.
Enter a space after [Length].
After the space, type: <=40'
Go to the parenthesis after THEN.
Type: 100
Go to the parenthesis after ELSE.
Type: 150
Click OK to close the Formula dialog and use the formula in the estimate extra.

The formula is now ready.

Tip: You can nest IF/THEN statements by adding additional IF/THEN statements in the ELSE section. Example: IF (Length<=40') THEN (100) ELSE (IF (<=60') THEN (150) ELSE (200) ENDIF) ENDIF.