{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary (Testimony Insert)","RCS-14 P1","RCS-14 P2","ROR"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Summary (Testimony Insert)","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Puget Sound Electric Settlement Agreement Revenue Change at Various Return on Equity Rates"]
[null,null,null,null,null,"PSE Electric",null,null,"PSE Gas"]
[null,null,null,null,null,null,"Change From",null,null,"Change From"]
[null,"Return on",null,null,null,"Revenue","Settlement",null,"Revenue","Settlement"]
[null,"Equity Used",null,"Note",null,"Requirement","Agreement",null,"Requirement","Agreement"]
[null,null,null,null,null,"(A)","(B)",null,"(C)","(D)"]
[null,9.5000000000000001E-2,null,"[1]",null,{"$f":"'RCS-14 P1'!G50","v":20160333.927101493},{"$f":"F10-F10","v":0},null,{"$f":"'RCS-14 P2'!G37","v":-35465639.42336645},{"$f":"I10-I10","v":0}]
[null,9.4E-2,null,null,null,{"$f":"'RCS-14 P1'!H50","v":15987386.728828281},{"$f":"F11-F10","v":-4172947.1982732117},null,{"$f":"'RCS-14 P2'!H37","v":-36888346.312686563},{"$f":"I11-I10","v":-1422706.8893201128}]
[null,9.2999999999999999E-2,null,null,null,{"$f":"'RCS-14 P1'!I50","v":11814439.530555069},{"$f":"F12-F10","v":-8345894.3965464234},null,{"$f":"'RCS-14 P2'!I37","v":-38311053.202006683},{"$f":"I12-I10","v":-2845413.778640233}]
[null,9.1999999999999998E-2,null,"[2]",null,{"$f":"'RCS-14 P1'!J50","v":7641492.3322818577},{"$f":"F13-F10","v":-12518841.594819635},null,{"$f":"'RCS-14 P2'!J37","v":-39733760.091326796},{"$f":"I13-I10","v":-4268120.6679603457}]
[null,9.0999999999999998E-2,null,"[3]",null,{"$f":"'RCS-14 P1'!K50","v":3468545.1340086311},{"$f":"F14-F10","v":-16691788.793092862},null,{"$f":"'RCS-14 P2'!K37","v":-41156466.980646916},{"$f":"I14-I10","v":-5690827.557280466}]
[null,8.8499999999999995E-2,null,"[4]",null,{"$f":"'RCS-14 P1'!L50","v":-6546528.1418470591},{"$f":"F15-F10","v":-26706862.068948552},null,{"$f":"'RCS-14 P2'!L37","v":-44570963.51501517},{"$f":"I15-I10","v":-9105324.0916487202}]
[]
[null,"Notes"]
[null,"[1] Settlement Agreement",null,null,null,null,"[3] ICNU witness Gorman"]
[null,"[2] Staff witness Parcell",null,null,null,null,"[4] PCU witness Woolridge"]

