{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["WA Gas - Sched 191","Revenue - current rates","DSM Balance","Base Revenue","RCF"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":5,"comments":1,"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 191","index":0,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[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":197762235.91501716},{"$f":"SUM('Revenue - current rates'!K4:V4)","v":138237023.03460655},{"$f":"SUM('Revenue - current rates'!K5:V5)","v":58614643.897065707},{"$f":"SUM('Revenue - current rates'!K6:V6)","v":910568.98334491695},null,null,null,null,"August 2022 - July 2024"]
[]
[null,"Present DSM Rates",null,3.0280000000000001E-2,1.626E-2,1.132E-2]
[]
[null,"Present Gross DSM Revenue",{"$f":"SUM(D11:H11)","v":5149198.8081456395},{"$f":"D7*D9","v":4185817.0574878864},{"$f":"E7*E9","v":953074.10976628843},{"$f":"F7*F9","v":10307.64089146446}]
[]
["UG-200901","Base Revenue",{"$f":"SUM(D13:H13)","v":107579000},{"$f":"ROUND('Base Revenue'!F14*1000,-3)","v":86814000},{"$f":"ROUND('Base Revenue'!F15*1000,-3)","v":20539000},{"$f":"ROUND('Base Revenue'!F16*1000,-3)","v":226000}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:G15)","v":1},{"$f":"D13/$C$13","v":0.80697905725095043},{"$f":"E13/$C$13","v":0.1909201609979643},{"$f":"F13/$C$13","v":2.100781751085249E-3}]
[]
[null,"Revenue Requirement",8725039.850123236]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:G19)","v":8725039.850123236},{"$f":"$C$17*D15","v":7040924.432729423},{"$f":"$C$17*E15","v":1665786.0128991825},{"$f":"$C$17*F15","v":18329.404494630471}]
[]
[null,"DSM Revenue Increase <Decrease>",{"$f":"SUM(D21:G21)","v":3575841.0419775969},{"$f":"D19-D11","v":2855107.3752415366},{"$f":"E19-E11","v":712711.90313289408},8021.7636031660113]
[]
[null,"Proposed DSM Rates",null,{"$f":"D19/D7","v":5.0933709929262459E-2},{"$f":"E19/E7","v":2.8419280612273293E-2},{"$f":"F19/F7","v":2.0129616569299971E-2}]
[]
[null,"Percentage Increase <Decrease>",null,{"$f":"D19/D11-1","v":0.68209081668634286},{"$f":"E19/E11-1","v":0.74780323568716422},0.77823467926678203]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:H27)","v":182207000},136764000,40128000,536000,3256000,1523000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:H29)","v":185782841.04197761},{"$f":"D27+D21","v":139619107.37524155},{"$f":"E27+E21","v":40840711.903132893},544021.76360316598,3256000,1523000]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":1.9625157331922605E-2},{"$f":"D29/D27-1","v":2.0876161674428628E-2},{"$f":"E29/E27-1","v":1.7760962498327704E-2},{"$f":"F29/F27-1","v":1.4965976871578412E-2},{"$f":"G29/G27-1","v":0},0]
[]
[]
[null,"Present DSM Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":2.8260159094577263E-2}]
[]
[]
["UG-200901","Revenue Conversion Factor",{"$f":"RCF!C23","v":0.95628199999999997}]
[]
[null,"Proposed Net DSM Revenue",{"$f":"SUM(D39:H39)","v":8343598.5579555472},{"$f":"D19*$C$37","v":6733109.2983793579},{"$f":"E19*$C$37","v":1592961.1799872559},17528.079588934215,0,0]
[]
[null,"Proposed DSM Revenue as a % of Billed Revenue",{"$f":"C19/C27","v":4.7885316426499729E-2}]
[]
[null,null,"Present","Proposed","$ Inc/(Dec)","% Inc/(Dec)"]
[null,"Average Monthly Bill @ 67 Therms",{"$f":"C50+(C51*C49)","v":64.856070000000003},{"$f":"C50+(C51*(C49+(ROUND(D23,5)-D9)))","v":66.239620000000002},{"$f":"D44-C44","v":1.3835499999999996},{"$f":"E44/C44","v":2.1332621603498324E-2}]
[]
[]
[null,"Change in Schedule 191 Rate",null,{"$f":"D23-D9","v":2.0653709929262458E-2}]
[]
[null,"Present Rate (first 70 therms)",0.82621]
[null,"Basic Charge",9.5]
[null,"Average Customer Usage",67]

