Spreadsheet tabs

Parent Previous Next

Quick reference : Spreadsheet tabs

This spreadsheet must have one Device tab and at least one of each Data and Template tabs. Other tabs are ignored by Gen.IT.

*** Customers with an enterprise license may use a separate Excel file for Template tabs.

<Description> are optional user configurable labels that have no significance to the Gen.IT application.

Device tabs are used to define devices and associated templates.

The two sets of tabs are dependent on each other and are linked via the ID values on each tab. All Device and Data tabs must contain the same amount and equal ID values, and no duplicate ID’s must exist on a single tab. Typically, the row or column number is used as the ID, with the ID cell formatted as ‘ID:[0-9]’.

Device and Data tabs can be defined in one of two ways – ID per Row, or ID per Column – and must be defined the same way within any given spreadsheet.

Device Sheets

The following data fields are required to define devices and categories:

DN:<DeviceID>:<Description> – Can also be written as DeviceName:<DeviceID>:<Description>

DR:<DeviceID>:<Description> – Can also be written as DeviceRAW:<DeviceID>:<Description>

DT:<DeviceID>:<Description> – Can also be written as DeviceTemplate:<DeviceID>:<Description>

DF:<DeviceID>:<Description> – Can also be written as DeviceFilename:<DeviceID>:<Description>

DA:<DeviceID>:<Description> – Can also be written as DeviceAppend:<DeviceID>:<Description>        

Multiple DT’s (templates) may be defined for each DN.

A single DA, DF, and DR may optionally be defined for each DN.

Data Sheets

Data tabs are used to define data variables and associated replacement values.

Note: The words row and column are used interchangeably below as the exact use depends on the where ID per row or ID per column is used.

The first row/column in each data sheet must be used as a heading row/column for all rows/columns. Variable names must be prefixed by 'DD:'.

All other rows/columns are ignored by Gen.IT. Other non ‘DD:’ and ‘ID’ rows /columns may contain any data/text/formulas.

The first row/column in each of the data sheets must be labeled as 'ID' and contain numerically unique values for each row/column. This ID column is used to link the various rows /columns spread across multiple sheets, and must be identical across all Data and Device sheets.

Multiple sheets may contain the same columns/data/headings, but when doing this, the data should be identical between sheets.

Some columns are required as defined in the spreadsheet specific settings file. These are:

Note: DD:<VariableName> – Can also be writen as Variable:<VariableName>

The actual values may be populated using any standard Excel method. i.e. text, functions, lookup tables, formulas, macro's etc.        

Template Sheets

Template tabs are used to specify templates containing text and variables.

The first row in each Template sheet must be used as a heading row (i.e. template name) for a column.


Any text placed under the template heading will be considered as to be part of the template.

Globals Sheet

A single 'Globals-' sheet may be defined.

Any variables that apply globally, to all ID's may be defined here. If a device data (DD) variable is also defined, then the DD variable takes preference of the global variable.