{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PF Revenue Adj","Reconcile ROO to Restated","2010","2010 Component Analysis"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PF Revenue Adj","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["WA Electric Revenue Normalization Adjustment--12-mo ended December 31, 2018"]
[]
[null,"$000's",null,null,null,null,"Total","Pro Forma"]
["Rates Effective May 1st, 2018",null,null,"CB Restated",null,"PF","Adjust","Revenue Adj"]
[null,"Revenue","WP Source",null,"WP Source"]
[null,"Base Rate Revenue","E-PREV-2",{"$f":"'Reconcile ROO to Restated'!L5","v":493175},"E-PREV-5",{"$f":"502705-280","v":502425},{"$f":"F6-D6","v":9250},{"$f":"ROUND(G6,0)","v":9250},null,"Pro Forma includes Sch 25 unbilled in this total"]
[]
[null,"Weather Normalization","E-PREV-2",{"$f":"'Reconcile ROO to Restated'!L7","v":2745},"E-PREV-5",2768,{"$f":"F8-D8","v":23},{"$f":"ROUND(G8,0)","v":23}]
[]
[null,"Unbilled Revenue","E-PREV-2",{"$f":"'Reconcile ROO to Restated'!L17","v":2150},"E-PREV-5",-3174,-5324,{"$f":"ROUND(G10,0)","v":-5324},null,"Schedule 25 Unbilled per books was $5,648"]
[null,"Sales to Ultimate Consumers",null,{"$f":"SUM(D6:D10)","v":498070},null,{"$f":"SUM(F6:F10)","v":502019},{"$f":"IF(ROUND(F11-D11,3)<>ROUND(SUM(G6:G10),3),#VALUE!,SUM(G6:G10))","v":3949},{"$f":"SUM(H6:H10)","v":3949}]
[null,"Other Revenue",null,null,null,{"$f":"IF(F11=ROUND('[1]Exh 1'!$D$28,0),\"\",\"check workpapers\")","v":""}]
[null,"Decoupled Deferred Revenue",null,{"$f":"'Reconcile ROO to Restated'!L28","v":13186.297},null,0,-13186.297,{"$f":"ROUND(G13,0)","v":-13186},null,"Elim 2018 Decoupling deferrals - GRC resets Base"]
[null,"Provision For Rate Refund - Decoupling",null,{"$f":"'Reconcile ROO to Restated'!L30","v":0},null,0,{"$f":"F14-D14","v":0},{"$f":"ROUND(G14,0)","v":0},null,"Elim Decoupling Earnings Sharing in Test Period"]
[null,"Provision For Rate Refund - Tax Reform",null,{"$f":"'Reconcile ROO to Restated'!L31","v":-8155},null,0,8155,{"$f":"ROUND(G15,0)","v":8155},null,"Elim Tax Reform Deferral (Jan - April) "]
[null,"Total Rev.",null,{"$f":"SUM(D11:D15)","v":503101.29700000002},null,{"$f":"SUM(F11:F15)","v":502019},{"$f":"SUM(G11:G15)","v":-1082.2970000000005},{"$f":"SUM(H11:H15)","v":-1082}]
[null,null,null,null,null,0]
[null,"Expense"]
[null,"State Excise Tax","CF",null,null,null,null,{"$f":"ROUND(H$11*$I19,0)","v":152},{"$f":"'Reconcile ROO to Restated'!M49","v":3.8587000000000003E-2},"Effective Rate"]
[null,"Uncollectibles","CF",null,null,null,null,{"$f":"ROUND(H$11*$I20,0)","v":15},{"$f":"'Reconcile ROO to Restated'!M50","v":3.7820000000000002E-3},"Effective Rate"]
[null,"Commission Fees","CF",null,null,null,null,8,{"$f":"'Reconcile ROO to Restated'!M51","v":2E-3},"Nominal Rate"]
[null,null,null,null,null,null,null,{"$f":"SUM(H19:H21)","v":175},{"$f":"SUM(I19:I21)","v":4.4369000000000006E-2},"Conver. Factor b4 FIT"]
[]
[null,"Operating Income before FIT",null,null,null,null,null,{"$f":"H16-H22","v":-1257}]
[null,"FIT Expense",null,null,null,null,null,{"$f":"ROUND(H24*$I25,0)","v":-264},0.21,"Diff"]
[null,"Net Operating Income",null,null,null,null,null,{"$f":"H24-H25","v":-993}]
[]
[null,"* zero in Pro-forma revenues",null,null,null,null,null,null,{"$f":"H11","v":3949},"Revenue"]
[null,null,null,null,null,null,null,null,{"$f":"I22","v":4.4369000000000006E-2},"Conver. Factor b4 FIT"]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(I28*I29,0)","v":175},"Rev related exp."]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H19:H21)","v":175},"check"]
[null,null,null,null,null,null,null,null,{"$f":"I30-I31","v":0}]

