{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["1. Utility_Info_","2. ICM_Costs","3. Cost_of_Service_Parameters","4. ICM_Assets_and_Rate_Base","5. UCC_Calculation","6. ICMIRR ","7. 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":[[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 - 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,"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","2019-Leaking Transformer Replacement Project - Overhead/Padmount/Vault",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,2019,null,2015,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual",null,"Forecast"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"SYSTEM ACCESS",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(I19),\"\",I19)","v":"Forecast"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G42,I42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G44,I44)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G46,I46)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G48,I48)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G50,I50)","v":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,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":0},null,{"$f":"SUM(I42,I44,I46,I48,I50,I52,I54,I56,I58,I60)","v":0},null,{"$f":"SUM(K42,K44,K46,K48,K50,K52,K54,K56,K58,K60)","v":0}]
[]
[null,null,null,null,{"$f":"E40","v":"Asset Type"}]
[null,null,"SYSTEM RENEWAL",null,null,null,{"$f":"G41","v":"Audited Actual"},null,{"$f":"I41","v":"Forecast"}]
[null,null,null,null,"OH Swtch & Cpctrs",null,91095.4476,null,null,null,{"$f":"SUM(G66,I66)","v":91095.4476}]
[]
[null,null,null,null,"Wood Poles",null,556694.402,null,null,null,{"$f":"SUM(G68,I68)","v":556694.402}]
[]
[null,null,null,null,"OH Transformers",null,101217.164,null,null,null,{"$f":"SUM(G70,I70)","v":101217.164}]
[]
[null,null,null,null,"OH Prim Cond & Dev",null,151825.74599999998,null,null,null,{"$f":"SUM(G72,I72)","v":151825.74599999998}]
[]
[null,null,null,null,"OH Sec Cond & Dev",null,50608.582000000002,null,null,null,{"$f":"SUM(G74,I74)","v":50608.582000000002}]
[]
[null,null,null,null,"UG Transformers",null,2794878.9040000001,null,null,null,{"$f":"SUM(G76,I76)","v":2794878.9040000001}]
[]
[null,null,null,null,"UG Prim XLPE TR",null,379725.0122,null,null,null,{"$f":"SUM(G78,I78)","v":379725.0122}]
[]
[null,null,null,null,"UG Sec - Dir Buried",null,205045.08069999999,null,null,null,{"$f":"SUM(G80,I80)","v":205045.08069999999}]
[]
[null,null,null,null,"UG Sec In Duct/Svs",null,174679.93150000001,null,null,null,{"$f":"SUM(G82,I82)","v":174679.93150000001}]
[]
[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":4505770.2699999996},null,{"$f":"SUM(I66,I68,I70,I72,I74,I76,I78,I80,I82,I84)","v":0},null,{"$f":"SUM(K66,K68,K70,K72,K74,K76,K78,K80,K82,K84)","v":4505770.2699999996}]
[]
[null,null,null,null,{"$f":"E64","v":"Asset Type"}]
[null,null,"SYSTEM SERVICE",null,null,null,{"$f":"G65","v":"Audited Actual"},null,{"$f":"I65","v":"Forecast"}]
[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,{"$f":"SUM(I90,I92,I94,I96,I98,I100,I102,I104,I106,I108)","v":0},null,{"$f":"SUM(K90,K92,K94,K96,K98,K100,K102,K104,K106,K108)","v":0}]
[]
[null,null,null,null,{"$f":"E88","v":"Asset Type"}]
[null,null,"GENERAL PLANT",null,null,null,"Audited Actual",null,{"$f":"I89","v":"Forecast"}]
[]
[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,{"$f":"SUM(I115,I117,I119,I121,I123,I125,I127,I129,I131,I133)","v":0},null,{"$f":"SUM(K115,K117,K119,K121,K123,K125,K127,K129,K131,K133)","v":0}]
[]
[null,null,null,null,{"$f":"E112","v":"Asset Type"}]
[null,null,null,null,null,null,"Audited Actual",null,{"$f":"I113","v":"Forecast"}]
[]
[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,{"$f":"SUM(F140,F142,F144,F146,F148,F150,F152,F154,F156,F158)","v":0},0,null,{"$f":"SUM(I140,I142,I144,I146,I148,I150,I152,I154,I156,I158)","v":0},null,{"$f":"SUM(K140,K142,K144,K146,K148,K150,K152,K154,K156,K158)","v":0}]
[]
[null,null,"Total Capital Costs Related to Incremental Capital Projects (ICP)",null,null,null,{"$f":"SUM(G62,G86,G110,G135,G160)","v":4505770.2699999996},null,{"$f":"SUM(I62,I86,I110,I135,I160)","v":0},null,{"$f":"SUM(K62,K86,K110,K135,K160)","v":4505770.2699999996}]
[]
[null,null,null,null,{"$f":"E137","v":"Asset Type"}]
[null,null,"OTHER CAPITAL COST",null,null,null,"Audited Actual",null,{"$f":"I138","v":"Forecast"}]
[]
[null,null,"A",null,null,null,null,null,null,null,{"$f":"SUM(G167,I167)","v":0}]
[]
[null,null,"B",null,null,null,null,null,null,null,{"$f":"SUM(G169,I169)","v":0}]
[]
[null,null,"C",null,null,null,null,null,null,null,{"$f":"SUM(G171,I171)","v":0}]
[]
[null,null,"Total Other Capital Costs ",null,null,null,{"$f":"SUM(G167,G169,G171)","v":0},null,{"$f":"SUM(I167,I169,I171)","v":0},null,{"$f":"SUM(K167,K169,K171)","v":0}]
[]
[null,null,"Total ICM Capital Costs",null,null,null,{"$f":"G162+G173","v":4505770.2699999996},null,{"$f":"I162+I173","v":0},null,{"$f":"K162+K173","v":4505770.2699999996}]
[]
[]
[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":91095.4476},null,{"$f":"SUMIF($E$42:$E$171,$D182,I$42:I$171)","v":0},null,{"$f":"SUM(G182:J182)","v":91095.4476}]
[]
[null,null,120223,"Concrete Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D184,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D184,I$42:I$171)","v":0},null,{"$f":"SUM(G184:J184)","v":0}]
[]
[null,null,120221,"Wood Poles",1830,null,{"$f":"SUMIF($E$42:$E$171,$D186,G$42:G$171)","v":556694.402},null,{"$f":"SUMIF($E$42:$E$171,$D186,I$42:I$171)","v":0},null,{"$f":"SUM(G186:J186)","v":556694.402}]
[]
[null,null,120225,"OH Transformers",1850,null,{"$f":"SUMIF($E$42:$E$171,$D188,G$42:G$171)","v":101217.164},null,{"$f":"SUMIF($E$42:$E$171,$D188,I$42:I$171)","v":0},null,{"$f":"SUM(G188:J188)","v":101217.164}]
[]
[null,null,120224,"OH Prim Cond & Dev",1835,null,{"$f":"SUMIF($E$42:$E$171,$D190,G$42:G$171)","v":151825.74599999998},null,{"$f":"SUMIF($E$42:$E$171,$D190,I$42:I$171)","v":0},null,{"$f":"SUM(G190:J190)","v":151825.74599999998}]
[]
[null,null,120226,"OH Sec Cond & Dev",1855,null,{"$f":"SUMIF($E$42:$E$171,$D192,G$42:G$171)","v":50608.582000000002},null,{"$f":"SUMIF($E$42:$E$171,$D192,I$42:I$171)","v":0},null,{"$f":"SUM(G192:J192)","v":50608.582000000002}]
[]
[null,null,120243,"UG Transformers",1850,null,{"$f":"SUMIF($E$42:$E$171,$D194,G$42:G$171)","v":2794878.9040000001},null,{"$f":"SUMIF($E$42:$E$171,$D194,I$42:I$171)","v":0},null,{"$f":"SUM(G194:J194)","v":2794878.9040000001}]
[]
[null,null,120245,"UG Conduit",1840,null,{"$f":"SUMIF($E$42:$E$171,$D196,G$42:G$171)","v":0},null,{"$f":"SUMIF($E$42:$E$171,$D196,I$42:I$171)","v":0},null,{"$f":"SUM(G196:J196)","v":0}]
[]
[null,null,"120241.XLPETR","UG Prim XLPE TR",1845,null,{"$f":"SUMIF($E$42:$E$171,$D198,G$42:G$171)","v":379725.0122},null,{"$f":"SUMIF($E$42:$E$171,$D198,I$42:I$171)","v":0},null,{"$f":"SUM(G198:J198)","v":379725.0122}]
[]
[null,null,"120242.DB","UG Sec - Dir Buried",1845,null,{"$f":"SUMIF($E$42:$E$171,$D200,G$42:G$171)","v":205045.08069999999},null,{"$f":"SUMIF($E$42:$E$171,$D200,I$42:I$171)","v":0},null,{"$f":"SUM(G200:J200)","v":205045.08069999999}]
[]
[null,null,"120242.IDSERV","UG Sec In Duct/Svs",1845,null,{"$f":"SUMIF($E$42:$E$171,$D202,G$42:G$171)","v":174679.93150000001},null,0,null,174679.93150000001]
[]
[null,null,120248,"Air Insulated Switchgear",1845,null,0,null,0,null,0]
[]
[null,null,120249,"Solid Dielectric Switchgear",1845,null,0,null,0,null,0]
[]
[null,null,120244,"UG Cable Injection",1845,null,0,null,0,null,0]
[]
[null,null,"120063.MS","MS Integrated P&C Systems ",1820,null,0,null,0,null,0]
[]
[null,null,"120021.MS","MS Building Improvements ",1820,null,0,null,0,null,0]
[]
[null,null,130104,"Capital Contributions Paid ",1609,null,0,null,0,null,0]
[]
[]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G182:G215)","v":4505770.2699999996},null,{"$f":"SUM(I182:I215)","v":0},null,{"$f":"SUM(K182:K214)","v":4505770.2699999996}]
[null,null,null,null,null,null,{"$f":"IF(G219=G175,\" \",\"Error\")","v":" "},null,{"$f":"IF(I219=I175,\"\",\"Error\")","v":""},null,{"$f":"IF(K219=K175,\"\",\"Error\")","v":""}]

