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


hpr1525 :: 30 - LibreOffice Calc - A Savings Model

LibreOffice, Calc, Spreadsheet, models, what-if analysis, savings

<< First, < Previous, , Latest >>

Thumbnail of Ahuka
Hosted by Ahuka on 2014-06-06 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: https://archive.org/details/hpr1525

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

Duration: 00:20:52

LibreOffice.

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

In the previous tutorial we discussed the fundamental ideas of building models and doing “What-If?” analysis. Now we need to take these ideas and put them into practice so you can see how this works. To do this I will create a simple model of savings over time. Now, I do want to be clear that this is a very over-simplified model and should not be taken as a good predictor of actual results. The idea is to illustrate the techniques involved in building a model and doing “What-If?” analysis.

So. what are the variables, parameters, assumptions, etc. that we need? I have identified these in my model:

  • An initial amount of money already saved. This is the starting amount you have.
  • An amount of money you add to your savings each year.
  • The rate of return on your savings

For the remainder of the show notes please see https://www.ahuka.com/?page_id=761

A copy of the spreadsheet created for this program can be found at https://www.ahuka.com/?attachment_id=763


Comments

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:
Title:
Comment:
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?