• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Performing What-If Analysis > Using the Scenario Manager

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.

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 worksheet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint