The following section provides an explanation of all the columns in the DisplayGroups sheets which are part of the Display generation spreadsheet. The set up of the Displaygroups sheets is different from the other displays as it is more complex. Therefore it consists of multiple input sheets:. In the next section all of all the sheets are explained, the first two sheets seperately and the other sheets in one go as they are exactly the same.
The first sheet with the name DisplayGroups_plotdef contains the following columns:
...
Column Name | Explanation of contents |
|---|---|
TYPE | This column specifies the structure of the plots. The type can either be a level 1 to level 5 or display. The type display specifies whether that row is referring to the actual locations being displayed in the separate plots |
NAME | This is the name of the plot. The names of the plots at each level are specified |
PLOTID | This column contains the Id of the plot(group). Each plot(group) should have a unique name which is based on the parameter, datatype, scenario or ModuleInstanceId |
SHEET | This column contains a reference to the name of each of the other sheets containing the locations per location type |
LOCSET | This column is referring to the locationSet of the data which is displayed in the plot. Locations and LocationSet are mutually exclusive. Either one or the other should be filled in |
LOC | This column is referring to the location used to display the data. Locations and LocationSet are mutually exclusive. Either one or the other should be filled in |
The other sheets with names like Displays_<location type> contain the following columns:
Column Name | Explanation of contents |
|---|---|
LOC | This column is referring to the locationId used in this plot |
SHORTCUT | This column is referring to the display name used for this plot |