{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Utility_Info","2. ICM_Costs","3. Cost_of_Service_Parameters","4. ICM_Assets_and_Rate_Base","5. UCC_Calculation","6. ICMIRR_2021 actual","7. Rate Rider Revs","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]]}
[null,null,null,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","2021 - Goreway Road Widening",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":217,"n_cols":11,"rows_kept":217,"cut":false,"hidden":false,"merged":[[166,2,166,3],[168,2,168,3],[170,2,170,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2021,null,2015,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual",null,"Forecast"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"ICP 1  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,"OH Swtch & Cpctrs",null,214477.90560000003,null,null,null,{"$f":"SUM(G42,I42)","v":214477.90560000003}]
[]
[null,null,"ICP 1.2",null,"Concrete Poles",null,1310698.3120000004,null,null,null,{"$f":"SUM(G44,I44)","v":1310698.3120000004}]
[]
[null,null,"ICP 1.3",null,"OH Transformers",null,238308.78400000004,null,null,null,{"$f":"SUM(G46,I46)","v":238308.78400000004}]
[]
[null,null,"ICP 1.4",null,"OH Prim Cond & Dev",null,357463.17600000004,null,null,null,{"$f":"SUM(G48,I48)","v":357463.17600000004}]
[]
[null,null,"ICP 1.5",null,"OH Sec Cond & Dev",null,119154.39200000002,null,null,null,{"$f":"SUM(G50,I50)","v":119154.39200000002}]
[]
[null,null,"ICP 1.6",null,"UG Prim XLPE TR",null,71492.635200000004,null,null,null,71492.635200000004]
[]
[null,null,"ICP 1.7",null,"UG Sec - Dir Buried",null,71492.635200000004,null,null,null,71492.635200000004]
[]
[null,null,"ICP 1.8",null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.9",null,null,null,null,null,null,null,0]
[]
[null,null,"ICP 1.10",null,null,null,null,null,null,null,0]
[]
[null,null,"Total General Plant",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60)","v":2383087.8400000003},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":2383087.8400000003}]
[]
[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,null,null,null,null,null,null,{"$f":"SUM(G66,I66)","v":0}]
[]
[null,null,"ICP 2.2",null,null,null,null,null,null,null,{"$f":"SUM(G68,I68)","v":0}]
[]
[null,null,"ICP 2.3",null,null,null,null,null,null,null,{"$f":"SUM(G70,I70)","v":0}]
[]
[null,null,"ICP 2.4",null,null,null,null,null,null,null,{"$f":"SUM(G72,I72)","v":0}]
[]
[null,null,"ICP 2.5",null,null,null,null,null,null,null,{"$f":"SUM(G74,I74)","v":0}]
[]
[null,null,"ICP 2.6",null,null,null,null,null,null,null,{"$f":"SUM(G76,I76)","v":0}]
[]
[null,null,"ICP 2.7",null,null,null,null,null,null,null,{"$f":"SUM(G78,I78)","v":0}]
[]
[null,null,"ICP 2.8",null,null,null,null,null,null,null,{"$f":"SUM(G80,I80)","v":0}]
[]
[null,null,"ICP 2.9",null,null,null,null,null,null,null,{"$f":"SUM(G82,I82)","v":0}]
[]
[null,null,"ICP 2.10",null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"SUM(G90,I90)","v":0}]
[]
[null,null,"ICP 3.2",null,null,null,null,null,null,null,{"$f":"SUM(G92,I92)","v":0}]
[]
[null,null,"ICP 3.3",null,null,null,null,null,null,null,{"$f":"SUM(G94,I94)","v":0}]
[]
[null,null,"ICP 3.4",null,null,null,null,null,null,null,{"$f":"SUM(G96,I96)","v":0}]
[]
[null,null,"ICP 3.5",null,null,null,null,null,null,null,{"$f":"SUM(G98,I98)","v":0}]
[]
[null,null,"ICP 3.6",null,null,null,null,null,null,null,{"$f":"SUM(G100,I100)","v":0}]
[]
[null,null,"ICP 3.7",null,null,null,null,null,null,null,{"$f":"SUM(G102,I102)","v":0}]
[]
[null,null,"ICP 3.8",null,null,null,null,null,null,null,{"$f":"SUM(G104,I104)","v":0}]
[]
[null,null,"ICP 3.9",null,null,null,null,null,null,null,{"$f":"SUM(G106,I106)","v":0}]
[]
[null,null,"ICP 3.10",null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Renewal - Station Replacements",null,null,null,{"$f":"SUM(G90:G108)","v":0},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,0]
[]
[null,null,"Total System Renewal -  Switchgear & Transformer ReplacementS",null,null,null,{"$f":"SUM(G115:G133)","v":0},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,0]
[]
[null,null,"Total System Capacity Relief",null,null,null,{"$f":"SUM(G140:G158)","v":0},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,{"$f":"G62+G86+G110+G135+G160","v":2383087.8400000003},null,{"$f":"SUM(I62,I86,I110,I135,I160)","v":0},null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":2383087.8400000003}]
[]
[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 System Access",null,null,null,{"$f":"G162+G173","v":2383087.8400000003},null,{"$f":"I162+I173","v":0},null,{"$f":"K162+K173","v":2383087.8400000003}]
[]
[]
[null,2,"Aggregated ICM Costs by Category"]
[]
[null,null,"Asset Account","Capital","Account"]
[]
[null,null,120227,"OH Swtch & Cpctrs",1835,null,{"$f":"SUMIF($E$42:$E$171,$D182,G$42:G$171)","v":214477.90560000003},null,{"$f":"SUMIF($E$42:$E$171,$D182,I$42:I$171)","v":0},null,{"$f":"SUM(G182:J182)","v":214477.90560000003}]
[]
[null,null,120223,"Concrete Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":1310698.3120000004},null,{"$f":"SUMIF($E$42:$E$171,$D184,I$42:I$171)","v":0},null,{"$f":"SUM(G184:J184)","v":1310698.3120000004}]
[]
[null,null,120221,"Wood Poles",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,120225,"OH Transformers",1850,null,{"$f":"SUMIF($E$42:$E$171,$D188,G$42:G$171)","v":238308.78400000004},null,{"$f":"SUMIF($E$42:$E$171,$D188,I$42:I$171)","v":0},null,{"$f":"SUM(G188:J188)","v":238308.78400000004}]
[]
[null,null,120224,"OH Prim Cond & Dev",1835,null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":357463.17600000004},null,{"$f":"SUMIF($E$42:$E$171,$D190,I$42:I$171)","v":0},null,{"$f":"SUM(G190:J190)","v":357463.17600000004}]
[]
[null,null,120226,"OH Sec Cond & Dev",1855,null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":119154.39200000002},null,{"$f":"SUMIF($E$42:$E$171,$D192,I$42:I$171)","v":0},null,{"$f":"SUM(G192:J192)","v":119154.39200000002}]
[]
[null,null,120243,"UG Transformers",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,120245,"UG Conduit",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,"120241.XLPETR","UG Prim XLPE TR",1845,null,{"$f":"SUMIF($E$42:$E$171,$D198,G$42:G$171)","v":71492.635200000004},null,{"$f":"SUMIF($E$42:$E$171,$D198,I$42:I$171)","v":0},null,{"$f":"SUM(G198:J198)","v":71492.635200000004}]
[]
[null,null,"120242.DB","UG Sec - Dir Buried",1845,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":71492.635200000004},null,{"$f":"SUMIF($E$42:$E$171,$D200,I$42:I$171)","v":0},null,{"$f":"SUM(G200:J200)","v":71492.635200000004}]
[]
[null,null,"120242.IDSERV","UG Sec In Duct/Svs",1845,null,{"$f":"SUMIF($E$42:$E$171,$D202,G$42:G$171)","v":0},null,0,null,0]
[]
[null,null,120248,"Air Insulated Switchgear",1845,null,0,null,0,null,0]
[]
[null,null,120249,"Solid Dielectric Switchgear",1845,null,0,null,0,null,0]
[]
[null,null,120244,"UG Cable Injection",1845,null,0]
[]
[null,null,"120063.MS","MS Integrated P&C Systems ",1820,null,0]
[]
[null,null,"120021.MS","MS Building Improvements ",1820,null,0]
[]
[null,null,130104,"Capital Contributions Paid ",1609,null,0]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G215)","v":2383087.8400000003},null,{"$f":"SUM(I182:I209)","v":0},null,{"$f":"SUM(K182:K209)","v":2383087.8400000003}]
[null,null,null,null,null,null,{"$f":"IF(G216=G175,\" \",\"Error\")","v":" "},null,{"$f":"IF(I216=I175,\"\",\"Error\")","v":""},null,{"$f":"IF(K216=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,38,null,{"$f":"G45","v":38},null,{"$f":"I45","v":38},null,{"$f":"K45","v":38},null,{"$f":"M45","v":38},null,{"$f":"O45","v":38},null,{"$f":"Q45","v":38},null,35,null,{"$f":"U45","v":35}]
[null,null,"                              - rate (%)",null,null,null,{"$f":"IF(G45=0,0,1/G45)","v":2.6315789473684209E-2},null,{"$f":"IF(I45=0,0,1/I45)","v":2.6315789473684209E-2},null,{"$f":"IF(K45=0,0,1/K45)","v":2.6315789473684209E-2},null,{"$f":"IF(M45=0,0,1/M45)","v":2.6315789473684209E-2},null,{"$f":"IF(O45=0,0,1/O45)","v":2.6315789473684209E-2},null,{"$f":"IF(Q45=0,0,1/Q45)","v":2.6315789473684209E-2},null,{"$f":"IF(S45=0,0,1/S45)","v":2.6315789473684209E-2},null,{"$f":"IF(U45=0,0,1/U45)","v":2.8571428571428571E-2},null,{"$f":"IF(W45=0,0,1/W45)","v":2.8571428571428571E-2}]
[null,null,"Concrete Poles",null,1830,null,51,null,{"$f":"G47","v":51},null,{"$f":"I47","v":51},null,{"$f":"K47","v":51},null,{"$f":"M47","v":51},null,{"$f":"O47","v":51},null,{"$f":"Q47","v":51},null,60,null,{"$f":"U47","v":60}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G47=0,0,1/G47)","v":1.9607843137254902E-2},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,44,null,{"$f":"G49","v":44},null,{"$f":"I49","v":44},null,{"$f":"K49","v":44},null,{"$f":"M49","v":44},null,{"$f":"O49","v":44},null,{"$f":"Q49","v":44},null,45,null,{"$f":"U49","v":45}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G49=0,0,1/G49)","v":2.2727272727272728E-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,41,null,{"$f":"G51","v":41},null,{"$f":"I51","v":41},null,{"$f":"K51","v":41},null,{"$f":"M51","v":41},null,{"$f":"O51","v":41},null,{"$f":"Q51","v":41},null,45,null,{"$f":"U51","v":45}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G51=0,0,1/G51)","v":2.4390243902439025E-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,45,null,{"$f":"G53","v":45},null,{"$f":"I53","v":45},null,{"$f":"K53","v":45},null,{"$f":"M53","v":45},null,{"$f":"O53","v":45},null,{"$f":"Q53","v":45},null,50,null,{"$f":"U53","v":50}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G53=0,0,1/G53)","v":2.2222222222222223E-2},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,48,null,{"$f":"G55","v":48},null,{"$f":"I55","v":48},null,{"$f":"K55","v":48},null,{"$f":"M55","v":48},null,{"$f":"O55","v":48},null,{"$f":"Q55","v":48},null,50,null,{"$f":"U55","v":50}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G55=0,0,1/G55)","v":2.0833333333333332E-2},null,{"$f":"IF(I55=0,0,1/I55)","v":2.0833333333333332E-2},null,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,32,null,{"$f":"G57","v":32},null,{"$f":"I57","v":32},null,{"$f":"K57","v":32},null,{"$f":"M57","v":32},null,{"$f":"O57","v":32},null,{"$f":"Q57","v":32},null,30,null,{"$f":"U57","v":30}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G57=0,0,1/G57)","v":3.125E-2},null,{"$f":"IF(I57=0,0,1/I57)","v":3.125E-2},null,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,52,null,{"$f":"G59","v":52},null,{"$f":"I59","v":52},null,{"$f":"K59","v":52},null,{"$f":"M59","v":52},null,{"$f":"O59","v":52},null,{"$f":"Q59","v":52},null,60,null,{"$f":"U59","v":60}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G59=0,0,1/G59)","v":1.9230769230769232E-2},null,{"$f":"IF(I59=0,0,1/I59)","v":1.9230769230769232E-2},null,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,38,null,{"$f":"G61","v":38},null,{"$f":"I61","v":38},null,{"$f":"K61","v":38},null,{"$f":"M61","v":38},null,{"$f":"O61","v":38},null,{"$f":"Q61","v":38},null,45,null,{"$f":"U61","v":45}]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G61=0,0,1/G61)","v":2.6315789473684209E-2},null,{"$f":"IF(I61=0,0,1/I61)","v":2.6315789473684209E-2},null,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,31,null,{"$f":"G63","v":31},null,{"$f":"I63","v":31},null,{"$f":"K63","v":31},null,{"$f":"M63","v":31},null,{"$f":"O63","v":31},null,{"$f":"Q63","v":31},null,30,null,{"$f":"U63","v":30}]
[null,null,"                             - rate (%)",null,null,null,3.2258064516129031E-2,null,3.2258064516129031E-2,null,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,37,null,{"$f":"G65","v":37},null,{"$f":"I65","v":37},null,{"$f":"K65","v":37},null,{"$f":"M65","v":37},null,{"$f":"O65","v":37},null,{"$f":"Q65","v":37},null,40,null,{"$f":"U65","v":40}]
[null,null,"                             - rate (%)",null,null,null,2.7027027027027029E-2,null,2.7027027027027029E-2,null,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,39,null,{"$f":"G67","v":39},null,{"$f":"I67","v":39},null,{"$f":"K67","v":39},null,{"$f":"M67","v":39},null,{"$f":"O67","v":39},null,{"$f":"Q67","v":39},null,35,null,{"$f":"U67","v":35}]
[null,null,"                             - rate (%)",null,null,null,2.564102564102564E-2,null,2.564102564102564E-2,null,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,42,null,{"$f":"G69","v":42},null,{"$f":"I69","v":42},null,{"$f":"K69","v":42},null,{"$f":"M69","v":42},null,{"$f":"O69","v":42},null,{"$f":"Q69","v":42},null,45,null,{"$f":"U69","v":45}]
[null,null,"                             - rate (%)",null,null,null,2.3809523809523808E-2,null,2.3809523809523808E-2,null,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,24,null,{"$f":"G71","v":24},null,{"$f":"I71","v":24},null,{"$f":"K71","v":24},null,{"$f":"M71","v":24},null,{"$f":"O71","v":24},null,{"$f":"Q71","v":24},null,20,null,{"$f":"U71","v":20}]
[null,null,"                             - rate (%)",null,null,null,4.1666666666666664E-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,4.1666666666666664E-2,null,4.1666666666666664E-2,null,4.1666666666666664E-2,null,4.1666666666666664E-2,null,0.05,null,0.05]
[null,null,"MS Integrated P&C Systems ",null,1820,null,36,null,{"$f":"G73","v":36},null,{"$f":"I73","v":36},null,{"$f":"K73","v":36},null,{"$f":"M73","v":36},null,{"$f":"O73","v":36},null,{"$f":"Q73","v":36},null,15,null,{"$f":"U73","v":15}]
[null,null,"                             - rate (%)",null,null,null,2.7777777777777776E-2,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,2.7777777777777776E-2,null,2.7777777777777776E-2,null,2.7777777777777776E-2,null,2.7777777777777776E-2,null,6.6666666666666666E-2,null,6.6666666666666666E-2]
[null,null,"MS Building Improvements ",null,1820,null,21,null,{"$f":"G75","v":21},null,{"$f":"I75","v":21},null,{"$f":"K75","v":21},null,{"$f":"M75","v":21},null,{"$f":"O75","v":21},null,{"$f":"Q75","v":21},null,25,null,{"$f":"U75","v":25}]
[null,null,"                             - rate (%)",null,null,null,4.7619047619047616E-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,4.7619047619047616E-2,null,4.7619047619047616E-2,null,4.7619047619047616E-2,null,4.7619047619047616E-2,null,0.04,null,0.04]
[null,null,"Capital Contributions Paid ",null,1609,null,40,null,{"$f":"G77","v":40},null,{"$f":"I77","v":40},null,{"$f":"K77","v":40},null,{"$f":"M77","v":40},null,{"$f":"O77","v":40},null,{"$f":"Q77","v":40},null,40,null,{"$f":"U77","v":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,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,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":277,"n_cols":19,"rows_kept":277,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,null,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Net Fixed Assets - OH Swtch & Cpctrs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I23","v":214477.90560000003},null,{"$f":"K25","v":214477.90560000003},null,{"$f":"M25","v":214477.90560000003},null,{"$f":"O25","v":214477.90560000003},null,{"$f":"Q25","v":214477.90560000003}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G182","v":214477.90560000003},null,{"$f":"'2. ICM_Costs'!I208","v":0},null,{"$f":"'2. ICM_Costs'!K208","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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I22+I23-I24","v":214477.90560000003},null,{"$f":"K22+K23-K24","v":214477.90560000003},null,{"$f":"M22+M23-M24","v":214477.90560000003},null,{"$f":"O22+O23-O24","v":214477.90560000003},null,{"$f":"Q22+Q23-Q24","v":214477.90560000003},null,{"$f":"S22+S23-S24","v":214477.90560000003}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":-5644.1554105263167},null,{"$f":"K31","v":-11288.310821052633},null,{"$f":"M31","v":-16932.46623157895},null,{"$f":"O31","v":-22576.621642105267},null,{"$f":"Q31","v":-28704.561802105269}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I23/('3. Cost_of_Service_Parameters'!M45)+MIN((I22/'3. Cost_of_Service_Parameters'!M45),(I22+I28)))), 0, -(I23/('3. Cost_of_Service_Parameters'!M45)+MIN((I22/'3. Cost_of_Service_Parameters'!M45),(I22+I28))))","v":-5644.1554105263167},null,{"$f":"IF(ISERROR(-(K23/('3. Cost_of_Service_Parameters'!O45)+MIN((K22/'3. Cost_of_Service_Parameters'!O45),(K22+K28)))), 0, -(K23/('3. Cost_of_Service_Parameters'!O45)+MIN((K22/'3. Cost_of_Service_Parameters'!O45),(K22+K28))))","v":-5644.1554105263167},null,{"$f":"IF(ISERROR(-(M23/('3. Cost_of_Service_Parameters'!Q45)+MIN((M22/'3. Cost_of_Service_Parameters'!Q45),(M22+M28)))), 0, -(M23/('3. Cost_of_Service_Parameters'!Q45)+MIN((M22/'3. Cost_of_Service_Parameters'!Q45),(M22+M28))))","v":-5644.1554105263167},null,{"$f":"IF(ISERROR(-(O23/('3. Cost_of_Service_Parameters'!S45)+MIN((O22/'3. Cost_of_Service_Parameters'!S45),(O22+O28)))), 0, -(O23/('3. Cost_of_Service_Parameters'!S45)+MIN((O22/'3. Cost_of_Service_Parameters'!S45),(O22+O28))))","v":-5644.1554105263167},null,{"$f":"IF(ISERROR(-(Q23/('3. Cost_of_Service_Parameters'!U45)+MIN((Q22/'3. Cost_of_Service_Parameters'!U45),(Q22+Q28)))), 0, -(Q23/('3. Cost_of_Service_Parameters'!U45)+MIN((Q22/'3. Cost_of_Service_Parameters'!U45),(Q22+Q28))))","v":-6127.940160000001},null,{"$f":"IF(ISERROR(-(S23/('3. Cost_of_Service_Parameters'!W45)+MIN((S22/'3. Cost_of_Service_Parameters'!W45),(S22+S28)))), 0, -(S23/('3. Cost_of_Service_Parameters'!W45)+MIN((S22/'3. Cost_of_Service_Parameters'!W45),(S22+S28))))","v":-6127.940160000001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":-5644.1554105263167},null,{"$f":"K28+K29-K30","v":-11288.310821052633},null,{"$f":"M28+M29-M30","v":-16932.46623157895},null,{"$f":"O28+O29-O30","v":-22576.621642105267},null,{"$f":"Q28+Q29-Q30","v":-28704.561802105269},null,{"$f":"S28+S29-S30","v":-34832.501962105271}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,208833.75018947371,null,{"$f":"M22+M28","v":203189.59477894739},null,197545.43936842107,null,{"$f":"Q22+Q28","v":191901.28395789478},null,{"$f":"S22+S28","v":185773.34379789475}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":208833.75018947371},null,{"$f":"K25+K31","v":203189.59477894739},null,{"$f":"M25+M31","v":197545.43936842107},null,{"$f":"O25+O31","v":191901.28395789478},null,{"$f":"Q25+Q31","v":185773.34379789475},null,{"$f":"S25+S31","v":179645.40363789475}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":208833.75018947371},null,{"$f":"K35","v":203189.59477894739},null,{"$f":"M35","v":197545.43936842107},null,{"$f":"O35","v":191901.28395789478},null,{"$f":"Q35","v":185773.34379789475},null,{"$f":"S35","v":179645.40363789475}]
[]
[null,"Net Fixed Assets - Concrete Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I44","v":1310698.3120000004},null,{"$f":"K44","v":1310698.3120000004},null,{"$f":"M44","v":1310698.3120000004},null,{"$f":"O44","v":1310698.3120000004},null,{"$f":"Q44","v":1310698.3120000004}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G184","v":1310698.3120000004},null,{"$f":"'2. ICM_Costs'!I184","v":0},null,null,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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I41+I42-I43","v":1310698.3120000004},null,{"$f":"K41+K42-K43","v":1310698.3120000004},null,{"$f":"M41+M42-M43","v":1310698.3120000004},null,{"$f":"O41+O42-O43","v":1310698.3120000004},null,{"$f":"Q41+Q42-Q43","v":1310698.3120000004},null,{"$f":"S41+S42-S43","v":1310698.3120000004}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":-25699.966901960794},null,{"$f":"K50","v":-51399.933803921587},null,{"$f":"M50","v":-77099.900705882377},null,{"$f":"O50","v":-102799.86760784317},null,{"$f":"Q50","v":-124644.83947450985}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I42/('3. Cost_of_Service_Parameters'!M47)+MIN((I41/'3. Cost_of_Service_Parameters'!M47),(I41+I47)))), 0, -(I42/('3. Cost_of_Service_Parameters'!M47)+MIN((I41/'3. Cost_of_Service_Parameters'!M47),(I41+I47))))","v":-25699.966901960794},null,{"$f":"IF(ISERROR(-(K42/('3. Cost_of_Service_Parameters'!O47)+MIN((K41/'3. Cost_of_Service_Parameters'!O47),(K41+K47)))), 0, -(K42/('3. Cost_of_Service_Parameters'!O47)+MIN((K41/'3. Cost_of_Service_Parameters'!O47),(K41+K47))))","v":-25699.966901960794},null,{"$f":"IF(ISERROR(-(M42/('3. Cost_of_Service_Parameters'!Q47)+MIN((M41/'3. Cost_of_Service_Parameters'!Q47),(M41+M47)))), 0, -(M42/('3. Cost_of_Service_Parameters'!Q47)+MIN((M41/'3. Cost_of_Service_Parameters'!Q47),(M41+M47))))","v":-25699.966901960794},null,{"$f":"IF(ISERROR(-(O42/('3. Cost_of_Service_Parameters'!S47)+MIN((O41/'3. Cost_of_Service_Parameters'!S47),(O41+O47)))), 0, -(O42/('3. Cost_of_Service_Parameters'!S47)+MIN((O41/'3. Cost_of_Service_Parameters'!S47),(O41+O47))))","v":-25699.966901960794},null,{"$f":"IF(ISERROR(-(Q42/('3. Cost_of_Service_Parameters'!U47)+MIN((Q41/'3. Cost_of_Service_Parameters'!U47),(Q41+Q47)))), 0, -(Q42/('3. Cost_of_Service_Parameters'!U47)+MIN((Q41/'3. Cost_of_Service_Parameters'!U47),(Q41+Q47))))","v":-21844.971866666674},null,{"$f":"IF(ISERROR(-(S42/('3. Cost_of_Service_Parameters'!W47)+MIN((S41/'3. Cost_of_Service_Parameters'!W47),(S41+S47)))), 0, -(S42/('3. Cost_of_Service_Parameters'!W47)+MIN((S41/'3. Cost_of_Service_Parameters'!W47),(S41+S47))))","v":-21844.971866666674}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":-25699.966901960794},null,{"$f":"K47+K48-K49","v":-51399.933803921587},null,{"$f":"M47+M48-M49","v":-77099.900705882377},null,{"$f":"O47+O48-O49","v":-102799.86760784317},null,{"$f":"Q47+Q48-Q49","v":-124644.83947450985},null,{"$f":"S47+S48-S49","v":-146489.81134117651}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,1284998.3450980396,null,{"$f":"M41+M47","v":1259298.3781960788},null,1233598.411294118,null,{"$f":"Q41+Q47","v":1207898.4443921573},null,{"$f":"S41+S47","v":1186053.4725254904}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":1284998.3450980396},null,{"$f":"K44+K50","v":1259298.3781960788},null,{"$f":"M44+M50","v":1233598.411294118},null,{"$f":"O44+O50","v":1207898.4443921573},null,{"$f":"Q44+Q50","v":1186053.4725254904},null,{"$f":"S44+S50","v":1164208.5006588239}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":1284998.3450980396},null,{"$f":"K54","v":1259298.3781960788},null,{"$f":"M54","v":1233598.411294118},null,{"$f":"O54","v":1207898.4443921573},null,{"$f":"Q54","v":1186053.4725254904},null,{"$f":"S54","v":1164208.5006588239}]
[]
[null,"Net Fixed Assets - OH Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I63","v":238308.78400000004},null,{"$f":"K63","v":238308.78400000004},null,{"$f":"M63","v":238308.78400000004},null,{"$f":"O63","v":238308.78400000004},null,{"$f":"Q63","v":238308.78400000004}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":238308.78400000004},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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":238308.78400000004},null,{"$f":"K60+K61-K62","v":238308.78400000004},null,{"$f":"M60+M61-M62","v":238308.78400000004},null,{"$f":"O60+O61-O62","v":238308.78400000004},null,{"$f":"Q60+Q61-Q62","v":238308.78400000004},null,{"$f":"S60+S61-S62","v":238308.78400000004}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":-5812.4093658536594},null,{"$f":"K69","v":-11624.818731707319},null,{"$f":"M69","v":-17437.228097560979},null,{"$f":"O69","v":-23249.637463414638},null,{"$f":"Q69","v":-28545.388218970194}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I61/('3. Cost_of_Service_Parameters'!M51)+MIN((I60/'3. Cost_of_Service_Parameters'!M51),(I60+I66)))), 0, -(I61/('3. Cost_of_Service_Parameters'!M51)+MIN((I60/'3. Cost_of_Service_Parameters'!M51),(I60+I66))))","v":-5812.4093658536594},null,{"$f":"IF(ISERROR(-(K61/('3. Cost_of_Service_Parameters'!O51)+MIN((K60/'3. Cost_of_Service_Parameters'!O51),(K60+K66)))), 0, -(K61/('3. Cost_of_Service_Parameters'!O51)+MIN((K60/'3. Cost_of_Service_Parameters'!O51),(K60+K66))))","v":-5812.4093658536594},null,{"$f":"IF(ISERROR(-(M61/('3. Cost_of_Service_Parameters'!Q51)+MIN((M60/'3. Cost_of_Service_Parameters'!Q51),(M60+M66)))), 0, -(M61/('3. Cost_of_Service_Parameters'!Q51)+MIN((M60/'3. Cost_of_Service_Parameters'!Q51),(M60+M66))))","v":-5812.4093658536594},null,{"$f":"IF(ISERROR(-(O61/('3. Cost_of_Service_Parameters'!S51)+MIN((O60/'3. Cost_of_Service_Parameters'!S51),(O60+O66)))), 0, -(O61/('3. Cost_of_Service_Parameters'!S51)+MIN((O60/'3. Cost_of_Service_Parameters'!S51),(O60+O66))))","v":-5812.4093658536594},null,{"$f":"IF(ISERROR(-(Q61/('3. Cost_of_Service_Parameters'!U51)+MIN((Q60/'3. Cost_of_Service_Parameters'!U51),(Q60+Q66)))), 0, -(Q61/('3. Cost_of_Service_Parameters'!U51)+MIN((Q60/'3. Cost_of_Service_Parameters'!U51),(Q60+Q66))))","v":-5295.7507555555567},null,{"$f":"IF(ISERROR(-(S61/('3. Cost_of_Service_Parameters'!W51)+MIN((S60/'3. Cost_of_Service_Parameters'!W51),(S60+S66)))), 0, -(S61/('3. Cost_of_Service_Parameters'!W51)+MIN((S60/'3. Cost_of_Service_Parameters'!W51),(S60+S66))))","v":-5295.7507555555567}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":-5812.4093658536594},null,{"$f":"K66+K67-K68","v":-11624.818731707319},null,{"$f":"M66+M67-M68","v":-17437.228097560979},null,{"$f":"O66+O67-O68","v":-23249.637463414638},null,{"$f":"Q66+Q67-Q68","v":-28545.388218970194},null,{"$f":"S66+S67-S68","v":-33841.138974525747}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,232496.37463414637,null,{"$f":"M60+M66","v":226683.96526829273},null,220871.55590243905,null,{"$f":"Q60+Q66","v":215059.14653658541},null,{"$f":"S60+S66","v":209763.39578102986}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":232496.37463414637},null,{"$f":"K63+K69","v":226683.96526829273},null,{"$f":"M63+M69","v":220871.55590243905},null,{"$f":"O63+O69","v":215059.14653658541},null,{"$f":"Q63+Q69","v":209763.39578102986},null,{"$f":"S63+S69","v":204467.64502547431}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":232496.37463414637},null,{"$f":"K73","v":226683.96526829273},null,{"$f":"M73","v":220871.55590243905},null,{"$f":"O73","v":215059.14653658541},null,{"$f":"Q73","v":209763.39578102986},null,{"$f":"S73","v":204467.64502547431}]
[]
[null,"Net Fixed Assets - OH Prim Cond & Dev"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I82","v":357463.17600000004},null,{"$f":"K82","v":357463.17600000004},null,{"$f":"M82","v":357463.17600000004},null,{"$f":"O82","v":357463.17600000004},null,{"$f":"Q82","v":357463.17600000004}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":357463.17600000004},null,{"$f":"'2. ICM_Costs'!I188","v":0},null,null,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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":357463.17600000004},null,{"$f":"K79+K80-K81","v":357463.17600000004},null,{"$f":"M79+M80-M81","v":357463.17600000004},null,{"$f":"O79+O80-O81","v":357463.17600000004},null,{"$f":"Q79+Q80-Q81","v":357463.17600000004},null,{"$f":"S79+S80-S81","v":357463.17600000004}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":-7943.6261333333341},null,{"$f":"K88","v":-15887.252266666668},null,{"$f":"M88","v":-23830.878400000001},null,{"$f":"O88","v":-31774.504533333336},null,{"$f":"Q88","v":-38923.768053333333}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I80/('3. Cost_of_Service_Parameters'!M53)+MIN((I79/'3. Cost_of_Service_Parameters'!M53),(I79+I85)))), 0, -(I80/('3. Cost_of_Service_Parameters'!M53)+MIN((I79/'3. Cost_of_Service_Parameters'!M53),(I79+I85))))","v":-7943.6261333333341},null,{"$f":"IF(ISERROR(-(K80/('3. Cost_of_Service_Parameters'!O53)+MIN((K79/'3. Cost_of_Service_Parameters'!O53),(K79+K85)))), 0, -(K80/('3. Cost_of_Service_Parameters'!O53)+MIN((K79/'3. Cost_of_Service_Parameters'!O53),(K79+K85))))","v":-7943.6261333333341},null,{"$f":"IF(ISERROR(-(M80/('3. Cost_of_Service_Parameters'!Q53)+MIN((M79/'3. Cost_of_Service_Parameters'!Q53),(M79+M85)))), 0, -(M80/('3. Cost_of_Service_Parameters'!Q53)+MIN((M79/'3. Cost_of_Service_Parameters'!Q53),(M79+M85))))","v":-7943.6261333333341},null,{"$f":"IF(ISERROR(-(O80/('3. Cost_of_Service_Parameters'!S53)+MIN((O79/'3. Cost_of_Service_Parameters'!S53),(O79+O85)))), 0, -(O80/('3. Cost_of_Service_Parameters'!S53)+MIN((O79/'3. Cost_of_Service_Parameters'!S53),(O79+O85))))","v":-7943.6261333333341},null,{"$f":"IF(ISERROR(-(Q80/('3. Cost_of_Service_Parameters'!U53)+MIN((Q79/'3. Cost_of_Service_Parameters'!U53),(Q79+Q85)))), 0, -(Q80/('3. Cost_of_Service_Parameters'!U53)+MIN((Q79/'3. Cost_of_Service_Parameters'!U53),(Q79+Q85))))","v":-7149.2635200000004},null,{"$f":"IF(ISERROR(-(S80/('3. Cost_of_Service_Parameters'!W53)+MIN((S79/'3. Cost_of_Service_Parameters'!W53),(S79+S85)))), 0, -(S80/('3. Cost_of_Service_Parameters'!W53)+MIN((S79/'3. Cost_of_Service_Parameters'!W53),(S79+S85))))","v":-7149.2635200000004}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":-7943.6261333333341},null,{"$f":"K85+K86-K87","v":-15887.252266666668},null,{"$f":"M85+M86-M87","v":-23830.878400000001},null,{"$f":"O85+O86-O87","v":-31774.504533333336},null,{"$f":"Q85+Q86-Q87","v":-38923.768053333333},null,{"$f":"S85+S86-S87","v":-46073.031573333334}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,349519.54986666673,null,{"$f":"M79+M85","v":341575.92373333336},null,333632.29760000005,null,{"$f":"Q79+Q85","v":325688.67146666668},null,{"$f":"S79+S85","v":318539.4079466667}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":349519.54986666673},null,{"$f":"K82+K88","v":341575.92373333336},null,{"$f":"M82+M88","v":333632.29760000005},null,{"$f":"O82+O88","v":325688.67146666668},null,{"$f":"Q82+Q88","v":318539.4079466667},null,{"$f":"S82+S88","v":311390.14442666672}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":349519.54986666673},null,{"$f":"K92","v":341575.92373333336},null,{"$f":"M92","v":333632.29760000005},null,{"$f":"O92","v":325688.67146666668},null,{"$f":"Q92","v":318539.4079466667},null,{"$f":"S92","v":311390.14442666672}]
[]
[null,"Net Fixed Assets - OH Sec Cond & Dev"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I101","v":119154.39200000002},null,{"$f":"K101","v":119154.39200000002},null,{"$f":"M101","v":119154.39200000002},null,{"$f":"O101","v":119154.39200000002},null,{"$f":"Q101","v":119154.39200000002}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":119154.39200000002},null,{"$f":"'2. ICM_Costs'!I190","v":0},null,null,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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I98+I99-I100","v":119154.39200000002},null,{"$f":"K98+K99-K100","v":119154.39200000002},null,{"$f":"M98+M99-M100","v":119154.39200000002},null,{"$f":"O98+O99-O100","v":119154.39200000002},null,{"$f":"Q98+Q99-Q100","v":119154.39200000002},null,{"$f":"S98+S99-S100","v":119154.39200000002}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":-2482.383166666667},null,{"$f":"K107","v":-4964.7663333333339},null,{"$f":"M107","v":-7447.1495000000014},null,{"$f":"O107","v":-9929.5326666666679},null,{"$f":"Q107","v":-12312.620506666668}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I99/('3. Cost_of_Service_Parameters'!M55)+MIN((I98/'3. Cost_of_Service_Parameters'!M55),(I98+I104)))), 0, -(I99/('3. Cost_of_Service_Parameters'!M55)+MIN((I98/'3. Cost_of_Service_Parameters'!M55),(I98+I104))))","v":-2482.383166666667},null,{"$f":"IF(ISERROR(-(K99/('3. Cost_of_Service_Parameters'!O55)+MIN((K98/'3. Cost_of_Service_Parameters'!O55),(K98+K104)))), 0, -(K99/('3. Cost_of_Service_Parameters'!O55)+MIN((K98/'3. Cost_of_Service_Parameters'!O55),(K98+K104))))","v":-2482.383166666667},null,{"$f":"IF(ISERROR(-(M99/('3. Cost_of_Service_Parameters'!Q55)+MIN((M98/'3. Cost_of_Service_Parameters'!Q55),(M98+M104)))), 0, -(M99/('3. Cost_of_Service_Parameters'!Q55)+MIN((M98/'3. Cost_of_Service_Parameters'!Q55),(M98+M104))))","v":-2482.383166666667},null,{"$f":"IF(ISERROR(-(O99/('3. Cost_of_Service_Parameters'!S55)+MIN((O98/'3. Cost_of_Service_Parameters'!S55),(O98+O104)))), 0, -(O99/('3. Cost_of_Service_Parameters'!S55)+MIN((O98/'3. Cost_of_Service_Parameters'!S55),(O98+O104))))","v":-2482.383166666667},null,{"$f":"IF(ISERROR(-(Q99/('3. Cost_of_Service_Parameters'!U55)+MIN((Q98/'3. Cost_of_Service_Parameters'!U55),(Q98+Q104)))), 0, -(Q99/('3. Cost_of_Service_Parameters'!U55)+MIN((Q98/'3. Cost_of_Service_Parameters'!U55),(Q98+Q104))))","v":-2383.0878400000006},null,{"$f":"IF(ISERROR(-(S99/('3. Cost_of_Service_Parameters'!W55)+MIN((S98/'3. Cost_of_Service_Parameters'!W55),(S98+S104)))), 0, -(S99/('3. Cost_of_Service_Parameters'!W55)+MIN((S98/'3. Cost_of_Service_Parameters'!W55),(S98+S104))))","v":-2383.0878400000006}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":-2482.383166666667},null,{"$f":"K104+K105-K106","v":-4964.7663333333339},null,{"$f":"M104+M105-M106","v":-7447.1495000000014},null,{"$f":"O104+O105-O106","v":-9929.5326666666679},null,{"$f":"Q104+Q105-Q106","v":-12312.620506666668},null,{"$f":"S104+S105-S106","v":-14695.708346666668}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,116672.00883333336,null,{"$f":"M98+M104","v":114189.62566666669},null,111707.24250000002,null,{"$f":"Q98+Q104","v":109224.85933333336},null,{"$f":"S98+S104","v":106841.77149333335}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":116672.00883333336},null,{"$f":"K101+K107","v":114189.62566666669},null,{"$f":"M101+M107","v":111707.24250000002},null,{"$f":"O101+O107","v":109224.85933333336},null,{"$f":"Q101+Q107","v":106841.77149333335},null,{"$f":"S101+S107","v":104458.68365333336}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":116672.00883333336},null,{"$f":"K111","v":114189.62566666669},null,{"$f":"M111","v":111707.24250000002},null,{"$f":"O111","v":109224.85933333336},null,{"$f":"Q111","v":106841.77149333335},null,{"$f":"S111","v":104458.68365333336}]
[]
[null,"Net Fixed Assets - UG Prim XLPE TR"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I120","v":71492.635200000004},null,{"$f":"K120","v":71492.635200000004},null,{"$f":"M120","v":71492.635200000004},null,{"$f":"O120","v":71492.635200000004},null,{"$f":"Q120","v":71492.635200000004}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":71492.635200000004},null,{"$f":"'2. ICM_Costs'!I192","v":0},null,null,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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I117+I118-I119","v":71492.635200000004},null,{"$f":"K117+K118-K119","v":71492.635200000004},null,{"$f":"M117+M118-M119","v":71492.635200000004},null,{"$f":"O117+O118-O119","v":71492.635200000004},null,{"$f":"Q117+Q118-Q119","v":71492.635200000004},null,{"$f":"S117+S118-S119","v":71492.635200000004}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":-1881.3851368421053},null,{"$f":"K126","v":-3762.7702736842107},null,{"$f":"M126","v":-5644.1554105263158},null,{"$f":"O126","v":-7525.5405473684214},null,{"$f":"Q126","v":-9114.2657740350878}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I118/('3. Cost_of_Service_Parameters'!M61)+MIN((I117/'3. Cost_of_Service_Parameters'!M61),(I117+I123)))), 0, -(I118/('3. Cost_of_Service_Parameters'!M61)+MIN((I117/'3. Cost_of_Service_Parameters'!M61),(I117+I123))))","v":-1881.3851368421053},null,{"$f":"IF(ISERROR(-(K118/('3. Cost_of_Service_Parameters'!O61)+MIN((K117/'3. Cost_of_Service_Parameters'!O61),(K117+K123)))), 0, -(K118/('3. Cost_of_Service_Parameters'!O61)+MIN((K117/'3. Cost_of_Service_Parameters'!O61),(K117+K123))))","v":-1881.3851368421053},null,{"$f":"IF(ISERROR(-(M118/('3. Cost_of_Service_Parameters'!Q61)+MIN((M117/'3. Cost_of_Service_Parameters'!Q61),(M117+M123)))), 0, -(M118/('3. Cost_of_Service_Parameters'!Q61)+MIN((M117/'3. Cost_of_Service_Parameters'!Q61),(M117+M123))))","v":-1881.3851368421053},null,{"$f":"IF(ISERROR(-(O118/('3. Cost_of_Service_Parameters'!S61)+MIN((O117/'3. Cost_of_Service_Parameters'!S61),(O117+O123)))), 0, -(O118/('3. Cost_of_Service_Parameters'!S61)+MIN((O117/'3. Cost_of_Service_Parameters'!S61),(O117+O123))))","v":-1881.3851368421053},null,{"$f":"IF(ISERROR(-(Q118/('3. Cost_of_Service_Parameters'!U61)+MIN((Q117/'3. Cost_of_Service_Parameters'!U61),(Q117+Q123)))), 0, -(Q118/('3. Cost_of_Service_Parameters'!U61)+MIN((Q117/'3. Cost_of_Service_Parameters'!U61),(Q117+Q123))))","v":-1588.7252266666667},null,{"$f":"IF(ISERROR(-(S118/('3. Cost_of_Service_Parameters'!W61)+MIN((S117/'3. Cost_of_Service_Parameters'!W61),(S117+S123)))), 0, -(S118/('3. Cost_of_Service_Parameters'!W61)+MIN((S117/'3. Cost_of_Service_Parameters'!W61),(S117+S123))))","v":-1588.7252266666667}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":-1881.3851368421053},null,{"$f":"K123+K124-K125","v":-3762.7702736842107},null,{"$f":"M123+M124-M125","v":-5644.1554105263158},null,{"$f":"O123+O124-O125","v":-7525.5405473684214},null,{"$f":"Q123+Q124-Q125","v":-9114.2657740350878},null,{"$f":"S123+S124-S125","v":-10702.991000701755}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,69611.250063157902,null,{"$f":"M117+M123","v":67729.8649263158},null,65848.479789473684,null,{"$f":"Q117+Q123","v":63967.094652631582},null,{"$f":"S117+S123","v":62378.36942596492}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":69611.250063157902},null,{"$f":"K120+K126","v":67729.8649263158},null,{"$f":"M120+M126","v":65848.479789473684},null,{"$f":"O120+O126","v":63967.094652631582},null,{"$f":"Q120+Q126","v":62378.36942596492},null,{"$f":"S120+S126","v":60789.644199298251}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":69611.250063157902},null,{"$f":"K130","v":67729.8649263158},null,{"$f":"M130","v":65848.479789473684},null,{"$f":"O130","v":63967.094652631582},null,{"$f":"Q130","v":62378.36942596492},null,{"$f":"S130","v":60789.644199298251}]
[]
[null,"Net Fixed Assets - UG Sec - Dir Buried"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I139","v":71492.635200000004},null,{"$f":"K139","v":71492.635200000004},null,{"$f":"M139","v":71492.635200000004},null,{"$f":"O139","v":71492.635200000004},null,{"$f":"Q139","v":71492.635200000004}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":71492.635200000004},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,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I136+I137-I138","v":71492.635200000004},null,{"$f":"K136+K137-K138","v":71492.635200000004},null,{"$f":"M136+M137-M138","v":71492.635200000004},null,{"$f":"O136+O137-O138","v":71492.635200000004},null,{"$f":"Q136+Q137-Q138","v":71492.635200000004},null,{"$f":"S136+S137-S138","v":71492.635200000004}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":-2306.2140387096774},null,{"$f":"K145","v":-4612.4280774193548},null,{"$f":"M145","v":-6918.6421161290327},null,{"$f":"O145","v":-9224.8561548387097},null,{"$f":"Q145","v":-11607.94399483871}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I137/('3. Cost_of_Service_Parameters'!M63)+MIN((I136/'3. Cost_of_Service_Parameters'!M63),(I136+I142)))), 0, -(I137/('3. Cost_of_Service_Parameters'!M63)+MIN((I136/'3. Cost_of_Service_Parameters'!M63),(I136+I142))))","v":-2306.2140387096774},null,{"$f":"IF(ISERROR(-(K137/('3. Cost_of_Service_Parameters'!O63)+MIN((K136/'3. Cost_of_Service_Parameters'!O63),(K136+K142)))), 0, -(K137/('3. Cost_of_Service_Parameters'!O63)+MIN((K136/'3. Cost_of_Service_Parameters'!O63),(K136+K142))))","v":-2306.2140387096774},null,{"$f":"IF(ISERROR(-(M137/('3. Cost_of_Service_Parameters'!Q63)+MIN((M136/'3. Cost_of_Service_Parameters'!Q63),(M136+M142)))), 0, -(M137/('3. Cost_of_Service_Parameters'!Q63)+MIN((M136/'3. Cost_of_Service_Parameters'!Q63),(M136+M142))))","v":-2306.2140387096774},null,{"$f":"IF(ISERROR(-(O137/('3. Cost_of_Service_Parameters'!S63)+MIN((O136/'3. Cost_of_Service_Parameters'!S63),(O136+O142)))), 0, -(O137/('3. Cost_of_Service_Parameters'!S63)+MIN((O136/'3. Cost_of_Service_Parameters'!S63),(O136+O142))))","v":-2306.2140387096774},null,{"$f":"IF(ISERROR(-(Q137/('3. Cost_of_Service_Parameters'!U63)+MIN((Q136/'3. Cost_of_Service_Parameters'!U63),(Q136+Q142)))), 0, -(Q137/('3. Cost_of_Service_Parameters'!U63)+MIN((Q136/'3. Cost_of_Service_Parameters'!U63),(Q136+Q142))))","v":-2383.0878400000001},null,{"$f":"IF(ISERROR(-(S137/('3. Cost_of_Service_Parameters'!W63)+MIN((S136/'3. Cost_of_Service_Parameters'!W63),(S136+S142)))), 0, -(S137/('3. Cost_of_Service_Parameters'!W63)+MIN((S136/'3. Cost_of_Service_Parameters'!W63),(S136+S142))))","v":-2383.0878400000001}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":-2306.2140387096774},null,{"$f":"K142+K143-K144","v":-4612.4280774193548},null,{"$f":"M142+M143-M144","v":-6918.6421161290327},null,{"$f":"O142+O143-O144","v":-9224.8561548387097},null,{"$f":"Q142+Q143-Q144","v":-11607.94399483871},null,{"$f":"S142+S143-S144","v":-13991.03183483871}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,69186.421161290331,null,{"$f":"M136+M142","v":66880.207122580643},null,64573.99308387097,null,{"$f":"Q136+Q142","v":62267.779045161296},null,{"$f":"S136+S142","v":59884.691205161296}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":69186.421161290331},null,{"$f":"K139+K145","v":66880.207122580643},null,{"$f":"M139+M145","v":64573.99308387097},null,{"$f":"O139+O145","v":62267.779045161296},null,{"$f":"Q139+Q145","v":59884.691205161296},null,{"$f":"S139+S145","v":57501.603365161296}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":69186.421161290331},null,{"$f":"K149","v":66880.207122580643},null,{"$f":"M149","v":64573.99308387097},null,{"$f":"O149","v":62267.779045161296},null,{"$f":"Q149","v":59884.691205161296},null,{"$f":"S149","v":57501.603365161296}]
[]
[null,"Net Fixed Assets - OH Services"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!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,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,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[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)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161)))), 0, -(K156/('3. Cost_of_Service_Parameters'!I59)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161))))","v":0},null,{"$f":"IF(ISERROR(-(M156/('3. Cost_of_Service_Parameters'!K59)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161)))), 0, -(M156/('3. Cost_of_Service_Parameters'!K59)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161))))","v":0},null,{"$f":"IF(ISERROR(-(O156/('3. Cost_of_Service_Parameters'!M59)+MIN((O155/'3. Cost_of_Service_Parameters'!M59),(O155+O161)))), 0, -(O156/('3. Cost_of_Service_Parameters'!M59)+MIN((O155/'3. Cost_of_Service_Parameters'!M59),(O155+O161))))","v":0},null,{"$f":"IF(ISERROR(-(Q156/('3. Cost_of_Service_Parameters'!O59)+MIN((Q155/'3. Cost_of_Service_Parameters'!O59),(Q155+Q161)))), 0, -(Q156/('3. Cost_of_Service_Parameters'!O59)+MIN((Q155/'3. Cost_of_Service_Parameters'!O59),(Q155+Q161))))","v":0},null,{"$f":"IF(ISERROR(-(S156/('3. Cost_of_Service_Parameters'!Q59)+MIN((S155/'3. Cost_of_Service_Parameters'!Q59),(S155+S161)))), 0, -(S156/('3. Cost_of_Service_Parameters'!Q59)+MIN((S155/'3. Cost_of_Service_Parameters'!Q59),(S155+S161))))","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,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I155+I161","v":0},null,0,null,{"$f":"M155+M161","v":0},null,0,null,{"$f":"Q155+Q161","v":0},null,{"$f":"S155+S161","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,null,null,"Incremental CAPEX",null,null,null,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,"Net Fixed Assets - RTUs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,null,null,{"$f":"'2. ICM_Costs'!I198","v":0},null,null,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,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,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[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)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180)))), 0, -(K175/('3. Cost_of_Service_Parameters'!I61)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180))))","v":0},null,{"$f":"IF(ISERROR(-(M175/('3. Cost_of_Service_Parameters'!K61)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180)))), 0, -(M175/('3. Cost_of_Service_Parameters'!K61)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180))))","v":0},null,{"$f":"IF(ISERROR(-(O175/('3. Cost_of_Service_Parameters'!M61)+MIN((O174/'3. Cost_of_Service_Parameters'!M61),(O174+O180)))), 0, -(O175/('3. Cost_of_Service_Parameters'!M61)+MIN((O174/'3. Cost_of_Service_Parameters'!M61),(O174+O180))))","v":0},null,{"$f":"IF(ISERROR(-(Q175/('3. Cost_of_Service_Parameters'!O61)+MIN((Q174/'3. Cost_of_Service_Parameters'!O61),(Q174+Q180)))), 0, -(Q175/('3. Cost_of_Service_Parameters'!O61)+MIN((Q174/'3. Cost_of_Service_Parameters'!O61),(Q174+Q180))))","v":0},null,{"$f":"IF(ISERROR(-(S175/('3. Cost_of_Service_Parameters'!Q61)+MIN((S174/'3. Cost_of_Service_Parameters'!Q61),(S174+S180)))), 0, -(S175/('3. Cost_of_Service_Parameters'!Q61)+MIN((S174/'3. Cost_of_Service_Parameters'!Q61),(S174+S180))))","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,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,0,null,{"$f":"M174+M180","v":0},null,0,null,{"$f":"Q174+Q180","v":0},null,{"$f":"S174+S180","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,null,null,"Incremental CAPEX",null,null,null,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,"Net Fixed Assets - System Supervisory Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,null,null,{"$f":"'2. ICM_Costs'!I200","v":0},null,null,null,{"$f":"'2. ICM_Costs'!M200","v":0},null,{"$f":"'2. ICM_Costs'!O200","v":0},null,{"$f":"'2. ICM_Costs'!Q200","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,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[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)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200)))), 0, -(K195/('3. Cost_of_Service_Parameters'!I63)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200))))","v":0},null,{"$f":"IF(ISERROR(-(M195/('3. Cost_of_Service_Parameters'!K63)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200)))), 0, -(M195/('3. Cost_of_Service_Parameters'!K63)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200))))","v":0},null,{"$f":"IF(ISERROR(-(O195/('3. Cost_of_Service_Parameters'!M63)+MIN((O194/'3. Cost_of_Service_Parameters'!M63),(O194+O200)))), 0, -(O195/('3. Cost_of_Service_Parameters'!M63)+MIN((O194/'3. Cost_of_Service_Parameters'!M63),(O194+O200))))","v":0},null,{"$f":"IF(ISERROR(-(Q195/('3. Cost_of_Service_Parameters'!O63)+MIN((Q194/'3. Cost_of_Service_Parameters'!O63),(Q194+Q200)))), 0, -(Q195/('3. Cost_of_Service_Parameters'!O63)+MIN((Q194/'3. Cost_of_Service_Parameters'!O63),(Q194+Q200))))","v":0},null,{"$f":"IF(ISERROR(-(S195/('3. Cost_of_Service_Parameters'!Q63)+MIN((S194/'3. Cost_of_Service_Parameters'!Q63),(S194+S200)))), 0, -(S195/('3. Cost_of_Service_Parameters'!Q63)+MIN((S194/'3. Cost_of_Service_Parameters'!Q63),(S194+S200))))","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,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,0,null,{"$f":"M194+M200","v":0},null,0,null,{"$f":"Q194+Q200","v":0},null,{"$f":"S194+S200","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,null,null,"Incremental CAPEX",null,null,null,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,"Net Fixed Assets - Distribution Station Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":0},null,{"$f":"'2. ICM_Costs'!I202","v":0},null,{"$f":"'2. ICM_Costs'!K202","v":0},null,{"$f":"'2. ICM_Costs'!M202","v":0},null,{"$f":"'2. ICM_Costs'!O202","v":0},null,{"$f":"'2. ICM_Costs'!Q202","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,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[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)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220)))), 0, -(K215/('3. Cost_of_Service_Parameters'!I65)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220))))","v":0},null,{"$f":"IF(ISERROR(-(M215/('3. Cost_of_Service_Parameters'!K65)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220)))), 0, -(M215/('3. Cost_of_Service_Parameters'!K65)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220))))","v":0},null,{"$f":"IF(ISERROR(-(O215/('3. Cost_of_Service_Parameters'!M65)+MIN((O214/'3. Cost_of_Service_Parameters'!M65),(O214+O220)))), 0, -(O215/('3. Cost_of_Service_Parameters'!M65)+MIN((O214/'3. Cost_of_Service_Parameters'!M65),(O214+O220))))","v":0},null,{"$f":"IF(ISERROR(-(Q215/('3. Cost_of_Service_Parameters'!O65)+MIN((Q214/'3. Cost_of_Service_Parameters'!O65),(Q214+Q220)))), 0, -(Q215/('3. Cost_of_Service_Parameters'!O65)+MIN((Q214/'3. Cost_of_Service_Parameters'!O65),(Q214+Q220))))","v":0},null,{"$f":"IF(ISERROR(-(S215/('3. Cost_of_Service_Parameters'!Q65)+MIN((S214/'3. Cost_of_Service_Parameters'!Q65),(S214+S220)))), 0, -(S215/('3. Cost_of_Service_Parameters'!Q65)+MIN((S214/'3. Cost_of_Service_Parameters'!Q65),(S214+S220))))","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,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,0,null,{"$f":"M214+M220","v":0},null,0,null,{"$f":"Q214+Q220","v":0},null,{"$f":"S214+S220","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,null,null,"Incremental CAPEX",null,null,null,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,"Net Fixed Assets - Transformer Station Equipment"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":0},null,{"$f":"'2. ICM_Costs'!I204","v":0},null,{"$f":"'2. ICM_Costs'!K204","v":0},null,{"$f":"'2. ICM_Costs'!M204","v":0},null,{"$f":"'2. ICM_Costs'!O204","v":0},null,{"$f":"'2. ICM_Costs'!Q204","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,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[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)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240)))), 0, -(K235/('3. Cost_of_Service_Parameters'!I67)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240))))","v":0},null,{"$f":"IF(ISERROR(-(M235/('3. Cost_of_Service_Parameters'!K67)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240)))), 0, -(M235/('3. Cost_of_Service_Parameters'!K67)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240))))","v":0},null,{"$f":"IF(ISERROR(-(O235/('3. Cost_of_Service_Parameters'!M67)+MIN((O234/'3. Cost_of_Service_Parameters'!M67),(O234+O240)))), 0, -(O235/('3. Cost_of_Service_Parameters'!M67)+MIN((O234/'3. Cost_of_Service_Parameters'!M67),(O234+O240))))","v":0},null,{"$f":"IF(ISERROR(-(Q235/('3. Cost_of_Service_Parameters'!O67)+MIN((Q234/'3. Cost_of_Service_Parameters'!O67),(Q234+Q240)))), 0, -(Q235/('3. Cost_of_Service_Parameters'!O67)+MIN((Q234/'3. Cost_of_Service_Parameters'!O67),(Q234+Q240))))","v":0},null,{"$f":"IF(ISERROR(-(S235/('3. Cost_of_Service_Parameters'!Q67)+MIN((S234/'3. Cost_of_Service_Parameters'!Q67),(S234+S240)))), 0, -(S235/('3. Cost_of_Service_Parameters'!Q67)+MIN((S234/'3. Cost_of_Service_Parameters'!Q67),(S234+S240))))","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,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I234+I240","v":0},null,0,null,{"$f":"M234+M240","v":0},null,0,null,{"$f":"Q234+Q240","v":0},null,{"$f":"S234+S240","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,null,null,"Incremental CAPEX",null,null,null,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,"Net Fixed Assets - Land Rights"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance"]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":0},null,{"$f":"'2. ICM_Costs'!I206","v":0},null,{"$f":"'2. ICM_Costs'!K206","v":0},null,{"$f":"'2. ICM_Costs'!M206","v":0},null,{"$f":"'2. ICM_Costs'!O206","v":0},null,{"$f":"'2. ICM_Costs'!Q206","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,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance"]
[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,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,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I254+I260","v":0},null,0,null,{"$f":"M254+M260","v":0},null,0,null,{"$f":"Q254+Q260","v":0},null,{"$f":"S254+S260","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,null,null,"Incremental CAPEX",null,null,null,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,null,null,"Additions",null,null,null,null,{"$f":"I23+I42+I61+I80+I99+I118+I137+I156+I175+I195+I215+I235+I255","v":2383087.8400000003},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,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I36+I55+I74+I93+I112+I131+I150+I169+I188+I208+I228+I248+I268","v":2331317.699846108},null,{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268","v":2279547.5596922152},null,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268","v":2227777.4195383228},null,{"$f":"O36+O55+O74+O93+O112+O131+O150+O169+O188+O208+O228+O248+O268","v":2176007.2793844305},null,{"$f":"Q36+Q55+Q74+Q93+Q112+Q131+Q150+Q169+Q188+Q208+Q228+Q248+Q268","v":2129234.4521755413},null,{"$f":"S36+S55+S74+S93+S112+S131+S150+S169+S188+S208+S228+S248+S268","v":2082461.6249666524}]
[null,null,null,"Total Amortization",null,null,null,null,{"$f":"I29+I48+I67+I86+I105+I124+I143+I162+I181+I201+I221+I241+I261","v":-51770.140153892549},null,{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261","v":-51770.140153892549},null,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261","v":-51770.140153892549},null,{"$f":"O29+O48+O67+O86+O105+O124+O143+O162+O181+O201+O221+O241+O261","v":-51770.140153892549},null,{"$f":"Q29+Q48+Q67+Q86+Q105+Q124+Q143+Q162+Q181+Q201+Q221+Q241+Q261","v":-46772.827208888906},null,{"$f":"S29+S48+S67+S86+S105+S124+S143+S162+S181+S201+S221+S241+S261","v":-46772.827208888906}]

