{"text_format":"1","workbook":"xlsx","n_sheets":39,"sheets":["TOC","1.0","2.0","2.1","2.2","2.3","3.0","3.1","3.2","3.3","4.0","4.1","5.0","5.1","5.2","5.3","5.4","6.0","6.1","RRA 1.0","RRA 2.1","RRA 2.2","RRA 3.0","RRA 3.4","RRA 4.0","RRA 5.0","RRA 5.1","RRA 5.2","RRA 5.4","RRA 6.0","RRA 7.0","RRA 8.0","RRA 9.0","RRA 10.0","RRA 12.1","RRA 12.2","RRA 12.4","RRA 12.5","RRA 15.0"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":305,"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":"TOC","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,1,0,3],[3,1,3,3]]}
[null,"F2016 Cost of Service - Forecast Cost"]
[]
[]
[null,"Table of Contents"]
[null,"Schedule","Description","Page"]
[null,1,"Functionalization Details",2]
[null,2,"Classification of Generation Function",{"$f":"D6+1","v":3}]
[null,2.1,"Classification of Transmission Function",{"$f":"D7+1","v":4}]
[null,2.2000000000000002,"Classification of Distribution Function",5]
[null,2.2999999999999998,"Classification of Customer Care",6]
[null,3,"Allocation of Generation to Rate Classes",7]
[null,3.1,"Allocation of Transmission to Rate Classes",8]
[null,3.2,"Allocation of Distribution to Rate Classes",9]
[null,3.3,{"$f":"'3.3'!B1","v":"Allocation of Customer Care Costs"},10]
[null,4,"Summary of Costs by Function & R/C Ratios",11]
[null,4.0999999999999996,"Summary of Costs by Classification",12]
[null,5,"Energy Allocators",13]
[null,5.0999999999999996,"Demand Allocators",14]
[null,5.2,{"$f":"'5.2'!B1","v":"Distribution Customer Allocators"},15]
[null,5.3,"Customer Care Allocators",16]
[null,5.4,"Transformer Allocators",17]
[null,6,"Distribution Classification by Sub-Functionalization",18]
[null,6.1,"Rate Base",19]
[null,"RRA 1.0",{"$f":"'RRA 1.0'!A1","v":"Revenue Requirements Summary"},20]
[null,"RRA 2.1",{"$f":"'RRA 2.1'!$A$1","v":"Deferral Accounts"},21]
[null,"RRA 2.2",{"$f":"'RRA 2.2'!$A$1","v":"Other Regulatory Accounts"},22]
[null,"RRA 3.0",{"$f":"'RRA 3.0'!$A$1","v":"Reconciliation of Current and Gross Views"},{"$f":"D26+4","v":26}]
[null,"RRA 3.4",{"$f":"'RRA 3.4'!$A$1","v":"Total Current Costs - Transmission"},{"$f":"D27+2","v":28}]
[null,"RRA 4.0",{"$f":"'RRA 4.0'!$A$1","v":"Cost of Energy"},{"$f":"D28+2","v":30}]
[null,"RRA 5.0",{"$f":"'RRA 5.0'!$A$1","v":"Operating Costs and Provisions - Total Company"},{"$f":"D29+2","v":32}]
[null,"RRA 5.1",{"$f":"'RRA 5.1'!$A$1","v":"Operating Costs - Corporate Groups"},{"$f":"D30+3","v":35}]
[null,"RRA 5.2",{"$f":"'RRA 5.2'!$A$1","v":"Operating Costs - Generation"},36]
[null,"RRA 5.4",{"$f":"'RRA 5.4'!$A$1","v":"Operating Costs - Transmission & Distribution"},37]
[null,"RRA 6.0",{"$f":"'RRA 6.0'!$A$1","v":"Taxes"},38]
[null,"RRA 7.0",{"$f":"'RRA 7.0'!$A$1","v":"Depreciation and Amortization"},39]
[null,"RRA 8.0",{"$f":"'RRA 8.0'!$A$1","v":"Finance Charges"},{"$f":"D35+2","v":41}]
[null,"RRA 9.0",{"$f":"'RRA 9.0'!$A$1","v":"Return on Equity"},{"$f":"D36+2","v":43}]
[null,"RRA 10.0",{"$f":"'RRA 10.0'!$A$1","v":"Rate Base"},{"$f":"D37+2","v":45}]
[null,"RRA 12.1",{"$f":"'RRA 12.1'!$A$1","v":"Assets - Corporate Groups"},{"$f":"D38+1","v":46}]
[null,"RRA 12.2",{"$f":"'RRA 12.2'!$A$1","v":"Assets - Generation"},47]
[null,"RRA 12.4",{"$f":"'RRA 12.4'!$A$1","v":"Assets - Transmission"},{"$f":"D40+1","v":48}]
[null,"RRA 12.5",{"$f":"'RRA 12.5'!$A$1","v":"Assets - Distribution"},49]
[null,"RRA 15.0",{"$f":"'RRA 15.0'!$A$1","v":"Miscellaneous Revenue"},{"$f":"D42+1","v":50}]
[]
[null,"Note:","All costs are in $ X 1 million unless otherwise noted."]

{"sheet":"1.0","index":1,"n_rows":136,"n_cols":9,"rows_kept":136,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8]]}
["F2016 Cost of Service - Planned Cost"]
[]
[null,null,null,null,"F2016 Forecast Revenue Requirement","Generation","Transmission","Distribution","Customer Care"]
["Revenue Requirement Schedule (F2016 Plan)"]
[null,null,"Cost of Energy "]
["Sched 4, L 11",null,null,"IPPs and Long-term Purchases commitment",{"$f":"'RRA 4.0'!$G$23+IF('4.0'!E16=\"SQ\",0,'RRA 4.0'!$G$131)","v":975.5},{"$f":"E6","v":975.5},0,0,0]
["Sched 4, L 15",null,null,"Domestic Transmission (Non-Heritage)",{"$f":"+'RRA 4.0'!$G$27","v":0},0,{"$f":"E7","v":0},0,0]
["Sched 4, L 13",null,null,"NIA Generation",{"$f":"+'RRA 4.0'!$G$25","v":34.299999999999997},{"$f":"E8","v":34.299999999999997},0,0,0]
["Sched 4, L 14",null,null,"Gas Transportation",{"$f":"+'RRA 4.0'!$G$26","v":12.1},{"$f":"E9","v":12.1},0,0,0]
["Sched 4, L 1 + L10",null,null,"Water Rentals",{"$f":"+'RRA 4.0'!$G$10+'RRA 4.0'!$G$22","v":391.9},{"$f":"E10","v":391.9},0,0,0]
["Sched 4, L 2 + L3",null,null,"Market Purchases",{"$f":"+'RRA 4.0'!$G$12+'RRA 4.0'!$G$21+'RRA 4.0'!$G$11","v":56.600000000000009},{"$f":"E11","v":56.600000000000009},0,0,0]
["Sched 4, L 4",null,null,"Natural gas for thermal generation",{"$f":"+'RRA 4.0'!$G$13","v":26.9},{"$f":"E12","v":26.9},0,0,0]
["Sched 4, L 5",null,null,"Domestic Transmission (Heritage)",{"$f":"+'RRA 4.0'!$G$14","v":25.7},0,{"$f":"+E13","v":25.7},0,0]
["Sched 4, L 5.1",null,null,"Non-treaty storage agreement",{"$f":"+'RRA 4.0'!$G$15","v":-19.8},{"$f":"+E14","v":-19.8},0,0,0]
["Sched 4, L 6 + L7",null,null,"Other and Surplus Sales",{"$f":"+'RRA 4.0'!$G$16+'RRA 4.0'!$G$17","v":-116.30000000000001},{"$f":"E15","v":-116.30000000000001},0,0,0]
["Sched 4, L 16",null,null,"Net purchases (sales) from Powerex",{"$f":"+'RRA 4.0'!$G$28","v":4.8},{"$f":"+E16","v":4.8},0,0,0]
["Sched 4, L 55",null,null,"Heritage Deferral Account Recoveries",{"$f":"-'RRA 3.0'!$G$18","v":17.741247086104963},{"$f":"E17","v":17.741247086104963},0,0,0]
["Sched 4, L 56",null,null,"Non-Heritage Deferral Account Recoveries",{"$f":"-'RRA 3.0'!$G$19","v":104.82163437312234},{"$f":"E18","v":104.82163437312234},0,0,0]
[null,null,"Total",null,{"$f":"SUM(E6:E18)","v":1514.2628814592274},{"$f":"SUM(F6:F18)","v":1488.5628814592274},{"$f":"SUM(G6:G18)","v":25.7},{"$f":"SUM(H6:H18)","v":0},{"$f":"SUM(I6:I18)","v":0}]
[null,null,null,null,null,1488.5628814592274,25.7,0,0]
[null,null,"O M & A Expenses"]
[null,null,null,"Generation Business Unit",{"$f":"'RRA 5.2'!$G$20-E23-E24","v":176.72606339999999},{"$f":"E22","v":176.72606339999999},0,0,0]
[null,null,null,"Energy Planning & Econ Development",{"$f":"'RRA 5.2'!$G$16","v":9.4286305000000006},{"$f":"IF('4.0'!$E$17=\"SQ\",0,1)*$E$23","v":0},0,0,{"$f":"IF('4.0'!$E$17=\"SQ\",1,0)*$E$23","v":9.4286305000000006}]
[null,null,null,"IT",{"$f":"'RRA 5.2'!$G$19","v":112.29790172999999},{"$f":"$E24*IF('4.0'!$E$15=\"SQ\",1,SUM(F22:F23,F25:F30,F37,F44,F47)/SUM($E$22:$E$23,$E$25:$E$30,$E37,$E44,$E47))","v":112.29790172999999},{"$f":"$E24*IF('4.0'!$E$15=\"SQ\",0,SUM(G22:G23,G25:G30,G37,G44,G47)/SUM($E$22:$E$23,$E$25:$E$30,$E37,$E44,$E47))","v":0},{"$f":"$E24*IF('4.0'!$E$15=\"SQ\",0,SUM(H22:H23,H25:H30,H37,H44,H47)/SUM($E$22:$E$23,$E$25:$E$30,$E37,$E44,$E47))","v":0},{"$f":"$E24*IF('4.0'!$E$15=\"SQ\",0,SUM(I22:I23,I25:I30,I37,I44,I47)/SUM($E$22:$E$23,$E$25:$E$30,$E37,$E44,$E47))","v":0}]
[null,null,null,"Provisions",{"$f":"'RRA 5.0'!$G$100","v":3.6181909999999999},3.6181909999999999,0,0,0]
[null,null,null,"PCB Remediation",{"$f":"'RRA 5.0'!$G$122","v":0.31969614206722247},0.31969614206722247,0,0,0]
[null,null,null,"Asbestos Remediation",{"$f":"'RRA 5.0'!$G$127","v":2.0120085348535421},2.0120085348535421,0,0,0]
[null,null,null,"Arrow Water Divestiture",{"$f":"'RRA 5.0'!$G$132","v":4.5141422872133097},4.5141422872133097,0,0,0]
[null,null,null,"Arrow Water Provision",{"$f":"'RRA 5.0'!$G$133","v":0.3},0.3,0,0,0]
[null,null,null,"Capital Project Investigation",{"$f":"'RRA 5.0'!$G$44","v":4.8310410800000003},4.8310410800000003,0,0,0]
["Sched 3.2, L 2",null,null,"Generation",{"$f":"SUM(E22:E30)","v":314.04767467413404},{"$f":"SUM(F22:F30)","v":304.61904417413405},{"$f":"SUM(G22:G30)","v":0},{"$f":"SUM(H22:H30)","v":0},{"$f":"SUM(I22:I30)","v":9.4286305000000006}]
[null,null,null,"T&D Business Unit",{"$f":"'RRA 5.4'!$G$36","v":179.13310000000001},0,{"$f":"E32","v":179.13310000000001},0,0]
[null,null,null,"Provisions",{"$f":"'RRA 5.0'!$G$101","v":8.3000000000000007},0,{"$f":"E33","v":8.3000000000000007},0,0]
[null,null,null,"PCB Remediation",{"$f":"'RRA 5.0'!$G$123","v":7.1423315544896502},0,{"$f":"E34","v":7.1423315544896502},0,0]
[null,null,null,"Asbestos Remediation",{"$f":"'RRA 5.0'!$G$128","v":0.16235876501394766},0,{"$f":"E35","v":0.16235876501394766},0,0]
[null,null,null,"First Nations",{"$f":"'RRA 5.0'!$G$39","v":43.218634970390966},{"$f":"IF('4.0'!$E$20=\"SQ\",0,-'RRA 3.4'!$G$30)","v":0},{"$f":"IF('4.0'!$E$20=\"SQ\",$E36,$E36-F36)","v":43.218634970390966},0,0]
["Sched 3.4, L 2",null,null,"Transmission",{"$f":"SUM(E32:E36)","v":237.95642528989458},{"$f":"SUM(F32:F36)","v":0},{"$f":"SUM(G32:G36)","v":237.95642528989458},{"$f":"SUM(H32:H36)","v":0},{"$f":"SUM(I32:I36)","v":0}]
[null,null,null,"T&D Business Unit",{"$f":"'RRA 5.4'!$G$37","v":156.24100418999996},0,0,{"$f":"E38","v":156.24100418999996},0]
[null,null,null,"Provisions",{"$f":"'RRA 5.0'!$G$102","v":22.7},0,0,22.7,0]
[null,null,null,"PCB Remediation",{"$f":"'RRA 5.0'!$G$124","v":5.6137471033960642},0,0,5.6137471033960642,0]
[null,null,null,"Asbestos Remediation",{"$f":"'RRA 5.0'!$G$129","v":8.5829796960468308},0,0,8.5829796960468308,0]
[null,null,null,"Storm Restoration",{"$f":"'RRA 5.0'!$G$41","v":-1.3722596637575986},0,0,-1.3722596637575986,0]
[null,null,null,"SMI",{"$f":"'RRA 5.0'!$G$46","v":31.326242819504898},{"$f":"$E43*IF('4.0'!$E$25=\"Option 4\",0.05,0)","v":0},0,{"$f":"$E43*IF('4.0'!$E$25=\"Option 4\",0.95,1)","v":31.326242819504898},0]
["Sched 3.5, L 2",null,null,"Distribution",{"$f":"SUM(E38:E43)","v":223.09171414519014},{"$f":"SUM(F38:F43)","v":0},{"$f":"SUM(G38:G43)","v":0},{"$f":"SUM(H38:H43)","v":223.09171414519014},{"$f":"SUM(I38:I43)","v":0}]
[null,null,null,"Cust Care Costs",{"$f":"'RRA 5.1'!$G$11","v":73.164006009999994},0,0,0,{"$f":"E45","v":73.164006009999994}]
[null,null,null,"IPP Capital Leases",{"$f":"IF('4.0'!E16=\"SQ\",'RRA 5.1'!$G$20,0)","v":33.77013204},0,0,0,{"$f":"E46","v":33.77013204}]
["Sched 5.1",null,null,"Customer Care",{"$f":"SUM(E45:E46)","v":106.93413805},{"$f":"SUM(F45:F46)","v":0},{"$f":"SUM(G45:G46)","v":0},{"$f":"SUM(H45:H46)","v":0},{"$f":"SUM(I45:I46)","v":106.93413805}]
[null,null,null,"Corporate Business Unit",{"$f":"'RRA 5.1'!$G$23-'RRA 5.1'!$G$20-'RRA 5.1'!$G$11","v":86.177456869999972},{"$f":"$E48*SUM(F$31,F37,F44,F47)/SUM($E$31,$E$37,$E$44,$E$47)","v":29.76236178469178},{"$f":"$E48*SUM(G$31,G37,G44,G47)/SUM($E$31,$E$37,$E$44,$E$47)","v":23.249187317459203},{"$f":"$E48*SUM(H$31,H37,H44,H47)/SUM($E$31,$E$37,$E$44,$E$47)","v":21.796852280058417},{"$f":"$E48*SUM(I$31,I37,I44,I47)/SUM($E$31,$E$37,$E$44,$E$47)","v":11.369055487790563}]
[null,null,null,"Real Property Sales",{"$f":"'RRA 5.0'!$G$107","v":-10},{"$f":"$E49*F$48/$E$48","v":-3.4536133770562252},-2.6978270375895361,-2.5292986207447856,-1.3192609646094522]
[null,null,null,"Provisions",{"$f":"'RRA 5.0'!$G$104","v":5.1073580000000005},1.7638839910215129,1.3778768503049219,1.2918033545049847,0.67379380416858037]
[null,null,null,"PCB Remediation",{"$f":"'RRA 5.0'!$G$125","v":0.21552728285249992},{"$f":"$E51*IF('4.0'!$E$20=\"SQ\",F$48/$E$48,F$26/SUM($E$26,$E$34,$E$40))","v":7.4434790717997454E-2},{"$f":"$E51*IF('4.0'!$E$20=\"SQ\",G$48/$E$48,G$34/SUM($E$26,$E$34,$E$40))","v":5.8145533101768183E-2},{"$f":"$E51*IF('4.0'!$E$20=\"SQ\",H$48/$E$48,H$40/SUM($E$26,$E$34,$E$40))","v":5.4513285925169928E-2},{"$f":"$E51*IF('4.0'!$E$20=\"SQ\",I$48/$E$48,I$40/SUM($E$26,$E$34,$E$40))","v":2.8433673107564329E-2}]
[null,null,null,"Rock Bay Remediation",{"$f":"'RRA 5.0'!$G$131","v":50.486034205431302},{"$f":"$E52*F$48/$E$48","v":17.435924308639571},{"$f":"$E52*G$48/$E$48","v":13.620258810008272},{"$f":"$E52*H$48/$E$48","v":12.769425668267147},{"$f":"$E52*I$48/$E$48","v":6.6604254185163096}]
[null,null,null,"Rate Smoothing",{"$f":"'RRA 5.0'!$G$135","v":-121.2},{"$f":"$E53*IF('4.0'!$E$20=\"SQ\",F$48/$E$48,SUM(F19,F31,F37,F44,F47,F81,F89,F112,F119,F124,F132)/SUM($E19,$E31,$E$37,$E$44,$E47,$E81,$E89,$E112,$E119,$E124,$E132))","v":-41.857794129921452},{"$f":"$E53*IF('4.0'!$E$20=\"SQ\",G$48/$E$48,SUM(G19,G31,G37,G44,G47,G81,G89,G112,G119,G124,G132)/SUM($E19,$E31,$E$37,$E$44,$E47,$E81,$E89,$E112,$E119,$E124,$E132))","v":-32.697663695585177},{"$f":"$E53*IF('4.0'!$E$20=\"SQ\",H$48/$E$48,SUM(H19,H31,H37,H44,H47,H81,H89,H112,H119,H124,H132)/SUM($E19,$E31,$E$37,$E$44,$E47,$E81,$E89,$E112,$E119,$E124,$E132))","v":-30.6550992834268},{"$f":"$E53*IF('4.0'!$E$20=\"SQ\",I$48/$E$48,SUM(I19,I31,I37,I44,I47,I81,I89,I112,I119,I124,I132)/SUM($E19,$E31,$E$37,$E$44,$E47,$E81,$E89,$E112,$E119,$E124,$E132))","v":-15.989442891066561}]
[null,null,null,"Home Purchase Option Plan",{"$f":"'RRA 5.0'!$G$47","v":11.328807069918},{"$f":"$E54*F$48/$E$48","v":3.9125319642757947},3.0563162016860268,2.8653936096627373,1.4945652942934404]
[null,null,null,"IFRS PP&E",{"$f":"'RRA 5.0'!$G$49","v":19.8289210786869},6.8481427089945228,5.3494999412310591,5.0153262735179975,2.6159521549433178]
[null,null,null,"IFRS Pension",{"$f":"'RRA 5.0'!$G$50","v":38.238888888888887},13.206233819043334,10.316190833182652,9.6717568925479771,5.0447073441149222]
[null,null,null,"Non-Current PEB - Pension",{"$f":"'RRA 5.0'!$G$48","v":15.520692307692308},{"$f":"$E57*SUM(F$31,F37,F44,F47)/SUM($E$31,$E$37,$E$44,$E$47)","v":5.3602470575019812},{"$f":"$E57*SUM(G$31,G37,G44,G47)/SUM($E$31,$E$37,$E$44,$E$47)","v":4.1872143349800242},{"$f":"$E57*SUM(H$31,H37,H44,H47)/SUM($E$31,$E$37,$E$44,$E$47)","v":3.9256465646850356},{"$f":"$E57*SUM(I$31,I37,I44,I47)/SUM($E$31,$E$37,$E$44,$E$47)","v":2.0475843505252658}]
["Sched 3.1, L 2",null,null,"Corp Service",{"$f":"SUM(E48:E57)","v":95.703685703469887},{"$f":"SUM(F48:F57)","v":33.052352917908813},{"$f":"SUM(G48:G57)","v":25.819199088779214},{"$f":"SUM(H48:H57)","v":24.206320024997883},{"$f":"SUM(I48:I57)","v":12.625813671783948}]
[null,null,"Total",null,{"$f":"SUM(E31,E37,E44,E47,E58)","v":977.73363786268874},{"$f":"SUM(F31,F37,F44,F47,F58)","v":337.67139709204287},{"$f":"SUM(G31,G37,G44,G47,G58)","v":263.7756243786738},{"$f":"SUM(H31,H37,H44,H47,H58)","v":247.29803417018803},{"$f":"SUM(I31,I37,I44,I47,I58)","v":128.98858222178396}]
[null,null,null,null,null,337.67139709204287,263.7756243786738,247.29803417018803,128.98858222178396]
[null,null,"Depreciation & Amortization"]
[null,null,null,"Amort on March 2014 Assets",{"$f":"'RRA 12.2'!$G$17","v":220.82837540000003},{"$f":"E62","v":220.82837540000003},0,0,0]
[null,null,null,"Amortization on Additions",{"$f":"'RRA 12.2'!$G$18","v":36.591624599999996},{"$f":"E63","v":36.591624599999996},0,0,0]
[null,null,null,"DSM Amortization",{"$f":"'RRA 7.0'!$G$62*0.9","v":74.978780598},{"$f":"E64","v":74.978780598},0,0,0]
["Sched 7, L 60",null,null,"Generation",{"$f":"SUM(E62:E64)","v":332.39878059800003},{"$f":"SUM(F62:F64)","v":332.39878059800003},{"$f":"SUM(G62:G64)","v":0},{"$f":"SUM(H62:H64)","v":0},{"$f":"SUM(I62:I64)","v":0}]
[null,null,null,"Amort on March 2014 Assets",{"$f":"'RRA 12.4'!$G$17","v":132.4980716},0,{"$f":"E66","v":132.4980716},0,0]
[null,null,null,"Amortization on Additions",{"$f":"'RRA 12.4'!$G$18","v":46.305928399999999},0,{"$f":"E67","v":46.305928399999999},0,0]
[null,null,null,"DSM Amortization",{"$f":"'RRA 7.0'!$G$62*IF('4.0'!E19=\"SQ\",0.1,0.05)","v":8.3309756220000004},0,{"$f":"E68","v":8.3309756220000004},0,0]
["Sched 7, L 61",null,null,"Transmission",{"$f":"SUM(E66:E68)","v":187.13497562200001},{"$f":"SUM(F66:F68)","v":0},{"$f":"SUM(G66:G68)","v":187.13497562200001},{"$f":"SUM(H66:H68)","v":0},{"$f":"SUM(I66:I68)","v":0}]
[null,null,null,"Amort on March 2014 Assets",{"$f":"'RRA 12.5'!$G$17","v":209.32176250000001},0,0,{"$f":"E70","v":209.32176250000001},0]
[null,null,null,"Amortization on Additions",{"$f":"'RRA 12.5'!$G$18","v":16.008237500000003},0,0,{"$f":"E71","v":16.008237500000003},0]
[null,null,null,"Pre-1996 CIAC Amortization",{"$f":"'RRA 7.0'!$G$81","v":-4.6900000000000004},0,0,{"$f":"E72","v":-4.6900000000000004},0]
[null,null,null,"DSM Amortization",{"$f":"'RRA 7.0'!$G$62*IF('4.0'!E19=\"SQ\",0,0.05)","v":0},0,0,{"$f":"E73","v":0},0]
["Sched 7, L 62",null,null,"Distribution",{"$f":"SUM(E70:E73)","v":220.64000000000001},{"$f":"SUM(F70:F73)","v":0},{"$f":"SUM(G70:G73)","v":0},{"$f":"SUM(H70:H73)","v":220.64000000000001},{"$f":"SUM(I70:I73)","v":0}]
[null,null,null,"IPP Capital Leases",{"$f":"IF('4.0'!E16=\"SQ\",'RRA 7.0'!$G$99,0)","v":25.8},0,0,0,{"$f":"E75","v":25.8}]
["Sched 7, L 63",null,null,"Customer Care",{"$f":"SUM(E75)","v":25.8},{"$f":"SUM(F75)","v":0},{"$f":"SUM(G75)","v":0},0,25.8]
[null,null,null,"Amort on March 2014 Assets",{"$f":"'RRA 12.1'!$G$17","v":31.685999999999996},{"$f":"$E77*SUM(F$65)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":18.195718937744964},{"$f":"$E77*IF('4.0'!$E$18=\"SQ\",0,SUM(G$69)/(SUM($E$65,$E$69,$E$74,$E$76)))","v":0},{"$f":"$E77*SUM(H$74)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":12.077972786787667},{"$f":"$E77*SUM(I$76)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":1.4123082754673759}]
[null,null,null,"Amortization on Additions",{"$f":"'RRA 12.1'!$G$18","v":7.7909999999999995},{"$f":"$E78*SUM(F$65)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":4.4739899717216129},{"$f":"$E78*IF('4.0'!$E$18=\"SQ\",0,SUM(G$69)/(SUM($E$65,$E$69,$E$74,$E$76)))","v":0},{"$f":"$E78*SUM(H$74)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":2.9697496049316014},{"$f":"$E78*SUM(I$76)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":0.34726042334678808}]
[null,null,null,"Capital Additions",{"$f":"'RRA 7.0'!$G$88","v":-9.4190630110050702},{"$f":"$E79*SUM(F$65)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":-5.4089068738609498},{"$f":"$E79*IF('4.0'!$E$18=\"SQ\",0,SUM(G$69)/(SUM($E$65,$E$69,$E$74,$E$76)))","v":0},{"$f":"$E79*SUM(H$74)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":-3.5903296952583967},{"$f":"$E79*SUM(I$76)/(SUM($E$65,$E$69,$E$74,$E$76)-IF('4.0'!$E$18=\"SQ\",$E$69,0))","v":-0.41982644188572621}]
["Sched 7, L 64",null,null,"Corporate Services",{"$f":"SUM(E77:E79)","v":30.057936988994925},{"$f":"SUM(F77:F79)","v":17.260802035605629},{"$f":"SUM(G77:G79)","v":0},{"$f":"SUM(H77:H79)","v":11.457392696460872},{"$f":"SUM(I77:I79)","v":1.3397422569284378}]
[null,null,"Total",null,{"$f":"SUM(E65,E69,E74,E76,E80)","v":796.03169320899485},{"$f":"SUM(F65,F69,F74,F76,F80)","v":349.65958263360568},{"$f":"SUM(G65,G69,G74,G76,G80)","v":187.13497562200001},{"$f":"SUM(H65,H69,H74,H76,H80)","v":232.09739269646087},{"$f":"SUM(I65,I69,I74,I76,I80)","v":27.139742256928439}]
[null,null,null,null,null,349.65958263360568,187.13497562200001,232.09739269646087,27.139742256928439]
[null,null,"Taxes"]
["Sched 6, L 29",null,null,"Generation",{"$f":"+'RRA 6.0'!$G53","v":43.069000000000003},{"$f":"E84","v":43.069000000000003},0,0,0]
["Sched 6, L 30",null,null,"Transmission",{"$f":"+'RRA 6.0'!$G54","v":131.96299999999999},0,{"$f":"E85","v":131.96299999999999},0,0]
["Sched 6, L 31",null,null,"Distribution",{"$f":"+'RRA 6.0'!$G55","v":27.585999999999999},0,0,{"$f":"E86","v":27.585999999999999},0]
["Sched 6, L 32",null,null,"Customer Care",{"$f":"IF('4.0'!E16=\"SQ\",'RRA 6.0'!$G56,0)","v":5.7545555537904658},0,0,0,{"$f":"E87","v":5.7545555537904658}]
["Sched 6, L 33",null,null,"Corporate",{"$f":"+'RRA 6.0'!$G57","v":15.757999999999999},{"$f":"$E88*SUM(F84:F87)/(SUM($E84:$E87)-IF('4.0'!$E$18=\"SQ\",$E85,0))","v":8.8821522004826345},{"$f":"$E88*IF('4.0'!$E$18=\"SQ\",0,SUM(G84:G87)/(SUM($E84:$E87)))","v":0},{"$f":"$E88*SUM(H84:H87)/(SUM($E84:$E87)-IF('4.0'!$E$18=\"SQ\",$E85,0))","v":5.6890814879034561},{"$f":"$E88*SUM(I84:I87)/(SUM($E84:$E87)-IF('4.0'!$E$18=\"SQ\",$E85,0))","v":1.1867663116139113}]
[null,null,"Total",null,{"$f":"SUM(E84:E88)","v":224.13055555379046},{"$f":"SUM(F84:F88)","v":51.951152200482639},{"$f":"SUM(G84:G88)","v":131.96299999999999},{"$f":"SUM(H84:H88)","v":33.275081487903456},{"$f":"SUM(I84:I88)","v":6.9413218654043769}]
[null,null,null,null,null,51.951152200482639,131.96299999999999,33.275081487903456,6.9413218654043769]
[null,null,"Finance Charges"]
["Sched 8, L 78",null,null,"Generation",{"$f":"('RRA 8.0'!$G$86-IF('4.0'!E16=\"SQ\",0,'RRA 8.0'!$G$80))*'RRA 8.0'!$G$114","v":344.37317902792086},{"$f":"E92","v":344.37317902792086},0,0,0]
["Sched 8, L 79",null,null,"Transmission",{"$f":"('RRA 8.0'!$G$86-IF('4.0'!E16=\"SQ\",0,'RRA 8.0'!$G$80))*'RRA 8.0'!$G$115","v":261.24027603363299},0,{"$f":"E93","v":261.24027603363299},0,0]
["Sched 8, L 80",null,null,"Distribution",{"$f":"('RRA 8.0'!$G$86-IF('4.0'!E16=\"SQ\",0,'RRA 8.0'!$G$80))*'RRA 8.0'!$G$116","v":209.01621971232166},0,0,{"$f":"E94","v":209.01621971232166},0]
["Sched 8, L 81",null,null,"Customer Care",{"$f":"+'RRA 8.0'!$G125","v":-1.2953734435369817E-3},0,0,0,{"$f":"+E95","v":-1.2953734435369817E-3}]
["Sched 2.1,  L 4",null,null,"Heritage Deferral Account",{"$f":"-'RRA 2.1'!$G$11","v":-1.8931075390026884},{"$f":"E96","v":-1.8931075390026884},0,0,0]
["Sched 2.1,  L 11",null,null,"Non-Heritage Deferral Account",{"$f":"-'RRA 2.1'!$G$20","v":-11.185156563078328},{"$f":"E97","v":-11.185156563078328},0,0,0]
["Sched 2.1,  L 19",null,null,"Trade Income Deferral Account",{"$f":"-'RRA 2.1'!$G$30","v":-10.716419271093825},{"$f":"E98","v":-10.716419271093825},0,0,0]
["Sched 2.2,  L 12",null,null,"First Nations",{"$f":"-'RRA 2.2'!$G$21","v":-7.1922866742465859},{"$f":"$E99*F36/$E36","v":0},{"$f":"$E99*G36/$E36","v":-7.1922866742465859},{"$f":"$E99*H36/$E36","v":0},{"$f":"$E99*I36/$E36","v":0}]
["Sched 2.2,  L 26",null,null,"Site C",{"$f":"-'RRA 2.2'!$G$41","v":-16.848680912344005},{"$f":"E100","v":-16.848680912344005},0,0,0]
["Sched 2.2,  L 45",null,null,"Storm Restoration Costs",{"$f":"-'RRA 2.2'!$G$68","v":2.7415647056131878E-2},{"$f":"$E101*F42/$E42","v":0},{"$f":"$E101*G42/$E42","v":0},{"$f":"$E101*H42/$E42","v":2.7415647056131882E-2},{"$f":"$E101*I42/$E42","v":0}]
["Sched 2.2,  L 86",null,null,"Capital Additions",{"$f":"-'RRA 2.2'!$G$123","v":0.20640115773937545},{"$f":"$E102*F79/$E79","v":0.11852608264378083},{"$f":"$E102*G79/$E79","v":0},{"$f":"$E102*H79/$E79","v":7.8675363451923427E-2},{"$f":"$E102*I79/$E79","v":9.1997116436712476E-3}]
["Sched 2.2,  L 103",null,null,"SMI",{"$f":"-'RRA 2.2'!$G$144","v":-12.524507045312106},{"$f":"$E103*F43/$E43","v":0},{"$f":"$E103*G43/$E43","v":0},{"$f":"$E103*H43/$E43","v":-12.524507045312106},{"$f":"$E103*I43/$E43","v":0}]
["Sched 2.2,  L 109",null,null,"Home Purchase Option Plan",{"$f":"-'RRA 2.2'!$G$152","v":-0.24445175248588374},{"$f":"$E104*F54/$E54","v":-8.4424184243008557E-2},{"$f":"$E104*G54/$E54","v":-6.5948854724256226E-2},{"$f":"$E104*H54/$E54","v":-6.1829148040119145E-2},{"$f":"$E104*I54/$E54","v":-3.224956547849981E-2}]
["Sched 2.2,  L 136",null,null,"Rock Bay Remediation",{"$f":"-'RRA 2.2'!$G$187","v":-1.0803561995785957},{"$f":"$E105*F52/$E52","v":-0.37311326228502634},{"$f":"$E105*G52/$E52","v":-0.29146141654506125},{"$f":"$E105*H52/$E52","v":-0.27325434455072206},{"$f":"$E105*I52/$E52","v":-0.14252717619778602}]
["Sched 2.2,  L 157",null,null,"Arrow Water Divestiture Costs",{"$f":"-'RRA 2.2'!$G$216","v":-9.7681160211553902E-2},{"$f":"$E106*F28/$E28","v":-9.7681160211553902E-2},{"$f":"$E106*G28/$E28","v":0},{"$f":"$E106*H28/$E28","v":0},{"$f":"$E106*I28/$E28","v":0}]
["Sched 2.2,  L 168",null,null,"Asbestos Remediation",{"$f":"-'RRA 2.2'!$G$231","v":-0.18826970474916299},{"$f":"$E107*E27/SUM($E$27,$E$35,$E$41)","v":-3.5213166680738484E-2},{"$f":"$E107*E35/SUM($E$27,$E$35,$E$41)","v":-2.8415218700506926E-3},{"$f":"$E107*E41/SUM($E$27,$E$35,$E$41)","v":-0.15021501619837382},0]
["Sched 3.0, L 30",null,null,"Interest on Regulatory Accounts",{"$f":"SUM(E96:E107)","v":-61.73710001730722},{"$f":"IF('4.0'!$E$20=\"SQ\",$E108*$E92/SUM($E$92:$E$95),SUM(F96:F107))","v":-26.098527788305923},{"$f":"IF('4.0'!$E$20=\"SQ\",$E108*$E93/SUM($E$92:$E$95),SUM(G96:G107))","v":-19.798250905410079},{"$f":"IF('4.0'!$E$20=\"SQ\",$E108*$E94/SUM($E$92:$E$95),SUM(H96:H107))","v":-15.840419494244077},{"$f":"IF('4.0'!$E$20=\"SQ\",$E108*$E95/SUM($E$92:$E$95),SUM(I96:I107))","v":9.8170652859241525E-5}]
["Sched 8.0,  L 67",null,null,"Foreign Exchange Gains/Losses",{"$f":"'RRA 8.0'!$G$94","v":-0.7},{"$f":"IF('4.0'!$E$20=\"SQ\",$E109*F92/SUM($E92:$E95),$E109*F108/$E108)","v":-0.29591557502203164},{"$f":"IF('4.0'!$E$20=\"SQ\",$E109*G93/SUM($E92:$E95),$E109*G108/$E108)","v":-0.22448050896303712},{"$f":"IF('4.0'!$E$20=\"SQ\",$E109*H94/SUM($E92:$E95),$E109*H108/$E108)","v":-0.1796050291131652},{"$f":"IF('4.0'!$E$20=\"SQ\",$E109*I95/SUM($E92:$E95),$E109*I108/$E108)","v":1.1130982339987533E-6}]
["Sched 8.0,  L 69",null,null,"Total Finance Charges",{"$f":"'RRA 8.0'!$G$96","v":-25.542661942377102},{"$f":"IF('4.0'!$E$20=\"SQ\",$E110*F92/SUM($E92:$E95),$E110*F108/$E108)","v":-10.797816423245548},{"$f":"IF('4.0'!$E$20=\"SQ\",$E110*G93/SUM($E92:$E95),$E110*G108/$E108)","v":-8.1911853615651573},{"$f":"IF('4.0'!$E$20=\"SQ\",$E110*H94/SUM($E92:$E95),$E110*H108/$E108)","v":-6.5537007739833939},{"$f":"IF('4.0'!$E$20=\"SQ\",$E110*I95/SUM($E92:$E95),$E110*I108/$E108)","v":4.0616416999553024E-5}]
["Sched 3.0, L 32",null,null,"Regulatory Account Recoveries",{"$f":"SUM(E109:E110)","v":-26.242661942377101},{"$f":"SUM(F109:F110)","v":-11.093731998267579},-8.4156658705281941,-6.7333058030965587,4.172951523355178E-5]
[null,null,"Total",null,{"$f":"SUM(E92:E95,E108,E111)","v":726.64861744074767},{"$f":"SUM(F92:F95,F108,F111)","v":307.18091924134734},{"$f":"SUM(G92:G95,G108,G111)","v":233.02635925769474},{"$f":"SUM(H92:H95,H108,H111)","v":186.44249441498101},{"$f":"SUM(I92:I95,I108,I111)","v":-1.1554732754441885E-3}]
[null,null,null,null,null,307.18091924134734,233.02635925769485,186.44249441498101,-1.1554732754441876E-3]
[null,null,"Allowed Net Income"]
["Sched 9, L 60",null,null,"Generation",{"$f":"+'RRA 9.0'!$G93","v":275.56131675592184},{"$f":"E115","v":275.56131675592184},0,0,0]
["Sched 9, L 61",null,null,"Transmission",{"$f":"IF('4.0'!E19=\"SQ\",'6.1'!$E$7,'6.1'!$G$7)*'RRA 9.0'!$G$82","v":209.03946795835179},0,{"$f":"E116","v":209.03946795835179},0,0]
["Sched 9, L 62",null,null,"Distribution",{"$f":"IF('4.0'!E19=\"SQ\",'6.1'!$E$9,'6.1'!$G$9)*'RRA 9.0'!$G$82","v":167.25077781537999},0,0,{"$f":"E117","v":167.25077781537999},0]
["Sched 9, L 63",null,null,"Customer Care",{"$f":"+'RRA 9.0'!$G96","v":-1.1620378434585457E-3},0,0,0,{"$f":"E118","v":-1.1620378434585457E-3}]
[null,null,"Total",null,{"$f":"SUM(E115:E118)","v":651.85040049181021},{"$f":"SUM(F115:F118)","v":275.56131675592184},209.03946795835179,167.25077781537999,-1.1620378434585457E-3]
[null,null,null,null,null,275.56131675592184,209.03946795835188,167.25077781537999,-1.1620378434585451E-3]
[null,null,"Miscellaneous Revenues"]
["Sched 15, L 4, 10, 11.3, 19",null,null,"Non Tariff Revenue (Functionalized)",{"$f":"+SUM(F122:I122)","v":-112.0786356728475},{"$f":"-'RRA 15.0'!$G$12","v":-3.0697999999999999},{"$f":"-'RRA 15.0'!$G$21","v":-39.191343315875997},{"$f":"-'RRA 15.0'!$G$27","v":-51.089361324000002},{"$f":"-'RRA 15.0'!$G$37+'RRA 15.0'!$G$32","v":-18.728131032971501}]
["Sched 15, L 26",null,null,"Corporate Miscellaneous Revenue",{"$f":"-'RRA 15.0'!$G$46","v":-11.182772399999999},{"$f":"$E123*F122/($E122)","v":-0.30629276050187154},{"$f":"$E123*G122/($E122)","v":-3.9103605225083826},-5.0974987009595134,-1.8686204160302327]
[null,null,"Total",null,{"$f":"SUM(E122:E123)","v":-123.2614080728475},{"$f":"SUM(F122:F123)","v":-3.3760927605018716},-43.101703838384381,-56.186860024959515,-20.596751449001733]
[null,null,null,null,null,-3.3760927605018716,-43.101703838384381,-56.186860024959515,-20.596751449001733]
[null,null,"Deferral Accounts, Revenue Offsets & Other"]
["Sched 1, L17",null,null,"Subsidiary Net Income",{"$f":"'RRA 3.0'!$G$76+'RRA 3.0'!$G$81","v":-14.691134629292488},{"$f":"+E127","v":-14.691134629292488},0,0,0]
["Sched 1.0, L24",null,null,"Other Utility Revenue",{"$f":"'RRA 1.0'!$G$40","v":-16.499916335699446},{"$f":"+E128","v":-16.499916335699446},0,0,0]
["Sched 1.0, L21",null,null,"Deferral Rider Revenue",{"$f":"'RRA 1.0'!$G$48","v":-222.99174682993481},{"$f":"E129","v":-222.99174682993481},0,0,0]
["Sched 1.0, L8",null,null,"Intersegment revenues",{"$f":"'RRA 1.0'!$G$21","v":-53.510359036389922},{"$f":"+E130-G130","v":-3},{"$f":"'RRA 3.0'!$G$66+'RRA 3.0'!$G$67","v":-50.510359036389922},0,0]
["Sched 3.4, L11 (L9, L10)",null,null,"Internal Allocations (GRTA, SDA)",0,{"$f":"-'RRA 3.4'!$G$24","v":43.3},{"$f":"-(F131+H131)","v":-191.57406614988662},{"$f":"-'RRA 3.4'!$G$25","v":148.27406614988664},0]
[null,null,"Total",null,{"$f":"SUM(E127,E128,E129,E130,E131)","v":-307.69315683131668},{"$f":"SUM(F127,F128,F129,F130,F131)","v":-213.88279779492672},{"$f":"SUM(G127,G128,G129,G130,G131)","v":-242.08442518627655},{"$f":"SUM(H127,H128,H129,H130,H131)","v":148.27406614988664},{"$f":"SUM(I127,I128,I129,I130,I131)","v":0}]
[null,null,null,null,null,-213.88279779492672,-242.08442518627655,148.27406614988664,0]
[null,null,"Total Revenue Requirement",null,{"$f":"ROUND(+E19+E59+E81+E89+E112+E119+E124+E132,2)","v":4459.7},{"$f":"+F19+F59+F81+F89+F112+F119+F124+F132","v":2593.3283588271993},{"$f":"+G19+G59+G81+G89+G112+G119+G124+G132","v":765.45329819205938},{"$f":"+H19+H59+H81+H89+H112+H119+H124+H132","v":958.45098670984032},{"$f":"+I19+I59+I81+I89+I112+I119+I124+I132","v":142.4705773839961}]
[]
[null,null,null,null,{"$f":"4459.7-E134","v":0}]

