{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary","Sch 001-002","Sch 011-012","Sch 021-022","Sch 031-032","Inputs","CF"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"Summary","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,4]]}
[]
[]
[]
[null,"Allowable Investment by Customer Class"]
[]
[]
[null,"RESIDENTIAL (SCHEDULE 1-2)"]
[null,null,null,"Terminal"]
[null,null,"Distribution","Facilities","Total"]
[null,"Allowable Investment per Customer",{"$f":"'Sch 001-002'!C32","v":1250},{"$f":"'Sch 001-002'!D32","v":610},{"$f":"SUM(C10:D10)","v":1860}]
[null,"GENERAL SERVICE (SCHEDULE 11-12)*"]
[null,null,null,"Terminal"]
[null,null,"Distribution","Facilities","Total"]
[null,"Allowable Investment per kWh",{"$f":"'Sch 011-012'!C28","v":0.10782971907336089},{"$f":"'Sch 011-012'!D28","v":4.2245042812902936E-2},{"$f":"'Sch 011-012'!E28","v":0.15007476188626384}]
[null,"LARGE GENERAL SERVICE (SCHEDULE 21-22)*"]
[null,null,null,"Terminal"]
[null,null,"Distribution","Facilities","Total"]
[null,"Allowable Investment per kWh",{"$f":"'Sch 021-022'!C28","v":0.10225030446829064},{"$f":"'Sch 021-022'!D28","v":2.4030164914836498E-2},{"$f":"SUM(C18:D18)","v":0.12628046938312715}]
[null,"PUMPING SERVICE (SCHEDULE 31)"]
[null,null,null,"Terminal"]
[null,null,"Distribution","Facilities","Total"]
[null,"Allowable Investment per kWh",{"$f":"'Sch 031-032'!C28","v":0.12277057059878532},{"$f":"'Sch 031-032'!D28","v":3.6739748368597495E-2},{"$f":"SUM(C22:D22)","v":0.15951031896738282}]
[]
[]
[]
[null,"*  Schedules 12 and 22 are for customers who meet the requirements for service under Schedules 11 and 21 and whose electric use qualifies as \"residential load\" as defined in the Pacific Northwest Electric Power Planning and Conservation Act and the Residential Purchase and Sale Agreement contract in effect between Avista and the Bonneville Power Administration.  Tariffed rates are the same under Schedules 11 and 12 and under Schedules 21 and 22."]

