Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Daily water meter readings
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 -- Jon Berenson |
#2
|
|||
|
|||
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 -- ExcelGirl ------------------------------------------------------------------------ ExcelGirl's Profile: http://www.excelforum.com/member.php...o&userid=25272 View this thread: http://www.excelforum.com/showthread...hreadid=387635 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting daily changes | Excel Worksheet Functions | |||
How can we use Excel to calculate interest with daily compounding | Excel Discussion (Misc queries) | |||
Chart to monitor Blood Pressure readings and date | Charts and Charting in Excel | |||
Why won't it Excel fill in weekly dates now, changes them to daily | Excel Worksheet Functions | |||
How do I protect cell formulas used for daily counts? | Excel Worksheet Functions |