Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes Monday through Friday.


hpr1525 :: 30 - LibreOffice Calc - A Savings Model

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

<< First, < Previous, Latest >>

Host Image
Hosted by Ahuka on Friday 2014-06-06 is flagged as Clean and is released under a CC-BY-SA license.
Tags: LibreOffice, Calc.

Listen in ogg, spx, or mp3 format. | Comments (0)

Part of the series: 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

Show Transcript

Automatically generated using whisper

whisper --model tiny --language en hpr1525.wav

<< First, < Previous, Latest >>


Comments

Subscribe to the comments RSS feed.

<< First, < Previous, Latest >>

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 P in HPR stand for ?
Are you a spammer →
Who hosted this show →
What does HPR mean to you ?