{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["WA Gas - Sched 162","Rate Impact Summary","Forecast","Sch 146 - Load Forecast","Cost Amtz Calc - Sch 101-146","Ben Amtz Calc - Sch 101","Ben Amtz Calc - Sch 111","Ben Amtz Calc - Sch 112-116","Ben Amtz Calc - Sch 131-132","Ben Amtz Calc - Sch 146","Conversion Factor","Revenue - current rates","DSM Balance","Base Revenue","RCF"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":21,"defined_names":182,"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 Gas - Sched 162","index":0,"n_rows":73,"n_cols":23,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Avista Utilities",null,null,null,null,"% of Sch 101 Res:"]
["State of Washington",null,null,null,null,0.17249999999999999]
["Rate Change Summary - Schedule 162"]
[null,null,"CCA Costs?","Yes",null,"Yes",null,"Yes",null,"Yes",null,"Yes",null,"Yes",null,"Yes",null,"Yes",null,"Yes","Yes",null,"Yes"]
[null,null,"CCA Benefits?","Yes",null,"Yes",null,"No",null,"Yes",null,"No",null,"Yes",null,"No",null,"Yes",null,"No","Yes",null,"No"]
[null,null," ","GEN SERVICE",null,"GEN SERVICE",null,"GEN SERVICE",null,"LRG GEN SVC",null,"LRG GEN SVC",null,"LRG GEN SVC",null,"LRG GEN SVC",null,"INTERRUPTIBLE",null,"INTERRUPTIBLE","TRANSPORT",null,"TRANSPORT"]
["Source",null,"TOTAL","SCH. 101 Pre 7/2021",null,"SCH. 101 Res Fixed/Low Income",null,"SCH. 101  Post 7/2021",null,"SCH. 111",null,"SCH. 111 Post 7/21",null,"SCH. 112, 116",null,"SCH. 112, 116 Post 7/21",null,"SCH. 131&132",null," SCH. 131/132\n Post 7/21","SCH. 146",null," SCH. 146\n Post 7/21"]
["SCHEDULE 162 - CCA Costs"]
["Forecast","Total Annual Therms (Subject to Cost)",{"$f":"SUM(D9:W9)","v":220376850.72049859},{"$f":"IF(D4=\"Yes\",SUM(Forecast!C57:N59),0)","v":133751645.87927376},null,"Incl in 101",null,"Incl in 101",null,{"$f":"IF(J4=\"Yes\",SUM(Forecast!$C$60:$N$61),0)","v":61340851.431824826},null,"Incl in 111",null,{"$f":"IF(N4=\"Yes\",SUM(Forecast!$C$62:$N$63),0)","v":137984.55499999999},null,"Incl in 112, 116",null,{"$f":"IF(R4=\"Yes\",SUM(Forecast!$C$64:$N$64),0)","v":2628936.4739999999},null,"Incl in 131/132",{"$f":"IF(U4=\"Yes\",SUM(Forecast!$C$65:$N$66),0)","v":22517432.380399998},null,"Incl in 146"]
[]
[null,"Percentage of Forecasted Load",{"$f":"SUM(D11:W11)","v":0.99999999999999989},{"$f":"D9/$C$9","v":0.60692239426231487},null,null,null,null,null,{"$f":"J9/$C$9","v":0.27834525827589179},null,null,null,{"$f":"N9/$C$9","v":6.261299884669112E-4},null,null,null,{"$f":"R9/$C$9","v":1.1929276897301022E-2},null,null,{"$f":"U9/$C$9","v":0.10217694057602537}]
[]
[null,"Costs Through December 2023",46022329]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D14:W14)","v":46022329},{"$f":"$C$13*D11","v":27931982.106207967},null,null,null,null,null,{"$f":"$C$13*J11","v":12810097.051963065},null,null,null,{"$f":"$C$13*N11","v":28815.960325990392},null,null,null,{"$f":"$C$13*R11","v":549013.10609968682},null,null,{"$f":"$C$13*U11","v":4702420.7754032891}]
[null,"Interest During Amortization Period",null,{"$f":"D14/($D$14+$J$14+$N$14+$R$14+$U$14)*'Cost Amtz Calc - Sch 101-146'!$F$27","v":870711.09553211776},null,null,null,null,null,{"$f":"J14/($D$14+$J$14+$N$14+$R$14+$U$14)*'Cost Amtz Calc - Sch 101-146'!$F$27","v":399323.38477005274},null,null,null,{"$f":"N14/($D$14+$J$14+$N$14+$R$14+$U$14)*'Cost Amtz Calc - Sch 101-146'!$F$27","v":898.26695036714648},null,null,null,{"$f":"R14/($D$14+$J$14+$N$14+$R$14+$U$14)*'Cost Amtz Calc - Sch 101-146'!$F$27","v":17114.138239667031},null,null,{"$f":"U14/($D$14+$J$14+$N$14+$R$14+$U$14)*'Cost Amtz Calc - Sch 101-146'!$F$27","v":146586.44450779542}]
[null,"Costs after Revenue Conversion Factor",{"$f":"'Conversion Factor'!E28","v":1.045717},{"$f":"(D14+D15)*$C$16","v":30119465.926844038},null,null,null,null,null,{"$f":"(J14+J15)*$C$16","v":13813315.510839246},null,null,null,{"$f":"(N14+N15)*$C$16","v":31072.672604750776},null,null,null,{"$f":"(R14+R15)*$C$16","v":592008.88356881612},null,null,{"$f":"(U14+U15)*$C$16","v":5070689.2829837594}]
[null,"Revenue Requirement",{"$f":"SUM(D17:W17)","v":49625281.96909143},{"$f":"D22*D9","v":30118195.619094864},null,null,null,null,null,{"$f":"J16","v":13813315.510839246},null,null,null,{"$f":"N16","v":31072.672604750776},null,null,null,{"$f":"R16","v":592008.88356881612},null,null,{"$f":"U16","v":5070689.2829837594}]
[]
[null,"Avg Number of Customers",null,{"$f":"ROUND(SUM(Forecast!$C41:$N41)/12,0)","v":140126},null,{"$f":"ROUND(SUM(Forecast!$C42:$N42)/12,0)","v":30005},null,{"$f":"ROUND(SUM(Forecast!$C43:$N43)/12,0)","v":3809},null,{"$f":"ROUND(SUM(Forecast!$C44:$N44)/12,0)","v":3427},null,{"$f":"ROUND(SUM(Forecast!$C45:$N45)/12,0)","v":73},null,{"$f":"ROUND(SUM(Forecast!$C46:$N46)/12,0)","v":0},null,{"$f":"ROUND(SUM(Forecast!$C47:$N47)/12,0)","v":1},null,{"$f":"ROUND(SUM(Forecast!$C48:$N48)/12,0)","v":4},null,0,{"$f":"ROUND(SUM(Forecast!$C49:$N49)/12,0)","v":33},null,{"$f":"ROUND(SUM(Forecast!$C50:$N50)/12,0)","v":2}]
[]
[null,"Monthly Schedule 162 Rate - Cost",null,"n/a",null,"n/a",null,"n/a",null,"n/a",null,"n/a",null,"n/a",null,"n/a",null,"n/a",null,"n/a","n/a",null,"n/a"]
[null,"Per Therm Schedule 162 Rate - Cost",null,{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"J22","v":0.22517999999999999},null,{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"N22","v":0.22517999999999999},null,{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"R22","v":0.22517999999999999},{"$f":"'Cost Amtz Calc - Sch 101-146'!$E$29","v":0.22517999999999999},null,{"$f":"U22","v":0.22517999999999999}]
[]
["SCHEDULE 162 - CCA Benefits"]
["Forecast","Total Annual Therms (Subject to Benefit)",{"$f":"SUM(D25:W25)","v":192046732.88868412},{"$f":"IF(D5=\"Yes\",SUM(Forecast!$C$57:$N$57,0))","v":107641633.61828922},null,null,null,null,null,{"$f":"IF(J5=\"Yes\",SUM(Forecast!$C$60:$N$60),0)","v":60044230.415994912},null,null,null,{"$f":"IF(N5=\"Yes\",SUM(Forecast!$C$62:$N$62),0)","v":0},null,null,null,{"$f":"IF(R5=\"Yes\",SUM(Forecast!$C$64:$N$64),0)","v":2628936.4739999999},null,null,{"$f":"IF(U5=\"Yes\",SUM(Forecast!$C$65:$N$65),0)","v":21731932.380399998}]
[]
[null,"Percentage of Forecasted Load",{"$f":"SUM(D27:W27)","v":1},{"$f":"D25/$C$25","v":0.56049708317965208},null,null,null,null,null,{"$f":"J25/$C$25","v":0.31265426655707962},null,null,null,{"$f":"N25/$C$25","v":0},null,null,null,{"$f":"R25/$C$25","v":1.3689045548740513E-2},null,null,{"$f":"U25/$C$25","v":0.11315960471452778}]
[]
[null,"Benefits Through December 2023",-37231122]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D30:W30)","v":-37231122},{"$f":"($C$29-$F$30)*D27","v":-18083242.832187314},null,{"$f":"F32/C32","v":-4968255.0291272523},null,null,null,{"$f":"($C$29-$F$30)*J27","v":-10087123.009806849},null,null,null,{"$f":"($C$29-$F$30)*N27","v":0},null,null,null,{"$f":"($C$29-$F$30)*R27","v":-441647.85549723293},null,null,{"$f":"($C$29-$F$30)*U27","v":-3650853.2733813548}]
[null,"Interest During Amortization Period",null,{"$f":"'Ben Amtz Calc - Sch 101'!F34+'Ben Amtz Calc - Sch 101'!F48","v":-202081.12},null,null,null,null,null,{"$f":"'Ben Amtz Calc - Sch 111'!F34+'Ben Amtz Calc - Sch 111'!F48","v":-115756.4},null,null,null,0,null,null,null,{"$f":"'Ben Amtz Calc - Sch 131-132'!F27","v":-10921.779999999999},null,null,{"$f":"'Ben Amtz Calc - Sch 146'!F27","v":-90284.23000000001}]
[null,"Benefits after Revenue Conversion Factor",{"$f":"'Conversion Factor'!E28","v":1.045717},{"$f":"(D30+D31)*$C$32","v":-19121274.107309461},null,{"$f":"F33","v":-5195388.744293863},null,null,null,{"$f":"(J30+J31)*$C$32","v":-10669324.44778499},null,null,null,{"$f":"(N30+N31)*$C$32","v":0},null,null,null,{"$f":"(R30+R31)*$C$32","v":-473259.76152325992},null,null,{"$f":"(U30+U31)*$C$32","v":-3912171.08662344}]
[null,"Revenue Requirement",{"$f":"SUM(D33:W33)","v":-39371418.147535011},{"$f":"D32","v":-19121274.107309461},null,{"$f":"F35*Forecast!O58","v":-5195388.744293863},null,null,null,{"$f":"J32","v":-10669324.44778499},null,null,null,{"$f":"N32","v":0},null,null,null,{"$f":"R32","v":-473259.76152325992},null,null,{"$f":"U32","v":-3912171.08662344}]
[]
[null,"Monthly Schedule 162 Rate - Benefit*",null,{"$f":"(('Ben Amtz Calc - Sch 101'!E36*7)+('Ben Amtz Calc - Sch 101'!E50*5))/12","v":-11.369166666666667},null,{"$f":"-F22","v":-0.22517999999999999},null,null,null,{"$f":"(('Ben Amtz Calc - Sch 111'!E36*7)+('Ben Amtz Calc - Sch 111'!E50*5))/12","v":-259.45333333333338},null,null,null,0,null,null,null,{"$f":"'Ben Amtz Calc - Sch 131-132'!E29","v":-9859.58},null,null,{"$f":"'Ben Amtz Calc - Sch 146'!E29","v":-9879.2199999999993}]
[]
[null,"Monthly Net Schedule 162 Cost (Est.)",null,{"$f":"(D9/(D19+H19+F19)/12*D22)+D35","v":3.060232177328805},null,{"$f":"F35+F22","v":0},null,{"$f":"H35+H22","v":0.22517999999999999},null,{"$f":"(J9/(J19+L19)/12*J22)+J35","v":69.421260129007408},null,{"$f":"(J9/(J19+L19)/12*J22)","v":328.87459346234078},null,{"$f":"(N9/(N19+P19)/12*N22)+N35","v":2589.2801745749998},null,{"$f":"(N9/(N19+P19)/12*N22)","v":2589.2801745749998},null,{"$f":"(R9/R19/12*R22)+R35","v":2473.4182336524991},null,{"$f":"T21","v":"n/a"},{"$f":"(U9/(U19+W19)/12*U22)+U35","v":2193.3405319487429},null,{"$f":"W39/12/W19","v":7369.9537499999997}]
[]
[null,"Net 162 Revenue",{"$f":"C17+C33","v":10253863.821556419},{"$f":"D33+D17+F33-H39","v":5117468.950856911},null,0,null,{"$f":"H37*Forecast!O59","v":684063.81663462915},null,{"$f":"J33+J17-L39","v":2855896.9191812454},null,{"$f":"L37*L19*12","v":288094.14387301053},null,0,null,{"$f":"P22*N9","v":31071.362094899996},null,{"$f":"R33+R17","v":118749.1220455562},null,{"$f":"T33+T17","v":0},{"$f":"U33+U17-W39","v":981639.30636031937},null,{"$f":"'Sch 146 - Load Forecast'!O15*'WA Gas - Sched 162'!W22","v":176878.88999999998}]
[]
[null,"Present Revenue",{"$f":"SUM(D41:W41)","v":275695986.50349998},{"$f":"H58*D19","v":156751566.700423},null,{"$f":"H58*F19","v":33565011.195967861},null,{"$f":"H58*H19","v":4260927.4336091178},null,{"$f":"(J19*H59)","v":74577947.563702866},null,{"$f":"L19*H59","v":1588616.9162971429},null,0,null,{"$f":"111000+25000","v":136000},null,{"$f":"R19*H61","v":1707098.3199999998},null,0,{"$f":"U19*H62","v":2931171.6093000001},null,{"$f":"W19*H62","v":177646.76420000001}]
[]
[null,"Overall Revenue Change %",{"$f":"IFERROR(C39/C41,0)","v":3.7192648146969834E-2},{"$f":"IFERROR(D39/D41,0)","v":3.2647003526524249E-2},null,{"$f":"IFERROR(F39/F41,0)","v":0},null,{"$f":"IFERROR(H39/H41,0)","v":0.16054340922093788},null,{"$f":"IFERROR(J39/J41,0)","v":3.8294120614432305E-2},null,{"$f":"IFERROR(L39/L41,0)","v":0.18134903444470432},null,"n/a",null,{"$f":"IFERROR(P39/P41,0)","v":0.22846589775661763},null,{"$f":"IFERROR(R39/R41,0)","v":6.956196995469846E-2},null,"n/a",{"$f":"IFERROR(U39/U41,0)","v":0.33489656601673584},null,{"$f":"IFERROR(W39/W41,0)","v":0.99567752216901895}]
[]
[null,"*The monthly net Schedule 162 cost for Schedule 111 is based on an annual monthly benefit amount, however, as described in the cover letter and on the tab labeled \"Sch111 Seasonal Benefit Calc\" which calculates the Schedule 111 amortization rates, we proposed a seasonal credit rate."]
[]
[]
[null,"Support cap of monthly credit - Do Not Print"]
[null,"Cost Per Therm",null,{"$f":"(D17+F17+H17)/D9","v":0.22517999999999999},null,null,null,null,null,{"$f":"J17/J9","v":0.22518949751115827},null,null,null,{"$f":"N17/N9","v":0.22518949751115824},null,null,null,{"$f":"R17/R9","v":0.22518949751115824},null,null,{"$f":"U17/U9","v":0.22518949751115824}]
[null,"Credit Per Therm",null,{"$f":"D33/Forecast!O57","v":-0.17763827493659104},null,null,null,null,null,{"$f":"J33/J25","v":-0.17769108495298219},null,null,null,"n/a",null,null,null,{"$f":"R33/R25","v":-0.18001947411197122},null,null,{"$f":"U33/U25","v":-0.1800194763237816}]
[null,"Net Cost Per Therm",null,{"$f":"D50+D49","v":4.7541725063408952E-2},null,null,null,null,null,{"$f":"J50+J49","v":4.7498412558176079E-2},null,null,null,"n/a",null,null,null,{"$f":"R50+R49","v":4.517002339918702E-2},null,null,{"$f":"U50+U49","v":4.5170021187376647E-2}]
[null,"%",null,{"$f":"-D50/D49","v":0.78887234628559844},null,null,null,null,null,{"$f":"-J50/J49","v":0.78907358876351463},null,null,null,"n/a",null,null,null,{"$f":"-R50/R49","v":0.79941327682500463},null,null,{"$f":"-U50/U49","v":0.79941328664700073}]
[]
[null,"Rev Check Cost",{"$f":"((D22*D9)+(J22*J9)+(N22*N9)+(R22*R9)+(U22*U9))-C17","v":-822.72384955734015}]
[null,"Rev Check Benefit",{"$f":"((D35*Forecast!O41*12)+(F35*Forecast!O58)+(J35*J19*12)+(R35*R19*12)+(U35*U19*12))-C33","v":3420.7644229531288}]
[null,"Support for Bill Impacts and Revenue - Do Not Print"]
[null,null,null,"Annual Revenue at Current Rates",null,"# of Customers",null,"Revenue Per Customer"]
[null,"General Service","101/102",194577505.32999998,null,{"$f":"D19+F19+H19","v":173940},null,{"$f":"D58/F58","v":1118.647265321375}]
[null,"Large General Service","111",{"$f":"76302564.48-D60","v":76166564.480000004},null,{"$f":"J19+L19","v":3500},null,{"$f":"D59/F59","v":21761.875565714286}]
[null,"Large General Service","112/116",{"$f":"N41+P41","v":136000},null,{"$f":"P19+N19","v":1},null,{"$f":"D60/F60","v":136000}]
[null,"Interruptible Service ","131/132",1707098.3199999998,null,{"$f":"R19","v":4},null,{"$f":"D61/F61","v":426774.57999999996}]
[null,"Transportation Service","146",{"$f":"3733818.3735-625000","v":3108818.3735000002},null,{"$f":"U19+W19","v":35},null,{"$f":"D62/F62","v":88823.382100000003}]
[null,null,null,{"$f":"SUM(D58:D62)","v":275695986.50349998}]
[null,null,null,{"$f":"C41","v":275695986.50349998}]
[null,null,null,{"$f":"D63-D64","v":0}]
[null,"Residential Bill Impact",64]
[null,null,"Pre 7/2021","Post 7/2021",null,"Fixed/Low Income"]
[null,"Basic Charge",9.5,9.5,null,9.5]
[null,"First 70 Therms",1.29338,1.29338,null,1.29338]
[null,"Current Bill @ 66 Therms",{"$f":"C68+(C69*C66)","v":92.276319999999998},{"$f":"D68+(D69*C66)","v":92.276319999999998},null,{"$f":"F68+(F69*C66)","v":92.276319999999998}]
[null,"Increase",{"$f":"D37","v":3.060232177328805},{"$f":"H37","v":0.22517999999999999},null,{"$f":"F37","v":0}]
[null,"Increase %",{"$f":"C71/C70","v":3.3163786519973974E-2},{"$f":"D71/D70","v":2.4402793696150864E-3},null,{"$f":"F71/F70","v":0}]
[null,"New Bill",{"$f":"C71+C70","v":95.336552177328798},{"$f":"D71+D70","v":92.501499999999993},null,{"$f":"F71+F70","v":92.276319999999998}]

