Creating scenarios

What is a scenario?

Scenarios let you set up different... scenarios. This is useful when comparing different discrete options. For example, you might be trying to decide whether to hire 5 people or 10 people this year.
A scenario is a variant of your model in which some variables have different values or formulas. The structure of the model — the variables, groups, and sections — doesn't change across scenarios.
You can visualise multiple scenarios together in charts and tables, to easily compare them.
You can't perform calculations across scenarios. For example, you can't sum the values of a variable under different scenarios.
Best Practice: Scenarios vs Ranges
We don't recommend using scenarios to account for things like "best-case" and "worst-case" versions of your model — this is what ranges are for.

Creating scenarios

There are two ways to create a scenario:
  1. 1.
    Right-click on a variable and click New Scenario
  2. 2.
    Click on Scenarios in the toolbar, and then click Add new scenario.
Note: if you have a set of linked models - the Scenario will automatically apply across all models. If you subsequently create a new linked model and want your scenarios to be pulled across, see the section here for more info.

Scenario mode

To activate a scenario, click on Scenarios in the toolbar, and select the scenario. This will take you into Scenario mode. In this mode, you'll be able to change the value of any variable, and this change will only be applied in the active scenario.
Variables that have been changed in a scenario will have a light blue background.
You also have the following actions by clicking the Scenarios button (as per screenshot below):
  • Rename the scenario by double-clicking the name
  • Inspect the scenario by hitting
  • Clone the scenario
  • Delete the scenario
  • Override the default scenario with the selected scenario

Adding existing scenarios to newly linked models

If you subsequently link a (new or existing) model, to a model(s) that already has a saved scenario, you might notice that your saved scenarios are missing in the newly linked model. To add those previously saved scenarios, create a new scenario in the newly linked model with the exact name as the scenario(s) you want to retrieve (including spelling, capitalization, spacing, etc). Your model may need to be refreshed before your scenarios get loaded properly.
Copy link
On this page
What is a scenario?
Creating scenarios
Scenario mode
Adding existing scenarios to newly linked models