{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1-SEC-16","1-Staff-39 (IT)","1-Staff-41 (Non-IT)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8015,"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-SEC-16","index":0,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[31,0,31,2],[29,0,29,2],[30,0,30,2],[54,0,54,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[50,0,50,2],[51,0,51,2],[52,0,52,2]]}
["Mergers","2020 EDR Category","Project Name","Total Project Cost","2027 Opening Net Book Value","Rationale for Inclusion","Amount Identified in Legacy DSPs ($ MM)"]
["Alectra Merger","CIS consolidation","CIS Consolidation",41619291.82,9377304.1101587228,"1) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit4_Part1_PUBLIC REDACTED_20140416.pdf, page 92\nDetails: Horizon Utilities discussed the need for investment in a new or upgraded CIS system. The current CIS was nearing the end of its useful life, and Horizon planned to investigate requirements for a new or upgraded CIS in 2017. The project plans for the upgrade or replacement were envisioned to commence in 2020, with full implementation by 2021.\n\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit4_Part1_PUBLIC REDACTED_20140416.pdf, page 167\nDetails: Horizon Utilities anticipated an increase in Customer Care costs in 2017 due to non-recurring project and consulting costs of $400,000 for the investigation and planning of the CIS upgrade or replacement. The CIS upgrade or replacement project was scheduled to begin in 2020 for implementation in 2021.\n\nForecasted Post-Merger Expenses: Ex.2/Tab 6/Sched.1 “Website & Customer Tools” pp. 66 - 68; $0.05 MM/yr in 2017 - 2019 (Subtotal $0.15 MM)\n\n2) PowerStream Inc. (EB-2015-0003)\nReference: PowerStream_IRR_Section B_20150821.pdf, page 207\nDetails: PowerStream added a new capital asset account for CIS software with a typical useful life of 10 years. The implementation of a new Oracle-based customer service and billing system was discussed, with the system expected to have a longer useful life than other software programs.\n\nForecasted Post-Merger Expenses: DSP Chapter 5 “Information Technology,” CIS modernization, p. 437; $15.6969 MM (2017 - 2020).",15.85]
[null,"Subtotal - CIS consolidation",null,41619291.82,{"$f":"SUBTOTAL(9,E2)","v":9377304.1101587228},null,15.85]
["Alectra Merger","ERP consolidation","ERP Consolidation",25511881.66,9154213.9233418349,"1) Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_IRR_2015_20140813.pdf, page 113\nDetails: Hydro One Brampton discussed the implementation of a new ERP system as part of its Distribution System Plan. The ERP system was described as necessary to replace a 30-year-old IT system. - The ERP system was expected to provide a centralized and integrated platform for financial, operational, and customer service functions. - The business case for the ERP system was included in the application, with costs spread over multiple years.\n \n2) PowerStream Inc. (EB-2015-0003)\nReference: PowerStream_APPL_Custom_IR_Part 3_20150522.pdf, page 344\nDetails: PowerStream proposed ERP enhancements as part of its IT and Information/Communication Systems investments for 2016-2020. - The ERP enhancements were included in a combined budget for IT projects designed to maintain, enhance, or upgrade critical systems and applications. - Specific dollar amounts for ERP-related investments were not separately itemized but were part of the broader IT budget.\n\nForecasted Post-Merger Expenses: Chapter 5 IT summary table, JDE/ERP upgrade p. 436; $2.3968 MM (2019).\n \n3) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 208\nDetails: Horizon Utilities included ERP modernization as part of its IT investments in its Distribution System Plan. The ERP system was identified as a critical tool for improving operational efficiency and supporting new business capabilities. The plan included migrating to a new ERP system to address end-of-vendor support for the existing system and to integrate with other enterprise systems like GIS and OMS.\n\nForecasted Post-Merger Expenses: Ex.2/Tab 6/Sched.1 “IFS ERP upgrade (2018)” pp. 67 - 68; $1.225 MM (2018).\n \n4) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: Energy Probe_IR_Enersource_20120704.pdf, page 10\nDetails: Enersource discussed capital expenditures for IT systems, including ERP-related projects, as part of its application. The application included plans for IT system upgrades, but specific details on ERP modernization were not explicitly itemized.\n \nForecasted Post-Merger Expenses: General Plant, Tables 79 - 80 pp. 382 - 387; ERP licenses/upgrades $0.345 MM (over plan window).",3.97]
[null,"Subtotal - ERP consolidation",null,25511881.66,{"$f":"SUBTOTAL(9,E4)","v":9154213.9233418349},null,3.97]
["Alectra Merger","GIS/OMS consolidation","GIS Convergence",3345416.1900000004,1616951.4968333333,"1) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 418\nDetails: Horizon Utilities discussed GIS as part of its business case for the 2018 Annual Corporate Computer Replacement. The justification included the integration of GIS with other enterprise systems to improve electricity system operation and mitigate risks related to aging systems.\n\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 508\nDetails: The 2019 Annual Corporate Computer Replacement included references to GIS as a strategic asset. The business case emphasized the importance of GIS in supporting investments in new applications and infrastructure.\n\nReference: SEC Horizon TCQ 20140815 with Attachments.pdf, page 4\nDetails: Horizon Utilities provided a GIS business case in its response to SEC-25, which included anticipated savings and efficiency improvements. The business case also discussed interoperability with other systems and the benefits of GIS for field operations.\n \n2) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: BdStaff_IR_Enersource_20120628.pdf, page 19\nDetails: Enersource discussed GIS systems in the context of supporting project management, asset management processes, and outage restoration. The benefits of GIS were described as indirect savings through productivity and efficiency gains.\n\nReference: BdStaff_IR_Enersource_20120628.pdf, page 10\nDetails: Enersource discussed GIS in the context of its Green Energy Act (GEA) plan. The plan included GIS as part of the tools required to connect renewable generation projects and manage customer engineering and field construction.\n \n3) Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_IRR_2015_20140813.pdf, page 625\nDetails: Hydro One Brampton discussed GIS systems in the context of mobile workforce management applications and asset management. The integration of GIS with mobile applications was highlighted as a key initiative.\n\nForecasted Post-Merger Expenses: Appendix 2-AB (General Plant) pp. 126–128; REG expansion inclusive of GIS elements $0.2442 MM (2017 - 2019).",0.24]
["Alectra Merger","GIS/OMS consolidation","OMS Convergence",8859418.5,6053936.2414999995,"1) Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_Exhibit_9_20140423.pdf, page 113\nDetails: The evidence discusses work related to the Smart Meter Integration with the OMS system. It mentions that the OMS system infrastructure existed, but there were programming hurdles at the time. The Smart Metering Vendor was working on providing programming code to incorporate outage management into the system at no additional cost.\n \n2) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit4_Part1_PUBLIC REDACTED_20140416.pdf, page 185\nDetails: The application discusses anticipated savings from a reduction in outside service provider expenses related to the ongoing development and operation of the OMS. It also mentions consulting costs to support asset management with asset condition studies.\n\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 177\nDetails: The application includes a capital project summary for 2016, which mentions the renewal of rear lot overhead distribution assets and the use of OMS for system operation improvements.\n\nForecasted Post-Merger Expenses: Ex.2/Tab 6/Sched.1, OMS program pp. 66 - 68; $0.25 MM (2017), $0.05 MM (2018), $0.05 MM (2019) \n \n3) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: Enersource_Suggested Version of Redacted Tech Conf July 31 2012_20120816.pdf, page 94-95\nDetails: The technical conference transcript discusses the inclusion of smart meter-related expenses in OM&A, including ongoing smart meter expenditures and their integration with OMS.\n\nReference: Energy Probe_IR_Enersource_20120704.pdf, page 10\nDetails: The interrogatory response mentions capital programs intended to sustain SAIDI and SAIFI, which are described in the Asset Management Plan (AMP). These programs include OMS-related investments.\n \n4) PowerStream Inc. (EB-2015-0003)\nReference: Exhibit K1.3_SEC_Cross-Examination Compendium_Panel 1 OM&A_20151120.pdf, page 37\nDetails: The application discusses the implementation of a new Customer Information System (CIS) and its integration with OMS to improve customer service and operational efficiency.",0.35]
[null,"Subtotal - GIS/OMS consolidation",null,12204834.690000001,{"$f":"SUBTOTAL(9,E6:E7)","v":7670887.7383333333},null,0.59]
["Alectra Merger","IT system migration and integration","Phone System Consolidation",2123217.4000000004,368057.76833333337,"1) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 97\nDetails: Horizon Utilities planned an \"Enterprise Phone System Upgrade\" as part of its 2015-2019 Custom IR application. The project involved replacing the phone system and call center software in Hamilton and the redundant backup phone system in St. Catharines. The capital investment was estimated at ~$400,000, with the project scheduled to start in August 2015 and go live in November 2015. The upgrade aimed to mitigate risks related to the end of vendor support for the existing system installed in 2010.",0.4]
["Alectra Merger","IT system migration and integration","SCADA Consolidation",3051378.27,889985.25,"1) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: Interrogatory Responses, Supp-Staff-15, p. 184\nDetails: The document outlines SCADA-related expenditures, including major upgrades to the SCADA system in 2015 and 2016. It also contemplates the need for expenditure on SCADA upgrades in 2018 and 2020.\n\nReference: LDC Co_JTC1_6_Enersource_Draft_DSP_EB-2015-0065_20160830.pdf, page 44\nDetails: The document describes the SCADA system's role in providing real-time data on key assets in the field, such as stations, circuit breakers, and automated switches. It also discusses the use of SCADA data for operating and engineering analysis to improve system performance.\n\nForecasted Post-Merger Expenses: S. 3.5.2.3.3 “Automation/SCADA Replacement and Enhancement Program” pp. 386 - 387; $19.422MM (program total).\n \n2) Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_IRR_2015_20140813.pdf, page 113\nDetails: The document discusses the benefits of a new ERP system integrated with SCADA, including improved workflows and centralized systems for better customer service.\n \n3) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 271\nDetails: The application includes SCADA-related investments as part of enabling future technology and operational requirements. It mentions that SCADA systems are constantly upgraded to deliver new processes and functionality, requiring up-to-date hardware to maintain vendor support. Capital Project summaries for 2017 onward show planned SCADA expenditures as a part of substation infrastructure renewal.\n\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 317\nDetails: The document discusses SCADA system upgrades as part of enabling future technology and operational requirements. It highlights the need for up-to-date hardware to support upgrades to GIS, OMS, SCADA, AMI, and IFS ERP systems.\n \n4) PowerStream Inc. (EB-2015-0003)\nForecasted Post-Merger Expenses: Chapter 5, SCADA modernization p. 436; $18.552MM (2017 - 2020).",37.97]
["Alectra Merger","IT system migration and integration","Data Backup & Archiving",886148.62000000023,0,"No 2027 Opening NBV",0]
["Alectra Merger","IT system migration and integration","IT Security Consolidation",1227743.83,0,"1) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part1_PUBLIC REDACTED_20140416.pdf, page: 416\nDetails: Horizon Utilities outlined its IT Security Planning process, which included: Reviewing security incident and event monitoring (SIEM) system logs to identify security incidents and potential threats, conducting periodic third-party security assessments to identify potential security risks, and performing internal security reviews of IST infrastructure and applications to identify required security changes.\n\nForecasted Post-Merger Expenses: Ex.2/Tab 6/Sched.1 pp. 66 - 68; SAN/IT infrastructure renewal $0.2MM (2017) and $0.3MM (2019)\n \n2) Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_Exhibit_2_20140423.pdf, page: 447\nDetails: PwC recommended IT security improvements to mitigate risks, including: 1. Implementing risk mitigation controls and measures for the AS 400 (iSeries) platform. 2. Enhancing IT security and controls to protect confidential data.\n\nReference: HOBNI_Exhibit_2_20140423.pdf, page: 1153\nDetails: Hydro One Brampton outlined its IT Roadmap, which included a focus on IT security under the \"Technology Risk Mitigation\" program.  Key initiatives include maintaining platform currency for vendor support, establishing business continuity and redundancy, and implementing IT security controls to protect confidential data.\n \n3) PowerStream Inc. (EB-2015-0003)\nReference: PowerStream_APPL_Custom_IR_Part 3_20150522.pdf, page 341\nDetails: PowerStream proposed expenditures in 2016-2017 to strengthen the security systems of the Operations’ network and critical cyber assets. The application mentions compliance with the North American Electricity Reliability Council’s Critical Infrastructure Program (NERC-CIP) for protecting Operations’ Cyber Assets from cyber-attacks. The effort included implementing Electronic Security Perimeters (ESP) within Physical Security Perimeters (PSP).",0.5]
["Alectra Merger","IT system migration and integration","Data Centre Consolidation",1318743.82,219790.58666666667,"Horizon Utilities Corporation (EB-2014-0002)\nReference: Alectra_Undertaking Resp_Oral Hearing_20191023.pdf, page 148\nDetails: During Alectra's 2020 EDR application, it provided evidence of an annual spend of $0.40 MM for both \"Server Refresh\" and \"Network\" refresh projects at the newly amalgamated utility. Although this information was filed after the merger, for Server Refresh, it indicates that the costs are to support ongoing application support, an expense that would occur at legacy utilities irrespective of the merger. For Network Refresh projects, the reference indicates that the expense was for \"Replacement of existing network infrastructure that is unsupported (or soon to be) including further rationalization and design modifications to support the delivery of services throughout the Alectra Environment\".\n \nReference: Alectra_Undertaking Resp_Oral Hearing_20191023.pdf, page 192\nDetails: During Alectra's 2020 EDR application, it provided evidence of a spend of $0.10 MM for Wireless LAN upgrades at the newly amalgamated utility. Although this information was filed after the merger, it indicates that the costs are to \"replace end of life wireless infrastructure in corporate and operation center locations.\" These are replacements that would have been required at legacy utilities irrespective of the merger taking place.\n \nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 509, 512\nDetails: In project planning documents, Horizon included two projects for 2019 that relate to the consolidation of its Data Centers. The first is for \"Storage Area Network (SAN) Expansion\", described as \"a risk management and sustainment project to ensure adequate data storage capacity for Horizon Utilities at the production data centre in Hamilton and the disaster recovery data centre in St. Catharines.\" The project involves the expansion of the existing SAN in both the production and disaster recovery data centres. The second is for the 2019 IBM Capital Lease, which includes a three-year lease with planned renewals in 2016 and 2019. The environment includes a production IBM iSeries server in Hamilton and an identical IBM iSeries server at the Disaster Recovery Data Centre in St. Catharines.\n \nForecasted Post-Merger Expenses: Appendix G (Material Capital Project Templates), PDF Pages 509, 512: $300,000 (2019 SAN Expansion), $900,000 (2019 IBM Capital Lease) (Subtotal: 1.20 MM)",1.2]
["Alectra Merger","IT system migration and integration","IT Service Desk Consolidation",732812.82000000018,0,"1) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, pages 418 & 508:\nDetails: p. 418 Discusses the reduction of IST service desk effort through a standardized PC refresh cycle and the introduction of mobile computing for remote field workers. p. 508 Mentions the use of a three-year PC refresh cycle to reduce the IST service desk effort required to deploy, secure, and manage new systems and applications.\n\nForecasted Post-Merger Expenses: Appendix G (Material Capital Project Templates), PDF Pages 315, 416, 506: $323,000 (2017), $353,000 (2018), $361,000 (2019) (Subtotal: 1.04 MM)\n\nNo 2027 Opening NBV",1.04]
["Alectra Merger","IT system migration and integration","Front Office Systems and User Technology",2744454.2800000003,215636.72083333335,"Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_IRR_2015_20140813, p. 177\nDetails: 4-Staff-41 asked HOBNI to provide the forecast costs from 2015 through 2019 for what was described in evidence as \"increased costs due to the need to purchase additional hardware and software from vendors to support desktop virtualization. In HOBNI's response, it provided those costs and indicated that they were for \"The Company’s entire virtualized network, which includes all servers, storage area networks and virtual devices.\"\n \nForecasted Post-Merger Expenses: From HOBNI's response to 4-Staff-41, the legacy utility predicted total hardware/software costs under desktop virtualization to be $0.09 MM (2017), $0.09 MM (2018), and $0.10 MM (2019) (Subtotal: $0.28 MM).",0.28000000000000003]
["Alectra Merger","IT system migration and integration","Other IT System Migration and Integration Projects",1414503.1,163506.68791666668,"N/A (Note: Due to the 12+ years that have passed since pre-merger project planning, there has been considerable changes to company personelle and document storage practices, making it difficult to collect documentation from legacy utilities for planned post-merger expenses in this specific EDR category.)",0]
[null,"Subtotal - IT system migration and integration",null,13499002.139999999,{"$f":"SUBTOTAL(9,E9:E16)","v":1856977.0137500002},null,40.99]
["Alectra Merger","Non-IT system and service consolidation","Improvement of Cognos Budgeting Software",769144.48999999987,0,"No 2027 Opening NBV",0]
["Alectra Merger","Non-IT system and service consolidation","Implementation of New Alectra Network Operations Voice Radio System",6671483.6000000006,2612997.9000000004,"A unified voice radio system was required to support safe and compliant Network Operations, as Alectra inherited four disparate legacy radio platforms that could not be effectively bridged into a single operating environment. Maintaining the status quo was not viable, particularly because the former Enersource system was at end-of-life and increasingly exposed to reliability and supportability risk.\n\nA review of each legacy platform (hardware, licensing, and radio sites) confirmed that the systems operated on different frequency bands, used different architectures, and relied on different user equipment, limiting interoperability and increasing operational complexity. In addition, Hydro One Brampton and Enersource functioned as tenants on third-party networks and did not contribute owned sites or additional licensed spectrum that could support consolidation.",0]
["Alectra Merger","Non-IT system and service consolidation","Capital Investment Portfolio Management Project",920089.06,0,"No 2027 Opening NBV",0]
["Alectra Merger","Non-IT system and service consolidation","LPSS Convergence",1792801.45,433260.35041666665,"1) PowerStream Inc. (EB-2015-0003)\nReference: Section B, Tab 2, Schedule 2, page: 207:\nDetails: PowerStream added a new capital asset account for underground primary cable injection and LPSS. The LPSS system was identified as critical for managing energy data, wholesale settlement, and customer billing processes.\n \n2) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: Exhibit 4, Tab 1, Schedule 9, page: 697:\nDetails: The application elaborates on LPSS maintenance costs, noting that it is part of the interface solutions for CC&B (Customer Care and Billing) and JDE (JD Edwards Enterprise Resource Planning system). Middleware software was also used to ensure robust and secure interfaces for LPSS.\n\nThe LPSS Convergence project was undertaken to consolidate wholesale settlements and interval billing across all legacy companies into a single system environment, enabling integration of these functions and realizing operational synergies.",0]
["Alectra Merger","Non-IT system and service consolidation","Control Room Consolidation",864729.63000000012,616785.48722222226,"1) Hydro One Brampton Networks Inc. (EB-2014-0083)\nReference: HOBNI_Exhibit_4_20140423.pdf, page 69\nDetails: Hydro One Brampton noted increased control room expenditures due to overtime and succession planning. The 2013 increase was attributed to additional staff for planning and outage coordination.\n \n2) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: Enersource_Suggested Version of Redacted Tech Conf July 31 2012_20120816.pdf, page 94\nDetails: Enersource discussed OM&A costs related to control room operations, including adjustments for smart meter-related expenses and the impact of staffing changes.",0]
["Alectra Merger","Non-IT system and service consolidation","Other Non-IT Projects",1465899.1,183362.16091666667,"The Customer Connection Process project was implemented to standardize the methodology and technology used for customer connections across Alectra, enabling faster, more cost-effective processing, full cost recovery, and regulatory compliance (including timely billing-system enrolment), while supporting Alectra’s HR people strategy through more consistent ways of working.",0]
[null,"Subtotal - Non-IT system and service consolidation",null,12484147.33,{"$f":"SUBTOTAL(9,E18:E23)","v":3846405.8985555558},null,0]
["Alectra Merger","Facilities renovations","Derry Road Renovation",10775664.510000002,7799353.0411419757,"1) Enersource Hydro Mississauga Inc. (EB-2012-0033)\nReference: EX_K6.1_20120928.pdf, page 30\nDetails: The reply argument highlighted the Derry Road acquisition as the preferred option for addressing staff overcrowding and environmental issues at existing facilities. The document noted that the Derry Road facility was compared to other options and found to be the most cost-effective for ratepayers.\n\nReference: EX_K1.2_20120904.pdf, page 11\nDetails: Enersource provided details on the Derry Road facility acquisition, including the need for renovations to address aging infrastructure and deferred maintenance. The renovations were intended to prepare the facility for operational use and address environmental and congestion issues.\n\nForecasted Post-Merger Expenses: General Plant “Grounds & Buildings,” Table 69 pp. 360 - 365; $2.855MM (2017), $2.400MM (2018), $3.325MM (2019) (subtotal $8.58MM). Narrative pp. 370 - 372, 402 - 404: Derry windows $0.725MM (2019); Mavis generator $0.950MM (2020); Mavis South Tower $0.800MM (2021).",11.05]
["Alectra Merger","Facilities renovations","John Street Control Room Expansion",2609087.98,1827972.3793518515,"The project was implemented to consolidate four control rooms into two 24/7 centres in Vaughan and Hamilton (relocating Brampton and Mississauga), with necessary facility and technology upgrades, to achieve business-case synergies through lower costs, improved efficiency, harmonized operating practices, stronger backup and emergency coverage, and better workforce planning and regulatory communications.",0]
["Alectra Merger","Facilities renovations","Alectra Food Services and Cafeteria",1634976.81,1189664.6295370371,"1) Horizon Utilities Corporation (EB-2014-0002)\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 591\nDetails: Horizon Utilities discussed the need for a centralized lunchroom with food service provisions on one of the upper floors as part of its facility upgrades. This was part of a broader plan to improve employee amenities and consolidate departments for better operational efficiency.\n\nReference: Horizon_APPL_2015-19 Custom IR_Exhibit2_Part3_PUBLIC REDACTED_20140416.pdf, page 611\nDetails: Horizon Utilities proposed renovations to the fourth floor of its facility, which included plans for a corporate lunchroom/cafeteria, a multi-faith prayer room, and a sick room. These upgrades were aimed at improving employee facilities and creating a more accommodating work environment.",0]
["Alectra Merger","Facilities renovations","Other Fleet and Facilities Projects",1138411.57,596435.15972222225,"1) Horizon Utilities Corporation (EB-2014-0002)\n\nForecasted Post-Merger Expenses: Ex.2/Tab 1/Sched.1 Table 2-6 pp. 13 - 14; Building Renovations John & Hughson $2.200MM (2017), $1.200MM (2018); Stoney Creek $1.200MM (2019); scope detail Ex.2/Tab 6/Sched.1 pp. 184 - 185.\n \n2) Hydro One Brampton Networks Inc. (EB-2014-0083)\n\nForecasted Post-Merger Expenses: Appendix 2-AB (Capital Expenditure Summary) p. 135 of 298; Building Upgrades $0.856MM (2019), $0.955MM (2020).",6.41]
[null,"Subtotal - Facilities renovations",null,16158140.870000003,{"$f":"SUBTOTAL(9,E25:E28)","v":11413425.209753085},null,17.46]
["Subtotal - Alectra Merger IT",null,null,92835010.310000002,{"$f":"E3+E5+E8+E17","v":28059382.785583895},null,61.4]
["Subtotal - Alectra Merger Non-IT",null,null,28642288.200000003,{"$f":"E29+E24","v":15259831.108308641},null,17.46]
["Total - Alectra Merger",null,null,121477298.50999998,{"$f":"SUBTOTAL(9,E2:E28)","v":43319213.893892534},null,78.86]
["Alectra-Guelph Merger","CIS consolidation","CIS Integration",7254841.7699999996,4534276.0812499998,"Alectra assumed Guelph’s water billing contract through December 31, 2025 for ~60,000 customers with a converged electric/water bill. Because meeting Guelph’s unique water billing requirements would have required costly, temporary CC&B customization that would be written off and later decommissioned, water exit was treated as a prerequisite to CC&B migration. In the interim, Alectra continued operating Guelph’s end-of-life, highly customized legacy CIS while advancing electricity CIS integration in parallel, targeting completion in early 2026.",0]
[null,"Subtotal - CIS consolidation",null,7254841.7699999996,{"$f":"SUBTOTAL(9,E33)","v":4534276.0812499998},null,0]
["Alectra-Guelph Merger","ERP consolidation","ERP Integration",2857979.45,1269168.2393092106,"1) Guelph Hydro Electric Systems Inc. (EB-2015-0073)\nReference: \"Guelph_APPL_Exhibit_2_Rate Base_20150424.pdf, page 20\"\nDetails: Guelph Hydro considered replacing its current ERP system in 2011-2012. After discussions with the ERP software provider, it was determined that upgrading the existing system would be more prudent and cost-effective than replacing it. Investments were made in upgrading hardware (e.g., servers, backup systems, and phone systems) in 2013 and 2014, with capital additions of $415,592 in 2013 and $475,939 in 2014. Additional investments were made in software to address specific gaps in the ERP system, such as a document management system ($115,795 in 2013) and an electronic timekeeping system ($166,819 in 2014). A major ERP upgrade was planned for 2015, with projected capitalized software-related increases of $522,302. This upgrade had been in development for 12-18 months prior to 2015.\n \nThe project was implemented to migrate Guelph’s stand-alone ERP to Alectra’s JDE system, accelerating integration synergies by standardizing finance and HR processes (e.g., reporting, procurement, payroll, time entry, and leave) and reducing duplicate effort.",0]
[null,"Subtotal - ERP consolidation",null,2857979.45,{"$f":"SUBTOTAL(9,E35)","v":1269168.2393092106},null,0]
["Alectra-Guelph Merger","GIS/OMS consolidation","OMS Integration",745922,599662.78431372554,"N/A (Note: Due to the 12+ years that have passed since pre-merger project planning, there has been considerable changes to company personelle and document storage practices, making it difficult to collect documentation from legacy utilities for planned post-merger expenses in this specific EDR category.)",0]
["Alectra-Guelph Merger","GIS/OMS consolidation","GIS Integration",850000,0,"1) Guelph Hydro Electric Systems Inc. (EB-2015-0073)\nReference: Guelph_APPL_Exhibit_4_Operating Expenses_20150424.pdf, page 26:\nDetails: Guelph Hydro discusses its GIS system, which has been in use for over 14 years. The system is used to map and catalog distribution assets and integrate data with other corporate systems such as customer information, SCADA, electrical system planning programs, and outage notification systems. The document highlights the benefits of GIS, including real-time data access for personnel in the field and GPS tracking of vehicles and contract employees.\n\nNo 2027 Opening NBV",0]
[null,"Subtotal - GIS/OMS consolidation",null,1595922,{"$f":"SUBTOTAL(9,E37:E38)","v":599662.78431372554},null,0]
["Alectra-Guelph Merger","IT system migration and integration","SCADA Integration",1091280,397862.73697916663,"1) Guelph Hydro Electric Systems Inc. (EB-2015-0073)\nReference: \"Guelph_APPL_Exhibit_2_Rate Base_20150424.pdf, page 369\"\nDetails: Guelph Hydro's SCADA system includes hardware, software, and supporting communications infrastructure. It provides tools for System Control Operators (SCOs) to monitor and operate the electric distribution systems efficiently. The SCADA system manages over 200 field devices, including over 100 remotely operable distribution switches. These upgrades aim to improve customer service through better reliability and reduced response times during system disturbances.\n\nReference: \"Guelph_APPL_Exhibit_4_Operating Expenses_20150424.pdf, page 40\"\nDetails: Guelph Hydro has experienced significant growth in the SCADA network, including the number of customers, field dispatch call volumes, and SCADA field devices. To address the increased workload, Guelph Hydro planned to hire a second SCADA Technologist in 2015 to support the operation, maintenance, and expansion of SCADA technology.\n\nForecasted Post-Merger Expenses: DSP Appendix 2-AB pp. 653 - 654; SCADA infrastructure/CSW $1.067MM (2019 - 2020).",1.07]
["Alectra-Guelph Merger","IT system migration and integration","Data Center Consolidation",900000,885000,"1) Guelph Hydro Electric Systems Inc. (EB-2015-0073):\nReference: Guelph_APPL_Exhibit_4_Operating Expenses_20150424.pdf, page 36\nDetails: Guelph Hydro planned to move to a 24/7 control room operation, citing the need for enhanced responses, compliance with the Utility Work Protection Code, and increased customer counts. The 2016 Test Year included costs for hiring additional System Control Operators and a Control Room Supervisor.",0]
["Alectra-Guelph Merger","IT system migration and integration","Aux Systems Integration",730000,620500,"The project was implemented to enhance Alectra’s CC&B metering and field-service integrations to incorporate Guelph data flows, enabling the safe migration and ongoing operation of systems such as LPSS, MV90, SDS, MDM/R, Fieldworker, and New Connections, while providing secure historical data access and supporting the shutdown of Guelph CIS services.",0]
["Alectra-Guelph Merger","IT system migration and integration","AD & Client Computing and Other IT System Integration",1336926.3900000001,732237.59483333339,"Guelph Hydro Electric Systems Inc. (EB-2015-0073)\nReference: Guelph_APPL_Exhibit_2_Rate Base_20150424.pdf, page 793\nDetails: Guelph Hydro had been using Lotus Notes as the email service provider for the past 20 years. With recent changes to MS Exchange and SharePoint, there was a need to migrate email processes to Outlook and the hosted solutions from Microsoft for MS Office. The application did not contemplate software maintenance costs; however, it is reasonable to assume some ongoing costs beyond 2015 to maintain the new collaboration tools.",0]
[null,"Subtotal - IT system migration and integration",null,4058206.39,{"$f":"SUBTOTAL(9,E40:E43)","v":2635600.3318125},null,0]
["Alectra-Guelph Merger","Non-IT system and service consolidation","Single Platform Website and Network Integration",216297,171827.38333333336,"Guelph Hydro Electric Systems Inc. (EB-2015-0073)\nReference: Guelph_APPL_Exhibit_2_Rate Base_20150424.pdf, page 793\nDetails: The evidence describes the need to invest in the customer self-serve internet portal due to its importance as the primary source of customer account information. The application did not contemplate software maintenance costs; however, it is reasonable to assume some ongoing costs beyond 2016 to maintain the benefit provided by these investments.\n \nReference: Guelph_APPL_Exhibit_2_Rate Base_20150424.pdf, page 311\nDetails: \"Website analytics and tweets regarding GHESI during an outage highlight the fact that customers like being able to access detailed information about outages online or via social media. Building on this success and considering comments from customers who call the Call Centre, tweets received and the fact that 15 per cent of respondents to the Online Customer Survey as reported above would like better information about the cause of and estimated restoration times for outages, GHESI has plans to explore how best to enhance the company’s outage reporting. The project to upgrade the Web Portal will support this effort to the degree that technology and data availability with will allow in the short term and expand over time as new applications are developed.\"\n \nReference: Guelph_APPL_Exhibit_2_Rate Base_20150424.pdf, page 317\nDetails: \"Ongoing technological enhancements in the handling of data and communications systems are constantly changing the opportunities for enhancing customer experience of GHESI services via Internet and Mobile access. In 2016, GEHSI is undertaking an IT initiative to upgrade the Web Portal to provide the latest options to GHESI customers on demand.\"",0]
[null,"Subtotal - Non-IT system and service consolidation",null,216297,{"$f":"SUBTOTAL(9,E45:E45)","v":171827.38333333336},null,0]
["Subtotal - Alectra-Guelph Merger IT",null,null,15766949.609999999,{"$f":"E34+E36+E39+E44","v":9038707.4366854355},null,1.07]
["Subtotal - Alectra-Guelph Merger Non-IT",null,null,216297,{"$f":"E45","v":171827.38333333336},null,0]
["Total - Alectra-Guelph Merger",null,null,15983246.609999999,{"$f":"SUM(E47:E48)","v":9210534.8200187683},null,1.07]
[null,null,null,null,null,"Total Forecasted Post-Merger Expenses - Alectra Merger + Guelph Merger (IT & Non-IT)",79.930000000000007]
["Subtotal - IT",null,null,108601959.92,{"$f":"SUM(E30,E47)","v":37098090.222269326}]
["Subtotal - Non-IT",null,null,28858585.200000003,{"$f":"SUM(E31,E48)","v":15431658.491641974}]
["TOTAL CAPITAL TRANSITION PROJECTS",null,null,137460545.12,{"$f":"E51+E52","v":52529748.713911302}]
["Alectra Merger",null,"OMS Convergence",3242227,2215522]
["TOTAL CAPITAL TRANSITION PROJECTS - LESS OMS IMPAIRMENT",null,null,134218318.12,{"$f":"E53-E54","v":50314226.713911302}]

