Yaskawa MP900 Series MPLOGGER - Manual (Page 14)

1 Overview of MPLOGGER
1-2
1.1 Main Functions
MPLOGGER is an add-in software for Microsoft Excel that enables data from external devices,
such as controllers, to be displayed on a standard Excel spreadsheet. The data collected from
controllers can be displayed in tables, used in calculations, or graphed using standard Excel
functions.
MPLOGGER has two main functions, which can be selected from the special MPLOGGER
Menu added to Excel. The basic operation of MPLOGGER is easy to follow because it is simi-
lar to the operation of Excel.
„ Monitoring Function
The Monitoring Function is a realtime display function that displays the memory contents
of controllers connected to the PC, in Excel cells in the specified data format.
MPLOGGER uses a simple dialog to associate the Excel cells to specific controller
addresses to display the data. The data displayed in the cells changes according to the
controller address specified in arbitrary cell settings. The controller data displayed in the
Excel cells can be manipulated using standard Excel functions, and can be easily converted
into graphs or incorporated into calculations. It is also possible to write the data into the
controllers.
„ Data Logging Function
The Data Logging Function collects controller data in designated groups at specified time
intervals from the controller memory, and stores it in a Microsoft Access database file
(MDB file). The stored data can be viewed and analyzed using Excel or Access. This func-
tion is useful for creating trend graphs or reporting periodic data on a daily or monthly basis.