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:
•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.