{"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","7. Rate Rider Revs","6. ICMIRR_2018","8. Opex Interest Annual","9. IRR"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9381,"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":85,"n_cols":28,"rows_kept":85,"cut":false,"hidden":false,"merged":[[20,3,20,5],[22,3,22,7],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4],[18,3,18,4],[16,3,16,7]]}
[null,null,null,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   ","Alectra Utilities Corporation - Brampton Rate Zone",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-2025-0252",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","Natalie Yeates, Director, Regulatory Affairs",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","416-617-1959",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","natalie.yeates@alectrautilities.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",null,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,"ICM Project","2018 CCRA",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."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - PowerStream Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - Brampton Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - Enersource Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - Horizon Rate Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alectra Utilities Corporation - Guelph Rate Zone"]

{"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,2018,null,null,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 System Access",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,"Capital Contributions Paid ",null,6804600,null,null,null,{"$f":"SUM(G42,I42)","v":6804600}]
[]
[null,null,"ICP 1.2",null,null,null,null,null,null,null,{"$f":"SUM(G44,I44)","v":0}]
[]
[null,null,"ICP 1.3",null,null,null,null,null,null,null,{"$f":"SUM(G46,I46)","v":0}]
[]
[null,null,"ICP 1.4",null,null,null,null,null,null,null,{"$f":"SUM(G48,I48)","v":0}]
[]
[null,null,"ICP 1.5",null,null,null,null,null,null,null,{"$f":"SUM(G50,I50)","v":0}]
[]
[null,null,"ICP 1.6",null,null,null,null,null,null,null,{"$f":"SUM(G52,I52)","v":0}]
[]
[null,null,"ICP 1.7",null,null,null,null,null,null,null,{"$f":"SUM(G54,I54)","v":0}]
[]
[null,null,"ICP 1.8",null,null,null,null,null,null,null,{"$f":"SUM(G56,I56)","v":0}]
[]
[null,null,"ICP 1.9",null,null,null,null,null,null,null,{"$f":"SUM(G58,I58)","v":0}]
[]
[null,null,"ICP 1.10",null,null,null,null,null,null,null,{"$f":"SUM(G60,I60)","v":0}]
[]
[null,null,"Total System Access",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60)","v":6804600},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":6804600}]
[]
[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,null,null,null,null,{"$f":"SUM(G66,I66)","v":0}]
[]
[null,null,"ICP 2.2",null,"Overhead Conductor",null,null,null,null,null,{"$f":"SUM(G68,I68)","v":0}]
[]
[null,null,"ICP 2.3",null,"Underground Conductor",null,null,null,null,null,{"$f":"SUM(G70,I70)","v":0}]
[]
[null,null,"ICP 2.4",null,"Overhead Transformers",null,null,null,null,null,{"$f":"SUM(G72,I72)","v":0}]
[]
[null,null,"ICP 2.5",null,"Underground Transformers",null,null,null,null,null,{"$f":"SUM(G74,I74)","v":0}]
[]
[null,null,"ICP 2.6",null,"Overhead Services",null,null,null,null,null,{"$f":"SUM(G76,I76)","v":0}]
[]
[null,null,"ICP 2.7",null,"Underground Conduit",null,null,null,null,null,{"$f":"SUM(G78,I78)","v":0}]
[]
[null,null,"ICP 2.8",null,"System Supervisory Equipment",null,null,null,null,null,{"$f":"SUM(G80,I80)","v":0}]
[]
[null,null,"ICP 2.9",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,null,null,null,null,{"$f":"SUM(G82,I82)","v":0}]
[]
[null,null,"ICP 2.10",null,"Underground Injected Cable",null,null,null,null,null,{"$f":"SUM(G84,I84)","v":0}]
[]
[null,null,"Total System Renewal - Pole Replacements",null,null,null,{"$f":"SUM(G66,G68,G70,G72,G74,G76,G78,G80,G82,G84)","v":0},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":0}]
[]
[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,null,null,null,null,{"$f":"SUM(G90,I90)","v":0}]
[]
[null,null,"ICP 3.2",null,"Overhead Conductor",null,null,null,null,null,{"$f":"SUM(G92,I92)","v":0}]
[]
[null,null,"ICP 3.3",null,"RTU's",null,null,null,null,null,{"$f":"SUM(G94,I94)","v":0}]
[]
[null,null,"ICP 3.4",null,"Underground Conductor",null,null,null,null,null,{"$f":"SUM(G96,I96)","v":0}]
[]
[null,null,"ICP 3.5",null,"Underground Transformers",null,null,null,null,null,{"$f":"SUM(G98,I98)","v":0}]
[]
[null,null,"ICP 3.6",null,"Overhead Services",null,null,null,null,null,{"$f":"SUM(G100,I100)","v":0}]
[]
[null,null,"ICP 3.7",null,"System Supervisory Equipment",null,null,null,null,null,{"$f":"SUM(G102,I102)","v":0}]
[]
[null,null,"ICP 3.8",null,"Distribution Station Equipment - Normally Primary below 50 kV",null,null,null,null,null,{"$f":"SUM(G104,I104)","v":0}]
[]
[null,null,"ICP 3.9",null,"Transformer Station Equipment - Normally Primary above 50 kV",null,null,null,null,null,{"$f":"SUM(G106,I106)","v":0}]
[]
[null,null,"ICP 3.10",null,null,null,null,null,null,null,{"$f":"SUM(G108,I108)","v":0}]
[]
[null,null,"Total System Renewal - Station Replacements",null,null,null,null,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":0}]
[]
[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,null,null,null,null,null,null,{"$f":"SUM(G115,I115)","v":0}]
[]
[null,null,"ICP 4.2",null,null,null,null,null,null,null,{"$f":"SUM(G117,I117)","v":0}]
[]
[null,null,"ICP 4.3",null,null,null,null,null,null,null,{"$f":"SUM(G119,I119)","v":0}]
[]
[null,null,"ICP 4.4",null,null,null,null,null,null,null,{"$f":"SUM(G121,I121)","v":0}]
[]
[null,null,"ICP 4.5",null,null,null,null,null,null,null,{"$f":"SUM(G123,I123)","v":0}]
[]
[null,null,"ICP 4.6",null,null,null,null,null,null,null,{"$f":"SUM(G125,I125)","v":0}]
[]
[null,null,"ICP 4.7",null,null,null,null,null,null,null,{"$f":"SUM(G127,I127)","v":0}]
[]
[null,null,"ICP 4.8",null,null,null,null,null,null,null,{"$f":"SUM(G129,I129)","v":0}]
[]
[null,null,"ICP 4.9",null,null,null,null,null,null,null,{"$f":"SUM(G131,I131)","v":0}]
[]
[null,null,"ICP 4.10",null,null,null,null,null,null,null,{"$f":"SUM(G133,I133)","v":0}]
[]
[null,null,"Total System Renewal -  Switchgear & Transformer ReplacementS",null,null,null,null,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":0}]
[]
[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,null,null,null,null,null,null,{"$f":"SUM(G140,I140)","v":0}]
[]
[null,null,"ICP 5.2",null,null,null,null,null,null,null,{"$f":"SUM(G142,I142)","v":0}]
[]
[null,null,"ICP 5.3",null,null,null,null,null,null,null,{"$f":"SUM(G144,I144)","v":0}]
[]
[null,null,"ICP 5.4",null,null,null,null,null,null,null,{"$f":"SUM(G146,I146)","v":0}]
[]
[null,null,"ICP 5.5",null,null,null,null,null,null,null,{"$f":"SUM(G148,I148)","v":0}]
[]
[null,null,"ICP 5.6",null,null,null,null,null,null,null,{"$f":"SUM(G150,I150)","v":0}]
[]
[null,null,"ICP 5.7",null,null,null,null,null,null,null,{"$f":"SUM(G152,I152)","v":0}]
[]
[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,{"$f":"SUM(G158,I158)","v":0}]
[]
[null,null,"Total System Capacity Relief",null,null,null,null,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":0}]
[]
[null,null,"Total Capital Costs Related to Incremental Capital Projects (ICP)",null,null,null,null,null,{"$f":"SUM(I62,I86,I110,I135,I160)","v":0},null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":6804600}]
[]
[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+G135+G110+G86+G62","v":6804600},null,{"$f":"I162+I173","v":0},null,{"$f":"K162+K173","v":6804600}]
[]
[]
[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":1835},null,{"$f":"SUMIF($E$42:$E$171,$D182,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D182,I$42:I$171)","v":0},null,{"$f":"SUM(G182:J182)","v":0}]
[]
[null,null,"2.1.2","Overhead Conductor",{"$f":"'3. Cost_of_Service_Parameters'!E47","v":1830},null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D184,I$42:I$171)","v":0},null,{"$f":"SUM(G184:J184)","v":0}]
[]
[null,null,"2.1.3","Underground Conduit",{"$f":"'3. Cost_of_Service_Parameters'!E49","v":1830},null,{"$f":"SUMIF($E$42:$E$171,$D186,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D186,I$42:I$171)","v":0},null,{"$f":"SUM(G186:J186)","v":0}]
[]
[null,null,"2.1.4","Underground Conductor",{"$f":"'3. Cost_of_Service_Parameters'!E51","v":1850},null,{"$f":"SUMIF($E$42:$E$171,$D188,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D188,I$42:I$171)","v":0},null,{"$f":"SUM(G188:J188)","v":0}]
[]
[null,null,"2.1.5","Underground Injected Cable",{"$f":"'3. Cost_of_Service_Parameters'!E53","v":1835},null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D190,I$42:I$171)","v":0},null,{"$f":"SUM(G190:J190)","v":0}]
[]
[null,null,"2.1.6","Overhead Transformers",{"$f":"'3. Cost_of_Service_Parameters'!E55","v":1855},null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D192,I$42:I$171)","v":0},null,{"$f":"SUM(G192:J192)","v":0}]
[]
[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":0},null,{"$f":"SUMIF($E$42:$E$171,$D194,I$42:I$171)","v":0},null,{"$f":"SUM(G194:J194)","v":0}]
[]
[null,null,"2.1.8","Overhead Services",{"$f":"'3. Cost_of_Service_Parameters'!E59","v":1840},null,{"$f":"SUMIF($E$42:$E$171,$D196,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D196,I$42:I$171)","v":0},null,{"$f":"SUM(G196:J196)","v":0}]
[]
[null,null,"2.1.9","RTU's",{"$f":"'3. Cost_of_Service_Parameters'!E61","v":1845},null,{"$f":"SUMIF($E$42:$E$171,$D198,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D198,I$42:I$171)","v":0},null,{"$f":"SUM(G198:J198)","v":0}]
[]
[null,null,"2.1.10","System Supervisory Equipment",1980,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D200,I$42:I$171)","v":0},null,{"$f":"SUM(G200:J200)","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":0},null,0,null,{"$f":"SUM(G202:J202)","v":0}]
[]
[null,null,"2.1.12","Transformer Station Equipment - Normally Primary above 50 kV",1815,null,0,null,0,null,{"$f":"SUM(G204:J204)","v":0}]
[]
[null,null,"2.1.13","Land Rights",1612,null,0,null,0,null,{"$f":"SUM(G206:J206)","v":0}]
[]
[null,null,"2.1.14","Capital Contributions Paid ",1609,null,6804600,null,null,null,{"$f":"SUM(G208:J208)","v":6804600}]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G209)","v":6804600},null,{"$f":"SUM(I182:I209)","v":0},null,{"$f":"SUM(K182:K209)","v":6804600}]
[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":140,"n_cols":23,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 3: Parameters and Rates"]
[]
[null,null,null,null,null,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[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,0.04,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":"60%-I22","v":0.55999999999999994},null,{"$f":"60%-K22","v":0.55999999999999994},null,{"$f":"60%-M22","v":0.55999999999999994},null,{"$f":"60%-O22","v":0.55999999999999994},null,{"$f":"60%-Q22","v":0.55999999999999994},null,{"$f":"60%-S22","v":0.55999999999999994},null,{"$f":"60%-U22","v":0.55999999999999994},null,{"$f":"60%-W22","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,{"$f":"100%-O23-O25-O22","v":0.40000000000000008},null,{"$f":"100%-Q23-Q25-Q22","v":0.40000000000000008},null,{"$f":"100%-S23-S25-S22","v":0.40000000000000008},null,{"$f":"100%-U23-U25-U22","v":0.40000000000000008},null,{"$f":"100%-W23-W25-W22","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,{"$f":"SUM(O22:O25)","v":1},null,{"$f":"SUM(Q22:Q25)","v":1},null,{"$f":"SUM(S22:S25)","v":1},null,{"$f":"SUM(U22:U25)","v":1},null,{"$f":"SUM(W22:W25)","v":1}]
[]
[null,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2,null,2.1600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2,null,6.0699999999999997E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2,null,9.2999999999999999E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(O22:O25,O29:O32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(Q22:Q25,Q29:Q32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(S22:S25,S29:S32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(U22:U25,U29:U32)","v":7.2055999999999995E-2},null,{"$f":"SUMPRODUCT(W22:W25,W29:W32)","v":7.2055999999999995E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.13,null,0.13,null,0.13,null,0.13,null,0.13,null,0.13,null,0.13,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.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,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,0,null,0,null,0,null,0,null,0]
[]
[null,"Depreciation Rates",null,null,"Account"]
[null,"(expressed as expected useful life in years)"]
[null,null,"OH Swtch & Cpctrs",null,1835,null,30,null,38,null,38,null,38,null,38,null,38,null,38,null,35,null,35]
[null,null,"                              - rate (%)",null,null,null,{"$f":"IF(G45=0,0,1/G45)","v":3.3333333333333333E-2},null,{"$f":"IF(I45=0,0,1/I45)","v":2.6315789473684209E-2},null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.8571428571428571E-2,null,2.8571428571428571E-2]
[null,null,"Concrete Poles",null,1830,null,50,null,51,null,51,null,51,null,51,null,51,null,51,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G47=0,0,1/G47)","v":0.02},null,{"$f":"IF(I47=0,0,1/I47)","v":1.9607843137254902E-2},null,{"$f":"IF(K47=0,0,1/K47)","v":1.9607843137254902E-2},null,{"$f":"IF(M47=0,0,1/M47)","v":1.9607843137254902E-2},null,{"$f":"IF(O47=0,0,1/O47)","v":1.9607843137254902E-2},null,{"$f":"IF(Q47=0,0,1/Q47)","v":1.9607843137254902E-2},null,{"$f":"IF(S47=0,0,1/S47)","v":1.9607843137254902E-2},null,{"$f":"IF(U47=0,0,1/U47)","v":1.6666666666666666E-2},null,{"$f":"IF(W47=0,0,1/W47)","v":1.6666666666666666E-2}]
[null,null,"Wood Poles",null,1830,null,45,null,44,null,44,null,44,null,44,null,44,null,44,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G49=0,0,1/G49)","v":2.2222222222222223E-2},null,{"$f":"IF(I49=0,0,1/I49)","v":2.2727272727272728E-2},null,{"$f":"IF(K49=0,0,1/K49)","v":2.2727272727272728E-2},null,{"$f":"IF(M49=0,0,1/M49)","v":2.2727272727272728E-2},null,{"$f":"IF(O49=0,0,1/O49)","v":2.2727272727272728E-2},null,{"$f":"IF(Q49=0,0,1/Q49)","v":2.2727272727272728E-2},null,{"$f":"IF(S49=0,0,1/S49)","v":2.2727272727272728E-2},null,{"$f":"IF(U49=0,0,1/U49)","v":2.2222222222222223E-2},null,{"$f":"IF(W49=0,0,1/W49)","v":2.2222222222222223E-2}]
[null,null,"OH Transformers",null,1850,null,40,null,41,null,41,null,41,null,41,null,41,null,41,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G51=0,0,1/G51)","v":2.5000000000000001E-2},null,{"$f":"IF(I51=0,0,1/I51)","v":2.4390243902439025E-2},null,{"$f":"IF(K51=0,0,1/K51)","v":2.4390243902439025E-2},null,{"$f":"IF(M51=0,0,1/M51)","v":2.4390243902439025E-2},null,{"$f":"IF(O51=0,0,1/O51)","v":2.4390243902439025E-2},null,{"$f":"IF(Q51=0,0,1/Q51)","v":2.4390243902439025E-2},null,{"$f":"IF(S51=0,0,1/S51)","v":2.4390243902439025E-2},null,{"$f":"IF(U51=0,0,1/U51)","v":2.2222222222222223E-2},null,{"$f":"IF(W51=0,0,1/W51)","v":2.2222222222222223E-2}]
[null,null,"OH Prim Cond & Dev",null,1835,null,50,null,45,null,45,null,45,null,45,null,45,null,45,null,50,null,50]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G53=0,0,1/G53)","v":0.02},null,{"$f":"IF(I53=0,0,1/I53)","v":2.2222222222222223E-2},null,{"$f":"IF(K53=0,0,1/K53)","v":2.2222222222222223E-2},null,{"$f":"IF(M53=0,0,1/M53)","v":2.2222222222222223E-2},null,{"$f":"IF(O53=0,0,1/O53)","v":2.2222222222222223E-2},null,{"$f":"IF(Q53=0,0,1/Q53)","v":2.2222222222222223E-2},null,{"$f":"IF(S53=0,0,1/S53)","v":2.2222222222222223E-2},null,{"$f":"IF(U53=0,0,1/U53)","v":0.02},null,{"$f":"IF(W53=0,0,1/W53)","v":0.02}]
[null,null,"OH Sec Cond & Dev",null,1855,null,50,null,48,null,48,null,48,null,48,null,48,null,48,null,50,null,50]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G55=0,0,1/G55)","v":0.02},null,{"$f":"IF(I55=0,0,1/I55)","v":2.0833333333333332E-2},null,{"$f":"IF(K55=0,0,1/K55)","v":2.0833333333333332E-2},null,{"$f":"IF(M55=0,0,1/M55)","v":2.0833333333333332E-2},null,{"$f":"IF(O55=0,0,1/O55)","v":2.0833333333333332E-2},null,{"$f":"IF(Q55=0,0,1/Q55)","v":2.0833333333333332E-2},null,{"$f":"IF(S55=0,0,1/S55)","v":2.0833333333333332E-2},null,{"$f":"IF(U55=0,0,1/U55)","v":0.02},null,{"$f":"IF(W55=0,0,1/W55)","v":0.02}]
[null,null,"UG Transformers",null,1850,null,40,null,32,null,32,null,32,null,32,null,32,null,32,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G57=0,0,1/G57)","v":2.5000000000000001E-2},null,{"$f":"IF(I57=0,0,1/I57)","v":3.125E-2},null,{"$f":"IF(K57=0,0,1/K57)","v":3.125E-2},null,{"$f":"IF(M57=0,0,1/M57)","v":3.125E-2},null,{"$f":"IF(O57=0,0,1/O57)","v":3.125E-2},null,{"$f":"IF(Q57=0,0,1/Q57)","v":3.125E-2},null,{"$f":"IF(S57=0,0,1/S57)","v":3.125E-2},null,{"$f":"IF(U57=0,0,1/U57)","v":3.3333333333333333E-2},null,{"$f":"IF(W57=0,0,1/W57)","v":3.3333333333333333E-2}]
[null,null,"UG Conduit",null,1840,null,50,null,52,null,52,null,52,null,52,null,52,null,52,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G59=0,0,1/G59)","v":0.02},null,{"$f":"IF(I59=0,0,1/I59)","v":1.9230769230769232E-2},null,{"$f":"IF(K59=0,0,1/K59)","v":1.9230769230769232E-2},null,{"$f":"IF(M59=0,0,1/M59)","v":1.9230769230769232E-2},null,{"$f":"IF(O59=0,0,1/O59)","v":1.9230769230769232E-2},null,{"$f":"IF(Q59=0,0,1/Q59)","v":1.9230769230769232E-2},null,{"$f":"IF(S59=0,0,1/S59)","v":1.9230769230769232E-2},null,{"$f":"IF(U59=0,0,1/U59)","v":1.6666666666666666E-2},null,{"$f":"IF(W59=0,0,1/W59)","v":1.6666666666666666E-2}]
[null,null,"UG Prim XLPE TR",null,1845,null,35,null,38,null,38,null,38,null,38,null,38,null,38,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.8571428571428571E-2,null,{"$f":"IF(I61=0,0,1/I61)","v":2.6315789473684209E-2},null,{"$f":"IF(K61=0,0,1/K61)","v":2.6315789473684209E-2},null,{"$f":"IF(M61=0,0,1/M61)","v":2.6315789473684209E-2},null,{"$f":"IF(O61=0,0,1/O61)","v":2.6315789473684209E-2},null,{"$f":"IF(Q61=0,0,1/Q61)","v":2.6315789473684209E-2},null,{"$f":"IF(S61=0,0,1/S61)","v":2.6315789473684209E-2},null,{"$f":"IF(U61=0,0,1/U61)","v":2.2222222222222223E-2},null,{"$f":"IF(W61=0,0,1/W61)","v":2.2222222222222223E-2}]
[null,null,"UG Sec - Dir Buried",null,1845,null,50,null,31,null,31,null,31,null,31,null,31,null,31,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,0.02,null,{"$f":"IF(I63=0,0,1/I63)","v":3.2258064516129031E-2},null,{"$f":"IF(K63=0,0,1/K63)","v":3.2258064516129031E-2},null,{"$f":"IF(M63=0,0,1/M63)","v":3.2258064516129031E-2},null,{"$f":"IF(O63=0,0,1/O63)","v":3.2258064516129031E-2},null,{"$f":"IF(Q63=0,0,1/Q63)","v":3.2258064516129031E-2},null,{"$f":"IF(S63=0,0,1/S63)","v":3.2258064516129031E-2},null,{"$f":"IF(U63=0,0,1/U63)","v":3.3333333333333333E-2},null,{"$f":"IF(W63=0,0,1/W63)","v":3.3333333333333333E-2}]
[null,null,"UG Sec In Duct/Svs",null,1845,null,50,null,37,null,37,null,37,null,37,null,37,null,37,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,0.02,null,{"$f":"IF(I65=0,0,1/I65)","v":2.7027027027027029E-2},null,{"$f":"IF(K65=0,0,1/K65)","v":2.7027027027027029E-2},null,{"$f":"IF(M65=0,0,1/M65)","v":2.7027027027027029E-2},null,{"$f":"IF(O65=0,0,1/O65)","v":2.7027027027027029E-2},null,{"$f":"IF(Q65=0,0,1/Q65)","v":2.7027027027027029E-2},null,{"$f":"IF(S65=0,0,1/S65)","v":2.7027027027027029E-2},null,{"$f":"IF(U65=0,0,1/U65)","v":2.5000000000000001E-2},null,{"$f":"IF(W65=0,0,1/W65)","v":2.5000000000000001E-2}]
[null,null,"Air Insulated Switchgear",null,1845,null,20,null,39,null,39,null,39,null,39,null,39,null,39,null,35,null,35]
[null,null,"                             - rate (%)",null,null,null,0.05,null,{"$f":"IF(I67=0,0,1/I67)","v":2.564102564102564E-2},null,{"$f":"IF(K67=0,0,1/K67)","v":2.564102564102564E-2},null,{"$f":"IF(M67=0,0,1/M67)","v":2.564102564102564E-2},null,{"$f":"IF(O67=0,0,1/O67)","v":2.564102564102564E-2},null,{"$f":"IF(Q67=0,0,1/Q67)","v":2.564102564102564E-2},null,{"$f":"IF(S67=0,0,1/S67)","v":2.564102564102564E-2},null,{"$f":"IF(U67=0,0,1/U67)","v":2.8571428571428571E-2},null,{"$f":"IF(W67=0,0,1/W67)","v":2.8571428571428571E-2}]
[null,null,"Solid Dielectric Switchgear",null,1845,null,35,null,42,null,42,null,42,null,42,null,42,null,42,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G69=0,0,1/G69)","v":2.8571428571428571E-2},null,{"$f":"IF(I69=0,0,1/I69)","v":2.3809523809523808E-2},null,{"$f":"IF(K69=0,0,1/K69)","v":2.3809523809523808E-2},null,{"$f":"IF(M69=0,0,1/M69)","v":2.3809523809523808E-2},null,{"$f":"IF(O69=0,0,1/O69)","v":2.3809523809523808E-2},null,{"$f":"IF(Q69=0,0,1/Q69)","v":2.3809523809523808E-2},null,{"$f":"IF(S69=0,0,1/S69)","v":2.3809523809523808E-2},null,{"$f":"IF(U69=0,0,1/U69)","v":2.2222222222222223E-2},null,{"$f":"IF(W69=0,0,1/W69)","v":2.2222222222222223E-2}]
[null,null,"UG Cable Injection",null,1845,null,35,null,24,null,24,null,24,null,24,null,24,null,24,null,20,null,20]
[null,null,"                             - rate (%)",null,null,null,2.8571428571428571E-2,null,{"$f":"IF(I71=0,0,1/I71)","v":4.1666666666666664E-2},null,{"$f":"IF(K71=0,0,1/K71)","v":4.1666666666666664E-2},null,{"$f":"IF(M71=0,0,1/M71)","v":4.1666666666666664E-2},null,{"$f":"IF(O71=0,0,1/O71)","v":4.1666666666666664E-2},null,{"$f":"IF(Q71=0,0,1/Q71)","v":4.1666666666666664E-2},null,{"$f":"IF(S71=0,0,1/S71)","v":4.1666666666666664E-2},null,{"$f":"IF(U71=0,0,1/U71)","v":0.05},null,{"$f":"IF(W71=0,0,1/W71)","v":0.05}]
[null,null,"MS Integrated P&C Systems ",null,1820,null,20,null,36,null,36,null,36,null,36,null,36,null,36,null,15,null,15]
[null,null,"                             - rate (%)",null,null,null,0.05,null,{"$f":"IF(I73=0,0,1/I73)","v":2.7777777777777776E-2},null,{"$f":"IF(K73=0,0,1/K73)","v":2.7777777777777776E-2},null,{"$f":"IF(M73=0,0,1/M73)","v":2.7777777777777776E-2},null,{"$f":"IF(O73=0,0,1/O73)","v":2.7777777777777776E-2},null,{"$f":"IF(Q73=0,0,1/Q73)","v":2.7777777777777776E-2},null,{"$f":"IF(S73=0,0,1/S73)","v":2.7777777777777776E-2},null,{"$f":"IF(U73=0,0,1/U73)","v":6.6666666666666666E-2},null,{"$f":"IF(W73=0,0,1/W73)","v":6.6666666666666666E-2}]
[null,null,"MS Building Improvements ",null,1820,null,60,null,21,null,21,null,21,null,21,null,21,null,21,null,25,null,25]
[null,null,"                             - rate (%)",null,null,null,1.6666666666666666E-2,null,{"$f":"IF(I75=0,0,1/I75)","v":4.7619047619047616E-2},null,{"$f":"IF(K75=0,0,1/K75)","v":4.7619047619047616E-2},null,{"$f":"IF(M75=0,0,1/M75)","v":4.7619047619047616E-2},null,{"$f":"IF(O75=0,0,1/O75)","v":4.7619047619047616E-2},null,{"$f":"IF(Q75=0,0,1/Q75)","v":4.7619047619047616E-2},null,{"$f":"IF(S75=0,0,1/S75)","v":4.7619047619047616E-2},null,{"$f":"IF(U75=0,0,1/U75)","v":0.04},null,{"$f":"IF(W75=0,0,1/W75)","v":0.04}]
[null,null,"Capital Contributions Paid ",null,1609,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,2.5000000000000001E-2,null,{"$f":"IF(I77=0,0,1/I77)","v":2.5000000000000001E-2},null,{"$f":"IF(K77=0,0,1/K77)","v":2.5000000000000001E-2},null,{"$f":"IF(M77=0,0,1/M77)","v":2.5000000000000001E-2},null,{"$f":"IF(O77=0,0,1/O77)","v":2.5000000000000001E-2},null,{"$f":"IF(Q77=0,0,1/Q77)","v":2.5000000000000001E-2},null,{"$f":"IF(S77=0,0,1/S77)","v":2.5000000000000001E-2},null,{"$f":"IF(U77=0,0,1/U77)","v":2.5000000000000001E-2},null,{"$f":"IF(W77=0,0,1/W77)","v":2.5000000000000001E-2}]
[]
[]
[]
[null,"CCA Rates"]
[null,null,"OH Swtch & Cpctrs - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"OH Swtch & Cpctrs - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Concrete Poles - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"Concrete Poles - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Wood Poles - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"Wood Poles - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH Transformers - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"OH Transformers - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH Prim Cond & Dev - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"OH Prim Cond & Dev - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"OH Sec Cond & Dev - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"OH Sec Cond & Dev - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Transformers - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"UG Transformers - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,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,47,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,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Conduit - CCA Class",null,null,null,47,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,"UG Conduit - CCA Rate",null,null,null,0.08,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,"UG Prim XLPE TR - CCA Class",null,null,null,47,null,8,null,8,null,8,null,8,null,8,null,8,null,8,null,8]
[null,null,"UG Prim XLPE TR - CCA Rate",null,null,null,0.08,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2,null,0.2]
[]
[null,null,"UG Sec - Dir Buried - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"UG Sec - Dir Buried - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Sec In Duct/Svs - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"UG Sec In Duct/Svs - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Air Insulated Switchgear - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"Air Insulated Switchgear - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"Solid Dielectric Switchgear - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"Solid Dielectric Switchgear - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"UG Cable Injection - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"UG Cable Injection - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"MS Integrated P&C Systems  - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"MS Integrated P&C Systems  - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[null,null,"MS Building Improvements   - CCA Class",null,null,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"MS Building Improvements   - CCA Rate",null,null,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04,null,0.04]
[]
[null,null,"Capital Contributions Paid   - CCA Class",null,null,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"Capital Contributions Paid   - CCA Rate",null,null,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08,null,0.08]
[]
[]
[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":295,"n_cols":25,"rows_kept":295,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,null,null,{"$f":"'3. Cost_of_Service_Parameters'!G19","v":2018},null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Net Fixed Assets - CCR&A contributions"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I25","v":6804600},null,{"$f":"K25","v":6804600},null,{"$f":"M25","v":6804600},null,{"$f":"O25","v":6804600},null,{"$f":"Q25","v":6804600},null,{"$f":"S25","v":6804600},null,{"$f":"U25","v":6804600},null,{"$f":"W25","v":6804600}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G208","v":6804600},null,{"$f":"'2. ICM_Costs'!I182","v":0},null,{"$f":"'2. ICM_Costs'!K182","v":0},null,{"$f":"'2. ICM_Costs'!M182","v":0},null,{"$f":"'2. ICM_Costs'!O182","v":0},null,{"$f":"'2. ICM_Costs'!Q182","v":0},null,{"$f":"'2. ICM_Costs'!S182","v":0},null,{"$f":"'2. ICM_Costs'!U182","v":0},null,{"$f":"'2. ICM_Costs'!W182","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I22+I23-I24","v":6804600},null,{"$f":"K22+K23-K24","v":6804600},null,{"$f":"M22+M23-M24","v":6804600},null,{"$f":"O22+O23-O24","v":6804600},null,{"$f":"Q22+Q23-Q24","v":6804600},null,{"$f":"S22+S23-S24","v":6804600},null,{"$f":"U22+U23-U24","v":6804600},null,{"$f":"W22+W23-W24","v":6804600},null,{"$f":"Y22+Y23-Y24","v":6804600}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":-170115},null,{"$f":"K31","v":-340230},null,{"$f":"M31","v":-510345},null,{"$f":"O31","v":-680460},null,{"$f":"Q31","v":-850575},null,{"$f":"S31","v":-1020690},null,{"$f":"U31","v":-1190805},null,{"$f":"W31","v":-1360920}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I23/('3. Cost_of_Service_Parameters'!G77)+MIN((I22/'3. Cost_of_Service_Parameters'!G77),(I22+I28)))), 0, -(I23/('3. Cost_of_Service_Parameters'!G77)+MIN((I22/'3. Cost_of_Service_Parameters'!G77),(I22+I28))))","v":-170115},null,{"$f":"IF(ISERROR(-(K23/('3. Cost_of_Service_Parameters'!I77)+MIN((K22/'3. Cost_of_Service_Parameters'!I77),(K22+K28)))), 0, -(K23/('3. Cost_of_Service_Parameters'!I77)+MIN((K22/'3. Cost_of_Service_Parameters'!I77),(K22+K28))))","v":-170115},null,{"$f":"IF(ISERROR(-(M23/('3. Cost_of_Service_Parameters'!K77)+MIN((M22/'3. Cost_of_Service_Parameters'!K77),(M22+M28)))), 0, -(M23/('3. Cost_of_Service_Parameters'!K77)+MIN((M22/'3. Cost_of_Service_Parameters'!K77),(M22+M28))))","v":-170115},null,{"$f":"IF(ISERROR(-(O23/('3. Cost_of_Service_Parameters'!M77)+MIN((O22/'3. Cost_of_Service_Parameters'!M77),(O22+O28)))), 0, -(O23/('3. Cost_of_Service_Parameters'!M77)+MIN((O22/'3. Cost_of_Service_Parameters'!M77),(O22+O28))))","v":-170115},null,{"$f":"IF(ISERROR(-(Q23/('3. Cost_of_Service_Parameters'!O77)+MIN((Q22/'3. Cost_of_Service_Parameters'!O77),(Q22+Q28)))), 0, -(Q23/('3. Cost_of_Service_Parameters'!O77)+MIN((Q22/'3. Cost_of_Service_Parameters'!O77),(Q22+Q28))))","v":-170115},null,{"$f":"IF(ISERROR(-(S23/('3. Cost_of_Service_Parameters'!Q77)+MIN((S22/'3. Cost_of_Service_Parameters'!Q77),(S22+S28)))), 0, -(S23/('3. Cost_of_Service_Parameters'!Q77)+MIN((S22/'3. Cost_of_Service_Parameters'!Q77),(S22+S28))))","v":-170115},null,{"$f":"IF(ISERROR(-(U23/('3. Cost_of_Service_Parameters'!S77)+MIN((U22/'3. Cost_of_Service_Parameters'!S77),(U22+U28)))), 0, -(U23/('3. Cost_of_Service_Parameters'!S77)+MIN((U22/'3. Cost_of_Service_Parameters'!S77),(U22+U28))))","v":-170115},null,{"$f":"IF(ISERROR(-(W23/('3. Cost_of_Service_Parameters'!U77)+MIN((W22/'3. Cost_of_Service_Parameters'!U77),(W22+W28)))), 0, -(W23/('3. Cost_of_Service_Parameters'!U77)+MIN((W22/'3. Cost_of_Service_Parameters'!U77),(W22+W28))))","v":-170115},null,{"$f":"IF(ISERROR(-(Y23/('3. Cost_of_Service_Parameters'!W77)+MIN((Y22/'3. Cost_of_Service_Parameters'!W77),(Y22+Y28)))), 0, -(Y23/('3. Cost_of_Service_Parameters'!W77)+MIN((Y22/'3. Cost_of_Service_Parameters'!W77),(Y22+Y28))))","v":-170115}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":-170115},null,{"$f":"K28+K29-K30","v":-340230},null,{"$f":"M28+M29-M30","v":-510345},null,{"$f":"O28+O29-O30","v":-680460},null,{"$f":"Q28+Q29-Q30","v":-850575},null,{"$f":"S28+S29-S30","v":-1020690},null,{"$f":"U28+U29-U30","v":-1190805},null,{"$f":"W28+W29-W30","v":-1360920},null,{"$f":"Y28+Y29-Y30","v":-1531035}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,{"$f":"I35","v":6634485},null,{"$f":"K35","v":6464370},null,{"$f":"M35","v":6294255},null,{"$f":"O35","v":6124140},null,{"$f":"Q35","v":5954025},null,{"$f":"S35","v":5783910},null,{"$f":"U35","v":5613795},null,{"$f":"W35","v":5443680}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":6634485},null,{"$f":"K25+K31","v":6464370},null,{"$f":"M25+M31","v":6294255},null,{"$f":"O25+O31","v":6124140},null,{"$f":"Q25+Q31","v":5954025},null,{"$f":"S25+S31","v":5783910},null,{"$f":"U25+U31","v":5613795},null,{"$f":"W25+W31","v":5443680},null,{"$f":"Y25+Y31","v":5273565}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":6634485},null,{"$f":"AVERAGE(K34:K35)","v":6549427.5},null,{"$f":"AVERAGE(M34:M35)","v":6379312.5},null,{"$f":"AVERAGE(O34:O35)","v":6209197.5},null,{"$f":"AVERAGE(Q34:Q35)","v":6039082.5},null,{"$f":"AVERAGE(S34:S35)","v":5868967.5},null,{"$f":"AVERAGE(U34:U35)","v":5698852.5},null,{"$f":"AVERAGE(W34:W35)","v":5528737.5},null,{"$f":"AVERAGE(Y34:Y35)","v":5358622.5}]
[]
[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":0},null,{"$f":"K44","v":0},null,{"$f":"M44","v":0},null,{"$f":"O44","v":0},null,{"$f":"Q44","v":0},null,{"$f":"S44","v":0},null,{"$f":"U44","v":0},null,{"$f":"W44","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G184","v":0},null,{"$f":"'2. ICM_Costs'!I184","v":0},null,{"$f":"'2. ICM_Costs'!K184","v":0},null,{"$f":"'2. ICM_Costs'!M184","v":0},null,{"$f":"'2. ICM_Costs'!O184","v":0},null,{"$f":"'2. ICM_Costs'!Q184","v":0},null,{"$f":"'2. ICM_Costs'!S184","v":0},null,{"$f":"'2. ICM_Costs'!U184","v":0},null,{"$f":"'2. ICM_Costs'!W184","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I41+I42-I43","v":0},null,{"$f":"K41+K42-K43","v":0},null,{"$f":"M41+M42-M43","v":0},null,{"$f":"O41+O42-O43","v":0},null,{"$f":"Q41+Q42-Q43","v":0},null,{"$f":"S41+S42-S43","v":0},null,{"$f":"U41+U42-U43","v":0},null,{"$f":"W41+W42-W43","v":0},null,{"$f":"Y41+Y42-Y43","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":0},null,{"$f":"K50","v":0},null,{"$f":"M50","v":0},null,{"$f":"O50","v":0},null,{"$f":"Q50","v":0},null,{"$f":"S50","v":0},null,{"$f":"U50","v":0},null,{"$f":"W50","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47)))), 0, -(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47))))","v":0},null,{"$f":"IF(ISERROR(-(O42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!M47),(O41+O47)))), 0, -(O42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!M47),(O41+O47))))","v":0},null,{"$f":"IF(ISERROR(-(Q42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!O47),(Q41+Q47)))), 0, -(Q42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!O47),(Q41+Q47))))","v":0},null,{"$f":"IF(ISERROR(-(S42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!Q47),(S41+S47)))), 0, -(S42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!Q47),(S41+S47))))","v":0},null,{"$f":"IF(ISERROR(-(U42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!S47),(U41+U47)))), 0, -(U42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!S47),(U41+U47))))","v":0},null,{"$f":"IF(ISERROR(-(W42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((W41/'3. Cost_of_Service_Parameters'!U47),(W41+W47)))), 0, -(W42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((W41/'3. Cost_of_Service_Parameters'!U47),(W41+W47))))","v":0},null,{"$f":"IF(ISERROR(-(Y42/('3. Cost_of_Service_Parameters'!W47*2)+MIN((Y41/'3. Cost_of_Service_Parameters'!W47),(Y41+Y47)))), 0, -(Y42/('3. Cost_of_Service_Parameters'!W47*2)+MIN((Y41/'3. Cost_of_Service_Parameters'!W47),(Y41+Y47))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":0},null,{"$f":"K47+K48-K49","v":0},null,{"$f":"M47+M48-M49","v":0},null,{"$f":"O47+O48-O49","v":0},null,{"$f":"Q47+Q48-Q49","v":0},null,{"$f":"S47+S48-S49","v":0},null,{"$f":"U47+U48-U49","v":0},null,{"$f":"W47+W48-W49","v":0},null,{"$f":"Y47+Y48-Y49","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,{"$f":"I54","v":0},null,{"$f":"K54","v":0},null,{"$f":"M54","v":0},null,{"$f":"O54","v":0},null,{"$f":"Q54","v":0},null,{"$f":"S54","v":0},null,{"$f":"U54","v":0},null,{"$f":"W54","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":0},null,{"$f":"K44+K50","v":0},null,{"$f":"M44+M50","v":0},null,{"$f":"O44+O50","v":0},null,{"$f":"Q44+Q50","v":0},null,{"$f":"S44+S50","v":0},null,{"$f":"U44+U50","v":0},null,{"$f":"W44+W50","v":0},null,{"$f":"Y44+Y50","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":0},null,{"$f":"AVERAGE(K53:K54)","v":0},null,{"$f":"AVERAGE(M53:M54)","v":0},null,{"$f":"AVERAGE(O53:O54)","v":0},null,{"$f":"AVERAGE(Q53:Q54)","v":0},null,{"$f":"AVERAGE(S53:S54)","v":0},null,{"$f":"AVERAGE(U53:U54)","v":0},null,{"$f":"AVERAGE(W53:W54)","v":0},null,{"$f":"AVERAGE(Y53:Y54)","v":0}]
[]
[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":0},null,{"$f":"K63","v":0},null,{"$f":"M63","v":0},null,{"$f":"O63","v":0},null,{"$f":"Q63","v":0},null,{"$f":"S63","v":0},null,{"$f":"U63","v":0},null,{"$f":"W63","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G186","v":0},null,{"$f":"'2. ICM_Costs'!I186","v":0},null,{"$f":"'2. ICM_Costs'!K186","v":0},null,{"$f":"'2. ICM_Costs'!M186","v":0},null,{"$f":"'2. ICM_Costs'!O186","v":0},null,{"$f":"'2. ICM_Costs'!Q186","v":0},null,{"$f":"'2. ICM_Costs'!S186","v":0},null,{"$f":"'2. ICM_Costs'!U186","v":0},null,{"$f":"'2. ICM_Costs'!W186","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":0},null,{"$f":"K60+K61-K62","v":0},null,{"$f":"M60+M61-M62","v":0},null,{"$f":"O60+O61-O62","v":0},null,{"$f":"Q60+Q61-Q62","v":0},null,{"$f":"S60+S61-S62","v":0},null,{"$f":"U60+U61-U62","v":0},null,{"$f":"W60+W61-W62","v":0},null,{"$f":"Y60+Y61-Y62","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":0},null,{"$f":"K69","v":0},null,{"$f":"M69","v":0},null,{"$f":"O69","v":0},null,{"$f":"Q69","v":0},null,{"$f":"S69","v":0},null,{"$f":"U69","v":0},null,{"$f":"W69","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!K49),(M60+M66)))), 0, -(M61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!K49),(M60+M66))))","v":0},null,{"$f":"IF(ISERROR(-(O61/('3. Cost_of_Service_Parameters'!M49*2)+MIN((O60/'3. Cost_of_Service_Parameters'!M49),(O60+O66)))), 0, -(O61/('3. Cost_of_Service_Parameters'!M49*2)+MIN((O60/'3. Cost_of_Service_Parameters'!M49),(O60+O66))))","v":0},null,{"$f":"IF(ISERROR(-(Q61/('3. Cost_of_Service_Parameters'!O49*2)+MIN((Q60/'3. Cost_of_Service_Parameters'!O49),(Q60+Q66)))), 0, -(Q61/('3. Cost_of_Service_Parameters'!O49*2)+MIN((Q60/'3. Cost_of_Service_Parameters'!O49),(Q60+Q66))))","v":0},null,{"$f":"IF(ISERROR(-(S61/('3. Cost_of_Service_Parameters'!Q49*2)+MIN((S60/'3. Cost_of_Service_Parameters'!Q49),(S60+S66)))), 0, -(S61/('3. Cost_of_Service_Parameters'!Q49*2)+MIN((S60/'3. Cost_of_Service_Parameters'!Q49),(S60+S66))))","v":0},null,{"$f":"IF(ISERROR(-(U61/('3. Cost_of_Service_Parameters'!S49*2)+MIN((U60/'3. Cost_of_Service_Parameters'!S49),(U60+U66)))), 0, -(U61/('3. Cost_of_Service_Parameters'!S49*2)+MIN((U60/'3. Cost_of_Service_Parameters'!S49),(U60+U66))))","v":0},null,{"$f":"IF(ISERROR(-(W61/('3. Cost_of_Service_Parameters'!U49*2)+MIN((W60/'3. Cost_of_Service_Parameters'!U49),(W60+W66)))), 0, -(W61/('3. Cost_of_Service_Parameters'!U49*2)+MIN((W60/'3. Cost_of_Service_Parameters'!U49),(W60+W66))))","v":0},null,{"$f":"IF(ISERROR(-(Y61/('3. Cost_of_Service_Parameters'!W49*2)+MIN((Y60/'3. Cost_of_Service_Parameters'!W49),(Y60+Y66)))), 0, -(Y61/('3. Cost_of_Service_Parameters'!W49*2)+MIN((Y60/'3. Cost_of_Service_Parameters'!W49),(Y60+Y66))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":0},null,{"$f":"K66+K67-K68","v":0},null,{"$f":"M66+M67-M68","v":0},null,{"$f":"O66+O67-O68","v":0},null,{"$f":"Q66+Q67-Q68","v":0},null,{"$f":"S66+S67-S68","v":0},null,{"$f":"U66+U67-U68","v":0},null,{"$f":"W66+W67-W68","v":0},null,{"$f":"Y66+Y67-Y68","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,{"$f":"I73","v":0},null,{"$f":"K73","v":0},null,{"$f":"M73","v":0},null,{"$f":"O73","v":0},null,{"$f":"Q73","v":0},null,{"$f":"S73","v":0},null,{"$f":"U73","v":0},null,{"$f":"W73","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":0},null,{"$f":"K63+K69","v":0},null,{"$f":"M63+M69","v":0},null,{"$f":"O63+O69","v":0},null,{"$f":"Q63+Q69","v":0},null,{"$f":"S63+S69","v":0},null,{"$f":"U63+U69","v":0},null,{"$f":"W63+W69","v":0},null,{"$f":"Y63+Y69","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":0},null,{"$f":"AVERAGE(K72:K73)","v":0},null,{"$f":"AVERAGE(M72:M73)","v":0},null,{"$f":"AVERAGE(O72:O73)","v":0},null,{"$f":"AVERAGE(Q72:Q73)","v":0},null,{"$f":"AVERAGE(S72:S73)","v":0},null,{"$f":"AVERAGE(U72:U73)","v":0},null,{"$f":"AVERAGE(W72:W73)","v":0},null,{"$f":"AVERAGE(Y72:Y73)","v":0}]
[]
[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":0},null,{"$f":"K82","v":0},null,{"$f":"M82","v":0},null,{"$f":"O82","v":0},null,{"$f":"Q82","v":0},null,{"$f":"S82","v":0},null,{"$f":"U82","v":0},null,{"$f":"W82","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":0},null,{"$f":"'2. ICM_Costs'!I188","v":0},null,{"$f":"'2. ICM_Costs'!K188","v":0},null,{"$f":"'2. ICM_Costs'!M188","v":0},null,{"$f":"'2. ICM_Costs'!O188","v":0},null,{"$f":"'2. ICM_Costs'!Q188","v":0},null,{"$f":"'2. ICM_Costs'!S188","v":0},null,{"$f":"'2. ICM_Costs'!U188","v":0},null,{"$f":"'2. ICM_Costs'!W188","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":0},null,{"$f":"K79+K80-K81","v":0},null,{"$f":"M79+M80-M81","v":0},null,{"$f":"O79+O80-O81","v":0},null,{"$f":"Q79+Q80-Q81","v":0},null,{"$f":"S79+S80-S81","v":0},null,{"$f":"U79+U80-U81","v":0},null,{"$f":"W79+W80-W81","v":0},null,{"$f":"Y79+Y80-Y81","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":0},null,{"$f":"K88","v":0},null,{"$f":"M88","v":0},null,{"$f":"O88","v":0},null,{"$f":"Q88","v":0},null,{"$f":"S88","v":0},null,{"$f":"U88","v":0},null,{"$f":"W88","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!K51),(M79+M85)))), 0, -(M80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!K51),(M79+M85))))","v":0},null,{"$f":"IF(ISERROR(-(O80/('3. Cost_of_Service_Parameters'!M51*2)+MIN((O79/'3. Cost_of_Service_Parameters'!M51),(O79+O85)))), 0, -(O80/('3. Cost_of_Service_Parameters'!M51*2)+MIN((O79/'3. Cost_of_Service_Parameters'!M51),(O79+O85))))","v":0},null,{"$f":"IF(ISERROR(-(Q80/('3. Cost_of_Service_Parameters'!O51*2)+MIN((Q79/'3. Cost_of_Service_Parameters'!O51),(Q79+Q85)))), 0, -(Q80/('3. Cost_of_Service_Parameters'!O51*2)+MIN((Q79/'3. Cost_of_Service_Parameters'!O51),(Q79+Q85))))","v":0},null,{"$f":"IF(ISERROR(-(S80/('3. Cost_of_Service_Parameters'!Q51*2)+MIN((S79/'3. Cost_of_Service_Parameters'!Q51),(S79+S85)))), 0, -(S80/('3. Cost_of_Service_Parameters'!Q51*2)+MIN((S79/'3. Cost_of_Service_Parameters'!Q51),(S79+S85))))","v":0},null,{"$f":"IF(ISERROR(-(U80/('3. Cost_of_Service_Parameters'!S51*2)+MIN((U79/'3. Cost_of_Service_Parameters'!S51),(U79+U85)))), 0, -(U80/('3. Cost_of_Service_Parameters'!S51*2)+MIN((U79/'3. Cost_of_Service_Parameters'!S51),(U79+U85))))","v":0},null,{"$f":"IF(ISERROR(-(W80/('3. Cost_of_Service_Parameters'!U51*2)+MIN((W79/'3. Cost_of_Service_Parameters'!U51),(W79+W85)))), 0, -(W80/('3. Cost_of_Service_Parameters'!U51*2)+MIN((W79/'3. Cost_of_Service_Parameters'!U51),(W79+W85))))","v":0},null,{"$f":"IF(ISERROR(-(Y80/('3. Cost_of_Service_Parameters'!W51*2)+MIN((Y79/'3. Cost_of_Service_Parameters'!W51),(Y79+Y85)))), 0, -(Y80/('3. Cost_of_Service_Parameters'!W51*2)+MIN((Y79/'3. Cost_of_Service_Parameters'!W51),(Y79+Y85))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":0},null,{"$f":"K85+K86-K87","v":0},null,{"$f":"M85+M86-M87","v":0},null,{"$f":"O85+O86-O87","v":0},null,{"$f":"Q85+Q86-Q87","v":0},null,{"$f":"S85+S86-S87","v":0},null,{"$f":"U85+U86-U87","v":0},null,{"$f":"W85+W86-W87","v":0},null,{"$f":"Y85+Y86-Y87","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,{"$f":"I92","v":0},null,{"$f":"K92","v":0},null,{"$f":"M92","v":0},null,{"$f":"O92","v":0},null,{"$f":"Q92","v":0},null,{"$f":"S92","v":0},null,{"$f":"U92","v":0},null,{"$f":"W92","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":0},null,{"$f":"K82+K88","v":0},null,{"$f":"M82+M88","v":0},null,{"$f":"O82+O88","v":0},null,{"$f":"Q82+Q88","v":0},null,{"$f":"S82+S88","v":0},null,{"$f":"U82+U88","v":0},null,{"$f":"W82+W88","v":0},null,{"$f":"Y82+Y88","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":0},null,{"$f":"AVERAGE(K91:K92)","v":0},null,{"$f":"AVERAGE(M91:M92)","v":0},null,{"$f":"AVERAGE(O91:O92)","v":0},null,{"$f":"AVERAGE(Q91:Q92)","v":0},null,{"$f":"AVERAGE(S91:S92)","v":0},null,{"$f":"AVERAGE(U91:U92)","v":0},null,{"$f":"AVERAGE(W91:W92)","v":0},null,{"$f":"AVERAGE(Y91:Y92)","v":0}]
[]
[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":0},null,{"$f":"K101","v":0},null,{"$f":"M101","v":0},null,{"$f":"O101","v":0},null,{"$f":"Q101","v":0},null,{"$f":"S101","v":0},null,{"$f":"U101","v":0},null,{"$f":"W101","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":0},null,{"$f":"'2. ICM_Costs'!I190","v":0},null,{"$f":"'2. ICM_Costs'!K190","v":0},null,{"$f":"'2. ICM_Costs'!M190","v":0},null,{"$f":"'2. ICM_Costs'!O190","v":0},null,{"$f":"'2. ICM_Costs'!Q190","v":0},null,{"$f":"'2. ICM_Costs'!S190","v":0},null,{"$f":"'2. ICM_Costs'!U190","v":0},null,{"$f":"'2. ICM_Costs'!W190","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I98+I99-I100","v":0},null,{"$f":"K98+K99-K100","v":0},null,{"$f":"M98+M99-M100","v":0},null,{"$f":"O98+O99-O100","v":0},null,{"$f":"Q98+Q99-Q100","v":0},null,{"$f":"S98+S99-S100","v":0},null,{"$f":"U98+U99-U100","v":0},null,{"$f":"W98+W99-W100","v":0},null,{"$f":"Y98+Y99-Y100","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":0},null,{"$f":"K107","v":0},null,{"$f":"M107","v":0},null,{"$f":"O107","v":0},null,{"$f":"Q107","v":0},null,{"$f":"S107","v":0},null,{"$f":"U107","v":0},null,{"$f":"W107","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!K53),(M98+M104)))), 0, -(M99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!K53),(M98+M104))))","v":0},null,{"$f":"IF(ISERROR(-(O99/('3. Cost_of_Service_Parameters'!M53*2)+MIN((O98/'3. Cost_of_Service_Parameters'!M53),(O98+O104)))), 0, -(O99/('3. Cost_of_Service_Parameters'!M53*2)+MIN((O98/'3. Cost_of_Service_Parameters'!M53),(O98+O104))))","v":0},null,{"$f":"IF(ISERROR(-(Q99/('3. Cost_of_Service_Parameters'!O53*2)+MIN((Q98/'3. Cost_of_Service_Parameters'!O53),(Q98+Q104)))), 0, -(Q99/('3. Cost_of_Service_Parameters'!O53*2)+MIN((Q98/'3. Cost_of_Service_Parameters'!O53),(Q98+Q104))))","v":0},null,{"$f":"IF(ISERROR(-(S99/('3. Cost_of_Service_Parameters'!Q53*2)+MIN((S98/'3. Cost_of_Service_Parameters'!Q53),(S98+S104)))), 0, -(S99/('3. Cost_of_Service_Parameters'!Q53*2)+MIN((S98/'3. Cost_of_Service_Parameters'!Q53),(S98+S104))))","v":0},null,{"$f":"IF(ISERROR(-(U99/('3. Cost_of_Service_Parameters'!S53*2)+MIN((U98/'3. Cost_of_Service_Parameters'!S53),(U98+U104)))), 0, -(U99/('3. Cost_of_Service_Parameters'!S53*2)+MIN((U98/'3. Cost_of_Service_Parameters'!S53),(U98+U104))))","v":0},null,{"$f":"IF(ISERROR(-(W99/('3. Cost_of_Service_Parameters'!U53*2)+MIN((W98/'3. Cost_of_Service_Parameters'!U53),(W98+W104)))), 0, -(W99/('3. Cost_of_Service_Parameters'!U53*2)+MIN((W98/'3. Cost_of_Service_Parameters'!U53),(W98+W104))))","v":0},null,{"$f":"IF(ISERROR(-(Y99/('3. Cost_of_Service_Parameters'!W53*2)+MIN((Y98/'3. Cost_of_Service_Parameters'!W53),(Y98+Y104)))), 0, -(Y99/('3. Cost_of_Service_Parameters'!W53*2)+MIN((Y98/'3. Cost_of_Service_Parameters'!W53),(Y98+Y104))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":0},null,{"$f":"K104+K105-K106","v":0},null,{"$f":"M104+M105-M106","v":0},null,{"$f":"O104+O105-O106","v":0},null,{"$f":"Q104+Q105-Q106","v":0},null,{"$f":"S104+S105-S106","v":0},null,{"$f":"U104+U105-U106","v":0},null,{"$f":"W104+W105-W106","v":0},null,{"$f":"Y104+Y105-Y106","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,{"$f":"I111","v":0},null,{"$f":"K111","v":0},null,{"$f":"M111","v":0},null,{"$f":"O111","v":0},null,{"$f":"Q111","v":0},null,{"$f":"S111","v":0},null,{"$f":"U111","v":0},null,{"$f":"W111","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":0},null,{"$f":"K101+K107","v":0},null,{"$f":"M101+M107","v":0},null,{"$f":"O101+O107","v":0},null,{"$f":"Q101+Q107","v":0},null,{"$f":"S101+S107","v":0},null,{"$f":"U101+U107","v":0},null,{"$f":"W101+W107","v":0},null,{"$f":"Y101+Y107","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":0},null,{"$f":"AVERAGE(K110:K111)","v":0},null,{"$f":"AVERAGE(M110:M111)","v":0},null,{"$f":"AVERAGE(O110:O111)","v":0},null,{"$f":"AVERAGE(Q110:Q111)","v":0},null,{"$f":"AVERAGE(S110:S111)","v":0},null,{"$f":"AVERAGE(U110:U111)","v":0},null,{"$f":"AVERAGE(W110:W111)","v":0},null,{"$f":"AVERAGE(Y110:Y111)","v":0}]
[]
[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":0},null,{"$f":"K120","v":0},null,{"$f":"M120","v":0},null,{"$f":"O120","v":0},null,{"$f":"Q120","v":0},null,{"$f":"S120","v":0},null,{"$f":"U120","v":0},null,{"$f":"W120","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":0},null,{"$f":"'2. ICM_Costs'!I192","v":0},null,{"$f":"'2. ICM_Costs'!K192","v":0},null,{"$f":"'2. ICM_Costs'!M192","v":0},null,{"$f":"'2. ICM_Costs'!O192","v":0},null,{"$f":"'2. ICM_Costs'!Q192","v":0},null,{"$f":"'2. ICM_Costs'!S192","v":0},null,{"$f":"'2. ICM_Costs'!U192","v":0},null,{"$f":"'2. ICM_Costs'!W192","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I117+I118-I119","v":0},null,{"$f":"K117+K118-K119","v":0},null,{"$f":"M117+M118-M119","v":0},null,{"$f":"O117+O118-O119","v":0},null,{"$f":"Q117+Q118-Q119","v":0},null,{"$f":"S117+S118-S119","v":0},null,{"$f":"U117+U118-U119","v":0},null,{"$f":"W117+W118-W119","v":0},null,{"$f":"Y117+Y118-Y119","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":0},null,{"$f":"K126","v":0},null,{"$f":"M126","v":0},null,{"$f":"O126","v":0},null,{"$f":"Q126","v":0},null,{"$f":"S126","v":0},null,{"$f":"U126","v":0},null,{"$f":"W126","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M118/('3. Cost_of_Service_Parameters'!K55*2)+MIN((M117/'3. Cost_of_Service_Parameters'!K55),(M117+M123)))), 0, -(M118/('3. Cost_of_Service_Parameters'!K55*2)+MIN((M117/'3. Cost_of_Service_Parameters'!K55),(M117+M123))))","v":0},null,{"$f":"IF(ISERROR(-(O118/('3. Cost_of_Service_Parameters'!M55*2)+MIN((O117/'3. Cost_of_Service_Parameters'!M55),(O117+O123)))), 0, -(O118/('3. Cost_of_Service_Parameters'!M55*2)+MIN((O117/'3. Cost_of_Service_Parameters'!M55),(O117+O123))))","v":0},null,{"$f":"IF(ISERROR(-(Q118/('3. Cost_of_Service_Parameters'!O55*2)+MIN((Q117/'3. Cost_of_Service_Parameters'!O55),(Q117+Q123)))), 0, -(Q118/('3. Cost_of_Service_Parameters'!O55*2)+MIN((Q117/'3. Cost_of_Service_Parameters'!O55),(Q117+Q123))))","v":0},null,{"$f":"IF(ISERROR(-(S118/('3. Cost_of_Service_Parameters'!Q55*2)+MIN((S117/'3. Cost_of_Service_Parameters'!Q55),(S117+S123)))), 0, -(S118/('3. Cost_of_Service_Parameters'!Q55*2)+MIN((S117/'3. Cost_of_Service_Parameters'!Q55),(S117+S123))))","v":0},null,{"$f":"IF(ISERROR(-(U118/('3. Cost_of_Service_Parameters'!S55*2)+MIN((U117/'3. Cost_of_Service_Parameters'!S55),(U117+U123)))), 0, -(U118/('3. Cost_of_Service_Parameters'!S55*2)+MIN((U117/'3. Cost_of_Service_Parameters'!S55),(U117+U123))))","v":0},null,{"$f":"IF(ISERROR(-(W118/('3. Cost_of_Service_Parameters'!U55*2)+MIN((W117/'3. Cost_of_Service_Parameters'!U55),(W117+W123)))), 0, -(W118/('3. Cost_of_Service_Parameters'!U55*2)+MIN((W117/'3. Cost_of_Service_Parameters'!U55),(W117+W123))))","v":0},null,{"$f":"IF(ISERROR(-(Y118/('3. Cost_of_Service_Parameters'!W55*2)+MIN((Y117/'3. Cost_of_Service_Parameters'!W55),(Y117+Y123)))), 0, -(Y118/('3. Cost_of_Service_Parameters'!W55*2)+MIN((Y117/'3. Cost_of_Service_Parameters'!W55),(Y117+Y123))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":0},null,{"$f":"K123+K124-K125","v":0},null,{"$f":"M123+M124-M125","v":0},null,{"$f":"O123+O124-O125","v":0},null,{"$f":"Q123+Q124-Q125","v":0},null,{"$f":"S123+S124-S125","v":0},null,{"$f":"U123+U124-U125","v":0},null,{"$f":"W123+W124-W125","v":0},null,{"$f":"Y123+Y124-Y125","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,{"$f":"I130","v":0},null,{"$f":"K130","v":0},null,{"$f":"M130","v":0},null,{"$f":"O130","v":0},null,{"$f":"Q130","v":0},null,{"$f":"S130","v":0},null,{"$f":"U130","v":0},null,{"$f":"W130","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":0},null,{"$f":"K120+K126","v":0},null,{"$f":"M120+M126","v":0},null,{"$f":"O120+O126","v":0},null,{"$f":"Q120+Q126","v":0},null,{"$f":"S120+S126","v":0},null,{"$f":"U120+U126","v":0},null,{"$f":"W120+W126","v":0},null,{"$f":"Y120+Y126","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":0},null,{"$f":"AVERAGE(K129:K130)","v":0},null,{"$f":"AVERAGE(M129:M130)","v":0},null,{"$f":"AVERAGE(O129:O130)","v":0},null,{"$f":"AVERAGE(Q129:Q130)","v":0},null,{"$f":"AVERAGE(S129:S130)","v":0},null,{"$f":"AVERAGE(U129:U130)","v":0},null,{"$f":"AVERAGE(W129:W130)","v":0},null,{"$f":"AVERAGE(Y129:Y130)","v":0}]
[]
[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":0},null,{"$f":"K139","v":0},null,{"$f":"M139","v":0},null,{"$f":"O139","v":0},null,{"$f":"Q139","v":0},null,{"$f":"S139","v":0},null,{"$f":"U139","v":0},null,{"$f":"W139","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G194","v":0},null,{"$f":"'2. ICM_Costs'!I194","v":0},null,{"$f":"'2. ICM_Costs'!K194","v":0},null,{"$f":"'2. ICM_Costs'!M194","v":0},null,{"$f":"'2. ICM_Costs'!O194","v":0},null,{"$f":"'2. ICM_Costs'!Q194","v":0},null,{"$f":"'2. ICM_Costs'!S194","v":0},null,{"$f":"'2. ICM_Costs'!U194","v":0},null,{"$f":"'2. ICM_Costs'!W194","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I136+I137-I138","v":0},null,{"$f":"K136+K137-K138","v":0},null,{"$f":"M136+M137-M138","v":0},null,{"$f":"O136+O137-O138","v":0},null,{"$f":"Q136+Q137-Q138","v":0},null,{"$f":"S136+S137-S138","v":0},null,{"$f":"U136+U137-U138","v":0},null,{"$f":"W136+W137-W138","v":0},null,{"$f":"Y136+Y137-Y138","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":0},null,{"$f":"K145","v":0},null,{"$f":"M145","v":0},null,{"$f":"O145","v":0},null,{"$f":"Q145","v":0},null,{"$f":"S145","v":0},null,{"$f":"U145","v":0},null,{"$f":"W145","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M137/('3. Cost_of_Service_Parameters'!K57*2)+MIN((M136/'3. Cost_of_Service_Parameters'!K57),(M136+M142)))), 0, -(M137/('3. Cost_of_Service_Parameters'!K57*2)+MIN((M136/'3. Cost_of_Service_Parameters'!K57),(M136+M142))))","v":0},null,{"$f":"IF(ISERROR(-(O137/('3. Cost_of_Service_Parameters'!M57*2)+MIN((O136/'3. Cost_of_Service_Parameters'!M57),(O136+O142)))), 0, -(O137/('3. Cost_of_Service_Parameters'!M57*2)+MIN((O136/'3. Cost_of_Service_Parameters'!M57),(O136+O142))))","v":0},null,{"$f":"IF(ISERROR(-(Q137/('3. Cost_of_Service_Parameters'!O57*2)+MIN((Q136/'3. Cost_of_Service_Parameters'!O57),(Q136+Q142)))), 0, -(Q137/('3. Cost_of_Service_Parameters'!O57*2)+MIN((Q136/'3. Cost_of_Service_Parameters'!O57),(Q136+Q142))))","v":0},null,{"$f":"IF(ISERROR(-(S137/('3. Cost_of_Service_Parameters'!Q57*2)+MIN((S136/'3. Cost_of_Service_Parameters'!Q57),(S136+S142)))), 0, -(S137/('3. Cost_of_Service_Parameters'!Q57*2)+MIN((S136/'3. Cost_of_Service_Parameters'!Q57),(S136+S142))))","v":0},null,{"$f":"IF(ISERROR(-(U137/('3. Cost_of_Service_Parameters'!S57*2)+MIN((U136/'3. Cost_of_Service_Parameters'!S57),(U136+U142)))), 0, -(U137/('3. Cost_of_Service_Parameters'!S57*2)+MIN((U136/'3. Cost_of_Service_Parameters'!S57),(U136+U142))))","v":0},null,{"$f":"IF(ISERROR(-(W137/('3. Cost_of_Service_Parameters'!U57*2)+MIN((W136/'3. Cost_of_Service_Parameters'!U57),(W136+W142)))), 0, -(W137/('3. Cost_of_Service_Parameters'!U57*2)+MIN((W136/'3. Cost_of_Service_Parameters'!U57),(W136+W142))))","v":0},null,{"$f":"IF(ISERROR(-(Y137/('3. Cost_of_Service_Parameters'!W57*2)+MIN((Y136/'3. Cost_of_Service_Parameters'!W57),(Y136+Y142)))), 0, -(Y137/('3. Cost_of_Service_Parameters'!W57*2)+MIN((Y136/'3. Cost_of_Service_Parameters'!W57),(Y136+Y142))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":0},null,{"$f":"K142+K143-K144","v":0},null,{"$f":"M142+M143-M144","v":0},null,{"$f":"O142+O143-O144","v":0},null,{"$f":"Q142+Q143-Q144","v":0},null,{"$f":"S142+S143-S144","v":0},null,{"$f":"U142+U143-U144","v":0},null,{"$f":"W142+W143-W144","v":0},null,{"$f":"Y142+Y143-Y144","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,{"$f":"I149","v":0},null,{"$f":"K149","v":0},null,{"$f":"M149","v":0},null,{"$f":"O149","v":0},null,{"$f":"Q149","v":0},null,{"$f":"S149","v":0},null,{"$f":"U149","v":0},null,{"$f":"W149","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":0},null,{"$f":"K139+K145","v":0},null,{"$f":"M139+M145","v":0},null,{"$f":"O139+O145","v":0},null,{"$f":"Q139+Q145","v":0},null,{"$f":"S139+S145","v":0},null,{"$f":"U139+U145","v":0},null,{"$f":"W139+W145","v":0},null,{"$f":"Y139+Y145","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":0},null,{"$f":"AVERAGE(K148:K149)","v":0},null,{"$f":"AVERAGE(M148:M149)","v":0},null,{"$f":"AVERAGE(O148:O149)","v":0},null,{"$f":"AVERAGE(Q148:Q149)","v":0},null,{"$f":"AVERAGE(S148:S149)","v":0},null,{"$f":"AVERAGE(U148:U149)","v":0},null,{"$f":"AVERAGE(W148:W149)","v":0},null,{"$f":"AVERAGE(Y148:Y149)","v":0}]
[]
[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":0},null,{"$f":"K158","v":0},null,{"$f":"M158","v":0},null,{"$f":"O158","v":0},null,{"$f":"Q158","v":0},null,{"$f":"S158","v":0},null,{"$f":"U158","v":0},null,{"$f":"W158","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G196","v":0},null,{"$f":"'2. ICM_Costs'!I196","v":0},null,{"$f":"'2. ICM_Costs'!K196","v":0},null,{"$f":"'2. ICM_Costs'!M196","v":0},null,{"$f":"'2. ICM_Costs'!O196","v":0},null,{"$f":"'2. ICM_Costs'!Q196","v":0},null,{"$f":"'2. ICM_Costs'!S196","v":0},null,{"$f":"'2. ICM_Costs'!U196","v":0},null,{"$f":"'2. ICM_Costs'!W196","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I155+I156-I157","v":0},null,{"$f":"K155+K156-K157","v":0},null,{"$f":"M155+M156-M157","v":0},null,{"$f":"O155+O156-O157","v":0},null,{"$f":"Q155+Q156-Q157","v":0},null,{"$f":"S155+S156-S157","v":0},null,{"$f":"U155+U156-U157","v":0},null,{"$f":"W155+W156-W157","v":0},null,{"$f":"Y155+Y156-Y157","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I164","v":0},null,{"$f":"K164","v":0},null,{"$f":"M164","v":0},null,{"$f":"O164","v":0},null,{"$f":"Q164","v":0},null,{"$f":"S164","v":0},null,{"$f":"U164","v":0},null,{"$f":"W164","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M156/('3. Cost_of_Service_Parameters'!K59*2)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161)))), 0, -(M156/('3. Cost_of_Service_Parameters'!K59*2)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161))))","v":0},null,{"$f":"IF(ISERROR(-(O156/('3. Cost_of_Service_Parameters'!M59*2)+MIN((O155/'3. Cost_of_Service_Parameters'!M59),(O155+O161)))), 0, -(O156/('3. Cost_of_Service_Parameters'!M59*2)+MIN((O155/'3. Cost_of_Service_Parameters'!M59),(O155+O161))))","v":0},null,{"$f":"IF(ISERROR(-(Q156/('3. Cost_of_Service_Parameters'!O59*2)+MIN((Q155/'3. Cost_of_Service_Parameters'!O59),(Q155+Q161)))), 0, -(Q156/('3. Cost_of_Service_Parameters'!O59*2)+MIN((Q155/'3. Cost_of_Service_Parameters'!O59),(Q155+Q161))))","v":0},null,{"$f":"IF(ISERROR(-(S156/('3. Cost_of_Service_Parameters'!Q59*2)+MIN((S155/'3. Cost_of_Service_Parameters'!Q59),(S155+S161)))), 0, -(S156/('3. Cost_of_Service_Parameters'!Q59*2)+MIN((S155/'3. Cost_of_Service_Parameters'!Q59),(S155+S161))))","v":0},null,{"$f":"IF(ISERROR(-(U156/('3. Cost_of_Service_Parameters'!S59*2)+MIN((U155/'3. Cost_of_Service_Parameters'!S59),(U155+U161)))), 0, -(U156/('3. Cost_of_Service_Parameters'!S59*2)+MIN((U155/'3. Cost_of_Service_Parameters'!S59),(U155+U161))))","v":0},null,{"$f":"IF(ISERROR(-(W156/('3. Cost_of_Service_Parameters'!U59*2)+MIN((W155/'3. Cost_of_Service_Parameters'!U59),(W155+W161)))), 0, -(W156/('3. Cost_of_Service_Parameters'!U59*2)+MIN((W155/'3. Cost_of_Service_Parameters'!U59),(W155+W161))))","v":0},null,{"$f":"IF(ISERROR(-(Y156/('3. Cost_of_Service_Parameters'!W59*2)+MIN((Y155/'3. Cost_of_Service_Parameters'!W59),(Y155+Y161)))), 0, -(Y156/('3. Cost_of_Service_Parameters'!W59*2)+MIN((Y155/'3. Cost_of_Service_Parameters'!W59),(Y155+Y161))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I161+I162-I163","v":0},null,{"$f":"K161+K162-K163","v":0},null,{"$f":"M161+M162-M163","v":0},null,{"$f":"O161+O162-O163","v":0},null,{"$f":"Q161+Q162-Q163","v":0},null,{"$f":"S161+S162-S163","v":0},null,{"$f":"U161+U162-U163","v":0},null,{"$f":"W161+W162-W163","v":0},null,{"$f":"Y161+Y162-Y163","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I155+I161","v":0},null,{"$f":"I168","v":0},null,{"$f":"K168","v":0},null,{"$f":"M168","v":0},null,{"$f":"O168","v":0},null,{"$f":"Q168","v":0},null,{"$f":"S168","v":0},null,{"$f":"U168","v":0},null,{"$f":"W168","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I158+I164","v":0},null,{"$f":"K158+K164","v":0},null,{"$f":"M158+M164","v":0},null,{"$f":"O158+O164","v":0},null,{"$f":"Q158+Q164","v":0},null,{"$f":"S158+S164","v":0},null,{"$f":"U158+U164","v":0},null,{"$f":"W158+W164","v":0},null,{"$f":"Y158+Y164","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I168","v":0},null,{"$f":"AVERAGE(K167:K168)","v":0},null,{"$f":"AVERAGE(M167:M168)","v":0},null,{"$f":"AVERAGE(O167:O168)","v":0},null,{"$f":"AVERAGE(Q167:Q168)","v":0},null,{"$f":"AVERAGE(S167:S168)","v":0},null,{"$f":"AVERAGE(U167:U168)","v":0},null,{"$f":"AVERAGE(W167:W168)","v":0},null,{"$f":"AVERAGE(Y167:Y168)","v":0}]
[]
[null,"Net Fixed Assets - RTUs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I177","v":0},null,{"$f":"K177","v":0},null,{"$f":"M177","v":0},null,{"$f":"O177","v":0},null,{"$f":"Q177","v":0},null,{"$f":"S177","v":0},null,{"$f":"U177","v":0},null,{"$f":"W177","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":0},null,{"$f":"'2. ICM_Costs'!I198","v":0},null,{"$f":"'2. ICM_Costs'!K198","v":0},null,{"$f":"'2. ICM_Costs'!M198","v":0},null,{"$f":"'2. ICM_Costs'!O198","v":0},null,{"$f":"'2. ICM_Costs'!Q198","v":0},null,{"$f":"'2. ICM_Costs'!S198","v":0},null,{"$f":"'2. ICM_Costs'!U198","v":0},null,{"$f":"'2. ICM_Costs'!W198","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I174+I175-I176","v":0},null,{"$f":"K174+K175-K176","v":0},null,{"$f":"M174+M175-M176","v":0},null,{"$f":"O174+O175-O176","v":0},null,{"$f":"Q174+Q175-Q176","v":0},null,{"$f":"S174+S175-S176","v":0},null,{"$f":"U174+U175-U176","v":0},null,{"$f":"W174+W175-W176","v":0},null,{"$f":"Y174+Y175-Y176","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I183","v":0},null,{"$f":"K183","v":0},null,{"$f":"M183","v":0},null,{"$f":"O183","v":0},null,{"$f":"Q183","v":0},null,{"$f":"S183","v":0},null,{"$f":"U183","v":0},null,{"$f":"W183","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M175/('3. Cost_of_Service_Parameters'!K61*2)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180)))), 0, -(M175/('3. Cost_of_Service_Parameters'!K61*2)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180))))","v":0},null,{"$f":"IF(ISERROR(-(O175/('3. Cost_of_Service_Parameters'!M61*2)+MIN((O174/'3. Cost_of_Service_Parameters'!M61),(O174+O180)))), 0, -(O175/('3. Cost_of_Service_Parameters'!M61*2)+MIN((O174/'3. Cost_of_Service_Parameters'!M61),(O174+O180))))","v":0},null,{"$f":"IF(ISERROR(-(Q175/('3. Cost_of_Service_Parameters'!O61*2)+MIN((Q174/'3. Cost_of_Service_Parameters'!O61),(Q174+Q180)))), 0, -(Q175/('3. Cost_of_Service_Parameters'!O61*2)+MIN((Q174/'3. Cost_of_Service_Parameters'!O61),(Q174+Q180))))","v":0},null,{"$f":"IF(ISERROR(-(S175/('3. Cost_of_Service_Parameters'!Q61*2)+MIN((S174/'3. Cost_of_Service_Parameters'!Q61),(S174+S180)))), 0, -(S175/('3. Cost_of_Service_Parameters'!Q61*2)+MIN((S174/'3. Cost_of_Service_Parameters'!Q61),(S174+S180))))","v":0},null,{"$f":"IF(ISERROR(-(U175/('3. Cost_of_Service_Parameters'!S61*2)+MIN((U174/'3. Cost_of_Service_Parameters'!S61),(U174+U180)))), 0, -(U175/('3. Cost_of_Service_Parameters'!S61*2)+MIN((U174/'3. Cost_of_Service_Parameters'!S61),(U174+U180))))","v":0},null,{"$f":"IF(ISERROR(-(W175/('3. Cost_of_Service_Parameters'!U61*2)+MIN((W174/'3. Cost_of_Service_Parameters'!U61),(W174+W180)))), 0, -(W175/('3. Cost_of_Service_Parameters'!U61*2)+MIN((W174/'3. Cost_of_Service_Parameters'!U61),(W174+W180))))","v":0},null,{"$f":"IF(ISERROR(-(Y175/('3. Cost_of_Service_Parameters'!W61*2)+MIN((Y174/'3. Cost_of_Service_Parameters'!W61),(Y174+Y180)))), 0, -(Y175/('3. Cost_of_Service_Parameters'!W61*2)+MIN((Y174/'3. Cost_of_Service_Parameters'!W61),(Y174+Y180))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I180+I181-I182","v":0},null,{"$f":"K180+K181-K182","v":0},null,{"$f":"M180+M181-M182","v":0},null,{"$f":"O180+O181-O182","v":0},null,{"$f":"Q180+Q181-Q182","v":0},null,{"$f":"S180+S181-S182","v":0},null,{"$f":"U180+U181-U182","v":0},null,{"$f":"W180+W181-W182","v":0},null,{"$f":"Y180+Y181-Y182","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,{"$f":"I187","v":0},null,{"$f":"K187","v":0},null,{"$f":"M187","v":0},null,{"$f":"O187","v":0},null,{"$f":"Q187","v":0},null,{"$f":"S187","v":0},null,{"$f":"U187","v":0},null,{"$f":"W187","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I177+I183","v":0},null,{"$f":"K177+K183","v":0},null,{"$f":"M177+M183","v":0},null,{"$f":"O177+O183","v":0},null,{"$f":"Q177+Q183","v":0},null,{"$f":"S177+S183","v":0},null,{"$f":"U177+U183","v":0},null,{"$f":"W177+W183","v":0},null,{"$f":"Y177+Y183","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I187","v":0},null,{"$f":"AVERAGE(K186:K187)","v":0},null,{"$f":"AVERAGE(M186:M187)","v":0},null,{"$f":"AVERAGE(O186:O187)","v":0},null,{"$f":"AVERAGE(Q186:Q187)","v":0},null,{"$f":"AVERAGE(S186:S187)","v":0},null,{"$f":"AVERAGE(U186:U187)","v":0},null,{"$f":"AVERAGE(W186:W187)","v":0},null,{"$f":"AVERAGE(Y186:Y187)","v":0}]
[]
[]
[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":0},null,{"$f":"K197","v":0},null,{"$f":"M197","v":0},null,{"$f":"O197","v":0},null,{"$f":"Q197","v":0},null,{"$f":"S197","v":0},null,{"$f":"U197","v":0},null,{"$f":"W197","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":0},null,{"$f":"'2. ICM_Costs'!I218","v":0},null,{"$f":"'2. ICM_Costs'!K218","v":0},null,{"$f":"'2. ICM_Costs'!M218","v":0},null,{"$f":"'2. ICM_Costs'!O218","v":0},null,{"$f":"'2. ICM_Costs'!Q218","v":0},null,{"$f":"'2. ICM_Costs'!S218","v":0},null,{"$f":"'2. ICM_Costs'!U218","v":0},null,{"$f":"'2. ICM_Costs'!W218","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I194+I195-I196","v":0},null,{"$f":"K194+K195-K196","v":0},null,{"$f":"M194+M195-M196","v":0},null,{"$f":"O194+O195-O196","v":0},null,{"$f":"Q194+Q195-Q196","v":0},null,{"$f":"S194+S195-S196","v":0},null,{"$f":"U194+U195-U196","v":0},null,{"$f":"W194+W195-W196","v":0},null,{"$f":"Y194+Y195-Y196","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I203","v":0},null,{"$f":"K203","v":0},null,{"$f":"M203","v":0},null,{"$f":"O203","v":0},null,{"$f":"Q203","v":0},null,{"$f":"S203","v":0},null,{"$f":"U203","v":0},null,{"$f":"W203","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M195/('3. Cost_of_Service_Parameters'!K63*2)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200)))), 0, -(M195/('3. Cost_of_Service_Parameters'!K63*2)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200))))","v":0},null,{"$f":"IF(ISERROR(-(O195/('3. Cost_of_Service_Parameters'!M63*2)+MIN((O194/'3. Cost_of_Service_Parameters'!M63),(O194+O200)))), 0, -(O195/('3. Cost_of_Service_Parameters'!M63*2)+MIN((O194/'3. Cost_of_Service_Parameters'!M63),(O194+O200))))","v":0},null,{"$f":"IF(ISERROR(-(Q195/('3. Cost_of_Service_Parameters'!O63*2)+MIN((Q194/'3. Cost_of_Service_Parameters'!O63),(Q194+Q200)))), 0, -(Q195/('3. Cost_of_Service_Parameters'!O63*2)+MIN((Q194/'3. Cost_of_Service_Parameters'!O63),(Q194+Q200))))","v":0},null,{"$f":"IF(ISERROR(-(S195/('3. Cost_of_Service_Parameters'!Q63*2)+MIN((S194/'3. Cost_of_Service_Parameters'!Q63),(S194+S200)))), 0, -(S195/('3. Cost_of_Service_Parameters'!Q63*2)+MIN((S194/'3. Cost_of_Service_Parameters'!Q63),(S194+S200))))","v":0},null,{"$f":"IF(ISERROR(-(U195/('3. Cost_of_Service_Parameters'!S63*2)+MIN((U194/'3. Cost_of_Service_Parameters'!S63),(U194+U200)))), 0, -(U195/('3. Cost_of_Service_Parameters'!S63*2)+MIN((U194/'3. Cost_of_Service_Parameters'!S63),(U194+U200))))","v":0},null,{"$f":"IF(ISERROR(-(W195/('3. Cost_of_Service_Parameters'!U63*2)+MIN((W194/'3. Cost_of_Service_Parameters'!U63),(W194+W200)))), 0, -(W195/('3. Cost_of_Service_Parameters'!U63*2)+MIN((W194/'3. Cost_of_Service_Parameters'!U63),(W194+W200))))","v":0},null,{"$f":"IF(ISERROR(-(Y195/('3. Cost_of_Service_Parameters'!W63*2)+MIN((Y194/'3. Cost_of_Service_Parameters'!W63),(Y194+Y200)))), 0, -(Y195/('3. Cost_of_Service_Parameters'!W63*2)+MIN((Y194/'3. Cost_of_Service_Parameters'!W63),(Y194+Y200))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I200+I201-I202","v":0},null,{"$f":"K200+K201-K202","v":0},null,{"$f":"M200+M201-M202","v":0},null,{"$f":"O200+O201-O202","v":0},null,{"$f":"Q200+Q201-Q202","v":0},null,{"$f":"S200+S201-S202","v":0},null,{"$f":"U200+U201-U202","v":0},null,{"$f":"W200+W201-W202","v":0},null,{"$f":"Y200+Y201-Y202","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,{"$f":"I207","v":0},null,{"$f":"K207","v":0},null,{"$f":"M207","v":0},null,{"$f":"O207","v":0},null,{"$f":"Q207","v":0},null,{"$f":"S207","v":0},null,{"$f":"U207","v":0},null,{"$f":"W207","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I197+I203","v":0},null,{"$f":"K197+K203","v":0},null,{"$f":"M197+M203","v":0},null,{"$f":"O197+O203","v":0},null,{"$f":"Q197+Q203","v":0},null,{"$f":"S197+S203","v":0},null,{"$f":"U197+U203","v":0},null,{"$f":"W197+W203","v":0},null,{"$f":"Y197+Y203","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I207","v":0},null,{"$f":"AVERAGE(K206:K207)","v":0},null,{"$f":"AVERAGE(M206:M207)","v":0},null,{"$f":"AVERAGE(O206:O207)","v":0},null,{"$f":"AVERAGE(Q206:Q207)","v":0},null,{"$f":"AVERAGE(S206:S207)","v":0},null,{"$f":"AVERAGE(U206:U207)","v":0},null,{"$f":"AVERAGE(W206:W207)","v":0},null,{"$f":"AVERAGE(Y206:Y207)","v":0}]
[]
[]
[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":0},null,{"$f":"K217","v":0},null,{"$f":"M217","v":0},null,{"$f":"O217","v":0},null,{"$f":"Q217","v":0},null,{"$f":"S217","v":0},null,{"$f":"U217","v":0},null,{"$f":"W217","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":0},null,{"$f":"'2. ICM_Costs'!I238","v":0},null,{"$f":"'2. ICM_Costs'!K238","v":0},null,{"$f":"'2. ICM_Costs'!M238","v":0},null,{"$f":"'2. ICM_Costs'!O238","v":0},null,{"$f":"'2. ICM_Costs'!Q238","v":0},null,{"$f":"'2. ICM_Costs'!S238","v":0},null,{"$f":"'2. ICM_Costs'!U238","v":0},null,{"$f":"'2. ICM_Costs'!W238","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I214+I215-I216","v":0},null,{"$f":"K214+K215-K216","v":0},null,{"$f":"M214+M215-M216","v":0},null,{"$f":"O214+O215-O216","v":0},null,{"$f":"Q214+Q215-Q216","v":0},null,{"$f":"S214+S215-S216","v":0},null,{"$f":"U214+U215-U216","v":0},null,{"$f":"W214+W215-W216","v":0},null,{"$f":"Y214+Y215-Y216","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I223","v":0},null,{"$f":"K223","v":0},null,{"$f":"M223","v":0},null,{"$f":"O223","v":0},null,{"$f":"Q223","v":0},null,{"$f":"S223","v":0},null,{"$f":"U223","v":0},null,{"$f":"W223","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M215/('3. Cost_of_Service_Parameters'!K65*2)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220)))), 0, -(M215/('3. Cost_of_Service_Parameters'!K65*2)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220))))","v":0},null,{"$f":"IF(ISERROR(-(O215/('3. Cost_of_Service_Parameters'!M65*2)+MIN((O214/'3. Cost_of_Service_Parameters'!M65),(O214+O220)))), 0, -(O215/('3. Cost_of_Service_Parameters'!M65*2)+MIN((O214/'3. Cost_of_Service_Parameters'!M65),(O214+O220))))","v":0},null,{"$f":"IF(ISERROR(-(Q215/('3. Cost_of_Service_Parameters'!O65*2)+MIN((Q214/'3. Cost_of_Service_Parameters'!O65),(Q214+Q220)))), 0, -(Q215/('3. Cost_of_Service_Parameters'!O65*2)+MIN((Q214/'3. Cost_of_Service_Parameters'!O65),(Q214+Q220))))","v":0},null,{"$f":"IF(ISERROR(-(S215/('3. Cost_of_Service_Parameters'!Q65*2)+MIN((S214/'3. Cost_of_Service_Parameters'!Q65),(S214+S220)))), 0, -(S215/('3. Cost_of_Service_Parameters'!Q65*2)+MIN((S214/'3. Cost_of_Service_Parameters'!Q65),(S214+S220))))","v":0},null,{"$f":"IF(ISERROR(-(U215/('3. Cost_of_Service_Parameters'!S65*2)+MIN((U214/'3. Cost_of_Service_Parameters'!S65),(U214+U220)))), 0, -(U215/('3. Cost_of_Service_Parameters'!S65*2)+MIN((U214/'3. Cost_of_Service_Parameters'!S65),(U214+U220))))","v":0},null,{"$f":"IF(ISERROR(-(W215/('3. Cost_of_Service_Parameters'!U65*2)+MIN((W214/'3. Cost_of_Service_Parameters'!U65),(W214+W220)))), 0, -(W215/('3. Cost_of_Service_Parameters'!U65*2)+MIN((W214/'3. Cost_of_Service_Parameters'!U65),(W214+W220))))","v":0},null,{"$f":"IF(ISERROR(-(Y215/('3. Cost_of_Service_Parameters'!W65*2)+MIN((Y214/'3. Cost_of_Service_Parameters'!W65),(Y214+Y220)))), 0, -(Y215/('3. Cost_of_Service_Parameters'!W65*2)+MIN((Y214/'3. Cost_of_Service_Parameters'!W65),(Y214+Y220))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I220+I221-I222","v":0},null,{"$f":"K220+K221-K222","v":0},null,{"$f":"M220+M221-M222","v":0},null,{"$f":"O220+O221-O222","v":0},null,{"$f":"Q220+Q221-Q222","v":0},null,{"$f":"S220+S221-S222","v":0},null,{"$f":"U220+U221-U222","v":0},null,{"$f":"W220+W221-W222","v":0},null,{"$f":"Y220+Y221-Y222","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,{"$f":"I227","v":0},null,{"$f":"K227","v":0},null,{"$f":"M227","v":0},null,{"$f":"O227","v":0},null,{"$f":"Q227","v":0},null,{"$f":"S227","v":0},null,{"$f":"U227","v":0},null,{"$f":"W227","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I217+I223","v":0},null,{"$f":"K217+K223","v":0},null,{"$f":"M217+M223","v":0},null,{"$f":"O217+O223","v":0},null,{"$f":"Q217+Q223","v":0},null,{"$f":"S217+S223","v":0},null,{"$f":"U217+U223","v":0},null,{"$f":"W217+W223","v":0},null,{"$f":"Y217+Y223","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I227","v":0},null,{"$f":"AVERAGE(K226:K227)","v":0},null,{"$f":"AVERAGE(M226:M227)","v":0},null,{"$f":"AVERAGE(O226:O227)","v":0},null,{"$f":"AVERAGE(Q226:Q227)","v":0},null,{"$f":"AVERAGE(S226:S227)","v":0},null,{"$f":"AVERAGE(U226:U227)","v":0},null,{"$f":"AVERAGE(W226:W227)","v":0},null,{"$f":"AVERAGE(Y226:Y227)","v":0}]
[]
[]
[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":0},null,{"$f":"K237","v":0},null,{"$f":"M237","v":0},null,{"$f":"O237","v":0},null,{"$f":"Q237","v":0},null,{"$f":"S237","v":0},null,{"$f":"U237","v":0},null,{"$f":"W237","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":0},null,{"$f":"'2. ICM_Costs'!I258","v":0},null,{"$f":"'2. ICM_Costs'!K258","v":0},null,{"$f":"'2. ICM_Costs'!M258","v":0},null,{"$f":"'2. ICM_Costs'!O258","v":0},null,{"$f":"'2. ICM_Costs'!Q258","v":0},null,{"$f":"'2. ICM_Costs'!S258","v":0},null,{"$f":"'2. ICM_Costs'!U258","v":0},null,{"$f":"'2. ICM_Costs'!W258","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I234+I235-I236","v":0},null,{"$f":"K234+K235-K236","v":0},null,{"$f":"M234+M235-M236","v":0},null,{"$f":"O234+O235-O236","v":0},null,{"$f":"Q234+Q235-Q236","v":0},null,{"$f":"S234+S235-S236","v":0},null,{"$f":"U234+U235-U236","v":0},null,{"$f":"W234+W235-W236","v":0},null,{"$f":"Y234+Y235-Y236","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I243","v":0},null,{"$f":"K243","v":0},null,{"$f":"M243","v":0},null,{"$f":"O243","v":0},null,{"$f":"Q243","v":0},null,{"$f":"S243","v":0},null,{"$f":"U243","v":0},null,{"$f":"W243","v":0}]
[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":0},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":0},null,{"$f":"IF(ISERROR(-(M235/('3. Cost_of_Service_Parameters'!K67*2)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240)))), 0, -(M235/('3. Cost_of_Service_Parameters'!K67*2)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240))))","v":0},null,{"$f":"IF(ISERROR(-(O235/('3. Cost_of_Service_Parameters'!M67*2)+MIN((O234/'3. Cost_of_Service_Parameters'!M67),(O234+O240)))), 0, -(O235/('3. Cost_of_Service_Parameters'!M67*2)+MIN((O234/'3. Cost_of_Service_Parameters'!M67),(O234+O240))))","v":0},null,{"$f":"IF(ISERROR(-(Q235/('3. Cost_of_Service_Parameters'!O67*2)+MIN((Q234/'3. Cost_of_Service_Parameters'!O67),(Q234+Q240)))), 0, -(Q235/('3. Cost_of_Service_Parameters'!O67*2)+MIN((Q234/'3. Cost_of_Service_Parameters'!O67),(Q234+Q240))))","v":0},null,{"$f":"IF(ISERROR(-(S235/('3. Cost_of_Service_Parameters'!Q67*2)+MIN((S234/'3. Cost_of_Service_Parameters'!Q67),(S234+S240)))), 0, -(S235/('3. Cost_of_Service_Parameters'!Q67*2)+MIN((S234/'3. Cost_of_Service_Parameters'!Q67),(S234+S240))))","v":0},null,{"$f":"IF(ISERROR(-(U235/('3. Cost_of_Service_Parameters'!S67*2)+MIN((U234/'3. Cost_of_Service_Parameters'!S67),(U234+U240)))), 0, -(U235/('3. Cost_of_Service_Parameters'!S67*2)+MIN((U234/'3. Cost_of_Service_Parameters'!S67),(U234+U240))))","v":0},null,{"$f":"IF(ISERROR(-(W235/('3. Cost_of_Service_Parameters'!U67*2)+MIN((W234/'3. Cost_of_Service_Parameters'!U67),(W234+W240)))), 0, -(W235/('3. Cost_of_Service_Parameters'!U67*2)+MIN((W234/'3. Cost_of_Service_Parameters'!U67),(W234+W240))))","v":0},null,{"$f":"IF(ISERROR(-(Y235/('3. Cost_of_Service_Parameters'!W67*2)+MIN((Y234/'3. Cost_of_Service_Parameters'!W67),(Y234+Y240)))), 0, -(Y235/('3. Cost_of_Service_Parameters'!W67*2)+MIN((Y234/'3. Cost_of_Service_Parameters'!W67),(Y234+Y240))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I240+I241-I242","v":0},null,{"$f":"K240+K241-K242","v":0},null,{"$f":"M240+M241-M242","v":0},null,{"$f":"O240+O241-O242","v":0},null,{"$f":"Q240+Q241-Q242","v":0},null,{"$f":"S240+S241-S242","v":0},null,{"$f":"U240+U241-U242","v":0},null,{"$f":"W240+W241-W242","v":0},null,{"$f":"Y240+Y241-Y242","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I234+I240","v":0},null,{"$f":"I247","v":0},null,{"$f":"K247","v":0},null,{"$f":"M247","v":0},null,{"$f":"O247","v":0},null,{"$f":"Q247","v":0},null,{"$f":"S247","v":0},null,{"$f":"U247","v":0},null,{"$f":"W247","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I237+I243","v":0},null,{"$f":"K237+K243","v":0},null,{"$f":"M237+M243","v":0},null,{"$f":"O237+O243","v":0},null,{"$f":"Q237+Q243","v":0},null,{"$f":"S237+S243","v":0},null,{"$f":"U237+U243","v":0},null,{"$f":"W237+W243","v":0},null,{"$f":"Y237+Y243","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I247","v":0},null,{"$f":"AVERAGE(K246:K247)","v":0},null,{"$f":"AVERAGE(M246:M247)","v":0},null,{"$f":"AVERAGE(O246:O247)","v":0},null,{"$f":"AVERAGE(Q246:Q247)","v":0},null,{"$f":"AVERAGE(S246:S247)","v":0},null,{"$f":"AVERAGE(U246:U247)","v":0},null,{"$f":"AVERAGE(W246:W247)","v":0},null,{"$f":"AVERAGE(Y246:Y247)","v":0}]
[]
[]
[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":0},null,{"$f":"K257","v":0},null,{"$f":"M257","v":0},null,{"$f":"O257","v":0},null,{"$f":"Q257","v":0},null,{"$f":"S257","v":0},null,{"$f":"U257","v":0},null,{"$f":"W257","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":0},null,{"$f":"'2. ICM_Costs'!I278","v":0},null,{"$f":"'2. ICM_Costs'!K278","v":0},null,{"$f":"'2. ICM_Costs'!M278","v":0},null,{"$f":"'2. ICM_Costs'!O278","v":0},null,{"$f":"'2. ICM_Costs'!Q278","v":0},null,{"$f":"'2. ICM_Costs'!S278","v":0},null,{"$f":"'2. ICM_Costs'!U278","v":0},null,{"$f":"'2. ICM_Costs'!W278","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I254+I255-I256","v":0},null,{"$f":"K254+K255-K256","v":0},null,{"$f":"M254+M255-M256","v":0},null,{"$f":"O254+O255-O256","v":0},null,{"$f":"Q254+Q255-Q256","v":0},null,{"$f":"S254+S255-S256","v":0},null,{"$f":"U254+U255-U256","v":0},null,{"$f":"W254+W255-W256","v":0},null,{"$f":"Y254+Y255-Y256","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I263","v":0},null,{"$f":"K263","v":0},null,{"$f":"M263","v":0},null,{"$f":"O263","v":0},null,{"$f":"Q263","v":0},null,{"$f":"S263","v":0},null,{"$f":"U263","v":0},null,{"$f":"W263","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,{"$f":"IF(ISERROR(-(M255/('3. Cost_of_Service_Parameters'!K69*2)+MIN((M254/'3. Cost_of_Service_Parameters'!K69),(M254+M260)))), 0, -(M255/('3. Cost_of_Service_Parameters'!K69*2)+MIN((M254/'3. Cost_of_Service_Parameters'!K69),(M254+M260))))","v":0},null,{"$f":"IF(ISERROR(-(O255/('3. Cost_of_Service_Parameters'!M69*2)+MIN((O254/'3. Cost_of_Service_Parameters'!M69),(O254+O260)))), 0, -(O255/('3. Cost_of_Service_Parameters'!M69*2)+MIN((O254/'3. Cost_of_Service_Parameters'!M69),(O254+O260))))","v":0},null,{"$f":"IF(ISERROR(-(Q255/('3. Cost_of_Service_Parameters'!O69*2)+MIN((Q254/'3. Cost_of_Service_Parameters'!O69),(Q254+Q260)))), 0, -(Q255/('3. Cost_of_Service_Parameters'!O69*2)+MIN((Q254/'3. Cost_of_Service_Parameters'!O69),(Q254+Q260))))","v":0},null,{"$f":"IF(ISERROR(-(S255/('3. Cost_of_Service_Parameters'!Q69*2)+MIN((S254/'3. Cost_of_Service_Parameters'!Q69),(S254+S260)))), 0, -(S255/('3. Cost_of_Service_Parameters'!Q69*2)+MIN((S254/'3. Cost_of_Service_Parameters'!Q69),(S254+S260))))","v":0},null,{"$f":"IF(ISERROR(-(U255/('3. Cost_of_Service_Parameters'!S69*2)+MIN((U254/'3. Cost_of_Service_Parameters'!S69),(U254+U260)))), 0, -(U255/('3. Cost_of_Service_Parameters'!S69*2)+MIN((U254/'3. Cost_of_Service_Parameters'!S69),(U254+U260))))","v":0},null,{"$f":"IF(ISERROR(-(W255/('3. Cost_of_Service_Parameters'!U69*2)+MIN((W254/'3. Cost_of_Service_Parameters'!U69),(W254+W260)))), 0, -(W255/('3. Cost_of_Service_Parameters'!U69*2)+MIN((W254/'3. Cost_of_Service_Parameters'!U69),(W254+W260))))","v":0},null,{"$f":"IF(ISERROR(-(Y255/('3. Cost_of_Service_Parameters'!W69*2)+MIN((Y254/'3. Cost_of_Service_Parameters'!W69),(Y254+Y260)))), 0, -(Y255/('3. Cost_of_Service_Parameters'!W69*2)+MIN((Y254/'3. Cost_of_Service_Parameters'!W69),(Y254+Y260))))","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,{"$f":"M260+M261-M262","v":0},null,{"$f":"O260+O261-O262","v":0},null,{"$f":"Q260+Q261-Q262","v":0},null,{"$f":"S260+S261-S262","v":0},null,{"$f":"U260+U261-U262","v":0},null,{"$f":"W260+W261-W262","v":0},null,{"$f":"Y260+Y261-Y262","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":0},null,{"$f":"K267","v":0},null,{"$f":"M267","v":0},null,{"$f":"O267","v":0},null,{"$f":"Q267","v":0},null,{"$f":"S267","v":0},null,{"$f":"U267","v":0},null,{"$f":"W267","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I257+I263","v":0},null,{"$f":"K257+K263","v":0},null,{"$f":"M257+M263","v":0},null,{"$f":"O257+O263","v":0},null,{"$f":"Q257+Q263","v":0},null,{"$f":"S257+S263","v":0},null,{"$f":"U257+U263","v":0},null,{"$f":"W257+W263","v":0},null,{"$f":"Y257+Y263","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I267","v":0},null,{"$f":"AVERAGE(K266:K267)","v":0},null,{"$f":"AVERAGE(M266:M267)","v":0},null,{"$f":"AVERAGE(O266:O267)","v":0},null,{"$f":"AVERAGE(Q266:Q267)","v":0},null,{"$f":"AVERAGE(S266:S267)","v":0},null,{"$f":"AVERAGE(U266:U267)","v":0},null,{"$f":"AVERAGE(W266:W267)","v":0},null,{"$f":"AVERAGE(Y266:Y267)","v":0}]
[]
[]
[null,"Net Fixed Assets -CCR&A contributions"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I277","v":0},null,{"$f":"K277","v":0},null,{"$f":"M277","v":0},null,{"$f":"O277","v":0},null,{"$f":"Q277","v":0},null,{"$f":"S277","v":0},null,{"$f":"U277","v":0},null,{"$f":"W277","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G226","v":0},null,{"$f":"'2. ICM_Costs'!I298","v":0},null,{"$f":"'2. ICM_Costs'!K298","v":0},null,{"$f":"'2. ICM_Costs'!M298","v":0},null,{"$f":"'2. ICM_Costs'!O298","v":0},null,{"$f":"'2. ICM_Costs'!Q298","v":0},null,{"$f":"'2. ICM_Costs'!S298","v":0},null,{"$f":"'2. ICM_Costs'!U298","v":0},null,{"$f":"'2. ICM_Costs'!W298","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I274+I275-I276","v":0},null,{"$f":"K274+K275-K276","v":0},null,{"$f":"M274+M275-M276","v":0},null,{"$f":"O274+O275-O276","v":0},null,{"$f":"Q274+Q275-Q276","v":0},null,{"$f":"S274+S275-S276","v":0},null,{"$f":"U274+U275-U276","v":0},null,{"$f":"W274+W275-W276","v":0},null,{"$f":"Y274+Y275-Y276","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I283","v":0},null,{"$f":"K283","v":0},null,{"$f":"M283","v":0},null,{"$f":"O283","v":0},null,{"$f":"Q283","v":0},null,{"$f":"S283","v":0},null,{"$f":"U283","v":0},null,{"$f":"W283","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I275/('3. Cost_of_Service_Parameters'!G96*2)+MIN((I274/'3. Cost_of_Service_Parameters'!G96),(I274+I280)))), 0, -(I275/('3. Cost_of_Service_Parameters'!G96*2)+MIN((I274/'3. Cost_of_Service_Parameters'!G96),(I274+I280))))","v":0},null,{"$f":"IF(ISERROR(-(K275/('3. Cost_of_Service_Parameters'!I96*2)+MIN((K274/'3. Cost_of_Service_Parameters'!I96),(K274+K280)))), 0, -(K275/('3. Cost_of_Service_Parameters'!I96*2)+MIN((K274/'3. Cost_of_Service_Parameters'!I96),(K274+K280))))","v":0},null,{"$f":"IF(ISERROR(-(M275/('3. Cost_of_Service_Parameters'!K96*2)+MIN((M274/'3. Cost_of_Service_Parameters'!K96),(M274+M280)))), 0, -(M275/('3. Cost_of_Service_Parameters'!K96*2)+MIN((M274/'3. Cost_of_Service_Parameters'!K96),(M274+M280))))","v":0},null,{"$f":"IF(ISERROR(-(O275/('3. Cost_of_Service_Parameters'!M96*2)+MIN((O274/'3. Cost_of_Service_Parameters'!M96),(O274+O280)))), 0, -(O275/('3. Cost_of_Service_Parameters'!M96*2)+MIN((O274/'3. Cost_of_Service_Parameters'!M96),(O274+O280))))","v":0},null,{"$f":"IF(ISERROR(-(Q275/('3. Cost_of_Service_Parameters'!O96*2)+MIN((Q274/'3. Cost_of_Service_Parameters'!O96),(Q274+Q280)))), 0, -(Q275/('3. Cost_of_Service_Parameters'!O96*2)+MIN((Q274/'3. Cost_of_Service_Parameters'!O96),(Q274+Q280))))","v":0},null,{"$f":"IF(ISERROR(-(S275/('3. Cost_of_Service_Parameters'!Q96*2)+MIN((S274/'3. Cost_of_Service_Parameters'!Q96),(S274+S280)))), 0, -(S275/('3. Cost_of_Service_Parameters'!Q96*2)+MIN((S274/'3. Cost_of_Service_Parameters'!Q96),(S274+S280))))","v":0},null,{"$f":"IF(ISERROR(-(U275/('3. Cost_of_Service_Parameters'!S96*2)+MIN((U274/'3. Cost_of_Service_Parameters'!S96),(U274+U280)))), 0, -(U275/('3. Cost_of_Service_Parameters'!S96*2)+MIN((U274/'3. Cost_of_Service_Parameters'!S96),(U274+U280))))","v":0},null,{"$f":"IF(ISERROR(-(W275/('3. Cost_of_Service_Parameters'!U96*2)+MIN((W274/'3. Cost_of_Service_Parameters'!U96),(W274+W280)))), 0, -(W275/('3. Cost_of_Service_Parameters'!U96*2)+MIN((W274/'3. Cost_of_Service_Parameters'!U96),(W274+W280))))","v":0},null,{"$f":"IF(ISERROR(-(Y275/('3. Cost_of_Service_Parameters'!W96*2)+MIN((Y274/'3. Cost_of_Service_Parameters'!W96),(Y274+Y280)))), 0, -(Y275/('3. Cost_of_Service_Parameters'!W96*2)+MIN((Y274/'3. Cost_of_Service_Parameters'!W96),(Y274+Y280))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I280+I281-I282","v":0},null,{"$f":"K280+K281-K282","v":0},null,{"$f":"M280+M281-M282","v":0},null,{"$f":"O280+O281-O282","v":0},null,{"$f":"Q280+Q281-Q282","v":0},null,{"$f":"S280+S281-S282","v":0},null,{"$f":"U280+U281-U282","v":0},null,{"$f":"W280+W281-W282","v":0},null,{"$f":"Y280+Y281-Y282","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I274+I280","v":0},null,{"$f":"I287","v":0},null,{"$f":"K287","v":0},null,{"$f":"M287","v":0},null,{"$f":"O287","v":0},null,{"$f":"Q287","v":0},null,{"$f":"S287","v":0},null,{"$f":"U287","v":0},null,{"$f":"W287","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I277+I283","v":0},null,{"$f":"K277+K283","v":0},null,{"$f":"M277+M283","v":0},null,{"$f":"O277+O283","v":0},null,{"$f":"Q277+Q283","v":0},null,{"$f":"S277+S283","v":0},null,{"$f":"U277+U283","v":0},null,{"$f":"W277+W283","v":0},null,{"$f":"Y277+Y283","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I287","v":0},null,{"$f":"AVERAGE(K286:K287)","v":0},null,{"$f":"AVERAGE(M286:M287)","v":0},null,{"$f":"AVERAGE(O286:O287)","v":0},null,{"$f":"AVERAGE(Q286:Q287)","v":0},null,{"$f":"AVERAGE(S286:S287)","v":0},null,{"$f":"AVERAGE(U286:U287)","v":0},null,{"$f":"AVERAGE(W286:W287)","v":0},null,{"$f":"AVERAGE(Y286:Y287)","v":0}]
[]
[]
[]
[]
[null,null,null,"Additions",null,null,null,null,{"$f":"I23+I42+I61+I80+I99+I118+I137+I156+I175+I195+I215+I235+I255","v":6804600},null,{"$f":"K23+K42+K61+K80+K99+K118+K137+K156+K175+K195+K215+K235+K255","v":0},null,{"$f":"M23+M42+M61+M80+M99+M118+M137+M156+M175+M195+M215+M235+M255","v":0},null,{"$f":"O23+O42+O61+O80+O99+O118+O137+O156+O175+O195+O215+O235+O255","v":0},null,{"$f":"Q23+Q42+Q61+Q80+Q99+Q118+Q137+Q156+Q175+Q195+Q215+Q235+Q255","v":0},null,{"$f":"S23+S42+S61+S80+S99+S118+S137+S156+S175+S195+S215+S235+S255","v":0},null,{"$f":"U23+U42+U61+U80+U99+U118+U137+U156+U175+U195+U215+U235+U255","v":0},null,{"$f":"W23+W42+W61+W80+W99+W118+W137+W156+W175+W195+W215+W235+W255","v":0},null,{"$f":"Y23+Y42+Y61+Y80+Y99+Y118+Y137+Y156+Y175+Y195+Y215+Y235+Y255","v":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":6634485},null,{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268","v":6549427.5},null,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268","v":6379312.5},null,{"$f":"O36+O55+O74+O93+O112+O131+O150+O169+O188+O208+O228+O248+O268","v":6209197.5},null,{"$f":"Q36+Q55+Q74+Q93+Q112+Q131+Q150+Q169+Q188+Q208+Q228+Q248+Q268","v":6039082.5},null,{"$f":"S36+S55+S74+S93+S112+S131+S150+S169+S188+S208+S228+S248+S268","v":5868967.5},null,{"$f":"U36+U55+U74+U93+U112+U131+U150+U169+U188+U208+U228+U248+U268","v":5698852.5},null,{"$f":"W36+W55+W74+W93+W112+W131+W150+W169+W188+W208+W228+W248+W268","v":5528737.5},null,{"$f":"Y36+Y55+Y74+Y93+Y112+Y131+Y150+Y169+Y188+Y208+Y228+Y248+Y268","v":5358622.5}]
[null,null,null,"Total Amortization",null,null,null,null,{"$f":"I29+I48+I67+I86+I105+I124+I143+I162+I181+I201+I221+I241+I261","v":-170115},null,{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261","v":-170115},null,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261","v":-170115},null,{"$f":"O29+O48+O67+O86+O105+O124+O143+O162+O181+O201+O221+O241+O261","v":-170115},null,{"$f":"Q29+Q48+Q67+Q86+Q105+Q124+Q143+Q162+Q181+Q201+Q221+Q241+Q261","v":-170115},null,{"$f":"S29+S48+S67+S86+S105+S124+S143+S162+S181+S201+S221+S241+S261","v":-170115},null,{"$f":"U29+U48+U67+U86+U105+U124+U143+U162+U181+U201+U221+U241+U261","v":-170115},null,{"$f":"W29+W48+W67+W86+W105+W124+W143+W162+W181+W201+W221+W241+W261","v":-170115},null,{"$f":"Y29+Y48+Y67+Y86+Y105+Y124+Y143+Y162+Y181+Y201+Y221+Y241+Y261","v":-170115}]

{"sheet":"5. UCC_Calculation","index":4,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6: CCA For PILs Calculation"]
[]
["UCC/Class 47",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G19","v":2018}]
[null,null,null,{"$f":"'2. ICM_Costs'!G19","v":"Audited Actual"}]
[]
["Opening UCC",null,null,0]
["Capital Additions",null,null,{"$f":"'2. ICM_Costs'!K211","v":6804600}]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D23:D24)-D25","v":6804600}]
[]
[]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G134","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G135","v":0.08}]
["CCA",null,null,{"$f":"D26*D30","v":544368}]
["Closing UCC",null,null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":6260232}]
[]
["UCC/Class 8",null,null,{"$f":"D20","v":2018}]
[null,null,null,"Audited Actual"]
[]
["Opening UCC",null,null,0]
["Capital Additions RTU's",null,null,0]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D37:D38)-D39","v":0}]
[]
[]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G107","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G108","v":0.08}]
["CCA",null,null,{"$f":"D40*D44","v":0}]
["Closing UCC",null,null,{"$f":"IF((D40-D45)<0, 0, D40-D45)","v":0}]

{"sheet":"7. Rate Rider Revs","index":5,"n_rows":131,"n_cols":17,"rows_kept":131,"cut":false,"hidden":false,"merged":[[12,1,12,13],[18,5,18,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the rate riders revenues.\n"]
[]
[]
[]
[null,"Sheet 7: ICM Rate Rider Revenues"]
[]
[]
[]
[]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Rate Rider Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)",null,"Board Approved ICM Rate Rider","Board Approved ICM  Rate Rider\n(Cumm.)"]
[]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2018-01-01",{"$f":"YEAR(F24)","v":2018},{"$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":"2018 Q1"},0,null,1.4999999999999999E-2,{"$f":"ROUND(J24*L24/12,2)","v":0},{"$f":"K24+M24","v":0},null,null,{"$f":"P24","v":0}]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2018-02-01",{"$f":"YEAR(F25)","v":2018},{"$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":"2018 Q1"},{"$f":"J24+K24","v":0},null,1.4999999999999999E-2,{"$f":"ROUND(J25*L25/12,2)","v":0},{"$f":"N24+K25+M25","v":0},null,null,{"$f":"Q24+P25","v":0}]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2018-03-01",2018,"Q1","2018 Q1",{"$f":"J25+K25","v":0},null,1.4999999999999999E-2,0,{"$f":"N25+K26+M26","v":0},null,null,{"$f":"Q25+P26","v":0}]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,64808.479999999989,1.89E-2,0,64808.479999999989,null,58899.468985677988,{"$f":"Q27+P28","v":58899.468985677988}]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2018-06-01",2018,"Q2","2018 Q2",64808.479999999989,57571.520000000011,1.89E-2,{"$f":"ROUND(J29*L29/12,2)","v":102.07},122482.07,null,58899.468985677988,117798.93797135598]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",122380,62441.650000000052,1.89E-2,192.75,185116.47000000006,null,58899.468985677988,176698.40695703396]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2018-08-01",2018,"Q3","2018 Q3",184821.65000000005,64110.919999999925,1.89E-2,291.08999999999997,249518.47999999998,null,58899.468985677988,235597.87594271195]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2018-09-01",2018,"Q3","2018 Q3",248932.56999999998,59870.180000000022,1.89E-2,392.07,309780.73000000004,null,58899.468985677988,294497.34492838994]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",308802.75,63550.900000000081,2.1700000000000001E-2,558.41999999999996,373890.0500000001,null,58899.468985677988,353396.81391406793]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",372353.65000000008,59797.79999999993,2.1700000000000001E-2,673.34,434361.19000000006,null,58899.468985677988,412296.28289974591]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",432151.45,61863.249999999942,2.1700000000000001E-2,781.47,497005.91,null,58899.468985677988,471195.7518854239]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2019-01-01",2019,"Q1","2019 Q1",494014.69999999995,64423.100000000006,2.4500000000000001E-2,{"$f":"ROUND(J36*L36/12,2)","v":1008.61},562437.62,null,58899.468985677988,530095.22087110183]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2019-02-01",2019,"Q1","2019 Q1",558437.79999999993,55891.299999999988,2.4500000000000001E-2,1140.1400000000001,619469.05999999994,null,58899.468985677988,588994.68985677976]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2019-03-01",2019,"Q1","2019 Q1",614329.09999999986,64213.560000000027,2.4500000000000001E-2,1254.26,684936.88,null,58899.468985677988,647894.15884245769]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2019-04-01",2019,"Q2","2019 Q2",678542.65999999992,60829.389999999956,2.18E-2,1232.69,746998.96,null,58899.468985677988,706793.62782813562]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2019-05-01",2019,"Q2","2019 Q2",739372.04999999981,61141.290000000037,2.18E-2,1343.19,809483.44,null,58899.468985677988,765693.09681381355]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",800513.33999999985,59032.699999999953,2.18E-2,1454.27,869970.40999999992,null,58899.468985677988,824592.56579949148]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2019-07-01",2019,"Q3","2019 Q3",859546.0399999998,66688.38,2.18E-2,1561.51,938220.29999999993,null,58899.468985677988,883492.03478516941]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2019-08-01",2019,"Q3","2019 Q3",926234.41999999981,61437.36,2.18E-2,1682.66,1001340.32,null,58899.468985677988,942391.50377084734]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2019-09-01",2019,"Q3","2019 Q3",987671.7799999998,59205.700000000004,2.18E-2,1794.27,1062340.29,null,58899.468985677988,1001290.9727565253]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-10-01",2019,"Q4","2019 Q4",1046877.4799999997,64597.60000000002,2.18E-2,1901.83,1128839.7200000002,null,58899.468985677988,1060190.4417422032]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-11-01",2019,"Q4","2019 Q4",1111475.0799999998,59038.209999999992,2.18E-2,2019.18,1189897.1100000001,null,58899.468985677988,1119089.9107278811]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2019-12-01",2019,"Q4","2019 Q4",1170513.2899999998,63618.849999999991,2.18E-2,2126.4299999999998,1255642.3900000001,null,58899.468985677988,1177989.3797135591]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2020-01-01",2020,"Q1","2020 Q1",1234132.1399999999,60129.67,2.18E-2,{"$f":"ROUND(J48*L48/12,2)","v":2242.0100000000002},{"$f":"N47+K48+M48","v":1318014.07},null,58899.468985677988,{"$f":"Q47+P48","v":1236888.848699237}]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2020-02-01",2020,"Q1","2020 Q1",1294261.8099999998,58023.16,2.18E-2,2351.2399999999998,1378388.47,null,58899.468985677988,1295788.3176849149]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2020-03-01",2020,"Q1","2020 Q1",1352284.9699999997,66683,2.18E-2,2456.65,1447528.1199999999,null,58899.468985677988,1354687.7866705928]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2020-04-01",2020,"Q2","2020 Q2",1418967.9699999997,55189.109999999993,2.18E-2,2577.79,1505295.02,null,58899.468985677988,1413587.2556562708]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2020-05-01",2020,"Q2","2020 Q2",1474157.0799999998,59696.849999999991,2.18E-2,2678.05,1567669.9200000002,null,58899.468985677988,1472486.7246419487]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-06-01",2020,"Q2","2020 Q2",1533853.93,63134.080000000002,2.18E-2,2786.5,1633590.5000000002,null,58899.468985677988,1531386.1936276266]
[null,"2025 Q3",2.9100000000000001E-2,4.2299999999999997E-2,null,"2020-07-01",2020,"Q3","2020 Q3",1596988.01,62980.84,5.7000000000000002E-3,758.57,1697329.9100000004,null,58899.468985677988,1590285.6626133046]
[null,"2025 Q4",2.9100000000000001E-2,4.2299999999999997E-2,null,"2020-08-01",2020,"Q3","2020 Q3",1659968.85,61270.659999999996,5.7000000000000002E-3,788.49,1759389.0600000003,null,58899.468985677988,1649185.1315989825]
[null,"2026 Q1",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",1721239.51,59297.599999999999,5.7000000000000002E-3,817.59,1819504.2500000005,null,58899.468985677988,1708084.6005846604]
[null,"2026 Q2",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",1780537.11,61987.05,5.7000000000000002E-3,845.76,1882337.0600000005,null,58899.468985677988,1766984.0695703384]
[null,"2026 Q3",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",1842524.1600000001,59969.24000000002,5.7000000000000002E-3,875.2,1943181.5000000005,null,58899.468985677988,1825883.5385560163]
[null,"2026 Q4",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-12-01",2020,{"$f":"IF(MONTH(F59)=0,\"\",IF(MONTH(F59)<4,\"Q1\",IF(MONTH(F59)<7,\"Q2\",IF(MONTH(F59)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2020 Q4",1902493.4000000001,62959.37,5.7000000000000002E-3,903.68,2007044.5500000005,null,58899.468985677988,1884783.0075416942]
[null,null,null,null,null,"2021-01-01",2021,"Q1","2021 Q1",{"$f":"J59+K59","v":1965452.7700000003},59266.199999999975,5.7000000000000002E-3,933.59,2067244.3400000005,null,58899.468985677988,1943682.4765273721]
[null,"Note: 2026 Interest rates are forecasted. ",null,null,null,"2021-02-01",2021,"Q1","2021 Q1",2024718.9700000002,57985.83,5.7000000000000002E-3,961.74,2126191.9100000006,null,58899.468985677988,2002581.9455130501]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",2082704.8000000003,67867.200000000012,5.7000000000000002E-3,989.28,2195048.3900000006,null,58899.468985677988,2061481.414498728]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",2150572.0000000005,52751.280000000006,5.7000000000000002E-3,1021.52,2248821.1900000004,null,58899.468985677988,2120380.8834844059]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",2203323.2800000003,63316.090000000004,5.7000000000000002E-3,1046.58,2313183.8600000003,null,58899.468985677988,2179280.3524700841]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",2266639.37,62164.06,5.7000000000000002E-3,1076.6500000000001,2376424.5700000003,null,58899.468985677988,2238179.8214557623]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",2328803.4300000002,60828.900000000009,5.7000000000000002E-3,1106.18,2438359.6500000004,null,58899.468985677988,2297079.2904414404]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",2389632.33,67303.28,5.7000000000000002E-3,1135.08,2506798.0100000002,null,58899.468985677988,2355978.7594271186]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",2456935.61,61184.100000000006,5.7000000000000002E-3,1167.04,2569149.1500000004,null,58899.468985677988,2414878.2284127967]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",2518119.71,61790.659999999989,5.7000000000000002E-3,1196.1099999999999,2632135.9200000004,null,58899.468985677988,2473777.6973984749]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",2579910.37,63643.770000000004,5.7000000000000002E-3,1225.46,2697005.1500000004,null,58899.468985677988,2532677.1663841531]
[null,null,null,null,null,"2021-12-01",2021,{"$f":"IF(MONTH(F71)=0,\"\",IF(MONTH(F71)<4,\"Q1\",IF(MONTH(F71)<7,\"Q2\",IF(MONTH(F71)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2021 Q4",2643554.14,62462.97,5.7000000000000002E-3,1255.69,2760723.8100000005,null,58899.468985677988,2591576.6353698312]
[null,null,null,null,null,"2022-01-01",{"$f":"YEAR(F72)","v":2022},{"$f":"IF(MONTH(F72)=0,\"\",IF(MONTH(F72)<4,\"Q1\",IF(MONTH(F72)<7,\"Q2\",IF(MONTH(F72)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2022 Q1",{"$f":"J71+K71","v":2706017.1100000003},59216.24,5.7000000000000002E-3,{"$f":"ROUND(J72*L72/12,2)","v":1285.3599999999999},{"$f":"N71+K72+M72","v":2821225.4100000006},null,58899.468985677988,{"$f":"Q71+P72","v":2650476.1043555094}]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",2765233.3500000006,59701.73,5.7000000000000002E-3,1313.49,2882240.6300000008,null,58899.468985677988,2709375.5733411876]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",2824935.0800000005,66606.360000000015,5.7000000000000002E-3,1341.84,2950188.8300000005,null,58899.468985677988,2768275.0423268657]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",2891541.4400000004,57505.029999999992,1.0200000000000001E-2,2457.81,3010151.6700000004,null,58899.468985677988,2827174.5113125439]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",2949046.47,64671.509999999987,1.0200000000000001E-2,2506.69,3077329.87,null,58899.468985677988,2886073.980298222]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",3013717.98,63087.850000000006,1.0200000000000001E-2,2561.66,3142979.3800000004,null,58899.468985677988,2944973.4492839002]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",3076805.83,63517.859999999993,2.1999999999999999E-2,5640.81,3212138.0500000003,null,58899.468985677988,3003872.9182695784]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",3140323.69,67186.540000000008,2.1999999999999999E-2,5757.26,3285081.85,null,58899.468985677988,3062772.3872552565]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",3207510.23,59030.18,2.1999999999999999E-2,5880.44,3349992.47,null,58899.468985677988,3121671.8562409347]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",3266540.41,62121.069999999992,3.8699999999999998E-2,10534.59,3422648.13,null,58899.468985677988,3180571.3252266129]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",3328661.48,59784.569999999992,3.8699999999999998E-2,10734.93,3493167.63,null,58899.468985677988,3239470.794212291]
[null,null,null,null,null,"2022-12-01",2022,{"$f":"IF(MONTH(F83)=0,\"\",IF(MONTH(F83)<4,\"Q1\",IF(MONTH(F83)<7,\"Q2\",IF(MONTH(F83)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2022 Q4",3388446.05,65938.040000000008,3.8699999999999998E-2,10927.74,3570033.41,null,58899.468985677988,3298370.2631979692]
[null,null,null,null,null,"2023-01-01",{"$f":"YEAR(F84)","v":2023},{"$f":"IF(MONTH(F84)=0,\"\",IF(MONTH(F84)<4,\"Q1\",IF(MONTH(F84)<7,\"Q2\",IF(MONTH(F84)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2023 Q1",{"$f":"J83+K83","v":3454384.09},63141.690000000017,4.7300000000000002E-2,{"$f":"ROUND(J84*L84/12,2)","v":13616.03},{"$f":"N83+K84+M84","v":3646791.13},null,58899.468985677988,{"$f":"Q83+P84","v":3357269.7321836473}]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",{"$f":"J84+K84","v":3517525.78},58133.19999999999,4.7300000000000002E-2,{"$f":"ROUND(J85*L85/12,2)","v":13864.91},3718789.24,null,58899.468985677988,3416169.2011693255]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",3575658.98,62564.689999999988,4.7300000000000002E-2,14094.06,3795447.99,null,58899.468985677988,3475068.6701550037]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",3638223.67,61094.950000000012,4.9799999999999997E-2,15098.63,3871641.5700000003,null,58899.468985677988,3533968.1391406818]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",3699318.62,63433.48,4.9799999999999997E-2,15352.17,3950427.22,null,58899.468985677988,3592867.60812636]
[null,null,null,null,null,"2023-06-01",2023,"Q2",{"$f":"CONCATENATE(G89,\" \",H89)","v":"2023 Q2"},3762752.1,63480.87000000001,4.9799999999999997E-2,15615.42,4029523.5100000002,null,58899.468985677988,3651767.0771120382]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",3826232.97,65522.87,4.9799999999999997E-2,15878.87,4110925.2500000005,null,58899.468985677988,3710666.5460977163]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",3891755.8400000003,63127.94999999999,4.9799999999999997E-2,16150.79,4190203.9900000007,null,58899.468985677988,3769566.0150833945]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",3954883.7900000005,61816.340000000004,4.9799999999999997E-2,16412.77,4268433.1000000006,null,58899.468985677988,3828465.4840690726]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",4016700.1300000004,63240.539999999994,5.4899999999999997E-2,18376.400000000001,4350050.040000001,null,58899.468985677988,3887364.9530547508]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",4079940.6700000004,62091.55999999999,5.4899999999999997E-2,18665.73,4430807.330000001,null,58899.468985677988,3946264.422040429]
[null,null,null,null,null,"2023-12-01",2023,{"$f":"IF(MONTH(F95)=0,\"\",IF(MONTH(F95)<4,\"Q1\",IF(MONTH(F95)<7,\"Q2\",IF(MONTH(F95)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2023 Q4",4142032.2300000004,67099.94,5.4899999999999997E-2,18949.8,4516857.0700000012,null,58899.468985677988,4005163.8910261071]
[null,null,null,null,null,"2024-01-01",{"$f":"YEAR(F96)","v":2024},{"$f":"IF(MONTH(F96)=0,\"\",IF(MONTH(F96)<4,\"Q1\",IF(MONTH(F96)<7,\"Q2\",IF(MONTH(F96)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2024 Q1",{"$f":"J95+K95","v":4209132.1700000009},63646.610000000008,5.4899999999999997E-2,{"$f":"ROUND(J96*L96/12,2)","v":19256.78},{"$f":"N95+K96+M96","v":4599760.4600000018},null,58899.468985677988,{"$f":"Q95+P96","v":4064063.3600117853}]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",4272778.7800000012,59586.92,5.4899999999999997E-2,{"$f":"ROUND(J97*L97/12,2)","v":19547.96},4678895.3400000017,null,58899.468985677988,4122962.8289974635]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",4332365.7000000011,62571.040000000008,5.4899999999999997E-2,19820.57,4761286.950000002,null,58899.468985677988,4181862.2979831416]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",4394936.7400000012,61083.259999999995,5.4899999999999997E-2,20106.84,4842477.0500000017,null,58899.468985677988,4240761.7669688193]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",4456020.0000000009,63944.28,5.4899999999999997E-2,{"$f":"ROUND(J100*L100/12,2)","v":20386.29},4926807.620000002,null,58899.468985677988,4299661.235954497]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",4519964.2800000012,63582.59,5.4899999999999997E-2,20678.84,5011069.0500000017,null,58899.468985677988,4358560.7049401747]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",4583546.870000001,65319.450000000004,5.1999999999999998E-2,19862.04,5096250.5400000019,null,58899.468985677988,4417460.1739258524]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",4648866.3200000012,65172.2,5.1999999999999998E-2,20145.09,5181567.8300000019,null,58899.468985677988,4476359.6429115301]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",4714038.5200000014,62887.350000000006,5.1999999999999998E-2,20427.5,5264882.6800000016,null,58899.468985677988,4535259.1118972078]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",4776925.870000001,62356.62000000001,4.3999999999999997E-2,17515.39,5344754.6900000013,null,58899.468985677988,4594158.5808828855]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",4839282.4900000012,60956.39,4.3999999999999997E-2,17744.04,5423455.120000001,null,58899.468985677988,4653058.0498685632]
[null,null,null,null,null,"2024-12-01",2024,{"$f":"IF(MONTH(F107)=0,\"\",IF(MONTH(F107)<4,\"Q1\",IF(MONTH(F107)<7,\"Q2\",IF(MONTH(F107)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2024 Q4",4900238.8800000008,63905.399999999994,4.3999999999999997E-2,17967.54,5505328.0600000015,null,58899.468985677988,4711957.5188542409]
[null,null,null,null,null,"2025-01-01",{"$f":"YEAR(F108)","v":2025},{"$f":"IF(MONTH(F108)=0,\"\",IF(MONTH(F108)<4,\"Q1\",IF(MONTH(F108)<7,\"Q2\",IF(MONTH(F108)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2025 Q1",{"$f":"J107+K107","v":4964144.2800000012},63586.479999999996,3.6400000000000002E-2,{"$f":"ROUND(J108*L108/12,2)","v":15057.9},{"$f":"N107+K108+M108","v":5583972.4400000023},null,58899.468985677988,{"$f":"Q107+P108","v":4770856.9878399186}]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",5027730.7600000016,58242.140000000007,3.6400000000000002E-2,15250.78,5657465.3600000022,null,58899.468985677988,4829756.4568255963]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",5085972.9000000013,62943.930000000008,3.6400000000000002E-2,15427.45,5735836.7400000021,null,58899.468985677988,4888655.925811274]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",5148916.830000001,62342.939999999995,3.1600000000000003E-2,13558.81,5811738.4900000021,null,58899.468985677988,4947555.3947969517]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",5211259.7700000014,64135.519999999997,3.1600000000000003E-2,13722.98,5889596.9900000021,null,58899.468985677988,5006454.8637826294]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",5275395.290000001,64631.13,3.1600000000000003E-2,13891.87,5968119.9900000021,null,58899.468985677988,5065354.3327683071]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",5340026.4200000009,67148.13,2.9100000000000001E-2,12949.56,6048217.6800000016,null,58899.468985677988,5124253.8017539848]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",5407174.5500000007,64830.15,2.9100000000000001E-2,13112.4,6126160.2300000023,null,58899.468985677988,5183153.2707396625]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",5472004.7000000011,62521.93,2.9100000000000001E-2,13269.61,6201951.7700000023,null,58899.468985677988,5242052.7397253402]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",5534526.6300000008,64160.87,2.9100000000000001E-2,13421.23,6279533.8700000029,null,58899.468985677988,5300952.2087110179]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",5598687.5000000009,62166.37,2.9100000000000001E-2,13576.82,6355277.0600000033,null,58899.468985677988,5359851.6776966956]
[null,null,null,null,null,"2025-12-01",2025,{"$f":"IF(MONTH(F119)=0,\"\",IF(MONTH(F119)<4,\"Q1\",IF(MONTH(F119)<7,\"Q2\",IF(MONTH(F119)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2025 Q4",5660853.870000001,65263.48,2.9100000000000001E-2,13727.57,6434268.1100000041,null,58899.468985677988,5418751.1466823732]
[null,null,null,null,null,"2026-01-01",{"$f":"YEAR(F120)","v":2026},{"$f":"IF(MONTH(F120)=0,\"\",IF(MONTH(F120)<4,\"Q1\",IF(MONTH(F120)<7,\"Q2\",IF(MONTH(F120)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2026 Q1",{"$f":"J119+K119","v":5726117.3500000015},64325.537210958901,2.5499999999999998E-2,{"$f":"ROUND(J120*L120/12,2)","v":12168},{"$f":"N119+K120+M120","v":6510761.6472109631},null,58899.468985677988,{"$f":"Q119+P120","v":5477650.6156680509}]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",5790442.8872109605,60165.136312328788,2.5499999999999998E-2,12304.69,6583231.4735232927,null,58899.468985677988,5536550.0846537286]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",5850608.0235232897,64120.397644931501,2.5499999999999998E-2,12432.54,6659784.4111682242,null,58899.468985677988,5595449.5536394063]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",5914728.4211682212,62620.782745205477,2.5499999999999998E-2,12568.8,6734973.9939134298,null,58899.468985677988,5654349.022625084]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",5977349.203913427,64890.96611945206,2.5499999999999998E-2,12701.87,6812566.8300328823,null,58899.468985677988,5713248.4916107617]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",6042240.1700328793,63921.41561643836,2.5499999999999998E-2,12839.76,6889328.0056493208,null,58899.468985677988,5772147.9605964394]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",6106161.5856493181,66633.336511780828,2.5499999999999998E-2,12975.59,6968936.9321611011,null,58899.468985677988,5831047.4295821171]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",6172794.9221610986,65968.449732602734,2.5499999999999998E-2,13117.19,7048022.5718937041,null,58899.468985677988,5889946.8985677948]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",6238763.3718937011,63450.538849315068,2.5499999999999998E-2,13257.37,7124730.4807430189,null,58899.468985677988,5948846.3675534725]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",6302213.9107430158,64340.974408219183,2.5499999999999998E-2,13392.2,7202463.6551512387,null,58899.468985677988,6007745.8365391502]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",6366554.8851512354,62613.708016438351,2.5499999999999998E-2,13528.93,7278606.2931676768,null,58899.468985677988,6066645.3055248279]
[null,null,null,null,null,"2026-12-01",2026,{"$f":"IF(MONTH(F131)=0,\"\",IF(MONTH(F131)<4,\"Q1\",IF(MONTH(F131)<7,\"Q2\",IF(MONTH(F131)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2026 Q4",6429168.5931676738,64545.144756164394,2.5499999999999998E-2,13661.98,7356813.4179238416,null,58899.468985677988,6125544.7745105056]

{"sheet":"6. ICMIRR_2018","index":6,"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,"Actual"]
[null,null,null,null,null,null,null,null,"2018 OEB Approved"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"'2. ICM_Costs'!G42","v":6804600},"B",null,null,null,6800377]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I29","v":170115},"C",null,null,null,226679]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"F27-F28","v":6634485},"D = B - C",null,null,null,{"$f":"K27-K28","v":6573698}]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},"E",{"$f":"F29*D31","v":265379.40000000002},"G = D * E",null,{"$f":"D31","v":0.04},null,{"$f":"K29*I31","v":262947.92}]
[null,null,"Deemed Long Term Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},"F",{"$f":"F29*D32","v":3715311.5999999996},"H = D * F",null,{"$f":"D32","v":0.55999999999999994},null,{"$f":"K29*I32","v":3681270.8799999994}]
[]
[null,null,"Short Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":2.1600000000000001E-2},"I",{"$f":"F31*D34","v":5732.1950400000005},"K = G * I",null,{"$f":"D34","v":2.1600000000000001E-2},null,{"$f":"K31*I34","v":5679.675072}]
[null,null,"Long Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":6.0699999999999997E-2},"J",{"$f":"F32*D35","v":225519.41411999997},"L = H * J",null,{"$f":"D35","v":6.0699999999999997E-2},null,{"$f":"K32*I35","v":223453.14241599996}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":231251.60915999996},"M = K + L",null,null,null,{"$f":"SUM(K34:K35)","v":229132.81748799997}]
[]
[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":2653794.0000000005},"P = D * N",null,0.39999999999999991,null,{"$f":"K29*I40","v":2629479.1999999993}]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":9.2999999999999999E-2},"O",{"$f":"F40*D42","v":246802.84200000003},"Q = P * O",null,{"$f":"D42","v":9.2999999999999999E-2},null,{"$f":"K40*I42","v":244541.56559999991}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":478054.45116},"R = M + Q",null,null,null,{"$f":"K37+K42","v":473674.38308799989}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":170115},"S",null,null,null,{"$f":"K28","v":226679}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":246802.84200000003},"T ",null,null,null,{"$f":"K42","v":244541.56559999991}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":170115},"U",null,null,null,{"$f":"K50","v":226679}]
[]
[null,null,"Deduct CCA",null,null,453639.53304353566,"V",null,null,null,453358]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-36721.691043535597},"W = T + U - V",null,null,null,{"$f":"K55+K57-K59","v":17862.565599999914}]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.26500000000000001},"X",null,null,null,{"$f":"D63","v":0.26500000000000001}]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-9731.2481265369333},"Y = W * X",null,null,null,{"$f":"K61*I63","v":4733.5798839999779}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-13239.793369438004},"Z = Y / ( 1 - X ) ",null,null,null,{"$f":"K65/(1-I63)","v":6440.2447401360241}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":6804600},"AA",null,null,null,{"$f":"K27","v":6800377}]
[]
[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":6804600},"AC = AA - AB",null,null,null,{"$f":"K71-K73","v":6800377}]
[]
[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":478054.45116},"AF",null,null,null,{"$f":"K44","v":473674.38308799989}]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":170115},"AG",null,null,null,{"$f":"K50","v":226679}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-13239.793369438004},"AH",null,null,null,{"$f":"K67","v":6440.2447401360241}]
[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":634929.65779056191},"AJ = AF + AG + AH + AI",null,null,null,{"$f":"SUM(K83:K86)","v":706793.62782813585}]

{"sheet":"8. Opex Interest Annual","index":7,"n_rows":42,"n_cols":14,"rows_kept":42,"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 4)"]
[null,2018,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I295","v":170115},null,{"$f":"D23+F23","v":170115},null,{"$f":"H23/2","v":85057.5},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C24:C27)","v":1.8624999999999999E-2},null,{"$f":"J23*L23","v":1584.1959374999999}]
[null,2019,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!K295","v":170115},null,{"$f":"H23+D24+F24","v":340230},null,{"$f":"(H24+H23)/2","v":255172.5},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C28:C31)","v":2.2474999999999998E-2},null,{"$f":"J24*L24","v":5735.0019374999993}]
[null,2020,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!M295","v":170115},null,{"$f":"H24+D25+F25","v":510345},null,{"$f":"(H25+H24)/2","v":425287.5},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C32:C35)","v":1.3749999999999998E-2},null,{"$f":"J25*L25","v":5847.7031249999991}]
[null,2021,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!O295","v":170115},null,680460,null,595402.5,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C36:C39)","v":5.7000000000000002E-3},null,{"$f":"J26*L26","v":3393.7942499999999}]
[null,2022,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!Q295","v":170115},null,{"$f":"H26+D27+F27","v":850575},null,765517.5,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C40:C43)","v":1.915E-2},null,{"$f":"J27*L27","v":14659.660125}]
[null,2023,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!S295","v":170115},null,1020690,null,935632.5,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C44:C47)","v":5.0449999999999995E-2},null,47202.659624999993]
[null,2024,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!U295","v":170115},null,1190805,null,1105747.5,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C48:C51)","v":5.1449999999999996E-2},null,56890.708874999997]
[null,2025,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!W295","v":170115},null,1360920,null,1275862.5,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C52:C55)","v":3.1550000000000002E-2},null,40253.461875000001]
[null,2026,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!Y295","v":170115},null,1531035,null,1445977.5,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C56:C59)","v":2.5499999999999998E-2},null,{"$f":"J31*L31","v":36872.426249999997}]
[]
[]
[null,"Cumulative Interest to 2018",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N23)","v":1584.1959374999999}]
[null,"Cumulative Interest to 2019",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N24)","v":7319.1978749999989}]
[null,"Cumulative Interest to 2020",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N25)","v":13166.900999999998}]
[null,"Cumulative Interest to 2021",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N26)","v":16560.695249999997}]
[null,"Cumulative Interest to 2022",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N27)","v":31220.355374999999}]
[null,"Cumulative Interest to 2023",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N28)","v":78423.014999999985}]
[null,"Cumulative Interest to 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N29)","v":135313.72387499997}]
[null,"Cumulative Interest to 2025",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N30)","v":175567.18574999998}]
[null,"Cumulative Interest to 2026",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N31)","v":212439.61199999996}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":37,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,26],[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,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total",null,null,null,2018,{"$f":"AC20+1","v":2019},{"$f":"AD20+1","v":2020},2021,2022,2023,2024,2025,2026]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,{"$f":"'6. ICMIRR_2018'!F88*8/12","v":423286.43852704129},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":634929.65779056191},null,{"$f":"SUM(G22:W22)","v":5502723.7008515373},null,null,"Revenue Requirement ",{"$f":"G22","v":423286.43852704129},{"$f":"I22","v":634929.65779056191},{"$f":"K22","v":634929.65779056191},{"$f":"M22","v":634929.65779056191},{"$f":"O22","v":634929.65779056191},{"$f":"Q22","v":634929.65779056191},{"$f":"S22","v":634929.65779056191},{"$f":"U22","v":634929.65779056191},{"$f":"W22","v":634929.65779056191}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest on Deferred  Amortization Expense ",{"$f":"G24","v":1584.1959374999999},{"$f":"I24","v":5735.0019374999993},{"$f":"K24","v":5847.7031249999991},{"$f":"M24","v":3393.7942499999999},{"$f":"O24","v":14659.660125},{"$f":"Q27","v":754748.08000000007},{"$f":"S27","v":755012.11},{"$f":"U24","v":40253.461875000001},{"$f":"W24","v":36872.426249999997}]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,{"$f":"'8. Opex Interest Annual'!$N$23","v":1584.1959374999999},null,{"$f":"'8. Opex Interest Annual'!$N$24","v":5735.0019374999993},null,{"$f":"'8. Opex Interest Annual'!$N$25","v":5847.7031249999991},null,{"$f":"'8. Opex Interest Annual'!$N$26","v":3393.7942499999999},null,{"$f":"'8. Opex Interest Annual'!$N$27","v":14659.660125},null,{"$f":"'8. Opex Interest Annual'!$N$28","v":47202.659624999993},null,{"$f":"'8. Opex Interest Annual'!$N$29","v":56890.708874999997},null,{"$f":"'8. Opex Interest Annual'!$N$30","v":40253.461875000001},null,{"$f":"'8. Opex Interest Annual'!$N$31","v":36872.426249999997},null,{"$f":"SUM(G24:W24)","v":212439.61199999996},null,null,"Subtotal A",{"$f":"AC22+AC23","v":424870.63446454128},{"$f":"AD22+AD23","v":640664.65972806187},640777.36091556191,638323.45204056194,649589.31791556196,1389677.737790562,1389941.767790562,675183.11966556194,671802.08404056192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ICM Funding adders",{"$f":"G27","v":494014.69999999995},{"$f":"I27","v":740117.43999999983}]
[null,null,"ICM Rate Rider Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Rider Revs'!K26:K35)","v":494014.69999999995},null,{"$f":"SUM('7. Rate Rider Revs'!K36:K47)","v":740117.43999999983},null,{"$f":"SUM('7. Rate Rider Revs'!K48:K59)","v":731320.63},null,{"$f":"SUM('7. Rate Rider Revs'!K60:K71)","v":740564.34},null,{"$f":"SUM('7. Rate Rider Revs'!K72:K83)","v":748366.98},null,{"$f":"SUM('7. Rate Rider Revs'!K84:K95)","v":754748.08000000007},null,{"$f":"SUM('7. Rate Rider Revs'!K96:K107)","v":755012.11},null,{"$f":"SUM('7. Rate Rider Revs'!K108:K119)","v":761973.07000000007},null,{"$f":"SUM('7. Rate Rider Revs'!K120:K131)","v":767596.38792383578},null,{"$f":"SUM(G27:W27)","v":6493713.7379238363},null,null,"ICM Funding Adder Interest",{"$f":"G29","v":2991.21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal B"]
[null,null,"ICM Rate Rider Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Rider Revs'!M27:M35)","v":2991.21},null,{"$f":"SUM('7. Rate Rider Revs'!M36:M47)","v":18519.04},null,{"$f":"SUM('7. Rate Rider Revs'!M48:M59)","v":20081.53},null,{"$f":"SUM('7. Rate Rider Revs'!M60:M71)","v":13114.92},null,{"$f":"SUM('7. Rate Rider Revs'!M72:M83)","v":60942.619999999995},null,{"$f":"SUM('7. Rate Rider Revs'!M84:M95)","v":192075.58},null,{"$f":"SUM('7. Rate Rider Revs'!M96:M107)","v":233458.88},null,{"$f":"SUM('7. Rate Rider Revs'!M108:M119)","v":166966.98000000001},null,{"$f":"SUM('7. Rate Rider Revs'!M120:M131)","v":154948.92000000001},null,{"$f":"SUM(G29:W29)","v":863099.68},null,null,"ICM True-up Amount (A-B)"]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":-72135.275535458699},null,{"$f":"(I22+I24)-(I27+I29)","v":-117971.82027193799},null,{"$f":"(K22+K24)-(K27+K29)","v":-110624.79908443813},null,{"$f":"(M22+M24)-(M27+M29)","v":-115355.80795943807},null,{"$f":"(O22+O24)-(O27+O29)","v":-159720.28208443802},null,{"$f":"(Q22+Q24)-(Q27+Q29)","v":-264691.34258443816},null,{"$f":"(S22+S24)-(S27+S29)","v":-296650.62333443807},null,{"$f":"(U22+U24)-(U27+U29)","v":-253756.9303344381},null,{"$f":"(W22+W24)-(W27+W29)","v":-250743.22388327389},null,{"$f":"(Y22+Y24)-(Y27+Y29)","v":-1641650.105072299}]