Dealing with large number of scenarios

Answered

Follow

Charles Ikenberry

• March 22, 2018 17:31

1.  Is there a limit (i.e., a maximum) number of scenarios that can be saved in the Scenario Manager?

2.  Is there a way to export scenario results to different worksheets/tabs when exporting to Excel.  For example, if I run 5 scenarios with unique seepage rates and 5 scenarios with unique concentration reductions, can I export seepage results to one worksheet/tab and concentration reduction results to another?  Right now I'm finding it a little cumbersome to update the export options each time I add or change scenarios.

Thanks,

Charles

1

• 

  Jason

  • March 22, 2018 18:12
  • Edited

  Charles,

  We limit scenarios to 100. We didn't think anyone would ever need to use more than that. If you do, perhaps you might want to consider running Monte Carlo where each realization takes on the changing "scenario" data.

  Regarding your question about exporting scenario results: the answer depends on what kind of data you are exporting. If you are exporting via Time History Result elements, then the scenario offset is automatically sent to separate sheets where the data can be grouped either by scenario or by result type. If you are exporting final values via Spreadsheet element, then you can use the "offset" feature, which allows you to offset by row, column, or sheet in Excel based on a model variable. In your case, you could have a variable called "Scenario_Offset" that is just a Data element that has a value defined by the person creating the scenarios such as {1, 2, 3, etc.} that corresponds to each scenario. That way, your final value results can be offset by row, column, or sheet that corresponds to the scenario.

  Does this help? I will update our model library to include a model that demonstrates this shortly and let you know.

  -Jason

  0

  Comment actions Permalink
• 

  Jason

  • March 22, 2018 18:36
  • Edited

  Charles,

  Here is the model file that uses offsets based on a scenario number. I hope you find this helpful.

  Spreadsheet Offsets Based on Scenarios

  -Jason

  0

  Comment actions Permalink
• 

  Charles Ikenberry

  • March 23, 2018 13:42

  Thanks for the responses, Jason.  Yes, 100 scenarios is more than enough for me.  But I thought it would be good to know that number because I felt like I had a lot (probably 30-40).

   

  I'm exporting Time Series Data, so I'll learn more about the Scenario "Offset."  Right now all scenario results are exporting to the same sheet, grouped by Scenario.  I must not be setting up the Spreadsheet Export Configuration options correctly.

   

  0

  Comment actions Permalink
• 

  Jason

  • March 23, 2018 14:13

  Charles, 

  I misspoke about scenario time histories being exported to Excel. They do not offset by sheet but rather column only. The only option you have is to choose whether to group the columns by result or by scenario. Sorry for the confusion I may have caused.

  -Jason

  0

  Comment actions Permalink
• 

  Charles Ikenberry

  • March 27, 2018 19:42

  Thanks for clarifying, Jason.  That is what I was asking before, but I didn't spend too much time trying to make the impossible happen :)

   

  --Charles

  1

  Comment actions Permalink
• 

  Jason

  • March 27, 2018 20:14

  No problem. Good luck with your model and let us know if you have any other questions. Thanks for using the Forum!

  -Jason

  0

  Comment actions Permalink

Please sign in to leave a comment.