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

  • No labels