
B-63364EN/03 5. SETTING AND REGISTERING DATA FOR EACH CNC MACHINE
- 89 -
The format of the calculation formula follows the grammar of MS
Excel.
Only the cell position can be described and only the operator, "+" can
be used. For instance, in order to get the value from the cell position
F6 of the monitoring item, set the following calculation formula.
= F6
• • • Get the value of cell F6 as the logging data
In order to get multiple data as the logging data, set following formula
using the operator, "+".
= F6+F7+F8
• • • Get the value of cell F6, F7 and F8 as the logging data
Refer to the manual and help of MS Excel for details of the format
of the calculation formula of MS Excel.
Address
Set the output cell position for the logging data by the calculation
formula.
The format of the calculation formula follows the grammar of MS
Excel.
Only the cell position can be described and only the operator, "+" can
be used. For instance, in order to output the first logging data specified
at the "Output value" to the cell position A2, set the following
calculation formula.
= A2
• • • The first data specified at "Output value" is output to the
cell position A2 as the logging data
In order to output multiple logging data to multiple position, set
following calculation formula using the operator, "+".
= A2+B2+C2
• • • The first data specified at "Output value" is output to the
cell position A2 as the logging data, and the second output
to position B2, and the third output to position C2