12 using the report template function (/mt option), 1 excel report files, 1 excel report files -102 – Yokogawa Touch Screen GP20 User Manual
Page 116
1-102
IM 04L51B01-01EN
1.12 Using the Report Template Function (/MT option)
You can create report templates and use them to automatically create custom report files.
Load a report template file that you have created into the GX/GP internal memory. The GX/
GP will automatically create report files using the report template file.
A report template file can be used to create report files in Excel format, create report files in
PDF format, and print reports on a printer connected over the LAN.
The GX/GP can handle template files that are 1 MB or smaller.
Report template file
Report file based
on a template
Save
Output
Excel
Printer
Internal
memory
Creating a report template: page App-16 in section Appendix 4, “Creating Report Templates”
Loading and saving report templates: page 1-160 in section 1.20.3, “Loading Report Templates
(/MT option)”page 1-164 in section 1.21.3, “Saving a
1.12.1 Excel Report Files
For instructions on how to create templates, see page App-16 in section Appendix 4, “Creating
Template
Item
Description
Format, extension
Excel format. The extension is .xlsx or .xlsm (with macro) (lowercase).
File name
Assign a file name of your choosing.
Kind
Creates a report template for each kind of report file. The kinds of report files
available are hourly, daily, weekly, monthly, hourly + daily, daily + weekly,
daily + monthly, batch, and day custom.
Creation method
Create templates using Microsoft Office 2007 or 2010.
Excel Report Files
Item
Description
Format, extension
Excel format. You can open the file with Excel. The extension is .xlsx or
.xlsm (with macro).
File name
The file name excluding the extension is the same as the report file with the
.GRE extension.
File name: page 1-89 in section 1.9.1, “Setting the Save Directory, File
Kind
For each kind of report file, a corresponding template file is used to create
the appropriate report files.
The report file that you create is based on the report creation setting. For
example, if the GX/GP is not configured to create daily reports, you will
not be able to use a report template to create daily reports. However,
regardless of this setting, you can output the data of all data types (average,
maximum, minimum, sum, and instantaneous).