{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Utility_Info_","2. ICM_Costs","3a. ICM_by component","3. Cost_of_Service_Parameters","4. ICM_Assets_and_Rate_Base","5. UCC_Calculation","6. ICMIRR ","7. Funding Adder Revs","8. Opex Interest Annual","9. True-up Amount"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Utility_Info_","index":0,"n_rows":79,"n_cols":28,"rows_kept":79,"cut":false,"hidden":false,"merged":[[18,3,18,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algoma Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attawapiskat Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brant County Power"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge and North Dumfries Hydro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. – Eastern Ontario Power/Fort Erie/Port Colborne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLLUS Power Corp."]
[null,null,null,null,null,null,null,"Version",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.L.K. Energy Inc."]
[null,null,"Utility Name   ","Kingston Hydro Corporation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enersource Hydro Mississauga Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc."]
[null,null,"Assigned EB Number","EB-2015-0083",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENWIN Utilities Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erie Thames Powerlines Corp."]
[null,null,"Name and Title","Randy Murphy, Chief Financial Officer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espanola Regional Hydro Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation"]
[null,null,"Phone Number","613-546-1181",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Festival Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Albany Power Corporation"]
[null,null,"Email Address","rmurphy@kingstonhydro.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Frances Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greater Sudbury Hydro Inc."]
[null,null,"Date","2015-04-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grimsby Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guelph Hydro Electric Systems Inc."]
[null,null,"Last COS Re-based Year",2011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haldimand County Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halton Hills Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hearst Power Distribution Co. Ltd."]
["Note:  Drop-down lists are shaded blue; Input cells are shaded green."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizon Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro 2000 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Brampton Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Remote Communities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Ottawa Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Innisfil Hydro Dist. Systems Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kashechewan Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenora Hydro Electric Corporation Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kingston Hydro Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kitchener-Wilmot Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakefront Utilities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"London Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midland Power Utility Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milton Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newmarket – Tay Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara Peninsula Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara-on-the-Lake Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norfolk Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orillia Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oshawa PUC Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottawa River Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parry Sound Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peterborough Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PowerStream Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUC Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renfrew Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rideau St. Lawrence Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Thomas Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux Lookout Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thunder Bay Hydro Electricity Distribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillsonburg Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toronto Hydro-Electric System Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veridian Connections Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wasaga Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterloo North Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Welland Hydro Electric System Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington North Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West Coast Huron Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whitby Hydro Electric Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodstock Hydro Services Inc."]

{"sheet":"2. ICM_Costs","index":1,"n_rows":212,"n_cols":14,"rows_kept":212,"cut":false,"hidden":false,"merged":[[166,2,166,3],[168,2,168,3],[170,2,170,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2012,2013,2014,null,2015,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual","Audited Actual","Audited Actual",null,"Forecast"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"ICP 1  King Street 44 kv Underground Rebuild",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"},"Audited Actual",{"$f":"IF(ISBLANK(I19),\"\",I19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(K19),\"\",K19)","v":"Forecast"}]
[null,null,"ICP 1.1 ",null,"Poles",null,null,null,null,null,null,null,{"$f":"SUM(I42,K42)","v":0}]
[]
[null,null,"ICP 1.2",null,"Overhead Conductor",null,null,null,null,null,null,null,{"$f":"SUM(I44,K44)","v":0}]
[]
[null,null,"ICP 1.3",null,"Underground Conduit",null,731286,null,null,null,null,null,{"$f":"SUM(I46,K46)","v":0}]
[]
[null,null,"ICP 1.4",null,"Underground Conductor",null,573808.32999999996,null,null,null,null,null,{"$f":"SUM(I48,K48)","v":0}]
[]
[null,null,"ICP 1.5",null,"Underground Injected Cable",null,null,null,null,null,null,null,{"$f":"SUM(I50,K50)","v":0}]
[]
[null,null,"ICP 1.6",null,"Underground Transformers",null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.7",null,"Overhead Transformers",null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.8",null,"Overhead Services",null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.9",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.10",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total King Street 44 kv Underground Rebuild",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60)","v":1305094.33},0,{"$f":"SUM(I42,I44,I46,I48,I50,I52,I54,I56,I58,I60)","v":0},null,{"$f":"SUM(K42,K44,K46,K48,K50,K52,K54,K56,K58,K60)","v":0},null,{"$f":"SUM(M42,M44,M46,M48,M50,M52,M54,M56,M58,M60)","v":0}]
[]
[null,null,null,null,{"$f":"E40","v":"Asset Type"}]
[null,null,"ICP 2    Transformer Vault (TV 6)",null,null,null,{"$f":"G41","v":"Audited Actual"},"Audited Actual",{"$f":"I41","v":"Audited Actual"},null,{"$f":"K41","v":"Forecast"}]
[null,null,"ICP 2.1.",null,"Poles",null,110.57,null,null,null,null,null,{"$f":"SUM(I66,K66)","v":0}]
[]
[null,null,"ICP 2.2",null,"Overhead Conductor",null,663.92,null,null,null,null,null,{"$f":"SUM(I68,K68)","v":0}]
[]
[null,null,"ICP 2.3",null,"Underground Conductor",null,208041.36,null,null,null,null,null,{"$f":"SUM(I70,K70)","v":0}]
[]
[null,null,"ICP 2.4",null,"Overhead Transformers",null,null,null,null,null,null,null,{"$f":"SUM(I72,K72)","v":0}]
[]
[null,null,"ICP 2.5",null,"Underground Transformers",null,36822.06,null,null,null,null,null,{"$f":"SUM(I74,K74)","v":0}]
[]
[null,null,"ICP 2.6",null,"Overhead Services",null,null,null,null,null,null,null,{"$f":"SUM(I76,K76)","v":0}]
[]
[null,null,"ICP 2.7",null,"Underground Conduit",null,220147.81,null,null,null,null,null,{"$f":"SUM(I78,K78)","v":0}]
[]
[null,null,"ICP 2.8",null,"System Supervisory Equipment",null,null,null,null,null,null,null,{"$f":"SUM(I80,K80)","v":0}]
[]
[null,null,"ICP 2.9",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,null,null,null,null,null,null,{"$f":"SUM(I82,K82)","v":0}]
[]
[null,null,"ICP 2.10",null,"Underground Injected Cable",null,null,null,null,null,null,null,0]
[]
[null,null,"Total Transformer Vault (TV 6)",null,null,null,{"$f":"SUM(G66,G68,G70,G72,G74,G76,G78,G80,G82,G84)","v":465785.72},0,{"$f":"SUM(I66,I68,I70,I72,I74,I76,I78,I80,I82,I84)","v":0},null,{"$f":"SUM(K66,K68,K70,K72,K74,K76,K78,K80,K82,K84)","v":0},null,{"$f":"SUM(M66,M68,M70,M72,M74,M76,M78,M80,M82,M84)","v":0}]
[]
[null,null,null,null,{"$f":"E64","v":"Asset Type"}]
[null,null,"ICP 3  Substation No. 15 Circuit Breakers Retrofit",null,null,null,{"$f":"G65","v":"Audited Actual"},"Audited Actual",{"$f":"I65","v":"Audited Actual"},null,{"$f":"K65","v":"Forecast"}]
[null,null,"ICP 3.1",null,"Poles",null,null,null,null,null,null,null,{"$f":"SUM(I90,K90)","v":0}]
[]
[null,null,"ICP 3.2",null,"Overhead Conductor",null,null,null,null,null,null,null,{"$f":"SUM(I92,K92)","v":0}]
[]
[null,null,"ICP 3.3",null,"RTU's",null,null,null,null,null,null,null,{"$f":"SUM(I94,K94)","v":0}]
[]
[null,null,"ICP 3.4",null,"Underground Conductor",null,null,null,null,null,null,null,{"$f":"SUM(I96,K96)","v":0}]
[]
[null,null,"ICP 3.5",null,"Underground Transformers",null,null,null,null,null,null,null,{"$f":"SUM(I98,K98)","v":0}]
[]
[null,null,"ICP 3.6",null,"Overhead Services",null,null,null,null,null,null,null,{"$f":"SUM(I100,K100)","v":0}]
[]
[null,null,"ICP 3.7",null,"System Supervisory Equipment",null,2567.09,null,null,null,null,null,{"$f":"SUM(I102,K102)","v":0}]
[]
[null,null,"ICP 3.8",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,473855.81999999995,null,null,null,null,null,{"$f":"SUM(I104,K104)","v":0}]
[]
[null,null,"ICP 3.9",null,"Transformer Station Equipment - Normally Primary above 50 kV",null,null,null,null,null,null,null,{"$f":"SUM(I106,K106)","v":0}]
[]
[null,null,"ICP 3.10",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total Substation No. 15 Circuit Breakers Retrofit",null,null,null,{"$f":"SUM(G90,G92,G94,G96,G98,G100,G102,G104,G106,G108)","v":476422.91},0,{"$f":"SUM(I90,I92,I94,I96,I98,I100,I102,I104,I106,I108)","v":0},null,{"$f":"SUM(K90,K92,K94,K96,K98,K100,K102,K104,K106,K108)","v":0},null,{"$f":"SUM(M90,M92,M94,M96,M98,M100,M102,M104,M106,M108)","v":0}]
[]
[null,null,null,null,{"$f":"E88","v":"Asset Type"}]
[null,null,"ICP 4  Transformer Vault 11 (TV 11) Rebuild",null,null,null,"Audited Actual","Audited Actual","Audited Actual",null,{"$f":"K89","v":"Forecast"}]
[]
[null,null,"ICP 4.1",null,"Poles",null,null,null,null,null,null,null,{"$f":"SUM(I115,K115)","v":0}]
[]
[null,null,"ICP 4.2",null,"Overhead Conductor",null,null,null,null,null,null,null,{"$f":"SUM(I117,K117)","v":0}]
[]
[null,null,"ICP 4.3",null,"Underground Conduit",null,null,173184.76500000001,45830.46,null,null,null,{"$f":"SUM(I119,K119)","v":45830.46}]
[]
[null,null,"ICP 4.4",null,"Underground Conductor",null,null,296850.84000000003,null,null,null,null,{"$f":"SUM(I121,K121)","v":0}]
[]
[null,null,"ICP 4.5",null,"Overhead Transformers",null,null,null,null,null,null,null,{"$f":"SUM(I123,K123)","v":0}]
[]
[null,null,"ICP 4.6",null,"Underground Transformers",null,null,38245.095000000001,null,null,null,null,{"$f":"SUM(I125,K125)","v":0}]
[]
[null,null,"ICP 4.7",null,"Overhead Services",null,null,null,null,null,null,null,{"$f":"SUM(I127,K127)","v":0}]
[]
[null,null,"ICP 4.8",null,"RTU's",null,null,null,null,null,null,null,{"$f":"SUM(I129,K129)","v":0}]
[]
[null,null,"ICP 4.9",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,null,null,null,null,null,null,{"$f":"SUM(I131,K131)","v":0}]
[]
[null,null,"ICP 4.10",null,"Land Rights",null,null,null,null,null,null,null,0]
[]
[null,null,"Total Transformer Vault 11 (TV 11) Rebuild",null,null,null,{"$f":"SUM(G115,G117,G119,G121,G123,G125,G127,G129,G131,G133)","v":0},508280.70000000007,{"$f":"SUM(I115,I117,I119,I121,I123,I125,I127,I129,I131,I133)","v":45830.46},null,{"$f":"SUM(K115,K117,K119,K121,K123,K125,K127,K129,K131,K133)","v":0},null,{"$f":"SUM(M115,M117,M119,M121,M123,M125,M127,M129,M131,M133)","v":45830.46}]
[]
[null,null,null,null,{"$f":"E112","v":"Asset Type"}]
[null,null,"ICP 5  SYSTEM CAPACITY RELIEF",null,null,null,"Audited Actual","Audited Actual","Audited Actual",null,{"$f":"K113","v":"Forecast"}]
[]
[null,null,"ICP 5.1",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I140,K140)","v":0}]
[]
[null,null,"ICP 5.2",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I142,K142)","v":0}]
[]
[null,null,"ICP 5.3",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I144,K144)","v":0}]
[]
[null,null,"ICP 5.4",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I146,K146)","v":0}]
[]
[null,null,"ICP 5.5",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I148,K148)","v":0}]
[]
[null,null,"ICP 5.6",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I150,K150)","v":0}]
[]
[null,null,"ICP 5.7",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I152,K152)","v":0}]
[]
[null,null,"ICP 5.8",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I154,K154)","v":0}]
[]
[null,null,"ICP 5.9",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I156,K156)","v":0}]
[]
[null,null,"ICP 5.10",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Capacity Relief",null,null,null,null,null,null,null,{"$f":"SUM(K140,K142,K144,K146,K148,K150,K152,K154,K156,K158)","v":0},null,{"$f":"SUM(M140,M142,M144,M146,M148,M150,M152,M154,M156,M158)","v":0}]
[]
[null,null,"Total Capital Costs Related to Incremental Capital Projects (ICP)",null,null,null,null,null,null,null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":0},null,{"$f":"SUM(M62,M86,M110,M135,M160)","v":45830.46}]
[]
[null,null,null,null,{"$f":"E137","v":"Asset Type"}]
[null,null,"OTHER CAPITAL COST",null,null,null,"Audited Actual","Audited Actual","Audited Actual",null,{"$f":"K138","v":"Forecast"}]
[]
[null,null,"A",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I167,K167)","v":0}]
[]
[null,null,"B",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I169,K169)","v":0}]
[]
[null,null,"C",null,null,null,null,null,null,null,null,null,{"$f":"SUM(I171,K171)","v":0}]
[]
[null,null,"Total Other Capital Costs ",null,null,null,{"$f":"SUM(G167,G169,G171)","v":0},0,{"$f":"SUM(I167,I169,I171)","v":0},null,{"$f":"SUM(K167,K169,K171)","v":0},null,{"$f":"SUM(M167,M169,M171)","v":0}]
[]
[null,null,"Total ICM Capital Costs",null,null,null,{"$f":"G162+G173","v":0},0,{"$f":"I162+I173","v":0},null,{"$f":"K162+K173","v":0},null,{"$f":"M162+M173","v":45830.46}]
[]
[]
[null,2,"Aggregated ICM Costs by Category"]
[]
[null,null,"2.1","Capital","Account"]
[]
[null,null,"2.1.1","Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D182,G$42:G$171)","v":110.57},0,{"$f":"SUMIF($E$42:$E$171,$D182,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D182,K$42:K$171)","v":0},null,{"$f":"SUM(I182:L182)","v":0}]
[]
[null,null,"2.1.2","Overhead Conductor",1835,null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":663.92},0,{"$f":"SUMIF($E$42:$E$171,$D184,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D184,K$42:K$171)","v":0},null,{"$f":"SUM(I184:L184)","v":0}]
[]
[null,null,"2.1.3","Underground Conduit",1840,null,{"$f":"SUMIF($E$42:$E$171,$D186,G$42:G$171)","v":951433.81},173184.76500000001,{"$f":"SUMIF($E$42:$E$171,$D186,I$42:I$171)","v":45830.46},null,{"$f":"SUMIF($E$42:$E$171,$D186,K$42:K$171)","v":0},null,{"$f":"SUM(I186:L186)","v":45830.46}]
[]
[null,null,"2.1.4","Underground Conductor",1845,null,{"$f":"SUMIF($E$42:$E$171,$D188,G$42:G$171)","v":781849.69},296850.84000000003,{"$f":"SUMIF($E$42:$E$171,$D188,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D188,K$42:K$171)","v":0},null,{"$f":"SUM(I188:L188)","v":0}]
[]
[null,null,"2.1.5","Underground Injected Cable",1846,null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":0},0,{"$f":"SUMIF($E$42:$E$171,$D190,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D190,K$42:K$171)","v":0},null,{"$f":"SUM(I190:L190)","v":0}]
[]
[null,null,"2.1.6","Overhead Transformers",1849,null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":0},0,{"$f":"SUMIF($E$42:$E$171,$D192,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D192,K$42:K$171)","v":0},null,{"$f":"SUM(I192:L192)","v":0}]
[]
[null,null,"2.1.7","Underground Transformers",1850,null,{"$f":"SUMIF($E$42:$E$171,$D194,G$42:G$171)","v":36822.06},38245.095000000001,{"$f":"SUMIF($E$42:$E$171,$D194,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D194,K$42:K$171)","v":0},null,{"$f":"SUM(I194:L194)","v":0}]
[]
[null,null,"2.1.8","Overhead Services",1855,null,{"$f":"SUMIF($E$42:$E$171,$D196,G$42:G$171)","v":0},0,{"$f":"SUMIF($E$42:$E$171,$D196,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D196,K$42:K$171)","v":0},null,{"$f":"SUM(I196:L196)","v":0}]
[]
[null,null,"2.1.9","RTU's",1981,null,{"$f":"SUMIF($E$42:$E$171,$D198,G$42:G$171)","v":0},0,{"$f":"SUMIF($E$42:$E$171,$D198,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D198,K$42:K$171)","v":0},null,{"$f":"SUM(I198:L198)","v":0}]
[]
[null,null,"2.1.10","System Supervisory Equipment",1980,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":2567.09},0,{"$f":"SUMIF($E$42:$E$171,$D200,I$42:I$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D200,K$42:K$171)","v":0},null,{"$f":"SUM(I200:L200)","v":0}]
[]
[null,null,"2.1.11","Distribution Station Equipment - Normally Primary below 50 kV",1820,null,{"$f":"SUMIF($E$42:$E$171,$D202,G$42:G$171)","v":473855.81999999995},0,0,null,0,null,0]
[]
[null,null,"2.1.12","Transformer Station Equipment - Normally Primary above 50 kV",1815,null,0,0,0,null,0,null,0]
[]
[null,null,"2.1.13","Land Rights",1612,null,0,0,0,null,0,null,0]
[]
[null,null,"2.1.14"]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G209)","v":2247302.96},{"$f":"SUM(H182:H209)","v":508280.70000000007},{"$f":"SUM(I182:I209)","v":45830.46},null,{"$f":"SUM(K182:K209)","v":0},null,{"$f":"SUM(M182:M209)","v":45830.46}]
[null,null,null,null,null,null,{"$f":"G211-G110-G86-G62-G135","v":0},{"$f":"H211-H110-H86-H62-H135","v":0},{"$f":"I211-I110-I86-I62-I135","v":0},null,{"$f":"K211-K110-K86-K62-K135","v":0},{"$f":"L211-L110-L86-L62-L135","v":0},{"$f":"M211-M110-M86-M62-M135","v":0},{"$f":"N211-N110-N86-N62-N135","v":0}]

{"sheet":"3a. ICM_by component","index":2,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,33,2]]}
["Asset","Asset Description ","Component","Old Useful Lives","New Useful Lives","2012-Additions","2012-NBV **","2013-Additions","2014-Additions","2012 Depreciation","2013 Depreciation","2014-Depreciation","2015-Depreciation"]
[]
[1830,"Poles",null,"25","45",110.57,{"$f":"F3-J3","v":108.36},null,null,{"$f":"+ROUND(F3/D3/2,2)","v":2.21},{"$f":"G3/(E3-1)+ROUND(H3/E3/2,2)","v":2.4627272727272729},{"$f":"G3/(E3-1)+(H3/E3)+ROUND(I3/E3/2,2)","v":2.4627272727272729},{"$f":"G3/(E3-1)+(H3/F3)+(I3/F3)","v":2.4627272727272729}]
[]
[1835,"Overhead Conductor",null,"25","45",663.98,{"$f":"F5-J5","v":650.70000000000005},null,null,{"$f":"+ROUND(F5/D5/2,2)","v":13.28},{"$f":"G5/(E5-1)+ROUND(H5/E5/2,2)","v":14.788636363636364},{"$f":"G5/(E5-1)+(H5/E5)+ROUND(I5/E5/2,2)","v":14.788636363636364},{"$f":"G5/(E5-1)+(H5/F5)+(I5/F5)","v":14.788636363636364}]
[]
[1840,"Underground Conduit"]
[null,null,"Duct","25","60",696879,{"$f":"F8-J8","v":682941.42},1614.04,null,{"$f":"+ROUND(F8/D8/2,2)","v":13937.58},{"$f":"G8/(E8-1)+ROUND(H8/E8/2,2)","v":11588.728305084747},{"$f":"G8/(E8-1)+(H8/E8)+ROUND(I8/E8/2,2)","v":11602.178971751413},{"$f":"(G8/(E8-1))+(H8/E8)","v":11602.178971751413}]
[null,null,"Vaults",25,"60",157511,{"$f":"F9-J9","v":154360.78},159187.34600000002,null,3150.22,3942.8444067796609,5269.4068401129944,{"$f":"(G9/(E9-1))+(H9/E9)","v":5269.4068401129944}]
[null,null,"Handholes",25,"60",16387,16059.26,95.12,null,327.74,272.98084745762714,273.77618079096044,273.77618079096044]
[null,null,"Manholes",25,"60",80656.77,79043.63,266.35000000000002,null,1613.14,1341.9425423728815,1344.1617090395482,1344.1617090395482]
[null,null,"Outdoor Submersible Vault",25,"35",null,null,11671.909,45830.46,0,{"$f":"G12/(E12-1)+ROUND(H12/E12/2,2)","v":166.74},{"$f":"G12/(E12-1)+(H12/E12)+ROUND(I12/E12/2,2)","v":988.20311428571426},{"$f":"(G12/(E12-1))+(H12/E12)+(I12/E12)","v":1642.9248285714284}]
[null,null,"Pad Mount Transformer",25,"40",null,null,350,null,0,{"$f":"G13/(E13-1)+ROUND(H13/E13/2,2)","v":4.38},{"$f":"G13/(E13-1)+(H13/E13)+ROUND(I13/E13/2,2)","v":8.75},{"$f":"(G13/(E13-1))+(H13/E13)+(I13/E13)","v":8.75}]
[]
[1845,"Underground Conductor"]
[null,null,"Underground Cable",25,"50",649242.18999999994,{"$f":"F16-J16","v":636257.35},230530.14,null,{"$f":"+ROUND(F16/D16/2,2)","v":12984.84},{"$f":"G16/(E16-1)+ROUND(H16/E16/2,2)","v":15290.143877551021},{"$f":"G16/(E16-1)+(H16/E16)+ROUND(I16/E16/2,2)","v":17595.446677551023},17595.446677551023]
[null,null,"Switches",25,"50",132607.5,129955.35,66320.7,null,{"$f":"+ROUND(F17/D17/2,2)","v":2652.15},{"$f":"G17/(E17-1)+ROUND(H17/E17/2,2)","v":3315.36},{"$f":"G17/(E17-1)+(H17/E17)+ROUND(I17/E17/2,2)","v":3978.5640000000003},3978.5640000000003]
[]
[]
[1850,"Underground Transformers"]
[null,null,"Pad Mount Transformer","25","40",36822.06,36085.619999999995,null,null,{"$f":"+ROUND(F21/D21/2,2)","v":736.44},{"$f":"G21/(E21-1)+ROUND(H21/E21/2,2)","v":925.27230769230755},{"$f":"G21/(E21-1)+(H21/E21)+ROUND(I21/E21/2,2)","v":925.27230769230755},925.27230769230755]
[null,null,"Vault Transformer","25","40",null,0,38245.095000000001,null,{"$f":"+ROUND(F22/D22/2,2)","v":0},{"$f":"G22/(E22-1)+ROUND(H22/E22/2,2)","v":478.06},{"$f":"G22/(E22-1)+(H22/E22)+ROUND(I22/E22/2,2)","v":956.12737500000003},956.12737500000003]
[null,null,"Pole Top Transformer","25","40",null,0]
[]
[1980,"System Supervisory Equipment"]
[null,null,null,"15","20",2567.09,2481.52,null,null,{"$f":"+ROUND(F26/D26/2,2)","v":85.57},{"$f":"G26/(E26-1)+ROUND(H26/E26/2,2)","v":130.60631578947368},{"$f":"G26/(E26-1)+(H26/E26)+ROUND(I26/E26/2,2)","v":130.60631578947368},130.60631578947368]
[]
[1820,"Distribution Station Equipment - Normally Primary below 50 kV","Circuit Breaker","30","50",1207.8044268873746,1187.6744268873745,null,null,{"$f":"+ROUND(F28/D28/2,2)","v":20.13},{"$f":"G28/(E28-1)+ROUND(H28/E28/2,2)","v":24.238253609946419},{"$f":"G28/(E28-1)+(H28/E28)+ROUND(I28/E28/2,2)","v":24.238253609946419},24.238253609946419]
[null,null,"Station Metal Clad Switchgear","30","50",335385.51557473402,329795.75557473401,null,null,{"$f":"+ROUND(F29/D29/2,2)","v":5589.76},{"$f":"G29/(E29-1)+ROUND(H29/E29/2,2)","v":6730.5256239741639},{"$f":"G29/(E29-1)+(H29/E29)+ROUND(I29/E29/2,2)","v":6730.5256239741639},6730.5256239741639]
[null,null,"Protective Relays","30","20",137262.49999837857,134974.78999837858,null,null,{"$f":"+ROUND(F30/D30/2,2)","v":2287.71},{"$f":"G30/(E30-1)+ROUND(H30/E30/2,2)","v":7103.9363157041353},{"$f":"G30/(E30-1)+(H30/E30)+ROUND(I30/E30/2,2)","v":7103.9363157041353},7103.9363157041353]
[]
[]
[]
[null,"**Effective January 1, 2013, the Company reviewed the useful lives of all capital assets subject to amortization.  This review was perfomed in accordance with IFRS IAS 16 and the requirement of the OEB to revise useful lives to conicide with IFRS.  The estimates of useful lives of certain items of property, plant and equipment were revised which resulted in a change in amortization rates and years of amortization."]

{"sheet":"3. Cost_of_Service_Parameters","index":3,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 3: Parameters and Rates"]
[]
[null,null,null,null,null,null,2012,null,2013,null,2014,null,2015]
[null,"Cost of Capital"]
[null,null,"Capital Structure"]
[null,null,null,"Deemed Short-term Debt Capitalization",null,null,0.04,null,0.04,null,0.04,null,0.04]
[null,null,null,"Deemed Long-term Debt Capitalization",null,null,{"$f":"60%-G22","v":0.55999999999999994},null,{"$f":"G23-(I22-G22)","v":0.55999999999999994},null,{"$f":"I23-(K22-I22)","v":0.55999999999999994},null,{"$f":"K23-(M22-K22)","v":0.55999999999999994}]
[null,null,null,"Deemed Equity Capitalization",null,null,{"$f":"100%-G23-G25-G22","v":0.40000000000000008},null,{"$f":"100%-I23-I25-I22","v":0.40000000000000008},null,{"$f":"100%-K23-K25-K22","v":0.40000000000000008},null,{"$f":"100%-M23-M25-M22","v":0.40000000000000008}]
[null,null,null,"Preferred Shares"]
[null,null,"Total",null,null,null,{"$f":"SUM(G22:G25)","v":1},null,{"$f":"SUM(I22:I25)","v":1},null,{"$f":"SUM(K22:K25)","v":1},null,{"$f":"SUM(M22:M25)","v":1}]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,2.46E-2,null,2.46E-2,null,2.46E-2,null,2.46E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,5.0099999999999999E-2,null,5.0099999999999999E-2,null,5.0099999999999999E-2,null,5.0099999999999999E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,9.5799999999999996E-2,null,9.5799999999999996E-2,null,9.5799999999999996E-2,null,9.5799999999999996E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":6.7360000000000003E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":6.7360000000000003E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":6.7360000000000003E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":6.7360000000000003E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.15,null,0.15,null,0.15,null,0.15]
[null,null,"(% of the sum of Cost of Power + controllable expenses)"]
[]
[null,"Taxes/PILs"]
[null,null,"Aggregate Corporate Income Tax Rate",null,null,null,0.24060000000000001,null,0.26500000000000001,null,0.24229999999999999,null,0.24229999999999999]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,0,null,0,null,0,null,0]
[]
[]
[]
[null,"CCA Rates"]
[null,null,"Poles - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Pole - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Overhead Conductor - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Overhead Conductor - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Underground Conduit - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Underground Conduit - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Underground Conductor - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Underground Conductor - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"U/G Injected Cable - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"U/G Injected Cable - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Overhead Transformers - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Overhead Transformers - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Underground Transformers - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Underground Transformers - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH  Services - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"OH Services - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"RTU's - CCA Class",null,null,null,8,null,8,null,8,null,8]
[null,null,"RUT's - CCA Rate",null,null,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,"System Supervisory Equipment - CCA Class",null,null,null,8,null,8,null,8,null,8]
[null,null,"System Supervisory Equipment - CCA Rate",null,null,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,"Distribution Station Equipment - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Distribution Station Equipment - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Transformer Station Equipment - CCA Class",null,null,null,47,null,47,null,47,null,47]
[null,null,"Transformer Station Equipment - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Land Rights - CCA Class"]
[null,null,"Land Rights - CCA Rate"]
[]
[]
[null,"Assumptions"]
[null,1,"Fiscal calendar year (January 1 to December 31) used."]
[null,3,"Amortization is done on a striaght line basis and no \"half-year\" rule applied."]

{"sheet":"4. ICM_Assets_and_Rate_Base","index":4,"n_rows":289,"n_cols":13,"rows_kept":289,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,"2012 Actual",null,"2013 Actual",null,"2014 Actual",null,"2015-Forecast"]
[null,"Net Fixed Assets - Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G25","v":110.57},null,{"$f":"I25","v":110.57},null,{"$f":"K25","v":110.57}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G182","v":110.57},null,{"$f":"'2. ICM_Costs'!H182","v":0},null,{"$f":"'2. ICM_Costs'!I182","v":0},null,{"$f":"'2. ICM_Costs'!K182","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G22+G23-G24","v":110.57},null,{"$f":"I22+I23-I24","v":110.57},null,{"$f":"K22+K23-K24","v":110.57},null,{"$f":"M22+M23-M24","v":110.57}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G31","v":-2.21},null,{"$f":"I31","v":-4.6727272727272728},null,{"$f":"K31","v":-7.1354545454545457}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-'3a. ICM_by component'!J3","v":-2.21},null,{"$f":"-'3a. ICM_by component'!K3","v":-2.4627272727272729},null,{"$f":"-'3a. ICM_by component'!L3","v":-2.4627272727272729},null,{"$f":"-'3a. ICM_by component'!M3","v":-2.4627272727272729}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G28+G29-G30","v":-2.21},null,{"$f":"I28+I29-I30","v":-4.6727272727272728},null,{"$f":"K28+K29-K30","v":-7.1354545454545457},null,{"$f":"M28+M29-M30","v":-9.5981818181818177}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G22+G28","v":0},null,{"$f":"I22+I28","v":108.36},null,{"$f":"K22+K28","v":105.89727272727272},null,103.43454545454544]
[null,null,null,"Closing Balance",null,null,{"$f":"G25+G31","v":108.36},null,{"$f":"I25+I31","v":105.89727272727272},null,{"$f":"K25+K31","v":103.43454545454544},null,{"$f":"M25+M31","v":100.97181818181818}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G35","v":108.36},null,{"$f":"I35","v":105.89727272727272},null,{"$f":"K35","v":103.43454545454544},null,{"$f":"M35","v":100.97181818181818}]
[]
[null,"Net Fixed Assets - Overhead Conductor"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G44","v":663.92},null,{"$f":"I44","v":663.92},null,{"$f":"K44","v":663.92}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G184","v":663.92},null,{"$f":"'2. ICM_Costs'!F184","v":0},null,{"$f":"'2. ICM_Costs'!I184","v":0},null,{"$f":"'2. ICM_Costs'!K184","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G41+G42-G43","v":663.92},null,{"$f":"I41+I42-I43","v":663.92},null,{"$f":"K41+K42-K43","v":663.92},null,{"$f":"M41+M42-M43","v":663.92}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G50","v":-13.28},null,{"$f":"I50","v":-28.068636363636365},null,{"$f":"K50","v":-42.857272727272729}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-'3a. ICM_by component'!J5","v":-13.28},null,{"$f":"-'3a. ICM_by component'!K5","v":-14.788636363636364},null,{"$f":"-'3a. ICM_by component'!L5","v":-14.788636363636364},null,{"$f":"-'3a. ICM_by component'!M5","v":-14.788636363636364}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G47+G48-G49","v":-13.28},null,{"$f":"I47+I48-I49","v":-28.068636363636365},null,{"$f":"K47+K48-K49","v":-42.857272727272729},null,{"$f":"M47+M48-M49","v":-57.645909090909093}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G41+G47","v":0},null,{"$f":"I41+I47","v":650.64},null,{"$f":"K41+K47","v":635.85136363636354},null,621.06272727272722]
[null,null,null,"Closing Balance",null,null,{"$f":"G44+G50","v":650.64},null,{"$f":"I44+I50","v":635.85136363636354},null,{"$f":"K44+K50","v":621.06272727272722},null,{"$f":"M44+M50","v":606.27409090909089}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G54","v":650.64},null,{"$f":"I54","v":635.85136363636354},null,{"$f":"K54","v":621.06272727272722},null,{"$f":"M54","v":606.27409090909089}]
[]
[null,"Net Fixed Assets - Underground Conduit"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G63","v":951433.81},null,{"$f":"I63","v":1124618.5750000002},null,{"$f":"K63","v":1170449.0350000001}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G186","v":951433.81},null,{"$f":"'2. ICM_Costs'!H186","v":173184.76500000001},null,{"$f":"'2. ICM_Costs'!I186","v":45830.46},null,{"$f":"'2. ICM_Costs'!K186","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G60+G61-G62","v":951433.81},null,{"$f":"I60+I61-I62","v":1124618.5750000002},null,{"$f":"K60+K61-K62","v":1170449.0350000001},null,{"$f":"M60+M61-M62","v":1170449.0350000001}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G69","v":-19028.68},null,{"$f":"I69","v":-36346.296101694919},null,{"$f":"K69","v":-55832.772917675553}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-SUM('3a. ICM_by component'!J8:J13)","v":-19028.68},null,{"$f":"-SUM('3a. ICM_by component'!K8:K13)","v":-17317.616101694919},null,{"$f":"-SUM('3a. ICM_by component'!L8:L13)","v":-19486.47681598063},null,{"$f":"-SUM('3a. ICM_by component'!M8:M13)","v":-20141.198530266342}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G66+G67-G68","v":-19028.68},null,{"$f":"I66+I67-I68","v":-36346.296101694919},null,{"$f":"K66+K67-K68","v":-55832.772917675553},null,{"$f":"M66+M67-M68","v":-75973.971447941891}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G60+G66","v":0},null,{"$f":"I60+I66","v":932405.13},null,{"$f":"K60+K66","v":1088272.2788983053},null,1114616.2620823246]
[null,null,null,"Closing Balance",null,null,{"$f":"G63+G69","v":932405.13},null,{"$f":"I63+I69","v":1088272.2788983053},null,{"$f":"K63+K69","v":1114616.2620823246},null,{"$f":"M63+M69","v":1094475.0635520583}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G73","v":932405.13},null,{"$f":"I73","v":1088272.2788983053},null,{"$f":"K73","v":1114616.2620823246},null,{"$f":"M73","v":1094475.0635520583}]
[]
[null,"Net Fixed Assets - Underground Conductor"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G82","v":781849.69},null,{"$f":"I82","v":1078700.53},null,{"$f":"K82","v":1078700.53}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G188","v":781849.69},null,{"$f":"'2. ICM_Costs'!H188","v":296850.84000000003},null,{"$f":"'2. ICM_Costs'!I188","v":0},null,{"$f":"'2. ICM_Costs'!K188","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G79+G80-G81","v":781849.69},null,{"$f":"I79+I80-I81","v":1078700.53},null,{"$f":"K79+K80-K81","v":1078700.53},null,{"$f":"M79+M80-M81","v":1078700.53}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G88","v":-15636.99},null,{"$f":"I88","v":-34242.493877551024},null,{"$f":"K88","v":-55816.504555102045}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-SUM('3a. ICM_by component'!J16:J17)","v":-15636.99},null,{"$f":"-SUM('3a. ICM_by component'!K16:K17)","v":-18605.503877551022},null,{"$f":"-SUM('3a. ICM_by component'!L16:L17)","v":-21574.010677551021},null,{"$f":"-SUM('3a. ICM_by component'!M16:M18)","v":-21574.010677551021}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G85+G86-G87","v":-15636.99},null,{"$f":"I85+I86-I87","v":-34242.493877551024},null,{"$f":"K85+K86-K87","v":-55816.504555102045},null,{"$f":"M85+M86-M87","v":-77390.515232653066}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G79+G85","v":0},null,{"$f":"I79+I85","v":766212.7},null,{"$f":"K79+K85","v":1044458.036122449},null,1022884.0254448979]
[null,null,null,"Closing Balance",null,null,{"$f":"G82+G88","v":766212.7},null,{"$f":"I82+I88","v":1044458.036122449},null,{"$f":"K82+K88","v":1022884.0254448979},null,{"$f":"M82+M88","v":1001310.0147673469}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G92","v":766212.7},null,{"$f":"I92","v":1044458.036122449},null,{"$f":"K92","v":1022884.0254448979},null,{"$f":"M92","v":1001310.0147673469}]
[]
[null,"Net Fixed Assets - U/G Injected Cable"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!F190","v":0},null,{"$f":"'2. ICM_Costs'!I190","v":0},null,{"$f":"'2. ICM_Costs'!K190","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G98+G99-G100","v":0},null,{"$f":"I98+I99-I100","v":0},null,{"$f":"K98+K99-K100","v":0},null,{"$f":"M98+M99-M100","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-(G99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G98/'3. Cost_of_Service_Parameters'!#REF!),(G98+G104)))), 0, -(G99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G98/'3. Cost_of_Service_Parameters'!#REF!),(G98+G104))))","v":0},null,{"$f":"IF(ISERROR(-(I99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I98/'3. Cost_of_Service_Parameters'!#REF!),(I98+I104)))), 0, -(I99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I98/'3. Cost_of_Service_Parameters'!#REF!),(I98+I104))))","v":0},null,{"$f":"IF(ISERROR(-(K99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K98/'3. Cost_of_Service_Parameters'!#REF!),(K98+K104)))), 0, -(K99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K98/'3. Cost_of_Service_Parameters'!#REF!),(K98+K104))))","v":0},null,{"$f":"IF(ISERROR(-(M99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M98/'3. Cost_of_Service_Parameters'!#REF!),(M98+M104)))), 0, -(M99/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M98/'3. Cost_of_Service_Parameters'!#REF!),(M98+M104))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G104+G105-G106","v":0},null,{"$f":"I104+I105-I106","v":0},null,{"$f":"K104+K105-K106","v":0},null,{"$f":"M104+M105-M106","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G98+G104","v":0},null,{"$f":"I98+I104","v":0},null,{"$f":"K98+K104","v":0},null,0]
[null,null,null,"Closing Balance",null,null,{"$f":"G101+G107","v":0},null,{"$f":"I101+I107","v":0},null,{"$f":"K101+K107","v":0},null,{"$f":"M101+M107","v":0}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G111","v":0},null,{"$f":"I111","v":0},null,{"$f":"K111","v":0},null,{"$f":"M111","v":0}]
[]
[null,"Net Fixed Assets - OH Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!F192","v":0},null,{"$f":"'2. ICM_Costs'!I192","v":0},null,{"$f":"'2. ICM_Costs'!K192","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G117+G118-G119","v":0},null,{"$f":"I117+I118-I119","v":0},null,{"$f":"K117+K118-K119","v":0},null,{"$f":"M117+M118-M119","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-(G118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G117/'3. Cost_of_Service_Parameters'!#REF!),(G117+G123)))), 0, -(G118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G117/'3. Cost_of_Service_Parameters'!#REF!),(G117+G123))))","v":0},null,{"$f":"IF(ISERROR(-(I118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I117/'3. Cost_of_Service_Parameters'!#REF!),(I117+I123)))), 0, -(I118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I117/'3. Cost_of_Service_Parameters'!#REF!),(I117+I123))))","v":0},null,{"$f":"IF(ISERROR(-(K118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K117/'3. Cost_of_Service_Parameters'!#REF!),(K117+K123)))), 0, -(K118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K117/'3. Cost_of_Service_Parameters'!#REF!),(K117+K123))))","v":0},null,{"$f":"IF(ISERROR(-(M118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M117/'3. Cost_of_Service_Parameters'!#REF!),(M117+M123)))), 0, -(M118/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M117/'3. Cost_of_Service_Parameters'!#REF!),(M117+M123))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G123+G124-G125","v":0},null,{"$f":"I123+I124-I125","v":0},null,{"$f":"K123+K124-K125","v":0},null,{"$f":"M123+M124-M125","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G117+G123","v":0},null,{"$f":"I117+I123","v":0},null,{"$f":"K117+K123","v":0},null,0]
[null,null,null,"Closing Balance",null,null,{"$f":"G120+G126","v":0},null,{"$f":"I120+I126","v":0},null,{"$f":"K120+K126","v":0},null,{"$f":"M120+M126","v":0}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G130","v":0},null,{"$f":"I130","v":0},null,{"$f":"K130","v":0},null,{"$f":"M130","v":0}]
[]
[null,"Net Fixed Assets - UG Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G139","v":36822.06},null,{"$f":"I139","v":75067.154999999999},null,{"$f":"K139","v":75067.154999999999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G194","v":36822.06},null,{"$f":"'2. ICM_Costs'!H194","v":38245.095000000001},null,{"$f":"'2. ICM_Costs'!I194","v":0},null,{"$f":"'2. ICM_Costs'!K194","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G136+G137-G138","v":36822.06},null,{"$f":"I136+I137-I138","v":75067.154999999999},null,{"$f":"K136+K137-K138","v":75067.154999999999},null,{"$f":"M136+M137-M138","v":75067.154999999999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G145","v":-736.44},null,{"$f":"I145","v":-2139.7723076923075},null,{"$f":"K145","v":-4021.1719903846151}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-SUM('3a. ICM_by component'!J21:J23)","v":-736.44},null,{"$f":"-SUM('3a. ICM_by component'!K21:K22)","v":-1403.3323076923075},null,{"$f":"-SUM('3a. ICM_by component'!L21:L22)","v":-1881.3996826923076},null,{"$f":"-SUM('3a. ICM_by component'!M21:M23)","v":-1881.3996826923076}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G142+G143-G144","v":-736.44},null,{"$f":"I142+I143-I144","v":-2139.7723076923075},null,{"$f":"K142+K143-K144","v":-4021.1719903846151},null,{"$f":"M142+M143-M144","v":-5902.5716730769227}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G136+G142","v":0},null,{"$f":"I136+I142","v":36085.619999999995},null,{"$f":"K136+K142","v":72927.382692307685},null,71045.983009615389]
[null,null,null,"Closing Balance",null,null,{"$f":"G139+G145","v":36085.619999999995},null,{"$f":"I139+I145","v":72927.382692307685},null,{"$f":"K139+K145","v":71045.983009615389},null,{"$f":"M139+M145","v":69164.583326923079}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G149","v":36085.619999999995},null,{"$f":"I149","v":72927.382692307685},null,{"$f":"K149","v":71045.983009615389},null,{"$f":"M149","v":69164.583326923079}]
[]
[null,"Net Fixed Assets - OH Services"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!F196","v":0},null,{"$f":"'2. ICM_Costs'!I196","v":0},null,{"$f":"'2. ICM_Costs'!K196","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G155+G156-G157","v":0},null,{"$f":"I155+I156-I157","v":0},null,{"$f":"K155+K156-K157","v":0},null,{"$f":"M155+M156-M157","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-(G156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G155/'3. Cost_of_Service_Parameters'!#REF!),(G155+G161)))), 0, -(G156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G155/'3. Cost_of_Service_Parameters'!#REF!),(G155+G161))))","v":0},null,{"$f":"IF(ISERROR(-(I156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I155/'3. Cost_of_Service_Parameters'!#REF!),(I155+I161)))), 0, -(I156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I155/'3. Cost_of_Service_Parameters'!#REF!),(I155+I161))))","v":0},null,{"$f":"IF(ISERROR(-(K156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K155/'3. Cost_of_Service_Parameters'!#REF!),(K155+K161)))), 0, -(K156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K155/'3. Cost_of_Service_Parameters'!#REF!),(K155+K161))))","v":0},null,{"$f":"IF(ISERROR(-(M156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M155/'3. Cost_of_Service_Parameters'!#REF!),(M155+M161)))), 0, -(M156/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M155/'3. Cost_of_Service_Parameters'!#REF!),(M155+M161))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G161+G162-G163","v":0},null,{"$f":"I161+I162-I163","v":0},null,{"$f":"K161+K162-K163","v":0},null,{"$f":"M161+M162-M163","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G155+G161","v":0},null,{"$f":"I155+I161","v":0},null,{"$f":"K155+K161","v":0},null,0]
[null,null,null,"Closing Balance",null,null,{"$f":"G158+G164","v":0},null,{"$f":"I158+I164","v":0},null,{"$f":"K158+K164","v":0},null,{"$f":"M158+M164","v":0}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G168","v":0},null,{"$f":"I168","v":0},null,{"$f":"K168","v":0},null,{"$f":"M168","v":0}]
[]
[null,"Net Fixed Assets - RTUs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!F198","v":0},null,{"$f":"'2. ICM_Costs'!I198","v":0},null,{"$f":"'2. ICM_Costs'!K198","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G174+G175-G176","v":0},null,{"$f":"I174+I175-I176","v":0},null,{"$f":"K174+K175-K176","v":0},null,{"$f":"M174+M175-M176","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-(G175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G174/'3. Cost_of_Service_Parameters'!#REF!),(G174+G180)))), 0, -(G175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G174/'3. Cost_of_Service_Parameters'!#REF!),(G174+G180))))","v":0},null,{"$f":"IF(ISERROR(-(I175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I174/'3. Cost_of_Service_Parameters'!#REF!),(I174+I180)))), 0, -(I175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I174/'3. Cost_of_Service_Parameters'!#REF!),(I174+I180))))","v":0},null,{"$f":"IF(ISERROR(-(K175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K174/'3. Cost_of_Service_Parameters'!#REF!),(K174+K180)))), 0, -(K175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K174/'3. Cost_of_Service_Parameters'!#REF!),(K174+K180))))","v":0},null,{"$f":"IF(ISERROR(-(M175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M174/'3. Cost_of_Service_Parameters'!#REF!),(M174+M180)))), 0, -(M175/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M174/'3. Cost_of_Service_Parameters'!#REF!),(M174+M180))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G180+G181-G182","v":0},null,{"$f":"I180+I181-I182","v":0},null,{"$f":"K180+K181-K182","v":0},null,{"$f":"M180+M181-M182","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G174+G180","v":0},null,{"$f":"I174+I180","v":0},null,{"$f":"K174+K180","v":0},null,0]
[null,null,null,"Closing Balance",null,null,{"$f":"G177+G183","v":0},null,{"$f":"I177+I183","v":0},null,{"$f":"K177+K183","v":0},null,{"$f":"M177+M183","v":0}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G187","v":0},null,{"$f":"I187","v":0},null,{"$f":"K187","v":0},null,{"$f":"M187","v":0}]
[]
[]
[null,"Net Fixed Assets - System Supervisory Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G197","v":2567.09},null,{"$f":"I197","v":2567.09},null,{"$f":"K197","v":2567.09}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G200","v":2567.09}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G194+G195-G196","v":2567.09},null,{"$f":"I194+I195-I196","v":2567.09},null,{"$f":"K194+K195-K196","v":2567.09},null,{"$f":"M194+M195-M196","v":2567.09}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G203","v":-85.57},null,{"$f":"I203","v":-216.17631578947368},null,{"$f":"K203","v":-346.78263157894736}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-'3a. ICM_by component'!J26","v":-85.57},null,{"$f":"-'3a. ICM_by component'!K26","v":-130.60631578947368},null,{"$f":"-'3a. ICM_by component'!L26","v":-130.60631578947368},null,{"$f":"-SUM('3a. ICM_by component'!M26)","v":-130.60631578947368}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G200+G201-G202","v":-85.57},null,{"$f":"I200+I201-I202","v":-216.17631578947368},null,{"$f":"K200+K201-K202","v":-346.78263157894736},null,{"$f":"M200+M201-M202","v":-477.38894736842104}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G194+G200","v":0},null,{"$f":"I194+I200","v":2481.52},null,{"$f":"K194+K200","v":2350.9136842105263},null,2220.3073684210526]
[null,null,null,"Closing Balance",null,null,{"$f":"G197+G203","v":2481.52},null,{"$f":"I197+I203","v":2350.9136842105263},null,{"$f":"K197+K203","v":2220.3073684210526},null,{"$f":"M197+M203","v":2089.7010526315789}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G207","v":2481.52},null,{"$f":"I207","v":2350.9136842105263},null,{"$f":"K207","v":2220.3073684210526},null,{"$f":"M207","v":2089.7010526315789}]
[]
[]
[null,"Net Fixed Assets - Distribution Station Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G217","v":473855.81999999995},null,{"$f":"I217","v":473855.81999999995},null,{"$f":"K217","v":473855.81999999995}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,{"$f":"'2. ICM_Costs'!G202","v":473855.81999999995},null,{"$f":"'2. ICM_Costs'!F202","v":0},null,{"$f":"'2. ICM_Costs'!I202","v":0},null,{"$f":"'2. ICM_Costs'!K202","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G214+G215-G216","v":473855.81999999995},null,{"$f":"I214+I215-I216","v":473855.81999999995},null,{"$f":"K214+K215-K216","v":473855.81999999995},null,{"$f":"M214+M215-M216","v":473855.81999999995}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"G223","v":-7897.6},null,{"$f":"I223","v":-21756.300193288247},null,{"$f":"K223","v":-35615.000386576488}]
[null,null,null,"Amortization expense during year",null,null,{"$f":"-SUM('3a. ICM_by component'!J28:J30)","v":-7897.6},null,{"$f":"-SUM('3a. ICM_by component'!K28:K30)","v":-13858.700193288245},null,{"$f":"-SUM('3a. ICM_by component'!L28:L30)","v":-13858.700193288245},null,{"$f":"-SUM('3a. ICM_by component'!M28:M31)","v":-13858.700193288245}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G220+G221-G222","v":-7897.6},null,{"$f":"I220+I221-I222","v":-21756.300193288247},null,{"$f":"K220+K221-K222","v":-35615.000386576488},null,{"$f":"M220+M221-M222","v":-49473.70057986473}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G214+G220","v":0},null,{"$f":"I214+I220","v":465958.22},null,{"$f":"K214+K220","v":452099.5198067117},null,438240.81961342343]
[null,null,null,"Closing Balance",null,null,{"$f":"G217+G223","v":465958.22},null,{"$f":"I217+I223","v":452099.5198067117},null,{"$f":"K217+K223","v":438240.81961342343},null,{"$f":"M217+M223","v":424382.11942013522}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G227","v":465958.22},null,{"$f":"I227","v":452099.5198067117},null,{"$f":"K227","v":438240.81961342343},null,{"$f":"M227","v":424382.11942013522}]
[]
[]
[null,"Net Fixed Assets - Transformer Station Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!F204","v":0},null,{"$f":"'2. ICM_Costs'!I204","v":0},null,{"$f":"'2. ICM_Costs'!K204","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G234+G235-G236","v":0},null,{"$f":"I234+I235-I236","v":0},null,{"$f":"K234+K235-K236","v":0},null,{"$f":"M234+M235-M236","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-(G235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G234/'3. Cost_of_Service_Parameters'!#REF!),(G234+G240)))), 0, -(G235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((G234/'3. Cost_of_Service_Parameters'!#REF!),(G234+G240))))","v":0},null,{"$f":"IF(ISERROR(-(I235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I234/'3. Cost_of_Service_Parameters'!#REF!),(I234+I240)))), 0, -(I235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((I234/'3. Cost_of_Service_Parameters'!#REF!),(I234+I240))))","v":0},null,{"$f":"IF(ISERROR(-(K235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K234/'3. Cost_of_Service_Parameters'!#REF!),(K234+K240)))), 0, -(K235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((K234/'3. Cost_of_Service_Parameters'!#REF!),(K234+K240))))","v":0},null,{"$f":"IF(ISERROR(-(M235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M234/'3. Cost_of_Service_Parameters'!#REF!),(M234+M240)))), 0, -(M235/('3. Cost_of_Service_Parameters'!#REF!)+MIN((M234/'3. Cost_of_Service_Parameters'!#REF!),(M234+M240))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G240+G241-G242","v":0},null,{"$f":"I240+I241-I242","v":0},null,{"$f":"K240+K241-K242","v":0},null,{"$f":"M240+M241-M242","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G234+G240","v":0},null,{"$f":"I234+I240","v":0},null,{"$f":"K234+K240","v":0},null,0]
[null,null,null,"Closing Balance",null,null,{"$f":"G237+G243","v":0},null,{"$f":"I237+I243","v":0},null,{"$f":"K237+K243","v":0},null,{"$f":"M237+M243","v":0}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G247","v":0},null,{"$f":"I247","v":0},null,{"$f":"K247","v":0},null,{"$f":"M247","v":0}]
[]
[]
[null,"Net Fixed Assets - Land Rights"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!F206","v":0},null,{"$f":"'2. ICM_Costs'!I206","v":0},null,{"$f":"'2. ICM_Costs'!K206","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G254+G255-G256","v":0},null,{"$f":"I254+I255-I256","v":0},null,{"$f":"K254+K255-K256","v":0},null,{"$f":"M254+M255-M256","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[null,null,null,"Amortization expense during year",null,null,{"$f":"IF(ISERROR(-(G255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((G254/'3. Cost_of_Service_Parameters'!#REF!),(G254+G260)))), 0, -(G255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((G254/'3. Cost_of_Service_Parameters'!#REF!),(G254+G260))))","v":0},null,{"$f":"IF(ISERROR(-(I255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((I254/'3. Cost_of_Service_Parameters'!#REF!),(I254+I260)))), 0, -(I255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((I254/'3. Cost_of_Service_Parameters'!#REF!),(I254+I260))))","v":0},null,{"$f":"IF(ISERROR(-(K255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((K254/'3. Cost_of_Service_Parameters'!#REF!),(K254+K260)))), 0, -(K255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((K254/'3. Cost_of_Service_Parameters'!#REF!),(K254+K260))))","v":0},null,{"$f":"IF(ISERROR(-(M255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((M254/'3. Cost_of_Service_Parameters'!#REF!),(M254+M260)))), 0, -(M255/('3. Cost_of_Service_Parameters'!#REF!*2)+MIN((M254/'3. Cost_of_Service_Parameters'!#REF!),(M254+M260))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,{"$f":"G260+G261-G262","v":0},null,{"$f":"I260+I261-I262","v":0},null,{"$f":"K260+K261-K262","v":0},null,{"$f":"M260+M261-M262","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,{"$f":"G254+G260","v":0},null,{"$f":"I254+I260","v":0},null,{"$f":"K254+K260","v":0},null,0]
[null,null,null,"Closing Balance",null,null,{"$f":"G257+G263","v":0},null,{"$f":"I257+I263","v":0},null,{"$f":"K257+K263","v":0},null,{"$f":"M257+M263","v":0}]
[null,null,null,"Incremental CAPEX",null,null,{"$f":"G267","v":0},null,{"$f":"I267","v":0},null,{"$f":"K267","v":0},null,{"$f":"M267","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",null,null,{"$f":"G23+G42+G61+G80+G99+G118+G137+G156+G175+G195+G215+G235+G255","v":2247302.96},{"$f":"H23+H42+H61+H80+H99+H118+H137+H156+H175+H195+H215+H235+H255","v":0},{"$f":"I23+I42+I61+I80+I99+I118+I137+I156+I175+I195+I215+I235+I255","v":508280.70000000007},{"$f":"J23+J42+J61+J80+J99+J118+J137+J156+J175+J195+J215+J235+J255","v":0},{"$f":"K23+K42+K61+K80+K99+K118+K137+K156+K175+K195+K215+K235+K255","v":45830.46},0,{"$f":"M23+M42+M61+M80+M99+M118+M137+M156+M175+M195+M215+M235+M255","v":0}]
[null,null,null,"Accumulated Incremental CAPEX",null,null,{"$f":"G36+G55+G74+G93+G112+G131+G150+G169+G188+G208+G228+G248+G268","v":2203902.1900000004},{"$f":"H36+H55+H74+H93+H112+H131+H150+H169+H188+H208+H228+H248+H268","v":0},{"$f":"I36+I55+I74+I93+I112+I131+I150+I169+I188+I208+I228+I248+I268","v":2660849.8798403479},{"$f":"J36+J55+J74+J93+J112+J131+J150+J169+J188+J208+J228+J248+J268","v":0},{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268","v":2649731.8947914094},0,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268","v":2592128.7280281861}]
[null,null,null,"Total Amortization",null,null,{"$f":"G29+G48+G67+G86+G105+G124+G143+G162+G181+G201+G221+G241+G261","v":-43400.770000000004},{"$f":"H29+H48+H67+H86+H105+H124+H143+H162+H181+H201+H221+H241+H261","v":0},{"$f":"I29+I48+I67+I86+I105+I124+I143+I162+I181+I201+I221+I241+I261","v":-51333.010159652331},{"$f":"J29+J48+J67+J86+J105+J124+J143+J162+J181+J201+J221+J241+J261","v":0},{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261","v":-56948.44504893804},0,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261","v":-57603.166763223751}]
[null,null,null,"Accumulated Amortization",null,null,{"$f":"G277","v":-43400.770000000004},null,{"$f":"G278+I277","v":-94733.780159652335},null,{"$f":"I278+K277","v":-151682.22520859039},null,{"$f":"K278+M277","v":-209285.39197181416}]
[]
[null,null,null,null,null,null,{"$f":"G275-'2. ICM_Costs'!G211","v":0},null,{"$f":"'2. ICM_Costs'!H211-'4. ICM_Assets_and_Rate_Base'!I275","v":0},null,{"$f":"K275-'2. ICM_Costs'!I211","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"'2. ICM_Costs'!G211","v":2247302.96},null,{"$f":"'2. ICM_Costs'!H211","v":508280.70000000007},null,{"$f":"'2. ICM_Costs'!I211","v":45830.46}]
[null,null,null,null,null,null,{"$f":"G288-G275","v":0},null,{"$f":"I288-I275","v":0},null,{"$f":"K288-K275","v":0}]

{"sheet":"5. UCC_Calculation","index":5,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,2012,null,2013,null,2014,null,2015]
[null,null,null,"Actual",null,"Actual",null,"Actual",null,"Forecast"]
[]
["Opening UCC",null,null,0,null,{"$f":"D26-D31","v":2154946.4352000002},null,{"$f":"F26-F31","v":2470500.1923840004},null,{"$f":"H26-H31","v":2316857.4185932805}]
["Capital Additions",null,null,{"$f":"'4. ICM_Assets_and_Rate_Base'!G23+'4. ICM_Assets_and_Rate_Base'!G42+'4. ICM_Assets_and_Rate_Base'!G61+'4. ICM_Assets_and_Rate_Base'!G80+'4. ICM_Assets_and_Rate_Base'!G137+'4. ICM_Assets_and_Rate_Base'!G215","v":2244735.87},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!I23+'4. ICM_Assets_and_Rate_Base'!I42+'4. ICM_Assets_and_Rate_Base'!I61+'4. ICM_Assets_and_Rate_Base'!I80+'4. ICM_Assets_and_Rate_Base'!I137","v":508280.70000000007},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!K61","v":45830.46},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!M61","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D23:D24)-D25","v":2244735.87},null,{"$f":"SUM(F23:F24)-F25","v":2663227.1352000004},null,{"$f":"SUM(H23:H24)-H25","v":2516330.6523840004},null,{"$f":"SUM(J23:J24)-J25","v":2316857.4185932805}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF(((D24-D25)/2)<0, 0, (D24-D25)/2)","v":1122367.9350000001},null,{"$f":"IF(((F24-F25)/2)<0, 0, (F24-F25)/2)","v":254140.35000000003},null,{"$f":"IF(((H24-H25)/2)<0, 0, (H24-H25)/2)","v":22915.23},null,{"$f":"IF(((J24-J25)/2)<0, 0, (J24-J25)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D27+D23","v":1122367.9350000001},null,{"$f":"F27+F23","v":2409086.7852000003},null,{"$f":"H27+H23","v":2493415.4223840004},null,{"$f":"J27+J23","v":2316857.4185932805}]
["CCA Rate Class",null,null,47,null,{"$f":"'3. Cost_of_Service_Parameters'!G46","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!I46","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!K46","v":47}]
["CCA Rate ",null,null,0.08,null,{"$f":"'3. Cost_of_Service_Parameters'!G47","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!I47","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!K47","v":0.08}]
["CCA",null,null,{"$f":"D28*D30","v":89789.434800000003},null,{"$f":"F28*F30","v":192726.94281600002},null,{"$f":"H28*H30","v":199473.23379072003},null,{"$f":"J28*J30","v":185348.59348746244}]
["Closing UCC",null,null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":2154946.4352000002},null,{"$f":"IF((F26-F31)<0, 0, F26-F31)","v":2470500.1923840004},null,{"$f":"IF((H26-H31)<0, 0, H26-H31)","v":2316857.4185932805},null,{"$f":"IF((J26-J31)<0, 0, J26-J31)","v":2131508.825105818}]
[]
["UCC/Class 8",null,null,{"$f":"D20","v":2012},null,{"$f":"F20","v":2013},null,2014,null,{"$f":"J20","v":2015}]
[null,null,null,{"$f":"D21","v":"Actual"},null,"Actual",null,"Actual",null,{"$f":"J21","v":"Forecast"}]
[]
["Opening UCC",null,null,0,null,{"$f":"D40-D45","v":2310.3810000000003},null,{"$f":"F40-F45","v":1848.3048000000003},null,{"$f":"H40-H45","v":1478.6438400000002}]
["Capital Additions RTU's",null,null,{"$f":"'4. ICM_Assets_and_Rate_Base'!G195","v":2567.09},null,{"$f":"'2. ICM_Costs'!I198+'2. ICM_Costs'!I200","v":0},null,{"$f":"'2. ICM_Costs'!K198","v":0},null,{"$f":"'2. ICM_Costs'!M198","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Before Half Year Rule",null,null,{"$f":"SUM(D37:D38)-D39","v":2567.09},null,{"$f":"SUM(F37:F38)-F39","v":2310.3810000000003},null,{"$f":"SUM(H37:H38)-H39","v":1848.3048000000003},null,{"$f":"SUM(J37:J38)-J39","v":1478.6438400000002}]
["Half Year Rule (1/2 Additions - Disposals)",null,null,{"$f":"IF((SUM(D38:D38)/2)<0, 0, SUM(D38:D38)/2)","v":1283.5450000000001},null,{"$f":"IF((SUM(F38:F38)/2)<0, 0, SUM(F38:F38)/2)","v":0},null,{"$f":"IF((SUM(H38:H38)/2)<0, 0, SUM(H38:H38)/2)","v":0},null,{"$f":"IF((SUM(J38:J38)/2)<0, 0, SUM(J38:J38)/2)","v":0}]
["Reduced UCC",null,null,{"$f":"D41+D37","v":1283.5450000000001},null,{"$f":"F41+F37","v":2310.3810000000003},null,{"$f":"H41+H37","v":1848.3048000000003},null,{"$f":"J41+J37","v":1478.6438400000002}]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G73","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!G70","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!I70","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!K70","v":8}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G74","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!G71","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!I71","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!K71","v":0.2}]
["CCA",null,null,{"$f":"D44*D42","v":256.709},null,{"$f":"F44*F42","v":462.07620000000009},null,{"$f":"H44*H42","v":369.6609600000001},null,{"$f":"J44*J42","v":295.72876800000006}]
["Closing UCC",null,null,{"$f":"IF((D40-D45)<0, 0, D40-D45)","v":2310.3810000000003},null,{"$f":"IF((F40-F45)<0, 0, F40-F45)","v":1848.3048000000003},null,{"$f":"IF((H40-H45)<0, 0, H40-H45)","v":1478.6438400000002},null,{"$f":"IF((J40-J45)<0, 0, J40-J45)","v":1182.9150720000002}]
[]
[]
[]
[null,null,null,{"$f":"D24+D38","v":2247302.96},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!I275","v":508280.70000000007},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!K275","v":45830.46},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!M275","v":0}]
[null,null,null,{"$f":"D50-'4. ICM_Assets_and_Rate_Base'!G275","v":0},null,{"$f":"F50-'4. ICM_Assets_and_Rate_Base'!I275","v":0},null,{"$f":"H50-'4. ICM_Assets_and_Rate_Base'!K275","v":0},null,{"$f":"J50-'4. ICM_Assets_and_Rate_Base'!M275","v":0}]

{"sheet":"6. ICMIRR ","index":6,"n_rows":87,"n_cols":19,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6:",null,"Incremental Capital Adjustment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Return on Rate Base",null,"2012 Actual",null,"2013 Actual",null,"2014 Actual",null,"2015 Actual"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"'4. ICM_Assets_and_Rate_Base'!G23+'4. ICM_Assets_and_Rate_Base'!G42+'4. ICM_Assets_and_Rate_Base'!G61+'4. ICM_Assets_and_Rate_Base'!G80+'4. ICM_Assets_and_Rate_Base'!G99+'4. ICM_Assets_and_Rate_Base'!G118+'4. ICM_Assets_and_Rate_Base'!G137+'4. ICM_Assets_and_Rate_Base'!G195+'4. ICM_Assets_and_Rate_Base'!G215","v":2247302.96},null,{"$f":"F29+('4. ICM_Assets_and_Rate_Base'!I23+'4. ICM_Assets_and_Rate_Base'!I42+'4. ICM_Assets_and_Rate_Base'!I61+'4. ICM_Assets_and_Rate_Base'!I80+'4. ICM_Assets_and_Rate_Base'!I99+'4. ICM_Assets_and_Rate_Base'!I118+'4. ICM_Assets_and_Rate_Base'!I137+'4. ICM_Assets_and_Rate_Base'!I195+'4. ICM_Assets_and_Rate_Base'!I215)","v":2712182.89},null,{"$f":"H29+('4. ICM_Assets_and_Rate_Base'!K23+'4. ICM_Assets_and_Rate_Base'!K42+'4. ICM_Assets_and_Rate_Base'!K61+'4. ICM_Assets_and_Rate_Base'!K80+'4. ICM_Assets_and_Rate_Base'!K99+'4. ICM_Assets_and_Rate_Base'!K118+'4. ICM_Assets_and_Rate_Base'!K137+'4. ICM_Assets_and_Rate_Base'!K195+'4. ICM_Assets_and_Rate_Base'!K215)","v":2706680.3398403479},null,{"$f":"J29+('4. ICM_Assets_and_Rate_Base'!M23+'4. ICM_Assets_and_Rate_Base'!M42+'4. ICM_Assets_and_Rate_Base'!M61+'4. ICM_Assets_and_Rate_Base'!M80+'4. ICM_Assets_and_Rate_Base'!M99+'4. ICM_Assets_and_Rate_Base'!M118+'4. ICM_Assets_and_Rate_Base'!M137+'4. ICM_Assets_and_Rate_Base'!M195+'4. ICM_Assets_and_Rate_Base'!M215)","v":2649731.8947914098},"B"]
[null,null,"Depreciation Expense",null,null,{"$f":"-('4. ICM_Assets_and_Rate_Base'!G29+'4. ICM_Assets_and_Rate_Base'!G48+'4. ICM_Assets_and_Rate_Base'!G67+'4. ICM_Assets_and_Rate_Base'!G86+'4. ICM_Assets_and_Rate_Base'!G143+'4. ICM_Assets_and_Rate_Base'!G201+'4. ICM_Assets_and_Rate_Base'!G221)","v":43400.770000000004},null,{"$f":"-('4. ICM_Assets_and_Rate_Base'!I29+'4. ICM_Assets_and_Rate_Base'!I48+'4. ICM_Assets_and_Rate_Base'!I67+'4. ICM_Assets_and_Rate_Base'!I86+'4. ICM_Assets_and_Rate_Base'!I143+'4. ICM_Assets_and_Rate_Base'!I201+'4. ICM_Assets_and_Rate_Base'!I221)","v":51333.010159652331},null,{"$f":"-('4. ICM_Assets_and_Rate_Base'!K29+'4. ICM_Assets_and_Rate_Base'!K48+'4. ICM_Assets_and_Rate_Base'!K67+'4. ICM_Assets_and_Rate_Base'!K86+'4. ICM_Assets_and_Rate_Base'!K143+'4. ICM_Assets_and_Rate_Base'!K201+'4. ICM_Assets_and_Rate_Base'!K221)","v":56948.44504893804},null,{"$f":"-('4. ICM_Assets_and_Rate_Base'!M29+'4. ICM_Assets_and_Rate_Base'!M48+'4. ICM_Assets_and_Rate_Base'!M67+'4. ICM_Assets_and_Rate_Base'!M86+'4. ICM_Assets_and_Rate_Base'!M143+'4. ICM_Assets_and_Rate_Base'!M201+'4. ICM_Assets_and_Rate_Base'!M221)","v":57603.166763223751},"C"]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"F27-F28","v":2203902.19},null,{"$f":"H27-H28","v":2660849.8798403479},null,{"$f":"J27-J28","v":2649731.8947914098},null,{"$f":"L27-L28","v":2592128.7280281861},"D = B - C"]
[]
[null,null,"Deemed ShortTerm Debt %","E",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},{"$f":"F29*E31","v":88156.087599999999},{"$f":"'3. Cost_of_Service_Parameters'!I22","v":0.04},{"$f":"H29*G31","v":106433.99519361393},{"$f":"'3. Cost_of_Service_Parameters'!K22","v":0.04},{"$f":"J29*I31","v":105989.2757916564},{"$f":"'3. Cost_of_Service_Parameters'!M22","v":0.04},{"$f":"L29*K31","v":103685.14912112744},"G = D * E"]
[null,null,"Deemed Long Term Debt %","F",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},{"$f":"F29*E32","v":1234185.2263999998},{"$f":"'3. Cost_of_Service_Parameters'!I23","v":0.55999999999999994},{"$f":"H29*G32","v":1490075.9327105947},{"$f":"'3. Cost_of_Service_Parameters'!K23","v":0.55999999999999994},{"$f":"J29*I32","v":1483849.8610831893},{"$f":"'3. Cost_of_Service_Parameters'!M23","v":0.55999999999999994},{"$f":"L29*K32","v":1451592.0876957842},"H = D * F"]
[]
[null,null,"Short Term Interest","I",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":2.46E-2},{"$f":"E34*F31","v":2168.6397549600001},{"$f":"'3. Cost_of_Service_Parameters'!I29","v":2.46E-2},{"$f":"G34*H31","v":2618.2762817629027},{"$f":"'3. Cost_of_Service_Parameters'!K29","v":2.46E-2},{"$f":"I34*J31","v":2607.3361844747474},{"$f":"'3. Cost_of_Service_Parameters'!M29","v":2.46E-2},{"$f":"K34*L31","v":2550.6546683797351},"K = G * I"]
[null,null,"Long Term Interest","J",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":5.0099999999999999E-2},{"$f":"E35*F32","v":61832.679842639991},{"$f":"'3. Cost_of_Service_Parameters'!I30","v":5.0099999999999999E-2},{"$f":"G35*H32","v":74652.8042288008},{"$f":"'3. Cost_of_Service_Parameters'!K30","v":5.0099999999999999E-2},{"$f":"I35*J32","v":74340.87804026778},{"$f":"'3. Cost_of_Service_Parameters'!M30","v":5.0099999999999999E-2},{"$f":"K35*L32","v":72724.76359355879},"L = H * J"]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":64001.319597599992},null,{"$f":"SUM(H34:H35)","v":77271.080510563697},null,{"$f":"SUM(J34:J35)","v":76948.214224742522},null,{"$f":"SUM(L34:L35)","v":75275.418261938525},"M = K + L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aaa"]
[null,null,"Deemed Equity %","N",{"$f":"'3. Cost_of_Service_Parameters'!G24","v":0.40000000000000008},{"$f":"E40*F29","v":881560.87600000016},{"$f":"'3. Cost_of_Service_Parameters'!I24","v":0.40000000000000008},{"$f":"G40*H29","v":1064339.9519361393},{"$f":"'3. Cost_of_Service_Parameters'!K24","v":0.40000000000000008},{"$f":"I40*J29","v":1059892.7579165641},{"$f":"'3. Cost_of_Service_Parameters'!M24","v":0.40000000000000008},{"$f":"K40*L29","v":1036851.4912112746},"P = D * N"]
[]
[null,null,"Return on Rate Base -Equity","O",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":9.5799999999999996E-2},{"$f":"F40*E42","v":84453.531920800015},{"$f":"'3. Cost_of_Service_Parameters'!I31","v":9.5799999999999996E-2},{"$f":"H40*G42","v":101963.76739548214},{"$f":"'3. Cost_of_Service_Parameters'!K31","v":9.5799999999999996E-2},{"$f":"J40*I42","v":101537.72620840684},{"$f":"'3. Cost_of_Service_Parameters'!M31","v":9.5799999999999996E-2},{"$f":"L40*K42","v":99330.372858040108},"Q = P * O"]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":148454.85151840001},null,{"$f":"H37+H42","v":179234.84790604585},null,{"$f":"J37+J42","v":178485.94043314934},null,{"$f":"L37+L42","v":174605.79111997865},"R = M + Q"]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental","C",null,{"$f":"F28","v":43400.770000000004},null,{"$f":"H28","v":51333.010159652331},null,{"$f":"J28","v":56948.44504893804},null,{"$f":"L28","v":57603.166763223751},"S"]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income","O",null,{"$f":"F42","v":84453.531920800015},null,{"$f":"H42","v":101963.76739548214},null,{"$f":"J42","v":101537.72620840684},null,{"$f":"L42","v":99330.372858040108},"T "]
[]
[null,null,"Add Back Amortization Expense","S",null,{"$f":"F49","v":43400.770000000004},null,{"$f":"H49","v":51333.010159652331},null,{"$f":"J49","v":56948.44504893804},null,{"$f":"L49","v":57603.166763223751},"U"]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'5. UCC_Calculation'!D31+'5. UCC_Calculation'!D45","v":90046.143800000005},null,{"$f":"'5. UCC_Calculation'!F31+'5. UCC_Calculation'!F45","v":193189.01901600003},null,{"$f":"'5. UCC_Calculation'!H31+'5. UCC_Calculation'!H45","v":199842.89475072004},null,{"$f":"'5. UCC_Calculation'!J31+'5. UCC_Calculation'!J45","v":185644.32225546244},"V"]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F54+F56-F58","v":37808.158120800013},null,{"$f":"H54+H56-H58","v":-39892.241460865567},null,{"$f":"J54+J56-J58","v":-41356.723493375146},null,{"$f":"L54+L56-L58","v":-28710.782634198578},"W = T + U - V"]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)","X",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.24060000000000001},null,{"$f":"'3. Cost_of_Service_Parameters'!I40","v":0.26500000000000001},null,{"$f":"'3. Cost_of_Service_Parameters'!K40","v":0.24229999999999999},null,{"$f":"'3. Cost_of_Service_Parameters'!M40","v":0.24229999999999999}]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"E62*F60","v":9096.6428438644834},null,{"$f":"G62*H60","v":-10571.443987129376},null,{"$f":"I62*J60","v":-10020.734102444798},null,{"$f":"K62*L60","v":-6956.6226322663151},"Y = W * X"]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F64*E62","v":2188.652268233795},null,{"$f":"H64*G62","v":-2801.4326565892848},null,{"$f":"J64*I62","v":-2428.0238730223746},null,{"$f":"L64*K62","v":-1685.589663798128},"Z = Y / ( 1 - X ) "]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":2247302.96},null,{"$f":"H27","v":2712182.89},null,{"$f":"J27","v":2706680.3398403479},null,{"$f":"L27","v":2649731.8947914098},"AA"]
[]
[null,null,"Less : Available Capital Exemption (if any)",null,null,null,null,null,null,null,null,null,"AB"]
[]
[null,null,"Incremental Capital CAPEX subject to OCT",null,null,{"$f":"SUM(F70:F73)","v":2247302.96},null,{"$f":"SUM(H70:H73)","v":2712182.89},null,{"$f":"SUM(J70:J73)","v":2706680.3398403479},null,{"$f":"SUM(L70:L73)","v":2649731.8947914098},"AC = AA - AB"]
[]
[null,null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)","AD",0]
[]
[null,null,"Incremental Ontario Capital Tax",null,null,{"$f":"E76*F74","v":0},null,{"$f":"G76*H74","v":0},null,{"$f":"I76*J74","v":0},null,{"$f":"K76*L74","v":0},"AE = AC * AD"]
[]
[]
[null,null,"Incremental Revenue Requirement"]
[null,null,"Return on Rate Base - Total","Q",null,{"$f":"F44","v":148454.85151840001},null,{"$f":"H44","v":179234.84790604585},null,{"$f":"J44","v":178485.94043314934},null,{"$f":"L44","v":174605.79111997865},"AF"]
[null,null,"Amortization Expense - Total","S",null,{"$f":"F49","v":43400.770000000004},null,{"$f":"H49","v":51333.010159652331},null,{"$f":"J49","v":56948.44504893804},null,{"$f":"L49","v":57603.166763223751},"AG"]
[null,null,"Incremental Grossed Up PIL's","Z",null,{"$f":"F66","v":2188.652268233795},null,{"$f":"H66","v":-2801.4326565892848},null,{"$f":"J66","v":-2428.0238730223746},null,{"$f":"L66","v":-1685.589663798128},"AH"]
[null,null,"Incremental Ontario Capital Tax","AE",null,{"$f":"F78","v":0},null,{"$f":"H78","v":0},null,{"$f":"J78","v":0},null,{"$f":"L78","v":0},"AI"]
[]
[null,null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(F82:F85)","v":194044.27378663383},null,{"$f":"SUM(H82:H85)","v":227766.4254091089},null,{"$f":"SUM(J82:J85)","v":233006.361609065},null,{"$f":"SUM(L82:L85)","v":230523.36821940428},"AJ = AF + AG + AH + AI"]

{"sheet":"7. Funding Adder Revs","index":7,"n_rows":65,"n_cols":17,"rows_kept":65,"cut":false,"hidden":false,"merged":[[12,1,12,13],[18,5,18,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the funding adder revenues.\n"]
[]
[]
[]
[null,"Sheet 7: ICM Funding Adder Revenues"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Account 1511 - Sub-account ICM Funding Adder Revenues"]
[]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Funding Adder Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)",null,"Board Approved ICM Funding Adder ","Board Approved ICM Funding Adder \n(Cumm.)"]
[]
[null,"2006 Q1"]
[null,"2006 Q2",4.1399999999999999E-2,4.6800000000000001E-2]
[null,"2006 Q3",4.5900000000000003E-2,5.0500000000000003E-2,null,"2012-05-01",{"$f":"YEAR(F26)","v":2012},{"$f":"IF(MONTH(F26)=0,\"\",IF(MONTH(F26)<4,\"Q1\",IF(MONTH(F26)<7,\"Q2\",IF(MONTH(F26)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G26,\" \",H26)","v":"2012 Q2"},0,null,{"$f":"VLOOKUP(I26,$B$24:$E$63,2)","v":1.47E-2},null,null,null,20662.64,{"$f":"P26","v":20662.64}]
[null,"2006 Q4",4.5900000000000003E-2,4.7199999999999999E-2,null,"2012-06-01",{"$f":"YEAR(F27)","v":2012},{"$f":"IF(MONTH(F27)=0,\"\",IF(MONTH(F27)<4,\"Q1\",IF(MONTH(F27)<7,\"Q2\",IF(MONTH(F27)<10,\"Q3\",\"Q4\"))))","v":"Q2"},{"$f":"CONCATENATE(G27,\" \",H27)","v":"2012 Q2"},0,6291.18,{"$f":"VLOOKUP(I27,$B$24:$E$63,2)","v":1.47E-2},{"$f":"ROUND(J27*L27/12,2)","v":0},{"$f":"K27+M27","v":6291.18},null,20662.64,{"$f":"P27+Q26","v":41325.279999999999}]
[null,"2007 Q1",4.5900000000000003E-2,4.7199999999999999E-2,null,"2012-07-01",{"$f":"YEAR(F28)","v":2012},{"$f":"IF(MONTH(F28)=0,\"\",IF(MONTH(F28)<4,\"Q1\",IF(MONTH(F28)<7,\"Q2\",IF(MONTH(F28)<10,\"Q3\",\"Q4\"))))","v":"Q3"},{"$f":"CONCATENATE(G28,\" \",H28)","v":"2012 Q3"},{"$f":"J27+K27","v":6291.18},18032.189999999999,{"$f":"VLOOKUP(I28,$B$24:$E$63,2)","v":1.47E-2},{"$f":"ROUND(J28*L28/12,2)","v":7.71},{"$f":"N27+K28+M28","v":24331.079999999998},null,20662.64,{"$f":"Q27+P28","v":61987.92}]
[null,"2007 Q2",4.5900000000000003E-2,4.7199999999999999E-2,null,"2012-08-01",2012,"Q3","2012 Q3",{"$f":"J28+K28","v":24323.37},19687.18,1.47E-2,29.8,{"$f":"N28+K29+M29","v":44048.06},null,20662.64,{"$f":"Q28+P29","v":82650.559999999998}]
[null,"2007 Q3",4.5900000000000003E-2,5.1799999999999999E-2,null,"2012-09-01",2012,"Q3","2012 Q3",44010.55,16898.77,1.47E-2,53.91,61000.740000000005,null,20662.64,103313.2]
[null,"2007 Q4",5.1400000000000001E-2,5.1799999999999999E-2,null,"2012-10-01",2012,"Q4","2012 Q4",60909.320000000007,20403.150000000001,1.47E-2,74.61,81478.500000000015,null,20662.64,123975.84]
[null,"2008 Q1",5.1400000000000001E-2,5.1799999999999999E-2,null,"2012-11-01",2012,"Q4","2012 Q4",81312.47,18961.77,1.47E-2,99.61,100539.88000000002,null,20662.64,144638.47999999998]
[null,"2008 Q2",4.0800000000000003E-2,5.1799999999999999E-2,null,"2012-12-01",2012,"Q4","2012 Q4",100274.24000000001,16724.88,1.47E-2,122.84,117387.60000000002,null,20662.64,165301.12]
[null,"2008 Q3",3.3500000000000002E-2,5.4300000000000001E-2,null,"2013-01-01",2013,"Q1","2013 Q1",116999.12000000001,26534,1.47E-2,143.32,144064.92000000004,null,20662.64,185963.76]
[null,"2008 Q4",3.3500000000000002E-2,5.4300000000000001E-2,null,"2013-02-01",2013,"Q1","2013 Q1",143533.12,21480.37,1.47E-2,175.83,165721.12000000002,null,20662.64,206626.40000000002]
[null,"2009 Q1",2.4500000000000001E-2,6.6100000000000006E-2,null,"2013-03-01",2013,"Q1","2013 Q1",165013.49,28116.54,1.47E-2,202.14,194039.80000000005,null,20662.64,227289.04000000004]
[null,"2009 Q2",0.01,6.6100000000000006E-2,null,"2013-04-01",2013,"Q2","2013 Q2",193130.03,23170.48,1.47E-2,236.58,217446.86000000004,null,20662.64,247951.68000000005]
[null,"2009 Q3",5.4999999999999997E-3,5.67E-2,null,"2013-05-01",2013,"Q2","2013 Q2",216300.51,19997.87,1.47E-2,264.97000000000003,237709.70000000004,null,20662.64,268614.32000000007]
[null,"2009 Q4",5.4999999999999997E-3,4.6600000000000003E-2,null,"2013-06-01",2013,"Q2","2013 Q2",236298.38,12729.33,1.47E-2,289.47000000000003,250728.50000000003,null,20662.64,289276.96000000008]
[null,"2010 Q1",5.4999999999999997E-3,4.3400000000000001E-2,null,"2013-07-01",2013,"Q3","2013 Q3",249027.71,19785.680000000099,1.47E-2,305.06,270819.24000000011,null,20662.64,309939.60000000009]
[null,"2010 Q2",5.4999999999999997E-3,4.3400000000000001E-2,null,"2013-08-01",2013,"Q3","2013 Q3",268813.39000000007,17753.130000000201,1.47E-2,329.3,288901.67000000027,null,20662.64,330602.24000000011]
[null,"2010 Q3",8.8999999999999999E-3,4.6600000000000003E-2,null,"2013-09-01",2013,"Q3","2013 Q3",286566.52000000025,18558.39,1.47E-2,351.04,307811.10000000027,null,20662.64,351264.88000000012]
[null,"2010 Q4",1.2E-2,4.0099999999999997E-2,null,"2013-10-01",2013,"Q4","2013 Q4",305124.91000000027,18734.179999999898,1.47E-2,373.78,326919.06000000017,null,20662.64,371927.52000000014]
[null,"2011 Q1",1.47E-2,4.2900000000000001E-2,null,"2013-11-01",2013,"Q4","2013 Q4",323859.09000000014,16500.96,1.47E-2,396.73,343816.75000000017,null,20662.64,392590.16000000015]
[null,"2011 Q2",1.47E-2,4.2900000000000001E-2,null,"2013-12-01",2013,"Q4","2013 Q4",340360.05000000016,19043.5899999998,1.47E-2,416.94,363277.27999999997,null,20662.64,413252.80000000016]
[null,"2011 Q3",1.47E-2,4.2900000000000001E-2,null,"2014-01-01",2014,"Q1","2014 Q1",359403.63999999996,28807.4,1.47E-2,440.27,392524.95,null,20662.64,433915.44000000018]
[null,"2011 Q4",{"$f":"C46","v":1.47E-2},3.9199999999999999E-2,null,"2014-02-01",2014,"Q1","2014 Q1",388211.04,23153,1.47E-2,475.56,416153.51,null,20662.64,454578.08000000019]
[null,"2012 Q1",1.47E-2,3.9199999999999999E-2,null,"2014-03-01",2014,"Q1","2014 Q1",411364.04,29343.740000000202,1.47E-2,503.92,446001.17000000022,null,20662.64,475240.7200000002]
[null,"2012 Q2",1.47E-2,3.2300000000000002E-2,null,"2014-04-01",2014,"Q2","2014 Q2",440707.7800000002,21520.0899999998,1.47E-2,539.87,468061.13,null,20662.64,495903.36000000022]
[null,"2012 Q3",1.47E-2,3.2300000000000002E-2,null,"2014-05-01",2014,"Q2","2014 Q2",462227.87,19855.240000000002,1.47E-2,566.23,488482.6,null,20662.64,516566.00000000023]
[null,"2012 Q4",1.47E-2,3.6999999999999998E-2,null,"2014-06-01",2014,"Q2","2014 Q2",{"$f":"J50+K50","v":482083.11},16851,1.47E-2,590.54999999999995,505924.14999999997,null,20662.64,537228.64000000025]
[null,"2013 Q1",1.47E-2,3.6999999999999998E-2,null,"2014-07-01",2014,"Q3","2014 Q3",498934.11,17498.800000000101,1.47E-2,611.19000000000005,524034.14000000007,null,20662.64,557891.28000000026]
[null,"2013 Q2",1.47E-2,3.1699999999999999E-2,null,"2014-08-01",2014,"Q3","2014 Q3",516432.91000000009,16434.509999999998,1.47E-2,632.63,541101.28,null,20662.64,578553.92000000027]
[null,"2013 Q3",1.47E-2,3.1699999999999999E-2,null,"2014-09-01",2014,"Q3","2014 Q3",532867.42000000004,18733.8599999998,1.47E-2,652.76,560487.89999999979,null,20662.64,599216.56000000029]
[null,"2013 Q4",1.47E-2,3.1699999999999999E-2,null,"2014-10-01",2014,"Q4","2014 Q4",551601.2799999998,18342.189999999999,1.47E-2,675.71,579505.7999999997,null,20662.64,619879.2000000003]
[null,"2014 Q1",1.47E-2,2.8899999999999999E-2,null,"2014-11-01",2014,"Q4","2014 Q4",569943.46999999974,15669.1599999999,1.47E-2,698.18,595873.13999999966,null,20662.64,640541.84000000032]
[null,"2014 Q2",1.47E-2,2.8899999999999999E-2,null,"2014-12-01",2014,"Q4","2014 Q4",585612.62999999966,19410.759999999998,1.47E-2,717.38,616001.27999999968,null,20662.64,661204.48000000033]
[null,"2014 Q3",{"$f":"C57","v":1.47E-2},2.8899999999999999E-2,null,"2015-01-01",2015,"Q1","2015 Q1",605023.38999999966,25424.82,1.47E-2,741.15,642167.24999999965,null,20662.64,681867.12000000034]
[null,"2014 Q4",{"$f":"C57","v":1.47E-2},2.8899999999999999E-2,null,"2015-02-01",2015,"Q1","2015 Q1",630448.20999999961,35404.300000000003,1.47E-2,772.3,678343.84999999974,null,20662.64,702529.76000000036]
[null,"2015 Q1",{"$f":"C59","v":1.47E-2},2.8899999999999999E-2,null,"2015-03-01",2015,"Q1","2015 Q1",665852.50999999966,32076.81,1.47E-2,815.67,711236.32999999984,null,20662.64,723192.40000000037]
[null,"2015 Q2",1.0999999999999999E-2,2.8899999999999999E-2,null,"2015-04-01",2015,"Q2","2015 Q2",697929.31999999972,30000,1.0999999999999999E-2,639.77,741876.09999999986,null,20662.64,743855.04000000039]
[null,"2015 Q3",1.0999999999999999E-2,2.8899999999999999E-2,null,"2015-05-01",2015,"Q2","2015 Q2",727929.31999999972,15000,1.0999999999999999E-2,667.27,757543.36999999988]
[null,"2015 Q4",1.0999999999999999E-2,2.8899999999999999E-2]
[]
[null,null,null,null,null,"Total Funding Adder Revenues Collected",null,null,null,null,{"$f":"SUM(K26:K62)","v":742929.31999999972},null,{"$f":"SUM(M27:M62)","v":14614.049999999997},{"$f":"K65+M65","v":757543.36999999976}]

{"sheet":"8. Opex Interest Annual","index":8,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the interest on amortization/depreciation expense, in the absence of monthly data."]
[]
[]
[null,"Sheet 8: Interest on Amortization (Annual Data) "]
[]
[]
[]
[]
[null,"Year",null,"OM&A",null,"Amortization Expense",null,"Cumulative OM&A and Amortization Expense",null,"Average Cumulative OM&A and Amortization Expense",null,"Average Annual Prescribed Interest Rate for Deferral and Variance Accounts (from Sheets 8A and 8B)",null,"Simple Interest on OM&A and Amortization Expenses"]
[null,null,null,null,null,"(from Sheet 6)"]
[null,2012,null,0,null,{"$f":"'6. ICMIRR '!F28","v":43400.770000000004},null,{"$f":"D23+F23","v":43400.770000000004},null,{"$f":"H23/2","v":21700.385000000002},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C48:C51)","v":1.47E-2},null,{"$f":"J23*L23","v":318.99565950000004}]
[null,2013,null,0,null,{"$f":"'6. ICMIRR '!H28","v":51333.010159652331},null,{"$f":"H23+F24","v":94733.780159652335},null,{"$f":"H24/2","v":47366.890079826167},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C52:C55)","v":1.47E-2},null,696.29328417344459]
[null,2014,null,0,null,{"$f":"'6. ICMIRR '!J28","v":56948.44504893804},null,{"$f":"H24+F25","v":151682.22520859039},null,{"$f":"H25/2","v":75841.112604295195},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C56:C59)","v":1.47E-2},null,1114.8643552831393]
[null,2015,null,0,null,{"$f":"'6. ICMIRR '!L28","v":57603.166763223751},null,209285.39197181416,null,{"$f":"(H26+H25)/2","v":180483.80859020227},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C60:C63)","v":1.1924999999999998E-2},null,2152.2694174381618]
[null,"Cumulative Interest to 2014",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N25)","v":2130.153298956584}]
[null,"Cumulative Interest to 2015",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N26)","v":4282.4227163947453}]

{"sheet":"9. True-up Amount","index":9,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,16],[19,2,19,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the ICM Incremental Revenue Requirement."]
[]
[]
[null,"Sheet 9: ICM Incremental Revenue Requirement True-up"]
[null,null," "]
[]
[null,null,null,null,null,null,"2012 Actual",null,"2013 Actual",null,"2014 Actual",null,"2015 Forecast",null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,{"$f":"'6. ICMIRR '!F87","v":194044.27378663383},null,{"$f":"'6. ICMIRR '!H87","v":227766.4254091089},null,{"$f":"'6. ICMIRR '!J87","v":233006.361609065},null,{"$f":"'6. ICMIRR '!L87","v":230523.36821940428},null,{"$f":"SUM(G22:M22)","v":885340.42902421195},null,{"$f":"O22-SUM('6. ICMIRR '!F87:L87)","v":0}]
[]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,{"$f":"'8. Opex Interest Annual'!N23","v":318.99565950000004},null,{"$f":"'8. Opex Interest Annual'!N24","v":696.29328417344459},null,{"$f":"'8. Opex Interest Annual'!N25","v":1114.8643552831393},null,{"$f":"'8. Opex Interest Annual'!N26","v":2152.2694174381618},null,{"$f":"SUM(G24:M24)","v":4282.4227163947453},null,{"$f":"SUM('8. Opex Interest Annual'!N23:N26)-O24","v":0}]
[]
[]
[null,null,"ICM Funding Adder Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Funding Adder Revs'!K26:K33)","v":116999.12000000001},null,{"$f":"SUM('7. Funding Adder Revs'!K34:K45)","v":242404.52000000002},null,{"$f":"SUM('7. Funding Adder Revs'!K46:K57)","v":245619.74999999985},null,{"$f":"SUM('7. Funding Adder Revs'!K58:K62)","v":137905.93},null,{"$f":"SUM(G27:M27)","v":742929.31999999983},null,{"$f":"O27-'7. Funding Adder Revs'!K65","v":0}]
[]
[null,null,"ICM Funding Adder Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Funding Adder Revs'!M27:M33)","v":388.48},null,{"$f":"SUM('7. Funding Adder Revs'!M34:M45)","v":3485.16},null,{"$f":"SUM('7. Funding Adder Revs'!M46:M57)","v":7104.25},null,{"$f":"SUM('7. Funding Adder Revs'!M58:M62)","v":3636.16},null,{"$f":"SUM(G29:M29)","v":14614.05},null,{"$f":"O29-'7. Funding Adder Revs'!M65","v":0}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":76975.669446133834},null,{"$f":"(I22+I24)-(I27+I29)","v":-17426.961306717683},null,{"$f":"(K22+K24)-(K27+K29)","v":-18602.774035651702},null,{"$f":"(M22+M24)-(M27+M29)","v":91133.547636842442},null,{"$f":"(O22+O24)-(O27+O29)","v":132079.48174060683}]