{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["WA Gas - Sched 191","Revenue - current rates","DSM Balance","RCF","Billing Determinants"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":4,"comments":0,"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":42,"n_cols":9,"rows_kept":42,"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","SCH. 111&112","SCH. 121&122","SCH. 131&132","SCHEDULE 146","SCHEDULE 148"]
[]
["Forecast","Total Annual Therms",{"$f":"SUM(D7:I7)","v":249602055.18865886},{"$f":"SUM('Revenue - current rates'!K4:V4)","v":118402336.53700037},{"$f":"SUM('Revenue - current rates'!K5:V5)","v":47863180.019162111},{"$f":"SUM('Revenue - current rates'!K6:V6)","v":5844811.4577872651},{"$f":"SUM('Revenue - current rates'!K7:V7)","v":949947.55193831061},{"$f":"SUM('Revenue - current rates'!K8:V8)","v":29225570.622770786},{"$f":"SUM('Revenue - current rates'!K9:V9)","v":47316209}]
[]
[null,"Present DSM Rates",null,2.3099999999999999E-2,1.8239999999999999E-2,1.6299999999999999E-2,1.4760000000000001E-2,0,0]
[]
[null,"Present Gross DSM Revenue",{"$f":"SUM(D11:I11)","v":3717410.0301827672},{"$f":"D7*D9","v":2735093.9740047087},{"$f":"E7*E9","v":873024.40354951692},{"$f":"F7*F9","v":95270.426761932409},{"$f":"G7*G9","v":14021.225866609466},{"$f":"H7*H9","v":0},0]
[]
["UG-140189","Base Revenue",{"$f":"SUM(D13:I13)","v":157419000},116589000,35906000,4113000,811000]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:H15)","v":1},{"$f":"D13/$C$13","v":0.74062851371181371},{"$f":"E13/$C$13","v":0.22809190758421791},2.6127722828883426E-2,5.151855875084964E-3]
[]
[null,"Revenue Requirement",4395607.6360085709]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:H19)","v":4395607.6360085709},{"$f":"$C$17*D15","v":3255512.3503173268},{"$f":"$C$17*E15","v":1002602.5306889495},114847.21797815544,22645.537024139085]
[]
[null,"DSM Revenue Increase <Decrease>",{"$f":"SUM(D21:H21)","v":678197.60582580336},{"$f":"D19-D11","v":520418.37631261814},{"$f":"E19-E11","v":129578.12713943259},19576.791216223035,8624.3111575296189]
[]
[null,"Proposed Rates",null,{"$f":"D19/D7","v":2.7495338736833026E-2},{"$f":"E19/E7","v":2.0947261136588829E-2},1.9649430748555647E-2,2.3838723493662606E-2]
[]
[null,"Percentage Increase <Decrease>",null,{"$f":"D23/D9-1","v":0.190274404191906},{"$f":"E23/E9-1","v":0.14842440441824722},0.20548654899114416,0.61508966759231742]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:I27)","v":174809000},126234000,39285000,4345000,762000,2576000,1607000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:I29)","v":175487197.60582581},{"$f":"D27+D21","v":126754418.37631261},{"$f":"E27+E21","v":39414578.127139434},4364576.7912162226,770624.31115752959,2576000,1607000]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":3.8796492504722391E-3},{"$f":"D29/D27-1","v":4.122648227201875E-3},{"$f":"E29/E27-1","v":3.2984122983183983E-3},4.5055906136299839E-3,1.1317993645052038E-2,0,0]
[]
[null,"Average Monthly Bill @ 68 Therms",null,{"$f":"(D23-D9)*68","v":0.29888303410464584}]
[]
[null,"Present DSM Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":2.1265552861596183E-2}]
[]
[]
["UG-140189","Revenue Conversion Factor",{"$f":"RCF!C25","v":0.95481700000000003}]
[]
[null,"Proposed Net DSM Revenue",{"$f":"SUM(D40:I40)","v":4197000.896190796},{"$f":"D19*$C$38","v":3108418.5357929394},{"$f":"E19*$C$38","v":957301.94054483075},109658.07612824845,21622.343724777409,0,0]
[]
[null,"Proposed DSM Revenue as a % of Billed Revenue",{"$f":"C19/C27","v":2.5145202112068433E-2}]

