Manage Scenario Analysis

Use this tool to add or remove inputs, outputs and scenarios to or from a scenarios sheet created with Create Scenario Analysis. Do not try to make changes manually without using this tool or you will cause errors in you Excel model.

In this section you can add and remove inputs, or move them up and down a list of inputs.

You can add and remove outputs, or sort them by moving them up and down.

You can add or remove scenarios, and sort them by moving them left or right.

You can also customize advanced options as well as apply customized macros and conditional formats to show if the inputs have been changed to the original or active values in the model.

You can also customize goal seeker analysis for scenario analysis.