Data tabs are used to define data variables and associated replacement values.
Multiple 'Data-' sheet may be defined. Enterprise users may define 'Data-' sheets within multiple spreadsheets. The sheets will be aggragted into a single data table within Gen.IT (v2.9+).
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 or column in each data sheet must be used as a heading row or column for all rows/columns. Variable names must be prefixed by 'DD:'.
All other rows or columns are ignored by Gen.IT. Other non ‘DD:’ and ‘ID’ rows or columns may contain any data/text/formulas.
The first row or column in each of the data sheets must be labeled as 'ID' and contain numerically unique values for each row or column. This ID column is used to link the various rows or 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:
•DD:<Category> - A data column used as the primary sort field within the Gen.IT application. e.g. DD:SiteClassification
•DD:<PriListTag> - A data column used as the secondary sort field within the Gen.IT application. e.g. DD:SiteName
•DD:<Description> - Up to 4 data column used as the description field within the Gen.IT application. e.g. DD:SiteDescription
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.