
B-63364EN/03 5. SETTING AND REGISTERING DATA FOR EACH CNC MACHINE
- 93 -
The format of the condition formula follows to the grammar of MS
Excel. For instance, when the monitor data is acquired only when the
value of cell F6 is larger than 0, set the following condition formula.
= F6>0
Refer to the manual and help of MS Excel for details of the format of
the condition formula of MS Excel.
And you can use the special logical functions prepared in the
Machining Status Monitor Package for the condition formula. Refer
to "4. Special logical functions of the Machining Status Monitor
Package" in this paragraph for the special logical functions of the
Machining Status Monitor Package.
Real value
It is not necessary to set the value.
The monitoring data from the personal computer is stored. The data is
stored in 1 byte integer representing the day of the week. The
correspondence on the value and the day of the week is as follows.
1 : Sunday 5 : Thursday
2 : Monday 6 : Friday
3 : Tuesday 7 : Saturday
4 : Wednesday
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, when the position of the cell of the acquisition
value is E6 and the acquisition value should be output as it is, set the
following calculation formula.
= E6
Instead, when the value by a factor of 10 over the acquisition value
should be output, set the following calculation formula.
= E6*10
Refer to the manual and help of MS Excel for details of the format
of the calculation formula of MS Excel.