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 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 you can type 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 ...
Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
