{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["State vs Performance","State Data","Test"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"comments":0,"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":"State vs Performance","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,5],[6,0,6,1],[27,0,27,5],[7,0,7,1],[11,0,11,1],[12,0,12,1],[14,0,14,2],[21,0,21,2],[5,0,5,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[29,0,29,5]]}
["EGU Type","Generation After Gas Shift (MWh)","Actual Rate      (lbs CO2/MWh)","ERCs Issued (Needed) Under State Goal","ERCs Issued  (Needed) Under Performance Rates","GS_ERCs Issued to NGCC Under Performance Rates","Total ERCs Issued (Needed) Under State Goal","Total ERCs Issued (Needed) Under Performance Rates","Total ERCs Issued (Needed) Under Performance Rates - No GS_ERCs","Emissions Under State Goal (Tons)**","Emissions Under Perforfmance Rate (Tons)**","-"]
["NGCC",{"$f":"BaselineNGCCGen+GSChange","v":26783421.009999994},{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$F$51, 6)","v":900.47459773698267},{"$f":"NGCCGen*((StateGoal-NGCCActualRate)/StateGoal)","v":3385521.8948337212},{"$f":"NGCCGen*((NGCCGoal-NGCCActualRate)/NGCCGoal)","v":-4497759.6125680925},{"$f":"NGCCGen*IGR*(1-(NGCCActualRate/FFSGoal))","v":2158612.4759333329},null,null,null,null,null,"Interim Step 1"]
["FFS",{"$f":"BaselineFFSGen-GSChange","v":25370640},{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$F$51, 5)","v":2239.2923284552539},{"$f":"FFSGen*((StateGoal-FFSActualRate)/StateGoal)","v":-29745851.618066974},{"$f":"FFSGen*((FFSGoal-FFSActualRate)/FFSGoal)","v":-18163673.808429122},null,null,null,null,null,null,"Interim Step 2"]
[null,null,null,null,null,null,{"$f":"D2+D3","v":-26360329.723233253},{"$f":"E2+E3+F2","v":-20502820.945063882},{"$f":"E2+E3","v":-22661433.420997214},{"$f":"(NGCCGen*NGCCActualRate+FFSGen*FFSActualRate+ERCtoMassConversionRate*G4)/2000","v":25703250.24498938},{"$f":"(NGCCGen*NGCCActualRate+FFSGen*FFSActualRate+ERCtoMassConversionRate*H4)/2000","v":28983455.160764229},"Interim Step 3"]
[null,null,null,null,null,null,null,null,null,null,null,"-"]
["Assumptions:",null,null,null,null,null,null,null,null,null,null,"Final"]
["State",null,null,3]
["Compliance Period",null,null,null,null,null,null,null,null,null,null,6]
["lbs/MWh ERC Conversion Rate",null,1120]
["Baseline NGCC Generation (MWh)",null,{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$F$51, 4)","v":26783421.009999994}]
["Baseline FFS Generation (MWh)",null,{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$F$51, 3)","v":25370640}]
["Shift from FFS to NGCC (MWh)",null,0]
["Calcuate Shift",null,null,null,null,null,null,null,null,null,null,{"$f":"G4-H4","v":-5857508.7781693712}]
[]
["Possible goal rates and IGR for selected state:"]
["Compliance Period","Interim Step 1 (2022-2024)","Interim Step 2 (2025-2027)","Interim Step 3 (2028-2029)","Interim Goal (2022-2029)","Final Goal (2030+)"]
["State Goal",{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$K$51, 7)","v":1263.0097625498704},{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$K$51, 8)","v":1149.1868536310674},{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$K$51, 9)","v":1073.7378293275171},{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$K$51, 10)","v":1173.4918979479871},{"$f":"VLOOKUP(INDEX(StateNames, $D$7),'State Data'!$A$2:$K$51, 11)","v":1030.7673411741098}]
["NGCC Performance Rate",877,817,784,832,771]
["FFS Performance Rate",1671,1500,1380,1534,1305]
["Incr. Gen. Factor",0.22,0.32,0.28000000000000003,null,0.26]
[]
["Goal rates and IGR for selected compliance period:"]
["State Goal",{"$f":"VLOOKUP(A23,$A$17:$F$20,GoalSelector,FALSE)","v":1030.7673411741098}]
["NGCC Performance Rate",{"$f":"VLOOKUP(A24,$A$17:$F$20,GoalSelector,FALSE)","v":771}]
["FFS Performance Rate",{"$f":"VLOOKUP(A25,$A$17:$F$20,GoalSelector,FALSE)","v":1305}]
["Incr. Gen. Factor",{"$f":"VLOOKUP(A26,$A$17:$F$20,GoalSelector,FALSE)","v":0.26}]
[]
["Cells other than those with a green background are protected, since all other values are calculated. The password to unprotect is 1234."]
[]
["*The shift from FFS to NGCC can be set manually. Clicking the \"Run Goal Seek\" button sets the shift to the minimum amount required to make the state goal easier to comply with than the performance rates during the compliance period selected in the drop-down menu, assuming the actual rates specified. The state goal is easier to comply with when the total amount of ERCs needed under the state goal is less than the total amount of ERCs needed under the performance rates."]
[]
["**Emissions from NGCC and FFS at actual rates minus emissions assumed to be displaced by ERCs required for compliance under each rate-based approach using the assumed conversion rate. The default conversion rate is taken from the AVERT modeling results for the Southwest region in B. Biewald, et al., Air Emissions Displacement by Energy Efficiency and Renewable Energy (June 26, 2015)."]

{"sheet":"State Data","index":1,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["State","State Name","Baseline FFS Gen (MWh)","Baseline NGCC Gen (MWh)","Baseline FFS Rate (lbs/MWh)","Baseline NGCC Rate (lbs/MWh)","Interim Goal - Step 1 (2022-2024)","Interim Goal - Step 2 (2025-2027)","Interim Goal - Step 3 (2028-2029)","Interim (2022-2029)","Final (2030)"]
["AL","Alabama",46059839.57,53492095.959999993,2263.3146370726708,876.68376230887179,1244.1141827144706,1132.9550973570324,1059.5763848347369,1156.7953664185277,1018.0665607799057]
["AR","Arkansas",32154992.080000002,15651185.020000003,2264.0739448115587,896.49152968737883,1410.9029017530381,1276.2306073056936,1184.5775336357706,1304.1733844758735,1130.1746257978866]
["AZ","Arizona",25370640,26783421.009999994,2239.2923284552539,900.47459773698267,1263.0097625498704,1149.1868536310674,1073.7378293275171,1173.4918979479871,1030.7673411741098]
["CA","California",11112636,93068611.620000005,1510.7210638411987,888.07956699935232,961.28300773782394,889.99633457171547,847.6062828241088,906.87979507074351,827.95984411364259]
["CO","Colorado",34248809,11131370.270000003,2224.9994339949162,917.67290702246532,1476.1254482301658,1332.2583390403556,1233.4590963959272,1361.8053975272451,1174.0143622215796]
["CT","Connecticut",438650,15299704.41,2061.268574033968,811.48177162724676,898.68369228038773,836.22202119907445,800.69072167918227,851.56572408893919,785.88332858047511]
["DE","Delaware",2491496.6,6672110.7800000003,1824.6931021298599,979.35543418032046,1092.5465720356819,1002.754884555577,945.98281828485847,1022.8670396570394,916.18945751689319]
["FL","Florida",56452020.599999994,147327444.46999997,2144.7674090872138,867.37360266244809,1096.6258769470751,1006.2591053133415,949.04008620545392,1026.4715992241267,918.93138744399403]
["Fort Mojave","Lands of the Fort Mojave Tribe",0,1360092.99,0,858.07394684094345,876.54102744561953,817.20094103183555,784.09572318157859,832,771]
["GA","Georgia",40990604.030000001,37728636.199999996,2293.513735762338,839.51046224555648,1290.2305272181811,1172.5701433494978,1094.138650644423,1197.54473779199,1049.0639458417702]
["IA","Iowa",33314157,1430247.71,2251.1925671719687,890.88759317083611,1638.2955240662025,1471.5663237035658,1354.9987658502378,1505.1022853665118,1283.0179777574322]
["ID","Idaho",0,3450055.3121739151,0,834.14281703753898,876.54102744561953,817.20094103183555,784.09572318157859,832,771]
["IL","Illinois",84487749.579999998,10627105.720000001,2300.6066143637781,945.06387521992144,1582.2350915108407,1423.4090675737032,1312.9838231604826,1455.5661087649262,1245.3366126502428]
["IN","Indiana",96338455.320000008,12839309.009999998,2168.2798386597269,952.62929729892073,1577.5709494101659,1419.4024576434913,1309.4882442980968,1451.4447747640556,1242.2015808034269]
["KS","Kansas",29631845.43,666705.60000000009,2318.6612032755861,908,1653.5175808718859,1484.6424355885517,1366.4070589218156,1518.5528147291075,1293.2495770161586]
["KY","Kentucky",84364121,3091968.0000000005,2166.1359103119203,908,1642.9115776495648,1475.5316244440412,1358.4583043860189,1509.1811273426599,1286.1206866110831]
["LA","Louisiana",36937785,19352269.379999999,1941.7397090810941,881.48954592131929,1397.8680711820336,1265.0333752151757,1174.8084748817096,1292.6555341899457,1121.4131841273947]
["MA","Massachusetts",2611409.2400000002,23554516.930000003,2030.6484708616558,889.32592429098941,955.82947204009497,885.31161660865791,843.51908657262879,902.06093629438692,824.29421649743972]
["MD","Maryland",19190189,676555.6,2067.8427012886636,975.17735423370971,1643.9442470139918,1476.418712195836,1359.2322467583153,1510.0936156998764,1286.8148016862308]
["ME","Maine",68163.317999999999,4677598.2119999994,2635.1275670001869,847.59208738982636,887.95182195638847,827.00308719540055,792.64763503029803,842.08281788571037,778.66983582759167]
["MI","Michigan",53985652,18499950.620000001,2246.2342468328438,997.65061751283758,1468.2357157049898,1325.4808695722811,1227.5460728109697,1354.8338640250654,1168.7112298994086]
["MN","Minnesota",27587742,5715510.0300000003,2331.5447765307399,877.42935515415411,1534.6542027303221,1382.5359429215314,1277.323942847092,1413.522635283615,1213.3548251302711]
["MO","Missouri",72859571,4854569,2082.9066226590871,889.72163749243236,1621.3718459622139,1457.0284783113045,1342.3151789917747,1490.1481676564906,1271.6426232600656]
["MS","Mississippi",15557042.4,32147488.24000001,1783.1911392103682,844.40309527217448,1135.6237676158235,1039.7592287311313,978.26736945644814,1060.9309551584345,945.14405990684327]
["MT","Montana",15432987.028695652,0,2481.3499544485703,0,1670.9992669336505,1499.6596231999185,1379.5088493384344,1534,1305]
["Navajo","Lands of the Navajo Nation",29629453,0,2120.6515415590025,0,1670.9992669336505,1499.6596231999185,1379.5088493384344,1534,1305]
["NC","North Carolina",54920452,25519801.990000002,2053.8290998096745,852.57163714009823,1418.9560925849098,1283.1484913796369,1190.6130623651757,1311.2893531737591,1135.5876276279021]
["ND","North Dakota",28513455.800000001,0,2367.8470275208965,0,1670.9992669336505,1499.6596231999185,1379.5088493384344,1534,1305]
["NE","Nebraska",24698864.809999999,423638,2180.4747454707008,1015.5032362535937,1657.60240507615,1488.1513975512687,1369.468463320906,1522.1622512593917,1295.9952167699648]
["NH","New Hampshire",1353955,6946868.9900000002,2355.604565882913,877.57722058322554,1006.1258381754778,928.51740143721815,881.21410326009709,946.50386264605027,858.10122885041437]
["NJ","New Jersey",2775579,33664782.100000009,2380.1441212806408,948.56155694567781,937.05309536527454,869.18225870855315,829.44697984860761,885.46973518327741,811.67355924198023]
["NM","New Mexico",13561988,5730957.0099999998,2173.6523126255533,907.40862493400562,1435.0059536066155,1296.9357069404105,1202.6417599735928,1325.471347742156,1146.375640590187]
["NV","Nevada",4413515.04,23783255.680000003,2222.4359520931871,894.10410021711516,1000.8940401877945,924.02316148529223,877.29309012128817,941.88093597123805,854.58464360205289]
["NY","New York",16661795.41,44035433.690000013,1580.3190551839816,973.35158095044517,1094.6251285555722,1004.5404144586846,947.54060920939992,1024.7036958894719,917.58657208686327]
["OH","Ohio",86729104.549999997,23687008.750000004,2125.610122651728,866.18665097344683,1500.5681703496468,1353.2552235802041,1251.7778913502375,1383.4035005803812,1190.4436884756747]
["OK","Oklahoma",37590917.719999999,29943375.989999991,2099.3503033849315,895.27815530729686,1318.752127495201,1197.070882055315,1115.5143936852157,1222.7470233235374,1068.2349151777337]
["OR","Oregon",3116930.7338761222,13486829.823949961,2079.5252208211391,860.36533332257,1025.6802115971391,945.31507720249135,895.8692859120298,963.78251803623471,871.24482141217845]
["PA","Pennsylvania",88716924.700000003,57420455.120000005,2121.4722858850405,901.57747736476506,1358.8398882625304,1231.5072300274521,1145.5584888594135,1258.1694113861254,1095.1801505415824]
["RI","Rhode Island",0,8140017.2799999984,0,917.88146670863102,876.54102744561953,817.20094103183555,784.09572318157859,832,771]
["SC","South Carolina",28875796.539999999,11209393.6,2156.912704164662,847.85655844933467,1448.837539021627,1308.8173705514607,1213.0079530625646,1337.6932273561119,1155.6726259375553]
["SD","South Dakota",4004975.1739130444,1401048,2239.7382102578363,908,1465.1040845212985,1322.7907232758118,1225.1990465981717,1352.066688883968,1166.6062847066082]
["TN","Tennessee",34373696,7333243.5500000007,2243.5966635650702,770.97574230499833,1531.311343932598,1379.6643470384818,1274.8186103977282,1410.5688149827336,1211.1079019954127]
["TX","Texas",164311070.40000001,160034168.27000007,2122.9492613999528,967.74711225166357,1279.0081154585625,1162.929822487381,1085.7279237657895,1187.6283788650196,1041.5207326409122]
["UTE","Lands of the Uintah and Ouray Reservation",3090433,0,2144.7457556918398,0,1670.9992669336505,1499.6596231999185,1379.5088493384344,1534,1305]
["UT","Utah",27452488,8486186.8000000007,2069.99689062791,884.48693881552185,1483.4041187370742,1338.5108915789021,1238.9141546297958,1368.2369837855013,1178.9067654436719]
["VA","Virginia",16015084,36291894.910000004,2402.676088999247,908.96173392102912,1119.7841989119897,1026.1526593151034,966.396277119356,1046.9347793024738,934.49739622153993]
["WA","Washington",7733957.1297229566,11728153.578537896,2431.8756280566308,994.79104579045713,1192.2470707242453,1088.400004166074,1020.7041600155579,1110.9644960122969,983.20376192388392]
["WI","Wisconsin",32160389,10244272.939999999,2362.0247080966587,846.4798869367105,1479.0711469485659,1334.7887648896979,1235.6667740251114,1364.4082788336927,1175.9943317623818]
["WV","West Virginia",70078372.819999993,0,2063.943941899307,0,1670.9992669336505,1499.6596231999185,1379.5088493384344,1534,1305]
["WY","Wyoming",42907427.019999996,483120.00000000006,2330.5399364401223,908,1662.1535922182672,1492.0609764629444,1372.8793871798607,1526.1837758845568,1299.0543252455175]
[]
["Data derived from EPA goal calculation TSD spreadsheet"]

{"sheet":"Test","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["State Rate with Calculated ERCs:",{"$f":"((NGCCGen*NGCCActualRate)+(FFSGen*FFSActualRate))/(NGCCGen+FFSGen-'State vs Performance'!G4)","v":1030.7673411741098}]
["NGCC Rate with Calculated ERCs:",{"$f":"(NGCCGen*NGCCActualRate)/(NGCCGen-NGCCERCs)","v":771.00000000000011}]
["FFS Rate with Calculated ERCs:",{"$f":"(FFSGen*FFSActualRate)/(FFSGen-FFSERCs)","v":1305}]
["FFS Rate with Calculated ERCs and GS_ERCs:",{"$f":"(FFSGen*FFSActualRate)/(FFSGen+(-PerfERCs+NGCCERCs+GSERCs))","v":1305}]