{"sheet":"2.0","index":2,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,2,8],[1,0,1,8]]}
["Classification of Generation Function"]
["(Functionalized Costs from Schedule 1.0)"]
[]
[null,null,null,"Functionalized Costs","Demand Related","Energy Related","Demand Costs","Energy Costs","Comments"]
[]
[null,{"$f":"'1.0'!$C$5","v":"Cost of Energy "}]
[null,null,{"$f":"'1.0'!D6","v":"IPPs and Long-term Purchases commitment"},{"$f":"'1.0'!F6","v":975.5},{"$f":"IF('4.0'!E22=\"SQ\",0,0.074)","v":0},{"$f":"100%-E7","v":1},{"$f":"D7*E7","v":0},{"$f":"+D7*F7","v":975.5}]
[null,null,{"$f":"'1.0'!D7","v":"Domestic Transmission (Non-Heritage)"},{"$f":"'1.0'!F7","v":0},0,1,0,{"$f":"+D8*F8","v":0}]
[null,null,{"$f":"'1.0'!D8","v":"NIA Generation"},{"$f":"'1.0'!F8","v":34.299999999999997},0,1,0,{"$f":"+D9*F9","v":34.299999999999997}]
[null,null,{"$f":"'1.0'!D9","v":"Gas Transportation"},{"$f":"'1.0'!F9","v":12.1},0,1,0,12.1]
[null,null,{"$f":"'1.0'!D10","v":"Water Rentals"},{"$f":"'1.0'!F10","v":391.9},0.1,0.9,39.19,352.71,"Based on Water Rental Rate"]
[null,null,{"$f":"'1.0'!D11","v":"Market Purchases"},{"$f":"'1.0'!F11","v":56.600000000000009},0,1,0,56.600000000000009]
[null,null,{"$f":"'1.0'!D12","v":"Natural gas for thermal generation"},{"$f":"'1.0'!F12","v":26.9},0,1,{"$f":"D13*E13","v":0},{"$f":"+D13*F13","v":26.9}]
[null,null,{"$f":"'1.0'!D13","v":"Domestic Transmission (Heritage)"},{"$f":"'1.0'!F13","v":0},1,0,0,0]
[null,null,"Non-treaty storage agreement",{"$f":"'1.0'!F14","v":-19.8},0,1,0,-19.8]
[null,null,{"$f":"'1.0'!D15","v":"Other and Surplus Sales"},{"$f":"'1.0'!F15","v":-116.30000000000001},0,1,{"$f":"D16*E16","v":0},{"$f":"+D16*F16","v":-116.30000000000001}]
[null,null,"Net purchases (sales) from Powerex",{"$f":"+'1.0'!E16","v":4.8},0,1,{"$f":"D17*E17","v":0},{"$f":"+D17*F17","v":4.8}]
[null,null,"Heritage Deferral Account Recoveries",{"$f":"+'1.0'!E17","v":17.741247086104963},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E18","v":0.42100000000000004},{"$f":"D18*E18","v":10.272182062854773},{"$f":"+D18*F18","v":7.4690650232501898}]
[null,null,"Non-Heritage Deferral Account Recoveries",{"$f":"+'1.0'!E18","v":104.82163437312234},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E19","v":0.42100000000000004},{"$f":"D19*E19","v":60.691726302037829},{"$f":"+D19*F19","v":44.129908071084508}]
[null,"Total",null,{"$f":"SUM(D7:D19)","v":1488.5628814592274},null,null,{"$f":"SUM(G7:G19)","v":110.1539083648926},{"$f":"SUM(H7:H19)","v":1378.4089730943344}]
[]
[null,{"$f":"'1.0'!$C$21","v":"O M & A Expenses"}]
[null,null,{"$f":"'1.0'!D31","v":"Generation"},{"$f":"'1.0'!F31-D24","v":284.18463337413402},{"$f":"IF('4.0'!E23=\"SQ\",0.579,ROUND(IF('4.0'!E23=\"Option 1B\",0.45,IF('4.0'!E23=\"Option 3\",0.55,0.5)),2))","v":0.57899999999999996},{"$f":"1-E23","v":0.42100000000000004},{"$f":"D23*E23","v":164.5429027236236},119.64173065051044]
[null,null,"Thermal Generation",{"$f":"20434410.8/1000000","v":20.434410800000002},{"$f":"IF('4.0'!E24=\"SQ\",E23,1)","v":0.57899999999999996},0.42100000000000004,11.8315238532,{"$f":"+D24*F24","v":8.6028869468000018}]
[null,null,{"$f":"'1.0'!D37","v":"Transmission"},{"$f":"'1.0'!F37","v":0},{"$f":"$E$24","v":0.57899999999999996},0.42100000000000004,0,0]
[null,null,{"$f":"'1.0'!D44","v":"Distribution"},{"$f":"'1.0'!F44","v":0},{"$f":"$E$24","v":0.57899999999999996},0.42100000000000004,0,0]
[null,null,"Customer Care",{"$f":"'1.0'!F47","v":0},{"$f":"$E$24","v":0.57899999999999996},0.42100000000000004,0,{"$f":"+D27*F27","v":0}]
[null,null,{"$f":"'1.0'!D58","v":"Corp Service"},{"$f":"'1.0'!F58","v":33.052352917908813},{"$f":"E23","v":0.57899999999999996},0.42100000000000004,19.137312339469201,13.915040578439612]
[null,"Total",null,{"$f":"SUM(D23:D28)","v":337.67139709204287},null,null,{"$f":"SUM(G23:G28)","v":195.51173891629279},{"$f":"SUM(H23:H28)","v":142.15965817575005}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"'1.0'!$C$61","v":"Depreciation & Amortization"},null,null,null,null,null,0]
[null,null,{"$f":"'1.0'!D65","v":"Generation"},{"$f":"'1.0'!F65","v":332.39878059800003},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E32","v":0.42100000000000004},{"$f":"D32*E32","v":192.45889396624202},139.93988663175801]
[null,null,{"$f":"'1.0'!D69","v":"Transmission"},{"$f":"'1.0'!F69","v":0},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E33","v":0.42100000000000004},0,0]
[null,null,{"$f":"'1.0'!D74","v":"Distribution"},{"$f":"'1.0'!F74","v":0},0.57899999999999996,0.42100000000000004,0,0]
[null,null,"Customer Care",{"$f":"'1.0'!F76","v":0},0.57899999999999996,0.42100000000000004,0,{"$f":"+D35*F35","v":0}]
[null,null,{"$f":"'1.0'!D80","v":"Corporate Services"},{"$f":"'1.0'!F80","v":17.260802035605629},0.57899999999999996,{"$f":"1-E36","v":0.42100000000000004},9.9940043786156583,7.2667976569899704]
[null,"Total",null,{"$f":"SUM(D32:D36)","v":349.65958263360568},null,null,{"$f":"SUM(G32:G36)","v":202.45289834485769},{"$f":"SUM(H32:H36)","v":147.20668428874799}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"'1.0'!$C$83","v":"Taxes"},null,null,null,null,null,0]
[null,null,{"$f":"'1.0'!D84","v":"Generation"},{"$f":"'1.0'!F84","v":43.069000000000003},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E40","v":0.42100000000000004},{"$f":"D40*E40","v":24.936951000000001},18.132049000000002]
[null,null,{"$f":"'1.0'!D85","v":"Transmission"},{"$f":"'1.0'!F85","v":0},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E41","v":0.42100000000000004},0,0]
[null,null,{"$f":"'1.0'!D86","v":"Distribution"},{"$f":"'1.0'!F86","v":0},0.57899999999999996,0.42100000000000004,0,0]
[null,null,{"$f":"'1.0'!D87","v":"Customer Care"},{"$f":"'1.0'!F87","v":0},0.57899999999999996,0.42100000000000004,0,0]
[null,null,{"$f":"'1.0'!D88","v":"Corporate"},{"$f":"'1.0'!F88","v":8.8821522004826345},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E44","v":0.42100000000000004},5.1427661240794453,3.7393860764031897]
[null,"Total",null,{"$f":"SUM(D40:D44)","v":51.951152200482639},null,null,{"$f":"SUM(G40:G44)","v":30.079717124079444},{"$f":"SUM(H40:H44)","v":21.871435076403191}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"'1.0'!$C$91","v":"Finance Charges"},null,null,null,null,null,0]
[null,null,{"$f":"'1.0'!D92","v":"Generation"},{"$f":"'1.0'!F92","v":344.37317902792086},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E48","v":0.42100000000000004},{"$f":"D48*E48","v":199.39207065716616},144.9811083707547]
[null,null,{"$f":"'1.0'!D93","v":"Transmission"},{"$f":"'1.0'!F93","v":0},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E49","v":0.42100000000000004},0,0]
[null,null,{"$f":"'1.0'!D94","v":"Distribution"},{"$f":"'1.0'!F94","v":0},0.57899999999999996,0.42100000000000004,0,0]
[null,null,{"$f":"'1.0'!D95","v":"Customer Care"},{"$f":"'1.0'!F95","v":0},0.57899999999999996,0.42100000000000004,0,0]
[null,null,"Interest on Deferral Accounts",{"$f":"SUM('1.0'!F96:F98)","v":-23.794683373174841},{"$f":"IF('4.0'!$E$20=\"SQ\",$E$23,G20/SUM(G20,H20))","v":0.57899999999999996},{"$f":"1-E52","v":0.42100000000000004},{"$f":"D52*E52","v":-13.777121673068232},{"$f":"+D52*F52","v":-10.01756170010661}]
[null,null,"Interest on Regulatory Accounts",{"$f":"'1.0'!F108-D52","v":-2.3038444151310813},{"$f":"$E$48","v":0.57899999999999996},{"$f":"1-E53","v":0.42100000000000004},-1.3339259163608961,{"$f":"+D53*F53","v":-0.96991849877018532}]
[null,null,"Regulatory Account Recoveries",{"$f":"'1.0'!F111","v":-11.093731998267579},{"$f":"$E$48","v":0.57899999999999996},{"$f":"1-E54","v":0.42100000000000004},-6.4232708269969274,-4.6704611712706514]
[null,"Total",null,{"$f":"SUM(D48:D54)","v":307.18091924134734},null,null,{"$f":"SUM(G48:G54)","v":177.8577522407401},{"$f":"SUM(H48:H54)","v":129.32316700060724}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"'1.0'!$C$114","v":"Allowed Net Income"},null,null,null,null,null,0]
[null,null,{"$f":"'1.0'!D115","v":"Generation"},{"$f":"'1.0'!F115","v":275.56131675592184},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E58","v":0.42100000000000004},{"$f":"D58*E58","v":159.55000240167874},116.0113143542431]
[null,null,{"$f":"'1.0'!D116","v":"Transmission"},{"$f":"'1.0'!F116","v":0},0.57899999999999996,0,{"$f":"D59*E59","v":0},0]
[null,null,{"$f":"'1.0'!D117","v":"Distribution"},{"$f":"'1.0'!F117","v":0},0.57899999999999996,0,{"$f":"D60*E60","v":0},0]
[null,null,{"$f":"'1.0'!D118","v":"Customer Care"},{"$f":"'1.0'!F118","v":0},0.57899999999999996,0,{"$f":"D61*E61","v":0},0]
[null,"Total",null,{"$f":"SUM(D58:D61)","v":275.56131675592184},null,null,{"$f":"SUM(G58:G61)","v":159.55000240167874},{"$f":"SUM(H58:H61)","v":116.0113143542431}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"'1.0'!$C$121","v":"Miscellaneous Revenues"},null,null,null,null,null,0]
[null,null,{"$f":"'1.0'!D122","v":"Non Tariff Revenue (Functionalized)"},{"$f":"'1.0'!F122","v":-3.0697999999999999},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E65","v":0.42100000000000004},{"$f":"D65*E65","v":-1.7774141999999997},-1.2923858000000001]
[null,null,{"$f":"'1.0'!D123","v":"Corporate Miscellaneous Revenue"},{"$f":"'1.0'!F123","v":-0.30629276050187154},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E66","v":0.42100000000000004},{"$f":"D66*E66","v":-0.1773435083305836},-0.12894925217128794]
[null,"Total",null,{"$f":"SUM(D65:D66)","v":-3.3760927605018716},null,null,{"$f":"SUM(G65:G66)","v":-1.9547577083305834},{"$f":"SUM(H65:H66)","v":-1.4213350521712882}]
[null,null,null,null,null,null,null,0]
[null,{"$f":"'1.0'!$C$126","v":"Deferral Accounts, Revenue Offsets & Other"},null,null,null,null,null,0]
[null,null,{"$f":"'1.0'!D127","v":"Subsidiary Net Income"},{"$f":"'1.0'!F127","v":-14.691134629292488},{"$f":"(G67+G62+G55+G45+G37+G29+G20+SUM(G71:G74))/(SUM($G$67:$H$67)+SUM($G$62:$H$62)+SUM($G$55:$H$55)+SUM($G$45:$H$45)+SUM($G$37:$H$37)+SUM($G$29:$H$29)+SUM($G$20:$H$20)+SUM($G$71:$H$74))","v":0.29076442435109401},{"$f":"(H67+H62+H55+H45+H37+H29+H20+SUM(H71:H74))/(SUM($G$67:$H$67)+SUM($G$62:$H$62)+SUM($G$55:$H$55)+SUM($G$45:$H$45)+SUM($G$37:$H$37)+SUM($G$29:$H$29)+SUM($G$20:$H$20)+SUM($G$71:$H$74))","v":0.70923557564890594},{"$f":"D70*E70","v":-4.2716593035506536},{"$f":"+D70*F70","v":-10.419475325741834},"Total costs before subsidiary income"]
[null,null,{"$f":"'1.0'!D128","v":"Other Utility Revenue"},{"$f":"'1.0'!F128","v":-16.499916335699446},{"$f":"$E$23","v":0.57899999999999996},{"$f":"1-E71","v":0.42100000000000004},-9.5534515583699786,-6.9464647773294672]
[null,null,"Deferral Rider Revenue",{"$f":"'1.0'!F129","v":-222.99174682993481},{"$f":"E23","v":0.57899999999999996},0.42100000000000004,{"$f":"D72*E72","v":-129.11222141453226},{"$f":"+D72*F72","v":-93.879525415402568}]
[null,null,{"$f":"'1.0'!D130","v":"Intersegment revenues"},{"$f":"'1.0'!F130","v":-3},0.57899999999999996,0.42100000000000004,-1.7369999999999999,-1.2630000000000001]
[null,null,{"$f":"'1.0'!D131","v":"Internal Allocations (GRTA, SDA)"},{"$f":"'1.0'!F131","v":43.3},0.57899999999999996,0.42100000000000004,25.070699999999995,18.229300000000002]
[null,"Total",null,{"$f":"SUM(D70:D74)","v":-213.88279779492672},null,null,{"$f":"SUM(G70:G74)","v":-119.60363227645288},{"$f":"SUM(H70:H74)","v":-94.279165518473889}]
[]
[null,"Total Generation Costs",null,{"$f":"D67+D62+D55+D45+D37+D29+D20+D75","v":2593.3283588271993},null,null,{"$f":"G67+G62+G55+G45+G37+G29+G20+G75","v":754.04762740775777},{"$f":"H67+H62+H55+H45+H37+H29+H20+H75","v":1839.2807314194408}]
[]
[null,null,null,{"$f":"IF(ROUND(D77,2)<>ROUND('1.0'!F134,2),\"error\",\"\")","v":""}]

{"sheet":"2.1","index":3,"n_rows":73,"n_cols":6,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[1,0,1,5]]}
["Classification of Transmission Function"]
["(Functionalized Costs from Schedule 1.0)"]
[]
[null,null,null,"Functionalized Costs","Demand Related","Demand Costs"]
[]
[null,{"$f":"'1.0'!$C$5","v":"Cost of Energy "}]
[null,null,{"$f":"'1.0'!D6","v":"IPPs and Long-term Purchases commitment"},{"$f":"'1.0'!G6","v":0},{"$f":"$E$14","v":1},{"$f":"D7*E7","v":0}]
[null,null,{"$f":"'1.0'!D7","v":"Domestic Transmission (Non-Heritage)"},{"$f":"'1.0'!G7","v":0},1,{"$f":"D8*E8","v":0}]
[null,null,{"$f":"'1.0'!D8","v":"NIA Generation"},{"$f":"'1.0'!G8","v":0},1,{"$f":"D9*E9","v":0}]
[null,null,{"$f":"'1.0'!D9","v":"Gas Transportation"},{"$f":"'1.0'!G9","v":0},1,{"$f":"D10*E10","v":0}]
[null,null,{"$f":"'1.0'!D10","v":"Water Rentals"},{"$f":"'1.0'!G10","v":0},1,{"$f":"D11*E11","v":0}]
[null,null,{"$f":"'1.0'!D11","v":"Market Purchases"},{"$f":"'1.0'!G11","v":0},1,{"$f":"D12*E13","v":0}]
[null,null,{"$f":"'1.0'!D12","v":"Natural gas for thermal generation"},{"$f":"'1.0'!G12","v":0},{"$f":"$E$14","v":1},{"$f":"D13*E13","v":0}]
[null,null,{"$f":"'1.0'!D13","v":"Domestic Transmission (Heritage)"},{"$f":"'1.0'!G13","v":25.7},1,{"$f":"D14*E14","v":25.7}]
[null,null,{"$f":"'1.0'!D15","v":"Other and Surplus Sales"},{"$f":"'1.0'!G15","v":0},null,{"$f":"D15*E15","v":0}]
[null,"Total ",null,{"$f":"SUM(D7:D15)","v":25.7},null,{"$f":"SUM(F7:F15)","v":25.7}]
[]
[null,{"$f":"'1.0'!$C$21","v":"O M & A Expenses"}]
[null,null,{"$f":"'1.0'!D31","v":"Generation"},{"$f":"'1.0'!G31","v":0},{"$f":"$E$14","v":1},{"$f":"D19*E19","v":0}]
[null,null,{"$f":"'1.0'!D37","v":"Transmission"},{"$f":"'1.0'!G37","v":237.95642528989458},1,{"$f":"D20*E20","v":237.95642528989458}]
[null,null,{"$f":"'1.0'!D44","v":"Distribution"},{"$f":"'1.0'!G44","v":0},1,{"$f":"D21*E21","v":0}]
[null,null,"Customer Care",{"$f":"'1.0'!G47","v":0},1,{"$f":"D22*E22","v":0}]
[null,null,{"$f":"'1.0'!D58","v":"Corp Service"},{"$f":"'1.0'!G58","v":25.819199088779214},1,{"$f":"D23*E23","v":25.819199088779214}]
[null,"Total ",null,{"$f":"SUM(D19:D23)","v":263.7756243786738},null,{"$f":"SUM(F19:F23)","v":263.7756243786738}]
[]
[null,{"$f":"'1.0'!$C$61","v":"Depreciation & Amortization"}]
[null,null,{"$f":"'1.0'!D65","v":"Generation"},{"$f":"'1.0'!G65","v":0},{"$f":"$E$14","v":1},{"$f":"D27*E27","v":0}]
[null,null,{"$f":"'1.0'!D69","v":"Transmission"},{"$f":"'1.0'!G69","v":187.13497562200001},1,{"$f":"D28*E28","v":187.13497562200001}]
[null,null,{"$f":"'1.0'!D74","v":"Distribution"},{"$f":"'1.0'!G74","v":0},1,{"$f":"D29*E29","v":0}]
[null,null,"Customer Care",{"$f":"'1.0'!G76","v":0},1,{"$f":"D30*E30","v":0}]
[null,null,{"$f":"'1.0'!D80","v":"Corporate Services"},{"$f":"'1.0'!G80","v":0},1,{"$f":"D31*E31","v":0}]
[null,"Total ",null,{"$f":"SUM(D27:D31)","v":187.13497562200001},null,{"$f":"SUM(F27:F31)","v":187.13497562200001}]
[]
[null,{"$f":"'1.0'!$C$83","v":"Taxes"}]
[null,null,{"$f":"'1.0'!D84","v":"Generation"},{"$f":"'1.0'!G84","v":0},{"$f":"$E$14","v":1},{"$f":"D35*E35","v":0}]
[null,null,{"$f":"'1.0'!D85","v":"Transmission"},{"$f":"'1.0'!G85","v":131.96299999999999},1,{"$f":"D36*E36","v":131.96299999999999}]
[null,null,{"$f":"'1.0'!D86","v":"Distribution"},{"$f":"'1.0'!G86","v":0},1,{"$f":"D37*E37","v":0}]
[null,null,{"$f":"'1.0'!D87","v":"Customer Care"},{"$f":"'1.0'!G87","v":0},1,{"$f":"D38*E38","v":0}]
[null,null,{"$f":"'1.0'!D88","v":"Corporate"},{"$f":"'1.0'!G88","v":0},1,{"$f":"D39*E39","v":0}]
[null,"Total ",null,{"$f":"SUM(D36:D39)","v":131.96299999999999},null,{"$f":"SUM(F36:F39)","v":131.96299999999999}]
[]
[null,{"$f":"'1.0'!$C$91","v":"Finance Charges"}]
[null,null,{"$f":"'1.0'!D92","v":"Generation"},{"$f":"'1.0'!G92","v":0},{"$f":"$E$14","v":1},{"$f":"D43*E43","v":0}]
[null,null,{"$f":"'1.0'!D93","v":"Transmission"},{"$f":"'1.0'!G93","v":261.24027603363299},1,261.24027603363299]
[null,null,{"$f":"'1.0'!D94","v":"Distribution"},{"$f":"'1.0'!G94","v":0},1,0]
[null,null,{"$f":"'1.0'!D95","v":"Customer Care"},{"$f":"'1.0'!G95","v":0},1,0]
[null,null,"Interest on Regulatory Accounts",{"$f":"'1.0'!G108","v":-19.798250905410079},1,-19.798250905410079]
[null,null,"Regulatory Account Recoveries",{"$f":"'1.0'!G111","v":-8.4156658705281941},1,-8.4156658705281941]
[null,"Total ",null,{"$f":"SUM(D43:D48)","v":233.02635925769474},null,{"$f":"SUM(F43:F48)","v":233.02635925769474}]
[]
[null,{"$f":"'1.0'!$C$114","v":"Allowed Net Income"}]
[null,null,{"$f":"'1.0'!D115","v":"Generation"},{"$f":"'1.0'!G115","v":0},{"$f":"$E$14","v":1},{"$f":"D52*E52","v":0}]
[null,null,{"$f":"'1.0'!D116","v":"Transmission"},{"$f":"'1.0'!G116","v":209.03946795835179},1,{"$f":"D53*E53","v":209.03946795835179}]
[null,null,{"$f":"'1.0'!D117","v":"Distribution"},{"$f":"'1.0'!G117","v":0},1,{"$f":"D54*E54","v":0}]
[null,null,"Customer Care",{"$f":"'1.0'!G118","v":0},1,{"$f":"D55*E55","v":0}]
[null,"Total ",null,{"$f":"SUM(D52:D55)","v":209.03946795835179},null,{"$f":"SUM(F52:F55)","v":209.03946795835179}]
[]
[null,{"$f":"'1.0'!$C$121","v":"Miscellaneous Revenues"}]
[null,null,{"$f":"'1.0'!D122","v":"Non Tariff Revenue (Functionalized)"},{"$f":"'1.0'!G122","v":-39.191343315875997},{"$f":"$E$14","v":1},{"$f":"D59*E59","v":-39.191343315875997}]
[null,null,{"$f":"'1.0'!D123","v":"Corporate Miscellaneous Revenue"},{"$f":"'1.0'!G123","v":-3.9103605225083826},{"$f":"$E$14","v":1},{"$f":"D60*E60","v":-3.9103605225083826}]
[null,"Total ",null,{"$f":"SUM(D59:D60)","v":-43.101703838384381},null,{"$f":"SUM(F59:F60)","v":-43.101703838384381}]
[]
[null,{"$f":"'1.0'!$C$126","v":"Deferral Accounts, Revenue Offsets & Other"}]
[null,null,{"$f":"'1.0'!D127","v":"Subsidiary Net Income"},{"$f":"'1.0'!G127","v":0},{"$f":"$E$14","v":1},{"$f":"D64*E64","v":0}]
[null,null,{"$f":"'1.0'!D128","v":"Other Utility Revenue"},{"$f":"'1.0'!G128","v":0},1,{"$f":"D65*E65","v":0}]
[null,null,"Deferral Rider Revenue",{"$f":"'1.0'!G129","v":0},1,{"$f":"D66*E66","v":0}]
[null,null,{"$f":"'1.0'!D130","v":"Intersegment revenues"},{"$f":"'1.0'!G130","v":-50.510359036389922},1,{"$f":"D67*E67","v":-50.510359036389922}]
[null,null,{"$f":"'1.0'!D131","v":"Internal Allocations (GRTA, SDA)"},{"$f":"'1.0'!G131","v":-191.57406614988662},1,{"$f":"D68*E68","v":-191.57406614988662}]
[null,"Total ",null,{"$f":"SUM(D64:D68)","v":-242.08442518627655},null,{"$f":"SUM(F64:F68)","v":-242.08442518627655}]
[]
[null,"Total Transmission Costs",null,{"$f":"D61+D56+D49+D40+D32+D24+D16+D69","v":765.45329819205938},null,{"$f":"F61+F56+F49+F40+F32+F24+F16+F69","v":765.45329819205938}]
[]
[null,null,null,{"$f":"IF(ROUND(D71,2)<>ROUND('1.0'!G134,2),\"error\",\"\")","v":""}]

{"sheet":"2.2","index":4,"n_rows":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,0,2,10],[1,0,1,10]]}
["Classification of Distribution Function"]
["(Functionalized Costs from Schedule 1.0)"]
[]
[null,null,null,"Functionalized Costs","Demand Related","Customer Related","SMI Energy Related","Streetlighting Costs (Direct Assigned)","Demand Costs","Customer Costs","SMI Energy \nCosts"]
[]
[null,{"$f":"'1.0'!$C$5","v":"Cost of Energy "}]
[null,null,{"$f":"'1.0'!D6","v":"IPPs and Long-term Purchases commitment"},{"$f":"'1.0'!H6","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E7","v":0.35},null,null,{"$f":"($D7-$H7)*E7","v":0},{"$f":"($D7-$H7)*F7","v":0},{"$f":"($D7-$H7)*G7","v":0}]
[null,null,{"$f":"'1.0'!D7","v":"Domestic Transmission (Non-Heritage)"},{"$f":"'1.0'!H7","v":0},0.65,{"$f":"1-E8","v":0.35},null,null,{"$f":"($D8-$H8)*E8","v":0},{"$f":"($D8-$H8)*F8","v":0},{"$f":"($D8-$H8)*G8","v":0}]
[null,null,{"$f":"'1.0'!D8","v":"NIA Generation"},{"$f":"'1.0'!H8","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D9","v":"Gas Transportation"},{"$f":"'1.0'!H9","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D10","v":"Water Rentals"},{"$f":"'1.0'!H10","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D11","v":"Market Purchases"},{"$f":"'1.0'!H11","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D12","v":"Natural gas for thermal generation"},{"$f":"'1.0'!H12","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D13","v":"Domestic Transmission (Heritage)"},{"$f":"'1.0'!H13","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D14","v":"Non-treaty storage agreement"},{"$f":"'1.0'!H14","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D15","v":"Other and Surplus Sales"},{"$f":"'1.0'!H15","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D16","v":"Net purchases (sales) from Powerex"},{"$f":"'1.0'!H16","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D17","v":"Heritage Deferral Account Recoveries"},{"$f":"'1.0'!H17","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D18","v":"Non-Heritage Deferral Account Recoveries"},{"$f":"'1.0'!H18","v":0},0.65,0.35,null,null,0,0,0]
[null,"Total ",null,{"$f":"SUM(D7:D19)","v":0},null,null,null,{"$f":"SUM(H7:H19)","v":0},{"$f":"SUM(I7:I19)","v":0},{"$f":"SUM(J7:J19)","v":0},{"$f":"SUM(K7:K19)","v":0}]
[]
[null,{"$f":"'1.0'!$C$21","v":"O M & A Expenses"}]
[null,null,{"$f":"'1.0'!D31","v":"Generation"},{"$f":"'1.0'!H31","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E23","v":0.35},null,null,{"$f":"($D23-$H23)*E23","v":0},0,{"$f":"($D23-$H23)*G23","v":0}]
[null,null,{"$f":"'1.0'!D37","v":"Transmission"},{"$f":"'1.0'!H37","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E24","v":0.35},null,null,0,0,0]
[null,null,"SMI",{"$f":"'1.0'!H43","v":31.326242819504898},{"$f":"IF('4.0'!$E$25=\"SQ\",E26,0)","v":0.65},{"$f":"1-E25-G25","v":0.35},{"$f":"IF('4.0'!$E$25=\"Option 3\",0.3,IF('4.0'!$E$25=\"Option 5\",0.05,0))","v":0},null,20.362057832678186,10.964184986826714,0]
[null,null,{"$f":"'1.0'!D44","v":"Distribution"},{"$f":"'1.0'!H44-D25","v":191.76547132568524},{"$f":"ROUND(IF('4.0'!E26=\"SQ\",0.65,'6.0'!$H$10),2)","v":0.65},{"$f":"1-E26","v":0.35},null,1.2312387086999999,{"$f":"($D26-$H26)*E26","v":123.84725120104041},66.686981415944828,0]
[null,null,"Customer Care",{"$f":"'1.0'!H47","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E27","v":0.35},null,null,0,0,0]
[null,null,{"$f":"'1.0'!D58","v":"Corp Service"},{"$f":"'1.0'!H58","v":24.206320024997883},{"$f":"$E$26","v":0.65},{"$f":"1-E28","v":0.35},null,null,15.734108016248625,8.4722120087492581,0]
[null,"Total ",null,{"$f":"SUM(D23:D28)","v":247.29803417018803},null,null,null,{"$f":"SUM(H23:H28)","v":1.2312387086999999},{"$f":"SUM(I23:I28)","v":159.94341704996722},{"$f":"SUM(J23:J28)","v":86.12337841152079},{"$f":"SUM(K23:K28)","v":0}]
[]
[null,{"$f":"'1.0'!$C$61","v":"Depreciation & Amortization"}]
[null,null,{"$f":"'1.0'!D65","v":"Generation"},{"$f":"'1.0'!H65","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E32","v":0.35},null,null,{"$f":"($D32-$H32)*E32","v":0},{"$f":"($D32-$H32)*F32","v":0},0]
[null,null,{"$f":"'1.0'!D69","v":"Transmission"},{"$f":"'1.0'!H69","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D74","v":"Distribution"},{"$f":"'1.0'!H74","v":220.64000000000001},{"$f":"$E$26","v":0.65},{"$f":"1-E34","v":0.35},null,1.1589695875824002,142.66266976807145,76.818360644346157,0]
[null,null,"Customer Care",{"$f":"'1.0'!H76","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E35","v":0.35},null,null,0,0,0]
[null,null,{"$f":"'1.0'!D80","v":"Corporate Services"},{"$f":"'1.0'!H80","v":11.457392696460872},{"$f":"$E$26","v":0.65},{"$f":"1-E36","v":0.35},null,null,7.4473052526995671,4.0100874437613045,0]
[null,"Total ",null,{"$f":"SUM(D32:D36)","v":232.09739269646087},null,null,null,{"$f":"SUM(H32:H36)","v":1.1589695875824002},{"$f":"SUM(I32:I36)","v":150.10997502077103},{"$f":"SUM(J32:J36)","v":80.828448088107464}]
[]
[null,{"$f":"'1.0'!$C$83","v":"Taxes"}]
[null,null,{"$f":"'1.0'!D84","v":"Generation"},{"$f":"'1.0'!H84","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E40","v":0.35},null,null,{"$f":"($D40-$H40)*E40","v":0},{"$f":"($D40-$H40)*F40","v":0},0]
[null,null,{"$f":"'1.0'!D85","v":"Transmission"},{"$f":"'1.0'!H85","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D86","v":"Distribution"},{"$f":"'1.0'!H86","v":27.585999999999999},{"$f":"$E$26","v":0.65},{"$f":"1-E42","v":0.35},null,{"$f":"IF('4.0'!$E$26=\"SQ\",+($H$26/SUM($D$25:$D$26)),'6.0'!$D$9)*D42","v":0.15224658230064739},17.831939721504579,9.6018136961947711,0]
[null,null,{"$f":"'1.0'!D87","v":"Customer Care"},{"$f":"'1.0'!H87","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E43","v":0.35},null,null,0,0,0]
[null,null,{"$f":"'1.0'!D88","v":"Corporate"},{"$f":"'1.0'!H88","v":5.6890814879034561},{"$f":"$E$26","v":0.65},{"$f":"1-E44","v":0.35},null,null,3.6979029671372468,1.9911785207662096,0]
[null,"Total ",null,{"$f":"SUM(D40:D44)","v":33.275081487903456},null,null,null,{"$f":"SUM(H40:H44)","v":0.15224658230064739},{"$f":"SUM(I40:I44)","v":21.529842688641825},{"$f":"SUM(J40:J44)","v":11.592992216960981}]
[]
[null,{"$f":"'1.0'!$C$91","v":"Finance Charges"}]
[null,null,{"$f":"'1.0'!D92","v":"Generation"},{"$f":"'1.0'!H92","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E48","v":0.35},null,null,{"$f":"($D48-$H48)*E48","v":0},{"$f":"($D48-$H48)*F48","v":0},0]
[null,null,{"$f":"'1.0'!D93","v":"Transmission"},{"$f":"'1.0'!H93","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D94","v":"Distribution"},{"$f":"'1.0'!H94","v":209.01621971232166},{"$f":"$E$26","v":0.65},{"$f":"1-E50","v":0.35},null,{"$f":"IF('4.0'!$E$26=\"SQ\",+($H$26/SUM($D$25:$D$26)),'6.0'!$D$9)*D50","v":1.1535563364243522},135.11073119433325,72.751932181564058,0]
[null,null,{"$f":"'1.0'!D95","v":"Customer Care"},{"$f":"'1.0'!H95","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E51","v":0.35},null,null,0,0,0]
[null,null,"Interest on Regulatory Accounts",{"$f":"'1.0'!H108","v":-15.840419494244077},{"$f":"$E$26","v":0.65},{"$f":"1-E52","v":0.35},null,null,-10.296272671258651,-5.5441468229854269,0]
[null,null,"Regulatory Account Recoveries",{"$f":"'1.0'!H111","v":-6.7333058030965587},{"$f":"$E$26","v":0.65},{"$f":"1-E53","v":0.35},null,null,-4.3766487720127634,-2.3566570310837953,0]
[null,"Total ",null,{"$f":"SUM(D48:D53)","v":186.44249441498101},null,null,null,{"$f":"SUM(H48:H53)","v":1.1535563364243522},{"$f":"SUM(I48:I53)","v":120.43780975106185},{"$f":"SUM(J48:J53)","v":64.851128327494834},{"$f":"SUM(K48:K53)","v":0}]
[]
[null,{"$f":"'1.0'!$C$114","v":"Allowed Net Income"}]
[null,null,{"$f":"'1.0'!D115","v":"Generation"},{"$f":"'1.0'!H115","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E57","v":0.35},null,null,{"$f":"($D57-$H57)*E57","v":0},{"$f":"($D57-$H57)*F57","v":0},0]
[null,null,{"$f":"'1.0'!D116","v":"Transmission"},{"$f":"'1.0'!H116","v":0},0.65,0.35,null,null,0,0,0]
[null,null,{"$f":"'1.0'!D117","v":"Distribution"},{"$f":"'1.0'!H117","v":167.25077781537999},{"$f":"$E$26","v":0.65},{"$f":"1-E59","v":0.35},null,{"$f":"IF('4.0'!$E$26=\"SQ\",+($H$26/SUM($D$25:$D$26)),'6.0'!$D$9)*D59","v":0.92305369787270874},108.11302067637973,58.21470344112754,0]
[null,null,{"$f":"'1.0'!D118","v":"Customer Care"},{"$f":"'1.0'!H118","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E60","v":0.35},null,null,0,0,0]
[null,"Total ",null,{"$f":"SUM(D57:D60)","v":167.25077781537999},null,null,null,{"$f":"SUM(H57:H60)","v":0.92305369787270874},{"$f":"SUM(I57:I60)","v":108.11302067637973},{"$f":"SUM(J57:J60)","v":58.21470344112754}]
[]
[null,{"$f":"'1.0'!$C$121","v":"Miscellaneous Revenues"}]
[null,null,{"$f":"'1.0'!D122","v":"Non Tariff Revenue (Functionalized)"},{"$f":"'1.0'!H122","v":-51.089361324000002},{"$f":"$E$26","v":0.65},{"$f":"1-E64","v":0.35},null,null,{"$f":"($D64-$H64)*E64","v":-33.208084860600003},{"$f":"($D64-$H64)*F64","v":-17.881276463399999},0]
[null,null,{"$f":"'1.0'!D123","v":"Corporate Miscellaneous Revenue"},{"$f":"'1.0'!H123","v":-5.0974987009595134},{"$f":"$E$26","v":0.65},{"$f":"1-E65","v":0.35},null,null,-3.3133741556236838,-1.7841245453358296,0]
[null,"Total ",null,{"$f":"SUM(D64:D65)","v":-56.186860024959515},null,null,null,{"$f":"SUM(H64:H65)","v":0},{"$f":"SUM(I64:I65)","v":-36.521459016223687},{"$f":"SUM(J64:J65)","v":-19.665401008735827},{"$f":"SUM(K64:K65)","v":0}]
[]
[null,{"$f":"'1.0'!$C$126","v":"Deferral Accounts, Revenue Offsets & Other"}]
[null,null,{"$f":"'1.0'!D127","v":"Subsidiary Net Income"},{"$f":"'1.0'!H127","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E69","v":0.35},null,null,{"$f":"($D69-$H69)*E69","v":0},{"$f":"($D69-$H69)*F69","v":0},0]
[null,null,{"$f":"'1.0'!D128","v":"Other Utility Revenue"},{"$f":"'1.0'!H128","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E70","v":0.35},null,null,0,0,0]
[null,null,"Deferral Rider Revenue",{"$f":"'1.0'!H129","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E71","v":0.35},null,null,0,0,0]
[null,null,{"$f":"'1.0'!D130","v":"Intersegment revenues"},{"$f":"'1.0'!H130","v":0},{"$f":"$E$26","v":0.65},{"$f":"1-E72","v":0.35},null,null,0,0,0]
[null,null,{"$f":"'1.0'!D131","v":"Internal Allocations (GRTA, SDA)"},{"$f":"'1.0'!H131","v":148.27406614988664},{"$f":"IF('4.0'!E26=\"SQ\",0.65,1)","v":0.65},{"$f":"1-E73","v":0.35},null,null,96.378142997426323,51.89592315246032,0]
[null,"Total ",null,{"$f":"SUM(D69:D73)","v":148.27406614988664},null,null,null,{"$f":"SUM(H69:H73)","v":0},{"$f":"SUM(I69:I73)","v":96.378142997426323},{"$f":"SUM(J69:J73)","v":51.89592315246032},{"$f":"SUM(K69:K73)","v":0}]
[]
[null,"Total Distribution Costs",null,{"$f":"D66+D61+D54+D45+D37+D29+D20+D74","v":958.45098670984032},null,null,null,{"$f":"H66+H61+H54+H45+H37+H29+H20+H74","v":4.6190649128801091},{"$f":"I66+I61+I54+I45+I37+I29+I20+I74","v":619.99074916802419},{"$f":"J66+J61+J54+J45+J37+J29+J20+J74","v":333.84117262893614},{"$f":"K66+K61+K54+K45+K37+K29+K20+K74","v":0}]

{"sheet":"2.3","index":5,"n_rows":73,"n_cols":8,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,7],[49,0,49,2],[40,0,40,2],[1,0,1,7]]}
["Classification of Customer Care Function"]
["(Functionalized Costs from Schedule 1.0)"]
[]
[null,null,null,"Functionalized Costs","Demand Related","Customer Related","Demand Costs","Customer Costs"]
[]
[null,{"$f":"'1.0'!$C$5","v":"Cost of Energy "}]
[null,null,{"$f":"'1.0'!D6","v":"IPPs and Long-term Purchases commitment"},{"$f":"'1.0'!I6","v":0},{"$f":"IF('4.0'!E27=\"SQ\",0.65,0)","v":0.65},{"$f":"1-E7","v":0.35},{"$f":"D7*E7","v":0},{"$f":"D7*F7","v":0}]
[null,null,{"$f":"'1.0'!D7","v":"Domestic Transmission (Non-Heritage)"},{"$f":"'1.0'!I7","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E8","v":0.35},0,0]
[null,null,{"$f":"'1.0'!D8","v":"NIA Generation"},{"$f":"'1.0'!I8","v":0},{"$f":"$E$7","v":0.65},0.35,0,0]
[null,null,{"$f":"'1.0'!D9","v":"Gas Transportation"},{"$f":"'1.0'!I9","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D10","v":"Water Rentals"},{"$f":"'1.0'!I10","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D11","v":"Market Purchases"},{"$f":"'1.0'!I11","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D12","v":"Natural gas for thermal generation"},{"$f":"'1.0'!I12","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D13","v":"Domestic Transmission (Heritage)"},{"$f":"'1.0'!I13","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D15","v":"Other and Surplus Sales"},{"$f":"'1.0'!I15","v":0},0.65,0.35,0,0]
[null,"Total ",null,{"$f":"SUM(D7:D15)","v":0},null,null,{"$f":"SUM(G7:G15)","v":0},{"$f":"SUM(H7:H15)","v":0}]
[]
[null,{"$f":"'1.0'!$C$21","v":"O M & A Expenses"}]
[null,null,{"$f":"'1.0'!D31","v":"Generation"},{"$f":"'1.0'!I31","v":9.4286305000000006},{"$f":"$E$7","v":0.65},{"$f":"1-E19","v":0.35},{"$f":"D19*E19","v":6.1286098250000007},{"$f":"D19*F19","v":3.3000206749999998}]
[null,null,{"$f":"'1.0'!D37","v":"Transmission"},{"$f":"'1.0'!I37","v":0},0.65,0.35,{"$f":"D20*E20","v":0},{"$f":"D20*F20","v":0}]
[null,null,{"$f":"'1.0'!D44","v":"Distribution"},{"$f":"'1.0'!I44","v":0},0.65,0.35,{"$f":"D21*E21","v":0},{"$f":"D21*F21","v":0}]
[null,null,"Customer Care",{"$f":"'1.0'!I47","v":106.93413805},0.65,0.35,{"$f":"D22*E22","v":69.507189732500009},{"$f":"D22*F22","v":37.426948317499999}]
[null,null,{"$f":"'1.0'!D58","v":"Corp Service"},{"$f":"'1.0'!I58","v":12.625813671783948},0.65,0.35,{"$f":"D23*E23","v":8.206778886659567},{"$f":"D23*F23","v":4.4190347851243814}]
[null,"Total ",null,{"$f":"SUM(D19:D23)","v":128.98858222178396},null,null,{"$f":"SUM(G19:G23)","v":83.842578444159571},{"$f":"SUM(H19:H23)","v":45.146003777624379}]
[]
[null,{"$f":"'1.0'!$C$61","v":"Depreciation & Amortization"}]
[null,null,{"$f":"'1.0'!D65","v":"Generation"},{"$f":"'1.0'!I65","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E27","v":0.35},{"$f":"D27*E27","v":0},{"$f":"D27*F27","v":0}]
[null,null,{"$f":"'1.0'!D69","v":"Transmission"},{"$f":"'1.0'!I69","v":0},0.65,0.35,0,{"$f":"D28*F28","v":0}]
[null,null,{"$f":"'1.0'!D74","v":"Distribution"},{"$f":"'1.0'!I74","v":0},0.65,0.35,0,{"$f":"D29*F29","v":0}]
[null,null,"Customer Care",{"$f":"'1.0'!I76","v":25.8},0.65,0.35,16.77,{"$f":"D30*F30","v":9.0299999999999994}]
[null,null,{"$f":"'1.0'!D80","v":"Corporate Services"},{"$f":"'1.0'!I80","v":1.3397422569284378},0.65,0.35,0.8708324670034846,{"$f":"D31*F31","v":0.46890978992495319}]
[null,"Total ",null,{"$f":"SUM(D27:D31)","v":27.139742256928439},null,null,{"$f":"SUM(G27:G31)","v":17.640832467003484},{"$f":"SUM(H27:H31)","v":9.4989097899249533}]
[]
[null,{"$f":"'1.0'!$C$83","v":"Taxes"}]
[null,null,{"$f":"'1.0'!D84","v":"Generation"},{"$f":"'1.0'!I84","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E35","v":0.35},{"$f":"D35*E35","v":0},{"$f":"D35*F35","v":0}]
[null,null,{"$f":"'1.0'!D85","v":"Transmission"},{"$f":"'1.0'!I85","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D86","v":"Distribution"},{"$f":"'1.0'!I86","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D87","v":"Customer Care"},{"$f":"'1.0'!I87","v":5.7545555537904658},0.65,0.35,3.7404611099638028,2.014094443826663]
[null,null,{"$f":"'1.0'!D88","v":"Corporate"},{"$f":"'1.0'!I88","v":1.1867663116139113},0.65,0.35,0.7713981025490424,0.41536820906486893]
[null,"Total ",null,{"$f":"SUM(D35:D39)","v":6.9413218654043769},null,null,{"$f":"SUM(G35:G39)","v":4.5118592125128449},{"$f":"SUM(H35:H39)","v":2.429462652891532}]
[]
[null,{"$f":"'1.0'!$C$91","v":"Finance Charges"}]
[null,null,{"$f":"'1.0'!D92","v":"Generation"},{"$f":"'1.0'!I92","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E43","v":0.35},{"$f":"D43*E43","v":0},{"$f":"D43*F43","v":0}]
[null,null,{"$f":"'1.0'!D93","v":"Transmission"},{"$f":"'1.0'!I93","v":0},0.65,0.35,0,{"$f":"D44*F44","v":0}]
[null,null,{"$f":"'1.0'!D94","v":"Distribution"},{"$f":"'1.0'!I94","v":0},0.65,0.35,0,{"$f":"D45*F45","v":0}]
[null,null,{"$f":"'1.0'!D95","v":"Customer Care"},{"$f":"'1.0'!I95","v":-1.2953734435369817E-3},0.65,0.35,-8.4199273829903818E-4,{"$f":"D46*F46","v":-4.5338070523794359E-4}]
[null,null,"Interest on Regulatory Accounts",{"$f":"'1.0'!I108","v":9.8170652859241525E-5},0.65,0.35,6.3810924358506988E-5,{"$f":"+D47*F47","v":3.435972850073453E-5}]
[null,null,"Regulatory Account Recoveries",{"$f":"'1.0'!I111","v":4.172951523355178E-5},0.65,0.35,2.7124184901808657E-5,1.4605330331743121E-5]
[null,"Total ",null,{"$f":"SUM(D43:D48)","v":-1.1554732754441885E-3},null,null,{"$f":"SUM(G43:G48)","v":-7.5105762903872255E-4},{"$f":"SUM(H43:H48)","v":-4.0441564640546592E-4}]
[]
[null,{"$f":"'1.0'!$C$114","v":"Allowed Net Income"}]
[null,null,{"$f":"'1.0'!D115","v":"Generation"},{"$f":"'1.0'!I115","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E52","v":0.35},{"$f":"D52*E52","v":0},{"$f":"D52*F52","v":0}]
[null,null,"Transmission",{"$f":"'1.0'!I116","v":0},0.65,{"$f":"1-E53","v":0.35},{"$f":"D53*E53","v":0},{"$f":"D53*F53","v":0}]
[null,null,{"$f":"'1.0'!D117","v":"Distribution"},{"$f":"'1.0'!I117","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E54","v":0.35},{"$f":"D54*E54","v":0},{"$f":"D54*F54","v":0}]
[null,null,{"$f":"'1.0'!D118","v":"Customer Care"},{"$f":"'1.0'!I118","v":-1.1620378434585457E-3},0.65,0.35,{"$f":"D55*E55","v":-7.5532459824805475E-4},{"$f":"D55*F55","v":-4.0671324521049097E-4}]
[null,"Total ",null,{"$f":"SUM(D52:D55)","v":-1.1620378434585457E-3},null,null,{"$f":"SUM(G52:G55)","v":-7.5532459824805475E-4},{"$f":"SUM(H52:H55)","v":-4.0671324521049097E-4}]
[]
[null,{"$f":"'1.0'!$C$121","v":"Miscellaneous Revenues"}]
[null,null,{"$f":"'1.0'!D122","v":"Non Tariff Revenue (Functionalized)"},{"$f":"'1.0'!I122","v":-18.728131032971501},{"$f":"$E$7","v":0.65},{"$f":"1-E59","v":0.35},{"$f":"D59*E59","v":-12.173285171431475},{"$f":"D59*F59","v":-6.5548458615400245}]
[null,null,{"$f":"'1.0'!D123","v":"Corporate Miscellaneous Revenue"},{"$f":"'1.0'!I123","v":-1.8686204160302327},0.65,0.35,{"$f":"D60*E60","v":-1.2146032704196512},{"$f":"D60*F60","v":-0.65401714561058144}]
[null,"Total ",null,{"$f":"SUM(D59:D60)","v":-20.596751449001733},null,null,{"$f":"SUM(G59:G60)","v":-13.387888441851127},{"$f":"SUM(H59:H60)","v":-7.2088630071506064}]
[]
[null,{"$f":"'1.0'!$C$126","v":"Deferral Accounts, Revenue Offsets & Other"}]
[null,null,{"$f":"'1.0'!D127","v":"Subsidiary Net Income"},{"$f":"'1.0'!I127","v":0},{"$f":"$E$7","v":0.65},{"$f":"1-E64","v":0.35},{"$f":"D64*E64","v":0},{"$f":"D64*F64","v":0}]
[null,null,{"$f":"'1.0'!D128","v":"Other Utility Revenue"},{"$f":"'1.0'!I128","v":0},0.65,0.35,0,0]
[null,null,"Deferral Rider Revenue",{"$f":"'1.0'!I129","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D130","v":"Intersegment revenues"},{"$f":"'1.0'!I130","v":0},0.65,0.35,0,0]
[null,null,{"$f":"'1.0'!D131","v":"Internal Allocations (GRTA, SDA)"},{"$f":"'1.0'!I131","v":0},0.65,0.35,0,0]
[null,"Total ",null,{"$f":"'1.0'!I132","v":0},null,null,{"$f":"SUM(G64:G65)","v":0},{"$f":"SUM(H64:H65)","v":0}]
[]
[null,"Total Customer Care Costs",null,{"$f":"D61+D56+D49+D40+D32+D24+D16+D69","v":142.47057738399613},null,null,{"$f":"G61+G56+G49+G40+G32+G24+G16+G69","v":92.605875299597486},{"$f":"H61+H56+H49+H40+H32+H24+H16+H69","v":49.864702084398644}]
[]
[null,null,null,{"$f":"IF(ROUND(D71,2)<>ROUND('1.0'!I134,2),\"error\",\"\")","v":""}]

{"sheet":"3.0","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"Allocation of Generation Costs"]
[null,"(Classified Costs from Schedule 2.0)"]
[]
[null,"Cost Classification","Generation Demand","Generation Demand-Related Costs","Generation Energy","Generation Energy \nRelated Costs"]
[null,"Allocation Basis","4 CP Demand including losses\n(Sched 5.1)",{"$f":"'2.0'!G77","v":754.04762740775777},"Energy Including Loss \n(Sched 5.0)",{"$f":"'2.0'!H77","v":1839.2807314194408}]
[null,"Residential",{"$f":"'5.1'!H5","v":0.46480686488451955},{"$f":"C6*D$5","v":350.48651366901021},{"$f":"'5.0'!K5","v":0.3579163708541947},{"$f":"E6*F$5","v":658.30868437169511}]
[null,"GS Under 35 kW",{"$f":"'5.1'!H6","v":7.1586139786123215E-2},53.979358861006304,{"$f":"'5.0'!K6","v":7.0705196713860996E-2},130.0467059270257]
[null,"MGS < 150 kW",{"$f":"'5.1'!H7","v":6.6367083178068248E-2},50.043941608395677,{"$f":"'5.0'!K9","v":6.528460854420913E-2},120.07672255362485]
[null,"LGS > 150 kW",{"$f":"'5.1'!H8","v":0.18599773788301954},140.25115295390091,{"$f":"'5.0'!K12","v":0.21105413925078456},388.18781161028352]
[null,"Irrigation",{"$f":"'5.1'!H9","v":0},0,{"$f":"'5.0'!K13","v":1.5125402485310451E-3},2.7819861346195234]
[null,"Street Lighting",{"$f":"'5.1'!H10","v":6.8617497607546332E-3},5.1740861269627807,{"$f":"'5.0'!K14","v":4.3887003690314293E-3},8.0720520247328977]
[null,"Transmission",{"$f":"'5.1'!H11","v":0.20438042450751487},154.11257418848194,{"$f":"'5.0'!K15","v":0.28913844401938826},531.80676879745954]
[null,"Total",{"$f":"SUM(C6:C12)","v":1},{"$f":"SUM(D6:D12)","v":754.04762740775789},{"$f":"SUM(E6:E12)","v":1},{"$f":"SUM(F6:F12)","v":1839.2807314194411}]

{"sheet":"3.1","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"Allocation of Transmission Costs"]
[null,"(Classified Costs from Schedule 2.1)"]
[]
[null,"Cost Classification","Transmission \nDemand","Demand Related \nCosts (Sched 2.1)"]
[null,"Allocation Basis","4 CP demand including losses (Sched 5.1)",{"$f":"'2.1'!F71","v":765.45329819205938}]
[null,"Residential",{"$f":"'5.1'!H5","v":0.46480686488451955},{"$f":"C6*D$5","v":355.7879477481664}]
[null,"GS Under 35 kW",{"$f":"'5.1'!H6","v":7.1586139786123215E-2},54.795846804125816]
[null,"MGS < 150 kW",{"$f":"'5.1'!H7","v":6.6367083178068248E-2},{"$f":"C8*D$5","v":50.800902710039082}]
[null,"LGS > 150 kW",{"$f":"'5.1'!H8","v":0.18599773788301954},{"$f":"C9*D$5","v":142.37258191881946}]
[null,"Irrigation",{"$f":"'5.1'!H9","v":0},{"$f":"C10*D$5","v":0}]
[null,"Street Lighting",{"$f":"'5.1'!H10","v":6.8617497607546332E-3},5.252348985738208]
[null,"Transmission",{"$f":"'5.1'!H11","v":0.20438042450751487},156.44367002517046]
[null,"Total",{"$f":"SUM(C6:C12)","v":1},{"$f":"SUM(D6:D12)","v":765.45329819205949}]

{"sheet":"3.2","index":8,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,13]]}
[null,"Allocation of Distribution Costs"]
[null,"(Classified Costs from Schedule 2.2)"]
[]
[null,"Cost Classification","Distribution\nDemand \nRelated","Distribution Demand-Related","Distribution\nTransformer \nRelated","Distribution\nTransformer\nRelated","Distribution\nCustomer \nRelated","Distribution\nCustomer \nRelated","Distribution\nSMI Energy \nRelated","Distribution\nSMI Energy \nRelated","Distribution\nMetering \nRelated","Distribution\nMetering \nRelated","Street Light Customer","Street Light Customer Related"]
[null,"Allocation Basis","NCP \n(Sched 5.1)",{"$f":"'2.2'!I76-(F5*0.5)","v":619.99074916802419},"Transformer Allocator\n(Sched 5.4)",{"$f":"IF('4.0'!E31=\"SQ\",0,'6.0'!$E$7*('2.2'!D76-'2.2'!D73))","v":0},"Customer Count (Sched 5.2)",{"$f":"'2.2'!J76-(F5*0.5)-IF('4.0'!$E$32=\"SQ\",0,L5)","v":333.84117262893614},"Energy Including Loss (Sched 5.0)",{"$f":"'2.2'!K76","v":0},"Metering Allocator (Sched 5.2)",{"$f":"IF('4.0'!$E$32=\"SQ\",0,'2.2'!J76*'6.0'!K6)","v":0},"Street Light Direct Assignment",{"$f":"'2.2'!H76","v":4.6190649128801091}]
[null,"Residential",{"$f":"'5.1'!I5","v":0.54285234968957863},{"$f":"C6*D$5","v":336.56343497166409},{"$f":"'5.4'!E4","v":0.65510957450018792},0,{"$f":"'5.2'!D4","v":0.88851773772964338},{"$f":"G6*H$5","v":296.62380346527368},{"$f":"'5.0'!K5","v":0.3579163708541947},0,{"$f":"'5.2'!F4","v":0.77152402134303388},{"$f":"K6*L$5","v":0},0,{"$f":"M6*N$5","v":0}]
[null,"GS Under 35 kW",{"$f":"'5.1'!I6","v":0.10330601475533711},64.048773481724425,{"$f":"'5.4'!E5","v":0.16803187635225431},0,{"$f":"'5.2'!D5","v":9.1891915543324196E-2},30.677304840102511,{"$f":"'5.0'!K6","v":7.0705196713860996E-2},0,{"$f":"'5.2'!F5","v":0.15958447918002575},0,0,0]
[null,"MGS < 150 kW",{"$f":"'5.1'!I7","v":9.1043451869637124E-2},{"$f":"C8*D$5","v":56.446097931499274},{"$f":"'5.4'!E6","v":0.10744412814984622},0,{"$f":"'5.2'!D6","v":9.3773677326263946E-3},{"$f":"G8*H$5","v":3.1305514400327437},{"$f":"'5.0'!K9","v":6.528460854420913E-2},0,{"$f":"'5.2'!F6","v":4.8855734593492621E-2},0,0,{"$f":"M8*N$5","v":0}]
[null,"LGS > 150 kW",{"$f":"'5.1'!I8","v":0.25134961362518771},{"$f":"C9*D$5","v":155.83443525457355},{"$f":"'5.4'!E7","v":5.405442515755865E-2},0,{"$f":"'5.2'!D7","v":3.253031748764085E-3},{"$f":"G9*H$5","v":1.085995933606561},{"$f":"'5.0'!K12","v":0.21105413925078456},0,{"$f":"'5.2'!F7","v":1.6948173546491679E-2},0,0,{"$f":"M9*N$5","v":0}]
[null,"Irrigation",{"$f":"'5.1'!I9","v":4.3373814509853146E-3},{"$f":"C10*D$5","v":2.6891363752238768},{"$f":"'5.4'!E8","v":5.3599955366579874E-3},0,{"$f":"'5.2'!D8","v":1.7778964710458312E-3},{"$f":"G10*H$5","v":0.5935350427067877},{"$f":"'5.0'!K13","v":1.5125402485310451E-3},0,{"$f":"'5.2'!F8","v":3.0875913369559404E-3},0,0,{"$f":"M10*N$5","v":0}]
[null,"Street Lighting",{"$f":"'5.1'!I10","v":7.1111886092741468E-3},{"$f":"C11*D$5","v":4.4088711533389979},{"$f":"'5.4'!E9","v":1.0000000532642214E-2},0,{"$f":"'5.2'!D9","v":5.0291048099867187E-3},{"$f":"G11*H$5","v":1.6789222470397893},{"$f":"'5.0'!K14","v":4.3887003690314293E-3},0,{"$f":"'5.2'!F9","v":0},0,1,{"$f":"N5","v":4.6190649128801091}]
[null,"Transmission",{"$f":"'5.1'!I11","v":0},0,{"$f":"'5.4'!E10","v":0},0,{"$f":"'5.2'!D10","v":1.5294596460944002E-4},5.1059660174079223E-2,{"$f":"'5.0'!K15","v":0.28913844401938826},0,{"$f":"'5.2'!F10","v":0},0,0,0]
[null,"Total",{"$f":"SUM(C6:C12)","v":1},619.99074916802408,1.0000000002291471,0,1.0000000000000002,333.84117262893614,1,0,{"$f":"SUM(K6:K12)","v":0.99999999999999978},0,1,4.6190649128801091]

{"sheet":"3.3","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"Allocation of Customer Care Costs"]
[null,"(Classified Costs from Schedule 2.3)"]
[]
[null,"Cost Classification","Customer Care Demand","Customer Care Demand Related Costs","Customer Care Customer","Customer Care Customer Related Costs"]
[null,"Allocation Basis","NCP \nSched 5.1",{"$f":"'2.3'!G71","v":92.605875299597486},"Blended Customer Count & Revenue Sched 5.3",{"$f":"'2.3'!H71","v":49.864702084398644}]
[null,"Residential",{"$f":"'5.1'!I5","v":0.54285234968957863},{"$f":"C6*D$5","v":50.271317001446604},{"$f":"'5.3'!M4","v":0.82958418272192358},{"$f":"E6*F$5","v":41.366968125358049}]
[null,"GS Under 35 kW",{"$f":"'5.1'!I6","v":0.10330601475533711},9.5667439201311275,{"$f":"'5.3'!M5","v":9.0584206227626474E-2},4.5169544570923224]
[null,"MGS < 150 kW",{"$f":"'5.1'!I7","v":9.1043451869637124E-2},{"$f":"C8*D$5","v":8.4311585506845219},{"$f":"'5.3'!M6","v":2.468661188049668E-2},{"$f":"E8*F$5","v":1.2309905468941431}]
[null,"LGS > 150 kW",{"$f":"'5.1'!I8","v":0.25134961362518771},{"$f":"C9*D$5","v":23.276450975976143},{"$f":"'5.3'!M7","v":2.4508180018357466E-2},{"$f":"E9*F$5","v":1.2220930952462068}]
[null,"Irrigation",{"$f":"'5.1'!I9","v":4.3373814509853146E-3},{"$f":"C10*D$5","v":0.40166700577673325},{"$f":"'5.3'!M8","v":6.6015286874265161E-4},{"$f":"E10*F$5","v":3.2918326130013442E-2}]
[null,"Street Lighting",{"$f":"'5.1'!I10","v":7.1111886092741468E-3},{"$f":"C11*D$5","v":0.65853784558235973},{"$f":"'5.3'!M9","v":9.7650603874033185E-3},{"$f":"E11*F$5","v":0.48693182705402888}]
[null,"Transmission",{"$f":"'5.1'!I11","v":0},0,{"$f":"'5.3'!M10","v":2.0211605895449802E-2},1.0078457066238797]
[null,"Total",{"$f":"SUM(C6:C12)","v":1},{"$f":"SUM(D6:D12)","v":92.605875299597486},{"$f":"SUM(E6:E12)","v":0.99999999999999989},{"$f":"SUM(F6:F12)","v":49.864702084398651}]

{"sheet":"4.0","index":10,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,12],[19,1,19,2],[21,1,21,2],[22,1,22,2],[25,1,25,2],[20,1,20,2],[24,1,24,2],[14,1,14,2],[15,1,15,2],[23,1,23,2],[13,1,13,2],[18,1,18,2],[1,1,1,11],[13,3,13,5],[32,1,32,2],[26,1,26,2],[31,1,31,2],[27,1,27,2],[30,1,30,2],[28,1,28,3],[29,1,29,3]]}
[null,"Summary of Costs by Functions and Revenue to Cost Ratios"]
[]
[null,"Rate Class","Generation Costs","Transmission Costs","Distribution Costs","Customer Care Costs","Total Cost","Total Revenue","Revenue - Cost\n($ million)","Updated Rev/Cost Ratio","SQ\nRev/Cost Ratio","Δ from SQ\nRev/Cost Ratio","Δ from SQ\nis"]
[null,"Residential",{"$f":"'3.0'!D6+'3.0'!F6","v":1008.7951980407054},{"$f":"'3.1'!D6","v":355.7879477481664},{"$f":"'3.2'!D6+'3.2'!H6+'3.2'!N6+'3.2'!J6+'3.2'!F6+'3.2'!L6","v":633.18723843693783},{"$f":"+'3.3'!D6+'3.3'!F6","v":91.638285126804647},{"$f":"SUM(C4:F4)","v":2089.4086693526142},{"$f":"'5.3'!H4","v":1917.574679043111},{"$f":"H4-G4","v":-171.83399030950318},{"$f":"H4/G4","v":0.9177595111813408},0.9177595111813408,{"$f":"J4-K4","v":0},{"$f":"IF(K4=J4,\"\",(IF(K4<1,IF(L4>0,\"better\",\"worse\"),IF(L4<0,\"better\",\"worse\"))))","v":""}]
[null,"GS Under 35 kW",{"$f":"'3.0'!D7+'3.0'!F7","v":184.02606478803199},{"$f":"'3.1'!D7","v":54.795846804125816},{"$f":"'3.2'!D7+'3.2'!H7+'3.2'!N7+'3.2'!J7+'3.2'!F7+'3.2'!L7","v":94.726078321826932},{"$f":"+'3.3'!D7+'3.3'!F7","v":14.083698377223449},{"$f":"SUM(C5:F5)","v":347.63168829120821},{"$f":"'5.3'!H5","v":411.82191967382226},{"$f":"H5-G5","v":64.190231382614058},1.1846501154660056,1.1846501154660056,{"$f":"J5-K5","v":0},{"$f":"IF(K5=J5,\"\",(IF(K5<1,IF(L5>0,\"better\",\"worse\"),IF(L5<0,\"better\",\"worse\"))))","v":""}]
[null,"MGS < 150 kW",{"$f":"'3.0'!D8+'3.0'!F8","v":170.12066416202052},{"$f":"'3.1'!D8","v":50.800902710039082},{"$f":"'3.2'!D8+'3.2'!H8+'3.2'!N8+'3.2'!J8+'3.2'!F8+'3.2'!L8","v":59.576649371532021},{"$f":"+'3.3'!D8+'3.3'!F8","v":9.6621490975786646},290.16036534117029,{"$f":"'5.3'!H6","v":360.5034883785454},{"$f":"H6-G6","v":70.343123037375108},{"$f":"H6/G6","v":1.2424284342028096},1.2424284342028096,0,""]
[null,"LGS > 150 kW",{"$f":"'3.0'!D9+'3.0'!F9","v":528.4389645641844},{"$f":"'3.1'!D9","v":142.37258191881946},{"$f":"'3.2'!D9+'3.2'!H9+'3.2'!N9+'3.2'!J9+'3.2'!F9+'3.2'!L9","v":156.92043118818012},{"$f":"+'3.3'!D9+'3.3'!F9","v":24.498544071222351},852.23052174240638,{"$f":"'5.3'!H7","v":836.14371480900627},-16.086806933400112,{"$f":"H7/G7","v":0.98112387843079096},0.98112387843079096,0,""]
[null,"Irrigation",{"$f":"'3.0'!D10+'3.0'!F10","v":2.7819861346195234},{"$f":"'3.1'!D10","v":0},{"$f":"'3.2'!D10+'3.2'!H10+'3.2'!N10+'3.2'!J10+'3.2'!F10+'3.2'!L10","v":3.2826714179306644},{"$f":"+'3.3'!D10+'3.3'!F10","v":0.4345853319067467},6.4992428844569341,{"$f":"'5.3'!H8","v":6.0433443448030575},-0.45589853965387661,0.92985359252472821,0.92985359252472821,0,""]
[null,"Street Lighting",{"$f":"'3.0'!D11+'3.0'!F11","v":13.246138151695678},{"$f":"'3.1'!D11","v":5.252348985738208},{"$f":"'3.2'!D11+'3.2'!H11+'3.2'!N11+'3.2'!J11+'3.2'!F11+'3.2'!L11","v":10.706858313258897},{"$f":"+'3.3'!D11+'3.3'!F11","v":1.1454696726363887},30.35081512332917,{"$f":"'5.3'!H9","v":38.386580481572068},8.0357653582428981,1.2647627526835747,1.2647627526835747,0,""]
[null,"Transmission",{"$f":"'3.0'!D12+'3.0'!F12","v":685.91934298594151},{"$f":"'3.1'!D12","v":156.44367002517046},{"$f":"'3.2'!D12+'3.2'!H12+'3.2'!N12+'3.2'!J12+'3.2'!F12+'3.2'!L12","v":5.1059660174079223E-2},{"$f":"+'3.3'!D12+'3.3'!F12","v":1.0078457066238797},843.42191837791006,{"$f":"'5.3'!H10","v":889.31850891094678},45.896590533036715,1.0544171185654105,1.0544171185654105,0,""]
[null,"Total Classes",{"$f":"SUM(C4:C10)","v":2593.3283588271993},{"$f":"SUM(D4:D10)","v":765.45329819205949},{"$f":"SUM(E4:E10)","v":958.45098670984055},{"$f":"SUM(F4:F10)","v":142.4705773839961},{"$f":"ROUND(SUM(G4:G10),2)","v":4459.7},{"$f":"SUM(H4:H10)","v":4459.7922356418067},9.2235641806837521E-2,1.0000206820283442,1.0000206820283442]
[]
[null,"Preferred or Status Quo (SQ) Options"]
[null,"Functionalization",null,"Choose from dropdown menus:"]
[null,"IT costs",null,null,"SQ",null,"Preferred: IT costs changed from 100% Generation to functionalized total OMA"]
[null,"IPP Capital Leases",null,null,"SQ",null,"Preferred: Costs functionalized as 100% Generation"]
[null,"ERP Costs",null,null,"SQ",null,"Preferred: Energy & Resource Planning & Economic Development costs as 100% Generation"]
[null,"Corporate Tax & Depreciation",null,null,"SQ",null,"Preferred: Portion of corporate costs assigned to Transmission"]
[null,"DSM",null,null,"SQ",null,"Preferred: Functionalized as 90-5-5 Generation-Transmission-Distribution"]
[null,"Regulatory Accounts",null,null,"SQ",null,"Preferred: Functionalized by cost causation"]
[null,"Classification"]
[null,"IPP costs",null,null,"SQ",null,"Preferred: Energy 93%"]
[null,"Heritage Hydro",null,null,"SQ",null,"Preferred: Option 1B Load Factor. Also shows Capacity Factor (Option 3) & 50-50."]
[null,"Thermal OMA",null,null,"SQ",null,"Status Quo is Preferred - Minimal impact from alternative 100% demand for thermal"]
[null,"SMI",null,null,"SQ",null,"Preferred: Option 1 100% Customer Classification"]
[null,"Distribution",null,null,"SQ",null,"Preferred: Sub-functionalization and classification by sub-functions"]
[null,"Customer Care",null,null,"SQ",null,"Preferred: 100% Customer"]
[null,"Allocation"]
[null,"Energy: Single Year vs. 5-Year Average",null,null,"F16",null,"Preferred: F16"]
[null,"Demand: Single Year vs. 5-Year Average",null,null,"F13",null,"Preferred: 5-Year Average"]
[null,"Distribution Transformers",null,null,"SQ",null,"Preferred: Transformer direct assignment"]
[null,"Weighted Metering Allocators",null,null,"SQ",null,"Preferred: Metering allocator weighted by rate class meter cost"]

{"sheet":"4.1","index":11,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Summary of Costs by Classification"]
[]
[null,"Cost Classes  ","Energy Related Costs","Generation Demand Related Costs","Transmission Demand Related Costs","Distribution Demand Related Costs","Total Demand Related Costs","Customer Related Costs","Total"]
[null,"Residential",{"$f":"'3.0'!F6+'3.2'!J6","v":658.30868437169511},{"$f":"'3.0'!D6","v":350.48651366901021},{"$f":"'3.1'!D6","v":355.7879477481664},{"$f":"'3.2'!D6+'3.2'!F6*0.5+'3.3'!D6","v":386.83475197311071},{"$f":"SUM(D4:F4)","v":1093.1092133902873},{"$f":"+'3.2'!H6+'3.2'!N6+'3.2'!F6*0.5+'3.2'!L6+'3.3'!F6","v":337.99077159063171},{"$f":"C4+G4+H4","v":2089.4086693526142}]
[null,"GS Under 35 kW",{"$f":"'3.0'!F7+'3.2'!J7","v":130.0467059270257},{"$f":"'3.0'!D7","v":53.979358861006304},{"$f":"'3.1'!D7","v":54.795846804125816},{"$f":"'3.2'!D7+'3.2'!F7*0.5+'3.3'!D7","v":73.615517401855556},182.39072306698768,{"$f":"+'3.2'!H7+'3.2'!N7+'3.2'!F7*0.5+'3.2'!L7+'3.3'!F7","v":35.194259297194833},347.63168829120821]
[null,"MGS < 150 kW",{"$f":"'3.0'!F8+'3.2'!J8","v":120.07672255362485},{"$f":"'3.0'!D8","v":50.043941608395677},{"$f":"'3.1'!D8","v":50.800902710039082},{"$f":"'3.2'!D8+'3.2'!F8*0.5+'3.3'!D8","v":64.877256482183796},{"$f":"SUM(D6:F6)","v":165.72210080061853},{"$f":"+'3.2'!H8+'3.2'!N8+'3.2'!F8*0.5+'3.2'!L8+'3.3'!F8","v":4.3615419869268868},{"$f":"C6+G6+H6","v":290.16036534117029}]
[null,"LGS > 150 kW",{"$f":"'3.0'!F9+'3.2'!J9","v":388.18781161028352},{"$f":"'3.0'!D9","v":140.25115295390091},{"$f":"'3.1'!D9","v":142.37258191881946},{"$f":"'3.2'!D9+'3.2'!F9*0.5+'3.3'!D9","v":179.11088623054968},461.73462110327006,{"$f":"+'3.2'!H9+'3.2'!N9+'3.2'!F9*0.5+'3.2'!L9+'3.3'!F9","v":2.308089028852768},852.23052174240638]
[null,"Irrigation",{"$f":"'3.0'!F10+'3.2'!J10","v":2.7819861346195234},{"$f":"'3.0'!D10","v":0},{"$f":"'3.1'!D10","v":0},{"$f":"'3.2'!D10+'3.2'!F10*0.5+'3.3'!D10","v":3.0908033810006099},3.0908033810006099,{"$f":"+'3.2'!H10+'3.2'!N10+'3.2'!F10*0.5+'3.2'!L10+'3.3'!F10","v":0.62645336883680114},6.4992428844569341]
[null,"Street Lighting",{"$f":"'3.0'!F11+'3.2'!J11","v":8.0720520247328977},{"$f":"'3.0'!D11","v":5.1740861269627807},{"$f":"'3.1'!D11","v":5.252348985738208},{"$f":"'3.2'!D11+'3.2'!F11*0.5+'3.3'!D11","v":5.0674089989213575},15.493844111622348,{"$f":"+'3.2'!H11+'3.2'!N11+'3.2'!F11*0.5+'3.2'!L11+'3.3'!F11","v":6.7849189869739277},30.350815123329173]
[null,"Transmission",{"$f":"'3.0'!F12+'3.2'!J12","v":531.80676879745954},{"$f":"'3.0'!D12","v":154.11257418848194},{"$f":"'3.1'!D12","v":156.44367002517046},{"$f":"'3.2'!D12+'3.2'!F12*0.5+'3.3'!D12","v":0},310.55624421365241,{"$f":"+'3.2'!H12+'3.2'!N12+'3.2'!F12*0.5+'3.2'!L12+'3.3'!F12","v":1.0589053667979589},843.42191837790983]
[null,"Total Classes",{"$f":"SUM(C4:C10)","v":1839.2807314194411},754.04762740775789,765.45329819205949,712.59662446762172,2232.097550067439,388.32493962621487,{"$f":"SUM(I4:I10)","v":4459.7032211130954}]

{"sheet":"5.0","index":12,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,6],[0,1,0,8]]}
[null,"Energy Allocators"]
[]
[null,"F10 - F14","Energy @ Customer Meter","Distribution Loss Factor","Energy @ Transmission Interface","Transmission Loss Factor","Energy @ Generation Interface","Energy by Rate Class","Energy at Generator Allocation Factor",null,{"$f":"CONCATENATE(\"Selection from 4.0: \",'4.0'!E29)","v":"Selection from 4.0: F16"}]
[null,null,"(MWh)",null,"(MWh)",null,"(MWh)"]
[null,"Residential",17890814.567800004,0.06,{"$f":"C5*(1+D5)","v":18964263.441868003},0.06,{"$f":"E5*(1+F5)","v":20102119.248380084},{"$f":"G5","v":20102119.248380084},{"$f":"H5/H$16","v":0.35945712735497792},null,{"$f":"IF('4.0'!$E$29=\"F16\",I20,IF('4.0'!$E$29=\"F13\",I35,I5))","v":0.3579163708541947}]
[null,"GS Under 35 kW",3918567.3706,{"$f":"D5","v":0.06},{"$f":"C6*(1+D6)","v":4153681.4128360003},{"$f":"F5","v":0.06},{"$f":"E6*(1+F6)","v":4402902.2976061609},{"$f":"G6","v":4402902.2976061609},{"$f":"H6/H$16","v":7.8730734424912935E-2},null,{"$f":"IF('4.0'!$E$29=\"F16\",I21,IF('4.0'!$E$29=\"F13\",I36,I6))","v":7.0705196713860996E-2}]
[null,"MGS < 150 kW Primary",96180.294236770162,3.44E-2,99488.896358515049,0.06,105458.23014002596]
[null,"MGS < 150 kW Secondary",3447436.4760065614,{"$f":"D6","v":0.06},3654282.6645669551,0.06,3873539.6244409727]
[null,"MGS",null,null,null,null,null,{"$f":"+G7+G8","v":3978997.8545809984},{"$f":"H9/H$16","v":7.115066430991171E-2},null,{"$f":"IF('4.0'!$E$29=\"F16\",I24,IF('4.0'!$E$29=\"F13\",I39,I9))","v":6.528460854420913E-2}]
[null,"LGS > 150 kW Primary",6981482.5575607326,{"$f":"D7","v":3.44E-2},7221645.5575408218,{"$f":"F8","v":0.06},7654944.2909932714]
[null,"LGS > 150 kW Secondary",3707421.9704841459,{"$f":"D8","v":0.06},3929867.2887131949,0.06,4165659.3260359867]
[null,"LGS",null,null,null,null,null,{"$f":"G10+G11","v":11820603.617029257},{"$f":"H12/H$16","v":0.21137075983277739},null,{"$f":"IF('4.0'!$E$29=\"F16\",I27,IF('4.0'!$E$29=\"F13\",I42,I12))","v":0.21105413925078456}]
[null,"Irrigation",73801.379904000059,{"$f":"D5","v":0.06},78229.462698240066,{"$f":"F8","v":0.06},82923.23046013448,{"$f":"G13","v":82923.23046013448},{"$f":"H13/H$16","v":1.4827962088920924E-3},null,{"$f":"IF('4.0'!$E$29=\"F16\",I28,IF('4.0'!$E$29=\"F13\",I43,I13))","v":1.5125402485310451E-3}]
[null,"Street Lighting",224721.56066399984,{"$f":"D5","v":0.06},238204.85430383985,0.06,252497.14556207025,{"$f":"G14","v":252497.14556207025},{"$f":"H14/H$16","v":4.5150412992594037E-3},null,{"$f":"IF('4.0'!$E$29=\"F16\",I29,IF('4.0'!$E$29=\"F13\",I44,I14))","v":4.3887003690314293E-3}]
[null,"Transmission",14418404.070000008,0,14418404.070000008,0.06,15283508.314200008,{"$f":"G15","v":15283508.314200008},{"$f":"H15/H$16","v":0.27329287656926859},null,{"$f":"IF('4.0'!$E$29=\"F16\",I30,IF('4.0'!$E$29=\"F13\",I45,I15))","v":0.28913844401938826}]
[null,"Total",{"$f":"SUM(C5:C15)","v":50758830.247256219},null,{"$f":"SUM(E5:E15)","v":52758067.648885578},null,{"$f":"SUM(G5:G15)","v":55923551.707818709},{"$f":"SUM(H5:H15)","v":55923551.707818709},{"$f":"SUM(I5:I15)","v":1}]
[null,null,null,null,null,null,{"$f":"G16/C16-1","v":0.10175020652375388}]
[null,"F16","Energy @ Customer Meter","Distribution Loss Factor","Energy @ Transmission Interface","Transmission Loss Factor","Energy @ Generation Interface","Energy by Rate Class","Energy at Generator Allocation Factor"]
[null,null,"(MWh)",null,"(MWh)",null,"(MWh)"]
[null,"Residential",18742647,0.06,{"$f":"C20*(1+D20)","v":19867205.82},0.06,{"$f":"E20*(1+F20)","v":21059238.169200003},{"$f":"G20","v":21059238.169200003},{"$f":"H20/H$31","v":0.3579163708541947}]
[null,"GS Under 35 kW",3702548,{"$f":"D20","v":0.06},{"$f":"C21*(1+D21)","v":3924700.8800000004},{"$f":"F20","v":0.06},{"$f":"E21*(1+F21)","v":4160182.9328000005},{"$f":"G21","v":4160182.9328000005},{"$f":"H21/H$31","v":7.0705196713860996E-2}]
[null,"MGS < 150 kW Primary",87191.406879865375,3.44E-2,90190.791276532749,0.06,95602.238753124722]
[null,"MGS < 150 kW Secondary",3333607.8531453824,{"$f":"D21","v":0.06},3533624.3243341055,0.06,3745641.7837941521]
[null,"MGS",null,null,null,null,null,{"$f":"+G22+G23","v":3841244.0225472767},{"$f":"H24/H$31","v":6.528460854420913E-2}]
[null,"LGS > 150 kW Primary",7118064.0881548505,{"$f":"D22","v":3.44E-2},{"$f":"C25*(1+D25)","v":7362925.492787377},{"$f":"F23","v":0.06},{"$f":"E25*(1+F25)","v":7804701.0223546196}]
[null,"LGS > 150 kW Secondary",4105903.9423521995,{"$f":"D23","v":0.06},4352258.1788933314,0.06,4613393.6696269317]
[null,"LGS",null,null,null,null,null,{"$f":"G25+G26","v":12418094.69198155},{"$f":"H27/H$31","v":0.21105413925078456}]
[null,"Irrigation",79205.675571230735,{"$f":"D20","v":0.06},{"$f":"C28*(1+D28)","v":83958.01610550459},{"$f":"F23","v":0.06},{"$f":"E28*(1+F28)","v":88995.497071834863},{"$f":"G28","v":88995.497071834863},1.5125402485310451E-3]
[null,"Street Lighting",229818.66297206783,{"$f":"D20","v":0.06},243607.78275039193,0.06,258224.24971541544,{"$f":"G29","v":258224.24971541544},4.3887003690314293E-3]
[null,"Transmission",16049483.749788677,0,16049483.749788677,0.06,17012452.774776001,{"$f":"G30","v":17012452.774776001},0.28913844401938826]
[null,"Total",{"$f":"SUM(C20:C30)","v":53448470.378864281},null,{"$f":"SUM(E20:E30)","v":55507955.035935923},null,{"$f":"SUM(G20:G30)","v":58838432.338092089},{"$f":"SUM(H20:H30)","v":58838432.338092074},{"$f":"SUM(I20:I30)","v":1}]
[]
[null,"F13","Energy @ Customer Meter","Distribution Loss Factor","Energy @ Transmission Interface","Transmission Loss Factor","Energy @ Generation Interface","Energy by Rate Class","Energy at Generator Allocation Factor"]
[null,null,"(MWh)",null,"(MWh)",null,"(MWh)"]
[null,"Residential",17703115.010000002,0.06,{"$f":"C35*(1+D35)","v":18765301.910600003},0.06,{"$f":"E35*(1+F35)","v":19891220.025236003},{"$f":"G35","v":19891220.025236003},{"$f":"H35/H$46","v":0.35620777353577299}]
[null,"GS Under 35 kW",3922246.7209999999,{"$f":"D35","v":0.06},{"$f":"C36*(1+D36)","v":4157581.5242600003},{"$f":"F35","v":0.06},{"$f":"E36*(1+F36)","v":4407036.4157156004},{"$f":"G36","v":4407036.4157156004},{"$f":"H36/H$46","v":7.8920278773322847E-2}]
[null,"MGS < 150 kW Primary",93814.765045597262,3.44E-2,97041.992963165801,0.06,102864.51254095575]
[null,"MGS < 150 kW Secondary",3442589.3883530386,{"$f":"D36","v":0.06},3649144.7516542212,0.06,3868093.4367534746]
[null,"MGS",null,null,null,null,null,{"$f":"+G37+G38","v":3970957.9492944302},{"$f":"H39/H$46","v":7.1111077557223165E-2}]
[null,"LGS > 150 kW Primary",7013179.5911951149,{"$f":"D37","v":3.44E-2},{"$f":"C40*(1+D40)","v":7254432.9691322269},{"$f":"F38","v":0.06},{"$f":"E40*(1+F40)","v":7689698.9472801611}]
[null,"LGS > 150 kW Secondary",3911671.9948472939,{"$f":"D38","v":0.06},4146372.3145381319,0.06,4395154.6534104198]
[null,"LGS",null,null,null,null,null,{"$f":"G40+G41","v":12084853.600690581},{"$f":"H42/H$46","v":0.21641300981771663}]
[null,"Irrigation",69777.823999999993,{"$f":"D35","v":0.06},{"$f":"C43*(1+D43)","v":73964.493439999991},{"$f":"F38","v":0.06},{"$f":"E43*(1+F43)","v":78402.363046400002},{"$f":"G43","v":78402.363046400002},{"$f":"H43/H$46","v":1.4040129838828303E-3}]
[null,"Street Lighting",222179.83499999999,{"$f":"D35","v":0.06},235510.6251,0.06,249641.262606,{"$f":"G44","v":249641.262606},{"$f":"H44/H$46","v":4.4705230862020703E-3}]
[null,"Transmission",14301425.372,0,14301425.372,0.06,15159510.89432,{"$f":"G45","v":15159510.89432},{"$f":"H45/H$46","v":0.27147332424587933}]
[null,"Total",{"$f":"SUM(C35:C45)","v":50680000.501441047},null,{"$f":"SUM(E35:E45)","v":52680775.95368775},null,{"$f":"SUM(G35:G45)","v":55841622.510909021},{"$f":"SUM(H35:H45)","v":55841622.510909021},{"$f":"SUM(I35:I45)","v":0.99999999999999989}]

