Microsoft Office Tutorials and References
In Depth Information
Using the Scenario Manager
Figure 18-7 Copying the results of the TABLE function to another part of the worksheet transfers
the numeric values, not the formulas used to compute them, as shown on the Data Table5 tab of
the Goal Seek.xlsx workbook.
Using the Scenario Manager
To model more complicated problems than data tables can handle—those involving as
many as 32 variables—you can call on the services of the Scenario Manager by clicking the
What-If Analysis button in the Data Tools group on the Data tab and then clicking Scenario
Manager. A scenario is a named combination of values assigned to one or more variable
cells in a what-if model. The worksheet in Figure 18-8 is a what-if model set up so that you
can type variable figures and watch the effect on dependent computed values. The
Scenario Manager records, tracks, and applies combinations of variable values.
You can find the Revenue Scenarios.xlsm file with the other examples on the companion
website.
Here are some of the tasks you can do with the Scenario Manager:
Create multiple scenarios for a single what-if model, each with its own sets of
variables. You can create as many scenarios as your model requires.
Distribute a what-if model to other members of your group so that they can add
their own scenarios. Then you can collect the multiple versions and merge the
scenarios into a single worksheet.
Search JabSto ::




Custom Search