Produce Vision EIS metrics - RSGInc/SeaCast GitHub Wiki

There are special summaries for the Vision 2050 EIS process. Here are the steps to produce them:

  1. On every model run you are summarizing, run this script : EIS Summary script. At the top of the file point to your model run by hard-coding the path to the run like this: os.chdir(r"os.chdir(r"H:\vision2050\soundcast\integrated\draft_runs\stc\stc_run_3_2018_08_17_13_06\2050\scripts\summarize\notebooks")scripts\summarize\notebooks")

  2. The summary scripts will create outputs in the directory outputs of your model run. For example, "H:\vision2050\soundcast\integrated\draft_runs\stc\stc_run_3_2018_08_17_13_06\2050\outputs\Vision2050_longlist.csv"

  3. The file will have the columns blank id (no label), Value, Data Item, Geography, Grouping and Order)

  4. Repeat this process for each model run you would like to summarize.

  5. Now append all the outputs row-wise into a csv single file, by copying each output into the file. Add a column "Model Run", and fill it in with the name of each run. Name the empty first column "ID".

  6. Open Tableau-Public on your machine. Download the workbook here: EIS Tableau workbook.

  7. On the Data Source page in Tableau, edit the connection the file called "Vision2050_long_list_Version2". Update it to look at your file.

  8. Click on Story 1 in your Tableau workbook. It should have formatted tables now.

  9. Save your file to Tableau public. Now you can download the tables individually online to paste into the EIS excel template, by clicking in a cell on a table and then download crosstab.