{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Utility_Info_","2. ICM_Costs","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. IRR"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":4,"defined_names":19,"comments":2,"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   ","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,"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-0103",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","Tom Barrett, Manager, Rates Applications",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","905-532-4640",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","tom.barrett@powerstream.ca",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-02-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",2013,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":11,"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,2014,null,2015,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual",null,"Forecast"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"ICP 1  UNDERGROUND CABLE REHABILITATION",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(I19),\"\",I19)","v":"Forecast"}]
[null,null,"ICP 1.1 ",null,"Poles",null,24226.045714000007,null,null,null,{"$f":"SUM(G42,I42)","v":24226.045714000007}]
[]
[null,null,"ICP 1.2",null,"Overhead Conductor",null,19822.860066000001,null,null,null,{"$f":"SUM(G44,I44)","v":19822.860066000001}]
[]
[null,null,"ICP 1.3",null,"Underground Conduit",null,2305442.1736579998,null,null,null,{"$f":"SUM(G46,I46)","v":2305442.1736579998}]
[]
[null,null,"ICP 1.4",null,"Underground Conductor",null,723815.92015300016,null,null,null,{"$f":"SUM(G48,I48)","v":723815.92015300016}]
[]
[null,null,"ICP 1.5",null,"Underground Injected Cable",null,3890145.035084994,null,null,null,{"$f":"SUM(G50,I50)","v":3890145.035084994}]
[]
[null,null,"ICP 1.6",null,"Underground Transformers",null,49233.945581999993,null,null,null,49233.945581999993]
[]
[null,null,"ICP 1.7",null,"Overhead Transformers",null,393.28054900000001,null,null,null,393.28054900000001]
[]
[null,null,"ICP 1.8",null,"Overhead Services",null,3551.2020400000001,null,null,null,3551.2020400000001]
[]
[null,null,"ICP 1.9",null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.10",null,null,null,null,null,null,null,0]
[]
[null,null,"Total Underground Cable Rehabilitation",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60)","v":7016630.4628469944},null,{"$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":7016630.4628469944}]
[]
[null,null,null,null,{"$f":"E40","v":"Asset Type"}]
[null,null,"ICP 2    SYSTEM RENEWAL - POLE REPLACEMENTS",null,null,null,{"$f":"G41","v":"Audited Actual"},null,{"$f":"I41","v":"Forecast"}]
[null,null,"ICP 2.1.",null,"Poles",null,961466.17602800124,null,null,null,{"$f":"SUM(G66,I66)","v":961466.17602800124}]
[]
[null,null,"ICP 2.2",null,"Overhead Conductor",null,406930.50607800018,null,null,null,{"$f":"SUM(G68,I68)","v":406930.50607800018}]
[]
[null,null,"ICP 2.3",null,"Underground Conductor",null,56172.037869000029,null,null,null,{"$f":"SUM(G70,I70)","v":56172.037869000029}]
[]
[null,null,"ICP 2.4",null,"Overhead Transformers",null,117810.25849699999,null,null,null,{"$f":"SUM(G72,I72)","v":117810.25849699999}]
[]
[null,null,"ICP 2.5",null,"Underground Transformers",null,12989.858327000002,null,null,null,{"$f":"SUM(G74,I74)","v":12989.858327000002}]
[]
[null,null,"ICP 2.6",null,"Overhead Services",null,79026.062894999981,null,null,null,{"$f":"SUM(G76,I76)","v":79026.062894999981}]
[]
[null,null,"ICP 2.7",null,"Underground Conduit",null,19645.824815,null,null,null,{"$f":"SUM(G78,I78)","v":19645.824815}]
[]
[null,null,"ICP 2.8",null,"System Supervisory Equipment",null,174.76201099999997,null,null,null,{"$f":"SUM(G80,I80)","v":174.76201099999997}]
[]
[null,null,"ICP 2.9",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,146.05566999999999,null,null,null,{"$f":"SUM(G82,I82)","v":146.05566999999999}]
[]
[null,null,"ICP 2.10",null,"Underground Injected Cable",null,50.753426000000005,null,null,null,50.753426000000005]
[]
[null,null,"Total System Renewal - Pole Replacements",null,null,null,{"$f":"SUM(G66,G68,G70,G72,G74,G76,G78,G80,G82,G84)","v":1654412.2956160011},null,{"$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":1654412.2956160011}]
[]
[null,null,null,null,{"$f":"E64","v":"Asset Type"}]
[null,null,"ICP 3  SYSTEM RENEWAL - STATION REPLACEMENTS",null,null,null,{"$f":"G65","v":"Audited Actual"},null,{"$f":"I65","v":"Forecast"}]
[null,null,"ICP 3.1",null,"Poles",null,25605.113445999999,null,null,null,{"$f":"SUM(G90,I90)","v":25605.113445999999}]
[]
[null,null,"ICP 3.2",null,"Overhead Conductor",null,79225.248863999994,null,null,null,{"$f":"SUM(G92,I92)","v":79225.248863999994}]
[]
[null,null,"ICP 3.3",null,"RTU's",null,79025.370894000022,null,null,null,{"$f":"SUM(G94,I94)","v":79025.370894000022}]
[]
[null,null,"ICP 3.4",null,"Underground Conductor",null,3329.2134679999999,null,null,null,{"$f":"SUM(G96,I96)","v":3329.2134679999999}]
[]
[null,null,"ICP 3.5",null,"Underground Transformers",null,73.706463999999997,null,null,null,{"$f":"SUM(G98,I98)","v":73.706463999999997}]
[]
[null,null,"ICP 3.6",null,"Overhead Services",null,509.15561500000001,null,null,null,{"$f":"SUM(G100,I100)","v":509.15561500000001}]
[]
[null,null,"ICP 3.7",null,"System Supervisory Equipment",null,319.64094499999999,null,null,null,{"$f":"SUM(G102,I102)","v":319.64094499999999}]
[]
[null,null,"ICP 3.8",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,9922.5923099999982,null,null,null,{"$f":"SUM(G104,I104)","v":9922.5923099999982}]
[]
[null,null,"ICP 3.9",null,"Transformer Station Equipment - Normally Primary above 50 kV",null,125163.54135499999,null,null,null,{"$f":"SUM(G106,I106)","v":125163.54135499999}]
[]
[null,null,"ICP 3.10",null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Renewal - Station Replacements",null,null,null,323173.583361,null,{"$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":323173.583361}]
[]
[null,null,null,null,{"$f":"E88","v":"Asset Type"}]
[null,null,"ICP 4  SYSTEM RENEWAL - SWITCHGEAR & TRANFORMER REPLACEMENTS",null,null,null,"Audited Actual",null,{"$f":"I89","v":"Forecast"}]
[]
[null,null,"ICP 4.1",null,"Poles",null,9421.2459429999999,null,null,null,{"$f":"SUM(G115,I115)","v":9421.2459429999999}]
[]
[null,null,"ICP 4.2",null,"Overhead Conductor",null,2502.198727,null,null,null,{"$f":"SUM(G117,I117)","v":2502.198727}]
[]
[null,null,"ICP 4.3",null,"Underground Conduit",null,186339.52537300004,null,null,null,{"$f":"SUM(G119,I119)","v":186339.52537300004}]
[]
[null,null,"ICP 4.4",null,"Underground Conductor",null,925518.75996499963,null,null,null,{"$f":"SUM(G121,I121)","v":925518.75996499963}]
[]
[null,null,"ICP 4.5",null,"Overhead Transformers",null,12.155147999999999,null,null,null,{"$f":"SUM(G123,I123)","v":12.155147999999999}]
[]
[null,null,"ICP 4.6",null,"Underground Transformers",null,165200.12170400005,null,null,null,{"$f":"SUM(G125,I125)","v":165200.12170400005}]
[]
[null,null,"ICP 4.7",null,"Overhead Services",null,23763.755616000006,null,null,null,{"$f":"SUM(G127,I127)","v":23763.755616000006}]
[]
[null,null,"ICP 4.8",null,"RTU's",null,-7818.6017139999994,null,null,null,{"$f":"SUM(G129,I129)","v":-7818.6017139999994}]
[]
[null,null,"ICP 4.9",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,2216.9037639999997,null,null,null,{"$f":"SUM(G131,I131)","v":2216.9037639999997}]
[]
[null,null,"ICP 4.10",null,"Land Rights",null,18.617166999999998,null,null,null,18.617166999999998]
[]
[null,null,"Total System Renewal -  Switchgear & Transformer ReplacementS",null,null,null,1307174.6816929993,null,{"$f":"SUM(I115,I117,I119,I121,I123,I125,I127,I129,I131,I133)","v":0},null,{"$f":"SUM(K115,K117,K119,K121,K123,K125,K127,K129,K131,K133)","v":1307174.6816929993}]
[]
[null,null,null,null,{"$f":"E112","v":"Asset Type"}]
[null,null,"ICP 5  SYSTEM CAPACITY RELIEF",null,null,null,"Audited Actual",null,{"$f":"I113","v":"Forecast"}]
[]
[null,null,"ICP 5.1",null,"Poles",null,285853.44457999995,null,null,null,{"$f":"SUM(G140,I140)","v":285853.44457999995}]
[]
[null,null,"ICP 5.2",null,"Overhead Conductor",null,193612.26198900002,null,null,null,{"$f":"SUM(G142,I142)","v":193612.26198900002}]
[]
[null,null,"ICP 5.3",null,"Underground Conduit",null,87407.264764999985,null,null,null,{"$f":"SUM(G144,I144)","v":87407.264764999985}]
[]
[null,null,"ICP 5.4",null,"Underground Conductor",null,75667.076668999987,null,null,null,{"$f":"SUM(G146,I146)","v":75667.076668999987}]
[]
[null,null,"ICP 5.5",null,"Overhead Transformers",null,10496.180907,null,null,null,{"$f":"SUM(G148,I148)","v":10496.180907}]
[]
[null,null,"ICP 5.6",null,"Overhead Services",null,-470.07928799999996,null,null,null,{"$f":"SUM(G150,I150)","v":-470.07928799999996}]
[]
[null,null,"ICP 5.7",null,"RTU's",null,2324.0970590000002,null,null,null,{"$f":"SUM(G152,I152)","v":2324.0970590000002}]
[]
[null,null,"ICP 5.8",null,null,null,null,null,null,null,{"$f":"SUM(G154,I154)","v":0}]
[]
[null,null,"ICP 5.9",null,null,null,null,null,null,null,{"$f":"SUM(G156,I156)","v":0}]
[]
[null,null,"ICP 5.10",null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Capacity Relief",null,null,null,654890.24668099999,null,{"$f":"SUM(I140,I142,I144,I146,I148,I150,I152,I154,I156,I158)","v":0},null,{"$f":"SUM(K140,K142,K144,K146,K148,K150,K152,K154,K156,K158)","v":654890.24668099999}]
[]
[null,null,"Total Capital Costs Related to Incremental Capital Projects (ICP)",null,null,null,10956281.270197993,null,{"$f":"SUM(I62,I86,I110,I135,I160)","v":0},null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":10956281.270197993}]
[]
[null,null,null,null,{"$f":"E137","v":"Asset Type"}]
[null,null,"OTHER CAPITAL COST",null,null,null,"Audited Actual",null,{"$f":"I138","v":"Forecast"}]
[]
[null,null,"A",null,null,null,null,null,null,null,{"$f":"SUM(G167,I167)","v":0}]
[]
[null,null,"B",null,null,null,null,null,null,null,{"$f":"SUM(G169,I169)","v":0}]
[]
[null,null,"C",null,null,null,null,null,null,null,{"$f":"SUM(G171,I171)","v":0}]
[]
[null,null,"Total Other Capital Costs ",null,null,null,{"$f":"SUM(G167,G169,G171)","v":0},null,{"$f":"SUM(I167,I169,I171)","v":0},null,{"$f":"SUM(K167,K169,K171)","v":0}]
[]
[null,null,"Total ICM Capital Costs",null,null,null,{"$f":"G162+G173","v":10956281.270197993},null,{"$f":"I162+I173","v":0},null,{"$f":"K162+K173","v":10956281.270197993}]
[]
[]
[null,2,"Aggregated ICM Costs by Category"]
[]
[null,null,"2.1","Capital","Account"]
[]
[null,null,"2.1.1","Poles",{"$f":"'3. Cost_of_Service_Parameters'!E45","v":1830},null,{"$f":"SUMIF($E$42:$E$171,$D182,G$42:G$171)","v":1306572.0257110011},null,{"$f":"SUMIF($E$42:$E$171,$D182,I$42:I$171)","v":0},null,{"$f":"SUM(G182:J182)","v":1306572.0257110011}]
[]
[null,null,"2.1.2","Overhead Conductor",{"$f":"'3. Cost_of_Service_Parameters'!E47","v":1835},null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":702093.07572400011},null,{"$f":"SUMIF($E$42:$E$171,$D184,I$42:I$171)","v":0},null,{"$f":"SUM(G184:J184)","v":702093.07572400011}]
[]
[null,null,"2.1.3","Underground Conduit",{"$f":"'3. Cost_of_Service_Parameters'!E49","v":1840},null,{"$f":"SUMIF($E$42:$E$171,$D186,G$42:G$171)","v":2598834.7886109999},null,{"$f":"SUMIF($E$42:$E$171,$D186,I$42:I$171)","v":0},null,{"$f":"SUM(G186:J186)","v":2598834.7886109999}]
[]
[null,null,"2.1.4","Underground Conductor",{"$f":"'3. Cost_of_Service_Parameters'!E51","v":1845},null,{"$f":"SUMIF($E$42:$E$171,$D188,G$42:G$171)","v":1784503.0081239999},null,{"$f":"SUMIF($E$42:$E$171,$D188,I$42:I$171)","v":0},null,{"$f":"SUM(G188:J188)","v":1784503.0081239999}]
[]
[null,null,"2.1.5","Underground Injected Cable",{"$f":"'3. Cost_of_Service_Parameters'!E53","v":1846},null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":3890195.7885109941},null,{"$f":"SUMIF($E$42:$E$171,$D190,I$42:I$171)","v":0},null,{"$f":"SUM(G190:J190)","v":3890195.7885109941}]
[]
[null,null,"2.1.6","Overhead Transformers",{"$f":"'3. Cost_of_Service_Parameters'!E55","v":1849},null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":128711.875101},null,{"$f":"SUMIF($E$42:$E$171,$D192,I$42:I$171)","v":0},null,{"$f":"SUM(G192:J192)","v":128711.875101}]
[]
[null,null,"2.1.7","Underground Transformers",{"$f":"'3. Cost_of_Service_Parameters'!E57","v":1850},null,{"$f":"SUMIF($E$42:$E$171,$D194,G$42:G$171)","v":227497.63207700005},null,{"$f":"SUMIF($E$42:$E$171,$D194,I$42:I$171)","v":0},null,{"$f":"SUM(G194:J194)","v":227497.63207700005}]
[]
[null,null,"2.1.8","Overhead Services",{"$f":"'3. Cost_of_Service_Parameters'!E59","v":1855},null,{"$f":"SUMIF($E$42:$E$171,$D196,G$42:G$171)","v":106380.096878},null,{"$f":"SUMIF($E$42:$E$171,$D196,I$42:I$171)","v":0},null,{"$f":"SUM(G196:J196)","v":106380.096878}]
[]
[null,null,"2.1.9","RTU's",{"$f":"'3. Cost_of_Service_Parameters'!E61","v":1981},null,{"$f":"SUMIF($E$42:$E$171,$D198,G$42:G$171)","v":73530.866239000025},null,{"$f":"SUMIF($E$42:$E$171,$D198,I$42:I$171)","v":0},null,{"$f":"SUM(G198:J198)","v":73530.866239000025}]
[]
[null,null,"2.1.10","System Supervisory Equipment",1980,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":494.40295599999996},null,{"$f":"SUMIF($E$42:$E$171,$D200,I$42:I$171)","v":0},null,{"$f":"SUM(G200:J200)","v":494.40295599999996}]
[]
[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":12285.551743999997},null,0,null,12285.551743999997]
[]
[null,null,"2.1.12","Transformer Station Equipment - Normally Primary above 50 kV",1815,null,125163.54135499999,null,0,null,125163.54135499999]
[]
[null,null,"2.1.13","Land Rights",1612,null,18.617166999999998,null,0,null,18.617166999999998]
[]
[null,null,"2.1.14"]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G209)","v":10956281.270197993},null,{"$f":"SUM(I182:I209)","v":0},null,{"$f":"SUM(K182:K209)","v":10956281.270197993}]
[null,null,null,null,null,null,{"$f":"IF(G211=G175,\" \",\"Error\")","v":" "},null,{"$f":"IF(I211=I175,\"\",\"Error\")","v":""},null,{"$f":"IF(K211=K175,\"\",\"Error\")","v":""}]

{"sheet":"3. Cost_of_Service_Parameters","index":2,"n_rows":118,"n_cols":15,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 3: Parameters and Rates"]
[]
[null,null,null,null,null,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,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.6},null,{"$f":"K23-(M22-K22)","v":0.6}]
[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.4},null,{"$f":"100%-M23-M25-M22","v":0.4}]
[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.0799999999999999E-2,null,2.1600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,4.1500000000000002E-2,null,3.9100000000000003E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.9300000000000004E-2,null,8.9300000000000004E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":5.9792000000000012E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":5.8480000000000004E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":0},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":0}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.13,null,0.13]
[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.26,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001]
[null,null,"Capital Tax (until July 1st, 2010)",null,null,null,0,null,0,null,0,null,0]
[]
[null,"Depreciation Rates",null,null,"Account"]
[null,"(expressed as expected useful life in years)"]
[null,null,"Poles - years",null,1830,null,45,null,45]
[null,null,"                              - rate (%)",null,null,null,{"$f":"IF(G45=0,0,1/G45)","v":2.2222222222222223E-2},null,{"$f":"IF(I45=0,0,1/I45)","v":2.2222222222222223E-2},null,{"$f":"IF(K45=0,0,1/K45)","v":0},null,{"$f":"IF(M45=0,0,1/M45)","v":0}]
[null,null,"Overhead Conductor - years",null,1835,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G47=0,0,1/G47)","v":2.5000000000000001E-2},null,{"$f":"IF(I47=0,0,1/I47)","v":2.5000000000000001E-2},null,{"$f":"IF(K47=0,0,1/K47)","v":0},null,{"$f":"IF(M47=0,0,1/M47)","v":0}]
[null,null,"Underground Conduit - years",null,1840,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G49=0,0,1/G49)","v":1.6666666666666666E-2},null,{"$f":"IF(I49=0,0,1/I49)","v":1.6666666666666666E-2},null,{"$f":"IF(K49=0,0,1/K49)","v":0},null,{"$f":"IF(M49=0,0,1/M49)","v":0}]
[null,null,"Underground Conductor - years",null,1845,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G51=0,0,1/G51)","v":2.2222222222222223E-2},null,{"$f":"IF(I51=0,0,1/I51)","v":2.2222222222222223E-2},null,{"$f":"IF(K51=0,0,1/K51)","v":0},null,{"$f":"IF(M51=0,0,1/M51)","v":0}]
[null,null,"U/G Injected Cable    - years",null,1846,null,20,null,20]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G53=0,0,1/G53)","v":0.05},null,{"$f":"IF(I53=0,0,1/I53)","v":0.05},null,{"$f":"IF(K53=0,0,1/K53)","v":0},null,{"$f":"IF(M53=0,0,1/M53)","v":0}]
[null,null,"Overhead Transformers    - years",null,1849,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G55=0,0,1/G55)","v":2.5000000000000001E-2},null,{"$f":"IF(I55=0,0,1/I55)","v":2.5000000000000001E-2},null,{"$f":"IF(K55=0,0,1/K55)","v":0},null,{"$f":"IF(M55=0,0,1/M55)","v":0}]
[null,null,"Underground Transformers    - years",null,1850,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G57=0,0,1/G57)","v":3.3333333333333333E-2},null,{"$f":"IF(I57=0,0,1/I57)","v":3.3333333333333333E-2},null,{"$f":"IF(K57=0,0,1/K57)","v":0},null,{"$f":"IF(M57=0,0,1/M57)","v":0}]
[null,null,"OH  Services    - years",null,1855,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G59=0,0,1/G59)","v":2.5000000000000001E-2},null,{"$f":"IF(I59=0,0,1/I59)","v":2.5000000000000001E-2},null,{"$f":"IF(K59=0,0,1/K59)","v":0},null,{"$f":"IF(M59=0,0,1/M59)","v":0}]
[null,null,"RTU's    - years",null,1981,null,15,null,15]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G61=0,0,1/G61)","v":6.6666666666666666E-2},null,{"$f":"IF(I61=0,0,1/I61)","v":6.6666666666666666E-2},null,{"$f":"IF(K61=0,0,1/K61)","v":0},null,{"$f":"IF(M61=0,0,1/M61)","v":0}]
[null,null,"System Supervisory Equipment    - years",null,1980,null,15,null,15]
[null,null,"                             - rate (%)",null,null,null,6.6666666666666666E-2,null,6.6666666666666666E-2,null,0,null,0]
[null,null,"Distribution Station Equipment     - years",null,1820,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,3.3333333333333333E-2,null,3.3333333333333333E-2,null,0,null,0]
[null,null,"Transformer Station Equipment     - years",null,1815,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,0,null,0]
[null,null,"Land Rights    - years",null,1612,null,0,null,0,null,null,null,null,null,"no depreciation (ECE)"]
[null,null,"                             - rate (%)",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,null,"Pole - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"Overhead Conductor - CCA Class",null,null,null,47,null,47]
[null,null,"Overhead Conductor - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"Underground Conduit - CCA Class",null,null,null,47,null,47]
[null,null,"Underground Conduit - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"Underground Conductor - CCA Class",null,null,null,47,null,47]
[null,null,"Underground Conductor - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"U/G Injected Cable - CCA Class",null,null,null,47,null,47]
[null,null,"U/G Injected Cable - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"Overhead Transformers - CCA Class",null,null,null,47,null,47]
[null,null,"Overhead Transformers - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"Underground Transformers - CCA Class",null,null,null,47,null,47]
[null,null,"Underground Transformers - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"OH  Services - CCA Class",null,null,null,47,null,47]
[null,null,"OH Services - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"RTU's - CCA Class",null,null,null,8,null,8]
[null,null,"RUT's - CCA Rate",null,null,null,0.2,null,0.2]
[]
[null,null,"System Supervisory Equipment - CCA Class",null,null,null,8,null,8]
[null,null,"System Supervisory Equipment - CCA Rate",null,null,null,0.2,null,0.2]
[]
[null,null,"Distribution Station Equipment - CCA Class",null,null,null,47,null,47]
[null,null,"Distribution Station Equipment - CCA Rate",null,null,null,0.08,null,0.08]
[]
[null,null,"Transformer Station Equipment - CCA Class",null,null,null,47,null,47]
[null,null,"Transformer Station Equipment - CCA Rate",null,null,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":3,"n_rows":277,"n_cols":11,"rows_kept":277,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,null,null,2014,null,2015]
[null,"Net Fixed Assets - Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I25","v":1306572.0257110011}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G182","v":1306572.0257110011},null,{"$f":"'2. ICM_Costs'!I182","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I22+I23-I24","v":1306572.0257110011},null,{"$f":"K22+K23-K24","v":1306572.0257110011}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":-29034.933904688914}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I23/('3. Cost_of_Service_Parameters'!G45)+MIN((I22/'3. Cost_of_Service_Parameters'!G45),(I22+I28)))), 0, -(I23/('3. Cost_of_Service_Parameters'!G45)+MIN((I22/'3. Cost_of_Service_Parameters'!G45),(I22+I28))))","v":-29034.933904688914},null,{"$f":"IF(ISERROR(-(K23/('3. Cost_of_Service_Parameters'!I45)+MIN((K22/'3. Cost_of_Service_Parameters'!I45),(K22+K28)))), 0, -(K23/('3. Cost_of_Service_Parameters'!I45)+MIN((K22/'3. Cost_of_Service_Parameters'!I45),(K22+K28))))","v":-29034.933904688914}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":-29034.933904688914},null,{"$f":"K28+K29-K30","v":-58069.867809377829}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,{"$f":"I35","v":1277537.0918063123}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":1277537.0918063123},null,{"$f":"K25+K31","v":1248502.1579016233}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":1277537.0918063123},null,{"$f":"AVERAGE(K34:K35)","v":1263019.6248539677}]
[]
[null,"Net Fixed Assets - Overhead Conductor"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I44","v":702093.07572400011}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G184","v":702093.07572400011},null,{"$f":"'2. ICM_Costs'!I184","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I41+I42-I43","v":702093.07572400011},null,{"$f":"K41+K42-K43","v":702093.07572400011}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":-17552.326893100002}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47)))), 0, -(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47))))","v":-17552.326893100002},null,{"$f":"IF(ISERROR(-(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47)))), 0, -(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47))))","v":-17552.326893100002}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":-17552.326893100002},null,{"$f":"K47+K48-K49","v":-35104.653786200004}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,{"$f":"I54","v":684540.74883090006}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":684540.74883090006},null,{"$f":"K44+K50","v":666988.42193780013}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":684540.74883090006},null,{"$f":"AVERAGE(K53:K54)","v":675764.58538435004}]
[]
[null,"Net Fixed Assets - Underground Conduit"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I63","v":2598834.7886109999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G186","v":2598834.7886109999},null,{"$f":"'2. ICM_Costs'!I186","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":2598834.7886109999},null,{"$f":"K60+K61-K62","v":2598834.7886109999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":-43313.913143516664}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I61/('3. Cost_of_Service_Parameters'!G49)+MIN((I60/'3. Cost_of_Service_Parameters'!G49),(I60+I66)))), 0, -(I61/('3. Cost_of_Service_Parameters'!G49)+MIN((I60/'3. Cost_of_Service_Parameters'!G49),(I60+I66))))","v":-43313.913143516664},null,{"$f":"IF(ISERROR(-(K61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!I49),(K60+K66)))), 0, -(K61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!I49),(K60+K66))))","v":-43313.913143516664}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":-43313.913143516664},null,{"$f":"K66+K67-K68","v":-86627.826287033327}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,{"$f":"I73","v":2555520.8754674834}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":2555520.8754674834},null,{"$f":"K63+K69","v":2512206.9623239664}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":2555520.8754674834},null,{"$f":"AVERAGE(K72:K73)","v":2533863.9188957252}]
[]
[null,"Net Fixed Assets - Underground Conductor"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I82","v":1784503.0081239999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":1784503.0081239999},null,{"$f":"'2. ICM_Costs'!I188","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":1784503.0081239999},null,{"$f":"K79+K80-K81","v":1784503.0081239999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":-39655.622402755551}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I80/('3. Cost_of_Service_Parameters'!G51)+MIN((I79/'3. Cost_of_Service_Parameters'!G51),(I79+I85)))), 0, -(I80/('3. Cost_of_Service_Parameters'!G51)+MIN((I79/'3. Cost_of_Service_Parameters'!G51),(I79+I85))))","v":-39655.622402755551},null,{"$f":"IF(ISERROR(-(K80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!I51),(K79+K85)))), 0, -(K80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!I51),(K79+K85))))","v":-39655.622402755551}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":-39655.622402755551},null,{"$f":"K85+K86-K87","v":-79311.244805511102}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,{"$f":"I92","v":1744847.3857212444}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":1744847.3857212444},null,{"$f":"K82+K88","v":1705191.7633184888}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":1744847.3857212444},null,{"$f":"AVERAGE(K91:K92)","v":1725019.5745198666}]
[]
[null,"Net Fixed Assets - U/G Injected Cable"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I101","v":3890195.7885109941}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":3890195.7885109941},null,{"$f":"'2. ICM_Costs'!I190","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I98+I99-I100","v":3890195.7885109941},null,{"$f":"K98+K99-K100","v":3890195.7885109941}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":-194509.78942554971}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I99/('3. Cost_of_Service_Parameters'!G53)+MIN((I98/'3. Cost_of_Service_Parameters'!G53),(I98+I104)))), 0, -(I99/('3. Cost_of_Service_Parameters'!G53)+MIN((I98/'3. Cost_of_Service_Parameters'!G53),(I98+I104))))","v":-194509.78942554971},null,{"$f":"IF(ISERROR(-(K99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!I53),(K98+K104)))), 0, -(K99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!I53),(K98+K104))))","v":-194509.78942554971}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":-194509.78942554971},null,{"$f":"K104+K105-K106","v":-389019.57885109942}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,{"$f":"I111","v":3695685.9990854445}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":3695685.9990854445},null,{"$f":"K101+K107","v":3501176.2096598945}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":3695685.9990854445},null,{"$f":"AVERAGE(K110:K111)","v":3598431.1043726695}]
[]
[null,"Net Fixed Assets - OH Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I120","v":128711.875101}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":128711.875101},null,{"$f":"'2. ICM_Costs'!I192","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I117+I118-I119","v":128711.875101},null,{"$f":"K117+K118-K119","v":128711.875101}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":-3217.7968775250001}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I118/('3. Cost_of_Service_Parameters'!G55)+MIN((I117/'3. Cost_of_Service_Parameters'!G55),(I117+I123)))), 0, -(I118/('3. Cost_of_Service_Parameters'!G55)+MIN((I117/'3. Cost_of_Service_Parameters'!G55),(I117+I123))))","v":-3217.7968775250001},null,{"$f":"IF(ISERROR(-(K118/('3. Cost_of_Service_Parameters'!I55*2)+MIN((K117/'3. Cost_of_Service_Parameters'!I55),(K117+K123)))), 0, -(K118/('3. Cost_of_Service_Parameters'!I55*2)+MIN((K117/'3. Cost_of_Service_Parameters'!I55),(K117+K123))))","v":-3217.7968775250001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":-3217.7968775250001},null,{"$f":"K123+K124-K125","v":-6435.5937550500003}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,{"$f":"I130","v":125494.07822347499}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":125494.07822347499},null,{"$f":"K120+K126","v":122276.28134595}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":125494.07822347499},null,{"$f":"AVERAGE(K129:K130)","v":123885.1797847125}]
[]
[null,"Net Fixed Assets - UG Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I139","v":227497.63207700005}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G194","v":227497.63207700005},null,{"$f":"'2. ICM_Costs'!I194","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I136+I137-I138","v":227497.63207700005},null,{"$f":"K136+K137-K138","v":227497.63207700005}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":-7583.2544025666684}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I137/('3. Cost_of_Service_Parameters'!G57)+MIN((I136/'3. Cost_of_Service_Parameters'!G57),(I136+I142)))), 0, -(I137/('3. Cost_of_Service_Parameters'!G57)+MIN((I136/'3. Cost_of_Service_Parameters'!G57),(I136+I142))))","v":-7583.2544025666684},null,{"$f":"IF(ISERROR(-(K137/('3. Cost_of_Service_Parameters'!I57*2)+MIN((K136/'3. Cost_of_Service_Parameters'!I57),(K136+K142)))), 0, -(K137/('3. Cost_of_Service_Parameters'!I57*2)+MIN((K136/'3. Cost_of_Service_Parameters'!I57),(K136+K142))))","v":-7583.2544025666684}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":-7583.2544025666684},null,{"$f":"K142+K143-K144","v":-15166.508805133337}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,{"$f":"I149","v":219914.37767443337}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":219914.37767443337},null,{"$f":"K139+K145","v":212331.1232718667}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":219914.37767443337},null,{"$f":"AVERAGE(K148:K149)","v":216122.75047315005}]
[]
[null,"Net Fixed Assets - OH Services"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I158","v":106380.096878}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G196","v":106380.096878},null,{"$f":"'2. ICM_Costs'!I196","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I155+I156-I157","v":106380.096878},null,{"$f":"K155+K156-K157","v":106380.096878}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I164","v":-2659.5024219500001}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I156/('3. Cost_of_Service_Parameters'!G59)+MIN((I155/'3. Cost_of_Service_Parameters'!G59),(I155+I161)))), 0, -(I156/('3. Cost_of_Service_Parameters'!G59)+MIN((I155/'3. Cost_of_Service_Parameters'!G59),(I155+I161))))","v":-2659.5024219500001},null,{"$f":"IF(ISERROR(-(K156/('3. Cost_of_Service_Parameters'!I59*2)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161)))), 0, -(K156/('3. Cost_of_Service_Parameters'!I59*2)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161))))","v":-2659.5024219500001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I161+I162-I163","v":-2659.5024219500001},null,{"$f":"K161+K162-K163","v":-5319.0048439000002}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I155+I161","v":0},null,{"$f":"I168","v":103720.59445604999}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I158+I164","v":103720.59445604999},null,{"$f":"K158+K164","v":101061.0920341}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I168","v":103720.59445604999},null,{"$f":"AVERAGE(K167:K168)","v":102390.843245075}]
[]
[null,"Net Fixed Assets - RTUs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I177","v":73530.866239000025}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":73530.866239000025},null,{"$f":"'2. ICM_Costs'!I198","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I174+I175-I176","v":73530.866239000025},null,{"$f":"K174+K175-K176","v":73530.866239000025}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I183","v":-4902.057749266668}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I175/('3. Cost_of_Service_Parameters'!G61)+MIN((I174/'3. Cost_of_Service_Parameters'!G61),(I174+I180)))), 0, -(I175/('3. Cost_of_Service_Parameters'!G61)+MIN((I174/'3. Cost_of_Service_Parameters'!G61),(I174+I180))))","v":-4902.057749266668},null,{"$f":"IF(ISERROR(-(K175/('3. Cost_of_Service_Parameters'!I61*2)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180)))), 0, -(K175/('3. Cost_of_Service_Parameters'!I61*2)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180))))","v":-4902.057749266668}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I180+I181-I182","v":-4902.057749266668},null,{"$f":"K180+K181-K182","v":-9804.115498533336}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,{"$f":"I187","v":68628.808489733361}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I177+I183","v":68628.808489733361},null,{"$f":"K177+K183","v":63726.75074046669}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I187","v":68628.808489733361},null,{"$f":"AVERAGE(K186:K187)","v":66177.779615100022}]
[]
[]
[null,"Net Fixed Assets - System Supervisory Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I197","v":494.40295599999996}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":494.40295599999996},null,{"$f":"'2. ICM_Costs'!I218","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I194+I195-I196","v":494.40295599999996},null,{"$f":"K194+K195-K196","v":494.40295599999996}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I203","v":-32.960197066666666}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I195/('3. Cost_of_Service_Parameters'!G63)+MIN((I194/'3. Cost_of_Service_Parameters'!G63),(I194+I200)))), 0, -(I195/('3. Cost_of_Service_Parameters'!G63)+MIN((I194/'3. Cost_of_Service_Parameters'!G63),(I194+I200))))","v":-32.960197066666666},null,{"$f":"IF(ISERROR(-(K195/('3. Cost_of_Service_Parameters'!I63*2)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200)))), 0, -(K195/('3. Cost_of_Service_Parameters'!I63*2)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200))))","v":-32.960197066666666}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I200+I201-I202","v":-32.960197066666666},null,{"$f":"K200+K201-K202","v":-65.920394133333332}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,{"$f":"I207","v":461.44275893333327}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I197+I203","v":461.44275893333327},null,{"$f":"K197+K203","v":428.48256186666663}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I207","v":461.44275893333327},null,{"$f":"AVERAGE(K206:K207)","v":444.96266039999995}]
[]
[]
[null,"Net Fixed Assets - Distribution Station Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I217","v":12285.551743999997}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":12285.551743999997},null,{"$f":"'2. ICM_Costs'!I238","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I214+I215-I216","v":12285.551743999997},null,{"$f":"K214+K215-K216","v":12285.551743999997}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I223","v":-409.51839146666657}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I215/('3. Cost_of_Service_Parameters'!G65)+MIN((I214/'3. Cost_of_Service_Parameters'!G65),(I214+I220)))), 0, -(I215/('3. Cost_of_Service_Parameters'!G65)+MIN((I214/'3. Cost_of_Service_Parameters'!G65),(I214+I220))))","v":-409.51839146666657},null,{"$f":"IF(ISERROR(-(K215/('3. Cost_of_Service_Parameters'!I65*2)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220)))), 0, -(K215/('3. Cost_of_Service_Parameters'!I65*2)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220))))","v":-409.51839146666657}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I220+I221-I222","v":-409.51839146666657},null,{"$f":"K220+K221-K222","v":-819.03678293333314}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,{"$f":"I227","v":11876.03335253333}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I217+I223","v":11876.03335253333},null,{"$f":"K217+K223","v":11466.514961066663}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I227","v":11876.03335253333},null,{"$f":"AVERAGE(K226:K227)","v":11671.274156799996}]
[]
[]
[null,"Net Fixed Assets - Transformer Station Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I237","v":125163.54135499999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":125163.54135499999},null,{"$f":"'2. ICM_Costs'!I258","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I234+I235-I236","v":125163.54135499999},null,{"$f":"K234+K235-K236","v":125163.54135499999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I243","v":-3129.0885338749999}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I235/('3. Cost_of_Service_Parameters'!G67)+MIN((I234/'3. Cost_of_Service_Parameters'!G67),(I234+I240)))), 0, -(I235/('3. Cost_of_Service_Parameters'!G67)+MIN((I234/'3. Cost_of_Service_Parameters'!G67),(I234+I240))))","v":-3129.0885338749999},null,{"$f":"IF(ISERROR(-(K235/('3. Cost_of_Service_Parameters'!I67*2)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240)))), 0, -(K235/('3. Cost_of_Service_Parameters'!I67*2)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240))))","v":-3129.0885338749999}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I240+I241-I242","v":-3129.0885338749999},null,{"$f":"K240+K241-K242","v":-6258.1770677499999}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I234+I240","v":0},null,{"$f":"I247","v":122034.452821125}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I237+I243","v":122034.452821125},null,{"$f":"K237+K243","v":118905.36428724999}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I247","v":122034.452821125},null,{"$f":"AVERAGE(K246:K247)","v":120469.9085541875}]
[]
[]
[null,"Net Fixed Assets - Land Rights"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I257","v":18.617166999999998}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":18.617166999999998},null,{"$f":"'2. ICM_Costs'!I278","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I254+I255-I256","v":18.617166999999998},null,{"$f":"K254+K255-K256","v":18.617166999999998}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I263","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I255/('3. Cost_of_Service_Parameters'!G69*2)+MIN((I254/'3. Cost_of_Service_Parameters'!G69),(I254+I260)))), 0, -(I255/('3. Cost_of_Service_Parameters'!G69*2)+MIN((I254/'3. Cost_of_Service_Parameters'!G69),(I254+I260))))","v":0},null,{"$f":"IF(ISERROR(-(K255/('3. Cost_of_Service_Parameters'!I69*2)+MIN((K254/'3. Cost_of_Service_Parameters'!I69),(K254+K260)))), 0, -(K255/('3. Cost_of_Service_Parameters'!I69*2)+MIN((K254/'3. Cost_of_Service_Parameters'!I69),(K254+K260))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I260+I261-I262","v":0},null,{"$f":"K260+K261-K262","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I254+I260","v":0},null,{"$f":"I267","v":18.617166999999998}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I257+I263","v":18.617166999999998},null,{"$f":"K257+K263","v":18.617166999999998}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I267","v":18.617166999999998},null,{"$f":"AVERAGE(K266:K267)","v":18.617166999999998}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",null,null,null,null,{"$f":"I23+I42+I61+I80+I99+I118+I137+I156+I175+I195+I215+I235+I255","v":10956281.270197993},{"$f":"J23+J42+J61+J80+J99+J118+J137+J156+J175+J195+J215+J235+J255","v":0},0]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I36+I55+I74+I93+I112+I131+I150+I169+I188+I208+I228+I248+I268","v":10610280.505854664},{"$f":"J36+J55+J74+J93+J112+J131+J150+J169+J188+J208+J228+J248+J268","v":0},10437280.123683004]
[null,null,null,"Total Amortization",null,null,null,null,{"$f":"I29+I48+I67+I86+I105+I124+I143+I162+I181+I201+I221+I241+I261","v":-346000.76434332744},{"$f":"J29+J48+J67+J86+J105+J124+J143+J162+J181+J201+J221+J241+J261","v":0},-346000.76434332744]

