Yokogawa Touch Screen GP20 - Manual (Page 392)

App-16
IM 04L51B01-01EN
Appendix 4 Creating Report Templates
Creating Report Templates for Report Files in Excel Format
To create a report template, enter keywords and text in the cells of an Excel file. Keywords
specify the type of data that will be entered into a cell. Text are output as they are in reports.
Save the report templates that you create in Excel format (.xlsx extension) or Excel macro
format (.xlsm extension).
Function: See page 1-102 in section 1.12, “Using the Report Template Function (/MT option)”.
Setup: See page 1-98 in section 1.11, “Configuring the Report Function (/MT option)”.
Loading and saving report templates: See page 1-104 in section 1.12.5, “Loading and Saving
Report Template Files”.
Template Example
Channel number $Tag(R001)$ $Tag(R002)$
Name Tank 1 temperature Tank 1 pressure
Unit $Unit(R001)$ $Unit(R002)$
$ReportDataTime(Hour)$ $ReportDataInst(Hour, R001)$ $ReportDataInst(Hour, R002)$
$Repeat$ $Repeat$ $Repeat$
$Repeat$ $Repeat$ $Repeat$
Report Output Example
Channel number TIC-001 PIC-002
Name Tank 1 temperature Tank 1 pressure
Unit °C kPa
2012/12/01 00:00:00 76.5 45.6
2012/12/01 01:00:00 78.9 56.7
2012/12/01 02:00:00 77.7 50.8