{"sheet":"3. Cost_of_Service_Parameters","index":2,"n_rows":140,"n_cols":21,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 3: Parameters and Rates"]
[]
[null,null,null,null,null,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,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,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,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,null,"Cost of Capital Parameters"]
[null,null,null,"Deemed Short-term Debt Rate",null,null,2.0799999999999999E-2,null,2.1600000000000001E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2,null,2.0799999999999999E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,5.0914000000000001E-2,null,3.9100000000000003E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2,null,5.0914000000000001E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2,null,8.9300000000000004E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":5.8480000000000004E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(O22:O25,O29:O32)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(Q22:Q25,Q29:Q32)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(S22:S25,S29:S32)","v":6.5063840000000012E-2},null,{"$f":"SUMPRODUCT(U22:U25,U29:U32)","v":6.5063840000000012E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001,null,0.13500000000000001]
[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,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,"Depreciation Rates",null,null,"Account"]
[null,"(expressed as expected useful life in years)"]
[null,null,"OH Swtch & Cpctrs",null,1835,null,38,null,38,null,38,null,38,null,38,null,38,null,35,null,35]
[null,null,"                              - rate (%)",null,null,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.8571428571428571E-2,null,2.8571428571428571E-2]
[null,null,"Concrete Poles",null,1830,null,51,null,51,null,51,null,51,null,51,null,51,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,1.9607843137254902E-2,null,1.9607843137254902E-2,null,1.9607843137254902E-2,null,1.9607843137254902E-2,null,1.9607843137254902E-2,null,1.9607843137254902E-2,null,1.6666666666666666E-2,null,1.6666666666666666E-2]
[null,null,"Wood Poles",null,1830,null,44,null,44,null,44,null,44,null,44,null,44,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.2727272727272728E-2,null,2.2727272727272728E-2,null,2.2727272727272728E-2,null,2.2727272727272728E-2,null,2.2727272727272728E-2,null,2.2727272727272728E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"OH Transformers",null,1850,null,41,null,41,null,41,null,41,null,41,null,41,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.4390243902439025E-2,null,2.4390243902439025E-2,null,2.4390243902439025E-2,null,2.4390243902439025E-2,null,2.4390243902439025E-2,null,2.4390243902439025E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"OH Prim Cond & Dev",null,1835,null,45,null,45,null,45,null,45,null,45,null,45,null,50,null,50]
[null,null,"                             - rate (%)",null,null,null,2.2222222222222223E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2,null,0.02,null,0.02]
[null,null,"OH Sec Cond & Dev",null,1855,null,48,null,48,null,48,null,48,null,48,null,48,null,50,null,50]
[null,null,"                             - rate (%)",null,null,null,2.0833333333333332E-2,null,2.0833333333333332E-2,null,2.0833333333333332E-2,null,2.0833333333333332E-2,null,2.0833333333333332E-2,null,2.0833333333333332E-2,null,0.02,null,0.02]
[null,null,"UG Transformers",null,1850,null,32,null,32,null,32,null,32,null,32,null,32,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,3.125E-2,null,3.125E-2,null,3.125E-2,null,3.125E-2,null,3.125E-2,null,3.125E-2,null,3.3333333333333333E-2,null,3.3333333333333333E-2]
[null,null,"UG Conduit",null,1840,null,52,null,52,null,52,null,52,null,52,null,52,null,60,null,60]
[null,null,"                             - rate (%)",null,null,null,1.9230769230769232E-2,null,1.9230769230769232E-2,null,1.9230769230769232E-2,null,1.9230769230769232E-2,null,1.9230769230769232E-2,null,1.9230769230769232E-2,null,1.6666666666666666E-2,null,1.6666666666666666E-2]
[null,null,"UG Prim XLPE TR",null,1845,null,38,null,38,null,38,null,38,null,38,null,38,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.6315789473684209E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"UG Sec - Dir Buried",null,1845,null,31,null,31,null,31,null,31,null,31,null,31,null,30,null,30]
[null,null,"                             - rate (%)",null,null,null,3.2258064516129031E-2,null,3.2258064516129031E-2,null,3.2258064516129031E-2,null,3.2258064516129031E-2,null,3.2258064516129031E-2,null,3.2258064516129031E-2,null,3.3333333333333333E-2,null,3.3333333333333333E-2]
[null,null,"UG Sec In Duct/Svs",null,1845,null,37,null,37,null,37,null,37,null,37,null,37,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,2.7027027027027029E-2,null,2.7027027027027029E-2,null,2.7027027027027029E-2,null,2.7027027027027029E-2,null,2.7027027027027029E-2,null,2.7027027027027029E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2]
[null,null,"Air Insulated Switchgear",null,1845,null,39,null,39,null,39,null,39,null,39,null,39,null,35,null,35]
[null,null,"                             - rate (%)",null,null,null,2.564102564102564E-2,null,2.564102564102564E-2,null,2.564102564102564E-2,null,2.564102564102564E-2,null,2.564102564102564E-2,null,2.564102564102564E-2,null,2.8571428571428571E-2,null,2.8571428571428571E-2]
[null,null,"Solid Dielectric Switchgear",null,1845,null,42,null,42,null,42,null,42,null,42,null,42,null,45,null,45]
[null,null,"                             - rate (%)",null,null,null,2.3809523809523808E-2,null,2.3809523809523808E-2,null,2.3809523809523808E-2,null,2.3809523809523808E-2,null,2.3809523809523808E-2,null,2.3809523809523808E-2,null,2.2222222222222223E-2,null,2.2222222222222223E-2]
[null,null,"UG Cable Injection",null,1845,null,24,null,24,null,24,null,24,null,24,null,24,null,20,null,20]
[null,null,"                             - rate (%)",null,null,null,4.1666666666666664E-2,null,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,36,null,36,null,36,null,36,null,36,null,15,null,15]
[null,null,"                             - rate (%)",null,null,null,2.7777777777777776E-2,null,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,21,null,21,null,21,null,21,null,21,null,25,null,25]
[null,null,"                             - rate (%)",null,null,null,4.7619047619047616E-2,null,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,40,null,40,null,40,null,40,null,40,null,40,null,40]
[null,null,"                             - rate (%)",null,null,null,{"$f":"IF(G77=0,0,1/G77)","v":2.5000000000000001E-2},null,{"$f":"IF(I77=0,0,1/I77)","v":2.5000000000000001E-2},null,{"$f":"IF(K77=0,0,1/K77)","v":2.5000000000000001E-2},null,{"$f":"IF(M77=0,0,1/M77)","v":2.5000000000000001E-2},null,{"$f":"IF(O77=0,0,1/O77)","v":2.5000000000000001E-2},null,{"$f":"IF(Q77=0,0,1/Q77)","v":2.5000000000000001E-2},null,{"$f":"IF(S77=0,0,1/S77)","v":2.5000000000000001E-2},null,{"$f":"IF(U77=0,0,1/U77)","v":2.5000000000000001E-2}]
[]
[]
[]
[null,"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,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,null,"Concrete Poles - CCA Class",null,null,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,null,"Wood Poles - CCA Class",null,null,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,null,"OH Transformers - CCA Class",null,null,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,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,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,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,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,null,"UG Transformers - CCA Class",null,null,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,null,"OH  Services - CCA Class",null,null,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,null,"UG Conduit - CCA Class",null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,"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":23,"rows_kept":357,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet 4: ICM Assets - Net Book Value"]
[null,null,null,null,null,null,null,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":91095.4476},null,{"$f":"K25","v":91095.4476},null,{"$f":"M25","v":91095.4476},null,{"$f":"O25","v":91095.4476},null,{"$f":"Q25","v":91095.4476},null,{"$f":"S25","v":91095.4476},null,{"$f":"U25","v":91095.4476}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G182","v":91095.4476},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":91095.4476},null,{"$f":"K22+K23-K24","v":91095.4476},null,{"$f":"M22+M23-M24","v":91095.4476},null,{"$f":"O22+O23-O24","v":91095.4476},null,{"$f":"Q22+Q23-Q24","v":91095.4476},null,{"$f":"S22+S23-S24","v":91095.4476},null,{"$f":"U22+U23-U24","v":91095.4476},null,{"$f":"W22+W23-W24","v":91095.4476}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":-2397.2486210526317},null,{"$f":"K31","v":-4794.4972421052635},null,{"$f":"M31","v":-7191.7458631578957},null,{"$f":"O31","v":-9588.9944842105269},null,{"$f":"Q31","v":-11986.243105263158},null,{"$f":"S31","v":-14383.491726315789},null,{"$f":"U31","v":-16986.218800601506}]
[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":-2397.2486210526317},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":-2397.2486210526317},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":-2397.2486210526317},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":-2397.2486210526317},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":-2397.2486210526317},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":-2397.2486210526317},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":-2602.7270742857145},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":-2602.7270742857145}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":-2397.2486210526317},null,{"$f":"K28+K29-K30","v":-4794.4972421052635},null,{"$f":"M28+M29-M30","v":-7191.7458631578957},null,{"$f":"O28+O29-O30","v":-9588.9944842105269},null,{"$f":"Q28+Q29-Q30","v":-11986.243105263158},null,{"$f":"S28+S29-S30","v":-14383.491726315789},null,{"$f":"U28+U29-U30","v":-16986.218800601506},null,{"$f":"W28+W29-W30","v":-19588.94587488722}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,{"$f":"I35","v":88698.198978947374},null,{"$f":"K35","v":86300.950357894733},null,{"$f":"M35","v":83903.701736842107},null,{"$f":"O35","v":81506.453115789467},null,{"$f":"Q35","v":79109.204494736841},null,{"$f":"S35","v":76711.955873684215},null,{"$f":"U35","v":74109.228799398494}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":88698.198978947374},null,{"$f":"K25+K31","v":86300.950357894733},null,{"$f":"M25+M31","v":83903.701736842107},null,{"$f":"O25+O31","v":81506.453115789467},null,{"$f":"Q25+Q31","v":79109.204494736841},null,{"$f":"S25+S31","v":76711.955873684215},null,{"$f":"U25+U31","v":74109.228799398494},null,{"$f":"W25+W31","v":71506.501725112787}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":88698.198978947374},null,{"$f":"AVERAGE(K34:K35)","v":87499.574668421061},null,{"$f":"AVERAGE(M34:M35)","v":85102.32604736842},null,{"$f":"AVERAGE(O34:O35)","v":82705.07742631578},null,{"$f":"AVERAGE(Q34:Q35)","v":80307.828805263154},null,{"$f":"AVERAGE(S34:S35)","v":77910.580184210528},null,{"$f":"AVERAGE(U34:U35)","v":75410.592336541362},null,{"$f":"AVERAGE(W34:W35)","v":72807.86526225564}]
[]
[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":0},null,{"$f":"K44","v":0},null,{"$f":"M44","v":0},null,{"$f":"O44","v":0},null,{"$f":"Q44","v":0},null,{"$f":"S44","v":0},null,{"$f":"U44","v":0}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G184","v":0},null,{"$f":"'2. ICM_Costs'!I184","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I41+I42-I43","v":0},null,{"$f":"K41+K42-K43","v":0},null,{"$f":"M41+M42-M43","v":0},null,{"$f":"O41+O42-O43","v":0},null,{"$f":"Q41+Q42-Q43","v":0},null,{"$f":"S41+S42-S43","v":0},null,{"$f":"U41+U42-U43","v":0},null,{"$f":"W41+W42-W43","v":0}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":0},null,{"$f":"K50","v":0},null,{"$f":"M50","v":0},null,{"$f":"O50","v":0},null,{"$f":"Q50","v":0},null,{"$f":"S50","v":0},null,{"$f":"U50","v":0}]
[null,null,null,"Amortization expense during year",null,null,null,null,{"$f":"IF(ISERROR(-(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47)))), 0, -(I42/('3. Cost_of_Service_Parameters'!G47)+MIN((I41/'3. Cost_of_Service_Parameters'!G47),(I41+I47))))","v":0},null,{"$f":"IF(ISERROR(-(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47)))), 0, -(K42/('3. Cost_of_Service_Parameters'!I47*2)+MIN((K41/'3. Cost_of_Service_Parameters'!I47),(K41+K47))))","v":0},null,{"$f":"IF(ISERROR(-(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47)))), 0, -(M42/('3. Cost_of_Service_Parameters'!K47*2)+MIN((M41/'3. Cost_of_Service_Parameters'!K47),(M41+M47))))","v":0},null,{"$f":"IF(ISERROR(-(O42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!M47),(O41+O47)))), 0, -(O42/('3. Cost_of_Service_Parameters'!M47*2)+MIN((O41/'3. Cost_of_Service_Parameters'!M47),(O41+O47))))","v":0},null,{"$f":"IF(ISERROR(-(Q42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!O47),(Q41+Q47)))), 0, -(Q42/('3. Cost_of_Service_Parameters'!O47*2)+MIN((Q41/'3. Cost_of_Service_Parameters'!O47),(Q41+Q47))))","v":0},null,{"$f":"IF(ISERROR(-(S42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!Q47),(S41+S47)))), 0, -(S42/('3. Cost_of_Service_Parameters'!Q47*2)+MIN((S41/'3. Cost_of_Service_Parameters'!Q47),(S41+S47))))","v":0},null,{"$f":"IF(ISERROR(-(U42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!S47),(U41+U47)))), 0, -(U42/('3. Cost_of_Service_Parameters'!S47*2)+MIN((U41/'3. Cost_of_Service_Parameters'!S47),(U41+U47))))","v":0},null,{"$f":"IF(ISERROR(-(W42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((W41/'3. Cost_of_Service_Parameters'!U47),(W41+W47)))), 0, -(W42/('3. Cost_of_Service_Parameters'!U47*2)+MIN((W41/'3. Cost_of_Service_Parameters'!U47),(W41+W47))))","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":0},null,{"$f":"K47+K48-K49","v":0},null,{"$f":"M47+M48-M49","v":0},null,{"$f":"O47+O48-O49","v":0},null,{"$f":"Q47+Q48-Q49","v":0},null,{"$f":"S47+S48-S49","v":0},null,{"$f":"U47+U48-U49","v":0},null,{"$f":"W47+W48-W49","v":0}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,{"$f":"I54","v":0},null,{"$f":"K54","v":0},null,{"$f":"M54","v":0},null,{"$f":"O54","v":0},null,{"$f":"Q54","v":0},null,{"$f":"S54","v":0},null,{"$f":"U54","v":0}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":0},null,{"$f":"K44+K50","v":0},null,{"$f":"M44+M50","v":0},null,{"$f":"O44+O50","v":0},null,{"$f":"Q44+Q50","v":0},null,{"$f":"S44+S50","v":0},null,{"$f":"U44+U50","v":0},null,{"$f":"W44+W50","v":0}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":0},null,{"$f":"AVERAGE(K53:K54)","v":0},null,{"$f":"AVERAGE(M53:M54)","v":0},null,{"$f":"AVERAGE(O53:O54)","v":0},null,{"$f":"AVERAGE(Q53:Q54)","v":0},null,{"$f":"AVERAGE(S53:S54)","v":0},null,{"$f":"AVERAGE(U53:U54)","v":0},null,{"$f":"AVERAGE(W53:W54)","v":0}]
[]
[null,"Net Fixed Assets - Wood Poles"]
[]
[null,null,"Gross Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I63","v":556694.402},null,{"$f":"K63","v":556694.402},null,{"$f":"M63","v":556694.402},null,{"$f":"O63","v":556694.402},null,{"$f":"Q63","v":556694.402},null,{"$f":"S63","v":556694.402},null,{"$f":"U63","v":556694.402}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G186","v":556694.402},null,{"$f":"'2. ICM_Costs'!I186","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":556694.402},null,{"$f":"K60+K61-K62","v":556694.402},null,{"$f":"M60+M61-M62","v":556694.402},null,{"$f":"O60+O61-O62","v":556694.402},null,{"$f":"Q60+Q61-Q62","v":556694.402},null,{"$f":"S60+S61-S62","v":556694.402},null,{"$f":"U60+U61-U62","v":556694.402},null,{"$f":"W60+W61-W62","v":556694.402}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":-12652.145500000001},null,{"$f":"K69","v":-25304.291000000001},null,{"$f":"M69","v":-37956.436500000003},null,{"$f":"O69","v":-50608.582000000002},null,{"$f":"Q69","v":-63260.727500000001},null,{"$f":"S69","v":-75912.873000000007},null,{"$f":"U69","v":-88283.859711111116}]
[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":-12652.145500000001},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":-12652.145500000001},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":-12652.145500000001},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":-12652.145500000001},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":-12652.145500000001},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":-12652.145500000001},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":-12370.986711111111},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":-12370.986711111111}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":-12652.145500000001},null,{"$f":"K66+K67-K68","v":-25304.291000000001},null,{"$f":"M66+M67-M68","v":-37956.436500000003},null,{"$f":"O66+O67-O68","v":-50608.582000000002},null,{"$f":"Q66+Q67-Q68","v":-63260.727500000001},null,{"$f":"S66+S67-S68","v":-75912.873000000007},null,{"$f":"U66+U67-U68","v":-88283.859711111116},null,{"$f":"W66+W67-W68","v":-100654.84642222222}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,{"$f":"I73","v":544042.25650000002},null,{"$f":"K73","v":531390.11100000003},null,{"$f":"M73","v":518737.96549999999},null,{"$f":"O73","v":506085.82},null,{"$f":"Q73","v":493433.67450000002},null,{"$f":"S73","v":480781.52899999998},null,{"$f":"U73","v":468410.54228888889}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":544042.25650000002},null,{"$f":"K63+K69","v":531390.11100000003},null,{"$f":"M63+M69","v":518737.96549999999},null,{"$f":"O63+O69","v":506085.82},null,{"$f":"Q63+Q69","v":493433.67450000002},null,{"$f":"S63+S69","v":480781.52899999998},null,{"$f":"U63+U69","v":468410.54228888889},null,{"$f":"W63+W69","v":456039.55557777779}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":544042.25650000002},null,{"$f":"AVERAGE(K72:K73)","v":537716.18375000008},null,{"$f":"AVERAGE(M72:M73)","v":525064.03824999998},null,{"$f":"AVERAGE(O72:O73)","v":512411.89275},null,{"$f":"AVERAGE(Q72:Q73)","v":499759.74725000001},null,{"$f":"AVERAGE(S72:S73)","v":487107.60175000003},null,{"$f":"AVERAGE(U72:U73)","v":474596.0356444444},null,{"$f":"AVERAGE(W72:W73)","v":462225.04893333337}]
[]
[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":101217.164},null,{"$f":"K82","v":101217.164},null,{"$f":"M82","v":101217.164},null,{"$f":"O82","v":101217.164},null,{"$f":"Q82","v":101217.164},null,{"$f":"S82","v":101217.164},null,{"$f":"U82","v":101217.164}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":101217.164},null,{"$f":"'2. ICM_Costs'!I188","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":101217.164},null,{"$f":"K79+K80-K81","v":101217.164},null,{"$f":"M79+M80-M81","v":101217.164},null,{"$f":"O79+O80-O81","v":101217.164},null,{"$f":"Q79+Q80-Q81","v":101217.164},null,{"$f":"S79+S80-S81","v":101217.164},null,{"$f":"U79+U80-U81","v":101217.164},null,{"$f":"W79+W80-W81","v":101217.164}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":-2468.7113170731709},null,{"$f":"K88","v":-4937.4226341463418},null,{"$f":"M88","v":-7406.1339512195127},null,{"$f":"O88","v":-9874.8452682926836},null,{"$f":"Q88","v":-12343.556585365855},null,{"$f":"S88","v":-14812.267902439027},null,{"$f":"U88","v":-17061.538213550139}]
[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":-2468.7113170731709},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":-2468.7113170731709},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":-2468.7113170731709},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":-2468.7113170731709},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":-2468.7113170731709},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":-2468.7113170731709},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":-2249.2703111111114},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":-2249.2703111111114}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":-2468.7113170731709},null,{"$f":"K85+K86-K87","v":-4937.4226341463418},null,{"$f":"M85+M86-M87","v":-7406.1339512195127},null,{"$f":"O85+O86-O87","v":-9874.8452682926836},null,{"$f":"Q85+Q86-Q87","v":-12343.556585365855},null,{"$f":"S85+S86-S87","v":-14812.267902439027},null,{"$f":"U85+U86-U87","v":-17061.538213550139},null,{"$f":"W85+W86-W87","v":-19310.80852466125}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,{"$f":"I92","v":98748.452682926829},null,{"$f":"K92","v":96279.741365853668},null,{"$f":"M92","v":93811.030048780493},null,{"$f":"O92","v":91342.318731707317},null,{"$f":"Q92","v":88873.607414634142},null,{"$f":"S92","v":86404.896097560981},null,{"$f":"U92","v":84155.625786449862}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":98748.452682926829},null,{"$f":"K82+K88","v":96279.741365853668},null,{"$f":"M82+M88","v":93811.030048780493},null,{"$f":"O82+O88","v":91342.318731707317},null,{"$f":"Q82+Q88","v":88873.607414634142},null,{"$f":"S82+S88","v":86404.896097560981},null,{"$f":"U82+U88","v":84155.625786449862},null,{"$f":"W82+W88","v":81906.355475338758}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":98748.452682926829},null,{"$f":"AVERAGE(K91:K92)","v":97514.097024390241},null,{"$f":"AVERAGE(M91:M92)","v":95045.38570731708},null,{"$f":"AVERAGE(O91:O92)","v":92576.674390243905},null,{"$f":"AVERAGE(Q91:Q92)","v":90107.963073170729},null,{"$f":"AVERAGE(S91:S92)","v":87639.251756097568},null,{"$f":"AVERAGE(U91:U92)","v":85280.260942005421},null,{"$f":"AVERAGE(W91:W92)","v":83030.990630894317}]
[]
[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":151825.74599999998},null,{"$f":"K101","v":151825.74599999998},null,{"$f":"M101","v":151825.74599999998},null,{"$f":"O101","v":151825.74599999998},null,{"$f":"Q101","v":151825.74599999998},null,{"$f":"S101","v":151825.74599999998},null,{"$f":"U101","v":151825.74599999998}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":151825.74599999998},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":151825.74599999998},null,{"$f":"K98+K99-K100","v":151825.74599999998},null,{"$f":"M98+M99-M100","v":151825.74599999998},null,{"$f":"O98+O99-O100","v":151825.74599999998},null,{"$f":"Q98+Q99-Q100","v":151825.74599999998},null,{"$f":"S98+S99-S100","v":151825.74599999998},null,{"$f":"U98+U99-U100","v":151825.74599999998},null,{"$f":"W98+W99-W100","v":151825.74599999998}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":-3373.9054666666661},null,{"$f":"K107","v":-6747.8109333333323},null,{"$f":"M107","v":-10121.716399999998},null,{"$f":"O107","v":-13495.621866666665},null,{"$f":"Q107","v":-16869.527333333332},null,{"$f":"S107","v":-20243.432799999999},null,{"$f":"U107","v":-23279.947719999996}]
[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":-3373.9054666666661},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":-3373.9054666666661},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":-3373.9054666666661},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":-3373.9054666666661},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":-3373.9054666666661},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":-3373.9054666666661},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":-3036.5149199999996},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":-3036.5149199999996}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":-3373.9054666666661},null,{"$f":"K104+K105-K106","v":-6747.8109333333323},null,{"$f":"M104+M105-M106","v":-10121.716399999998},null,{"$f":"O104+O105-O106","v":-13495.621866666665},null,{"$f":"Q104+Q105-Q106","v":-16869.527333333332},null,{"$f":"S104+S105-S106","v":-20243.432799999999},null,{"$f":"U104+U105-U106","v":-23279.947719999996},null,{"$f":"W104+W105-W106","v":-26316.462639999998}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,{"$f":"I111","v":148451.84053333331},null,{"$f":"K111","v":145077.93506666666},null,{"$f":"M111","v":141704.02959999998},null,{"$f":"O111","v":138330.12413333333},null,{"$f":"Q111","v":134956.21866666665},null,{"$f":"S111","v":131582.31319999998},null,{"$f":"U111","v":128545.79827999999}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":148451.84053333331},null,{"$f":"K101+K107","v":145077.93506666666},null,{"$f":"M101+M107","v":141704.02959999998},null,{"$f":"O101+O107","v":138330.12413333333},null,{"$f":"Q101+Q107","v":134956.21866666665},null,{"$f":"S101+S107","v":131582.31319999998},null,{"$f":"U101+U107","v":128545.79827999999},null,{"$f":"W101+W107","v":125509.28335999999}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":148451.84053333331},null,{"$f":"AVERAGE(K110:K111)","v":146764.88779999997},null,{"$f":"AVERAGE(M110:M111)","v":143390.98233333332},null,{"$f":"AVERAGE(O110:O111)","v":140017.07686666667},null,{"$f":"AVERAGE(Q110:Q111)","v":136643.17139999999},null,{"$f":"AVERAGE(S110:S111)","v":133269.26593333331},null,{"$f":"AVERAGE(U110:U111)","v":130064.05573999998},null,{"$f":"AVERAGE(W110:W111)","v":127027.54081999999}]
[]
[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":50608.582000000002},null,{"$f":"K120","v":50608.582000000002},null,{"$f":"M120","v":50608.582000000002},null,{"$f":"O120","v":50608.582000000002},null,{"$f":"Q120","v":50608.582000000002},null,{"$f":"S120","v":50608.582000000002},null,{"$f":"U120","v":50608.582000000002}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":50608.582000000002},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":50608.582000000002},null,{"$f":"K117+K118-K119","v":50608.582000000002},null,{"$f":"M117+M118-M119","v":50608.582000000002},null,{"$f":"O117+O118-O119","v":50608.582000000002},null,{"$f":"Q117+Q118-Q119","v":50608.582000000002},null,{"$f":"S117+S118-S119","v":50608.582000000002},null,{"$f":"U117+U118-U119","v":50608.582000000002},null,{"$f":"W117+W118-W119","v":50608.582000000002}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":-1054.3454583333335},null,{"$f":"K126","v":-2108.6909166666669},null,{"$f":"M126","v":-3163.0363750000006},null,{"$f":"O126","v":-4217.3818333333338},null,{"$f":"Q126","v":-5271.727291666667},null,{"$f":"S126","v":-6326.0727500000003},null,{"$f":"U126","v":-7338.2443899999998}]
[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":-1054.3454583333335},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":-1054.3454583333335},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":-1054.3454583333335},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":-1054.3454583333335},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":-1054.3454583333335},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":-1054.3454583333335},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":-1012.17164},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":-1012.17164}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":-1054.3454583333335},null,{"$f":"K123+K124-K125","v":-2108.6909166666669},null,{"$f":"M123+M124-M125","v":-3163.0363750000006},null,{"$f":"O123+O124-O125","v":-4217.3818333333338},null,{"$f":"Q123+Q124-Q125","v":-5271.727291666667},null,{"$f":"S123+S124-S125","v":-6326.0727500000003},null,{"$f":"U123+U124-U125","v":-7338.2443899999998},null,{"$f":"W123+W124-W125","v":-8350.4160300000003}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,{"$f":"I130","v":49554.236541666665},null,{"$f":"K130","v":48499.891083333336},null,{"$f":"M130","v":47445.545624999999},null,{"$f":"O130","v":46391.200166666669},null,{"$f":"Q130","v":45336.854708333332},null,{"$f":"S130","v":44282.509250000003},null,{"$f":"U130","v":43270.337610000002}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":49554.236541666665},null,{"$f":"K120+K126","v":48499.891083333336},null,{"$f":"M120+M126","v":47445.545624999999},null,{"$f":"O120+O126","v":46391.200166666669},null,{"$f":"Q120+Q126","v":45336.854708333332},null,{"$f":"S120+S126","v":44282.509250000003},null,{"$f":"U120+U126","v":43270.337610000002},null,{"$f":"W120+W126","v":42258.165970000002}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":49554.236541666665},null,{"$f":"AVERAGE(K129:K130)","v":49027.063812499997},null,{"$f":"AVERAGE(M129:M130)","v":47972.718354166667},null,{"$f":"AVERAGE(O129:O130)","v":46918.372895833338},null,{"$f":"AVERAGE(Q129:Q130)","v":45864.027437500001},null,{"$f":"AVERAGE(S129:S130)","v":44809.681979166664},null,{"$f":"AVERAGE(U129:U130)","v":43776.423430000003},null,{"$f":"AVERAGE(W129:W130)","v":42764.251790000002}]
[]
[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":2794878.9040000001},null,{"$f":"K139","v":2794878.9040000001},null,{"$f":"M139","v":2794878.9040000001},null,{"$f":"O139","v":2794878.9040000001},null,{"$f":"Q139","v":2794878.9040000001},null,{"$f":"S139","v":2794878.9040000001},null,{"$f":"U139","v":2794878.9040000001}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G194","v":2794878.9040000001},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":2794878.9040000001},null,{"$f":"K136+K137-K138","v":2794878.9040000001},null,{"$f":"M136+M137-M138","v":2794878.9040000001},null,{"$f":"O136+O137-O138","v":2794878.9040000001},null,{"$f":"Q136+Q137-Q138","v":2794878.9040000001},null,{"$f":"S136+S137-S138","v":2794878.9040000001},null,{"$f":"U136+U137-U138","v":2794878.9040000001},null,{"$f":"W136+W137-W138","v":2794878.9040000001}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":-87339.965750000003},null,{"$f":"K145","v":-174679.93150000001},null,{"$f":"M145","v":-262019.89725000001},null,{"$f":"O145","v":-349359.86300000001},null,{"$f":"Q145","v":-436699.82874999999},null,{"$f":"S145","v":-524039.79449999996},null,{"$f":"U145","v":-617202.42463333334}]
[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":-87339.965750000003},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":-87339.965750000003},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":-87339.965750000003},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":-87339.965750000003},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":-87339.965750000003},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":-87339.965750000003},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":-93162.630133333339},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":-93162.630133333339}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":-87339.965750000003},null,{"$f":"K142+K143-K144","v":-174679.93150000001},null,{"$f":"M142+M143-M144","v":-262019.89725000001},null,{"$f":"O142+O143-O144","v":-349359.86300000001},null,{"$f":"Q142+Q143-Q144","v":-436699.82874999999},null,{"$f":"S142+S143-S144","v":-524039.79449999996},null,{"$f":"U142+U143-U144","v":-617202.42463333334},null,{"$f":"W142+W143-W144","v":-710365.05476666673}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,{"$f":"I149","v":2707538.9382500001},null,{"$f":"K149","v":2620198.9725000001},null,{"$f":"M149","v":2532859.0067500002},null,{"$f":"O149","v":2445519.0410000002},null,{"$f":"Q149","v":2358179.0752500002},null,{"$f":"S149","v":2270839.1095000003},null,{"$f":"U149","v":2177676.4793666666}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":2707538.9382500001},null,{"$f":"K139+K145","v":2620198.9725000001},null,{"$f":"M139+M145","v":2532859.0067500002},null,{"$f":"O139+O145","v":2445519.0410000002},null,{"$f":"Q139+Q145","v":2358179.0752500002},null,{"$f":"S139+S145","v":2270839.1095000003},null,{"$f":"U139+U145","v":2177676.4793666666},null,{"$f":"W139+W145","v":2084513.8492333335}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":2707538.9382500001},null,{"$f":"AVERAGE(K148:K149)","v":2663868.9553749999},null,{"$f":"AVERAGE(M148:M149)","v":2576528.9896250004},null,{"$f":"AVERAGE(O148:O149)","v":2489189.023875},null,{"$f":"AVERAGE(Q148:Q149)","v":2401849.0581250004},null,{"$f":"AVERAGE(S148:S149)","v":2314509.092375},null,{"$f":"AVERAGE(U148:U149)","v":2224257.7944333334},null,{"$f":"AVERAGE(W148:W149)","v":2131095.1643000003}]
[]
[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,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,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,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,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,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,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,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,"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":379725.0122},null,{"$f":"K177","v":379725.0122},null,{"$f":"M177","v":379725.0122},null,{"$f":"O177","v":379725.0122},null,{"$f":"Q177","v":379725.0122},null,{"$f":"S177","v":379725.0122},null,{"$f":"U177","v":379725.0122}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":379725.0122},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":379725.0122},null,{"$f":"K174+K175-K176","v":379725.0122},null,{"$f":"M174+M175-M176","v":379725.0122},null,{"$f":"O174+O175-O176","v":379725.0122},null,{"$f":"Q174+Q175-Q176","v":379725.0122},null,{"$f":"S174+S175-S176","v":379725.0122},null,{"$f":"U174+U175-U176","v":379725.0122},null,{"$f":"W174+W175-W176","v":379725.0122}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I183","v":-9992.7634789473686},null,{"$f":"K183","v":-19985.526957894737},null,{"$f":"M183","v":-29978.290436842108},null,{"$f":"O183","v":-39971.053915789475},null,{"$f":"Q183","v":-49963.817394736841},null,{"$f":"S183","v":-59956.580873684208},null,{"$f":"U183","v":-68394.91447812866}]
[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":-9992.7634789473686},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":-9992.7634789473686},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":-9992.7634789473686},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":-9992.7634789473686},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":-9992.7634789473686},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":-9992.7634789473686},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":-8438.3336044444441},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":-8438.3336044444441}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I180+I181-I182","v":-9992.7634789473686},null,{"$f":"K180+K181-K182","v":-19985.526957894737},null,{"$f":"M180+M181-M182","v":-29978.290436842108},null,{"$f":"O180+O181-O182","v":-39971.053915789475},null,{"$f":"Q180+Q181-Q182","v":-49963.817394736841},null,{"$f":"S180+S181-S182","v":-59956.580873684208},null,{"$f":"U180+U181-U182","v":-68394.91447812866},null,{"$f":"W180+W181-W182","v":-76833.248082573104}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,{"$f":"I187","v":369732.2487210526},null,{"$f":"K187","v":359739.48524210526},null,{"$f":"M187","v":349746.72176315787},null,{"$f":"O187","v":339753.95828421053},null,{"$f":"Q187","v":329761.19480526313},null,{"$f":"S187","v":319768.4313263158},null,{"$f":"U187","v":311330.09772187134}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I177+I183","v":369732.2487210526},null,{"$f":"K177+K183","v":359739.48524210526},null,{"$f":"M177+M183","v":349746.72176315787},null,{"$f":"O177+O183","v":339753.95828421053},null,{"$f":"Q177+Q183","v":329761.19480526313},null,{"$f":"S177+S183","v":319768.4313263158},null,{"$f":"U177+U183","v":311330.09772187134},null,{"$f":"W177+W183","v":302891.76411742688}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I187","v":369732.2487210526},null,{"$f":"AVERAGE(K186:K187)","v":364735.86698157893},null,{"$f":"AVERAGE(M186:M187)","v":354743.10350263154},null,{"$f":"AVERAGE(O186:O187)","v":344750.3400236842},null,{"$f":"AVERAGE(Q186:Q187)","v":334757.57654473686},null,{"$f":"AVERAGE(S186:S187)","v":324764.81306578947},null,{"$f":"AVERAGE(U186:U187)","v":315549.2645240936},null,{"$f":"AVERAGE(W186:W187)","v":307110.93091964908}]
[]
[]
[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":205045.08069999999},null,{"$f":"K197","v":205045.08069999999},null,{"$f":"M197","v":205045.08069999999},null,{"$f":"O197","v":205045.08069999999},null,{"$f":"Q197","v":205045.08069999999},null,{"$f":"S197","v":205045.08069999999},null,{"$f":"U197","v":205045.08069999999}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":205045.08069999999},null,{"$f":"'2. ICM_Costs'!I200","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I194+I195-I196","v":205045.08069999999},null,{"$f":"K194+K195-K196","v":205045.08069999999},null,{"$f":"M194+M195-M196","v":205045.08069999999},null,{"$f":"O194+O195-O196","v":205045.08069999999},null,{"$f":"Q194+Q195-Q196","v":205045.08069999999},null,{"$f":"S194+S195-S196","v":205045.08069999999},null,{"$f":"U194+U195-U196","v":205045.08069999999},null,{"$f":"W194+W195-W196","v":205045.08069999999}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I203","v":-6614.3574419354836},null,{"$f":"K203","v":-13228.714883870967},null,{"$f":"M203","v":-19843.07232580645},null,{"$f":"O203","v":-26457.429767741934},null,{"$f":"Q203","v":-33071.787209677415},null,{"$f":"S203","v":-39686.1446516129},null,{"$f":"U203","v":-46520.98067494623}]
[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":-6614.3574419354836},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":-6614.3574419354836},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":-6614.3574419354836},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":-6614.3574419354836},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":-6614.3574419354836},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":-6614.3574419354836},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":-6834.8360233333333},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":-6834.8360233333333}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I200+I201-I202","v":-6614.3574419354836},null,{"$f":"K200+K201-K202","v":-13228.714883870967},null,{"$f":"M200+M201-M202","v":-19843.07232580645},null,{"$f":"O200+O201-O202","v":-26457.429767741934},null,{"$f":"Q200+Q201-Q202","v":-33071.787209677415},null,{"$f":"S200+S201-S202","v":-39686.1446516129},null,{"$f":"U200+U201-U202","v":-46520.98067494623},null,{"$f":"W200+W201-W202","v":-53355.816698279566}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,{"$f":"I207","v":198430.72325806451},null,{"$f":"K207","v":191816.36581612902},null,{"$f":"M207","v":185202.00837419354},null,{"$f":"O207","v":178587.65093225805},null,{"$f":"Q207","v":171973.29349032257},null,{"$f":"S207","v":165358.93604838708},null,{"$f":"U207","v":158524.10002505378}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I197+I203","v":198430.72325806451},null,{"$f":"K197+K203","v":191816.36581612902},null,{"$f":"M197+M203","v":185202.00837419354},null,{"$f":"O197+O203","v":178587.65093225805},null,{"$f":"Q197+Q203","v":171973.29349032257},null,{"$f":"S197+S203","v":165358.93604838708},null,{"$f":"U197+U203","v":158524.10002505378},null,{"$f":"W197+W203","v":151689.26400172041}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I207","v":198430.72325806451},null,{"$f":"AVERAGE(K206:K207)","v":195123.54453709675},null,{"$f":"AVERAGE(M206:M207)","v":188509.18709516129},null,{"$f":"AVERAGE(O206:O207)","v":181894.82965322578},null,{"$f":"AVERAGE(Q206:Q207)","v":175280.47221129033},null,{"$f":"AVERAGE(S206:S207)","v":168666.11476935481},null,{"$f":"AVERAGE(U206:U207)","v":161941.51803672043},null,{"$f":"AVERAGE(W206:W207)","v":155106.68201338709}]
[]
[]
[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":174679.93150000001},null,{"$f":"K217","v":174679.93150000001},null,{"$f":"M217","v":174679.93150000001},null,{"$f":"O217","v":174679.93150000001},null,{"$f":"Q217","v":174679.93150000001},null,{"$f":"S217","v":174679.93150000001},null,{"$f":"U217","v":174679.93150000001}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":174679.93150000001},null,{"$f":"'2. ICM_Costs'!I202","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I214+I215-I216","v":174679.93150000001},null,{"$f":"K214+K215-K216","v":174679.93150000001},null,{"$f":"M214+M215-M216","v":174679.93150000001},null,{"$f":"O214+O215-O216","v":174679.93150000001},null,{"$f":"Q214+Q215-Q216","v":174679.93150000001},null,{"$f":"S214+S215-S216","v":174679.93150000001},null,{"$f":"U214+U215-U216","v":174679.93150000001},null,{"$f":"W214+W215-W216","v":174679.93150000001}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I223","v":-4721.0792297297303},null,{"$f":"K223","v":-9442.1584594594606},null,{"$f":"M223","v":-14163.237689189191},null,{"$f":"O223","v":-18884.316918918921},null,{"$f":"Q223","v":-23605.396148648651},null,{"$f":"S223","v":-28326.475378378382},null,{"$f":"U223","v":-32693.47366587838}]
[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":-4721.0792297297303},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":-4721.0792297297303},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":-4721.0792297297303},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":-4721.0792297297303},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":-4721.0792297297303},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":-4721.0792297297303},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":-4366.9982875000005},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":-4366.9982875000005}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I220+I221-I222","v":-4721.0792297297303},null,{"$f":"K220+K221-K222","v":-9442.1584594594606},null,{"$f":"M220+M221-M222","v":-14163.237689189191},null,{"$f":"O220+O221-O222","v":-18884.316918918921},null,{"$f":"Q220+Q221-Q222","v":-23605.396148648651},null,{"$f":"S220+S221-S222","v":-28326.475378378382},null,{"$f":"U220+U221-U222","v":-32693.47366587838},null,{"$f":"W220+W221-W222","v":-37060.471953378379}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,{"$f":"I227","v":169958.85227027029},null,{"$f":"K227","v":165237.77304054055},null,{"$f":"M227","v":160516.6938108108},null,{"$f":"O227","v":155795.61458108108},null,{"$f":"Q227","v":151074.53535135137},null,{"$f":"S227","v":146353.45612162162},null,{"$f":"U227","v":141986.45783412163}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I217+I223","v":169958.85227027029},null,{"$f":"K217+K223","v":165237.77304054055},null,{"$f":"M217+M223","v":160516.6938108108},null,{"$f":"O217+O223","v":155795.61458108108},null,{"$f":"Q217+Q223","v":151074.53535135137},null,{"$f":"S217+S223","v":146353.45612162162},null,{"$f":"U217+U223","v":141986.45783412163},null,{"$f":"W217+W223","v":137619.45954662163}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I227","v":169958.85227027029},null,{"$f":"AVERAGE(K226:K227)","v":167598.31265540543},null,{"$f":"AVERAGE(M226:M227)","v":162877.23342567566},null,{"$f":"AVERAGE(O226:O227)","v":158156.15419594594},null,{"$f":"AVERAGE(Q226:Q227)","v":153435.07496621623},null,{"$f":"AVERAGE(S226:S227)","v":148713.99573648651},null,{"$f":"AVERAGE(U226:U227)","v":144169.95697787162},null,{"$f":"AVERAGE(W226:W227)","v":139802.95869037163}]
[]
[]
[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,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":0},null,{"$f":"'2. ICM_Costs'!I204","v":0},null,{"$f":"'2. ICM_Costs'!K266","v":0},null,{"$f":"'2. ICM_Costs'!M266","v":0},null,{"$f":"'2. ICM_Costs'!O266","v":0},null,{"$f":"'2. ICM_Costs'!Q266","v":0},null,{"$f":"'2. ICM_Costs'!S266","v":0},null,{"$f":"'2. ICM_Costs'!U266","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,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,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,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,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,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,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,"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,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":0},null,{"$f":"'2. ICM_Costs'!I206","v":0},null,{"$f":"'2. ICM_Costs'!K286","v":0},null,{"$f":"'2. ICM_Costs'!M286","v":0},null,{"$f":"'2. ICM_Costs'!O286","v":0},null,{"$f":"'2. ICM_Costs'!Q286","v":0},null,{"$f":"'2. ICM_Costs'!S286","v":0},null,{"$f":"'2. ICM_Costs'!U286","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,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,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,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,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,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,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,"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,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'!I208","v":0},null,{"$f":"'2. ICM_Costs'!K306","v":0},null,{"$f":"'2. ICM_Costs'!M306","v":0},null,{"$f":"'2. ICM_Costs'!O306","v":0},null,{"$f":"'2. ICM_Costs'!Q306","v":0},null,{"$f":"'2. ICM_Costs'!S306","v":0},null,{"$f":"'2. ICM_Costs'!U306","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,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,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,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,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,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,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,"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,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'!I210","v":0},null,{"$f":"'2. ICM_Costs'!K326","v":0},null,{"$f":"'2. ICM_Costs'!M326","v":0},null,{"$f":"'2. ICM_Costs'!O326","v":0},null,{"$f":"'2. ICM_Costs'!Q326","v":0},null,{"$f":"'2. ICM_Costs'!S326","v":0},null,{"$f":"'2. ICM_Costs'!U326","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,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,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,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,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,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,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,"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,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'!I212","v":0},null,{"$f":"'2. ICM_Costs'!K346","v":0},null,{"$f":"'2. ICM_Costs'!M346","v":0},null,{"$f":"'2. ICM_Costs'!O346","v":0},null,{"$f":"'2. ICM_Costs'!Q346","v":0},null,{"$f":"'2. ICM_Costs'!S346","v":0},null,{"$f":"'2. ICM_Costs'!U346","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,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,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,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,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,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,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,"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,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'!I214","v":0},null,{"$f":"'2. ICM_Costs'!K366","v":0},null,{"$f":"'2. ICM_Costs'!M366","v":0},null,{"$f":"'2. ICM_Costs'!O366","v":0},null,{"$f":"'2. ICM_Costs'!Q366","v":0},null,{"$f":"'2. ICM_Costs'!S366","v":0},null,{"$f":"'2. ICM_Costs'!U366","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,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,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,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,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,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,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,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":4505770.2699999996},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,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":4375155.7477362622},null,{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268+K288+K308+K328+K348","v":4309848.4866043925},null,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268+M288+M308+M328+M348","v":4179233.9643406551},null,{"$f":"O36+O55+O74+O93+O112+O131+O150+O169+O188+O208+O228+O248+O268+O288+O308+O328+O348","v":4048619.4420769159},null,{"$f":"Q36+Q55+Q74+Q93+Q112+Q131+Q150+Q169+Q188+Q208+Q228+Q248+Q268+Q288+Q308+Q328+Q348","v":3918004.9198131775},null,{"$f":"S36+S55+S74+S93+S112+S131+S150+S169+S188+S208+S228+S248+S268+S288+S308+S328+S348","v":3787390.3975494392},null,{"$f":"U36+U55+U74+U93+U112+U131+U150+U169+U188+U208+U228+U248+U268+U288+U308+U328+U348","v":3655045.9020650103},null,{"$f":"W36+W55+W74+W93+W112+W131+W150+W169+W188+W208+W228+W248+W268+W288+W308+W328+W348","v":3520971.4333598916}]
[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":-130614.52226373838},null,{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261+K281+K301+K321+K341","v":-130614.52226373838},null,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261+M281+M301+M321+M341","v":-130614.52226373838},null,{"$f":"O29+O48+O67+O86+O105+O124+O143+O162+O181+O201+O221+O241+O261+O281+O301+O321+O341","v":-130614.52226373838},null,{"$f":"Q29+Q48+Q67+Q86+Q105+Q124+Q143+Q162+Q181+Q201+Q221+Q241+Q261+Q281+Q301+Q321+Q341","v":-130614.52226373838},null,{"$f":"S29+S48+S67+S86+S105+S124+S143+S162+S181+S201+S221+S241+S261+S281+S301+S321+S341","v":-130614.52226373838},null,{"$f":"U29+U48+U67+U86+U105+U124+U143+U162+U181+U201+U221+U241+U261+U281+U301+U321+U341","v":-134074.46870511907},null,{"$f":"W29+W48+W67+W86+W105+W124+W143+W162+W181+W201+W221+W241+W261+W281+W301+W321+W341","v":-134074.46870511907}]

{"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":"'2. ICM_Costs'!G18","v":2019}]
[null,null,null,{"$f":"'2. ICM_Costs'!G19","v":"Audited Actual"}]
[]
["Opening UCC",null,null,0]
["Capital Additions",null,null,4505770.2699999996]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D23:D24)-D25","v":4505770.2699999996}]
[]
[]
["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":360461.62159999995}]
["Closing UCC",null,null,{"$f":"IF((D26-D31)<0, 0, D26-D31)","v":4145308.6483999994}]
[]
["UCC/Class 1",null,null,{"$f":"D20","v":2019}]
[null,null,null,"Audited Actual"]
[]
["Opening UCC",null,null,0]
["Capital Additions RTU's"]
["Retirements/Removals (if applicable)"]
["UCC Full Year",null,null,{"$f":"SUM(D37:D38)-D39","v":0}]
[]
[]
["CCA Rate Class",null,null,1]
["CCA Rate ",null,null,0.04]
["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 ","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,"2019 ICM EB-2018-0016"]
[]
[null,null,"Return on Rate Base"]
[null,null,"Incremental Capital CAPEX",null,null,4505770.2699999996,"B",null,null,null,7500000]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":130614.52226373838},"C",null,null,null,198490]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"F27-F28/2","v":4440463.0088681299},"D = B - C/2",null,null,null,{"$f":"K27-K28/2","v":7400755}]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},"E",{"$f":"F29*D31","v":177618.52035472519},"G = D * E",null,0.04,null,{"$f":"K29*I31","v":296030.2}]
[null,null,"Deemed Long Term Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},"F",{"$f":"F29*D32","v":2486659.2849661526},"H = D * F",null,0.56000000000000005,null,{"$f":"K29*I32","v":4144422.8000000003}]
[]
[null,null,"Short Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":2.0799999999999999E-2},"I",{"$f":"F31*D34","v":3694.4652233782836},"K = G * I",null,2.0799999999999999E-2,null,{"$f":"K31*I34","v":6157.4281600000004}]
[null,null,"Long Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":5.0914000000000001E-2},"J",{"$f":"F32*D35","v":126605.77083476669},"L = H * J",null,5.0900000000000001E-2,null,{"$f":"K32*I35","v":210951.12052000003}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":130300.23605814498},"M = K + L",null,null,null,{"$f":"SUM(K34:K35)","v":217108.54868000004}]
[]
[]
[null,null,"Deemed Equity %",{"$f":"'3. Cost_of_Service_Parameters'!G24","v":0.40000000000000008},"N",{"$f":"F29*D40","v":1776185.2035472523},"P = D * N",null,0.39999999999999991,null,{"$f":"K29*I40","v":2960301.9999999995}]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":8.9300000000000004E-2},"O",{"$f":"F40*D42","v":158613.33867676964},"Q = P * O",null,8.9300000000000004E-2,null,{"$f":"K40*I42","v":264354.96859999996}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":288913.57473491458},"R = M + Q",null,null,null,{"$f":"K37+K42","v":481463.51728000003}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":130614.52226373838},"S",null,null,null,{"$f":"K28","v":198490}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":158613.33867676964},"T ",null,null,null,{"$f":"K42","v":264354.96859999996}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":130614.52226373838},"U",null,null,null,{"$f":"K50","v":198490}]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'5. UCC_Calculation'!D31+'5. UCC_Calculation'!D45","v":360461.62159999995},"V",null,null,null,599853.02675344096]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-71233.760659491934},"W = T + U - V",null,null,null,{"$f":"K55+K57-K59","v":-137008.058153441}]
[]
[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,0.26500000000000001]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-18876.946574765363},"Y = W * X",null,null,null,{"$f":"K61*I63","v":-36307.135410661867}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-25682.920509884847},"Z = Y / ( 1 - X ) ",null,null,null,{"$f":"K65/(1-I63)","v":-49397.463143757646}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":4505770.2699999996},"AA",null,null,null,{"$f":"K27","v":7500000}]
[]
[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":4505770.2699999996},"AC = AA - AB",null,null,null,{"$f":"K71-K73","v":7500000}]
[]
[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":288913.57473491458},"AF",null,null,null,{"$f":"K44","v":481463.51728000003}]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":130614.52226373838},"AG",null,null,null,{"$f":"K50","v":198490}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-25682.920509884847},"AH",null,null,null,{"$f":"K67","v":-49397.463143757646}]
[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":393845.17648876813},"AJ = AF + AG + AH + AI",null,null,null,{"$f":"SUM(K83:K86)","v":630556.05413624237}]

{"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 rider 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,null,{"$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,null,{"$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,null,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,null,0,0,null,null,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,null,null,0,0,null,null,0]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2018-06-01",2018,"Q2","2018 Q2",0,null,null,0,0,null,null,0]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",0,null,null,0,0,null,null,0]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2018-08-01",2018,"Q3","2018 Q3",0,null,null,0,0,null,null,0]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2018-09-01",2018,"Q3","2018 Q3",0,null,null,0,0,null,null,0]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",0,null,null,0,0,null,null,0]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",0,null,null,0,0,null,null,0]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",0,null,null,0,0,null,null,0]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2019-01-01",2019,"Q1","2019 Q1",0,null,null,0,0,null,null,0]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2019-02-01",2019,"Q1","2019 Q1",0,null,null,0,0,null,null,0]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2019-03-01",2019,"Q1","2019 Q1",0,23599.22,2.4500000000000001E-2,0,23599.22,null,52546.337844686866,52546.337844686866]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2019-04-01",2019,"Q2","2019 Q2",23599.22,86525.68,2.18E-2,42.87,110167.76999999999,null,52546.337844686866,105092.67568937373]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2019-05-01",2019,"Q2","2019 Q2",110124.9,58337.27,2.18E-2,200.06,168705.09999999998,null,52546.337844686866,157639.01353406059]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",168462.16999999998,51987.72,2.18E-2,306.04000000000002,220998.86,null,52546.337844686866,210185.35137874747]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2019-07-01",2019,"Q3","2019 Q3",220449.88999999998,60865.42,2.18E-2,400.48,282264.75999999995,null,52546.337844686866,262731.68922343431]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2019-08-01",2019,"Q3","2019 Q3",281315.31,55862.37,2.18E-2,511.06,338638.18999999994,null,52546.337844686866,315278.02706812118]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2019-09-01",2019,"Q3","2019 Q3",337177.68,53651.89,2.18E-2,612.54,392902.61999999994,null,52546.337844686866,367824.36491280806]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-10-01",2019,"Q4","2019 Q4",390829.57,55990.03,2.18E-2,710.01,449602.65999999992,null,52546.337844686866,420370.70275749493]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-11-01",2019,"Q4","2019 Q4",446819.6,54031.12,2.18E-2,811.72,504445.49999999988,null,52546.337844686866,472917.04060218181]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2019-12-01",2019,"Q4","2019 Q4",500850.72,55285.32,2.18E-2,909.88,560640.69999999984,null,52546.337844686866,525463.37844686862]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2020-01-01",2020,"Q1","2020 Q1",556136.03999999992,54001.85,2.18E-2,{"$f":"ROUND(J48*L48/12,2)","v":1010.31},{"$f":"N47+K48+M48","v":615652.85999999987},null,52546.337844686866,{"$f":"Q47+P48","v":578009.71629155544}]
[null,"2024 Q2",5.4899999999999997E-2,4.9799999999999997E-2,null,"2020-02-01",2020,"Q1","2020 Q1",610137.8899999999,51872.76,2.18E-2,1108.42,668634.03999999992,null,52546.337844686866,630556.05413624225]
[null,"2024 Q3",5.1999999999999998E-2,4.9799999999999997E-2,null,"2020-03-01",2020,"Q1","2020 Q1",662010.64999999991,61208.68,2.18E-2,1202.6500000000001,731045.37,null,52546.337844686866,683102.39198092907]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2020-04-01",2020,"Q2","2020 Q2",723219.33,49455.48,2.18E-2,1313.85,781814.7,null,52546.337844686866,735648.72982561588]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2020-05-01",2020,"Q2","2020 Q2",772674.80999999994,52778.26,2.18E-2,1403.69,835996.64999999991,null,52546.337844686866,788195.0676703027]
[null,"2025 Q2",3.1600000000000003E-2,{"$f":"D52","v":4.2299999999999997E-2},null,"2020-06-01",2020,"Q2","2020 Q2",825453.07,55098.84,2.18E-2,1499.57,892595.05999999982,null,52546.337844686866,840741.40551498951]
[null,"2025 Q3",2.9100000000000001E-2,{"$f":"D53","v":4.2299999999999997E-2},null,"2020-07-01",2020,"Q3","2020 Q3",880551.90999999992,56520.59,5.7000000000000002E-3,418.26,949533.9099999998,null,52546.337844686866,893287.74335967633]
[null,"2025 Q4",{"$f":"C54","v":2.9100000000000001E-2},4.2299999999999997E-2,null,"2020-08-01",2020,"Q3","2020 Q3",937072.49999999988,54846.51,5.7000000000000002E-3,445.11,1004825.5299999998,null,52546.337844686866,945834.08120436314]
[null,"2026 Q1",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",991919.00999999989,54853.34,5.7000000000000002E-3,471.16,1060150.0299999998,null,52546.337844686866,998380.41904904996]
[null,"2026 Q2",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",1046772.3499999999,55462.2,5.7000000000000002E-3,497.22,1116109.4499999997,null,52546.337844686866,1050926.7568937368]
[null,"2026 Q3",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",1102234.5499999998,52928.39,5.7000000000000002E-3,523.55999999999995,1169561.3999999997,null,52546.337844686866,1103473.0947384236]
[null,"2026 Q4",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-12-01",2020,"Q4","2020 Q4",1155162.9399999997,56739.18,5.7000000000000002E-3,548.70000000000005,1226849.2799999996,null,52546.337844686866,1156019.4325831104]
[null,null,null,null,null,"2021-01-01",2021,{"$f":"IF(MONTH(F60)=0,\"\",IF(MONTH(F60)<4,\"Q1\",IF(MONTH(F60)<7,\"Q2\",IF(MONTH(F60)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G60,\" \",H60)","v":"2021 Q1"},{"$f":"J59+K59","v":1211902.1199999996},51624.79,5.7000000000000002E-3,{"$f":"ROUND(J60*L60/12,2)","v":575.65},{"$f":"N59+K60+M60","v":1279049.7199999995},null,52546.337844686866,{"$f":"Q59+P60","v":1208565.7704277972}]
[null,null,null,null,null,"2021-02-01",2021,"Q1","2021 Q1",1263526.9099999997,51674.99,5.7000000000000002E-3,600.17999999999995,1331324.8899999994,null,52546.337844686866,1261112.108272484]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",1315201.8999999997,57823.29,5.7000000000000002E-3,624.72,1389772.8999999994,null,52546.337844686866,1313658.4461171709]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",1373025.1899999997,47350.63,5.7000000000000002E-3,652.19000000000005,1437775.7199999993,null,52546.337844686866,1366204.7839618577]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",1420375.8199999996,55111.97,5.7000000000000002E-3,674.68,1493562.3699999992,null,52546.337844686866,1418751.1218065445]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",1475487.7899999996,58094.91,5.7000000000000002E-3,700.86,1552358.1399999992,null,52546.337844686866,1471297.4596512313]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",1533582.6999999995,54875.01,5.7000000000000002E-3,728.45,1607961.5999999992,null,52546.337844686866,1523843.7974959181]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",1588457.7099999995,57050.61,5.7000000000000002E-3,754.52,1665766.7299999993,null,52546.337844686866,1576390.1353406049]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",1645508.3199999996,54219.39,5.7000000000000002E-3,781.62,1720767.7399999993,null,52546.337844686866,1628936.4731852917]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",1699727.7099999995,54040.800000000003,5.7000000000000002E-3,807.37,1775615.9099999995,null,52546.337844686866,1681482.8110299786]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",1753768.5099999995,55584.04,5.7000000000000002E-3,833.04,1832032.9899999995,null,52546.337844686866,1734029.1488746654]
[null,null,null,null,null,"2021-12-01",2021,"Q4","2021 Q4",1809352.5499999996,55538.5,5.7000000000000002E-3,859.44,1888430.9299999995,null,52546.337844686866,1786575.4867193522]
[null,null,null,null,null,"2022-01-01",2022,{"$f":"IF(MONTH(F72)=0,\"\",IF(MONTH(F72)<4,\"Q1\",IF(MONTH(F72)<7,\"Q2\",IF(MONTH(F72)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G72,\" \",H72)","v":"2022 Q1"},{"$f":"J71+K71","v":1864891.0499999996},52995.839999999997,5.7000000000000002E-3,{"$f":"ROUND(J72*L72/12,2)","v":885.82},{"$f":"N71+K72+M72","v":1942312.5899999996},null,52546.337844686866,{"$f":"Q71+P72","v":1839121.824564039}]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",1917886.8899999997,52948.72,5.7000000000000002E-3,911,1996172.3099999996,null,52546.337844686866,1891668.1624087258]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",1970835.6099999996,59524.58,5.7000000000000002E-3,936.15,2056633.0399999996,null,52546.337844686866,1944214.5002534126]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",2030360.1899999997,51626.07,1.0200000000000001E-2,1725.81,2109984.9199999995,null,52546.337844686866,1996760.8380980995]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",2081986.2599999998,56915.67,1.0200000000000001E-2,1769.69,2168670.2799999993,null,52546.337844686866,2049307.1759427863]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",2138901.9299999997,56524.97,1.0200000000000001E-2,1818.07,2227013.3199999994,null,52546.337844686866,2101853.5137874731]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",2195426.9,56452.49,2.1999999999999999E-2,4024.95,2287490.7599999998,null,52546.337844686866,2154399.8516321601]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",2251879.39,58406.84,2.1999999999999999E-2,4128.45,2350026.0499999998,null,52546.337844686866,2206946.1894768472]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",2310286.23,52298.6,2.1999999999999999E-2,4235.5200000000004,2406560.17,null,52546.337844686866,2259492.5273215342]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",2362584.83,47756.94,3.8699999999999998E-2,7619.34,2461936.4499999997,null,52546.337844686866,2312038.8651662213]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",2410341.77,51801.57,3.8699999999999998E-2,7773.35,2521511.3699999996,null,52546.337844686866,2364585.2030109083]
[null,null,null,null,null,"2022-12-01",2022,"Q4","2022 Q4",2462143.34,57550.98,3.8699999999999998E-2,7940.41,2587002.7599999998,null,52546.337844686866,2417131.5408555954]
[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"},{"$f":"CONCATENATE(G84,\" \",H84)","v":"2023 Q1"},{"$f":"J83+K83","v":2519694.3199999998},54636.7,4.7300000000000002E-2,{"$f":"ROUND(J84*L84/12,2)","v":9931.7999999999993},{"$f":"N83+K84+M84","v":2651571.2599999998},null,52546.337844686866,{"$f":"Q83+P84","v":2469677.8787002824}]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",2574331.02,49857.48,4.7300000000000002E-2,10147.15,2711575.8899999997,null,52546.337844686866,2522224.2165449695]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",2624188.5,56391.42,4.7300000000000002E-2,10343.68,2778310.9899999998,null,52546.337844686866,2574770.5543896565]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",2680579.92,52926.9,4.9799999999999997E-2,11124.41,2842362.3,null,52546.337844686866,2627316.8922343436]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",2733506.82,54409.73,4.9799999999999997E-2,11344.05,2908116.0799999996,null,52546.337844686866,2679863.2300790306]
[null,null,null,null,null,"2023-06-01",2023,"Q2","2023 Q2",2787916.55,55124.76,4.9799999999999997E-2,11569.85,2974810.6899999995,null,52546.337844686866,2732409.5679237177]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",2843041.3099999996,56064.81,4.9799999999999997E-2,11798.62,3042674.1199999996,null,52546.337844686866,2784955.9057684047]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",2899106.1199999996,54995.51,4.9799999999999997E-2,12031.29,3109700.9199999995,null,52546.337844686866,2837502.2436130918]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",2954101.6299999994,54322.32,4.9799999999999997E-2,12259.52,3176282.7599999993,null,52546.337844686866,2890048.5814577788]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",3008423.9499999993,54480.57,5.4899999999999997E-2,13763.54,3244526.8699999992,null,52546.337844686866,2942594.9193024659]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",3062904.5199999991,52485.83,5.4899999999999997E-2,14012.79,3311025.4899999993,null,52546.337844686866,2995141.2571471529]
[null,null,null,null,null,"2023-12-01",2023,"Q4","2023 Q4",3115390.3499999992,55209.27,5.4899999999999997E-2,14252.91,3380487.6699999995,null,52546.337844686866,3047687.59499184]
[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"},{"$f":"CONCATENATE(G96,\" \",H96)","v":"2024 Q1"},{"$f":"J95+K95","v":3170599.6199999992},55295.45,5.4899999999999997E-2,{"$f":"ROUND(J96*L96/12,2)","v":14505.49},{"$f":"N95+K96+M96","v":3450288.61},null,52546.337844686866,{"$f":"Q95+P96","v":3100233.932836527}]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",3225895.0699999994,51607.48,5.4899999999999997E-2,14758.47,3516654.56,null,52546.337844686866,3152780.2706812141]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",3277502.5499999993,54032.4,5.4899999999999997E-2,14994.57,3585681.53,null,52546.337844686866,3205326.6085259011]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",3331534.9499999993,53691.79,5.4899999999999997E-2,15241.77,3654615.09,null,52546.337844686866,3257872.9463705881]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",3385226.7399999993,54679.93,5.4899999999999997E-2,15487.41,3724782.43,null,52546.337844686866,3310419.2842152752]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",3439906.6699999995,55103.22,5.4899999999999997E-2,15737.57,3795623.22,null,52546.337844686866,3362965.6220599622]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",3495009.8899999997,57633.1,5.1999999999999998E-2,15145.04,3868401.3600000003,null,52546.337844686866,3415511.9599046493]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",3552642.9899999998,56950.01,5.1999999999999998E-2,15394.79,3940746.16,null,52546.337844686866,3468058.2977493363]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",3609592.9999999995,53726.44,5.1999999999999998E-2,15641.57,4010114.17,null,52546.337844686866,3520604.6355940234]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",3663319.4399999995,54672.97,4.3999999999999997E-2,13432.17,4078219.31,null,52546.337844686866,3573150.9734387104]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",3717992.4099999997,52217.42,4.3999999999999997E-2,13632.64,4144069.37,null,52546.337844686866,3625697.3112833975]
[null,null,null,null,null,"2024-12-01",2024,"Q4","2024 Q4",3770209.8299999996,55401.25,4.3999999999999997E-2,13824.1,4213294.72,null,52546.337844686866,3678243.6491280845]
[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"},{"$f":"CONCATENATE(G108,\" \",H108)","v":"2025 Q1"},{"$f":"J107+K107","v":3825611.0799999996},55166.68,3.6400000000000002E-2,{"$f":"ROUND(J108*L108/12,2)","v":11604.35},{"$f":"N107+K108+M108","v":4280065.7499999991},null,52546.337844686866,{"$f":"Q107+P108","v":3730789.9869727716}]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",3880777.76,50613.88,3.6400000000000002E-2,11771.69,4342451.3199999994,null,52546.337844686866,3783336.3248174586]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",3931391.6399999997,56765.15,3.6400000000000002E-2,11925.22,4411141.6899999995,null,52546.337844686866,3835882.6626621457]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",3988156.7899999996,52800.97,3.1600000000000003E-2,10502.15,4474444.8099999996,null,52546.337844686866,3888429.0005068327]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",4040957.76,55284.76,3.1600000000000003E-2,10641.19,4540370.76,null,52546.337844686866,3940975.3383515198]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",4096242.5199999996,56436.160000000003,3.1600000000000003E-2,10786.77,4607593.6899999995,null,52546.337844686866,3993521.6761962068]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",4152678.6799999997,59640.07,2.9100000000000001E-2,10070.25,4677304.01,null,52546.337844686866,4046068.0140408939]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",4212318.75,56522.66,2.9100000000000001E-2,10214.870000000001,4744041.54,null,52546.337844686866,4098614.3518855809]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",4268841.41,52519.46,2.9100000000000001E-2,10351.94,4806912.9400000004,null,52546.337844686866,4151160.689730268]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",4321360.87,56161.57,2.9100000000000001E-2,10479.299999999999,4873553.8100000005,null,52546.337844686866,4203707.0275749546]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",4377522.4400000004,52792.55,2.9100000000000001E-2,10615.49,4936961.8500000006,null,52546.337844686866,4256253.3654196411]
[null,null,null,null,null,"2025-12-01",2025,"Q4","2025 Q4",4430314.99,57500.9,2.9100000000000001E-2,10743.51,5005206.2600000007,null,52546.337844686866,4308799.7032643277]
[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"},{"$f":"CONCATENATE(G120,\" \",H120)","v":"2026 Q1"},{"$f":"J119+K119","v":4487815.8900000006},55679.504578082197,2.5499999999999998E-2,{"$f":"ROUND(J120*L120/12,2)","v":9536.61},{"$f":"N119+K120+M120","v":5070422.3745780829},null,52546.337844686866,{"$f":"Q119+P120","v":4361346.0411090143}]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",4543495.3945780825,50977.19275452054,2.5499999999999998E-2,9654.93,5131054.4973326027,null,52546.337844686866,4413892.3789537009]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",4594472.5873326026,55246.391420821921,2.5499999999999998E-2,9763.25,5196064.1387534244,null,52546.337844686866,4466438.7167983875]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",4649718.9787534242,53061.374583561636,2.5499999999999998E-2,9880.65,5259006.1633369867,null,52546.337844686866,4518985.0546430741]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",4702780.3533369862,54494.638184109586,2.5499999999999998E-2,9993.41,5323494.2115210965,null,52546.337844686866,4571531.3924877606]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",4757274.9915210959,54784.347895890402,2.5499999999999998E-2,10109.209999999999,5388387.769416987,null,52546.337844686866,4624077.7303324472]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",4812059.3394169863,58587.262057534252,2.5499999999999998E-2,10225.629999999999,5457200.6614745213,null,52546.337844686866,4676624.0681771338]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",4870646.6014745208,57359.211074520543,2.5499999999999998E-2,10350.120000000001,5524909.9925490422,null,52546.337844686866,4729170.4060218204]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",4928005.8125490416,54580.503997260268,2.5499999999999998E-2,10472.01,5589962.5065463027,null,52546.337844686866,4781716.743866507]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",4982586.3165463023,54703.928239452056,2.5499999999999998E-2,10588,5655254.4347857544,null,52546.337844686866,4834263.0817111935]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",5037290.244785754,52925.69992328767,2.5499999999999998E-2,10704.24,5718884.3747090427,null,52546.337844686866,4886809.4195558801]
[null,null,null,null,null,"2026-12-01",2026,"Q4","2026 Q4",5090215.9447090421,55711.10282575342,2.5499999999999998E-2,10816.71,5785412.1875347961,null,52546.337844686866,4939355.7574005667]

