UI supported quali plan creation step 1: create Excel configuration file

[Yuri05]

Script inputs are:

• List of project snapshots given by their URL or relative path
• List of observed data sets (which are not included into the projects) given by their URL or relative path
• Default excel template (only captions and lookup tables)
• Optional: existing qualification plan. If not given: at least 1 project must be included into the projects list above
  • Optional: projects to remove?
  • Optional: observed data sets to remove?

▶ If no qualification plan was passed: fill the default template with the information extracted from snapshots, e.g.

• List of projects
• List of {project, simulation, output path}
• List of {project, simulation, observed data set}
• List of {project, building block type, building block name}
• …

▶ If qualification plan was passed:

• Set "List of Projects" = "Projects passed to the script" union "Projects from the qualification plan" minus "Projects to remove"
• Set "List of Observed Data Sets" = "Observed Data Sets passed to the script" union "Observed Data Sets from the qualification plan" minus "Observed data sets to remove"
• Reverse engineer the qualification plan into the Excel template (EVERYTHING)
• Add all NEW combinations of projects/simulations/outputs/observed data/… and highlight them as NEW (via cell background color)
• Highlight all previously available combinations of projects/simulations/outputs/observed data/… which are not available anymore as DELETED (via cell background color)

[Yuri05]

Example_QualiPlan_Input.xlsx

[Yuri05]

Open questions:

1. Is it possible to create Lookup-Tables in Excel dynamically via R script?

   Lookup Table

   

   If not: we could prefill the input excel template

   Prefill for large number of projects etc.

   

2. Do we need IDs for outputs?