The command Data | group Analyze | Scenario manager can also be used to create a scenario summary for all scenarios defined in the current worksheet.
A scenario summary is a table listing all scenarios well arranged side by side. For each scenario, the "changing cells" are displayed alongside with any "result cells" that you specify (containing the calculations to be observed).
Scenario summaries allow you to compare the changing values and the results of scenarios at a glance.
To create a scenario summary, proceed as follows.
| 1. | Create the desired scenarios (as described in the section Creating scenarios). |
| 2. | Choose the ribbon command Data | group Analyze | Scenario manager  . |
| 3. | Click on Summary. |
| 4. | Enter the address of the desired result cell. That is the cell that contains the calculation that you want to observe in your scenarios. |
| You can also specify multiple cells. Separate the cell addresses with a comma – for example: A2,A4,A10. Cell ranges (like B5:B10) are allowed as well. |
| 5. | Confirm with OK. |
PlanMaker will now create a new worksheet and generate the scenario summary on it.
Note: Scenario summaries are not updated automatically when cell contents or scenario settings are changed. To update a scenario summary manually, delete the worksheet containing the summary and create the summary once again.