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

Excel Scenarios' Sheet Wizard

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

 

Back To Excel Model Analyzer Start & Demos

Scenarios' sheet wizard  
 
 
Use this wizard to add a worksheet where the variables of the model you want to analyze will be presented
in an orderly manner. These variables are of two types: inputs and outputs.
Input variable: any variable which is not the result of a formula or a constant, but is rather part of a formula.
Output variable: any variable which is the result of a formula

You can create a scenario worksheet in any of the three following ways, depending on your analysis requirements.

1. A scenario module
Use this option to create a worksheet where input and output variables will be orderly listed in rows,
while the scenarios for selected variables are represented by columns.
 

You can assign the desired values out of all possible values input variables can take. After running the tool,
you will see the results in the Outputs section.

2. Scenario tables module
Use this option to create a worksheet where input and output variables will be orderly listed in rows.
You can enter such variables as time and others as column headings.
Possible values for input variables are displayed in a special section at the bottom of the worksheet.


 
3. Combine scenarios
Use this option to create a worksheet where input and output variables will be orderly listed in rows.
You can enter possible scenarios as column headings.
With this option you can select input and output variables from a worksheet containing scenarios
more quickly.

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