{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Meta data_sheet","Meta data_lookup","Raw data_sheet","Raw data_format","24hr_PM10_chart","24hr_PM2.5_chart"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"24hr_PM10_chart","index":5,"reason":"not_a_worksheet"},{"sheet":"24hr_PM2.5_chart","index":6,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Meta data_sheet","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[18,0,18,1],[16,0,16,1]]}
["Ambient Monitoring Station","Details",null,"Ambient Monitoring Results","Details"]
["Location","Breeza",null,"PM2.5 monitoring start (dd/mm/yyyy hh:mm)","2019-01-01"]
["Easting",{"$f":"VLOOKUP($B$2,'Meta data_lookup'!$A$2:$D$5,2,FALSE)","v":237993},null,"PM2.5 monitoring end","2019-02-01"]
["Northing",{"$f":"VLOOKUP($B$2,'Meta data_lookup'!$A$2:$D$5,3,FALSE)","v":6542606},null,"PM2.5 monitoring period (h)",{"$f":"(E3-E2)*24","v":744}]
["Site elevation (m)",{"$f":"VLOOKUP($B$2,'Meta data_lookup'!$A$2:$D$5,4,FALSE)","v":"ND"},null,"Number of valid PM2.5 results",{"$f":"COUNTIF('Raw data_sheet'!G2:G745,\"Valid\")","v":641}]
["Description of surrounding land use","Agriculture",null,"Proportion of valid PM2.5 results (%)",{"$f":"E5/E4","v":0.86155913978494625}]
["Typical sources impacting on the site","Agriculture/Gravel roads",null,"PM10 monitoring start (dd/mm/yyyy hh:mm)","2019-01-01"]
["Site compliance with AS/NZS 3580.1.1:2007","Yes",null,"PM10 monitoring end","2019-02-01"]
["PM2.5 method compliance with AS/NZS 3580.9.13:2013\n","Yes",null,"PM10 monitoring period (h)",{"$f":"(E8-E7)*24","v":744}]
["PM2.5 instrument make","Thermo",null,"Number of valid PM10 results",{"$f":"COUNTIF('Raw data_sheet'!J2:J745,\"Valid\")","v":690}]
["PM2.5 instrument model","1405DF",null,"Proportion of valid PM10 results (%)",{"$f":"E10/E9","v":0.92741935483870963}]
["PM2.5 instrument intake height (m)",3.5]
["PM10 method compliance with AS 3580.9.8-2008\n","No*"]
["PM10 instrument make","Thermo"]
["PM10 instrument model","1405DF"]
["PM10 instrument intake height (m)",3.5]
["*The 1405DF TEOM used at this site measures PM10 indirectly rather than directly. The unit does however meet the intent of AS 3580.9.8-2008, and this method has been accredited by the USEPA. It is considered scientifically robust and is used extensively throughout NSW with EPA's knowledge and informal acceptance."]

{"sheet":"Meta data_lookup","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Location","Easting","Northing","Site elevation (m)"]
["Maules Creek",225302,6623037,"ND"]
["Breeza",237993,6542606,"ND"]
["Will-gai",231804,6596392,"ND"]
["Werris Creek",276783,6528734,"ND"]

{"sheet":"Raw data_sheet","index":3,"n_rows":745,"n_cols":21,"rows_kept":745,"cut":false,"hidden":false,"merged":[]}
["Year","Month","Day","Hour","Date and time","PM2.5_hourly","PM2.5_Data_Status","PM2.5_24hr_rolling_average","PM10_hourly","PM10_Data_Status","PM10_24hr_rolling_average","Cause of data invalidity, if applicable","Detailed comments","PM2.5_hourly_valid_plot","PM2.5_24hr_rolling_ave_valid_plot","PM10_hourly_valid_plot","PM10_24hr_rolling_ave_valid_plot","PM10_hourly_valid_plot_series","PM10_24hr_rolling_average_valid_plot_series","PM2.5_hourly_valid_plot_series","PM2.5_24hr_rolling_average_valid_plot_series"]
[2019,1,1,0,{"$f":"DATE(A2,B2,C2)+TIME(D2,0,0)","v":43466},10.24,"Valid",9.52,17.84,"Valid",20.93,null,null,{"$f":"IF(G2=\"Valid\", F2, NA())","v":10.24},{"$f":"IF(G2=\"Valid\", H2, NA())","v":9.52},{"$f":"IF(J2=\"Valid\", I2, NA())","v":17.84},{"$f":"IF(J2=\"Valid\", K2, NA())","v":20.93},17.84,20.93,10.24,9.52]
[{"$f":"A2","v":2019},{"$f":"B2","v":1},{"$f":"C2","v":1},{"$f":"IF(D2=23,0,D2+1)","v":1},{"$f":"E2+0.0416666666666666","v":43466.041666666664},9.7899999999999991,"Valid",9.81,17.13,"Valid",21.2,null,null,9.7899999999999991,9.81,17.13,21.2,17.13,21.2,9.7899999999999991,9.81]
[{"$f":"A3","v":2019},{"$f":"B3","v":1},1,{"$f":"IF(D3=23,0,D3+1)","v":2},{"$f":"E3+0.0416666666666666","v":43466.083333333328},5.32,"Valid",9.69,13.51,"Valid",21.11,null,null,5.32,9.69,13.51,21.11,13.51,21.11,5.32,9.69]
[2019,1,1,3,43466.124999999993,5.19,"Valid",9.75,14.22,"Valid",21.15,null,null,5.19,9.75,14.22,21.15,14.22,21.15,5.19,9.75]
[2019,1,1,4,43466.166666666657,5.78,"Valid",9.67,14.45,"Valid",21.05,null,null,5.78,9.67,14.45,21.05,14.45,21.05,5.78,9.67]
[2019,1,1,5,43466.208333333321,5.49,"Valid",9.49,13.62,"Valid",20.86,null,null,5.49,9.49,13.62,20.86,13.62,20.86,5.49,9.49]
[2019,1,1,6,43466.249999999985,7.32,"Valid",9.59,16.760000000000002,"Valid",20.99,null,null,7.32,9.59,16.760000000000002,20.99,16.760000000000002,20.99,7.32,9.59]
[2019,1,1,7,43466.29166666665,7.32,"Valid",9.6199999999999992,18.04,"Valid",20.97,null,null,7.32,9.6199999999999992,18.04,20.97,18.04,20.97,7.32,9.6199999999999992]
[2019,1,1,8,43466.333333333314,4.62,"Valid",9.56,15.64,"Valid",20.8,null,null,4.62,9.56,15.64,20.8,15.64,20.8,4.62,9.56]
[2019,1,1,9,43466.374999999978,7.01,"Valid",9.25,19.66,"Valid",20.67,null,null,7.01,9.25,19.66,20.67,19.66,20.67,7.01,9.25]
[2019,1,1,10,43466.416666666642,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,1,11,43466.458333333307,15.06,"Valid",9.82,33.44,"Valid",21.53,null,null,15.06,9.82,33.44,21.53,33.44,21.53,15.06,9.82]
[2019,1,1,12,43466.499999999971,14.38,"Valid",10.130000000000001,47.74,"Valid",22.77,null,null,14.38,10.130000000000001,47.74,22.77,47.74,22.77,14.38,10.130000000000001]
[2019,1,1,13,43466.541666666635,13.67,"Valid",10.41,68.84,"Valid",24.86,null,null,13.67,10.41,68.84,24.86,68.84,24.86,13.67,10.41]
[2019,1,1,14,43466.583333333299,14.4,"Valid",10.38,71.959999999999994,"Valid",26.75,null,null,14.4,10.38,71.959999999999994,26.75,71.959999999999994,26.75,14.4,10.38]
[2019,1,1,15,43466.624999999964,8.9700000000000006,"Valid",10.1,57.26,"Valid",28.05,null,null,8.9700000000000006,10.1,57.26,28.05,57.26,28.05,8.9700000000000006,10.1]
[2019,1,1,16,43466.666666666628,15.55,"Valid",9.6199999999999992,63.87,"Valid",29.2,null,null,15.55,9.6199999999999992,63.87,29.2,63.87,29.2,15.55,9.6199999999999992]
[2019,1,1,17,43466.708333333292,20.52,"Valid",9.66,63.41,"Valid",30.43,null,null,20.52,9.66,63.41,30.43,63.41,30.43,20.52,9.66]
[2019,1,1,18,43466.749999999956,18.25,"Valid",9.82,58.42,"Valid",31.63,null,null,18.25,9.82,58.42,31.63,58.42,31.63,18.25,9.82]
[2019,1,1,19,43466.791666666621,21.01,"Valid",10.33,47.94,"Valid",32.68,null,null,21.01,10.33,47.94,32.68,47.94,32.68,21.01,10.33]
[2019,1,1,20,43466.833333333285,13.5,"Valid",10.51,33.770000000000003,"Valid",33.130000000000003,null,null,13.5,10.51,33.770000000000003,33.130000000000003,33.770000000000003,33.130000000000003,13.5,10.51]
[2019,1,1,21,43466.874999999949,4.57,"Valid",10.55,21.38,"Valid",32.9,null,null,4.57,10.55,21.38,32.9,21.38,32.9,4.57,10.55]
[2019,1,1,22,43466.916666666613,8.2200000000000006,"Valid",10.45,25.93,"Valid",33.72,null,null,8.2200000000000006,10.45,25.93,33.72,25.93,33.72,8.2200000000000006,10.45]
[2019,{"$f":"B24","v":1},{"$f":"C24","v":1},23,43466.958333333278,3.28,"Valid",10.41,18.829999999999998,"Valid",33.64,null,null,3.28,10.41,18.829999999999998,33.64,18.829999999999998,33.64,3.28,10.41]
[2019,{"$f":"B25","v":1},{"$f":"C2+1","v":2},0,43466.999999999942,7.55,"Valid",10.29,20.260000000000002,"Valid",33.74,null,null,7.55,10.29,20.260000000000002,33.74,20.260000000000002,33.74,7.55,10.29]
[2019,{"$f":"B26","v":1},{"$f":"C3+1","v":2},1,43467.041666666606,6.92,"Valid",10.17,19.690000000000001,"Valid",33.85,null,null,6.92,10.17,19.690000000000001,33.85,19.690000000000001,33.85,6.92,10.17]
[2019,1,2,2,43467.08333333327,4.82,"Valid",10.15,17.04,"Valid",34.01,null,null,4.82,10.15,17.04,34.01,17.04,34.01,4.82,10.15]
[2019,1,2,3,43467.124999999935,6.64,"Valid",10.210000000000001,19.36,"Valid",34.229999999999997,null,null,6.64,10.210000000000001,19.36,34.229999999999997,19.36,34.229999999999997,6.64,10.210000000000001]
[2019,1,2,4,43467.166666666599,10.94,"Valid",10.44,22.69,"Valid",34.590000000000003,null,null,10.94,10.44,22.69,34.590000000000003,22.69,34.590000000000003,10.94,10.44]
[2019,1,2,5,43467.208333333263,11.05,"Valid",10.68,23.18,"Valid",35,null,null,11.05,10.68,23.18,35,23.18,35,11.05,10.68]
[2019,1,2,6,43467.249999999927,8.82,"Valid",10.74,20.64,"Valid",35.17,null,null,8.82,10.74,20.64,35.17,20.64,35.17,8.82,10.74]
[2019,1,2,7,43467.291666666591,8.5,"Valid",10.79,20.73,"Valid",35.29,null,null,8.5,10.79,20.73,35.29,20.73,35.29,8.5,10.79]
[2019,1,2,8,43467.333333333256,5.25,"Valid",10.82,19.41,"Valid",35.450000000000003,null,null,5.25,10.82,19.41,35.450000000000003,19.41,35.450000000000003,5.25,10.82]
[2019,1,2,9,43467.37499999992,9,"Valid",10.91,20.7,"Valid",35.5,null,null,9,10.91,20.7,35.5,20.7,35.5,9,10.91]
[2019,1,2,10,43467.416666666584,19.190000000000001,"Valid",11.25,30.28,"Valid",35.28,null,null,19.190000000000001,11.25,30.28,35.28,30.28,35.28,19.190000000000001,11.25]
[2019,1,2,11,43467.458333333248,13.63,"Valid",11.19,23.96,"Valid",34.89,null,null,13.63,11.19,23.96,34.89,23.96,34.89,13.63,11.19]
[2019,1,2,12,43467.499999999913,4.8499999999999996,"Valid",10.8,14.4,"Valid",33.5,null,null,4.8499999999999996,10.8,14.4,33.5,14.4,33.5,4.8499999999999996,10.8]
[2019,1,2,13,43467.541666666577,7.46,"Valid",10.54,18.190000000000001,"Valid",31.39,null,null,7.46,10.54,18.190000000000001,31.39,18.190000000000001,31.39,7.46,10.54]
[2019,1,2,14,43467.583333333241,7,"Valid",10.23,18.8,"Valid",29.17,null,null,7,10.23,18.8,29.17,18.8,29.17,7,10.23]
[2019,1,2,15,43467.624999999905,10.07,"Valid",10.27,22.23,"Valid",27.71,null,null,10.07,10.27,22.23,27.71,22.23,27.71,10.07,10.27]
[2019,1,2,16,43467.66666666657,13.69,"Valid",10.199999999999999,27.69,"Valid",26.21,null,null,13.69,10.199999999999999,27.69,26.21,27.69,26.21,13.69,10.199999999999999]
[2019,1,2,17,43467.708333333234,15.81,"Valid",10,33.76,"Valid",24.97,null,null,15.81,10,33.76,24.97,33.76,24.97,15.81,10]
[2019,1,2,18,43467.749999999898,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,2,19,43467.791666666562,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,2,20,43467.833333333227,8.84,"Valid",8.91,21.19,"Valid",21.83,null,null,8.84,8.91,21.19,21.83,21.19,21.83,8.84,8.91]
[2019,1,2,21,43467.874999999891,-1.77,"Valid",8.6300000000000008,8.43,"Valid",21.25,null,null,-1.77,8.6300000000000008,8.43,21.25,8.43,21.25,-1.77,8.6300000000000008]
[2019,1,2,22,43467.916666666555,9.75,"Valid",8.6999999999999993,20.21,"Valid",20.99,null,null,9.75,8.6999999999999993,20.21,20.99,20.21,20.99,9.75,8.6999999999999993]
[2019,1,2,23,43467.958333333219,7.52,"Valid",8.89,19.05,"Valid",21,null,null,7.52,8.89,19.05,21,19.05,21,7.52,8.89]
[2019,1,3,0,43467.999999999884,6.11,"Valid",8.82,17.29,"Valid",20.86,null,null,6.11,8.82,17.29,20.86,17.29,20.86,6.11,8.82]
[2019,1,3,1,43468.041666666548,5.19,"Valid",8.74,16.440000000000001,"Valid",20.71,null,null,5.19,8.74,16.440000000000001,20.71,16.440000000000001,20.71,5.19,8.74]
[2019,1,3,2,43468.083333333212,7.22,"Valid",8.85,16.38,"Valid",20.68,null,null,7.22,8.85,16.38,20.68,16.38,20.68,7.22,8.85]
[2019,1,3,3,43468.124999999876,9.4,"Valid",8.98,19.010000000000002,"Valid",20.67,null,null,9.4,8.98,19.010000000000002,20.67,19.010000000000002,20.67,9.4,8.98]
[2019,1,3,4,43468.166666666541,6.02,"Valid",8.75,13.63,"Valid",20.25,null,null,6.02,8.75,13.63,20.25,13.63,20.25,6.02,8.75]
[2019,1,3,5,43468.208333333205,6.35,"Valid",8.5399999999999991,14.62,"Valid",19.87,null,null,6.35,8.5399999999999991,14.62,19.87,14.62,19.87,6.35,8.5399999999999991]
[2019,1,3,6,43468.249999999869,9.6300000000000008,"Valid",8.58,18.82,"Valid",19.78,null,null,9.6300000000000008,8.58,18.82,19.78,18.82,19.78,9.6300000000000008,8.58]
[2019,1,3,7,43468.291666666533,10.93,"Valid",8.69,20.61,"Valid",19.78,null,null,10.93,8.69,20.61,19.78,20.61,19.78,10.93,8.69]
[2019,1,3,8,43468.333333333198,7.64,"Valid",8.8000000000000007,17.36,"Valid",19.68,null,null,7.64,8.8000000000000007,17.36,19.68,17.36,19.68,7.64,8.8000000000000007]
[2019,1,3,9,43468.374999999862,5,"Valid",8.6199999999999992,18.64,"Valid",19.59,null,null,5,8.6199999999999992,18.64,19.59,18.64,19.59,5,8.6199999999999992]
[2019,1,3,10,43468.416666666526,-1.19,"Valid",7.69,11.81,"Valid",18.75,null,null,-1.19,7.69,11.81,18.75,11.81,18.75,-1.19,7.69]
[2019,1,3,11,43468.45833333319,7.94,"Valid",7.43,18.920000000000002,"Valid",18.52,null,null,7.94,7.43,18.920000000000002,18.52,18.920000000000002,18.52,7.94,7.43]
[2019,1,3,12,43468.499999999854,10.58,"Valid",7.69,21.69,"Valid",18.850000000000001,null,null,10.58,7.69,21.69,18.850000000000001,21.69,18.850000000000001,10.58,7.69]
[2019,1,3,13,43468.541666666519,1.85,"Valid",7.44,12.89,"Valid",18.61,null,null,1.85,7.44,12.89,18.61,12.89,18.61,1.85,7.44]
[2019,1,3,14,43468.583333333183,11.54,"Valid",7.64,22.71,"Valid",18.79,null,null,11.54,7.64,22.71,18.79,22.71,18.79,11.54,7.64]
[2019,1,3,15,43468.624999999847,29.45,"Valid",8.52,41.26,"Valid",19.66,null,null,29.45,8.52,41.26,19.66,41.26,19.66,29.45,8.52]
[2019,1,3,16,43468.666666666511,34.25,"Valid",9.4600000000000009,51.85,"Valid",20.75,null,null,{"$f":"IF(G66=\"Valid\", F66, NA())","v":34.25},{"$f":"IF(G66=\"Valid\", H66, NA())","v":9.4600000000000009},{"$f":"IF(J66=\"Valid\", I66, NA())","v":51.85},{"$f":"IF(J66=\"Valid\", K66, NA())","v":20.75},51.85,20.75,34.25,9.4600000000000009]
[2019,1,3,17,43468.708333333176,29.84,"Valid",10.1,51.16,"Valid",21.54,null,null,29.84,10.1,51.16,21.54,51.16,21.54,29.84,10.1]
[{"$f":"A67","v":2019},1,3,{"$f":"IF(D67=23,0,D67+1)","v":18},{"$f":"E67+0.0416666666666666","v":43468.74999999984},6.94,"Valid",9.9600000000000009,27.8,"Valid",21.82,null,null,6.94,9.9600000000000009,27.8,21.82,27.8,21.82,6.94,9.9600000000000009]
[2019,1,3,19,43468.791666666504,2.4700000000000002,"Valid",9.65,19.670000000000002,"Valid",21.73,null,null,2.4700000000000002,9.65,19.670000000000002,21.73,19.670000000000002,21.73,2.4700000000000002,9.65]
[2019,1,3,20,43468.833333333168,-2.17,"Valid",9.19,7.22,"Valid",21.14,null,null,-2.17,9.19,7.22,21.14,7.22,21.14,-2.17,9.19]
[2019,1,3,21,43468.874999999833,5.6,"Valid",9.49,15.99,"Valid",21.46,null,null,5.6,9.49,15.99,21.46,15.99,21.46,5.6,9.49]
[2019,1,3,22,43468.916666666497,7.25,"Valid",9.39,17.07,"Valid",21.33,null,null,7.25,9.39,17.07,21.33,17.07,21.33,7.25,9.39]
[2019,1,3,23,43468.958333333161,8.92,"Valid",9.4499999999999993,19.77,"Valid",21.36,null,null,8.92,9.4499999999999993,19.77,21.36,19.77,21.36,8.92,9.4499999999999993]
[2019,1,4,0,43468.999999999825,8.89,"Valid",9.56,19.93,"Valid",21.47,null,null,8.89,9.56,19.93,21.47,19.93,21.47,8.89,9.56]
[2019,1,4,1,43469.04166666649,7.08,"Valid",9.64,16.989999999999998,"Valid",21.49,null,null,7.08,9.64,16.989999999999998,21.49,16.989999999999998,21.49,7.08,9.64]
[2019,1,4,2,43469.083333333154,11.68,"Valid",9.83,21.77,"Valid",21.72,null,null,11.68,9.83,21.77,21.72,21.77,21.72,11.68,9.83]
[2019,1,4,3,43469.124999999818,15.6,"Valid",10.09,25.87,"Valid",22,null,null,15.6,10.09,25.87,22,25.87,22,15.6,10.09]
[2019,1,4,4,43469.166666666482,14.25,"Valid",10.43,23.71,"Valid",22.42,null,null,14.25,10.43,23.71,22.42,23.71,22.42,14.25,10.43]
[2019,1,4,5,43469.208333333147,10.92,"Valid",10.62,21.84,"Valid",22.72,null,null,10.92,10.62,21.84,22.72,21.84,22.72,10.92,10.62]
[2019,1,4,6,43469.249999999811,13.36,"Valid",10.78,25.55,"Valid",23,null,null,13.36,10.78,25.55,23,25.55,23,13.36,10.78]
[2019,1,4,7,43469.291666666475,11.89,"Valid",10.82,31.13,"Valid",23.44,null,null,11.89,10.82,31.13,23.44,31.13,23.44,11.89,10.82]
[2019,1,4,8,43469.333333333139,13.17,"Valid",11.05,32.159999999999997,"Valid",24.06,null,null,13.17,11.05,32.159999999999997,24.06,32.159999999999997,24.06,13.17,11.05]
[2019,1,4,9,43469.374999999804,0.37,"Valid",10.85,12.06,"Valid",23.78,null,null,0.37,10.85,12.06,23.78,12.06,23.78,0.37,10.85]
[2019,1,4,10,43469.416666666468,8.93,"Valid",11.28,19.41,"Valid",24.1,null,null,8.93,11.28,19.41,24.1,19.41,24.1,8.93,11.28]
[2019,1,4,11,43469.458333333132,8.23,"Valid",11.29,17.649999999999999,"Valid",24.05,null,null,8.23,11.29,17.649999999999999,24.05,17.649999999999999,24.05,8.23,11.29]
[2019,1,4,12,43469.499999999796,7.01,"Valid",11.14,16.21,"Valid",23.82,null,null,7.01,11.14,16.21,23.82,16.21,23.82,7.01,11.14]
[2019,1,4,13,43469.541666666461,7.26,"Valid",11.36,16.64,"Valid",23.98,null,null,7.26,11.36,16.64,23.98,16.64,23.98,7.26,11.36]
[2019,1,4,14,43469.583333333125,15.83,"Valid",11.54,25.96,"Valid",24.11,null,null,15.83,11.54,25.96,24.11,25.96,24.11,15.83,11.54]
[2019,1,4,15,43469.624999999789,18.5,"Valid",11.09,32.32,"Valid",23.74,null,null,18.5,11.09,32.32,23.74,32.32,23.74,18.5,11.09]
[2019,1,4,16,43469.666666666453,13.95,"Valid",10.24,31.25,"Valid",22.88,null,null,13.95,10.24,31.25,22.88,31.25,22.88,13.95,10.24]
[2019,{"$f":"B90","v":1},{"$f":"C67+1","v":4},17,43469.708333333117,19.79,"Valid",9.82,35.049999999999997,"Valid",22.21,null,null,19.79,9.82,35.049999999999997,22.21,35.049999999999997,22.21,19.79,9.82]
[2019,1,4,18,43469.749999999782,21.71,"Valid",10.44,36.32,"Valid",22.56,null,null,21.71,10.44,36.32,22.56,36.32,22.56,21.71,10.44]
[2019,1,4,19,43469.791666666446,28.57,"Valid",11.52,46.15,"Valid",23.67,null,null,28.57,11.52,46.15,23.67,46.15,23.67,28.57,11.52]
[2019,1,4,20,43469.83333333311,10.69,"Valid",12.06,39.39,"Valid",25.01,null,null,10.69,12.06,39.39,25.01,39.39,25.01,10.69,12.06]
[2019,1,4,21,43469.874999999774,4.07,"Valid",12,22.68,"Valid",25.29,null,null,4.07,12,22.68,25.29,22.68,25.29,4.07,12]
[2019,1,4,22,43469.916666666439,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},7.06,"Valid",24.87,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},7.06,24.87,7.06,24.87]
[2019,1,4,23,43469.958333333103,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},6.46,"Valid",24.32,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},6.46,24.32,6.46,24.32]
[2019,1,5,0,43469.999999999767,0.35,"Valid",11.96,11.84,"Valid",23.98,null,null,0.35,11.96,11.84,23.98,11.84,23.98,0.35,11.96]
[2019,1,5,1,43470.041666666431,7.59,"Valid",11.99,18.91,"Valid",24.06,null,null,7.59,11.99,18.91,24.06,18.91,24.06,7.59,11.99]
[2019,1,5,2,43470.083333333096,6.56,"Valid",11.75,17.559999999999999,"Valid",23.88,null,null,6.56,11.75,17.559999999999999,23.88,17.559999999999999,23.88,6.56,11.75]
[2019,1,5,3,43470.12499999976,8.23,"Valid",11.42,20.18,"Valid",23.65,null,null,8.23,11.42,20.18,23.65,20.18,23.65,8.23,11.42]
[2019,1,5,4,43470.166666666424,5.21,"Valid",11.01,15.89,"Valid",23.32,null,null,5.21,11.01,15.89,23.32,15.89,23.32,5.21,11.01]
[2019,1,5,5,43470.208333333088,4.84,"Valid",10.73,14.71,"Valid",23.02,null,null,4.84,10.73,14.71,23.02,14.71,23.02,4.84,10.73]
[2019,1,5,6,43470.249999999753,8.91,"Valid",10.53,18.29,"Valid",22.72,null,null,8.91,10.53,18.29,22.72,18.29,22.72,8.91,10.53]
[2019,1,5,7,43470.291666666417,5.15,"Valid",10.220000000000001,13.99,"Valid",22.01,null,null,5.15,10.220000000000001,13.99,22.01,13.99,22.01,5.15,10.220000000000001]
[2019,1,5,8,43470.333333333081,6.34,"Valid",9.91,17.11,"Valid",21.38,null,null,6.34,9.91,17.11,21.38,17.11,21.38,6.34,9.91]
[2019,1,5,9,43470.374999999745,17.39,"Valid",10.69,29.3,"Valid",22.1,null,null,17.39,10.69,29.3,22.1,29.3,22.1,17.39,10.69]
[2019,1,5,10,43470.41666666641,16.79,"Valid",11.04,27.89,"Valid",22.45,null,null,16.79,11.04,27.89,22.45,27.89,22.45,16.79,11.04]
[2019,1,5,11,43470.458333333074,8.43,"Valid",11.05,21.41,"Valid",22.61,null,null,8.43,11.05,21.41,22.61,21.41,22.61,8.43,11.05]
[2019,1,5,12,43470.499999999738,9.81,"Valid",11.18,23.12,"Valid",22.9,null,null,9.81,11.18,23.12,22.9,23.12,22.9,9.81,11.18]
[2019,1,5,13,43470.541666666402,9.69,"Valid",11.29,24.4,"Valid",23.22,null,null,9.69,11.29,24.4,23.22,24.4,23.22,9.69,11.29]
[2019,1,5,14,43470.583333333067,9.27,"Valid",10.99,22.98,"Valid",23.09,null,null,9.27,10.99,22.98,23.09,22.98,23.09,9.27,10.99]
[2019,1,5,15,43470.624999999731,4.9800000000000004,"Valid",10.38,18.02,"Valid",22.5,null,null,4.9800000000000004,10.38,18.02,22.5,18.02,22.5,4.9800000000000004,10.38]
[2019,1,5,16,43470.666666666395,1.51,"Valid",9.81,13.8,"Valid",21.77,null,null,1.51,9.81,13.8,21.77,13.8,21.77,1.51,9.81]
[2019,1,5,17,43470.708333333059,6.51,"Valid",9.2100000000000009,18.41,"Valid",21.08,null,null,6.51,9.2100000000000009,18.41,21.08,18.41,21.08,6.51,9.2100000000000009]
[2019,1,5,18,43470.749999999724,11.08,"Valid",8.73,23.01,"Valid",20.52,null,null,11.08,8.73,23.01,20.52,23.01,20.52,11.08,8.73]
[2019,1,5,19,43470.791666666388,12.57,"Valid",8,24.64,"Valid",19.63,null,null,12.57,8,24.64,19.63,24.64,19.63,12.57,8]
[2019,1,5,20,43470.833333333052,3.35,"Valid",7.67,18.489999999999998,"Valid",18.760000000000002,null,null,3.35,7.67,18.489999999999998,18.760000000000002,18.489999999999998,18.760000000000002,3.35,7.67]
[2019,1,5,21,43470.874999999716,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-9.39,"Valid",17.420000000000002,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-9.39,17.420000000000002,-9.39,17.420000000000002]
[2019,1,5,22,43470.91666666638,8.9499999999999993,"Valid",7.89,17.079999999999998,"Valid",17.84,null,null,8.9499999999999993,7.89,17.079999999999998,17.84,17.079999999999998,17.84,8.9499999999999993,7.89]
[2019,1,5,23,43470.958333333045,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},6.12,"Valid",17.82,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},6.12,17.82,6.12,17.82]
[2019,1,6,0,43470.999999999709,7.32,"Valid",8.1999999999999993,22.26,"Valid",18.260000000000002,null,null,7.32,8.1999999999999993,22.26,18.260000000000002,22.26,18.260000000000002,7.32,8.1999999999999993]
[2019,1,6,1,43471.041666666373,8.74,"Valid",8.26,20.75,"Valid",18.329999999999998,null,null,8.74,8.26,20.75,18.329999999999998,20.75,18.329999999999998,8.74,8.26]
[2019,1,6,2,43471.083333333037,7.97,"Valid",8.32,17.47,"Valid",18.329999999999998,null,null,7.97,8.32,17.47,18.329999999999998,17.47,18.329999999999998,7.97,8.32]
[2019,1,6,3,43471.124999999702,10.81,"Valid",8.44,22.28,"Valid",18.420000000000002,null,null,10.81,8.44,22.28,18.420000000000002,22.28,18.420000000000002,10.81,8.44]
[2019,1,6,4,43471.166666666366,16.5,"Valid",8.9499999999999993,28.9,"Valid",18.96,null,null,16.5,8.9499999999999993,28.9,18.96,28.9,18.96,16.5,8.9499999999999993]
[2019,1,6,5,43471.20833333303,13.81,"Valid",9.36,26.03,"Valid",19.43,null,null,13.81,9.36,26.03,19.43,26.03,19.43,13.81,9.36]
[2019,1,6,6,43471.249999999694,9.24,"Valid",9.3699999999999992,24.89,"Valid",19.71,null,null,9.24,9.3699999999999992,24.89,19.71,24.89,19.71,9.24,9.3699999999999992]
[2019,1,6,7,43471.291666666359,16.850000000000001,"Valid",9.91,29.57,"Valid",20.36,null,null,16.850000000000001,9.91,29.57,20.36,29.57,20.36,16.850000000000001,9.91]
[2019,1,6,8,43471.333333333023,13.81,"Valid",10.24,29.17,"Valid",20.86,null,null,{"$f":"IF(G130=\"Valid\", F130, NA())","v":13.81},{"$f":"IF(G130=\"Valid\", H130, NA())","v":10.24},{"$f":"IF(J130=\"Valid\", I130, NA())","v":29.17},{"$f":"IF(J130=\"Valid\", K130, NA())","v":20.86},29.17,20.86,13.81,10.24]
[2019,1,6,9,43471.374999999687,12.11,"Valid",10,27.74,"Valid",20.79,null,null,12.11,10,27.74,20.79,27.74,20.79,12.11,10]
[{"$f":"A131","v":2019},1,6,{"$f":"IF(D131=23,0,D131+1)","v":10},{"$f":"E131+0.0416666666666666","v":43471.416666666351},7.89,"Valid",9.6,21.15,"Valid",20.51,null,null,7.89,9.6,21.15,20.51,21.15,20.51,7.89,9.6]
[2019,1,6,11,43471.458333333016,21,"Valid",10.17,32.520000000000003,"Valid",20.98,null,null,21,10.17,32.520000000000003,20.98,32.520000000000003,20.98,21,10.17]
[2019,1,6,12,43471.49999999968,4.1399999999999997,"Valid",9.91,15.8,"Valid",20.67,null,null,4.1399999999999997,9.91,15.8,20.67,15.8,20.67,4.1399999999999997,9.91]
[2019,1,6,13,43471.541666666344,8.39,"Valid",9.85,19.84,"Valid",20.48,null,null,8.39,9.85,19.84,20.48,19.84,20.48,8.39,9.85]
[2019,1,6,14,43471.583333333008,8.19,"Valid",9.81,20.62,"Valid",20.38,null,null,8.19,9.81,20.62,20.38,20.62,20.38,8.19,9.81]
[2019,1,6,15,43471.624999999673,6.77,"Valid",9.89,18.940000000000001,"Valid",20.420000000000002,null,null,6.77,9.89,18.940000000000001,20.420000000000002,18.940000000000001,20.420000000000002,6.77,9.89]
[2019,1,6,16,43471.666666666337,8.1199999999999992,"Valid",10.19,22.58,"Valid",20.79,null,null,8.1199999999999992,10.19,22.58,20.79,22.58,20.79,8.1199999999999992,10.19]
[2019,1,6,17,43471.708333333001,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},5.91,"Valid",20.27,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},5.91,20.27,5.91,20.27]
[2019,1,6,18,43471.749999999665,7.27,"Valid",10.18,23.32,"Valid",20.28,null,null,7.27,10.18,23.32,20.28,23.32,20.28,7.27,10.18]
[2019,1,6,19,43471.79166666633,9.25,"Valid",10.02,23.01,"Valid",20.21,null,null,9.25,10.02,23.01,20.21,23.01,20.21,9.25,10.02]
[2019,1,6,20,43471.833333332994,19.88,"Valid",10.81,34.82,"Valid",20.89,null,null,19.88,10.81,34.82,20.89,34.82,20.89,19.88,10.81]
[2019,1,6,21,43471.874999999658,13.39,"Valid",10.93,24.55,"Valid",22.31,null,null,13.39,10.93,24.55,22.31,24.55,22.31,13.39,10.93]
[2019,1,6,22,43471.916666666322,11.57,"Valid",11.05,21.42,"Valid",22.49,null,null,11.57,11.05,21.42,22.49,21.42,22.49,11.57,11.05]
[2019,1,6,23,43471.958333332987,11.67,"Valid",11.07,20.9,"Valid",23.1,null,null,11.67,11.07,20.9,23.1,20.9,23.1,11.67,11.07]
[2019,1,7,0,43471.999999999651,9.6,"Valid",11.17,20.09,"Valid",23.01,null,null,9.6,11.17,20.09,23.01,20.09,23.01,9.6,11.17]
[2019,1,7,1,43472.041666666315,14.29,"Valid",11.41,22.56,"Valid",23.09,null,null,14.29,11.41,22.56,23.09,22.56,23.09,14.29,11.41]
[2019,1,7,2,43472.083333332979,9.24,"Valid",11.47,16.579999999999998,"Valid",23.05,null,null,9.24,11.47,16.579999999999998,23.05,16.579999999999998,23.05,9.24,11.47]
[2019,1,7,3,43472.124999999643,6.82,"Valid",11.3,14.04,"Valid",22.71,null,null,6.82,11.3,14.04,22.71,14.04,22.71,6.82,11.3]
[2019,1,7,4,43472.166666666308,5.83,"Valid",10.83,12.59,"Valid",22.03,null,null,5.83,10.83,12.59,22.03,12.59,22.03,5.83,10.83]
[2019,1,7,5,43472.208333332972,9.1300000000000008,"Valid",10.63,15.63,"Valid",21.59,null,null,9.1300000000000008,10.63,15.63,21.59,15.63,21.59,9.1300000000000008,10.63]
[2019,1,7,6,43472.249999999636,3.25,"Valid",10.37,8.68,"Valid",20.92,null,null,3.25,10.37,8.68,20.92,8.68,20.92,3.25,10.37]
[2019,1,7,7,43472.2916666663,4.59,"Valid",9.83,11.1,"Valid",20.149999999999999,null,null,4.59,9.83,11.1,20.149999999999999,11.1,20.149999999999999,4.59,9.83]
[2019,1,7,8,43472.333333332965,5.54,"Valid",9.48,12.18,"Valid",19.440000000000001,null,null,5.54,9.48,12.18,19.440000000000001,12.18,19.440000000000001,5.54,9.48]
[2019,{"$f":"B154","v":1},{"$f":"C131+1","v":7},9,43472.374999999629,0.76,"Valid",8.98,13.51,"Valid",18.850000000000001,null,null,0.76,8.98,13.51,18.850000000000001,13.51,18.850000000000001,0.76,8.98]
[2019,1,7,10,43472.416666666293,-2.1,"Valid",8.5500000000000007,8.07,"Valid",18.3,null,null,-2.1,8.5500000000000007,8.07,18.3,8.07,18.3,-2.1,8.5500000000000007]
[2019,1,7,11,43472.458333332957,8.66,"Valid",8.01,15.29,"Valid",17.579999999999998,null,null,8.66,8.01,15.29,17.579999999999998,15.29,17.579999999999998,8.66,8.01]
[2019,1,7,12,43472.499999999622,19.940000000000001,"Valid",8.6999999999999993,29.75,"Valid",18.170000000000002,null,null,19.940000000000001,8.6999999999999993,29.75,18.170000000000002,29.75,18.170000000000002,19.940000000000001,8.6999999999999993]
[2019,1,7,13,43472.541666666286,10.44,"Valid",8.7899999999999991,19.28,"Valid",18.14,null,null,10.44,8.7899999999999991,19.28,18.14,19.28,18.14,10.44,8.7899999999999991]
[2019,1,7,14,43472.58333333295,11.6,"Valid",8.94,18.62,"Valid",18.059999999999999,null,null,11.6,8.94,18.62,18.059999999999999,18.62,18.059999999999999,11.6,8.94]
[2019,1,7,15,43472.624999999614,15.78,"Valid",9.33,26.31,"Valid",18.37,null,null,15.78,9.33,26.31,18.37,26.31,18.37,15.78,9.33]
[2019,1,7,16,43472.666666666279,21.14,"Valid",9.89,34.56,"Valid",18.87,null,null,21.14,9.89,34.56,18.87,34.56,18.87,21.14,9.89]
[2019,1,7,17,43472.708333332943,23.4,"Valid",10.46,38.270000000000003,"Valid",20.21,null,null,23.4,10.46,38.270000000000003,20.21,38.270000000000003,20.21,23.4,10.46]
[2019,1,7,18,43472.749999999607,16.48,"Valid",10.84,42.83,"Valid",21.03,null,null,16.48,10.84,42.83,21.03,42.83,21.03,16.48,10.84]
[2019,1,7,19,43472.791666666271,-1.89,"Valid",10.38,13.52,"Valid",20.63,null,null,-1.89,10.38,13.52,20.63,13.52,20.63,-1.89,10.38]
[2019,1,7,20,43472.833333332936,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-3.44,"Valid",19.04,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-3.44,19.04,-3.44,19.04]
[2019,1,7,21,43472.8749999996,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-4.92,"Valid",17.809999999999999,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-4.92,17.809999999999999,-4.92,17.809999999999999]
[2019,1,7,22,43472.916666666264,5.25,"Valid",9.52,17.2,"Valid",17.63,null,null,5.25,9.52,17.2,17.63,17.2,17.63,5.25,9.52]
[2019,1,7,23,43472.958333332928,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},7.21,"Valid",17.059999999999999,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},7.21,17.059999999999999,7.21,17.059999999999999]
[2019,1,8,0,43472.999999999593,-2.04,"Valid",8.86,5.39,"Valid",16.45,null,null,-2.04,8.86,5.39,16.45,5.39,16.45,-2.04,8.86]
[2019,1,8,1,43473.041666666257,-0.19,"Valid",8.17,8.81,"Valid",15.88,null,null,-0.19,8.17,8.81,15.88,8.81,15.88,-0.19,8.17]
[2019,1,8,2,43473.083333332921,2.5099999999999998,"Valid",7.85,12.78,"Valid",15.72,null,null,2.5099999999999998,7.85,12.78,15.72,12.78,15.72,2.5099999999999998,7.85]
[2019,1,8,3,43473.124999999585,3.66,"Valid",7.7,15.25,"Valid",15.77,null,null,3.66,7.7,15.25,15.77,15.25,15.77,3.66,7.7]
[2019,1,8,4,43473.16666666625,2.97,"Valid",7.57,15.38,"Valid",15.89,null,null,2.97,7.57,15.38,15.89,15.38,15.89,2.97,7.57]
[2019,1,8,5,43473.208333332914,6.82,"Valid",7.46,22.65,"Valid",16.18,null,null,6.82,7.46,22.65,16.18,22.65,16.18,6.82,7.46]
[2019,1,8,6,43473.249999999578,4.17,"Valid",7.5,16.22,"Valid",16.489999999999998,null,null,4.17,7.5,16.22,16.489999999999998,16.22,16.489999999999998,4.17,7.5]
[2019,1,8,7,43473.291666666242,18.68,"Valid",8.17,33.659999999999997,"Valid",17.43,null,null,18.68,8.17,33.659999999999997,17.43,33.659999999999997,17.43,18.68,8.17]
[2019,1,8,8,43473.333333332906,8.94,"Valid",8.33,25.79,"Valid",18,null,null,8.94,8.33,25.79,18,25.79,18,8.94,8.33]
[2019,1,8,9,43473.374999999571,1.07,"Valid",8.35,16.43,"Valid",18.12,null,null,1.07,8.35,16.43,18.12,16.43,18.12,1.07,8.35]
[2019,1,8,10,43473.416666666235,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},6.09,"Valid",18.04,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},6.09,18.04,6.09,18.04]
[2019,1,8,11,43473.458333332899,null,"Invalid",8.8800000000000008,5.86,"Valid",17.649999999999999,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},5.86,17.649999999999999,5.86,17.649999999999999]
[2019,1,8,12,43473.499999999563,null,"Invalid",8.27,1.67,"Valid",16.48,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},1.67,16.48,1.67,16.48]
[2019,1,8,13,43473.541666666228,null,"Invalid",{"$error":"#N/A"},4.76,"Valid",15.87,"Pump Failure","High negative removed, <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},4.76,15.87,4.76,15.87]
[2019,1,8,14,43473.583333332892,-1.99,"Valid",{"$error":"#N/A"},7.63,"Valid",15.41,null,"<75% 24hr average data available",-1.99,{"$error":"#N/A"},7.63,15.41,7.63,15.41,-1.99]
[2019,1,8,15,43473.624999999556,null,"Invalid",{"$error":"#N/A"},-1.89,"Valid",14.24,"Pump Failure","High negative removed, <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},-1.89,14.24,-1.89,14.24]
[2019,1,8,16,43473.66666666622,5.54,"Valid",{"$error":"#N/A"},15.21,"Valid",13.43,null,"<75% 24hr average data available",5.54,{"$error":"#N/A"},15.21,13.43,15.21,13.43,5.54]
[2019,1,8,17,43473.708333332885,8.4700000000000006,"Valid",{"$error":"#N/A"},18.989999999999998,"Valid",12.63,null,"<75% 24hr average data available",8.4700000000000006,{"$error":"#N/A"},18.989999999999998,12.63,18.989999999999998,12.63,8.4700000000000006]
[2019,1,8,18,43473.749999999549,3.37,"Valid",{"$error":"#N/A"},11.21,"Valid",11.31,null,"<75% 24hr average data available",3.37,{"$error":"#N/A"},11.21,11.31,11.21,11.31,3.37]
[2019,1,8,19,43473.791666666213,5,"Valid",{"$error":"#N/A"},14.29,"Valid",11.34,null,"<75% 24hr average data available",5,{"$error":"#N/A"},14.29,11.34,14.29,11.34,5]
[2019,1,8,20,43473.833333332877,2.5499999999999998,"Valid",{"$error":"#N/A"},14.07,"Valid",12.07,null,"<75% 24hr average data available",2.5499999999999998,{"$error":"#N/A"},14.07,12.07,14.07,12.07,2.5499999999999998]
[2019,1,8,21,43473.874999999542,null,"Invalid",{"$error":"#N/A"},2.87,"Valid",12.4,"Pump Failure","High negative removed, <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},2.87,12.4,2.87,12.4]
[2019,1,8,22,43473.916666666206,-0.91,"Valid",{"$error":"#N/A"},8.8000000000000007,"Valid",12.05,null,"<75% 24hr average data available",-0.91,{"$error":"#N/A"},8.8000000000000007,12.05,8.8000000000000007,12.05,-0.91]
[2019,1,8,23,43473.95833333287,0.34,"Valid",3.83,8.7799999999999994,"Valid",12.11,null,null,0.34,3.83,8.7799999999999994,12.11,8.7799999999999994,12.11,0.34,3.83]
[2019,1,9,0,43473.999999999534,2.79,"Valid",4.0999999999999996,15.68,"Valid",12.54,null,null,{"$f":"IF(G194=\"Valid\", F194, NA())","v":2.79},{"$f":"IF(G194=\"Valid\", H194, NA())","v":4.0999999999999996},{"$f":"IF(J194=\"Valid\", I194, NA())","v":15.68},{"$f":"IF(J194=\"Valid\", K194, NA())","v":12.54},15.68,12.54,2.79,4.0999999999999996]
[2019,1,9,1,43474.041666666199,3.93,"Valid",4.33,13.99,"Valid",12.76,null,null,3.93,4.33,13.99,12.76,13.99,12.76,3.93,4.33]
[{"$f":"A195","v":2019},1,9,{"$f":"IF(D195=23,0,D195+1)","v":2},{"$f":"E195+0.0416666666666666","v":43474.083333332863},-0.91,"Valid",4.1399999999999997,9.8699999999999992,"Valid",12.64,null,null,-0.91,4.1399999999999997,9.8699999999999992,12.64,9.8699999999999992,12.64,-0.91,4.1399999999999997]
[2019,1,9,3,43474.124999999527,2.31,"Valid",4.0599999999999996,12.31,"Valid",12.51,null,null,2.31,4.0599999999999996,12.31,12.51,12.31,12.51,2.31,4.0599999999999996]
[2019,1,9,4,43474.166666666191,-0.37,"Valid",3.88,9.4,"Valid",12.26,null,null,-0.37,3.88,9.4,12.26,9.4,12.26,-0.37,3.88]
[2019,1,9,5,43474.208333332856,0.92,"Valid",3.55,10,"Valid",11.74,null,null,0.92,3.55,10,11.74,10,11.74,0.92,3.55]
[2019,1,9,6,43474.24999999952,7.24,"Valid",3.72,16.66,"Valid",11.76,null,null,7.24,3.72,16.66,11.76,16.66,11.76,7.24,3.72]
[2019,1,9,7,43474.291666666184,-0.53,"Valid",2.65,9.23,"Valid",10.74,null,null,-0.53,2.65,9.23,10.74,9.23,10.74,-0.53,2.65]
[2019,1,9,8,43474.333333332848,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},4.8899999999999997,"Valid",9.8699999999999992,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},4.8899999999999997,9.8699999999999992,4.8899999999999997,9.8699999999999992]
[2019,1,9,9,43474.374999999513,-1.08,"Valid",2.16,6.97,"Valid",9.4700000000000006,null,null,-1.08,2.16,6.97,9.4700000000000006,6.97,9.4700000000000006,-1.08,2.16]
[2019,1,9,10,43474.416666666177,0.61,"Valid",2.0699999999999998,9.6300000000000008,"Valid",9.6199999999999992,null,null,0.61,2.0699999999999998,9.6300000000000008,9.6199999999999992,9.6300000000000008,9.6199999999999992,0.61,2.0699999999999998]
[2019,1,9,11,43474.458333332841,20.6,"Valid",3.05,30.54,"Valid",10.65,null,null,20.6,3.05,30.54,10.65,30.54,10.65,20.6,3.05]
[2019,1,9,12,43474.499999999505,12.96,"Valid",3.54,21.62,"Valid",11.48,null,null,12.96,3.54,21.62,11.48,21.62,11.48,12.96,3.54]
[2019,1,9,13,43474.541666666169,12.14,"Valid",3.95,22.14,"Valid",12.2,null,null,12.14,3.95,22.14,12.2,22.14,12.2,12.14,3.95]
[2019,1,9,14,43474.583333332834,6.96,"Valid",4.38,17.37,"Valid",12.61,null,null,6.96,4.38,17.37,12.61,17.37,12.61,6.96,4.38]
[2019,1,9,15,43474.624999999498,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},9.66,"Valid",13.09,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},9.66,13.09,9.66,13.09]
[2019,1,9,16,43474.666666666162,1.53,"Valid",4.1900000000000004,13.26,"Valid",13.01,null,null,1.53,4.1900000000000004,13.26,13.01,13.26,13.01,1.53,4.1900000000000004]
[2019,1,9,17,43474.708333332826,22.73,"Valid",4.87,37.409999999999997,"Valid",13.78,null,null,22.73,4.87,37.409999999999997,13.78,37.409999999999997,13.78,22.73,4.87]
[2019,1,9,18,43474.749999999491,12.38,"Valid",5.29,35.950000000000003,"Valid",14.81,null,null,12.38,5.29,35.950000000000003,14.81,35.950000000000003,14.81,12.38,5.29]
[2019,1,9,19,43474.791666666155,7.87,"Valid",5.43,25.85,"Valid",15.29,null,null,7.87,5.43,25.85,15.29,25.85,15.29,7.87,5.43]
[2019,1,9,20,43474.833333332819,4.5199999999999996,"Valid",5.53,19.239999999999998,"Valid",15.51,null,null,4.5199999999999996,5.53,19.239999999999998,15.51,19.239999999999998,15.51,4.5199999999999996,5.53]
[2019,1,9,21,43474.874999999483,3.89,"Valid",5.45,25.02,"Valid",16.43,null,null,3.89,5.45,25.02,16.43,25.02,16.43,3.89,5.45]
[2019,1,9,22,43474.916666666148,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},12.45,"Valid",16.579999999999998,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},12.45,16.579999999999998,12.45,16.579999999999998]
[2019,1,9,23,43474.958333332812,4.7300000000000004,"Valid",5.96,19.73,"Valid",17.04,null,null,4.7300000000000004,5.96,19.73,17.04,19.73,17.04,4.7300000000000004,5.96]
[2019,1,10,0,43474.999999999476,8.67,"Valid",6.24,21.21,"Valid",17.27,null,null,8.67,6.24,21.21,17.27,21.21,17.27,8.67,6.24]
[2019,{"$f":"B218","v":1},{"$f":"C195+1","v":10},1,43475.04166666614,4.72,"Valid",6.28,16.14,"Valid",17.36,null,null,4.72,6.28,16.14,17.36,16.14,17.36,4.72,6.28]
[2019,1,10,2,43475.083333332805,9.1,"Valid",6.76,21.57,"Valid",17.84,null,null,9.1,6.76,21.57,17.84,21.57,17.84,9.1,6.76]
[2019,1,10,3,43475.124999999469,18.73,"Valid",7.54,30.41,"Valid",18.600000000000001,null,null,18.73,7.54,30.41,18.600000000000001,30.41,18.600000000000001,18.73,7.54]
[2019,1,10,4,43475.166666666133,10.68,"Valid",8.07,22.63,"Valid",19.149999999999999,null,null,10.68,8.07,22.63,19.149999999999999,22.63,19.149999999999999,10.68,8.07]
[2019,1,10,5,43475.208333332797,9.67,"Valid",8.48,19.649999999999999,"Valid",19.55,null,null,9.67,8.48,19.649999999999999,19.55,19.649999999999999,19.55,9.67,8.48]
[2019,1,10,6,43475.249999999462,12.05,"Valid",8.7100000000000009,22.2,"Valid",19.78,null,null,12.05,8.7100000000000009,22.2,19.78,22.2,19.78,12.05,8.7100000000000009]
[2019,1,10,7,43475.291666666126,9.9600000000000009,"Valid",9.2100000000000009,21.96,"Valid",20.309999999999999,null,null,9.9600000000000009,9.2100000000000009,21.96,20.309999999999999,21.96,20.309999999999999,9.9600000000000009,9.2100000000000009]
[2019,1,10,8,43475.33333333279,8.36,"Valid",9.17,21.26,"Valid",20.99,null,null,8.36,9.17,21.26,20.99,21.26,20.99,8.36,9.17]
[2019,1,10,9,43475.374999999454,6.2,"Valid",9.5,20.49,"Valid",21.56,null,null,6.2,9.5,20.49,21.56,20.49,21.56,6.2,9.5]
[2019,1,10,10,43475.416666666119,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},8.34,"Valid",21.5,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},8.34,21.5,8.34,21.5]
[2019,1,10,11,43475.458333332783,13.75,"Valid",9.6,28.45,"Valid",21.42,null,null,13.75,9.6,28.45,21.42,28.45,21.42,13.75,9.6]
[2019,1,10,12,43475.499999999447,15.9,"Valid",9.74,27.42,"Valid",21.66,null,null,15.9,9.74,27.42,21.66,27.42,21.66,15.9,9.74]
[2019,1,10,13,43475.541666666111,11.2,"Valid",9.6999999999999993,23.34,"Valid",21.71,null,null,11.2,9.6999999999999993,23.34,21.71,23.34,21.71,11.2,9.6999999999999993]
[2019,1,10,14,43475.583333332776,5.46,"Valid",9.6199999999999992,19.13,"Valid",21.78,null,null,5.46,9.6199999999999992,19.13,21.78,19.13,21.78,5.46,9.6199999999999992]
[2019,1,10,15,43475.62499999944,3.59,"Valid",9.35,19.100000000000001,"Valid",22.18,null,null,3.59,9.35,19.100000000000001,22.18,19.100000000000001,22.18,3.59,9.35]
[2019,1,10,16,43475.666666666104,10.62,"Valid",9.76,30.9,"Valid",22.91,null,null,10.62,9.76,30.9,22.91,30.9,22.91,10.62,9.76]
[2019,1,10,17,43475.708333332768,10.23,"Valid",9.19,40.369999999999997,"Valid",23.03,null,null,10.23,9.19,40.369999999999997,23.03,40.369999999999997,23.03,10.23,9.19]
[2019,1,10,18,43475.749999999432,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,10,19,43475.791666666097,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,10,20,43475.833333332761,5.21,"Valid",9.14,19.760000000000002,"Valid",22.34,null,null,5.21,9.14,19.760000000000002,22.34,19.760000000000002,22.34,5.21,9.14]
[2019,1,10,21,43475.874999999425,5.8,"Valid",9.23,18.98,"Valid",22.07,null,null,5.8,9.23,18.98,22.07,18.98,22.07,5.8,9.23]
[2019,1,10,22,43475.916666666089,8.0299999999999994,"Valid",9.17,19.420000000000002,"Valid",22.38,null,null,8.0299999999999994,9.17,19.420000000000002,22.38,19.420000000000002,22.38,8.0299999999999994,9.17]
[2019,1,10,23,43475.958333332754,6.39,"Valid",9.25,17.07,"Valid",22.26,null,null,6.39,9.25,17.07,22.26,17.07,22.26,6.39,9.25]
[2019,1,11,0,43475.999999999418,6.82,"Valid",9.17,20.83,"Valid",22.25,null,null,6.82,9.17,20.83,22.25,20.83,22.25,6.82,9.17]
[2019,1,11,1,43476.041666666082,15.13,"Valid",9.66,28.61,"Valid",22.81,null,null,15.13,9.66,28.61,22.81,28.61,22.81,15.13,9.66]
[2019,1,11,2,43476.083333332746,17.22,"Valid",10.050000000000001,31.86,"Valid",23.28,null,null,17.22,10.050000000000001,31.86,23.28,31.86,23.28,17.22,10.050000000000001]
[2019,1,11,3,43476.124999999411,15.27,"Valid",9.8800000000000008,28.52,"Valid",23.2,null,null,15.27,9.8800000000000008,28.52,23.2,28.52,23.2,15.27,9.8800000000000008]
[2019,1,11,4,43476.166666666075,12.81,"Valid",9.98,24.89,"Valid",23.3,null,null,12.81,9.98,24.89,23.3,24.89,23.3,12.81,9.98]
[2019,1,11,5,43476.208333332739,13.25,"Valid",10.15,26.56,"Valid",23.61,null,null,13.25,10.15,26.56,23.61,26.56,23.61,13.25,10.15]
[2019,1,11,6,43476.249999999403,6.02,"Valid",9.8699999999999992,19.100000000000001,"Valid",23.47,null,null,6.02,9.8699999999999992,19.100000000000001,23.47,19.100000000000001,23.47,6.02,9.8699999999999992]
[2019,1,11,7,43476.291666666068,7.25,"Valid",9.74,18.760000000000002,"Valid",23.33,null,null,7.25,9.74,18.760000000000002,23.33,18.760000000000002,23.33,7.25,9.74]
[2019,1,11,8,43476.333333332732,7.16,"Valid",9.68,19.02,"Valid",23.22,null,null,7.16,9.68,19.02,23.22,19.02,23.22,7.16,9.68]
[2019,1,11,9,43476.374999999396,8.26,"Valid",9.7799999999999994,20.91,"Valid",23.24,null,null,8.26,9.7799999999999994,20.91,23.24,20.91,23.24,8.26,9.7799999999999994]
[2019,1,11,10,43476.41666666606,7.89,"Valid",9.69,20.39,"Valid",23.79,null,null,7.89,9.69,20.39,23.79,20.39,23.79,7.89,9.69]
[2019,1,11,11,43476.458333332725,17.96,"Valid",9.89,27.77,"Valid",23.76,null,null,17.96,9.89,27.77,23.76,27.77,23.76,17.96,9.89]
[2019,1,11,12,43476.499999999389,16.96,"Valid",9.93,29.14,"Valid",23.84,null,null,16.96,9.93,29.14,23.84,29.14,23.84,16.96,9.93]
[2019,1,11,13,43476.541666666053,11.74,"Valid",9.9600000000000009,22.98,"Valid",23.82,null,null,11.74,9.9600000000000009,22.98,23.82,22.98,23.82,11.74,9.9600000000000009]
[2019,1,11,14,43476.583333332717,14.01,"Valid",10.35,24.92,"Valid",24.08,null,null,14.01,10.35,24.92,24.08,24.92,24.08,14.01,10.35]
[2019,1,11,15,43476.624999999382,17.36,"Valid",10.97,29.77,"Valid",24.57,null,null,17.36,10.97,29.77,24.57,29.77,24.57,17.36,10.97]
[2019,1,11,16,43476.666666666046,8.01,"Valid",10.85,22.18,"Valid",24.17,null,null,{"$f":"IF(G258=\"Valid\", F258, NA())","v":8.01},{"$f":"IF(G258=\"Valid\", H258, NA())","v":10.85},{"$f":"IF(J258=\"Valid\", I258, NA())","v":22.18},{"$f":"IF(J258=\"Valid\", K258, NA())","v":24.17},22.18,24.17,8.01,10.85]
[2019,1,11,17,43476.70833333271,13.37,"Valid",11,27.42,"Valid",23.58,null,null,13.37,11,27.42,23.58,27.42,23.58,13.37,11]
[{"$f":"A259","v":2019},1,11,{"$f":"IF(D259=23,0,D259+1)","v":18},{"$f":"E259+0.0416666666666666","v":43476.749999999374},5.6,"Valid",10.76,22.83,"Valid",23.55,null,null,5.6,10.76,22.83,23.55,22.83,23.55,5.6,10.76]
[2019,1,11,19,43476.791666666039,0.19,"Valid",10.32,17.579999999999998,"Valid",23.3,null,null,0.19,10.32,17.579999999999998,23.3,17.579999999999998,23.3,0.19,10.32]
[2019,1,11,20,43476.833333332703,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,11,21,43476.874999999367,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,11,22,43476.916666666031,6.88,"Valid",10.71,18.78,"Valid",23.63,null,null,6.88,10.71,18.78,23.63,18.78,23.63,6.88,10.71]
[2019,1,11,23,43476.958333332695,11.19,"Valid",10.93,23.78,"Valid",23.94,null,null,11.19,10.93,23.78,23.94,23.78,23.94,11.19,10.93]
[2019,1,12,0,43476.99999999936,7.38,"Valid",10.95,19.54,"Valid",23.88,null,null,7.38,10.95,19.54,23.88,19.54,23.88,7.38,10.95]
[2019,1,12,1,43477.041666666024,6.17,"Valid",10.54,16.600000000000001,"Valid",23.33,null,null,6.17,10.54,16.600000000000001,23.33,16.600000000000001,23.33,6.17,10.54]
[2019,1,12,2,43477.083333332688,7.26,"Valid",10.09,16.739999999999998,"Valid",22.64,null,null,7.26,10.09,16.739999999999998,22.64,16.739999999999998,22.64,7.26,10.09]
[2019,1,12,3,43477.124999999352,3.13,"Valid",9.5399999999999991,12.23,"Valid",21.9,null,null,3.13,9.5399999999999991,12.23,21.9,12.23,21.9,3.13,9.5399999999999991]
[2019,1,12,4,43477.166666666017,-0.31,"Valid",8.94,8.44,"Valid",21.16,null,null,-0.31,8.94,8.44,21.16,8.44,21.16,-0.31,8.94]
[2019,1,12,5,43477.208333332681,1.43,"Valid",8.41,10.82,"Valid",20.440000000000001,null,null,1.43,8.41,10.82,20.440000000000001,10.82,20.440000000000001,1.43,8.41]
[2019,1,12,6,43477.249999999345,4.29,"Valid",8.33,13.47,"Valid",20.190000000000001,null,null,4.29,8.33,13.47,20.190000000000001,13.47,20.190000000000001,4.29,8.33]
[2019,1,12,7,43477.291666666009,7.46,"Valid",8.34,16.38,"Valid",20.079999999999998,null,null,7.46,8.34,16.38,20.079999999999998,16.38,20.079999999999998,7.46,8.34]
[2019,1,12,8,43477.333333332674,2.29,"Valid",8.11,11.83,"Valid",19.75,null,null,2.29,8.11,11.83,19.75,11.83,19.75,2.29,8.11]
[2019,1,12,9,43477.374999999338,4.5199999999999996,"Valid",7.94,12.08,"Valid",19.350000000000001,null,null,4.5199999999999996,7.94,12.08,19.350000000000001,12.08,19.350000000000001,4.5199999999999996,7.94]
[2019,1,12,10,43477.416666666002,6.65,"Valid",7.89,14.71,"Valid",19.09,null,null,6.65,7.89,14.71,19.09,14.71,19.09,6.65,7.89]
[2019,1,12,11,43477.458333332666,9.15,"Valid",7.49,18.8,"Valid",18.68,null,null,9.15,7.49,18.8,18.68,18.8,18.68,9.15,7.49]
[2019,1,12,12,43477.499999999331,8.7100000000000009,"Valid",7.11,17.559999999999999,"Valid",18.16,null,null,8.7100000000000009,7.11,17.559999999999999,18.16,17.559999999999999,18.16,8.7100000000000009,7.11]
[2019,1,12,13,43477.541666665995,6.39,"Valid",6.87,18.61,"Valid",17.96,null,null,6.39,6.87,18.61,17.96,18.61,17.96,6.39,6.87]
[2019,1,12,14,43477.583333332659,9.82,"Valid",6.68,28.64,"Valid",18.13,null,null,9.82,6.68,28.64,18.13,28.64,18.13,9.82,6.68]
[2019,1,12,15,43477.624999999323,14.74,"Valid",6.56,41.09,"Valid",18.64,null,null,14.74,6.56,41.09,18.64,41.09,18.64,14.74,6.56]
[2019,1,12,16,43477.666666665988,14.33,"Valid",6.85,39.65,"Valid",19.440000000000001,null,null,14.33,6.85,39.65,19.440000000000001,39.65,19.440000000000001,14.33,6.85]
[2019,{"$f":"B282","v":1},{"$f":"C259+1","v":12},17,43477.708333332652,18.62,"Valid",7.09,41.76,"Valid",20.09,null,null,18.62,7.09,41.76,20.09,41.76,20.09,18.62,7.09]
[2019,1,12,18,43477.749999999316,9.43,"Valid",7.26,29.23,"Valid",20.38,null,null,9.43,7.26,29.23,20.38,29.23,20.38,9.43,7.26]
[2019,1,12,19,43477.79166666598,22.7,"Valid",8.2799999999999994,45.11,"Valid",21.63,null,null,22.7,8.2799999999999994,45.11,21.63,45.11,21.63,22.7,8.2799999999999994]
[2019,1,12,20,43477.833333332645,11.87,"Valid",8.44,36.06,"Valid",22.26,null,null,11.87,8.44,36.06,22.26,36.06,22.26,11.87,8.44]
[2019,1,12,21,43477.874999999309,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},5.05,"Valid",21.54,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},5.05,21.54,5.05,21.54]
[2019,1,12,22,43477.916666665973,3.6,"Valid",8.3000000000000007,22.63,"Valid",21.7,null,null,3.6,8.3000000000000007,22.63,21.7,22.63,21.7,3.6,8.3000000000000007]
[2019,1,12,23,43477.958333332637,9.84,"Valid",8.24,24.01,"Valid",21.71,null,null,9.84,8.24,24.01,21.71,24.01,21.71,9.84,8.24]
[2019,1,13,0,43477.999999999302,5.56,"Valid",8.16,21.58,"Valid",21.8,null,null,5.56,8.16,21.58,21.8,21.58,21.8,5.56,8.16]
[2019,1,13,1,43478.041666665966,2.61,"Valid",8,17.73,"Valid",21.84,null,null,2.61,8,17.73,21.84,17.73,21.84,2.61,8]
[2019,1,13,2,43478.08333333263,12.35,"Valid",8.23,28.06,"Valid",22.31,null,null,12.35,8.23,28.06,22.31,28.06,22.31,12.35,8.23]
[2019,1,13,3,43478.124999999294,6.6,"Valid",8.3800000000000008,20.58,"Valid",22.66,null,null,6.6,8.3800000000000008,20.58,22.66,20.58,22.66,6.6,8.3800000000000008]
[2019,1,13,4,43478.166666665958,7,"Valid",8.69,20.64,"Valid",23.17,null,null,7,8.69,20.64,23.17,20.64,23.17,7,8.69]
[2019,1,13,5,43478.208333332623,8.2100000000000009,"Valid",8.99,20.2,"Valid",23.56,null,null,8.2100000000000009,8.99,20.2,23.56,20.2,23.56,8.2100000000000009,8.99]
[2019,1,13,6,43478.249999999287,7.89,"Valid",9.15,20.38,"Valid",23.85,null,null,7.89,9.15,20.38,23.85,20.38,23.85,7.89,9.15]
[2019,1,13,7,43478.291666665951,5.03,"Valid",9.0399999999999991,16.28,"Valid",23.84,null,null,5.03,9.0399999999999991,16.28,23.84,16.28,23.84,5.03,9.0399999999999991]
[2019,1,13,8,43478.333333332615,5.61,"Valid",9.18,16.98,"Valid",24.06,null,null,5.61,9.18,16.98,24.06,16.98,24.06,5.61,9.18]
[2019,1,13,9,43478.37499999928,5.33,"Valid",9.2200000000000006,17.18,"Valid",24.27,null,null,5.33,9.2200000000000006,17.18,24.27,17.18,24.27,5.33,9.2200000000000006]
[2019,1,13,10,43478.416666665944,13.79,"Valid",9.5299999999999994,28.68,"Valid",24.85,null,null,13.79,9.5299999999999994,28.68,24.85,28.68,24.85,13.79,9.5299999999999994]
[2019,1,13,11,43478.458333332608,4.3099999999999996,"Valid",9.32,17.47,"Valid",24.8,null,null,4.3099999999999996,9.32,17.47,24.8,17.47,24.8,4.3099999999999996,9.32]
[2019,1,13,12,43478.499999999272,1.55,"Valid",9.01,13.01,"Valid",24.61,null,null,1.55,9.01,13.01,24.61,13.01,24.61,1.55,9.01]
[2019,1,13,13,43478.541666665937,6.59,"Valid",9.02,15.81,"Valid",24.49,null,null,6.59,9.02,15.81,24.49,15.81,24.49,6.59,9.02]
[2019,1,13,14,43478.583333332601,9.5399999999999991,"Valid",9,18.670000000000002,"Valid",24.08,null,null,9.5399999999999991,9,18.670000000000002,24.08,18.670000000000002,24.08,9.5399999999999991,9]
[2019,1,13,15,43478.624999999265,12.65,"Valid",8.91,22.73,"Valid",23.31,null,null,12.65,8.91,22.73,23.31,22.73,23.31,12.65,8.91]
[2019,1,13,16,43478.666666665929,17.62,"Valid",9.06,34.880000000000003,"Valid",23.11,null,null,17.62,9.06,34.880000000000003,23.11,34.880000000000003,23.11,17.62,9.06]
[2019,1,13,17,43478.708333332594,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,13,18,43478.749999999258,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,13,19,43478.791666665922,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,13,20,43478.833333332586,60.39,"Valid",10.3,76.17,"Valid",22.8,null,null,60.39,10.3,76.17,22.8,76.17,22.8,60.39,10.3]
[2019,1,13,21,43478.874999999251,25.52,"Valid",11.03,50.25,"Valid",24.95,null,null,25.52,11.03,50.25,24.95,50.25,24.95,25.52,11.03]
[2019,1,13,22,43478.916666665915,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},10.02,"Valid",24.35,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},10.02,24.35,10.02,24.35]
[2019,1,13,23,43478.958333332579,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-2.96,"Valid",23.06,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-2.96,23.06,-2.96,23.06]
[2019,1,14,0,43478.999999999243,null,"Invalid",11.81,0.66,"Valid",22.07,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},0.66,22.07,0.66,22.07]
[2019,1,14,1,43479.041666665908,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},5.38,"Valid",21.48,"Pump Failure","High negative removed,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},5.38,21.48,5.38,21.48]
[2019,1,14,2,43479.083333332572,7.82,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},20.87,"Valid",21.14,null," <75% 24hr average data available",7.82,{"$error":"#N/A"},20.87,21.14,20.87,21.14,7.82]
[2019,1,14,3,43479.124999999236,5.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},18.46,"Valid",21.04,null," <75% 24hr average data available",5.16,{"$error":"#N/A"},18.46,21.04,18.46,21.04,5.16]
[2019,1,14,4,43479.1666666659,5.31,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},17.440000000000001,"Valid",20.88,null," <75% 24hr average data available",5.31,{"$error":"#N/A"},17.440000000000001,20.88,17.440000000000001,20.88,5.31]
[2019,1,14,5,43479.208333332565,6,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},18.18,"Valid",20.79,null," <75% 24hr average data available",6,{"$error":"#N/A"},18.18,20.79,18.18,20.79,6]
[2019,1,14,6,43479.249999999229,8.6300000000000008,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},21.95,"Valid",20.86,null," <75% 24hr average data available",8.6300000000000008,{"$error":"#N/A"},21.95,20.86,21.95,20.86,8.6300000000000008]
[2019,1,14,7,43479.291666665893,7.95,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},22.88,"Valid",21.18,null," <75% 24hr average data available",7.95,{"$error":"#N/A"},22.88,21.18,22.88,21.18,7.95]
[2019,1,14,8,43479.333333332557,8.56,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},22.68,"Valid",21.45,null," <75% 24hr average data available",{"$f":"IF(G322=\"Valid\", F322, NA())","v":8.56},{"$f":"IF(G322=\"Valid\", H322, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J322=\"Valid\", I322, NA())","v":22.68},{"$f":"IF(J322=\"Valid\", K322, NA())","v":21.45},22.68,21.45,8.56]
[2019,1,14,9,43479.374999999221,6.42,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},19.45,"Valid",21.56,null," <75% 24hr average data available",6.42,{"$error":"#N/A"},19.45,21.56,19.45,21.56,6.42]
[{"$f":"A323","v":2019},1,14,{"$f":"IF(D323=23,0,D323+1)","v":10},{"$f":"E323+0.0416666666666666","v":43479.416666665886},-0.17,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},10.76,"Valid",20.7,null," <75% 24hr average data available",-0.17,{"$error":"#N/A"},10.76,20.7,10.76,20.7,-0.17]
[2019,1,14,11,43479.45833333255,4.8899999999999997,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},32.06,"Valid",21.4,null," <75% 24hr average data available",4.8899999999999997,{"$error":"#N/A"},32.06,21.4,32.06,21.4,4.8899999999999997]
[2019,1,14,12,43479.499999999214,15.91,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},27.11,"Valid",22.07,null," <75% 24hr average data available",15.91,{"$error":"#N/A"},27.11,22.07,27.11,22.07,15.91]
[2019,1,14,13,43479.541666665878,5.99,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},38.78,"Valid",23.16,null," <75% 24hr average data available",5.99,{"$error":"#N/A"},38.78,23.16,38.78,23.16,5.99]
[2019,1,14,14,43479.583333332543,10.69,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},19.73,"Valid",23.21,null," <75% 24hr average data available",10.69,{"$error":"#N/A"},19.73,23.21,19.73,23.21,10.69]
[2019,1,14,15,43479.624999999207,11.44,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},20.34,"Valid",23.1,null," <75% 24hr average data available",11.44,{"$error":"#N/A"},20.34,23.1,20.34,23.1,11.44]
[2019,1,14,16,43479.666666665871,14.83,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},29.14,"Valid",22.83,null," <75% 24hr average data available",14.83,{"$error":"#N/A"},29.14,22.83,29.14,22.83,14.83]
[2019,1,14,17,43479.708333332535,7.46,"Valid",11.82,24.08,"Valid",22.88,null,null,7.46,11.82,24.08,22.88,24.08,22.88,7.46,11.82]
[2019,1,14,18,43479.7499999992,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,14,19,43479.791666665864,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,14,20,43479.833333332528,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,14,21,43479.874999999192,-0.51,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},111.22,"Valid",23.25,null," <75% 24hr average data available",-0.51,{"$error":"#N/A"},111.22,23.25,111.22,23.25,-0.51]
[2019,1,14,22,43479.916666665857,0.75,"Valid",7.06,34.479999999999997,"Valid",24.41,null,null,0.75,7.06,34.479999999999997,24.41,34.479999999999997,24.41,0.75,7.06]
[2019,1,14,23,43479.958333332521,null,"Invalid",7.06,8.8800000000000008,"Valid",24.98,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},8.8800000000000008,24.98,8.8800000000000008,24.98]
[2019,1,15,0,43479.999999999185,4.16,"Valid",6.91,20.18,"Valid",25.91,null,null,4.16,6.91,20.18,25.91,20.18,25.91,4.16,6.91]
[2019,1,15,1,43480.041666665849,15.3,"Valid",7.33,34.11,"Valid",27.28,null,null,15.3,7.33,34.11,27.28,34.11,27.28,15.3,7.33]
[2019,1,15,2,43480.083333332514,4.72,"Valid",7.17,17.3,"Valid",27.11,null,null,4.72,7.17,17.3,27.11,17.3,27.11,4.72,7.17]
[2019,1,15,3,43480.124999999178,9.19,"Valid",7.38,23.57,"Valid",27.35,null,null,9.19,7.38,23.57,27.35,23.57,27.35,9.19,7.38]
[2019,1,15,4,43480.166666665842,2.29,"Valid",7.23,15.25,"Valid",27.24,null,null,2.29,7.23,15.25,27.24,15.25,27.24,2.29,7.23]
[2019,1,15,5,43480.208333332506,8.94,"Valid",7.37,22.35,"Valid",27.44,null,null,8.94,7.37,22.35,27.44,22.35,27.44,8.94,7.37]
[2019,1,15,6,43480.249999999171,8.74,"Valid",7.38,20.05,"Valid",27.35,null,null,8.74,7.38,20.05,27.35,20.05,27.35,8.74,7.38]
[2019,1,15,7,43480.291666665835,7.71,"Valid",7.37,18.12,"Valid",27.13,null,null,7.71,7.37,18.12,27.13,18.12,27.13,7.71,7.37]
[2019,1,15,8,43480.333333332499,10.16,"Valid",7.45,20.63,"Valid",27.03,null,null,10.16,7.45,20.63,27.03,20.63,27.03,10.16,7.45]
[2019,{"$f":"B346","v":1},{"$f":"C323+1","v":15},9,43480.374999999163,15.71,"Valid",7.91,26.73,"Valid",27.37,null,null,15.71,7.91,26.73,27.37,26.73,27.37,15.71,7.91]
[2019,1,15,10,43480.416666665828,4.96,"Valid",8.17,16.16,"Valid",27.63,null,null,4.96,8.17,16.16,27.63,16.16,27.63,4.96,8.17]
[2019,1,15,11,43480.458333332492,16.22,"Valid",8.73,28.82,"Valid",27.48,null,null,16.22,8.73,28.82,27.48,28.82,27.48,16.22,8.73]
[2019,1,15,12,43480.499999999156,8.27,"Valid",8.35,20.23,"Valid",27.15,null,null,8.27,8.35,20.23,27.15,20.23,27.15,8.27,8.35]
[2019,1,15,13,43480.54166666582,10.8,"Valid",8.59,23.07,"Valid",26.4,null,null,10.8,8.59,23.07,26.4,23.07,26.4,10.8,8.59]
[2019,1,15,14,43480.583333332484,8.3800000000000008,"Valid",8.48,21.79,"Valid",26.5,null,null,8.3800000000000008,8.48,21.79,26.5,21.79,26.5,8.3800000000000008,8.48]
[2019,1,15,15,43480.624999999149,30.83,"Valid",9.4499999999999993,44.93,"Valid",27.67,null,null,30.83,9.4499999999999993,44.93,27.67,44.93,27.67,30.83,9.4499999999999993]
[2019,1,15,16,43480.666666665813,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,15,17,43480.708333332477,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,15,18,43480.749999999141,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,15,19,43480.791666665806,20.82,"Valid",9.8699999999999992,37.619999999999997,"Valid",28.27,null,null,20.82,9.8699999999999992,37.619999999999997,28.27,37.619999999999997,28.27,20.82,9.8699999999999992]
[2019,1,15,20,43480.83333333247,21.02,"Valid",10.42,42.79,"Valid",28.97,null,null,21.02,10.42,42.79,28.97,42.79,28.97,21.02,10.42]
[2019,1,15,21,43480.874999999134,22.56,"Valid",11.58,43.15,"Valid",25.72,null,null,22.56,11.58,43.15,25.72,43.15,25.72,22.56,11.58]
[2019,1,15,22,43480.916666665798,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-9.15,"Valid",23.65,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-9.15,23.65,-9.15,23.65]
[2019,1,15,23,43480.958333332463,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,16,0,43480.999999999127,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},13.4,"Valid",24.05,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},13.4,24.05,13.4,24.05]
[2019,1,16,1,43481.041666665791,16.670000000000002,"Valid",12.67,32.76,"Valid",23.98,null,null,16.670000000000002,12.67,32.76,23.98,32.76,23.98,16.670000000000002,12.67]
[2019,1,16,2,43481.083333332455,10.050000000000001,"Valid",12.96,25.2,"Valid",24.37,null,null,10.050000000000001,12.96,25.2,24.37,25.2,24.37,10.050000000000001,12.96]
[2019,1,16,3,43481.12499999912,7.25,"Valid",12.85,20.78,"Valid",24.23,null,null,7.25,12.85,20.78,24.23,20.78,24.23,7.25,12.85]
[2019,1,16,4,43481.166666665784,14.73,"Valid",13.55,28.87,"Valid",24.92,null,null,14.73,13.55,28.87,24.92,28.87,24.92,14.73,13.55]
[2019,1,16,5,43481.208333332448,13.43,"Valid",13.8,28.1,"Valid",25.2,null,null,13.43,13.8,28.1,25.2,28.1,25.2,13.43,13.8]
[2019,1,16,6,43481.249999999112,12.67,"Valid",14.01,26.27,"Valid",25.51,null,null,12.67,14.01,26.27,25.51,26.27,25.51,12.67,14.01]
[2019,1,16,7,43481.291666665777,0.34,"Valid",13.6,13.21,"Valid",25.27,null,null,0.34,13.6,13.21,25.27,13.21,25.27,0.34,13.6]
[2019,1,16,8,43481.333333332441,4.2,"Valid",13.27,20.149999999999999,"Valid",25.24,null,null,4.2,13.27,20.149999999999999,25.24,20.149999999999999,25.24,4.2,13.27]
[2019,1,16,9,43481.374999999105,-1.62,"Valid",12.31,11.76,"Valid",24.5,null,null,-1.62,12.31,11.76,24.5,11.76,24.5,-1.62,12.31]
[2019,1,16,10,43481.416666665769,14.26,"Valid",12.83,28.95,"Valid",25.14,null,null,14.26,12.83,28.95,25.14,28.95,25.14,14.26,12.83]
[2019,1,16,11,43481.458333332434,6.99,"Valid",12.31,21.84,"Valid",24.79,null,null,6.99,12.31,21.84,24.79,21.84,24.79,6.99,12.31]
[2019,1,16,12,43481.499999999098,9.66,"Valid",12.39,28.48,"Valid",25.2,null,null,9.66,12.39,28.48,25.2,28.48,25.2,9.66,12.39]
[2019,1,16,13,43481.541666665762,22.57,"Valid",13.05,44.3,"Valid",26.26,null,null,22.57,13.05,44.3,26.26,44.3,26.26,22.57,13.05]
[2019,1,16,14,43481.583333332426,18.97,"Valid",13.63,52.52,"Valid",27.8,null,null,18.97,13.63,52.52,27.8,52.52,27.8,18.97,13.63]
[2019,1,16,15,43481.624999999091,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,16,16,43481.666666665755,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,16,17,43481.708333332419,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,16,18,43481.749999999083,21.57,"Valid",13.12,55.15,"Valid",28.31,null,null,21.57,13.12,55.15,28.31,55.15,28.31,21.57,13.12]
[2019,1,16,19,43481.791666665747,9.6300000000000008,"Valid",12.5,50.11,"Valid",28.93,null,null,9.6300000000000008,12.5,50.11,28.93,50.11,28.93,9.6300000000000008,12.5]
[2019,1,16,20,43481.833333332412,-1.73,"Valid",11.23,33.04,"Valid",28.44,null,null,-1.73,11.23,33.04,28.44,33.04,28.44,-1.73,11.23]
[2019,1,16,21,43481.874999999076,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},7.83,"Valid",26.68,"Pump Failure","High negative removed,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},7.83,26.68,7.83,26.68]
[2019,1,16,22,43481.91666666574,10.72,"Valid",10.58,26.83,"Valid",28.48,null,null,10.72,10.58,26.83,28.48,26.83,28.48,10.72,10.58]
[2019,1,16,23,43481.958333332404,14.84,"Valid",10.8,32.840000000000003,"Valid",28.69,null,null,14.84,10.8,32.840000000000003,28.69,32.840000000000003,28.69,14.84,10.8]
[2019,1,17,0,43481.999999999069,8.98,"Valid",10.71,26.33,"Valid",29.3,null,null,{"$f":"IF(G386=\"Valid\", F386, NA())","v":8.98},{"$f":"IF(G386=\"Valid\", H386, NA())","v":10.71},{"$f":"IF(J386=\"Valid\", I386, NA())","v":26.33},{"$f":"IF(J386=\"Valid\", K386, NA())","v":29.3},26.33,29.3,8.98,10.71]
[2019,1,17,1,43482.041666665733,5.08,"Valid",10.130000000000001,20.92,"Valid",28.74,null,null,5.08,10.130000000000001,20.92,28.74,20.92,28.74,5.08,10.130000000000001]
[{"$f":"A387","v":2019},1,17,{"$f":"IF(D387=23,0,D387+1)","v":2},{"$f":"E387+0.0416666666666666","v":43482.083333332397},8.1999999999999993,"Valid",10.039999999999999,22.2,"Valid",28.59,null,null,8.1999999999999993,10.039999999999999,22.2,28.59,22.2,28.59,8.1999999999999993,10.039999999999999]
[2019,1,17,3,43482.124999999061,10.38,"Valid",10.19,26.98,"Valid",28.89,null,null,10.38,10.19,26.98,28.89,26.98,28.89,10.38,10.19]
[2019,1,17,4,43482.166666665726,10.97,"Valid",10.01,26.93,"Valid",28.8,null,null,10.97,10.01,26.93,28.8,26.93,28.8,10.97,10.01]
[2019,1,17,5,43482.20833333239,7.81,"Valid",9.7200000000000006,23.58,"Valid",28.58,null,null,7.81,9.7200000000000006,23.58,28.58,23.58,28.58,7.81,9.7200000000000006]
[2019,1,17,6,43482.249999999054,9.15,"Valid",9.5500000000000007,24.15,"Valid",28.48,null,null,9.15,9.5500000000000007,24.15,28.48,24.15,28.48,9.15,9.5500000000000007]
[2019,1,17,7,43482.291666665718,8.23,"Valid",9.94,23.06,"Valid",28.95,null,null,8.23,9.94,23.06,28.95,23.06,28.95,8.23,9.94]
[2019,1,17,8,43482.333333332383,6.76,"Valid",10.07,21.68,"Valid",29.02,null,null,6.76,10.07,21.68,29.02,21.68,29.02,6.76,10.07]
[2019,1,17,9,43482.374999999047,13.79,"Valid",10.84,35.25,"Valid",30.14,null,null,13.79,10.84,35.25,30.14,35.25,30.14,13.79,10.84]
[2019,1,17,10,43482.416666665711,12.86,"Valid",10.77,30.97,"Valid",30.24,null,null,12.86,10.77,30.97,30.24,30.97,30.24,12.86,10.77]
[2019,1,17,11,43482.458333332375,12.61,"Valid",11.05,27.31,"Valid",30.5,null,null,12.61,11.05,27.31,30.5,27.31,30.5,12.61,11.05]
[2019,1,17,12,43482.49999999904,11.97,"Valid",11.17,26.89,"Valid",30.42,null,null,11.97,11.17,26.89,30.42,26.89,30.42,11.97,11.17]
[2019,1,17,13,43482.541666665704,5.8,"Valid",10.33,22.05,"Valid",29.36,null,null,5.8,10.33,22.05,29.36,22.05,29.36,5.8,10.33]
[2019,1,17,14,43482.583333332368,16.93,"Valid",10.23,33.9,"Valid",28.48,null,null,16.93,10.23,33.9,28.48,33.9,28.48,16.93,10.23]
[2019,1,17,15,43482.624999999032,22.02,"Valid",10.79,41.06,"Valid",29.05,null,null,22.02,10.79,41.06,29.05,41.06,29.05,22.02,10.79]
[2019,1,17,16,43482.666666665697,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,17,17,43482.708333332361,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,17,18,43482.749999999025,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,17,19,43482.791666665689,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,17,20,43482.833333332354,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,17,21,43482.874999999018,14.46,"Valid",11.13,28.68,"Valid",27.45,null,null,14.46,11.13,28.68,27.45,28.68,27.45,14.46,11.13]
[2019,1,17,22,43482.916666665682,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-3.52,"Valid",25.86,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-3.52,25.86,-3.52,25.86]
[2019,1,17,23,43482.958333332346,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},10.06,"Valid",24.66,"Pump Failure","High negative removed,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},10.06,24.66,10.06,24.66]
[2019,1,18,0,43482.99999999901,3.8,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},19.64,"Valid",24.3,null," <75% 24hr average data available",3.8,{"$error":"#N/A"},19.64,24.3,19.64,24.3,3.8]
[2019,{"$f":"B410","v":1},{"$f":"C387+1","v":18},1,43483.041666665675,4.0599999999999996,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},20.149999999999999,"Valid",24.26,null," <75% 24hr average data available",4.0599999999999996,{"$error":"#N/A"},20.149999999999999,24.26,20.149999999999999,24.26,4.0599999999999996]
[2019,1,18,2,43483.083333332339,10.36,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},24.49,"Valid",24.38,null," <75% 24hr average data available",10.36,{"$error":"#N/A"},24.49,24.38,24.49,24.38,10.36]
[2019,1,18,3,43483.124999999003,9.35,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},22.1,"Valid",24.13,null," <75% 24hr average data available",9.35,{"$error":"#N/A"},22.1,24.13,22.1,24.13,9.35]
[2019,1,18,4,43483.166666665667,9.3699999999999992,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},22.5,"Valid",23.89,null," <75% 24hr average data available",9.3699999999999992,{"$error":"#N/A"},22.5,23.89,22.5,23.89,9.3699999999999992]
[2019,1,18,5,43483.208333332332,8.0299999999999994,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},18.5,"Valid",23.63,null," <75% 24hr average data available",8.0299999999999994,{"$error":"#N/A"},18.5,23.63,18.5,23.63,8.0299999999999994]
[2019,1,18,6,43483.249999998996,6.62,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},17.53,"Valid",23.28,null," <75% 24hr average data available",6.62,{"$error":"#N/A"},17.53,23.28,17.53,23.28,6.62]
[2019,1,18,7,43483.29166666566,6.8,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},18.29,"Valid",23.03,null," <75% 24hr average data available",6.8,{"$error":"#N/A"},18.29,23.03,18.29,23.03,6.8]
[2019,1,18,8,43483.333333332324,12.67,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},25.95,"Valid",23.25,null," <75% 24hr average data available",12.67,{"$error":"#N/A"},25.95,23.25,25.95,23.25,12.67]
[2019,1,18,9,43483.374999998989,13.5,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},25.74,"Valid",22.75,null," <75% 24hr average data available",13.5,{"$error":"#N/A"},25.74,22.75,25.74,22.75,13.5]
[2019,1,18,10,43483.416666665653,10.26,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},21.32,"Valid",22.24,null," <75% 24hr average data available",10.26,{"$error":"#N/A"},21.32,22.24,21.32,22.24,10.26]
[2019,1,18,11,43483.458333332317,8.48,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},21.48,"Valid",21.94,null," <75% 24hr average data available",8.48,{"$error":"#N/A"},21.48,21.94,21.48,21.94,8.48]
[2019,1,18,12,43483.499999998981,8.81,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},23.17,"Valid",21.74,null," <75% 24hr average data available",8.81,{"$error":"#N/A"},23.17,21.74,23.17,21.74,8.81]
[2019,1,18,13,43483.541666665646,12.24,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},35.51,"Valid",22.45,null," <75% 24hr average data available",12.24,{"$error":"#N/A"},35.51,22.45,35.51,22.45,12.24]
[2019,1,18,14,43483.58333333231,16.47,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},45.44,"Valid",23.06,null," <75% 24hr average data available",16.47,{"$error":"#N/A"},45.44,23.06,45.44,23.06,16.47]
[2019,1,18,15,43483.624999998974,34.409999999999997,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},57.34,"Valid",23.91,null," <75% 24hr average data available",34.409999999999997,{"$error":"#N/A"},57.34,23.91,57.34,23.91,34.409999999999997]
[2019,1,18,16,43483.666666665638,24.57,"Valid",11.9,44.88,"Valid",24.96,null,null,24.57,11.9,44.88,24.96,44.88,24.96,24.57,11.9]
[2019,1,18,17,43483.708333332303,17.91,"Valid",12.22,35.590000000000003,"Valid",25.47,null,null,17.91,12.22,35.590000000000003,25.47,35.590000000000003,25.47,17.91,12.22]
[2019,1,18,18,43483.749999998967,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,18,19,43483.791666665631,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,18,20,43483.833333332295,30.82,"Valid",13.15,41.67,"Valid",26.21,null,null,30.82,13.15,41.67,26.21,41.67,26.21,30.82,13.15]
[2019,1,18,21,43483.87499999896,33.24,"Valid",14.09,49.47,"Valid",27.15,null,null,33.24,14.09,49.47,27.15,49.47,27.15,33.24,14.09]
[2019,1,18,22,43483.916666665624,12.35,"Valid",14.01,31.51,"Valid",28.74,null,null,12.35,14.01,31.51,28.74,31.51,28.74,12.35,14.01]
[2019,1,18,23,43483.958333332288,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,19,0,43483.999999998952,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,19,1,43484.041666665617,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-3.5,"Valid",28.95,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-3.5,28.95,-3.5,28.95]
[2019,1,19,2,43484.083333332281,6.32,"Valid",14.85,16.600000000000001,"Valid",28.55,null,null,6.32,14.85,16.600000000000001,28.55,16.600000000000001,28.55,6.32,14.85]
[2019,1,19,3,43484.124999998945,5.46,"Valid",14.65,14.34,"Valid",28.17,null,null,5.46,14.65,14.34,28.17,14.34,28.17,5.46,14.65]
[2019,1,19,4,43484.166666665609,10.3,"Valid",14.7,18.37,"Valid",27.96,null,null,10.3,14.7,18.37,27.96,18.37,27.96,10.3,14.7]
[2019,1,19,5,43484.208333332273,8.49,"Valid",14.72,16.73,"Valid",27.87,null,null,8.49,14.72,16.73,27.87,16.73,27.87,8.49,14.72]
[2019,1,19,6,43484.249999998938,8.52,"Valid",14.82,17.329999999999998,"Valid",27.86,null,null,8.52,14.82,17.329999999999998,27.86,17.329999999999998,27.86,8.52,14.82]
[2019,1,19,7,43484.291666665602,3.41,"Valid",14.64,11.91,"Valid",27.54,null,null,3.41,14.64,11.91,27.54,11.91,27.54,3.41,14.64]
[2019,1,19,8,43484.333333332266,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},8.16,"Valid",26.65,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},8.16,26.65,8.16,26.65]
[2019,1,19,9,43484.37499999893,16.75,"Valid",14.93,27.22,"Valid",26.73,null,null,16.75,14.93,27.22,26.73,27.22,26.73,16.75,14.93]
[2019,1,19,10,43484.416666665595,11.92,"Valid",15.03,23.1,"Valid",26.82,null,null,11.92,15.03,23.1,26.82,23.1,26.82,11.92,15.03]
[2019,1,19,11,43484.458333332259,2.69,"Valid",14.7,14.23,"Valid",26.45,null,null,2.69,14.7,14.23,26.45,14.23,26.45,2.69,14.7]
[2019,1,19,12,43484.499999998923,6.71,"Valid",14.59,16.96,"Valid",26.14,null,null,6.71,14.59,16.96,26.14,16.96,26.14,6.71,14.59]
[2019,1,19,13,43484.541666665587,6.47,"Valid",14.27,17.82,"Valid",25.26,null,null,6.47,14.27,17.82,25.26,17.82,25.26,6.47,14.27]
[2019,1,19,14,43484.583333332252,20.62,"Valid",14.5,36.32,"Valid",24.8,null,null,20.62,14.5,36.32,24.8,36.32,24.8,20.62,14.5]
[2019,1,19,15,43484.624999998916,20.36,"Valid",13.72,36.89,"Valid",23.78,null,null,20.36,13.72,36.89,23.78,36.89,23.78,20.36,13.72]
[2019,1,19,16,43484.66666666558,8.2899999999999991,"Valid",12.81,22.56,"Valid",22.66,null,null,{"$f":"IF(G450=\"Valid\", F450, NA())","v":8.2899999999999991},{"$f":"IF(G450=\"Valid\", H450, NA())","v":12.81},{"$f":"IF(J450=\"Valid\", I450, NA())","v":22.56},{"$f":"IF(J450=\"Valid\", K450, NA())","v":22.66},22.56,22.66,8.2899999999999991,12.81]
[2019,1,19,17,43484.708333332244,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A451","v":2019},1,19,{"$f":"IF(D451=23,0,D451+1)","v":18},{"$f":"E451+0.0416666666666666","v":43484.749999998909},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,19,19,43484.791666665573,8.4499999999999993,"Valid",12.29,23.33,"Valid",22.05,null,null,8.4499999999999993,12.29,23.33,22.05,23.33,22.05,8.4499999999999993,12.29]
[2019,1,19,20,43484.833333332237,33.409999999999997,"Valid",12.43,54.07,"Valid",22.67,null,null,33.409999999999997,12.43,54.07,22.67,54.07,22.67,33.409999999999997,12.43]
[2019,1,19,21,43484.874999998901,33.21,"Valid",12.43,57.37,"Valid",23.07,null,null,33.21,12.43,57.37,23.07,57.37,23.07,33.21,12.43]
[2019,1,19,22,43484.916666665566,-0.33,"Valid",11.73,19.2,"Valid",22.45,null,null,-0.33,11.73,19.2,22.45,19.2,22.45,-0.33,11.73]
[2019,1,19,23,43484.95833333223,9.4600000000000009,"Valid",11.61,27.93,"Valid",22.71,null,null,9.4600000000000009,11.61,27.93,22.71,27.93,22.71,9.4600000000000009,11.61]
[2019,1,20,0,43484.999999998894,4.4400000000000004,"Valid",11.25,21.27,"Valid",22.65,null,null,4.4400000000000004,11.25,21.27,22.65,21.27,22.65,4.4400000000000004,11.25]
[2019,1,20,1,43485.041666665558,9.24,"Valid",11.15,24.1,"Valid",23.9,null,null,9.24,11.15,24.1,23.9,24.1,23.9,9.24,11.15]
[2019,1,20,2,43485.083333332223,10.84,"Valid",11.37,24.48,"Valid",24.26,null,null,10.84,11.37,24.48,24.26,24.48,24.26,10.84,11.37]
[2019,1,20,3,43485.124999998887,4.26,"Valid",11.31,15.8,"Valid",24.33,null,null,4.26,11.31,15.8,24.33,15.8,24.33,4.26,11.31]
[2019,1,20,4,43485.166666665551,5.29,"Valid",11.07,14.93,"Valid",24.17,null,null,5.29,11.07,14.93,24.17,14.93,24.17,5.29,11.07]
[2019,1,20,5,43485.208333332215,7.27,"Valid",11.01,15.73,"Valid",24.12,null,null,7.27,11.01,15.73,24.12,15.73,24.12,7.27,11.01]
[2019,1,20,6,43485.24999999888,7.94,"Valid",10.99,15.77,"Valid",24.05,null,null,7.94,10.99,15.77,24.05,15.77,24.05,7.94,10.99]
[2019,1,20,7,43485.291666665544,2.4500000000000002,"Valid",10.94,12.62,"Valid",24.08,null,null,2.4500000000000002,10.94,12.62,24.08,12.62,24.08,2.4500000000000002,10.94]
[2019,1,20,8,43485.333333332208,-0.49,"Valid",10.42,7.64,"Valid",24.06,null,null,-0.49,10.42,7.64,24.06,7.64,24.06,-0.49,10.42]
[2019,1,20,9,43485.374999998872,8.6,"Valid",10.050000000000001,18.84,"Valid",23.68,null,null,8.6,10.050000000000001,18.84,23.68,18.84,23.68,8.6,10.050000000000001]
[2019,1,20,10,43485.416666665536,6.93,"Valid",9.82,20.89,"Valid",23.58,null,null,6.93,9.82,20.89,23.58,20.89,23.58,6.93,9.82]
[2019,1,20,11,43485.458333332201,19.86,"Valid",10.6,33.659999999999997,"Valid",24.46,null,null,19.86,10.6,33.659999999999997,24.46,33.659999999999997,24.46,19.86,10.6]
[2019,1,20,12,43485.499999998865,6.21,"Valid",10.58,19.37,"Valid",24.57,null,null,6.21,10.58,19.37,24.57,19.37,24.57,6.21,10.58]
[2019,1,20,13,43485.541666665529,15.37,"Valid",10.99,30.49,"Valid",25.15,null,null,15.37,10.99,30.49,25.15,30.49,25.15,15.37,10.99]
[2019,1,20,14,43485.583333332193,10.91,"Valid",10.54,23.89,"Valid",24.58,null,null,10.91,10.54,23.89,24.58,23.89,24.58,10.91,10.54]
[2019,1,20,15,43485.624999998858,9.99,"Valid",10.07,21.19,"Valid",23.87,null,null,9.99,10.07,21.19,23.87,21.19,23.87,9.99,10.07]
[2019,1,20,16,43485.666666665522,19.82,"Valid",10.6,32.33,"Valid",24.31,null,null,19.82,10.6,32.33,24.31,32.33,24.31,19.82,10.6]
[2019,{"$f":"B474","v":1},{"$f":"C451+1","v":20},17,43485.708333332186,20.09,"Valid",11.01,33.57,"Valid",24.72,null,null,20.09,11.01,33.57,24.72,33.57,24.72,20.09,11.01]
[2019,1,20,18,43485.74999999885,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,20,19,43485.791666665515,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,20,20,43485.833333332179,18.260000000000002,"Valid",10.44,43.51,"Valid",24.3,null,null,18.260000000000002,10.44,43.51,24.3,43.51,24.3,18.260000000000002,10.44]
[2019,1,20,21,43485.874999998843,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},0.53,"Valid",21.72,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},0.53,21.72,0.53,21.72]
[2019,1,20,22,43485.916666665507,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},7.04,"Valid",21.16,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},7.04,21.16,7.04,21.16]
[2019,1,20,23,43485.958333332172,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},7.72,"Valid",20.239999999999998,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},7.72,20.239999999999998,7.72,20.239999999999998]
[2019,1,21,0,43485.999999998836,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},9.73,"Valid",19.72,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},9.73,19.72,9.73,19.72]
[2019,1,21,1,43486.0416666655,11.75,"Valid",10.3,24.35,"Valid",19.73,null,null,11.75,10.3,24.35,19.73,24.35,19.73,11.75,10.3]
[2019,1,21,2,43486.083333332164,4.45,"Valid",9.94,15.74,"Valid",19.329999999999998,null,null,4.45,9.94,15.74,19.329999999999998,15.74,19.329999999999998,4.45,9.94]
[2019,1,21,3,43486.124999998829,6.29,"Valid",10.06,17.04,"Valid",19.39,null,null,6.29,10.06,17.04,19.39,17.04,19.39,6.29,10.06]
[2019,1,21,4,43486.166666665493,7.38,"Valid",10.17,18.14,"Valid",19.54,null,null,7.38,10.17,18.14,19.54,18.14,19.54,7.38,10.17]
[2019,1,21,5,43486.208333332157,7.73,"Valid",10.199999999999999,18.850000000000001,"Valid",19.68,null,null,7.73,10.199999999999999,18.850000000000001,19.68,18.850000000000001,19.68,7.73,10.199999999999999]
[2019,1,21,6,43486.249999998821,12.46,"Valid",10.45,23.62,"Valid",20.03,null,null,12.46,10.45,23.62,20.03,23.62,20.03,12.46,10.45]
[2019,1,21,7,43486.291666665486,14.04,"Valid",11.09,26.75,"Valid",20.68,null,null,14.04,11.09,26.75,20.68,26.75,20.68,14.04,11.09]
[2019,1,21,8,43486.33333333215,12.33,"Valid",11.8,24.44,"Valid",21.44,null,null,12.33,11.8,24.44,21.44,24.44,21.44,12.33,11.8]
[2019,1,21,9,43486.374999998814,12.24,"Valid",12.01,22.91,"Valid",21.63,null,null,12.24,12.01,22.91,21.63,22.91,21.63,12.24,12.01]
[2019,1,21,10,43486.416666665478,10.53,"Valid",12.21,21.15,"Valid",21.64,null,null,10.53,12.21,21.15,21.64,21.15,21.64,10.53,12.21]
[2019,1,21,11,43486.458333332143,9.06,"Valid",11.61,18.07,"Valid",20.93,null,null,9.06,11.61,18.07,20.93,18.07,20.93,9.06,11.61]
[2019,1,21,12,43486.499999998807,4.78,"Valid",11.53,12.44,"Valid",20.61,null,null,4.78,11.53,12.44,20.61,12.44,20.61,4.78,11.53]
[2019,1,21,13,43486.541666665471,-1.07,"Valid",10.61,7.23,"Valid",19.559999999999999,null,null,-1.07,10.61,7.23,19.559999999999999,7.23,19.559999999999999,-1.07,10.61]
[2019,1,21,14,43486.583333332135,-0.06,"Valid",10,9.2799999999999994,"Valid",18.89,null,null,-0.06,10,9.2799999999999994,18.89,9.2799999999999994,18.89,-0.06,10]
[2019,1,21,15,43486.624999998799,16.309999999999999,"Valid",10.36,24.42,"Valid",19.04,null,null,16.309999999999999,10.36,24.42,19.04,24.42,19.04,16.309999999999999,10.36]
[2019,1,21,16,43486.666666665464,19.52,"Valid",10.34,26.69,"Valid",18.78,null,null,19.52,10.34,26.69,18.78,26.69,18.78,19.52,10.34]
[2019,1,21,17,43486.708333332128,2.5,"Valid",9.36,14.12,"Valid",17.899999999999999,null,null,2.5,9.36,14.12,17.899999999999999,14.12,17.899999999999999,2.5,9.36]
[2019,1,21,18,43486.749999998792,2.81,"Valid",9.02,12.45,"Valid",17.66,null,null,2.81,9.02,12.45,17.66,12.45,17.66,2.81,9.02]
[2019,1,21,19,43486.791666665456,6.92,"Valid",8.91,15.22,"Valid",17.559999999999999,null,null,6.92,8.91,15.22,17.559999999999999,15.22,17.559999999999999,6.92,8.91]
[2019,1,21,20,43486.833333332121,6.65,"Valid",8.33,14.75,"Valid",16.36,null,null,6.65,8.33,14.75,16.36,14.75,16.36,6.65,8.33]
[2019,1,21,21,43486.874999998785,9.19,"Valid",8.3699999999999992,20.100000000000001,"Valid",17.18,null,null,9.19,8.3699999999999992,20.100000000000001,17.18,20.100000000000001,17.18,9.19,8.3699999999999992]
[2019,1,21,22,43486.916666665449,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,21,23,43486.958333332113,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,22,0,43486.999999998778,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,22,1,43487.041666665442,10.88,"Valid",8.33,22.51,"Valid",18.38,null,null,10.88,8.33,22.51,18.38,22.51,18.38,10.88,8.33]
[2019,1,22,2,43487.083333332106,12.34,"Valid",8.7100000000000009,22.73,"Valid",18.71,null,null,12.34,8.7100000000000009,22.73,18.71,22.73,18.71,12.34,8.7100000000000009]
[2019,1,22,3,43487.12499999877,7.75,"Valid",8.7799999999999994,17.29,"Valid",18.72,null,null,7.75,8.7799999999999994,17.29,18.72,17.29,18.72,7.75,8.7799999999999994]
[2019,1,22,4,43487.166666665435,12.77,"Valid",9.0299999999999994,23.46,"Valid",18.98,null,null,12.77,9.0299999999999994,23.46,18.98,23.46,18.98,12.77,9.0299999999999994]
[2019,1,22,5,43487.208333332099,8.52,"Valid",9.07,18.510000000000002,"Valid",18.96,null,null,8.52,9.07,18.510000000000002,18.96,18.510000000000002,18.96,8.52,9.07]
[2019,1,22,6,43487.249999998763,15.43,"Valid",9.2100000000000009,27.44,"Valid",19.14,null,null,15.43,9.2100000000000009,27.44,19.14,27.44,19.14,15.43,9.2100000000000009]
[2019,1,22,7,43487.291666665427,8.98,"Valid",8.9700000000000006,19.989999999999998,"Valid",18.82,null,null,8.98,8.9700000000000006,19.989999999999998,18.82,19.989999999999998,18.82,8.98,8.9700000000000006]
[2019,1,22,8,43487.333333332092,12.3,"Valid",8.9700000000000006,22.21,"Valid",18.71,null,null,{"$f":"IF(G514=\"Valid\", F514, NA())","v":12.3},{"$f":"IF(G514=\"Valid\", H514, NA())","v":8.9700000000000006},{"$f":"IF(J514=\"Valid\", I514, NA())","v":22.21},{"$f":"IF(J514=\"Valid\", K514, NA())","v":18.71},22.21,18.71,12.3,8.9700000000000006]
[2019,1,22,9,43487.374999998756,13.22,"Valid",9.02,22.74,"Valid",18.7,null,null,13.22,9.02,22.74,18.7,22.74,18.7,13.22,9.02]
[{"$f":"A515","v":2019},1,22,{"$f":"IF(D515=23,0,D515+1)","v":10},{"$f":"E515+0.0416666666666666","v":43487.41666666542},6.72,"Valid",8.83,15.01,"Valid",18.41,null,null,6.72,8.83,15.01,18.41,15.01,18.41,6.72,8.83]
[2019,1,22,11,43487.458333332084,20.55,"Valid",9.3800000000000008,30.04,"Valid",18.98,null,null,20.55,9.3800000000000008,30.04,18.98,30.04,18.98,20.55,9.3800000000000008]
[2019,1,22,12,43487.499999998749,10.93,"Valid",9.67,20.5,"Valid",19.37,null,null,10.93,9.67,20.5,19.37,20.5,19.37,10.93,9.67]
[2019,1,22,13,43487.541666665413,15.75,"Valid",10.48,25.41,"Valid",20.23,null,null,15.75,10.48,25.41,20.23,25.41,20.23,15.75,10.48]
[2019,1,22,14,43487.583333332077,10.7,"Valid",10.99,21.3,"Valid",20.8,null,null,10.7,10.99,21.3,20.8,21.3,20.8,10.7,10.99]
[2019,1,22,15,43487.624999998741,11.99,"Valid",10.78,24.99,"Valid",20.83,null,null,11.99,10.78,24.99,20.83,24.99,20.83,11.99,10.78]
[2019,1,22,16,43487.666666665406,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},9.86,"Valid",20.03,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},9.86,20.03,9.86,20.03]
[2019,1,22,17,43487.70833333207,12.18,"Valid",10.83,24.15,"Valid",20.51,null,null,12.18,10.83,24.15,20.51,24.15,20.51,12.18,10.83]
[2019,1,22,18,43487.749999998734,10.66,"Valid",11.22,22.16,"Valid",20.97,null,null,10.66,11.22,22.16,20.97,22.16,20.97,10.66,11.22]
[2019,1,22,19,43487.791666665398,12.41,"Valid",11.5,24.46,"Valid",21.41,null,null,12.41,11.5,24.46,21.41,24.46,21.41,12.41,11.5]
[2019,1,22,20,43487.833333332062,18.3,"Valid",12.08,28.93,"Valid",22.09,null,null,18.3,12.08,28.93,22.09,28.93,22.09,18.3,12.08]
[2019,1,22,21,43487.874999998727,11.72,"Valid",12.21,23.43,"Valid",22.24,null,null,11.72,12.21,23.43,22.24,23.43,22.24,11.72,12.21]
[2019,1,22,22,43487.916666665391,12.28,"Valid",12.21,24.89,"Valid",22.36,null,null,12.28,12.21,24.89,22.36,24.89,22.36,12.28,12.21]
[2019,1,22,23,43487.958333332055,2.94,"Valid",11.79,15.86,"Valid",22.08,null,null,2.94,11.79,15.86,22.08,15.86,22.08,2.94,11.79]
[2019,1,23,0,43487.999999998719,2.77,"Valid",11.4,15.23,"Valid",21.8,null,null,2.77,11.4,15.23,21.8,15.23,21.8,2.77,11.4]
[2019,1,23,1,43488.041666665384,7.48,"Valid",11.25,17.88,"Valid",21.6,null,null,7.48,11.25,17.88,21.6,17.88,21.6,7.48,11.25]
[2019,1,23,2,43488.083333332048,3.71,"Valid",10.87,12.53,"Valid",21.18,null,null,3.71,10.87,12.53,21.18,12.53,21.18,3.71,10.87]
[2019,1,23,3,43488.124999998712,3.71,"Valid",10.7,11.51,"Valid",20.94,null,null,3.71,10.7,11.51,20.94,11.51,20.94,3.71,10.7]
[2019,1,23,4,43488.166666665376,9.42,"Valid",10.55,19.61,"Valid",20.78,null,null,9.42,10.55,19.61,20.78,19.61,20.78,9.42,10.55]
[2019,1,23,5,43488.208333332041,16.66,"Valid",10.9,33.229999999999997,"Valid",21.39,null,null,16.66,10.9,33.229999999999997,21.39,33.229999999999997,21.39,16.66,10.9]
[2019,1,23,6,43488.249999998705,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,23,7,43488.291666665369,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,23,8,43488.333333332033,16.149999999999999,"Valid",10.96,28.83,"Valid",21.48,null,null,16.149999999999999,10.96,28.83,21.48,28.83,21.48,16.149999999999999,10.96]
[2019,{"$f":"B538","v":1},{"$f":"C515+1","v":23},9,43488.374999998698,10.93,"Valid",10.86,19.68,"Valid",21.34,null,null,10.93,10.86,19.68,21.34,19.68,21.34,10.93,10.86]
[2019,1,23,10,43488.416666665362,8.81,"Valid",10.95,19.55,"Valid",21.55,null,null,8.81,10.95,19.55,21.55,19.55,21.55,8.81,10.95]
[2019,1,23,11,43488.458333332026,10.29,"Valid",10.47,19.239999999999998,"Valid",21.06,null,null,10.29,10.47,19.239999999999998,21.06,19.239999999999998,21.06,10.29,10.47]
[2019,1,23,12,43488.49999999869,6.14,"Valid",10.24,12.48,"Valid",20.69,null,null,6.14,10.24,12.48,20.69,12.48,20.69,6.14,10.24]
[2019,1,23,13,43488.541666665355,15.22,"Valid",10.210000000000001,21.93,"Valid",20.53,null,null,15.22,10.210000000000001,21.93,20.53,21.93,20.53,15.22,10.210000000000001]
[2019,1,23,14,43488.583333332019,11.53,"Valid",10.25,18.899999999999999,"Valid",20.420000000000002,null,null,11.53,10.25,18.899999999999999,20.420000000000002,18.899999999999999,20.420000000000002,11.53,10.25]
[2019,1,23,15,43488.624999998683,10.51,"Valid",10.18,17.309999999999999,"Valid",20.079999999999998,null,null,10.51,10.18,17.309999999999999,20.079999999999998,17.309999999999999,20.079999999999998,10.51,10.18]
[2019,1,23,16,43488.666666665347,16.38,"Valid",10.46,23.69,"Valid",20.7,null,null,16.38,10.46,23.69,20.7,23.69,20.7,16.38,10.46]
[2019,1,23,17,43488.708333332012,3.41,"Valid",10.07,11.19,"Valid",20.11,null,null,3.41,10.07,11.19,20.11,11.19,20.11,3.41,10.07]
[2019,1,23,18,43488.749999998676,11.02,"Valid",10.08,19.72,"Valid",20,null,null,11.02,10.08,19.72,20,19.72,20,11.02,10.08]
[2019,1,23,19,43488.79166666534,5.84,"Valid",9.7799999999999994,15.2,"Valid",19.579999999999998,null,null,5.84,9.7799999999999994,15.2,19.579999999999998,15.2,19.579999999999998,5.84,9.7799999999999994]
[2019,1,23,20,43488.833333332004,4.3099999999999996,"Valid",9.15,22.2,"Valid",19.28,null,null,4.3099999999999996,9.15,22.2,19.28,22.2,19.28,4.3099999999999996,9.15]
[2019,1,23,21,43488.874999998668,13.34,"Valid",9.2200000000000006,33.729999999999997,"Valid",19.75,null,null,13.34,9.2200000000000006,33.729999999999997,19.75,33.729999999999997,19.75,13.34,9.2200000000000006]
[2019,1,23,22,43488.916666665333,21.75,"Valid",9.65,36.880000000000003,"Valid",20.29,null,null,21.75,9.65,36.880000000000003,20.29,36.880000000000003,20.29,21.75,9.65]
[2019,1,23,23,43488.958333331997,18.3,"Valid",10.35,32.71,"Valid",21.06,null,null,18.3,10.35,32.71,21.06,32.71,21.06,18.3,10.35]
[2019,1,24,0,43488.999999998661,14.9,"Valid",10.9,28.75,"Valid",21.67,null,null,14.9,10.9,28.75,21.67,28.75,21.67,14.9,10.9]
[2019,1,24,1,43489.041666665325,15.93,"Valid",11.28,27.26,"Valid",22.1,null,null,15.93,11.28,27.26,22.1,27.26,22.1,15.93,11.28]
[2019,1,24,2,43489.08333333199,14.44,"Valid",11.77,27.57,"Valid",22.78,null,null,14.44,11.77,27.57,22.78,27.57,22.78,14.44,11.77]
[2019,1,24,3,43489.124999998654,12.82,"Valid",12.19,23.55,"Valid",23.33,null,null,12.82,12.19,23.55,23.33,23.55,23.33,12.82,12.19]
[2019,1,24,4,43489.166666665318,20.23,"Valid",12.68,31.9,"Valid",23.89,null,null,20.23,12.68,31.9,23.89,31.9,23.89,20.23,12.68]
[2019,1,24,5,43489.208333331982,16.809999999999999,"Valid",12.68,28.7,"Valid",23.68,null,null,16.809999999999999,12.68,28.7,23.68,28.7,23.68,16.809999999999999,12.68]
[2019,1,24,6,43489.249999998647,18.87,"Valid",12.95,31.01,"Valid",24,null,null,18.87,12.95,31.01,24,31.01,24,18.87,12.95]
[2019,1,24,7,43489.291666665311,26.83,"Valid",13.53,39.479999999999997,"Valid",24.64,null,null,26.83,13.53,39.479999999999997,24.64,39.479999999999997,24.64,26.83,13.53]
[2019,1,24,8,43489.333333331975,19.07,"Valid",13.65,32.75,"Valid",24.81,null,null,19.07,13.65,32.75,24.81,32.75,24.81,19.07,13.65]
[2019,1,24,9,43489.374999998639,18.82,"Valid",13.98,32.299999999999997,"Valid",25.33,null,null,18.82,13.98,32.299999999999997,25.33,32.299999999999997,25.33,18.82,13.98]
[2019,1,24,10,43489.416666665304,23.08,"Valid",14.58,34.83,"Valid",25.97,null,null,23.08,14.58,34.83,25.97,34.83,25.97,23.08,14.58]
[2019,1,24,11,43489.458333331968,35.96,"Valid",15.65,46.04,"Valid",27.09,null,null,35.96,15.65,46.04,27.09,46.04,27.09,35.96,15.65]
[2019,1,24,12,43489.499999998632,22.91,"Valid",16.350000000000001,34.53,"Valid",28.01,null,null,22.91,16.350000000000001,34.53,28.01,34.53,28.01,22.91,16.350000000000001]
[2019,1,24,13,43489.541666665296,15.94,"Valid",16.38,27.96,"Valid",28.26,null,null,15.94,16.38,27.96,28.26,27.96,28.26,15.94,16.38]
[2019,1,24,14,43489.583333331961,17.329999999999998,"Valid",16.62,30.01,"Valid",28.72,null,null,17.329999999999998,16.62,30.01,28.72,30.01,28.72,17.329999999999998,16.62]
[2019,1,24,15,43489.624999998625,19.489999999999998,"Valid",16.989999999999998,32.75,"Valid",29.36,null,null,19.489999999999998,16.989999999999998,32.75,29.36,32.75,29.36,19.489999999999998,16.989999999999998]
[2019,1,24,16,43489.666666665289,9.75,"Valid",16.71,19.690000000000001,"Valid",29.2,null,null,9.75,16.71,19.690000000000001,29.2,19.690000000000001,29.2,9.75,16.71]
[2019,1,24,17,43489.708333331953,2.4300000000000002,"Valid",16.670000000000002,16.32,"Valid",29.41,null,null,2.4300000000000002,16.670000000000002,16.32,29.41,16.32,29.41,2.4300000000000002,16.670000000000002]
[2019,1,24,18,43489.749999998618,21.61,"Valid",17.12,37.200000000000003,"Valid",30.14,null,null,21.61,17.12,37.200000000000003,30.14,37.200000000000003,30.14,21.61,17.12]
[2019,1,24,19,43489.791666665282,33.93,"Valid",18.29,46.83,"Valid",31.46,null,null,33.93,18.29,46.83,31.46,46.83,31.46,33.93,18.29]
[2019,1,24,20,43489.833333331946,25.96,"Valid",19.190000000000001,41.8,"Valid",32.270000000000003,null,null,25.96,19.190000000000001,41.8,32.270000000000003,41.8,32.270000000000003,25.96,19.190000000000001]
[2019,1,24,21,43489.87499999861,11.47,"Valid",19.11,32.17,"Valid",32.21,null,null,11.47,19.11,32.17,32.21,32.17,32.21,11.47,19.11]
[2019,1,24,22,43489.916666665275,14.45,"Valid",18.809999999999999,28.93,"Valid",31.88,null,null,14.45,18.809999999999999,28.93,31.88,28.93,31.88,14.45,18.809999999999999]
[2019,1,24,23,43489.958333331939,5.17,"Valid",18.260000000000002,21.21,"Valid",31.4,null,null,5.17,18.260000000000002,21.21,31.4,21.21,31.4,5.17,18.260000000000002]
[2019,1,25,0,43489.999999998603,-1.39,"Valid",17.579999999999998,13.51,"Valid",30.76,null,null,{"$f":"IF(G578=\"Valid\", F578, NA())","v":-1.39},{"$f":"IF(G578=\"Valid\", H578, NA())","v":17.579999999999998},{"$f":"IF(J578=\"Valid\", I578, NA())","v":13.51},{"$f":"IF(J578=\"Valid\", K578, NA())","v":30.76},13.51,30.76,-1.39,17.579999999999998]
[2019,1,25,1,43490.041666665267,5.18,"Valid",17.13,21.12,"Valid",30.51,null,null,5.18,17.13,21.12,30.51,21.12,30.51,5.18,17.13]
[{"$f":"A579","v":2019},1,25,{"$f":"IF(D579=23,0,D579+1)","v":2},{"$f":"E579+0.0416666666666666","v":43490.083333331931},13.84,"Valid",17.11,30.4,"Valid",30.62,null,null,13.84,17.11,30.4,30.62,30.4,30.62,13.84,17.11]
[2019,1,25,3,43490.124999998596,20.73,"Valid",17.440000000000001,35.619999999999997,"Valid",31.13,null,null,20.73,17.440000000000001,35.619999999999997,31.13,35.619999999999997,31.13,20.73,17.440000000000001]
[2019,1,25,4,43490.16666666526,19.29,"Valid",17.399999999999999,35.479999999999997,"Valid",31.28,null,null,19.29,17.399999999999999,35.479999999999997,31.28,35.479999999999997,31.28,19.29,17.399999999999999]
[2019,1,25,5,43490.208333331924,16.850000000000001,"Valid",17.399999999999999,32.07,"Valid",31.42,null,null,16.850000000000001,17.399999999999999,32.07,31.42,32.07,31.42,16.850000000000001,17.399999999999999]
[2019,1,25,6,43490.249999998588,16.72,"Valid",17.309999999999999,31.78,"Valid",31.45,null,null,16.72,17.309999999999999,31.78,31.45,31.78,31.45,16.72,17.309999999999999]
[2019,1,25,7,43490.291666665253,15.17,"Valid",16.82,30.34,"Valid",31.07,null,null,15.17,16.82,30.34,31.07,30.34,31.07,15.17,16.82]
[2019,1,25,8,43490.333333331917,18.829999999999998,"Valid",16.809999999999999,34.36,"Valid",31.14,null,null,18.829999999999998,16.809999999999999,34.36,31.14,34.36,31.14,18.829999999999998,16.809999999999999]
[2019,1,25,9,43490.374999998581,6.45,"Valid",16.3,18.72,"Valid",30.57,null,null,6.45,16.3,18.72,30.57,18.72,30.57,6.45,16.3]
[2019,1,25,10,43490.416666665245,5.32,"Valid",15.56,17.73,"Valid",29.86,null,null,5.32,15.56,17.73,29.86,17.73,29.86,5.32,15.56]
[2019,1,25,11,43490.45833333191,12.64,"Valid",14.59,23.42,"Valid",28.91,null,null,12.64,14.59,23.42,28.91,23.42,28.91,12.64,14.59]
[2019,1,25,12,43490.499999998574,21.13,"Valid",14.51,31.58,"Valid",28.79,null,null,21.13,14.51,31.58,28.79,31.58,28.79,21.13,14.51]
[2019,1,25,13,43490.541666665238,11.43,"Valid",14.32,23.14,"Valid",28.59,null,null,11.43,14.32,23.14,28.59,23.14,28.59,11.43,14.32]
[2019,1,25,14,43490.583333331902,11.51,"Valid",14.08,24.5,"Valid",28.36,null,null,11.51,14.08,24.5,28.36,24.5,28.36,11.51,14.08]
[2019,1,25,15,43490.624999998567,10.210000000000001,"Valid",13.7,23.16,"Valid",27.96,null,null,10.210000000000001,13.7,23.16,27.96,23.16,27.96,10.210000000000001,13.7]
[2019,1,25,16,43490.666666665231,33.25,"Valid",14.67,50.86,"Valid",29.26,null,null,33.25,14.67,50.86,29.26,50.86,29.26,33.25,14.67]
[2019,1,25,17,43490.708333331895,24.26,"Valid",15.58,40.36,"Valid",30.26,null,null,24.26,15.58,40.36,30.26,40.36,30.26,24.26,15.58]
[2019,1,25,18,43490.749999998559,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,25,19,43490.791666665224,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,25,20,43490.833333331888,40.53,"Valid",15.14,54.15,"Valid",29.76,null,null,40.53,15.14,54.15,29.76,54.15,29.76,40.53,15.14]
[2019,1,25,21,43490.874999998552,22.06,"Valid",15.62,40.08,"Valid",30.11,null,null,22.06,15.62,40.08,30.11,40.08,30.11,22.06,15.62]
[2019,1,25,22,43490.916666665216,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-6.15,"Valid",28.52,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},-6.15,28.52,-6.15,28.52]
[2019,1,25,23,43490.958333331881,-0.65,"Valid",15.4,16.11,"Valid",28.29,null,null,-0.65,15.4,16.11,28.29,16.11,28.29,-0.65,15.4]
[2019,1,26,0,43490.999999998545,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",28.99,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,{"$f":"B602","v":1},{"$f":"C579+1","v":26},1,43491.041666665209,8.91,"Valid",16.420000000000002,22.81,"Valid",29.07,null,null,8.91,16.420000000000002,22.81,29.07,22.81,29.07,8.91,16.420000000000002]
[2019,1,26,2,43491.083333331873,9.85,"Valid",16.22,23.56,"Valid",28.75,null,null,9.85,16.22,23.56,28.75,23.56,28.75,9.85,16.22]
[2019,1,26,3,43491.124999998538,11.73,"Valid",15.77,23.23,"Valid",28.16,null,null,11.73,15.77,23.23,28.16,23.23,28.16,11.73,15.77]
[2019,1,26,4,43491.166666665202,11.81,"Valid",15.4,23.39,"Valid",27.58,null,null,11.81,15.4,23.39,27.58,23.39,27.58,11.81,15.4]
[2019,1,26,5,43491.208333331866,13.69,"Valid",15.24,25.56,"Valid",27.27,null,null,13.69,15.24,25.56,27.27,25.56,27.27,13.69,15.24]
[2019,1,26,6,43491.24999999853,10.55,"Valid",14.93,21.28,"Valid",26.77,null,null,10.55,14.93,21.28,26.77,21.28,26.77,10.55,14.93]
[2019,1,26,7,43491.291666665194,7.26,"Valid",14.54,20.73,"Valid",26.31,null,null,7.26,14.54,20.73,26.31,20.73,26.31,7.26,14.54]
[2019,1,26,8,43491.333333331859,3.4,"Valid",13.77,16.75,"Valid",25.47,null,null,3.4,13.77,16.75,25.47,16.75,25.47,3.4,13.77]
[2019,1,26,9,43491.374999998523,15.78,"Valid",14.23,29.01,"Valid",25.96,null,null,15.78,14.23,29.01,25.96,29.01,25.96,15.78,14.23]
[2019,1,26,10,43491.416666665187,13.04,"Valid",14.62,23.44,"Valid",26.24,null,null,13.04,14.62,23.44,26.24,23.44,26.24,13.04,14.62]
[2019,1,26,11,43491.458333331851,9.7799999999999994,"Valid",14.48,20.79,"Valid",26.11,null,null,9.7799999999999994,14.48,20.79,26.11,20.79,26.11,9.7799999999999994,14.48]
[2019,1,26,12,43491.499999998516,11.08,"Valid",13.97,23.52,"Valid",25.73,null,null,11.08,13.97,23.52,25.73,23.52,25.73,11.08,13.97]
[2019,1,26,13,43491.54166666518,12.18,"Valid",14.01,26.97,"Valid",25.91,null,null,12.18,14.01,26.97,25.91,26.97,25.91,12.18,14.01]
[2019,1,26,14,43491.583333331844,14.72,"Valid",14.17,29.26,"Valid",26.14,null,null,14.72,14.17,29.26,26.14,29.26,26.14,14.72,14.17]
[2019,1,26,15,43491.624999998508,35.85,"Valid",15.45,52.14,"Valid",27.52,null,null,35.85,15.45,52.14,27.52,52.14,27.52,35.85,15.45]
[2019,1,26,16,43491.666666665173,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,26,17,43491.708333331837,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,26,18,43491.749999998501,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,26,19,43491.791666665165,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,26,20,43491.83333333183,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,26,21,43491.874999998494,37.89,"Valid",13.35,48.69,"Valid",24.51,null,null,37.89,13.35,48.69,24.51,48.69,24.51,37.89,13.35]
[2019,1,26,22,43491.916666665158,38.130000000000003,"Valid",14.72,58.88,"Valid",28.12,null,null,38.130000000000003,14.72,58.88,28.12,58.88,28.12,38.130000000000003,14.72]
[2019,1,26,23,43491.958333331822,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-8.1,"Valid",26.77,"Pump Failure","High negative removed,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},-8.1,26.77,-8.1,26.77]
[2019,1,27,0,43491.999999998487,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,27,1,43492.041666665151,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},-1.55,"Valid",25.42,"Pump Failure","High negative removed,  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},-1.55,25.42,-1.55,25.42]
[2019,1,27,2,43492.083333331815,4.9000000000000004,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},17.87,"Valid",25.1,null," <75% 24hr average data available",4.9000000000000004,{"$error":"#N/A"},17.87,25.1,17.87,25.1,4.9000000000000004]
[2019,1,27,3,43492.124999998479,5.35,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},16.61,"Valid",24.74,null," <75% 24hr average data available",5.35,{"$error":"#N/A"},16.61,24.74,16.61,24.74,5.35]
[2019,1,27,4,43492.166666665144,5.41,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},18.100000000000001,"Valid",24.44,null," <75% 24hr average data available",5.41,{"$error":"#N/A"},18.100000000000001,24.44,18.100000000000001,24.44,5.41]
[2019,1,27,5,43492.208333331808,4.05,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},15.66,"Valid",23.89,null," <75% 24hr average data available",4.05,{"$error":"#N/A"},15.66,23.89,15.66,23.89,4.05]
[2019,1,27,6,43492.249999998472,3.03,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},13.92,"Valid",23.48,null," <75% 24hr average data available",3.03,{"$error":"#N/A"},13.92,23.48,13.92,23.48,3.03]
[2019,1,27,7,43492.291666665136,7.27,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},19.36,"Valid",23.41,null," <75% 24hr average data available",7.27,{"$error":"#N/A"},19.36,23.41,19.36,23.41,7.27]
[2019,1,27,8,43492.333333331801,9.2200000000000006,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},20.98,"Valid",23.64,null," <75% 24hr average data available",9.2200000000000006,{"$error":"#N/A"},20.98,23.64,20.98,23.64,9.2200000000000006]
[2019,1,27,9,43492.374999998465,8.82,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},19.739999999999998,"Valid",23.13,null," <75% 24hr average data available",8.82,{"$error":"#N/A"},19.739999999999998,23.13,19.739999999999998,23.13,8.82]
[2019,1,27,10,43492.416666665129,2.5299999999999998,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},13.31,"Valid",22.56,null," <75% 24hr average data available",2.5299999999999998,{"$error":"#N/A"},13.31,22.56,13.31,22.56,2.5299999999999998]
[2019,1,27,11,43492.458333331793,6.28,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},16.48,"Valid",22.32,null," <75% 24hr average data available",6.28,{"$error":"#N/A"},16.48,22.32,16.48,22.32,6.28]
[2019,1,27,12,43492.499999998457,9.56,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},19.86,"Valid",22.12,null," <75% 24hr average data available",9.56,{"$error":"#N/A"},19.86,22.12,19.86,22.12,9.56]
[2019,1,27,13,43492.541666665122,16.55,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},28.19,"Valid",22.19,null," <75% 24hr average data available",16.55,{"$error":"#N/A"},28.19,22.19,28.19,22.19,16.55]
[2019,1,27,14,43492.583333331786,9.8000000000000007,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},25.27,"Valid",21.97,null," <75% 24hr average data available",9.8000000000000007,{"$error":"#N/A"},25.27,21.97,25.27,21.97,9.8000000000000007]
[2019,1,27,15,43492.62499999845,12.32,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},26.69,"Valid",20.55,null," <75% 24hr average data available",12.32,{"$error":"#N/A"},26.69,20.55,26.69,20.55,12.32]
[2019,1,27,16,43492.666666665114,37.97,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},54.16,"Valid",22.32,null," <75% 24hr average data available",{"$f":"IF(G642=\"Valid\", F642, NA())","v":37.97},{"$f":"IF(G642=\"Valid\", H642, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J642=\"Valid\", I642, NA())","v":54.16},{"$f":"IF(J642=\"Valid\", K642, NA())","v":22.32},54.16,22.32,37.97]
[2019,1,27,17,43492.708333331779,33.869999999999997,"Valid",14.05,46.73,"Valid",23.54,null,null,33.869999999999997,14.05,46.73,23.54,46.73,23.54,33.869999999999997,14.05]
[{"$f":"A643","v":2019},1,27,{"$f":"IF(D643=23,0,D643+1)","v":18},{"$f":"E643+0.0416666666666666","v":43492.749999998443},25.31,"Valid",14.65,34.53,"Valid",24.07,null,null,25.31,14.65,34.53,24.07,34.53,24.07,25.31,14.65]
[2019,1,27,19,43492.791666665107,37.31,"Valid",15.78,43.94,"Valid",24.97,null,null,37.31,15.78,43.94,24.97,43.94,24.97,37.31,15.78]
[2019,1,27,20,43492.833333331771,32.07,"Valid",16.55,39.75,"Valid",25.61,null,null,32.07,16.55,39.75,25.61,39.75,25.61,32.07,16.55]
[2019,1,27,21,43492.874999998436,47.82,"Valid",17.03,58.4,"Valid",26.03,null,null,47.82,17.03,58.4,26.03,58.4,26.03,47.82,17.03]
[2019,1,27,22,43492.9166666651,42.89,"Valid",17.25,61.97,"Valid",26.17,null,null,42.89,17.25,61.97,26.17,61.97,26.17,42.89,17.25]
[2019,1,27,23,43492.958333331764,10.99,"Valid",16.97,29.4,"Valid",27.8,null,null,10.99,16.97,29.4,27.8,29.4,27.8,10.99,16.97]
[2019,1,28,0,43492.999999998428,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},2.42,"Valid",26.74,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},2.42,26.74,2.42,26.74]
[2019,1,28,1,43493.041666665093,0.15,"Valid",16.239999999999998,17.71,"Valid",27.54,null,null,0.15,16.239999999999998,17.71,27.54,17.71,27.54,0.15,16.239999999999998]
[2019,1,28,2,43493.083333331757,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},9.92,"Valid",27.21,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},9.92,27.21,9.92,27.21]
[2019,1,28,3,43493.124999998421,0.8,"Valid",16.55,16.54,"Valid",27.21,null,null,0.8,16.55,16.54,27.21,16.54,27.21,0.8,16.55]
[2019,1,28,4,43493.166666665085,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},11.5,"Valid",26.93,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},11.5,26.93,11.5,26.93]
[2019,1,28,5,43493.20833333175,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},5.32,"Valid",26.5,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},5.32,26.5,5.32,26.5]
[2019,1,28,6,43493.249999998414,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},4.92,"Valid",26.13,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},4.92,26.13,4.92,26.13]
[2019,1,28,7,43493.291666665078,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},8.5,"Valid",25.68,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},8.5,25.68,8.5,25.68]
[2019,1,28,8,43493.333333331742,-0.38,"Valid",18.59,15.78,"Valid",25.46,null,null,-0.38,18.59,15.78,25.46,15.78,25.46,-0.38,18.59]
[2019,1,28,9,43493.374999998407,6.32,"Valid",18.45,18.239999999999998,"Valid",25.4,null,null,6.32,18.45,18.239999999999998,25.4,18.239999999999998,25.4,6.32,18.45]
[2019,1,28,10,43493.416666665071,3.14,"Valid",18.489999999999998,15.32,"Valid",25.48,null,null,3.14,18.489999999999998,15.32,25.48,15.32,25.48,3.14,18.489999999999998]
[2019,1,28,11,43493.458333331735,2.56,"Valid",18.28,13.35,"Valid",25.35,null,null,2.56,18.28,13.35,25.35,13.35,25.35,2.56,18.28]
[2019,1,28,12,43493.499999998399,2.9,"Valid",17.91,13.06,"Valid",25.07,null,null,2.9,17.91,13.06,25.07,13.06,25.07,2.9,17.91]
[2019,1,28,13,43493.541666665064,2.89,"Valid",17.149999999999999,14.33,"Valid",24.49,null,null,2.89,17.149999999999999,14.33,24.49,14.33,24.49,2.89,17.149999999999999]
[2019,1,28,14,43493.583333331728,10.34,"Valid",17.18,23.25,"Valid",24.41,null,null,10.34,17.18,23.25,24.41,23.25,24.41,10.34,17.18]
[2019,1,28,15,43493.624999998392,20.95,"Valid",17.66,36.6,"Valid",24.82,null,null,20.95,17.66,36.6,24.82,36.6,24.82,20.95,17.66]
[2019,1,28,16,43493.666666665056,32.58,"Valid",17.36,44.49,"Valid",24.42,null,null,32.58,17.36,44.49,24.42,44.49,24.42,32.58,17.36]
[2019,{"$f":"B666","v":1},{"$f":"C643+1","v":28},17,43493.70833333172,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage.  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,28,18,43493.749999998385,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage.  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,28,19,43493.791666665049,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage.  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,28,20,43493.833333331713,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage.  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,28,21,43493.874999998377,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage.  <75% 24hr average data available",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,28,22,43493.916666665042,41.73,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},61.7,"Valid",19.07,null," <75% 24hr average data available",41.73,{"$error":"#N/A"},61.7,19.07,61.7,19.07,41.73]
[2019,1,28,23,43493.958333331706,8.99,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},24.95,"Valid",18.84,null," <75% 24hr average data available",8.99,{"$error":"#N/A"},24.95,18.84,24.95,18.84,8.99]
[2019,1,29,0,43493.99999999837,2.65,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},20.3,"Valid",19.78,null," <75% 24hr average data available",2.65,{"$error":"#N/A"},20.3,19.78,20.3,19.78,2.65]
[2019,1,29,1,43494.041666665034,-0.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},16.84,"Valid",19.73,null," <75% 24hr average data available",-0.16,{"$error":"#N/A"},16.84,19.73,16.84,19.73,-0.16]
[2019,1,29,2,43494.083333331699,6.67,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},23.64,"Valid",20.45,null," <75% 24hr average data available",6.67,{"$error":"#N/A"},23.64,20.45,23.64,20.45,6.67]
[2019,1,29,3,43494.124999998363,13.52,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},30.81,"Valid",21.21,null," <75% 24hr average data available",13.52,{"$error":"#N/A"},30.81,21.21,30.81,21.21,13.52]
[2019,1,29,4,43494.166666665027,14.19,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},35.270000000000003,"Valid",22.46,null," <75% 24hr average data available",14.19,{"$error":"#N/A"},35.270000000000003,22.46,35.270000000000003,22.46,14.19]
[2019,1,29,5,43494.208333331691,16.350000000000001,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},27.97,"Valid",23.65,null," <75% 24hr average data available",16.350000000000001,{"$error":"#N/A"},27.97,23.65,27.97,23.65,16.350000000000001]
[2019,1,29,6,43494.249999998356,17.11,"Valid",11.24,34.68,"Valid",25.21,null,null,17.11,11.24,34.68,25.21,34.68,25.21,17.11,11.24]
[2019,1,29,7,43494.29166666502,25.88,"Valid",12.01,42.53,"Valid",27.01,null,null,25.88,12.01,42.53,27.01,42.53,27.01,25.88,12.01]
[2019,1,29,8,43494.333333331684,23.02,"Valid",13.24,40.58,"Valid",28.31,null,null,23.02,13.24,40.58,28.31,40.58,28.31,23.02,13.24]
[2019,1,29,9,43494.374999998348,19.329999999999998,"Valid",13.93,33.75,"Valid",29.13,null,null,19.329999999999998,13.93,33.75,29.13,33.75,29.13,19.329999999999998,13.93]
[2019,1,29,10,43494.416666665013,35.14,"Valid",15.61,47.59,"Valid",30.83,null,null,35.14,15.61,47.59,30.83,47.59,30.83,35.14,15.61]
[2019,1,29,11,43494.458333331677,26.51,"Valid",16.87,38.06,"Valid",32.130000000000003,null,null,26.51,16.87,38.06,32.130000000000003,38.06,32.130000000000003,26.51,16.87]
[2019,1,29,12,43494.499999998341,14.03,"Valid",17.46,26.76,"Valid",32.85,null,null,14.03,17.46,26.76,32.85,26.76,32.85,14.03,17.46]
[2019,1,29,13,43494.541666665005,16.989999999999998,"Valid",18.2,30.43,"Valid",33.69,null,null,16.989999999999998,18.2,30.43,33.69,30.43,33.69,16.989999999999998,18.2]
[2019,1,29,14,43494.58333333167,11.9,"Valid",18.28,25.13,"Valid",33.79,null,null,11.9,18.28,25.13,33.79,25.13,33.79,11.9,18.28]
[2019,1,29,15,43494.624999998334,14.32,"Valid",17.93,28.92,"Valid",33.39,null,null,14.32,17.93,28.92,33.39,28.92,33.39,14.32,17.93]
[2019,1,29,16,43494.666666664998,26.66,"Valid",17.62,43.69,"Valid",33.35,null,null,26.66,17.62,43.69,33.35,43.69,33.35,26.66,17.62]
[2019,1,29,17,43494.708333331662,31.64,"Valid",18.32,47.13,"Valid",34.04,null,null,31.64,18.32,47.13,34.04,47.13,34.04,31.64,18.32]
[2019,1,29,18,43494.749999998327,37.89,"Valid",19.260000000000002,54.04,"Valid",34.99,null,null,37.89,19.260000000000002,54.04,34.99,54.04,34.99,37.89,19.260000000000002]
[2019,1,29,19,43494.791666664991,36.68,"Valid",20.05,47.17,"Valid",35.54,null,null,36.68,20.05,47.17,35.54,47.17,35.54,36.68,20.05]
[2019,1,29,20,43494.833333331655,43.51,"Valid",21.07,59.42,"Valid",36.58,null,null,43.51,21.07,59.42,36.58,59.42,36.58,43.51,21.07]
[2019,1,29,21,43494.874999998319,24.19,"Valid",21.2,42.24,"Valid",36.82,null,null,24.19,21.2,42.24,36.82,42.24,36.82,24.19,21.2]
[2019,1,29,22,43494.916666664983,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},3.6,"Valid",34.4,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},3.6,34.4,3.6,34.4]
[2019,1,29,23,43494.958333331648,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,30,0,43494.999999998312,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},9.5399999999999991,"Valid",34.340000000000003,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},9.5399999999999991,34.340000000000003,9.5399999999999991,34.340000000000003]
[2019,1,30,1,43495.041666664976,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2019,1,30,2,43495.08333333164,3.02,"Valid",22.59,12.57,"Valid",34.630000000000003,null,null,3.02,22.59,12.57,34.630000000000003,12.57,34.630000000000003,3.02,22.59]
[2019,1,30,3,43495.124999998305,8.07,"Valid",22.32,17.09,"Valid",34.01,null,null,8.07,22.32,17.09,34.01,17.09,34.01,8.07,22.32]
[2019,1,30,4,43495.166666664969,18.420000000000002,"Valid",22.53,29.76,"Valid",33.76,null,null,18.420000000000002,22.53,29.76,33.76,29.76,33.76,18.420000000000002,22.53]
[2019,1,30,5,43495.208333331633,23.74,"Valid",22.9,35.22,"Valid",34.090000000000003,null,null,23.74,22.9,35.22,34.090000000000003,35.22,34.090000000000003,23.74,22.9]
[2019,1,30,6,43495.249999998297,22.16,"Valid",23.16,35.31,"Valid",34.119999999999997,null,null,22.16,23.16,35.31,34.119999999999997,35.31,34.119999999999997,22.16,23.16]
[2019,1,30,7,43495.291666664962,20.48,"Valid",22.89,31.41,"Valid",33.61,null,null,20.48,22.89,31.41,33.61,31.41,33.61,20.48,22.89]
[2019,1,30,8,43495.333333331626,15.44,"Valid",22.51,29.27,"Valid",33.1,null,null,{"$f":"IF(G706=\"Valid\", F706, NA())","v":15.44},{"$f":"IF(G706=\"Valid\", H706, NA())","v":22.51},{"$f":"IF(J706=\"Valid\", I706, NA())","v":29.27},{"$f":"IF(J706=\"Valid\", K706, NA())","v":33.1},29.27,33.1,15.44,22.51]
[2019,1,30,9,43495.37499999829,16.88,"Valid",22.38,29.98,"Valid",32.92,null,null,16.88,22.38,29.98,32.92,29.98,32.92,16.88,22.38]
[{"$f":"A707","v":2019},1,30,{"$f":"IF(D707=23,0,D707+1)","v":10},{"$f":"E707+0.0416666666666666","v":43495.416666664954},12.59,"Valid",21.26,24.46,"Valid",31.87,null,null,12.59,21.26,24.46,31.87,24.46,31.87,12.59,21.26]
[2019,1,30,11,43495.458333331619,21.7,"Valid",21.02,34.29,"Valid",31.7,null,null,21.7,21.02,34.29,31.7,34.29,31.7,21.7,21.02]
[2019,1,30,12,43495.499999998283,3.45,"Valid",20.49,12.82,"Valid",31.07,null,null,3.45,20.49,12.82,31.07,12.82,31.07,3.45,20.49]
[2019,1,30,13,43495.541666664947,12.35,"Valid",20.25,21.85,"Valid",30.68,null,null,12.35,20.25,21.85,30.68,21.85,30.68,12.35,20.25]
[2019,1,30,14,43495.583333331611,3.25,"Valid",19.82,12.65,"Valid",30.11,null,null,3.25,19.82,12.65,30.11,12.65,30.11,3.25,19.82]
[2019,1,30,15,43495.624999998276,11.97,"Valid",19.7,21.29,"Valid",29.76,null,null,11.97,19.7,21.29,29.76,21.29,29.76,11.97,19.7]
[2019,1,30,16,43495.66666666494,6.94,"Valid",18.72,18.22,"Valid",28.61,null,null,6.94,18.72,18.22,28.61,18.22,28.61,6.94,18.72]
[2019,1,30,17,43495.708333331604,5.81,"Valid",17.43,15.35,"Valid",27.16,null,null,5.81,17.43,15.35,27.16,15.35,27.16,5.81,17.43]
[2019,1,30,18,43495.749999998268,6.82,"Valid",15.87,13.2,"Valid",25.31,null,null,6.82,15.87,13.2,25.31,13.2,25.31,6.82,15.87]
[2019,1,30,19,43495.791666664933,8.49,"Valid",14.46,17.21,"Valid",23.94,null,null,8.49,14.46,17.21,23.94,17.21,23.94,8.49,14.46]
[2019,1,30,20,43495.833333331597,6.76,"Valid",12.63,14.28,"Valid",21.89,null,null,6.76,12.63,14.28,21.89,14.28,21.89,6.76,12.63]
[2019,1,30,21,43495.874999998261,5.03,"Valid",11.67,13.32,"Valid",20.58,null,null,5.03,11.67,13.32,20.58,13.32,20.58,5.03,11.67]
[2019,1,30,22,43495.916666664925,7.26,"Valid",11.46,16.420000000000002,"Valid",21.16,null,null,7.26,11.46,16.420000000000002,21.16,16.420000000000002,21.16,7.26,11.46]
[2019,1,30,23,43495.95833333159,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},2.02,"Valid",20.329999999999998,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},2.02,20.329999999999998,2.02,20.329999999999998]
[2019,1,31,0,43495.999999998254,3.45,"Valid",11.09,12.59,"Valid",20.46,null,null,3.45,11.09,12.59,20.46,12.59,20.46,3.45,11.09]
[2019,1,31,1,43496.041666664918,1.97,"Valid",10.7,11.09,"Valid",20.07,null,null,1.97,10.7,11.09,20.07,11.09,20.07,1.97,10.7]
[2019,1,31,2,43496.083333331582,8.94,"Valid",10.96,17.5,"Valid",20.28,null,null,8.94,10.96,17.5,20.28,17.5,20.28,8.94,10.96]
[2019,1,31,3,43496.124999998246,4.62,"Valid",10.81,12.59,"Valid",20.09,null,null,4.62,10.81,12.59,20.09,12.59,20.09,4.62,10.81]
[2019,1,31,4,43496.166666664911,14.17,"Valid",10.62,24.03,"Valid",19.850000000000001,null,null,14.17,10.62,24.03,19.850000000000001,24.03,19.850000000000001,14.17,10.62]
[2019,1,31,5,43496.208333331575,8.35,"Valid",9.9499999999999993,19.22,"Valid",19.18,null,null,8.35,9.9499999999999993,19.22,19.18,19.22,19.18,8.35,9.9499999999999993]
[2019,1,31,6,43496.249999998239,9.9499999999999993,"Valid",9.42,19.34,"Valid",18.52,null,null,9.9499999999999993,9.42,19.34,18.52,19.34,18.52,9.9499999999999993,9.42]
[2019,1,31,7,43496.291666664903,9.1999999999999993,"Valid",8.93,19.600000000000001,"Valid",18.02,null,null,9.1999999999999993,8.93,19.600000000000001,18.02,19.600000000000001,18.02,9.1999999999999993,8.93]
[2019,1,31,8,43496.333333331568,1.93,"Valid",8.34,13.8,"Valid",17.38,null,null,1.93,8.34,13.8,17.38,13.8,17.38,1.93,8.34]
[2019,{"$f":"B730","v":1},{"$f":"C707+1","v":31},9,43496.374999998232,7.38,"Valid",7.93,17.84,"Valid",16.87,null,null,7.38,7.93,17.84,16.87,17.84,16.87,7.38,7.93]
[2019,1,31,10,43496.416666664896,8.36,"Valid",7.75,18.45,"Valid",16.62,null,null,8.36,7.75,18.45,16.62,18.45,16.62,8.36,7.75]
[2019,1,31,11,43496.45833333156,8.5399999999999991,"Valid",7.17,20.8,"Valid",16.059999999999999,null,null,8.5399999999999991,7.17,20.8,16.059999999999999,20.8,16.059999999999999,8.5399999999999991,7.17]
[2019,1,31,12,43496.499999998225,1.28,"Valid",7.08,11.12,"Valid",15.99,null,null,1.28,7.08,11.12,15.99,11.12,15.99,1.28,7.08]
[2019,1,31,13,43496.541666664889,4.38,"Valid",6.73,13.38,"Valid",15.64,null,null,4.38,6.73,13.38,15.64,13.38,15.64,4.38,6.73]
[2019,1,31,14,43496.583333331553,10.16,"Valid",7.03,20.12,"Valid",15.95,null,null,10.16,7.03,20.12,15.95,20.12,15.95,10.16,7.03]
[2019,1,31,15,43496.624999998217,4.7300000000000004,"Valid",6.72,13.96,"Valid",15.64,null,null,4.7300000000000004,6.72,13.96,15.64,13.96,15.64,4.7300000000000004,6.72]
[2019,1,31,16,43496.666666664882,9.09,"Valid",6.81,19.21,"Valid",15.69,null,null,9.09,6.81,19.21,15.69,19.21,15.69,9.09,6.81]
[2019,1,31,17,43496.708333331546,8.39,"Valid",6.92,17.8,"Valid",15.79,null,null,8.39,6.92,17.8,15.79,17.8,15.79,8.39,6.92]
[2019,1,31,18,43496.74999999821,12.44,"Valid",7.17,22.68,"Valid",16.18,null,null,12.44,7.17,22.68,16.18,22.68,16.18,12.44,7.17]
[2019,1,31,19,43496.791666664874,2.46,"Valid",6.91,12.38,"Valid",15.98,null,null,2.46,6.91,12.38,15.98,12.38,15.98,2.46,6.91]
[2019,1,31,20,43496.833333331539,4.08,"Valid",6.79,11.86,"Valid",15.88,null,null,4.08,6.79,11.86,15.88,11.86,15.88,4.08,6.79]
[2019,1,31,21,43496.874999998203,null,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},3.06,"Valid",15.45,"Pump Failure","High negative removed",{"$error":"#N/A"},{"$error":"#N/A"},3.06,15.45,3.06,15.45]
[2019,1,31,22,43496.916666664867,8.4600000000000009,"Valid",6.92,18.68,"Valid",15.55,null,null,8.4600000000000009,6.92,18.68,15.55,18.68,15.55,8.4600000000000009,6.92]
[2019,1,31,23,43496.958333331531,3.75,"Valid",6.79,13.94,"Valid",16.04,null,null,3.75,6.79,13.94,16.04,13.94,16.04,3.75,6.79]

{"sheet":"Raw data_format","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Parameter","Format","Comment","Units of measure","Minimum","Maximum"]
["Year","yyyy","4 integer format","Not applicable",2015,"Until reporting ceases"]
["Month","mm","2 integer format","Not applicable",1,12]
["Day","dd","2 integer format","Not applicable",1,31]
["Hour","hh","2 integer format","Not applicable",0,23]
["PM10",0,"1 decimal place resolution","µg/m3","Negative","Instrument specific"]
["PM2.5",0,"2 decimal place resolution","µg/m3","Negative","Instrument specific"]
["Status","Text","7 character format","Not applicable","Valid","Invalid"]