{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["App.2-FA Proposed REG Invest.","App.2-FB Calc of REG Improvemnt","App.2-FC Calc of REG Expansion","Trueup Calculation 2015-2026"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"App.2-FA Proposed REG Invest.","index":0,"n_rows":87,"n_cols":20,"rows_kept":87,"cut":false,"hidden":false,"merged":[[48,0,48,7],[49,0,49,7],[8,0,8,7],[9,0,9,7],[6,0,6,6],[0,0,0,7],[1,0,1,7],[3,0,3,7],[4,0,4,7],[5,0,5,6]]}
["Appendix 2-FA"]
["Renewable Generation Connection Investment Summary (over the rate setting period)"]
[]
["Enter the details of the Renewable Generation Connection projects as described in Section 2.5.2.5 of the Filing Requirements."]
["All costs entered on this page will be transferred to the appropriate cells in the appendices that follow."]
["For Part A, Renewable Enabling Improvements (REI), these amounts will be transferred to Appendix 2 - FB"]
["For Part B, Expansions, these amounts will be transferred to Appendix 2 - FC"]
[]
["If there are more than five projects proposed to be in-service in a certain year, please amend the tables below and ensure that the formulae for the Total Amounts in any given rate year are updated."]
["Based on the current methodology and allocation, amounts allocated represent 6% for REI Connection Investments and 17% for Expansion Investments. (pg 15, EB-2009-0349)"]
[]
[]
["Part A"]
["REI Investments (Direct Benefit at 6%)",null,null,2015,2016,2017,2018,2019,{"$f":"H14+1","v":2020},{"$f":"I14+1","v":2021},{"$f":"J14+1","v":2022},{"$f":"K14+1","v":2023},{"$f":"L14+1","v":2024},{"$f":"M14+1","v":2025},{"$f":"N14+1","v":2026},{"$f":"O14+1","v":2027},{"$f":"P14+1","v":2028},{"$f":"Q14+1","v":2029},{"$f":"R14+1","v":2030},{"$f":"S14+1","v":2031}]
["Project 1"]
["Name: OPA FIT/MicroFIT Program Management"]
["Capital Costs"]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,117500,122500,110000,110000,110000,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 2"]
["Name: Maintenance of Connected REG Infrastructure"]
["Capital Costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,70000,76000,82000,88000,94000,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 3"]
["Name: Remote Monitoring and Control of  REG"]
["Capital Costs",null,null,180000,180000,180000,180000,180000,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,{"$f":"0.05*D29","v":9000},{"$f":"0.05*E29","v":9000},9000,9000,9000,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)"]
[]
["Project 4"]
["Name: REI Connection Project"]
["Capital Costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 5"]
["Name: REI Connection Project"]
["Capital Costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Capital Costs",null,null,{"$f":"SUM(D41,D35,D29,D23,D17)","v":180000},180000,180000,180000,180000,0,0,0,0,0,0,0,0,0,0,0,0]
["Total OM&A (Start-Up)",null,null,{"$f":"SUM(D42,D36,D30,D24,D18)","v":9000},9000,9000,9000,9000,0,0,0,0,0,0,0,0,0,0,0,0]
["Total OM&A (Ongoing)",null,null,{"$f":"SUM(D43,D37,D31,D25,D19)","v":187500},198500,192000,198000,204000,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Appendix 2-FA"]
["Renewable Generation Connection Investment Summary (over the rate setting period)"]
[]
[]
["Part B"]
["Expansion Investments (Direct Benefit at 17%)",null,null,{"$f":"D14","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031]
["Project 1"]
["Name: Transformer Replacement"]
["Capital Costs",null,null,60000,60000,60000,60000,60000,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,{"$f":"0.1*D57","v":6000},{"$f":"0.1*E57","v":6000},6000,6000,6000,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 2"]
["Name: Rebuilding Existing Line"]
["Capital Costs",null,null,38000,10000,12000,14000,16000,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,{"$f":"0.1*D63","v":3800},{"$f":"0.1*E63","v":1000},1200,1400,1600,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 3"]
["Name: Expansion Connection Project"]
["Capital Costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 4"]
["Name: Expansion Connection Project"]
["Capital Costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Project 5"]
["Name: Expansion Connection Project"]
["Capital Costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Start-Up)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["OM&A (Ongoing)",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Capital Costs",null,null,{"$f":"SUM(D81,D75,D69,D63,D57)","v":98000},{"$f":"SUM(E81,E75,E69,E63,E57)","v":70000},72000,74000,76000,{"$f":"SUM(I81,I75,I69,I63,I57)","v":0},{"$f":"SUM(J81,J75,J69,J63,J57)","v":0},0,0,0,0,0,{"$f":"SUM(P81,P75,P69,P63,P57)","v":0},0,0,0,0]
["Total OM&A (Start-Up)",null,null,{"$f":"SUM(D82,D76,D70,D64,D58)","v":9800},7000,7200,7400,7600,{"$f":"SUM(I82,I76,I70,I64,I58)","v":0},{"$f":"SUM(J82,J76,J70,J64,J58)","v":0},0,0,0,0,0,{"$f":"SUM(P82,P76,P70,P64,P58)","v":0},0,0,0,0]
["Total OM&A (Ongoing)",null,null,{"$f":"SUM(D83,D77,D71,D65,D59)","v":0},0,0,0,0,{"$f":"SUM(I83,I77,I71,I65,I59)","v":0},{"$f":"SUM(J83,J77,J71,J65,J59)","v":0},0,0,0,0,0,{"$f":"SUM(P83,P77,P71,P65,P59)","v":0},0,0,0,0]

{"sheet":"App.2-FB Calc of REG Improvemnt","index":1,"n_rows":88,"n_cols":54,"rows_kept":88,"cut":false,"hidden":false,"merged":[[7,39,7,41],[7,42,7,44],[7,45,7,47],[7,48,7,50],[7,51,7,53],[41,40,41,41],[41,43,41,44],[41,46,41,47],[41,49,41,50],[41,52,41,53],[7,33,7,35],[41,34,41,35],[7,36,7,38],[41,37,41,38],[7,24,7,26],[41,25,41,26],[7,27,7,29],[41,28,41,29],[7,30,7,32],[41,31,41,32],[7,21,7,23],[41,22,41,23],[57,0,57,6],[58,0,58,6],[41,16,41,17],[41,4,41,5],[41,7,41,8],[41,10,41,11],[41,13,41,14],[7,18,7,20],[41,19,41,20],[7,3,7,5],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[0,0,0,6],[1,0,1,6],[3,0,3,6],[4,0,4,6],[5,0,5,6]]}
["Appendix 2-FB"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Enabling Improvement Investments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed",null,null,2027,null,null,2028,null,null,2029,null,null,2030,null,null,2031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST Interest",null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2]
["This table will calculate the distributor/provincial shares of the investments entered in Part A of Appendix 2-FA.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LT Interest",null,null,4.19E-2,null,null,4.3499999999999997E-2,null,null,4.36E-2,null,null,4.3700000000000003E-2,null,null,4.5100000000000001E-2]
["Enter values in green shaded cells: WCA percentage, debt percentages, interest rates, kWh, tax rates, amortization period, CCA Class and percentage.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROE",null,null,0.09,null,null,0.09,null,null,0.09,null,null,0.09,null,null,0.09]
["Rate Riders are not calculated for Test Year as these assets and costs are already in the distributor's rate base/revenue requirement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WCA",null,null,6.1029E-2,null,null,6.1896E-2,null,null,6.1992999999999999E-2,null,null,6.2053999999999998E-2,null,null,6.2847E-2]
[]
[null,null,null,"2015Test Year",null,null,2016,null,null,2017,2016,null,2018,null,null,2019,null,null,2020,null,null,{"$f":"+S8+1","v":2021},null,null,{"$f":"+V8+1","v":2022},null,null,{"$f":"+Y8+1","v":2023},null,null,{"$f":"+AB8+1","v":2024},null,null,{"$f":"+AE8+1","v":2025},null,null,{"$f":"+AH8+1","v":2026},null,null,{"$f":"+AK8+1","v":2027},null,null,{"$f":"+AN8+1","v":2028},null,null,{"$f":"+AQ8+1","v":2029},null,null,{"$f":"+AT8+1","v":2030},null,null,{"$f":"+AW8+1","v":2031}]
[null,null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,2015,null,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94,"Total",0.06,0.94]
["Net Fixed Assets (average)",null,null,null,{"$f":"D11*E10","v":0},{"$f":"D11*F10","v":0},{"$f":"E75","v":255000},{"$f":"G11*H10","v":15300},{"$f":"G11*I10","v":239700},{"$f":"F75","v":411000},{"$f":"J11*K10","v":24660},{"$f":"J11*L10","v":386340},{"$f":"G75","v":555000},{"$f":"M11*N10","v":33300},{"$f":"M11*O10","v":521699.99999999994},{"$f":"H75","v":687000},{"$f":"P11*Q10","v":41220},{"$f":"P11*R10","v":645780},{"$f":"I75","v":720000},{"$f":"S11*T10","v":43200},{"$f":"S11*U10","v":676800},{"$f":"J75","v":660000},{"$f":"V11*W10","v":39600},{"$f":"V11*X10","v":620400},{"$f":"K75","v":600000},{"$f":"Y11*Z10","v":36000},{"$f":"Y11*AA10","v":564000},{"$f":"L75","v":540000},{"$f":"AB11*AC10","v":32400},{"$f":"AB11*AD10","v":507600},{"$f":"M75","v":480000},{"$f":"AE11*AF10","v":28800},{"$f":"AE11*AG10","v":451200},{"$f":"N75","v":420000},{"$f":"AH11*AI10","v":25200},{"$f":"AH11*AJ10","v":394800},{"$f":"O75","v":360000},{"$f":"AK11*AL10","v":21600},{"$f":"AK11*AM10","v":338400},{"$f":"P75","v":300000},{"$f":"AN11*AO10","v":18000},{"$f":"AN11*AP10","v":282000},{"$f":"Q75","v":240000},{"$f":"AQ11*AR10","v":14400},{"$f":"AQ11*AS10","v":225600},{"$f":"R75","v":180000},{"$f":"AT11*AU10","v":10800},{"$f":"AT11*AV10","v":169200},{"$f":"S75","v":120000},{"$f":"AW11*AX10","v":7200},{"$f":"AW11*AY10","v":112800},{"$f":"T75","v":60000},{"$f":"AZ11*BA10","v":3600},{"$f":"AZ11*BB10","v":56400}]
["Incremental OM&A (on-going, N/A for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!D47","v":187500},{"$f":"D12","v":187500},null,{"$f":"'App.2-FA Proposed REG Invest.'!E47","v":198500},{"$f":"G12","v":198500},null,{"$f":"'App.2-FA Proposed REG Invest.'!F47","v":192000},{"$f":"J12","v":192000},null,{"$f":"'App.2-FA Proposed REG Invest.'!G47","v":198000},{"$f":"M12","v":198000},null,{"$f":"'App.2-FA Proposed REG Invest.'!H47","v":204000},{"$f":"P12","v":204000},null,{"$f":"'App.2-FA Proposed REG Invest.'!I47","v":0},{"$f":"S12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!J47","v":0},{"$f":"V12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!K47","v":0},{"$f":"Y12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!L47","v":0},{"$f":"AB12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!M47","v":0},{"$f":"AE12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!N47","v":0},{"$f":"AH12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!O47","v":0},{"$f":"AK12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!P47","v":0},{"$f":"AN12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!Q47","v":0},{"$f":"AQ12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!R47","v":0},{"$f":"AT12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!S47","v":0},{"$f":"AW12","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!T47","v":0},{"$f":"AZ12","v":0}]
["Incremental OM&A (start-up, applicable for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!D46","v":9000},{"$f":"D13*E10","v":540},{"$f":"D13*F10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!E46","v":9000},{"$f":"G13*H10","v":540},{"$f":"G13*I10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!F46","v":9000},{"$f":"J13*K10","v":540},{"$f":"J13*L10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!G46","v":9000},{"$f":"M13*N10","v":540},{"$f":"M13*O10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!H46","v":9000},{"$f":"P13*Q10","v":540},{"$f":"P13*R10","v":8460},{"$f":"'App.2-FA Proposed REG Invest.'!I46","v":0},{"$f":"S13*T10","v":0},{"$f":"S13*U10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J46","v":0},{"$f":"V13*W10","v":0},{"$f":"V13*X10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K46","v":0},{"$f":"Y13*Z10","v":0},{"$f":"Y13*AA10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L46","v":0},{"$f":"AB13*AC10","v":0},{"$f":"AB13*AD10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M46","v":0},{"$f":"AE13*AF10","v":0},{"$f":"AE13*AG10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N46","v":0},{"$f":"AH13*AI10","v":0},{"$f":"AH13*AJ10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!O46","v":0},{"$f":"AK13*AL10","v":0},{"$f":"AK13*AM10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!P46","v":0},{"$f":"AN13*AO10","v":0},{"$f":"AN13*AP10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!Q46","v":0},{"$f":"AQ13*AR10","v":0},{"$f":"AQ13*AS10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!R46","v":0},{"$f":"AT13*AU10","v":0},{"$f":"AT13*AV10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!S46","v":0},{"$f":"AW13*AX10","v":0},{"$f":"AW13*AY10","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!T46","v":0},{"$f":"AZ13*BA10","v":0},{"$f":"AZ13*BB10","v":0}]
["WCA",0.13,null,null,{"$f":"(E12+E13)*$B$14","v":24445.200000000001},{"$f":"F13*$B$14","v":1099.8},null,{"$f":"(H12+H13)*$B$14","v":25875.200000000001},{"$f":"I13*$B$14","v":1099.8},null,{"$f":"(K12+K13)*$B$14","v":25030.2},{"$f":"L13*$B$14","v":1099.8},null,{"$f":"(N12+N13)*$B$14","v":25810.2},{"$f":"O13*$B$14","v":1099.8},null,{"$f":"(Q12+Q13)*$B$14","v":26590.2},{"$f":"R13*$B$14","v":1099.8},null,{"$f":"(T12+T13)*$B$14","v":0},{"$f":"U13*$B$14","v":0},null,{"$f":"(W12+W13)*$B$14","v":0},{"$f":"X13*$B$14","v":0},null,{"$f":"(Z12+Z13)*$B$14","v":0},{"$f":"AA13*$B$14","v":0},null,{"$f":"(AC12+AC13)*$B$14","v":0},{"$f":"AD13*$B$14","v":0},null,{"$f":"(AF12+AF13)*$B$14","v":0},{"$f":"AG13*$B$14","v":0},null,{"$f":"(AI12+AI13)*$B$14","v":0},{"$f":"AJ13*$B$14","v":0},null,{"$f":"(AL12+AL13)*$B$14","v":0},{"$f":"AM13*$B$14","v":0},null,{"$f":"(AO12+AO13)*$B$14","v":0},{"$f":"AP13*$B$14","v":0},null,{"$f":"(AR12+AR13)*$B$14","v":0},{"$f":"AS13*$B$14","v":0},null,{"$f":"(AU12+AU13)*$B$14","v":0},{"$f":"AV13*$B$14","v":0},null,{"$f":"(AX12+AX13)*$B$14","v":0},{"$f":"AY13*$B$14","v":0},null,{"$f":"(BA12+BA13)*$B$14","v":0},{"$f":"BB13*$B$14","v":0}]
["Rate Base",null,null,null,{"$f":"SUM(E11+E14)","v":24445.200000000001},{"$f":"SUM(F11+F14)","v":1099.8},null,{"$f":"SUM(H11+H14)","v":41175.199999999997},{"$f":"SUM(I11+I14)","v":240799.8},null,{"$f":"SUM(K11+K14)","v":49690.2},{"$f":"SUM(L11+L14)","v":387439.8},null,{"$f":"SUM(N11+N14)","v":59110.2},{"$f":"SUM(O11+O14)","v":522799.79999999993},null,{"$f":"SUM(Q11+Q14)","v":67810.2},{"$f":"SUM(R11+R14)","v":646879.80000000005},null,{"$f":"SUM(T11+T14)","v":43200},{"$f":"SUM(U11+U14)","v":676800},null,{"$f":"SUM(W11+W14)","v":39600},{"$f":"SUM(X11+X14)","v":620400},null,{"$f":"SUM(Z11+Z14)","v":36000},{"$f":"SUM(AA11+AA14)","v":564000},null,{"$f":"SUM(AC11+AC14)","v":32400},{"$f":"SUM(AD11+AD14)","v":507600},null,{"$f":"SUM(AF11+AF14)","v":28800},{"$f":"SUM(AG11+AG14)","v":451200},null,{"$f":"SUM(AI11+AI14)","v":25200},{"$f":"SUM(AJ11+AJ14)","v":394800},null,{"$f":"SUM(AL11+AL14)","v":21600},{"$f":"SUM(AM11+AM14)","v":338400},null,{"$f":"SUM(AO11+AO14)","v":18000},282000,null,{"$f":"SUM(AR11+AR14)","v":14400},225600,null,{"$f":"SUM(AU11+AU14)","v":10800},169200,null,{"$f":"SUM(AX11+AX14)","v":7200},112800,null,{"$f":"SUM(BA11+BA14)","v":3600},56400]
[]
[]
["Deemed ST Debt",0.04,null,null,{"$f":"E15*$B$18","v":977.80799999999999},{"$f":"F15*$B$18","v":43.991999999999997},null,{"$f":"H15*$B$18","v":1647.0079999999998},{"$f":"I15*$B$18","v":9631.9920000000002},null,{"$f":"K15*$B$18","v":1987.6079999999999},{"$f":"L15*$B$18","v":15497.592000000001},null,{"$f":"N15*$B$18","v":2364.4079999999999},{"$f":"O15*$B$18","v":20911.991999999998},null,{"$f":"Q15*$B$18","v":2712.4079999999999},{"$f":"R15*$B$18","v":25875.192000000003},null,{"$f":"T15*$B$18","v":1728},{"$f":"U15*$B$18","v":27072},null,{"$f":"W15*$B$18","v":1584},{"$f":"X15*$B$18","v":24816},null,{"$f":"Z15*$B$18","v":1440},{"$f":"AA15*$B$18","v":22560},null,{"$f":"AC15*$B$18","v":1296},{"$f":"AD15*$B$18","v":20304},null,{"$f":"AF15*$B$18","v":1152},{"$f":"AG15*$B$18","v":18048},null,{"$f":"AI15*$B$18","v":1008},{"$f":"AJ15*$B$18","v":15792},null,{"$f":"AL15*$B$18","v":864},{"$f":"AM15*$B$18","v":13536},null,{"$f":"AO15*$B$18","v":720},{"$f":"AP15*$B$18","v":11280},null,{"$f":"AR15*$B$18","v":576},{"$f":"AS15*$B$18","v":9024},null,{"$f":"AU15*$B$18","v":432},{"$f":"AV15*$B$18","v":6768},null,{"$f":"AX15*$B$18","v":288},{"$f":"AY15*$B$18","v":4512},null,{"$f":"BA15*$B$18","v":144},{"$f":"BB15*$B$18","v":2256}]
["Deemed LT Debt",0.56000000000000005,null,null,{"$f":"E15*$B$19","v":13689.312000000002},{"$f":"F15*$B$19","v":615.88800000000003},null,{"$f":"H15*$B$19","v":23058.112000000001},{"$f":"I15*$B$19","v":134847.88800000001},null,{"$f":"K15*$B$19","v":27826.512000000002},{"$f":"L15*$B$19","v":216966.288},null,{"$f":"N15*$B$19","v":33101.712},{"$f":"O15*$B$19","v":292767.88799999998},null,{"$f":"Q15*$B$19","v":37973.712},{"$f":"R15*$B$19","v":362252.68800000008},null,{"$f":"T15*$B$19","v":24192.000000000004},{"$f":"U15*$B$19","v":379008.00000000006},null,{"$f":"W15*$B$19","v":22176.000000000004},{"$f":"X15*$B$19","v":347424.00000000006},null,{"$f":"Z15*$B$19","v":20160.000000000004},{"$f":"AA15*$B$19","v":315840.00000000006},null,{"$f":"AC15*$B$19","v":18144},{"$f":"AD15*$B$19","v":284256},null,{"$f":"AF15*$B$19","v":16128.000000000002},{"$f":"AG15*$B$19","v":252672.00000000003},null,{"$f":"AI15*$B$19","v":14112.000000000002},{"$f":"AJ15*$B$19","v":221088.00000000003},null,{"$f":"AL15*$B$19","v":12096.000000000002},{"$f":"AM15*$B$19","v":189504.00000000003},null,{"$f":"AO15*$B$19","v":10080.000000000002},{"$f":"AP15*$B$19","v":157920.00000000003},null,{"$f":"AR15*$B$19","v":8064.0000000000009},{"$f":"AS15*$B$19","v":126336.00000000001},null,{"$f":"AU15*$B$19","v":6048.0000000000009},{"$f":"AV15*$B$19","v":94752.000000000015},null,{"$f":"AX15*$B$19","v":4032.0000000000005},{"$f":"AY15*$B$19","v":63168.000000000007},null,{"$f":"BA15*$B$19","v":2016.0000000000002},{"$f":"BB15*$B$19","v":31584.000000000004}]
["Deemed Equity",0.4,null,null,{"$f":"E15*$B$20","v":9778.08},{"$f":"F15*$B$20","v":439.92},null,{"$f":"H15*$B$20","v":16470.079999999998},{"$f":"I15*$B$20","v":96319.92},null,{"$f":"K15*$B$20","v":19876.080000000002},{"$f":"L15*$B$20","v":154975.92000000001},null,{"$f":"N15*$B$20","v":23644.080000000002},{"$f":"O15*$B$20","v":209119.91999999998},null,{"$f":"Q15*$B$20","v":27124.080000000002},{"$f":"R15*$B$20","v":258751.92000000004},null,{"$f":"T15*$B$20","v":17280},{"$f":"U15*$B$20","v":270720},null,{"$f":"W15*$B$20","v":15840},{"$f":"X15*$B$20","v":248160},null,{"$f":"Z15*$B$20","v":14400},{"$f":"AA15*$B$20","v":225600},null,{"$f":"AC15*$B$20","v":12960},{"$f":"AD15*$B$20","v":203040},null,{"$f":"AF15*$B$20","v":11520},{"$f":"AG15*$B$20","v":180480},null,{"$f":"AI15*$B$20","v":10080},{"$f":"AJ15*$B$20","v":157920},null,{"$f":"AL15*$B$20","v":8640},{"$f":"AM15*$B$20","v":135360},null,{"$f":"AO15*$B$20","v":7200},{"$f":"AP15*$B$20","v":112800},null,{"$f":"AR15*$B$20","v":5760},{"$f":"AS15*$B$20","v":90240},null,{"$f":"AU15*$B$20","v":4320},{"$f":"AV15*$B$20","v":67680},null,{"$f":"AX15*$B$20","v":2880},{"$f":"AY15*$B$20","v":45120},null,{"$f":"BA15*$B$20","v":1440},{"$f":"BB15*$B$20","v":22560}]
[]
["ST Interest",2.1600000000000001E-2,null,null,{"$f":"E18*$B22","v":21.120652800000002},{"$f":"F18*$B22","v":0.95022719999999994},null,{"$f":"H18*$B22","v":35.575372799999997},{"$f":"I18*$B22","v":208.05102720000002},null,{"$f":"K18*$B22","v":42.932332800000005},{"$f":"L18*$B22","v":334.74798720000001},null,{"$f":"N18*$B22","v":51.071212799999998},{"$f":"O18*$B22","v":451.69902719999999},null,{"$f":"Q18*$B22","v":58.588012800000001},{"$f":"R18*$B22","v":558.90414720000012},null,{"$f":"T18*$B22","v":37.324800000000003},{"$f":"U18*$B22","v":584.75520000000006},null,{"$f":"W18*$B22","v":34.214400000000005},{"$f":"X18*$B22","v":536.02560000000005},null,{"$f":"Z18*$B22","v":31.104000000000003},{"$f":"AA18*$B22","v":487.29600000000005},null,{"$f":"AC18*$B22","v":27.993600000000001},438.56640000000004,null,{"$f":"AF18*$B22","v":24.883200000000002},389.83680000000004,null,{"$f":"AI18*$B22","v":21.7728},{"$f":"AJ18*$B22","v":341.10720000000003},null,{"$f":"AL18*$B22","v":18.662400000000002},{"$f":"AM18*$B22","v":292.37760000000003},null,{"$f":"AO18*AO3","v":28.152000000000001},{"$f":"AP18*AO3","v":441.04800000000006},null,{"$f":"AR18*AR3","v":22.521600000000003},{"$f":"AS18*AR3","v":352.83840000000004},null,{"$f":"AU18*AU3","v":16.891200000000001},{"$f":"AV18*AU3","v":264.62880000000001},null,{"$f":"AX18*AX3","v":11.260800000000001},{"$f":"AY18*AX3","v":176.41920000000002},null,{"$f":"BA18*BA3","v":5.6304000000000007},{"$f":"BB18*BA3","v":88.209600000000009}]
["LT Interest",6.0728710462287103E-2,null,null,{"$f":"E19*$B23","v":831.33426487591248},37.402084029197084,null,{"$f":"H19*$B23","v":1400.2894074549879},8189.1383468029198,null,{"$f":"K19*$B23","v":1689.8681904233576},13176.082884029196,null,{"$f":"N19*$B23","v":2010.2242838540144},17779.416303007296,null,{"$f":"Q19*$B23","v":2306.0945612262772},21999.138603737232,null,{"$f":"T19*$B23","v":1469.1489635036498},23016.667094890512,null,{"$f":"W19*$B23","v":1346.719883211679},21098.611503649638,null,{"$f":"Z19*$B23","v":1224.2908029197083},19180.555912408763,null,1101.8617226277372,17262.500321167881,null,979.43264233576656,15344.444729927009,null,{"$f":"AI19*$B23","v":857.00356204379568},13426.389138686132,null,{"$f":"AL19*$B23","v":734.57448175182492},11508.333547445256,null,{"$f":"AO19*AO4","v":422.35200000000009},{"$f":"AP19*AO4","v":6616.8480000000009},null,{"$f":"AR19*AR4","v":350.78399999999999},{"$f":"AS19*AR4","v":5495.616},null,{"$f":"AU19*AU4","v":263.69280000000003},{"$f":"AV19*AU4","v":4131.1872000000003},null,{"$f":"AX19*AX4","v":176.19840000000002},{"$f":"AY19*AX4","v":2760.4416000000006},null,{"$f":"BA19*BA4","v":90.921600000000012},{"$f":"BB19*BA4","v":1424.4384000000002}]
["ROE",9.2999999999999999E-2,null,null,909.36144000000002,40.912559999999999,null,1531.7174399999999,8957.752559999999,null,1848.4754400000002,14412.760560000001,null,2198.8994400000001,19448.152559999999,null,2522.53944,24063.928560000004,null,{"$f":"T20*$B24","v":1607.04},25176.959999999999,null,{"$f":"W20*$B24","v":1473.12},23078.880000000001,null,{"$f":"Z20*$B24","v":1339.2},20980.799999999999,null,1205.28,18882.72,null,1071.3599999999999,16784.64,null,{"$f":"AI20*$B24","v":937.43999999999994},14686.56,null,{"$f":"AL20*$B24","v":803.52},12588.48,null,{"$f":"AO20*AO5","v":648},{"$f":"AP20*AO5","v":10152},null,{"$f":"AR20*AR5","v":518.4},{"$f":"AS20*AR5","v":8121.5999999999995},null,{"$f":"AU20*AU5","v":388.8},{"$f":"AV20*AU5","v":6091.2},null,{"$f":"AX20*AX5","v":259.2},{"$f":"AY20*AX5","v":4060.7999999999997},null,{"$f":"BA20*BA5","v":129.6},{"$f":"BB20*BA5","v":2030.3999999999999}]
["Cost of Capital Total",null,null,null,{"$f":"SUM(E22:E24)","v":1761.8163576759125},{"$f":"SUM(F22:F24)","v":79.264871229197084},null,{"$f":"SUM(H22:H24)","v":2967.582220254988},{"$f":"SUM(I22:I24)","v":17354.94193400292},null,{"$f":"SUM(K22:K24)","v":3581.2759632233578},{"$f":"SUM(L22:L24)","v":27923.591431229197},null,{"$f":"SUM(N22:N24)","v":4260.1949366540139},{"$f":"SUM(O22:O24)","v":37679.267890207295},null,{"$f":"SUM(Q22:Q24)","v":4887.2220140262771},{"$f":"SUM(R22:R24)","v":46621.971310937239},null,{"$f":"SUM(T22:T24)","v":3113.5137635036499},{"$f":"SUM(U22:U24)","v":48778.382294890514},null,{"$f":"SUM(W22:W24)","v":2854.0542832116789},{"$f":"SUM(X22:X24)","v":44713.517103649639},null,{"$f":"SUM(Z22:Z24)","v":2594.5948029197084},{"$f":"SUM(AA22:AA24)","v":40648.651912408764},null,{"$f":"SUM(AC22:AC24)","v":2335.135322627737},{"$f":"SUM(AD22:AD24)","v":36583.786721167882},null,{"$f":"SUM(AF22:AF24)","v":2075.6758423357664},{"$f":"SUM(AG22:AG24)","v":32518.921529927007},null,{"$f":"SUM(AI22:AI24)","v":1816.2163620437955},{"$f":"SUM(AJ22:AJ24)","v":28454.056338686132},null,{"$f":"SUM(AL22:AL24)","v":1556.7568817518249},{"$f":"SUM(AM22:AM24)","v":24389.191147445257},null,{"$f":"SUM(AO22:AO24)","v":1098.5040000000001},17209.896000000001,null,{"$f":"SUM(AR22:AR24)","v":891.7056},13970.054399999999,null,{"$f":"SUM(AU22:AU24)","v":669.38400000000001},10487.016,null,{"$f":"SUM(AX22:AX24)","v":446.6592},6997.6607999999997,null,{"$f":"SUM(BA22:BA24)","v":226.15199999999999},3543.0479999999998]
[]
["OM&A",null,null,null,{"$f":"E12+E13","v":188040},{"$f":"F13","v":8460},null,{"$f":"H12+H13","v":199040},{"$f":"I13","v":8460},null,{"$f":"K12+K13","v":192540},{"$f":"L13","v":8460},null,{"$f":"N12+N13","v":198540},{"$f":"O13","v":8460},null,{"$f":"Q12+Q13","v":204540},{"$f":"R13","v":8460},null,{"$f":"T12+T13","v":0},{"$f":"U13","v":0},null,{"$f":"W12+W13","v":0},{"$f":"X13","v":0},null,{"$f":"Z12+Z13","v":0},{"$f":"AA13","v":0},null,{"$f":"AC12+AC13","v":0},{"$f":"AD13","v":0},null,{"$f":"AF12+AF13","v":0},{"$f":"AG13","v":0},null,{"$f":"AI12+AI13","v":0},{"$f":"AJ13","v":0},null,{"$f":"AL12+AL13","v":0},{"$f":"AM13","v":0},null,{"$f":"AO12+AO13","v":0},{"$f":"AP13","v":0},null,{"$f":"AR12+AR13","v":0},{"$f":"AS13","v":0},null,{"$f":"AU12+AU13","v":0},{"$f":"AV13","v":0},null,{"$f":"AX12+AX13","v":0},{"$f":"AY13","v":0},null,{"$f":"BA12+BA13","v":0},{"$f":"BB13","v":0}]
["Amortization",null,null,{"$f":"D70","v":6000},{"$f":"D28*E$10","v":360},{"$f":"D28*F$10","v":5640},{"$f":"E69+E70","v":18000},{"$f":"G28*H$10","v":1080},{"$f":"G28*I$10","v":16920},{"$f":"F69+F70","v":30000},{"$f":"J28*K$10","v":1800},{"$f":"J28*L$10","v":28200},{"$f":"G69+G70","v":42000},{"$f":"M28*N$10","v":2520},{"$f":"M28*O$10","v":39480},{"$f":"H69+H70","v":54000},{"$f":"P28*Q$10","v":3240},{"$f":"P28*R$10","v":50760},{"$f":"I69+I70","v":60000},{"$f":"S28*T$10","v":3600},{"$f":"S28*U$10","v":56400},{"$f":"J69+J70","v":60000},{"$f":"V28*W$10","v":3600},{"$f":"V28*X$10","v":56400},{"$f":"K69+K70","v":60000},{"$f":"Y28*Z$10","v":3600},{"$f":"Y28*AA$10","v":56400},{"$f":"L69+L70","v":60000},{"$f":"AB28*AC$10","v":3600},{"$f":"AB28*AD$10","v":56400},{"$f":"M69+M70","v":60000},{"$f":"AE28*AF$10","v":3600},{"$f":"AE28*AG$10","v":56400},{"$f":"N69+N70","v":60000},{"$f":"AH28*AI$10","v":3600},{"$f":"AH28*AJ$10","v":56400},{"$f":"O69+O70","v":60000},{"$f":"AK28*AL$10","v":3600},{"$f":"AK28*AM$10","v":56400},{"$f":"P69+P70","v":60000},{"$f":"AN28*AO$10","v":3600},{"$f":"AN28*AP$10","v":56400},{"$f":"Q69+Q70","v":60000},{"$f":"AQ28*AR$10","v":3600},{"$f":"AQ28*AS$10","v":56400},{"$f":"R69+R70","v":60000},{"$f":"AT28*AU$10","v":3600},{"$f":"AT28*AV$10","v":56400},{"$f":"S69+S70","v":60000},{"$f":"AW28*AX$10","v":3600},{"$f":"AW28*AY$10","v":56400},{"$f":"T69+T70","v":60000},{"$f":"AZ28*BA$10","v":3600},{"$f":"AZ28*BB$10","v":56400}]
["Grossed-up PILs",null,null,null,{"$f":"E55","v":301.90582530612249},{"$f":"F55","v":-391.94309061224499},null,{"$f":"H55","v":486.83472326530614},{"$f":"I55","v":2204.7973175510219},null,{"$f":"K55","v":585.50601306122451},{"$f":"L55","v":3928.2032930612258},null,{"$f":"N55","v":718.32544946938799},{"$f":"O55","v":5845.143497469393},null,{"$f":"Q55","v":861.73732933224528},{"$f":"R55","v":7928.0319826677587},null,{"$f":"T55","v":602.97315186729816},{"$f":"U55","v":9446.5793792543336},null,{"$f":"W55","v":656.64067114648572},{"$f":"X55","v":10287.370514628279},null,{"$f":"Z55","v":702.15206235272603},{"$f":"AA55","v":11000.382310192712},null,{"$f":"AC55","v":740.15981573185479},{"$f":"AD55","v":11595.837113132395},null,{"$f":"AF55","v":771.2642223100413},{"$f":"AG55","v":12083.139482857314},null,{"$f":"AI55","v":796.01754983136016},{"$f":"AJ55","v":12470.941614024647},null,{"$f":"AL55","v":814.92788462036208},{"$f":"AM55","v":12767.203525719002},null,{"$f":"AO55","v":820.67491099359006},{"$f":"AP55","v":12857.24027223291},null,{"$f":"AR55","v":830.82173444063312},{"$f":"AS55","v":13016.207172903256},null,{"$f":"AU55","v":836.41868956293388},13103.892803152628,null,{"$f":"AX55","v":837.82976582647052},13125.999664614705,null,{"$f":"BA55","v":835.38983353994479},13087.774058792465]
[]
["Revenue Requirement",null,null,null,{"$f":"SUM(E25:E29)","v":190463.72218298202},{"$f":"SUM(F25:F29)","v":13787.321780616952},null,{"$f":"SUM(H25:H29)","v":203574.41694352031},{"$f":"SUM(I25:I29)","v":44939.73925155394},null,{"$f":"SUM(K25:K29)","v":198506.78197628458},{"$f":"SUM(L25:L29)","v":68511.794724290434},null,{"$f":"SUM(N25:N29)","v":206038.52038612339},{"$f":"SUM(O25:O29)","v":91464.411387676693},null,{"$f":"SUM(Q25:Q29)","v":213528.95934335853},{"$f":"SUM(R25:R29)","v":113770.003293605},null,{"$f":"SUM(T25:T29)","v":7316.4869153709478},{"$f":"SUM(U25:U29)","v":114624.96167414484},null,{"$f":"SUM(W25:W29)","v":7110.694954358165},{"$f":"SUM(X25:X29)","v":111400.88761827792},null,{"$f":"SUM(Z25:Z29)","v":6896.7468652724338},{"$f":"SUM(AA25:AA29)","v":108049.03422260148},null,{"$f":"SUM(AC25:AC29)","v":6675.2951383595919},{"$f":"SUM(AD25:AD29)","v":104579.62383430028},null,{"$f":"SUM(AF25:AF29)","v":6446.9400646458071},{"$f":"SUM(AG25:AG29)","v":101002.06101278431},null,{"$f":"SUM(AI25:AI29)","v":6212.2339118751552},{"$f":"SUM(AJ25:AJ29)","v":97324.997952710779},null,{"$f":"SUM(AL25:AL29)","v":5971.6847663721874},{"$f":"SUM(AM25:AM29)","v":93556.394673164265},null,{"$f":"SUM(AO25:AO29)","v":5519.1789109935899},86467.136272232921,null,{"$f":"SUM(AR25:AR29)","v":5322.5273344406332},83386.261572903255,null,{"$f":"SUM(AU25:AU29)","v":5105.8026895629337},79990.908803152633,null,{"$f":"SUM(AX25:AX29)","v":4884.488965826471},76523.660464614703,null,{"$f":"SUM(BA25:BA29)","v":4661.5418335399445},73030.822058792473]
[]
[]
["Provincial Rate Protection",null,null,null,null,{"$f":"F31","v":13787.321780616952},null,null,{"$f":"I31","v":44939.73925155394},null,null,{"$f":"L31","v":68511.794724290434},null,null,{"$f":"O31","v":91464.411387676693},null,null,{"$f":"R31","v":113770.003293605},null,null,{"$f":"U31","v":114624.96167414484},null,null,{"$f":"X31","v":111400.88761827792},null,null,{"$f":"AA31","v":108049.03422260148},null,null,{"$f":"AD31","v":104579.62383430028},null,null,{"$f":"AG31","v":101002.06101278431},null,null,{"$f":"AJ31","v":97324.997952710779},null,null,{"$f":"AM31","v":93556.394673164265},null,null,{"$f":"AP31","v":86467.136272232921},null,null,{"$f":"AS31","v":83386.261572903255},null,null,{"$f":"AV31","v":79990.908803152633},null,null,{"$f":"AY31","v":76523.660464614703},null,null,{"$f":"BB31","v":73030.822058792473}]
[]
["Monthly Amount Paid by IESO",null,null,null,null,{"$f":"F34/12","v":1148.9434817180793},null,null,{"$f":"I34/12","v":3744.9782709628284},null,null,{"$f":"L34/12","v":5709.3162270242028},null,null,{"$f":"O34/12","v":7622.0342823063911},null,null,{"$f":"R34/12","v":9480.8336078004158},null,null,{"$f":"U34/12","v":9552.0801395120707},null,null,{"$f":"X34/12","v":9283.4073015231606},null,null,{"$f":"AA34/12","v":9004.0861852167891},null,null,{"$f":"AD34/12","v":8714.968652858357},null,null,{"$f":"AG34/12","v":8416.8384177320258},null,null,{"$f":"AJ34/12","v":8110.4164960592316},null,null,{"$f":"AM34/12","v":7796.3662227636887},null,null,{"$f":"AP34/12","v":7205.5946893527434},null,null,{"$f":"AS34/12","v":6948.8551310752709},null,null,{"$f":"AV34/12","v":6665.9090669293864},null,null,{"$f":"AY34/12","v":6376.9717053845588},null,null,{"$f":"BB34/12","v":6085.9018382327058}]
[]
["Note 1: The difference between the actual costs of approved eligible investments and revenue received from the IESO should be recorded in a variance account.  The Board regulatory accounting guidance regarding a variance account either in an individual proceeding or on a generic basis. "]
["Note 2: For the 2014 Test Year, Costs and Revenues of the Direct Benefit are to be included in the test year applicant Rate Base and Revenues.  ",null,null,null,null,{"$f":"+F34+'App.2-FC Calc of REG Expansion'!F35","v":25655.170593792329},null,null,{"$f":"+I34+'App.2-FC Calc of REG Expansion'!I35","v":60710.615227489776},null,null,{"$f":"+L34+'App.2-FC Calc of REG Expansion'!L35","v":89741.108872788915},null,null,{"$f":"+O34+'App.2-FC Calc of REG Expansion'!O35","v":118291.13915835354},null,null,{"$f":"+R34+'App.2-FC Calc of REG Expansion'!R35","v":146324.10673932123},null,null,{"$f":"+U34+'App.2-FC Calc of REG Expansion'!U35","v":143581.98786349266},null,null,{"$f":"+X34+'App.2-FC Calc of REG Expansion'!X35","v":140272.38436852055},null,null,{"$f":"+AA34+'App.2-FC Calc of REG Expansion'!AA35","v":136786.50133831453},null,null,{"$f":"+AD34+'App.2-FC Calc of REG Expansion'!AD35","v":133138.44113569337},null,null,{"$f":"+AG34+'App.2-FC Calc of REG Expansion'!AG35","v":129341.17793445024},null,null,{"$f":"+AJ34+'App.2-FC Calc of REG Expansion'!AJ35","v":124221.7242921774},null,null,{"$f":"+AM34+'App.2-FC Calc of REG Expansion'!AM35","v":120237.77356771402},null,null,{"$f":"+AP34+'App.2-FC Calc of REG Expansion'!AP35+'Trueup Calculation 2015-2026'!D15","v":111282.06496248583},null,null,{"$f":"+AS34+'App.2-FC Calc of REG Expansion'!AS35","v":107035.97725677889},null,null,{"$f":"+AV34+'App.2-FC Calc of REG Expansion'!AV35","v":103425.82732861573},null,null,{"$f":"+AY34+'App.2-FC Calc of REG Expansion'!AY35","v":99718.084962689274},null,null,{"$f":"+BB34+'App.2-FC Calc of REG Expansion'!BB35","v":96117.872414420621}]
[null,null,null,null,null,{"$f":"+F36+'App.2-FC Calc of REG Expansion'!F37","v":2137.9308828160274},null,null,{"$f":"+I36+'App.2-FC Calc of REG Expansion'!I37","v":5059.2179356241486},null,null,{"$f":"+L36+'App.2-FC Calc of REG Expansion'!L37","v":7478.4257393990765},null,null,{"$f":"+O36+'App.2-FC Calc of REG Expansion'!O37","v":9857.5949298627947},null,null,{"$f":"+R36+'App.2-FC Calc of REG Expansion'!R37","v":12193.675561610102},null,null,{"$f":"+U36+'App.2-FC Calc of REG Expansion'!U37","v":11965.165655291057},null,null,{"$f":"+X36+'App.2-FC Calc of REG Expansion'!X37","v":11689.36536404338},null,null,{"$f":"+AA36+'App.2-FC Calc of REG Expansion'!AA37","v":11398.875111526211},null,null,{"$f":"+AD36+'App.2-FC Calc of REG Expansion'!AD37","v":11094.870094641114},null,null,{"$f":"+AG36+'App.2-FC Calc of REG Expansion'!AG37","v":10778.431494537519},null,null,{"$f":"+AJ36+'App.2-FC Calc of REG Expansion'!AJ37","v":10351.81035768145},null,null,{"$f":"+AM36+'App.2-FC Calc of REG Expansion'!AM37","v":10019.814463976169},null,null,{"$f":"+AP36+'App.2-FC Calc of REG Expansion'!AP37","v":9174.8888118342493},null,null,{"$f":"+AS36+'App.2-FC Calc of REG Expansion'!AS37","v":8919.664771398242},null,null,{"$f":"+AV36+'App.2-FC Calc of REG Expansion'!AV37","v":8618.8189440513106},null,null,{"$f":"+AY36+'App.2-FC Calc of REG Expansion'!AY37","v":8309.8404135574401},null,null,{"$f":"+BB36+'App.2-FC Calc of REG Expansion'!BB37","v":8009.8227012017187}]
["PILs Calculation"]
[null,null,null,null,2015,null,null,2016,null,null,2017,null,null,2018,null,null,2019,null,null,2020,null,null,{"$f":"V8","v":2021},null,null,{"$f":"Y8","v":2022},null,null,{"$f":"AB8","v":2023},null,null,{"$f":"AE8","v":2024},null,null,{"$f":"AH8","v":2025},null,null,{"$f":"AK8","v":2026},null,null,{"$f":"AN8","v":2027},null,null,{"$f":"AQ8","v":2028},null,null,{"$f":"AT8","v":2029},null,null,{"$f":"AW8","v":2030},null,null,{"$f":"AZ8","v":2031}]
["Income Tax",null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total"]
["Net Income - ROE on Rate Base",null,null,null,{"$f":"E24","v":909.36144000000002},{"$f":"F24","v":40.912559999999999},null,{"$f":"H24","v":1531.7174399999999},{"$f":"I24","v":8957.752559999999},null,{"$f":"K24","v":1848.4754400000002},{"$f":"L24","v":14412.760560000001},null,{"$f":"N24","v":2198.8994400000001},{"$f":"O24","v":19448.152559999999},null,{"$f":"Q24","v":2522.53944},{"$f":"R24","v":24063.928560000004},null,{"$f":"T24","v":1607.04},{"$f":"U24","v":25176.959999999999},null,{"$f":"W24","v":1473.12},{"$f":"X24","v":23078.880000000001},null,{"$f":"Z24","v":1339.2},{"$f":"AA24","v":20980.799999999999},null,{"$f":"AC24","v":1205.28},{"$f":"AD24","v":18882.72},null,{"$f":"AF24","v":1071.3599999999999},{"$f":"AG24","v":16784.64},null,{"$f":"AI24","v":937.43999999999994},{"$f":"AJ24","v":14686.56},null,{"$f":"AL24","v":803.52},{"$f":"AM24","v":12588.48},null,{"$f":"AO24","v":648},{"$f":"AP24","v":10152},null,{"$f":"AR24","v":518.4},8121.5999999999995,null,{"$f":"AU24","v":388.8},6091.2,null,{"$f":"AX24","v":259.2},4060.7999999999997,null,{"$f":"BA24","v":129.6},2030.3999999999999]
["Amortization (6% DB and 94% P)",null,null,null,{"$f":"E28","v":360},{"$f":"F28","v":5640},null,{"$f":"H28","v":1080},{"$f":"I28","v":16920},null,{"$f":"K28","v":1800},{"$f":"L28","v":28200},null,{"$f":"N28","v":2520},{"$f":"O28","v":39480},null,{"$f":"Q28","v":3240},{"$f":"R28","v":50760},null,{"$f":"T28","v":3600},{"$f":"U28","v":56400},null,{"$f":"W28","v":3600},{"$f":"X28","v":56400},null,{"$f":"Z28","v":3600},{"$f":"AA28","v":56400},null,{"$f":"AC28","v":3600},{"$f":"AD28","v":56400},null,{"$f":"AF28","v":3600},{"$f":"AG28","v":56400},null,{"$f":"AI28","v":3600},{"$f":"AJ28","v":56400},null,{"$f":"AL28","v":3600},{"$f":"AM28","v":56400},null,{"$f":"AO28","v":3600},{"$f":"AP28","v":56400},null,{"$f":"AR28","v":3600},56400,null,{"$f":"AU28","v":3600},56400,null,{"$f":"AX28","v":3600},56400,null,{"$f":"BA28","v":3600},56400]
["CCA (6% DB and 94% P)",null,null,null,{"$f":"-D87*E$10","v":-432},{"$f":"-D87*F$10","v":-6768},null,{"$f":"-E87*H$10","v":-1261.44},{"$f":"-E87*I$10","v":-19762.559999999998},null,{"$f":"-F87*K$10","v":-2024.5248000000001},{"$f":"-F87*L$10","v":-31717.555199999999},null,{"$f":"-G87*N$10","v":-2726.5628159999997},{"$f":"-G87*O$10","v":-42716.15078399999},null,{"$f":"-H87*Q$10","v":-3372.4377907199996},{"$f":"-H87*R$10","v":-52834.85872127999},null,{"$f":"-I87*T$10","v":-3534.6427674623997},{"$f":"-I87*U$10","v":-55376.070023577595},null,{"$f":"-J87*W$10","v":-3251.8713460654076},{"$f":"-J87*X$10","v":-50945.984421691384},null,{"$f":"-K87*Z$10","v":-2991.7216383801747},{"$f":"-K87*AA$10","v":-46870.305667956069},null,{"$f":"-L87*AC$10","v":-2752.3839073097611},{"$f":"-L87*AD$10","v":-43120.681214519587},null,{"$f":"-M87*AF$10","v":-2532.1931947249795},{"$f":"-M87*AG$10","v":-39671.026717358014},null,{"$f":"-N87*AI$10","v":-2329.6177391469819},{"$f":"-N87*AJ$10","v":-36497.34457996938},null,{"$f":"-O87*AL$10","v":-2143.2483200152228},{"$f":"-O87*AM$10","v":-33577.557013571823},null,{"$f":"-P87*AO$10","v":-1971.7884544140052},{"$f":"-P87*AP$10","v":-30891.35245248608},null,{"$f":"-Q87*AR$10","v":-1814.0453780608848},{"$f":"-Q87*AS$10","v":-28420.044256287194},null,{"$f":"-R87*AU$10","v":-1668.921747816014},{"$f":"-R87*AV$10","v":-26146.440715784218},null,{"$f":"-S87*AX$10","v":-1535.4080079907328},{"$f":"-S87*AY$10","v":-24054.725458521483},null,{"$f":"-T87*BA$10","v":-1412.5753673514744},{"$f":"-T87*BB$10","v":-22130.347421839764}]
["Taxable income",null,null,null,{"$f":"SUM(E45:E47)","v":837.36144000000013},{"$f":"SUM(F45:F47)","v":-1087.0874400000002},null,{"$f":"SUM(H45:H47)","v":1350.2774399999998},{"$f":"SUM(I45:I47)","v":6115.1925600000031},null,{"$f":"SUM(K45:K47)","v":1623.95064},{"$f":"SUM(L45:L47)","v":10895.205360000004},null,{"$f":"SUM(N45:N47)","v":1992.3366240000005},{"$f":"SUM(O45:O47)","v":16212.001776000012},null,{"$f":"SUM(Q45:Q47)","v":2390.1016492800009},{"$f":"SUM(R45:R47)","v":21989.06983872001},null,{"$f":"SUM(T45:T47)","v":1672.3972325376003},{"$f":"SUM(U45:U47)","v":26200.889976422397},null,{"$f":"SUM(W45:W47)","v":1821.2486539345923},{"$f":"SUM(X45:X47)","v":28532.89557830862},null,{"$f":"SUM(Z45:Z47)","v":1947.4783616198251},{"$f":"SUM(AA45:AA47)","v":30510.494332043934},null,{"$f":"SUM(AC45:AC47)","v":2052.8960926902387},{"$f":"SUM(AD45:AD47)","v":32162.038785480414},null,{"$f":"SUM(AF45:AF47)","v":2139.1668052750201},{"$f":"SUM(AG45:AG47)","v":33513.613282641985},null,{"$f":"SUM(AI45:AI47)","v":2207.8222608530177},{"$f":"SUM(AJ45:AJ47)","v":34589.215420030618},null,{"$f":"SUM(AL45:AL47)","v":2260.2716799847776},{"$f":"SUM(AM45:AM47)","v":35410.922986428173},null,{"$f":"SUM(AO45:AO47)","v":2276.2115455859948},35660.647547513916,null,{"$f":"SUM(AR45:AR47)","v":2304.3546219391146},36101.555743712801,null,{"$f":"SUM(AU45:AU47)","v":2319.8782521839862},36344.759284215776,null,{"$f":"SUM(AX45:AX47)","v":2323.7919920092672},36406.07454147852,null,{"$f":"SUM(BA45:BA47)","v":2317.0246326485258},36300.052578160234]
[]
["Tax Rate  (to be entered)",null,null,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001]
[]
["Income Taxes Payable",null,null,null,{"$f":"E48*E50","v":221.90078160000004},{"$f":"F48*F50","v":-288.07817160000008},null,{"$f":"H48*H50","v":357.82352159999999},{"$f":"I48*I50","v":1620.526028400001},null,{"$f":"K48*K50","v":430.34691960000004},{"$f":"L48*L50","v":2887.2294204000009},null,{"$f":"N48*N50","v":527.96920536000016},{"$f":"O48*O50","v":4296.1804706400035},null,{"$f":"Q48*Q50","v":633.37693705920026},{"$f":"R48*R50","v":5827.1035072608029},null,{"$f":"T48*T50","v":443.1852666224641},{"$f":"U48*U50","v":6943.2358437519351},null,{"$f":"W48*W50","v":482.630893292667},{"$f":"X48*X50","v":7561.2173282517851},null,{"$f":"Z48*Z50","v":516.08176582925364},{"$f":"AA48*AA50","v":8085.2809979916428},null,{"$f":"AC48*AC50","v":544.01746456291323},{"$f":"AD48*AD50","v":8522.9402781523095},null,{"$f":"AF48*AF50","v":566.87920339788036},{"$f":"AG48*AG50","v":8881.1075199001261},null,{"$f":"AI48*AI50","v":585.07289912604972},{"$f":"AJ48*AJ50","v":9166.1420863081148},null,{"$f":"AL48*AL50","v":598.97199519596609},{"$f":"AM48*AM50","v":9383.8945914034666},null,{"$f":"AO48*AO50","v":603.19605958028865},{"$f":"AP48*AP50","v":9450.0716000911889},null,{"$f":"AR48*AR50","v":610.65397481386537},9566.9122720838932,null,{"$f":"AU48*AU50","v":614.76773682875637},9631.3612103171818,null,{"$f":"AX48*AX50","v":615.8048778824558},9647.6097534918081,null,{"$f":"BA48*BA50","v":614.01152765185941},9619.5139332124618]
["Gross Up"]
["Income Taxes Payable",null,null,null,{"$f":"E52/(1-E50)","v":301.90582530612249},{"$f":"F52/(1-F50)","v":-391.94309061224499},null,{"$f":"H52/(1-H50)","v":486.83472326530614},{"$f":"I52/(1-I50)","v":2204.7973175510219},null,{"$f":"K52/(1-K50)","v":585.50601306122451},{"$f":"L52/(1-L50)","v":3928.2032930612258},null,{"$f":"N52/(1-N50)","v":718.32544946938799},{"$f":"O52/(1-O50)","v":5845.143497469393},null,{"$f":"Q52/(1-Q50)","v":861.73732933224528},{"$f":"R52/(1-R50)","v":7928.0319826677587},null,{"$f":"T52/(1-T50)","v":602.97315186729816},{"$f":"U52/(1-U50)","v":9446.5793792543336},null,{"$f":"W52/(1-W50)","v":656.64067114648572},{"$f":"X52/(1-X50)","v":10287.370514628279},null,{"$f":"Z52/(1-Z50)","v":702.15206235272603},{"$f":"AA52/(1-AA50)","v":11000.382310192712},null,{"$f":"AC52/(1-AC50)","v":740.15981573185479},{"$f":"AD52/(1-AD50)","v":11595.837113132395},null,{"$f":"AF52/(1-AF50)","v":771.2642223100413},{"$f":"AG52/(1-AG50)","v":12083.139482857314},null,{"$f":"AI52/(1-AI50)","v":796.01754983136016},{"$f":"AJ52/(1-AJ50)","v":12470.941614024647},null,{"$f":"AL52/(1-AL50)","v":814.92788462036208},{"$f":"AM52/(1-AM50)","v":12767.203525719002},null,{"$f":"AO52/(1-AO50)","v":820.67491099359006},{"$f":"AP52/(1-AP50)","v":12857.24027223291},null,{"$f":"AR52/(1-AR50)","v":830.82173444063312},13016.207172903256,null,{"$f":"AU52/(1-AU50)","v":836.41868956293388},13103.892803152628,null,{"$f":"AX52/(1-AX50)","v":837.82976582647052},13125.999664614705,null,{"$f":"BA52/(1-BA50)","v":835.38983353994479},13087.774058792465]
["Grossed Up PILs",null,null,null,{"$f":"SUM(E54:E54)","v":301.90582530612249},{"$f":"SUM(F54:F54)","v":-391.94309061224499},null,{"$f":"SUM(H54:H54)","v":486.83472326530614},{"$f":"SUM(I54:I54)","v":2204.7973175510219},null,{"$f":"SUM(K54:K54)","v":585.50601306122451},{"$f":"SUM(L54:L54)","v":3928.2032930612258},null,{"$f":"SUM(N54:N54)","v":718.32544946938799},{"$f":"SUM(O54:O54)","v":5845.143497469393},null,{"$f":"SUM(Q54:Q54)","v":861.73732933224528},{"$f":"SUM(R54:R54)","v":7928.0319826677587},null,{"$f":"SUM(T54:T54)","v":602.97315186729816},{"$f":"SUM(U54:U54)","v":9446.5793792543336},null,{"$f":"SUM(W54:W54)","v":656.64067114648572},{"$f":"SUM(X54:X54)","v":10287.370514628279},null,{"$f":"SUM(Z54:Z54)","v":702.15206235272603},{"$f":"SUM(AA54:AA54)","v":11000.382310192712},null,{"$f":"SUM(AC54:AC54)","v":740.15981573185479},{"$f":"SUM(AD54:AD54)","v":11595.837113132395},null,{"$f":"SUM(AF54:AF54)","v":771.2642223100413},{"$f":"SUM(AG54:AG54)","v":12083.139482857314},null,{"$f":"SUM(AI54:AI54)","v":796.01754983136016},{"$f":"SUM(AJ54:AJ54)","v":12470.941614024647},null,{"$f":"SUM(AL54:AL54)","v":814.92788462036208},{"$f":"SUM(AM54:AM54)","v":12767.203525719002},null,{"$f":"SUM(AO54:AO54)","v":820.67491099359006},{"$f":"SUM(AP54:AP54)","v":12857.24027223291},null,{"$f":"SUM(AR54:AR54)","v":830.82173444063312},13016.207172903256,null,{"$f":"SUM(AU54:AU54)","v":836.41868956293388},13103.892803152628,null,{"$f":"SUM(AX54:AX54)","v":837.82976582647052},13125.999664614705,null,{"$f":"SUM(BA54:BA54)","v":835.38983353994479},13087.774058792465]
[]
[]
["Appendix 2-FB"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Enabling Improvement Investments"]
[]
[null,null,null,2015,2016,2017,2018,2019,2020,{"$f":"+I61+1","v":2021},2022,2023,2024,2025,2026,{"$f":"+O61+1","v":2027},{"$f":"+P61+1","v":2028},{"$f":"+Q61+1","v":2029},{"$f":"+R61+1","v":2030},{"$f":"+S61+1","v":2031}]
["Net Fixed Assets",null,null,{"$f":"(180000/25)/2","v":3600}]
[null,"Enter applicable amortization in years:",15]
["Opening Gross Fixed Assets",null,null,null,{"$f":"D66","v":180000},{"$f":"E66","v":360000},{"$f":"F66","v":540000},{"$f":"G66","v":720000},{"$f":"H66","v":900000},{"$f":"I66","v":900000},900000,900000,900000,900000,900000,{"$f":"O66","v":900000},{"$f":"P66","v":900000},{"$f":"Q66","v":900000},{"$f":"R66","v":900000},{"$f":"S66","v":900000}]
["Gross Capital Additions",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!D45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!E45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!F45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!G45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!H45","v":180000},{"$f":"'App.2-FA Proposed REG Invest.'!I45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!O45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!P45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!Q45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!R45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!S45","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!T45","v":0}]
["Closing Gross Fixed Assets",null,null,{"$f":"SUM(D64:D65)","v":180000},{"$f":"SUM(E64:E65)","v":360000},540000,720000,900000,{"$f":"SUM(I64:I65)","v":900000},900000,{"$f":"SUM(K64:K65)","v":900000},900000,900000,900000,900000,{"$f":"SUM(P64:P65)","v":900000},900000,900000,900000,900000]
[]
["Opening Accumulated Amortization",null,null,null,{"$f":"D71","v":6000},{"$f":"E71","v":24000},{"$f":"F71","v":54000},{"$f":"G71","v":96000},{"$f":"H71","v":150000},{"$f":"I71","v":210000},270000,330000,390000,450000,510000,{"$f":"O71","v":570000},{"$f":"P71","v":630000},{"$f":"Q71","v":690000},{"$f":"R71","v":750000},{"$f":"S71","v":810000}]
["Current Year Amortization (before additions)",null,null,null,{"$f":"IF(ISERROR(E64/$C$63), 0, E64/$C$63)","v":12000},24000,36000,{"$f":"IF(ISERROR(H64/$C$63), 0, H64/$C$63)","v":48000},{"$f":"IF(ISERROR(I64/$C$63), 0, I64/$C$63)","v":60000},{"$f":"IF(ISERROR(J64/$C$63), 0, J64/$C$63)","v":60000},60000,{"$f":"IF(ISERROR(L64/$C$63), 0, L64/$C$63)","v":60000},60000,60000,60000,60000,60000,60000,60000,60000]
["Additions (half year)",null,null,{"$f":"D65/C63/2","v":6000},{"$f":"E65/C63/2","v":6000},{"$f":"F65/C63/2","v":6000},{"$f":"G65/C63/2","v":6000},{"$f":"H65/C63/2","v":6000},{"$f":"I65/$C$63/2","v":0},{"$f":"J65/$C$63/2","v":0},0,0,0,0,0,0,0,0,0,0]
["Closing Accumulated Amortization",null,null,{"$f":"SUM(D68+D70)","v":6000},{"$f":"SUM(E68:E70)","v":24000},{"$f":"SUM(F68:F70)","v":54000},{"$f":"SUM(G68:G70)","v":96000},{"$f":"SUM(H68:H70)","v":150000},{"$f":"SUM(I68:I70)","v":210000},{"$f":"SUM(J68:J70)","v":270000},330000,{"$f":"SUM(L68:L70)","v":390000},450000,510000,570000,{"$f":"SUM(P68:P70)","v":630000},690000,750000,810000,870000]
[]
["Opening Net Fixed Assets",null,null,{"$f":"D64-D68","v":0},{"$f":"D74","v":174000},{"$f":"E74","v":336000},{"$f":"F74","v":486000},{"$f":"G74","v":624000},{"$f":"H74","v":750000},{"$f":"I74","v":690000},630000,570000,510000,450000,390000,{"$f":"O74","v":330000},{"$f":"P74","v":270000},{"$f":"Q74","v":210000},{"$f":"R74","v":150000},{"$f":"S74","v":90000}]
["Closing Net Fixed Assets",null,null,{"$f":"D66-D71","v":174000},336000,486000,624000,{"$f":"H66-H71","v":750000},690000,{"$f":"J66-J71","v":630000},570000,{"$f":"L66-L71","v":510000},450000,390000,330000,{"$f":"P66-P71","v":270000},210000,150000,90000,30000]
["Average Net Fixed Assets",null,null,{"$f":"SUM(D73:D74)/2","v":87000},255000,411000,555000,687000,720000,{"$f":"SUM(J73:J74)/2","v":660000},600000,{"$f":"SUM(L73:L74)/2","v":540000},480000,420000,360000,{"$f":"SUM(P73:P74)/2","v":300000},240000,180000,120000,60000]
[]
["UCC for PILs Calculation"]
[null,null,null,{"$f":"D61","v":2015},2016,2017,{"$f":"G61","v":2018},{"$f":"H61","v":2019},2020,2021,{"$f":"K61","v":2022},2023,2024,2025,2026,{"$f":"P61","v":2027},2028,2029,2030,2031]
[]
["Opening UCC",null,null,null,{"$f":"D88","v":172800},{"$f":"E88","v":331776},{"$f":"F88","v":478033.91999999998},{"$f":"G88","v":612591.20639999991},{"$f":"H88","v":736383.90988799988},{"$f":"I88","v":677473.19709695992},623275.3413292031,573413.31402286689,527540.2489010375,485337.02898895449,446510.06666983815,{"$f":"O88","v":410789.2613362511},{"$f":"P88","v":377926.12042935099},{"$f":"Q88","v":347692.03079500294},{"$f":"R88","v":319876.6683314027},{"$f":"S88","v":294286.53486489051}]
["Capital Additions (from Appendix 2-FA)",null,null,{"$f":"D65","v":180000},{"$f":"E65","v":180000},{"$f":"F65","v":180000},180000,180000,{"$f":"I65","v":0},0,{"$f":"K65","v":0},0,0,0,0,{"$f":"P65","v":0},0,0,0,0]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D80:D81)","v":180000},352800,511776,658033.91999999993,792591.20639999991,736383.90988799988,{"$f":"SUM(J80:J81)","v":677473.19709695992},623275.3413292031,{"$f":"SUM(L80:L81)","v":573413.31402286689},527540.2489010375,485337.02898895449,446510.06666983815,{"$f":"SUM(P80:P81)","v":410789.2613362511},377926.12042935099,347692.03079500294,319876.6683314027,294286.53486489051]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"D81/2","v":90000},90000,90000,90000,90000,0,{"$f":"J81/2","v":0},0,{"$f":"L81/2","v":0},0,0,0,{"$f":"P81/2","v":0},0,0,0,0]
["Reduced UCC",null,null,{"$f":"D82-D83","v":90000},262800,421776,568033.91999999993,702591.20639999991,736383.90988799988,{"$f":"J82-J83","v":677473.19709695992},623275.3413292031,{"$f":"L82-L83","v":573413.31402286689},527540.2489010375,485337.02898895449,446510.06666983815,{"$f":"P82-P83","v":410789.2613362511},377926.12042935099,347692.03079500294,319876.6683314027,294286.53486489051]
["CCA Rate Class (to be entered)",null,47,{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"C85","v":47},{"$f":"D85","v":47},{"$f":"E85","v":47},47,47,47,47,47,{"$f":"K85","v":47},{"$f":"L85","v":47},{"$f":"M85","v":47},{"$f":"N85","v":47},{"$f":"O85","v":47}]
["CCA Rate  (to be entered)",null,0.08,{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"C86","v":0.08},{"$f":"D86","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
["CCA",null,null,{"$f":"D84*D86","v":7200},{"$f":"E84*E86","v":21024},33742.080000000002,45442.713599999995,{"$f":"H84*H86","v":56207.296511999994},{"$f":"I84*I86","v":58910.712791039994},{"$f":"J84*J86","v":54197.855767756795},49862.027306336247,{"$f":"L84*L86","v":45873.06512182935},42203.219912082997,38826.962319116363,35720.80533358705,{"$f":"P84*P86","v":32863.140906900087},30234.089634348082,27815.362463600235,25590.133466512216,23542.922789191241]
["Closing UCC",null,null,{"$f":"D82-D87","v":172800},331776,478033.91999999998,612591.20639999991,736383.90988799988,677473.19709695992,{"$f":"J82-J87","v":623275.3413292031},573413.31402286689,{"$f":"L82-L87","v":527540.2489010375},485337.02898895449,446510.06666983815,410789.2613362511,{"$f":"P82-P87","v":377926.12042935099},347692.03079500294,319876.6683314027,294286.53486489051,270743.61207569926]

{"sheet":"App.2-FC Calc of REG Expansion","index":2,"n_rows":86,"n_cols":54,"rows_kept":86,"cut":false,"hidden":false,"merged":[[8,48,8,50],[42,49,42,50],[8,51,8,53],[42,52,42,53],[8,39,8,41],[42,40,42,41],[8,42,8,44],[42,43,42,44],[8,45,8,47],[42,46,42,47],[8,33,8,35],[42,34,42,35],[8,36,8,38],[42,37,42,38],[8,24,8,26],[42,25,42,26],[8,27,8,29],[42,28,42,29],[8,30,8,32],[42,31,42,32],[57,0,57,5],[58,0,58,5],[42,16,42,17],[8,6,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[39,0,39,12],[8,3,8,5],[40,0,40,1],[42,4,42,5],[42,7,42,8],[42,10,42,11],[42,13,42,14],[8,21,8,23],[42,22,42,23],[8,18,8,19],[0,0,0,5],[1,0,1,5],[3,0,3,5],[4,0,4,5],[5,0,5,5],[42,19,42,20]]}
["Appendix 2-FC"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Expansion Investments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed",null,null,2027,null,null,2028,null,null,2029,null,null,2030,null,null,2031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST Interest",null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2,null,null,3.9100000000000003E-2]
["This table will calculate the distributor/provincial shares of the investments entered in Part B of Appendix 2-FA.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LT Interest",null,null,4.19E-2,null,null,4.3499999999999997E-2,null,null,4.36E-2,null,null,4.3700000000000003E-2,null,null,4.5100000000000001E-2]
["Enter values in green shaded cells: WCA percentage, debt percentages, interest rates, kWh, tax rates, amortization period, CCA Class and percentage.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROE",null,null,0.09,null,null,0.09,null,null,0.09,null,null,0.09,null,null,0.09]
["Rate Riders are not calculated for Test Year as these assets and costs are already in the distributors rate base.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WAC",null,null,6.1029E-2,null,null,6.1896E-2,null,null,6.1992999999999999E-2,null,null,6.2053999999999998E-2,null,null,6.2847E-2]
[]
[]
[null,null,null,"2015 Test Year",null,null,2016,null,null,2017,2016,null,2018,null,null,2019,null,null,2020,null,null,{"$f":"+S9+1","v":2021},null,null,{"$f":"+V9+1","v":2022},null,null,{"$f":"+Y9+1","v":2023},null,null,{"$f":"+AB9+1","v":2024},null,null,{"$f":"+AE9+1","v":2025},null,null,{"$f":"+AH9+1","v":2026},null,null,{"$f":"+AK9+1","v":2027},null,null,{"$f":"+AN9+1","v":2028},null,null,{"$f":"+AQ9+1","v":2029},null,null,{"$f":"+AT9+1","v":2030},null,null,{"$f":"+AW9+1","v":2031}]
[null,2015,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83,"Total",0.17,0.83]
["Net Fixed Assets (average)",null,null,{"$f":"D73","v":48387.5},{"$f":"D12*E11","v":8225.875},{"$f":"D12*F11","v":40161.625},{"$f":"E73","v":130112.5},{"$f":"G12*H11","v":22119.125},{"$f":"G12*I11","v":107993.375},{"$f":"F73","v":196900},{"$f":"J12*K11","v":33473},{"$f":"J12*L11","v":163427},{"$f":"G73","v":263887.5},{"$f":"M12*N11","v":44860.875},{"$f":"M12*O11","v":219026.625},{"$f":"H73","v":331025},{"$f":"P12*Q11","v":56274.250000000007},{"$f":"P12*R11","v":274750.75},{"$f":"I73","v":359750},{"$f":"S12*T11","v":61157.500000000007},{"$f":"S12*U11","v":298592.5},{"$f":"J73","v":350000},{"$f":"V12*W11","v":59500.000000000007},{"$f":"V12*X11","v":290500},{"$f":"K73","v":340250},{"$f":"Y12*Z11","v":57842.500000000007},{"$f":"Y12*AA11","v":282407.5},{"$f":"L73","v":330500},{"$f":"AB12*AC11","v":56185.000000000007},{"$f":"AB12*AD11","v":274315},{"$f":"M73","v":320750},{"$f":"AE12*AF11","v":54527.500000000007},{"$f":"AE12*AG11","v":266222.5},{"$f":"N73","v":311541.66666666663},{"$f":"AH12*AI11","v":52962.083333333328},{"$f":"AH12*AJ11","v":258579.58333333328},{"$f":"O73","v":302875},{"$f":"AK12*AL11","v":51488.750000000007},{"$f":"AK12*AM11","v":251386.25},{"$f":"P73","v":294208.33333333331},{"$f":"AN12*AO11","v":50015.416666666664},{"$f":"AN12*AP11","v":244192.91666666663},{"$f":"Q73","v":285541.66666666663},{"$f":"AQ12*AR11","v":48542.083333333328},{"$f":"AQ12*AS11","v":236999.58333333328},{"$f":"R73","v":276875},{"$f":"AT12*AU11","v":47068.75},{"$f":"AT12*AV11","v":229806.25},{"$f":"S73","v":268208.33333333331},{"$f":"AW12*AX11","v":45595.416666666664},{"$f":"AW12*AY11","v":222612.91666666663},{"$f":"T73","v":259541.66666666666},{"$f":"AZ12*BA11","v":44122.083333333336},{"$f":"AZ12*BB11","v":215419.58333333331}]
["Incremental OM&A (on-going, N/A for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!D87","v":0},{"$f":"D13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!E87","v":0},{"$f":"G13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!F87","v":0},{"$f":"J13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!G87","v":0},{"$f":"M13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!H87","v":0},{"$f":"P13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!I87","v":0},{"$f":"S13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!J87","v":0},{"$f":"V13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!K87","v":0},{"$f":"Y13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!L87","v":0},{"$f":"AB13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!M87","v":0},{"$f":"AE13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!N87","v":0},{"$f":"AH13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!O87","v":0},{"$f":"AK13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!P87","v":0},{"$f":"AN13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!Q87","v":0},{"$f":"AQ13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!R87","v":0},{"$f":"AT13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!S87","v":0},{"$f":"AW13","v":0},null,{"$f":"'App.2-FA Proposed REG Invest.'!T87","v":0},{"$f":"AZ13","v":0}]
["Incremental OM&A (start-up, applicable for Provincial Recovery)",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!D86","v":9800},{"$f":"D14*E11","v":1666.0000000000002},{"$f":"D14*F11","v":8134},{"$f":"'App.2-FA Proposed REG Invest.'!E86","v":7000},{"$f":"G14*H11","v":1190},{"$f":"G14*I11","v":5810},{"$f":"'App.2-FA Proposed REG Invest.'!F86","v":7200},{"$f":"J14*K11","v":1224},{"$f":"J14*L11","v":5976},{"$f":"'App.2-FA Proposed REG Invest.'!G86","v":7400},{"$f":"M14*N11","v":1258},{"$f":"M14*O11","v":6142},{"$f":"'App.2-FA Proposed REG Invest.'!H86","v":7600},{"$f":"P14*Q11","v":1292},{"$f":"P14*R11","v":6308},{"$f":"'App.2-FA Proposed REG Invest.'!I86","v":0},{"$f":"S14*T11","v":0},{"$f":"S14*U11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J86","v":0},{"$f":"V14*W11","v":0},{"$f":"V14*X11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K86","v":0},{"$f":"Y14*Z11","v":0},{"$f":"Y14*AA11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L86","v":0},{"$f":"AB14*AC11","v":0},{"$f":"AB14*AD11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M86","v":0},{"$f":"AE14*AF11","v":0},{"$f":"AE14*AG11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N86","v":0},{"$f":"AH14*AI11","v":0},{"$f":"AH14*AJ11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!O86","v":0},{"$f":"AK14*AL11","v":0},{"$f":"AK14*AM11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!P86","v":0},{"$f":"AN14*AO11","v":0},{"$f":"AN14*AP11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!Q86","v":0},{"$f":"AQ14*AR11","v":0},{"$f":"AQ14*AS11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!R86","v":0},{"$f":"AT14*AU11","v":0},{"$f":"AT14*AV11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!S86","v":0},{"$f":"AW14*AX11","v":0},{"$f":"AW14*AY11","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!T86","v":0},{"$f":"AZ14*BA11","v":0},{"$f":"AZ14*BB11","v":0}]
["WCA",0.13,null,null,{"$f":"(E13+E14)*$B$15","v":216.58000000000004},{"$f":"F14*$B$15","v":1057.42},null,{"$f":"(H13+H14)*$B$15","v":154.70000000000002},{"$f":"I14*$B$15","v":755.30000000000007},null,{"$f":"(K13+K14)*$B$15","v":159.12},{"$f":"L14*$B$15","v":776.88},null,{"$f":"(N13+N14)*$B$15","v":163.54},{"$f":"O14*$B$15","v":798.46},null,{"$f":"(Q13+Q14)*$B$15","v":167.96},{"$f":"R14*$B$15","v":820.04000000000008},null,{"$f":"(T13+T14)*$B$15","v":0},{"$f":"U14*$B$15","v":0},null,{"$f":"(W13+W14)*$B$15","v":0},{"$f":"X14*$B$15","v":0},null,{"$f":"(Z13+Z14)*$B$15","v":0},{"$f":"AA14*$B$15","v":0},null,{"$f":"(AC13+AC14)*$B$15","v":0},{"$f":"AD14*$B$15","v":0},null,{"$f":"(AF13+AF14)*$B$15","v":0},{"$f":"AG14*$B$15","v":0},null,{"$f":"(AI13+AI14)*$B$15","v":0},{"$f":"AJ14*$B$15","v":0},null,{"$f":"(AL13+AL14)*$B$15","v":0},{"$f":"AM14*$B$15","v":0},null,{"$f":"(AO13+AO14)*$B$15","v":0},{"$f":"AP14*$B$15","v":0},null,{"$f":"(AR13+AR14)*$B$15","v":0},{"$f":"AS14*$B$15","v":0},null,{"$f":"(AU13+AU14)*$B$15","v":0},{"$f":"AV14*$B$15","v":0},null,{"$f":"(AX13+AX14)*$B$15","v":0},{"$f":"AY14*$B$15","v":0},null,{"$f":"(BA13+BA14)*$B$15","v":0},{"$f":"BB14*$B$15","v":0}]
["Rate Base",null,null,null,{"$f":"SUM(E12+E15)","v":8442.4549999999999},{"$f":"SUM(F12+F15)","v":41219.044999999998},null,{"$f":"SUM(H12+H15)","v":22273.825000000001},{"$f":"SUM(I12+I15)","v":108748.675},null,{"$f":"SUM(K12+K15)","v":33632.120000000003},{"$f":"SUM(L12+L15)","v":164203.88},null,{"$f":"SUM(N12+N15)","v":45024.415000000001},{"$f":"SUM(O12+O15)","v":219825.08499999999},null,{"$f":"SUM(Q12+Q15)","v":56442.210000000006},{"$f":"SUM(R12+R15)","v":275570.78999999998},null,{"$f":"SUM(T12+T15)","v":61157.500000000007},{"$f":"SUM(U12+U15)","v":298592.5},null,{"$f":"SUM(W12+W15)","v":59500.000000000007},{"$f":"SUM(X12+X15)","v":290500},null,{"$f":"SUM(Z12+Z15)","v":57842.500000000007},{"$f":"SUM(AA12+AA15)","v":282407.5},null,{"$f":"SUM(AC12+AC15)","v":56185.000000000007},{"$f":"SUM(AD12+AD15)","v":274315},null,{"$f":"SUM(AF12+AF15)","v":54527.500000000007},{"$f":"SUM(AG12+AG15)","v":266222.5},null,{"$f":"SUM(AI12+AI15)","v":52962.083333333328},{"$f":"SUM(AJ12+AJ15)","v":258579.58333333328},null,{"$f":"SUM(AL12+AL15)","v":51488.750000000007},{"$f":"SUM(AM12+AM15)","v":251386.25},null,{"$f":"SUM(AO12+AO15)","v":50015.416666666664},{"$f":"SUM(AP12+AP15)","v":244192.91666666663},null,{"$f":"SUM(AR12+AR15)","v":48542.083333333328},{"$f":"SUM(AS12+AS15)","v":236999.58333333328},null,{"$f":"SUM(AU12+AU15)","v":47068.75},{"$f":"SUM(AV12+AV15)","v":229806.25},null,{"$f":"SUM(AX12+AX15)","v":45595.416666666664},{"$f":"SUM(AY12+AY15)","v":222612.91666666663},null,{"$f":"SUM(BA12+BA15)","v":44122.083333333336},{"$f":"SUM(BB12+BB15)","v":215419.58333333331}]
[]
[]
["Deemed ST Debt",0.04,null,null,{"$f":"E16*$B$19","v":337.69819999999999},{"$f":"F16*$B$19","v":1648.7618},null,{"$f":"H16*$B$19","v":890.95300000000009},{"$f":"I16*$B$19","v":4349.9470000000001},null,{"$f":"K16*$B$19","v":1345.2848000000001},{"$f":"L16*$B$19","v":6568.1552000000001},null,{"$f":"N16*$B$19","v":1800.9766},{"$f":"O16*$B$19","v":8793.0033999999996},null,{"$f":"Q16*$B$19","v":2257.6884000000005},{"$f":"R16*$B$19","v":11022.8316},null,{"$f":"T16*$B$19","v":2446.3000000000002},{"$f":"U16*$B$19","v":11943.7},null,{"$f":"W16*$B$19","v":2380.0000000000005},{"$f":"X16*$B$19","v":11620},null,{"$f":"Z16*$B$19","v":2313.7000000000003},{"$f":"AA16*$B$19","v":11296.300000000001},null,{"$f":"AC16*$B$19","v":2247.4000000000005},{"$f":"AD16*$B$19","v":10972.6},null,{"$f":"AF16*$B$19","v":2181.1000000000004},{"$f":"AG16*$B$19","v":10648.9},null,{"$f":"AI16*$B$19","v":2118.4833333333331},{"$f":"AJ16*$B$19","v":10343.183333333332},null,{"$f":"AL16*$B$19","v":2059.5500000000002},{"$f":"AM16*$B$19","v":10055.450000000001},null,{"$f":"AO16*$B$19","v":2000.6166666666666},{"$f":"AP16*$B$19","v":9767.7166666666653},null,{"$f":"AR16*$B$19","v":1941.6833333333332},{"$f":"AS16*$B$19","v":9479.9833333333318},null,{"$f":"AU16*$B$19","v":1882.75},{"$f":"AV16*$B$19","v":9192.25},null,{"$f":"AX16*$B$19","v":1823.8166666666666},{"$f":"AY16*$B$19","v":8904.5166666666646},null,{"$f":"BA16*$B$19","v":1764.8833333333334},{"$f":"BB16*$B$19","v":8616.7833333333328}]
["Deemed LT Debt",0.56000000000000005,null,null,{"$f":"E16*$B$20","v":4727.7748000000001},{"$f":"F16*$B$20","v":23082.665199999999},null,{"$f":"H16*$B$20","v":12473.342000000002},{"$f":"I16*$B$20","v":60899.258000000009},null,{"$f":"K16*$B$20","v":18833.987200000003},{"$f":"L16*$B$20","v":91954.172800000015},null,{"$f":"N16*$B$20","v":25213.672400000003},{"$f":"O16*$B$20","v":123102.04760000001},null,{"$f":"Q16*$B$20","v":31607.637600000005},{"$f":"R16*$B$20","v":154319.64240000001},null,{"$f":"T16*$B$20","v":34248.200000000004},{"$f":"U16*$B$20","v":167211.80000000002},null,{"$f":"W16*$B$20","v":33320.000000000007},{"$f":"X16*$B$20","v":162680.00000000003},null,{"$f":"Z16*$B$20","v":32391.800000000007},{"$f":"AA16*$B$20","v":158148.20000000001},null,{"$f":"AC16*$B$20","v":31463.600000000006},{"$f":"AD16*$B$20","v":153616.40000000002},null,{"$f":"AF16*$B$20","v":30535.400000000009},{"$f":"AG16*$B$20","v":149084.6},null,{"$f":"AI16*$B$20","v":29658.766666666666},{"$f":"AJ16*$B$20","v":144804.56666666665},null,{"$f":"AL16*$B$20","v":28833.700000000008},{"$f":"AM16*$B$20","v":140776.30000000002},null,{"$f":"AO16*$B$20","v":28008.633333333335},{"$f":"AP16*$B$20","v":136748.03333333333},null,{"$f":"AR16*$B$20","v":27183.566666666666},{"$f":"AS16*$B$20","v":132719.76666666666},null,{"$f":"AU16*$B$20","v":26358.500000000004},{"$f":"AV16*$B$20","v":128691.50000000001},null,{"$f":"AX16*$B$20","v":25533.433333333334},{"$f":"AY16*$B$20","v":124663.23333333332},null,{"$f":"BA16*$B$20","v":24708.366666666669},{"$f":"BB16*$B$20","v":120634.96666666667}]
["Deemed Equity",0.4,null,null,{"$f":"E16*$B$21","v":3376.982},{"$f":"F16*$B$21","v":16487.617999999999},null,{"$f":"H16*$B$21","v":8909.5300000000007},{"$f":"I16*$B$21","v":43499.47},null,{"$f":"K16*$B$21","v":13452.848000000002},{"$f":"L16*$B$21","v":65681.552000000011},null,{"$f":"N16*$B$21","v":18009.766},{"$f":"O16*$B$21","v":87930.034},null,{"$f":"Q16*$B$21","v":22576.884000000005},{"$f":"R16*$B$21","v":110228.31599999999},null,{"$f":"T16*$B$21","v":24463.000000000004},{"$f":"U16*$B$21","v":119437},null,{"$f":"W16*$B$21","v":23800.000000000004},{"$f":"X16*$B$21","v":116200},null,{"$f":"Z16*$B$21","v":23137.000000000004},{"$f":"AA16*$B$21","v":112963},null,{"$f":"AC16*$B$21","v":22474.000000000004},{"$f":"AD16*$B$21","v":109726},null,{"$f":"AF16*$B$21","v":21811.000000000004},{"$f":"AG16*$B$21","v":106489},null,{"$f":"AI16*$B$21","v":21184.833333333332},{"$f":"AJ16*$B$21","v":103431.83333333331},null,{"$f":"AL16*$B$21","v":20595.500000000004},{"$f":"AM16*$B$21","v":100554.5},null,{"$f":"AO16*$B$21","v":20006.166666666668},{"$f":"AP16*$B$21","v":97677.166666666657},null,{"$f":"AR16*$B$21","v":19416.833333333332},{"$f":"AS16*$B$21","v":94799.833333333314},null,{"$f":"AU16*$B$21","v":18827.5},{"$f":"AV16*$B$21","v":91922.5},null,{"$f":"AX16*$B$21","v":18238.166666666668},{"$f":"AY16*$B$21","v":89045.166666666657},null,{"$f":"BA16*$B$21","v":17648.833333333336},{"$f":"BB16*$B$21","v":86167.833333333328}]
[]
["ST Interest",2.1600000000000001E-2,null,null,{"$f":"E19*$B$23","v":7.29428112},{"$f":"F19*$B$23","v":35.61325488},null,{"$f":"H19*$B$23","v":19.244584800000002},{"$f":"I19*$B$23","v":93.958855200000002},null,{"$f":"K19*$B$23","v":29.058151680000005},{"$f":"L19*$B$23","v":141.87215232},null,{"$f":"N19*$B$23","v":38.901094560000004},{"$f":"O19*$B$23","v":189.92887343999999},null,{"$f":"Q19*$B$23","v":48.76606944000001},{"$f":"R19*$B$23","v":238.09316256},null,{"$f":"T19*$B$23","v":52.840080000000007},{"$f":"U19*$B$23","v":257.98392000000001},null,{"$f":"W19*$B$23","v":51.408000000000015},{"$f":"X19*$B$23","v":250.99200000000002},null,{"$f":"Z19*$B$23","v":49.975920000000009},{"$f":"AA19*$B$23","v":244.00008000000003},null,{"$f":"AC19*$B$23","v":48.543840000000017},{"$f":"AD19*$B$23","v":237.00816000000003},null,{"$f":"AF19*$B$23","v":47.111760000000011},{"$f":"AG19*$B$23","v":230.01624000000001},null,{"$f":"AI19*$B$23","v":45.759239999999998},{"$f":"AJ19*$B$23","v":223.41275999999999},null,{"$f":"AL19*$B$23","v":44.486280000000008},{"$f":"AM19*$B$23","v":217.19772000000003},null,{"$f":"AO19*AO3","v":78.224111666666673},{"$f":"AP19*AO3","v":381.91772166666664},null,{"$f":"AR19*AR3","v":75.919818333333339},{"$f":"AS19*AR3","v":370.66734833333328},null,{"$f":"AU19*AU3","v":73.615525000000005},{"$f":"AV19*AU3","v":359.41697500000004},null,{"$f":"AX19*AX3","v":71.311231666666671},{"$f":"AY19*AX3","v":348.16660166666662},null,{"$f":"BA19*BA3","v":69.006938333333338},{"$f":"BB19*BA3","v":336.91622833333332}]
["LT Interest",6.0728710462287103E-2,null,null,{"$f":"E20*$B$24","v":287.1116669600973},{"$f":"F20*$B$24","v":1401.7804916287105},null,{"$f":"H20*$B$24","v":757.48997481508525},{"$f":"I20*$B$24","v":3698.3334064501219},null,{"$f":"K20*$B$24","v":1143.7637555192216},{"$f":"L20*$B$24","v":5584.258335770317},null,{"$f":"N20*$B$24","v":1531.1938108705597},{"$f":"O20*$B$24","v":7475.8286060150849},null,{"$f":"Q20*$B$24","v":1919.4910722072996},{"$f":"R20*$B$24","v":9371.6328819532846},null,{"$f":"T20*$B$24","v":2079.8490216545015},{"$f":"U20*$B$24","v":10154.55698807786},null,{"$f":"W20*$B$24","v":2023.4806326034068},{"$f":"X20*$B$24","v":9879.3466180048672},null,{"$f":"Z20*$B$24","v":1967.1122435523118},{"$f":"AA20*$B$24","v":9604.1362479318741},null,{"$f":"AC20*$B$24","v":1910.7438545012169},{"$f":"AD20*$B$24","v":9328.925877858881},null,{"$f":"AF20*$B$24","v":1854.3754654501222},{"$f":"AG20*$B$24","v":9053.7155077858879},null,{"$f":"AI20*$B$24","v":1801.1386535685319},{"$f":"AJ20*$B$24","v":8793.7946027169492},null,{"$f":"AL20*$B$24","v":1751.0334188564482},{"$f":"AM20*$B$24","v":8549.1631626520684},null,{"$f":"AO20*AO4","v":1173.5617366666668},{"$f":"AP20*AO4","v":5729.742596666666},null,{"$f":"AR20*AR4","v":1182.48515},{"$f":"AS20*AR4","v":5773.3098499999996},null,{"$f":"AU20*AU4","v":1149.2306000000001},{"$f":"AV20*AU4","v":5610.9494000000004},null,{"$f":"AX20*AX4","v":1115.8110366666667},{"$f":"AY20*AX4","v":5447.7832966666665},null,{"$f":"BA20*BA4","v":1114.3473366666667},{"$f":"BB20*BA4","v":5440.6369966666671}]
["ROE",9.2999999999999999E-2,null,null,{"$f":"E21*$B$25","v":314.059326},{"$f":"F21*$B$25","v":1533.3484739999999},null,{"$f":"H21*$B$25","v":828.58629000000008},{"$f":"I21*$B$25","v":4045.4507100000001},null,{"$f":"K21*$B$25","v":1251.1148640000001},{"$f":"L21*$B$25","v":6108.384336000001},null,{"$f":"N21*$B$25","v":1674.908238},{"$f":"O21*$B$25","v":8177.4931619999998},null,{"$f":"Q21*$B$25","v":2099.6502120000005},{"$f":"R21*$B$25","v":10251.233387999999},null,{"$f":"T21*$B$25","v":2275.0590000000002},{"$f":"U21*$B$25","v":11107.641},null,{"$f":"W21*$B$25","v":2213.4000000000005},{"$f":"X21*$B$25","v":10806.6},null,{"$f":"Z21*$B$25","v":2151.7410000000004},{"$f":"AA21*$B$25","v":10505.558999999999},null,{"$f":"AC21*$B$25","v":2090.0820000000003},{"$f":"AD21*$B$25","v":10204.518},null,{"$f":"AF21*$B$25","v":2028.4230000000002},{"$f":"AG21*$B$25","v":9903.4770000000008},null,{"$f":"AI21*$B$25","v":1970.1895},{"$f":"AJ21*$B$25","v":9619.1604999999981},null,{"$f":"AL21*$B$25","v":1915.3815000000004},{"$f":"AM21*$B$25","v":9351.5684999999994},null,{"$f":"AO21*AO5","v":1800.5550000000001},{"$f":"AP21*AO5","v":8790.9449999999997},null,{"$f":"AR21*AR5","v":1747.5149999999999},{"$f":"AS21*AR5","v":8531.9849999999988},null,{"$f":"AU21*AU5","v":1694.4749999999999},{"$f":"AV21*AU5","v":8273.0249999999996},null,{"$f":"AX21*AX5","v":1641.4349999999999},{"$f":"AY21*AX5","v":8014.0649999999987},null,{"$f":"BA21*BA5","v":1588.3950000000002},{"$f":"BB21*BA5","v":7755.1049999999996}]
["Cost of Capital Total",null,null,null,{"$f":"SUM(E23:E25)","v":608.46527408009729},{"$f":"SUM(F23:F25)","v":2970.7422205087105},null,{"$f":"SUM(H23:H25)","v":1605.3208496150853},{"$f":"SUM(I23:I25)","v":7837.7429716501219},null,{"$f":"SUM(K23:K25)","v":2423.9367711992218},{"$f":"SUM(L23:L25)","v":11834.514824090318},null,{"$f":"SUM(N23:N25)","v":3245.0031434305597},{"$f":"SUM(O23:O25)","v":15843.250641455084},null,{"$f":"SUM(Q23:Q25)","v":4067.9073536472997},{"$f":"SUM(R23:R25)","v":19860.959432513286},null,{"$f":"SUM(T23:T25)","v":4407.7481016545016},{"$f":"SUM(U23:U25)","v":21520.181908077859},null,{"$f":"SUM(W23:W25)","v":4288.2886326034077},{"$f":"SUM(X23:X25)","v":20936.938618004868},null,{"$f":"SUM(Z23:Z25)","v":4168.8291635523128},{"$f":"SUM(AA23:AA25)","v":20353.695327931873},null,{"$f":"SUM(AC23:AC25)","v":4049.3696945012171},{"$f":"SUM(AD23:AD25)","v":19770.452037858879},null,{"$f":"SUM(AF23:AF25)","v":3929.9102254501222},{"$f":"SUM(AG23:AG25)","v":19187.208747785888},null,{"$f":"SUM(AI23:AI25)","v":3817.0873935685322},{"$f":"SUM(AJ23:AJ25)","v":18636.367862716947},null,{"$f":"SUM(AL23:AL25)","v":3710.9011988564489},{"$f":"SUM(AM23:AM25)","v":18117.929382652066},null,{"$f":"SUM(AO23:AO25)","v":3052.3408483333333},{"$f":"SUM(AP23:AP25)","v":14902.605318333332},null,{"$f":"SUM(AR23:AR25)","v":3005.9199683333331},{"$f":"SUM(AS23:AS25)","v":14675.962198333331},null,{"$f":"SUM(AU23:AU25)","v":2917.3211249999999},{"$f":"SUM(AV23:AV25)","v":14243.391374999999},null,{"$f":"SUM(AX23:AX25)","v":2828.557268333333},{"$f":"SUM(AY23:AY25)","v":13810.014898333331},null,{"$f":"SUM(BA23:BA25)","v":2771.7492750000001},{"$f":"SUM(BB23:BB25)","v":13532.658224999999}]
[]
["OM&A",null,null,null,{"$f":"E13+E14","v":1666.0000000000002},{"$f":"F14","v":8134},null,{"$f":"H13+H14","v":1190},{"$f":"I14","v":5810},null,{"$f":"K13+K14","v":1224},{"$f":"L14","v":5976},null,{"$f":"N13+N14","v":1258},{"$f":"O14","v":6142},null,{"$f":"Q13+Q14","v":1292},{"$f":"R14","v":6308},null,{"$f":"T13+T14","v":0},{"$f":"U14","v":0},null,{"$f":"W13+W14","v":0},{"$f":"X14","v":0},null,{"$f":"Z13+Z14","v":0},{"$f":"AA14","v":0},null,{"$f":"AC13+AC14","v":0},{"$f":"AD14","v":0},null,{"$f":"AF13+AF14","v":0},{"$f":"AG14","v":0},null,{"$f":"AI13+AI14","v":0},{"$f":"AJ14","v":0},null,{"$f":"AL13+AL14","v":0},{"$f":"AM14","v":0},null,{"$f":"AO13+AO14","v":0},{"$f":"AP14","v":0},null,{"$f":"AR13+AR14","v":0},{"$f":"AS14","v":0},null,{"$f":"AU13+AU14","v":0},{"$f":"AV14","v":0},null,{"$f":"AX13+AX14","v":0},{"$f":"AY14","v":0},null,{"$f":"BA13+BA14","v":0},{"$f":"BB14","v":0}]
["Amortization",null,null,{"$f":"D69","v":1225},{"$f":"D29*E$11","v":208.25000000000003},{"$f":"D29*F$11","v":1016.75},{"$f":"E67+E68","v":3325},{"$f":"G29*H$11","v":565.25},{"$f":"G29*I$11","v":2759.75},{"$f":"F67+F68","v":5100},{"$f":"J29*K$11","v":867.00000000000011},{"$f":"J29*L$11","v":4233},{"$f":"G67+G68","v":6925},{"$f":"M29*N$11","v":1177.25},{"$f":"M29*O$11","v":5747.75},{"$f":"H67+H68","v":8800},{"$f":"P29*Q$11","v":1496},{"$f":"P29*R$11","v":7304},{"$f":"I67+I68","v":9750},{"$f":"S29*T$11","v":1657.5000000000002},{"$f":"S29*U$11","v":8092.5},{"$f":"J67+J68","v":9750},{"$f":"V29*W$11","v":1657.5000000000002},{"$f":"V29*X$11","v":8092.5},{"$f":"K67+K68","v":9750},{"$f":"Y29*Z$11","v":1657.5000000000002},{"$f":"Y29*AA$11","v":8092.5},{"$f":"L67+L68","v":9750},{"$f":"AB29*AC$11","v":1657.5000000000002},{"$f":"AB29*AD$11","v":8092.5},{"$f":"M67+M68","v":9750},{"$f":"AE29*AF$11","v":1657.5000000000002},{"$f":"AE29*AG$11","v":8092.5},{"$f":"N67+N68","v":8666.6666666666661},{"$f":"AH29*AI$11","v":1473.3333333333333},{"$f":"AH29*AJ$11","v":7193.3333333333321},{"$f":"O67+O68","v":8666.6666666666661},{"$f":"AK29*AL$11","v":1473.3333333333333},{"$f":"AK29*AM$11","v":7193.3333333333321},{"$f":"P67+P68","v":8666.6666666666661},{"$f":"AN29*AO$11","v":1473.3333333333333},{"$f":"AN29*AP$11","v":7193.3333333333321},{"$f":"Q67+Q68","v":8666.6666666666661},{"$f":"AQ29*AR$11","v":1473.3333333333333},{"$f":"AQ29*AS$11","v":7193.3333333333321},{"$f":"R67+R68","v":8666.6666666666661},{"$f":"AT29*AU$11","v":1473.3333333333333},{"$f":"AT29*AV$11","v":7193.3333333333321},{"$f":"S67+S68","v":8666.6666666666661},{"$f":"AW29*AX$11","v":1473.3333333333333},{"$f":"AW29*AY$11","v":7193.3333333333321},{"$f":"T67+T68","v":8666.6666666666661},{"$f":"AZ29*BA$11","v":1473.3333333333333},{"$f":"AZ29*BB$11","v":7193.3333333333321}]
["Grossed-up PILs",null,null,null,{"$f":"E55","v":-51.951059333333355},{"$f":"F55","v":-253.64340733333336},null,{"$f":"H55","v":-130.3914328571428},{"$f":"I55","v":-636.61699571428517},null,{"$f":"K55","v":-166.76399379591848},{"$f":"L55","v":-814.20067559183644},null,{"$f":"N55","v":-185.6221542557825},{"$f":"O55","v":-906.27287077823235},null,{"$f":"Q55","v":-188.19941898253074},{"$f":"R55","v":-918.85598679706243},null,{"$f":"T55","v":-134.29093034229589},{"$f":"U55","v":-655.65571873003228},null,{"$f":"W55","v":-32.349539180218066},{"$f":"X55","v":-157.94186776224123},null,{"$f":"Z55","v":59.65807701542392},{"$f":"AA55","v":291.27178778118753},null,{"$f":"AC55","v":142.52662024194512},{"$f":"AD55","v":695.86526353420254},null,{"$f":"AF55","v":216.98721633687515},{"$f":"AG55","v":1059.4081738800367},null,{"$f":"AI55","v":218.54731853105875},{"$f":"AJ55","v":1067.0251434163449},null,{"$f":"AL55","v":280.62620524812058},{"$f":"AM55","v":1370.1161785643524},null,{"$f":"AO55","v":314.51860129992616},{"$f":"AP55","v":1535.5908181114039},null,{"$f":"AR55","v":364.66436852473026},{"$f":"AS55","v":1780.420152208977},null,{"$f":"AU55","v":409.26861314706025},{"$f":"AV55","v":1998.1938171297647},null,{"$f":"AX55","v":448.77465697511394},{"$f":"AY55","v":2191.0762664079089},null,{"$f":"BA55","v":483.59035607243374},{"$f":"BB55","v":2361.0587972948229}]
[]
["Revenue Requirement",null,null,null,{"$f":"SUM(E26:E30)","v":2430.7642147467641},{"$f":"SUM(F26:F30)","v":11867.848813175377},null,{"$f":"SUM(H26:H30)","v":3230.1794167579428},{"$f":"SUM(I26:I30)","v":15770.875975935836},null,{"$f":"SUM(K26:K30)","v":4348.1727774033034},{"$f":"SUM(L26:L30)","v":21229.314148498481},null,{"$f":"SUM(N26:N30)","v":5494.6309891747778},{"$f":"SUM(O26:O30)","v":26826.727770676851},null,{"$f":"SUM(Q26:Q30)","v":6667.7079346647688},{"$f":"SUM(R26:R30)","v":32554.103445716224},null,{"$f":"SUM(T26:T30)","v":5930.9571713122059},{"$f":"SUM(U26:U30)","v":28957.026189347827},null,{"$f":"SUM(W26:W30)","v":5913.4390934231897},{"$f":"SUM(X26:X30)","v":28871.496750242626},null,{"$f":"SUM(Z26:Z30)","v":5885.987240567737},{"$f":"SUM(AA26:AA30)","v":28737.467115713062},null,{"$f":"SUM(AC26:AC30)","v":5849.3963147431623},{"$f":"SUM(AD26:AD30)","v":28558.817301393083},null,{"$f":"SUM(AF26:AF30)","v":5804.3974417869977},{"$f":"SUM(AG26:AG30)","v":28339.116921665925},null,{"$f":"SUM(AI26:AI30)","v":5508.9680454329236},{"$f":"SUM(AJ26:AJ30)","v":26896.726339466622},null,{"$f":"SUM(AL26:AL30)","v":5464.8607374379026},{"$f":"SUM(AM26:AM30)","v":26681.378894549751},null,{"$f":"SUM(AO26:AO30)","v":4840.1927829665929},{"$f":"SUM(AP26:AP30)","v":23631.529469778066},null,{"$f":"SUM(AR26:AR30)","v":4843.9176701913966},{"$f":"SUM(AS26:AS30)","v":23649.715683875642},null,{"$f":"SUM(AU26:AU30)","v":4799.9230714803934},{"$f":"SUM(AV26:AV30)","v":23434.918525463097},null,{"$f":"SUM(AX26:AX30)","v":4750.6652586417804},{"$f":"SUM(AY26:AY30)","v":23194.424498074572},null,{"$f":"SUM(BA26:BA30)","v":4728.6729644057668},{"$f":"SUM(BB26:BB30)","v":23087.050355628155}]
[]
[]
["Provincial Rate Protection",null,null,null,null,{"$f":"F32","v":11867.848813175377},null,null,{"$f":"I32","v":15770.875975935836},null,null,{"$f":"L32","v":21229.314148498481},null,null,{"$f":"O32","v":26826.727770676851},null,null,{"$f":"R32","v":32554.103445716224},null,null,{"$f":"U32","v":28957.026189347827},null,null,{"$f":"X32","v":28871.496750242626},null,null,{"$f":"AA32","v":28737.467115713062},null,null,{"$f":"AD32","v":28558.817301393083},null,null,{"$f":"AG32","v":28339.116921665925},null,null,{"$f":"AJ32","v":26896.726339466622},null,null,{"$f":"AM32","v":26681.378894549751},null,null,{"$f":"AP32","v":23631.529469778066},null,null,{"$f":"AS32","v":23649.715683875642},null,null,{"$f":"AV32","v":23434.918525463097},null,null,{"$f":"AY32","v":23194.424498074572},null,null,{"$f":"BB32","v":23087.050355628155}]
[]
["Monthly Amount Paid by IESO",null,null,null,null,{"$f":"F35/12","v":988.98740109794801},null,null,{"$f":"I35/12","v":1314.2396646613197},null,null,{"$f":"L35/12","v":1769.1095123748735},null,null,{"$f":"O35/12","v":2235.5606475564041},null,null,{"$f":"R35/12","v":2712.8419538096855},null,null,{"$f":"U35/12","v":2413.0855157789856},null,null,{"$f":"X35/12","v":2405.9580625202188},null,null,{"$f":"AA35/12","v":2394.7889263094216},null,null,{"$f":"AD35/12","v":2379.901441782757},null,null,{"$f":"AG35/12","v":2361.5930768054936},null,null,{"$f":"AJ35/12","v":2241.3938616222185},null,null,{"$f":"AM35/12","v":2223.4482412124794},null,null,{"$f":"AP35/12","v":1969.2941224815056},null,null,{"$f":"AS35/12","v":1970.8096403229702},null,null,{"$f":"AV35/12","v":1952.9098771219249},null,null,{"$f":"AY35/12","v":1932.868708172881},null,null,{"$f":"BB35/12","v":1923.9208629690129}]
[]
["Note 1: The difference between the actual costs of approved eligible investments and revenue received from the IESO should be recorded in a variance account.  The Board may provide regulatory accounting guidance regarding a variance account either in an individual proceeding or on a generic basis."]
["Note 2: For the 2014 Test Year, Costs and Revenues of the Direct Benefit are to be included in the test year applicant Rate Base and Revenues."]
[]
["PILs Calculation"]
[null,null,null,null,2015,null,null,2016,null,null,2017,null,null,2018,null,null,2019,null,null,{"$f":"S9","v":2020},null,null,{"$f":"V9","v":2021},null,null,{"$f":"Y9","v":2022},null,null,{"$f":"AB9","v":2023},null,null,{"$f":"AE9","v":2024},null,null,{"$f":"AH9","v":2025},null,null,{"$f":"AK9","v":2026},null,null,{"$f":"AN9","v":2027},null,null,{"$f":"AQ9","v":2028},null,null,{"$f":"AT9","v":2029},null,null,{"$f":"AW9","v":2030},null,null,{"$f":"AZ9","v":2031}]
["Income Tax",null,null,null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial",null,"Direct Benefit","Provincial"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total",null,null,"Total"]
["Net Income - ROE on Rate Base",null,null,null,{"$f":"E25","v":314.059326},{"$f":"F25","v":1533.3484739999999},null,{"$f":"H25","v":828.58629000000008},{"$f":"I25","v":4045.4507100000001},null,{"$f":"K25","v":1251.1148640000001},{"$f":"L25","v":6108.384336000001},null,{"$f":"N25","v":1674.908238},{"$f":"O25","v":8177.4931619999998},null,{"$f":"Q25","v":2099.6502120000005},{"$f":"R25","v":10251.233387999999},null,{"$f":"T25","v":2275.0590000000002},{"$f":"U25","v":11107.641},null,{"$f":"W25","v":2213.4000000000005},{"$f":"X25","v":10806.6},null,{"$f":"Z25","v":2151.7410000000004},{"$f":"AA25","v":10505.558999999999},null,{"$f":"AC25","v":2090.0820000000003},{"$f":"AD25","v":10204.518},null,{"$f":"AF25","v":2028.4230000000002},{"$f":"AG25","v":9903.4770000000008},null,{"$f":"AI25","v":1970.1895},{"$f":"AJ25","v":9619.1604999999981},null,{"$f":"AL25","v":1915.3815000000004},{"$f":"AM25","v":9351.5684999999994},null,{"$f":"AO25","v":1800.5550000000001},{"$f":"AP25","v":8790.9449999999997},null,{"$f":"AR25","v":1747.5149999999999},{"$f":"AS25","v":8531.9849999999988},null,{"$f":"AU25","v":1694.4749999999999},{"$f":"AV25","v":8273.0249999999996},null,{"$f":"AX25","v":1641.4349999999999},{"$f":"AY25","v":8014.0649999999987},null,{"$f":"BA25","v":1588.3950000000002},{"$f":"BB25","v":7755.1049999999996}]
["Amortization (17% DB and 83% P)",null,null,null,{"$f":"E29","v":208.25000000000003},{"$f":"F29","v":1016.75},null,{"$f":"H29","v":565.25},{"$f":"I29","v":2759.75},null,{"$f":"K29","v":867.00000000000011},{"$f":"L29","v":4233},null,{"$f":"N29","v":1177.25},{"$f":"O29","v":5747.75},null,{"$f":"Q29","v":1496},{"$f":"R29","v":7304},null,{"$f":"T29","v":1657.5000000000002},{"$f":"U29","v":8092.5},null,{"$f":"W29","v":1657.5000000000002},{"$f":"X29","v":8092.5},null,{"$f":"Z29","v":1657.5000000000002},{"$f":"AA29","v":8092.5},null,{"$f":"AC29","v":1657.5000000000002},{"$f":"AD29","v":8092.5},null,{"$f":"AF29","v":1657.5000000000002},{"$f":"AG29","v":8092.5},null,{"$f":"AI29","v":1473.3333333333333},{"$f":"AJ29","v":7193.3333333333321},null,{"$f":"AL29","v":1473.3333333333333},{"$f":"AM29","v":7193.3333333333321},null,{"$f":"AO29","v":1473.3333333333333},{"$f":"AP29","v":7193.3333333333321},null,{"$f":"AR29","v":1473.3333333333333},{"$f":"AS29","v":7193.3333333333321},null,{"$f":"AU29","v":1473.3333333333333},{"$f":"AV29","v":7193.3333333333321},null,{"$f":"AX29","v":1473.3333333333333},{"$f":"AY29","v":7193.3333333333321},null,{"$f":"BA29","v":1473.3333333333333},{"$f":"BB29","v":7193.3333333333321}]
["CCA (17% DB and 83% P)",null,null,null,{"$f":"-D85*E$11","v":-666.40000000000009},{"$f":"-D85*F$11","v":-3253.6},null,{"$f":"-E85*H$11","v":-1755.4880000000001},{"$f":"-E85*I$11","v":-8570.9119999999984},null,{"$f":"-F85*K$11","v":-2580.6489600000004},{"$f":"-F85*L$11","v":-12599.63904},null,{"$f":"-G85*N$11","v":-3366.9970432000005},{"$f":"-G85*O$11","v":-16438.867916800002},null,{"$f":"-H85*Q$11","v":-4117.6372797440008},{"$f":"-H85*R$11","v":-20103.758483456004},null,{"$f":"-I85*T$11","v":-4305.0262973644813},{"$f":"-I85*U$11","v":-21018.657804779523},null,{"$f":"-J85*W$11","v":-3960.6241935753224},{"$f":"-J85*X$11","v":-19337.165180397158},null,{"$f":"-K85*Z$11","v":-3643.7742580892968},{"$f":"-K85*AA$11","v":-17790.191965965387},null,{"$f":"-L85*AC$11","v":-3352.2723174421526},{"$f":"-L85*AD$11","v":-16366.976608688155},null,{"$f":"-M85*AF$11","v":-3084.0905320467809},{"$f":"-M85*AG$11","v":-15057.618479993105},null,{"$f":"-N85*AI$11","v":-2837.3632894830384},{"$f":"-N85*AJ$11","v":-13853.009001593657},null,{"$f":"-O85*AL$11","v":-2610.3742263243953},{"$f":"-O85*AM$11","v":-12744.768281466164},null,{"$f":"-P85*AO$11","v":-2401.5442882184439},{"$f":"-P85*AP$11","v":-11725.186818948872},null,{"$f":"-Q85*AR$11","v":-2209.4207451609682},{"$f":"-Q85*AS$11","v":-10787.171873432961},null,{"$f":"-R85*AU$11","v":-2032.6670855480909},{"$f":"-R85*AV$11","v":-9924.1981235583244},null,{"$f":"-S85*AX$11","v":-1870.0537187042439},{"$f":"-S85*AY$11","v":-9130.2622736736594},null,{"$f":"-T85*BA$11","v":-1720.4494212079042},{"$f":"-T85*BB$11","v":-8399.8412917797668}]
["Taxable income",null,null,null,{"$f":"SUM(E46:E48)","v":-144.09067400000004},{"$f":"SUM(F46:F48)","v":-703.50152600000001},null,{"$f":"SUM(H46:H48)","v":-361.65170999999987},{"$f":"SUM(I46:I48)","v":-1765.7112899999984},null,{"$f":"SUM(K46:K48)","v":-462.53409600000032},{"$f":"SUM(L46:L48)","v":-2258.254703999999},null,{"$f":"SUM(N46:N48)","v":-514.83880520000048},{"$f":"SUM(O46:O48)","v":-2513.6247548000028},null,{"$f":"SUM(Q46:Q48)","v":-521.98706774400034},{"$f":"SUM(R46:R48)","v":-2548.5250954560033},null,{"$f":"SUM(T46:T48)","v":-372.46729736448106},{"$f":"SUM(U46:U48)","v":-1818.5168047795232},null,{"$f":"SUM(W46:W48)","v":-89.724193575321806},{"$f":"SUM(X46:X48)","v":-438.06518039715957},null,{"$f":"SUM(Z46:Z48)","v":165.46674191070406},{"$f":"SUM(AA46:AA48)","v":807.86703403461433},null,{"$f":"SUM(AC46:AC48)","v":395.30968255784774},{"$f":"SUM(AD46:AD48)","v":1930.0413913118446},null,{"$f":"SUM(AF46:AF48)","v":601.83246795321975},{"$f":"SUM(AG46:AG48)","v":2938.3585200068937},null,{"$f":"SUM(AI46:AI48)","v":606.15954385029499},{"$f":"SUM(AJ46:AJ48)","v":2959.4848317396736},null,{"$f":"SUM(AL46:AL48)","v":778.34060700893815},{"$f":"SUM(AM46:AM48)","v":3800.1335518671658},null,{"$f":"SUM(AO46:AO48)","v":872.34404511488947},{"$f":"SUM(AP46:AP48)","v":4259.0915143844595},null,{"$f":"SUM(AR46:AR48)","v":1011.4275881723652},{"$f":"SUM(AS46:AS48)","v":4938.1464599003702},null,{"$f":"SUM(AU46:AU48)","v":1135.1412477852425},{"$f":"SUM(AV46:AV48)","v":5542.1602097750074},null,{"$f":"SUM(AX46:AX48)","v":1244.7146146290895},{"$f":"SUM(AY46:AY48)","v":6077.1360596596714},null,{"$f":"SUM(BA46:BA48)","v":1341.2789121254293},{"$f":"SUM(BB46:BB48)","v":6548.5970415535648}]
[]
["Tax Rate  (to be entered)",null,null,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001,null,0.26500000000000001,0.26500000000000001]
["Income Taxes Payable",null,null,null,{"$f":"E49*E51","v":-38.184028610000013},{"$f":"F49*F51","v":-186.42790439000001},null,{"$f":"H49*H51","v":-95.837703149999967},{"$f":"I49*I51","v":-467.91349184999962},null,{"$f":"K49*K51","v":-122.57153544000009},{"$f":"L49*L51","v":-598.43749655999977},null,{"$f":"N49*N51","v":-136.43228337800014},{"$f":"O49*O51","v":-666.11056002200075},null,{"$f":"Q49*Q51","v":-138.32657295216009},{"$f":"R49*R51","v":-675.35915029584089},null,{"$f":"T49*T51","v":-98.703833801587479},{"$f":"U49*U51","v":-481.90695326657368},null,{"$f":"W49*W51","v":-23.776911297460281},{"$f":"X49*X51","v":-116.0872728052473},null,{"$f":"Z49*Z51","v":43.848686606336578},{"$f":"AA49*AA51","v":214.08476401917281},null,{"$f":"AC49*AC51","v":104.75706587782966},{"$f":"AD49*AD51","v":511.46096869763886},null,{"$f":"AF49*AF51","v":159.48560400760323},{"$f":"AG49*AG51","v":778.66500780182685},null,{"$f":"AI49*AI51","v":160.63227912032818},{"$f":"AJ49*AJ51","v":784.26348041101357},null,{"$f":"AL49*AL51","v":206.26026085736862},{"$f":"AM49*AM51","v":1007.035391244799},null,{"$f":"AO49*AO51","v":231.17117195544571},{"$f":"AP49*AP51","v":1128.6592513118819},null,{"$f":"AR49*AR51","v":268.02831086567676},{"$f":"AS49*AS51","v":1308.6088118735981},null,{"$f":"AU49*AU51","v":300.81243066308929},{"$f":"AV49*AV51","v":1468.672455590377},null,{"$f":"AX49*AX51","v":329.84937287670874},{"$f":"AY49*AY51","v":1610.441055809813},null,{"$f":"BA49*BA51","v":355.43891171323878},{"$f":"BB49*BB51","v":1735.3782160116948}]
["Gross Up"]
["Income Taxes Payable",null,null,null,{"$f":"E52/(1-E51)","v":-51.951059333333355},{"$f":"F52/(1-F51)","v":-253.64340733333336},null,{"$f":"H52/(1-H51)","v":-130.3914328571428},{"$f":"I52/(1-I51)","v":-636.61699571428517},null,{"$f":"K52/(1-K51)","v":-166.76399379591848},{"$f":"L52/(1-L51)","v":-814.20067559183644},null,{"$f":"N52/(1-N51)","v":-185.6221542557825},{"$f":"O52/(1-O51)","v":-906.27287077823235},null,{"$f":"Q52/(1-Q51)","v":-188.19941898253074},{"$f":"R52/(1-R51)","v":-918.85598679706243},null,{"$f":"T52/(1-T51)","v":-134.29093034229589},{"$f":"U52/(1-U51)","v":-655.65571873003228},null,{"$f":"W52/(1-W51)","v":-32.349539180218066},{"$f":"X52/(1-X51)","v":-157.94186776224123},null,{"$f":"Z52/(1-Z51)","v":59.65807701542392},{"$f":"AA52/(1-AA51)","v":291.27178778118753},null,{"$f":"AC52/(1-AC51)","v":142.52662024194512},{"$f":"AD52/(1-AD51)","v":695.86526353420254},null,{"$f":"AF52/(1-AF51)","v":216.98721633687515},{"$f":"AG52/(1-AG51)","v":1059.4081738800367},null,{"$f":"AI52/(1-AI51)","v":218.54731853105875},{"$f":"AJ52/(1-AJ51)","v":1067.0251434163449},null,{"$f":"AL52/(1-AL51)","v":280.62620524812058},{"$f":"AM52/(1-AM51)","v":1370.1161785643524},null,{"$f":"AO52/(1-AO51)","v":314.51860129992616},{"$f":"AP52/(1-AP51)","v":1535.5908181114039},null,{"$f":"AR52/(1-AR51)","v":364.66436852473026},{"$f":"AS52/(1-AS51)","v":1780.420152208977},null,{"$f":"AU52/(1-AU51)","v":409.26861314706025},{"$f":"AV52/(1-AV51)","v":1998.1938171297647},null,{"$f":"AX52/(1-AX51)","v":448.77465697511394},{"$f":"AY52/(1-AY51)","v":2191.0762664079089},null,{"$f":"BA52/(1-BA51)","v":483.59035607243374},{"$f":"BB52/(1-BB51)","v":2361.0587972948229}]
["Grossed Up PILs",null,null,null,{"$f":"SUM(E54:E54)","v":-51.951059333333355},{"$f":"SUM(F54:F54)","v":-253.64340733333336},null,{"$f":"SUM(H54:H54)","v":-130.3914328571428},{"$f":"SUM(I54:I54)","v":-636.61699571428517},null,{"$f":"SUM(K54:K54)","v":-166.76399379591848},{"$f":"SUM(L54:L54)","v":-814.20067559183644},null,{"$f":"SUM(N54:N54)","v":-185.6221542557825},{"$f":"SUM(O54:O54)","v":-906.27287077823235},null,{"$f":"SUM(Q54:Q54)","v":-188.19941898253074},{"$f":"SUM(R54:R54)","v":-918.85598679706243},null,{"$f":"SUM(T54:T54)","v":-134.29093034229589},{"$f":"SUM(U54:U54)","v":-655.65571873003228},null,{"$f":"SUM(W54:W54)","v":-32.349539180218066},{"$f":"SUM(X54:X54)","v":-157.94186776224123},null,{"$f":"SUM(Z54:Z54)","v":59.65807701542392},{"$f":"SUM(AA54:AA54)","v":291.27178778118753},null,{"$f":"SUM(AC54:AC54)","v":142.52662024194512},{"$f":"SUM(AD54:AD54)","v":695.86526353420254},null,{"$f":"SUM(AF54:AF54)","v":216.98721633687515},{"$f":"SUM(AG54:AG54)","v":1059.4081738800367},null,{"$f":"SUM(AI54:AI54)","v":218.54731853105875},{"$f":"SUM(AJ54:AJ54)","v":1067.0251434163449},null,{"$f":"SUM(AL54:AL54)","v":280.62620524812058},{"$f":"SUM(AM54:AM54)","v":1370.1161785643524},null,{"$f":"SUM(AO54:AO54)","v":314.51860129992616},{"$f":"SUM(AP54:AP54)","v":1535.5908181114039},null,{"$f":"SUM(AR54:AR54)","v":364.66436852473026},{"$f":"SUM(AS54:AS54)","v":1780.420152208977},null,{"$f":"SUM(AU54:AU54)","v":409.26861314706025},{"$f":"SUM(AV54:AV54)","v":1998.1938171297647},null,{"$f":"SUM(AX54:AX54)","v":448.77465697511394},{"$f":"SUM(AY54:AY54)","v":2191.0762664079089},null,{"$f":"SUM(BA54:BA54)","v":483.59035607243374},{"$f":"SUM(BB54:BB54)","v":2361.0587972948229}]
[]
[]
["Appendix 2-FC"]
["Calculation of Renewable Generation Connection Direct Benefits/Provincial Amount: Renewable Expansion Investments"]
["Net Fixed Assets",null,null,2015,2016,2017,2018,2019,2020,{"$f":"+I60+1","v":2021},{"$f":"+J60+1","v":2022},2023,2024,2025,{"$f":"+N60+1","v":2026},{"$f":"+O60+1","v":2027},{"$f":"+P60+1","v":2028},{"$f":"+Q60+1","v":2029},{"$f":"+R60+1","v":2030},{"$f":"+S60+1","v":2031}]
[null,"Enter applicable amortization in years:",null,40,40,40,40,40,40,40,40,40,40,45,45,45,45,45,45,45]
["Opening Gross Fixed Assets",null,null,null,{"$f":"D64","v":98000},168000,240000,314000,390000,390000,{"$f":"J64","v":390000},{"$f":"K64","v":390000},{"$f":"L64","v":390000},{"$f":"M64","v":390000},390000,{"$f":"O64","v":390000},{"$f":"P64","v":390000},{"$f":"Q64","v":390000},{"$f":"R64","v":390000},{"$f":"S64","v":390000}]
["Gross Capital Additions",null,null,{"$f":"'App.2-FA Proposed REG Invest.'!D85","v":98000},{"$f":"'App.2-FA Proposed REG Invest.'!E85","v":70000},{"$f":"'App.2-FA Proposed REG Invest.'!F85","v":72000},{"$f":"'App.2-FA Proposed REG Invest.'!G85","v":74000},{"$f":"'App.2-FA Proposed REG Invest.'!H85","v":76000},{"$f":"'App.2-FA Proposed REG Invest.'!I85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!J85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!K85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!L85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!M85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!N85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!O85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!P85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!Q85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!R85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!S85","v":0},{"$f":"'App.2-FA Proposed REG Invest.'!T85","v":0}]
["Closing Gross Fixed Assets",null,null,{"$f":"SUM(D62:D63)","v":98000},168000,240000,314000,390000,390000,{"$f":"SUM(J62:J63)","v":390000},390000,390000,390000,390000,{"$f":"SUM(O62:O63)","v":390000},390000,390000,390000,390000,390000]
[]
["Opening Accumulated Amortization",null,null,null,{"$f":"D69","v":1225},{"$f":"E69","v":4550},{"$f":"F69","v":9650},16575,25375,35125,{"$f":"J69","v":44875},{"$f":"K69","v":54625},{"$f":"L69","v":64375},{"$f":"M69","v":74125},{"$f":"N69","v":82791.666666666672},{"$f":"O69","v":91458.333333333343},{"$f":"P69","v":100125.00000000001},{"$f":"Q69","v":108791.66666666669},{"$f":"R69","v":117458.33333333336},{"$f":"S69","v":126125.00000000003}]
["Current Year Amortization (before additions)",null,null,null,{"$f":"E62/E61","v":2450},{"$f":"F62/F61","v":4200},{"$f":"G62/G61","v":6000},{"$f":"H62/H61","v":7850},{"$f":"I62/I61","v":9750},9750,9750,9750,9750,8666.6666666666661,8666.6666666666661,8666.6666666666661,8666.6666666666661,8666.6666666666661,8666.6666666666661,8666.6666666666661]
["Additions (half year)",null,null,{"$f":"D63/D61/2","v":1225},875,900,925,950,0,{"$f":"J63/J61/2","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"U63/$E$61","v":0}]
["Closing Accumulated Amortization",null,null,{"$f":"SUM(D66+D68)","v":1225},{"$f":"SUM(E66:E68)","v":4550},{"$f":"SUM(F66:F68)","v":9650},16575,25375,35125,44875,{"$f":"SUM(K66:K68)","v":54625},64375,74125,82791.666666666672,{"$f":"SUM(O66:O68)","v":91458.333333333343},100125.00000000001,108791.66666666669,117458.33333333336,126125.00000000003,134791.66666666669]
[]
["Opening Net Fixed Assets",null,null,{"$f":"D62-D66","v":0},{"$f":"D72","v":96775},163450,230350,297425,364625,354875,{"$f":"J72","v":345125},{"$f":"K72","v":335375},{"$f":"L72","v":325625},{"$f":"M72","v":315875},{"$f":"N72","v":307208.33333333331},{"$f":"O72","v":298541.66666666663},{"$f":"P72","v":289875},{"$f":"Q72","v":281208.33333333331},{"$f":"R72","v":272541.66666666663},{"$f":"S72","v":263875}]
["Closing Net Fixed Assets",null,null,{"$f":"D64-D69","v":96775},163450,230350,297425,364625,354875,{"$f":"J64-J69","v":345125},335375,325625,315875,307208.33333333331,{"$f":"O64-O69","v":298541.66666666663},{"$f":"P64-P69","v":289875},281208.33333333331,272541.66666666663,263875,255208.33333333331]
["Average Net Fixed Assets",null,null,{"$f":"SUM(D71:D72)/2","v":48387.5},130112.5,196900,263887.5,331025,359750,{"$f":"SUM(J71:J72)/2","v":350000},340250,330500,320750,311541.66666666663,{"$f":"SUM(O71:O72)/2","v":302875},294208.33333333331,285541.66666666663,276875,268208.33333333331,259541.66666666666]
[]
["UCC for PILs Calculation"]
[null,null,null,2015,2016,2017,2018,2019,2020,{"$f":"J60","v":2021},{"$f":"K60","v":2022},2023,2024,2025,{"$f":"O60","v":2026},2027,2028,2029,2030,2031]
[]
["Opening UCC",null,null,null,{"$f":"D86","v":94080},153753.60000000001,210573.31200000001,264767.44704000006,316546.05127680005,291222.36717465601,{"$f":"J86","v":267924.57780068356},{"$f":"K86","v":246490.61157662887},{"$f":"L86","v":226771.36265049857},{"$f":"M86","v":208629.65363845869},{"$f":"N86","v":191939.281347382},{"$f":"O86","v":176584.13883959144},{"$f":"P86","v":162457.40773242412},{"$f":"Q86","v":149460.81511383021},{"$f":"R86","v":137503.94990472379},{"$f":"S86","v":126503.63391234589}]
["Capital Additions (from Appendix 2-FA)",null,null,{"$f":"D63","v":98000},70000,72000,74000,76000,0,{"$f":"J63","v":0},0,0,0,0,{"$f":"O63","v":0},0,0,0,0,0]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D78:D79)","v":98000},164080,225753.60000000001,284573.31200000003,340767.44704000006,316546.05127680005,{"$f":"SUM(J78:J79)","v":291222.36717465601},267924.57780068356,246490.61157662887,226771.36265049857,208629.65363845869,{"$f":"SUM(O78:O79)","v":191939.281347382},176584.13883959144,162457.40773242412,149460.81511383021,137503.94990472379,126503.63391234589]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"D79/2","v":49000},35000,36000,37000,38000,0,{"$f":"J79/2","v":0},0,0,0,0,{"$f":"O79/2","v":0},0,0,0,0,0]
["Reduced UCC",null,null,{"$f":"D80-D81","v":49000},129080,189753.60000000001,247573.31200000003,302767.44704000006,316546.05127680005,{"$f":"J80-J81","v":291222.36717465601},267924.57780068356,246490.61157662887,226771.36265049857,208629.65363845869,{"$f":"O80-O81","v":191939.281347382},176584.13883959144,162457.40773242412,149460.81511383021,137503.94990472379,126503.63391234589]
["CCA Rate Class (to be entered)",null,47,{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"C83","v":47},{"$f":"D83","v":47},{"$f":"$C$83","v":47},{"$f":"$C$83","v":47},47,47,47,47,47,47,47,47,47]
["CCA Rate  (to be entered)",null,0.08,{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"C84","v":0.08},{"$f":"D84","v":0.08},{"$f":"$C$84","v":0.08},{"$f":"$C$84","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
["CCA",null,null,{"$f":"D82*D$84","v":3920},{"$f":"E82*E$84","v":10326.4},15180.288,19805.864960000003,24221.395763200006,{"$f":"I82*I$84","v":25323.684102144005},23297.789373972482,{"$f":"K82*K$84","v":21433.966224054686},19719.248926130309,18141.709012039886,16690.372291076696,{"$f":"O82*O$84","v":15355.142507790561},14126.731107167316,12996.59261859393,11956.865209106416,11000.315992377904,10120.290712987671]
["Closing UCC",null,null,{"$f":"D80-D85","v":94080},153753.60000000001,210573.31200000001,264767.44704000006,316546.05127680005,291222.36717465601,{"$f":"J80-J85","v":267924.57780068356},246490.61157662887,226771.36265049857,208629.65363845869,191939.281347382,{"$f":"O80-O85","v":176584.13883959144},162457.40773242412,149460.81511383021,137503.94990472379,126503.63391234589,116383.34319935822]

{"sheet":"Trueup Calculation 2015-2026","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["Year","Approved RGCRP , refer to EB-2025-0055, Alectra_APPL_Attach 22_RGCRP BRZ_20250814","BRZ RGCRP Workform","True-Up"]
[2015,25591.367010899387,{"$f":"'App.2-FB Calc of REG Improvemnt'!$F$39","v":25655.170593792329},{"$f":"C3-B3","v":63.803582892942359}]
[2016,60541.572939883357,{"$f":"'App.2-FB Calc of REG Improvemnt'!$I$39","v":60710.615227489776},169.04228760641854]
[2017,89490.850560433522,{"$f":"'App.2-FB Calc of REG Improvemnt'!$L$39","v":89741.108872788915},250.25831235539226]
[2018,117963.05772568559,{"$f":"'App.2-FB Calc of REG Improvemnt'!$O$39","v":118291.13915835354},328.08143266795378]
[2019,145921.76402408161,{"$f":"'App.2-FB Calc of REG Improvemnt'!$R$39","v":146324.10673932123},{"$f":"C7-B7","v":402.34271523961797}]
[2020,143159.89708025384,{"$f":"'App.2-FB Calc of REG Improvemnt'!$U$39","v":143581.98786349266},{"$f":"C8-B8","v":422.0907832388184}]
[2021,139883.23557965836,{"$f":"'App.2-FB Calc of REG Improvemnt'!$X$39","v":140272.38436852055},389.1487888621923]
[2022,136430.29454382902,{"$f":"'App.2-FB Calc of REG Improvemnt'!$AA$39","v":136786.50133831453},356.206794485508]
[2023,132815.17633558449,{"$f":"'App.2-FB Calc of REG Improvemnt'!$AD$39","v":133138.44113569337},323.2648001088819]
[2024,129050.85512871803,{"$f":"'App.2-FB Calc of REG Improvemnt'!$AG$39","v":129341.17793445024},290.32280573221215]
[2025,125149.26716311938,{"$f":"'App.2-FB Calc of REG Improvemnt'!$AJ$39","v":124221.7242921774},-927.54287094197934]
[2026,121121.39377948712,{"$f":"'App.2-FB Calc of REG Improvemnt'!$AM$39","v":120237.77356771402},-883.62021177310089]
["Total",{"$f":"SUM(B3:B14)","v":1367118.7318716336},{"$f":"SUM(C3:C14)","v":1368302.1310921088},1183.3992204748574]