Managing scenarios

<< Click to Display Table of Contents >>

Managing scenarios

The command Data | group Analyze | Scenario manager scenario_manager_icon can also be used to manage the scenarios defined in the current worksheet.

For that purpose, the following buttons are available in the dialog box for this command:

Add

Adds a new scenario.
For more information, see Creating scenarios.

Delete

Deletes the scenario selected in the list.

Edit

Opens a dialog box where you can edit the selected scenario. When you click on Next, another dialog box appears where you can edit the values for the changing cells.

Merge

Merges scenarios that have been defined on other worksheets (or workbooks) into the current worksheet.
For more information, see Merging scenarios.

Summary

Creates a scenario summary for all scenarios, where you can directly compare the values in the changing cells as well as any "result cells" you define.
For more information, see Creating a scenario summary.