{"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,2019,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":130614.52226373838},null,{"$f":"H23+D24+F24","v":130614.52226373838},null,{"$f":"(H24+H23)/2","v":65307.261131869192},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C28:C31)","v":2.2474999999999998E-2},null,{"$f":"J24*L24","v":1467.7806939387599}]
[null,2020,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!K357","v":130614.52226373838},null,{"$f":"H24+D25+F25","v":261229.04452747677},null,{"$f":"(H25+H24)/2","v":195921.78339560758},null,{"$f":"AVERAGE('7. Rate Rider Revs'!C32:C35)","v":1.3749999999999998E-2},null,{"$f":"J25*L25","v":2693.9245216896038}]
[null,2021,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!M357","v":130614.52226373838},null,391843.56679121515,null,326536.30565934593,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C36:C39)","v":5.7000000000000002E-3},null,1861.2569422582719]
[null,2022,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!O357","v":130614.52226373838},null,522458.08905495354,null,457150.82792308438,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C40:C43)","v":1.915E-2},null,8754.4383547270663]
[null,2023,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!Q357","v":130614.52226373838},null,653072.61131869187,null,587765.3501868227,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C44:C47)","v":5.0449999999999995E-2},null,29652.761916925203]
[null,2024,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!S357","v":130614.52226373838},null,783687.13358243019,null,718379.87245056103,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C48:C51)","v":5.1449999999999996E-2},null,36960.644437581359]
[null,2025,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!U357","v":134074.46870511907},null,917761.60228754929,null,850724.36793498974,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C52:C55)","v":3.1550000000000002E-2},null,26840.353808348929]
[null,2026,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!W357","v":134074.46870511907},null,1051836.0709926684,null,984798.83664010884,null,{"$f":"AVERAGE('7. Rate Rider Revs'!C56:C59)","v":2.5499999999999998E-2},null,25112.370334322775]
[]
[]
[]
[null,"Cumulative Interest to 2019",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N24)","v":1467.7806939387599}]
[null,"Cumulative Interest to 2020",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N25)","v":4161.7052156283635}]
[null,"Cumulative Interest to 2021",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N26)","v":6022.9621578866354}]
[null,"Cumulative Interest to 2022",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N27)","v":14777.400512613702}]
[null,"Cumulative Interest to 2023",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N28)","v":44430.162429538905}]
[null,"Cumulative Interest to 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N29)","v":81390.806867120264}]
[null,"Cumulative Interest to 2025",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N30)","v":108231.16067546919}]
[null,"Cumulative Interest to 2026",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N$23:N31)","v":133343.53100979197}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":26,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,27],[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,null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,null,null,{"$f":"'6. ICMIRR '!$F$88/12*10","v":328204.31374064012},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,{"$f":"'6. ICMIRR '!$F$88","v":393845.17648876813},null,null,{"$f":"SUM(G22:W22)","v":3085120.5491620172}]
[]
[null,null,"Interest on Deferred and forecasted Amortization Expense (Sheet 8)",null,null,null,{"$f":"'8. Opex Interest Annual'!$N$23","v":0},null,{"$f":"'8. Opex Interest Annual'!$N$24","v":1467.7806939387599},null,{"$f":"'8. Opex Interest Annual'!$N$25","v":2693.9245216896038},null,{"$f":"'8. Opex Interest Annual'!$N$26","v":1861.2569422582719},null,{"$f":"'8. Opex Interest Annual'!$N$27","v":8754.4383547270663},null,{"$f":"'8. Opex Interest Annual'!$N$28","v":29652.761916925203},null,{"$f":"'8. Opex Interest Annual'!$N$29","v":36960.644437581359},null,{"$f":"'8. Opex Interest Annual'!$N$30","v":26840.353808348929},null,{"$f":"'8. Opex Interest Annual'!$N$31","v":25112.370334322775},null,null,{"$f":"SUM(G24:W24)","v":133343.53100979197}]
[]
[]
[null,null,"ICM Rate Rider Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Rider Revs'!K24:K35)","v":0},null,{"$f":"SUM('7. Rate Rider Revs'!K36:K47)","v":556136.03999999992},null,{"$f":"SUM('7. Rate Rider Revs'!K48:K59)","v":655766.07999999996},null,{"$f":"SUM('7. Rate Rider Revs'!K60:K71)","v":652988.93000000017},null,{"$f":"SUM('7. Rate Rider Revs'!K72:K83)","v":654803.2699999999},null,{"$f":"SUM('7. Rate Rider Revs'!K84:K95)","v":650905.29999999993},null,{"$f":"SUM('7. Rate Rider Revs'!K96:K107)","v":655011.46000000008},null,{"$f":"SUM('7. Rate Rider Revs'!K108:K119)","v":662204.81000000006},null,{"$f":"SUM('7. Rate Rider Revs'!K120:K131)","v":658111.15753479442},null,null,{"$f":"SUM(G27:W27)","v":5145927.0475347936}]
[]
[null,null,"ICM Rate Rider Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Rate Rider Revs'!M27:M35)","v":0},null,{"$f":"SUM('7. Rate Rider Revs'!M36:M47)","v":4504.6600000000008},null,{"$f":"SUM('7. Rate Rider Revs'!M48:M59)","v":10442.5},null,{"$f":"SUM('7. Rate Rider Revs'!M60:M71)","v":8592.7199999999993},null,{"$f":"SUM('7. Rate Rider Revs'!M72:M83)","v":43768.56},null,{"$f":"SUM('7. Rate Rider Revs'!M84:M95)","v":142579.61000000002},null,{"$f":"SUM('7. Rate Rider Revs'!M96:M107)","v":177795.59000000005},null,{"$f":"SUM('7. Rate Rider Revs'!M108:M119)","v":129706.73000000001},null,{"$f":"SUM('7. Rate Rider Revs'!M120:M131)","v":122094.76999999999},null,null,{"$f":"SUM(G29:W29)","v":639485.14000000013}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":0},null,{"$f":"(I22+I24)-(I27+I29)","v":-230968.60556542105},null,{"$f":"(K22+K24)-(K27+K29)","v":-269669.47898954223},null,{"$f":"(M22+M24)-(M27+M29)","v":-265875.21656897373},null,{"$f":"(O22+O24)-(O27+O29)","v":-295972.21515650465},null,{"$f":"(Q22+Q24)-(Q27+Q29)","v":-369986.97159430658},null,{"$f":"(S22+S24)-(S27+S29)","v":-402001.22907365067},null,{"$f":"(U22+U24)-(U27+U29)","v":-371226.00970288296},null,{"$f":"(W22+W24)-(W27+W29)","v":-361248.3807117035},null,null,{"$f":"(Z22+Z24)-(Z27+Z29)","v":-2566948.1073629851}]