{"sheet":"Revenue - current rates","index":1,"n_rows":39,"n_cols":43,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Forecasted Usage",null,null,"2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01"]
[null,"Small Service Schedule 101",null,{"$f":"'Billing Determinants'!C5","v":9486133.3543652892},{"$f":"'Billing Determinants'!D5","v":5309378.7151976842},{"$f":"'Billing Determinants'!E5","v":3124073.2541952846},{"$f":"'Billing Determinants'!F5","v":2408530.9169284631},{"$f":"'Billing Determinants'!G5","v":2301424.9789287667},{"$f":"'Billing Determinants'!H5","v":2834532.528517135},{"$f":"'Billing Determinants'!I5","v":7562292.7115087137},{"$f":"'Billing Determinants'!J5","v":14133934.069782864},{"$f":"'Billing Determinants'!K5","v":20341217.842150096},{"$f":"'Billing Determinants'!L5","v":20287115.11479678},{"$f":"'Billing Determinants'!M5","v":17074770.976138227},{"$f":"'Billing Determinants'!N5","v":14270012.981294559},{"$f":"'Billing Determinants'!O5","v":9009117.8060181029},{"$f":"'Billing Determinants'!P5","v":5138480.7468622709},{"$f":"'Billing Determinants'!Q5","v":3122990.7779136146},{"$f":"'Billing Determinants'!R5","v":2319085.3715035394},{"$f":"'Billing Determinants'!G15","v":2359924.5148603828},{"$f":"'Billing Determinants'!H15","v":2749531.3714723131},{"$f":"'Billing Determinants'!I15","v":7596154.9642076371},{"$f":"'Billing Determinants'!J15","v":14516282.895168405},{"$f":"'Billing Determinants'!K15","v":20641596.254023939},{"$f":"'Billing Determinants'!L15","v":20539153.954293981},{"$f":"'Billing Determinants'!M15","v":16920096.895452436},{"$f":"'Billing Determinants'!N15","v":14522526.748795167},{"$f":"'Billing Determinants'!O15","v":9197313.5402993709},{"$f":"'Billing Determinants'!P15","v":5222946.6935753692},{"$f":"'Billing Determinants'!Q15","v":3187789.7966954801},{"$f":"'Billing Determinants'!R15","v":2446827.8052194281},{"$f":"'Billing Determinants'!G25","v":2382505.8500252739},{"$f":"'Billing Determinants'!H25","v":2726187.3413235671},{"$f":"'Billing Determinants'!I25","v":7813140.1060121823},{"$f":"'Billing Determinants'!J25","v":14724702.558143053},{"$f":"'Billing Determinants'!K25","v":20919815.084402364},{"$f":"'Billing Determinants'!L25","v":20754124.23687312},{"$f":"'Billing Determinants'!M25","v":17083215.099112578},{"$f":"'Billing Determinants'!N25","v":14672743.703363501},{"$f":"'Billing Determinants'!O25","v":9302012.469644621},{"$f":"'Billing Determinants'!P25","v":5272642.0737331426},{"$f":"'Billing Determinants'!Q25","v":3269929.2673760266},{"$f":"'Billing Determinants'!R25","v":2503113.7464417168}]
[null,"Large Service Schedule 111",null,{"$f":"'Billing Determinants'!C6","v":3705052.0609527766},{"$f":"'Billing Determinants'!D6","v":2204442.258024517},{"$f":"'Billing Determinants'!E6","v":1539767.8318035046},{"$f":"'Billing Determinants'!F6","v":1253545.8688069226},{"$f":"'Billing Determinants'!G6","v":1297445.9920746498},{"$f":"'Billing Determinants'!H6","v":1693673.8613106299},{"$f":"'Billing Determinants'!I6","v":4096349.3051061872},{"$f":"'Billing Determinants'!J6","v":5947535.3780040909},{"$f":"'Billing Determinants'!K6","v":7248603.8456553631},{"$f":"'Billing Determinants'!L6","v":7205965.8854712928},{"$f":"'Billing Determinants'!M6","v":6151763.1351760598},{"$f":"'Billing Determinants'!N6","v":5239727.6736684041},{"$f":"'Billing Determinants'!O6","v":3508785.1475548386},{"$f":"'Billing Determinants'!P6","v":2185289.8329650946},{"$f":"'Billing Determinants'!Q6","v":1649906.4588958987},{"$f":"'Billing Determinants'!R6","v":1379927.0250684489},{"$f":"'Billing Determinants'!G16","v":1394371.3438798578},{"$f":"'Billing Determinants'!H16","v":1774045.2937462421},{"$f":"'Billing Determinants'!I16","v":4177258.9990765303},{"$f":"'Billing Determinants'!J16","v":6117214.1081609949},{"$f":"'Billing Determinants'!K16","v":7590760.0293535572},{"$f":"'Billing Determinants'!L16","v":7383061.609425419},{"$f":"'Billing Determinants'!M16","v":6130099.3895974224},{"$f":"'Billing Determinants'!N16","v":5375184.3984122081},{"$f":"'Billing Determinants'!O16","v":3553706.5548426686},{"$f":"'Billing Determinants'!P16","v":2210765.6797165624},{"$f":"'Billing Determinants'!Q16","v":1611502.9447466936},{"$f":"'Billing Determinants'!R16","v":1307545.0171005109},{"$f":"'Billing Determinants'!G26","v":1370674.1112940607},{"$f":"'Billing Determinants'!H26","v":1743524.0743583071},{"$f":"'Billing Determinants'!I26","v":4156430.0978646073},{"$f":"'Billing Determinants'!J26","v":6271826.3113280721},{"$f":"'Billing Determinants'!K26","v":7784391.3028813526},{"$f":"'Billing Determinants'!L26","v":7522685.4006127045},{"$f":"'Billing Determinants'!M26","v":6254332.8744894061},{"$f":"'Billing Determinants'!N26","v":5467385.6317083649},{"$f":"'Billing Determinants'!O26","v":3620529.9241601545},{"$f":"'Billing Determinants'!P26","v":2240995.8953844355},{"$f":"'Billing Determinants'!Q26","v":1600360.7678630196},{"$f":"'Billing Determinants'!R26","v":1290293.6456406808}]
[null,"Extra Large Service Schedule 121",null,{"$f":"'Billing Determinants'!C7","v":412360.59016816848},{"$f":"'Billing Determinants'!D7","v":309484.89428500889},{"$f":"'Billing Determinants'!E7","v":306925.74903021165},{"$f":"'Billing Determinants'!F7","v":312947.03262088232},{"$f":"'Billing Determinants'!G7","v":364280.37718693283},{"$f":"'Billing Determinants'!H7","v":350431.74630578415},{"$f":"'Billing Determinants'!I7","v":657669.77602987015},{"$f":"'Billing Determinants'!J7","v":692338.31364556879},{"$f":"'Billing Determinants'!K7","v":660862.48520079488},{"$f":"'Billing Determinants'!L7","v":637995.73881243216},{"$f":"'Billing Determinants'!M7","v":575706.1529142292},{"$f":"'Billing Determinants'!N7","v":521840.6111560901},{"$f":"'Billing Determinants'!O7","v":394805.45275511296},{"$f":"'Billing Determinants'!P7","v":312062.15782259678},{"$f":"'Billing Determinants'!Q7","v":318736.05958225229},{"$f":"'Billing Determinants'!R7","v":322851.19973185571},{"$f":"'Billing Determinants'!G17","v":354279.56602059439},{"$f":"'Billing Determinants'!H17","v":380119.65524988505},{"$f":"'Billing Determinants'!I17","v":673214.06489585235},{"$f":"'Billing Determinants'!J17","v":704359.21600288269},{"$f":"'Billing Determinants'!K17","v":683964.02152434899},{"$f":"'Billing Determinants'!L17","v":640881.00277145219},{"$f":"'Billing Determinants'!M17","v":557961.31656436168},{"$f":"'Billing Determinants'!N17","v":523118.45108857285},{"$f":"'Billing Determinants'!O17","v":393503.3534489731},{"$f":"'Billing Determinants'!P17","v":315534.04494058399},{"$f":"'Billing Determinants'!Q17","v":318649.56690693222},{"$f":"'Billing Determinants'!R17","v":319707.83948716987},{"$f":"'Billing Determinants'!G27","v":369882.16347352543},{"$f":"'Billing Determinants'!H27","v":389233.82574263983},{"$f":"'Billing Determinants'!I27","v":677692.02061458037},{"$f":"'Billing Determinants'!J27","v":717900.68829194573},{"$f":"'Billing Determinants'!K27","v":689880.52137045178},{"$f":"'Billing Determinants'!L27","v":638378.54659301334},{"$f":"'Billing Determinants'!M27","v":555845.69403725909},{"$f":"'Billing Determinants'!N27","v":520168.75648937997},{"$f":"'Billing Determinants'!O27","v":392982.40505712363},{"$f":"'Billing Determinants'!P27","v":315637.02750747011},{"$f":"'Billing Determinants'!Q27","v":316661.69469821517},{"$f":"'Billing Determinants'!R27","v":325350.89886638295}]
[null,"Interrupt Service Schedule 131",null,{"$f":"'Billing Determinants'!C8","v":104980.76563874594},{"$f":"'Billing Determinants'!D8","v":78812.598911483423},{"$f":"'Billing Determinants'!E8","v":68390.796452200608},{"$f":"'Billing Determinants'!F8","v":64231.546927837153},{"$f":"'Billing Determinants'!G8","v":56180.40977699808},{"$f":"'Billing Determinants'!H8","v":26731.319955887942},{"$f":"'Billing Determinants'!I8","v":68916.966153642992},{"$f":"'Billing Determinants'!J8","v":101811.94955805273},{"$f":"'Billing Determinants'!K8","v":131967.62698606736},{"$f":"'Billing Determinants'!L8","v":127188.67518277075},{"$f":"'Billing Determinants'!M8","v":122019.40286288105},{"$f":"'Billing Determinants'!N8","v":107766.28753965048},{"$f":"'Billing Determinants'!O8","v":79730.234346449884},{"$f":"'Billing Determinants'!P8","v":60062.840949341051},{"$f":"'Billing Determinants'!Q8","v":50784.126520712889},{"$f":"'Billing Determinants'!R8","v":42486.699936936944},{"$f":"'Billing Determinants'!G18","v":28035.049511434663},{"$f":"'Billing Determinants'!H18","v":28583.197316745587},{"$f":"'Billing Determinants'!I18","v":69511.461227267428},{"$f":"'Billing Determinants'!J18","v":102567.88999966314},{"$f":"'Billing Determinants'!K18","v":135869.86221683293},{"$f":"'Billing Determinants'!L18","v":127430.85075436343},{"$f":"'Billing Determinants'!M18","v":118117.06639951833},{"$f":"'Billing Determinants'!N18","v":108158.86870162336},{"$f":"'Billing Determinants'!O18","v":79591.339825851595},{"$f":"'Billing Determinants'!P18","v":60682.968490124033},{"$f":"'Billing Determinants'!Q18","v":50564.661817979671},{"$f":"'Billing Determinants'!R18","v":41734.407792386133},{"$f":"'Billing Determinants'!G28","v":28985.907454890894},{"$f":"'Billing Determinants'!H28","v":29010.983689920045},{"$f":"'Billing Determinants'!I28","v":69528.032706353464},{"$f":"'Billing Determinants'!J28","v":104236.86697702721},{"$f":"'Billing Determinants'!K28","v":136976.75155183821},{"$f":"'Billing Determinants'!L28","v":127051.02711070004},{"$f":"'Billing Determinants'!M28","v":117864.10210448205},{"$f":"'Billing Determinants'!N28","v":107748.35418732991},{"$f":"'Billing Determinants'!O28","v":79563.372560549586},{"$f":"'Billing Determinants'!P28","v":60657.15287015168},{"$f":"'Billing Determinants'!Q28","v":50094.738590880777},{"$f":"'Billing Determinants'!R28","v":42246.792070750947}]
[null,"Transport Service Schedule 146",null,{"$f":"'Billing Determinants'!C9","v":2508687.3990395153},{"$f":"'Billing Determinants'!D9","v":2163117.2778222915},{"$f":"'Billing Determinants'!E9","v":1907188.8399939518},{"$f":"'Billing Determinants'!F9","v":1705251.6796036633},{"$f":"'Billing Determinants'!G9","v":1842139.5249331123},{"$f":"'Billing Determinants'!H9","v":1715712.2024699394},{"$f":"'Billing Determinants'!I9","v":1866429.895180952},{"$f":"'Billing Determinants'!J9","v":2553938.8152195672},{"$f":"'Billing Determinants'!K9","v":2721719.1993802432},{"$f":"'Billing Determinants'!L9","v":3216723.1398855527},{"$f":"'Billing Determinants'!M9","v":3461087.3868407402},{"$f":"'Billing Determinants'!N9","v":2885773.052977988},{"$f":"'Billing Determinants'!O9","v":2920481.0414094515},{"$f":"'Billing Determinants'!P9","v":2399785.8200041056},{"$f":"'Billing Determinants'!Q9","v":2081076.3106292747},{"$f":"'Billing Determinants'!R9","v":1804359.8962635719},{"$f":"'Billing Determinants'!G19","v":1614824.3437344171},{"$f":"'Billing Determinants'!H19","v":1704318.7543243538},{"$f":"'Billing Determinants'!I19","v":1861482.8621015169},{"$f":"'Billing Determinants'!J19","v":2552504.954488303},{"$f":"'Billing Determinants'!K19","v":2731334.1785123935},{"$f":"'Billing Determinants'!L19","v":3231444.7220111163},{"$f":"'Billing Determinants'!M19","v":3503435.2838310488},{"$f":"'Billing Determinants'!N19","v":2915517.9211498541},{"$f":"'Billing Determinants'!O19","v":2936559.7151487572},{"$f":"'Billing Determinants'!P19","v":2400940.3557914756},{"$f":"'Billing Determinants'!Q19","v":2084993.7921222211},{"$f":"'Billing Determinants'!R19","v":1810389.4969431651},{"$f":"'Billing Determinants'!G29","v":1622602.8393433923},{"$f":"'Billing Determinants'!H29","v":1713150.749634997},{"$f":"'Billing Determinants'!I29","v":1871149.8910683426},{"$f":"'Billing Determinants'!J29","v":2563087.1091650268},{"$f":"'Billing Determinants'!K29","v":2742592.0976233408},{"$f":"'Billing Determinants'!L29","v":3242869.0157049587},{"$f":"'Billing Determinants'!M29","v":3514583.4739140309},{"$f":"'Billing Determinants'!N29","v":2923818.0635665972},{"$f":"'Billing Determinants'!O29","v":2942858.1490322985},{"$f":"'Billing Determinants'!P29","v":2406604.3096446763},{"$f":"'Billing Determinants'!Q29","v":2090991.5247326605},{"$f":"'Billing Determinants'!R29","v":1816495.9640500718}]
[null,"Special Contract Transport",null,{"$f":"'Billing Determinants'!C10","v":3798396},{"$f":"'Billing Determinants'!D10","v":3444836},{"$f":"'Billing Determinants'!E10","v":3394978},{"$f":"'Billing Determinants'!F10","v":3188893},{"$f":"'Billing Determinants'!G10","v":3326120},{"$f":"'Billing Determinants'!H10","v":3372541},{"$f":"'Billing Determinants'!I10","v":3433105},{"$f":"'Billing Determinants'!J10","v":4003772},{"$f":"'Billing Determinants'!K10","v":4310120},{"$f":"'Billing Determinants'!L10","v":4662531},{"$f":"'Billing Determinants'!M10","v":4750261},{"$f":"'Billing Determinants'!N10","v":4271089},{"$f":"'Billing Determinants'!O10","v":4296316},{"$f":"'Billing Determinants'!P10","v":3876453},{"$f":"'Billing Determinants'!Q10","v":3550405},{"$f":"'Billing Determinants'!R10","v":3442600},{"$f":"'Billing Determinants'!G20","v":3272157},{"$f":"'Billing Determinants'!H20","v":3407902},{"$f":"'Billing Determinants'!I20","v":3472603},{"$f":"'Billing Determinants'!J20","v":4046445},{"$f":"'Billing Determinants'!K20","v":4355432},{"$f":"'Billing Determinants'!L20","v":4709037},{"$f":"'Billing Determinants'!M20","v":4797603},{"$f":"'Billing Determinants'!N20","v":4318999},{"$f":"'Billing Determinants'!O20","v":4344578},{"$f":"'Billing Determinants'!P20","v":3924903},{"$f":"'Billing Determinants'!Q20","v":3598917},{"$f":"'Billing Determinants'!R20","v":3491074},{"$f":"'Billing Determinants'!G30","v":3320518},{"$f":"'Billing Determinants'!H30","v":3456088},{"$f":"'Billing Determinants'!I30","v":3520570},{"$f":"'Billing Determinants'!J30","v":4094156},{"$f":"'Billing Determinants'!K30","v":4402860},{"$f":"'Billing Determinants'!L30","v":4756082},{"$f":"'Billing Determinants'!M30","v":4844249},{"$f":"'Billing Determinants'!N30","v":4365230},{"$f":"'Billing Determinants'!O30","v":4390387},{"$f":"'Billing Determinants'!P30","v":3970281},{"$f":"'Billing Determinants'!Q30","v":3643858},{"$f":"'Billing Determinants'!R30","v":3535571}]
["Total Forecasted Usage",null,null,{"$f":"SUM(D4:D9)","v":20015610.170164496},13510071.744240986,10341324.471475154,8933400.0448877681,9187591.2829004601,9993622.6585593764,17684763.653979365,27433330.526210144,35414490.999372564,36137519.554148823,32135608.053932138,27296209.606636692,20209235.682083957,13972134.39860341,10773898.733541753,9311310.1925043538,{"$f":"SUM(T4:T9)","v":9023591.8180066869},10044500.27210954,17850225.351508804,28039374.063820247,36138956.345631078,36631009.139256328,32027312.951844789,27763505.388147425,20505252.503565624,{"$f":"SUM(AC4:AC9)","v":14135772.742514115},10852417.762289306,9417278.566542659,{"$f":"SUM(AF4:AF9)","v":9095168.8715911433},10057194.974749431,18108510.14826607,28475909.533905126,36676515.757829346,37041190.226894498,32370090.243657753,28057094.50931517,20728333.320454746,14266817.459139876,10971895.993260805,9513072.0470696036]
[]
[]
["DSM Rates"]
[null,"Small Service Schedule 101",null,2.3099999999999999E-2,2.3099999999999999E-2,2.3099999999999999E-2,2.3099999999999999E-2,2.3099999999999999E-2,2.3099999999999999E-2,2.3099999999999999E-2,{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2},{"$f":"'WA Gas - Sched 191'!$D$23","v":2.7495338736833026E-2}]
[null,"Large Service Schedule 111",null,1.8239999999999999E-2,1.8239999999999999E-2,1.8239999999999999E-2,1.8239999999999999E-2,1.8239999999999999E-2,1.8239999999999999E-2,1.8239999999999999E-2,{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2},{"$f":"'WA Gas - Sched 191'!$E$23","v":2.0947261136588829E-2}]
[null,"Extra Large Service Schedule 121",null,1.6299999999999999E-2,1.6299999999999999E-2,1.6299999999999999E-2,1.6299999999999999E-2,1.6299999999999999E-2,1.6299999999999999E-2,1.6299999999999999E-2,{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2},{"$f":"'WA Gas - Sched 191'!$F$23","v":1.9649430748555647E-2}]
[null,"Interrupt Service Schedule 131",null,1.4760000000000001E-2,1.4760000000000001E-2,1.4760000000000001E-2,1.4760000000000001E-2,1.4760000000000001E-2,1.4760000000000001E-2,1.4760000000000001E-2,{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2},{"$f":"'WA Gas - Sched 191'!$G$23","v":2.3838723493662606E-2}]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total"]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D3","v":"2015-04-01"},{"$f":"E3","v":"2015-05-01"},"2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01",{"$f":"T3","v":"2016-08-01"},"2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01",{"$f":"AC3","v":"2017-05-01"},"2017-06-01","2017-07-01",{"$f":"AF3","v":"2017-08-01"},"2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01"]
[null,"Small Service Schedule 101",null,{"$f":"D4*D14","v":219129.68048583818},122646.6483210665,72166.092171911077,55637.064181047499,53162.917013254511,65477.701408745816,174688.96163585127,388617.30493274488,559288.67488962866,557801.10207446269,469476.61184276565,392358.84069969843,247708.74579650172,141284.2687276729,85867.689310740519,63764.037849124077,{"$f":"T4*T14","v":64886.923929442572},75599.296426180328,208858.85383836474,399130.11540235049,567547.68107333186,564730.99534127652,465223.79560050159,399301.79227284156,252883.25125939219,{"$f":"AC4*AC14","v":143606.68854427681},87649.360281962319,67276.359335209883,{"$f":"AF4*AF14","v":65507.805388931207},74957.444409757707,214824.93381314047,404860.68463525502,575197.40205755213,570641.67607914272,469708.78586428089,403432.0583227133,255761.98378712358,144973.07985537048,89907.812851988099,68823.960355238174]
[null,"Large Service Schedule 111",null,{"$f":"D5*D15","v":67580.149591778638},40209.026786367191,28085.365252095922,22864.676647038268,23665.414895441612,30892.611230305887,74717.411325136854,124584.57668215224,151838.39763062491,150945.24914431773,128862.58884297333,109757.94386494315,73499.438758015574,45775.836790252419,34561.021445436949,28905.691743544958,{"$f":"T5*T15","v":29208.260661627683},37161.390036238969,87502.135088821757,128138.8813520737,159005.63256004965,154654.91952015806,128408.79270714099,112595.39125085865,74440.419207096813,{"$f":"AC5*AC15","v":46309.486004831131},33756.573005990867,27389.486921049906,{"$f":"AF5*AF15","v":28711.868542438508},36522.054083512776,87065.826655947385,131377.5835467178,163061.67741084663,157579.65553503868,131011.14395708183,114526.7545618288,75840.185774216909,46942.726226641469,33523.174917178483,27028.117938116549]
[null,"Extra Large Service Schedule 121",null,{"$f":"D6*D16","v":6721.4776197411456},5044.6037768456445,5002.8897091924491,5101.0366317203816,5937.7701481470049,5712.0374647842809,10720.017349286882,13604.053748550403,12985.5716372714,12536.253087668481,11312.298183205534,10253.870950695547,7757.7024030637504,6131.8437593799581,6262.9821298289726,6343.8422912192063,{"$f":"T6*T16","v":6961.3917981500181},7469.1348419974629,13228.273147124699,13840.257636955592,13439.50367544632,12592.94688202255,10963.62225020436,10278.979777956607,7732.116892920013,{"$f":"AC6*AC16","v":6200.0643648716505},6261.2825979950139,6282.0770517734891,{"$f":"AF6*AF16","v":7267.9739562989771},7648.2231039253775,13316.262427914942,14106.339858933021,13555.759529446157,12543.775042643019,10922.051471867973,10221.019958200377,7721.8805535707952,6202.0879136879876,6222.22204069285,6392.959956255324]
[null,"Interrupt Service Schedule 131",null,{"$f":"D7*D17","v":1549.5161008278901},1163.2739599334955,1009.4481556344811,948.05763265487644,829.22284830849173,394.55428254890603,1017.2144204277706,2427.0669138651438,3145.9397698356674,3032.015659207339,2908.786805710045,2569.0107305962656,1900.6670106699401,1431.821457635177,1210.6287499944526,1012.8286919548523,{"$f":"T7*T17","v":668.31979343423188},681.386937398697,1657.0645038372775,2445.0875690303715,3238.9640765091167,3037.7888156954568,2815.7600857807038,2578.3693643653578,1897.3559425986127,{"$f":"AC7*AC17","v":1446.6045066107074},1205.3969916293765,994.89500753445111,{"$f":"AF7*AF17","v":690.98703303003765},691.58481846315965,1657.4595467450904,2484.8738497110426,3265.3509053043913,3028.7343048778098,2809.7297398975647,2568.5832223689813,1896.6892386942043,1445.989095184369,1194.1946217553163,1007.1095946688897]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D24:D29)","v":294980.82379818591},{"$f":"SUM(E24:E29)","v":169063.55284421283},106263.79528883394,84550.835092461028,83595.324905151618,102476.90438638489,261143.60473070279,529233.00227731268,727258.58392736071,724314.61996565619,612560.28567465453,514939.66624593339,330866.55396825098,194623.77073494045,127902.3216360009,100026.40057584309,{"$f":"SUM(T24:T29)","v":101724.8961826545},120911.20824181546,311246.32657814841,543554.34196041012,743231.78138533689,735016.65055915259,607411.97064362769,524754.53266602219,336953.14330200758,{"$f":"SUM(AC24:AC29)","v":197562.8434205903},128872.61287757757,101942.81831556773,{"$f":"SUM(AF24:AF29)","v":102178.63492069872},119819.30641565903,316864.48244374793,552829.48189061682,755080.18990314938,743793.84096170228,614451.7110331282,530748.41606511141,341220.73935360549,199563.88309088431,130847.40443161476,103252.14784427892]
[]
["Net DSM Revenue",null,{"$f":"RCF!C25","v":0.95481700000000003},{"$f":"D23","v":"2015-04-01"},{"$f":"E23","v":"2015-05-01"},"2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01",{"$f":"T23","v":"2016-08-01"},"2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01",{"$f":"AC23","v":"2017-05-01"},"2017-06-01","2017-07-01",{"$f":"AF23","v":"2017-08-01"},"2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01"]
[null,"Small Service Schedule 101",null,{"$f":"D24*$C$32","v":209228.74413244656},{"$f":"E24*$C$32","v":117105.10480997576},68905.411629307622,53123.214710155233,50760.856933844632,62519.222425994456,166795.9902822586,371058.40924396866,534018.33469209063,532597.97487943224,448264.25008987397,374630.89120036399,236516.52153517838,134900.62161375047,81987.929504613334,{"$f":"S24*$C$32","v":60882.987326987102},{"$f":"T24*$C$32","v":61955.138045538566},72183.493415756224,199421.98424538592,381096.21939812612,541904.17419939546,539214.75477877166,444203.58884388412,381260.13939257775,241457.22731773907,{"$f":"AC24*$C$32","v":137118.10753578076},{"$f":"AD24*$C$32","v":83689.099236342416},64236.611591367095,{"$f":"AF24*$C$32","v":62547.966218043133},71570.642198991627,205118.49882866134,386567.86432138033,549208.25784038578,544858.37322885881,448485.93379257509,385203.78763151815,244205.89007366999,138422.76118826529,85845.508143896717,65714.287354507454]
[null,"Large Service Schedule 111",null,{"$f":"D25*$C$32","v":64526.675692773308},38392.26232907876,26816.384193910471,21831.581962095137,22596.140454220873,29496.790377086978,71341.454529233204,118955.47175392255,144977.88331048039,144125.08995223002,123040.19049128128,104798.75068729343,70178.513616612152,43707.547156558445,32999.450813467774,27599.645873496367,{"$f":"T25*$C$32","v":27888.543820153358},35482.326950231582,83548.526119103524,122349.18227594296,151821.28106408892,147667.14629147877,122606.89822625424,107507.9936879711,71076.977746062563,{"$f":"AC25*$C$32","v":44217.084498674849},32231.349767861182,26151.947733496108,{"$f":"AF25*$C$32","v":27414.58018608551},34871.87811385742,83131.931410151723,125441.55018932644,155694.06164039235,150459.73395899902,125091.66743966901,109352.09221046169,72413.498660380472,44821.713027543126,32008.497304895609,25806.906485318628]
[null,"Extra Large Service Schedule 121",null,{"$f":"D26*$C$32","v":6417.7810964483815},4816.6734443964278,4776.8441434620072,4870.5564935893599,5669.4838795432788,5453.950476012933,10235.654805394053,12989.38178802965,12398.844553984567,11969.827564408357,10801.174614393758,9790.5702995302709,7407.1861353861214,5854.7886627998932,5980.0018082569104,6057.2084649750495,{"$f":"T26*$C$32","v":6646.8552325342062},7131.6569224314917,12630.580081518165,13214.913276145027,12832.26658087863,12023.959763052126,10468.252906073378,9814.5446346491935,7382.7566553472079,{"$f":"AC26*$C$32","v":5919.9268566736546},5978.3790663698055,5998.2339643432078,{"$f":"AF26*$C$32","v":6939.5850890315205},7302.6534394207174,12714.593742634463,13468.97310508685,12943.269646627192,11977.009654891281,10428.560420214562,9759.2036134290101,7372.9828245188064,5921.8589754838231,5941.0833822282248,6104.1068465518401]
[null,"Interrupt Service Schedule 131",null,{"$f":"D27*$C$32","v":1479.5043148441837},1110.7137526018203,963.83825961844832,905.22154463863114,791.75607235336918,376.72713640049881,971.25362126958271,2317.404749495975,3003.7967732151824,2895.0200956773738,2777.3590914676479,2452.9351187557345,1814.7891731268403,1367.1274687148468,1155.9289111834532,967.06605316625621,{"$f":"T27*$C$32","v":638.12310020749305},650.59983140621171,1582.1933583603977,2334.6111773988723,3092.6179626402054,2900.5324036358893,2688.5355978248745,2461.8709013752377,1811.6277090441797,{"$f":"AC27*$C$32","v":1381.242575188516},1150.9335393565864,949.94266640902208,{"$f":"AF27*$C$32","v":659.76616591664151},660.3369416105387,1582.5705520445069,2372.5997945595486,3117.8125553500231,2891.887002780516,2682.7777210597733,2452.5269266326836,1810.9911288222841,1380.6549698966537,1140.237326160546,961.6053618529653]
[null,"Transport Service Schedule 146"]
[null,"Special Contract Transport"]
[null,"Total",null,{"$f":"SUM(D33:D38)","v":281652.70523651247},161424.75433605278,101462.47822629855,80730.574710478366,79818.237339962143,97846.690415494872,249344.35323815545,505320.66753541678,694398.85932977078,691587.91249174788,584882.97428701667,491673.14730594342,315917.01046030351,185830.08490182363,122123.31103752147,95506.907718624774,{"$f":"SUM(T33:T38)","v":97128.660198433616},115448.07711982551,297183.28380436799,518994.926127613,709650.33980700327,701806.39323693851,579967.27557403652,501044.54861657327,321728.58942819299,{"$f":"SUM(AC33:AC38)","v":188636.36146631776},123049.76160992999,97336.735955615441,{"$f":"SUM(AF33:AF38)","v":97561.897659076814},114405.51069388031,302547.594533492,527850.98741035315,720963.40168275544,710187.00384552975,586688.93937351834,506767.61038204149,325803.36268739152,190546.9881611889,124935.3261571811,98586.906048230885]

