Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at

hpr1515 :: 29 - LibreOffice Calc - Models and "What-If" Analysis

This episode looks at building models and doing "What-If?" Analysis.

<< First, < Previous, , Latest >>

Thumbnail of Ahuka
Hosted by Ahuka on 2014-05-23 is flagged as Clean and is released under a CC-BY-SA license.
LibreOffice, Calc. (Be the first).
The show is available on the Internet Archive at:

Listen in ogg, spx, or mp3 format. Play now:

Duration: 00:12:54


In this in-depth series on LibreOffice we examine Writer, Calc and Impress

The next topic is extremely important because it addresses where most beginning users of spreadsheets get into trouble. First, understand that building models and doing "What-If" analysis is fundamental to the success and widespread adoption of spreadsheets all over the world. A model can be thought of as a mathematical representation of a process of some kind. It could be financial, such as projecting my sales over the next year, or perhaps working out when my car loan will be paid off. Or it could be scientific, such as projecting out the reaction times and quantities in a chemical reaction. The only real requirement is that whatever you are modeling has to be something that can be represented using mathematical formulas of some kind.

"What-If" analysis takes this model and lets you experiment to see how how changes in different variables affect the results in your model. If I am figuring out when my car loan will be paid off, I might ask how paying an extra $20 per month against the principle would affect my results (presumably, it should lead to getting it paid off sooner if I set the model up correctly.) Or in the case of the chemical process, how would different temperatures or pressures affect the reaction times and quantities? By experimenting with different values in my model I can do this comparison easily. But only if I built the model properly in the first place.

For the remainder of the show notes please see


Subscribe to the comments RSS feed.

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Anti Spam Question: What does the letter P in HPR stand for?
Are you a spammer?
What is the HOST_ID for the host of this show?
What does HPR mean to you?