Compare Scenarios

Multiple scenarios can be created, simulated and compared to perform scenario analysis. Click on Compare on the navigation panel to open the Scenario Comparison window.

Click Compare for scenario comparison

In Scenario Comparison pop-up, all the scenarios are listed under the baseline using which it was created, and all the series including plan series are also available for comparison. Select the required scenarios and data series that you want to compare by checking them and then click Compare.

Select scenarios & series to compare

This opens the Compare Scenarios window where the top node value, KPIs, key inputs and simulation summary for all chosen scenarios and data series can be compared alongside each other.

Scenario Comparison

The current or the active scenario is highlighted with a blue outline in the Compare Scenarios window.

Manage Scenarios

Click on Manage Scenarios to add or remove any existing scenarios and series.

Alternatively, you can click on the + icon to add an existing scenario or data series for comparison. Click on the bin icon to remove them from the comparison window.

Manage Scenarios

Other features available in this window are highlighted in the below image.

Manage Comparison Features

Edit Simulation: This icon opens the Edit Simulation grid where you can manually edit the values for simulation at the period level for the desired nodes. This is already discussed here.

Simulation Impact: Clicking this icon opens a waterfall chart showing the breakdown of the Simulation Impact on the top node for that specific scenario.

Waterfall Chart for Total Net Profit - Scenario 2

Go to Scenario: Navigate to the respective Scenario's tree model on the simulation canvas by clicking this icon .

Remove: Finally, bin icon is used to remove the scenario from comparison.

Add KPI: Add any node as a KPI by clicking on +Add to compare.

Add Note: Click this icon to add a note and this icon to view already added notes.

Download Scenario Comparison

To export the scenario comparison data to Excel, click on Download as Excel option.

Download as Excel

This not only exports the KPIs, Key Inputs and simulation summary as seen in the window but also all the node values in the model for the respective scenarios and series under comparison.

Last updated