beautypg.com

Yokogawa Touch Screen GP20 User Manual

Page 393

background image

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

This manual is related to the following products: