{"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_2019","7. Funding Adder Revs","8. Opex Interest Annual","9. IRR"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":9064,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Utility_Info_","index":0,"n_rows":85,"n_cols":28,"rows_kept":85,"cut":false,"hidden":false,"merged":[[20,3,20,5],[22,3,22,7],[18,3,18,4],[1,2,1,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[14,3,14,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algoma Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atikokan Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attawapiskat Power Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluewater Power Distribution Corp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brant County Power"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brantford Power Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burlington Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cambridge and North Dumfries Hydro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canadian Niagara Power Inc. – Eastern Ontario Power/Fort Erie/Port Colborne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre Wellington Hydro Ltd."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chapleau Public Utilities Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLLUS Power Corp."]
[null,null,null,null,null,null,null,"Version",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooperative Hydro Embrun Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.L.K. Energy Inc."]
[null,null,"Utility Name   ","Alectra Utilities Corporation - PowerStream Rate Zone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enersource Hydro Mississauga Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entegrus Powerlines Inc."]
[null,null,"Assigned EB Number",null,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 & Reporting",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 - Road Authority YRRT ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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":226,"n_cols":11,"rows_kept":226,"cut":false,"hidden":false,"merged":[[172,2,172,3],[174,2,174,3],[176,2,176,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,2019,null,null,null,"Total"]
[null,"Sheet 2: ICM Capital Cost Data",null,null,null,null,"Audited Actual"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"Capital Costs"]
[null,null,null,null,"Asset Type"]
[null,null,"SYSTEM ACCESS",null,"Asset type must be selected to enable calculations",null,{"$f":"IF(ISBLANK(G19),\"\",G19)","v":"Audited Actual"},null,{"$f":"IF(ISBLANK(I19),\"\",I19)","v":""}]
[null,null,null,null,"OH Swtch & Cpctrs",null,1557599.1713472982,null,null,null,{"$f":"SUM(G42,I42)","v":1557599.1713472982}]
[]
[null,null,null,null,"Concrete Poles",null,9520855.362473404,null,null,null,{"$f":"SUM(G44,I44)","v":9520855.362473404}]
[]
[null,null,null,null,"Wood Poles",null,-2193.7597954715297,null,null,null,{"$f":"SUM(G46,I46)","v":-2193.7597954715297}]
[]
[null,null,null,null,"OH Transformers",null,1730665.7459414422,null,null,null,{"$f":"SUM(G48,I48)","v":1730665.7459414422}]
[]
[null,null,null,null,"OH Prim Cond & Dev",null,2595998.6189121632,null,null,null,{"$f":"SUM(G50,I50)","v":2595998.6189121632}]
[]
[null,null,null,null,"OH Sec Cond & Dev",null,865332.8729707211,null,null,null,865332.8729707211]
[]
[null,null,null,null,"UG Transformers",null,175689.70025270237,null,null,null,175689.70025270237]
[]
[null,null,null,null,"UG Conduit",null,488026.94514639548,null,null,null,488026.94514639548]
[]
[null,null,null,null,"UG Prim XLPE TR",null,1300042.8360166654,null,null,null,1300042.8360166654]
[]
[null,null,null,null,"UG Sec - Dir Buried",null,519199.72378243261,null,null,null,519199.72378243261]
[]
[null,null,null,null,"UG Sec In Duct/Svs",null,195210.77805855821,null,null,null,{"$f":"SUM(G62,I62)","v":195210.77805855821}]
[]
[null,null,null,null,"Air Insulated Switchgear",null,156168.62244684657,null,null,null,{"$f":"SUM(G64,I64)","v":156168.62244684657}]
[]
[null,null,null,null,"Solid Dielectric Switchgear",null,156168.62244684657,null,null,null,{"$f":"SUM(G66,I66)","v":156168.62244684657}]
[]
[null,null,"Total System Access",null,null,null,{"$f":"SUM(G42,G44,G46,G48,G50,G52,G54,G56,G58,G60,G62,G64,G66)","v":19258765.240000002},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,K62,K64,K66)","v":19258765.240000002}]
[]
[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":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G72,I72)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G74,I74)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G76,I76)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G78,I78)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G80,I80)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G82,I82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G84,I84)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G86,I86)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G88,I88)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Renewal",null,null,null,{"$f":"SUM(G72,G74,G76,G78,G80,G82,G84,G86,G88,G90)","v":0},null,{"$f":"SUM(I72,I74,I76,I78,I80,I82,I84,I86,I88,I90)","v":0},null,{"$f":"SUM(K72,K74,K76,K78,K80,K82,K84,K86,K88,K90)","v":0}]
[]
[null,null,null,null,{"$f":"E70","v":"Asset Type"}]
[null,null,"SYSTEM SERVICE",null,null,null,{"$f":"G71","v":"Audited Actual"},null,{"$f":"I71","v":""}]
[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,{"$f":"SUM(G108,I108)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G110,I110)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G112,I112)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total System Service",null,null,null,{"$f":"SUM(G96,G98,G100,G102,G104,G106,G108,G110,G112,G114)","v":0},null,{"$f":"SUM(I96,I98,I100,I102,I104,I106,I108,I110,I112,I114)","v":0},null,{"$f":"SUM(K96,K98,K100,K102,K104,K106,K108,K110,K112,K114)","v":0}]
[]
[null,null,null,null,{"$f":"E94","v":"Asset Type"}]
[null,null,"GENERAL PLANT",null,null,null,"Audited Actual",null,{"$f":"I95","v":""}]
[]
[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,{"$f":"SUM(G133,I133)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G135,I135)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G137,I137)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total General Plant",null,null,null,{"$f":"SUM(G121,G123,G125,G127,G129,G131,G133,G135,G137,G139)","v":0},null,{"$f":"SUM(I121,I123,I125,I127,I129,I131,I133,I135,I137,I139)","v":0},null,{"$f":"SUM(K121,K123,K125,K127,K129,K131,K133,K135,K137,K139)","v":0}]
[]
[null,null,null,null,{"$f":"E118","v":"Asset Type"}]
[null,null,null,null,null,null,"Audited Actual",null,{"$f":"I119","v":""}]
[]
[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,{"$f":"SUM(G158,I158)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G160,I160)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G162,I162)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total ",null,null,null,{"$f":"SUM(G146,G148,G150,G152,G154,G156,G158,G160,G162,G164)","v":0},null,{"$f":"SUM(I146,I148,I150,I152,I154,I156,I158,I160,I162,I164)","v":0},null,{"$f":"SUM(K146,K148,K150,K152,K154,K156,K158,K160,K162,K164)","v":0}]
[]
[null,null,"Total Capital Costs Related to Incremental Capital Projects (ICP)",null,null,null,{"$f":"G166+G141+G116+G92+G68","v":19258765.240000002},null,{"$f":"SUM(I68,I92,I116,I141,I166)","v":0},null,{"$f":"SUM(K68,K92,K116,K141,K166)","v":19258765.240000002}]
[]
[null,null,null,null,{"$f":"E143","v":"Asset Type"}]
[null,null,"OTHER CAPITAL COST",null,null,null,"Audited Actual",null,{"$f":"I144","v":""}]
[]
[null,null,"A",null,null,null,null,null,null,null,{"$f":"SUM(G173,I173)","v":0}]
[]
[null,null,"B",null,null,null,null,null,null,null,{"$f":"SUM(G175,I175)","v":0}]
[]
[null,null,"C",null,null,null,null,null,null,null,{"$f":"SUM(G177,I177)","v":0}]
[]
[null,null,"Total Other Capital Costs ",null,null,null,{"$f":"SUM(G173,G175,G177)","v":0},null,{"$f":"SUM(I173,I175,I177)","v":0},null,{"$f":"SUM(K173,K175,K177)","v":0}]
[]
[null,null,"Total ICM Capital Costs",null,null,null,{"$f":"G168+G179","v":19258765.240000002},null,{"$f":"I168+I179","v":0},null,{"$f":"K168+K179","v":19258765.240000002}]
[]
[]
[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$177,$D188,G$42:G$177)","v":1557599.1713472982},null,{"$f":"SUMIF($E$42:$E$177,$D188,I$42:I$177)","v":0},null,{"$f":"SUM(G188:J188)","v":1557599.1713472982}]
[]
[null,null,120223,"Concrete Poles",1830,null,{"$f":"SUMIF($E$42:$E$177,$D190,G$42:G$177)","v":9520855.362473404},null,{"$f":"SUMIF($E$42:$E$177,$D190,I$42:I$177)","v":0},null,{"$f":"SUM(G190:J190)","v":9520855.362473404}]
[]
[null,null,120221,"Wood Poles",1830,null,{"$f":"SUMIF($E$42:$E$177,$D192,G$42:G$177)","v":-2193.7597954715297},null,{"$f":"SUMIF($E$42:$E$177,$D192,I$42:I$177)","v":0},null,{"$f":"SUM(G192:J192)","v":-2193.7597954715297}]
[]
[null,null,120225,"OH Transformers",1850,null,{"$f":"SUMIF($E$42:$E$177,$D194,G$42:G$177)","v":1730665.7459414422},null,{"$f":"SUMIF($E$42:$E$177,$D194,I$42:I$177)","v":0},null,{"$f":"SUM(G194:J194)","v":1730665.7459414422}]
[]
[null,null,120224,"OH Prim Cond & Dev",1835,null,{"$f":"SUMIF($E$42:$E$177,$D196,G$42:G$177)","v":2595998.6189121632},null,{"$f":"SUMIF($E$42:$E$177,$D196,I$42:I$177)","v":0},null,{"$f":"SUM(G196:J196)","v":2595998.6189121632}]
[]
[null,null,120226,"OH Sec Cond & Dev",1855,null,{"$f":"SUMIF($E$42:$E$177,$D198,G$42:G$177)","v":865332.8729707211},null,{"$f":"SUMIF($E$42:$E$177,$D198,I$42:I$177)","v":0},null,{"$f":"SUM(G198:J198)","v":865332.8729707211}]
[]
[null,null,120243,"UG Transformers",1850,null,{"$f":"SUMIF($E$42:$E$177,$D200,G$42:G$177)","v":175689.70025270237},null,{"$f":"SUMIF($E$42:$E$177,$D200,I$42:I$177)","v":0},null,{"$f":"SUM(G200:J200)","v":175689.70025270237}]
[]
[null,null,120245,"UG Conduit",1840,null,{"$f":"SUMIF($E$42:$E$177,$D202,G$42:G$177)","v":488026.94514639548},null,{"$f":"SUMIF($E$42:$E$177,$D202,I$42:I$177)","v":0},null,{"$f":"SUM(G202:J202)","v":488026.94514639548}]
[]
[null,null,"120241.XLPETR","UG Prim XLPE TR",1845,null,{"$f":"SUMIF($E$42:$E$177,$D204,G$42:G$177)","v":1300042.8360166654},null,{"$f":"SUMIF($E$42:$E$177,$D204,I$42:I$177)","v":0},null,{"$f":"SUM(G204:J204)","v":1300042.8360166654}]
[]
[null,null,"120242.DB","UG Sec - Dir Buried",1845,null,{"$f":"SUMIF($E$42:$E$177,$D206,G$42:G$177)","v":519199.72378243261},null,{"$f":"SUMIF($E$42:$E$177,$D206,I$42:I$177)","v":0},null,{"$f":"SUM(G206:J206)","v":519199.72378243261}]
[]
[null,null,"120242.IDSERV","UG Sec In Duct/Svs",1845,null,{"$f":"SUMIF($E$42:$E$177,$D208,G$42:G$177)","v":195210.77805855821},null,0,null,195210.77805855821]
[]
[null,null,120248,"Air Insulated Switchgear",1845,null,156168.62244684657,null,0,null,156168.62244684657]
[]
[null,null,120249,"Solid Dielectric Switchgear",1845,null,156168.62244684657,null,0,null,156168.62244684657]
[]
[null,null,120244,"UG Cable Injection",1845,null,0,null,0,null,{"$f":"SUM(G214:J214)","v":0}]
[]
[null,null,"120063.MS","MS Integrated P&C Systems ",1820,null,0,null,0,null,{"$f":"SUM(G216:J216)","v":0}]
[]
[null,null,"120021.MS","MS Building Improvements ",1820,null,0,null,0,null,{"$f":"SUM(G218:J218)","v":0}]
[]
[null,null,130104,"Capital Contributions Paid ",1609,null,0,null,0,null,{"$f":"SUM(G220:J220)","v":0}]
[]
[]
[]
[]
[null,null,null,"Total Capital Costs",null,null,{"$f":"SUM(G188:G223)","v":19258765.240000002},null,{"$f":"SUM(I188:I223)","v":0},null,{"$f":"SUM(K188:K223)","v":19258765.240000002}]
[null,null,null,null,null,null,{"$f":"IF(G225=G181,\" \",\"Error\")","v":" "},null,{"$f":"IF(I225=I181,\"\",\"Error\")","v":""},null,{"$f":"IF(K225=K181,\"\",\"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,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2,null,1.7600000000000001E-2]
[null,null,null,"Long-term Debt Rate (actual/embedded/deemed)1",null,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2,null,3.8825039999999998E-2]
[null,null,null,"Target Return on Equity (ROE)",null,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2,null,8.7800000000000003E-2]
[null,null,null,"Return on Preferred Shares"]
[null,null,"WACC",null,null,null,{"$f":"SUMPRODUCT(G22:G25,G29:G32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(I22:I25,I29:I32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(K22:K25,K29:K32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(M22:M25,M29:M32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(O22:O25,O29:O32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(Q22:Q25,Q29:Q32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(S22:S25,S29:S32)","v":5.75660224E-2},null,{"$f":"SUMPRODUCT(U22:U25,U29:U32)","v":5.75660224E-2}]
[]
[null,"Working Capital Allowance"]
[null,null,"Working Capital Allowance Rate",null,null,null,7.4999999999999997E-2,null,7.4999999999999997E-2,null,7.4999999999999997E-2,null,7.4999999999999997E-2,null,7.4999999999999997E-2,null,7.4999999999999997E-2,null,7.4999999999999997E-2,null,7.4999999999999997E-2]
[null,null,"(% of the sum of Cost of Power + controllable expenses)"]
[]
[null,"Taxes/PILs"]
[null,null,"Aggregate Corporate Income Tax Rate",null,null,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001,null,0.26500000000000001]
[null,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,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,2.5000000000000001E-2,null,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,{"$f":"'3. Cost_of_Service_Parameters'!G19","v":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":1557599.1713472982},null,{"$f":"K25","v":1557599.1713472982},null,{"$f":"M25","v":1557599.1713472982},null,{"$f":"O25","v":1557599.1713472982},null,{"$f":"Q25","v":1557599.1713472982},null,{"$f":"S25","v":1557599.1713472982},null,{"$f":"U25","v":1557599.1713472982}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G188","v":1557599.1713472982},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":1557599.1713472982},null,{"$f":"K22+K23-K24","v":1557599.1713472982},null,{"$f":"M22+M23-M24","v":1557599.1713472982},null,{"$f":"O22+O23-O24","v":1557599.1713472982},null,{"$f":"Q22+Q23-Q24","v":1557599.1713472982},null,{"$f":"S22+S23-S24","v":1557599.1713472982},null,{"$f":"U22+U23-U24","v":1557599.1713472982},null,{"$f":"W22+W23-W24","v":1557599.1713472982}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I31","v":-40989.451877560481},null,{"$f":"K31","v":-81978.903755120962},null,{"$f":"M31","v":-122968.35563268144},null,{"$f":"O31","v":-163957.80751024192},null,{"$f":"Q31","v":-204947.25938780239},null,{"$f":"S31","v":-245936.71126536286},null,{"$f":"U31","v":-290439.54473242851}]
[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":-40989.451877560481},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":-40989.451877560481},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":-40989.451877560481},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":-40989.451877560481},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":-40989.451877560481},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":-40989.451877560481},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":-44502.833467065662},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":-44502.833467065662}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I28+I29-I30","v":-40989.451877560481},null,{"$f":"K28+K29-K30","v":-81978.903755120962},null,{"$f":"M28+M29-M30","v":-122968.35563268144},null,{"$f":"O28+O29-O30","v":-163957.80751024192},null,{"$f":"Q28+Q29-Q30","v":-204947.25938780239},null,{"$f":"S28+S29-S30","v":-245936.71126536286},null,{"$f":"U28+U29-U30","v":-290439.54473242851},null,{"$f":"W28+W29-W30","v":-334942.37819949415}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I22+I28","v":0},null,{"$f":"I35","v":1516609.7194697377},null,{"$f":"K35","v":1475620.2675921773},null,{"$f":"M35","v":1434630.8157146168},null,{"$f":"O35","v":1393641.3638370563},null,{"$f":"Q35","v":1352651.9119594959},null,{"$f":"S35","v":1311662.4600819354},null,{"$f":"U35","v":1267159.6266148696}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I25+I31","v":1516609.7194697377},null,{"$f":"K25+K31","v":1475620.2675921773},null,{"$f":"M25+M31","v":1434630.8157146168},null,{"$f":"O25+O31","v":1393641.3638370563},null,{"$f":"Q25+Q31","v":1352651.9119594959},null,{"$f":"S25+S31","v":1311662.4600819354},null,{"$f":"U25+U31","v":1267159.6266148696},null,{"$f":"W25+W31","v":1222656.793147804}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I35","v":1516609.7194697377},null,{"$f":"AVERAGE(K34:K35)","v":1496114.9935309575},null,{"$f":"AVERAGE(M34:M35)","v":1455125.541653397},null,{"$f":"AVERAGE(O34:O35)","v":1414136.0897758366},null,{"$f":"AVERAGE(Q34:Q35)","v":1373146.6378982761},null,{"$f":"AVERAGE(S34:S35)","v":1332157.1860207156},null,{"$f":"AVERAGE(U34:U35)","v":1289411.0433484025},null,{"$f":"AVERAGE(W34:W35)","v":1244908.2098813369}]
[]
[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":9520855.362473404},null,{"$f":"K44","v":9520855.362473404},null,{"$f":"M44","v":9520855.362473404},null,{"$f":"O44","v":9520855.362473404},null,{"$f":"Q44","v":9520855.362473404},null,{"$f":"S44","v":9520855.362473404},null,{"$f":"U44","v":9520855.362473404}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G190","v":9520855.362473404},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":9520855.362473404},null,{"$f":"K41+K42-K43","v":9520855.362473404},null,{"$f":"M41+M42-M43","v":9520855.362473404},null,{"$f":"O41+O42-O43","v":9520855.362473404},null,{"$f":"Q41+Q42-Q43","v":9520855.362473404},null,{"$f":"S41+S42-S43","v":9520855.362473404},null,{"$f":"U41+U42-U43","v":9520855.362473404},null,{"$f":"W41+W42-W43","v":9520855.362473404}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I50","v":-186683.43847987067},null,{"$f":"K50","v":-373366.87695974135},null,{"$f":"M50","v":-560050.31543961202},null,{"$f":"O50","v":-746733.7539194827},null,{"$f":"Q50","v":-933417.19239935337},null,{"$f":"S50","v":-1120100.630879224},null,{"$f":"U50","v":-1278781.5535871142}]
[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":-186683.43847987067},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":-186683.43847987067},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":-186683.43847987067},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":-186683.43847987067},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":-186683.43847987067},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":-186683.43847987067},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":-158680.92270789007},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":-158680.92270789007}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I47+I48-I49","v":-186683.43847987067},null,{"$f":"K47+K48-K49","v":-373366.87695974135},null,{"$f":"M47+M48-M49","v":-560050.31543961202},null,{"$f":"O47+O48-O49","v":-746733.7539194827},null,{"$f":"Q47+Q48-Q49","v":-933417.19239935337},null,{"$f":"S47+S48-S49","v":-1120100.630879224},null,{"$f":"U47+U48-U49","v":-1278781.5535871142},null,{"$f":"W47+W48-W49","v":-1437462.4762950044}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I41+I47","v":0},null,{"$f":"I54","v":9334171.9239935335},null,{"$f":"K54","v":9147488.4855136629},null,{"$f":"M54","v":8960805.0470337924},null,{"$f":"O54","v":8774121.6085539218},null,{"$f":"Q54","v":8587438.1700740512},null,{"$f":"S54","v":8400754.7315941807},null,{"$f":"U54","v":8242073.8088862896}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I44+I50","v":9334171.9239935335},null,{"$f":"K44+K50","v":9147488.4855136629},null,{"$f":"M44+M50","v":8960805.0470337924},null,{"$f":"O44+O50","v":8774121.6085539218},null,{"$f":"Q44+Q50","v":8587438.1700740512},null,{"$f":"S44+S50","v":8400754.7315941807},null,{"$f":"U44+U50","v":8242073.8088862896},null,{"$f":"W44+W50","v":8083392.8861783994}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I54","v":9334171.9239935335},null,{"$f":"AVERAGE(K53:K54)","v":9240830.2047535982},null,{"$f":"AVERAGE(M53:M54)","v":9054146.7662737276},null,{"$f":"AVERAGE(O53:O54)","v":8867463.3277938571},null,{"$f":"AVERAGE(Q53:Q54)","v":8680779.8893139865},null,{"$f":"AVERAGE(S53:S54)","v":8494096.450834116},null,{"$f":"AVERAGE(U53:U54)","v":8321414.2702402351},null,{"$f":"AVERAGE(W53:W54)","v":8162733.347532345}]
[]
[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":-2193.7597954715297},null,{"$f":"K63","v":-2193.7597954715297},null,{"$f":"M63","v":-2193.7597954715297},null,{"$f":"O63","v":-2193.7597954715297},null,{"$f":"Q63","v":-2193.7597954715297},null,{"$f":"S63","v":-2193.7597954715297},null,{"$f":"U63","v":-2193.7597954715297}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G192","v":-2193.7597954715297}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I60+I61-I62","v":-2193.7597954715297},null,{"$f":"K60+K61-K62","v":-2193.7597954715297},null,{"$f":"M60+M61-M62","v":-2193.7597954715297},null,{"$f":"O60+O61-O62","v":-2193.7597954715297},null,{"$f":"Q60+Q61-Q62","v":-2193.7597954715297},null,{"$f":"S60+S61-S62","v":-2193.7597954715297},null,{"$f":"U60+U61-U62","v":-2193.7597954715297},null,{"$f":"W60+W61-W62","v":-2193.7597954715297}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I69","v":49.858177169807497},null,{"$f":"K69","v":99.716354339614995},null,{"$f":"M69","v":149.57453150942248},null,{"$f":"O69","v":199.43270867922999},null,{"$f":"Q69","v":249.29088584903749},null,{"$f":"S69","v":299.14906301884497},null,{"$f":"U69","v":347.89928069599006}]
[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":49.858177169807497},null,{"$f":"-I61/'3. Cost_of_Service_Parameters'!I49","v":49.858177169807497},null,{"$f":"-K60/'3. Cost_of_Service_Parameters'!K49","v":49.858177169807497},null,{"$f":"-M60/'3. Cost_of_Service_Parameters'!M49","v":49.858177169807497},null,{"$f":"-O60/'3. Cost_of_Service_Parameters'!O49","v":49.858177169807497},null,{"$f":"-Q60/'3. Cost_of_Service_Parameters'!Q49","v":49.858177169807497},null,{"$f":"-S60/'3. Cost_of_Service_Parameters'!S49","v":48.750217677145102},null,{"$f":"-U60/'3. Cost_of_Service_Parameters'!U49","v":48.750217677145102}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I66+I67-I68","v":49.858177169807497},null,{"$f":"K66+K67-K68","v":99.716354339614995},null,{"$f":"M66+M67-M68","v":149.57453150942248},null,{"$f":"O66+O67-O68","v":199.43270867922999},null,{"$f":"Q66+Q67-Q68","v":249.29088584903749},null,{"$f":"S66+S67-S68","v":299.14906301884497},null,{"$f":"U66+U67-U68","v":347.89928069599006},null,{"$f":"W66+W67-W68","v":396.64949837313515}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I60+I66","v":0},null,{"$f":"I73","v":-2143.9016183017225},null,{"$f":"K73","v":-2094.0434411319147},null,{"$f":"M73","v":-2044.1852639621072},null,{"$f":"O73","v":-1994.3270867922997},null,{"$f":"Q73","v":-1944.4689096224922},null,{"$f":"S73","v":-1894.6107324526847},null,{"$f":"U73","v":-1845.8605147755397}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I63+I69","v":-2143.9016183017225},null,{"$f":"K63+K69","v":-2094.0434411319147},null,{"$f":"M63+M69","v":-2044.1852639621072},null,{"$f":"O63+O69","v":-1994.3270867922997},null,{"$f":"Q63+Q69","v":-1944.4689096224922},null,{"$f":"S63+S69","v":-1894.6107324526847},null,{"$f":"U63+U69","v":-1845.8605147755397},null,{"$f":"W63+W69","v":-1797.1102970983945}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I73","v":-2143.9016183017225},null,{"$f":"AVERAGE(K72:K73)","v":-2118.9725297168188},null,{"$f":"AVERAGE(M72:M73)","v":-2069.1143525470111},null,{"$f":"AVERAGE(O72:O73)","v":-2019.2561753772034},null,{"$f":"AVERAGE(Q72:Q73)","v":-1969.3979982073961},null,{"$f":"AVERAGE(S72:S73)","v":-1919.5398210375884},null,{"$f":"AVERAGE(U72:U73)","v":-1870.2356236141122},null,{"$f":"AVERAGE(W72:W73)","v":-1821.4854059369673}]
[]
[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":1730665.7459414422},null,{"$f":"K82","v":1730665.7459414422},null,{"$f":"M82","v":1730665.7459414422},null,{"$f":"O82","v":1730665.7459414422},null,{"$f":"Q82","v":1730665.7459414422},null,{"$f":"S82","v":1730665.7459414422},null,{"$f":"U82","v":1730665.7459414422}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G194","v":1730665.7459414422}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I79+I80-I81","v":1730665.7459414422},null,{"$f":"K79+K80-K81","v":1730665.7459414422},null,{"$f":"M79+M80-M81","v":1730665.7459414422},null,{"$f":"O79+O80-O81","v":1730665.7459414422},null,{"$f":"Q79+Q80-Q81","v":1730665.7459414422},null,{"$f":"S79+S80-S81","v":1730665.7459414422},null,{"$f":"U79+U80-U81","v":1730665.7459414422},null,{"$f":"W79+W80-W81","v":1730665.7459414422}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I88","v":-42211.359657108347},null,{"$f":"K88","v":-84422.719314216694},null,{"$f":"M88","v":-126634.07897132504},null,{"$f":"O88","v":-168845.43862843339},null,{"$f":"Q88","v":-211056.79828554174},null,{"$f":"S88","v":-253268.15794265008},null,{"$f":"U88","v":-291727.39674134878}]
[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":-42211.359657108347},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":-42211.359657108347},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":-42211.359657108347},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":-42211.359657108347},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":-42211.359657108347},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":-42211.359657108347},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":-38459.238798698716},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":-38459.238798698716}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I85+I86-I87","v":-42211.359657108347},null,{"$f":"K85+K86-K87","v":-84422.719314216694},null,{"$f":"M85+M86-M87","v":-126634.07897132504},null,{"$f":"O85+O86-O87","v":-168845.43862843339},null,{"$f":"Q85+Q86-Q87","v":-211056.79828554174},null,{"$f":"S85+S86-S87","v":-253268.15794265008},null,{"$f":"U85+U86-U87","v":-291727.39674134878},null,{"$f":"W85+W86-W87","v":-330186.63554004749}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I79+I85","v":0},null,{"$f":"I92","v":1688454.3862843339},null,{"$f":"K92","v":1646243.0266272256},null,{"$f":"M92","v":1604031.6669701173},null,{"$f":"O92","v":1561820.3073130087},null,{"$f":"Q92","v":1519608.9476559004},null,{"$f":"S92","v":1477397.5879987921},null,{"$f":"U92","v":1438938.3492000934}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I82+I88","v":1688454.3862843339},null,{"$f":"K82+K88","v":1646243.0266272256},null,{"$f":"M82+M88","v":1604031.6669701173},null,{"$f":"O82+O88","v":1561820.3073130087},null,{"$f":"Q82+Q88","v":1519608.9476559004},null,{"$f":"S82+S88","v":1477397.5879987921},null,{"$f":"U82+U88","v":1438938.3492000934},null,{"$f":"W82+W88","v":1400479.1104013948}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I92","v":1688454.3862843339},null,{"$f":"AVERAGE(K91:K92)","v":1667348.7064557797},null,{"$f":"AVERAGE(M91:M92)","v":1625137.3467986714},null,{"$f":"AVERAGE(O91:O92)","v":1582925.9871415631},null,{"$f":"AVERAGE(Q91:Q92)","v":1540714.6274844545},null,{"$f":"AVERAGE(S91:S92)","v":1498503.2678273462},null,{"$f":"AVERAGE(U91:U92)","v":1458167.9685994429},null,{"$f":"AVERAGE(W91:W92)","v":1419708.729800744}]
[]
[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":2595998.6189121632},null,{"$f":"K101","v":2595998.6189121632},null,{"$f":"M101","v":2595998.6189121632},null,{"$f":"O101","v":2595998.6189121632},null,{"$f":"Q101","v":2595998.6189121632},null,{"$f":"S101","v":2595998.6189121632},null,{"$f":"U101","v":2595998.6189121632}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G196","v":2595998.6189121632},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":2595998.6189121632},null,{"$f":"K98+K99-K100","v":2595998.6189121632},null,{"$f":"M98+M99-M100","v":2595998.6189121632},null,{"$f":"O98+O99-O100","v":2595998.6189121632},null,{"$f":"Q98+Q99-Q100","v":2595998.6189121632},null,{"$f":"S98+S99-S100","v":2595998.6189121632},null,{"$f":"U98+U99-U100","v":2595998.6189121632},null,{"$f":"W98+W99-W100","v":2595998.6189121632}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I107","v":-57688.858198048074},null,{"$f":"K107","v":-115377.71639609615},null,{"$f":"M107","v":-173066.57459414421},null,{"$f":"O107","v":-230755.4327921923},null,{"$f":"Q107","v":-288444.29099024035},null,{"$f":"S107","v":-346133.14918828843},null,{"$f":"U107","v":-398053.12156653171}]
[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":-57688.858198048074},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":-57688.858198048074},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":-57688.858198048074},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":-57688.858198048074},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":-57688.858198048074},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":-57688.858198048074},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":-51919.972378243263},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":-51919.972378243263}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I104+I105-I106","v":-57688.858198048074},null,{"$f":"K104+K105-K106","v":-115377.71639609615},null,{"$f":"M104+M105-M106","v":-173066.57459414421},null,{"$f":"O104+O105-O106","v":-230755.4327921923},null,{"$f":"Q104+Q105-Q106","v":-288444.29099024035},null,{"$f":"S104+S105-S106","v":-346133.14918828843},null,{"$f":"U104+U105-U106","v":-398053.12156653171},null,{"$f":"W104+W105-W106","v":-449973.093944775}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I98+I104","v":0},null,{"$f":"I111","v":2538309.7607141151},null,{"$f":"K111","v":2480620.902516067},null,{"$f":"M111","v":2422932.0443180189},null,{"$f":"O111","v":2365243.1861199709},null,{"$f":"Q111","v":2307554.3279219228},null,{"$f":"S111","v":2249865.4697238747},null,{"$f":"U111","v":2197945.4973456315}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I101+I107","v":2538309.7607141151},null,{"$f":"K101+K107","v":2480620.902516067},null,{"$f":"M101+M107","v":2422932.0443180189},null,{"$f":"O101+O107","v":2365243.1861199709},null,{"$f":"Q101+Q107","v":2307554.3279219228},null,{"$f":"S101+S107","v":2249865.4697238747},null,{"$f":"U101+U107","v":2197945.4973456315},null,{"$f":"W101+W107","v":2146025.5249673882}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I111","v":2538309.7607141151},null,{"$f":"AVERAGE(K110:K111)","v":2509465.3316150913},null,{"$f":"AVERAGE(M110:M111)","v":2451776.4734170428},null,{"$f":"AVERAGE(O110:O111)","v":2394087.6152189951},null,{"$f":"AVERAGE(Q110:Q111)","v":2336398.7570209466},null,{"$f":"AVERAGE(S110:S111)","v":2278709.898822899},null,{"$f":"AVERAGE(U110:U111)","v":2223905.4835347533},null,{"$f":"AVERAGE(W110:W111)","v":2171985.5111565096}]
[]
[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":865332.8729707211},null,{"$f":"K120","v":865332.8729707211},null,{"$f":"M120","v":865332.8729707211},null,{"$f":"O120","v":865332.8729707211},null,{"$f":"Q120","v":865332.8729707211},null,{"$f":"S120","v":865332.8729707211},null,{"$f":"U120","v":865332.8729707211}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G198","v":865332.8729707211},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":865332.8729707211},null,{"$f":"K117+K118-K119","v":865332.8729707211},null,{"$f":"M117+M118-M119","v":865332.8729707211},null,{"$f":"O117+O118-O119","v":865332.8729707211},null,{"$f":"Q117+Q118-Q119","v":865332.8729707211},null,{"$f":"S117+S118-S119","v":865332.8729707211},null,{"$f":"U117+U118-U119","v":865332.8729707211},null,{"$f":"W117+W118-W119","v":865332.8729707211}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I126","v":-18027.768186890022},null,{"$f":"K126","v":-36055.536373780044},null,{"$f":"M126","v":-54083.304560670062},null,{"$f":"O126","v":-72111.072747560087},null,{"$f":"Q126","v":-90138.840934450112},null,{"$f":"S126","v":-108166.60912134014},null,{"$f":"U126","v":-125473.26658075456}]
[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":-18027.768186890022},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":-18027.768186890022},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":-18027.768186890022},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":-18027.768186890022},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":-18027.768186890022},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":-18027.768186890022},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":-17306.657459414422},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":-17306.657459414422}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I123+I124-I125","v":-18027.768186890022},null,{"$f":"K123+K124-K125","v":-36055.536373780044},null,{"$f":"M123+M124-M125","v":-54083.304560670062},null,{"$f":"O123+O124-O125","v":-72111.072747560087},null,{"$f":"Q123+Q124-Q125","v":-90138.840934450112},null,{"$f":"S123+S124-S125","v":-108166.60912134014},null,{"$f":"U123+U124-U125","v":-125473.26658075456},null,{"$f":"W123+W124-W125","v":-142779.92404016899}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I117+I123","v":0},null,{"$f":"I130","v":847305.10478383105},null,{"$f":"K130","v":829277.33659694111},null,{"$f":"M130","v":811249.56841005106},null,{"$f":"O130","v":793221.800223161},null,{"$f":"Q130","v":775194.03203627095},null,{"$f":"S130","v":757166.26384938101},null,{"$f":"U130","v":739859.60638996656}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I120+I126","v":847305.10478383105},null,{"$f":"K120+K126","v":829277.33659694111},null,{"$f":"M120+M126","v":811249.56841005106},null,{"$f":"O120+O126","v":793221.800223161},null,{"$f":"Q120+Q126","v":775194.03203627095},null,{"$f":"S120+S126","v":757166.26384938101},null,{"$f":"U120+U126","v":739859.60638996656},null,{"$f":"W120+W126","v":722552.94893055211}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I130","v":847305.10478383105},null,{"$f":"AVERAGE(K129:K130)","v":838291.22069038614},null,{"$f":"AVERAGE(M129:M130)","v":820263.45250349608},null,{"$f":"AVERAGE(O129:O130)","v":802235.68431660603},null,{"$f":"AVERAGE(Q129:Q130)","v":784207.91612971597},null,{"$f":"AVERAGE(S129:S130)","v":766180.14794282592},null,{"$f":"AVERAGE(U129:U130)","v":748512.93511967384},null,{"$f":"AVERAGE(W129:W130)","v":731206.27766025928}]
[]
[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":175689.70025270237},null,{"$f":"K139","v":175689.70025270237},null,{"$f":"M139","v":175689.70025270237},null,{"$f":"O139","v":175689.70025270237},null,{"$f":"Q139","v":175689.70025270237},null,{"$f":"S139","v":175689.70025270237},null,{"$f":"U139","v":175689.70025270237}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G200","v":175689.70025270237},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":175689.70025270237},null,{"$f":"K136+K137-K138","v":175689.70025270237},null,{"$f":"M136+M137-M138","v":175689.70025270237},null,{"$f":"O136+O137-O138","v":175689.70025270237},null,{"$f":"Q136+Q137-Q138","v":175689.70025270237},null,{"$f":"S136+S137-S138","v":175689.70025270237},null,{"$f":"U136+U137-U138","v":175689.70025270237},null,{"$f":"W136+W137-W138","v":175689.70025270237}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I145","v":-5490.3031328969491},null,{"$f":"K145","v":-10980.606265793898},null,{"$f":"M145","v":-16470.909398690848},null,{"$f":"O145","v":-21961.212531587797},null,{"$f":"Q145","v":-27451.515664484745},null,{"$f":"S145","v":-32941.818797381697},null,{"$f":"U145","v":-38798.142139138443}]
[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":-5490.3031328969491},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":-5490.3031328969491},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":-5490.3031328969491},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":-5490.3031328969491},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":-5490.3031328969491},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":-5490.3031328969491},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":-5856.3233417567453},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":-5856.3233417567453}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I142+I143-I144","v":-5490.3031328969491},null,{"$f":"K142+K143-K144","v":-10980.606265793898},null,{"$f":"M142+M143-M144","v":-16470.909398690848},null,{"$f":"O142+O143-O144","v":-21961.212531587797},null,{"$f":"Q142+Q143-Q144","v":-27451.515664484745},null,{"$f":"S142+S143-S144","v":-32941.818797381697},null,{"$f":"U142+U143-U144","v":-38798.142139138443},null,{"$f":"W142+W143-W144","v":-44654.465480895189}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I136+I142","v":0},null,{"$f":"I149","v":170199.39711980542},null,{"$f":"K149","v":164709.09398690847},null,{"$f":"M149","v":159218.79085401152},null,{"$f":"O149","v":153728.48772111456},null,{"$f":"Q149","v":148238.18458821764},null,{"$f":"S149","v":142747.88145532069},null,{"$f":"U149","v":136891.55811356392}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I139+I145","v":170199.39711980542},null,{"$f":"K139+K145","v":164709.09398690847},null,{"$f":"M139+M145","v":159218.79085401152},null,{"$f":"O139+O145","v":153728.48772111456},null,{"$f":"Q139+Q145","v":148238.18458821764},null,{"$f":"S139+S145","v":142747.88145532069},null,{"$f":"U139+U145","v":136891.55811356392},null,{"$f":"W139+W145","v":131035.23477180718}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I149","v":170199.39711980542},null,{"$f":"AVERAGE(K148:K149)","v":167454.24555335694},null,{"$f":"AVERAGE(M148:M149)","v":161963.94242045999},null,{"$f":"AVERAGE(O148:O149)","v":156473.63928756304},null,{"$f":"AVERAGE(Q148:Q149)","v":150983.33615466609},null,{"$f":"AVERAGE(S148:S149)","v":145493.03302176917},null,{"$f":"AVERAGE(U148:U149)","v":139819.71978444231},null,{"$f":"AVERAGE(W148:W149)","v":133963.39644268557}]
[]
[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":488026.94514639548},null,{"$f":"K158","v":488026.94514639548},null,{"$f":"M158","v":488026.94514639548},null,{"$f":"O158","v":488026.94514639548},null,{"$f":"Q158","v":488026.94514639548},null,{"$f":"S158","v":488026.94514639548},null,{"$f":"U158","v":488026.94514639548}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G202","v":488026.94514639548},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":488026.94514639548},null,{"$f":"K155+K156-K157","v":488026.94514639548},null,{"$f":"M155+M156-M157","v":488026.94514639548},null,{"$f":"O155+O156-O157","v":488026.94514639548},null,{"$f":"Q155+Q156-Q157","v":488026.94514639548},null,{"$f":"S155+S156-S157","v":488026.94514639548},null,{"$f":"U155+U156-U157","v":488026.94514639548},null,{"$f":"W155+W156-W157","v":488026.94514639548}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I164","v":-9385.1335605076056},null,{"$f":"K164","v":-18770.267121015211},null,{"$f":"M164","v":-28155.400681522817},null,{"$f":"O164","v":-37540.534242030422},null,{"$f":"Q164","v":-46925.667802538024},null,{"$f":"S164","v":-56310.801363045626},null,{"$f":"U164","v":-64444.583782152215}]
[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":-9385.1335605076056},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":-9385.1335605076056},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":-9385.1335605076056},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":-9385.1335605076056},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":-9385.1335605076056},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":-9385.1335605076056},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":-8133.7824191065911},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":-8133.7824191065911}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I161+I162-I163","v":-9385.1335605076056},null,{"$f":"K161+K162-K163","v":-18770.267121015211},null,{"$f":"M161+M162-M163","v":-28155.400681522817},null,{"$f":"O161+O162-O163","v":-37540.534242030422},null,{"$f":"Q161+Q162-Q163","v":-46925.667802538024},null,{"$f":"S161+S162-S163","v":-56310.801363045626},null,{"$f":"U161+U162-U163","v":-64444.583782152215},null,{"$f":"W161+W162-W163","v":-72578.366201258803}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I155+I161","v":0},null,{"$f":"I168","v":478641.81158588786},null,{"$f":"K168","v":469256.67802538024},null,{"$f":"M168","v":459871.54446487268},null,{"$f":"O168","v":450486.41090436507},null,{"$f":"Q168","v":441101.27734385745},null,{"$f":"S168","v":431716.14378334983},null,{"$f":"U168","v":423582.36136424326}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I158+I164","v":478641.81158588786},null,{"$f":"K158+K164","v":469256.67802538024},null,{"$f":"M158+M164","v":459871.54446487268},null,{"$f":"O158+O164","v":450486.41090436507},null,{"$f":"Q158+Q164","v":441101.27734385745},null,{"$f":"S158+S164","v":431716.14378334983},null,{"$f":"U158+U164","v":423582.36136424326},null,{"$f":"W158+W164","v":415448.57894513669}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I168","v":478641.81158588786},null,{"$f":"AVERAGE(K167:K168)","v":473949.24480563402},null,{"$f":"AVERAGE(M167:M168)","v":464564.11124512646},null,{"$f":"AVERAGE(O167:O168)","v":455178.97768461891},null,{"$f":"AVERAGE(Q167:Q168)","v":445793.84412411123},null,{"$f":"AVERAGE(S167:S168)","v":436408.71056360367},null,{"$f":"AVERAGE(U167:U168)","v":427649.25257379655},null,{"$f":"AVERAGE(W167:W168)","v":419515.47015468997}]
[]
[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":1300042.8360166654},null,{"$f":"K177","v":1300042.8360166654},null,{"$f":"M177","v":1300042.8360166654},null,{"$f":"O177","v":1300042.8360166654},null,{"$f":"Q177","v":1300042.8360166654},null,{"$f":"S177","v":1300042.8360166654},null,{"$f":"U177","v":1300042.8360166654}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G204","v":1300042.8360166654},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":1300042.8360166654},null,{"$f":"K174+K175-K176","v":1300042.8360166654},null,{"$f":"M174+M175-M176","v":1300042.8360166654},null,{"$f":"O174+O175-O176","v":1300042.8360166654},null,{"$f":"Q174+Q175-Q176","v":1300042.8360166654},null,{"$f":"S174+S175-S176","v":1300042.8360166654},null,{"$f":"U174+U175-U176","v":1300042.8360166654},null,{"$f":"W174+W175-W176","v":1300042.8360166654}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I183","v":-34211.653579385929},null,{"$f":"K183","v":-68423.307158771859},null,{"$f":"M183","v":-102634.9607381578},null,{"$f":"O183","v":-136846.61431754372},null,{"$f":"Q183","v":-171058.26789692964},null,{"$f":"S183","v":-205269.92147631556},null,{"$f":"U183","v":-234159.76227668591}]
[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":-34211.653579385929},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":-34211.653579385929},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":-34211.653579385929},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":-34211.653579385929},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":-34211.653579385929},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":-34211.653579385929},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":-28889.840800370344},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":-28889.840800370344}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I180+I181-I182","v":-34211.653579385929},null,{"$f":"K180+K181-K182","v":-68423.307158771859},null,{"$f":"M180+M181-M182","v":-102634.9607381578},null,{"$f":"O180+O181-O182","v":-136846.61431754372},null,{"$f":"Q180+Q181-Q182","v":-171058.26789692964},null,{"$f":"S180+S181-S182","v":-205269.92147631556},null,{"$f":"U180+U181-U182","v":-234159.76227668591},null,{"$f":"W180+W181-W182","v":-263049.60307705624}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I174+I180","v":0},null,{"$f":"I187","v":1265831.1824372795},null,{"$f":"K187","v":1231619.5288578935},null,{"$f":"M187","v":1197407.8752785076},null,{"$f":"O187","v":1163196.2216991216},null,{"$f":"Q187","v":1128984.5681197359},null,{"$f":"S187","v":1094772.91454035},null,{"$f":"U187","v":1065883.0737399794}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I177+I183","v":1265831.1824372795},null,{"$f":"K177+K183","v":1231619.5288578935},null,{"$f":"M177+M183","v":1197407.8752785076},null,{"$f":"O177+O183","v":1163196.2216991216},null,{"$f":"Q177+Q183","v":1128984.5681197359},null,{"$f":"S177+S183","v":1094772.91454035},null,{"$f":"U177+U183","v":1065883.0737399794},null,{"$f":"W177+W183","v":1036993.2329396092}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I187","v":1265831.1824372795},null,{"$f":"AVERAGE(K186:K187)","v":1248725.3556475865},null,{"$f":"AVERAGE(M186:M187)","v":1214513.7020682006},null,{"$f":"AVERAGE(O186:O187)","v":1180302.0484888146},null,{"$f":"AVERAGE(Q186:Q187)","v":1146090.3949094289},null,{"$f":"AVERAGE(S186:S187)","v":1111878.7413300429},null,{"$f":"AVERAGE(U186:U187)","v":1080327.9941401647},null,{"$f":"AVERAGE(W186:W187)","v":1051438.1533397944}]
[]
[]
[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":519199.72378243261},null,{"$f":"K197","v":519199.72378243261},null,{"$f":"M197","v":519199.72378243261},null,{"$f":"O197","v":519199.72378243261},null,{"$f":"Q197","v":519199.72378243261},null,{"$f":"S197","v":519199.72378243261},null,{"$f":"U197","v":519199.72378243261}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G206","v":519199.72378243261}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I194+I195-I196","v":519199.72378243261},null,{"$f":"K194+K195-K196","v":519199.72378243261},null,{"$f":"M194+M195-M196","v":519199.72378243261},null,{"$f":"O194+O195-O196","v":519199.72378243261},null,{"$f":"Q194+Q195-Q196","v":519199.72378243261},null,{"$f":"S194+S195-S196","v":519199.72378243261},null,{"$f":"U194+U195-U196","v":519199.72378243261},null,{"$f":"W194+W195-W196","v":519199.72378243261}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I203","v":-16748.378186530084},null,{"$f":"K203","v":-33496.756373060169},null,{"$f":"M203","v":-50245.134559590253},null,{"$f":"O203","v":-66993.512746120337},null,{"$f":"Q203","v":-83741.890932650422},null,{"$f":"S203","v":-100490.26911918051},null,{"$f":"U203","v":-117796.92657859492}]
[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":-16748.378186530084},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":-16748.378186530084},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":-16748.378186530084},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":-16748.378186530084},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":-16748.378186530084},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":-16748.378186530084},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":-17306.657459414422},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":-17306.657459414422}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I200+I201-I202","v":-16748.378186530084},null,{"$f":"K200+K201-K202","v":-33496.756373060169},null,{"$f":"M200+M201-M202","v":-50245.134559590253},null,{"$f":"O200+O201-O202","v":-66993.512746120337},null,{"$f":"Q200+Q201-Q202","v":-83741.890932650422},null,{"$f":"S200+S201-S202","v":-100490.26911918051},null,{"$f":"U200+U201-U202","v":-117796.92657859492},null,{"$f":"W200+W201-W202","v":-135103.58403800934}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I194+I200","v":0},null,{"$f":"I207","v":502451.34559590253},null,{"$f":"K207","v":485702.96740937245},null,{"$f":"M207","v":468954.58922284236},null,{"$f":"O207","v":452206.21103631228},null,{"$f":"Q207","v":435457.83284978219},null,{"$f":"S207","v":418709.45466325211},null,{"$f":"U207","v":401402.79720383766}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I197+I203","v":502451.34559590253},null,{"$f":"K197+K203","v":485702.96740937245},null,{"$f":"M197+M203","v":468954.58922284236},null,{"$f":"O197+O203","v":452206.21103631228},null,{"$f":"Q197+Q203","v":435457.83284978219},null,{"$f":"S197+S203","v":418709.45466325211},null,{"$f":"U197+U203","v":401402.79720383766},null,{"$f":"W197+W203","v":384096.13974442327}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I207","v":502451.34559590253},null,{"$f":"AVERAGE(K206:K207)","v":494077.15650263749},null,{"$f":"AVERAGE(M206:M207)","v":477328.7783161074},null,{"$f":"AVERAGE(O206:O207)","v":460580.40012957732},null,{"$f":"AVERAGE(Q206:Q207)","v":443832.02194304724},null,{"$f":"AVERAGE(S206:S207)","v":427083.64375651715},null,{"$f":"AVERAGE(U206:U207)","v":410056.12593354488},null,{"$f":"AVERAGE(W206:W207)","v":392749.4684741305}]
[]
[]
[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":195210.77805855821},null,{"$f":"K217","v":195210.77805855821},null,{"$f":"M217","v":195210.77805855821},null,{"$f":"O217","v":195210.77805855821},null,{"$f":"Q217","v":195210.77805855821},null,{"$f":"S217","v":195210.77805855821},null,{"$f":"U217","v":195210.77805855821}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G208","v":195210.77805855821},null,{"$f":"'2. ICM_Costs'!I246","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I214+I215-I216","v":195210.77805855821},null,{"$f":"K214+K215-K216","v":195210.77805855821},null,{"$f":"M214+M215-M216","v":195210.77805855821},null,{"$f":"O214+O215-O216","v":195210.77805855821},null,{"$f":"Q214+Q215-Q216","v":195210.77805855821},null,{"$f":"S214+S215-S216","v":195210.77805855821},null,{"$f":"U214+U215-U216","v":195210.77805855821},null,{"$f":"W214+W215-W216","v":195210.77805855821}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I223","v":-5275.9669745556275},null,{"$f":"K223","v":-10551.933949111255},null,{"$f":"M223","v":-15827.900923666883},null,{"$f":"O223","v":-21103.86789822251},null,{"$f":"Q223","v":-26379.834872778138},null,{"$f":"S223","v":-31655.801847333765},null,{"$f":"U223","v":-36536.071298797717}]
[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":-5275.9669745556275},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":-5275.9669745556275},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":-5275.9669745556275},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":-5275.9669745556275},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":-5275.9669745556275},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":-5275.9669745556275},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":-4880.2694514639552},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":-4880.2694514639552}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I220+I221-I222","v":-5275.9669745556275},null,{"$f":"K220+K221-K222","v":-10551.933949111255},null,{"$f":"M220+M221-M222","v":-15827.900923666883},null,{"$f":"O220+O221-O222","v":-21103.86789822251},null,{"$f":"Q220+Q221-Q222","v":-26379.834872778138},null,{"$f":"S220+S221-S222","v":-31655.801847333765},null,{"$f":"U220+U221-U222","v":-36536.071298797717},null,{"$f":"W220+W221-W222","v":-41416.340750261676}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I214+I220","v":0},null,{"$f":"I227","v":189934.81108400258},null,{"$f":"K227","v":184658.84410944695},null,{"$f":"M227","v":179382.87713489131},null,{"$f":"O227","v":174106.91016033571},null,{"$f":"Q227","v":168830.94318578008},null,{"$f":"S227","v":163554.97621122445},null,{"$f":"U227","v":158674.70675976051}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I217+I223","v":189934.81108400258},null,{"$f":"K217+K223","v":184658.84410944695},null,{"$f":"M217+M223","v":179382.87713489131},null,{"$f":"O217+O223","v":174106.91016033571},null,{"$f":"Q217+Q223","v":168830.94318578008},null,{"$f":"S217+S223","v":163554.97621122445},null,{"$f":"U217+U223","v":158674.70675976051},null,{"$f":"W217+W223","v":153794.43730829653}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I227","v":189934.81108400258},null,{"$f":"AVERAGE(K226:K227)","v":187296.82759672476},null,{"$f":"AVERAGE(M226:M227)","v":182020.86062216913},null,{"$f":"AVERAGE(O226:O227)","v":176744.89364761353},null,{"$f":"AVERAGE(Q226:Q227)","v":171468.9266730579},null,{"$f":"AVERAGE(S226:S227)","v":166192.95969850227},null,{"$f":"AVERAGE(U226:U227)","v":161114.84148549248},null,{"$f":"AVERAGE(W226:W227)","v":156234.57203402853}]
[]
[]
[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":156168.62244684657},null,{"$f":"K237","v":156168.62244684657},null,{"$f":"M237","v":156168.62244684657},null,{"$f":"O237","v":156168.62244684657},null,{"$f":"Q237","v":156168.62244684657},null,{"$f":"S237","v":156168.62244684657},null,{"$f":"U237","v":156168.62244684657}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G210","v":156168.62244684657},null,{"$f":"'2. ICM_Costs'!I266","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I234+I235-I236","v":156168.62244684657},null,{"$f":"K234+K235-K236","v":156168.62244684657},null,{"$f":"M234+M235-M236","v":156168.62244684657},null,{"$f":"O234+O235-O236","v":156168.62244684657},null,{"$f":"Q234+Q235-Q236","v":156168.62244684657},null,{"$f":"S234+S235-S236","v":156168.62244684657},null,{"$f":"U234+U235-U236","v":156168.62244684657},null,{"$f":"W234+W235-W236","v":156168.62244684657}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I243","v":-4004.3236524832455},null,{"$f":"K243","v":-8008.647304966491},null,{"$f":"M243","v":-12012.970957449736},null,{"$f":"O243","v":-16017.294609932982},null,{"$f":"Q243","v":-20021.618262416228},null,{"$f":"S243","v":-24025.941914899475},null,{"$f":"U243","v":-28487.902556237947}]
[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":-4004.3236524832455},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":-4004.3236524832455},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":-4004.3236524832455},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":-4004.3236524832455},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":-4004.3236524832455},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":-4004.3236524832455},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":-4461.9606413384736},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":-4461.9606413384736}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I240+I241-I242","v":-4004.3236524832455},null,{"$f":"K240+K241-K242","v":-8008.647304966491},null,{"$f":"M240+M241-M242","v":-12012.970957449736},null,{"$f":"O240+O241-O242","v":-16017.294609932982},null,{"$f":"Q240+Q241-Q242","v":-20021.618262416228},null,{"$f":"S240+S241-S242","v":-24025.941914899475},null,{"$f":"U240+U241-U242","v":-28487.902556237947},null,{"$f":"W240+W241-W242","v":-32949.863197576422}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I234+I240","v":0},null,{"$f":"I247","v":152164.29879436333},null,{"$f":"K247","v":148159.97514188007},null,{"$f":"M247","v":144155.65148939684},null,{"$f":"O247","v":140151.32783691358},null,{"$f":"Q247","v":136147.00418443035},null,{"$f":"S247","v":132142.68053194709},null,{"$f":"U247","v":127680.71989060863}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I237+I243","v":152164.29879436333},null,{"$f":"K237+K243","v":148159.97514188007},null,{"$f":"M237+M243","v":144155.65148939684},null,{"$f":"O237+O243","v":140151.32783691358},null,{"$f":"Q237+Q243","v":136147.00418443035},null,{"$f":"S237+S243","v":132142.68053194709},null,{"$f":"U237+U243","v":127680.71989060863},null,{"$f":"W237+W243","v":123218.75924927014}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I247","v":152164.29879436333},null,{"$f":"AVERAGE(K246:K247)","v":150162.13696812169},null,{"$f":"AVERAGE(M246:M247)","v":146157.81331563846},null,{"$f":"AVERAGE(O246:O247)","v":142153.48966315523},null,{"$f":"AVERAGE(Q246:Q247)","v":138149.16601067196},null,{"$f":"AVERAGE(S246:S247)","v":134144.8423581887},null,{"$f":"AVERAGE(U246:U247)","v":129911.70021127786},null,{"$f":"AVERAGE(W246:W247)","v":125449.73956993938}]
[]
[]
[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":156168.62244684657},null,{"$f":"K257","v":156168.62244684657},null,{"$f":"M257","v":156168.62244684657},null,{"$f":"O257","v":156168.62244684657},null,{"$f":"Q257","v":156168.62244684657},null,{"$f":"S257","v":156168.62244684657},null,{"$f":"U257","v":156168.62244684657}]
[null,null,null,"Capital Additions during year (from ICM Costs)",null,null,null,null,{"$f":"'2. ICM_Costs'!G212","v":156168.62244684657},null,{"$f":"'2. ICM_Costs'!I286","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I254+I255-I256","v":156168.62244684657},null,{"$f":"K254+K255-K256","v":156168.62244684657},null,{"$f":"M254+M255-M256","v":156168.62244684657},null,{"$f":"O254+O255-O256","v":156168.62244684657},null,{"$f":"Q254+Q255-Q256","v":156168.62244684657},null,{"$f":"S254+S255-S256","v":156168.62244684657},null,{"$f":"U254+U255-U256","v":156168.62244684657},null,{"$f":"W254+W255-W256","v":156168.62244684657}]
[]
[null,null,"Accumulated Depreciation"]
[null,null,null,"Opening Balance",null,null,null,null,null,null,{"$f":"I263","v":-3718.3005344487278},null,{"$f":"K263","v":-7436.6010688974557},null,{"$f":"M263","v":-11154.901603346183},null,{"$f":"O263","v":-14873.202137794911},null,{"$f":"Q263","v":-18591.502672243638},null,{"$f":"S263","v":-22309.803206692366},null,{"$f":"U263","v":-25780.217038844512}]
[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":-3718.3005344487278},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":-3718.3005344487278},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":-3718.3005344487278},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":-3718.3005344487278},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":-3718.3005344487278},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":-3718.3005344487278},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":-3470.4138321521459},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":-3470.4138321521459}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I260+I261-I262","v":-3718.3005344487278},null,{"$f":"K260+K261-K262","v":-7436.6010688974557},null,{"$f":"M260+M261-M262","v":-11154.901603346183},null,{"$f":"O260+O261-O262","v":-14873.202137794911},null,{"$f":"Q260+Q261-Q262","v":-18591.502672243638},null,{"$f":"S260+S261-S262","v":-22309.803206692366},null,{"$f":"U260+U261-U262","v":-25780.217038844512},null,{"$f":"W260+W261-W262","v":-29250.630870996658}]
[]
[null,null,"Net Book Value"]
[null,null,null,"Opening Balance",null,null,null,null,{"$f":"I254+I260","v":0},null,{"$f":"I267","v":152450.32191239783},null,{"$f":"K267","v":148732.0213779491},null,{"$f":"M267","v":145013.72084350037},null,{"$f":"O267","v":141295.42030905167},null,{"$f":"Q267","v":137577.11977460294},null,{"$f":"S267","v":133858.8192401542},null,{"$f":"U267","v":130388.40540800206}]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I257+I263","v":152450.32191239783},null,{"$f":"K257+K263","v":148732.0213779491},null,{"$f":"M257+M263","v":145013.72084350037},null,{"$f":"O257+O263","v":141295.42030905167},null,{"$f":"Q257+Q263","v":137577.11977460294},null,{"$f":"S257+S263","v":133858.8192401542},null,{"$f":"U257+U263","v":130388.40540800206},null,{"$f":"W257+W263","v":126917.99157584991}]
[null,null,null,"Incremental CAPEX",null,null,null,null,{"$f":"I267","v":152450.32191239783},null,{"$f":"AVERAGE(K266:K267)","v":150591.17164517345},null,{"$f":"AVERAGE(M266:M267)","v":146872.87111072475},null,{"$f":"AVERAGE(O266:O267)","v":143154.57057627602},null,{"$f":"AVERAGE(Q266:Q267)","v":139436.27004182729},null,{"$f":"AVERAGE(S266:S267)","v":135717.96950737858},null,{"$f":"AVERAGE(U266:U267)","v":132123.61232407813},null,{"$f":"AVERAGE(W266:W267)","v":128653.19849192598}]
[]
[]
[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'!G214","v":0},null,{"$f":"'2. ICM_Costs'!I306","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I274+I275-I276","v":0},null,{"$f":"K274+K275-K276","v":0},null,{"$f":"M274+M275-M276","v":0},null,{"$f":"O274+O275-O276","v":0},null,{"$f":"Q274+Q275-Q276","v":0},null,{"$f":"S274+S275-S276","v":0},null,{"$f":"U274+U275-U276","v":0},null,{"$f":"W274+W275-W276","v":0}]
[]
[null,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'!G216","v":0},null,{"$f":"'2. ICM_Costs'!I326","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I294+I295-I296","v":0},null,{"$f":"K294+K295-K296","v":0},null,{"$f":"M294+M295-M296","v":0},null,{"$f":"O294+O295-O296","v":0},null,{"$f":"Q294+Q295-Q296","v":0},null,{"$f":"S294+S295-S296","v":0},null,{"$f":"U294+U295-U296","v":0},null,{"$f":"W294+W295-W296","v":0}]
[]
[null,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'!G218","v":0},null,{"$f":"'2. ICM_Costs'!I346","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I314+I315-I316","v":0},null,{"$f":"K314+K315-K316","v":0},null,{"$f":"M314+M315-M316","v":0},null,{"$f":"O314+O315-O316","v":0},null,{"$f":"Q314+Q315-Q316","v":0},null,{"$f":"S314+S315-S316","v":0},null,{"$f":"U314+U315-U316","v":0},null,{"$f":"W314+W315-W316","v":0}]
[]
[null,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'!G220","v":0},null,{"$f":"'2. ICM_Costs'!I366","v":0}]
[null,null,null,"Retirements/Removals (if applicable)"]
[null,null,null,"Closing Balance",null,null,null,null,{"$f":"I334+I335-I336","v":0},null,{"$f":"K334+K335-K336","v":0},null,{"$f":"M334+M335-M336","v":0},null,{"$f":"O334+O335-O336","v":0},null,{"$f":"Q334+Q335-Q336","v":0},null,{"$f":"S334+S335-S336","v":0},null,{"$f":"U334+U335-U336","v":0},null,{"$f":"W334+W335-W336","v":0}]
[]
[null,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":19258765.240000002},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":18834380.162156887},null,{"$f":"K36+K55+K74+K93+K112+K131+K150+K169+K188+K208+K228+K248+K268+K288+K308+K328+K348","v":18622187.62323533},null,{"$f":"M36+M55+M74+M93+M112+M131+M150+M169+M188+M208+M228+M248+M268+M288+M308+M328+M348","v":18197802.545392215},null,{"$f":"O36+O55+O74+O93+O112+O131+O150+O169+O188+O208+O228+O248+O268+O288+O308+O328+O348","v":17773417.467549101},null,{"$f":"Q36+Q55+Q74+Q93+Q112+Q131+Q150+Q169+Q188+Q208+Q228+Q248+Q268+Q288+Q308+Q328+Q348","v":17349032.389705978},null,{"$f":"S36+S55+S74+S93+S112+S131+S150+S169+S188+S208+S228+S248+S268+S288+S308+S328+S348","v":16924647.311862864},null,{"$f":"U36+U55+U74+U93+U112+U131+U150+U169+U188+U208+U228+U248+U268+U288+U308+U328+U348","v":16520544.71167169},null,{"$f":"W36+W55+W74+W93+W112+W131+W150+W169+W188+W208+W228+W248+W268+W288+W308+W328+W348","v":16136724.589132452}]
[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":-424385.0778431159},{"$f":"J29+J48+J67+J86+J105+J124+J143+J162+J181+J201+J221+J241+J261+J281+J301+J321+J341","v":0},{"$f":"K29+K48+K67+K86+K105+K124+K143+K162+K181+K201+K221+K241+K261+K281+K301+K321+K341","v":-424385.0778431159},null,{"$f":"M29+M48+M67+M86+M105+M124+M143+M162+M181+M201+M221+M241+M261+M281+M301+M321+M341","v":-424385.0778431159},null,{"$f":"O29+O48+O67+O86+O105+O124+O143+O162+O181+O201+O221+O241+O261+O281+O301+O321+O341","v":-424385.0778431159},null,{"$f":"Q29+Q48+Q67+Q86+Q105+Q124+Q143+Q162+Q181+Q201+Q221+Q241+Q261+Q281+Q301+Q321+Q341","v":-424385.0778431159},null,{"$f":"S29+S48+S67+S86+S105+S124+S143+S162+S181+S201+S221+S241+S261+S281+S301+S321+S341","v":-424385.0778431159},null,{"$f":"U29+U48+U67+U86+U105+U124+U143+U162+U181+U201+U221+U241+U261+U281+U301+U321+U341","v":-383820.12253923772},null,{"$f":"W29+W48+W67+W86+W105+W124+W143+W162+W181+W201+W221+W241+W261+W281+W301+W321+W341","v":-383820.12253923772}]

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

{"sheet":"6. ICMIRR_2019","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 OEB Approved"]
[]
[null,null,"Return on Rate Base",null,null,null,"Actual spend"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"+'2. ICM_Costs'!G168","v":19258765.240000002},"B",null,null,null,13272246]
[null,null,"Depreciation Expense",null,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":424385.0778431159},"C",null,null,null,308754]
[null,null,"Incremental Capital CAPEX to be included in Rate Base",null,null,{"$f":"(F27+(F27-F28))/2","v":19046572.701078445},"D = B - C",null,null,null,{"$f":"(K27+(K27-K28))/2","v":13117869}]
[]
[null,null,"Deemed ShortTerm Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G22","v":0.04},"E",{"$f":"F29*D31","v":761862.90804313775},"G = D * E",null,{"$f":"D31","v":0.04},null,{"$f":"K29*I31","v":524714.76}]
[null,null,"Deemed Long Term Debt %",{"$f":"'3. Cost_of_Service_Parameters'!G23","v":0.55999999999999994},"F",{"$f":"F29*D32","v":10666080.712603929},"H = D * F",null,{"$f":"D32","v":0.55999999999999994},null,{"$f":"K29*I32","v":7346006.6399999997}]
[]
[null,null,"Short Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G29","v":1.7600000000000001E-2},"I",{"$f":"F31*D34","v":13408.787181559224},"K = G * I",null,{"$f":"D34","v":1.7600000000000001E-2},null,{"$f":"K31*I34","v":9234.9797760000001}]
[null,null,"Long Term Interest",{"$f":"'3. Cost_of_Service_Parameters'!G30","v":3.8825039999999998E-2},"J",{"$f":"F32*D35","v":414111.010310076},"L = H * J",null,{"$f":"D35","v":3.8825039999999998E-2},null,{"$f":"K32*I35","v":285209.00163826556}]
[]
[null,null,"Return on Rate Base - Interest",null,null,{"$f":"SUM(F34:F35)","v":427519.79749163525},"M = K + L",null,null,null,{"$f":"SUM(K34:K35)","v":294443.98141426558}]
[]
[]
[null,null,"Deemed Equity %",{"$f":"'3. Cost_of_Service_Parameters'!G24","v":0.40000000000000008},"N",{"$f":"F29*D40","v":7618629.0804313794},"P = D * N",null,0.39999999999999991,null,{"$f":"K29*I40","v":5247147.5999999987}]
[]
[null,null,"Return on Rate Base -Equity",{"$f":"'3. Cost_of_Service_Parameters'!G31","v":8.7800000000000003E-2},"O",{"$f":"F40*D42","v":668915.63326187513},"Q = P * O",null,{"$f":"D42","v":8.7800000000000003E-2},null,{"$f":"K40*I42","v":460699.55927999993}]
[]
[null,null,"Return on Rate Base - Total",null,null,{"$f":"F37+F42","v":1096435.4307535104},"R = M + Q",null,null,null,{"$f":"K37+K42","v":755143.54069426551}]
[]
[]
[]
[null,null,"Amortization Expense"]
[]
[null,null,"Amortization Expense - Incremental",null,"C",{"$f":"F28","v":424385.0778431159},"S",null,null,null,{"$f":"K28","v":308754}]
[]
[]
[null,null,"Grossed up PIL's"]
[]
[null,null,"Regulatory Taxable Income",null,"O",{"$f":"F42","v":668915.63326187513},"T ",null,null,null,{"$f":"K42","v":460699.55927999993}]
[]
[null,null,"Add Back Amortization Expense",null,"S",{"$f":"F50","v":424385.0778431159},"U",null,null,null,{"$f":"K50","v":308754}]
[]
[null,null,"Deduct CCA",null,null,{"$f":"'5. UCC_Calculation'!D31+'5. UCC_Calculation'!D45","v":1540701.2192000002},"V",null,null,null,1061780]
[]
[null,null,"Incremental Taxable Income",null,null,{"$f":"F55+F57-F59","v":-447400.50809500925},"W = T + U - V",null,null,null,{"$f":"K55+K57-K59","v":-292326.44072000007}]
[]
[null,null,"Current Tax Rate (F1.1 Z-Factor Tax Changes)",{"$f":"'3. Cost_of_Service_Parameters'!G40","v":0.26500000000000001},"X",null,null,null,{"$f":"D63","v":0.26500000000000001}]
[]
[null,null,"PIL's Before Gross Up",null,null,{"$f":"F61*D63","v":-118561.13464517746},"Y = W * X",null,null,null,{"$f":"K61*I63","v":-77466.50679080002}]
[]
[null,null,"Incremental Grossed Up PIL's",null,null,{"$f":"F65/(1-D63)","v":-161307.6661839149},"Z = Y / ( 1 - X ) ",null,null,null,{"$f":"K65/(1-I63)","v":-105396.60787863948}]
[]
[]
[null,null,"Ontario Capital Tax"]
[null,null,"Incremental Capital CAPEX",null,null,{"$f":"F27","v":19258765.240000002},"AA",null,null,null,{"$f":"K27","v":13272246}]
[]
[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":19258765.240000002},"AC = AA - AB",null,null,null,{"$f":"K71-K73","v":13272246}]
[]
[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":1096435.4307535104},"AF",null,null,null,{"$f":"K44","v":755143.54069426551}]
[null,null,"Amortization Expense - Total",null,"S",{"$f":"F50","v":424385.0778431159},"AG",null,null,null,{"$f":"K50","v":308754}]
[null,null,"Incremental Grossed Up PIL's",null,"Z",{"$f":"F67","v":-161307.6661839149},"AH",null,null,null,{"$f":"K67","v":-105396.60787863948}]
[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":1359512.8424127114},"AJ = AF + AG + AH + AI",null,null,null,{"$f":"SUM(K83:K86)","v":958500.93281562615}]

{"sheet":"7. Funding Adder 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 funding adder revenues.\n"]
[]
[]
[]
[null,"Sheet 7: ICM Funding Adder Revenues"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Account 1511 - Sub-account ICM Funding Adder Revenues"]
[null,null,null,null,null,null,null,null,null,null,"Rate Rider Collected"]
[null,"Prescribed \nInterest Rates","Approved Deferral and Variance Accounts","CWIP",null,"Date","Year","Quarter",null,"Opening Balance (Principal)","Funding Adder Revenues","Interest Rate","Interest","Principal &\nInterest\n(Cumm.)",null,"Board Approved ICM Funding Adder ","Board Approved ICM Funding Adder \n(Cumm.)"]
[]
[null,"2018 Q1",1.4999999999999999E-2,2.9899999999999999E-2,null,"2018-01-01",{"$f":"YEAR(F24)","v":2018},{"$f":"IF(MONTH(F24)=0,\"\",IF(MONTH(F24)<4,\"Q1\",IF(MONTH(F24)<7,\"Q2\",IF(MONTH(F24)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G24,\" \",H24)","v":"2018 Q1"},0,null,1.4999999999999999E-2,{"$f":"ROUND(J24*L24/12,2)","v":0},{"$f":"K24+M24","v":0},null,null,{"$f":"P24","v":0}]
[null,"2018 Q2",1.89E-2,3.3500000000000002E-2,null,"2018-02-01",{"$f":"YEAR(F25)","v":2018},{"$f":"IF(MONTH(F25)=0,\"\",IF(MONTH(F25)<4,\"Q1\",IF(MONTH(F25)<7,\"Q2\",IF(MONTH(F25)<10,\"Q3\",\"Q4\"))))","v":"Q1"},{"$f":"CONCATENATE(G25,\" \",H25)","v":"2018 Q1"},{"$f":"J24+K24","v":0},null,1.4999999999999999E-2,{"$f":"ROUND(J25*L25/12,2)","v":0},{"$f":"N24+K25+M25","v":0},null,null,{"$f":"Q24+P25","v":0}]
[null,"2018 Q3",1.89E-2,3.3500000000000002E-2,null,"2018-03-01",2018,"Q1","2018 Q1",{"$f":"J25+K25","v":0},null,1.4999999999999999E-2,0,{"$f":"N25+K26+M26","v":0},null,null,{"$f":"Q25+P26","v":0}]
[null,"2018 Q4",2.1700000000000001E-2,3.3500000000000002E-2,null,"2018-04-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q1",2.4500000000000001E-2,3.8199999999999998E-2,null,"2018-05-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q2",2.18E-2,3.39E-2,null,"2018-06-01",2018,"Q2","2018 Q2",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q3",2.18E-2,2.8799999999999999E-2,null,"2018-07-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0,null,null,0]
[null,"2019 Q4",2.18E-2,2.8799999999999999E-2,null,"2018-08-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0,null,null,0]
[null,"2020 Q1",2.18E-2,2.8799999999999999E-2,null,"2018-09-01",2018,"Q3","2018 Q3",0,null,1.89E-2,0,0,null,null,0]
[null,"2020 Q2",2.18E-2,2.4799999999999999E-2,null,"2018-10-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0,null,null,0]
[null,"2020 Q3",5.7000000000000002E-3,2.4799999999999999E-2,null,"2018-11-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0,null,null,0]
[null,"2020 Q4",5.7000000000000002E-3,2.0299999999999999E-2,null,"2018-12-01",2018,"Q4","2018 Q4",0,null,2.1700000000000001E-2,0,0,null,null,0]
[null,"2021 Q1",5.7000000000000002E-3,2.0299999999999999E-2,null,"2019-01-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0,null,null,0]
[null,"2021 Q2",5.7000000000000002E-3,2.29E-2,null,"2019-02-01",2019,"Q1","2019 Q1",0,null,2.4500000000000001E-2,0,0,null,null,0]
[null,"2021 Q3",5.7000000000000002E-3,2.29E-2,null,"2019-03-01",2019,"Q1","2019 Q1",0,42800.340008812949,2.4500000000000001E-2,0,{"$f":"N37+K38+M38","v":42800.340008812949},null,79875.077734635517,79875.077734635517]
[null,"2021 Q4",5.7000000000000002E-3,2.29E-2,null,"2019-04-01",2019,"Q2","2019 Q2",{"$f":"J38+K38","v":42800.340008812949},149494.36130020377,2.18E-2,77.75,{"$f":"N38+K39+M39","v":192372.45130901673},null,79875.077734635517,159750.15546927103]
[null,"2022 Q1",5.7000000000000002E-3,2.7199999999999998E-2,null,"2019-05-01",2019,"Q2","2019 Q2",{"$f":"J39+K39","v":192294.70130901673},97302.767639240701,2.18E-2,349.34,290024.55894825747,null,79875.077734635517,239625.23320390657]
[null,"2022 Q2",1.0200000000000001E-2,3.3099999999999997E-2,null,"2019-06-01",2019,"Q2","2019 Q2",289597.46894825745,97134.911378583303,2.18E-2,526.1,387685.57032684074,null,79875.077734635517,319500.31093854207]
[null,"2022 Q3",2.1999999999999999E-2,4.6600000000000003E-2,null,"2019-07-01",2019,"Q3","2019 Q3",386732.38032684074,103244.69800754612,2.18E-2,702.56,491632.82833438687,null,79875.077734635517,399375.38867317757]
[null,"2022 Q4",3.8699999999999998E-2,5.0099999999999999E-2,null,"2019-08-01",2019,"Q3","2019 Q3",489977.07833438687,95920.049295622564,2.18E-2,890.13,588443.00763000944,null,79875.077734635517,479250.46640781307]
[null,"2023 Q1",4.7300000000000002E-2,5.0099999999999999E-2,null,"2019-09-01",2019,"Q3","2019 Q3",585897.12763000943,90179.534239983303,2.18E-2,1064.3800000000001,679686.92186999274,null,79875.077734635517,559125.54414244858]
[null,"2023 Q2",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-10-01",2019,"Q4","2019 Q4",676076.66186999273,99078.748226184936,2.18E-2,1228.21,779993.88009617769,null,79875.077734635517,639000.62187708414]
[null,"2023 Q3",4.9799999999999997E-2,5.0099999999999999E-2,null,"2019-11-01",2019,"Q4","2019 Q4",775155.41009617771,94267.403235575053,2.18E-2,1408.2,875669.48333175271,null,79875.077734635517,718875.6996117197]
[null,"2023 Q4",5.4899999999999997E-2,5.4800000000000001E-2,null,"2019-12-01",2019,"Q4","2019 Q4",869422.81333175278,98270.882239047292,2.18E-2,1579.45,975519.81557079998,null,79875.077734635517,798750.77734635526]
[null,"2024 Q1",5.4899999999999997E-2,5.4800000000000001E-2,null,"2020-01-01",2020,"Q1","2020 Q1",967693.6955708001,94626.295990165177,2.18E-2,{"$f":"ROUND(J48*L48/12,2)","v":1757.98},{"$f":"N47+K48+M48","v":1071904.0915609652},null,79875.077734635517,{"$f":"Q47+P48","v":878625.85508099082}]
[null,"2024 Q2",5.4899999999999997E-2,5.9799999999999999E-2,null,"2020-02-01",2020,"Q1","2020 Q1",1062319.9915609653,90413.175305526107,2.18E-2,1929.88,1164247.1468664911,null,79875.077734635517,958500.93281562638]
[null,"2024 Q3",5.1999999999999998E-2,5.9799999999999999E-2,null,"2020-03-01",2020,"Q1","2020 Q1",1152733.1668664913,101571.60802747459,2.18E-2,2094.13,1267912.8848939654,null,79875.077734635517,1038376.0105502619]
[null,"2024 Q4",4.3999999999999997E-2,4.5499999999999999E-2,null,"2020-04-01",2020,"Q2","2020 Q2",1254304.7748939658,87509.406654751525,2.18E-2,2278.65,1357700.941548717,null,79875.077734635517,1118251.0882848974]
[null,"2025 Q1",3.6400000000000002E-2,4.2299999999999997E-2,null,"2020-05-01",2020,"Q2","2020 Q2",1341814.1815487174,93215.813652857178,2.18E-2,2437.63,1453354.3852015741,null,79875.077734635517,1198126.1660195328]
[null,"2025 Q2",3.1600000000000003E-2,4.2299999999999997E-2,null,"2020-06-01",2020,"Q2","2020 Q2",1435029.9952015746,101180.82938057081,2.18E-2,2606.9699999999998,1557142.184582145,null,79875.077734635517,1278001.2437541683]
[null,"2025 Q3",2.9100000000000001E-2,{"$f":"D53","v":4.2299999999999997E-2},null,"2020-07-01",2020,"Q3","2020 Q3",1536210.8245821455,98408.804627035293,5.7000000000000002E-3,729.7,1656280.6892091802,null,79875.077734635517,1357876.3214888037]
[null,"2025 Q4",2.9100000000000001E-2,{"$f":"D54","v":4.2299999999999997E-2},null,"2020-08-01",2020,"Q3","2020 Q3",1634619.6292091808,96816.157027927766,5.7000000000000002E-3,776.44,1753873.2862371078,null,79875.077734635517,1437751.3992234392]
[null,"2026 Q1",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-09-01",2020,"Q3","2020 Q3",1731435.7862371085,95619.534128517873,5.7000000000000002E-3,822.43,1850315.2503656256,null,79875.077734635517,1517626.4769580746]
[null,"2026 Q2",{"$f":"C56","v":2.5499999999999998E-2},4.2299999999999997E-2,null,"2020-10-01",2020,"Q4","2020 Q4",1827055.3203656264,97945.417820864706,5.7000000000000002E-3,867.85,1949128.5181864905,null,79875.077734635517,1597501.5546927101]
[null,"2026 Q3",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-11-01",2020,"Q4","2020 Q4",1925000.7381864912,97230.551626777407,5.7000000000000002E-3,914.38,2047273.4498132679,null,79875.077734635517,1677376.6324273455]
[null,"2026 Q4",2.5499999999999998E-2,4.2299999999999997E-2,null,"2020-12-01",2020,{"$f":"IF(MONTH(F59)=0,\"\",IF(MONTH(F59)<4,\"Q1\",IF(MONTH(F59)<7,\"Q2\",IF(MONTH(F59)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2020 Q4",2022231.2898132687,101880.07941750422,5.7000000000000002E-3,960.56,2150114.0892307721,null,79875.077734635517,1757251.7101619809]
[null,null,null,null,null,"2021-01-01",2021,"Q1","2021 Q1",{"$f":"J59+K59","v":2124111.3692307728},92799.510606230353,5.7000000000000002E-3,1008.95,2243922.5498370025,null,79875.077734635517,1837126.7878966164]
[null,"Note: 2025-2026 Interest rates are forecasted. ",null,null,null,"2021-02-01",2021,"Q1","2021 Q1",2216910.8798370031,91037.420730504455,5.7000000000000002E-3,1053.03,2336013.000567507,null,79875.077734635517,1917001.8656312518]
[null,null,null,null,null,"2021-03-01",2021,"Q1","2021 Q1",2307948.3005675077,102424.7103269927,5.7000000000000002E-3,1096.28,2439533.9908944997,null,79875.077734635517,1996876.9433658873]
[null,null,null,null,null,"2021-04-01",2021,"Q2","2021 Q2",2410373.0108945007,82891.947758179987,5.7000000000000002E-3,1144.93,2523570.86865268,null,79875.077734635517,2076752.0211005227]
[null,null,null,null,null,"2021-05-01",2021,"Q2","2021 Q2",2493264.9586526807,99387.35033181576,5.7000000000000002E-3,1184.3,2624142.5189844957,null,79875.077734635517,2156627.0988351582]
[null,null,null,null,null,"2021-06-01",2021,"Q2","2021 Q2",2592652.3089844966,98829.41257412752,5.7000000000000002E-3,1231.51,2724203.4415586228,null,79875.077734635517,2236502.1765697938]
[null,null,null,null,null,"2021-07-01",2021,"Q3","2021 Q3",2691481.7215586239,100005.12969172258,5.7000000000000002E-3,1278.45,2825487.0212503457,null,79875.077734635517,2316377.2543044295]
[null,null,null,null,null,"2021-08-01",2021,"Q3","2021 Q3",2791486.8512503468,101791.55881238752,5.7000000000000002E-3,1325.96,2928604.540062733,null,79875.077734635517,2396252.3320390652]
[null,null,null,null,null,"2021-09-01",2021,"Q3","2021 Q3",2893278.410062734,92854.768448034345,5.7000000000000002E-3,1374.31,3022833.6185107674,null,79875.077734635517,2476127.4097737009]
[null,null,null,null,null,"2021-10-01",2021,"Q4","2021 Q4",2986133.1785107683,97628.528346119288,5.7000000000000002E-3,1418.41,3121880.5568568869,null,79875.077734635517,2556002.4875083365]
[null,null,null,null,null,"2021-11-01",2021,"Q4","2021 Q4",3083761.7068568878,98557.062261889645,5.7000000000000002E-3,1464.79,3221902.4091187767,null,79875.077734635517,2635877.5652429722]
[null,null,null,null,null,"2021-12-01",2021,{"$f":"IF(MONTH(F71)=0,\"\",IF(MONTH(F71)<4,\"Q1\",IF(MONTH(F71)<7,\"Q2\",IF(MONTH(F71)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2021 Q4",3182318.7691187775,98371.149819523052,5.7000000000000002E-3,1511.6,3321785.1589382999,null,79875.077734635517,2715752.6429776079]
[null,null,null,null,null,"2022-01-01",{"$f":"YEAR(F72)","v":2022},{"$f":"IF(MONTH(F72)=0,\"\",IF(MONTH(F72)<4,\"Q1\",IF(MONTH(F72)<7,\"Q2\",IF(MONTH(F72)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2022 Q1",{"$f":"J71+K71","v":3280689.9189383006},93371.504648231756,5.7000000000000002E-3,{"$f":"ROUND(J72*L72/12,2)","v":1558.33},{"$f":"N71+K72+M72","v":3416714.9935865318},null,79875.077734635517,{"$f":"Q71+P72","v":2795627.7207122436}]
[null,null,null,null,null,"2022-02-01",2022,"Q1","2022 Q1",3374061.4235865325,91370.057078004931,5.7000000000000002E-3,1602.68,3509687.7306645368,null,79875.077734635517,2875502.7984468793]
[null,null,null,null,null,"2022-03-01",2022,"Q1","2022 Q1",3465431.4806645373,102661.33170824236,5.7000000000000002E-3,1646.08,3613995.1423727791,null,79875.077734635517,2955377.8761815149]
[null,null,null,null,null,"2022-04-01",2022,"Q2","2022 Q2",3568092.8123727795,88387.083487290816,1.0200000000000001E-2,3032.88,3705415.1058600699,null,79875.077734635517,3035252.9539161506]
[null,null,null,null,null,"2022-05-01",2022,"Q2","2022 Q2",3656479.8958600704,99789.658094743281,1.0200000000000001E-2,3108.01,3808312.7739548129,null,79875.077734635517,3115128.0316507863]
[null,null,null,null,null,"2022-06-01",2022,"Q2","2022 Q2",3756269.5539548136,99782.381592944497,1.0200000000000001E-2,3192.83,3911287.9855477577,null,79875.077734635517,3195003.109385422]
[null,null,null,null,null,"2022-07-01",2022,"Q3","2022 Q3",3856051.9355477579,101035.58691891693,2.1999999999999999E-2,7069.43,4019393.0024666749,null,79875.077734635517,3274878.1871200576]
[null,null,null,null,null,"2022-08-01",2022,"Q3","2022 Q3",3957087.5224666749,103677.17493122518,2.1999999999999999E-2,7254.66,4130324.8373979004,null,79875.077734635517,3354753.2648546933]
[null,null,null,null,null,"2022-09-01",2022,"Q3","2022 Q3",4060764.6973979003,93701.34368186706,2.1999999999999999E-2,7444.74,4231470.9210797679,null,79875.077734635517,3434628.342589329]
[null,null,null,null,null,"2022-10-01",2022,"Q4","2022 Q4",4154466.0410797675,97911.850054482595,3.8699999999999998E-2,13398.15,4342780.9211342512,null,79875.077734635517,3514503.4203239647]
[null,null,null,null,null,"2022-11-01",2022,"Q4","2022 Q4",4252377.89113425,95701.100663652003,3.8699999999999998E-2,13713.92,4452195.9417979028,null,79875.077734635517,3594378.4980586004]
[null,null,null,null,null,"2022-12-01",2022,{"$f":"IF(MONTH(F83)=0,\"\",IF(MONTH(F83)<4,\"Q1\",IF(MONTH(F83)<7,\"Q2\",IF(MONTH(F83)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2022 Q4",4348078.9917979017,101044.04857549978,3.8699999999999998E-2,14022.55,4567262.5403734026,null,79875.077734635517,3674253.575793236]
[null,null,null,null,null,"2023-01-01",{"$f":"YEAR(F84)","v":2023},{"$f":"IF(MONTH(F84)=0,\"\",IF(MONTH(F84)<4,\"Q1\",IF(MONTH(F84)<7,\"Q2\",IF(MONTH(F84)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2023 Q1",{"$f":"J83+K83","v":4449123.0403734017},98849.490490468233,4.7300000000000002E-2,{"$f":"ROUND(J84*L84/12,2)","v":17536.96},{"$f":"N83+K84+M84","v":4683648.9908638708},null,79875.077734635517,{"$f":"Q83+P84","v":3754128.6535278717}]
[null,null,null,null,null,"2023-02-01",2023,"Q1","2023 Q1",4547972.5308638699,89279.62704087059,4.7300000000000002E-2,17926.59,4790855.2079047412,null,79875.077734635517,3834003.7312625074]
[null,null,null,null,null,"2023-03-01",2023,"Q1","2023 Q1",4637252.1579047404,102727.61323241223,4.7300000000000002E-2,18278.5,4911861.3211371535,null,79875.077734635517,3913878.8089971431]
[null,null,null,null,null,"2023-04-01",2023,"Q2","2023 Q2",4739979.7711371528,95451.939299062826,4.9799999999999997E-2,19670.919999999998,5026984.1804362163,null,79875.077734635517,3993753.8867317787]
[null,null,null,null,null,"2023-05-01",2023,"Q2","2023 Q2",4835431.7104362156,100544.26183158823,4.9799999999999997E-2,20067.04,5147595.4822678044,null,79875.077734635517,4073628.9644664144]
[null,null,null,null,null,"2023-06-01",2023,"Q2",{"$f":"CONCATENATE(G89,\" \",H89)","v":"2023 Q2"},4935975.9722678037,98417.318569858588,4.9799999999999997E-2,20484.3,5266497.1008376628,null,79875.077734635517,4153504.0422010501]
[null,null,null,null,null,"2023-07-01",2023,"Q3","2023 Q3",5034393.2908376623,103344.12029380095,4.9799999999999997E-2,20892.73,5390733.951131464,null,79875.077734635517,4233379.1199356858]
[null,null,null,null,null,"2023-08-01",2023,"Q3","2023 Q3",5137737.411131463,99723.542143668223,4.9799999999999997E-2,21321.61,5511779.1032751324,null,79875.077734635517,4313254.197670321]
[null,null,null,null,null,"2023-09-01",2023,"Q3","2023 Q3",5237460.9532751311,98104.855996806349,4.9799999999999997E-2,21735.46,5631619.4192719385,null,79875.077734635517,4393129.2754049562]
[null,null,null,null,null,"2023-10-01",2023,"Q4","2023 Q4",5335565.8092719372,100475.25270854046,5.4899999999999997E-2,24410.21,5756504.8819804788,null,79875.077734635517,4473004.3531395914]
[null,null,null,null,null,"2023-11-01",2023,"Q4","2023 Q4",5436041.0619804775,95113.560179483989,5.4899999999999997E-2,24869.89,5876488.3321599625,null,79875.077734635517,4552879.4308742266]
[null,null,null,null,null,"2023-12-01",2023,{"$f":"IF(MONTH(F95)=0,\"\",IF(MONTH(F95)<4,\"Q1\",IF(MONTH(F95)<7,\"Q2\",IF(MONTH(F95)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2023 Q4",5531154.6221599616,100196.07904192117,5.4899999999999997E-2,25305.03,6001989.4412018843,null,79875.077734635517,4632754.5086088618]
[null,null,null,null,null,"2024-01-01",{"$f":"YEAR(F96)","v":2024},{"$f":"IF(MONTH(F96)=0,\"\",IF(MONTH(F96)<4,\"Q1\",IF(MONTH(F96)<7,\"Q2\",IF(MONTH(F96)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2024 Q1",{"$f":"J95+K95","v":5631350.7012018831},98714.199843250579,5.4899999999999997E-2,{"$f":"ROUND(J96*L96/12,2)","v":25763.43},{"$f":"N95+K96+M96","v":6126467.0710451342},null,79875.077734635517,{"$f":"Q95+P96","v":4712629.586343497}]
[null,null,null,null,null,"2024-02-01",2024,"Q1","2024 Q1",5730064.9010451334,93208.633009165875,5.4899999999999997E-2,26215.05,6245890.7540542996,null,79875.077734635517,4792504.6640781322]
[null,null,null,null,null,"2024-03-01",2024,"Q1","2024 Q1",5823273.5340542989,99301.609611817403,5.4899999999999997E-2,26641.48,6371833.8436661176,null,79875.077734635517,4872379.7418127675]
[null,null,null,null,null,"2024-04-01",2024,"Q2","2024 Q2",5922575.1436661165,97380.220990124464,5.4899999999999997E-2,27095.78,6496309.8446562421,null,79875.077734635517,4952254.8195474027]
[null,null,null,null,null,"2024-05-01",2024,"Q2","2024 Q2",6019955.3646562407,99723.376570573397,5.4899999999999997E-2,27541.3,6623574.5212268149,null,79875.077734635517,5032129.8972820379]
[null,null,null,null,null,"2024-06-01",2024,"Q2","2024 Q2",6119678.7412268138,99891.04111501576,5.4899999999999997E-2,27997.53,6751463.092341831,null,79875.077734635517,5112004.9750166731]
[null,null,null,null,null,"2024-07-01",2024,"Q3","2024 Q3",6219569.7823418295,104216.36807170471,5.1999999999999998E-2,26951.47,6882630.9304135358,null,79875.077734635517,5191880.0527513083]
[null,null,null,null,null,"2024-08-01",2024,"Q3","2024 Q3",6323786.1504135346,101509.05625512495,5.1999999999999998E-2,27403.07,7011543.0566686606,null,79875.077734635517,5271755.1304859435]
[null,null,null,null,null,"2024-09-01",2024,"Q3","2024 Q3",6425295.2066686591,98542.849118855054,5.1999999999999998E-2,27842.95,7137928.8557875156,null,79875.077734635517,5351630.2082205787]
[null,null,null,null,null,"2024-10-01",2024,"Q4","2024 Q4",6523838.055787514,101260.21732235199,4.3999999999999997E-2,23920.74,7263109.8131098682,null,79875.077734635517,5431505.2859552139]
[null,null,null,null,null,"2024-11-01",2024,"Q4","2024 Q4",6625098.2731098663,95625.451188064471,4.3999999999999997E-2,24292.03,7383027.2942979326,null,79875.077734635517,5511380.3636898492]
[null,null,null,null,null,"2024-12-01",2024,{"$f":"IF(MONTH(F107)=0,\"\",IF(MONTH(F107)<4,\"Q1\",IF(MONTH(F107)<7,\"Q2\",IF(MONTH(F107)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2024 Q4",6720723.7242979305,99592.748113131049,4.3999999999999997E-2,24642.65,7507262.6924110642,null,79875.077734635517,5591255.4414244844]
[null,null,null,null,null,"2025-01-01",{"$f":"YEAR(F108)","v":2025},{"$f":"IF(MONTH(F108)=0,\"\",IF(MONTH(F108)<4,\"Q1\",IF(MONTH(F108)<7,\"Q2\",IF(MONTH(F108)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2025 Q1",{"$f":"J107+K107","v":6820316.4724110616},101197.86598059081,3.6400000000000002E-2,{"$f":"ROUND(J108*L108/12,2)","v":20688.29},{"$f":"N107+K108+M108","v":7629148.8483916549},null,79875.077734635517,{"$f":"Q107+P108","v":5671130.5191591196}]
[null,null,null,null,null,"2025-02-01",2025,"Q1","2025 Q1",6921514.3383916523,92688.89906451483,3.6400000000000002E-2,20995.26,7742833.0074561695,null,79875.077734635517,5751005.5968937548]
[null,null,null,null,null,"2025-03-01",2025,"Q1","2025 Q1",7014203.2374561671,102856.68181701389,3.6400000000000002E-2,21276.42,7866966.1092731832,null,79875.077734635517,5830880.67462839]
[null,null,null,null,null,"2025-04-01",2025,"Q2","2025 Q2",7117059.9192731809,95755.905358038581,3.1600000000000003E-2,18741.59,7981463.6046312219,null,79875.077734635517,5910755.7523630252]
[null,null,null,null,null,"2025-05-01",2025,"Q2","2025 Q2",7212815.8246312197,102640.15578085177,3.1600000000000003E-2,18993.75,8103097.5104120737,null,79875.077734635517,5990630.8300976604]
[null,null,null,null,null,"2025-06-01",2025,"Q2","2025 Q2",7315455.9804120716,103687.3446049967,3.1600000000000003E-2,19264.03,8226048.8850170709,null,79875.077734635517,6070505.9078322956]
[null,null,null,null,null,"2025-07-01",2025,"Q3","2025 Q3",7419143.3250170685,106795.7093147327,2.9100000000000001E-2,17991.419999999998,8350836.0143318037,null,79875.077734635517,6150380.9855669308]
[null,null,null,null,null,"2025-08-01",2025,"Q3","2025 Q3",7525939.0343318013,103961.21121820823,2.9100000000000001E-2,18250.400000000001,8473047.625550013,null,79875.077734635517,6230256.0633015661]
[null,null,null,null,null,"2025-09-01",2025,"Q3","2025 Q3",7629900.2455500094,97717.083808729643,2.9100000000000001E-2,18502.509999999998,8589267.2193587422,null,79875.077734635517,6310131.1410362013]
[null,null,null,null,null,"2025-10-01",2025,"Q4","2025 Q4",7727617.3293587388,101102.40873423836,2.9100000000000001E-2,18739.47,8709109.0980929807,null,79875.077734635517,6390006.2187708365]
[null,null,null,null,null,"2025-11-01",2025,"Q4","2025 Q4",7828719.7380929776,98596.799804647279,2.9100000000000001E-2,18984.650000000001,8826690.5478976276,null,79875.077734635517,6469881.2965054717]
[null,null,null,null,null,"2025-12-01",2025,{"$f":"IF(MONTH(F119)=0,\"\",IF(MONTH(F119)<4,\"Q1\",IF(MONTH(F119)<7,\"Q2\",IF(MONTH(F119)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2025 Q4",7927316.537897625,103922.06625284259,2.9100000000000001E-2,19223.740000000002,8949836.3541504703,null,79875.077734635517,6549756.3742401069]
[null,null,null,null,null,"2026-01-01",{"$f":"YEAR(F120)","v":2026},{"$f":"IF(MONTH(F120)=0,\"\",IF(MONTH(F120)<4,\"Q1\",IF(MONTH(F120)<7,\"Q2\",IF(MONTH(F120)<10,\"Q3\",\"Q4\"))))","v":"Q1"},"2026 Q1",{"$f":"J119+K119","v":8031238.6041504676},101399.10306880192,2.5499999999999998E-2,{"$f":"ROUND(J120*L120/12,2)","v":17066.38},{"$f":"N119+K120+M120","v":9068301.8372192737},null,79875.077734635517,{"$f":"Q119+P120","v":6629631.4519747421}]
[null,null,null,null,null,"2026-02-01",2026,"Q1","2026 Q1",8132637.7072192691,91160.063520467244,2.5499999999999998E-2,17281.86,9176743.76073974,null,79875.077734635517,6709506.5297093773]
[null,null,null,null,null,"2026-03-01",2026,"Q1","2026 Q1",8223797.770739736,99826.850011452392,2.5499999999999998E-2,17475.57,9294046.1807511933,null,79875.077734635517,6789381.6074440125]
[null,null,null,null,null,"2026-04-01",2026,"Q2","2026 Q2",8323624.6207511881,97751.051483676361,2.5499999999999998E-2,17687.7,9409484.9322348684,null,79875.077734635517,6869256.6851786477]
[null,null,null,null,null,"2026-05-01",2026,"Q2","2026 Q2",8421375.6722348649,100522.31121263631,2.5499999999999998E-2,17895.419999999998,9527902.6634475049,null,79875.077734635517,6949131.762913283]
[null,null,null,null,null,"2026-06-01",2026,"Q2","2026 Q2",8521897.9834475014,101828.32385133691,2.5499999999999998E-2,18109.03,9647840.0172988418,null,79875.077734635517,7029006.8406479182]
[null,null,null,null,null,"2026-07-01",2026,"Q3","2026 Q3",8623726.3072988391,107785.78889764358,2.5499999999999998E-2,18325.419999999998,9773951.2261964846,null,79875.077734635517,7108881.9183825534]
[null,null,null,null,null,"2026-08-01",2026,"Q3","2026 Q3",8731512.096196482,102892.81975437258,2.5499999999999998E-2,18554.46,9895398.5059508588,null,79875.077734635517,7188756.9961171886]
[null,null,null,null,null,"2026-09-01",2026,"Q3","2026 Q3",8834404.9159508552,97849.202908687803,2.5499999999999998E-2,18773.11,10012020.818859546,null,79875.077734635517,7268632.0738518238]
[null,null,null,null,null,"2026-10-01",2026,"Q4","2026 Q4",8932254.1188595425,101045.16416045644,2.5499999999999998E-2,18981.04,10132047.023020001,null,79875.077734635517,7348507.151586459]
[null,null,null,null,null,"2026-11-01",2026,"Q4","2026 Q4",9033299.283019999,99393.479625748645,2.5499999999999998E-2,19195.759999999998,10250636.262645749,null,79875.077734635517,7428382.2293210942]
[null,null,null,null,null,"2026-12-01",2026,{"$f":"IF(MONTH(F131)=0,\"\",IF(MONTH(F131)<4,\"Q1\",IF(MONTH(F131)<7,\"Q2\",IF(MONTH(F131)<10,\"Q3\",\"Q4\"))))","v":"Q4"},"2026 Q4",9132692.7626457475,102121.34715701955,2.5499999999999998E-2,19406.97,10372164.57980277,null,79875.077734635517,7508257.3070557294]

{"sheet":"8. Opex Interest Annual","index":7,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the interest on amortization/depreciation expense, in the absence of monthly data."]
[]
[]
[null,"Sheet 8: Interest on Amortization (Annual Data) "]
[]
[]
[]
[]
[null,"Year",null,"OM&A",null,"Amortization Expense",null,"Cumulative OM&A and Amortization Expense",null,"Average Cumulative OM&A and Amortization Expense",null,"Average Annual Prescribed Interest Rate for Deferral and Variance Accounts (from Sheet 7)",null,"Simple Interest on OM&A and Amortization Expenses"]
[null,null,null,null,null,"(from Sheet 4)"]
[null,2018,null,0,null,null,null,{"$f":"D23+F23","v":0},null,{"$f":"H23/2","v":0},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C24:C27)","v":1.8624999999999999E-2},null,{"$f":"J23*L23","v":0}]
[null,2019,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!I357","v":424385.0778431159},null,{"$f":"H23+D24+F24","v":424385.0778431159},null,{"$f":"(H24+H23)/2","v":212192.53892155795},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C28:C31)","v":2.2474999999999998E-2},null,{"$f":"J24*L24","v":4769.0273122620147}]
[null,2020,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!K357","v":424385.0778431159},null,{"$f":"H24+D25+F25","v":848770.1556862318},null,{"$f":"(H25+H24)/2","v":636577.61676467385},null,{"$f":"AVERAGE('7. Funding Adder Revs'!C32:C35)","v":1.3749999999999998E-2},null,{"$f":"J25*L25","v":8752.9422305142634}]
[null,2021,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!M357","v":424385.0778431159},null,1273155.2335293477,null,1060962.6946077896,null,{"$f":"AVERAGE('7. Funding Adder Revs'!C36:C39)","v":5.7000000000000002E-3},null,6047.4873592644008]
[null,2022,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!O357","v":424385.0778431159},null,{"$f":"H26+D27+F27","v":1697540.3113724636},null,1485347.7724509058,null,{"$f":"AVERAGE('7. Funding Adder Revs'!C40:C43)","v":1.915E-2},null,28444.409842434845]
[null,2023,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!Q357","v":424385.0778431159},null,2121925.3892155793,null,1909732.8502940214,null,{"$f":"AVERAGE('7. Funding Adder Revs'!C44:C47)","v":5.0449999999999995E-2},null,96346.022297333373]
[null,2024,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!S357","v":424385.0778431159},null,2546310.4670586949,null,2334117.9281371371,null,{"$f":"AVERAGE('7. Funding Adder Revs'!C48:C51)","v":5.1449999999999996E-2},null,120090.3674026557]
[null,2025,null,0,null,{"$f":"-'4. ICM_Assets_and_Rate_Base'!U357","v":383820.12253923772},null,2930130.5895979325,null,2738220.5283283135,null,{"$f":"AVERAGE('7. Funding Adder Revs'!C52:C55)","v":3.1550000000000002E-2},null,86390.857668758297]
[null,2026,null,0,null,{"$f":"F30","v":383820.12253923772},null,3313950.7121371701,null,3122040.6508675516,null,{"$f":"AVERAGE('7. Funding Adder Revs'!C56:C59)","v":2.5499999999999998E-2},null,{"$f":"J31*L31","v":79612.036597122555}]
[]
[]
[null,"Cumulative Interest to 2018",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N23)","v":0}]
[null,"Cumulative Interest to 2019",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N24)","v":4769.0273122620147}]
[null,"Cumulative Interest to 2020",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N25)","v":13521.969542776278}]
[null,"Cumulative Interest to 2021",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N26)","v":19569.456902040678}]
[null,"Cumulative Interest to 2022",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N27)","v":48013.866744475527}]
[null,"Cumulative Interest to 2023",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N28)","v":144359.8890418089}]
[null,"Cumulative Interest to 2024",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N29)","v":264450.25644446461}]
[null,"Cumulative Interest to 2025",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N30)","v":350841.11411322292}]
[null,"Cumulative Interest to 2026",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($N$23:N31)","v":430453.15071034548}]

{"sheet":"9. IRR","index":8,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[[13,1,13,26],[19,2,19,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet calculates the ICM Incremental Revenue Requirement."]
[]
[]
[null,"Sheet 9: ICM Incremental Revenue Requirement"]
[null,null," "]
[]
[null,null,null,null,null,null,2018,null,2019,null,2020,null,2021,null,2022,null,2023,null,2024,null,2025,null,2026,null,"Total"]
[]
[null,null,"Deferred and forecasted ICM Incremental Revenue Requirement (from Sheet 6)",null,null,null,null,null,{"$f":"'6. ICMIRR_2019'!$F$88/12*10","v":1132927.3686772594},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"'6. ICMIRR_2019'!$F$88","v":1359512.8424127114},null,{"$f":"SUM(G22:W22)","v":10649517.265566239}]
[]
[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":4769.0273122620147},null,{"$f":"'8. Opex Interest Annual'!$N$25","v":8752.9422305142634},null,{"$f":"'8. Opex Interest Annual'!$N$26","v":6047.4873592644008},null,{"$f":"'8. Opex Interest Annual'!$N$27","v":28444.409842434845},null,{"$f":"'8. Opex Interest Annual'!$N$28","v":96346.022297333373},null,{"$f":"'8. Opex Interest Annual'!$N$29","v":120090.3674026557},null,{"$f":"'8. Opex Interest Annual'!$N$30","v":86390.857668758297},null,{"$f":"'8. Opex Interest Annual'!$N$31","v":79612.036597122555},null,{"$f":"SUM(G24:W24)","v":430453.15071034548}]
[]
[]
[null,null,"ICM Rate Rider Revenues (from Sheet 7)",null,null,null,{"$f":"SUM('7. Funding Adder Revs'!K26:K35)","v":0},null,{"$f":"SUM('7. Funding Adder Revs'!K36:K47)","v":967693.6955708001},null,{"$f":"SUM('7. Funding Adder Revs'!K48:K59)","v":1156417.6736599726},null,{"$f":"SUM('7. Funding Adder Revs'!K60:K71)","v":1156578.5497075273},null,{"$f":"SUM('7. Funding Adder Revs'!K72:K83)","v":1168433.1214351011},null,{"$f":"SUM('7. Funding Adder Revs'!K84:K95)","v":1182227.6608284817},null,{"$f":"SUM('7. Funding Adder Revs'!K96:K107)","v":1188965.7712091799},null,{"$f":"SUM('7. Funding Adder Revs'!K108:K119)","v":1210922.1317394052},null,{"$f":"SUM('7. Funding Adder Revs'!K120:K131)","v":1203575.5056522998},null,{"$f":"SUM(G27:W27)","v":9234814.1098027676}]
[]
[null,null,"ICM Rate Rider Interest (from Sheet 7)",null,null,null,{"$f":"SUM('7. Funding Adder Revs'!M27:M35)","v":0},null,{"$f":"SUM('7. Funding Adder Revs'!M36:M47)","v":7826.12},null,{"$f":"SUM('7. Funding Adder Revs'!M48:M59)","v":18176.600000000002},null,{"$f":"SUM('7. Funding Adder Revs'!M60:M71)","v":15092.519999999999},null,{"$f":"SUM('7. Funding Adder Revs'!M72:M83)","v":77044.259999999995},null,{"$f":"SUM('7. Funding Adder Revs'!M84:M95)","v":252499.24000000002},null,{"$f":"SUM('7. Funding Adder Revs'!M96:M107)","v":316307.48},null,{"$f":"SUM('7. Funding Adder Revs'!M108:M119)","v":231651.53},null,{"$f":"SUM('7. Funding Adder Revs'!M120:M131)","v":218752.72000000003},null,{"$f":"SUM(G29:W29)","v":1137350.47}]
[]
[null,null,"Net Deferred Revenue Requirement",null,null,null,{"$f":"(G22+G24)-(G27+G29)","v":0},null,{"$f":"(I22+I24)-(I27+I29)","v":162176.58041872131},null,{"$f":"(K22+K24)-(K27+K29)","v":193671.5109832529},null,{"$f":"(M22+M24)-(M27+M29)","v":193889.26006444846},null,{"$f":"(O22+O24)-(O27+O29)","v":142479.87082004501},null,{"$f":"(Q22+Q24)-(Q27+Q29)","v":21131.963881563162},null,{"$f":"(S22+S24)-(S27+S29)","v":-25670.041393812746},null,{"$f":"(U22+U24)-(U27+U29)","v":3330.0383420644794},null,{"$f":"(W22+W24)-(W27+W29)","v":16796.653357534204},null,{"$f":"(Y22+Y24)-(Y27+Y29)","v":707805.83647381701}]