{"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_2018","7. Rate Rider Revs","8. Opex Interest Annual","9. IRR"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9063,"comments":0,"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],[18,3,18,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algoma Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attawapiskat Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brant County Power"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge and North Dumfries Hydro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. – Eastern Ontario Power/Fort Erie/Port Colborne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLLUS Power Corp."]
[null,null,null,null,null,null,null,null,null,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 - 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,"Enersource Hydro Mississauga Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc."]
[null,null,"Assigned EB Number","EB-2025-0252",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENWIN Utilities Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erie Thames Powerlines Corp."]
[null,null,"Name and Title","Natalie Yeates, Director, Regulatory Affairs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Espanola Regional Hydro Distribution Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essex Powerlines Corporation"]
[null,null,"Phone Number","416-617-1959",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Festival Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Albany Power Corporation"]
[null,null,"Email Address","natalie.yeates@alectrautilities.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Frances Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greater Sudbury Hydro Inc."]
[null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grimsby Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guelph Hydro Electric Systems Inc."]
[null,null,"ICM Project","2018 - Road Authority YRRT ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haldimand County Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halton Hills Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hearst Power Distribution Co. Ltd."]
["Note:  Drop-down lists are shaded blue; Input cells are shaded green."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizon Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro 2000 Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Hawkesbury Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Brampton Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro One Remote Communities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydro Ottawa Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Innisfil Hydro Dist. Systems Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kashechewan Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kenora Hydro Electric Corporation Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kingston Hydro Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kitchener-Wilmot Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakefront Utilities Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lakeland Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"London Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midland Power Utility Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milton Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newmarket – Tay Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara Peninsula Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niagara-on-the-Lake Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norfolk Power Distribution Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Bay Hydro Distribution Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northern Ontario Wires Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakville Hydro Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville Hydro Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orillia Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oshawa PUC Networks Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottawa River Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parry Sound Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peterborough Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PowerStream Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUC Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renfrew Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rideau St. Lawrence Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Thomas Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux Lookout Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thunder Bay Hydro Electricity Distribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillsonburg Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toronto Hydro-Electric System Limited"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veridian Connections Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wasaga Distribution Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterloo North Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Welland Hydro Electric System Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington North Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"West Coast Huron Energy Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westario Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whitby Hydro Electric Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodstock Hydro Services Inc."]
[]
[null,null,null,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":220,"n_cols":11,"rows_kept":220,"cut":false,"hidden":false,"merged":[[166,2,166,3],[168,2,168,3],[170,2,170,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2018,null,null,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"SYSTEM ACCESS",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"}]
[null,null,null,null,"OH Swtch & Cpctrs",null,1428623.6580000005,null,null,null,{"$f":"SUM(G42,I42)","v":1428623.6580000005}]
[]
[null,null,null,null,"Concrete Poles",null,8730477.9100000057,null,null,null,{"$f":"SUM(G44,I44)","v":8730477.9100000057}]
[]
[null,null,null,null,"OH Transformers",null,1587359.6200000006,null,null,null,{"$f":"SUM(G46,I46)","v":1587359.6200000006}]
[]
[null,null,null,null,"OH Prim Cond & Dev",null,2381039.4300000011,null,null,null,{"$f":"SUM(G48,I48)","v":2381039.4300000011}]
[]
[null,null,null,null,"OH Sec Cond & Dev",null,793679.81000000029,null,null,null,{"$f":"SUM(G50,I50)","v":793679.81000000029}]
[]
[null,null,null,null,"UG Prim XLPE TR",null,476207.88600000006,null,null,null,476207.88600000006]
[]
[null,null,null,null,"UG Sec - Dir Buried",null,476207.88600000006,null,null,null,476207.88600000006]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Access",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60)","v":15873596.200000009},null,null,null,{"$f":"SUM(K42,K44,K46,K48,K50,K52,K54,K56,K58,K60)","v":15873596.200000009}]
[]
[null,null,null,null,{"$f":"E40","v":"Asset Type"}]
[null,null,"SYSTEM RENEWAL",null,null,null,{"$f":"G41","v":"Audited Actual"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G66,I66)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G68,I68)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G70,I70)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G72,I72)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G74,I74)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G76,I76)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G78,I78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G80,I80)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G82,I82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Renewal",null,null,null,{"$f":"SUM(G66,G68,G70,G72,G74,G76,G78,G80,G82,G84)","v":0},null,null,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,"SYSTEM SERVICE",null,null,null,{"$f":"G65","v":"Audited Actual"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G90,I90)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G92,I92)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G94,I94)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G96,I96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G98,I98)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G100,I100)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G102,I102)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G104,I104)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G106,I106)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Service",null,null,null,{"$f":"SUM(G90,G92,G94,G96,G98,G100,G102,G104,G106,G108)","v":0},null,null,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,"GENERAL PLANT",null,null,null,"Audited Actual"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G115,I115)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G117,I117)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G119,I119)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G121,I121)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G123,I123)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G125,I125)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G127,I127)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G129,I129)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G131,I131)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total General Plant",null,null,null,{"$f":"SUM(G115,G117,G119,G121,G123,G125,G127,G129,G131,G133)","v":0},null,null,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,null,null,null,null,"Audited Actual"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G140,I140)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G142,I142)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G144,I144)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G146,I146)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G148,I148)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G150,I150)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G152,I152)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G154,I154)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G156,I156)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total ",null,null,null,{"$f":"SUM(G140,G142,G144,G146,G148,G150,G152,G154,G156,G158)","v":0},null,null,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":"G160+G135+G110+G86+G62","v":15873596.200000009},null,null,null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":15873596.200000009}]
[]
[null,null,null,null,{"$f":"E137","v":"Asset Type"}]
[null,null,"OTHER CAPITAL COST",null,null,null,"Audited Actual"]
[]
[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,null,null,{"$f":"SUM(K167,K169,K171)","v":0}]
[]
[null,null,"Total ICM Capital Costs",null,null,null,{"$f":"G162+G173","v":15873596.200000009},null,null,null,{"$f":"K162+K173","v":15873596.200000009}]
[]
[]
[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":1428623.6580000005},null,null,null,{"$f":"SUM(G182:J182)","v":1428623.6580000005}]
[]
[null,null,120223,"Concrete Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":8730477.9100000057},null,null,null,{"$f":"SUM(G184:J184)","v":8730477.9100000057}]
[]
[null,null,120221,"Wood Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D186,G$42:G$171)","v":0},null,null,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":1587359.6200000006},null,null,null,{"$f":"SUM(G188:J188)","v":1587359.6200000006}]
[]
[null,null,120224,"OH Prim Cond & Dev",1835,null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":2381039.4300000011},null,null,null,{"$f":"SUM(G190:J190)","v":2381039.4300000011}]
[]
[null,null,120226,"OH Sec Cond & Dev",1855,null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":793679.81000000029},null,null,null,{"$f":"SUM(G192:J192)","v":793679.81000000029}]
[]
[null,null,120243,"UG Transformers",{"$f":"'3. Cost_of_Service_Parameters'!E57","v":1850},null,{"$f":"SUMIF($E$42:$E$171,$D194,G$42:G$171)","v":0},null,null,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,null,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":476207.88600000006},null,null,null,{"$f":"SUM(G198:J198)","v":476207.88600000006}]
[]
[null,null,"120242.DB","UG Sec - Dir Buried",1845,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":476207.88600000006},null,null,null,{"$f":"SUM(G200:J200)","v":476207.88600000006}]
[]
[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,null,null,0]
[]
[null,null,120248,"Air Insulated Switchgear",1845,null,0,null,null,null,0]
[]
[null,null,120249,"Solid Dielectric Switchgear",1845,null,0,null,null,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,{"$f":"SUMIF($E$42:$E$171,$D212,G$42:G$171)","v":0}]
[]
[null,null,130104,"Capital Contributions Paid ",1609,null,0]
[]
[]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G217)","v":15873596.200000009},null,null,null,{"$f":"SUM(K182:K217)","v":15873596.200000009}]
[null,null,null,null,null,null,{"$f":"IF(G219=G175,\" \",\"Error\")","v":" "},null,null,null,{"$f":"IF(K219=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":"G23-(I22-G22)","v":0.55999999999999994},null,{"$f":"I23-(K22-I22)","v":0.55999999999999994},null,{"$f":"K23-(M22-K22)","v":0.55999999999999994},null,{"$f":"M23-(O22-M22)","v":0.55999999999999994},null,{"$f":"O23-(Q22-O22)","v":0.55999999999999994},null,{"$f":"Q23-(S22-Q22)","v":0.55999999999999994},null,{"$f":"S23-(U22-S22)","v":0.55999999999999994},null,{"$f":"U23-(W22-U22)","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,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(O22:O25,O29:O32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(Q22:Q25,Q29:Q32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(S22:S25,S29:S32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(U22:U25,U29:U32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(W22:W25,W29:W32)","v":5.75660224E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,7.4999999999999997E-2,null,{"$f":"G36","v":7.4999999999999997E-2},null,{"$f":"I36","v":7.4999999999999997E-2},null,{"$f":"K36","v":7.4999999999999997E-2},null,{"$f":"M36","v":7.4999999999999997E-2},null,{"$f":"O36","v":7.4999999999999997E-2},null,{"$f":"Q36","v":7.4999999999999997E-2},null,{"$f":"S36","v":7.4999999999999997E-2},null,{"$f":"U36","v":7.4999999999999997E-2}]
[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,47,null,47,null,47,null,47,null,47,null,47,null,47,null,47]
[null,null,"UG Conduit - 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 Prim XLPE TR - 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 Prim XLPE TR - 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 - 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":357,"n_cols":26,"rows_kept":357,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,null,null,{"$f":"'3. Cost_of_Service_Parameters'!G19","v":2018},null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026]
[null,"Net Fixed Assets - OH Swtch & Cpctrs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I25","v":1428623.6580000005},null,{"$f":"K25","v":1428623.6580000005},null,{"$f":"M25","v":1428623.6580000005},null,{"$f":"O25","v":1428623.6580000005},null,{"$f":"Q25","v":1428623.6580000005},null,{"$f":"S25","v":1428623.6580000005},null,{"$f":"U25","v":1428623.6580000005},null,{"$f":"W25","v":1428623.6580000005}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G182","v":1428623.6580000005},null,{"$f":"'2. ICM_Costs'!I182","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I22+I23-I24","v":1428623.6580000005},null,{"$f":"K22+K23-K24","v":1428623.6580000005},null,{"$f":"M22+M23-M24","v":1428623.6580000005},null,{"$f":"O22+O23-O24","v":1428623.6580000005},null,{"$f":"Q22+Q23-Q24","v":1428623.6580000005},null,{"$f":"S22+S23-S24","v":1428623.6580000005},null,{"$f":"U22+U23-U24","v":1428623.6580000005},null,{"$f":"W22+W23-W24","v":1428623.6580000005},null,{"$f":"Y22+Y23-Y24","v":1428623.6580000005}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":-37595.359421052643},null,{"$f":"K31","v":-75190.718842105285},null,{"$f":"M31","v":-112786.07826315792},null,{"$f":"O31","v":-150381.43768421057},null,{"$f":"Q31","v":-187976.79710526322},null,{"$f":"S31","v":-225572.15652631587},null,{"$f":"U31","v":-263167.51594736852},null,{"$f":"W31","v":-303985.33474736853}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I23/('3. Cost_of_Service_Parameters'!G45)+MIN((I22/'3. Cost_of_Service_Parameters'!G45),(I22+I28)))), 0, -(I23/('3. Cost_of_Service_Parameters'!G45)+MIN((I22/'3. Cost_of_Service_Parameters'!G45),(I22+I28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(K23/('3. Cost_of_Service_Parameters'!I45)+MIN((K22/'3. Cost_of_Service_Parameters'!I45),(K22+K28)))), 0, -(K23/('3. Cost_of_Service_Parameters'!I45)+MIN((K22/'3. Cost_of_Service_Parameters'!I45),(K22+K28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(M23/('3. Cost_of_Service_Parameters'!K45)+MIN((M22/'3. Cost_of_Service_Parameters'!K45),(M22+M28)))), 0, -(M23/('3. Cost_of_Service_Parameters'!K45)+MIN((M22/'3. Cost_of_Service_Parameters'!K45),(M22+M28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(O23/('3. Cost_of_Service_Parameters'!M45)+MIN((O22/'3. Cost_of_Service_Parameters'!M45),(O22+O28)))), 0, -(O23/('3. Cost_of_Service_Parameters'!M45)+MIN((O22/'3. Cost_of_Service_Parameters'!M45),(O22+O28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(Q23/('3. Cost_of_Service_Parameters'!O45)+MIN((Q22/'3. Cost_of_Service_Parameters'!O45),(Q22+Q28)))), 0, -(Q23/('3. Cost_of_Service_Parameters'!O45)+MIN((Q22/'3. Cost_of_Service_Parameters'!O45),(Q22+Q28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(S23/('3. Cost_of_Service_Parameters'!Q45)+MIN((S22/'3. Cost_of_Service_Parameters'!Q45),(S22+S28)))), 0, -(S23/('3. Cost_of_Service_Parameters'!Q45)+MIN((S22/'3. Cost_of_Service_Parameters'!Q45),(S22+S28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(U23/('3. Cost_of_Service_Parameters'!S45)+MIN((U22/'3. Cost_of_Service_Parameters'!S45),(U22+U28)))), 0, -(U23/('3. Cost_of_Service_Parameters'!S45)+MIN((U22/'3. Cost_of_Service_Parameters'!S45),(U22+U28))))","v":-37595.359421052643},null,{"$f":"IF(ISERROR(-(W23/('3. Cost_of_Service_Parameters'!U45)+MIN((W22/'3. Cost_of_Service_Parameters'!U45),(W22+W28)))), 0, -(W23/('3. Cost_of_Service_Parameters'!U45)+MIN((W22/'3. Cost_of_Service_Parameters'!U45),(W22+W28))))","v":-40817.818800000015},null,{"$f":"IF(ISERROR(-(Y23/('3. Cost_of_Service_Parameters'!W45)+MIN((Y22/'3. Cost_of_Service_Parameters'!W45),(Y22+Y28)))), 0, -(Y23/('3. Cost_of_Service_Parameters'!W45)+MIN((Y22/'3. Cost_of_Service_Parameters'!W45),(Y22+Y28))))","v":-40817.818800000015}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":-37595.359421052643},null,{"$f":"K28+K29-K30","v":-75190.718842105285},null,{"$f":"M28+M29-M30","v":-112786.07826315792},null,{"$f":"O28+O29-O30","v":-150381.43768421057},null,{"$f":"Q28+Q29-Q30","v":-187976.79710526322},null,{"$f":"S28+S29-S30","v":-225572.15652631587},null,{"$f":"U28+U29-U30","v":-263167.51594736852},null,{"$f":"W28+W29-W30","v":-303985.33474736853},null,{"$f":"Y28+Y29-Y30","v":-344803.15354736854}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,{"$f":"I35","v":1391028.2985789478},null,{"$f":"K35","v":1353432.9391578953},null,{"$f":"M35","v":1315837.5797368425},null,{"$f":"O35","v":1278242.22031579},null,{"$f":"Q35","v":1240646.8608947373},null,{"$f":"S35","v":1203051.5014736846},null,{"$f":"U35","v":1165456.1420526321},null,{"$f":"W35","v":1124638.323252632}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":1391028.2985789478},null,{"$f":"K25+K31","v":1353432.9391578953},null,{"$f":"M25+M31","v":1315837.5797368425},null,{"$f":"O25+O31","v":1278242.22031579},null,{"$f":"Q25+Q31","v":1240646.8608947373},null,{"$f":"S25+S31","v":1203051.5014736846},null,{"$f":"U25+U31","v":1165456.1420526321},null,{"$f":"W25+W31","v":1124638.323252632},null,{"$f":"Y25+Y31","v":1083820.504452632}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":1391028.2985789478},null,{"$f":"AVERAGE(K34:K35)","v":1372230.6188684215},null,{"$f":"AVERAGE(M34:M35)","v":1334635.2594473688},null,{"$f":"AVERAGE(O34:O35)","v":1297039.9000263163},null,{"$f":"AVERAGE(Q34:Q35)","v":1259444.5406052638},null,{"$f":"AVERAGE(S34:S35)","v":1221849.1811842108},null,{"$f":"AVERAGE(U34:U35)","v":1184253.8217631583},null,{"$f":"AVERAGE(W34:W35)","v":1145047.2326526321},null,{"$f":"AVERAGE(Y34:Y35)","v":1104229.413852632}]
[]
[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":8730477.9100000057},null,{"$f":"K44","v":8730477.9100000057},null,{"$f":"M44","v":8730477.9100000057},null,{"$f":"O44","v":8730477.9100000057},null,{"$f":"Q44","v":8730477.9100000057},null,{"$f":"S44","v":8730477.9100000057},null,{"$f":"U44","v":8730477.9100000057},null,{"$f":"W44","v":8730477.9100000057}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G184","v":8730477.9100000057},null,{"$f":"'2. ICM_Costs'!I184","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I41+I42-I43","v":8730477.9100000057},null,{"$f":"K41+K42-K43","v":8730477.9100000057},null,{"$f":"M41+M42-M43","v":8730477.9100000057},null,{"$f":"O41+O42-O43","v":8730477.9100000057},null,{"$f":"Q41+Q42-Q43","v":8730477.9100000057},null,{"$f":"S41+S42-S43","v":8730477.9100000057},null,{"$f":"U41+U42-U43","v":8730477.9100000057},null,{"$f":"W41+W42-W43","v":8730477.9100000057},null,{"$f":"Y41+Y42-Y43","v":8730477.9100000057}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":-171185.84137254913},null,{"$f":"K50","v":-342371.68274509825},null,{"$f":"M50","v":-513557.52411764738},null,{"$f":"O50","v":-684743.36549019651},null,{"$f":"Q50","v":-855929.20686274557},null,{"$f":"S50","v":-1027115.0482352946},null,{"$f":"U50","v":-1198300.8896078437},null,{"$f":"W50","v":-1343808.8547745105}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47)))), 0, -(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47)))), 0, -(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47)))), 0, -(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(O42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!M47),(O41+O47)))), 0, -(O42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!M47),(O41+O47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(Q42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!O47),(Q41+Q47)))), 0, -(Q42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!O47),(Q41+Q47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(S42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!Q47),(S41+S47)))), 0, -(S42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!Q47),(S41+S47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(U42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!S47),(U41+U47)))), 0, -(U42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!S47),(U41+U47))))","v":-171185.84137254913},null,{"$f":"IF(ISERROR(-(W42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((W41/'3. Cost_of_Service_Parameters'!U47),(W41+W47)))), 0, -(W42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((W41/'3. Cost_of_Service_Parameters'!U47),(W41+W47))))","v":-145507.96516666675},null,{"$f":"IF(ISERROR(-(Y42/('3. Cost_of_Service_Parameters'!W47*2)+MIN((Y41/'3. Cost_of_Service_Parameters'!W47),(Y41+Y47)))), 0, -(Y42/('3. Cost_of_Service_Parameters'!W47*2)+MIN((Y41/'3. Cost_of_Service_Parameters'!W47),(Y41+Y47))))","v":-145507.96516666675}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":-171185.84137254913},null,{"$f":"K47+K48-K49","v":-342371.68274509825},null,{"$f":"M47+M48-M49","v":-513557.52411764738},null,{"$f":"O47+O48-O49","v":-684743.36549019651},null,{"$f":"Q47+Q48-Q49","v":-855929.20686274557},null,{"$f":"S47+S48-S49","v":-1027115.0482352946},null,{"$f":"U47+U48-U49","v":-1198300.8896078437},null,{"$f":"W47+W48-W49","v":-1343808.8547745105},null,{"$f":"Y47+Y48-Y49","v":-1489316.8199411773}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,{"$f":"I54","v":8559292.0686274562},null,{"$f":"K54","v":8388106.2272549076},null,{"$f":"M54","v":8216920.3858823581},null,{"$f":"O54","v":8045734.5445098095},null,{"$f":"Q54","v":7874548.7031372599},null,{"$f":"S54","v":7703362.8617647113},null,{"$f":"U54","v":7532177.0203921618},null,{"$f":"W54","v":7386669.0552254952}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":8559292.0686274562},null,{"$f":"K44+K50","v":8388106.2272549076},null,{"$f":"M44+M50","v":8216920.3858823581},null,{"$f":"O44+O50","v":8045734.5445098095},null,{"$f":"Q44+Q50","v":7874548.7031372599},null,{"$f":"S44+S50","v":7703362.8617647113},null,{"$f":"U44+U50","v":7532177.0203921618},null,{"$f":"W44+W50","v":7386669.0552254952},null,{"$f":"Y44+Y50","v":7241161.0900588287}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":8559292.0686274562},null,{"$f":"AVERAGE(K53:K54)","v":8473699.1479411814},null,{"$f":"AVERAGE(M53:M54)","v":8302513.3065686328},null,{"$f":"AVERAGE(O53:O54)","v":8131327.4651960842},null,{"$f":"AVERAGE(Q53:Q54)","v":7960141.6238235347},null,{"$f":"AVERAGE(S53:S54)","v":7788955.7824509852},null,{"$f":"AVERAGE(U53:U54)","v":7617769.9410784366},null,{"$f":"AVERAGE(W53:W54)","v":7459423.0378088281},null,{"$f":"AVERAGE(Y53:Y54)","v":7313915.0726421624}]
[]
[null,"Net Fixed Assets - Wood Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I63","v":0},null,{"$f":"K63","v":0},null,{"$f":"M63","v":0},null,{"$f":"O63","v":0},null,{"$f":"Q63","v":0},null,{"$f":"S63","v":0},null,{"$f":"U63","v":0},null,{"$f":"W63","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G186","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":0},null,{"$f":"K60+K61-K62","v":0},null,{"$f":"M60+M61-M62","v":0},null,{"$f":"O60+O61-O62","v":0},null,{"$f":"Q60+Q61-Q62","v":0},null,{"$f":"S60+S61-S62","v":0},null,{"$f":"U60+U61-U62","v":0},null,{"$f":"W60+W61-W62","v":0},null,{"$f":"Y60+Y61-Y62","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":0},null,{"$f":"K69","v":0},null,{"$f":"M69","v":0},null,{"$f":"O69","v":0},null,{"$f":"Q69","v":0},null,{"$f":"S69","v":0},null,{"$f":"U69","v":0},null,{"$f":"W69","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I61/('3. Cost_of_Service_Parameters'!G49)+MIN((I60/'3. Cost_of_Service_Parameters'!G49),(I60+I66)))), 0, -(I61/('3. Cost_of_Service_Parameters'!G49)+MIN((I60/'3. Cost_of_Service_Parameters'!G49),(I60+I66))))","v":0},null,{"$f":"IF(ISERROR(-(K61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!I49),(K60+K66)))), 0, -(K61/('3. Cost_of_Service_Parameters'!I49*2)+MIN((K60/'3. Cost_of_Service_Parameters'!I49),(K60+K66))))","v":0},null,{"$f":"IF(ISERROR(-(M61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!K49),(M60+M66)))), 0, -(M61/('3. Cost_of_Service_Parameters'!K49*2)+MIN((M60/'3. Cost_of_Service_Parameters'!K49),(M60+M66))))","v":0},null,{"$f":"IF(ISERROR(-(O61/('3. Cost_of_Service_Parameters'!M49*2)+MIN((O60/'3. Cost_of_Service_Parameters'!M49),(O60+O66)))), 0, -(O61/('3. Cost_of_Service_Parameters'!M49*2)+MIN((O60/'3. Cost_of_Service_Parameters'!M49),(O60+O66))))","v":0},null,{"$f":"IF(ISERROR(-(Q61/('3. Cost_of_Service_Parameters'!O49*2)+MIN((Q60/'3. Cost_of_Service_Parameters'!O49),(Q60+Q66)))), 0, -(Q61/('3. Cost_of_Service_Parameters'!O49*2)+MIN((Q60/'3. Cost_of_Service_Parameters'!O49),(Q60+Q66))))","v":0},null,{"$f":"IF(ISERROR(-(S61/('3. Cost_of_Service_Parameters'!Q49*2)+MIN((S60/'3. Cost_of_Service_Parameters'!Q49),(S60+S66)))), 0, -(S61/('3. Cost_of_Service_Parameters'!Q49*2)+MIN((S60/'3. Cost_of_Service_Parameters'!Q49),(S60+S66))))","v":0},null,{"$f":"IF(ISERROR(-(U61/('3. Cost_of_Service_Parameters'!S49*2)+MIN((U60/'3. Cost_of_Service_Parameters'!S49),(U60+U66)))), 0, -(U61/('3. Cost_of_Service_Parameters'!S49*2)+MIN((U60/'3. Cost_of_Service_Parameters'!S49),(U60+U66))))","v":0},null,{"$f":"IF(ISERROR(-(W61/('3. Cost_of_Service_Parameters'!U49*2)+MIN((W60/'3. Cost_of_Service_Parameters'!U49),(W60+W66)))), 0, -(W61/('3. Cost_of_Service_Parameters'!U49*2)+MIN((W60/'3. Cost_of_Service_Parameters'!U49),(W60+W66))))","v":0},null,{"$f":"IF(ISERROR(-(Y61/('3. Cost_of_Service_Parameters'!W49*2)+MIN((Y60/'3. Cost_of_Service_Parameters'!W49),(Y60+Y66)))), 0, -(Y61/('3. Cost_of_Service_Parameters'!W49*2)+MIN((Y60/'3. Cost_of_Service_Parameters'!W49),(Y60+Y66))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":0},null,{"$f":"K66+K67-K68","v":0},null,{"$f":"M66+M67-M68","v":0},null,{"$f":"O66+O67-O68","v":0},null,{"$f":"Q66+Q67-Q68","v":0},null,{"$f":"S66+S67-S68","v":0},null,{"$f":"U66+U67-U68","v":0},null,{"$f":"W66+W67-W68","v":0},null,{"$f":"Y66+Y67-Y68","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,{"$f":"I73","v":0},null,{"$f":"K73","v":0},null,{"$f":"M73","v":0},null,{"$f":"O73","v":0},null,{"$f":"Q73","v":0},null,{"$f":"S73","v":0},null,{"$f":"U73","v":0},null,{"$f":"W73","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":0},null,{"$f":"K63+K69","v":0},null,{"$f":"M63+M69","v":0},null,{"$f":"O63+O69","v":0},null,{"$f":"Q63+Q69","v":0},null,{"$f":"S63+S69","v":0},null,{"$f":"U63+U69","v":0},null,{"$f":"W63+W69","v":0},null,{"$f":"Y63+Y69","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":0},null,{"$f":"AVERAGE(K72:K73)","v":0},null,{"$f":"AVERAGE(M72:M73)","v":0},null,{"$f":"AVERAGE(O72:O73)","v":0},null,{"$f":"AVERAGE(Q72:Q73)","v":0},null,{"$f":"AVERAGE(S72:S73)","v":0},null,{"$f":"AVERAGE(U72:U73)","v":0},null,{"$f":"AVERAGE(W72:W73)","v":0},null,{"$f":"AVERAGE(Y72:Y73)","v":0}]
[]
[null,"Net Fixed Assets - OH Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I82","v":1587359.6200000006},null,{"$f":"K82","v":1587359.6200000006},null,{"$f":"M82","v":1587359.6200000006},null,{"$f":"O82","v":1587359.6200000006},null,{"$f":"Q82","v":1587359.6200000006},null,{"$f":"S82","v":1587359.6200000006},null,{"$f":"U82","v":1587359.6200000006},null,{"$f":"W82","v":1587359.6200000006}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":1587359.6200000006}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":1587359.6200000006},null,{"$f":"K79+K80-K81","v":1587359.6200000006},null,{"$f":"M79+M80-M81","v":1587359.6200000006},null,{"$f":"O79+O80-O81","v":1587359.6200000006},null,{"$f":"Q79+Q80-Q81","v":1587359.6200000006},null,{"$f":"S79+S80-S81","v":1587359.6200000006},null,{"$f":"U79+U80-U81","v":1587359.6200000006},null,{"$f":"W79+W80-W81","v":1587359.6200000006},null,{"$f":"Y79+Y80-Y81","v":1587359.6200000006}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":-38716.088292682944},null,{"$f":"K88","v":-77432.176585365887},null,{"$f":"M88","v":-116148.26487804882},null,{"$f":"O88","v":-154864.35317073177},null,{"$f":"Q88","v":-193580.44146341473},null,{"$f":"S88","v":-232296.52975609768},null,{"$f":"U88","v":-271012.6180487806},null,{"$f":"W88","v":-306287.27627100283}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I80/('3. Cost_of_Service_Parameters'!G51)+MIN((I79/'3. Cost_of_Service_Parameters'!G51),(I79+I85)))), 0, -(I80/('3. Cost_of_Service_Parameters'!G51)+MIN((I79/'3. Cost_of_Service_Parameters'!G51),(I79+I85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(K80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!I51),(K79+K85)))), 0, -(K80/('3. Cost_of_Service_Parameters'!I51*2)+MIN((K79/'3. Cost_of_Service_Parameters'!I51),(K79+K85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(M80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!K51),(M79+M85)))), 0, -(M80/('3. Cost_of_Service_Parameters'!K51*2)+MIN((M79/'3. Cost_of_Service_Parameters'!K51),(M79+M85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(O80/('3. Cost_of_Service_Parameters'!M51*2)+MIN((O79/'3. Cost_of_Service_Parameters'!M51),(O79+O85)))), 0, -(O80/('3. Cost_of_Service_Parameters'!M51*2)+MIN((O79/'3. Cost_of_Service_Parameters'!M51),(O79+O85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(Q80/('3. Cost_of_Service_Parameters'!O51*2)+MIN((Q79/'3. Cost_of_Service_Parameters'!O51),(Q79+Q85)))), 0, -(Q80/('3. Cost_of_Service_Parameters'!O51*2)+MIN((Q79/'3. Cost_of_Service_Parameters'!O51),(Q79+Q85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(S80/('3. Cost_of_Service_Parameters'!Q51*2)+MIN((S79/'3. Cost_of_Service_Parameters'!Q51),(S79+S85)))), 0, -(S80/('3. Cost_of_Service_Parameters'!Q51*2)+MIN((S79/'3. Cost_of_Service_Parameters'!Q51),(S79+S85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(U80/('3. Cost_of_Service_Parameters'!S51*2)+MIN((U79/'3. Cost_of_Service_Parameters'!S51),(U79+U85)))), 0, -(U80/('3. Cost_of_Service_Parameters'!S51*2)+MIN((U79/'3. Cost_of_Service_Parameters'!S51),(U79+U85))))","v":-38716.088292682944},null,{"$f":"IF(ISERROR(-(W80/('3. Cost_of_Service_Parameters'!U51*2)+MIN((W79/'3. Cost_of_Service_Parameters'!U51),(W79+W85)))), 0, -(W80/('3. Cost_of_Service_Parameters'!U51*2)+MIN((W79/'3. Cost_of_Service_Parameters'!U51),(W79+W85))))","v":-35274.658222222235},null,{"$f":"IF(ISERROR(-(Y80/('3. Cost_of_Service_Parameters'!W51*2)+MIN((Y79/'3. Cost_of_Service_Parameters'!W51),(Y79+Y85)))), 0, -(Y80/('3. Cost_of_Service_Parameters'!W51*2)+MIN((Y79/'3. Cost_of_Service_Parameters'!W51),(Y79+Y85))))","v":-35274.658222222235}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":-38716.088292682944},null,{"$f":"K85+K86-K87","v":-77432.176585365887},null,{"$f":"M85+M86-M87","v":-116148.26487804882},null,{"$f":"O85+O86-O87","v":-154864.35317073177},null,{"$f":"Q85+Q86-Q87","v":-193580.44146341473},null,{"$f":"S85+S86-S87","v":-232296.52975609768},null,{"$f":"U85+U86-U87","v":-271012.6180487806},null,{"$f":"W85+W86-W87","v":-306287.27627100283},null,{"$f":"Y85+Y86-Y87","v":-341561.93449322507}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,{"$f":"I92","v":1548643.5317073176},null,{"$f":"K92","v":1509927.4434146348},null,{"$f":"M92","v":1471211.3551219518},null,{"$f":"O92","v":1432495.2668292688},null,{"$f":"Q92","v":1393779.1785365858},null,{"$f":"S92","v":1355063.090243903},null,{"$f":"U92","v":1316347.00195122},null,{"$f":"W92","v":1281072.3437289977}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":1548643.5317073176},null,{"$f":"K82+K88","v":1509927.4434146348},null,{"$f":"M82+M88","v":1471211.3551219518},null,{"$f":"O82+O88","v":1432495.2668292688},null,{"$f":"Q82+Q88","v":1393779.1785365858},null,{"$f":"S82+S88","v":1355063.090243903},null,{"$f":"U82+U88","v":1316347.00195122},null,{"$f":"W82+W88","v":1281072.3437289977},null,{"$f":"Y82+Y88","v":1245797.6855067755}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":1548643.5317073176},null,{"$f":"AVERAGE(K91:K92)","v":1529285.4875609763},null,{"$f":"AVERAGE(M91:M92)","v":1490569.3992682933},null,{"$f":"AVERAGE(O91:O92)","v":1451853.3109756103},null,{"$f":"AVERAGE(Q91:Q92)","v":1413137.2226829273},null,{"$f":"AVERAGE(S91:S92)","v":1374421.1343902443},null,{"$f":"AVERAGE(U91:U92)","v":1335705.0460975615},null,{"$f":"AVERAGE(W91:W92)","v":1298709.6728401089},null,{"$f":"AVERAGE(Y91:Y92)","v":1263435.0146178866}]
[]
[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":"I101","v":2381039.4300000011},null,{"$f":"K101","v":2381039.4300000011},null,{"$f":"M101","v":2381039.4300000011},null,{"$f":"O101","v":2381039.4300000011},null,{"$f":"Q101","v":2381039.4300000011},null,{"$f":"S101","v":2381039.4300000011},null,{"$f":"U101","v":2381039.4300000011},null,{"$f":"W101","v":2381039.4300000011}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":2381039.4300000011},null,{"$f":"'2. ICM_Costs'!I190","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I98+I99-I100","v":2381039.4300000011},null,{"$f":"K98+K99-K100","v":2381039.4300000011},null,{"$f":"M98+M99-M100","v":2381039.4300000011},null,{"$f":"O98+O99-O100","v":2381039.4300000011},null,{"$f":"Q98+Q99-Q100","v":2381039.4300000011},null,{"$f":"S98+S99-S100","v":2381039.4300000011},null,{"$f":"U98+U99-U100","v":2381039.4300000011},null,{"$f":"W98+W99-W100","v":2381039.4300000011},null,{"$f":"Y98+Y99-Y100","v":2381039.4300000011}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":-52911.98733333336},null,{"$f":"K107","v":-105823.97466666672},null,{"$f":"M107","v":-158735.96200000009},null,{"$f":"O107","v":-211647.94933333344},null,{"$f":"Q107","v":-264559.93666666682},null,{"$f":"S107","v":-317471.92400000017},null,{"$f":"U107","v":-370383.91133333353},null,{"$f":"W107","v":-418004.69993333356}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I99/('3. Cost_of_Service_Parameters'!G53)+MIN((I98/'3. Cost_of_Service_Parameters'!G53),(I98+I104)))), 0, -(I99/('3. Cost_of_Service_Parameters'!G53)+MIN((I98/'3. Cost_of_Service_Parameters'!G53),(I98+I104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(K99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!I53),(K98+K104)))), 0, -(K99/('3. Cost_of_Service_Parameters'!I53*2)+MIN((K98/'3. Cost_of_Service_Parameters'!I53),(K98+K104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(M99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!K53),(M98+M104)))), 0, -(M99/('3. Cost_of_Service_Parameters'!K53*2)+MIN((M98/'3. Cost_of_Service_Parameters'!K53),(M98+M104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(O99/('3. Cost_of_Service_Parameters'!M53*2)+MIN((O98/'3. Cost_of_Service_Parameters'!M53),(O98+O104)))), 0, -(O99/('3. Cost_of_Service_Parameters'!M53*2)+MIN((O98/'3. Cost_of_Service_Parameters'!M53),(O98+O104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(Q99/('3. Cost_of_Service_Parameters'!O53*2)+MIN((Q98/'3. Cost_of_Service_Parameters'!O53),(Q98+Q104)))), 0, -(Q99/('3. Cost_of_Service_Parameters'!O53*2)+MIN((Q98/'3. Cost_of_Service_Parameters'!O53),(Q98+Q104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(S99/('3. Cost_of_Service_Parameters'!Q53*2)+MIN((S98/'3. Cost_of_Service_Parameters'!Q53),(S98+S104)))), 0, -(S99/('3. Cost_of_Service_Parameters'!Q53*2)+MIN((S98/'3. Cost_of_Service_Parameters'!Q53),(S98+S104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(U99/('3. Cost_of_Service_Parameters'!S53*2)+MIN((U98/'3. Cost_of_Service_Parameters'!S53),(U98+U104)))), 0, -(U99/('3. Cost_of_Service_Parameters'!S53*2)+MIN((U98/'3. Cost_of_Service_Parameters'!S53),(U98+U104))))","v":-52911.98733333336},null,{"$f":"IF(ISERROR(-(W99/('3. Cost_of_Service_Parameters'!U53*2)+MIN((W98/'3. Cost_of_Service_Parameters'!U53),(W98+W104)))), 0, -(W99/('3. Cost_of_Service_Parameters'!U53*2)+MIN((W98/'3. Cost_of_Service_Parameters'!U53),(W98+W104))))","v":-47620.788600000022},null,{"$f":"IF(ISERROR(-(Y99/('3. Cost_of_Service_Parameters'!W53*2)+MIN((Y98/'3. Cost_of_Service_Parameters'!W53),(Y98+Y104)))), 0, -(Y99/('3. Cost_of_Service_Parameters'!W53*2)+MIN((Y98/'3. Cost_of_Service_Parameters'!W53),(Y98+Y104))))","v":-47620.788600000022}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":-52911.98733333336},null,{"$f":"K104+K105-K106","v":-105823.97466666672},null,{"$f":"M104+M105-M106","v":-158735.96200000009},null,{"$f":"O104+O105-O106","v":-211647.94933333344},null,{"$f":"Q104+Q105-Q106","v":-264559.93666666682},null,{"$f":"S104+S105-S106","v":-317471.92400000017},null,{"$f":"U104+U105-U106","v":-370383.91133333353},null,{"$f":"W104+W105-W106","v":-418004.69993333356},null,{"$f":"Y104+Y105-Y106","v":-465625.48853333358}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,{"$f":"I111","v":2328127.4426666675},null,{"$f":"K111","v":2275215.4553333344},null,{"$f":"M111","v":2222303.4680000008},null,{"$f":"O111","v":2169391.4806666677},null,{"$f":"Q111","v":2116479.4933333341},null,{"$f":"S111","v":2063567.506000001},null,{"$f":"U111","v":2010655.5186666676},null,{"$f":"W111","v":1963034.7300666675}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":2328127.4426666675},null,{"$f":"K101+K107","v":2275215.4553333344},null,{"$f":"M101+M107","v":2222303.4680000008},null,{"$f":"O101+O107","v":2169391.4806666677},null,{"$f":"Q101+Q107","v":2116479.4933333341},null,{"$f":"S101+S107","v":2063567.506000001},null,{"$f":"U101+U107","v":2010655.5186666676},null,{"$f":"W101+W107","v":1963034.7300666675},null,{"$f":"Y101+Y107","v":1915413.9414666675}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":2328127.4426666675},null,{"$f":"AVERAGE(K110:K111)","v":2301671.449000001},null,{"$f":"AVERAGE(M110:M111)","v":2248759.4616666678},null,{"$f":"AVERAGE(O110:O111)","v":2195847.4743333342},null,{"$f":"AVERAGE(Q110:Q111)","v":2142935.4870000007},null,{"$f":"AVERAGE(S110:S111)","v":2090023.4996666675},null,{"$f":"AVERAGE(U110:U111)","v":2037111.5123333344},null,{"$f":"AVERAGE(W110:W111)","v":1986845.1243666676},null,{"$f":"AVERAGE(Y110:Y111)","v":1939224.3357666675}]
[]
[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":"I120","v":793679.81000000029},null,{"$f":"K120","v":793679.81000000029},null,{"$f":"M120","v":793679.81000000029},null,{"$f":"O120","v":793679.81000000029},null,{"$f":"Q120","v":793679.81000000029},null,{"$f":"S120","v":793679.81000000029},null,{"$f":"U120","v":793679.81000000029},null,{"$f":"W120","v":793679.81000000029}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":793679.81000000029},null,{"$f":"'2. ICM_Costs'!I192","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I117+I118-I119","v":793679.81000000029},null,{"$f":"K117+K118-K119","v":793679.81000000029},null,{"$f":"M117+M118-M119","v":793679.81000000029},null,{"$f":"O117+O118-O119","v":793679.81000000029},null,{"$f":"Q117+Q118-Q119","v":793679.81000000029},null,{"$f":"S117+S118-S119","v":793679.81000000029},null,{"$f":"U117+U118-U119","v":793679.81000000029},null,{"$f":"W117+W118-W119","v":793679.81000000029},null,{"$f":"Y117+Y118-Y119","v":793679.81000000029}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":-16534.996041666673},null,{"$f":"K126","v":-33069.992083333345},null,{"$f":"M126","v":-49604.988125000018},null,{"$f":"O126","v":-66139.984166666691},null,{"$f":"Q126","v":-82674.980208333363},null,{"$f":"S126","v":-99209.976250000036},null,{"$f":"U126","v":-115744.97229166671},null,{"$f":"W126","v":-131618.56849166672}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I118/('3. Cost_of_Service_Parameters'!G55)+MIN((I117/'3. Cost_of_Service_Parameters'!G55),(I117+I123)))), 0, -(I118/('3. Cost_of_Service_Parameters'!G55)+MIN((I117/'3. Cost_of_Service_Parameters'!G55),(I117+I123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(K118/('3. Cost_of_Service_Parameters'!I55*2)+MIN((K117/'3. Cost_of_Service_Parameters'!I55),(K117+K123)))), 0, -(K118/('3. Cost_of_Service_Parameters'!I55*2)+MIN((K117/'3. Cost_of_Service_Parameters'!I55),(K117+K123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(M118/('3. Cost_of_Service_Parameters'!K55*2)+MIN((M117/'3. Cost_of_Service_Parameters'!K55),(M117+M123)))), 0, -(M118/('3. Cost_of_Service_Parameters'!K55*2)+MIN((M117/'3. Cost_of_Service_Parameters'!K55),(M117+M123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(O118/('3. Cost_of_Service_Parameters'!M55*2)+MIN((O117/'3. Cost_of_Service_Parameters'!M55),(O117+O123)))), 0, -(O118/('3. Cost_of_Service_Parameters'!M55*2)+MIN((O117/'3. Cost_of_Service_Parameters'!M55),(O117+O123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(Q118/('3. Cost_of_Service_Parameters'!O55*2)+MIN((Q117/'3. Cost_of_Service_Parameters'!O55),(Q117+Q123)))), 0, -(Q118/('3. Cost_of_Service_Parameters'!O55*2)+MIN((Q117/'3. Cost_of_Service_Parameters'!O55),(Q117+Q123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(S118/('3. Cost_of_Service_Parameters'!Q55*2)+MIN((S117/'3. Cost_of_Service_Parameters'!Q55),(S117+S123)))), 0, -(S118/('3. Cost_of_Service_Parameters'!Q55*2)+MIN((S117/'3. Cost_of_Service_Parameters'!Q55),(S117+S123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(U118/('3. Cost_of_Service_Parameters'!S55*2)+MIN((U117/'3. Cost_of_Service_Parameters'!S55),(U117+U123)))), 0, -(U118/('3. Cost_of_Service_Parameters'!S55*2)+MIN((U117/'3. Cost_of_Service_Parameters'!S55),(U117+U123))))","v":-16534.996041666673},null,{"$f":"IF(ISERROR(-(W118/('3. Cost_of_Service_Parameters'!U55*2)+MIN((W117/'3. Cost_of_Service_Parameters'!U55),(W117+W123)))), 0, -(W118/('3. Cost_of_Service_Parameters'!U55*2)+MIN((W117/'3. Cost_of_Service_Parameters'!U55),(W117+W123))))","v":-15873.596200000005},null,{"$f":"IF(ISERROR(-(Y118/('3. Cost_of_Service_Parameters'!W55*2)+MIN((Y117/'3. Cost_of_Service_Parameters'!W55),(Y117+Y123)))), 0, -(Y118/('3. Cost_of_Service_Parameters'!W55*2)+MIN((Y117/'3. Cost_of_Service_Parameters'!W55),(Y117+Y123))))","v":-15873.596200000005}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":-16534.996041666673},null,{"$f":"K123+K124-K125","v":-33069.992083333345},null,{"$f":"M123+M124-M125","v":-49604.988125000018},null,{"$f":"O123+O124-O125","v":-66139.984166666691},null,{"$f":"Q123+Q124-Q125","v":-82674.980208333363},null,{"$f":"S123+S124-S125","v":-99209.976250000036},null,{"$f":"U123+U124-U125","v":-115744.97229166671},null,{"$f":"W123+W124-W125","v":-131618.56849166672},null,{"$f":"Y123+Y124-Y125","v":-147492.16469166672}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,{"$f":"I130","v":777144.81395833357},null,{"$f":"K130","v":760609.81791666697},null,{"$f":"M130","v":744074.82187500026},null,{"$f":"O130","v":727539.82583333366},null,{"$f":"Q130","v":711004.82979166694},null,{"$f":"S130","v":694469.83375000022},null,{"$f":"U130","v":677934.83770833362},null,{"$f":"W130","v":662061.24150833359}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":777144.81395833357},null,{"$f":"K120+K126","v":760609.81791666697},null,{"$f":"M120+M126","v":744074.82187500026},null,{"$f":"O120+O126","v":727539.82583333366},null,{"$f":"Q120+Q126","v":711004.82979166694},null,{"$f":"S120+S126","v":694469.83375000022},null,{"$f":"U120+U126","v":677934.83770833362},null,{"$f":"W120+W126","v":662061.24150833359},null,{"$f":"Y120+Y126","v":646187.64530833357}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":777144.81395833357},null,{"$f":"AVERAGE(K129:K130)","v":768877.31593750021},null,{"$f":"AVERAGE(M129:M130)","v":752342.31989583361},null,{"$f":"AVERAGE(O129:O130)","v":735807.32385416701},null,{"$f":"AVERAGE(Q129:Q130)","v":719272.3278125003},null,{"$f":"AVERAGE(S129:S130)","v":702737.33177083358},null,{"$f":"AVERAGE(U129:U130)","v":686202.33572916687},null,{"$f":"AVERAGE(W129:W130)","v":669998.03960833361},null,{"$f":"AVERAGE(Y129:Y130)","v":654124.44340833358}]
[]
[null,"Net Fixed Assets - UG Transformers"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I139","v":0},null,{"$f":"K139","v":0},null,{"$f":"M139","v":0},null,{"$f":"O139","v":0},null,{"$f":"Q139","v":0},null,{"$f":"S139","v":0},null,{"$f":"U139","v":0},null,{"$f":"W139","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G194","v":0},null,{"$f":"'2. ICM_Costs'!I194","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I136+I137-I138","v":0},null,{"$f":"K136+K137-K138","v":0},null,{"$f":"M136+M137-M138","v":0},null,{"$f":"O136+O137-O138","v":0},null,{"$f":"Q136+Q137-Q138","v":0},null,{"$f":"S136+S137-S138","v":0},null,{"$f":"U136+U137-U138","v":0},null,{"$f":"W136+W137-W138","v":0},null,{"$f":"Y136+Y137-Y138","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":0},null,{"$f":"K145","v":0},null,{"$f":"M145","v":0},null,{"$f":"O145","v":0},null,{"$f":"Q145","v":0},null,{"$f":"S145","v":0},null,{"$f":"U145","v":0},null,{"$f":"W145","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I137/('3. Cost_of_Service_Parameters'!G57)+MIN((I136/'3. Cost_of_Service_Parameters'!G57),(I136+I142)))), 0, -(I137/('3. Cost_of_Service_Parameters'!G57)+MIN((I136/'3. Cost_of_Service_Parameters'!G57),(I136+I142))))","v":0},null,{"$f":"IF(ISERROR(-(K137/('3. Cost_of_Service_Parameters'!I57*2)+MIN((K136/'3. Cost_of_Service_Parameters'!I57),(K136+K142)))), 0, -(K137/('3. Cost_of_Service_Parameters'!I57*2)+MIN((K136/'3. Cost_of_Service_Parameters'!I57),(K136+K142))))","v":0},null,{"$f":"IF(ISERROR(-(M137/('3. Cost_of_Service_Parameters'!K57*2)+MIN((M136/'3. Cost_of_Service_Parameters'!K57),(M136+M142)))), 0, -(M137/('3. Cost_of_Service_Parameters'!K57*2)+MIN((M136/'3. Cost_of_Service_Parameters'!K57),(M136+M142))))","v":0},null,{"$f":"IF(ISERROR(-(O137/('3. Cost_of_Service_Parameters'!M57*2)+MIN((O136/'3. Cost_of_Service_Parameters'!M57),(O136+O142)))), 0, -(O137/('3. Cost_of_Service_Parameters'!M57*2)+MIN((O136/'3. Cost_of_Service_Parameters'!M57),(O136+O142))))","v":0},null,{"$f":"IF(ISERROR(-(Q137/('3. Cost_of_Service_Parameters'!O57*2)+MIN((Q136/'3. Cost_of_Service_Parameters'!O57),(Q136+Q142)))), 0, -(Q137/('3. Cost_of_Service_Parameters'!O57*2)+MIN((Q136/'3. Cost_of_Service_Parameters'!O57),(Q136+Q142))))","v":0},null,{"$f":"IF(ISERROR(-(S137/('3. Cost_of_Service_Parameters'!Q57*2)+MIN((S136/'3. Cost_of_Service_Parameters'!Q57),(S136+S142)))), 0, -(S137/('3. Cost_of_Service_Parameters'!Q57*2)+MIN((S136/'3. Cost_of_Service_Parameters'!Q57),(S136+S142))))","v":0},null,{"$f":"IF(ISERROR(-(U137/('3. Cost_of_Service_Parameters'!S57*2)+MIN((U136/'3. Cost_of_Service_Parameters'!S57),(U136+U142)))), 0, -(U137/('3. Cost_of_Service_Parameters'!S57*2)+MIN((U136/'3. Cost_of_Service_Parameters'!S57),(U136+U142))))","v":0},null,{"$f":"IF(ISERROR(-(W137/('3. Cost_of_Service_Parameters'!U57*2)+MIN((W136/'3. Cost_of_Service_Parameters'!U57),(W136+W142)))), 0, -(W137/('3. Cost_of_Service_Parameters'!U57*2)+MIN((W136/'3. Cost_of_Service_Parameters'!U57),(W136+W142))))","v":0},null,{"$f":"IF(ISERROR(-(Y137/('3. Cost_of_Service_Parameters'!W57*2)+MIN((Y136/'3. Cost_of_Service_Parameters'!W57),(Y136+Y142)))), 0, -(Y137/('3. Cost_of_Service_Parameters'!W57*2)+MIN((Y136/'3. Cost_of_Service_Parameters'!W57),(Y136+Y142))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":0},null,{"$f":"K142+K143-K144","v":0},null,{"$f":"M142+M143-M144","v":0},null,{"$f":"O142+O143-O144","v":0},null,{"$f":"Q142+Q143-Q144","v":0},null,{"$f":"S142+S143-S144","v":0},null,{"$f":"U142+U143-U144","v":0},null,{"$f":"W142+W143-W144","v":0},null,{"$f":"Y142+Y143-Y144","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,{"$f":"I149","v":0},null,{"$f":"K149","v":0},null,{"$f":"M149","v":0},null,{"$f":"O149","v":0},null,{"$f":"Q149","v":0},null,{"$f":"S149","v":0},null,{"$f":"U149","v":0},null,{"$f":"W149","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":0},null,{"$f":"K139+K145","v":0},null,{"$f":"M139+M145","v":0},null,{"$f":"O139+O145","v":0},null,{"$f":"Q139+Q145","v":0},null,{"$f":"S139+S145","v":0},null,{"$f":"U139+U145","v":0},null,{"$f":"W139+W145","v":0},null,{"$f":"Y139+Y145","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":0},null,{"$f":"AVERAGE(K148:K149)","v":0},null,{"$f":"AVERAGE(M148:M149)","v":0},null,{"$f":"AVERAGE(O148:O149)","v":0},null,{"$f":"AVERAGE(Q148:Q149)","v":0},null,{"$f":"AVERAGE(S148:S149)","v":0},null,{"$f":"AVERAGE(U148:U149)","v":0},null,{"$f":"AVERAGE(W148:W149)","v":0},null,{"$f":"AVERAGE(Y148:Y149)","v":0}]
[]
[null,"Net Fixed Assets - UG Conduit"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I158","v":0},null,{"$f":"K158","v":0},null,{"$f":"M158","v":0},null,{"$f":"O158","v":0},null,{"$f":"Q158","v":0},null,{"$f":"S158","v":0},null,{"$f":"U158","v":0},null,{"$f":"W158","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G196","v":0},null,{"$f":"'2. ICM_Costs'!I196","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I155+I156-I157","v":0},null,{"$f":"K155+K156-K157","v":0},null,{"$f":"M155+M156-M157","v":0},null,{"$f":"O155+O156-O157","v":0},null,{"$f":"Q155+Q156-Q157","v":0},null,{"$f":"S155+S156-S157","v":0},null,{"$f":"U155+U156-U157","v":0},null,{"$f":"W155+W156-W157","v":0},null,{"$f":"Y155+Y156-Y157","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I164","v":0},null,{"$f":"K164","v":0},null,{"$f":"M164","v":0},null,{"$f":"O164","v":0},null,{"$f":"Q164","v":0},null,{"$f":"S164","v":0},null,{"$f":"U164","v":0},null,{"$f":"W164","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I156/('3. Cost_of_Service_Parameters'!G59)+MIN((I155/'3. Cost_of_Service_Parameters'!G59),(I155+I161)))), 0, -(I156/('3. Cost_of_Service_Parameters'!G59)+MIN((I155/'3. Cost_of_Service_Parameters'!G59),(I155+I161))))","v":0},null,{"$f":"IF(ISERROR(-(K156/('3. Cost_of_Service_Parameters'!I59*2)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161)))), 0, -(K156/('3. Cost_of_Service_Parameters'!I59*2)+MIN((K155/'3. Cost_of_Service_Parameters'!I59),(K155+K161))))","v":0},null,{"$f":"IF(ISERROR(-(M156/('3. Cost_of_Service_Parameters'!K59*2)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161)))), 0, -(M156/('3. Cost_of_Service_Parameters'!K59*2)+MIN((M155/'3. Cost_of_Service_Parameters'!K59),(M155+M161))))","v":0},null,{"$f":"IF(ISERROR(-(O156/('3. Cost_of_Service_Parameters'!M59*2)+MIN((O155/'3. Cost_of_Service_Parameters'!M59),(O155+O161)))), 0, -(O156/('3. Cost_of_Service_Parameters'!M59*2)+MIN((O155/'3. Cost_of_Service_Parameters'!M59),(O155+O161))))","v":0},null,{"$f":"IF(ISERROR(-(Q156/('3. Cost_of_Service_Parameters'!O59*2)+MIN((Q155/'3. Cost_of_Service_Parameters'!O59),(Q155+Q161)))), 0, -(Q156/('3. Cost_of_Service_Parameters'!O59*2)+MIN((Q155/'3. Cost_of_Service_Parameters'!O59),(Q155+Q161))))","v":0},null,{"$f":"IF(ISERROR(-(S156/('3. Cost_of_Service_Parameters'!Q59*2)+MIN((S155/'3. Cost_of_Service_Parameters'!Q59),(S155+S161)))), 0, -(S156/('3. Cost_of_Service_Parameters'!Q59*2)+MIN((S155/'3. Cost_of_Service_Parameters'!Q59),(S155+S161))))","v":0},null,{"$f":"IF(ISERROR(-(U156/('3. Cost_of_Service_Parameters'!S59*2)+MIN((U155/'3. Cost_of_Service_Parameters'!S59),(U155+U161)))), 0, -(U156/('3. Cost_of_Service_Parameters'!S59*2)+MIN((U155/'3. Cost_of_Service_Parameters'!S59),(U155+U161))))","v":0},null,{"$f":"IF(ISERROR(-(W156/('3. Cost_of_Service_Parameters'!U59*2)+MIN((W155/'3. Cost_of_Service_Parameters'!U59),(W155+W161)))), 0, -(W156/('3. Cost_of_Service_Parameters'!U59*2)+MIN((W155/'3. Cost_of_Service_Parameters'!U59),(W155+W161))))","v":0},null,{"$f":"IF(ISERROR(-(Y156/('3. Cost_of_Service_Parameters'!W59*2)+MIN((Y155/'3. Cost_of_Service_Parameters'!W59),(Y155+Y161)))), 0, -(Y156/('3. Cost_of_Service_Parameters'!W59*2)+MIN((Y155/'3. Cost_of_Service_Parameters'!W59),(Y155+Y161))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I161+I162-I163","v":0},null,{"$f":"K161+K162-K163","v":0},null,{"$f":"M161+M162-M163","v":0},null,{"$f":"O161+O162-O163","v":0},null,{"$f":"Q161+Q162-Q163","v":0},null,{"$f":"S161+S162-S163","v":0},null,{"$f":"U161+U162-U163","v":0},null,{"$f":"W161+W162-W163","v":0},null,{"$f":"Y161+Y162-Y163","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I155+I161","v":0},null,{"$f":"I168","v":0},null,{"$f":"K168","v":0},null,{"$f":"M168","v":0},null,{"$f":"O168","v":0},null,{"$f":"Q168","v":0},null,{"$f":"S168","v":0},null,{"$f":"U168","v":0},null,{"$f":"W168","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I158+I164","v":0},null,{"$f":"K158+K164","v":0},null,{"$f":"M158+M164","v":0},null,{"$f":"O158+O164","v":0},null,{"$f":"Q158+Q164","v":0},null,{"$f":"S158+S164","v":0},null,{"$f":"U158+U164","v":0},null,{"$f":"W158+W164","v":0},null,{"$f":"Y158+Y164","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I168","v":0},null,{"$f":"AVERAGE(K167:K168)","v":0},null,{"$f":"AVERAGE(M167:M168)","v":0},null,{"$f":"AVERAGE(O167:O168)","v":0},null,{"$f":"AVERAGE(Q167:Q168)","v":0},null,{"$f":"AVERAGE(S167:S168)","v":0},null,{"$f":"AVERAGE(U167:U168)","v":0},null,{"$f":"AVERAGE(W167:W168)","v":0},null,{"$f":"AVERAGE(Y167:Y168)","v":0}]
[]
[null,"Net Fixed Assets - UG Prim XLPE TR"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I177","v":476207.88600000006},null,{"$f":"K177","v":476207.88600000006},null,{"$f":"M177","v":476207.88600000006},null,{"$f":"O177","v":476207.88600000006},null,{"$f":"Q177","v":476207.88600000006},null,{"$f":"S177","v":476207.88600000006},null,{"$f":"U177","v":476207.88600000006},null,{"$f":"W177","v":476207.88600000006}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":476207.88600000006},null,{"$f":"'2. ICM_Costs'!I198","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I174+I175-I176","v":476207.88600000006},null,{"$f":"K174+K175-K176","v":476207.88600000006},null,{"$f":"M174+M175-M176","v":476207.88600000006},null,{"$f":"O174+O175-O176","v":476207.88600000006},null,{"$f":"Q174+Q175-Q176","v":476207.88600000006},null,{"$f":"S174+S175-S176","v":476207.88600000006},null,{"$f":"U174+U175-U176","v":476207.88600000006},null,{"$f":"W174+W175-W176","v":476207.88600000006},null,{"$f":"Y174+Y175-Y176","v":476207.88600000006}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I183","v":-12531.786473684211},null,{"$f":"K183","v":-25063.572947368422},null,{"$f":"M183","v":-37595.359421052635},null,{"$f":"O183","v":-50127.145894736845},null,{"$f":"Q183","v":-62658.932368421054},null,{"$f":"S183","v":-75190.718842105271},null,{"$f":"U183","v":-87722.505315789487},null,{"$f":"W183","v":-98304.902782456149}]
[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":-12531.786473684211},null,{"$f":"IF(ISERROR(-(K175/('3. Cost_of_Service_Parameters'!I61*2)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180)))), 0, -(K175/('3. Cost_of_Service_Parameters'!I61*2)+MIN((K174/'3. Cost_of_Service_Parameters'!I61),(K174+K180))))","v":-12531.786473684211},null,{"$f":"IF(ISERROR(-(M175/('3. Cost_of_Service_Parameters'!K61*2)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180)))), 0, -(M175/('3. Cost_of_Service_Parameters'!K61*2)+MIN((M174/'3. Cost_of_Service_Parameters'!K61),(M174+M180))))","v":-12531.786473684211},null,{"$f":"IF(ISERROR(-(O175/('3. Cost_of_Service_Parameters'!M61*2)+MIN((O174/'3. Cost_of_Service_Parameters'!M61),(O174+O180)))), 0, -(O175/('3. Cost_of_Service_Parameters'!M61*2)+MIN((O174/'3. Cost_of_Service_Parameters'!M61),(O174+O180))))","v":-12531.786473684211},null,{"$f":"IF(ISERROR(-(Q175/('3. Cost_of_Service_Parameters'!O61*2)+MIN((Q174/'3. Cost_of_Service_Parameters'!O61),(Q174+Q180)))), 0, -(Q175/('3. Cost_of_Service_Parameters'!O61*2)+MIN((Q174/'3. Cost_of_Service_Parameters'!O61),(Q174+Q180))))","v":-12531.786473684211},null,{"$f":"IF(ISERROR(-(S175/('3. Cost_of_Service_Parameters'!Q61*2)+MIN((S174/'3. Cost_of_Service_Parameters'!Q61),(S174+S180)))), 0, -(S175/('3. Cost_of_Service_Parameters'!Q61*2)+MIN((S174/'3. Cost_of_Service_Parameters'!Q61),(S174+S180))))","v":-12531.786473684211},null,{"$f":"IF(ISERROR(-(U175/('3. Cost_of_Service_Parameters'!S61*2)+MIN((U174/'3. Cost_of_Service_Parameters'!S61),(U174+U180)))), 0, -(U175/('3. Cost_of_Service_Parameters'!S61*2)+MIN((U174/'3. Cost_of_Service_Parameters'!S61),(U174+U180))))","v":-12531.786473684211},null,{"$f":"IF(ISERROR(-(W175/('3. Cost_of_Service_Parameters'!U61*2)+MIN((W174/'3. Cost_of_Service_Parameters'!U61),(W174+W180)))), 0, -(W175/('3. Cost_of_Service_Parameters'!U61*2)+MIN((W174/'3. Cost_of_Service_Parameters'!U61),(W174+W180))))","v":-10582.397466666667},null,{"$f":"IF(ISERROR(-(Y175/('3. Cost_of_Service_Parameters'!W61*2)+MIN((Y174/'3. Cost_of_Service_Parameters'!W61),(Y174+Y180)))), 0, -(Y175/('3. Cost_of_Service_Parameters'!W61*2)+MIN((Y174/'3. Cost_of_Service_Parameters'!W61),(Y174+Y180))))","v":-10582.397466666667}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I180+I181-I182","v":-12531.786473684211},null,{"$f":"K180+K181-K182","v":-25063.572947368422},null,{"$f":"M180+M181-M182","v":-37595.359421052635},null,{"$f":"O180+O181-O182","v":-50127.145894736845},null,{"$f":"Q180+Q181-Q182","v":-62658.932368421054},null,{"$f":"S180+S181-S182","v":-75190.718842105271},null,{"$f":"U180+U181-U182","v":-87722.505315789487},null,{"$f":"W180+W181-W182","v":-98304.902782456149},null,{"$f":"Y180+Y181-Y182","v":-108887.30024912281}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,{"$f":"I187","v":463676.09952631587},null,{"$f":"K187","v":451144.31305263162},null,{"$f":"M187","v":438612.52657894744},null,{"$f":"O187","v":426080.74010526319},null,{"$f":"Q187","v":413548.953631579},null,{"$f":"S187","v":401017.16715789482},null,{"$f":"U187","v":388485.38068421057},null,{"$f":"W187","v":377902.98321754392}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I177+I183","v":463676.09952631587},null,{"$f":"K177+K183","v":451144.31305263162},null,{"$f":"M177+M183","v":438612.52657894744},null,{"$f":"O177+O183","v":426080.74010526319},null,{"$f":"Q177+Q183","v":413548.953631579},null,{"$f":"S177+S183","v":401017.16715789482},null,{"$f":"U177+U183","v":388485.38068421057},null,{"$f":"W177+W183","v":377902.98321754392},null,{"$f":"Y177+Y183","v":367320.58575087728}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I187","v":463676.09952631587},null,{"$f":"AVERAGE(K186:K187)","v":457410.20628947375},null,{"$f":"AVERAGE(M186:M187)","v":444878.41981578956},null,{"$f":"AVERAGE(O186:O187)","v":432346.63334210531},null,{"$f":"AVERAGE(Q186:Q187)","v":419814.84686842107},null,{"$f":"AVERAGE(S186:S187)","v":407283.06039473694},null,{"$f":"AVERAGE(U186:U187)","v":394751.27392105269},null,{"$f":"AVERAGE(W186:W187)","v":383194.18195087725},null,{"$f":"AVERAGE(Y186:Y187)","v":372611.7844842106}]
[]
[]
[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":"I197","v":476207.88600000006},null,{"$f":"K197","v":476207.88600000006},null,{"$f":"M197","v":476207.88600000006},null,{"$f":"O197","v":476207.88600000006},null,{"$f":"Q197","v":476207.88600000006},null,{"$f":"S197","v":476207.88600000006},null,{"$f":"U197","v":476207.88600000006},null,{"$f":"W197","v":476207.88600000006}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":476207.88600000006},null,{"$f":"'2. ICM_Costs'!I226","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I194+I195-I196","v":476207.88600000006},null,{"$f":"K194+K195-K196","v":476207.88600000006},null,{"$f":"M194+M195-M196","v":476207.88600000006},null,{"$f":"O194+O195-O196","v":476207.88600000006},null,{"$f":"Q194+Q195-Q196","v":476207.88600000006},null,{"$f":"S194+S195-S196","v":476207.88600000006},null,{"$f":"U194+U195-U196","v":476207.88600000006},null,{"$f":"W194+W195-W196","v":476207.88600000006},null,{"$f":"Y194+Y195-Y196","v":476207.88600000006}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I203","v":-15361.544709677421},null,{"$f":"K203","v":-30723.089419354841},null,{"$f":"M203","v":-46084.63412903226},null,{"$f":"O203","v":-61446.178838709682},null,{"$f":"Q203","v":-76807.723548387105},null,{"$f":"S203","v":-92169.26825806452},null,{"$f":"U203","v":-107530.81296774193},null,{"$f":"W203","v":-123404.40916774193}]
[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":-15361.544709677421},null,{"$f":"IF(ISERROR(-(K195/('3. Cost_of_Service_Parameters'!I63*2)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200)))), 0, -(K195/('3. Cost_of_Service_Parameters'!I63*2)+MIN((K194/'3. Cost_of_Service_Parameters'!I63),(K194+K200))))","v":-15361.544709677421},null,{"$f":"IF(ISERROR(-(M195/('3. Cost_of_Service_Parameters'!K63*2)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200)))), 0, -(M195/('3. Cost_of_Service_Parameters'!K63*2)+MIN((M194/'3. Cost_of_Service_Parameters'!K63),(M194+M200))))","v":-15361.544709677421},null,{"$f":"IF(ISERROR(-(O195/('3. Cost_of_Service_Parameters'!M63*2)+MIN((O194/'3. Cost_of_Service_Parameters'!M63),(O194+O200)))), 0, -(O195/('3. Cost_of_Service_Parameters'!M63*2)+MIN((O194/'3. Cost_of_Service_Parameters'!M63),(O194+O200))))","v":-15361.544709677421},null,{"$f":"IF(ISERROR(-(Q195/('3. Cost_of_Service_Parameters'!O63*2)+MIN((Q194/'3. Cost_of_Service_Parameters'!O63),(Q194+Q200)))), 0, -(Q195/('3. Cost_of_Service_Parameters'!O63*2)+MIN((Q194/'3. Cost_of_Service_Parameters'!O63),(Q194+Q200))))","v":-15361.544709677421},null,{"$f":"IF(ISERROR(-(S195/('3. Cost_of_Service_Parameters'!Q63*2)+MIN((S194/'3. Cost_of_Service_Parameters'!Q63),(S194+S200)))), 0, -(S195/('3. Cost_of_Service_Parameters'!Q63*2)+MIN((S194/'3. Cost_of_Service_Parameters'!Q63),(S194+S200))))","v":-15361.544709677421},null,{"$f":"IF(ISERROR(-(U195/('3. Cost_of_Service_Parameters'!S63*2)+MIN((U194/'3. Cost_of_Service_Parameters'!S63),(U194+U200)))), 0, -(U195/('3. Cost_of_Service_Parameters'!S63*2)+MIN((U194/'3. Cost_of_Service_Parameters'!S63),(U194+U200))))","v":-15361.544709677421},null,{"$f":"IF(ISERROR(-(W195/('3. Cost_of_Service_Parameters'!U63*2)+MIN((W194/'3. Cost_of_Service_Parameters'!U63),(W194+W200)))), 0, -(W195/('3. Cost_of_Service_Parameters'!U63*2)+MIN((W194/'3. Cost_of_Service_Parameters'!U63),(W194+W200))))","v":-15873.596200000002},null,{"$f":"IF(ISERROR(-(Y195/('3. Cost_of_Service_Parameters'!W63*2)+MIN((Y194/'3. Cost_of_Service_Parameters'!W63),(Y194+Y200)))), 0, -(Y195/('3. Cost_of_Service_Parameters'!W63*2)+MIN((Y194/'3. Cost_of_Service_Parameters'!W63),(Y194+Y200))))","v":-15873.596200000002}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I200+I201-I202","v":-15361.544709677421},null,{"$f":"K200+K201-K202","v":-30723.089419354841},null,{"$f":"M200+M201-M202","v":-46084.63412903226},null,{"$f":"O200+O201-O202","v":-61446.178838709682},null,{"$f":"Q200+Q201-Q202","v":-76807.723548387105},null,{"$f":"S200+S201-S202","v":-92169.26825806452},null,{"$f":"U200+U201-U202","v":-107530.81296774193},null,{"$f":"W200+W201-W202","v":-123404.40916774193},null,{"$f":"Y200+Y201-Y202","v":-139278.00536774195}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,{"$f":"I207","v":460846.34129032266},null,{"$f":"K207","v":445484.7965806452},null,{"$f":"M207","v":430123.2518709678},null,{"$f":"O207","v":414761.7071612904},null,{"$f":"Q207","v":399400.16245161294},null,{"$f":"S207","v":384038.61774193554},null,{"$f":"U207","v":368677.07303225814},null,{"$f":"W207","v":352803.47683225811}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I197+I203","v":460846.34129032266},null,{"$f":"K197+K203","v":445484.7965806452},null,{"$f":"M197+M203","v":430123.2518709678},null,{"$f":"O197+O203","v":414761.7071612904},null,{"$f":"Q197+Q203","v":399400.16245161294},null,{"$f":"S197+S203","v":384038.61774193554},null,{"$f":"U197+U203","v":368677.07303225814},null,{"$f":"W197+W203","v":352803.47683225811},null,{"$f":"Y197+Y203","v":336929.88063225814}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I207","v":460846.34129032266},null,{"$f":"AVERAGE(K206:K207)","v":453165.56893548393},null,{"$f":"AVERAGE(M206:M207)","v":437804.02422580647},null,{"$f":"AVERAGE(O206:O207)","v":422442.47951612913},null,{"$f":"AVERAGE(Q206:Q207)","v":407080.93480645167},null,{"$f":"AVERAGE(S206:S207)","v":391719.39009677421},null,{"$f":"AVERAGE(U206:U207)","v":376357.84538709687},null,{"$f":"AVERAGE(W206:W207)","v":360740.27493225812},null,{"$f":"AVERAGE(Y206:Y207)","v":344866.67873225815}]
[]
[]
[null,"Net Fixed Assets - UG Sec In Duct/Svs"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I217","v":0},null,{"$f":"K217","v":0},null,{"$f":"M217","v":0},null,{"$f":"O217","v":0},null,{"$f":"Q217","v":0},null,{"$f":"S217","v":0},null,{"$f":"U217","v":0},null,{"$f":"W217","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":0},null,{"$f":"'2. ICM_Costs'!I246","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I214+I215-I216","v":0},null,{"$f":"K214+K215-K216","v":0},null,{"$f":"M214+M215-M216","v":0},null,{"$f":"O214+O215-O216","v":0},null,{"$f":"Q214+Q215-Q216","v":0},null,{"$f":"S214+S215-S216","v":0},null,{"$f":"U214+U215-U216","v":0},null,{"$f":"W214+W215-W216","v":0},null,{"$f":"Y214+Y215-Y216","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I223","v":0},null,{"$f":"K223","v":0},null,{"$f":"M223","v":0},null,{"$f":"O223","v":0},null,{"$f":"Q223","v":0},null,{"$f":"S223","v":0},null,{"$f":"U223","v":0},null,{"$f":"W223","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I215/('3. Cost_of_Service_Parameters'!G65)+MIN((I214/'3. Cost_of_Service_Parameters'!G65),(I214+I220)))), 0, -(I215/('3. Cost_of_Service_Parameters'!G65)+MIN((I214/'3. Cost_of_Service_Parameters'!G65),(I214+I220))))","v":0},null,{"$f":"IF(ISERROR(-(K215/('3. Cost_of_Service_Parameters'!I65*2)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220)))), 0, -(K215/('3. Cost_of_Service_Parameters'!I65*2)+MIN((K214/'3. Cost_of_Service_Parameters'!I65),(K214+K220))))","v":0},null,{"$f":"IF(ISERROR(-(M215/('3. Cost_of_Service_Parameters'!K65*2)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220)))), 0, -(M215/('3. Cost_of_Service_Parameters'!K65*2)+MIN((M214/'3. Cost_of_Service_Parameters'!K65),(M214+M220))))","v":0},null,{"$f":"IF(ISERROR(-(O215/('3. Cost_of_Service_Parameters'!M65*2)+MIN((O214/'3. Cost_of_Service_Parameters'!M65),(O214+O220)))), 0, -(O215/('3. Cost_of_Service_Parameters'!M65*2)+MIN((O214/'3. Cost_of_Service_Parameters'!M65),(O214+O220))))","v":0},null,{"$f":"IF(ISERROR(-(Q215/('3. Cost_of_Service_Parameters'!O65*2)+MIN((Q214/'3. Cost_of_Service_Parameters'!O65),(Q214+Q220)))), 0, -(Q215/('3. Cost_of_Service_Parameters'!O65*2)+MIN((Q214/'3. Cost_of_Service_Parameters'!O65),(Q214+Q220))))","v":0},null,{"$f":"IF(ISERROR(-(S215/('3. Cost_of_Service_Parameters'!Q65*2)+MIN((S214/'3. Cost_of_Service_Parameters'!Q65),(S214+S220)))), 0, -(S215/('3. Cost_of_Service_Parameters'!Q65*2)+MIN((S214/'3. Cost_of_Service_Parameters'!Q65),(S214+S220))))","v":0},null,{"$f":"IF(ISERROR(-(U215/('3. Cost_of_Service_Parameters'!S65*2)+MIN((U214/'3. Cost_of_Service_Parameters'!S65),(U214+U220)))), 0, -(U215/('3. Cost_of_Service_Parameters'!S65*2)+MIN((U214/'3. Cost_of_Service_Parameters'!S65),(U214+U220))))","v":0},null,{"$f":"IF(ISERROR(-(W215/('3. Cost_of_Service_Parameters'!U65*2)+MIN((W214/'3. Cost_of_Service_Parameters'!U65),(W214+W220)))), 0, -(W215/('3. Cost_of_Service_Parameters'!U65*2)+MIN((W214/'3. Cost_of_Service_Parameters'!U65),(W214+W220))))","v":0},null,{"$f":"IF(ISERROR(-(Y215/('3. Cost_of_Service_Parameters'!W65*2)+MIN((Y214/'3. Cost_of_Service_Parameters'!W65),(Y214+Y220)))), 0, -(Y215/('3. Cost_of_Service_Parameters'!W65*2)+MIN((Y214/'3. Cost_of_Service_Parameters'!W65),(Y214+Y220))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I220+I221-I222","v":0},null,{"$f":"K220+K221-K222","v":0},null,{"$f":"M220+M221-M222","v":0},null,{"$f":"O220+O221-O222","v":0},null,{"$f":"Q220+Q221-Q222","v":0},null,{"$f":"S220+S221-S222","v":0},null,{"$f":"U220+U221-U222","v":0},null,{"$f":"W220+W221-W222","v":0},null,{"$f":"Y220+Y221-Y222","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,{"$f":"I227","v":0},null,{"$f":"K227","v":0},null,{"$f":"M227","v":0},null,{"$f":"O227","v":0},null,{"$f":"Q227","v":0},null,{"$f":"S227","v":0},null,{"$f":"U227","v":0},null,{"$f":"W227","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I217+I223","v":0},null,{"$f":"K217+K223","v":0},null,{"$f":"M217+M223","v":0},null,{"$f":"O217+O223","v":0},null,{"$f":"Q217+Q223","v":0},null,{"$f":"S217+S223","v":0},null,{"$f":"U217+U223","v":0},null,{"$f":"W217+W223","v":0},null,{"$f":"Y217+Y223","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I227","v":0},null,{"$f":"AVERAGE(K226:K227)","v":0},null,{"$f":"AVERAGE(M226:M227)","v":0},null,{"$f":"AVERAGE(O226:O227)","v":0},null,{"$f":"AVERAGE(Q226:Q227)","v":0},null,{"$f":"AVERAGE(S226:S227)","v":0},null,{"$f":"AVERAGE(U226:U227)","v":0},null,{"$f":"AVERAGE(W226:W227)","v":0},null,{"$f":"AVERAGE(Y226:Y227)","v":0}]
[]
[]
[null,"Net Fixed Assets - Air Insulated Switchgear"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I237","v":0},null,{"$f":"K237","v":0},null,{"$f":"M237","v":0},null,{"$f":"O237","v":0},null,{"$f":"Q237","v":0},null,{"$f":"S237","v":0},null,{"$f":"U237","v":0},null,{"$f":"W237","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":0},null,{"$f":"'2. ICM_Costs'!I266","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I234+I235-I236","v":0},null,{"$f":"K234+K235-K236","v":0},null,{"$f":"M234+M235-M236","v":0},null,{"$f":"O234+O235-O236","v":0},null,{"$f":"Q234+Q235-Q236","v":0},null,{"$f":"S234+S235-S236","v":0},null,{"$f":"U234+U235-U236","v":0},null,{"$f":"W234+W235-W236","v":0},null,{"$f":"Y234+Y235-Y236","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I243","v":0},null,{"$f":"K243","v":0},null,{"$f":"M243","v":0},null,{"$f":"O243","v":0},null,{"$f":"Q243","v":0},null,{"$f":"S243","v":0},null,{"$f":"U243","v":0},null,{"$f":"W243","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I235/('3. Cost_of_Service_Parameters'!G67)+MIN((I234/'3. Cost_of_Service_Parameters'!G67),(I234+I240)))), 0, -(I235/('3. Cost_of_Service_Parameters'!G67)+MIN((I234/'3. Cost_of_Service_Parameters'!G67),(I234+I240))))","v":0},null,{"$f":"IF(ISERROR(-(K235/('3. Cost_of_Service_Parameters'!I67*2)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240)))), 0, -(K235/('3. Cost_of_Service_Parameters'!I67*2)+MIN((K234/'3. Cost_of_Service_Parameters'!I67),(K234+K240))))","v":0},null,{"$f":"IF(ISERROR(-(M235/('3. Cost_of_Service_Parameters'!K67*2)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240)))), 0, -(M235/('3. Cost_of_Service_Parameters'!K67*2)+MIN((M234/'3. Cost_of_Service_Parameters'!K67),(M234+M240))))","v":0},null,{"$f":"IF(ISERROR(-(O235/('3. Cost_of_Service_Parameters'!M67*2)+MIN((O234/'3. Cost_of_Service_Parameters'!M67),(O234+O240)))), 0, -(O235/('3. Cost_of_Service_Parameters'!M67*2)+MIN((O234/'3. Cost_of_Service_Parameters'!M67),(O234+O240))))","v":0},null,{"$f":"IF(ISERROR(-(Q235/('3. Cost_of_Service_Parameters'!O67*2)+MIN((Q234/'3. Cost_of_Service_Parameters'!O67),(Q234+Q240)))), 0, -(Q235/('3. Cost_of_Service_Parameters'!O67*2)+MIN((Q234/'3. Cost_of_Service_Parameters'!O67),(Q234+Q240))))","v":0},null,{"$f":"IF(ISERROR(-(S235/('3. Cost_of_Service_Parameters'!Q67*2)+MIN((S234/'3. Cost_of_Service_Parameters'!Q67),(S234+S240)))), 0, -(S235/('3. Cost_of_Service_Parameters'!Q67*2)+MIN((S234/'3. Cost_of_Service_Parameters'!Q67),(S234+S240))))","v":0},null,{"$f":"IF(ISERROR(-(U235/('3. Cost_of_Service_Parameters'!S67*2)+MIN((U234/'3. Cost_of_Service_Parameters'!S67),(U234+U240)))), 0, -(U235/('3. Cost_of_Service_Parameters'!S67*2)+MIN((U234/'3. Cost_of_Service_Parameters'!S67),(U234+U240))))","v":0},null,{"$f":"IF(ISERROR(-(W235/('3. Cost_of_Service_Parameters'!U67*2)+MIN((W234/'3. Cost_of_Service_Parameters'!U67),(W234+W240)))), 0, -(W235/('3. Cost_of_Service_Parameters'!U67*2)+MIN((W234/'3. Cost_of_Service_Parameters'!U67),(W234+W240))))","v":0},null,{"$f":"IF(ISERROR(-(Y235/('3. Cost_of_Service_Parameters'!W67*2)+MIN((Y234/'3. Cost_of_Service_Parameters'!W67),(Y234+Y240)))), 0, -(Y235/('3. Cost_of_Service_Parameters'!W67*2)+MIN((Y234/'3. Cost_of_Service_Parameters'!W67),(Y234+Y240))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I240+I241-I242","v":0},null,{"$f":"K240+K241-K242","v":0},null,{"$f":"M240+M241-M242","v":0},null,{"$f":"O240+O241-O242","v":0},null,{"$f":"Q240+Q241-Q242","v":0},null,{"$f":"S240+S241-S242","v":0},null,{"$f":"U240+U241-U242","v":0},null,{"$f":"W240+W241-W242","v":0},null,{"$f":"Y240+Y241-Y242","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I234+I240","v":0},null,{"$f":"I247","v":0},null,{"$f":"K247","v":0},null,{"$f":"M247","v":0},null,{"$f":"O247","v":0},null,{"$f":"Q247","v":0},null,{"$f":"S247","v":0},null,{"$f":"U247","v":0},null,{"$f":"W247","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I237+I243","v":0},null,{"$f":"K237+K243","v":0},null,{"$f":"M237+M243","v":0},null,{"$f":"O237+O243","v":0},null,{"$f":"Q237+Q243","v":0},null,{"$f":"S237+S243","v":0},null,{"$f":"U237+U243","v":0},null,{"$f":"W237+W243","v":0},null,{"$f":"Y237+Y243","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I247","v":0},null,{"$f":"AVERAGE(K246:K247)","v":0},null,{"$f":"AVERAGE(M246:M247)","v":0},null,{"$f":"AVERAGE(O246:O247)","v":0},null,{"$f":"AVERAGE(Q246:Q247)","v":0},null,{"$f":"AVERAGE(S246:S247)","v":0},null,{"$f":"AVERAGE(U246:U247)","v":0},null,{"$f":"AVERAGE(W246:W247)","v":0},null,{"$f":"AVERAGE(Y246:Y247)","v":0}]
[]
[]
[null,"Net Fixed Assets - Solid Dielectric Switchgear"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I257","v":0},null,{"$f":"K257","v":0},null,{"$f":"M257","v":0},null,{"$f":"O257","v":0},null,{"$f":"Q257","v":0},null,{"$f":"S257","v":0},null,{"$f":"U257","v":0},null,{"$f":"W257","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":0},null,{"$f":"'2. ICM_Costs'!I286","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I254+I255-I256","v":0},null,{"$f":"K254+K255-K256","v":0},null,{"$f":"M254+M255-M256","v":0},null,{"$f":"O254+O255-O256","v":0},null,{"$f":"Q254+Q255-Q256","v":0},null,{"$f":"S254+S255-S256","v":0},null,{"$f":"U254+U255-U256","v":0},null,{"$f":"W254+W255-W256","v":0},null,{"$f":"Y254+Y255-Y256","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I263","v":0},null,{"$f":"K263","v":0},null,{"$f":"M263","v":0},null,{"$f":"O263","v":0},null,{"$f":"Q263","v":0},null,{"$f":"S263","v":0},null,{"$f":"U263","v":0},null,{"$f":"W263","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I255/('3. Cost_of_Service_Parameters'!G69)+MIN((I254/'3. Cost_of_Service_Parameters'!G69),(I254+I260)))), 0, -(I255/('3. Cost_of_Service_Parameters'!G69)+MIN((I254/'3. Cost_of_Service_Parameters'!G69),(I254+I260))))","v":0},null,{"$f":"IF(ISERROR(-(K255/('3. Cost_of_Service_Parameters'!I69*2)+MIN((K254/'3. Cost_of_Service_Parameters'!I69),(K254+K260)))), 0, -(K255/('3. Cost_of_Service_Parameters'!I69*2)+MIN((K254/'3. Cost_of_Service_Parameters'!I69),(K254+K260))))","v":0},null,{"$f":"IF(ISERROR(-(M255/('3. Cost_of_Service_Parameters'!K69*2)+MIN((M254/'3. Cost_of_Service_Parameters'!K69),(M254+M260)))), 0, -(M255/('3. Cost_of_Service_Parameters'!K69*2)+MIN((M254/'3. Cost_of_Service_Parameters'!K69),(M254+M260))))","v":0},null,{"$f":"IF(ISERROR(-(O255/('3. Cost_of_Service_Parameters'!M69*2)+MIN((O254/'3. Cost_of_Service_Parameters'!M69),(O254+O260)))), 0, -(O255/('3. Cost_of_Service_Parameters'!M69*2)+MIN((O254/'3. Cost_of_Service_Parameters'!M69),(O254+O260))))","v":0},null,{"$f":"IF(ISERROR(-(Q255/('3. Cost_of_Service_Parameters'!O69*2)+MIN((Q254/'3. Cost_of_Service_Parameters'!O69),(Q254+Q260)))), 0, -(Q255/('3. Cost_of_Service_Parameters'!O69*2)+MIN((Q254/'3. Cost_of_Service_Parameters'!O69),(Q254+Q260))))","v":0},null,{"$f":"IF(ISERROR(-(S255/('3. Cost_of_Service_Parameters'!Q69*2)+MIN((S254/'3. Cost_of_Service_Parameters'!Q69),(S254+S260)))), 0, -(S255/('3. Cost_of_Service_Parameters'!Q69*2)+MIN((S254/'3. Cost_of_Service_Parameters'!Q69),(S254+S260))))","v":0},null,{"$f":"IF(ISERROR(-(U255/('3. Cost_of_Service_Parameters'!S69*2)+MIN((U254/'3. Cost_of_Service_Parameters'!S69),(U254+U260)))), 0, -(U255/('3. Cost_of_Service_Parameters'!S69*2)+MIN((U254/'3. Cost_of_Service_Parameters'!S69),(U254+U260))))","v":0},null,{"$f":"IF(ISERROR(-(W255/('3. Cost_of_Service_Parameters'!U69*2)+MIN((W254/'3. Cost_of_Service_Parameters'!U69),(W254+W260)))), 0, -(W255/('3. Cost_of_Service_Parameters'!U69*2)+MIN((W254/'3. Cost_of_Service_Parameters'!U69),(W254+W260))))","v":0},null,{"$f":"IF(ISERROR(-(Y255/('3. Cost_of_Service_Parameters'!W69*2)+MIN((Y254/'3. Cost_of_Service_Parameters'!W69),(Y254+Y260)))), 0, -(Y255/('3. Cost_of_Service_Parameters'!W69*2)+MIN((Y254/'3. Cost_of_Service_Parameters'!W69),(Y254+Y260))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I260+I261-I262","v":0},null,{"$f":"K260+K261-K262","v":0},null,{"$f":"M260+M261-M262","v":0},null,{"$f":"O260+O261-O262","v":0},null,{"$f":"Q260+Q261-Q262","v":0},null,{"$f":"S260+S261-S262","v":0},null,{"$f":"U260+U261-U262","v":0},null,{"$f":"W260+W261-W262","v":0},null,{"$f":"Y260+Y261-Y262","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I254+I260","v":0},null,{"$f":"I267","v":0},null,{"$f":"K267","v":0},null,{"$f":"M267","v":0},null,{"$f":"O267","v":0},null,{"$f":"Q267","v":0},null,{"$f":"S267","v":0},null,{"$f":"U267","v":0},null,{"$f":"W267","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I257+I263","v":0},null,{"$f":"K257+K263","v":0},null,{"$f":"M257+M263","v":0},null,{"$f":"O257+O263","v":0},null,{"$f":"Q257+Q263","v":0},null,{"$f":"S257+S263","v":0},null,{"$f":"U257+U263","v":0},null,{"$f":"W257+W263","v":0},null,{"$f":"Y257+Y263","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I267","v":0},null,{"$f":"AVERAGE(K266:K267)","v":0},null,{"$f":"AVERAGE(M266:M267)","v":0},null,{"$f":"AVERAGE(O266:O267)","v":0},null,{"$f":"AVERAGE(Q266:Q267)","v":0},null,{"$f":"AVERAGE(S266:S267)","v":0},null,{"$f":"AVERAGE(U266:U267)","v":0},null,{"$f":"AVERAGE(W266:W267)","v":0},null,{"$f":"AVERAGE(Y266:Y267)","v":0}]
[]
[]
[null,"Net Fixed Assets - UG Cable Injection"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I277","v":0},null,{"$f":"K277","v":0},null,{"$f":"M277","v":0},null,{"$f":"O277","v":0},null,{"$f":"Q277","v":0},null,{"$f":"S277","v":0},null,{"$f":"U277","v":0},null,{"$f":"W277","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G208","v":0},null,{"$f":"'2. ICM_Costs'!I306","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I274+I275-I276","v":0},null,{"$f":"K274+K275-K276","v":0},null,{"$f":"M274+M275-M276","v":0},null,{"$f":"O274+O275-O276","v":0},null,{"$f":"Q274+Q275-Q276","v":0},null,{"$f":"S274+S275-S276","v":0},null,{"$f":"U274+U275-U276","v":0},null,{"$f":"W274+W275-W276","v":0},null,{"$f":"Y274+Y275-Y276","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I283","v":0},null,{"$f":"K283","v":0},null,{"$f":"M283","v":0},null,{"$f":"O283","v":0},null,{"$f":"Q283","v":0},null,{"$f":"S283","v":0},null,{"$f":"U283","v":0},null,{"$f":"W283","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I275/('3. Cost_of_Service_Parameters'!G71)+MIN((I274/'3. Cost_of_Service_Parameters'!G71),(I274+I280)))), 0, -(I275/('3. Cost_of_Service_Parameters'!G71)+MIN((I274/'3. Cost_of_Service_Parameters'!G71),(I274+I280))))","v":0},null,{"$f":"IF(ISERROR(-(K275/('3. Cost_of_Service_Parameters'!I71*2)+MIN((K274/'3. Cost_of_Service_Parameters'!I71),(K274+K280)))), 0, -(K275/('3. Cost_of_Service_Parameters'!I71*2)+MIN((K274/'3. Cost_of_Service_Parameters'!I71),(K274+K280))))","v":0},null,{"$f":"IF(ISERROR(-(M275/('3. Cost_of_Service_Parameters'!K71*2)+MIN((M274/'3. Cost_of_Service_Parameters'!K71),(M274+M280)))), 0, -(M275/('3. Cost_of_Service_Parameters'!K71*2)+MIN((M274/'3. Cost_of_Service_Parameters'!K71),(M274+M280))))","v":0},null,{"$f":"IF(ISERROR(-(O275/('3. Cost_of_Service_Parameters'!M71*2)+MIN((O274/'3. Cost_of_Service_Parameters'!M71),(O274+O280)))), 0, -(O275/('3. Cost_of_Service_Parameters'!M71*2)+MIN((O274/'3. Cost_of_Service_Parameters'!M71),(O274+O280))))","v":0},null,{"$f":"IF(ISERROR(-(Q275/('3. Cost_of_Service_Parameters'!O71*2)+MIN((Q274/'3. Cost_of_Service_Parameters'!O71),(Q274+Q280)))), 0, -(Q275/('3. Cost_of_Service_Parameters'!O71*2)+MIN((Q274/'3. Cost_of_Service_Parameters'!O71),(Q274+Q280))))","v":0},null,{"$f":"IF(ISERROR(-(S275/('3. Cost_of_Service_Parameters'!Q71*2)+MIN((S274/'3. Cost_of_Service_Parameters'!Q71),(S274+S280)))), 0, -(S275/('3. Cost_of_Service_Parameters'!Q71*2)+MIN((S274/'3. Cost_of_Service_Parameters'!Q71),(S274+S280))))","v":0},null,{"$f":"IF(ISERROR(-(U275/('3. Cost_of_Service_Parameters'!S71*2)+MIN((U274/'3. Cost_of_Service_Parameters'!S71),(U274+U280)))), 0, -(U275/('3. Cost_of_Service_Parameters'!S71*2)+MIN((U274/'3. Cost_of_Service_Parameters'!S71),(U274+U280))))","v":0},null,{"$f":"IF(ISERROR(-(W275/('3. Cost_of_Service_Parameters'!U71*2)+MIN((W274/'3. Cost_of_Service_Parameters'!U71),(W274+W280)))), 0, -(W275/('3. Cost_of_Service_Parameters'!U71*2)+MIN((W274/'3. Cost_of_Service_Parameters'!U71),(W274+W280))))","v":0},null,{"$f":"IF(ISERROR(-(Y275/('3. Cost_of_Service_Parameters'!W71*2)+MIN((Y274/'3. Cost_of_Service_Parameters'!W71),(Y274+Y280)))), 0, -(Y275/('3. Cost_of_Service_Parameters'!W71*2)+MIN((Y274/'3. Cost_of_Service_Parameters'!W71),(Y274+Y280))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I280+I281-I282","v":0},null,{"$f":"K280+K281-K282","v":0},null,{"$f":"M280+M281-M282","v":0},null,{"$f":"O280+O281-O282","v":0},null,{"$f":"Q280+Q281-Q282","v":0},null,{"$f":"S280+S281-S282","v":0},null,{"$f":"U280+U281-U282","v":0},null,{"$f":"W280+W281-W282","v":0},null,{"$f":"Y280+Y281-Y282","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I274+I280","v":0},null,{"$f":"I287","v":0},null,{"$f":"K287","v":0},null,{"$f":"M287","v":0},null,{"$f":"O287","v":0},null,{"$f":"Q287","v":0},null,{"$f":"S287","v":0},null,{"$f":"U287","v":0},null,{"$f":"W287","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I277+I283","v":0},null,{"$f":"K277+K283","v":0},null,{"$f":"M277+M283","v":0},null,{"$f":"O277+O283","v":0},null,{"$f":"Q277+Q283","v":0},null,{"$f":"S277+S283","v":0},null,{"$f":"U277+U283","v":0},null,{"$f":"W277+W283","v":0},null,{"$f":"Y277+Y283","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I287","v":0},null,{"$f":"AVERAGE(K286:K287)","v":0},null,{"$f":"AVERAGE(M286:M287)","v":0},null,{"$f":"AVERAGE(O286:O287)","v":0},null,{"$f":"AVERAGE(Q286:Q287)","v":0},null,{"$f":"AVERAGE(S286:S287)","v":0},null,{"$f":"AVERAGE(U286:U287)","v":0},null,{"$f":"AVERAGE(W286:W287)","v":0},null,{"$f":"AVERAGE(Y286:Y287)","v":0}]
[]
[]
[null,"Net Fixed Assets - MS Integrated P&C Systems "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I297","v":0},null,{"$f":"K297","v":0},null,{"$f":"M297","v":0},null,{"$f":"O297","v":0},null,{"$f":"Q297","v":0},null,{"$f":"S297","v":0},null,{"$f":"U297","v":0},null,{"$f":"W297","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G210","v":0},null,{"$f":"'2. ICM_Costs'!I326","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I294+I295-I296","v":0},null,{"$f":"K294+K295-K296","v":0},null,{"$f":"M294+M295-M296","v":0},null,{"$f":"O294+O295-O296","v":0},null,{"$f":"Q294+Q295-Q296","v":0},null,{"$f":"S294+S295-S296","v":0},null,{"$f":"U294+U295-U296","v":0},null,{"$f":"W294+W295-W296","v":0},null,{"$f":"Y294+Y295-Y296","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I303","v":0},null,{"$f":"K303","v":0},null,{"$f":"M303","v":0},null,{"$f":"O303","v":0},null,{"$f":"Q303","v":0},null,{"$f":"S303","v":0},null,{"$f":"U303","v":0},null,{"$f":"W303","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I295/('3. Cost_of_Service_Parameters'!G73)+MIN((I294/'3. Cost_of_Service_Parameters'!G73),(I294+I300)))), 0, -(I295/('3. Cost_of_Service_Parameters'!G73)+MIN((I294/'3. Cost_of_Service_Parameters'!G73),(I294+I300))))","v":0},null,{"$f":"IF(ISERROR(-(K295/('3. Cost_of_Service_Parameters'!I73*2)+MIN((K294/'3. Cost_of_Service_Parameters'!I73),(K294+K300)))), 0, -(K295/('3. Cost_of_Service_Parameters'!I73*2)+MIN((K294/'3. Cost_of_Service_Parameters'!I73),(K294+K300))))","v":0},null,{"$f":"IF(ISERROR(-(M295/('3. Cost_of_Service_Parameters'!K73*2)+MIN((M294/'3. Cost_of_Service_Parameters'!K73),(M294+M300)))), 0, -(M295/('3. Cost_of_Service_Parameters'!K73*2)+MIN((M294/'3. Cost_of_Service_Parameters'!K73),(M294+M300))))","v":0},null,{"$f":"IF(ISERROR(-(O295/('3. Cost_of_Service_Parameters'!M73*2)+MIN((O294/'3. Cost_of_Service_Parameters'!M73),(O294+O300)))), 0, -(O295/('3. Cost_of_Service_Parameters'!M73*2)+MIN((O294/'3. Cost_of_Service_Parameters'!M73),(O294+O300))))","v":0},null,{"$f":"IF(ISERROR(-(Q295/('3. Cost_of_Service_Parameters'!O73*2)+MIN((Q294/'3. Cost_of_Service_Parameters'!O73),(Q294+Q300)))), 0, -(Q295/('3. Cost_of_Service_Parameters'!O73*2)+MIN((Q294/'3. Cost_of_Service_Parameters'!O73),(Q294+Q300))))","v":0},null,{"$f":"IF(ISERROR(-(S295/('3. Cost_of_Service_Parameters'!Q73*2)+MIN((S294/'3. Cost_of_Service_Parameters'!Q73),(S294+S300)))), 0, -(S295/('3. Cost_of_Service_Parameters'!Q73*2)+MIN((S294/'3. Cost_of_Service_Parameters'!Q73),(S294+S300))))","v":0},null,{"$f":"IF(ISERROR(-(U295/('3. Cost_of_Service_Parameters'!S73*2)+MIN((U294/'3. Cost_of_Service_Parameters'!S73),(U294+U300)))), 0, -(U295/('3. Cost_of_Service_Parameters'!S73*2)+MIN((U294/'3. Cost_of_Service_Parameters'!S73),(U294+U300))))","v":0},null,{"$f":"IF(ISERROR(-(W295/('3. Cost_of_Service_Parameters'!U73*2)+MIN((W294/'3. Cost_of_Service_Parameters'!U73),(W294+W300)))), 0, -(W295/('3. Cost_of_Service_Parameters'!U73*2)+MIN((W294/'3. Cost_of_Service_Parameters'!U73),(W294+W300))))","v":0},null,{"$f":"IF(ISERROR(-(Y295/('3. Cost_of_Service_Parameters'!W73*2)+MIN((Y294/'3. Cost_of_Service_Parameters'!W73),(Y294+Y300)))), 0, -(Y295/('3. Cost_of_Service_Parameters'!W73*2)+MIN((Y294/'3. Cost_of_Service_Parameters'!W73),(Y294+Y300))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I300+I301-I302","v":0},null,{"$f":"K300+K301-K302","v":0},null,{"$f":"M300+M301-M302","v":0},null,{"$f":"O300+O301-O302","v":0},null,{"$f":"Q300+Q301-Q302","v":0},null,{"$f":"S300+S301-S302","v":0},null,{"$f":"U300+U301-U302","v":0},null,{"$f":"W300+W301-W302","v":0},null,{"$f":"Y300+Y301-Y302","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I294+I300","v":0},null,{"$f":"I307","v":0},null,{"$f":"K307","v":0},null,{"$f":"M307","v":0},null,{"$f":"O307","v":0},null,{"$f":"Q307","v":0},null,{"$f":"S307","v":0},null,{"$f":"U307","v":0},null,{"$f":"W307","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I297+I303","v":0},null,{"$f":"K297+K303","v":0},null,{"$f":"M297+M303","v":0},null,{"$f":"O297+O303","v":0},null,{"$f":"Q297+Q303","v":0},null,{"$f":"S297+S303","v":0},null,{"$f":"U297+U303","v":0},null,{"$f":"W297+W303","v":0},null,{"$f":"Y297+Y303","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I307","v":0},null,{"$f":"AVERAGE(K306:K307)","v":0},null,{"$f":"AVERAGE(M306:M307)","v":0},null,{"$f":"AVERAGE(O306:O307)","v":0},null,{"$f":"AVERAGE(Q306:Q307)","v":0},null,{"$f":"AVERAGE(S306:S307)","v":0},null,{"$f":"AVERAGE(U306:U307)","v":0},null,{"$f":"AVERAGE(W306:W307)","v":0},null,{"$f":"AVERAGE(Y306:Y307)","v":0}]
[]
[]
[null,"Net Fixed Assets - MS Building Improvements "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I317","v":0},null,{"$f":"K317","v":0},null,{"$f":"M317","v":0},null,{"$f":"O317","v":0},null,{"$f":"Q317","v":0},null,{"$f":"S317","v":0},null,{"$f":"U317","v":0},null,{"$f":"W317","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G212","v":0},null,{"$f":"'2. ICM_Costs'!I346","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I314+I315-I316","v":0},null,{"$f":"K314+K315-K316","v":0},null,{"$f":"M314+M315-M316","v":0},null,{"$f":"O314+O315-O316","v":0},null,{"$f":"Q314+Q315-Q316","v":0},null,{"$f":"S314+S315-S316","v":0},null,{"$f":"U314+U315-U316","v":0},null,{"$f":"W314+W315-W316","v":0},null,{"$f":"Y314+Y315-Y316","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I323","v":0},null,{"$f":"K323","v":0},null,{"$f":"M323","v":0},null,{"$f":"O323","v":0},null,{"$f":"Q323","v":0},null,{"$f":"S323","v":0},null,{"$f":"U323","v":0},null,{"$f":"W323","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I315/('3. Cost_of_Service_Parameters'!G75)+MIN((I314/'3. Cost_of_Service_Parameters'!G75),(I314+I320)))), 0, -(I315/('3. Cost_of_Service_Parameters'!G75)+MIN((I314/'3. Cost_of_Service_Parameters'!G75),(I314+I320))))","v":0},null,{"$f":"IF(ISERROR(-(K315/('3. Cost_of_Service_Parameters'!I75*2)+MIN((K314/'3. Cost_of_Service_Parameters'!I75),(K314+K320)))), 0, -(K315/('3. Cost_of_Service_Parameters'!I75*2)+MIN((K314/'3. Cost_of_Service_Parameters'!I75),(K314+K320))))","v":0},null,{"$f":"IF(ISERROR(-(M315/('3. Cost_of_Service_Parameters'!K75*2)+MIN((M314/'3. Cost_of_Service_Parameters'!K75),(M314+M320)))), 0, -(M315/('3. Cost_of_Service_Parameters'!K75*2)+MIN((M314/'3. Cost_of_Service_Parameters'!K75),(M314+M320))))","v":0},null,{"$f":"IF(ISERROR(-(O315/('3. Cost_of_Service_Parameters'!M75*2)+MIN((O314/'3. Cost_of_Service_Parameters'!M75),(O314+O320)))), 0, -(O315/('3. Cost_of_Service_Parameters'!M75*2)+MIN((O314/'3. Cost_of_Service_Parameters'!M75),(O314+O320))))","v":0},null,{"$f":"IF(ISERROR(-(Q315/('3. Cost_of_Service_Parameters'!O75*2)+MIN((Q314/'3. Cost_of_Service_Parameters'!O75),(Q314+Q320)))), 0, -(Q315/('3. Cost_of_Service_Parameters'!O75*2)+MIN((Q314/'3. Cost_of_Service_Parameters'!O75),(Q314+Q320))))","v":0},null,{"$f":"IF(ISERROR(-(S315/('3. Cost_of_Service_Parameters'!Q75*2)+MIN((S314/'3. Cost_of_Service_Parameters'!Q75),(S314+S320)))), 0, -(S315/('3. Cost_of_Service_Parameters'!Q75*2)+MIN((S314/'3. Cost_of_Service_Parameters'!Q75),(S314+S320))))","v":0},null,{"$f":"IF(ISERROR(-(U315/('3. Cost_of_Service_Parameters'!S75*2)+MIN((U314/'3. Cost_of_Service_Parameters'!S75),(U314+U320)))), 0, -(U315/('3. Cost_of_Service_Parameters'!S75*2)+MIN((U314/'3. Cost_of_Service_Parameters'!S75),(U314+U320))))","v":0},null,{"$f":"IF(ISERROR(-(W315/('3. Cost_of_Service_Parameters'!U75*2)+MIN((W314/'3. Cost_of_Service_Parameters'!U75),(W314+W320)))), 0, -(W315/('3. Cost_of_Service_Parameters'!U75*2)+MIN((W314/'3. Cost_of_Service_Parameters'!U75),(W314+W320))))","v":0},null,{"$f":"IF(ISERROR(-(Y315/('3. Cost_of_Service_Parameters'!W75*2)+MIN((Y314/'3. Cost_of_Service_Parameters'!W75),(Y314+Y320)))), 0, -(Y315/('3. Cost_of_Service_Parameters'!W75*2)+MIN((Y314/'3. Cost_of_Service_Parameters'!W75),(Y314+Y320))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I320+I321-I322","v":0},null,{"$f":"K320+K321-K322","v":0},null,{"$f":"M320+M321-M322","v":0},null,{"$f":"O320+O321-O322","v":0},null,{"$f":"Q320+Q321-Q322","v":0},null,{"$f":"S320+S321-S322","v":0},null,{"$f":"U320+U321-U322","v":0},null,{"$f":"W320+W321-W322","v":0},null,{"$f":"Y320+Y321-Y322","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I314+I320","v":0},null,{"$f":"I327","v":0},null,{"$f":"K327","v":0},null,{"$f":"M327","v":0},null,{"$f":"O327","v":0},null,{"$f":"Q327","v":0},null,{"$f":"S327","v":0},null,{"$f":"U327","v":0},null,{"$f":"W327","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I317+I323","v":0},null,{"$f":"K317+K323","v":0},null,{"$f":"M317+M323","v":0},null,{"$f":"O317+O323","v":0},null,{"$f":"Q317+Q323","v":0},null,{"$f":"S317+S323","v":0},null,{"$f":"U317+U323","v":0},null,{"$f":"W317+W323","v":0},null,{"$f":"Y317+Y323","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I327","v":0},null,{"$f":"AVERAGE(K326:K327)","v":0},null,{"$f":"AVERAGE(M326:M327)","v":0},null,{"$f":"AVERAGE(O326:O327)","v":0},null,{"$f":"AVERAGE(Q326:Q327)","v":0},null,{"$f":"AVERAGE(S326:S327)","v":0},null,{"$f":"AVERAGE(U326:U327)","v":0},null,{"$f":"AVERAGE(W326:W327)","v":0},null,{"$f":"AVERAGE(Y326:Y327)","v":0}]
[]
[]
[null,"Net Fixed Assets - Capital Contributions Paid "]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I337","v":0},null,{"$f":"K337","v":0},null,{"$f":"M337","v":0},null,{"$f":"O337","v":0},null,{"$f":"Q337","v":0},null,{"$f":"S337","v":0},null,{"$f":"U337","v":0},null,{"$f":"W337","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G214","v":0},null,{"$f":"'2. ICM_Costs'!I366","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I334+I335-I336","v":0},null,{"$f":"K334+K335-K336","v":0},null,{"$f":"M334+M335-M336","v":0},null,{"$f":"O334+O335-O336","v":0},null,{"$f":"Q334+Q335-Q336","v":0},null,{"$f":"S334+S335-S336","v":0},null,{"$f":"U334+U335-U336","v":0},null,{"$f":"W334+W335-W336","v":0},null,{"$f":"Y334+Y335-Y336","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I343","v":0},null,{"$f":"K343","v":0},null,{"$f":"M343","v":0},null,{"$f":"O343","v":0},null,{"$f":"Q343","v":0},null,{"$f":"S343","v":0},null,{"$f":"U343","v":0},null,{"$f":"W343","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I335/('3. Cost_of_Service_Parameters'!G77)+MIN((I334/'3. Cost_of_Service_Parameters'!G77),(I334+I340)))), 0, -(I335/('3. Cost_of_Service_Parameters'!G77)+MIN((I334/'3. Cost_of_Service_Parameters'!G77),(I334+I340))))","v":0},null,{"$f":"IF(ISERROR(-(K335/('3. Cost_of_Service_Parameters'!I77*2)+MIN((K334/'3. Cost_of_Service_Parameters'!I77),(K334+K340)))), 0, -(K335/('3. Cost_of_Service_Parameters'!I77*2)+MIN((K334/'3. Cost_of_Service_Parameters'!I77),(K334+K340))))","v":0},null,{"$f":"IF(ISERROR(-(M335/('3. Cost_of_Service_Parameters'!K77*2)+MIN((M334/'3. Cost_of_Service_Parameters'!K77),(M334+M340)))), 0, -(M335/('3. Cost_of_Service_Parameters'!K77*2)+MIN((M334/'3. Cost_of_Service_Parameters'!K77),(M334+M340))))","v":0},null,{"$f":"IF(ISERROR(-(O335/('3. Cost_of_Service_Parameters'!M77*2)+MIN((O334/'3. Cost_of_Service_Parameters'!M77),(O334+O340)))), 0, -(O335/('3. Cost_of_Service_Parameters'!M77*2)+MIN((O334/'3. Cost_of_Service_Parameters'!M77),(O334+O340))))","v":0},null,{"$f":"IF(ISERROR(-(Q335/('3. Cost_of_Service_Parameters'!O77*2)+MIN((Q334/'3. Cost_of_Service_Parameters'!O77),(Q334+Q340)))), 0, -(Q335/('3. Cost_of_Service_Parameters'!O77*2)+MIN((Q334/'3. Cost_of_Service_Parameters'!O77),(Q334+Q340))))","v":0},null,{"$f":"IF(ISERROR(-(S335/('3. Cost_of_Service_Parameters'!Q77*2)+MIN((S334/'3. Cost_of_Service_Parameters'!Q77),(S334+S340)))), 0, -(S335/('3. Cost_of_Service_Parameters'!Q77*2)+MIN((S334/'3. Cost_of_Service_Parameters'!Q77),(S334+S340))))","v":0},null,{"$f":"IF(ISERROR(-(U335/('3. Cost_of_Service_Parameters'!S77*2)+MIN((U334/'3. Cost_of_Service_Parameters'!S77),(U334+U340)))), 0, -(U335/('3. Cost_of_Service_Parameters'!S77*2)+MIN((U334/'3. Cost_of_Service_Parameters'!S77),(U334+U340))))","v":0},null,{"$f":"IF(ISERROR(-(W335/('3. Cost_of_Service_Parameters'!U77*2)+MIN((W334/'3. Cost_of_Service_Parameters'!U77),(W334+W340)))), 0, -(W335/('3. Cost_of_Service_Parameters'!U77*2)+MIN((W334/'3. Cost_of_Service_Parameters'!U77),(W334+W340))))","v":0},null,{"$f":"IF(ISERROR(-(Y335/('3. Cost_of_Service_Parameters'!W77*2)+MIN((Y334/'3. Cost_of_Service_Parameters'!W77),(Y334+Y340)))), 0, -(Y335/('3. Cost_of_Service_Parameters'!W77*2)+MIN((Y334/'3. Cost_of_Service_Parameters'!W77),(Y334+Y340))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I340+I341-I342","v":0},null,{"$f":"K340+K341-K342","v":0},null,{"$f":"M340+M341-M342","v":0},null,{"$f":"O340+O341-O342","v":0},null,{"$f":"Q340+Q341-Q342","v":0},null,{"$f":"S340+S341-S342","v":0},null,{"$f":"U340+U341-U342","v":0},null,{"$f":"W340+W341-W342","v":0},null,{"$f":"Y340+Y341-Y342","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I334+I340","v":0},null,{"$f":"I347","v":0},null,{"$f":"K347","v":0},null,{"$f":"M347","v":0},null,{"$f":"O347","v":0},null,{"$f":"Q347","v":0},null,{"$f":"S347","v":0},null,{"$f":"U347","v":0},null,{"$f":"W347","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I337+I343","v":0},null,{"$f":"K337+K343","v":0},null,{"$f":"M337+M343","v":0},null,{"$f":"O337+O343","v":0},null,{"$f":"Q337+Q343","v":0},null,{"$f":"S337+S343","v":0},null,{"$f":"U337+U343","v":0},null,{"$f":"W337+W343","v":0},null,{"$f":"Y337+Y343","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I347","v":0},null,{"$f":"AVERAGE(K346:K347)","v":0},null,{"$f":"AVERAGE(M346:M347)","v":0},null,{"$f":"AVERAGE(O346:O347)","v":0},null,{"$f":"AVERAGE(Q346:Q347)","v":0},null,{"$f":"AVERAGE(S346:S347)","v":0},null,{"$f":"AVERAGE(U346:U347)","v":0},null,{"$f":"AVERAGE(W346:W347)","v":0},null,{"$f":"AVERAGE(Y346:Y347)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Additions",null,null,null,null,{"$f":"I23+I42+I61+I80+I99+I118+I137+I156+I175+I195+I215+I235+I255+I275+I295+I315+I335","v":15873596.200000009},null,{"$f":"K23+K42+K61+K80+K99+K118+K137+K156+K175+K195+K215+K235+K255+K275+K295+K315+K335","v":0},null,{"$f":"M23+M42+M61+M80+M99+M118+M137+M156+M175+M195+M215+M235+M255+M275+M295+M315+M335","v":0},null,{"$f":"O23+O42+O61+O80+O99+O118+O137+O156+O175+O195+O215+O235+O255+O275+O295+O315+O335","v":0},null,{"$f":"Q23+Q42+Q61+Q80+Q99+Q118+Q137+Q156+Q175+Q195+Q215+Q235+Q255+Q275+Q295+Q315+Q335","v":0},null,{"$f":"S23+S42+S61+S80+S99+S118+S137+S156+S175+S195+S215+S235+S255+S275+S295+S315+S335","v":0},null,{"$f":"U23+U42+U61+U80+U99+U118+U137+U156+U175+U195+U215+U235+U255+U275+U295+U315+U335","v":0},null,{"$f":"W23+W42+W61+W80+W99+W118+W137+W156+W175+W195+W215+W235+W255+W275+W295+W315+W335","v":0},null,{"$f":"Y23+Y42+Y61+Y80+Y99+Y118+Y137+Y156+Y175+Y195+Y215+Y235+Y255+Y275+Y295+Y315+Y335","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+I288+I308+I328+I348","v":15528758.596355364},null,{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268+K288+K308+K328+K348","v":15356339.794533039},null,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268+M288+M308+M328+M348","v":15011502.190888394},null,{"$f":"O36+O55+O74+O93+O112+O131+O150+O169+O188+O208+O228+O248+O268+O288+O308+O328+O348","v":14666664.587243747},null,{"$f":"Q36+Q55+Q74+Q93+Q112+Q131+Q150+Q169+Q188+Q208+Q228+Q248+Q268+Q288+Q308+Q328+Q348","v":14321826.9835991},null,{"$f":"S36+S55+S74+S93+S112+S131+S150+S169+S188+S208+S228+S248+S268+S288+S308+S328+S348","v":13976989.379954452},null,{"$f":"U36+U55+U74+U93+U112+U131+U150+U169+U188+U208+U228+U248+U268+U288+U308+U328+U348","v":13632151.776309809},null,{"$f":"W36+W55+W74+W93+W112+W131+W150+W169+W188+W208+W228+W248+W268+W288+W308+W328+W348","v":13303957.564159704},null,{"$f":"Y36+Y55+Y74+Y93+Y112+Y131+Y150+Y169+Y188+Y208+Y228+Y248+Y268+Y288+Y308+Y328+Y348","v":12992406.74350415}]
[null,null,null,"Total Amortization",null,null,null,null,{"$f":"I29+I48+I67+I86+I105+I124+I143+I162+I181+I201+I221+I241+I261+I281+I301+I321+I341","v":-344837.60364464635},null,{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261+K281+K301+K321+K341","v":-344837.60364464635},null,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261+M281+M301+M321+M341","v":-344837.60364464635},null,{"$f":"O29+O48+O67+O86+O105+O124+O143+O162+O181+O201+O221+O241+O261+O281+O301+O321+O341","v":-344837.60364464635},null,{"$f":"Q29+Q48+Q67+Q86+Q105+Q124+Q143+Q162+Q181+Q201+Q221+Q241+Q261+Q281+Q301+Q321+Q341","v":-344837.60364464635},null,{"$f":"S29+S48+S67+S86+S105+S124+S143+S162+S181+S201+S221+S241+S261+S281+S301+S321+S341","v":-344837.60364464635},null,{"$f":"U29+U48+U67+U86+U105+U124+U143+U162+U181+U201+U221+U241+U261+U281+U301+U321+U341","v":-344837.60364464635},null,{"$f":"W29+W48+W67+W86+W105+W124+W143+W162+W181+W201+W221+W241+W261+W281+W301+W321+W341","v":-311550.8206555557},null,{"$f":"Y29+Y48+Y67+Y86+Y105+Y124+Y143+Y162+Y181+Y201+Y221+Y241+Y261+Y281+Y301+Y321+Y341","v":-311550.8206555557},0]

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

{"sheet":"6. ICMIRR_2018","index":5,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[23,8,23,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sheet 6:",null,"Incremental Capital Adjustment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"2018 OEB Approved"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"'2. ICM_Costs'!G219","v":15873596.200000009},"B",null,null,null,11243530]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":344837.60364464635},"C",null,null,null,266271.29064259888]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"F27-F28","v":15528758.596355362},"D = B - C",null,null,null,{"$f":"K27-K28","v":10977258.709357401}]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},"E",{"$f":"F29*D31","v":621150.34385421453},"G = D * E",null,{"$f":"D31","v":0.04},null,{"$f":"K29*I31","v":439090.34837429604}]
[null,null,"Deemed Long Term Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},"F",{"$f":"F29*D32","v":8696104.8139590025},"H = D * F",null,{"$f":"D32","v":0.55999999999999994},null,{"$f":"K29*I32","v":6147264.8772401437}]
[]
[null,null,"Short Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":1.7600000000000001E-2},"I",{"$f":"F31*D34","v":10932.246051834176},"K = G * I",null,{"$f":"D34","v":1.7600000000000001E-2},null,{"$f":"K31*I34","v":7727.9901313876107}]
[null,null,"Long Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":3.8825039999999998E-2},"J",{"$f":"F32*D35","v":337626.6172461508},"L = H * J",null,{"$f":"D35","v":3.8825039999999998E-2},null,{"$f":"K32*I35","v":238667.80474944366}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":348558.86329798499},"M = K + L",null,null,null,{"$f":"SUM(K34:K35)","v":246395.79488083126}]
[]
[]
[null,null,"Deemed Equity %",{"$f":"'3. Cost_of_Service_Parameters'!G24","v":0.40000000000000008},"N",{"$f":"F29*D40","v":6211503.4385421462},"P = D * N",null,0.39999999999999991,null,{"$f":"K29*I40","v":4390903.4837429598}]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":8.7800000000000003E-2},"O",{"$f":"F40*D42","v":545370.00190400041},"Q = P * O",null,{"$f":"D42","v":8.7800000000000003E-2},null,{"$f":"K40*I42","v":385521.32587263186}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":893928.86520198546},"R = M + Q",null,null,null,{"$f":"K37+K42","v":631917.12075346312}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":344837.60364464635},"S",null,null,null,{"$f":"K28","v":266271.29064259888}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":545370.00190400041},"T ",null,null,null,{"$f":"K42","v":385521.32587263186}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":344837.60364464635},"U",null,null,null,{"$f":"K50","v":266271.29064259888}]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'5. UCC_Calculation'!D31+'5. UCC_Calculation'!D45","v":1269887.6960000007},"V",null,null,null,899482.38320000086]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-379680.09045135393},"W = T + U - V",null,null,null,{"$f":"K55+K57-K59","v":-247689.76668477012}]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.26500000000000001},"X",null,null,null,{"$f":"D63","v":0.26500000000000001}]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-100615.22396960879},"Y = W * X",null,null,null,{"$f":"K61*I63","v":-65637.788171464083}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-136891.46118314122},"Z = Y / ( 1 - X ) ",null,null,null,{"$f":"K65/(1-I63)","v":-89303.113158454536}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":15873596.200000009},"AA",null,null,null,{"$f":"K27","v":11243530}]
[]
[null,null,"Less : Available Capital Exemption (if any)",null,null,0,"AB",null,null,null,0]
[]
[null,null,"Incremental Capital CAPEX subject to OCT",null,null,{"$f":"F71-F73","v":15873596.200000009},"AC = AA - AB",null,null,null,{"$f":"K71-K73","v":11243530}]
[]
[null,null,"Ontario Capital Tax Rate (F1.1 Z-Factor Tax Changes)",0,"AD"]
[]
[null,null,"Incremental Ontario Capital Tax",null,null,{"$f":"F75*D77","v":0},"AE = AC * AD",null,null,null,{"$f":"K75*I77","v":0}]
[]
[]
[null,null,"Incremental Revenue Requirement"]
[null,null,"Return on Rate Base - Total",null,"Q",{"$f":"F44","v":893928.86520198546},"AF",null,null,null,{"$f":"K44","v":631917.12075346312}]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":344837.60364464635},"AG",null,null,null,{"$f":"K50","v":266271.29064259888}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-136891.46118314122},"AH",null,null,null,{"$f":"K67","v":-89303.113158454536}]
[null,null,"Incremental Ontario Capital Tax",null,"AE",{"$f":"F79","v":0},"AI",null,null,null,{"$f":"K79","v":0}]
[]
[null,null,"Incremental Revenue Requirement",null,null,{"$f":"SUM(F83:F86)","v":1101875.0076634905},"AJ = AF + AG + AH + AI",null,null,null,{"$f":"SUM(K83:K86)","v":808885.29823760747}]

