Manage Scenarios' Sheet  
 

With this tool you will be able to manage scenarios' sheets created with the scenarios' sheet wizard.
You can manage all three types of scenarios' sheets: BASIC, TABLES and COMBINED.

Use this manager to add or delete inputs, outpus, scenarios, headings and the options in the
customization tab.
 
 
Notice that, as it pops up, the scenarios manager dialog loads the input and output variables, the scenarios, Goal Seek and any additional customizations.
 
 
1 In this example we are going to delete the Discount rate input from the scenarios' sheet, by selecting it and then clicking on the Delete button, as shown in the picture below.
 
 
2 Now as an example, we will add the same input we had previously deleted from the model. As shown in the screenshot below, select Discount rate and press the + button (Add items).
 
 
Notice that here such input has already added to the scenarios' sheet, which is also reflected in the dialog.
 
 
3 In this example we are going to add two more scenarios called Scenario 3 and Scenario 4, which are entered separated by commas.
 
 
Notice that two columns have been added in the scenarios' sheet, and two items in the dialog.
 
 
4 In this section you can customize the options for calculations (applicable only in this sheet), the logo of your
company, if you want to apply conditional format, if you want to run macros you have created before running the
scenarios' sheet.
 
 
Here we have changed the logo. Additionally, you may add a link to the website of your company.
 
 

5 The Refresh Titles option has button with a T on it at the bottom of the dialog. Use it to refresh all variable headings you may have changed in the model.

As an example, we changed manually the Tax % input heading for Tax % xx, as shown below:
 
 
Now we open the Manage Scenarios' Sheet dialog and click on the Refresh Heading button to refresh all headings.
 
 
Notice that Tax % changed to Tax % xx in the dialog, the reflect the change in the sheet.
 
 
6 To make your work easier, we have included the Go button in this dialog to run the scenarios' sheets, besides the T button (Refresh headings)