
5. SETTING AND REGISTERING DATA FOR EACH CNC MACHINE B-63364EN/03
- 94 -
• Display form
The display format of the cell where this "Output value" is output as
the logging data is specified using the formatting function of MS
Excel.
Refer to the manual and help of MS Excel for details of the display
format of MS Excel.
Setting example
The setting example for monitoring the following data from the
personal computer is illustrated below.
Monitor data : Current day of the week
Condition : None (Acquire at sampling intervals)
Output value : = Real value
(5) Calculate
The calculated value is acquired.
Item name
Set the name by which the character of this monitoring item is shown.
The item name becomes the key word for referring to the output item
on the registration auxiliary screen of the logging output item.
Output value
Set the calculation formula to convert the "Real value" into the
"Output value", or the display format of outputting as the logging
data.
• Calculation formula
The format of the calculation formula follows to the grammar of MS
Excel. For instance, in order to add the value of cell position F6 and
F7 where the monitoring data are stored, Set the following
calculation formula.
= F6+F7
When the alarm number is being monitored and it is stored to the
cell position F6, in order to output data including the character
string, such as "Alarm(number : OOOO)", set the following
calculation formula.
="Alarm(number : " &F6& ")"