{"sheet":"5.1","index":13,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,7,2,8],[0,1,0,3],[1,1,1,3],[2,2,2,3],[2,4,2,5]]}
[null,"Demand Allocators"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Selection from Schedule 4.0: \",IF('4.0'!E30=\"F13\",E3,C3))","v":"Selection from Schedule 4.0: F13"}]
[null,null,"F10-F14 Average",null,"F13"]
[null,"Rate Classes","4 CP","NCP w/o T","4 CP","NCP w/o T",null,"4 CP","NCP w/o T"]
[null,"Residential",0.45850773497942077,0.56608235702623477,0.46480686488451955,0.54285234968957863,null,{"$f":"IF('4.0'!$E$30=\"F13\",E5,C5)","v":0.46480686488451955},{"$f":"IF('4.0'!$E$30=\"F13\",F5,D5)","v":0.54285234968957863}]
[null,"GS Under 35 kW",7.2192327042338938E-2,0.10619451353638544,7.1586139786123215E-2,0.10330601475533711,null,{"$f":"IF('4.0'!$E$30=\"F13\",E6,C6)","v":7.1586139786123215E-2},{"$f":"IF('4.0'!$E$30=\"F13\",F6,D6)","v":0.10330601475533711}]
[null,"MGS < 150 kW",6.4432448033137038E-2,8.5573453790648318E-2,6.6367083178068248E-2,9.1043451869637124E-2,null,{"$f":"IF('4.0'!$E$30=\"F13\",E7,C7)","v":6.6367083178068248E-2},{"$f":"IF('4.0'!$E$30=\"F13\",F7,D7)","v":9.1043451869637124E-2}]
[null,"LGS > 150 kW",0.18416455441602916,0.23115194869780725,0.18599773788301954,0.25134961362518771,null,{"$f":"IF('4.0'!$E$30=\"F13\",E8,C8)","v":0.18599773788301954},{"$f":"IF('4.0'!$E$30=\"F13\",F8,D8)","v":0.25134961362518771}]
[null,"Irrigation",0,4.3031701434375156E-3,0,4.3373814509853146E-3,null,{"$f":"IF('4.0'!$E$30=\"F13\",E9,C9)","v":0},{"$f":"IF('4.0'!$E$30=\"F13\",F9,D9)","v":4.3373814509853146E-3}]
[null,"Street Lighting",5.9311285521252725E-3,6.6945568054863572E-3,6.8617497607546332E-3,7.1111886092741468E-3,null,{"$f":"IF('4.0'!$E$30=\"F13\",E10,C10)","v":6.8617497607546332E-3},{"$f":"IF('4.0'!$E$30=\"F13\",F10,D10)","v":7.1111886092741468E-3}]
[null,"Transmission",0.21477180697694878,0,0.20438042450751487,0,null,{"$f":"IF('4.0'!$E$30=\"F13\",E11,C11)","v":0.20438042450751487},{"$f":"IF('4.0'!$E$30=\"F13\",F11,D11)","v":0}]
[null,"Total Integrated Area",{"$f":"SUM(C5:C11)","v":1},{"$f":"SUM(D5:D11)","v":0.99999999999999956},{"$f":"SUM(E5:E11)","v":1},{"$f":"SUM(F5:F11)","v":1}]

