{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","GI","Staff ","JPS-1","Schedule","Sheet3","GI-1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":20,"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":"Cover","index":0,"n_rows":90,"n_cols":5,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"'[3]ROO INPUT'!A3:C3","v":"AVISTA UTILITIES"}]
[{"$f":"'[3]ROO INPUT'!A4:C4","v":"WASHINGTON NATURAL GAS RESULTS "}]
[{"$f":"'[3]ROO INPUT'!A5:C5","v":"TWELVE MONTHS ENDED DECEMBER 31, 2011"}]
[{"$f":"'[3]ROO INPUT'!A6:C6","v":"(000'S OF DOLLARS)   "}]
[]
[]
[null,null,null,null,"Gas Inventory"]
["Line",null,null,null,"& JP "]
["No.",null,null,"DESCRIPTION","Restating"]
[null,"Adjsutment Number",null,null,1.03]
[null,"Workpaper Reference",null,null,"G-GI"]
[]
[null,"REVENUES"]
[1,"Total General Business",null,null,0]
[2,"Total Transportation",null,null,0]
[3,"Other Revenues",null,null,0]
[4,"Total Gas Revenues",null,null,{"$f":"SUM(E15:E17)","v":0}]
[]
[null,"EXPENSES"]
[null,"Production Expenses"]
[5,null,"City Gate Purchases",null,{"$f":"+(ROUND(GI!F9/1000,0))","v":88}]
[6,null,"Purchased Gas Expense",null,0]
[7,null,"Net Nat Gas Storage Trans",null,0]
[8,"Total Production",null,null,{"$f":"SUM(E22:E24)","v":88}]
[]
[null,"Underground Storage",null,null,{"$f":"+E23-E25","v":-88}]
[9,null,"Operating Expenses"]
[10,null,"Depreciation/Amortization"]
[11,null,"Taxes",null,0]
[12,"Total Underground Storage",null,null,{"$f":"SUM(E28:E30)","v":0}]
[]
[null,"Distribution"]
[13,null,"Operating Expenses",null,0]
[14,null,"Depreciation/Amortization",null,0]
[15,null,"Taxes",null,0]
[16,"Total Distribution",null,null,{"$f":"SUM(E34:E36)","v":0}]
[]
[17,"Customer Accounting",null,null,0]
[18,"Customer Service & Information",null,null,0]
[19,"Sales Expenses",null,null,0]
[]
[null,"Administrative & General"]
[20,null,"Operating Expenses",null,0]
[21,null,"Depreciation/Amortization",null,0]
[22,null,"Regulatory Amortizations"]
[23,null,"Taxes",null,0]
[24,"Total Admin. & General",null,null,{"$f":"SUM(E44:E47)","v":0}]
[25,"Total Gas Expense",null,null,{"$f":"E21+E25+E31+E37+E39+E40+E41+E48","v":88}]
[]
[26,"OPERATING INCOME BEFORE FIT",null,null,{"$f":"E18-E49","v":-88}]
[]
[null,"FEDERAL INCOME TAX"]
[27,"Current Accrual",null,null,{"$f":"ROUND(E51*0.35,0)","v":-31}]
[28,"Debt Interest",null,null,{"$f":"ROUND(+E76*3.08%*-35%,0)","v":116}]
[29,"Deferred FIT",null,null,0]
[30,"Amort ITC"]
[]
[31,"NET OPERATING INCOME",null,null,{"$f":"ROUND(E51-SUM(E54:E57),0)","v":-173}]
[]
[null,"RATE BASE"]
[null,"PLANT IN SERVICE"]
[32,null,"Underground Storage",null,0]
[33,null,"Distribution Plant",null,0]
[34,null,"General Plant",null,0]
[35,"Total Plant in Service",null,null,{"$f":"SUM(E63:E65)","v":0}]
[]
[null,"ACCUMULATED DEPRECIATION/AMORT"]
[36,null,"Underground Storage",null,0]
[37,null,"Distribution Plant",null,0]
[38,null,"General Plant",null,0]
[39,"Total Accumulated Depreciation/Amortization",null,null,{"$f":"SUM(E69:E71)","v":0}]
[40,"NET PLANT",null,null,{"$f":"E66-E72","v":0}]
[41,"DEFERRED TAXES",null,null,0]
[42,"Net Plant After DFIT",null,null,{"$f":"E73+E74","v":0}]
[43,"GAS INVENTORY",null,null,{"$f":"-ROUND(GI!E25/1000,0)","v":-10773}]
[44,"GAIN ON SALE OF BUILDING",null,null,0]
[45,"OTHER"]
[46,"WORKING CAPITAL ",null,null,0]
[]
[]
[47,"TOTAL RATE BASE",null,null,{"$f":"E75+E76+E77+E79+E78","v":-10773}]
[48,"RATE OF RETURN"]
[49,"REVENUE REQUIREMENT",null,null,{"$f":"E90","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Pro Forma Rate of Return"]
[null,null,null,"Revenue Conversion Factor"]
[]
[null,null,null,"NOI Requirement",{"$f":"E82*$E$86-E59","v":173}]
[null,null,null,"Revenue Requirement",{"$f":"E89/$E$87","v":{"$error":"#DIV/0!"}}]

{"sheet":"GI","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Avista","Staff"]
["WA Pro Forma Period: (01/01/2013-12/31/2013",null,"Total System Adjustment",null,"Total Washington Adjustment","Total Washington Adjustment","Total           Idaho Adjustment"]
["System Contract Demand Allocation Percentages",null,"GDAN",null,0.69579999999999997,0.69579999999999997,{"$f":"1-E3","v":0.30420000000000003}]
[]
["Jackson Prairie"]
["2011  O & M","GI-1",{"$f":"433103+394503","v":827606},null,{"$f":"C6*E3","v":575848.2548},{"$f":"+C6*F3","v":575848.2548}]
["2013 O & M - Avista","GI-1",{"$f":"'[4]GI-1'!O142+'[4]GI-1'!O137","v":1115327.4290221953},null,{"$f":"C7*E3","v":776044.82511364343},null,{"$f":"C7*G3","v":339282.60390855186}]
["2014 O & M - Staff","GI-2",{"$f":"+'Staff '!T13","v":954730.20146674151},null,null,{"$f":"+C8*F3","v":664301.27418055874},{"$f":"C6*G3","v":251757.74520000003}]
["2013 Pro Forma O&M Adjustment",null,null,null,{"$f":"+E7-E6","v":200196.57031364343},{"$f":"+F8-F6","v":88453.019380558748},{"$f":"G7-G8","v":87524.858708551823}]
[]
["Net Income Before Taxes",null,null,null,{"$f":"E9","v":200196.57031364343},{"$f":"F9","v":88453.019380558748},{"$f":"G9","v":87524.858708551823}]
[]
["Idaho State Income Taxes",1.8797000000000001E-2,null,null,null,null,{"$f":"G11*B13","v":1645.2047691446487}]
[]
["Net Income before FIT",null,null,null,{"$f":"E11","v":200196.57031364343},{"$f":"F11","v":88453.019380558748},{"$f":"G11-G13","v":85879.653939407173}]
[]
["Federal Income Tax",0.35,null,null,{"$f":"E15*B17","v":70068.799609775189},{"$f":"+F15*B17","v":30958.55678319556},{"$f":"G15*B17","v":30057.878878792508}]
[]
["Net Reduction to Income",null,null,null,{"$f":"E15-E17","v":130127.77070386824},{"$f":"F15-F17","v":57494.462597363192},{"$f":"G15-G17","v":55821.775060614666}]
[]
[]
["Per Inventory Workpaper:"]
[null,"Dec 2013 AMA -->",16415871.883348474,null,11422163.389879497,0]
[]
[null,"Dec 2011 AMA -->",15482583,null,10772781,0]
[]
[null,null,null,null,{"$f":"+E23-E25","v":649382.38987949677},{"$f":"-E25","v":-10772781}]
[null,null,null,null,null,"moved to working Capital"]
[null,null,null,null,"JPS-1","JPS-1"]

{"sheet":"Staff ","index":2,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Transaction Analysis  Selection: Accounting Period : '2011%' , Organization : 'J06'"]
[]
["Expenditure Organization:J06","Report Category:OPER","Summary Exp Category:Non-Labor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"System","WA"]
[null,null,null,null,null,null,"Accounting Period","201101","201102","201103","201104","201105","201106","201107","201108","201109","201110","201111","201112","Total"]
["Actual","Project Number","Task Number","Vendor Name","Service Desc","Jurisdiction"]
["2011 O&M","54502100","824000","NULL","Gas Direct","AN",null,30316.940000000002,32294.98,24924.77,27010.55,38372.46,52406.94,26609.68,63844.49,57889.04,-3430.04,21272.97,61590.06,433102.84,null,"workpaper 1.03-4"]
[null,"54502101","837000","NULL","Gas Direct","AN",null,36432.28,24305.07,20062.09,23569.29,49618.35,69606.06,3219.44,31613.18,56194.98,11571.380000000001,32736.600000000002,35574.17,394502.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T7+T8","v":827605.73}]
["Staff proposed"]
["2013 O&M","54502100","824000","NULL","Gas Direct","AN",null,45156.150466950705,46102.891173109165,43566.978567327584,52865.324788526712,38372.46,52406.94,26609.68,63844.49,57889.04,-3430.04,21272.97,61590.06,{"$f":"SUM(H11:S11)","v":506246.94499591418}]
[null,"54502101","837000","NULL","Gas Direct","AN",null,38096.778659122661,38895.513067550542,36756.04590211872,44600.7588420354,49618.35,69606.06,3219.44,31613.18,56194.98,11571.380000000001,32736.600000000002,35574.17,{"$f":"SUM(H12:S12)","v":448483.25647082727}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 month O & M",null,{"$f":"SUM(T11:T12)","v":954730.20146674151}]
[]
[]
[]
["Avista proposed",null,null,null,null,null,null,201301,201301,201301,201301,201301,201301,201301,201301,201301,201301,201301,201301]
["2013 Budgeted O&M","54502100","824000","NULL","Gas Direct","AN",null,45156.150466950705,46102.891173109165,43566.978567327584,52865.324788526712,48469.742938505311,63008.975211653036,46779.134534650919,54978.585293344702,51005.655544286892,50667.533863516015,44581.343609640215,57768.089159704447,{"$f":"SUM(H18:S18)","v":604950.40515121561}]
[null,"54502101","837000","NULL","Gas Direct","AN",null,38096.778659122661,38895.513067550542,36756.04590211872,44600.7588420354,40892.349088620242,53158.627503762691,39466.037644999022,46383.648146561922,43031.816254052064,42746.553965327817,37611.832768291446,48737.062028536922,{"$f":"SUM(H19:S19)","v":510377.02387097944}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T18:T19)","v":1115327.4290221951}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Avista Adjustment",null,null,null,null,"(1,115,327-827,606)",null,null,null,{"$f":"+T20-T9","v":287721.69902219507},{"$f":"+T23*GI!E3","v":200196.75817964331},"matched"]
[null,null,null,null,null,null,null,null,null,null,"Staf Adjustment (incremental increase from Jan to Apr., which is 954,730-820,606)",null,null,null,null,null,null,null,null,{"$f":"+SUM(H18:K19)-SUM(H7:K8)","v":127124.47146674147},{"$f":"+T24*GI!E3","v":88453.207246558712}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"workpaper 1.03-2"]
[]
[null,null,null,null,{"$f":"+E23-E25","v":0}]

{"sheet":"JPS-1","index":3,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"Estimated Inventory"]
[null,"WA/ID"]
[null,null,"Volumes - Dth",null,null,null,"Avg. Cost in","Ending $",null,"WA","ID"]
[null,null,"Beg. Inv.","Inject/(Withdr)","End. Inv.","WACOG","Inventory","Inventory",null,{"$f":"J30/H30","v":0.69579998376239938},{"$f":"1-J4","v":0.30420001623760062}]
[]
[{"$f":"MONTH(B6)","v":4},"2012-04-01",0,{"$f":"SUM(INDEX($E$58:$F$69,$A6,0))","v":1230000},{"$f":"ROUND(C6+D6,0)","v":1230000},{"$f":"J36","v":3.0939999999999999},{"$f":"IF(E6,SUMPRODUCT(D6:D$6,F6:F$6)/E6,0)","v":3.0939999999999999},{"$f":"E6*G6","v":3805620},null,{"$f":"$H6*J$4","v":2647950.3342058621},1157669.6657941376]
[{"$f":"MONTH(B7)","v":5},"2012-05-01",{"$f":"E6","v":1230000},{"$f":"SUM(INDEX($E$58:$F$69,$A7,0))","v":1271000},{"$f":"ROUND(C7+D7,0)","v":2501000},{"$f":"J37","v":3.048},{"$f":"SUMPRODUCT(D$6:D7,F$6:F7)/E7","v":3.0706229508196721},{"$f":"E7*G7","v":7679628},null,5343485.0377012677,2336142.9622987323]
[6,"2012-06-01",{"$f":"E7","v":2501000},{"$f":"SUM(INDEX($E$58:$F$69,$A8,0))","v":1260000},3761000,{"$f":"J38","v":3.0819999999999999},{"$f":"SUMPRODUCT(D$6:D8,F$6:F8)/E8","v":3.0744344589204999},{"$f":"E8*G8","v":11562948},null,8045499.0306454683,3517448.9693545317]
[7,"2012-07-01",{"$f":"E8","v":3761000},1302000,5063000,3.2119999999999997,{"$f":"SUMPRODUCT(D$6:D9,F$6:F9)/E9","v":3.109810784120087},15744972,null,{"$f":"$H9*J$4","v":10955351.261939432},4789620.7380605675]
[8,"2012-08-01",{"$f":"E9","v":5063000},1333000,6396000,3.254,{"$f":"SUMPRODUCT(D$6:D10,F$6:F10)/E10","v":3.1398614759224515},20082554,null,13973440.74710751,6109113.2528924914]
[9,"2012-09-01",6396000,1308666.9999999991,7704667,3.2439999999999998,{"$f":"SUMPRODUCT(D$6:D11,F$6:F11)/E11","v":3.1575498004001985},24327869.747999996,null,16927331.375632163,7400538.3723678319]
[10,"2012-10-01",7704667,0,7704667,null,{"$f":"G11","v":3.1575498004001985},24327869.747999996,null,16927331.375632163,7400538.3723678319]
[11,"2012-11-01",7704667,0,7704667,null,3.1575498004001985,24327869.747999996,null,16927331.375632163,7400538.3723678319]
[12,"2012-12-01",7704667,{"$f":"SUM(INDEX($E$75:$F$86,$A14,0))","v":-1395000},6309667,null,3.1575498004001985,19923087.776441719,null,{"$f":"$H14*J$4","v":13862484.151345005},6060603.6250967132]
[1,"2013-01-01",6309667,-2635000,3674667,null,3.1575498004001985,11602944.052387197,null,{"$f":"$H15*J$4","v":8073328.2832470397},3529615.7691401569]
[2,"2013-02-01",3674667,-2100000,1574667,null,3.1575498004001985,4972089.4715467794,null,3459579.773567446,1512509.6979793333]
[3,"2013-03-01",1574667,-1574666.9999994,0,null,{"$f":"G16","v":3.1575498004001985},0,null,0,0]
[4,"2013-04-01",0,1230000,1230000,{"$f":"J49","v":3.71},{"$f":"IF(E18,SUMPRODUCT(D$18:D18,F$18:F18)/E18,0)","v":3.71},4563300,null,{"$f":"$H18*J$4","v":3175144.0659029572},1388155.934097043]
[5,"2013-05-01",1230000,1271000,2501000,{"$f":"J50","v":3.722},{"$f":"SUMPRODUCT(D$18:D19,F$18:F19)/E19","v":3.7160983606557378},{"$f":"E19*G19","v":9293962},null,6466738.6086883573,2827223.3913116432]
[6,"2013-06-01",2501000,1260000,3761000,3.734,{"$f":"SUMPRODUCT(D$18:D20,F$18:F20)/E20","v":3.7220957192236108},13998802,null,9740366.2042930443,4258435.7957069557]
[7,"2013-07-01",3761000,1302000,5063000,3.8319999999999999,{"$f":"SUMPRODUCT(D$18:D21,F$18:F21)/E21","v":3.750358680624136},18988066,null,13211896.014479367,5776169.985520632]
[8,"2013-08-01",5063000,1333000,6396000,3.8460000000000001,{"$f":"SUMPRODUCT(D$18:D22,F$18:F22)/E22","v":3.7702914321450907},24114784,null,16779066.31563377,7335717.6843662318]
[9,"2013-09-01",6396000,1308666.9999998999,7704667,3.8719999999999999,{"$f":"SUMPRODUCT(D$18:D23,F$18:F23)/E23","v":3.7875670193143467},29181942.623999611,null,20304795.2039342,8877147.4200654104]
[10,"2013-10-01",7704667,0,7704667,null,{"$f":"G23","v":3.7875670193143467},29181942.623999611,null,20304795.2039342,8877147.4200654104]
[11,"2013-11-01",7704667,0,{"$f":"ROUND(C25+D25,0)","v":7704667},null,{"$f":"G24","v":3.7875670193143467},29181942.623999611,null,20304795.2039342,8877147.4200654104]
[12,"2013-12-01",7704667,{"$f":"SUM(INDEX($E$75:$F$86,$A26,0))","v":-1395000},6309667,null,{"$f":"G25","v":3.7875670193143467},{"$f":"E26*G26","v":23898286.632056095},null,16628427.450533796,7269859.1815222977]
[]
[null,null,null,null,null,"Dec 2013 AMA -->",null,{"$f":"(0.5*H14+0.5*H26+SUM(H15:H25))/12","v":16415871.883348474},null,{"$f":"(0.5*J14+0.5*J26+SUM(J15:J25))/12","v":11422163.389879497}]
[null,null,null,null,null,"Jun 2013 AMA -->",null,{"$f":"(0.5*H8+0.5*H20+SUM(H9:H19))/12","v":14328949.462031307},null,null,{"$f":"(0.5*K8+0.5*K20+SUM(K9:K19))/12","v":4358866.6590176821}]
[null,null,null,"less:",null,"Dec 2011 AMA -->",null,{"$f":"J30+K30","v":15482583},null,10772781,4709802]
[null,null,null,null,null,"Difference",null,null,null,{"$f":"J28-J30","v":649382.38987949677},{"$f":"K29-K30","v":-350935.34098231792}]
[null,null,null,null,null,"in $000's",null,null,null,{"$f":"ROUND(J31/1000,0)","v":649},{"$f":"ROUND(K31/1000,0)","v":-351}]
[]
[null,null,"60-dy avg fwd price+adders, 2-15-2012",null,null,"Weighting"]
[null,null,"AECO","Sumas","Rockies","AECO","Sumas","Rockies",null,"WACOG"]
[null,{"$f":"B6","v":"2012-04-01"},2.97,3.07,3.13,0,0.6,0.4,null,{"$f":"SUMPRODUCT(C36:E36,F36:H36)","v":3.0939999999999999}]
[null,"2012-05-01",2.97,2.98,3.15,0,0.6,0.4,null,{"$f":"SUMPRODUCT(C37:E37,F37:H37)","v":3.048}]
[null,"2012-06-01",2.98,3.01,3.19,0,0.6,0.4,null,3.0819999999999999]
[null,"2012-07-01",3.01,3.16,3.29,0,0.6,0.4,null,3.2119999999999997]
[null,"2012-08-01",3.05,3.21,3.32,0,0.6,0.4,null,3.254]
[null,"2012-09-01",3.07,3.2,3.31,0,0.6,0.4,null,3.2439999999999998]
[null,"2012-10-01",6.8643416666666663,7.1562000000000019,4.2764499999999996]
[null,"2012-11-01"]
[null,"2012-12-01"]
[null,"2013-01-01"]
[null,"2013-02-01"]
[null,"2013-03-01"]
[null,"2013-04-01",7.0753255813953499,7.2205581395348837,4.8145348837209294,0,0,0,null,{"$f":"SUMPRODUCT(C48:E48,F48:H48)","v":0}]
[null,{"$f":"B18","v":"2013-04-01"},3.6,3.67,3.77,0,0.6,0.4,null,3.71]
[null,"2013-05-01",3.6,3.67,3.8,0,0.6,0.4,null,3.722]
[null,"2013-06-01",3.6,3.67,3.83,0,0.6,0.4,null,3.734]
[null,"2013-07-01",3.64,3.8,3.88,0,0.6,0.4,null,3.8319999999999999]
[null,"2013-08-01",3.62,3.81,3.9,0,0.6,0.4,null,3.8460000000000001]
[null,"2013-09-01",3.68,3.84,3.92,0,0.6,0.4,null,3.8719999999999999]
[]
[null,null,"Daily",null,"Monthly","Monthly"]
[null,null,"Amount","Days","Injection","Withdrawal"]
[null,"2012-01-01",-85000,31,{"$f":"MAX(C58,0)*D58","v":0},{"$f":"MIN(C58,0)*D58","v":-2635000}]
[null,"2012-02-01",-75000,28,{"$f":"MAX(C59,0)*D59","v":0},{"$f":"MIN(C59,0)*D59","v":-2100000}]
[null,"2012-03-01",-50795.709677400002,31,0,-1574666.9999994]
[null,"2012-04-01",41000,30,{"$f":"MAX(C61,0)*D61","v":1230000},0]
[null,"2012-05-01",41000,31,1271000,0]
[null,"2012-06-01",42000,30,1260000,0]
[null,"2012-07-01",42000,31,1302000,0]
[null,"2012-08-01",43000,31,1333000,0]
[null,"2012-09-01",{"$f":"43622.2333333333","v":43622.233333333301},30,1308666.9999999991,0]
[null,"2012-10-01",0,31,0,0]
[null,"2012-11-01",0,30,0,0]
[null,"2012-12-01",-45000,31,0,-1395000]
[null,null,null,null,{"$f":"SUM(E58:E69)","v":7704666.9999999991},{"$f":"SUM(F58:F69)","v":-7704666.9999994002}]
[]
[]
[null,null,"Daily",null,"Monthly","Monthly"]
[null,null,"Amount","Days","Injection","Withdrawal"]
[null,"2013-01-01",-85000,31,{"$f":"MAX(C75,0)*D75","v":0},{"$f":"MIN(C75,0)*D75","v":-2635000}]
[null,"2013-02-01",-75000,28,{"$f":"MAX(C76,0)*D76","v":0},{"$f":"MIN(C76,0)*D76","v":-2100000}]
[null,"2013-03-01",-50795.709677400002,31,0,-1574666.9999994]
[null,"2013-04-01",41000,30,1230000,0]
[null,"2013-05-01",41000,31,1271000,0]
[null,"2013-06-01",42000,30,1260000,0]
[null,"2013-07-01",42000,31,1302000,0]
[null,"2013-08-01",43000,31,1333000,0]
[null,"2013-09-01",43622.233333329998,30,1308666.9999998999,0]
[null,"2013-10-01",0,31,0,0]
[null,"2013-11-01",0,30,0,0]
[null,"2013-12-01",-45000,31,0,-1395000]
[null,null,null,null,{"$f":"SUM(E75:E86)","v":7704666.9999998994},{"$f":"SUM(F75:F86)","v":-7704666.9999994002}]

{"sheet":"Schedule","index":4,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,4]]}
["WA/ID JP Inventory Synthetic Schedule"]
["Source: Gas Supply"]
[]
[null,"Injection","Withdrawal","End of Month Balance"]
["2012-02-01",null,null,{"$f":"B5+C5","v":0}]
["2012-03-01",null,null,0]
["2012-04-01",{"$f":"41000*30","v":1230000},null,{"$f":"B7+C7","v":1230000}]
["2012-05-01",{"$f":"41000*31","v":1271000},null,{"$f":"+D7+B8+C8","v":2501000}]
["2012-06-01",{"$f":"42000*30","v":1260000},null,{"$f":"+D8+B9+C9","v":3761000}]
["2012-07-01",{"$f":"42000*31","v":1302000},null,5063000]
["2012-08-01",{"$f":"43000*31","v":1333000},null,6396000]
["2012-09-01",{"$f":"(43000*30)+18667","v":1308667},null,7704667]
["2012-10-01",null,null,7704667]
["2012-11-01",null,null,7704667]
["2012-12-01",null,{"$f":"-45000*31","v":-1395000},6309667]
["2013-01-01",null,{"$f":"-85000*31","v":-2635000},3674667]
["2013-02-01",null,{"$f":"-75000*28","v":-2100000},1574667]
["2013-03-01",null,{"$f":"-45000*31-179667","v":-1574667},0]
["2013-04-01",{"$f":"41000*30","v":1230000},null,1230000]
["2013-05-01",{"$f":"41000*31","v":1271000},null,2501000]
["2013-06-01",{"$f":"42000*30","v":1260000},null,3761000]
["2013-07-01",{"$f":"42000*31","v":1302000},null,5063000]
["2013-08-01",{"$f":"43000*31","v":1333000},null,6396000]
["2013-09-01",{"$f":"(43000*30)+18667","v":1308667},null,7704667]
["2013-10-01",null,null,7704667]
["2013-11-01",null,null,7704667]
["2013-12-01",null,{"$f":"-45000*31","v":-1395000},6309667]
[]
["* Injections are spread ratably over the injection season and withdrawals are scheduled based on pricing, peak day demand requirements and decline curve considerations.  This schedule is synthetic and actuals can differ based on market conditions and variability in actual demand."]

{"sheet":"Sheet3","index":5,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,4,3,16]]}
[]
["Transaction Analysis  Selection: Organization : 'J06' , Summary Exp Category Parameter 1 : 'Non-Labor'"]
[]
["Expenditure Organization:J06","Report Category:OPER","Summary Exp Category:Non-Labor",null,"* 2005-2010 JACKSON PRAIRIE O & M EXPENSES"]
[]
[null,"*Data not available for periods prior to 2005 in query system."]
[0,0,0,0,"Transaction Amount"]
[null,null,null,null,"200501","200502","200503","200504","200505","200506","200507","200508","200509","200510","200511","200512","TOTAL"]
["Project Number","Task Number","Service Desc","Jurisdiction"]
[null,"824000","Gas Direct","AN",46973.71,14889.32,22166.84,25787.65,15375.800000000001,19117.32,18478.59,26654.52,21927.4,17635.990000000002,17111.580000000002,24483.96,{"$f":"SUM(E10:P10)","v":270602.68}]
["54502101","837000","Gas Direct","AN",40076.14,16051.4,16423.28,20987.98,17480.68,37248.31,20765.100000000002,18283.72,16668.18,21380.53,33205.89,42966.66,{"$f":"SUM(E11:P11)","v":301537.87}]
["Total",null,null,null,87049.85,30940.720000000001,38590.120000000003,46775.63,32856.480000000003,56365.630000000005,39243.69,44938.239999999998,38595.58,39016.520000000004,50317.47,67450.62,{"$f":"SUM(E12:P12)","v":572140.55000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",{"$f":"Q10+Q11","v":572140.55000000005}]
[]
[0,0,0,0]
[null,null,null,null,"200601","200602","200603","200604","200605","200606","200607","200608","200609","200610","200611","200612","TOTAL"]
["Project Number","Task Number","Service Desc","Jurisdiction"]
[null,"824000","Gas Direct","AN",59497.68,21398.959999999999,17474.349999999999,29932.55,10065.85,28784.77,12955.130000000001,57767.41,-5816.45,17662.400000000001,0,0,{"$f":"SUM(E18:P18)","v":249722.64999999997}]
["54502101","837000","Gas Direct","AN",58356.340000000004,39478.79,20741.97,37272.43,70915.100000000006,12711.07,17502.7,-9701.6,16799.670000000002,12208.54,28743.95,21248.170000000002,{"$f":"SUM(E19:P19)","v":326277.13}]
["Total",null,null,null,117854.02,60877.75,38216.32,67204.98,80980.95,41495.840000000004,30457.83,48065.81,10983.22,29870.940000000002,42947.67,63593.770000000004,{"$f":"SUM(E20:P20)","v":632549.10000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",{"$f":"Q18+Q19+#REF!","v":{"$error":"#REF!"}}]
[]
[0,0,0,0]
[null,null,null,null,"200701","200702","200703","200704","200705","200706","200707","200708","200709","200710","200711","200712","TOTAL"]
["Project Number","Task Number","Service Desc","Jurisdiction"]
[null,"824000","Gas Direct","AN",24432.36,21209.79,17592.75,25131.200000000001,26832.07,26030.959999999999,25942.34,38935.5,20905.72,22033.32,10273.77,43856.92,{"$f":"SUM(E26:P26)","v":303176.7}]
["54502101","837000","Gas Direct","AN",37744.99,19833.100000000002,18541.07,30309.63,65768.78,-7660.9400000000005,29913.89,19491.91,18671.89,24336.11,17286.64,22872.05,{"$f":"SUM(E27:P27)","v":297109.12}]
["Total",null,null,null,62177.35,41042.89,36133.82,55440.83,92600.85,18370.02,55856.23,58427.41,39577.61,46369.43,27560.41,66728.97,{"$f":"SUM(E28:P28)","v":600285.81999999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",{"$f":"Q26+Q27","v":600285.82000000007}]
[]
[0,0,0,0]
[null,null,null,null,"200801","200802","200803","200804","200805","200806","200807","200808","200809","200810","200811","200812","TOTAL"]
["Project Number","Task Number","Service Desc","Jurisdiction"]
[null,"824000","Gas Direct","AN",25150.21,23150.05,27670.2,22726.66,23711.439999999999,25079.29,23086.33,47860.78,0,24619.14,25638.95,53436,{"$f":"SUM(E34:P34)","v":322129.05}]
["54502101","837000","Gas Direct","AN",22033.78,22537.16,19542,25191.940000000002,22453.79,53990.75,-7621.49,21388.98,15015.960000000001,22996.15,29633.03,24845.16,{"$f":"SUM(E35:P35)","v":272007.21000000002}]
["Total",null,null,null,47183.99,45687.21,47212.200000000004,57835.25,55620.76,88601.12,25177.34,79540.44,22251.69,56369.64,67442.75,89656.66,{"$f":"SUM(E36:P36)","v":682579.05}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",{"$f":"Q34+Q35","v":594136.26}]
[]
[0,0,0,0]
[null,null,null,null,"200901","200902","200903","200904","200905","200906","200907","200908","200909","200910","200911","200912","TOTAL"]
["Project Number","Task Number","Service Desc","Jurisdiction"]
[null,"824000","Gas Direct","AN",40853.68,30267.73,19677.84,21046.54,-15965.880000000001,25686.09,17793.96,37994.450000000004,18412.09,22512.52,13242.550000000001,46225.62,{"$f":"SUM(E42:P42)","v":277747.19}]
["54502101","837000","Gas Direct","AN",43164.92,17354.490000000002,23434.5,31165.54,-9738.27,50882.62,-8652.2900000000009,21809.760000000002,30253.87,37210.9,23461.850000000002,38041.120000000003,{"$f":"SUM(E43:P43)","v":298389.01}]
["Total",null,null,null,100993.12,54877.37,53007.64,64606.12,64858.67,106527.02,32781.54,87190.81,85469.26,98386.67,63102.48,124637.96,{"$f":"SUM(E44:P44)","v":936438.66}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AN",{"$f":"Q42+Q43","v":576136.19999999995}]
[]
[0,0,0,0]
[null,null,null,null,"201001","201002","201003","201004","201005","201006","201007","201008","201009","201010","201011","201012","TOTAL"]
["Project Number","Task Number","Service Desc","Jurisdiction"]
[null,"824000","Gas Direct","AN",8681.48,23108.639999999999,28286.33,21348.240000000002,27889.24,24308.06,19116.920000000002,45422.9,11317.53,19400.66,16237.26,31510.58,{"$f":"SUM(E50:P50)","v":276627.84000000003}]
["54502101","837000","Gas Direct","AN",10544.07,17282.670000000002,24492.41,28394.2,23178.57,39392.42,4117.3,21660.89,23252.89,22533.25,27648.62,27354.05,{"$f":"SUM(E51:P51)","v":269851.34000000003}]
["Total",null,null,null,{"$f":"SUM(E50:E51)","v":19225.55},40391.31,52778.740000000005,49742.44,51067.81,63700.479999999996,23234.22,67083.790000000008,34570.42,41933.910000000003,43885.88,58864.630000000005,546479.18000000005]

{"sheet":"GI-1","index":6,"n_rows":147,"n_cols":16,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
["JACKSON PRAIRIE O&M BUDGET - 2012 - 100% -Draft"]
["Prepared 6-8-11   Rev 1"]
[]
["LABOR SUMMARY",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Labor Actual",null,138690,138690,138690,138690,138690,138690,138690,138690,138690,138690,138690,138690,1664279.9999999998]
["Subtotal Labor",null,138690,138690,138690,138690,138690,138690,138690,138690,138690,138690,138690,138690,1664280]
[]
["LABOR OVERHEAD"]
["Labor OH Actual",null,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,1081782]
["Subtotal Labor Overhead",null,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,90148.5,1081782]
["Subtotal Labor & Overhead",null,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,228838.5,2746062]
[]
["CONSUMABLES"]
["Materials - Direct Purchases",null,10350,10350,10350,10350,19665,25874.999999999996,10350,10350,55889.999999999993,34155,10350,10350,218384.99999999997]
["Materials - Stores Issues",null,310.5,310.5,310.5,310.5,310.5,310.5,310.5,310.5,310.5,310.5,310.5,310.5,3725.9999999999995]
["Materials - Stores Overhead",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Materials Direct & Stores",null,10660.5,10660.5,10660.5,10660.5,19975.5,26185.499999999996,10660.5,10660.5,56200.499999999993,34465.5,10660.5,10660.5,222111]
["Office & Station Supplies",null,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,13454.999999999998,161460]
["Legal Expenses",null,310.5,310.5,310.5,310.5,310.5,310.5,9625.5,310.5,310.5,310.5,310.5,310.5,13040.999999999998]
["Outside Services",null,7762.4999999999991,23287.5,7762.4999999999991,18112.5,28462.499999999996,111262.49999999999,7762.4999999999991,9315,7762.4999999999991,27427.499999999996,7762.4999999999991,7762.4999999999991,264442.5]
["Regulatory Fees & Permits",null,4554,0,0,0,0,0,0,68310,0,0,0,0,72864]
["Employee Expenses",null,1035,1035,1035,1035,1035,1035,1035,1035,1035,1035,1035,1035,12419.999999999998]
["Employee Training",null,1035,1035,1035,1035,1035,1035,1035,1035,1035,1035,1035,1035,12419.999999999998]
["Rent/Lease",null,0,0,0,0,0,0,0,0,0,0,0,86940,86940]
["Miscellaneous",null,2070,2070,2070,48644.999999999993,2070,2070,2070,2070,2070,2070,2070,2070,71415]
["Vehicle Costs",null,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,1552.4999999999998,18630]
["Advertising",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hardware & Software",null,5175,0,0,0,0,0,10350,0,0,0,6209.9999999999991,0,21735]
["Service Provider Planning",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Corp/Organization Dues",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Membership/Donate/Sponsor",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OH Small Tools",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal Consumables",null,47610,53406,37881,94806,67896,156905.99999999997,57546,107743.5,83420.999999999985,81351,44091,124821,957478.5]
[]
["Subtotal Labor & OH, Consumables",null,276448.5,282244.5,266719.5,323644.5,296734.5,385744.5,286384.5,336582,312259.5,310189.5,272929.5,353659.5,3703540.5]
["Planning Cost Element"]
["Subtotal Labor & OH, Consumables, Planning CE"]
[]
["OTHER"]
["Construction Overhead"]
["Depreciation"]
["Amortization"]
["CIAC"]
["CLX/C.A.R.S. System"]
["Energy Procurement"]
["Low Income"]
["Not Assigned/Unassigned CE's"]
["Other Income"]
["Other Operating Revenues"]
["Settlement CE For Reporting"]
["Taxes"]
["Subtotal Other"]
[]
["TOTAL EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,3703540.5]
["AFUDC"]
["Total Expenses with AFUDC"]
[]
["TRANSFER TO FORECAST CALCULATIONS"]
["Internal Expenses for Construction OH"]
["External Expenses for Construction OH"]
["Total Expenses without Depreciation & Amortization"]
[]
[]
[]
[]
[]
[]
[]
["JACKSON PRAIRIE O&M BUDGET - 2013 - 1/3 SHARE"]
["Prepared 6-8-11"]
[]
["LABOR SUMMARY",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
["Labor Actual",null,46230,46230,46230,46230,46230,46230,46230,46230,46230,46230,46230,46230,554759.99999999988]
["Subtotal Labor",null,46230,46230,46230,46230,46230,46230,46230,46230,46230,46230,46230,46230,554759.99999999988]
[]
["LABOR OVERHEAD"]
["Labor OH Actual",null,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,360594]
["Subtotal Labor Overhead",null,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,30049.5,360594]
["Subtotal Labor & Overhead",null,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,76279.5,915354]
[]
["CONSUMABLES"]
["Materials - Direct Purchases",null,3450,3450,3450,3450,6555,8624.9999999999982,3450,3450,18629.999999999996,11385,3450,3450,72794.999999999985]
["Materials - Stores Issues",null,103.5,103.5,103.5,103.5,103.5,103.5,103.5,103.5,103.5,103.5,103.5,103.5,1241.9999999999998]
["Materials - Stores Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Materials Direct & Stores",null,3553.5,3553.5,3553.5,3553.5,6658.5,8728.4999999999982,3553.5,3553.5,18733.499999999996,11488.5,3553.5,3553.5,74037]
["Office & Station Supplies",null,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,4484.9999999999991,53820]
["Legal Expenses",null,103.5,103.5,103.5,103.5,103.5,103.5,3208.5,103.5,103.5,103.5,103.5,103.5,4346.9999999999991]
["Outside Services",null,2587.4999999999995,7762.5,2587.4999999999995,6037.5,9487.4999999999982,37087.499999999993,2587.4999999999995,3105,2587.4999999999995,9142.4999999999982,2587.4999999999995,2587.4999999999995,88147.5]
["Regulatory Fees & Permits",null,1518,0,0,0,0,0,0,22770,0,0,0,0,24288]
["Employee Expenses",null,345,345,345,345,345,345,345,345,345,345,345,345,4139.9999999999991]
["Employee Training",null,345,345,345,345,345,345,345,345,345,345,345,345,4139.9999999999991]
["Rent/Lease",null,0,0,0,0,0,0,0,0,0,0,0,28980,28980]
["Miscellaneous",null,690,690,690,16214.999999999998,690,690,690,690,690,690,690,690,23805]
["Vehicle Costs",null,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,517.49999999999989,6210]
["Advertising",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hardware & Software",null,1725,0,0,0,0,0,3450,0,0,0,2069.9999999999995,0,7245]
["Service Provider Planning",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Corp/Organization Dues",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Membership/Donate/Sponsor",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OH Small Tools",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal Consumables",null,15869.999999999998,17802,12626.999999999998,31602,22632,52301.999999999985,19182,35914.5,27806.999999999996,27117,14696.999999999998,41607,319159.5]
[]
["Subtotal Labor & OH, Consumables",null,92149.5,94081.5,88906.5,107881.5,98911.5,128581.49999999999,95461.5,112194,104086.5,103396.5,90976.5,117886.5,1234513.5]
["Planning Cost Element"]
["Subtotal Labor & OH, Consumables, Planning CE"]
[]
["OTHER"]
["Construction Overhead"]
["Depreciation"]
["Amortization"]
["CIAC"]
["CLX/C.A.R.S. System"]
["Energy Procurement"]
["Low Income"]
["Not Assigned/Unassigned CE's"]
["Other Income"]
["Other Operating Revenues"]
["Settlement CE For Reporting"]
["Taxes"]
["Subtotal Other"]
[]
["Pipeline Integrity (Pigging)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["TOTAL EXPENSES",null,92149.5,94081.5,88906.5,107881.5,98911.5,128581.49999999999,95461.5,112194,104086.5,103396.5,90976.5,117886.5,1234513.5,499999.99999999977]
[]
["2011 O&M Split"]
["Operations",0.54239713774597498,49981.625044722721,51029.536314847945,48222.631127012522,58514.616815742396,53649.314490161007,69742.23756708407,51778.044364937392,60853.704472271915,56456.219677996422,56081.965652951701,49345.39320214669,63941.30017889088,669596.5889087657]
["Maintenance",0.45760286225402502,42167.874955277279,43051.963685152055,40683.868872987478,49366.883184257604,45262.185509838993,58839.262432915915,43683.455635062608,51340.295527728085,47630.280322003578,47314.534347048299,41631.10679785331,53945.19982110912,564916.9110912343]
["Total",null,92149.5,94081.5,88906.5,107881.5,98911.5,128581.49999999999,95461.5,112194,104086.5,103396.5,90976.5,117886.5,1234513.5]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jurisidictional Split"]
["AN",null,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809,0.90345502825379809]
["OR",null,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2,9.6544971746201941E-2]
["Total",null,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["Operations"]
["AN","54502100 824000",45156.150466950705,46102.891173109165,43566.978567327584,52865.324788526712,48469.742938505311,63008.975211653036,46779.134534650919,54978.585293344702,51005.655544286892,50667.533863516015,44581.343609640215,57768.089159704447,604950.40515121573]
["OR","54502100 824000",4825.4745777720145,4926.6451417387807,4655.6525596849424,5649.2920272156825,5179.5715516556966,6733.2623554310348,4998.9098302864713,5875.1191789272143,5450.5641337095349,5414.43178943569,4764.0495925064779,6173.2110191864367,64646.183757549981]
[null,null,49981.625044722721,51029.536314847945,48222.63112701253,58514.616815742396,53649.314490161007,69742.23756708407,51778.044364937392,60853.704472271915,56456.219677996429,56081.965652951709,49345.39320214669,63941.30017889088,669596.5889087657,0.54239713774597498]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Maintenance"]
["AN","54502101 837000",38096.778659122661,38895.513067550542,36756.04590211872,44600.7588420354,40892.349088620242,53158.627503762691,39466.037644999022,46383.648146561922,43031.816254052064,42746.553965327817,37611.832768291446,48737.062028536922,510377.02387097944]
["OR","54502101 837000",4071.0962961546211,4156.4506176015175,3927.8229708687604,4766.1243422222024,4369.8364212187562,5680.6349291532279,4217.4179900635854,4956.6473811661663,4598.4640679515142,4567.9803817204793,4019.2740295618632,5208.1377925721981,54539.887220254888]
[null,null,42167.874955277279,43051.963685152063,40683.868872987478,49366.883184257604,45262.185509839001,58839.262432915915,43683.455635062608,51340.295527728085,47630.280322003578,47314.534347048299,41631.10679785331,53945.19982110912,564916.9110912343,0.45760286225402502]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL AN",{"$f":"O137+O142","v":1115327.4290221953}]