Microsoft Office Tutorials and References
In Depth Information
Creating scenario reports
Figure 18-14 The merged scenarios are now available on the same worksheet.
Each group of scenarios provided by the coworkers uses different changing cells. Vicki’s
scenarios change the values in cells D2, D3, and D5; Max’s scenarios change only the value
in E8; and Regina’s scenarios change only the value in E11. You can display these different
scenarios together and watch how the combinations affect the bottom line.
Creating scenario reports
The Revenue Scenarios workbook with its merged scenarios has become a somewhat
complex what-if model. However, you can create models that are far more complex, using
as many scenarios as you want (or as many as your computer can handle) and up to 32
variables per scenario. The Scenario Manager summary reports help you keep track of the
possibilities, and PivotTable reports give you additional what-if functionality by allowing
you to manipulate the elements of the report. However, although you can create as many
scenarios as you like, the Scenario Summary report displays only the first 251 of them.
Clicking Summary in the Scenario Manager dialog box displays the dialog box shown in
Figure 18-15. Use it to create reports that show the values that each scenario assigns to
each changing cell.
At the bottom of the dialog box, you identify result cells that you want to appear in the
report, separated by commas. You want cells that are dependent on the most changing
cells—in this case, the Operating Profit value in cell E16, as well as cell E6, the yearly Gross
Profit value.
Search JabSto ::




Custom Search