{"sheet":"5.2","index":14,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Distribution Customer Allocators"]
[]
[null,"Rate Class","Distribution Customer Count","Distribution Customer Allocator","Distribution Meter Weighting","Distribution Metering Allocator"]
[null,"Residential",1766044.5828666219,{"$f":"C4/C$11","v":0.88851773772964338},1,{"$f":"(D4*E4)/$E$11","v":0.77152402134303388}]
[null,"GS Under 35 kW",182647.13551943144,9.1891915543324196E-2,2,{"$f":"(D5*E5)/$E$11","v":0.15958447918002575}]
[null,"MGS < 150 kW",18638.738184416761,9.3773677326263946E-3,6,4.8855734593492621E-2]
[null,"LGS > 150 kW",6465.823757753752,3.253031748764085E-3,6,1.6948173546491679E-2]
[null,"Irrigation",3533.8005064605254,1.7778964710458312E-3,2,3.0875913369559404E-3]
[null,"Street Lighting",9996,5.0291048099867187E-3,0,0]
[null,"Transmission",304,1.5294596460944002E-4,0,0]
[null,"Total",{"$f":"SUM(C4:C10)","v":1987630.0808346842},{"$f":"SUM(D4:D10)","v":1.0000000000000002},{"$f":"D4*E4+D5*E5+D6*E6+D7*E7+D8*E8+D9*E9+D10*E10","v":1.1516397586467264},{"$f":"SUM(F4:F10)","v":0.99999999999999978}]

{"sheet":"5.3","index":15,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,12]]}
[null,"Customer Care Allocators"]
[]
[null,"Rate Class","Number of Accounts","Annual bills per account ","Annual bills per rate class","# of Bills Allocator",null,"Revenue ($millions)","Revenue Allocator",null,"90% # of Bills Allocator","10% Revenue Allocator","Blended Customer Care Allocator"]
[null,"Residential",{"$f":"'5.2'!C4","v":1766044.5828666219},6,{"$f":"D4*C4","v":10596267.497199731},{"$f":"E4/E$11","v":0.87398581310452272},null,1917.574679043111,{"$f":"H4/H$11","v":0.42996950927853117},null,{"$f":"F4*LEFT(K$3,3)","v":0.78658723179407042},{"$f":"I4*LEFT(L$3,3)","v":4.299695092785312E-2},{"$f":"SUM(K4:L4)","v":0.82958418272192358}]
[null,"GS Under 35 kW",{"$f":"'5.2'!C5","v":182647.13551943144},6,1095882.8131165886,9.0389000819589255E-2,null,411.82191967382226,{"$f":"H5/H$11","v":9.2341054899961542E-2},null,{"$f":"F5*LEFT(K$3,3)","v":8.1350100737630326E-2},{"$f":"I5*LEFT(L$3,3)","v":9.2341054899961542E-3},9.0584206227626474E-2]
[null,"MGS < 150 kW",{"$f":"'5.2'!C6","v":18638.738184416761},12,223664.85821300113,1.8447997185788007E-2,null,360.5034883785454,8.0834144132874722E-2,null,1.6603197467209205E-2,8.0834144132874725E-3,{"$f":"SUM(K6:L6)","v":2.468661188049668E-2}]
[null,"LGS > 150 kW",{"$f":"'5.2'!C7","v":6465.823757753752},12,77589.885093045028,6.3996552398901032E-3,null,836.14371480900627,0.18748490302456369,null,5.7596897159010929E-3,1.8748490302456372E-2,{"$f":"SUM(K7:L7)","v":2.4508180018357466E-2}]
[null,"Irrigation",{"$f":"'5.2'!C8","v":3533.8005064605254},2,7067.6010129210508,5.8293951333415663E-4,null,6.0433443448030575,1.3550730674191066E-3,null,5.2464556200074099E-4,1.3550730674191067E-4,{"$f":"SUM(K8:L8)","v":6.6015286874265161E-4}]
[null,"Street Lighting",{"$f":"'5.2'!C9","v":9996},12,119952,9.8937051448747156E-3,null,38.386580481572068,8.6072575701607486E-3,null,8.904334630387244E-3,8.6072575701607494E-4,9.7650603874033185E-3]
[null,"Transmission",{"$f":"'5.2'!C10","v":304},12,3648,3.0088899200099174E-4,null,889.31850891094678,0.19940805802648906,null,2.7080009280089259E-4,1.9940805802648908E-2,2.0211605895449802E-2]
[null,"Total",{"$f":"SUM(C4:C10)","v":1987630.0808346842},null,{"$f":"SUM(E4:E10)","v":12124072.654635288},{"$f":"SUM(F4:F10)","v":0.99999999999999989},null,{"$f":"SUM(H4:H10)","v":4459.7922356418067},{"$f":"SUM(I4:I10)","v":1},null,null,null,{"$f":"SUM(M4:M10)","v":0.99999999999999989}]

