{"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)","2020-08-01"]
["Easting",{"$f":"VLOOKUP($B$2,'Meta data_lookup'!$A$2:$D$5,2,FALSE)","v":237993},null,"PM2.5 monitoring end","2020-09-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":473}]
["Description of surrounding land use","Agriculture",null,"Proportion of valid PM2.5 results (%)",{"$f":"E5/E4","v":0.635752688172043}]
["Typical sources impacting on the site","Agriculture/Gravel roads",null,"PM10 monitoring start (dd/mm/yyyy hh:mm)","2020-08-01"]
["Site compliance with AS/NZS 3580.1.1:2007","Yes",null,"PM10 monitoring end","2020-09-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":475}]
["PM2.5 instrument model","1405DF",null,"Proportion of valid PM10 results (%)",{"$f":"E10/E9","v":0.63844086021505375}]
["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"]
[2020,8,1,0,{"$f":"DATE(A2,B2,C2)+TIME(D2,0,0)","v":44044},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$f":"IF(G2=\"Valid\", F2, NA())","v":{"$error":"#N/A"}},{"$f":"IF(G2=\"Valid\", H2, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J2=\"Valid\", I2, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J2=\"Valid\", K2, NA())","v":{"$error":"#N/A"}}]
[{"$f":"A2","v":2020},{"$f":"B2","v":8},{"$f":"C2","v":1},{"$f":"IF(D2=23,0,D2+1)","v":1},{"$f":"E2+0.0416666666666666","v":44044.041666666664},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A3","v":2020},{"$f":"B3","v":8},1,{"$f":"IF(D3=23,0,D3+1)","v":2},{"$f":"E3+0.0416666666666666","v":44044.083333333328},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,3,44044.124999999993,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,4,44044.166666666657,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,5,44044.208333333321,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,6,44044.249999999985,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,7,44044.29166666665,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,8,44044.333333333314,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,9,44044.374999999978,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,10,44044.416666666642,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,11,44044.458333333307,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,12,44044.499999999971,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,13,44044.541666666635,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,14,44044.583333333299,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,15,44044.624999999964,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,16,44044.666666666628,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,17,44044.708333333292,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,18,44044.749999999956,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,19,44044.791666666621,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,20,44044.833333333285,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,21,44044.874999999949,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,1,22,44044.916666666613,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,{"$f":"B24","v":8},{"$f":"C24","v":1},23,44044.958333333278,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,{"$f":"B25","v":8},{"$f":"C2+1","v":2},0,44044.999999999942,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,{"$f":"B26","v":8},{"$f":"C3+1","v":2},1,44045.041666666606,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,2,44045.08333333327,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,3,44045.124999999935,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,4,44045.166666666599,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,5,44045.208333333263,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,6,44045.249999999927,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,7,44045.291666666591,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,8,44045.333333333256,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,9,44045.37499999992,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,10,44045.416666666584,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,11,44045.458333333248,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,12,44045.499999999913,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,13,44045.541666666577,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,14,44045.583333333241,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,15,44045.624999999905,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,16,44045.66666666657,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,17,44045.708333333234,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,18,44045.749999999898,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,19,44045.791666666562,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,20,44045.833333333227,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,21,44045.874999999891,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,22,44045.916666666555,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,2,23,44045.958333333219,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,0,44045.999999999884,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,1,44046.041666666548,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,2,44046.083333333212,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,3,44046.124999999876,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,4,44046.166666666541,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,5,44046.208333333205,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,6,44046.249999999869,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,7,44046.291666666533,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,8,44046.333333333198,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,9,44046.374999999862,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,10,44046.416666666526,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,11,44046.45833333319,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,12,44046.499999999854,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,13,44046.541666666519,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,14,44046.583333333183,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,15,44046.624999999847,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,16,44046.666666666511,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$f":"IF(G66=\"Valid\", F66, NA())","v":{"$error":"#N/A"}},{"$f":"IF(G66=\"Valid\", H66, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J66=\"Valid\", I66, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J66=\"Valid\", K66, NA())","v":{"$error":"#N/A"}}]
[2020,8,3,17,44046.708333333176,{"$error":"#N/A"},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A67","v":2020},8,3,{"$f":"IF(D67=23,0,D67+1)","v":18},{"$f":"E67+0.0416666666666666","v":44046.74999999984},136.94,"Invalid",{"$error":"#N/A"},126.06,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,19,44046.791666666504,12.22,"Invalid",{"$error":"#N/A"},13.42,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,20,44046.833333333168,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,21,44046.874999999833,71.03,"Invalid",{"$error":"#N/A"},66.95,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,22,44046.916666666497,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,3,23,44046.958333333161,25.43,"Invalid",{"$error":"#N/A"},24.26,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,0,44046.999999999825,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,1,44047.04166666649,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,2,44047.083333333154,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,3,44047.124999999818,41.84,"Invalid",{"$error":"#N/A"},39.26,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,4,44047.166666666482,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,5,44047.208333333147,-2.16,"Invalid",{"$error":"#N/A"},-1.05,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,6,44047.249999999811,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,7,44047.291666666475,38.01,"Invalid",{"$error":"#N/A"},35.39,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,8,44047.333333333139,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,9,44047.374999999804,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,10,44047.416666666468,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,11,44047.458333333132,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,12,44047.499999999796,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,13,44047.541666666461,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,14,44047.583333333125,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,15,44047.624999999789,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,16,44047.666666666453,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,{"$f":"B90","v":8},{"$f":"C67+1","v":4},17,44047.708333333117,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,18,44047.749999999782,12.33,"Invalid",{"$error":"#N/A"},15.32,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,19,44047.791666666446,3.07,"Invalid",{"$error":"#N/A"},5.57,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,20,44047.83333333311,21.7,"Invalid",{"$error":"#N/A"},22.18,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,21,44047.874999999774,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,22,44047.916666666439,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,4,23,44047.958333333103,19.66,"Invalid",{"$error":"#N/A"},19.57,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,0,44047.999999999767,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,1,44048.041666666431,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,2,44048.083333333096,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,3,44048.12499999976,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,4,44048.166666666424,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,5,44048.208333333088,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,6,44048.249999999753,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,7,44048.291666666417,7.77,"Invalid",{"$error":"#N/A"},8.16,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,8,44048.333333333081,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,9,44048.374999999745,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,10,44048.41666666641,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,11,44048.458333333074,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,12,44048.499999999738,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,13,44048.541666666402,5.51,"Invalid",{"$error":"#N/A"},6.78,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,14,44048.583333333067,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,15,44048.624999999731,14.63,"Invalid",{"$error":"#N/A"},15.26,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,16,44048.666666666395,22.4,"Invalid",{"$error":"#N/A"},21.98,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,17,44048.708333333059,9.65,"Invalid",{"$error":"#N/A"},10.92,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,18,44048.749999999724,5.52,"Invalid",{"$error":"#N/A"},7.9,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,19,44048.791666666388,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,20,44048.833333333052,16.3,"Invalid",{"$error":"#N/A"},16.34,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,21,44048.874999999716,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,22,44048.91666666638,23.02,"Invalid",{"$error":"#N/A"},21.99,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,5,23,44048.958333333045,33.22,"Invalid",{"$error":"#N/A"},31.23,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,0,44048.999999999709,26.14,"Invalid",{"$error":"#N/A"},25.31,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,1,44049.041666666373,15.3,"Invalid",{"$error":"#N/A"},14.98,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,2,44049.083333333037,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,3,44049.124999999702,11.49,"Invalid",{"$error":"#N/A"},11.21,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,4,44049.166666666366,27.9,"Invalid",{"$error":"#N/A"},25.73,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,5,44049.20833333303,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,6,44049.249999999694,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,7,44049.291666666359,18.72,"Invalid",{"$error":"#N/A"},18.37,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,8,44049.333333333023,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$f":"IF(G130=\"Valid\", F130, NA())","v":{"$error":"#N/A"}},{"$f":"IF(G130=\"Valid\", H130, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J130=\"Valid\", I130, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J130=\"Valid\", K130, NA())","v":{"$error":"#N/A"}}]
[2020,8,6,9,44049.374999999687,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A131","v":2020},8,6,{"$f":"IF(D131=23,0,D131+1)","v":10},{"$f":"E131+0.0416666666666666","v":44049.416666666351},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,11,44049.458333333016,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,12,44049.49999999968,5,"Invalid",{"$error":"#N/A"},7.56,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,13,44049.541666666344,0.43,"Invalid",{"$error":"#N/A"},3.07,"Invalid",{"$error":"#N/A"},"Calibration Error","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,14,44049.583333333008,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,15,44049.624999999673,49.09,"Invalid",{"$error":"#N/A"},45.29,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,16,44049.666666666337,47.51,"Invalid",{"$error":"#N/A"},45.83,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,17,44049.708333333001,20.8,"Invalid",{"$error":"#N/A"},22.74,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,18,44049.749999999665,15.4,"Invalid",{"$error":"#N/A"},18.809999999999999,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,19,44049.79166666633,26.14,"Invalid",{"$error":"#N/A"},27.72,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,20,44049.833333332994,16.37,"Invalid",{"$error":"#N/A"},18.63,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,21,44049.874999999658,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,22,44049.916666666322,7.08,"Invalid",{"$error":"#N/A"},9.18,"Invalid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,6,23,44049.958333332987,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,0,44049.999999999651,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,1,44050.041666666315,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,2,44050.083333332979,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Valid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,3,44050.124999999643,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,4,44050.166666666308,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,5,44050.208333332972,8.48,"Valid",{"$error":"#N/A"},10.55,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",8.48,{"$error":"#N/A"},10.55,{"$error":"#N/A"},10.55,null,8.48]
[2020,8,7,6,44050.249999999636,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,7,44050.2916666663,23.99,"Valid",{"$error":"#N/A"},24.47,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",23.99,{"$error":"#N/A"},24.47,{"$error":"#N/A"},24.47,null,23.99]
[2020,8,7,8,44050.333333332965,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","TEOM Calibration, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,{"$f":"B154","v":8},{"$f":"C131+1","v":7},9,44050.374999999629,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","TEOM Calibration, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,10,44050.416666666293,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","TEOM Calibration, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,11,44050.458333332957,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","TEOM Calibration, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,12,44050.499999999622,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","TEOM Calibration, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,13,44050.541666666286,-1.84,"Valid",{"$error":"#N/A"},0.46,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",-1.84,{"$error":"#N/A"},0.46,{"$error":"#N/A"},0.46,null,-1.84]
[2020,8,7,14,44050.58333333295,5,"Valid",{"$error":"#N/A"},7.3,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",5,{"$error":"#N/A"},7.3,{"$error":"#N/A"},7.3,null,5]
[2020,8,7,15,44050.624999999614,33.11,"Valid",{"$error":"#N/A"},34.979999999999997,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",33.11,{"$error":"#N/A"},34.979999999999997,{"$error":"#N/A"},34.979999999999997,null,33.11]
[2020,8,7,16,44050.666666666279,5.83,"Valid",{"$error":"#N/A"},6.18,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",5.83,{"$error":"#N/A"},6.18,{"$error":"#N/A"},6.18,null,5.83]
[2020,8,7,17,44050.708333332943,9.57,"Valid",{"$error":"#N/A"},10.31,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",9.57,{"$error":"#N/A"},10.31,{"$error":"#N/A"},10.31,null,9.57]
[2020,8,7,18,44050.749999999607,0.34,"Valid",{"$error":"#N/A"},0.2,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",0.34,{"$error":"#N/A"},0.2,{"$error":"#N/A"},0.2,null,0.34]
[2020,8,7,19,44050.791666666271,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Valid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,7,20,44050.833333332936,5.64,"Valid",{"$error":"#N/A"},8.6300000000000008,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",5.64,{"$error":"#N/A"},8.6300000000000008,{"$error":"#N/A"},8.6300000000000008,null,5.64]
[2020,8,7,21,44050.8749999996,2.09,"Valid",{"$error":"#N/A"},6.62,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",2.09,{"$error":"#N/A"},6.62,{"$error":"#N/A"},6.62,null,2.09]
[2020,8,7,22,44050.916666666264,4.83,"Valid",{"$error":"#N/A"},5.37,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",4.83,{"$error":"#N/A"},5.37,{"$error":"#N/A"},5.37,null,4.83]
[2020,8,7,23,44050.958333332928,-0.79,"Valid",{"$error":"#N/A"},0.31,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",-0.79,{"$error":"#N/A"},0.31,{"$error":"#N/A"},0.31,null,-0.79]
[2020,8,8,0,44050.999999999593,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,8,1,44051.041666666257,8.24,"Valid",{"$error":"#N/A"},8.36,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",8.24,{"$error":"#N/A"},8.36,{"$error":"#N/A"},8.36,null,8.24]
[2020,8,8,2,44051.083333332921,4.7699999999999996,"Valid",{"$error":"#N/A"},4.99,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",4.7699999999999996,{"$error":"#N/A"},4.99,{"$error":"#N/A"},4.99,null,4.7699999999999996]
[2020,8,8,3,44051.124999999585,2.65,"Valid",{"$error":"#N/A"},2.8,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",2.65,{"$error":"#N/A"},2.8,{"$error":"#N/A"},2.8,null,2.65]
[2020,8,8,4,44051.16666666625,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,8,5,44051.208333332914,2.31,"Valid",{"$error":"#N/A"},3.15,"Valid",{"$error":"#N/A"},"              ","<18hrs of 1hr data for 24hr rolling average",2.31,{"$error":"#N/A"},3.15,{"$error":"#N/A"},3.15,null,2.31]
[2020,8,8,6,44051.249999999578,6.56,"Valid",{"$error":"#N/A"},6.09,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.56,{"$error":"#N/A"},6.09,{"$error":"#N/A"},6.09,null,6.56]
[2020,8,8,7,44051.291666666242,-2.23,"Valid",{"$error":"#N/A"},-1.27,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-2.23,{"$error":"#N/A"},-1.27,{"$error":"#N/A"},-1.27,null,-2.23]
[2020,8,8,8,44051.333333332906,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,8,9,44051.374999999571,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,8,10,44051.416666666235,1.76,"Valid",{"$error":"#N/A"},1.62,"Valid",3.6680952380952387,"              ","<18hrs of 1hr data for 24hr rolling average",1.76,{"$error":"#N/A"},1.62,3.6680952380952387,1.62,3.6680952380952387,1.76]
[2020,8,8,11,44051.458333332899,3.91,"Valid",5.0972222222222223,5.67,"Valid",3.7590909090909097,"","",3.91,5.0972222222222223,5.67,3.7590909090909097,5.67,3.7590909090909097,3.91,5.0972222222222223]
[2020,8,8,12,44051.499999999563,0.13,"Valid",4.8357894736842102,1.66,"Valid",3.6678260869565222,"","",0.13,4.8357894736842102,1.66,3.6678260869565222,1.66,3.6678260869565222,0.13,4.8357894736842102]
[2020,8,8,13,44051.541666666228,3.16,"Valid",5.0989473684210518,4.2300000000000004,"Valid",3.8317391304347836,"","",3.16,5.0989473684210518,4.2300000000000004,3.8317391304347836,4.2300000000000004,3.8317391304347836,3.16,5.0989473684210518]
[2020,8,8,14,44051.583333332892,-1.18,"Valid",4.7736842105263149,-0.78,"Valid",3.4804347826086963,"","",-1.18,4.7736842105263149,-0.78,3.4804347826086963,-0.78,3.4804347826086963,-1.18,4.7736842105263149]
[2020,8,8,15,44051.624999999556,-1.46,"Valid",2.9542105263157898,-1.24,"Valid",1.9056521739130432,"","",-1.46,2.9542105263157898,-1.24,1.9056521739130432,-1.24,1.9056521739130432,-1.46,2.9542105263157898]
[2020,8,8,16,44051.66666666622,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,8,17,44051.708333332885,1.7,"Valid",2.3572222222222226,0.63,"Valid",0.95173913043478275,"","",1.7,2.3572222222222226,0.63,0.95173913043478275,0.63,0.95173913043478275,1.7,2.3572222222222226]
[2020,8,8,18,44051.749999999549,14.69,"Valid",3.1544444444444446,23.21,"Valid",1.9521739130434785,"","",14.69,3.1544444444444446,23.21,1.9521739130434785,23.21,1.9521739130434785,14.69,3.1544444444444446]
[2020,8,8,19,44051.791666666213,-1.81,"Valid",2.8931578947368419,7.0000000000000007E-2,"Valid",2.3726086956521732,"","",-1.81,2.8931578947368419,7.0000000000000007E-2,2.3726086956521732,7.0000000000000007E-2,2.3726086956521732,-1.81,2.8931578947368419]
[2020,8,8,20,44051.833333332877,-0.48,"Valid",2.5710526315789473,-1.33,"Valid",1.9395652173913047,"","",-0.48,2.5710526315789473,-1.33,1.9395652173913047,-1.33,1.9395652173913047,-0.48,2.5710526315789473]
[2020,8,8,21,44051.874999999542,9.82,"Valid",2.9778947368421052,13.89,"Valid",2.255652173913044,"","",9.82,2.9778947368421052,13.89,2.255652173913044,13.89,2.255652173913044,9.82,2.9778947368421052]
[2020,8,8,22,44051.916666666206,3.83,"Valid",2.9252631578947366,3.87,"Valid",2.1904347826086963,"","",3.83,2.9252631578947366,3.87,2.1904347826086963,3.87,2.1904347826086963,3.83,2.9252631578947366]
[2020,8,8,23,44051.95833333287,1.06,"Valid",3.0226315789473683,1.17,"Valid",2.2278260869565218,"","",1.06,3.0226315789473683,1.17,2.2278260869565218,1.17,2.2278260869565218,1.06,3.0226315789473683]
[2020,8,9,0,44051.999999999534,4.13,"Valid",3.0780000000000003,4.3499999999999996,"Valid",2.3162500000000001,"","",{"$f":"IF(G194=\"Valid\", F194, NA())","v":4.13},{"$f":"IF(G194=\"Valid\", H194, NA())","v":3.0780000000000003},{"$f":"IF(J194=\"Valid\", I194, NA())","v":4.3499999999999996},{"$f":"IF(J194=\"Valid\", K194, NA())","v":2.3162500000000001},4.3499999999999996,2.3162500000000001,4.13,3.0780000000000003]
[2020,8,9,1,44052.041666666199,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A195","v":2020},8,9,{"$f":"IF(D195=23,0,D195+1)","v":2},{"$f":"E195+0.0416666666666666","v":44052.083333332863},-2.1,"Valid",2.4447368421052631,-2.4500000000000002,"Valid",1.405,"","",-2.1,2.4447368421052631,-2.4500000000000002,1.405,-2.4500000000000002,1.405,-2.1,2.4447368421052631]
[2020,8,9,3,44052.124999999527,0.36,"Valid",2.3242105263157895,1.58,"Valid",1.354166666666667,"","",0.36,2.3242105263157895,1.58,1.354166666666667,1.58,1.354166666666667,0.36,2.3242105263157895]
[2020,8,9,4,44052.166666666191,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,9,5,44052.208333332856,8.7100000000000009,"Valid",2.6610526315789476,10.56,"Valid",1.69625,"","",8.7100000000000009,2.6610526315789476,10.56,1.69625,10.56,1.69625,8.7100000000000009,2.6610526315789476]
[2020,8,9,6,44052.24999999952,11.43,"Valid",2.9173684210526321,16.329999999999998,"Valid",2.1229166666666672,"","",11.43,2.9173684210526321,16.329999999999998,2.1229166666666672,16.329999999999998,2.1229166666666672,11.43,2.9173684210526321]
[2020,8,9,7,44052.291666666184,3.28,"Valid",3.2073684210526316,3.06,"Valid",2.3033333333333337,"","",3.28,3.2073684210526316,3.06,2.3033333333333337,3.06,2.3033333333333337,3.28,3.2073684210526316]
[2020,8,9,8,44052.333333332848,1.03,"Valid",3.0985000000000005,1.65,"Valid",2.5908333333333333,"","",1.03,3.0985000000000005,1.65,2.5908333333333333,1.65,2.5908333333333333,1.03,3.0985000000000005]
[2020,8,9,9,44052.374999999513,2.9,"Valid",3.0890476190476193,5.8,"Valid",3.155416666666667,"","",2.9,3.0890476190476193,5.8,3.155416666666667,5.8,3.155416666666667,2.9,3.0890476190476193]
[2020,8,9,10,44052.416666666177,4.43,"Valid",3.2161904761904765,3.97,"Valid",3.2533333333333334,"","",4.43,3.2161904761904765,3.97,3.2533333333333334,3.97,3.2533333333333334,4.43,3.2161904761904765]
[2020,8,9,11,44052.458333332841,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,9,12,44052.499999999505,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,9,13,44052.541666666169,0.49,"Valid",3.2015789473684211,0.91,"Valid",2.3037500000000004,"","",0.49,3.2015789473684211,0.91,2.3037500000000004,0.91,2.3037500000000004,0.49,3.2015789473684211]
[2020,8,9,14,44052.583333332834,1.46,"Valid",3.3405263157894738,1.48,"Valid",2.3979166666666663,"","",1.46,3.3405263157894738,1.48,2.3979166666666663,1.48,2.3979166666666663,1.46,3.3405263157894738]
[2020,8,9,15,44052.624999999498,-1.73,"Valid",3.3263157894736839,-0.65,"Valid",2.4224999999999999,"","",-1.73,3.3263157894736839,-0.65,2.4224999999999999,-0.65,2.4224999999999999,-1.73,3.3263157894736839]
[2020,8,9,16,44052.666666666162,1.5,"Valid",3.2349999999999994,1.99,"Valid",2.7587499999999991,"","",1.5,3.2349999999999994,1.99,2.7587499999999991,1.99,2.7587499999999991,1.5,3.2349999999999994]
[2020,8,9,17,44052.708333332826,1.59,"Valid",3.2295000000000003,1.29,"Valid",2.7862500000000003,"","",1.59,3.2295000000000003,1.29,2.7862500000000003,1.29,2.7862500000000003,1.59,3.2295000000000003]
[2020,8,9,18,44052.749999999491,1.91,"Valid",2.5905000000000005,2.69,"Valid",1.9312499999999997,"","",1.91,2.5905000000000005,2.69,1.9312499999999997,2.69,1.9312499999999997,1.91,2.5905000000000005]
[2020,8,9,19,44052.791666666155,1.1100000000000001,"Valid",2.7365000000000004,1.38,"Valid",1.9858333333333331,"","",1.1100000000000001,2.7365000000000004,1.38,1.9858333333333331,1.38,1.9858333333333331,1.1100000000000001,2.7365000000000004]
[2020,8,9,20,44052.833333332819,5.27,"Valid",3.024,4.3,"Valid",2.2204166666666665,"","",5.27,3.024,4.3,2.2204166666666665,4.3,2.2204166666666665,5.27,3.024]
[2020,8,9,21,44052.874999999483,0.87,"Valid",2.5765000000000002,1.06,"Valid",1.6858333333333331,"","",0.87,2.5765000000000002,1.06,1.6858333333333331,1.06,1.6858333333333331,0.87,2.5765000000000002]
[2020,8,9,22,44052.916666666148,1.86,"Valid",2.4780000000000006,2.1,"Valid",1.6120833333333333,"","",1.86,2.4780000000000006,2.1,1.6120833333333333,2.1,1.6120833333333333,1.86,2.4780000000000006]
[2020,8,9,23,44052.958333332812,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,10,0,44052.999999999476,2.57,"Valid",2.4705263157894737,2.0699999999999998,"Valid",1.3837499999999998,"","",2.57,2.4705263157894737,2.0699999999999998,1.3837499999999998,2.0699999999999998,1.3837499999999998,2.57,2.4705263157894737]
[2020,{"$f":"B218","v":8},{"$f":"C195+1","v":10},1,44053.04166666614,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,10,2,44053.083333332805,5.89,"Valid",2.8910526315789475,5.31,"Valid",1.7879166666666666,"","",5.89,2.8910526315789475,5.31,1.7879166666666666,5.31,1.7879166666666666,5.89,2.8910526315789475]
[2020,8,10,3,44053.124999999469,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,10,4,44053.166666666133,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,10,5,44053.208333332797,-1.94,"Valid",2.4399999999999995,-2.5099999999999998,"Valid",0.99583333333333324,"","",-1.94,2.4399999999999995,-2.5099999999999998,0.99583333333333324,-2.5099999999999998,0.99583333333333324,-1.94,2.4399999999999995]
[2020,8,10,6,44053.249999999462,6.76,"Valid",2.1805555555555554,5.83,"Valid",0.55833333333333324,"","",6.76,2.1805555555555554,5.83,0.55833333333333324,5.83,0.55833333333333324,6.76,2.1805555555555554]
[2020,8,10,7,44053.291666666126,6.61,"Valid",2.3655555555555554,6.3,"Valid",0.69333333333333336,"","",6.61,2.3655555555555554,6.3,0.69333333333333336,6.3,0.69333333333333336,6.61,2.3655555555555554]
[2020,8,10,8,44053.33333333279,2.33,"Valid",2.4377777777777774,1.99,"Valid",0.70749999999999991,"","",2.33,2.4377777777777774,1.99,0.70749999999999991,1.99,0.70749999999999991,2.33,2.4377777777777774]
[2020,8,10,9,44053.374999999454,-0.14000000000000001,"Valid",2.2688888888888887,0.72,"Valid",0.4958333333333334,"","",-0.14000000000000001,2.2688888888888887,0.72,0.4958333333333334,0.72,0.4958333333333334,-0.14000000000000001,2.2688888888888887]
[2020,8,10,10,44053.416666666119,3.56,"Valid",2.2205555555555554,3.97,"Valid",0.49583333333333335,"","",3.56,2.2205555555555554,3.97,0.49583333333333335,3.97,0.49583333333333335,3.56,2.2205555555555554]
[2020,8,10,11,44053.458333332783,0.28000000000000003,"Valid",2.1184210526315788,0.45,"Valid",0.74791666666666667,"","",0.28000000000000003,2.1184210526315788,0.45,0.74791666666666667,0.45,0.74791666666666667,0.28000000000000003,2.1184210526315788]
[2020,8,10,12,44053.499999999447,5.1100000000000003,"Valid",2.2679999999999998,5.57,"Valid",1.2524999999999997,"","",5.1100000000000003,2.2679999999999998,5.57,1.2524999999999997,5.57,1.2524999999999997,5.1100000000000003,2.2679999999999998]
[2020,8,10,13,44053.541666666111,-1.95,"Valid",2.1459999999999999,0.4,"Valid",1.2312499999999997,"","",-1.95,2.1459999999999999,0.4,1.2312499999999997,0.4,1.2312499999999997,-1.95,2.1459999999999999]
[2020,8,10,14,44053.583333332776,3.91,"Valid",2.2684999999999995,8.18,"Valid",1.5104166666666663,"","",3.91,2.2684999999999995,8.18,1.5104166666666663,8.18,1.5104166666666663,3.91,2.2684999999999995]
[2020,8,10,15,44053.62499999944,2.62,"Valid",2.4859999999999998,7.67,"Valid",1.857083333333333,"","",2.62,2.4859999999999998,7.67,1.857083333333333,7.67,1.857083333333333,2.62,2.4859999999999998]
[2020,8,10,16,44053.666666666104,5.81,"Valid",2.7014999999999998,9.3000000000000007,"Valid",2.1616666666666666,"","",5.81,2.7014999999999998,9.3000000000000007,2.1616666666666666,9.3000000000000007,2.1616666666666666,5.81,2.7014999999999998]
[2020,8,10,17,44053.708333332768,8.8800000000000008,"Valid",3.0659999999999998,11.84,"Valid",2.6012500000000003,"","",8.8800000000000008,3.0659999999999998,11.84,2.6012500000000003,11.84,2.6012500000000003,8.8800000000000008,3.0659999999999998]
[2020,8,10,18,44053.749999999432,-0.55000000000000004,"Valid",2.9430000000000001,2,"Valid",2.5725000000000002,"","",-0.55000000000000004,2.9430000000000001,2,2.5725000000000002,2,2.5725000000000002,-0.55000000000000004,2.9430000000000001]
[2020,8,10,19,44053.791666666097,7.26,"Valid",3.2505000000000002,8.77,"Valid",2.8804166666666666,"","",7.26,3.2505000000000002,8.77,2.8804166666666666,8.77,2.8804166666666666,7.26,3.2505000000000002]
[2020,8,10,20,44053.833333332761,4.3899999999999997,"Valid",3.2064999999999997,6.36,"Valid",2.9662500000000001,"","",4.3899999999999997,3.2064999999999997,6.36,2.9662500000000001,6.36,2.9662500000000001,4.3899999999999997,3.2064999999999997]
[2020,8,10,21,44053.874999999425,5.76,"Valid",3.4510000000000005,7.25,"Valid",3.2241666666666666,"","",5.76,3.4510000000000005,7.25,3.2241666666666666,7.25,3.2241666666666666,5.76,3.4510000000000005]
[2020,8,10,22,44053.916666666089,1.25,"Valid",3.4204999999999997,2.83,"Valid",3.2545833333333332,"","",1.25,3.4204999999999997,2.83,3.2545833333333332,2.83,3.2545833333333332,1.25,3.4204999999999997]
[2020,8,10,23,44053.958333332754,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,0,44053.999999999418,0.19,"Valid",3.3014999999999999,1.88,"Valid",3.2570833333333327,"","",0.19,3.3014999999999999,1.88,3.2570833333333327,1.88,3.2570833333333327,0.19,3.3014999999999999]
[2020,8,11,1,44054.041666666082,2.0699999999999998,"Valid",3.2428571428571424,4.0999999999999996,"Valid",3.5999999999999996,"","",2.0699999999999998,3.2428571428571424,4.0999999999999996,3.5999999999999996,4.0999999999999996,3.5999999999999996,2.0699999999999998,3.2428571428571424]
[2020,8,11,2,44054.083333332746,-0.78,"Valid",2.9252380952380954,-0.08,"Valid",3.3754166666666663,"","",-0.78,2.9252380952380954,-0.08,3.3754166666666663,-0.08,3.3754166666666663,-0.78,2.9252380952380954]
[2020,8,11,3,44054.124999999411,5.98,"Valid",3.064090909090909,7.87,"Valid",3.9462499999999996,"","",5.98,3.064090909090909,7.87,3.9462499999999996,7.87,3.9462499999999996,5.98,3.064090909090909]
[2020,8,11,4,44054.166666666075,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,5,44054.208333332739,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,6,44054.249999999403,6,"Valid",3.2661904761904763,7.19,"Valid",3.7758333333333329,"","",6,3.2661904761904763,7.19,3.7758333333333329,7.19,3.7758333333333329,6,3.2661904761904763]
[2020,8,11,7,44054.291666666068,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,8,44054.333333332732,2.82,"Valid",3.1234999999999995,3.39,"Valid",3.4750000000000001,"","",2.82,3.1234999999999995,3.39,3.4750000000000001,3.39,3.4750000000000001,2.82,3.1234999999999995]
[2020,8,11,9,44054.374999999396,7.18,"Valid",3.4894999999999996,8.52,"Valid",3.8000000000000003,"","",7.18,3.4894999999999996,8.52,3.8000000000000003,8.52,3.8000000000000003,7.18,3.4894999999999996]
[2020,8,11,10,44054.41666666606,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,11,44054.458333332725,3.26,"Valid",3.6426315789473689,4.62,"Valid",3.580833333333334,"","",3.26,3.6426315789473689,4.62,3.580833333333334,4.62,3.580833333333334,3.26,3.6426315789473689]
[2020,8,11,12,44054.499999999389,8.39,"Valid",3.8152631578947371,7.81,"Valid",3.6741666666666668,"","",8.39,3.8152631578947371,7.81,3.6741666666666668,7.81,3.6741666666666668,8.39,3.8152631578947371]
[2020,8,11,13,44054.541666666053,7.73,"Valid",4.3247368421052634,8.24,"Valid",4.0008333333333335,"","",7.73,4.3247368421052634,8.24,4.0008333333333335,8.24,4.0008333333333335,7.73,4.3247368421052634]
[2020,8,11,14,44054.583333332717,2.7,"Valid",4.2610526315789476,4.5599999999999996,"Valid",3.85,"","",2.7,4.2610526315789476,4.5599999999999996,3.85,4.5599999999999996,3.85,2.7,4.2610526315789476]
[2020,8,11,15,44054.624999999382,1.17,"Valid",4.1847368421052638,1.65,"Valid",3.5991666666666666,"","",1.17,4.1847368421052638,1.65,3.5991666666666666,1.65,3.5991666666666666,1.17,4.1847368421052638]
[2020,8,11,16,44054.666666666046,4.6500000000000004,"Valid",4.1236842105263163,6.14,"Valid",3.4674999999999998,"","",{"$f":"IF(G258=\"Valid\", F258, NA())","v":4.6500000000000004},{"$f":"IF(G258=\"Valid\", H258, NA())","v":4.1236842105263163},{"$f":"IF(J258=\"Valid\", I258, NA())","v":6.14},{"$f":"IF(J258=\"Valid\", K258, NA())","v":3.4674999999999998},6.14,3.4674999999999998,4.6500000000000004,4.1236842105263163]
[2020,8,11,17,44054.70833333271,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A259","v":2020},8,11,{"$f":"IF(D259=23,0,D259+1)","v":18},{"$f":"E259+0.0416666666666666","v":44054.749999999374},-0.14000000000000001,"Valid",3.8822222222222229,1.39,"Valid",2.7954166666666662,"","",-0.14000000000000001,3.8822222222222229,1.39,2.7954166666666662,1.39,2.7954166666666662,-0.14000000000000001,3.8822222222222229]
[2020,8,11,19,44054.791666666039,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,20,44054.833333332703,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,11,21,44054.874999999367,9.14,"Valid",3.8506250000000004,8.4700000000000006,"Valid",1.9337500000000001,"","",9.14,3.8506250000000004,8.4700000000000006,1.9337500000000001,8.4700000000000006,1.9337500000000001,9.14,3.8506250000000004]
[2020,8,11,22,44054.916666666031,2.2799999999999998,"Valid",3.9150000000000005,1.77,"Valid",1.8895833333333336,"","",2.2799999999999998,3.9150000000000005,1.77,1.8895833333333336,1.77,1.8895833333333336,2.2799999999999998,3.9150000000000005]
[2020,8,11,23,44054.958333332695,4.8899999999999997,"Valid",3.9723529411764709,4.21,"Valid",2.1391666666666671,"","",4.8899999999999997,3.9723529411764709,4.21,2.1391666666666671,4.21,2.1391666666666671,4.8899999999999997,3.9723529411764709]
[2020,8,12,0,44054.99999999936,4.58,"Valid",4.2305882352941175,4.4800000000000004,"Valid",2.2475000000000005,"","",4.58,4.2305882352941175,4.4800000000000004,2.2475000000000005,4.4800000000000004,2.2475000000000005,4.58,4.2305882352941175]
[2020,8,12,1,44055.041666666024,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,12,2,44055.083333332688,2.5499999999999998,"Valid",4.5737499999999995,2.66,"Valid",2.1312500000000001,"","",2.5499999999999998,4.5737499999999995,2.66,2.1312500000000001,2.66,2.1312500000000001,2.5499999999999998,4.5737499999999995]
[2020,8,12,3,44055.124999999352,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,12,4,44055.166666666017,-0.96,"Valid",4.1400000000000006,-1.05,"Valid",2.037500000000001,"","",-0.96,4.1400000000000006,-1.05,2.037500000000001,-1.05,2.037500000000001,-0.96,4.1400000000000006]
[2020,8,12,5,44055.208333332681,7.65,"Valid",4.3464705882352952,7,"Valid",2.4687500000000004,"","",7.65,4.3464705882352952,7,2.4687500000000004,7,2.4687500000000004,7.65,4.3464705882352952]
[2020,8,12,6,44055.249999999345,1.52,"Valid",4.0829411764705883,2.27,"Valid",2.2637500000000004,"","",1.52,4.0829411764705883,2.27,2.2637500000000004,2.27,2.2637500000000004,1.52,4.0829411764705883]
[2020,8,12,7,44055.291666666009,2.2400000000000002,"Valid",3.9805555555555552,2.97,"Valid",2.4841666666666673,"","",2.2400000000000002,3.9805555555555552,2.97,2.4841666666666673,2.97,2.4841666666666673,2.2400000000000002,3.9805555555555552]
[2020,8,12,8,44055.333333332674,-2.0699999999999998,"Valid",3.7088888888888882,-1.41,"Valid",2.2841666666666671,"","",-2.0699999999999998,3.7088888888888882,-1.41,2.2841666666666671,-1.41,2.2841666666666671,-2.0699999999999998,3.7088888888888882]
[2020,8,12,9,44055.374999999338,1.04,"Valid",3.3677777777777775,2.27,"Valid",2.0237500000000002,"","",1.04,3.3677777777777775,2.27,2.0237500000000002,2.27,2.0237500000000002,1.04,3.3677777777777775]
[2020,8,12,10,44055.416666666002,1.5,"Valid",3.2694736842105261,3.98,"Valid",2.4170833333333337,"","",1.5,3.2694736842105261,3.98,2.4170833333333337,3.98,2.4170833333333337,1.5,3.2694736842105261]
[2020,8,12,11,44055.458333332666,10.06,"Valid",3.6273684210526316,10.99,"Valid",2.6825000000000006,"","",10.06,3.6273684210526316,10.99,2.6825000000000006,10.99,2.6825000000000006,10.06,3.6273684210526316]
[2020,8,12,12,44055.499999999331,7.11,"Valid",3.56,8.6999999999999993,"Valid",2.7195833333333339,"","",7.11,3.56,8.6999999999999993,2.7195833333333339,8.6999999999999993,2.7195833333333339,7.11,3.56]
[2020,8,12,13,44055.541666665995,-0.71,"Valid",3.1157894736842109,1.94,"Valid",2.4570833333333333,"","",-0.71,3.1157894736842109,1.94,2.4570833333333333,1.94,2.4570833333333333,-0.71,3.1157894736842109]
[2020,8,12,14,44055.583333332659,-1.04,"Valid",2.918947368421053,2.96,"Valid",2.3904166666666664,"","",-1.04,2.918947368421053,2.96,2.3904166666666664,2.96,2.3904166666666664,-1.04,2.918947368421053]
[2020,8,12,15,44055.624999999323,8.1999999999999993,"Valid",3.2889473684210531,10.78,"Valid",2.7708333333333326,"","",8.1999999999999993,3.2889473684210531,10.78,2.7708333333333326,10.78,2.7708333333333326,8.1999999999999993,3.2889473684210531]
[2020,8,12,16,44055.666666665988,-0.2,"Valid",3.033684210526316,2.75,"Valid",2.6295833333333336,"","",-0.2,3.033684210526316,2.75,2.6295833333333336,2.75,2.6295833333333336,-0.2,3.033684210526316]
[2020,{"$f":"B282","v":8},{"$f":"C259+1","v":12},17,44055.708333332652,4.76,"Valid",3.12,8.7899999999999991,"Valid",3.149166666666666,"","",4.76,3.12,8.7899999999999991,3.149166666666666,8.7899999999999991,3.149166666666666,4.76,3.12]
[2020,8,12,18,44055.749999999316,-0.8,"Valid",3.0870000000000002,3.62,"Valid",3.2420833333333334,"","",-0.8,3.0870000000000002,3.62,3.2420833333333334,3.62,3.2420833333333334,-0.8,3.0870000000000002]
[2020,8,12,19,44055.79166666598,4.72,"Valid",3.1647619047619053,6.71,"Valid",3.6458333333333326,"","",4.72,3.1647619047619053,6.71,3.6458333333333326,6.71,3.6458333333333326,4.72,3.1647619047619053]
[2020,8,12,20,44055.833333332645,6.26,"Valid",3.3054545454545461,6.92,"Valid",4.0920833333333322,"","",6.26,3.3054545454545461,6.92,4.0920833333333322,6.92,4.0920833333333322,6.26,3.3054545454545461]
[2020,8,12,21,44055.874999999309,2.6,"Valid",3.0081818181818178,3.96,"Valid",3.9041666666666663,"","",2.6,3.0081818181818178,3.96,3.9041666666666663,3.96,3.9041666666666663,2.6,3.0081818181818178]
[2020,8,12,22,44055.916666665973,3.55,"Valid",3.0659090909090909,5.56,"Valid",4.0620833333333328,"","",3.55,3.0659090909090909,5.56,4.0620833333333328,5.56,4.0620833333333328,3.55,3.0659090909090909]
[2020,8,12,23,44055.958333332637,7.97,"Valid",3.205909090909091,10.64,"Valid",4.3299999999999992,"","",7.97,3.205909090909091,10.64,4.3299999999999992,10.64,4.3299999999999992,7.97,3.205909090909091]
[2020,8,13,0,44055.999999999302,0.98,"Valid",3.0422727272727275,3.28,"Valid",4.28,"","",0.98,3.0422727272727275,3.28,4.28,3.28,4.28,0.98,3.0422727272727275]
[2020,8,13,1,44056.041666665966,0.57999999999999996,"Valid",2.9352173913043482,2.1,"Valid",4.427083333333333,"","",0.57999999999999996,2.9352173913043482,2.1,4.427083333333333,2.1,4.427083333333333,0.57999999999999996,2.9352173913043482]
[2020,8,13,2,44056.08333333263,4.3,"Valid",3.0113043478260866,6.12,"Valid",4.57125,"","",4.3,3.0113043478260866,6.12,4.57125,6.12,4.57125,4.3,3.0113043478260866]
[2020,8,13,3,44056.124999999294,4.0999999999999996,"Valid",3.0566666666666662,5.25,"Valid",4.8791666666666664,"","",4.0999999999999996,3.0566666666666662,5.25,4.8791666666666664,5.25,4.8791666666666664,4.0999999999999996,3.0566666666666662]
[2020,8,13,4,44056.166666665958,12.22,"Valid",3.605833333333333,12.81,"Valid",5.4566666666666661,"","",12.22,3.605833333333333,12.81,5.4566666666666661,12.81,5.4566666666666661,12.22,3.605833333333333]
[2020,8,13,5,44056.208333332623,5.86,"Valid",3.5312499999999996,6.18,"Valid",5.4224999999999994,"","",5.86,3.5312499999999996,6.18,5.4224999999999994,6.18,5.4224999999999994,5.86,3.5312499999999996]
[2020,8,13,6,44056.249999999287,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,13,7,44056.291666665951,-1.97,"Valid",3.4356521739130432,-1.84,"Valid",5.0262500000000001,"","",-1.97,3.4356521739130432,-1.84,5.0262500000000001,-1.84,5.0262500000000001,-1.97,3.4356521739130432]
[2020,8,13,8,44056.333333332615,6.4,"Valid",3.8039130434782606,7.23,"Valid",5.3862499999999995,"","",6.4,3.8039130434782606,7.23,5.3862499999999995,7.23,5.3862499999999995,6.4,3.8039130434782606]
[2020,8,13,9,44056.37499999928,0.72,"Valid",3.79,0.77,"Valid",5.3237499999999995,"","",0.72,3.79,0.77,5.3237499999999995,0.77,5.3237499999999995,0.72,3.79]
[2020,8,13,10,44056.416666665944,1.91,"Valid",3.8078260869565215,3.84,"Valid",5.3179166666666662,"","",1.91,3.8078260869565215,3.84,5.3179166666666662,3.84,5.3179166666666662,1.91,3.8078260869565215]
[2020,8,13,11,44056.458333332608,9.7100000000000009,"Valid",3.7926086956521736,12.34,"Valid",5.3741666666666665,"","",9.7100000000000009,3.7926086956521736,12.34,5.3741666666666665,12.34,5.3741666666666665,9.7100000000000009,3.7926086956521736]
[2020,8,13,12,44056.499999999272,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,13,13,44056.541666665937,1.32,"Valid",3.7340909090909093,3.06,"Valid",4.9779166666666663,null,null,1.32,3.7340909090909093,3.06,4.9779166666666663,3.06,4.9779166666666663,1.32,3.7340909090909093]
[2020,8,13,14,44056.583333332601,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,13,15,44056.624999999265,1.02,"Valid",3.6195238095238085,2.23,"Valid",4.4404166666666667,"","",1.02,3.6195238095238085,2.23,4.4404166666666667,2.23,4.4404166666666667,1.02,3.6195238095238085]
[2020,8,13,16,44056.666666665929,8,"Valid",4.01,11.13,"Valid",4.7895833333333329,"","",8,4.01,11.13,4.7895833333333329,11.13,4.7895833333333329,8,4.01]
[2020,8,13,17,44056.708333332594,12.29,"Valid",4.3685714285714274,13.25,"Valid",4.9754166666666668,"","",12.29,4.3685714285714274,13.25,4.9754166666666668,13.25,4.9754166666666668,12.29,4.3685714285714274]
[2020,8,13,18,44056.749999999258,6.56,"Valid",4.7190476190476192,8.73,"Valid",5.1883333333333335,"","",6.56,4.7190476190476192,8.73,5.1883333333333335,8.73,5.1883333333333335,6.56,4.7190476190476192]
[2020,8,13,19,44056.791666665922,5.57,"Valid",4.7595238095238086,8.5399999999999991,"Valid",5.2645833333333334,"","",5.57,4.7595238095238086,8.5399999999999991,5.2645833333333334,8.5399999999999991,5.2645833333333334,5.57,4.7595238095238086]
[2020,8,13,20,44056.833333332586,-1.87,"Valid",4.3723809523809525,0.67,"Valid",5.0041666666666673,"","",-1.87,4.3723809523809525,0.67,5.0041666666666673,0.67,5.0041666666666673,-1.87,4.3723809523809525]
[2020,8,13,21,44056.874999999251,0.42,"Valid",4.2685714285714269,2.7,"Valid",4.9516666666666671,"","",0.42,4.2685714285714269,2.7,4.9516666666666671,2.7,4.9516666666666671,0.42,4.2685714285714269]
[2020,8,13,22,44056.916666665915,10.4,"Valid",4.5947619047619046,13.95,"Valid",5.3012500000000005,"","",10.4,4.5947619047619046,13.95,5.3012500000000005,13.95,5.3012500000000005,10.4,4.5947619047619046]
[2020,8,13,23,44056.958333332579,8.09,"Valid",4.6004761904761908,10.57,"Valid",5.2983333333333347,"","",8.09,4.6004761904761908,10.57,5.2983333333333347,10.57,5.2983333333333347,8.09,4.6004761904761908]
[2020,8,14,0,44056.999999999243,4.09,"Valid",4.7485714285714291,3.12,"Valid",5.2916666666666679,"","",4.09,4.7485714285714291,3.12,5.2916666666666679,3.12,5.2916666666666679,4.09,4.7485714285714291]
[2020,8,14,1,44057.041666665908,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,14,2,44057.083333332572,2.69,"Valid",4.8765000000000009,3.67,"Valid",5.1550000000000011,"","",2.69,4.8765000000000009,3.67,5.1550000000000011,3.67,5.1550000000000011,2.69,4.8765000000000009]
[2020,8,14,3,44057.124999999236,5.64,"Valid",4.9535000000000009,7.62,"Valid",5.253750000000001,"","",5.64,4.9535000000000009,7.62,5.253750000000001,7.62,5.253750000000001,5.64,4.9535000000000009]
[2020,8,14,4,44057.1666666659,3.69,"Valid",4.5270000000000001,4.49,"Valid",4.9070833333333344,"","",3.69,4.5270000000000001,4.49,4.9070833333333344,4.49,4.9070833333333344,3.69,4.5270000000000001]
[2020,8,14,5,44057.208333332565,5.81,"Valid",4.5245000000000006,6.96,"Valid",4.9395833333333323,"","",5.81,4.5245000000000006,6.96,4.9395833333333323,6.96,4.9395833333333323,5.81,4.5245000000000006]
[2020,8,14,6,44057.249999999229,6.27,"Valid",4.6076190476190479,2.4700000000000002,"Valid",5.1437500000000007,"","",6.27,4.6076190476190479,2.4700000000000002,5.1437500000000007,2.4700000000000002,5.1437500000000007,6.27,4.6076190476190479]
[2020,8,14,7,44057.291666665893,2.8,"Valid",4.8347619047619048,2.87,"Valid",5.3400000000000007,"","",2.8,4.8347619047619048,2.87,5.3400000000000007,2.87,5.3400000000000007,2.8,4.8347619047619048]
[2020,8,14,8,44057.333333332557,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$f":"IF(G322=\"Valid\", F322, NA())","v":{"$error":"#N/A"}},{"$f":"IF(G322=\"Valid\", H322, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J322=\"Valid\", I322, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J322=\"Valid\", K322, NA())","v":{"$error":"#N/A"}}]
[2020,8,14,9,44057.374999999221,0,"Valid",4.7204999999999995,1.32,"Valid",4.7945833333333328,"","",0,4.7204999999999995,1.32,4.7945833333333328,1.32,4.7945833333333328,0,4.7204999999999995]
[{"$f":"A323","v":2020},8,14,{"$f":"IF(D323=23,0,D323+1)","v":10},{"$f":"E323+0.0416666666666666","v":44057.416666665886},4.24,"Valid",4.8369999999999997,5.38,"Valid",4.8587499999999997,"","",4.24,4.8369999999999997,5.38,4.8587499999999997,5.38,4.8587499999999997,4.24,4.8369999999999997]
[2020,8,14,11,44057.45833333255,4.34,"Valid",4.5684999999999993,8.92,"Valid",4.7162499999999996,"","",4.34,4.5684999999999993,8.92,4.7162499999999996,8.92,4.7162499999999996,4.34,4.5684999999999993]
[2020,8,14,12,44057.499999999214,3.88,"Valid",4.5357142857142847,6.2,"Valid",5.0549999999999997,"","",3.88,4.5357142857142847,6.2,5.0549999999999997,6.2,5.0549999999999997,3.88,4.5357142857142847]
[2020,8,14,13,44057.541666665878,3.38,"Valid",4.6338095238095232,4.51,"Valid",5.1154166666666665,"","",3.38,4.6338095238095232,4.51,5.1154166666666665,4.51,5.1154166666666665,3.38,4.6338095238095232]
[2020,8,14,14,44057.583333332543,4.08,"Valid",4.6086363636363634,6.29,"Valid",5.4354166666666677,"","",4.08,4.6086363636363634,6.29,5.4354166666666677,6.29,5.4354166666666677,4.08,4.6086363636363634]
[2020,8,14,15,44057.624999999207,2.78,"Valid",4.6886363636363635,4.8099999999999996,"Valid",5.5429166666666667,"","",2.78,4.6886363636363635,4.8099999999999996,5.5429166666666667,4.8099999999999996,5.5429166666666667,2.78,4.6886363636363635]
[2020,8,14,16,44057.666666665871,-0.36,"Valid",4.3086363636363627,1.3,"Valid",5.1333333333333337,"","",-0.36,4.3086363636363627,1.3,5.1333333333333337,1.3,5.1333333333333337,-0.36,4.3086363636363627]
[2020,8,14,17,44057.708333332535,-0.12,"Valid",3.7445454545454537,1.8,"Valid",4.65625,"","",-0.12,3.7445454545454537,1.8,4.65625,1.8,4.65625,-0.12,3.7445454545454537]
[2020,8,14,18,44057.7499999992,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,14,19,44057.791666665864,1.46,"Valid",3.4147619047619044,3.05,"Valid",3.7766666666666673,"","",1.46,3.4147619047619044,3.05,3.7766666666666673,3.05,3.7766666666666673,1.46,3.4147619047619044]
[2020,8,14,20,44057.833333332528,5.63,"Valid",3.7719047619047616,6.16,"Valid",4.0054166666666671,"","",5.63,3.7719047619047616,6.16,4.0054166666666671,6.16,4.0054166666666671,5.63,3.7719047619047616]
[2020,8,14,21,44057.874999999192,14.03,"Valid",4.42,13.45,"Valid",4.453333333333334,"","",14.03,4.42,13.45,4.453333333333334,13.45,4.453333333333334,14.03,4.42]
[2020,8,14,22,44057.916666665857,-0.11,"Valid",3.9195238095238096,-0.39,"Valid",3.855833333333333,"","",-0.11,3.9195238095238096,-0.39,3.855833333333333,-0.39,3.855833333333333,-0.11,3.9195238095238096]
[2020,8,14,23,44057.958333332521,2.14,"Valid",3.636190476190476,2.0299999999999998,"Valid",3.5,"","",2.14,3.636190476190476,2.0299999999999998,3.5,2.0299999999999998,3.5,2.14,3.636190476190476]
[2020,8,15,0,44057.999999999185,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,15,1,44058.041666665849,4.07,"Valid",3.6352380952380954,5.34,"Valid",3.2754166666666666,"","",4.07,3.6352380952380954,5.34,3.2754166666666666,5.34,3.2754166666666666,4.07,3.6352380952380954]
[2020,8,15,2,44058.083333332514,0.85,"Valid",3.5476190476190474,1.66,"Valid",3.1916666666666664,"","",0.85,3.5476190476190474,1.66,3.1916666666666664,1.66,3.1916666666666664,0.85,3.5476190476190474]
[2020,8,15,3,44058.124999999178,6.62,"Valid",3.5942857142857152,7.28,"Valid",3.1774999999999998,"","",6.62,3.5942857142857152,7.28,3.1774999999999998,7.28,3.1774999999999998,6.62,3.5942857142857152]
[2020,8,15,4,44058.166666665842,6.05,"Valid",3.706666666666667,7.37,"Valid",3.2974999999999999,"","",6.05,3.706666666666667,7.37,3.2974999999999999,7.37,3.2974999999999999,6.05,3.706666666666667]
[2020,8,15,5,44058.208333332506,9.1300000000000008,"Valid",3.8647619047619046,10.050000000000001,"Valid",3.4262499999999996,"","",9.1300000000000008,3.8647619047619046,10.050000000000001,3.4262499999999996,10.050000000000001,3.4262499999999996,9.1300000000000008,3.8647619047619046]
[2020,8,15,6,44058.249999999171,12.11,"Valid",4.1428571428571432,12.61,"Valid",3.8487499999999994,"","",12.11,4.1428571428571432,12.61,3.8487499999999994,12.61,3.8487499999999994,12.11,4.1428571428571432]
[2020,8,15,7,44058.291666665835,14.74,"Valid",4.7114285714285717,14.52,"Valid",4.3341666666666665,"","",14.74,4.7114285714285717,14.52,4.3341666666666665,14.52,4.3341666666666665,14.74,4.7114285714285717]
[2020,8,15,8,44058.333333332499,5.53,"Valid",4.748636363636364,5.76,"Valid",4.8412499999999996,"","",5.53,4.748636363636364,5.76,4.8412499999999996,5.76,4.8412499999999996,5.53,4.748636363636364]
[2020,{"$f":"B346","v":8},{"$f":"C323+1","v":15},9,44058.374999999163,0.91,"Valid",4.79,0.57999999999999996,"Valid",4.8104166666666659,"","",0.91,4.79,0.57999999999999996,4.8104166666666659,0.57999999999999996,4.8104166666666659,0.91,4.79]
[2020,8,15,10,44058.416666665828,3.79,"Valid",4.7695454545454545,5.15,"Valid",4.8008333333333333,"","",3.79,4.7695454545454545,5.15,4.8008333333333333,5.15,4.8008333333333333,3.79,4.7695454545454545]
[2020,8,15,11,44058.458333332492,1.59,"Valid",4.6445454545454545,1.37,"Valid",4.486250000000001,"","",1.59,4.6445454545454545,1.37,4.486250000000001,1.37,4.486250000000001,1.59,4.6445454545454545]
[2020,8,15,12,44058.499999999156,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,15,13,44058.54166666582,-1.4,"Valid",4.4533333333333331,-0.24,"Valid",3.9258333333333337,"","",-1.4,4.4533333333333331,-0.24,3.9258333333333337,-0.24,3.9258333333333337,-1.4,4.4533333333333331]
[2020,8,15,14,44058.583333332484,0.98,"Valid",4.305714285714286,1.67,"Valid",3.7333333333333338,"","",0.98,4.305714285714286,1.67,3.7333333333333338,1.67,3.7333333333333338,0.98,4.305714285714286]
[2020,8,15,15,44058.624999999149,2.66,"Valid",4.3,2.64,"Valid",3.6429166666666677,"","",2.66,4.3,2.64,3.6429166666666677,2.64,3.6429166666666677,2.66,4.3]
[2020,8,15,16,44058.666666665813,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,15,17,44058.708333332477,8.23,"Valid",4.9504999999999999,7.94,"Valid",3.7762500000000006,"","",8.23,4.9504999999999999,7.94,3.7762500000000006,7.94,3.7762500000000006,8.23,4.9504999999999999]
[2020,8,15,18,44058.749999999141,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,15,19,44058.791666665806,5.19,"Valid",5.1370000000000005,7.41,"Valid",3.9962500000000003,"","",5.19,5.1370000000000005,7.41,3.9962500000000003,7.41,3.9962500000000003,5.19,5.1370000000000005]
[2020,8,15,20,44058.83333333247,1.1399999999999999,"Valid",4.9124999999999996,1.76,"Valid",3.8129166666666676,"","",1.1399999999999999,4.9124999999999996,1.76,3.8129166666666676,1.76,3.8129166666666676,1.1399999999999999,4.9124999999999996]
[2020,8,15,21,44058.874999999134,6.04,"Valid",4.5129999999999999,5.42,"Valid",3.4783333333333335,"","",6.04,4.5129999999999999,5.42,3.4783333333333335,5.42,3.4783333333333335,6.04,4.5129999999999999]
[2020,8,15,22,44058.916666665798,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,15,23,44058.958333332463,2.88,"Valid",4.7952631578947367,2.0499999999999998,"Valid",3.2012499999999995,"","",2.88,4.7952631578947367,2.0499999999999998,3.2012499999999995,2.0499999999999998,3.2012499999999995,2.88,4.7952631578947367]
[2020,8,16,0,44058.999999999127,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,1,44059.041666665791,3.78,"Valid",4.78,4.9000000000000004,"Valid",3.32375,"","",3.78,4.78,4.9000000000000004,3.32375,4.9000000000000004,3.32375,3.78,4.78]
[2020,8,16,2,44059.083333332455,2.99,"Valid",4.892631578947368,2.72,"Valid",3.3679166666666664,"","",2.99,4.892631578947368,2.72,3.3679166666666664,2.72,3.3679166666666664,2.99,4.892631578947368]
[2020,8,16,3,44059.12499999912,5.0999999999999996,"Valid",4.8126315789473679,3.88,"Valid",3.2262499999999998,"","",5.0999999999999996,4.8126315789473679,3.88,3.2262499999999998,3.88,3.2262499999999998,5.0999999999999996,4.8126315789473679]
[2020,8,16,4,44059.166666665784,-2.15,"Valid",4.3810526315789469,-7.37,"Valid",2.6120833333333322,"","",-2.15,4.3810526315789469,-7.37,2.6120833333333322,-7.37,2.6120833333333322,-2.15,4.3810526315789469]
[2020,8,16,5,44059.208333332448,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,6,44059.249999999112,0.92,"Valid",3.4955555555555562,1.18,"Valid",1.5429166666666665,"","",0.92,3.4955555555555562,1.18,1.5429166666666665,1.18,1.5429166666666665,0.92,3.4955555555555562]
[2020,8,16,7,44059.291666665777,10.15,"Valid",3.2405555555555563,10.46,"Valid",1.37375,"","",10.15,3.2405555555555563,10.46,1.37375,10.46,1.37375,10.15,3.2405555555555563]
[2020,8,16,8,44059.333333332441,3.85,"Valid",3.147222222222223,3.17,"Valid",1.2658333333333334,"","",3.85,3.147222222222223,3.17,1.2658333333333334,3.17,1.2658333333333334,3.85,3.147222222222223]
[2020,8,16,9,44059.374999999105,10.94,"Valid",3.7044444444444449,10.89,"Valid",1.6954166666666668,"","",10.94,3.7044444444444449,10.89,1.6954166666666668,10.89,1.6954166666666668,10.94,3.7044444444444449]
[2020,8,16,10,44059.416666665769,2.5299999999999998,"Valid",3.6344444444444446,7.29,"Valid",1.7845833333333332,"","",2.5299999999999998,3.6344444444444446,7.29,1.7845833333333332,7.29,1.7845833333333332,2.5299999999999998,3.6344444444444446]
[2020,8,16,11,44059.458333332434,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,12,44059.499999999098,5.62,"Valid",3.8583333333333334,5.0199999999999996,"Valid",2.0395833333333333,"","",5.62,3.8583333333333334,5.0199999999999996,2.0395833333333333,5.0199999999999996,2.0395833333333333,5.62,3.8583333333333334]
[2020,8,16,13,44059.541666665762,-0.09,"Valid",3.9311111111111114,0.68,"Valid",2.0779166666666664,"","",-0.09,3.9311111111111114,0.68,2.0779166666666664,0.68,2.0779166666666664,-0.09,3.9311111111111114]
[2020,8,16,14,44059.583333332426,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,15,44059.624999999091,2.0499999999999998,"Valid",4.0688235294117652,3.51,"Valid",1.8729166666666666,"","",2.0499999999999998,4.0688235294117652,3.51,1.8729166666666666,3.51,1.8729166666666666,2.0499999999999998,4.0688235294117652]
[2020,8,16,16,44059.666666665755,3.1,"Valid",4.0149999999999997,3.32,"Valid",2.0795833333333333,"","",3.1,4.0149999999999997,3.32,2.0795833333333333,3.32,2.0795833333333333,3.1,4.0149999999999997]
[2020,8,16,17,44059.708333332419,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,18,44059.749999999083,-0.19,"Valid",3.5472222222222221,1.64,"Valid",2.1556521739130434,"","",-0.19,3.5472222222222221,1.64,2.1556521739130434,1.64,2.1556521739130434,-0.19,3.5472222222222221]
[2020,8,16,19,44059.791666665747,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,20,44059.833333332412,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,16,21,44059.874999999076,4.6399999999999997,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},4.43,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",4.6399999999999997,{"$error":"#N/A"},4.43,{"$error":"#N/A"},4.43,null,4.6399999999999997]
[2020,8,16,22,44059.91666666574,3.75,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.0299999999999998,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",3.75,{"$error":"#N/A"},2.0299999999999998,{"$error":"#N/A"},2.0299999999999998,null,3.75]
[2020,8,16,23,44059.958333332404,-2.13,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-2,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-2.13,{"$error":"#N/A"},-2,{"$error":"#N/A"},-2,null,-2.13]
[2020,8,17,0,44059.999999999069,0.93,"Valid",3.099444444444444,0.15,"Valid",1.8727272727272732,"","",{"$f":"IF(G386=\"Valid\", F386, NA())","v":0.93},{"$f":"IF(G386=\"Valid\", H386, NA())","v":3.099444444444444},{"$f":"IF(J386=\"Valid\", I386, NA())","v":0.15},{"$f":"IF(J386=\"Valid\", K386, NA())","v":1.8727272727272732},0.15,1.8727272727272732,0.93,3.099444444444444]
[2020,8,17,1,44060.041666665733,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A387","v":2020},8,17,{"$f":"IF(D387=23,0,D387+1)","v":2},{"$f":"E387+0.0416666666666666","v":44060.083333332397},14.23,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.04,"Valid",1.5022727272727268,"              ","<18hrs of 1hr data for 24hr rolling average",14.23,{"$error":"#N/A"},-0.04,1.5022727272727268,-0.04,1.5022727272727268,14.23]
[2020,8,17,3,44060.124999999061,1.69,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.09,"Valid",1.321818181818182,"              ","<18hrs of 1hr data for 24hr rolling average",1.69,{"$error":"#N/A"},-0.09,1.321818181818182,-0.09,1.321818181818182,1.69]
[2020,8,17,4,44060.166666665726,2.13,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},0.28999999999999998,"Valid",1.6699999999999997,"              ","<18hrs of 1hr data for 24hr rolling average",2.13,{"$error":"#N/A"},0.28999999999999998,1.6699999999999997,0.28999999999999998,1.6699999999999997,2.13]
[2020,8,17,5,44060.20833333239,0.02,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},0.5,"Valid",1.8827272727272728,"              ","<18hrs of 1hr data for 24hr rolling average",0.02,{"$error":"#N/A"},0.5,1.8827272727272728,0.5,1.8827272727272728,0.02]
[2020,8,17,6,44060.249999999054,2.54,"Valid",3.6533333333333338,0.63,"Valid",1.8577272727272727,"","",2.54,3.6533333333333338,0.63,1.8577272727272727,0.63,1.8577272727272727,2.54,3.6533333333333338]
[2020,8,17,7,44060.291666665718,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,17,8,44060.333333332383,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,17,9,44060.374999999047,-1.88,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.78,"Valid",0.69818181818181813,"              ","<18hrs of 1hr data for 24hr rolling average",-1.88,{"$error":"#N/A"},-0.78,0.69818181818181813,-0.78,0.69818181818181813,-1.88]
[2020,8,17,10,44060.416666665711,4.45,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.9,"Valid",0.32590909090909093,"              ","<18hrs of 1hr data for 24hr rolling average",4.45,{"$error":"#N/A"},-0.9,0.32590909090909093,-0.9,0.32590909090909093,4.45]
[2020,8,17,11,44060.458333332375,-0.54,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.89,"Valid",0.28681818181818186,"              ","<18hrs of 1hr data for 24hr rolling average",-0.54,{"$error":"#N/A"},-0.89,0.28681818181818186,-0.89,0.28681818181818186,-0.54]
[2020,8,17,12,44060.49999999904,3.94,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.93,"Valid",1.6363636363636323E-2,"              ","<18hrs of 1hr data for 24hr rolling average",3.94,{"$error":"#N/A"},-0.93,1.6363636363636323E-2,-0.93,1.6363636363636323E-2,3.94]
[2020,8,17,13,44060.541666665704,10.199999999999999,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.3,"Valid",-2.8181818181818207E-2,"              ","<18hrs of 1hr data for 24hr rolling average",10.199999999999999,{"$error":"#N/A"},-0.3,-2.8181818181818207E-2,-0.3,-2.8181818181818207E-2,10.199999999999999]
[2020,8,17,14,44060.583333332368,-0.52,"Valid",2.6894444444444439,-0.17,"Valid",0.15136363636363639,"","",-0.52,2.6894444444444439,-0.17,0.15136363636363639,-0.17,0.15136363636363639,-0.52,2.6894444444444439]
[2020,8,17,15,44060.624999999032,5.29,"Valid",2.869444444444444,-7.0000000000000007E-2,"Valid",-1.1363636363636419E-2,"","",5.29,2.869444444444444,-7.0000000000000007E-2,-1.1363636363636419E-2,-7.0000000000000007E-2,-1.1363636363636419E-2,5.29,2.869444444444444]
[2020,8,17,16,44060.666666665697,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,17,17,44060.708333332361,-1.55,"Valid",2.6111111111111112,0.45,"Valid",-0.15521739130434783,"","",-1.55,2.6111111111111112,0.45,-0.15521739130434783,0.45,-0.15521739130434783,-1.55,2.6111111111111112]
[2020,8,17,18,44060.749999999025,0.12,"Valid",2.628333333333333,0.39,"Valid",-0.2095652173913044,"","",0.12,2.628333333333333,0.39,-0.2095652173913044,0.39,-0.2095652173913044,0.12,2.628333333333333]
[2020,8,17,19,44060.791666665689,2.5499999999999998,"Valid",2.6242105263157889,1.1499999999999999,"Valid",-0.15291666666666673,"","",2.5499999999999998,2.6242105263157889,1.1499999999999999,-0.15291666666666673,1.1499999999999999,-0.15291666666666673,2.5499999999999998,2.6242105263157889]
[2020,8,17,20,44060.833333332354,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,17,21,44060.874999999018,0.57999999999999996,"Valid",2.4105263157894732,0.78,"Valid",5.4166666666666712E-3,"","",0.57999999999999996,2.4105263157894732,0.78,5.4166666666666712E-3,0.78,5.4166666666666712E-3,0.57999999999999996,2.4105263157894732]
[2020,8,17,22,44060.916666665682,12.97,"Valid",2.8957894736842098,1.1599999999999999,"Valid",-3.0833333333333341E-2,"","",12.97,2.8957894736842098,1.1599999999999999,-3.0833333333333341E-2,1.1599999999999999,-3.0833333333333341E-2,12.97,2.8957894736842098]
[2020,8,17,23,44060.958333332346,4.62,"Valid",3.251052631578947,1.43,"Valid",0.11208333333333335,"","",4.62,3.251052631578947,1.43,0.11208333333333335,1.43,0.11208333333333335,4.62,3.251052631578947]
[2020,8,18,0,44060.99999999901,7.34,"Valid",3.5884210526315785,1.66,"Valid",0.17500000000000002,"","",7.34,3.5884210526315785,1.66,0.17500000000000002,1.66,0.17500000000000002,7.34,3.5884210526315785]
[2020,{"$f":"B410","v":8},{"$f":"C387+1","v":18},1,44061.041666665675,4.32,"Valid",3.625,2.34,"Valid",0.29291666666666666,"","",4.32,3.625,2.34,0.29291666666666666,2.34,0.29291666666666666,4.32,3.625]
[2020,8,18,2,44061.083333332339,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,3,44061.124999999003,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,4,44061.166666665667,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,5,44061.208333332332,1.23,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.1100000000000001,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",1.23,{"$error":"#N/A"},1.1100000000000001,{"$error":"#N/A"},1.1100000000000001,null,1.23]
[2020,8,18,6,44061.249999998996,2.95,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.04,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",2.95,{"$error":"#N/A"},1.04,{"$error":"#N/A"},1.04,null,2.95]
[2020,8,18,7,44061.29166666566,5.74,"Valid",3.4338888888888888,1.42,"Valid",0.55583333333333329,"","",5.74,3.4338888888888888,1.42,0.55583333333333329,1.42,0.55583333333333329,5.74,3.4338888888888888]
[2020,8,18,8,44061.333333332324,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,9,44061.374999998989,5.57,"Valid",3.8477777777777771,1.54,"Valid",0.71583333333333332,"","",5.57,3.8477777777777771,1.54,0.71583333333333332,1.54,0.71583333333333332,5.57,3.8477777777777771]
[2020,8,18,10,44061.416666665653,6.03,"Valid",3.9355555555555557,1.67,"Valid",0.82291666666666663,"","",6.03,3.9355555555555557,1.67,0.82291666666666663,1.67,0.82291666666666663,6.03,3.9355555555555557]
[2020,8,18,11,44061.458333332317,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,12,44061.499999998981,4.96,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.39,"Valid",1.0154166666666666,"              ","<18hrs of 1hr data for 24hr rolling average",4.96,{"$error":"#N/A"},1.39,1.0154166666666666,1.39,1.0154166666666666,4.96]
[2020,8,18,13,44061.541666665646,1.44,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},0.83,"Valid",1.0624999999999998,"              ","<18hrs of 1hr data for 24hr rolling average",1.44,{"$error":"#N/A"},0.83,1.0624999999999998,0.83,1.0624999999999998,1.44]
[2020,8,18,14,44061.58333333231,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},0.75,"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,15,44061.624999998974,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,16,44061.666666665638,10.33,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},0.96,"Valid",1.1745833333333333,"              ","<18hrs of 1hr data for 24hr rolling average",10.33,{"$error":"#N/A"},0.96,1.1745833333333333,0.96,1.1745833333333333,10.33]
[2020,8,18,17,44061.708333332303,3.36,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.17,"Valid",1.2045833333333331,"              ","<18hrs of 1hr data for 24hr rolling average",3.36,{"$error":"#N/A"},1.17,1.2045833333333331,1.17,1.2045833333333331,3.36]
[2020,8,18,18,44061.749999998967,4.97,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.51,"Valid",1.25125,"              ","<18hrs of 1hr data for 24hr rolling average",4.97,{"$error":"#N/A"},1.51,1.25125,1.51,1.25125,4.97]
[2020,8,18,19,44061.791666665631,4.53,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.66,"Valid",1.2725,"              ","<18hrs of 1hr data for 24hr rolling average",4.53,{"$error":"#N/A"},1.66,1.2725,1.66,1.2725,4.53]
[2020,8,18,20,44061.833333332295,4.97,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.25,"Valid",1.32125,"              ","<18hrs of 1hr data for 24hr rolling average",4.97,{"$error":"#N/A"},2.25,1.32125,2.25,1.32125,4.97]
[2020,8,18,21,44061.87499999896,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,18,22,44061.916666665624,5.17,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.99,"Valid",1.4158333333333333,"              ","<18hrs of 1hr data for 24hr rolling average",5.17,{"$error":"#N/A"},1.99,1.4158333333333333,1.99,1.4158333333333333,5.17]
[2020,8,18,23,44061.958333332288,0.67,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.81,"Valid",1.4316666666666666,"              ","<18hrs of 1hr data for 24hr rolling average",0.67,{"$error":"#N/A"},1.81,1.4316666666666666,1.81,1.4316666666666666,0.67]
[2020,8,19,0,44061.999999998952,0.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.52,"Valid",1.4258333333333333,"              ","<18hrs of 1hr data for 24hr rolling average",0.16,{"$error":"#N/A"},1.52,1.4258333333333333,1.52,1.4258333333333333,0.16]
[2020,8,19,1,44062.041666665617,1.03,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.33,"Valid",1.38375,"              ","<18hrs of 1hr data for 24hr rolling average",1.03,{"$error":"#N/A"},1.33,1.38375,1.33,1.38375,1.03]
[2020,8,19,2,44062.083333332281,5.46,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.75,"Valid",1.3887499999999999,"              ","<18hrs of 1hr data for 24hr rolling average",5.46,{"$error":"#N/A"},1.75,1.3887499999999999,1.75,1.3887499999999999,5.46]
[2020,8,19,3,44062.124999998945,2.23,"Valid",3.9333333333333331,1.98,"Valid",1.4137499999999996,"","",2.23,3.9333333333333331,1.98,1.4137499999999996,1.98,1.4137499999999996,2.23,3.9333333333333331]
[2020,8,19,4,44062.166666665609,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,19,5,44062.208333332273,6.25,"Valid",4.2122222222222225,2.15,"Valid",1.4945833333333332,"","",6.25,4.2122222222222225,2.15,1.4945833333333332,2.15,1.4945833333333332,6.25,4.2122222222222225]
[2020,8,19,6,44062.249999998938,1.26,"Valid",4.1183333333333341,2.09,"Valid",1.5383333333333329,"","",1.26,4.1183333333333341,2.09,1.5383333333333329,2.09,1.5383333333333329,1.26,4.1183333333333341]
[2020,8,19,7,44062.291666665602,1.7,"Valid",3.8938888888888892,1.91,"Valid",1.5587499999999999,"","",1.7,3.8938888888888892,1.91,1.5587499999999999,1.91,1.5587499999999999,1.7,3.8938888888888892]
[2020,8,19,8,44062.333333332266,0.79,"Valid",3.7305263157894744,2.34,"Valid",1.6041666666666667,"","",0.79,3.7305263157894744,2.34,1.6041666666666667,2.34,1.6041666666666667,0.79,3.7305263157894744]
[2020,8,19,9,44062.37499999893,5.58,"Valid",3.7310526315789474,2.35,"Valid",1.6379166666666665,"","",5.58,3.7310526315789474,2.35,1.6379166666666665,2.35,1.6379166666666665,5.58,3.7310526315789474]
[2020,8,19,10,44062.416666665595,9,"Valid",3.8873684210526314,2.78,"Valid",1.6841666666666664,"","",9,3.8873684210526314,2.78,1.6841666666666664,2.78,1.6841666666666664,9,3.8873684210526314]
[2020,8,19,11,44062.458333332259,4.76,"Valid",3.931,3.61,"Valid",1.7758333333333332,"","",4.76,3.931,3.61,1.7758333333333332,3.61,1.7758333333333332,4.76,3.931]
[2020,8,19,12,44062.499999998923,8,"Valid",4.0830000000000002,4.16,"Valid",1.8912500000000001,"","",8,4.0830000000000002,4.16,1.8912500000000001,4.16,1.8912500000000001,8,4.0830000000000002]
[2020,8,19,13,44062.541666665587,8.69,"Valid",4.4455,4.8499999999999996,"Valid",2.0587500000000003,"","",8.69,4.4455,4.8499999999999996,2.0587500000000003,4.8499999999999996,2.0587500000000003,8.69,4.4455]
[2020,8,19,14,44062.583333332252,11.71,"Valid",4.7914285714285718,6.05,"Valid",2.2795833333333335,"","",11.71,4.7914285714285718,6.05,2.2795833333333335,6.05,2.2795833333333335,11.71,4.7914285714285718]
[2020,8,19,15,44062.624999998916,3.62,"Valid",4.7381818181818183,6.88,"Valid",2.5541666666666667,"","",3.62,4.7381818181818183,6.88,2.5541666666666667,6.88,2.5541666666666667,3.62,4.7381818181818183]
[2020,8,19,16,44062.66666666558,10.51,"Valid",4.7463636363636361,7.36,"Valid",2.8208333333333333,"","",{"$f":"IF(G450=\"Valid\", F450, NA())","v":10.51},{"$f":"IF(G450=\"Valid\", H450, NA())","v":4.7463636363636361},{"$f":"IF(J450=\"Valid\", I450, NA())","v":7.36},{"$f":"IF(J450=\"Valid\", K450, NA())","v":2.8208333333333333},7.36,2.8208333333333333,10.51,4.7463636363636361]
[2020,8,19,17,44062.708333332244,9.18,"Valid",5.0109090909090916,8.1300000000000008,"Valid",3.1108333333333333,"","",9.18,5.0109090909090916,8.1300000000000008,3.1108333333333333,8.1300000000000008,3.1108333333333333,9.18,5.0109090909090916]
[{"$f":"A451","v":2020},8,19,{"$f":"IF(D451=23,0,D451+1)","v":18},{"$f":"E451+0.0416666666666666","v":44062.749999998909},9.57,"Valid",5.22,8.58,"Valid",3.4054166666666661,"","",9.57,5.22,8.58,3.4054166666666661,8.58,3.4054166666666661,9.57,5.22]
[2020,8,19,19,44062.791666665573,12.94,"Valid",5.6022727272727275,9.43,"Valid",3.7291666666666665,"","",12.94,5.6022727272727275,9.43,3.7291666666666665,9.43,3.7291666666666665,12.94,5.6022727272727275]
[2020,8,19,20,44062.833333332237,9.26,"Valid",5.7972727272727278,10.14,"Valid",4.0579166666666664,"","",9.26,5.7972727272727278,10.14,4.0579166666666664,10.14,4.0579166666666664,9.26,5.7972727272727278]
[2020,8,19,21,44062.874999998901,11.4,"Valid",6.0408695652173909,11.42,"Valid",4.4412500000000001,"","",11.4,6.0408695652173909,11.42,4.4412500000000001,11.42,4.4412500000000001,11.4,6.0408695652173909]
[2020,8,19,22,44062.916666665566,10.29,"Valid",6.2634782608695643,12.37,"Valid",4.8737500000000002,"","",10.29,6.2634782608695643,12.37,4.8737500000000002,12.37,4.8737500000000002,10.29,6.2634782608695643]
[2020,8,19,23,44062.95833333223,2.6,"Valid",6.3473913043478252,13.42,"Valid",5.3575000000000008,"","",2.6,6.3473913043478252,13.42,5.3575000000000008,13.42,5.3575000000000008,2.6,6.3473913043478252]
[2020,8,20,0,44062.999999998894,15.46,"Valid",7.0126086956521734,15.09,"Valid",5.9229166666666666,"","",15.46,7.0126086956521734,15.09,5.9229166666666666,15.09,5.9229166666666666,15.46,7.0126086956521734]
[2020,8,20,1,44063.041666665558,9.41,"Valid",7.37695652173913,16.309999999999999,"Valid",6.5470833333333331,"","",9.41,7.37695652173913,16.309999999999999,6.5470833333333331,16.309999999999999,6.5470833333333331,9.41,7.37695652173913]
[2020,8,20,2,44063.083333332223,25.8,"Valid",8.261304347826087,20.28,"Valid",7.3191666666666668,"","",25.8,8.261304347826087,20.28,7.3191666666666668,20.28,7.3191666666666668,25.8,8.261304347826087]
[2020,8,20,3,44063.124999998887,53.09,"Valid",10.472608695652173,28.89,"Valid",8.4404166666666658,"","",53.09,10.472608695652173,28.89,8.4404166666666658,28.89,8.4404166666666658,53.09,10.472608695652173]
[2020,8,20,4,44063.166666665551,90,"Valid",13.786250000000001,42.68,"Valid",10.136250000000002,"","",90,13.786250000000001,42.68,10.136250000000002,42.68,10.136250000000002,90,13.786250000000001]
[2020,8,20,5,44063.208333332215,89.53,"Valid",17.256249999999998,55.13,"Valid",12.34375,"","",89.53,17.256249999999998,55.13,12.34375,55.13,12.34375,89.53,17.256249999999998]
[2020,8,20,6,44063.24999999888,78.94,"Valid",20.492916666666666,65.89,"Valid",15.002083333333333,"","",78.94,20.492916666666666,65.89,15.002083333333333,65.89,15.002083333333333,78.94,20.492916666666666]
[2020,8,20,7,44063.291666665544,74.42,"Valid",23.522916666666671,76,"Valid",18.089166666666667,"","",74.42,23.522916666666671,76,18.089166666666667,76,18.089166666666667,74.42,23.522916666666671]
[2020,8,20,8,44063.333333332208,70.05,"Valid",26.408749999999998,85.34,"Valid",21.547499999999999,"","",70.05,26.408749999999998,85.34,21.547499999999999,85.34,21.547499999999999,70.05,26.408749999999998]
[2020,8,20,9,44063.374999998872,66.290000000000006,"Valid",28.938333333333333,93.96,"Valid",25.364583333333332,"","",66.290000000000006,28.938333333333333,93.96,25.364583333333332,93.96,25.364583333333332,66.290000000000006,28.938333333333333]
[2020,8,20,10,44063.416666665536,39.83,"Valid",30.222916666666666,98.68,"Valid",29.360416666666669,"","",39.83,30.222916666666666,98.68,29.360416666666669,98.68,29.360416666666669,39.83,30.222916666666666]
[2020,8,20,11,44063.458333332201,36.49,"Valid",31.545000000000002,102.41,"Valid",33.477083333333333,"","",36.49,31.545000000000002,102.41,33.477083333333333,102.41,33.477083333333333,36.49,31.545000000000002]
[2020,8,20,12,44063.499999998865,32.26,"Valid",32.555833333333332,105.54,"Valid",37.701250000000002,"","",32.26,32.555833333333332,105.54,37.701250000000002,105.54,37.701250000000002,32.26,32.555833333333332]
[2020,8,20,13,44063.541666665529,18.2,"Valid",32.952083333333334,107.08,"Valid",41.960833333333333,null,null,18.2,32.952083333333334,107.08,41.960833333333333,107.08,41.960833333333333,18.2,32.952083333333334]
[2020,8,20,14,44063.583333332193,9.19,"Valid",32.847083333333337,107.25,"Valid",46.177500000000002,"","",9.19,32.847083333333337,107.25,46.177500000000002,107.25,46.177500000000002,9.19,32.847083333333337]
[2020,8,20,15,44063.624999998858,17.34,"Valid",33.418750000000003,107.82,"Valid",50.383333333333333,"","",17.34,33.418750000000003,107.82,50.383333333333333,107.82,50.383333333333333,17.34,33.418750000000003]
[2020,8,20,16,44063.666666665522,3.65,"Valid",33.132916666666667,107.39,"Valid",54.551250000000003,"","",3.65,33.132916666666667,107.39,54.551250000000003,107.39,54.551250000000003,3.65,33.132916666666667]
[2020,{"$f":"B474","v":8},{"$f":"C451+1","v":20},17,44063.708333332186,0.66,"Valid",32.77791666666667,106.85,"Valid",58.664583333333333,"","",0.66,32.77791666666667,106.85,58.664583333333333,106.85,58.664583333333333,0.66,32.77791666666667]
[2020,8,20,18,44063.74999999885,2.11,"Valid",32.467083333333335,106.11,"Valid",62.728333333333325,"","",2.11,32.467083333333335,106.11,62.728333333333325,106.11,62.728333333333325,2.11,32.467083333333335]
[2020,8,20,19,44063.791666665515,5.84,"Valid",32.171250000000008,105.02,"Valid",66.711249999999993,"","",5.84,32.171250000000008,105.02,66.711249999999993,105.02,66.711249999999993,5.84,32.171250000000008]
[2020,8,20,20,44063.833333332179,1.82,"Valid",31.861250000000009,104.2,"Valid",70.630416666666662,"","",1.82,31.861250000000009,104.2,70.630416666666662,104.2,70.630416666666662,1.82,31.861250000000009]
[2020,8,20,21,44063.874999998843,-0.24,"Valid",31.37625000000001,103.18,"Valid",74.453749999999999,"","",-0.24,31.37625000000001,103.18,74.453749999999999,103.18,74.453749999999999,-0.24,31.37625000000001]
[2020,8,20,22,44063.916666665507,1.41,"Valid",31.006250000000009,102.26,"Valid",78.19916666666667,"","",1.41,31.006250000000009,102.26,78.19916666666667,102.26,78.19916666666667,1.41,31.006250000000009]
[2020,8,20,23,44063.958333332172,3.36,"Valid",31.037916666666675,101.16,"Valid",81.855000000000004,"","",3.36,31.037916666666675,101.16,81.855000000000004,101.16,81.855000000000004,3.36,31.037916666666675]
[2020,8,21,0,44063.999999998836,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,1,44064.0416666655,3.76,"Valid",31.469565217391313,98.57,"Valid",88.787916666666675,"","",3.76,31.469565217391313,98.57,88.787916666666675,98.57,88.787916666666675,3.76,31.469565217391313]
[2020,8,21,2,44064.083333332164,0.78,"Valid",30.381739130434791,94.32,"Valid",91.872916666666683,"","",0.78,30.381739130434791,94.32,91.872916666666683,94.32,91.872916666666683,0.78,30.381739130434791]
[2020,8,21,3,44064.124999998829,3.16,"Valid",28.210869565217397,85.9,"Valid",94.248333333333349,"","",3.16,28.210869565217397,85.9,94.248333333333349,85.9,94.248333333333349,3.16,28.210869565217397]
[2020,8,21,4,44064.166666665493,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,5,44064.208333332157,0.82,"Valid",21.37,59.68,"Valid",95.679583333333326,"","",0.82,21.37,59.68,95.679583333333326,59.68,95.679583333333326,0.82,21.37]
[2020,8,21,6,44064.249999998821,4.78,"Valid",17.999090909090906,49.15,"Valid",94.982083333333321,"","",4.78,17.999090909090906,49.15,94.982083333333321,49.15,94.982083333333321,4.78,17.999090909090906]
[2020,8,21,7,44064.291666665486,3.07,"Valid",14.755909090909087,39.15,"Valid",93.446666666666658,"","",3.07,14.755909090909087,39.15,93.446666666666658,39.15,93.446666666666658,3.07,14.755909090909087]
[2020,8,21,8,44064.33333333215,2.88,"Valid",11.702727272727271,29.95,"Valid",91.138750000000002,"","",2.88,11.702727272727271,29.95,91.138750000000002,29.95,91.138750000000002,2.88,11.702727272727271]
[2020,8,21,9,44064.374999998814,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,10,44064.416666665478,10.79,"Valid",7.72047619047619,16.23,"Valid",84.67291666666668,"","",10.79,7.72047619047619,16.23,84.67291666666668,16.23,84.67291666666668,10.79,7.72047619047619]
[2020,8,21,11,44064.458333332143,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,12,44064.499999998807,3.49,"Valid",4.8434999999999979,7.58,"Valid",76.791666666666686,"","",3.49,4.8434999999999979,7.58,76.791666666666686,7.58,76.791666666666686,3.49,4.8434999999999979]
[2020,8,21,13,44064.541666665471,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,14,44064.583333332135,-2.19,"Valid",3.5415789473684205,4.43,"Valid",68.275416666666672,"","",-2.19,3.5415789473684205,4.43,68.275416666666672,4.43,68.275416666666672,-2.19,3.5415789473684205]
[2020,8,21,15,44064.624999998799,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,16,44064.666666665464,7.23,"Valid",2.9738888888888888,2.93,"Valid",59.558333333333344,"","",7.23,2.9738888888888888,2.93,59.558333333333344,2.93,59.558333333333344,7.23,2.9738888888888888]
[2020,8,21,17,44064.708333332128,4.2699999999999996,"Valid",3.1744444444444446,2.93,"Valid",55.228333333333346,"","",4.2699999999999996,3.1744444444444446,2.93,55.228333333333346,2.93,55.228333333333346,4.2699999999999996,3.1744444444444446]
[2020,8,21,18,44064.749999998792,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,21,19,44064.791666665456,13.06,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.08,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",13.06,{"$error":"#N/A"},3.08,{"$error":"#N/A"},3.08,null,13.06]
[2020,8,21,20,44064.833333332121,5.25,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.13,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",5.25,{"$error":"#N/A"},3.13,{"$error":"#N/A"},3.13,null,5.25]
[2020,8,21,21,44064.874999998785,8.1999999999999993,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.4,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",8.1999999999999993,{"$error":"#N/A"},3.4,{"$error":"#N/A"},3.4,null,8.1999999999999993]
[2020,8,21,22,44064.916666665449,6.91,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.69,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.91,{"$error":"#N/A"},3.69,{"$error":"#N/A"},3.69,null,6.91]
[2020,8,21,23,44064.958333332113,4.9400000000000004,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},4.04,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",4.9400000000000004,{"$error":"#N/A"},4.04,{"$error":"#N/A"},4.04,null,4.9400000000000004]
[2020,8,22,0,44064.999999998778,3.34,"Valid",4.6966666666666672,4.4000000000000004,"Valid",26.201249999999998,"","",3.34,4.6966666666666672,4.4000000000000004,26.201249999999998,4.4000000000000004,26.201249999999998,3.34,4.6966666666666672]
[2020,8,22,1,44065.041666665442,-7.0000000000000007E-2,"Valid",4.483888888888889,3.95,"Valid",22.258750000000003,"","",-7.0000000000000007E-2,4.483888888888889,3.95,22.258750000000003,3.95,22.258750000000003,-7.0000000000000007E-2,4.483888888888889]
[2020,8,22,2,44065.083333332106,4.49,"Valid",4.6900000000000004,4.21,"Valid",18.504166666666663,"","",4.49,4.6900000000000004,4.21,18.504166666666663,4.21,18.504166666666663,4.49,4.6900000000000004]
[2020,8,22,3,44065.12499999877,2.72,"Valid",4.6655555555555557,4.21,"Valid",15.100416666666662,"","",2.72,4.6655555555555557,4.21,15.100416666666662,4.21,15.100416666666662,2.72,4.6655555555555557]
[2020,8,22,4,44065.166666665435,-0.66,"Valid",4.3852631578947374,4.41,"Valid",12.264166666666663,"","",-0.66,4.3852631578947374,4.41,12.264166666666663,4.41,12.264166666666663,-0.66,4.3852631578947374]
[2020,8,22,5,44065.208333332099,-1.99,"Valid",4.2373684210526319,4.34,"Valid",9.9583333333333339,"","",-1.99,4.2373684210526319,4.34,9.9583333333333339,4.34,9.9583333333333339,-1.99,4.2373684210526319]
[2020,8,22,6,44065.249999998763,1.57,"Valid",4.0684210526315789,4.25,"Valid",8.0875000000000004,"","",1.57,4.0684210526315789,4.25,8.0875000000000004,4.25,8.0875000000000004,1.57,4.0684210526315789]
[2020,8,22,7,44065.291666665427,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,22,8,44065.333333332092,8.1300000000000008,"Valid",4.4155555555555548,4.16,"Valid",5.5466666666666669,"","",{"$f":"IF(G514=\"Valid\", F514, NA())","v":8.1300000000000008},{"$f":"IF(G514=\"Valid\", H514, NA())","v":4.4155555555555548},{"$f":"IF(J514=\"Valid\", I514, NA())","v":4.16},{"$f":"IF(J514=\"Valid\", K514, NA())","v":5.5466666666666669},4.16,5.5466666666666669,8.1300000000000008,4.4155555555555548]
[2020,8,22,9,44065.374999998756,3.3,"Valid",4.3568421052631576,4.4400000000000004,"Valid",4.847083333333333,"","",3.3,4.3568421052631576,4.4400000000000004,4.847083333333333,4.4400000000000004,4.847083333333333,3.3,4.3568421052631576]
[{"$f":"A515","v":2020},8,22,{"$f":"IF(D515=23,0,D515+1)","v":10},{"$f":"E515+0.0416666666666666","v":44065.41666666542},3.69,"Valid",3.9831578947368418,4.1500000000000004,"Valid",4.3437499999999991,"","",3.69,3.9831578947368418,4.1500000000000004,4.3437499999999991,4.1500000000000004,4.3437499999999991,3.69,3.9831578947368418]
[2020,8,22,11,44065.458333332084,2.79,"Valid",3.9234999999999998,5.09,"Valid",4.0883333333333338,"","",2.79,3.9234999999999998,5.09,4.0883333333333338,5.09,4.0883333333333338,2.79,3.9234999999999998]
[2020,8,22,12,44065.499999998749,4.5,"Valid",3.9740000000000002,5.13,"Valid",3.9862500000000001,"","",4.5,3.9740000000000002,5.13,3.9862500000000001,5.13,3.9862500000000001,4.5,3.9740000000000002]
[2020,8,22,13,44065.541666665413,4.18,"Valid",3.9838095238095237,5.29,"Valid",3.9770833333333333,"","",4.18,3.9838095238095237,5.29,3.9770833333333333,5.29,3.9770833333333333,4.18,3.9838095238095237]
[2020,8,22,14,44065.583333332077,-0.64,"Valid",4.0576190476190472,5.33,"Valid",4.0145833333333343,"","",-0.64,4.0576190476190472,5.33,4.0145833333333343,5.33,4.0145833333333343,-0.64,4.0576190476190472]
[2020,8,22,15,44065.624999998741,1.55,"Valid",3.9436363636363634,5.64,"Valid",4.121666666666667,"","",1.55,3.9436363636363634,5.64,4.121666666666667,5.64,4.121666666666667,1.55,3.9436363636363634]
[2020,8,22,16,44065.666666665406,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,22,17,44065.70833333207,10.1,"Valid",4.0647619047619044,5.42,"Valid",4.3204166666666675,"","",10.1,4.0647619047619044,5.42,4.3204166666666675,5.42,4.3204166666666675,10.1,4.0647619047619044]
[2020,8,22,18,44065.749999998734,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,22,19,44065.791666665398,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,22,20,44065.833333332062,11.6,"Valid",3.9324999999999997,4.74,"Valid",4.552083333333333,"","",11.6,3.9324999999999997,4.74,4.552083333333333,4.74,4.552083333333333,11.6,3.9324999999999997]
[2020,8,22,21,44065.874999998727,0.43,"Valid",3.5439999999999996,4.51,"Valid",4.5983333333333327,"","",0.43,3.5439999999999996,4.51,4.5983333333333327,4.51,4.5983333333333327,0.43,3.5439999999999996]
[2020,8,22,22,44065.916666665391,12.93,"Valid",3.8450000000000002,4.7699999999999996,"Valid",4.6433333333333326,"","",12.93,3.8450000000000002,4.7699999999999996,4.6433333333333326,4.7699999999999996,4.6433333333333326,12.93,3.8450000000000002]
[2020,8,22,23,44065.958333332055,2.75,"Valid",3.7355000000000005,4.71,"Valid",4.6712499999999988,"","",2.75,3.7355000000000005,4.71,4.6712499999999988,4.71,4.6712499999999988,2.75,3.7355000000000005]
[2020,8,23,0,44065.999999998719,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,1,44066.041666665384,4.8499999999999996,"Valid",4.0152631578947364,4.46,"Valid",4.6845833333333315,"","",4.8499999999999996,4.0152631578947364,4.46,4.6845833333333315,4.46,4.6845833333333315,4.8499999999999996,4.0152631578947364]
[2020,8,23,2,44066.083333332048,11.13,"Valid",4.3647368421052626,4.6399999999999997,"Valid",4.7024999999999988,"","",11.13,4.3647368421052626,4.6399999999999997,4.7024999999999988,4.6399999999999997,4.7024999999999988,11.13,4.3647368421052626]
[2020,8,23,3,44066.124999998712,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,4,44066.166666665376,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,5,44066.208333332041,-1.52,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.61,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-1.52,{"$error":"#N/A"},3.61,{"$error":"#N/A"},3.61,null,-1.52]
[2020,8,23,6,44066.249999998705,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,7,44066.291666665369,7.64,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.95,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",7.64,{"$error":"#N/A"},3.95,{"$error":"#N/A"},3.95,null,7.64]
[2020,8,23,8,44066.333333332033,5.38,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.78,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",5.38,{"$error":"#N/A"},3.78,{"$error":"#N/A"},3.78,null,5.38]
[2020,{"$f":"B538","v":8},{"$f":"C515+1","v":23},9,44066.374999998698,-1.64,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.61,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-1.64,{"$error":"#N/A"},3.61,{"$error":"#N/A"},3.61,null,-1.64]
[2020,8,23,10,44066.416666665362,6.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.62,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.16,{"$error":"#N/A"},3.62,{"$error":"#N/A"},3.62,null,6.16]
[2020,8,23,11,44066.458333332026,5.0999999999999996,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.67,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",5.0999999999999996,{"$error":"#N/A"},3.67,{"$error":"#N/A"},3.67,null,5.0999999999999996]
[2020,8,23,12,44066.49999999869,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,13,44066.541666665355,3.81,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.12,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",3.81,{"$error":"#N/A"},3.12,{"$error":"#N/A"},3.12,null,3.81]
[2020,8,23,14,44066.583333332019,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,15,44066.624999998683,8.73,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.08,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",8.73,{"$error":"#N/A"},3.08,{"$error":"#N/A"},3.08,null,8.73]
[2020,8,23,16,44066.666666665347,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,17,44066.708333332012,1.59,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.61,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",1.59,{"$error":"#N/A"},2.61,{"$error":"#N/A"},2.61,null,1.59]
[2020,8,23,18,44066.749999998676,9.35,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.13,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",9.35,{"$error":"#N/A"},3.13,{"$error":"#N/A"},3.13,null,9.35]
[2020,8,23,19,44066.79166666534,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,20,44066.833333332004,7.8,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.89,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",7.8,{"$error":"#N/A"},2.89,{"$error":"#N/A"},2.89,null,7.8]
[2020,8,23,21,44066.874999998668,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,23,22,44066.916666665333,-2.2200000000000002,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.82,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-2.2200000000000002,{"$error":"#N/A"},1.82,{"$error":"#N/A"},1.82,null,-2.2200000000000002]
[2020,8,23,23,44066.958333331997,0.24,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.61,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.24,{"$error":"#N/A"},1.61,{"$error":"#N/A"},1.61,null,0.24]
[2020,8,24,0,44066.999999998661,0.94,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.12,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.94,{"$error":"#N/A"},2.12,{"$error":"#N/A"},2.12,null,0.94]
[2020,8,24,1,44067.041666665325,4.4000000000000004,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},5.48,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",4.4000000000000004,{"$error":"#N/A"},5.48,{"$error":"#N/A"},5.48,null,4.4000000000000004]
[2020,8,24,2,44067.08333333199,9.85,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},9.7100000000000009,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",9.85,{"$error":"#N/A"},9.7100000000000009,{"$error":"#N/A"},9.7100000000000009,null,9.85]
[2020,8,24,3,44067.124999998654,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,4,44067.166666665318,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,5,44067.208333331982,17.47,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},16.29,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",17.47,{"$error":"#N/A"},16.29,{"$error":"#N/A"},16.29,null,17.47]
[2020,8,24,6,44067.249999998647,20.13,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},18,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",20.13,{"$error":"#N/A"},18,{"$error":"#N/A"},18,null,20.13]
[2020,8,24,7,44067.291666665311,26.78,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},25.1,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",26.78,{"$error":"#N/A"},25.1,{"$error":"#N/A"},25.1,null,26.78]
[2020,8,24,8,44067.333333331975,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,9,44067.374999998639,2.93,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},4.5199999999999996,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",2.93,{"$error":"#N/A"},4.5199999999999996,{"$error":"#N/A"},4.5199999999999996,null,2.93]
[2020,8,24,10,44067.416666665304,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,11,44067.458333331968,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,12,44067.499999998632,-0.79,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},null,"<18hrs of 1hr data for 24hr rolling average",-0.79,{"$error":"#N/A"},-0.16,{"$error":"#N/A"},-0.16,null,-0.79]
[2020,8,24,13,44067.541666665296,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,14,44067.583333331961,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,15,44067.624999998625,-1.31,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},0.6,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-1.31,{"$error":"#N/A"},0.6,{"$error":"#N/A"},0.6,null,-1.31]
[2020,8,24,16,44067.666666665289,0.56000000000000005,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.74,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.56000000000000005,{"$error":"#N/A"},1.74,{"$error":"#N/A"},1.74,null,0.56000000000000005]
[2020,8,24,17,44067.708333331953,4.12,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},4.1500000000000004,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",4.12,{"$error":"#N/A"},4.1500000000000004,{"$error":"#N/A"},4.1500000000000004,null,4.12]
[2020,8,24,18,44067.749999998618,4.92,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},7.76,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",4.92,{"$error":"#N/A"},7.76,{"$error":"#N/A"},7.76,null,4.92]
[2020,8,24,19,44067.791666665282,0.3,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.18,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.3,{"$error":"#N/A"},1.18,{"$error":"#N/A"},1.18,null,0.3]
[2020,8,24,20,44067.833333331946,6.67,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},7.15,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.67,{"$error":"#N/A"},7.15,{"$error":"#N/A"},7.15,null,6.67]
[2020,8,24,21,44067.87499999861,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,22,44067.916666665275,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,24,23,44067.958333331939,3.62,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},5.59,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",3.62,{"$error":"#N/A"},5.59,{"$error":"#N/A"},5.59,null,3.62]
[2020,8,25,0,44067.999999998603,0.68,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.7,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",{"$f":"IF(G578=\"Valid\", F578, NA())","v":0.68},{"$f":"IF(G578=\"Valid\", H578, NA())","v":{"$error":"#N/A"}},{"$f":"IF(J578=\"Valid\", I578, NA())","v":1.7},{"$f":"IF(J578=\"Valid\", K578, NA())","v":{"$error":"#N/A"}},1.7,null,0.68]
[2020,8,25,1,44068.041666665267,1.6,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.07,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",1.6,{"$error":"#N/A"},3.07,{"$error":"#N/A"},3.07,null,1.6]
[{"$f":"A579","v":2020},8,25,{"$f":"IF(D579=23,0,D579+1)","v":2},{"$f":"E579+0.0416666666666666","v":44068.083333331931},11.83,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},11.71,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",11.83,{"$error":"#N/A"},11.71,{"$error":"#N/A"},11.71,null,11.83]
[2020,8,25,3,44068.124999998596,0.97,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.85,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.97,{"$error":"#N/A"},1.85,{"$error":"#N/A"},1.85,null,0.97]
[2020,8,25,4,44068.16666666526,-2.15,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-2.2200000000000002,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-2.15,{"$error":"#N/A"},-2.2200000000000002,{"$error":"#N/A"},-2.2200000000000002,null,-2.15]
[2020,8,25,5,44068.208333331924,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,6,44068.249999998588,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,7,44068.291666665253,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,8,44068.333333331917,9.51,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},14.24,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",9.51,{"$error":"#N/A"},14.24,{"$error":"#N/A"},14.24,null,9.51]
[2020,8,25,9,44068.374999998581,0.37,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.55,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.37,{"$error":"#N/A"},1.55,{"$error":"#N/A"},1.55,null,0.37]
[2020,8,25,10,44068.416666665245,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,11,44068.45833333191,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,12,44068.499999998574,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,13,44068.541666665238,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,14,44068.583333331902,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,15,44068.624999998567,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Power Failure","Power outage, system reset, <18 hours of 1hr data for 24 hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,16,44068.666666665231,1.52,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.66,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",1.52,{"$error":"#N/A"},2.66,{"$error":"#N/A"},2.66,null,1.52]
[2020,8,25,17,44068.708333331895,-0.02,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.66,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-0.02,{"$error":"#N/A"},-0.66,{"$error":"#N/A"},-0.66,null,-0.02]
[2020,8,25,18,44068.749999998559,2.87,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},3.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",2.87,{"$error":"#N/A"},3.16,{"$error":"#N/A"},3.16,null,2.87]
[2020,8,25,19,44068.791666665224,3.92,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},5.16,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",3.92,{"$error":"#N/A"},5.16,{"$error":"#N/A"},5.16,null,3.92]
[2020,8,25,20,44068.833333331888,-1.55,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.69,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-1.55,{"$error":"#N/A"},-0.69,{"$error":"#N/A"},-0.69,null,-1.55]
[2020,8,25,21,44068.874999998552,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,25,22,44068.916666665216,4.6399999999999997,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},5.69,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",4.6399999999999997,{"$error":"#N/A"},5.69,{"$error":"#N/A"},5.69,null,4.6399999999999997]
[2020,8,25,23,44068.958333331881,6.11,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},6.49,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.11,{"$error":"#N/A"},6.49,{"$error":"#N/A"},6.49,null,6.11]
[2020,8,26,0,44068.999999998545,0.68,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.2000000000000002,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.68,{"$error":"#N/A"},2.2000000000000002,{"$error":"#N/A"},2.2000000000000002,null,0.68]
[2020,{"$f":"B602","v":8},{"$f":"C579+1","v":26},1,44069.041666665209,-1.67,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-0.65,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-1.67,{"$error":"#N/A"},-0.65,{"$error":"#N/A"},-0.65,null,-1.67]
[2020,8,26,2,44069.083333331873,6.97,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},6.75,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.97,{"$error":"#N/A"},6.75,{"$error":"#N/A"},6.75,null,6.97]
[2020,8,26,3,44069.124999998538,0.06,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},0.12,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.06,{"$error":"#N/A"},0.12,{"$error":"#N/A"},0.12,null,0.06]
[2020,8,26,4,44069.166666665202,0.96,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},-5.79,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.96,{"$error":"#N/A"},-5.79,{"$error":"#N/A"},-5.79,null,0.96]
[2020,8,26,5,44069.208333331866,1.38,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.76,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",1.38,{"$error":"#N/A"},2.76,{"$error":"#N/A"},2.76,null,1.38]
[2020,8,26,6,44069.24999999853,6.44,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},14.24,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.44,{"$error":"#N/A"},14.24,{"$error":"#N/A"},14.24,null,6.44]
[2020,8,26,7,44069.291666665194,0.9,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.54,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.9,{"$error":"#N/A"},2.54,{"$error":"#N/A"},2.54,null,0.9]
[2020,8,26,8,44069.333333331859,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed, <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,26,9,44069.374999998523,6.04,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},6.35,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.04,{"$error":"#N/A"},6.35,{"$error":"#N/A"},6.35,null,6.04]
[2020,8,26,10,44069.416666665187,5.45,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},5.62,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",5.45,{"$error":"#N/A"},5.62,{"$error":"#N/A"},5.62,null,5.45]
[2020,8,26,11,44069.458333331851,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,26,12,44069.499999998516,9.93,"Valid",3.0349999999999997,9.27,"Valid",3.1690000000000005,"","",9.93,3.0349999999999997,9.27,3.1690000000000005,9.27,3.1690000000000005,9.93,3.0349999999999997]
[2020,8,26,13,44069.54166666518,1.82,"Valid",2.9710526315789472,2.29,"Valid",3.1271428571428581,"","",1.82,2.9710526315789472,2.29,3.1271428571428581,2.29,3.1271428571428581,1.82,2.9710526315789472]
[2020,8,26,14,44069.583333331844,3.53,"Valid",2.9989999999999997,5.78,"Valid",3.2477272727272735,"","",3.53,2.9989999999999997,5.78,3.2477272727272735,5.78,3.2477272727272735,3.53,2.9989999999999997]
[2020,8,26,15,44069.624999998508,3.69,"Valid",3.0319047619047614,4.51,"Valid",3.3026086956521747,"","",3.69,3.0319047619047614,4.51,3.3026086956521747,4.51,3.3026086956521747,3.69,3.0319047619047614]
[2020,8,26,16,44069.666666665173,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,26,17,44069.708333331837,0.89,"Valid",3.153,2.0499999999999998,"Valid",3.2378260869565216,"","",0.89,3.153,2.0499999999999998,3.2378260869565216,2.0499999999999998,3.2378260869565216,0.89,3.153]
[2020,8,26,18,44069.749999998501,0.84,"Valid",3.0515000000000003,3.12,"Valid",3.2360869565217394,"","",0.84,3.0515000000000003,3.12,3.2360869565217394,3.12,3.2360869565217394,0.84,3.0515000000000003]
[2020,8,26,19,44069.791666665165,3.77,"Valid",3.044,5.01,"Valid",3.2295652173913045,"","",3.77,3.044,5.01,3.2295652173913045,5.01,3.2295652173913045,3.77,3.044]
[2020,8,26,20,44069.83333333183,2.31,"Valid",3.2370000000000005,6.74,"Valid",3.5526086956521739,"","",2.31,3.2370000000000005,6.74,3.5526086956521739,6.74,3.5526086956521739,2.31,3.2370000000000005]
[2020,8,26,21,44069.874999998494,6.35,"Valid",3.3852380952380954,10.92,"Valid",4.0695652173913039,"","",6.35,3.3852380952380954,10.92,4.0695652173913039,10.92,4.0695652173913039,6.35,3.3852380952380954]
[2020,8,26,22,44069.916666665158,9.1,"Valid",3.5976190476190473,10.1,"Valid",4.2613043478260861,"","",9.1,3.5976190476190473,10.1,4.2613043478260861,10.1,4.2613043478260861,9.1,3.5976190476190473]
[2020,8,26,23,44069.958333331822,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,27,0,44069.999999998487,4.62,"Valid",3.6690000000000005,5.27,"Valid",4.1352173913043471,"","",4.62,3.6690000000000005,5.27,4.1352173913043471,5.27,4.1352173913043471,4.62,3.6690000000000005]
[2020,8,27,1,44070.041666665151,10.37,"Valid",4.2710000000000008,17.39,"Valid",4.9195652173913036,"","",10.37,4.2710000000000008,17.39,4.9195652173913036,17.39,4.9195652173913036,10.37,4.2710000000000008]
[2020,8,27,2,44070.083333331815,1.23,"Valid",3.9840000000000009,3.78,"Valid",4.7904347826086946,"","",1.23,3.9840000000000009,3.78,4.7904347826086946,3.78,4.7904347826086946,1.23,3.9840000000000009]
[2020,8,27,3,44070.124999998479,4.18,"Valid",4.1900000000000004,5.25,"Valid",5.0134782608695643,"","",4.18,4.1900000000000004,5.25,5.0134782608695643,5.25,5.0134782608695643,4.18,4.1900000000000004]
[2020,8,27,4,44070.166666665144,9.1,"Valid",4.5970000000000013,15.95,"Valid",5.9586956521739127,"","",9.1,4.5970000000000013,15.95,5.9586956521739127,15.95,5.9586956521739127,9.1,4.5970000000000013]
[2020,8,27,5,44070.208333331808,1.17,"Valid",4.5865,-3.59,"Valid",5.6826086956521733,"","",1.17,4.5865,-3.59,5.6826086956521733,-3.59,5.6826086956521733,1.17,4.5865]
[2020,8,27,6,44070.249999998472,5.37,"Valid",4.5330000000000004,6.76,"Valid",5.3573913043478258,"","",5.37,4.5330000000000004,6.76,5.3573913043478258,6.76,5.3573913043478258,5.37,4.5330000000000004]
[2020,8,27,7,44070.291666665136,7.8,"Valid",4.8780000000000001,8.5500000000000007,"Valid",5.6186956521739129,"","",7.8,4.8780000000000001,8.5500000000000007,5.6186956521739129,8.5500000000000007,5.6186956521739129,7.8,4.8780000000000001]
[2020,8,27,8,44070.333333331801,-2.1,"Valid",4.5457142857142863,-2.0299999999999998,"Valid",5.3,"","",-2.1,4.5457142857142863,-2.0299999999999998,5.3,-2.0299999999999998,5.3,-2.1,4.5457142857142863]
[2020,8,27,9,44070.374999998465,18.7,"Valid",5.1485714285714286,17.5,"Valid",5.7645833333333343,"","",18.7,5.1485714285714286,17.5,5.7645833333333343,17.5,5.7645833333333343,18.7,5.1485714285714286]
[2020,8,27,10,44070.416666665129,7.73,"Valid",5.2571428571428571,8.6199999999999992,"Valid",5.8895833333333343,"","",7.73,5.2571428571428571,8.6199999999999992,5.8895833333333343,8.6199999999999992,5.8895833333333343,7.73,5.2571428571428571]
[2020,8,27,11,44070.458333331793,7.57,"Valid",5.3622727272727273,10.01,"Valid",6.3429166666666674,"","",7.57,5.3622727272727273,10.01,6.3429166666666674,10.01,6.3429166666666674,7.57,5.3622727272727273]
[2020,8,27,12,44070.499999998457,14.04,"Valid",5.549090909090908,16.07,"Valid",6.6262499999999998,"","",14.04,5.549090909090908,16.07,6.6262499999999998,16.07,6.6262499999999998,14.04,5.549090909090908]
[2020,8,27,13,44070.541666665122,-2.4700000000000002,"Valid",5.3540909090909086,0.52,"Valid",6.5524999999999993,null,null,-2.4700000000000002,5.3540909090909086,0.52,6.5524999999999993,0.52,6.5524999999999993,-2.4700000000000002,5.3540909090909086]
[2020,8,27,14,44070.583333331786,2.38,"Valid",5.3018181818181827,4.24,"Valid",6.4883333333333342,"","",2.38,5.3018181818181827,4.24,6.4883333333333342,4.24,6.4883333333333342,2.38,5.3018181818181827]
[2020,8,27,15,44070.62499999845,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,27,16,44070.666666665114,-1.47,"Valid",5.0672727272727265,1.53,"Valid",6.3500000000000014,"","",{"$f":"IF(G642=\"Valid\", F642, NA())","v":-1.47},{"$f":"IF(G642=\"Valid\", H642, NA())","v":5.0672727272727265},{"$f":"IF(J642=\"Valid\", I642, NA())","v":1.53},{"$f":"IF(J642=\"Valid\", K642, NA())","v":6.3500000000000014},1.53,6.3500000000000014,-1.47,5.0672727272727265]
[2020,8,27,17,44070.708333331779,1.88,"Valid",5.1122727272727273,2.35,"Valid",6.3625000000000007,"","",1.88,5.1122727272727273,2.35,6.3625000000000007,2.35,6.3625000000000007,1.88,5.1122727272727273]
[{"$f":"A643","v":2020},8,27,{"$f":"IF(D643=23,0,D643+1)","v":18},{"$f":"E643+0.0416666666666666","v":44070.749999998443},-2.04,"Valid",4.9813636363636355,0.13,"Valid",6.2379166666666679,"","",-2.04,4.9813636363636355,0.13,6.2379166666666679,0.13,6.2379166666666679,-2.04,4.9813636363636355]
[2020,8,27,19,44070.791666665107,3.36,"Valid",4.962727272727272,10.35,"Valid",6.4604166666666671,"","",3.36,4.962727272727272,10.35,6.4604166666666671,10.35,6.4604166666666671,3.36,4.962727272727272]
[2020,8,27,20,44070.833333331771,11.3,"Valid",5.3713636363636352,16.21,"Valid",6.8550000000000013,"","",11.3,5.3713636363636352,16.21,6.8550000000000013,16.21,6.8550000000000013,11.3,5.3713636363636352]
[2020,8,27,21,44070.874999998436,0.37,"Valid",5.0995454545454537,4.21,"Valid",6.5754166666666665,"","",0.37,5.0995454545454537,4.21,6.5754166666666665,4.21,6.5754166666666665,0.37,5.0995454545454537]
[2020,8,27,22,44070.9166666651,2.21,"Valid",4.7863636363636353,5.39,"Valid",6.3791666666666664,"","",2.21,4.7863636363636353,5.39,6.3791666666666664,5.39,6.3791666666666664,2.21,4.7863636363636353]
[2020,8,27,23,44070.958333331764,10.92,"Valid",5.0530434782608689,12.78,"Valid",6.89,"","",10.92,5.0530434782608689,12.78,6.89,12.78,6.89,10.92,5.0530434782608689]
[2020,8,28,0,44070.999999998428,1.19,"Valid",4.9039130434782603,2.5,"Valid",6.7745833333333332,"","",1.19,4.9039130434782603,2.5,6.7745833333333332,2.5,6.7745833333333332,1.19,4.9039130434782603]
[2020,8,28,1,44071.041666665093,4.2300000000000004,"Valid",4.6369565217391298,5.16,"Valid",6.2649999999999997,"","",4.2300000000000004,4.6369565217391298,5.16,6.2649999999999997,5.16,6.2649999999999997,4.2300000000000004,4.6369565217391298]
[2020,8,28,2,44071.083333331757,9.25,"Valid",4.9856521739130431,9.84,"Valid",6.5174999999999992,"","",9.25,4.9856521739130431,9.84,6.5174999999999992,9.84,6.5174999999999992,9.25,4.9856521739130431]
[2020,8,28,3,44071.124999998421,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,28,4,44071.166666665085,6.51,"Valid",4.9045454545454552,6.44,"Valid",5.6475,"","",6.51,4.9045454545454552,6.44,5.6475,6.44,5.6475,6.51,4.9045454545454552]
[2020,8,28,5,44071.20833333175,5.76,"Valid",5.1131818181818192,7.13,"Valid",6.0941666666666654,"","",5.76,5.1131818181818192,7.13,6.0941666666666654,7.13,6.0941666666666654,5.76,5.1131818181818192]
[2020,8,28,6,44071.249999998414,-0.7,"Valid",4.8372727272727278,0.12,"Valid",5.817499999999999,"","",-0.7,4.8372727272727278,0.12,5.817499999999999,0.12,5.817499999999999,-0.7,4.8372727272727278]
[2020,8,28,7,44071.291666665078,4.9800000000000004,"Valid",4.7090909090909099,6.08,"Valid",5.7145833333333336,"","",4.9800000000000004,4.7090909090909099,6.08,5.7145833333333336,6.08,5.7145833333333336,4.9800000000000004,4.7090909090909099]
[2020,8,28,8,44071.333333331742,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,28,9,44071.374999998407,0.78,"Valid",4.1800000000000006,1.43,"Valid",4.78,"","",0.78,4.1800000000000006,1.43,4.78,1.43,4.78,0.78,4.1800000000000006]
[2020,8,28,10,44071.416666665071,2.4300000000000002,"Valid",3.9276190476190487,2.48,"Valid",4.5241666666666669,"","",2.4300000000000002,3.9276190476190487,2.48,4.5241666666666669,2.48,4.5241666666666669,2.4300000000000002,3.9276190476190487]
[2020,8,28,11,44071.458333331735,0.27,"Valid",3.5800000000000005,2.5499999999999998,"Valid",4.2133333333333338,"","",0.27,3.5800000000000005,2.5499999999999998,4.2133333333333338,2.5499999999999998,4.2133333333333338,0.27,3.5800000000000005]
[2020,8,28,12,44071.499999998399,-1.41,"Valid",2.8442857142857143,1.56,"Valid",3.6087500000000006,"","",-1.41,2.8442857142857143,1.56,3.6087500000000006,1.56,3.6087500000000006,-1.41,2.8442857142857143]
[2020,8,28,13,44071.541666665064,-0.82,"Valid",2.922857142857143,0.48,"Valid",3.6070833333333336,"","",-0.82,2.922857142857143,0.48,3.6070833333333336,0.48,3.6070833333333336,-0.82,2.922857142857143]
[2020,8,28,14,44071.583333331728,-1.65,"Valid",2.7309523809523815,0.03,"Valid",3.431666666666668,"","",-1.65,2.7309523809523815,0.03,3.431666666666668,0.03,3.431666666666668,-1.65,2.7309523809523815]
[2020,8,28,15,44071.624999998392,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,28,16,44071.666666665056,6.33,"Valid",3.1023809523809525,7.91,"Valid",3.8279166666666673,"","",6.33,3.1023809523809525,7.91,3.8279166666666673,7.91,3.8279166666666673,6.33,3.1023809523809525]
[2020,{"$f":"B666","v":8},{"$f":"C643+1","v":28},17,44071.70833333172,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,28,18,44071.749999998385,-0.87,"Valid",3.222,0.62,"Valid",3.565416666666668,"","",-0.87,3.222,0.62,3.565416666666668,0.62,3.565416666666668,-0.87,3.222]
[2020,8,28,19,44071.791666665049,2.59,"Valid",3.1835,6.62,"Valid",3.4100000000000006,"","",2.59,3.1835,6.62,3.4100000000000006,6.62,3.4100000000000006,2.59,3.1835]
[2020,8,28,20,44071.833333331713,4.54,"Valid",2.8455000000000004,8.2100000000000009,"Valid",3.0766666666666658,"","",4.54,2.8455000000000004,8.2100000000000009,3.0766666666666658,8.2100000000000009,3.0766666666666658,4.54,2.8455000000000004]
[2020,8,28,21,44071.874999998377,1.1499999999999999,"Valid",2.8845000000000001,5.41,"Valid",3.1266666666666665,"","",1.1499999999999999,2.8845000000000001,5.41,3.1266666666666665,5.41,3.1266666666666665,1.1499999999999999,2.8845000000000001]
[2020,8,28,22,44071.916666665042,5.47,"Valid",3.0475000000000003,7.65,"Valid",3.2208333333333328,"","",5.47,3.0475000000000003,7.65,3.2208333333333328,7.65,3.2208333333333328,5.47,3.0475000000000003]
[2020,8,28,23,44071.958333331706,1.32,"Valid",2.5674999999999999,4.13,"Valid",2.8604166666666671,"","",1.32,2.5674999999999999,4.13,2.8604166666666671,4.13,2.8604166666666671,1.32,2.5674999999999999]
[2020,8,29,0,44071.99999999837,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,29,1,44072.041666665034,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,29,2,44072.083333331699,5.08,"Valid",2.3199999999999998,7.09,"Valid",2.25,"","",5.08,2.3199999999999998,7.09,2.25,7.09,2.25,5.08,2.3199999999999998]
[2020,8,29,3,44072.124999998363,6.91,"Valid",2.561578947368421,9.33,"Valid",2.8937499999999994,"","",6.91,2.561578947368421,9.33,2.8937499999999994,9.33,2.8937499999999994,6.91,2.561578947368421]
[2020,8,29,4,44072.166666665027,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,29,5,44072.208333331691,2.35,"Valid",2.1527777777777772,3.77,"Valid",2.4770833333333333,"","",2.35,2.1527777777777772,3.77,2.4770833333333333,3.77,2.4770833333333333,2.35,2.1527777777777772]
[2020,8,29,6,44072.249999998356,1.79,"Valid",2.2911111111111109,4,"Valid",2.6387499999999995,"","",1.79,2.2911111111111109,4,2.6387499999999995,4,2.6387499999999995,1.79,2.2911111111111109]
[2020,8,29,7,44072.29166666502,2.83,"Valid",2.1716666666666669,5.55,"Valid",2.6166666666666663,"","",2.83,2.1716666666666669,5.55,2.6166666666666663,5.55,2.6166666666666663,2.83,2.1716666666666669]
[2020,8,29,8,44072.333333331684,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,29,9,44072.374999998348,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High Negatives Removed (PM2.5), <18 hours of 1hr data for 24hr rolling average",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,29,10,44072.416666665013,-1.04,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},2.39,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-1.04,{"$error":"#N/A"},2.39,{"$error":"#N/A"},2.39,null,-1.04]
[2020,8,29,11,44072.458333331677,2.0499999999999998,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},5,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",2.0499999999999998,{"$error":"#N/A"},5,{"$error":"#N/A"},5,null,2.0499999999999998]
[2020,8,29,12,44072.499999998341,6.71,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},9.5299999999999994,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",6.71,{"$error":"#N/A"},9.5299999999999994,{"$error":"#N/A"},9.5299999999999994,null,6.71]
[2020,8,29,13,44072.541666665005,-2.23,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.62,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",-2.23,{"$error":"#N/A"},1.62,{"$error":"#N/A"},1.62,null,-2.23]
[2020,8,29,14,44072.58333333167,0.11,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},1.45,"Valid",{"$f":"NA()","v":{"$error":"#N/A"}},"              ","<18hrs of 1hr data for 24hr rolling average",0.11,{"$error":"#N/A"},1.45,{"$error":"#N/A"},1.45,null,0.11]
[2020,8,29,15,44072.624999998334,17.37,"Valid",3.4699999999999998,19.29,"Valid",3.8766666666666674,"","",17.37,3.4699999999999998,19.29,3.8766666666666674,19.29,3.8766666666666674,17.37,3.4699999999999998]
[2020,8,29,16,44072.666666664998,-0.05,"Valid",3.1155555555555563,3.84,"Valid",3.7070833333333333,"","",-0.05,3.1155555555555563,3.84,3.7070833333333333,3.84,3.7070833333333333,-0.05,3.1155555555555563]
[2020,8,29,17,44072.708333331662,5.43,"Valid",3.2373684210526323,6.89,"Valid",4.1791666666666663,"","",5.43,3.2373684210526323,6.89,4.1791666666666663,6.89,4.1791666666666663,5.43,3.2373684210526323]
[2020,8,29,18,44072.749999998327,2.87,"Valid",3.4342105263157894,5.15,"Valid",4.3679166666666678,"","",2.87,3.4342105263157894,5.15,4.3679166666666678,5.15,4.3679166666666678,2.87,3.4342105263157894]
[2020,8,29,19,44072.791666664991,4.0599999999999996,"Valid",3.5115789473684216,22.22,"Valid",5.0179166666666672,"","",4.0599999999999996,3.5115789473684216,22.22,5.0179166666666672,22.22,5.0179166666666672,4.0599999999999996,3.5115789473684216]
[2020,8,29,20,44072.833333331655,3.86,"Valid",3.4757894736842108,17.75,"Valid",5.4154166666666681,"","",3.86,3.4757894736842108,17.75,5.4154166666666681,17.75,5.4154166666666681,3.86,3.4757894736842108]
[2020,8,29,21,44072.874999998319,6.31,"Valid",3.7473684210526317,11.79,"Valid",5.6812499999999995,"","",6.31,3.7473684210526317,11.79,5.6812499999999995,11.79,5.6812499999999995,6.31,3.7473684210526317]
[2020,8,29,22,44072.916666664983,-0.68,"Valid",3.4236842105263157,4.9000000000000004,"Valid",5.5666666666666673,"","",-0.68,3.4236842105263157,4.9000000000000004,5.5666666666666673,4.9000000000000004,5.5666666666666673,-0.68,3.4236842105263157]
[2020,8,29,23,44072.958333331648,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,30,0,44072.999999998312,2.08,"Valid",3.4636842105263166,3.93,"Valid",5.4262500000000005,"","",{"$f":"IF(G698=\"Valid\", F698, NA())","v":2.08},{"$f":"IF(G698=\"Valid\", H698, NA())","v":3.4636842105263166},{"$f":"IF(J698=\"Valid\", I698, NA())","v":3.93},{"$f":"IF(J698=\"Valid\", K698, NA())","v":5.4262500000000005},3.93,5.4262500000000005,2.08,3.4636842105263166]
[2020,8,30,1,44073.041666664976,1.49,"Valid",3.3650000000000007,4.84,"Valid",5.7887500000000003,"","",1.49,3.3650000000000007,4.84,5.7887500000000003,4.84,5.7887500000000003,1.49,3.3650000000000007]
[2020,8,30,2,44073.08333333164,-0.26,"Valid",3.0980000000000003,2.0499999999999998,"Valid",5.5787500000000003,"","",-0.26,3.0980000000000003,2.0499999999999998,5.5787500000000003,2.0499999999999998,5.5787500000000003,-0.26,3.0980000000000003]
[2020,8,30,3,44073.124999998305,3.41,"Valid",2.9230000000000005,5.96,"Valid",5.4383333333333335,"","",3.41,2.9230000000000005,5.96,5.4383333333333335,5.96,5.4383333333333335,3.41,2.9230000000000005]
[2020,8,30,4,44073.166666664969,12.35,"Valid",3.3719047619047622,12.93,"Valid",5.9854166666666684,"","",12.35,3.3719047619047622,12.93,5.9854166666666684,12.93,5.9854166666666684,12.35,3.3719047619047622]
[2020,8,30,5,44073.208333331633,7.51,"Valid",3.6176190476190477,9.42,"Valid",6.2208333333333323,"","",7.51,3.6176190476190477,9.42,6.2208333333333323,9.42,6.2208333333333323,7.51,3.6176190476190477]
[2020,8,30,6,44073.249999998297,6.12,"Valid",3.8238095238095244,5.52,"Valid",6.2841666666666667,"","",6.12,3.8238095238095244,5.52,6.2841666666666667,5.52,6.2841666666666667,6.12,3.8238095238095244]
[2020,8,30,7,44073.291666664962,6.2,"Valid",3.9842857142857149,8.17,"Valid",6.3933333333333318,"","",6.2,3.9842857142857149,8.17,6.3933333333333318,8.17,6.3933333333333318,6.2,3.9842857142857149]
[2020,8,30,8,44073.333333331626,-1.49,"Valid",3.7354545454545462,1.22,"Valid",6.7437499999999986,"","",-1.49,3.7354545454545462,1.22,6.7437499999999986,1.22,6.7437499999999986,-1.49,3.7354545454545462]
[2020,8,30,9,44073.37499999829,10.59,"Valid",4.0334782608695665,11.3,"Valid",7.2337499999999997,"","",10.59,4.0334782608695665,11.3,7.2337499999999997,11.3,7.2337499999999997,10.59,4.0334782608695665]
[{"$f":"A707","v":2020},8,30,{"$f":"IF(D707=23,0,D707+1)","v":10},{"$f":"E707+0.0416666666666666","v":44073.416666664954},5.26,"Valid",4.3073913043478269,7.82,"Valid",7.46,"","",5.26,4.3073913043478269,7.82,7.46,7.82,7.46,5.26,4.3073913043478269]
[2020,8,30,11,44073.458333331619,12.29,"Valid",4.7526086956521754,14.4,"Valid",7.8516666666666666,"","",12.29,4.7526086956521754,14.4,7.8516666666666666,14.4,7.8516666666666666,12.29,4.7526086956521754]
[2020,8,30,12,44073.499999998283,4.26,"Valid",4.6460869565217404,7.03,"Valid",7.7474999999999996,"","",4.26,4.6460869565217404,7.03,7.7474999999999996,7.03,7.7474999999999996,4.26,4.6460869565217404]
[2020,8,30,13,44073.541666664947,5.31,"Valid",4.9739130434782615,9.69,"Valid",8.0837500000000002,"","",5.31,4.9739130434782615,9.69,8.0837500000000002,9.69,8.0837500000000002,5.31,4.9739130434782615]
[2020,8,30,14,44073.583333331611,9.14,"Valid",5.3665217391304365,12.13,"Valid",8.5287500000000005,"","",9.14,5.3665217391304365,12.13,8.5287500000000005,12.13,8.5287500000000005,9.14,5.3665217391304365]
[2020,8,30,15,44073.624999998276,9.86,"Valid",5.04,8.09,"Valid",8.0620833333333337,"","",9.86,5.04,8.09,8.0620833333333337,8.09,8.0620833333333337,9.86,5.04]
[2020,8,30,16,44073.66666666494,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,30,17,44073.708333331604,8.34,"Valid",5.4036363636363642,11.86,"Valid",8.1645833333333329,"","",8.34,5.4036363636363642,11.86,8.1645833333333329,11.86,8.1645833333333329,8.34,5.4036363636363642]
[2020,8,30,18,44073.749999998268,17.489999999999998,"Valid",6.0681818181818183,50.37,"Valid",10.04875,"","",17.489999999999998,6.0681818181818183,50.37,10.04875,50.37,10.04875,17.489999999999998,6.0681818181818183]
[2020,8,30,19,44073.791666664933,9.0399999999999991,"Valid",6.294545454545454,18.010000000000002,"Valid",9.8733333333333331,"","",9.0399999999999991,6.294545454545454,18.010000000000002,9.8733333333333331,18.010000000000002,9.8733333333333331,9.0399999999999991,6.294545454545454]
[2020,8,30,20,44073.833333331597,24.77,"Valid",7.245000000000001,37.520000000000003,"Valid",10.697083333333332,"","",24.77,7.245000000000001,37.520000000000003,10.697083333333332,37.520000000000003,10.697083333333332,24.77,7.245000000000001]
[2020,8,30,21,44073.874999998261,7.37,"Valid",7.2931818181818189,18.07,"Valid",10.95875,"","",7.37,7.2931818181818189,18.07,10.95875,18.07,10.95875,7.37,7.2931818181818189]
[2020,8,30,22,44073.916666664925,4.97,"Valid",7.5500000000000007,7.79,"Valid",11.079166666666667,"","",4.97,7.5500000000000007,7.79,11.079166666666667,7.79,11.079166666666667,4.97,7.5500000000000007]
[2020,8,30,23,44073.95833333159,3.45,"Valid",7.3717391304347828,6.74,"Valid",11.507916666666668,"","",3.45,7.3717391304347828,6.74,11.507916666666668,6.74,11.507916666666668,3.45,7.3717391304347828]
[2020,8,31,0,44073.999999998254,10.19,"Valid",7.724347826086956,11.34,"Valid",11.816666666666668,"","",10.19,7.724347826086956,11.34,11.816666666666668,11.34,11.816666666666668,10.19,7.724347826086956]
[2020,8,31,1,44074.041666664918,13.61,"Valid",8.2513043478260855,14.92,"Valid",12.236666666666666,"","",13.61,8.2513043478260855,14.92,12.236666666666666,14.92,12.236666666666666,13.61,8.2513043478260855]
[2020,8,31,2,44074.083333331582,10.72,"Valid",8.7286956521739132,11.91,"Valid",12.647500000000001,"","",10.72,8.7286956521739132,11.91,12.647500000000001,11.91,12.647500000000001,10.72,8.7286956521739132]
[2020,8,31,3,44074.124999998246,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[2020,8,31,4,44074.166666664911,4.28,"Valid",8.6036363636363618,5.25,"Valid",11.970416666666667,"","",4.28,8.6036363636363618,5.25,11.970416666666667,5.25,11.970416666666667,4.28,8.6036363636363618]
[2020,8,31,5,44074.208333331575,6.39,"Valid",8.552727272727271,4.6399999999999997,"Valid",11.77125,"","",6.39,8.552727272727271,4.6399999999999997,11.77125,4.6399999999999997,11.77125,6.39,8.552727272727271]
[2020,8,31,6,44074.249999998239,1.1399999999999999,"Valid",8.3263636363636344,4.33,"Valid",11.721666666666666,"","",1.1399999999999999,8.3263636363636344,4.33,11.721666666666666,4.33,11.721666666666666,1.1399999999999999,8.3263636363636344]
[2020,8,31,7,44074.291666664903,6.19,"Valid",8.3259090909090894,8.49,"Valid",11.734999999999999,"","",6.19,8.3259090909090894,8.49,11.734999999999999,8.49,11.734999999999999,6.19,8.3259090909090894]
[2020,8,31,8,44074.333333331568,7.38,"Valid",8.7290909090909068,10.25,"Valid",12.111249999999998,"","",7.38,8.7290909090909068,10.25,12.111249999999998,10.25,12.111249999999998,7.38,8.7290909090909068]
[2020,8,{"$f":"C707+1","v":31},9,44074.374999998232,23.33,"Valid",9.308181818181815,24.91,"Valid",12.678333333333333,"","",23.33,9.308181818181815,24.91,12.678333333333333,24.91,12.678333333333333,23.33,9.308181818181815]
[{"$f":"A731","v":2020},8,31,10,44074.416666664896,2.5499999999999998,"Valid",9.1849999999999969,5.15,"Valid",12.567083333333331,"","",2.5499999999999998,9.1849999999999969,5.15,12.567083333333331,5.15,12.567083333333331,2.5499999999999998,9.1849999999999969]
[2020,8,31,11,44074.45833333156,7.3,"Valid",8.9581818181818171,10.1,"Valid",12.387916666666667,"","",7.3,8.9581818181818171,10.1,12.387916666666667,10.1,12.387916666666667,7.3,8.9581818181818171]
[2020,8,31,12,44074.499999998225,-0.44,"Valid",8.7445454545454542,4.0599999999999996,"Valid",12.264166666666666,"","",-0.44,8.7445454545454542,4.0599999999999996,12.264166666666666,4.0599999999999996,12.264166666666666,-0.44,8.7445454545454542]
[2020,8,31,13,44074.541666664889,7.55,"Valid",8.8463636363636358,12.19,"Valid",12.368333333333332,"","",7.55,8.8463636363636358,12.19,12.368333333333332,12.19,12.368333333333332,7.55,8.8463636363636358]
[2020,8,31,14,44074.583333331553,4.93,"Valid",8.6550000000000011,10.14,"Valid",12.285416666666665,"","",4.93,8.6550000000000011,10.14,12.285416666666665,10.14,12.285416666666665,4.93,8.6550000000000011]
[2020,8,31,15,44074.624999998217,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A737","v":2020},8,31,16,44074.666666664882,5.92,"Valid",8.4759090909090933,13.75,"Valid",12.519166666666663,"","",5.92,8.4759090909090933,13.75,12.519166666666663,13.75,12.519166666666663,5.92,8.4759090909090933]
[{"$f":"A738","v":2020},8,31,17,44074.708333331546,5.5,"Valid",8.3468181818181826,15.22,"Valid",12.659166666666666,"","",5.5,8.3468181818181826,15.22,12.659166666666666,15.22,12.659166666666666,5.5,8.3468181818181826]
[{"$f":"A739","v":2020},8,31,18,44074.74999999821,5.98,"Valid",7.8236363636363642,14.19,"Valid",11.151666666666666,"","",5.98,7.8236363636363642,14.19,11.151666666666666,14.19,11.151666666666666,5.98,7.8236363636363642]
[{"$f":"A740","v":2020},8,31,19,44074.791666664874,2.02,"Valid",7.504545454545454,7.85,"Valid",10.728333333333333,"","",2.02,7.504545454545454,7.85,10.728333333333333,7.85,10.728333333333333,2.02,7.504545454545454]
[{"$f":"A741","v":2020},8,31,20,44074.833333331539,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A742","v":2020},8,31,21,44074.874999998203,13.72,"Valid",6.9847619047619052,16.11,"Valid",9.1316666666666677,"","",13.72,6.9847619047619052,16.11,9.1316666666666677,16.11,9.1316666666666677,13.72,6.9847619047619052]
[{"$f":"A743","v":2020},8,31,22,44074.916666664867,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"A744","v":2020},8,31,23,44074.958333331531,{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},"Invalid",{"$f":"NA()","v":{"$error":"#N/A"}},"Calibration Error","High negatives removed (PM2.5)",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"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"]