Exporting Scenario Results from a Time History Result Element to a Spreadsheet

When running multiple scenarios, time histories for different scenarios can be written to a spreadsheet.

Note, however, that export of scenario results to a spreadsheet must be carried out in a special way to prevent each export from simply overwriting previously exported scenarios.

In particular, when exporting scenarios, GoldSim exports all scenarios with results to a separate sheet from that defined in the dialog; it appends “-Scenarios” to the specified sheet name, and exports results to that sheet (creating it if it does not already exist). For example, if your specified sheet name was simply “Sheet1”, scenario results would be exported to “Sheet1-Scenarios” (and this is indicated in the dialog):

Scenario results are exported only under the following four conditions:

1. If the model is in Scenario Mode, pressing Export Now from the Export tab of the Result element exports results for all scenarios with results to the specified Scenarios sheet.

2. If the model is in Scenario Mode, pressing Export Now from the Results tab of the Model Options dialog exports results for all scenarios with results from all Time History Result elements to their specified Scenarios sheet.

3. Within Dashboards, the Button control provides a command option that is equivalent to pressing the Export Now button from the Result tab of the Options dialog. Hence, if the model is in Scenario Mode, this button command exports results for all scenarios with results from all Time History Result elements to their specified Scenarios sheet.

4. If you press Run All in the Scenario Manager, any Result elements that are configured to automatically exports result will export results for all scenarios to their specified Scenarios sheet.

Several important points should be noted regarding scenario export:

• If you run a single scenario from the Scenario Manager or from the Scenario control on a Dashboard, no results are exported (even for Result elements that are configured to automatically export).

• If you run a model such that it ends in Result Mode (e.g., by pressing F5 or the Run button in the Run Control toolbar), any Result elements that are configured to automatically export results will simply export results for the Active Scenario to the selected primary sheet (e.g., Sheet1). Similarly, if you press Export Now in Result Mode, the results for the Active Scenario will be exported to the primary sheet. In either case, any other results in the primary sheet will be overwritten. As a result, you cannot export scenario comparisons in this way.

• Since Player users cannot access the Scenario Manager, and single scenario runs are never automatically exported, if a Scenario control is present on a Dashboard when running the Player, automatic export will always be ignored. Results can only be exported manually. To export scenarios from the Player, the author should provide a Button control with an Export command (item #3 above). Note that the Result tab of the options dialog is accessible from the Player, so if the model is browsable, scenario export could also be carried out by pressing the Export Now button in that dialog (item #2). However, this would typically be a very awkward way for a Player user to trigger an export.

When exporting scenario results to the Scenarios sheet GoldSim provides two options for how the results are exported on the Export tab of the Result element dialog:

If you select “Group Results Together”, if multiple results are being exported, the columns will be grouped together by result:

In this particular example, the Result element contained two results (Flow and Cost) and three scenarios (Scenario1, Scenario2, and Scenario3) and was run for a single realization. Note that all the results for Flow are presented (for each scenario), followed by all the results for Cost.

If you select “Group Scenarios Together”, if multiple results are being exported, the columns will be grouped together by scenario:

Note that in this case all the results for the first scenario are presented (for each result), followed by all the results for the second scenario, and finally all the results for the third scenario.

Note that when exporting scenario results, GoldSim writes four header rows (rather than three). The first identifies the scenario, the second the result, the third the units, and the fourth the result type. In this example, in which only a single realization was run, the result type is simply the realization number. If multiple realizations were run, the result type would be a statistic.

In addition, the first cell contains a comment with information regarding the run (e.g., version used, date/time of simulation and export, name of Result element, names of scenarios being exported, etc.).