{"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":4,"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":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,""]
[]
[null,null," ","GEN SERVICE","LRG GEN SVC","EX LRG GEN SVC","INTERRUPTIBLE","TRANSPORT","TRANSPORT"]
["Source",null,"TOTAL","SCHEDULE 101&102","SCH. 111,112&116","SCH. 121,122&126","SCH. 131&132","SCHEDULE 146","SCHEDULE 148"]
[]
["Forecast","Total Annual Therms",{"$f":"SUM(D7:I7)","v":190573814.07921055},{"$f":"SUM('Revenue - current rates'!K4:V4)","v":129254349.71035127},{"$f":"SUM('Revenue - current rates'!K5:V5)","v":55626395.473514929},{"$f":"SUM('Revenue - current rates'!K6:V6)","v":4762542.9033457879},{"$f":"SUM('Revenue - current rates'!K7:V7)","v":930525.99199854792},null,null,null,null,"August 2019 - July 2020"]
[]
[null,"Present DSM Rates",null,3.0280000000000001E-2,1.626E-2,1.2760000000000001E-2,1.132E-2]
[]
[null,"Present Gross DSM Revenue",{"$f":"SUM(D11:I11)","v":4889610.5013049049},{"$f":"D7*D9","v":3913821.7092294367},{"$f":"E7*E9","v":904485.19039935281},{"$f":"F7*F9","v":60770.047446692253},{"$f":"G7*G9","v":10533.554229423562}]
[]
["UG-170486","Base Revenue",{"$f":"SUM(D13:I13)","v":82226000},{"$f":"ROUND('Base Revenue'!F14*1000,-3)","v":65960000},{"$f":"ROUND('Base Revenue'!F15*1000,-3)","v":15082000},{"$f":"ROUND('Base Revenue'!F16*1000,-3)","v":999000},{"$f":"ROUND('Base Revenue'!F17*1000,-3)","v":185000}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:H15)","v":1.0000000000000002},{"$f":"D13/$C$13","v":0.80217935932673368},{"$f":"E13/$C$13","v":0.18342130226449055},{"$f":"F13/$C$13","v":1.2149441782404593E-2},{"$f":"G13/$C$13","v":2.2498966263712209E-3}]
[]
[null,"Revenue Requirement",0]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:H19)","v":0},{"$f":"$C$17*D15","v":0},{"$f":"$C$17*E15","v":0},{"$f":"$C$17*F15","v":0},{"$f":"$C$17*G15","v":0}]
[]
[null,"DSM Revenue Increase <Decrease>",{"$f":"SUM(D21:H21)","v":-4889610.5013049049},{"$f":"D19-D11","v":-3913821.7092294367},{"$f":"E19-E11","v":-904485.19039935281},-60770.047446692253,-10533.554229423562]
[]
[null,"Proposed DSM Rates",null,{"$f":"D19/D7","v":0},{"$f":"E19/E7","v":0},{"$f":"F19/F7","v":0},{"$f":"G19/G7","v":0}]
[]
[null,"Percentage Increase <Decrease>",null,{"$f":"D19/D11-1","v":-1},{"$f":"E19/E11-1","v":-1},-1,-1]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:I27)","v":127834000},95820000,25964000,718000,456000,3156000,1720000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:I29)","v":122944389.49869509},{"$f":"D27+D21","v":91906178.290770561},{"$f":"E27+E21","v":25059514.809600648},657229.95255330775,445466.44577057642,3156000,1720000]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":-3.8249687104408125E-2},{"$f":"D29/D27-1","v":-4.0845561565742483E-2},{"$f":"E29/E27-1","v":-3.4836126575233162E-2},{"$f":"F29/F27-1","v":-8.4637949090100584E-2},{"$f":"G29/G27-1","v":-2.3099899625928955E-2},0,0]
[]
[]
[null,"Present DSM Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":3.8249687104408098E-2}]
[]
[]
["UG-170486","Revenue Conversion Factor",{"$f":"RCF!C25","v":0.95353500000000002}]
[]
[null,"Proposed Net DSM Revenue",{"$f":"SUM(D39:I39)","v":0},{"$f":"D19*$C$37","v":0},{"$f":"E19*$C$37","v":0},0,0,0,0]
[]
[null,"Proposed DSM Revenue as a % of Billed Revenue",{"$f":"C19/C27","v":0}]
[]
[null,null,"Present","Proposed"]
[null,"Average Monthly Bill @ 66 Therms",{"$f":"9.5+(66*0.55907)","v":46.398619999999994},{"$f":"9.5+(66*(0.55907+(ROUND(D23,5)-D9)))","v":44.40014},{"$f":"D44-C44","v":-1.9984799999999936},{"$f":"E44/C44","v":-4.3071970674989773E-2}]
[]
[]
[null,"Change in Schedule 191 Rate",null,{"$f":"D23-D9","v":-3.0280000000000001E-2}]

