{"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","NH","VT","CT","MA","RI","DE","DC","MD","NJ","NY","PA","VA-OTC","OTC","OTC NEAR ROAD"]
[2015,7.7655760529063445,3.4056469490141184,7.1766948647682396,10.355609821496984,10.075929006305724,11.629761630363818,12.177754364840441,13.636445771883674,10.975446917808229,14.340632800957783,13.136817405957878,8.7363110027574251,8.5018647486394734,10.563238034693315,15.660031944279739]
[2016,6.0986370986370897,3.0451999510823016,6.0289479947637821,12.654852683001311,8.7595935611645981,10.421246929218517,11.579329377673531,13.398978497684622,11.400929636798322,13.587881194523922,12.063460771207357,7.4912494678187551,9.0941610392583403,10.062815167274971,14.763121715381146]
[2017,7.6085071859063227,2.6433433193529128,6.225725154541129,12.531030563514802,7.9709438214358954,10.069645247657354,10.65227001194744,11.70715258751906,10.293897260273964,12.493093879104132,11.645507348064848,6.3916889578752736,8.6913070776255648,9.3410731780505412,13.733961222909512]
[2018,7.6936682039137576,2.5275419062767486,6.2271158586688484,10.423818695428873,8.3622050834303483,11.432356389214519,9.8847344575887348,11.143863489345526,10.023914003044139,12.157784165035828,12.973313276799335,5.5595234520614669,8.6011522988506108,9.1517072621248285,13.2164703038844]
[2019,6.963033064610344,2.6437238493723823,6.2489297181591077,10.000183226368735,8.3131226155487656,11.479476060354079,10.291181742508343,11.691868150684977,10.438376331811236,13.092818556570258,11.774807391552464,6.3670639379135023,9.2173013851912113,9.3865937026865502,13.469329736099809]
[2020,6.409607401257273,2.4609088343212076,5.3242899584075989,9.7334796519567597,7.8093564732371323,10.261347642505234,9.4047308921110702,9.8747051457194921,9.0674726242438073,11.425064438951011,11.154942083550191,6.4645441921847278,7.4448132580991917,8.5451101716741551,12.187825827649018]
[2021,6.4249255331824031,3.1339751552795057,5.3758308516974367,9.7709732809274126,7.334042461566348,10.442766333137108,8.6807212672733662,11.269848363774742,9.8785081811263247,11.788485540334815,10.956331115459879,7.1553280569915252,8.0993690669136278,8.9639798282655772,12.900974530729952]
["Grand Total",6.9913911416094834,2.8089427678677166,6.0868608556984247,10.796362863004765,8.3797135446445736,10.817180872915388,10.38619336919996,11.816973380817894,10.298432535473973,12.696851734095652,11.957610043469188,6.8808915147965442,8.5219358854397171,9.4305462480171922,13.704351593697195]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 Nitrogen Dioxide 1-hr Concentrations \" &TEXT(O47,\"mmm d\")&\" - \" &TEXT(P47,\"mmm d\")&\"  (2021 data are preliminary)\"","v":"Average Nitrogen Dioxide 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":"NH"},"VT","CT","MA","RI","DE","DC","MD","NJ","NY","PA","VA-OTC","OTC","OTC NEAR ROAD","","","",""]
["2021/2015-100%",{"$f":"IF(B70=\"\",\"\",IF(B64=\"\",\"\",B70/B64-100%))","v":-0.17264018929055358},{"$f":"IF(C70=\"\",\"\",IF(C64=\"\",\"\",C70/C64-100%))","v":-7.9770979729198666E-2},-0.25093222534952497,-5.6456022450356969E-2,-0.27212245570839644,-0.10206531612201042,-0.2871656787283946,-0.17354943125931721,-9.9944789938536838E-2,-0.17796615365902924,-0.16598284219959503,-0.18096688010155515,-4.7342047142099664E-2,-0.15139848228121178,-0.1761846606294829,{"$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":5.3501861033546705E-2},{"$f":"IF(C70=\"\",\"\",IF(C65=\"\",\"\",C70/C65-100%))","v":2.9152504145303348E-2},-0.1083302001665275,-0.22788723617049156,-0.1627416945368777,2.0649548048090605E-3,-0.25032607812237051,-0.15890242187326442,-0.13353485234731555,-0.13242650774090403,-9.1775459525672454E-2,-4.4841840105618758E-2,-0.10938798730859522,-0.10919760730405637,-0.1261350560234894,"","","",""]
["2021/2017-100%",{"$f":"IF(B70=\"\",\"\",IF(B66=\"\",\"\",B70/B66-100%))","v":-0.15556029899220392},{"$f":"IF(C70=\"\",\"\",IF(C66=\"\",\"\",C70/C66-100%))","v":0.18561033382780523},-0.13651330274735429,-0.22025780470311351,-7.9902879023781015E-2,3.7054044735742586E-2,-0.18508249814009703,-3.7353593922618389E-2,-4.0352945890639647E-2,-5.6399827423680882E-2,-5.9179579902071899E-2,0.11947375789858539,-6.8106903302932453E-2,-4.0369381825532624E-2,-6.0651597791761769E-2,"","","",""]
["2021/2018-100%",{"$f":"IF(B70=\"\",\"\",IF(B67=\"\",\"\",B70/B67-100%))","v":-0.16490738060239551},{"$f":"IF(C70=\"\",\"\",IF(C67=\"\",\"\",C70/C67-100%))","v":0.2399300472513537},-0.13670614555634564,-6.2630158253591861E-2,-0.12295352859753439,-8.6560462461702792E-2,-0.12180531459709776,1.1305313866206923E-2,-1.4505892795334874E-2,-3.0375487809947033E-2,-0.15547162997647646,0.28703981891439545,-5.8339070685219374E-2,-2.0512832030388339E-2,-2.3871409377867026E-2,"","","",""]
["2021/2019-100%",{"$f":"IF(B70=\"\",\"\",IF(B68=\"\",\"\",B70/B68-100%))","v":-7.7280622745118821E-2},{"$f":"IF(C70=\"\",\"\",IF(C68=\"\",\"\",C70/C68-100%))","v":0.18543968048081449},-0.13971974495480166,-2.2920574578767283E-2,-0.11777525717606496,-9.0309847049325542E-2,-0.15648936298373517,-3.6095154467296275E-2,-5.3635559103066499E-2,-9.9622018788376177E-2,-6.9510799529492129E-2,0.12380339301828003,-0.12128629319571638,-4.5023134888646177E-2,-4.2196250036598326E-2,"","","",""]
["2021/2020-100%",{"$f":"IF(B70=\"\",\"\",IF(B69=\"\",\"\",B70/B69-100%))","v":2.3898705437286338E-3},{"$f":"IF(C70=\"\",\"\",IF(C69=\"\",\"\",C70/C69-100%))","v":0.27350315118192903},9.6803317799116773E-3,3.8520272617117435E-3,-6.0864683703413691E-2,1.7679811361267062E-2,-7.6983555738423304E-2,0.14128454444637462,8.9444500192263243E-2,3.1809107364402012E-2,-1.7804751167932786E-2,0.10685731959910139,8.7921051357782165E-2,4.9018637346527782E-2,5.8513201055359731E-2,{"$f":"IF($B$70=\"\",\"\",IF(Q69=\"\",\"\",$B$70/Q69-100%))","v":""},"","",""]
[]
[]
["Row Labels","ME-OTC","NH","VT","CT","MA","RI","DE","DC","MD","NJ","NY","PA","VA-OTC","OTC","OTC NEAR ROAD"]
[2015,7.7655760529063445,3.4056469490141184,7.1766948647682396,10.355609821496984,10.075929006305724,11.629761630363818,12.177754364840441,13.636445771883674,10.975446917808229,14.340632800957783,13.136817405957878,8.7363110027574251,8.5018647486394734,10.563238034693315,15.660031944279739]
[2016,6.0986370986370897,3.0451999510823016,6.0289479947637821,12.654852683001311,8.7595935611645981,10.421246929218517,11.579329377673531,13.398978497684622,11.400929636798322,13.587881194523922,12.063460771207357,7.4912494678187551,9.0941610392583403,10.062815167274971,14.763121715381146]
[2017,7.6085071859063227,2.6433433193529128,6.225725154541129,12.531030563514802,7.9709438214358954,10.069645247657354,10.65227001194744,11.70715258751906,10.293897260273964,12.493093879104132,11.645507348064848,6.3916889578752736,8.6913070776255648,9.3410731780505412,13.733961222909512]
[2018,7.6936682039137576,2.5275419062767486,6.2271158586688484,10.423818695428873,8.3622050834303483,11.432356389214519,9.8847344575887348,11.143863489345526,10.023914003044139,12.157784165035828,12.973313276799335,5.5595234520614669,8.6011522988506108,9.1517072621248285,13.2164703038844]
[2019,6.963033064610344,2.6437238493723823,6.2489297181591077,10.000183226368735,8.3131226155487656,11.479476060354079,10.291181742508343,11.691868150684977,10.438376331811236,13.092818556570258,11.774807391552464,6.3670639379135023,9.2173013851912113,9.3865937026865502,13.469329736099809]
[2020,6.409607401257273,2.4609088343212076,5.3242899584075989,9.7334796519567597,7.8093564732371323,10.261347642505234,9.4047308921110702,9.8747051457194921,9.0674726242438073,11.425064438951011,11.154942083550191,6.4645441921847278,7.4448132580991917,8.5451101716741551,12.187825827649018]
[2021,6.4249255331824031,3.1339751552795057,5.3758308516974367,9.7709732809274126,7.334042461566348,10.442766333137108,8.6807212672733662,11.269848363774742,9.8785081811263247,11.788485540334815,10.956331115459879,7.1553280569915252,8.0993690669136278,8.9639798282655772,12.900974530729952]

{"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","2021 AQS COMPLETE"]
[9,"Connecticut",null,null,"2020-12-31"]
[10,"Delaware",null,null,"2020-06-30"]
[11,"DC",null,null,"2020-12-31"]
[23,"Maine",null,null,"2020-12-31"]
[24,"Maryland",null,null,"2020-12-31"]
[25,"Massachusetts",null,null,"2020-10-30"]
[33,"New Hampshire",null,null,"2020-12-31"]
[34,"New Jersey",null,null,"2020-12-31"]
[36,"New York",null,null,"2022-12-30"]
[42,"Pennsylvania",null,null,"2020-09-30"]
[44,"Rhode Island",null,null,"2022-12-12"]
[50,"Vermont",null,null,"2020-12-31"]
[51,"Virginia OTC",null,null,"2020-12-31"]