Rules for Naming

Special rules must be kept in mind for naming the cells, rows and columns of the template file for the User-Excel-Interface, so that EBSILON^®Professional can assign the data correctly to the cells.

These rules describe,

• in which cells of the Excel-sheet the data is to be entered,
• which specification or result values are to be entered,
• from which profiles or from which components the data is to be taken.

The names to be given comprise of a prefix, an underscore ("_") and the name of the object or the desired value

 

Prefixes

The prefix specifies, which type of data is to be given as output. Different prefixes can be used depending upon the type.

Prefix	Meaning	Range	Can be used for
F	Fixed values (file names, times)	individual cells	Type A und Type B
M	Model variables	individual cells	Type A und Type B
S	Specification and result values	Row	Type A
P	Profiles	Column	Type A
X	Extra values (e.g. unit)	Column	Type A
C	Components	Row	Type B
N	Names	Column	Type B
V	Values	Column	Type B
U	Units	Column	Type B
L	Pipes	Column	Type B

Examples are given along with the rules for Type A and Type B respectively.

When you allocate names to individual cells instead of complete rows (or columns), EBSILON^®Professionaluses the corresponding row (or column) , in which the cell is present.

 

Names

• To specify a profile, use its name.
• To specify a component or a pipe, use their names.
• To specify a specification value, use its identifier.
• To specify a connection point, use its number.

 

Key words for all types

The following key words can be used as names for individual cells in both report types:

Name of the cell	Content entered by Ebsilon in the cell
F_FILE	File name of the model file
F_DATE	Current time
F_INPFILE	File name of the input file read (if available)
F_MODELDATE	Time stamp of the measurement values read (if available)
M_Variable	Value of the model-global variables with the names Variable (in EbsScript syntax @model.variable)