| Scenarios' sheet wizard |  |
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.
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.
IMPORTANT
Once you have created the worksheet, you can use the Manage Scenarios and Manage Inputs and Outputs