{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["1. Information Sheet","3. Rate Class Selection","4. Growth Factor - NUM_CALC1","5. Growth Factor - NUM_CALC2","6. Rev_Requ_Check","7. Growth Factor - DEN_CALC1","8. Revenue Proportions","9. Threshold Test","10b. Proposed ACM ICM Projects","11. Incremental Capital Adj.","12. Opt 1-Rate Rider Calc F & V"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":6,"defined_names":11,"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":"1. Information Sheet","index":0,"n_rows":115,"n_cols":27,"rows_kept":115,"cut":false,"hidden":false,"merged":[[23,5,23,9],[13,5,13,11],[15,5,15,9],[17,5,17,9],[19,5,19,9],[21,5,21,9],[35,0,35,4],[35,5,35,7],[25,0,25,4],[25,5,25,7],[27,0,27,4],[27,5,27,7],[29,5,29,7],[31,0,31,4],[31,5,31,7],[33,0,33,4],[33,5,33,7],[90,3,90,6],[90,7,90,11],[63,0,63,12],[37,5,37,7],[39,5,39,7],[41,5,41,7],[43,5,43,7],[45,0,46,4],[45,5,45,7],[45,9,49,12],[46,5,46,7],[50,2,50,11],[52,2,52,13],[54,2,54,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",null,null,null,null,null,{"$f":"IF(OR(F16=\"\", F16=\"(if applicable)\"), F14, F14 & \" - \" & F16)","v":"Burlington Hydro Inc"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Note:  Depending on the selections made below, certain worksheets in this workbook will be hidden.",null,null,null,null,null,null,null,null,null,null,null,"Version",4]
[]
[null,null,null,null,"Utility Name   ","Burlington Hydro Inc"]
[]
[null,null,null,null,"Service Territory (if filing more than one model)"]
[]
[null,null,null,null,"Assigned EB Number","EB-2018-0021"]
[]
[null,null,null,null,"Name of Contact and Title","Sally Blackwell, Director Regulator Affairs"]
[]
[null,null,null,null,"Phone Number   ","905-336-4373"]
[]
[null,null,null,null,"Email Address   ","sblackwell@burlingtonhydro.com"]
[]
["Is this Capital Module being filed in a CoS or \nPrice-Cap IR Application?",null,null,null,null,"Price-Cap IR",null,null,null,"Rate Year",2019]
[]
[{"$f":"\"Indicate the Price-Cap IR Year (1, 2, 3, 4, etc) in which \" &F14 & \" is applying:\"","v":"Indicate the Price-Cap IR Year (1, 2, 3, 4, etc) in which Burlington Hydro Inc is applying:"},null,null,null,null,5]
[]
[null,null,null,null,{"$f":"F14 & \" is applying for:\"","v":"Burlington Hydro Inc is applying for:"},"ICM Approval"]
[]
["Last Rebasing Year:",null,null,null,null,{"$f":"IF(F26=\"COS\", K26-F28, VLOOKUP(F28, D107:E115,2,FALSE))","v":2014}]
[]
["Last COS OEB Application Number",null,null,null,null,"EB-2013-0115"]
[]
["The most recent complete year for which actual billing and load data exists",null,null,null,null,{"$f":"K26-2","v":2017}]
[]
[null,null,null,null,"Current IPI",1.2E-2]
[]
[null,null,null,null,"Strech Factor Assigned to Middle Cohort","II"]
[]
[null,null,null,null,"Stretch Factor Value",1.5E-3]
[]
[null,null,null,null,"Price Cap Index",{"$f":"F38-F42","v":1.0500000000000001E-2}]
[]
["Based on the inputs above, the growth factor utilized in the Materiality Threshold Calculation will be determined by:",null,null,null,null,{"$f":"IF($F$26=\"COS\", $K$26 & \" Test Year Distribution Revenues\", VLOOKUP($F$28, $D$107:$M$115, 3,FALSE))","v":"2017 Actual Distribution Revenues"},null,null,{"$f":"LEFT(F46,4)","v":"2017"},"These will be hidden later. For year three price cap IR, it should be most recent actuals for 2014 divided by 2013 CoS Board-approved. For year 4 price cap IR, should be 2014 actuals divided by 2012 CoS Board-approved."]
[null,null,null,null,null,{"$f":"IF(F26=\"COS\",F36&\" Actual Distribution Revenues\",VLOOKUP($F$28, $D$107:$M$115, 7,FALSE))","v":"2014 Board-Approved Distribution Revenues"},null,null,{"$f":"LEFT(F47,4)","v":"2014"}]
[]
[null,"Notes"]
[]
[null,null,"Pale green cells represent input cells."]
[]
[null,null,"Pale blue cells represent drop-down lists.  The applicant should select the appropriate item from the drop-down list."]
[]
[null,null,"White cells contain fixed values, automatically generated values or formulae. "]
[]
[]
[]
[]
[]
[]
[]
[]
["OEB policies regarding rate-setting and rebasing following distributor consolidations could allow a distributor to not rebase rates for up to ten years. A distributor could also apply for and receive OEB approval to defer rebasing. If a distributor is under Price Cap IR for more than four years after rebasing and applies for an ICM, this spreadsheet will need to be adapted to accommodate those circumstances. The distributor should contact OEB staff to discuss the circumstances so that a customized model can be provided."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CoS",null,"Price Cap IR",null,null,null,"Deferred Rebasing"]
[null,null,"Year",1,2,3,4,5,6,7,8,9]
["RY",{"$f":"K26","v":2019},"t",{"$f":"K26","v":2019},{"$f":"D93","v":2019},{"$f":"E93","v":2019},2019,2019,2020,2021,2022,2023]
["LY ACTUALS",{"$f":"B93-2","v":2017},"t-2",{"$f":"D93-2","v":2017},{"$f":"E93-2","v":2017},2017,2017,{"$f":"H93-2","v":2017},{"$f":"I93-2","v":2018},{"$f":"J93-2","v":2019},{"$f":"K93-2","v":2020},{"$f":"L93-2","v":2021}]
["LAST COS",null,null,{"$f":"D93-D92","v":2018},{"$f":"E93-E92","v":2017},2016,2015,2014,{"$f":"I93-I92","v":2014},{"$f":"J93-J92","v":2014},2014,2014]
[]
["Growth"]
["Numerator",{"$f":"B93&\" Test Year Distribution Revenues\"","v":"2019 Test Year Distribution Revenues"}," ",{"$f":"D95&\" Board-Approved Distribution Revenues\"","v":"2018 Board-Approved Distribution Revenues"},{"$f":"E95&\" Board-Approved Distribution Revenues\"","v":"2017 Board-Approved Distribution Revenues"},{"$f":"F95+1&\" Actual Distribution Revenues\"","v":"2017 Actual Distribution Revenues"},{"$f":"G95+2&\" Actual Distribution Revenues\"","v":"2017 Actual Distribution Revenues"},{"$f":"H95+3&\" Actual Distribution Revenues\"","v":"2017 Actual Distribution Revenues"},{"$f":"I95+3&\" Actual Distribution Revenues\"","v":"2017 Actual Distribution Revenues"},{"$f":"J95+4&\" Actual Distribution Revenues\"","v":"2018 Actual Distribution Revenues"},{"$f":"K95+5&\" Actual Distribution Revenues\"","v":"2019 Actual Distribution Revenues"},{"$f":"L95+6&\" Actual Distribution Revenues\"","v":"2020 Actual Distribution Revenues"}]
["Denominator",{"$f":"B94&\" Actual Distribution Revenues\"","v":"2017 Actual Distribution Revenues"}," ",{"$f":"D94&\" Actual Distribution Revenues\"","v":"2017 Actual Distribution Revenues"},{"$f":"E94-1&\" Actual Distribution Revenues\"","v":"2016 Actual Distribution Revenues"},{"$f":"F95&\" Board-Approved Distribution Revenues\"","v":"2016 Board-Approved Distribution Revenues"},"2015 Board-Approved Distribution Revenues",{"$f":"H95&\" Board-Approved Distribution Revenues\"","v":"2014 Board-Approved Distribution Revenues"},{"$f":"I95&\" Board-Approved Distribution Revenues\"","v":"2014 Board-Approved Distribution Revenues"},{"$f":"J95&\" Board-Approved Distribution Revenues\"","v":"2014 Board-Approved Distribution Revenues"},{"$f":"K95&\" Board-Approved Distribution Revenues\"","v":"2014 Board-Approved Distribution Revenues"},{"$f":"L95&\" Board-Approved Distribution Revenues\"","v":"2014 Board-Approved Distribution Revenues"}]
["Annualized?","Yes",null,"No","No","No","Yes","Yes","Yes","Yes","Yes","Yes"]
["Divisor to Annuqlized",{"$f":"B104","v":2},null,1,1,1,2,3,3,4,5,6]
[null,{"$f":"LEFT(B98,4)","v":"2019"},null,{"$f":"LEFT(D98,4)","v":"2018"},"2017","2017","2017",{"$f":"LEFT(H98,4)","v":"2017"},{"$f":"LEFT(I98,4)","v":"2017"},"2018","2019","2020"]
[null,{"$f":"LEFT(B99,4)","v":"2017"},null,"2017","2016","2016","2015",{"$f":"LEFT(H99,4)","v":"2014"},"2014","2014","2014","2014"]
[null,{"$f":"B102-B103","v":2},null,{"$f":"D102-D103","v":1},1,1,2,{"$f":"H102-H103","v":3},{"$f":"I102-I103","v":3},{"$f":"J102-J103","v":4},{"$f":"K102-K103","v":5},{"$f":"L102-L103","v":6}]
[]
[]
[null,null,null,"Price Cap IR","Last CoS","Numerator",null,null,null,"Denominator"]
[null,null,null,1,{"$f":"D95","v":2018},{"$f":"D98","v":"2018 Board-Approved Distribution Revenues"},null,null,null,{"$f":"D99","v":"2017 Actual Distribution Revenues"}]
[null,null,null,2,{"$f":"E95","v":2017},{"$f":"E98","v":"2017 Board-Approved Distribution Revenues"},null,null,null,{"$f":"E99","v":"2016 Actual Distribution Revenues"}]
[null,null,null,3,{"$f":"F95","v":2016},{"$f":"F98","v":"2017 Actual Distribution Revenues"},null,null,null,{"$f":"F99","v":"2016 Board-Approved Distribution Revenues"}]
[null,null,null,4,{"$f":"G95","v":2015},{"$f":"G98","v":"2017 Actual Distribution Revenues"},null,null,null,{"$f":"G99","v":"2015 Board-Approved Distribution Revenues"}]
[null,null,null,5,{"$f":"+H95","v":2014},{"$f":"I98","v":"2017 Actual Distribution Revenues"},null,null,null,{"$f":"I99","v":"2014 Board-Approved Distribution Revenues"}]
[null,null,null,6,{"$f":"J95","v":2014},{"$f":"J98","v":"2018 Actual Distribution Revenues"},null,null,null,{"$f":"J99","v":"2014 Board-Approved Distribution Revenues"}]
[null,null,null,7,{"$f":"K95","v":2014},{"$f":"K98","v":"2019 Actual Distribution Revenues"},null,null,null,{"$f":"K99","v":"2014 Board-Approved Distribution Revenues"}]
[null,null,null,8,{"$f":"L95","v":2014},{"$f":"L98","v":"2020 Actual Distribution Revenues"},null,null,null,{"$f":"L99","v":"2014 Board-Approved Distribution Revenues"}]

{"sheet":"3. Rate Class Selection","index":1,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[22,1,22,9],[23,1,23,9],[24,1,24,9],[11,0,11,13],[17,1,17,9],[18,1,18,9],[19,1,19,9],[20,1,20,9],[21,1,21,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select the appropriate rate classes as they appear on your most recent Board-Approved Tariff of Rates and Charges, excluding the MicroFit Class."]
[]
["How many classes are on your most recent Board-Approved Tariff of Rates and Charges?",null,null,null,null,null,null,null,null,5]
[]
["Select Your Rate Classes from the Blue Cells below.  Please ensure that a rate class is assigned to each shaded cell."]
[]
[null,"Rate Class Classification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of duplicates"]
[1,"RESIDENTIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($B$19:$J$40, B19)","v":1},{"$f":"COUNTIF(P19:P40, 2)/2","v":0}]
[2,"GENERAL SERVICE LESS THAN 50 KW",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($B$19:$J$40, B20)","v":1}]
[3,"GENERAL SERVICE GREATER THAN 50 KW",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[4,"UNMETERED SCATTERED LOAD",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[5,"STREET LIGHTING",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"4. Growth Factor - NUM_CALC1","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,0,13,4],[14,2,14,4],[14,6,14,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Input the billing determinants and base distribution rates associated with \" & '1. Information Sheet'!F14 & \"'s \" & '1. Information Sheet'!F46 & \".  Sheets 4 & 5 calculate the NUMERATOR portion of the growth factor calculation.\"","v":"Input the billing determinants and base distribution rates associated with Burlington Hydro Inc's 2017 Actual Distribution Revenues.  Sheets 4 & 5 calculate the NUMERATOR portion of the growth factor calculation."}]
[]
[null,null,"2017 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class","Units","Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW"]
["RESIDENTIAL","$/kWh",60593,499660804,0,null,22.44,4.1999999999999997E-3,0]
["GENERAL SERVICE LESS THAN 50 KW","$/kWh",5523,165968773,0,null,26.22,1.4E-2,0]
["GENERAL SERVICE GREATER THAN 50 KW","$/kW",1006,null,2376074,null,61.46,0,3.0255999999999998]
["UNMETERED SCATTERED LOAD","$/kWh",582,3130312,0,null,9.42,1.6400000000000001E-2,0]
["STREET LIGHTING","$/kW",15386,null,26971,null,0.63,0,4.5568]

{"sheet":"5. Growth Factor - NUM_CALC2","index":3,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,2,13,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF('1. Information Sheet'!F26=\"COS\", \"Calculation of \" & '1. Information Sheet'!K26 & \" Revenue Requirement.  No input required.\", \"Calculation of \" & '1. Information Sheet'!F36 & \" Revenue Requirement.  No input required.\")","v":"Calculation of 2017 Revenue Requirement.  No input required."}]
[]
[null,null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C15:E15","v":"2017 Actual Distribution Demand"}]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenue Requirement from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"K = G / J","L = H / J","M = I / J","N = J / R"]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A17","v":"RESIDENTIAL"},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C17","v":60593},{"$f":"+'4. Growth Factor - NUM_CALC1'!D17","v":499660804},{"$f":"+'4. Growth Factor - NUM_CALC1'!E17","v":0},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G17","v":22.44},{"$f":"+'4. Growth Factor - NUM_CALC1'!H17","v":4.1999999999999997E-3},{"$f":"+'4. Growth Factor - NUM_CALC1'!I17","v":0},null,{"$f":"G17*C17*12","v":16316483.040000003},{"$f":"H17*D17","v":2098575.3767999997},{"$f":"I17*E17","v":0},{"$f":"SUM(K17,L17,M17)","v":18415058.416800003},null,{"$f":"IF(ISERROR(K17/N17),0,ROUND(K17/N17,3))","v":0.88600000000000001},{"$f":"IF(ISERROR(L17/N17),0,ROUND(L17/N17,3))","v":0.114},{"$f":"IF(ISERROR(M17/N17),0,ROUND(M17/N17,3))","v":0},{"$f":"N17/N24","v":0.59859663477405056}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A18","v":"GENERAL SERVICE LESS THAN 50 KW"},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C18","v":5523},{"$f":"+'4. Growth Factor - NUM_CALC1'!D18","v":165968773},{"$f":"+'4. Growth Factor - NUM_CALC1'!E18","v":0},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G18","v":26.22},{"$f":"+'4. Growth Factor - NUM_CALC1'!H18","v":1.4E-2},{"$f":"+'4. Growth Factor - NUM_CALC1'!I18","v":0},null,1737756.72,{"$f":"H18*D18","v":2323562.8220000002},0,4061319.5420000004,null,0.42799999999999999,0.57199999999999995,0,{"$f":"N18/N24","v":0.13201653535703206}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A19","v":"GENERAL SERVICE GREATER THAN 50 KW"},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C19","v":1006},{"$f":"+'4. Growth Factor - NUM_CALC1'!D19","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!E19","v":2376074},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G19","v":61.46},{"$f":"+'4. Growth Factor - NUM_CALC1'!H19","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!I19","v":3.0255999999999998},null,741945.12,0,{"$f":"I19*E19","v":7189049.4943999993},7930994.6143999994,null,9.4E-2,0,0.90600000000000003,{"$f":"N19/N24","v":0.25780350945071445}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A20","v":"UNMETERED SCATTERED LOAD"},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C20","v":582},{"$f":"+'4. Growth Factor - NUM_CALC1'!D20","v":3130312},{"$f":"+'4. Growth Factor - NUM_CALC1'!E20","v":0},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G20","v":9.42},{"$f":"+'4. Growth Factor - NUM_CALC1'!H20","v":1.6400000000000001E-2},{"$f":"+'4. Growth Factor - NUM_CALC1'!I20","v":0},null,65789.279999999999,51337.116800000003,{"$f":"I20*E20","v":0},117126.3968,null,0.56200000000000006,0.438,0,{"$f":"N20/N24","v":3.807289956991265E-3}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A21","v":"STREET LIGHTING"},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C21","v":15386},{"$f":"+'4. Growth Factor - NUM_CALC1'!D21","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!E21","v":26971},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G21","v":0.63},{"$f":"+'4. Growth Factor - NUM_CALC1'!H21","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!I21","v":4.5568},null,116318.16,0,122901.4528,239219.6128,null,0.48599999999999999,0,0.51400000000000001,{"$f":"N21/N24","v":7.7760304612117899E-3}]
[null,null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C22","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!D22","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!E22","v":0},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G22","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!H22","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!I22","v":0},null,0,0,0,0,null,0,0,0,{"$f":"N22/N24","v":0}]
[null,null,{"$f":"+'4. Growth Factor - NUM_CALC1'!C23","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!D23","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!E23","v":0},null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G23","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!H23","v":0},{"$f":"+'4. Growth Factor - NUM_CALC1'!I23","v":0},null,0,0,0,0,null,0,0,0,{"$f":"N23/N24","v":0}]
["Total",null,{"$f":"SUM(C17:C23)","v":83090},{"$f":"SUM(D17:D23)","v":668759889},{"$f":"SUM(E17:E23)","v":2403045},null,null,null,null,null,{"$f":"SUM(K17:K23)","v":18978292.320000004},{"$f":"SUM(L17:L23)","v":4473475.3155999994},{"$f":"SUM(M17:M23)","v":7311950.9471999994},{"$f":"SUM(N17:N23)","v":30763718.582800001},null,null,null,null,{"$f":"SUM(S17:S23)","v":1.0000000000000002}]

{"sheet":"6. Rev_Requ_Check","index":4,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[7,2,7,5]]}
[]
[]
[]
[]
[]
[]
[]
["Applicants Rate Base",null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G15","v":"Current Approved Distribution Rates"}]
["Average Net Fixed Assets"]
["Gross Fixed Assets - Re-based Opening",null,{"$f":"+'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$D$59","v":242255337},"A"]
["Add: CWIP Re-based Opening",null,null,"B"]
["Re-based Capital Additions",null,{"$f":"+'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$E$59","v":7730045},"C"]
["Re-based Capital Disposals",null,{"$f":"+'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$F$59","v":0},"D"]
["Re-based Capital Retirements",null,null,"E"]
["Deduct: CWIP Re-based Closing",null,null,"F"]
["Gross Fixed Assets - Re-based Closing",null,{"$f":"SUM(C10:C15)","v":249985382},"G"]
["Average Gross Fixed Assets",null,null,null,{"$f":"(C10+C16)/2","v":246120359.5},"H = ( A + G ) / 2"]
[]
["Accumulated Depreciation - Re-based Opening",null,{"$f":"-'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$I$59","v":139112890},"I"]
["Re-based Depreciation Expense",null,{"$f":"-'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$J$59","v":4510060},"J"]
["Re-based Disposals",null,null,"K"]
["Re-based Retirements",null,null,"L"]
["Accumulated Depreciation - Re-based Closing",null,{"$f":"SUM(C19:C22)","v":143622950},"M"]
["Average Accumulated Depreciation",null,null,null,{"$f":"SUM(C19,C23)/2","v":141367920},"N =  ( I + M ) / 2"]
[]
["Average Net Fixed Assets ",null,null,null,{"$f":"E17-E24","v":104752439.5},"O = H - N"]
[]
["Working Capital Allowance"]
["Working Capital Allowance Base",null,{"$f":"+'[3]4. Rate_Base'!$W$26","v":208278793},"P"]
["Working Capital Allowance Rate",null,0.13,"Q"]
["Working Capital Allowance",null,null,null,{"$f":"C29*C30","v":27076243.09},"R = P * Q"]
[]
["Rate Base",null,null,null,{"$f":"SUM(E26,E31)","v":131828682.59},"S =  O + R"]
[]
["Return on Rate Base"]
["Deemed ShortTerm Debt %",null,0.04,"T",{"$f":"E33*C36","v":5273147.3036000002},"W = S * T"]
["Deemed Long Term Debt %",null,0.56000000000000005,"U",{"$f":"E33*C37","v":73824062.250400007},"X = S * U"]
["Deemed Equity %",null,{"$f":"1-C36-C37","v":0.39999999999999991},"V",{"$f":"E33*C38","v":52731473.035999991},"Y = S * V"]
[]
["Short Term Interest",null,{"$f":"+'[3]7. Cost_of_Capital'!$L$50","v":2.1100000000000001E-2},"Z",{"$f":"E36*C40","v":111263.40810596001},"AC = W * Z"]
["Long Term Interest",null,{"$f":"+'[3]7. Cost_of_Capital'!$L$49","v":4.7300000000000002E-2},"AA",{"$f":"E37*C41","v":3491878.1444439203},"AD = X * AA"]
["Return on Equity",null,{"$f":"+'[3]7. Cost_of_Capital'!$L$54","v":9.3600000000000003E-2},"AB",{"$f":"E38*C42","v":4935665.8761695996},"AE = Y * AB"]
["Return on Rate Base",null,null,null,{"$f":"SUM(E40:E42)","v":8538807.4287194796},"AF = AC + AD + AE"]
[]
["Distribution Expenses"]
["OM&A Expenses",null,{"$f":"+'[3]5. Utility Income'!$V$22+'[3]5. Utility Income'!$V$24-'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$J$60","v":17576532.629999999},"AG"]
["Amortization",null,{"$f":"+'[3]5. Utility Income'!$V$23+'[2]App.2-BA1_Fix Asset Cont.CGAAP'!$J$60","v":4510060.28},"AH"]
["Ontario Capital Tax",null,0,"AI"]
["Grossed Up PILs",null,{"$f":"+'[3]5. Utility Income'!$V$35:$V$35","v":211145.67786013972},"AJ"]
["Low Voltage",null,0,"AK"]
["Transformer Allowance",null,{"$f":"+'[4]I6.1 Revenue'!$C$40","v":571049.13600000006},"AL"]
[null,null,null,"AM"]
[null,null,null,"AN"]
[null,null,null,"AO"]
[null,null,null,null,{"$f":"SUM(C46:C54)","v":22868787.723860141},"AP = SUM ( AG : AO )"]
["Revenue Offsets"]
["Specific Service Charges",null,{"$f":"-'[3]3. Data_Input_Sheet'!U28","v":-817981},"AQ"]
["Late Payment Charges",null,{"$f":"-'[3]3. Data_Input_Sheet'!U29","v":-241000},"AR"]
["Other Distribution Income",null,{"$f":"-'[3]3. Data_Input_Sheet'!U30","v":-625033},"AS"]
["Other Income and Deductions",null,{"$f":"-'[3]3. Data_Input_Sheet'!U31","v":-317000},"AT",{"$f":"SUM(C57:C60)","v":-2001014},"AU = SUM ( AQ : AT )"]
[]
["Revenue Requirement from Distribution Rates",null,null,null,{"$f":"SUM(E60,E55,E43)","v":29406581.15257962},"AV = AF + AP + AU",{"$f":"E62-C51","v":28835532.016579621},"after Tx allowance"]
[]
["Rate Classes Revenue"]
["Rate Classes Revenue - Total  (Sheet 5)",null,null,null,{"$f":"+'5. Growth Factor - NUM_CALC2'!N24","v":30763718.582800001},"AW"]
[]
["Difference",null,null,null,{"$f":"E62-E65","v":-1357137.4302203804},"AZ = AV - AW"]
[]
["Difference (Percentage - should be less than 1%)",null,null,null,{"$f":"IF(ISERROR(E67/E65),0,E67/E65)","v":-4.4114869487174288E-2},"BA = AZ / AW"]

{"sheet":"7. Growth Factor - DEN_CALC1","index":5,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,2,13,4],[13,6,13,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Input the billing determinants associated with Burlington Hydro Inc. 2014 Board-Approved Distribution Revenues.  This sheet calculates the DENOMINATOR portion of the growth factor calculation."]
["Pseudo Revenue Requirement Calculation."]
[null,null,{"$f":"+'1. Information Sheet'!F47","v":"2014 Board-Approved Distribution Revenues"},null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue By Rate Class",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"K = G / Jtotal","L = H / Jtotal","M = I / Jtotal","N = J / Jtotal"]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A17","v":"RESIDENTIAL"},null,59869,{"$f":"+'[5]I6.1 Revenue'!$D$25","v":553858289},0,null,{"$f":"'5. Growth Factor - NUM_CALC2'!G17","v":22.44},{"$f":"'5. Growth Factor - NUM_CALC2'!H17","v":4.1999999999999997E-3},{"$f":"'5. Growth Factor - NUM_CALC2'!I17","v":0},null,{"$f":"G17*C17*12","v":16121524.32},{"$f":"H17*D17","v":2326204.8137999997},0,{"$f":"SUM(K17,L17,M17)","v":18447729.1338},null,{"$f":"IF(ISERROR(K17/N24),0,ROUND(K17/N24,3))","v":0.51900000000000002},{"$f":"IF(ISERROR(L17/N24),0,ROUND(L17/N24,3))","v":7.4999999999999997E-2},{"$f":"IF(ISERROR(M17/N24),0,ROUND(M17/N24,3))","v":0},{"$f":"N17/N24","v":0.59389104057241549}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A18","v":"GENERAL SERVICE LESS THAN 50 KW"},null,5224,{"$f":"+'[5]I6.1 Revenue'!$E$25","v":173842956},0,null,{"$f":"'5. Growth Factor - NUM_CALC2'!G18","v":26.22},{"$f":"'5. Growth Factor - NUM_CALC2'!H18","v":1.4E-2},{"$f":"'5. Growth Factor - NUM_CALC2'!I18","v":0},null,1643679.3599999999,2433801.3840000001,0,4077480.7439999999,null,{"$f":"IF(ISERROR(K18/N24),0,ROUND(K18/N24,3))","v":5.2999999999999999E-2},{"$f":"IF(ISERROR(L18/N24),0,ROUND(L18/N24,3))","v":7.8E-2},{"$f":"IF(ISERROR(M18/N24),0,ROUND(M18/N24,3))","v":0},{"$f":"N18/N24","v":0.13126706622829365}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A19","v":"GENERAL SERVICE GREATER THAN 50 KW"},null,1012,0,{"$f":"+'[5]I6.1 Revenue'!$F$26","v":2451173},null,{"$f":"'5. Growth Factor - NUM_CALC2'!G19","v":61.46},{"$f":"'5. Growth Factor - NUM_CALC2'!H19","v":0},{"$f":"'5. Growth Factor - NUM_CALC2'!I19","v":3.0255999999999998},null,746370.24,0,7416269.0287999995,8162639.2687999997,null,{"$f":"IF(ISERROR(K19/N24),0,ROUND(K19/N24,3))","v":2.4E-2},{"$f":"IF(ISERROR(L19/N24),0,ROUND(L19/N24,3))","v":0},{"$f":"IF(ISERROR(M19/N24),0,ROUND(M19/N24,3))","v":0.23899999999999999},{"$f":"N19/N24","v":0.262781304625884}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A20","v":"UNMETERED SCATTERED LOAD"},null,605,{"$f":"+'[5]I6.1 Revenue'!$L$25","v":3151827},null,null,{"$f":"'5. Growth Factor - NUM_CALC2'!G20","v":9.42},{"$f":"'5. Growth Factor - NUM_CALC2'!H20","v":1.6400000000000001E-2},{"$f":"'5. Growth Factor - NUM_CALC2'!I20","v":0},null,68389.200000000012,51689.962800000001,0,120079.16280000002,null,{"$f":"IF(ISERROR(K20/N24),0,ROUND(K20/N24,3))","v":2E-3},{"$f":"IF(ISERROR(L20/N24),0,ROUND(L20/N24,3))","v":2E-3},{"$f":"IF(ISERROR(M20/N24),0,ROUND(M20/N24,3))","v":0},{"$f":"N20/N24","v":3.8657299458985891E-3}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A21","v":"STREET LIGHTING"},null,15272,0,{"$f":"+'[5]I6.1 Revenue'!$J$26","v":30525},null,{"$f":"'5. Growth Factor - NUM_CALC2'!G21","v":0.63},{"$f":"'5. Growth Factor - NUM_CALC2'!H21","v":0},{"$f":"'5. Growth Factor - NUM_CALC2'!I21","v":4.5568},null,115456.32000000001,0,139096.32000000001,254552.64,null,{"$f":"IF(ISERROR(K21/N24),0,ROUND(K21/N24,3))","v":4.0000000000000001E-3},{"$f":"IF(ISERROR(L21/N24),0,ROUND(L21/N24,3))","v":0},{"$f":"IF(ISERROR(M21/N24),0,ROUND(M21/N24,3))","v":4.0000000000000001E-3},{"$f":"N21/N24","v":8.1948586275082096E-3}]
[null,null,null,null,0,null,{"$f":"'5. Growth Factor - NUM_CALC2'!G22","v":0},{"$f":"'5. Growth Factor - NUM_CALC2'!H22","v":0},{"$f":"'5. Growth Factor - NUM_CALC2'!I22","v":0},null,0,0,0,0,null,{"$f":"IF(ISERROR(K22/N24),0,ROUND(K22/N24,3))","v":0},{"$f":"IF(ISERROR(L22/N24),0,ROUND(L22/N24,3))","v":0},{"$f":"IF(ISERROR(M22/N24),0,ROUND(M22/N24,3))","v":0},{"$f":"N22/N24","v":0}]
[null,null,null,0,null,null,{"$f":"'5. Growth Factor - NUM_CALC2'!G23","v":0},{"$f":"'5. Growth Factor - NUM_CALC2'!H23","v":0},{"$f":"'5. Growth Factor - NUM_CALC2'!I23","v":0},null,0,0,0,0,null,{"$f":"IF(ISERROR(K23/N24),0,ROUND(K23/N24,3))","v":0},{"$f":"IF(ISERROR(L23/N24),0,ROUND(L23/N24,3))","v":0},{"$f":"IF(ISERROR(M23/N24),0,ROUND(M23/N24,3))","v":0},{"$f":"N23/N24","v":0}]
["Total",null,{"$f":"SUM(C17:C23)","v":81982},{"$f":"SUM(D17:D23)","v":730853072},{"$f":"SUM(E17:E23)","v":2481698},null,null,null,null,null,{"$f":"SUM(K17:K23)","v":18695419.439999998},{"$f":"SUM(L17:L23)","v":4811696.1605999991},{"$f":"SUM(M17:M23)","v":7555365.3487999998},{"$f":"SUM(N17:N23)","v":31062480.9494},null,null,null,null,{"$f":"SUM(S17:S23)","v":1}]

