{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["WA Natural Gas - Sched 192","LIRAP Balance","LIRAP Expense Summary","Revenue By Month","Rev Conv Factor","Base Revenue"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":6,"defined_names":13,"comments":2,"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 Natural Gas - Sched 192","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[56,4,56,5]]}
[]
[null,""]
[]
[null,null," ","GEN SERVICE","LRG GEN SVC","INTERRUPTIBLE","TRANSPORT","TRANSPORT"]
["Source",null,"TOTAL","SCHEDULE 101&102","SCH. 111,112&116","SCH. 131&132","SCHEDULE 146","SCHEDULE 148"]
[]
["Forecast","Total Annual Therms",{"$f":"SUM(D7:H7)","v":231835507.77867189},{"$f":"SUM('Revenue By Month'!G4:R4)","v":136079643.457452},{"$f":"SUM('Revenue By Month'!G5:R5)","v":61164730.745119207},{"$f":"SUM('Revenue By Month'!G6:R6)","v":2519394.5761006647},{"$f":"SUM('Revenue By Month'!G7:R7)","v":32071739}]
[]
[null,"Present LIRAP Rates",null,2.929E-2,2.4559999999999998E-2,2.1559999999999999E-2,1.1800000000000001E-3]
[]
[null,"Present Gross LIRAP Revenue",{"$f":"SUM(D11:G11)","v":5580141.3430496268},{"$f":"D7*D9","v":3985772.7568687689},{"$f":"E7*E9","v":1502205.7871001277},{"$f":"F7*F9","v":54318.147060730327},{"$f":"G7*G9","v":37844.652020000001}]
[]
["UG-220054","Base Revenue",{"$f":"SUM(D13:G13)","v":121156640.52599999},{"$f":"'Base Revenue'!F14*1000","v":95552177.950000003},{"$f":"'Base Revenue'!F15*1000","v":21347859.18},{"$f":"'Base Revenue'!F16*1000+619409","v":859088.85},{"$f":"('Base Revenue'!F17*1000-291000)","v":3397514.5459999996}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:F15)","v":1},{"$f":"D13/($C$13-$G$13)","v":0.81142057700248571},{"$f":"E13/($C$13-$G$13)","v":0.1812841170681386},{"$f":"F13/($C$13-$G$13)","v":7.295305929375751E-3},{"$f":"G13/$C$13","v":2.8042330418289366E-2}]
[]
[null,"Revenue Requirement",10228865.820365522]
[null,"Less Sch 146",{"$f":"G21","v":33975.14546}]
[null,"Net to collect from other schedules",{"$f":"C17-C18","v":10194890.674905522}]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D21:G21)","v":10228865.820365522},{"$f":"$C$19*D15","v":8272344.0739090992},{"$f":"$C$19*E15","v":1848171.7546064472},74374.846389975806,{"$f":"0.01*('Base Revenue'!F17*1000-291000)","v":33975.14546}]
[]
[null,"LIRAP Revenue Increase <Decrease>",{"$f":"SUM(D23:G23)","v":4648724.4773158953},{"$f":"D21-D11","v":4286571.3170403298},{"$f":"E21-E11","v":345965.96750631952},20056.699329245479,{"$f":"G21-G11","v":-3869.5065600000016}]
[]
[null,"Proposed LIRAP Rates",null,{"$f":"D21/D7","v":6.0790459643551398E-2},{"$f":"E21/E7","v":3.0216298381300841E-2},{"$f":"F21/F7","v":2.9520920262155907E-2},{"$f":"G21/G7","v":1.0593484020308347E-3}]
[]
[null,"Percentage Increase <Decrease>",null,{"$f":"D21/D11-1","v":1.0754680656726325},{"$f":"E21/E11-1","v":0.23030530868488763},0.36924491011854865,{"$f":"G21/G11-1","v":-0.10224711692302146}]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D29:H29)","v":274078340},208751061,59624181,862933,3489738,1350427]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D31:H31)","v":278727064.47731584},{"$f":"D29+D23","v":213037632.31704032},{"$f":"E29+E23","v":59970146.967506319},882989.69932924549,{"$f":"G29+G23","v":3485868.4934399999},1350427]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C31/C29-1","v":1.6961298281782611E-2},{"$f":"D31/D29-1","v":2.053436900634642E-2},{"$f":"E31/E29-1","v":5.8024439364008362E-3},{"$f":"F31/F29-1","v":2.3242475753326719E-2},{"$f":"G31/G29-1","v":-1.1088243759274086E-3},0]
[]
[]
[null,"Present LIRAP Revenue as a Percentage of Billed Revenue",{"$f":"C11/C29","v":2.0359658275256726E-2}]
[]
[]
["UG-220054","Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95628199999999997}]
[]
[null,"Proposed Net LIRAP Revenue",{"$f":"SUM(D41:H41)","v":9781680.2644307818},{"$f":"D21*$C$39","v":7910693.7356859408},{"$f":"E21*$C$39","v":1767373.3818385624},71123.326855498846,32489.820050779719,0]
[]
[null,"Proposed LIRAP Revenue as a % of Billed Revenue",{"$f":"C21/C29","v":3.7320956557039577E-2}]
[]
[null,null,"Present","Proposed","$ Inc/(Dec)","% Inc/(Dec)"]
[null,"Average Monthly Bill @ 67 Therms",{"$f":"C52+(C53*C51)","v":96.783580000000001},{"$f":"C52+(C53*(C51+(ROUND(D25,5)-D9)))","v":98.894080000000002},{"$f":"D46-C46","v":2.1105000000000018},{"$f":"E46/C46","v":2.1806384926038092E-2}]
[]
[]
[null,"Change in Schedule 192 Rate",null,{"$f":"D25-D9","v":3.1500459643551401E-2}]
[]
[null,"Present Rate (first 70 therms)",1.30274]
[null,"Basic Charge",9.5]
[null,"Average Customer Usage",67]
[]
[]
[]
[null,null,null,null,"Change in Annual Revenue"]
[null,null,null,"Rate Schedule","($)","(%)"]
[null,null,null,"Schedule 101/102",4287000,0.02]
[null,null,null,"Schedule 111/112",346000,6.0000000000000001E-3]
[null,null,null,"Schedule 131/132",20000,2.3E-2]
[null,null,null,"Schedule 146",-4000,-1E-3]
[null,null,null,"Total",{"$f":"SUM(E59:E62)","v":4649000},1.7000000000000001E-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'!D35","v":-111178.10580727163},{"$f":"-'Revenue By Month'!E35","v":-161796.50548711416},{"$f":"-'Revenue By Month'!F35","v":-394388.76576971333},{"$f":"-'Revenue By Month'!G35","v":-1219425.3265351565},{"$f":"-'Revenue By Month'!H35","v":-1769896.7104586677},{"$f":"-'Revenue By Month'!I35","v":-1606157.9898769492},{"$f":"-'Revenue By Month'!J35","v":-1408388.016379762},{"$f":"-'Revenue By Month'!K35","v":-1093476.8930825691},{"$f":"-'Revenue By Month'!L35","v":-698607.84590366553},{"$f":"-'Revenue By Month'!M35","v":-385204.50120449631},{"$f":"-'Revenue By Month'!N35","v":-253827.86091486219},{"$f":"-'Revenue By Month'!O35","v":-191535.71986551065},{"$f":"-'Revenue By Month'!P35","v":-201818.65873071147},{"$f":"-'Revenue By Month'!Q35","v":-279470.332600325},{"$f":"-'Revenue By Month'!R35","v":-673870.40887810581},{"$f":"-'Revenue By Month'!S35","v":-1223507.8000980504},{"$f":"-'Revenue By Month'!T35","v":-1781941.8074500877},{"$f":"-'Revenue By Month'!U35","v":-1617365.016282958},{"$f":"-'Revenue By Month'!V35","v":-1415757.0658743572},{"$f":"-'Revenue By Month'!W35","v":-1095182.7796432027},{"$f":"-'Revenue By Month'!X35","v":-708113.72299513221},{"$f":"-'Revenue By Month'!Y35","v":-384175.05276517611},{"$f":"-'Revenue By Month'!Z35","v":-252221.21738622969},{"$f":"-'Revenue By Month'!AA35","v":-195142.08439774477},{"$f":"-'Revenue By Month'!AB35","v":-197322.80438433186},{"$f":"-'Revenue By Month'!AC35","v":-271275.00899860362},{"$f":"-'Revenue By Month'!AD35","v":-665893.17025374353}]
["Expected LIRAP Expense",null,{"$f":"'LIRAP Expense Summary'!$B$47","v":221875},{"$f":"'LIRAP Expense Summary'!$B$47","v":221875},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$C$33/12","v":688475.5600654725},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$D$33/12","v":1136624.5114522146},{"$f":"'LIRAP Expense Summary'!$E$33/12","v":1334490.653812252}]
["Net change in balance",null,{"$f":"C3+C4","v":110696.89419272837},{"$f":"D3+D4","v":60078.494512885838},294086.79429575917,-530949.76646968396,-1081421.1503931952,-917682.42981147673,-719912.45631428948,-405001.33301709662,-10132.285838193027,303271.05886097619,434647.69915061031,496939.84019996185,486656.90133476106,409005.2274651475,{"$f":"Q3+Q4","v":462754.10257410875},-86883.288645835826,-645317.29599787318,-480740.50483074342,-279132.55442214268,41441.731809011893,428510.78845708235,752449.45868703839,884403.2940659849,941482.42705446982,939301.70706788264,865349.502453611,{"$f":"AC3+AC4","v":668597.48355850845}]
["Accounting Adjustment"]
["Elec Tariff rider balance",-3422500.34,{"$f":"C5+C6+B7","v":-3311803.4458072716},{"$f":"D5+D6+C7","v":-3251724.9512943858},{"$f":"E5+E6+D7","v":-2957638.1569986269},-3488587.9234683109,-4570009.0738615058,-5487691.5036729826,-6207603.9599872716,-6612605.2930043684,-6622737.5788425617,-6319466.5199815854,-5884818.8208309747,-5387878.9806310125,-4901222.0792962518,{"$f":"O7+P5+P6","v":-4492216.8518311046},{"$f":"P7+Q5+Q6","v":-4029462.749256996},{"$f":"Q7+R5+R6","v":-4116346.037902832},-4761663.333900705,-5242403.8387314482,-5521536.3931535911,-5480094.6613445794,-5051583.8728874968,-4299134.4142004587,-3414731.1201344738,-2473248.6930800038,-1533946.9860121212,-668597.4835585102,{"$f":"AB7+AC5+AC6","v":-1.7462298274040222E-9}]
[]
[]
[]
["Forecasted End of October 2023 Balance",{"$f":"E7","v":-2957638.1569986269},"Overfunded \"Rebate\""]
["November 2023 - October 2025 Expenditure Budget",{"$f":"SUM(F4:AC4)","v":22547215.951959021}]
["November 2023 - October 2025 Forecasted Revenue",{"$f":"SUM(F3:AC3)","v":-19589577.794960398}]
[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":[[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,8,18,10],[23,0,23,5],[37,0,37,1],[18,7,19,7]]}
["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":47,"n_cols":34,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Forecasted Usage",null,null,"2023-08-31",{"$f":"EOMONTH(D3,1)","v":"2023-09-30"},"2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31",null,"2022-2023","2023-2024"]
[null,"Small Service Schedule 101",null,{"$f":"D38","v":2294937.430901587},3580778.6614875691,9536348.0539146084,16896724.585724,25318761.379441429,22936252.243829809,20105498.728020974,15455535.198045896,9694274.395910874,5183904.46824532,3240671.9152343152,2340441.1111559412,2489737.256021257,3519545.2521682116,8898296.9236539602,16978003.416995637,25540559.183098633,23133721.336629376,20236790.385652628,15488448.234711271,9859704.6172709987,5172571.9154418055,3218684.0407317942,2406610.1200701939,{"$f":"AB38","v":2414744.4626946463},3380515.0413405122,8750149.3287331983,null,{"$f":"SUM(D4:O4)","v":136584128.17191231},{"$f":"SUM(P4:AA4)","v":136942672.68244576}]
[null,"Large Service Schedule 111",null,{"$f":"D39+D40","v":1811059.2980091409},2410383.6727872053,5097277.0375389084,7774200.7307153111,9866698.7152098306,9002635.065499058,7900560.0242170924,6407192.0206340617,4392730.3326240024,2692002.0779268248,2078905.0362181957,1745092.4506622497,1807011.0882689361,2398983.7055906351,5098719.4975530114,7750797.3172108112,9839437.1753610335,8992230.1002024263,7891540.6217613313,6399075.2966159284,4388737.5686300453,2679862.7539378079,2068584.3707074169,1737584.8485223502,{"$f":"AB39+AB40","v":1802347.7172293086},2395561.25831088,5118879.484641985,null,{"$f":"SUM(D5:O5)","v":61178736.462041877},{"$f":"SUM(P5:AA5)","v":61052564.34436173}]
[null,"Interrupt Service Schedule 131",null,{"$f":"D42","v":99072.320221823771},120887.66393904743,249609.26907159825,347671.43138689199,347632.58956974506,329887.84254494117,276791.75253276987,239018.49667086484,179545.24880668859,120676.27091623716,105778.55520706638,101513.6591716637,99031.206036056785,120809.83696400616,251037.68629373278,347386.9039570202,347694.44899869908,329844.52520212258,276693.1709493415,238783.71742413205,179344.54270619864,120125.94961021497,105367.82416974485,101323.34314434076,{"$f":"AB42","v":99099.961091384423},121230.92478210553,252717.01977525026,null,2518085.1000393378,2517443.1554556102]
[null,"Transport Service Schedule 146",null,2056324,2124517,2142848,2683302,3090346,3318946,3450658,3077573,3015119,2622375,2351056,2160373,2046710,2111844,2143437,2724551,3028501,3348035,3450753,3110861,3024980,2618081,2332683,2142684,{"$f":"AB43","v":2043252},2086080,2148434]
[null,"Special Contract Transport",null,3274936,3394097,3472303,4012777,4389174,4792623,4825009,4352849,4317680,3939169,3656651,3480246,3310149,3431054,3507041,4047280,4423023,4826686,4859504,4387169,4352013,3973337,3690791,3514441,{"$f":"AB44","v":3344335},3465261,3541224]
["Total Forecasted Usage",null,null,{"$f":"SUM(D4:D8)","v":9536329.049132552},11630663.998213822,20498385.360525116,31714675.747826204,43012612.684221007,40380344.151873812,36558517.50477083,29532167.715350822,21599348.977341566,14558126.817088382,11433062.506659577,9827666.220989855,9752638.5503262505,11582236.794722853,19898532.107500702,31848018.63816347,43179214.807458363,40630516.962033927,36715281.178363301,29624337.248751331,21804779.728607245,14563978.618989829,11416110.235608956,9902643.3117368855,{"$f":"SUM(AB4:AB8)","v":9703779.1410153396},11448648.224433497,19811403.833150432,null,{"$f":"SUM(AF4:AF8)","v":200280949.73399353},{"$f":"SUM(AG4:AG8)","v":200512680.18226311},{"$f":"(AG9-AF9)/AF9","v":1.1570269093358729E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'[6]WA Gas - Sched 191'!C7","v":200280949.73399353}]
[]
["LIRAP Rates"]
[null,"Small Service Schedule 101",null,{"$f":"'WA Natural Gas - Sched 192'!D9","v":2.929E-2},{"$f":"D13","v":2.929E-2},{"$f":"E13","v":2.929E-2},{"$f":"'WA Natural Gas - Sched 192'!D25","v":6.0790459643551398E-2},{"$f":"G13","v":6.0790459643551398E-2},{"$f":"H13","v":6.0790459643551398E-2},6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2,6.0790459643551398E-2]
[null,"Large Service Schedule 111",null,{"$f":"'WA Natural Gas - Sched 192'!E9","v":2.4559999999999998E-2},{"$f":"D14","v":2.4559999999999998E-2},{"$f":"E14","v":2.4559999999999998E-2},{"$f":"'WA Natural Gas - Sched 192'!E25","v":3.0216298381300841E-2},{"$f":"G14","v":3.0216298381300841E-2},3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2,3.0216298381300841E-2]
[null,"Interrupt Service Schedule 131",null,{"$f":"'WA Natural Gas - Sched 192'!F9","v":2.1559999999999999E-2},{"$f":"D15","v":2.1559999999999999E-2},{"$f":"E15","v":2.1559999999999999E-2},{"$f":"'WA Natural Gas - Sched 192'!F25","v":2.9520920262155907E-2},2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2,2.9520920262155907E-2]
[null,"Transport Service Schedule 146",null,{"$f":"'WA Natural Gas - Sched 192'!G9","v":1.1800000000000001E-3},{"$f":"D16","v":1.1800000000000001E-3},{"$f":"E16","v":1.1800000000000001E-3},{"$f":"'WA Natural Gas - Sched 192'!G25","v":1.0593484020308347E-3},1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3,1.0593484020308347E-3]
[null,"Special Contract Transport"]
[null,"Total"]
[]
[]
["Gross LIRAP Revenue",null,null,{"$f":"D3","v":"2023-08-31"},"2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31",{"$f":"AB3","v":"2025-08-31"},"2025-09-30","2025-10-31"]
[null,"Small Service Schedule 101",null,{"$f":"D4*D13","v":67218.71735110748},{"$f":"E4*E13","v":104881.0069949709},279319.63449915888,1027159.6540366575,1539139.141861642,1394305.3164028511,1222222.509039233,939549.08872629725,589319.39643813355,315131.93537289288,197001.93528104207,142276.49091583383,151352.27218520662,213954.77361558459,540931.5600337236,1032100.631548951,1552622.3322938934,1406309.553319532,1230203.7892540251,941549.88735345041,599375.97563354997,314443.02427903243,195665.28228344908,146298.93538188952,{"$f":"AB4*AB13","v":146793.42580892809},205503.0631950289,531925.5996434039]
[null,"Large Service Schedule 111",null,{"$f":"D5*D14","v":44479.616359104497},59199.023003653761,125189.12404195558,234907.56895542087,298135.11241717788,272026.30735708139,238725.67907112106,193601.62588176865,132732.05043915776,81342.338029718812,62816.814880758029,52730.234192166055,54601.186221453325,72488.407460005401,154064.42970061809,234200.40442982793,297311.36959477293,271711.90782103129,238453.14611529675,193356.36852695807,132611.40389095023,80975.532593919401,62504.962572190743,52503.382245778754,{"$f":"AB5*AB14","v":54460.276410657221},72384.993771806054,154673.5898858617]
[null,"Interrupt Service Schedule 131",null,2135.9992239825206,2606.3380345258624,5381.5758411836578,10263.580603402046,10262.433957215215,9738.5926952238515,8171.1472557422894,7056.0459814009782,5300.3409734711968,3562.4745712525614,3122.6802937138632,2996.7766379263558,2923.4923368555651,3566.4175638984811,7410.8635198733946,10255.181091832406,10264.260104484829,9737.3139274005352,8168.2370366785835,7049.11508197897,5294.4159446825051,3546.2285798589146,3110.5551355119019,2991.1583336591448,{"$f":"AB6*AB15","v":2925.5220493615125},3578.8484637999577,7460.4389896748407]
[null,"Transport Service Schedule 146",null,2426.4623200000001,2506.9300600000001,2528.5606400000001,2842.5516858661431,3273.7530968223818,3515.9201415266307,3655.4490382549161,3260.2220396832422,3194.0614945828083,2778.0087657756103,2490.5874166850062,2288.5876853405607,2168.1789679205299,2237.1785667384061,2270.6465608037661,2886.2487481015128,3208.2376948987849,3546.7355271933056,3655.5496763531091,3295.4856292900445,3204.5077291752345,2773.45992373729,2471.1240084944939,2269.8488714570371,2164.5157411463069,2209.8855145084835,2275.9401247687142]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D22:D26)","v":116260.7952541945},169193.29809315054,412418.89502229809,1275173.3552813467,1850810.4413328576,1679586.1365966832,1472774.7844043514,1143466.9826291499,730545.84934534528,402814.75673963985,265432.01787219895,200292.08943126677,211045.12971143605,292246.77720622683,704677.49981501873,1279442.465818713,1863406.1996880502,1691305.5105951573,1480480.7220823534,1145250.8565916775,740486.30319835804,401738.24537654797,263751.92399964621,204063.32483278445,{"$f":"SUM(AB22:AB26)","v":206343.74001009314},283676.79094514338,696335.56864370918]
[]
["Net LIRAP Revenue",null,{"$f":"'Rev Conv Factor'!E22","v":0.95628199999999997},{"$f":"D21","v":"2023-08-31"},"2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31",{"$f":"AB21","v":"2025-08-31"},"2025-09-30","2025-10-31"]
[null,"Small Service Schedule 101",null,{"$f":"D22*$C$29","v":64280.049465951757},100295.81913116475,267108.33871812467,982254.28828148288,1471851.0568577347,1333349.0765803512,1168789.3853890558,898473.881665361,563555.53106465121,301354.99742226076,{"$f":"N22*$C$29","v":188389.40467442546},{"$f":"O22*$C$29","v":136056.44728597539},{"$f":"P22*$C$29","v":144735.45354981374},204601.09882265844,517283.11409216927,986979.25613889401,1484744.7891706689,1344828.5122675085,1176421.7399954177,900387.20937813225,573172.45673080243,300696.2041436017,187111.18747258125,139903.03852486407,{"$f":"AB22*$C$29","v":140375.91081941337},196518.88027826863,508670.87627819355]
[null,"Large Service Schedule 111",null,{"$f":"D23*$C$29","v":42535.056491117168},56610.960115980022,119716.10591708937,224637.87985582778,285101.24157252366,260133.8612520445,228289.06983348978,185137.75000146948,126929.27065805865,{"$f":"M23*$C$29","v":77786.213695735569},60070.589367801047,50424.973813752935,52214.131562223825,69319.359262668877,147329.04096296645,223961.63114896472,284313.51113882865,259833.20663491145,228028.4514734282,184903.21480769652,126813.89853564565,77435.444259978423,59772.370618459703,50208.039380757793,{"$f":"AB23*$C$29","v":52079.382046536106},69220.466614090241,147911.5698832316]
[null,"Interrupt Service Schedule 131",null,2042.6176099084526,2492.3941483324606,5146.3041085587902,9814.8773865825151,9813.7808694736796,9312.8408997740553,7813.9210400157481,6747.5697631860903,5068.6206667929828,{"$f":"M24*$C$29","v":3406.7303079465419},2986.1629566332804,2865.7635568694914,2795.6830988729134,3410.5009208399674,7086.8753885115693,9806.8450848596767,9815.527181236961,9311.6180371224382,7811.1380499090692,6740.9418688250134,5062.9546684128754,3391.1945588046424,2974.5678860975922,2860.3908736282342,{"$f":"AB24*$C$29","v":2797.624076407526},3422.3883666595511,7134.2835179242356]
[null,"Transport Service Schedule 146",null,2320.3822402942401,2397.3320916369203,2418.0170259404799,2718.281011263447,3130.6311589355009,3362.2111447793695,3495.6401172004876,3117.6916525523702,3054.4235141626368,{"$f":"M25*$C$29","v":2656.5597785534319},2381.703916002371,2188.5352089128419,2073.3905198009802,2139.3735941577365,2171.378434458547,2760.0677253320109,3067.9799593531998,3391.6793434154688,3495.7363556023038,3151.4135885487422,3064.4130602711516,2652.209802791343,2363.0914090911315,2170.6156184946785,2069.8874419748727,2113.2737395852014,2176.4405743940756]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D30:D34)","v":111178.10580727163},161796.50548711416,394388.76576971333,1219425.3265351565,1769896.7104586677,1606157.9898769492,1408388.016379762,1093476.8930825691,698607.84590366553,385204.50120449631,253827.86091486219,191535.71986551065,201818.65873071147,279470.332600325,673870.40887810581,1223507.8000980504,1781941.8074500877,1617365.016282958,1415757.0658743572,1095182.7796432027,708113.72299513221,384175.05276517611,252221.21738622969,195142.08439774477,{"$f":"SUM(AB30:AB34)","v":197322.80438433186},271275.00899860362,665893.17025374353,null,{"$f":"SUM(D35:O35)","v":9293884.2412857376},{"$f":"AF35+SUM('[6]DSM Balance'!G3:Y3)","v":-880939.84491478279}]
[]
[]
[null,"WA101",null,2294937.430901587,3580778.6614875691,9536348.0539146084,16896724.585724,25318761.379441429,22936252.243829809,20105498.728020974,15455535.198045896,9694274.395910874,5183904.46824532,3240671.9152343152,2340441.1111559412,2489737.256021257,3519545.2521682116,8898296.9236539602,16978003.416995637,25540559.183098633,23133721.336629376,20236790.385652628,15488448.234711271,9859704.6172709987,5172571.9154418055,3218684.0407317942,2406610.1200701939,2414744.4626946463,3380515.0413405122,8750149.3287331983]
[null,"WA111",null,1788424.4328219858,2383581.0727075031,5048195.0594924744,7705945.5661882907,9797127.9517010469,8938966.3986753449,7838869.9781867638,6354425.0969351623,4350960.9671011157,2662882.1370576401,2053543.3142675646,1722905.7282588359,1784385.616361862,2372198.3609133409,5049356.6423460506,7682598.0113617992,9769854.0320931841,8928569.7936670054,7829872.5471313922,6346360.2039626213,4347014.8953283662,2650875.6090505403,2043321.1266225937,1715439.7213968683,1779706.5369850844,2368682.5521770138,5069186.4132960998]
[null,"WA112",null,22634.865187155025,26802.600079702086,49081.978046434386,68255.164527020141,69570.763508783013,63668.666823712752,61690.046030328544,52766.923698899664,41769.365522886255,29119.940869184575,25361.721950631145,22186.722403413907,22625.471907074054,26785.344677293979,49362.855206961009,68199.305849012337,69583.143267849548,63660.306535421041,61668.074629938936,52715.092653307016,41722.673301678769,28987.144887267445,25263.244084823171,22145.127125481955,22641.180244224044,26878.706133866115,49693.071345885088]
[null,"WA121 -Discontinued",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WA132",null,99072.320221823771,120887.66393904743,249609.26907159825,347671.43138689199,347632.58956974506,329887.84254494117,276791.75253276987,239018.49667086484,179545.24880668859,120676.27091623716,105778.55520706638,101513.6591716637,99031.206036056785,120809.83696400616,251037.68629373278,347386.9039570202,347694.44899869908,329844.52520212258,276693.1709493415,238783.71742413205,179344.54270619864,120125.94961021497,105367.82416974485,101323.34314434076,99099.961091384423,121230.92478210553,252717.01977525026]
[null,"WA146",null,2056324,2124517,2142848,2683302,3090346,3318946,3450658,3077573,3015119,2622375,2351056,2160373,2046710,2111844,2143437,2724551,3028501,3348035,3450753,3110861,3024980,2618081,2332683,2142684,2043252,2086080,2148434]
[null,"WA148",null,3274936,3394097,3472303,4012777,4389174,4792623,4825009,4352849,4317680,3939169,3656651,3480246,3310149,3431054,3507041,4047280,4423023,4826686,4859504,4387169,4352013,3973337,3690791,3514441,3344335,3465261,3541224]
[]
[]
[null,null,null,{"$f":"SUM(D38:D44)-D9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB38:AB44)-AB9","v":0},0,0]

{"sheet":"Rev Conv Factor","index":4,"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 NATURAL GAS"]
["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.326E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8392000000000003E-2]
[]
[5,null,"  Franchise Fees",null,0]
[]
[6,null,"    Total Expense",null,{"$f":"E12+E14+E16+E18","v":4.3718E-2}]
[]
[7,null,"Net Operating Income Before FIT",null,{"$f":"E9-E20","v":0.95628199999999997}]
[]
[8,null,"  Federal Income Tax @ 21%",null,0.20081921999999999]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.75546278}]
[]
[]
["Source:  UG-220054"]

{"sheet":"Base Revenue","index":5,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["AVISTA UTILITIES"]
["WASHINGTON NATURAL GAS"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED SEPTEMBER 30, 2021"]
["(000s of Dollars)"]
[]
[]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Total Billed",null,null,null,"Percent "]
[null,null,null,"Distribution Revenue","Final","Distribution Revenue","Tariff","Revenue","Final","Sch. 192","Sch. 178","Increase"]
["Line","Type of","Schedule","Under Present","General","Under Proposed","Percent","at Present","General","LIRAP ","Tax Credit","on Billed"]
["No.","Service","Number","Rates","Increase","Rates","Increase","Rates (1)","Increase","Increase","Decrease","Revenue"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)",null,"(I)","(j)"]
[]
[1,"General Service","101/102",89621.225590000002,5930.9523599999993,95552.177949999998,6.6177987646955136E-2,139159.29743999999,5930.9523599999993,0,-4927.0491765657271,7.2140575721655661E-3]
[2,"Large General Service","111/112/116",20022.859260000005,1324.9999199999943,21347.859179999999,6.6174361153652439E-2,43152.721950000006,1324.9999199999943,0,-1100.7840116000636,5.1958694206989788E-3]
[3,"Interruptible Service ","131/132",224.70907,14.77077999999997,239.67984999999999,6.573290521828945E-2,527.50023999999996,14.77077999999997,0,-12.353687767843773,4.5821632842407744E-3]
[4,"Transportation Service","146",3459.6527085000002,228.86183749999944,3688.5145459999994,6.6151679600010185E-2,3224.9898985,228.86183749999944,0,-190.1991287934396,1.1988474359111188E-2]
[5,"Special Contracts","148",1530.9043399999998,0,1530.9043399999998,0,1530.9043399999998,0,0,0,0]
[6,"Total",null,114859.55096849999,7499.7848974999933,122359.53586599998,6.5295265689805759E-2,187595.8138685,7499.5848974999935,0,-6230.3860047270737,6.7656034886929657E-3]
[null,null,null,0,null,0,null,null,null,null,0]
["(1) Includes Schedule 150 (Purchase Gas Cost Adjustment), Schedule 155 (Gas Rate Adjustment), Schedule 175 (Decoupling), Schedule 176 (Tax Credit)"]
[" Schedule 191 (DSM Adjustment), and Schedule 192 (LIRAP Adjustment)."]