Spreadsheet for electricity meter readings/useage

jools002

Just wondering if there is a spreadsheet anywhere for putting meter readings into to calculate electricity useage please?

d12345

It is very easy to do one yourself


Column for date, present reading, previous reading, subtract previous from present give units used, multiply by tariff plus standing charge for how many days gives cost.


Gas will have to be converted to kWhs see bill for conversion or look it up on the internet.


So simple even a 68 year old OAP can do it.

Nada666

You can use an online service like imeasure.org.uk (although it is hideously over-featured with repetition and unnecessary nonsense).

It is probably easiest to just write a quick one yourself - it should not take more than five minutes.

A simple table like this:

Date Reading Units #days  per day  per month per year since start
  1 Feb 10300
  10 Feb 10370  70    9      7.8      233      2796      £419

First row just enter the first two figures (date and reading)
Second row - # days is from this row's date - previous row's date
units used is again this row - previous row reading
units used per day or month or year is then units used / days multiplied by 30 or 365 (this gives consumption pro rata'd at used for this reading).

All this are simple relative links - no '$' needed.

Then you can calculate total average from very first reading - this time you will need to $$ the cells in the first row with the start date and start read.

Finally you can stick a 0.15 somewhere (price per unit) and $$ it to include a cost in pounds.

There are more complicated spreadsheets out there - but most of them seem to be for comparing different tariffs rather than monitoring useage. Most of them are unnecessary and a waste of time.

Just start with a simple table and see if that suffices.

saveallmymoney

If you have a smartphone there will be an app for that.

I find it really handy as i can enter the readings as i wander around outside and look at the meters.

The one i use (just called 'meter readings') will also compare your usage to previous time periods, cope with water, gas, electricity or more and you can see if you are on target for the current month if you take a reading a week or two in.

d12345

I just found an app in the windows 8.1 store that calculates electricity costs, you enter the consumption, cost and hours and it tells you how much it costs to run.

macman

Since one electricity meter unit is one kWh, and so is the same as one billing unit, no conversion is needed.