{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cost of Service","Restructured","State Estimate","maps"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Cost of Service","index":0,"n_rows":6,"n_cols":26,"rows_kept":6}
["COST OF SERVICE"]
["data source:",null,"IPM","IPM","IPM","IPM","IPM","IPM","IPM","IPM","calc","IPM","EIA","calc","calc","EIA","EIA","EIA","calc","EIA","calc","EIA","EIA","calc","EIA","calc"]
["EIA Region","IPM Region","Fuel Cost (Millions$)","VOM Cost (Millions$)","FOM Cost (Millions$)","Capital Cost (Millions$)","CCS Cost (Millions$)","Wholesale Costs - interregional transactions (Millions$)","REC transaction Cost (Millions$)","Allocated Allowance Costs (Millions$)","Total Costs for Generation of  Power (Millions$)","Net Energy For Load (GWh)","Distribution Loss Factor","Sales (GWh)","Average Cost of Power Sales (mills/kWh)","Utility Depreciation Costs  (mills/kWh)","Return (mills/kWh)","Final NUG Cost (mills/kWh)","Generation Cost Before Taxes (mills/kWh)","Assumed Tax Rates for Cost-of Service","Generation Cost After Taxes (mills/kWh)","Transmission Cost (mills/kWh)","Distribution Cost (mills/kWh)","Retail Rate (Generation + Transmission + Distribution) (mills/kWh)","Deregulated Share (%)","Final Average Price Weighted for Deregulated Share (mills/kWh)"]
["Region A","Region 1",{"v":1400,"d":"1,400"},255,457,203,0,-361,-8,0,{"$f":"C4+D4+E4+F4+H4+I4+G4+J4","v":{"v":1946,"d":"1,946"}},{"v":48050,"d":"48,050"},{"v":0.067,"d":"6.7%"},{"$f":"L4*(1-M4)","v":{"v":44830.65,"d":"44,831"}},{"$f":"IF(N4=0, 0, K4/N4*1000)","v":{"v":43.40780247442319,"d":"43.4"}},4,7,37,{"$f":"O4+P4+Q4+R4","v":{"v":91.40780247442319,"d":"91"}},0.07,{"$f":"S4*(1+T4)","v":{"v":97.80634864763282,"d":"97.8"}},9,18,{"$f":"MAX(U4,0)+V4+W4","v":{"v":124.80634864763282,"d":"125"}},{"v":0.63,"d":"63%"},{"$f":"(1-Y4)*X4","v":{"v":46.17834899962414,"d":"46.2"}}]
["Region B","Region 2",{"v":1610,"d":"1,610"},211,{"v":1092,"d":"1,092"},297,0,644,-51,0,{"$f":"C5+D5+E5+F5+H5+I5+G5+J5","v":{"v":3803,"d":"3,803"}},{"v":95980,"d":"95,980"},{"v":0.059,"d":"5.9%"},{"$f":"L5*(1-M5)","v":{"v":90317.18000000001,"d":"90,317"}},{"$f":"IF(N5=0, 0, K5/N5*1000)","v":{"v":42.10716056457918,"d":"42.1"}},7,9,0.15,{"$f":"O5+P5+Q5+R5","v":{"v":58.25716056457918,"d":"58"}},0.098,{"$f":"S5*(1+T5)","v":{"v":63.96636229990794,"d":"64.0"}},6,20,{"$f":"MAX(U5,0)+V5+W5","v":{"v":89.96636229990794,"d":"90"}},{"v":0,"d":"0%"},{"$f":"(1-Y5)*X5","v":{"v":89.96636229990794,"d":"90.0"}}]
["Region A","Region 3",{"v":4686,"d":"4,686"},848,{"v":2595,"d":"2,595"},296,0,-109,77,0,{"v":8393,"d":"8,393"},{"v":203600,"d":"203,600"},{"v":0.067,"d":"6.7%"},{"$f":"L6*(1-M6)","v":{"v":189958.80000000002,"d":"189,959"}},{"v":44.1832650027269,"d":"44.2"},4,7,37,{"$f":"O6+P6+Q6+R6","v":{"v":92.1832650027269,"d":"92"}},0.07,{"v":98.63609355291779,"d":"98.6"},9,18,{"v":125.63609355291779,"d":"126"},{"v":0.63,"d":"63%"},{"v":46.48535461457958,"d":"46.5"}]