{"sheet":"Rate Impact Summary","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,8,7,8],[6,7,7,7],[6,2,7,2],[6,3,7,3],[2,2,3,2],[2,3,3,3],[2,7,3,7],[2,8,3,8]]}
[]
["Schedule No.","Rate Schedule","# of Customers","Average Monthly Therm Usage to Calculate Impact","Monthly Schedule 162 (CCA Costs) Fee","Monthly Schedule 162 (CCA Benefit) Credit","Total Net Monthly Bill Amount","Annual Net Bill Amount","% Change in Billed Revenue "]
[101,"General Service pre 7/2021 (Apr - Oct)",{"$f":"'WA Gas - Sched 162'!D19","v":140126},{"$f":"Forecast!O57/Forecast!O41/12","v":64.014691824099842},{"$f":"SUM(Forecast!C57:I57)/SUM(Forecast!C41:I41)*'WA Gas - Sched 162'!J22","v":6.3709905993139895},{"$f":"'Ben Amtz Calc - Sch 101'!E36","v":-5.04},{"$f":"(E3+F3)","v":1.3309905993139894},{"$f":"'WA Gas - Sched 162'!D37*12","v":36.72278612794566},{"$f":"'WA Gas - Sched 162'!D43","v":3.2647003526524249E-2}]
[101,"General Service pre 7/2021 (Nov - Mar)",null,null,{"$f":"SUM(Forecast!J57:N57)/SUM(Forecast!J41:N41)*'WA Gas - Sched 162'!J22","v":25.676201092842337},{"$f":"'Ben Amtz Calc - Sch 101'!E50","v":-20.23},{"$f":"(E4+F4)","v":5.4462010928423368}]
[101,"Low-Income Residential",{"$f":"'WA Gas - Sched 162'!F19","v":30005},{"$f":"Forecast!O58/Forecast!O42/12","v":64.079315058140153},{"$f":"'WA Gas - Sched 162'!F22*D5","v":14.429380164791999},{"$f":"'WA Gas - Sched 162'!F35*D5","v":-14.429380164791999},{"$f":"(E5+F5)","v":0},{"$f":"G5*12","v":0},{"$f":"'WA Gas - Sched 162'!F43","v":0}]
[101,"General Service After 7/2021",{"$f":"'WA Gas - Sched 162'!H19","v":3809},{"$f":"Forecast!O59/Forecast!O43/12","v":66.456482966800252},{"$f":"'WA Gas - Sched 162'!H22*D6","v":14.96467083446408},{"$f":"'WA Gas - Sched 162'!H35*D6","v":0},{"$f":"(E6+F6)","v":14.96467083446408},{"$f":"G6*12","v":179.57605001356896},{"$f":"'WA Gas - Sched 162'!H43","v":0.16054340922093788}]
[111,"Large General Service - Firm pre 7/2021 (Apr - Oct)",{"$f":"'WA Gas - Sched 162'!J19","v":3427},{"$f":"Forecast!O60/Forecast!O44/12","v":1460.1588016102576},{"$f":"SUM(Forecast!C60:I60)/SUM(Forecast!C44:I44)*'WA Gas - Sched 162'!J22","v":186.43453310069054},{"$f":"'Ben Amtz Calc - Sch 111'!E36","v":-147.52000000000001},{"$f":"E7+F7","v":38.914533100690534},{"$f":"'WA Gas - Sched 162'!J37*12","v":833.05512154808889},{"$f":"'WA Gas - Sched 162'!J43","v":3.8294120614432305E-2}]
[111,"Large General Service - Firm pre 7/2021 (Nov - mar)",null,null,{"$f":"SUM(Forecast!J60:N60)/SUM(Forecast!J44:N44)*'WA Gas - Sched 162'!J22","v":528.1081951308679},{"$f":"'Ben Amtz Calc - Sch 111'!E50","v":-416.16},111.94819513086787]
[111,"Large General Service - Firm after 7/2021",{"$f":"'WA Gas - Sched 162'!L19","v":73},{"$f":"Forecast!O61/Forecast!O45/12","v":1480.1609769747809},{"$f":"'WA Gas - Sched 162'!L37","v":328.87459346234078},{"$f":"'WA Gas - Sched 162'!L35","v":0},{"$f":"E9+F9","v":328.87459346234078},{"$f":"G9*12","v":3946.4951215480896},{"$f":"'WA Gas - Sched 162'!L43","v":0.18134903444470432}]
["112/116","Large General Service - Firm (Former Transport) pre 7/2021",{"$f":"'WA Gas - Sched 162'!N19","v":0},"n/a",{"$f":"'WA Gas - Sched 162'!N22*'WA Gas - Sched 162'!N9/12","v":2589.2801745749998},"n/a","n/a","n/a","n/a"]
["112/116","Large General Service - Firm (Former Transport) after 7/2021",{"$f":"'WA Gas - Sched 162'!P19","v":1},{"$f":"Forecast!O63/Forecast!O47/12","v":11498.712916666665},{"$f":"'WA Gas - Sched 162'!N22*'WA Gas - Sched 162'!N9/12","v":2589.2801745749998},{"$f":"F9","v":0},2589.2801745749998,{"$f":"G11*12","v":31071.362094899996},{"$f":"'WA Gas - Sched 162'!P43","v":0.22846589775661763}]
["131/132","Interruptible Service pre 7/2021",{"$f":"'WA Gas - Sched 162'!R19","v":4},{"$f":"Forecast!O64/Forecast!O48/12","v":54769.509874999996},{"$f":"'WA Gas - Sched 162'!R22*'WA Gas - Sched 162'!R9/'WA Gas - Sched 162'!R19/12","v":12332.998233652499},{"$f":"'WA Gas - Sched 162'!R35","v":-9859.58},2473.4182336524991,{"$f":"G12*12","v":29681.018803829989},{"$f":"'WA Gas - Sched 162'!R43","v":6.956196995469846E-2}]
["131/132","Interruptible Service - After 7/2021",{"$f":"'WA Gas - Sched 162'!T19","v":0},"n/a",{"$f":"'WA Gas - Sched 162'!R22*'WA Gas - Sched 162'!R9/'WA Gas - Sched 162'!R19/12","v":12332.998233652499},"n/a","n/a","n/a",{"$f":"'WA Gas - Sched 162'!T43","v":"n/a"}]
[146,"Transport Service pre 7/2021",{"$f":"'WA Gas - Sched 162'!U19","v":33},{"$f":"Forecast!O65/Forecast!O49/12","v":54878.617122222211},{"$f":"(('WA Gas - Sched 162'!U9*'WA Gas - Sched 162'!U22)-'WA Gas - Sched 162'!W37)/'WA Gas - Sched 162'!U19/12","v":12785.619872900179},{"$f":"'WA Gas - Sched 162'!U35","v":-9879.2199999999993},{"$f":"E14+F14","v":2906.3998729001796},{"$f":"G14*12","v":34876.798474802155},{"$f":"'WA Gas - Sched 162'!U43","v":0.33489656601673584}]
[146,"Transport Service After 7/2021",{"$f":"'WA Gas - Sched 162'!W19","v":2},{"$f":"Forecast!O66/Forecast!O50/12","v":32729.166666666668},{"$f":"'WA Gas - Sched 162'!W37","v":7369.9537499999997},0,7369.9537499999997,88439.444999999992,{"$f":"'WA Gas - Sched 162'!W43","v":0.99567752216901895}]

{"sheet":"Forecast","index":2,"n_rows":69,"n_cols":15,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Avista Utilities"]
["State of Washington"]
["Forecasted Billing Determ - Schedule 162"]
[null,null,"2024-04-30",{"$f":"EOMONTH(C4,1)","v":"2024-05-31"},{"$f":"EOMONTH(D4,1)","v":"2024-06-30"},{"$f":"EOMONTH(E4,1)","v":"2024-07-31"},{"$f":"EOMONTH(F4,1)","v":"2024-08-31"},{"$f":"EOMONTH(G4,1)","v":"2024-09-30"},{"$f":"EOMONTH(H4,1)","v":"2024-10-31"},{"$f":"EOMONTH(I4,1)","v":"2024-11-30"},{"$f":"EOMONTH(J4,1)","v":"2024-12-31"},{"$f":"EOMONTH(K4,1)","v":"2025-01-31"},{"$f":"EOMONTH(L4,1)","v":"2025-02-28"},{"$f":"EOMONTH(M4,1)","v":"2025-03-31"}]
[null,"Loads by Schedule"]
[null,"Total"]
[null,"WA101",9499682.7239622697,5016514.4672501832,3135852.5097496635,2272841.1016540774,2316389.9863451943,3415987.8876927826,8775642.8846403863,16621413.948530352,25026063.172614612,22656909.175218843,19849602.889217008,15164745.132398369]
[null,"WA111",4348827.3615205763,2709142.8793267882,2087159.7133220758,1746817.7686037498,1922964.2557926795,2425888.2833625982,5048312.1238102727,7775814.0376365269,9889776.0357673876,9069853.3055666778,7924640.9734425247,6391654.6936729671]
[null,"WA112",43.2,13047.877,14626.32,13714.83,5963.5280000000002,30861.5,48088,11639.3,0,0,0,0]
[null,"WA121",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WA132",243961,192768,149592,127723,130942,139991,153667.47399999999,163545,377381,348098,300634,300634]
[null,"WA146",{"$f":"'Sch 146 - Load Forecast'!C11","v":2199143.3785999999},{"$f":"'Sch 146 - Load Forecast'!D11","v":1886501.7999999998},{"$f":"'Sch 146 - Load Forecast'!E11","v":1674834.3220000002},{"$f":"'Sch 146 - Load Forecast'!F11","v":1372870.855},{"$f":"'Sch 146 - Load Forecast'!G11","v":1352081.05},{"$f":"'Sch 146 - Load Forecast'!H11","v":1299319.0471999999},{"$f":"'Sch 146 - Load Forecast'!I11","v":1419161.6868},{"$f":"'Sch 146 - Load Forecast'!J11","v":1865826.1568},{"$f":"'Sch 146 - Load Forecast'!K11","v":2164821.6264},{"$f":"'Sch 146 - Load Forecast'!L11","v":2534684.412},{"$f":"'Sch 146 - Load Forecast'!M11","v":2450818.8615999999},{"$f":"'Sch 146 - Load Forecast'!N11","v":2297369.1839999999}]
[]
[null,null,{"$f":"SUM(C7:C13)","v":16291657.664082846},{"$f":"SUM(D7:D13)","v":9817975.0235769711},{"$f":"SUM(E7:E13)","v":7062064.86507174},5533967.555257827,5728340.8201378733,7312047.7182553802,15444872.169250658,26438238.442966878,37458041.834781997,34609544.892785519,30525696.724259533,24154403.010071337]
[]
[null,"Gas Customers"]
[null,"Total"]
[null,"WA101",173751.80938881665,173492.29645748829,173575.48215610525,173630.20673269284,173863.15030761535,173754.4968362205,174389.37138730765,174154.05695264527,174861.69898026594,173930.68769033503,173936.71094614899,173942.73420196294]
[null,"WA111",3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898,3499.8093733924898]
[null,"WA112",1,1,1,1,1,1,1,1,1,1,1,1]
[null,"WA121",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WA132",4,4,4,4,4,4,4,4,4,4,4,4]
[null,"WA146",35,35,35,35,35,35,35,35,35,35,35,35]
[]
[null,null,{"$f":"SUM(C18:C24)","v":177291.61876220914},{"$f":"SUM(D18:D24)","v":177032.10583088078},{"$f":"SUM(E18:E24)","v":177115.29152949774},{"$f":"SUM(F18:F24)","v":177170.01610608533},{"$f":"SUM(G18:G24)","v":177402.95968100784},{"$f":"SUM(H18:H24)","v":177294.30620961299},{"$f":"SUM(I18:I24)","v":177929.18076070014},{"$f":"SUM(J18:J24)","v":177693.86632603777},{"$f":"SUM(K18:K24)","v":178401.50835365843},{"$f":"SUM(L18:L24)","v":177470.49706372753},{"$f":"SUM(M18:M24)","v":177476.52031954148},{"$f":"SUM(N18:N24)","v":177482.54357535543}]
[]
[null,"New Customers (7/25/2021+) as of 11/30/2023"]
[null,"WA101",4415,{"$f":"D18-C18+C28","v":4155.4870686716458},4238.6727672886045,4293.3973438761896,4526.3409187986981,4417.6874474038486,5052.5619984910008,4817.2475638286269,5524.8895914492896,4593.8783015183872,4599.9015573323413,4605.9248131462955]
[null,"WA111",73,{"$f":"D19-C19+C29","v":73},73,73,73,73,73,73,73,73,73,73]
[null,"WA112",1,{"$f":"D20-C20+C30","v":1},1,1,1,1,1,1,1,1,1,1]
[null,"WA121",0,{"$f":"D21-C21+C31","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"WA132",0,{"$f":"D22-C22+C32","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"WA146",2,{"$f":"D23-C23+C33","v":2},2,2,2,2,2,2,2,2,2,2]
[null,null,0,{"$f":"D24-C24+C34","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C28:C34)","v":4491},{"$f":"SUM(D28:D34)","v":4231.4870686716458},{"$f":"SUM(E28:E34)","v":4314.6727672886045},4369.3973438761896,4602.3409187986981,4493.6874474038486,5128.5619984910008,4893.2475638286269,5600.8895914492896,4669.8783015183872,4675.9015573323413,4681.9248131462955]
[]
[null,null,{"$f":"C57/C41","v":54.673863583798216},28.914911899154006,18.066218055666596,13.0901249524696,13.323064618619965,19.6598531254858,50.322120062869224,95.440865629963042,143.11918115034973,130.26401192385927,114.1196862999351,87.182400587027416]
[null,null,{"$f":"C58/C42","v":54.673863583798202},28.914911899154006,18.066218055666596,13.0901249524696,13.323064618619961,19.659853125485803,50.322120062869232,95.440865629963056,143.11918115034979,130.26401192385924,114.1196862999351,87.182400587027416]
[null,null,{"$f":"C59/C43","v":54.673863583798202},28.91491189915401,18.066218055666596,13.0901249524696,13.323064618619961,19.659853125485803,50.322120062869224,95.440865629963056,143.11918115034976,130.26401192385924,114.11968629993508,87.182400587027402]
[null,"Customer Count by New Rate Schedule Estimate"]
[null,{"$f":"B57","v":"SCH. 101 Pre 7/2021"},{"$f":"C18-C42-C43","v":140126.20976924576},{"$f":"D18-D42-D43","v":140126.20976924579},140126.20976924579,140126.20976924576,140126.20976924576,140126.20976924579,140126.20976924579,140126.20976924579,140126.20976924579,140126.20976924576,140126.20976924576,140126.20976924579,{"$f":"AVERAGE(B41:N41)","v":140126.20976924573}]
[null,{"$f":"B58","v":"SCH. 101 Res Fixed/Low Income"},{"$f":"(C18)*'WA Gas - Sched 162'!$F$2","v":29972.18711957087},{"$f":"(D18)*'WA Gas - Sched 162'!$F$2","v":29927.421138916729},{"$f":"(E18)*'WA Gas - Sched 162'!$F$2","v":29941.770671928152},{"$f":"(F18)*'WA Gas - Sched 162'!$F$2","v":29951.210661389512},{"$f":"(G18)*'WA Gas - Sched 162'!$F$2","v":29991.393428063646},{"$f":"(H18)*'WA Gas - Sched 162'!$F$2","v":29972.650704248033},{"$f":"(I18)*'WA Gas - Sched 162'!$F$2","v":30082.166564310566},{"$f":"(J18)*'WA Gas - Sched 162'!$F$2","v":30041.574824331306},{"$f":"(K18)*'WA Gas - Sched 162'!$F$2","v":30163.643074095871},{"$f":"(L18)*'WA Gas - Sched 162'!$F$2","v":30003.043626582792},{"$f":"(M18)*'WA Gas - Sched 162'!$F$2","v":30004.082638210697},{"$f":"(N18)*'WA Gas - Sched 162'!$F$2","v":30005.121649838606},30004.688841790561]
[null,{"$f":"B59","v":"SCH. 101  Post 7/2021"},{"$f":"(C28*(1-'WA Gas - Sched 162'!$F$2))","v":3653.4124999999999},{"$f":"(D28*(1-'WA Gas - Sched 162'!$F$2))","v":3438.6655493257872},{"$f":"(E28*(1-'WA Gas - Sched 162'!$F$2))","v":3507.5017149313203},{"$f":"(F28*(1-'WA Gas - Sched 162'!$F$2))","v":3552.7863020575469},{"$f":"(G28*(1-'WA Gas - Sched 162'!$F$2))","v":3745.5471103059226},{"$f":"(H28*(1-'WA Gas - Sched 162'!$F$2))","v":3655.6363627266846},{"$f":"(I28*(1-'WA Gas - Sched 162'!$F$2))","v":4180.9950537513032},{"$f":"(J28*(1-'WA Gas - Sched 162'!$F$2))","v":3986.272359068189},{"$f":"(K28*(1-'WA Gas - Sched 162'!$F$2))","v":4571.8461369242868},{"$f":"(L28*(1-'WA Gas - Sched 162'!$F$2))","v":3801.4342945064654},{"$f":"(M28*(1-'WA Gas - Sched 162'!$F$2))","v":3806.4185386925124},{"$f":"(N28*(1-'WA Gas - Sched 162'!$F$2))","v":3811.4027828785597},3809.3265587640476]
[null,{"$f":"B60","v":"SCH. 111"},{"$f":"C19-C45","v":3426.8093733924898},{"$f":"D19-D45","v":3426.8093733924898},3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924898,3426.8093733924902]
[null,{"$f":"B61","v":"SCH. 111 Post 7/21"},{"$f":"C29","v":73},{"$f":"D29","v":73},73,73,73,73,73,73,73,73,73,73,73]
[null,{"$f":"B62","v":"SCH. 112, 116"},{"$f":"C20-C47","v":0},{"$f":"D20-D47","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"SCH. 112, 116 Post 7/21",{"$f":"C30","v":1},{"$f":"D30","v":1},1,1,1,1,1,1,1,1,1,1,1]
[null,{"$f":"B64","v":"SCH. 131&132"},{"$f":"C22","v":4},{"$f":"D22","v":4},4,4,4,4,4,4,4,4,4,4,4]
[null,{"$f":"B65","v":"SCH. 146"},{"$f":"C23-C50","v":33},{"$f":"D23-D50","v":33},33,33,33,33,33,33,33,33,33,33,33]
[null,{"$f":"B66","v":" SCH. 146\n Post 7/21"},{"$f":"C33","v":2},{"$f":"D33","v":2},2,2,2,2,2,2,2,2,2,2,2]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C41:C51)","v":177291.61876220914},177032.10583088078,177115.29152949774,177170.01610608533,177402.95968100784,177294.30620961299,177929.18076070017,177693.86632603777,178401.50835365843,177470.49706372753,177476.52031954148,177482.54357535543,177480.03454319283]
[null,null,{"$f":"C52-C25","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Usage by Rate Schedule Estimate",null,null,null,null,null,null,null,null,null,null,null,null,"Annual"]
[null,{"$f":"'WA Gas - Sched 162'!D7","v":"SCH. 101 Pre 7/2021"},{"$f":"C7-C58-C59","v":7661241.2774384357},4051737.0102401152,2531550.661005273,1834269.5949953934,1866910.5475179574,2754860.7030943856,7051447.9519627849,13373766.757822603,20054748.399876595,18253402.260226235,15991159.101265227,12216539.352844222,{"$f":"SUM(C57:N57)","v":107641633.61828922}]
[null,{"$f":"'WA Gas - Sched 162'!F7","v":"SCH. 101 Res Fixed/Low Income"},{"$f":"C7*'WA Gas - Sched 162'!$F$2","v":1638695.2698834913},{"$f":"D7*'WA Gas - Sched 162'!$F$2","v":865348.74560065649},{"$f":"E7*'WA Gas - Sched 162'!$F$2","v":540934.5579318169},{"$f":"F7*'WA Gas - Sched 162'!$F$2","v":392065.09003532835},{"$f":"G7*'WA Gas - Sched 162'!$F$2","v":399577.272644546},{"$f":"H7*'WA Gas - Sched 162'!$F$2","v":589257.91062700492},{"$f":"I7*'WA Gas - Sched 162'!$F$2","v":1513798.3976004666},{"$f":"J7*'WA Gas - Sched 162'!$F$2","v":2867193.9061214854},{"$f":"K7*'WA Gas - Sched 162'!$F$2","v":4316995.8972760206},{"$f":"L7*'WA Gas - Sched 162'!$F$2","v":3908316.8327252502},{"$f":"M7*'WA Gas - Sched 162'!$F$2","v":3424056.4983899337},{"$f":"N7*'WA Gas - Sched 162'!$F$2","v":2615918.5353387184},{"$f":"SUM(C58:N58)","v":23072158.914174717}]
[null,{"$f":"'WA Gas - Sched 162'!H7","v":"SCH. 101  Post 7/2021"},{"$f":"C7/C18*C43","v":199746.17664034315},{"$f":"D7/D18*D43","v":99428.71140941116},63367.290812573767,46506.41662335569,49902.166182691071,71869.273971391769,210396.53507713546,380453.28458626289,654318.87546199374,495190.08226735768,434387.28956184682,332287.24421542964,{"$f":"SUM(C59:N59)","v":3037853.3468097928}]
[null,{"$f":"'WA Gas - Sched 162'!J7","v":"SCH. 111"},{"$f":"(C19+C20-C29-C30)/(C19+C20)*(C8)","v":4256901.9835784268},{"$f":"(D19+D20-D29-D30)/(D19+D20)*(D8)","v":2651877.1011344986},2043041.3960095958,1709893.5887671846,1882316.6969709429,2374609.9320381242,4941601.0586488061,7611449.1215807013,9680726.2565337401,8878135.0275841411,7757130.1582316784,6256548.0949170766,{"$f":"SUM(C60:N60)","v":60044230.415994912}]
[null,{"$f":"'WA Gas - Sched 162'!L7","v":"SCH. 111 Post 7/21"},{"$f":"C8-C60","v":91925.377942149527},{"$f":"D8-D60","v":57265.778192289639},44118.31731247995,36924.179836565163,40647.558821736602,51278.351324473973,106711.0651614666,164364.91605582554,209049.77923364751,191718.2779825367,167510.81521084625,135106.5987558905,1296621.015829908]
[null,{"$f":"'WA Gas - Sched 162'!N7","v":"SCH. 112, 116"},{"$f":"C9-C63","v":0},{"$f":"D9-D63","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'WA Gas - Sched 162'!P7","v":"SCH. 112, 116 Post 7/21"},{"$f":"C9/C30*C47","v":43.2},{"$f":"D9/D30*D47","v":13047.877},14626.32,13714.83,5963.5280000000002,30861.5,48088,11639.3,0,0,0,0,137984.55499999999]
[null,{"$f":"'WA Gas - Sched 162'!R7","v":"SCH. 131&132"},{"$f":"C11","v":243961},{"$f":"D11","v":192768},149592,127723,130942,139991,153667.47399999999,163545,377381,348098,300634,300634,2628936.4739999999]
[null,{"$f":"'WA Gas - Sched 162'!U7","v":"SCH. 146"},{"$f":"C12-C66","v":2151987.3785999999},{"$f":"D12-D66","v":1838527.7999999998},1634341.3220000002,1334698.855,1222218.05,1209977.0471999999,1297947.6868,1767840.1568,2128125.6264,2489870.412,2404874.8615999999,2251523.1839999999,21731932.380399998]
[null,{"$f":"'WA Gas - Sched 162'!W7","v":" SCH. 146\n Post 7/21"},{"$f":"'Sch 146 - Load Forecast'!C15","v":47156},{"$f":"'Sch 146 - Load Forecast'!D15","v":47974},{"$f":"'Sch 146 - Load Forecast'!E15","v":40493},{"$f":"'Sch 146 - Load Forecast'!F15","v":38172},{"$f":"'Sch 146 - Load Forecast'!G15","v":129863},{"$f":"'Sch 146 - Load Forecast'!H15","v":89342},{"$f":"'Sch 146 - Load Forecast'!I15","v":121214},{"$f":"'Sch 146 - Load Forecast'!J15","v":97986},{"$f":"'Sch 146 - Load Forecast'!K15","v":36696},{"$f":"'Sch 146 - Load Forecast'!L15","v":44814},{"$f":"'Sch 146 - Load Forecast'!M15","v":45944},{"$f":"'Sch 146 - Load Forecast'!N15","v":45846},785500]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C57:C67)","v":16291657.664082846},9817975.0235769711,7062064.86507174,5533967.555257827,5728340.8201378742,7312047.7182553802,15444872.16925066,26438238.442966878,37458041.834782004,34609544.892785519,30525696.724259533,24154403.010071337,220376850.72049856]
[null,null,{"$f":"C68-C14","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sch 146 - Load Forecast","index":3,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Avista Utilities"]
["State of Washington"]
["Forecasted Schedule 146 Billing Determ - Schedule 162 (from current GRC loads)"]
[]
[null,"Washington Gas Billing Determinants by Customer"]
[]
[null,"ANNUAL USAGE, Sch 146"]
[null,"Washington","2024-04-30",{"$f":"EOMONTH(C8,1)","v":"2024-05-31"},{"$f":"EOMONTH(D8,1)","v":"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","Total"]
[null,"Forecasted Load",2878601.3785999999,2520984.7999999998,2231816.3220000002,2063729.855,1976312.05,1902718.0471999999,2051878.6868,2488242.1568,2909124.6264,3060969.412,3209173.8615999999,2996149.1839999999,{"$f":"SUM(C9:N9)","v":30289700.380400006}]
[null,"Less Exempt Schedule 146 Customer",679458,634483,556982,690859,624231,603399,632717,622416,744303,526285,758355,698780,{"$f":"SUM(C10:N10)","v":7772268},null,{"$f":"Q$7*12-SUMPRODUCT(--($G10:$N10<=Q$7),Q$7-$G10:$N10)","v":0},{"$f":"R$7*12-SUM($Q10:Q10)-SUMPRODUCT(--($G10:$N10<=R$7),R$7-$G10:$N10)","v":0},{"$f":"S$7*12-SUM($Q10:R10)-SUMPRODUCT(--($G10:$N10<=S$7),S$7-$G10:$N10)","v":0},{"$f":"T$7*12-SUM($Q10:S10)-SUMPRODUCT(--($G10:$N10<=T$7),T$7-$G10:$N10)","v":0},{"$f":"U$7*12-SUM($Q10:T10)-SUMPRODUCT(--($G10:$N10<=U$7),U$7-$G10:$N10)","v":0},null,{"$f":"IF(O10<250000,(250000-O10)*[20]RD!$E$56,0)","v":0},{"$f":"IF(O10<250000,(250000-O10)*[20]RD!$K$56,0)","v":0}]
[null,"Net Applicable Schedule 146 Load",{"$f":"C9-C10","v":2199143.3785999999},1886501.7999999998,1674834.3220000002,1372870.855,1352081.05,1299319.0471999999,1419161.6868,1865826.1568,2164821.6264,2534684.412,2450818.8615999999,2297369.1839999999,{"$f":"SUM(C11:N11)","v":22517432.380399998}]
[]
[null,"Post 7/2021 Schedule 146 Customer #1",47156,47974,40493,38172,37798,36926,37391,39924,36696,44814,45944,45846,{"$f":"SUM(C13:N13)","v":499134}]
[null,"Post 7/2021 Schedule 146 Customer #2",null,null,null,null,92065,52416,83823,58062,null,null,null,null,{"$f":"SUM(C14:N14)","v":286366}]
[null,"Total",{"$f":"SUM(C13:C14)","v":47156},{"$f":"SUM(D13:D14)","v":47974},40493,38172,129863,89342,121214,97986,36696,44814,45944,45846,{"$f":"SUM(C15:N15)","v":785500}]

{"sheet":"Cost Amtz Calc - Sch 101-146","index":4,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,1,5,6],[7,2,7,5]]}
["Avista Utilities"]
["State of Washington",null,null,null,"RCF",{"$f":"'Conversion Factor'!E28","v":1.045717}]
["Development of Amortization Rate"]
[]
[]
[null,"AMORTIZATION RATE CALCULATION"]
[]
[null,null,"Schedule 101-146  - Costs to All Customers"]
[null,null,"Customers","Amortization & Deferral","Interest","Balance"]
[null,null,null,null,4.8000000000000001E-2]
[null,"Beginning Balance",null,"Amortization",null,{"$f":"'WA Gas - Sched 162'!C14","v":46022329}]
[null,"2024-04-30",{"$f":"Forecast!C14","v":16291657.664082846},{"$f":"-(C12/$C$24)*$F$11","v":-3402263.1075835163},{"$f":"ROUND((F11+(D12/2))*E$10/12,2)","v":177284.79},{"$f":"F11+D12+E12","v":42797350.682416484}]
[null,{"$f":"EOMONTH(B12,1)","v":"2024-05-31"},{"$f":"Forecast!D14","v":9817975.0235769711},{"$f":"-(C13/$C$24)*$F$11","v":-2050333.6678583964},{"$f":"ROUND((F12+(D13/2))*E$10/12,2)","v":167088.74},{"$f":"+F12+D13+E13","v":40914105.754558086}]
[null,{"$f":"EOMONTH(B13,1)","v":"2024-06-30"},{"$f":"Forecast!E14","v":7062064.86507174},-1474804.0530440379,160706.81,{"$f":"+F13+D14+E14","v":39600008.511514053}]
[null,"2024-07-31",{"$f":"Forecast!F14","v":5533967.555257827},-1155684.3410309772,156088.67000000001,38600412.840483077]
[null,"2024-08-31",{"$f":"Forecast!G14","v":5728340.8201378733},-1196276.2195148889,152009.1,37556145.720968187]
[null,"2024-09-30",{"$f":"Forecast!H14","v":7312047.7182553802},-1527009.142081124,147170.56,36176307.138887063]
[null,"2024-10-31",{"$f":"Forecast!I14","v":15444872.169250658},-3225424.9301243913,138254.38,33089136.588762671]
[null,"2024-11-30",{"$f":"Forecast!J14","v":26438238.442966878},-5521221.0530490726,121314.1,27689229.6357136]
[null,"2024-12-31",{"$f":"Forecast!K14","v":37458041.834781997},-7822538.1630601091,95111.84,19961803.312653489]
[null,"2025-01-31",{"$f":"Forecast!L14","v":34609544.892785519},-7227673.2169849817,65391.87,12799521.965668507]
[null,"2025-02-28",{"$f":"Forecast!M14","v":30525696.724259533},-6374824.0933884066,38448.44,6463146.3122801008]
[null,"2025-03-31",{"$f":"Forecast!N14","v":24154403.010071337},-5044277.0122800963,15764.03,{"$f":"+F22+D23+E23","v":1434633.3300000045}]
[null,null,{"$f":"SUM(C12:C23)","v":220376850.72049856},{"$f":"SUM(D12:D23)","v":-46022329.000000007},{"$f":"SUM(E12:E23)","v":1434633.33},{"$f":"D24+E24+F11","v":1434633.3299999908}]
[]
[null,null,null,"Amortization Rate",{"$f":"ROUND(F11/C24,5)","v":0.20882999999999999},{"$f":"F11","v":46022329}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F23/C24,5)","v":6.5100000000000002E-3},{"$f":"E24","v":1434633.33}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E26:E27)","v":0.21533999999999998},{"$f":"SUM(F26:F27)","v":47456962.329999998}]
[null,null,null,"Tariff Rate",{"$f":"ROUND(E28*$F$2,5)","v":0.22517999999999999},{"$f":"E29*C24","v":49624459.245241866}]

{"sheet":"Ben Amtz Calc - Sch 101","index":5,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[17,1,17,6],[19,2,19,5]]}
["Avista Utilities"]
["State of Washington",null,null,null,"RCF",{"$f":"'Conversion Factor'!E28","v":1.045717}]
["Development of Amortization Rate"]
[]
[null,null,null,"2024-04-30",{"$f":"EOMONTH(D5,1)","v":"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","Total"]
[null,null,"WA101",{"$f":"Forecast!C57","v":7661241.2774384357},{"$f":"Forecast!D57","v":4051737.0102401152},{"$f":"Forecast!E57","v":2531550.661005273},{"$f":"Forecast!F57","v":1834269.5949953934},{"$f":"Forecast!G57","v":1866910.5475179574},{"$f":"Forecast!H57","v":2754860.7030943856},{"$f":"Forecast!I57","v":7051447.9519627849},{"$f":"Forecast!J57","v":13373766.757822603},{"$f":"Forecast!K57","v":20054748.399876595},{"$f":"Forecast!L57","v":18253402.260226235},{"$f":"Forecast!M57","v":15991159.101265227},{"$f":"Forecast!N57","v":12216539.352844222},{"$f":"SUM(D6:O6)","v":107641633.61828922}]
[]
[null,null,null,"Volumes","% of Annual"]
[null,null,"Apr- Oct",{"$f":"SUM(D6:J6)","v":27752017.746254347},{"$f":"D9/$D$11","v":0.25781862290074947}]
[null,null,"Nov - Mar",{"$f":"SUM(K6:O6)","v":79889615.872034878},{"$f":"D10/$D$11","v":0.74218137709925047}]
[null,null,null,{"$f":"D9+D10","v":107641633.61828923}]
[]
[null,null,"Total Annual Benefits to be Allocated",{"$f":"'WA Gas - Sched 162'!D30","v":-18083242.832187314}]
[null,null,"Apr- Oct Benefit",{"$f":"D13*E9","v":-4662196.7645743815}]
[null,null,"Nov - Mar Benefit",{"$f":"D13*E10","v":-13421046.067612931}]
[]
[]
[null,"AMORTIZATION RATE CALCULATION"]
[]
[null,null,"Schedule 101 - Benefits to Pre 7/2021 Customers"]
[null,null,"Customers","Amortization & Deferral","Interest","Balance"]
[null,null,null,null,4.8000000000000001E-2]
[null,"Beginning Balance",null,"Amortization",null,{"$f":"D14","v":-4662196.7645743815}]
[null,"2024-04-30",{"$f":"Forecast!O41","v":140126.20976924573},{"$f":"-(C24/$C$31)*$F$23","v":666028.10922491178},{"$f":"ROUND((F23+(D24/2))*$E$22/12,2)","v":-17316.73},{"$f":"F23+D24+E24","v":-4013485.3853494697}]
[null,{"$f":"EOMONTH(B24,1)","v":"2024-05-31"},{"$f":"$C$24","v":140126.20976924573},666028.10922491178,{"$f":"ROUND((F24+(D25/2))*$E$22/12,2)","v":-14721.89},{"$f":"+F24+D25+E25","v":-3362179.1661245581}]
[null,{"$f":"EOMONTH(B25,1)","v":"2024-06-30"},{"$f":"$C$24","v":140126.20976924573},666028.10922491178,-12116.66,{"$f":"+F25+D26+E26","v":-2708267.7168996464}]
[null,"2024-07-31",140126.20976924573,666028.10922491178,-9501.01,-2051740.6176747347]
[null,"2024-08-31",140126.20976924573,666028.10922491178,-6874.91,-1392587.4184498228]
[null,"2024-09-30",140126.20976924573,666028.10922491178,-4238.29,-730797.59922491107]
[null,{"$f":"EOMONTH(B29,1)","v":"2024-10-31"},140126.20976924573,666028.10922491178,-1591.13,-66360.619999999297]
[null,null,{"$f":"SUM(C24:C30)","v":980883.46838472004},{"$f":"SUM(D24:D30)","v":4662196.7645743825},{"$f":"SUM(E24:E30)","v":-66360.62},{"$f":"D31+E31+F23","v":-66360.61999999918}]
[null,null,null,"Amortization Rate"]
[null,null,null,null,{"$f":"ROUND(F23/C31,2)","v":-4.75},{"$f":"F23","v":-4662196.7645743815}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F31/C31,2)","v":-7.0000000000000007E-2},{"$f":"E31","v":-66360.62}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E33:E34)","v":-4.82},{"$f":"SUM(F33:F34)","v":-4728557.3845743816}]
[null,null,null,"Tariff Rate (Mar - Oct)",{"$f":"ROUND(E35*$F$2,2)","v":-5.04}]
[]
[]
[null,"Beginning Balance",null,null,null,{"$f":"D15","v":-13421046.067612931}]
[null,{"$f":"EOMONTH(B30,1)","v":"2024-11-30"},{"$f":"$C$24","v":140126.20976924573},{"$f":"-(C40/$C$45)*$F$39","v":2684209.2135225865},{"$f":"ROUND((F39+(D40/2))*$E$22/12,2)","v":-48315.77},{"$f":"+F39+D40+E40","v":-10785152.624090344}]
[null,{"$f":"EOMONTH(B40,1)","v":"2024-12-31"},140126.20976924573,{"$f":"-(C41/$C$45)*$F$39","v":2684209.2135225865},{"$f":"ROUND((F40+(D41/2))*$E$22/12,2)","v":-37772.19},{"$f":"+F40+D41+E41","v":-8138715.6005677572}]
[null,"2025-01-31",140126.20976924573,{"$f":"-(C42/$C$45)*$F$39","v":2684209.2135225865},{"$f":"ROUND((F41+(D42/2))*$E$22/12,2)","v":-27186.44},-5481692.8270451715]
[null,"2025-02-28",140126.20976924573,{"$f":"-(C43/$C$45)*$F$39","v":2684209.2135225865},-16558.349999999999,-2814041.9635225851]
[null,"2025-03-31",140126.20976924573,{"$f":"-(C44/$C$45)*$F$39","v":2684209.2135225865},-5887.75,-135720.4999999986]
[null,null,{"$f":"SUM(C40:C44)","v":700631.04884622863},{"$f":"SUM(D40:D44)","v":13421046.067612933},{"$f":"SUM(E40:E44)","v":-135720.5},{"$f":"D45+E45+F39","v":-135720.49999999814}]
[]
[null,null,null,"Amortization Rate",{"$f":"ROUND(F39/C45,2)","v":-19.16},{"$f":"F39","v":-13421046.067612931}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F45/C45,2)","v":-0.19},{"$f":"E45","v":-135720.5}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E47:E48)","v":-19.350000000000001},{"$f":"SUM(F47:F48)","v":-13556766.567612931}]
[null,null,null,"Tariff Rate (Nov - Feb)",{"$f":"ROUND(E49*$F$2,2)","v":-20.23}]

{"sheet":"Ben Amtz Calc - Sch 111","index":6,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[17,1,17,6],[19,2,19,5]]}
["Avista Utilities"]
["State of Washington",null,null,null,"RCF",{"$f":"'Conversion Factor'!E28","v":1.045717}]
["Development of Amortization Rate"]
[]
[null,null,null,"2024-04-30",{"$f":"EOMONTH(D5,1)","v":"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","Total"]
[null,null,"WA111",{"$f":"Forecast!C60","v":4256901.9835784268},{"$f":"Forecast!D60","v":2651877.1011344986},{"$f":"Forecast!E60","v":2043041.3960095958},{"$f":"Forecast!F60","v":1709893.5887671846},{"$f":"Forecast!G60","v":1882316.6969709429},{"$f":"Forecast!H60","v":2374609.9320381242},{"$f":"Forecast!I60","v":4941601.0586488061},{"$f":"Forecast!J60","v":7611449.1215807013},{"$f":"Forecast!K60","v":9680726.2565337401},{"$f":"Forecast!L60","v":8878135.0275841411},{"$f":"Forecast!M60","v":7757130.1582316784},{"$f":"Forecast!N60","v":6256548.0949170766},{"$f":"SUM(D6:O6)","v":60044230.415994912}]
[]
[null,null,null,"Volumes","% of Annual"]
[null,null,"Apr- Oct",{"$f":"SUM(D6:J6)","v":19860241.75714758},{"$f":"D9/$D$11","v":0.33076020159727287}]
[null,null,"Nov - Mar",{"$f":"SUM(K6:O6)","v":40183988.658847332},{"$f":"D10/$D$11","v":0.66923979840272718}]
[null,null,null,{"$f":"D9+D10","v":60044230.415994912}]
[]
[null,null,"Total Annual Benefits to be Allocated",{"$f":"'WA Gas - Sched 162'!J30","v":-10087123.009806849}]
[null,null,"Apr- Oct Benefit",{"$f":"D13*E9","v":-3336418.8402602035}]
[null,null,"Nov - Mar Benefit",{"$f":"D13*E10","v":-6750704.1695466461}]
[]
[]
[null,"AMORTIZATION RATE CALCULATION"]
[]
[null,null,"Schedule 111 - Benefits to Pre 7/2021 Customers"]
[null,null,"Customers","Amortization & Deferral","Interest","Balance"]
[null,null,null,null,4.8000000000000001E-2]
[null,"Beginning Balance",null,"Amortization",null,{"$f":"'Ben Amtz Calc - Sch 111'!D14","v":-3336418.8402602035}]
[null,"2024-04-30",{"$f":"Forecast!C44","v":3426.8093733924898},{"$f":"-(C24/$C$31)*$F$23","v":476631.26289431477},{"$f":"ROUND((F23+(D24/2))*$E$22/12,2)","v":-12392.41},{"$f":"F23+D24+E24","v":-2872179.9873658889}]
[null,{"$f":"EOMONTH(B24,1)","v":"2024-05-31"},{"$f":"Forecast!D44","v":3426.8093733924898},476631.26289431477,{"$f":"ROUND((F24+(D25/2))*$E$22/12,2)","v":-10535.46},{"$f":"+F24+D25+E25","v":-2406084.1844715741}]
[null,{"$f":"EOMONTH(B25,1)","v":"2024-06-30"},{"$f":"Forecast!E44","v":3426.8093733924898},476631.26289431477,-8671.07,{"$f":"+F25+D26+E26","v":-1938123.9915772595}]
[null,"2024-07-31",{"$f":"Forecast!F44","v":3426.8093733924898},476631.26289431477,-6799.23,-1468291.9586829448]
[null,"2024-08-31",{"$f":"Forecast!G44","v":3426.8093733924898},476631.26289431477,-4919.91,-996580.60578863008]
[null,"2024-09-30",{"$f":"Forecast!H44","v":3426.8093733924898},476631.26289431477,-3033.06,-522982.40289431531]
[null,{"$f":"EOMONTH(B29,1)","v":"2024-10-31"},{"$f":"Forecast!I44","v":3426.8093733924898},476631.26289431477,-1138.67,-47489.810000000536]
[null,null,{"$f":"SUM(C24:C30)","v":23987.665613747431},{"$f":"SUM(D24:D30)","v":3336418.8402602035},{"$f":"SUM(E24:E30)","v":-47489.81},{"$f":"D31+E31+F23","v":-47489.810000000056}]
[null,null,null,"Amortization Rate"]
[null,null,null,null,{"$f":"ROUND(F23/C31,2)","v":-139.09},{"$f":"F23","v":-3336418.8402602035}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F31/C31,2)","v":-1.98},{"$f":"E31","v":-47489.81}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E33:E34)","v":-141.07},{"$f":"SUM(F33:F34)","v":-3383908.6502602035}]
[null,null,null,"Tariff Rate (Mar - Oct)",{"$f":"ROUND(E35*$F$2,2)","v":-147.52000000000001}]
[]
[]
[null,"Beginning Balance",null,null,null,{"$f":"'Ben Amtz Calc - Sch 111'!D15","v":-6750704.1695466461}]
[null,{"$f":"EOMONTH(B30,1)","v":"2024-11-30"},{"$f":"Forecast!J44","v":3426.8093733924898},{"$f":"-(C40/$C$45)*$F$39","v":1350140.833909329},{"$f":"ROUND((F39+(D40/2))*$E$22/12,2)","v":-24302.54},{"$f":"+F39+D40+E40","v":-5424865.8756373171}]
[null,{"$f":"EOMONTH(B40,1)","v":"2024-12-31"},{"$f":"Forecast!K44","v":3426.8093733924898},{"$f":"-(C41/$C$45)*$F$39","v":1350140.833909329},{"$f":"ROUND((F40+(D41/2))*$E$22/12,2)","v":-18999.18},{"$f":"+F40+D41+E41","v":-4093724.2217279882}]
[null,"2025-01-31",{"$f":"Forecast!L44","v":3426.8093733924898},{"$f":"-(C42/$C$45)*$F$39","v":1350140.833909329},{"$f":"ROUND((F41+(D42/2))*$E$22/12,2)","v":-13674.62},-2757258.0078186593]
[null,"2025-02-28",{"$f":"Forecast!M44","v":3426.8093733924898},{"$f":"-(C43/$C$45)*$F$39","v":1350140.833909329},-8328.75,-1415445.9239093303]
[null,"2025-03-31",{"$f":"Forecast!N44","v":3426.8093733924898},{"$f":"-(C44/$C$45)*$F$39","v":1350140.833909329},-2961.5,-68266.590000001248]
[null,null,{"$f":"SUM(C40:C44)","v":17134.04686696245},{"$f":"SUM(D40:D44)","v":6750704.1695466451},{"$f":"SUM(E40:E44)","v":-68266.59},{"$f":"D45+E45+F39","v":-68266.590000000782}]
[]
[null,null,null,"Amortization Rate",{"$f":"ROUND(F39/C45,2)","v":-393.99},{"$f":"F39","v":-6750704.1695466461}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F45/C45,2)","v":-3.98},{"$f":"E45","v":-68266.59}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E47:E48)","v":-397.97},{"$f":"SUM(F47:F48)","v":-6818970.7595466459}]
[null,null,null,"Tariff Rate (Nov - Feb)",{"$f":"ROUND(E49*$F$2,2)","v":-416.16}]

