Basic Functions of Material Quantity Calculation
Use
You can use the following functions in material quantity calculation whenever you do not need to access batch data for the calculation. If you must take the values of batches into account in a calculation, you can also use the functions described in
Material Quantity Calculation with Batch Data.Prerequisites
Features
The data of all materials, operations, and phases that are used in the master recipe or process order are available in material quantity calculation. When you call up material quantity calculation, you are given the following:
For materials for which you use batch determination, you are given the following in material quantity calculation:
For material properties, you are given:
If multiple values or value ranges have been defined, the system uses the lowest value.
After you have carried out batch determination, the planned value from the material list is normally still displayed in the totals record. If, however, no unit has been assigned to the characteristic, the system displays the sum of all batch values instead.
Example: Data of Material Quantity Calculation
You can enter formulas for the following fields:
This field does not directly influence the quantity structure of an order. Its value can, however, be used to calculate the remaining quantities.
You can use the following operands to define your formulas:
The system expects the decimal point or the sign defined for decimal expressions in your user defaults.
Note that the system does not take the unit of measure of referred values into account. Percentages, for example, are treated like absolute values during the calculation.
References are displayed as follows in the formula:
[<Line of the field referred to>,<Column of the field>]
In the graphic above:
In addition, you can use the operators or functions listed below:
Operator |
Meaning |
Example |
+ |
Addition |
|
- |
Subtraction |
|
* |
Multiplication |
|
/ |
Division |
|
DIV |
Division using integers; not intended for negative numbers |
10 DIV 3 = 3 |
MOD |
Remainder after division (modulo function); not intended for negative numbers |
10 MOD 3 = 1 |
Function |
Meaning |
Example |
** |
Exponentiation |
3**3 = 27 |
IF…THEN… ELSE |
Returns the following value:
|
IF (2<3) THEN (5*6) ELSE (5-7) = 30 |
IF NOT … THEN…ELSE |
Returns the following value:
|
IF (2<3) THEN (5*6) ELSE (5-7) = -2 |
ABS |
Absolute value |
ABS(-2) = 2 |
ROUND |
Round to nearest integer |
ROUND(1,8) = 2 |
TRUNC |
Integral amount of a number; not intended for negative numbers |
TRUNC(1,8) = 1 |
SQRT |
Square root |
SQRT(144) = 12 |
EXP |
Power to base e |
EXP(1) = 2.7182746352 |
LOG |
Logarithm to base e |
LOG(2.7182746352) = 1 |
SIN |
Sine |
SIN(0) = 0 |
COS |
Cosine |
COS(0) = 1 |
TAN |
Tangent |
TAN(1) » 1.55741 |
Example
Calculating Header and Component Quantities