Dealing with large number of scenarios

Answered

Comments

6 comments

  • Avatar
    Jason

    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

  • Avatar
    Jason

    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

  • Avatar
    Charles Ikenberry

    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.

     

  • Avatar
    Jason

    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

  • Avatar
    Charles Ikenberry

    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

  • Avatar
    Jason

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

    -Jason

Please sign in to leave a comment.