{"sheet":"8. Revenue Proportions","index":6,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,0,12,6],[13,2,13,4],[13,6,13,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Current Revenue from Rates"]
["This sheet is used to determine the applicant's most current allocation of revenues (after the most recent revenue to cost ratio adjustment, if applicable)  to appropriately allocate the incremental revenue requirement to the classes.\n"]
[null,null,"Most Recent Board-Approved Base Rates",null,null,null,{"$f":"+'4. Growth Factor - NUM_CALC1'!G15:I15","v":"Current Approved Distribution Rates"}]
["Rate Class",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Re-based Billed Customers or Connections","Re-based Billed kWh","Re-based Billed kW",null,"Current Base Service Charge Revenue","Current Base Distribution Volumetric Rate kWh Revenue","Current Base Distribution Volumetric Rate kW Revenue","Total Current Base Revenue",null,"Service Charge % Total Revenue","Distribution Volumetric Rate % Total Revenue ","Distribution Volumetric Rate % Total Revenue ","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G = A * D *12","H = B * E","I = C * F","J = G + H + I",null,"L = G / Jtotal","M = H / Jtotal","N = I / Jtotal","O = J / Jtotal"]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A17","v":"RESIDENTIAL"},null,22.44,4.1999999999999997E-3,0,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C17","v":60593},{"$f":"'4. Growth Factor - NUM_CALC1'!D17","v":499660804},{"$f":"'4. Growth Factor - NUM_CALC1'!E17","v":0},null,{"$f":"G17*C17*12","v":16316483.040000003},{"$f":"H17*D17","v":2098575.3767999997},0,{"$f":"SUM(K17,L17,M17)","v":18415058.416800003},null,{"$f":"IF(ISERROR(K17/N24),0,K17/N24)","v":0.53038071441475709},{"$f":"IF(ISERROR(L17/N24),0,L17/N24)","v":6.8215920359293414E-2},{"$f":"IF(ISERROR(M17/N24),0,M17/N24)","v":0},{"$f":"N17/N24","v":0.59859663477405056}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A18","v":"GENERAL SERVICE LESS THAN 50 KW"},null,26.22,1.4E-2,0,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C18","v":5523},{"$f":"'4. Growth Factor - NUM_CALC1'!D18","v":165968773},{"$f":"'4. Growth Factor - NUM_CALC1'!E18","v":0},null,1737756.72,2323562.8220000002,0,4061319.5420000004,null,{"$f":"IF(ISERROR(K18/N24),0,K18/N24)","v":5.6487212861568041E-2},{"$f":"IF(ISERROR(L18/N24),0,L18/N24)","v":7.5529322495463999E-2},{"$f":"IF(ISERROR(M18/N24),0,M18/N24)","v":0},{"$f":"N18/N24","v":0.13201653535703206}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A19","v":"GENERAL SERVICE GREATER THAN 50 KW"},null,61.46,0,3.0255999999999998,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C19","v":1006},{"$f":"'4. Growth Factor - NUM_CALC1'!D19","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!E19","v":2376074},null,741945.12,0,7189049.4943999993,7930994.6143999994,null,{"$f":"IF(ISERROR(K19/N24),0,K19/N24)","v":2.4117536961699475E-2},{"$f":"IF(ISERROR(L19/N24),0,L19/N24)","v":0},{"$f":"IF(ISERROR(M19/N24),0,M19/N24)","v":0.23368597248901496},{"$f":"N19/N24","v":0.25780350945071445}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A20","v":"UNMETERED SCATTERED LOAD"},null,9.42,1.6400000000000001E-2,0,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C20","v":582},{"$f":"'4. Growth Factor - NUM_CALC1'!D20","v":3130312},{"$f":"'4. Growth Factor - NUM_CALC1'!E20","v":0},null,65789.279999999999,51337.116800000003,0,117126.3968,null,{"$f":"IF(ISERROR(K20/N24),0,K20/N24)","v":2.138534710065343E-3},{"$f":"IF(ISERROR(L20/N24),0,L20/N24)","v":1.6687552469259225E-3},{"$f":"IF(ISERROR(M20/N24),0,M20/N24)","v":0},{"$f":"N20/N24","v":3.807289956991265E-3}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A21","v":"STREET LIGHTING"},null,0.63,0,4.5568,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C21","v":15386},{"$f":"'4. Growth Factor - NUM_CALC1'!D21","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!E21","v":26971},null,116318.16,0,122901.4528,239219.6128,null,{"$f":"IF(ISERROR(K21/N24),0,K21/N24)","v":3.7810175543938796E-3},{"$f":"IF(ISERROR(L21/N24),0,L21/N24)","v":0},{"$f":"IF(ISERROR(M21/N24),0,M21/N24)","v":3.9950129068179107E-3},{"$f":"N21/N24","v":7.7760304612117899E-3}]
[null,null,null,null,null,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C22","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!D22","v":0},0,null,0,0,0,0,null,{"$f":"IF(ISERROR(K22/N24),0,K22/N24)","v":0},{"$f":"IF(ISERROR(L22/N24),0,L22/N24)","v":0},{"$f":"IF(ISERROR(M22/N24),0,M22/N24)","v":0},{"$f":"N22/N24","v":0}]
[null,null,null,null,null,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C23","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!D23","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!E23","v":0},null,0,0,0,0,null,{"$f":"IF(ISERROR(K23/N24),0,K23/N24)","v":0},{"$f":"IF(ISERROR(L23/N24),0,L23/N24)","v":0},{"$f":"IF(ISERROR(M23/N24),0,M23/N24)","v":0},{"$f":"N23/N24","v":0}]
["Total",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K17:K23)","v":18978292.320000004},{"$f":"SUM(L17:L23)","v":4473475.3155999994},{"$f":"SUM(M17:M23)","v":7311950.9471999994},{"$f":"SUM(N17:N23)","v":30763718.582800001},null,null,null,null,{"$f":"SUM(S17:S23)","v":1.0000000000000002}]

{"sheet":"9. Threshold Test","index":7,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[[8,2,8,4],[68,2,70,5]]}
[]
[]
[]
[]
[]
[]
[]
["No Input Required."]
[null,null,{"$f":"IF('1. Information Sheet'!F26 = \"COS\", \"Preliminary Threshold Calculation\", \"Final Threshold Calculation\")","v":"Final Threshold Calculation"}]
[]
[]
[]
[null,null,"Year",null,{"$f":"+'1. Information Sheet'!K26","v":2019}]
[null,null,"Year in which Applicant is applying",null,{"$f":"+'1. Information Sheet'!F28","v":5}]
[]
[null,null,"Price Cap Index",null,1.2E-2]
[null,null,"Growth Factor Calculation"]
[null,null,{"$f":"'1. Information Sheet'!F46","v":"2017 Actual Distribution Revenues"},null,{"$f":"'5. Growth Factor - NUM_CALC2'!N24","v":30763718.582800001}]
[null,null,{"$f":"+'1. Information Sheet'!F47:F47","v":"2014 Board-Approved Distribution Revenues"},null,{"$f":"'7. Growth Factor - DEN_CALC1'!N24","v":31062480.9494}]
[null,null,"Growth Factor",null,{"$f":"IF(ISERROR(E18/E19-1),0,(E18/E19-1)/('1. Information Sheet'!I46-'1. Information Sheet'!I47))","v":-3.2060367520404531E-3}]
[null,null,"Dead Band",null,0.1]
[null,null,"Average Net Fixed Assets"]
[null,null,"Gross Fixed Assets Opening",null,{"$f":"'6. Rev_Requ_Check'!C10","v":242255337}]
[null,null,"Add: CWIP Opening",null,{"$f":"'6. Rev_Requ_Check'!C11","v":0}]
[null,null,"Capital Additions",null,{"$f":"'6. Rev_Requ_Check'!C12","v":7730045}]
[null,null,"Capital Disposals",null,{"$f":"'6. Rev_Requ_Check'!C13","v":0}]
[null,null,"Capital Retirements",null,{"$f":"'6. Rev_Requ_Check'!C14","v":0}]
[null,null,"Deduct: CWIP Closing",null,{"$f":"'6. Rev_Requ_Check'!C15","v":0}]
[null,null,"Gross Fixed Assets - Closing",null,{"$f":"'6. Rev_Requ_Check'!C16","v":249985382}]
[]
[null,null,"Average Gross Fixed Assets",null,{"$f":"(E23+E29)/2","v":246120359.5}]
[]
[null,null,"Accumulated Depreciation - Opening",null,{"$f":"'6. Rev_Requ_Check'!C19","v":139112890}]
[null,null,"Depreciation Expense",null,{"$f":"'6. Rev_Requ_Check'!C20","v":4510060}]
[null,null,"Disposals",null,{"$f":"'6. Rev_Requ_Check'!C21","v":0}]
[null,null,"Retirements",null,{"$f":"'6. Rev_Requ_Check'!C22","v":0}]
[null,null,"Accumulated Depreciation - Closing",null,{"$f":"'6. Rev_Requ_Check'!C23","v":143622950}]
[]
[null,null,"Average Accumulated Depreciation",null,{"$f":"(E33+E37)/2","v":141367920}]
[]
[null,null,"Average Net Fixed Assets ",null,{"$f":"E31-E39","v":104752439.5}]
[]
[]
[null,null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Base",null,{"$f":"'6. Rev_Requ_Check'!C29","v":208278793}]
[null,null,"Working Capital Allowance Rate",null,{"$f":"'6. Rev_Requ_Check'!C30","v":0.13}]
[null,null,"Working Capital Allowance",null,{"$f":"E45*E46","v":27076243.09}]
[]
[null,null,"Rate Base",null,{"$f":"E41+E47","v":131828682.59}]
[]
[null,null,"Depreciation",null,{"$f":"E34","v":4510060}]
[]
[null,null,"Threshold Value (varies by Price Cap IR Year subsequent to CoS rebasing)"]
[null,null,"    Price Cap IR Year 2015",null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(1-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(1-1) + 10%)","v":1.3559222756475757}]
[null,null,"    Price Cap IR Year 2016",null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(2-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(2-1) + 10%)","v":1.3581630007792982}]
[null,null,"    Price Cap IR Year 2017",null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(3-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(3-1) + 10%)","v":1.3604233445593121}]
[null,null,"    Price Cap IR Year 2018",null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(4-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(4-1) + 10%)","v":1.3627034787585124}]
[null,null,"    Price Cap IR Year 2019",null,{"$f":"IF(ISERROR(1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(5-1) + 10%), 0, 1+((RB/d)*(g+PCI*(1+g)))*((1+g)*(1+PCI))^(5-1) + 10%)","v":1.3650035766517323}]
[]
[null,null,"Threshold CAPEX"]
[null,null,{"$f":"C54","v":"    Price Cap IR Year 2015"},null,{"$f":"IF(ISERROR(d*E54), \"\", d*E54)","v":6115290.8185071051}]
[null,null,{"$f":"C55","v":"    Price Cap IR Year 2016"},null,{"$f":"IF(ISERROR(d*E55), \"\", d*E55)","v":6125396.6232946813}]
[null,null,{"$f":"C56","v":"    Price Cap IR Year 2017"},null,{"$f":"IF(ISERROR(d*E56), \"\", d*E56)","v":6135590.9093631711}]
[null,null,{"$f":"C57","v":"    Price Cap IR Year 2018"},null,{"$f":"IF(ISERROR(d*E57), \"\", d*E57)","v":6145874.4514096165}]
[null,null,{"$f":"C58","v":"    Price Cap IR Year 2019"},null,{"$f":"IF(ISERROR(d*E58), \"\", d*E58)","v":6156248.0309139118}]
[]
[]
[]
[null,"Note 1:","The growth factor g is annualized, depending on the number of years between the numerator and denominator for the calculation. Typically, for ACM review in a cost of service and in the fourth year of Price Cap IR, the ratio is divided by 2 to annualize it. No division is normally required for the first three years under Price Cap IR."]

{"sheet":"10b. Proposed ACM ICM Projects","index":8,"n_rows":79,"n_cols":15,"rows_kept":79,"cut":false,"hidden":false,"merged":[[12,3,12,6],[47,3,47,14],[48,3,48,5],[48,6,48,8],[48,9,48,11],[48,12,48,14],[50,1,53,1],[56,3,56,5],[56,6,56,8],[56,9,56,11],[56,12,56,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Identify ALL Proposed ACM projects and related CAPEX costs in the relevant years"]
[]
[null,null,"Cost of Service","Price Cap IR"]
[null,null,"Test Year","Year 2","Year 3","Year 4","Year 5"]
[null,null,{"$f":"+'1. Information Sheet'!F32","v":2014},{"$f":"+C15+2","v":2016},{"$f":"D15+1","v":2017},{"$f":"E15+1","v":2018},{"$f":"F15+1","v":2019}]
["Distribution System Plan CAPEX",null,null,null,null,{"$f":"+'[6]Reply 2'!$C$4","v":10488183.83},{"$f":"+'[6]Reply 2'!$D$4","v":14623987}]
[]
["Materiality Threshold",null,null,{"$f":"'9. Threshold Test'!E62","v":6125396.6232946813},{"$f":"'9. Threshold Test'!E63","v":6135590.9093631711},{"$f":"'9. Threshold Test'!E64","v":6145874.4514096165},{"$f":"'9. Threshold Test'!E65","v":6156248.0309139118}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,0,{"$f":"IF(D18>D16,0,D16-D18)","v":0},{"$f":"IF(E18>E16,0,E16-E18)","v":0},{"$f":"IF(F18>F16,0,F16-F18)","v":4342309.3785903836},{"$f":"IF(G18>G16,0,G16-G18)","v":8467738.9690860882}]
[]
["Project Descriptions:","Type","Test Year",{"$f":"D14","v":"Year 2"},"Year 3","Year 4","Year 5","Total"]
[null,null,{"$f":"C15","v":2014},2016,2017,2018,2019]
["Project 1: Tremaine TS - CCRA True-up","New ICM",null,null,null,0,3717100,{"$f":"SUM(D24:G24)","v":3717100}]
["Project 2: Tremaine TS - Additional Breaker Positions","New ICM",null,null,null,1000000,1000000,2000000]
["Project 3: Bronte TS - Additional Breaker Positions","New ICM",null,null,null,0,1030600,1030600]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
["Total Cost of ACM Projects",null,0,{"$f":"SUM(D24:D42)","v":0},{"$f":"SUM(E24:E42)","v":0},{"$f":"SUM(F24:F42)","v":1000000},{"$f":"SUM(G24:G42)","v":5747700},{"$f":"SUM(D44:G44)","v":6747700}]
[]
["Maximum Allowed Incremental Capital",null,null,{"$f":"MIN(D44,D20)","v":0},{"$f":"MIN(E44,E20)","v":0},{"$f":"MIN(F44,F20)","v":1000000},{"$f":"MIN(G44,G20)","v":5747700},{"$f":"SUM(D46:G46)","v":6747700}]
[]
[null,null,null,"Price Cap IR"]
[null,null,"Test Year","Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5"]
[null,null,{"$f":"C15","v":2014},null,{"$f":"D15","v":2016},null,null,{"$f":"E15","v":2017},null,null,{"$f":"F15","v":2018},null,null,{"$f":"G15","v":2019}]
["Distribution System Plan CAPEX",null,{"$f":"C16","v":0},{"$f":"D16","v":0},null,null,{"$f":"E16","v":0},null,null,{"$f":"F16","v":10488183.83},null,null,{"$f":"G16","v":14623987}]
[]
["Materiality Threshold",null,null,{"$f":"D18","v":6125396.6232946813},null,null,{"$f":"E18","v":6135590.9093631711},null,null,{"$f":"F18","v":6145874.4514096165},null,null,{"$f":"G18","v":6156248.0309139118}]
[]
["Maximum Eligible Incremental Capital (Forecasted Capex less Threshold)",null,0,{"$f":"D20","v":0},null,null,{"$f":"E20","v":0},null,null,{"$f":"F20","v":4342309.3785903836},null,null,{"$f":"G20","v":8467738.9690860882}]
[]
[null,null,"Test Year","Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5"]
[null,null,{"$f":"C15","v":2014},null,{"$f":"D15","v":2016},null,null,{"$f":"E15","v":2017},null,null,{"$f":"F15","v":2018},null,null,{"$f":"G15","v":2019}]
["Project Descriptions:","Type",null,"Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA","Proposed ACM/ICM","Amortization Expense","CCA"]
[{"$f":"IF(OR(A24=\"\", A24=0), \"\", A24)","v":"Project 1: Tremaine TS - CCRA True-up"},"New ICM",null,{"$f":"IF(OR(D24=\"\", D24=0), 0, D24)","v":0},null,null,{"$f":"IF(OR(E24=\"\", E24=0), 0, E24)","v":0},null,null,{"$f":"IF(OR(F24=\"\", F24=0), 0, F24)","v":0},{"$f":"+J60/60","v":0},{"$f":"+J60*0.07","v":0},{"$f":"IF(OR(G24=\"\", G24=0), 0, G24)","v":3717100},{"$f":"+M60/60","v":61951.666666666664},{"$f":"+M60*0.07","v":260197.00000000003}]
["Project 2: Tremaine TS - Additional Breaker Positions","New ICM",null,0,null,null,0,null,null,1000000,16666.666666666668,70000,1000000,{"$f":"+M61/60","v":16666.666666666668},{"$f":"+M61*0.07","v":70000}]
["Project 3: Bronte TS - Additional Breaker Positions","New ICM",null,0,null,null,0,null,null,0,null,null,1030600,{"$f":"+M62/60","v":17176.666666666668},{"$f":"+M62*0.07","v":72142}]
["","",null,0,null,null,0,null,null,0,null,null,0,{"$f":"+M63/5","v":0},{"$f":"+M63*0.55","v":0}]
[{"$f":"IF(OR(A29=\"\", A29=0), \"\", A29)","v":""},"",null,{"$f":"IF(OR(D29=\"\", D29=0), 0, D29)","v":0},null,null,{"$f":"IF(OR(E29=\"\", E29=0), 0, E29)","v":0},null,null,{"$f":"IF(OR(F29=\"\", F29=0), 0, F29)","v":0},null,null,{"$f":"IF(OR(G29=\"\", G29=0), 0, G29)","v":0}]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
["","",null,0,null,null,0,null,null,0,null,null,0]
[]
["Total Cost of Projects",null,null,{"$f":"SUM(D60:D77)","v":0},{"$f":"SUM(E60:E77)","v":0},0,0,0,0,1000000,16666.666666666668,70000,5747700,95795,402339]

{"sheet":"11. Incremental Capital Adj.","index":9,"n_rows":83,"n_cols":12,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Incremental Capital Adjustment"]
[]
[]
[]
[null,"Current Revenue Requirement"]
[]
[null,"Current Revenue Requirement - Total",null,null,{"$f":"'6. Rev_Requ_Check'!E62","v":29406581.15257962},"A"]
[]
[]
[null,"Return on Rate Base",null,null,null,null,"Tremaine TS1","Tremaine TS2","Bronte TS",null,null,"Check = 0"]
[null,"Incremental Capital",null,null,{"$f":"+'10b. Proposed ACM ICM Projects'!J79+'10b. Proposed ACM ICM Projects'!M79","v":6747700},"B",{"$f":"+'10b. Proposed ACM ICM Projects'!J60+'10b. Proposed ACM ICM Projects'!M60","v":3717100},{"$f":"+'10b. Proposed ACM ICM Projects'!J61+'10b. Proposed ACM ICM Projects'!M61","v":2000000},{"$f":"+'10b. Proposed ACM ICM Projects'!M62","v":1030600},{"$f":"+'10b. Proposed ACM ICM Projects'!M63","v":0},{"$f":"+'10b. Proposed ACM ICM Projects'!M64","v":0},{"$f":"SUM(G22:K22)-E22","v":0}]
[null,"Depreciation Expense",null,null,{"$f":"+'10b. Proposed ACM ICM Projects'!K79+'10b. Proposed ACM ICM Projects'!N79","v":112461.66666666667},"C",{"$f":"+'10b. Proposed ACM ICM Projects'!K60+'10b. Proposed ACM ICM Projects'!N60","v":61951.666666666664},{"$f":"+'10b. Proposed ACM ICM Projects'!K61+'10b. Proposed ACM ICM Projects'!N61","v":33333.333333333336},{"$f":"+'10b. Proposed ACM ICM Projects'!N62","v":17176.666666666668},{"$f":"+'10b. Proposed ACM ICM Projects'!N63","v":0},{"$f":"+'10b. Proposed ACM ICM Projects'!N64","v":0},{"$f":"SUM(G23:K23)-E23","v":0}]
[null,"Incremental Capital to be included in Rate Base",null,null,{"$f":"(+E22+(E22-E23))/2","v":6691469.166666666},"D = (B + (B-C))/2",{"$f":"+G22-G23","v":3655148.3333333335},{"$f":"+H22-H23","v":1966666.6666666667},1013423.3333333334,0,0,{"$f":"SUM(G24:K24)-E24","v":-56230.833333333023}]
[]
[null,"Deemed ShortTerm Debt %",{"$f":"'6. Rev_Requ_Check'!C36","v":0.04},"E",{"$f":"E24*C26","v":267658.76666666666},"G = D * E",{"$f":"G24*$C26","v":146205.93333333335},{"$f":"H24*$C26","v":78666.666666666672},40536.933333333334,0,0,{"$f":"SUM(G26:K26)-E26","v":-2249.233333333279}]
[null,"Deemed Long Term Debt %",{"$f":"'6. Rev_Requ_Check'!C37","v":0.56000000000000005},"F",{"$f":"E24*C27","v":3747222.7333333334},"H = D * F",{"$f":"G24*$C27","v":2046883.0666666669},{"$f":"H24*$C27","v":1101333.3333333335},567517.06666666677,0,0,{"$f":"SUM(G27:K27)-E27","v":-31489.266666666139}]
[]
[null,"Short Term Interest",{"$f":"'6. Rev_Requ_Check'!C40","v":2.1100000000000001E-2},"I",{"$f":"E26*C29","v":5647.5999766666664},"K = G * I",{"$f":"G26*$C29","v":3084.9451933333339},{"$f":"H26*$C29","v":1659.8666666666668},855.32929333333334,0,0,{"$f":"SUM(G29:K29)-E29","v":-47.458823333332475}]
[null,"Long Term Interest",{"$f":"'6. Rev_Requ_Check'!C41","v":4.7300000000000002E-2},"J",{"$f":"E27*C30","v":177243.63528666669},"L = H * J",{"$f":"G27*$C30","v":96817.56905333334},{"$f":"H27*$C30","v":52093.066666666673},26843.55725333334,0,0,{"$f":"SUM(G30:K30)-E30","v":-1489.442313333333}]
[]
[null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(E29:E30)","v":182891.23526333336},"M = K + L",{"$f":"SUM(G29:G30)","v":99902.514246666673},{"$f":"SUM(H29:H30)","v":53752.933333333342},27698.886546666672,0,0,{"$f":"SUM(G32:K32)-E32","v":-1536.9011366666819}]
[]
[]
[null,"Deemed Equity %",{"$f":"'6. Rev_Requ_Check'!C38","v":0.39999999999999991},"N",{"$f":"E24*C35","v":2676587.666666666},"P = D * N",{"$f":"G24* $C35","v":1462059.333333333},{"$f":"H24* $C35","v":786666.66666666651},405369.33333333326,0,0,{"$f":"SUM(G35:K35)-E35","v":-22492.333333333023}]
[]
[null,"Return on Rate Base -Equity",{"$f":"'6. Rev_Requ_Check'!C42","v":9.3600000000000003E-2},"O",{"$f":"E35*C37","v":250528.60559999995},"Q = P * O",{"$f":"G35*$C37","v":136848.75359999997},{"$f":"H35*$C37","v":73631.999999999985},37942.569599999995,0,0,{"$f":"SUM(G37:K37)-E37","v":-2105.2824000000255}]
[]
[null,"Return on Rate Base - Total",null,null,{"$f":"E32+E37","v":433419.84086333332},"R = M + Q",{"$f":"G32+G37","v":236751.26784666663},{"$f":"H32+H37","v":127384.93333333332},65641.456146666664,0,0,{"$f":"SUM(G39:K39)-E39","v":-3642.1835366666783}]
[]
[]
[]
[null,"Amortization Expense"]
[]
[null,"Amortization Expense - Incremental",null,"C",{"$f":"E23","v":112461.66666666667},"S",{"$f":"G23","v":61951.666666666664},{"$f":"H23","v":33333.333333333336},17176.666666666668,0,0,{"$f":"SUM(G45:K45)-E45","v":0}]
[]
[]
[null,"Grossed up PIL's"]
[]
[null,"Regulatory Taxable Income",null,"O",{"$f":"E37","v":250528.60559999995},"T ",{"$f":"G37","v":136848.75359999997},{"$f":"H37","v":73631.999999999985},37942.569599999995,0,0,{"$f":"SUM(G50:K50)-E50","v":-2105.2824000000255}]
[]
[null,"Add Back Amortization Expense",null,"S",{"$f":"E45","v":112461.66666666667},"U",{"$f":"G45","v":61951.666666666664},{"$f":"H45","v":33333.333333333336},17176.666666666668,0,0,{"$f":"SUM(G52:K52)-E52","v":0}]
[]
[null,"Deduct CCA",null,null,{"$f":"+'10b. Proposed ACM ICM Projects'!L79+'10b. Proposed ACM ICM Projects'!O79","v":472339},"V",{"$f":"+'10b. Proposed ACM ICM Projects'!L60+'10b. Proposed ACM ICM Projects'!O60","v":260197.00000000003},{"$f":"+'10b. Proposed ACM ICM Projects'!L61+'10b. Proposed ACM ICM Projects'!O61","v":140000},{"$f":"+'10b. Proposed ACM ICM Projects'!$O62","v":72142},{"$f":"+'10b. Proposed ACM ICM Projects'!$O63","v":0},{"$f":"+'10b. Proposed ACM ICM Projects'!$O64","v":0},{"$f":"SUM(G54:K54)-E54","v":0}]
[]
[null,"Incremental Taxable Income",null,null,{"$f":"E50+E52-E54","v":-109348.72773333336},"W = T + U - V",{"$f":"G50+G52-G54","v":-61396.579733333405},{"$f":"H50+H52-H54","v":-33034.666666666686},-17022.76373333334,0,0,{"$f":"SUM(G56:K56)-E56","v":-2105.2824000000692}]
[]
[null,"Current Tax Rate",0.26500000000000001,"X"]
[]
[null,"PIL's Before Gross Up",null,null,{"$f":"E56*C58","v":-28977.412849333341},"Y = W * X",{"$f":"G56*$C58","v":-16270.093629333353},{"$f":"H56*$C58","v":-8754.186666666672},-4511.0323893333352,0,0,{"$f":"SUM(G60:K60)-E60","v":-557.89983600001869}]
[]
[null,"Incremental Grossed Up PIL's",null,null,{"$f":"E60/(1-C58)","v":-39425.051495691623},"Z = Y / ( 1 - X ) ",{"$f":"G60/(1-$C58)","v":-22136.181808616806},{"$f":"H60/(1-$C58)","v":-11910.458049886629},-6137.4590331065783,0,0,{"$f":"SUM(G62:K62)-E62","v":-759.04739591838734}]
[]
[]
[null,"Ontario Capital Tax"]
[null,"Incremental Capital CAPEX",null,null,null,"AA"]
[]
[null,"Less : Available Capital Exemption (if any)",null,null,null,"AB"]
[]
[null,"Incremental Capital CAPEX subject to OCT",null,null,null,"AC = AA - AB"]
[]
[null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",null,"AD"]
[]
[null,"Incremental Ontario Capital Tax",null,null,null,"AE = AC * AD"]
[]
[]
[null,"Incremental Revenue Requirement"]
[null,"Return on Rate Base - Total",null,"Q",{"$f":"E39","v":433419.84086333332},"AA",{"$f":"G39","v":236751.26784666663},{"$f":"H39","v":127384.93333333332},65641.456146666664,0,0,{"$f":"SUM(G78:K78)-E78","v":-3642.1835366666783}]
[null,"Amortization Expense - Total",null,"S",{"$f":"E45","v":112461.66666666667},"AB",{"$f":"G45","v":61951.666666666664},{"$f":"H45","v":33333.333333333336},17176.666666666668,0,0,{"$f":"SUM(G79:K79)-E79","v":0}]
[null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"E62","v":-39425.051495691623},"AC",{"$f":"G62","v":-22136.181808616806},{"$f":"H62","v":-11910.458049886629},-6137.4590331065783,0,0,{"$f":"SUM(G80:K80)-E80","v":-759.04739591838734}]
[]
[]
[null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(E78:E81)","v":506456.4560343083},"AD = AA + AB + AC",{"$f":"SUM(G78:G81)","v":276566.75270471652},{"$f":"SUM(H78:H81)","v":148807.80861678004},76680.663780226751,0,0,{"$f":"SUM(G83:K83)-E83","v":-4401.2309325849637}]

{"sheet":"12. Opt 1-Rate Rider Calc F & V","index":10,"n_rows":26,"n_cols":26,"rows_kept":26,"cut":false,"hidden":false,"merged":[[12,0,12,3],[12,4,12,5]]}
[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,true]
[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,false]
[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,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculation of incremental rate rider.  Choose one of the 3 options:"]
[]
["Rate Class",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue kWh","Distribution Volumetric Rate % Revenue kW","Service Charge Revenue","Distribution Volumetric Rate Revenue kWh","Distribution Volumetric Rate Revenue kW","Total Revenue by Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Service Charge Rate Rider","Distribution Volumetric Rate kWh Rate Rider","Distribution Volumetric Rate kW Rate Rider"]
[null,null,"From Sheet 8","From Sheet 8","From Sheet 8","Col C * Col Itotal","Col  D* Col Itotal","Col  E* Col Itotal",null,null,"From Sheet 4","From Sheet 4","From Sheet 4",null,"Col F / Col K / 12","Col G / Col L","Col H / Col M"]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A17","v":"RESIDENTIAL"},null,{"$f":"'8. Revenue Proportions'!P17","v":0.53038071441475709},{"$f":"'8. Revenue Proportions'!Q17","v":6.8215920359293414E-2},{"$f":"'8. Revenue Proportions'!R17","v":0},{"$f":"C17*$I$25","v":268614.73697144247},{"$f":"D17*$I$25","v":34548.39327028636},{"$f":"E17*$I$25","v":0},{"$f":"SUM(F17:H17)","v":303163.13024172885},null,{"$f":"'4. Growth Factor - NUM_CALC1'!C17","v":60593},{"$f":"'4. Growth Factor - NUM_CALC1'!D17","v":499660804},0,null,{"$f":"IFERROR(I17/K17/12,\"\")","v":0.4169391544701655},0,{"$f":"IFERROR(H17/M17,\"\")","v":""},"Note:  As per the OEB's letter issued July 16, 2015 (EB-2012-0410), Residential Rates will be applied on a fixed basis only."]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A18","v":"GENERAL SERVICE LESS THAN 50 KW"},null,{"$f":"'8. Revenue Proportions'!P18","v":5.6487212861568041E-2},{"$f":"'8. Revenue Proportions'!Q18","v":7.5529322495463999E-2},{"$f":"'8. Revenue Proportions'!R18","v":0},{"$f":"C18*$I$25","v":28608.313637125349},38252.312997725057,0,{"$f":"SUM(F18:H18)","v":66860.6266348504},null,{"$f":"'4. Growth Factor - NUM_CALC1'!C18","v":5523},{"$f":"'4. Growth Factor - NUM_CALC1'!D18","v":165968773},0,null,{"$f":"IFERROR(F18/K18/12,\"\")","v":0.43165419815808664},{"$f":"IFERROR(G18/L18,\"\")","v":2.3047897689600354E-4},""]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A19","v":"GENERAL SERVICE GREATER THAN 50 KW"},null,{"$f":"'8. Revenue Proportions'!P19","v":2.4117536961699475E-2},{"$f":"'8. Revenue Proportions'!Q19","v":0},{"$f":"'8. Revenue Proportions'!R19","v":0.23368597248901496},12214.482297898756,0,118351.76945171738,130566.25174961613,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C19","v":1006},{"$f":"'4. Growth Factor - NUM_CALC1'!D19","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!E19","v":2376074},null,{"$f":"IFERROR(F19/K19/12,\"\")","v":1.0118027085734556},{"$f":"IFERROR(G19/L19,\"\")","v":""},{"$f":"IFERROR(H19/M19,\"\")","v":4.9809799464039156E-2}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A20","v":"UNMETERED SCATTERED LOAD"},null,{"$f":"'8. Revenue Proportions'!P20","v":2.138534710065343E-3},{"$f":"'8. Revenue Proportions'!Q20","v":1.6687552469259225E-3},{"$f":"'8. Revenue Proportions'!R20","v":0},1083.0747103660506,845.15186834675978,0,1928.2265787128104,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C20","v":582},{"$f":"'4. Growth Factor - NUM_CALC1'!D20","v":3130312},{"$f":"'4. Growth Factor - NUM_CALC1'!E20","v":0},null,0.1550794258828824,2.699896586496042E-4,{"$f":"IFERROR(H20/M20,\"\")","v":""}]
[{"$f":"+'4. Growth Factor - NUM_CALC1'!A21","v":"STREET LIGHTING"},null,{"$f":"'8. Revenue Proportions'!P21","v":3.7810175543938796E-3},{"$f":"'8. Revenue Proportions'!Q21","v":0},{"$f":"'8. Revenue Proportions'!R21","v":3.9950129068179107E-3},1914.9207508018317,0,2023.3000785983195,3938.2208294001512,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C21","v":15386},{"$f":"'4. Growth Factor - NUM_CALC1'!D21","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!E21","v":26971},null,1.0371553960320161E-2,"",7.501761442283636E-2]
[null,null,{"$f":"'8. Revenue Proportions'!P22","v":0},{"$f":"'8. Revenue Proportions'!Q22","v":0},{"$f":"'8. Revenue Proportions'!R22","v":0},0,0,0,0,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C22","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!D22","v":0},0,null,{"$f":"IFERROR(I22/K22/12,\"\")","v":""},"",""]
[null,null,{"$f":"'8. Revenue Proportions'!P23","v":0},{"$f":"'8. Revenue Proportions'!Q23","v":0},{"$f":"'8. Revenue Proportions'!R23","v":0},0,0,0,0,null,{"$f":"'4. Growth Factor - NUM_CALC1'!C23","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!D23","v":0},{"$f":"'4. Growth Factor - NUM_CALC1'!E23","v":0},null,"","",""]
["Total",null,{"$f":"SUM(C17:C23)","v":0.61690501650248375},0.14541399810168334,0.23768098539583288,312435.52836763446,73645.858136358176,120375.0695303157,506456.45603430836,null,{"$f":"SUM(K17:K23)","v":83090},{"$f":"SUM(L17:L23)","v":668759889},{"$f":"SUM(M17:M23)","v":2403045}]
[null,null,null,null,null,null,null,null,{"$f":"'11. Incremental Capital Adj.'!E83","v":506456.4560343083}]
[null,null,null,null,null,null,null,null,"From Sheet 11, E83"]