maximus315
New Member
- Joined
- Aug 2, 2011
- Messages
- 7
I need to quickly evaluate pump rates.
I have an output (pump gpm) that gets recorded to excel every minute in a new row. The pump turns on an off multiple times a day depending on build up. What I want is to know the number of occurrences a day that the pump turns on and the average gpm during these time frames (the pump on time for each event also varies) and sometimes there is blips at startup of an occurrence.
Occurrences were added in the table by hand in the example below.
<tbody>
</tbody>
I have an output (pump gpm) that gets recorded to excel every minute in a new row. The pump turns on an off multiple times a day depending on build up. What I want is to know the number of occurrences a day that the pump turns on and the average gpm during these time frames (the pump on time for each event also varies) and sometimes there is blips at startup of an occurrence.
Occurrences were added in the table by hand in the example below.
Data | ||||
occurrence | GPM | Desired output | ||
occurrence | average gpm | |||
1 | 175.3245 | 1 | 174.6 | |
1 | 175.6294 | 2 | 152.43 | |
1 | 173.9357 | 3 | ||
1 | 174.1177 | 4 | ||
1 | 174.2998 | 5 | ||
1 | 174.4818 | |||
1 | 174.6638 | |||
1 | 173.6071 | |||
1 | 174.2018 | |||
1 | 176.7737 | |||
1 | 174.1055 | |||
1 | 173.8339 | |||
1 | 175.6286 | |||
1 | 173.8325 | |||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
0 | ||||
2 | 24.56381 | |||
0 | ||||
2 | 1.924029 | |||
0 | ||||
0 | ||||
2 | 14.86348 | |||
2 | 1.62 | |||
2 | 3.057903 | |||
2 | 3.343711 | |||
2 | 14.5067 | |||
2 | 12.77087 | |||
2 | 3.227844 | |||
2 | 114.8468 | |||
2 | 197.5547 | |||
2 | 244.9118 | |||
2 | 266.7711 | |||
2 | 274.3633 | |||
2 | 283.6748 | |||
2 | 285.0492 | |||
2 | 296.478 | |||
2 | 313.9584 | |||
2 | 338.4923 | |||
2 | 352.7092 |
<tbody>
</tbody>