Formulas are used to define variables and calculations that then can be combined with Items to build
Assemblies.
 SelectorUse this field to select a previously saved Formula record.
|
|
 DescriptionEnter a meaningful description of the formula.
|
|
 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.
|
|
 Attachments Field |
|
 VariableThe name of the variable. This can be used to call out the variable on subsequent lines in the formula.
|
|
 UOMThe unit of measure of the variable.
|
|
 Calculation / QuantityThere 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 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.
|
|
 NotesNotes 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
|
|
|
 DescriptionThe description of the variable.
|
|
