Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to measure my power consumption. So once in a month I note my meter reading.

So I got the following data:

2012-12-01| 893.8|  |    |31
2013-01-05| 977.2|34|2.45|31


  1. Date of reading
  2. kWh
  3. days in between readings
  4. delta since last reading
  5. number of days of reading month.

So I would like to compute the average over a month. Any Ideas how to do that?

share|improve this question
Just multiply the average mount you used per day (column 4) by 30 days. – mhoran_psprep May 3 '13 at 21:08

The formula I would use (assuming this started in column A) would be this:


This will find the change in kWh since the last reading, divide it by the number of days in the reading (to get the daily average) then multiply it by the number of days in that month.

Since you have already calculated the daily average (in column 4) you could just do


and you would get the same results. If you were trying to find a general month average (not tied to specific days in each month) you could just take column 4 * 30 (=D2*30).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.