{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CSII O&M","454 Revenue","456 Revenue","407 Reg Def-Amort","Intangible","ADFIT ","WA Retail Load"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":43,"comments":5,"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":"CSII O&M","index":0,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,0,6,5]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant Location Code","610"]
["Disaggregate CSII O&M Expense",null,null,null,null,null,null,null,null,null,null,null,null,null,"Service","ED"]
["Washington Electric Cost Study",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jurisdiction","AN"]
["12 Months Ended December 31, 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transaction Amount","Electric Amt SUM"]
["Identify CSII non-fuel production expenses during test year by Account to collect in Account 548 for Cost Assignment purposes.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferc Acct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"546000",159879.96,{"$f":"P7","v":159879.96}]
["(Most O&M expenses would ordinarily be in Accounts 548 and 553.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"548000",1679253.08,{"$f":"P8","v":1679253.08}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"549000",134585.30999999997,134585.30999999997]
["Account",null,"12 ME Dec 2018",null,"Adjustment","WA Share",null,null,null,null,null,null,null,null,"550000",0,0]
["(in 000's)",null,"Electric System",null,null,0.65390000000000004,null,null,null,null,null,null,null,null,"551000",248145.30000000013,248145.30000000013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"552000",66189.13,66189.13]
[546,null,{"$f":"Q7","v":159879.96},null,{"$f":"D13-C13","v":-159879.96},{"$f":"ROUND(E13*$F$11,0)","v":-104546},null,null,null,null,null,null,null,null,"553000",3385437.56,3385437.56]
[548,null,{"$f":"Q8","v":1679253.08},null,{"$f":"C22-C14","v":4196762.68},{"$f":"ROUND(E14*$F$11,0)","v":2744263},null,null,null,null,null,null,null,null,"554000",202525.41999999995,202525.41999999995]
[549,null,134585.30999999997,null,{"$f":"D15-C15","v":-134585.30999999997},-88005,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P7:P14)","v":5876015.7599999998}]
[550,null,0,null,{"$f":"D16-C16","v":0},0]
[551,null,248145.30000000013,null,-248145.30000000013,-162262,null,null,null,null,null,null,null,null,"From Accounting Period 201801 to 201812"]
[552,null,66189.13,null,-66189.13,-43281,null,null,null,null,null,null,null,null,"FERC Account 500 - 559"]
[553,null,3385437.56,null,-3385437.56,-2213738]
[554,null,202525.41999999995,null,-202525.41999999995,-132431]
[]
[null,null,{"$f":"SUM(C12:C21)","v":5876015.7599999998},null,{"$f":"SUM(E12:E21)","v":-4.9476511776447296E-10},{"$f":"SUM(F12:F21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Query Name:  Transaction_by_FERC_GL_Detail_w_Loc"]

{"sheet":"454 Revenue","index":1,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[14,13,15,13],[16,12,16,15],[2,16,2,19],[4,12,13,12],[5,13,6,13],[8,13,11,13],[8,14,10,14],[12,13,13,13],[14,12,15,12]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,"Electric Revenue Report by Location  Twelve Months Ended  for Report Date : '12/31/2018'"]
["Account 454 Rent Revenue from Electric Property"]
["Washington Electric Cost Study",null,null,null,null,null,null,null,null,null,null,null,"FERC Acct","Source ID","Rev Class Description","Town Cde","Revenue Amt"]
["Twelve Months Ended December 31,  2016",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jurisdiction","ID","WA","AN","Summary"]
[null,null,null,null,null,null,null,null,null,null,null,null,"454000","REVCCB","85 MISC-RENT FROM ELECTRIC PROPERTY",null,115331.14,282967.61,null,398298.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"REVBILLS","RE Rent Electric ",null,null,-191.88,null,-191.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RP Rent Permits","3800",null,0,null,0]
[null,null,"Allocation","Total","WA","ID",null,null,null,null,null,null,null,"REVCOL","RC Rent - Colstrip Property",null,null,null,29417.21,29417.21]
[null,null,"P/T ratio",{"$f":"E9+F9","v":1},0.65390000000000004,0.34610000000000002,null,null,null,null,null,null,null,"REVRENT","RP Rent Permits","2800",null,2055.0300000000002,25626.36,27681.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3800",null,-100,15,-85]
["454000","Misc-Rent from Electric Property","Direct",{"$f":"E11+F11","v":398298.75},{"$f":"R5","v":282967.61},{"$f":"Q5","v":115331.14},"Use of Facilities Fees","Distribution",null,null,null,null,null,null,null,"4800",null,-1091.6400000000001,27246.3,26154.66]
["454000","RE Rent Electric","Direct",{"$f":"E12+F12","v":239558.43},{"$f":"R6+R12","v":239558.43},{"$f":"Q12","v":0},"Leases from Distribution Property/Use of Facilities","Distribution",null,null,null,null,null,null,"RE Rent Electric ",null,null,239750.31,3600,243350.31]
["454000","RA & RB Rent Electric ","Direct",{"$f":"E13+F13","v":2227792.36},{"$f":"R13+R14","v":1266070.17},{"$f":"Q13+Q14","v":961722.19000000006},"Pole Contact Fees","Distribution",null,null,null,null,null,"REVPOLE","RA Rent Electric - Accrued ",null,837454.93,1058372.49,null,1895827.42]
["454100","TA & TP Transmission Rent Electric","Direct",{"$f":"E14+F14","v":30512.160000000003},{"$f":"R15+R16","v":13789.300000000001},{"$f":"Q15+Q16","v":16722.86},"Pole Contact Fees","Transmission",null,null,null,null,null,null,"RB Rent Electric - Advance billing",null,124267.26,207697.68,null,331964.94]
["454000","RC Rent - Colstrip Property","P/T ratio",{"$f":"S8","v":29417.21},{"$f":"ROUND($D15*E$9,0)","v":19236},{"$f":"ROUND($D15*F$9,0)","v":10181},"Rental for Colstrip Property","Production",null,null,null,null,"454100","REVPOLE","TA Transmission Rent Accrued",null,651.36,441.94,null,1093.3]
["454000","RP Rent Permits","P/T ratio",{"$f":"T11","v":26154.66},17103,9052,"Land Use Permits at Noxon","Production",null,null,null,null,null,null,"TP Transmission Rent Advanced Billing",null,16071.5,13347.36,null,29418.86]
["454000","RP Rent Permits","P/T ratio",{"$f":"T7+T9+T10+S12","v":31196.39},20399,10797,"Land Use Permits on Transmission Line Land","Transmission",null,null,null,null,"Summary",null,null,null,1093776.19,1803248.9,85904.87,2982929.96]
[null,null,null,{"$f":"SUM(D11:D17)","v":2982929.9600000004},{"$f":"SUM(E11:E17)","v":1859123.51},{"$f":"SUM(F11:F17)","v":1123806.1900000002}]
[]
[null,"Per Results Total",null,{"$f":"SUM(E20:F20)","v":2983000},1859000,1124000]
[null,"Production",null,{"$f":"SUM(E21:F21)","v":55000},{"$f":"ROUND(SUMIF($H$11:$H$17,$B21,E$11:E$17),-3)","v":36000},19000]
[null,"Transmission",null,{"$f":"SUM(E22:F22)","v":62000},34000,28000]
[null,"Distribution",null,{"$f":"SUM(E23:F23)","v":2866000},1789000,1077000]
[null,null,null,{"$f":"SUM(E24:F24)","v":2983000},{"$f":"SUM(E21:E23)","v":1859000},{"$f":"SUM(F21:F23)","v":1124000}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Report:  2018 FERC Acct 12ME w Rev Class / 454 Revenue"]
["Adjustments to Account 454"]
[null,"Eliminate B&O Tax","Adj E-EBO-2",null,-13000,null,"Distribution"]
[]
[]
[]
[null,"Production Total",null,null,{"$f":"E21+E28","v":36000}]
[null,"Transmission Total",null,null,{"$f":"E22","v":34000}]
[null,"Distribution Total",null,null,{"$f":"E23+E27","v":1776000}]
[null,"Pro Forma Total",null,null,{"$f":"SUM(E31:E33)","v":1846000}]

{"sheet":"456 Revenue","index":2,"n_rows":42,"n_cols":26,"rows_kept":42,"cut":false,"hidden":false,"merged":[[16,18,18,18],[16,19,18,19],[2,22,2,25],[39,18,39,21],[23,18,24,18],[23,19,24,19],[29,18,31,18],[29,19,31,19],[12,19,13,19],[4,18,13,18],[4,19,6,19],[8,19,11,19],[14,18,15,18],[14,19,15,19]]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric Revenue Report by Location  Twelve Months Ended  for Report Date : '12/31/2018'"]
["Functionalize Other Operating Revenue"]
["Washington Electric Cost Study",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERC Acct","Source ID","Rev Class Description",null,"Revenue Amt"]
["Twelve Months Ended December 31, 2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jurisdiction","AN","WA","ID","Summary"]
[null,null,null,null,null,"System",null,null,null,null,null,null,null,null,null,null,null,null,"456000","REVBILLS","GA Other Gas Allocated",null,9643.74,null,null,9643.74]
[null,null,null,null,"System Total","Adjustments","Reference","Pro Forma Total","WA","ID",null,null,null,null,null,null,null,null,null,null,"OA Other Electric Allocated",null,349322.79,2130.31,null,351453.1]
[null,null,null,"Allocation",null,null,null,{"$f":"I7+J7","v":1},0.65390000000000004,0.34610000000000002,null,null,null,null,null,null,null,null,null,null,"OD Other Electric Direct",null,22025.75,35069.39,1300,58395.14]
[null,null,null,null,null,null,null,{"$f":"I8+J8","v":1},0.6573,0.3427,null,null,null,null,null,null,null,null,null,"REVCOL","OC Other Revenue & Scrap Sales - Colstrip",null,31836.27,null,null,31836.27]
["456000","Miscellaneous","Other Electric Allocated","P/T ratio",{"$f":"SUM(W5:W14)-E10","v":960833.11999999988},null,null,{"$f":"ROUND(E9,-3)+F9","v":961000},{"$f":"$H9*I$7","v":628397.9},{"$f":"$H9*J$7","v":332602.10000000003},"Distribution","Pre-line School and Centralized Distribution Services for other utilities",null,null,null,null,null,null,null,"REVEARNED","AD Apprentice Lineman School Deposits",null,8400,null,null,8400]
["456000","Miscellaneous","OC Other Revenue - Colstrip","P/T ratio",{"$f":"W8","v":31836.27},null,null,{"$f":"ROUND(E10,-3)+F10","v":32000},{"$f":"$H10*I$7","v":20924.800000000003},{"$f":"$H10*J$7","v":11075.2},"Production",null,null,null,null,null,null,null,null,null,"AL Apprentice Lineman School Receivable",null,63925.16,null,null,63925.16]
["456000","Miscellaneous","Other Electric Direct","Direct",{"$f":"I11+J11","v":39928.699999999997},null,null,40000,{"$f":"SUM(X5:X14)","v":38628.699999999997},{"$f":"SUM(Y5:Y14)","v":1300},"Distribution","Make Readies and Misc Contracts",null,null,null,null,null,null,null,null,"PD Pre-Line School Deposits",null,26515.56,null,null,26515.56]
["456010","Turbine Gas","AG/AH","P/T ratio",{"$f":"SUM(W15:W16)","v":5327941.5},-5328000,"E-APS OER",{"$f":"ROUND(E12+F12,-3)","v":0},{"$f":"$H12*I$8","v":0},0,"Production",null,null,null,null,null,null,null,null,null,"PL Pre-Line School Receivable",null,480717.62,null,null,480717.62]
["456015","Turbine Gas","CC/CO/GF","P/T ratio",{"$f":"SUM(W17:W19)","v":33445350.850000001},-33445000,"E-APS OER",{"$f":"ROUND(E13+F13,-3)","v":0},0,0,"Production",null,null,null,null,null,null,null,null,"REVPS","EN EnerVee Electric",null,282.5,null,null,282.5]
["456016","Resource Optimization","RO","P/T ratio",{"$f":"W20","v":4855921.55},-4856000,"E-APS OER",{"$f":"ROUND(E14,-3)+F14","v":0},0,0,"Production",null,null,null,null,null,null,null,null,null,"EV Fast Charger",null,null,1429,null,1429]
["456016","Resource Optimization","RW REC's Direct WA","Direct",0,null,null,{"$f":"ROUND(E15,-3)+F15","v":0},{"$f":"H15","v":0},0,"Production","WA EIA REC Sales",null,null,null,null,null,null,"456010","REVFUEL","AG Turbine Gas Financial Mizuho Clearing Agent",null,1023486,null,null,1023486]
["456017","Non-Resource Other Elec Rev","NR","P/T ratio",{"$f":"W21","v":60244.08},null,"E-APS TW",60000,{"$f":"$H16*I$8","v":39438},{"$f":"$H16*J$8","v":20562},"Transmission","Generation Interconnection Non-Refundable Deposits",null,null,null,null,null,null,null,null,"AH Turbine Gas Financial Wells Fargo",null,4304455.5,null,null,4304455.5]
["456018","Extraction Credits","CC Extraction Plant Credits","P/T ratio",{"$f":"W22","v":755451.97},-755000,"E-APS OER",{"$f":"ROUND(E17,-3)+F17","v":0},{"$f":"$H17*I$8","v":0},0,"Production",null,null,null,null,null,null,null,"456015","REVFUEL","CC Extraction Plant Credits",null,130421.77,null,null,130421.77]
["456020","Transmission Release Rev","BT BPA Excess Transm Sales","P/T ratio",{"$f":"W23","v":313913.75},0,"E-APS TW",{"$f":"ROUND(E18,-3)+F18","v":314000},206392.2,107607.8,"Transmission",null,null,null,null,null,null,null,null,null,"CO Cochrane Extraction Credit",null,-130421.77,null,null,-130421.77]
["4561xx","Wheeling","ET/JB/PC/EA Electric Transmission","P/T ratio",{"$f":"SUM(W24:W27)","v":15959856.539999999},{"$f":"-2933000-105000-51000-1000-F18-F21-F22-F16","v":-3090000},"E-APS TW",{"$f":"ROUND(E19,-3)+F19","v":12870000},8459451,4410549,"Transmission",null,null,null,null,null,null,null,null,null,"GF Turbine Gas Physical",null,33445350.850000001,null,null,33445350.850000001]
["4563xx","Decoupling Deferred Rev"," Decoupling Deferred Rev","Direct",{"$f":"SUM(X28:Y34)","v":4869584.1700000009},-4870000,"E-WN/EAS/RN",{"$f":"ROUND(E20,-3)+F20","v":0},0,0,"Distribution",null,null,null,null,null,null,null,"456016","REVREC","RO Miscellaneous Resource Optimization",null,4855921.55,null,null,4855921.55]
["456700","Low Voltage Wheeling","DE Electric Distribution","Direct",{"$f":"X35+Y35","v":156508.13999999998},-157000,"E-APS TW",{"$f":"ROUND(E21,-3)+F21","v":0},0,0,"Distribution","Wheeling over Distribution System (3 contracts)",null,null,null,null,null,null,"456017","REVTRAN","NR Other Electric Revenue - Non Resource ",null,60244.08,null,null,60244.08]
["456705","Low Voltage Wheeling","LV Electric Distribution","P/T ratio",{"$f":"W36","v":1747966},157000,"E-APS TW",1905000,1252156.5,652843.5,"Distribution","Low Voltage portion of BPA Network Contracts in WA, ID and MT",null,null,null,null,null,null,"456018","REVFUEL","CC Extraction Plant Credits",null,755451.97,null,null,755451.97]
["456730","Thermal Gas","IT Intraco Thermal Gas","P/T ratio",{"$f":"SUM(W37:W39)","v":30550889.120000001},-30551000,"E-APS OER",{"$f":"ROUND(E23+F23,-3)","v":0},0,0,"Production",null,null,null,null,null,null,null,"456020","REVESALES","BT BPA Excess Transm Sales",null,313913.75,null,null,313913.75]
[null,null,null,null,{"$f":"SUM(E9:E23)","v":99076225.75999999},{"$f":"SUM(F9:F23)","v":-82895000},null,{"$f":"SUM(H9:H23)","v":16182000},{"$f":"SUM(I9:I23)","v":10645389.1},{"$f":"SUM(J9:J23)","v":5536539.5999999996},null,null,null,null,null,null,null,null,"456100","REVTRAN","ET Electric Transmission",null,12421345.800000001,null,null,12421345.800000001]
[null,null,null,null,99076228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JB Electric Retained Damages - First Wind",null,251654.28,null,null,251654.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456120","REVTRAN","PC Parallel Capacity Support Rev",null,924000,null,null,924000]
[null,null,null,{"$f":"ROUND(E27,-3)","v":74967000},{"$f":"SUMIF($K$9:$K$23,$H27,E$9:E$23)","v":74967391.260000005},{"$f":"SUMIF($K$9:$K$24,$H27,F$9:F$23)","v":-74935000},null,"Production",{"$f":"ROUND(SUMIF($K$9:$K$24,$H27,I$9:I$23),-3)","v":21000},11000,null,null,null,null,null,null,null,null,"456130","REVTRAN","EA Electric Ancillary Transmission",null,2362856.46,null,null,2362856.46]
[null,null,null,{"$f":"ROUND(E28,-3)","v":16334000},{"$f":"SUMIF($K$9:$K$23,$H28,E$9:E$23)","v":16334014.369999999},-3090000,null,"Transmission",{"$f":"ROUND(SUMIF($K$9:$K$24,$H28,I$9:I$23),-3)+1000","v":8706000},{"$f":"ROUND(SUMIF($K$9:$K$24,$H28,J$9:J$23),-3)-1000","v":4538000},null,null,null,null,null,null,null,null,"456311","REVDECOUPLING","CW Contra Decoupling Deferral WA",null,null,-1396884.38,null,-1396884.38]
[null,null,null,{"$f":"ROUND(E29,-3)","v":7775000},{"$f":"SUMIF($K$9:$K$23,$H29,E$9:E$23)","v":7774820.1299999999},-4870000,null,"Distribution",{"$f":"ROUND(SUMIF($K$9:$K$24,$H29,I$9:I$23),-3)","v":1919000},987000,null,null,null,null,null,null,null,null,"456328","REVDECOUPLING","RD Res Decoupling Deferred Rev",null,null,8398268.7599999998,1745107.86,10143376.619999999]
[null,null,null,{"$f":"SUM(D27:D29)","v":99076000},{"$f":"SUM(E27:E29)","v":99076225.760000005},{"$f":"SUM(F27:F29)","v":-82895000},null,null,{"$f":"SUM(I27:I29)","v":10646000},{"$f":"SUM(J27:J29)","v":5536000},null,null,null,null,null,null,null,null,"456329","REVDECOUPLING","AC Amort Res Decoupling Def Rev",null,null,null,317937.15999999997,317937.15999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR Amort Res Decoupling Deferred Rev",null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EZ Amort Res E Decoupling Def Rev",null,null,-7545364.8300000001,-2066553.62,-9611918.4499999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456338","REVDECOUPLING","NW Non-Res Decoupling Deferred Rev",null,null,6898027.75,1415142.1,8313169.8499999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456339","REVDECOUPLING","FA Elec Amort Non-Rest Decoupling",null,null,-857983.2,-2038113.43,-2896096.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456700","REVTRAN","DE Electric Distribution",null,null,105727.26,50780.88,156508.14000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456705","REVTRAN","LV Electric Distribution",null,1747966,null,null,1747966]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456711","REVFUEL","GK Turbine Gas Bookout",null,-5765181.8799999999,null,null,-5765181.8799999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456720","REVFUEL","GK Turbine Gas Bookout",null,5765181.8799999999,null,null,5765181.8799999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"456730","REVFUEL","IT Intraco Thermal Gas",null,30550889.120000001,null,null,30550889.120000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary",null,null,null,94010204.75,5640420.0599999996,-574399.05000000005,99076225.760000005]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Report:  2018 FERC Acct 12ME w Rev Class / 456 Revenue",null,null,null,{"$f":"W40-94010205","v":-0.25},{"$f":"X40-5640421","v":-0.94000000040978193},{"$f":"Y40--574398","v":-1.0500000000465661},{"$f":"Z40-99076228","v":-2.239999994635582}]

{"sheet":"407 Reg Def-Amort","index":3,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["AVISTA UTILITIES"]
["Functionalize Regulatory Deferrals and Amortizations"]
["Washington Electric Cost Study"]
["Twelve Months Ended December 31, 2018"]
[null,null,null,null,"H","S","P","R","T","D","O"]
["ROO Account 407 Analysis",null,"Function Code",null,"Hydro Related","Steam Related","Peaking Unit Related","Renewable Related","Transmission Related","Distribution Related","Other/General Related"]
[null,null,null,"WA ROO Total"]
[406100,"Amort of Acq Adj--Colstrip Common AFUDC","S",31743,{"$f":"IF($C8=E$5,$D8,0)","v":0},{"$f":"IF($C8=F$5,$D8,0)","v":31743},0,0,0,0,0]
[407312,"Amortization of Lancaster Generation","S",0,{"$f":"IF($C9=E$5,$D9,0)","v":0},0,0,0,0,0,0]
[407320,"Amortization of Colstrip Outage Return","S",0,{"$f":"IF($C10=E$5,$D10,0)","v":0},0,0,0,0,0,0]
[407322,"Amortization of Spokane River Relicense","H",72939,72939,0,0,0,0,0,0]
[407324,"Amortization of CDA CDR Fund","H",141845,141845,0,0,0,0,0,0]
[407326,"Amortization of Spokane River TDG","H",0,0,0,0,0,0,0,0]
[407331,"Amortization of BPA Parallel Capacity Support","T",0,0,0,0,0,0,0,0]
[407333,"Amortization of CDA Settlement Costs","H",21395,21395,0,0,0,0,0,0]
[407335,"Amortization of ID DSIT","O",0,0,0,0,0,0,0,0]
[407350,"Amortization of WA Renewable Energy Credits","R",0,0,0,0,0,0,0,0]
[407351,"Amortization of CNC Transmission","T",0,0,0,0,0,0,0,0]
[407360,"Amortization of CS2 & COLSTRIP O&M","S",0,0,0,0,0,0,0,0]
[407362,"Amortization of LiDAR O&M","T",0,0,0,0,0,0,0,0]
[407365,"Amortization of Wind Generation","R",0,0,0,0,0,0,0,0]
[407368,"Amortization of Project Compass","O",0,0,0,0,0,0,0,0]
[407380,"Amortization of Wartsila Generators","P",0,0,0,0,0,0,0,0]
[407382,"Amortization of CDA Settlement - Allocated","H",578104,578104,0,0,0,0,0,0]
[407382,"Amortization of CDA Settlement - Direct","H",152118,152118,0,0,0,0,0,0]
[407391,"Amortization of Spokane River TDG","H",0,0,0,0,0,0,0,0]
[407395,"Optional Renewable Power Revenue Offset","R",186347,0,0,0,186347,0,0,0]
[407403,"Amortization of Dissallowed K.F. Plant","S",-134592,0,-134592,0,0,0,0,0]
[407405,"Amortization of Boulder Park Write Off - Idaho","P",0,0,0,0,0,0,0,0]
[407420,"Amortization of CS2 Levelized Return","S",0,0,0,0,0,0,0,0]
["407450/407499","Amortization of BPA Residential Exchange Credit","O",-1889276,0,0,0,0,0,0,-1889276]
[407455,"Amortization of Colstrip Refund","S",0,0,0,0,0,0,0,0]
[407460,"Amortization of Deferred CS2 & COLSTRIP O&M","S",0,0,0,0,0,0,0,0]
[407462,"Amortization of Deferred LiDAR O&M","T",0,0,0,0,0,0,0,0]
[407494,"Amortization of Schedule 98 REC Rev","R",41533,0,0,0,41533,0,0,0]
[407495,"Optional Renew Solar Project Offset","R",-5503,0,0,0,-5503,0,0,0]
[407496,"Def Palouse Wind & Thornton Sw St","R",0,0,0,0,0,0,0,0]
[407497,"Amortization of BPA Settlement","T",0,0,0,0,0,0,0,0]
[407229,"Idaho Earnings Test Amortization","O",0,0,0,0,0,0,0,0]
[407230,"Tax Reform Amortization","O",-3927632,0,0,0,0,0,0,-3927632]
[407311,"Regulatory Debit - AFUDC Amortization","O",41487,0,0,0,0,0,0,41487]
[407319,"AFUDC Equity DFIT Deferral","O",797405,0,0,0,0,0,0,797405]
[407332,"Existing Meters Excess Deprec. Deferral","D",187845,0,0,0,0,0,187845,0]
[407414,"Regulatory Credit - Deferral - FISERVE","O",-527265,0,0,0,0,0,0,-527265]
[407436,"Regulatory Credit - MDM System","D",-2497735,0,0,0,0,0,-2497735,0]
[407468,"Project Compass Deferral - ID","O",0,0,0,0,{"$f":"IF($C46=H$5,$D46,0)","v":0},0,0,0]
[]
[null,null,null,{"$f":"SUM(D8:D46)","v":-6729242},{"$f":"SUM(E8:E46)","v":966401},{"$f":"SUM(F8:F46)","v":-102849},0,222377,0,-2309890,-5505281]

{"sheet":"Intangible","index":4,"n_rows":124,"n_cols":21,"rows_kept":124,"cut":false,"hidden":false,"merged":[[48,13,48,19],[49,13,49,19],[48,11,52,11],[50,13,50,19],[51,13,51,18],[75,11,79,11],[75,13,75,19],[76,13,76,19],[77,13,77,19],[78,13,78,17],[101,13,101,19],[101,11,105,11],[102,13,102,19],[103,13,103,19],[104,13,104,17]]}
["AVISTA UTILITIES"]
["Production and Transmission Related Intangible Plant Analysis"]
["Washington Electric Cost Study"]
["Twelve Months Ended December 31, 2018"]
[]
[null,null,null,"Allocation","Total","WA","ID"]
[null,null,null,"P/T ratio",{"$f":"F7+G7","v":1},0.65390000000000004,0.34610000000000002]
[null,null,null,"4-factor",{"$f":"F8+G8","v":1},0.68594999999999995,0.31405]
[]
["Plant-AMA"]
["Account 301","Organization",null,"P/T ratio",0,{"$f":"ROUND($E11*F$7,0)","v":0},0]
["Account 302","Franchises & Consents",null,"P/T ratio",{"$f":"ROUND(SUM(N69,Q69:S69),0)-1","v":43679748},{"$f":"ROUND($E12*F$7,0)","v":28562187},{"$f":"ROUND($E12*G$7,0)","v":15117561},"Production (Hydro Relicensing)",null,null,null,"System EB","WA Share","EB Adj"]
["Account 302","Franchises & Consents",null,"P/T ratio",{"$f":"ROUND(SUM(O69:P69),0)","v":369470},241596,127874,"Transmission (Forest Service Use Permit)"]
["Account 302","Franchises & Consents",null,"Direct",{"$f":"F14+G14","v":602704},{"$f":"ROUND(T69,0)","v":602704},0,"Distribution  (WA DOT Franchises)"]
["Account 303.00","Misc Intangible Plant",null,"P/T ratio",10389595,{"$f":"ROUND($E15*F$7,0)","v":6793756},{"$f":"ROUND($E15*G$7,0)","v":3595839},"Transmission (Communication Agreements)",null,null,"Transmission 303",10501811,{"$f":"L15*$F$7","v":6867134.2129000006},{"$f":"M15-F15","v":73378.212900000624}]
["Account 303.00","Misc Intangible Plant",null,"4-factor",6599684,{"$f":"ROUND($E16*F$8,0)+1","v":4527054},{"$f":"ROUND($E16*G$8,0)-1","v":2072630},"Common Allocated All Allocation - General Plt",null,null,"General 303 AA",8033663,{"$f":"ROUND(L16*$F$8,0)","v":5510691},{"$f":"M16-F16","v":983637}]
["Account 303.00","Misc Intangible Plant",null,"P/T ratio",150812,{"$f":"ROUND($E17*F$7,0)","v":98616},{"$f":"ROUND($E17*G$7,0)","v":52196},"Common Allocated North Allocation - General Plt",null,null,"General 303 AN",150812,{"$f":"ROUND(L17*$F$7,0)","v":98616},{"$f":"M17-F17","v":0}]
["Account 303.00","Misc Intangible Plant",null,"Direct",{"$f":"F18+G18","v":319716},319716,0,"Distribution  (Substation Agreements)",null,null,"Distribution 303",319716,{"$f":"L18","v":319716},{"$f":"M18-F18","v":0}]
[null,null,null,null,{"$f":"SUM(E11:E18)","v":62111729},{"$f":"SUM(F11:F18)","v":41145629},{"$f":"SUM(G11:G18)","v":20966100},null,null,null,null,null,{"$f":"SUM(M15:M18)","v":12796157.212900002},{"$f":"SUM(N15:N18)","v":1057015.2129000006}]
[null,null,null,{"$f":"E20-E19","v":0},{"$f":"44651922+17459807","v":62111729},{"$f":"29406488+11739141","v":41145629},{"$f":"15245434+5720666","v":20966100},"check",null,null,"Transmission 302",{"$f":"O69","v":369469.5},{"$f":"L20*$F$7","v":241596.10605},{"$f":"M20-F13","v":0.10605000000214204}]
["Accumulated Amortization-AMA",null,null,null,null,null,null,null,null,null,"Distribution 302",{"$f":"T66","v":602703.89},{"$f":"L21","v":602703.89},{"$f":"M21-F14","v":-0.10999999998603016}]
["111000","302000",null,"P/T ratio",{"$f":"ROUND(SUM(N123,P123:S123),0)","v":-11340387},{"$f":"ROUND($E22*F$7,0)","v":-7415479},{"$f":"ROUND($E22*G$7,0)","v":-3924908},"Production (Hydro Relicensing)",null,null,null,null,{"$f":"SUM(M19:M21)","v":13640457.208950002},{"$f":"SUM(N19:N21)","v":1057015.2089500008}]
["111000","302000",null,"P/T ratio",{"$f":"ROUND(O123,0)","v":-178567},{"$f":"ROUND($E23*F$7,0)","v":-116765},{"$f":"ROUND($E23*G$7,0)","v":-61802},"Transmission (Forest Service Use Permit)"]
["111000","302000",null,"Direct",{"$f":"F24+G24","v":-205618},{"$f":"ROUND(T123,0)","v":-205618},{"$f":"ROUND(S123,0)","v":0},"Distribution  (WA DOT Franchises)"]
["111000","303000",null,"P/T ratio",-1731653,{"$f":"ROUND($E25*F$7,0)","v":-1132328},{"$f":"ROUND($E25*G$7,0)","v":-599325},"Transmission (Communication Agreements)",null,null,"Transmission 303",-1848823,{"$f":"L25*$F$7","v":-1208945.3597000001},{"$f":"M25-F25","v":-76617.359700000146}]
["111000","303000",null,"4-factor",-1971754,{"$f":"ROUND($E26*F$8,0)","v":-1352525},{"$f":"ROUND($E26*G$8,0)","v":-619229},"Common Allocated All Allocation - General Plt",null,null,"General 303 AA",-2199788,{"$f":"ROUND(L26*$F$8,0)","v":-1508945},{"$f":"M26-F26","v":-156420}]
["111000","303000",null,"P/T ratio",-78983,{"$f":"ROUND($E27*F$7,0)","v":-51647},{"$f":"ROUND($E27*G$7,0)","v":-27336},"Common Allocated North Allocation - General Plt",null,null,"General 303 AN",-82765,{"$f":"ROUND(L27*$F$7,0)","v":-54120},{"$f":"M27-F27","v":-2473}]
["111000","303000",null,"Direct",{"$f":"F28+G28","v":-39740},-39740,0,"Distribution  (Substation Agreements)",null,null,"Distribution 303",-42673,{"$f":"L28","v":-42673},{"$f":"M28-F28","v":-2933}]
[null,null,null,null,{"$f":"SUM(E22:E28)","v":-15546702},{"$f":"SUM(F22:F28)","v":-10314102},{"$f":"SUM(G22:G28)","v":-5232600},null,null,null,null,null,{"$f":"SUM(M25:M28)","v":-2814683.3596999999},{"$f":"SUM(N25:N28)","v":-238443.35970000015}]
[null,null,null,{"$f":"E30-E29","v":0},{"$f":"-13250607-245358-2050737","v":-15546702},{"$f":"-8664572-245358-1404172","v":-10314102},{"$f":"-4586035-646565","v":-5232600},"check",null,null,"Transmission 302",{"$f":"O119","v":-184725.22},{"$f":"L30*$F$7","v":-120791.821358},{"$f":"M30-F23","v":-4026.8213580000011}]
["Amortization Expense",null,null,null,null,null,null,null,null,null,"Distribution 302",{"$f":"T119","v":-217694.42},{"$f":"L31","v":-217694.42},{"$f":"M31-F24","v":-12076.420000000013}]
["404000","302000",null,"P/T ratio",{"$f":"-ROUND((SUM(N95,P95:S95)),0)","v":906084},{"$f":"ROUND($E32*F$7,0)+1","v":592489},{"$f":"ROUND($E32*G$7,0)-1","v":313595},"Production (Hydro Relicensing)",null,null,null,null,{"$f":"SUM(M29:M31)","v":-3153169.6010579998},{"$f":"SUM(N29:N31)","v":-254546.60105800015}]
["404000","302000",null,"P/T ratio",{"$f":"-ROUND(O95,0)","v":12316},{"$f":"ROUND($E33*F$7,0)","v":8053},4263,"Transmission (Forest Service Use Permit)"]
["404000","302000",null,"Direct",{"$f":"F34+G34","v":24153},{"$f":"-ROUND(T95,0)","v":24153},{"$f":"-ROUND(S95,0)","v":0},"Distribution  (WA DOT Franchises)"]
["404000","303000",null,"P/T ratio",234459,{"$f":"ROUND($E35*F$7,0)","v":153313},{"$f":"ROUND($E35*G$7,0)","v":81146},"Transmission (Communication Agreements)",null,null,"Transmission 303",234459,{"$f":"L35*$F$7","v":153312.7401},{"$f":"M35-F35","v":-0.25990000000456348}]
["404000","303000",null,"4-factor",439979,{"$f":"ROUND($E36*F$8,0)","v":301804},{"$f":"ROUND($E36*G$8,0)","v":138175},"Common Allocated All Allocation - General Plt",null,null,"General 303 AA",{"$f":"439979+61160","v":501139},{"$f":"ROUND(L36*$F$8,0)","v":343756},{"$f":"M36-F36","v":41952}]
["404000","303000",null,"P/T ratio",7561,{"$f":"ROUND($E37*F$7,0)","v":4944},{"$f":"ROUND($E37*G$7,0)","v":2617},"Common Allocated North Allocation - General Plt",null,null,"General 303 AN",{"$f":"E37","v":7561},{"$f":"ROUND(L37*$F$7,0)","v":4944},{"$f":"M37-F37","v":0}]
["404000","303000",null,"Direct",{"$f":"F38+G38","v":5866},5866,0,"Distribution  (Substation Agreements)",null,null,"Distribution 303",{"$f":"E38","v":5866},{"$f":"L38","v":5866},{"$f":"M38-F38","v":0}]
[null,null,null,null,{"$f":"SUM(E32:E38)","v":1630418},{"$f":"SUM(F32:F38)","v":1090622},{"$f":"SUM(G32:G38)","v":539796},null,null,null,null,null,{"$f":"SUM(M35:M38)","v":507878.7401},{"$f":"SUM(N35:N38)","v":41951.740099999995}]
[null,null,null,{"$f":"E40-E39","v":0},{"$f":"1152859+30019+447540","v":1630418},{"$f":"753855+30019+306748","v":1090622},{"$f":"399004+140792","v":539796},"check",null,null,"Transmission 302",{"$f":"E33","v":12316},{"$f":"L40*$F$7","v":8053.4324000000006},{"$f":"M40-F33","v":0.43240000000059808}]
[null,null,null,null,null,null,null,null,null,null,"Distribution 302",{"$f":"E34","v":24153},{"$f":"L41","v":24153},{"$f":"M41-F34","v":0}]
[null,null,null,null,"1.00 Value","Restated for COS","COS Reclass Adj",null,null,null,null,null,{"$f":"SUM(M39:M41)","v":540085.17249999999},{"$f":"SUM(N39:N41)","v":41952.172499999993}]
["Add Hydro Relicensing Related Regulatory Asset Amortization",null,null,null,null,{"$f":"'407 Reg Def-Amort'!E48","v":966401},null,"See 407 Reg Def-Amort Analysis"]
[null,"Total Hydro Relicensing Amortization",null,null,1591096,{"$f":"F32+F43","v":1558890},{"$f":"E44-F44","v":32206}]
[null,"Total Miscellaneous Intangible Amortization",null,null,465927,{"$f":"F39-F32","v":498133},{"$f":"E45-F45","v":-32206}]
[null,null,null,null,null,null,null,null,null,null,null,"Intangible Plant Query  Plant Account 302   Gl Service : ED , Plant Acct : 302000"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ending Balance","Plant Acct","302000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL FERC Acct","101000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL Service","ED"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL Jurisdiction","AN",null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Facility ID","CABINET GORGE HED","FOREST USE PERMITS - IDAHO","LOLO-OXBOW 230KV LINE - OREGON","Long Lake","NOXON RAPIDS HED","POST FALLS HED","WASHINGTON STATE FRANCHISES 028","Note: Long Lake HED values shown under the description \"ke\" beginning July 2012"]
[null,null,null,null,null,null,null,null,null,null,null,"201712",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201801",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201802",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201803",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201804",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201805",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201806",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201807",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201808",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201809",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201810",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201811",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[null,null,null,null,null,null,null,null,null,null,null,"201812",null,8667214.1400000006,369469.5,0,27217345.559999999,6222447.8799999999,1572740.97,602703.89]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"AMA Balance",null,{"$f":"(AVERAGE(N54,N66)+SUM(N55:N65))/12","v":8667214.1400000006},{"$f":"(AVERAGE(O54,O66)+SUM(O55:O65))/12","v":369469.5},0,27217345.559999999,6222447.8799999999,1572740.97,602703.8899999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Production","Transmission","Transmission","Production","Production","Production","Distribution"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Reserve Ledger Current Activity"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gl Ferc Acct:111000","Service:ED","Plant Acct:302000","Plant Acct Desc:INTANG PLT FRANCH&CONSENT"]
[null,null,null,null,null,null,null,null,null,null,null,"Depreciation Expense","Plant Acct","302000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL FERC Acct","111000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL Service","ED"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL Jurisdiction","AN",null,null,null,null,"ID","WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Facility ID Desc","CABINET GORGE HED","FOREST USE PERMITS - IDAHO","Long Lake","NOXON RAPIDS HED","POST FALLS HED","UNSPECIFIED","WASHINGTON STATE FRANCHISES 028"]
[null,null,null,null,null,null,null,null,null,null,null,"201712",null,-16146.46,-1026.3599999999999,-45402.82,-11334.08,-2623.58,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201801",null,-16146.44,-1026.3599999999999,-45402.8,-11334.06,-2623.58,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201802",null,-16146.46,-1026.3599999999999,-45402.879999999997,-11334.06,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201803",null,-16146.48,-1026.3599999999999,-45402.82,-11334.07,-2623.58,0,-2012.74]
[null,null,null,null,null,null,null,null,null,null,null,"201804",null,-16146.44,-1026.3599999999999,-45402.84,-11334.05,-2623.58,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201805",null,-16146.44,-1026.3599999999999,-45402.93,-11334.05,-2623.6,0,-2012.74]
[null,null,null,null,null,null,null,null,null,null,null,"201806",null,-16146.48,-1026.3599999999999,-45402.85,-11334.06,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201807",null,-16146.45,-1026.3599999999999,-45402.86,-11334.07,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201808",null,-16146.44,-1026.3599999999999,-45402.94,-11334.09,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201809",null,-16146.47,-1026.3599999999999,-45402.86,-11334.07,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201810",null,-16146.47,-1026.3599999999999,-45402.85,-11334.05,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201811",null,-16146.44,-1026.3599999999999,-45402.91,-11334.07,-2623.6,0,-2012.75]
[null,null,null,null,null,null,null,null,null,null,null,"201812",null,-16146.48,-1026.3599999999999,-45402.79,-11334.08,-2623.58,0,-2012.74]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"12 ME Dec 2018",{"$f":"SUM(N82:N93)","v":-193757.49000000002},{"$f":"SUM(O82:O93)","v":-12316.320000000002},-544834.32999999996,-136008.78,-31483.119999999995,0,-24152.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Production","Transmission","Production","Production","Production","Distribution","Distribution"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Reserve Ledger Current Activity"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ending Balance","Plant Acct","302000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL FERC Acct","111000"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL Service","ED"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GL Jurisdiction","AN",null,null,null,null,"ID","WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Facility ID Desc","CABINET GORGE HED","FOREST USE PERMITS - IDAHO","Long Lake","NOXON RAPIDS HED","POST FALLS HED","UNSPECIFIED","WASHINGTON STATE FRANCHISES 028"]
[null,null,null,null,null,null,null,null,null,null,null,"201712",null,-3484200.05,-172408.9,-4652122.33,-2482204.9900000002,-268818.09000000003,0,-193541.45]
[null,null,null,null,null,null,null,null,null,null,null,"201801",null,-3500346.49,-173435.26,-4697525.13,-2493539.0499999998,-271441.67,0,-195554.2]
[null,null,null,null,null,null,null,null,null,null,null,"201802",null,-3516492.95,-174461.62,-4742928.01,-2504873.11,-274065.27,0,-197566.95]
[null,null,null,null,null,null,null,null,null,null,null,"201803",null,-3532639.43,-175487.98,-4788330.83,-2516207.1800000002,-276688.84999999998,0,-199579.69]
[null,null,null,null,null,null,null,null,null,null,null,"201804",null,-3548785.87,-176514.34,-4833733.67,-2527541.23,-279312.43,0,-201592.44]
[null,null,null,null,null,null,null,null,null,null,null,"201805",null,-3564932.31,-177540.7,-4879136.5999999996,-2538875.2799999998,-281936.03000000003,0,-203605.18]
[null,null,null,null,null,null,null,null,null,null,null,"201806",null,-3581078.79,-178567.06,-4924539.45,-2550209.34,-284559.63,0,-205617.93]
[null,null,null,null,null,null,null,null,null,null,null,"201807",null,-3597225.24,-179593.42,-4969942.3099999996,-2561543.41,-287183.23,0,-207630.68]
[null,null,null,null,null,null,null,null,null,null,null,"201808",null,-3613371.68,-180619.78,-5015345.25,-2572877.5,-289806.83,0,-209643.43]
[null,null,null,null,null,null,null,null,null,null,null,"201809",null,-3629518.15,-181646.14,-5060748.1100000003,-2584211.5699999998,-292430.43,0,-211656.18]
[null,null,null,null,null,null,null,null,null,null,null,"201810",null,-3645664.62,-182672.5,-5106150.96,-2595545.62,-295054.03000000003,0,-213668.93]
[null,null,null,null,null,null,null,null,null,null,null,"201811",null,-3661811.06,-183698.86,-5151553.87,-2606879.69,-297677.63,0,-215681.68]
[null,null,null,null,null,null,null,null,null,null,null,"201812",null,-3677957.54,-184725.22,-5196956.66,-2618213.77,-300301.21000000002,0,-217694.42]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Average Monthly Average Balance",{"$f":"(AVERAGE(N107,N119)+SUM(N108:N118))/12","v":-3581078.782083333},{"$f":"(AVERAGE(O107,O119)+SUM(O108:O118))/12","v":-178567.05999999997},-4924539.4737499999,-2550209.3633333337,-284559.64,0,-205617.93541666665]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Production","Transmission","Production","Production","Production","Distribution","Distribution"]

{"sheet":"ADFIT ","index":5,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["AVISTA UTILITIES",null,null,null,null,null,null,null,null,null,null,null,"WA"]
["Washington Electric Cost Study"]
["Average - Twelve Months Ended December 31, 2018",null,null,null,null,null,null,null,null,null,null,"Total Plant in Service","Intangible"]
[null,null,null,null,null,null,null,null,null,null,null,"Intangible (excluding CDA)",161261347]
["Accumulated Deferred FIT Assignment to functions",null,null,null,null,null,null,null,null,null,null,"Intangible - common",-111060902.0311]
[null,null,null,"Washington","Intangible","Production","Transmission","Distribution","General","Check",null,"Intangible - common"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M4:M6)","v":50200444.968899995}]
["Intangible",null,"P",-6516550.3052000003,0,{"$f":"D8","v":-6516550.3052000003}]
["Production",null,"P",-124563748.69250001,0,{"$f":"IF($C9=\"P\",$D9,0)","v":-124563748.69250001},{"$f":"IF($C9=\"T\",$D9,0)","v":0},{"$f":"IF($C9=\"D\",$D9,0)","v":0},{"$f":"IF($C9=\"O\",$D9,0)","v":0},null,null,"Total Plant in Service","Production"]
["Transmission",null,"T",-65638036.694100007,0,0,{"$f":"IF($C10=\"T\",$D10,0)","v":-65638036.694100007},0,{"$f":"IF($C10=\"O\",$D10,0)","v":0},null,null,"TOTAL PRODUCTION PLANT",905266231]
["Distribution",null,"D",-157122946.3608,0,0,0,-157122946.3608,{"$f":"IF($C11=\"O\",$D11,0)","v":0},null,null,"CDA LAKE SETTLEMENT",28009662]
["General Utility",null,"O",-9444899.3060999997,0,0,0,0,{"$f":"IF($C12=\"O\",$D12,0)","v":-9444899.3060999997}]
["ADFIT-COMMON ALL",null,"O",-43850783.705948323,{"$f":"D13*O26","v":-13105445.822524235},0,0,0,{"$f":"D13*O25","v":-30745337.883424085},{"$f":"D13-E13-F13-G13-H13-I13","v":0},null,null,{"$f":"SUM(M10:M12)","v":933275893}]
["ADFIT-COMMON ALL WWP",null,"O",-399508.8887694861,{"$f":"D14*O26","v":-119399.05413081903},0,0,0,{"$f":"D14*O25","v":-280109.83463866706},{"$f":"D14-E14-F14-G14-H14-I14","v":0}]
["   Total Accelerated Tax Depr",null,null,{"$f":"SUM(D8:D14)","v":-407536473.9534179},-13224844.876655053,-131080298.99770001,-65638036.694100007,-157122946.3608,-40470347.024162754]
["CDA Lake CDR Fund",null,"P",0,0,{"$f":"IF($C16=\"P\",$D16,0)","v":0},null,null,null,null,null,"Total Plant in Service","Transmission"]
["CDA Lake IPA Fund ",null,"P",0,0,{"$f":"IF($C17=\"P\",$D17,0)","v":0},null,null,null,null,null,"TOTAL TRANSMISSION PLANT",477023994]
["CDA Settlement",null,"P",-4436362.9811085006,0,{"$f":"IF($C18=\"P\",$D18,0)","v":-4436362.9811085006}]
["CDA Settlement Costs",null,"P",165131.83520004168,0,{"$f":"D19","v":165131.83520004168}]
["Total Plant DFIT",null,null,{"$f":"SUM(D15:D19)","v":-411807705.09932631},{"$f":"SUM(E15:E19)","v":-13224844.876655053},-135351530.14360845,-65638036.694100007,-157122946.3608,-40470347.024162754]
[null,null,null,null,null,null,null,null,null,null,null,"Total Plant in Service","Distribution"]
["Colstrip PCB",null,"P",26090.014406083337,{"$f":"IF($C22=\"i\",$D22,0)","v":0},{"$f":"IF($C22=\"P\",$D22,0)","v":26090.014406083337},{"$f":"IF($C22=\"T\",$D22,0)","v":0},{"$f":"IF($C22=\"D\",$D22,0)","v":0},{"$f":"IF($C22=\"O\",$D22,0)","v":0},{"$f":"D25-E25-F25-G25-H25-I25","v":-0.53192316542845219},null,"TOTAL DISTRIBUTION",1109131502]
[{"$f":"'[1]Elec-Dec18'!A28","v":"ADFIT-Plant - AFUDC Equity"},null,"O",-21323.277560739374,{"$f":"IF($C23=\"i\",$D23,0)","v":0},0,0,0,-21323.277560739374]
["AFUDC CWIP Intangibles",null,"I",-114929.30628657466,-114929.30628657466,0,0,0,0,null,null,"Total Plant in Service","General"]
["FMB/MTN Elec","Allocate by Plant",null,-964864.53192316543,{"$f":"ROUND($D$25*E32,0)","v":-16468},{"$f":"ROUND($D$25*F32,0)","v":-306158},{"$f":"ROUND($D$25*G32,0)","v":-156486},{"$f":"ROUND($D$25*H32,0)","v":-363847},{"$f":"ROUND($D$25*I32,0)","v":-121905},null,null,"TOTAL GENERAL PLANT",260548554,null,{"$f":"M25/M27","v":0.701135425300358}]
[null,null,"D",0,null,null,null,null,null,null,null,"Intangible-Common",{"$f":"-M5","v":111060902.0311},null,{"$f":"M26/M27","v":0.29886457469964195}]
["   Total Other Deferred FIT",null,null,{"$f":"SUM(D22:D26)","v":-1075027.101364396},-131397.30628657466,-280067.98559391667,-156486,-363847,-143228.27756073937,{"$f":"D29-E29-F29-G29-H29-I29","v":-0.53192318975925446},null,null,{"$f":"SUM(M25:M26)","v":371609456.03110003},null,{"$f":"SUM(O25:O26)","v":1}]
[]
["      Total Deferred FIT",null,"K",{"$f":"D20+D27","v":-412882732.20069069},-13356242.182941629,-135631598.12920237,-65794522.694100007,-157486793.3608,-40613575.301723495,null,null,"Copied From 1) ADFIT - Dec 2016 AMA.xlsx Elec AMA-Functional"]
[]
[null,"Total","Plant",{"$f":"SUM(E31:I31)","v":2941241290},{"$f":"M7","v":50200444.968899995},{"$f":"M13","v":933275893},{"$f":"M17","v":477023994},{"$f":"M22","v":1109131502},{"$f":"M27","v":371609456.03110003}]
[null,null,null,null,{"$f":"ROUND(E31/$D$31,7)","v":1.7067800000000001E-2},{"$f":"ROUND(F31/$D$31,7)","v":0.3173068},{"$f":"ROUND(G31/$D$31,7)","v":0.16218460000000001},{"$f":"ROUND(H31/$D$31,7)","v":0.3770964},{"$f":"ROUND(I31/$D$31,7)","v":0.1263444}]
[]
["Plant Related Deferred FIT","E-ROO + E-DFIT",null,{"$f":"SUM(E34:I34)","v":-412884000},{"$f":"ROUND(E29,-3)","v":-13356000},{"$f":"ROUND(F29,-3)","v":-135632000},{"$f":"ROUND(G29,-3)","v":-65795000},{"$f":"ROUND(H29,-3)","v":-157487000},{"$f":"ROUND(I29,-3)","v":-40614000}]
["Restate 2018 to EOP","E-EOP18","Direct",{"$f":"SUM(E35:I35)","v":-36000},{"$f":"-12993000-E34","v":363000},{"$f":"-135795000-F34","v":-163000},{"$f":"-65974000-G34","v":-179000},{"$f":"-157917000-H34","v":-430000},{"$f":"-40241000-I34","v":373000}]
["Eliminate AMI Rate Base EOP","E-AMI","Direct",{"$f":"SUM(E36:I36)","v":2820000},{"$f":"ROUND(SUM(10036,602909,888785,30889,1104417,32367),-3)","v":2669000},null,null,{"$f":"ROUND(5663,-3)","v":6000},{"$f":"2820000-SUM(E36:H36)","v":145000}]
["PF 2019 Threshhold Capital","E-PCAP","Direct",-2053000,{"$f":"-2053000-SUM(F37:I37)","v":-2053000}]
[]
["Pro Forma Plant Related Deferred FIT",null,null,{"$f":"SUM(E39:I39)","v":-412153000},{"$f":"SUM(E34:E37)","v":-12377000},{"$f":"SUM(F34:F37)","v":-135795000},{"$f":"SUM(G34:G37)","v":-65974000},{"$f":"SUM(H34:H37)","v":-157911000},{"$f":"SUM(I34:I37)","v":-40096000}]
[]
["Other Debits and Credits Deferred FIT"]
["Regulatory Asset AFUDC","Allocate by Plant",null,-2000,{"$f":"ROUND($D$42*E32,-3)","v":0},{"$f":"ROUND($D$42*F32,-3)","v":-1000},0,-1000,0]
["Kettle Falls Disallowed Plant",null,"P",{"$f":"ROUND((23565-23565),-3)","v":0},{"$f":"IF($C43=\"I\",$D43,0)","v":0},{"$f":"IF($C43=\"P\",$D43,0)","v":0},{"$f":"IF($C43=\"T\",$D43,0)","v":0},{"$f":"IF($C43=\"D\",$D43,0)","v":0},{"$f":"IF($C43=\"O\",$D43,0)","v":0}]
["WNP3 Settlement Exchange Power",null,"P",{"$f":"ROUND((-513675+513675),-3)","v":0},0,0,0,0,0]
["CDA Settlement",null,"P",{"$f":"ROUND((-79789+71914),-3)","v":-8000},0,-8000,0,0,0]
["CDA/CDR Fund",null,"P",0,0,0,0,0,0]
["Spokane River Relicensing",null,"P",{"$f":"ROUND((-38246+28339),-3)","v":-10000},0,-10000,0,0,0]
["Spokane River PM&Es",null,"P",{"$f":"ROUND((-24308+15265),-3)","v":-9000},0,-9000,0,0,0]
["Montana Riverbed Lease",null,"P",{"$f":"ROUND((-118743+118743),-3)","v":0},0,0,0,0,0]
["Lancaster Generation",null,"P",{"$f":"-317000+317000","v":0},0,0,0,0,0]
[]
["Total Other Debits and Credits Deferred FIT",null,null,{"$f":"SUM(D42:D51)","v":-29000},0,-28000,0,-1000,0]
[]
["Total Cost of Service Deferred FIT",null,null,{"$f":"D39+D52","v":-412182000},-12377000,-135823000,-65974000,-157912000,-40096000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["AVISTA UTILITIES"]
["Idaho Electric Cost Study"]
[{"$f":"A3","v":"Average - Twelve Months Ended December 31, 2018"}]
[]
["Accumulated Deferred FIT Assignment to functions"]
["Adjustment C",null,null,"Idaho","Production","Transmission","Distribution","Other","Check"]
["ACCELERATED TAX DEPRECIATION"]
[]
["Production",null,"P",-32336661,{"$f":"IF($C73=\"P\",$D73,0)","v":-32336661},{"$f":"IF($C73=\"T\",$D73,0)","v":0},{"$f":"IF($C73=\"D\",$D73,0)","v":0},{"$f":"IF($C73=\"O\",$D73,0)","v":0}]
["Transmission",null,"T",-14350880,0,-14350880,0,0]
["Distribution",null,"D",-33792522,0,0,-33792522,0]
["General Utility",null,"O",-5186594,0,0,0,-5186594]
["ADFIT-COMMON ALL",null,"O",-3066322,0,0,0,-3066322]
["ADFIT-COMMON ALL WWP",null,"O",-455305,0,0,0,-455305]
["   Total Accelerated Tax Depr",null,null,{"$f":"SUM(D73:D78)","v":-89188284},{"$f":"SUM(E73:E78)","v":-32336661},{"$f":"SUM(F73:F78)","v":-14350880},{"$f":"SUM(G73:G78)","v":-33792522},{"$f":"SUM(H73:H78)","v":-8708221}]
[]
["Colstrip PCB",null,"P",-214644,{"$f":"IF($C81=\"P\",$D81,0)","v":-214644},{"$f":"IF($C81=\"T\",$D81,0)","v":0},{"$f":"IF($C81=\"D\",$D81,0)","v":0},{"$f":"IF($C81=\"O\",$D81,0)","v":0}]
["FMB/MTN Elec",null,"Allocate by Plant",-1056009,{"$f":"ROUND($D$82*E89,0)","v":-409563},{"$f":"ROUND($D$82*F89,0)","v":-172293},{"$f":"ROUND($D$82*G89,0)","v":-404231},{"$f":"ROUND($D$82*H89,0)","v":-69922},{"$f":"SUM(E82:H82)","v":-1056009}]
["DSM (Elec-ID) Elec",null,"D",-234832,{"$f":"IF($C83=\"P\",$D83,0)","v":0},{"$f":"IF($C83=\"T\",$D83,0)","v":0},{"$f":"IF($C83=\"D\",$D83,0)","v":-234832},{"$f":"IF($C83=\"O\",$D83,0)","v":0}]
["   Total Other Deferred FIT",null,null,{"$f":"SUM(D81:D83)","v":-1505485},{"$f":"SUM(E81:E83)","v":-624207},{"$f":"SUM(F81:F83)","v":-172293},{"$f":"SUM(G81:G83)","v":-639063},{"$f":"SUM(H81:H83)","v":-69922}]
[]
["      Total Deferred FIT","Adj C",null,{"$f":"D79+D84","v":-90693769},{"$f":"E79+E84","v":-32960868},{"$f":"F79+F84","v":-14523173},{"$f":"G79+G84","v":-34431585},{"$f":"H79+H84","v":-8778143},{"$f":"SUM(E86:H86)","v":-90693769}]
[]
[null,"Total","Plant in Service",{"$f":"SUM(E88:H88)","v":1003871908},{"$f":"367473563+10834416+11034126","v":389342105},{"$f":"163053472+733061","v":163786533},384273788,{"$f":"58812045+53835+5092017+2511585","v":66469482}]
[null,null,null,null,{"$f":"E88/$D$88","v":0.38784042256514661},{"$f":"F88/$D$88","v":0.16315481257594869},{"$f":"G88/$D$88","v":0.38279165393280434},{"$f":"H88/$D$88","v":6.6213110926100341E-2}]
["Deferred FIT",null,"Direct",{"$f":"SUM(E90:H90)","v":-90693000},{"$f":"ROUND(E86,-3)+1000","v":-32960000},{"$f":"ROUND(F86,-3)","v":-14523000},{"$f":"ROUND(G86,-3)","v":-34432000},{"$f":"ROUND(H86,-3)","v":-8778000}]
["Deferred Gain on Office Bldg","Adj D","O",0,{"$f":"IF($C91=\"P\",$D91,0)","v":0},{"$f":"IF($C91=\"T\",$D91,0)","v":0},{"$f":"IF($C91=\"D\",$D91,0)","v":0},{"$f":"IF($C91=\"O\",$D91,0)","v":0}]
["KF and BP Disallowance","Adj G","P",0,{"$f":"IF($C92=\"P\",$D92,0)","v":0},{"$f":"IF($C92=\"T\",$D92,0)","v":0},{"$f":"IF($C92=\"D\",$D92,0)","v":0},{"$f":"IF($C92=\"O\",$D92,0)","v":0}]
["PF Production Factor Adj","PF 2","Direct",{"$f":"SUM(E93:H93)","v":0},0,0,0,0]
["PF 2008 Capital","PF6","Direct",{"$f":"SUM(E94:H94)","v":0},0,0,0,0]
["PF 2009 Capital","PF7","Direct",{"$f":"SUM(E95:H95)","v":0},0,0,0,0]
["PF Spokane River Relicensing","PF10","P",0,{"$f":"IF($C96=\"P\",$D96,0)","v":0},{"$f":"IF($C96=\"T\",$D96,0)","v":0},{"$f":"IF($C96=\"D\",$D96,0)","v":0},{"$f":"IF($C96=\"O\",$D96,0)","v":0}]
["PF CDA Settlement","PF11","P",0,{"$f":"IF($C97=\"P\",$D97,0)","v":0},{"$f":"IF($C97=\"T\",$D97,0)","v":0},{"$f":"IF($C97=\"D\",$D97,0)","v":0},{"$f":"IF($C97=\"O\",$D97,0)","v":0}]
["PF Montana Lease","PF12","P",0,{"$f":"IF($C98=\"P\",$D98,0)","v":0},{"$f":"IF($C98=\"T\",$D98,0)","v":0},{"$f":"IF($C98=\"D\",$D98,0)","v":0},{"$f":"IF($C98=\"O\",$D98,0)","v":0}]
["PF Idaho AMR","PF16","D",0,{"$f":"IF($C99=\"P\",$D99,0)","v":0},{"$f":"IF($C99=\"T\",$D99,0)","v":0},{"$f":"IF($C99=\"D\",$D99,0)","v":0},{"$f":"IF($C99=\"O\",$D99,0)","v":0}]
[]
["Total Pro Forma Deferred FIT",null,null,{"$f":"SUM(D90:D99)","v":-90693000},{"$f":"SUM(E90:E99)","v":-32960000},{"$f":"SUM(F90:F99)","v":-14523000},{"$f":"SUM(G90:G99)","v":-34432000},{"$f":"SUM(H90:H99)","v":-8778000}]

{"sheet":"WA Retail Load","index":6,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["WUTC Docket No. UE-19____"]
["Normalized Usage by Month"]
["Twelve Months Ended December 31, 2018"]
["WASHINGTON ELECTRIC SYSTEM"]
[null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual Total"]
["Revenue Run Billed Usage"]
[null,"Residential Schedule 001/002",null,290781554.06200004,227575425.00199997,233136064.20699999,195827349.29800999,159686942.68922001,149276244.59101999,162965398.63099,205105319.92300999,165901549.60800001,149412587.058,181215231.46800002,245751615.04300001,{"$f":"SUM(D7:O7)","v":2366635281.5802498}]
[null,"General Svc Schedule 011/012",null,64968017.218999997,55958109.224000007,55740105.916000001,50692240.114,46948189.068040006,46100696.828000002,48168343.664999999,55210418.299999997,48512488.306999996,45641900.678999998,47727635.006999999,57034428.782000005,{"$f":"SUM(D8:O8)","v":622702573.10904002}]
[null,"Large Gen Svc Schedule 021/022",null,125937052.837,113399610.21799999,112223930.37199999,111090733.608,112273215.22399999,113413112.17999999,114915539.823,124759437.27500001,113710882.943,110448175.94400001,109051287.447,119116948.25899999,1380339926.1299999]
[null,"Extra Large Gen Schedule 25",null,85895739.5,82389792.700000003,59452404.5,91719050,50375927.600000001,94067376.900000006,91430986,95462593.189999998,98727948.689999998,89411353.701000005,95120660.879999995,88922599.900000006,1022976433.5610001]
[null,"Pumping Schedule 30/31/32",null,5199805.6780000003,4295325.2790000001,4226647.8,5323831.0029999996,10126135.685010001,18516636.552000001,23083952.635000002,28015837.673000004,23798947.989000004,12939703.931,6282585.2740000002,3998282.9430000004,145807692.44200999]
[null,"Street and Area Lights",null,1677509.9980299999,1505148.60812,1474261.9374699998,1503568.73648,1565521.43,1544276.2680000002,1517440.93136,1578869.159,1535455.0220000001,1534835.862,1517745.8010000002,1587397.7870499999,18542031.540509999]
["Total Revenue Run Billed Usage",null,null,{"$f":"SUM(D7:D12)","v":574459679.29402995},{"$f":"SUM(E7:E12)","v":485123411.03111994},466253414.73246998,456156772.75949001,380975931.69627005,422918343.31901997,442081661.68535,510132475.52000999,452187272.55900007,409388557.17499995,440915145.87700003,516411272.71405011,5557003938.3628101]
[]
["Net Unbilled Usage "]
[null,"Residential Schedule 001/002",null,-16807345,-11417924,-2538576,-21339210,-11882566,-6167987,22269076,-2879705,-26562728,10771561,32345083,12693423,{"$f":"SUM(D16:O16)","v":-21516898}]
[null,"General Svc Schedule 011/012",null,-5056613,226900,-1492318,-3135024,-94436,-612520,5513065,-3427114,-5492340,4178114,5066221,-648853,{"$f":"SUM(D17:O17)","v":-4974918}]
[null,"Large Gen Svc Schedule 021/022",null,-17335146,2932085,-3284636,-1903474,4768104,131589,11356739,-11474036,-10604470,11698081,8235200,-7362830,-12842794]
[null,"Extra Large Gen Schedule 25",null,9694517,4244920,29856455,3968084,42504574,1641436,1095411,3752803,-8960868,5368369,-7500338,4713680,90379043]
[null,"Pumping Schedule 30/31/32",null,329032,-115788,-137275,22402,930226,2217873,2033088,726896,-1530437,-1792052,-1310272,-1358868,14825]
[null,"Street and Area Lights",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Unbilled Usage",null,null,{"$f":"SUM(D16:D21)","v":-29175555},{"$f":"SUM(E16:E21)","v":-4129807},22403650,-22387222,36225902,-2789609,42267379,-13301156,-53150843,30224073,36835894,8036552,51059258]
[]
["Schedule Shifting Adjustment"]
[null,"General Svc Schedule 011/012",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D25:O25)","v":0}]
[null,"Large Gen Svc Schedule 021/022",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D26:O26)","v":0}]
["Schedule Shifting Adjustment",null,null,{"$f":"SUM(D25:D26)","v":0},{"$f":"SUM(E25:E26)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D27:O27)","v":0}]
[]
["Other Usage Adjustments"]
[null,"Extra Large Gen Schedule 25",null,-2351888,424875,{"$f":"6266574-424875","v":5841699},{"$f":"3075877-6266574","v":-3190697},{"$f":"4262752-3075877","v":1186875},{"$f":"-15075-4262752","v":-4277827},{"$f":"2921121+15075","v":2936196},{"$f":"2433674-2921121","v":-487447},{"$f":"2077947-2433674","v":-355727},{"$f":"2418885-2077947","v":340938},{"$f":"3721162-2418885","v":1302277},{"$f":"2560423-3721162","v":-1160739},{"$f":"SUM(D30:O30)","v":208535}]
[]
["Weather Adjustment"]
[null,"Residential Schedule 001/002",null,18971503,-7032417,-1444882,-357275,11243016,8391924,-18566532,-7591998,6498512,1439157,2721258,15313039,{"$f":"SUM(D33:O33)","v":29585305}]
[null,"General Svc Schedule 011/012",null,1930773,-710823,-145200,-42341,444874,944145,-2529540,-1038088,865276,123714,198669,1536838,{"$f":"SUM(D34:O34)","v":1578297}]
[null,"Large Gen Svc Schedule 021/022",null,991519,-366102,-74963,-40508,-779435,825754,-2819054,-1160154,980935,50179,20819,778502,-1592508]
[null,"Extra Large Gen Schedule 25",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Pumping Schedule 30/31/32",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Street and Area Lights",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Weather Adjustment",null,null,{"$f":"SUM(D33:D38)","v":21893795},{"$f":"SUM(E33:E38)","v":-8109342},-1665045,-440124,10908455,10161823,-23915126,-9790240,8344723,1613050,2940746,17628379,29571094]
[]
["Normalized Test Year Usage"]
[null,"Residential Schedule 001/002",null,{"$f":"D7+D16+D33","v":292945712.06200004},209125084.00199997,229152606.20699999,174130864.29800999,159047392.68922001,151500181.59101999,166667942.63099,194633616.92300999,145837333.60800001,161623305.058,216281572.46800002,273758077.04299998,{"$f":"SUM(D42:O42)","v":2374703688.5802498}]
[null,"General Svc Schedule 011/012",null,{"$f":"D8+D17+D34+D25","v":61842177.218999997},{"$f":"E8+E17+E34+E25","v":55474186.224000007},54102587.916000001,47514875.114,47298627.068040006,46432321.828000002,51151868.664999999,50745216.299999997,43885424.306999996,49943728.678999998,52992525.006999999,57922413.782000005,619305952.10904002]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D9+D18+D35+D26","v":109593425.837},115965593.21799999,108864331.37199999,109146751.608,116261884.22399999,114370455.17999999,123453224.823,112125247.27500001,104087347.943,122196435.94400001,117307306.447,112532620.25899999,1365904624.1299999]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D10+D19+D30+D36","v":93238368.5},{"$f":"E10+E19+E30+E36","v":87059587.700000003},95150558.5,92496437,94067376.599999994,91430985.900000006,95462593,98727949.189999998,89411353.689999998,95120660.701000005,88922599.879999995,92475540.900000006,1113564011.5609999]
[null,"Pumping Schedule 31/32",null,{"$f":"D11+D20+D37","v":5528837.6780000003},4179537.2790000001,4089372.8,5346233.0029999996,11056361.685010001,20734509.552000001,25117040.635000002,28742733.673000004,22268510.989000004,11147651.931,4972313.2740000002,2639414.9430000004,145822517.44200999]
[null,"Street and Area Lights",null,1677509.9980299999,1505148.60812,1474261.9374699998,1503568.73648,1565521.43,1544276.2680000002,1517440.93136,1578869.159,1535455.0220000001,1534835.862,1517745.8010000002,1587397.7870499999,18542031.540509999]
["Total Normalized Test Year Usage",null,null,{"$f":"SUM(D42:D47)","v":564826031.29402995},{"$f":"SUM(E42:E47)","v":473309137.03112},492833718.73246998,430138729.75949001,429297163.69626999,426012730.31901997,463370110.68535,486553632.52000999,407025425.55900007,441566618.17499995,481994062.87700003,540915464.71404994,5637842825.3628101]
[]
[null,"Percentage of Annual Usage",null,{"$f":"ROUND(D48/$P$48,3)","v":0.1},{"$f":"ROUND(E48/$P$48,3)","v":8.4000000000000005E-2},{"$f":"ROUND(F48/$P$48,3)+0.001","v":8.7999999999999995E-2},7.5999999999999998E-2,7.5999999999999998E-2,7.5999999999999998E-2,8.2000000000000003E-2,8.5999999999999993E-2,7.1999999999999995E-2,7.8E-2,{"$f":"ROUND(N48/$P$48,3)+0.001","v":8.6000000000000007E-2},9.6000000000000002E-2,{"$f":"SUM(D50:O50)","v":0.99999999999999978}]
[]
[null,"Residential Usage",null,{"$f":"D42","v":292945712.06200004},{"$f":"E42","v":209125084.00199997},229152606.20699999,174130864.29800999,159047392.68922001,151500181.59101999,166667942.63099,194633616.92300999,145837333.60800001,{"$f":"M42","v":161623305.058},216281572.46800002,273758077.04299998,{"$f":"SUM(D52:O52)","v":2374703688.5802498}]
[null,"Schedule 001/002 Customers",null,215198,214198,216045,214971,215099,214829,215408,215648,214122,218388,216943,217126,2587975]
[null,"Schedule 001/002 Norm Use/Customer",null,{"$f":"D52/D53","v":1361.2845475422637},{"$f":"E52/E53","v":976.31669764423555},1060.6707223356245,810.02025528099136,739.41484009325939,705.21289765823042,773.73144280152087,902.55238593916931,681.09457976293891,{"$f":"M52/M53","v":740.07411148048425},{"$f":"N52/N53","v":996.95114600609384},{"$f":"O52/O53","v":1260.8258662850142},917.59143290806514]
[null,"Non-Residential Group Usage",null,{"$f":"D43+D44+D46","v":176964440.734},{"$f":"E43+E44+E46","v":175619316.72100002},167056292.088,162007859.72499999,174616872.97705001,181537286.56,199722134.123,191613197.248,170241283.23899999,{"$f":"M43+M44+M46","v":183287816.55399999},175272144.72799999,173094448.984,2131033093.6810496]
[null,"Non-Residential Group Customers",null,36868,36445,36552,36255,36544,36486,36644,36729,35718,37528,36613,36651,439033]
[null,"Non-Residential Group Norm Use/Customer",null,{"$f":"D55/D56","v":4799.9468572746009},{"$f":"E55/E56","v":4818.749258361916},4570.3734977019039,4468.5659833126465,4778.2638183299587,4975.5327128213567,5450.336593248554,5216.9456627732852,4766.2602396270786,{"$f":"M55/M56","v":4884.028366926028},{"$f":"N55/N56","v":4787.1560573566758},{"$f":"O55/O56","v":4722.7756127800058},4853.9246336404085]