Free Energy Tracker Spreadsheet - See what each appliance costs you

Admin

— 1 min read
Share
Free Energy Tracker Spreadsheet - See what each appliance costs you
Energy Tracker Spreadsheet

I built this because my own bill was a bit of a mystery.

This simple tracker shows you approximately how much each appliance in your house is costing you per day/month/year.

Just enter:

  • Your appliance name (Kettle, Lounge TV, Lounge Lights etc.)
  • Watts (the rated Watts for the device) - or your own real world measurement. I'll show a couple of simple ways to do that in a future post
  • Hours used per day

It automatically calculates your daily, monthly and yearly cost for each appliance based on the rate you are currently paying, which you enter at the top of the spreadsheet. The rate defaults to 24.5p per kWh.

I found going through this process a valuable exercise in itself. What it did is provide me with a bit more knowledge regarding what things were costing. This allowed me to start to make more informed decisions and gradually I was able to claw back an element of control. Perfect if you want to assess what things are costing with a view to cutting your bill without guessing. As the saying goes - "Knowledge is power". Quite literally in this case.

Read more