Creating Scenarios
Another predictive analysis tool that Calc provides is the scenario. Scenarios can be used to create different “what if” situations, where each scenario manipulates one or more values in the spreadsheet. Scenarios are great for comparing a best case and worst case set of values and how they affect the overall outcome.
For example, let's say that you are selling your house and that you have a situation where the actual sale price can fluctuate depending on market conditions. And let's also say that you've talked to different real estate brokers and that there is a range of brokerage fees that you can choose from.
You can put your baseline data in a spreadsheet and then create different scenarios that allow you to see the effect ...
Get StarOffice™ 5.2 Calc Handbook 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.
