Meter reading calculator based on date

**bd528** · 07-17-2009, 03:24 AM

Hi,

Please see attached

As part of a project, I need to come up with a meter reading calculator. I start of with 3 base meter readings (A2, F2, K2), which would be read from the meter. 3 reads are needed in case the consumption changes dramatically at some point. I then need Excel to work out the reading for dates in between. The formula needs to be dynamic enough so that I can change any of the grey dates to what I want.
The estimates need to be calculated using an average daily consumption. This figure needs to be displayed in D9.
It would be preferable if macros weren't used. If its possible to explain what to do without an attachment, that would be good too.

Any help would be great.

Thanks.

**zbor** · 07-17-2009, 03:54 AM

Don't know did I understand well... But is this close

Book1(1).xls

**bd528** · 07-17-2009, 09:18 AM

Thanks for your efforts but this isnt quite right.

The use should only enter figures in cells A2 F2 K2. All the other cells in row 2 should be automatically populated.

So in my exmaple, excel needs to work out the average daily usage between 01/01/08 and 12/06/08, and then work out values for the dates in row A.

Any other ideas?

**daddylonglegs** · 07-17-2009, 09:37 AM

Originally Posted by bd528

As part of a project

What sort of project, is this a homework assignment?

You can calculate the average usage per day by dividing the amount used in a period by the number of days in that period

Once you have the average per day then for any date you can multiply that amount by the number of days passed since the start date....and add that to the reading as of the start date

**bd528** · 07-17-2009, 10:17 AM

Its for a work project.

I can work out the daily average, I just cant do the formula so that excel works out values for the dates I can change on row A.

**daddylonglegs** · 07-17-2009, 10:36 AM

You have one cell for average daily consumption but that will differ for dates before and after F1 because the average will be calculated using different start and end points

You can use this formula in B2 copied across to E2

=$A2+(B1-$A1)*($F2-$A2)/($F1-$A1)

You need to change the formula again for the cells G2:J2, see attached

**bd528** · 07-17-2009, 06:38 PM

Thank you. Thats exactly what I need.

Solved

**ashoke1773** · 07-16-2013, 04:16 AM

How i calculate the daily meter reading. I have only one meter and i want calculte the daliy usage. Pl guide me how i calculate the meter reading in the excel sheet with example...

**zbor** · 07-16-2013, 04:31 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.