Spreadsheet: 751547d1634163928-count-continuous-instances-and-get-max-value-from-corresponding-column-sample2_new
Sheet: Sheet1

No. of Days | Flow | Flow Cat | Flow category | Date | helper |  | Date | Description | FORMULAs | Check | Variable
 | 904 | 1 | low | 2015-10-18 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_No. of pulses_15 Days |  | 2 | No. of Low Pulses
 | 872 | 1 | low | 2015-10-19 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_Duration of total pulses_15 Days |  | 13 | Low-Count
 | 888 | 1 | low | 2015-10-20 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_Max peak discharge pulse_15 Days |  | 1900 | Low-maxQtyForLow
 | 904 | 1 | low | 2015-10-21 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_Duration of [NAME] continuous pulse_15 Days |  | 10 | Low-continuous count
 | 833 | 1 | low | 2015-10-22 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_Max peak discharge in continuous pulse_15 Days |  | 993 | Low-maxQtyForContinuousCount
 | 818 | 1 | low | 2015-10-23 00:00:00
 | 810 | 1 | low | 2015-10-24 00:00:00 |  |  | 2015-12-03 00:00:00 | Low Peak_No. of pulses _30 Days |  | 3
 | 787 | 1 | low | 2015-10-25 00:00:00 |  |  | 2015-12-03 00:00:00 | Low Peak_Duration of total pulses_30 Days |  | 23
 | 780 | 1 | low | 2015-10-26 00:00:00 |  |  | 2015-12-03 00:00:00 | Low Peak_Max peak discharge pulse_30 Days |  | 2060
 | 757 | 1 | low | 2015-10-27 00:00:00 |  |  | 2015-12-03 00:00:00 | Low Peak_Duration of [NAME] continuous pulse_30 Days |  | 10
 | 735 | 1 | low | 2015-10-28 00:00:00 |  |  | 2015-12-03 00:00:00 | Low Peak_Max peak discharge in continuous pulse_30 Days |  | 993
 | 735 | 2 | low | 2015-10-29 00:00:00
 | 735 | 4 | low | 2015-10-30 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_AVERAGE peak discharge pulse_15 Days
 | 61600 | 4 | large | 2015-10-31 00:00:00 |  |  | 2015-12-03 00:00:00 | Low_AVERAGE peak discharge in continuous pulse_15 Days
 | 57700 | 4 | large | 2015-11-01 00:00:00
 | 10700 | 4 | large | 2015-11-02 00:00:00
1 | 4070 | 4 | large | 2015-11-03 00:00:00
2 | 2640 | 4 | large | 2015-11-04 00:00:00
3 | 2220 | 4 | large | 2015-11-05 00:00:00
4 | 2260 | 4 | large | 2015-11-06 00:00:00
5 | 2040 | 3 | low | 2015-11-07 00:00:00
6 | 2060 | 1 | low | 2015-11-08 00:00:00
7 | 1930 | 1 | low | 2015-11-09 00:00:00
8 | 1330 | 1 | low | 2015-11-10 00:00:00
9 | 1150 | 1 | low | 2015-11-11 00:00:00
10 | 1020 | 1 | low | 2015-11-12 00:00:00
11 | 936 | 1 | low | 2015-11-13 00:00:00
12 | 841 | 1 | low | 2015-11-14 00:00:00
13 | 772 | 1 | low | 2015-11-15 00:00:00
14 | 735 | 2 | low | 2015-11-16 00:00:00
15 | 904 | 1 | low | 2015-11-17 00:00:00
16 | 1900 | 1 | low | 2015-11-18 00:00:00
17 | 1550 | 1 | low | 2015-11-19 00:00:00
18 | 888 | 1 | low flow | 2015-11-20 00:00:00
19 | 765 | 3 | low flow | 2015-11-21 00:00:00
20 | 678 | 3 | low flow | 2015-11-22 00:00:00
21 | 629 | 1 | low flow | 2015-11-23 00:00:00
22 | 602 | 1 | low flow | 2015-11-24 00:00:00
23 | 589 | 1 | low flow | 2015-11-25 00:00:00
24 | 582 | 1 | low flow | 2015-11-26 00:00:00
25 | 609 | 1 | low flow | 2015-11-27 00:00:00
26 | 936 | 1 | low flow | 2015-11-28 00:00:00
27 | 993 | 1 | low flow | 2015-11-29 00:00:00
28 | 888 | 1 | low flow | 2015-11-30 00:00:00
29 | 864 | 1 | low flow | 2015-12-01 00:00:00
30 | 750 | 1 | low flow | 2015-12-02 00:00:00
 | 720 | 1 | low flow | 2015-12-03 00:00:00
 | 692 | 1 | low flow | 2015-12-04 00:00:00
 | 685 | 1 | low flow | 2015-12-05 00:00:00
 | 622 | 1 | low flow | 2015-12-06 00:00:00
 | 629 | 1 | low flow | 2015-12-07 00:00:00
 | 615 | 1 | low flow | 2015-12-08 00:00:00
 | 595 | 1 | low flow | 2015-12-09 00:00:00
 | 615 | 1 | low flow | 2015-12-10 00:00:00
 | 615 | 1 | low flow | 2015-12-11 00:00:00
 | 636 | 1 | low flow | 2015-12-12 00:00:00
 | 4550 | 2 | high flow pulse | 2015-12-13 00:00:00
 | 5660 | 2 | high flow pulse | 2015-12-14 00:00:00
 | 2500 | 2 | high flow pulse | 2015-12-15 00:00:00
 | 1350 | 1 | low flow | 2015-12-16 00:00:00
 | 952 | 1 | low flow | 2015-12-17 00:00:00
 | 825 | 1 | low flow | 2015-12-18 00:00:00
 | 750 | 1 | low flow | 2015-12-19 00:00:00
 | 706 | 1 | low flow | 2015-12-20 00:00:00
 | 664 | 1 | low flow | 2015-12-21 00:00:00
 | 657 | 1 | low flow | 2015-12-22 00:00:00