Hi,

I have a spreadsheet of meter readings for household utility usage
(gas, electricity and water). The readings have been taken at
irregular dates, which makes analysing the data hard. For example, it
would be great to be able to work out how much electricty got used in
the month of February 2009, and perhaps to compare that to how much
got used in February 2008 and 2007. However, I will not have taken
readings at 1st Feb and then on 1st March on any of those years. The
readings are taken pretty much when I remember to check.

So I have a worksheet with
- the date I took the readings in column A
- the gas meter reading in column B
- the electricty meter reading in column C

What I would like to do is to have a second worksheet where these
figures get tidied up. Column A would have dates starting on 1st
January and incrementing by a month in each row (1st Feb, 1st March,
etc). Then in column B I would need to use the data points which I do
have to estimate (based on daily usage over that period) what the gas
meter reading would have been on 1st Jan, 1st Feb etc. (Ditto in
column C for electricity.)

Is this actually doable using Excel functions, or do I need visual
basic?

If it's any help here is the spreadsheet:
http://www.filefactory.com/file/agab...lity_usage_xls

Thank you

--
Remember Dr Folkman