{"sheet":"5.4","index":16,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"Distribution Transformer Allocators"]
[]
[null,"Rate Class","OH Transformers","UG Transformers","Weighted Allocator"]
[null,"Residential",{"$f":"515066294/713863409","v":0.7215193936351485},{"$f":"272085224.591667/487693627","v":0.55790194812545091},{"$f":"C4*$C$11+D4*$D$11","v":0.65510957450018792}]
[null,"GS Under 35 kW",{"$f":"121555362/713863409","v":0.17027817992559413},{"$f":"80344521.3033332/487693627","v":0.16474384091825173},{"$f":"C5*$C$11+D5*$D$11","v":0.16803187635225431}]
[null,"MGS < 150 kW",{"$f":"49271631/713863409","v":6.9021090559916898E-2},{"$f":"79828617.1553334/487693627","v":0.16368599615785712},0.10744412814984622]
[null,"LGS > 150 kW",{"$f":"11831802/713863409","v":1.6574321993298859E-2},{"$f":"53117672.875/487693627","v":0.10891606929897404},5.405442515755865E-2]
[null,"Irrigation",{"$f":"6082680/713863409","v":8.5207897243546778E-3},{"$f":"357660.35/487693627","v":7.3337097349439014E-4},5.3599955366579874E-3]
[null,"Street Lighting",{"$f":"10055640/713863409","v":1.4086224161686931E-2},{"$f":"1959931/487693627","v":4.0187750905344511E-3},1.0000000532642214E-2]
[null,"Transmission",null,null,0]
[null,"Total",{"$f":"713863409/(713863409+487693627)","v":0.59411529175215949},{"$f":"487693627/(713863409+487693627)","v":0.40588470824784051},{"$f":"SUM(E4:E10)","v":1.0000000002291471}]
[]
[null,"* Based on replacement costs"]

{"sheet":"6.0","index":17,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,10]]}
[null,"Distribution Classification by Sub-Functionalization"]
[]
[null,"Sub-Function","F14 Year-End Assets","% of assets  (excluding Substation)","% of assets without Streetlighting","Demand-related %","Customer-related %","Demand % of Total Costs","Customer % of Total Costs","% of total Demand costs","% of total Customer costs"]
[null,"Primary",2176.2307785385356,{"$f":"C4/($C$10-$C$8)","v":0.55234283719252175},{"$f":"ROUND(D4/SUM($D$4:$D$7),10)","v":0.55557757090000004},1,{"$f":"1-F4","v":0},{"$f":"E4*F4","v":0.55557757090000004},{"$f":"E4*G4","v":0},{"$f":"H4/$H$10","v":0.77788037786849451},{"$f":"I4/$I$10","v":0}]
[null,"Secondary/Services",576.06393868078032,{"$f":"C5/($C$10-$C$8)","v":0.14620912149258383},{"$f":"ROUND(D5/SUM($D$4:$D$7),10)","v":0.14706537880000001},0.5,{"$f":"1-F5","v":0.5},{"$f":"E5*F5","v":7.3532689400000004E-2},{"$f":"E5*G5","v":7.3532689400000004E-2},{"$f":"H5/$H$10","v":0.10295526531695456},{"$f":"I5/$I$10","v":0.25730505600070952}]
[null,"Meters",498.00705297832388,{"$f":"C6/($C$10-$C$8)","v":0.1263977291823157},{"$f":"ROUND(D6/SUM($D$4:$D$7),10)","v":0.12713796329999999},0,1,{"$f":"E6*F6","v":0},0.12713796329999999,{"$f":"H6/$H$10","v":0},{"$f":"I6/$I$10","v":0.44488024351687383}]
[null,"Transformers",666.75840753197656,{"$f":"C7/($C$10-$C$8)","v":0.1692280222162377},{"$f":"ROUND(D7/SUM($D$4:$D$7),10)","v":0.1702190871},0.5,0.5,{"$f":"E7*F7","v":8.510954355E-2},8.510954355E-2,{"$f":"H7/$H$10","v":0.11916435681455095},{"$f":"I7/$I$10","v":0.29781470048241665}]
[null,"Substation",629.5]
[null,"Streetlighting",22.939822270383729,{"$f":"C9/($C$10-$C$8)","v":5.8222899163410478E-3}]
[null,"Total",{"$f":"SUM(C4:C9)","v":4569.5},{"$f":"SUM(D4:D9)","v":1},{"$f":"SUM(E4:E9)","v":1.0000000001},null,null,{"$f":"SUM(H4:H7)","v":0.71421980385000006},{"$f":"SUM(I4:I7)","v":0.28578019625000001},{"$f":"SUM(J4:J7)","v":1},{"$f":"SUM(K4:K7)","v":1}]

{"sheet":"6.1","index":18,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,3,3,4],[3,5,3,6],[0,1,0,6],[1,1,1,6]]}
[null,"Rate Base"]
[null,"(re-calculated with DSM 90-5-5 alternative)"]
[]
[null,"Function",null,"SQ",null,"Preferred"]
[null,"Generation","Mid-Year Net Assets",{"$f":"'RRA 10.0'!G12-D6","v":6500.2088902989999},{"$f":"SUM(D5:D6)/SUM($D$5:$D$10)","v":0.42273586353641213},{"$f":"D5","v":6500.2088902989999},{"$f":"SUM(F5:F6)/SUM($F$5:$F$10)","v":0.42273586353641213}]
[null,null,"90% of DSM",{"$f":"'RRA 10.0'!G10","v":851.01539858399997},null,{"$f":"D6","v":851.01539858399997}]
[null,"Transmission","Mid-Year Net Assets",{"$f":"'RRA 10.0'!$G$19-D8","v":5482.0554878109988},{"$f":"SUM(D7:D8)/SUM($D$5:$D$10)","v":0.32068593144013313},{"$f":"D7","v":5482.0554878109988},{"$f":"SUM(F7:F8)/SUM($F$5:$F$10)","v":0.3179671497691729}]
[null,null,"% DSM",{"$f":"'RRA 10.0'!$G$17","v":94.557266509333331},null,{"$f":"D8/2","v":47.278633254666666}]
[null,"Distribution","Mid-Year Net Assets",{"$f":"'RRA 10.0'!$G$25-D10","v":4461.8024999999998},{"$f":"SUM(D9:D10)/SUM($D$5:$D$10)","v":0.25657820502345474},{"$f":"D9","v":4461.8024999999998},{"$f":"SUM(F9:F10)/SUM($F$5:$F$10)","v":0.25929698669441498}]
[null,null,"% DSM",0,null,{"$f":"F8","v":47.278633254666666}]
[null,"Corporate","Mid-Year Net Assets",{"$f":"'RRA 10.0'!$G$37","v":776.33749999999998},null,{"$f":"D11","v":776.33749999999998}]

