Page History

UNDER CONSTRUCTION

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' to the end of the sheet 'DisplayGroups" 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
  • • sheet. To distinguish between the plot definition of the two models add the model's abbreviation as a postfix to
  each
  • • the plot id
  of the plot definitions for MOdel2 with the model's abbrevation, e.g. plot definition with plot id 
  • • 'plot_H_ref(all)'. That means you have one plot definition named 'plot_H_
  whatif
  • • ref(
  Hist
  • • all)_
  to_ref(Hist)' will be used for Model1 and plot definition with plot id
  • • Model1' used for plots of model 1 and one plot definition named 'plot_H_
  whatif(Hist)_to_
  • • ref(
  Hist
  • • all)_Model2'
  will be
  • • used for
  Model2.
  • • plots of model 2.
    • Note: The plot id for these plots have to be changed accordingly in the
  sheet 
  • • sheet 'DisplayGroups_folders'
  which refer to the plot definitions in the sheet 'DisplayGroups_plotdef' have to be changed accordingly.

add example file

2 Merge 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.
  • 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 refer to the plot definitions in the sheet 'DisplayGroups_plotdef'
• 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)