O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required