Scenario analysis shows how an output varies when input cells are driven by certain scenarios.
Scenario Analysis uses Cases. When you and your collaborators have added multiple cases (assumptions) in some cells, you can combine any case combination into a scenario and compare instantly results under all the scenarios created.
Create a scenario
You can create scenarios by clicking on the Scenarios button (see above).
Inside the panel, you can switch to existing scenarios or create a new one by typing a name for the scenario and clicking on Add Scenario.
When the cases selected in the grid have been grouped in a scenario, on top of the grid it will be clearly displayed the name of the scenario that is currently driving the cells in the grid.
Also the charts will display the scenario name under the title so that you will not be wondering under which assumptions you took that printout.
So you can switch cases one at a time from the cases panel, or you can switch scenarios and observe how all the cases part of that scenario are set to the right value, making it a breeze to watch charts changing as scenarios are changed.
Record a scenario
If you need to change multiple cells and group them automatically in a scenario, activate recording session and edit cells. Cases will be created and linked to a new scenario. You will be able to rename cases and scenarios after ending the recording session. Note the red dots appearing after editing the cell. It indicates that now the cell has more than one value. See How to create Cases in Visyond and Cases, scenarios, collaboration (overview video).
Comparing scenarios from scenario panel
Open the scenario panel and switch among them.
Switch assumptions (cases) in the cells driven by a scenario
Click on the “plus” icon next to a scenario to expand the list of cells that are driven by the scenario.
You can change the case via the dropdown or unlink the cell so that switching back to that scenario would have no effect on the cell.
Reset current Scenario
If you want to reset all the cells in the spreadsheet on their default case, click on the button Reset Scenario inside the Scenario Panel.
Comparing scenarios: the Scenario Analysis TAB
Clicking on the Scenario Tab, you can compare scenarios side by side, automatically generating a chart and a variance table ready to be printed or exported.
As usual, setting up this analysis requires only the selection of the output cells to analyse, the scenarios to compare, and one click on the button Compare Scenarios.
Compare ranges of output (formula) cells
You can select ranges (for example the Cash flow row) and see a time-based comparison (for each period on the x-axis, you will see the value of the cash flow when the selected scenarios are active).
Compare individual formula cells
You can also select sparse cells individually and, for each scenario (on the x-axis), see the values of those cells when that scenario is active.
See only the cells that are set on different assumptions in selected scenarios
Here you want to explore the cells that cause differences among scenarios.
- Go to Report/Overview Tab
- In the scenario section, select the scenarios you want to compare
- See them with all the cells that are not on their default assumption
- Now switch ON “Hide cells on same cases” and see only the cells that are NOT on the same case in all selected scenarios
Below the scenario comparison chart you will find a table displaying the values you see in the chart and their percentage change compared to the scenario that is currently selected in the grid.