{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1. Info","Incremental Capital Summary","Fixed Asset Amort and  UCC 1","Fixed Asset Amort and  UCC 2","Fixed Asset Amort and  UCC 3","Fixed Asset Amort and  UCC 4","Fixed Asset Amort and  UCC 5"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":6,"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. Info","index":0,"n_rows":100,"n_cols":27,"rows_kept":100,"cut":false,"hidden":false,"merged":[[23,2,23,4],[13,2,13,3],[13,5,13,10],[27,2,34,11],[0,2,1,12],[2,2,3,12],[23,5,23,10],[21,5,21,10],[19,5,19,10],[17,5,17,10],[17,2,17,3],[19,2,19,3],[21,2,21,4],[15,5,15,10],[15,2,15,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Version",1]
[null,null,"Applicant Name:",null,null,"PowerStream Inc."]
[]
[null,null,"Service Territory:",null,null,"York Region and Simcoe County"]
[]
[null,null,"Name:",null,null,"Tom Barrett"]
[]
[null,null,"Title:","Title:",null,"Manager, Rate Applications"]
[]
[null,null,"Phone Number:",null,null,"905.532.4640",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Algoma Power Inc."]
[null,null,"Email Address:",null,null,"tom.barrett@powerstream.ca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"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,3,"Attawapiskat Power Corp. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Bluewater Power 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,5,"Brant County Power Inc."]
[null,null,"This Workbook Model is protected by copyright and is being made available to you solely for the purpose of filing your IRM application.   You may use and copy this model for that purpose, and provide a copy of this model to any person that is advising or assisting you in that regard.  Except as indicated above, any copying, reproduction, publication, sale, adaptation, translation, modification, reverse engineering or other use or dissemination of this model without the express written consent of the Ontario Energy Board is prohibited.  If you provide a copy of this model to a person that is advising or assisting you in preparing the application or reviewing your draft rate order, you must ensure that the person understands and agrees to the restrictions noted above.  \n\nWhile this model has been provided in Excel format and is required to be filed with the applications, the onus remains on the applicant to ensure the accuracy of the data and the results.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"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,7,"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,8,"Cambridge and North Dumfries 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,9,"Canadian Niagara 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,10,"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,11,"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,12,"Clinton 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,13,"COLLUS 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,14,"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,15,"E.L.K. 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,16,"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,17,"Entegrus Powerlines 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,18,"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,19,"Erie Thames Powerlines 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,20,"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,21,"Essex Powerlines 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,22,"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,23,"Fort Albany 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,24,"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,25,"Greater Sudbury 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,26,"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,27,"Guelph Hydro Electric Systems 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,28,"Haldimand County Hydro Inc."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"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,30,"Hearst Power Distribution Company 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,31,"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,32,"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,33,"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,34,"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,35,"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,36,"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,37,"Innisfil Hydro Distribution 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,38,"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,39,"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,40,"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,41,"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,42,"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,43,"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,44,"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,45,"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,46,"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,47,"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,48,"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,49,"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,50,"Norfolk Power 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,51,"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,52,"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,53,"Oakville Hydro Electricity 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,54,"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,55,"Orillia Power 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,56,"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,57,"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,58,"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,59,"Peterborough Distribution Incorporated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"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,61,"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,62,"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,63,"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,64,"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,65,"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,66,"Thunder Bay Hydro Electricity 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,67,"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,68,"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,69,"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,70,"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,71,"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,72,"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,73,"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,74,"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,75,"West Perth 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,76,"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,77,"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,78,"Woodstock Hydro Services Inc."]

{"sheet":"Incremental Capital Summary","index":1,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[16,1,16,2],[10,1,10,2],[18,6,19,6],[18,8,19,8],[13,1,13,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Using the pull-down menu below, please identify what year of the IRM cycle you are in."]
[null,"1st year of IRM cycle"]
[]
[null,"Name or General Description of Project "]
[null,"System Service: Distribution System Capacity Relief"]
[]
[null,"Details of Project "]
[null,"See Appendix G"]
[]
[null,null,null,null,null,null,"Capital Cost (1/2 year rule applied)",null,"Depreciation   Rate"]
[null,"Asset Component",null,null,"Capital Cost",null,null,null,null,null,"CCA Class",null,"CCA Rate"]
[null,1,"Poles, towers and fixtures",null,774737,null,{"$f":"IF($B$11=\"4th year of IRM cycle\", E21/2, 0)","v":0},null,2.2222220000000001E-2,null,47,null,0.08]
[null,2,"Overhead conductor, devices, transformers, and services",null,574508,null,{"$f":"IF($B$11=\"4th year of IRM cycle\", E22/2, 0)","v":0},null,2.5000000000000001E-2,null,47,null,0.08]
[null,3,"Underground conductor and devices",null,2414323,null,{"$f":"IF($B$11=\"4th year of IRM cycle\", E23/2, 0)","v":0},null,2.2222222222222199E-2,null,47,null,0.08]
[null,4,"Underground transformers",null,165283,null,{"$f":"IF($B$11=\"4th year of IRM cycle\", E24/2, 0)","v":0},null,3.3333330000000001E-2,null,47,null,0.08]
[null,5,"Underground services",null,4272,null,{"$f":"IF($B$11=\"4th year of IRM cycle\", E25/2, 0)","v":0},null,0.04,null,47,null,0.08]
[]
[null,null,null,null,2014,null,null,null,2015,null,2016,null,2017,null,2018]
[null,"Closing Net Fixed Asset",null,null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!D32,'Fixed Asset Amort and  UCC 2'!D32, 'Fixed Asset Amort and  UCC 3'!D32, 'Fixed Asset Amort and  UCC 4'!D32,  'Fixed Asset Amort and  UCC 5'!D32)","v":3842211.9889392476},null,null,null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!E32,'Fixed Asset Amort and  UCC 2'!E32, 'Fixed Asset Amort and  UCC 3'!E32, 'Fixed Asset Amort and  UCC 4'!E32,  'Fixed Asset Amort and  UCC 5'!E32)","v":3751300.9778784961},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!F32,'Fixed Asset Amort and  UCC 2'!F32, 'Fixed Asset Amort and  UCC 3'!F32, 'Fixed Asset Amort and  UCC 4'!F32,  'Fixed Asset Amort and  UCC 5'!F32)","v":3660389.9668177431},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!G32,'Fixed Asset Amort and  UCC 2'!G32, 'Fixed Asset Amort and  UCC 3'!G32, 'Fixed Asset Amort and  UCC 4'!G32,  'Fixed Asset Amort and  UCC 5'!G32)","v":3569478.9557569912},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!H32,'Fixed Asset Amort and  UCC 2'!H32, 'Fixed Asset Amort and  UCC 3'!H32, 'Fixed Asset Amort and  UCC 4'!H32,  'Fixed Asset Amort and  UCC 5'!H32)","v":3478567.9446962392}]
[]
[null,"Amortization Expense",null,null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!D28,'Fixed Asset Amort and  UCC 2'!D28, 'Fixed Asset Amort and  UCC 3'!D28, 'Fixed Asset Amort and  UCC 4'!D28,  'Fixed Asset Amort and  UCC 5'!D28)","v":90911.011060752164},null,null,null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!E28,'Fixed Asset Amort and  UCC 2'!E28, 'Fixed Asset Amort and  UCC 3'!E28, 'Fixed Asset Amort and  UCC 4'!E28,  'Fixed Asset Amort and  UCC 5'!E28)","v":90911.011060752164},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!F28,'Fixed Asset Amort and  UCC 2'!F28, 'Fixed Asset Amort and  UCC 3'!F28, 'Fixed Asset Amort and  UCC 4'!F28,  'Fixed Asset Amort and  UCC 5'!F28)","v":90911.011060752164},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!G28,'Fixed Asset Amort and  UCC 2'!G28, 'Fixed Asset Amort and  UCC 3'!G28, 'Fixed Asset Amort and  UCC 4'!G28,  'Fixed Asset Amort and  UCC 5'!G28)","v":90911.011060752164},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!H28,'Fixed Asset Amort and  UCC 2'!H28, 'Fixed Asset Amort and  UCC 3'!H28, 'Fixed Asset Amort and  UCC 4'!H28,  'Fixed Asset Amort and  UCC 5'!H28)","v":90911.011060752164}]
[]
[null,"CCA",null,null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!D50,'Fixed Asset Amort and  UCC 2'!D50, 'Fixed Asset Amort and  UCC 3'!D50, 'Fixed Asset Amort and  UCC 4'!D50,  'Fixed Asset Amort and  UCC 5'!D50)","v":314649.84000000003},null,null,null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!E50,'Fixed Asset Amort and  UCC 2'!E50, 'Fixed Asset Amort and  UCC 3'!E50, 'Fixed Asset Amort and  UCC 4'!E50,  'Fixed Asset Amort and  UCC 5'!E50)","v":289477.85280000005},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!F50,'Fixed Asset Amort and  UCC 2'!F50, 'Fixed Asset Amort and  UCC 3'!F50, 'Fixed Asset Amort and  UCC 4'!F50,  'Fixed Asset Amort and  UCC 5'!F50)","v":266319.62457600003},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!G50,'Fixed Asset Amort and  UCC 2'!G50, 'Fixed Asset Amort and  UCC 3'!G50, 'Fixed Asset Amort and  UCC 4'!G50,  'Fixed Asset Amort and  UCC 5'!G50)","v":245014.05460991999},null,{"$f":"SUM('Fixed Asset Amort and  UCC 1'!H50,'Fixed Asset Amort and  UCC 2'!H50, 'Fixed Asset Amort and  UCC 3'!H50, 'Fixed Asset Amort and  UCC 4'!H50,  'Fixed Asset Amort and  UCC 5'!H50)","v":225412.93024112639}]

