{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["2018","2019","2020","2021","2022","2023"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":90,"defined_names":608,"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":"2018","index":0,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[7,0,7,1],[7,2,9,2],[7,3,9,3],[7,4,8,4],[7,5,8,5],[8,0,9,0],[8,1,9,1],[23,0,23,5],[25,0,25,1],[25,2,27,2],[25,3,27,3],[25,4,26,4],[25,5,26,5],[26,0,27,0],[26,1,27,1]]}
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2018]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$ x 1000"]
["HONI","Other","Supply Chain Services","Cost of services",276,276]
["HONI","Other","Lease of IT Assets","Shared Asset Allocation",768.35346782881584,768.35346782881584]
["HONI","Other","Utility Operation Services","Cost of services",1545.5134799999998,1545.5134799999998]
["HONI","Other","Network Operations","Cost of services",1176.7057399999999,1176.7057399999999]
["HONI","Other","Managing Director","Cost of services",120,120]
["Other","HONI","Meter and Lines and Training Work","Cost of services",404.04296999999997,404.04296999999997]
["Other","HONI","Business and Power System Operations","Cost of services",19585,19585]
[]
[]
[]
[]
[]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$ x 1000"]
["HOI","HONI","Chief Financial Office Services","CCC Allocation Model",0.25237652376634145,1176.3194034554392]
["HOI","HONI","General Counsel","CCC Allocation Model",0.31749213578342672,932.51460999999983]
["HOI","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0.22638884381176505,4926.1551131627311]
["HOL","HONI","Chief Financial Office Services","CCC Allocation Model",0,0]
["HOL","HONI","General Counsel","CCC Allocation Model",0,0]
["HOL","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0,0]
["HONI","Other","Corporate Services","CCC Allocation Model",8.0842170675019271E-3,1521.7796418802652]
["HONI","Other","Financial Services","CCC Allocation Model",6.8001629414977505E-2,2217.520700751696]
["HONI","Other","General Counsel","CCC Allocation Model",6.7393423057613699E-2,2038.5192176853561]
["HONI","Other","Other Services","CCC Allocation Model",1.7256584406191159E-2,1525.7260000000001]
["HONI","Other","Telecommunication Services","CCC Allocation Model",2.2318981098615853E-2,403.61799999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HOL\"","Hydro One Limited"]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Other\"","Other unregulated subsidiaries and affiliates, including:"]
[null,null,"Hydro One Inc."]
[null,null,"Hydro One Limited"]
[null,null,"Hydro One Networks Inc.'s non-regulated segment"]
[null,null,"Hydro One Remote Communities Inc."]
[null,null,"Hydro One Telecom Inc."]
[null,null,"B2M Limited Partnership "]
[null,null,"Niagara Reinforcement Limited Partnership"]
[null,null,"Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]

{"sheet":"2019","index":1,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[23,0,23,5],[25,0,25,1],[25,2,27,2],[25,3,27,3],[25,4,26,4],[25,5,26,5],[26,0,27,0],[26,1,27,1],[0,0,0,5],[1,0,1,5],[5,0,5,5],[7,0,7,1],[7,2,9,2],[7,3,9,3],[7,4,8,4],[7,5,8,5],[8,0,9,0],[8,1,9,1]]}
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2019]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$ x 1000"]
["HONI","Other","Supply Chain Services","Cost of services",276,276]
["HONI","Other","Lease of IT Assets","Shared Asset Allocation",768.35347000000002,768.35347000000002]
["HONI","Other","Utility Operation Services","Cost of services",1865.4675299999999,1865.4675299999999]
["HONI","Other","Network Operations","Cost of services",1333.06017,1333.06017]
["HONI","Other","Managing Director","Cost of services",160,160]
["Other","HONI","Meter and Lines and Training Work","Cost of services",295.36477000000002,295.36477000000002]
["Other","HONI","Business and Power System Operations","Cost of services",17247,17247]
[]
[]
[]
[]
[]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$ x 1000"]
["HOI","HONI","Chief Financial Office Services","CCC Allocation Model",2.713870004434326E-2,192.99916319907987]
["HOI","HONI","General Counsel","CCC Allocation Model",9.5919537553743273E-2,405.02028952527735]
["HOI","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0.32678190509685978,3650.3189472756439]
["HOL","HONI","Chief Financial Office Services","CCC Allocation Model",0,0]
["HOL","HONI","General Counsel","CCC Allocation Model",0,0]
["HOL","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0,0]
["HONI","Other","Corporate Services","CCC Allocation Model",4.3512213251745015E-2,7419.0226009105709]
["HONI","Other","Financial Services","CCC Allocation Model",6.9710035564845091E-2,1943.7566571482666]
["HONI","Other","General Counsel","CCC Allocation Model",6.3211352755804348E-2,1848.3908329094629]
["HONI","Other","Other Services","CCC Allocation Model",1.9058819603700351E-2,1747.5025540540003]
["HONI","Other","Telecommunication Services","CCC Allocation Model",2.1887515790863021E-2,405.4595374800341]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HOL\"","Hydro One Limited"]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Other\"","Other unregulated subsidiaries and affiliates, including:"]
[null,null,"Hydro One Inc."]
[null,null,"Hydro One Limited"]
[null,null,"Hydro One Networks Inc.'s non-regulated segment"]
[null,null,"Hydro One Remote Communities Inc."]
[null,null,"Hydro One Telecom Inc."]
[null,null,"B2M Limited Partnership "]
[null,null,"Niagara Reinforcement Limited Partnership"]
[null,null,"Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]

{"sheet":"2020","index":2,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[7,0,7,1],[7,2,9,2],[7,3,9,3],[7,4,8,4],[7,5,8,5],[8,0,9,0],[8,1,9,1],[23,0,23,5],[25,0,25,1],[25,2,27,2],[25,3,27,3],[25,4,26,4],[25,5,26,5],[26,0,27,0],[26,1,27,1]]}
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2020]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$ x 1000"]
["HONI","Other","Supply Chain Services","Cost of services",276,276]
["HONI","Other","Lease of IT Assets","Shared Asset Allocation",768.35347000000002,768.35347000000002]
["HONI","Other","Utility Operation Services","Cost of services",1573.7825500000001,1573.7825500000001]
["HONI","Other","Managing Director","Cost of services",240,240]
["Other","HONI","Meter and Lines and Training Work","Cost of services",159.99812,159.99812]
["Other","HONI","Business and Power System Operations","Cost of services",17977,17977]
[]
[]
[]
[]
[]
[]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$ x 1000"]
["HOI","HONI","Chief Financial Office Services","CCC Allocation Model",7.6197375652286944E-2,192.37547773458863]
["HOI","HONI","General Counsel","CCC Allocation Model",0.20624973699544227,422.55653291637208]
["HOI","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0.29530041320284101,2558.8362693490394]
["HOL","HONI","Chief Financial Office Services","CCC Allocation Model",0,0]
["HOL","HONI","General Counsel","CCC Allocation Model",0,0]
["HOL","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0,0]
["HONI","Other","Corporate Services","CCC Allocation Model",3.475653497863726E-2,5797.3418563181658]
["HONI","Other","Financial Services","CCC Allocation Model",9.0383763015495194E-2,2216.0512203283965]
["HONI","Other","General Counsel","CCC Allocation Model",6.1778731409511276E-2,1987.1555447341591]
["HONI","Other","Other Services","CCC Allocation Model",1.9808465786844597E-2,1802.9901422549767]
["HONI","Other","Telecommunication Services","CCC Allocation Model",2.389223270225186E-2,436.69737299654048]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HOL\"","Hydro One Limited"]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Other\"","Other unregulated subsidiaries and affiliates, including:"]
[null,null,"Hydro One Inc."]
[null,null,"Hydro One Limited"]
[null,null,"Hydro One Networks Inc.'s non-regulated segment"]
[null,null,"Hydro One Remote Communities Inc."]
[null,null,"Hydro One Telecom Inc."]
[null,null,"B2M Limited Partnership "]
[null,null,"Niagara Reinforcement Limited Partnership"]
[null,null,"Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]

{"sheet":"2021","index":3,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[7,0,7,1],[7,2,9,2],[7,3,9,3],[7,4,8,4],[7,5,8,5],[8,0,9,0],[8,1,9,1],[23,0,23,5],[25,0,25,1],[25,2,27,2],[25,3,27,3],[25,4,26,4],[25,5,26,5],[26,0,27,0],[26,1,27,1]]}
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2021]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$ x 1000"]
["HONI","Other","Supply Chain Services","Cost of services",276,276]
["HONI","Other","Lease of IT Assets","Shared Asset Allocation",768.35346782881572,768.35346782881572]
["HONI","Other","Utility Operation Services","Cost of services",1155.9097963464289,1155.9097963464289]
["HONI","Other","Managing Director","Cost of services",224.39999999999998,224.39999999999998]
["Other","HONI","Meter and Lines and Training Work","Cost of services",363,363]
["Other","HONI","Business and Power System Operations","Cost of services",18964,18964]
[]
[]
[]
[]
[]
[]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$ x 1000"]
["HOI","HONI","Chief Financial Office Services","CCC Allocation Model",0.10172862517321768,232.76592241059203]
["HOI","HONI","General Counsel","CCC Allocation Model",0.58456589337998077,317.36112178232696]
["HOI","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0.38081957127344379,2997.8734192655656]
["HOL","HONI","Chief Financial Office Services","CCC Allocation Model",0,0]
["HOL","HONI","General Counsel","CCC Allocation Model",0,0]
["HOL","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0,0]
["HONI","Other","Corporate Services","CCC Allocation Model",5.7339317086516337E-2,10922.02035062641]
["HONI","Other","Financial Services","CCC Allocation Model",9.4901921304113915E-2,2622.266919755049]
["HONI","Other","General Counsel","CCC Allocation Model",4.8978286720233508E-2,1509.4447035405337]
["HONI","Other","Other Services","CCC Allocation Model",1.2230264063007604E-2,1105.2113350782543]
["HONI","Other","Telecommunication Services","CCC Allocation Model",2.5165110808700375E-2,435.43760265779866]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HOL\"","Hydro One Limited"]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Other\"","Other unregulated subsidiaries and affiliates, including:"]
[null,null,"Hydro One Inc."]
[null,null,"Hydro One Limited"]
[null,null,"Hydro One Networks Inc.'s non-regulated segment"]
[null,null,"Hydro One Remote Communities Inc."]
[null,null,"Hydro One Telecom Inc."]
[null,null,"B2M Limited Partnership "]
[null,null,"Niagara Reinforcement Limited Partnership"]
[null,null,"Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]

{"sheet":"2022","index":4,"n_rows":88,"n_cols":6,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[7,0,7,1],[7,2,9,2],[7,3,9,3],[7,4,8,4],[7,5,8,5],[8,0,9,0],[8,1,9,1],[21,0,21,5],[23,0,23,1],[23,2,25,2],[23,3,25,3],[23,4,24,4],[23,5,24,5],[24,0,25,0],[24,1,25,1]]}
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2022]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$ x 1000"]
["HONI","Other","Supply Chain Services","Cost of services",276,276]
["HONI","Other","Lease of IT Assets","Shared Asset Allocation",768.35346782881572,768.35346782881572]
["HONI","Other","Utility Operation Services","Cost of services",1456.6981063871237,1456.6981063871237]
["HONI","Other","Managing Director","Cost of services",228.88800000000001,228.88800000000001]
["Other","HONI","Meter and Lines and Training Work","Cost of services",363,363]
["Other","HONI","Business and Power System Operations","Cost of services",20440,20440]
[]
[]
[]
[]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$ x 1000"]
["HOI","HONI","Chief Financial Office Services","CCC Allocation Model",9.8290811333373279E-2,237.66083672224428]
["HOI","HONI","General Counsel","CCC Allocation Model",0.58385508068568748,327.86510037806153]
["HOI","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0.36981388053522302,3047.4866162772887]
["HOL","HONI","Chief Financial Office Services","CCC Allocation Model",0,0]
["HOL","HONI","General Counsel","CCC Allocation Model",0,0]
["HOL","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0,0]
["HONI","Other","Corporate Services","CCC Allocation Model",5.7760225227205378E-2,11723.308547162294]
["HONI","Other","Financial Services","CCC Allocation Model",9.6040091085176721E-2,2824.8950727115907]
["HONI","Other","General Counsel","CCC Allocation Model",4.9817333853520773E-2,1643.3254813536964]
["HONI","Other","Other Services","CCC Allocation Model",1.2205989580843521E-2,1057.2979767611771]
["HONI","Other","Telecommunication Services","CCC Allocation Model",2.5165110808700514E-2,433.92235093974324]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HOL\"","Hydro One Limited"]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Other\"","Other unregulated subsidiaries and affiliates, including:"]
[null,null,"Hydro One Inc."]
[null,null,"Hydro One Limited"]
[null,null,"Hydro One Networks Inc.'s non-regulated segment"]
[null,null,"Hydro One Remote Communities Inc."]
[null,null,"Hydro One Telecom Inc."]
[null,null,"B2M Limited Partnership "]
[null,null,"Niagara Reinforcement Limited Partnership"]
[null,null,"Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]

{"sheet":"2023","index":5,"n_rows":88,"n_cols":6,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[7,0,7,1],[7,2,9,2],[7,3,9,3],[7,4,8,4],[7,5,8,5],[8,0,9,0],[8,1,9,1],[21,0,21,5],[23,0,23,1],[23,2,25,2],[23,3,25,3],[23,4,24,4],[23,5,24,5],[24,0,25,0],[24,1,25,1]]}
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2023]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$ x 1000"]
["HONI","Other","Supply Chain Services","Cost of services",276,276]
["HONI","Other","Lease of IT Assets","Shared Asset Allocation",2077.0403755191551,2077.0403755191551]
["HONI","Other","Utility Operation Services","Cost of services",1474.2908455192362,1474.2908455192362]
["HONI","Other","Managing Director","Cost of services",233.46600000000001,233.46600000000001]
["Other","HONI","Meter and Lines and Training Work","Cost of services",363,363]
["Other","HONI","Business and Power System Operations","Cost of services",22033,22033]
[]
[]
[]
[]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$ x 1000"]
["HOI","HONI","Chief Financial Office Services","CCC Allocation Model",0.12255975651340836,310.25599739659521]
["HOI","HONI","General Counsel","CCC Allocation Model",0.58351514178541952,334.28544082483535]
["HOI","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0.36223458938284203,3102.1568608884777]
["HOL","HONI","Chief Financial Office Services","CCC Allocation Model",0,0]
["HOL","HONI","General Counsel","CCC Allocation Model",0,0]
["HOL","HONI","President/CEO/Chairman/Board/Ombudsman","CCC Allocation Model",0,0]
["HONI","Other","Corporate Services","CCC Allocation Model",5.8359291829931326E-2,12389.356486402572]
["HONI","Other","Financial Services","CCC Allocation Model",9.5409683655982236E-2,2895.5892424879521]
["HONI","Other","General Counsel","CCC Allocation Model",5.0207795484871323E-2,1575.9393207068406]
["HONI","Other","Other Services","CCC Allocation Model",1.1583175190493466E-2,1024.5577678769082]
["HONI","Other","Telecommunication Services","CCC Allocation Model",2.5165110808700469E-2,439.9755666936673]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HOL\"","Hydro One Limited"]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Other\"","Other unregulated subsidiaries and affiliates, including:"]
[null,null,"Hydro One Inc."]
[null,null,"Hydro One Limited"]
[null,null,"Hydro One Networks Inc.'s non-regulated segment"]
[null,null,"Hydro One Remote Communities Inc."]
[null,null,"Hydro One Telecom Inc."]
[null,null,"B2M Limited Partnership "]
[null,null,"Niagara Reinforcement Limited Partnership"]
[null,null,"Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]