{"sheet":"5. UCC_Calculation","index":4,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,{"$f":"'2. ICM_Costs'!G18","v":2014},null,{"$f":"'2. ICM_Costs'!I18","v":2015}]
[null,null,null,{"$f":"'2. ICM_Costs'!G19","v":"Audited Actual"},null,{"$f":"'2. ICM_Costs'!I19","v":"Forecast"}]
[]
["Opening UCC",null,null,0,null,{"$f":"D26-D31","v":10011675.520922754}]
["Capital Additions",null,null,{"$f":"'4. ICM_Assets_and_Rate_Base'!I275-D38","v":10882256.001002993},null,{"$f":"'4. ICM_Assets_and_Rate_Base'!K275-F38","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D23:D24)-D25","v":10882256.001002993},null,{"$f":"SUM(F23:F24)-F25","v":10011675.520922754}]
[null,null,null,null,null,{"$f":"IF(((F24-F25)/2)<0, 0, (F24-F25)/2)","v":0}]
[null,null,null,null,null,{"$f":"F27+F23","v":10011675.520922754}]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G76","v":47},null,{"$f":"'3. Cost_of_Service_Parameters'!I76","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G77","v":0.08},null,{"$f":"'3. Cost_of_Service_Parameters'!I77","v":0.08}]
["CCA",null,null,{"$f":"D26*D30","v":870580.48008023947},null,{"$f":"F28*F30","v":800934.04167382035}]
["Closing UCC",null,null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":10011675.520922754},null,{"$f":"IF((F26-F31)<0, 0, F26-F31)","v":9210741.4792489335}]
[]
["UCC/Class 8",null,null,{"$f":"D20","v":2014},null,2015]
[null,null,null,"Audited Actual",null,"Forecast"]
[]
["Opening UCC",null,null,0,null,{"$f":"D40-D45","v":59220.215356000022}]
["Capital Additions RTU's",null,null,{"$f":"'2. ICM_Costs'!G198+'2. ICM_Costs'!G200","v":74025.26919500003},null,{"$f":"'2. ICM_Costs'!I198","v":0}]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D37:D38)-D39","v":74025.26919500003},null,{"$f":"SUM(F37:F38)-F39","v":59220.215356000022}]
[null,null,null,null,null,{"$f":"IF((SUM(F38:F38)/2)<0, 0, SUM(F38:F38)/2)","v":0}]
[null,null,null,null,null,{"$f":"F41+F37","v":59220.215356000022}]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G100","v":8},null,{"$f":"'3. Cost_of_Service_Parameters'!I100","v":8}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G101","v":0.2},null,{"$f":"'3. Cost_of_Service_Parameters'!I101","v":0.2}]
["CCA",null,null,{"$f":"D40*D44","v":14805.053839000007},null,{"$f":"F44*F42","v":11844.043071200005}]
["Closing UCC",null,null,{"$f":"IF((D40-D45)<0, 0, D40-D45)","v":59220.215356000022},null,{"$f":"IF((F40-F45)<0, 0, F40-F45)","v":47376.172284800021}]

