The following section provides an explanation of all the columns in the filters sheet which is part of the Display generation spreadsheet:
Column Name | Explanation of contents |
---|---|
TYPE | This column specifies the structure of the filters. The type can either be a parent, a child or a timeseries (tms). The tms define the actual data to be displayed and the childs and parents define the order of the filter in that row (a child can be a parent at a lower level) |
FILTERID | This column contains the Id of the filter. This is used to make each filter unique to be able to nest filters within filters |
NAME | This is the name of the Filter. It is only used at the parent level and where the TimeSerieSet itself is specified |
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 |
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 | This column contains a reference to the input parameter to be processed. The name of the parameter should be taken from the parameters.xml |
LOCSET | This column is referring to the locationSet of the data which is displayed through the filter |
TMSTYPE | This column refers to the TimeSeriesType. 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 created. It can either be nonequidistant or DaysOfMonth |