Create Scenario Analysis |
When models are large and complex, and you wish to have input and output variables centralised, it is time to use the Create Scenario Analysis tool. With this tool, you can create quickly a new sheet in the same book, with the input and output cells you want to analyse, managing as much scenarios as columns are in the Microsoft Excel spreadsheet.
|
First choose the inputs and outputs from the left-side lists and move it to the right-side list. To do it see the following image: |
Click Next to enter the scenarios. The default number of scenarios is fourth, but you can add others by entering their names directly, separated by commas. |
Click Next. Enter the information about the scenarios sheet you are going to create. |
(OPTIONAL) If you click the Advanced customizing button, you will be able to configure certain advaced features, but you don't have to. You can create the scenarios sheet without customizing these options. |
(OPTIONAL) If you click the Apply Goal Seeker for Scenarios' Sheet checkbox, you will be able to configure Goal Seeker for Scenario Analysis, but you don't have to. You can create the scenarios sheet without customizing these options. |
When you click Finish, the following scenarios sheet will appear. |
Important: if you want to add or remove inputs, output or scenarios in the scenarios sheet don't do it manually; use the Manage Scenario Analysis tool. |