Yokogawa Touch Screen GP20 User Manual
Page 393
App-17
IM 04L51B01-01EN
Appendix
1
2
3
4
5
App
Keyword Format
Keywords are written by themselves or with parameters.
$ Keyword(parameter)$
Example: $ReportDataSum(Hour,R001,00,23)$
Basic Rules
• The dollar sign on the left indicates the start of a keyword, and the dollar sign on the right
indicates the end of a keyword.
• You can only write keywords using letters of the alphabet, dollar signs, parentheses,
commas, and spaces. You can put a space after an opening parenthesis, before and after
a comma, and before a closing parenthesis. Keywords are not case sensitive. You cannot
use a dollar sign inside of a keyword.
• The maximum length of a keyword, including spaces, is 100 characters.
Parameter Rules
• Parameters are enclosed in parentheses.
• Multiple parameters (up to 4) are separated by commas.
• Examples of how parameters can be omitted are shown below.
$ReportDataSum(Hour, R001, ,23)$
The third parameter has been omitted.
$ReportDataSum(Hour, R001, 01, )$ or
The fourth parameter has been omitted.
$ReportDataSum(Hour, R001, 01)$
Excel Format Rules
• Set the data format by setting the cell format.
• Set the proper format for each keyword’s cell in the cell’s Number properties.
• The keyword in a cell is only valid when the keyword name and parameters are all in the
same format. When a keyword’s font size or some other property is not consistent, it is
invalid.
$ReportDataSum(
Hour
, R001, 00, 23)$
The font size of “Hour” is different, so the
keyword is invalid.
• If a single cell contains text and a keyword, only the format of the keyword has to be
consistent. The format of the text can be different.
Date and time:
$DateTime$
The format of the keyword is consistent, so it
is valid.
Limitations on Report Types and Template Types
If you violate the rules illustrated below, data will not be output.
Keyword
Parameter
Template Type
Report Kind
Hour
Day
Week
Month
Hour + Day
Day +
Week
Day +
Month
Batch
Day
Custom
Hour
Day
Week
Month
Batch
Custom
Free
Limitation on Report Types and Parameter Omissions
If you violate the rules illustrated below, it will be considered a keyword format error.
The keyword will not be converted and will remain as is.
Report Kind
Start date and time
End date and time
Start number
End number
Hour
Start time (hour)
End time (hour)
—
—
Day
Start day
End day
—
—
Week
—
—
—
—
Month
—
—
—
—
Batch
Relative start time (minute) Relative end time (minute)
Start number
End number
Custom
Start time (hour:minute)
End time (hour:minute)
—
—
Free
—
—
—
—
Appendix 4 Creating Report Templates