{"sheet":"6. ICMIRR ","index":5,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[23,8,23,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6:",null,"Incremental Capital Adjustment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"2014 IRM"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"'4. ICM_Assets_and_Rate_Base'!I275","v":10956281.270197993},"B",null,null,null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!F27","v":11326840.10086146}]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I277","v":346000.76434332744},"C",null,null,null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!F28","v":260581.5821153312}]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"F27-F28","v":10610280.505854666},"D = B - C",null,null,null,{"$f":"K27-K28","v":11066258.518746128}]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},"E",{"$f":"F29*D31","v":424411.22023418668},"G = D * E",null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D31","v":0.04},null,{"$f":"K29*I31","v":442650.34074984514}]
[null,null,"Deemed Long Term Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},"F",{"$f":"F29*D32","v":5941757.0832786122},"H = D * F",null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D32","v":0.56000000000000005},null,{"$f":"K29*I32","v":6197104.7704978324}]
[]
[null,null,"Short Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":2.0799999999999999E-2},"I",{"$f":"F31*D34","v":8827.7533808710832},"K = G * I",null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D34","v":2.0799999999999999E-2},null,{"$f":"K31*I34","v":9207.1270875967784}]
[null,null,"Long Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":4.1500000000000002E-2},"J",{"$f":"F32*D35","v":246582.91895606241},"L = H * J",null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D35","v":4.1454493039772097E-2},null,{"$f":"K32*I35","v":256897.83657534086}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":255410.67233693349},"M = K + L",null,null,null,{"$f":"SUM(K34:K35)","v":266104.96366293763}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"aaa"]
[null,null,"Deemed Equity %",{"$f":"'3. Cost_of_Service_Parameters'!G24","v":0.40000000000000008},"N",{"$f":"F29*D40","v":4244112.2023418676},"P = D * N",null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D40","v":0.39999999999999991},null,{"$f":"K29*I40","v":4426503.40749845}]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":8.9300000000000004E-2},"O",{"$f":"F40*D42","v":378999.21966912877},"Q = P * O",null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D42","v":8.9300000000000004E-2},null,{"$f":"K40*I42","v":395286.75428961159}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":634409.8920060622},"R = M + Q",null,null,null,{"$f":"K37+K42","v":661391.71795254922}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":346000.76434332744},"S",null,null,null,{"$f":"K28","v":260581.5821153312}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":378999.21966912877},"T ",null,null,null,{"$f":"K42","v":395286.75428961159}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":346000.76434332744},"U",null,null,null,{"$f":"K50","v":260581.5821153312}]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'5. UCC_Calculation'!D31+'5. UCC_Calculation'!D45","v":885385.53391923953},"V",null,null,null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$F$59","v":906147.20806891716}]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-160385.54990678339},"W = T + U - V",null,null,null,{"$f":"K55+K57-K59","v":-250278.87166397437}]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.26},"X",null,null,null,{"$f":"'[3]E4.1 IncrementalCapitalAdjust'!$D$63","v":0.26}]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-41700.242975763686},"Y = W * X",null,null,null,{"$f":"K61*I63","v":-65072.50663263334}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-56351.679696977953},"Z = Y / ( 1 - X ) ",null,null,null,{"$f":"K65/(1-I63)","v":-87935.819773828844}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":10956281.270197993},"AA",null,null,null,{"$f":"K27","v":11326840.10086146}]
[]
[null,null,"Less : Available Capital Exemption (if any)",null,null,0,"AB",null,null,null,0]
[]
[null,null,"Incremental Capital CAPEX subject to OCT",null,null,{"$f":"F71-F73","v":10956281.270197993},"AC = AA - AB",null,null,null,{"$f":"K71-K73","v":11326840.10086146}]
[]
[null,null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",0,"AD"]
[]
[null,null,"Incremental Ontario Capital Tax",null,null,{"$f":"F75*D77","v":0},"AE = AC * AD",null,null,null,{"$f":"K75*I77","v":0}]
[]
[]
[null,null,"Incremental Revenue Requirement"]
[null,null,"Return on Rate Base - Total",null,"Q",{"$f":"F44","v":634409.8920060622},"AF",null,null,null,{"$f":"K44","v":661391.71795254922}]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":346000.76434332744},"AG",null,null,null,{"$f":"K50","v":260581.5821153312}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-56351.679696977953},"AH",null,null,null,{"$f":"K67","v":-87935.819773828844}]
[null,null,"Incremental Ontario Capital Tax",null,"AE",{"$f":"F79","v":0},"AI",null,null,null,{"$f":"K79","v":0}]
[]
[null,null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(F83:F86)","v":924058.97665241163},"AJ = AF + AG + AH + AI",null,null,null,{"$f":"SUM(K83:K86)","v":834037.48029405158}]

{"sheet":"7. Funding Adder Revs","index":6,"n_rows":70,"n_cols":17,"rows_kept":70,"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,null,null,"2014-01-01",{"$f":"YEAR(F24)","v":2014},{"$f":"IF(MONTH(F24)=0,\"\",IF(MONTH(F24)<4,\"Q1\",IF(MONTH(F24)<7,\"Q2\",IF(MONTH(F24)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G24,\" \",H24)","v":"2014 Q1"},0,0,{"$f":"VLOOKUP(I24,$B$22:$D$59,2)","v":1.47E-2},{"$f":"ROUND(J24*L24/12,2)","v":0},{"$f":"K24+M24","v":0},null,0,{"$f":"P24","v":0}]
[null,"2006 Q2",4.1399999999999999E-2,4.6800000000000001E-2,null,"2014-02-01",{"$f":"YEAR(F25)","v":2014},{"$f":"IF(MONTH(F25)=0,\"\",IF(MONTH(F25)<4,\"Q1\",IF(MONTH(F25)<7,\"Q2\",IF(MONTH(F25)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G25,\" \",H25)","v":"2014 Q1"},{"$f":"J24+K24","v":0},0,1.47E-2,{"$f":"ROUND(J25*L25/12,2)","v":0},{"$f":"N24+K25+M25","v":0},null,0,{"$f":"Q24+P25","v":0}]
[null,"2006 Q3",4.5900000000000003E-2,5.0500000000000003E-2,null,"2014-03-01",2014,"Q1","2014 Q1",{"$f":"J25+K25","v":0},81633.070000000007,1.47E-2,0,{"$f":"N25+K26+M26","v":81633.070000000007},null,83403.748029405164,{"$f":"Q25+P26","v":83403.748029405164}]
[null,"2006 Q4",4.5900000000000003E-2,4.7199999999999999E-2,null,"2014-04-01",2014,"Q2","2014 Q2",81633.070000000007,79489.13999999997,1.47E-2,100,161222.20999999996,null,83403.748029405164,166807.49605881033]
[null,"2007 Q1",4.5900000000000003E-2,4.7199999999999999E-2,null,"2014-05-01",2014,"Q2","2014 Q2",161122.20999999996,101852.74999999997,1.47E-2,197.37,263272.32999999996,null,83403.748029405164,250211.24408821549]
[null,"2007 Q2",4.5900000000000003E-2,4.7199999999999999E-2,null,"2014-06-01",2014,"Q2","2014 Q2",262974.95999999996,88915.12,1.47E-2,322.14,352509.58999999997,null,83403.748029405164,333614.99211762066]
[null,"2007 Q3",4.5900000000000003E-2,5.1799999999999999E-2,null,"2014-07-01",2014,"Q3","2014 Q3",351890.07999999996,96907.279999999984,1.47E-2,431.07,449847.93999999994,null,83403.748029405164,417018.74014702579]
[null,"2007 Q4",5.1400000000000001E-2,5.1799999999999999E-2,null,"2014-08-01",2014,"Q3","2014 Q3",448797.35999999993,102961.39000000001,1.47E-2,549.78,553359.11,null,83403.748029405164,500422.48817643092]
[null,"2008 Q1",5.1400000000000001E-2,5.1799999999999999E-2,null,"2014-09-01",2014,"Q3","2014 Q3",551758.75,98095.569999999992,1.47E-2,675.9,652130.57999999996,null,83403.748029405164,583826.23620583606]
[null,"2008 Q2",4.0800000000000003E-2,5.1799999999999999E-2,null,"2014-10-01",2014,"Q4","2014 Q4",649854.31999999995,93325.989999999976,1.47E-2,796.07,746252.6399999999,null,83403.748029405164,667229.98423524119]
[null,"2008 Q3",3.3500000000000002E-2,5.4300000000000001E-2,null,"2014-11-01",2014,"Q4","2014 Q4",743180.30999999994,87338.4,1.47E-2,910.4,834501.44,null,83403.748029405164,750633.73226464633]
[null,"2008 Q4",3.3500000000000002E-2,5.4300000000000001E-2,null,"2014-12-01",2014,"Q4","2014 Q4",830518.71,96981.680000000066,1.47E-2,1017.39,932500.51,null,83403.748029405164,834037.48029405146]
[null,"2009 Q1",2.4500000000000001E-2,6.6100000000000006E-2,null,"2015-01-01",2015,"Q1","2015 Q1",927500.39,{"$f":"TRANSPOSE('[4]ICM Revenues'!$C$68:$N$68)","v":83727.569999999774},1.47E-2,1136.19,1017364.2699999998,null,69503.123357837627,903540.60365188913]
[null,"2009 Q2",0.01,6.6100000000000006E-2,null,"2015-02-01",2015,"Q1","2015 Q1",1011227.9599999997,79245.510000000068,1.47E-2,1238.75,1097848.5299999998,null,69503.123357837627,973043.7270097268]
[null,"2009 Q3",5.4999999999999997E-3,5.67E-2,null,"2015-03-01",2015,"Q1","2015 Q1",1090473.4699999997,84672.979999999909,1.47E-2,1335.83,1183857.3399999999,null,69503.123357837627,1042546.8503675645]
[null,"2009 Q4",5.4999999999999997E-3,4.6600000000000003E-2,null,"2015-04-01",2015,"Q2","2015 Q2",1175146.4499999997,78624.759999999951,1.47E-2,1439.55,1263921.6499999999,null,69503.123357837627,1112049.973725402]
[null,"2010 Q1",5.4999999999999997E-3,4.3400000000000001E-2,null,"2015-05-01",2015,"Q2","2015 Q2",1253771.2099999997,-25693.259999999987,1.47E-2,1535.87,1239764.26,null,69503.123357837627,1181553.0970832396]
[null,"2010 Q2",5.4999999999999997E-3,4.3400000000000001E-2,null,"2015-06-01",2015,"Q2","2015 Q2",1228077.9499999997,180243.31999999983,1.47E-2,1504.4,1421511.9799999997,null,69503.123357837627,1251056.2204410771]
[null,"2010 Q3",8.8999999999999999E-3,4.6600000000000003E-2,null,"2015-07-01",2015,"Q3","2015 Q3",1408321.2699999996,88985.049999999901,1.47E-2,1725.19,1512222.2199999995,null,69503.123357837627,1320559.3437989147]
[null,"2010 Q4",1.2E-2,4.0099999999999997E-2,null,"2015-08-01",2015,"Q3","2015 Q3",1497306.3199999994,84665.999999999971,1.47E-2,1834.2,1598722.4199999995,null,69503.123357837627,1390062.4671567522]
[null,"2011 Q1",1.47E-2,4.2900000000000001E-2,null,"2015-09-01",2015,"Q3","2015 Q3",1581972.3199999994,84780.950000000041,1.47E-2,1937.92,1685441.2899999993,null,69503.123357837627,1459565.5905145898]
[null,"2011 Q2",1.47E-2,4.2900000000000001E-2,null,"2015-10-01",2015,"Q4","2015 Q4",1666753.2699999993,84537.399999999965,1.47E-2,2041.77,1772020.4599999993,null,69503.123357837627,1529068.7138724274]
[null,"2011 Q3",1.47E-2,4.2900000000000001E-2,null,"2015-11-01",2015,"Q4","2015 Q4",1751290.6699999992,70041.17,1.47E-2,2145.33,1844206.9599999993,null,69503.123357837627,1598571.8372302649]
[null,"2011 Q4",{"$f":"C46","v":1.47E-2},3.9199999999999999E-2,null,"2015-12-01",2015,"Q4","2015 Q4",1821331.8399999992,76251.070000000007,1.47E-2,2231.13,1922689.1599999992,null,69503.123357837627,1668074.9605881025]
[null,"2012 Q1",1.47E-2,3.9199999999999999E-2,null,"2016-01-01",2016,"Q1","2016 Q1",1897582.9099999992,{"$f":"TRANSPOSE('[4]ICM Revenues'!$C$116:$N$116)","v":84474.972758301868},{"$f":"VLOOKUP(I48,$B$22:$E$67,2)","v":1.0999999999999999E-2},1739.45,2008903.5827583009,null,69503.123357837627,1737578.08394594]
[null,"2012 Q2",1.47E-2,3.2300000000000002E-2,null,"2016-02-01",2016,"Q1","2016 Q1",1982057.882758301,81598.462879906583,{"$f":"VLOOKUP(I49,$B$22:$D$67,2)","v":1.0999999999999999E-2},1816.89,2092318.9356382075,null,69503.123357837627,1807081.2073037776]
[null,"2012 Q3",1.47E-2,3.2300000000000002E-2,null,"2016-03-01",2016,"Q1","2016 Q1",2063656.3456382076,80523.560117288333,{"$f":"VLOOKUP(I50,$B$22:$D$67,2)","v":1.0999999999999999E-2},1891.68,2174734.1757554961,null,69503.123357837627,1876584.3306616151]
[null,"2012 Q4",1.47E-2,3.6999999999999998E-2,null,"2016-04-01",2016,"Q2","2016 Q2",2144179.9057554961,75457.130343627621,1.0999999999999999E-2,1965.5,2252156.8060991238,null,69503.123357837627,1946087.4540194527]
[null,"2013 Q1",1.47E-2,3.6999999999999998E-2,null,"2016-05-01",2016,"Q2","2016 Q2",2219637.0360991238,77296.298337551256,1.0999999999999999E-2,2034.67,2331487.774436675,null,69503.123357837627,2015590.5773772902]
[null,"2013 Q2",1.47E-2,3.1699999999999999E-2,null,"2016-06-01",2016,"Q2","2016 Q2",2296933.3344366751,84521.779501341734,1.0999999999999999E-2,2105.52,2418115.0739380168,null,69503.123357837627,2085093.7007351278]
[null,"2013 Q3",1.47E-2,3.1699999999999999E-2,null,"2016-07-01",2016,"Q3","2016 Q3",2381455.1139380168,93903.945347073881,1.0999999999999999E-2,2183,2514202.0192850907,null,69503.123357837627,2154596.8240929656]
[null,"2013 Q4",1.47E-2,3.1699999999999999E-2,null,"2016-08-01",2016,"Q3","2016 Q3",2475359.0592850908,89637.246795687621,1.0999999999999999E-2,2269.08,2606108.3460807786,null,69503.123357837627,2224099.9474508031]
[null,"2014 Q1",1.47E-2,3.6999999999999998E-2,null,"2016-09-01",2016,"Q3","2016 Q3",2564996.3060807786,78722.431691422797,1.0999999999999999E-2,2351.25,2687182.0277722012,null,69503.123357837627,2293603.0708086407]
[null,"2014 Q2",1.47E-2,3.1699999999999999E-2,null,"2016-10-01",2016,"Q4","2016 Q4",2643718.7377722012,75365.630181081564,1.0999999999999999E-2,2423.41,2764971.067953283,null,69503.123357837627,2363106.1941664782]
[null,"2014 Q3",{"$f":"C57","v":1.47E-2},3.1699999999999999E-2,null,"2016-11-01",2016,"Q4","2016 Q4",2719084.3679532828,76087.091627727088,1.0999999999999999E-2,2492.4899999999998,2843550.6495810105,null,69503.123357837627,2432609.3175243158]
[null,"2014 Q4",{"$f":"C57","v":1.47E-2},3.1699999999999999E-2,null,"2016-12-01",2016,"Q4","2016 Q4",2795171.45958101,86533.410687048658,1.0999999999999999E-2,2562.2399999999998,2932646.3002680591,null,69503.123357837627,2502112.4408821533]
[null,"2015 Q1",{"$f":"C59","v":1.47E-2},2.8899999999999999E-2]
[null,"2015 Q2",1.0999999999999999E-2,2.2800000000000001E-2]
[null,"2015 Q3",1.0999999999999999E-2,2.5499999999999998E-2]
[null,"2015 Q4",1.0999999999999999E-2,2.5499999999999998E-2]
[null,"2016 Q1",1.0999999999999999E-2,2.92E-2]
[null,"2016 Q2",1.0999999999999999E-2,2.92E-2,null,"Total Funding Adder Revenues Collected",null,null,null,null,{"$f":"SUM(K24:K64)","v":2881704.8702680585},null,{"$f":"SUM(M24:M64)","v":50941.429999999993},{"$f":"K65+M65","v":2932646.3002680587}]
[null,"2016 Q3",1.0999999999999999E-2,2.92E-2]
[null,"2016 Q4",1.0999999999999999E-2,2.92E-2]
[]
[]
[null,"NOTE: Funding adder revenues are up to December 2015 actuals and Jan-Dec 2016 forecasted 9approved rates x 2016 billing determinants)"]

{"sheet":"8. Opex Interest Annual","index":7,"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 Sheet 7)",null,"Simple Interest on OM&A and Amortization Expenses"]
[null,null,null,null,null,"(from Sheet 6)"]
[null,2014,null,0,null,{"$f":"'6. ICMIRR '!$F$28","v":346000.76434332744},null,{"$f":"D23+F23","v":346000.76434332744},null,{"$f":"H23/2","v":173000.38217166372},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C56:C59)","v":1.47E-2},null,{"$f":"J23*L23","v":2543.1056179234565}]
[null,2015,null,0,null,{"$f":"F23","v":346000.76434332744},null,{"$f":"H23+D24+F24","v":692001.52868665487},null,{"$f":"(H24+H23)/2","v":519001.14651499118},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C60:C63)","v":1.1924999999999998E-2},null,6189.0886721912684]
[null,2016,null,0,null,{"$f":"F23","v":346000.76434332744},null,{"$f":"H24+D25+F25","v":1038002.2930299824},null,{"$f":"(H25+H24)/2","v":865001.91085831868},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C64:C67)","v":1.0999999999999999E-2},null,9515.0210194415049]
[null,"Cumulative Interest to 2014",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N23)","v":2543.1056179234565}]
[null,"Cumulative Interest to 2015",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N24)","v":8732.1942901147249}]
[null,"Cumulative Interest to 2016",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N23:N25)","v":18247.215309556232}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,14],[19,2,19,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the ICM Incremental Revenue Requirement."]
[]
[]
[null,"Sheet 9: ICM Incremental Revenue Requirement"]
[null,null," "]
[]
[null,null,null,null,null,null,2014,null,2015,null,2016,null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,{"$f":"'6. ICMIRR '!$F$88","v":924058.97665241163},null,{"$f":"'6. ICMIRR '!$F$88","v":924058.97665241163},null,{"$f":"'6. ICMIRR '!$F$88","v":924058.97665241163},null,{"$f":"SUM(G22:K22)","v":2772176.9299572348}]
[]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,{"$f":"'8. Opex Interest Annual'!$N$23","v":2543.1056179234565},null,{"$f":"'8. Opex Interest Annual'!$N$24","v":6189.0886721912684},null,{"$f":"'8. Opex Interest Annual'!N25","v":9515.0210194415049},null,{"$f":"SUM(G24:K24)","v":18247.215309556232}]
[]
[]
[null,null,"ICM Funding Adder Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Funding Adder Revs'!K26:K35)","v":927500.39},null,{"$f":"SUM('7. Funding Adder Revs'!K36:K47)","v":970082.51999999955},null,{"$f":"SUM('7. Funding Adder Revs'!K48:K59)","v":984121.96026805905},null,{"$f":"SUM(G27:K27)","v":2881704.870268059}]
[]
[null,null,"ICM Funding Adder Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Funding Adder Revs'!M27:M35)","v":5000.12},null,{"$f":"SUM('7. Funding Adder Revs'!M36:M47)","v":20106.13},null,{"$f":"SUM('7. Funding Adder Revs'!M48:M59)","v":25835.18},null,{"$f":"SUM(G29:K29)","v":50941.43}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":-5898.4277296649525},null,{"$f":"(I22+I24)-(I27+I29)","v":-59940.584675396676},null,{"$f":"(K22+K24)-(K27+K29)","v":-76383.142596205929},null,{"$f":"(M22+M24)-(M27+M29)","v":-142222.15500126826}]