{"sheet":"Ben Amtz Calc - Sch 112-116","index":7,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,1,5,6],[7,2,7,5]]}
["Avista Utilities"]
["State of Washington",null,null,null,"RCF",{"$f":"'Conversion Factor'!E28","v":1.045717}]
["Development of Amortization Rate"]
[]
[]
[null,"AMORTIZATION RATE CALCULATION"]
[]
[null,null,"Schedule 112/116 - Benefits to Pre 7/2021 Customers"]
[null,null,"Customers","Amortization & Deferral","Interest","Balance"]
[null,null,null,null,4.8000000000000001E-2]
[null,"Beginning Balance",null,"Amortization",null,{"$f":"'WA Gas - Sched 162'!N25","v":0}]
[null,"2024-04-30",{"$f":"Forecast!C46","v":0},{"$f":"-(C12/$C$24)*$F$11","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((F11+(D12/2))*$E$10/12,2)","v":{"$error":"#DIV/0!"}},{"$f":"F11+D12+E12","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"EOMONTH(B12,1)","v":"2024-05-31"},{"$f":"Forecast!D46","v":0},{"$f":"-(C13/$C$24)*$F$11","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((F12+(D13/2))*$E$10/12,2)","v":{"$error":"#DIV/0!"}},{"$f":"+F12+D13+E13","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"EOMONTH(B13,1)","v":"2024-06-30"},{"$f":"Forecast!E46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+F13+D14+E14","v":{"$error":"#DIV/0!"}}]
[null,"2024-07-31",{"$f":"Forecast!F46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2024-08-31",{"$f":"Forecast!G46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2024-09-30",{"$f":"Forecast!H46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2024-10-31",{"$f":"Forecast!I46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2024-11-30",{"$f":"Forecast!J46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2024-12-31",{"$f":"Forecast!K46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2025-01-31",{"$f":"Forecast!L46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2025-02-28",{"$f":"Forecast!M46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"2025-03-31",{"$f":"Forecast!N46","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+F22+D23+E23","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"SUM(C12:C23)","v":0},{"$f":"SUM(D12:D23)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E12:E23)","v":{"$error":"#DIV/0!"}},{"$f":"D24+E24+F11","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Amortization Rate",{"$f":"ROUND(F11/C24,2)","v":{"$error":"#DIV/0!"}},{"$f":"F11","v":0}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F23/C24,2)","v":{"$error":"#DIV/0!"}},{"$f":"E24","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E26:E27)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F26:F27)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Tariff Rate",{"$f":"ROUND(E28*$F$2,2)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Ben Amtz Calc - Sch 131-132","index":8,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,1,5,6],[7,2,7,5]]}
["Avista Utilities"]
["State of Washington",null,null,null,"RCF",{"$f":"'Conversion Factor'!E28","v":1.045717}]
["Development of Amortization Rate"]
[]
[]
[null,"AMORTIZATION RATE CALCULATION"]
[]
[null,null,"Schedule 131/132 - Benefits to Pre 7/2021 Customers"]
[null,null,"Customers","Amortization & Deferral","Interest","Balance"]
[null,null,null,null,4.8000000000000001E-2]
[null,"Beginning Balance",null,"Amortization",null,{"$f":"'WA Gas - Sched 162'!R30","v":-441647.85549723293}]
[null,"2024-04-30",{"$f":"Forecast!C48","v":4},{"$f":"-(C12/$C$24)*$F$11","v":36803.987958102742},{"$f":"ROUND((F11+(D12/2))*$E$10/12,2)","v":-1692.98},{"$f":"F11+D12+E12","v":-406536.84753913019}]
[null,{"$f":"EOMONTH(B12,1)","v":"2024-05-31"},{"$f":"Forecast!D48","v":4},{"$f":"-(C13/$C$24)*$F$11","v":36803.987958102742},{"$f":"ROUND((F12+(D13/2))*$E$10/12,2)","v":-1552.54},{"$f":"+F12+D13+E13","v":-371285.39958102745}]
[null,{"$f":"EOMONTH(B13,1)","v":"2024-06-30"},{"$f":"Forecast!E48","v":4},36803.987958102742,-1411.53,{"$f":"+F13+D14+E14","v":-335892.94162292476}]
[null,"2024-07-31",{"$f":"Forecast!F48","v":4},36803.987958102742,-1269.96,-300358.91366482206]
[null,"2024-08-31",{"$f":"Forecast!G48","v":4},36803.987958102742,-1127.83,-264682.75570671936]
[null,"2024-09-30",{"$f":"Forecast!H48","v":4},36803.987958102742,-985.12,-228863.8877486166]
[null,"2024-10-31",{"$f":"Forecast!I48","v":4},36803.987958102742,-841.85,-192901.74979051386]
[null,"2024-11-30",{"$f":"Forecast!J48","v":4},36803.987958102742,-698,-156795.76183241111]
[null,"2024-12-31",{"$f":"Forecast!K48","v":4},36803.987958102742,-553.58000000000004,-120545.35387430836]
[null,"2025-01-31",{"$f":"Forecast!L48","v":4},36803.987958102742,-408.57,-84149.935916205635]
[null,"2025-02-28",{"$f":"Forecast!M48","v":4},36803.987958102742,-262.99,-47608.937958102892]
[null,"2025-03-31",{"$f":"Forecast!N48","v":4},36803.987958102742,-116.83,{"$f":"+F22+D23+E23","v":-10921.78000000015}]
[null,null,{"$f":"SUM(C12:C23)","v":48},{"$f":"SUM(D12:D23)","v":441647.85549723281},{"$f":"SUM(E12:E23)","v":-10921.779999999999},{"$f":"D24+E24+F11","v":-10921.780000000086}]
[]
[null,null,null,"Amortization Rate",{"$f":"ROUND(F11/C24,2)","v":-9201},{"$f":"F11","v":-441647.85549723293}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F23/C24,2)","v":-227.54},{"$f":"E24","v":-10921.779999999999}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E26:E27)","v":-9428.5400000000009},{"$f":"SUM(F26:F27)","v":-452569.6354972329}]
[null,null,null,"Tariff Rate",{"$f":"ROUND(E28*$F$2,2)","v":-9859.58}]

{"sheet":"Ben Amtz Calc - Sch 146","index":9,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,1,5,6],[7,2,7,5]]}
["Avista Utilities"]
["State of Washington",null,null,null,"RCF",{"$f":"'Conversion Factor'!E28","v":1.045717}]
["Development of Amortization Rate"]
[]
[]
[null,"AMORTIZATION RATE CALCULATION"]
[]
[null,null,"Schedule 146 - Benefits to Pre 7/2021 Customers"]
[null,null,"Customers","Amortization & Deferral","Interest","Balance"]
[null,null,null,null,4.8000000000000001E-2]
[null,"Beginning Balance",null,"Amortization",null,{"$f":"'WA Gas - Sched 162'!U30","v":-3650853.2733813548}]
[null,"2024-04-30",{"$f":"Forecast!C49","v":33},{"$f":"-(C12/$C$24)*$F$11","v":304237.77278177952},{"$f":"ROUND((F11+(D12/2))*$E$10/12,2)","v":-13994.94},{"$f":"F11+D12+E12","v":-3360610.4405995752}]
[null,{"$f":"EOMONTH(B12,1)","v":"2024-05-31"},{"$f":"Forecast!D49","v":33},{"$f":"-(C13/$C$24)*$F$11","v":304237.77278177952},{"$f":"ROUND((F12+(D13/2))*$E$10/12,2)","v":-12833.97},{"$f":"+F12+D13+E13","v":-3069206.6378177959}]
[null,{"$f":"EOMONTH(B13,1)","v":"2024-06-30"},{"$f":"Forecast!E49","v":33},304237.77278177952,-11668.35,{"$f":"+F13+D14+E14","v":-2776637.2150360164}]
[null,"2024-07-31",{"$f":"Forecast!F49","v":33},304237.77278177952,-10498.07,-2482897.5122542367]
[null,"2024-08-31",{"$f":"Forecast!G49","v":33},304237.77278177952,-9323.11,-2187982.8494724571]
[null,"2024-09-30",{"$f":"Forecast!H49","v":33},304237.77278177952,-8143.46,-1891888.5366906775]
[null,"2024-10-31",{"$f":"Forecast!I49","v":33},304237.77278177952,-6959.08,-1594609.8439088981]
[null,"2024-11-30",{"$f":"Forecast!J49","v":33},304237.77278177952,-5769.96,-1296142.0311271185]
[null,"2024-12-31",{"$f":"Forecast!K49","v":33},304237.77278177952,-4576.09,-996480.34834533895]
[null,"2025-01-31",{"$f":"Forecast!L49","v":33},304237.77278177952,-3377.45,-695620.02556355938]
[null,"2025-02-28",{"$f":"Forecast!M49","v":33},304237.77278177952,-2174,-393556.25278177985]
[null,"2025-03-31",{"$f":"Forecast!N49","v":33},304237.77278177952,-965.75,{"$f":"+F22+D23+E23","v":-90284.230000000331}]
[null,null,{"$f":"SUM(C12:C23)","v":396},{"$f":"SUM(D12:D23)","v":3650853.2733813543},{"$f":"SUM(E12:E23)","v":-90284.23000000001},{"$f":"D24+E24+F11","v":-90284.230000000447}]
[]
[null,null,null,"Amortization Rate",{"$f":"ROUND(F11/C24,2)","v":-9219.33},{"$f":"F11","v":-3650853.2733813548}]
[null,null,null,"Interest Rate",{"$f":"ROUND(F23/C24,2)","v":-227.99},{"$f":"E24","v":-90284.23000000001}]
[null,null,null,"Rate Before RCF",{"$f":"SUM(E26:E27)","v":-9447.32},{"$f":"SUM(F26:F27)","v":-3741137.5033813547}]
[null,null,null,"Tariff Rate",{"$f":"ROUND(E28*$F$2,2)","v":-9879.2199999999993}]

{"sheet":"Conversion Factor","index":10,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,4]]}
["AVISTA UTILITIES"]
["Revenue Conversion Factor"]
["Washington - Natural Gas System"]
["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,{"$f":"E22*21%","v":0.20081921999999999}]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.75546278}]
[]
[null,null,"REVENUE GROSS UP:","1/(1-.043718)",{"$f":"ROUND(1/(1-E20),6)","v":1.045717}]
[]
["2022 GRC Conversion Factor (UG-220054)"]

{"sheet":"Revenue - current rates","index":11,"n_rows":47,"n_cols":38,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Forecasted Usage",null,null,"2023-01-31",{"$f":"EOMONTH(D3,1)","v":"2023-02-28"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01",null,"2022-2023","2023-2024"]
[null,"Small Service Schedule 101",null,null,null,null,{"$f":"G38","v":0},{"$f":"H38","v":5070610.5531998109},3170130.372016375,1812771.8926424859,2073438.0843850782,2968240.5660654423,9254547.3455810752,17143580.537804507,26127031.462473758,23816315.706908848,20619339.573812734,16091512.440609436,9894923.2650398463,5199750.4931855202,2945533.4820336467,2102810.0767066558,1903280.0295206353,3089788.9015638665,8963927.3463242725,17127558.92009785,25959555.354015864,23947467.536230512,20801110.457976989,16397869.908349177,10115068.393056097,5223536.6227784296,3184810.3452011878,2109689.4224888245,null,{"$f":"SUM(K4:V4)","v":138237023.03460655},{"$f":"SUM(W4:AH4)","v":138823663.23760372}]
[null,"Large Service Schedule 111",null,null,null,null,{"$f":"G39+G40","v":0},{"$f":"H39+H40","v":2588626.5926134456},2011700.368299183,1683906.7702309897,1742851.7367864409,2322414.8692462118,4924835.8528578607,7252306.4993036538,9372326.1083555091,8698800.5669853613,7582269.9890039274,6291462.544827668,4212964.4749191692,2544237.5025430578,1995612.2801158165,1674561.4721210408,1758920.3538532169,2348799.1103350651,5019484.6365879467,7361177.0294063678,9522983.6002360694,8825720.9970562849,7695576.5673085898,6390946.6901884656,4285273.9040826699,2590001.9825783693,2037652.6902911412,1698383.8758142141,null,{"$f":"SUM(K5:V5)","v":58614643.897065707},{"$f":"SUM(W5:AH5)","v":59534921.437738404}]
[null,"Interrupt Service Schedule 131",null,null,null,null,{"$f":"G42","v":0},45178.592041924763,37951.0168820135,36160.191204956966,32707.676267293024,40862.345369953655,86622.768481211868,113518.487262,132358.85107130543,118703.33521448342,106925.79840659398,91577.374449217663,66054.928390878238,46918.899131297963,39004.301097719697,35314.218202961965,{"$f":"W42","v":31110.611434196442},36840.785682120222,81394.075281387049,109609.01177984949,131031.07356211923,120036.60083139922,110133.3260915823,92090.460079383294,67113.192613570282,47922.486123568306,40123.227880584709,35752.296166013504,null,910568.98334491695,903157.14752577385]
[null,"Transport Service Schedule 146",null,null,null,null,0,{"$f":"H43","v":2825661},2478607,2304662,2215419,2255889,2418396,2921288,3395034,3728560,3846569,3428664,3327185,2874605,2555500,2358850,{"$f":"W43","v":2223456},2315682,2366203,2988871,3335564,3705380,3829526,3438126,3350365,2875023,2538856,2329248]
[null,"Special Contract Transport",null,null,null,null,0,3408896,3127311,2936673,2793896,2920172,2996541,3546647,3884589,4299759,4338868,3850822,3830134,3428840,3134594,2964348,{"$f":"W44","v":2806056},2916767,3005728,3551884,3896302,4312962,4350528,3861329,3835979,3436820,3144062,2974418]
["Total Forecasted Usage",null,null,{"$f":"SUM(D4:D8)","v":0},0,0,0,13938972.737855181,10825699.757197572,8774173.8540784325,8858312.4974388126,10507578.780681608,19680942.966920145,30977340.52437016,42911339.42190057,40662138.609108694,36493972.361223251,29754038.359886318,21331261.668349892,14094351.894859876,10670244.063247183,9135883.7670306582,8722822.994808048,10707877.797581051,19436737.058193609,31139099.961284067,42845436.027814053,40911567.134118199,36786874.351377159,30180362.058617026,21653799.489752337,14173304.091480367,10945504.263372913,9147491.5944690518,null,{"$f":"SUM(AJ4:AJ8)","v":197762235.91501716},{"$f":"SUM(AK4:AK8)","v":199261741.82286793},{"$f":"(AK9-AJ9)/AJ9","v":7.58236728520375E-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,null,null,null,null,{"$f":"'WA Gas - Sched 162'!C9","v":220376850.72049859}]
[]
["DSM Rates"]
[null,"Small Service Schedule 101",null,{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}}]
[null,"Large Service Schedule 111",null,{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}}]
[null,"Interrupt Service Schedule 131",null,{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}},{"$f":"'WA Gas - Sched 162'!#REF!","v":{"$error":"#REF!"}}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total"]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D3","v":"2023-01-31"},"2023-02-28","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01"]
[null,"Small Service Schedule 101",null,{"$f":"D4*D13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Large Service Schedule 111",null,{"$f":"D5*D14","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Interrupt Service Schedule 131",null,{"$f":"D6*D15","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D22:D26)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Net DSM Revenue",null,{"$f":"RCF!C23","v":0.95628199999999997},{"$f":"D21","v":"2023-01-31"},{"$f":"E21","v":"2023-02-28"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01",{"$f":"R21","v":"2023-03-01"},"2023-04-01","2023-05-01","2023-06-01","2023-07-01",{"$f":"W21","v":"2023-08-01"},"2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01",{"$f":"AH21","v":"2024-07-01"}]
[null,"Small Service Schedule 101",null,{"$f":"D22*$C$29","v":{"$error":"#REF!"}},{"$f":"E22*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"R22*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"U22*$C$29","v":{"$error":"#REF!"}},{"$f":"V22*$C$29","v":{"$error":"#REF!"}},{"$f":"W22*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AH22*$C$29","v":{"$error":"#REF!"}}]
[null,"Large Service Schedule 111",null,{"$f":"D23*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"R23*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"T23*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"W23*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"AH23*$C$29","v":{"$error":"#REF!"}}]
[null,"Interrupt Service Schedule 131",null,{"$f":"D24*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"T24*$C$29","v":{"$error":"#REF!"}},{"$f":"U24*$C$29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D30:D34)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"SUM(D35:V35)","v":{"$error":"#REF!"}},{"$f":"AJ35+SUM('DSM Balance'!G3:Y3)","v":{"$error":"#REF!"}}]
[]
[]
[null,"WA101",null,null,null,null,null,5070610.5531998109,3170130.372016375,1812771.8926424859,2073438.0843850782,2968240.5660654423,9254547.3455810752,17143580.537804507,26127031.462473758,23816315.706908848,20619339.573812734,16091512.440609436,9894923.2650398463,5199750.4931855202,2945533.4820336467,2102810.0767066558,1903280.0295206353,3089788.9015638665,8963927.3463242725,17127558.92009785,25959555.354015864,23947467.536230512,20801110.457976989,16397869.908349177,10115068.393056097,5223536.6227784296,3184810.3452011878,2109689.4224888245]
[null,"WA111",null,null,null,null,null,2588626.5926134456,2011700.368299183,1683906.7702309897,1742851.7367864409,2322414.8692462118,4924835.8528578607,7252306.4993036538,9372326.1083555091,8698800.5669853613,7582269.9890039274,6291462.544827668,4212964.4749191692,2544237.5025430578,1995612.2801158165,1674561.4721210408,1758920.3538532169,2348799.1103350651,5019484.6365879467,7361177.0294063678,9522983.6002360694,8825720.9970562849,7695576.5673085898,6390946.6901884656,4285273.9040826699,2590001.9825783693,2037652.6902911412,1698383.8758142141]
[null,"WA112",null,null,null,null,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,"WA121 -Discontinued",null,null,null,null,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,null,null,null,null,45178.592041924763,37951.0168820135,36160.191204956966,32707.676267293024,40862.345369953655,86622.768481211868,113518.487262,132358.85107130543,118703.33521448342,106925.79840659398,91577.374449217663,66054.928390878238,46918.899131297963,39004.301097719697,35314.218202961965,31110.611434196442,36840.785682120222,81394.075281387049,109609.01177984949,131031.07356211923,120036.60083139922,110133.3260915823,92090.460079383294,67113.192613570282,47922.486123568306,40123.227880584709,35752.296166013504]
[null,"WA146",null,null,null,null,null,2825661,2478607,2304662,2215419,2255889,2418396,2921288,3395034,3728560,3846569,3428664,3327185,2874605,2555500,2358850,2223456,2315682,2366203,2988871,3335564,3705380,3829526,3438126,3350365,2875023,2538856,2329248]
[null,"WA148",null,null,null,null,null,3408896,3127311,2936673,2793896,2920172,2996541,3546647,3884589,4299759,4338868,3850822,3830134,3428840,3134594,2964348,2806056,2916767,3005728,3551884,3896302,4312962,4350528,3861329,3835979,3436820,3144062,2974418]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H38:H44)-H9","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,0,0,0]

{"sheet":"DSM Balance","index":12,"n_rows":16,"n_cols":37,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["End of July 2022 Balance",{"$f":"M8","v":{"$error":"#REF!"}},"Surcharge/(Rebate)",null,null,null,null,null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M1+1","v":2023},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y1+1","v":2024}]
["Aug 2022 - July 2024 Expenditure Budget",{"$f":"SUM(N4:AK4)","v":14417018.180712625},null,null,null,"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","End November","End December","End January","End February","End March","End April","End May","End June","End July"]
["Total Projected DSM Balance + Expenditures",{"$f":"B1+B2","v":{"$error":"#REF!"}},null,null,"Expected gas tariff rider revenue",null,null,null,null,null,{"$f":"-'Revenue - current rates'!H35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!I35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!J35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!K35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!L35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!M35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!N35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!O35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!P35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!Q35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!R35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!S35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!T35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!U35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!V35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!W35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!X35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!Y35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!Z35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AA35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AB35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AC35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AD35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AE35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AF35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AG35","v":{"$error":"#REF!"}},{"$f":"-'Revenue - current rates'!AH35","v":{"$error":"#REF!"}}]
[null,null,null,null,"Expected DSM cash expenditures",null,null,null,null,null,484214.82260583341,471091.15260583343,454553.10260583338,647281.9526058333,572621.89260583313,383058.23260583333,615456.64260583336,854927.39260583313,609493.06760583341,477237.08760583337,840961.73760583322,440910.80048400839,549061.11048400844,535937.4404840084,519399.39048400836,712128.24048400833,637468.18048400816,447904.5204840083,680302.93048400828,919773.68048400804,609539.6904840084,477283.71048400836,840961.73760583322,440910.80048400839,549061.11048400844,{"$f":"X4","v":535937.4404840084},{"$f":"Y4","v":519399.39048400836}]
["Net Revenue Projected to be Recovered ",{"$f":"SUM(N3:AK3)","v":{"$error":"#REF!"}},"Aug 2022 - July 2024",null,"Accounting Adjustment"]
[null,null,null,null,"Net change in balance",null,null,null,null,null,{"$f":"K3+K4","v":{"$error":"#REF!"}},{"$f":"L3+L4","v":{"$error":"#REF!"}},{"$f":"M3+M4","v":{"$error":"#REF!"}},{"$f":"N3+N4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Z3+Z4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Total Projected DSM Balance (July 2024)",{"$f":"B3+B5","v":{"$error":"#REF!"}},"Underfunded (Surcharge)"]
[null,null,null,null,"Gas Tariff rider balance",null,null,null,null,1303878.4099999999,{"$f":"K6+J8","v":{"$error":"#REF!"}},{"$f":"L6+K8","v":{"$error":"#REF!"}},{"$f":"M6+L8","v":{"$error":"#REF!"}},{"$f":"N6+M8","v":{"$error":"#REF!"}},{"$f":"O6+N8","v":{"$error":"#REF!"}},{"$f":"P6+O8","v":{"$error":"#REF!"}},{"$f":"Q6+P8","v":{"$error":"#REF!"}},{"$f":"R6+Q8","v":{"$error":"#REF!"}},{"$f":"S6+R8","v":{"$error":"#REF!"}},{"$f":"T6+S8","v":{"$error":"#REF!"}},{"$f":"U6+T8","v":{"$error":"#REF!"}},{"$f":"V6+U8","v":{"$error":"#REF!"}},{"$f":"W6+V8","v":{"$error":"#REF!"}},{"$f":"X6+W8","v":{"$error":"#REF!"}},{"$f":"Y6+X8","v":{"$error":"#REF!"}},{"$f":"Z6+Y8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
["August 2022 - July 2024"]
["DSM Revenue",{"$f":"SUM(N3:Y3)","v":{"$error":"#REF!"}},null,null,"2015 Washington gas DSM budget ",null,"CY 2015 expected expenditures (From DSM Business Plan)"]
["DSM Expense",{"$f":"SUM(N4:Y4)","v":7046346.7477827007},null,null,"2016 Washington gas DSM budget ",null,"CY 2016 expected expenditures"]
[null,{"$f":"B13+B14","v":{"$error":"#REF!"}},null,null,"2017 Washington gas DSM budget ",null,"CY 2016 expected expenditures + 2%"]
[null,null,null,null,"2018 Washington gas DSM budget ",null,"CY 2017 expected expenditures + 2%"]

{"sheet":"Base Revenue","index":13,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,11,2,12]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,"This worksheet pulls data from 'Pres & Prop Rev' tab."]
["WASHINGTON NATURAL GAS"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED DECEMBER 31, 2019"]
["(000s of Dollars)"]
["From UG-200901 Compliance Filing, Attachment 2, Page 1"]
[]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Total Billed",null,"Percent ",null,null,null,null,"Present "]
[null,null,null,"Revenue","Final","Revenue","Tariff","Revenue","Final","Increase","Gas",null,"Margin ",null,"Margin"]
["Line","Type of","Schedule","Under Present","General","Under Proposed","Percent","at Present","General","on Billed","Costs",null,"Increase",null,"Revenue"]
["No.","Service","Number","Rates(1)","Change","Rates","Increase","Rates (2)","Change","Revenue"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(i)","(j)"]
[]
[1,"General Service","101/102",79468.690430000017,7344.9412234357942,86813.631653435805,{"$f":"E14/D14","v":9.2425597851088087E-2},122717.83895999999,{"$f":"E14","v":7344.9412234357942},{"$f":"(+E14)/H14","v":5.9852269936320222E-2},{"$f":"('[21]Pres & Prop Rev'!D46*[21]Exh3!E15)/1000","v":46969.155635490002},null,{"$f":"E14/(D14-K14)","v":0.22600142647815805},null,{"$f":"D14-K14","v":32499.534794510015},{"$f":"I14/H14","v":5.9852269936320222E-2},{"$f":"#REF!/H14","v":{"$error":"#REF!"}}]
[2,"Large General Service","111/112",20145.480680000004,393.4157572360009,20538.896437236006,1.9528735178137274E-2,38590.734510000002,{"$f":"E15","v":393.4157572360009},1.0194565152266154E-2,{"$f":"('[21]Pres & Prop Rev'!E46*[21]Exh3!E19)/1000","v":18143.079048119998},null,0.19647195196631581,null,2002.4016318800059,1.0194565152266154E-2,{"$f":"#REF!/H15","v":{"$error":"#REF!"}}]
[3,"Interruptible Service ","131/132",216.98343000000003,8.574823885027774,225.5582538850278,3.9518335040734549E-2,472.20610999999997,8.574823885027774,1.8159070167532935E-2,{"$f":"('[21]Pres & Prop Rev'!G46*[21]Exh3!E40)/1000","v":375.37861080000005},null,-5.4135636208874939E-2,null,-158.39518080000002,1.8159070167532935E-2,{"$f":"#REF!/H16","v":{"$error":"#REF!"}}]
[4,"Transportation Service","146",3580.8606365599999,330.96318515548586,3911.8238217154858,9.2425597851088087E-2,3643.6783265599997,330.96318515548586,9.0832163405584851E-2,{"$f":"('[21]Pres & Prop Rev'!H46*[21]Exh3!E49)/1000","v":17.124913119999999},null,9.2869733010396749E-2,null,3563.7357234399997,9.0832163405584851E-2,{"$f":"#REF!/H17","v":{"$error":"#REF!"}}]
[5,"Special Contracts","148",1760.8636899999999,0,1760.8636899999999,0,1760.8636899999999,0,0,null,null,0,null,1760.8636899999999,0,{"$f":"#REF!/H18","v":{"$error":"#REF!"}}]
[6,"Total",null,{"$f":"SUM(D14:D18)-0.2","v":105172.67886656002},{"$f":"SUM(E14:E18)","v":8077.8949897123084},{"$f":"SUM(F14:F18)","v":113250.77385627232},7.6806021076645789E-2,{"$f":"SUM(H14:H18)+1","v":167186.32159656001},{"$f":"SUM(I14:I18)-0.2","v":8077.6949897123086},4.8316721802189093E-2,{"$f":"SUM(K14:K18)","v":65504.738207530005},null,0.20363787117528259,null,39667.940659030013,4.831552553207507E-2,{"$f":"#REF!/H19","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(I19-SUM(I14:I18),-1)","v":0},{"$f":"ROUND(J19-SUM(J14:J18),0)","v":0}]
[]
[null,null,null,{"$f":"IF(Base1_Billing2=2,\"Exhibit won't work until Base1_Billing2 range set to '1'\",\"\")","v":""}]
[]
["(1) Includes Purchase Adjustment Schedule 150; excludes all other rate adjustments."]
[]
["(2) Includes Schedule 150 (Purchase Gas Cost Adjustment), Schedule 155 (Gas Rate Adjustment), "]
[" Schedule 191 (DSM Adjustment) and Schedule 192 (LIRAP Adjustment)."]
[]
[null,null,null,{"$f":"SUM(ROUND(D14:D18,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(ROUND(E14:E18,0))","v":8078},{"$f":"SUM(ROUND(F14:F18,0))","v":113252},null,{"$f":"SUM(ROUND(H14:H18,0))","v":167186},null,{"$f":"SUM(ROUND(J14:J18,0))","v":0}]
[null,null,null,{"$f":"ROUND(D19,0)-D29","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E19,0)-E29","v":0},{"$f":"ROUND(F19,0)-F29","v":-1},null,{"$f":"ROUND(H19,0)-H29","v":0},null,{"$f":"ROUND(J19,0)-J29","v":0}]
[]
[]
[null,null,null,null,null,null,"Rate Sch.","Therms","Sch 155 Rate","Sch 155 Rate"]
[null,null,null,null,null,null,112,0,-1.451E-2,-1.3999999999999999E-4,"No 112's in test year"]
[null,null,null,null,null,null,122,{"$f":"'[21]Rev Runs CY'!O40","v":665507},5.3899999999999998E-3,-1.3999999999999999E-4]

{"sheet":"RCF","index":14,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["AVISTA UTILITIES"]
["REVENUE CONVERSION FACTOR"]
["WASHINGTON NATURAL GAS"]
["TWELVE MONTHS ENDED DECEMBER 31, 2019"]
[]
[]
["From UG-200901"]
[]
[]
["Description",null,"Factor"]
[]
["Revenues",null,1]
[]
["Expense:"]
["  Uncollectibles  ",null,3.326E-3]
[]
["  Commission Fees ",null,2E-3]
[]
["  Washington Excise Tax  ",null,3.8392000000000003E-2]
[]
["    Total Expense",null,{"$f":"C15+C17+C19","v":4.3718E-2}]
[]
["Net Operating Income Before FIT",null,{"$f":"C12-C21","v":0.95628199999999997}]
[]
["  Federal Income Tax @ 21%",null,0.20081921999999999]
[]
["REVENUE CONVERSION FACTOR",null,{"$f":"C23-C25","v":0.75546278}]