Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Manage Excel Scenarios

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Back To Excel Model Analyzer Start & Demos

Manage Scenarios  
 
Use this tool to do any of the following:

1. Add a column with the same format as the other ones.

For example, you can add a column with "Year 2010" as heading.

2. Delete columns

3. Get the values output variables take when input variable values are changed in the model.

4. Change the values of the input variables in the model as you deem convenient.

With the Scenario tables module option of the Scenario sheet wizard we have created the following scenario sheet:

 
 
In the following example, analyze the sales and sales cost from 2005 to 2007.

Enter the values of all input variables in the table.
 
 
Open the Manage Scenarios dialog and click the Run button to get the values of output variables.
 
 
You can select another set of values from the tables and run the tool as many times as
you wish and analyze their impact on the output variable (in the example, Gross Margin)

WARNING

As you run the tool, the original values in your model are kept, but if you want
to replace that set of input variable values in your model, use the button

If you want to add or delete input or output values, use the Manage Inputs & Outputs tool.

Do not add columns manually, as this will result in errors. Use the Add-In to enter data
in an adequate and quick manner. This process is validated by VBA code.

Back To Excel Model Analyzer Start & Demos

Model Analyzer for Excel Secure Payment Options

Special! Free Choice of Complete Excel Training Course AND Excel Add-ins Collection on all purchases of Model Analyzer for Excel

1 Personal License $139.95 USD
2 - 5 Personal Licenses $118.95 USD
6 - 10 Personal Licenses $104.95 USD
11+ Personal Licenses $69.95 USD

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us