{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Benefits_Interface","Canopy Cover Benefit","Green Roof Benefit","EnergySavings by State","AvoidedEmissions_UCTrees","ElectricityPriceByState","BenefitPerTon_Regression","SCC_Regression","GDP Implicit Price Deflator","AVERT_2017"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":93,"comments":3,"pivot_tables":0},"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":"whole","date_system":"1900"}

{"sheet":"Benefits_Interface","index":0,"n_rows":158,"n_cols":16,"rows_kept":158,"cut":false,"hidden":false,"merged":[[1,2,2,11],[3,1,3,11],[4,2,4,11],[11,4,11,7],[12,4,12,7],[64,4,64,5],[64,7,64,8],[74,4,74,5],[74,7,74,8],[79,7,79,8],[80,4,80,5],[80,7,80,8],[100,4,100,5],[100,7,100,8],[65,4,66,5],[65,7,65,8],[66,7,66,8],[72,4,72,5],[72,7,72,8],[73,4,73,5],[73,7,73,8],[108,4,108,5],[108,7,108,8],[109,4,109,5],[109,7,109,8],[110,4,110,5],[110,7,110,8],[101,4,101,5],[101,7,101,8],[102,4,102,5],[102,7,102,8],[107,4,107,5],[107,7,107,8],[114,4,114,5],[114,7,114,8],[115,4,115,5],[115,7,115,8],[116,4,116,5],[116,7,116,8],[111,4,111,5],[111,7,111,8],[112,4,112,5],[112,7,112,8],[113,4,113,5],[113,7,113,8],[120,4,120,5],[120,7,120,8],[121,4,121,5],[121,7,121,8],[122,4,122,5],[122,7,122,8],[117,4,117,5],[117,7,117,8],[118,4,118,5],[118,7,118,8],[119,4,119,5],[119,7,119,8],[126,4,126,5],[126,7,126,8],[127,4,127,5],[127,7,127,8],[128,4,128,5],[128,7,128,8],[123,4,123,5],[123,7,123,8],[124,4,124,5],[124,7,124,8],[125,4,125,5],[125,7,125,8],[132,4,132,5],[132,7,132,8],[133,4,133,5],[133,7,133,8],[134,4,134,5],[134,7,134,8],[129,4,129,5],[129,7,129,8],[130,4,130,5],[130,7,130,8],[131,4,131,5],[131,7,131,8],[138,4,138,5],[138,7,138,8],[139,4,139,5],[139,7,139,8],[140,4,140,5],[140,7,140,8],[135,4,135,5],[135,7,135,8],[136,4,136,5],[136,7,136,8],[137,4,137,5],[137,7,137,8],[146,4,146,5],[146,7,146,8],[147,4,147,5],[147,7,147,8],[148,4,148,5],[148,7,148,8],[141,4,141,5],[141,7,141,8],[142,4,142,5],[142,7,142,8],[143,4,143,5],[143,7,143,8],[154,7,154,8],[155,4,156,5],[155,7,155,8],[149,4,149,5],[151,4,151,5],[151,7,151,8],[152,4,152,5],[152,7,152,8],[153,4,153,5],[153,7,153,8]]}
[]
[null,null,"Benefit Calculations"]
[]
[null,"ScenCompare will calculate benefits related to outcomes targeted by a management practice (direct benefits) and ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DROP DOWN LISTS - DO NOT REMOVE!"]
[null,null,"benefits that arise from other outcomes of implementing the management practice selected to meet the target (co-benefits).",null,null,null,null,null,null,null,null,null,null,null,null,"Daily"]
[null,"1. Study Characteristics",null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annually"]
[null,"1A. ","Specify the year of the analysis.",null,"Specify the dollar year in which you'd like to evaluate benefits."]
[null,null,2017,null,"$2017"]
[]
[null,null,"If calculating management option co-benefits (see Section 3), choose if you would like to calculate co-benefits using the global or domestic social cost of carbon."]
[null,null,"Global social cost of carbon",{"$f":"'Canopy Cover Benefit'!C7","v":44.855918167279725},"$/metric ton; delete either the global or domestic cost as appropriate"]
[null,null,"Domestic social cost of carbon",null,"$/metric ton; delete either the global or domestic cost as appropriate",null,null,null,null,null,null,null,null,null,null,"$2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$2017"]
[null,"1B.","ScenCompare uses several databases to calculate management option direct benefits and co-benefits. The databases are based on USGS' fourth level of hydrologic unit classification (HUC12). ",null,null,null,null,null,null,null,null,null,null,null,null,"$2018"]
[null,null,"Enter characteristics of your study area. Setup the HRU table before the HUC12 table.",null,null,null,null,"Enter the number of HUC12s that make up your \nstudy area (up to 20).",null,null,null,null,null,null,null,"$2019"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,"Select each data header for more information.",null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,null,"HRU Name","Agricultural land","Residential land","Green space percentage",null,"HUC12 ID","Proportion of HUC12 (percentage)",null,null,null,null,null,null,2019]
[null,null,"Turfgrass A/B Montgomery County",null,null,null,null,null,null,null,null,null,null,null,null,2020]
[null,null,"Turfgrass C/D Montgomery County",null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,"Turfgrass A/B  City of Rockville",null,null,null,null,null,null,null,null,null,null,null,null,2022]
[null,null,"Turfgrass C/D  City of Rockville",null,null,null,null,null,null,null,null,null,null,null,null,2023]
[null,null,"Turfgrass A/B MD State Highway Administration",null,null,null,null,null,null,null,null,null,null,null,null,2024]
[null,null,"Turfgrass C/D MD State Highway Administration",null,null,null,null,null,null,null,null,null,null,null,null,2025]
[null,null,"Turfgrass A/B Other Regulated",null,null,null,null,null,null,null,null,null,null,null,null,2026]
[null,null,"Turfgrass C/D Other Regulated",null,null,null,null,null,null,null,null,null,null,null,null,2027]
[null,null,"Natural",null,null,null,null,null,null,null,null,null,null,null,null,2028]
[null,null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,2029]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2030]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northeast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Great Lakes/Mid-Atlantic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southeast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower Midwest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper Midwest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rocky Mountains"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southwest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northwest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"California"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wind"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility photovoltaic (PV)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portfolio energy efficiency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uniform energy efficiency"]
[null,"2. ","Calculation of Direct Benefits"]
[null,null,"Once input values have been entered below, use this button to calculate the value of direct benefits."]
[]
[]
[]
[null,null,"If any of the direct benefit calculations are inappropriate for your study area, leave the model run choices blank under step 2A."]
[null,"2A.","Choose the appropriate baseline and ",null,"Fill out the blue input cells to compute the direct benefit value of…"]
[null,null,"managed model runs below."]
[]
[null,null,null,null,"Avoided water treatment costs"]
[null,null,"Baseline Model Run",null,"Estimated ratio of turbidity to TSS",null,null,"1.5 by default; see User Guide",null,null,"Total avoided water treatment costs"]
[null,null,"TSS_BaselineWTP",null,"Cost of alum ",null,null,"$/ton"]
[null,null,"Managed Model Run",null,null,null,null,"$ year"]
[null,null,"TSS_ScenWTP"]
[]
[null,null,null,null,"Use and non-use of water quality improvements"]
[null,null,"Baseline Model Run - TN",null,"Indicate below if your case study falls into any of the three defined US regions."]
[null,null,"TN_Baseline",null," If your case study does not fall into any of the three, leave all values as zero.",null,null,null,null,null,"Annualized willingness-to-pay for "]
[null,null,"Baseline Model Run - TP",null,"Northeast",null,null,"1 if located in the Northeast (ME, NH, VT, MA, RI, CT, and NY); 0 otherwise",null,null,"water quality changes"]
[null,null,"TP_Baseline",null,"Central",null,null,"1 if located in the Central US (OH, MI, IN, IL, WI, MN, IA, MO, ND, SD, NE, KS, MT, WY, UT, and CO); 0 otherwise"]
[null,null,"Baseline Model Run - TSS",null,"South",null,null,"1 if located in the South (NC, SC, GA, FL, KY, TN, MS, AL, AR, LA, OK, TX, and NM); 0 otherwise"]
[null,null,"TSS_BaselineWTP"]
[null,null,"Model Run Estimating TN Changes"]
[null,null,"TN_Scenario"]
[null,null,"Model Run Estimating TP Changes"]
[null,null,"TP_Scenario",null,"Specify the dollar year of the income data.",null,null,"Specify the data frequency of BOD, DO, and FC data"]
[null,null,"Model Run Estimating TSS Changes",null,null,null,null,"Monthly"]
[null,null,"TSS_ScenWTP"]
[null,null,null,null,null,null,null,null,null,null,"Total Direct Benefits"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Alum_Savings+WTP_Value","v":0}]
[]
[null,"3. Calculation of Co-benefits"]
[null,null,"Select a model below using the drop-down list."]
[null,null,"Model run to calculate co-benefits",null,"TN_Scenario"]
[null,null,"Once a model is selected, use this button to identify which BMPs were chosen by your model."]
[]
[]
[]
[null,null,"If any of the co-benefit calculations are inappropriate for your study area, unbold the associated BMP under Step 3A."]
[null,null,"Once input values have been entered below, use this button to calculate the value of co-benefits."]
[]
[]
[]
[null,"3A.","BMPs chosen by your model are ",null,"Fill out the blue input cells to compute the co-benefit value of…"]
[null,null,"in bold below."]
[null,null,null,null,"Change in housing property value due to improved aesthetic quality of the landscape from increases in green space"]
[null,null,"Land Conservation",null,"Acres of increased green space",null,null,"WMOST results",null,null,"Change in property values"]
[null,null,"Bioretention Basin",null,"Wetland",null,null,"1 if wetland area is expected to increase; 0 otherwise"]
[null,null,"Grass Swale",null,"Recreational",null,null,"1 if recreational amenities are included; 0 otherwise"]
[null,null,"Gravel Wetland"]
[null,null,"Direct Reduction Tree Canopy"]
[null,null,"Riparian Buffer"]
[]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - bioretention basin"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - grass swale"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - gravel wetland"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - riparian buffer"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - direct reduction tree canopy"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass A/B Montgomery County"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass C/D Montgomery County"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass A/B  City of Rockville"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass C/D  City of Rockville"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass A/B MD State Highway Administration"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass C/D MD State Highway Administration"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass A/B Other Regulated"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Turfgrass C/D Other Regulated"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Natural"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - Water"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[null,null,null,null,"Tree cover",null,null,"% of the increase in open space - HRU1"]
[]
[null,null,null,null,"Air pollution removal and energy savings benefits related to canopy cover",null,null,null,null,null,"Canopy cover benefits"]
[null,null,"Land Conservation",null,"Acres of increased canopy cover",null,59.16,"WMOST results",null,"Lower Bound",{"$f":"'Canopy Cover Benefit'!C9+'Canopy Cover Benefit'!C23+'Canopy Cover Benefit'!C31+'Canopy Cover Benefit'!C47+'Canopy Cover Benefit'!C56","v":27170.488783869896}]
[null,null,"Direct Reduction Tree Canopy",null,"Population density",null,{"$f":"1039198/491.25","v":2115.4157760814251},"people/square mile",null,"Upper Bound",{"$f":"'Canopy Cover Benefit'!C9+'Canopy Cover Benefit'!C23+'Canopy Cover Benefit'!C31+'Canopy Cover Benefit'!D47+'Canopy Cover Benefit'!C56","v":38264.122344986317}]
[null,null,"Riparian Buffer"]
[]
[null,null,null,null,"Air pollution removal and energy savings benefits related to green roofs",null,null,null,null,null,"Green roof benefits"]
[null,null,"Green Roof",null,"Acres of green roof",null,10,"WMOST results",null,"Lower Bound",{"$f":"'Green Roof Benefit'!B15+'Green Roof Benefit'!B20+'Green Roof Benefit'!B27","v":21905.444236123694}]
[null,null,null,null,"Direct energy savings",null,100000,"kWh/year",null,"Upper Bound",{"$f":"'Green Roof Benefit'!C15+'Green Roof Benefit'!B20+'Green Roof Benefit'!B27","v":27721.477339678422}]
[null,null,null,null,"Location",null,"Great Lakes/Mid-Atlantic","AVERT region"]
[null,null,null,null,"Source of energy savings",null,"Uniform energy efficiency","AVERT emission factor category"]
[null,null,null,null,"Price of electricity for residential customers",null,{"$f":"'Green Roof Benefit'!B26","v":139.6},"$/MWh"]
[null,null,null,null,null,null,"2017","dollar year"]
[null,null,null,null,null,null,null,null,null,null,"Total Co-Benefits"]

{"sheet":"Canopy Cover Benefit","index":1,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Benefits from Canopy Cover -- ILLUSTRATIVE SAMPLE CALCULATIONS ** NOT TO BE DISTRIBUTED BROADLY"]
[]
[null,"Carbon Sequestration Benefits from Canopy Cover"]
[null,"Increase in acres canopy cover (acres)",{"$f":"Benefits_Interface!$G$147","v":59.16}]
[null,"Rate of carbon sequestration (metric ton/acre)",0.77,"https://www.epa.gov/energy/greenhouse-gases-equivalencies-calculator-calculations-and-references#_ftn1"]
[null,"Total carbon sequestration (metric tons)",{"$f":"C4*C5","v":45.553199999999997}]
[null,"Social cost of carbon ($/metric ton) (global; 2017$)",{"$f":"SCC_Regression!B5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BK8)","v":44.855918167279725}]
[null,"Social cost of carbon ($/metric ton) (domestic; 2017$)",{"$f":"SCC_Regression!C5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BT8)","v":6.3905996264556055}]
[null,"Annual benefits, global (2017$)",{"$f":"C7*C6","v":2043.3306114577267}]
[null,"Annual benefits, domestic (2017$)",{"$f":"C6*C8","v":291.11226290385747}]
[]
[null,"Avoided Health Damages from Canopy Cover (Tree Removal)",null,null,null,null,"Pollutant Removal Rates (Nowak et al. 2014)"]
[null,"Population Density (people/km2)",{"$f":"Benefits_Interface!$G$148/2.59","v":816.76284790788623},null,null,null,"Pollutant","g/m^2","metric tons/acre"]
[null,"Increase in tree cover (acres)",{"$f":"Benefits_Interface!$G$147","v":59.16},null,null,null,"NO2",0.55000000000000004,{"$f":"(H14/10^6)/$C$61","v":2.2257799354308376E-3}]
[null,"NO2 removed by tree cover (metric tons)",{"$f":"$C$14*I14","v":0.13167714098008834},null,null,null,"SO2",0.35,{"$f":"(H15/10^6)/$C$61","v":1.4164054134559875E-3}]
[null,"SO2 removed by tree cover (metric tons)",{"$f":"$C$14*I15","v":8.3794544260056211E-2},null,null,null,"O3",5.49,{"$f":"(H16/10^6)/$C$61","v":2.2217330628209634E-2}]
[null,"Ozone removed by tree cover (metric tons)",{"$f":"$C$14*I16","v":1.3143772799648819},null,null,null,"PM2.5",0.27,{"$f":"(H17/10^6)/$C$61","v":1.0926556046660476E-3}]
[null,"PM2.5 removed by tree cover (metric tons)",{"$f":"$C$14*I17","v":6.4641505572043373E-2}]
[null,"Avoided health damages from NO2 (2017$)",{"$f":"(0.7298+(0.6264*C13))*C15*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BN$8)","v":75.773731374370428},null,null,null,"Regressions estimating dollars per tonne (Nowak et al. 2014)"]
[null,"Avoided health damages from SO2 (2017$)",{"$f":"(0.1442+(0.1493*C13))*C16*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BN$8)","v":11.490165651300334},null,null,null,"NO2","0.7298 + 0.6264 * pop density"]
[null,"Avoided health damages from Ozone (2017$)",{"$f":"(9.4667+(3.5089*C13))*C17*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BN$8)","v":4244.8338983624508},null,null,null,"SO2","0.1442 + 0.1493 * pop density"]
[null,"Avoided health damages from PM2.5 (2017$)",{"$f":"(428.0011+(121.7864*C13))*C18*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BN$8)","v":7252.911934757798},null,null,null,"O3","9.4667 + 3.5089 * pop density"]
[null,"Total Avoided health damages",{"$f":"SUM(C19:C22)","v":11585.009730145919},null,null,null,"PM2.5","428.0011 + 121.7864 * pop density"]
[]
[null,"Electricity Savings from Urban/Community Trees"]
[null,"Location (state)","Maryland"]
[null,"Energy Savings $/ha tree cover (2009$)",{"$f":"'EnergySavings by State'!B20","v":845.33370571104786}]
[null,"Energy Savings $/ha tree cover (2017$)",{"$f":"C27*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BM8)","v":960.50779824108645}]
[null,"Increase in urban/community trees (acres)",{"$f":"Benefits_Interface!$G$152","v":10}]
[null,"Increase in urban/community trees (hectares)",{"$f":"C29*(1/C60)","v":4.0468726098742502}]
[null,"Electricity savings from canopy cover increase (2017$)",{"$f":"C30*C28","v":3887.0527002724752}]
[]
[null,"Avoided Health Damages from Urban/Community Trees (Avoided Power Plant Emissions)"]
[null,"Location (state)","Maryland"]
[null,"Increase in urban/community trees (acres)",{"$f":"Benefits_Interface!$G$152","v":10}]
[null,"Increase in urban/community trees (hectares)",{"$f":"C35*(1/C60)","v":4.0468726098742502}]
[null,"NO2 avoided from U/C trees (U.S tons)",{"$f":"C36*AvoidedEmissions_UCTrees!I20*C62","v":1.8524686957830924E-2}]
[null,"SO2 avoided from U/C trees (U.S. tons)",{"$f":"C36*AvoidedEmissions_UCTrees!J20*C62","v":0.19199310788916818}]
[null,"PM2.5 avoided from U/C trees (U.S. tons)",{"$f":"C36*AvoidedEmissions_UCTrees!K20*C62","v":3.4500306671167913E-3}]
[null,null,"Low","High"]
[null,"Avoided health damages from NO2 (2015$)",{"$f":"C37*BenefitPerTon_Regression!D5","v":111.52028814410659},{"$f":"C37*BenefitPerTon_Regression!G5","v":257.12934560655196}]
[null,"Avoided health damages from SO2 (2015$)",{"$f":"C38*BenefitPerTon_Regression!C5","v":7765.5361335397265},{"$f":"C38*BenefitPerTon_Regression!F5","v":17732.708809013995}]
[null,"Avoided health damages from PM2.5 (2015$)",{"$f":"C39*BenefitPerTon_Regression!B5","v":492.89490050072573},{"$f":"C39*BenefitPerTon_Regression!E5","v":1149.1016364177949}]
[null,"Avoided health damages from NO2 (2017$)",{"$f":"C41*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BS$8)","v":114.88221153537124},{"$f":"D41*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BS$8)","v":264.88084245041057}]
[null,"Avoided health damages from SO2 (2017$)",{"$f":"C42*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BS$8)","v":7999.6382687433452},{"$f":"D42*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BS$8)","v":18267.284261854227}]
[null,"Avoided health damages from PM2.5 (2017$)",{"$f":"C43*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BS$8)","v":507.75385507307391},{"$f":"D43*('GDP Implicit Price Deflator'!$BU$8/'GDP Implicit Price Deflator'!$BS$8)","v":1183.7427921635679}]
[null,"Total Avoided health damages",{"$f":"SUM(C44:C46)","v":8622.2743353517908},{"$f":"SUM(D44:D46)","v":19715.907896468205}]
[]
[null,"Avoided CO2 emissions from Urban/Community Trees (Avoided Power Plant Emissions)"]
[null,"Location (state)","Maryland"]
[null,"Increase in urban/community trees (acres)",{"$f":"Benefits_Interface!$G$152","v":10}]
[null,"Increase in urban/community trees (hectares)",{"$f":"C51*(1/C60)","v":4.0468726098742502}]
[null,"CO2 avoided from U/C trees (metric tons)",{"$f":"C52*AvoidedEmissions_UCTrees!L20","v":23.025309676870734}]
[null,"Social cost of carbon ($/metric ton) (global; 2017$)",{"$f":"SCC_Regression!B5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BK8)","v":44.855918167279725}]
[null,"Social cost of carbon ($/metric ton) (domestic; 2017$)",{"$f":"SCC_Regression!C5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BT8)","v":6.3905996264556055}]
[null,"Annual benefits, global (2017$)",{"$f":"C54*C53","v":1032.8214066419876}]
[null,"Annual benefits, domestic (2017$)",{"$f":"C53*C55","v":147.14553542003475}]
[]
[]
[null,"1 hectare = 2.47104393046628 acres ",2.4710439304662799]
[null,"1 m^2 =  0.000247104393046628 acres",2.4710439304662801E-4]
[null,"1 metric tons (tonnes) = 1.1023 U.S. tons (short tons)",1.1023000000000001]

{"sheet":"Green Roof Benefit","index":2,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,12,3,15],[4,12,4,15]]}
["Green roof calculator outputs",null,null,null,"Regional Emission rates (AVERT) - Uniform EE (2017)"]
["Electrical savings (kWh)",{"$f":"Benefits_Interface!$G$153","v":100000},null,null,"Region","SO2 (lbs/MWh)","NOx (lbs/MWh)","CO2 (tons/MWh)","PM2.5 (lbs/MWh)"]
["Electrical savings (MWh)",{"$f":"B2/1000","v":100},null,null,"Northeast",{"$f":"AVERT_2017!E29","v":0.28309122537265902},{"$f":"AVERT_2017!K16","v":0.43103012510669703},{"$f":"AVERT_2017!E16*0.0005","v":0.57013693872728743},{"$f":"AVERT_2017!K29","v":4.5166520502734703E-2}]
[null,null,null,null,"Great Lakes/Mid-Atlantic",{"$f":"AVERT_2017!E30","v":1.2549787840850701},{"$f":"AVERT_2017!K17","v":0.98590615073606291},{"$f":"AVERT_2017!E17*0.0005","v":0.85447029800999219},{"$f":"AVERT_2017!K30","v":0.21038508533316702}]
["Avoided Pollutants",null,null,null,"Southeast",{"$f":"AVERT_2017!E31","v":0.788492001199248},{"$f":"AVERT_2017!K18","v":0.93052642990953249},{"$f":"AVERT_2017!E18*0.0005","v":0.76703788068093992},{"$f":"AVERT_2017!K31","v":0.10451385980316499}]
["SO2 (lbs): ",{"$f":"$B$3*INDEX(F$3:F$12,MATCH(Benefits_Interface!$G$154,'Green Roof Benefit'!$E$3:$E$12,0))","v":125.49787840850701},null,null,"Lower Midwest",{"$f":"AVERT_2017!E32","v":1.8776048387896001},{"$f":"AVERT_2017!K19","v":1.202439471233435},{"$f":"AVERT_2017!E19*0.0005","v":0.92757905597601154},{"$f":"AVERT_2017!K32","v":9.891248930513985E-2}]
["NO2 (lbs):",{"$f":"$B$3*INDEX(G$3:G$12,MATCH(Benefits_Interface!$G$154,'Green Roof Benefit'!$E$3:$E$12,0))","v":98.590615073606287},null,null,"Upper Midwest",{"$f":"AVERT_2017!E33","v":2.02860038682077},{"$f":"AVERT_2017!K20","v":1.3807234878788051},{"$f":"AVERT_2017!E20*0.0005","v":1.0045022619890651},{"$f":"AVERT_2017!K33","v":9.855173382644114E-2}]
["CO2 (short tons):",{"$f":"$B$3*INDEX(H$3:H$12,MATCH(Benefits_Interface!$G$154,'Green Roof Benefit'!$E$3:$E$12,0))","v":85.447029800999218},null,null,"Rocky Mountains",{"$f":"AVERT_2017!E34","v":0.60044089608265905},{"$f":"AVERT_2017!K21","v":1.42313617262887},{"$f":"AVERT_2017!E21*0.0005","v":0.86893085056215547},{"$f":"AVERT_2017!K34","v":3.6387188497506745E-2}]
["PM2.5 (lbs):",{"$f":"$B$3*INDEX(I$3:I$12,MATCH(Benefits_Interface!$G$154,'Green Roof Benefit'!$E$3:$E$12,0))","v":21.038508533316701},null,null,"Texas",{"$f":"AVERT_2017!E35","v":1.3172687069506199},{"$f":"AVERT_2017!K22","v":0.65331796964456301},{"$f":"AVERT_2017!E22*0.0005","v":0.69755844427000091},{"$f":"AVERT_2017!K35","v":7.633690172792984E-2}]
[null,null,null,null,"Southwest",{"$f":"AVERT_2017!E36","v":0.2431762626984065},{"$f":"AVERT_2017!K23","v":0.98662668042475943},{"$f":"AVERT_2017!E23*0.0005","v":0.68242104085324151},{"$f":"AVERT_2017!K36","v":7.5400756039452455E-2}]
["Avoided Health Damages","Low","High",null,"Northwest",{"$f":"AVERT_2017!E37","v":0.92228926104787101},{"$f":"AVERT_2017!K24","v":1.2921949161865052},{"$f":"AVERT_2017!E24*0.0005","v":0.84841216433678301},{"$f":"AVERT_2017!K37","v":8.775666425259375E-2}]
["SO2 (2017$)",{"$f":"B6*$B$30*BenefitPerTon_Regression!C5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BS8)","v":2614.514765140254},{"$f":"B6*$B$30*BenefitPerTon_Regression!F5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BS8)","v":5970.2805073378204},null,"California",{"$f":"AVERT_2017!E38","v":7.7862708857230345E-2},{"$f":"AVERT_2017!K25","v":0.34487416228586054},{"$f":"AVERT_2017!E25*0.0005","v":0.563690917079954},{"$f":"AVERT_2017!K38","v":4.8109721685088105E-2}]
["NO2 (2017$)",{"$f":"B7*$B$30*BenefitPerTon_Regression!D5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BS8)","v":305.70848301165057},{"$f":"B7*$B$30*BenefitPerTon_Regression!G5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BS8)","v":704.86387267563271}]
["PM2.5 (2017$)",{"$f":"B9*$B$30*BenefitPerTon_Regression!B5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BS8)","v":1548.1578054647614},{"$f":"B9*$B$30*BenefitPerTon_Regression!E5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BS8)","v":3609.2697771579401}]
["Total",{"$f":"SUM(B13+B14+B12)","v":4468.3810536166657},{"$f":"SUM(C12:C14)","v":10284.414157171394}]
[]
["Avoided Carbon Benefits"]
["Social cost of carbon ($/metric ton) (global; 2017$)",{"$f":"SCC_Regression!B5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BK8)","v":44.855918167279725}]
["Social cost of carbon ($/metric ton) (domestic; 2017$)",{"$f":"SCC_Regression!C5*('GDP Implicit Price Deflator'!BU8/'GDP Implicit Price Deflator'!BT8)","v":6.3905996264556055}]
["Annual benefits, global (2017$)",{"$f":"B8*B32*B18","v":3477.0631825070268}]
["Annual benefits, domestic (2017$)",{"$f":"B8*B32*B19","v":495.37540603729667}]
[]
["Electricity Savings"]
["Location (state)","Maryland"]
["Residential electricity rate (cents per kilowatthour; 2017$)",{"$f":"ElectricityPriceByState!R38","v":13.96}]
["Residential electricity rate (dollars per megawatt hour; 2017$)",{"$f":"B25*(1/100)*1000","v":139.6}]
["Total value of energy savings from green roofs (2017$/year)",{"$f":"B3*B26","v":13960}]
[]
[]
["1 lbs = 0.000500000000 tons",5.0000000000000001E-4]
["1 ton = 907184.74 g",907184.74]
["1 US ton = 0.907185 metric tons",0.90718500000000002]

