Create Scenario Analysis
 
csa_ribbon
 

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.
As we have already loaded the inputs and outpus using Manage Inputs and Manage Outputs now just go to the section Scenario Analysis and select Create Scenario Analysis, taking the following model as example.

 
 
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:
 
csa_information2
 
 
csa_information3
 
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.
 
csa_information4
 
Click Next. Enter the information about the scenarios sheet you are going to create.
 
csa_information5
 
(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.
 
csa_information6
 

(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.

 
csa_information7
 
When you click Finish, the following scenarios sheet will appear.
 
csa_information8
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.