Very good idea. I recorded the states of the electric, water and gas meters every day between 2000-2006, when still living in my Grandma's house. Unfortunately, after moving out she didn't continue.
After moving in with my Wife, I started recording the electric meter, now I have one year of data. The gas meter is in box out in the street, and only recently have I found a way to open it. One day I'd like to ask Dad-in-law where the bi-monthly gas bills from the previous years are stowed, this should give me an idea as to how much gas is needed for winter and summer. The water meter is in the basement, not too easy to get to, so I only check it every 10-15 days for the last half year.
When still at Grandma's, with 5 years of data, I entered everything into a spreadsheet, for every month I had total, average per day, max day and min day values. Those 4 were input into a month by month spreadsheet, calculated the multiyear average for each month, comparing each month's total to the multiyear average, etc.
|