{"sheet":"Restructured","index":1,"n_rows":6,"n_cols":18,"rows_kept":6}
["RESTRUCTURED"]
["data source:",null,"IPM","IPM","IPM input","IPM","EIA","calc","IPM input","IPM","calc","EIA","calc","EIA","EIA","calc","EIA","calc"]
["EIA Region","IPM Region","Energy Price (mills/kWh)","Capacity Price ($/kW)","Reserve Margin (%)","Load Factor","Distribution Loss Factor","Marginal Energy Cost and Capacity Cost (mills/kWh)","RPS Policy - Renewables Penetration as a Percentage of Sales (%)","RPS Policy - REC Price (mills/kWh)","RPS REC Cost (mills/kWh)","State/Local Taxes Rate (%)","Competitive Generation Cost (mills/kWh)","Transmission Cost (mills/kWh)","Distribution Cost (mills/kWh)","Final Average Price after T&D Addition (mills/kWh)","Deregulated Share (%)","Final Average Price Weighted for Deregulated Share (mills/kWh)"]
["Region A","Region 1",38,21,{"v":0.154,"d":"15.4%"},0.65,0.067,{"$f":"(C4+(D4*(1+E4)/(8.76*F4)))/(1-G4)","v":{"v":45.29052412592032,"d":"45.3"}},{"v":0.052,"d":"5.2%"},{"v":49.53,"d":"49.5"},{"$f":"I4*J4","v":{"v":2.57556,"d":"2.6"}},{"v":0.028,"d":"2.80%"},{"$f":"(H4+K4)*(1+L4)","v":{"v":49.20633448144609,"d":"49.2"}},{"v":9.11,"d":"9.1"},{"v":17.86,"d":"17.9"},{"$f":"M4+N4+O4","v":{"v":76.17633448144609,"d":"76.2"}},{"v":0.63,"d":"63%"},{"$f":"Q4*P4","v":{"v":47.99109072331104,"d":"48.0"}}]
["Region B","Region 2",40,17,{"v":0.154,"d":"15.4%"},0.62,0.059,{"$f":"(C5+(D5*(1+E5)/(8.76*F5)))/(1-G5)","v":{"v":46.3465388860426,"d":"46.3"}},{"v":0.035,"d":"3.5%"},{"v":117.49,"d":"117.5"},{"$f":"I5*J5","v":{"v":4.112150000000001,"d":"4.1"}},{"v":0.0144,"d":"1.44%"},{"$f":"(H5+K5)*(1+L5)","v":{"v":51.18529400600161,"d":"51.2"}},{"v":6.03,"d":"6.0"},{"v":19.85,"d":"19.9"},{"$f":"M5+N5+O5","v":{"v":77.06529400600161,"d":"77.1"}},{"v":0,"d":"0%"},{"$f":"Q5*P5","v":{"v":0,"d":"0.0"}}]
["Region A","Region 3",39,20,{"v":0.154,"d":"15.4%"},0.65,0.067,{"$f":"(C6+(D6*(1+E6)/(8.76*F6)))/(1-G6)","v":{"v":46.14511203948723,"d":"46.1"}},{"v":0.052,"d":"5.2%"},{"v":49.53,"d":"49.5"},{"v":2.57556,"d":"2.6"},{"v":0.028,"d":"2.80%"},{"$f":"(H6+K6)*(1+L6)","v":{"v":50.08485085659288,"d":"50.1"}},{"v":9.11,"d":"9.1"},{"v":17.86,"d":"17.9"},{"v":77.05485085659288,"d":"77.1"},{"v":0.63,"d":"63%"},{"v":48.544556039653514,"d":"48.5"}]

{"sheet":"State Estimate","index":2,"n_rows":9,"n_cols":7,"rows_kept":9}
["ESTIMATES BY MODEL REGION"]
["data source:",null,"RPM","RPM","RPM","IPM","IPM"]
["EIA Region","IPM Region","Cost of Service (mills/kWh)","Restructured (mills/kWh)","Average Electricity Price (mills/kWh)","Generation Total (GWh)","Generation Share"]
["Region A","Region 1",{"$f":"'Cost of Service'!Z4","v":{"v":46.17834899962414,"d":"46.2"}},{"$f":"Restructured!R4","v":{"v":47.99109072331104,"d":"48.0"}},{"$f":"C4+D4","v":{"v":94.16943972293518,"d":"94.2"}},9842,{"$f":"F4/SUM($F$4:$F$6)","v":{"v":0.12405778102705019,"d":"12.4%"}}]
["Region B","Region 2",{"$f":"'Cost of Service'!Z5","v":{"v":89.96636229990794,"d":"90.0"}},{"$f":"Restructured!R5","v":{"v":0,"d":"0.0"}},{"$f":"C5+D5","v":{"v":89.96636229990794,"d":"90.0"}},64063,{"$f":"F5/SUM($F$4:$F$6)","v":{"v":0.8075100209241939,"d":"80.8%"}}]
["Region A","Region 3",{"$f":"'Cost of Service'!Z6","v":{"v":46.48535461457958,"d":"46.5"}},{"$f":"Restructured!R6","v":{"v":48.544556039653514,"d":"48.5"}},{"v":95.02991065423309,"d":"95.0"},5429,{"$f":"F6/SUM($F$4:$F$6)","v":{"v":0.06843219804875589,"d":"6.8%"}}]
[]
["STATE-LEVEL ESTIMATE (mills/kWh)"]
["State X",{"$f":"E4*G4+E5*G5+E6*G6","v":{"v":90.83429650230623,"d":"90.8"}}]

{"sheet":"maps","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}