{"sheet":"EnergySavings by State","index":3,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["State","Energy Savings\n$/ha tree cover (2009$)"]
["Alabama",204.79328030026295]
["Arkansas",263.21213460639615]
["Arizona",692.10025693720843]
["California",407.99730384889978]
["Colorado",148.4335766526533]
["Connecticut",402.20514793396421]
["District of Columbia",1811.4282245615602]
["Delaware",1183.1739727516524]
["Florida",627.75152643371541]
["Georgia",169.95786661218278]
["Iowa",891.55440684689552]
["Idaho",1293.9352953878326]
["Illinois",880.30032354591117]
["Indiana",765.91680339969173]
["Kansas",1392.6143498204858]
["Kentucky",863.56141109965051]
["Louisiana",618.27307304805709]
["Massachusetts",433.31361274188896]
["Maryland",845.33370571104786]
["Maine",248.4854138848728]
["Michigan",584.33901470867102]
["Minnesota",314.52791749876963]
["Missouri",841.97678802189989]
["Mississippi",299.98767986783639]
["Montana",123.01385978585242]
["North Carolina",240.41320364190423]
["North Dakota",563.03707013806263]
["Nebraska",1270.4324349896597]
["New Hampshire",155.60627702142202]
["New Jersey",626.52690798920037]
["New Mexico",556.74781499901269]
["Nevada",855.85757232850438]
["New York",667.92903294038103]
["Ohio",728.31894574242801]
["Oklahoma",215.24156754655229]
["Oregon",242.27440100078223]
["Pennsylvania",582.65567093619939]
["Rhode Island",698.53151086830746]
["South Carolina",249.53149597976096]
["South Dakota",591.69483066762712]
["Tennessee",270.42416071411901]
["Texas",508.22022100118016]
["Utah",549.94516823918514]
["Virginia",366.07101473976229]
["Vermont",409.20343188180937]
["Washington",258.45658657575967]
["Wisconsin",606.12546652815161]
["West Virginia",258.99920962470497]
["Wyoming",218.02954902863354]
["Conterminous US",455.31017276957874]
[]
["Source: Nowak et al. (2017); personal communication"]

{"sheet":"AvoidedEmissions_UCTrees","index":4,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,7,0,11]]}
["Avoided Emissions from Power Plants (Metric Tons)\nNowak et al. (2017)",null,null,null,null,"Nowak et al. (2012)",null,"Avoided Emissions from Power Plants \n(Metric Tons/ha)"]
["State","NOx","SO2","PM2.5","CO2","UC tree cover (ha)",null,"State","NOx","SO2","PM2.5","CO2"]
["AL",593,3164,225,833000,701000,null,"AL",{"$f":"B3/F3","v":8.4593437945791725E-4},{"$f":"C3/F3","v":4.5135520684736093E-3},{"$f":"D3/F3","v":3.2097004279600568E-4},{"$f":"E3/F3","v":1.18830242510699}]
["AR",614,1244,16,549000,259000,null,"AR",{"$f":"B4/F4","v":2.3706563706563707E-3},{"$f":"C4/F4","v":4.8030888030888034E-3},{"$f":"D4/F4","v":6.1776061776061777E-5},{"$f":"E4/F4","v":2.1196911196911197}]
["AZ",1356,742,70,1237000,277000,null,"AZ",4.8953068592057763E-3,2.6787003610108302E-3,2.527075812274368E-4,4.465703971119134]
["CA",262,184,390,728000,870000,null,"CA",3.0114942528735634E-4,2.1149425287356321E-4,4.4827586206896552E-4,0.83678160919540234]
["CO",249,187,3,171000,130000,null,"CO",1.9153846153846155E-3,1.4384615384615384E-3,2.3076923076923076E-5,1.3153846153846154]
["CT",201,207,56,318000,337000,null,"CT",5.9643916913946593E-4,6.1424332344213646E-4,1.6617210682492583E-4,0.94362017804154308]
["DE",333,1167,39,292000,32000,null,"DE",1.0406250000000001E-2,3.6468750000000001E-2,1.21875E-3,9.125]
["FL",2709,5810,769,3157000,813000,null,"FL",3.3321033210332103E-3,7.1463714637146373E-3,9.4587945879458799E-4,3.8831488314883149]
["GA",780,3520,322,1052000,781000,null,"GA",9.9871959026888598E-4,4.507042253521127E-3,4.1229193341869397E-4,1.3469910371318823]
["IA",1229,2838,5,1231000,100000,null,"IA",1.2290000000000001E-2,2.8379999999999999E-2,5.0000000000000002E-5,12.31]
["ID",101,154,11,109000,18000,null,"ID",5.611111111111111E-3,8.5555555555555558E-3,6.111111111111111E-4,6.0555555555555554]
["IL",1695,5534,14,2387000,317000,null,"IL",5.3470031545741325E-3,1.7457413249211358E-2,4.4164037854889592E-5,7.5299684542586753]
["IN",1288,4723,38,1339000,178000,null,"IN",7.2359550561797749E-3,2.6533707865168538E-2,2.1348314606741572E-4,7.5224719101123592]
["KS",1512,1584,10,1200000,95000,null,"KS",1.591578947368421E-2,1.6673684210526316E-2,1.0526315789473685E-4,12.631578947368421]
["KY",939,2997,72,1101000,117000,null,"KY",8.0256410256410258E-3,2.5615384615384616E-2,6.1538461538461541E-4,9.4102564102564106]
["LA",1208,1894,227,1128000,265000,null,"LA",4.5584905660377359E-3,7.1471698113207546E-3,8.5660377358490571E-4,4.2566037735849056]
["MA",733,1881,110,1017000,534000,null,"MA",1.3726591760299626E-3,3.5224719101123597E-3,2.0599250936329587E-4,1.904494382022472]
["MD",843,8737,157,1155000,203000,null,"MD",4.1527093596059111E-3,4.3039408866995074E-2,{"$f":"D20/F20","v":7.7339901477832507E-4},{"$f":"E20/F20","v":5.6896551724137927}]
["ME",108,119,85,94000,176000,null,"ME",6.1363636363636362E-4,6.7613636363636368E-4,4.8295454545454547E-4,0.53409090909090906]
["MI",1969,6456,49,1754000,376000,null,"MI",5.2367021276595741E-3,1.7170212765957447E-2,1.3031914893617022E-4,4.6648936170212769]
["MN",1300,1632,33,1077000,361000,null,"MN",3.6011080332409972E-3,4.5207756232686983E-3,9.1412742382271473E-5,2.9833795013850417]
["MO",1382,6137,28,1939000,263000,null,"MO",5.2547528517110269E-3,2.3334600760456275E-2,1.064638783269962E-4,7.3726235741444865]
["MS",556,858,127,540000,268000,null,"MS",2.074626865671642E-3,3.2014925373134327E-3,4.7388059701492538E-4,2.0149253731343282]
["MT",487,772,23,429000,279000,null,"MT",1.7455197132616488E-3,2.7670250896057349E-3,8.2437275985663085E-5,1.5376344086021505]
["NC",755,2046,284,1201000,663000,null,"NC",1.138763197586727E-3,3.0859728506787329E-3,4.283559577677225E-4,1.8114630467571644]
["ND",227,472,4,127000,21000,null,"ND",1.0809523809523809E-2,2.2476190476190476E-2,1.9047619047619048E-4,6.0476190476190474]
["NE",663,1074,1,391000,29000,null,"NE",2.2862068965517242E-2,3.7034482758620688E-2,3.4482758620689657E-5,13.482758620689655]
["NH",59,425,7,74000,158000,null,"NH",3.7341772151898732E-4,2.689873417721519E-3,4.4303797468354433E-5,0.46835443037974683]
["NJ",551,813,148,939000,452000,null,"NJ",1.2190265486725664E-3,1.7986725663716814E-3,3.2743362831858409E-4,2.0774336283185839]
["NM",814,235,3,440000,63000,null,"NM",1.2920634920634921E-2,3.7301587301587303E-3,4.761904761904762E-5,6.9841269841269842]
["NV",254,132,10,327000,75000,null,"NV",3.3866666666666667E-3,1.7600000000000001E-3,1.3333333333333334E-4,4.3600000000000003]
["NY",862,1540,69,1190000,561000,null,"NY",1.536541889483066E-3,2.7450980392156863E-3,1.2299465240641711E-4,2.1212121212121211]
["OH",2050,12579,146,2459000,419000,null,"OH",4.8926014319809067E-3,3.0021479713603819E-2,3.4844868735083533E-4,5.8687350835322194]
["OK",888,1132,29,637000,378000,null,"OK",2.3492063492063491E-3,2.9947089947089949E-3,7.6719576719576726E-5,1.6851851851851851]
["OR",105,138,17,122000,141000,null,"OR",7.4468085106382982E-4,9.7872340425531924E-4,1.2056737588652483E-4,0.86524822695035464]
["PA",2005,10488,128,2067000,590000,null,"PA",3.3983050847457628E-3,1.7776271186440679E-2,2.1694915254237288E-4,3.5033898305084747]
["RI",25,1,2,130000,54000,null,"RI",4.6296296296296298E-4,1.8518518518518518E-5,3.7037037037037037E-5,2.4074074074074074]
["SC",313,1316,101,514000,352000,null,"SC",8.8920454545454546E-4,3.7386363636363637E-3,2.8693181818181818E-4,1.4602272727272727]
["SD",503,486,2,149000,24000,null,"SD",2.0958333333333332E-2,2.0250000000000001E-2,8.3333333333333331E-5,6.208333333333333]
["TN",738,2755,145,1072000,497000,null,"TN",1.4849094567404427E-3,5.5432595573440642E-3,2.9175050301810863E-4,2.1569416498993963]
["TX",2215,6172,213,3352000,105800,null,"TX",2.0935727788279773E-2,5.833648393194707E-2,2.0132325141776937E-3,31.682419659735348]
["UT",895,349,20,564000,98000,null,"UT",9.13265306122449E-3,3.5612244897959182E-3,2.0408163265306123E-4,5.7551020408163263]
["VA",908,2760,215,979000,401000,null,"VA",2.2643391521197007E-3,6.8827930174563592E-3,5.3615960099750624E-4,2.4413965087281797]
["VT",47,4.7,6,1010,36000,null,"VT",1.3055555555555555E-3,1.3055555555555555E-4,1.6666666666666666E-4,2.8055555555555556E-2]
["WA",265,96,19,301000,310000,null,"WA",8.5483870967741939E-4,3.0967741935483873E-4,6.1290322580645156E-5,0.97096774193548385]
["WI",1104,3415,20,1383000,250000,null,"WI",4.4159999999999998E-3,1.366E-2,8.0000000000000007E-5,5.532]
["WV",204,971,47,388000,156000,null,"WV",1.3076923076923077E-3,6.2243589743589747E-3,3.012820512820513E-4,2.4871794871794872]
["WY",175,196,14,123000,96000,null,"WY",{"$f":"B50/F50","v":1.8229166666666667E-3},2.0416666666666665E-3,{"$f":"D50/F50","v":1.4583333333333335E-4},{"$f":"E50/F50","v":1.28125}]

