The following section provides an explanation of all the columns in the gridDisplay sheet which is part Display generation spreadsheet:
Column Name |
Explanation of contents |
---|---|
TYPE |
This column specifies the structure of the plots. The type can either be a level 1 to level 4, loc, locset, contour or uv. The types loc and locset specify wheter the data is linked to 1 location or a locationset, the uv and contour types define a specific type of plot (using different settings) and the levels |
MI_PREFIX |
The ModuleInstance prefix is the model abbreviation and is referring to the first part of the ModuleInstanceId which was used to create and store the data. Together the columns MI_PREFIX, MI_SOURCE and MI_EXT create the complete ModuleInstanceId |
GROUPID |
This column contains the Id of the plotgroup. Each plotgroup should have a unique name |
GROUP_NAME |
This column contains the name of the plotgroup. This is used to specify the name of a group of plots |
PLOT_NAME |
This is the name of the plot. It is only used at the level of the plot where the TimeSerieSet itself is specified |
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 |
MI_SOURCE |
This is the middle part of the ModuleInstance source. It should refer to the processing step which was used to create the original data. Together the columns MI_PREFIX, MI_SOURCE and MI_EXT create the complete ModuleInstanceId |
MI_EXT |
This is the last part of the ModuleInstanceId. It should refer to the Scenario name, which was used to create the original data (or to 'observed' in case of observed data). Together the columns MI_PREFIX, MI_SOURCE and MI_EXT create the complete ModuleInstanceId |
PAR_EXT |
This column contains a reference to the input parameter to be processed. The name of the parameter should be taken from the parameters.xml |
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 |
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 |
TMSTYPE |
This TimeSeriesType is specified for each TimeSeries and should be the same as what has been used when the data was created. Three types (of the 4 available) are used in NGMS: external historical (observed data), simulated historical (used in ref scenario) and simulated forecasting (used in whatif scenario) |
TIMESTEP |
This is referring to the the TimeStep used for the data being displayed. It can either be nonequidistant or DaysOfMonth |
VIEWPERIOD_UNIT |
This column is referring to the unit of the period for which you want to display data. Typically we specify the display period in weeks. It is only used for the rows where you specify the data to be displayed |
VIEWPERIOD_START |
This column is referring to the start of the period for which you want to display data. Typically the start of the display period should be 0. It is only used for the rows where you specify the data to be displayed |
VIEWPERIOD_END |
This column is referring to the end of the period for which you want to display data. Typically the end of the display period should be the end of the simulation. It is only used for the rows where you specify the data to be displayed |