Yaskawa MP900 Series MPLOGGER - Manual (Page 79)

5.1 Cell Settings
5-3
5
4. Enter the reference cells from the cell setting sheet.
For example, to display the contents of sheet 2 cell D4 in sheet 1 cell C3, type
“=Sheet2!D4” in sheet 1 cell C3.
Copying a cell with settings using the Excel copy function will not copy the settings. The controller
data will not be displayed. To display data using the same cell settings in multiple locations, use the
cell reference function.
„ Block Setup
The block setup function is useful when creating a sheet to monitor large amounts of data
from controllers. When setting up write cells, or when large numbers of cells are being set
up using one Block Setup Function, the simultaneity of data needs to be considered.
Write Cells
A write cell is always paired with a Write Button.
Both the write cell and the button can be moved to a different position. Also, the button
name can be modified. One
Write Button, however, cannot be shared with cells that have
been set up separately.
If the Block Setup Function is used to set up write cells, clicking the
Write Button will take
the data from the cell range and write it to the controller. In this way, it is possible to write a
block of data (the cell range setup using Block Setup) to the controller in one cycle.
If the amount of data that can be written in one cycle is exceeded, it will automatically divide the infor-
mation and simultaneity will be lost.
If cells are set up using the Block Setup Function, any corrections or deletion of cells will
apply to the whole range. Cells in the range cannot be modified individually. This is done to
maintain the simultaneity of the Block Setup Function.
• The process of writing data to the controller begins when the Write Button is clicked after the data
is input to the cell. If the cell is left blank and does not contain any data, the writing process will
not be executed. If write cells are set up using the block setup function and there is a blank cell,
the data write command will not be sent to the controller.
• A data input value is checked when the Write Button is clicked. If the data is invalid, a message
will appeared and the command will not be sent.
INFO
IMPORTANT
INFO