{"sheet":"ElectricityPriceByState","index":5,"n_rows":68,"n_cols":19,"rows_kept":68,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,4,18]]}
["Average retail price of electricity (cents per kilowatthour)"]
["https://www.eia.gov/electricity/data/browser/#/topic/7?agg=1,0&geo=vvvvvvvvvvvvo&endsec=8&freq=A&start=2001&end=2018&ctype=linechart&ltype=pin&rtype=s&maptype=0&rse=0&pin="]
["Source: U.S. Energy Information Administration"]
[]
["State/Region","Average retail price of residential electricity (cents per kilowatthour)"]
[null,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
["United States",8.58,8.44,8.7200000000000006,8.9499999999999993,9.4499999999999993,10.4,10.65,11.26,11.51,11.54,11.72,11.88,12.13,12.52,12.65,12.55,12.89,12.87]
["New England",12.08,11.23,11.68,11.91,13.44,15.98,16.7,17.649999999999999,17.48,16.23,15.89,15.71,16.22,17.82,19.43,18.809999999999999,19.41,20.6]
["Connecticut",10.9,10.96,11.31,11.63,13.64,16.86,19.11,19.54,20.329999999999998,19.25,18.11,17.34,17.55,19.75,20.94,20.010000000000002,20.29,21.2]
["Maine",13.13,12.74,12.37,12.16,13.23,13.8,16.52,16.239999999999998,15.64,15.72,15.38,14.66,14.35,15.27,15.61,15.83,15.97,16.84]
["Massachusetts",12.47,10.93,11.6,11.75,13.44,16.600000000000001,16.23,17.559999999999999,16.87,14.59,14.67,14.91,15.83,17.39,19.829999999999998,19,20.059999999999999,21.61]
["New Hampshire",12.49,11.89,11.98,12.49,13.51,14.68,14.88,15.68,16.39,16.32,16.52,16.07,16.329999999999998,17.53,18.5,18.38,19.2,19.690000000000001]
["Rhode Island",12.13,10.199999999999999,11.61,12.19,13.04,15.12,14.05,17.45,15.6,15.92,14.33,14.4,15.2,17.170000000000002,19.29,18.62,18.32,20.55]
["Vermont",12.67,12.78,12.82,12.94,12.96,13.39,14.15,14.48,14.9,15.57,16.260000000000002,17.010000000000002,17.14,17.47,17.09,17.37,17.68,18.02]
["Middle Atlantic",11.46,11.33,11.62,11.81,12.49,13.36,13.95,14.88,14.84,15.81,15.8,15.27,15.7,16.39,15.97,15.68,15.99,15.97]
["New Jersey",10.210000000000001,10.38,10.67,11.23,11.74,12.84,14.14,15.66,16.309999999999999,16.57,16.23,15.78,15.73,15.78,15.81,15.72,15.65,15.41]
["New York",14.04,13.55,14.31,14.54,15.72,16.89,17.100000000000001,18.309999999999999,17.5,18.739999999999998,18.260000000000002,17.62,18.79,20.07,18.54,17.579999999999998,18.03,18.52]
["Pennsylvania",9.68,9.74,9.59,9.58,9.86,10.35,10.95,11.35,11.65,12.7,13.26,12.75,12.79,13.32,13.64,13.86,14.23,13.89]
["East North Central",8.1300000000000008,8.0500000000000007,8.15,8.2799999999999994,8.41,9.14,9.74,10.39,10.92,11.41,11.79,12.05,12.14,12.65,12.96,13.06,13.36,13.25]
["Illinois",8.7100000000000009,8.39,8.3800000000000008,8.3699999999999992,8.34,8.42,10.119999999999999,11.07,11.27,11.52,11.78,11.37,10.63,11.91,12.5,12.54,12.95,12.77]
["Indiana",6.92,6.91,7.04,7.3,7.5,8.2200000000000006,8.26,8.8699999999999992,9.5,9.56,10.06,10.53,10.99,11.46,11.57,11.79,12.29,12.26]
["Michigan",8.26,8.2799999999999994,8.35,8.33,8.4,9.77,10.210000000000001,10.75,11.6,12.46,13.27,14.13,14.59,14.46,14.42,15.22,15.4,15.45]
["Ohio",8.3699999999999992,8.24,8.26,8.4499999999999993,8.51,9.34,9.57,10.06,10.67,11.31,11.42,11.76,12.01,12.5,12.8,12.47,12.63,12.56]
["Wisconsin",7.9,8.18,8.67,9.07,9.66,10.51,10.87,11.51,11.94,12.65,13.02,13.19,13.55,13.67,14.11,14.07,14.35,14.02]
["West North Central",7.37,7.37,7.42,7.57,7.78,8.1199999999999992,8.31,8.67,9.14,9.64,10.119999999999999,10.59,10.94,11.09,11.47,11.79,12.13,12]
["Iowa",8.41,8.35,8.57,8.9600000000000009,9.27,9.6300000000000008,9.4499999999999993,9.49,9.99,10.42,10.46,10.82,11.04,11.16,11.63,11.94,12.34,12.24]
["Kansas",7.66,7.67,7.71,7.74,7.9,8.25,8.19,8.89,9.5299999999999994,10.029999999999999,10.65,11.24,11.64,12.17,12.34,13.06,13.31,13.35]
["Minnesota",7.61,7.49,7.65,7.92,8.2799999999999994,8.6999999999999993,9.18,9.74,10.039999999999999,10.59,10.96,11.35,11.81,12.01,12.12,12.67,13.04,13.14]
["Missouri",7,7.06,6.96,6.97,7.08,7.44,7.69,8,8.5399999999999991,9.08,9.75,10.17,10.6,10.64,11.21,11.21,11.63,11.34]
["Nebraska",6.5,6.73,6.87,6.96,7.14,7.41,7.59,7.87,8.52,8.94,9.32,10.039999999999999,10.31,10.4,10.6,10.84,10.97,10.7]
["North Dakota",6.47,6.39,6.49,6.79,6.99,7.14,7.3,7.51,7.58,8.1300000000000008,8.58,9.06,9.1199999999999992,9.15,9.6199999999999992,10.16,10.29,10.25]
["South Dakota",7.42,7.4,7.47,7.65,7.77,7.83,8.07,8.27,8.49,8.9700000000000006,9.35,10.07,10.26,10.47,11.08,11.47,11.77,11.59]
["South Atlantic",8.0500000000000007,7.91,8.1,8.33,8.83,9.76,10.029999999999999,10.67,11.32,10.96,11.19,11.38,11.39,11.74,11.74,11.56,11.86,11.7]
["Delaware",8.61,8.6999999999999993,8.59,8.7799999999999994,9.01,11.85,13.16,13.93,14.07,13.8,13.7,13.58,12.95,13.29,13.42,13.42,13.35,12.53]
["District Of Columbia",7.79,7.98,7.84,8,9.1,9.8800000000000008,11.18,12.78,13.73,14.01,13.4,12.28,12.57,12.74,12.99,12.29,12.94,12.84]
["Florida",8.59,8.16,8.5500000000000007,8.99,9.6199999999999992,11.33,11.22,11.65,12.39,11.44,11.51,11.42,11.27,11.89,11.58,10.98,11.61,11.54]
["Georgia",7.72,7.63,7.7,7.86,8.64,8.91,9.1,9.93,10.130000000000001,10.07,11.05,11.17,11.46,11.65,11.54,11.5,11.9,11.47]
["Maryland",7.67,7.74,7.73,7.8,8.4600000000000009,9.7100000000000009,11.89,13.84,14.98,14.32,13.31,12.84,13.25,13.63,13.82,14.23,13.96,13.3]
["North Carolina",8.1199999999999992,8.19,8.32,8.4499999999999993,8.65,9.1199999999999992,9.4,9.52,9.99,10.119999999999999,10.26,10.91,10.97,11.1,11.28,11.03,10.94,11.09]
["South Carolina",7.69,7.72,8.01,8.1199999999999992,8.67,9.0299999999999994,9.19,9.89,10.44,10.5,11.05,11.77,11.99,12.45,12.57,12.65,13.02,12.44]
["Virginia",7.79,7.79,7.76,7.99,8.16,8.49,8.74,9.6199999999999992,10.61,10.45,10.64,11.08,10.84,11.1,11.37,11.36,11.55,11.73]
["West Virginia",6.26,6.23,6.24,6.23,6.21,6.35,6.73,7.06,7.9,8.7899999999999991,9.39,9.85,9.52,9.34,10.08,11.44,11.63,11.18]
["East South Central",6.51,6.57,6.78,7.12,7.42,8.16,8.35,9.32,9.61,9.58,10.14,10.32,10.4,10.76,10.82,10.86,11.3,11.14]
["Alabama",7.01,7.12,7.39,7.62,8,8.75,9.32,10.4,10.66,10.67,11.09,11.4,11.26,11.48,11.7,11.99,12.55,12.18]
["Kentucky",5.58,5.65,5.81,6.11,6.57,7.02,7.34,7.94,8.3699999999999992,8.57,9.1999999999999993,9.43,9.7899999999999991,10.16,10.24,10.49,10.85,10.6]
["Mississippi",7.37,7.28,7.6,8.2100000000000009,8.7100000000000009,9.66,9.36,10.39,10.220000000000001,9.8699999999999992,10.17,10.26,10.78,11.32,11.27,10.47,11.08,11.12]
["Tennessee",6.32,6.41,6.55,6.9,6.98,7.75,7.84,8.91,9.32,9.23,9.98,10.1,9.98,10.32,10.3,10.41,10.72,10.71]
["West South Central",8.4499999999999993,7.7,8.61,9.0500000000000007,10.039999999999999,11.48,11.15,11.86,11.04,10.67,10.42,10.3,10.74,11.12,10.95,10.59,10.74,10.77]
["Arkansas",7.72,7.25,7.24,7.36,8,8.85,8.73,9.27,9.14,8.86,9.02,9.3000000000000007,9.59,9.51,9.82,9.92,10.28,9.81]
["Louisiana",7.92,7.1,7.84,8.0500000000000007,8.8699999999999992,9.14,9.3699999999999992,10.28,8.1,8.98,8.9600000000000009,8.3699999999999992,9.43,9.57,9.33,9.34,9.74,9.59]
["Oklahoma",7.27,6.73,7.47,7.72,7.95,8.5500000000000007,8.58,9.09,8.49,9.14,9.4700000000000006,9.51,9.67,10.029999999999999,10.14,10.199999999999999,10.61,10.3]
["Texas",8.86,8.0500000000000007,9.16,9.73,10.93,12.86,12.34,13.03,12.38,11.6,11.08,10.98,11.35,11.86,11.56,10.99,11.01,11.2]
["Mountain",7.8,7.87,8.02,8.24,8.67,8.98,9.31,9.84,10.18,10.49,10.56,10.94,11.31,11.67,11.83,11.65,11.89,11.94]
["Arizona",8.3000000000000007,8.27,8.35,8.4600000000000009,8.86,9.4,9.66,10.27,10.73,10.97,11.08,11.29,11.71,11.9,12.13,12.15,12.44,12.77]
["Colorado",7.47,7.37,8.14,8.42,9.06,9.02,9.25,10.130000000000001,10,11.04,11.27,11.46,11.93,12.18,12.12,12.07,12.17,12.15]
["Idaho",6.01,6.59,6.24,6.1,6.29,6.21,6.36,6.99,7.8,7.99,7.87,8.67,9.32,9.7200000000000006,9.93,9.9499999999999993,10.039999999999999,10.15]
["Montana",6.88,7.23,7.56,7.86,8.1,8.2799999999999994,8.77,9.1300000000000008,8.94,9.16,9.75,10.08,10.33,10.18,10.88,10.94,10.95,10.96]
["Nevada",9.08,9.43,9.02,9.69,10.199999999999999,11.08,11.82,11.93,12.86,12.36,11.61,11.83,11.89,12.93,12.76,11.41,11.99,11.85]
["New Mexico",8.74,8.5,8.69,8.67,9.1300000000000008,9.06,9.1199999999999992,10.01,10.02,10.52,11,11.37,11.68,12.28,12.47,12.03,12.88,12.68]
["Utah",6.72,6.79,6.9,7.21,7.52,7.59,8.15,8.26,8.48,8.7100000000000009,8.9600000000000009,9.93,10.37,10.65,10.88,11.02,10.95,10.41]
["Wyoming",6.77,6.97,7.04,7.21,7.48,7.75,7.75,8.2100000000000009,8.58,8.77,9.11,9.85,10.16,10.5,10.97,11.13,11.37,11.29]
["Pacific Contiguous",9.68,10.27,10.11,10.11,10.36,11.62,11.82,11.55,12.15,12.31,12.43,12.94,13.51,13.64,14.28,14.59,15.08,15.56]
["California",12.09,12.64,12.23,12.2,12.51,14.33,14.42,13.81,14.74,14.75,14.78,15.34,16.23,16.25,16.989999999999998,17.39,18.309999999999999,18.84]
["Oregon",6.29,7.12,7.06,7.18,7.25,7.48,8.19,8.49,8.68,8.8699999999999992,9.5399999999999991,9.8000000000000007,9.9,10.47,10.66,10.66,10.66,10.98]
["Washington",5.7,6.29,6.31,6.37,6.54,6.82,7.26,7.54,7.67,8.0399999999999991,8.2799999999999994,8.5299999999999994,8.6999999999999993,8.67,9.09,9.48,9.66,9.75]
["Pacific Noncontiguous",14.64,14.2,14.85,15.84,17.78,19.940000000000001,20.56,25.99,21.31,23.22,27.49,28.76,28.56,29.13,25.34,24.36,25.89,28.03]
["Alaska",12.12,12.05,11.98,12.44,13.3,14.83,15.18,16.559999999999999,17.14,16.260000000000002,17.62,17.88,18.12,19.14,19.829999999999998,20.3,21.27,21.94]
["Hawaii",16.34,15.63,16.73,18.059999999999999,20.7,23.35,24.12,32.5,24.2,28.1,34.68,37.340000000000003,36.979999999999997,37.04,29.6,27.47,29.5,32.47]

{"sheet":"BenefitPerTon_Regression","index":6,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,3],[1,4,1,6]]}
["Based on \"Electricity generating units\" Sector (3% discount rate); 2015$"]
["Year","Low",null,null,"High"]
[null,"PM2.5","SO2","NOx","PM2.5","SO2","NOx"]
[2016,140000,40000,6000,330000,92000,14000]
[2017,142866.81715575606,40446.9525959366,6020.0902934537153,333069.97742663696,92361.173814898357,13880.361173814919]
[2018,145846.50112866797,41108.352144469507,6107.9006772009016,338623.02483070083,93602.708803611808,14031.602708803606]
[2019,148826.18510157987,41769.751693002181,6195.7110609480878,344176.07223476283,94844.243792324793,14182.844243792351]
[2020,150000,42000,6200,350000,96000,14000]
[2021,154785.55304740369,43092.550790067529,6371.3318284424313,355282.16704289056,97327.313769751694,14485.327313769783]
[2022,157765.2370203156,43753.950338600436,6459.1422121896176,360835.21444695257,98568.848758464679,14636.56884875847]
[2023,160744.92099322844,44415.34988713311,6546.9525959368038,366388.26185101643,99810.38374717813,14787.810383747215]
[2024,163724.60496614035,45076.749435665784,6634.7629796839901,371941.3092550803,101051.91873589158,14939.051918735902]
[2025,170000,46000,6700,370000,100000,15000]
[2026,169683.97291196417,46399.548532731365,6810.3837471783336,383047.40406320617,103534.98871331802,15241.534988713334]
[2027,172663.65688487608,47060.94808126404,6898.1941309255199,388600.45146726817,104776.52370203147,15392.776523702021]
[2028,175643.34085778799,47722.347629796714,6986.004514672677,394153.49887133203,106018.05869074492,15544.018058690766]
[2029,178623.0248306999,48383.747178329388,7073.8148984198633,399706.5462753959,107259.5936794579,15695.259593679453]
[2030,180000,49000,7200,410000,110000,16000]
[]
["Source: https://www.epa.gov/sites/production/files/2018-02/documents/sourceapportionmentbpttsd_2018.pdf "]