{"sheet":"1-Staff-39 (IT)","index":1,"n_rows":40,"n_cols":33,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,1,37,3],[35,1,35,3],[2,15,2,16],[2,17,2,32],[20,1,20,3],[2,4,2,11],[2,12,2,13]]}
[]
[null,"1-Staff-39 a) i & iii  -  Table - Capital Transition Project Expenditures - IT Related"]
[null,null,null,null,"Actual Expenditures",null,null,null,null,null,null,null,"Bridge",null,null,"Opening Net-Book-Value",null,"Additions Transferred to Fixed Assets"]
[null,"Mergers","2020 EDR Category","Project Name",2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total",2027,2029,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,"Total 2017-2031"]
[null,"Alectra Merger","CIS consolidation","CIS Consolidation",17547769,14904708.449999999,9149425.6500000004,17388.72,0,0,0,0,0,0,{"$f":"SUM(E5:N5)","v":41619291.82},9377304.1101587228,6252989.0180952325,null,31928507.780000001,9683091.2199999988,24868,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R5:AF5)","v":41636467}]
[null,null,"Subtotal - CIS consolidation",null,{"$f":"SUBTOTAL(9,E5)","v":17547769},14904708.449999999,9149425.6500000004,17388.72,0,0,0,0,0,0,41619291.82,9377304.1101587228,6252989.0180952325,0,31928507.780000001,9683091.2199999988,24868,0,0,0,0,0,0,0,0,0,0,0,41636467]
[null,"Alectra Merger","ERP consolidation","ERP Consolidation",2000692.7500000002,11213592.09,12461039.58,-163442.75999999998,0,0,0,0,0,0,{"$f":"SUM(E7:N7)","v":25511881.66},9154213.9233418349,6727216.8740051016,null,0,25669084.470000003,-157203.47000000253,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R7:AF7)","v":25511881}]
[null,null,"Subtotal - ERP consolidation",null,{"$f":"SUBTOTAL(9,E7)","v":2000692.7500000002},{"$f":"SUBTOTAL(9,F7)","v":11213592.09},12461039.58,-163442.75999999998,0,0,0,0,0,0,25511881.66,9154213.9233418349,6727216.8740051016,0,0,25669084.470000003,-157203.47000000253,0,0,0,0,0,0,0,0,0,0,0,25511881]
[null,"Alectra Merger","GIS/OMS consolidation","GIS Convergence",71978.5,410316.43,170368.72000000015,1881047.5,811705.04,0,0,0,0,0,{"$f":"SUM(E9:N9)","v":3345416.1900000004},1616951.4968333333,947868.11883333325,null,0,0,0,3345416.8899999997,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R9:AF9)","v":3345416.8899999997}]
[null,"Alectra Merger","GIS/OMS consolidation","OMS Convergence",44972,1308724.77,1171310.51,1579778.4100000001,1098512.81,1620532,2022366,13222,0,0,{"$f":"SUM(E10:N10)","v":8859418.5},6053936.2414999995,4282052.4635000005,null,0,0,0,0,0,8846196.8900000006,13222,0,0,0,0,0,0,0,{"$f":"SUM(R10:AF10)","v":8859418.8900000006}]
[null,null,"Subtotal - GIS/OMS consolidation",null,{"$f":"SUBTOTAL(9,E9:E10)","v":116950.5},{"$f":"SUBTOTAL(9,F9:F10)","v":1719041.2},1341679.2300000002,3460825.91,1910217.85,1620532,2022366,13222,0,0,12204834.690000001,7670887.7383333333,5229920.5823333338,0,0,0,0,3345416.8899999997,0,8846196.8900000006,13222,0,0,0,0,0,0,0,12204835.780000001]
[null,"Alectra Merger","IT system migration and integration","Phone System Consolidation",128943.87000000001,31609.62,514500.37,1053950.22,408640.32,-14427,0,0,0,0,2123217.4000000004,368057.76833333337,0,0,0,0,2123217.9199999999,0,0,0,0,0,0,0,0,0,0,0,2123217.9199999999]
[null,"Alectra Merger","IT system migration and integration","SCADA Consolidation",546200.35,2189631.75,369466.79999999993,-53920.63,0,0,0,0,0,0,{"$f":"SUM(E13:N13)","v":3051378.27},889985.25,279709.65000000002,null,0,3051378.22,0,0,0,-0.22000000020489097,0,0,0,0,0,0,0,0,{"$f":"SUM(R13:AF13)","v":3051378}]
[null,"Alectra Merger","IT system migration and integration","Data Backup & Archiving",3958.0099999999998,769037.70000000007,162073.37000000008,-48920.46,0,0,0,0,0,0,886148.62000000023,0,0,null,0,935069.08000000019,-48632.460000000079,0,0,0,0,0,0,0,0,0,0,0,886436.62000000011]
[null,"Alectra Merger","IT system migration and integration","IT Security Consolidation",316265.7,204573.89,653082.67000000004,47476.299999999996,6345.27,0,0,0,0,0,1227743.83,0,0,null,0,1173922.2600000002,47476.299999999814,6345.3700000001118,0,0,0,0,0,0,0,0,0,0,1227743.9300000002]
[null,"Alectra Merger","IT system migration and integration","Data Centre Consolidation",60965.5,3072.37,45442.530000000006,68908.840000000011,317904.58,820752,1698,0,0,0,1318743.82,219790.58666666667,0,null,0,0,0,0,1317045.52,1698,0,0,0,0,0,0,0,0,1318743.52]
[null,"Alectra Merger","IT system migration and integration","IT Service Desk Consolidation",0,295324.21000000002,437236.68000000005,251.93000000000407,0,0,0,0,0,0,732812.82000000018,0,0,null,0,0,732812.82000000018,0,0,0,null,0,0,0,0,0,0,0,732812.82000000018]
[null,"Alectra Merger","IT system migration and integration","Front Office Systems and User Technology",346584.57,926741.73,1335935.8499999999,84337.62,50854.51,0,0,0,0,0,2744454.2800000003,215636.72083333335,67771.540833333347,0,75059.94,2531796.2800000003,19317.409999999829,117992.18,0,0,0,0,0,0,0,0,0,0,2744165.8100000005]
[null,"Alectra Merger","IT system migration and integration","Other IT System Migration and Integration Projects",711870.62,511957.55000000005,165057.42999999996,25617.5,0,0,0,0,0,0,1414503.1,163506.68791666668,87886.701916666672,293211.97000000003,184320.66999999998,903145.58000000007,16649.179999999986,0,0,0,0,0,0,0,0,0,0,0,1397327.4]
[null,null,"Subtotal - IT system migration and integration",null,{"$f":"SUBTOTAL(9,E12:E19)","v":2114788.62},{"$f":"SUBTOTAL(9,F12:F19)","v":4931948.82},3682795.6999999997,1177701.3199999998,783744.68,806325,1698,0,0,0,13499002.139999999,1856977.0137500002,435367.89275,293211.97000000003,259380.61,8595311.4200000018,2890841.17,124337.5500000001,1317045.52,1697.7799999997951,0,0,0,0,0,0,0,0,13481826.020000001]
[null,"Subtotal - Alectra Merger IT",null,null,{"$f":"E6+E8+E11+E20","v":21780200.870000001},32769290.559999999,26634940.16,4492473.1899999995,2693962.5300000003,2426857,2024064,13222,0,0,92835010.310000002,28059382.785583895,18645494.367183667,293211.97000000003,32187888.390000001,43947487.109999999,2758505.6999999974,3469754.44,1317045.52,8847894.6699999999,13222,0,0,0,0,0,0,0,92835009.799999997]
[null,"Alectra-Guelph Merger","CIS consolidation","CIS Integration",0,0,40340.94,688647,521684,13549.5,0,698783.33,4759632,532205,{"$f":"SUM(E22:N22)","v":7254841.7699999996},4534276.0812499998,0,null,0,0,0,0,0,0,0,0,7254841.7300000004,0,0,0,0,0,{"$f":"SUM(R22:AF22)","v":7254841.7300000004}]
[null,null,"Subtotal - CIS consolidation",null,{"$f":"SUBTOTAL(9,E22)","v":0},{"$f":"SUBTOTAL(9,F22)","v":0},40340.94,688647,521684,13549.5,0,698783.33,4759632,532205,7254841.7699999996,4534276.0812499998,0,0,0,0,0,0,0,0,0,0,7254841.7300000004,0,0,0,0,0,7254841.7300000004]
[null,"Alectra-Guelph Merger","ERP consolidation","ERP Integration",0,0,0,0,549798,2308181.4500000002,0,0,0,0,{"$f":"SUM(E24:N24)","v":2857979.45},1269168.2393092106,930723.3754934211,null,0,0,0,549797.85000000009,2308181,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R24:AF24)","v":2857978.85}]
[null,null,"Subtotal - ERP consolidation",null,{"$f":"SUBTOTAL(9,E24)","v":0},{"$f":"SUBTOTAL(9,F24)","v":0},0,0,549798,2308181.4500000002,0,0,0,0,2857979.45,1269168.2393092106,930723.3754934211,0,0,0,0,549797.85000000009,2308181,0,0,0,0,0,0,0,0,0,2857978.85]
[null,"Alectra-Guelph Merger","GIS/OMS consolidation","OMS Integration",0,0,0,0,0,0,0,695922,50000,0,{"$f":"SUM(E26:N26)","v":745922},599662.78431372554,424151.72549019608,null,0,0,0,0,0,0,0,745922,0,0,0,0,0,0,{"$f":"SUM(R26:AF26)","v":745922}]
[null,"Alectra-Guelph Merger","GIS/OMS consolidation","GIS Integration",0,0,0,0,0,0,0,0,650000,200000,{"$f":"SUM(E27:N27)","v":850000},null,498275.86206896551,null,0,0,0,0,0,0,0,0,0,850000,0,0,0,0,{"$f":"SUM(R27:AF27)","v":850000}]
[null,null,"Subtotal - GIS/OMS consolidation",null,{"$f":"SUBTOTAL(9,E26:E27)","v":0},{"$f":"SUBTOTAL(9,F26:F27)","v":0},0,0,0,0,0,695922,700000,200000,1595922,599662.78431372554,922427.58755916159,0,0,0,0,0,0,0,0,745922,0,850000,0,0,0,0,1595922]
[null,"Alectra-Guelph Merger","IT system migration and integration","SCADA Integration",0,0,0,652041,439239,0,0,0,0,0,{"$f":"SUM(E29:N29)","v":1091280},397862.73697916663,125042.57447916665,null,0,0,0,1091280.6499999999,0,0,0,0,0,0,0,0,0,0,1091280.6499999999]
[null,"Alectra-Guelph Merger","IT system migration and integration","Data Center Consolidation",0,0,0,0,0,0,0,0,0,900000,{"$f":"SUM(E30:N30)","v":900000},885000,525000,null,0,0,0,0,0,0,0,0,900000,0,0,0,0,0,{"$f":"SUM(R30:AF30)","v":900000}]
[null,"Alectra-Guelph Merger","IT system migration and integration","Aux Systems Integration",0,0,0,0,0,0,0,0,630000,100000,{"$f":"SUM(E31:N31)","v":730000},620500,328500,null,0,0,0,0,0,0,0,0,730000,0,0,0,0,0,{"$f":"SUM(R31:AF31)","v":730000}]
[null,"Alectra-Guelph Merger","IT system migration and integration","AD & Client Computing and Other IT System Integration",0,0,94352.390000000014,323063,-20884.629999999997,682167.05,21232,236996.58,0,0,1336926.3900000001,732237.59483333339,385635.91200000001,0,0,0,129054.24,93195.66,0,589498.56000000006,235331,0,289848,0,0,0,0,0,1336927.46]
[null,null,"Subtotal - IT system migration and integration",null,{"$f":"SUBTOTAL(9,E29:E32)","v":0},{"$f":"SUBTOTAL(9,F29:F32)","v":0},94352.390000000014,975104,418354.37,682167.05,21232,236996.58,630000,1000000,4058206.39,2635600.3318125,1364178.4864791667,0,0,0,129054.24,1184476.3099999998,0,589498.56000000006,235331,0,1919848,0,0,0,0,0,4058208.11]
[null,"Subtotal - Alectra-Guelph Merger IT",null,null,{"$f":"E23+E25+E28+E33","v":0},0,134693.33000000002,1663751,1489836.37,3003898,21232,1631701.9100000001,6089632,1732205,15766949.609999999,9038707.4366854355,3217329.4495317494,0,0,0,129054.24,1734274.16,2308181,589498.56000000006,235331,745922,9174689.7300000004,850000,0,0,0,0,15766950.689999999]
[]
[null,"Subtotal - IT",null,null,{"$f":"SUM(E21,E34)","v":21780200.870000001},32769290.559999999,26769633.489999998,6156224.1899999995,4183798.9000000004,5430755,2045296,1644923.9100000001,6089632,1732205,108601959.92,37098090.222269326,21862823.816715416,293211.97000000003,32187888.390000001,43947487.109999999,2887559.9399999976,5204028.5999999996,3625226.52,9437393.2300000004,248553,745922,9174689.7300000004,850000,0,0,0,0,{"$f":"SUM(R36:AF36)","v":108601960.48999999}]
[null,"Alectra Merger",null,"OMS Convergence",null,null,null,null,null,null,null,null,null,null,3242227,2215522,1567076.3833333333,null,null,null,null,null,null,3242227,null,null,null,null,null,null,null,null,3242227]
[null,"TOTAL CAPITAL TRANSITION PROJECTS - LESS OMS IMPAIRMENT",null,null,{"$f":"E36-E37","v":21780200.870000001},{"$f":"F36-F37","v":32769290.559999999},26769633.489999998,6156224.1899999995,4183798.9000000004,5430755,2045296,1644923.9100000001,6089632,1732205,105359732.92,34882568.222269326,20295747.433382083,293211.97000000003,32187888.390000001,43947487.109999999,2887559.9399999976,5204028.5999999996,3625226.52,6195166.2300000004,248553,745922,9174689.7300000004,850000,0,0,0,0,105359733.48999999]
[]
[null,"Note: A $114,846 adjustment between IT and Facilities renovations changed the total from $108.7M to $108.6M."]

{"sheet":"1-Staff-41 (Non-IT)","index":2,"n_rows":24,"n_cols":33,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,17,2,32],[2,4,2,11],[2,12,2,13],[21,1,21,3],[16,1,16,3],[19,1,19,3],[2,15,2,16]]}
[]
[null,"1-Staff-41 a) i & iii  -  Table - Capital Transition Project Expenditures - Non-IT Related"]
[null,null,null,null,"Actual Expenditures",null,null,null,null,null,null,null,"Bridge",null,null,"Opening Net-Book-Value",null,"Additions Transferred to Fixed Assets"]
[null,"Mergers","2020 EDR Category","Project Name",2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total",2027,2029,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,"Total 2017-2031"]
[null,"Alectra Merger","Non-IT system and service consolidation","Improvement of Cognos Budgeting Software",267493.75,128378.75,188681.61000000002,134943.78999999998,49646.59,0,0,0,0,0,{"$f":"SUM(E5:N5)","v":769144.48999999987},0,0,0,0,0,0,769144.69,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R5:AF5)","v":769144.69}]
[null,"Alectra Merger","Non-IT system and service consolidation","Implementation of New Alectra Network Operations Voice Radio System",0,49000,947090.45,4866630.1100000003,783557.04,24430,776,0,0,0,6671483.6000000006,2612997.9000000004,1278701.1000000001,0,0,0,5862720.9600000009,783557.04,24430,776,0,0,0,0,0,0,0,0,6671484.0000000009]
[null,"Alectra Merger","Non-IT system and service consolidation","Capital Investment Portfolio Management Project",150000,770089.06,0,0,0,0,0,0,0,0,920089.06,0,0,0,920089.06,0,0,0,0,0,0,0,0,0,0,0,0,0,920089.06]
[null,"Alectra Merger","Non-IT system and service consolidation","LPSS Convergence",215914.33000000002,1201135.98,375751.13999999996,0,0,0,0,0,0,0,1792801.45,433260.35041666665,74700.06041666666,0,0,1792801.45,0,0,0,0,0,0,0,0,0,0,0,0,1792801.45]
[null,"Alectra Merger","Non-IT system and service consolidation","Control Room Consolidation",0,841495.28,23096.920000000042,137.43,0,0,0,0,0,0,864729.63000000012,616785.48722222226,552731.4701851852,0,841495.28,23096.920000000042,137.02999999999884,0,0,0,0,0,0,0,0,0,0,0,864729.2300000001]
[null,"Alectra Merger","Non-IT system and service consolidation","Other Non-IT Projects",118302.5,210866.73000000004,805231.17,271283.88999999996,60214.810000000012,0,0,0,0,0,1465899.1,183362.16091666667,93552.122916666674,0,79600,0,936321.46,449977.19,0,0,0,0,0,0,0,0,0,0,1465898.65]
[null,null,"Subtotal - Non-IT system and service consolidation",null,{"$f":"SUBTOTAL(9,E5:E10)","v":751710.58000000007},{"$f":"SUBTOTAL(9,F5:F10)","v":3200965.8000000003},2339851.29,5272995.22,893418.44000000006,24430,776,0,0,0,12484147.33,3846405.8985555558,1999684.7535185185,0,1841184.34,1815898.37,6799179.4500000011,2002678.92,24430,776,0,0,0,0,0,0,0,0,12484147.080000002]
[null,"Alectra Merger","Facilities renovations","Derry Road Renovation",1758391,3505185.45,3067011.87,38375.49,2373091.7000000002,33609,0,0,0,0,10775664.510000002,7799353.0411419757,7001155.6396604944,0,5263576.8600000003,3067011.8700000006,38375.490000000224,217.63999999966472,2406483.06,0,0,0,0,0,0,0,0,0,10775664.920000002]
[null,"Alectra Merger","Facilities renovations","John Street Control Room Expansion",0,2492668.4500000002,116419.53,0,0,0,0,0,0,0,2609087.98,1827972.3793518515,1634706.5771296294,0,2492668.7999999998,116419.5299999998,0,0,0,0,0,0,0,0,0,0,0,0,2609088.3299999996]
[null,"Alectra Merger","Facilities renovations","Alectra Food Services and Cafeteria",197400,150508.5,1232495.0900000001,59052.89,-4479.67,0,0,0,0,0,1634976.81,1189664.6295370371,1068555.2147222222,0,312246.29000000004,1268157.5900000001,59052.889999999898,-4479.6699999999255,0,0,0,0,0,0,0,0,0,0,1634977.1]
[null,"Alectra Merger","Facilities renovations","Other Fleet and Facilities Projects",609213.22000000009,0,529198.35,0,0,0,0,0,0,0,1138411.57,596435.15972222225,533923.8819444445,609213.22000000009,0,529198.35,0,0,0,0,0,0,0,0,0,0,0,0,1138411.57]
[null,null,"Subtotal - Facilities renovations",null,{"$f":"SUBTOTAL(9,E12:E15)","v":2565004.2200000002},{"$f":"SUBTOTAL(9,F12:F15)","v":6148362.4000000004},4945124.84,97428.38,2368612.0300000003,33609,0,0,0,0,16158140.870000003,11413425.209753085,10238341.313456791,609213.22000000009,8068491.9500000002,4980787.34,97428.380000000121,-4262.0300000002608,2406483.06,0,0,0,0,0,0,0,0,0,16158141.920000002]
[null,"Subtotal - Alectra Merger Non-IT",null,null,{"$f":"E16+E11","v":3316714.8000000003},9349328.2000000011,7284976.1299999999,5370423.5999999996,3262030.47,58039,776,0,0,0,28642288.200000003,15259831.108308641,12238026.066975309,609213.22000000009,9909676.290000001,6796685.71,6896607.830000001,1998416.8899999997,2430913.06,776,0,0,0,0,0,0,0,0,28642289.000000004]
[null,"Alectra-Guelph Merger","Non-IT system and service consolidation","Single Platform Website and Network Integration",0,0,0,0,0,0,15432,865,0,200000,216297,171827.38333333336,86666.666666666672,0,0,0,0,0,0,15432,865,0,200000,0,0,0,0,0,216297]
[null,null,"Subtotal - Non-IT system and service consolidation",null,{"$f":"SUBTOTAL(9,E18:E18)","v":0},0,0,0,0,0,15432,865,0,200000,216297,171827.38333333336,86666.666666666672,0,0,0,0,0,0,15432,865,0,200000,0,0,0,0,0,216297]
[null,"Subtotal - Alectra-Guelph Merger Non-IT",null,null,{"$f":"E18","v":0},0,0,0,0,0,15432,865,0,200000,216297,171827.38333333336,86666.666666666672,0,0,0,0,0,0,15432,865,0,200000,0,0,0,0,0,216297]
[]
[null,"Subtotal - Non-IT",null,null,{"$f":"SUM(E17,E20)","v":3316714.8000000003},9349328.2000000011,7284976.1299999999,5370423.5999999996,3262030.47,58039,16208,865,0,200000,28858585.200000003,15431658.491641974,12324692.733641975,609213.22000000009,9909676.290000001,6796685.71,6896607.830000001,1998416.8899999997,2430913.06,16208,865,0,200000,0,0,0,0,0,{"$f":"SUM(R22:AF22)","v":28858586.000000004}]
[]
[null,"Note: A $114,846 adjustment between IT and Facilities renovations the $28.8M total unchanged due to rounding."]