{"sheet":"RCS-14 P1","index":1,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Puget Sound Energy",null,null,null,null,null,null,null,null,null,null,"Exhibit RCS-14"]
["Electric Restating and Pro Forma Adjustments",null,null,null,null,null,null,null,null,null,null,"Docket Nos. UE-170033 & UG-170034"]
[null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 2"]
[]
[null,"Exhibit A to the Multiparty Settlement Stipulation and Agreement",null,null,null,null,"Recalculated Using Indicated ROE"]
["Line No.","Adjustment\n","NOI\n","Rate Base\n","Revenue Requirement \n(Note 1)",null,"Revenue Requirement @ 9.50 % ROE","Revenue Requirement @ 9.40 % ROE","Revenue Requirement @ 9.30 % ROE","Revenue Requirement @ 9.20 % ROE","Revenue Requirement @ 9.10 % ROE","Revenue Requirement @ 8.85 % ROE"]
[null,null,"(A)","(B)","(C)",null,"(D)","(E)","(F)","(G)","(H)","(I)"]
[1,"Actual Results of Operations",401002971.69877887,5153204461.5858841,-15119000.88724787,null,{"$f":"(D8*ROR!$H$10-C8)/0.619051","v":-15119000.88724787},{"$f":"(D8*ROR!$H$17-C8)/0.619051","v":-19281181.75892555},{"$f":"(D8*ROR!$H$24-C8)/0.619051","v":-23443362.630603231},{"$f":"(D8*ROR!$H$31-C8)/0.619051","v":-27605543.50228091},{"$f":"(D8*ROR!$H$38-C8)/0.619051","v":-31767724.373958591},{"$f":"(D8*ROR!$H$45-C8)/0.619051","v":-41756958.465985022}]
[{"$f":"A8+1","v":2},"Adjustment 13.01-Revenues & Expenses",-29139113.529240973,0,47070618.623087555,null,{"$f":"(D9*ROR!$H$10-C9)/0.619051","v":47070618.623087555},{"$f":"(D9*ROR!$H$17-C9)/0.619051","v":47070618.623087555},{"$f":"(D9*ROR!$H$24-C9)/0.619051","v":47070618.623087555},{"$f":"(D9*ROR!$H$31-C9)/0.619051","v":47070618.623087555},{"$f":"(D9*ROR!$H$38-C9)/0.619051","v":47070618.623087555},{"$f":"(D9*ROR!$H$45-C9)/0.619051","v":47070618.623087555}]
[{"$f":"A9+1","v":3},"Adjustment 13.02-Temperature Normalization",17527344,0,-28313247.212265223,null,{"$f":"(D10*ROR!$H$10-C10)/0.619051","v":-28313247.212265223},{"$f":"(D10*ROR!$H$17-C10)/0.619051","v":-28313247.212265223},{"$f":"(D10*ROR!$H$24-C10)/0.619051","v":-28313247.212265223},{"$f":"(D10*ROR!$H$31-C10)/0.619051","v":-28313247.212265223},{"$f":"(D10*ROR!$H$38-C10)/0.619051","v":-28313247.212265223},{"$f":"(D10*ROR!$H$45-C10)/0.619051","v":-28313247.212265223}]
[4,"Adjustment 13.03-Pass-Through Revs. & Exps.",-1000540.3107059002,0,1616248.5977825739,null,{"$f":"(D11*ROR!$H$10-C11)/0.619051","v":1616248.5977825739},{"$f":"(D11*ROR!$H$17-C11)/0.619051","v":1616248.5977825739},{"$f":"(D11*ROR!$H$24-C11)/0.619051","v":1616248.5977825739},{"$f":"(D11*ROR!$H$31-C11)/0.619051","v":1616248.5977825739},{"$f":"(D11*ROR!$H$38-C11)/0.619051","v":1616248.5977825739},{"$f":"(D11*ROR!$H$45-C11)/0.619051","v":1616248.5977825739}]
[5,"Adjustment 13.04-Federal Income Tax",-27023238.806572676,0,43652685.815179482,null,{"$f":"(D12*ROR!$H$10-C12)/0.619051","v":43652685.815179482},{"$f":"(D12*ROR!$H$17-C12)/0.619051","v":43652685.815179482},{"$f":"(D12*ROR!$H$24-C12)/0.619051","v":43652685.815179482},{"$f":"(D12*ROR!$H$31-C12)/0.619051","v":43652685.815179482},{"$f":"(D12*ROR!$H$38-C12)/0.619051","v":43652685.815179482},{"$f":"(D12*ROR!$H$45-C12)/0.619051","v":43652685.815179482}]
[6,"Adjustment 13.05-Tax Benefit of Proforma Interest",54067781.157280222,0,-87339784.859858423,null,{"$f":"(D13*ROR!$H$10-C13)/0.619051","v":-87339784.859858423},{"$f":"(D13*ROR!$H$17-C13)/0.619051","v":-87339784.859858423},{"$f":"(D13*ROR!$H$24-C13)/0.619051","v":-87339784.859858423},{"$f":"(D13*ROR!$H$31-C13)/0.619051","v":-87339784.859858423},{"$f":"(D13*ROR!$H$38-C13)/0.619051","v":-87339784.859858423},{"$f":"(D13*ROR!$H$45-C13)/0.619051","v":-87339784.859858423}]
[7,"Adjustment 13.06-Depreciation Study",-34311787.71534916,-17155893.857674569,53320226.899182603,null,{"$f":"(D14*ROR!$H$10-C14)/0.619051","v":53320226.899182603},{"$f":"(D14*ROR!$H$17-C14)/0.619051","v":53334083.507004641},{"$f":"(D14*ROR!$H$24-C14)/0.619051","v":53347940.114826672},{"$f":"(D14*ROR!$H$31-C14)/0.619051","v":53361796.72264871},{"$f":"(D14*ROR!$H$38-C14)/0.619051","v":53375653.330470741},{"$f":"(D14*ROR!$H$45-C14)/0.619051","v":53408909.189243615}]
[8,"Adjustment 13.06A-Reg. Asset Colstrip",0,0,0,null,{"$f":"(D15*ROR!$H$10-C15)/0.619051","v":0},{"$f":"(D15*ROR!$H$17-C15)/0.619051","v":0},{"$f":"(D15*ROR!$H$24-C15)/0.619051","v":0},{"$f":"(D15*ROR!$H$31-C15)/0.619051","v":0},{"$f":"(D15*ROR!$H$38-C15)/0.619051","v":0},{"$f":"(D15*ROR!$H$45-C15)/0.619051","v":0}]
[9,"Adjustment 13.07-Normalize Injuries & Damages",69387.278670666696,0,-112086.53030310378,null,{"$f":"(D16*ROR!$H$10-C16)/0.619051","v":-112086.53030310378},{"$f":"(D16*ROR!$H$17-C16)/0.619051","v":-112086.53030310378},{"$f":"(D16*ROR!$H$24-C16)/0.619051","v":-112086.53030310378},{"$f":"(D16*ROR!$H$31-C16)/0.619051","v":-112086.53030310378},{"$f":"(D16*ROR!$H$38-C16)/0.619051","v":-112086.53030310378},{"$f":"(D16*ROR!$H$45-C16)/0.619051","v":-112086.53030310378}]
[10,"Adjustment 13.08-Bad Debts",681065,0,-1100175.914423852,null,{"$f":"(D17*ROR!$H$10-C17)/0.619051","v":-1100175.914423852},{"$f":"(D17*ROR!$H$17-C17)/0.619051","v":-1100175.914423852},{"$f":"(D17*ROR!$H$24-C17)/0.619051","v":-1100175.914423852},{"$f":"(D17*ROR!$H$31-C17)/0.619051","v":-1100175.914423852},{"$f":"(D17*ROR!$H$38-C17)/0.619051","v":-1100175.914423852},{"$f":"(D17*ROR!$H$45-C17)/0.619051","v":-1100175.914423852}]
[11,"Adjustment 13.09-Incentive Pay",-109903.18925372648,0,177534.95148820771,null,{"$f":"(D18*ROR!$H$10-C18)/0.619051","v":177534.95148820771},{"$f":"(D18*ROR!$H$17-C18)/0.619051","v":177534.95148820771},{"$f":"(D18*ROR!$H$24-C18)/0.619051","v":177534.95148820771},{"$f":"(D18*ROR!$H$31-C18)/0.619051","v":177534.95148820771},{"$f":"(D18*ROR!$H$38-C18)/0.619051","v":177534.95148820771},{"$f":"(D18*ROR!$H$45-C18)/0.619051","v":177534.95148820771}]
[12,"Adjustment 13.10-D&O Insurance",16141.122864383684,0,-26073.979146118305,null,{"$f":"(D19*ROR!$H$10-C19)/0.619051","v":-26073.979146118305},{"$f":"(D19*ROR!$H$17-C19)/0.619051","v":-26073.979146118305},{"$f":"(D19*ROR!$H$24-C19)/0.619051","v":-26073.979146118305},{"$f":"(D19*ROR!$H$31-C19)/0.619051","v":-26073.979146118305},{"$f":"(D19*ROR!$H$38-C19)/0.619051","v":-26073.979146118305},{"$f":"(D19*ROR!$H$45-C19)/0.619051","v":-26073.979146118305}]
[13,"Adjustment 13.11-Interest on Customer Deposits",-176605.63064400846,0,285284.46064057475,null,{"$f":"(D20*ROR!$H$10-C20)/0.619051","v":285284.46064057475},{"$f":"(D20*ROR!$H$17-C20)/0.619051","v":285284.46064057475},{"$f":"(D20*ROR!$H$24-C20)/0.619051","v":285284.46064057475},{"$f":"(D20*ROR!$H$31-C20)/0.619051","v":285284.46064057475},{"$f":"(D20*ROR!$H$38-C20)/0.619051","v":285284.46064057475},{"$f":"(D20*ROR!$H$45-C20)/0.619051","v":285284.46064057475}]
[14,"Adjustment 13.12-Rate Case Expenses",-264904.5667814,0,427920.42461994244,null,{"$f":"(D21*ROR!$H$10-C21)/0.619051","v":427920.42461994244},{"$f":"(D21*ROR!$H$17-C21)/0.619051","v":427920.42461994244},{"$f":"(D21*ROR!$H$24-C21)/0.619051","v":427920.42461994244},{"$f":"(D21*ROR!$H$31-C21)/0.619051","v":427920.42461994244},{"$f":"(D21*ROR!$H$38-C21)/0.619051","v":427920.42461994244},{"$f":"(D21*ROR!$H$45-C21)/0.619051","v":427920.42461994244}]
[15,"Adjustment 13.13-Deferred G/L on Property Sales",171199.77983333383,0,-276551.98010072485,null,{"$f":"(D22*ROR!$H$10-C22)/0.619051","v":-276551.98010072485},{"$f":"(D22*ROR!$H$17-C22)/0.619051","v":-276551.98010072485},{"$f":"(D22*ROR!$H$24-C22)/0.619051","v":-276551.98010072485},{"$f":"(D22*ROR!$H$31-C22)/0.619051","v":-276551.98010072485},{"$f":"(D22*ROR!$H$38-C22)/0.619051","v":-276551.98010072485},{"$f":"(D22*ROR!$H$45-C22)/0.619051","v":-276551.98010072485}]
[16,"Adjustment 13.14-Property & Liability Ins",66147.120545911268,0,-106852.45730305139,null,{"$f":"(D23*ROR!$H$10-C23)/0.619051","v":-106852.45730305139},{"$f":"(D23*ROR!$H$17-C23)/0.619051","v":-106852.45730305139},{"$f":"(D23*ROR!$H$24-C23)/0.619051","v":-106852.45730305139},{"$f":"(D23*ROR!$H$31-C23)/0.619051","v":-106852.45730305139},{"$f":"(D23*ROR!$H$38-C23)/0.619051","v":-106852.45730305139},{"$f":"(D23*ROR!$H$45-C23)/0.619051","v":-106852.45730305139}]
[17,"Adjustment 13.15-Pension Plan",-1184945.4451730854,0,1914132.1880961107,null,{"$f":"(D24*ROR!$H$10-C24)/0.619051","v":1914132.1880961107},{"$f":"(D24*ROR!$H$17-C24)/0.619051","v":1914132.1880961107},{"$f":"(D24*ROR!$H$24-C24)/0.619051","v":1914132.1880961107},{"$f":"(D24*ROR!$H$31-C24)/0.619051","v":1914132.1880961107},{"$f":"(D24*ROR!$H$38-C24)/0.619051","v":1914132.1880961107},{"$f":"(D24*ROR!$H$45-C24)/0.619051","v":1914132.1880961107}]
[18,"Adjustment 13.16-Wage Increase",-1357715.5890578774,0,2193220.8962716763,null,{"$f":"(D25*ROR!$H$10-C25)/0.619051","v":2193220.8962716763},{"$f":"(D25*ROR!$H$17-C25)/0.619051","v":2193220.8962716763},{"$f":"(D25*ROR!$H$24-C25)/0.619051","v":2193220.8962716763},{"$f":"(D25*ROR!$H$31-C25)/0.619051","v":2193220.8962716763},{"$f":"(D25*ROR!$H$38-C25)/0.619051","v":2193220.8962716763},{"$f":"(D25*ROR!$H$45-C25)/0.619051","v":2193220.8962716763}]
[19,"Adjustment 13.17-Investment Plan",-96704.676397892646,0,156214.39331798616,null,{"$f":"(D26*ROR!$H$10-C26)/0.619051","v":156214.39331798616},{"$f":"(D26*ROR!$H$17-C26)/0.619051","v":156214.39331798616},{"$f":"(D26*ROR!$H$24-C26)/0.619051","v":156214.39331798616},{"$f":"(D26*ROR!$H$31-C26)/0.619051","v":156214.39331798616},{"$f":"(D26*ROR!$H$38-C26)/0.619051","v":156214.39331798616},{"$f":"(D26*ROR!$H$45-C26)/0.619051","v":156214.39331798616}]
[20,"Adjustment 13.18-Employee Insurance",-121750.92923393101,0,196673.5038533675,null,{"$f":"(D27*ROR!$H$10-C27)/0.619051","v":196673.5038533675},{"$f":"(D27*ROR!$H$17-C27)/0.619051","v":196673.5038533675},{"$f":"(D27*ROR!$H$24-C27)/0.619051","v":196673.5038533675},{"$f":"(D27*ROR!$H$31-C27)/0.619051","v":196673.5038533675},{"$f":"(D27*ROR!$H$38-C27)/0.619051","v":196673.5038533675},{"$f":"(D27*ROR!$H$45-C27)/0.619051","v":196673.5038533675}]
[21,"Adjustment 13.19-Environmental Remediation",-925459.98811139422,0,1494965.6621367128,null,{"$f":"(D28*ROR!$H$10-C28)/0.619051","v":1494965.6621367128},{"$f":"(D28*ROR!$H$17-C28)/0.619051","v":1494965.6621367128},{"$f":"(D28*ROR!$H$24-C28)/0.619051","v":1494965.6621367128},{"$f":"(D28*ROR!$H$31-C28)/0.619051","v":1494965.6621367128},{"$f":"(D28*ROR!$H$38-C28)/0.619051","v":1494965.6621367128},{"$f":"(D28*ROR!$H$45-C28)/0.619051","v":1494965.6621367128}]
[22,"Adjustment 13.20-Payment Processing Costs",-2010221.1570587384,0,3247262.5955837863,null,{"$f":"(D29*ROR!$H$10-C29)/0.619051","v":3247262.5955837863},{"$f":"(D29*ROR!$H$17-C29)/0.619051","v":3247262.5955837863},{"$f":"(D29*ROR!$H$24-C29)/0.619051","v":3247262.5955837863},{"$f":"(D29*ROR!$H$31-C29)/0.619051","v":3247262.5955837863},{"$f":"(D29*ROR!$H$38-C29)/0.619051","v":3247262.5955837863},{"$f":"(D29*ROR!$H$45-C29)/0.619051","v":3247262.5955837863}]
[23,"Adjustment 13.21-South King Service Center",434046.43987045588,15915060.097866783,1252720.9027485936,null,{"$f":"(D30*ROR!$H$10-C30)/0.619051","v":1252720.9027485936},{"$f":"(D30*ROR!$H$17-C30)/0.619051","v":1239866.5013358933},{"$f":"(D30*ROR!$H$24-C30)/0.619051","v":1227012.0999231932},{"$f":"(D30*ROR!$H$31-C30)/0.619051","v":1214157.6985104934},{"$f":"(D30*ROR!$H$38-C30)/0.619051","v":1201303.2970977933},{"$f":"(D30*ROR!$H$45-C30)/0.619051","v":1170452.733707313}]
[24,"Adjustment 13.22-Excise Tax and WUTC Filing Fee",10262.31709798798,0,-16577.498619641967,null,{"$f":"(D31*ROR!$H$10-C31)/0.619051","v":-16577.498619641967},{"$f":"(D31*ROR!$H$17-C31)/0.619051","v":-16577.498619641967},{"$f":"(D31*ROR!$H$24-C31)/0.619051","v":-16577.498619641967},{"$f":"(D31*ROR!$H$31-C31)/0.619051","v":-16577.498619641967},{"$f":"(D31*ROR!$H$38-C31)/0.619051","v":-16577.498619641967},{"$f":"(D31*ROR!$H$45-C31)/0.619051","v":-16577.498619641967}]
[25,"Adjustment 13.23-ISWC and RB Adjustment",0,19006089.897415221,2333350.2929541455,null,{"$f":"(D32*ROR!$H$10-C32)/0.619051","v":2333350.2929541455},{"$f":"(D32*ROR!$H$17-C32)/0.619051","v":2317999.3041847106},{"$f":"(D32*ROR!$H$24-C32)/0.619051","v":2302648.3154152748},{"$f":"(D32*ROR!$H$31-C32)/0.619051","v":2287297.32664584},{"$f":"(D32*ROR!$H$38-C32)/0.619051","v":2271946.3378764046},{"$f":"(D32*ROR!$H$45-C32)/0.619051","v":2235103.9648297606}]
[26,"Adjustment 13.24-Legal Cost Adjustment",0,0,0,null,{"$f":"(D33*ROR!$H$10-C33)/0.619051","v":0},{"$f":"(D33*ROR!$H$17-C33)/0.619051","v":0},{"$f":"(D33*ROR!$H$24-C33)/0.619051","v":0},{"$f":"(D33*ROR!$H$31-C33)/0.619051","v":0},{"$f":"(D33*ROR!$H$38-C33)/0.619051","v":0},{"$f":"(D33*ROR!$H$45-C33)/0.619051","v":0}]
[27,"Adjustment 13.25-Black Box Adjustment",619050.9,0,-999999.83846242074,null,{"$f":"(D34*ROR!$H$10-C34)/0.619051","v":-999999.83846242074},{"$f":"(D34*ROR!$H$17-C34)/0.619051","v":-999999.83846242074},{"$f":"(D34*ROR!$H$24-C34)/0.619051","v":-999999.83846242074},{"$f":"(D34*ROR!$H$31-C34)/0.619051","v":-999999.83846242074},{"$f":"(D34*ROR!$H$38-C34)/0.619051","v":-999999.83846242074},{"$f":"(D34*ROR!$H$45-C34)/0.619051","v":-999999.83846242074}]
[28,"Adjustment 14.01-Power Costs",1185175.274016425,0,-1914503.4480461625,null,{"$f":"(D35*ROR!$H$10-C35)/0.619051","v":-1914503.4480461625},{"$f":"(D35*ROR!$H$17-C35)/0.619051","v":-1914503.4480461625},{"$f":"(D35*ROR!$H$24-C35)/0.619051","v":-1914503.4480461625},{"$f":"(D35*ROR!$H$31-C35)/0.619051","v":-1914503.4480461625},{"$f":"(D35*ROR!$H$38-C35)/0.619051","v":-1914503.4480461625},{"$f":"(D35*ROR!$H$45-C35)/0.619051","v":-1914503.4480461625}]
[29,"Adjustment 14.02-Montana Electric Energy Tax",148015.50184247154,0,-239100.65865731827,null,{"$f":"(D36*ROR!$H$10-C36)/0.619051","v":-239100.65865731827},{"$f":"(D36*ROR!$H$17-C36)/0.619051","v":-239100.65865731827},{"$f":"(D36*ROR!$H$24-C36)/0.619051","v":-239100.65865731827},{"$f":"(D36*ROR!$H$31-C36)/0.619051","v":-239100.65865731827},{"$f":"(D36*ROR!$H$38-C36)/0.619051","v":-239100.65865731827},{"$f":"(D36*ROR!$H$45-C36)/0.619051","v":-239100.65865731827}]
[30,"Adjustment 14.03-Wild Horse Solar",137890.37865459672,-1969341.3363122563,-464517.98028648383,null,{"$f":"(D37*ROR!$H$10-C37)/0.619051","v":-464517.98028648394},{"$f":"(D37*ROR!$H$17-C37)/0.619051","v":-462927.36712511902},{"$f":"(D37*ROR!$H$24-C37)/0.619051","v":-461336.7539637541},{"$f":"(D37*ROR!$H$31-C37)/0.619051","v":-459746.14080238907},{"$f":"(D37*ROR!$H$38-C37)/0.619051","v":-458155.52764102415},{"$f":"(D37*ROR!$H$45-C37)/0.619051","v":-454338.0560537483}]
[31,"Adjustment 14.04-ASC 815 (Prev. SFAS 133)",-41672583.95949994,0,67316883.357752338,null,{"$f":"(D38*ROR!$H$10-C38)/0.619051","v":67316883.357752338},{"$f":"(D38*ROR!$H$17-C38)/0.619051","v":67316883.357752338},{"$f":"(D38*ROR!$H$24-C38)/0.619051","v":67316883.357752338},{"$f":"(D38*ROR!$H$31-C38)/0.619051","v":67316883.357752338},{"$f":"(D38*ROR!$H$38-C38)/0.619051","v":67316883.357752338},{"$f":"(D38*ROR!$H$45-C38)/0.619051","v":67316883.357752338}]
[32,"Adjustment 14.05-Storm Damage",-6137438.1759166643,0,9914269.0600882061,null,{"$f":"(D39*ROR!$H$10-C39)/0.619051","v":9914269.0600882061},{"$f":"(D39*ROR!$H$17-C39)/0.619051","v":9914269.0600882061},{"$f":"(D39*ROR!$H$24-C39)/0.619051","v":9914269.0600882061},{"$f":"(D39*ROR!$H$31-C39)/0.619051","v":9914269.0600882061},{"$f":"(D39*ROR!$H$38-C39)/0.619051","v":9914269.0600882061},{"$f":"(D39*ROR!$H$45-C39)/0.619051","v":9914269.0600882061}]
[33,"Adjustment 14.06-Reg Assets & Liabilities",1736211.9514499884,-44085326.485419184,-8216926.8191826614,null,{"$f":"(D40*ROR!$H$10-C40)/0.619051","v":-8216926.8191826614},{"$f":"(D40*ROR!$H$17-C40)/0.619051","v":-8181319.6345682945},{"$f":"(D40*ROR!$H$24-C40)/0.619051","v":-8145712.4499539239},{"$f":"(D40*ROR!$H$31-C40)/0.619051","v":-8110105.2653395562},{"$f":"(D40*ROR!$H$38-C40)/0.619051","v":-8074498.0807251865},{"$f":"(D40*ROR!$H$45-C40)/0.619051","v":-7989040.8376507023}]
[34,"Adjustment 14.07-Glacier Battery Storage",-145490.32262849354,2842787.0613208562,584026.41993774113,null,{"$f":"(D41*ROR!$H$10-C41)/0.619051","v":584026.41993774113},{"$f":"(D41*ROR!$H$17-C41)/0.619051","v":581730.33523605997},{"$f":"(D41*ROR!$H$24-C41)/0.619051","v":579434.25053437881},{"$f":"(D41*ROR!$H$31-C41)/0.619051","v":577138.16583269765},{"$f":"(D41*ROR!$H$38-C41)/0.619051","v":574842.08113101649},{"$f":"(D41*ROR!$H$45-C41)/0.619051","v":569331.47784698172}]
[35,"Adjustment 14.08-Energy Imbalance Market",0,0,0,null,{"$f":"(D42*ROR!$H$10-C42)/0.619051","v":0},{"$f":"(D42*ROR!$H$17-C42)/0.619051","v":0},{"$f":"(D42*ROR!$H$24-C42)/0.619051","v":0},{"$f":"(D42*ROR!$H$31-C42)/0.619051","v":0},{"$f":"(D42*ROR!$H$38-C42)/0.619051","v":0},{"$f":"(D42*ROR!$H$45-C42)/0.619051","v":0}]
[36,"Adjustment 14.09-Goldendale Capacity Upgrade",2156.0948424596518,18140954.4063752,2223655.9508700506,null,{"$f":"(D43*ROR!$H$10-C43)/0.619051","v":2223655.9508700506},{"$f":"(D43*ROR!$H$17-C43)/0.619051","v":2209003.7215655381},{"$f":"(D43*ROR!$H$24-C43)/0.619051","v":2194351.4922610261},{"$f":"(D43*ROR!$H$31-C43)/0.619051","v":2179699.2629565136},{"$f":"(D43*ROR!$H$38-C43)/0.619051","v":2165047.0336520011},{"$f":"(D43*ROR!$H$45-C43)/0.619051","v":2129881.6833211724}]
[37,"Adjustment 14.10-Mint Farm Capacity Upgrade",0,19004590.008907948,2333166.1538015511,null,{"$f":"(D44*ROR!$H$10-C44)/0.619051","v":2333166.1538015511},{"$f":"(D44*ROR!$H$17-C44)/0.619051","v":2317816.3764739092},{"$f":"(D44*ROR!$H$24-C44)/0.619051","v":2302466.5991462674},{"$f":"(D44*ROR!$H$31-C44)/0.619051","v":2287116.8218186256},{"$f":"(D44*ROR!$H$38-C44)/0.619051","v":2271767.0444909842},{"$f":"(D44*ROR!$H$45-C44)/0.619051","v":2234927.5789046441}]
[38,"Adjustment 14.11-White River",-3288310.2380116768,-4108724.3018971421,4807434.591120108,null,{"$f":"(D45*ROR!$H$10-C45)/0.619051","v":4807434.591120108},{"$f":"(D45*ROR!$H$17-C45)/0.619051","v":4810753.1580086974},{"$f":"(D45*ROR!$H$24-C45)/0.619051","v":4814071.7248972878},{"$f":"(D45*ROR!$H$31-C45)/0.619051","v":4817390.2917858781},{"$f":"(D45*ROR!$H$38-C45)/0.619051","v":4820708.8586744685},{"$f":"(D45*ROR!$H$45-C45)/0.619051","v":4828673.419207084}]
[39,"Adjustment 14.12-Reclass of Hydro Treasury Grants",-2131857,5739614.9999999851,4148394.4618456294,null,{"$f":"(D46*ROR!$H$10-C46)/0.619051","v":4148394.4618456294},{"$f":"(D46*ROR!$H$17-C46)/0.619051","v":4143758.64427971},{"$f":"(D46*ROR!$H$24-C46)/0.619051","v":4139122.8267137911},{"$f":"(D46*ROR!$H$31-C46)/0.619051","v":4134487.0091478713},{"$f":"(D46*ROR!$H$38-C46)/0.619051","v":4129851.1915819515},{"$f":"(D46*ROR!$H$45-C46)/0.619051","v":4118725.2294237455}]
[40,"Adjustment 14.13-Production Adjustment",32768.976473137918,0,-52934.211354376159,null,{"$f":"(D47*ROR!$H$10-C47)/0.619051","v":-52934.211354376159},{"$f":"(D47*ROR!$H$17-C47)/0.619051","v":-52934.211354376159},{"$f":"(D47*ROR!$H$24-C47)/0.619051","v":-52934.211354376159},{"$f":"(D47*ROR!$H$31-C47)/0.619051","v":-52934.211354376159},{"$f":"(D47*ROR!$H$38-C47)/0.619051","v":-52934.211354376159},{"$f":"(D47*ROR!$H$45-C47)/0.619051","v":-52934.211354376159}]
[41,"Adjusted Results of Operations",326809043.76258337,5166534272.0764675,106368555.92710151,null,{"$f":"SUM(G8:G47)","v":106368555.92710151},{"$f":"SUM(H8:H47)","v":102195608.7288283},{"$f":"SUM(I8:I47)","v":98022661.530555084},{"$f":"SUM(J8:J47)","v":93849714.332281873},89676767.134008646,79661693.858152956]
[42,"Changes to Other Price Schedules",null,null,-86208222.000000015,null,{"$f":"E49","v":-86208222.000000015},{"$f":"E49","v":-86208222.000000015},{"$f":"E49","v":-86208222.000000015},{"$f":"E49","v":-86208222.000000015},{"$f":"E49","v":-86208222.000000015},{"$f":"E49","v":-86208222.000000015}]
[43,"Overall Electric Revenue Requirement Deficiency Using Different ROEs",null,null,20160333.927101493,null,{"$f":"G48+G49","v":20160333.927101493},{"$f":"H48+H49","v":15987386.728828281},{"$f":"I48+I49","v":11814439.530555069},{"$f":"J48+J49","v":7641492.3322818577},3468545.1340086311,-6546528.1418470591]
[44,"Overall Electric Revenue Requirement Deficiency per Settlement",null,null,null,null,20160333.927101493,20160333.927101493,20160333.927101493,20160333.927101493,20160333.927101493,20160333.927101493]
[45,"Difference",null,null,null,null,{"$f":"G50-G51","v":0},{"$f":"H50-H51","v":-4172947.1982732117},-8345894.3965464234,-12518841.594819635,-16691788.793092862,-26706862.068948552]
[]
["Notes and Source"]
["Cols. A-C: Amounts from Exhibit A to Multiparty Settlement Stipulation and Agreement"]
["Col. D: (Note 1) = calculated as Column (B) x 7.60% rate of return per paragraph 11 of the Settlement less Column (A) and the result is divided by the electric conversion factor of .619501 from Exhibit MCC-3r at 3"]

{"sheet":"RCS-14 P2","index":2,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Puget Sound Energy",null,null,null,null,null,null,null,null,null,null,"Exhibit RCS-14"]
["Gas Restating and Pro Forma Adjustments",null,null,null,null,null,null,null,null,null,null,"Docket Nos. UE-170033 & UG-170034"]
[null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 2"]
[]
[null,"Exhibit A to the Multiparty Settlement Stipulation and Agreement",null,null,null,null,"Recalculated Using Indicated ROE"]
["Line No.","Adjustment\n","NOI\n","Rate Base\n","Revenue Requirement \n(Note 1)",null,"Revenue Requirement @ 9.50 % ROE","Revenue Requirement @ 9.40 % ROE","Revenue Requirement @ 9.30 % ROE","Revenue Requirement @ 9.20 % ROE","Revenue Requirement @ 9.10 % ROE","Revenue Requirement @ 8.85 % ROE"]
[null,null,"(A)","(B)","(C)",null,"(D)","(E)","(F)","(G)","(H)","(I)"]
[1,"Actual Results of Operations",119145768.85122192,1727319760.395555,19551185.331356686,null,{"$f":"(D8*ROR!$H$10-C8)/0.62045","v":19551185.331356686},{"$f":"(D8*ROR!$H$17-C8)/0.62045","v":18159195.839539815},{"$f":"(D8*ROR!$H$24-C8)/0.62045","v":16767206.347722942},{"$f":"(D8*ROR!$H$31-C8)/0.62045","v":15375216.855906069},{"$f":"(D8*ROR!$H$38-C8)/0.62045","v":13983227.364089197},{"$f":"(D8*ROR!$H$45-C8)/0.62045","v":10642452.583728742}]
[{"$f":"A8+1","v":2},"Adjustment 11.01-Revenues & Expenses",-32674131.179331072,0,52661989.168073289,null,{"$f":"(D9*ROR!$H$10-C9)/0.62045","v":52661989.168073289},{"$f":"(D9*ROR!$H$17-C9)/0.62045","v":52661989.168073289},{"$f":"(D9*ROR!$H$24-C9)/0.62045","v":52661989.168073289},{"$f":"(D9*ROR!$H$31-C9)/0.62045","v":52661989.168073289},{"$f":"(D9*ROR!$H$38-C9)/0.62045","v":52661989.168073289},{"$f":"(D9*ROR!$H$45-C9)/0.62045","v":52661989.168073289}]
[{"$f":"A9+1","v":3},"Adjustment 11.02-Temperature Normalization",16046445.390000008,0,-25862592.29591427,null,{"$f":"(D10*ROR!$H$10-C10)/0.62045","v":-25862592.29591427},{"$f":"(D10*ROR!$H$17-C10)/0.62045","v":-25862592.29591427},{"$f":"(D10*ROR!$H$24-C10)/0.62045","v":-25862592.29591427},{"$f":"(D10*ROR!$H$31-C10)/0.62045","v":-25862592.29591427},{"$f":"(D10*ROR!$H$38-C10)/0.62045","v":-25862592.29591427},{"$f":"(D10*ROR!$H$45-C10)/0.62045","v":-25862592.29591427}]
[4,"Adjustment 11.03-Pass-Through Revs. & Exps.",736148.06664671004,0,-1186474.4405620277,null,{"$f":"(D11*ROR!$H$10-C11)/0.62045","v":-1186474.4405620277},{"$f":"(D11*ROR!$H$17-C11)/0.62045","v":-1186474.4405620277},{"$f":"(D11*ROR!$H$24-C11)/0.62045","v":-1186474.4405620277},{"$f":"(D11*ROR!$H$31-C11)/0.62045","v":-1186474.4405620277},{"$f":"(D11*ROR!$H$38-C11)/0.62045","v":-1186474.4405620277},{"$f":"(D11*ROR!$H$45-C11)/0.62045","v":-1186474.4405620277}]
[5,"Adjustment 11.04-Federal Income Tax",700821.90807233378,0,-1129538.0902124811,null,{"$f":"(D12*ROR!$H$10-C12)/0.62045","v":-1129538.0902124811},{"$f":"(D12*ROR!$H$17-C12)/0.62045","v":-1129538.0902124811},{"$f":"(D12*ROR!$H$24-C12)/0.62045","v":-1129538.0902124811},{"$f":"(D12*ROR!$H$31-C12)/0.62045","v":-1129538.0902124811},{"$f":"(D12*ROR!$H$38-C12)/0.62045","v":-1129538.0902124811},{"$f":"(D12*ROR!$H$45-C12)/0.62045","v":-1129538.0902124811}]
[6,"Adjustment 11.05-Tax Benefit of Proforma Interest",18475297.984788481,0,-29777255.193470035,null,{"$f":"(D13*ROR!$H$10-C13)/0.62045","v":-29777255.193470035},{"$f":"(D13*ROR!$H$17-C13)/0.62045","v":-29777255.193470035},{"$f":"(D13*ROR!$H$24-C13)/0.62045","v":-29777255.193470035},{"$f":"(D13*ROR!$H$31-C13)/0.62045","v":-29777255.193470035},{"$f":"(D13*ROR!$H$38-C13)/0.62045","v":-29777255.193470035},{"$f":"(D13*ROR!$H$45-C13)/0.62045","v":-29777255.193470035}]
[7,"Adjustment 11.06-Depreciation Study",13174097.538770448,6587048.7693852149,-20426274.207909055,null,{"$f":"(D14*ROR!$H$10-C14)/0.62045","v":-20426274.207909055},{"$f":"(D14*ROR!$H$17-C14)/0.62045","v":-20431582.49122712},{"$f":"(D14*ROR!$H$24-C14)/0.62045","v":-20436890.774545182},{"$f":"(D14*ROR!$H$31-C14)/0.62045","v":-20442199.057863247},{"$f":"(D14*ROR!$H$38-C14)/0.62045","v":-20447507.341181308},{"$f":"(D14*ROR!$H$45-C14)/0.62045","v":-20460247.221144661}]
[8,"Adjustment 11.07-Normalize Injuries & Damages",-57737.625337333404,0,93057.660306766717,null,{"$f":"(D15*ROR!$H$10-C15)/0.62045","v":93057.660306766717},{"$f":"(D15*ROR!$H$17-C15)/0.62045","v":93057.660306766717},{"$f":"(D15*ROR!$H$24-C15)/0.62045","v":93057.660306766717},{"$f":"(D15*ROR!$H$31-C15)/0.62045","v":93057.660306766717},{"$f":"(D15*ROR!$H$38-C15)/0.62045","v":93057.660306766717},{"$f":"(D15*ROR!$H$45-C15)/0.62045","v":93057.660306766717}]
[9,"Adjustment 11.08-Bad Debts",35240,0,-56797.485695865907,null,{"$f":"(D16*ROR!$H$10-C16)/0.62045","v":-56797.485695865907},{"$f":"(D16*ROR!$H$17-C16)/0.62045","v":-56797.485695865907},{"$f":"(D16*ROR!$H$24-C16)/0.62045","v":-56797.485695865907},{"$f":"(D16*ROR!$H$31-C16)/0.62045","v":-56797.485695865907},{"$f":"(D16*ROR!$H$38-C16)/0.62045","v":-56797.485695865907},{"$f":"(D16*ROR!$H$45-C16)/0.62045","v":-56797.485695865907}]
[10,"Adjustment 11.09-Incentive Pay",104022.87357146727,0,-167657.14170596708,null,{"$f":"(D17*ROR!$H$10-C17)/0.62045","v":-167657.14170596708},{"$f":"(D17*ROR!$H$17-C17)/0.62045","v":-167657.14170596708},{"$f":"(D17*ROR!$H$24-C17)/0.62045","v":-167657.14170596708},{"$f":"(D17*ROR!$H$31-C17)/0.62045","v":-167657.14170596708},{"$f":"(D17*ROR!$H$38-C17)/0.62045","v":-167657.14170596708},{"$f":"(D17*ROR!$H$45-C17)/0.62045","v":-167657.14170596708}]
[11,"Adjustment 11.10-D&O Insurance",11635.719098073176,0,-18753.677327863934,null,{"$f":"(D18*ROR!$H$10-C18)/0.62045","v":-18753.677327863934},{"$f":"(D18*ROR!$H$17-C18)/0.62045","v":-18753.677327863934},{"$f":"(D18*ROR!$H$24-C18)/0.62045","v":-18753.677327863934},{"$f":"(D18*ROR!$H$31-C18)/0.62045","v":-18753.677327863934},{"$f":"(D18*ROR!$H$38-C18)/0.62045","v":-18753.677327863934},{"$f":"(D18*ROR!$H$45-C18)/0.62045","v":-18753.677327863934}]
[12,"Adjustment 11.11-Interest on Customer Deposits",-50136.587352658156,0,80806.813365554292,null,{"$f":"(D19*ROR!$H$10-C19)/0.62045","v":80806.813365554292},{"$f":"(D19*ROR!$H$17-C19)/0.62045","v":80806.813365554292},{"$f":"(D19*ROR!$H$24-C19)/0.62045","v":80806.813365554292},{"$f":"(D19*ROR!$H$31-C19)/0.62045","v":80806.813365554292},{"$f":"(D19*ROR!$H$38-C19)/0.62045","v":80806.813365554292},{"$f":"(D19*ROR!$H$45-C19)/0.62045","v":80806.813365554292}]
[13,"Adjustment 11.12-Rate Case Expenses",-280617.30621860002,0,452280.29046434048,null,{"$f":"(D20*ROR!$H$10-C20)/0.62045","v":452280.29046434048},{"$f":"(D20*ROR!$H$17-C20)/0.62045","v":452280.29046434048},{"$f":"(D20*ROR!$H$24-C20)/0.62045","v":452280.29046434048},{"$f":"(D20*ROR!$H$31-C20)/0.62045","v":452280.29046434048},{"$f":"(D20*ROR!$H$38-C20)/0.62045","v":452280.29046434048},{"$f":"(D20*ROR!$H$45-C20)/0.62045","v":452280.29046434048}]
[14,"Adjustment 11.13-Deferred G/L on Property Sales",-105089.82033333331,0,169376.77545867243,null,{"$f":"(D21*ROR!$H$10-C21)/0.62045","v":169376.77545867243},{"$f":"(D21*ROR!$H$17-C21)/0.62045","v":169376.77545867243},{"$f":"(D21*ROR!$H$24-C21)/0.62045","v":169376.77545867243},{"$f":"(D21*ROR!$H$31-C21)/0.62045","v":169376.77545867243},{"$f":"(D21*ROR!$H$38-C21)/0.62045","v":169376.77545867243},{"$f":"(D21*ROR!$H$45-C21)/0.62045","v":169376.77545867243}]
[15,"Adjustment 11.14-Property & Liability Ins",45174.25030059729,0,-72808.848900954617,null,{"$f":"(D22*ROR!$H$10-C22)/0.62045","v":-72808.848900954617},{"$f":"(D22*ROR!$H$17-C22)/0.62045","v":-72808.848900954617},{"$f":"(D22*ROR!$H$24-C22)/0.62045","v":-72808.848900954617},{"$f":"(D22*ROR!$H$31-C22)/0.62045","v":-72808.848900954617},{"$f":"(D22*ROR!$H$38-C22)/0.62045","v":-72808.848900954617},{"$f":"(D22*ROR!$H$45-C22)/0.62045","v":-72808.848900954617}]
[16,"Adjustment 11.15-Pension Plan",-572091.09867787152,0,922058.34261885984,null,{"$f":"(D23*ROR!$H$10-C23)/0.62045","v":922058.34261885984},{"$f":"(D23*ROR!$H$17-C23)/0.62045","v":922058.34261885984},{"$f":"(D23*ROR!$H$24-C23)/0.62045","v":922058.34261885984},{"$f":"(D23*ROR!$H$31-C23)/0.62045","v":922058.34261885984},{"$f":"(D23*ROR!$H$38-C23)/0.62045","v":922058.34261885984},{"$f":"(D23*ROR!$H$45-C23)/0.62045","v":922058.34261885984}]
[17,"Adjustment 11.16-Wage Increase",-907409.25008465524,0,1462501.8133365386,null,{"$f":"(D24*ROR!$H$10-C24)/0.62045","v":1462501.8133365386},{"$f":"(D24*ROR!$H$17-C24)/0.62045","v":1462501.8133365386},{"$f":"(D24*ROR!$H$24-C24)/0.62045","v":1462501.8133365386},{"$f":"(D24*ROR!$H$31-C24)/0.62045","v":1462501.8133365386},{"$f":"(D24*ROR!$H$38-C24)/0.62045","v":1462501.8133365386},{"$f":"(D24*ROR!$H$45-C24)/0.62045","v":1462501.8133365386}]
[18,"Adjustment 11.17-Investment Plan",-46688.825971461367,0,75249.94112573353,null,{"$f":"(D25*ROR!$H$10-C25)/0.62045","v":75249.94112573353},{"$f":"(D25*ROR!$H$17-C25)/0.62045","v":75249.94112573353},{"$f":"(D25*ROR!$H$24-C25)/0.62045","v":75249.94112573353},{"$f":"(D25*ROR!$H$31-C25)/0.62045","v":75249.94112573353},{"$f":"(D25*ROR!$H$38-C25)/0.62045","v":75249.94112573353},{"$f":"(D25*ROR!$H$45-C25)/0.62045","v":75249.94112573353}]
[19,"Adjustment 11.18-Employee Insurance",-58781.168112681989,0,94739.573072257219,null,{"$f":"(D26*ROR!$H$10-C26)/0.62045","v":94739.573072257219},{"$f":"(D26*ROR!$H$17-C26)/0.62045","v":94739.573072257219},{"$f":"(D26*ROR!$H$24-C26)/0.62045","v":94739.573072257219},{"$f":"(D26*ROR!$H$31-C26)/0.62045","v":94739.573072257219},{"$f":"(D26*ROR!$H$38-C26)/0.62045","v":94739.573072257219},{"$f":"(D26*ROR!$H$45-C26)/0.62045","v":94739.573072257219}]
[20,"Adjustment 11.19-Environmental Remediation",-5592127.7891472196,0,9013019.2427225728,null,{"$f":"(D27*ROR!$H$10-C27)/0.62045","v":9013019.2427225728},{"$f":"(D27*ROR!$H$17-C27)/0.62045","v":9013019.2427225728},{"$f":"(D27*ROR!$H$24-C27)/0.62045","v":9013019.2427225728},{"$f":"(D27*ROR!$H$31-C27)/0.62045","v":9013019.2427225728},{"$f":"(D27*ROR!$H$38-C27)/0.62045","v":9013019.2427225728},{"$f":"(D27*ROR!$H$45-C27)/0.62045","v":9013019.2427225728}]
[21,"Adjustment 11.20-Payment Processing Costs",-1449116.576651016,0,2335589.6150391106,null,{"$f":"(D28*ROR!$H$10-C28)/0.62045","v":2335589.6150391106},{"$f":"(D28*ROR!$H$17-C28)/0.62045","v":2335589.6150391106},{"$f":"(D28*ROR!$H$24-C28)/0.62045","v":2335589.6150391106},{"$f":"(D28*ROR!$H$31-C28)/0.62045","v":2335589.6150391106},{"$f":"(D28*ROR!$H$38-C28)/0.62045","v":2335589.6150391106},{"$f":"(D28*ROR!$H$45-C28)/0.62045","v":2335589.6150391106}]
[22,"Adjustment 11.21-South King Service Center",212048.29051128853,7775115.6953258077,610622.13286078314,null,{"$f":"(D29*ROR!$H$10-C29)/0.62045","v":610622.13286078314},{"$f":"(D29*ROR!$H$17-C29)/0.62045","v":604356.42595827207},{"$f":"(D29*ROR!$H$24-C29)/0.62045","v":598090.71905576112},{"$f":"(D29*ROR!$H$31-C29)/0.62045","v":591825.01215325028},{"$f":"(D29*ROR!$H$38-C29)/0.62045","v":585559.30525073933},{"$f":"(D29*ROR!$H$45-C29)/0.62045","v":570521.60868471314}]
[23,"Adjustment 11.22-Excise Tax and WUTC Filing Fee",33509.156061998103,0,-54007.826677408506,null,{"$f":"(D30*ROR!$H$10-C30)/0.62045","v":-54007.826677408506},{"$f":"(D30*ROR!$H$17-C30)/0.62045","v":-54007.826677408506},{"$f":"(D30*ROR!$H$24-C30)/0.62045","v":-54007.826677408506},{"$f":"(D30*ROR!$H$31-C30)/0.62045","v":-54007.826677408506},{"$f":"(D30*ROR!$H$38-C30)/0.62045","v":-54007.826677408506},{"$f":"(D30*ROR!$H$45-C30)/0.62045","v":-54007.826677408506}]
[24,"Adjustment 11.23-ISWC and RB Adjustment",null,4743345.688135013,581020.66612661944,null,{"$f":"(D31*ROR!$H$10-C31)/0.62045","v":581020.66612661944},{"$f":"(D31*ROR!$H$17-C31)/0.62045","v":577198.16174420749},{"$f":"(D31*ROR!$H$24-C31)/0.62045","v":573375.65736179554},{"$f":"(D31*ROR!$H$31-C31)/0.62045","v":569553.15297938348},{"$f":"(D31*ROR!$H$38-C31)/0.62045","v":565730.64859697153},{"$f":"(D31*ROR!$H$45-C31)/0.62045","v":556556.63807918283}]
[25,"Adjustment 11.24-Legal Cost Adjustment",0,0,0,null,{"$f":"(D32*ROR!$H$10-C32)/0.62045","v":0},{"$f":"(D32*ROR!$H$17-C32)/0.62045","v":0},{"$f":"(D32*ROR!$H$24-C32)/0.62045","v":0},{"$f":"(D32*ROR!$H$31-C32)/0.62045","v":0},{"$f":"(D32*ROR!$H$38-C32)/0.62045","v":0},{"$f":"(D32*ROR!$H$45-C32)/0.62045","v":0}]
[26,"Adjustment 11.25-Black Box Adjustment",930675.17044970009,0,-1500000.2747194781,null,{"$f":"(D33*ROR!$H$10-C33)/0.62045","v":-1500000.2747194781},{"$f":"(D33*ROR!$H$17-C33)/0.62045","v":-1500000.2747194781},{"$f":"(D33*ROR!$H$24-C33)/0.62045","v":-1500000.2747194781},{"$f":"(D33*ROR!$H$31-C33)/0.62045","v":-1500000.2747194781},{"$f":"(D33*ROR!$H$38-C33)/0.62045","v":-1500000.2747194781},{"$f":"(D33*ROR!$H$45-C33)/0.62045","v":-1500000.2747194781}]
[27,"Adjustment 07.01-Gas Cost Recovery Mechanism",-4003723.99784054,19011708.408931427,8781713.0097821392,null,{"$f":"(D34*ROR!$H$10-C34)/0.62045","v":8781713.0097821392},{"$f":"(D34*ROR!$H$17-C34)/0.62045","v":8766392.1068818811},{"$f":"(D34*ROR!$H$24-C34)/0.62045","v":8751071.2039816212},{"$f":"(D34*ROR!$H$31-C34)/0.62045","v":8735750.3010813631},{"$f":"(D34*ROR!$H$38-C34)/0.62045","v":8720429.398181105},{"$f":"(D34*ROR!$H$45-C34)/0.62045","v":8683659.2312204838}]
[28,"Adjusted Results of Operations",123853233.97443457,1765436978.9573324,16633050.892614519,null,{"$f":"SUM(G8:G34)","v":16633050.892614519},{"$f":"SUM(H8:H34)","v":15210344.003294408},13787637.113974286,12364930.224654177,10942223.335334055,7527726.8009658046]
[29,"Changes to Other Price Schedules",null,null,-52098690.315980971,null,{"$f":"E36","v":-52098690.315980971},{"$f":"E36","v":-52098690.315980971},{"$f":"E36","v":-52098690.315980971},{"$f":"E36","v":-52098690.315980971},{"$f":"E36","v":-52098690.315980971},{"$f":"E36","v":-52098690.315980971}]
[30,"Overall Natural Gas Revenue Requirement Surplus Using Different ROEs",null,null,-35465639.42336645,null,{"$f":"G35+G36","v":-35465639.42336645},{"$f":"H35+H36","v":-36888346.312686563},-38311053.202006683,-39733760.091326796,-41156466.980646916,-44570963.51501517]
[31,"Overall Natural Gas Revenue Requirement Surplus Per Settlement",null,null,null,null,-35465639.42336645,-35465639.42336645,-35465639.42336645,-35465639.42336645,-35465639.42336645,-35465639.42336645]
[32,"Difference",null,null,null,null,{"$f":"G37-G38","v":0},{"$f":"H37-H38","v":-1422706.8893201128},-2845413.778640233,-4268120.6679603457,-5690827.557280466,-9105324.0916487202]
[]
["Notes and Source"]
["Cols. A-C: Amounts from Exhibit A to Multiparty Settlement Stipulation and Agreement"]
["Col. D: (Note 1) calculated as Column (B) x 7.60% rate of return per paragraph 11 of the Settlement less Column (A) and the result is divided by the natural gas conversion factor of .620450 from Exhibit MCC-8r at 3"]

{"sheet":"ROR","index":3,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"Capital",null,null,null,"Weighted"]
[null,"Description",null,"Structure",null,"Cost",null,"Cost"]
[null,"Long-Term Debt",null,0.51500000000000001,null,5.8058252427184473E-2,null,{"$f":"ROUND(D8*F8,4)","v":2.9899999999999999E-2}]
[null,"Preferred Stock",null,0.48499999999999999,null,9.5000000000000001E-2,null,{"$f":"ROUND(D9*F9,4)","v":4.6100000000000002E-2}]
[null,"Total Capital Structure",null,{"$f":"D8+D9","v":1},null,null,null,{"$f":"H8+H9","v":7.5999999999999998E-2}]
[]
[]
[null,null,null,"Capital",null,null,null,"Weighted"]
[null,"Description",null,"Structure",null,"Cost",null,"Cost"]
[null,"Long-Term Debt",null,0.51500000000000001,null,5.8058252427184473E-2,null,{"$f":"ROUND(D15*F15,4)","v":2.9899999999999999E-2}]
[null,"Preferred Stock",null,0.48499999999999999,null,9.4E-2,null,{"$f":"ROUND(D16*F16,4)","v":4.5600000000000002E-2}]
[null,"Total Capital Structure",null,{"$f":"D15+D16","v":1},null,null,null,{"$f":"H15+H16","v":7.5499999999999998E-2}]
[]
[]
[null,null,null,"Capital",null,null,null,"Weighted"]
[null,"Description",null,"Structure",null,"Cost",null,"Cost"]
[null,"Long-Term Debt",null,0.51500000000000001,null,5.8058252427184473E-2,null,{"$f":"ROUND(D22*F22,4)","v":2.9899999999999999E-2}]
[null,"Preferred Stock",null,0.48499999999999999,null,9.2999999999999999E-2,null,{"$f":"ROUND(D23*F23,4)","v":4.5100000000000001E-2}]
[null,"Total Capital Structure",null,{"$f":"D22+D23","v":1},null,null,null,{"$f":"H22+H23","v":7.4999999999999997E-2}]
[]
[]
[null,null,null,"Capital",null,null,null,"Weighted"]
[null,"Description",null,"Structure",null,"Cost",null,"Cost"]
[null,"Long-Term Debt",null,0.51500000000000001,null,5.8058252427184473E-2,null,{"$f":"ROUND(D29*F29,4)","v":2.9899999999999999E-2}]
[null,"Preferred Stock",null,0.48499999999999999,null,9.1999999999999998E-2,null,{"$f":"ROUND(D30*F30,4)","v":4.4600000000000001E-2}]
[null,"Total Capital Structure",null,{"$f":"D29+D30","v":1},null,null,null,{"$f":"H29+H30","v":7.4499999999999997E-2}]
[]
[]
[null,null,null,"Capital",null,null,null,"Weighted"]
[null,"Description",null,"Structure",null,"Cost",null,"Cost"]
[null,"Long-Term Debt",null,0.51500000000000001,null,5.8058252427184473E-2,null,{"$f":"ROUND(D36*F36,4)","v":2.9899999999999999E-2}]
[null,"Preferred Stock",null,0.48499999999999999,null,9.0999999999999998E-2,null,{"$f":"ROUND(D37*F37,4)","v":4.41E-2}]
[null,"Total Capital Structure",null,{"$f":"D36+D37","v":1},null,null,null,{"$f":"H36+H37","v":7.3999999999999996E-2}]
[]
[]
[null,null,null,"Capital",null,null,null,"Weighted"]
[null,"Description",null,"Structure",null,"Cost",null,"Cost"]
[null,"Long-Term Debt",null,0.51500000000000001,null,5.8058252427184473E-2,null,{"$f":"ROUND(D43*F43,4)","v":2.9899999999999999E-2}]
[null,"Preferred Stock",null,0.48499999999999999,null,8.8499999999999995E-2,null,{"$f":"ROUND(D44*F44,4)","v":4.2900000000000001E-2}]
[null,"Total Capital Structure",null,{"$f":"D43+D44","v":1},null,null,null,{"$f":"H43+H44","v":7.2800000000000004E-2}]