Define columns
In this step, you define columns by specifying the values according to which the columns are to be calculated.
The definition is carried out by means of values that are linked to each other by operators.
A value can, for example, be the requirements of order 4711, which is
linked by "+" to a second value, for example, the requirements of order
4712. In the column, the total capacity requirements of the orders 4711 and 4712 is calculated in this case.
The following value types are distinguished:
In this case, the value is the requirements for a set. As a value, you enter the name of a
set
for the definition of the column. With the calculation of the value, all capacity requirements which meet the selection
criteria of the set are calculated and summed up.
Example of such a column definition:
Value type Value Operator
-------------------------------
1A SET1 +
If the column does not contain any other values, the capacity
requirements which meet the selection criteria of set "SETX1" would be calculated in the column.
If the set "SETX1" refers to the field "work center" and has the value
"R0815", the requirements for the work center "R0815" would be calculated. The result is calculated with a + sign.
With this value type, you enter a set not to be taken into account. You
can use this category only together with the category "1A".
Example of such a column definition:
Value type Value Operator
-------------------------------
1A SET1 +
1B SET2
The requirements which meet the criteria of the set "SET1" are
determined here, but the requirements of the set "SET2" are not taken into account. This way you can, for instance, calculate the
requirements of all orders at a work center, where all planned orders are to be ignored, however. For this, set "SET1" must contain the name of the required
work center
, while set "SET2" contains the order category "planned orders".
If you specify a sequence of sets in a column, the requirements that
correspond to the terms of all sets are calculated. You can only specify an operator for the first set.
With this value type, you refer to the value of another column.
Example of such a column definition:
Value type Value Operator
-------------------------------
2A SP1 +
2A SP2 +
This way, you add the calculated results of the columns "SP1" and "SP2".
Example of such a column definition:
Value type Value Operator
2B SP3 +
If you determine the requirements for the capacity category machine in the column "SP3", you calculate the appropriate available capacity.
If you have not made out any restrictions in the reference column, that is to say in column "SP3", concerning the
capacities to
be considered, then the availability of all capacities selected with the current evaluation is calculated.
With this value type, you specify an integral constant as a value. This way, you can calculate
capacity loads, for example.
Example of such a column definition:
In column "SP4", requirements for the capacity category "machine" are
determined. In column "SP5", the capacity load of the capacity category "machine" is to be calculated.
You must define the following columns to do this:
Value type Value Operator
1A SET1 +
SET1 contains the value "MAS" for machine for the field "capacity category".
Value type Value Operator
-------------------------------
2A SP4 +
2B SP4 /
3 100 *
In column SP5, load is displayed in %.
With this value type, you allocate characters to a column. This way, you can, for instance, include the character "%" in a list.
Actions
1. Specify a name for the columns.
2. Define the columns.