Totals

[Jerry]

I need a spreadsheet that will help keep track of my electrical usage. I
have made the following and I would like it to do 2 things: In the total
column, I would like it to automatically put in the numbers of the 5 dial
fields and then when I add a row every day, have it calculate the total KW
used starting from the first row of which would be zero. Can someone help?

Thanks,
Jerry
Dial 1 Dial 2 Dial 3 Dial 4 Dial 5 Total Date KW Used
0 0 0 0 0 0 1/11/2007 0
5 8 0 3 4 58034 1/12/2007 0:00 58034
6 5 7 3 5 65735 1/14/2005 0:00 7701

--

 

[Pete_UK]

If you have five individual dials, then the total reading would be as
follows:

=10000*A2 + 1000*B2 + 100*C2 + 10*D2 + E2

assuming the dial readings are in columns A to E and begin on row 2.
Copy this formula down as necessary.

As for kWh used, then if the first reading is zero the current total
will be the kWh used to date - is this what you mean?

Hope this helps.

Pete

 

[Pete_UK]

No, I think what you mean is the difference from the row above. In
that case, enter 0 in cell H2 and in H3 enter this formula:

=IF(G3=0,"",F3-F2)

and copy this down as far as you like - it will show a blank until you
enter a date in column G (which assumes that you have entered the five
dial readings also for that row).

You might like to amend my earlier formula in F2 to:

=IF(SUM(A2:E2)=0,"",10000*A2+1000*B2+100*C2+10*D2+E2)

and then copy that down column F as far as you like.

Hope this helps.

Pete

 

[Jerry]

This helps a lot. Thank you for the help.

Jerry

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete