Spreadsheet: 219119d1362670754-counting-number-and-duration-of-non-continuous-events-query
Sheet: Sheet1

date | flow | compliance
1990-01-01 00:00:00 | 2.533028479999995 | 0
1990-01-02 00:00:00 | 1.341600000000003 | 0 |  | Jan- July | Jan- March | March
1990-01-03 00:00:00 | 0.8664847999999985 | 0 | # non compliance events
1990-01-04 00:00:00 | 1.58556608 | 0 | average length of event
1990-01-05 00:00:00 | 1.758366080000002 | 0 | [NAME] duration of non compliance
1990-01-06 00:00:00 | 3.458463359999996 | 0
1990-01-07 00:00:00 | 3.052036479999998 | 0
1990-01-08 00:00:00 | 0.2869439999999983 | 0
1990-01-09 00:00:00 | 0.6263231999999981 | 0
1990-01-10 00:00:00 | 1.121222400000001 | 0
1990-01-11 00:00:00 | 0.6892223999999985 | 0
1990-01-12 00:00:00 | 1.946400000000004 | 0
1990-01-13 00:00:00 | 1.295231999999999 | 0
1990-01-14 00:00:00 | 1.295231999999999 | 0
1990-01-15 00:00:00 | 1.157600000000006 | 0
1990-01-16 00:00:00 | 2.200116479999998 | 0
1990-01-17 00:00:00 | 1.727231999999997 | 0
1990-01-18 00:00:00 | 1.773600000000005 | 0
1990-01-19 00:00:00 | 1.773600000000005 | 0
1990-01-20 00:00:00 | 1.428000000000004 | 0
1990-01-21 00:00:00 | 1.341600000000003 | 0
1990-01-22 00:00:00 | 1.773600000000005 | 0
1990-01-23 00:00:00 | 5.701631999999996 | 0
1990-01-24 00:00:00 | -1.002399999999998 | 1
1990-01-25 00:00:00 | 3.397344 | 0
1990-01-26 00:00:00 | -0.1450560000000003 | 1
1990-01-27 00:00:00 | 1.508916479999996 | 0
1990-01-28 00:00:00 | -0.8362560000000023 | 1
1990-01-29 00:00:00 | 1.058323199999997 | 0
1990-01-30 00:00:00 | 2.440723200000001 | 0
1990-01-31 00:00:00 | 3.576800000000002 | 0
1990-02-01 00:00:00 | 5.298144000000001 | 0
1990-02-02 00:00:00 | 7.810399999999998 | 0
1990-02-03 00:00:00 | 83.75767609600001 | 0
1990-02-04 00:00:00 | -31.19761375999998 | 1
1990-02-05 00:00:00 | -14.49768089599999 | 1
1990-02-06 00:00:00 | -5.976138752000004 | 1
1990-02-07 00:00:00 | -5.803338752000002 | 1
1990-02-08 00:00:00 | -13.198943744 | 1
1990-02-09 00:00:00 | -2.230607167999999 | 1
1990-02-10 00:00:00 | -1.895600000000002 | 1
1990-02-11 00:00:00 | 2.235349120000002 | 0
1990-02-12 00:00:00 | 3.012949120000002 | 0
1990-02-13 00:00:00 | 2.494549120000002 | 0
1990-02-14 00:00:00 | 1.551689344000003 | 0
1990-02-15 00:00:00 | -2.433738752000004 | 1
1990-02-16 00:00:00 | 0.8797928319999997 | 0
1990-02-17 00:00:00 | -1.636400000000002 | 1
1990-02-18 00:00:00 | -1.075326080000004 | 1
1990-02-19 00:00:00 | 0.1617491199999961 | 0
1990-02-20 00:00:00 | 1.151236479999998 | 0
1990-02-21 00:00:00 | 1.756036479999999 | 0
1990-02-22 00:00:00 | 1.543708480000003 | 0
1990-02-23 00:00:00 | 2.8856 | 0
1990-02-24 00:00:00 | 2.8856 | 0
1990-02-25 00:00:00 | 3.404 | 0
1990-02-26 00:00:00 | 5.431708480000005 | 0
1990-02-27 00:00:00 | 4.567708480000007 | 0
1990-02-28 00:00:00 | 7.810399999999998 | 0
1990-03-01 00:00:00 | 4.348036480000005 | 0
1990-03-02 00:00:00 | -1.549999999999997 | 1
1990-03-03 00:00:00 | 0.5073491199999971 | 0
1990-03-04 00:00:00 | 3.231200000000001 | 0
1990-03-05 00:00:00 | 3.058400000000002 | 0
1990-03-06 00:00:00 | 2.6264 | 0
1990-03-07 00:00:00 | 2.618111039999995 | 0
1990-03-08 00:00:00 | 2.358911039999995 | 0
1990-03-09 00:00:00 | 2.55001056 | 0
1990-03-10 00:00:00 | 2.290810560000001 | 0
1990-03-11 00:00:00 | 2.792544000000003 | 0
1990-03-12 00:00:00 | 2.965344000000002 | 0
1990-03-13 00:00:00 | 2.965344000000002 | 0
1990-03-14 00:00:00 | 3.224544000000002 | 0
1990-03-15 00:00:00 | 3.248364479999996 | 0
1990-03-16 00:00:00 | 3.975515519999998 | 0
1990-03-17 00:00:00 | 3.629915519999997 | 0
1990-03-18 00:00:00 | 3.841716479999999 | 0
1990-03-19 00:00:00 | 17.24516448 | 0
1990-03-20 00:00:00 | 6.382108480000007 | 0
1990-03-21 00:00:00 | 4.778111039999999 | 0
1990-03-22 00:00:00 | 4.717164479999994 | 0
1990-03-23 00:00:00 | 6.174516479999998 | 0
1990-03-24 00:00:00 | 5.656116479999994 | 0
1990-03-25 00:00:00 | 4.964916479999999 | 0
1990-03-26 00:00:00 | 5.378323200000001 | 0
1990-03-27 00:00:00 | 6.050463359999998 | 0
1990-03-28 00:00:00 | 5.8732224 | 0
1990-03-29 00:00:00 | 5.960831999999996 | 0
1990-03-30 00:00:00 | 5.615231999999999 | 0
1990-03-31 00:00:00 | 5.887340159999997 | 0
1990-04-01 00:00:00 | 6.007200000000005 | 0
1990-04-02 00:00:00 | 10.453632 | 0
1990-04-03 00:00:00 | 4.088543999999999 | 0
1990-04-04 00:00:00 | 4.859923200000001 | 0
1990-04-05 00:00:00 | 5.442431999999997 | 0
1990-04-06 00:00:00 | 5.748000000000005 | 0
1990-04-07 00:00:00 | 5.143200000000004 | 0
1990-04-08 00:00:00 | 4.884000000000004 | 0
1990-04-09 00:00:00 | 5.143200000000004 | 0
1990-04-10 00:00:00 | 5.056800000000003 | 0
1990-04-11 00:00:00 | 5.488800000000005 | 0
1990-04-12 00:00:00 | 3.372084799999996 | 0
1990-04-13 00:00:00 | 4.365600000000004 | 0
1990-04-14 00:00:00 | 2.849222399999999 | 0
1990-04-15 00:00:00 | 4.020000000000003 | 0
1990-04-16 00:00:00 | 4.020000000000003 | 0
1990-04-17 00:00:00 | 8.772000000000002 | 0
1990-04-18 00:00:00 | 8.253600000000002 | 0
1990-04-19 00:00:00 | 7.476000000000006 | 0
1990-04-20 00:00:00 | 6.439200000000003 | 0
1990-04-21 00:00:00 | 5.834400000000002 | 0
1990-04-22 00:00:00 | 5.2728848 | 0
1990-04-23 00:00:00 | 6.26278688 | 0
1990-04-24 00:00:00 | 6.680228479999997 | 0
1990-04-25 00:00:00 | 5.682930559999996 | 0
1990-04-26 00:00:00 | 5.250930559999997 | 0
1990-04-27 00:00:00 | 4.520228479999993 | 0
1990-04-28 00:00:00 | 4.699387519999998 | 0
1990-04-29 00:00:00 | 4.726465280000003 | 0
1990-04-30 00:00:00 | 5.352174079999994 | 0
1990-05-01 00:00:00 | 5.648310079999995 | 0
1990-05-02 00:00:00 | 4.69791008 | 0
1990-05-03 00:00:00 | 5.343724160000001 | 0
1990-05-04 00:00:00 | 4.930464319999999 | 0
1990-05-05 00:00:00 | 4.546000000000003 | 0
1990-05-06 00:00:00 | 4.200400000000002 | 0
1990-05-07 00:00:00 | 4.0276 | 0
1990-05-08 00:00:00 | 4.114000000000001 | 0
1990-05-09 00:00:00 | 2.817999999999998 | 0
1990-05-10 00:00:00 | 7.742799999999999 | 0
1990-05-11 00:00:00 | 5.964084799999998 | 0
1990-05-12 00:00:00 | 2.949740159999994 | 0
1990-05-13 00:00:00 | 3.224228479999997 | 0
1990-05-14 00:00:00 | 4.652524159999999 | 0
1990-05-15 00:00:00 | 4.805200000000003 | 0
1990-05-16 00:00:00 | 4.718800000000002 | 0
1990-05-17 00:00:00 | 4.373200000000001 | 0
1990-05-18 00:00:00 | 3.614109760000002 | 0
1990-05-19 00:00:00 | 3.760955199999998 | 0
1990-05-20 00:00:00 | 3.555184960000002 | 0
1990-05-21 00:00:00 | 3.404218239999999 | 0
1990-05-22 00:00:00 | 3.231418239999996 | 0
1990-05-23 00:00:00 | 3.105205120000001 | 0
1990-05-24 00:00:00 | 3.071103039999997 | 0
1990-05-25 00:00:00 | 2.567278720000004 | 0
1990-05-26 00:00:00 | 1.789678720000001 | 0
1990-05-27 00:00:00 | 1.384592319999996 | 0
1990-05-28 00:00:00 | 1.308482559999998 | 0
1990-05-29 00:00:00 | 1.22208256 | 0
1990-05-30 00:00:00 | 2.18652256 | 0
1990-05-31 00:00:00 | 1.672494399999998 | 0
1990-06-01 00:00:00 | 1.913282559999999 | 0
1990-06-02 00:00:00 | -0.03320000000000078 | 1
1990-06-03 00:00:00 | 0.8986182399999976 | 0
1990-06-04 00:00:00 | 0.1581097599999985 | 0
1990-06-05 00:00:00 | 1.098478720000003 | 0
1990-06-06 00:00:00 | 0.8392787200000029 | 0
1990-06-07 00:00:00 | 1.322522559999999 | 0
1990-06-08 00:00:00 | 1.826882559999998 | 0
1990-06-09 00:00:00 | -0.2134448000000013 | 1
1990-06-10 00:00:00 | 0.7528787200000018 | 0
1990-06-11 00:00:00 | 1.499694399999999 | 0
1990-06-12 00:00:00 | 1.499694399999999 | 0
1990-06-13 00:00:00 | 1.503418239999995 | 0
1990-06-14 00:00:00 | 1.826381439999999 | 0
1990-06-15 00:00:00 | 1.9662112 | 0
1990-06-16 00:00:00 | 1.442990080000001 | 0
1990-06-17 00:00:00 | 1.168324479999999 | 0
1990-06-18 00:00:00 | 1.341124480000001 | 0
1990-06-19 00:00:00 | 1.14996448 | 0
1990-06-20 00:00:00 | 0.8531027199999954 | 0
1990-06-21 00:00:00 | 1.788590079999999 | 0
1990-06-22 00:00:00 | -1.520581760000002 | 1
1990-06-23 00:00:00 | -0.9238774400000018 | 1
1990-06-24 00:00:00 | -1.553007680000004 | 1
1990-06-25 00:00:00 | -0.08811296000000013 | 1
1990-06-26 00:00:00 | 0.5451644800000004 | 0
1990-06-27 00:00:00 | 0.3157983999999967 | 0
1990-06-28 00:00:00 | 0.1197308800000005 | 0
1990-06-29 00:00:00 | 0.04240000000000066 | 0
1990-06-30 00:00:00 | -0.5292972800000033 | 1
1990-07-01 00:00:00 | -1.437905600000002 | 1
1990-07-02 00:00:00 | -2.047077439999999 | 1
1990-07-03 00:00:00 | -1.32180992 | 1
1990-07-04 00:00:00 | -0.05963551999999872 | 1
1990-07-05 00:00:00 | -1.801917440000002 | 1
1990-07-06 00:00:00 | -2.14751744 | 1
1990-07-07 00:00:00 | -1.87427744 | 1
1990-07-08 00:00:00 | -1.23540992 | 1
1990-07-09 00:00:00 | -0.5714691199999997 | 1
1990-07-10 00:00:00 | -0.3895999999999997 | 1
1990-07-11 00:00:00 | -0.3895999999999997 | 1
1990-07-12 00:00:00 | -0.8216000000000001 | 1
1990-07-13 00:00:00 | -1.167199999999999 | 1
1990-07-14 00:00:00 | -1.858400000000001 | 1
1990-07-15 00:00:00 | -2.5496 | 1
1990-07-16 00:00:00 | -2.8088 | 1
1990-07-17 00:00:00 | -2.722399999999999 | 1
1990-07-18 00:00:00 | -3.413600000000001 | 1
1990-07-19 00:00:00 | -2.8088 | 1
1990-07-20 00:00:00 | -4.363999999999999 | 1
1990-07-21 00:00:00 | -4.7096 | 1
1990-07-22 00:00:00 | -4.855492160000004 | 1
1990-07-23 00:00:00 | -4.096356703999998 | 1
1990-07-24 00:00:00 | -4.355556703999998 | 1
1990-07-25 00:00:00 | -4.186445983999999 | 1
1990-07-26 00:00:00 | -4.186445983999999 | 1
1990-07-27 00:00:00 | -4.708227679999998 | 1
1990-07-28 00:00:00 | -4.96742768 | 1
1990-07-29 00:00:00 | -5.053827679999998 | 1
1990-07-30 00:00:00 | -4.545465631999997 | 1
1990-07-31 00:00:00 | -4.372665631999999 | 1