{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["2014","2015","2016","2017","2018"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"2014","index":0,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[91,2,91,3],[89,2,89,5],[85,2,85,3],[87,2,87,3],[88,2,88,3],[90,2,90,3],[8,6,9,6],[9,0,10,0],[9,1,10,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],[84,2,84,3],[1,0,1,5],[2,0,2,5],[6,0,6,5],[8,0,8,1],[8,2,10,2],[8,3,10,3],[8,4,9,4],[8,5,9,5]]}
[]
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2014]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$"]
["HOI","All subs","General Counsel & Secretary (including Corporate Exec Office)","CCC Allocation Model",793.2784289606883,793.2784289606883]
["HOI","All subs","President/CEO/Chairman/Board","CCC Allocation Model",3518.5062277674224,3518.5062277674224]
["HOI","All subs","Chief Financial Office Services (Including Strategic Financial Services)","CCC Allocation Model",968.49543837337353,968.49543837337353]
["HONI","All subs and HOI","General Counsel & Secretary","CCC Allocation Model",32330.627157844312,32330.627157844312]
["HONI","All subs and HOI","Financial Services","CCC Allocation Model",38056.156204335399,38056.156204335399]
["HONI","All subs and HOI","Corporate Services","CCC Allocation Model",188081.31269138039,188081.31269138039]
["HONI","All subs and HOI","Telecommunication Services","CCC Allocation Model",18460.312117627454,18460.312117627454]
["HONI","All subs and HOI","Other Services","CCC Allocation Model",124297.5730485364,124297.5730485364]
["Remotes Services","HONI","Metering and Lines Services","CCC Allocation Model",0,0]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$"]
["HOI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.4257607478942162,347]
[{"$f":"A27","v":"HOI"},{"$f":"B27","v":"HONI Dx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.33015198166280846,1594]
[{"$f":"A28","v":"HOI"},{"$f":"B28","v":"HONI Dx"},"Chief Financial Office Services","CCC Allocation Model",0.57895408753125743,426]
["HOI","HONI Tx",{"$f":"C27","v":"General Counsel & Secretary"},"CCC Allocation Model",0.49201746370484345,401]
["HOI",{"$f":"B30","v":"HONI Tx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.38151816199679622,1842]
["HOI",{"$f":"B31","v":"HONI Tx"},"Chief Financial Office Services","CCC Allocation Model",0.66865119968398745,492]
["HOI","Telecom","General Counsel & Secretary","CCC Allocation Model",1.01010101010101E-2,8.2324416292160496]
["HOI",{"$f":"B33","v":"Telecom"},"President/CEO/Chairman /Board","CCC Allocation Model",5.8305237647196112E-3,28.150232005740556]
["HOI",{"$f":"B34","v":"Telecom"},"Chief Financial Office Services","CCC Allocation Model",2.2679571897986292E-2,16.687847683639578]
["HOI","Remotes","General Counsel & Secretary","CCC Allocation Model",2.5252525252525249E-2,20.581104073040123]
["HOI",{"$f":"B36","v":"Remotes"},"President/CEO/Chairman /Board","CCC Allocation Model",3.9071513830307393E-3,18.864037323609924]
["HOI",{"$f":"B37","v":"Remotes"},"Chief Financial Office Services","CCC Allocation Model",1.1235304991538589E-2,8.2670457458978248]
["HOI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B39","v":"B2M "},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B40","v":"B2M "},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B42","v":"Hydro One SSM"},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B43","v":"Hydro One SSM"},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Brampton","General Counsel & Secretary","CCC Allocation Model",2.02020202020202E-2,16.464883258432099]
["HOI",{"$f":"B45","v":"Brampton"},"President/CEO/Chairman /Board","CCC Allocation Model",7.3511545868402937E-3,35.491958438071762]
["HOI",{"$f":"B46","v":"Brampton"},"Chief Financial Office Services","CCC Allocation Model",3.4710804913168372E-2,25.540544943836146]
["HONI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.52050250311215185,16813,null,null,null,{"$f":"E48+E53+E58+E63+E68+E73+E78","v":0.97106186193701804}]
[{"$f":"A48","v":"HONI"},{"$f":"B48","v":"HONI Dx"},"Financial Services","CCC Allocation Model",0.41147192399950927,11760,null,null,null,{"$f":"E49+E54+E59+E64+E69+E74+E79","v":0.99805260153036279}]
[{"$f":"A49","v":"HONI"},"HONI Dx","Corporate Services","CCC Allocation Model",0.48332868851029709,79832,null,null,null,1]
["HONI","HONI Dx","Telecommunication Services","CCC Allocation Model",0.47527328750569797,8317,null,null,null,0.99999999999999989]
["HONI","HONI Dx","Other Services","CCC Allocation Model",0.7039214024659175,90781,null,null,null,0.99999999999999989]
["HONI","HONI Tx","General Counsel & Secretary","CCC Allocation Model",0.43351824949465551,14871]
[{"$f":"A53","v":"HONI"},{"$f":"B53","v":"HONI Tx"},"Financial Services","CCC Allocation Model",0.56275618982676801,25415]
[{"$f":"A54","v":"HONI"},"HONI Tx","Corporate Services","CCC Allocation Model",0.51329984696586106,107610]
["HONI","HONI Tx","Telecommunication Services","CCC Allocation Model",0.50136361725620671,9746]
["HONI","HONI Tx","Other Services","CCC Allocation Model",0.28534717620307998,32070]
["HONI","Telecom","General Counsel & Secretary","CCC Allocation Model",3.1241933885326964E-3,101.22606095161198]
[{"$f":"A58","v":"HONI"},{"$f":"B58","v":"Telecom"},"Financial Services","CCC Allocation Model",1.439134180647518E-2,413.80907027567486]
[{"$f":"A59","v":"HONI"},"Telecom","Corporate Services","CCC Allocation Model",1.2946293212023115E-3,308.19894098905382]
["HONI","Telecom","Telecommunication Services","CCC Allocation Model",1.5625E-2,271.98547649664846]
["HONI","Telecom","Other Services","CCC Allocation Model",8.4337249387008741E-3,1085.597962362647]
["HONI","Remotes","General Counsel & Secretary","CCC Allocation Model",1.1730860944396591E-2,342.9489749894741]
[{"$f":"A63","v":"HONI"},{"$f":"B63","v":"Remotes"},"Financial Services","CCC Allocation Model",6.6469759029001976E-3,210.93805347178852]
[{"$f":"A64","v":"HONI"},"Remotes","Corporate Services","CCC Allocation Model",1.2845487821325626E-3,297.41433863236512]
["HONI","Remotes","Telecommunication Services","CCC Allocation Model",7.7380952380952375E-3,125.3266411308086]
["HONI","Remotes","Other Services","CCC Allocation Model",2.2976963923016457E-3,359.13864592292242]
["HONI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0]
[{"$f":"A68","v":"HONI"},{"$f":"B68","v":"B2M "},"Financial Services","CCC Allocation Model",0,0]
[{"$f":"A69","v":"HONI"},"B2M ","Corporate Services","CCC Allocation Model",0,0]
["HONI","B2M ","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","B2M ","Other Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",2.186054997281472E-3,0]
[{"$f":"A73","v":"HONI"},{"$f":"B73","v":"Hydro One SSM"},"Financial Services","CCC Allocation Model",2.7861699947101123E-3,0]
[{"$f":"A74","v":"HONI"},"Hydro One SSM","Corporate Services","CCC Allocation Model",7.922864205069652E-4,0]
["HONI","Hydro One SSM","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Other Services","CCC Allocation Model",0,0]
["HONI","Brampton","General Counsel & Secretary","CCC Allocation Model",0,202.45212190322397]
[{"$f":"A78","v":"HONI"},{"$f":"B78","v":"Brampton"},"Financial Services","CCC Allocation Model",0,256.40908058793531]
[{"$f":"A79","v":"HONI"},"Brampton","Corporate Services","CCC Allocation Model",0,33.699411758939981]
["HONI","Brampton","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Brampton","Other Services","CCC Allocation Model",0,1.8364402508274906]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Brampton\"","Hydro One Brampton Networks Inc."]
[null,"\"B2M\"","B2M Limited Partnership "]
[null,"\"Telecom\"","Hydro One Telecom Inc."]
[null,"\"Hydro One SSM\"","Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]
[null,"\"Remotes\"","Hydro One Remote Communities Inc."]
[null,"\"HONI Dx\"","Hydro One Distribution"]
[null,"\"HONI Tx\"","HONI's transmission business"]

{"sheet":"2015","index":1,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[91,2,91,3],[85,2,85,3],[87,2,87,3],[88,2,88,3],[89,2,89,5],[90,2,90,3],[8,6,9,6],[9,0,10,0],[9,1,10,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],[84,2,84,3],[1,0,1,5],[2,0,2,5],[6,0,6,5],[8,0,8,1],[8,2,10,2],[8,3,10,3],[8,4,9,4],[8,5,9,5]]}
[]
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2015]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$"]
["HOI","All subs","General Counsel & Secretary (including Corporate Exec Office)","CCC Allocation Model",1909.5661685709013,1909.5661685709013]
["HOI","All subs","President/CEO/Chairman/Board","CCC Allocation Model",2505.8341535473601,2505.8341535473601]
["HOI","All subs","Chief Financial Office Services (Including Strategic Financial Services)","CCC Allocation Model",939.58104622026906,939.58104622026906]
["HONI","All subs and HOI","General Counsel & Secretary","CCC Allocation Model",33395.745846669932,33395.745846669932]
["HONI","All subs and HOI","Financial Services","CCC Allocation Model",41103.287787162801,41103.287787162801]
["HONI","All subs and HOI","Corporate Services","CCC Allocation Model",189686.57838082491,189686.57838082491]
["HONI","All subs and HOI","Telecommunication Services","CCC Allocation Model",17295.183204922618,17295.183204922618]
["HONI","All subs and HOI","Other Services","CCC Allocation Model",122420.08879570349,122420.08879570349]
["Remotes Services","HONI","Metering and Lines Services","CCC Allocation Model",148,148]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$"]
["HOI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.73352013251430903,852]
[{"$f":"A27","v":"HOI"},{"$f":"B27","v":"HONI Dx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.15858753723178917,1107]
[{"$f":"A28","v":"HOI"},{"$f":"B28","v":"HONI Dx"},"Chief Financial Office Services","CCC Allocation Model",0.34945548912352331,402]
["HOI","HONI Tx",{"$f":"C27","v":"General Counsel & Secretary"},"CCC Allocation Model",0.86180006179204616,1001]
["HOI",{"$f":"B30","v":"HONI Tx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.18637975242868809,1301]
["HOI",{"$f":"B31","v":"HONI Tx"},"Chief Financial Office Services","CCC Allocation Model",0.41117523969011571,473]
["HOI","Telecom","General Counsel & Secretary","CCC Allocation Model",1.0101010101010104E-2,11.732548603078358]
["HOI",{"$f":"B33","v":"Telecom"},"President/CEO/Chairman /Board","CCC Allocation Model",5.9114771955695337E-3,41.264309729022742]
["HOI",{"$f":"B34","v":"Telecom"},"Chief Financial Office Services","CCC Allocation Model",2.2585592904802936E-2,25.981587441945859]
["HOI","Remotes","General Counsel & Secretary","CCC Allocation Model",2.4242424242424249E-2,28.158116647388059]
["HOI",{"$f":"B36","v":"Remotes"},"President/CEO/Chairman /Board","CCC Allocation Model",2.9865974759063409E-3,20.847561312438319]
["HOI",{"$f":"B37","v":"Remotes"},"Chief Financial Office Services","CCC Allocation Model",1.1260685152239413E-2,12.953854130475946]
["HOI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B39","v":"B2M "},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B40","v":"B2M "},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B42","v":"Hydro One SSM"},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B43","v":"Hydro One SSM"},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Brampton","General Counsel & Secretary","CCC Allocation Model",1.4356593198765413E-2,16.675503320434796]
["HOI",{"$f":"B45","v":"Brampton"},"President/CEO/Chairman /Board","CCC Allocation Model",5.117532797568841E-3,35.72228250589874]
["HOI",{"$f":"B46","v":"Brampton"},"Chief Financial Office Services","CCC Allocation Model",2.2293525661895429E-2,25.645604647847247]
["HONI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.52050250311215185,17250,null,null,null,{"$f":"E48+E53+E58+E63+E68+E73+E78","v":0.96887580693973663}]
[{"$f":"A48","v":"HONI"},{"$f":"B48","v":"HONI Dx"},"Financial Services","CCC Allocation Model",0.41147192399950927,14566,null,null,null,{"$f":"E49+E54+E59+E64+E69+E74+E79","v":0.99526643153565264}]
[{"$f":"A49","v":"HONI"},"HONI Dx","Corporate Services","CCC Allocation Model",0.48332868851029709,84359,null,null,null,0.99920771357949301]
["HONI","HONI Dx","Telecommunication Services","CCC Allocation Model",0.47527328750569797,7768,null,null,null,0.99999999999999989]
["HONI","HONI Dx","Other Services","CCC Allocation Model",0.7039214024659175,87586,null,null,null,0.99999999999999989]
["HONI","HONI Tx","General Counsel & Secretary","CCC Allocation Model",0.43351824949465551,15461]
[{"$f":"A53","v":"HONI"},{"$f":"B53","v":"HONI Tx"},"Financial Services","CCC Allocation Model",0.56275618982676801,25496]
[{"$f":"A54","v":"HONI"},"HONI Tx","Corporate Services","CCC Allocation Model",0.51329984696586106,104754]
["HONI","HONI Tx","Telecommunication Services","CCC Allocation Model",0.50136361725620671,9102]
["HONI","HONI Tx","Other Services","CCC Allocation Model",0.28534717620307998,33607]
["HONI","Telecom","General Counsel & Secretary","CCC Allocation Model",3.1241933885326964E-3,101.92674600924616]
[{"$f":"A58","v":"HONI"},{"$f":"B58","v":"Telecom"},"Financial Services","CCC Allocation Model",1.439134180647518E-2,535.74260544102617]
[{"$f":"A59","v":"HONI"},"Telecom","Corporate Services","CCC Allocation Model",1.2946293212023115E-3,270.79344736511354]
["HONI","Telecom","Telecommunication Services","CCC Allocation Model",1.5625E-2,284.35819437500004]
["HONI","Telecom","Other Services","CCC Allocation Model",8.4337249387008741E-3,964.35775459000979]
["HONI","Remotes","General Counsel & Secretary","CCC Allocation Model",1.1730860944396591E-2,382.71910066068665]
[{"$f":"A63","v":"HONI"},{"$f":"B63","v":"Remotes"},"Financial Services","CCC Allocation Model",6.6469759029001976E-3,247.4451817217778]
[{"$f":"A64","v":"HONI"},"Remotes","Corporate Services","CCC Allocation Model",1.2845487821325626E-3,268.68493345978891]
["HONI","Remotes","Telecommunication Services","CCC Allocation Model",7.7380952380952375E-3,140.82501054761906]
["HONI","Remotes","Other Services","CCC Allocation Model",2.2976963923016457E-3,262.73104111347766]
["HONI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0.1]
[{"$f":"A68","v":"HONI"},{"$f":"B68","v":"B2M "},"Financial Services","CCC Allocation Model",0,0.1]
[{"$f":"A69","v":"HONI"},"B2M ","Corporate Services","CCC Allocation Model",0,0.1]
["HONI","B2M ","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","B2M ","Other Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",0,0]
[{"$f":"A73","v":"HONI"},{"$f":"B73","v":"Hydro One SSM"},"Financial Services","CCC Allocation Model",0,0]
[{"$f":"A74","v":"HONI"},"Hydro One SSM","Corporate Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Other Services","CCC Allocation Model",0,0]
["HONI","Brampton","General Counsel & Secretary","CCC Allocation Model",0,200]
[{"$f":"A78","v":"HONI"},{"$f":"B78","v":"Brampton"},"Financial Services","CCC Allocation Model",0,258]
[{"$f":"A79","v":"HONI"},"Brampton","Corporate Services","CCC Allocation Model",0,34]
["HONI","Brampton","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Brampton","Other Services","CCC Allocation Model",0,0]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Brampton\"","Hydro One Brampton Networks Inc."]
[null,"\"B2M\"","B2M Limited Partnership "]
[null,"\"Telecom\"","Hydro One Telecom Inc."]
[null,"\"Hydro One SSM\"","Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]
[null,"\"Remotes\"","Hydro One Remote Communities Inc."]
[null,"\"HONI Dx\"","Hydro One Distribution"]
[null,"\"HONI Tx\"","HONI's transmission business"]

{"sheet":"2016","index":2,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[[91,2,91,3],[85,2,85,3],[87,2,87,3],[88,2,88,3],[89,2,89,5],[90,2,90,3],[8,6,9,6],[9,0,10,0],[9,1,10,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],[84,2,84,3],[1,0,1,5],[2,0,2,5],[6,0,6,5],[8,0,8,1],[8,2,10,2],[8,3,10,3],[8,4,9,4],[8,5,9,5]]}
[]
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2016]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$"]
["HOI","All subs","General Counsel & Secretary (including Corporate Exec Office)","CCC Allocation Model",772.69779420383554,772.69779420383554]
["HOI","All subs","President/CEO/Chairman/Board","CCC Allocation Model",5486.0025815590516,5486.0025815590516]
["HOI","All subs","Chief Financial Office Services (Including Strategic Financial Services)","CCC Allocation Model",1278.5767769681697,1278.5767769681697]
["HONI","All subs and HOI","General Counsel & Secretary","CCC Allocation Model",33693.745846669932,33693.745846669932]
["HONI","All subs and HOI","Financial Services","CCC Allocation Model",40060.287787162801,40060.287787162801]
["HONI","All subs and HOI","Corporate Services","CCC Allocation Model",205914.57838082491,205914.57838082491]
["HONI","All subs and HOI","Telecommunication Services","CCC Allocation Model",425.1832049226191,425.1832049226191]
["HONI","All subs and HOI","Other Services","CCC Allocation Model",1227.0887957034874,1227.0887957034874]
["Remotes Services","HONI","Metering and Lines Services","CCC Allocation Model",148,148]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$"]
["HOI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.19801599821395666,230]
[{"$f":"A27","v":"HOI"},{"$f":"B27","v":"HONI Dx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.38407695331384534,2681]
[{"$f":"A28","v":"HOI"},{"$f":"B28","v":"HONI Dx"},"Chief Financial Office Services","CCC Allocation Model",0.79366383475068847,913]
["HOI","HONI Tx",{"$f":"C27","v":"General Counsel & Secretary"},"CCC Allocation Model",0.41841641361731713,486]
["HOI",{"$f":"B30","v":"HONI Tx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.38780168318559466,2707]
["HOI",{"$f":"B31","v":"HONI Tx"},"Chief Financial Office Services","CCC Allocation Model",0.26165697071189181,301]
["HOI","Telecom","General Counsel & Secretary","CCC Allocation Model",1.0101010101010104E-2,11.732548603078358]
["HOI",{"$f":"B33","v":"Telecom"},"President/CEO/Chairman /Board","CCC Allocation Model",5.9114771955695337E-3,41.264309729022742]
["HOI",{"$f":"B34","v":"Telecom"},"Chief Financial Office Services","CCC Allocation Model",2.2585592904802936E-2,25.981587441945859]
["HOI","Remotes","General Counsel & Secretary","CCC Allocation Model",2.4242424242424249E-2,28.158116647388059]
["HOI",{"$f":"B36","v":"Remotes"},"President/CEO/Chairman /Board","CCC Allocation Model",2.9865974759063409E-3,20.847561312438319]
["HOI",{"$f":"B37","v":"Remotes"},"Chief Financial Office Services","CCC Allocation Model",1.1260685152239413E-2,12.953854130475946]
["HOI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B39","v":"B2M "},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B40","v":"B2M "},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B42","v":"Hydro One SSM"},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B43","v":"Hydro One SSM"},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Brampton","General Counsel & Secretary","CCC Allocation Model",1.4469914855704693E-2,16.807128953369123]
["HOI",{"$f":"B45","v":"Brampton"},"President/CEO/Chairman /Board","CCC Allocation Model",5.1416615993529263E-3,35.890710517590115]
["HOI",{"$f":"B46","v":"Brampton"},"Chief Financial Office Services","CCC Allocation Model",2.2289814434083184E-2,25.641335395748033]
["HONI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.52050250311215185,17511,null,null,null,{"$f":"E48+E53+E58+E63+E68+E73+E78","v":0.96887580693973663}]
[{"$f":"A48","v":"HONI"},{"$f":"B48","v":"HONI Dx"},"Financial Services","CCC Allocation Model",0.41147192399950927,12701,null,null,null,{"$f":"E49+E54+E59+E64+E69+E74+E79","v":0.99526643153565264}]
[{"$f":"A49","v":"HONI"},"HONI Dx","Corporate Services","CCC Allocation Model",0.48332868851029709,91073,null,null,null,0.99920771357949301]
["HONI","HONI Dx","Telecommunication Services","CCC Allocation Model",0.47527328750569797,null,null,null,null,0.99999999999999989]
["HONI","HONI Dx","Other Services","CCC Allocation Model",0.7039214024659175,null,null,null,null,0.99999999999999989]
["HONI","HONI Tx","General Counsel & Secretary","CCC Allocation Model",0.43351824949465551,15698]
[{"$f":"A53","v":"HONI"},{"$f":"B53","v":"HONI Tx"},"Financial Services","CCC Allocation Model",0.56275618982676801,26576]
[{"$f":"A54","v":"HONI"},"HONI Tx","Corporate Services","CCC Allocation Model",0.51329984696586106,114302]
["HONI","HONI Tx","Telecommunication Services","CCC Allocation Model",0.50136361725620671]
["HONI","HONI Tx","Other Services","CCC Allocation Model",0.28534717620307998]
["HONI","Telecom","General Counsel & Secretary","CCC Allocation Model",3.1241933885326964E-3,101.92674600924616]
[{"$f":"A58","v":"HONI"},{"$f":"B58","v":"Telecom"},"Financial Services","CCC Allocation Model",1.439134180647518E-2,535.74260544102617]
[{"$f":"A59","v":"HONI"},"Telecom","Corporate Services","CCC Allocation Model",1.2946293212023115E-3,270.79344736511354]
["HONI","Telecom","Telecommunication Services","CCC Allocation Model",1.5625E-2,284.35819437500004]
["HONI","Telecom","Other Services","CCC Allocation Model",8.4337249387008741E-3,964.35775459000979]
["HONI","Remotes","General Counsel & Secretary","CCC Allocation Model",1.1730860944396591E-2,382.71910066068665]
[{"$f":"A63","v":"HONI"},{"$f":"B63","v":"Remotes"},"Financial Services","CCC Allocation Model",6.6469759029001976E-3,247.4451817217778]
[{"$f":"A64","v":"HONI"},"Remotes","Corporate Services","CCC Allocation Model",1.2845487821325626E-3,268.68493345978891]
["HONI","Remotes","Telecommunication Services","CCC Allocation Model",7.7380952380952375E-3,140.82501054761906]
["HONI","Remotes","Other Services","CCC Allocation Model",2.2976963923016457E-3,262.73104111347766]
["HONI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0.1]
[{"$f":"A68","v":"HONI"},{"$f":"B68","v":"B2M "},"Financial Services","CCC Allocation Model",0,0.1]
[{"$f":"A69","v":"HONI"},"B2M ","Corporate Services","CCC Allocation Model",0,0.1]
["HONI","B2M ","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","B2M ","Other Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",0,0]
[{"$f":"A73","v":"HONI"},{"$f":"B73","v":"Hydro One SSM"},"Financial Services","CCC Allocation Model",0,0]
[{"$f":"A74","v":"HONI"},"Hydro One SSM","Corporate Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Other Services","CCC Allocation Model",0,0]
["HONI","Brampton","General Counsel & Secretary","CCC Allocation Model",0,0]
[{"$f":"A78","v":"HONI"},{"$f":"B78","v":"Brampton"},"Financial Services","CCC Allocation Model",0,0]
[{"$f":"A79","v":"HONI"},"Brampton","Corporate Services","CCC Allocation Model",0,0]
["HONI","Brampton","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Brampton","Other Services","CCC Allocation Model",0,0]
[]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Brampton\"","Hydro One Brampton Networks Inc."]
[null,"\"B2M\"","B2M Limited Partnership "]
[null,"\"Telecom\"","Hydro One Telecom Inc."]
[null,"\"Hydro One SSM\"","Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]
[null,"\"Remotes\"","Hydro One Remote Communities Inc."]
[null,"\"HONI Dx\"","Hydro One Distribution"]
[null,"\"HONI Tx\"","HONI's transmission business"]

{"sheet":"2017","index":3,"n_rows":99,"n_cols":10,"rows_kept":99,"cut":false,"hidden":false,"merged":[[96,2,96,3],[97,2,97,3],[90,2,90,3],[91,2,91,3],[93,2,93,3],[94,2,94,3],[95,2,95,5],[2,0,2,5],[3,0,3,5],[7,0,7,5],[9,0,9,1],[9,2,11,2],[9,3,11,3],[9,4,10,4],[9,5,10,5],[89,1,89,5],[9,6,10,6],[10,0,11,0],[10,1,11,1],[22,0,22,5],[24,0,24,1],[24,2,26,2],[24,3,26,3],[24,4,25,4],[24,5,25,5],[25,0,26,0],[25,1,26,1]]}
[]
[]
["Appendix 2-N"]
["Shared Services and Corporate Cost Allocation"]
[]
[null,"Year:",2017]
[]
["Shared Services"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","Price for the Service","Cost for the Service"]
["From","To"]
[null,null,null,null,"$","$"]
["HOI","All subs","General Counsel & Secretary (including Corporate Exec Office)","CCC Allocation Model",1161.5223117047572,1161.5223117047572]
["HOI","All subs","President/CEO/Chairman/Board","CCC Allocation Model",6980.3719719918809,6980.3719719918809]
["HOI","All subs","Chief Financial Office Services (Including Strategic Financial Services)","CCC Allocation Model",1150.3610975127754,1150.3610975127754]
["HONI","All subs and HOI","General Counsel & Secretary","CCC Allocation Model",32624.979741448376,32624.979741448376]
["HONI","All subs and HOI","Financial Services","CCC Allocation Model",37226.730672186277,37226.730672186277]
["HONI","All subs and HOI","Corporate Services","CCC Allocation Model",209166.78073815745,209166.78073815745]
["HONI","All subs and HOI","Telecommunication Services","CCC Allocation Model",18198.924439999999,18198.924439999999]
["HONI","All subs and HOI","Other Services","CCC Allocation Model",114345.41221100801,114345.41221100801]
["Remotes Services","HONI","Metering and Lines Services","CCC Allocation Model",148,148]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$"]
["HOI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.4236067434283427,496.99867058647743]
[{"$f":"A28","v":"HOI"},{"$f":"B28","v":"HONI Dx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.50839604730400678,3986.6379361430522]
[{"$f":"A29","v":"HOI"},{"$f":"B29","v":"HONI Dx"},"Chief Financial Office Services","CCC Allocation Model",0.24264508840494486,543.90692139622593]
["HOI","HONI Tx",{"$f":"C28","v":"General Counsel & Secretary"},"CCC Allocation Model",0.52881347169959791,620.43297586781341]
["HOI",{"$f":"B31","v":"HONI Tx"},{"$f":"C29","v":"President/CEO/Chairman /Board"},"CCC Allocation Model",0.36939177389807465,2896.6221648073683]
["HOI",{"$f":"B32","v":"HONI Tx"},{"$f":"C30","v":"Chief Financial Office Services"},"CCC Allocation Model",0.23388508902410859,524.27073454412721]
["HOI","Telecom",{"$f":"C31","v":"General Counsel & Secretary"},"CCC Allocation Model",0.01,11.732548603078358]
[{"$f":"A34","v":"HOI"},{"$f":"B34","v":"Telecom"},{"$f":"C32","v":"President/CEO/Chairman /Board"},"CCC Allocation Model",5.2622315587704423E-3,41.264309729022742]
["HOI",{"$f":"B35","v":"Telecom"},{"$f":"C33","v":"Chief Financial Office Services"},"CCC Allocation Model",1.1590778373565119E-2,25.981587441945859]
["HOI","Remotes",{"$f":"C34","v":"General Counsel & Secretary"},"CCC Allocation Model",2.4E-2,28.158116647388059]
[{"$f":"A37","v":"HOI"},{"$f":"B37","v":"Remotes"},{"$f":"C35","v":"President/CEO/Chairman /Board"},"CCC Allocation Model",2.6585854890613914E-3,20.847561312438319]
["HOI",{"$f":"B38","v":"Remotes"},{"$f":"C36","v":"Chief Financial Office Services"},"CCC Allocation Model",5.7789098778251108E-3,12.953854130475946]
["HOI","B2M ",{"$f":"C37","v":"General Counsel & Secretary"},"CCC Allocation Model",0,0]
["HOI",{"$f":"B40","v":"B2M "},{"$f":"C38","v":"President/CEO/Chairman /Board"},"CCC Allocation Model",0,0]
["HOI",{"$f":"B41","v":"B2M "},{"$f":"C39","v":"Chief Financial Office Services"},"CCC Allocation Model",0,0]
[{"$f":"A42","v":"HOI"},"Hydro One SSM",{"$f":"C40","v":"General Counsel & Secretary"},"CCC Allocation Model",3.579784872059268E-3,4.2]
["HOI",{"$f":"B43","v":"Hydro One SSM"},{"$f":"C41","v":"President/CEO/Chairman /Board"},"CCC Allocation Model",4.4633753906569307E-3,35]
["HOI",{"$f":"B44","v":"Hydro One SSM"},{"$f":"C42","v":"Chief Financial Office Services"},"CCC Allocation Model",1.9293585667927982E-2,43.247999999999998]
[{"$f":"A45","v":"HOI"},"Brampton","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B46","v":"Brampton"},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B47","v":"Brampton"},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HONI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.52050250311215174,16981.383619407123,null,null,null,{"$f":"E49+E54+E59+E64+E69+E74+E79","v":0.97106186193701771}]
[{"$f":"A49","v":"HONI"},{"$f":"B49","v":"HONI Dx"},"Financial Services","CCC Allocation Model",0.41147192399950916,15317.754493896029,null,null,null,{"$f":"E50+E55+E60+E65+E70+E75+E80","v":0.99805260153036268}]
[{"$f":"A50","v":"HONI"},{"$f":"B50","v":"HONI Dx"},"Corporate Services","CCC Allocation Model",0.48332868851029709,101096.30581409451,null,null,null,1]
["HONI","HONI Dx","Telecommunication Services","CCC Allocation Model",0.47527328750569803,8649.4626476665944,null,null,null,1]
["HONI","HONI Dx","Other Services","CCC Allocation Model",0.7039214024659175,80490.182929116199,null,null,null,0.99999999999999989]
["HONI","HONI Tx","General Counsel & Secretary","CCC Allocation Model",0.43351518435865249,14143.424107311295]
[{"$f":"A54","v":"HONI"},{"$f":"B54","v":"HONI Tx"},"Financial Services","CCC Allocation Model",0.56275350358496823,20949.473112786825]
[{"$f":"A55","v":"HONI"},{"$f":"B55","v":"HONI Tx"},"Corporate Services","CCC Allocation Model",0.51329936887847238,107365.17654323803]
["HONI","HONI Tx","Telecommunication Services","CCC Allocation Model",0.50136361725620682,9124.2785874107867]
["HONI","HONI Tx","Other Services","CCC Allocation Model",0.28534717620307998,32628.140486188317]
["HONI","Telecom","General Counsel & Secretary","CCC Allocation Model",3.124193388532696E-3,101.92674600924616]
[{"$f":"A59","v":"HONI"},{"$f":"B59","v":"Telecom"},"Financial Services","CCC Allocation Model",1.4391341806475179E-2,535.74260544102617]
[{"$f":"A60","v":"HONI"},{"$f":"B60","v":"Telecom"},"Corporate Services","CCC Allocation Model",1.2946293212023115E-3,270.79344736511354]
["HONI","Telecom","Telecommunication Services","CCC Allocation Model",1.5625000000000003E-2,284.35819437500004]
["HONI","Telecom","Other Services","CCC Allocation Model",8.4337249387008758E-3,964.35775459000979]
["HONI","Remotes","General Counsel & Secretary","CCC Allocation Model",1.1730860944396588E-2,382.71910066068665]
[{"$f":"A64","v":"HONI"},{"$f":"B64","v":"Remotes"},"Financial Services","CCC Allocation Model",6.6469759029001959E-3,247.4451817217778]
[{"$f":"A65","v":"HONI"},{"$f":"B65","v":"Remotes"},"Corporate Services","CCC Allocation Model",1.2845487821325626E-3,268.68493345978891]
["HONI","Remotes","Telecommunication Services","CCC Allocation Model",7.7380952380952392E-3,140.82501054761906]
["HONI","Remotes","Other Services","CCC Allocation Model",2.2976963923016457E-3,262.73104111347766]
["HONI","B2M ","General Counsel & Secretary","CCC Allocation Model",3.0651360029184967E-6,0.1]
[{"$f":"A69","v":"HONI"},{"$f":"B69","v":"B2M "},"Financial Services","CCC Allocation Model",2.6862417997590744E-6,0.1]
[{"$f":"A70","v":"HONI"},{"$f":"B70","v":"B2M "},"Corporate Services","CCC Allocation Model",4.7808738867183521E-7,0.1]
["HONI","B2M ","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","B2M ","Other Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",2.1860549972814716E-3,71.319999999999993]
[{"$f":"A74","v":"HONI"},{"$f":"B74","v":"Hydro One SSM"},"Financial Services","CCC Allocation Model",2.7861699947101118E-3,103.72]
[{"$f":"A75","v":"HONI"},{"$f":"B75","v":"Hydro One SSM"},"Corporate Services","CCC Allocation Model",7.922864205069652E-4,165.72]
["HONI","Hydro One SSM","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Other Services","CCC Allocation Model",0,0]
["HONI","Brampton","General Counsel & Secretary","CCC Allocation Model",0,0]
[{"$f":"A79","v":"HONI"},{"$f":"B79","v":"Brampton"},"Financial Services","CCC Allocation Model",0,0]
[{"$f":"A80","v":"HONI"},{"$f":"B80","v":"Brampton"},"Corporate Services","CCC Allocation Model",0,0]
["HONI","Brampton","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Brampton","Other Services","CCC Allocation Model",0,0]
["HONI","HOI","General Counsel & Secretary","CCC Allocation Model",2.8938138062982052E-2,944.10616806002565]
[{"$f":"A84","v":"HONI"},"HOI","Financial Services","CCC Allocation Model",1.947398469637427E-3,72.495278340620217]
[{"$f":"A85","v":"HONI"},"HOI","Corporate Services","CCC Allocation Model",0,0]
["HONI","HOI","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","HOI","Other Services","CCC Allocation Model",0,0]
[]
["Note:","Exhibit C1, Tab 4, Schedule 1 provides a breakdown of Shared Service and Common Corporate Cost allocations, as derived by applying the Black & Veatch Review of Allocation of Common Corporate Costs for 2016. Exhibit C1, Tab 4, Schedule 1 provides the lines of business’ costs in a similar format to that found in past rate applications. For test years, the affiliate allocations outlined in this Attachment use the same cost base, but are grouped differently.  As a result, a direct reconciliation is not possible by comparing the two Exhibits."]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Brampton\"","Hydro One Brampton Networks Inc."]
[null,"\"B2M\"","B2M Limited Partnership "]
[null,"\"Telecom\"","Hydro One Telecom Inc."]
[null,"\"Hydro One SSM\"","Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]
[null,"\"Remotes\"","Hydro One Remote Communities Inc."]
[null,"\"HONI Dx\"","Hydro One Distribution"]
[null,"\"HONI Tx\"","HONI's transmission business"]

{"sheet":"2018","index":4,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[[97,2,97,3],[98,2,98,3],[91,2,91,3],[92,2,92,3],[94,2,94,3],[95,2,95,3],[96,2,96,5],[2,0,2,5],[3,0,3,5],[7,0,7,5],[9,0,9,1],[9,2,11,2],[9,3,11,3],[9,4,10,4],[9,5,10,5],[89,1,89,5],[9,6,10,6],[10,0,11,0],[10,1,11,1],[22,0,22,5],[24,0,24,1],[24,2,26,2],[24,3,26,3],[24,4,25,4],[24,5,25,5],[25,0,26,0],[25,1,26,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,"$","$"]
["HOI","All subs","General Counsel & Secretary (including Corporate Exec Office)","CCC Allocation Model",1185.217931384602,1185.217931384602]
["HOI","All subs","President/CEO/Chairman/Board","CCC Allocation Model",7044.626811811383,7044.626811811383]
["HOI","All subs","Chief Financial Office Services (Including Strategic Financial Services)","CCC Allocation Model",1168.1755495841383,1168.1755495841383]
["HONI","All subs and HOI","General Counsel & Secretary","CCC Allocation Model",33063.720272083592,33063.720272083592]
["HONI","All subs and HOI","Financial Services","CCC Allocation Model",35619.933687698111,35619.933687698111]
["HONI","All subs and HOI","Corporate Services","CCC Allocation Model",209862.321619739,209862.321619739]
["HONI","All subs and HOI","Telecommunication Services","CCC Allocation Model",18247.847520000003,18247.847520000003]
["HONI","All subs and HOI","Other Services","CCC Allocation Model",111690.50109973903,111690.50109973903]
["Remotes Services","HONI","Metering and Lines Services","CCC Allocation Model",148,148]
[]
["Corporate Cost Allocation"]
[]
["Name of Company",null,"Service Offered","Pricing Methodology","% of Corporate Costs Allocated","Amount Allocated"]
["From","To"]
[null,null,null,null,"%","$"]
["HOI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.4236067434283427,507.13768501687701,null,null,null,{"$f":"E28+E31+E34+E37+E40+E43+E46","v":0.98999999999999988}]
[{"$f":"A28","v":"HOI"},{"$f":"B28","v":"HONI Dx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.50878567586406498,4029.0768198815863,null,null,null,{"$f":"E29+E32+E35+E38+E41+E44+E47","v":0.88958472967584346}]
[{"$f":"A29","v":"HOI"},{"$f":"B29","v":"HONI Dx"},"Chief Financial Office Services","CCC Allocation Model",0.24254403118172874,552.33412264068534,null,null,null,0.5129757429605486]
["HOI","HONI Tx",{"$f":"C28","v":"General Counsel & Secretary"},"CCC Allocation Model",0.5288850410022703,633.17579215855687]
["HOI",{"$f":"B31","v":"HONI Tx"},"President/CEO/Chairman /Board","CCC Allocation Model",0.36847492822762212,2917.9551674841091]
["HOI",{"$f":"B32","v":"HONI Tx"},"Chief Financial Office Services","CCC Allocation Model",0.23407676524776655,533.05201589077217]
["HOI","Telecom","General Counsel & Secretary","CCC Allocation Model",9.9999999999999985E-3,11.971898296814162]
["HOI",{"$f":"B34","v":"Telecom"},"President/CEO/Chairman /Board","CCC Allocation Model",5.2534847317935235E-3,41.602377111981305]
["HOI",{"$f":"B35","v":"Telecom"},"Chief Financial Office Services","CCC Allocation Model",1.1586799690117293E-2,26.38607435471868]
["HOI","Remotes","General Counsel & Secretary","CCC Allocation Model",2.4000000000000004E-2,28.732555912353995]
["HOI",{"$f":"B37","v":"Remotes"},"President/CEO/Chairman /Board","CCC Allocation Model",2.6508942326481724E-3,20.992447333706274]
["HOI",{"$f":"B38","v":"Remotes"},"Chief Financial Office Services","CCC Allocation Model",5.7768446009125894E-3,13.155336697961998]
["HOI","B2M ","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B40","v":"B2M "},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B41","v":"B2M "},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HOI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",3.5082155693869038E-3,4.2]
["HOI",{"$f":"B43","v":"Hydro One SSM"},"President/CEO/Chairman /Board","CCC Allocation Model",4.4197466197146455E-3,35]
["HOI",{"$f":"B44","v":"Hydro One SSM"},"Chief Financial Office Services","CCC Allocation Model",1.8991302240023395E-2,43.247999999999998]
["HOI","Brampton","General Counsel & Secretary","CCC Allocation Model",0,0]
["HOI",{"$f":"B46","v":"Brampton"},"President/CEO/Chairman /Board","CCC Allocation Model",0,0]
["HOI",{"$f":"B47","v":"Brampton"},"Chief Financial Office Services","CCC Allocation Model",0,0]
["HONI","HONI Dx","General Counsel & Secretary","CCC Allocation Model",0.5213466962536647,17237.661329706101,null,null,null,{"$f":"E49+E54+E59+E64+E69+E74+E79+E84","v":1.0000000000000002}]
[{"$f":"A49","v":"HONI"},{"$f":"B49","v":"HONI Dx"},"Financial Services","CCC Allocation Model",0.4114450028097037,14655.643716216409,null,null,null,{"$f":"E50+E55+E60+E65+E70+E75+E80+E85","v":1.0000000000000002}]
[{"$f":"A50","v":"HONI"},"HONI Dx","Corporate Services","CCC Allocation Model",0.4827619834177409,101313.55062979704,null,null,null,{"$f":"E51+E56+E61+E66+E71+E76+E81+E86","v":1}]
["HONI","HONI Dx","Telecommunication Services","CCC Allocation Model",0.47527328750569797,8672.7144807330988,null,null,null,{"$f":"E52+E57+E62+E67+E72+E77+E82+E87","v":0.99999999999999989}]
["HONI","HONI Dx","Other Services","CCC Allocation Model",0.71103278959546168,79415.608568262425,null,null,null,{"$f":"E53+E58+E63+E68+E73+E78+E83+E88","v":1}]
["HONI","HONI Tx","General Counsel & Secretary","CCC Allocation Model",0.43342736300220347,14330.721088571689]
[{"$f":"A54","v":"HONI"},{"$f":"B54","v":"HONI Tx"},"Financial Services","CCC Allocation Model",0.56272376208768116,20044.183090055212]
[{"$f":"A55","v":"HONI"},"HONI Tx","Corporate Services","CCC Allocation Model",0.51389129877401341,107846.4210208974]
["HONI","HONI Tx","Telecommunication Services","CCC Allocation Model",0.50136361725620671,9148.8068397669031]
["HONI","HONI Tx","Other Services","CCC Allocation Model",0.27828789955433886,31082.114951217947]
["HONI","Telecom","General Counsel & Secretary","CCC Allocation Model",3.1226173293614329E-3,103.24534589476714]
[{"$f":"A59","v":"HONI"},{"$f":"B59","v":"Telecom"},"Financial Services","CCC Allocation Model",1.4424211760525059E-2,513.78946640721779]
[{"$f":"A60","v":"HONI"},"Telecom","Corporate Services","CCC Allocation Model",1.2760792873103216E-3,267.80096180580603]
["HONI","Telecom","Telecommunication Services","CCC Allocation Model",1.5624999999999997E-2,285.12261749999999]
["HONI","Telecom","Other Services","CCC Allocation Model",8.393285644278374E-3,937.45027948269762]
["HONI","Remotes","General Counsel & Secretary","CCC Allocation Model",1.1720338414052648E-2,387.51799081639263]
[{"$f":"A64","v":"HONI"},{"$f":"B64","v":"Remotes"},"Financial Services","CCC Allocation Model",6.6160849276722085E-3,235.66450639586301]
[{"$f":"A65","v":"HONI"},"Remotes","Corporate Services","CCC Allocation Model",1.2805014504971028E-3,268.72900723876529]
["HONI","Remotes","Telecommunication Services","CCC Allocation Model",7.7380952380952375E-3,141.20358200000001]
["HONI","Remotes","Other Services","CCC Allocation Model",2.2860252059210872E-3,255.32730077596034]
["HONI","B2M ","General Counsel & Secretary","CCC Allocation Model",3.0244630421831916E-6,0.1]
[{"$f":"A69","v":"HONI"},{"$f":"B69","v":"B2M "},"Financial Services","CCC Allocation Model",2.8074167929890485E-6,0.1]
[{"$f":"A70","v":"HONI"},"B2M ","Corporate Services","CCC Allocation Model",4.765028768775153E-7,0.1]
["HONI","B2M ","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","B2M ","Other Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","General Counsel & Secretary","CCC Allocation Model",2.1570470416850522E-3,71.319999999999993]
[{"$f":"A74","v":"HONI"},{"$f":"B74","v":"Hydro One SSM"},"Financial Services","CCC Allocation Model",2.9118526976882409E-3,103.72]
[{"$f":"A75","v":"HONI"},"Hydro One SSM","Corporate Services","CCC Allocation Model",7.896605675614183E-4,165.72]
["HONI","Hydro One SSM","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Hydro One SSM","Other Services","CCC Allocation Model",0,0]
["HONI","Brampton","General Counsel & Secretary","CCC Allocation Model",0,0]
[{"$f":"A79","v":"HONI"},{"$f":"B79","v":"Brampton"},"Financial Services","CCC Allocation Model",0,0]
[{"$f":"A80","v":"HONI"},"Brampton","Corporate Services","CCC Allocation Model",0,0]
["HONI","Brampton","Telecommunication Services","CCC Allocation Model",0,0]
["HONI","Brampton","Other Services","CCC Allocation Model",0,0]
["HONI","HOI","General Counsel & Secretary","CCC Allocation Model",2.8222913495990661E-2,933.15451709464799]
[{"$f":"A84","v":"HONI"},"HOI","Financial Services","CCC Allocation Model",1.8762782999366748E-3,66.832908623411299]
[{"$f":"A85","v":"HONI"},"HOI","Corporate Services","CCC Allocation Model",0,0]
[{"$f":"A86","v":"HONI"},"HOI","Telecommunication Services","CCC Allocation Model",0,0]
[{"$f":"A87","v":"HONI"},"HOI","Other Services","CCC Allocation Model",0,0]
[]
["Note:","Exhibit C1, Tab 4, Schedule 1 provides a breakdown of Shared Service and Common Corporate Cost allocations, as derived by applying the Black & Veatch Review of Allocation of Common Corporate Costs for 2016. Exhibit C1, Tab 4, Schedule 1 provides the lines of business’ costs in a similar format to that found in past rate applications. For test years, the affiliate allocations outlined in this Attachment use the same cost base, but are grouped differently.  As a result, a direct reconciliation is not possible by comparing the two Exhibits."]
[]
["Legend","\"HOI\"","Hydro One Inc."]
[null,"\"HONI\"","Hydro One Networks Inc."]
[null,"\"Brampton\"","Hydro One Brampton Networks Inc."]
[null,"\"B2M\"","B2M Limited Partnership "]
[null,"\"Telecom\"","Hydro One Telecom Inc."]
[null,"\"Hydro One SSM\"","Hydro One Sault Ste. Marie LP (formerly Great Lakes Power Transmission LP)"]
[null,"\"Remotes\"","Hydro One Remote Communities Inc."]
[null,"\"HONI Dx\"","Hydro One Distribution"]
[null,"\"HONI Tx\"","HONI's transmission business"]