{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["WA Electric - Sched 92","LIRAP Balance","LIRAP Expense Summary","Revenue By Month","Billing Determinants","Rev Conv Factor","Base Revenue"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":5,"defined_names":14,"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 92","index":0,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[58,3,58,4]]}
[]
[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,13","SCH. 21,22,23","SCHEDULE 25/25I","SCH. 30, 31, 32","SCH. 41-48"]
[]
["Forecast","Total Annual Forecasted kWh's",{"$f":"SUM(D7:I7)","v":5371975013.3334751},{"$f":"SUM('Billing Determinants'!$F19:$Q19)","v":2566593571.0473332},{"$f":"SUM('Billing Determinants'!F20:Q20)","v":681083760.79192913},{"$f":"SUM('Billing Determinants'!F21:Q21)","v":1311256847.2120991},{"$f":"SUM('Billing Determinants'!F22:Q22)","v":649738455.39999998},{"$f":"SUM('Billing Determinants'!F23:Q23)","v":147533673.28433281},{"$f":"SUM('Billing Determinants'!F24:Q24)","v":15768705.597780734}]
[]
[null,"Present LIRAP Rates",null,1.7899999999999999E-3,2.5999999999999999E-3,1.8600000000000001E-3,1.1800000000000001E-3,1.6199999999999999E-3,2.1000000000000001E-2]
[]
[null,"Present Annual LIRAP Revenue",{"$f":"SUM(D11:I11)","v":9969486.9341408666},{"$f":"D7*D9","v":4594202.492174726},{"$f":"E7*E9","v":1770817.7780590157},{"$f":"F7*F9","v":2438937.7358145043},766691.37737200002,239004.55072061915,159833]
[]
["UE-220053","Base Revenue",{"$f":"SUM(D13:I13)","v":574386944.67812788},{"$f":"'Base Revenue'!F14*1000","v":279484405.94999999},{"$f":"'Base Revenue'!F16*1000","v":84833839.709999993},{"$f":"'Base Revenue'!F18*1000","v":136399731.27999997},{"$f":"('Base Revenue'!F20+'Base Revenue'!F22)*1000-14265000","v":49983817.105800003},{"$f":"'Base Revenue'!F24*1000","v":16075572.790000001},{"$f":"'Base Revenue'!F26*1000","v":7609577.842327999}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:I15)","v":1},{"$f":"D13/$C$13","v":0.48657861836782534},{"$f":"E13/$C$13","v":0.14769458201655117},{"$f":"F13/$C$13","v":0.23747011060015472},{"$f":"G13/$C$13","v":8.7021158069338925E-2},2.7987357545196906E-2,{"$f":"I13/$C$13","v":1.3248173400933087E-2}]
[]
[null,"Revenue Requirement ",17591583.405461773,{"$f":"D7/C7","v":0.47777466661273305}]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:I19)","v":17591583.405461777},{"$f":"$C$17*D15","v":8559688.3483319543},{"$f":"$C$17*E15","v":2598181.5580789745},{"$f":"$C$17*F15","v":4177475.2569268537},{"$f":"$C$17*G15","v":1530839.9602166484},492341.93455481122,{"$f":"$C$17*I15","v":233056.34735253456}]
[]
[null,"LIRAP Revenue Increase <Decrease> ",{"$f":"C19-C11","v":7622096.4713209104},{"$f":"D19-D11","v":3965485.8561572284},{"$f":"E19-E11","v":827363.78001995874},{"$f":"F19-F11","v":1738537.5211123494},{"$f":"G19-G11","v":764148.58284464839},{"$f":"H19-H11","v":253337.38383419206},73223.347352534562]
[]
[null,"Proposed LIRAP Rates",null,{"$f":"D19/D7","v":3.3350384902737281E-3},{"$f":"E19/E7","v":3.8147753736749541E-3},3.1858558190248571E-3,2.3560864336930987E-3,3.3371495713114259E-3,{"$f":"I19/I7","v":1.4779675218575618E-2}]
[]
[null,"Percentage Increase <Decrease>",{"$f":"C19/C11-1","v":0.76454250069968666},{"$f":"D19/D11-1","v":0.86314999456632857},{"$f":"E19/E11-1","v":0.46722129756729003},{"$f":"F19/F11-1","v":0.71282570915314891},{"$f":"G19/G11-1","v":0.99668341838398189},{"$f":"H19/H11-1","v":1.0599688711798927},{"$f":"I19/I11-1","v":0.4581240879701598}]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:I27)","v":576920000},252270000,89268000,141148000,73514000,13888000,6832000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:I29)","v":584542096.47132087},{"$f":"D21+D27","v":256235485.85615724},{"$f":"E21+E27","v":90095363.780019954},142886537.52111235,{"$f":"G21+G27","v":74278148.582844645},{"$f":"H21+H27","v":14141337.383834193},{"$f":"I21+I27","v":6905223.3473525345}]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":1.3211704346046016E-2},{"$f":"D29/D27-1","v":1.5719212970853658E-2},{"$f":"E29/E27-1","v":9.2683131695563414E-3},{"$f":"F29/F27-1","v":1.2317124728032702E-2},{"$f":"G29/G27-1","v":1.0394599434728757E-2},1.8241459089443524E-2,1.071770306682307E-2]
[]
[null,null,null,{"$f":"D23-D9","v":1.5450384902737282E-3},1.2147753736749542E-3,1.325855819024857E-3,1.1760864336930986E-3,1.717149571311426E-3]
[null,"Present LIRAP Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":1.7280536182037138E-2}]
[]
[null,"Proposed LIRAP Revenue as a Percentage of Billed Revenue",{"$f":"C17/C29","v":3.0094639054494277E-2}]
[]
[null,null,"Present","Proposed","Change"]
[null,"Gross LIRAP Revenue",{"$f":"C11","v":9969486.9341408666},{"$f":"C19","v":17591583.405461777},{"$f":"D39-C39","v":7622096.4713209104}]
[null,"Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95606855188236617},{"$f":"'Rev Conv Factor'!E22","v":0.95606855188236617}]
[]
[null,"Net LIRAP Revenue ",{"$f":"C39*C40","v":9531512.9361342285},{"$f":"D39*D40","v":16818759.671777703},{"$f":"D42-C42","v":7287246.7356434744}]
[]
[null,null,"Present","Proposed","$ Change","% Change"]
[null,"Average Monthly Bill @ 932 kWh's - Increase <Decrease>",{"$f":"9+(800*C49)+((932-800)*C50)","v":87.52803999999999},{"$f":"9+(800*E49)+((932-800)*E50)","v":88.972639999999984},{"$f":"D45-C45","v":1.4445999999999941},{"$f":"E45/C45","v":1.6504425324730159E-2}]
[]
[null,null,"Present","Change","Proposed"]
[null,"Basic Charge",9,0,{"$f":"C48+D48","v":9}]
[null,"First 800 kWh's",8.2159999999999997E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":1.5500000000000002E-3},{"$f":"C49+D49","v":8.3709999999999993E-2}]
[null,"801 - 1500 kWh's",9.6970000000000001E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":1.5500000000000002E-3},{"$f":"C50+D50","v":9.8519999999999996E-2}]
[null,"Over 1500 kWh's",0.11518,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":1.5500000000000002E-3},0.11673]
[]
[null,null,{"$f":"C48+(800*C49)+(132*C50)","v":87.52803999999999},{"$f":"932*D49","v":1.4446000000000001},{"$f":"E48+(800*E49)+(132*E50)","v":88.972639999999984}]
[]
[null,null,null,null,{"$f":"D53/C53","v":1.6504425324730225E-2}]
[]
[]
[]
[null,null,null,"Change in Annual Revenue"]
[null,null,"Rate Schedule","($)","(%)"]
[null,null,"Schedule 01/02",3965000,1.6E-2]
[null,null,"Schedule 11/12/13",827000,8.9999999999999993E-3]
[null,null,"Schedule 21/22/23",1739000,1.2E-2]
[null,null,"Schedule 25/25I",764000,0.01]
[null,null,"Schedule 31/32",253000,1.7999999999999999E-2]
[null,null,"Street and Area Lights",73000,1.0999999999999999E-2]
[null,null,"Total",{"$f":"SUM(D61:D66)","v":7621000},1.2999999999999999E-2]

{"sheet":"LIRAP Balance","index":1,"n_rows":15,"n_cols":29,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,2023,2023,2023,2023,2023,2023,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025]
[null,"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","End August","End September","End October "]
["Expected elec tariff rider revenue",null,{"$f":"-'Revenue By Month'!D39","v":-831651.568269838},{"$f":"-'Revenue By Month'!E39","v":-694515.70772877289},{"$f":"-'Revenue By Month'!F39","v":-720123.94586081547},{"$f":"-'Revenue By Month'!G39","v":-1483042.6409134124},{"$f":"-'Revenue By Month'!H39","v":-1681278.0822653377},{"$f":"-'Revenue By Month'!I39","v":-1703781.5185390564},{"$f":"-'Revenue By Month'!J39","v":-1509411.2376659932},{"$f":"-'Revenue By Month'!K39","v":-1406417.6384517031},{"$f":"-'Revenue By Month'!L39","v":-1241976.0260746952},{"$f":"-'Revenue By Month'!M39","v":-1197515.0891647548},{"$f":"-'Revenue By Month'!N39","v":-1240291.1672569867},{"$f":"-'Revenue By Month'!O39","v":-1400294.0735527026},{"$f":"-'Revenue By Month'!P39","v":-1457559.7700759841},{"$f":"-'Revenue By Month'!Q39","v":-1226071.2648509957},{"$f":"-'Revenue By Month'!R39","v":-1271121.1629660826},{"$f":"-'Revenue By Month'!S39","v":-1461416.1232290491},{"$f":"-'Revenue By Month'!T39","v":-1676736.3893780669},{"$f":"-'Revenue By Month'!U39","v":-1705566.7057170605},{"$f":"-'Revenue By Month'!V39","v":-1514733.9273882338},{"$f":"-'Revenue By Month'!W39","v":-1416196.1134525475},{"$f":"-'Revenue By Month'!X39","v":-1253001.8048476817},{"$f":"-'Revenue By Month'!Y39","v":-1206791.7181666696},{"$f":"-'Revenue By Month'!Z39","v":-1243387.7984252058},{"$f":"-'Revenue By Month'!AA39","v":-1401113.3990078},{"$f":"-'Revenue By Month'!AB39","v":-1456929.4957889188},{"$f":"-'Revenue By Month'!AC39","v":-1227441.3830232681},{"$f":"-'Revenue By Month'!AD39","v":-1277707.5124251742}]
["Expected LIRAP Expense",null,{"$f":"'LIRAP Expense Summary'!$B$48","v":372000},{"$f":"'LIRAP Expense Summary'!$B$48","v":372000},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$C$32/12","v":1166051.4288502189},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$D$32/12","v":1925754.9039043912},{"$f":"'LIRAP Expense Summary'!$E$32/12","v":2260981.6414314779}]
["Net change in balance",null,{"$f":"C3+C4","v":-459651.568269838},-322515.70772877289,445927.48298940342,-316991.21206319355,-515226.65341511881,-537730.08968883753,-343359.80881577427,-240366.20960148424,-75924.597224476282,-31463.660314535955,-74239.738406767836,-234242.64470248367,-291508.34122576518,-60019.83600077685,{"$f":"Q3+Q4","v":654633.74093830865},464338.78067534207,249018.51452632435,220188.19818733074,411020.97651615739,509558.79045184376,672753.09905670956,718963.18573772162,682367.10547918547,524641.50489659118,468825.40811547241,698313.52088112314,{"$f":"AC3+AC4","v":983274.12900630361}]
["Accounting Adjustment"]
["Elec Tariff rider balance",-4200584.37,{"$f":"C5+C6+B7","v":-4660235.9382698378},{"$f":"D5+D6+C7","v":-4982751.6459986102},{"$f":"E5+E6+D7","v":-4536824.1630092068},-4853815.3750724001,-5369042.0284875184,-5906772.118176356,-6250131.9269921305,-6490498.1365936147,-6566422.7338180915,-6597886.3941326272,-6672126.1325393952,-6906368.7772418791,-7197877.1184676439,{"$f":"O7+P5+P6","v":-7257896.9544684207},{"$f":"P7+Q5+Q6","v":-6603263.2135301121},{"$f":"Q7+R5+R6","v":-6138924.4328547698},-5889905.9183284454,-5669717.7201411147,-5258696.7436249573,-4749137.953173114,-4076384.8541164044,-3357421.6683786828,-2675054.5628994973,-2150413.0580029059,-1681587.6498874335,-983274.12900631037,{"$f":"AB7+AC5+AC6","v":-6.7520886659622192E-9}]
[]
[]
[]
["Forecasted End of October 2023 Balance",{"$f":"E7","v":-4536824.1630092068},"Overfunded \"Rebate\""]
["November 2023 - October 2025 Expenditure Budget",{"$f":"SUM(F4:AC4)","v":38196606.205636576}]
["November 2023 - October 2025 Forecasted Revenue",{"$f":"SUM(F3:AC3)","v":-33659782.042627379}]
[null,{"$f":"SUM(B6:P6)","v":0}]
["Total Projected DSM Balance October 2025",{"$f":"B11+B12+B14+B13","v":0},"(Overfunded)/Underfunded"]

{"sheet":"LIRAP Expense Summary","index":2,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[37,0,37,1],[0,0,0,5],[1,0,1,1],[1,7,2,7],[1,8,1,9],[1,10,7,10],[1,11,1,13],[16,0,16,5],[18,7,19,7],[18,8,18,10],[23,0,23,5]]}
["Washington LIRAP Spending Forecast"]
["Direct Service",null,"23-24 PY (Existing Budget)","24-25 PY","25-26 PY","26-27 PY",null,"Arrearage Programs","Oregon Actuals (Oct 22-May 23)",null,null,"Washington Forecast"]
["Customers",129500,47915,73815,86765,93240,null,null,"Participants","Avg. Benefit",null,"Participants","Avg. Benefit","Total Benefit"]
["Saturation Forecast",1,0.37,0.56999999999999995,0.67,0.72,null,"AFP",1086,496,null,{"$f":"L6*L7","v":3080},{"$f":"M6*J7","v":711.96172248803828},{"$f":"L4*M4","v":2192842.1052631577}]
["LIRAP Share Elec",1837570.9763249997,679901.26124024985,1047415.4565052497,1231172.5541377498,1323051.1029539998,null,"AMP",491,98,null,{"$f":"L6*L8","v":1400},{"$f":"M6*J8","v":140.66985645933013},{"$f":"L5*M5","v":196937.7990430622}]
["LIRAP Share Gas",1079208.351175,399307.08993474999,615148.76016974996,723069.59528725001,777030.01284599991,null,"Avg Past Due",9629,209,null,28000,300]
["BD Elec",35341196.754779994,13076242.799268598,20144482.150224596,23678601.825702596,25445661.663441595,null,"AFP %",{"$f":"I4/I6","v":0.11278429743483227},{"$f":"J4/J6","v":2.3732057416267942},null,0.11,{"$f":"M4/M6","v":2.3732057416267942}]
["BD Gas",20755940.951219998,7679698.1519513996,11830886.342195397,13906480.437317399,14944277.484878398,null,"AMP %",{"$f":"I5/I6","v":5.0991795617405751E-2},{"$f":"J5/J6","v":0.46889952153110048},null,0.05,{"$f":"M5/M6","v":0.46889952153110043}]
["AFP Elec",1381490.5263157894,511151.49473684211,787449.59999999986,925598.65263157897,994673.1789473684]
["AFP Gas",811351.57894736831,300200.08421052626,462470.39999999991,543605.55789473676,584173.13684210519]
["AMP Elec",124070.81339712918,45906.200956937799,70720.363636363632,83127.444976076556,89330.985645933004,null,"Average Annual Bill","Electric Only","Dual Fuel","Gas Only","Overall"]
["AMP Gas",72866.985645933019,26960.784688995216,41534.181818181816,48820.880382775125,52464.229665071769,null,"Electric ",1248,1032,0,1128]
["Other DS Elec",2901325.3783783782,1073490.3899999999,1653755.4656756755,1943888.0035135134,2088954.2724324323,null,"Gas ",0,948,888,864]
["Other DS Gas",1703953,630462.61,971253.21,1141648.51,1226846.1599999999]
["LIHEAP ",-6675000,-6000000,-6200000,-7000000,-7500000]
["Direct Service Total",{"$f":"SUM(B5:B15)","v":59333975.316184588},{"$f":"SUM(C5:C15)","v":18423320.866988298},{"$f":"SUM(D5:D15)","v":31425115.930225216},{"$f":"SUM(E5:E15)","v":37226013.461843677},{"$f":"SUM(F5:F15)","v":40026462.2276529},null,"Percent Electric",0.63]
[null,null,null,null,null,null,null,"Percent Gas",0.37]
["Admin/Con-Ed/Outreach",1,0.37,0.56999999999999995,0.67,0.72]
["Agency Admin Elec",4033013.5135135134,1492215,2298817.702702703,2702119.054054054,2903769.7297297297,null,"LIRAP Share","WA Actuals (Oct 2018-Sept 22)"]
["Agency Admin Gas",2459386.4864864866,909973,1401850.2972972975,1647788.945945946,1770758.2702702705,null,null,"Participants","Total Benefit","Average Benefit"]
["Agency Con-Ed Elec",1026424.3243243244,379777,585061.86486486485,687704.29729729728,739025.51351351349,null,"18-19 PY",10211,2957944.14,{"$f":"J21/I21","v":289.68212124179809}]
["Agency Con-Ed Gas",626024.32432432426,231629,356833.86486486485,419436.29729729728,450737.51351351349,null,"19-20 PY",11996,3528478.38,{"$f":"J22/I22","v":294.13791097032345}]
["Admin/Con-Ed/Outreach Total",{"$f":"SUM(B19:B22)","v":8144848.6486486495},{"$f":"SUM(C19:C22)","v":3013594},{"$f":"SUM(D19:D22)","v":4642563.7297297306},{"$f":"SUM(E19:E22)","v":5457048.5945945941},{"$f":"SUM(F19:F22)","v":5864291.0270270277},null,"20-21 PY",7337,2306538.34,314.37077006951068]
[null,null,null,null,null,null,null,"21-22",8978,2874156.45,320.13326464691471]
["LIRAP Total",74153823.96483323,27436914.866988298,42267679.65995495,49683062.056438267,53390753.254679926,null,"Total",{"$f":"SUM(I21:I24)","v":38522},{"$f":"SUM(J21:J24)","v":11667117.309999999},302.86894008618447]
["Avista Outreach Elec",63000,441000,315000,157500,157500,null,"Avg",{"$f":"AVERAGE(I21:I24)","v":9630.5},{"$f":"AVERAGE(J21:J24)","v":2916779.3274999997},{"$f":"J26/I26","v":302.86894008618447}]
["Avista Outreach Gas",37000,259000,185000,92500,92500]
["Avista Con-Ed Electric",197116.21621621621,72933,112356.24324324324,132067.86486486488,141923.67567567568]
["Avista Con-Ed Gas",120205.4054054054,44476,68517.08108108108,80537.621621621627,86547.891891891893]
["LIRAP Grand Total",{"$f":"SUM(B16, B23, B26:B29)","v":67896145.586454853},{"$f":"SUM(C16, C23, C26:C29)","v":22254323.866988298},{"$f":"SUM(D16, D23, D26:D29)","v":36748552.984279267},{"$f":"SUM(E16, E23, E26:E29)","v":43145667.542924754},{"$f":"SUM(F16, F23, F26:F29)","v":46369224.82224749}]
[]
[null,"Annual Electric (Oct - Sep)",{"$f":"C5+C7+C9+C11+C13+C19+C21+C26+C28+(C15*$I$16)","v":13992617.146202628},{"$f":"D5+D7+D9+D11+D13+D19+D21+D26+D28+(D15*$I$16)","v":23109058.846852694},{"$f":"E5+E7+E9+E11+E13+E19+E21+E26+E28+(E15*$I$16)","v":27131779.697177734},{"$f":"F5+F7+F9+F11+F13+F19+F21+F26+F28+(F15*$I$16)","v":29158890.122340247}]
[null,"Annual Natural Gas (Oct - Sep)",{"$f":"C6+C8+C10+C12+C14+C20+C22+C27+C29+(C15*$I$17)","v":8261706.72078567},{"$f":"D6+D8+D10+D12+D14+D20+D22+D27+D29+(D15*$I$17)","v":13639494.137426574},{"$f":"E6+E8+E10+E12+E14+E20+E22+E27+E29+(E15*$I$17)","v":16013887.845747024},{"$f":"F6+F8+F10+F12+F14+F20+F22+F27+F29+(F15*$I$17)","v":17210334.699907251}]
[null,null,{"$f":"C32+C33","v":22254323.866988298},{"$f":"D32+D33","v":36748552.984279267},43145667.542924762,46369224.822247498]
[null,null,{"$f":"C34-C30","v":0},{"$f":"D34-D30","v":0},0,0]
[]
[]
["Estimated Total LIRAP Costs Aug-Sept 2023"]
["Direct Service Electric",882000]
["Direct Service Gas",518000]
["Admin Electric",465000]
["Admin Gas",283500]
["Con-Ed Electric",141000]
["Con-Ed Gas",86000]
["Total",2375500]
[]
["Monthly Gas",{"$f":"(B40+B42+B44)/4","v":221875}]
["Monthly Electric",{"$f":"(B39+B41+B43)/4","v":372000}]

{"sheet":"Revenue By Month","index":3,"n_rows":39,"n_cols":31,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Usage",null,null,{"$f":"'Billing Determinants'!C7","v":"2023-08-31"},{"$f":"'Billing Determinants'!D7","v":"2023-09-30"},{"$f":"'Billing Determinants'!E7","v":"2023-10-30"},{"$f":"'Billing Determinants'!F7","v":"2023-11-30"},{"$f":"'Billing Determinants'!G7","v":"2023-12-30"},{"$f":"'Billing Determinants'!H7","v":"2024-01-30"},{"$f":"'Billing Determinants'!I7","v":"2024-02-29"},{"$f":"'Billing Determinants'!J7","v":"2024-03-29"},{"$f":"'Billing Determinants'!K7","v":"2024-04-29"},{"$f":"'Billing Determinants'!L7","v":"2024-05-29"},{"$f":"'Billing Determinants'!M7","v":"2024-06-29"},{"$f":"'Billing Determinants'!N7","v":"2024-07-29"},{"$f":"'Billing Determinants'!O7","v":"2024-08-29"},{"$f":"'Billing Determinants'!P7","v":"2024-09-29"},{"$f":"'Billing Determinants'!Q7","v":"2024-10-29"},{"$f":"'Billing Determinants'!R7","v":"2024-11-29"},{"$f":"'Billing Determinants'!S7","v":"2024-12-29"},{"$f":"'Billing Determinants'!T7","v":"2025-01-29"},{"$f":"'Billing Determinants'!U7","v":"2025-02-28"},{"$f":"'Billing Determinants'!V7","v":"2025-03-28"},{"$f":"'Billing Determinants'!W7","v":"2025-04-28"},{"$f":"'Billing Determinants'!X7","v":"2025-05-28"},{"$f":"'Billing Determinants'!Y7","v":"2025-06-28"},{"$f":"'Billing Determinants'!Z7","v":"2025-07-28"},{"$f":"'Billing Determinants'!AA7","v":"2025-08-28"},{"$f":"'Billing Determinants'!AB7","v":"2025-09-28"},{"$f":"'Billing Determinants'!AC7","v":"2025-10-28"}]
[null,"Residential Schedule 001",null,{"$f":"'Billing Determinants'!C19","v":216209497.7530745},{"$f":"'Billing Determinants'!D19","v":164378140.16461864},{"$f":"'Billing Determinants'!E19","v":174139117.2331399},{"$f":"'Billing Determinants'!F19","v":235946007.98693439},{"$f":"'Billing Determinants'!G19","v":297456462.56435245},{"$f":"'Billing Determinants'!H19","v":301765375.53165054},{"$f":"'Billing Determinants'!I19","v":255859994.07496363},{"$f":"'Billing Determinants'!J19","v":225841060.46251208},{"$f":"'Billing Determinants'!K19","v":182482987.26500857},{"$f":"'Billing Determinants'!L19","v":163759072.52232468},{"$f":"'Billing Determinants'!M19","v":161242849.58974019},{"$f":"'Billing Determinants'!N19","v":192776018.12559634},{"$f":"'Billing Determinants'!O19","v":210064416.9829776},{"$f":"'Billing Determinants'!P19","v":164248252.80340925},{"$f":"'Billing Determinants'!Q19","v":175151073.13786343},{"$f":"'Billing Determinants'!R19","v":230797453.97304013},{"$f":"'Billing Determinants'!S19","v":298268989.45558703},{"$f":"'Billing Determinants'!T19","v":301956578.94019938},{"$f":"'Billing Determinants'!U19","v":258602225.11612216},{"$f":"'Billing Determinants'!V19","v":230124279.31823125},{"$f":"'Billing Determinants'!W19","v":187095773.03556761},{"$f":"'Billing Determinants'!X19","v":168319383.42280456},{"$f":"'Billing Determinants'!Y19","v":163683407.76655337},{"$f":"'Billing Determinants'!Z19","v":192711531.44051418},{"$f":"'Billing Determinants'!AA19","v":210081292.76810104},{"$f":"'Billing Determinants'!AB19","v":165466383.49115184},{"$f":"'Billing Determinants'!AC19","v":177402346.55275396}]
[null,"General Svc Schedule 011/012",null,{"$f":"'Billing Determinants'!C20","v":57384870.776428893},{"$f":"'Billing Determinants'!D20","v":51158303.551664442},{"$f":"'Billing Determinants'!E20","v":52609259.186167553},{"$f":"'Billing Determinants'!F20","v":59969436.391246565},{"$f":"'Billing Determinants'!G20","v":67514674.551979929},{"$f":"'Billing Determinants'!H20","v":66175768.174606346},{"$f":"'Billing Determinants'!I20","v":60824854.044374868},{"$f":"'Billing Determinants'!J20","v":57642337.671863586},{"$f":"'Billing Determinants'!K20","v":50313004.490033604},{"$f":"'Billing Determinants'!L20","v":48799715.822577871},{"$f":"'Billing Determinants'!M20","v":50199193.221615747},{"$f":"'Billing Determinants'!N20","v":57934521.50008779},{"$f":"'Billing Determinants'!O20","v":57518232.074999891},{"$f":"'Billing Determinants'!P20","v":51168047.43729791},{"$f":"'Billing Determinants'!Q20","v":53023975.411245033},{"$f":"'Billing Determinants'!R20","v":60307610.725034952},{"$f":"'Billing Determinants'!S20","v":67675694.459992915},{"$f":"'Billing Determinants'!T20","v":67356187.224309251},{"$f":"'Billing Determinants'!U20","v":61603730.850496598},{"$f":"'Billing Determinants'!V20","v":58644864.541692585},{"$f":"'Billing Determinants'!W20","v":50922850.609907754},{"$f":"'Billing Determinants'!X20","v":49588145.103822492},{"$f":"'Billing Determinants'!Y20","v":50973821.633687682},{"$f":"'Billing Determinants'!Z20","v":58904769.936036184},{"$f":"'Billing Determinants'!AA20","v":58530067.262217902},{"$f":"'Billing Determinants'!AB20","v":51716360.914509796},{"$f":"'Billing Determinants'!AC20","v":53899119.969902568}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'Billing Determinants'!C21","v":112338964.88710393},{"$f":"'Billing Determinants'!D21","v":104825173.70255427},{"$f":"'Billing Determinants'!E21","v":116001079.12916349},{"$f":"'Billing Determinants'!F21","v":117082091.41523786},{"$f":"'Billing Determinants'!G21","v":113100785.03157571},{"$f":"'Billing Determinants'!H21","v":109129046.029506},{"$f":"'Billing Determinants'!I21","v":106848952.04278769},{"$f":"'Billing Determinants'!J21","v":104370219.89654699},{"$f":"'Billing Determinants'!K21","v":101231853.44569716},{"$f":"'Billing Determinants'!L21","v":105586298.70959443},{"$f":"'Billing Determinants'!M21","v":109020288.32537802},{"$f":"'Billing Determinants'!N21","v":118413173.59211193},{"$f":"'Billing Determinants'!O21","v":109806639.40594229},{"$f":"'Billing Determinants'!P21","v":102473332.88843574},{"$f":"'Billing Determinants'!Q21","v":114194166.42928523},{"$f":"'Billing Determinants'!R21","v":115084309.02834532},{"$f":"'Billing Determinants'!S21","v":111268549.41096006},{"$f":"'Billing Determinants'!T21","v":108719787.93629479},{"$f":"'Billing Determinants'!U21","v":105456170.84659164},{"$f":"'Billing Determinants'!V21","v":103309341.67486668},{"$f":"'Billing Determinants'!W21","v":99519722.204151526},{"$f":"'Billing Determinants'!X21","v":104178700.0585538},{"$f":"'Billing Determinants'!Y21","v":107997928.17311805},{"$f":"'Billing Determinants'!Z21","v":117780625.7352528},{"$f":"'Billing Determinants'!AA21","v":109442798.22064903},{"$f":"'Billing Determinants'!AB21","v":101079915.94890866},{"$f":"'Billing Determinants'!AC21","v":112842324.6138899}]
[null,"Extra Large Gen Schedule 25/25I (1st & 2nd Block Only)",null,{"$f":"'Billing Determinants'!C22","v":60430912.799999997},{"$f":"'Billing Determinants'!D22","v":50534307.399999999},{"$f":"'Billing Determinants'!E22","v":52769328},{"$f":"'Billing Determinants'!F22","v":57591762},{"$f":"'Billing Determinants'!G22","v":49831570},{"$f":"'Billing Determinants'!H22","v":60425160.600000001},{"$f":"'Billing Determinants'!I22","v":50766954},{"$f":"'Billing Determinants'!J22","v":55739145.200000003},{"$f":"'Billing Determinants'!K22","v":57763064},{"$f":"'Billing Determinants'!L22","v":50780495},{"$f":"'Billing Determinants'!M22","v":54466029},{"$f":"'Billing Determinants'!N22","v":51128029.399999999},{"$f":"'Billing Determinants'!O22","v":59757273.799999997},{"$f":"'Billing Determinants'!P22","v":50316026.399999999},{"$f":"'Billing Determinants'!Q22","v":51172946},{"$f":"'Billing Determinants'!R22","v":57152985},{"$f":"'Billing Determinants'!S22","v":49027012},{"$f":"'Billing Determinants'!T22","v":59506312.600000001},{"$f":"'Billing Determinants'!U22","v":50054920},{"$f":"'Billing Determinants'!V22","v":54053229.200000003},{"$f":"'Billing Determinants'!W22","v":57717280},{"$f":"'Billing Determinants'!X22","v":49911639},{"$f":"'Billing Determinants'!Y22","v":53742315},{"$f":"'Billing Determinants'!Z22","v":50736511.399999999},{"$f":"'Billing Determinants'!AA22","v":58638031.799999997},{"$f":"'Billing Determinants'!AB22","v":50343797.399999999},{"$f":"'Billing Determinants'!AC22","v":50491311}]
[null,"Pumping Schedule 31/32",null,{"$f":"'Billing Determinants'!C23","v":28309316.090187293},{"$f":"'Billing Determinants'!D23","v":22882087.698015667},{"$f":"'Billing Determinants'!E23","v":11844667.08025321},{"$f":"'Billing Determinants'!F23","v":2148535.058652895},{"$f":"'Billing Determinants'!G23","v":3425874.6507218229},{"$f":"'Billing Determinants'!H23","v":4009939.9112014472},{"$f":"'Billing Determinants'!I23","v":4379445.3481514584},{"$f":"'Billing Determinants'!J23","v":4230011.2203625403},{"$f":"'Billing Determinants'!K23","v":6236383.3650903627},{"$f":"'Billing Determinants'!L23","v":13497389.686853914},{"$f":"'Billing Determinants'!M23","v":21867571.970769797},{"$f":"'Billing Determinants'!N23","v":25045393.693771407},{"$f":"'Billing Determinants'!O23","v":28320609.56866435},{"$f":"'Billing Determinants'!P23","v":22455024.314864375},{"$f":"'Billing Determinants'!Q23","v":11917494.495228428},{"$f":"'Billing Determinants'!R23","v":2465369.7860727538},{"$f":"'Billing Determinants'!S23","v":3467393.6584835933},{"$f":"'Billing Determinants'!T23","v":4137155.6569303661},{"$f":"'Billing Determinants'!U23","v":4350092.8139849603},{"$f":"'Billing Determinants'!V23","v":4184404.4901869316},{"$f":"'Billing Determinants'!W23","v":6150907.0615069643},{"$f":"'Billing Determinants'!X23","v":13006276.193674263},{"$f":"'Billing Determinants'!Y23","v":21113767.436383747},{"$f":"'Billing Determinants'!Z23","v":25239808.716203485},{"$f":"'Billing Determinants'!AA23","v":28201935.39506631},{"$f":"'Billing Determinants'!AB23","v":22464573.924035482},{"$f":"'Billing Determinants'!AC23","v":12608229.998966608}]
[null,"Street and Area Lights*",null,358587.35046994447,357429.89455422648,357259.35647346941,{"$f":"'Billing Determinants'!F24","v":1330329.7010500454},{"$f":"'Billing Determinants'!G24","v":1338864.1154058825},{"$f":"'Billing Determinants'!H24","v":1340188.064714706},{"$f":"'Billing Determinants'!I24","v":1272098.5856400984},{"$f":"'Billing Determinants'!J24","v":1353925.3824872593},{"$f":"'Billing Determinants'!K24","v":1292839.6562630786},{"$f":"'Billing Determinants'!L24","v":1297017.5794819526},{"$f":"'Billing Determinants'!M24","v":1313152.508189003},{"$f":"'Billing Determinants'!N24","v":1314340.3992536208},{"$f":"'Billing Determinants'!O24","v":1313371.6555335638},{"$f":"'Billing Determinants'!P24","v":1318741.2360407989},{"$f":"'Billing Determinants'!Q24","v":1283836.7137207252},{"$f":"'Billing Determinants'!R24","v":1303362.0311496446},{"$f":"'Billing Determinants'!S24","v":1306376.539913778},{"$f":"'Billing Determinants'!T24","v":1324673.3176681858},{"$f":"'Billing Determinants'!U24","v":1249320.6327347257},{"$f":"'Billing Determinants'!V24","v":1328407.0762940696},{"$f":"'Billing Determinants'!W24","v":1270504.384507658},{"$f":"'Billing Determinants'!X24","v":1273798.0869214772},{"$f":"'Billing Determinants'!Y24","v":1287598.2319709167},{"$f":"'Billing Determinants'!Z24","v":1291310.3797258679},{"$f":"'Billing Determinants'!AA24","v":1287442.0677841802},{"$f":"'Billing Determinants'!AB24","v":1293084.1010535024},{"$f":"'Billing Determinants'!AC24","v":1260162.7084792485}]
["Total Forecasted Usage",null,null,{"$f":"SUM(D5:D10)","v":475032149.65726459},394135442.41140723,407720709.9851976,474068162.55312175,532668230.9140358,542845478.31167901,479952298.0959177,449176699.83377242,399320132.22209275,383719989.32083285,{"$f":"SUM(N5:N10)","v":398109084.61569279},446611476.71082109,466780543.48811769,391979425.08004802,{"$f":"SUM(R5:R10)","v":406743492.18734282},467111090.54364276,531014015.52493733,543000695.67540193,481316460.25993007,451644526.3012715,402677037.29564154,386277941.8657766,398798838.24171376,446664557.60773253,466181567.5138185,392364115.77965921,{"$f":"SUM(AD5:AD10)","v":408503494.84399229}]
[null,null,null,null,null,null,{"$f":"G11-'Billing Determinants'!F25","v":0},{"$f":"H11-'Billing Determinants'!G25","v":0},{"$f":"I11-'Billing Determinants'!H25","v":0},{"$f":"J11-'Billing Determinants'!I25","v":0},{"$f":"K11-'Billing Determinants'!J25","v":0},{"$f":"L11-'Billing Determinants'!K25","v":0},{"$f":"M11-'Billing Determinants'!L25","v":0},{"$f":"N11-'Billing Determinants'!M25","v":0},{"$f":"O11-'Billing Determinants'!N25","v":0},{"$f":"P11-'Billing Determinants'!O25","v":0},{"$f":"Q11-'Billing Determinants'!P25","v":0},{"$f":"R11-'Billing Determinants'!Q25","v":0},{"$f":"S11-'Billing Determinants'!R25","v":0},{"$f":"T11-'Billing Determinants'!S25","v":0},{"$f":"U11-'Billing Determinants'!T25","v":0},{"$f":"V11-'Billing Determinants'!U25","v":0},{"$f":"W11-'Billing Determinants'!V25","v":0},{"$f":"X11-'Billing Determinants'!W25","v":0},{"$f":"Y11-'Billing Determinants'!X25","v":0},{"$f":"Z11-'Billing Determinants'!Y25","v":0},{"$f":"AA11-'Billing Determinants'!Z25","v":0},{"$f":"AB11-'Billing Determinants'!AA25","v":0},{"$f":"AC11-'Billing Determinants'!AB25","v":0},{"$f":"AD11-'Billing Determinants'!AC25","v":0}]
["*Current LIRAP rate for street and area lights is a percentage of base revenue. Therefore, forecasted base revenue by month is included for June 2023 - October 2023 before new rates go into effect November 1, 2023 at a per kwh rate. "]
["LIRAP Rates"]
[null,"Residential Schedule 001",null,{"$f":"'WA Electric - Sched 92'!D9","v":1.7899999999999999E-3},{"$f":"D15","v":1.7899999999999999E-3},{"$f":"E15","v":1.7899999999999999E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3},{"$f":"'WA Electric - Sched 92'!$D$23","v":3.3350384902737281E-3}]
[null,"General Svc Schedule 011/012",null,{"$f":"'WA Electric - Sched 92'!E9","v":2.5999999999999999E-3},{"$f":"D16","v":2.5999999999999999E-3},{"$f":"E16","v":2.5999999999999999E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3},{"$f":"'WA Electric - Sched 92'!$E$23","v":3.8147753736749541E-3}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'WA Electric - Sched 92'!F9","v":1.8600000000000001E-3},1.8600000000000001E-3,{"$f":"E17","v":1.8600000000000001E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3},{"$f":"'WA Electric - Sched 92'!$F$23","v":3.1858558190248571E-3}]
[null,"Extra Large Gen Schedule 25/25I (1st & 2nd Block Only)",null,{"$f":"'WA Electric - Sched 92'!G9","v":1.1800000000000001E-3},1.1800000000000001E-3,{"$f":"E18","v":1.1800000000000001E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3},{"$f":"'WA Electric - Sched 92'!$G$23","v":2.3560864336930987E-3}]
[null,"Pumping Schedule 31/32",null,{"$f":"'WA Electric - Sched 92'!H9","v":1.6199999999999999E-3},1.6199999999999999E-3,{"$f":"E19","v":1.6199999999999999E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3},{"$f":"'WA Electric - Sched 92'!$H$23","v":3.3371495713114259E-3}]
[null,"Street and Area Lights",null,{"$f":"'WA Electric - Sched 92'!I9","v":2.1000000000000001E-2},2.1000000000000001E-2,{"$f":"E20","v":2.1000000000000001E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2},{"$f":"'WA Electric - Sched 92'!$I$23","v":1.4779675218575618E-2}]
[]
[]
["Gross LIRAP Revenue",null,null,{"$f":"D4","v":"2023-08-31"},"2023-09-30","2023-10-30","2023-11-30","2023-12-30","2024-01-30","2024-02-29","2024-03-29","2024-04-29","2024-05-29","2024-06-29","2024-07-29","2024-08-29","2024-09-29",{"$f":"R4","v":"2024-10-29"},"2024-11-29","2024-12-29","2025-01-29","2025-02-28","2025-03-28","2025-04-28","2025-05-28","2025-06-28","2025-07-28","2025-08-28","2025-09-28",{"$f":"AD4","v":"2025-10-28"}]
[null,"Residential Schedule 001",null,{"$f":"D5*D15","v":387015.00097800331},{"$f":"E5*E15","v":294236.87089466734},311709.01984732039,786889.01826285862,992028.75183278171,1006399.1424299604,853302.92836121167,753188.62932671397,608587.78634893417,546142.80999347963,{"$f":"N5*N15","v":537751.10966320091},642915.44045056973,700572.91607514047,{"$f":"Q5*Q15","v":547774.24505957961},{"$f":"R5*R15","v":584135.57052752341},769718.39245726797,994738.56028943148,1007036.8131569424,862448.37443269882,767473.32907280372,623971.60444113554,561351.62237419491,545890.46512062522,642700.37487371045,700629.19746808079,551836.75778938481,{"$f":"AD5*AD15","v":591643.65401831327}]
[null,"General Svc Schedule 011/012",null,{"$f":"D6*D16","v":149200.66401871512},{"$f":"E6*E16","v":133011.58923432755},136784.07388403564,228769.92911849401,257553.31784257214,252445.69076651105,232033.15531585467,219892.57023168128,191932.81050417759,186159.95416230606,{"$f":"N6*N16","v":191498.64608017044},221007.18590417705,219419.13525703043,195194.6072828359,{"$f":"R6*R16","v":202274.55561316386},230059.98823903888,258167.5726223315,256948.72428793448,235004.39537497447,223716.9850461524,194259.2364640047,189167.6347682823,194453.67947029139,224708.46574397964,223279.05921144749,197286.30003275789,{"$f":"AD6*AD16","v":205613.03552393624}]
[null,"Large Gen Svc Schedule 021/022",null,208950.47469001333,{"$f":"E7*E17","v":194974.82308675096},215762.00718024411,373006.66223883582,360322.7941291249,347669.40631773317,340405.35562222305,332508.47239031811,322510.08937064582,336382.72415325814,{"$f":"N7*N17","v":347322.91995317326},377247.29813763034,349828.12111898541,326465.26387749426,{"$f":"R7*R17","v":363806.14961743134},366642.0155964088,354485.55561536195,346365.56903999322,335968.15554369346,329128.66733450117,317055.48609183339,331898.31779998884,344065.82791295671,375232.09186704399,348668.97556161799,322026.0384123741,{"$f":"AD7*AD17","v":359499.37650345301}]
[null,"Extra Large Gen Schedule 25/25I",null,71308.477104000005,{"$f":"E8*E18","v":59630.482732000004},62267.80704,135691.16914068171,117407.48604662801,142366.90114338673,119611.33159932159,131326.24383136979,136094.77145894623,119643.23536572023,{"$f":"N8*N18","v":128326.6720240349},120462.0564508019,140793.30211466402,118548.90719838379,{"$f":"R8*R18","v":120567.88384270952},134657.37260356516,115511.87785770875,140202.01583596072,117933.71795159335,127354.08001542366,135986.900397666,117596.13553128738,126621.53928676112,119539.60620245524,138156.27122244451,118614.3380747339,{"$f":"AD8*AD18","v":118961.89286647912}]
[null,"Pumping Schedule 31/32",null,45861.092066103411,{"$f":"E9*E19","v":37068.98207078538},19188.360670010199,7169.9828499310779,11432.656122023012,13381.769255650486,14614.864166165458,14116.180130675373,20811.744073345013,45042.808207307797,{"$f":"N9*N19","v":72975.358427876185},83580.224828495135,94510.110081346502,74935.7747661373,{"$f":"R9*R19","v":39770.461645857824},8227.307724716833,11571.211260976479,13806.307226973811,14516.910369354824,13963.983650620925,20526.496863484386,43403.889024078067,70459.799949097156,84229.016837260846,94114.076613798068,74967.643240288846,{"$f":"AD9*AD19","v":42075.549336047276}]
[null,"Street and Area Lights",null,7530.3343598688343,{"$f":"E10*E20","v":7506.0277856387565},7502.4464859428581,19661.840915144468,{"$f":"H10*H20","v":19787.976787504489},19807.544328294756,18801.203941770058,20010.577423347462,19107.750229263242,{"$f":"M10*M20","v":19169.498577526349},{"$f":"N10*N20","v":19407.967583491423},19425.524227621525,19411.206510069045,19490.567166025976,{"$f":"R10*R20","v":18974.689662475761},19263.267512614788,19307.820973092228,19578.241405848832,18464.553195684639,19633.425145683952,18777.642166799502,18826.32201874239,19030.283680542339,19085.148018723881,19027.975624581599,19111.363043874579,{"$f":"AD10*AD20","v":18624.79555388388}]
[null,"Total",null,{"$f":"SUM(D24:D29)","v":869866.04321670393},726428.77580417006,753213.71510755317,1551188.6025259455,1758532.9827606343,1782070.4542415366,1578768.8390065467,{"$f":"SUM(K24:K29)","v":1471042.6733341059},1299044.9519853119,1252541.0304595982,{"$f":"SUM(N24:N29)","v":1297282.6737319471},1464637.7299992957,1524534.7911572359,1282409.3653504569,{"$f":"SUM(R24:R29)","v":1329529.3109091618},1528568.3441336125,1753782.5986189025,1783937.6709536535,1584336.1068679998,1481270.4702651862,1310577.3664249235,1262243.921516574,1300521.595420274,1465494.7035431741,1523875.5557019704,1283842.440593414,{"$f":"SUM(AD24:AD29)","v":1336418.3038021128},{"$f":"SUM(F30:Q30)-'WA Electric - Sched 92'!D39","v":-576315.59580160677}]
[]
["Net LIRAP Revenue",null,{"$f":"'Rev Conv Factor'!E22","v":0.95606855188236617},{"$f":"D4","v":"2023-08-31"},"2023-09-30","2023-10-30","2023-11-30","2023-12-30","2024-01-30","2024-02-29","2024-03-29","2024-04-29","2024-05-29","2024-06-29","2024-07-29","2024-08-29","2024-09-29",{"$f":"R4","v":"2024-10-29"},"2024-11-29","2024-12-29","2025-01-29","2025-02-28","2025-03-28","2025-04-28","2025-05-28","2025-06-28","2025-07-28","2025-08-28","2025-09-28",{"$f":"AD4","v":"2025-10-28"}]
[null,"Residential Schedule 001",null,{"$f":"D24*$C$32","v":370012.87154179218},{"$f":"E24*$C$32","v":281310.61906666332},298015.19121409935,752319.84418270807,948447.49219043879,962186.57071866747,815816.09503528604,720099.96213465568,581851.64358792035,522149.96547143231,{"$f":"N24*$C$32","v":514126.92468883196},614671.23413438979,669795.73335996596,{"$f":"Q24*$C$32","v":523709.72923256864},{"$f":"R24*$C$32","v":558473.64901722909},735903.54883384297,951038.25483746652,962796.2276471908,824559.76841717109,733757.11433497409,596559.6282737531,536690.63270011335,521908.70647426747,614465.61669976218,669849.54222981236,527593.76989515719,{"$f":"AD24*$C$32","v":565651.89152768045}]
[null,"General Svc Schedule 011/012",null,{"$f":"D25*$C$32","v":142646.06278826043},127168.19750283567,130774.95143888053,218719.73484655013,246238.62762224674,241355.38600008184,221839.60279152534,210232.37119109504,183500.92419744167,177981.67779444362,{"$f":"N25*$C$32","v":183085.83324530232},211298.02018300345,209779.73490047012,186619.4255201481,{"$f":"R25*$C$32","v":193388.34146772671},219953.11980177209,246825.89730001808,245660.59473798689,224680.31197214287,213888.77392456389,185725.14689591512,180857.22663592399,185911.04773935929,214836.6974395549,213470.0868059457,188619.22717854884,{"$f":"AD25*$C$32","v":196580.15712150725}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D26*$C$32","v":199770.97775201406},186409.29676207053,206283.26975604868,356619.93940915866,344493.29199324042,332395.78583199711,325450.85540274065,317900.89368682919,308341.75411204586,321604.94395945093,{"$f":"N26*$C$32","v":332064.52111518534},360674.27803197951,334459.66516595735,312123.17207525048,{"$f":"R26*$C$32","v":347823.61863063701},350534.90091049048,338912.49182039505,331149.22801397805,321208.58794924855,314669.56836146954,303126.77945417882,317317.54407122871,328950.51784494793,358747.60269111575,333351.44255150424,307878.96821333375,{"$f":"AD26*$C$32","v":343706.04829626984}]
[null,"Extra Large Gen Schedule 25/25I",null,{"$f":"D27*$C$32","v":68175.792441758153},57010.829273629686,59532.292105623404,129730.05958355678,112249.60516474875,136112.51701213772,114356.6325908849,125556.89176400824,130115.9310675163,114387.13477862524,{"$f":"N27*$C$32","v":122689.09548990239},115169.98386769003,134608.04846750331,113340.88203239581,{"$f":"R27*$C$32","v":115271.16210902062},128741.67922537476,110437.27378863236,134042.73825127553,112752.71894008327,121759.23085665709,130012.7989381681,112429.96700436038,121058.87170300985,114288.05819456969,132086.86616110994,113403.43843559624,{"$f":"AD27*$C$32","v":113735.72464203987}]
[null,"Pumping Schedule 31/32",null,{"$f":"D28*$C$32","v":43846.347879383356},35440.488008169174,18345.388198773202,6854.9951203550063,10930.40298275161,12793.888753873729,13972.812019303296,13496.035895645435,19897.454018349385,43064.012415475925,{"$f":"N28*$C$32","v":69769.445255236205},79908.424517781925,90358.144083715961,71643.73766484404,{"$f":"R28*$C$32","v":38023.287673448474},7865.8701822606272,11062.87119380671,13199.776157335898,13879.161474635172,13350.525627358185,19624.738131489448,41497.093325313246,67364.398903254536,80528.714154075409,89979.508939899984,71674.20611077681,{"$f":"AD28*$C$32","v":40227.109523369771}]
[null,"Street and Area Lights",null,{"$f":"D29*$C$32","v":7199.5158666298212},7176.2771154044494,7172.8531473903349,18798.067771083628,18918.662311911292,18937.370222298541,17975.239826253135,19131.483779469778,18268.319091421658,18327.354745326695,{"$f":"N29*$C$32","v":18555.347462528549},18572.132817857932,18558.44409837127,18634.318325788448,{"$f":"R29*$C$32","v":18141.104068020504},18417.004275308249,18459.600437748264,18718.140909293274,17653.378634953129,18770.90034752489,17952.713154177258,17999.254429730143,18194.255760366741,18246.709828721952,18192.049100646691,18271.773189855339,{"$f":"AD29*$C$32","v":17806.581314306892}]
[null,"Total",null,{"$f":"SUM(D33:D38)","v":831651.568269838},694515.70772877289,720123.94586081547,1483042.6409134124,1681278.0822653377,1703781.5185390564,1509411.2376659932,1406417.6384517031,1241976.0260746952,1197515.0891647548,{"$f":"SUM(N33:N38)","v":1240291.1672569867},1400294.0735527026,1457559.7700759841,1226071.2648509957,{"$f":"SUM(R33:R38)","v":1271121.1629660826},1461416.1232290491,1676736.3893780669,1705566.7057170605,1514733.9273882338,1416196.1134525475,1253001.8048476817,1206791.7181666696,1243387.7984252058,1401113.3990078,1456929.4957889188,1227441.3830232681,{"$f":"SUM(AD33:AD38)","v":1277707.5124251742},{"$f":"SUM(F39:Q39)-'WA Electric - Sched 92'!D42","v":-550997.21710526571}]

{"sheet":"Billing Determinants","index":4,"n_rows":45,"n_cols":31,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Loads"]
[]
[]
[null,null,"2023-08-31",{"$f":"EDATE(C7, 1)","v":"2023-09-30"},{"$f":"EDATE(D7, 1)","v":"2023-10-30"},{"$f":"EDATE(E7, 1)","v":"2023-11-30"},"2023-12-30","2024-01-30","2024-02-29","2024-03-29","2024-04-29","2024-05-29","2024-06-29","2024-07-29","2024-08-29","2024-09-29","2024-10-29","2024-11-29","2024-12-29","2025-01-29","2025-02-28","2025-03-28","2025-04-28","2025-05-28","2025-06-28","2025-07-28","2025-08-28","2025-09-28","2025-10-28"]
["WA001/002",null,{"$f":"C32+C33","v":216209497.7530745},164378140.16461864,174139117.2331399,235946007.98693439,297456462.56435245,301765375.53165054,255859994.07496363,225841060.46251208,182482987.26500857,163759072.52232468,161242849.58974019,192776018.12559634,210064416.9829776,164248252.80340925,175151073.13786343,230797453.97304013,298268989.45558703,301956578.94019938,258602225.11612216,230124279.31823125,187095773.03556761,168319383.42280456,163683407.76655337,192711531.44051418,210081292.76810104,165466383.49115184,{"$f":"AC32+AC33","v":177402346.55275396}]
["WA011/013",null,{"$f":"C34+C36","v":52746141.427619867},46952302.835522875,47689666.41826316,53375183.450053357,58901607.972593412,57556131.795960084,53423616.008827575,50956725.382201605,45252606.667749502,44381561.950254366,45929470.675717682,53267840.220358506,52837226.725626037,46928856.363244489,48085231.535434589,53549576.973897301,59084818.086098023,58579596.696745813,54068143.020952486,51718225.553632975,45702452.571031734,45061003.190119363,46581425.60586077,54048294.108559698,53699989.302995227,47404873.912998222,{"$f":"AC34+AC36","v":48830991.871300265}]
["WA012",null,{"$f":"C35","v":4638729.3488090299},4206000.7161415657,4919592.7679043962,6594252.9411932062,8613066.5793865137,8619636.378646262,7401238.0355472974,6685612.2896619784,5060397.8222841006,4418153.8723235037,4269722.5458980678,4666681.2797292853,4681005.3493738528,4239191.0740534179,4938743.8758104425,6758033.7511376534,8590876.3738948982,8776590.5275634378,7535587.829544113,6926638.9880596083,5220398.0388760166,4527141.9137031268,4392396.0278269118,4856475.8274764866,4830077.9592226744,4311487.0015115719,{"$f":"AC35","v":5068128.0986023042}]
["WA021/023",null,{"$f":"C37+C39","v":109937207.62322544},102698715.4939623,113671852.7819272,114410353.84445219,109555859.50611316,105663615.05623178,103976370.85462879,101691890.00280541,99058312.707727969,103575969.20129484,107032639.81962354,116013325.40279536,107426392.84884776,100372724.14307229,111850659.14690001,112395136.59629856,107832425.93389189,105248131.46680707,102576888.82358848,100631120.58372223,97331357.472500205,102152947.55001421,105971785.77611437,115344695.82835943,107038654.55190396,98986003.286220774,{"$f":"AC37+AC39","v":110473787.8401915}]
["WA022",null,{"$f":"C38","v":2401757.2638785015},2126458.2085919706,2329226.3472362962,2671737.5707856785,3544925.5254625492,3465430.9732742188,2872581.1881589061,2678329.8937415709,2173540.7379691852,2010329.5082995901,1987648.5057544769,2399848.1893165717,2380246.5570945218,2100608.7453634385,2343507.2823852138,2689172.4320467599,3436123.4770681662,3471656.4694877309,2879282.0230031572,2678221.0911444402,2188364.7316513183,2025752.5085395901,2026142.3970036749,2435929.9068933725,2404143.6687450754,2093912.6626878842,{"$f":"AC38","v":2368536.7736984058}]
["WA025/025I",null,{"$f":"C40+C44-C45","v":60430912.799999997},50534307.399999999,52769328,57591762,49831570,60425160.600000001,50766954,55739145.200000003,57763064,50780495,54466029,51128029.399999999,59757273.799999997,50316026.399999999,51172946,57152985,49027012,59506312.600000001,50054920,54053229.200000003,57717280,49911639,53742315,50736511.399999999,58638031.799999997,50343797.399999999,50491311]
["WA031",null,{"$f":"C41","v":26566751.758787945},21709792.874961346,11410621.379116725,1952766.5761318973,3164471.982197979,3678208.2596704336,4039130.053974513,3898522.7883625552,5826340.4028385654,12778958.490199,20829121.136190742,23313749.406122014,26428761.012388594,21309031.215128899,11417459.090989742,2169238.068355042,3121073.0620580884,3739406.9061371023,4034041.3562367894,3885316.157664693,5773243.5742994081,12255129.704444148,19996966.845588166,23284080.352412105,26394174.382441044,21298267.16491846,{"$f":"AC41","v":12106114.167783566}]
["WA032",null,{"$f":"C42","v":1742564.3313993483},1172294.8230543211,434045.70113648567,195768.48252099779,261402.6685238441,331731.65153101354,340315.29417694558,331488.43199998507,410042.96225179743,718431.19665491395,1038450.8345790538,1731644.2876493931,1891848.5562757547,1145993.0997354772,500035.4042386869,296131.71771771193,346320.59642550471,397748.7507932639,316051.45774817141,299088.33252223843,377663.48720755574,751146.48923011404,1116800.5907955815,1955728.3637913812,1807761.0126252656,1166306.759117024,{"$f":"AC42","v":502115.83118304249}]
["WA04X",null,{"$f":"C43","v":1343017.048684244},1345900.7959291809,1314322.6735311958,1330329.7010500454,1338864.1154058825,1340188.064714706,1272098.5856400984,1353925.3824872593,1292839.6562630786,1297017.5794819526,1313152.508189003,1314340.3992536208,1313371.6555335638,1318741.2360407989,1283836.7137207252,1303362.0311496446,1306376.539913778,1324673.3176681858,1249320.6327347257,1328407.0762940696,1270504.384507658,1273798.0869214772,1287598.2319709167,1291310.3797258679,1287442.0677841802,1293084.1010535024,{"$f":"AC43","v":1260162.7084792485}]
[null,null,{"$f":"SUM(C8:C16)","v":476016579.35547882},395123913.31278217,408677773.30225533,474068162.55312181,532668230.91403586,542845478.31167889,479952298.09591776,449176699.83377242,399320132.22209269,383719989.32083285,398109084.61569273,446611476.71082103,466780543.48811764,391979425.08004802,406743492.18734288,467111090.54364282,531014015.52493739,543000695.67540193,481316460.25993013,451644526.30127144,402677037.29564148,386277941.8657766,398798838.2417137,446664557.60773253,466181567.51381856,392364115.77965927,{"$f":"SUM(AC8:AC16)","v":408503494.84399217}]
[]
["WA001",null,{"$f":"C8","v":216209497.7530745},164378140.16461864,174139117.2331399,235946007.98693439,297456462.56435245,301765375.53165054,255859994.07496363,225841060.46251208,182482987.26500857,163759072.52232468,161242849.58974019,192776018.12559634,210064416.9829776,164248252.80340925,{"$f":"Q8","v":175151073.13786343},230797453.97304013,298268989.45558703,301956578.94019938,258602225.11612216,230124279.31823125,187095773.03556761,168319383.42280456,163683407.76655337,192711531.44051418,210081292.76810104,165466383.49115184,{"$f":"AC8","v":177402346.55275396},{"$f":"SUM(F19:Q19)","v":2566593571.0473332},{"$f":"SUM(R19:AC19)","v":2584509645.2806263}]
["WA011/12",null,{"$f":"C9+C10","v":57384870.776428893},51158303.551664442,52609259.186167553,59969436.391246565,67514674.551979929,66175768.174606346,60824854.044374868,57642337.671863586,50313004.490033604,48799715.822577871,50199193.221615747,57934521.50008779,57518232.074999891,51168047.43729791,{"$f":"Q9+Q10","v":53023975.411245033},60307610.725034952,67675694.459992915,67356187.224309251,61603730.850496598,58644864.541692585,50922850.609907754,49588145.103822492,50973821.633687682,58904769.936036184,58530067.262217902,51716360.914509796,{"$f":"AC9+AC10","v":53899119.969902568},{"$f":"SUM(F20:Q20)","v":681083760.79192913},690123223.23161054]
["WA021/22",null,{"$f":"C11+C12","v":112338964.88710393},104825173.70255427,116001079.12916349,117082091.41523786,113100785.03157571,109129046.029506,106848952.04278769,104370219.89654699,101231853.44569716,105586298.70959443,109020288.32537802,118413173.59211193,109806639.40594229,102473332.88843574,{"$f":"Q11+Q12","v":114194166.42928523},115084309.02834532,111268549.41096006,108719787.93629479,105456170.84659164,103309341.67486668,99519722.204151526,104178700.0585538,107997928.17311805,117780625.7352528,109442798.22064903,101079915.94890866,{"$f":"AC11+AC12","v":112842324.6138899},1311256847.2120991,1296680173.8515823]
["WA025",null,{"$f":"C13","v":60430912.799999997},50534307.399999999,52769328,57591762,49831570,60425160.600000001,50766954,55739145.200000003,57763064,50780495,54466029,51128029.399999999,59757273.799999997,50316026.399999999,{"$f":"Q13","v":51172946},57152985,49027012,59506312.600000001,50054920,54053229.200000003,57717280,49911639,53742315,50736511.399999999,58638031.799999997,50343797.399999999,{"$f":"AC13","v":50491311},649738455.39999998,641375344.39999998]
["WA031/32",null,{"$f":"C14+C15","v":28309316.090187293},22882087.698015667,11844667.08025321,2148535.058652895,3425874.6507218229,4009939.9112014472,4379445.3481514584,4230011.2203625403,6236383.3650903627,13497389.686853914,21867571.970769797,25045393.693771407,28320609.56866435,22455024.314864375,{"$f":"Q14+Q15","v":11917494.495228428},2465369.7860727538,3467393.6584835933,4137155.6569303661,4350092.8139849603,4184404.4901869316,6150907.0615069643,13006276.193674263,21113767.436383747,25239808.716203485,28201935.39506631,22464573.924035482,{"$f":"AC14+AC15","v":12608229.998966608},147533673.28433281,147389915.13149545]
["WA04X",null,{"$f":"C16","v":1343017.048684244},1345900.7959291809,1314322.6735311958,1330329.7010500454,1338864.1154058825,1340188.064714706,1272098.5856400984,1353925.3824872593,1292839.6562630786,1297017.5794819526,1313152.508189003,1314340.3992536208,1313371.6555335638,1318741.2360407989,{"$f":"Q16","v":1283836.7137207252},1303362.0311496446,1306376.539913778,1324673.3176681858,1249320.6327347257,1328407.0762940696,1270504.384507658,1273798.0869214772,1287598.2319709167,1291310.3797258679,1287442.0677841802,1293084.1010535024,{"$f":"AC16","v":1260162.7084792485},15768705.597780734,15476039.558203256]
["Total",null,{"$f":"SUM(C19:C24)","v":476016579.35547888},395123913.31278223,408677773.30225533,474068162.55312175,532668230.9140358,542845478.31167901,479952298.0959177,449176699.83377242,399320132.22209275,383719989.32083285,398109084.61569279,446611476.71082109,466780543.48811769,391979425.08004802,406743492.18734282,467111090.54364276,531014015.52493733,543000695.67540193,481316460.25993007,451644526.3012715,402677037.29564154,386277941.8657766,398798838.24171376,446664557.60773253,466181567.5138185,392364115.77965921,{"$f":"SUM(AC19:AC24)","v":408503494.84399229},5371975013.3334742,5375554341.4535189]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C32:C44)-C17-C45","v":0},{"$f":"SUM(D32:D44)-D17-D45","v":0},-5.9604644775390625E-8,-5.9604644775390625E-8,-5.9604644775390625E-8,2.1606683731079102E-7,0,0,5.9604644775390625E-8,0,0,0,0,0,5.9604644775390625E-8,0,0,9.6857547760009766E-8,0,0,0,0,0,0,-7.4505805969238281E-8,-3.7252902984619141E-8,0]
["WA_1",null,215442657.22861224,163752148.23941305,173339779.48313203,234685770.72820219,295838192.7049498,300095194.06203902,254448635.09341836,224581696.51276612,181513176.10017586,162969995.6206041,160554701.52058125,192002592.14118013,209238599.52396232,163555764.92429495,174264645.66908044,229437625.80891955,296478795.39701569,300113886.07065749,257030039.52866167,228711497.17790115,185998357.74612343,167422146.11875334,162909364.75811756,191858351.31228501,209174133.78043562,164703446.71386239,176427670.09267277]
["WA_2",null,766840.52446224191,625991.92520558555,799337.750007867,1260237.2587321929,1618269.8594026286,1670181.4696115437,1411358.9815452725,1259363.949745968,969811.16483271564,789076.90172057413,688148.06915895524,773425.9844162201,825817.45901527908,692487.87911429023,886427.46878297767,1359828.1641205717,1790194.0585713389,1842692.8695418537,1572185.5874605016,1412782.1403301023,1097415.2894441639,897237.30405122275,774043.00843580463,853180.12822918477,907158.9876654062,762936.77728943992,974676.46008118591]
["WA_11",null,52730970.275100537,46937131.258801423,47674416.724783435,53360383.109277904,58886735.209790573,57541184.588071309,53408614.277107485,50941696.137034513,45237575.201981515,44366534.570227906,45914454.561973855,53252842.79107628,52822257.964547381,46913868.019383401,48070230.72454261,53534570.248629287,59069810.651970476,58564591.775072806,54053141.04073368,51703226.371209845,45687455.288750902,45046005.919718146,46566425.16444651,54033292.326666251,53684987.41185414,47389872.558655731,48815991.193160295]
["WA_12",null,4638729.3488090299,4206000.7161415657,4919592.7679043962,6594252.9411932062,8613066.5793865137,8619636.378646262,7401238.0355472974,6685612.2896619784,5060397.8222841006,4418153.8723235037,4269722.5458980678,4666681.2797292853,4681005.3493738528,4239191.0740534179,4938743.8758104425,6758033.7511376534,8590876.3738948982,8776590.5275634378,7535587.829544113,6926638.9880596083,5220398.0388760166,4527141.9137031268,4392396.0278269118,4856475.8274764866,4830077.9592226744,4311487.0015115719,5068128.0986023042]
["WA_13",null,15171.152519330233,15171.576721452222,15249.693479725467,14800.340775449076,14872.76280284112,14947.207888777773,15001.731720092279,15029.245167094754,15031.465767987291,15027.380026457709,15016.113743829746,14997.429282225816,14968.761078658319,14988.343861088579,15000.810891982092,15006.725268012968,15007.434127543795,15004.921673008335,15001.980218805953,14999.182423130334,14997.282280830279,14997.270401219697,15000.441414261097,15001.781893447898,15001.891141085451,15001.354342493707,15000.678139967473]
["WA_21",null,109905199.85087353,102666656.85509126,113640007.03762068,114377238.05922967,109523587.98144051,105631380.9316736,103944190.73211814,101659611.78551148,99026068.29631491,103543780.15926491,107000416.02304524,115981061.09043947,107394096.51101667,100340398.62356445,111818411.18798466,112362886.97009891,107800174.49504688,105215875.4609471,102544634.25010045,100598864.36714518,97299094.760670751,102120681.29020296,105939519.1091864,115312432.06014866,107006397.03037058,98953744.842077807,110441528.47037815]
["WA_22",null,2401757.2638785015,2126458.2085919706,2329226.3472362962,2671737.5707856785,3544925.5254625492,3465430.9732742188,2872581.1881589061,2678329.8937415709,2173540.7379691852,2010329.5082995901,1987648.5057544769,2399848.1893165717,2380246.5570945218,2100608.7453634385,2343507.2823852138,2689172.4320467599,3436123.4770681662,3471656.4694877309,2879282.0230031572,2678221.0911444402,2188364.7316513183,2025752.5085395901,2026142.3970036749,2435929.9068933725,2404143.6687450754,2093912.6626878842,2368536.7736984058]
["WA_23",null,32007.772351903888,32058.638871043197,31845.744306512996,33115.785222522187,32271.524672647713,32234.124558181371,32180.122510648922,32278.217293927126,32244.411413059857,32189.04202992783,32223.796578307669,32264.312355892445,32296.337831088167,32325.51950784291,32247.95891534823,32249.626199643895,32251.438845003402,32256.005859970639,32254.573488031259,32256.216577048945,32262.711829452863,32266.259811256212,32266.666927972023,32263.768210768718,32257.521533389441,32258.444142965502,32259.369813352536]
["WA_25",null,58885543,49947496,50764195,49541955,49979591,55440542,48854215,52560911,49147173,49713670,52029033,51512338,58011555,50365851,50452671,49586033,49714103,54926927,49057508,51207377,49361216,49414639,51618075,51429669,57048223,50693189,49948708]
["WA_31",null,26566751.758787945,21709792.874961346,11410621.379116725,1952766.5761318973,3164471.982197979,3678208.2596704336,4039130.053974513,3898522.7883625552,5826340.4028385654,12778958.490199,20829121.136190742,23313749.406122014,26428761.012388594,21309031.215128899,11417459.090989742,2169238.068355042,3121073.0620580884,3739406.9061371023,4034041.3562367894,3885316.157664693,5773243.5742994081,12255129.704444148,19996966.845588166,23284080.352412105,26394174.382441044,21298267.16491846,12106114.167783566]
["WA_32",null,1742564.3313993483,1172294.8230543211,434045.70113648567,195768.48252099779,261402.6685238441,331731.65153101354,340315.29417694558,331488.43199998507,410042.96225179743,718431.19665491395,1038450.8345790538,1731644.2876493931,1891848.5562757547,1145993.0997354772,500035.4042386869,296131.71771771193,346320.59642550471,397748.7507932639,316051.45774817141,299088.33252223843,377663.48720755574,751146.48923011404,1116800.5907955815,1955728.3637913812,1807761.0126252656,1166306.759117024,502115.83118304249]
["WA_4X",null,1343017.048684244,1345900.7959291809,1314322.6735311958,1330329.7010500454,1338864.1154058825,1340188.064714706,1272098.5856400984,1353925.3824872593,1292839.6562630786,1297017.5794819526,1313152.508189003,1314340.3992536208,1313371.6555335638,1318741.2360407989,1283836.7137207252,1303362.0311496446,1306376.539913778,1324673.3176681858,1249320.6327347257,1328407.0762940696,1270504.384507658,1273798.0869214772,1287598.2319709167,1291310.3797258679,1287442.0677841802,1293084.1010535024,1260162.7084792485]
["WA_25I",null,36557518,33791973,36644189,35454061,34638205,35576866,30968543,33226563,36898259,34318289,34622943,34410021,36757867,33155337,35359331,34971206,34099135,35171633,30053216,32894181,36638432,33748464,34310187,34101172,36601957,32855770,35181659]
["WA 25/25I Block 3",null,35012148.200000003,33205161.600000001,34639056,27404254,34786226,30592247.399999999,29055804,30048328.800000001,28282368,33251464,32185947,34794329.600000001,35012148.200000003,33205161.600000001,34639056,27404254,34786226,30592247.399999999,29055804,30048328.800000001,28282368,33251464,32185947,34794329.600000001,35012148.200000003,33205161.600000001,34639056]

{"sheet":"Rev Conv Factor","index":5,"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],[1,0,1,4],[2,0,2,4]]}
["AVISTA UTILITIES"]
["REVENUE CONVERSION FACTOR"]
["WASHINGTON ELECTRIC"]
["TWELVE MONTHS ENDED SEPTEMBER 30, 2021"]
[]
["Line "]
["No.",null,"Description",null,"Factor"]
[]
[1,null,"Revenues",null,1]
[]
[null,null,"Expense:"]
[2,null,"  Uncollectibles",null,3.3262885794710221E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8605159538162764E-2]
[]
[5,null,"  Franchise Fees",null,0]
[]
[6,null,"    Total Expense",null,{"$f":"E12+E14+E16+E18","v":4.393144811763379E-2}]
[]
[7,null,"Net Operating Income Before FIT",null,{"$f":"E9-E20","v":0.95606855188236617}]
[]
[8,null,"  Federal Income Tax @ 21%",null,0.20077439589529689]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.75529415598706928}]
[]
[]
["Source:  UE-220053"]

{"sheet":"Base Revenue","index":6,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14]]}
["AVISTA UTILITIES"]
["WASHINGTON ELECTRIC"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED SEPTEMBER 30, 2021"]
["(000s of Dollars)"]
["Source:  UE-20053 Compliance Filing, Attachment 1"]
[]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Base Tariff","Total Billed",null,"Adjusted Billed","Base ","Sch 78",null,"Percent",null,"Percent ",null,null,null,"Percent ","Total Billed"]
[null,null,null,"Revenue","Proposed","Revenue","Tariff","Percent","Revenue","Misc","Revenue","Rate","Tax","Total","Increase","Proposed","Increase",null,null,null,"Increase","Revenue"]
[null,"Type of","Schedule","Under Present","General","Under Proposed","Percent","Change","at Present","Rate Adjustment","at Present","General","Rate ","Net ","on Billed","General","on Billed",null,null,null,"on Base","at Proposed"]
["No.","Service","Number","Rates(1)","Increase","Rates(1)","Increase","from Sp Ct","Rates (2)","Change","Rates (2)","Increase","Credit","Impact","Revenue","Increase","Revenue",null,null,null,"Revenue","Rates (2)"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(i)","(g)","(h)","(h)","(h)","(i)","(j)","(k)","(j)","(k)",null,"col (m) source"]
[null,null,null,""]
[1,"Residential","1/2",253459.08989999999,26025.316049999983,279484.40594999999,0.10268053933385478,9.3119027380210745E-2,240021.74566977358,0,240021.74566977358,26025.316049999983,-12722,13303.316049999983,5.5425461609228253E-2,26025.316049999983,0.10842899245390084,null,"from Pres & Prop Rev tab",null,0.10268053933385478,253325.06171977357]
[]
[2,"General Service","11/12",81570.42638307692,3263.8133269230725,84833.83971,4.0012213637272372E-2,3.8473011926375679E-2,87406.540884330403,0,87406.540884330403,3263.8133269230725,0,3263.8133269230725,3.7340607395071786E-2,3263.8133269230725,3.7340607395071786E-2,null,"from below",null,4.0012213637272372E-2,90670.354211253478]
[]
[3,"Large General Service","21/22",131152.68517692306,5247.0461030769347,136399.73127999998,4.0007157276259697E-2,3.8468155720232704E-2,142808.50547370259,0,142808.50547370259,5247.0461030769347,0,5247.0461030769347,3.6741831907506024E-2,5247.0461030769347,3.6741831907506024E-2,null,"from below",null,4.0007157276259697E-2,148055.55157677952]
[]
[4,"Extra Large General Service",25,41217.656242999998,823.04935440000145,42040.705597399996,1.9968368641527987E-2,1.9577439120120353E-2,41422.051203000003,0,41422.051203000003,823.04935440000145,0,823.04935440000145,1.9869835763719781E-2,823.04935440000145,1.9869835763719781E-2,null,"from Pres & Prop Rev tab",null,1.9968368641527987E-2,42245.100557400001]
[]
[5,"Extra Large General Service - Special Contract","25I",21772.9124414,435.19906700000166,22208.111508400001,1.9988096134189861E-2,1.9596401379531614E-2,22445.297721399998,0,22445.297721399998,435.19906700000166,0,435.19906700000166,1.9389320311179042E-2,435.19906700000166,1.9389320311179042E-2,null,"from Pres & Prop Rev tab",null,1.9988096134189861E-2,22880.4967884]
[]
[6,"Pumping Service","30/31/32",14578.56552,1496.6072700000013,16075.57279,0.10265806110668708,9.3098223593686413E-2,15745.319493805822,0,15745.319493805822,1496.6072700000013,-732,764.60727000000134,4.8560924425877568E-2,1496.6072700000013,9.5050930569478997E-2,null,"from below",null,0.10265806110668708,16509.926763805823]
[]
[7,"Street & Area Lights","41-48",6900.6056423279988,708.77220000000023,7609.577842327999,0.10271159326254264,9.3142118352148362E-2,7097.8004199979987,0,7097.8004199979987,708.77220000000023,-346,362.77220000000023,5.1110510092379088E-2,708.77220000000023,9.9858006432956323E-2,null,"from Pres & Prop Rev tab",null,0.10271159326254264,7460.572619997999]
[]
[8,"Total",null,550651.94130672794,37999.80337139999,588652.34467812791,6.9008752209652302E-2,null,556947.26086601045,0,556947.26086601045,37999.80337139999,-13799.7,24200.10337139999,4.3451337445794561E-2,37999.80337139999,6.8228728358073254E-2,null,"from below",null,6.9008752209652302E-2,581147.36423741048]
[null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9700965244218858E-2,null,1.9700965244218858E-2]
[]
["(1) Excludes all present rate adjustments:  Schedule 59 (BPA Residential Exchange), Schedule 75 (Decoupling), Schedule 76 (Tax Credit)"]
["      Scheduke 89 (Low Income Discount), 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 75 (Decoupling), Schedule 76 (Tax Credit)"]
["      Scheduke 89 (Low Income Discount), Schedule 91 (DSM), Schedule 92 (LIRAP), Schedule 93 (ERM) and Schedule 98 (REC Revenue)."]