{"sheet":"Reconcile ROO to Restated","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,12,8,13],[0,11,1,11],[26,12,29,13]]}
["WA Electric Normalized Revenue --12-months ended December 31, 2018",null,null,null,null,null,null,null,null,null,null,"Normalized Restated"]
[null,"$000's",null,null,"Eliminate","Weather","Eliminate","Misc","Eliminate WA","Commission Basis","Total"]
[null,null,null,"Actuals","B&O Taxes","Normalization","Adder Sched","Restating","Power Cost Def","Power Supply Adj","Adjust","Base Revenue"]
[null,"Revenue","WP Source",1,2.0099999999999998,2.1,2.11,2.12,2.13,2.1800000000000002]
[null,"Billed Base Rate Revenue","Calc",{"$f":"D18-SUM(D8:D17)","v":493175},null,null,null,null,null,null,{"$f":"SUM(E5:J5)","v":0},{"$f":"D5+K5","v":493175}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Weather Normalization",null,null,null,2745,null,null,null,null,{"$f":"SUM(E7:J7)","v":2745},2745," Weather adj excludes weather related revenue captured in decoupling mechanism (began January 2015)"]
[null,"B&O Tax - Sch 58","B&O",{"$f":"-K8","v":18620},-18620,null,null,null,null,null,-18620,0]
[null,"BPA Residential Exchange Credit - Sch 59","Calc",{"$f":"-K9","v":-1996},null,null,{"$f":"ROUND(G41*$M$53,0)","v":1996},null,null,null,1996,0]
[null,"Tax Reform Refund - Sch 74","Calc",{"$f":"-K10","v":-4110},null,null,{"$f":"ROUND(G48*$M$53,0)","v":4110},null,null,null,4110,0]
[null,"Decoupling Amort - Sch 75","EAS-2",{"$f":"-K11","v":8794},null,null,{"$f":"ROUND((-G27)*$M$53,0)","v":-8794},null,null,null,{"$f":"SUM(E11:J11)","v":-8794},{"$f":"D11+K11","v":0}]
[null,"Public Purpose Rider - Sch 89/91/92","Calc",{"$f":"-K12","v":26479},null,null,{"$f":"ROUND(G46*$M$53,0)","v":-26479},null,null,null,-26479,0]
[null,"Power Cost Surcharge - ERM Sch 93","EWPC",0,null,null,null,null,0,0,0,0]
[null,"BPA Capacity Support Rebate - Sch 94","Calc",0,null,null,{"$f":"ROUND(G43*$M$53,0)","v":0},null,null,null,0,0]
[null,"Optional Renewable Power - Sch 95","Calc",195,null,null,{"$f":"ROUND(G45*$M$53,0)","v":-195},null,null,null,-195,0]
[null,"REC Revenue Rebate - Sch 98","Calc",{"$f":"-K16","v":-2639},null,null,{"$f":"ROUND(G39*$M$53,0)","v":0},null,{"$f":"ROUND(I39*$M$53,0)+5","v":2639},null,2639,0]
[null,"Unbilled Revenue","ROO / Calc",2620,null,null,{"$f":"ROUND((G38+G40+G42+G44+G47)*$M$53,0)+0","v":-470},null,null,null,-470,2150]
[null,"Sales to Ultimate Consumers","ROO",541138,{"$f":"SUM(E5:E17)","v":-18620},2745,-29832,0,2639,0,-43068,498070,"   Rounding matches column B results"]
[]
[null,"Sales for Resale Revenue - ERM Related","E-APS",59999,null,null,null,null,null,-24436,-24436,35563]
[null,"Sales for Resale Revenue - Other","Calc",{"$f":"D22-D20","v":13},null,null,null,null,null,null,0,13,null,null,"Solar Select"]
[null,"     Total Sales for Resale Revenue","ROO",60012,{"$f":"SUM(E20+E21)","v":0},{"$f":"SUM(F20+F21)","v":0},0,0,0,-24436,-24436,35576]
[]
[null,"Other Revenue - Misc","ROO / Calc",{"$f":"60951-SUM(D25:D31)","v":1195},null,null,null,null,null,null,{"$f":"SUM(E24:J24)","v":0},{"$f":"D24+K24","v":1195}]
[null,"Other Revenue - ERM Related","E-APS",{"$f":"67114-SUM(D27:D29)-688","v":60930.050999999999},null,null,null,null,null,-50972,{"$f":"SUM(E25:J25)","v":-50972},{"$f":"D25+K25","v":9958.0509999999995}]
[null,"Other Revenue - From Electric Property","ROO / B&O",{"$f":"1845+14","v":1859},-13,null,null,null,null,null,{"$f":"SUM(E26:J26)","v":-13},{"$f":"D26+K26","v":1846}]
[null,"Other Revenue - Decoupling Amortization","ROO/EAS",{"$f":"(-7545365-857983)/1000","v":-8403.348},null,null,{"$f":"-D27","v":8403.348},null,null,null,{"$f":"SUM(E27:J27)","v":8403.348},0," Decoupling deferred revenue is net of revenue related expenses to be paid with recovery through surcharge or rebate in a later period."]
[null,"Other Revenue - Decoupling Deferred Revenue","ROO/WN",{"$f":"(8398269+6898028)/1000","v":15296.297},null,-2110,null,null,null,null,{"$f":"SUM(E28:J28)","v":-2110},13186.297]
[null,"Other Revenue - Contra Decoupling Deferral","ROO/EAS",-1397,null,null,{"$f":"-D29","v":1397},null,null,null,{"$f":"SUM(E29:J29)","v":1397},0]
[null,"Provision For Rate Refund - Decoupling","ROO/MR",-374,null,null,null,374,null,null,{"$f":"SUM(E30:J30)","v":374},0]
[null,"Provision For Rate Refund - Tax Reform","ROO",-8155,null,null,null,null,null,null,{"$f":"SUM(E31:J31)","v":0},-8155]
[null,"     Total Other Revenue",null,{"$f":"SUM(D24:D31)","v":60951},{"$f":"SUM(E24:E31)","v":-13},-2110,9800.348,374,0,-50972,-42920.652000000002,{"$f":"SUM(L24:L31)","v":18030.347999999998}]
[null,"     Total Revenue",null,{"$f":"D18+D20+D32","v":662088},{"$f":"E18+E20+E32","v":-18633},635,-20031.652000000002,374,2639,-75408,-110424.652,551663.348]
[]
[null,"Expense"]
[null,"B&O Tax","B&O",{"$f":"18664-83","v":18581},-18544,null,null,null,null,null,{"$f":"SUM(E36:J36)","v":-18544},{"$f":"D36+K36","v":37}]
[null,"Power Cost Surcharge Amort. - ERM","EWPC",0,null,null,null,null,{"$f":"-D37","v":0},null,0,0,"amort only; excluding deferrals"]
[null,"Power Cost Surcharge Amort. - ERM Unbilled","EAS-2",0,null,null,{"$f":"-D38","v":0},null,null,null,0,0]
[null,"REC Rev Rebate Amort.","EWPC",-2517,null,null,null,null,{"$f":"-D39","v":2517},null,2517,0,"amort only; excluding deferrals"]
[null,"REC Rev Rebate Unbilled Amort","EAS-2",42,null,null,{"$f":"-D40","v":-42},null,null,null,-42,0]
[null,"BPA Residential Exchange","EAS-2",-1907,null,null,{"$f":"-D41","v":1907},null,null,null,1907,0]
[null,"BPA Residential Exchange Unbilled","EAS-2",18,null,null,{"$f":"-D42","v":-18},null,null,null,-18,0]
[null,"BPA Capacity Support Amort","EAS-2",0,null,null,{"$f":"-D43","v":0},null,null,null,0,0,"amort only; excluding deferrals"]
[null,"BPA Capacity Support Unbilled ","EAS-2",0,null,null,0,null,null,null,0,0]
[null,"Optional Renewable Power - Revenue Offset","EAS-2",186,null,null,-186,null,null,null,-186,0]
[null,"Public Purpose Rider","EAS-2",25304,null,null,-25304,null,null,null,-25304,0]
[null,"Public Purpose Rider Unbilled","EAS-2",389,null,null,-389,null,null,null,-389,0]
[null,"Tax Reform Amortization","EAS-2",-3928,null,null,3928,null,null,null,3928,0]
[null,"State Excise Tax","CF",{"$f":"ROUND(D$18*$M49,0)","v":20881},null,{"$f":"ROUND(F$18*$M49,0)","v":106},-1151,0,102,0,-943,19938,{"$f":"'[2]CF '!$E$16","v":3.8587000000000003E-2},"Effective Rate"]
[null,"Uncollectibles","CF",{"$f":"ROUND(D$18*$M50,0)","v":2047},null,10,-113,0,{"$f":"ROUND(I$18*$M50,0)+5","v":15},0,-88,1959,{"$f":"'[2]CF '!$E$12","v":3.7820000000000002E-3},"Effective Rate"]
[null,"Commission Fees","CF",{"$f":"ROUND(D$18*$M51,0)","v":1082},null,5,-60,0,5,0,-50,1032,{"$f":"'[2]CF '!$E$14","v":2E-3},"Nominal Rate"]
[null,null,null,{"$f":"SUM(D36:D51)","v":60178},{"$f":"SUM(E36:E51)","v":-18544},121,-21428,{"$f":"SUM(H36:H51)","v":0},2639,0,-37212,{"$f":"SUM(L37:L51)","v":22929},{"$f":"SUM(M49:M51)","v":4.4369000000000006E-2},"Conver. Factor b4 FIT"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/(1-M52)","v":1.0464290086864072},"Expense Gross Up Factor"]
[null,"Net Revenue",null,{"$f":"D33-D52","v":601910},{"$f":"E33-E52","v":-89},514,1396.3479999999981,374,{"$f":"I33-I52","v":0},-75408,-73212.652000000002,528734.348]

{"sheet":"2010","index":2,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["WA Electric Revenue Normalization Adjustment--12-mo ended Dec 2010",null,null,null,"Total","Revenue"]
[null,null,"Actuals","Pro-Forma","Adjust","Norm. Adj."]
[null,"Revenue"]
[null,"Base Rate Revenue",{"$f":"C14-SUM(C7:C13)","v":400549},430547,{"$f":"D4-C4","v":29998},{"$f":"E4","v":29998}]
[]
[null,"Weather Normalization",null,5305,{"$f":"D6-C6","v":5305},{"$f":"E6","v":5305}]
[null,"B&O Tax - Sch 58",14789,0,{"$f":"D7-C7","v":-14789},"Adj. T"]
[null,"BPA Residential Exchange Credit - Sch 59",{"$f":"ROUND(C22/(1-G29),0)","v":-6622},0,{"$f":"D8-C8","v":6622},{"$f":"E8","v":6622}]
[null,"Public Purpose Rider - Sch 91",{"$f":"ROUND(C25/(1-G30),0)","v":20489},0,{"$f":"D9-C9","v":-20489},{"$f":"E9","v":-20489}]
[null,"Power Cost Surcharge - ERM Sch 93",7113,0,{"$f":"D10-C10","v":-7113},"Adj. Z"]
[null,"Optional Renewable Power - Sch 95",179,0,{"$f":"D11-C11","v":-179},"Adj. AI"]
[null,"Special Contract Revenue",337,0,-337,{"$f":"E12","v":-337}]
[null,"Unbilled Revenue",-2426,-2845,{"$f":"D13-C13","v":-419},{"$f":"E13","v":-419}]
[null,"Sales to Ultimate Consumers",434408,{"$f":"SUM(D4:D13)","v":433007},{"$f":"IF(ROUND(D14-C14,3)<>ROUND(SUM(E4:E13),3),#VALUE!,SUM(E4:E13))","v":-1401},{"$f":"SUM(F4:F13)","v":20680},"   Rounding matches column B results"]
[null,"Special Contract--transfer to Other Op Rev. ",0,337,{"$f":"D15-C15","v":337},{"$f":"E15","v":337},"Sch 28 Waste-to-Egy"]
[null,"Total Rev.",{"$f":"C14+C15","v":434408},{"$f":"D14+D15","v":433344},{"$f":"IF(ROUND(E14+E15,3)<>ROUND(D16-C16,3),#VALUE!,E14+E15)","v":-1064},{"$f":"F14+F15","v":21017}]
[null,null,null,-433007]
[null,"Expense"]
[null,"B&O Tax",{"$f":"ROUND((14849283-88660)/1000,0)","v":14761},0,{"$f":"D19-C19","v":-14761},"Adj. T"]
[null,"Power Cost Surcharge Amort. - ERM",6276,0,-6276,"Adj. Z","amort only; excluding deferrals"]
[null,"Power Cost Surcharge Amort. - ERM Unbilled",-2740,0,2740,{"$f":"E21","v":2740}]
[null,"BPA Residential Exchange",-6609,0,6609,{"$f":"E22","v":6609}]
[null,"BPA Residential Exchange Unbilled",{"$f":"ROUND(-(6243901)/1000,0)-C22","v":365},0,-365,{"$f":"E23","v":-365}]
[null,"Optional Renewable Power - Revenue Offset",160,0,{"$f":"D24-C24","v":-160},"Adj. AI"]
[null,"Public Purpose Rider",19583,0,-19583,{"$f":"E25","v":-19583}]
[null,"Public Purpose Rider Unbilled",{"$f":"ROUND((19582839-100077)/1000,0)-C25","v":-100},0,100,{"$f":"E26","v":100}]
[null,"State Excise Tax",null,null,null,{"$f":"ROUND(F$16*$G27,0)","v":811},3.8589999999999999E-2,"Effective Rate"]
[null,"Uncollectibles",null,null,null,{"$f":"ROUND(F$16*$G28,0)","v":76},3.6180000000000001E-3,"Effective Rate"]
[null,"Commission Fees",null,null,null,{"$f":"ROUND(F$16*$G29,0)","v":42},2E-3,"Nominal Rate"]
[null,null,null,null,null,{"$f":"SUM(F19:F29)","v":-9570},{"$f":"SUM(G27:G29)","v":4.4208000000000004E-2},"Conver. Factor b4 FIT"]
[]
[null,"Operating Income before FIT",null,null,null,{"$f":"F16-F30","v":30587}]
[null,"FIT Expense",null,null,null,{"$f":"ROUND(F32*$G33,0)","v":10705},0.35,"Diff"]
[null,"Net Operating Income",null,null,null,{"$f":"F32-F33","v":19882}]
[]
[null,"* zero in Pro-forma revenues",null,null,null,null,{"$f":"F16","v":21017},"Revenue"]
[null,null,null,null,null,null,{"$f":"G30","v":4.4208000000000004E-2},"Conver. Factor b4 FIT"]
[null,null,null,null,null,null,{"$f":"ROUND(G36*G37,0)","v":929},"Rev related exp."]
[null,null,null,null,null,null,{"$f":"SUM(F27:F29)","v":929},"check"]
[null,null,null,null,null,null,{"$f":"G38-G39","v":0}]
[]
[null,"for Commission Basis Adjustments file:"]
[null,"REVENUES  "]
[1,"Total General Business  ",null,null,null,{"$f":"ROUND(F14,0)","v":20680}]
[5,"Other Revenue",null,null,null,{"$f":"ROUND(F15,0)","v":337}]
[]
[null,"EXPENSES  "]
[null,"Production and Transmission  "]
[7,"Operating Expenses  ",null,null,null,{"$f":"ROUND(F21,0)","v":2740}]
[9,"Depreciation and Amortization  ",null,null,null,{"$f":"ROUND(F22+F23,0)","v":6244}]
[]
[null,"Distribution  "]
[14,"Taxes  ",null,null,null,{"$f":"ROUND(F27,0)","v":811}]
[]
[16,"Customer Accounting  ",null,null,null,{"$f":"ROUND(F28,0)","v":76}]
[17,"Customer Service & Information  ",null,null,null,{"$f":"ROUND(F25+F26,0)","v":-19483}]
[]
[null,"Administrative & General  "]
[19,"Operating Expenses  ",null,null,null,{"$f":"ROUND(F29,0)","v":42}]
[]
[null,"FEDERAL INCOME TAX  "]
[25,"Current Accrual  ",null,null,null,{"$f":"ROUND((F44+F45-SUM(F49:F59))*G33,0)","v":10705}]
[]
[27,"NET OPERATING INCOME  ",null,null,null,{"$f":"F44+F45-SUM(F47:F62)","v":19882}]
[null,null,null,null,null,{"$f":"ROUND(F64-F34,0)","v":0}]

{"sheet":"2010 Component Analysis","index":3,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":true,"merged":[[6,2,6,5]]}
["Avista Utilities"]
["Docket No. UE-110876 & UG-110877"]
["Response to Staff Data Request No. 224"]
["Electric"]
[]
["Electric Revenue Normalization Adjustment Segregated Components"]
[null,null,"Eliminate Adder Schedules",null,null,null,null,"Transfer"]
["$000's",null,"B & O Tax Revenue Sch 58","Residential Exchange Sch 59","Pub Purp Tariff Rider Sch 91","ERM Surcharge Sch 93","Sch 95","Special Contract","Re-pricing Billed Revenue","Unbilled Revenue (1)","Weather Normalization","Total"]
["REVENUES"]
["Pro forma Gen Bus Revenue",null,null,null,null,null,null,null,430547,-2845,5305,{"$f":"SUM(C10:K10)","v":433007}]
["Actual Gen Bus Revenue",null,14789,-6915,20489,7113,179,337,{"$f":"434408-C11-D11-E11-F11-H11-J11-G11","v":400842},-2426,null,{"$f":"SUM(C11:K11)","v":434408}]
["General Business Revenue Adjustment",null,"Adj T",{"$f":"D10-D11","v":6915},-20489,"Adj Z","Adj Al",-337,{"$f":"I10-I11","v":29705},-419,5305,{"$f":"SUM(C12:K12)","v":20680}]
[]
["Other Revenue Adjustment",null,null,null,null,null,null,337,null,null,null,{"$f":"SUM(C14:K14)","v":337}]
[]
["Total Revenue Adjustment",null,null,{"$f":"D12+D14","v":6915},{"$f":"E12+E14","v":-20489},null,null,{"$f":"H12+H14","v":0},{"$f":"I12+I14","v":29705},{"$f":"J12+J14","v":-419},{"$f":"K12+K14","v":5305},{"$f":"L12+L14","v":21017}]
[]
[]
["EXPENSES"]
["Pro Forma Expense",null,0,0,0,0,null,0,0,0,0,{"$f":"SUM(C20:K20)","v":0}]
[]
["B&O Tax",null,14761,null,null,null,null,null,null,null,null,"Adj T"]
["Optional Renewable Power - Rev Offset",null,null,null,null,null,160,null,null,null,null,"Adj Al"]
["Power Cost Surcharge Amort - ERM",null,null,null,null,6276,null,null,null,null,null,"Adj Z"]
["Power Cost Surcharge Amort - ERM Unbilled",null,null,null,null,null,null,null,null,-2740,null,{"$f":"SUM(C25:K25)","v":-2740}]
["BPA Residential Exchange Amort",null,null,-6609,null,null,null,null,null,null,null,{"$f":"SUM(C26:K26)","v":-6609}]
["BPA Residential Exchange Amort unbilled",null,null,null,null,null,null,null,null,365,null,{"$f":"SUM(C27:K27)","v":365}]
["Public Purpose Rider Offset Expense",null,null,null,19583,null,null,null,null,null,null,{"$f":"SUM(C28:K28)","v":19583}]
["Public Purpose Rider Offset Expense Unbilled",null,null,null,null,null,null,null,null,-100,null,{"$f":"SUM(C29:K29)","v":-100}]
["Actual per Books Expense",null,"Adj T",{"$f":"SUM(D22:D29)","v":-6609},19583,"Adj X","Adj Al",0,0,-2475,0,{"$f":"SUM(L22:L29)","v":10499}]
[]
["Expense Adjustment",null,null,{"$f":"D20-D30","v":6609},{"$f":"E20-E30","v":-19583},null,null,{"$f":"H20-H30","v":0},0,{"$f":"J20-J30","v":2475},0,{"$f":"SUM(C32:K32)","v":-10499}]
[]
["State Excise Tax",3.8589999999999999E-2,{"$f":"C$16*$B34","v":0},{"$f":"D$16*$B34","v":266.84985},{"$f":"E$16*$B34","v":-790.67051000000004},{"$f":"F$16*$B34","v":0},{"$f":"G$16*$B34","v":0},0,{"$f":"I$16*$B34","v":1146.3159499999999},-16.16921,204.71994999999998,{"$f":"SUM(C34:K34)","v":811.04602999999975}]
["Uncollectibles",3.6180000000000001E-3,{"$f":"C$16*$B35","v":0},{"$f":"D$16*$B35","v":25.018470000000001},-74.129202000000006,0,0,0,107.47269,-1.5159420000000001,19.193490000000001,{"$f":"SUM(C35:K35)","v":76.039505999999989}]
["Commission Fees",2E-3,0,13.83,-40.978000000000002,0,0,0,59.410000000000004,-0.83799999999999997,10.61,{"$f":"SUM(C36:K36)","v":42.033999999999999}]
[]
["Total Expense Adjustment",null,{"$f":"SUM(C32:C36)","v":0},{"$f":"SUM(D32:D36)","v":6914.6983199999995},{"$f":"SUM(E32:E36)","v":-20488.777711999999},0,0,0,1313.1986400000001,2456.4768479999998,234.52343999999999,-9569.8804640000017]
[]
["Operating Income before FIT",null,{"$f":"C16-C38","v":0},{"$f":"D16-D38","v":0.30168000000048778},{"$f":"E16-E38","v":-0.22228800000084448},{"$f":"F16-F38","v":0},{"$f":"G$16*$B40","v":0},0,28391.801360000001,-2875.4768479999998,5070.4765600000001,30586.880464000002]
["FIT Expense",0.35,{"$f":"C40*$B$41","v":0},{"$f":"D40*$B$41","v":0.10558800000017071},{"$f":"E40*$B$41","v":-7.7800800000295559E-2},{"$f":"F40*$B$41","v":0},{"$f":"G$16*$B41","v":0},0,9937.1304760000003,-1006.4168967999999,1774.666796,10705.408162399999]
["Net Operating Income",null,"Adj T",{"$f":"D40-D41","v":0.19609200000031707},-0.14448720000054893,"Adj X","Adj Al",0,18454.670883999999,-1869.0599511999999,3295.8097640000001,{"$f":"(L40-L41)+1","v":19882.472301600003}]
[]
["(1)  Adder schedule revenues in unbilled are segregated on workpapers TLK-R-19"]