{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tool","Input-Output","Saved Portfolios","Compare","Warnings"],"not_rendered":{"charts":9,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Tool","index":0,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,3,36,15],[37,3,38,15],[39,3,40,15],[19,5,21,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,64.8,0.27480348563033596,12.924994598307665,39000,4600,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"'Input-Output'!P26","v":-1}]
[]
[null,null,null,{"$f":"'Input-Output'!P25","v":-1}]
[]
[null,null,null,{"$f":"'Input-Output'!P27","v":-1}]

{"sheet":"Input-Output","index":1,"n_rows":135,"n_cols":28,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[null,"Units","Biomass-\nand-Coal","Coal: \nCO2 released","Coal: \nCO2 captured","Coal-to-Gas:\nCO2 released","Coal-to-Gas: \nCO2 captured","Energy\nEfficiency","Natural Gas","Nuclear","Solar Cell","Wind",null,"Totals",null,null,null,null,"Other Assumptions/Calculations","Units",null,null,"NG Backup calculations","Units",null,"Backup for Solar","Backup for wind","Total"]
[]
["Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Assumptions",null,null,null,"Capacity Factor"]
["Number of plants","#",0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"Electricity Goal","TWh",60,null,"Best wind/PV Extreme","%",null,{"$f":"$U$13-K98","v":0.76},0.57000000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capital Charge Rate","%",0.09,null,"Base","%",null,0.79,0.62]
["Output",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission and Distribution","$/kWh",7.0999999999999994E-2,null,"Worst wind/PV Extreme","%",null,0.82000000000000006,0.66999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Residential Electricity Price (Take home)","$/kWh",0.11]
["Plants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent of electricity generation from new capacity","%",0.3,null,"Electricity generated/year","TWh",null,{"$f":"ROUND(I42*8760*Z5/1000000,1)","v":2.6},{"$f":"ROUND(I42*8760*AA5/1000000,1)","v":2.1}]
["NG Backup","#",0,0,0,0,0,0,{"$f":"AB11","v":0},0,0,0,null,null,null,null,null,null,"Average Household electricity use","kWh/month",700,null,"Electricity backup needed","TWh",null,{"$f":"Z5*K42*8760*K4/1000000","v":0},{"$f":"AA5*L42*8760*L4/1000000","v":0},{"$f":"Z9+AA9","v":0}]
["Total","#",{"$f":"C4+C9","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"Current electricity bill","$/month",{"$f":"U7*U9","v":77},null,"% of electricity goal","%",null,{"$f":"Z9/$U$4","v":0},{"$f":"AA9/$U$4","v":0},{"$f":"SUM(Z10:AA10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Living fron energy use","%",0.1,null,"Number of NG plants for backup","#",null,{"$f":"Z9/Z8","v":0},{"$f":"AA9/AA8","v":0},{"$f":"ROUNDUP(Z11+AA11,0)","v":0}]
["Electricity Generated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM emissions from IECM model are 37% PM10 ","%",0.37]
["Base","TWh",{"$f":"C4*C44","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"Availability of wind and solar","%",0.9,null,"NG Backup Cost Calculations"]
["NG Backup","TWh",0,0,0,0,0,0,{"$f":"AB9","v":0},0,0,0]
["Total","TWh",{"$f":"C14+C13","v":0},0,0,0,0,0,{"$f":"ROUND(I14+I13,1)","v":0},{"$f":"J14+J13","v":0},{"$f":"K14+K13","v":0},{"$f":"L14+L13","v":0},null,{"$f":"SUM(C15:L15)","v":0},null,null,null,null,null,null,null,null,"Annual Electricity Production"]
[null,null,{"$f":"C15&\" TWh\"","v":"0 TWh"},{"$f":"D15&\" TWh\"","v":"0 TWh"},"0 TWh","0 TWh","0 TWh","0 TWh","0 TWh","0 TWh","0 TWh","0 TWh",null,"0 TWh",null,null,null,null,"Original Plan Calculations",null,null,null,"Best wind/PV Extreme","kWh/kW",null,{"$f":"Z4*8760","v":6657.6},4993.2000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base","kWh/kW",null,6920.4000000000005,5431.2]
["Percent of Electricity Goal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 emissions for elec goal","kg",{"$f":"SUMPRODUCT(C39:L39,C47:L47)*U4","v":27762901184.726402},null,"Worst wind/PV Extreme","kWh/kW",null,7183.2000000000007,5869.2]
["Base","%",{"$f":"C13/$U$4","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"Water Use for elec goal","Pools/year",{"$f":"ROUND(SUMPRODUCT(C39:L39,C49:L49)*U4,-3)","v":56000}]
["NG Backup","%",null,null,null,null,null,null,{"$f":"I14/$U$4","v":0},null,null,null,null,null,null,null,null,null,"Land use for elec goal","football fields",{"$f":"ROUND(SUMPRODUCT(C39:L39,C48:L48)*U4,-2)","v":3500},null,"Annual Fuel Expenses"]
["Total","%",{"$f":"SUM(C19:C20)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C21:L21)","v":0},null,null,null,null,"Health costs for elec goal","$Millions",{"$f":"ROUND(SUMPRODUCT(C39:L39,C50:L50)*U4/1000000,-1)","v":830},null,"Best wind/PV Extreme","$/kW",null,{"$f":"($I88/1000000)*$I93*Z16","v":179.59541760000002},134.69656320000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base","$/kW",null,404.4835392,317.44277759999994]
["Impacts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Change from original plan",null,null,"Monthly electric bill increase",null,"Origin\nPlan",null,"Worst wind/PV Extreme","$/kW",null,839.68734719999998,686.08600319999994]
["CO2 emissions (% of original plan)","%",{"$f":"(C15*C47)/$U$18","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C24:L24)","v":0}]
["Land use","football fields",{"$f":"C15*C48","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUNDUP(SUM(C25:L25),-2)","v":0},null,{"$f":"(N25-U20)/U20","v":-1},null,null,"Best","$/kWh",{"$f":"U28/700","v":7.6520705315433332E-3},null,"LCOE"]
["Water use","Pools/yr",{"$f":"C15*C49","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUNDUP(SUM(C26:L26),-3)","v":0},null,{"$f":"(N26-$U$19)/$U$19","v":-1},null,null,"Base","$/kWh",{"$f":"U29/700","v":1.3441973236525526E-2},null,"Best wind/PV Extreme","$/kWh",null,{"$f":"($I$114+Z21)/Z16","v":4.4481779110825105E-2},5.0317038814433467E-2]
["Health costs","$Millions",{"$f":"C15*C50/1000000","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUNDUP(SUM(C27:L27),-1)","v":0},null,{"$f":"(N27-U21)/U21","v":-1},null,null,"Worst","$/kWh",2.5511023425461982E-2,null,"Base","$/kWh",null,7.5289002688895032E-2,7.9906696974559793E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Best","$",{"$f":"SUMPRODUCT($C$39:$L$39,C133:L133)*$U$9","v":5.3564493720803332},null,"Worst wind/PV Extreme","$/kWh",null,0.13312086844417934,0.13675330167795086]
["Increased electricity bill cost",null,null,null,null,null,null,null,null,null,null,null,null,"Your\nCombination","cost/kWh","% increase from current",null,null,"Base","$",{"$f":"SUMPRODUCT($C$39:$L$39,C134:L134)*$U$9","v":9.4093812655678679}]
["Best Extreme","$",{"$f":"C133*C$19*$U$9","v":0},0,0,0,0,0,{"$f":"I133*I$19*$U$9+AB47","v":0},{"$f":"J133*J$19*$U$9","v":0},0,0,null,{"$f":"SUM(C30:L30)","v":0},{"$f":"N30/700","v":0},null,null,null,"Worst","$",{"$f":"SUMPRODUCT($C$39:$L$39,C135:L135)*$U$9","v":17.857716397823388},null,"LCOE+T&D"]
["Base","$",0,0,0,0,0,0,{"$f":"I134*I$19*$U$9+AB48","v":0},0,0,0,null,{"$f":"SUM(C31:L31)","v":0},{"$f":"N31/700","v":0},{"$f":"N31/U10","v":0},null,null,null,null,null,null,"Best wind/PV Extreme","$/kWh",null,{"$f":"Z26+$U$6","v":0.11548177911082511},0.12131703881443345]
["Worst Extreme","$",0,0,0,0,0,0,{"$f":"I135*I$19*$U$9+AB49","v":0},0,0,0,null,{"$f":"SUM(C32:L32)","v":0},{"$f":"N32/700","v":0},null,null,null,"Energy Efficiency Assumptions",null,null,null,"Base","$/kWh",null,0.14628900268889503,0.15090669697455977]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Of living increase",null,null,"Energy Efficiency supply curve - tipping point","% of electricity saved",0.15,null,"Worst wind/PV Extreme","$/kWh",null,0.20412086844417932,0.20775330167795086]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31*U11","v":0},null,null,{"$f":"\"less than \" &U33","v":"less than 0.15"},"multiplier",{"$f":"2/15","v":0.13333333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"greater than \" &U33","v":"greater than 0.15"},"multiplier",3,null,"Increase in LCOE from current"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S35","v":"greater than 0.15"},"shift ($/kWh)",0.41,null,"Best wind/PV Extreme","$/kWh",null,{"$f":"Z31*$U$8+$U$7*(1-$U$8)-$U$7","v":1.6445337332475357E-3},3.3951116443300261E-3]
["Assumptions and Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base","$/kWh",null,1.0886700806668495E-2,1.2272009092367933E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst wind/PV Extreme","$/kWh",null,2.8236260533253774E-2,2.932599050338526E-2]
["Original Plan","%",0,0.5,0,0,0,0,0.14000000000000001,0.35,0,0.01,null,null,null,null,null,null,"Biomass Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent of Biomass co-fired","%",0.1,null,"Increase in electricity bill cost"]
["Basic Plant Info",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Best wind/PV Extreme","$",null,{"$f":"Z36*$U$9*Z$10","v":0},0]
["Average Nameplate capacity","MW",533,761,761,761,761,null,381,888,105,205,null,null,null,null,null,null,"Biomass fuel price (demand curve-exponential function based on # of plants)",null,null,null,"Base","$",null,0,0]
["Capacity Factor","%",0.75,0.75,0.75,0.75,0.75,null,0.75,0.9,0.11,0.28000000000000003,null,null,null,null,null,null,"# of plants",null,null,null,"Worst wind/PV Extreme","$",null,0,0]
["Electricity Generation","TWh",{"$f":"ROUND(C42*8760*C43/1000000,1)","v":3.5},{"$f":"ROUND(D42*8760*D43/1000000,1)","v":5},{"$f":"ROUND(E42*8760*E43/1000000,1)","v":5},{"$f":"ROUND(F42*8760*F43/1000000,1)","v":5},{"$f":"ROUND(G42*8760*G43/1000000,1)","v":5},0.5,{"$f":"ROUND(I42*8760*I43/1000000,1)","v":2.5},{"$f":"ROUND(J42*8760*J43/1000000,1)","v":7},{"$f":"ROUND(K42*8760*K43/1000000,1)","v":0.1},{"$f":"ROUND(L42*8760*L43/1000000,1)","v":0.5},null,null,null,null,null,null,1,"$/MMBtu",{"$f":"2.1314*EXP(0.4812*S44)","v":3.4486368630439541}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"$/MMBtu",{"$f":"2.1314*EXP(0.4812*S45)","v":5.5799456756806061}]
["Impacts per TWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"$/MMBtu",{"$f":"2.1314*EXP(0.4812*S46)","v":9.0284349962160277}]
["CO2 emissions","kg/TWh",779521167.46350002,820548597.33000004,136213788.711,849578509.01000011,92442125.005999997,0,374576579.14600003,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z41+AA41","v":0}]
["Land Use","football fields/TWh",1157.3461808136487,77.409829938329281,112.54344982246309,77.409829938329281,112.54344982246309,0,49.149691646421232,21.678190992337882,78.490001868809557,450.38310596150251,null,null,null,null,null,null,"Reduction in emissions from 10% biomass co-fire w/ PC plants",null,null,null,null,null,null,null,null,{"$f":"Z42+AA42","v":0}]
["Water use","olympic pools/yr-TWh",1136.5920000000001,1136.5920000000001,2003.9858545130953,1092.5600000000002,1479.2325751633987,0,207.78897516287998,957.88,6,1.6,null,null,null,null,null,null,"CO2","%",-0.04,null,null,null,null,null,null,{"$f":"Z43+AA43","v":0}]
["Health costs from air pollution","$/TWh",{"$f":"SUM(C68:C71)","v":25590190.654753599},27646521.203528088,1882936.0288163873,3368315.377580551,650674.92438376765,0,140831.10737073296,0,0,0,null,null,null,null,null,null,"Nox","%",-0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SO2","%",-7.4999999999999997E-2]
["Health Cost Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PM ","%",-7.4999999999999997E-2]
[]
["Emissions"]
["NOx ","tons/MWh",{"$f":"D55*(1+U50)","v":4.1973374999999997E-4},4.4182499999999997E-4,7.1798000000000001E-4,9.1249999999999995E-5,1.0215E-4,0,9.4099999999999997E-5,0,0,0]
["SOx ","tons/MWh",{"$f":"D56*(1+U51)","v":2.4378375000000002E-3},2.6354999999999998E-3,9.1950000000000005E-7,3.1980000000000002E-4,4.2030000000000002E-5,0,0,0,0,0]
["PM (all)","tons/MWh",{"$f":"D57*(1+U52)","v":6.0587500000000009E-5},6.5500000000000006E-5,5.435E-5,4.7330000000000003E-6,5.49E-6,0,0,0,0,0]
["PM10","tons/MWh",{"$f":"C57*$U$12","v":2.2417375000000002E-5},2.4235000000000001E-5,2.0109500000000001E-5,1.7512100000000001E-6,2.0312999999999999E-6,0,0,0,0,0]
["PM2.5","tons/MWh",{"$f":"C57*(1-$U$12)","v":3.8170125000000004E-5},4.1265000000000006E-5,3.4240499999999999E-5,2.9817900000000001E-6,3.4587E-6,0,0,0,0,0]
[]
["Health Damages per ton"]
["NOx emissions","$/ton",1553.4242281556035,1553.4242281556035,1553.4242281556035,1553.4242281556035,1553.4242281556035,0,1496.6111304009878,0,0,0]
["SOx emissions","$/ton",9882.7722434626194,9882.7722434626194,9882.7722434626194,9882.7722434626194,9882.7722434626194,0,10805.48099164719,0,0,0]
["PM10 emissions","$/ton",969.87692119683879,969.87692119683879,969.87692119683879,969.87692119683879,969.87692119683879,0,1567.2277201196921,0,0,0]
["PM2.5 emissions","$/ton",21583.141381129233,21583.141381129233,21583.141381129233,21583.141381129233,21583.141381129233,0,34789.575616379145,0,0,0]
[]
["Health Damages per TWh"]
["NOx emissions","$/TWh",{"$f":"C62*C55*1000000","v":652024.57662460697},686341.65960484953,1115327.5273311601,141749.96081919881,158682.28490609489,0,140831.10737073296,0,0,0]
["SOx emissions","$/TWh",{"$f":"C63*C56*1000000","v":24092592.779072303},26046046.247645732,9087.2090778638794,3160510.5634593456,415372.91739273391,0,0,0,0,0]
["PM10 emissions","$/TWh",{"$f":"C64*C58*1000000","v":21742.094646314985},23504.967185205387,19503.739946807829,1698.4581631691162,1970.1109900271385,0,0,0,0,0]
["PM2.5 emissions","$/TWh",{"$f":"C65*C59*1000000","v":823831.20441037556},890628.32909229794,739017.55246055545,64356.395138837339,74649.611094911685,0,0,0,0,0]
[]
["Cost Assumptions/Calcs"]
[]
["Technology Lifetime","Years",20,20,20,20,20,20,20,20,20,20]
[]
["Technology Capital Costs ($2008)"]
["Best Extreme","$/kW",{"$f":"D78+50","v":2600},2550,4000,3750,4400,null,900,5750,3500,1900]
["Base","$/kW",{"$f":"AVERAGE(C78,C80)","v":3050},{"$f":"0.5*(D78+D80)","v":2775},{"$f":"0.5*(E78+E80)","v":4675},{"$f":"0.5*(F78+F80)","v":4075},{"$f":"0.5*(G78+G80)","v":4737.5},null,{"$f":"0.5*(I78+I80)","v":1000},{"$f":"0.5*(J78+J80)","v":6650},{"$f":"0.5*(K78+K80)","v":3750},{"$f":"0.5*(L78+L80)","v":2200}]
["Worst Extreme","$/kW",{"$f":"D80+500","v":3500},3000,5350,4400,5075,null,1100,7550,4000,2500]
[]
["Technology Non-fixed O&M Costs"]
["Best Extreme","$/kW",{"$f":"D83+3","v":23},20,32,26,30,null,7,71,25,40]
["Base","$/kW",{"$f":"D84+3","v":23},20,32,26,30,null,7,71,25,{"$f":"0.5*(L83+L85)","v":45}]
["Worst Extreme","$/kW",{"$f":"D85+3","v":23},20,32,26,30,null,7,71,25,50]
[]
["Fuel Costs"]
["Best Extreme","$/MMBtu",{"$f":"IF($C$4=2,$U$45, IF($C$4=3,$U$46,$U$44))*0.1+D88*0.9","v":1.6948636863043955},1.5,1.5,1.5,1.5,null,3,0.4]
["Base","$/MMBtu",{"$f":"IF($C$4=2,$U$45, IF($C$3=3,$U$46,$U$44))*0.1+D89*0.9","v":2.2798636863043953},2.15,2.15,2.15,2.15,null,6.5,0.5]
["Worst Extreme","$/MMBtu",{"$f":"IF($C$4=2,$U$45, IF($C$3=3,$U$46,$U$44))*0.1+D90*0.9","v":4.8448636863043957},5,5,5,5,null,13,0.6]
[]
["Technology Heat Rate"]
["Best Extreme","Btu/kWh",10995,9200,12680,8765,10781,null,{"$f":"(7196+10788)/2","v":8992},10488]
["Base","Btu/kWh",10995,9200,12680,8765,10781,null,{"$f":"(7196+10788)/2","v":8992},10488]
["Worst Extreme","Btu/kWh",10995,9200,12680,8765,10781,null,{"$f":"(7196+10788)/2","v":8992},10488]
[]
["Capacity Factor"]
["Best Extreme","%",{"$f":"C99+0.1","v":0.85},{"$f":"D99+0.1","v":0.85},{"$f":"E99+0.1","v":0.85},{"$f":"F99+0.1","v":0.85},{"$f":"G99+0.1","v":0.85},null,{"$f":"I99+0.15","v":0.9},{"$f":"J99+0.05","v":0.95000000000000007},{"$f":"K99+0.03","v":0.14000000000000001},{"$f":"L99+0.05","v":0.33}]
["Base","%",{"$f":"C43","v":0.75},{"$f":"D43","v":0.75},{"$f":"E43","v":0.75},{"$f":"F43","v":0.75},{"$f":"G43","v":0.75},null,{"$f":"I43","v":0.75},{"$f":"J43","v":0.9},{"$f":"K43","v":0.11},{"$f":"L43","v":0.28000000000000003}]
["Worst Extreme","%",{"$f":"C99-0.1","v":0.65},{"$f":"D99-0.1","v":0.65},{"$f":"E99-0.1","v":0.65},{"$f":"F99-0.1","v":0.65},{"$f":"G99-0.1","v":0.65},null,{"$f":"I99-0.35","v":0.4},{"$f":"J99-0.1","v":0.8},{"$f":"K99-0.03","v":0.08},{"$f":"L99-0.05","v":0.23000000000000004}]
[]
["Annual Electricity Production"]
["Best Extreme","kWh/kW",{"$f":"C98*8760","v":7446},7446,7446,7446,7446,null,{"$f":"I98*8760","v":7884},8322,1226.4000000000001,2890.8]
["Base","kWh/kW",6570,6570,6570,6570,6570,null,6570,7884,963.6,2452.8000000000002]
["Worst Extreme","kWh/kW",5694,5694,5694,5694,5694,null,3504,7008,700.80000000000007,2014.8000000000004]
[]
["Intermittency Charges"]
["Best Extreme","$/kWh",null,null,null,null,null,null,null,null,5.0000000000000001E-3,5.0000000000000001E-3]
["Base","$/kWh",null,null,null,null,null,null,null,null,0.01,0.01]
["Worst Extreme","$/kWh",null,null,null,null,null,null,null,null,0.03,0.03]
[]
["Annualized Capital, O&M, and Intermittency Expenses"]
["Best Extreme","$/kW",{"$f":"-PMT($U$5,C$75,C78)+C83+(C108*C103)","v":307.82083502139596},299.34351127098449,470.18590003291689,436.79928128085953,512.00449003620861,0,105.59182750740629,700.89223129731795,414.54466252880229,262.59230251563554]
["Base","$/kW",{"$f":"-PMT($U$5,C$75,C79)+C84+(C109*C104)","v":357.1167487750991},323.99146814783609,544.12977066347162,472.40188565853401,548.97642535148589,0,116.54647500822922,799.48405880472433,445.43528128085956,310.53024501810432]
["Worst Extreme","$/kW",{"$f":"-PMT($U$5,C$75,C80)+C85+(C110*C105)","v":406.41266252880229},348.63942502468763,618.07364129402629,508.00449003620861,585.94836066676328,0,127.50112250905215,898.07588631213059,484.20990003291689,384.31018752057304]
[]
["Annualized fuel expenses"]
["Best Extreme","$/kW",{"$f":"(C88/1000000)*C93*C103","v":138.75640531540671},102.7548,141.62292000000002,97.896285000000006,120.41298900000001,0,212.67878400000001,34.912454400000001,0,0]
["Base","$/kW",{"$f":"(C89/1000000)*C94*C104","v":164.69085508712357},129.9546,179.11133999999998,123.81000749999998,152.28701549999997,0,384.00335999999993,41.343695999999994,0,0]
["Worst Extreme","$/kW",{"$f":"(C90/1000000)*C95*C105","v":303.31525885884042},261.92400000000004,360.99960000000004,249.53955000000002,306.93507,0,409.60358399999996,44.099942399999996,0,0]
[]
["LCOE"]
["Best Extreme","$/kWh",{"$f":"(C118+C113)/C103","v":5.9975455323234311E-2},5.4001922007921636E-2,8.2166105295852387E-2,7.1809772533019012E-2,8.4933854289042252E-2,{"$f":"H124*0.75","v":0},{"$f":"(I118+I113)/I103","v":4.0369179541781625E-2},8.841680914411415E-2,0.33801750043118256,9.083724315609365E-2]
["Base","$/kWh",7.9422770755285033E-2,6.9093769885515383E-2,0.11008236083157862,9.0747624529457227E-2,0.10673720560905416,{"$f":"IF(H21<U33,H21*U34,H21*U35-U36)","v":0},7.6187189498969424E-2,0.10664989279613449,0.46226160365386004,0.12660235038246262]
["Worst Extreme","$/kWh",0.12464487555104369,0.10722926326390721,0.17194823345522064,0.13304250790941494,0.1568112804121467,{"$f":"H124*1.25","v":0},0.15328330665212675,0.13444289793266703,0.69093878429354572,0.19074359118551368]
[]
["LCOE+T&D"]
["Best Extreme","$/kWh",{"$f":"C123+$U$6","v":0.13097545532323429},0.12500192200792162,0.15316610529585239,0.14280977253301902,0.15593385428904225,{"$f":"H123","v":0},{"$f":"I123+$U$6","v":0.11136917954178162},0.15941680914411416,0.40901750043118257,0.16183724315609366]
["Base","$/kWh",0.15042277075528504,0.14009376988551536,0.18108236083157861,0.16174762452945723,0.17773720560905415,{"$f":"H124","v":0},0.14718718949896942,0.17764989279613447,0.53326160365385999,0.1976023503824626]
["Worst Extreme","$/kWh",0.19564487555104368,0.1782292632639072,0.24294823345522065,0.20404250790941492,0.22781128041214671,{"$f":"H125","v":0},0.22428330665212676,0.20544289793266701,0.76193878429354567,0.26174359118551366]
[]
["Increase in LCOE from current"]
["Best Extreme","$/kWh",{"$f":"C128*$U$8+$U$7*(1-$U$8)-$U$7","v":6.292636596970283E-3},4.5005766023764743E-3,1.294983158875572E-2,9.842931759905707E-3,1.3780156286712669E-2,-3.3000000000000002E-2,4.1075386253448809E-4,1.4825042743234249E-2,8.9705250129354749E-2,1.5551172946828104E-2]
["Base","$/kWh",{"$f":"C129*$U$8+$U$7*(1-$U$8)-$U$7","v":1.2126831226585519E-2},9.0281309656546072E-3,2.1324708249473565E-2,1.5524287358837166E-2,2.0321161682716235E-2,-3.3000000000000002E-2,1.1156156849690832E-2,2.0294967838840342E-2,0.126978481096158,2.6280705114738775E-2]
["Worst Extreme","$/kWh",{"$f":"C130*$U$8+$U$7*(1-$U$8)-$U$7","v":2.5693462665313097E-2},2.0468778979172167E-2,3.9884470036566186E-2,2.8212752372824487E-2,3.5343384123644003E-2,-3.3000000000000002E-2,3.4284991995638017E-2,2.8632869379800099E-2,0.19558163528806372,4.5523077355654099E-2]

{"sheet":"Saved Portfolios","index":2,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[null,"CANNED PORTFOLIOS ***Scenarios do not include NG backup","Biomass-and-Coal","Coal Option 1: \nNo CO2 capture","Coal Option 2: \nCO2 Capture","Coal-to-Gas Option 1:\nNo CO2 capture","Coal-to-Gas Option 2: \nCO2 Capture","Energy Efficiency","Natural Gas","Nuclear","Solar Cell","Wind","Natural Gas Backup (Solar)","NG Backup Wind","Total","Chosen"]
[]
[1,"Least Expensive, full portfolio",0,2,0,0,2,18,0,2,0,11,null,null,null,7]
[2,"full portfolio, no PC",0,0,0,0,3,18,0,3,0,10]
[3,"Zero CO2 with EE, least land, least water, least health cost",0,0,0,0,0,22,0,7,0,0]
[4,"Least CO2 emissions with no Nuclear",0,0,0,0,10,20,0,0,0,0]
[5,"Least CO2 (no nuc, no coal), least water, Maximize wind and EE",0,0,0,0,0,23,0,0,0,30]
[6,"Limited Portfolio",0,0,0,0,0,24,0,0,25,17]
[7,"semi-limited, no CCS",0,2,0,0,0,18,0,3,0,13]
[8,"semi-limited, no nuc",0,1,0,0,5,18,0,0,0,13]
[]
[]
[null,"SAVED PORTFOLIOS"]
[null,"These portfolios do not include NG backup"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('Input-Output'!$Z$5*'Input-Output'!$K$42*8760*K15/1000000)","v":0},{"$f":"('Input-Output'!$AA$5*'Input-Output'!$L$42*8760*L15/1000000)","v":0},{"$f":"SUM(M15:N15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('Input-Output'!$Z$5*'Input-Output'!$K$42*8760*K16/1000000)","v":0},{"$f":"('Input-Output'!$AA$5*'Input-Output'!$L$42*8760*L16/1000000)","v":0},{"$f":"SUM(M16:N16)","v":0},2]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('Input-Output'!$Z$5*'Input-Output'!$K$42*8760*K17/1000000)","v":0},{"$f":"('Input-Output'!$AA$5*'Input-Output'!$L$42*8760*L17/1000000)","v":0},0]
[]
[]
[]
[]
[]
[]
[null,"These portfolios are same as above, but include NG backup and are in percentages"]
[null,{"$f":"IF(B15 = \"\", \"\",B15)","v":""},{"$f":"(C15*'Input-Output'!C$44)/'Input-Output'!$U$4","v":0},{"$f":"(D15*'Input-Output'!D$44)/'Input-Output'!$U$4","v":0},{"$f":"(E15*'Input-Output'!E$44)/'Input-Output'!$U$4","v":0},{"$f":"(F15*'Input-Output'!F$44)/'Input-Output'!$U$4","v":0},{"$f":"(G15*'Input-Output'!G$44)/'Input-Output'!$U$4","v":0},{"$f":"(H15*'Input-Output'!H$44)/'Input-Output'!$U$4","v":0},{"$f":"((I15*'Input-Output'!I$44)+O15)/'Input-Output'!$U$4","v":0},{"$f":"(J15*'Input-Output'!J$44)/'Input-Output'!$U$4","v":0},{"$f":"(K15*'Input-Output'!K$44)/'Input-Output'!$U$4","v":0},{"$f":"(L15*'Input-Output'!L$44)/'Input-Output'!$U$4","v":0}]
[null,{"$f":"IF(B16 = \"\", \"\",B16)","v":""},{"$f":"(C16*'Input-Output'!C$44)/'Input-Output'!$U$4","v":0},{"$f":"(D16*'Input-Output'!D$44)/'Input-Output'!$U$4","v":0},{"$f":"(E16*'Input-Output'!E$44)/'Input-Output'!$U$4","v":0},{"$f":"(F16*'Input-Output'!F$44)/'Input-Output'!$U$4","v":0},{"$f":"(G16*'Input-Output'!G$44)/'Input-Output'!$U$4","v":0},{"$f":"(H16*'Input-Output'!H$44)/'Input-Output'!$U$4","v":0},{"$f":"((I16*'Input-Output'!I$44)+O16)/'Input-Output'!$U$4","v":0},{"$f":"(J16*'Input-Output'!J$44)/'Input-Output'!$U$4","v":0},{"$f":"(K16*'Input-Output'!K$44)/'Input-Output'!$U$4","v":0},{"$f":"(L16*'Input-Output'!L$44)/'Input-Output'!$U$4","v":0}]
[null,"",{"$f":"(C17*'Input-Output'!C$44)/'Input-Output'!$U$4","v":0},{"$f":"(D17*'Input-Output'!D$44)/'Input-Output'!$U$4","v":0},{"$f":"(E17*'Input-Output'!E$44)/'Input-Output'!$U$4","v":0},{"$f":"(F17*'Input-Output'!F$44)/'Input-Output'!$U$4","v":0},{"$f":"(G17*'Input-Output'!G$44)/'Input-Output'!$U$4","v":0},{"$f":"(H17*'Input-Output'!H$44)/'Input-Output'!$U$4","v":0},{"$f":"((I17*'Input-Output'!I$44)+O17)/'Input-Output'!$U$4","v":0},{"$f":"(J17*'Input-Output'!J$44)/'Input-Output'!$U$4","v":0},{"$f":"(K17*'Input-Output'!K$44)/'Input-Output'!$U$4","v":0},{"$f":"(L17*'Input-Output'!L$44)/'Input-Output'!$U$4","v":0}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Compare","index":3,"n_rows":13,"n_cols":36,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[12,1,12,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Values"]
[null,"                                  Your Combinations (Percent of Each Power Plant Type)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity Produced","CO2 Released","Cost","Water Use","Land Use","Health Costs"]
[null,null,null,{"$f":"AD3","v":""},{"$f":"AD4","v":""},{"$f":"AD5","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B15=\"\",\"\",'Saved Portfolios'!B15)","v":""}]
[null,"Biomass-and-Coal",null,{"$f":"'Saved Portfolios'!$C$25","v":0},{"$f":"'Saved Portfolios'!$C$26","v":0},{"$f":"'Saved Portfolios'!$C$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B16=\"\",\"\",'Saved Portfolios'!B16)","v":""}]
[null,"Coal:  CO2 released to air",null,{"$f":"'Saved Portfolios'!$D$25","v":0},{"$f":"'Saved Portfolios'!$D$26","v":0},{"$f":"'Saved Portfolios'!$D$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B17=\"\",\"\",'Saved Portfolios'!B17)","v":""}]
[null,"Coal:  CO2 captured",null,{"$f":"'Saved Portfolios'!$E$25","v":0},{"$f":"'Saved Portfolios'!$E$26","v":0},{"$f":"'Saved Portfolios'!$E$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B18=\"\",\"\",'Saved Portfolios'!B18)","v":""}]
[null,"Coal-to-Gas: CO2 released to air",null,{"$f":"'Saved Portfolios'!$F$25","v":0},{"$f":"'Saved Portfolios'!$F$26","v":0},{"$f":"'Saved Portfolios'!$F$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B19=\"\",\"\",'Saved Portfolios'!B19)","v":""}]
[null,"Coal-to-Gas: CO2 captured",null,{"$f":"'Saved Portfolios'!$G$25","v":0},{"$f":"'Saved Portfolios'!$G$26","v":0},{"$f":"'Saved Portfolios'!$G$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B20=\"\",\"\",'Saved Portfolios'!B20)","v":""}]
[null,"Energy Efficiency",null,{"$f":"'Saved Portfolios'!$H$25","v":0},{"$f":"'Saved Portfolios'!$H$26","v":0},{"$f":"'Saved Portfolios'!$H$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B21=\"\",\"\",'Saved Portfolios'!B21)","v":""}]
[null,"Natural Gas",null,{"$f":"'Saved Portfolios'!$I$25","v":0},{"$f":"'Saved Portfolios'!$I$26","v":0},{"$f":"'Saved Portfolios'!$I$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saved Portfolios'!B22=\"\",\"\",'Saved Portfolios'!B22)","v":""}]
[null,"Nuclear",null,{"$f":"'Saved Portfolios'!$J$25","v":0},{"$f":"'Saved Portfolios'!$J$26","v":0},{"$f":"'Saved Portfolios'!$J$27","v":0}]
[null,"Solar Cell",null,{"$f":"'Saved Portfolios'!$K$25","v":0},{"$f":"'Saved Portfolios'!$K$26","v":0},{"$f":"'Saved Portfolios'!$K$27","v":0}]
[null,"Wind",null,{"$f":"'Saved Portfolios'!$L$25","v":0},{"$f":"'Saved Portfolios'!$L$26","v":0},{"$f":"'Saved Portfolios'!$L$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"current values",{"$f":"'Input-Output'!N15","v":0},{"$f":"'Input-Output'!N24","v":0},{"$f":"'Input-Output'!N31","v":0},{"$f":"'Input-Output'!N26","v":0},{"$f":"'Input-Output'!N25","v":0},{"$f":"'Input-Output'!N27","v":0}]

{"sheet":"Warnings","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Warnings",1]