Tag Archives: MSOffice

Using spreadsheets for home economics.

I love spreadsheets.  With a few formulas you can calculate your budget, right down to the earth’s gravitational field.

They can also help you calculate the TOC of an operation, in realtime, and make more accurate analysis when doing logistics.

This is especially useful when you’re moving to another city. Especially if you’re someone who travels light, is a practitioner of simple living and just want to know just how much you have and how that will affect your personal economy.

Well for me, since I am currently moving to another city, I wanted to know how much moving in my new  place would cost.

So I did a new workbook and divided it into three sections. The first is belongings, the second is groceries and installation fees and the last is “Grand total”.

In the “belongings” sheet I put the item name, the quantity and the Cost and if I had already acquired it or not. In “groceries” I had put the same.

The two, I linked their totals to the Grand total sheet, that way each time I changed a value on either of the pages, I would be able to quickly know how much money it had cost .

While simplistic, this can help one to be organized and really help you erase the stress of moving, or at the very least see how much this is costing you and what adjustments you will need to make financially.

The very same can be applied to all kinds of home economic projects, I will include these links to other useful excel workbook templates;

http://christianpf.com/10-free-household-budget-spreadsheets/

http://exceltemplates.net/

http://www.spreadsheetzone.com/

And for the libre-office/Open-office calc fans

http://templates.libreoffice.org/template-center

http://www.kaaredyret.dk/openoffice_links.html

Tagged , , , , , , , ,