{"sheet":"Revenue - current rates","index":1,"n_rows":51,"n_cols":38,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Forecasted Usage",null,null,"2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01",null,"2019-2020","2020-2021"]
[null,"Small Service Schedule 101",null,null,null,null,{"$f":"G42","v":9497249.38565493},{"$f":"H42","v":5057421.2988135302},2861262.5041613695,2193485.5075411289,2490800.6721167457,2537629.1803711448,8083359.7827961203,15735548.779149588,22898409.369904723,23385530.387359805,18608677.815918069,15440273.500018638,9571568.850759903,5127349.9933950882,2872177.448569085,2503023.9299923512,2084881.7652356273,2984815.0020103883,7807394.3990552668,15900610.890801232,23326612.342601817,23572499.046756923,18452080.826143943,15630325.724624043,9717079.0659439471,5233677.7966828514,2960083.572531437,2421980.0239204071,null,{"$f":"SUM(K4:V4)","v":129254349.71035127},{"$f":"SUM(W4:AH4)","v":130092040.45630787}]
[null,"Large Service Schedule 111",null,null,null,null,{"$f":"G43+G44","v":3800204.4344416708},{"$f":"H43+H44","v":2304488.1312518851},1563793.0880789938,1652903.8288640622,1404917.1421370988,2196613.6781878844,4408858.5714469543,7087233.9602375301,9260136.0511023272,8750436.1131530385,7316604.8899631975,5958901.7369157067,3906277.7938024472,2323544.6060872218,1583456.1387518561,1429414.7917296663,1769106.2732588651,1856993.7191873128,4823516.9712495934,7282355.7666467652,9344688.0971711278,9129686.003126746,7128074.6812279616,6139497.9991393574,3984667.8257863405,2329556.012800449,1556513.7701044211,1532156.729308177,null,{"$f":"SUM(K5:V5)","v":55626395.473514929},{"$f":"SUM(W5:AH5)","v":56876813.849007115}]
[null,"Extra Large Service Schedule 121",null,null,null,null,{"$f":"G45","v":313430.15285417554},{"$f":"H45","v":252835.90419457926},211227.15637691299,281350.79628296639,238625.7694304933,327760.47391709295,494685.72381366143,596974.56379795086,567151.68341207656,558660.28597495391,518132.19174880744,424889.04190052097,323237.50948291621,251045.15866068864,222293.8854430732,239086.61576355246,309846.81353137415,281423.51841503108,541395.77772003156,606780.33889551065,564840.17374783487,571336.08152191958,498945.17327462236,429543.02602678823,326846.62489302777,249538.75512639218,218524.84855672822,260618.48662193544,null,4762542.9033457879,4859639.6183311967]
[null,"Interrupt Service Schedule 131",null,null,null,null,{"$f":"G46","v":69932.360650378381},51173.851866115787,38319.32726484086,44255.702001881873,24592.75146685561,35201.434761008131,70611.147898500683,113373.124671743,134031.65063612064,131860.52689029608,119124.76195874538,99359.946716736653,72224.526485283539,52161.409051189483,39751.755997898545,38232.955464170278,30743.958231800363,29171.320504393123,74387.986725765935,113194.67439941452,131551.24139362737,134228.37975061344,113859.52418141914,100798.38156233754,72946.782612984127,52087.309216876864,39121.709314143482,41679.086493376613,null,930525.99199854792,933770.35438675259]
[null,"Transport Service Schedule 146",null,null,null,null,3565969,3017941,2601293,2341923,2192880,2233771,2405362,3117039,3480828,4028278,4280063,3635087,3599254,3067921,2674184,2403810,2234943,2274469,2427370,3145431,3516528,4084411,4300496,3654029,3629893,3089320,2704718,2425650]
[null,"Special Contract Transport",null,null,null,null,4424842,4047057,3733720,3592927,3413044,3538051,3615845,4144387,4520970,4908767,4998627,4469128,4468138,4086062,3772247,3629612,3449305,3573089,3650351,4177983,4553109,4940561,5029910,4499804,4498319,4115744,3801482,3658653]
["Total Forecasted Usage",null,null,{"$f":"SUM(D4:D9)","v":0},0,0,21671627.333601154,{"$f":"SUM(H4:H9)","v":14730917.186126111},11009615.075882118,10106845.834690038,9764860.3351511937,10869026.767237131,19078722.225955237,30794556.42785681,40861526.755055249,41763532.313378096,35841229.659588821,30027639.225551601,21940700.680530548,14908084.167194188,11164110.228761911,10243180.29294974,9878826.8102576658,10999961.560117126,19324416.134750657,31226355.670742922,41437328.854914404,42432721.511156201,35523366.204827942,30453998.131352525,22229752.299236301,15069923.873826571,11280443.900506729,10340737.326343898,null,{"$f":"SUM(AJ4:AJ9)","v":190573814.07921055},{"$f":"SUM(AK4:AK9)","v":192762264.27803293},{"$f":"(AK10-AJ10)/AJ10","v":1.1483477986712102E-2}]
[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":190573814.07921055}]
[]
["DSM Rates"]
[null,"Small Service Schedule 101",null,{"$f":"'WA Gas - Sched 191'!D9","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},3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2,3.0280000000000001E-2]
[null,"Large Service Schedule 111",null,{"$f":"'WA Gas - Sched 191'!E9","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},1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2,1.626E-2]
[null,"Extra Large Service Schedule 121",null,{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},{"$f":"'WA Gas - Sched 191'!$F$9","v":1.2760000000000001E-2},1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2,1.2760000000000001E-2]
[null,"Interrupt Service Schedule 131",null,{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},{"$f":"'WA Gas - Sched 191'!$G$9","v":1.132E-2},1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2,1.132E-2]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total"]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D3","v":"2019-01-01"},{"$f":"E3","v":"2019-02-01"},"2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01",{"$f":"R3","v":"2020-03-01"},"2020-04-01","2020-05-01","2020-06-01","2020-07-01",{"$f":"W3","v":"2020-08-01"},"2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01",{"$f":"AH3","v":"2021-07-01"}]
[null,"Small Service Schedule 101",null,{"$f":"D4*D14","v":0},0,0,287576.71139763127,153138.7169280737,86639.028626006271,66418.741168345383,75421.444351695071,76839.411581638269,244764.13422306653,476472.41703264957,693363.835720715,708113.86012925499,563470.7642659992,{"$f":"R4*R14","v":467531.48158056434},289827.10480100987,155256.15780000328,{"$f":"U4*U14","v":86969.533142671891},75791.564600168393,{"$f":"W4*W14","v":63130.219851334798},90380.19826087456,236407.9024033935,481470.49777346133,706329.821733983,713775.2711357997,558729.00741563865,473286.26294161606,294233.15411678271,158475.76368355675,89631.330576251916,{"$f":"AH4*AH14","v":73337.555124309933}]
[null,"Large Service Schedule 111",null,{"$f":"D5*D15","v":0},0,0,61791.324104021565,37470.977014155651,25427.275612164442,26876.216257329652,22843.952731149227,35716.938407335001,71688.040371727475,115238.42419346224,150569.81219092384,142282.09119986842,118967.99551080159,{"$f":"R5*R15","v":96891.742242249398},63516.07692722779,{"$f":"T5*T15","v":37780.835294978227},25746.99681610518,23242.284513524373,{"$f":"W5*W15","v":28765.668003189148},30194.717873985705,78430.385952518394,118411.1047656764,151944.62846000254,148448.69441084089,115902.49431676665,99828.237466005958,64790.698847285894,37878.580768135304,25308.913901897886,{"$f":"AH5*AH15","v":24912.868418550959}]
[null,"Extra Large Service Schedule 121",null,{"$f":"D6*D16","v":0},0,0,3999.3687504192799,3226.1861375228314,2695.2585153694099,3590.0361605706512,3044.8648179330944,4182.2236471821061,6312.1898358623203,7617.3954340618529,{"$f":"O6*O16","v":7236.8554803380975},7128.5052490404123,6611.3667667147829,{"$f":"R6*R16","v":5421.5841746506476},4124.5106210020112,3203.3362245103872,2836.469978253614,3050.7452171429295,{"$f":"W6*W16","v":3953.6453406603341},3590.9640949757968,6908.2101237076031,7742.5171243067161,7207.3606170223729,7290.2484002196943,6366.5404109841811,5480.9690121018184,4170.5629336350348,3184.1145154127644,2788.3770675838523,{"$f":"AH6*AH16","v":3325.4918892958963}]
[null,"Interrupt Service Schedule 131",null,{"$f":"D7*D17","v":0},0,0,791.63432256228327,579.2880031244307,433.77478463799855,500.97454666130284,278.38994660480552,398.48024149461207,799.31819421102773,1283.3837712841307,1517.2382852008857,1492.6611643981516,1348.4923053729976,{"$f":"R7*R17","v":1124.7545968334589},817.58163981340965,590.46715045946496,449.98987789621151,432.79705585440757,{"$f":"W7*W17","v":348.02160718398011},330.21934810973016,842.07200973567035,1281.3637142013724,1489.1600525758618,1519.4652587769442,1288.8898137336646,1141.0376792856609,825.75757917898034,589.62834033504612,442.8577494361042,{"$f":"AH7*AH17","v":471.80725910502326}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D24:D29)","v":0},{"$f":"SUM(E24:E29)","v":0},0,354159.03857463441,194415.16808287663,115195.33753817811,97385.968132907001,101588.65184738219,117137.05387764999,323563.68262486736,600611.62043145788,852687.74167717784,859017.11774256208,690398.61884888855,{"$f":"SUM(R24:R29)","v":570969.56259429781},358285.27398905309,196830.79646995137,116002.9898149269,102517.3913866901,{"$f":"SUM(W24:W29)","v":96197.554802368264},124496.0995779458,322588.57048935519,608905.48337764584,866970.97086358385,871033.67920563719,682286.9319571231,579736.50709900935,364020.17347688257,200128.08730743988,118171.47929516976,{"$f":"SUM(AH24:AH29)","v":102047.72269126182}]
[]
["Net DSM Revenue",null,{"$f":"RCF!C25","v":0.95353500000000002},{"$f":"D23","v":"2019-01-01"},{"$f":"E23","v":"2019-02-01"},"2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01",{"$f":"R23","v":"2020-03-01"},"2020-04-01","2020-05-01","2020-06-01","2020-07-01",{"$f":"W23","v":"2020-08-01"},"2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01",{"$f":"AH23","v":"2021-07-01"}]
[null,"Small Service Schedule 101",null,{"$f":"D24*$C$32","v":0},{"$f":"E24*$C$32","v":0},0,274214.45950254035,146023.12644601075,82613.346160898887,63332.594359958217,71916.986939893555,73269.068322497449,233391.16872639174,454333.12617522752,661146.68509395199,675211.34961834922,537289.09520437953,{"$f":"R24*$C$32","v":445807.63128892344},276360.28837643098,148042.18042782613,{"$f":"U24*$C$32","v":82928.493785197643},{"$f":"V24*$C$32","v":72269.90955102157},{"$f":"W24*$C$32","v":60196.874185942528},86180.682348683025,225423.20921821982,459098.97109441744,673510.20656711352,680609.70316247479,532767.66408607096,451295.01673403388,280561.61061074643,151112.18732400029,85466.610801026371,{"$f":"AH24*$C$32","v":69929.925625458869}]
[null,"Large Service Schedule 111",null,{"$f":"D25*$C$32","v":0},0,0,58920.190229528205,35729.888067192907,24245.797250845222,25627.412868932832,21782.50846749638,34057.350864238178,68357.055575855164,109883.87081331301,143573.58586747258,135670.95383226653,113440.14759939219,{"$f":"R25*$C$32","v":92389.667438963283},60564.802412804151,{"$f":"T25*$C$32","v":36025.348782997062},24550.662609044855,22162.331763603463,{"$f":"W25*$C$32","v":27429.071239420966},28791.720307970958,74786.118069234624,112909.13278273925,144884.52129860854,141551.02582504117,110517.08491833809,95189.718412147995,61780.199025346759,36118.552512743896,24132.9352174462,{"$f":"AH25*$C$32","v":23755.291987482989}]
[null,"Extra Large Service Schedule 121",null,{"$f":"D26*$C$32","v":0},0,0,3813.5380814310483,3076.2813986428332,2570.0233284527703,3423.2251303697358,2903.3851741678332,3987.8966254157895,6018.8939351389781,7263.4531552181688,{"$f":"O26*$C$32","v":6900.5949904441877},6797.2792526437497,6304.1696098993807,{"$f":"R26*$C$32","v":5169.6702659755056},3932.865234997153,3054.4932068385119,2704.6734007140599,2908.9923406283833,{"$f":"W26*$C$32","v":3769.9392099065517},3424.1099483027465,6587.2201403095296,7382.761066125805,6872.4706059524287,6951.5070083034861,6070.7191107878016,5226.2957869545071,3976.7777269236831,3036.1646344541105,2658.8151271385686,{"$f":"AH26*$C$32","v":3170.9729086597627}]
[null,"Interrupt Service Schedule 131",null,{"$f":"D27*$C$32","v":0},0,0,754.8510337644268,552.37138605925406,413.61943926979393,477.69676435068538,265.45455773581324,379.96485707356493,762.17787431701231,1223.7513443514135,{"$f":"O27*$C$32","v":1446.7398082790266},1423.3046633943916,1285.8346104038412,{"$f":"R27*$C$32","v":1072.4928744915921},779.59270891947961,563.03109431336588,429.08109821976404,412.68714065413252,{"$f":"W27*$C$32","v":331.85078320617646},314.87570609981157,802.9451338033025,1221.8251492210056,1419.9662307329243,1448.8633055278735,1229.00154853853,1088.0193635176527,787.38875326242908,562.23125950137819,422.2803641085556,{"$f":"AH27*$C$32","v":449.88473481070838}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D33:D38)","v":0},0,0,337703.03884726402,185381.66729790572,109842.78617946667,92860.929123611466,96868.335139293587,111694.28066922497,308529.29611170292,572704.20148811012,813067.60576014768,819102.88736665377,658319.24702407501,{"$f":"SUM(R33:R38)","v":544439.46186835389},341637.54873315181,187685.05351197507,110612.91089317632,97753.920795907543,{"$f":"SUM(W33:W38)","v":91727.735418476223},118711.38831105655,307599.49256156728,580612.69009250356,826687.16470240743,830561.09930134728,650584.46966373548,552799.05029665399,347105.97611627931,190829.13573069967,112680.64150971969,{"$f":"SUM(AH33:AH38)","v":97306.07525641234},null,{"$f":"SUM(D39:V39)","v":5388203.1708100205},{"$f":"AJ39+SUM('DSM Balance'!C3:U3)","v":0}]
[]
[]
[null,"WA101",null,null,null,null,9497249.38565493,5057421.2988135302,2861262.5041613695,2193485.5075411289,2490800.6721167457,2537629.1803711448,8083359.7827961203,15735548.779149588,22898409.369904723,23385530.387359805,18608677.815918069,15440273.500018638,9571568.850759903,5127349.9933950882,2872177.448569085,2503023.9299923512,2084881.7652356273,2984815.0020103883,7807394.3990552668,15900610.890801232,23326612.342601817,23572499.046756923,18452080.826143943,15630325.724624043,9717079.0659439471,5233677.7966828514,2960083.572531437,2421980.0239204071]
[null,"WA111",null,null,null,null,3792538.8373198803,2299837.7613783632,1560189.0343624263,1648238.006907054,1400437.3130040073,2188764.0970326914,4393536.2310198462,7065733.130457405,9235840.4505345654,8731137.2825534791,7302695.2045650715,5947731.4907014035,3898502.9170361264,2318877.0663845045,1579764.8840469313,1425392.9029550967,1763397.722040836,1850269.1084488421,4806967.9600809384,7260636.5321553657,9320731.4678638577,9110016.9444728848,7114799.8743097242,6128213.8909187457,3976865.8972975626,2324928.3229435817,1552906.8334235682,1527789.3709478253]
[null,"WA112",null,null,null,null,7665.597121790709,4650.3698735219668,3604.0537165676715,4665.8219570081774,4479.8291330914062,7849.5811551929464,15322.340427108202,21500.829780125423,24295.600567761445,19298.830599559758,13909.685398125686,11170.246214302784,7774.8767663209073,4667.5397027173767,3691.2547049248524,4021.8887745696206,5708.5512180291962,6724.6107384706684,16549.011168655023,21719.234491399715,23956.629307270832,19669.058653860986,13274.806918237406,11284.108220611834,7801.9284887781268,4627.689856867245,3606.9366808529085,4367.3583603517854]
[null,"WA121",null,null,null,null,313430.15285417554,252835.90419457926,211227.15637691299,281350.79628296639,238625.7694304933,327760.47391709295,494685.72381366143,596974.56379795086,567151.68341207656,558660.28597495391,518132.19174880744,424889.04190052097,323237.50948291621,251045.15866068864,222293.8854430732,239086.61576355246,309846.81353137415,281423.51841503108,541395.77772003156,606780.33889551065,564840.17374783487,571336.08152191958,498945.17327462236,429543.02602678823,326846.62489302777,249538.75512639218,218524.84855672822,260618.48662193544]
[null,"WA132",null,null,null,null,69932.360650378381,51173.851866115787,38319.32726484086,44255.702001881873,24592.75146685561,35201.434761008131,70611.147898500683,113373.124671743,134031.65063612064,131860.52689029608,119124.76195874538,99359.946716736653,72224.526485283539,52161.409051189483,39751.755997898545,38232.955464170278,30743.958231800363,29171.320504393123,74387.986725765935,113194.67439941452,131551.24139362737,134228.37975061344,113859.52418141914,100798.38156233754,72946.782612984127,52087.309216876864,39121.709314143482,41679.086493376613]
[null,"WA146",null,null,null,null,3565969,3017941,2601293,2341923,2192880,2233771,2405362,3117039,3480828,4028278,4280063,3635087,3599254,3067921,2674184,2403810,2234943,2274469,2427370,3145431,3516528,4084411,4300496,3654029,3629893,3089320,2704718,2425650]
[null,"WA148",null,null,null,null,4424842,4047057,3733720,3592927,3413044,3538051,3615845,4144387,4520970,4908767,4998627,4469128,4468138,4086062,3772247,3629612,3449305,3573089,3650351,4177983,4553109,4940561,5029910,4499804,4498319,4115744,3801482,3658653]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G42:G48)-G10","v":0},{"$f":"SUM(H42:H48)-H10","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":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,"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"]
["Expected gas tariff rider revenue",null,null,null,null,{"$f":"-'Revenue - current rates'!G39","v":-337703.03884726402},{"$f":"-'Revenue - current rates'!H39","v":-185381.66729790572},{"$f":"-'Revenue - current rates'!I39","v":-109842.78617946667},{"$f":"-'Revenue - current rates'!J39","v":-92860.929123611466},{"$f":"-'Revenue - current rates'!K39","v":-96868.335139293587},{"$f":"-'Revenue - current rates'!L39","v":-111694.28066922497},{"$f":"-'Revenue - current rates'!M39","v":-308529.29611170292},{"$f":"-'Revenue - current rates'!N39","v":-572704.20148811012},{"$f":"-'Revenue - current rates'!O39","v":-813067.60576014768},{"$f":"-'Revenue - current rates'!P39","v":-819102.88736665377},{"$f":"-'Revenue - current rates'!Q39","v":-658319.24702407501},{"$f":"-'Revenue - current rates'!R39","v":-544439.46186835389},{"$f":"-'Revenue - current rates'!S39","v":-341637.54873315181},{"$f":"-'Revenue - current rates'!T39","v":-187685.05351197507},{"$f":"-'Revenue - current rates'!U39","v":-110612.91089317632},{"$f":"-'Revenue - current rates'!V39","v":-97753.920795907543},{"$f":"-'Revenue - current rates'!W39","v":-91727.735418476223},{"$f":"-'Revenue - current rates'!X39","v":-118711.38831105655},{"$f":"-'Revenue - current rates'!Y39","v":-307599.49256156728},{"$f":"-'Revenue - current rates'!Z39","v":-580612.69009250356},{"$f":"-'Revenue - current rates'!AA39","v":-826687.16470240743},{"$f":"-'Revenue - current rates'!AB39","v":-830561.09930134728},{"$f":"-'Revenue - current rates'!AC39","v":-650584.46966373548},{"$f":"-'Revenue - current rates'!AD39","v":-552799.05029665399},{"$f":"-'Revenue - current rates'!AE39","v":-347105.97611627931},{"$f":"-'Revenue - current rates'!AF39","v":-190829.13573069967},{"$f":"-'Revenue - current rates'!AG39","v":-112680.64150971969},{"$f":"-'Revenue - current rates'!AH39","v":-97306.07525641234}]
["Expected DSM cash expenditures",null,null,null,null,334239.99,372110.17000000004,459189.6,330645.38,432236.16,316643.07999999996,335209.03000000003,441291.73,694817.54999999993,550282.03,412852.16,413204.21,230639.99,252510.17,363789.6,230145.38,319436.15999999997,225343.08,263209.03000000003,310191.73,583817.54999999993,550282.03,412852.16,482304.21,230639.99,252510.17,363789.6,230145.38]
["Accounting Adjustment"]
["Net change in balance",null,null,{"$f":"D3+D4","v":0},{"$f":"E3+E4","v":0},-3463.0488472640282,186728.50270209432,349346.81382053334,{"$f":"I3+I4","v":237784.45087638852},{"$f":"J3+J4","v":335367.8248607064},204948.79933077499,26679.733888297109,-131412.47148811014,-118250.05576014775,-268820.85736665374,-245467.08702407504,-131235.25186835387,-110997.55873315182,64825.116488024942,253176.68910682364,132391.45920409245,{"$f":"V3+V4","v":227708.42458152375},106631.69168894344,-44390.462561567256,-270420.96009250358,-242869.6147024075,-280279.06930134725,-237732.3096637355,-70494.840296653972,-116465.98611627932,61681.034269300348,251108.95849028029,132839.30474358768]
[]
["Gas Tariff rider balance",null,null,0,-249539,{"$f":"F6+E8","v":-253002.04884726403},{"$f":"G6+F8","v":-66273.546145169705},{"$f":"H6+G8","v":283073.26767536363},{"$f":"I6+H8","v":520857.71855175216},{"$f":"J6+I8","v":856225.54341245862},{"$f":"K6+J8","v":1061174.3427432335},{"$f":"L6+K8","v":1087854.0766315307},{"$f":"M6+L8","v":956441.60514342051},{"$f":"N6+M8","v":838191.54938327277},{"$f":"O6+N8","v":569370.69201661902},{"$f":"P6+O8","v":323903.60499254399},{"$f":"Q6+P8","v":192668.35312419012},{"$f":"R6+Q8","v":81670.794391038304},{"$f":"S6+R8","v":146495.91087906325},{"$f":"T6+S8","v":399672.59998588689},{"$f":"U6+T8","v":532064.05918997934},{"$f":"V6+U8","v":759772.48377150309},866404.17546044651,822013.71289887931,551592.75280637573,308723.13810396823,28444.068802620983,-209288.24086111452,-279783.08115776849,-396249.06727404782,-334568.03300474747,-83459.074514467182,49380.230229120498]
[]
[]
[]
[]
["2015 Washington gas DSM budget ",null,"CY 2015 expected expenditures (From DSM Business Plan)"]
["2016 Washington gas DSM budget ",null,"CY 2016 expected expenditures"]
["2017 Washington gas DSM budget ",null,"CY 2016 expected expenditures + 2%"]
["2018 Washington gas DSM budget ",null,"CY 2017 expected expenditures + 2%"]
[]
["End of July 2019 Balance",{"$f":"I8","v":520857.71855175216},"Underfunded (Surcharge)"]
["Aug 2019 - July 2021 Expenditure Budget",{"$f":"SUM(J4:AG4)","v":8898142.1800000016}]
["Total Projected DSM Balance + Expenditures",{"$f":"B18+B19","v":9418999.8985517547}]
[]
["Net Revenue Projected to be Recovered ",{"$f":"SUM(J3:AG3)","v":-9369619.6683226321},"Aug 2019 - July 2021"]
[]
["Total Projected DSM Balance (July 2021)",{"$f":"B20+B22","v":49380.230229122564},"Underfunded (Surcharge)"]
[]
[]
[]
[]
["August 2019 - July 2021"]
["DSM Revenue",{"$f":"SUM(J3:U3)","v":-4662414.749361773}]
["DSM Expense",{"$f":"SUM(J4:U4)","v":4673621.09}]
[null,{"$f":"B30+B31","v":11206.340638226829}]

{"sheet":"Base Revenue","index":3,"n_rows":36,"n_cols":17,"rows_kept":36,"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, 2016"]
["(000s of Dollars)"]
["From UG-170486 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)","Decrease","Rates","Increase","Rates (2)","Decrease","Revenue"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(i)","(j)"]
[]
[1,"General Service","101/102",67622.221049999993,-1662.5956499999986,65959.525399999999,{"$f":"E14/D14","v":-2.4586528277009304E-2},101853.98361,{"$f":"E14","v":-1662.5956499999986},{"$f":"(+E14)/H14","v":-1.6323324734809543E-2},{"$f":"('[3]Pres & Prop Rev'!D46*[3]Exh3!E15)/1000","v":46969.155635490002},null,{"$f":"E14/(D14-K14)","v":-8.0501156444889171E-2},null,{"$f":"D14-K14","v":20653.065414509991},{"$f":"I14/H14","v":-1.6323324734809543E-2},{"$f":"#REF!/H14","v":{"$error":"#REF!"}}]
[2,"Large General Service","111/112/116",15462.140309999999,-380.46057999999823,15081.67973,{"$f":"E15/D15","v":-2.4605945384801535E-2},28321.832710000002,-380.46057999999823,{"$f":"(+E15)/H15","v":-1.3433473175825357E-2},{"$f":"('[3]Pres & Prop Rev'!E46*[3]Exh3!E19)/1000","v":18143.079048119998},null,0.14191319428163998,null,-2680.9387381199995,-1.3433473175825357E-2,{"$f":"#REF!/H15","v":{"$error":"#REF!"}}]
[3,"Large General Svc.-High Annual Load Factor","121/122/126",1024.17931,-25.189519999999902,998.88979000000006,-2.4594833887046499E-2,2271.7746000000002,-25.189519999999902,-1.1088036638846081E-2,{"$f":"('[3]Pres & Prop Rev'!F46*[3]Exh3!E28)/1000","v":2126.3796684899999},null,2.2853848491311703E-2,null,-1102.2003584899999,-1.1088036638846081E-2,{"$f":"#REF!/H16","v":{"$error":"#REF!"}}]
[4,"Interruptible Service ","131/132",190.16824000000003,-4.6779000000000233,185.29034000000001,{"$f":"E17/D17","v":-2.4598744774627049E-2},430.80652999999995,-4.6779000000000233,-1.0858470506470791E-2,{"$f":"('[3]Pres & Prop Rev'!G46*[3]Exh3!E40)/1000","v":375.37861080000005},null,2.5257224958808965E-2,null,-185.21037080000002,-1.0858470506470791E-2,{"$f":"#REF!/H17","v":{"$error":"#REF!"}}]
[5,"Transportation Service","146",2920.5861954500001,-71.888519999999559,2848.8976754500004,{"$f":"E18/D18","v":-2.4614414774676106E-2},2963.2863354500005,-71.888519999999559,-2.4259727836622533E-2,{"$f":"('[3]Pres & Prop Rev'!H46*[3]Exh3!E49)/1000","v":17.124913119999999},null,-2.4759593123387446E-2,null,2903.4612823299999,-2.4259727836622533E-2,{"$f":"#REF!/H18","v":{"$error":"#REF!"}}]
[6,"Special Contracts","148",1612.3641100000002,0,1612.3641100000002,0,1612.3641100000002,0,0,null,null,0,null,1612.3641100000002,0,{"$f":"#REF!/H19","v":{"$error":"#REF!"}}]
[7,"Total",null,{"$f":"SUM(D14:D19)-0.2","v":88831.459215449999},{"$f":"SUM(E14:E19)","v":-2144.8121699999965},{"$f":"SUM(F14:F19)-0.6","v":86686.047045450003},{"$f":"E20/D20","v":-2.4144736436198948E-2},{"$f":"SUM(H14:H19)+1","v":137455.04789545},{"$f":"SUM(I14:I19)-0.2","v":-2145.0121699999963},-1.5603735205355041E-2,{"$f":"SUM(K14:K19)","v":67631.117876020013},null,-0.10116875646765715,null,21200.341339429986,-1.5605190226491492E-2,{"$f":"#REF!/H20","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(I20-SUM(I14:I19),-1)","v":0},{"$f":"ROUND(J20-SUM(J14:J19),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:D19,0))","v":{"$error":"#VALUE!"}},{"$f":"SUM(ROUND(E14:E19,0))","v":-2145},{"$f":"SUM(ROUND(F14:F19,0))","v":86687},null,{"$f":"SUM(ROUND(H14:H19,0))","v":137454},null,{"$f":"SUM(ROUND(J14:J19,0))","v":0}]
[null,null,null,{"$f":"ROUND(D20,0)-D30","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E20,0)-E30","v":0},{"$f":"ROUND(F20,0)-F30","v":-1},null,{"$f":"ROUND(H20,0)-H30","v":1},null,{"$f":"ROUND(J20,0)-J30","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":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["AVISTA UTILITIES"]
["REVENUE CONVERSION FACTOR"]
["WASHINGTON NATURAL GAS"]
["TWELVE MONTHS ENDED DECEMBER 31, 2016"]
[]
[]
["From UG-170486"]
[]
[]
["Description",null,"Factor"]
[]
["Revenues",null,1]
[]
["Expense:"]
["  Uncollectibles  ",null,6.1830000000000001E-3]
[]
["  Commission Fees ",null,2E-3]
[]
["  Washington Excise Tax  ",null,3.8281999999999997E-2]
[]
["  Franchise Fees  (City of Millwood Expired in 2004)",null,0]
[]
["    Total Expense",null,{"$f":"C15+C17+C19+C21","v":4.6464999999999992E-2}]
[]
["Net Operating Income Before FIT",null,{"$f":"C12-C23","v":0.95353500000000002}]
[]
["  Federal Income Tax @ 21%",null,0.200242]
[]
["REVENUE CONVERSION FACTOR",null,{"$f":"C25-C27","v":0.75329299999999999}]