SEARCH |
Contact Us
HOME Excel |
Software |
Excel Formulas |
Excel Macros |
Free
Excel Help |
Excel Training |
Excel Development |
Newsletter |
SEARCH |
Contact Us
Excel Scenarios' Sheet Wizard
Back To Excel Model Analyzer Start
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
Software Categories
Excel Add-ins || Excel Training || Excel Templates || Employee Scheduling Software || Excel Password Recovery and Access & Word etc|| Excel Recovery and Access & Word etc || Financial Software || Financial Calculators || Conversion Software || Construction Estimating Software || Drilling Software || Real Estate Investment Software || Time Management Software || Database Software || Neural Network Software || Trading Software || Charting Software || Windows & Internet Software || Barcodes Fonts, ActiveX, Labels and DLL's || Code Printing Software || Outlook Add-ins
MOST POPULAR! Excel to HTML
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us