{"sheet":"Fixed Asset Amort and  UCC 1","index":2,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixed Asset Amortization and  UCC 1"]
[]
[null,"Name or General Description of Project "]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!B14), \"\", 'Incremental Capital Summary'!B14)","v":"System Service: Distribution System Capacity Relief"}]
[]
[null,"Asset Component"]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!C21),\"\",'Incremental Capital Summary'!C21)","v":"Poles, towers and fixtures"}]
[]
[]
[null,"Average Net Fixed Assets"]
[null,null,null,2014,2015,2016,2017,2018]
[null,"Net Fixed Assets",null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D25","v":774737},{"$f":"E25","v":774737},{"$f":"F25","v":774737},{"$f":"G25","v":774737}]
[null,"Capital Investment",null,{"$f":"IF('Incremental Capital Summary'!$B$11=\"4th year of IRM cycle\", 'Incremental Capital Summary'!E21/2,  'Incremental Capital Summary'!E21)","v":774737},0,0,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D23:D24)","v":774737},{"$f":"SUM(E23:E24)","v":774737},{"$f":"SUM(F23:F24)","v":774737},{"$f":"SUM(G23:G24)","v":774737},{"$f":"SUM(H23:H24)","v":774737}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D29","v":17216.376056140001},{"$f":"E29","v":34432.752112280003},{"$f":"F29","v":51649.128168420008},{"$f":"G29","v":68865.504224560005}]
[null,"Amortization",{"$f":"'Incremental Capital Summary'!I21","v":2.2222220000000001E-2},{"$f":"D24*$C$28","v":17216.376056140001},{"$f":"E23*$C$28","v":17216.376056140001},{"$f":"F23*$C$28","v":17216.376056140001},{"$f":"G23*$C$28","v":17216.376056140001},{"$f":"H23*$C$28","v":17216.376056140001}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D27:D28)","v":17216.376056140001},{"$f":"SUM(E27:E28)","v":34432.752112280003},{"$f":"SUM(F27:F28)","v":51649.128168420008},{"$f":"SUM(G27:G28)","v":68865.504224560005},{"$f":"SUM(H27:H28)","v":86081.880280700003}]
[]
[null,"Opening Net Fixed Assets",null,0,{"$f":"E23-E27","v":757520.62394385994},{"$f":"F23-F27","v":740304.24788772},{"$f":"G23-G27","v":723087.87183157995},{"$f":"H23-H27","v":705871.49577544001}]
[null,"Closing Net Fixed Assets",null,{"$f":"D25-D29","v":757520.62394385994},{"$f":"E25-E29","v":740304.24788772},{"$f":"F25-F29","v":723087.87183157995},{"$f":"G25-G29","v":705871.49577544001},{"$f":"H25-H29","v":688655.11971929995}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D31:D32)/2","v":378760.31197192997},{"$f":"SUM(E31:E32)/2","v":748912.43591579003},{"$f":"SUM(F31:F32)/2","v":731696.05985964998},{"$f":"SUM(G31:G32)/2","v":714479.68380350992},{"$f":"SUM(H31:H32)/2","v":697263.30774736998}]
[]
[]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC",null,2014,2015,2016,2017,2018]
[null,null,null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening UCC",null,0,{"$f":"D51","v":712758.04},{"$f":"E51","v":655737.39679999999},{"$f":"F51","v":603278.40505599999},{"$f":"G51","v":555016.13265151996}]
[null,"Capital Additions",null,{"$f":"D24","v":774737},{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":0}]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D43:D44)","v":774737},{"$f":"SUM(E43:E44)","v":712758.04},{"$f":"SUM(F43:F44)","v":655737.39679999999},{"$f":"SUM(G43:G44)","v":603278.40505599999},{"$f":"SUM(H43:H44)","v":555016.13265151996}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,0,{"$f":"E44/2","v":0},{"$f":"F44/2","v":0},{"$f":"G44/2","v":0},{"$f":"H44/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D45-D46","v":774737},{"$f":"E45-E46","v":712758.04},{"$f":"F45-F46","v":655737.39679999999},{"$f":"G45-G46","v":603278.40505599999},{"$f":"H45-H46","v":555016.13265151996}]
[null,"CCA Rate Class",{"$f":"'Incremental Capital Summary'!K21","v":47}]
[null,"CCA Rate ",{"$f":"'Incremental Capital Summary'!M21","v":0.08}]
[null,"CCA",null,{"$f":"D47*$C$49","v":61978.96},{"$f":"E47*$C$49","v":57020.643200000006},{"$f":"F47*$C$49","v":52458.991743999999},{"$f":"G47*$C$49","v":48262.272404479998},{"$f":"H47*$C$49","v":44401.2906121216}]
[null,"Closing UCC",null,{"$f":"D45-D50","v":712758.04},{"$f":"E45-E50","v":655737.39679999999},{"$f":"F45-F50","v":603278.40505599999},{"$f":"G45-G50","v":555016.13265151996},{"$f":"H45-H50","v":510614.84203939838}]

{"sheet":"Fixed Asset Amort and  UCC 2","index":3,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixed Asset Amortization and  UCC 2"]
[]
[null,"Name or General Description of Project "]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!B14), \"\", 'Incremental Capital Summary'!B14)","v":"System Service: Distribution System Capacity Relief"}]
[]
[null,"Asset Component"]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!C22),\"\",'Incremental Capital Summary'!C22)","v":"Overhead conductor, devices, transformers, and services"}]
[]
[]
[null,"Average Net Fixed Assets"]
[null,null,null,2014,2015,2016,2017,2018]
[null,"Net Fixed Assets",null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D25","v":574508},{"$f":"E25","v":574508},{"$f":"F25","v":574508},{"$f":"G25","v":574508}]
[null,"Capital Investment",null,{"$f":"IF('Incremental Capital Summary'!$B$11=\"4th year of IRM cycle\", 'Incremental Capital Summary'!E22/2,  'Incremental Capital Summary'!E22)","v":574508},0,0,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D23:D24)","v":574508},{"$f":"SUM(E23:E24)","v":574508},{"$f":"SUM(F23:F24)","v":574508},{"$f":"SUM(G23:G24)","v":574508},{"$f":"SUM(H23:H24)","v":574508}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D29","v":14362.7},{"$f":"E29","v":28725.4},{"$f":"F29","v":43088.100000000006},{"$f":"G29","v":57450.8}]
[null,"Amortization",{"$f":"'Incremental Capital Summary'!I22","v":2.5000000000000001E-2},{"$f":"D24*$C$28","v":14362.7},{"$f":"E23*$C$28","v":14362.7},{"$f":"F23*$C$28","v":14362.7},{"$f":"G23*$C$28","v":14362.7},{"$f":"H23*$C$28","v":14362.7}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D27:D28)","v":14362.7},{"$f":"SUM(E27:E28)","v":28725.4},{"$f":"SUM(F27:F28)","v":43088.100000000006},{"$f":"SUM(G27:G28)","v":57450.8},{"$f":"SUM(H27:H28)","v":71813.5}]
[]
[null,"Opening Net Fixed Assets",null,0,{"$f":"E23-E27","v":560145.30000000005},{"$f":"F23-F27","v":545782.6},{"$f":"G23-G27","v":531419.9},{"$f":"H23-H27","v":517057.2}]
[null,"Closing Net Fixed Assets",null,{"$f":"D25-D29","v":560145.30000000005},{"$f":"E25-E29","v":545782.6},{"$f":"F25-F29","v":531419.9},{"$f":"G25-G29","v":517057.2},{"$f":"H25-H29","v":502694.5}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D31:D32)/2","v":280072.65000000002},{"$f":"SUM(E31:E32)/2","v":552963.94999999995},{"$f":"SUM(F31:F32)/2","v":538601.25},{"$f":"SUM(G31:G32)/2","v":524238.55000000005},{"$f":"SUM(H31:H32)/2","v":509875.85}]
[]
[]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC",null,2014,2015,2016,2017,2018]
[null,null,null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening UCC",null,0,{"$f":"D51","v":528547.36},{"$f":"E51","v":486263.57120000001},{"$f":"F51","v":447362.48550399998},{"$f":"G51","v":411573.48666368}]
[null,"Capital Additions",null,{"$f":"D24","v":574508},{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":0}]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D43:D44)","v":574508},{"$f":"SUM(E43:E44)","v":528547.36},{"$f":"SUM(F43:F44)","v":486263.57120000001},{"$f":"SUM(G43:G44)","v":447362.48550399998},{"$f":"SUM(H43:H44)","v":411573.48666368}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,0,{"$f":"E44/2","v":0},{"$f":"F44/2","v":0},{"$f":"G44/2","v":0},{"$f":"H44/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D45-D46","v":574508},{"$f":"E45-E46","v":528547.36},{"$f":"F45-F46","v":486263.57120000001},{"$f":"G45-G46","v":447362.48550399998},{"$f":"H45-H46","v":411573.48666368}]
[null,"CCA Rate Class",{"$f":"'Incremental Capital Summary'!K22","v":47}]
[null,"CCA Rate ",{"$f":"'Incremental Capital Summary'!M22","v":0.08}]
[null,"CCA",null,{"$f":"D47*$C$49","v":45960.639999999999},{"$f":"E47*$C$49","v":42283.788800000002},{"$f":"F47*$C$49","v":38901.085696000002},{"$f":"G47*$C$49","v":35788.998840319997},{"$f":"H47*$C$49","v":32925.878933094398}]
[null,"Closing UCC",null,{"$f":"D45-D50","v":528547.36},{"$f":"E45-E50","v":486263.57120000001},{"$f":"F45-F50","v":447362.48550399998},{"$f":"G45-G50","v":411573.48666368},{"$f":"H45-H50","v":378647.60773058562}]

{"sheet":"Fixed Asset Amort and  UCC 3","index":4,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixed Asset Amortization and  UCC 3"]
[]
[null,"Name or General Description of Project "]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!B14), \"\", 'Incremental Capital Summary'!B14)","v":"System Service: Distribution System Capacity Relief"}]
[]
[null,"Asset Component"]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!C23),\"\",'Incremental Capital Summary'!C23)","v":"Underground conductor and devices"}]
[]
[]
[null,"Average Net Fixed Assets"]
[null,null,null,2014,2015,2016,2017,2018]
[null,"Net Fixed Assets",null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D25","v":2414323},{"$f":"E25","v":2414323},{"$f":"F25","v":2414323},{"$f":"G25","v":2414323}]
[null,"Capital Investment",null,{"$f":"IF('Incremental Capital Summary'!$B$11=\"4th year of IRM cycle\", 'Incremental Capital Summary'!E23/2,  'Incremental Capital Summary'!E23)","v":2414323},0,0,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D23:D24)","v":2414323},{"$f":"SUM(E23:E24)","v":2414323},{"$f":"SUM(F23:F24)","v":2414323},{"$f":"SUM(G23:G24)","v":2414323},{"$f":"SUM(H23:H24)","v":2414323}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D29","v":53651.622222222162},{"$f":"E29","v":107303.24444444432},{"$f":"F29","v":160954.86666666649},{"$f":"G29","v":214606.48888888865}]
[null,"Amortization",{"$f":"'Incremental Capital Summary'!I23","v":2.2222222222222199E-2},{"$f":"D24*$C$28","v":53651.622222222162},{"$f":"E23*$C$28","v":53651.622222222162},{"$f":"F23*$C$28","v":53651.622222222162},{"$f":"G23*$C$28","v":53651.622222222162},{"$f":"H23*$C$28","v":53651.622222222162}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D27:D28)","v":53651.622222222162},{"$f":"SUM(E27:E28)","v":107303.24444444432},{"$f":"SUM(F27:F28)","v":160954.86666666649},{"$f":"SUM(G27:G28)","v":214606.48888888865},{"$f":"SUM(H27:H28)","v":268258.11111111083}]
[]
[null,"Opening Net Fixed Assets",null,0,{"$f":"E23-E27","v":2360671.3777777776},{"$f":"F23-F27","v":2307019.7555555557},{"$f":"G23-G27","v":2253368.1333333333},{"$f":"H23-H27","v":2199716.5111111114}]
[null,"Closing Net Fixed Assets",null,{"$f":"D25-D29","v":2360671.3777777776},{"$f":"E25-E29","v":2307019.7555555557},{"$f":"F25-F29","v":2253368.1333333333},{"$f":"G25-G29","v":2199716.5111111114},{"$f":"H25-H29","v":2146064.888888889}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D31:D32)/2","v":1180335.6888888888},{"$f":"SUM(E31:E32)/2","v":2333845.5666666664},{"$f":"SUM(F31:F32)/2","v":2280193.9444444445},{"$f":"SUM(G31:G32)/2","v":2226542.3222222226},{"$f":"SUM(H31:H32)/2","v":2172890.7000000002}]
[]
[]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC",null,2014,2015,2016,2017,2018]
[null,null,null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening UCC",null,0,{"$f":"D51","v":2221177.16},{"$f":"E51","v":2043482.9872000001},{"$f":"F51","v":1880004.3482240001},{"$f":"G51","v":1729604.0003660801}]
[null,"Capital Additions",null,{"$f":"D24","v":2414323},{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":0}]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D43:D44)","v":2414323},{"$f":"SUM(E43:E44)","v":2221177.16},{"$f":"SUM(F43:F44)","v":2043482.9872000001},{"$f":"SUM(G43:G44)","v":1880004.3482240001},{"$f":"SUM(H43:H44)","v":1729604.0003660801}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,0,{"$f":"E44/2","v":0},{"$f":"F44/2","v":0},{"$f":"G44/2","v":0},{"$f":"H44/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D45-D46","v":2414323},{"$f":"E45-E46","v":2221177.16},{"$f":"F45-F46","v":2043482.9872000001},{"$f":"G45-G46","v":1880004.3482240001},{"$f":"H45-H46","v":1729604.0003660801}]
[null,"CCA Rate Class",{"$f":"'Incremental Capital Summary'!K23","v":47}]
[null,"CCA Rate ",{"$f":"'Incremental Capital Summary'!M23","v":0.08}]
[null,"CCA",null,{"$f":"D47*$C$49","v":193145.84},{"$f":"E47*$C$49","v":177694.17280000003},{"$f":"F47*$C$49","v":163478.63897600002},{"$f":"G47*$C$49","v":150400.34785792002},{"$f":"H47*$C$49","v":138368.32002928641}]
[null,"Closing UCC",null,{"$f":"D45-D50","v":2221177.16},{"$f":"E45-E50","v":2043482.9872000001},{"$f":"F45-F50","v":1880004.3482240001},{"$f":"G45-G50","v":1729604.0003660801},{"$f":"H45-H50","v":1591235.6803367937}]

{"sheet":"Fixed Asset Amort and  UCC 4","index":5,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixed Asset Amortization and  UCC 4"]
[]
[null,"Name or General Description of Project "]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!B14), \"\", 'Incremental Capital Summary'!B14)","v":"System Service: Distribution System Capacity Relief"}]
[]
[null,"Asset Component"]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!C24),\"\",'Incremental Capital Summary'!C24)","v":"Underground transformers"}]
[]
[]
[null,"Average Net Fixed Assets"]
[null,null,null,2014,2015,2016,2017,2018]
[null,"Net Fixed Assets",null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D25","v":165283},{"$f":"E25","v":165283},{"$f":"F25","v":165283},{"$f":"G25","v":165283}]
[null,"Capital Investment",null,{"$f":"IF('Incremental Capital Summary'!$B$11=\"4th year of IRM cycle\", 'Incremental Capital Summary'!E24/2,  'Incremental Capital Summary'!E24)","v":165283},0,0,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D23:D24)","v":165283},{"$f":"SUM(E23:E24)","v":165283},{"$f":"SUM(F23:F24)","v":165283},{"$f":"SUM(G23:G24)","v":165283},{"$f":"SUM(H23:H24)","v":165283}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D29","v":5509.4327823900003},{"$f":"E29","v":11018.865564780001},{"$f":"F29","v":16528.298347169999},{"$f":"G29","v":22037.731129560001}]
[null,"Amortization",{"$f":"'Incremental Capital Summary'!I24","v":3.3333330000000001E-2},{"$f":"D24*$C$28","v":5509.4327823900003},{"$f":"E23*$C$28","v":5509.4327823900003},{"$f":"F23*$C$28","v":5509.4327823900003},{"$f":"G23*$C$28","v":5509.4327823900003},{"$f":"H23*$C$28","v":5509.4327823900003}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D27:D28)","v":5509.4327823900003},{"$f":"SUM(E27:E28)","v":11018.865564780001},{"$f":"SUM(F27:F28)","v":16528.298347169999},{"$f":"SUM(G27:G28)","v":22037.731129560001},{"$f":"SUM(H27:H28)","v":27547.163911950003}]
[]
[null,"Opening Net Fixed Assets",null,0,{"$f":"E23-E27","v":159773.56721760999},{"$f":"F23-F27","v":154264.13443522001},{"$f":"G23-G27","v":148754.70165283},{"$f":"H23-H27","v":143245.26887043999}]
[null,"Closing Net Fixed Assets",null,{"$f":"D25-D29","v":159773.56721760999},{"$f":"E25-E29","v":154264.13443522001},{"$f":"F25-F29","v":148754.70165283},{"$f":"G25-G29","v":143245.26887043999},{"$f":"H25-H29","v":137735.83608804998}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D31:D32)/2","v":79886.783608804995},{"$f":"SUM(E31:E32)/2","v":157018.850826415},{"$f":"SUM(F31:F32)/2","v":151509.41804402502},{"$f":"SUM(G31:G32)/2","v":145999.98526163498},{"$f":"SUM(H31:H32)/2","v":140490.552479245}]
[]
[]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC",null,2014,2015,2016,2017,2018]
[null,null,null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening UCC",null,0,{"$f":"D51","v":152060.35999999999},{"$f":"E51","v":139895.5312},{"$f":"F51","v":128703.888704},{"$f":"G51","v":118407.57760768}]
[null,"Capital Additions",null,{"$f":"D24","v":165283},{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":0}]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D43:D44)","v":165283},{"$f":"SUM(E43:E44)","v":152060.35999999999},{"$f":"SUM(F43:F44)","v":139895.5312},{"$f":"SUM(G43:G44)","v":128703.888704},{"$f":"SUM(H43:H44)","v":118407.57760768}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,0,{"$f":"E44/2","v":0},{"$f":"F44/2","v":0},{"$f":"G44/2","v":0},{"$f":"H44/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D45-D46","v":165283},{"$f":"E45-E46","v":152060.35999999999},{"$f":"F45-F46","v":139895.5312},{"$f":"G45-G46","v":128703.888704},{"$f":"H45-H46","v":118407.57760768}]
[null,"CCA Rate Class",{"$f":"'Incremental Capital Summary'!K24","v":47}]
[null,"CCA Rate ",{"$f":"'Incremental Capital Summary'!M24","v":0.08}]
[null,"CCA",null,{"$f":"D47*$C$49","v":13222.64},{"$f":"E47*$C$49","v":12164.828799999999},{"$f":"F47*$C$49","v":11191.642496},{"$f":"G47*$C$49","v":10296.31109632},{"$f":"H47*$C$49","v":9472.6062086143993}]
[null,"Closing UCC",null,{"$f":"D45-D50","v":152060.35999999999},{"$f":"E45-E50","v":139895.5312},{"$f":"F45-F50","v":128703.888704},{"$f":"G45-G50","v":118407.57760768},{"$f":"H45-H50","v":108934.9713990656}]

{"sheet":"Fixed Asset Amort and  UCC 5","index":6,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixed Asset Amortization and  UCC 5"]
[]
[null,"Name or General Description of Project "]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!B14), \"\", 'Incremental Capital Summary'!B14)","v":"System Service: Distribution System Capacity Relief"}]
[]
[null,"Asset Component"]
[null,{"$f":"IF(ISBLANK('Incremental Capital Summary'!C25),\"\",'Incremental Capital Summary'!C25)","v":"Underground services"}]
[]
[]
[null,"Average Net Fixed Assets"]
[null,null,null,2014,2015,2016,2017,2018]
[null,"Net Fixed Assets",null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening Capital Investment",null,0,{"$f":"D25","v":4272},{"$f":"E25","v":4272},{"$f":"F25","v":4272},{"$f":"G25","v":4272}]
[null,"Capital Investment",null,{"$f":"IF('Incremental Capital Summary'!$B$11=\"4th year of IRM cycle\", 'Incremental Capital Summary'!E25/2,  'Incremental Capital Summary'!E25)","v":4272},0,0,0,0]
[null,"Closing Capital Investment",null,{"$f":"SUM(D23:D24)","v":4272},{"$f":"SUM(E23:E24)","v":4272},{"$f":"SUM(F23:F24)","v":4272},{"$f":"SUM(G23:G24)","v":4272},{"$f":"SUM(H23:H24)","v":4272}]
[]
[null,"Opening Accumulated Amortization",null,0,{"$f":"D29","v":170.88},{"$f":"E29","v":341.76},{"$f":"F29","v":512.64},{"$f":"G29","v":683.52}]
[null,"Amortization",{"$f":"'Incremental Capital Summary'!I25","v":0.04},{"$f":"D24*$C$28","v":170.88},{"$f":"E23*$C$28","v":170.88},{"$f":"F23*$C$28","v":170.88},{"$f":"G23*$C$28","v":170.88},{"$f":"H23*$C$28","v":170.88}]
[null,"Closing Accumulated Amortization",null,{"$f":"SUM(D27:D28)","v":170.88},{"$f":"SUM(E27:E28)","v":341.76},{"$f":"SUM(F27:F28)","v":512.64},{"$f":"SUM(G27:G28)","v":683.52},{"$f":"SUM(H27:H28)","v":854.4}]
[]
[null,"Opening Net Fixed Assets",null,0,{"$f":"E23-E27","v":4101.12},{"$f":"F23-F27","v":3930.24},{"$f":"G23-G27","v":3759.36},{"$f":"H23-H27","v":3588.48}]
[null,"Closing Net Fixed Assets",null,{"$f":"D25-D29","v":4101.12},{"$f":"E25-E29","v":3930.24},{"$f":"F25-F29","v":3759.36},{"$f":"G25-G29","v":3588.48},{"$f":"H25-H29","v":3417.6}]
[null,"Average Net Fixed Assets",null,{"$f":"SUM(D31:D32)/2","v":2050.56},{"$f":"SUM(E31:E32)/2","v":4015.68},{"$f":"SUM(F31:F32)/2","v":3844.8},{"$f":"SUM(G31:G32)/2","v":3673.92},{"$f":"SUM(H31:H32)/2","v":3503.04}]
[]
[]
[]
[]
[null,"For PILs Calculation"]
[]
[null,"UCC",null,2014,2015,2016,2017,2018]
[null,null,null,"Forecasted","Forecasted","Forecasted","Forecasted","Forecasted"]
[]
[null,"Opening UCC",null,0,{"$f":"D51","v":3930.24},{"$f":"E51","v":3615.8208},{"$f":"F51","v":3326.5551359999999},{"$f":"G51","v":3060.4307251199998}]
[null,"Capital Additions",null,{"$f":"D24","v":4272},{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":0}]
[null,"UCC Before Half Year Rule",null,{"$f":"SUM(D43:D44)","v":4272},{"$f":"SUM(E43:E44)","v":3930.24},{"$f":"SUM(F43:F44)","v":3615.8208},{"$f":"SUM(G43:G44)","v":3326.5551359999999},{"$f":"SUM(H43:H44)","v":3060.4307251199998}]
[null,"Half Year Rule (1/2 Additions - Disposals)",null,0,{"$f":"E44/2","v":0},{"$f":"F44/2","v":0},{"$f":"G44/2","v":0},{"$f":"H44/2","v":0}]
[null,"Reduced UCC",null,{"$f":"D45-D46","v":4272},{"$f":"E45-E46","v":3930.24},{"$f":"F45-F46","v":3615.8208},{"$f":"G45-G46","v":3326.5551359999999},{"$f":"H45-H46","v":3060.4307251199998}]
[null,"CCA Rate Class",{"$f":"'Incremental Capital Summary'!K25","v":47}]
[null,"CCA Rate ",{"$f":"'Incremental Capital Summary'!M25","v":0.08}]
[null,"CCA",null,{"$f":"D47*$C$49","v":341.76},{"$f":"E47*$C$49","v":314.41919999999999},{"$f":"F47*$C$49","v":289.26566400000002},{"$f":"G47*$C$49","v":266.12441088000003},{"$f":"H47*$C$49","v":244.83445800959998}]
[null,"Closing UCC",null,{"$f":"D45-D50","v":3930.24},{"$f":"E45-E50","v":3615.8208},{"$f":"F45-F50","v":3326.5551359999999},{"$f":"G45-G50","v":3060.4307251199998},{"$f":"H45-H50","v":2815.5962671103998}]