{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["WA Electric - Sched 91","Revenue By Month","DSM Balance","Rev Conv Factor","Billing Determinants","Base Revenue"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":7,"comments":4,"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":"WA Electric - Sched 91","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,""]
[]
[null,null," ","RESIDENTIAL","GENERAL SVC. ","LG. GEN. SVC.","EX LG GEN SVC","PUMPING","ST & AREA LTG"]
["Source",null,"TOTAL","SCHEDULE 1,2","SCH. 11,12","SCH. 21,22","SCHEDULE 25","SCH. 30, 31, 32","SCH. 41-48"]
[]
["Forecast","Total Annual Forecasted kWh's",{"$f":"SUM(D7:I7)","v":5703088058.8421621},{"$f":"SUM('Billing Determinants'!$I19:$T19)","v":2376578849.7214694},{"$f":"SUM('Billing Determinants'!I20:T20)","v":629198609.75904572},{"$f":"SUM('Billing Determinants'!I21:T21)","v":1390329750.6077092},{"$f":"SUM('Billing Determinants'!I22:T22)","v":1147942826.8097293},{"$f":"SUM('Billing Determinants'!I23:T23)","v":141034811.98234928},{"$f":"SUM('Billing Determinants'!I24:T24)","v":18003209.96185841},null,null,"August 2019 - July 2020"]
[]
[null,"Present DSM Rates",null,4.3299999999999996E-3,5.9699999999999996E-3,4.5999999999999999E-3,2.97E-3,4.3299999999999996E-3,2.017E-2]
[]
[null,"Present Annual DSM Revenue",{"$f":"SUM(D11:I11)","v":24825614.64879008},{"$f":"D7*D9","v":10290586.419293962},{"$f":"E7*E9","v":3756315.7002615025},6395516.8527954621,3409390.1956248963,610680.73588357237,{"$f":"I7*I9","v":363124.74493068416}]
[]
["UE-170485","Base Revenue",{"$f":"SUM(D13:I13)","v":502897000},{"$f":"ROUND('Base Revenue'!F14*1000,-3)","v":214393000},{"$f":"ROUND('Base Revenue'!F16*1000,-3)","v":75057000},{"$f":"ROUND('Base Revenue'!F18*1000,-3)","v":129541000},{"$f":"ROUND('Base Revenue'!F20*1000,-3)","v":65753000},{"$f":"ROUND('Base Revenue'!F22*1000,-3)","v":11132000},{"$f":"ROUND('Base Revenue'!F24*1000,-3)","v":7021000}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:I15)","v":1},{"$f":"D13/$C$13","v":0.4263159255274937},{"$f":"E13/$C$13","v":0.14924924984639001},{"$f":"F13/$C$13","v":0.25758952628470644},{"$f":"G13/$C$13","v":0.13074844351825524},2.2135745490627304E-2,{"$f":"I13/$C$13","v":1.3961109332527337E-2}]
[]
[null,"Revenue Requirement ",17978577.976300407]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:I19)","v":17978577.976300407},{"$f":"$C$17*D15","v":7664554.1096347226},{"$f":"$C$17*E15","v":2683289.2762676645},{"$f":"$C$17*F15","v":4631093.3841878781},{"$f":"$C$17*G15","v":2350671.0870728614},397969.22636678308,{"$f":"$C$17*I15","v":251000.89277049806}]
[]
[null,"DSM Revenue Increase <Decrease> ",{"$f":"C19-C11","v":-6847036.6724896729},{"$f":"D19-D11","v":-2626032.3096592398},{"$f":"E19-E11","v":-1073026.423993838},{"$f":"F19-F11","v":-1764423.468607584},{"$f":"G19-G11","v":-1058719.1085520349},{"$f":"H19-H11","v":-212711.50951678929},-112123.8521601861]
[]
[null,"Proposed DSM Rates",null,{"$f":"D19/D7","v":3.2250367415888573E-3},{"$f":"E19/E7","v":4.2646141212791958E-3},{"$f":"F19/F7","v":3.3309316600350675E-3},2.0477248798232033E-3,2.821780103600163E-3,{"$f":"I19/I7","v":1.394200774763325E-2}]
[]
[null,"Percentage Increase <Decrease>",{"$f":"C19/C11-1","v":-0.27580532322583906},{"$f":"D19/D11-1","v":-0.25518781949449021},{"$f":"E19/E11-1","v":-0.28565927616763875},{"$f":"F19/F11-1","v":-0.27588442173150707},{"$f":"G19/G11-1","v":-0.31053034349387099},-0.34831868277132494,{"$f":"I19/I11-1","v":-0.30877502490663122}]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:I27)","v":519238000},220074000,78692000,131866000,69157000,12659000,6790000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:I29)","v":512390963.3275103},{"$f":"D21+D27","v":217447967.69034076},{"$f":"E21+E27","v":77618973.576006159},130101576.53139241,{"$f":"G21+G27","v":68098280.891447961},{"$f":"H21+H27","v":12446288.490483211},{"$f":"I21+I27","v":6677876.1478398135}]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":-1.3186701806280898E-2},{"$f":"D29/D27-1","v":-1.1932496840422968E-2},{"$f":"E29/E27-1","v":-1.3635775224849267E-2},{"$f":"F29/F27-1","v":-1.3380427620520718E-2},{"$f":"G29/G27-1","v":-1.5308921852481117E-2},-1.6803184257586645E-2,-1.6513085737877242E-2]
[]
[]
[null,"Present DSM Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":4.7811629057946607E-2}]
[]
[null,"Percentage DSM Decrease",{"$f":"C21/C11","v":-0.27580532322583906}]
[]
[null,null,"Present","Proposed","Change"]
[null,"Gross DSM Revenue",{"$f":"C11","v":24825614.64879008},{"$f":"C19","v":17978577.976300407},{"$f":"D39-C39","v":-6847036.6724896729}]
[null,"Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95332300000000003},{"$f":"'Rev Conv Factor'!E22","v":0.95332300000000003}]
[]
[null,"Net DSM Revenue ",{"$f":"C39*C40","v":23666829.433828507},{"$f":"D39*D40","v":17139391.892100632},{"$f":"D42-C42","v":-6527437.5417278744}]
[]
[null,null,"Present","Proposed"]
[null,"Average Monthly Bill @ 918 kWh's - Increase <Decrease>",{"$f":"9+(800*0.07708)+(118*0.0894)","v":81.213199999999986},{"$f":"9+(800*(0.07708+(D23-D9))+(118*(0.0894+(ROUND(D23,5)-D9))))","v":80.199429393271089},{"$f":"D45-C45","v":-1.0137706067288974},{"$f":"E45/C45","v":-1.2482830460182552E-2}]
[]
[null,null,"Present","Change","Proposed"]
[null,"Basic Charge",9,0,{"$f":"C48+D48","v":9}]
[null,"First 800 kWh's",7.7079999999999996E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":-1.0999999999999998E-3},{"$f":"C49+D49","v":7.5979999999999992E-2}]
[null,"801 - 1500 kWh's",8.9399999999999993E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":-1.0999999999999998E-3},{"$f":"C50+D50","v":8.829999999999999E-2}]
[null,"Over 1500 kWh's",0.10451000000000001,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":-1.0999999999999998E-3},0.10341]
[]
[null,null,{"$f":"C48+ROUND((800*C49),2)+ROUND((118*C50),2)","v":81.209999999999994},{"$f":"918*D49","v":-1.0097999999999998},{"$f":"E48+ROUND((800*E49),2)+ROUND((118*E50),2)","v":80.2}]
[]
[null,null,null,null,{"$f":"D53/C53","v":-1.2434429257480605E-2}]

{"sheet":"Revenue By Month","index":1,"n_rows":39,"n_cols":36,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Usage",null,null,"2019-01-18","2019-02-18","2019-03-18","2019-04-18","2019-05-18","2019-06-18","2019-07-18","2019-08-18","2019-09-18","2019-10-18","2019-11-18","2019-12-18","2020-01-18","2020-02-18","2020-03-18","2020-04-18","2020-05-18","2020-06-18","2020-07-18","2020-08-18","2020-09-18","2020-10-18","2020-11-18","2020-12-18","2021-01-18","2021-02-18","2021-03-18","2021-04-18","2021-05-18","2021-06-18","2021-07-18"]
[null,"Residential Schedule 001",null,{"$f":"'Billing Determinants'!B19","v":0},{"$f":"'Billing Determinants'!C19","v":0},{"$f":"'Billing Determinants'!D19","v":0},{"$f":"'Billing Determinants'!E19","v":0},{"$f":"'Billing Determinants'!F19","v":156624519.61568195},{"$f":"'Billing Determinants'!G19","v":153422523.20191467},{"$f":"'Billing Determinants'!H19","v":190806253.99686599},{"$f":"'Billing Determinants'!I19","v":189012031.13839647},{"$f":"'Billing Determinants'!J19","v":151014677.993},{"$f":"'Billing Determinants'!K19","v":168788558.73193106},{"$f":"'Billing Determinants'!L19","v":218121702.50687876},{"$f":"'Billing Determinants'!M19","v":275559030.45227277},{"$f":"'Billing Determinants'!N19","v":268629663.44140643},{"$f":"'Billing Determinants'!O19","v":217744893.75803551},{"$f":"'Billing Determinants'!P19","v":215352451.10566804},{"$f":"'Billing Determinants'!Q19","v":175004830.27882707},{"$f":"'Billing Determinants'!R19","v":156817550.78367597},{"$f":"'Billing Determinants'!S19","v":153447790.65149826},{"$f":"'Billing Determinants'!T19","v":187085668.87987944},{"$f":"'Billing Determinants'!U19","v":185505048.32055381},{"$f":"'Billing Determinants'!V19","v":152371883.51476175},{"$f":"'Billing Determinants'!W19","v":169934455.09803253},{"$f":"'Billing Determinants'!X19","v":217126335.14180923},{"$f":"'Billing Determinants'!Y19","v":278188137.58097559},{"$f":"'Billing Determinants'!Z19","v":275640088.95071131},{"$f":"'Billing Determinants'!AA19","v":224332745.50526756},{"$f":"'Billing Determinants'!AB19","v":217609548.21916467},{"$f":"'Billing Determinants'!AC19","v":176817245.55417454},{"$f":"'Billing Determinants'!AD19","v":158911030.18890849},{"$f":"'Billing Determinants'!AE19","v":153582074.30163369},{"$f":"'Billing Determinants'!AF19","v":184262168.90678608}]
[null,"General Svc Schedule 011/012",null,{"$f":"'Billing Determinants'!B20","v":0},{"$f":"'Billing Determinants'!C20","v":0},{"$f":"'Billing Determinants'!D20","v":0},{"$f":"'Billing Determinants'!E20","v":0},{"$f":"'Billing Determinants'!F20","v":44718741.154740974},{"$f":"'Billing Determinants'!G20","v":46113534.9722353},{"$f":"'Billing Determinants'!H20","v":54584950.216016635},{"$f":"'Billing Determinants'!I20","v":54071176.68785505},{"$f":"'Billing Determinants'!J20","v":45850257.795033507},{"$f":"'Billing Determinants'!K20","v":48486986.771192618},{"$f":"'Billing Determinants'!L20","v":54616974.449917674},{"$f":"'Billing Determinants'!M20","v":62571479.899202012},{"$f":"'Billing Determinants'!N20","v":61553823.736181661},{"$f":"'Billing Determinants'!O20","v":52529054.943627611},{"$f":"'Billing Determinants'!P20","v":53685828.420249395},{"$f":"'Billing Determinants'!Q20","v":47125129.840164512},{"$f":"'Billing Determinants'!R20","v":45983953.310445733},{"$f":"'Billing Determinants'!S20","v":47166495.831966393},{"$f":"'Billing Determinants'!T20","v":55557448.073209599},{"$f":"'Billing Determinants'!U20","v":54419492.935259506},{"$f":"'Billing Determinants'!V20","v":46661643.05569271},{"$f":"'Billing Determinants'!W20","v":49409404.149250261},{"$f":"'Billing Determinants'!X20","v":55520698.835766867},{"$f":"'Billing Determinants'!Y20","v":63319107.578263395},{"$f":"'Billing Determinants'!Z20","v":62197728.792811386},{"$f":"'Billing Determinants'!AA20","v":53433443.382756412},{"$f":"'Billing Determinants'!AB20","v":54424458.652998962},{"$f":"'Billing Determinants'!AC20","v":47668812.849165834},{"$f":"'Billing Determinants'!AD20","v":46579758.002899051},{"$f":"'Billing Determinants'!AE20","v":47908287.43953751},{"$f":"'Billing Determinants'!AF20","v":56294022.719294973}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'Billing Determinants'!B21","v":0},{"$f":"'Billing Determinants'!C21","v":0},{"$f":"'Billing Determinants'!D21","v":0},{"$f":"'Billing Determinants'!E21","v":0},{"$f":"'Billing Determinants'!F21","v":108313446.91364183},{"$f":"'Billing Determinants'!G21","v":112519811.68682531},{"$f":"'Billing Determinants'!H21","v":128599755.62158555},{"$f":"'Billing Determinants'!I21","v":124354077.37095807},{"$f":"'Billing Determinants'!J21","v":108801090.09601292},{"$f":"'Billing Determinants'!K21","v":117549035.39143126},{"$f":"'Billing Determinants'!L21","v":119625110.72212097},{"$f":"'Billing Determinants'!M21","v":125081170.52440688},{"$f":"'Billing Determinants'!N21","v":120655433.84032178},{"$f":"'Billing Determinants'!O21","v":106071712.24893263},{"$f":"'Billing Determinants'!P21","v":112726054.28636214},{"$f":"'Billing Determinants'!Q21","v":105647396.86799644},{"$f":"'Billing Determinants'!R21","v":108802635.5287288},{"$f":"'Billing Determinants'!S21","v":113154246.57324685},{"$f":"'Billing Determinants'!T21","v":127861787.15719029},{"$f":"'Billing Determinants'!U21","v":121859622.46751796},{"$f":"'Billing Determinants'!V21","v":107827478.12257183},{"$f":"'Billing Determinants'!W21","v":118403672.26729967},{"$f":"'Billing Determinants'!X21","v":120028262.23580496},{"$f":"'Billing Determinants'!Y21","v":124130039.94233091},{"$f":"'Billing Determinants'!Z21","v":119448619.09724107},{"$f":"'Billing Determinants'!AA21","v":105897251.07837602},{"$f":"'Billing Determinants'!AB21","v":111899282.71244127},{"$f":"'Billing Determinants'!AC21","v":104954069.45037574},{"$f":"'Billing Determinants'!AD21","v":108923476.99029909},{"$f":"'Billing Determinants'!AE21","v":114122082.70427254},{"$f":"'Billing Determinants'!AF21","v":128522654.91260286}]
[null,"Extra Large Gen Schedule 25",null,{"$f":"'Billing Determinants'!B22","v":0},{"$f":"'Billing Determinants'!C22","v":0},{"$f":"'Billing Determinants'!D22","v":0},{"$f":"'Billing Determinants'!E22","v":0},{"$f":"'Billing Determinants'!F22","v":94315785.075259253},{"$f":"'Billing Determinants'!G22","v":96055580.236795917},{"$f":"'Billing Determinants'!H22","v":93099792.477471739},{"$f":"'Billing Determinants'!I22","v":99256250.528455988},{"$f":"'Billing Determinants'!J22","v":97718562.220592394},{"$f":"'Billing Determinants'!K22","v":96401446.0155164},{"$f":"'Billing Determinants'!L22","v":96489734.745736539},{"$f":"'Billing Determinants'!M22","v":94397352.566369906},{"$f":"'Billing Determinants'!N22","v":96007245.061376721},{"$f":"'Billing Determinants'!O22","v":94786165.539778799},{"$f":"'Billing Determinants'!P22","v":92669864.327046648},{"$f":"'Billing Determinants'!Q22","v":95467199.041716039},{"$f":"'Billing Determinants'!R22","v":94727900.87368162},{"$f":"'Billing Determinants'!S22","v":95953694.595385045},{"$f":"'Billing Determinants'!T22","v":94067411.294073164},{"$f":"'Billing Determinants'!U22","v":98186324.609269202},{"$f":"'Billing Determinants'!V22","v":98007423.585044548},{"$f":"'Billing Determinants'!W22","v":95483887.635155961},{"$f":"'Billing Determinants'!X22","v":96235516.48916015},{"$f":"'Billing Determinants'!Y22","v":93574724.951840743},{"$f":"'Billing Determinants'!Z22","v":94912583.735581845},{"$f":"'Billing Determinants'!AA22","v":94920175.304665536},{"$f":"'Billing Determinants'!AB22","v":91664760.230084375},{"$f":"'Billing Determinants'!AC22","v":95160123.714374393},{"$f":"'Billing Determinants'!AD22","v":94224976.893454403},{"$f":"'Billing Determinants'!AE22","v":95753709.519079149},{"$f":"'Billing Determinants'!AF22","v":94257388.518785611}]
[null,"Pumping Schedule 31/32",null,{"$f":"'Billing Determinants'!B23","v":0},{"$f":"'Billing Determinants'!C23","v":0},{"$f":"'Billing Determinants'!D23","v":0},{"$f":"'Billing Determinants'!E23","v":0},{"$f":"'Billing Determinants'!F23","v":12728088.581896193},{"$f":"'Billing Determinants'!G23","v":18735223.498093493},{"$f":"'Billing Determinants'!H23","v":25691636.844153345},{"$f":"'Billing Determinants'!I23","v":26106264.431511365},{"$f":"'Billing Determinants'!J23","v":18761823.596155304},{"$f":"'Billing Determinants'!K23","v":11287617.930930469},{"$f":"'Billing Determinants'!L23","v":5047261.8010655791},{"$f":"'Billing Determinants'!M23","v":4184150.6925409003},{"$f":"'Billing Determinants'!N23","v":4159559.2458253582},{"$f":"'Billing Determinants'!O23","v":3746894.0992693719},{"$f":"'Billing Determinants'!P23","v":4417312.4022785341},{"$f":"'Billing Determinants'!Q23","v":6663591.8006782811},{"$f":"'Billing Determinants'!R23","v":12442406.017103244},{"$f":"'Billing Determinants'!S23","v":18672245.894762293},{"$f":"'Billing Determinants'!T23","v":25545684.070228584},{"$f":"'Billing Determinants'!U23","v":26226893.848168094},{"$f":"'Billing Determinants'!V23","v":19608846.821155239},{"$f":"'Billing Determinants'!W23","v":12046047.784684464},{"$f":"'Billing Determinants'!X23","v":5186108.9984172964},{"$f":"'Billing Determinants'!Y23","v":4177289.7649649815},{"$f":"'Billing Determinants'!Z23","v":4167276.2166585093},{"$f":"'Billing Determinants'!AA23","v":3776271.4253890365},{"$f":"'Billing Determinants'!AB23","v":4317922.0947066694},{"$f":"'Billing Determinants'!AC23","v":6302343.9993373519},{"$f":"'Billing Determinants'!AD23","v":12029513.655201595},{"$f":"'Billing Determinants'!AE23","v":18669227.349847432},{"$f":"'Billing Determinants'!AF23","v":25515306.27860605}]
[null,"Street and Area Lights",null,{"$f":"'Billing Determinants'!B24","v":0},{"$f":"'Billing Determinants'!C24","v":0},{"$f":"'Billing Determinants'!D24","v":0},{"$f":"'Billing Determinants'!E24","v":0},{"$f":"'Billing Determinants'!F24","v":1511923.9038003993},{"$f":"'Billing Determinants'!G24","v":1513801.1947004327},{"$f":"'Billing Determinants'!H24","v":1514576.9693421354},{"$f":"'Billing Determinants'!I24","v":1512356.4257348133},{"$f":"'Billing Determinants'!J24","v":1515051.9951293813},{"$f":"'Billing Determinants'!K24","v":1500133.4061401626},{"$f":"'Billing Determinants'!L24","v":1498305.246901843},{"$f":"'Billing Determinants'!M24","v":1523830.53881033},{"$f":"'Billing Determinants'!N24","v":1518395.1167070242},{"$f":"'Billing Determinants'!O24","v":1480773.1053209431},{"$f":"'Billing Determinants'!P24","v":1486086.6081810216},{"$f":"'Billing Determinants'!Q24","v":1493552.1084854817},{"$f":"'Billing Determinants'!R24","v":1489472.8849378307},{"$f":"'Billing Determinants'!S24","v":1492715.3000326166},{"$f":"'Billing Determinants'!T24","v":1492537.2254769653},{"$f":"'Billing Determinants'!U24","v":1487036.3301548676},{"$f":"'Billing Determinants'!V24","v":1490798.3221898722},{"$f":"'Billing Determinants'!W24","v":1479472.2661115797},{"$f":"'Billing Determinants'!X24","v":1476952.7544425316},{"$f":"'Billing Determinants'!Y24","v":1496245.880070922},{"$f":"'Billing Determinants'!Z24","v":1493390.9085093047},{"$f":"'Billing Determinants'!AA24","v":1466506.6411594949},{"$f":"'Billing Determinants'!AB24","v":1465773.9358127073},{"$f":"'Billing Determinants'!AC24","v":1471495.3797820145},{"$f":"'Billing Determinants'!AD24","v":1468461.3190567256},{"$f":"'Billing Determinants'!AE24","v":1471511.6052333},{"$f":"'Billing Determinants'!AF24","v":1470862.7973333569}]
["Total Forecasted Usage",null,null,{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},{"$f":"SUM(F5:F10)","v":0},{"$f":"SUM(G5:G10)","v":0},{"$f":"SUM(H5:H10)","v":418212505.24502063},428360474.79056507,494296966.12543541,494312156.58291173,423661463.69592351,444013778.24714196,495399089.47262138,563317014.67360282,552524120.44181895,476359493.69496489,480337597.14978576,{"$f":"SUM(S5:S10)","v":431401699.93786776},420263919.39857316,429887188.8468914,491610536.70005804,{"$f":"SUM(W5:W10)","v":487684418.51092345},425968073.42141598,446756939.20053446,495573874.45540106,564885545.69844651,557859687.70151341,483826393.33761412,481381745.84520864,432374090.94720995,422137217.04981941,431506892.91960365,490322404.1334089]
[null,null,null,{"$f":"D11-'Billing Determinants'!B25","v":0},{"$f":"E11-'Billing Determinants'!C25","v":0},{"$f":"F11-'Billing Determinants'!D25","v":0},{"$f":"G11-'Billing Determinants'!E25","v":0},{"$f":"H11-'Billing Determinants'!F25","v":0},{"$f":"I11-'Billing Determinants'!G25","v":0},{"$f":"J11-'Billing Determinants'!H25","v":0},{"$f":"K11-'Billing Determinants'!I25","v":0},{"$f":"L11-'Billing Determinants'!J25","v":0},{"$f":"M11-'Billing Determinants'!K25","v":0},{"$f":"N11-'Billing Determinants'!L25","v":0},{"$f":"O11-'Billing Determinants'!M25","v":0},{"$f":"P11-'Billing Determinants'!N25","v":0},{"$f":"Q11-'Billing Determinants'!O25","v":0},{"$f":"R11-'Billing Determinants'!P25","v":0},{"$f":"S11-'Billing Determinants'!Q25","v":0},{"$f":"T11-'Billing Determinants'!R25","v":0},{"$f":"U11-'Billing Determinants'!S25","v":0},{"$f":"V11-'Billing Determinants'!T25","v":0},{"$f":"W11-'Billing Determinants'!U25","v":0},{"$f":"X11-'Billing Determinants'!V25","v":0},{"$f":"Y11-'Billing Determinants'!W25","v":0},{"$f":"Z11-'Billing Determinants'!X25","v":0},{"$f":"AA11-'Billing Determinants'!Y25","v":0},{"$f":"AB11-'Billing Determinants'!Z25","v":0},{"$f":"AC11-'Billing Determinants'!AA25","v":0},{"$f":"AD11-'Billing Determinants'!AB25","v":0},{"$f":"AE11-'Billing Determinants'!AC25","v":0},{"$f":"AF11-'Billing Determinants'!AD25","v":0},{"$f":"AG11-'Billing Determinants'!AE25","v":0},{"$f":"AH11-'Billing Determinants'!AF25","v":0}]
[]
["DSM Rates"]
[null,"Residential Schedule 001",null,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":3.2250367415888573E-3}]
[null,"General Svc Schedule 011/012",null,5.9699999999999996E-3,5.9699999999999996E-3,5.9699999999999996E-3,5.9699999999999996E-3,5.9699999999999996E-3,5.9699999999999996E-3,5.9699999999999996E-3,{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":4.2646141212791958E-3}]
[null,"Large Gen Svc Schedule 021/022",null,4.5999999999999999E-3,4.5999999999999999E-3,4.5999999999999999E-3,4.5999999999999999E-3,4.5999999999999999E-3,4.5999999999999999E-3,4.5999999999999999E-3,{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":3.3309316600350675E-3}]
[null,"Extra Large Gen Schedule 25",null,2.97E-3,2.97E-3,2.97E-3,2.97E-3,2.97E-3,2.97E-3,2.97E-3,{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":2.0477248798232033E-3}]
[null,"Pumping Schedule 31/32",null,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,4.3299999999999996E-3,{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.821780103600163E-3}]
[null,"Street and Area Lights",null,2.017E-2,2.017E-2,2.017E-2,2.017E-2,2.017E-2,2.017E-2,2.017E-2,{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.394200774763325E-2}]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D4","v":"2019-01-18"},{"$f":"E4","v":"2019-02-18"},"2019-03-18","2019-04-18","2019-05-18","2019-06-18","2019-07-18","2019-08-18","2019-09-18","2019-10-18","2019-11-18","2019-12-18","2020-01-18","2020-02-18","2020-03-18","2020-04-18","2020-05-18","2020-06-18","2020-07-18",{"$f":"W4","v":"2020-08-18"},"2020-09-18","2020-10-18","2020-11-18","2020-12-18","2021-01-18","2021-02-18","2021-03-18","2021-04-18","2021-05-18","2021-06-18","2021-07-18"]
[null,"Residential Schedule 001",null,{"$f":"D5*D15","v":0},{"$f":"E5*E15","v":0},{"$f":"F5*F15","v":0},{"$f":"G5*G15","v":0},{"$f":"H5*H15","v":678184.16993590281},{"$f":"I5*I15","v":664319.5254642904},826191.07980642968,609570.74502366583,487027.88504663523,544349.30347030645,703450.50472259836,888687.99768518249,866340.53447918477,702235.28266302671,694519.56720699731,{"$f":"S5*S15","v":564397.0076047394},505742.36300333153,494874.76276671706,{"$f":"V5*V15","v":603358.15596233832},{"$f":"W5*W15","v":598260.59658400237},491404.92272020417,548044.86135303683,700240.40839887061,897166.96477282222,888949.41432086483,723481.34659599047,701798.7883273582,570242.11345875193,512493.91100296594,495307.83247219847,594252.26480923709]
[null,"General Svc Schedule 011/012",null,{"$f":"D6*D16","v":0},{"$f":"E6*E16","v":0},0,{"$f":"G6*G16","v":0},266970.88469380361,275297.80378424469,325872.15278961929,230592.70365720909,195533.65685699141,206778.2884827056,232920.32050066395,266843.21676747425,262503.30592405086,224016.14949004506,228949.34199356756,{"$f":"S6*S16","v":200970.49418348118},196103.81663997009,201146.9041762602,236931.0775952453,{"$f":"W6*W16","v":232078.13804456111},198993.90189739646,210712.04265888355,236774.35627830078,270031.56032505858,265249.31252131704,227873.0171986754,232099.31491455509,203289.09242116779,198644.69374493093,204310.35914095439,240072.28423231721]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D7*D17","v":0},0,0,{"$f":"G7*G17","v":0},498241.85580275237,517591.13375939638,591558.8758592935,414214.9333693746,362408.99564713723,391547.80359190103,398463.06863951316,416636.83097399195,401895.0045339943,353317.62456409918,375482.7831332754,{"$f":"S7*S17","v":351904.25902789895},362414.14337789902,376909.0623782425,425898.87495055032,{"$f":"W7*W17","v":405906.07455697621},359165.96070021309,394394.54061956453,399805.9387802342,413468.68000532751,397875.1870984697,352736.50632764539,372728.8635220853,349594.8327817758,362816.65802808845,380132.8583888018,428100.18028015038]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D8*D18","v":0},0,0,{"$f":"G8*G18","v":0},280117.88167351997,285285.07330328389,276506.38365809107,203249.49368508431,200100.73107965878,197403.63945690636,197584.43048638612,193299.80743959837,196596.42435546446,194095.98943884581,189762.38679233415,{"$f":"S8*S18","v":195490.55868475582},193976.67943246401,196486.7677339272,192624.1784874358,{"$f":"W8*W18","v":201058.57976079782},200692.23968246713,195524.732332752,197063.86143748937,191615.29240649741,194354.85912365405,194370.40456854363,187704.21012617229,194861.75289697846,192946.82948549304,196077.25331758228,193013.19957707924]
[null,"Pumping Schedule 31/32",null,{"$f":"D9*D19","v":0},0,0,{"$f":"G9*G19","v":0},55112.623559610511,81123.517746744823,111244.78753518398,73666.137552163389,52941.740530887095,31851.175694540038,14242.262927907976,11806.753174676756,11737.361519616095,10572.911219615167,12464.684248135807,{"$f":"S9*S19","v":18803.190761667156},35109.73373997688,52688.971955370063,72084.303042226646,{"$f":"W9*W19","v":74006.527239994248},55331.85381447916,33991.29796583944,14634.059186835697,11787.393145750786,11759.137114373143,10655.80757395661,12184.226655738819,17783.828903374018,33944.642288234332,52680.454285387481,71998.583594234864]
[null,"Street and Area Lights",null,{"$f":"D10*D20","v":0},0,0,0,30495.505139654055,30533.370097107727,30549.017471630872,21085.285004777696,21122.866654161047,{"$f":"M10*M20","v":20914.871570889605},20889.383360625045,21245.257178173772,21169.476481097823,20644.950106871533,{"$f":"R10*R20","v":20719.031004913821},{"$f":"S10*S20","v":20823.115067998562},20766.242501692883,20811.448278065433,20808.965561230885,{"$f":"W10*W20","v":20732.272036031278},20784.721758129846,20626.813796536164,20591.686745326046,20860.671652313125,20820.867616681786,20446.046953001292,20435.831569379647,20515.599985527377,20473.299087388608,20515.82620089491,20506.780516127175]
[null,"Total",null,{"$f":"SUM(D24:D29)","v":0},0,0,0,1809122.9208052433,1854150.4241550681,2161922.2971202489,1552379.2982922748,1319135.8758154709,1392845.0822672492,1567549.9706376947,1798519.8632190975,{"$f":"SUM(P24:P29)","v":1760242.1072934081},1504882.9074825034,1521897.7943792243,{"$f":"SUM(S24:S29)","v":1352388.6253305413},1314112.9786953344,1342917.9172885825,1551705.5555990273,{"$f":"SUM(W24:W29)","v":1532042.1882223631},1326373.6005728899,1403294.2887266125,1569110.3108270566,1804930.5623077697,1779008.7777953602,1529563.1292178128,1526951.2351152895,1356287.2204475754,1321320.0336371013,1349024.5838058193,1547943.2930091459,null,{"$f":"SUM(K30:V30)-'WA Electric - Sched 91'!D39","v":0}]
[]
["Net DSM Revenue",null,{"$f":"'Rev Conv Factor'!E22","v":0.95332300000000003},{"$f":"D4","v":"2019-01-18"},{"$f":"E4","v":"2019-02-18"},"2019-03-18","2019-04-18","2019-05-18","2019-06-18","2019-07-18","2019-08-18","2019-09-18","2019-10-18","2019-11-18","2019-12-18","2020-01-18","2020-02-18","2020-03-18","2020-04-18","2020-05-18","2020-06-18","2020-07-18",{"$f":"W4","v":"2020-08-18"},"2020-09-18","2020-10-18","2020-11-18","2020-12-18","2021-01-18","2021-02-18","2021-03-18","2021-04-18","2021-05-18","2021-06-18","2021-07-18"]
[null,"Residential Schedule 001",null,{"$f":"D24*$C$32","v":0},{"$f":"E24*$C$32","v":0},{"$f":"F24*$C$32","v":0},{"$f":"G24*$C$32","v":0},{"$f":"H24*$C$32","v":646528.56743580475},{"$f":"I24*$C$32","v":633311.08297419373},787626.95877430495,581117.8113581962,464294.88445631345,518940.71103222296,670615.54551366169,847206.7080172312,825902.35735129984,669457.04637416464,662101.47736847633,{"$f":"S24*$C$32","v":538052.64848077297},482135.82672542502,471775.49346505501,{"$f":"V24*$C$32","v":575195.2073164843},{"$f":"W24*$C$32","v":570335.58671725087},468467.61514239322,522463.77135966113,667555.28685603652,855289.90235812124,847455.92250860983,689711.40778092947,669040.92628460214,543624.9223288378,488572.23271908052,472188.34877589368,566514.35184473637]
[null,"General Svc Schedule 011/012",null,{"$f":"D25*$C$32","v":0},{"$f":"E25*$C$32","v":0},0,{"$f":"G25*$C$32","v":0},254509.48470895094,262447.7281970075,310661.41831385822,219829.32802860154,186406.73235587764,197126.49831119835,222048.29870065447,254387.77593841887,250250.43911343394,213559.74768029823,218262.67355733382,{"$f":"S25*$C$32","v":191589.79442647882},186950.2787906662,191757.97013002491,225871.84568633203,{"$f":"W25*$C$32","v":221245.42679505513},189705.46353853168,200876.63664369486,225722.43965029853,257427.29718376583,252868.27036075955,217236.58837489283,221265.61519228842,193800.16745422495,189372.5553749988,194773.76450733206,228866.43022120534]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D26*$C$32","v":0},0,0,{"$f":"G26*$C$32","v":0},474985.42069944734,493431.53240890906,563946.68221080932,394880.62292449229,345492.8309573158,373271.52676364186,379864.00798462663,397189.47361461894,383135.75140736107,336825.81780232076,357956.37326496351,{"$f":"S26*$C$32","v":335478.42392925371},345497.73840744887,359316.07807361329,406019.19316448347,{"$f":"W26*$C$32","v":386959.59671488026},342401.17115260928,375985.38664706511,381144.19697578921,394169.20242871885,379303.56699027447,336271.8244217899,355330.99835946492,333276.79477202083,345881.4648813114,362389.39695778769,408117.74816521379]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D27*$C$32","v":0},0,0,{"$f":"G27*$C$32","v":0},267042.81931064511,271968.82193670649,263599.89518808236,193762.41706834565,190760.62925505356,188189.42977797636,188361.78202457307,184277.15232774024,187419.89305582445,185036.1709398088,180904.84786402836,{"$f":"S27*$C$32","v":186365.64587702748},184922.42996659488,187315.35487641068,183633.05970817775,{"$f":"W27*$C$32","v":191673.76843330308},191324.52801080863,186398.22440165613,187865.51157717168,182671.26540283934,185282.95736433927,185297.77719449773,178942.74071011294,185766.19085700621,183940.65032559869,186924.9553644775,184003.92246041991]
[null,"Pumping Schedule 31/32",null,{"$f":"D28*$C$32","v":0},0,0,{"$f":"G28*$C$32","v":0},52540.131629718569,77336.915308880023,106052.2145874042,70227.623249641067,50470.578908126881,30364.458366645995,13577.476821222015,11255.649356742369,11189.496695964976,10079.39944261719,11882.870181485572,{"$f":"S28*$C$32","v":17925.514226484818},33470.916698195979,50229.608811409256,68719.624029124636,{"$f":"W28*$C$32","v":70552.124568013038},52749.128873980721,32404.686150687954,13950.985206171768,11237.192995886577,11210.255871285548,10158.426443827038,11615.503508128899,16953.733121651228,32360.208220146418,50221.488720708454,68637.905707806771]
[null,"Street and Area Lights",null,{"$f":"D29*$C$32","v":0},0,0,{"$f":"G29*$C$32","v":0},{"$f":"H29*$C$32","v":29072.066446250425},29108.163981085032,29123.08098310756,20101.087156609687,20136.914607344774,19938.628110575191,19914.329613501151,20253.592308868156,20181.348827389622,19681.305770733092,19751.928794697458,{"$f":"S29*$C$32","v":19851.154525969592},19796.936600441364,19840.032306790174,19837.665475729311,{"$f":"W29*$C$32","v":19764.551774205447},19814.553300625619,19664.016008955245,19630.528583114461,19886.958081598106,19849.011978937931,19491.686819376053,19481.948259215715,19557.993325002917,19517.66690588657,19558.20898131574,19549.585521975907]
[null,"Total",null,{"$f":"SUM(D33:D38)","v":0},{"$f":"SUM(E33:E38)","v":0},{"$f":"SUM(F33:F38)","v":0},{"$f":"SUM(G33:G38)","v":0},1724678.4902308171,1767604.2448067819,2061010.2500575664,1479918.8897858865,1257562.5705400319,1327831.2523622606,1494381.4406582392,1714570.3515636199,1678079.2864512741,1434639.4880099425,1450860.171030985,{"$f":"SUM(S33:S38)","v":1289263.1814659873},1252774.1271887722,1280234.5376633033,1479276.5953803316,{"$f":"SUM(W33:W38)","v":1460531.0550027078},1264462.4600189491,1337792.7212117203,1495868.9488485823,1720681.8184509298,1695969.9850742067,1458167.7110353129,1455677.7323138132,1292979.8018587439,1259644.7784270223,1286056.1633075154,1475689.9439213581,null,{"$f":"SUM(K39:V39)-'WA Electric - Sched 91'!D42","v":0}]

{"sheet":"DSM Balance","index":2,"n_rows":36,"n_cols":33,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,"End January","End February","End March","End April","End May","End June","End July","End August","End September","End October ","End November","End December","End January","End February","End March","End April","End May","End June","End July","End August","End September","End October ","End November","End December","End January","End February","End March","End April","End May","End June","End July"]
["Expected elec tariff rider revenue",null,null,null,null,null,{"$f":"-'Revenue By Month'!H39","v":-1724678.4902308171},{"$f":"-'Revenue By Month'!I39","v":-1767604.2448067819},{"$f":"-'Revenue By Month'!J39","v":-2061010.2500575664},{"$f":"-'Revenue By Month'!K39","v":-1479918.8897858865},{"$f":"-'Revenue By Month'!L39","v":-1257562.5705400319},{"$f":"-'Revenue By Month'!M39","v":-1327831.2523622606},{"$f":"-'Revenue By Month'!N39","v":-1494381.4406582392},{"$f":"-'Revenue By Month'!O39","v":-1714570.3515636199},{"$f":"-'Revenue By Month'!P39","v":-1678079.2864512741},{"$f":"-'Revenue By Month'!Q39","v":-1434639.4880099425},{"$f":"-'Revenue By Month'!R39","v":-1450860.171030985},{"$f":"-'Revenue By Month'!S39","v":-1289263.1814659873},{"$f":"-'Revenue By Month'!T39","v":-1252774.1271887722},{"$f":"-'Revenue By Month'!U39","v":-1280234.5376633033},{"$f":"-'Revenue By Month'!V39","v":-1479276.5953803316},{"$f":"-'Revenue By Month'!W39","v":-1460531.0550027078},{"$f":"-'Revenue By Month'!X39","v":-1264462.4600189491},{"$f":"-'Revenue By Month'!Y39","v":-1337792.7212117203},{"$f":"-'Revenue By Month'!Z39","v":-1495868.9488485823},{"$f":"-'Revenue By Month'!AA39","v":-1720681.8184509298},{"$f":"-'Revenue By Month'!AB39","v":-1695969.9850742067},{"$f":"-'Revenue By Month'!AC39","v":-1458167.7110353129},{"$f":"-'Revenue By Month'!AD39","v":-1455677.7323138132},{"$f":"-'Revenue By Month'!AE39","v":-1292979.8018587439},{"$f":"-'Revenue By Month'!AF39","v":-1259644.7784270223},{"$f":"-'Revenue By Month'!AG39","v":-1286056.1633075154},{"$f":"-'Revenue By Month'!AH39","v":-1475689.9439213581}]
["Expected DSM expenditures",null,null,null,null,null,941558.07999999984,1680231.6599999997,952516.73,1000506.3700000003,932751.17999999993,1434286.9999999998,1259849.1499999997,2133151.4400000004,753031.50666666683,1041303.1266666667,1293876.9666666663,1058190.8866666667,822849.74666666647,1561523.3266666662,833808.39666666661,881798.03666666697,814042.84666666656,1315578.6666666665,1141140.8166666664,2014443.1066666669,753031.50666666683,1041303.1266666667,1293876.9666666663,1058190.8866666667,822849.74666666647,1561523.3266666662,833808.39666666661]
["Net change in balance",null,null,null,{"$f":"E3+E4","v":0},{"$f":"F3+F4","v":0},-783120.41023081727,-87372.584806782193,-1108493.5200575665,-479412.51978588616,-324811.39054003195,106455.74763773917,-234532.29065823951,418581.08843638049,-925047.77978460724,-393336.36134327576,-156983.20436431863,-231072.29479932063,-429924.38052210573,281288.78900336288,-645468.19871366501,{"$f":"V3+V4","v":-578733.01833604078},-450419.61335228255,-22214.054545053747,-354728.13218191592,293761.28821573709,-942938.47840753989,-416864.58436864614,-161800.76564714685,-234788.91519207717,-436795.03176035581,275467.16335915076,-641881.54725469148]
["Accounting Adjustment"]
["Elec Tariff rider balance",null,null,null,0,8665185,{"$f":"G5+G6+F7","v":7882064.5897691827},7794692.0049624005,6686198.4849048341,6206785.9651189484,5881974.5745789167,5988430.3222166561,5753898.0315584168,6172479.1199947968,5247431.34021019,4854094.9788669143,4697111.7745025959,4466039.4797032755,4036115.0991811696,4317403.8881845325,{"$f":"T7+U5+U6","v":3671935.6894708676},{"$f":"U7+V5+V6","v":3093202.6711348267},2642783.0577825443,2620569.0032374905,2265840.8710555746,2559602.1592713119,1616663.6808637721,1199799.0964951259,1037998.3308479791,803209.41565590189,366414.38389554608,641881.54725469684,{"$f":"AF7+AG5+AG6","v":5.3551048040390015E-9}]
[]
[]
[]
[]
[]
["Tariff rider balance annual interest rate",0,"applied to E  \"shareholder owes customer\" balances."]
["2015 Washington electric DSM budget ",null,"CY 2016 expected expenditures"]
["2016 Washington electric DSM budget ",{"$f":"B14*1.02","v":0},"CY 2017 expected expenditures + 2% increase"]
[]
[]
[]
["End of July Balance",{"$f":"I7","v":6686198.4849048341},"Underfunded \"Surcharge\""]
["Aug 2019 - July 2021 Expenditure Budget",{"$f":"SUM(J4:AG4)","v":27656716.526666664}]
["Aug 2019 - July 2021 Forecasted Revenue",{"$f":"SUM(J3:AG3)","v":-34342915.011571497}]
[null,{"$f":"SUM(C6:U6)","v":0}]
["Total Projected DSM Balance July 2021",{"$f":"B19+B20+B22+B21","v":0},"Overfunded"]
[]
[null,"Present","Proposed"]
["Gross Annual Revenue Recovered",{"$f":"'WA Electric - Sched 91'!C11","v":24825614.64879008},{"$f":"'WA Electric - Sched 91'!C19","v":17978577.976300407},{"$f":"C26-B26","v":-6847036.6724896729}]
["Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95332300000000003},{"$f":"'Rev Conv Factor'!E22","v":0.95332300000000003}]
[]
["Net Annual Revenue to be Recovered",{"$f":"B26*B27","v":23666829.433828507},{"$f":"C26*C27","v":17139391.892100632},{"$f":"C29-B29","v":-6527437.5417278744}]
[]
[]
[]
["August 2019 - July 2020"]
["Annual DSM Expense",{"$f":"SUM(J4:U4)","v":14125129.096666666}]
["Annual DSM Revenue",{"$f":"SUM(J3:U3)","v":-17139391.892100632}]
[null,{"$f":"B34+B35","v":-3014262.7954339664}]

{"sheet":"Rev Conv Factor","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[31,0,31,4],[32,0,32,4],[33,0,33,4]]}
["AVISTA UTILITIES"]
["Revenue Conversion Factor"]
["Washington - Electric System"]
["TWELVE MONTHS ENDED DECEMBER 31, 2016"]
[]
["Line "]
["No.",null,"Description",null,"Factor"]
[]
[1,null,"Revenues",null,1]
[]
[null,null,"Expense:"]
[2,null,"  Uncollectibles",null,6.1824999999999996E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8494500000000001E-2]
[]
[5,null,"  Franchise Fees",null,0]
[]
[6,null,"    Total Expense",null,{"$f":"E12+E14+E16+E18","v":4.6676999999999996E-2}]
[]
[7,null,"Net Operating Income Before FIT",null,{"$f":"E9-E20","v":0.95332300000000003}]
[]
[8,null,"  Federal Income Tax @ 21%",null,0.20019799999999999]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.75312500000000004}]
[]
[]
["Source:  UE-170485"]

{"sheet":"Billing Determinants","index":4,"n_rows":25,"n_cols":35,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Loads"]
[]
[]
[null,null,null,"2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01"]
["WA001",null,null,null,null,156624519.61568195,153422523.20191467,190806253.99686599,189012031.13839647,151014677.993,168788558.73193106,218121702.50687876,275559030.45227277,268629663.44140643,217744893.75803551,215352451.10566804,175004830.27882707,156817550.78367597,153447790.65149826,187085668.87987944,185505048.32055381,152371883.51476175,169934455.09803253,217126335.14180923,278188137.58097559,275640088.95071131,224332745.50526756,217609548.21916467,176817245.55417454,158911030.18890849,153582074.30163369,184262168.90678608]
["WA011",null,null,null,null,40592862.218050748,42203866.682264931,50192965.001339763,49711718.425782613,41932287.821355976,43994957.165837921,49009704.349167429,55583195.248400681,54534100.433609173,46563116.166528039,47841484.991203703,42297527.269957982,41658882.591263466,43046875.909656323,50980027.335145347,50007905.740787685,42664678.424143523,44726369.493553497,49820311.327456661,56212997.597576179,54992725.778683737,47267049.680865109,48414716.288479827,42700990.480110385,42118473.692546614,43622376.488564573,51598859.105239935]
["WA012",null,null,null,null,4125878.9366902229,3909668.2899703681,4391985.2146768728,4359458.2620724402,3917969.9736775318,4492029.6053546956,5607270.1007502442,6988284.6508013289,7019723.3025724869,5965938.7770995758,5844343.4290456893,4827602.5702065313,4325070.7191822659,4119619.9223100725,4577420.7380642528,4411587.1944718212,3996964.6315491842,4683034.6556967665,5700387.5083102053,7106109.9806872178,7205003.0141276512,6166393.7018913068,6009742.364519136,4967822.3690554518,4461284.31035244,4285910.950972937,4695163.6140550366]
["WA021",null,null,null,null,106030928.0703634,110318296.47847171,126099023.40395041,121913771.29540363,106696715.53365222,115212075.68240115,116934981.57461621,121876064.93945692,117465263.31068932,103387553.98109707,110048979.08801307,103306609.58892979,106549540.59503815,110937662.42381507,125379440.31182821,119447015.42531909,105711329.18454373,116054512.49784428,117382601.20911194,121013399.64482564,116330301.62346528,103211480.1808105,109243223.16198228,102643754.72464158,106689172.57021083,111913340.12610386,126050587.70472655]
["WA022",null,null,null,null,2282518.8432784248,2201515.2083535977,2500732.2176351426,2440306.07555445,2104374.5623606988,2336959.7090301099,2690129.147504766,3205105.5849499558,3190170.5296324696,2684158.2678355547,2677075.1983490707,2340787.2790666488,2253094.9336906588,2216584.1494317842,2482346.8453620747,2412607.0421988629,2116148.9380280976,2349159.769455391,2645661.02669302,3116640.2975052693,3118317.4737757868,2685770.8975655334,2656059.550458984,2310314.7257341635,2234304.4200882581,2208742.5781686744,2472067.207876307]
["WA025",null,null,null,null,94315785.075259253,96055580.236795917,93099792.477471739,99256250.528455988,97718562.220592394,96401446.0155164,96489734.745736539,94397352.566369906,96007245.061376721,94786165.539778799,92669864.327046648,95467199.041716039,94727900.87368162,95953694.595385045,94067411.294073164,98186324.609269202,98007423.585044548,95483887.635155961,96235516.48916015,93574724.951840743,94912583.735581845,94920175.304665536,91664760.230084375,95160123.714374393,94224976.893454403,95753709.519079149,94257388.518785611]
["WA031",null,null,null,null,12024162.370243033,17642198.351146057,23982643.044956166,24448305.75960964,17686778.739922635,10702273.61240479,4752631.6447205953,3900991.5738899345,3861576.9838458197,3490140.7181236632,4146977.9811925497,6259576.7647937275,11751280.904841138,17609337.935527042,23848486.869992331,24571470.230119288,18514947.812681295,11441175.339350075,4888889.0877788244,3897097.022585866,3868764.597305052,3518880.0492083598,4050218.0018001357,5911737.7079175422,11355819.578127854,17631864.920766752,23823860.859085675]
["WA032",null,null,null,null,703926.2116531597,1093025.1469474346,1708993.7991971767,1657958.6719017269,1075044.8562326697,585344.31852567859,294630.15634498349,283159.11865096586,297982.26197953854,256753.38114570858,270334.42108598456,404015.0358845531,691125.11226210603,1062907.9592352519,1697197.2002362525,1655423.6180488048,1093899.0084739453,604872.44533439016,297219.91063847166,280192.74237911543,298511.6193534573,257391.37618067663,267704.09290653386,390606.29141980957,673694.07707374159,1037362.4290806807,1691445.4195203753]
["WA04X",null,null,null,null,1511923.9038003993,1513801.1947004327,1514576.9693421354,1512356.4257348133,1515051.9951293813,1500133.4061401626,1498305.246901843,1523830.53881033,1518395.1167070242,1480773.1053209431,1486086.6081810216,1493552.1084854817,1489472.8849378307,1492715.3000326166,1492537.2254769653,1487036.3301548676,1490798.3221898722,1479472.2661115797,1476952.7544425316,1496245.880070922,1493390.9085093047,1466506.6411594949,1465773.9358127073,1471495.3797820145,1468461.3190567256,1471511.6052333,1470862.7973333569]
[null,null,null,{"$f":"SUM(D8:D16)","v":0},0,418212505.24502063,428360474.79056507,494296966.12543541,494312156.58291173,423661463.69592351,444013778.2471419,495399089.47262144,563317014.67360282,552524120.44181895,476359493.69496489,{"$f":"SUM(P8:P16)","v":480337597.1497857},431401699.93786782,420263919.39857322,429887188.8468914,491610536.70005804,{"$f":"SUM(U8:U16)","v":487684418.51092339},425968073.42141598,446756939.20053446,495573874.455401,564885545.69844651,557859687.70151341,483826393.33761406,481381745.84520864,432374090.94720995,422137217.04981941,431506892.91960365,490322404.1334089]
[]
["WA001",null,null,{"$f":"D8","v":0},0,156624519.61568195,153422523.20191467,190806253.99686599,189012031.13839647,151014677.993,168788558.73193106,218121702.50687876,275559030.45227277,268629663.44140643,217744893.75803551,215352451.10566804,175004830.27882707,156817550.78367597,153447790.65149826,187085668.87987944,{"$f":"U8","v":185505048.32055381},152371883.51476175,169934455.09803253,217126335.14180923,278188137.58097559,275640088.95071131,224332745.50526756,217609548.21916467,176817245.55417454,158911030.18890849,153582074.30163369,184262168.90678608,null,{"$f":"SUM(B19:M19)","v":1503349297.6369419},{"$f":"SUM(B19:T19)","v":2877432146.535933}]
["WA011/12",null,null,{"$f":"D9+D10","v":0},0,44718741.154740974,46113534.9722353,54584950.216016635,54071176.68785505,45850257.795033507,48486986.771192618,54616974.449917674,62571479.899202012,61553823.736181661,52529054.943627611,53685828.420249395,47125129.840164512,45983953.310445733,47166495.831966393,55557448.073209599,{"$f":"U9+U10","v":54419492.935259506},46661643.05569271,49409404.149250261,55520698.835766867,63319107.578263395,62197728.792811386,53433443.382756412,54424458.652998962,47668812.849165834,46579758.002899051,47908287.43953751,56294022.719294973,null,{"$f":"SUM(B20:M20)","v":411014101.94619375},{"$f":"SUM(B20:T20)","v":774615836.10203874}]
["WA021/22",null,null,{"$f":"D11+D12","v":0},0,108313446.91364183,112519811.68682531,128599755.62158555,124354077.37095807,108801090.09601292,117549035.39143126,119625110.72212097,125081170.52440688,120655433.84032178,106071712.24893263,112726054.28636214,105647396.86799644,108802635.5287288,113154246.57324685,127861787.15719029,{"$f":"U11+U12","v":121859622.46751796},107827478.12257183,118403672.26729967,120028262.23580496,124130039.94233091,119448619.09724107,105897251.07837602,111899282.71244127,104954069.45037574,108923476.99029909,114122082.70427254,128522654.91260286,null,944843498.32698286,1739762764.829762]
["WA025",null,null,{"$f":"D13","v":0},0,94315785.075259253,96055580.236795917,93099792.477471739,99256250.528455988,97718562.220592394,96401446.0155164,96489734.745736539,94397352.566369906,96007245.061376721,94786165.539778799,92669864.327046648,95467199.041716039,94727900.87368162,95953694.595385045,94067411.294073164,{"$f":"U13","v":98186324.609269202},98007423.585044548,95483887.635155961,96235516.48916015,93574724.951840743,94912583.735581845,94920175.304665536,91664760.230084375,95160123.714374393,94224976.893454403,95753709.519079149,94257388.518785611,null,767734503.86619818,1431413984.599256]
["WA031/32",null,null,{"$f":"D14+D15","v":0},0,12728088.581896193,18735223.498093493,25691636.844153345,26106264.431511365,18761823.596155304,11287617.930930469,5047261.8010655791,4184150.6925409003,4159559.2458253582,3746894.0992693719,4417312.4022785341,6663591.8006782811,12442406.017103244,18672245.894762293,25545684.070228584,{"$f":"U14+U15","v":26226893.848168094},19608846.821155239,12046047.784684464,5186108.9984172964,4177289.7649649815,4167276.2166585093,3776271.4253890365,4317922.0947066694,6302343.9993373519,12029513.655201595,18669227.349847432,25515306.27860605,null,122542067.37634663,198189760.90649229]
["WA04X",null,null,{"$f":"D16","v":0},0,1511923.9038003993,1513801.1947004327,1514576.9693421354,1512356.4257348133,1515051.9951293813,1500133.4061401626,1498305.246901843,1523830.53881033,1518395.1167070242,1480773.1053209431,1486086.6081810216,1493552.1084854817,1489472.8849378307,1492715.3000326166,1492537.2254769653,{"$f":"U16","v":1487036.3301548676},1490798.3221898722,1479472.2661115797,1476952.7544425316,1496245.880070922,1493390.9085093047,1466506.6411594949,1465773.9358127073,1471495.3797820145,1468461.3190567256,1471511.6052333,1470862.7973333569,null,12089979.680559499,22543512.029701382]
["Total",null,null,{"$f":"SUM(D19:D24)","v":0},0,418212505.24502063,428360474.79056507,494296966.12543541,494312156.58291173,423661463.69592351,444013778.24714196,495399089.47262138,563317014.67360282,552524120.44181895,476359493.69496489,{"$f":"SUM(P19:P24)","v":480337597.14978576},431401699.93786776,420263919.39857316,429887188.8468914,491610536.70005804,{"$f":"SUM(U19:U24)","v":487684418.51092345},425968073.42141598,446756939.20053446,495573874.45540106,564885545.69844651,557859687.70151341,483826393.33761412,481381745.84520864,432374090.94720995,422137217.04981941,431506892.91960365,490322404.1334089,null,3761573448.8332224,7043958005.0031834]

{"sheet":"Base Revenue","index":5,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,0,4,13],[0,0,0,13],[0,16,2,17],[1,0,1,13],[2,0,2,13],[3,0,3,13]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This worksheet pulls data from 'Pres & Prop Rev' tab."]
["WASHINGTON ELECTRIC"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED DECEMBER 31, 2016"]
["(000s of Dollars)"]
["Source:  UE-170485 Compliance Filing, Attachment 1, Page 1"]
[]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Total Billed",null,"Percent",null,null,null,"Percent ",null,null,null,"Percent ","Total Billed"]
[null,null,null,"Revenue","Total","Revenue","Tariff","Revenue","Total ","Increase","Sch. 98","Sch. 93","Proposed","Increase",null,null,null,"Increase","Revenue"]
[null,"Type of","Schedule","Under Present","General","Under Proposed","Percent","at Present","General","on Billed","REC Revenue","ERM","General","on Billed",null,null,null,"on Base","at Proposed"]
["No.","Service","Number","Rates(1)","Increase","Rates(1)","Increase","Rates (2)","Increase","Revenue","Decrease","Increase","Increase","Revenue",null,null,null,"Revenue","Rates (2)"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(k)","(j)","(k)","(j)","(k)",null,{"$f":"\"col (m) source\"","v":"col (m) source"}]
[null,null,null,{"$f":"IF(Base1_Billing2<>1,\"ERROR\",\"\")","v":""}]
[1,"Residential",1,209488.93071000002,4904.4568899999858,214393.38759999999,2.3411532405926163E-2,227177.78877000001,4904.4568899999858,{"$f":"(I14)/H14","v":2.1588628521097941E-2},{"$f":"'[3]Adder Schedule'!H11/1000","v":{"$error":"#DIV/0!"}},{"$f":"('[3]Pres & Prop Rev'!D23*(0))/1000","v":0},{"$f":"E14+L14","v":4904.4568899999858},{"$f":"(M14)/H14","v":2.1588628521097941E-2},null,"from Pres & Prop Rev tab",null,{"$f":"(E14+L14)/D14","v":2.3411532405926163E-2},{"$f":"E14+H14+L14","v":232082.24565999999},null,{"$f":"#REF!/H14","v":{"$error":"#REF!"}},{"$f":"#REF!/H14","v":{"$error":"#REF!"}}]
[]
[2,"General Service","11/12",73765.851869999999,1291.4264699999987,75057.478340000001,1.7507104402127997E-2,77450.850290000002,1291.4264699999987,{"$f":"(I16)/H16","v":1.6674141925679287E-2},{"$f":"'[3]Adder Schedule'!H13/1000","v":{"$error":"#DIV/0!"}},{"$f":"('[3]Pres & Prop Rev'!E23*(0))/1000","v":0},{"$f":"E16+L16","v":1291.4264699999987},{"$f":"(M16)/H16","v":1.6674141925679287E-2},null,"from below",null,{"$f":"(E16+L16)/D16","v":1.7507104402127997E-2},{"$f":"E16+H16+L16","v":78742.276760000008},null,{"$f":"#REF!/H16","v":{"$error":"#REF!"}},{"$f":"#REF!/H16","v":{"$error":"#REF!"}}]
[]
[3,"Large General Service","21/22",126766.29444000001,2774.5581999999731,129540.75263999998,2.1887191798551819E-2,133183.52299999999,2774.5581999999731,2.0832593533360529E-2,{"$f":"'[3]Adder Schedule'!H15/1000","v":{"$error":"#DIV/0!"}},{"$f":"('[3]Pres & Prop Rev'!F23*(0))/1000","v":0},{"$f":"E18+L18","v":2774.5581999999731},{"$f":"(M18)/H18","v":2.0832593533360529E-2},null,"from below",null,{"$f":"(E18+L18)/D18","v":2.1887191798551819E-2},{"$f":"E18+H18+L18","v":135958.08119999996},null,{"$f":"#REF!/H18","v":{"$error":"#REF!"}},{"$f":"#REF!/H18","v":{"$error":"#REF!"}}]
[]
[4,"Extra Large General Service",25,64348.301520000001,1405.0125,65753.014020000002,2.1934492392364235E-2,67050.377429999993,1405.0125,2.095458003151169E-2,{"$f":"'[3]Adder Schedule'!H17/1000","v":{"$error":"#DIV/0!"}},{"$f":"('[3]Pres & Prop Rev'!G23*(0))/1000","v":0},{"$f":"E20+L20","v":1405.0125},{"$f":"(M20)/H20","v":2.095458003151169E-2},null,"from Pres & Prop Rev tab",null,{"$f":"(E20+L20)/D20","v":2.1834492392364235E-2},{"$f":"E20+H20+L20","v":68455.38992999999},null,{"$f":"#REF!/H20","v":{"$error":"#REF!"}},{"$f":"#REF!/H20","v":{"$error":"#REF!"}}]
[]
[5,"Pumping Service","30/31/32",10894.097790000002,238.12927999999934,11132.227070000001,2.1858559064761186E-2,11443.438270000001,238.12927999999934,2.080924232573322E-2,{"$f":"'[3]Adder Schedule'!H19/1000","v":{"$error":"#DIV/0!"}},{"$f":"('[3]Pres & Prop Rev'!H23*(0))/1000","v":0},{"$f":"E22+L22","v":238.12927999999934},{"$f":"(M22)/H22","v":2.080924232573322E-2},null,"from below",null,{"$f":"(E22+L22)/D22","v":2.1858559064761186E-2},{"$f":"E22+H22+L22","v":11681.56755},null,{"$f":"#REF!/H22","v":{"$error":"#REF!"}},{"$f":"#REF!/H22","v":{"$error":"#REF!"}}]
[]
[6,"Street & Area Lights","41-48",6870.5681202796004,149.70324035639968,7020.5713606360005,2.1789062816294068E-2,7222.8842058432301,149.70324035639968,2.0726241220272019E-2,{"$f":"'[3]Adder Schedule'!H21/1000","v":{"$error":"#DIV/0!"}},{"$f":"('[3]Pres & Prop Rev'!I23*(0))/1000","v":0},{"$f":"E24+L24","v":149.70324035639968},{"$f":"(M24)/H24","v":2.0726241220272019E-2},null,"from Pres & Prop Rev tab",null,{"$f":"(E24+L24)/D24","v":2.1789062816294068E-2},{"$f":"E24+H24+L24","v":7372.58744619963},null,{"$f":"#REF!/H24","v":{"$error":"#REF!"}},{"$f":"#REF!/H24","v":{"$error":"#REF!"}}]
[]
[7,"Total",null,{"$f":"SUM(D14:D24)","v":492134.04445027962},{"$f":"SUM(E14:E24)","v":10763.286580356356},{"$f":"SUM(F14:F24)","v":502897.43103063595},{"$f":"E26/D26","v":2.1870640126876596E-2},{"$f":"SUM(H14:H24)","v":523528.86196584319},{"$f":"E26","v":10763.286580356356},2.0559108317238468E-2,{"$f":"SUM(K14:K25)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L14:L24)","v":0},{"$f":"E26+L26","v":10763.286580356356},{"$f":"(M26)/H26","v":2.0559108317238468E-2},null,"from below",null,{"$f":"(E26+L26)/D26","v":2.1870640126876596E-2},{"$f":"E26+H26+L26","v":534292.14854619955},null,{"$f":"#REF!/H26","v":{"$error":"#REF!"}},{"$f":"#REF!/H26","v":{"$error":"#REF!"}}]
[]
[null,null,null,{"$f":"IF(Base1_Billing2=2,\"Exhibit won't work until Base1_Billing2 range set to '1'\",\"\")","v":""}]
[]
[]
["(1) Excludes all present rate adjustments:  Schedule 59 (BPA Residential Exchange), Schedule 91 (DSM), "]
["     Schedule 92 (LIRAP), Schedule 93 (ERM), and Schedule 98 (REC Revenue)."]
[]
["(2) Includes all present rate adjustments:  Schedule 59 (BPA Residential Exchange), Schedule 91 (DSM), "]
["     Schedule 92 (LIRAP), Schedule 93 (ERM), and Schedule 98 (REC Revenue)."]
[]
[]
[null,"reduce billed revenue for BPA ResEx (already accounted for in Schs 1 & 48)"]
[null,null,null,null,null,"Billing",null,null,"Billed Revenue"]
[null,null,null,null,null,"Determinants",null,"Sch 59 Rate","Impact"]
[null,"Schedule 12 only",null,null,null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P49+'[3]Rev Runs 12MESEPT2014'!P81+'[3]Rev Runs 12MESEPT2014'!P90","v":57963673},null,-2.7E-4,{"$f":"F41*H41","v":-15650.191710000001}]
[null,"Schedule 22 only",null,null,null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P51+'[3]Rev Runs 12MESEPT2014'!P83+'[3]Rev Runs 12MESEPT2014'!P92","v":36956089},null,-2.7E-4,{"$f":"F42*H42","v":-9978.1440299999995}]
[null,"Schedule 32 only",null,null,null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P55+'[3]Rev Runs 12MESEPT2014'!P86+'[3]Rev Runs 12MESEPT2014'!P95","v":8649684},null,-2.7E-4,{"$f":"F43*H43","v":-2335.4146799999999}]
[]
[null,"Total",null,null,null,{"$f":"SUM(F41:F44)","v":103569446},null,null,{"$f":"SUM(I41:I44)","v":-27963.750420000004},"Manually deducted in Column H"]
[]
[]
[null,null,null,null,null,null,null,null,null,"ERM Reduction Calc",null,0,1,{"$f":"-D14*$L$49","v":0},null,{"$f":"0/'[3]Pres & Prop Rev'!D23","v":0},{"$f":"(D14/$D$26)*$N$54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L48/D26","v":0},11,{"$f":"-D16*L49","v":0},null,null,{"$f":"(D16/$D$26)*$N$54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"-D18*L49","v":0},null,null,{"$f":"(D18/$D$26)*$N$54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"-D20*L49","v":0},null,null,{"$f":"(D20/$D$26)*$N$54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"-D22*L49","v":0},null,null,{"$f":"(D22/$D$26)*$N$54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"41-48",{"$f":"-D24*L49","v":0},null,null,{"$f":"(D24/$D$26)*$N$54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N48:N53)","v":0},null,null,{"$f":"SUM(Q48:Q53)","v":0}]