Data sheets

Parent Previous Next


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 written as Variable:<VariableName>


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