×
Menu
Index

Formulas

Formulas
 
Formulas are used to define variables and calculations that then can be combined with Items to build Assemblies.
 
1

Selector

1. Selector
Use this field to select a previously saved Formula record.
2

Description

2. Description
Enter a meaningful description of the formula.
3

Line #

3. Line #
This field is read-only and is automatically assigned when you save a line in the table. Line # is very important because formulas are always evaluated from the top of the table downward. Lines that reference other variables or calculations need to have a higher Line # than the lines they refer to. Generally, variables that users will enter at run time will appear at the top of the table and thus have lower Line #s.
4

Attachments Field

4. Attachments Field
5

Variable

5. Variable
The name of the variable. This can be used to call out the variable on subsequent lines in the formula.
 
6

UOM

6. UOM
The unit of measure of the variable.
7

Calculation / Quantity

7. Calculation / Quantity
There are three basic options for data in this field. They are:
 
  • Empty. The user will be prompted to supply a value at takeoff time.
  • A number.
  • A logical expression composed of numbers, mathematical operators, functions, and variables defined previously in the formula. To be called out in an expression a variable must have been defined in a line above the current variable and the variable name must be enclosed in brackets.
 
8

Notes

8. Notes
Notes about the variable.
 
 

Mathematical Operators Available in Formulas

Operator
Comments
Operator
Comments
+ (plus)
Add
- (dash)
Minus
* (asterisk)
Multiply
/ (front slash)
Divide
^ (caret)
Exponent
% (percent)
Percent
 

Functions Available in Formulas

Operator
Comments
Operator
Comments
sqrt
Square Root
sin
Sine
cos
Cosign
tan
Tangent
atan
Arc Tangent
acos
Arc Cosine
asin
Arc Sine
acotan
Arc Tangent
exp
Exponent
ln
Natural Logarithm
10log
Logarithm
fac
Factorial
sinh
Hyperbolic Sine
cosh
Hyperbolic Cosine
tanh
Hyperbolic Tangent
abs
Absolute Value
ceil
Ceiling
floor
Floor
sfac
Semi Factorial
round
Round
fpart
Fraction Part
 
 
 

Logical Symbols Available in Formulas

Operator
Comments
Operator
Comments
!
Not
==
Equal To
!=
Not Equal To
||
Or
&&
And
>
Greater Than
<
Less Than
>=
Greater Than or Equal To
<=
Less Than or Equal To
 
 
9

Description

9. Description
The description of the variable.