Hello-
Newbie here. I am generating data from a small water supply meter every minute and want to get statistics from the data. There are 1440 lines every day and I would like to get a summary report for a month.
Ideally I would like Daily statistics. Like Min, Max and Average for each day. perhaps even Total flow for a day (this is a SUM for that day of the flow readings). What functions should I be looking at to generate this. Any assistance would be great.
<tbody>
</tbody>
Newbie here. I am generating data from a small water supply meter every minute and want to get statistics from the data. There are 1440 lines every day and I would like to get a summary report for a month.
Ideally I would like Daily statistics. Like Min, Max and Average for each day. perhaps even Total flow for a day (this is a SUM for that day of the flow readings). What functions should I be looking at to generate this. Any assistance would be great.
Time Stamp | Flow GPM | pH | Temperature |
6/1/2014 0:00 | 8 | 7.6 | 74.1 |
6/1/2014 0:01 | 7 | 7.6 | 74.1 |
6/1/2014 0:02 | 9 | 7.6 | 74.1 |
6/1/2014 0:03 | 8 | 7.6 | 74.1 |
6/1/2014 0:04 | 6 | 7.6 | 74.1 |
6/1/2014 0:05 | 4 | 7.6 | 74.1 |
6/1/2014 0:06 | 9 | 7.6 | 74.1 |
6/1/2014 0:07 | 4 | 7.6 | 74.1 |
6/1/2014 0:08 | 9 | 7.6 | 74.1 |
6/1/2014 0:09 | 9 | 7.6 | 74.1 |
6/1/2014 0:10 | 6 | 7.6 | 74.1 |
6/1/2014 0:11 | 5 | 7.6 | 74.1 |
<tbody>
</tbody>