{"sheet":"7. Rate Rider Revs","index":6,"n_rows":131,"n_cols":17,"rows_kept":131,"cut":false,"hidden":false,"merged":[[12,1,12,13],[18,5,18,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the rate riders revenues.\n"]
[]
[]
[]
[null,"Sheet 7: ICM Rate Rider Revenues"]
[]
[]
[]
[]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Rate Rider Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)",null,"Board Approved ICM Rate Rider","Board Approved ICM  Rate Rider\n(Cumm.)"]
[]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2018-01-01",{"$f":"YEAR(F24)","v":2018},{"$f":"IF(MONTH(F24)=0,\"\",IF(MONTH(F24)<4,\"Q1\",IF(MONTH(F24)<7,\"Q2\",IF(MONTH(F24)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G24,\" \",H24)","v":"2018 Q1"},0,null,{"$f":"VLOOKUP(I24,$B$22:$D$59,2)","v":1.4999999999999999E-2},{"$f":"ROUND(J24*L24/12,2)","v":0},{"$f":"K24+M24","v":0},null,null,{"$f":"P24","v":0}]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2018-02-01",{"$f":"YEAR(F25)","v":2018},{"$f":"IF(MONTH(F25)=0,\"\",IF(MONTH(F25)<4,\"Q1\",IF(MONTH(F25)<7,\"Q2\",IF(MONTH(F25)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G25,\" \",H25)","v":"2018 Q1"},{"$f":"J24+K24","v":0},null,1.4999999999999999E-2,{"$f":"ROUND(J25*L25/12,2)","v":0},{"$f":"N24+K25+M25","v":0},null,null,{"$f":"Q24+P25","v":0}]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2018-03-01",2018,"Q1","2018 Q1",{"$f":"J25+K25","v":0},null,1.4999999999999999E-2,0,{"$f":"N25+K26+M26","v":0},null,null,{"$f":"Q25+P26","v":0}]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,70994.739999999991,1.89E-2,0,70994.739999999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},67407.108186467289]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2018-06-01",2018,"Q2","2018 Q2",70994.739999999991,70981,1.89E-2,111.82,142087.56,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},134814.21637293458]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",141975.74,72735.350000000006,1.89E-2,223.61,215046.52,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},202221.32455940187]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2018-08-01",2018,"Q3","2018 Q3",214711.09,73743.539999999994,1.89E-2,338.17,289128.23,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},269628.43274586916]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2018-09-01",2018,"Q3","2018 Q3",288454.63,65536.56,1.89E-2,454.32,355119.11,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},337035.54093233647]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",353991.19,72992.200000000012,2.1700000000000001E-2,640.13,428751.44,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},404442.64911880379]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",426983.39,68939.11,2.1700000000000001E-2,772.13,498462.68,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},471849.75730527111]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",495922.5,70562.03,2.1700000000000001E-2,896.79,569921.5,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},539256.86549173843]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2019-01-01",2019,"Q1","2019 Q1",566484.53,69165.47,2.4500000000000001E-2,1156.57,640243.53999999992,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},606663.97367820574]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2019-02-01",2019,"Q1","2019 Q1",635650,63632.45,2.4500000000000001E-2,1297.79,705173.77999999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},674071.08186467306]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2019-03-01",2019,"Q1","2019 Q1",699282.45,71070.55,2.4500000000000001E-2,1427.7,777672.02999999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},741478.19005114038]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2019-04-01",2019,"Q2","2019 Q2",770353,71689.549999999988,2.18E-2,1399.47,850761.04999999981,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},808885.2982376077]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2019-05-01",2019,"Q2","2019 Q2",842042.55,69113.61,2.18E-2,1529.71,921404.36999999976,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},876292.40642407502]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",911156.16,69844.290000000008,2.18E-2,1655.27,992903.92999999982,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},943699.51461054233]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2019-07-01",2019,"Q3","2019 Q3",981000.45000000007,75344.87,2.18E-2,1782.15,1070030.9499999997,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1011106.6227970097]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2019-08-01",2019,"Q3","2019 Q3",1056345.32,69730.03,2.18E-2,1919.03,1141680.0099999998,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1078513.7309834769]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2019-09-01",2019,"Q3","2019 Q3",1126075.3500000001,65250.359999999986,2.18E-2,2045.7,1208976.0699999996,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1145920.8391699442]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-10-01",2019,"Q4","2019 Q4",1191325.71,71301.819999999992,2.18E-2,2164.2399999999998,1282442.1299999997,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1213327.9473564115]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-11-01",2019,"Q4","2019 Q4",1262627.53,68395.649999999994,2.18E-2,2293.77,1353131.5499999996,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1280735.0555428788]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2019-12-01",2019,"Q4","2019 Q4",1331023.18,71228.040000000008,2.18E-2,2418.0300000000002,1426777.6199999996,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1348142.1637293461]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2020-01-01",2020,"Q1","2020 Q1",1402251.22,68743.66,2.18E-2,{"$f":"ROUND(J48*L48/12,2)","v":2547.42},{"$f":"N47+K48+M48","v":1498068.6999999995},null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},{"$f":"Q47+P48","v":1415549.2719158134}]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2020-02-01",2020,"Q1","2020 Q1",1470994.88,66531.02,2.18E-2,2672.31,1567272.0299999996,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1482956.3801022808]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2020-03-01",2020,"Q1","2020 Q1",1537525.9,72391.399999999994,2.18E-2,2793.17,1642456.5999999994,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1550363.4882887481]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2020-04-01",2020,"Q2","2020 Q2",1609917.2999999998,64202.14,2.18E-2,2924.68,1709583.4199999992,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1617770.5964752154]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2020-05-01",2020,"Q2","2020 Q2",1674119.4399999997,65169.279999999999,2.18E-2,3041.32,1777794.0199999993,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1685177.7046616827]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-06-01",2020,"Q2","2020 Q2",1739288.7199999997,73478.83,2.18E-2,3159.71,1854432.5599999994,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1752584.81284815]
[null,"2025 Q3",{"$f":"C53","v":3.1600000000000003E-2},4.2299999999999997E-2,null,"2020-07-01",2020,"Q3","2020 Q3",1812767.5499999998,71690.66,5.7000000000000002E-3,861.06,1926984.2799999993,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1819991.9210346173]
[null,"2025 Q4",{"$f":"C54","v":3.1600000000000003E-2},4.2299999999999997E-2,null,"2020-08-01",2020,"Q3","2020 Q3",1884458.2099999997,70277.5,5.7000000000000002E-3,895.12,1998156.8999999994,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1887399.0292210847]
[null,"2026 Q1",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",1954735.7099999997,69546.3,5.7000000000000002E-3,928.5,2068631.6999999995,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},1954806.137407552]
[null,"2026 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",2024282.0099999998,70547.61,5.7000000000000002E-3,961.53,2140140.8399999994,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2022213.2455940193]
[null,"2026 Q3",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",2094829.6199999999,70384.240000000005,5.7000000000000002E-3,995.04,2211520.1199999996,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2089620.3537804866]
[null,"2026 Q4",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-12-01",2020,{"$f":"IF(MONTH(F59)=0,\"\",IF(MONTH(F59)<4,\"Q1\",IF(MONTH(F59)<7,\"Q2\",IF(MONTH(F59)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2020 Q4",2165213.86,74065.039999999994,5.7000000000000002E-3,1028.48,2286613.6399999997,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2157027.4619669537]
[null,null,null,null,null,"2021-01-01",2021,"Q1","2021 Q1",{"$f":"J59+K59","v":2239278.9},67037.72,{"$f":"VLOOKUP(I60,$B$22:$D$59,2)","v":5.7000000000000002E-3},1063.6600000000001,2354715.02,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2224434.5701534208]
[null,"Note: 2025-2026 Interest rates are forecasted. ",null,null,null,"2021-02-01",2021,"Q1","2021 Q1",2306316.62,66294.649999999994,5.7000000000000002E-3,1095.5,2422105.17,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2291841.6783398879]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",2372611.27,74422.22,5.7000000000000002E-3,1126.99,2497654.3800000004,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2359248.786526355]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",2447033.4900000002,60186.05,5.7000000000000002E-3,1162.3399999999999,2559002.77,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2426655.894712822]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",2507219.54,70777.8,5.7000000000000002E-3,1190.93,2630971.5,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2494063.0028992891]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",2577997.34,72016.36,5.7000000000000002E-3,1224.55,2704212.4099999997,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2561470.1110857562]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",2650013.6999999997,71705.08,5.7000000000000002E-3,1258.76,2777176.2499999995,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2628877.2192722233]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",2721718.78,73880.479999999996,5.7000000000000002E-3,1292.82,2852349.5499999993,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2696284.3274586904]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",2795599.26,67463.55,5.7000000000000002E-3,1327.91,2921141.0099999993,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2763691.4356451575]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",2863062.8099999996,69582.48,5.7000000000000002E-3,1359.95,2992083.4399999995,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2831098.5438316246]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",2932645.2899999996,72119.820000000007,5.7000000000000002E-3,1393.01,3065596.2699999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2898505.6520180916]
[null,null,null,null,null,"2021-12-01",2021,{"$f":"IF(MONTH(F71)=0,\"\",IF(MONTH(F71)<4,\"Q1\",IF(MONTH(F71)<7,\"Q2\",IF(MONTH(F71)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2021 Q4",3004765.1099999994,71002.820000000007,5.7000000000000002E-3,1427.26,3138026.3499999987,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},2965912.7602045587]
[null,null,null,null,null,"2022-01-01",{"$f":"YEAR(F72)","v":2022},{"$f":"IF(MONTH(F72)=0,\"\",IF(MONTH(F72)<4,\"Q1\",IF(MONTH(F72)<7,\"Q2\",IF(MONTH(F72)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2022 Q1",{"$f":"J71+K71","v":3075767.9299999992},68395.960000000006,{"$f":"VLOOKUP(I72,$B$22:$D$59,2)","v":5.7000000000000002E-3},{"$f":"ROUND(J72*L72/12,2)","v":1460.99},{"$f":"N71+K72+M72","v":3207883.2999999989},null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},{"$f":"Q71+P72","v":3033319.8683910258}]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",3144163.8899999992,66370.490000000005,5.7000000000000002E-3,1493.48,3275747.2699999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3100726.9765774929]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",3210534.3799999994,74288.17,5.7000000000000002E-3,1525,3351560.439999999,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3168134.08476396]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",3284822.5499999993,65158.84,1.0200000000000001E-2,2792.1,3419511.379999999,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3235541.1929504271]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",3349981.3899999992,71446.69,1.0200000000000001E-2,2847.48,3493805.5499999989,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3302948.3011368942]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",3421428.0799999991,72542.03,1.0200000000000001E-2,2908.21,3569255.7899999986,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3370355.4093233612]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",3493970.1099999989,72749.510000000009,2.1999999999999999E-2,6405.61,3648410.9099999988,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3437762.5175098283]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",3566719.6199999992,75817.78,2.1999999999999999E-2,6538.99,3730767.6799999988,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3505169.6256962954]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",3642537.399999999,67733.95,2.1999999999999999E-2,6677.99,3805179.6199999992,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3572576.7338827625]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",3710271.3499999992,70228.460000000006,3.8699999999999998E-2,11965.63,3887373.709999999,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3639983.8420692296]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",3780499.8099999991,67906.179999999993,3.8699999999999998E-2,12192.11,3967471.9999999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3707390.9502556967]
[null,null,null,null,null,"2022-12-01",2022,{"$f":"IF(MONTH(F83)=0,\"\",IF(MONTH(F83)<4,\"Q1\",IF(MONTH(F83)<7,\"Q2\",IF(MONTH(F83)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2022 Q4",3848405.9899999993,74500.81,3.8699999999999998E-2,12411.11,4054383.919999999,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3774798.0584421637]
[null,null,null,null,null,"2023-01-01",{"$f":"YEAR(F84)","v":2023},{"$f":"IF(MONTH(F84)=0,\"\",IF(MONTH(F84)<4,\"Q1\",IF(MONTH(F84)<7,\"Q2\",IF(MONTH(F84)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2023 Q1",{"$f":"J83+K83","v":3922906.7999999993},71517.890000000014,{"$f":"VLOOKUP(I84,$B$22:$D$59,2)","v":4.7300000000000002E-2},{"$f":"ROUND(J84*L84/12,2)","v":15462.79},{"$f":"N83+K84+M84","v":4141364.5999999992},null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},{"$f":"Q83+P84","v":3842205.1666286308}]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",3994424.6899999995,63999.99,4.7300000000000002E-2,15744.69,4221109.2799999993,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3909612.2748150979]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",4058424.6799999997,73151.510000000009,4.7300000000000002E-2,15996.96,4310257.7499999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},3977019.383001565]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",4131576.1899999995,70275.02,4.9799999999999997E-2,17146.04,4397678.8099999987,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4044426.4911880321]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",4201851.209999999,72961.789999999994,4.9799999999999997E-2,17437.68,4488078.2799999984,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4111833.5993744992]
[null,null,null,null,null,"2023-06-01",2023,"Q2",{"$f":"CONCATENATE(G89,\" \",H89)","v":"2023 Q2"},4274812.9999999991,70300.100000000006,4.9799999999999997E-2,17740.47,4576118.8499999978,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4179240.7075609663]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",4345113.0999999987,75010.829999999987,4.9799999999999997E-2,18032.22,4669161.8999999976,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4246647.8157474333]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",4420123.9299999988,70354.27,4.9799999999999997E-2,18343.509999999998,4757859.6799999969,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4314054.9239339009]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",4490478.1999999983,70528.91,4.9799999999999997E-2,18635.48,4847024.0699999975,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4381462.0321203684]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",4561007.1099999985,70438.7,5.4899999999999997E-2,20866.61,4938329.379999998,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4448869.140306836]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",4631445.8099999987,69189.22,5.4899999999999997E-2,21188.86,5028707.4599999981,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4516276.2484933035]
[null,null,null,null,null,"2023-12-01",2023,{"$f":"IF(MONTH(F95)=0,\"\",IF(MONTH(F95)<4,\"Q1\",IF(MONTH(F95)<7,\"Q2\",IF(MONTH(F95)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2023 Q4",4700635.0299999984,73860.23,5.4899999999999997E-2,21505.41,5124073.0999999987,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4583683.3566797711]
[null,null,null,null,null,"2024-01-01",{"$f":"YEAR(F96)","v":2024},{"$f":"IF(MONTH(F96)=0,\"\",IF(MONTH(F96)<4,\"Q1\",IF(MONTH(F96)<7,\"Q2\",IF(MONTH(F96)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2024 Q1",{"$f":"J95+K95","v":4774495.2599999988},72016.070000000007,{"$f":"VLOOKUP(I96,$B$22:$D$59,2)","v":5.4899999999999997E-2},{"$f":"ROUND(J96*L96/12,2)","v":21843.32},{"$f":"N95+K96+M96","v":5217932.4899999993},null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},{"$f":"Q95+P96","v":4651090.4648662386}]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",4846511.3299999991,67661.740000000005,5.4899999999999997E-2,22172.79,5307767.0199999996,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4718497.5730527062]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",4914173.0699999994,70376.429999999993,5.4899999999999997E-2,22482.34,5400625.7899999991,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4785904.6812391737]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",4984549.4999999991,71976.639999999999,5.4899999999999997E-2,22804.31,5495406.7399999984,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4853311.7894256413]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",5056526.1399999987,70641.25,5.4899999999999997E-2,23133.61,5589181.5999999987,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4920718.8976121088]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",5127167.3899999987,74732.09,5.4899999999999997E-2,23456.79,5687370.4799999986,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},4988126.0057985764]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",5201899.4799999986,73037.5,5.1999999999999998E-2,22541.56,5782949.5399999982,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5055533.113985044]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",5274936.9799999986,75337.2,5.1999999999999998E-2,22858.06,5881144.799999998,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5122940.2221715115]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",5350274.1799999988,72052.97,5.1999999999999998E-2,23184.52,5976382.2899999972,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5190347.3303579791]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",5422327.1499999985,70181.7,4.3999999999999997E-2,19881.87,6066445.8599999975,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5257754.4385444466]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",5492508.8499999987,71160.91,4.3999999999999997E-2,20139.2,6157745.9699999979,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5325161.5467309142]
[null,null,null,null,null,"2024-12-01",2024,{"$f":"IF(MONTH(F107)=0,\"\",IF(MONTH(F107)<4,\"Q1\",IF(MONTH(F107)<7,\"Q2\",IF(MONTH(F107)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2024 Q4",5563669.7599999988,70757.279999999999,4.3999999999999997E-2,20400.12,6248903.3699999982,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5392568.6549173817]
[null,null,null,null,null,"2025-01-01",{"$f":"YEAR(F108)","v":2025},{"$f":"IF(MONTH(F108)=0,\"\",IF(MONTH(F108)<4,\"Q1\",IF(MONTH(F108)<7,\"Q2\",IF(MONTH(F108)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2025 Q1",{"$f":"J107+K107","v":5634427.0399999991},74712.759999999995,{"$f":"VLOOKUP(I108,$B$22:$D$59,2)","v":3.6400000000000002E-2},{"$f":"ROUND(J108*L108/12,2)","v":17091.099999999999},{"$f":"N107+K108+M108","v":6340707.2299999977},null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},{"$f":"Q107+P108","v":5459975.7631038493}]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",5709139.7999999989,67774.81,3.6400000000000002E-2,17317.72,6425799.759999997,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5527382.8712903168]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",5776914.6099999985,72607.12,3.6400000000000002E-2,17523.310000000001,6515930.1899999967,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5594789.9794767844]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",5849521.7299999986,69309.179999999993,3.1600000000000003E-2,15403.74,6600643.1099999966,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5662197.0876632519]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",5918830.9099999983,72098.295230684933,{"$f":"VLOOKUP(I112,$B$22:$D$59,2)","v":3.1600000000000003E-2},15586.25,6688327.6552306814,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5729604.1958497195]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",5990929.2052306831,73132.17409863013,3.1600000000000003E-2,15776.11,6777235.9393293122,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5797011.304036187]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",6064061.3793293135,77786.212674520531,3.1600000000000003E-2,15968.69,6870990.8420038335,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5864418.4122226546]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",6141847.5920038344,74299.901334794529,3.1600000000000003E-2,16173.53,6961464.273338628,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5931825.5204091221]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",6216147.4933386287,70340.61535342464,3.1600000000000003E-2,16369.19,7048174.0786920534,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},5999232.6285955897]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",6286488.1086920537,72455.208100273958,3.1600000000000003E-2,16554.419999999998,7137183.7067923276,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6066639.7367820572]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",6358943.3167923279,71495.002309589036,3.1600000000000003E-2,16745.22,7225423.929101916,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6134046.8449685248]
[null,null,null,null,null,"2025-12-01",2025,{"$f":"IF(MONTH(F119)=0,\"\",IF(MONTH(F119)<4,\"Q1\",IF(MONTH(F119)<7,\"Q2\",IF(MONTH(F119)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2025 Q4",6430438.3191019166,73634.725669589039,3.1600000000000003E-2,16933.490000000002,7315992.1447715051,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6201453.9531549923]
[null,null,null,null,null,"2026-01-01",{"$f":"YEAR(F120)","v":2026},{"$f":"IF(MONTH(F120)=0,\"\",IF(MONTH(F120)<4,\"Q1\",IF(MONTH(F120)<7,\"Q2\",IF(MONTH(F120)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2026 Q1",{"$f":"J119+K119","v":6504073.0447715055},73727.824818630135,{"$f":"VLOOKUP(I120,$B$22:$D$59,2)","v":3.1600000000000003E-2},{"$f":"ROUND(J120*L120/12,2)","v":17127.39},{"$f":"N119+K120+M120","v":7406847.3595901346},null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},{"$f":"Q119+P120","v":6268861.0613414599}]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",6577800.8695901353,66401.676486575336,3.1600000000000003E-2,17321.54,7490570.5760767097,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6336268.1695279274]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",6644202.5460767103,72423.149668493148,3.1600000000000003E-2,17496.400000000001,7580490.1257452033,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6403675.277714395]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",6716625.6957452036,70669.91196164384,3.1600000000000003E-2,17687.11,7668847.1477068476,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6471082.3859008625]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",6787295.6077068476,72573.422926027401,3.1600000000000003E-2,17873.21,7759293.7806328749,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6538489.4940873301]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",6859869.0306328749,73637.883928767114,3.1600000000000003E-2,18064.32,7850995.9845616426,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6605896.6022737976]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",6933506.9145616423,78343.844847671236,3.1600000000000003E-2,18258.23,7947598.0594093148,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6673303.7104602652]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",7011850.759409314,74813.1696120548,3.1600000000000003E-2,18464.54,8040875.7690213695,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6740710.8186467327]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",7086663.9290213687,70781.558884931495,3.1600000000000003E-2,18661.55,8130318.8779063011,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6808117.9268332003]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",7157445.4879063005,72894.988537534242,3.1600000000000003E-2,18847.939999999999,8222061.8064438356,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6875525.0350196678]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",7230340.4764438346,71941.510720547943,3.1600000000000003E-2,19039.900000000001,8313043.2171643842,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},6942932.1432061354]
[null,null,null,null,null,"2026-12-01",2026,{"$f":"IF(MONTH(F131)=0,\"\",IF(MONTH(F131)<4,\"Q1\",IF(MONTH(F131)<7,\"Q2\",IF(MONTH(F131)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2026 Q4",7302281.9871643828,74083.513193424646,3.1600000000000003E-2,19229.34,8406356.0703578088,null,{"$f":"'6. ICMIRR_2018'!$K$88/12","v":67407.108186467289},7010339.2513926029]

{"sheet":"8. Opex Interest Annual","index":7,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the interest on amortization/depreciation expense, in the absence of monthly data."]
[]
[]
[null,"Sheet 8: Interest on Amortization (Annual Data) "]
[]
[]
[]
[]
[null,"Year",null,"OM&A",null,"Amortization Expense",null,"Cumulative OM&A and Amortization Expense",null,"Average Cumulative OM&A and Amortization Expense",null,"Average Annual Prescribed Interest Rate for Deferral and Variance Accounts (from Sheet 7)",null,"Simple Interest on OM&A and Amortization Expenses"]
[null,null,null,null,null,"(from Sheet 6)"]
[null,2018,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":344837.60364464635},null,{"$f":"D23+F23","v":344837.60364464635},null,{"$f":"H23/2","v":172418.80182232318},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C24:C27)","v":1.8624999999999999E-2},null,{"$f":"J23*L23","v":3211.3001839407689}]
[null,2019,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!K357","v":344837.60364464635},null,{"$f":"H23+D24+F24","v":689675.20728929271},null,{"$f":"(H24+H23)/2","v":517256.40546696953},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C28:C31)","v":2.2474999999999998E-2},null,{"$f":"J24*L24","v":11625.33771287014}]
[null,2020,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!M357","v":344837.60364464635},null,{"$f":"H24+D25+F25","v":1034512.8109339391},null,{"$f":"(H25+H24)/2","v":862094.00911161583},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C32:C35)","v":1.3749999999999998E-2},null,11853.792625284716]
[null,2021,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!O357","v":344837.60364464635},null,1379350.4145785854,null,1206931.6127562623,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C36:C39)","v":5.7000000000000002E-3},null,6879.5101927106953]
[null,2022,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!Q357","v":344837.60364464635},null,{"$f":"H26+D27+F27","v":1724188.0182232317},null,1551769.2164009085,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C40:C43)","v":1.915E-2},null,29716.380494077399]
[null,2023,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!S357","v":344837.60364464635},null,2069025.6218678779,null,1896606.8200455548,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C44:C47)","v":5.0449999999999995E-2},null,95683.814071298228]
[null,2024,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!U357","v":344837.60364464635},null,2413863.2255125241,null,2241444.4236902008,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C48:C51)","v":5.1449999999999996E-2},null,115322.31559886082]
[null,2025,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!W357","v":311550.8206555557},null,2725414.0461680796,null,2569638.6358403019,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C52:C55)","v":3.2800000000000003E-2},null,84284.147255561911]
[null,2026,null,0,null,{"$f":"F30","v":311550.8206555557},null,3036964.8668236351,null,2881189.4564958573,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C56:C59)","v":3.1600000000000003E-2},null,{"$f":"J31*L31","v":91045.5868252691}]
[]
[]
[null,"Cumulative Interest to 2018",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N23)","v":3211.3001839407689}]
[null,"Cumulative Interest to 2019",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N24)","v":14836.637896810909}]
[null,"Cumulative Interest to 2020",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N25)","v":26690.430522095623}]
[null,"Cumulative Interest to 2021",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N26)","v":33569.940714806318}]
[null,"Cumulative Interest to 2022",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N27)","v":63286.321208883717}]
[null,"Cumulative Interest to 2023",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N28)","v":158970.13528018194}]
[null,"Cumulative Interest to 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N29)","v":274292.45087904274}]
[null,"Cumulative Interest to 2025",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N30)","v":358576.59813460463}]
[null,"Cumulative Interest to 2026",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N31)","v":449622.18495987373}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,26],[19,2,19,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the ICM Incremental Revenue Requirement."]
[]
[]
[null,"Sheet 9: ICM Incremental Revenue Requirement"]
[null,null," "]
[]
[null,null,null,null,null,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,{"$f":"'6. ICMIRR_2018'!$F$88/12*8","v":734583.33844232699},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"'6. ICMIRR_2018'!$F$88","v":1101875.0076634905},null,{"$f":"SUM(G22:W22)","v":9549583.3997502495}]
[]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,{"$f":"'8. Opex Interest Annual'!$N$23","v":3211.3001839407689},null,{"$f":"'8. Opex Interest Annual'!$N$24","v":11625.33771287014},null,{"$f":"'8. Opex Interest Annual'!$N$25","v":11853.792625284716},null,{"$f":"'8. Opex Interest Annual'!$N$26","v":6879.5101927106953},null,{"$f":"'8. Opex Interest Annual'!$N$27","v":29716.380494077399},null,{"$f":"'8. Opex Interest Annual'!$N$28","v":95683.814071298228},null,{"$f":"'8. Opex Interest Annual'!$N$29","v":115322.31559886082},null,{"$f":"'8. Opex Interest Annual'!$N$30","v":84284.147255561911},null,{"$f":"'8. Opex Interest Annual'!$N$31","v":91045.5868252691},null,{"$f":"SUM(G24:W24)","v":449622.18495987373}]
[]
[]
[null,null,"ICM Rate Rider Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Rider Revs'!K26:K35)","v":566484.53},null,{"$f":"SUM('7. Rate Rider Revs'!K36:K47)","v":835766.69},null,{"$f":"SUM('7. Rate Rider Revs'!K48:K59)","v":837027.68},null,{"$f":"SUM('7. Rate Rider Revs'!K60:K71)","v":836489.03},null,{"$f":"SUM('7. Rate Rider Revs'!K72:K83)","v":847138.86999999988},null,{"$f":"SUM('7. Rate Rider Revs'!K84:K95)","v":851588.46},null,{"$f":"SUM('7. Rate Rider Revs'!K96:K107)","v":859931.77999999991},null,{"$f":"SUM('7. Rate Rider Revs'!K108:K119)","v":869646.00477150676},null,{"$f":"SUM('7. Rate Rider Revs'!K120:K131)","v":872292.4555863014},null,{"$f":"SUM(G27:W27)","v":7376365.5003578076}]
[]
[null,null,"ICM Rate Rider Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Rider Revs'!M27:M35)","v":3436.9700000000003},null,{"$f":"SUM('7. Rate Rider Revs'!M36:M47)","v":21089.43},null,{"$f":"SUM('7. Rate Rider Revs'!M48:M59)","v":22808.34},null,{"$f":"SUM('7. Rate Rider Revs'!M60:M71)","v":14923.680000000002},null,{"$f":"SUM('7. Rate Rider Revs'!M72:M83)","v":69218.7},null,{"$f":"SUM('7. Rate Rider Revs'!M84:M95)","v":218100.72},null,{"$f":"SUM('7. Rate Rider Revs'!M96:M107)","v":264898.49},null,{"$f":"SUM('7. Rate Rider Revs'!M108:M119)","v":197442.77},null,{"$f":"SUM('7. Rate Rider Revs'!M120:M131)","v":218071.46999999997},null,{"$f":"SUM(G29:W29)","v":1029990.57}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":167873.13862626778},null,{"$f":"(I22+I24)-(I27+I29)","v":256644.2253763607},null,{"$f":"(K22+K24)-(K27+K29)","v":253892.78028877522},null,{"$f":"(M22+M24)-(M27+M29)","v":257341.80785620108},null,{"$f":"(O22+O24)-(O27+O29)","v":215233.81815756811},null,{"$f":"(Q22+Q24)-(Q27+Q29)","v":127869.64173478889},null,{"$f":"(S22+S24)-(S27+S29)","v":92367.053262351314},null,{"$f":"(U22+U24)-(U27+U29)","v":119070.38014754583},null,{"$f":"(W22+W24)-(W27+W29)","v":102556.66890245816},null,{"$f":"(Y22+Y24)-(Y27+Y29)","v":1592849.514352316}]