Using the Scenario Manager

To model more complicated problems than data tables can handle, involving as many as 32 variables, you can call on the services of the Scenario Manager by choosing Tools, Scenarios. 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 enter variable figures and watch the effect on dependent computed values. The Scenario Manager records, tracks, and applies combinations of variable values.

We'll use the Scenario Manager to model the effects of changing values in D2:D3, D5, and E8:E13 of this worksheet.

Figure 18-8. We'll use the Scenario Manager to model the effects of changing values in D2:D3, D5, and E8:E13 of this ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.