{"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,2021]
[null,null,null,{"$f":"'2. ICM_Costs'!G19","v":"Audited Actual"}]
[]
["Opening UCC",null,null,0]
["Capital Additions",null,null,{"$f":"'2. ICM_Costs'!G216","v":2383087.8400000003}]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D23:D24)-D25","v":2383087.8400000003}]
[]
[]
["CCA Rate Class",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G83","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G84","v":0.08}]
["CCA",null,null,{"$f":"D26*D30","v":190647.02720000004}]
["Closing UCC",null,null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":2192440.8128000004}]
[]
["UCC/Class 8",null,null,{"$f":"D20","v":2021}]
[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'!G134","v":47}]
["CCA Rate ",null,null,{"$f":"'3. Cost_of_Service_Parameters'!G135","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":"6. ICMIRR_2021 actual","index":5,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Goreway Road Widening - Brampton RZ"]
[null,null,null,null,null,"Actual"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital",null,null,2383087.8400000003]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I277","v":51770.140153892549}]
[null,null,"Incremental Capital to be included in Rate Base (avg NBV)",null,null,{"$f":"((F20)+(F20-F21))/2","v":2357202.7699230541}]
[]
[null,null,"Deemed ShortTerm Debt %",0.04,"E",{"$f":"F22*D24","v":94288.110796922163}]
[null,null,"Deemed Long Term Debt %",0.56000000000000005,"F",{"$f":"F22*D25","v":1320033.5511569104}]
[]
[null,null,"Short Term Interest",2.1600000000000001E-2,"I",{"$f":"F24*D27","v":2036.6231932135188}]
[null,null,"Long Term Interest",6.0728710462287103E-2,"J",{"$f":"F25*D28","v":80163.935328712658}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F27:F28)","v":82200.55852192617}]
[]
[]
[null,null,"Deemed Equity %",0.39999999999999991,"N",{"$f":"F22*D33","v":942881.10796922143}]
[]
[null,null,"Return on Rate Base -Equity",9.2999999999999999E-2,"O",{"$f":"F33*D35","v":87687.943041137594}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F30+F35","v":169888.50156306376}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F21","v":51770.140153892549}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F35","v":87687.943041137594}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F43","v":51770.140153892549}]
[]
[null,null,"Deduct CCA",null,null,190647.02720000004]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F48+F50-F52","v":-51188.944004969904}]
[]
[null,null,"Current Tax Rate",0.26500000000000001,"X"]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F54*D56","v":-13565.070161317026}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F58/(1-D56)","v":-18455.877770499355}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX"]
[]
[null,null,"Less : Available Capital Exemption (if any)"]
[]
[null,null,"Incremental Capital CAPEX subject to OCT"]
[]
[null,null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",null,"AD"]
[]
[null,null,"Incremental Ontario Capital Tax"]
[]
[]
[null,null,"Incremental Revenue Requirement"]
[null,null,"Return on Rate Base - Total",null,"Q",{"$f":"F37","v":169888.50156306376}]
[null,null,"Amortization Expense - Total",null,null,{"$f":"F43","v":51770.140153892549}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F60","v":-18455.877770499355}]
[]
[]
[null,null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(F76:F79)","v":203202.76394645695}]

{"sheet":"7. Rate Rider Revs","index":6,"n_rows":94,"n_cols":17,"rows_kept":94,"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,null,null,null,null,"2021-01-01",{"$f":"YEAR(F23)","v":2021},{"$f":"IF(MONTH(F23)=0,\"\",IF(MONTH(F23)<4,\"Q1\",IF(MONTH(F23)<7,\"Q2\",IF(MONTH(F23)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G23,\" \",H23)","v":"2021 Q1"},0,5863.0881167157431,{"$f":"VLOOKUP(I23,$B$22:$D$59,2)","v":5.7000000000000002E-3},{"$f":"ROUND(J23*L23/12,2)","v":0},{"$f":"K23+M23","v":5863.0881167157431},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"P23","v":16933.563662204746}]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2021-02-01",2021,"Q1","2021 Q1",{"$f":"J23+K23","v":5863.0881167157431},21796.508636759194,5.7000000000000002E-3,2.78,{"$f":"N23+K24+M24","v":27662.376753474935},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q23+P24","v":33867.127324409492}]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2021-03-01",2021,"Q1","2021 Q1",27659.596753474936,17026.638474084259,5.7000000000000002E-3,13.14,44702.155227559197,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q24+P25","v":50800.690986614238}]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2021-04-01",2021,"Q2","2021 Q2",44686.235227559198,13206.037364172302,5.7000000000000002E-3,21.23,57929.422591731498,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},67734.254648818984]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2021-05-01",2021,"Q2","2021 Q2",57892.272591731497,15247.129633956878,5.7000000000000002E-3,27.5,73204.052225688371,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},84667.81831102373]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2021-06-01",2021,"Q2","2021 Q2",73139.402225688376,15170.38147010293,5.7000000000000002E-3,34.74,88409.173695791309,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},101601.38197322848]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2021-07-01",2021,"Q3","2021 Q3",88309.78369579131,14724.529700121511,5.7000000000000002E-3,41.95,103175.65339591281,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},118534.94563543322]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2021-08-01",2021,"Q3","2021 Q3",103034.31339591282,16435.129500828461,5.7000000000000002E-3,48.94,119659.72289674128,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},135468.50929763797]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2021-09-01",2021,"Q3","2021 Q3",119469.44289674128,14859.041549841284,5.7000000000000002E-3,56.75,134575.51444658256,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},152402.07295984271]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2021-10-01",2021,"Q4","2021 Q4",134328.48444658256,14939.976433272686,5.7000000000000002E-3,63.81,149579.30087985523,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},169335.63662204746]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2021-11-01",2021,"Q4","2021 Q4",149268.46087985524,15568.701806559115,5.7000000000000002E-3,70.900000000000006,165218.90268641434,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},186269.20028425221]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2021-12-01",2021,{"$f":"IF(MONTH(F34)=0,\"\",IF(MONTH(F34)<4,\"Q1\",IF(MONTH(F34)<7,\"Q2\",IF(MONTH(F34)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2021 Q4",164837.16268641435,15146.733653771793,5.7000000000000002E-3,78.3,180443.9363401861,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},203202.76394645695]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2022-01-01",{"$f":"YEAR(F35)","v":2022},{"$f":"IF(MONTH(F35)=0,\"\",IF(MONTH(F35)<4,\"Q1\",IF(MONTH(F35)<7,\"Q2\",IF(MONTH(F35)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2022 Q1",{"$f":"J34+K34","v":179983.89634018613},14393.387524410833,{"$f":"VLOOKUP(I35,$B$22:$D$59,2)","v":5.7000000000000002E-3},{"$f":"ROUND(J35*L35/12,2)","v":85.49},{"$f":"N34+K35+M35","v":194922.81386459692},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q34+P35","v":220136.3276086617}]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2022-02-01",2022,"Q1","2022 Q1",194377.28386459695,14514.792358077759,5.7000000000000002E-3,92.33,209529.93622267467,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},237069.89127086644]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2022-03-01",2022,"Q1","2022 Q1",208892.07622267472,16220.455391781452,5.7000000000000002E-3,99.22,225849.61161445614,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},254003.45493307119]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2022-04-01",2022,"Q2","2022 Q2",225112.53161445618,14016.231569665249,1.0200000000000001E-2,191.35,240057.1931841214,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},270937.01859527593]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2022-05-01",2022,"Q2","2022 Q2",239128.76318412143,15734.427168383303,1.0200000000000001E-2,203.26,255994.8803525047,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},287870.58225748071]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2022-06-01",2022,"Q2","2022 Q2",254863.19035250472,15321.941220510771,1.0200000000000001E-2,216.63,271533.45157301548,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},304804.14591968548]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2022-07-01",2022,"Q3","2022 Q3",270185.13157301547,15433.221668189313,2.1999999999999999E-2,495.34,287462.01324120484,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},321737.70958189026]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2022-08-01",2022,"Q3","2022 Q3",285618.35324120481,16403.996261358239,2.1999999999999999E-2,523.63,304389.63950256311,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},338671.27324409503]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2022-09-01",2022,"Q3","2022 Q3",302022.34950256307,14328.088245009554,2.1999999999999999E-2,553.71,319271.43774757267,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},355604.83690629981]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2022-10-01",2022,"Q4","2022 Q4",316350.43774757261,15036.659804126057,3.8699999999999998E-2,1020.23,335328.32755169872,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},372538.40056850458]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2022-11-01",2022,"Q4","2022 Q4",331387.09755169868,14545.030055972689,3.8699999999999998E-2,1068.72,350942.07760767138,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},389471.96423070936]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2022-12-01",2022,{"$f":"IF(MONTH(F46)=0,\"\",IF(MONTH(F46)<4,\"Q1\",IF(MONTH(F46)<7,\"Q2\",IF(MONTH(F46)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2022 Q4",345932.12760767137,16043.087989478552,3.8699999999999998E-2,1115.6300000000001,368100.79559714993,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},406405.52789291414]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2023-01-01",{"$f":"YEAR(F47)","v":2023},{"$f":"IF(MONTH(F47)=0,\"\",IF(MONTH(F47)<4,\"Q1\",IF(MONTH(F47)<7,\"Q2\",IF(MONTH(F47)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2023 Q1",{"$f":"J46+K46","v":361975.21559714992},15386.222040865647,{"$f":"VLOOKUP(I47,$B$22:$D$59,2)","v":4.7300000000000002E-2},{"$f":"ROUND(J47*L47/12,2)","v":1426.79},{"$f":"N46+K47+M47","v":384913.80763801554},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q46+P47","v":423339.09155511891}]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2023-02-01",2023,"Q1","2023 Q1",{"$f":"J47+K47","v":377361.43763801554},14140.267840622018,4.7300000000000002E-2,{"$f":"ROUND(J48*L48/12,2)","v":1487.43},400541.50547863753,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},440272.65521732369]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2023-03-01",2023,"Q1","2023 Q1",391501.70547863754,15305.206884800044,4.7300000000000002E-2,1543.17,417389.88236343756,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},457206.21887952846]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2023-04-01",2023,"Q2","2023 Q2",406806.91236343759,15010.975069702114,4.9799999999999997E-2,1688.25,434089.1074331397,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},474139.78254173324]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2023-05-01",2023,"Q2","2023 Q2",421817.88743313972,15223.996064188581,4.9799999999999997E-2,1750.54,451063.64349732827,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},491073.34620393801]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2023-06-01",2023,"Q2",{"$f":"CONCATENATE(G52,\" \",H52)","v":"2023 Q2"},437041.88349732832,15545.904378446523,4.9799999999999997E-2,1813.72,468423.26787577476,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},508006.90986614279]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2023-07-01",2023,"Q3","2023 Q3",452587.78787577484,15980.819002018294,4.9799999999999997E-2,1878.24,486282.32687779306,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},524940.47352834756]
[null,"2025 Q3",3.1600000000000003E-2,4.2299999999999997E-2,null,"2023-08-01",2023,"Q3","2023 Q3",468568.60687779315,15279.369130667157,4.9799999999999997E-2,1944.56,503506.25600846024,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},541874.03719055234]
[null,"2025 Q4",3.1600000000000003E-2,4.2299999999999997E-2,null,"2023-09-01",2023,"Q3","2023 Q3",483847.97600846033,15010.350448267251,4.9799999999999997E-2,2007.97,520524.57645672746,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},558807.60085275711]
[null,"2026 Q1",3.1600000000000003E-2,4.2299999999999997E-2,null,"2023-10-01",2023,"Q4","2023 Q4",498858.32645672758,15388.825884437483,5.4899999999999997E-2,2282.2800000000002,538195.68234116503,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},575741.16451496189]
[null,"2026 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2023-11-01",2023,"Q4","2023 Q4",514247.15234116506,15114.91809691088,5.4899999999999997E-2,2352.6799999999998,555663.28043807601,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},592674.72817716666]
[null,"2026 Q3",3.1600000000000003E-2,4.2299999999999997E-2,null,"2023-12-01",2023,{"$f":"IF(MONTH(F58)=0,\"\",IF(MONTH(F58)<4,\"Q1\",IF(MONTH(F58)<7,\"Q2\",IF(MONTH(F58)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2023 Q4",529362.07043807593,16241.549534937129,5.4899999999999997E-2,2421.83,574326.6599730131,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},609608.29183937144]
[null,"2026 Q4",3.1600000000000003E-2,4.2299999999999997E-2,null,"2024-01-01",{"$f":"YEAR(F59)","v":2024},{"$f":"IF(MONTH(F59)=0,\"\",IF(MONTH(F59)<4,\"Q1\",IF(MONTH(F59)<7,\"Q2\",IF(MONTH(F59)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2024 Q1",{"$f":"J58+K58","v":545603.61997301306},15575.64538941735,{"$f":"VLOOKUP(I59,$B$22:$D$59,2)","v":5.4899999999999997E-2},{"$f":"ROUND(J59*L59/12,2)","v":2496.14},{"$f":"N58+K59+M59","v":592398.44536243042},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q58+P59","v":626541.85550157621}]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",561179.26536243036,14444.551294633586,5.4899999999999997E-2,2567.4,609410.39665706397,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},643475.41916378099]
[null,"Note: 2025-2026 Interest rates are forecasted. ",null,null,null,"2024-03-01",2024,"Q1","2024 Q1",575623.8166570639,15242.508940450783,5.4899999999999997E-2,2633.48,627286.38559751469,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},660408.98282598576]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",590866.32559751463,14790.681876261157,5.4899999999999997E-2,2703.21,644780.27747377579,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},677342.54648819054]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",605657.00747377577,15556.60823251303,5.4899999999999997E-2,2770.88,663107.76570628886,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},694276.11015039531]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",621213.61570628884,15465.920224026417,5.4899999999999997E-2,2842.05,681415.73593031534,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},711209.67381260009]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",636679.53593031527,15855.11958242171,5.1999999999999998E-2,2758.94,700029.79551273701,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},728143.23747480486]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",652534.65551273699,15839.990699394966,5.1999999999999998E-2,2827.65,718697.43621213199,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},745076.80113700964]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",668374.64621213195,15342.435827429768,5.1999999999999998E-2,2896.29,736936.16203956178,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},762010.36479921441]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",683717.0820395617,15132.124034347526,4.3999999999999997E-2,2506.96,754575.24607390922,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},778943.92846141919]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",698849.20607390918,14819.5148030576,4.3999999999999997E-2,2562.4499999999998,771957.21087696683,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},795877.49212362396]
[null,null,null,null,null,"2024-12-01",2024,{"$f":"IF(MONTH(F70)=0,\"\",IF(MONTH(F70)<4,\"Q1\",IF(MONTH(F70)<7,\"Q2\",IF(MONTH(F70)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2024 Q4",713668.72087696684,15557.867509462032,4.3999999999999997E-2,2616.79,790131.86838642892,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},812811.05578582874]
[null,null,null,null,null,"2025-01-01",{"$f":"YEAR(F71)","v":2025},{"$f":"IF(MONTH(F71)=0,\"\",IF(MONTH(F71)<4,\"Q1\",IF(MONTH(F71)<7,\"Q2\",IF(MONTH(F71)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2025 Q1",{"$f":"J70+K70","v":729226.58838642889},15420.646458338033,{"$f":"VLOOKUP(I71,$B$22:$D$59,2)","v":3.6400000000000002E-2},{"$f":"ROUND(J71*L71/12,2)","v":2211.9899999999998},{"$f":"N70+K71+M71","v":807764.50484476693},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q70+P71","v":829744.61944803351}]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",744647.23484476691,14193.255304752985,3.6400000000000002E-2,2258.7600000000002,824216.5201495199,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},846678.18311023829]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",758840.49014951987,15452.120856503601,3.6400000000000002E-2,2301.8200000000002,841970.46100602346,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},863611.74677244306]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",774292.61100602348,15218.030804059646,3.1600000000000003E-2,2038.97,859227.46181008313,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},880545.31043464784]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",789510.64181008318,15590.633081677535,{"$f":"VLOOKUP(I75,$B$22:$D$59,2)","v":3.1600000000000003E-2},2079.04,876897.13489176065,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},897478.87409685261]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",805101.27489176067,15361.115131954795,3.1600000000000003E-2,2120.1,894378.35002371541,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},914412.43775905739]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",820462.39002371544,16019.481359331601,3.1600000000000003E-2,2160.5500000000002,912558.38138304709,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},931346.00142126216]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",836481.87138304708,15856.557035890926,3.1600000000000003E-2,2202.7399999999998,930617.67841893795,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},948279.56508346694]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",852338.42841893795,15246.826213708591,3.1600000000000003E-2,2244.4899999999998,948108.99463264656,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},965213.12874567171]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",867585.25463264657,15458.157475430558,3.1600000000000003E-2,2284.64,965851.79210807709,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},982146.69240787649]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",883043.41210807709,15045.024077905548,3.1600000000000003E-2,2325.35,983222.16618598264,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},999080.25607008126]
[null,null,null,null,null,"2025-12-01",2025,{"$f":"IF(MONTH(F82)=0,\"\",IF(MONTH(F82)<4,\"Q1\",IF(MONTH(F82)<7,\"Q2\",IF(MONTH(F82)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2025 Q4",898088.43618598266,15511.706789170974,3.1600000000000003E-2,2364.9699999999998,1001098.8429751536,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1016013.819732286]
[null,null,null,null,null,"2026-01-01",{"$f":"YEAR(F83)","v":2026},{"$f":"IF(MONTH(F83)=0,\"\",IF(MONTH(F83)<4,\"Q1\",IF(MONTH(F83)<7,\"Q2\",IF(MONTH(F83)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2026 Q1",{"$f":"J82+K82","v":913600.14297515363},15634.755606111394,{"$f":"VLOOKUP(I83,$B$22:$D$59,2)","v":3.1600000000000003E-2},{"$f":"ROUND(J83*L83/12,2)","v":2405.81},{"$f":"N82+K83+M83","v":1019139.408581265},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},{"$f":"Q82+P83","v":1032947.3833944908}]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",929234.89858126501,14631.650756610614,3.1600000000000003E-2,2446.9899999999998,1036218.0493378756,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1049880.9470566956]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",943866.54933787556,15582.444579400664,3.1600000000000003E-2,2485.52,1054286.0139172762,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1066814.5107189002]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",959448.99391727627,15219.865852971821,3.1600000000000003E-2,2526.5500000000002,1072032.429770248,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1083748.0743811049]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",974668.85977024806,15770.027978835727,3.1600000000000003E-2,2566.63,1090369.0877490835,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1100681.6380433096]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",990438.88774908381,15539.864569232175,3.1600000000000003E-2,2608.16,1108517.1123183155,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1117615.2017055142]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",1005978.752318316,16204.243530853477,3.1600000000000003E-2,2649.08,1127370.435849169,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1134548.7653677189]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",1022182.9958491696,16039.083806847299,3.1600000000000003E-2,2691.75,1146101.2696560163,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1151482.3290299235]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",1038222.0796560169,15422.456538887187,3.1600000000000003E-2,2733.98,1164257.7061949035,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1168415.8926921282]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",1053644.536194904,15633.50653918169,3.1600000000000003E-2,2774.6,1182665.8127340851,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1185349.4563543329]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",1069278.0427340856,15216.411236312639,3.1600000000000003E-2,2815.77,1200697.9939703979,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1202283.0200165375]
[null,null,null,null,null,"2026-12-01",2026,{"$f":"IF(MONTH(F94)=0,\"\",IF(MONTH(F94)<4,\"Q1\",IF(MONTH(F94)<7,\"Q2\",IF(MONTH(F94)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2026 Q4",1084494.4539703983,15686.203846880093,{"$f":"VLOOKUP(I94,$B$22:$D$59,2)","v":3.1600000000000003E-2},2855.84,1219240.0378172779,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81/12","v":16933.563662204746},1219216.5836787422]

{"sheet":"8. Opex Interest Annual","index":7,"n_rows":36,"n_cols":14,"rows_kept":36,"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,2021,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I277","v":51770.140153892549},null,{"$f":"D23+F23","v":51770.140153892549},null,{"$f":"(H23)/2","v":25885.070076946275},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C36:C39)","v":5.7000000000000002E-3},null,{"$f":"J23*L23","v":147.54489943859377}]
[null,2022,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!K277","v":51770.140153892549},null,{"$f":"H23+D24+F24","v":103540.2803077851},null,{"$f":"(H24+H23)/2","v":77655.210230838828},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C40:C43)","v":1.915E-2},null,{"$f":"J24*L24","v":1487.0972759205636}]
[null,2023,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!M277","v":51770.140153892549},null,{"$f":"H24+D25+F25","v":155310.42046167766},null,129425.35038473137,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C44:C47)","v":5.0449999999999995E-2},null,{"$f":"J25*L25","v":6529.508926909697}]
[null,2024,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!O277","v":51770.140153892549},null,207080.5606155702,null,181195.49053862394,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C48:C51)","v":5.1449999999999996E-2},null,9322.5079882122009]
[null,2025,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!Q277","v":46772.827208888906},null,253853.38782445912,null,230466.97422001464,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C52:C55)","v":3.2800000000000003E-2},null,7559.3167544164808]
[null,2026,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!S277","v":46772.827208888906},null,300626.21503334801,null,277239.80142890359,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C56:C59)","v":3.1600000000000003E-2},null,{"$f":"J28*L28","v":8760.7777251533553}]
[]
[]
[null,"Cumulative Interest to 2021",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N23)","v":147.54489943859377}]
[null,"Cumulative Interest to 2022",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N24)","v":1634.6421753591574}]
[null,"Cumulative Interest to 2023",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N25)","v":8164.1511022688546}]
[null,"Cumulative Interest to 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N26)","v":17486.659090481055}]
[null,"Cumulative Interest to 2025",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N27)","v":25045.975844897534}]
[null,"Cumulative Interest to 2026",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N28)","v":33806.753570050889}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,21],[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,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,null,{"$f":"'6. ICMIRR_2021 actual'!$F$81","v":203202.76394645695},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81","v":203202.76394645695},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81","v":203202.76394645695},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81","v":203202.76394645695},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81","v":203202.76394645695},null,{"$f":"'6. ICMIRR_2021 actual'!$F$81","v":203202.76394645695},null,{"$f":"SUM(H22:R22)","v":1219216.5836787417}]
[]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,null,{"$f":"'8. Opex Interest Annual'!$N$23","v":147.54489943859377},null,{"$f":"'8. Opex Interest Annual'!$N$24","v":1487.0972759205636},null,{"$f":"'8. Opex Interest Annual'!$N$25","v":6529.508926909697},null,{"$f":"'8. Opex Interest Annual'!$N$26","v":9322.5079882122009},null,{"$f":"'8. Opex Interest Annual'!$N$27","v":7559.3167544164808},null,{"$f":"'8. Opex Interest Annual'!$N$28","v":8760.7777251533553},null,{"$f":"SUM(G24:R24)","v":33806.753570050889}]
[]
[]
[null,null,"ICM Rate Rider Revenues (from Sheet 7)",null,null,null,null,{"$f":"SUM('7. Rate Rider Revs'!K23:K34)","v":179983.89634018613},null,{"$f":"SUM('7. Rate Rider Revs'!K35:K46)","v":181991.31925696376},null,{"$f":"SUM('7. Rate Rider Revs'!K47:K58)","v":183628.40437586312},null,{"$f":"SUM('7. Rate Rider Revs'!K59:K70)","v":183622.96841341592},null,{"$f":"SUM('7. Rate Rider Revs'!K71:K82)","v":184373.55458872477},null,{"$f":"SUM('7. Rate Rider Revs'!K83:K94)","v":186580.5148421248},null,{"$f":"SUM(G27:R27)","v":1100180.6578172785}]
[]
[null,null,"ICM Rate Rider Interest (from Sheet 7)",null,null,null,null,{"$f":"SUM('7. Rate Rider Revs'!M23:M34)","v":460.04},null,{"$f":"SUM('7. Rate Rider Revs'!M35:M46)","v":5665.54},null,{"$f":"SUM('7. Rate Rider Revs'!M47:M58)","v":22597.46},null,{"$f":"SUM('7. Rate Rider Revs'!M59:M70)","v":32182.240000000002},null,{"$f":"SUM('7. Rate Rider Revs'!M71:M82)","v":26593.42},null,{"$f":"SUM('7. Rate Rider Revs'!M83:M94)","v":31560.679999999997},null,{"$f":"SUM(G29:R29)","v":119059.37999999999}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,null,{"$f":"(H22+H24)-(H27+H29)","v":22906.372505709413},null,{"$f":"(J22+J24)-(J27+J29)","v":17033.001965413743},null,{"$f":"(L22+L24)-(L27+L29)","v":3506.4084975035512},null,{"$f":"(N22+N24)-(N27+N29)","v":-3279.9364787467639},null,{"$f":"(P22+P24)-(P27+P29)","v":-204.89388785135816},null,{"$f":"(R22+R24)-(R27+R29)","v":-6177.6531705144735},null,{"$f":"(T22+T24)-(T27+T29)","v":33783.299431514228}]