Daily water meter readings

[Guest]

Download data from a controller in to a CSV file. Want to subtract the first
reading on a day from the last reading of a given day to get tptal daily
water usage. The file contains 90 days of data so am looking for a way to
automate.

Thanks

 

[ExcelGirl]

Hi Jon,

If your source data is one row for each reading like: date, reading #1
(or #2 or...), water volume value, read it into Excel so it maintains
that 3 column format with one row for each reading.

Then try using a pivot table to set the dates across the top on
columns, and the reading numbers down the side on rows and the water
volumn value as the data.

Then add a row below the table where you subtract the first reading row
from the last reading row.

I'm not sure how to automate this without using VBA, but perhaps this
is close enough?

ExcelGirl