Corel wordperfect office 2002 사용자 설명서
or variable values plugged into a model and the values that result. For example, a worst-case
scenario shows what you can expect from the least desirable set of variable values; a best-case
scenario uses the most desirable values as input. Scenarios are often used to find the optimum
solution to a problem.
Before using scenarios, you have to create a data model that includes formulas and supporting
Before using scenarios, you have to create a data model that includes formulas and supporting
data.
To create a scenario
1 Click Tools } Scenario } New.
2 Click the Range picker
2 Click the Range picker
in the Changing cells box, and select the changing cells.
3 Click Next.
4 Type a name in the Scenario name box.
5 Type a value for each changing cell in the Changing cells and their values boxes.
6 Click Add scenario.
7 Click Next.
8 Click Show scenario.
4 Type a name in the Scenario name box.
5 Type a value for each changing cell in the Changing cells and their values boxes.
6 Click Add scenario.
7 Click Next.
8 Click Show scenario.
To create a scenario group
1 Click Tools } Scenario } Edit.
2 Click Settings.
3 In the Scenario group settings dialog box, click New.
4 In the New group dialog box, type a name in the New group name box.
2 Click Settings.
3 In the Scenario group settings dialog box, click New.
4 In the New group dialog box, type a name in the New group name box.
To display a scenario
1 Click Tools } Scenario } Edit.
2 Choose a scenario group from the Scenario groups list box.
3 Choose a scenario from the Scenarios list.
2 Choose a scenario group from the Scenario groups list box.
3 Choose a scenario from the Scenarios list.
From here
For more information about...
In the online Help Index, type...
Managing scenarios
scenarios, managing
Creating one-variable What-If tables
What-If tables, one-variable
Creating two-variable What-If tables
What-If tables, two-variable
Using goal seeking
goal seeking
Finding optimum solutions for linear and
non-linear problems
Optimizer
Analyzing data
217