{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PLOT","HOURLY","Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"unopened":[],"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":"part_too_large","date_system":"1900"}

{"sheet":"PLOT","index":0,"n_rows":70,"n_cols":20,"rows_kept":70,"cut":false,"hidden":false,"merged":[[51,0,52,1]]}
["ProperSort","(All)"]
[]
["Row Labels","ME-OTC","VT","MA","RI","DE","DC","MD","NJ","NY","PA","OTC","OTC NEAR ROAD"]
[2015,17.188107669103118,11.153002502085048,15.942152732478045,25.569874764703638,18.842178812922565,22.480037574787467,19.601852168949819,25.496186862880332,{"$error":"#DIV/0!"},14.011828751371073,16.875806387620752,35.48763687803492]
[2016,7.484643959309655,9.3587766273950095,13.798552879333256,22.919629011208333,18.08439569536425,21.935244249601418,20.898120991308915,24.287720413377919,16.912234368494659,12.029266797188017,16.374104828206914,29.276971761222359]
[2017,8.1710273424093085,9.4268069424631413,12.189600050425327,20.829119334480868,15.841628853984856,18.761375761035069,17.811383561643751,21.685778430093489,15.767626478038704,10.564905064300323,14.724138239871065,26.154314085736768]
[2018,7.298350704386678,9.588660640920299,12.95021822164593,25.879618991793706,15.237943619431158,18.290542275494619,18.298752853881275,21.322491981952524,20.664441169048644,9.5108582802440189,15.012434116479868,26.197440502537102]
[2019,6.3127902985928541,9.4962004994648783,13.1525749003888,24.822810977783107,15.286709211986704,19.827661054033481,19.073982718586972,21.841817116039632,20.737804409902164,10.264190537915294,15.037637831546231,25.570232754526664]
[2020,9.2093151171043282,8.1367914438502638,12.842100210476005,22.651513019000706,14.339395428852296,16.626237951578599,24.372605739310789,20.169479270571312,16.152648064663012,9.8841021066948453,14.260751438423531,22.902699966368314]
[2021,8.3054330990110508,8.0989041095890482,11.823771257016231,21.92905826957033,11.576070104482692,18.299757800608813,26.331962134251309,20.139346144089288,14.782521409991567,10.823834762128955,14.47777486589953,23.269839453776196]
["Grand Total",9.1268195207519263,9.3229057103111543,13.250364156941767,23.508269546777029,15.64617778980752,19.459261470506995,20.904074909059339,22.131362579933544,17.499512317956899,11.012668505414988,15.251858142238595,26.979180325980135]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1st day","last day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January 1","December 31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Average NOx 1-hr Concentrations \" &TEXT(O47,\"mmm d\")&\" - \" &TEXT(P47,\"mmm d\")&\"  (2021 data are preliminary)\"","v":"Average NOx 1-hr Concentrations Jan 1 - Dec 31  (2021 data are preliminary)"}]
[]
[]
["Click on the CALCULATE MACRO to update the % change between years table below:"]
["CALCULATE MACRO"]
[]
["Row Labels",{"$f":"IF(B63=\"\",\"\",B63)","v":"ME-OTC"},{"$f":"IF(C63=\"\",\"\",C63)","v":"VT"},"MA","RI","DE","DC","MD","NJ","NY","PA","OTC","OTC NEAR ROAD","","","","","","",""]
["2021/2015-100%",{"$f":"IF(B70=\"\",\"\",IF(B64=\"\",\"\",B70/B64-100%))","v":-0.51679188547668486},{"$f":"IF(C70=\"\",\"\",IF(C64=\"\",\"\",C70/C64-100%))","v":-0.27383643031775862},-0.25833283274671359,-0.14238695060638507,-0.38562996246785131,-0.18595519514909775,0.34334051227884865,-0.21010360284855067,{"$error":"#N/A"},-0.22752162089692751,-0.14209878133469811,-0.34428320674744428,"","","",{"$f":"IF($B$70=\"\",\"\",IF(Q64=\"\",\"\",$B$70/Q64-100%))","v":""},{"$f":"IF($B$70=\"\",\"\",IF(R64=\"\",\"\",$B$70/R64-100%))","v":""},"",""]
["2021/2016-100%",{"$f":"IF(B70=\"\",\"\",IF(B65=\"\",\"\",B70/B65-100%))","v":0.10966308406433556},{"$f":"IF(C70=\"\",\"\",IF(C65=\"\",\"\",C70/C65-100%))","v":-0.13461935976953043},-0.14311512515741764,-4.321931830369441E-2,-0.35988626330211859,-0.16573722214461617,0.26001577582990421,-0.17080130200295229,-0.12592735602520244,-0.1002082716579904,-0.11581274104466854,-0.20518284324072988,"","","","","","",""]
["2021/2017-100%",{"$f":"IF(B70=\"\",\"\",IF(B66=\"\",\"\",B70/B66-100%))","v":1.6449064599765695E-2},{"$f":"IF(C70=\"\",\"\",IF(C66=\"\",\"\",C70/C66-100%))","v":-0.14086454098179757},-3.0011550165366607E-2,5.2807750410676535E-2,-0.26926263636262326,-2.460469670806209E-2,0.47837825417203161,-7.1310895801564023E-2,-6.2476433559559563E-2,2.4508473692165689E-2,-1.6731938396531421E-2,-0.11028676273080384,"","","","","","",""]
["2021/2018-100%",{"$f":"IF(B70=\"\",\"\",IF(B67=\"\",\"\",B70/B67-100%))","v":0.13798766809315777},{"$f":"IF(C70=\"\",\"\",IF(C67=\"\",\"\",C70/C67-100%))","v":-0.15536648830532263},-8.698285583689036E-2,-0.15265142518041241,-0.24031284052520774,5.0384100019496003E-4,0.43900310280796773,-5.5488159585880381E-2,-0.28463967212755115,0.13805026246813656,-3.5614427775800706E-2,-0.1117514151230683,"","","","","","",""]
["2021/2019-100%",{"$f":"IF(B70=\"\",\"\",IF(B68=\"\",\"\",B70/B68-100%))","v":0.31565167004872063},{"$f":"IF(C70=\"\",\"\",IF(C68=\"\",\"\",C70/C68-100%))","v":-0.14714267984912166},-0.10102992405945455,-0.1165763503095093,-0.24273629177131228,-7.7059177542973534E-2,0.38051724816714194,-7.7945482415935352E-2,-0.2871703716651407,5.4523951221128408E-2,-3.723077865808222E-2,-8.9963721599023438E-2,"","","","","","",""]
["2021/2020-100%",{"$f":"IF(B70=\"\",\"\",IF(B69=\"\",\"\",B70/B69-100%))","v":-9.8148668668586514E-2},{"$f":"IF(C70=\"\",\"\",IF(C69=\"\",\"\",C70/C69-100%))","v":-4.656299048914514E-3},-7.9296138230494972E-2,-3.1894326388897776E-2,-0.19270863531732418,0.10065535293697159,8.039174866642429E-2,-1.493996254330221E-3,-8.4823655488963312E-2,9.5075166695981039E-2,1.5218232251861696E-2,1.6030402002690236E-2,"","","",{"$f":"IF($B$70=\"\",\"\",IF(Q69=\"\",\"\",$B$70/Q69-100%))","v":""},"","",""]
[]
[]
["Row Labels","ME-OTC","VT","MA","RI","DE","DC","MD","NJ","NY","PA","OTC","OTC NEAR ROAD"]
[2015,17.188107669103118,11.153002502085048,15.942152732478045,25.569874764703638,18.842178812922565,22.480037574787467,19.601852168949819,25.496186862880332,{"$error":"#N/A"},14.011828751371073,16.875806387620752,35.48763687803492]
[2016,7.484643959309655,9.3587766273950095,13.798552879333256,22.919629011208333,18.08439569536425,21.935244249601418,20.898120991308915,24.287720413377919,16.912234368494659,12.029266797188017,16.374104828206914,29.276971761222359]
[2017,8.1710273424093085,9.4268069424631413,12.189600050425327,20.829119334480868,15.841628853984856,18.761375761035069,17.811383561643751,21.685778430093489,15.767626478038704,10.564905064300323,14.724138239871065,26.154314085736768]
[2018,7.298350704386678,9.588660640920299,12.95021822164593,25.879618991793706,15.237943619431158,18.290542275494619,18.298752853881275,21.322491981952524,20.664441169048644,9.5108582802440189,15.012434116479868,26.197440502537102]
[2019,6.3127902985928541,9.4962004994648783,13.1525749003888,24.822810977783107,15.286709211986704,19.827661054033481,19.073982718586972,21.841817116039632,20.737804409902164,10.264190537915294,15.037637831546231,25.570232754526664]
[2020,9.2093151171043282,8.1367914438502638,12.842100210476005,22.651513019000706,14.339395428852296,16.626237951578599,24.372605739310789,20.169479270571312,16.152648064663012,9.8841021066948453,14.260751438423531,22.902699966368314]
[2021,8.3054330990110508,8.0989041095890482,11.823771257016231,21.92905826957033,11.576070104482692,18.299757800608813,26.331962134251309,20.139346144089288,14.782521409991567,10.823834762128955,14.47777486589953,23.269839453776196]

{"sheet":"HOURLY","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"read":"part_too_large"}

{"sheet":"Sheet1","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LAST DATE"]
["Code","State","PARSED","SEQUENTIAL","2020 AQS COMPLETE"]
[9,"Connecticut",null,null,"XXX"]
[10,"Delaware",null,null,"2022-06-30"]
[11,"DC",null,null,"2022-12-31"]
[23,"Maine",null,null,"2022-12-31"]
[24,"Maryland",null,null,"2022-12-31"]
[25,"Massachusetts",null,null,"2022-10-31"]
[33,"New Hampshire",null,null,"XXX"]
[34,"New Jersey",null,null,"2022-12-31"]
[36,"New York",null,null,"2022-12-30"]
[42,"Pennsylvania",null,null,"2022-09-30"]
[44,"Rhode Island",null,null,"2022-12-12"]
[50,"Vermont",null,null,"2022-12-31"]
[51,"Virginia OTC",null,null,"XXX"]