beautypg.com

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

background image

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

PDF

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

Report Template”

1.12.1 Excel Report Files

For instructions on how to create templates, see page App-16 in section Appendix 4, “Creating

Report Templates”.

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

Header, and File Name”

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).

This manual is related to the following products: