{"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":71,"n_cols":20,"rows_kept":71,"cut":false,"hidden":false,"merged":[[52,0,53,1]]}
["ProperSort","(All)"]
[]
["Row Labels","ME-OTC","NH","VT","CT","MA","RI","DE","DC","MD","NJ","NY","PA","VA-OTC","OTC"]
[2015,0.76536310612992631,0.83303921568627903,0.35434305317325587,0.44333869485294092,0.74738567351598229,0.35593357167569084,0.44029375951292615,1.3331497771522418,0.92703770928462848,0.3178061625715749,1.01400343727102,1.5360761620213474,0.78293416776987701,0.97852284984681326]
[2016,0.66637411549873993,0.77168929283633181,0.11183055110907854,0.39615348517797777,0.79249491499696101,0.25448105057020015,0.35309404531480054,1.0395418719211795,0.66397880374966378,0.27530950935322307,0.45466069171743467,0.93694654106608666,0.34497668997669118,0.62727315635198699]
[2017,1.3302711360256247,0.83831204939408133,0.23528226737473881,0.27338503510378087,0.68280137012662001,0.24192899816175592,0.25871484568253394,1.0083001827944678,0.96205730321809169,0.16605539247662623,0.33115715182117594,0.84335572396424863,0.30965361266515729,0.64016185260776026]
[2018,0.51392579464897759,0.89222158107328564,0.40975122955507343,0.24045492289442053,0.56424256981058185,0.27271855138505824,0.24940905631658411,0.84608319972514923,1.1839105240269561,0.32723052565775024,0.24294756300210205,0.71199065199672451,0.50299765807962826,0.57873095364402072]
[2019,8.8260794671566126E-2,0.82262388302193401,0.31529888492930014,0.22086163669839762,0.33681144443132005,0.22883981944615306,0.28939421613393601,0.69492289211760883,0.83110792164793745,0.33940762484598141,0.23489003701697828,0.73937352465039174,0.41560877772533916,0.52639372497887271]
[2020,0.15011297500855758,0.84634494464375154,0.33344798083504462,0.21822342384702739,0.29537548973515043,0.15571858540256367,0.28343328779599442,0.92827090069284068,0.37793091074441404,0.51567922015497103,0.22217701546303942,0.51434917145092685,0.22623556031916375,0.4589939727305542]
[2021,0.11502652050919175,0.97369670991659751,0.2766805905241479,0.19253032653223656,0.27399174041297869,0.15994653056265049,0.28010943146535655,0.72061907678563575,0.34746308980212326,0.42528334058128597,0.23093353959206628,0.64689476126945977,0.41732991014121318,0.48674260694401733]
["Grand Total",0.52034029008338045,0.85390698301130741,0.29101450105567084,0.28472559607137682,0.53040112975577036,0.23997108597685485,0.30882111402251783,0.93802303014170696,0.75659628491542108,0.33815513759821186,0.39013243609029041,0.8469031605418359,0.42787150762584997,0.61377600503404472]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 Sulfur Dioxide 1-hr Concentrations \"&TEXT(O49,\"mmm d\")&\" - \"&TEXT(P49,\"mmm d\")&\" (2021 data are preliminary)\"","v":"Average Sulfur 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(B64=\"\",\"\",B64)","v":"ME-OTC"},{"$f":"IF(C64=\"\",\"\",C64)","v":"NH"},"VT","CT","MA","RI","DE","DC","MD","NJ","NY","PA","VA-OTC","OTC","","","","",""]
["2020/2014-100%",{"$f":"IF(B71=\"\",\"\",IF(B65=\"\",\"\",B71/B65-100%))","v":-0.84970987027213052},{"$f":"IF(C71=\"\",\"\",IF(C65=\"\",\"\",C71/C65-100%))","v":0.16884858669521496},-0.21917309215918213,-0.56572631992770117,-0.63339979595271223,-0.55062814162305007,-0.36381239703413715,-0.45946127799311542,-0.62518990724740664,0.33818468823903158,-0.7722556639318936,-0.5788654382747529,-0.46696679322356971,-0.50257410236233491,"",{"$f":"IF($B$70=\"\",\"\",IF(Q65=\"\",\"\",$B$70/Q65-100%))","v":""},"","",""]
["2020/2015-100%",{"$f":"IF(B71=\"\",\"\",IF(B66=\"\",\"\",B71/B66-100%))","v":-0.82738447092426226},{"$f":"IF(C71=\"\",\"\",IF(C66=\"\",\"\",C71/C66-100%))","v":0.26177299459189163},1.4741055800956939,-0.51400067464826293,-0.65426687890605661,-0.37147960445672457,-0.20670021150986739,-0.30679167790147965,-0.47669550919410775,0.54474628057851038,-0.49207498295104812,-0.30957132246477692,0.20973364945153428,-0.22403405595298997,"","","","",""]
["2020/2016-100%",{"$f":"IF(B71=\"\",\"\",IF(B67=\"\",\"\",B71/B67-100%))","v":-0.91353152196262044},{"$f":"IF(C71=\"\",\"\",IF(C67=\"\",\"\",C71/C67-100%))","v":0.16149673694940936},0.17595173495787986,-0.29575396671164067,-0.59872409107473068,-0.33886995036573175,8.2695624699773429E-2,-0.28531295631776454,-0.63883327049245864,1.5610932246066525,-0.30264667901006159,-0.23295147837653996,0.34773144272174616,-0.2396569633738328,"","","","",""]
["2020/2017-100%",{"$f":"IF(B71=\"\",\"\",IF(B68=\"\",\"\",B71/B68-100%))","v":-0.77618068268443818},{"$f":"IF(C71=\"\",\"\",IF(C68=\"\",\"\",C71/C68-100%))","v":9.1317146515669911E-2},-0.32475958443229003,-0.19930802740614628,-0.5144078893144155,-0.4135106330305417,0.12309246345009761,-0.1482881624174438,-0.70651237340110673,0.29964446234483932,-4.9451096613518319E-2,-9.1428013197516256E-2,-0.17031440715943302,-0.15894837855274924,"","","","",""]
["2020/2018-100%",{"$f":"IF(B71=\"\",\"\",IF(B69=\"\",\"\",B71/B69-100%))","v":0.30325724957752276},{"$f":"IF(C71=\"\",\"\",IF(C69=\"\",\"\",C71/C69-100%))","v":0.18364750891949888},-0.12248154449963145,-0.12827628459916507,-0.18651297352561025,-0.30105463747629568,-3.2083518435912062E-2,3.6977030055412419E-2,-0.58192783301455431,0.25301645999931144,-1.6844041046432334E-2,-0.12507719075369916,4.1412321108662553E-3,-7.5325970187898439E-2,"","","","",""]
["2020/2019-100%",{"$f":"IF(B71=\"\",\"\",IF(B70=\"\",\"\",B71/B70-100%))","v":-0.23373365625033837},{"$f":"IF(C71=\"\",\"\",IF(C70=\"\",\"\",C71/C70-100%))","v":0.1504726483909602},-0.17024361691660483,-0.11773757767086201,-7.2395137935600373E-2,2.7151191677966535E-2,-1.1727120538608915E-2,-0.22369743977993739,-8.0617435822537109E-2,-0.1752947880011908,3.9412376256731108E-2,0.25769573895615561,0.84466981915867434,6.0455334627569357E-2,"","","","",""]
[]
[]
["Row Labels","ME-OTC","NH","VT","CT","MA","RI","DE","DC","MD","NJ","NY","PA","VA-OTC","OTC"]
[2015,0.76536310612992631,0.83303921568627903,0.35434305317325587,0.44333869485294092,0.74738567351598229,0.35593357167569084,0.44029375951292615,1.3331497771522418,0.92703770928462848,0.3178061625715749,1.01400343727102,1.5360761620213474,0.78293416776987701,0.97852284984681326]
[2016,0.66637411549873993,0.77168929283633181,0.11183055110907854,0.39615348517797777,0.79249491499696101,0.25448105057020015,0.35309404531480054,1.0395418719211795,0.66397880374966378,0.27530950935322307,0.45466069171743467,0.93694654106608666,0.34497668997669118,0.62727315635198699]
[2017,1.3302711360256247,0.83831204939408133,0.23528226737473881,0.27338503510378087,0.68280137012662001,0.24192899816175592,0.25871484568253394,1.0083001827944678,0.96205730321809169,0.16605539247662623,0.33115715182117594,0.84335572396424863,0.30965361266515729,0.64016185260776026]
[2018,0.51392579464897759,0.89222158107328564,0.40975122955507343,0.24045492289442053,0.56424256981058185,0.27271855138505824,0.24940905631658411,0.84608319972514923,1.1839105240269561,0.32723052565775024,0.24294756300210205,0.71199065199672451,0.50299765807962826,0.57873095364402072]
[2019,8.8260794671566126E-2,0.82262388302193401,0.31529888492930014,0.22086163669839762,0.33681144443132005,0.22883981944615306,0.28939421613393601,0.69492289211760883,0.83110792164793745,0.33940762484598141,0.23489003701697828,0.73937352465039174,0.41560877772533916,0.52639372497887271]
[2020,0.15011297500855758,0.84634494464375154,0.33344798083504462,0.21822342384702739,0.29537548973515043,0.15571858540256367,0.28343328779599442,0.92827090069284068,0.37793091074441404,0.51567922015497103,0.22217701546303942,0.51434917145092685,0.22623556031916375,0.4589939727305542]
[2021,0.11502652050919175,0.97369670991659751,0.2766805905241479,0.19253032653223656,0.27399174041297869,0.15994653056265049,0.28010943146535655,0.72061907678563575,0.34746308980212326,0.42528334058128597,0.23093353959206628,0.64689476126945977,0.41732991014121318,0.48674260694401733]

{"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,"2022-10-31"]
[10,"Delaware",null,null,"2020-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,"2022-12-31"]
[34,"New Jersey",null,null,"2022-12-31"]
[36,"New York",null,null,"2022-12-31"]
[42,"Pennsylvania",null,null,"2022-11-30"]
[44,"Rhode Island",null,null,"2022-12-31"]
[50,"Vermont",null,null,"2022-12-31"]
[51,"Virginia OTC",null,null,"2022-12-31"]