{"sheet":"SCC_Regression","index":7,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["3% average values"]
["Year","Global\n(2007$)","Domestic\n(2016$)"]
[2015,36,6]
[2016,37.507142857142753,6.1357142857143003]
[2017,38.430952380952249,6.2714285714286007]
[2018,39.354761904761745,6.407142857142901]
[2019,40.27857142857124,6.5428571428571445]
[2020,42,7]
[2021,42.126190476190459,6.8142857142857451]
[2022,43.049999999999955,6.9500000000000455]
[2023,43.97380952380945,7.085714285714289]
[2024,44.897619047618946,7.2214285714285893]
[2025,46,7]
[2026,46.745238095237937,7.49285714285719]
[2027,47.669047619047433,7.6285714285714334]
[2028,48.592857142857156,7.7642857142857338]
[2029,49.516666666666652,7.9000000000000341]
[2030,50,8]
[2031,51.364285714285643,8.1714285714285779]
[2032,52.288095238095138,8.3071428571428783]
[2033,53.211904761904634,8.4428571428571786]
[2034,54.13571428571413,8.5785714285714789]
[2035,55,9]
[2036,55.983333333333121,8.8500000000000227]
[2037,56.907142857142844,8.9857142857143231]
[2038,57.83095238095234,9.1214285714286234]
[2039,58.754761904761835,9.2571428571428669]
[2040,60,9]
[2041,60.602380952380827,9.5285714285714675]
[2042,61.526190476190322,9.6642857142857679]
[2043,62.449999999999818,9.8000000000000114]
[2044,63.373809523809541,9.9357142857143117]
[2045,64,10]
[2046,65.221428571428532,10.207142857142912]
[2047,66.145238095238028,10.342857142857156]
[2048,67.069047619047524,10.478571428571456]
[2049,67.992857142857019,10.614285714285757]
[2050,69,11]
[]
["Sources: "]
["Global: ","https://19january2017snapshot.epa.gov/sites/production/files/2016-12/documents/sc_co2_tsd_august_2016.pdf"]
["Domestic:","https://www.epa.gov/sites/production/files/2019-06/documents/utilities_ria_final_cpp_repeal_and_ace_2019-06.pdf "]

{"sheet":"GDP Implicit Price Deflator","index":8,"n_rows":35,"n_cols":73,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,72],[1,0,1,72],[2,0,2,72],[3,0,3,72]]}
["Table 1.1.9. Implicit Price Deflators for Gross Domestic Product"]
["[Index numbers, 2012=100]"]
["Bureau of Economic Analysis"]
["Last Revised on: July 27, 2018 - Next Release Date August 29, 2018"]
[]
["Line","",1947,1948,"1949","1950","1951","1952","1953","1954","1955","1956","1957","1958","1959","1960","1961","1962","1963","1964","1965","1966","1967","1968","1969","1970","1971","1972","1973","1974","1975","1976","1977","1978","1979","1980","1981","1982","1983","1984","1985","1986","1987","1988","1989","1990","1991","1992","1993","1994","1995","1996",1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
["Line","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["1","        Gross domestic product",12.266999999999999,12.956,12.935,13.095000000000001,14.023999999999999,14.266,14.439,14.573,14.819000000000001,15.324,15.832000000000001,16.192,16.414000000000001,16.638000000000002,16.815000000000001,17.02,17.215,17.477,17.797999999999998,18.295999999999999,18.827000000000002,19.628,20.591000000000001,21.677,22.776,23.760999999999999,25.062999999999999,27.318000000000001,29.849,31.491,33.448,35.801000000000002,38.771000000000001,42.273000000000003,46.273000000000003,49.131999999999998,51.055999999999997,52.898000000000003,54.570999999999998,55.67,57.045999999999999,59.058999999999997,61.374000000000002,63.670999999999999,65.825000000000003,67.325000000000003,68.92,70.391999999999996,71.867999999999995,73.183000000000007,74.444999999999993,75.283000000000001,76.37,78.078000000000003,79.790000000000006,81.052000000000007,82.557000000000002,84.78,87.421000000000006,90.066000000000003,92.486000000000004,94.284999999999997,95.004000000000005,96.111000000000004,98.117999999999995,100,101.755,103.68,104.789,105.935,107.94799999999999]
["2","Personal consumption expenditures",12.516999999999999,13.225,13.122,13.278,14.182,14.473000000000001,14.663,14.787000000000001,14.845000000000001,15.14,15.6,15.968999999999999,16.207000000000001,16.472999999999999,16.643999999999998,16.838999999999999,17.04,17.286999999999999,17.536000000000001,17.978999999999999,18.431000000000001,19.152000000000001,20.015000000000001,20.951000000000001,21.841000000000001,22.585999999999999,23.802,26.28,28.47,30.032,31.986000000000001,34.210999999999999,37.250999999999998,41.262,44.957999999999998,47.456000000000003,49.473999999999997,51.343000000000004,53.134,54.29,55.963999999999999,58.151000000000003,60.69,63.354999999999997,65.472999999999999,67.218000000000004,68.891999999999996,70.33,71.811000000000007,73.346000000000004,74.623000000000005,75.215999999999994,76.337999999999994,78.234999999999999,79.738,80.789000000000001,82.358000000000004,84.411000000000001,86.811999999999998,89.174000000000007,91.438000000000002,94.18,94.093999999999994,95.704999999999998,98.131,100,101.346,102.86799999999999,103.126,104.235,106.07299999999999]
["3","    Goods",21.957000000000001,23.251999999999999,22.709,22.78,24.619,24.856000000000002,24.742000000000001,24.648,24.503,24.919,25.699000000000002,26.283999999999999,26.417999999999999,26.625,26.725000000000001,26.863,27.085999999999999,27.381,27.669,28.277999999999999,28.777000000000001,29.78,30.934000000000001,32.113999999999997,33.079000000000001,33.926000000000002,35.948999999999998,40.436,43.703000000000003,45.412999999999997,47.837000000000003,50.773000000000003,55.573999999999998,61.796999999999997,66.388999999999996,68.197999999999993,69.429000000000002,70.742000000000004,71.876999999999995,71.540999999999997,73.841999999999999,75.787999999999997,78.703999999999994,81.927000000000007,83.93,84.942999999999998,85.680999999999997,86.552000000000007,87.361000000000004,88.320999999999998,88.218999999999994,86.893000000000001,87.349000000000004,89.081999999999994,89.015000000000001,88.165999999999997,88.054000000000002,89.292000000000002,91.084000000000003,92.305999999999997,93.331000000000003,96.122,93.811999999999998,95.183000000000007,98.772999999999996,100,99.406999999999996,98.938999999999993,95.888999999999996,94.34,94.632000000000005]
["4","        Durable goods",47.106999999999999,49.515999999999998,49.854999999999997,50.109000000000002,53.466999999999999,53.8,53.377000000000002,52.207999999999998,52.006,53.259,55.219000000000001,56.222000000000001,57.115000000000002,56.899000000000001,57.042999999999999,57.287999999999997,57.506999999999998,57.767000000000003,57.292999999999999,57.167999999999999,58.085999999999999,59.948,61.637999999999998,62.966999999999999,65.141000000000005,65.858999999999995,66.834000000000003,71.221999999999994,77.596000000000004,81.84,85.504999999999995,90.290999999999997,96.275000000000006,104.63,111.627,115.98099999999999,118.33199999999999,120.08199999999999,121.352,122.687,126.217,128.29900000000001,130.637,131.935,133.86799999999999,134.79300000000001,136.12,138.78399999999999,139.797,138.386,135.364,131.53800000000001,127.994,125.717,123.254,120.143,115.752,113.488,112.309,110.38800000000001,108.038,106.012,104.02,102.107,101.28,100,97.968000000000004,95.495999999999995,93.364999999999995,91.183000000000007,89.135999999999996]
["5","        Nondurable goods",14.869,15.78,15.266,15.304,16.614999999999998,16.794,16.734999999999999,16.774999999999999,16.666,16.905000000000001,17.399999999999999,17.824000000000002,17.850000000000001,18.062999999999999,18.138999999999999,18.238,18.419,18.664999999999999,19.001999999999999,19.61,19.968,20.687999999999999,21.582999999999998,22.553000000000001,23.19,23.933,25.863,29.774999999999999,32.076000000000001,33.119999999999997,35.018000000000001,37.256,41.271000000000001,46.335000000000001,49.912999999999997,51.045999999999999,51.921999999999997,53.000999999999998,53.993000000000002,53.304000000000002,55.116999999999997,56.869,59.69,63.112000000000002,64.954999999999998,65.897999999999996,66.433999999999997,66.787999999999997,67.486000000000004,69.013999999999996,69.734999999999999,69.222999999999999,70.942999999999998,73.989999999999995,74.775999999999996,74.781000000000006,76.326999999999998,78.97,81.998000000000005,84.552999999999997,87.040999999999997,91.903999999999996,89.466999999999999,92.182000000000002,97.652000000000001,100,100.08199999999999,100.595,97.078999999999994,95.867000000000004,97.436999999999998]
["6","    Services",8.0370000000000008,8.4619999999999997,8.6050000000000004,8.8249999999999993,9.26,9.5980000000000008,9.968,10.218,10.391,10.638,10.949,11.22,11.521000000000001,11.826000000000001,12.037000000000001,12.265000000000001,12.461,12.689,12.926,13.298,13.739000000000001,14.337999999999999,15.077999999999999,15.913,16.780999999999999,17.491,18.335999999999999,19.89,21.594999999999999,23.093,24.841000000000001,26.75,28.994,32.009,35.287999999999997,38.058,40.396000000000001,42.497999999999998,44.576999999999998,46.408000000000001,47.795999999999999,50.082000000000001,52.442999999999998,54.845999999999997,56.991999999999997,59.018000000000001,61.058999999999997,62.719000000000001,64.471000000000004,66.239999999999995,68.106999999999999,69.549000000000007,70.97,72.938000000000002,75.171000000000006,77.123000000000005,79.506,81.965000000000003,84.673000000000002,87.616,90.516000000000005,93.234999999999999,94.230999999999995,95.956999999999994,97.813999999999993,100,102.316,104.852,106.82299999999999,109.325,111.98399999999999]
["7","Gross private domestic investment",17.510000000000002,18.838000000000001,18.917999999999999,19.635000000000002,21.745999999999999,21.61,21.582999999999998,21.594000000000001,22.277000000000001,23.529,24.071999999999999,24.067,24.378,24.518000000000001,24.47,24.495999999999999,24.43,24.588000000000001,24.968,25.481000000000002,26.132000000000001,27.116,28.408999999999999,29.635999999999999,31.097000000000001,32.396000000000001,34.164999999999999,37.630000000000003,42.079000000000001,44.396999999999998,47.674999999999997,51.542000000000002,56.174999999999997,61.353999999999999,67.147999999999996,70.688000000000002,70.938999999999993,71.688999999999993,72.570999999999998,74.159000000000006,75.763999999999996,77.652000000000001,79.63,81.227999999999994,82.683999999999997,82.671999999999997,83.641000000000005,84.908000000000001,86.263000000000005,86.227000000000004,86.239000000000004,85.706000000000003,85.825999999999993,86.861999999999995,87.367000000000004,87.927000000000007,88.503,91.156999999999996,94.912999999999997,98.13,99.584999999999994,100.59699999999999,99.366,97.698999999999998,98.748000000000005,100,100.876,102.959,103.873,103.914,105.36]
["8","    Fixed investment",16.28,17.641999999999999,17.98,18.38,19.943999999999999,20.420000000000002,20.599,20.754000000000001,21.106000000000002,22.315000000000001,23.077999999999999,23.172999999999998,23.408000000000001,23.553999999999998,23.501000000000001,23.527000000000001,23.47,23.632999999999999,24.018999999999998,24.523,25.184999999999999,26.196000000000002,27.498000000000001,28.699000000000002,30.134,31.42,33.168999999999997,36.448999999999998,40.874000000000002,43.231999999999999,46.55,50.444000000000003,54.976999999999997,60.104999999999997,65.623999999999995,69.311000000000007,69.575000000000003,70.253,71.277000000000001,73.021000000000001,74.506,76.585999999999999,78.561000000000007,80.278000000000006,81.683000000000007,81.727999999999994,82.710999999999999,83.983000000000004,85.378,85.45,85.599000000000004,85.132999999999996,85.277000000000001,86.486000000000004,87.241,87.5,88.265000000000001,90.843000000000004,94.596999999999994,97.957999999999998,99.456000000000003,100.29600000000001,99.075999999999993,97.567999999999998,98.641000000000005,100,101.09099999999999,103.25,104.217,104.357,105.93899999999999]
["9","        Nonresidential",20.106000000000002,21.785,{"$f":"'GDP Implicit Price Deflator'!BU8?","v":{"$error":"#NAME?"}},22.733000000000001,24.856999999999999,25.4,25.645,25.884,26.266999999999999,28.224,29.603000000000002,29.812999999999999,30.222999999999999,30.404,30.28,30.308,30.315000000000001,30.513000000000002,30.853000000000002,31.327000000000002,32.093000000000004,33.237000000000002,34.637999999999998,36.295999999999999,37.997,39.296999999999997,40.881999999999998,44.856999999999999,50.765999999999998,53.561999999999998,57.110999999999997,60.93,65.83,71.641000000000005,78.453000000000003,82.911000000000001,82.774000000000001,83.036000000000001,83.893000000000001,85.364999999999995,86.338999999999999,88.513999999999996,90.572000000000003,92.516000000000005,94.266999999999996,93.96,94.161000000000001,94.903999999999996,95.849000000000004,95.266999999999996,94.734999999999999,93.248000000000005,92.313999999999993,92.718000000000004,92.346000000000004,91.863,91.156000000000006,92.055000000000007,94.442999999999998,96.745000000000005,98.31,99.831999999999994,99.183999999999997,97.415999999999997,98.558999999999997,100,100.251,101.565,102.081,101.282,101.962]
["10","            Structures",5.968,6.6390000000000002,6.6159999999999997,6.6989999999999998,7.4710000000000001,7.6689999999999996,7.819,7.7240000000000002,7.8789999999999996,8.5530000000000008,8.92,8.7769999999999992,8.8249999999999993,8.8140000000000001,8.7609999999999992,8.83,8.9049999999999994,9.032,9.2940000000000005,9.6289999999999996,9.9290000000000003,10.427,11.114000000000001,11.845000000000001,12.757,13.673999999999999,14.734,16.77,18.773,19.692,21.401,23.468,26.193999999999999,28.629000000000001,32.566000000000003,35.136000000000003,34.241,34.54,35.360999999999997,36.039000000000001,36.618000000000002,38.170999999999999,39.665999999999997,40.948,41.689,41.698999999999998,42.921999999999997,44.436999999999998,46.362000000000002,47.54,49.354999999999997,51.612000000000002,53.198,55.283000000000001,58.177999999999997,60.603000000000002,62.768999999999998,67.415999999999997,75.733000000000004,84.748999999999995,89.748000000000005,94.334999999999994,92.613,92.006,95.361999999999995,100,101.455,107.47499999999999,109.852,110.29600000000001,113.12]
["11","            Equipment",35.856999999999999,38.442999999999998,39.972000000000001,40.978999999999999,44.46,45.356999999999999,45.457999999999998,46.542000000000002,46.997999999999998,50.493000000000002,53.335999999999999,54.375,55.371000000000002,55.838000000000001,55.534999999999997,55.271999999999998,54.984999999999999,54.954999999999998,55.026000000000003,55.204000000000001,56.466999999999999,58.017000000000003,59.656999999999996,61.890999999999998,63.847999999999999,64.686000000000007,65.78,70.712999999999994,81.483999999999995,86.486000000000004,91.8,96.9,103.167,112.25,120.46299999999999,125.41500000000001,125.776,124.748,124.748,127.254,128.083,129.85400000000001,132.33699999999999,135.042,137.33000000000001,137.12100000000001,135.518,135.27699999999999,133.79599999999999,130.762,127.15600000000001,121.45099999999999,116.76300000000001,114.224,110.858,108.53100000000001,105.72499999999999,104.84099999999999,104.598,103.56,103.191,102.542,103.16800000000001,99.471000000000004,99.447000000000003,100,99.787000000000006,99.281999999999996,98.742999999999995,97.738,97.183000000000007]
["12","            Intellectual property products",22.754999999999999,23.934999999999999,23.984000000000002,24.545000000000002,26.053999999999998,26.384,26.844000000000001,27.036000000000001,27.678999999999998,28.731000000000002,29.643999999999998,30.361999999999998,30.922000000000001,31.393000000000001,31.596,31.751000000000001,31.791,32.281999999999996,32.509,33.002000000000002,33.505000000000003,34.676000000000002,36.204000000000001,37.929000000000002,39.317999999999998,40.49,42.494,46.460999999999999,50.19,52.408000000000001,54.709000000000003,57.557000000000002,61.381999999999998,66.123000000000005,71.058000000000007,75.093000000000004,77.897999999999996,80.081000000000003,81.412999999999997,82.046999999999997,83.518000000000001,86.129000000000005,87.24,88.147000000000006,90.271000000000001,89.373000000000005,89.998000000000005,90.468000000000004,93.134,93.543999999999997,94.052000000000007,93.594999999999999,95.105000000000004,97.813999999999993,97.683999999999997,96.376000000000005,95.647000000000006,95.334999999999994,95.951999999999998,97.087999999999994,98.284000000000006,99.834000000000003,98.588999999999999,98.305999999999997,99.516999999999996,100,100.081,100.73399999999999,101.51600000000001,100.208,101.294]
["13","        Residential",9.4019999999999992,10.192,10.327,10.582000000000001,11.34,11.651999999999999,11.736000000000001,11.782999999999999,12.028,12.335000000000001,12.368,12.337999999999999,12.374000000000001,12.458,12.477,12.497,12.398999999999999,12.496,12.846,13.311999999999999,13.77,14.497999999999999,15.518000000000001,16.015999999999998,16.943000000000001,17.975000000000001,19.571000000000002,21.593,23.59,25.117000000000001,27.683,31.082000000000001,34.593000000000004,38.323999999999998,41.424999999999997,43.646000000000001,44.68,46.003,47.267000000000003,49.350999999999999,51.485999999999997,53.279000000000003,55.02,56.287999999999997,57.021000000000001,57.722999999999999,60.073999999999998,62.247,64.472999999999999,65.855999999999995,67.444000000000003,69.222999999999999,71.816000000000003,75.004000000000005,78.563999999999993,80.510000000000005,84.325000000000003,90.242999999999995,96.706000000000003,102.355,103.708,102.249,98.671000000000006,98.316999999999993,99.049000000000007,100,105.054,111.10599999999999,114.1,118.185,123.495]
["14","    Change in private inventories","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["15","Net exports of goods and services","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["16","    Exports",20.416,21.504999999999999,20.222000000000001,19.690999999999999,22.248000000000001,22.384,22.321000000000002,22.016999999999999,22.206,22.948,23.818999999999999,23.577999999999999,23.63,23.962,24.324999999999999,24.384,24.335999999999999,24.530999999999999,25.312000000000001,26.079000000000001,27.084,27.664000000000001,28.588999999999999,29.710999999999999,30.795999999999999,32.145000000000003,36.381999999999998,44.807000000000002,49.387999999999998,51.009,53.088000000000001,56.317,63.100999999999999,69.503,74.650000000000006,75.006,75.311000000000007,76.016000000000005,73.753,72.522999999999996,74.123999999999995,77.92,79.209999999999994,79.656999999999996,80.545000000000002,80.153000000000006,80.277000000000001,81.209999999999994,83.025000000000006,81.923000000000002,80.478999999999999,78.573999999999998,77.971000000000004,79.466999999999999,78.834999999999994,78.200999999999993,79.400000000000006,82.284000000000006,85.131,87.841999999999999,91.138999999999996,95.41,89.694000000000003,93.347999999999999,99.242000000000004,100,100.16800000000001,100.169,95.146000000000001,93.248000000000005,95.923000000000002]
["17","        Goods",23.684000000000001,25.21,23.356000000000002,22.579000000000001,25.885999999999999,25.771999999999998,25.510999999999999,25.148,25.385000000000002,26.347999999999999,27.206,26.908999999999999,27.17,27.352,27.872,27.655000000000001,27.565999999999999,27.751999999999999,28.718,29.699000000000002,30.943999999999999,31.42,32.393999999999998,33.86,34.765999999999998,35.69,41.316000000000003,51.982999999999997,57.701000000000001,59.265000000000001,61.468000000000004,64.998999999999995,73.430999999999997,80.463999999999999,86.18,85.471999999999994,84.974999999999994,85.741,81.463999999999999,78.668000000000006,80.426000000000002,85.384,86.475999999999999,85.712999999999994,85.674000000000007,84.337999999999994,83.914000000000001,84.873000000000005,86.887,84.683999999999997,82.335999999999999,79.739999999999995,78.661000000000001,80.024000000000001,79.557000000000002,78.728999999999999,79.506,82.314999999999998,84.933999999999997,87.585999999999999,91.001999999999995,95.712999999999994,88.921000000000006,92.966999999999999,99.793000000000006,100,99.311999999999998,98.322999999999993,91.275999999999996,87.822000000000003,90.49]
["18","        Services",13.404,13.259,13.551,13.685,14.404,15.227,15.680999999999999,15.512,15.583,15.787000000000001,16.777999999999999,16.664000000000001,16.286999999999999,16.856999999999999,16.91,17.489000000000001,17.521000000000001,17.727,18.128,18.463000000000001,18.986999999999998,19.734000000000002,20.536000000000001,20.975000000000001,22.347999999999999,24.431999999999999,25.645,28.882999999999999,30.878,32.664999999999999,34.497999999999998,37.076000000000001,40.127000000000002,45.237000000000002,49.182000000000002,51.966000000000001,54.034999999999997,54.6,56.564999999999998,58.497,59.75,61.082000000000001,62.774000000000001,65.748000000000005,68.555000000000007,70.165000000000006,71.456000000000003,72.322999999999993,73.683000000000007,75.137,75.897999999999996,75.739999999999995,76.325000000000003,78.159000000000006,77.106999999999999,76.951999999999998,79.171999999999997,82.236000000000004,85.634,88.49,91.504000000000005,94.745999999999995,91.385999999999996,94.197000000000003,97.998999999999995,100,102.099,104.336,103.83799999999999,105.395,108.084]
["19","    Imports",13.584,14.763,14.07,14.945,18.062999999999999,17.408999999999999,16.661999999999999,16.888999999999999,16.797999999999998,17.094000000000001,17.289000000000001,16.571000000000002,16.72,16.881,16.881,16.681999999999999,17.006,17.364000000000001,17.606000000000002,18.015999999999998,18.085999999999999,18.361000000000001,18.838999999999999,19.954000000000001,21.178999999999998,22.661999999999999,26.600999999999999,38.058,41.225999999999999,42.466999999999999,46.209000000000003,49.470999999999997,57.93,72.168999999999997,76.06,73.507000000000005,70.751000000000005,70.138999999999996,67.835999999999999,67.843999999999994,71.935000000000002,75.376999999999995,77.024000000000001,79.233000000000004,78.572999999999993,78.635999999999996,78.033000000000001,78.766000000000005,80.924000000000007,79.513999999999996,76.75,72.617999999999995,73.019000000000005,76.221000000000004,74.222999999999999,73.242000000000004,75.453999999999994,79.06,83.703000000000003,86.909000000000006,89.921000000000006,98.96,87.986999999999995,92.783000000000001,99.825999999999993,100,98.635999999999996,97.777000000000001,89.727999999999994,86.53,88.510999999999996]
["20","        Goods",13.532,14.943,14.146000000000001,15.302,19.21,18.263000000000002,17.48,17.856000000000002,17.808,18.157,18.318999999999999,17.361999999999998,17.488,17.675000000000001,17.506,17.088000000000001,17.245000000000001,17.71,17.797999999999998,18.199000000000002,18.225000000000001,18.47,18.989999999999998,20.280999999999999,21.32,22.954000000000001,27.055,40.485999999999997,43.878,45.051000000000002,49.177999999999997,52.456000000000003,61.853999999999999,78.064999999999998,82.426000000000002,79.111000000000004,75.802000000000007,75.28,72.317999999999998,70.709999999999994,75.73,79.337999999999994,81.558000000000007,83.055999999999997,81.486000000000004,81.040000000000006,80.134,80.718000000000004,82.87,80.77,77.433999999999997,72.757000000000005,72.8,76.641000000000005,74.463999999999999,73.096999999999994,74.686999999999998,78.231999999999999,83.183000000000007,86.528000000000006,89.429000000000002,99.233999999999995,86.628,92.052000000000007,99.912999999999997,100,98.054000000000002,96.715000000000003,87.463999999999999,83.768000000000001,85.760999999999996]
["21","        Services",14.128,14.627000000000001,14.222,14.25,15.092000000000001,15.124000000000001,14.472,14.432,14.278,14.471,14.71,14.404999999999999,14.583,14.691000000000001,14.974,15.17,15.792999999999999,15.927,16.483000000000001,16.896000000000001,17.059999999999999,17.393000000000001,17.747,18.38,20.045000000000002,21.042999999999999,24.341000000000001,28.946999999999999,31.294,32.707999999999998,35.033000000000001,38.215000000000003,43.156999999999996,50.085999999999999,52.264000000000003,52.302999999999997,51.444000000000003,50.56,50.497999999999998,55.969000000000001,56.762999999999998,59.533000000000001,59.218000000000004,63.655000000000001,65.983000000000004,67.835999999999999,68.411000000000001,69.753,71.930999999999997,73.725999999999999,73.724000000000004,72.281999999999996,74.537000000000006,74.259,73.213999999999999,74.271000000000001,79.866,83.817999999999998,86.721000000000004,89.134,92.77,97.798000000000002,94.510999999999996,96.415999999999997,99.391999999999996,100,101.575,103.196,101.498,100.91800000000001,102.83499999999999]
["22","Government consumption expenditures and gross investment",7.62,7.93,8.1509999999999998,8.234,8.7379999999999995,8.9169999999999998,9.0169999999999995,9.2080000000000002,9.5670000000000002,10.081,10.519,10.840999999999999,10.972,11.093,11.285,11.497999999999999,11.778,12.087999999999999,12.416,12.91,13.353,14.068,14.891999999999999,16.077999999999999,17.350999999999999,18.661000000000001,19.937000000000001,21.850999999999999,23.87,25.181000000000001,26.739000000000001,28.507000000000001,30.852,34.045000000000002,37.423999999999999,39.970999999999997,41.515999999999998,43.317,44.658999999999999,45.408999999999999,46.634999999999998,48.177,50.015999999999998,52.113,54.005000000000003,55.642000000000003,56.953000000000003,58.463000000000001,60.122999999999998,61.354999999999997,62.56,63.624000000000002,65.778000000000006,68.600999999999999,70.566999999999993,72.393000000000001,75.028000000000006,78.153000000000006,82.11,85.661000000000001,89.492000000000004,93.316999999999993,92.930999999999997,95.385999999999996,98.284999999999997,100,102.33199999999999,104.44499999999999,104.717,105.059,107.797]
["23","    Federal",9.8940000000000001,9.8710000000000004,10.266,10.393000000000001,10.811,10.93,11.015000000000001,11.278,11.821999999999999,12.395,12.936999999999999,13.446,13.56,13.654999999999999,13.818,14.012,14.364000000000001,14.811,15.179,15.691000000000001,16.041,16.847999999999999,17.713999999999999,19.108000000000001,20.669,22.484000000000002,24.050999999999998,25.968,28.254000000000001,30.012,31.856999999999999,34.008000000000003,36.564999999999998,40.098999999999997,43.843000000000004,46.948,48.499000000000002,50.637,51.712000000000003,51.957000000000001,52.317999999999998,54.024999999999999,55.533999999999999,57.25,59.308999999999997,60.823999999999998,62.151000000000003,63.860999999999997,65.837999999999994,66.936999999999998,67.971999999999994,68.840999999999994,70.519000000000005,72.885999999999996,74.236000000000004,76.631,80.007999999999996,82.76,86.203999999999994,88.948999999999998,91.59,94.403999999999996,94.213999999999999,96.421000000000006,99.07,100,100.931,102.61799999999999,103.2,103.73699999999999,105.753]
["24","        National defense",9.5730000000000004,9.6039999999999992,9.9239999999999995,10.137,10.449,10.506,10.545,10.82,11.366,11.984999999999999,12.510999999999999,12.981,13.071,13.162000000000001,13.275,13.436999999999999,13.794,14.185,14.555999999999999,15.065,15.425000000000001,16.195,17.018000000000001,18.292999999999999,19.815000000000001,21.881,23.484999999999999,25.4,27.545000000000002,29.344999999999999,31.266999999999999,33.561,36.213999999999999,39.918999999999997,43.747,47.039000000000001,48.777999999999999,51.012999999999998,51.872,51.893999999999998,52.267000000000003,53.904000000000003,55.365000000000002,57.161999999999999,58.963999999999999,60.677999999999997,61.615000000000002,63.228999999999999,65.027000000000001,66.114000000000004,67.034999999999997,67.870999999999995,69.558999999999997,71.908000000000001,73.27,75.713999999999999,79.504999999999995,82.263000000000005,86.010999999999996,89.022000000000006,91.75,94.801000000000002,94.126000000000005,96.128,98.945999999999998,100,100.60899999999999,101.995,102.256,102.557,104.209]
["25","        Nondefense",10.079000000000001,9.8390000000000004,10.43,10.266999999999999,11.129,11.718,12.164999999999999,12.286,12.707000000000001,12.843999999999999,13.391999999999999,14.083,14.384,14.49,14.909000000000001,15.247999999999999,15.542,16.175000000000001,16.513999999999999,17.004999999999999,17.289000000000001,18.18,19.154,20.905999999999999,22.521000000000001,23.579000000000001,25.018000000000001,26.904,29.484000000000002,31.123999999999999,32.781999999999996,34.612000000000002,36.951999999999998,40.106000000000002,43.643000000000001,46.304000000000002,47.396999999999998,49.279000000000003,50.906999999999996,51.747999999999998,52.076000000000001,53.973999999999997,55.604999999999997,57.093000000000004,59.786999999999999,60.825000000000003,62.994,64.897999999999996,67.222999999999999,68.343999999999994,69.590999999999994,70.518000000000001,72.177999999999997,74.578000000000003,75.906000000000006,78.221999999999994,80.894999999999996,83.637,86.531000000000006,88.799000000000007,91.281999999999996,93.664000000000001,94.364000000000004,96.941999999999993,99.289000000000001,100,101.476,103.65600000000001,104.739,105.631,108.188]
["26","    State and local",5.7839999999999998,6.4690000000000003,6.5270000000000001,6.5709999999999997,7.2190000000000003,7.5339999999999998,7.6829999999999998,7.798,7.9580000000000002,8.4629999999999992,8.8260000000000005,8.9640000000000004,9.1270000000000007,9.2859999999999996,9.5229999999999997,9.7710000000000008,9.9990000000000006,10.194000000000001,10.502000000000001,11.006,11.564,12.234,13.063000000000001,14.117000000000001,15.198,16.163,17.245999999999999,19.157,20.998999999999999,22.024000000000001,23.393999999999998,24.914000000000001,27.114000000000001,30.081,33.225999999999999,35.401000000000003,36.963999999999999,38.543999999999997,40.113,41.268999999999998,43.195999999999998,44.64,46.752000000000002,49.152999999999999,50.953000000000003,52.69,54.002000000000002,55.393999999999998,56.871000000000002,58.177,59.470999999999997,60.63,63.008000000000003,66.031999999999996,68.281000000000006,69.814999999999998,72.05,75.369,79.608999999999995,83.617000000000004,88.132999999999996,92.558000000000007,92.048000000000002,94.668999999999997,97.739000000000004,100,103.279,105.67,105.748,105.97,109.155]
["","Addendum:","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["27","    Gross national product",12.241,12.928000000000001,12.906000000000001,13.066000000000001,13.991,14.233000000000001,14.404999999999999,14.539,14.787000000000001,15.29,15.797000000000001,16.157,16.379000000000001,16.603000000000002,16.78,16.986000000000001,17.181999999999999,17.443999999999999,17.765000000000001,18.263000000000002,18.792999999999999,19.594000000000001,20.553999999999998,21.638999999999999,22.738,23.721,25.024000000000001,27.271000000000001,29.8,31.446000000000002,33.401000000000003,35.752000000000002,38.719000000000001,42.213000000000001,46.210999999999999,49.064999999999998,50.991999999999997,52.832000000000001,54.503,55.606000000000002,56.997,59.01,61.33,63.637,65.801000000000002,67.299000000000007,68.891000000000005,70.36,71.843000000000004,73.161000000000001,74.423000000000002,75.263000000000005,76.347999999999999,78.052999999999997,79.763999999999996,81.025999999999996,82.533000000000001,84.754000000000005,87.394999999999996,90.040999999999997,92.46,94.268000000000001,94.997,96.102000000000004,98.117999999999995,100,101.754,103.667,104.755,105.90300000000001,107.90300000000001]

{"sheet":"AVERT_2017","index":9,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,0,3,4],[26,6,26,10]]}
["2017 AVERT Emission Factors"]
[]
["National Emission Factors"]
["National Weighted Averages (lb/MWh)"]
[" ","Wind","Utility PV","Portfolio EE","Uniform EE"]
["Avoided CO2 Rate",1485.0040306744493,1486.1476865589939,1592.1159595294362,1597.681215354813]
["Avoided NOx Rate",0.88448944837642496,0.93630380515226497,0.98686949367578802,0.96303462290875952]
["Avoided SO2 Rate",0.99530156272411752,0.96294669220088491,1.0473950047377549,1.0718438097366949]
["Avoided PM2.5 Rate",0.1076863597881715,0.108857389095979,0.116630196296614,0.11621650705011399]
["National factors presented here reflect a weighted average of the avoided emission rates of AVERT’s 10 regions. Averages are weighted by the fraction of 2017 fossil generation in each region."]
[]
[]
["Regional Emission Factors"]
["Avoided CO2 Rate (lb/MWh) ",null,null,null,null,null,"Avoided NOx Rate (lb/MWh)"]
[" ","Wind","Utility PV","Portfolio EE","Uniform EE",null," ","Wind","Utility PV","Portfolio EE","Uniform EE"]
["Northeast",1057.4553862695191,1074.6382785583721,1163.2327940307741,1140.2738774545749,null,"Northeast",0.3688380930916435,0.46304790497725051,0.50656339606135403,0.43103012510669703]
["Great Lakes/Mid-Atlantic",1595.7181181210349,1594.863799874156,1712.437370719523,1708.9405960199842,null,"Great Lakes/Mid-Atlantic",0.93368554777331703,0.94176702040941551,1.00826035492195,0.98590615073606291]
["Southeast",1406.1319737750769,1452.2498907980262,1547.9528961608601,1534.0757613618798,null,"Southeast",0.82940036985772203,0.95596597412263751,0.97384622604077897,0.93052642990953249]
["Lower Midwest",1746.9929833846697,1667.0897412239101,1808.5286278961239,1855.1581119520231,null,"Lower Midwest",1.0995054540403799,1.1651828484715598,1.243942042823265,1.202439471233435]
["Upper Midwest",1883.7751019760578,1793.6120619663679,1966.3559674496739,2009.0045239781302,null,"Upper Midwest",1.306757150605625,1.22795959629625,1.3512295174146352,1.3807234878788051]
["Rocky Mountains",1612.3276920938993,1562.3066010019588,1702.0449547895012,1737.8617011243109,null,"Rocky Mountains",1.32861303801312,1.2707768050604851,1.3808958846265802,1.42313617262887]
["Texas",1328.8234914949619,1265.796578471165,1361.0546201035011,1395.1168885400018,null,"Texas",0.59965091068832543,0.66306873579354852,0.69413185655790843,0.65331796964456301]
["Southwest",1263.5777610927419,1267.8517586500759,1359.248887728266,1364.842081706483,null,"Southwest",0.89599419406358694,0.93667676006906397,1.0039525409637999,0.98662668042475943]
["Northwest",1558.2118606813808,1591.091901244301,1653.1618461582229,1696.824328673566,null,"Northwest",1.1820705863919101,1.2226458247873899,1.24497765039702,1.2921949161865052]
["California",1033.5532829620822,1050.9664640330373,1136.1535828319329,1127.3818341599081,null,"California",0.32188976023684351,0.32072450324757995,0.33173039412766248,0.34487416228586054]
[]
["Avoided SO2 Rate (lb/MWh)",null,null,null,null,null,"Avoided PM2.5 Rate (lb/MWh) "]
[" ","Wind","Utility PV","Portfolio EE","Uniform EE",null," ","Wind","Utility PV","Portfolio EE","Uniform EE"]
["Northeast",0.270004562433307,0.30225502558576445,0.3349645371145385,0.28309122537265902,null,"Northeast",4.0459534199957597E-2,4.6048209063572154E-2,4.9755479387913949E-2,4.5166520502734703E-2]
["Great Lakes/Mid-Atlantic",1.083690997048955,1.196831764515925,1.2800238877348051,1.2549787840850701,null,"Great Lakes/Mid-Atlantic",0.1964647478310535,0.19533088480761951,0.21077436898443552,0.21038508533316702]
["Southeast",0.73109713261569009,0.74681947944894955,0.7914408541362995,0.788492001199248,null,"Southeast",9.4770776419046493E-2,0.1020015477818535,0.106926489413422,0.10451385980316499]
["Lower Midwest",1.8002605184063198,1.6099725783979548,1.7734073712906748,1.8776048387896001,null,"Lower Midwest",9.2145949396086391E-2,9.1555646624185597E-2,9.8623059955572301E-2,9.891248930513985E-2]
["Upper Midwest",1.93742550126075,1.6732723835153349,1.9100099079350099,2.02860038682077,null,"Upper Midwest",9.1959042682420153E-2,8.8227943198888603E-2,9.6536188725867195E-2,9.855173382644114E-2]
["Rocky Mountains",0.57623640340238103,0.51615788903807003,0.56667879007440791,0.60044089608265905,null,"Rocky Mountains",3.2462086949150301E-2,3.5378700568644852E-2,3.7823576823414695E-2,3.6387188497506745E-2]
["Texas",1.3069717093437001,1.0461111444645801,1.1770258199404551,1.3172687069506199,null,"Texas",7.3035123472321745E-2,6.7850130599451608E-2,7.3690672440057947E-2,7.633690172792984E-2]
["Southwest",0.26597314935614152,0.22040685167409502,0.20063009423642,0.2431762626984065,null,"Southwest",7.2216754107128051E-2,7.1024835476881792E-2,7.3122602762430988E-2,7.5400756039452455E-2]
["Northwest",0.83152461007003298,0.86283444272426701,0.92641225456863352,0.92228926104787101,null,"Northwest",8.0453916616998147E-2,8.1908378115209207E-2,8.5284717150995559E-2,8.775666425259375E-2]
["California",7.2325675591637148E-2,6.8890034295074551E-2,7.3865345551519551E-2,7.7862708857230345E-2,null,"California",4.4136443399170049E-2,4.5442244421623146E-2,4.828204595316235E-2,4.8109721685088105E-2]
[]
["Wind = Wind power generation"]
["Utility PV = Utility-scale photovoltaic power generation"]
["Portfolio EE = Represents a wide range of EE program types"]
["Uniform EE = Represents consistent energy savings throughout the year"]
[]
[]
["Source: https://www.epa.gov/statelocalenergy/avoided-emission-factors-generated-avert "]