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 or it specifies which template to use. The type can either be plot or subplot or a reference to a template name. The types plot and subplot specify the level of the plot to be displayed. The template names are used in the rows where the actual timeseries to be displayed is specified |
PLOTID | This column contains the Id of the plotgroup. Each plotgroup should have a unique name |
MODINSTSET | This column is referring to the the first part of the ModuleInstanceSetId. The ModuleInstanceSet is a group of ModuleInstanceIds. As all ModuleInstanceSets start their Ids with 'All', this is the setting typically used |
LOCSET | This column is referring to the locationSet of the data which is displayed through the plot. Locations and LocationSet are mutually exclusive. Either one or the other should be filled in |
RUNTYPE | This is the last part of the ModuleInstanceSetId. It should refer to the Scenario name, which was used to create the original data (or to 'observed' in case of observed data) |
RUNTYPE_2 | This is the last part of the ModuleInstanceSetId only used when comparing results of scenarios. It should refer to the Scenario name which is used as a reference for the comparison |
TIMESTEP | This is referring to the the TimeStep used for the data being displayed. It can either be nonequidistant or DaysOfMonth |
PAR | This column contains a reference to the input parameter to be processed. The name of the parameter should be taken from the parameters.xml |
PAR_postfix | This column contains a reference to the extension of the input parameter to be processed. This extension is related to the scenario to be displayed. The name of the parameter should be taken from the parameters.xml |
COLOR | In plots where longitudinal profiles (locationSet is 'branches_all') are displayed, specific colors are defined for each parameter or for each scenario |
LINESTYLE | In plots where longitudinal profiles (locationSet is 'branches_all') are displayed, specific linestyle types are defined for each parameter or for each scenario |
The second sheet with the name DisplayGroups_folders 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 |