{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["App.2-CA_CGAAP_DepExp_2011","App.2-CB_MIFRS_DepExp_2011","App.2-CC_MIFRS_DepExp_2012","App.2-CD_MIFRS_DepExp_2013","App.2-CI_AltAccStd_DepExp","App.2-EA_PP&E Deferral Account","App.2-W_Bill Impacts_RES800","App.2-W_Bill Impacts_GS<50","App.2-W_Bill Impacts_GS>50","App.2-W_Bill Impacts_USL","App.2-W_Bill Impacts_Sentinel","App.2-W_Bill Impacts_Streetligh"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":19,"comments":6,"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-CA_CGAAP_DepExp_2011","index":0,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":true,"merged":[[10,0,10,11],[8,0,8,11],[9,0,9,11],[57,1,57,11],[60,1,61,11],[58,1,59,9],[13,0,14,0],[13,1,14,1],[13,10,14,10]]}
[null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-CA"]
["Depreciation and Amortization Expense"]
["Assumes the applicant adopted IFRS for financial reporting purposes January 1, 2012"]
[null,null,"Year",2011,"CGAAP"]
[]
["Account","Description","Opening Regulatory Gross PP&E as at Jan 1, 2011 ","Less Fully Depreciated","Net for Depreciation","Additions","Total for Depreciation","Years","Depreciation Rate","Depreciation Expense","2011 Depreciation Expense per Appendix 2-B Fixed Assets, Column K \n (l)","Variance 2"]
[null,null,"(a)","(b)","(c)","(d)","(e) = (c) + ½ x (d) 1","(f)","(g) = 1 / (f)","(h) = (e) / (f)",null,"(m) = (h) - (l)"]
[1611,"Computer Software (Formally known as Account 1925)",null,null,{"$f":"C16-D16","v":0},null,{"$f":"E16+0.5*F16","v":0},null,{"$f":"IF(H16=0,0,1/H16)","v":0},{"$f":"IF(H16=0,0,G16/H16)","v":0},null,{"$f":"IF(ISERROR(+J16-K16), 0, +J16-K16)","v":0}]
[1612,"Land Rights (Formally known as Account 1906)",null,null,{"$f":"C17-D17","v":0},null,{"$f":"E17+0.5*F17","v":0},null,0,0,null,0]
[1805,"Land",null,null,0,null,0,null,0,0,null,0]
[1808,"Buildings",null,null,0,null,0,null,0,0,null,0]
[1810,"Leasehold Improvements",null,null,0,null,0,null,0,0,null,0]
[1815,"Transformer Station Equipment >50 kV",null,null,0,null,0,null,0,0,null,0]
[1820,"Distribution Station Equipment <50 kV",null,null,0,null,0,null,0,0,null,0]
[1825,"Storage Battery Equipment",null,null,0,null,0,null,0,0,null,0]
[1830,"Poles, Towers & Fixtures",null,null,0,null,0,null,0,0,null,0]
[1835,"Overhead Conductors & Devices",null,null,0,null,0,null,0,0,null,0]
[1840,"Underground Conduit",null,null,0,null,0,null,0,0,null,0]
[1845,"Underground Conductors & Devices",null,null,0,null,0,null,0,0,null,0]
[1850,"Line Transformers",null,null,0,null,0,null,0,0,null,0]
[1855,"Services (Overhead & Underground)",null,null,0,null,0,null,0,0,null,0]
[1860,"Meters",null,null,0,null,0,null,0,0,null,0]
[1860,"Meters (Smart Meters)",null,null,0,null,0,null,0,0,null,0]
[1905,"Land",null,null,0,null,0,null,0,0,null,0]
[1908,"Buildings & Fixtures",null,null,0,null,0,null,0,0,null,0]
[1910,"Leasehold Improvements",null,null,0,null,0,null,0,0,null,0]
[1915,"Office Furniture & Equipment (10 years)",null,null,0,null,0,null,0,0,null,0]
[1915,"Office Furniture & Equipment (5 years)",null,null,0,null,0,null,0,0,null,0]
[1920,"Computer Equipment - Hardware",null,null,0,null,0,null,0,0,null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 22/04)",null,null,0,null,0,null,0,0,null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 19/07)",null,null,0,null,0,null,0,0,null,0]
[1930,"Transportation Equipment",null,null,0,null,0,null,0,0,null,0]
[1935,"Stores Equipment",null,null,0,null,0,null,0,0,null,0]
[1940,"Tools, Shop & Garage Equipment",null,null,0,null,0,null,0,0,null,0]
[1945,"Measurement & Testing Equipment",null,null,0,null,0,null,0,0,null,0]
[1950,"Power Operated Equipment",null,null,0,null,0,null,0,0,null,0]
[1955,"Communications Equipment",null,null,0,null,0,null,0,0,null,0]
[1955,"Communication Equipment (Smart Meters)",null,null,0,null,0,null,0,0,null,0]
[1960,"Miscellaneous Equipment ",null,null,0,null,0,null,0,0,null,0]
[1975,"Load Management Controls Utility Premises",null,null,0,null,0,null,0,0,null,0]
[1980,"System Supervisor Equipment",null,null,0,null,0,null,0,0,null,0]
[1985,"Miscellaneous Fixed Assets",null,null,0,null,0,null,0,0,null,0]
[1995,"Contributions & Grants",null,null,0,null,0,null,0,0,null,0]
["etc.",null,null,null,0,null,0,null,0,0,null,0]
[null,null,null,null,0,null,0,null,0,0,null,0]
[null,"Total",{"$f":"SUM(C16:C53)","v":0},{"$f":"SUM(D16:D53)","v":0},{"$f":"SUM(E16:E53)","v":0},{"$f":"SUM(F16:F53)","v":0},{"$f":"SUM(G16:G53)","v":0},null,null,{"$f":"SUM(J16:J53)","v":0},{"$f":"SUM(K16:K53)","v":0},{"$f":"SUM(L16:L53)","v":0}]
[]
["Notes:"]
[]
[1,"Board policy of the \"half-year\" rule - the applicant must ensure that additions in the year attract a half-year depreciation expense in the first year.  Deviations from this standard practice must be supported in the application."]
[2,"The applicant must provide an explanation of material variances in evidence"]
[]
["General","Applicants must provide a breakdown of depreciation and amortization expense in the above format for all relevant accounts.  Asset Retirement Obligations (AROs), depreciation and accretion expense should be disclosed separately consistent with the Notes of historical Audited Financial Statements."]

{"sheet":"App.2-CB_MIFRS_DepExp_2011","index":1,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":true,"merged":[[8,0,8,14],[9,0,9,14],[10,0,10,14],[61,1,61,14],[64,1,65,14],[57,1,57,14],[58,1,58,14],[59,1,59,14],[60,1,60,14],[13,0,14,0],[13,1,14,1],[13,10,14,10],[13,13,14,13],[62,1,62,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-CB"]
["Depreciation and Amortization Expense"]
["Assumes the applicant adopted IFRS for financial reporting purposes January 1, 2012"]
[null,null,"Year",2011,"MIFRS"]
[]
["Account","Description","Opening NBV as at Jan 1, 2011 5","Additions","Average Remaining Life of Opening NBV 4","Years (new additions only) 3","Depreciation Rate on New Additions","Depreciation Expense on Opening NBV","Depreciation Expense on Additions 1","2011 Depreciation Expense","2011 Depreciation Expense per Appendix 2-B Fixed Assets, Column K \n (l)","Variance 2","Depreciation Expense on 2011 Full Year Additions","Less Depreciation Expense on Assets Fully Depreciated during the year\n(o)","2011 Full Year Depreciation 6"]
[null,null,"(a)","(d)","(i)","(f)","(g) = 1 / (f)","(j) = (a) / (i)","(h)=((d)*0.5)/(f) ","(k) = (j) + (h)",null,"(m) = (k) - (l)","(n) = (d)/(f) ",null,"(p) = (j) + (n) - (o)"]
[1611,"Computer Software (Formally known as Account 1925)",null,null,null,null,{"$f":"IF(F16=0,0,1/F16)","v":0},{"$f":"IF(E16=0,0,+C16/E16)","v":0},{"$f":"IF(F16=0,0,+(D16*0.5)/F16)","v":0},{"$f":"IF(ISERROR(+H16+I16), 0, +H16+I16)","v":0},null,{"$f":"IF(ISERROR(+J16-K16), 0, +J16-K16)","v":0},{"$f":"IF(F16=0,0,+(D16)/F16)","v":0},null,{"$f":"IF(ISERROR(+M16+H16-N16), 0, +M16+H16-N16)","v":0}]
[1612,"Land Rights (Formally known as Account 1906)",null,null,null,null,0,0,0,0,null,0,0,null,{"$f":"IF(ISERROR(+M17+H17-N17), 0, +M17+H17-N17)","v":0}]
[1805,"Land",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1808,"Buildings",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1810,"Leasehold Improvements",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1815,"Transformer Station Equipment >50 kV",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1820,"Distribution Station Equipment <50 kV",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1825,"Storage Battery Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1830,"Poles, Towers & Fixtures",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1835,"Overhead Conductors & Devices",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1840,"Underground Conduit",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1845,"Underground Conductors & Devices",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1850,"Line Transformers",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1855,"Services (Overhead & Underground)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1860,"Meters",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1860,"Meters (Smart Meters)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1905,"Land",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1908,"Buildings & Fixtures",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1910,"Leasehold Improvements",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1915,"Office Furniture & Equipment (10 years)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1915,"Office Furniture & Equipment (5 years)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1920,"Computer Equipment - Hardware",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 22/04)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 19/07)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1930,"Transportation Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1935,"Stores Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1940,"Tools, Shop & Garage Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1945,"Measurement & Testing Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1950,"Power Operated Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1955,"Communications Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1955,"Communication Equipment (Smart Meters)",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1960,"Miscellaneous Equipment ",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1975,"Load Management Controls Utility Premises",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1980,"System Supervisor Equipment",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1985,"Miscellaneous Fixed Assets",null,null,null,null,0,0,0,0,null,0,0,null,0]
[1995,"Contributions & Grants",null,null,null,null,0,0,0,0,null,0,0,null,0]
["etc.",null,null,null,null,null,0,0,0,0,null,0,0,null,0]
[null,null,null,null,null,null,0,0,0,0,null,0,0,null,0]
[null,"Total",{"$f":"SUM(C16:C53)","v":0},{"$f":"SUM(D16:D53)","v":0},null,null,null,{"$f":"SUM(H16:H53)","v":0},0,0,0,0,0,{"$f":"SUM(N16:N53)","v":0},0]
[]
["Notes:"]
[]
[1,"Board policy of the \"half-year\" rule - the applicant must ensure that additions in the year attract a half-year depreciation expense in the first year.  Deviations from this standard practice must be supported in the application."]
[2,"The applicant must provide an explanation of material variances in evidence"]
[3,"The applicant should ensure that the years for new additions of assets are the asset useful lives determined by management in accordance with IFRS. "]
[4,"A recalculation should be performed to determine the average remaining life of opening balance of assets (i.e. excluding 2011 additions) under IFRS.  For example, Asset A had a useful life of 20 years under CGAAP.  On January 1, 2011, the date of transition, Asset A was 3 years depreciated. As a result, Asset A would have a remaining service life of 17 years (20 years less 3 years) under CGAAP as of January 1, 2011.  Due to the transition to IFRS, management re-assessed the asset useful lives under IFRS principles and concluded that the revised useful life of Asset A is now 30 years. Therefore, the average remaining useful life of opening balance of Asset A is determined to be 27 years (30 years less 3 years) under IFRS as of January 1, 2011."]
[5," NBV must exclude assets still on the books but which have been fully amortized or depreciated."]
[6,"This column refers to the calculated full year depreciation but excludes the depreciation expense on assets fully depreciated during the year.  This column is used for the purpose of calculating depreciation expense in the following year on the next worksheet."]
[]
["General:","Applicants must provide a breakdown of depreciation and amortization expense in the above format for all relevant accounts.  Asset Retirement Obligations (AROs), depreciation and accretion expense should be disclosed separately consistent with the Notes of historical Audited Financial Statements."]

{"sheet":"App.2-CC_MIFRS_DepExp_2012","index":2,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":true,"merged":[[8,0,8,10],[56,1,56,10],[57,1,57,10],[58,1,58,10],[9,0,9,10],[60,1,61,10],[13,0,14,0],[13,1,14,1],[13,6,14,6],[10,0,10,10],[13,9,14,9]]}
[null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-CC"]
["Depreciation and Amortization Expense"]
["Assumes the applicant adopted IFRS for financial reporting purposes January 1, 2012"]
[null,null,2012,"MIFRS"]
[]
["Account","Description","Additions","Years (new additions only)","Depreciation Rate on New Additions","2012 Depreciation Expense 1","2012 Depreciation Expense per Apppendix 2-B Fixed Assets, Column K\n (l)","Variance 2","Depreciation Expense on 2012 Full Year Additions","Less Depreciation Expense on Assets Fully Depreciated during the year\n(o)","2012 Full Year Depreciation 3"]
[null,null,"(d)","(f)","(g) = 1 / (f)","(h)=2011 Full Year Deprecation + ((d)*0.5)/(f) ",null,"(m) = (h) - (l)","(n)=((d))/(f) ",null,"(o) = 2011 Full Year Depreciation  + (n) - (o)"]
[1611,"Computer Software (Formally known as Account 1925)",null,null,{"$f":"IF(D16=0,0,1/D16)","v":0},{"$f":"IF(D16=0,+'App.2-CB_MIFRS_DepExp_2011'!O16,+'App.2-CB_MIFRS_DepExp_2011'!O16+((C16*0.5)/D16))","v":0},null,{"$f":"IF(ISERROR(+F16-G16), 0, +F16-G16)","v":0},{"$f":"IF(D16=0,0,+(C16)/D16)","v":0},null,{"$f":"IF(ISERROR(+I16+'App.2-CB_MIFRS_DepExp_2011'!O16-J16), 0, +I16+'App.2-CB_MIFRS_DepExp_2011'!O16-J16)","v":0}]
[1612,"Land Rights (Formally known as Account 1906)",null,null,0,{"$f":"IF(D17=0,+'App.2-CB_MIFRS_DepExp_2011'!O17,+'App.2-CB_MIFRS_DepExp_2011'!O17+((C17*0.5)/D17))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I17+'App.2-CB_MIFRS_DepExp_2011'!O17-J17), 0, +I17+'App.2-CB_MIFRS_DepExp_2011'!O17-J17)","v":0}]
[1805,"Land",null,null,0,{"$f":"IF(D18=0,+'App.2-CB_MIFRS_DepExp_2011'!O18,+'App.2-CB_MIFRS_DepExp_2011'!O18+((C18*0.5)/D18))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I18+'App.2-CB_MIFRS_DepExp_2011'!O18-J18), 0, +I18+'App.2-CB_MIFRS_DepExp_2011'!O18-J18)","v":0}]
[1808,"Buildings",null,null,0,{"$f":"IF(D19=0,+'App.2-CB_MIFRS_DepExp_2011'!O19,+'App.2-CB_MIFRS_DepExp_2011'!O19+((C19*0.5)/D19))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I19+'App.2-CB_MIFRS_DepExp_2011'!O19-J19), 0, +I19+'App.2-CB_MIFRS_DepExp_2011'!O19-J19)","v":0}]
[1810,"Leasehold Improvements",null,null,0,{"$f":"IF(D20=0,+'App.2-CB_MIFRS_DepExp_2011'!O20,+'App.2-CB_MIFRS_DepExp_2011'!O20+((C20*0.5)/D20))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I20+'App.2-CB_MIFRS_DepExp_2011'!O20-J20), 0, +I20+'App.2-CB_MIFRS_DepExp_2011'!O20-J20)","v":0}]
[1815,"Transformer Station Equipment >50 kV",null,null,0,{"$f":"IF(D21=0,+'App.2-CB_MIFRS_DepExp_2011'!O21,+'App.2-CB_MIFRS_DepExp_2011'!O21+((C21*0.5)/D21))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I21+'App.2-CB_MIFRS_DepExp_2011'!O21-J21), 0, +I21+'App.2-CB_MIFRS_DepExp_2011'!O21-J21)","v":0}]
[1820,"Distribution Station Equipment <50 kV",null,null,0,{"$f":"IF(D22=0,+'App.2-CB_MIFRS_DepExp_2011'!O22,+'App.2-CB_MIFRS_DepExp_2011'!O22+((C22*0.5)/D22))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I22+'App.2-CB_MIFRS_DepExp_2011'!O22-J22), 0, +I22+'App.2-CB_MIFRS_DepExp_2011'!O22-J22)","v":0}]
[1825,"Storage Battery Equipment",null,null,0,{"$f":"IF(D23=0,+'App.2-CB_MIFRS_DepExp_2011'!O23,+'App.2-CB_MIFRS_DepExp_2011'!O23+((C23*0.5)/D23))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I23+'App.2-CB_MIFRS_DepExp_2011'!O23-J23), 0, +I23+'App.2-CB_MIFRS_DepExp_2011'!O23-J23)","v":0}]
[1830,"Poles, Towers & Fixtures",null,null,0,{"$f":"IF(D24=0,+'App.2-CB_MIFRS_DepExp_2011'!O24,+'App.2-CB_MIFRS_DepExp_2011'!O24+((C24*0.5)/D24))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I24+'App.2-CB_MIFRS_DepExp_2011'!O24-J24), 0, +I24+'App.2-CB_MIFRS_DepExp_2011'!O24-J24)","v":0}]
[1835,"Overhead Conductors & Devices",null,null,0,{"$f":"IF(D25=0,+'App.2-CB_MIFRS_DepExp_2011'!O25,+'App.2-CB_MIFRS_DepExp_2011'!O25+((C25*0.5)/D25))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I25+'App.2-CB_MIFRS_DepExp_2011'!O25-J25), 0, +I25+'App.2-CB_MIFRS_DepExp_2011'!O25-J25)","v":0}]
[1840,"Underground Conduit",null,null,0,{"$f":"IF(D26=0,+'App.2-CB_MIFRS_DepExp_2011'!O26,+'App.2-CB_MIFRS_DepExp_2011'!O26+((C26*0.5)/D26))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I26+'App.2-CB_MIFRS_DepExp_2011'!O26-J26), 0, +I26+'App.2-CB_MIFRS_DepExp_2011'!O26-J26)","v":0}]
[1845,"Underground Conductors & Devices",null,null,0,{"$f":"IF(D27=0,+'App.2-CB_MIFRS_DepExp_2011'!O27,+'App.2-CB_MIFRS_DepExp_2011'!O27+((C27*0.5)/D27))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I27+'App.2-CB_MIFRS_DepExp_2011'!O27-J27), 0, +I27+'App.2-CB_MIFRS_DepExp_2011'!O27-J27)","v":0}]
[1850,"Line Transformers",null,null,0,{"$f":"IF(D28=0,+'App.2-CB_MIFRS_DepExp_2011'!O28,+'App.2-CB_MIFRS_DepExp_2011'!O28+((C28*0.5)/D28))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I28+'App.2-CB_MIFRS_DepExp_2011'!O28-J28), 0, +I28+'App.2-CB_MIFRS_DepExp_2011'!O28-J28)","v":0}]
[1855,"Services (Overhead & Underground)",null,null,0,{"$f":"IF(D29=0,+'App.2-CB_MIFRS_DepExp_2011'!O29,+'App.2-CB_MIFRS_DepExp_2011'!O29+((C29*0.5)/D29))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I29+'App.2-CB_MIFRS_DepExp_2011'!O29-J29), 0, +I29+'App.2-CB_MIFRS_DepExp_2011'!O29-J29)","v":0}]
[1860,"Meters",null,null,0,{"$f":"IF(D30=0,+'App.2-CB_MIFRS_DepExp_2011'!O30,+'App.2-CB_MIFRS_DepExp_2011'!O30+((C30*0.5)/D30))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I30+'App.2-CB_MIFRS_DepExp_2011'!O30-J30), 0, +I30+'App.2-CB_MIFRS_DepExp_2011'!O30-J30)","v":0}]
[1860,"Meters (Smart Meters)",null,null,0,{"$f":"IF(D31=0,+'App.2-CB_MIFRS_DepExp_2011'!O31,+'App.2-CB_MIFRS_DepExp_2011'!O31+((C31*0.5)/D31))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I31+'App.2-CB_MIFRS_DepExp_2011'!O31-J31), 0, +I31+'App.2-CB_MIFRS_DepExp_2011'!O31-J31)","v":0}]
[1905,"Land",null,null,0,{"$f":"IF(D32=0,+'App.2-CB_MIFRS_DepExp_2011'!O32,+'App.2-CB_MIFRS_DepExp_2011'!O32+((C32*0.5)/D32))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I32+'App.2-CB_MIFRS_DepExp_2011'!O32-J32), 0, +I32+'App.2-CB_MIFRS_DepExp_2011'!O32-J32)","v":0}]
[1908,"Buildings & Fixtures",null,null,0,{"$f":"IF(D33=0,+'App.2-CB_MIFRS_DepExp_2011'!O33,+'App.2-CB_MIFRS_DepExp_2011'!O33+((C33*0.5)/D33))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I33+'App.2-CB_MIFRS_DepExp_2011'!O33-J33), 0, +I33+'App.2-CB_MIFRS_DepExp_2011'!O33-J33)","v":0}]
[1910,"Leasehold Improvements",null,null,0,{"$f":"IF(D34=0,+'App.2-CB_MIFRS_DepExp_2011'!O34,+'App.2-CB_MIFRS_DepExp_2011'!O34+((C34*0.5)/D34))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I34+'App.2-CB_MIFRS_DepExp_2011'!O34-J34), 0, +I34+'App.2-CB_MIFRS_DepExp_2011'!O34-J34)","v":0}]
[1915,"Office Furniture & Equipment (10 years)",null,null,0,{"$f":"IF(D35=0,+'App.2-CB_MIFRS_DepExp_2011'!O35,+'App.2-CB_MIFRS_DepExp_2011'!O35+((C35*0.5)/D35))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I35+'App.2-CB_MIFRS_DepExp_2011'!O35-J35), 0, +I35+'App.2-CB_MIFRS_DepExp_2011'!O35-J35)","v":0}]
[1915,"Office Furniture & Equipment (5 years)",null,null,0,{"$f":"IF(D36=0,+'App.2-CB_MIFRS_DepExp_2011'!O36,+'App.2-CB_MIFRS_DepExp_2011'!O36+((C36*0.5)/D36))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I36+'App.2-CB_MIFRS_DepExp_2011'!O36-J36), 0, +I36+'App.2-CB_MIFRS_DepExp_2011'!O36-J36)","v":0}]
[1920,"Computer Equipment - Hardware",null,null,0,{"$f":"IF(D37=0,+'App.2-CB_MIFRS_DepExp_2011'!O37,+'App.2-CB_MIFRS_DepExp_2011'!O37+((C37*0.5)/D37))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I37+'App.2-CB_MIFRS_DepExp_2011'!O37-J37), 0, +I37+'App.2-CB_MIFRS_DepExp_2011'!O37-J37)","v":0}]
[1920,"Computer Equip.-Hardware(Post Mar. 22/04)",null,null,0,{"$f":"IF(D38=0,+'App.2-CB_MIFRS_DepExp_2011'!O38,+'App.2-CB_MIFRS_DepExp_2011'!O38+((C38*0.5)/D38))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I38+'App.2-CB_MIFRS_DepExp_2011'!O38-J38), 0, +I38+'App.2-CB_MIFRS_DepExp_2011'!O38-J38)","v":0}]
[1920,"Computer Equip.-Hardware(Post Mar. 19/07)",null,null,0,{"$f":"IF(D39=0,+'App.2-CB_MIFRS_DepExp_2011'!O39,+'App.2-CB_MIFRS_DepExp_2011'!O39+((C39*0.5)/D39))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I39+'App.2-CB_MIFRS_DepExp_2011'!O39-J39), 0, +I39+'App.2-CB_MIFRS_DepExp_2011'!O39-J39)","v":0}]
[1930,"Transportation Equipment",null,null,0,{"$f":"IF(D40=0,+'App.2-CB_MIFRS_DepExp_2011'!O40,+'App.2-CB_MIFRS_DepExp_2011'!O40+((C40*0.5)/D40))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I40+'App.2-CB_MIFRS_DepExp_2011'!O40-J40), 0, +I40+'App.2-CB_MIFRS_DepExp_2011'!O40-J40)","v":0}]
[1935,"Stores Equipment",null,null,0,{"$f":"IF(D41=0,+'App.2-CB_MIFRS_DepExp_2011'!O41,+'App.2-CB_MIFRS_DepExp_2011'!O41+((C41*0.5)/D41))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I41+'App.2-CB_MIFRS_DepExp_2011'!O41-J41), 0, +I41+'App.2-CB_MIFRS_DepExp_2011'!O41-J41)","v":0}]
[1940,"Tools, Shop & Garage Equipment",null,null,0,{"$f":"IF(D42=0,+'App.2-CB_MIFRS_DepExp_2011'!O42,+'App.2-CB_MIFRS_DepExp_2011'!O42+((C42*0.5)/D42))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I42+'App.2-CB_MIFRS_DepExp_2011'!O42-J42), 0, +I42+'App.2-CB_MIFRS_DepExp_2011'!O42-J42)","v":0}]
[1945,"Measurement & Testing Equipment",null,null,0,{"$f":"IF(D43=0,+'App.2-CB_MIFRS_DepExp_2011'!O43,+'App.2-CB_MIFRS_DepExp_2011'!O43+((C43*0.5)/D43))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I43+'App.2-CB_MIFRS_DepExp_2011'!O43-J43), 0, +I43+'App.2-CB_MIFRS_DepExp_2011'!O43-J43)","v":0}]
[1950,"Power Operated Equipment",null,null,0,{"$f":"IF(D44=0,+'App.2-CB_MIFRS_DepExp_2011'!O44,+'App.2-CB_MIFRS_DepExp_2011'!O44+((C44*0.5)/D44))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I44+'App.2-CB_MIFRS_DepExp_2011'!O44-J44), 0, +I44+'App.2-CB_MIFRS_DepExp_2011'!O44-J44)","v":0}]
[1955,"Communications Equipment",null,null,0,{"$f":"IF(D45=0,+'App.2-CB_MIFRS_DepExp_2011'!O45,+'App.2-CB_MIFRS_DepExp_2011'!O45+((C45*0.5)/D45))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I45+'App.2-CB_MIFRS_DepExp_2011'!O45-J45), 0, +I45+'App.2-CB_MIFRS_DepExp_2011'!O45-J45)","v":0}]
[1955,"Communication Equipment (Smart Meters)",null,null,0,{"$f":"IF(D46=0,+'App.2-CB_MIFRS_DepExp_2011'!O46,+'App.2-CB_MIFRS_DepExp_2011'!O46+((C46*0.5)/D46))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I46+'App.2-CB_MIFRS_DepExp_2011'!O46-J46), 0, +I46+'App.2-CB_MIFRS_DepExp_2011'!O46-J46)","v":0}]
[1960,"Miscellaneous Equipment ",null,null,0,{"$f":"IF(D47=0,+'App.2-CB_MIFRS_DepExp_2011'!O47,+'App.2-CB_MIFRS_DepExp_2011'!O47+((C47*0.5)/D47))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I47+'App.2-CB_MIFRS_DepExp_2011'!O47-J47), 0, +I47+'App.2-CB_MIFRS_DepExp_2011'!O47-J47)","v":0}]
[1975,"Load Management Controls Utility Premises",null,null,0,{"$f":"IF(D48=0,+'App.2-CB_MIFRS_DepExp_2011'!O48,+'App.2-CB_MIFRS_DepExp_2011'!O48+((C48*0.5)/D48))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I48+'App.2-CB_MIFRS_DepExp_2011'!O48-J48), 0, +I48+'App.2-CB_MIFRS_DepExp_2011'!O48-J48)","v":0}]
[1980,"System Supervisor Equipment",null,null,0,{"$f":"IF(D49=0,+'App.2-CB_MIFRS_DepExp_2011'!O49,+'App.2-CB_MIFRS_DepExp_2011'!O49+((C49*0.5)/D49))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I49+'App.2-CB_MIFRS_DepExp_2011'!O49-J49), 0, +I49+'App.2-CB_MIFRS_DepExp_2011'!O49-J49)","v":0}]
[1985,"Miscellaneous Fixed Assets",null,null,0,{"$f":"IF(D50=0,+'App.2-CB_MIFRS_DepExp_2011'!O50,+'App.2-CB_MIFRS_DepExp_2011'!O50+((C50*0.5)/D50))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I50+'App.2-CB_MIFRS_DepExp_2011'!O50-J50), 0, +I50+'App.2-CB_MIFRS_DepExp_2011'!O50-J50)","v":0}]
[1995,"Contributions & Grants",null,null,0,{"$f":"IF(D51=0,+'App.2-CB_MIFRS_DepExp_2011'!O51,+'App.2-CB_MIFRS_DepExp_2011'!O51+((C51*0.5)/D51))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I51+'App.2-CB_MIFRS_DepExp_2011'!O51-J51), 0, +I51+'App.2-CB_MIFRS_DepExp_2011'!O51-J51)","v":0}]
["etc.",null,null,null,0,{"$f":"IF(D52=0,+'App.2-CB_MIFRS_DepExp_2011'!O52,+'App.2-CB_MIFRS_DepExp_2011'!O52+((C52*0.5)/D52))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I52+'App.2-CB_MIFRS_DepExp_2011'!O52-J52), 0, +I52+'App.2-CB_MIFRS_DepExp_2011'!O52-J52)","v":0}]
[null,null,null,null,0,{"$f":"IF(D53=0,+'App.2-CB_MIFRS_DepExp_2011'!O53,+'App.2-CB_MIFRS_DepExp_2011'!O53+((C53*0.5)/D53))","v":0},null,0,0,null,{"$f":"IF(ISERROR(+I53+'App.2-CB_MIFRS_DepExp_2011'!O53-J53), 0, +I53+'App.2-CB_MIFRS_DepExp_2011'!O53-J53)","v":0}]
[null,"Total",{"$f":"SUM(C16:C53)","v":0},null,null,{"$f":"SUM(F16:F53)","v":0},0,0,0,0,0]
[]
["Notes:"]
[1,"Board policy of the \"half-year\" rule - the applicant must ensure that additions in the year attract a half-year depreciation expense in the first year.  Deviations from this standard practice must be supported in the application."]
[2,"The applicant must provide an explanation of material variances in evidence"]
[3,"This column refers to the calculated full year depreciation but excludes the depreciation expense on assets fully depreciated during the year.  This column is used for the purpose of calculating depreciation expense in the following year on the next worksheet."]
[]
["General:","Applicants must provide a breakdown of depreciation and amortization expense in the above format for all relevant accounts.  Asset Retirement Obligations (AROs), depreciation and accretion expense should be disclosed separately consistent with the Notes of historical Audited Financial Statements."]

{"sheet":"App.2-CD_MIFRS_DepExp_2013","index":3,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":true,"merged":[[59,1,59,9],[58,1,58,9],[55,1,55,4],[57,1,57,7],[60,1,61,7],[54,1,54,4],[13,1,14,1],[13,6,14,6],[8,0,8,9],[9,0,9,9],[10,0,10,9]]}
[null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-CD"]
["Depreciation and Amortization Expense"]
["Assumes the applicant adopted IFRS for financial reporting purposes January 1, 2012"]
[null,null,2013,"MIFRS"]
[]
["Account","Description","Additions","Years (new additions only)","Depreciation Rate on New Additions","2013 Depreciation Expense 1","2013 Depreciation Expense per Appendix 2-B Fixed Assets, Column K\n (l)","Variance 2"]
[null,null,"(d)","(f)","(g) = 1 / (f)","(h)=2012 Full Year Depreciation + ((d)*0.5)/(f) ",null,"(m) = (h) - (l)"]
[1611,"Computer Software (Formally known as Account 1925)",null,null,{"$f":"IF(D16=0,0,1/D16)","v":0},{"$f":"IF(D16=0,'App.2-CC_MIFRS_DepExp_2012'!K16,+'App.2-CC_MIFRS_DepExp_2012'!K16+((C16*0.5)/D16))","v":0},null,{"$f":"IF(ISERROR(+F16-G16), 0, +F16-G16)","v":0}]
[1612,"Land Rights (Formally known as Account 1906)",null,null,0,{"$f":"IF(D17=0,'App.2-CC_MIFRS_DepExp_2012'!K17,+'App.2-CC_MIFRS_DepExp_2012'!K17+((C17*0.5)/D17))","v":0},null,0]
[1805,"Land",null,null,0,{"$f":"IF(D18=0,'App.2-CC_MIFRS_DepExp_2012'!K18,+'App.2-CC_MIFRS_DepExp_2012'!K18+((C18*0.5)/D18))","v":0},null,0]
[1808,"Buildings",null,null,0,{"$f":"IF(D19=0,'App.2-CC_MIFRS_DepExp_2012'!K19,+'App.2-CC_MIFRS_DepExp_2012'!K19+((C19*0.5)/D19))","v":0},null,0]
[1810,"Leasehold Improvements",null,null,0,{"$f":"IF(D20=0,'App.2-CC_MIFRS_DepExp_2012'!K20,+'App.2-CC_MIFRS_DepExp_2012'!K20+((C20*0.5)/D20))","v":0},null,0]
[1815,"Transformer Station Equipment >50 kV",null,null,0,{"$f":"IF(D21=0,'App.2-CC_MIFRS_DepExp_2012'!K21,+'App.2-CC_MIFRS_DepExp_2012'!K21+((C21*0.5)/D21))","v":0},null,0]
[1820,"Distribution Station Equipment <50 kV",null,null,0,{"$f":"IF(D22=0,'App.2-CC_MIFRS_DepExp_2012'!K22,+'App.2-CC_MIFRS_DepExp_2012'!K22+((C22*0.5)/D22))","v":0},null,0]
[1825,"Storage Battery Equipment",null,null,0,{"$f":"IF(D23=0,'App.2-CC_MIFRS_DepExp_2012'!K23,+'App.2-CC_MIFRS_DepExp_2012'!K23+((C23*0.5)/D23))","v":0},null,0]
[1830,"Poles, Towers & Fixtures",null,null,0,{"$f":"IF(D24=0,'App.2-CC_MIFRS_DepExp_2012'!K24,+'App.2-CC_MIFRS_DepExp_2012'!K24+((C24*0.5)/D24))","v":0},null,0]
[1835,"Overhead Conductors & Devices",null,null,0,{"$f":"IF(D25=0,'App.2-CC_MIFRS_DepExp_2012'!K25,+'App.2-CC_MIFRS_DepExp_2012'!K25+((C25*0.5)/D25))","v":0},null,0]
[1840,"Underground Conduit",null,null,0,{"$f":"IF(D26=0,'App.2-CC_MIFRS_DepExp_2012'!K26,+'App.2-CC_MIFRS_DepExp_2012'!K26+((C26*0.5)/D26))","v":0},null,0]
[1845,"Underground Conductors & Devices",null,null,0,{"$f":"IF(D27=0,'App.2-CC_MIFRS_DepExp_2012'!K27,+'App.2-CC_MIFRS_DepExp_2012'!K27+((C27*0.5)/D27))","v":0},null,0]
[1850,"Line Transformers",null,null,0,{"$f":"IF(D28=0,'App.2-CC_MIFRS_DepExp_2012'!K28,+'App.2-CC_MIFRS_DepExp_2012'!K28+((C28*0.5)/D28))","v":0},null,0]
[1855,"Services (Overhead & Underground)",null,null,0,{"$f":"IF(D29=0,'App.2-CC_MIFRS_DepExp_2012'!K29,+'App.2-CC_MIFRS_DepExp_2012'!K29+((C29*0.5)/D29))","v":0},null,0]
[1860,"Meters",null,null,0,{"$f":"IF(D30=0,'App.2-CC_MIFRS_DepExp_2012'!K30,+'App.2-CC_MIFRS_DepExp_2012'!K30+((C30*0.5)/D30))","v":0},null,0]
[1860,"Meters (Smart Meters)",null,null,0,{"$f":"IF(D31=0,'App.2-CC_MIFRS_DepExp_2012'!K31,+'App.2-CC_MIFRS_DepExp_2012'!K31+((C31*0.5)/D31))","v":0},null,0]
[1905,"Land",null,null,0,{"$f":"IF(D32=0,'App.2-CC_MIFRS_DepExp_2012'!K32,+'App.2-CC_MIFRS_DepExp_2012'!K32+((C32*0.5)/D32))","v":0},null,0]
[1908,"Buildings & Fixtures",null,null,0,{"$f":"IF(D33=0,'App.2-CC_MIFRS_DepExp_2012'!K33,+'App.2-CC_MIFRS_DepExp_2012'!K33+((C33*0.5)/D33))","v":0},null,0]
[1910,"Leasehold Improvements",null,null,0,{"$f":"IF(D34=0,'App.2-CC_MIFRS_DepExp_2012'!K34,+'App.2-CC_MIFRS_DepExp_2012'!K34+((C34*0.5)/D34))","v":0},null,0]
[1915,"Office Furniture & Equipment (10 years)",null,null,0,{"$f":"IF(D35=0,'App.2-CC_MIFRS_DepExp_2012'!K35,+'App.2-CC_MIFRS_DepExp_2012'!K35+((C35*0.5)/D35))","v":0},null,0]
[1915,"Office Furniture & Equipment (5 years)",null,null,0,{"$f":"IF(D36=0,'App.2-CC_MIFRS_DepExp_2012'!K36,+'App.2-CC_MIFRS_DepExp_2012'!K36+((C36*0.5)/D36))","v":0},null,0]
[1920,"Computer Equipment - Hardware",null,null,0,{"$f":"IF(D37=0,'App.2-CC_MIFRS_DepExp_2012'!K37,+'App.2-CC_MIFRS_DepExp_2012'!K37+((C37*0.5)/D37))","v":0},null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 22/04)",null,null,0,{"$f":"IF(D38=0,'App.2-CC_MIFRS_DepExp_2012'!K38,+'App.2-CC_MIFRS_DepExp_2012'!K38+((C38*0.5)/D38))","v":0},null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 19/07)",null,null,0,{"$f":"IF(D39=0,'App.2-CC_MIFRS_DepExp_2012'!K39,+'App.2-CC_MIFRS_DepExp_2012'!K39+((C39*0.5)/D39))","v":0},null,0]
[1930,"Transportation Equipment",null,null,0,{"$f":"IF(D40=0,'App.2-CC_MIFRS_DepExp_2012'!K40,+'App.2-CC_MIFRS_DepExp_2012'!K40+((C40*0.5)/D40))","v":0},null,0]
[1935,"Stores Equipment",null,null,0,{"$f":"IF(D41=0,'App.2-CC_MIFRS_DepExp_2012'!K41,+'App.2-CC_MIFRS_DepExp_2012'!K41+((C41*0.5)/D41))","v":0},null,0]
[1940,"Tools, Shop & Garage Equipment",null,null,0,{"$f":"IF(D42=0,'App.2-CC_MIFRS_DepExp_2012'!K42,+'App.2-CC_MIFRS_DepExp_2012'!K42+((C42*0.5)/D42))","v":0},null,0]
[1945,"Measurement & Testing Equipment",null,null,0,{"$f":"IF(D43=0,'App.2-CC_MIFRS_DepExp_2012'!K43,+'App.2-CC_MIFRS_DepExp_2012'!K43+((C43*0.5)/D43))","v":0},null,0]
[1950,"Power Operated Equipment",null,null,0,{"$f":"IF(D44=0,'App.2-CC_MIFRS_DepExp_2012'!K44,+'App.2-CC_MIFRS_DepExp_2012'!K44+((C44*0.5)/D44))","v":0},null,0]
[1955,"Communications Equipment",null,null,0,{"$f":"IF(D45=0,'App.2-CC_MIFRS_DepExp_2012'!K45,+'App.2-CC_MIFRS_DepExp_2012'!K45+((C45*0.5)/D45))","v":0},null,0]
[1955,"Communication Equipment (Smart Meters)",null,null,0,{"$f":"IF(D46=0,'App.2-CC_MIFRS_DepExp_2012'!K46,+'App.2-CC_MIFRS_DepExp_2012'!K46+((C46*0.5)/D46))","v":0},null,0]
[1960,"Miscellaneous Equipment ",null,null,0,{"$f":"IF(D47=0,'App.2-CC_MIFRS_DepExp_2012'!K47,+'App.2-CC_MIFRS_DepExp_2012'!K47+((C47*0.5)/D47))","v":0},null,0]
[1975,"Load Management Controls Utility Premises",null,null,0,{"$f":"IF(D48=0,'App.2-CC_MIFRS_DepExp_2012'!K48,+'App.2-CC_MIFRS_DepExp_2012'!K48+((C48*0.5)/D48))","v":0},null,0]
[1980,"System Supervisor Equipment",null,null,0,{"$f":"IF(D49=0,'App.2-CC_MIFRS_DepExp_2012'!K49,+'App.2-CC_MIFRS_DepExp_2012'!K49+((C49*0.5)/D49))","v":0},null,0]
[1985,"Miscellaneous Fixed Assets",null,null,0,{"$f":"IF(D50=0,'App.2-CC_MIFRS_DepExp_2012'!K50,+'App.2-CC_MIFRS_DepExp_2012'!K50+((C50*0.5)/D50))","v":0},null,0]
[1995,"Contributions & Grants",null,null,0,{"$f":"IF(D51=0,'App.2-CC_MIFRS_DepExp_2012'!K51,+'App.2-CC_MIFRS_DepExp_2012'!K51+((C51*0.5)/D51))","v":0},null,0]
["etc.",null,null,null,0,{"$f":"IF(D52=0,'App.2-CC_MIFRS_DepExp_2012'!K52,+'App.2-CC_MIFRS_DepExp_2012'!K52+((C52*0.5)/D52))","v":0},null,0]
[null,null,null,null,0,{"$f":"IF(D53=0,'App.2-CC_MIFRS_DepExp_2012'!K53,+'App.2-CC_MIFRS_DepExp_2012'!K53+((C53*0.5)/D53))","v":0},null,0]
[null,"Total",{"$f":"SUM(C16:C53)","v":0},null,null,{"$f":"SUM(F16:F53)","v":0},{"$f":"SUM(G16:G53)","v":0},{"$f":"SUM(H16:H53)","v":0}]
[null,"Depreciation expense adjustment resulting from  amortization of Account 1575",null,null,null,0]
[null,"Total Depreciation expense to be included in the test year revenue requirement",null,null,null,{"$f":"+F54+F55","v":0}]
["Notes:"]
[1,"Board policy of the \"half-year\" rule - the applicant must ensure that additions in the year attract a half-year depreciation expense in the first year.  Deviations from this standard practice must be supported in the application."]
[2,"The applicant must provide an explanation of material variances in evidence"]
[]
["General:","Applicants must provide a breakdown of depreciation and amortization expense in the above format for all relevant accounts.  Asset Retirement Obligations (AROs), depreciation and accretion expense should be disclosed separately consistent with the Notes of historical Audited Financial Statements."]

{"sheet":"App.2-CI_AltAccStd_DepExp","index":4,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":true,"merged":[[58,1,58,11],[57,1,57,11],[61,1,62,11],[10,0,10,11],[9,0,9,11],[8,0,8,11],[11,4,11,5],[13,0,14,0],[13,1,14,1],[13,10,14,10]]}
[null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-CI"]
["Depreciation and Amortization Expense"]
["Assumes the applicant adopted an alternate accounting standard other than IFRS for financial reporting purposes.  For applicants adopting an Alternate Accounting Standard for financial reporting purposes January 1, 2012, applicants must complete 4 versions of the table below (2011 CGAAP, 2011 Alternate Accounting Standard, 2012 Alternate Accounting Standard and 2013 Alternate Accounting Standard).  For applicants adopting an Alternate Accounting Standard for financial reporting purposes January 1, 2013, applicants must complete 4 versions of the table below (2011 CGAAP, 2012 CGAAP, 2012 Alternate Accounting Standard and 2013 Alternate Accounting Standard)."]
[null,"Year",null,null,"Accounting Standard"]
[]
["Account","Description","Opening\nRegulatory Gross PP&E","Less Fully Depreciated","Net for Depreciation","Additions","Total for Depreciation","Years","Depreciation Rate","Depreciation Expense","Depreciation Expense per Appendix 2-B Fixed Assets, Column K\n (l)","Variance 2"]
[null,null,"(a)","(b)","(c)","(d)","(e) = (c) + ½ x (d) 1","(f)","(g) = 1 / (f)","(h) = (e) / (f)",null,"(m) = (h) - (l)"]
[1611,"Computer Software (Formally known as Account 1925)",null,null,{"$f":"C16-D16","v":0},null,{"$f":"E16+0.5*F16","v":0},null,{"$f":"IF(H16=0,0,1/H16)","v":0},{"$f":"IF(H16=0,0,G16/H16)","v":0},null,{"$f":"IF(ISERROR(+J16-K16), 0, +J16-K16)","v":0}]
[1612,"Land Rights (Formally known as Account 1906)",null,null,{"$f":"C17-D17","v":0},null,{"$f":"E17+0.5*F17","v":0},null,0,0,null,0]
[1805,"Land",null,null,0,null,0,null,0,0,null,0]
[1808,"Buildings",null,null,0,null,0,null,0,0,null,0]
[1810,"Leasehold Improvements",null,null,0,null,0,null,0,0,null,0]
[1815,"Transformer Station Equipment >50 kV",null,null,0,null,0,null,0,0,null,0]
[1820,"Distribution Station Equipment <50 kV",null,null,0,null,0,null,0,0,null,0]
[1825,"Storage Battery Equipment",null,null,0,null,0,null,0,0,null,0]
[1830,"Poles, Towers & Fixtures",null,null,0,null,0,null,0,0,null,0]
[1835,"Overhead Conductors & Devices",null,null,0,null,0,null,0,0,null,0]
[1840,"Underground Conduit",null,null,0,null,0,null,0,0,null,0]
[1845,"Underground Conductors & Devices",null,null,0,null,0,null,0,0,null,0]
[1850,"Line Transformers",null,null,0,null,0,null,0,0,null,0]
[1855,"Services (Overhead & Underground)",null,null,0,null,0,null,0,0,null,0]
[1860,"Meters",null,null,0,null,0,null,0,0,null,0]
[1860,"Meters (Smart Meters)",null,null,0,null,0,null,0,0,null,0]
[1905,"Land",null,null,0,null,0,null,0,0,null,0]
[1908,"Buildings & Fixtures",null,null,0,null,0,null,0,0,null,0]
[1910,"Leasehold Improvements",null,null,0,null,0,null,0,0,null,0]
[1915,"Office Furniture & Equipment (10 years)",null,null,0,null,0,null,0,0,null,0]
[1915,"Office Furniture & Equipment (5 years)",null,null,0,null,0,null,0,0,null,0]
[1920,"Computer Equipment - Hardware",null,null,0,null,0,null,0,0,null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 22/04)",null,null,0,null,0,null,0,0,null,0]
[1920,"Computer Equip.-Hardware(Post Mar. 19/07)",null,null,0,null,0,null,0,0,null,0]
[1930,"Transportation Equipment",null,null,0,null,0,null,0,0,null,0]
[1935,"Stores Equipment",null,null,0,null,0,null,0,0,null,0]
[1940,"Tools, Shop & Garage Equipment",null,null,0,null,0,null,0,0,null,0]
[1945,"Measurement & Testing Equipment",null,null,0,null,0,null,0,0,null,0]
[1950,"Power Operated Equipment",null,null,0,null,0,null,0,0,null,0]
[1955,"Communications Equipment",null,null,0,null,0,null,0,0,null,0]
[1955,"Communication Equipment (Smart Meters)",null,null,0,null,0,null,0,0,null,0]
[1960,"Miscellaneous Equipment ",null,null,0,null,0,null,0,0,null,0]
[1975,"Load Management Controls Utility Premises",null,null,0,null,0,null,0,0,null,0]
[1980,"System Supervisor Equipment",null,null,0,null,0,null,0,0,null,0]
[1985,"Miscellaneous Fixed Assets",null,null,0,null,0,null,0,0,null,0]
[1995,"Contributions & Grants",null,null,0,null,0,null,0,0,null,0]
["etc.",null,null,null,0,null,0,null,0,0,null,0]
[null,null,null,null,0,null,0,null,0,0,null,0]
[null,"Total",{"$f":"SUM(C16:C53)","v":0},{"$f":"SUM(D16:D53)","v":0},{"$f":"SUM(E16:E53)","v":0},0,0,null,null,{"$f":"SUM(J16:J53)","v":0},{"$f":"SUM(K16:K53)","v":0},{"$f":"SUM(L16:L53)","v":0}]
[]
["Notes:"]
[]
[1,"Board policy of the \"half-year\" rule - the applicant must ensure that additions in the year attract a half-year depreciation expense in the first year.  Deviations from this standard practice must be supported in the application."]
[2,"The applicant must provide an explanation of material variances in evidence"]
[]
[]
["General:","Applicants must provide a breakdown of depreciation and amortization expense in the above format for all relevant accounts.  Asset Retirement Obligations (AROs), depreciation and accretion expense should be disclosed separately consistent with the Notes of historical Audited Financial Statements."]

{"sheet":"App.2-EA_PP&E Deferral Account","index":5,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":true,"merged":[[8,0,8,8],[9,0,9,8],[10,0,10,8],[14,0,14,8],[12,0,12,8],[54,0,55,8],[33,1,34,2],[25,1,26,2],[20,1,20,8],[19,1,19,2],[19,5,19,8],[25,5,26,8],[31,5,31,8],[31,1,31,2]]}
[null,null,null,null,null,null,null,"File Number:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,"Date:"]
[]
["Appendix 2-EA"]
["IFRS-CGAAP Transitional PP&E Amounts"]
["2012 Adopters of IFRS for Financial Reporting Purposes"]
[]
["For applicants that adopt IFRS on January 1, 2012 for financial reporting purposes"]
[]
["Note: this sheet should be filled out if the applicant adopts IFRS for its financial reporting purpose as of January 1, 2012. "]
[]
[null,"2009 Rebasing Year",2010,2011,2012,"2013 Rebasing Year",2014,2015,2016]
["Reporting Basis","CGAAP","IRM","IRM","IRM","MIFRS","IRM","IRM","IRM"]
["Forecast vs. Actual Used in Rebasing Year","Forecast","Actual","Actual","Forecast","Forecast"]
[null,null,null,"$","$"]
["PP&E Values under CGAAP"]
["            Opening net PP&E - Note 1"]
["            Additions"]
["            Depreciation (amounts should be negative)"]
["            Closing net PP&E (1)",null,null,{"$f":"D22+D23+D24","v":0},{"$f":"E22+E23+E24","v":0}]
[]
["PP&E Values under MIFRS (Starts from 2011, the transition year)"]
["            Opening net PP&E  - Note 1"]
["            Additions"]
["            Depreciation (amounts should be negative)"]
["            Closing net PP&E (2)",null,null,{"$f":"SUM(D28:D30)","v":0},{"$f":"SUM(E28:E30)","v":0}]
[]
["Difference in Closing net PP&E, CGAAP vs. MIFRS (Shown as adjustment to rate base on rebasing)",null,null,{"$f":"D25-D31","v":0},{"$f":"E25-E31","v":0}]
[]
["Account 1575 - IFRS-CGAAP Transitional PP&E Amounts"]
["Opening balance ",null,null,0,{"$f":"D40","v":0},{"$f":"E40","v":0},{"$f":"F40","v":0},{"$f":"G40","v":0},{"$f":"H40","v":0}]
["Amounts added in the year",null,null,{"$f":"D33","v":0},{"$f":"E33-D33","v":0}]
["Sub-total",null,null,{"$f":"D36+D37","v":0},0,0,0,0,0]
["Amount of amortization, included in  depreciation expense  - Note 2",null,null,null,null,{"$f":"IF(ISERROR(-E33/I44), 0, -E33/I44)","v":0},{"$f":"+F39","v":0},{"$f":"+F39","v":0},{"$f":"+F39","v":0}]
["          Closing balance in deferral account",null,null,{"$f":"D38+D39","v":0},0,{"$f":"IF(ISERROR(F38+F39), 0, F38+F39)","v":0},0,0,0]
[]
["Effect on Revenue Requirement"]
["Amortization of deferred balance as above - Note 2",null,null,null,null,{"$f":"IF(ISERROR(E33/I44), 0, E33/I44)","v":0},null,"WACC"]
["Return on Rate Base Associated with deferred PP&E balance at WACC  - Note 3 ",null,null,null,null,{"$f":"E33*I43","v":0},null,"Disposition Period - Note 4",4,"Years"]
["     Amount included in Revenue Requirement on rebasing",null,null,null,null,{"$f":"F43+F44","v":0}]
[]
["Notes:"]
["1  For an applicant that adopts IFRS on January 1, 2012, the PP&E values as of January 1, 2011 under both CGAAP and MIFRS should be the same. "]
["2  Amortization of the deferred balance in Account 1575 will start from the rebasing year. "]
["    Assume the utility requests for a certain disposition period, the amortization that should be included in the depreciation expense is calculated as:"]
["   the opening balance of Account 1575 / the approved disposition period"]
["3  Return on rate base associated with deferred balance is calculated as:"]
["     the deferred account opening balance as of 2013 rebasing year x WACC"]
["     * Please note that the calculation should be adjusted once WACC is updated and finalized in the rate application."]
["4  Consistent with the 4 year normal rate cycle, the model is using a 4 year amortization period as a default selection to \"clear\" the PP&E deferral account through a one-time adjustment to ratebase to capture and remove the impact of the accounting policy changes as caused by the transition from CGAAP to MIFRS."]

{"sheet":"App.2-W_Bill Impacts_RES800","index":6,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14],[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"'[2]LDC Info'!$E$18","v":"EB2012-0176"},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Residential"]
[]
[null,null,null,"Consumption",null,800," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"per kWh",null,11.34,1,{"$f":"G21*F21","v":11.34},null,13.24,1,{"$f":"K21*J21","v":13.24},null,{"$f":"L21-H21","v":1.9000000000000004},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":0.16754850088183426}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G22*F22","v":0},null,null,1,{"$f":"K22*J22","v":0},null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"SMDR",null,"Monthly",null,null,1,0,null,0.19,1,{"$f":"K23*J23","v":0.19},null,{"$f":"L23-H23","v":0.19},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,0.67,1,0.67,null,0.67,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,1.4200000000000001E-2,{"$f":"$F$16","v":800},11.360000000000001,null,1.66E-2,{"$f":"$F$16","v":800},13.28,null,1.9199999999999982,0.16901408450704208]
[null,"Smart Meter Disposition Rider",null,null,null,null,{"$f":"$F$16","v":800},0,null,null,{"$f":"$F$16","v":800},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,6.9999999999999999E-4,{"$f":"$F$16","v":800},0.55999999999999994,null,null,800,0,null,-0.55999999999999994,-1]
[null,"Rate Rider for Tax Adjustments",null,"per kWh",null,-2.9999999999999997E-4,{"$f":"$F$16","v":800},-0.24,null,null,800,0,null,0.24,-1]
[null,null,null,"per kWh",null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":23.020000000000003},null,null,null,{"$f":"SUM(L21:L36)","v":27.38},null,4.3599999999999959,0.1894005212858382]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,-1.5E-3,{"$f":"$F$16","v":800},{"$f":"G38*F38","v":-1.2},null,2.5999999999999999E-3,{"$f":"$F$16","v":800},{"$f":"K38*J38","v":2.08},null,{"$f":"L38-H38","v":3.2800000000000002},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-2.7333333333333338}]
[null,null,null,null,null,null,{"$f":"$F$16","v":800},{"$f":"G39*F39","v":0},null,null,{"$f":"$F$16","v":800},{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,null,null,null,null,null,800,0,null,null,800,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,1.1999999999999999E-3,800,{"$f":"G42*F42","v":0.96},null,1.6999999999999999E-3,800,{"$f":"K42*J42","v":1.3599999999999999},null,{"$f":"L42-H42","v":0.39999999999999991},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":0.41666666666666657}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,800,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":22.780000000000005},null,null,null,{"$f":"SUM(L38:L42)+L37","v":30.82},null,{"$f":"L44-H44","v":8.0399999999999956},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":0.35294117647058798}]
[null,"RTSR - Network",null,"per kWh",null,5.1999999999999998E-3,{"$f":"F16*(1+F71)","v":863.04},{"$f":"G45*F45","v":4.4878079999999994},null,5.8999999999999999E-3,{"$f":"F16*(1+J71)","v":856},{"$f":"K45*J45","v":5.0503999999999998},null,0.56259200000000043,0.12536008670602675]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,1.9E-3,{"$f":"G45","v":863.04},{"$f":"G46*F46","v":1.6397759999999999},null,2.0999999999999999E-3,{"$f":"K45","v":856},{"$f":"K46*J46","v":1.7975999999999999},null,0.15782399999999996,9.6247292313096408E-2]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":28.907584000000003},null,null,null,{"$f":"SUM(L44:L46)","v":37.668000000000006},null,8.7604160000000029,0.30304905453184888]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"G46","v":863.04},{"$f":"G48*F48","v":4.4878079999999994},null,5.1999999999999998E-3,{"$f":"K46","v":856},{"$f":"K48*J48","v":4.4512},null,-3.6607999999999308E-2,-8.1572117167221306E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"G46","v":863.04},0.94934399999999997,null,1.1000000000000001E-3,{"$f":"K46","v":856},0.9416000000000001,null,-7.7439999999998621E-3,-8.1572117167221393E-3]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,6.9999999999999999E-4,{"$f":"G49","v":863.04},0.604128,null,6.9999999999999999E-4,{"$f":"K49","v":856},0.59919999999999995,null,-4.9280000000000435E-3,-8.1572117167223561E-3]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":600},{"$f":"G52*F52","v":45},null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$J$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$J$71),$F$16-1000))))","v":600},{"$f":"K52*J52","v":45},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":263.03999999999996},{"$f":"G53*F53","v":23.147519999999997},null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$J$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$J$71)-1000,IF($F$16<1000,0))))","v":256},{"$f":"K53*J53","v":22.527999999999999},null,-0.61951999999999785,-2.6763990267639814E-2]
[null,"TOU - Off Peak",null,"per kWh",null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":552.34559999999999},35.902464000000002,null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$J$71)","v":547.84},35.6096,null,-0.29286400000000157,-8.1572117167223266E-3]
[null,"TOU - Mid Peak",null,"per kWh",null,0.1,{"$f":"0.18*$F$16*(1+$F$71)","v":155.34719999999999},15.53472,null,0.1,{"$f":"0.18*$F$16*(1+$J$71)","v":154.08000000000001},15.408000000000001,null,-0.12671999999999883,-8.1572117167222086E-3]
[null,"TOU - On Peak",null,"per kWh",null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$F$71)","v":155.34719999999999},18.175622399999998,null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$J$71)","v":154.08000000000001},18.027360000000002,null,-0.14826239999999657,-8.1572117167220959E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":103.346384},null,null,null,{"$f":"SUM(L47:L53)","v":111.43800000000002},null,8.0916160000000161,7.8296072748902532E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":13.43502992},null,0.13,null,{"$f":"L58*J59","v":14.486940000000002},null,1.0519100800000025,7.8296072748902559E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":116.78141392000001},null,null,null,{"$f":"L58+L59","v":125.92494000000002},null,9.1435260800000151,7.829607274890249E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-11.68},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-12.59},null,-0.91000000000000014,7.7910958904109609E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":105.10141392},null,null,null,{"$f":"SUM(L60:L61)","v":113.33494000000002},null,8.2335260800000185,7.8338870743138889E-2]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":104.81167039999998},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":112.95496000000001},null,{"$f":"L64-H64","v":8.1432896000000312},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":7.7694493074313531E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":13.625517151999999},null,0.13,null,{"$f":"L64*J65","v":14.684144800000002},null,1.0586276480000034,7.7694493074313475E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":118.43718755199998},null,null,null,{"$f":"L64+L65","v":127.63910480000001},null,9.2019172480000293,7.7694493074313475E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-11.84},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-12.76},null,-0.91999999999999993,7.77027027027027E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":106.59718755199998},null,null,null,{"$f":"L66+L67","v":114.87910480000001},null,8.2819172480000276,7.7693581211605259E-2]
[]
[]
[null,"Loss Factor (%)",null,null,null,7.8799999999999995E-2,null,null,null,7.0000000000000007E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts_GS<50","index":7,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14],[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"'[2]LDC Info'!$E$18","v":"EB2012-0176"},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"GS<50"]
[]
[null,null,null,"Consumption",null,2000," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"per kWh",null,20.77,1,{"$f":"G21*F21","v":20.77},null,20.77,1,{"$f":"K21*J21","v":20.77},null,{"$f":"L21-H21","v":0},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":0}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G22*F22","v":0},null,null,1,0,null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"SMDR",null,"Monthly",null,null,1,0,null,2.06,1,2.06,null,{"$f":"L23-H23","v":2.06},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,4.16,1,4.16,null,4.16,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,9.1999999999999998E-3,{"$f":"$F$16","v":2000},18.399999999999999,null,1.1299999999999999E-2,{"$f":"$F$16","v":2000},22.599999999999998,null,4.1999999999999993,0.22826086956521738]
[null,"Smart Meter Disposition Rider",null,null,null,null,{"$f":"$F$16","v":2000},0,null,null,{"$f":"$F$16","v":2000},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,2.0000000000000001E-4,{"$f":"$F$16","v":2000},0.4,null,null,2000,0,null,-0.4,-1]
[null,"Rate Rider for Tax Adjustments",null,"per kWh",null,-2.0000000000000001E-4,{"$f":"$F$16","v":2000},-0.4,null,null,2000,0,null,0.4,-1]
[null,null,null,"per kWh",null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":39.17},null,null,null,{"$f":"SUM(L21:L36)","v":49.589999999999996},null,10.419999999999995,0.26601991319887652]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,-1.5E-3,{"$f":"$F$16","v":2000},{"$f":"G38*F38","v":-3},null,2.5999999999999999E-3,{"$f":"$F$16","v":2000},{"$f":"K38*J38","v":5.2},null,{"$f":"L38-H38","v":8.1999999999999993},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-2.7333333333333329}]
[null,null,null,null,null,null,{"$f":"$F$16","v":2000},{"$f":"G39*F39","v":0},null,null,{"$f":"$F$16","v":2000},{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,null,null,null,null,null,2000,0,null,null,2000,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,1.1000000000000001E-3,2000,{"$f":"G42*F42","v":2.2000000000000002},null,1.5E-3,2000,{"$f":"K42*J42","v":3},null,{"$f":"L42-H42","v":0.79999999999999982},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":0.36363636363636354}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,2000,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":38.370000000000005},null,null,null,{"$f":"SUM(L38:L42)+L37","v":57.789999999999992},null,{"$f":"L44-H44","v":19.419999999999987},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":0.50612457649205067}]
[null,"RTSR - Network",null,"per kWh",null,4.7999999999999996E-3,{"$f":"F16*(1+F71)","v":2157.6},{"$f":"G45*F45","v":10.356479999999999},null,5.4000000000000003E-3,{"$f":"F16*(1+J71)","v":2140},{"$f":"K45*J45","v":11.556000000000001},null,1.1995200000000015,0.11582313681868758]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,1.6999999999999999E-3,{"$f":"G45","v":2157.6},{"$f":"G46*F46","v":3.6679199999999996},null,1.9E-3,{"$f":"K45","v":2140},{"$f":"K46*J46","v":4.0659999999999998},null,0.39808000000000021,0.10853017514013398]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":52.394400000000005},null,null,null,{"$f":"SUM(L44:L46)","v":73.411999999999992},null,21.017599999999987,0.40114210679003837]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"G46","v":2157.6},{"$f":"G48*F48","v":11.219519999999999},null,5.1999999999999998E-3,{"$f":"K46","v":2140},{"$f":"K48*J48","v":11.128},null,-9.1519999999999158E-2,-8.1572117167222086E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"G46","v":2157.6},2.3733599999999999,null,1.1000000000000001E-3,{"$f":"K46","v":2140},2.3540000000000001,null,-1.9359999999999822E-2,-8.1572117167222086E-3]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,6.9999999999999999E-4,{"$f":"G49","v":2157.6},1.5103199999999999,null,6.9999999999999999E-4,{"$f":"K49","v":2140},1.498,null,-1.2319999999999887E-2,-8.1572117167222104E-3]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":600},{"$f":"G52*F52","v":45},null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$J$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$J$71),$F$16-1000))))","v":600},{"$f":"K52*J52","v":45},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":1557.6},{"$f":"G53*F53","v":137.06879999999998},null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$J$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$J$71)-1000,IF($F$16<1000,0))))","v":1540},{"$f":"K53*J53","v":135.51999999999998},null,-1.5488,-1.1299435028248589E-2]
[null,"TOU - Off Peak",null,"per kWh",null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":1380.864},89.756160000000008,null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$J$71)","v":1369.6000000000001},89.024000000000015,null,-0.73215999999999326,-8.1572117167222086E-3]
[null,"TOU - Mid Peak",null,"per kWh",null,0.1,{"$f":"0.18*$F$16*(1+$F$71)","v":388.36799999999999},38.836800000000004,null,0.1,{"$f":"0.18*$F$16*(1+$J$71)","v":385.20000000000005},38.52000000000001,null,-0.31679999999999353,-8.1572117167221167E-3]
[null,"TOU - On Peak",null,"per kWh",null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$F$71)","v":388.36799999999999},45.439056000000001,null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$J$71)","v":385.20000000000005},45.068400000000011,null,-0.37065599999998966,-8.157211716722056E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":249.81639999999999},null,null,null,{"$f":"SUM(L47:L53)","v":269.16199999999998},null,19.34559999999999,7.7439271400916804E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":32.476132},null,0.13,null,{"$f":"L58*J59","v":34.991059999999997},null,2.5149279999999976,7.7439271400916762E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":282.29253199999999},null,null,null,{"$f":"L58+L59","v":304.15305999999998},null,21.860527999999988,7.743927140091679E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-28.23},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-30.42},null,-2.1900000000000013,7.7577045696068062E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":254.062532},null,null,null,{"$f":"SUM(L60:L61)","v":273.73305999999997},null,19.670527999999962,7.7423962695923859E-2]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":241.779616},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":261.25440000000003},null,{"$f":"L64-H64","v":19.474784000000028},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":8.0547667012590626E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":31.431350080000001},null,0.13,null,{"$f":"L64*J65","v":33.963072000000004},null,2.5317219200000025,8.0547667012590585E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":273.21096607999999},null,null,null,{"$f":"L64+L65","v":295.21747200000004},null,22.006505920000052,8.0547667012590696E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-27.32},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-29.52},null,-2.1999999999999993,8.0527086383601731E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":245.89096608},null,null,null,{"$f":"L66+L67","v":265.69747200000006},null,19.806505920000063,8.0549953647162734E-2]
[]
[]
[null,"Loss Factor (%)",null,null,null,7.8799999999999995E-2,null,null,null,7.0000000000000007E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts_GS>50","index":8,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"'[2]LDC Info'!$E$18","v":"EB2012-0176"},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"GS 50 to 4,999 kW"]
[]
[null,null,null,"Consumption",null,50000," kWh"]
[null,null,null,null,null,140,"KW"]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,240.15,1,{"$f":"G21*F21","v":240.15},null,205.17,{"$f":"+G21","v":1},{"$f":"K21*J21","v":205.17},null,{"$f":"L21-H21","v":-34.980000000000018},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":-0.14565896314803256}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G22*F22","v":0},null,null,{"$f":"+G22","v":1},0,null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"SMDR",null,"Monthly",null,null,1,0,null,1.53,1,1.53,null,{"$f":"L23-H23","v":1.53},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,2.2372999999999998,{"$f":"+$F$17","v":140},313.22199999999998,null,1.9398,140,271.572,null,-41.649999999999977,-0.13297277968980462]
[null,"Smart Meter Disposition Rider",null,null,null,null,{"$f":"+$F$17","v":140},0,null,null,140,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,2.4400000000000002E-2,140,3.4160000000000004,null,null,140,0,null,-3.4160000000000004,-1]
[null,"Rate Rider for Tax Adjustments",null,"per kW",null,-3.7100000000000001E-2,140,-5.194,null,null,140,0,null,5.194,-1]
[null,null,null,"per kWh",null,null,140,0,null,null,140,0,null,0,""]
[null,null,null,null,null,null,140,0,null,null,140,0,null,0,""]
[null,null,null,null,null,null,140,0,null,null,140,0,null,0,""]
[null,null,null,null,null,null,140,0,null,null,140,0,null,0,""]
[null,null,null,null,null,null,140,0,null,null,140,0,null,0,""]
[null,null,null,null,null,null,140,0,null,null,140,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":551.59400000000005},null,null,null,{"$f":"SUM(L21:L36)","v":478.27199999999999},null,-73.32200000000006,-0.1329274792691727]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,-0.57699999999999996,{"$f":"+$F$17","v":140},{"$f":"G38*F38","v":-80.78},null,0.90590000000000004,140,{"$f":"K38*J38","v":126.82600000000001},null,{"$f":"L38-H38","v":207.60599999999999},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-2.5700173310225303}]
[null,"Global Adjustment Rate Rider",null,"per kW",null,-0.1048,{"$f":"+$F$17","v":140},{"$f":"G39*F39","v":-14.672000000000001},null,0.59840000000000004,140,{"$f":"K39*J39","v":83.77600000000001},null,{"$f":"L39-H39","v":98.448000000000008},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":-6.7099236641221376}]
[null,null,null,null,null,null,{"$f":"+$F$17","v":140},0,null,null,140,0,null,0,""]
[null,null,null,null,null,null,{"$f":"+$F$17","v":140},0,null,null,140,0,null,0,""]
[null,"Low Voltage Service Charge",null,"per kW",null,0.39900000000000002,{"$f":"+$F$17","v":140},{"$f":"G42*F42","v":55.86},null,0.56969999999999998,140,{"$f":"K42*J42","v":79.757999999999996},null,{"$f":"L42-H42","v":23.897999999999996},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":0.42781954887218038}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":512.00200000000007},null,null,null,{"$f":"SUM(L38:L42)+L37","v":768.63200000000006},null,{"$f":"L44-H44","v":256.63},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":0.50122851082612951}]
[null,"RTSR - Network",null,"per kW",null,1.9886999999999999,{"$f":"+$F$17","v":140},{"$f":"G45*F45","v":278.41800000000001},null,2.2486999999999999,140,{"$f":"K45*J45","v":314.81799999999998},null,36.399999999999977,0.13073867350530488]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,0.69289999999999996,{"$f":"G45","v":140},{"$f":"G46*F46","v":97.006},null,0.77659999999999996,140,{"$f":"K46*J46","v":108.72399999999999},null,11.717999999999989,0.12079665175349967]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":887.42600000000004},null,null,null,{"$f":"SUM(L44:L46)","v":1192.174},null,304.74799999999993,0.34340666151318522]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"+$F$16","v":50000},{"$f":"G48*F48","v":260},null,5.1999999999999998E-3,50000,{"$f":"K48*J48","v":260},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"+$F$16","v":50000},55,null,1.1000000000000001E-3,50000,55,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,6.9999999999999999E-4,{"$f":"G49","v":50000},35,null,6.9999999999999999E-4,50000,35,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":600},{"$f":"G52*F52","v":45},null,7.4999999999999997E-2,600,{"$f":"K52*J52","v":45},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":53340},{"$f":"G53*F53","v":4693.92},null,8.7999999999999995E-2,53340,{"$f":"K53*J53","v":4693.92},null,0,0]
[null,"TOU - Off Peak",null,"per kWh",null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":34521.599999999999},2243.904,null,6.5000000000000002E-2,34521.599999999999,2243.904,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.1,{"$f":"0.18*$F$16*(1+$F$71)","v":9709.2000000000007},970.92000000000007,null,0.1,9709.2000000000007,970.92000000000007,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$F$71)","v":9709.2000000000007},1135.9764000000002,null,0.11700000000000001,9709.2000000000007,1135.9764000000002,null,0,0]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":5976.5959999999995},null,null,null,{"$f":"SUM(L47:L53)","v":6281.3440000000001},null,304.7480000000005,5.0990229220780614E-2]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":776.95747999999992},null,0.13,null,{"$f":"L58*J59","v":816.57472000000007},null,39.617240000000152,5.0990229220780725E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":6753.5534799999996},null,null,null,{"$f":"L58+L59","v":7097.9187199999997},null,344.36524000000009,5.0990229220780538E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-675.36},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-709.79},null,-34.42999999999995,5.0980217957829824E-2]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":6078.1934799999999},null,null,null,{"$f":"SUM(L60:L61)","v":6388.1287199999997},null,309.93523999999979,5.0991341591844125E-2]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":5588.4764000000005},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":5893.2244000000001},null,{"$f":"L64-H64","v":304.74799999999959},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":5.4531499855667201E-2}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":726.50193200000012},null,0.13,null,{"$f":"L64*J65","v":766.11917200000005},null,39.617239999999924,5.4531499855667166E-2]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":6314.9783320000006},null,null,null,{"$f":"L64+L65","v":6659.3435719999998},null,344.36523999999918,5.4531499855667145E-2]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-631.5},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-665.93},null,-34.42999999999995,5.4520981789390265E-2]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":5683.4783320000006},null,null,null,{"$f":"L66+L67","v":5993.4135719999995},null,309.93523999999888,5.4532668534153367E-2]
[]
[]
[null,"Loss Factor (%)",null,null,null,7.8799999999999995E-2,null,null,null,7.0000000000000007E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts_USL","index":9,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"'[2]LDC Info'!$E$18","v":"EB2012-0176"},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Unmetered Scattered Load"]
[]
[null,null,null,"Consumption",null,375," kWh"]
[]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"per kWh",null,11.3,1,{"$f":"G21*F21","v":11.3},null,6.19,1,{"$f":"K21*J21","v":6.19},null,{"$f":"L21-H21","v":-5.1100000000000003},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":-0.45221238938053099}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G22*F22","v":0},null,null,1,{"$f":"K22*J22","v":0},null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"SMDR",null,"Monthly",null,null,1,0,null,null,1,{"$f":"K23*J23","v":0},null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kWh",null,4.2200000000000001E-2,{"$f":"$F$16","v":375},15.825000000000001,null,2.3099999999999999E-2,{"$f":"$F$16","v":375},8.6624999999999996,null,-7.1625000000000014,-0.45260663507109011]
[null,"Smart Meter Disposition Rider",null,null,null,null,{"$f":"$F$16","v":375},0,null,null,{"$f":"$F$16","v":375},0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kWh",null,null,{"$f":"$F$16","v":375},0,null,null,375,0,null,0,""]
[null,"Rate Rider for Tax Adjustments",null,"per kWh",null,-5.9999999999999995E-4,{"$f":"$F$16","v":375},-0.22499999999999998,null,null,375,0,null,0.22499999999999998,-1]
[null,null,null,"per kWh",null,null,375,0,null,null,375,0,null,0,""]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":26.9},null,null,null,{"$f":"SUM(L21:L36)","v":14.852499999999999},null,-12.047499999999999,-0.44786245353159854]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kWh",null,-1.1999999999999999E-3,{"$f":"$F$16","v":375},{"$f":"G38*F38","v":-0.44999999999999996},null,2.8999999999999998E-3,{"$f":"$F$16","v":375},{"$f":"K38*J38","v":1.0874999999999999},null,{"$f":"L38-H38","v":1.5374999999999999},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-3.4166666666666665}]
[null,null,null,null,null,null,{"$f":"$F$16","v":375},{"$f":"G39*F39","v":0},null,null,{"$f":"$F$16","v":375},{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,null,null,null,null,null,375,0,null,null,375,0,null,0,""]
[null,"Low Voltage Service Charge",null,null,null,1.1000000000000001E-3,375,{"$f":"G42*F42","v":0.41250000000000003},null,1.5E-3,375,{"$f":"K42*J42","v":0.5625},null,{"$f":"L42-H42","v":0.14999999999999997},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":0.36363636363636354}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,375,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":26.862499999999997},null,null,null,{"$f":"SUM(L38:L42)+L37","v":16.502499999999998},null,{"$f":"L44-H44","v":-10.36},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":-0.38566775244299678}]
[null,"RTSR - Network",null,"per kWh",null,4.7999999999999996E-3,{"$f":"F16*(1+F71)","v":404.55},{"$f":"G45*F45","v":1.9418399999999998},null,5.4000000000000003E-3,{"$f":"F16*(1+J71)","v":401.25},{"$f":"K45*J45","v":2.16675},null,0.22491000000000017,0.11582313681868753]
[null,"RTSR - Line and Transformation Connection",null,"per kWh",null,1.6999999999999999E-3,{"$f":"G45","v":404.55},{"$f":"G46*F46","v":0.68773499999999999},null,1.9E-3,{"$f":"K45","v":401.25},{"$f":"K46*J46","v":0.76237500000000002},null,7.464000000000004E-2,0.10853017514013398]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":29.492074999999996},null,null,null,{"$f":"SUM(L44:L46)","v":19.431624999999997},null,-10.060449999999999,-0.34112384428698223]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"G46","v":404.55},{"$f":"G48*F48","v":2.1036600000000001},null,5.1999999999999998E-3,{"$f":"K46","v":401.25},{"$f":"K48*J48","v":2.0865},null,-1.7160000000000064E-2,-8.1572117167223145E-3]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"G46","v":404.55},0.44500500000000004,null,1.1000000000000001E-3,{"$f":"K46","v":401.25},0.44137500000000002,null,-3.6300000000000221E-3,-8.1572117167223335E-3]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,6.9999999999999999E-4,{"$f":"G49","v":404.55},0.28318500000000002,null,6.9999999999999999E-4,{"$f":"K49","v":401.25},0.28087499999999999,null,-2.3100000000000342E-3,-8.1572117167224047E-3]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":404.55},{"$f":"G52*F52","v":30.341249999999999},null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$J$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$J$71),$F$16-1000))))","v":401.25},{"$f":"K52*J52","v":30.09375},null,-0.24749999999999872,-8.1572117167222416E-3]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":0},{"$f":"G53*F53","v":0},null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$J$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$J$71)-1000,IF($F$16<1000,0))))","v":0},{"$f":"K53*J53","v":0},null,0,""]
[null,"TOU - Off Peak",null,"per kWh",null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":258.91199999999998},16.829280000000001,null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$J$71)","v":256.8},16.692,null,-0.13728000000000051,-8.1572117167223145E-3]
[null,"TOU - Mid Peak",null,"per kWh",null,0.1,{"$f":"0.18*$F$16*(1+$F$71)","v":72.819000000000003},7.2819000000000003,null,0.1,{"$f":"0.18*$F$16*(1+$J$71)","v":72.225000000000009},7.222500000000001,null,-5.9399999999999231E-2,-8.1572117167221774E-3]
[null,"TOU - On Peak",null,"per kWh",null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$F$71)","v":72.819000000000003},8.5198230000000006,null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$J$71)","v":72.225000000000009},8.4503250000000012,null,-6.9497999999999394E-2,-8.1572117167222121E-3]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":62.915175000000005},null,null,null,{"$f":"SUM(L47:L53)","v":52.584125},null,-10.331050000000005,-0.16420601230148377]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":8.1789727500000016},null,0.13,null,{"$f":"L58*J59","v":6.8359362500000005},null,-1.3430365000000011,-0.16420601230148379]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":71.094147750000005},null,null,null,{"$f":"L58+L59","v":59.420061250000003},null,-11.674086500000001,-0.16420601230148371]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-7.11},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-5.94},null,1.17,-0.16455696202531644]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":63.984147750000005},null,null,null,{"$f":"SUM(L60:L61)","v":53.480061250000006},null,-10.5040865,-0.16416701432113703]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":65.204927999999995},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":54.855200000000004},null,{"$f":"L64-H64","v":-10.349727999999992},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":-0.15872616253789887}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":8.4766406399999994},null,0.13,null,{"$f":"L64*J65","v":7.1311760000000008},null,-1.3454646399999985,-0.15872616253789881]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":73.681568639999995},null,null,null,{"$f":"L64+L65","v":61.986376000000007},null,-11.695192639999988,-0.15872616253789881]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-7.37},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-6.2},null,1.17,-0.1587516960651289]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":66.31156863999999},null,null,null,{"$f":"L66+L67","v":55.786376000000004},null,-10.525192639999986,-0.1587233246907547]
[]
[]
[null,"Loss Factor (%)",null,null,null,7.8799999999999995E-2,null,null,null,7.0000000000000007E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts_Sentinel","index":10,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"'[2]LDC Info'!$E$18","v":"EB2012-0176"},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Sentinel Lighting"]
[]
[null,null,null,"Consumption",null,200," kWh"]
[null,null,null,null,null,0.2,"KW"]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,2.5299999999999998,1,{"$f":"G21*F21","v":2.5299999999999998},null,4.51,{"$f":"+G21","v":1},{"$f":"K21*J21","v":4.51},null,{"$f":"L21-H21","v":1.98},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":0.78260869565217395}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G22*F22","v":0},null,null,{"$f":"+G22","v":1},0,null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"SMDR",null,"Monthly",null,null,1,0,null,null,1,0,null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,13.0802,{"$f":"+$F$17","v":0.2},2.6160399999999999,null,23.327500000000001,0.2,4.6655000000000006,null,2.0494600000000007,0.78342074280209817]
[null,"Smart Meter Disposition Rider",null,null,null,null,{"$f":"+$F$17","v":0.2},0,null,null,0.2,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,"Rate Rider for Tax Adjustments",null,"per kW",null,-0.2288,0.2,-4.5760000000000002E-2,null,null,0.2,0,null,4.5760000000000002E-2,-1]
[null,null,null,"per kWh",null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,null,null,null,null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,null,null,null,null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,null,null,null,null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,null,null,null,null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,null,null,null,null,null,0.2,0,null,null,0.2,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":5.1002799999999997},null,null,null,{"$f":"SUM(L21:L36)","v":9.1754999999999995},null,4.0752199999999998,0.79901887739496658]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,-1.1627000000000001,{"$f":"+$F$17","v":0.2},{"$f":"G38*F38","v":-0.23254000000000002},null,3.2347000000000001,0.2,{"$f":"K38*J38","v":0.64694000000000007},null,{"$f":"L38-H38","v":0.87948000000000004},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":-3.7820590006020467}]
[null,"Global Adjustment Rate Rider",null,"per kW",null,null,{"$f":"+$F$17","v":0.2},{"$f":"G39*F39","v":0},null,null,0.2,{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,{"$f":"+$F$17","v":0.2},0,null,null,0.2,0,null,0,""]
[null,null,null,null,null,null,{"$f":"+$F$17","v":0.2},0,null,null,0.2,0,null,0,""]
[null,"Low Voltage Service Charge",null,"per kW",null,0.31530000000000002,{"$f":"+$F$17","v":0.2},{"$f":"G42*F42","v":6.3060000000000005E-2},null,0.43969999999999998,0.2,{"$f":"K42*J42","v":8.7940000000000004E-2},null,{"$f":"L42-H42","v":2.4879999999999999E-2},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":0.39454487789406911}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":4.9307999999999996},null,null,null,{"$f":"SUM(L38:L42)+L37","v":9.91038},null,{"$f":"L44-H44","v":4.9795800000000003},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":1.0098929179849112}]
[null,"RTSR - Network",null,"per kW",null,1.5096000000000001,{"$f":"+$F$17","v":0.2},{"$f":"G45*F45","v":0.30192000000000002},null,1.7069000000000001,0.2,{"$f":"K45*J45","v":0.34138000000000002},null,3.9459999999999995E-2,0.13069687334393215]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,0.54759999999999998,{"$f":"G45","v":0.2},{"$f":"G46*F46","v":0.10952000000000001},null,0.61370000000000002,0.2,{"$f":"K46*J46","v":0.12274000000000002},null,1.322000000000001E-2,0.12070854638422214]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":5.3422399999999994},null,null,null,{"$f":"SUM(L44:L46)","v":10.374500000000001},null,5.0322600000000017,0.94197565066339251]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"+$F$16","v":200},{"$f":"G48*F48","v":1.04},null,5.1999999999999998E-3,200,{"$f":"K48*J48","v":1.04},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"+$F$16","v":200},0.22,null,1.1000000000000001E-3,200,0.22,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,6.9999999999999999E-4,{"$f":"G49","v":200},0.13999999999999999,null,6.9999999999999999E-4,200,0.13999999999999999,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":215.76},{"$f":"G52*F52","v":16.181999999999999},null,7.4999999999999997E-2,215.76,{"$f":"K52*J52","v":16.181999999999999},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":0},{"$f":"G53*F53","v":0},null,8.7999999999999995E-2,0,{"$f":"K53*J53","v":0},null,0,""]
[null,"TOU - Off Peak",null,"per kWh",null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":138.0864},8.9756160000000005,null,6.5000000000000002E-2,138.0864,8.9756160000000005,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.1,{"$f":"0.18*$F$16*(1+$F$71)","v":38.836799999999997},3.88368,null,0.1,38.836799999999997,3.88368,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$F$71)","v":38.836799999999997},4.5439055999999995,null,0.11700000000000001,38.836799999999997,4.5439055999999995,null,0,0]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":23.174239999999998},null,null,null,{"$f":"SUM(L47:L53)","v":28.206499999999998},null,5.0322600000000008,0.21714886874391573]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":3.0126511999999996},null,0.13,null,{"$f":"L58*J59","v":3.6668449999999999},null,0.65419380000000027,0.21714886874391578]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":26.186891199999998},null,null,null,{"$f":"L58+L59","v":31.873344999999997},null,5.6864537999999989,0.21714886874391562]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-2.62},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-3.19},null,-0.56999999999999984,0.21755725190839686]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":23.566891199999997},null,null,null,{"$f":"SUM(L60:L61)","v":28.683344999999996},null,5.1164537999999986,0.21710346759694801]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":24.395441599999998},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":29.427701600000002},null,{"$f":"L64-H64","v":5.0322600000000044},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":0.20627870085368755}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":3.1714074079999999},null,0.13,null,{"$f":"L64*J65","v":3.8256012080000006},null,0.65419380000000071,0.20627870085368757]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":27.566849007999998},null,null,null,{"$f":"L64+L65","v":33.253302808000001},null,5.6864538000000024,0.20627870085368746]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-2.76},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-3.33},null,-0.57000000000000028,0.20652173913043489]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":24.806849008},null,null,null,{"$f":"L66+L67","v":29.923302808000003},null,5.1164538000000022,0.20625166051319088]
[]
[]
[null,"Loss Factor (%)",null,null,null,7.8799999999999995E-2,null,null,null,7.0000000000000007E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]