{"sheet":"Revenue - current rates","index":1,"n_rows":47,"n_cols":38,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Forecasted Usage",null,null,"2022-01-01","2022-02-01","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 191'!C7","v":197762235.91501716}]
[]
["DSM Rates"]
[null,"Small Service Schedule 101",null,{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$9","v":3.0280000000000001E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":5.0933709929262459E-2}]
[null,"Large Service Schedule 111",null,{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$9","v":1.626E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.8419280612273293E-2}]
[null,"Interrupt Service Schedule 131",null,{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":2.0129616569299971E-2}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total"]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D3","v":"2022-01-01"},"2022-02-01","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":0},0,0,0,153538.08755089028,95991.547664655838,54890.732909214479,105607.89394635519,151183.50399224705,471368.43002645235,873186.158261484,1330746.6418223523,1213053.3157994326,1050219.4607855401,819600.42697311926,503985.15135385015,264842.58332445071,150026.94796083219,107103.91848330694,96941.112937762126,157374.41165490844,456566.07528466388,872370.11783261562,1322216.4622940763,1219733.3650307944,1059477.7262731479,835204.3493696386,515197.9594465702,266054.09914947581,162214.20630219154,107454.30908587902]
[null,"Large Service Schedule 111",null,{"$f":"D5*D14","v":0},0,0,0,42091.068395894625,32710.247988544714,27380.324083955893,49530.592573321737,66001.359867224077,139960.29207175181,206105.33348992391,266354.76566309051,247213.65430335901,215482.65849552094,178798.83952306453,119729.41962226648,72305.399529040544,56713.86538190992,47589.832378709318,49987.251110793608,66751.181018470073,142650.14241618747,209199.35563531989,270636.34320118546,250820.64162097499,218702.74993957765,181626.10736654524,121784.40158057731,73605.993129238836,57908.623595737547,48266.847954124467]
[null,"Interrupt Service Schedule 131",null,{"$f":"D6*D15","v":0},0,0,0,511.42166191458836,429.60551110439286,409.33336444011286,658.39298213340112,822.54334441947708,1743.6831156980377,2285.083622111023,2664.332921618457,2389.4526233646343,2152.3753232910026,1843.4174340859597,1329.6603810209456,944.45944936668946,785.1416256506235,710.86167187021783,626.24467940685383,741.59088989283634,1638.4315264270579,2206.3873796682542,2637.6052694691984,2416.2907490181806,2216.9416257252319,1853.7456510884115,1350.9628340527447,964.66127071502854,807.66519275881649,719.68001329390529]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D22:D26)","v":0},0,0,0,196140.5776086995,129131.40116430495,82680.390357610493,155796.87950181033,218007.40720389059,613072.40521390224,1081576.575373519,1599765.7404070611,1462656.4227261564,1267854.4946043519,1000242.6839302698,625044.23135713756,338092.44230285793,207525.95496839273,155404.61253388648,147554.60872796259,224867.18356327136,600854.64922727842,1083775.8608476038,1595490.4107647308,1472970.2974007875,1280397.4178384508,1018684.2023872723,638333.32386120025,340624.75354942965,220930.49509068791,156440.83705329738]
[]
["Net DSM Revenue",null,{"$f":"RCF!C23","v":0.95628199999999997},{"$f":"D21","v":"2022-01-01"},{"$f":"E21","v":"2022-02-01"},"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":0},{"$f":"E22*$C$29","v":0},0,0,146825.70943934045,91794.989183852405,52491.019847889438,100990.92803880843,144574.06356471399,450761.14500255592,835012.20579460845,1272569.0601351627,1160021.0509393129,1004305.9663989177,{"$f":"R22*$C$29","v":783769.13550670841},481951.92850696249,253264.19526667235,{"$f":"U22*$C$29","v":143468.06984988053},{"$f":"V22*$C$29","v":102421.54937505373},{"$f":"W22*$C$29","v":92703.041362349031},150494.31712617914,436605.91960536892,834231.84102120926,1264411.8029955039,1166409.0617783782,1013159.4790359384,798690.88562389673,492674.53505548503,254422.74604285901,155122.52563107232,{"$f":"AH22*$C$29","v":102756.62160126257}]
[null,"Large Service Schedule 111",null,{"$f":"D23*$C$29","v":0},0,0,0,40250.931067762904,31280.221366981514,26183.31107565351,47365.214127201252,63115.912416548774,133841.50802295897,197094.82052041142,254710.26801783152,236405.96776452474,206062.18763141375,{"$f":"R23*$C$29","v":170982.11185679518},114495.08885522022,{"$f":"T23*$C$29","v":69144.352072429945},54234.448615143578,45509.300086776901,{"$f":"W23*$C$29","v":47801.908466731933},63832.952886704596,136413.7634900366,200053.57820565498,258804.66354911603,239855.2648105892,209141.5031177192,173685.7772046946,116460.23111227763,70388.08632161477,55376.974389379087,{"$f":"AH23*$C$29","v":46156.717895266054}]
[null,"Interrupt Service Schedule 131",null,{"$f":"D24*$C$29","v":0},0,0,0,489.06332969900637,410.82401736993097,391.43812841352002,629.60935774049301,786.58339448814638,1667.4527772459508,2185.184336319573,2547.853614951141,2284.9905335763792,2058.2777789073666,1762.8269107025897,1271.5302884834718,{"$f":"T24*$C$29","v":903.16957115927653},{"$f":"U24*$C$29","v":750.81680406042949},679.78422129939565,598.866514512545,709.17001936850124,1566.8025769547196,2109.9285362039172,2522.2944422985438,2310.6553500526038,2120.0213717317761,1772.7035987141282,1291.9014408736268,922.48820928190889,772.35568586178647,688.21704247272237]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D30:D34)","v":0},0,0,0,187565.70383680236,123486.03456820385,79065.769051956464,148985.75152375019,208476.55937575089,586270.10580276081,1034292.2106513395,1529827.1817679454,1398712.009237414,1212426.4318092389,956514.07427420618,597718.54765066621,323311.7169102616,198453.33526908452,148610.63368313003,141103.8163435935,215036.44003225223,574586.48567236029,1036395.3477630682,1525738.7609869186,1408574.9819390199,1224421.0035253894,974149.36642730539,610426.66760863631,325733.32057375571,211271.85570631319,149601.55653900132,null,{"$f":"SUM(D35:V35)","v":8733716.065412512},{"$f":"AJ35+SUM('DSM Balance'!G3:Y3)","v":0}]
[]
[]
[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":2,"n_rows":16,"n_cols":37,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["End of July 2022 Balance",{"$f":"M8","v":2323619.9803605373},"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":16740638.161073163},null,null,"Expected gas tariff rider revenue",null,null,null,null,null,{"$f":"-'Revenue - current rates'!H35","v":-187565.70383680236},{"$f":"-'Revenue - current rates'!I35","v":-123486.03456820385},{"$f":"-'Revenue - current rates'!J35","v":-79065.769051956464},{"$f":"-'Revenue - current rates'!K35","v":-148985.75152375019},{"$f":"-'Revenue - current rates'!L35","v":-208476.55937575089},{"$f":"-'Revenue - current rates'!M35","v":-586270.10580276081},{"$f":"-'Revenue - current rates'!N35","v":-1034292.2106513395},{"$f":"-'Revenue - current rates'!O35","v":-1529827.1817679454},{"$f":"-'Revenue - current rates'!P35","v":-1398712.009237414},{"$f":"-'Revenue - current rates'!Q35","v":-1212426.4318092389},{"$f":"-'Revenue - current rates'!R35","v":-956514.07427420618},{"$f":"-'Revenue - current rates'!S35","v":-597718.54765066621},{"$f":"-'Revenue - current rates'!T35","v":-323311.7169102616},{"$f":"-'Revenue - current rates'!U35","v":-198453.33526908452},{"$f":"-'Revenue - current rates'!V35","v":-148610.63368313003},{"$f":"-'Revenue - current rates'!W35","v":-141103.8163435935},{"$f":"-'Revenue - current rates'!X35","v":-215036.44003225223},{"$f":"-'Revenue - current rates'!Y35","v":-574586.48567236029},{"$f":"-'Revenue - current rates'!Z35","v":-1036395.3477630682},{"$f":"-'Revenue - current rates'!AA35","v":-1525738.7609869186},{"$f":"-'Revenue - current rates'!AB35","v":-1408574.9819390199},{"$f":"-'Revenue - current rates'!AC35","v":-1224421.0035253894},{"$f":"-'Revenue - current rates'!AD35","v":-974149.36642730539},{"$f":"-'Revenue - current rates'!AE35","v":-610426.66760863631},{"$f":"-'Revenue - current rates'!AF35","v":-325733.32057375571},{"$f":"-'Revenue - current rates'!AG35","v":-211271.85570631319},{"$f":"-'Revenue - current rates'!AH35","v":-149601.55653900132}]
[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":-16740638.161073165},"Aug 2022 - July 2024",null,"Accounting Adjustment"]
[null,null,null,null,"Net change in balance",null,null,null,null,null,{"$f":"K3+K4","v":296649.11876903102},{"$f":"L3+L4","v":347605.11803762958},{"$f":"M3+M4","v":375487.3335538769},{"$f":"N3+N4","v":498296.20108208311},364145.33323008224,-203211.87319692748,-418835.56804550614,-674899.78916211228,-789218.94163158059,-735189.34420340555,-115552.33666837297,-156807.74716665782,225749.39357374684,337484.10521492385,370788.75680087833,{"$f":"Z3+Z4","v":571024.42414041481},422431.74045175593,-126681.96518835198,-356092.41727905988,-605965.08050291054,-799035.29145501147,-747137.29304138105,-133187.62882147217,-169515.86712462793,223327.78991025273,324665.58477769524,369797.83394500706]
["Total Projected DSM Balance (July 2024)",{"$f":"B3+B5","v":0},"Underfunded (Surcharge)"]
[null,null,null,null,"Gas Tariff rider balance",null,null,null,null,1303878.4099999999,{"$f":"K6+J8","v":1600527.5287690309},{"$f":"L6+K8","v":1948132.6468066606},{"$f":"M6+L8","v":2323619.9803605373},{"$f":"N6+M8","v":2821916.1814426202},{"$f":"O6+N8","v":3186061.5146727026},{"$f":"P6+O8","v":2982849.6414757753},{"$f":"Q6+P8","v":2564014.073430269},{"$f":"R6+Q8","v":1889114.2842681566},{"$f":"S6+R8","v":1099895.3426365759},{"$f":"T6+S8","v":364705.99843317037},{"$f":"U6+T8","v":249153.66176479741},{"$f":"V6+U8","v":92345.914598139585},{"$f":"W6+V8","v":318095.30817188643},{"$f":"X6+W8","v":655579.41338681034},{"$f":"Y6+X8","v":1026368.1701876887},{"$f":"Z6+Y8","v":1597392.5943281036},2019824.3347798595,1893142.3695915076,1537049.9523124476,931084.87180953706,132049.58035452559,-615087.71268685546,-748275.34150832763,-917791.20863295556,-694463.41872270289,-369797.83394500765,-5.8207660913467407E-10]
[]
[]
[]
["August 2022 - July 2024"]
["DSM Revenue",{"$f":"SUM(N3:Y3)","v":-8343598.5579555482},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":-1297251.8101728475},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":3,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"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":"('[3]Pres & Prop Rev'!D46*[3]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":"('[3]Pres & Prop Rev'!E46*[3]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":"('[3]Pres & Prop Rev'!G46*[3]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":"('[3]Pres & Prop Rev'!H46*[3]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":"'[3]Rev Runs CY'!O40","v":665507},5.3899999999999998E-3,-1.3999999999999999E-4]

{"sheet":"RCF","index":4,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"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}]