9-19
IM 04L42B01-01E
Computation and Report Functions (/M1 and /PM1 Options)
9
KeywordFormat
Keywords are written by themselves or with parameters.
$ Keyword(parameter)$ Example: $ReportDataSum(Hour,R01,00,23)$
• BasicRules
• Thedollarsignontheleftindicatesthestartofakeyword,andthedollarsignon
the right indicates the end of a keyword.
• Youcanonlywritekeywordsusinglettersofthealphabet,dollarsigns,parentheses,
commas, and spaces. You can put a space after an opening parenthesis, before
and after a comma, and before a closing parenthesis. There is no distinction
between uppercase and lowercase letters. You cannot use a dollar sign inside of a
keyword.
• Themaximumlengthofakeyword,includingspaces,is100characters.
• ParameterRules
• Parametersareenclosedinparentheses.
• Multipleparameters(upto4)areseparatedbycommas.
• Examplesofhowparameterscanbeomittedareshownbelow.
$ReportDataSum(Hour, R01, ,23)$ The third parameter is omitted.
$ReportDataSum(Hour, R01, 01, )$ or The fourth parameter is omitted.
$ReportDataSum(Hour, R01, 01)$
• RulesThatRelatetoExcel
• Setthedataformatbysettingthecellformat.
• Settheproperformatforeachkeyword’scellinthecell’sNumberproperties.
• Thekeywordinacellisonlyvalidwhenthekeywordnameandparametersare
all in the same format. When a keyword’s font size or some other property is not
consistent, it is invalid.
$ReportDataSum(
Hour
, R01, 00, 23)$
The font size of “Hour” is different, so the
keyword is invalid.
• Whenasinglecellcontainstextandakeyword,onlytheformatofthekeywordhas
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.
9.6CreatingaReportTemplate(Releasenumbers4andlater)