{"sheet":"Sch 001-002","index":1,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of Allowance - Schedule 51"]
[null,"Schedule 001"]
[]
[]
[null,"Summary"]
[null,"Residential (Schedule 1)"]
[]
[null,"# Customers",{"$f":"Inputs!C37","v":209864}]
[null,"Rate of Return",{"$f":"Inputs!D24","v":9.0427326141078831E-2}]
[]
[null,null,"Distribution","Terminal"]
[null,"2015 Cost of Service Study","Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"Inputs!C93","v":234913585.47783434},{"$f":"Inputs!C98","v":121823757.14497238},{"$f":"SUM(C13:D13)","v":356737342.62280673}]
[]
[null,"Return on Net Plant",{"$f":"C13*C9","v":21242607.408974327},{"$f":"D13*C9","v":11016196.61908},{"$f":"SUM(C15:D15)","v":32258804.028054327}]
[null,"Depreciation Expense",{"$f":"Inputs!C113","v":10271434.465495642},{"$f":"Inputs!C118","v":4410414},{"$f":"SUM(C16:D16)","v":14681848.465495642}]
[null,"Total",{"$f":"SUM(C15:C16)","v":31514041.874469969},{"$f":"SUM(D15:D16)","v":15426610.61908},{"$f":"SUM(E15:E16)","v":46940652.493549973}]
[]
[]
[null,null,"Distribution","Terminal"]
[null,"Per Customer Expenses","Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"(C13/C8)","v":1119.3610408542406},{"$f":"D13/C8","v":580.48906503722594},{"$f":"SUM(C22:D22)","v":1699.8501058914667}]
[]
[null,"Return on Net Plant",{"$f":"C15/C8","v":101.22082591094389},{"$f":"D15/C8","v":52.492074005451144},{"$f":"SUM(C24:D24)","v":153.71289991639503}]
[null,"Depreciation Expense",{"$f":"C16/C8","v":48.943289299239709},{"$f":"D16/C8","v":21.015581519460223},{"$f":"SUM(C25:D25)","v":69.958870818699936}]
[null,"Total",{"$f":"SUM(C24:C25)","v":150.16411521018358},{"$f":"SUM(D24:D25)","v":73.507655524911371},{"$f":"SUM(E24:E25)","v":223.67177073509498}]
[]
[null,"Allowable Investment",{"$f":"C26/(Inputs!H142+C9)","v":1249.163248567613},{"$f":"D26/(Inputs!H142+C9)","v":611.48471884619903},{"$f":"SUM(C28:D28)","v":1860.647967413812}]
[]
[null,"Rounded to nearest $5 increment",{"$f":"C32-C28","v":0.83675143238701821},{"$f":"D32-D28","v":-1.4847188461990299},{"$f":"C30+D30","v":-0.64796741381201173}]
[]
[null,"Allowable Investment",{"$f":"MROUND(C28,5)","v":1250},{"$f":"MROUND(D28,5)","v":610},{"$f":"SUM(C32:D32)","v":1860}]
[]
[]
[]
[]
[]
[null,"Apartments"]
[null,"Current Schedule 1 Allowance",1695,"Present Schedule 51"]
[null,"Current Duplex Allowance",1355,"Present Schedule 51"]
[null,"Current Multiplex Allowance",1015,"Present Schedule 51"]
[null,"Ratio of Duplex to Residence",{"$f":"C40/C39","v":0.79941002949852502},"C40/C39"]
[null,"New Duplex Allowance",{"$f":"MROUND(C42*E32,5)","v":1485},"E32*C42"]
[null,"Ratio of Multiplex to Residence",{"$f":"C41/C39","v":0.59882005899705015},"C41/C39"]
[null,"New Multiplex Allowance",{"$f":"MROUND(C44*E32,5)","v":1115},"E32*C44"]
[]
[null,"Small Schedule 011 Allowance"]
[null,"Sch 011 Under 75,000 kWh's",1300]
[null,"Ratio of Small Sch 011 to Sch 1 Allowance",{"$f":"C48/C39","v":0.76696165191740417},"C48/C39"]
[null,"New Small Sch 011 Allowance",{"$f":"(C49*E32)","v":1426.5486725663718},"C49*E32"]

{"sheet":"Sch 011-012","index":2,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of Allowance - Schedule 51"]
[null,"Schedule 011/012"]
[]
[]
[]
[null,"Residential (Schedule 11/12)"]
[]
[null,"Annual MWhs",{"$f":"Inputs!D38","v":623244}]
[null,"Rate of Return",{"$f":"Inputs!D24","v":9.0427326141078831E-2}]
[]
[null,null,"Distribution","Terminal"]
[null,{"$f":"'Sch 001-002'!B12","v":"2015 Cost of Service Study"},"Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"Inputs!D93","v":60220941.866142675},{"$f":"Inputs!D98","v":25376574.872533411},{"$f":"SUM(C13:D13)","v":85597516.738676086}]
[]
[null,"Return on Net Plant",{"$f":"C13*C9","v":5445618.7506526317},{"$f":"D13*C9","v":2294735.8123420849},{"$f":"SUM(C15:D15)","v":7740354.5629947167}]
[null,"Depreciation Expense",{"$f":"Inputs!D113","v":2633119.6066260445},{"$f":"Inputs!D118","v":870316},{"$f":"SUM(C16:D16)","v":3503435.6066260445}]
[null,"Total",{"$f":"SUM(C15:C16)","v":8078738.3572786767},{"$f":"SUM(D15:D16)","v":3165051.8123420849},{"$f":"SUM(E15:E16)","v":11243790.169620762}]
[]
[]
[null,null,"Distribution","Terminal"]
[null,"Per Customer Expenses","Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"C13/C8/1000","v":9.6624984542398609E-2},{"$f":"D13/C8/1000","v":4.0716918049003938E-2},{"$f":"SUM(C22:D22)","v":0.13734190259140255}]
[]
[null,"Return on Net Plant",{"$f":"C15/C8/1000","v":8.7375389905921773E-3},{"$f":"D15/C8/1000","v":3.6819220278768586E-3},{"$f":"SUM(C24:D24)","v":1.2419461018469035E-2}]
[null,"Depreciation Expense",{"$f":"C16/C8/1000","v":4.2248615415889194E-3},{"$f":"D16/C8/1000","v":1.3964290069378926E-3},{"$f":"SUM(C25:D25)","v":5.6212905485268118E-3}]
[null,"Total",{"$f":"SUM(C24:C25)","v":1.2962400532181097E-2},{"$f":"SUM(D24:D25)","v":5.078351034814751E-3},1.8040751566995847E-2]
[]
[null,"Allowable Investment",{"$f":"C26/(Inputs!H142+C9)","v":0.10782971907336089},{"$f":"D26/(Inputs!H142+C9)","v":4.2245042812902936E-2},{"$f":"SUM(C28:D28)","v":0.15007476188626384}]

{"sheet":"Sch 021-022","index":3,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of Allowance - Schedule 51"]
[null,"Schedule 021/022"]
[]
[]
[]
[null,"Residential (Schedule 21/22)"]
[]
[null,"Annual MWhs",{"$f":"Inputs!E38","v":1409459}]
[null,"Rate of Return",{"$f":"Inputs!D24","v":9.0427326141078831E-2}]
[]
[null,null,"Distribution","Terminal"]
[null,{"$f":"'Sch 001-002'!B12","v":"2015 Cost of Service Study"},"Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"Inputs!E93","v":129306929.71010351},{"$f":"Inputs!E98","v":33890619.992405698},{"$f":"SUM(C13:D13)","v":163197549.70250922}]
[]
[null,"Return on Net Plant",{"$f":"C13*C9","v":11692879.905197086},{"$f":"D13*C9","v":3064638.1471766368},{"$f":"SUM(C15:D15)","v":14757518.052373722}]
[null,"Depreciation Expense",{"$f":"Inputs!E113","v":5631752.1633633664},{"$f":"Inputs!E118","v":1006878},{"$f":"SUM(C16:D16)","v":6638630.1633633664}]
[null,"Total",{"$f":"SUM(C15:C16)","v":17324632.068560451},{"$f":"SUM(D15:D16)","v":4071516.1471766368},{"$f":"SUM(E15:E16)","v":21396148.21573709}]
[]
[]
[null,null,"Distribution","Terminal"]
[null,"Per Customer Expenses","Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"C13/C8/1000","v":9.174224274001834E-2},{"$f":"D13/C8/1000","v":2.4045126528977216E-2},{"$f":"SUM(C22:D22)","v":0.11578736926899555}]
[]
[null,"Return on Net Plant",{"$f":"C15/C8/1000","v":8.2960057051656606E-3},{"$f":"D15/C8/1000","v":2.1743364987393296E-3},{"$f":"SUM(C24:D24)","v":1.0470342203904991E-2}]
[null,"Depreciation Expense",{"$f":"C16/C8/1000","v":3.9956835660798695E-3},{"$f":"D16/C8/1000","v":7.1437196825164823E-4},{"$f":"SUM(C25:D25)","v":4.7100555343315177E-3}]
[null,"Total",{"$f":"SUM(C24:C25)","v":1.2291689271245531E-2},{"$f":"SUM(D24:D25)","v":2.8887084669909778E-3},1.5180397738236508E-2]
[]
[null,"Allowable Investment",{"$f":"C26/(Inputs!H142+C9)","v":0.10225030446829064},{"$f":"D26/(Inputs!H142+C9)","v":2.4030164914836498E-2},{"$f":"SUM(C28:D28)","v":0.12628046938312715}]

{"sheet":"Sch 031-032","index":4,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation of Allowance - Schedule 51"]
[null,"Schedule 031/032"]
[]
[]
[]
[null,"Residential (Schedule 31/32)"]
[]
[null,"Annual MWhs",{"$f":"Inputs!F38","v":133495}]
[null,"Rate of Return",{"$f":"Inputs!D24","v":9.0427326141078831E-2}]
[]
[null,null,"Distribution","Terminal"]
[null,{"$f":"'Sch 001-002'!B12","v":"2015 Cost of Service Study"},"Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"Inputs!F93","v":14686230.967357226},{"$f":"Inputs!F98","v":4837401.9900885019},{"$f":"SUM(C13:D13)","v":19523632.957445726}]
[]
[null,"Return on Net Plant",{"$f":"C13*C9","v":1328036.5974684234},{"$f":"D13*C9","v":437433.32743323676},{"$f":"SUM(C15:D15)","v":1765469.9249016601}]
[null,"Depreciation Expense",{"$f":"Inputs!F113","v":642144.90406466764},{"$f":"Inputs!F118","v":152154},{"$f":"SUM(C16:D16)","v":794298.90406466764}]
[null,"Total",{"$f":"SUM(C15:C16)","v":1970181.5015330911},{"$f":"SUM(D15:D16)","v":589587.32743323676},{"$f":"SUM(E15:E16)","v":2559768.8289663279}]
[]
[]
[null,null,"Distribution","Terminal"]
[null,"Per Customer Expenses","Plant","Facilities","Total"]
[null,"Net Plant",{"$f":"C13/C8/1000","v":0.11001334107912077},{"$f":"D13/C8/1000","v":3.623657807474813E-2},{"$f":"SUM(C22:D22)","v":0.1462499191538689}]
[]
[null,"Return on Net Plant",{"$f":"C15/C8/1000","v":9.9482122736313985E-3},{"$f":"D15/C8/1000","v":3.2767768638019158E-3},{"$f":"SUM(C24:D24)","v":1.3224989137433314E-2}]
[null,"Depreciation Expense",{"$f":"C16/C8/1000","v":4.8102543470891612E-3},{"$f":"D16/C8/1000","v":1.1397730252069368E-3},{"$f":"SUM(C25:D25)","v":5.9500273722960977E-3}]
[null,"Total",{"$f":"SUM(C24:C25)","v":1.475846662072056E-2},{"$f":"SUM(D24:D25)","v":4.4165498890088523E-3},1.9175016509729411E-2]
[]
[null,"Allowable Investment",{"$f":"C26/(Inputs!H142+C9)","v":0.12277057059878532},{"$f":"D26/(Inputs!H142+C9)","v":3.6739748368597495E-2},{"$f":"SUM(C28:D28)","v":0.15951031896738282}]

{"sheet":"Inputs","index":5,"n_rows":146,"n_cols":21,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["*From UE-170485"]
[]
["Cost of Capital",null,null,null,"Source"]
["Capital","Capital","Component","Weighted"]
["Component","Structure","Cost","Cost"]
["Long Term Debt",0.48599999999999999,5.7599999999999998E-2,{"$f":"B10*C10","v":2.7993599999999997E-2},"UE-170485, Order 7, Pg 40"]
["Short Term Debt",2.9000000000000001E-2,3.2599999999999997E-2,{"$f":"B11*C11","v":9.4539999999999999E-4},"UE-170485, Order 7, Pg 40"]
["Common Equity",0.48499999999999999,9.5000000000000001E-2,4.6074999999999998E-2,"UE-170485, Order 7, Pg 40"]
["Total",{"$f":"SUM(B10:B12)","v":1},null,{"$f":"SUM(D10:D12)","v":7.5013999999999997E-2},"UE-170485, Order 7, Pg 40"]
[]
[]
["Grossed-up Rate of Return"]
[]
["Tax Gross-up Factor",null,null,{"$f":"1/CF!E24","v":1.3278008298755186},"Adjusted for Tax Reform"]
[]
[]
["Weighted ROE * Tax Gross-up",null,"1.328 * 4.608%",{"$f":"D18*D12","v":6.1178423236514519E-2}]
["Long Term and Short Term Debt",null,null,{"$f":"D10","v":2.7993599999999997E-2}]
["Preferred Equity * Tax Gross-up",null,"1.328 * 0.000%",{"$f":"D11*D18","v":1.2553029045643154E-3}]
["Grossed-up Rate of Return",null,null,{"$f":"SUM(D21:D23)","v":9.0427326141078831E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
["*From UE-170485 Cost of Service (Knox)",null,null,null,null,null,null,null,null,null,null,"*From UE-170485 Cost of Service (Knox)"]
[null,null,null,null,null,null,null,null,null,null,null,"Allocations to Rate Schedules"]
[]
[null,"Total ","Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032","Source",null,null,null,"Allocator"]
["Number of Customers",{"$f":"SUM(C37:F37)","v":245486},209864,31286,1903,2433,"Knox COS Study  - \"Assign\" (columns BB - BL)",null,null,null,"C01"]
["Annual Consumption (MWhs)",{"$f":"SUM(C38:F38)","v":4528084},2361886,623244,1409459,133495,"Knox COS Study  - \"Assign\" (columns BB - BL)",null,null,null,"E01"]
["NCP Demand (kW)",844928,451201,115667,249852,28208,"Knox COS Study  - \"Assign\" (columns BB - BL)",null,null,null,"D02"]
[]
[]
[]
[null,"Plant in Service",null,null,null,null,null,null,"Final ProForma",null,null,"Plant in Service"]
["Account",null,null,null,null,null,null,null,"Cost of Service Balances",null,"Account"]
[null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032",null,null,"From UE-170485",null,null,null,"Total","Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032","Schedule 25","Sch 41-49"]
[361,"Structures & Improvements",{"$f":"$I46*($N46/$M46)","v":7138426.4806697518},{"$f":"$I46*($O46/$M46)","v":1829961.1232214074},{"$f":"$I46*($P46/$M46)","v":3952894.2661702423},{"$f":"$I46*($Q46/$M46)","v":446277.03005030169},null,null,14851000,null,361,"Structures & Improvements",{"$f":"SUM(N46:S46)","v":14850999},7138426,1829961,3952894,446277,1392629,90812,null,"Knox COS Study  - \"Assign\"  (J946 - W1089)"]
[362,"Station Equipment",{"$f":"$I47*($N47/$M47)","v":41379995.502087727},{"$f":"$I47*($O47/$M47)","v":10607910.872358395},{"$f":"$I47*($P47/$M47)","v":22914121.724281691},{"$f":"$I47*($Q47/$M47)","v":2586977.9688717201},null,null,83107000,null,362,"Station Equipment",{"$f":"SUM(N47:S47)","v":83107001},41379996,10607911,22914122,2586978,5091574,526420]
[363,"Storage Battery Equipment",1256574.5223966087,322126.87756485079,695826.73552765651,78557.970141402446,null,null,2631000,null,363,"Storage Battery Equipment",{"$f":"SUM(N48:S48)","v":2631001},1256575,322127,695827,78558,261928,15986]
[364,"Poles, Towers & Fixtures",112840283.51704387,28927012.876192458,62429734.732800893,7054502.9698067456,null,null,233645000,null,364,"Poles, Towers & Fixtures",233645001,112840284,28927013,62429735,7054503,9228978,13164488]
[365,"OH Conductors & Devices",75265044,19294465,41658499,4705389,null,null,148163000,null,365,"OH Conductors & Devices",148163000,75265044,19294465,41658499,4705389,6282111,957492]
[366,"UG Conduit",{"$f":"$I51*($N51/$M51)","v":34737002.513648234},8904955.1316755656,18775543.277629729,2171674.0321120545,null,null,67628000,null,366,"UG Conduit",67627999,34737002,8904955,18775543,2171674,2596915,441910]
[367,"UG Conductors & Devices",62375794.489417724,15990259.869110392,33817052.723187685,3899584.9680796214,null,null,122166000,null,367,"UG Conductors & Devices",122166001,62375795,15990260,33817053,3899585,5289788,793520]
[null,"Subtotals",{"$f":"SUM(C46:C52)","v":334993121.02526391},{"$f":"SUM(D46:D52)","v":85876691.750123069},184243672.45959789,20942963.939061847,null,null,{"$f":"SUM(I46:I52)","v":672191000},null,null,"Subtotals",{"$f":"SUM(N53:S53)","v":672191002},{"$f":"SUM(N46:N52)","v":334993122},{"$f":"SUM(O46:O52)","v":85876692},184243673,20942964,{"$f":"SUM(R46:R52)","v":30143923},15990628]
[]
[368,"Line Transformers",{"$f":"$I55*($N55/$M55)","v":92283009},{"$f":"$I55*($O55/$M55)","v":23657081},{"$f":"$I55*($P55/$M55)","v":45834611},{"$f":"$I55*($Q55/$M55)","v":5769311},null,null,168718000,null,368,"Line Transformers",{"$f":"SUM(N55:S55)","v":168718000},92283009,23657081,45834611,5769311,0,1173988]
[369,"Services",{"$f":"$I56*($N56/$M56)","v":88621902.144972384},{"$f":"$I56*($O56/$M56)","v":13211656.872533413},{"$f":"$I56*($P56/$M56)","v":787133.99240570015},{"$f":"$I56*($Q56/$M56)","v":1027306.9900885015},null,null,103648000,null,369,"Services",{"$f":"SUM(N56:S56)","v":103648001},88621903,13211657,787134,1027307,0,0]
[370,"Meters",0,0,0,0,null,null,0,null,370,"Meters",0,0,0,0,0,0,0]
[null,"Subtotals",{"$f":"SUM(C55:C57)","v":180904911.14497238},{"$f":"SUM(D55:D57)","v":36868737.872533411},46621744.992405698,6796617.9900885019,null,null,{"$f":"SUM(I55:I57)","v":272366000},null,null,"Subtotals",272366001,{"$f":"SUM(N55:N57)","v":180904912},{"$f":"SUM(O55:O57)","v":36868738},46621745,6796618,{"$f":"SUM(R55:R57)","v":0},1173988]
[]
[null,"Totals",{"$f":"C53+C58","v":515898032.17023629},{"$f":"D53+D58","v":122745429.62265648},230865417.4520036,27739581.92915035,null,null,null,null,null,"Totals",{"$f":"SUM(N60:S60)","v":944557003},{"$f":"N53+N58","v":515898034},{"$f":"O53+O58","v":122745430},230865418,27739582,{"$f":"R53+R58","v":30143923},17164616]
[]
[]
[null,"Accumulated Depreciation",null,null,null,null,null,null,null,null,null,"Accumulated Depreciation"]
["Account",null,null,null,null,null,null,null,null,null,"Account"]
[null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032",null,null,null,null,null,null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032","Schedule 25","Sch 41-49"]
[361,"Structures & Improvements",{"$f":"$I66*($N66/$M66)","v":2155323},{"$f":"$I66*($O66/$M66)","v":552525},{"$f":"$I66*($P66/$M66)","v":1193507},{"$f":"$I66*($Q66/$M66)","v":134746},null,null,4484000,null,361,"Structures & Improvements",{"$f":"SUM(N66:S66)","v":4484000},2155323,552525,1193507,134746,420480,27419,null,"Knox COS Study  - \"Assign\"  (J1221 - W1364)"]
[362,"Station Equipment",{"$f":"$I67*($N67/$M67)","v":11543100},{"$f":"$I67*($O67/$M67)","v":2959114.9999999995},{"$f":"$I67*($P67/$M67)","v":6391978},{"$f":"$I67*($Q67/$M67)","v":721647},null,null,23183000,null,362,"Station Equipment",{"$f":"SUM(N67:S67)","v":23183000},11543100,2959115,6391978,721647,1420313,146847]
[363,"Storage Battery Equipment",102684.52239757024,26323.877563360173,56861.735526811499,6419.9701396737692,null,null,215000,null,363,"Storage Battery Equipment",{"$f":"SUM(N68:S68)","v":215001},102685,26324,56862,6420,21404,1306]
[364,"Poles, Towers & Fixtures",26560171.517043885,6808795.8761924561,14694614.732800895,1660477.9698067466,null,null,54995000,null,364,"Poles, Towers & Fixtures",54995001,26560172,6808796,14694615,1660478,2172303,3098637]
[365,"OH Conductors & Devices",21142973.507988118,5420077.1302245772,11702438.281166678,1321808.0317581999,null,null,41621000,null,365,"OH Conductors & Devices",41620999,21142973,5420077,11702438,1321808,1764730,268973]
[366,"UG Conduit",9884133,2533833.0000000005,5342429,617932,null,null,19243000,null,366,"UG Conduit",19243000,9884133,2533833,5342429,617932,738931,125742]
[367,"UG Conductors & Devices",28691150,7355079.9999999991,15554914,1793702,null,null,56193000,null,367,"UG Conductors & Devices",56193000,28691150,7355080,15554914,1793702,2433157,364997]
[null,"Subtotals",{"$f":"SUM(C66:C72)","v":100079535.54742956},{"$f":"SUM(D66:D72)","v":25655749.883980393},{"$f":"SUM(E66:E72)","v":54936742.749494389},{"$f":"SUM(F66:F72)","v":6256732.9717046209},null,null,{"$f":"SUM(I66:I72)","v":199934000},null,null,"Subtotals",199934001,{"$f":"SUM(N66:N72)","v":100079536},{"$f":"SUM(O66:O72)","v":25655750},54936743,6256733,{"$f":"SUM(R66:R72)","v":8971318},4033921]
[]
[368,"Line Transformers",{"$f":"$I75*($N75/$M75)","v":25023694},{"$f":"$I75*($O75/$M75)","v":6414914},{"$f":"$I75*($P75/$M75)","v":12428629},{"$f":"$I75*($Q75/$M75)","v":1564421.0000000002},null,null,45750000,null,368,"Line Transformers",{"$f":"SUM(N75:S75)","v":45750000},25023694,6414914,12428629,1564421,0,318342]
[369,"Services",{"$f":"$I76*($N76/$M76)","v":34057460},{"$f":"$I76*($O76/$M76)","v":5077249},{"$f":"$I76*($P76/$M76)","v":302496},{"$f":"$I76*($Q76/$M76)","v":394795},null,null,39832000,null,369,"Services",{"$f":"SUM(N76:S76)","v":39832000},34057460,5077249,302496,394795,0,0]
[370,"Meters",0,0,0,0,null,null,0,null,370,"Meters",0,0,0,0,0,0,0]
[null,"Subtotals",{"$f":"SUM(C75:C77)","v":59081154},{"$f":"SUM(D75:D77)","v":11492163},{"$f":"SUM(E75:E77)","v":12731125},{"$f":"SUM(F75:F77)","v":1959216.0000000002},null,null,{"$f":"SUM(I75:I77)","v":85582000},null,null,"Subtotals",{"$f":"SUM(N78:S78)","v":85582000},{"$f":"SUM(N75:N77)","v":59081154},{"$f":"SUM(O75:O77)","v":11492163},12731125,1959216,{"$f":"SUM(R75:R77)","v":0},318342]
[]
[null,"Totals",{"$f":"C73+C78","v":159160689.54742956},{"$f":"D73+D78","v":37147912.883980393},67667867.749494389,8215948.9717046209,null,null,null,null,null,"Totals",{"$f":"M73+M78","v":285516001},{"$f":"N73+N78","v":159160690},{"$f":"O73+O78","v":37147913},67667868,8215949,{"$f":"R73+R78","v":8971318},4352263]
[]
[]
[null,"Net Plant",null,null,null,null,null,null,null,null,null,"Net Plant"]
["Account",null,null,null,null,null,null,null,null,null,"Account"]
[null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032",null,null,null,null,null,null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032","Schedule 25","Sch 41-49"]
[361,"Structures & Improvements",{"$f":"C46-C66","v":4983103.4806697518},{"$f":"D46-D66","v":1277436.1232214074},2759387.2661702423,311531.03005030169,null,null,null,null,361,"Structures & Improvements",{"$f":"M46-M66","v":10366999},{"$f":"N46-N66","v":4983103},{"$f":"O46-O66","v":1277436},2759387,311531,{"$f":"R46-R66","v":972149},63393]
[362,"Station Equipment",29836895.502087727,{"$f":"D47-D67","v":7648795.8723583948},16522143.724281691,1865330.9688717201,null,null,null,null,362,"Station Equipment",{"$f":"M47-M67","v":59924001},{"$f":"N47-N67","v":29836896},7648796,16522144,1865331,{"$f":"R47-R67","v":3671261},379573]
[363,"Storage Battery Equipment",1153889.9999990384,295803.00000149064,638965.00000084506,72138.00000172868,null,null,null,null,363,"Storage Battery Equipment",2416000,1153890,295803,638965,72138,240524,14680]
[364,"Poles, Towers & Fixtures",86280111.999999985,22118217,47735120,5394024.9999999991,null,null,null,null,364,"Poles, Towers & Fixtures",178650000,{"$f":"N49-N69","v":86280112},22118217,47735120,5394025,{"$f":"R49-R69","v":7056675},10065851]
[365,"OH Conductors & Devices",54122070.492011882,13874387.869775422,29956060.71883332,3383580.9682418001,null,null,null,null,365,"OH Conductors & Devices",106542001,{"$f":"N50-N70","v":54122071},13874388,29956061,3383581,{"$f":"R50-R70","v":4517381},688519]
[366,"UG Conduit",24852869.513648234,6371122.1316755656,13433114.277629729,1553742.0321120545,null,null,null,null,366,"UG Conduit",48384999,{"$f":"N51-N71","v":24852869},6371122,13433114,1553742,{"$f":"R51-R71","v":1857984},316168]
[367,"UG Conductors & Devices",33684644.489417724,8635179.8691103943,18262138.723187685,2105882.9680796214,null,null,null,null,367,"UG Conductors & Devices",65973001,{"$f":"N52-N72","v":33684645},8635180,18262139,2105883,{"$f":"R52-R72","v":2856631},428523]
[null,"Subtotals",{"$f":"SUM(C86:C92)","v":234913585.47783434},{"$f":"SUM(D86:D92)","v":60220941.866142675},{"$f":"SUM(E86:E92)","v":129306929.71010351},{"$f":"SUM(F86:F92)","v":14686230.967357226},null,null,null,null,null,"Subtotals",472257001,{"$f":"SUM(N86:N92)","v":234913586},{"$f":"SUM(O86:O92)","v":60220942},129306930,14686231,{"$f":"SUM(R86:R92)","v":21172605},11956707]
[]
[368,"Line Transformers",{"$f":"C55-C75","v":67259315},{"$f":"D55-D75","v":17242167},33405982,4204890,null,null,null,null,368,"Line Transformers",{"$f":"M55-M75","v":122968000},{"$f":"N55-N75","v":67259315},{"$f":"O55-O75","v":17242167},33405982,4204890,{"$f":"R55-R75","v":0},855646]
[369,"Services",{"$f":"C56-C76","v":54564442.144972384},{"$f":"D56-D76","v":8134407.8725334127},484637.99240570015,632511.99008850148,null,null,null,null,369,"Services",{"$f":"M56-M76","v":63816001},{"$f":"N56-N76","v":54564443},8134408,484638,632512,{"$f":"R56-R76","v":0},0]
[370,"Meters",{"$f":"C57-C77","v":0},0,0,0,null,null,null,null,370,"Meters",{"$f":"M57-M77","v":0},{"$f":"N57-N77","v":0},0,0,0,{"$f":"R57-R77","v":0},0]
[null,"Subtotals",{"$f":"SUM(C95:C97)","v":121823757.14497238},{"$f":"SUM(D95:D97)","v":25376574.872533411},{"$f":"SUM(E95:E97)","v":33890619.992405698},{"$f":"SUM(F95:F97)","v":4837401.9900885019},null,null,null,null,null,"Subtotals",{"$f":"M58-M78","v":186784001},{"$f":"SUM(N95:N97)","v":121823758},{"$f":"SUM(O95:O97)","v":25376575},33890620,4837402,{"$f":"SUM(R95:R97)","v":0},855646]
[]
[null,"Totals",{"$f":"C93+C98","v":356737342.62280673},{"$f":"D93+D98","v":85597516.738676086},163197549.70250922,19523632.957445726,null,null,null,null,null,"Totals",{"$f":"M93+M98","v":659041002},{"$f":"N93+N98","v":356737344},{"$f":"O93+O98","v":85597517},163197550,19523633,{"$f":"R93+R98","v":21172605},12812353]
[]
[]
[null,"Depreciation Expense",null,null,null,null,null,null,null,null,null,"Depreciation Expense"]
["Account",null,null,null,null,null,null,null,null,null,"Account"]
[null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032",null,null,null,null,null,null,null,"Schedule 001","Schedule 011/012","Schedule 021/022","Schedule 031/032","Schedule 25","Sch 41-49"]
[361,"Structures & Improvements",{"$f":"$I106*($N106/$M106)","v":118725.48066996223},{"$f":"$I106*($O106/$M106)","v":30436.123223170944},{"$f":"$I106*($P106/$M106)","v":65744.266171118099},{"$f":"$I106*($Q106/$M106)","v":7422.0300487046507},null,null,247000,null,361,"Structures & Improvements",{"$f":"SUM(N106:S106)","v":246999},118725,30436,65744,7422,23162,1510,null,"Knox COS Study  - \"Assign\"  (J555 - W698)"]
[362,"Station Equipment",{"$f":"$I107*($N107/$M107)","v":851928},{"$f":"$I107*($O107/$M107)","v":218395},{"$f":"$I107*($P107/$M107)","v":471754},{"$f":"$I107*($Q107/$M107)","v":53260},null,null,1711000,null,362,"Station Equipment",{"$f":"SUM(N107:S107)","v":1711000},851928,218395,471754,53260,104825,10838]
[363,"Storage Battery Equipment",63521,16284,35175,3971,null,null,133000,null,363,"Storage Battery Equipment",{"$f":"SUM(N108:S108)","v":133000},63521,16284,35175,3971,13241,808]
[364,"Poles, Towers & Fixtures",2611343.5170439212,669426.87619255111,1444745.732800863,163254.96980673759,null,null,5407000,null,364,"Poles, Towers & Fixtures",5407001,2611344,669427,1444746,163255,213577,304652]
[365,"OH Conductors & Devices",2084782.4920120633,534441.86977537291,1153907.7188334018,130335.96824172312,null,null,4104000,null,365,"OH Conductors & Devices",4104001,2084783,534442,1153908,130336,174010,26522]
[366,"UG Conduit",943571.48635193997,241887.86832451369,510005.72237031988,58989.96788787812,null,null,1837000,null,366,"UG Conduit",1837001,943572,241888,510006,58990,70541,12004]
[367,"UG Conductors & Devices",3597562.4894177564,922247.86911043583,1950419.7231876634,224910.96807962417,null,null,7046000,null,367,"UG Conductors & Devices",7046001,3597563,922248,1950420,224911,305092,45767]
[null,"Subtotals",{"$f":"SUM(C106:C112)","v":10271434.465495642},{"$f":"SUM(D106:D112)","v":2633119.6066260445},{"$f":"SUM(E106:E112)","v":5631752.1633633664},{"$f":"SUM(F106:F112)","v":642144.90406466764},null,null,{"$f":"SUM(I106:I112)","v":20485000},null,null,"Subtotals",20485003,{"$f":"SUM(N106:N112)","v":10271436},{"$f":"SUM(O106:O112)","v":2633120},5631753,642145,{"$f":"SUM(R106:R112)","v":904448},402101]
[]
[368,"Line Transformers",{"$f":"$I115*($N115/$M115)","v":1983845.9999999998},{"$f":"$I115*($O115/$M115)","v":508566},{"$f":"$I115*($P115/$M115)","v":985325},{"$f":"$I115*($Q115/$M115)","v":124025},null,null,3627000,null,368,"Line Transformers",{"$f":"SUM(N115:S115)","v":3627000},1983846,508566,985325,124025,0,25238]
[369,"Services",{"$f":"$I116*($N116/$M116)","v":2426568},{"$f":"$I116*($O116/$M116)","v":361750},{"$f":"$I116*($P116/$M116)","v":21553},{"$f":"$I116*($Q116/$M116)","v":28129},null,null,2838000,null,369,"Services",{"$f":"SUM(N116:S116)","v":2838000},2426568,361750,21553,28129,0,0]
[370,"Meters",0,0,0,0,null,null,0,null,370,"Meters",0,0,0,0,0,0,0]
[null,"Subtotals",{"$f":"SUM(C115:C117)","v":4410414},{"$f":"SUM(D115:D117)","v":870316},{"$f":"SUM(E115:E117)","v":1006878},{"$f":"SUM(F115:F117)","v":152154},null,null,{"$f":"SUM(I115:I117)","v":6465000},null,null,"Subtotals",6465000,{"$f":"SUM(N115:N117)","v":4410414},{"$f":"SUM(O115:O117)","v":870316},1006878,152154,{"$f":"SUM(R115:R117)","v":0},25238]
[]
[null,"Totals",{"$f":"C113+C118","v":14681848.465495642},{"$f":"D113+D118","v":3503435.6066260445},6638630.1633633664,794298.90406466764,null,null,null,null,null,"Totals",{"$f":"M113+M118","v":26950003},{"$f":"N113+N118","v":14681850},{"$f":"O113+O118","v":3503436},6638631,794299,{"$f":"R113+R118","v":904448},427339]
[]
[]
["Total Distribution Plant Depreciation Rates by Account"]
[]
[]
[null,null,null,null,null,null,"Effective","Weighted","Distribution","Term Fac"]
["Account","Account","Plant in","Accumulated","Net","Depreciation","Depreciation","Depreciation","Weighted","Weighted"]
["Number","Description","Service","Depreciation","Plant","Expense","Rate","Rate","Rate","Rate"]
[360,"Land & Land Rights",4757000,29000,{"$f":"C129-D129","v":4728000},5000,{"$f":"F129/C129","v":1.0510826150935463E-3},{"$f":"G129*(E129/$E$140)","v":7.4868193666204459E-6},{"$f":"G129*(F129/(SUM($F$129:$F$136)))","v":2.5648672891496979E-7},null,"Results of Operations (September 30, 2015)","Knox COS Study  - \"Assign\"  (colunm Q)"]
[361,"Structures & Improvements",14851000,4484000,{"$f":"C130-D130","v":10367000},247000,{"$f":"F130/C130","v":1.6631876641303615E-2},2.5976305784149991E-4,2.0049163154719341E-4]
[362,"Station Equipment",83107000,23183000,{"$f":"C131-D131","v":59924000},1711000,2.0587916781979857E-2,1.8586440843777895E-3,1.7191764574898748E-3]
[363,"Storage Battery Equipment",2631000,215000,{"$f":"C132-D132","v":2416000},133000,{"$f":"F132/C132","v":5.0551121246674269E-2},1.8399700638620518E-4,3.2812587241618727E-4]
[364,"Poles, Towers & Fixtures",233645000,54995000,178650000,5407000,2.3141946114832331E-2,6.2285353389730409E-3,6.1068083281063156E-3]
[365,"OH Conductors & Devices",148163000,41621000,106542000,4104000,2.7699223152878923E-2,4.446020578174073E-3,5.5479556768870232E-3]
[366,"UG Conduit",67628000,19243000,48385000,1837000,2.7163305139882889E-2,1.9800510707689476E-3,2.4352850923360109E-3]
[367,"UG Conductors & Devices",122166000,56193000,65973000,7046000,5.7675621695070643E-2,5.7324668523068946E-3,1.9833207928914971E-2]
[368,"Line Transformers",168718000,45750000,122968000,3627000,2.1497409879206723E-2,3.9825504023633107E-3,null,{"$f":"G137*(F137/(SUM($F$137:$F$139)))","v":1.2060495844065397E-2}]
[369,"Services",103648000,39832000,63816000,2838000,2.7381136153133683E-2,2.6324739250377454E-3,null,{"$f":"G138*(F138/(SUM($F$137:$F$139)))","v":1.2019747007361701E-2}]
[370,"Meters",0,0,0,0,0,0,null,0]
["Totals",null,{"$f":"SUM(C129:C139)","v":949314000},{"$f":"SUM(D129:D139)","v":285545000},663769000,26955000,{"$f":"F140/C140","v":2.8394187802981943E-2},{"$f":"G140*(E140/E140)","v":2.8394187802981943E-2},{"$f":"SUM(I129:I139)","v":3.6171307474426491E-2},{"$f":"SUM(J129:J139)","v":2.4080242851427097E-2}]
[null,null,null,null,"Revenue Conversion Factor (Before FIT)",null,null,{"$f":"CF!E20","v":0.95332300000000003}]
[null,null,null,null,"Grossed-up Depreciation Rate",null,null,{"$f":"H140/H141","v":2.9784435918342411E-2}]
[]
[]
[371,"Install on Customers Premises",0,0,0,0,0]
[373,"Street Lighting",39422000,12616000,{"$f":"C146-D146","v":26806000},1353000,{"$f":"F146/C146","v":3.4320937547562276E-2}]

{"sheet":"CF","index":6,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[]
["Revenue Conversion Factor"]
["Washington - Electric System"]
["Twelve Months Ended December 31, 2016"]
[]
["Line "]
["No.",null,"Description",null,"Factor"]
[]
[1,null,"Revenues",null,1]
[]
[null,null,"Expense:"]
[2,null,"  Uncollectibles",null,6.1824999999999996E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8494500000000001E-2]
[]
[5,null,"    Total Expense",null,{"$f":"SUM(E12:E16)","v":4.6676999999999996E-2}]
[]
[6,null,"Net Operating Income Before FIT",null,{"$f":"E9-E18","v":0.95332300000000003}]
[]
[7,null,"  Federal Income Tax @ 21%",null,{"$f":"ROUND(E20*0.21,6)","v":0.20019799999999999}]
[]
[8,null,"REVENUE CONVERSION FACTOR",null,{"$f":"ROUND(E20-E22,6)","v":0.75312500000000004}]