Creating scenarios
Quattro Pro lets you create scenarios, scenario groups, or display scenarios. A scenario is a snapshot of a data model which is a set of formulas designed to simulate real-life situations and conditions. Scenarios show changing data 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 data.
To create a scenario |  |
|
1.
|
|
Click Tools
 Scenario New. |
|
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.
|
|
9.
|
|
Click Next.
|
|
•
|
|
By default, changing cells are yellow; result cells are green.
|
|
•
|
|
You can click Create report to see a Scenario Summary Report.
|
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.
|
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.
|
|
•
|
|
When you display a scenario, its changing cell and result cell values replace those currently on the screen.
|