{"sheet":"DSM Balance","index":2,"n_rows":26,"n_cols":42,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,"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","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,0,0,0,null,null,{"$f":"-'Revenue - current rates'!I39","v":-97846.690415494872},{"$f":"-'Revenue - current rates'!J39","v":-249344.35323815545},{"$f":"-'Revenue - current rates'!K39","v":-505320.66753541678},{"$f":"-'Revenue - current rates'!L39","v":-694398.85932977078},{"$f":"-'Revenue - current rates'!M39","v":-691587.91249174788},{"$f":"-'Revenue - current rates'!N39","v":-584882.97428701667},{"$f":"-'Revenue - current rates'!O39","v":-491673.14730594342},{"$f":"-'Revenue - current rates'!P39","v":-315917.01046030351},{"$f":"-'Revenue - current rates'!Q39","v":-185830.08490182363},{"$f":"-'Revenue - current rates'!R39","v":-122123.31103752147},{"$f":"-'Revenue - current rates'!S39","v":-95506.907718624774},{"$f":"-'Revenue - current rates'!T39","v":-97128.660198433616},{"$f":"-'Revenue - current rates'!U39","v":-115448.07711982551},{"$f":"-'Revenue - current rates'!V39","v":-297183.28380436799},{"$f":"-'Revenue - current rates'!W39","v":-518994.926127613},{"$f":"-'Revenue - current rates'!X39","v":-709650.33980700327},{"$f":"-'Revenue - current rates'!Y39","v":-701806.39323693851},{"$f":"-'Revenue - current rates'!Z39","v":-579967.27557403652},{"$f":"-'Revenue - current rates'!AA39","v":-501044.54861657327},{"$f":"-'Revenue - current rates'!AB39","v":-321728.58942819299},{"$f":"-'Revenue - current rates'!AC39","v":-188636.36146631776},{"$f":"-'Revenue - current rates'!AD39","v":-123049.76160992999},{"$f":"-'Revenue - current rates'!AE39","v":-97336.735955615441},{"$f":"-'Revenue - current rates'!AF39","v":-97561.897659076814},{"$f":"-'Revenue - current rates'!AG39","v":-114405.51069388031},{"$f":"-'Revenue - current rates'!AH39","v":-302547.594533492},{"$f":"-'Revenue - current rates'!AI39","v":-527850.98741035315},{"$f":"-'Revenue - current rates'!AJ39","v":-720963.40168275544},{"$f":"-'Revenue - current rates'!AK39","v":-710187.00384552975},{"$f":"-'Revenue - current rates'!AL39","v":-586688.93937351834},{"$f":"-'Revenue - current rates'!AM39","v":-506767.61038204149},{"$f":"-'Revenue - current rates'!AN39","v":-325803.36268739152},{"$f":"-'Revenue - current rates'!AO39","v":-190546.9881611889},{"$f":"-'Revenue - current rates'!AP39","v":-124935.3261571811},{"$f":"-'Revenue - current rates'!AQ39","v":-98586.906048230885}]
["Expected DSM cash expenditures",null,0,0,0,null,null,{"$f":"$B13/12","v":242856.66666666666},{"$f":"$B13/12","v":242856.66666666666},242856.66666666666,{"$f":"$B13/12","v":242856.66666666666},{"$f":"$B14/12","v":302869.91666666669},{"$f":"$B14/12","v":302869.91666666669},{"$f":"$B14/12","v":302869.91666666669},302869.91666666669,{"$f":"$B14/12","v":302869.91666666669},{"$f":"$B14/12","v":302869.91666666669},{"$f":"$B14/12","v":302869.91666666669},{"$f":"$B14/12","v":302869.91666666669},302869.91666666669,302869.91666666669,302869.91666666669,{"$f":"$B14/12","v":302869.91666666669},{"$f":"$B15/12","v":308927.315},308927.315,308927.315,308927.315,308927.315,308927.315,308927.315,{"$f":"$B15/12","v":308927.315},{"$f":"$B15/12","v":308927.315},308927.315,308927.315,308927.315,{"$f":"$B16/12","v":315105.86130000005},{"$f":"$B16/12","v":315105.86130000005},315105.86130000005,315105.86130000005,315105.86130000005,315105.86130000005,315105.86130000005]
["Accounting Adjustment"]
["Net change in balance",null,{"$f":"C3+C4","v":0},{"$f":"D3+D4","v":0},0,{"$f":"F3+F4+F5","v":0},{"$f":"G3+G4","v":0},{"$f":"H3+H4","v":145009.97625117179},-6487.6865714887972,-262464.00086875015,-451542.19266310416,-388717.99582508119,-282013.05762034998,-188803.23063927674,-13047.093793636828,117039.83176484305,180746.60562914523,{"$f":"R3+R4","v":207363.00894804191},205741.25646823307,{"$f":"T3+T4","v":187421.83954684116},5686.6328622986912,-216125.00946094631,-406780.42314033658,-392879.07823693851,-271039.96057403652,-192117.23361657327,-12801.274428192992,120290.95353368224,185877.55339007001,211590.57904438456,{"$f":"AE3+AE4","v":211365.41734092319},194521.80430611968,6379.7204665080062,-218923.67241035315,-412036.08668275544,-395081.1425455297,-271583.07807351829,-191661.74908204144,-10697.501387391472,124558.87313881115,190170.53514281893,216518.95525176916]
[]
["Gas Tariff rider balance",0,{"$f":"C6+B8","v":0},{"$f":"D6+C8","v":0},0,{"$f":"F6+E8","v":0},1518050,{"$f":"H6+G8","v":1663059.9762511719},1656572.289679683,1394108.288810933,942566.09614782885,553848.1003227476,{"$f":"M6+L8","v":271835.04270239762},{"$f":"N6+M8","v":83031.812063120888},69984.718269484059,187024.55003432711,367771.15566347237,{"$f":"R6+Q8","v":575134.16461151431},{"$f":"S6+R8","v":780875.42107974738},{"$f":"T6+S8","v":968297.26062658848},{"$f":"U6+T8","v":973983.89348888723},{"$f":"V6+U8","v":757858.88402794092},{"$f":"W6+V8","v":351078.46088760433},{"$f":"X6+W8","v":-41800.617349334178},{"$f":"Y6+X8","v":-312840.5779233707},{"$f":"Z6+Y8","v":-504957.81153994397},{"$f":"AA6+Z8","v":-517759.08596813696},{"$f":"AB6+AA8","v":-397468.13243445475},{"$f":"AC6+AB8","v":-211590.57904438474},{"$f":"AD6+AC8","v":0},{"$f":"AE6+AD8","v":211365.41734092319},{"$f":"AF6+AE8","v":405887.2216470429},{"$f":"AG6+AF8","v":412266.9421135509},{"$f":"AH6+AG8","v":193343.26970319776},{"$f":"AI6+AH8","v":-218692.81697955768},{"$f":"AJ6+AI8","v":-613773.95952508738},{"$f":"AK6+AJ8","v":-885357.03759860573},{"$f":"AL6+AK8","v":-1077018.7866806472},{"$f":"AM6+AL8","v":-1087716.2880680386},{"$f":"AN6+AM8","v":-963157.41492922744},{"$f":"AO6+AN8","v":-772986.87978640851},{"$f":"AP6+AO8","v":-556467.92453463934}]
[]
[]
[]
[]
["2015 Washington gas DSM budget ",2914280,"CY 2015 expected expenditures (From DSM Business Plan)"]
["2016 Washington gas DSM budget ",3634439,"CY 2016 expected expenditures"]
["2017 Washington gas DSM budget ",{"$f":"B14*1.02","v":3707127.7800000003},"CY 2016 expected expenditures + 2%"]
["2018 Washington gas DSM budget ",{"$f":"B15*1.02","v":3781270.3356000003},"CY 2017 expected expenditures + 2%"]
[]
["August Balance",{"$f":"G8","v":1518050},"Underfunded (Surcharge)"]
["September 2015 - July 2016 Expenditure Budget",{"$f":"SUM(G4:R4)","v":3091516.083333333}]
["Total Projected DSM Balance + Expenditures",{"$f":"B18+B19","v":4609566.083333333}]
[]
["Net Revenue Projected to be Recovered ",{"$f":"SUM(G3:R3)","v":-4034431.9187218193},"September 2015 - July 2016"]
[]
["Total Projected DSM Balance (July 2016)",{"$f":"B20+B22","v":575134.16461151373},"Underfunded (Surcharge)"]
["Total Projected DSM Balance (July 2017)",{"$f":"AD8","v":0}]
["Total Projected DSM Balance (July 2018)",{"$f":"AP8","v":-556467.92453463934},"Overfunded (Rebate)"]

{"sheet":"RCF","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["AVISTA UTILITIES"]
["Revenue Conversion Factor"]
["Washington - Gas System"]
["TWELVE MONTHS ENDED DECEMBER 31, 2013"]
[]
[]
[]
[]
[]
["Description",null,"Factor"]
[]
["Revenues",null,1]
[]
["Expense:"]
["  Uncollectibles  ",null,4.8500000000000001E-3]
[]
["  Commission Fees ",null,2E-3]
[]
["  Washington Excise Tax  ",null,3.8332999999999999E-2]
[]
["  Franchise Fees  (City of Millwood Expired in 2004)",null,0]
[]
["    Total Expense",null,{"$f":"C15+C17+C19+C21","v":4.5183000000000001E-2}]
[]
["Net Operating Income Before FIT",null,{"$f":"C12-C23","v":0.95481700000000003}]
[]
["  Federal Income Tax @ 35%",null,0.33418599999999998]
[]
["REVENUE CONVERSION FACTOR",null,{"$f":"C25-C27","v":0.62063100000000004}]

{"sheet":"Billing Determinants","index":4,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01",null,"Annual"]
["WA101",null,9486133.3543652892,5309378.7151976842,3124073.2541952846,2408530.9169284631,2301424.9789287667,2834532.528517135,7562292.7115087137,14133934.069782864,20341217.842150096,20287115.11479678,17074770.976138227,14270012.981294559,9009117.8060181029,5138480.7468622709,3122990.7779136146,2319085.3715035394,null,{"$f":"SUM(G5:R5)","v":118394975.90541467},{"$f":"T5-'WA Gas - Sched 191'!D7","v":-7360.6315857023001}]
["WA111",null,3705052.0609527766,2204442.258024517,1539767.8318035046,1253545.8688069226,1297445.9920746498,1693673.8613106299,4096349.3051061872,5947535.3780040909,7248603.8456553631,7205965.8854712928,6151763.1351760598,5239727.6736684041,3508785.1475548386,2185289.8329650946,1649906.4588958987,1379927.0250684489,null,{"$f":"SUM(G6:R6)","v":47604973.540950961},{"$f":"T6-'WA Gas - Sched 191'!E7","v":-258206.47821114957}]
["WA121",null,412360.59016816848,309484.89428500889,306925.74903021165,312947.03262088232,364280.37718693283,350431.74630578415,657669.77602987015,692338.31364556879,660862.48520079488,637995.73881243216,575706.1529142292,521840.6111560901,394805.45275511296,312062.15782259678,318736.05958225229,322851.19973185571,null,5809580.0711435201,{"$f":"T7-'WA Gas - Sched 191'!F7","v":-35231.386643745005}]
["WA132",null,104980.76563874594,78812.598911483423,68390.796452200608,64231.546927837153,56180.40977699808,26731.319955887942,68916.966153642992,101811.94955805273,131967.62698606736,127188.67518277075,122019.40286288105,107766.28753965048,79730.234346449884,60062.840949341051,50784.126520712889,42486.699936936944,null,975646.53976939211,{"$f":"T8-'WA Gas - Sched 191'!G7","v":25698.987831081497}]
["WA146",null,2508687.3990395153,2163117.2778222915,1907188.8399939518,1705251.6796036633,1842139.5249331123,1715712.2024699394,1866429.895180952,2553938.8152195672,2721719.1993802432,3216723.1398855527,3461087.3868407402,2885773.052977988,2920481.0414094515,2399785.8200041056,2081076.3106292747,1804359.8962635719,null,29469226.285194498,{"$f":"T9-'WA Gas - Sched 191'!H7","v":243655.66242371127}]
["WA148",null,3798396,3444836,3394978,3188893,3326120,3372541,3433105,4003772,4310120,4662531,4750261,4271089,4296316,3876453,3550405,3442600,null,47295313,{"$f":"T10-'WA Gas - Sched 191'!I7","v":-20896}]
[]
[null,null,{"$f":"SUM(C5:C11)","v":20015610.170164496},{"$f":"SUM(D5:D11)","v":13510071.744240986},10341324.471475154,8933400.0448877681,9187591.2829004601,9993622.6585593764,17684763.653979365,27433330.526210144,35414490.999372564,36137519.554148823,32135608.053932138,27296209.606636692,20209235.682083957,13972134.39860341,10773898.733541753,9311310.1925043538,null,{"$f":"SUM(T5:T11)","v":249549715.342473}]
[]
[null,null,null,null,null,null,"2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01",null,"Annual"]
["WA101",null,null,null,null,null,2359924.5148603828,2749531.3714723131,7596154.9642076371,14516282.895168405,20641596.254023939,20539153.954293981,16920096.895452436,14522526.748795167,9197313.5402993709,5222946.6935753692,3187789.7966954801,2446827.8052194281,null,{"$f":"SUM(G15:R15)","v":119900145.43406391}]
["WA111",null,null,null,null,null,1394371.3438798578,1774045.2937462421,4177258.9990765303,6117214.1081609949,7590760.0293535572,7383061.609425419,6130099.3895974224,5375184.3984122081,3553706.5548426686,2210765.6797165624,1611502.9447466936,1307545.0171005109,null,{"$f":"SUM(G16:R16)","v":48625515.368058667}]
["WA121",null,null,null,null,null,354279.56602059439,380119.65524988505,673214.06489585235,704359.21600288269,683964.02152434899,640881.00277145219,557961.31656436168,523118.45108857285,393503.3534489731,315534.04494058399,318649.56690693222,319707.83948716987,null,5865292.098901609]
["WA132",null,null,null,null,null,28035.049511434663,28583.197316745587,69511.461227267428,102567.88999966314,135869.86221683293,127430.85075436343,118117.06639951833,108158.86870162336,79591.339825851595,60682.968490124033,50564.661817979671,41734.407792386133,null,950847.62405379023]
["WA146",null,null,null,null,null,1614824.3437344171,1704318.7543243538,1861482.8621015169,2552504.954488303,2731334.1785123935,3231444.7220111163,3503435.2838310488,2915517.9211498541,2936559.7151487572,2400940.3557914756,2084993.7921222211,1810389.4969431651,null,29347746.380158622]
["WA148",null,null,null,null,null,3272157,3407902,3472603,4046445,4355432,4709037,4797603,4318999,4344578,3924903,3598917,3491074,null,47739650]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T15:T21)","v":252429196.9052366}]
[]
[null,null,null,null,null,null,"2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01",null,"Annual"]
[null,null,null,null,null,null,2382505.8500252739,2726187.3413235671,7813140.1060121823,14724702.558143053,20919815.084402364,20754124.23687312,17083215.099112578,14672743.703363501,9302012.469644621,5272642.0737331426,3269929.2673760266,2503113.7464417168,null,{"$f":"SUM(G25:R25)","v":121424131.53645115}]
[null,null,null,null,null,null,1370674.1112940607,1743524.0743583071,4156430.0978646073,6271826.3113280721,7784391.3028813526,7522685.4006127045,6254332.8744894061,5467385.6317083649,3620529.9241601545,2240995.8953844355,1600360.7678630196,1290293.6456406808,null,{"$f":"SUM(G26:R26)","v":49323430.037585169}]
[null,null,null,null,null,null,369882.16347352543,389233.82574263983,677692.02061458037,717900.68829194573,689880.52137045178,638378.54659301334,555845.69403725909,520168.75648937997,392982.40505712363,315637.02750747011,316661.69469821517,325350.89886638295,null,5909614.242741988]
[null,null,null,null,null,null,28985.907454890894,29010.983689920045,69528.032706353464,104236.86697702721,136976.75155183821,127051.02711070004,117864.10210448205,107748.35418732991,79563.372560549586,60657.15287015168,50094.738590880777,42246.792070750947,null,953964.08187487477]
[null,null,null,null,null,null,1622602.8393433923,1713150.749634997,1871149.8910683426,2563087.1091650268,2742592.0976233408,3242869.0157049587,3514583.4739140309,2923818.0635665972,2942858.1490322985,2406604.3096446763,2090991.5247326605,1816495.9640500718,null,29450803.187480394]
[null,null,null,null,null,null,3320518,3456088,3520570,4094156,4402860,4756082,4844249,4365230,4390387,3970281,3643858,3535571,null,48299850]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T25:T31)","v":255361793.08613357}]