{"sheet":"App.2-W_Bill Impacts_Streetligh","index":11,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[67,1,67,3],[18,3,19,3],[18,13,19,13],[18,14,19,14],[60,1,60,3],[61,1,61,3],[66,1,66,3],[2,0,2,10],[9,1,9,14],[10,1,10,14],[13,3,13,14],[17,5,17,7],[17,9,17,11],[17,13,17,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:",{"$f":"'[2]LDC Info'!$E$18","v":"EB2012-0176"},null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[null,"Appendix 2-W"]
[null,"Bill Impacts"]
[]
[]
[null,"Customer Class:",null,"Street Lighting"]
[]
[null,null,null,"Consumption",null,500," kWh"]
[null,null,null,null,null,3,"KW"]
[null,null,null,null,null,"Current Board-Approved",null,null,null,"Proposed",null,null,null,"Impact"]
[null,null,null,"Charge Unit",null,"Rate","Volume","Charge",null,"Rate","Volume","Charge",null,"$ Change","% Change"]
[null,null,null,null,null,"($)",null,"($)",null,"($)",null,"($)"]
[null,"Monthly Service Charge",null,"Monthly",null,3.88,1,{"$f":"G21*F21","v":3.88},null,4.25,{"$f":"+G21","v":1},{"$f":"K21*J21","v":4.25},null,{"$f":"L21-H21","v":0.37000000000000011},{"$f":"IF((H21)=0,\"\",(N21/H21))","v":9.5360824742268077E-2}]
[null,"Smart Meter Rate Adder",null,"Monthly",null,null,1,{"$f":"G22*F22","v":0},null,null,{"$f":"+G22","v":1},0,null,{"$f":"L22-H22","v":0},{"$f":"IF((H22)=0,\"\",(N22/H22))","v":""}]
[null,"SMDR",null,"Monthly",null,null,1,0,null,null,1,0,null,{"$f":"L23-H23","v":0},{"$f":"IF((H23)=0,\"\",(N23/H23))","v":""}]
[null,"Stranded Meter Rate Rider",null,"Monthly",null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,null,null,null,null,null,1,0,null,null,1,0,null,0,""]
[null,"Distribution Volumetric Rate",null,"per kW",null,3.2599,{"$f":"+$F$17","v":3},9.7797000000000001,null,3.5558999999999998,3,10.6677,null,0.8879999999999999,9.0800331298506079E-2]
[null,"Smart Meter Disposition Rider",null,null,null,null,{"$f":"+$F$17","v":3},0,null,null,3,0,null,0,""]
[null,"LRAM & SSM Rate Rider",null,"per kW",null,null,3,0,null,null,3,0,null,0,""]
[null,"Rate Rider for Tax Adjustments",null,"per kW",null,-0.27800000000000002,3,-0.83400000000000007,null,null,3,0,null,0.83400000000000007,-1]
[null,null,null,"per kWh",null,null,3,0,null,null,3,0,null,0,""]
[null,null,null,null,null,null,3,0,null,null,3,0,null,0,""]
[null,null,null,null,null,null,3,0,null,null,3,0,null,0,""]
[null,null,null,null,null,null,3,0,null,null,3,0,null,0,""]
[null,null,null,null,null,null,3,0,null,null,3,0,null,0,""]
[null,null,null,null,null,null,3,0,null,null,3,0,null,0,""]
[null,"Sub-Total A",null,null,null,null,null,{"$f":"SUM(H21:H36)","v":12.825700000000001},null,null,null,{"$f":"SUM(L21:L36)","v":14.9177},null,2.0919999999999987,0.16311000569169704]
[null,"Deferral/Variance Account Disposition Rate Rider",null,"per kW",null,8.4709999999999994E-2,{"$f":"+$F$17","v":3},{"$f":"G38*F38","v":0.25412999999999997},null,1.5746,3,{"$f":"K38*J38","v":4.7237999999999998},null,{"$f":"L38-H38","v":4.4696699999999998},{"$f":"IF((H38)=0,\"\",(N38/H38))","v":17.588124188407509}]
[null,"Global Adjustment Rate Rider",null,"per kW",null,null,{"$f":"+$F$17","v":3},{"$f":"G39*F39","v":0},null,null,3,{"$f":"K39*J39","v":0},null,{"$f":"L39-H39","v":0},{"$f":"IF((H39)=0,\"\",(N39/H39))","v":""}]
[null,null,null,null,null,null,{"$f":"+$F$17","v":3},0,null,null,3,0,null,0,""]
[null,null,null,null,null,null,{"$f":"+$F$17","v":3},0,null,null,3,0,null,0,""]
[null,"Low Voltage Service Charge",null,"per kW",null,0.30790000000000001,{"$f":"+$F$17","v":3},{"$f":"G42*F42","v":0.92369999999999997},null,0.45019999999999999,3,{"$f":"K42*J42","v":1.3506},null,{"$f":"L42-H42","v":0.42690000000000006},{"$f":"IF((H42)=0,\"\",(N42/H42))","v":0.46216303994803515}]
[null,"Smart Meter Entity Charge",null,null,null,null,null,null,null,null,0,{"$f":"K43*J43","v":0},null,{"$f":"L43-H43","v":0}]
[null,"Sub-Total B - Distribution (includes Sub-Total A)",null,null,null,null,null,{"$f":"SUM(H38:H42)+H37","v":14.003530000000001},null,null,null,{"$f":"SUM(L38:L42)+L37","v":20.992100000000001},null,{"$f":"L44-H44","v":6.9885699999999993},{"$f":"IF((H44)=0,\"\",(N44/H44))","v":0.49905773758473748}]
[null,"RTSR - Network",null,"per kW",null,1.4976,{"$f":"+$F$17","v":3},{"$f":"G45*F45","v":4.4927999999999999},null,1.6934,3,{"$f":"K45*J45","v":5.0801999999999996},null,0.5873999999999997,0.13074252136752129]
[null,"RTSR - Line and Transformation Connection",null,"per kW",null,0.53480000000000005,{"$f":"G45","v":3},{"$f":"G46*F46","v":1.6044},null,0.59940000000000004,3,{"$f":"K46*J46","v":1.7982},null,0.19379999999999997,0.1207928197456993]
[null,"Sub-Total C - Delivery (including Sub-Total B)",null,null,null,null,null,{"$f":"SUM(H44:H46)","v":20.100729999999999},null,null,null,{"$f":"SUM(L44:L46)","v":27.8705},null,7.7697700000000012,0.38654168281450485]
[null,"Wholesale Market Service Charge (WMSC)",null,"per kWh",null,5.1999999999999998E-3,{"$f":"+$F$16","v":500},{"$f":"G48*F48","v":2.6},null,5.1999999999999998E-3,500,{"$f":"K48*J48","v":2.6},null,0,0]
[null,"Rural and Remote Rate Protection (RRRP)",null,"per kWh",null,1.1000000000000001E-3,{"$f":"+$F$16","v":500},0.55000000000000004,null,1.1000000000000001E-3,500,0.55000000000000004,null,0,0]
[null,"Standard Supply Service Charge",null,"Monthly",null,0.25,1,0.25,null,0.25,1,0.25,null,0,0]
[null,"Debt Retirement Charge (DRC)",null,"per kWh",null,6.9999999999999999E-4,{"$f":"G49","v":500},0.35,null,6.9999999999999999E-4,500,0.35,null,0,0]
[null,"Energy - RPP - Tier 1",null,"per kWh",null,7.4999999999999997E-2,{"$f":"IF($T$1=1,IF($F$16>=600,600,IF($F$16<600,$F$16*(1+$F$71),$F$16-600)),IF($T$1=2,IF($F$16>=1000,1000,IF($F$16<1000,$F$16*(1+$F$71),$F$16-1000))))","v":539.4},{"$f":"G52*F52","v":40.454999999999998},null,7.4999999999999997E-2,539.4,{"$f":"K52*J52","v":40.454999999999998},null,0,0]
[null,"Energy - RPP - Tier 2",null,"per kWh",null,8.7999999999999995E-2,{"$f":"IF($T$1=1,IF($F$16>=600,$F$16*(1+$F$71)-600,IF($F$16<600,0,)), IF($T$1=2,IF($F$16>=1000,$F$16*(1+$F$71)-1000,IF($F$16<1000,0))))","v":0},{"$f":"G53*F53","v":0},null,8.7999999999999995E-2,0,{"$f":"K53*J53","v":0},null,0,""]
[null,"TOU - Off Peak",null,"per kWh",null,6.5000000000000002E-2,{"$f":"0.64*$F$16*(1+$F$71)","v":345.21600000000001},22.439040000000002,null,6.5000000000000002E-2,345.21600000000001,22.439040000000002,null,0,0]
[null,"TOU - Mid Peak",null,"per kWh",null,0.1,{"$f":"0.18*$F$16*(1+$F$71)","v":97.091999999999999},9.7092000000000009,null,0.1,97.091999999999999,9.7092000000000009,null,0,0]
[null,"TOU - On Peak",null,"per kWh",null,0.11700000000000001,{"$f":"0.18*$F$16*(1+$F$71)","v":97.091999999999999},11.359764,null,0.11700000000000001,97.091999999999999,11.359764,null,0,0]
[]
[null,"Total Bill on RPP (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H53)","v":64.305729999999997},null,null,null,{"$f":"SUM(L47:L53)","v":72.075500000000005},null,7.7697700000000083,0.12082546920779857]
[null,"HST",null,null,null,0.13,null,{"$f":"H58*F59","v":8.359744899999999},null,0.13,null,{"$f":"L58*J59","v":9.3698150000000009},null,1.0100701000000019,0.12082546920779867]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H58+H59","v":72.665474899999992},null,null,null,{"$f":"L58+L59","v":81.445315000000008},null,8.7798401000000155,0.12082546920779866]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H60*10%,2)","v":-7.27},null,null,null,{"$f":"ROUND(-L60*10%,2)","v":-8.14},null,-0.87000000000000099,0.11966987620357648]
[null,"Total Bill on RPP (including OCEB)",null,null,null,null,null,{"$f":"SUM(H60:H61)","v":65.395474899999996},null,null,null,{"$f":"SUM(L60:L61)","v":73.305315000000007},null,7.9098401000000109,0.12095393621799375]
[]
[null,"Total Bill on TOU (before Taxes)",null,null,null,null,null,{"$f":"SUM(H47:H51,H54:H56)","v":67.358734000000013},null,null,null,{"$f":"SUM(L47:L51,L54:L56)","v":75.128504000000007},null,{"$f":"L64-H64","v":7.7697699999999941},{"$f":"IF((H64)=0,\"\",(N64/H64))","v":0.11534910973831534}]
[null,"HST",null,null,null,0.13,null,{"$f":"H64*F65","v":8.7566354200000021},null,0.13,null,{"$f":"L64*J65","v":9.7667055200000004},null,1.0100700999999983,0.11534910973831523]
[null,"Total Bill (including HST)",null,null,null,null,null,{"$f":"H64+H65","v":76.115369420000007},null,null,null,{"$f":"L64+L65","v":84.895209520000009},null,8.7798401000000013,0.11534910973831546]
[null,"Ontario Clean Energy Benefit 1",null,null,null,null,null,{"$f":"ROUND(-H66*10%,2)","v":-7.61},null,null,null,{"$f":"ROUND(-L66*10%,2)","v":-8.49},null,-0.87999999999999989,0.11563731931668855]
[null,"Total Bill on TOU (including OCEB)",null,null,null,null,null,{"$f":"H66+H67","v":68.505369420000008},null,null,null,{"$f":"L66+L67","v":76.405209520000014},null,7.8998401000000058,0.1153170936363663]
[]
[]
[null,"Loss Factor (%)",null,null,null,7.8799999999999995E-2,null,null,null,7.0000000000000007E-2]
[]
["1 Applicable to eligible customers only.  Refer to the Ontario Clean Energy Benefit Act, 2010."]
[]
["Note that the \"Charge $\" columns provide breakdowns of the amounts that each bill component contributes to the total monthly bill at the referenced "]
["consumption level at existing and proposed rates."]
[]
["Applicants must provide bill impacts for residential at 800 kWh and GS<50kW at 2000 kWh. In addition, their filing should cover the range that is relevant"]
["to their service territory, class by class. A general guideline of consumption levels follows:"]
[]
["Residential (kWh) - 100, 250, 500, 800, 1000, 1500, 2000"]
["GS<50kW (kWh) - 1000, 2000, 5000, 10000, 15000"]
["GS>50kW (kW) - 60, 100, 500, 1000"]
["Large User - range appropriate for utility"]
["Lighting Classes and USL - 150 kWh and 1 kW, range appropriate for utility."]