Page History

Merging the DisplayGroups configuration files requires some more changes in the spreadsheets. One has to merge the sheet 'DisplayGroups_plotdef' as well as the sheet 'DisplayGroups_folders'.

step 1: Merge sheet 'DisplayGroups_plotdef'

• Open the 'Region_Displays.xls' spreadheet and go to the 'DisplayGroups_plotdef' sheet which contains the plot definitions for Model1. The plot definitions form the first part of the DisplayGroups.xml file (section plot).
• The 'DisplayGroups_plotdef' sheet should contain all the scenarios and parameters used in either of the models. Copy all
  • merging models with the same time step
    • most of the plot definitions can be used for
  the display groups of Model2 from the spreadsheet 'Model2_Displays.xls' from the sheet 'DisplayGroups_plotdef' which are not yet part of the plot definitions for the display groups of Model1 in the '
  • • both models, except the plot definitions with plot id 'plot_H_ref_all' (on top of you spreadsheet). Here you have to have a separate plot definition for each model. Copy the section with the plot defintion 'plot_H_ref_all' from spreadsheet of model 2 under the section of the plot definition 'plot_H_ref_all' in the "Region_Displays.xls'
  spreadheet.
  • If the time step of the time series used for Model2 is the same as used for Model1, the plot definitions can be used for both models, e.g. plot definition
    • sheet. To distinguish between the plot definition of the two models add the model's abbreviation as a postfix to the plot id 'plot_H_ref(all)'. That means you have one plot definition named 'plot_H_
    whatif
    • ref(
    Hist
    • all)_
    to
    • Model1' used for plots of model 1 and one plot definition named 'plot_H_ref(
    Hist
    • all)_Model2'
    will be used for both Model1 and Model2. => see example 1If the time step of the time series used for Model2 differs from the time step used for Model1, each Model needs its own plot definition. All plot definitions of Model2 have then to be copied to the sheet 'DisplayGoups_plotdef' in the
    • used for plots of model 2.
    • Note: The plot id for these plots have to be changed accordingly in the sheet 'DisplayGroups_folders'. Here you refer to the plot definitions in the sheet 'DisplayGroups_plotdef'
    • Check if all other plot definitions from the model 2 spreadsheet 'DisplayGroups_plotdef' are represented in the model 1 spreadsheet 'DisplayGroups_plotdef'. Copy all plot definitions for the display groups of Model2 which are not yet represented in the plot definitions of Model1 from the spreadsheet 'Model2_Displays.xls' from the sheet 'DisplayGroups_plotdef' to the sheet 'DisplayGroups" in the 'Region_Displays.xls' spreadheet.
    To distinguish between the plot definition of the two model you now have to add a postfix to each plot id with the models abbrevation e.g. plot definition with plot id  'plot_H_whatif(Hist)_to_ref(Hist)_Model1' will be used for Model1 and plot definition with plot id 'plot_H_whatif(Hist)_to_ref(Hist)_Model2' will be used for Model2. The plot id in the sheet  'DisplayGroups_folders
  • merging models with different time step
    • If you merge two models with different time steps (e.g. time step model 1 is daysOfMonth="01" and time step model 2 is daysOfMonth="01 16") you can't use the same plot definitions for both models. In this case you have to take the same approach as for the 'pot_H_ref(all)' plot definitions when merging models with the same time step (see above) for all plot defintions. All plot defintions have to be copied from the sheet for model 2 to the plot defintions of the merged spreadsheet ('Region_Displays.xls') and the model abbrevation has to be added to each plot defintion as a post-fix. At the end you will have one spreadsheet 'DisplayGroups_plotdef' which contains all plot defintions for model 1 (each plot id contains the model abbreviation of model 1 as a post-fix), followed by all  model plot defintions for model 2 (each plot id contains the model abbreviation of model 2 as a post-fix)
    • Note: The plot id for these plots have to be changed accordingly in the sheet 'DisplayGroups_folders'. Here you
    ' which
    • refer to the plot definitions in the sheet 'DisplayGroups_plotdef'
    have to be changed accordingly. => see example 2

           example 1 (time step is the same)

           example 2 (time step differs)

• Save the spreadsheet 'Region_Displays.xls'

example file (Anglian displays, meged models EO, NWN and YNN all use the same time step)

step 2:

...

Merge sheet 'DisplayGroups_folders'

• Open the 'Region_Displays.xls' spreadheet and go to the 'DisplayGroups_folders' sheet which contains the folder structure of the display groups for Model1. The folder structure is forms the second part of the DisplayGroups.xml file (section displayGroup).
• Copy the content of the sheet 'DisplayGroups_folders' from the sheet for model 2, to the end of the same sheet in the merged spreadsheet ('Region_Displays.xls')the original sheets with DisplayGroups folders can be put in one sheet below each other. The order of the elements in the list should not be changed. The column SHEET refers to a different sheet with the locations to be displayed. The best procedure is to create a sheet for each model for each type of locations. The reference to these sheets should be put in the column SHEET correctly.
• the sheets with locations (e.g. Displays_obhs_YNN) should be populated with all locations for that specific location type for that model
modelcheck sheets (1 and 2) should be created for both models as well
• Make sure that the names of the plot id's match the names of the plot id's in the sheet 'DisplayGroups_plotdef).
  • change 'plot_H_ref_all' of model 1 to 'plot_H_ref_all_MODEL1' (where MODEL1 is the model abbreviation for model 1)
  • change 'plot_H_ref_all' of model 2 to 'plot_H_ref_all_MODEL2' (where MODEL2 is the model abbreviation for model 2)
  • if necessary add the model abbreviation as post-fix to every plot id name (in case the model time steps are different and one has to use a separate plot definition for each model, see above)
• save the spreadsheet 'Region_Displays.xls'

example file (Anglian displays, meged models EO, NWN and YNN all use the same time step)