Show TOC
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:
Column
"SP4":
Value type Value Operator
1A SET1 +
SET1 contains the
value "MAS" for machine for the field "capacity category".
Column
"SP5":
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.