{"sheet":"RRA 1.0","index":19,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Revenue Requirements Summary"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[1,null,"Cost of Energy",null,"3.0 L14",null,1391.6999999999998]
[null,null,null,null,null,null," "]
[{"$f":"A7+1","v":2},null,"Operating Costs",null,"3.0 L20",null,1146.6158990065233]
[]
[{"$f":"A9+1","v":3},null,"Taxes",null,"3.0 L24",null,224.13055555379046]
[]
[{"$f":"A11+1","v":4},null,"Amortization",null,"3.0 L28",null,758.00200000000007]
[]
[{"$f":"A13+1","v":5},null,"Finance Charges",null,"3.0 L33",null,838.3282225574651]
[]
[{"$f":"A15+1","v":6},null,"Return on Equity",null,"3.0 L37",null,651.85107129458243]
[]
[{"$f":"A17+1","v":7},null,"Non-Tariff Revenue",null,"3.0 L41",null,-126.62466333937094]
[]
[{"$f":"A19+1","v":8},null,"Inter-Segment Revenue",null,"3.0 L47",null,-53.510359036389922]
[]
[null,null,"Deferral Accounts"]
[{"$f":"A21+1","v":9},null,null,"Deferral Account Additions","2.1 L33",null,0]
[{"$f":"A24+1","v":10},null,null,"Interest on Deferral Accounts","2.1 L34",null,-23.794683373174841]
[{"$f":"A25+1","v":11},null,null,"Deferral Account Recoveries","2.1 L35",null,222.99174682993481]
[{"$f":"A26+1","v":12},null,null,"Total",null,null,199.19706345675996]
[]
[null,null,"Other Regulatory Accounts"]
[{"$f":"A27+1","v":13},null,null,"Regulatory Account Additions","2.2 L212",null,-310.28880000000004]
[{"$f":"A30+1","v":14},null,null,"Interest on Regulatory Accounts","2.2 L213",null,-37.944519165489261]
[{"$f":"A31+1","v":15},null,null,"Regulatory Account Recoveries","2.2 L214",null,132.85682538930655]
[{"$f":"A32+1","v":16},null,null,"Total",null,null,-215.37649377618277]
[]
[null,null,"Subsidiary Net Income"]
[{"$f":"A33+1","v":17},null,null,"Powerex Net Income",null,null,-110]
[{"$f":"A36+1","v":18},null,null,"Powertech Net Income",null,null,-5.12]
[{"$f":"A37+1","v":19},null,null,"Total",null,null,-115.12]
[]
[{"$f":"A38+1","v":20},null,"Less Other Utilities Revenue",null,"14.0 L17",null,-16.499916335699446]
[{"$f":"A40+1","v":21},null,"Less Deferral Rider",null,"14.0 L21",null,-222.99174682993481]
[]
[{"$f":"A41+1","v":22},null,"Total Rate Revenue Requirement",null,null,null,4459.7016325515424]
[]
[null,null,"Rate Revenue at Current Rates"]
[{"$f":"A43+1","v":23},null,null,"Total Domestic Revenue","14.0 L22",null,4099.4838187816067]
[{"$f":"A46+1","v":24},null,null,"Less Other Utilities","Line 20",null,-16.499916335699446]
[{"$f":"A47+1","v":25},null,null,"Less Deferral Rider","Line 21",null,-222.99174682993481]
[{"$f":"A48+1","v":26},null,null,"Revenue Subject to Rate Increase",null,null,3859.9921556159725]
[]
[{"$f":"+A49+1","v":27},null,"Revenue Shortfall",null,"Line 22 - 26",null,599.70947693556991]
[]
[{"$f":"A51+1","v":28},null,"Rate Increases (May 1 for F2012)",null,null,null,0.06]
[]
[{"$f":"A53+1","v":29},null,"Deferral Account Rate Rider",null,null,null,0.05]
[{"$f":"A55+1","v":30},null,"Net Bill Impact",null,null,null,6.0000000000000053E-2]

{"sheet":"RRA 2.1","index":20,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["Deferral Accounts"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Heritage Deferral Account"]
[1,null,null,"Beginning of Year",null,null,51.213906632141303]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[3,null,null,"Additions","Line 41",null,0]
[4,null,null,"Interest",null,null,1.8931075390026884]
[5,null,null,"Recovery",null,null,-17.741247086104963]
[6,null,null,"Transfer of GM Shrum 3","2.2 L67",null,0]
[7,null,null,"End of Year",null,null,35.365767085039025]
[]
[null,null,"Non-Heritage Deferral Account"]
[{"$f":"A14+1","v":8},null,null,"Beginning of Year",null,null,302.5900811684225]
[{"$f":"A17+1","v":9},null,null,"Adjustment to Opening Balance",null,null,0]
[10,null,null,"Additions","Line 42",null,0]
[11,null,null,"Interest",null,null,11.185156563078328]
[12,null,null,"Recovery",null,null,-104.82163437312234]
[13,null,null,"Transfer of Storm Restoration","2.2 L47",null,0]
[14,null,null,"Transfer from BCTCDA",null,null,0]
[15,null,null,"End of Year",null,null,208.95360335837853]
[]
[null,null,"Trade Income Deferral Account"]
[{"$f":"A24+1","v":16},null,null,"Beginning of Year",null,null,289.90941331827827]
[{"$f":"A27+1","v":17},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A28+1","v":18},null,null,"Additions","Line 43",null,0]
[{"$f":"A29+1","v":19},null,null,"Interest",null,null,10.716419271093825]
[{"$f":"A30+1","v":20},null,null,"Recovery",null,null,-100.42886537070751]
[{"$f":"A31+1","v":21},null,null,"End of Year",null,null,200.19696721866455]
[]
[null,null,"BCTC Deferral Account"]
[{"$f":"A32+1","v":22},null,null,"Beginning of Year",null,null,0]
[{"$f":"A35+1","v":23},null,null,"Additions",null,null,0]
[{"$f":"A36+1","v":24},null,null,"Interest",null,null,0]
[{"$f":"A37+1","v":25},null,null,"Recovery",null,null,0]
[{"$f":"A38+1","v":26},null,null,"Transfer to NHDA",null,null,0]
[{"$f":"A39+1","v":27},null,null,"End of Year",null,null,0]
[]
[null,null,"End of Year Balances"]
[{"$f":"A40+1","v":28},null,null,"Heritage","Line 7",null,35.365767085039025]
[{"$f":"A43+1","v":29},null,null,"Non-Heritage","Line 15",null,208.95360335837853]
[{"$f":"A44+1","v":30},null,null,"Trade Income","Line 21",null,200.19696721866455]
[{"$f":"A45+1","v":31},null,null,"BCTC","Line 27",null,0]
[{"$f":"A46+1","v":32},null,null,"Total",null,null,444.51633766208209]
[]
[null,null,"Summary"]
[{"$f":"A47+1","v":33},null,null,"Deferral Account Additions",null,null,0]
[{"$f":"A50+1","v":34},null,null,"Interest on Deferral Accounts",null,null,23.794683373174841]
[35,null,null,"Deferral Account Recoveries",null,null,-222.99174682993481]
[36,null,null,"Transfer of GM Shrum 3","Line 6",null,0]
[37,null,null,"Transfer of Storm Restoration","Line 13",null,0]
[38,null,null,"Adjustment to Opening Balance","Line 2",null,0]
[39,null,null,"Deferral Account Net Transfers",null,null,-199.19706345675996]
[]
[{"$f":"A56+1","v":40},null,"Interest Rate",null,"8.0 L104",null,4.4708567708830096E-2]
[]
[null,"Summary of Items Subject to Deferral"]
[{"$f":"A58+1","v":41},null,"Heritage Payment Obligation",null,"4.0 L75",null,399.21871863469147]
[{"$f":"A61+1","v":42},null,"Cost of Non-Heritage Energy",null,"4.0 L88",null,1032.1999999999998]
[{"$f":"A62+1","v":43},null,"Trade Income",null,"1.0 L17",null,110]

{"sheet":"RRA 2.2","index":21,"n_rows":292,"n_cols":7,"rows_kept":292,"cut":false,"hidden":false,"merged":[]}
["Other Regulatory Accounts"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Demand-Side Management"]
[{"$f":"1","v":1},null,null,"Beginning of Year",null,null,897.7824213133332]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[3,null,null,"Additions","5.0 L49",null,131.1]
[4,null,null,"F11 RRA NSA Adjustment","5.0 L9",null,0]
[5,null,null,"Amortization on Existing",null,null,-73.276422886666666]
[6,null,null,"Amortization on Additions","13.0 L72",null,-10.033333333333333]
[7,null,null,"End of Year",null,null,945.57266509333328]
[]
[null,null,"First Nations Costs"]
[{"$f":"A14+1","v":8},null,null,"Beginning of Year",null,null,174.15036185182103]
[{"$f":"A17+1","v":9},null,null,"Adjustment to Opening Balance",null,null,0]
[10,null,null,"Additions","5.0 L50",null,2.9809999999999999]
[11,null,null,"Transfer from Provision","Line 18",null,13.677778524551213]
[12,null,null,"Interest",null,null,7.1922866742465859]
[13,null,null,"Recovery","5.0 L28",null,-43.218634970390966]
[14,null,null,"End of Year",null,null,154.78279208022786]
[]
[null,null,"First Nations Settlement Provisions"]
[{"$f":"A23+1","v":15},null,null,"Beginning of Year",null,null,401.43245430708504]
[{"$f":"A26+1","v":16},null,null,"Additions - Operating","5.0 L84",null,0]
[{"$f":"A27+1","v":17},null,null,"Additions - Accretion","8.0 L76",null,17.7]
[{"$f":"A28+1","v":18},null,null,"Transfer to Negotiation Costs",null,null,-13.677778524551213]
[{"$f":"A29+1","v":19},null,null,"End of Year",null,null,405.4546757825338]
[]
[null,null,"F07/F08 RRA Depreciation Study"]
[{"$f":"A30+1","v":20},null,null,"Beginning of Year",null,null,0]
[{"$f":"A33+1","v":21},null,null,"Additions","7.0 L27",null,0]
[{"$f":"A34+1","v":22},null,null,"Recovery","7.0 L43",null,0]
[{"$f":"A35+1","v":23},null,null,"End of Year",null,null,0]
[]
[null,null,"Site C"]
[{"$f":"A36+1","v":24},null,null,"Beginning of Year",null,null,376.85575216976434]
[{"$f":"A39+1","v":25},null,null,"Additions","5.0 L51",null,0]
[{"$f":"A40+1","v":26},null,null,"Interest",null,null,16.848680912344005]
[{"$f":"A41+1","v":27},null,null,"Recovery","5.0 L29",null,0]
[{"$f":"A42+1","v":28},null,null,"End of Year",null,null,393.70443308210832]
[]
[null,null,"Future Removal and Site Restoration"]
[{"$f":"A43+1","v":29},null,null,"Beginning of Year",null,null,-41.091925880000034]
[{"$f":"A46+1","v":30},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A47+1","v":31},null,null,"Additions","N/A",null,0]
[{"$f":"A48+1","v":32},null,null,"Recovery","7.0 L50",null,31.170999999999999]
[{"$f":"A49+1","v":33},null,null,"End of Year",null,null,-9.9209258800000342]
[]
[null,null,"Foreign Exchange Gains/Losses"]
[{"$f":"A50+1","v":34},null,null,"Beginning of Year",null,null,-94.418000000000006]
[{"$f":"A53+1","v":35},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A54+1","v":36},null,null,"Additions","8.0 L72",null,-0.1]
[{"$f":"A55+1","v":37},null,null,"Recovery","8.0 L67",null,0.7]
[{"$f":"A56+1","v":38},null,null,"End of Year",null,null,-93.817999999999998]
[]
[null,null,"Pre-1996 Customer Contributions"]
[{"$f":"A57+1","v":39},null,null,"Beginning of Year",null,null,87.437999999999988]
[{"$f":"A60+1","v":40},null,null,"Additions","N/A",null,0]
[{"$f":"A61+1","v":41},null,null,"Recovery","7.0 L51",null,4.6900000000000004]
[{"$f":"A62+1","v":42},null,null,"End of Year",null,null,92.127999999999986]
[]
[null,null,"Storm Restoration Costs"]
[{"$f":"A63+1","v":43},null,null,"Beginning of Year",null,null,-1.2993377349965991]
[{"$f":"A66+1","v":44},null,null,"Additions","5.0 L52",null,0]
[{"$f":"A67+1","v":45},null,null,"Interest",null,null,-2.7415647056131878E-2]
[{"$f":"A68+1","v":46},null,null,"Recovery","5.0 L30",null,1.3722596637575986]
[{"$f":"A69+1","v":47},null,null,"Transfer to NHDA",null,null,0]
[{"$f":"A70+1","v":48},null,null,"End of Year",null,null,4.5506281704867479E-2]
[]
[null,null,"Procurement Enhancement"]
[{"$f":"A71+1","v":49},null,null,"Beginning of Year",null,null,4.7027258188537861E-2]
[{"$f":"A74+1","v":50},null,null,"Additions - Operating","5.0 L53",null,0]
[51,null,null,"Additions - Amortization","7.0 L32",null,0]
[52,null,null,"Interest",null,null,2.1025213568828796E-3]
[53,null,null,"F11 RRA NSA Adjustment","5.0 L31",null,0]
[54,null,null,"Recovery","5.0 L32",null,0]
[55,null,null,"End of Year",null,null,4.9129779545420742E-2]
[]
[null,null,"Capital Project Investigation"]
[{"$f":"A80+1","v":56},null,null,"Beginning of Year",null,null,29.878958910000001]
[{"$f":"A83+1","v":57},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A84+1","v":58},null,null,"Additions","5.0 L54",null,0]
[{"$f":"A85+1","v":59},null,null,"Interest",null,null,0]
[{"$f":"A86+1","v":60},null,null,"Recovery","5.0 L33",null,-4.8310410800000003]
[{"$f":"A87+1","v":61},null,null,"End of Year",null,null,25.047917830000003]
[]
[null,null,"GM Shrum 3"]
[{"$f":"A88+1","v":62},null,null,"Beginning of Year",null,null,0]
[{"$f":"A91+1","v":63},null,null,"Additions - Deferred Operating","5.0 L55",null,0]
[64,null,null,"Additions - COE","4.0 L49",null,0]
[65,null,null,"Interest",null,null,0]
[66,null,null,"Insurance Proceeds","4.0 L50",null,0]
[67,null,null,"Transfer to HDA",null,null,0]
[68,null,null,"End of Year",null,null,0]
[]
[null,null,"F2010 ROE Adjustment"]
[{"$f":"A97+1","v":69},null,null,"Beginning of Year",null,null,0]
[{"$f":"A100+1","v":70},null,null,"Additions","9.0 L53",null,0]
[{"$f":"A101+1","v":71},null,null,"Interest","N/A",null,0]
[{"$f":"A102+1","v":72},null,null,"Recovery","9.0 L54",null,0]
[{"$f":"A103+1","v":73},null,null,"End of Year",null,null,0]
[]
[null,null,"Net Employment Costs"]
[{"$f":"A104+1","v":74},null,null,"Beginning of Year",null,null,0]
[{"$f":"A107+1","v":75},null,null,"Additions","N/A",null,0]
[{"$f":"A108+1","v":76},null,null,"Interest",null,null,0]
[{"$f":"A109+1","v":77},null,null,"Recovery","5.0 L34",null,0]
[{"$f":"A110+1","v":78},null,null,"End of Year",null,null,0]
[]
[null,null,"Total Taxes"]
[{"$f":"A111+1","v":79},null,null,"Beginning of Year",null,null,-3.1151863171441363E-2]
[{"$f":"A114+1","v":80},null,null,"Additions","N/A",null,0]
[{"$f":"A115+1","v":81},null,null,"Interest",null,null,0]
[{"$f":"A116+1","v":82},null,null,"Recovery","6.0 L27",null,0]
[{"$f":"A117+1","v":83},null,null,"End of Year",null,null,-3.1151863171441363E-2]
[]
[null,null,"Amortization of Capital Additions"]
[{"$f":"A118+1","v":84},null,null,"Beginning of Year",null,null,-9.3261222020237859]
[{"$f":"A121+1","v":85},null,null,"Additions - Bad Debt","5.0 L60",null,0]
[{"$f":"A122+1","v":86},null,null,"Interest",null,null,-0.20640115773937545]
[{"$f":"A123+1","v":87},null,null,"Recovery","7.0 L57",null,9.4190630110050702]
[{"$f":"A124+1","v":88},null,null,"End of Year",null,null,-0.11346034875809075]
[]
[null,null,"Total Finance Charges"]
[{"$f":"A125+1","v":89},null,null,"Beginning of Year",null,null,-25.606174206678254]
[{"$f":"A128+1","v":90},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A129+1","v":91},null,null,"Additions","N/A",null,0]
[{"$f":"A130+1","v":92},null,null,"Interest","N/A",null,0]
[{"$f":"A131+1","v":93},null,null,"Recovery","8.0 L69",null,25.542661942377102]
[{"$f":"A132+1","v":94},null,null,"End of Year",null,null,-6.3512264301152754E-2]
[]
[null,null,"Smart Metering & Infrastructure"]
[{"$f":"A133+1","v":95},null,null,"Beginning of Year",null,null,286.74974146162839]
[{"$f":"A136+1","v":96},null,null,"Adjustment to Opening Balance",null,null,0]
[97,null,null,"Additions - Deferred Operating","5.0 L56",null,21.463255266523444]
[98,null,null,"Additions - Amortization","7.0 L28",null,0]
[99,null,null,"Legacy Meter Contributions",null,null,0]
[100,null,null,"Additions - Finance Charges","8.0 L73",null,0]
[101,null,null,"Additions - ROE","9.0 L51",null,0]
[102,null,null,"Additions - Non tariff revenues","15.0 L34",null,-3.3632552665234421]
[103,null,null,"Interest",null,null,12.524507045312106]
[104,null,null,"Recovery","5.0 L35",null,-31.326242819504898]
[105,null,null,"End of Year",null,null,286.04800568743559]
[]
[null,null,"Home Purchase Option Plan"]
[{"$f":"A146+1","v":106},null,null,"Beginning of Year",null,null,11.132074834068939]
[{"$f":"A149+1","v":107},null,null,"Additions - Deferred Operating","5.0 L57",null,0]
[{"$f":"A150+1","v":108},null,null,"Additions - Interest","8.0 L74",null,0]
[{"$f":"A151+1","v":109},null,null,"Interest",null,null,0.24445175248588374]
[{"$f":"A152+1","v":110},null,null,"Recovery","5.0 L36",null,-11.328807069918]
[{"$f":"A153+1","v":111},null,null,"End of Year",null,null,4.7719516636822945E-2]
[]
[null,null,"Non-Current Pension Cost"]
[{"$f":"A154+1","v":112},null,null,"Beginning of Year",null,null,186.33931669230753]
[{"$f":"A157+1","v":113},null,null,"Adjustment to Opening Balance",null,null,0]
[114,null,null,"OCI Deferral","9.0 L8",null,0]
[115,null,null,"Additions",null,null,0]
[116,null,null,"Interest","N/A",null,0]
[117,null,null,"Recovery - Operating","5.0 L37",null,-15.520692307692308]
[118,null,null,"Recovery - Finance Charges","8.0 L68",null,0]
[119,null,null,"End of Year",null,null,170.81862438461522]
[]
[null,null,"Waneta"]
[{"$f":"A164+1","v":120},null,null,"Beginning of Year",null,null,0]
[{"$f":"A167+1","v":121},null,null,"Additions",null,null,0]
[{"$f":"A168+1","v":122},null,null,"Recovery",null,null,0]
[{"$f":"A169+1","v":123},null,null,"End of Year",null,null,0]
[]
[null,null,"Environmental Provisions"]
[{"$f":"A170+1","v":124},null,null,"Beginning of Year",null,null,239.0693144816303]
[{"$f":"A173+1","v":125},null,null,"Adjustment to Opening Balance",null,null,0]
[126,null,null,"Additions - Deferred Operating","5.0 L85",null,0]
[127,null,null,"Additions - Amortization","7.0 L29",null,0]
[128,null,null,"Additions - Accretion","8.0 L71",null,6]
[129,null,null,"Transfer to Rock Bay",null,null,0]
[130,null,null,"Transfer to Asbestos",null,null,-0.91818119999999992]
[131,null,null,"Recovery","5.0 L90-93",null,-13.291302082805437]
[132,null,null,"End of Year",null,null,230.85983119882488]
[]
[null,null,"Rock Bay Remediation"]
[{"$f":"A181+1","v":133},null,null,"Beginning of Year",null,null,49.407427973905818]
[{"$f":"A184+1","v":134},null,null,"Transfer from Environmental","Line 129",null,0]
[{"$f":"A185+1","v":135},null,null,"Additions",null,null,0]
[{"$f":"A186+1","v":136},null,null,"Interest",null,null,1.0803561995785957]
[{"$f":"A187+1","v":137},null,null,"Recovery","5.0 L99",null,-50.486034205431302]
[{"$f":"A188+1","v":138},null,null,"End of Year",null,null,1.7499680531116724E-3]
[]
[null,null,"IFRS PP&E"]
[{"$f":"A189+1","v":139},null,null,"Beginning of Year",null,null,758.16305972131306]
[{"$f":"A192+1","v":140},null,null,"Adjustment to Opening Balance",null,null,0]
[141,null,null,"Additions - Deferred Operating","5.0 L58",null,134.40780000000001]
[142,null,null,"Additions - IDC","8.0 L75",null,0]
[143,null,null,"Interest","N/A",null,0]
[144,null,null,"Recovery","5.0 L38",null,-19.8289210786869]
[145,null,null,"End of Year",null,null,872.74193864262622]
[]
[null,null,"IFRS Pension"]
[{"$f":"A198+1","v":146},null,null,"Beginning of Year",null,null,650.06111111111102]
[{"$f":"A201+1","v":147},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A202+1","v":148},null,null,"Additions","N/A",null,0]
[{"$f":"A203+1","v":149},null,null,"Recovery","5.0 L39",null,-38.238888888888887]
[{"$f":"A204+1","v":150},null,null,"End of Year",null,null,611.82222222222208]
[]
[null,null,"F12-F14 Rate Smoothing"]
[{"$f":"A205+1","v":151},null,null,"Beginning of Year",null,null,0]
[{"$f":"A208+1","v":152},null,null,"Additions","N/A",null,0]
[{"$f":"A209+1","v":153},null,null,"Recovery","5.0 L102",null,0]
[{"$f":"A210+1","v":154},null,null,"End of Year",null,null,0]
[]
[null,null,"Arrow Water Divestiture Costs"]
[{"$f":"A211+1","v":155},null,null,"Beginning of Year",null,null,4.4419132268447976]
[{"$f":"A214+1","v":156},null,null,"Additions","5.0 L86",null,0]
[{"$f":"A215+1","v":157},null,null,"Interest",null,null,9.7681160211553902E-2]
[{"$f":"A216+1","v":158},null,null,"Recovery","5.0 L100",null,-4.5141422872133097]
[{"$f":"A217+1","v":159},null,null,"End of Year",null,null,2.5452099843041864E-2]
[]
[null,null,"Arrow Water Provision"]
[{"$f":"A218+1","v":160},null,null,"Beginning of Year",null,null,3.0205397500000002]
[{"$f":"A221+1","v":161},null,null,"Additions","5.0 L87",null,0]
[{"$f":"A222+1","v":162},null,null,"Additions - Accretion",null,null,0.1]
[{"$f":"A223+1","v":163},null,null,"Recovery","5.0 L101",null,-0.3]
[{"$f":"A224+1","v":164},null,null,"End of Year",null,null,2.8205397500000005]
[]
[null,null,"Asbestos Remediation"]
[{"$f":"A225+1","v":165},null,null,"Beginning of Year",null,null,9.5897165797953434]
[{"$f":"A228+1","v":166},null,null,"Transfer from Environmental","Line 130",null,0.91818119999999992]
[{"$f":"A229+1","v":167},null,null,"Additions",null,null,0]
[{"$f":"A230+1","v":168},null,null,"Interest",null,null,0.18826970474916299]
[{"$f":"A231+1","v":169},null,null,"Recovery","5.0 L95-98",null,-10.75734699591432]
[{"$f":"A232+1","v":170},null,null,"End of Year",null,null,-6.1179511369815032E-2]
[]
[null,null,"Rate Smoothing"]
[{"$f":"A233+1","v":171},null,null,"Beginning of Year",null,null,166.2]
[{"$f":"A236+1","v":172},null,null,"Additions","N/A",null,0]
[{"$f":"A237+1","v":173},null,null,"Recovery","5.0 L103",null,121.2]
[{"$f":"A238+1","v":174},null,null,"End of Year",null,null,287.39999999999998]
[]
[null,null,"Real Property Sales"]
[{"$f":"A239+1","v":175},null,null,"Beginning of Year",null,null,0]
[{"$f":"A242+1","v":176},null,null,"Additions",null,null,0]
[{"$f":"A243+1","v":177},null,null,"Interest",null,null,0]
[{"$f":"A244+1","v":178},null,null,"Recovery",null,null,0]
[{"$f":"A245+1","v":179},null,null,"End of Year",null,null,0]
[]
[null,null,"End of Year Balances"]
[{"$f":"A246+1","v":180},null,null,"Demand-Side Management","Line 7",null,945.57266509333328]
[{"$f":"A249+1","v":181},null,null,"First Nations Costs","Line 14",null,154.78279208022786]
[182,null,null,"First Nations Provisions","Line 19",null,405.4546757825338]
[183,null,null,"F07/F08 RRA Depn Study","Line 23",null,0]
[184,null,null,"Site C","Line 28",null,393.70443308210832]
[185,null,null,"Future Removal","Line 33",null,-9.9209258800000342]
[186,null,null,"Foreign Exchange","Line 38",null,-93.817999999999998]
[187,null,null,"Pre-1996 Contributions","Line 42",null,92.127999999999986]
[188,null,null,"Storm Restoration","Line 48",null,4.5506281704867479E-2]
[189,null,null,"Procurement Enhancement","Line 55",null,4.9129779545420742E-2]
[190,null,null,"Capital Project Investigation","Line 61",null,25.047917830000003]
[191,null,null,"GM Shrum 3","Line 68",null,0]
[192,null,null,"F2010 ROE Adjustment","Line 73",null,0]
[193,null,null,"Net Employment Costs","Line 78",null,0]
[194,null,null,"Total Taxes","Line 83",null,-3.1151863171441363E-2]
[195,null,null,"Amortization of Capital Additions","Line 88",null,-0.11346034875809075]
[196,null,null,"Total Finance Charges","Line 94",null,-6.3512264301152754E-2]
[197,null,null,"Smart Metering & Infrastructure","Line 105",null,286.04800568743559]
[198,null,null,"Home Option Purchase Plan","Line 111",null,4.7719516636822945E-2]
[199,null,null,"Non-Current Pension Cost","Line 119",null,170.81862438461522]
[200,null,null,"Waneta","Line 123",null,0]
[201,null,null,"Environmental Provisions","Line 132",null,230.85983119882488]
[202,null,null,"Rock Bay Remediation","Line 138",null,1.7499680531116724E-3]
[203,null,null,"IFRS PP&E","Line 145",null,872.74193864262622]
[204,null,null,"IFRS Pension","Line 150",null,611.82222222222208]
[205,null,null,"F12-F14 Rate Smoothing","Line 154",null,0]
[206,null,null,"Arrow Water Divestiture Costs","Line 159",null,2.5452099843041864E-2]
[207,null,null,"Arrow Water Provision","Line 164",null,2.8205397500000005]
[208,null,null,"Asbestos Remediation","Line 170",null,-6.1179511369815032E-2]
[209,null,null,"Rate Smoothing","Line 174",null,287.39999999999998]
[210,null,null,"Real Property Sales","Line 179",null,0]
[211,null,null,"Total",null,null,4375.3629735321092]
[]
[null,null,"Summary"]
[{"$f":"A280+1","v":212},null,null,"Regulatory Account Additions",null,null,310.28880000000004]
[{"$f":"A283+1","v":213},null,null,"Interest on Regulatory Accounts",null,null,37.944519165489261]
[214,null,null,"Regulatory Account Recoveries",null,null,-132.85682538930655]
[215,null,null,"Transfer of Storm Restoration","Line 47",null,0]
[216,null,null,"Transfer of GM Shrum 3","Line 67",null,0]
[217,null,null,"Adjustments to Opening Balances",null,null,0]
[218,null,null,"OCI Deferral (Pension)",null,null,0]
[219,null,null,"Regulatory Account Net Transfers",null,null,215.37649377618277]
[]
[{"$f":"A290+1","v":220},null,"Interest Rate",null,"8.0 L104",null,4.4708567708830096E-2]

{"sheet":"RRA 3.0","index":22,"n_rows":110,"n_cols":7,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
["Reconciliation of Current and Gross Views"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Cost of Energy"]
[1,null,null,"Total Current","4.0 L58",null,1514.2628814592272]
[{"$f":"A8+1","v":2},null,null,"HDA Additions","4.0 L46",null,0]
[3,null,null,"NHDA Additions","4.0 L47",null,0]
[4,null,null,"BCTCDA Additions","4.0 L48",null,0]
[5,null,null,"Deferred GMS 3 COE","4.0 L49",null,0]
[6,null,null,"GMS 3 Insurance Proceeds","4.0 L50",null,0]
[7,null,null,"Water License Variances","4.0 L51",null,0]
[8,null,null,"Deferred Operating HDA","4.0 L52",null,0]
[9,null,null,"Deferred Operating NHDA","4.0 L53",null,0]
[10,null,null,"Deferred Waneta Costs","4.0 L54",null,0]
[11,null,null,"HDA Recoveries","4.0 L55",null,-17.741247086104963]
[12,null,null,"NHDA Recoveries","4.0 L56",null,-104.82163437312234]
[13,null,null,"BCTCDA Recoveries","4.0 L57",null,0]
[14,null,null,"Total Gross",null,null,1391.6999999999998]
[]
[null,null,"Operating Costs"]
[{"$f":"A21+1","v":15},null,null,"Total Current","5.0 L124",null,977.73363786268862]
[{"$f":"A24+1","v":16},null,null,"Deferral Account Additions","5.0 L48",null,0]
[{"$f":"A25+1","v":17},null,null,"Deferral Account Recoveries","5.0 L41",null,0]
[{"$f":"A26+1","v":18},null,null,"Regulatory Account Additions","5.0 L61+88",null,289.95205526652342]
[{"$f":"A27+1","v":19},null,null,"Regulatory Account Recoveries","5.0 L40+104",null,-121.06979412268872]
[{"$f":"A28+1","v":20},null,null,"Total Gross",null,null,1146.6158990065233]
[]
[null,null,"Taxes"]
[{"$f":"A29+1","v":21},null,null,"Total Current","6.0 L28",null,224.13055555379046]
[{"$f":"A32+1","v":22},null,null,"Regulatory Account Additions","N/A",null,0]
[{"$f":"A33+1","v":23},null,null,"Regulatory Account Recoveries","6.0 L27",null,0]
[{"$f":"A34+1","v":24},null,null,"Total Gross",null,null,224.13055555379046]
[]
[null,null,"Amortization"]
[{"$f":"A35+1","v":25},null,null,"Total Current","7.0 L59",null,796.03169320899497]
[{"$f":"A38+1","v":26},null,null,"Regulatory Account Additions","7.0 L30+34",null,0]
[{"$f":"A39+1","v":27},null,null,"Regulatory Account Recoveries","7.0 L58",null,-38.029693208994928]
[{"$f":"A40+1","v":28},null,null,"Total Gross",null,null,758.00200000000007]
[]
[null,null,"Finance Charges"]
[{"$f":"A41+1","v":29},null,null,"Total Current","8.0 L71",null,726.64635807642378]
[{"$f":"A44+1","v":30},null,null,"Interest on Regulatory Accounts","8.0 L66",null,61.739202538664102]
[{"$f":"A45+1","v":31},null,null,"Regulatory Account Additions","8.0 L79",null,23.7]
[{"$f":"A46+1","v":32},null,null,"Regulatory Account Recoveries","8.0 L70",null,26.242661942377101]
[{"$f":"A47+1","v":33},null,null,"Total Gross",null,null,838.3282225574651]
[]
[null,null,"Return on Equity"]
[{"$f":"A48+1","v":34},null,null,"Total Current","9.0 L56",null,651.85107129458243]
[{"$f":"A51+1","v":35},null,null,"Regulatory Account Additions","9.0 L53",null,0]
[{"$f":"A52+1","v":36},null,null,"Regulatory Account Recoveries","9.0 L54",null,0]
[{"$f":"A53+1","v":37},null,null,"Total Gross",null,null,651.85107129458243]
[]
[null,null,"Non-Tariff Revenue"]
[{"$f":"A54+1","v":38},null,null,"Total Current","15.0 L35",null,-123.2614080728475]
[{"$f":"A57+1","v":39},null,null,"Regulatory Account Additions","15.0 L33+34",null,-3.3632552665234421]
[{"$f":"A58+1","v":40},null,null,"Regulatory Account Recoveries",null,null,0]
[{"$f":"A59+1","v":41},null,null,"Total Gross","15.0 L32",null,-126.62466333937094]
[]
[null,null,"Inter-Segment Revenue"]
[{"$f":"A60+1","v":42},null,null,"Powerex - Corporate Allocation","3.1 L17",null,-3]
[{"$f":"A63+1","v":43},null,null,"Mark to Market Losses (Gains)","3.1 L18",null,0]
[{"$f":"A64+1","v":44},null,null,"Other","3.1 L19",null,0]
[{"$f":"A65+1","v":45},null,null,"Powerex  PTP Charges","3.4 L18",null,-29.20293199999999]
[{"$f":"A66+1","v":46},null,null,"BC Hydro PTP Charges","3.4 L19",null,-21.307427036389932]
[{"$f":"A67+1","v":47},null,null,"Total",null,null,-53.510359036389922]
[]
[null,null,"Regulatory Account Transfers"]
[{"$f":"A68+1","v":48},null,null,"Deferral Accounts","1.0 L12",null,199.19706345675996]
[{"$f":"A71+1","v":49},null,null,"Other Regulatory Accounts","1.0 L16",null,-215.37649377618277]
[{"$f":"A72+1","v":50},null,null,"Total",null,null,-16.179430319422806]
[]
[null,null,"Powerex Net Income"]
[{"$f":"A73+1","v":51},null,null,"Total Current",null,null,-9.5711346292924873]
[{"$f":"A76+1","v":52},null,null,"TIDA Additions","2.1 L18",null,0]
[{"$f":"A77+1","v":53},null,null,"TIDA Recoveries","2.1 L20",null,-100.42886537070751]
[{"$f":"A78+1","v":54},null,null,"Total Gross",null,null,-110]
[]
[{"$f":"A79+1","v":55},null,"Powertech Net Income",null,"1.0 L18",null,-5.12]
[{"$f":"A81+1","v":56},null,"Other Utilities Revenue",null,"14.0 L17",null,-16.499916335699446]
[{"$f":"A82+1","v":57},null,"Deferral Rider Revenue",null,"14.0 L21",null,-222.99174682993481]
[]
[{"$f":"A83+1","v":58},null,"Total Rate Revenue Requirement",null,null,null,4459.7016325515424]
[]
[null,null,"Summary - Current Rates View"]
[{"$f":"A85+1","v":59},null,null,"Cost of Energy","Line 1",null,1514.2628814592272]
[{"$f":"A88+1","v":60},null,null,"Operating Costs","Line 15",null,977.73363786268862]
[61,null,null,"Taxes","Line 21",null,224.13055555379046]
[62,null,null,"Amortization","Line 25",null,796.03169320899497]
[63,null,null,"Finance Charges","Line 29",null,726.64635807642378]
[64,null,null,"Return on Equity","Line 34",null,651.85107129458243]
[65,null,null,"Non-Tariff Revenue","Line 38",null,-123.2614080728475]
[66,null,null,"Inter-Segment Revenue","Line 47",null,-53.510359036389922]
[67,null,null,"Subsididary Net Income","Lines 51+55",null,-14.691134629292488]
[68,null,null,"Other Utilities Revenue","Line 56",null,-16.499916335699446]
[69,null,null,"Deferral Rider Revenue","Line 57",null,-222.99174682993481]
[70,null,null,"Total Rate Revenue Requirement",null,null,4459.7016325515442]
[]
[null,null,"Current Costs by Business Group"]
[{"$f":"A99+1","v":71},null,null,"Generation","3.2 L17",null,1600.779656245438]
[{"$f":"A102+1","v":72},null,null,"Transmission","3.4 L21",null,747.68417637907692]
[73,null,null,"Distribution","3.5 L13",null,1078.0243089803655]
[74,null,null,"Customer Care","3.3 L16",null,1287.3962887415896]
[75,null,null,"Corporate Groups","3.1 L21",null,-5.6843418860808015E-14]
[76,null,null,"Subsididary Net Income","Line 67",null,-14.691134629292488]
[77,null,null,"Other Utilities Revenue","Line 68",null,-16.499916335699446]
[78,null,null,"Deferral Rider Revenue","Line 69",null,-222.99174682993481]
[79,null,null,"Total Rate Revenue Requirement",null,null,4459.7016325515433]

{"sheet":"RRA 3.4","index":23,"n_rows":117,"n_cols":7,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
["Total Current Costs - Transmission"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[1,null,"Cost of Energy",null,"N/A",null,0]
[]
[{"$f":"A7+1","v":2},null,"Current Operating Costs",null,"5.0 L114",null,237.95642528989455]
[]
[3,null,"Taxes",null,"6.0 L31",null,131.96299999999999]
[]
[{"$f":"A11+1","v":4},null,"Current Amortization",null,"7.0 L61",null,187.13497562200001]
[]
[{"$f":"A13+1","v":5},null,"Current Finance Charges",null,"8.0 L88",null,233.02567957535786]
[]
[{"$f":"A15+1","v":6},null,"Return on Equity",null,"9.0 L64",null,209.03984060754007]
[]
[{"$f":"A17+1","v":7},null,"Corporate Allocation",null,"3.1 L68",null,95.692613236822694]
[]
[{"$f":"A19+1","v":8},null,"Non-Tariff Revenue",null,"15.0 L12",null,-39.191343315875997]
[]
[null,null,"Internal Allocations:"]
[{"$f":"A21+1","v":9},null,null,"GRTA Allocation",null,null,-43.3]
[{"$f":"A24+1","v":10},null,null,"SDA Allocation",null,null,-148.27406614988664]
[11,null,null,"Generation Real Time Dispatch",null,null,-1.818939006782037]
[12,null,null,"Distribution Real Time Dispatch",null,null,-17.125008751837242]
[13,null,null,"PTP Allocation to Distribution",null,null,-29.416960283610088]
[14,null,null,"First Nations Comm Dev Fund",null,null,0]
[15,null,null,"Aboriginal Relations",null,null,-19.314013988156386]
[16,null,null,"Generation Ancillary Services",null,null,1.8223325799999999]
[17,null,null,"Total",null,null,-257.42665560027234]
[]
[null,null,"Inter-Segment Revenue"]
[{"$f":"A32+1","v":18},null,null,"Powerex PTP Charges",null,null,-29.20293199999999]
[{"$f":"A35+1","v":19},null,null,"BC Hydro PTP Charges",null,null,-21.307427036389932]
[{"$f":"A36+1","v":20},null,null,"Total",null,null,-50.510359036389922]
[]
[{"$f":"A37+1","v":21},null,"Total Current Costs",null,null,null,747.68417637907692]
[]
[null,null,"Transmission Revenue Requirement"]
[{"$f":"A39+1","v":22},null,null,"Total Current Costs","Line 21",null,747.68417637907692]
[{"$f":"A42+1","v":23},null,null,"PTP Allocation to Distribution","Line 13",null,29.416960283610088]
[{"$f":"A43+1","v":24},null,null,"Inter-Segment Revenue","Line 20",null,50.510359036389922]
[{"$f":"A44+1","v":25},null,null,"External OATT Revenue","Line 71",null,11.803587407999999]
[{"$f":"A45+1","v":26},null,null,"Total TRR",null,null,839.41508310707695]
[]
[null,null,"NITS Charge to BC Hydro"]
[{"$f":"A46+1","v":27},null,null,"Total Current Costs","Line 21",null,747.68417637907692]
[{"$f":"A49+1","v":28},null,null,"Internal Ancillary Services","Line 33",null,0]
[{"$f":"A50+1","v":29},null,null,"Internal Scheduling & Dispatch","Line 35",null,-2.8805038133538519]
[{"$f":"A51+1","v":30},null,null,"Total",null,null,744.8036725657231]
[{"$f":"A52+1","v":31},null,null,"NITS Monthly Rate","Line 30 / 12",null,62.066666666666663]
[]
[null,null,"Long-Term PTP Rate"]
[{"$f":"A53+1","v":32},null,null,"Total TRR","Line 26",null,839.41508310707695]
[{"$f":"A56+1","v":33},null,null,"Internal Ancillary Services",null,null,0]
[{"$f":"A57+1","v":34},null,null,"External Ancillary Services",null,null,-1.8223325799999999]
[{"$f":"A58+1","v":35},null,null,"Internal Scheduling & Dispatch",null,null,-2.8805038133538519]
[{"$f":"A59+1","v":36},null,null,"External Scheduling & Dispatch",null,null,-0.13535002800000001]
[{"$f":"A60+1","v":37},null,null,"Total",null,null,834.57689668572323]
[]
[{"$f":"A61+1","v":38},null,null,"Maximum Supply (MW)",null,null,12846]
[{"$f":"A63+1","v":39},null,null,"Long-Term Firm PTP Rate ($/MW/year)",null,null,64967.841871845179]
[]
[null,null,"Maximum Price for Short-Term Firm and"]
[null,null,"Non-Firm (per MW of Reserved Capacity)"]
[{"$f":"A64+1","v":40},null,null,"Monthly ($/MW/month)",null,null,5413.99]
[{"$f":"A68+1","v":41},null,null,"Weekly ($/MW/week)",null,null,1249.3800000000001]
[{"$f":"A69+1","v":42},null,null,"Daily ($/MW/day)",null,null,177.99]
[{"$f":"A70+1","v":43},null,null,"Hourly ($/MW/hour)",null,null,7.42]
[]
[null,null,"Scheduling Fee"]
[{"$f":"A71+1","v":44},null,null,"Scheduling, Control & Dispatch","Lines 35 + 36",null,3.0158538413538518]
[{"$f":"A74+1","v":45},null,null,"Total Volumne (GWh)",null,null,30463.17011468537]
[{"$f":"A75+1","v":46},null,null,"Scheduling Fee ($/MWh)","Line 44 / 45",null,9.9000000000000005E-2]
[]
[null,null,"Long-Term PTP Volumes (GWh)"]
[{"$f":"A76+1","v":47},null,null,"Internal",null,null,8926.44]
[{"$f":"A79+1","v":48},null,null,"External",null,null,1314]
[{"$f":"A80+1","v":49},null,null,"Total",null,null,10240.44]
[]
[null,null,"Long-Term PTP Revenue"]
[{"$f":"A81+1","v":50},null,null,"Internal","Line 43 * 47",null,66.234184800000008]
[{"$f":"A84+1","v":51},null,null,"External","Line 43 * 48",null,9.7498799999999992]
[{"$f":"A85+1","v":52},null,null,"Total",null,null,75.984064800000013]
[]
[null,null,"Long-Term PTP Average Price ($/MWh)"]
[{"$f":"A86+1","v":53},null,null,"Internal","Line 50 / 47",null,7.42]
[{"$f":"A89+1","v":54},null,null,"External","Line 51 / 48",null,7.419999999999999]
[{"$f":"A90+1","v":55},null,null,"Total","Line 52 / 49",null,7.42]
[]
[null,null,"Short-Term PTP Volumes (GWh)"]
[{"$f":"A91+1","v":56},null,null,"Internal",null,null,7582.3261146853702]
[{"$f":"A94+1","v":57},null,null,"External",null,null,53.171999999999997]
[{"$f":"A95+1","v":58},null,null,"Total",null,null,7635.4981146853697]
[]
[null,null,"Short-Term PTP Revenue"]
[{"$f":"A96+1","v":59},null,null,"Internal",null,null,13.693134519999996]
[{"$f":"A99+1","v":60},null,null,"External",null,null,9.6024800000000007E-2]
[{"$f":"A100+1","v":61},null,null,"Total",null,null,13.789159319999996]
[]
[null,null,"Short-Term PTP Average Price ($/MWh)"]
[{"$f":"A101+1","v":62},null,null,"Internal","Line 59 / 56",null,1.8059279319942829]
[{"$f":"A104+1","v":63},null,null,"External","Line 60 / 57",null,1.8059279319942831]
[{"$f":"A105+1","v":64},null,null,"Total","Line 61 / 58",null,1.8059279319942829]
[]
[null,null,"Total PTP Revenue"]
[{"$f":"A106+1","v":65},null,null,"Internal","Line 50 + 59",null,79.927319320000009]
[{"$f":"A109+1","v":66},null,null,"External","Line 51 + 60",null,9.8459047999999996]
[{"$f":"A110+1","v":67},null,null,"Total",null,null,89.773224120000009]
[]
[null,null,"Total External OATT Revenue"]
[{"$f":"A111+1","v":68},null,null,"Total External PTP","Line 66",null,9.8459047999999996]
[{"$f":"A114+1","v":69},null,null,"External Ancillary Services","Line 34",null,1.8223325799999999]
[{"$f":"A115+1","v":70},null,null,"External Scheduling & Dispatch","Line 36",null,0.13535002800000001]
[{"$f":"A116+1","v":71},null,null,"Total",null,null,11.803587407999999]

{"sheet":"RRA 4.0","index":24,"n_rows":159,"n_cols":7,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
["Cost of Energy"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,"Cost of Energy ($ million)"]
[]
[null,null,"Heritage Energy"]
[1,null,null,"Hydroelectric (water rentals)",null,null,384.5]
[{"$f":"A10+1","v":2},null,null,"Market Electricity Purchases",null,null,56.600000000000009]
[3,null,null,"Market Purchases to Non-Heritage",null,null,0]
[4,null,null,"Natural Gas for Thermal Generation",null,null,26.9]
[5,null,null,"Domestic Transmission",null,null,25.7]
[6,null,null,"Non-Treaty Storage Agreement",null,null,-19.8]
[7,null,null,"Surplus Sales",null,null,-84.2]
[8,null,null,"Other",null,null,-32.1]
[9,null,null,"Total",null,null,357.59999999999997]
[]
[null,null,"Non-Heritage Energy"]
[{"$f":"A18+1","v":10},null,null,"Mkt Purchases From Heritage","Line 3",null,0]
[{"$f":"A21+1","v":11},null,null,"Waneta (water rentals)",null,null,7.4]
[12,null,null,"IPPs and Long-Term Commitments",null,null,975.5]
[13,null,null,"New Capital Leases Under IFRS",null,null,0]
[14,null,null,"Non-Integrated Area",null,null,34.299999999999997]
[15,null,null,"Gas & Other Transportation",null,null,12.1]
[16,null,null,"Domestic Transmission",null,null,0]
[17,null,null,"Net Purchases (Sales) from Powerex",null,null,4.8]
[18,null,null,"Total",null,null,1034.0999999999999]
[]
[{"$f":"A29+1","v":19},null,"Total Gross COE",null,"Lines 9+18",null,1391.6999999999998]
[]
[null,"Sources of Supply (GWh)"]
[]
[null,null,"Heritage Energy"]
[{"$f":"A31+1","v":20},null,null,"Hydroelectric (water rentals)",null,null,46312]
[{"$f":"A36+1","v":21},null,null,"Net Purchases (Sales) from Powerex",null,null,255]
[22,null,null,"Market Electricity Purchases",null,null,1553]
[23,null,null,"Market Purchases to Non-Heritage",null,null,0]
[24,null,null,"Natural Gas for Thermal Generation",null,null,301]
[25,null,null,"Surplus Sales",null,null,-2446]
[26,null,null,"Exchange Net",null,null,-204]
[27,null,null,"Total",null,null,45771]
[]
[null,null,"Non-Heritage Energy"]
[{"$f":"A43+1","v":28},null,null,"Waneta (water rentals)",null,null,594]
[{"$f":"A46+1","v":29},null,null,"IPPs and Long-Term Commitments",null,null,12002]
[{"$f":"A47+1","v":30},null,null,"Mkt Purchases From Heritage","Line 23",null,0]
[{"$f":"A48+1","v":31},null,null,"Non-Integrated Area",null,null,135]
[{"$f":"A49+1","v":32},null,null,"Total",null,null,12731]
[]
[{"$f":"A50+1","v":33},null,"Total Sources of Supply",null,"Lines 27+32",null,58502]
[]
[{"$f":"A52+1","v":34},null,"Less Line Loss and System Use",null,null,null,-4742.2389116680206]
[]
[{"$f":"A54+1","v":35},null,"Total Domestic Sales",null,"14.0 L9",null,53759.761088331979]
[]
[{"$f":"A56+1","v":36},null,"Line Loss as % of Sales",null,null,null,8.8211681295906577E-2]
[]
[null,"Unit Costs ($/MWh)"]
[{"$f":"A58+1","v":37},null,null,"Hydroelectric (water rentals)",null,null,8.3023838314043878]
[{"$f":"A61+1","v":38},null,null,"Waneta (water rentals)",null,null,12.457912457912458]
[39,null,null,"IPPs and Long-Term Commitments",null,null,81.278120313281121]
[40,null,null,"Market Electricity Purchases",null,null,36.445589182227948]
[41,null,null,"Surplus Sales",null,null,-34.423548650858542]
[42,null,null,"Natural Gas for Thermal Generation",null,null,89.368770764119603]
[43,null,null,"Non-Integrated Area",null,null,254.07407407407408]
[44,null,null,"Total Weighted Cost",null,null,25.887391830356449]
[]
[null,"Current Cost of Energy"]
[{"$f":"A68+1","v":45},null,null,"Gross Cost of Energy","Line 19",null,1391.6999999999998]
[{"$f":"A71+1","v":46},null,null,"HDA Additions",null,null,0]
[47,null,null,"NHDA Additions",null,null,0]
[48,null,null,"BCTCDA Additions",null,null,0]
[49,null,null,"Deferred GMS 3 COE",null,null,0]
[50,null,null,"GMS 3 Insurance Proceeds",null,null,0]
[51,null,null,"Water License Variances",null,null,0]
[52,null,null,"Deferred Operating HDA",null,null,0]
[53,null,null,"Deferred Operating NHDA",null,null,0]
[54,null,null,"Deferred Waneta Costs",null,null,0]
[55,null,null,"HDA Recoveries",null,null,17.741247086104963]
[56,null,null,"NHDA Recoveries",null,null,104.82163437312234]
[57,null,null,"BCTCDA Recoveries",null,null,0]
[58,null,null,"Total",null,null,1514.2628814592272]
[]
[null,"Total Current COE by Function"]
[{"$f":"A84+1","v":59},null,null,"Generation",null,null,375.34124708610494]
[{"$f":"A87+1","v":60},null,null,"Transmission",null,null,0]
[{"$f":"A88+1","v":61},null,null,"Distribution",null,null,0]
[{"$f":"A89+1","v":62},null,null,"Customer Care",null,null,1138.9216343731223]
[{"$f":"A90+1","v":63},null,null,"Corporate Groups",null,null,0]
[{"$f":"A91+1","v":64},null,null,"Total",null,null,1514.2628814592272]
[]
[null,"Heritage Payment Obligation"]
[{"$f":"A92+1","v":65},null,"Heritage Energy",null,"Line 9",null,357.59999999999997]
[{"$f":"A95+1","v":66},null,"Costs in Operating/Amortization",null,null,null,13]
[67,null,"Commodity Risk",null,null,null,0]
[68,null,"Notional Water Rentals",null,null,null,1.9]
[69,null,"Skagit and Ancillary Revenue",null,"14.0 L17",null,-16.499916335699446]
[70,null,"Load Curtailment",null,null,null,0]
[71,null,"Water License Variances",null,"5.0 L41",null,0]
[72,null,"Deferred Operating HDA",null,"5.0 L46",null,0]
[73,null,"Transfer to GMS 3 Reg Account",null,null,null,0]
[74,null,"Other",null,null,null,43.218634970390966]
[75,null,"Total",null,null,null,399.21871863469147]
[]
[{"$f":"A105+1","v":76},null,"Total System Inflow (% of Normal)",null,null,null,1]
[]
[null,"Non-Heritage COE Subject to NHDA"]
[{"$f":"A107+1","v":77},null,"Non-Heritage Cost of Energy",null,"Line 18",null,1034.0999999999999]
[{"$f":"A110+1","v":78},null,"Commodity Risk",null,null,null,0]
[79,null,"F/X Gains on Powerex Trade",null,null,null,0]
[80,null,"Less Domestic Transmission",null,"Line 16",null,0]
[81,null,"Notional Water Rental",null,"Line 68",null,-1.9]
[82,null,"Revenue Variance",null,null,null,0]
[83,null,"ROE Adjustment",null,null,null,0]
[84,null,"ABSU Founding Partner Benefits",null,null,null,0]
[85,null,"Deferred Operating NHDA",null,"5.0 L47",null,0]
[86,null,"Other",null,null,null,0]
[87,null,"F11 NSA & F12-F14 Adjustments",null,null,null,0]
[88,null,"Total",null,null,null,1032.1999999999998]
[]
[null,"IPP Summary"]
[{"$f":"A121+1","v":89},null,"IPP Costs in Non-Heritage COE",null,"Line 12",null,975.5]
[{"$f":"A124+1","v":90},null,"Less COE Impact of New Leases",null,"Line 13",null,0]
[null,null,"Existing Capital Leases"]
[{"$f":"A125+1","v":91},null,null,"Operating Costs","5.1 L13",null,33.77013204]
[{"$f":"A127+1","v":92},null,null,"Taxes","6.0 L12",null,5.7545555537904658]
[{"$f":"A128+1","v":93},null,null,"Amortization","7.0 L23",null,25.8]
[{"$f":"A129+1","v":94},null,null,"Finance Charges","8.0 L57",null,93.9]
[{"$f":"A130+1","v":95},null,null,"Total",null,null,159.22468759379046]
[null,null,"New IPP Capital Leases Under IFRS"]
[{"$f":"A131+1","v":96},null,null,"Operating Costs",null,null,0]
[{"$f":"A133+1","v":97},null,null,"Taxes",null,null,0]
[{"$f":"A134+1","v":98},null,null,"Amortization",null,null,0]
[{"$f":"A135+1","v":99},null,null,"Finance Charges",null,null,0]
[{"$f":"A136+1","v":100},null,null,"Total",null,null,0]
[]
[{"$f":"A137+1","v":101},null,"Total Costs in Revenue Requirement",null,null,null,1134.7246875937903]
[]
[{"$f":"A139+1","v":102},null,"Total Payments to IPPs",null,null,null,1130.9000000000001]
[{"$f":"A141+1","v":103},null,"Difference",null,"Line 101 - 102",null,3.8246875937902587]
[]
[null,"IPP Capital Leases"]
[null,null,"Gross Assets in Service"]
[{"$f":"A142+1","v":104},null,null,"Opening Balance",null,null,1113.2]
[{"$f":"A146+1","v":105},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A147+1","v":106},null,null,"Capital Additions",null,null,0]
[{"$f":"A148+1","v":107},null,null,"Retirements & Transfers",null,null,0]
[{"$f":"A149+1","v":108},null,null,"Closing Balance",null,null,1113.2]
[]
[null,null,"Accumulated Amortization"]
[{"$f":"A150+1","v":109},null,null,"Opening Balance",null,null,182.29900000000001]
[{"$f":"A153+1","v":110},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A154+1","v":111},null,null,"Amortization",null,null,25.8]
[{"$f":"A155+1","v":112},null,null,"Retirements & Transfers",null,null,0]
[{"$f":"A156+1","v":113},null,null,"Closing Balance",null,null,208.09900000000002]
[]
[{"$f":"A157+1","v":114},null,"Net Capital Leases (Year-End)",null,null,null,905.101]

{"sheet":"RRA 5.0","index":25,"n_rows":162,"n_cols":7,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
["Operating Costs and Provisions - Total Company"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Operating Costs by Business Group"]
[1,null,null,"Generation",null,null,298.45259562999996]
[{"$f":"A8+1","v":2},null,null,"Transmission & Distribution",null,null,335.37410418999997]
[3,null,null,"Customer Care",null,null,0]
[4,null,null,"Corporate Groups (excl PEB)",null,null,193.11159491999996]
[5,null,null,"Severance Costs",null,null,0]
[6,null,null,"Non-Current PEB - Pension",null,null,0]
[7,null,null,"Non-Current PEB - Other",null,null,0]
[8,null,null,"F09/F10 RRA Adjustments",null,null,0]
[9,null,null,"F11 RRA NSA Adjustment",null,null,0]
[10,null,null,"F12-F14 RRA Adjustment",null,null,0]
[11,null,null,"Total Before Regulatory Accounts",null,null,826.93829473999995]
[]
[null,null,"Operating Costs by Resource"]
[{"$f":"A18+1","v":12},null,null,"Labour (excl Non-Current PEB)",null,null,478.10456903999989]
[{"$f":"A21+1","v":13},null,null,"Services - ABSU",null,null,59.020211879999998]
[14,null,null,"Services - BCTC",null,null,0]
[15,null,null,"Services - Other",null,null,427.76541710000015]
[16,null,null,"Materials",null,null,40.120347510000002]
[17,null,null,"Buildings & Equipment",null,null,49.565761370000004]
[18,null,null,"Capitalized Overhead",null,null,-199.84329215]
[19,null,null,"External Recoveries",null,null,-27.794720010000002]
[20,null,null,"Severance Costs",null,null,0]
[21,null,null,"Non-Current PEB - Pension",null,null,0]
[22,null,null,"Non-Current PEB - Other",null,null,0]
[23,null,null,"F09/F10 RRA Adjustments",null,null,0]
[24,null,null,"F11 RRA NSA Adjustment",null,null,0]
[25,null,null,"F12-F14 RRA Adjustment",null,null,0]
[26,null,null,"Total Before Regulatory Accounts",null,null,826.93829473999995]
[]
[null,null,"Regulatory Account Recoveries"]
[{"$f":"A35+1","v":27},null,null,"DSM - F11 RRA NSA Adjustment",null,null,0]
[{"$f":"A38+1","v":28},null,null,"First Nation Costs",null,null,43.218634970390966]
[29,null,null,"Site C",null,null,0]
[30,null,null,"Storm Restoration",null,null,-1.3722596637575986]
[31,null,null,"PEI - F11 RRA NSA Adjustment",null,null,0]
[32,null,null,"Procurement Enhancement",null,null,0]
[33,null,null,"Capital Project Investigation",null,null,4.8310410800000003]
[34,null,null,"Net Employment Costs",null,null,0]
[35,null,null,"Smart Metering & Infrastructure",null,null,31.326242819504898]
[36,null,null,"Home Purchase Offer Plan",null,null,11.328807069918]
[37,null,null,"Non-Current Pension Cost",null,null,15.520692307692308]
[38,null,null,"IFRS PP&E",null,null,19.8289210786869]
[39,null,null,"IFRS Pension",null,null,38.238888888888887]
[40,null,null,"Total",null,null,162.92096855132436]
[]
[null,null,"Deferral Account Recoveries"]
[{"$f":"A51+1","v":41},null,null,"Water License Variances",null,null,0]
[]
[null,null,"Current IFRS Impact"]
[{"$f":"A54+1","v":42},null,null,"New IPP Capital Leases",null,null,0]
[{"$f":"A57+1","v":43},null,null,"Other Operating Costs",null,null,0]
[{"$f":"A58+1","v":44},null,null,"Total",null,null,0]
[]
[{"$f":"+A59+1","v":45},null,"Total Current Operating",null,"L 11+40+41+44",null,989.85926329132428]
[]
[null,null,"Deferral Account Additions"]
[{"$f":"A61+1","v":46},null,null,"Transfers to HDA",null,null,0]
[{"$f":"A64+1","v":47},null,null,"Transfers to NHDA",null,null,0]
[{"$f":"A65+1","v":48},null,null,"Total",null,null,0]
[]
[null,null,"Regulatory Account Additions"]
[{"$f":"A66+1","v":49},null,null,"Demand-Side Management",null,null,131.1]
[{"$f":"A69+1","v":50},null,null,"First Nations Costs",null,null,2.9809999999999999]
[{"$f":"A70+1","v":51},null,null,"Site C",null,null,0]
[{"$f":"A71+1","v":52},null,null,"Storm Restoration",null,null,0]
[{"$f":"+A72+1","v":53},null,null,"Procurement Enhancement",null,null,0]
[54,null,null,"Capital Project Investigation",null,null,0]
[55,null,null,"GM Shrum 3",null,null,0]
[56,null,null,"Smart Metering & Infrastructure",null,null,21.463255266523444]
[57,null,null,"Home Purchase Offer Plan",null,null,0]
[58,null,null,"IFRS Capitalized Overhead",null,null,134.40780000000001]
[59,null,null,"Outsourcing Implementation",null,null,0]
[60,null,null,"Bad Debt (Meziadin Lake)",null,null,0]
[61,null,null,"Total",null,null,289.95205526652342]
[]
[{"$f":"+A81+1","v":62},null,"Total Gross Operating",null,"L 11+44+48+61",null,1116.8903500065235]
[]
[null,null,"Current Operating by Business Group"]
[{"$f":"+A83+1","v":63},null,null,"Generation",null,null,303.28363670999994]
[{"$f":"+A86+1","v":64},null,null,"Transmission",null,null,222.35173497039096]
[65,null,null,"Distribution",null,null,186.19498734574725]
[66,null,null,"Customer Care",null,null,0]
[67,null,null,"Corporate Groups (excl PEB)",null,null,262.50821195749376]
[68,null,null,"Severance Costs","Line 5",null,0]
[69,null,null,"Non-Current PEB - Pension","Lines 6 + 37",null,15.520692307692308]
[70,null,null,"Non-Current PEB - Other","Line 7",null,0]
[71,null,null,"F09/F10 RRA Adjustments","Line 8",null,0]
[72,null,null,"F11 RRA NSA Adjustment","Line 9",null,0]
[73,null,null,"F12-F14 RRA Adjustment","Line 10",null,0]
[74,null,null,"Total",null,null,989.85926329132417]
[]
[null,null,"Provisions Before Regulatory Accounts"]
[{"$f":"+A97+1","v":75},null,null,"Generation",null,null,3.6181909999999999]
[{"$f":"+A100+1","v":76},null,null,"Transmission",null,null,8.3000000000000007]
[77,null,null,"Distribution",null,null,22.7]
[78,null,null,"Customer Care",null,null,0]
[79,null,null,"Corporate Groups",null,null,5.1073580000000005]
[80,null,null,"Increase in Mass Asset Rtmts",null,null,0]
[81,null,null,"FRSR Write-Off",null,null,0]
[82,null,null,"Real Property Sales",null,null,-10]
[83,null,null,"Total",null,null,29.725548999999994]
[]
[null,null,"Deferred Provisions"]
[{"$f":"+A108+1","v":84},null,null,"First Nations Provisions",null,null,0]
[{"$f":"+A111+1","v":85},null,null,"Environmental Provisions",null,null,0]
[{"$f":"+A112+1","v":86},null,null,"Arrow Water Divestiture Costs",null,null,0]
[{"$f":"+A113+1","v":87},null,null,"Arrow Water Provision",null,null,0]
[]
[{"$f":"+A114+1","v":88},null,null,"Total",null,null,0]
[]
[{"$f":"+A116+1","v":89},null,"Total Gross Provisions",null,"Lines 83 + 88",null,29.725548999999994]
[]
[null,null,"Recovery of Deferred Provisions"]
[null,null,null,"PCB Remediation"]
[{"$f":"+A118+1","v":90},null,null,"     Generation",null,null,0.31969614206722247]
[{"$f":"+A122+1","v":91},null,null,"     Transmission",null,null,7.1423315544896502]
[92,null,null,"     Distribution",null,null,5.6137471033960642]
[93,null,null,"     Corporate",null,null,0.21552728285249992]
[94,null,null,"Asbestos Remediation"]
[95,null,null,"     Generation",null,null,2.0120085348535421]
[96,null,null,"     Transmission",null,null,0.16235876501394766]
[97,null,null,"     Distribution",null,null,8.5829796960468308]
[98,null,null,"     Corporate",null,null,0]
[99,null,null,"Rock Bay Remediation",null,null,50.486034205431302]
[100,null,null,"Arrow Water Divestiture Costs",null,null,4.5141422872133097]
[101,null,null,"Arrow Water Provision",null,null,0.3]
[102,null,null,"F12-F14 Rate Smoothing",null,null,0]
[103,null,null,"Rate Smoothing",null,null,-121.2]
[104,null,null,"Total",null,null,-41.851174428635645]
[]
[{"$f":"+A136+1","v":105},null,"Total Current Provisions",null,"Lines 83 + 104",null,-12.125625428635651]
[]
[null,null,"Current Provisions by Business Group"]
[{"$f":"+A138+1","v":106},null,null,"Generation",null,null,10.764037964134076]
[{"$f":"+A141+1","v":107},null,null,"Transmission",null,null,15.6046903195036]
[{"$f":"+A142+1","v":108},null,null,"Distribution",null,null,36.896726799442895]
[{"$f":"+A143+1","v":109},null,null,"Customer Care",null,null,0]
[{"$f":"+A144+1","v":110},null,null,"Corporate Groups",null,null,-75.391080511716197]
[{"$f":"+A145+1","v":111},null,null,"Total",null,null,-12.12562542863563]
[]
[{"$f":"+A146+1","v":112},null,"Total Gross Operating & Provisions",null,null,null,1146.6158990065235]
[]
[null,null,"Total Current Operating & Provisions"]
[{"$f":"+A148+1","v":113},null,null,"Generation",null,null,314.04767467413399]
[{"$f":"+A151+1","v":114},null,null,"Transmission",null,null,237.95642528989455]
[115,null,null,"Distribution",null,null,223.09171414519014]
[116,null,null,"Customer Care",null,null,0]
[117,null,null,"Corporate Groups (excl PEB)",null,null,187.11713144577755]
[118,null,null,"Severance Costs",null,null,0]
[119,null,null,"Non-Current PEB - Pension",null,null,15.520692307692308]
[120,null,null,"Non-Current PEB - Other",null,null,0]
[121,null,null,"F09/F10 RRA Adjustments",null,null,0]
[122,null,null,"F11 RRA NSA Adjustment",null,null,0]
[123,null,null,"F12-F14 RRA Adjustment",null,null,0]
[124,null,null,"Total",null,null,977.73363786268862]

{"sheet":"RRA 5.1","index":26,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Operating Costs - Corporate Groups"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Operating Costs by KBU"]
[1,null,null,"Executive",null,null,0.94699081000000007]
[{"$f":"A8+1","v":2},null,null,"Sustainability",null,null,0]
[3,null,null,"Communications",null,null,12.217800190000002]
[4,null,null,"Customer Care and Power Smart",null,null,73.164006009999994]
[5,null,null,"Corporate Human Resources",null,null,0]
[6,null,null,"Safety, Health & Environment",null,null,0]
[7,null,null,"Human Resources",null,null,54.613135920000005]
[8,null,null,"Finance & Corporate Resources",null,null,0]
[9,null,null,"Finance & Supply Chain",null,null,64.558500280000004]
[10,null,null,"Corporate Services & General Counsel",null,null,52.588347110000001]
[11,null,null,"Energy Planning & Procurement",null,null,0]
[12,null,null,"Economic & Business Development",null,null,0]
[13,null,null,"IPP Capital Lease Operating Costs",null,null,33.77013204]
[14,null,null,"Smart Metering & Infrastructure",null,null,0]
[15,null,null,"Corporate Costs",null,null,-98.747317440000074]
[16,null,null,"Total",null,null,193.11159491999996]
[]
[null,null,"Operating Costs by Resource"]
[{"$f":"A23+1","v":17},null,null,"Labour",null,null,130.93184545999992]
[{"$f":"A26+1","v":18},null,null,"Services - ABSU",null,null,56.758511890000001]
[19,null,null,"Services - BCTC",null,null,0]
[20,null,null,"Services - Other",null,null,152.25243079000006]
[21,null,null,"Materials",null,null,15.713167610000003]
[22,null,null,"Buildings & Equipment",null,null,10.131739169999999]
[23,null,null,"Capitalized Overhead",null,null,-172.67609999999999]
[24,null,null,"External Recoveries",null,null,0]
[25,null,null,"Total",null,null,193.11159491999999]

{"sheet":"RRA 5.2","index":27,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Operating Costs - Generation"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Operating Costs by KBU"]
[1,null,null,"Engineering",null,null,6.9445869699999996]
[{"$f":"A8+1","v":2},null,null,"Dam Safety",null,null,9.4859559100000013]
[3,null,null,"Generation Asset Mgmt.",null,null,10.31628693]
[4,null,null,"Generation Project Delivery",null,null,7.3633423200000001]
[5,null,null,"Generation Operations",null,null,91.030470749999964]
[6,null,null,"Operational Safety",null,null,10.573894989999999]
[7,null,null,"Environmental Risk Management",null,null,25.586267620000001]
[8,null,null,"Generation Resource Mgmt",null,null,13.31006002]
[9,null,null,"Energy Planning & Econ Development",null,null,9.4286305000000006]
[10,null,null,"Aboriginal Relations",null,null,0]
[11,null,null,"Business Support",null,null,2.1151978899999997]
[12,null,null,"Technology",null,null,112.29790172999999]
[13,null,null,"Total",null,null,298.45259562999996]
[]
[null,null,"Operating Costs by Resource"]
[{"$f":"A20+1","v":14},null,null,"Labour",null,null,137.23733369999999]
[{"$f":"A23+1","v":15},null,null,"Services - ABSU",null,null,0.52969999999999995]
[16,null,null,"Services - BCTC",null,null,0]
[17,null,null,"Services - Other",null,null,139.73600160000004]
[18,null,null,"Materials",null,null,9.7065574800000007]
[19,null,null,"Buildings & Equipment",null,null,31.397353210000002]
[20,null,null,"Capitalized Overhead",null,null,-2.2592004000000006]
[21,null,null,"External Recoveries",null,null,-17.895149960000001]
[22,null,null,"Total",null,null,298.45259563000002]

{"sheet":"RRA 5.4","index":28,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Operating Costs - Transmission & Distribution"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Operating Costs by KBU"]
[1,null,null,"Distribution Operations",null,null,0]
[{"$f":"A8+1","v":2},null,null,"Transmission & Construction Services",null,null,0]
[3,null,null,"Operational Support Services",null,null,0]
[4,null,null,"Transmission Owner",null,null,0]
[5,null,null,"Field Operations & Safety",null,null,110.35406233999998]
[6,null,null,"Grid Operations",null,null,37.385254959999997]
[7,null,null,"Asset Investment Management",null,null,147.05234041]
[8,null,null,"Project & Program Delivery",null,null,14.54222087]
[9,null,null,"Engineering and Design",null,null,22.454768609999999]
[10,null,null,"Aboriginal Relations",null,null,5.06645871]
[11,null,null,"Smart Metering & Infrastructure",null,null,0]
[12,null,null,"Business Support",null,null,-1.4810017100000008]
[13,null,null,"Total",null,null,335.37410418999997]
[]
[null,null,"Operating Costs by Resource"]
[{"$f":"A20+1","v":14},null,null,"Labour",null,null,209.93538988000003]
[{"$f":"A23+1","v":15},null,null,"Services - ABSU",null,null,1.7319999900000003]
[16,null,null,"Services - BCTC",null,null,0]
[17,null,null,"Services - Other",null,null,135.77698471000005]
[18,null,null,"Materials",null,null,14.700622419999998]
[19,null,null,"Buildings & Equipment",null,null,8.036668989999999]
[20,null,null,"Capitalized Overhead",null,null,-24.907991750000001]
[21,null,null,"External Recoveries",null,null,-9.8995700500000012]
[22,null,null,"Total",null,null,335.37410419000003]
[]
[null,null,"Operating Costs by Function"]
[{"$f":"A31+1","v":23},null,null,"Allocation to Transmission (%)",null,null,0.53412919412083015]
[]
[{"$f":"A34+1","v":24},null,null,"Transmission",null,null,179.13310000000001]
[{"$f":"A36+1","v":25},null,null,"Distribution",null,null,156.24100418999996]
[{"$f":"A37+1","v":26},null,null,"Total",null,null,335.37410418999997]

{"sheet":"RRA 6.0","index":29,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Taxes"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Generation"]
[1,null,null,"Grants in Lieu",null,null,24.317]
[{"$f":"A8+1","v":2},null,null,"School Taxes",null,null,18.751999999999999]
[{"$f":"A9+1","v":3},null,null,"Total",null,null,43.069000000000003]
[]
[null,null,"Transmission"]
[{"$f":"A10+1","v":4},null,null,"Grants in Lieu",null,null,46.787999999999997]
[{"$f":"A13+1","v":5},null,null,"School Taxes",null,null,85.174999999999997]
[{"$f":"A14+1","v":6},null,null,"Total",null,null,131.96299999999999]
[]
[null,null,"Distribution"]
[{"$f":"A15+1","v":7},null,null,"Grants in Lieu",null,null,7.1890000000000001]
[{"$f":"A18+1","v":8},null,null,"School Taxes",null,null,20.396999999999998]
[{"$f":"A19+1","v":9},null,null,"Total",null,null,27.585999999999999]
[]
[null,null,"Customer Care"]
[{"$f":"A20+1","v":10},null,null,"Grants in Lieu",null,null,0]
[{"$f":"A23+1","v":11},null,null,"School Taxes",null,null,0]
[{"$f":"A24+1","v":12},null,null,"Existing IPP Capital Leases",null,null,5.7545555537904658]
[{"$f":"A25+1","v":13},null,null,"New Capital Leases Under IFRS",null,null,0]
[{"$f":"A26+1","v":14},null,null,"Total",null,null,5.7545555537904658]
[]
[null,null,"Corporate Groups"]
[{"$f":"A27+1","v":15},null,null,"Grants in Lieu",null,null,10.175999999999998]
[{"$f":"A30+1","v":16},null,null,"School Taxes",null,null,5.5820000000000007]
[{"$f":"A31+1","v":17},null,null,"Total",null,null,15.757999999999999]
[]
[null,null,"Total Before Regulatory Accounts"]
[{"$f":"A32+1","v":18},null,null,"Grants in Lieu",null,null,88.47]
[{"$f":"A35+1","v":19},null,null,"School Taxes",null,null,129.90600000000001]
[{"$f":"A36+1","v":20},null,null,"IPP Capital Leases",null,null,5.7545555537904658]
[{"$f":"A37+1","v":21},null,null,"Total",null,null,224.13055555379046]
[]
[null,null,"Regulatory Account Recoveries"]
[{"$f":"A38+1","v":22},null,null,"Generation",null,null,0]
[{"$f":"A41+1","v":23},null,null,"Transmission",null,null,0]
[{"$f":"A42+1","v":24},null,null,"Distribution",null,null,0]
[{"$f":"A43+1","v":25},null,null,"Customer Care",null,null,0]
[{"$f":"A44+1","v":26},null,null,"Corporate Groups",null,null,0]
[{"$f":"A45+1","v":27},null,null,"Total",null,null,0]
[]
[{"$f":"A46+1","v":28},null,"Total Current Taxes",null,"Lines 21+27",null,224.13055555379046]
[]
[{"$f":"A48+1","v":29},null,"Total Gross Taxes",null,"Line 21",null,224.13055555379046]
[]
[null,null,"Total Current Taxes by Business Group"]
[{"$f":"A50+1","v":30},null,null,"Generation",null,null,43.069000000000003]
[{"$f":"A53+1","v":31},null,null,"Transmission",null,null,131.96299999999999]
[{"$f":"A54+1","v":32},null,null,"Distribution",null,null,27.585999999999999]
[{"$f":"A55+1","v":33},null,null,"Customer Care",null,null,5.7545555537904658]
[{"$f":"A56+1","v":34},null,null,"Corporate Groups",null,null,15.757999999999999]
[{"$f":"A57+1","v":35},null,null,"Total",null,null,224.13055555379046]

{"sheet":"RRA 7.0","index":30,"n_rows":101,"n_cols":7,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Depreciation and Amortization"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Amortization of Capital Assets"]
[1,null,null,"Generation","12.2 L8+9",null,257.42]
[{"$f":"A8+1","v":2},null,null,"Transmission","12.4 L8+9+10",null,178.804]
[{"$f":"A9+1","v":3},null,null,"Distribution","12.5 L8+9",null,225.33]
[{"$f":"A10+1","v":4},null,null,"Customer Care","12.3 L8+9",null,0]
[{"$f":"A11+1","v":5},null,null,"Corporate Groups","12.1 L8+9",null,39.476999999999997]
[{"$f":"A12+1","v":6},null,null,"Total",null,null,701.03100000000006]
[]
[null,null,"Amortization of Contributions"]
[{"$f":"A13+1","v":7},null,null,"Generation",null,null,0]
[{"$f":"A16+1","v":8},null,null,"Transmission",null,null,0]
[{"$f":"A17+1","v":9},null,null,"Distribution",null,null,0]
[{"$f":"A18+1","v":10},null,null,"Total",null,null,0]
[]
[null,null,"Dismantling Costs"]
[{"$f":"A19+1","v":11},null,null,"Generation",null,null,9.5370000000000008]
[{"$f":"A22+1","v":12},null,null,"Transmission",null,null,10.696]
[{"$f":"A23+1","v":13},null,null,"Distribution",null,null,10.938000000000001]
[{"$f":"A24+1","v":14},null,null,"Customer Care",null,null,0]
[{"$f":"A25+1","v":15},null,null,"Corporate Groups",null,null,0]
[{"$f":"A26+1","v":16},null,null,"Total",null,null,31.170999999999999]
[]
[null,null,"Capital Asset Write-Offs"]
[{"$f":"A27+1","v":17},null,null,"Generation",null,null,0]
[{"$f":"A30+1","v":18},null,null,"Transmission",null,null,0]
[{"$f":"A31+1","v":19},null,null,"Distribution",null,null,0]
[{"$f":"A32+1","v":20},null,null,"Customer Care",null,null,0]
[{"$f":"A33+1","v":21},null,null,"Corporate Groups",null,null,0]
[{"$f":"A34+1","v":22},null,null,"Total",null,null,0]
[]
[null,null,"IPP Capital Leases"]
[{"$f":"A35+1","v":23},null,null,"Existing IPP Capital Leases",null,null,25.8]
[{"$f":"A38+1","v":24},null,null,"New Capital Leases Under IFRS",null,null,0]
[{"$f":"A39+1","v":25},null,null,"Total",null,null,25.8]
[]
[{"$f":"A40+1","v":26},null,"Other Net IFRS Impact",null,null,null,0]
[]
[null,null,"Regulatory Account Additions"]
[{"$f":"A42+1","v":27},null,null,"F07/F08 RRA Depn Study",null,null,0]
[{"$f":"A45+1","v":28},null,null,"Deferred SMI Amortization",null,null,0]
[{"$f":"A46+1","v":29},null,null,"Deferred Environmental Liability",null,null,0]
[{"$f":"A47+1","v":30},null,null,"Total",null,null,0]
[]
[{"$f":"A48+1","v":31},null,"Total Gross Amortization",null,null,null,758.00200000000007]
[]
[null,null,"Other Regulatory Account Additions"]
[{"$f":"A50+1","v":32},null,null,"Deferred PEI Amortization",null,null,0]
[{"$f":"A53+1","v":33},null,null,"Deferred SMI Amortization",null,null,0]
[{"$f":"A54+1","v":34},null,null,"Total",null,null,0]
[]
[null,null,"Regulatory Account Recoveries"]
[]
[null,null,null,"DSM Amortization"]
[{"$f":"A55+1","v":35},null,null,"Generation - 90%","2.2 L5+6",null,74.978780598]
[{"$f":"A60+1","v":36},null,null,"Transmission - 10%","2.2 L5+6",null,8.3309756220000004]
[{"$f":"A61+1","v":37},null,null,"Total",null,null,83.309756219999997]
[]
[null,null,null,"Depn Study Amortization"]
[{"$f":"A62+1","v":38},null,null,"Generation",null,null,0]
[{"$f":"A65+1","v":39},null,null,"Transmission",null,null,0]
[{"$f":"A66+1","v":40},null,null,"Distribution",null,null,0]
[{"$f":"A67+1","v":41},null,null,"Customer Care",null,null,0]
[{"$f":"A68+1","v":42},null,null,"Corporate",null,null,0]
[{"$f":"A69+1","v":43},null,null,"Total",null,null,0]
[]
[null,null,null,"FRSR Amortization"]
[{"$f":"A70+1","v":44},null,null,"Generation","Line 11",null,-9.5370000000000008]
[{"$f":"A73+1","v":45},null,null,"Transmission","Line 12",null,-10.696]
[46,null,null,"Distribution","Line 13",null,-10.938000000000001]
[47,null,null,"Customer Care","Line 14",null,0]
[48,null,null,"Corporate Groups","Line 15",null,0]
[49,null,null,"Adjustment",null,null,0]
[50,null,null,"Total",null,null,-31.170999999999999]
[]
[{"$f":"A79+1","v":51},null,null,"Pre-1996 CIAC Amortization",null,null,-4.6900000000000004]
[]
[null,null,null,"Capital Additions Regulatory Account"]
[{"$f":"A81+1","v":52},null,null,"Generation",null,null,0]
[{"$f":"A84+1","v":53},null,null,"Transmission",null,null,0]
[{"$f":"A85+1","v":54},null,null,"Distribution",null,null,0]
[{"$f":"A86+1","v":55},null,null,"Customer Care",null,null,0]
[{"$f":"A87+1","v":56},null,null,"Corporate Groups",null,null,-9.4190630110050702]
[{"$f":"A88+1","v":57},null,null,"Total",null,null,-9.4190630110050702]
[]
[{"$f":"A89+1","v":58},null,null,"Total Recoveries",null,null,38.029693208994928]
[]
[{"$f":"A91+1","v":59},null,"Total Current Amortization",null,null,null,796.03169320899497]
[]
[null,null,"Current Amortization by Business Group"]
[{"$f":"A93+1","v":60},null,null,"Generation",null,null,332.39878059800003]
[{"$f":"A96+1","v":61},null,null,"Transmission",null,null,187.13497562200001]
[{"$f":"A97+1","v":62},null,null,"Distribution",null,null,220.64000000000001]
[{"$f":"A98+1","v":63},null,null,"Customer Care",null,null,25.8]
[{"$f":"A99+1","v":64},null,null,"Corporate Groups",null,null,30.057936988994925]
[{"$f":"A100+1","v":65},null,null,"Total",null,null,796.03169320899485]

{"sheet":"RRA 8.0","index":31,"n_rows":144,"n_cols":7,"rows_kept":144,"cut":false,"hidden":false,"merged":[]}
["Finance Charges"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Increase in Cash"]
[1,null,null,"Net Income","9.0 L52",null,651.85107129458243]
[{"$f":"A8+1","v":2},null,null,"Dividend (One Year Lag)","9.0 L4",null,-278.57157335995544]
[3,null,null,"Amortization","7.0 L31",null,758.00200000000007]
[4,null,null,"Deferral Account Additions","2.1 L33",null,0]
[5,null,null,"Deferral Account Recoveries","2.1 L35",null,222.99174682993481]
[6,null,null,"Regulatory Account Additions","2.2 L212",null,-310.28880000000004]
[7,null,null,"Regulatory Account Recoveries","2.2 L214",null,132.85682538930655]
[8,null,null,"First Nations Provisions","2.2 L16",null,0]
[9,null,null,"Environmental Provisions","2.2 L126",null,0]
[10,null,null,"Capital Expenditures","13.0 L17-16",null,-1939.18]
[11,null,null,"Contributions in Aid","11.0 L49",null,124.1]
[12,null,null,"Change in Sinking Funds","Line 16",null,0.1]
[13,null,null,"Change in Working Cap & Other",null,null,-136.86127015386683]
[14,null,null,"Total",null,null,-774.99999999999841]
[]
[null,null,"Sinking Funds"]
[{"$f":"A21+1","v":15},null,null,"Beginning of Year",null,null,125.19999999999982]
[{"$f":"A24+1","v":16},null,null,"Change in Sinking Funds",null,null,-0.1]
[{"$f":"A25+1","v":17},null,null,"Sinking Fund Income",null,null,4.2]
[{"$f":"A26+1","v":18},null,null,"End of Year",null,null,129.29999999999981]
[{"$f":"A27+1","v":19},null,null,"Mid-Year Balance",null,null,127.24999999999991]
[]
[null,null,"Long-Term Debt"]
[{"$f":"A28+1","v":20},null,null,"Beginning of Year",null,null,12743.1]
[{"$f":"A31+1","v":21},null,null,"Adjustment to Opening Balance",null,null,0]
[22,null,null,"Bonds Retired",null,null,-150]
[23,null,null,"Bonds Issued",null,null,0]
[24,null,null,"Bonds Planned Issues",null,null,800]
[25,null,null,"Revaluation of US $ Debt",null,null,-1.2]
[26,null,null,"Revaluation to Fair Value",null,null,0]
[27,null,null,"Premiums/(Discounts) on Issues",null,null,0]
[28,null,null,"Amortization of Issue Costs",null,null,-12.5]
[29,null,null,"End of Year",null,null,13379.4]
[30,null,null,"Mid-Year Balance",null,null,13061.25]
[]
[{"$f":"A41+1","v":31},null,null,"Interest Rate - Planned Issues",null,null,0.05]
[]
[{"$f":"A43+1","v":32},null,null,"Debt Costs - Excluding Planned",null,null,608.4]
[{"$f":"A45+1","v":33},null,null,"Debt Costs - Planned Issues",null,null,68.599999999999994]
[{"$f":"A46+1","v":34},null,null,"Total Long-Term Debt Costs",null,null,677]
[]
[null,null,"Short-Term Debt"]
[{"$f":"A47+1","v":35},null,null,"Beginning of Year",null,null,4164.3149413086649]
[{"$f":"A50+1","v":36},null,null,"Increase in Cash Requirement","Line 14",null,774.99999999999841]
[{"$f":"A51+1","v":37},null,null,"Change in Long-Term Debt","Line 20-29",null,-636.29999999999927]
[{"$f":"A52+1","v":38},null,null,"End of Year",null,null,4303.0149413086638]
[{"$f":"A53+1","v":39},null,null,"Mid-Year Balance",null,null,4233.6649413086616]
[]
[{"$f":"A54+1","v":40},null,null,"Interest Rate",null,null,2.23E-2]
[]
[{"$f":"A56+1","v":41},null,null,"Debt Costs - Interest",null,null,94.410728191183154]
[{"$f":"A58+1","v":42},null,null,"Debt Costs - Other",null,null,-0.21072819118323594]
[{"$f":"A59+1","v":43},null,null,"Total Short-Term Debt Costs",null,null,94.199999999999918]
[]
[null,null,"Interest Capitalized"]
[{"$f":"A60+1","v":44},null,null,"Unfinished Construction","13.0 L51",null,2387.427571187297]
[{"$f":"A63+1","v":45},null,null,"Less Not Subject to IDC",null,null,-1016.3257188706771]
[{"$f":"A64+1","v":46},null,null,"Unfinished Subject to IDC",null,null,1371.1018523166199]
[]
[{"$f":"A65+1","v":47},null,null,"Interest Rate","Line 104",null,4.4708567708830096E-2]
[]
[{"$f":"A67+1","v":48},null,null,"Interest Capitalized",null,null,61.299999999999962]
[]
[null,null,"Total Before Regulatory Accounts"]
[{"$f":"A69+1","v":49},null,null,"Sinking Fund Income","Line 17",null,-4.2]
[{"$f":"A72+1","v":50},null,null,"Long-Term Debt Costs","Line 34",null,677]
[51,null,null,"Short-Term Debt Costs","Line 43",null,94.199999999999918]
[52,null,null,"Interest Capitalized","Line 48",null,-61.299999999999983]
[53,null,null,"Swaps",null,null,0]
[54,null,null,"Other (Income) / Loss",null,null,13.6]
[55,null,null,"Deferred SMI Finance Charges",null,null,0]
[56,null,null,"Deferred HPOP Finance Charges",null,null,0]
[57,null,null,"Existing IPP Capital Leases",null,null,93.9]
[58,null,null,"New Capital Leases Under IFRS",null,null,0]
[59,null,null,"IFRS Reduced IDC Capitalized",null,null,0]
[60,null,null,"Accretion - ARO",null,null,1.3282225574650823]
[61,null,null,"Non-Current PEB",null,null,0.1]
[62,null,null,"F2013 Correction",null,null,0]
[63,null,null,"Total",null,null,814.62822255746505]
[]
[null,null,"Interest on Regulatory Accounts"]
[{"$f":"A86+1","v":64},null,null,"Interest on Deferral Accounts","2.1 L34",null,-23.794683373174841]
[{"$f":"A89+1","v":65},null,null,"Interest on Other Reg Accounts","2.2 L213",null,-37.944519165489261]
[{"$f":"A90+1","v":66},null,null,"Total",null,null,-61.739202538664102]
[]
[null,null,"Regulatory Account Recoveries"]
[{"$f":"A91+1","v":67},null,null,"Amort. of FX Gains/Losses",null,null,-0.7]
[{"$f":"A94+1","v":68},null,null,"Non-Current Pension",null,null,0]
[{"$f":"A95+1","v":69},null,null,"Total Finance Charges",null,null,-25.542661942377102]
[{"$f":"A96+1","v":70},null,null,"Total",null,null,-26.242661942377101]
[]
[{"$f":"A97+1","v":71},null,"Total Current Finance Chrgs",null,"L 63+66+70",null,726.64635807642378]
[]
[null,null,"Regulatory Account Additions"]
[{"$f":"A99+1","v":72},null,null,"FX Gains/Losses",null,null,-0.1]
[{"$f":"A102+1","v":73},null,null,"Net SMI Impact",null,null,0]
[74,null,null,"Deferred HPOP Finance Chges","Line 56",null,0]
[75,null,null,"IFRS Reduced IDC Capitalized",null,null,0]
[76,null,null,"Accretion - First Nations",null,null,17.7]
[77,null,null,"Accretion - Environmental",null,null,6]
[78,null,null,"Accretion - Arrow Water",null,null,0.1]
[79,null,null,"Total",null,null,23.7]
[]
[{"$f":"A109+1","v":80},null,"Total Gross Finance Charges",null,"Lines 63+79",null,838.3282225574651]
[]
[null,null,"Portion of Rate Base"]
[{"$f":"A111+1","v":81},null,null,"Generation","10.0 L28",null,0.42273661713657146]
[{"$f":"A114+1","v":82},null,null,"Transmission","10.0 L29",null,0.32068650311854957]
[{"$f":"A115+1","v":83},null,null,"Distribution","10.0 L30",null,0.25657866241870519]
[{"$f":"A116+1","v":84},null,null,"Customer Care","10.0 L31",null,-1.7826738263246658E-6]
[{"$f":"A117+1","v":85},null,null,"Corporate Groups",null,null,0]
[{"$f":"A118+1","v":86},null,null,"Total",null,null,1]
[]
[null,null,"Allocation of Current Finance Charges"]
[{"$f":"A119+1","v":87},null,null,"Generation",null,null,307.18002326783716]
[{"$f":"A122+1","v":88},null,null,"Transmission",null,null,233.02567957535777]
[{"$f":"A123+1","v":89},null,null,"Distribution",null,null,186.44195060667232]
[{"$f":"A124+1","v":90},null,null,"Customer Care",null,null,-1.2953734435369817E-3]
[{"$f":"A125+1","v":91},null,null,"Corporate Groups",null,null,0]
[{"$f":"A126+1","v":92},null,null,"Total",null,null,726.64635807642367]
[]
[null,null,"Net Debt"]
[{"$f":"A127+1","v":93},null,null,"Sinking Funds","Line 18",null,-129.29999999999981]
[{"$f":"A130+1","v":94},null,null,"Temporary Investments",null,null,-10]
[95,null,null,"Long-Term Debt","Line 29",null,13379.4]
[96,null,null,"Short-Term Debt","Line 38",null,4303.0149413086638]
[97,null,null,"Subtotal",null,null,17543.114941308664]
[98,null,null,"IDC Adjustments",null,null,96.21820237375141]
[99,null,null,"End of Year",null,null,17639.333143682416]
[100,null,null,"Mid-Year Balance",null,null,17249.657145310808]
[]
[null,null,"Weighted Average Cost of Debt"]
[{"$f":"A137+1","v":101},null,null,"Total Gross Finance Charges",null,null,838.3282225574651]
[{"$f":"A140+1","v":102},null,null,"IDC Adjustments",null,null,-67.120758122231905]
[{"$f":"A141+1","v":103},null,null,"Total",null,null,771.20746443523319]
[]
[{"$f":"A142+1","v":104},null,null,"Weighted Average Cost of Debt",null,null,4.4708567708830096E-2]

{"sheet":"RRA 9.0","index":32,"n_rows":98,"n_cols":7,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Return on Equity"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Shareholder's Equity"]
[1,null,null,"Retained Earnings - Begining of Year",null,null,4122.6497353271679]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[3,null,null,"Gross Return on Equity","Line 52",null,651.85107129458243]
[4,null,null,"Dividend to Province","Line 16",null,-459.12607129458502]
[5,null,null,"Distribution to Province",null,null,0]
[6,null,null,"Retained Earnings - End of Year",null,null,4315.3747353271656]
[7,null,null,"Accum Other Comp Income",null,null,70.403999999999996]
[8,null,null,"OCI Deferred (Pension)",null,null,0]
[9,null,null,"Total Shareholder's Equity",null,null,4385.7787353271651]
[]
[null,null,"Dividend to Province"]
[{"$f":"A16+1","v":10},null,null,"Net Income","Line 52",null,651.85107129458243]
[{"$f":"A19+1","v":11},null,null,"IDC (net of amortization)",null,null,0]
[{"$f":"A20+1","v":12},null,null,"Distributable Surplus",null,null,651.85107129458243]
[]
[{"$f":"A21+1","v":13},null,null,"Maximum Dividend Percentage",null,null,0.85]
[{"$f":"A23+1","v":14},null,null,"Maximum Dividend Amount",null,null,554.07341060039505]
[]
[{"$f":"A24+1","v":15},null,null,"Minimum Equity Percentage",null,null,0.2]
[]
[{"$f":"A26+1","v":16},null,null,"Dividend to Province",null,null,459.12607129458502]
[]
[null,null,"Deferred Revenue"]
[{"$f":"A28+1","v":17},null,null,"Skagit - Beginning of Year"]
[{"$f":"A31+1","v":18},null,null,"Payments Received"]
[{"$f":"A32+1","v":19},null,null,"Interest"]
[{"$f":"A33+1","v":20},null,null,"Revenues Earned"]
[{"$f":"A34+1","v":21},null,null,"Skagit - End of Year"]
[]
[null,null,"Return on Equity"]
[{"$f":"A35+1","v":22},null,null,"Shareholder's Equity","Line 9"]
[{"$f":"A38+1","v":23},null,null,"Deferred Revenue","Line 21"]
[24,null,null,"Contributions - Columbia River"]
[25,null,null,"Contributions - EARG"]
[26,null,null,"Contributions - Field Operations"]
[27,null,null,"Contributions - Transmission"]
[28,null,null,"Pre-1996 CIAC Adjustment"]
[29,null,null,"Total Equity"]
[]
[null,null,"Capitalization"]
[{"$f":"A45+1","v":30},null,null,"Net Debt","8.0 L97",null,17543.114941308664]
[{"$f":"A48+1","v":31},null,null,"Shareholder's Equity","Line 9",null,4385.7787353271651]
[{"$f":"A49+1","v":32},null,null,"Total",null,null,21928.893676635831]
[]
[null,null,"Capital Structure"]
[{"$f":"A50+1","v":33},null,null,"Net Debt",null,null,0.79999999999999993]
[{"$f":"A53+1","v":34},null,null,"Equity",null,null,0.19999999999999996]
[{"$f":"A54+1","v":35},null,null,"Total",null,null,1]
[]
[null,null,"Deemed Equity"]
[{"$f":"A55+1","v":36},null,null,"Rate Base","10.0 L26",null,19215.897665093336]
[{"$f":"A58+1","v":37},null,null,"Pre-1996 Customer Contns","2.2 L42",null,-92.127999999999986]
[38,null,null,"Powerex & Powertech Assets",null,null,26.6]
[39,null,null,"Columbia River Treaty Contns","11.0 L10",null,0]
[40,null,null,"Allowance for Working Capital",null,null,250]
[41,null,null,"Total",null,null,19400.369665093334]
[42,null,null,"Deemed Equity Percentage",null,null,0.3]
[43,null,null,"Year-End Deemed Equity",null,null,5820.1108995280001]
[44,null,null,"Mid-Year Deemed Equity",null,null,5505.4989129610003]
[]
[{"$f":"A66+1","v":45},null,null,"Achieved ROE"]
[{"$f":"A68+1","v":46},null,null,"Allowed ROE",null,null,0.11840000000000001]
[47,null,null,"Return on Equity",null,null,651.85107129458243]
[48,null,null,"F11 RRA NSA Adjustment",null,null,0]
[49,null,null,"Amortize PEI Reg Acct",null,null,0]
[50,null,null,"IFRS ROE Impact",null,null,0]
[51,null,null,"Deferred SMI ROE",null,null,0]
[52,null,null,"Gross Return on Equity",null,null,651.85107129458243]
[]
[null,null,"F2010 ROE Regulatory Account Transfers"]
[{"$f":"A75+1","v":53},null,null,"Additions",null,null,0]
[{"$f":"A78+1","v":54},null,null,"Recoveries",null,null,0]
[{"$f":"A79+1","v":55},null,null,"Total",null,null,0]
[]
[{"$f":"A80+1","v":56},null,"Current Return on Equity",null,null,null,651.85107129458243]
[]
[null,null,"Portion of Rate Base"]
[{"$f":"A82+1","v":57},null,null,"Generation","10.0 L28",null,0.42273661713657146]
[{"$f":"A85+1","v":58},null,null,"Transmission","10.0 L29",null,0.32068650311854957]
[{"$f":"A86+1","v":59},null,null,"Distribution","10.0 L30",null,0.25657866241870519]
[{"$f":"A87+1","v":60},null,null,"Customer Care","10.0 L31",null,-1.7826738263246658E-6]
[{"$f":"A88+1","v":61},null,null,"Corporate Groups",null,null,0]
[{"$f":"A89+1","v":62},null,null,"Total",null,null,1]
[]
[null,null,"Allocation of ROE"]
[{"$f":"A90+1","v":63},null,null,"Generation",null,null,275.56131675592184]
[{"$f":"A93+1","v":64},null,null,"Transmission",null,null,209.03984060753999]
[{"$f":"A94+1","v":65},null,null,"Distribution",null,null,167.25107596896399]
[{"$f":"A95+1","v":66},null,null,"Customer Care",null,null,-1.1620378434585457E-3]
[{"$f":"A96+1","v":67},null,null,"Corporate Groups",null,null,0]
[{"$f":"A97+1","v":68},null,null,"Total",null,null,651.85107129458243]

{"sheet":"RRA 10.0","index":33,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Rate Base"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Generation"]
[1,null,null,"Net Assets in Service","12.2 L15",null,6732.616]
[{"$f":"A8+1","v":2},null,null,"Net Contributions","11.0 L21",null,-2.3079999999999998]
[{"$f":"A9+1","v":3},null,null,"90% of Net DSM","2.2 L7",null,851.01539858399997]
[{"$f":"A10+1","v":4},null,null,"Total",null,null,7581.3233985839997]
[{"$f":"A11+1","v":5},null,null,"Mid-Year",null,null,7351.2242888829996]
[]
[null,null,"Transmission"]
[{"$f":"A12+1","v":6},null,null,"Net Assets in Service","12.4 L15",null,6535.7420000000011]
[{"$f":"A15+1","v":7},null,null,"Net Contributions","11.0 L32",null,-324.34499999999997]
[{"$f":"A16+1","v":8},null,null,"10% of Net DSM","2.2 L7",null,94.557266509333331]
[{"$f":"A17+1","v":9},null,null,"Total",null,null,6305.954266509334]
[{"$f":"A18+1","v":10},null,null,"Mid-Year",null,null,5576.612754320332]
[]
[null,null,"Distribution"]
[{"$f":"A19+1","v":11},null,null,"Net Assets in Service","12.5 L16",null,5493.8209999999999]
[{"$f":"A22+1","v":12},null,null,"Net Contributions","11.0 L46",null,-984.61899999999991]
[{"$f":"A23+1","v":13},null,null,"Total",null,null,4509.2020000000002]
[{"$f":"A24+1","v":14},null,null,"Mid-Year",null,null,4461.8024999999998]
[]
[null,null,"Customer Care"]
[{"$f":"A25+1","v":15},null,null,"Net Assets in Service","12.3 L14",null,-3.1000000000000361E-2]
[{"$f":"A28+1","v":16},null,null,"Net Contributions","N/A",null,0]
[{"$f":"A29+1","v":17},null,null,"Total",null,null,-3.1000000000000361E-2]
[{"$f":"A30+1","v":18},null,null,"Mid-Year",null,null,-3.1000000000000381E-2]
[]
[null,null,"Corporate Groups"]
[{"$f":"A31+1","v":19},null,null,"Net Assets in Service","12.1 L14",null,819.44899999999996]
[{"$f":"A34+1","v":20},null,null,"Net Contributions","N/A",null,0]
[{"$f":"A35+1","v":21},null,null,"Total",null,null,819.44899999999996]
[{"$f":"A36+1","v":22},null,null,"Mid-Year",null,null,776.33749999999998]
[]
[null,null,"Total"]
[{"$f":"A37+1","v":23},null,null,"Net Assets in Service","12.0 L17",null,19581.597000000002]
[{"$f":"A40+1","v":24},null,null,"Net Contributions","11.0 L60",null,-1311.2719999999999]
[{"$f":"A41+1","v":25},null,null,"Net DSM","2.2 L7",null,945.57266509333328]
[{"$f":"A42+1","v":26},null,null,"Total",null,null,19215.897665093336]
[{"$f":"A43+1","v":27},null,null,"Mid-Year",null,null,18165.946043203334]
[]
[null,null,"Portion of Rate Base"]
[{"$f":"A44+1","v":28},null,null,"Generation",null,null,0.42273661713657146]
[{"$f":"A47+1","v":29},null,null,"Transmission",null,null,0.32068650311854957]
[{"$f":"A48+1","v":30},null,null,"Distribution",null,null,0.25657866241870519]
[{"$f":"A49+1","v":31},null,null,"Customer Care",null,null,-1.7826738263246658E-6]
[{"$f":"A50+1","v":32},null,null,"Corporate Groups",null,null,0]
[{"$f":"A51+1","v":33},null,null,"Total",null,null,1]

{"sheet":"RRA 12.1","index":34,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Assets - Corporate Groups"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Gross Assets in Service"]
[1,null,null,"Opening Balance",null,null,860.91700000000003]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A9+1","v":3},null,null,"Capital Additions","13.0 L44",null,125.69999999999999]
[{"$f":"A10+1","v":4},null,null,"Retirements & Transfers",null,null,0]
[{"$f":"A11+1","v":5},null,null,"Closing Balance",null,null,986.61699999999996]
[]
[null,null,"Accumulated Amortization"]
[{"$f":"A12+1","v":6},null,null,"Opening Balance",null,null,127.69099999999999]
[{"$f":"A15+1","v":7},null,null,"Adjustment to Opening Balance",null,null,0]
[8,null,null,"Amort on March 2014 Assets",null,null,31.685999999999996]
[9,null,null,"Amortization on Additions","13.0 L78",null,7.7909999999999995]
[10,null,null,"Capital Asset Write-Offs",null,null,0]
[11,null,null,"Depn Study Adjustment",null,null,0]
[12,null,null,"Retirements & Transfers",null,null,0]
[13,null,null,"Closing Balance",null,null,167.16799999999998]
[]
[{"$f":"A22+1","v":14},null,"Net Assets in Service (Year-End)",null,null,null,819.44899999999996]

{"sheet":"RRA 12.2","index":35,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Assets - Generation"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Gross Assets in Service"]
[1,null,null,"Opening Balance",null,null,7244.2199999999993]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A9+1","v":3},null,null,"Capital Additions","13.0 L40",null,677.90700000000004]
[{"$f":"A10+1","v":4},null,null,"Retirements & Transfers",null,null,-3.7]
[{"$f":"A11+1","v":5},null,null,"Closing Balance",null,null,7918.4269999999997]
[]
[null,null,"Accumulated Amortization"]
[{"$f":"A12+1","v":6},null,null,"Opening Balance",null,null,928.39099999999996]
[{"$f":"A15+1","v":7},null,null,"Adjustment to Opening Balance",null,null,0]
[8,null,null,"Amort on March 2014 Assets",null,null,220.82837540000003]
[9,null,null,"Amortization on Additions","13.0 L74",null,36.591624599999996]
[10,null,null,"Amort on CRT Contribution",null,null,0]
[11,null,null,"Capital Asset Write-Offs",null,null,0]
[12,null,null,"Depn Study Adjustment",null,null,0]
[13,null,null,"Retirements & Transfers",null,null,0]
[14,null,null,"Closing Balance",null,null,1185.8109999999999]
[]
[{"$f":"A23+1","v":15},null,"Net Assets in Service (Year-End)",null,null,null,6732.616]

{"sheet":"RRA 12.4","index":36,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Assets - Transmission"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Gross Assets in Service"]
[1,null,null,"Opening Balance",null,null,5610.9500000000007]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A9+1","v":3},null,null,"Capital Additions","13.0 L41",null,1680.1150000000002]
[{"$f":"A10+1","v":4},null,null,"Retirements & Transfers",null,null,-9.0069999999999997]
[{"$f":"A11+1","v":5},null,null,"Closing Balance",null,null,7282.0580000000009]
[]
[null,null,"Accumulated Amortization"]
[{"$f":"A12+1","v":6},null,null,"Opening Balance",null,null,567.51200000000017]
[{"$f":"A15+1","v":7},null,null,"Adjustment to Opening Balance",null,null,0]
[8,null,null,"Amort on March 2014 Assets",null,null,132.4980716]
[9,null,null,"Amortization on Additions","13.0 L75",null,46.305928399999999]
[10,null,null,"Amortization Adjustment",null,null,0]
[11,null,null,"Capital Asset Write-Offs",null,null,0]
[12,null,null,"Depn Study Adjustment",null,null,0]
[13,null,null,"Retirements & Transfers",null,null,0]
[14,null,null,"Closing Balance",null,null,746.31600000000014]
[]
[{"$f":"A23+1","v":15},null,"Net Assets in Service (Year-End)",null,null,null,6535.7420000000011]

{"sheet":"RRA 12.5","index":37,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Assets - Distribution"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Gross Assets in Service"]
[1,null,null,"Opening Balance",null,null,6101.4930000000004]
[{"$f":"A8+1","v":2},null,null,"Adjustment to Opening Balance",null,null,0]
[{"$f":"A9+1","v":3},null,null,"Capital Additions","13.0 L42",null,378.48]
[{"$f":"A10+1","v":4},null,null,"Retirements & Transfers",null,null,-22.741]
[{"$f":"A11+1","v":5},null,null,"Closing Balance",null,null,6457.232]
[]
[null,null,"Accumulated Amortization"]
[{"$f":"A12+1","v":6},null,null,"Opening Balance",null,null,738.08100000000002]
[{"$f":"A15+1","v":7},null,null,"Adjustment to Opening Balance",null,null,0]
[8,null,null,"Amort on March 2014 Assets",null,null,209.32176250000001]
[9,null,null,"Amortization on Additions","13.0 L76",null,16.008237500000003]
[10,null,null,"SMI New Assets",null,null,0]
[11,null,null,"SMI Legacy Meters",null,null,0]
[12,null,null,"Capital Asset Write-Offs",null,null,0]
[13,null,null,"Depn Study Adjustment",null,null,0]
[14,null,null,"Retirements & Transfers",null,null,0]
[15,null,null,"Closing Balance",null,null,963.41099999999994]
[]
[{"$f":"A24+1","v":16},null,"Net Assets in Service (Year-End)",null,null,null,5493.8209999999999]

{"sheet":"RRA 15.0","index":38,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Miscellaneous Revenue"]
["($ million)"]
[null,null,null,null,null,null,"F2016"]
[null,null,null,null,"Reference",null,"Plan"]
["Line",null,null,"Column",null,null,11]
[]
[null,null,"Generation"]
[1,null,null,"Interconnected Operations Services",null,null,0]
[{"$f":"A8+1","v":2},null,null,"FX Loss - Cost of Energy",null,null,0]
[{"$f":"A9+1","v":3},null,null,"Amortization of Contributions","11.0 L18",null,0.4]
[{"$f":"A10+1","v":4},null,null,"Other",null,null,2.6698]
[{"$f":"A11+1","v":5},null,null,"Total",null,null,3.0697999999999999]
[]
[null,null,"Transmission"]
[{"$f":"A12+1","v":6},null,null,"External OATT","3.4 L71",null,11.803587407999999]
[{"$f":"A15+1","v":7},null,null,"FortisBC Wheeling Agreement",null,null,4.8]
[8,null,null,"Secondary Revenue",null,null,7.537755907875999]
[9,null,null,"Interconnections",null,null,4.1500000000000004]
[10,null,null,"Amortization of Contributions","11.0 L29+30-25",null,10.9]
[11,null,null,"Other",null,null,0]
[12,null,null,"Total",null,null,39.191343315875997]
[]
[null,null,"Distribution"]
[{"$f":"A21+1","v":13},null,null,"Secondary Use Revenue & Other",null,null,16.589361324000002]
[{"$f":"A24+1","v":14},null,null,"Amortization of Contributions","11.0 L41+44-37",null,34.5]
[{"$f":"A25+1","v":15},null,null,"Legacy Meter Contributions","11.0 L36+43",null,0]
[{"$f":"A26+1","v":16},null,null,"Total",null,null,51.089361324000002]
[]
[null,null,"Customer Care"]
[{"$f":"A27+1","v":17},null,null,"Meter/Trans Rents & Power Factor Surcharges",null,null,10.505140592357501]
[{"$f":"A30+1","v":18},null,null,"Terasen Meter Reading",null,null,0]
[19,null,null,"SMI Impact",null,null,3.3632552665234421]
[20,null,null,"Diversion Net Recoveries",null,null,0.9]
[21,null,null,"FX Loss - Cost of Energy",null,null,0]
[22,null,null,"Other Operating Recoveries",null,null,5.8729904406139992]
[23,null,null,"Other",null,null,1.45]
[24,null,null,"Total",null,null,22.091386299494943]
[]
[null,null,"Corporate Groups"]
[{"$f":"A37+1","v":25},null,null,"Corporate General Rents",null,null,3.6307999999999998]
[{"$f":"A40+1","v":26},null,null,"Diversion Net Recoveries",null,null,0]
[27,null,null,"Net Gains on Property Sales",null,null,0]
[28,null,null,"Late Payment Charges",null,null,7.5659723999999988]
[29,null,null,"BCTC Recoveries",null,null,0]
[30,null,null,"Other",null,null,-1.4000000000000012E-2]
[31,null,null,"Total",null,null,11.182772399999999]
[]
[{"$f":"A46+1","v":32},null,"Total Gross Non-Tariff Revenue",null,null,null,126.62466333937094]
[]
[null,null,"Regulatory Account Additions"]
[{"$f":"A48+1","v":33},null,null,"Legacy Meter Contributions","Line 15",null,0]
[{"$f":"A51+1","v":34},null,null,"SMI Impact","Line 19",null,3.3632552665234421]
[]
[{"$f":"A52+1","v":35},null,"Total Current Non-Tariff Revenue",null,null,null,123.2614080728475]