Yaskawa MP900 Series MPLOGGER - Manual (Page 78)

5 Application
5-2
5.1 Cell Settings
The main feature of MPLOGGER, the communications cell setup function, has been described
in previous chapters. In this section, techniques are introduced to use this function effectively
and to create monitoring displays.
MPLOGGER displays controller data in Excel cells. This data can be freely edited using Excel
functions. The thoughtful layout of data produces an easy-to-read display and enables the use of
Excel functions to extend the display to include colored cells and graphics. Using these func-
tions, the display can be developed to depict a floor plan of a factory process line.
„ Moving Cells
Cells can be moved by selecting and dragging them with a mouse. The cell settings will be
transferred when cells are moved. This function is useful in the following situations for set-
ting up cells and determining the layout of the sheet.
Displaying Current Values
This example describes the steps for creating a sheet that displays current values using
MPLOGGER’s monitoring function in a layout that corresponds to a control line.
1. Suppose that the operating status of the controllers in the control line is in MW1001 to
MW1010.
2. Create a layout display of the control line. Set up the cells in the empty area of the sheet
using the block setup function for MW1001 to MW1010.
3. Move the individual cells to the desired display positions.
„ Cell References
A cell reference allows the access of cell setting information by multiple sheets. It is useful
in cases where a number of controllers are monitored and for data maintenance of informa-
tion.
Operating Status Reference
1. Set up a worksheet with the cell settings. This sheet is designated only for cell settings
of monitoring data. Do not set up the user interface. Leave the data in a list or table for-
mat for easy maintenance, and set cells for all the required data.
2. When the cells have been set for all monitoring data, start designing the user interface
sheets. These sheets are different from the cell setting sheet.
3. To display the current operating status of each controller on the control line as in the
previous example, select cells to display the operating status after creating a layout dis-
play of the control line on the user interface sheet.
EXAMPLE
EXAMPLE