{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Bench 1-C Gas","Bench 1-C Electric","GRC Impacts","Exhibit No.__(JAP-Sch 7 Imp)","Exhibit No.__(JAP-Sch 24 Imp)","Exhibit No.__(JAP-Sch 25 Imp)","Exhibit No.__(JAP-Sch 26 Imp)","Exhibit No.__(JAP-Sch 29 Imp)","Exhibit No.__(JAP-Sch 31 Imp)","Exhibit No.__(JAP-Sch 46 Imp)","Exhibit No.__(JAP-Sch 49 Imp)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":65,"defined_names":5607,"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":"Bench 1-C Gas","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Puget Sound Energy"]
[null,"Total Gas Utility Revenue Requirement Change Amounts in $000"]
[]
[null,"Component from JAP-45","PSE","Public Counsel Adjusted","Reference"]
[]
[]
[null,"Schedule 141 ERF Revenue Removal",2074,null,"Note A"]
[null,"Schedule 142 Decoupling Revenue Removal",-77217,null,"Note A"]
[null,"Schedule 142 Decoupling (Deferral)",34844,null,"Note A"]
[null,"Schedule 149 Gas CRM",-11799,null,"Note A"]
[null,"  Subtotal",{"$f":"SUM(C7:C10)","v":-52098},{"$f":"C11","v":-52098}]
[null,"Base Revenue Change",22814,-13534,"Exhibit RCS-4"]
[null,"Net Revenue Change",{"$f":"SUM(C11:C12)","v":-29284},{"$f":"SUM(D11:D12)","v":-65632}]
[]
[null,"Note A:  Public Counsel witness Smith is not contesting these amounts"]
[]
[]
[null,"Net Revenue Change Check number",-29284]
[null,"Difference",{"$f":"C13-C18","v":0}]

{"sheet":"Bench 1-C Electric","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Puget Sound Energy"]
[null,"Total Electric Utility Revenue Requirement Change Amounts in $000"]
[]
[null,"Component from JAP-44","PSE","Public Counsel Adjusted","Reference"]
[]
[null,"Subtotal Rider Rates",170222.334,null,"Note A"]
[]
[null,"Schedule 95 PCORC",65843,null,"Note A"]
[null,"Schedule 141 ERF",-29746,null,"Note A"]
[null,"Schedule 142  Rate Plan, Deferral & K-Factor",-143380.334,null,"Note A"]
[null,"Schedule 142 Decoupling (Deferral)",21075.112000000001,null,"Note A"]
[null,"Schedule 149 Electric CRM",10479,null,"Note A"]
[null,"  Subtotal",{"$f":"SUM(C8:C12)","v":-75729.222000000009},{"$f":"C13","v":-75729.222000000009}]
[null,"Base Revenue Change",144030.25400000002,70326,"Exhibit RCS-3"]
[null,"Net Revenue Change",{"$f":"SUM(C13:C14)","v":68301.032000000007},{"$f":"SUM(D13:D14)","v":-5403.2220000000088}]
[]
[null,"Note A:  Public Counsel witness Smith is not contesting these amounts"]
[]
[]
[null,"Net Revenue Change Check number",68301.032000000007]
[null,"Difference",{"$f":"C15-C20","v":0}]

{"sheet":"GRC Impacts","index":2,"n_rows":45,"n_cols":31,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,21,5,22],[5,18,5,20],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
["Puget Sound Energy"]
["GRC Rate Impacts"]
["Test Year ended September 2016"]
["$ x 1000"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remove:",null,null,"Add:"]
["Line No.","Tariff","Annual mWh Delivered Sales YE 9-2016","Estimated Annual Proforma Base Revenue","Schedule 95\nPCORC","Schedule 95A\nFederal Incentive Credit","Schedule 120\nConservation","Schedule 129\nLow Income","Schedule 132\nMerger Credit","Schedule 140\nProperty Tax","Schedule 141\nERF","Schedule 142\n Rate Plan, Deferral & \nK-Factor","Schedule 194\nBPA Res & Farm Credit","Subtotal\nRider\nRates","Annual Estimated Revenue @ Rates Effective 12/31/2016",null,"Estimated Annual Proposed Base Revenue","Subtotal\nRider\nRates",{"$f":"+E7","v":"Schedule 95\nPCORC"},{"$f":"+K7","v":"Schedule 141\nERF"},{"$f":"+L7","v":"Schedule 142\n Rate Plan, Deferral & \nK-Factor"},"Schedule 142\nDecoupling (Deferral)","Schedule 149\nElectric CRM","Total \nProposed\nRates","Base Revenue Change","Net Revenue Change","% Change (Base)","% Change (Net)"]
[null,null,"a","b","c","d","e","f","g","h","i","j","k","l = \n∑ (c…k)","m = \nb + l",null,"n","o = l","p = -c","q = - i","r = -j","s","t","u = \n∑ (n…t)","v = m - b","w = u - m","x = v / b","y = w / m"]
[1,7,10442426,1066627,-34802,-28894,63438,9534,-3822,37071,16991,96112,-69308,{"$f":"SUM(E9:M9)","v":86320},{"$f":"SUM(N9,D9)","v":1152947},null,1153702,{"$f":"+N9","v":86320},{"$f":"-E9","v":34802},{"$f":"-K9","v":-16991},{"$f":"-L9","v":-96112},12541,8396,{"$f":"SUM(Q9:W9)","v":1182658},{"$f":"+Q9-D9","v":87075},{"$f":"+X9-O9","v":29711},{"$f":"+Y9/D9","v":8.1635848333109884E-2},{"$f":"+Z9/O9","v":2.5769614735109247E-2}]
[{"$f":"+A9+1","v":2},"Residential",{"$f":"SUM(C9:C9)","v":10442426},1066627,-34802,-28894,63438,9534,-3822,37071,16991,96112,-69308,86320,1152947,null,{"$f":"SUM(Q9:Q9)","v":1153702},86320,34802,-16991,-96112,12541,{"$f":"SUM(W9:W9)","v":8396},1182658,87075,29711,{"$f":"+Y10/D10","v":8.1635848333109884E-2},{"$f":"+Z10/O10","v":2.5769614735109247E-2}]
[{"$f":"+A10+1","v":3}]
[4,"24 (8)",2787459,266944,-8568,-5915,12937,2328,-741,6985,4339,14372,-1738,{"$f":"SUM(E12:M12)","v":23999},{"$f":"SUM(N12,D12)","v":290943},null,283287,{"$f":"+N12","v":23999},{"$f":"-E12","v":8568},{"$f":"-K12","v":-4339},-14372,3721,1143,{"$f":"SUM(Q12:W12)","v":302007},{"$f":"+Q12-D12","v":16343},{"$f":"+X12-O12","v":11064},{"$f":"+Y12/D12","v":6.1222578518340925E-2},{"$f":"+Z12/O12","v":3.8028067353399121E-2}]
[5,"25 (11, 7A)",2830899,251785,-8670,-5826,12736,2200,-679,6460,3524,14596,-1030,{"$f":"SUM(E13:M13)","v":23311},{"$f":"SUM(N13,D13)","v":275096},null,267201,23311,{"$f":"-E13","v":8670},-3524,-14596,3779,564,{"$f":"SUM(Q13:W13)","v":285405},{"$f":"+Q13-D13","v":15416},{"$f":"+X13-O13","v":10309},6.1226840359830809E-2,3.747419082792916E-2,null,null,{"$f":"SUM(Z12,Z14)/SUM(O12,O14)","v":4.0598856904305723E-2}]
[6,"26 (12,26P)",1867682,151835,-5900,-4072,8965,1326,-390,4055,1962,5275.3850000000002,-117,{"$f":"SUM(E14:M14)","v":11104.385},{"$f":"SUM(N14,D14)","v":162939.38500000001},null,161130,11104.385,{"$f":"-E14","v":5900},-1962,-5275.3850000000002,-766.50900000000001,172,{"$f":"SUM(Q14:W14)","v":170302.49100000001},{"$f":"+Q14-D14","v":9295},{"$f":"+X14-O14","v":7363.1059999999998},6.1217769289030853E-2,4.5189234020982703E-2]
[7,29,14327,1137.7460000000001,-41,-30,66,10,-3,33,19,74,-98,{"$f":"SUM(E15:M15)","v":30},{"$f":"SUM(N15,D15)","v":1167.7460000000001},null,1207,30,{"$f":"-E15","v":41},-19,-74,19,0,{"$f":"SUM(Q15:W15)","v":1204},{"$f":"+Q15-D15","v":69.253999999999905},{"$f":"+X15-O15","v":36.253999999999905},6.0869473502873139E-2,3.1046135032789583E-2]
[8,"Total Secondary",{"$f":"SUM(C12:C15)","v":7500367},671701.74600000004,-23179,-15843,34704,5864,-1813,17533,9844,34317.385000000002,-2983,58444.385000000002,730146.13100000005,null,{"$f":"SUM(Q12:Q15)","v":712825},58444.385000000002,23179,-9844,-34317.385000000002,6752.491,{"$f":"SUM(W12:W15)","v":1879},758918.49100000004,41123.254000000001,28772.36,6.1222490852361131E-2,3.9406303448590072E-2]
[9]
[10,"31 (10)",1264534,101395,-3618,-2611,5756,891,-296,2735,1345,3654.9490000000001,-218,{"$f":"SUM(E18:M18)","v":7638.9490000000005},{"$f":"SUM(N18,D18)","v":109033.94899999999},null,107602,{"$f":"+N18","v":7638.9490000000005},{"$f":"-E18","v":3618},{"$f":"-K18","v":-1345},-3654.9490000000001,-129.37899999999999,78,{"$f":"SUM(Q18:W18)","v":113807.621},{"$f":"+Q18-D18","v":6207},{"$f":"+X18-O18","v":4773.6720000000059},{"$f":"+Y18/D18","v":6.1216036293702848E-2},{"$f":"+Z18/O18","v":4.3781519827370524E-2}]
[11,35,4453,248,-11,-6,14,4,-1,10,0,23,-30,{"$f":"SUM(E19:M19)","v":3},{"$f":"SUM(N19,D19)","v":251},null,263,3,{"$f":"-E19","v":11},0,-23,6,0,{"$f":"SUM(Q19:W19)","v":260},{"$f":"+Q19-D19","v":15},{"$f":"+X19-O19","v":9},6.0483870967741937E-2,3.5856573705179286E-2,null,{"$f":"SUM(Y18:Y19)/SUM(D18:D19)","v":6.1214249874560964E-2},{"$f":"SUM(Z18:Z19)/SUM(O18:O19)","v":4.37633182223474E-2}]
[12,43,119660,10338,-336,-232,509,93,-28,443,206,617,0,{"$f":"SUM(E20:M20)","v":1272},{"$f":"SUM(N20,D20)","v":11610},null,11182,1272,{"$f":"-E20","v":336},-206,-617,160,121,{"$f":"SUM(Q20:W20)","v":12248},{"$f":"+Q20-D20","v":844},{"$f":"+X20-O20","v":638},8.1640549429289999E-2,5.49526270456503E-2]
[13,"Total Primary",{"$f":"SUM(C18:C20)","v":1388647},111981,-3965,-2849,6279,988,-325,3188,1551,4294.9490000000005,-248,8913.9490000000005,120894.94899999999,null,{"$f":"SUM(Q18:Q20)","v":119047},8913.9490000000005,3965,-1551,-4294.9490000000005,36.621000000000009,{"$f":"SUM(W18:W20)","v":199},126315.621,7066,5420.6720000000059,6.3099990176905013E-2,4.4837869942771606E-2]
[14]
[15,40,674604,47837,-2137,-1579,3469,414,-87,1560,319,3479,0,{"$f":"SUM(E23:M23)","v":5438},{"$f":"SUM(N23,D23)","v":53275},null,51873,{"$f":"+N23","v":5438},{"$f":"-E23","v":2137},{"$f":"-K23","v":-319},{"$f":"-L23","v":-3479},901,0,{"$f":"SUM(Q23:W23)","v":56551},{"$f":"+Q23-D23","v":4036},{"$f":"+X23-O23","v":3276},{"$f":"+Y23/D23","v":8.4369839245772099E-2},{"$f":"+Z23/O23","v":6.1492257156264662E-2}]
[16]
[17,46,64275,4202,-172,-85,187,39,-5,94,20,332,0,{"$f":"SUM(E25:M25)","v":410},{"$f":"SUM(N25,D25)","v":4612},null,4460,{"$f":"+N25","v":410},{"$f":"-E25","v":172},{"$f":"-K25","v":-20},{"$f":"-L25","v":-332},86,0,{"$f":"SUM(Q25:W25)","v":4776},{"$f":"+Q25-D25","v":258},{"$f":"+X25-O25","v":164},{"$f":"+Y25/D25","v":6.1399333650642554E-2},{"$f":"+Z25/O25","v":3.5559410234171723E-2}]
[18,49,567984,36158,-1325,-1143,2514,318,-48,830,201,2928,0,{"$f":"SUM(E26:M26)","v":4275},{"$f":"SUM(N26,D26)","v":40433},null,38371,4275,{"$f":"-E26","v":1325},{"$f":"-K26","v":-201},{"$f":"-L26","v":-2928},758,0,{"$f":"SUM(Q26:W26)","v":41600},{"$f":"+Q26-D26","v":2213},{"$f":"+X26-O26","v":1167},6.120360639415897E-2,2.8862562758143102E-2]
[19,"Total High Voltage",{"$f":"SUM(C25:C26)","v":632259},{"$f":"SUM(D25:D26)","v":40360},{"$f":"SUM(E25:E26)","v":-1497},-1228,{"$f":"SUM(G25:G26)","v":2701},357,-53,{"$f":"SUM(J25:J26)","v":924},{"$f":"SUM(K25:K26)","v":221},3260,{"$f":"SUM(M25:M26)","v":0},{"$f":"SUM(N25:N26)","v":4685},45045,null,{"$f":"SUM(Q25:Q26)","v":42831},4685,1497,-221,-3260,844,{"$f":"SUM(W25:W26)","v":0},46376,{"$f":"SUM(Y25:Y26)","v":2471},1331,6.1223984142715557E-2,2.9548229548229547E-2]
[20]
[21,"50-59",77972,17167,-241,-220,489,154,-120,784,611,1738,-13,{"$f":"SUM(E29:M29)","v":3182},{"$f":"SUM(N29,D29)","v":20349},null,18569,{"$f":"+N29","v":3182},{"$f":"-E29","v":241},{"$f":"-K29","v":-611},{"$f":"-L29","v":-1738},0,5,{"$f":"SUM(Q29:W29)","v":19648},{"$f":"+Q29-D29","v":1402},{"$f":"+X29-O29","v":-701},{"$f":"+Y29/D29","v":8.1668317120055928E-2},{"$f":"+Z29/O29","v":-3.4448867266204726E-2}]
[22]
[23,"449-459",2098104,7513,0,0,2270,67,-65,619,209,179,0,{"$f":"SUM(E31:M31)","v":3279},{"$f":"SUM(N31,D31)","v":10792},null,7964,{"$f":"+N31","v":3279},{"$f":"-E31","v":0},{"$f":"-K31","v":-209},{"$f":"-L31","v":-179},0,0,{"$f":"SUM(Q31:W31)","v":10855},{"$f":"+Q31-D31","v":451},{"$f":"+X31-O31","v":63},{"$f":"+Y31/D31","v":6.0029282576866766E-2},{"$f":"+Z31/O31","v":5.8376575240919196E-3}]
[24]
[25,"Total",{"$f":"SUM(C10,C16,C21,C23,C27,C29,C31)","v":22814379},1963186.746,-65821,-50613,113350,17378,-6285,61679,29746,143380.334,-72552,170262.334,2133449.08,null,{"$f":"SUM(Q10,Q16,Q21,Q23,Q27,Q29,Q31)","v":2106811},170262.334,65821,-29746,-143380.334,21075.112000000001,{"$f":"SUM(W10,W16,W21,W23,W27,W29,W31)","v":10479},2201322.1119999997,{"$f":"SUM(Y10,Y16,Y21,Y23,Y27,Y29,Y31)","v":143624.25400000002},67873.032000000007,{"$f":"+Y33/D33","v":7.3158732500937546E-2},{"$f":"+Z33/O33","v":3.1813757654811245E-2}]
[26]
[27,5,6930,316,-22,-18,0,0,0,0,0,0,0,{"$f":"SUM(E35:M35)","v":-40},{"$f":"SUM(N35,D35)","v":276},null,722,{"$f":"+N35","v":-40},{"$f":"-E35","v":22},{"$f":"-K35","v":0},{"$f":"-L35","v":0},0,0,{"$f":"SUM(Q35:W35)","v":704},{"$f":"+Q35-D35","v":406},{"$f":"+X35-O35","v":428},{"$f":"+Y35/D35","v":1.2848101265822784},{"$f":"+Z35/O35","v":1.5507246376811594}]
[28]
[29,"All Sales",{"$f":"+C35+C33","v":22821309},{"$f":"+D35+D33","v":1963502.746},{"$f":"+E35+E33","v":-65843},-50631,{"$f":"+G35+G33","v":113350},17378,-6285,{"$f":"+J35+J33","v":61679},{"$f":"+K35+K33","v":29746},143380.334,{"$f":"+M35+M33","v":-72552},{"$f":"+N35+N33","v":170222.334},2133725.08,null,{"$f":"+Q35+Q33","v":2107533},170222.334,65843,-29746,-143380.334,21075.112000000001,{"$f":"+W35+W33","v":10479},2202026.1119999997,{"$f":"+Y35+Y33","v":144030.25400000002},68301.032000000007,{"$f":"+Y37/D37","v":7.3353731892361718E-2},{"$f":"+Z37/O37","v":3.2010230671329035E-2}]
[]
[null,null,22821309.339773428,1963502.709129941,-65843,-50631,113350,17378,-6285,61679,29746,143380.334,-72552,null,null,null,2107532,null,null,null,null,21075.112000000001,10479.212,null,144029.16692985891]
[null,null,{"$f":"+C39-C37","v":0.33977342769503593},-3.6870059091597795E-2,0,0,0,0,{"$f":"+I39-I37","v":0},0,0,0,0,null,null,null,{"$f":"+Q39-Q37","v":-1},null,null,null,null,{"$f":"+V39-V37","v":0},{"$f":"+W39-W37","v":0.21199999999953434},null,{"$f":"+Y39-Y37","v":-1.08707014110405}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S37","v":65843},{"$f":"T37","v":-29746},-143380.334,21075.112000000001,10479,{"$f":"SUM(R43:W43)","v":-75729.222000000009}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y37","v":144030.25400000002},{"$f":"Z37","v":68301.032000000007},{"$f":"Z45-Y45","v":-75729.222000000009}]

{"sheet":"Exhibit No.__(JAP-Sch 7 Imp)","index":3,"n_rows":42,"n_cols":38,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,20,39,30],[40,20,40,30],[41,20,41,30],[42,20,42,30],[0,20,0,30],[1,20,1,30],[2,20,2,30],[5,24,5,30],[6,28,6,30],[3,20,3,30],[41,1,41,11],[6,9,6,11],[39,1,39,11],[40,1,40,11],[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[5,5,5,11]]}
[null,"Puget Sound Energy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Billing Comparison"]
[null,"Schedule 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 7"]
[null,"Residential Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Service"]
[]
[null,null,null,null,null,"Monthly Energy Charge 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Energy Charge 1"]
[null,null,null,"%",null," ",null," ",null,"Change",null,null,null,null,null,null,null,null,null,null,null,null,"%",null," ",null," ",null,"Change"]
[null,"kWh",null,"Customers",null,"Present"," ","Proposed"," ","$",null,"%",null,null,"Present Price (Net)",null,"Proposed Price (Net)",null,null,null,"kWh",null,"Customers",null,"Present"," ","Proposed"," ","$",null,"%",null,null,"Present Price (Net)",null,"Proposed Price (Net)"]
[null,0,null,{"$f":"+W9","v":5.7419848979944474E-3},null,{"$f":"ROUND((($B9*O$11+$O$9)),2)","v":7.87},null,{"$f":"ROUND((($B9*Q$11+$Q$9)),2)","v":9},null,{"$f":"H9-F9","v":1.1299999999999999},null,{"$f":"(H9-F9)/F9","v":0.14358322744599744},null,"Basic 1 Phase",{"$f":"SUM(O17,O30)","v":7.87},null,{"$f":"SUM(Q17,Q30)","v":9},null,{"$f":"(Q9-O9)/O9","v":0.14358322744599744},null,0,null,5.7419848979944474E-3,null,{"$f":"ROUND((($U9*AH$11+$AH$9)),2)","v":7.87},null,{"$f":"(ROUND((($U9*AJ$11+$AJ$9)),2))","v":9},null,{"$f":"AA9-Y9","v":1.1299999999999999},null,{"$f":"(AA9-Y9)/Y9","v":0.14358322744599744},null,"Basic 1 Phase",{"$f":"SUM(AH17,AH30)","v":7.87},null,{"$f":"SUM(AJ17,AJ30)","v":9},null,{"$f":"(AJ9-AH9)/AH9","v":0.14358322744599744}]
[null,50,null,{"$f":"+W10","v":8.1833144872857384E-3},null,{"$f":"ROUND((($B10*O$11+$O$9)),2)","v":12.53},null,{"$f":"ROUND((($B10*Q$11+$Q$9)),2)","v":13.71},null,{"$f":"H10-F10","v":1.1800000000000015},null,{"$f":"(H10-F10)/F10","v":9.4173982442138995E-2},null,null,null,null,null,null,null,null,50,null,8.1833144872857384E-3,null,{"$f":"ROUND((($U10*AH$11+$AH$9)),2)","v":12.53},null,{"$f":"(ROUND((($U10*AJ$11+$AJ$9)),2))","v":13.9},null,{"$f":"AA10-Y10","v":1.370000000000001},null,{"$f":"(AA10-Y10)/Y10","v":0.10933758978451724}]
[null,100,null,{"$f":"+W11","v":1.1031546417228269E-2},null,{"$f":"ROUND((($B11*O$11+$O$9)),2)","v":17.190000000000001},null,{"$f":"ROUND((($B11*Q$11+$Q$9)),2)","v":18.420000000000002},null,{"$f":"H11-F11","v":1.2300000000000004},null,{"$f":"(H11-F11)/F11","v":7.1553228621291473E-2},null,"Energy - First 600",{"$f":"SUM(O18,O23:O29,O31,O33:O35)","v":9.3174726766320798E-2},null,{"$f":"SUM(Q18,Q23:Q29,Q31,Q33:Q35)","v":9.4238486674376565E-2},null,{"$f":"(Q11-O11)/O11","v":1.1416828843766212E-2},null,100,null,1.1031546417228269E-2,null,{"$f":"ROUND((($U11*AH$11+$AH$9)),2)","v":17.190000000000001},null,{"$f":"(ROUND((($U11*AJ$11+$AJ$9)),2))","v":18.8},null,{"$f":"AA11-Y11","v":1.6099999999999994},null,{"$f":"(AA11-Y11)/Y11","v":9.3659104130308285E-2},null,"Energy - First 600",{"$f":"SUM(AH18,AH23:AH29,AH31,AH33:AH35)","v":9.3174726766320798E-2},null,{"$f":"SUM(AJ18,AJ23:AJ29,AJ31,AJ33:AJ35)","v":9.7993486674376573E-2},null,{"$f":"(AJ11-AH11)/AH11","v":5.171745681788871E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy - Over 600",{"$f":"SUM(O19,O23:O29,O32,O33:O35)","v":0.11199672676632079},null,{"$f":"SUM(Q19,Q23:Q29,Q32,Q33:Q35)","v":0.11412948667437657},null,{"$f":"(Q12-O12)/O12","v":1.9043055718099222E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy - Next 200",{"$f":"SUM(AH19,AH23:AH29,AH32:AH35)","v":0.11199672676632079},null,{"$f":"SUM(AJ19,AJ23:AJ29,AJ32:AJ35)","v":9.7993486674376573E-2},null,{"$f":"(AJ12-AH12)/AH12","v":-0.12503258350721028}]
[null,150,null,{"$f":"+W13","v":1.4908688935828765E-2},null,{"$f":"ROUND((($B13*O$11+$O$9)),2)","v":21.85},null,{"$f":"ROUND((($B13*Q$11+$Q$9)),2)","v":23.14},null,{"$f":"H13-F13","v":1.2899999999999991},null,{"$f":"(H13-F13)/F13","v":5.9038901601830618E-2},null,null,null,null,null,null,null,null,150,null,1.4908688935828765E-2,null,{"$f":"ROUND((($U13*AH$11+$AH$9)),2)","v":21.85},null,{"$f":"(ROUND((($U13*AJ$11+$AJ$9)),2))","v":23.7},null,{"$f":"AA13-Y13","v":1.8499999999999979},null,{"$f":"(AA13-Y13)/Y13","v":8.4668192219679528E-2},null,"Energy - Next 1000",{"$f":"SUM(AH20,AH23:AH29,AH32:AH35)","v":0.11199672676632079},null,{"$f":"SUM(AJ20,AJ23:AJ29,AJ32:AJ35)","v":0.11869948667437656},null,{"$f":"(AJ13-AH13)/AH13","v":5.9847819678167588E-2}]
[null,200,null,{"$f":"+W14","v":2.0516728812595968E-2},null,{"$f":"ROUND((($B14*O$11+$O$9)),2)","v":26.5},null,{"$f":"ROUND((($B14*Q$11+$Q$9)),2)","v":27.85},null,{"$f":"H14-F14","v":1.3500000000000014},null,{"$f":"(H14-F14)/F14","v":5.0943396226415145E-2},null,null,null,null,null,null,null,null,200,null,2.0516728812595968E-2,null,{"$f":"ROUND((($U14*AH$11+$AH$9)),2)","v":26.5},null,{"$f":"(ROUND((($U14*AJ$11+$AJ$9)),2))","v":28.6},null,{"$f":"AA14-Y14","v":2.1000000000000014},null,{"$f":"(AA14-Y14)/Y14","v":7.9245283018867976E-2},null,"Energy - Over 1800",{"$f":"SUM(AH21,AH23:AH29,AH32:AH35)","v":0.11199672676632079},null,{"$f":"SUM(AJ21,AJ23:AJ29,AJ32:AJ35)","v":0.10039048667437657},null,{"$f":"(AJ14-AH14)/AH14","v":-0.10363017230102123}]
[null,300,null,{"$f":"+W15","v":6.3392310525435244E-2},null,{"$f":"ROUND((($B15*O$11+$O$9)),2)","v":35.82},null,{"$f":"ROUND((($B15*Q$11+$Q$9)),2)","v":37.270000000000003},null,{"$f":"H15-F15","v":1.4500000000000028},null,{"$f":"(H15-F15)/F15","v":4.0480178671133522E-2},null,null,null,null,null,null,null,null,300,null,6.3392310525435244E-2,null,{"$f":"ROUND((($U15*AH$11+$AH$9)),2)","v":35.82},null,{"$f":"(ROUND((($U15*AJ$11+$AJ$9)),2))","v":38.4},null,{"$f":"AA15-Y15","v":2.5799999999999983},null,{"$f":"(AA15-Y15)/Y15","v":7.2026800670016697E-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,null,null,null,null,null," "]
[null,400,null,{"$f":"+W17","v":8.9366412179571794E-2},null,{"$f":"ROUND((($B17*O$11+$O$9)),2)","v":45.14},null,{"$f":"ROUND((($B17*Q$11+$Q$9)),2)","v":46.7},null,{"$f":"H17-F17","v":1.5600000000000023},null,{"$f":"(H17-F17)/F17","v":3.4559149313247724E-2},null,{"$f":"+N9","v":"Basic 1 Phase"},7.49,null,9,null,null,null,400,null,8.9366412179571794E-2,null,{"$f":"ROUND((($U17*AH$11+$AH$9)),2)","v":45.14},null,{"$f":"(ROUND((($U17*AJ$11+$AJ$9)),2))","v":48.2},null,{"$f":"AA17-Y17","v":3.0600000000000023},null,{"$f":"(AA17-Y17)/Y17","v":6.7789100575985875E-2},null,{"$f":"+AG9","v":"Basic 1 Phase"},7.49,null,9]
[null,500,null,{"$f":"+W18","v":0.10259225843382799},null,{"$f":"ROUND((($B18*O$11+$O$9)),2)","v":54.46},null,{"$f":"ROUND((($B18*Q$11+$Q$9)),2)","v":56.12},null,{"$f":"H18-F18","v":1.6599999999999966},null,{"$f":"(H18-F18)/F18","v":3.0481087036356897E-2},null,{"$f":"+N11","v":"Energy - First 600"},8.5578000000000001E-2,null,9.1621999999999995E-2," ",null,null,500,null,0.10259225843382799,null,{"$f":"ROUND((($U18*AH$11+$AH$9)),2)","v":54.46},null,{"$f":"(ROUND((($U18*AJ$11+$AJ$9)),2))","v":58},null,{"$f":"AA18-Y18","v":3.5399999999999991},null,{"$f":"(AA18-Y18)/Y18","v":6.5001836210062419E-2},null,{"$f":"+AG11","v":"Energy - First 600"},8.5578000000000001E-2,null,9.5377000000000003E-2," "]
[null,600,null,{"$f":"+W19","v":0.10260180180545389},null,{"$f":"ROUND((($B19*O$11+$O$9)),2)","v":63.77},null,{"$f":"ROUND((($B19*Q$11+$Q$9)),2)","v":65.540000000000006},null,{"$f":"H19-F19","v":1.7700000000000031},null,{"$f":"(H19-F19)/F19","v":2.7755998118237462E-2},null,{"$f":"+N12","v":"Energy - Over 600"},0.104157,null,0.111513,null,null,null,600,null,0.10260180180545389,null,{"$f":"ROUND((($U19*AH$11+$AH$9)),2)","v":63.77},null,{"$f":"(ROUND((($U19*AJ$11+$AJ$9)),2))","v":67.8},null,{"$f":"AA19-Y19","v":4.029999999999994},null,{"$f":"(AA19-Y19)/Y19","v":6.3195860122314471E-2},null,{"$f":"+AG12","v":"Energy - Next 200"},0.104157,null,9.5377000000000003E-2]
[null,700,null,{"$f":"+W20","v":9.354041267396912E-2},null,{"$f":"ROUND((((600*O$11)+(($B20-600)*O$12)+$O$9)),2)","v":74.97},null,{"$f":"ROUND((((600*Q$11)+(($B20-600)*Q$12)+$Q$9)),2)","v":76.959999999999994},null,{"$f":"H20-F20","v":1.9899999999999949},null,{"$f":"(H20-F20)/F20","v":2.6543950913698745E-2},null,null,null,null,null,null,null,null,700,null,9.354041267396912E-2,null,{"$f":"ROUND((($U20*AH$11+$AH$9)),2)","v":73.09},null,{"$f":"(ROUND((($U20*AJ$11+$AJ$9)),2))","v":77.599999999999994},null,{"$f":"AA20-Y20","v":4.5099999999999909},null,{"$f":"(AA20-Y20)/Y20","v":6.1704747571487077E-2},null,"Energy - Next 1000",0.104157,null,0.11608300000000001]
[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,null,"Energy - Over 1800",0.104157,null,9.7774E-2]
[null,800,null,{"$f":"+W22","v":8.0786329905573828E-2},null,{"$f":"ROUND((((600*O$11)+(($B22-600)*O$12)+$O$9)),2)","v":86.17},null,{"$f":"ROUND((((600*Q$11)+(($B22-600)*Q$12)+$Q$9)),2)","v":88.37},null,{"$f":"H22-F22","v":2.2000000000000028},null,{"$f":"(H22-F22)/F22","v":2.5530927236857407E-2},null,null,null,null,null,null,null,null,800,null,8.0786329905573828E-2,null,{"$f":"ROUND((($U22*AH$11+$AH$9)),2)","v":82.41},null,{"$f":"(ROUND((($U22*AJ$11+$AJ$9)),2))","v":87.39},null,{"$f":"AA22-Y22","v":4.980000000000004},null,{"$f":"(AA22-Y22)/Y22","v":6.0429559519475845E-2}]
[null,900,"*",{"$f":"+W23","v":6.7617321607992248E-2},null,{"$f":"ROUND((((600*O$11)+(($B23-600)*O$12)+$O$9)),2)","v":97.37},null,{"$f":"ROUND((((600*Q$11)+(($B23-600)*Q$12)+$Q$9)),2)","v":99.78},null,{"$f":"H23-F23","v":2.4099999999999966},null,{"$f":"(H23-F23)/F23","v":2.475094998459481E-2},null,"Schedule 95 - PCA",{"$f":"+AH23","v":-3.3327342336791918E-3},null,{"$f":"+AJ23","v":0},null,null,null,900,"*",6.7617321607992248E-2,null,{"$f":"ROUND((((600*AH$11)+(($U23-600)*AH$12)+$AH$9)),2)","v":97.37},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U23-800)*AJ$13))+$AJ$9),2))","v":99.26},null,{"$f":"AA23-Y23","v":1.8900000000000006},null,{"$f":"(AA23-Y23)/Y23","v":1.941049604601007E-2},null,"Schedule 95 - PCA",-3.3327342336791918E-3,null,0]
[null,1000,null,{"$f":"+W24","v":5.6054386745895232E-2},null,{"$f":"ROUND((((600*O$11)+(($B24-600)*O$12)+$O$9)),2)","v":108.57},null,{"$f":"ROUND((((600*Q$11)+(($B24-600)*Q$12)+$Q$9)),2)","v":111.19},null,{"$f":"H24-F24","v":2.6200000000000045},null,{"$f":"(H24-F24)/F24","v":2.4131896472322046E-2},null,"Schedule 95A - Fed Inc Credit",-2.7669999999999999E-3,null,-2.7669999999999999E-3,null,null,null,1000,null,5.6054386745895232E-2,null,{"$f":"ROUND((((600*AH$11)+(($U24-600)*AH$12)+$AH$9)),2)","v":108.57},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U24-800)*AJ$13))+$AJ$9),2))","v":111.13},null,{"$f":"AA24-Y24","v":2.5600000000000023},null,{"$f":"(AA24-Y24)/Y24","v":2.3579257621810835E-2},null,"Schedule 95A - Fed Inc Credit",-2.7669999999999999E-3,null,{"$f":"+AH24","v":-2.7669999999999999E-3}]
[null,1100,null,{"$f":"+W25","v":4.6059014014314552E-2},null,{"$f":"ROUND((((600*O$11)+(($B25-600)*O$12)+$O$9)),2)","v":119.77},null,{"$f":"ROUND((((600*Q$11)+(($B25-600)*Q$12)+$Q$9)),2)","v":122.61},null,{"$f":"H25-F25","v":2.8400000000000034},null,{"$f":"(H25-F25)/F25","v":2.3712114886866524E-2},null,"Schedule 120 - Conservation",6.0749999999999997E-3,null,6.0749999999999997E-3,null,null,null,1100,null,4.6059014014314552E-2,null,{"$f":"ROUND((((600*AH$11)+(($U25-600)*AH$12)+$AH$9)),2)","v":119.77},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U25-800)*AJ$13))+$AJ$9),2))","v":123},null,{"$f":"AA25-Y25","v":3.230000000000004},null,{"$f":"(AA25-Y25)/Y25","v":2.6968356015696787E-2},null,"Schedule 120 - Conservation",6.0749999999999997E-3,null,6.0749999999999997E-3]
[null,1200,null,{"$f":"+W26","v":3.7802646284051784E-2},null,{"$f":"ROUND((((600*O$11)+(($B26-600)*O$12)+$O$9)),2)","v":130.97},null,{"$f":"ROUND((((600*Q$11)+(($B26-600)*Q$12)+$Q$9)),2)","v":134.02000000000001},null,{"$f":"H26-F26","v":3.0500000000000114},null,{"$f":"(H26-F26)/F26","v":2.3287775826525244E-2},null,"Schedule 129 - Low Income",9.1299999999999997E-4," ",9.1299999999999997E-4,null,null,null,1200,null,3.7802646284051784E-2,null,{"$f":"ROUND((((600*AH$11)+(($U26-600)*AH$12)+$AH$9)),2)","v":130.97},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U26-800)*AJ$13))+$AJ$9),2))","v":134.87},null,{"$f":"AA26-Y26","v":3.9000000000000057},null,{"$f":"(AA26-Y26)/Y26","v":2.9777811712605982E-2},null,"Schedule 129 - Low Income",9.1299999999999997E-4," ",9.1299999999999997E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 132 - Merger Credit",-3.6600000000000001E-4,null,-3.6600000000000001E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 132 - Merger Credit",-3.6600000000000001E-4,null,-3.6600000000000001E-4]
[null,1300,null,{"$f":"+W28","v":3.093167207725165E-2},null,{"$f":"ROUND((((600*O$11)+(($B28-600)*O$12)+$O$9)),2)","v":142.16999999999999},null,{"$f":"ROUND((((600*Q$11)+(($B28-600)*Q$12)+$Q$9)),2)","v":145.43},null,{"$f":"H28-F28","v":3.2600000000000193},null,{"$f":"(H28-F28)/F28","v":2.2930294717591754E-2},null,"Schedule 137 - REC",0,null,0,null,null,null,1300,null,3.093167207725165E-2,null,{"$f":"ROUND((((600*AH$11)+(($U28-600)*AH$12)+$AH$9)),2)","v":142.16999999999999},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U28-800)*AJ$13))+$AJ$9),2))","v":146.74},null,{"$f":"AA28-Y28","v":4.5700000000000216},null,{"$f":"(AA28-Y28)/Y28","v":3.2144615601041163E-2},null,"Schedule 137 - REC",0,null,0]
[null,1400,null,{"$f":"+W29","v":2.5532488466244209E-2},null,{"$f":"ROUND((((600*O$11)+(($B29-600)*O$12)+$O$9)),2)","v":153.37},null,{"$f":"ROUND((((600*Q$11)+(($B29-600)*Q$12)+$Q$9)),2)","v":156.85},null,{"$f":"H29-F29","v":3.4799999999999898},null,{"$f":"(H29-F29)/F29","v":2.2690226250244441E-2},null,"Schedule 140 - Property Tax",3.5500000000000002E-3,null,3.5500000000000002E-3,null,null,null,1400,null,2.5532488466244209E-2,null,{"$f":"ROUND((((600*AH$11)+(($U29-600)*AH$12)+$AH$9)),2)","v":153.37},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U29-800)*AJ$13))+$AJ$9),2))","v":158.61000000000001},null,{"$f":"AA29-Y29","v":5.2400000000000091},null,{"$f":"(AA29-Y29)/Y29","v":3.4165742974506155E-2},null,"Schedule 140 - Property Tax",3.5500000000000002E-3,null,3.5500000000000002E-3]
[null,1600," ",{"$f":"+W30","v":3.8812385674841791E-2},null,{"$f":"ROUND((((600*O$11)+(($B30-600)*O$12)+$O$9)),2)","v":175.77},null,{"$f":"ROUND((((600*Q$11)+(($B30-600)*Q$12)+$Q$9)),2)","v":179.67},null,{"$f":"H30-F30","v":3.8999999999999773},null,{"$f":"(H30-F30)/F30","v":2.2188086704215605E-2},null,"Schedule 141 - ERF - Basic Charge",0.37999999999999989,null,0,null,null,null,1600," ",3.8812385674841791E-2,null,{"$f":"ROUND((((600*AH$11)+(($U30-600)*AH$12)+$AH$9)),2)","v":175.77},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(($U30-800)*AJ$13))+$AJ$9),2))","v":182.35},null,{"$f":"AA30-Y30","v":6.5799999999999841},null,{"$f":"(AA30-Y30)/Y30","v":3.7435284747112614E-2},null,"Schedule 141 - ERF - Basic Charge",0.37999999999999989,null,0]
[null,2000,null,{"$f":"+W31","v":4.6644706777373153E-2},null,{"$f":"ROUND((((600*O$11)+(($B31-600)*O$12)+$O$9)),2)","v":220.57},null,{"$f":"ROUND((((600*Q$11)+(($B31-600)*Q$12)+$Q$9)),2)","v":225.32},null,{"$f":"H31-F31","v":4.75},null,{"$f":"(H31-F31)/F31","v":2.1535113569388403E-2},null,"Schedule 141 - ERF - First 600 kWh",1.114E-3,null,0,null,null,null,2000,null,4.6644706777373153E-2,null,{"$f":"ROUND((((600*AH$11)+(($U31-600)*AH$12)+$AH$9)),2)","v":220.57},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(1000*AJ$13)+(($U31-1800)*AJ$14)))+$AJ$9,2))","v":226.17},null,{"$f":"AA31-Y31","v":5.5999999999999943},null,{"$f":"(AA31-Y31)/Y31","v":2.5388765471278933E-2},null,"Schedule 141 - ERF - First 600 kWh",1.114E-3,null,0]
[null,2500,null,{"$f":"+W32","v":2.8462894737708876E-2},null,{"$f":"ROUND((((600*O$11)+(($B32-600)*O$12)+$O$9)),2)","v":276.57},null,{"$f":"ROUND((((600*Q$11)+(($B32-600)*Q$12)+$Q$9)),2)","v":282.39},null,{"$f":"H32-F32","v":5.8199999999999932},null,{"$f":"(H32-F32)/F32","v":2.1043497125501655E-2},null,"Schedule 141 - ERF - Over 600 kWh",1.3569999999999999E-3,null,0,null,null,null,2500,null,2.8462894737708876E-2,null,{"$f":"ROUND((((600*AH$11)+(($U32-600)*AH$12)+$AH$9)),2)","v":276.57},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(1000*AJ$13)+(($U32-1800)*AJ$14)))+$AJ$9,2))","v":276.37},null,{"$f":"AA32-Y32","v":-0.19999999999998863},null,{"$f":"(AA32-Y32)/Y32","v":-7.2314423111685515E-4},null,"Schedule 141 - ERF - Over 600 kWh",1.3569999999999999E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling",9.2040000000000038E-3,null,1.201E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling",9.2040000000000038E-3,null,1.201E-3]
[null,3000,null,{"$f":"+W34","v":1.3600909204615715E-2},null,{"$f":"ROUND((((600*O$11)+(($B34-600)*O$12)+$O$9)),2)","v":332.57},null,{"$f":"ROUND((((600*Q$11)+(($B34-600)*Q$12)+$Q$9)),2)","v":339.45},null,{"$f":"H34-F34","v":6.8799999999999955},null,{"$f":"(H34-F34)/F34","v":2.0687374086658435E-2},null,"Schedule 149 - CRM",{"$f":"+AH34","v":0},null,8.040256743765921E-4,null,null,null,3000,null,1.3600909204615715E-2,null,{"$f":"ROUND((((600*AH$11)+(($U34-600)*AH$12)+$AH$9)),2)","v":332.57},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(1000*AJ$13)+(($U34-1800)*AJ$14)))+$AJ$9,2))","v":326.56},null,{"$f":"AA34-Y34","v":-6.0099999999999909},null,{"$f":"(AA34-Y34)/Y34","v":-1.8071383468142018E-2},null,"Schedule 149 - CRM",0,null,8.040256743765921E-4]
[null,4000,null,{"$f":"+W35","v":1.0247638670045864E-2},null,{"$f":"ROUND((((600*O$11)+(($B35-600)*O$12)+$O$9)),2)","v":444.56},null,{"$f":"ROUND((((600*Q$11)+(($B35-600)*Q$12)+$Q$9)),2)","v":453.58},null,{"$f":"H35-F35","v":9.0199999999999818},null,{"$f":"(H35-F35)/F35","v":2.0289724671585348E-2},null,"Schedule 194 - BPA Exch Credit",{"$f":"+AH35","v":-6.7935390000000003E-3},null,{"$f":"+AJ35","v":-6.7935390000000003E-3},null,null,null,4000,null,1.0247638670045864E-2,null,{"$f":"ROUND((((600*AH$11)+(($U35-600)*AH$12)+$AH$9)),2)","v":444.56},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(1000*AJ$13)+(($U35-1800)*AJ$14)))+$AJ$9,2))","v":426.95},null,{"$f":"AA35-Y35","v":-17.610000000000014},null,{"$f":"(AA35-Y35)/Y35","v":-3.9612200827784806E-2},null,"Schedule 194 - BPA Exch Credit",-6.7935390000000003E-3,null,{"$f":"+AH35","v":-6.7935390000000003E-3}]
[null,5000,null,{"$f":"+W36","v":2.9912135950987272E-3},null,{"$f":"ROUND((((600*O$11)+(($B36-600)*O$12)+$O$9)),2)","v":556.55999999999995},null,{"$f":"ROUND((((600*Q$11)+(($B36-600)*Q$12)+$Q$9)),2)","v":567.71},null,{"$f":"H36-F36","v":11.150000000000091},null,{"$f":"(H36-F36)/F36","v":2.0033778927698885E-2},null,null,null,null,null,null,null,null,5000,null,2.9912135950987272E-3,null,{"$f":"ROUND((((600*AH$11)+(($U36-600)*AH$12)+$AH$9)),2)","v":556.55999999999995},null,{"$f":"(ROUND((((600*AJ$11)+(200*AJ$12)+(1000*AJ$13)+(($U36-1800)*AJ$14)))+$AJ$9,2))","v":527.34},null,{"$f":"AA36-Y36","v":-29.219999999999914},null,{"$f":"(AA36-Y36)/Y36","v":-5.2501078050883852E-2}]
[null,">5000",null,{"$f":"+W37","v":2.5809330698011489E-3},null,null,null,null,null,null,null,null,null,"Residential Overall:",8.1635848333109884E-2,null,null,null,null,null,">5000",null,2.5809330698011489E-3,null,null,null,null,null,null,null,null,null,"Residential Overall:",8.1634751053054622E-2]
[]
[]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,"* Average PSE Customer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Average PSE Customer"]
[null,"       1 Includes Rider Schedules  95, 95A, 120, 129, 132, 137, 140, 141, 142 and 194",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       1 Includes Rider Schedules  95, 95A, 120, 129, 132, 137, 140, 141, 142 and 194"]

{"sheet":"Exhibit No.__(JAP-Sch 24 Imp)","index":4,"n_rows":44,"n_cols":28,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,19,7,21],[7,22,7,24],[41,1,41,17],[42,1,42,17],[43,1,43,17]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 24"]
[null,"Secondary Voltage General Service, Demand < 50 kW"]
[]
[null,null,null,"Monthly Billing 1, 2",null,null,null,null,null,null,null,"Dollar",null,null,null,"Percent"]
[null,null,null,"Present Price Schedule 24",null,null,null,"Proposed Price Schedule 24",null,null,null,"Difference",null,null,null,"Difference"]
[null,"kWh",null,"1 Phase",null,"3 Phase",null,"1 Phase",null,"3 Phase",null,"1 Phase",null,"3 Phase",null,"1 Phase",null,"3 Phase",null,"Net Present Price",null,null,"Net Proposed Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Phase","Three Phase",null,"Single Phase","Three Phase"]
[null,500,null,{"$f":"ROUND($U$10+$B10*$U$14,2)","v":58.58},null,{"$f":"ROUND($V$10+$B10*$V$14,2)","v":74.23},null,{"$f":"ROUND($X$10+$B10*$X$14,2)","v":60.61},null,{"$f":"ROUND($Y$10+$B10*$Y$14,2)","v":76.41},null,{"$f":"H10-D10","v":2.0300000000000011},null,{"$f":"J10-F10","v":2.1799999999999926},null,{"$f":"ROUND(H10/D10-1,4)","v":3.4700000000000002E-2},null,{"$f":"ROUND(J10/F10-1,4)","v":2.9399999999999999E-2},null,"Basic Charge",{"$f":"SUM(U17,V29)","v":10.16},{"$f":"SUM(V17,V30)","v":25.810000000000002},{"$f":"+T10","v":"Basic Charge"},{"$f":"SUM(X17,Y29)","v":10.25},{"$f":"SUM(Y17,Y30)","v":26.05},null,{"$f":"(X10-U10)/U10","v":8.8582677165354191E-3},{"$f":"(Y10-V10)/V10","v":9.2987214258038898E-3}]
[null,{"$f":"+B10+500","v":1000},null,{"$f":"ROUND($U$10+$B11*$U$14,2)","v":107.01},null,{"$f":"ROUND($V$10+$B11*$V$14,2)","v":122.66},null,{"$f":"ROUND($X$10+$B11*$X$14,2)","v":110.97},null,{"$f":"ROUND($Y$10+$B11*$Y$14,2)","v":126.77},null,{"$f":"H11-D11","v":3.9599999999999937},null,{"$f":"J11-F11","v":4.1099999999999994},null,{"$f":"ROUND(H11/D11-1,4)","v":3.6999999999999998E-2},null,{"$f":"ROUND(J11/F11-1,4)","v":3.3500000000000002E-2}]
[null,{"$f":"+B11+500","v":1500},null,{"$f":"ROUND($U$10+$B12*$U$14,2)","v":155.43},null,{"$f":"ROUND($V$10+$B12*$V$14,2)","v":171.08},null,{"$f":"ROUND($X$10+$B12*$X$14,2)","v":161.33000000000001},null,{"$f":"ROUND($Y$10+$B12*$Y$14,2)","v":177.13},null,{"$f":"H12-D12","v":5.9000000000000057},null,{"$f":"J12-F12","v":6.0499999999999829},null,{"$f":"ROUND(H12/D12-1,4)","v":3.7999999999999999E-2},null,{"$f":"ROUND(J12/F12-1,4)","v":3.5400000000000001E-2},null,"Winter kWh ",{"$f":"SUM(U18,V22:V28,V31,V33:V34)","v":9.8330147368215132E-2},{"$f":"U12","v":9.8330147368215132E-2},{"$f":"+T12","v":"Winter kWh "},{"$f":"SUM(X18,Y22:Y28,Y31,Y33:Y34)","v":0.10227505804828485},{"$f":"X12","v":0.10227505804828485},null,{"$f":"(X12-U12)/U12","v":4.0119035572043667E-2},4.0119035572043667E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer kWh",{"$f":"SUM(U19,V22:V28,V32,V33:V34)","v":9.5189147368215155E-2},{"$f":"U13","v":9.5189147368215155E-2},{"$f":"+T13","v":"Summer kWh"},{"$f":"SUM(X19,Y22:Y28,Y32,Y33:Y34)","v":9.8985058048284849E-2},{"$f":"X13","v":9.8985058048284849E-2},null,3.9877557316341683E-2,3.9877557316341683E-2]
[null,2500,null,{"$f":"ROUND($U$10+$B14*$U$14,2)","v":252.27},null,{"$f":"ROUND($V$10+$B14*$V$14,2)","v":267.92},null,{"$f":"ROUND($X$10+$B14*$X$14,2)","v":262.05},null,{"$f":"ROUND($Y$10+$B14*$Y$14,2)","v":277.85000000000002},null,{"$f":"H14-D14","v":9.7800000000000011},null,{"$f":"J14-F14","v":9.9300000000000068},null,{"$f":"ROUND(H14/D14-1,4)","v":3.8800000000000001E-2},null,{"$f":"ROUND(J14/F14-1,4)","v":3.7100000000000001E-2},null,"Average kWh",{"$f":"ROUND(SUM(U20,V22:V28,V33:V34)+AVERAGE(V31:V32),6)","v":9.6845000000000001E-2},{"$f":"U14","v":9.6845000000000001E-2},{"$f":"+T14","v":"Average kWh"},{"$f":"ROUND(SUM(X20,Y22:Y28,Y33:Y34)+AVERAGE(Y31:Y32),6)","v":0.100721},{"$f":"X14","v":0.100721},null,4.0022716712272234E-2,4.0022716712272234E-2]
[null,{"$f":"+B14+500","v":3000},null,{"$f":"ROUND($U$10+$B15*$U$14,2)","v":300.7},null,{"$f":"ROUND($V$10+$B15*$V$14,2)","v":316.35000000000002},null,{"$f":"ROUND($X$10+$B15*$X$14,2)","v":312.41000000000003},null,{"$f":"ROUND($Y$10+$B15*$Y$14,2)","v":328.21},null,{"$f":"H15-D15","v":11.710000000000036},null,{"$f":"J15-F15","v":11.859999999999957},null,{"$f":"ROUND(H15/D15-1,4)","v":3.8899999999999997E-2},null,{"$f":"ROUND(J15/F15-1,4)","v":3.7499999999999999E-2},null," "," "," "," "," "," "]
[null,{"$f":"+B15+500","v":3500},null,{"$f":"ROUND($U$10+$B16*$U$14,2)","v":349.12},null,{"$f":"ROUND($V$10+$B16*$V$14,2)","v":364.77},null,{"$f":"ROUND($X$10+$B16*$X$14,2)","v":362.77},null,{"$f":"ROUND($Y$10+$B16*$Y$14,2)","v":378.57},null,{"$f":"H16-D16","v":13.649999999999977},null,{"$f":"J16-F16","v":13.800000000000011},null,{"$f":"ROUND(H16/D16-1,4)","v":3.9100000000000003E-2},null,{"$f":"ROUND(J16/F16-1,4)","v":3.78E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T10","v":"Basic Charge"},9.66,24.55,null,10.25,26.05]
[null,{"$f":"+B16+500","v":4000},null,{"$f":"ROUND($U$10+$B18*$U$14,2)","v":397.54},null,{"$f":"ROUND($V$10+$B18*$V$14,2)","v":413.19},null,{"$f":"ROUND($X$10+$B18*$X$14,2)","v":413.13},null,{"$f":"ROUND($Y$10+$B18*$Y$14,2)","v":428.93},null,{"$f":"H18-D18","v":15.589999999999975},null,{"$f":"J18-F18","v":15.740000000000009},null,{"$f":"ROUND(H18/D18-1,4)","v":3.9199999999999999E-2},null,{"$f":"ROUND(J18/F18-1,4)","v":3.8100000000000002E-2},null,{"$f":"+T12","v":"Winter kWh "},8.9456999999999995E-2,8.9456999999999995E-2,null,9.4936000000000006E-2,9.4936000000000006E-2]
[null,{"$f":"+B18+500","v":4500},null,{"$f":"ROUND($U$10+$B19*$U$14,2)","v":445.96},null,{"$f":"ROUND($V$10+$B19*$V$14,2)","v":461.61},null,{"$f":"ROUND($X$10+$B19*$X$14,2)","v":463.49},null,{"$f":"ROUND($Y$10+$B19*$Y$14,2)","v":479.29},null,{"$f":"H19-D19","v":17.53000000000003},null,{"$f":"J19-F19","v":17.680000000000007},null,{"$f":"ROUND(H19/D19-1,4)","v":3.9300000000000002E-2},null,{"$f":"ROUND(J19/F19-1,4)","v":3.8300000000000001E-2},null,{"$f":"+T13","v":"Summer kWh"},8.6359000000000005E-2,8.6359000000000005E-2,null,9.1646000000000005E-2,9.1646000000000005E-2]
[null,{"$f":"+B19+500","v":5000},null,{"$f":"ROUND($U$10+$B20*$U$14,2)","v":494.39},null,{"$f":"ROUND($V$10+$B20*$V$14,2)","v":510.04},null,{"$f":"ROUND($X$10+$B20*$X$14,2)","v":513.86},null,{"$f":"ROUND($Y$10+$B20*$Y$14,2)","v":529.66},null,{"$f":"H20-D20","v":19.470000000000027},null,{"$f":"J20-F20","v":19.619999999999948},null,{"$f":"ROUND(H20/D20-1,4)","v":3.9399999999999998E-2},null,{"$f":"ROUND(J20/F20-1,4)","v":3.85E-2},null,{"$f":"+T14","v":"Average kWh"},8.7993000000000002E-2,8.7993000000000002E-2,null,9.3382000000000007E-2,9.3382000000000007E-2]
[]
[null,{"$f":"+B20+1000","v":6000},null,{"$f":"ROUND($U$10+$B22*$U$14,2)","v":591.23},null,{"$f":"ROUND($V$10+$B22*$V$14,2)","v":606.88},null,{"$f":"ROUND($X$10+$B22*$X$14,2)","v":614.58000000000004},null,{"$f":"ROUND($Y$10+$B22*$Y$14,2)","v":630.38},null,{"$f":"H22-D22","v":23.350000000000023},null,{"$f":"J22-F22","v":23.5},null,{"$f":"ROUND(H22/D22-1,4)","v":3.95E-2},null,{"$f":"ROUND(J22/F22-1,4)","v":3.8699999999999998E-2},null,"Schedule 95 - PCA",null,-3.0738526317848651E-3,null,null,0]
[null,{"$f":"+B22+1000","v":7000},null,{"$f":"ROUND($U$10+$B23*$U$14,2)","v":688.08},null,{"$f":"ROUND($V$10+$B23*$V$14,2)","v":703.73},null,{"$f":"ROUND($X$10+$B23*$X$14,2)","v":715.3},null,{"$f":"ROUND($Y$10+$B23*$Y$14,2)","v":731.1},null,{"$f":"H23-D23","v":27.219999999999914},null,{"$f":"J23-F23","v":27.370000000000005},null,{"$f":"ROUND(H23/D23-1,4)","v":3.9600000000000003E-2},null,{"$f":"ROUND(J23/F23-1,4)","v":3.8899999999999997E-2},null,"Schedule 95A - Fed Inc Credit",null,-2.1220000000000002E-3,null,null,{"$f":"+V23","v":-2.1220000000000002E-3}]
[null,{"$f":"+B23+1000","v":8000},null,{"$f":"ROUND($U$10+$B24*$U$14,2)","v":784.92},null,{"$f":"ROUND($V$10+$B24*$V$14,2)","v":800.57},null,{"$f":"ROUND($X$10+$B24*$X$14,2)","v":816.02},null,{"$f":"ROUND($Y$10+$B24*$Y$14,2)","v":831.82},null,{"$f":"H24-D24","v":31.100000000000023},null,{"$f":"J24-F24","v":31.25},null,{"$f":"ROUND(H24/D24-1,4)","v":3.9600000000000003E-2},null,{"$f":"ROUND(J24/F24-1,4)","v":3.9E-2},null,"Schedule 120 - Conservation",null,4.6410000000000002E-3,null,null,4.6410000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 129 - Low Income",null,8.3500000000000002E-4,null,null,8.3500000000000002E-4]
[null,{"$f":"+B24+1000","v":9000},null,{"$f":"ROUND($U$10+$B26*$U$14,2)","v":881.77},null,{"$f":"ROUND($V$10+$B26*$V$14,2)","v":897.42},null,{"$f":"ROUND($X$10+$B26*$X$14,2)","v":916.74},null,{"$f":"ROUND($Y$10+$B26*$Y$14,2)","v":932.54},null,{"$f":"H26-D26","v":34.970000000000027},null,{"$f":"J26-F26","v":35.120000000000005},null,{"$f":"ROUND(H26/D26-1,4)","v":3.9699999999999999E-2},null,{"$f":"ROUND(J26/F26-1,4)","v":3.9100000000000003E-2},null,"Schedule 132 - Merger Credit",null,-2.6600000000000001E-4,null,null,-2.6600000000000001E-4]
[null,{"$f":"+B26+1000","v":10000},null,{"$f":"ROUND($U$10+$B27*$U$14,2)","v":978.61},null,{"$f":"ROUND($V$10+$B27*$V$14,2)","v":994.26},null,{"$f":"ROUND($X$10+$B27*$X$14,2)","v":1017.46},null,{"$f":"ROUND($Y$10+$B27*$Y$14,2)","v":1033.26},null,{"$f":"H27-D27","v":38.850000000000023},null,{"$f":"J27-F27","v":39},null,{"$f":"ROUND(H27/D27-1,4)","v":3.9699999999999999E-2},null,{"$f":"ROUND(J27/F27-1,4)","v":3.9199999999999999E-2},null,"Schedule 137 - REC",null,0,null,null,0]
[null,{"$f":"+B27+1000","v":11000},null,{"$f":"ROUND($U$10+$B28*$U$14,2)","v":1075.46},null,{"$f":"ROUND($V$10+$B28*$V$14,2)","v":1091.1099999999999},null,{"$f":"ROUND($X$10+$B28*$X$14,2)","v":1118.18},null,{"$f":"ROUND($Y$10+$B28*$Y$14,2)","v":1133.98},null,{"$f":"H28-D28","v":42.720000000000027},null,{"$f":"J28-F28","v":42.870000000000118},null,{"$f":"ROUND(H28/D28-1,4)","v":3.9699999999999999E-2},null,{"$f":"ROUND(J28/F28-1,4)","v":3.9300000000000002E-2},null,"Schedule 140 - Property Tax",null,2.506E-3,null,null,2.506E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Basic 1 Phase",null,0.5,null,null,0]
[null,{"$f":"+B28+1000","v":12000},null,{"$f":"ROUND($U$10+$B30*$U$14,2)","v":1172.3},null,{"$f":"ROUND($V$10+$B30*$V$14,2)","v":1187.95},null,{"$f":"ROUND($X$10+$B30*$X$14,2)","v":1218.9000000000001},null,{"$f":"ROUND($Y$10+$B30*$Y$14,2)","v":1234.7},null,{"$f":"H30-D30","v":46.600000000000136},null,{"$f":"J30-F30","v":46.75},null,{"$f":"ROUND(H30/D30-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J30/F30-1,4)","v":3.9399999999999998E-2},null,"Schedule 141 - ERF - Basic 3 Phase",null,1.26,null,null,0]
[null,{"$f":"+B30+1000","v":13000},null,{"$f":"ROUND($U$10+$B31*$U$14,2)","v":1269.1500000000001},null,{"$f":"ROUND($V$10+$B31*$V$14,2)","v":1284.8},null,{"$f":"ROUND($X$10+$B31*$X$14,2)","v":1319.62},null,{"$f":"ROUND($Y$10+$B31*$Y$14,2)","v":1335.42},null,{"$f":"H31-D31","v":50.4699999999998},null,{"$f":"J31-F31","v":50.620000000000118},null,{"$f":"ROUND(H31/D31-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J31/F31-1,4)","v":3.9399999999999998E-2},null,"Schedule 141 - ERF - Winter",null,1.1969999999999999E-3,null,null,0]
[null,{"$f":"+B31+1000","v":14000},null,{"$f":"ROUND($U$10+$B32*$U$14,2)","v":1365.99},null,{"$f":"ROUND($V$10+$B32*$V$14,2)","v":1381.64},null,{"$f":"ROUND($X$10+$B32*$X$14,2)","v":1420.34},null,{"$f":"ROUND($Y$10+$B32*$Y$14,2)","v":1436.14},null,{"$f":"H32-D32","v":54.349999999999909},null,{"$f":"J32-F32","v":54.5},null,{"$f":"ROUND(H32/D32-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J32/F32-1,4)","v":3.9399999999999998E-2},null,"Schedule 141 - ERF - Summer",null,1.1540000000000001E-3,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling",null,5.1560000000000009E-3,null,null,1.335E-3]
[null,{"$f":"+B32+1000","v":15000},null,{"$f":"ROUND($U$10+$B34*$U$14,2)","v":1462.84},null,{"$f":"ROUND($V$10+$B34*$V$14,2)","v":1478.49},null,{"$f":"ROUND($X$10+$B34*$X$14,2)","v":1521.07},null,{"$f":"ROUND($Y$10+$B34*$Y$14,2)","v":1536.87},null,{"$f":"H34-D34","v":58.230000000000018},null,{"$f":"J34-F34","v":58.379999999999882},null,{"$f":"ROUND(H34/D34-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J34/F34-1,4)","v":3.95E-2},null,"Schedule 149 - CRM",null,0,null,null,4.100580482848454E-4]
[null,{"$f":"+B34+1000","v":16000},null,{"$f":"ROUND($U$10+$B35*$U$14,2)","v":1559.68},null,{"$f":"ROUND($V$10+$B35*$V$14,2)","v":1575.33},null,{"$f":"ROUND($X$10+$B35*$X$14,2)","v":1621.79},null,{"$f":"ROUND($Y$10+$B35*$Y$14,2)","v":1637.59},null,{"$f":"H35-D35","v":62.1099999999999},null,{"$f":"J35-F35","v":62.259999999999991},null,{"$f":"ROUND(H35/D35-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J35/F35-1,4)","v":3.95E-2},null,null," "]
[null,{"$f":"+B35+1000","v":17000},null,{"$f":"ROUND($U$10+$B36*$U$14,2)","v":1656.53},null,{"$f":"ROUND($V$10+$B36*$V$14,2)","v":1672.18},null,{"$f":"ROUND($X$10+$B36*$X$14,2)","v":1722.51},null,{"$f":"ROUND($Y$10+$B36*$Y$14,2)","v":1738.31},null,{"$f":"H36-D36","v":65.980000000000018},null,{"$f":"J36-F36","v":66.129999999999882},null,{"$f":"ROUND(H36/D36-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J36/F36-1,4)","v":3.95E-2},null,"Overall:",6.1226840359830809E-2]
[]
[null,{"$f":"+B36+1000","v":18000},null,{"$f":"ROUND($U$10+$B38*$U$14,2)","v":1753.37},null,{"$f":"ROUND($V$10+$B38*$V$14,2)","v":1769.02},null,{"$f":"ROUND($X$10+$B38*$X$14,2)","v":1823.23},null,{"$f":"ROUND($Y$10+$B38*$Y$14,2)","v":1839.03},null,{"$f":"H38-D38","v":69.860000000000127},null,{"$f":"J38-F38","v":70.009999999999991},null,{"$f":"ROUND(H38/D38-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J38/F38-1,4)","v":3.9600000000000003E-2}]
[null,{"$f":"+B38+1000","v":19000},null,{"$f":"ROUND($U$10+$B39*$U$14,2)","v":1850.22},null,{"$f":"ROUND($V$10+$B39*$V$14,2)","v":1865.87},null,{"$f":"ROUND($X$10+$B39*$X$14,2)","v":1923.95},null,{"$f":"ROUND($Y$10+$B39*$Y$14,2)","v":1939.75},null,{"$f":"H39-D39","v":73.730000000000018},null,{"$f":"J39-F39","v":73.880000000000109},null,{"$f":"ROUND(H39/D39-1,4)","v":3.9800000000000002E-2},null,{"$f":"ROUND(J39/F39-1,4)","v":3.9600000000000003E-2}]
[null,{"$f":"+B39+1000","v":20000},null,{"$f":"ROUND($U$10+$B40*$U$14,2)","v":1947.06},null,{"$f":"ROUND($V$10+$B40*$V$14,2)","v":1962.71},null,{"$f":"ROUND($X$10+$B40*$X$14,2)","v":2024.67},null,{"$f":"ROUND($Y$10+$B40*$Y$14,2)","v":2040.47},null,{"$f":"H40-D40","v":77.610000000000127},null,{"$f":"J40-F40","v":77.759999999999991},null,{"$f":"ROUND(H40/D40-1,4)","v":3.9899999999999998E-2},null,{"$f":"ROUND(J40/F40-1,4)","v":3.9600000000000003E-2}]
[]
[null,"Notes:"]
[null,"       1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141 and 142"]
[null,"       2 Average Non-Seasonal Energy Rate"]

{"sheet":"Exhibit No.__(JAP-Sch 25 Imp)","index":5,"n_rows":54,"n_cols":19,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,13,7,14],[7,15,7,16],[5,6,5,8]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 25"]
[null,"Secondary Voltage General Service, Small Demand Between 50 & 350 kW"]
[]
[null,"kW",null,null,null,null,"Monthly Billing 1, 2"]
[null,"Load Size/",null,"kWh per kW",null,null,"Present ",null,"Proposed",null,"Percent"]
[null,"Demand",null,"(Equiv Hours)","kWh",null,"Schedule 25",null,"Schedule 25",null,"Difference",null,null,"Net Present Price",null,"Net Proposed Price"]
[]
[null,50,null,300,{"$f":"ROUND((B$10*D10),0)","v":15000},null,{"$f":"+O$10+IF($E10<20000,$E10*O$14,20000*O$14+($E10-20000)*O$16)+IF($B10>50,($B10-50)*O$22,0)","v":1468.3349999999998},null,{"$f":"+Q$10+IF($E10<20000,$E10*Q$14,20000*Q$14+($E10-20000)*Q$16)+IF($B10>50,($B10-50)*Q$22,0)","v":1519.22},null,{"$f":"ROUND((+I10-G10)/G10,3)","v":3.5000000000000003E-2},null,null,"Basic Charge",{"$f":"SUM(O27,O46)","v":54.27},{"$f":"+N10","v":"Basic Charge"},{"$f":"SUM(Q27,Q46)","v":54.83},null,{"$f":"(Q10-O10)/O10","v":1.0318776487930626E-2}]
[null,{"$f":"+B10","v":50},null,500,{"$f":"ROUND((B$10*D11),0)","v":25000},null,{"$f":"+O$10+IF($E11<20000,$E11*O$14,20000*O$14+($E11-20000)*O$16)+IF($B11>50,($B11-50)*O$22,0)","v":2301.7718327178882},null,{"$f":"+Q$10+IF($E11<20000,$E11*Q$14,20000*Q$14+($E11-20000)*Q$16)+IF($B11>50,($B11-50)*Q$22,0)","v":2381.2963125571441},null,{"$f":"ROUND((+I11-G11)/G11,3)","v":3.5000000000000003E-2}]
[null,{"$f":"+B11","v":50},null,700,{"$f":"ROUND((B$10*D12),0)","v":35000},null,{"$f":"+O$10+IF($E12<20000,$E12*O$14,20000*O$14+($E12-20000)*O$16)+IF($B12>50,($B12-50)*O$22,0)","v":3025.9354981536644},null,{"$f":"+Q$10+IF($E12<20000,$E12*Q$14,20000*Q$14+($E12-20000)*Q$16)+IF($B12>50,($B12-50)*Q$22,0)","v":3129.1889376714335},null,{"$f":"ROUND((+I12-G12)/G12,3)","v":3.4000000000000002E-2},null,null,"Winter kWh - First 20,000",{"$f":"SUM(O28,O39:O45,O48,O51:O52)","v":9.833036654357763E-2},{"$f":"+N12","v":"Winter kWh - First 20,000"},{"$f":"SUM(Q28,Q39:Q45,Q48,Q51:Q52)","v":0.10186426251142888},null,{"$f":"(Q12-O12)/O12","v":3.5939009403418785E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer kWh - First 20,000",{"$f":"SUM(O29,O39:O45,O49,O51:O52)","v":9.0043366543577613E-2},{"$f":"+N13","v":"Summer kWh - First 20,000"},{"$f":"SUM(Q29,Q39:Q45,Q49,Q51:Q52)","v":9.3210262511428887E-2},null,{"$f":"(Q13-O13)/O13","v":3.5170785915902149E-2}]
[null,100,null,300,{"$f":"ROUND((B$14*D14),0)","v":30000},null,{"$f":"+O$10+IF($E14<20000,$E14*O$14,20000*O$14+($E14-20000)*O$16)+IF($B14>50,($B14-50)*O$22,0)","v":3040.8536654357763},null,{"$f":"+Q$10+IF($E14<20000,$E14*Q$14,20000*Q$14+($E14-20000)*Q$16)+IF($B14>50,($B14-50)*Q$22,0)","v":3154.7426251142888},null,{"$f":"ROUND((+I14-G14)/G14,3)","v":3.6999999999999998E-2},null,null,"Average kWh - First 20,000",{"$f":"ROUND(SUM(O30,O39:O45,O51:O52)+AVERAGE(O48:O49),6)","v":9.4270999999999994E-2},{"$f":"+N14","v":"Average kWh - First 20,000"},{"$f":"ROUND(SUM(Q30,Q39:Q45,Q51:Q52)+AVERAGE(Q48:Q49),6)","v":9.7626000000000004E-2},null,{"$f":"(Q14-O14)/O14","v":3.5588887356663351E-2}]
[null,{"$f":"+B14","v":100},null,500,{"$f":"ROUND((B$14*D15),0)","v":50000},null,{"$f":"+O$10+IF($E15<20000,$E15*O$14,20000*O$14+($E15-20000)*O$16)+IF($B15>50,($B15-50)*O$22,0)","v":4489.1809963073292},null,{"$f":"+Q$10+IF($E15<20000,$E15*Q$14,20000*Q$14+($E15-20000)*Q$16)+IF($B15>50,($B15-50)*Q$22,0)","v":4650.5278753428665},null,{"$f":"ROUND((+I15-G15)/G15,3)","v":3.5999999999999997E-2}]
[null,{"$f":"+B15","v":100},null,700,{"$f":"ROUND((B$14*D16),0)","v":70000},null,{"$f":"+O$10+IF($E16<20000,$E16*O$14,20000*O$14+($E16-20000)*O$16)+IF($B16>50,($B16-50)*O$22,0)","v":5937.5083271788817},null,{"$f":"+Q$10+IF($E16<20000,$E16*Q$14,20000*Q$14+($E16-20000)*Q$16)+IF($B16>50,($B16-50)*Q$22,0)","v":6146.3131255714434},null,{"$f":"ROUND((+I16-G16)/G16,3)","v":3.5000000000000003E-2},null,null,"kWh - All Over 20,000",{"$f":"SUM(O31,O39:O45,O50,O51:O52)","v":7.2416366543577637E-2},{"$f":"+N16","v":"kWh - All Over 20,000"},{"$f":"SUM(Q31,Q39:Q45,Q50,Q51:Q52)","v":7.4789262511428881E-2},null,{"$f":"(Q16-O16)/O16","v":3.2767398878309061E-2}]
[]
[null,150,null,300,{"$f":"ROUND((B$18*D18),0)","v":45000},null,{"$f":"+O$10+IF($E18<20000,$E18*O$14,20000*O$14+($E18-20000)*O$16)+IF($B18>50,($B18-50)*O$22,0)","v":4504.0991635894406},null,{"$f":"+Q$10+IF($E18<20000,$E18*Q$14,20000*Q$14+($E18-20000)*Q$16)+IF($B18>50,($B18-50)*Q$22,0)","v":4676.0815627857219},null,{"$f":"ROUND((+I18-G18)/G18,3)","v":3.7999999999999999E-2},null,null,"kW - First 50",0,{"$f":"+N18","v":"kW - First 50"},0]
[null,{"$f":"+B18","v":150},null,500,{"$f":"ROUND((B$18*D19),0)","v":75000},null,{"$f":"+O$10+IF($E19<20000,$E19*O$14,20000*O$14+($E19-20000)*O$16)+IF($B19>50,($B19-50)*O$22,0)","v":6676.5901598967703},null,{"$f":"+Q$10+IF($E19<20000,$E19*Q$14,20000*Q$14+($E19-20000)*Q$16)+IF($B19>50,($B19-50)*Q$22,0)","v":6919.759438128589},null,{"$f":"ROUND((+I19-G19)/G19,3)","v":3.5999999999999997E-2}]
[null,{"$f":"+B19","v":150},null,700,{"$f":"ROUND((B$18*D20),0)","v":105000},null,{"$f":"+O$10+IF($E20<20000,$E20*O$14,20000*O$14+($E20-20000)*O$16)+IF($B20>50,($B20-50)*O$22,0)","v":8849.0811562040999},null,{"$f":"+Q$10+IF($E20<20000,$E20*Q$14,20000*Q$14+($E20-20000)*Q$16)+IF($B20>50,($B20-50)*Q$22,0)","v":9163.4373134714551},null,{"$f":"ROUND((+I20-G20)/G20,3)","v":3.5999999999999997E-2},null,null,"Winter kW - Over 50",{"$f":"SUM(O33,O47)","v":9.02},{"$f":"+N20","v":"Winter kW - Over 50"},{"$f":"SUM(Q33,Q47)","v":9.56},null,{"$f":"(Q20-O20)/O20","v":5.9866962305986801E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer kW - Over 50",{"$f":"SUM(O34,O47)","v":6.02},{"$f":"+N21","v":"Summer kW - Over 50"},{"$f":"SUM(Q34,Q47)","v":6.38},null,{"$f":"(Q21-O21)/O21","v":5.9800664451827301E-2}]
[null,200,null,300,{"$f":"ROUND((B$22*D22),0)","v":60000},null,{"$f":"+O$10+IF($E22<20000,$E22*O$14,20000*O$14+($E22-20000)*O$16)+IF($B22>50,($B22-50)*O$22,0)","v":5967.3446617431055},null,{"$f":"+Q$10+IF($E22<20000,$E22*Q$14,20000*Q$14+($E22-20000)*Q$16)+IF($B22>50,($B22-50)*Q$22,0)","v":6197.420500457155},null,{"$f":"ROUND((+I22-G22)/G22,3)","v":3.9E-2},null,null,"Average kW - Over 50",{"$f":"SUM(O35,O47)","v":7.54},{"$f":"+N22","v":"Average kW - Over 50"},{"$f":"SUM(Q35,Q47)","v":7.99},null,{"$f":"(Q22-O22)/O22","v":5.9681697612732121E-2}]
[null,{"$f":"+B22","v":200},null,500,{"$f":"ROUND((B$22*D23),0)","v":100000},null,{"$f":"+O$10+IF($E23<20000,$E23*O$14,20000*O$14+($E23-20000)*O$16)+IF($B23>50,($B23-50)*O$22,0)","v":8863.9993234862122},null,{"$f":"+Q$10+IF($E23<20000,$E23*Q$14,20000*Q$14+($E23-20000)*Q$16)+IF($B23>50,($B23-50)*Q$22,0)","v":9188.9910009143096},null,{"$f":"ROUND((+I23-G23)/G23,3)","v":3.6999999999999998E-2}]
[null,{"$f":"+B23","v":200},null,700,{"$f":"ROUND((B$22*D24),0)","v":140000},null,{"$f":"+O$10+IF($E24<20000,$E24*O$14,20000*O$14+($E24-20000)*O$16)+IF($B24>50,($B24-50)*O$22,0)","v":11760.653985229317},null,{"$f":"+Q$10+IF($E24<20000,$E24*Q$14,20000*Q$14+($E24-20000)*Q$16)+IF($B24>50,($B24-50)*Q$22,0)","v":12180.561501371467},null,{"$f":"ROUND((+I24-G24)/G24,3)","v":3.5999999999999997E-2},null,null,"kVarh",{"$f":"+O36","v":2.8300000000000001E-3},{"$f":"+N24","v":"kVarh"},{"$f":"+Q36","v":3.0000000000000001E-3},null,{"$f":"(Q24-O24)/O24","v":6.0070671378091876E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "]
[null,250,null,300,{"$f":"ROUND((B$26*D26),0)","v":75000},null,{"$f":"+O$10+IF($E26<20000,$E26*O$14,20000*O$14+($E26-20000)*O$16)+IF($B26>50,($B26-50)*O$22,0)","v":7430.5901598967703},null,{"$f":"+Q$10+IF($E26<20000,$E26*Q$14,20000*Q$14+($E26-20000)*Q$16)+IF($B26>50,($B26-50)*Q$22,0)","v":7718.759438128589},null,{"$f":"ROUND((+I26-G26)/G26,3)","v":3.9E-2}]
[null,{"$f":"+B26","v":250},null,500,{"$f":"ROUND((B$26*D27),0)","v":125000},null,{"$f":"+O$10+IF($E27<20000,$E27*O$14,20000*O$14+($E27-20000)*O$16)+IF($B27>50,($B27-50)*O$22,0)","v":11051.408487075652},null,{"$f":"+Q$10+IF($E27<20000,$E27*Q$14,20000*Q$14+($E27-20000)*Q$16)+IF($B27>50,($B27-50)*Q$22,0)","v":11458.222563700032},null,{"$f":"ROUND((+I27-G27)/G27,3)","v":3.6999999999999998E-2},null,null,{"$f":"+N10","v":"Basic Charge"},51.67,null,54.83]
[null,{"$f":"+B27","v":250},null,700,{"$f":"ROUND((B$26*D28),0)","v":175000},null,{"$f":"+O$10+IF($E28<20000,$E28*O$14,20000*O$14+($E28-20000)*O$16)+IF($B28>50,($B28-50)*O$22,0)","v":14672.226814254534},null,{"$f":"+Q$10+IF($E28<20000,$E28*Q$14,20000*Q$14+($E28-20000)*Q$16)+IF($B28>50,($B28-50)*Q$22,0)","v":15197.685689271477},null,{"$f":"ROUND((+I28-G28)/G28,3)","v":3.5999999999999997E-2},null,null,{"$f":"+N12","v":"Winter kWh - First 20,000"},8.9582999999999996E-2,null,9.5070000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N13","v":"Summer kWh - First 20,000"},8.1430000000000002E-2,null,8.6416000000000007E-2]
[null,300,null,300,{"$f":"ROUND((B$30*D30),0)","v":90000},null,{"$f":"+O$10+IF($E30<20000,$E30*O$14,20000*O$14+($E30-20000)*O$16)+IF($B30>50,($B30-50)*O$22,0)","v":8893.8356580504351},null,{"$f":"+Q$10+IF($E30<20000,$E30*Q$14,20000*Q$14+($E30-20000)*Q$16)+IF($B30>50,($B30-50)*Q$22,0)","v":9240.098375800022},null,{"$f":"ROUND((+I30-G30)/G30,3)","v":3.9E-2},null,null,{"$f":"+N14","v":"Average kWh - First 20,000"},8.5591E-2,null,9.0831999999999996E-2]
[null,{"$f":"+B30","v":300},null,500,{"$f":"ROUND((B$30*D31),0)","v":150000},null,{"$f":"+O$10+IF($E31<20000,$E31*O$14,20000*O$14+($E31-20000)*O$16)+IF($B31>50,($B31-50)*O$22,0)","v":13238.817650665093},null,{"$f":"+Q$10+IF($E31<20000,$E31*Q$14,20000*Q$14+($E31-20000)*Q$16)+IF($B31>50,($B31-50)*Q$22,0)","v":13727.454126485754},null,{"$f":"ROUND((+I31-G31)/G31,3)","v":3.6999999999999998E-2},null,null,{"$f":"+N16","v":"kWh - All Over 20,000"},6.4072000000000004E-2,null,6.7995E-2]
[null,{"$f":"+B31","v":300},null,700,{"$f":"ROUND((B$30*D32),0)","v":210000},null,{"$f":"+O$10+IF($E32<20000,$E32*O$14,20000*O$14+($E32-20000)*O$16)+IF($B32>50,($B32-50)*O$22,0)","v":17583.799643279752},null,{"$f":"+Q$10+IF($E32<20000,$E32*Q$14,20000*Q$14+($E32-20000)*Q$16)+IF($B32>50,($B32-50)*Q$22,0)","v":18214.809877171487},null,{"$f":"ROUND((+I32-G32)/G32,3)","v":3.5999999999999997E-2},null,null,{"$f":"+N18","v":"kW - First 50"},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N20","v":"Winter kW - Over 50"},9.01,null,9.56]
[null,350,null,300,{"$f":"ROUND((B$34*D34),0)","v":105000},null,{"$f":"+O$10+IF($E34<20000,$E34*O$14,20000*O$14+($E34-20000)*O$16)+IF($B34>50,($B34-50)*O$22,0)","v":10357.0811562041},null,{"$f":"+Q$10+IF($E34<20000,$E34*Q$14,20000*Q$14+($E34-20000)*Q$16)+IF($B34>50,($B34-50)*Q$22,0)","v":10761.437313471455},null,{"$f":"ROUND((+I34-G34)/G34,3)","v":3.9E-2},null,null,{"$f":"+N21","v":"Summer kW - Over 50"},6.01,null,6.38]
[null,{"$f":"+B34","v":350},null,500,{"$f":"ROUND((B$34*D35),0)","v":175000},null,{"$f":"+O$10+IF($E35<20000,$E35*O$14,20000*O$14+($E35-20000)*O$16)+IF($B35>50,($B35-50)*O$22,0)","v":15426.226814254534},null,{"$f":"+Q$10+IF($E35<20000,$E35*Q$14,20000*Q$14+($E35-20000)*Q$16)+IF($B35>50,($B35-50)*Q$22,0)","v":15996.685689271477},null,{"$f":"ROUND((+I35-G35)/G35,3)","v":3.6999999999999998E-2},null,null,"Average kW - Over 50",7.53,null,7.99]
[null,{"$f":"+B35","v":350},null,700,{"$f":"ROUND((B$34*D36),0)","v":245000},null,{"$f":"+O$10+IF($E36<20000,$E36*O$14,20000*O$14+($E36-20000)*O$16)+IF($B36>50,($B36-50)*O$22,0)","v":20495.372472304967},null,{"$f":"+Q$10+IF($E36<20000,$E36*Q$14,20000*Q$14+($E36-20000)*Q$16)+IF($B36>50,($B36-50)*Q$22,0)","v":21231.934065071502},null,{"$f":"ROUND((+I36-G36)/G36,3)","v":3.5999999999999997E-2},null,null,{"$f":"+N24","v":"kVarh"},2.8300000000000001E-3,null,3.0000000000000001E-3]
[]
[]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,"Schedule 95 - PCA",-3.0626334564223842E-3,null,0]
[null," 1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141 and 142",null,null,null,null,null,null,null,null,null,null,null,"Schedule 95A - Fed Inc Credit",-2.0579999999999999E-3,null,{"$f":"+O40","v":-2.0579999999999999E-3}]
[null," 2 Average Non-Seasonal Energy and Demand Rates",null,null,null,null,null,null,null,null,null,null,null,"Schedule 120 - Conservation",4.4990000000000004E-3,null,4.4990000000000004E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 129 - Low Income",7.7700000000000002E-4,null,7.7700000000000002E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 132 - Merger Credit",-2.4000000000000001E-4,null,-2.4000000000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 137 - REC",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 140 - Property Tax",2.2820000000000002E-3,null,2.2820000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Basic",2.6,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Demand",0.01,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Winter kWh First 20,000",1.3940000000000001E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Summer kWh First 20,000",1.2600000000000001E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - kWh Over 20,000",9.9099999999999991E-4,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling",5.1560000000000009E-3,null,1.335E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 149 - CRM",0,null,1.992625114288819E-4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall:",6.1226840359830809E-2]

{"sheet":"Exhibit No.__(JAP-Sch 26 Imp)","index":6,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,6,5,8],[7,13,7,14],[7,15,7,16]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 26"]
[null,"Secondary Voltage General Service, Large Demand Over 350 kW"]
[]
[null,"kW",null,null,null,null,"Monthly Billing 1, 2"]
[null,"Load Size/",null,"kWh per kW",null,null,"Present ",null,"Proposed",null,"Percent"]
[null,"Demand",null,"(Equiv Hours)","kWh",null,"Schedule 26",null,"Schedule 26",null,"Difference",null,null,"Net Present Price",null,"Net Proposed Price"]
[]
[null,350,null,300,{"$f":"ROUND((B$10*D10),0)","v":105000},null,{"$f":"+O$10+$B10*O$16+$E10*O$12","v":10225.395422355432},null,{"$f":"+Q$10+$B10*Q$16+$E10*Q$12","v":10534.021761362117},null,{"$f":"ROUND((+I10-G10)/G10,3)","v":0.03},null,null,"Basic Charge",{"$f":"SUM(O21,O35)","v":110.46},{"$f":"+N10","v":"Basic Charge"},{"$f":"SUM(Q21,Q35)","v":110.86},null,{"$f":"(Q10-O10)/O10","v":3.6212203512584256E-3}]
[null,{"$f":"+B10","v":350},null,500,{"$f":"ROUND((B$10*D11),0)","v":175000},null,{"$f":"+O$10+$B11*O$16+$E11*O$12","v":14346.019037259051},null,{"$f":"+Q$10+$B11*Q$16+$E11*Q$12","v":15107.462935603529},null,{"$f":"ROUND((+I11-G11)/G11,3)","v":5.2999999999999999E-2}]
[null,{"$f":"+B11","v":350},null,700,{"$f":"ROUND((B$10*D12),0)","v":245000},null,{"$f":"+O$10+$B12*O$16+$E12*O$12","v":18466.642652162671},null,{"$f":"+Q$10+$B12*Q$16+$E12*Q$12","v":19680.904109844938},null,{"$f":"ROUND((+I12-G12)/G12,3)","v":6.6000000000000003E-2},null,null,"kWh - All",{"$f":"SUM(O22,O28:O34,O40)","v":5.8866051641480295E-2},{"$f":"+N12","v":"kWh - All"},{"$f":"SUM(Q22,Q28:Q34,Q40)","v":6.5334873917734446E-2},null,{"$f":"(Q12-O12)/O12","v":0.10989054125206282}]
[]
[null,{"$f":"+B12+50","v":400},null,300,{"$f":"ROUND((B$14*D14),0)","v":120000},null,{"$f":"+O$10+$B14*O$16+$E14*O$12","v":11670.386196977635},null,{"$f":"+Q$10+$B14*Q$16+$E14*Q$12","v":12023.044870128133},null,{"$f":"ROUND((+I14-G14)/G14,3)","v":0.03},null,null,"Winter kW",{"$f":"SUM(O23,O36,O39)","v":13.31},{"$f":"+N14","v":"Winter kW"},{"$f":"SUM(Q23,Q36,Q39)","v":12.31},null,{"$f":"(Q14-O14)/O14","v":-7.5131480090157771E-2}]
[null,{"$f":"+B14","v":400},null,500,{"$f":"ROUND((B$14*D15),0)","v":200000},null,{"$f":"+O$10+$B15*O$16+$E15*O$12","v":16379.670328296059},null,{"$f":"+Q$10+$B15*Q$16+$E15*Q$12","v":17249.834783546889},null,{"$f":"ROUND((+I15-G15)/G15,3)","v":5.2999999999999999E-2},null,null,"Summer kW",{"$f":"SUM(O24,O37,O39)","v":9.26},{"$f":"+N15","v":"Summer kW"},{"$f":"SUM(Q24,Q37,Q39)","v":8.16},null,{"$f":"(Q15-O15)/O15","v":-0.11879049676025914}]
[null,{"$f":"+B15","v":400},null,700,{"$f":"ROUND((B$14*D16),0)","v":280000},null,{"$f":"+O$10+$B16*O$16+$E16*O$12","v":21088.954459614481},null,{"$f":"+Q$10+$B16*Q$16+$E16*Q$12","v":22476.624696965646},null,{"$f":"ROUND((+I16-G16)/G16,3)","v":6.6000000000000003E-2},null,null,"Average kW",{"$f":"ROUND(SUM(O25,O39:O39)+AVERAGE(O36:O37),2)","v":11.24},{"$f":"+N16","v":"Average kW"},{"$f":"ROUND(SUM(Q25,Q39:Q39)+AVERAGE(Q36:Q37),2)","v":10.18},null,{"$f":"(Q16-O16)/O16","v":-9.43060498220641E-2}]
[]
[null,{"$f":"+B16+100","v":500},null,300,{"$f":"ROUND((B$18*D18),0)","v":150000},null,{"$f":"+O$10+$B18*O$16+$E18*O$12","v":14560.367746222044},null,{"$f":"+Q$10+$B18*Q$16+$E18*Q$12","v":15001.091087660167},null,{"$f":"ROUND((+I18-G18)/G18,3)","v":0.03},null,null,"kVarh",{"$f":"SUM(O26,O38)","v":1.2700000000000001E-3},{"$f":"+N18","v":"kVarh"},{"$f":"SUM(Q26,Q38)","v":1.32E-3},null,{"$f":"(Q18-O18)/O18","v":3.937007874015741E-2}]
[null,{"$f":"+B18","v":500},null,500,{"$f":"ROUND((B$18*D19),0)","v":250000},null,{"$f":"+O$10+$B19*O$16+$E19*O$12","v":20446.972910370074},null,{"$f":"+Q$10+$B19*Q$16+$E19*Q$12","v":21534.57847943361},null,{"$f":"ROUND((+I19-G19)/G19,3)","v":5.2999999999999999E-2},null,null," "," "," "," "]
[null,{"$f":"+B19","v":500},null,700,{"$f":"ROUND((B$18*D20),0)","v":350000},null,{"$f":"+O$10+$B20*O$16+$E20*O$12","v":26333.578074518104},null,{"$f":"+Q$10+$B20*Q$16+$E20*Q$12","v":28068.065871207058},null,{"$f":"ROUND((+I20-G20)/G20,3)","v":6.6000000000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N10","v":"Basic Charge"},104.46,null,110.86]
[null,{"$f":"+B20+100","v":600},null,300,{"$f":"ROUND((B$22*D22),0)","v":180000},null,{"$f":"+O$10+$B22*O$16+$E22*O$12","v":17450.349295466454},null,{"$f":"+Q$10+$B22*Q$16+$E22*Q$12","v":17979.137305192198},null,{"$f":"ROUND((+I22-G22)/G22,3)","v":0.03},null,null,{"$f":"+N12","v":"kWh - All"},5.6732999999999999E-2,null,5.9950000000000003E-2]
[null,{"$f":"+B22","v":600},null,500,{"$f":"ROUND((B$22*D23),0)","v":300000},null,{"$f":"+O$10+$B23*O$16+$E23*O$12","v":24514.275492444089},null,{"$f":"+Q$10+$B23*Q$16+$E23*Q$12","v":25819.322175320332},null,{"$f":"ROUND((+I23-G23)/G23,3)","v":5.2999999999999999E-2},null,null,{"$f":"+N14","v":"Winter kW"},11.65,null,12.48]
[null,{"$f":"+B23","v":600},null,700,{"$f":"ROUND((B$22*D24),0)","v":420000},null,{"$f":"+O$10+$B24*O$16+$E24*O$12","v":31578.201689421723},null,{"$f":"+Q$10+$B24*Q$16+$E24*Q$12","v":33659.507045448467},null,{"$f":"ROUND((+I24-G24)/G24,3)","v":6.6000000000000003E-2},null,null,{"$f":"+N15","v":"Summer kW"},7.76,null,8.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N16","v":"Average kW"},9.66,null,10.35]
[null,{"$f":"+B24+100","v":700},null,300,{"$f":"ROUND((B$26*D26),0)","v":210000},null,{"$f":"+O$10+$B26*O$16+$E26*O$12","v":20340.330844710861},null,{"$f":"+Q$10+$B26*Q$16+$E26*Q$12","v":20957.183522724234},null,{"$f":"ROUND((+I26-G26)/G26,3)","v":0.03},null,null,{"$f":"+N18","v":"kVarh"},1.24E-3,null,1.32E-3]
[null,{"$f":"+B26","v":700},null,500,{"$f":"ROUND((B$26*D27),0)","v":350000},null,{"$f":"+O$10+$B27*O$16+$E27*O$12","v":28581.578074518104},null,{"$f":"+Q$10+$B27*Q$16+$E27*Q$12","v":30104.065871207058},null,{"$f":"ROUND((+I27-G27)/G27,3)","v":5.2999999999999999E-2}]
[null,{"$f":"+B27","v":700},null,700,{"$f":"ROUND((B$26*D28),0)","v":490000},null,{"$f":"+O$10+$B28*O$16+$E28*O$12","v":36822.825304325343},null,{"$f":"+Q$10+$B28*Q$16+$E28*Q$12","v":39250.948219689875},null,{"$f":"ROUND((+I28-G28)/G28,3)","v":6.6000000000000003E-2},null,null,"Schedule 95 - PCA",-3.1589483585196991E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 95A - Fed Inc Credit",-2.1800000000000001E-3,null,{"$f":"+O29","v":-2.1800000000000001E-3}]
[null,{"$f":"+B28+100","v":800},null,300,{"$f":"ROUND((B$30*D30),0)","v":240000},null,{"$f":"+O$10+$B30*O$16+$E30*O$12","v":23230.312393955268},null,{"$f":"+Q$10+$B30*Q$16+$E30*Q$12","v":23935.229740256269},null,{"$f":"ROUND((+I30-G30)/G30,3)","v":0.03},null,null,"Schedule 120 - Conservation",4.7999999999999996E-3,null,4.7999999999999996E-3]
[null,{"$f":"+B30","v":800},null,500,{"$f":"ROUND((B$30*D31),0)","v":400000},null,{"$f":"+O$10+$B31*O$16+$E31*O$12","v":32648.880656592119},null,{"$f":"+Q$10+$B31*Q$16+$E31*Q$12","v":34388.809567093776},null,{"$f":"ROUND((+I31-G31)/G31,3)","v":5.2999999999999999E-2},null,null,"Schedule 129 - Low Income",7.1000000000000002E-4,null,7.1000000000000002E-4]
[null,{"$f":"+B31","v":800},null,700,{"$f":"ROUND((B$30*D32),0)","v":560000},null,{"$f":"+O$10+$B32*O$16+$E32*O$12","v":42067.448919228962},null,{"$f":"+Q$10+$B32*Q$16+$E32*Q$12","v":44842.389393931291},null,{"$f":"ROUND((+I32-G32)/G32,3)","v":6.6000000000000003E-2},null,null,"Schedule 132 - Merger Credit",-2.0900000000000001E-4,null,-2.0900000000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 137 - REC",0,null,0]
[null,{"$f":"+B32+200","v":1000},null,300,{"$f":"ROUND((B$34*D34),0)","v":300000},null,{"$f":"+O$10+$B34*O$16+$E34*O$12","v":29010.275492444089},null,{"$f":"+Q$10+$B34*Q$16+$E34*Q$12","v":29891.322175320332},null,{"$f":"ROUND((+I34-G34)/G34,3)","v":0.03},null,null,"Schedule 140 - Property Tax",2.1710000000000002E-3,null,2.1710000000000002E-3]
[null,{"$f":"+B34","v":1000},null,500,{"$f":"ROUND((B$34*D35),0)","v":500000},null,{"$f":"+O$10+$B35*O$16+$E35*O$12","v":40783.485820740141},null,{"$f":"+Q$10+$B35*Q$16+$E35*Q$12","v":42958.296958867228},null,{"$f":"ROUND((+I35-G35)/G35,3)","v":5.2999999999999999E-2},null,null,"Schedule 141 - ERF - Basic",6,null,0]
[null,{"$f":"+B35","v":1000},null,700,{"$f":"ROUND((B$34*D36),0)","v":700000},null,{"$f":"+O$10+$B36*O$16+$E36*O$12","v":52556.696149036208},null,{"$f":"+Q$10+$B36*Q$16+$E36*Q$12","v":56025.271742414116},null,{"$f":"ROUND((+I36-G36)/G36,3)","v":6.6000000000000003E-2},null,null,"Schedule 141 - ERF - Demand Winter",0.49,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Demand Summer",0.33,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Reactive Power",3.0000000000000001E-5,null,0]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling kW",1.17,null,-0.17]
[null," 1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141 and 142",null,null,null,null,null,null,null,null,null,null,null,"Schedule 149 - CRM",0,null,9.2873917734436897E-5]
[null," 2 Average Non-Seasonal Energy and Demand Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall:",6.1217991457989375E-2]

{"sheet":"Exhibit No.__(JAP-Sch 29 Imp)","index":7,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,13,7,14],[7,15,7,16],[5,6,5,8]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 29"]
[null,"Secondary Voltage Irrigation & Pumping Service"]
[]
[null,"kW",null,null,null,null,"Monthly Billing 1, 2"]
[null,"Load Size/",null,"kWh per kW",null,null,"Present ",null,"Proposed"]
[null,"Demand",null,"(Equiv Hours)","kWh",null,"Schedule 29",null,"Schedule 29",null,"% Change",null,null,"Net Present Price",null,"Net Proposed Price"]
[]
[null,"Single Phase",null,null,null,null,null,null,null,null,null,null,null,"Basic Charge (1 Phase)",{"$f":"SUM(O30,O51)","v":10.040000000000001},{"$f":"+N10","v":"Basic Charge (1 Phase)"},{"$f":"SUM(Q30,Q51)","v":10.15},null,{"$f":"(Q10-O10)/O10","v":1.0956175298804723E-2}]
[null,25,null,200,{"$f":"ROUND((B$11*D11),0)","v":5000},null,{"$f":"ROUND(+O$10+IF(E11>20000,20000*O$15+(E11-20000)*O$19,E11*O$15)+IF(B11>50,(B11-50)*O$25,0),0)","v":348},null,{"$f":"ROUND(+Q$10+IF(E11>20000,20000*Q$15+(E11-20000)*Q$19,E11*Q$15)+IF(B11>50,(B11-50)*Q$25,0),0)","v":358},null,{"$f":"ROUND((I11-G11)/G11,4)","v":2.87E-2},null,null,"Basic Charge (3 Phase)",{"$f":"SUM(O31,O52)","v":25.5},{"$f":"+N11","v":"Basic Charge (3 Phase)"},{"$f":"SUM(Q31,Q52)","v":25.77},null,{"$f":"(Q11-O11)/O11","v":1.0588235294117631E-2}]
[null,{"$f":"+B11","v":25},null,300,{"$f":"ROUND((B$11*D12),0)","v":7500},null,{"$f":"ROUND(+O$10+IF(E12>20000,20000*O$15+(E12-20000)*O$19,E12*O$15)+IF(B12>50,(B12-50)*O$25,0),0)","v":518},null,{"$f":"ROUND(+Q$10+IF(E12>20000,20000*Q$15+(E12-20000)*Q$19,E12*Q$15)+IF(B12>50,(B12-50)*Q$25,0),0)","v":533},null,{"$f":"ROUND((I12-G12)/G12,4)","v":2.9000000000000001E-2}]
[null,{"$f":"+B12","v":25},null,500,{"$f":"ROUND((B$11*D13),0)","v":12500},null,{"$f":"ROUND(+O$10+IF(E13>20000,20000*O$15+(E13-20000)*O$19,E13*O$15)+IF(B13>50,(B13-50)*O$25,0),0)","v":856},null,{"$f":"ROUND(+Q$10+IF(E13>20000,20000*Q$15+(E13-20000)*Q$19,E13*Q$15)+IF(B13>50,(B13-50)*Q$25,0),0)","v":881},null,{"$f":"ROUND((I13-G13)/G13,4)","v":2.92E-2},null,null,"Winter kWh - First 20,000",{"$f":"SUM(O32,O44:O50,O53,O57:O59)","v":9.1599797894671528E-2},{"$f":"+N13","v":"Winter kWh - First 20,000"},{"$f":"SUM(Q32,Q44:Q50,Q53,Q57:Q59)","v":9.4855461000000002E-2},null,{"$f":"(Q13-O13)/O13","v":3.5542252059028397E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer kWh - First 20,000",{"$f":"SUM(O33,O44:O50,O54,O57:O59)","v":6.3695797894671544E-2},{"$f":"+N14","v":"Summer kWh - First 20,000"},{"$f":"SUM(Q33,Q44:Q50,Q54,Q57:Q59)","v":6.5664461000000007E-2},null,{"$f":"(Q14-O14)/O14","v":3.0907268146383511E-2}]
[null,50,null,200,{"$f":"ROUND((B$15*D15),0)","v":10000},null,{"$f":"ROUND(+O$10+IF(E15>20000,20000*O$15+(E15-20000)*O$19,E15*O$15)+IF(B15>50,(B15-50)*O$25,0),0)","v":687},null,{"$f":"ROUND(+Q$10+IF(E15>20000,20000*Q$15+(E15-20000)*Q$19,E15*Q$15)+IF(B15>50,(B15-50)*Q$25,0),0)","v":707},null,{"$f":"ROUND((I15-G15)/G15,4)","v":2.9100000000000001E-2},null,null,"Average kWh",{"$f":"SUM(O34,O44:O50,O57:O59)+AVERAGE(O53:O54)","v":6.7666297894671532E-2},{"$f":"+N15","v":"Average kWh"},{"$f":"SUM(Q34,Q44:Q50,Q57:Q59)+AVERAGE(Q53:Q54)","v":6.9667461E-2},null,{"$f":"(Q15-O15)/O15","v":2.9574000168347506E-2}]
[null,{"$f":"+B15","v":50},null,300,{"$f":"ROUND((B$15*D16),0)","v":15000},null,{"$f":"ROUND(+O$10+IF(E16>20000,20000*O$15+(E16-20000)*O$19,E16*O$15)+IF(B16>50,(B16-50)*O$25,0),0)","v":1025},null,{"$f":"ROUND(+Q$10+IF(E16>20000,20000*Q$15+(E16-20000)*Q$19,E16*Q$15)+IF(B16>50,(B16-50)*Q$25,0),0)","v":1055},null,{"$f":"ROUND((I16-G16)/G16,4)","v":2.93E-2}]
[null,{"$f":"+B16","v":50},null,500,{"$f":"ROUND((B$15*D17),0)","v":25000},null,{"$f":"ROUND(+O$10+IF(E17>20000,20000*O$15+(E17-20000)*O$19,E17*O$15)+IF(B17>50,(B17-50)*O$25,0),0)","v":1641},null,{"$f":"ROUND(+Q$10+IF(E17>20000,20000*Q$15+(E17-20000)*Q$19,E17*Q$15)+IF(B17>50,(B17-50)*Q$25,0),0)","v":1689},null,{"$f":"ROUND((I17-G17)/G17,4)","v":2.93E-2},null,null,"Winter kWh - Over 20,000",{"$f":"SUM(O35,O44:O50,O55,O57:O59)","v":6.9741797894671512E-2},{"$f":"+N17","v":"Winter kWh - Over 20,000"},{"$f":"SUM(Q35,Q44:Q50,Q55,Q57:Q59)","v":7.1989461000000005E-2},null,{"$f":"(Q17-O17)/O17","v":3.2228350475321216E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer kWh - Over 20,000",{"$f":"SUM(O36,O44:O50,O56,O57:O59)","v":5.4680797894671528E-2},{"$f":"+N18","v":"Summer kWh - Over 20,000"},{"$f":"SUM(Q36,Q44:Q50,Q56,Q57:Q59)","v":5.6233460999999998E-2},null,{"$f":"(Q18-O18)/O18","v":2.8395033816428144E-2}]
[null,75,null,200,{"$f":"ROUND((B$15*D19),0)","v":10000},null,{"$f":"ROUND(+O$10+IF(E19>20000,20000*O$15+(E19-20000)*O$19,E19*O$15)+IF(B19>50,(B19-50)*O$25,0),0)","v":836},null,{"$f":"ROUND(+Q$10+IF(E19>20000,20000*Q$15+(E19-20000)*Q$19,E19*Q$15)+IF(B19>50,(B19-50)*Q$25,0),0)","v":865},null,{"$f":"ROUND((I19-G19)/G19,4)","v":3.4700000000000002E-2},null,null,"kWh - All Over 20,000",{"$f":"SUM(O37,O44:O50,O57:O59)+AVERAGE(O55:O56)","v":5.5518797894671526E-2},{"$f":"+N19","v":"kWh - All Over 20,000"},{"$f":"SUM(Q37,Q44:Q50,Q57:Q59)+AVERAGE(Q55:Q56)","v":5.7009460999999997E-2},null,{"$f":"(Q19-O19)/O19","v":2.684970067537322E-2}]
[null,{"$f":"+B19","v":75},null,300,{"$f":"ROUND((B$15*D20),0)","v":15000},null,{"$f":"ROUND(+O$10+IF(E20>20000,20000*O$15+(E20-20000)*O$19,E20*O$15)+IF(B20>50,(B20-50)*O$25,0),0)","v":1174},null,{"$f":"ROUND(+Q$10+IF(E20>20000,20000*Q$15+(E20-20000)*Q$19,E20*Q$15)+IF(B20>50,(B20-50)*Q$25,0),0)","v":1213},null,{"$f":"ROUND((I20-G20)/G20,4)","v":3.32E-2}]
[null,{"$f":"+B20","v":75},null,500,{"$f":"ROUND((B$15*D21),0)","v":25000},null,{"$f":"ROUND(+O$10+IF(E21>20000,20000*O$15+(E21-20000)*O$19,E21*O$15)+IF(B21>50,(B21-50)*O$25,0),0)","v":1790},null,{"$f":"ROUND(+Q$10+IF(E21>20000,20000*Q$15+(E21-20000)*Q$19,E21*Q$15)+IF(B21>50,(B21-50)*Q$25,0),0)","v":1847},null,{"$f":"ROUND((I21-G21)/G21,4)","v":3.1800000000000002E-2},null,null,"kW - First 50",0,{"$f":"+N21","v":"kW - First 50"},0]
[]
[null,"Three Phase",null,null,null,null,null,null,null,null,null,null,null,"Winter kW - Over 50",{"$f":"SUM(O39)","v":8.83},{"$f":"+N23","v":"Winter kW - Over 50"},{"$f":"SUM(Q39)","v":9.3699999999999992},null,{"$f":"(Q23-O23)/O23","v":6.1155152887882119E-2}]
[null,100,null,200,{"$f":"ROUND((B$24*D24),0)","v":20000},null,{"$f":"ROUND(+O$11+IF(E24>20000,20000*O$15+(E24-20000)*O$19,E24*O$15)+IF(B24>50,(B24-50)*O$25,0),0)","v":1677},null,{"$f":"ROUND(+Q$11+IF(E24>20000,20000*Q$15+(E24-20000)*Q$19,E24*Q$15)+IF(B24>50,(B24-50)*Q$25,0),0)","v":1736},null,{"$f":"ROUND((I24-G24)/G24,4)","v":3.5200000000000002E-2},null,null,"Summer kW - Over 50",{"$f":"SUM(O40)","v":4.3499999999999996},{"$f":"+N24","v":"Summer kW - Over 50"},{"$f":"SUM(Q40)","v":4.62},null,{"$f":"(Q24-O24)/O24","v":6.2068965517241489E-2}]
[null,{"$f":"+B24","v":100},null,300,{"$f":"ROUND((B$24*D25),0)","v":30000},null,{"$f":"ROUND(+O$11+IF(E25>20000,20000*O$15+(E25-20000)*O$19,E25*O$15)+IF(B25>50,(B25-50)*O$25,0),0)","v":2232},null,{"$f":"ROUND(+Q$11+IF(E25>20000,20000*Q$15+(E25-20000)*Q$19,E25*Q$15)+IF(B25>50,(B25-50)*Q$25,0),0)","v":2306},null,{"$f":"ROUND((I25-G25)/G25,4)","v":3.32E-2},null,null,"Average kW - Over 50",{"$f":"SUM(O41)","v":5.96},{"$f":"+N25","v":"Average kW - Over 50"},{"$f":"SUM(Q41)","v":6.33},null,{"$f":"(Q25-O25)/O25","v":6.2080536912751699E-2}]
[null,{"$f":"+B25","v":100},null,500,{"$f":"ROUND((B$24*D26),0)","v":50000},null,{"$f":"ROUND(+O$11+IF(E26>20000,20000*O$15+(E26-20000)*O$19,E26*O$15)+IF(B26>50,(B26-50)*O$25,0),0)","v":3342},null,{"$f":"ROUND(+Q$11+IF(E26>20000,20000*Q$15+(E26-20000)*Q$19,E26*Q$15)+IF(B26>50,(B26-50)*Q$25,0),0)","v":3446},null,{"$f":"ROUND((I26-G26)/G26,4)","v":3.1099999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"kVarh",{"$f":"SUM(O42)","v":2.81E-3},{"$f":"+N27","v":"kVarh"},{"$f":"SUM(Q42)","v":2.98E-3},null,{"$f":"(Q27-O27)/O27","v":6.0498220640569401E-2}]
[null,150,null,200,{"$f":"ROUND((B$28*D28),0)","v":30000},null,{"$f":"ROUND(+O$11+IF(E28>20000,20000*O$15+(E28-20000)*O$19,E28*O$15)+IF(B28>50,(B28-50)*O$25,0),0)","v":2530},null,{"$f":"ROUND(+Q$11+IF(E28>20000,20000*Q$15+(E28-20000)*Q$19,E28*Q$15)+IF(B28>50,(B28-50)*Q$25,0),0)","v":2622},null,{"$f":"ROUND((I28-G28)/G28,4)","v":3.6400000000000002E-2},null,null," "," "," "," "]
[null,{"$f":"+B28","v":150},null,300,{"$f":"ROUND((B$28*D29),0)","v":45000},null,{"$f":"ROUND(+O$11+IF(E29>20000,20000*O$15+(E29-20000)*O$19,E29*O$15)+IF(B29>50,(B29-50)*O$25,0),0)","v":3363},null,{"$f":"ROUND(+Q$11+IF(E29>20000,20000*Q$15+(E29-20000)*Q$19,E29*Q$15)+IF(B29>50,(B29-50)*Q$25,0),0)","v":3477},null,{"$f":"ROUND((I29-G29)/G29,4)","v":3.39E-2}]
[null,{"$f":"+B29","v":150},null,500,{"$f":"ROUND((B$28*D30),0)","v":75000},null,{"$f":"ROUND(+O$11+IF(E30>20000,20000*O$15+(E30-20000)*O$19,E30*O$15)+IF(B30>50,(B30-50)*O$25,0),0)","v":5028},null,{"$f":"ROUND(+Q$11+IF(E30>20000,20000*Q$15+(E30-20000)*Q$19,E30*Q$15)+IF(B30>50,(B30-50)*Q$25,0),0)","v":5188},null,{"$f":"ROUND((I30-G30)/G30,4)","v":3.1800000000000002E-2},null,null,{"$f":"+N10","v":"Basic Charge (1 Phase)"},9.56,null,10.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N11","v":"Basic Charge (3 Phase)"},24.28,null,25.77]
[null,200,null,200,{"$f":"ROUND((B$32*D32),0)","v":40000},null,{"$f":"ROUND(+O$11+IF(E32>20000,20000*O$15+(E32-20000)*O$19,E32*O$15)+IF(B32>50,(B32-50)*O$25,0),0)","v":3383},null,{"$f":"ROUND(+Q$11+IF(E32>20000,20000*Q$15+(E32-20000)*Q$19,E32*Q$15)+IF(B32>50,(B32-50)*Q$25,0),0)","v":3509},null,{"$f":"ROUND((I32-G32)/G32,4)","v":3.7199999999999997E-2},null,null,{"$f":"+N13","v":"Winter kWh - First 20,000"},8.9582999999999996E-2,null,9.5068E-2]
[null,{"$f":"+B32","v":200},null,300,{"$f":"ROUND((B$32*D33),0)","v":60000},null,{"$f":"ROUND(+O$11+IF(E33>20000,20000*O$15+(E33-20000)*O$19,E33*O$15)+IF(B33>50,(B33-50)*O$25,0),0)","v":4494},null,{"$f":"ROUND(+Q$11+IF(E33>20000,20000*Q$15+(E33-20000)*Q$19,E33*Q$15)+IF(B33>50,(B33-50)*Q$25,0),0)","v":4649},null,{"$f":"ROUND((I33-G33)/G33,4)","v":3.4500000000000003E-2},null,null,{"$f":"+N14","v":"Summer kWh - First 20,000"},6.2075999999999999E-2,null,6.5877000000000005E-2]
[null,{"$f":"+B33","v":200},null,500,{"$f":"ROUND((B$32*D34),0)","v":100000},null,{"$f":"ROUND(+O$11+IF(E34>20000,20000*O$15+(E34-20000)*O$19,E34*O$15)+IF(B34>50,(B34-50)*O$25,0),0)","v":6714},null,{"$f":"ROUND(+Q$11+IF(E34>20000,20000*Q$15+(E34-20000)*Q$19,E34*Q$15)+IF(B34>50,(B34-50)*Q$25,0),0)","v":6929},null,{"$f":"ROUND((I34-G34)/G34,4)","v":3.2000000000000001E-2},null,null,{"$f":"+N15","v":"Average kWh"},6.5848000000000004E-2,null,6.9879999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N17","v":"Winter kWh - Over 20,000"},6.8035999999999999E-2,null,7.2202000000000002E-2]
[null,300,null,200,{"$f":"ROUND((B$36*D36),0)","v":60000},null,{"$f":"ROUND(+O$11+IF(E36>20000,20000*O$15+(E36-20000)*O$19,E36*O$15)+IF(B36>50,(B36-50)*O$25,0),0)","v":5090},null,{"$f":"ROUND(+Q$11+IF(E36>20000,20000*Q$15+(E36-20000)*Q$19,E36*Q$15)+IF(B36>50,(B36-50)*Q$25,0),0)","v":5282},null,{"$f":"ROUND((I36-G36)/G36,4)","v":3.7699999999999997E-2},null,null,{"$f":"+N18","v":"Summer kWh - Over 20,000"},5.3189E-2,null,5.6446000000000003E-2]
[null,{"$f":"+B36","v":300},null,300,{"$f":"ROUND((B$36*D37),0)","v":90000},null,{"$f":"ROUND(+O$11+IF(E37>20000,20000*O$15+(E37-20000)*O$19,E37*O$15)+IF(B37>50,(B37-50)*O$25,0),0)","v":6755},null,{"$f":"ROUND(+Q$11+IF(E37>20000,20000*Q$15+(E37-20000)*Q$19,E37*Q$15)+IF(B37>50,(B37-50)*Q$25,0),0)","v":6992},null,{"$f":"ROUND((I37-G37)/G37,4)","v":3.5099999999999999E-2},null,null,{"$f":"+N19","v":"kWh - All Over 20,000"},5.3920000000000003E-2,null,5.7222000000000002E-2]
[null,{"$f":"+B37","v":300},null,500,{"$f":"ROUND((B$36*D38),0)","v":150000},null,{"$f":"ROUND(+O$11+IF(E38>20000,20000*O$15+(E38-20000)*O$19,E38*O$15)+IF(B38>50,(B38-50)*O$25,0),0)","v":10086},null,{"$f":"ROUND(+Q$11+IF(E38>20000,20000*Q$15+(E38-20000)*Q$19,E38*Q$15)+IF(B38>50,(B38-50)*Q$25,0),0)","v":10413},null,{"$f":"ROUND((I38-G38)/G38,4)","v":3.2399999999999998E-2},null,null,{"$f":"+N21","v":"kW - First 50"},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N23","v":"Winter kW - Over 50"},8.83,null,9.3699999999999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N24","v":"Summer kW - Over 50"},4.3499999999999996,null,4.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N25","v":"Average kW - Over 50"},5.96,null,6.33]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N27","v":"kVarh"},2.81E-3,null,2.98E-3]
[null," 1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141, 142 and 194"]
[null," 2 Average Non-Seasonal Energy and Demand Rates",null,null,null,null,null,null,null,null,null,null,null,"Schedule 95 - PCA",-2.8826631053284735E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 95A - Fed Inc Credit",-2.0830000000000002E-3,null,{"$f":"+O45","v":-2.0830000000000002E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 120 - Conservation",4.5799999999999999E-3,null,4.5799999999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 129 - Low Income",7.0699999999999995E-4,null,7.0699999999999995E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 132 - Merger Credit",-2.4000000000000001E-4,null,-2.4000000000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 137 - REC",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 140 - Property Tax",2.2820000000000002E-3,null,2.2820000000000002E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Basic 1 Phase",0.48,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Basic 3 phase",1.22,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Winter kWh First 20,000",1.291E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Summer kWh First 20,000",8.9400000000000005E-4,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Winter kWh Over 20,000",9.7999999999999997E-4,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Summer kWh Over 20,000",7.6599999999999997E-4,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling",5.1560000000000009E-3,null,1.335E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 149 - CRM",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 194 - BPA Exchange Credit",-6.7935390000000003E-3,null,{"$f":"+O59","v":-6.7935390000000003E-3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall:",6.1264992362091313E-2]

{"sheet":"Exhibit No.__(JAP-Sch 31 Imp)","index":8,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,6,5,8],[7,13,7,14],[7,15,7,16]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 31"]
[null,"Primary Voltage General Service"]
[]
[null,"kW",null,null,null,null,"Monthly Billing 1, 2"]
[null,"Load Size/",null,"kWh per kW",null,null,"Present ",null,"Proposed",null,"Percent"]
[null,"Demand",null,"(Equiv Hours)","kWh",null,"Schedule 31",null,"Schedule 31",null,"Difference",null,null,"Net Present Price",null,"Net Proposed Price"]
[]
[null,350,null,300,{"$f":"ROUND((B$10*D10),0)","v":105000},null,{"$f":"+O$10+$B10*O$16+$E10*O$12","v":10115.655082192658},null,{"$f":"+Q$10+$B10*Q$16+$E10*Q$12","v":10433.185482603825},null,{"$f":"ROUND((+I10-G10)/G10,3)","v":3.1E-2},null,null,"Basic Charge",{"$f":"SUM(O21,O35)","v":356.90999999999997},{"$f":"+N10","v":"Basic Charge"},{"$f":"SUM(Q21,Q35)","v":360.3},null,{"$f":"(Q10-O10)/O10","v":9.4981928217198839E-3}]
[null,{"$f":"+B10","v":350},null,500,{"$f":"ROUND((B$10*D11),0)","v":175000},null,{"$f":"+O$10+$B11*O$16+$E11*O$12","v":14078.151803654431},null,{"$f":"+Q$10+$B11*Q$16+$E11*Q$12","v":14833.775804339708},null,{"$f":"ROUND((+I11-G11)/G11,3)","v":5.3999999999999999E-2}]
[null,{"$f":"+B11","v":350},null,700,{"$f":"ROUND((B$10*D12),0)","v":245000},null,{"$f":"+O$10+$B12*O$16+$E12*O$12","v":18040.648525116201},null,{"$f":"+Q$10+$B12*Q$16+$E12*Q$12","v":19234.366126075594},null,{"$f":"ROUND((+I12-G12)/G12,3)","v":6.6000000000000003E-2},null,null,"kWh - All",{"$f":"SUM(O22,O28:O34,O40)","v":5.6607096020882465E-2},{"$f":"+N12","v":"kWh - All"},{"$f":"SUM(Q22,Q28:Q34,Q40)","v":6.2865576024798336E-2},null,{"$f":"(Q12-O12)/O12","v":0.110559990599184}]
[]
[null,{"$f":"+B12+50","v":400},null,300,{"$f":"ROUND((B$14*D14),0)","v":120000},null,{"$f":"+O$10+$B14*O$16+$E14*O$12","v":11509.761522505894},null,{"$f":"+Q$10+$B14*Q$16+$E14*Q$12","v":11872.1691229758},null,{"$f":"ROUND((+I14-G14)/G14,3)","v":3.1E-2},null,null,"Winter kW",{"$f":"SUM(O23,O36,O39:O39)","v":12.899999999999999},{"$f":"+N14","v":"Winter kW"},{"$f":"SUM(Q23,Q36,Q39:Q39)","v":11.97},null,{"$f":"(Q14-O14)/O14","v":-7.2093023255813807E-2}]
[null,{"$f":"+B14","v":400},null,500,{"$f":"ROUND((B$14*D15),0)","v":200000},null,{"$f":"+O$10+$B15*O$16+$E15*O$12","v":16038.329204176493},null,{"$f":"+Q$10+$B15*Q$16+$E15*Q$12","v":16901.415204959667},null,{"$f":"ROUND((+I15-G15)/G15,3)","v":5.3999999999999999E-2},null,null,"Summer kW",{"$f":"SUM(O24,O37,O39:O39)","v":8.9799999999999986},{"$f":"+N15","v":"Summer kW"},{"$f":"SUM(Q24,Q37,Q39:Q39)","v":7.97},null,{"$f":"(Q15-O15)/O15","v":-0.11247216035634733}]
[null,{"$f":"+B15","v":400},null,700,{"$f":"ROUND((B$14*D16),0)","v":280000},null,{"$f":"+O$10+$B16*O$16+$E16*O$12","v":20566.896885847091},null,{"$f":"+Q$10+$B16*Q$16+$E16*Q$12","v":21930.661286943534},null,{"$f":"ROUND((+I16-G16)/G16,3)","v":6.6000000000000003E-2},null,null,"Average kW",{"$f":"ROUND(SUM(O25,O39:O39)+AVERAGE(O36:O37),2)","v":10.9},{"$f":"+N16","v":"Average kW"},{"$f":"ROUND(SUM(Q25,Q39:Q39)+AVERAGE(Q36:Q37),2)","v":9.92},null,{"$f":"(Q16-O16)/O16","v":-8.9908256880733978E-2}]
[]
[null,{"$f":"+B16+100","v":500},null,300,{"$f":"ROUND((B$18*D18),0)","v":150000},null,{"$f":"+O$10+$B18*O$16+$E18*O$12","v":14297.97440313237},null,{"$f":"+Q$10+$B18*Q$16+$E18*Q$12","v":14750.136403719749},null,{"$f":"ROUND((+I18-G18)/G18,3)","v":3.2000000000000001E-2},null,null,"kVarh",{"$f":"SUM(O26,O38)","v":1.09E-3},{"$f":"+N18","v":"kVarh"},{"$f":"SUM(Q26,Q38)","v":1.1199999999999999E-3},null,{"$f":"(Q18-O18)/O18","v":2.7522935779816387E-2}]
[null,{"$f":"+B18","v":500},null,500,{"$f":"ROUND((B$18*D19),0)","v":250000},null,{"$f":"+O$10+$B19*O$16+$E19*O$12","v":19958.684005220617},null,{"$f":"+Q$10+$B19*Q$16+$E19*Q$12","v":21036.694006199585},null,{"$f":"ROUND((+I19-G19)/G19,3)","v":5.3999999999999999E-2},null,null," "," "," "," "]
[null,{"$f":"+B19","v":500},null,700,{"$f":"ROUND((B$18*D20),0)","v":350000},null,{"$f":"+O$10+$B20*O$16+$E20*O$12","v":25619.393607308863},null,{"$f":"+Q$10+$B20*Q$16+$E20*Q$12","v":27323.251608679417},null,{"$f":"ROUND((+I20-G20)/G20,3)","v":6.7000000000000004E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N10","v":"Basic Charge"},339.51,null,360.3]
[null,{"$f":"+B20+100","v":600},null,300,{"$f":"ROUND((B$22*D22),0)","v":180000},null,{"$f":"+O$10+$B22*O$16+$E22*O$12","v":17086.187283758845},null,{"$f":"+Q$10+$B22*Q$16+$E22*Q$12","v":17628.103684463702},null,{"$f":"ROUND((+I22-G22)/G22,3)","v":3.2000000000000001E-2},null,null,{"$f":"+N12","v":"kWh - All"},5.4346999999999999E-2,null,5.7683000000000005E-2]
[null,{"$f":"+B22","v":600},null,500,{"$f":"ROUND((B$22*D23),0)","v":300000},null,{"$f":"+O$10+$B23*O$16+$E23*O$12","v":23879.03880626474},null,{"$f":"+Q$10+$B23*Q$16+$E23*Q$12","v":25171.972807439499},null,{"$f":"ROUND((+I23-G23)/G23,3)","v":5.3999999999999999E-2},null,null,{"$f":"+N14","v":"Winter kW"},11.32,null,12.01]
[null,{"$f":"+B23","v":600},null,700,{"$f":"ROUND((B$22*D24),0)","v":420000},null,{"$f":"+O$10+$B24*O$16+$E24*O$12","v":30671.890328770634},null,{"$f":"+Q$10+$B24*Q$16+$E24*Q$12","v":32715.841930415299},null,{"$f":"ROUND((+I24-G24)/G24,3)","v":6.7000000000000004E-2},null,null,{"$f":"+N15","v":"Summer kW"},7.55,null,8.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average kW",9.39,null,9.9600000000000009]
[null,{"$f":"+B24+100","v":700},null,300,{"$f":"ROUND((B$26*D26),0)","v":210000},null,{"$f":"+O$10+$B26*O$16+$E26*O$12","v":19874.400164385319},null,{"$f":"+Q$10+$B26*Q$16+$E26*Q$12","v":20506.070965207651},null,{"$f":"ROUND((+I26-G26)/G26,3)","v":3.2000000000000001E-2},null,null,{"$f":"+N18","v":"kVarh"},1.06E-3,null,1.1199999999999999E-3]
[null,{"$f":"+B26","v":700},null,500,{"$f":"ROUND((B$26*D27),0)","v":350000},null,{"$f":"+O$10+$B27*O$16+$E27*O$12","v":27799.393607308863},null,{"$f":"+Q$10+$B27*Q$16+$E27*Q$12","v":29307.251608679417},null,{"$f":"ROUND((+I27-G27)/G27,3)","v":5.3999999999999999E-2}]
[null,{"$f":"+B27","v":700},null,700,{"$f":"ROUND((B$26*D28),0)","v":490000},null,{"$f":"+O$10+$B28*O$16+$E28*O$12","v":35724.387050232406},null,{"$f":"+Q$10+$B28*Q$16+$E28*Q$12","v":38108.432252151186},null,{"$f":"ROUND((+I28-G28)/G28,3)","v":6.7000000000000004E-2},null,null,"Schedule 95 - PCA",-2.8609039791175355E-3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 95A - Fed Inc Credit",-2.065E-3,null,{"$f":"+O29","v":-2.065E-3}]
[null,{"$f":"+B28+100","v":800},null,300,{"$f":"ROUND((B$30*D30),0)","v":240000},null,{"$f":"+O$10+$B30*O$16+$E30*O$12","v":22662.613045011793},null,{"$f":"+Q$10+$B30*Q$16+$E30*Q$12","v":23384.0382459516},null,{"$f":"ROUND((+I30-G30)/G30,3)","v":3.2000000000000001E-2},null,null,"Schedule 120 - Conservation",4.5519999999999996E-3,null,4.5519999999999996E-3]
[null,{"$f":"+B30","v":800},null,500,{"$f":"ROUND((B$30*D31),0)","v":400000},null,{"$f":"+O$10+$B31*O$16+$E31*O$12","v":31719.748408352985},null,{"$f":"+Q$10+$B31*Q$16+$E31*Q$12","v":33442.530409919331},null,{"$f":"ROUND((+I31-G31)/G31,3)","v":5.3999999999999999E-2},null,null,"Schedule 129 - Low Income",7.0500000000000001E-4,null,7.0500000000000001E-4]
[null,{"$f":"+B31","v":800},null,700,{"$f":"ROUND((B$30*D32),0)","v":560000},null,{"$f":"+O$10+$B32*O$16+$E32*O$12","v":40776.883771694178},null,{"$f":"+Q$10+$B32*Q$16+$E32*Q$12","v":43501.022573887065},null,{"$f":"ROUND((+I32-G32)/G32,3)","v":6.7000000000000004E-2},null,null,"Schedule 132 - Merger Credit",-2.34E-4,null,-2.34E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 137 - REC",0,null,0]
[null,{"$f":"+B32+200","v":1000},null,300,{"$f":"ROUND((B$34*D34),0)","v":300000},null,{"$f":"+O$10+$B34*O$16+$E34*O$12","v":28239.03880626474},null,{"$f":"+Q$10+$B34*Q$16+$E34*Q$12","v":29139.972807439499},null,{"$f":"ROUND((+I34-G34)/G34,3)","v":3.2000000000000001E-2},null,null,"Schedule 140 - Property Tax",2.163E-3,null,2.163E-3]
[null,{"$f":"+B34","v":1000},null,500,{"$f":"ROUND((B$34*D35),0)","v":500000},null,{"$f":"+O$10+$B35*O$16+$E35*O$12","v":39560.458010441231},null,{"$f":"+Q$10+$B35*Q$16+$E35*Q$12","v":41713.088012399166},null,{"$f":"ROUND((+I35-G35)/G35,3)","v":5.3999999999999999E-2},null,null,"Schedule 141 - ERF - Basic",17.399999999999999,null,0]
[null,{"$f":"+B35","v":1000},null,700,{"$f":"ROUND((B$34*D36),0)","v":700000},null,{"$f":"+O$10+$B36*O$16+$E36*O$12","v":50881.877214617722},null,{"$f":"+Q$10+$B36*Q$16+$E36*Q$12","v":54286.203217358838},null,{"$f":"ROUND((+I36-G36)/G36,3)","v":6.7000000000000004E-2},null,null,"Schedule 141 - ERF - Demand Winter",0.45,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Demand Summer",0.3,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 141 - ERF - Reactive Power",3.0000000000000001E-5,null,0]
[null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling kW",1.129999999999999,null,-0.04]
[null," 1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141 and 142",null,null,null,null,null,null,null,null,null,null,null,"Schedule 149 - CRM",0,null,6.1576024798322556E-5]
[null," 2 Average Non-Seasonal Energy and Demand Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall:",6.1216654179653648E-2]

{"sheet":"Exhibit No.__(JAP-Sch 46 Imp)","index":9,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[8,6,8,8]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 46 - Interruptible Service -High Voltage"]
[]
[]
[]
[]
[]
[null,"kVa",null,null,null,null,"Monthly Billing 1"]
[null,"Load Size/","kWh per kVa",null,null,null,"Present",null,"Proposed ",null,"Percent"]
[null,"Demand","(Equiv Hours)",null,"kWh",null,"Price Schedule 46",null,"Price Schedule 46",null,"Difference",null,null,"Net Present Price",null,"Net Proposed Price"]
[]
[null,1000,300,null,{"$f":"ROUND((B$13*C13),0)","v":300000},null,{"$f":"ROUND(IF($B$13>4400,$B$13*N$13,4400*$N$13)+$E13*N$14,0)","v":27447},null,{"$f":"ROUND(IF($B$13>4400,$B$13*P$13,4400*$N$13)+$E13*P$14,0)","v":27993},null,{"$f":"(I13-G13)/G13","v":1.9892884468247895E-2},null,"Demand ($ per kVa)",{"$f":"SUM(N17)","v":2.09},null,{"$f":"SUM(P17)","v":2.2200000000000002},null,{"$f":"(P13-N13)/N13","v":6.2200956937799208E-2}]
[null,null,500,null,{"$f":"ROUND((B$13*C14),0)","v":500000},null,{"$f":"ROUND(IF($B$13>4400,$B$13*N$13,4400*$N$13)+$E14*N$14,0)","v":39614},null,{"$f":"ROUND(IF($B$13>4400,$B$13*P$13,4400*$N$13)+$E14*P$14,0)","v":40525},null,{"$f":"(I14-G14)/G14","v":2.2996920280708839E-2},null,"Energy ($ per kWh)",{"$f":"SUM(N18,N20:N28)","v":6.0836116307137485E-2},null,{"$f":"SUM(P18,P20:P28)","v":6.2657999999999991E-2},null,{"$f":"(P14-N14)/N14","v":2.9947403014099993E-2}]
[null,null,700,null,{"$f":"ROUND((B$13*C15),0)","v":700000},null,{"$f":"ROUND(IF($B$13>4400,$B$13*N$13,4400*$N$13)+$E15*N$14,0)","v":51781},null,{"$f":"ROUND(IF($B$13>4400,$B$13*P$13,4400*$N$13)+$E15*P$14,0)","v":53057},null,{"$f":"(I15-G15)/G15","v":2.4642243293872271E-2},null," "," ",null," "]
[]
[null,2000,300,null,{"$f":"ROUND((B$17*C17),0)","v":600000},null,{"$f":"ROUND(IF($B$17>4400,$B$17*N$13,4400*$N$13)+$E17*N$14,0)","v":45698},null,{"$f":"ROUND(IF($B$17>4400,$B$17*P$13,4400*$N$13)+$E17*P$14,0)","v":46791},null,{"$f":"(I17-G17)/G17","v":2.3917895750361066E-2},null,{"$f":"+M13","v":"Demand ($ per kVa)"},2.09,null,2.2200000000000002]
[null,null,500,null,{"$f":"ROUND((B$17*C18),0)","v":1000000},null,{"$f":"ROUND(IF($B$17>4400,$B$17*N$13,4400*$N$13)+$E18*N$14,0)","v":70032},null,{"$f":"ROUND(IF($B$17>4400,$B$17*P$13,4400*$N$13)+$E18*P$14,0)","v":71854},null,{"$f":"(I18-G18)/G18","v":2.6016678090015993E-2},null,{"$f":"+M14","v":"Energy ($ per kWh)"},5.4413000000000003E-2,null,5.7734999999999995E-2]
[null,null,700,null,{"$f":"ROUND((B$17*C19),0)","v":1400000},null,{"$f":"ROUND(IF($B$17>4400,$B$17*N$13,4400*$N$13)+$E19*N$14,0)","v":94367},null,{"$f":"ROUND(IF($B$17>4400,$B$17*P$13,4400*$N$13)+$E19*P$14,0)","v":96917},null,{"$f":"(I19-G19)/G19","v":2.7022158169699155E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 95 - PCA",-2.6768836928625197E-3,null,0]
[null,4000,300,null,{"$f":"ROUND((B$21*C21),0)","v":1200000},null,{"$f":"ROUND(IF($B$21>4400,$B$21*N$13,4400*$N$13)+$E21*N$14,0)","v":82199},null,{"$f":"ROUND(IF($B$21>4400,$B$21*P$13,4400*$N$13)+$E21*P$14,0)","v":84386},null,{"$f":"(I21-G21)/G21","v":2.6606163092008417E-2},null,"Schedule 95A - Fed Inc Credit",-1.3159999999999999E-3,null,{"$f":"+N21","v":-1.3159999999999999E-3}]
[null,null,500,null,{"$f":"ROUND((B$21*C22),0)","v":2000000},null,{"$f":"ROUND(IF($B$21>4400,$B$21*N$13,4400*$N$13)+$E22*N$14,0)","v":130868},null,{"$f":"ROUND(IF($B$21>4400,$B$21*P$13,4400*$N$13)+$E22*P$14,0)","v":134512},null,{"$f":"(I22-G22)/G22","v":2.7844851300547115E-2},null,"Schedule 120 - Conservation",2.9169999999999999E-3,null,2.9169999999999999E-3]
[null,null,700,null,{"$f":"ROUND((B$21*C23),0)","v":2800000},null,{"$f":"ROUND(IF($B$21>4400,$B$21*N$13,4400*$N$13)+$E23*N$14,0)","v":179537},null,{"$f":"ROUND(IF($B$21>4400,$B$21*P$13,4400*$N$13)+$E23*P$14,0)","v":184638},null,{"$f":"(I23-G23)/G23","v":2.8411970791536005E-2},null,"Schedule 129 - Low Income",6.0999999999999997E-4,null,6.0999999999999997E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 132 - Merger Credit",-8.5000000000000006E-5,null,-8.5000000000000006E-5]
[null,6000,300,null,{"$f":"ROUND((B$25*C25),0)","v":1800000},null,{"$f":"ROUND(IF($B$25>4400,$B$25*N$13,4400*$N$13)+$E25*N$14,0)","v":122045},null,{"$f":"ROUND(IF($B$25>4400,$B$25*P$13,4400*$N$13)+$E25*P$14,0)","v":126104},null,{"$f":"(I25-G25)/G25","v":3.3258224425416857E-2},null,"Schedule 137 - REC",0,null,0]
[null,null,500,null,{"$f":"ROUND((B$25*C26),0)","v":3000000},null,{"$f":"ROUND(IF($B$25>4400,$B$25*N$13,4400*$N$13)+$E26*N$14,0)","v":195048},null,{"$f":"ROUND(IF($B$25>4400,$B$25*P$13,4400*$N$13)+$E26*P$14,0)","v":201294},null,{"$f":"(I26-G26)/G26","v":3.2022886674049462E-2},null,"Schedule 140 - Property Tax",1.4620000000000002E-3,null,1.4620000000000002E-3]
[null,null,700,null,{"$f":"ROUND((B$25*C27),0)","v":4200000},null,{"$f":"ROUND(IF($B$25>4400,$B$25*N$13,4400*$N$13)+$E27*N$14,0)","v":268052},null,{"$f":"ROUND(IF($B$25>4400,$B$25*P$13,4400*$N$13)+$E27*P$14,0)","v":276484},null,{"$f":"(I27-G27)/G27","v":3.14565830510498E-2},null,"Schedule 141 - ERF - Energy",3.5599999999999998E-4,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling kWh",5.1560000000000009E-3,null,1.335E-3]
[null,8000,300,null,{"$f":"ROUND((B$29*C29),0)","v":2400000},null,{"$f":"ROUND(IF($B$29>4400,$B$29*N$13,4400*$N$13)+$E29*N$14,0)","v":162727},null,{"$f":"ROUND(IF($B$29>4400,$B$29*P$13,4400*$N$13)+$E29*P$14,0)","v":168139},null,{"$f":"(I29-G29)/G29","v":3.3258156298585972E-2}]
[null,null,500,null,{"$f":"ROUND((B$29*C30),0)","v":4000000},null,{"$f":"ROUND(IF($B$29>4400,$B$29*N$13,4400*$N$13)+$E30*N$14,0)","v":260064},null,{"$f":"ROUND(IF($B$29>4400,$B$29*P$13,4400*$N$13)+$E30*P$14,0)","v":268392},null,{"$f":"(I30-G30)/G30","v":3.2022886674049462E-2}]
[null,null,700,null,{"$f":"ROUND((B$29*C31),0)","v":5600000},null,{"$f":"ROUND(IF($B$29>4400,$B$29*N$13,4400*$N$13)+$E31*N$14,0)","v":357402},null,{"$f":"ROUND(IF($B$29>4400,$B$29*P$13,4400*$N$13)+$E31*P$14,0)","v":368645},null,{"$f":"(I31-G31)/G31","v":3.1457574384026951E-2}]
[]
[null,10000,300,null,{"$f":"ROUND((B$33*C33),0)","v":3000000},null,{"$f":"ROUND(IF($B$33>4400,$B$33*N$13,4400*$N$13)+$E33*N$14,0)","v":203408},null,{"$f":"ROUND(IF($B$33>4400,$B$33*P$13,4400*$N$13)+$E33*P$14,0)","v":210174},null,{"$f":"(I33-G33)/G33","v":3.3263195154566196E-2}]
[null,null,500,null,{"$f":"ROUND((B$33*C34),0)","v":5000000},null,{"$f":"ROUND(IF($B$33>4400,$B$33*N$13,4400*$N$13)+$E34*N$14,0)","v":325081},null,{"$f":"ROUND(IF($B$33>4400,$B$33*P$13,4400*$N$13)+$E34*P$14,0)","v":335490},null,{"$f":"(I34-G34)/G34","v":3.2019712010237449E-2}]
[null,null,700,null,{"$f":"ROUND((B$33*C35),0)","v":7000000},null,{"$f":"ROUND(IF($B$33>4400,$B$33*N$13,4400*$N$13)+$E35*N$14,0)","v":446753},null,{"$f":"ROUND(IF($B$33>4400,$B$33*P$13,4400*$N$13)+$E35*P$14,0)","v":460806},null,{"$f":"(I35-G35)/G35","v":3.1455860397132197E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 46 Overall:",6.1244556318382909E-2]
[]
[]
[null,"Notes:"]
[null," 1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141 and 142"]

{"sheet":"Exhibit No.__(JAP-Sch 49 Imp)","index":10,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[8,6,8,8]]}
[null,"Puget Sound Energy"]
[null,"Monthly Billing Comparison"]
[null,"Schedule 49 - Large General Service -High Voltage"]
[]
[]
[]
[]
[]
[null,"kVa",null,null,null,null,"Monthly Billing 1"]
[null,"Load Size/","kWh per kVa",null,null,null,"Present",null,"Proposed ",null,"Percent"]
[null,"Demand","(Equiv Hours)",null,"kWh",null,"Price Schedule 49",null,"Price Schedule 49",null,"Difference",null,null,"Net Present Price",null,"Net Proposed Price"]
[]
[null,1000,300,null,{"$f":"ROUND((B$13*C13),0)","v":300000},null,{"$f":"ROUND(IF($B$13>4400,$B$13*N$13,4400*$N$13)+$E13*N$14,0)","v":35072},null,{"$f":"ROUND(IF($B$13>4400,$B$13*P$13,4400*$N$13)+$E13*P$14,0)","v":35515},null,{"$f":"(I13-G13)/G13","v":1.2631158759124088E-2},null,"Demand ($ per kVa)",{"$f":"SUM(N17)","v":3.7},null,{"$f":"SUM(P17)","v":3.93},null,{"$f":"(P13-N13)/N13","v":6.2162162162162152E-2}]
[null,null,500,null,{"$f":"ROUND((B$13*C14),0)","v":500000},null,{"$f":"ROUND(IF($B$13>4400,$B$13*N$13,4400*$N$13)+$E14*N$14,0)","v":47600},null,{"$f":"ROUND(IF($B$13>4400,$B$13*P$13,4400*$N$13)+$E14*P$14,0)","v":48339},null,{"$f":"(I14-G14)/G14","v":1.5525210084033613E-2},null,"Energy ($ per kWh)",{"$f":"SUM(N18,N20:N28)","v":6.2639630566108426E-2},null,{"$f":"SUM(P18,P20:P28)","v":6.4116999999999993E-2},null,{"$f":"(P14-N14)/N14","v":2.3585219461541778E-2}]
[null,null,700,null,{"$f":"ROUND((B$13*C15),0)","v":700000},null,{"$f":"ROUND(IF($B$13>4400,$B$13*N$13,4400*$N$13)+$E15*N$14,0)","v":60128},null,{"$f":"ROUND(IF($B$13>4400,$B$13*P$13,4400*$N$13)+$E15*P$14,0)","v":61162},null,{"$f":"(I15-G15)/G15","v":1.7196647152740819E-2},null," "," ",null," "]
[]
[null,2000,300,null,{"$f":"ROUND((B$17*C17),0)","v":600000},null,{"$f":"ROUND(IF($B$17>4400,$B$17*N$13,4400*$N$13)+$E17*N$14,0)","v":53864},null,{"$f":"ROUND(IF($B$17>4400,$B$17*P$13,4400*$N$13)+$E17*P$14,0)","v":54750},null,{"$f":"(I17-G17)/G17","v":1.6448834100698053E-2},null,{"$f":"+M13","v":"Demand ($ per kVa)"},3.7,null,3.93]
[null,null,500,null,{"$f":"ROUND((B$17*C18),0)","v":1000000},null,{"$f":"ROUND(IF($B$17>4400,$B$17*N$13,4400*$N$13)+$E18*N$14,0)","v":78920},null,{"$f":"ROUND(IF($B$17>4400,$B$17*P$13,4400*$N$13)+$E18*P$14,0)","v":80397},null,{"$f":"(I18-G18)/G18","v":1.8715154586923466E-2},null,{"$f":"+M14","v":"Energy ($ per kWh)"},5.4413000000000003E-2,null,5.7734999999999995E-2]
[null,null,700,null,{"$f":"ROUND((B$17*C19),0)","v":1400000},null,{"$f":"ROUND(IF($B$17>4400,$B$17*N$13,4400*$N$13)+$E19*N$14,0)","v":103975},null,{"$f":"ROUND(IF($B$17>4400,$B$17*P$13,4400*$N$13)+$E19*P$14,0)","v":106044},null,{"$f":"(I19-G19)/G19","v":1.9899014186102428E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 95 - PCA",-2.3323694338915728E-3,null,0]
[null,4000,300,null,{"$f":"ROUND((B$21*C21),0)","v":1200000},null,{"$f":"ROUND(IF($B$21>4400,$B$21*N$13,4400*$N$13)+$E21*N$14,0)","v":91448},null,{"$f":"ROUND(IF($B$21>4400,$B$21*P$13,4400*$N$13)+$E21*P$14,0)","v":93220},null,{"$f":"(I21-G21)/G21","v":1.9377132359373633E-2},null,"Schedule 95A - Fed Inc Credit",-1.3159999999999999E-3,null,{"$f":"+N21","v":-1.3159999999999999E-3}]
[null,null,500,null,{"$f":"ROUND((B$21*C22),0)","v":2000000},null,{"$f":"ROUND(IF($B$21>4400,$B$21*N$13,4400*$N$13)+$E22*N$14,0)","v":141559},null,{"$f":"ROUND(IF($B$21>4400,$B$21*P$13,4400*$N$13)+$E22*P$14,0)","v":144514},null,{"$f":"(I22-G22)/G22","v":2.0874688292514074E-2},null,"Schedule 120 - Conservation",4.4260000000000002E-3,null,4.4260000000000002E-3]
[null,null,700,null,{"$f":"ROUND((B$21*C23),0)","v":2800000},null,{"$f":"ROUND(IF($B$21>4400,$B$21*N$13,4400*$N$13)+$E23*N$14,0)","v":191671},null,{"$f":"ROUND(IF($B$21>4400,$B$21*P$13,4400*$N$13)+$E23*P$14,0)","v":195808},null,{"$f":"(I23-G23)/G23","v":2.1583859843168764E-2},null,"Schedule 129 - Low Income",5.5999999999999995E-4,null,5.5999999999999995E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 132 - Merger Credit",-8.5000000000000006E-5,null,-8.5000000000000006E-5]
[null,6000,300,null,{"$f":"ROUND((B$25*C25),0)","v":1800000},null,{"$f":"ROUND(IF($B$25>4400,$B$25*N$13,4400*$N$13)+$E25*N$14,0)","v":134951},null,{"$f":"ROUND(IF($B$25>4400,$B$25*P$13,4400*$N$13)+$E25*P$14,0)","v":138991},null,{"$f":"(I25-G25)/G25","v":2.9936791872605614E-2},null,"Schedule 137 - REC",0,null,0]
[null,null,500,null,{"$f":"ROUND((B$25*C26),0)","v":3000000},null,{"$f":"ROUND(IF($B$25>4400,$B$25*N$13,4400*$N$13)+$E26*N$14,0)","v":210119},null,{"$f":"ROUND(IF($B$25>4400,$B$25*P$13,4400*$N$13)+$E26*P$14,0)","v":215931},null,{"$f":"(I26-G26)/G26","v":2.7660516183686389E-2},null,"Schedule 140 - Property Tax",1.4620000000000002E-3,null,1.4620000000000002E-3]
[null,null,700,null,{"$f":"ROUND((B$25*C27),0)","v":4200000},null,{"$f":"ROUND(IF($B$25>4400,$B$25*N$13,4400*$N$13)+$E27*N$14,0)","v":285286},null,{"$f":"ROUND(IF($B$25>4400,$B$25*P$13,4400*$N$13)+$E27*P$14,0)","v":292871},null,{"$f":"(I27-G27)/G27","v":2.6587354444312025E-2},null,"Schedule 141 - ERF - Energy",3.5599999999999998E-4,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 142 - Decoupling kWh",5.1560000000000009E-3,null,1.335E-3]
[null,8000,300,null,{"$f":"ROUND((B$29*C29),0)","v":2400000},null,{"$f":"ROUND(IF($B$29>4400,$B$29*N$13,4400*$N$13)+$E29*N$14,0)","v":179935},null,{"$f":"ROUND(IF($B$29>4400,$B$29*P$13,4400*$N$13)+$E29*P$14,0)","v":185321},null,{"$f":"(I29-G29)/G29","v":2.9933031372440046E-2}]
[null,null,500,null,{"$f":"ROUND((B$29*C30),0)","v":4000000},null,{"$f":"ROUND(IF($B$29>4400,$B$29*N$13,4400*$N$13)+$E30*N$14,0)","v":280159},null,{"$f":"ROUND(IF($B$29>4400,$B$29*P$13,4400*$N$13)+$E30*P$14,0)","v":287908},null,{"$f":"(I30-G30)/G30","v":2.7659293472635182E-2}]
[null,null,700,null,{"$f":"ROUND((B$29*C31),0)","v":5600000},null,{"$f":"ROUND(IF($B$29>4400,$B$29*N$13,4400*$N$13)+$E31*N$14,0)","v":380382},null,{"$f":"ROUND(IF($B$29>4400,$B$29*P$13,4400*$N$13)+$E31*P$14,0)","v":390495},null,{"$f":"(I31-G31)/G31","v":2.6586431534615203E-2},null,"Schedule 49 Overall:",6.121289490955753E-2]
[]
[null,10000,300,null,{"$f":"ROUND((B$33*C33),0)","v":3000000},null,{"$f":"ROUND(IF($B$33>4400,$B$33*N$13,4400*$N$13)+$E33*N$14,0)","v":224919},null,{"$f":"ROUND(IF($B$33>4400,$B$33*P$13,4400*$N$13)+$E33*P$14,0)","v":231651},null,{"$f":"(I33-G33)/G33","v":2.993077507902845E-2}]
[null,null,500,null,{"$f":"ROUND((B$33*C34),0)","v":5000000},null,{"$f":"ROUND(IF($B$33>4400,$B$33*N$13,4400*$N$13)+$E34*N$14,0)","v":350198},null,{"$f":"ROUND(IF($B$33>4400,$B$33*P$13,4400*$N$13)+$E34*P$14,0)","v":359885},null,{"$f":"(I34-G34)/G34","v":2.7661494354622243E-2}]
[null,null,700,null,{"$f":"ROUND((B$33*C35),0)","v":7000000},null,{"$f":"ROUND(IF($B$33>4400,$B$33*N$13,4400*$N$13)+$E35*N$14,0)","v":475477},null,{"$f":"ROUND(IF($B$33>4400,$B$33*P$13,4400*$N$13)+$E35*P$14,0)","v":488119},null,{"$f":"(I35-G35)/G35","v":2.6588036855620778E-2}]
[]
[]
[]
[null,"Notes:"]
[null," 1 Includes Rider Schedules 95A, 95, 120, 129, 132, 137, 140, 141 and 142"]