# Meter reading calculator based on date

1. ## Meter reading calculator based on date

Hi,

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.  Register To Reply

2. ## Re: Meter reading calculator based on date

Don't know did I understand well... But is this close Book1(1).xls  Register To Reply

3. ## Re: Meter reading calculator based on date

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?  Register To Reply

4. ## Re: Meter reading calculator based on date 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  Register To Reply

5. ## Re: Meter reading calculator based on date

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.  Register To Reply

6. ## Re: Meter reading calculator based on date

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  Register To Reply

7. ## Re: Meter reading calculator based on date

Thank you. Thats exactly what I need.

Solved  Register To Reply

8. ## Re: Meter reading calculator based on date

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...  Register To Reply

9. ## Re: Meter reading calculator based on date

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.

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.  Register To Reply