{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["AER adjustments","Revenue forecast","Forecast charges BH","Forecast charges AH","New charges calc","Fee-based services RIN","Quoted services RIN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"AER adjustments","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[13,1,13,2]]}
["BUSINESS HOURS ADJUSTMENTS"]
[null,"Labour rates for 2020-21 ($June 021)"]
[null,"Marsden Jacob","United Energy","Adjustment to labour category","Labour weights for fee-based services","Weighted adjustment"]
["Administrative officer",92.51,112.81590698920981,{"$f":"IF(C4<=B4,0,B4/C4-1)","v":-0.17999152363462312},0.15,{"$f":"E4*D4","v":-2.6998728545193466E-2}]
["Field officer",171.34,164.40338786730896,0,0.85,0]
["Technical specialist",171.34,177.37416391218682,-3.4019407218596753E-2,0,0]
["Engineer",150.33000000000001,156.54522588668505,-3.9702430089972318E-2,0,0]
["Senior engineer",196.58,271.8352976732819,-0.27684152248590987,0,0]
[null,null,null,null,"Preliminary adjustment factor",{"$f":"SUM(F4:F8)","v":-2.6998728545193466E-2}]
[null,null,null,null,"Labour composition",0.9]
[null,null,null,null,"Fee-based price adjustment",{"$f":"F9*F10","v":-2.429885569067412E-2}]
[]
["AFTER HOURS ADJUSTMENTS"]
[null,"Labour rates for 2020-21 ($June 021)"]
[null,"Marsden Jacob","United Energy","Adjustment to labour category","Labour weights for fee-based services","Weighted adjustment"]
["Administrative officer",{"$f":"B4*1.75","v":161.89250000000001},{"$error":"#N/A"},{"$error":"#N/A"},0.15,{"$f":"E16*D16","v":{"$error":"#N/A"}}]
["Field officer",{"$f":"B5*1.75","v":299.84500000000003},202.38313477755989,{"$f":"IF(C17<=C5*1.75,0,C5*1.75/C17-1)","v":0},0.85,0]
["Technical specialist",{"$f":"B6*1.75","v":299.84500000000003},218.85344366334576,{"$f":"IF(C18<=C6*1.75,0,C6*1.75/C18-1)","v":0},0,0]
["Engineer",{"$f":"B7*1.75","v":263.07750000000004},222.41542559454712,{"$f":"IF(C19<=C7*1.75,0,C7*1.75/C19-1)","v":0},0,0]
["Senior engineer",{"$f":"B8*1.75","v":344.01500000000004},312.47481648258639,{"$f":"IF(C20<=C8*1.75,0,C8*1.75/C20-1)","v":0},0,0]
[null,null,null,null,"Preliminary adjustment factor",{"$f":"SUM(F17:F20)","v":0}]
[null,null,null,null,"Labour composition",0.9]
[null,null,null,null,"Fee-based price adjustment",{"$f":"F21*F22","v":0}]

{"sheet":"Revenue forecast","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5]]}
["United Energy Alternative Control Services forecast revenue","Revenue"]
[null,"$ June 2021 "]
[null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Basic connections fixed fee",{"$f":"SUM('Forecast charges BH'!P6:P8,'Forecast charges BH'!P10:P12)+SUM('Forecast charges AH'!P6:P8,'Forecast charges AH'!P10:P12)","v":10841986.147895128},{"$f":"SUM('Forecast charges BH'!Q6:Q8,'Forecast charges BH'!Q10:Q12)+SUM('Forecast charges AH'!Q6:Q8,'Forecast charges AH'!Q10:Q12)","v":10682555.551949561},{"$f":"SUM('Forecast charges BH'!R6:R8,'Forecast charges BH'!R10:R12)+SUM('Forecast charges AH'!R6:R8,'Forecast charges AH'!R10:R12)","v":10545993.255064117},{"$f":"SUM('Forecast charges BH'!S6:S8,'Forecast charges BH'!S10:S12)+SUM('Forecast charges AH'!S6:S8,'Forecast charges AH'!S10:S12)","v":10482022.558502952},{"$f":"SUM('Forecast charges BH'!T6:T8,'Forecast charges BH'!T10:T12)+SUM('Forecast charges AH'!T6:T8,'Forecast charges AH'!T10:T12)","v":10395542.91586823}]
["Metering and network ancilliary services fixed fee",{"$f":"'Forecast charges BH'!P41-'Revenue forecast'!B4+'Forecast charges AH'!P39","v":2484293.8184289141},{"$f":"'Forecast charges BH'!Q41-'Revenue forecast'!C4+'Forecast charges AH'!Q39","v":2582077.9092996018},{"$f":"'Forecast charges BH'!R41-'Revenue forecast'!D4+'Forecast charges AH'!R39","v":2646223.3656686889},{"$f":"'Forecast charges BH'!S41-'Revenue forecast'!E4+'Forecast charges AH'!S39","v":2717830.4868546454},{"$f":"'Forecast charges BH'!T41-'Revenue forecast'!F4+'Forecast charges AH'!T39","v":2797792.3147360152}]
["Quoted services",{"$f":"SUM('Quoted services RIN'!E13:E18)","v":1563976.7624789998},{"$f":"SUM('Quoted services RIN'!F13:F18)","v":1563976.7624789998},{"$f":"SUM('Quoted services RIN'!G13:G18)","v":1563976.7624789998},{"$f":"SUM('Quoted services RIN'!H13:H18)","v":1563976.7624789998},{"$f":"SUM('Quoted services RIN'!I13:I18)","v":1563976.7624789998}]
["Total",{"$f":"SUM(B4:B6)","v":14890256.728803042},{"$f":"SUM(C4:C6)","v":14828610.223728161},{"$f":"SUM(D4:D6)","v":14756193.383211806},{"$f":"SUM(E4:E6)","v":14763829.807836596},{"$f":"SUM(F4:F6)","v":14757311.993083246}]

{"sheet":"Forecast charges BH","index":2,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,1,4,6],[8,1,8,6],[8,15,8,19],[4,9,4,13],[8,9,8,13],[4,15,4,18],[2,1,2,6],[2,9,2,13],[2,15,2,19],[1,1,1,6],[1,9,1,13],[1,15,1,19]]}
[]
["Business hours","Charges",null,null,null,null,null,null,null,"Volumes",null,null,null,null,null,"Revenue"]
[null,"$ June 2021 ",null,null,null,null,null,null,null,null,null,null,null,null,null,"$ June 2021 "]
["Basic connection services","United  proposal 2021/22","AER draft decision 2021/22","2022/23","2023/24","2024/25","2025/26",null,null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["New connection where we are the metering coordinator"]
["Single phase",513.66700178392011,{"$f":"B6*(1+'AER adjustments'!$F$11)","v":501.18548143451136},{"$f":"C6","v":501.18548143451136},501.18548143451136,501.18548143451136,501.18548143451136,null,null,14241.353898593399,14020.611659053511,13831.532097050893,13742.960422711427,13623.223618890437,null,{"$f":"J6*C6","v":7137559.8099457882},7026927.0043490566,6932163.0730373487,6887772.2357920622,6827761.8881236101]
["Multi-phase DC",513.66700178392011,{"$f":"B7*(1+'AER adjustments'!$F$11)","v":501.18548143451136},501.18548143451136,501.18548143451136,501.18548143451136,501.18548143451136,null,null,5013.4506895943368,4935.7417624147965,4869.1791962950228,4837.9988938492297,4795.8473845221952,null,2512668.6975125205,2473722.1114322832,2440361.9196860283,2424734.8047934598,2403609.0802981984]
["Multi-phase CT",1783,{"$f":"B8*(1+'AER adjustments'!$F$11)","v":1739.675140303528},1739.675140303528,1739.675140303528,1739.675140303528,1739.675140303528,null,null,365.33140018538023,359.66873131096025,354.81830054259927,352.54618413894775,349.47459315784272,null,635557.95487478573,625706.75060618669,617268.57677870581,613315.83235539729,607972.2618843884]
["New connection where we are not the metering coordinator"]
["Single phase",476.68290187153372,{"$f":"B10*(1+'AER adjustments'!$F$11)","v":465.10005282874556},{"$f":"C10","v":465.10005282874556},465.10005282874556,465.10005282874556,465.10005282874556,null,null,0,0,0,0,0,null,{"$f":"J10*C10","v":0},0,0,0,0]
["Multi-phase DC",476.68290187153372,{"$f":"B11*(1+'AER adjustments'!$F$11)","v":465.10005282874556},465.10005282874556,465.10005282874556,465.10005282874556,465.10005282874556,null,null,0,0,0,0,0,null,0,0,0,0,0]
["Multi-phase CT",1627,{"$f":"B12*(1+'AER adjustments'!$F$11)","v":1587.4657617912733},1587.4657617912733,1587.4657617912733,1587.4657617912733,1587.4657617912733,null,null,0,0,0,0,0,null,0,0,0,0,0]
[]
["Metering and network ancillary services","United  proposal 2021/22","AER draft decision 2021/22","2022/23","2023/24","2024/25","2025/26",null,null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Meter/NMI/site investigation",{"$f":"B16","v":284.33673828486758},{"$f":"B15*(1+'AER adjustments'!$F$11)","v":277.42768091372659},{"$f":"C15","v":277.42768091372659},277.42768091372659,277.42768091372659,277.42768091372659,null,null,765,772.65,780.37649999999996,788.18026499999996,796.06206765000002,null,{"$f":"J15*C15","v":212232.17589900084},214354.49765799084,216498.04263457074,218663.02306091646,220849.65329152564]
["Meter accuracy test",284.33673828486758,{"$f":"B16*(1+'AER adjustments'!$F$11)","v":277.42768091372659},277.42768091372659,277.42768091372659,277.42768091372659,277.42768091372659,null,null,114,114,114,114,114,null,31626.755624164831,31626.755624164831,31626.755624164831,31626.755624164831,31626.755624164831]
["Meter accuracy test - additional meters","N/A","To be proposed by United."]
["Special reading",23.88588001764446,{"$f":"B18*(1+'AER adjustments'!$F$11)","v":23.305480466050959},23.305480466050959,23.305480466050959,23.305480466050959,23.305480466050959,null,null,139,139,139,139,139,null,3239.4617847810832,3239.4617847810832,3239.4617847810832,3239.4617847810832,3239.4617847810832]
["Remote meter reconfiguration",67.814356266501008,{"$f":"B19*(1+'AER adjustments'!$F$11)","v":66.166545009825342},{"$f":"C19","v":66.166545009825342},{"$f":"D19","v":66.166545009825342},{"$f":"E19","v":66.166545009825342},{"$f":"F19","v":66.166545009825342},null,null,5768,5768,5768,5768,5768,null,{"$f":"J19*C19","v":381648.63161667256},{"$f":"K19*D19","v":381648.63161667256},{"$f":"L19*E19","v":381648.63161667256},{"$f":"M19*F19","v":381648.63161667256},{"$f":"N19*G19","v":381648.63161667256}]
["Remote energisation","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Remote de‑energisation","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Manual re-energisation (incl customer transfer)",50.863400289915099,{"$f":"B22*(1+'AER adjustments'!$F$11)","v":49.627477866333457},{"$f":"C22","v":49.627477866333457},49.627477866333457,49.627477866333457,49.627477866333457,null,null,3438,3850.5600000000004,4312.6272000000008,4830.1424640000014,5409.759559680002,null,{"$f":"J22*C22","v":170619.26890445442},191093.58117298898,214024.81091374767,239707.78822339742,268472.72281020513]
["Manual re-energisation (same day)",76.67011126373626,{"$f":"B23*(1+'AER adjustments'!$F$11)","v":74.807115294350808},74.807115294350808,74.807115294350808,74.807115294350808,74.807115294350808,null,null,1320,1478.4,1655.8080000000002,1854.5049600000004,2077.0455552000008,null,98745.392188543061,110594.83925116825,123866.21996130844,138730.16635666546,155377.78631946535]
["Manual de-energisation",50.863400289915099,{"$f":"B24*(1+'AER adjustments'!$F$11)","v":49.627477866333457},49.627477866333457,49.627477866333457,49.627477866333457,49.627477866333457,null,null,3868,4332.1600000000008,4852.0192000000015,5434.2615040000019,6086.3728844800025,null,191959.0843869778,214994.1745134152,240793.47545502504,269688.69250962808,302051.33561078343]
["Service truck – first 30 minutes (unit rate)",364.93952926575844,{"$f":"B25*(1+'AER adjustments'!$F$11)","v":356.07191630830721},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 1x additional 15 mins",440.4088508633472,{"$f":"B26*(1+'AER adjustments'!$F$11)","v":429.70741975132307},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 2x additional 15 mins",515.87871207480919,{"$f":"B27*(1+'AER adjustments'!$F$11)","v":503.34344969621259},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 3x additional 15 mins",591.32804745110604,{"$f":"B28*(1+'AER adjustments'!$F$11)","v":576.95945256024356},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 4x additional 15 mins",666.78737596158408,{"$f":"B29*(1+'AER adjustments'!$F$11)","v":650.58520573673025},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 5x additional 15 mins",742.25723716138555,{"$f":"B30*(1+'AER adjustments'!$F$11)","v":724.22123567024255},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 6x additional 15 mins",817.69657946260656,{"$f":"B31*(1+'AER adjustments'!$F$11)","v":797.82748827948683},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Wasted service truck visit (unit rate)",316.53766645592788,{"$f":"B32*(1+'AER adjustments'!$F$11)","v":308.84616337805255},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Failed field visit (simple tasks) ","N/A",{"$f":"C18","v":23.305480466050959},{"$f":"C33","v":23.305480466050959},23.305480466050959,23.305480466050959,23.305480466050959]
["Isolation of supply or reconnection, excluding HV (single)",{"$f":"'New charges calc'!$C$27","v":326.32773491712686},{"$f":"B34*(1+'AER adjustments'!$F$11)","v":318.39834437851101},{"$f":"'New charges calc'!D27","v":326.32773491712686},{"$f":"'New charges calc'!E27","v":326.32773491712686},{"$f":"'New charges calc'!F27","v":326.32773491712686},{"$f":"'New charges calc'!G27","v":326.32773491712686},null,null,{"$f":"'New charges calc'!C8","v":520.66046668921206},{"$f":"'New charges calc'!D8","v":520.66046668921206},{"$f":"'New charges calc'!E8","v":520.66046668921206},{"$f":"'New charges calc'!F8","v":520.66046668921206},{"$f":"'New charges calc'!G8","v":520.66046668921206},null,{"$f":"J34*C34","v":165777.430577188},169905.95075558475,169905.95075558475,169905.95075558475,169905.95075558475]
["Isolation of supply and reconnection after isolation, excluding HV (same day)",{"$f":"'New charges calc'!$C$29","v":600.37401147226865},{"$f":"B35*(1+'AER adjustments'!$F$11)","v":585.78561000707282},{"$f":"'New charges calc'!D29","v":600.37401147226865},{"$f":"'New charges calc'!E29","v":600.37401147226865},{"$f":"'New charges calc'!F29","v":600.37401147226865},{"$f":"'New charges calc'!G29","v":600.37401147226865},null,null,{"$f":"'New charges calc'!C10","v":86.18802840716944},{"$f":"'New charges calc'!D10","v":86.18802840716944},{"$f":"'New charges calc'!E10","v":86.18802840716944},{"$f":"'New charges calc'!F10","v":86.18802840716944},{"$f":"'New charges calc'!G10","v":86.18802840716944},null,50487.706795800674,51745.052355698164,51745.052355698164,51745.052355698164,51745.052355698164]
["Standard alteration, 30-60 minutes",{"$f":"'New charges calc'!$C$28","v":563.90684929395309},{"$f":"B36*(1+'AER adjustments'!$F$11)","v":550.2045581399766},{"$f":"'New charges calc'!D$28","v":563.90684929395309},{"$f":"'New charges calc'!E$28","v":563.90684929395309},{"$f":"'New charges calc'!F$28","v":563.90684929395309},{"$f":"'New charges calc'!G$28","v":563.90684929395309},null,null,{"$f":"'New charges calc'!C9","v":1334.501521812648},{"$f":"'New charges calc'!D9","v":1334.501521812648},{"$f":"'New charges calc'!E9","v":1334.501521812648},{"$f":"'New charges calc'!F9","v":1334.501521812648},{"$f":"'New charges calc'!G9","v":1334.501521812648},null,734248.82014605438,752534.54854335589,752534.54854335589,752534.54854335589,752534.54854335589]
["Complex alteration, > 60 minutes",{"$f":"'New charges calc'!$C$30","v":700.88106820762619},{"$f":"B37*(1+'AER adjustments'!$F$11)","v":683.85046027492353},{"$f":"'New charges calc'!D$30","v":700.88106820762619},{"$f":"'New charges calc'!E$30","v":700.88106820762619},{"$f":"'New charges calc'!F$30","v":700.88106820762619},{"$f":"'New charges calc'!G$30","v":700.88106820762619},null,null,{"$f":"'New charges calc'!C11","v":147.64998309097058},{"$f":"'New charges calc'!D11","v":147.64998309097058},{"$f":"'New charges calc'!E11","v":147.64998309097058},{"$f":"'New charges calc'!F11","v":147.64998309097058},{"$f":"'New charges calc'!G11","v":147.64998309097058},null,{"$f":"J37*C37","v":100970.50889634491},103485.0778696374,103485.0778696374,103485.0778696374,103485.0778696374]
["Failed field visit (unable to perform customer requested task) ",{"$f":"$B$32","v":316.53766645592788},{"$f":"B38*(1+'AER adjustments'!$F$11)","v":308.84616337805255},{"$f":"C38","v":308.84616337805255},{"$f":"D38","v":308.84616337805255},{"$f":"E38","v":308.84616337805255},{"$f":"F38","v":308.84616337805255},null,null,505,505,505,505,505,null,155967.31250591655,155967.31250591655,155967.31250591655,155967.31250591655,155967.31250591655]
[]
["Total fee-based  services BH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Fee-based  service BH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P22:P38,P15:P21,P6:P12)","v":12583309.011658993},{"$f":"SUM(Q22:Q38,Q15:Q21,Q6:Q12)","v":12507545.750038903},{"$f":"SUM(R22:R38,R15:R21,R6:R12)","v":12435128.909522546},{"$f":"SUM(S22:S38,S15:S21,S6:S12)","v":12442765.334147338},{"$f":"SUM(T22:T38,T15:T21,T6:T12)","v":12436247.519393986}]

{"sheet":"Forecast charges AH","index":3,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,1,4,6],[8,1,8,6],[8,9,8,13],[4,9,4,13],[8,15,8,19],[4,15,4,19],[2,1,2,6],[1,9,1,13],[1,15,1,19],[2,9,2,13],[2,15,2,19],[1,1,1,6]]}
[]
["After hours",null,null,null,null,null,null,null,null,"Volumes",null,null,null,null,null,"Revenue"]
[null,"$ June 2021 ",null,null,null,null,null,null,null,null,null,null,null,null,null,"$ June 2021 "]
["Basic connection services","United  proposal 2021/22","AER draft decision 2021/22","2022/23","2023/24","2024/25","2025/26",null,null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["New connection where we are the metering coordinator"]
["Single phase",784.47473737916221,{"$f":"B6*(1+'AER adjustments'!$F$23)","v":784.47473737916221},{"$f":"C6","v":784.47473737916221},784.47473737916221,784.47473737916221,784.47473737916221,null,null,479,479,479,479,479,null,{"$f":"J6*C6","v":375763.3992046187},375763.3992046187,375763.3992046187,375763.3992046187,375763.3992046187]
["Multi-phase DC",784.47473737916221,{"$f":"B7*(1+'AER adjustments'!$F$23)","v":784.47473737916221},784.47473737916221,784.47473737916221,784.47473737916221,784.47473737916221,null,null,171,171,171,171,171,null,134145.18009183675,134145.18009183675,134145.18009183675,134145.18009183675,134145.18009183675]
["Multi-phase CT",2723.0062509162954,{"$f":"B8*(1+'AER adjustments'!$F$23)","v":2723.0062509162954},2723.0062509162954,2723.0062509162954,2723.0062509162954,2723.0062509162954,null,null,17,17,17,17,17,null,46291.106265577022,46291.106265577022,46291.106265577022,46291.106265577022,46291.106265577022]
["New connection where we are not the metering coordinator"]
["Single phase",784.47473737916221,{"$f":"B10*(1+'AER adjustments'!$F$23)","v":784.47473737916221},{"$f":"C10","v":784.47473737916221},784.47473737916221,784.47473737916221,784.47473737916221,null,null,0,0,0,0,0,null,{"$f":"J10*C10","v":0},0,0,0,0]
["Multi-phase DC",784.47473737916221,{"$f":"B11*(1+'AER adjustments'!$F$23)","v":784.47473737916221},784.47473737916221,784.47473737916221,784.47473737916221,784.47473737916221,null,null,0,0,0,0,0,null,0,0,0,0,0]
["Multi-phase CT",2723.0062509162954,{"$f":"B12*(1+'AER adjustments'!$F$23)","v":2723.0062509162954},2723.0062509162954,2723.0062509162954,2723.0062509162954,2723.0062509162954,null,null,0,0,0,0,0,null,0,0,0,0,0]
[]
["Metering and network ancillary services","United  proposal 2021/22","AER draft decision 2021/22","2022/23","2023/24","2024/25","2025/26",null,null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Meter/NMI/site investigation",534.04,{"$f":"'Forecast charges BH'!C15*1.75","v":485.49844159902153},{"$f":"'New charges calc'!D57","v":623.23538723006175},{"$f":"'New charges calc'!E57","v":623.23538723006175},{"$f":"'New charges calc'!F57","v":623.23538723006175},{"$f":"'New charges calc'!G57","v":623.23538723006175},null,null,0,0,0,0,0,null,{"$f":"J15*C15","v":0},0,0,0,0]
["Meter accuracy test",{"$f":"B15","v":534.04},{"$f":"'Forecast charges BH'!C16*1.75","v":485.49844159902153},{"$f":"D15","v":623.23538723006175},{"$f":"E15","v":623.23538723006175},{"$f":"F15","v":623.23538723006175},{"$f":"G15","v":623.23538723006175},null,null,0,0,0,0,0,null,0,0,0,0,0]
["Special reading","N/A",{"$f":"B17","v":"N/A"},"N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Remote meter reconfiguration","N/A",{"$f":"B18","v":"N/A"},{"$f":"C18","v":"N/A"},{"$f":"D18","v":"N/A"},{"$f":"E18","v":"N/A"},{"$f":"F18","v":"N/A"},null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Remote re‑energisation","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Remote de‑energisation","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Manual re-energisation (incl customer transfer)",90.249079239117748,{"$f":"'Forecast charges BH'!C22*1.75","v":86.848086266083556},{"$f":"C21","v":86.848086266083556},86.848086266083556,86.848086266083556,86.848086266083556,null,null,331,331,331,331,331,null,{"$f":"J21*C21","v":28746.716554073657},{"$f":"K21*D21","v":28746.716554073657},{"$f":"L21*E21","v":28746.716554073657},{"$f":"M21*F21","v":28746.716554073657},{"$f":"N21*G21","v":28746.716554073657}]
["Manual re-energisation (same day)","N/A",{"$f":"B22","v":"N/A"},{"$f":"C22","v":"N/A"},{"$f":"D22","v":"N/A"},{"$f":"E22","v":"N/A"},{"$f":"F22","v":"N/A"},null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Manual de-energisation","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Service truck – first 30 minutes (unit rate)","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 1x additional 15 mins",912.31857408390874,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 2x additional 15 mins",1016.9976527367824,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 3x additional 15 mins",1121.6562055365662,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 4x additional 15 mins",1226.2947721748394,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 5x additional 15 mins",1330.9433319088655,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Truck Visit + 6x additional 15 mins",1435.6224105649303,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Wasted service truck visit (unit rate)",807.67001434495705,"N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Isolation of supply or reconnection, excluding HV (single)",{"$f":"'New charges calc'!$C$57","v":623.23538723006175},{"$f":"'Forecast charges BH'!C34*1.75","v":557.19710266239429},{"$f":"'New charges calc'!D57","v":623.23538723006175},{"$f":"'New charges calc'!E57","v":623.23538723006175},{"$f":"'New charges calc'!F57","v":623.23538723006175},{"$f":"'New charges calc'!G57","v":623.23538723006175},null,null,{"$f":"'New charges calc'!C38","v":30},{"$f":"'New charges calc'!D38","v":30},{"$f":"'New charges calc'!E38","v":30},{"$f":"'New charges calc'!F38","v":30},{"$f":"'New charges calc'!G38","v":30},null,{"$f":"J32*C32","v":16715.913079871829},{"$f":"K32*D32","v":18697.061616901854},{"$f":"L32*E32","v":18697.061616901854},{"$f":"M32*F32","v":18697.061616901854},{"$f":"N32*G32","v":18697.061616901854}]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","N/A","N/A","N/A","N/A","N/A","N/A",null,null,"N/A","N/A","N/A","N/A","N/A",null,"N/A","N/A","N/A","N/A","N/A"]
["Standard alteration, <60 minutes",{"$f":"'New charges calc'!$C$58","v":1076.9746668043804},{"$f":"'Forecast charges BH'!C36*1.75","v":962.85797674495905},{"$f":"'New charges calc'!D$58","v":1076.9746668043804},{"$f":"'New charges calc'!E$58","v":1076.9746668043804},{"$f":"'New charges calc'!F$58","v":1076.9746668043804},{"$f":"'New charges calc'!G$58","v":1076.9746668043804},null,null,{"$f":"'New charges calc'!C39","v":79},{"$f":"'New charges calc'!D39","v":79},{"$f":"'New charges calc'!E39","v":79},{"$f":"'New charges calc'!F39","v":79},{"$f":"'New charges calc'!G39","v":79},null,{"$f":"J34*C34","v":76065.780162851763},85080.998677546057,85080.998677546057,85080.998677546057,85080.998677546057]
["Complex alteration, > 60 minutes",{"$f":"'New charges calc'!$C$60","v":1338.5741915486624},{"$f":"'Forecast charges BH'!C37*1.75","v":1196.7383054811162},{"$f":"'New charges calc'!D$60","v":1338.5741915486624},{"$f":"'New charges calc'!E$60","v":1338.5741915486624},{"$f":"'New charges calc'!F$60","v":1338.5741915486624},{"$f":"'New charges calc'!G$60","v":1338.5741915486624},null,null,{"$f":"'New charges calc'!C41","v":22},{"$f":"'New charges calc'!D41","v":22},{"$f":"'New charges calc'!E41","v":22},{"$f":"'New charges calc'!F41","v":22},{"$f":"'New charges calc'!G41","v":22},null,26328.242720584556,29448.632214070574,29448.632214070574,29448.632214070574,29448.632214070574]
["Failed field visit (unable to perform customer requested task) ",{"$f":"$B$31","v":807.67001434495705},{"$f":"'Forecast charges BH'!C38*1.75","v":540.48078591159197},{"$f":"C36","v":540.48078591159197},{"$f":"D36","v":540.48078591159197},{"$f":"E36","v":540.48078591159197},{"$f":"F36","v":540.48078591159197},null,null,72,72,72,72,72,null,38914.61658563462,38914.61658563462,38914.61658563462,38914.61658563462,38914.61658563462]
[]
["Total fee-based services AH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Fee-based service AH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P21:P36,P15:P20,P6:P12)","v":742970.95466504886},{"$f":"SUM(Q21:Q36,Q15:Q20,Q6:Q12)","v":757087.71121025924},{"$f":"SUM(R21:R36,R15:R20,R6:R12)","v":757087.71121025924},{"$f":"SUM(S21:S36,S15:S20,S6:S12)","v":757087.71121025924},{"$f":"SUM(T21:T36,T15:T20,T6:T12)","v":757087.71121025924}]

{"sheet":"New charges calc","index":4,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
["Business hours"]
[]
["All services previously classified as service truck visits",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Revenue","$2021",{"$f":"C12*'Forecast charges BH'!B27","v":1077670.6295242764},{"$f":"C5","v":1077670.6295242764},{"$f":"D5","v":1077670.6295242764},{"$f":"E5","v":1077670.6295242764},{"$f":"F5","v":1077670.6295242764}]
[]
["Volumes break-down",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","Number",{"$f":"M8*$C$12","v":520.66046668921206},{"$f":"C8","v":520.66046668921206},520.66046668921206,520.66046668921206,520.66046668921206,null,null,null,null,737,{"$f":"L8/$L$12","v":0.24923909367602298}]
["Standard alteration, <60 minutes","Number",{"$f":"M9*$C$12","v":1334.501521812648},1334.501521812648,1334.501521812648,1334.501521812648,1334.501521812648,null,null,null,null,{"$f":"981+908","v":1889},{"$f":"L9/$L$12","v":0.6388231315522489}]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","Number",{"$f":"M10*$C$12","v":86.18802840716944},86.18802840716944,86.18802840716944,86.18802840716944,86.18802840716944,null,null,null,null,122,{"$f":"L10/$L$12","v":4.1258031788975316E-2}]
["Complex alteration, > 60 minutes","Number",{"$f":"M11*$C$12","v":147.64998309097058},147.64998309097058,147.64998309097058,147.64998309097058,147.64998309097058,null,null,null,null,209,{"$f":"L11/$L$12","v":7.0679742982752786E-2}]
["Total","Number",2089,2089,2089,2089,2089,null,null,null,null,{"$f":"SUM(L8:L11)","v":2957},{"$f":"L12/$L$12","v":1}]
[]
["Price weighted volumes",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,null,"Price ratio "]
["Isolation of supply or reconnection, excluding HV (single)","$2021",{"$f":"C8*J15","v":520.66046668921206},{"$f":"C15","v":520.66046668921206},520.66046668921206,520.66046668921206,520.66046668921206,null,null,1]
["Standard alteration, <60 minutes","$2021",{"$f":"C9*J16","v":2306.069843356916},2306.069843356916,2306.069843356916,2306.069843356916,2306.069843356916,null,null,1.7280383766251466]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C10*J17","v":158.5677428516432},158.5677428516432,158.5677428516432,158.5677428516432,158.5677428516432,null,null,1.8397884924636814]
["Complex alteration, > 60 minutes","$2021",{"$f":"C11*J18","v":317.12008142954244},317.12008142954244,317.12008142954244,317.12008142954244,317.12008142954244,null,null,2.1477827141650088]
[]
["Revenue per service",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C15","v":169905.95075558475},{"$f":"C21","v":169905.95075558475},169905.95075558475,169905.95075558475,169905.95075558475]
["Standard alteration, <60 minutes","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C16","v":752534.54854335589},752534.54854335589,752534.54854335589,752534.54854335589,752534.54854335589]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C17","v":51745.052355698164},51745.052355698164,51745.052355698164,51745.052355698164,51745.052355698164]
["Complex alteration, > 60 minutes","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C18","v":103485.0778696374},103485.0778696374,103485.0778696374,103485.0778696374,103485.0778696374]
[]
["Weighted service charges",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","$2021",{"$f":"C21/C8","v":326.32773491712686},{"$f":"C27","v":326.32773491712686},326.32773491712686,326.32773491712686,326.32773491712686]
["Standard alteration, <60 minutes","$2021",{"$f":"C22/C9","v":563.90684929395309},563.90684929395309,563.90684929395309,563.90684929395309,563.90684929395309]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C23/C10","v":600.37401147226865},600.37401147226865,600.37401147226865,600.37401147226865,600.37401147226865]
["Complex alteration, > 60 minutes","$2021",{"$f":"C24/C11","v":700.88106820762619},700.88106820762619,700.88106820762619,700.88106820762619,700.88106820762619]
[]
["After hours"]
[]
["All services previously classified as service truck visits",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Revenue","$2021",{"$f":"C42*'Forecast charges AH'!B26","v":133226.69250851849},{"$f":"C35","v":133226.69250851849},{"$f":"D35","v":133226.69250851849},{"$f":"E35","v":133226.69250851849},{"$f":"F35","v":133226.69250851849}]
[]
["Volumes break-down",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","Number",30,{"$f":"C38","v":30},30,30,30]
["Standard alteration, <60 minutes","Number",79,79,79,79,79]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","Number","N/A","N/A","N/A","N/A","N/A"]
["Complex alteration, > 60 minutes","Number",22,22,22,22,22]
["Total","Number",131,131,131,131,131]
[]
["Price weighted volumes",null,"2021/22","2022/23","2023/24","2024/25","2025/26",null,null,"Price ratio "]
["Isolation of supply or reconnection, excluding HV (single)","$2021",{"$f":"C38*J45","v":30},{"$f":"C45","v":30},30,30,30,null,null,1]
["Standard alteration, <60 minutes","$2021",{"$f":"C39*J46","v":136.51503175338658},136.51503175338658,136.51503175338658,136.51503175338658,136.51503175338658,null,null,1.7280383766251466]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021","N/A","N/A","N/A","N/A","N/A",null,null,"N/A"]
["Complex alteration, > 60 minutes","$2021",{"$f":"C41*J48","v":47.251219711630192},47.251219711630192,47.251219711630192,47.251219711630192,47.251219711630192,null,null,2.1477827141650088]
[]
["Revenue per service",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","$2021",{"$f":"C$35/(C$45+C$46+C$48)*C45","v":18697.061616901854},{"$f":"C51","v":18697.061616901854},18697.061616901854,18697.061616901854,18697.061616901854]
["Standard alteration, <60 minutes","$2021",{"$f":"C$35/(C$45+C$46+C$48)*C46","v":85080.998677546057},85080.998677546057,85080.998677546057,85080.998677546057,85080.998677546057]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021","N/A","N/A","N/A","N/A","N/A"]
["Complex alteration, > 60 minutes","$2021",{"$f":"C$35/(C$45+C$46+C$48)*C48","v":29448.632214070571},29448.632214070571,29448.632214070571,29448.632214070571,29448.632214070571]
[]
["Weighted service charges",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","$2021",{"$f":"C51/C38","v":623.23538723006175},{"$f":"C57","v":623.23538723006175},623.23538723006175,623.23538723006175,623.23538723006175]
["Standard alteration, <60 minutes","$2021",{"$f":"C52/C39","v":1076.9746668043804},1076.9746668043804,1076.9746668043804,1076.9746668043804,1076.9746668043804]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021","N/A","N/A","N/A","N/A","N/A"]
["Complex alteration, > 60 minutes","$2021",{"$f":"C54/C41","v":1338.5741915486624},1338.5741915486624,1338.5741915486624,1338.5741915486624,1338.5741915486624]

{"sheet":"Fee-based services RIN","index":5,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,1,5,2],[8,1,9,1],[8,2,8,8],[8,9,8,15]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"United Energy"]
[null,"2021-22 to 2025-26"]
[null,"4.3 ANCILLARY SERVICES - FEE BASED SERVICES"]
[]
[null,"There are TWO tables on this worksheet. The COLUMNS representing each table have been 'grouped' for easy navigation. See the Instructions sheet on how to group or ungroup data."]
[]
[null,"4.3.1 - COST METRICS FOR FEE-BASED SERVICES"]
[null,"SERVICE SUBCATEGORY","EXPENDITURE \n($0's, real June 2021)",null,null,null,null,null,null,"VOLUMES (0's)"]
[null,null,"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[null,"COMMON FEE-BASED SERVICES"]
[null,"Energisation"]
[null,"De-energisation",184824.88080347897,190661.45598674676,{"$f":"SUM('Forecast charges BH'!P24)","v":191959.0843869778},{"$f":"SUM('Forecast charges BH'!Q24)","v":214994.1745134152},{"$f":"SUM('Forecast charges BH'!R24)","v":240793.47545502504},{"$f":"SUM('Forecast charges BH'!S24)","v":269688.69250962808},{"$f":"SUM('Forecast charges BH'!T24)","v":302051.33561078343},3758,3825,{"$f":"'Forecast charges BH'!J24","v":3868},{"$f":"'Forecast charges BH'!K24","v":4332.1600000000008},{"$f":"'Forecast charges BH'!L24","v":4852.0192000000015},{"$f":"'Forecast charges BH'!M24","v":5434.2615040000019},{"$f":"'Forecast charges BH'!N24","v":6086.3728844800025}]
[null,"Re-energisation",253237.43850499904,257446.01716044819,{"$f":"SUM('Forecast charges BH'!P22:P23)","v":269364.66109299747},{"$f":"SUM('Forecast charges BH'!Q22:Q23)","v":301688.42042415723},{"$f":"SUM('Forecast charges BH'!R22:R23)","v":337891.03087505611},{"$f":"SUM('Forecast charges BH'!S22:S23)","v":378437.95458006288},{"$f":"SUM('Forecast charges BH'!T22:T23)","v":423850.50912967045},4624,4689,{"$f":"SUM('Forecast charges BH'!J22:J23)","v":4758},{"$f":"SUM('Forecast charges BH'!K22:K23)","v":5328.9600000000009},{"$f":"SUM('Forecast charges BH'!L22:L23)","v":5968.4352000000008},{"$f":"SUM('Forecast charges BH'!M22:M23)","v":6684.6474240000016},{"$f":"SUM('Forecast charges BH'!N22:N23)","v":7486.8051148800023}]
[null,"MISCELLANEOUS FEE-BASED SERVICES"]
[null,"Meter/NMI/site investigation",206641.72454852751,202508.89005755694,{"$f":"'Forecast charges BH'!P15","v":212232.17589900084},{"$f":"'Forecast charges BH'!Q15","v":214354.49765799084},{"$f":"'Forecast charges BH'!R15","v":216498.04263457074},{"$f":"'Forecast charges BH'!S15","v":218663.02306091646},{"$f":"'Forecast charges BH'!T15","v":220849.65329152564},704.94749999999999,726.75,{"$f":"'Forecast charges BH'!J15","v":765},{"$f":"'Forecast charges BH'!K15","v":772.65},{"$f":"'Forecast charges BH'!L15","v":780.37649999999996},{"$f":"'Forecast charges BH'!M15","v":788.18026499999996},{"$f":"'Forecast charges BH'!N15","v":796.06206765000002}]
[null,"Meter accuracy test",30793.668756251158,30177.795381126136,{"$f":"'Forecast charges BH'!P16","v":31626.755624164831},{"$f":"'Forecast charges BH'!Q16","v":31626.755624164831},{"$f":"'Forecast charges BH'!R16","v":31626.755624164831},{"$f":"'Forecast charges BH'!S16","v":31626.755624164831},{"$f":"'Forecast charges BH'!T16","v":31626.755624164831},105.05099999999999,108.3,{"$f":"'Forecast charges BH'!J16","v":114},{"$f":"'Forecast charges BH'!K16","v":114},{"$f":"'Forecast charges BH'!L16","v":114},{"$f":"'Forecast charges BH'!M16","v":114},{"$f":"'Forecast charges BH'!N16","v":114}]
[null,"Special reading",3154.1304563299509,3253.7345760035282,{"$f":"'Forecast charges BH'!P18","v":3239.4617847810832},{"$f":"'Forecast charges BH'!Q18","v":3239.4617847810832},{"$f":"'Forecast charges BH'!R18","v":3239.4617847810832},{"$f":"'Forecast charges BH'!S18","v":3239.4617847810832},{"$f":"'Forecast charges BH'!T18","v":3239.4617847810832},139,139,{"$f":"'Forecast charges BH'!J18","v":139},{"$f":"'Forecast charges BH'!K18","v":139},{"$f":"'Forecast charges BH'!L18","v":139},{"$f":"'Forecast charges BH'!M18","v":139},{"$f":"'Forecast charges BH'!N18","v":139}]
[null,"Service truck visit",1122881.7213370022,1150953.764370427,0,0,0,0,0,2089,2089,0,0,0,0,0]
[null,"Wasted truck visit",321045.61499999999,324256.07114999997,0,0,0,0,0,932,932,0,0,0,0,0]
[null,"Remote meter reconfiguration",375663.53995014873,383330.14280627423,{"$f":"'Forecast charges BH'!P19","v":381648.63161667256},{"$f":"'Forecast charges BH'!Q19","v":381648.63161667256},{"$f":"'Forecast charges BH'!R19","v":381648.63161667256},{"$f":"'Forecast charges BH'!S19","v":381648.63161667256},{"$f":"'Forecast charges BH'!T19","v":381648.63161667256},5768,5768,{"$f":"'Forecast charges BH'!J19","v":5768},{"$f":"'Forecast charges BH'!K19","v":5768},{"$f":"'Forecast charges BH'!L19","v":5768},{"$f":"'Forecast charges BH'!M19","v":5768},{"$f":"'Forecast charges BH'!N19","v":5768}]
[null,"Remote energisation",514138.7,523875.48599999998,0,0,0,0,0,45499,45953.99,0,0,0,0,0]
[null,"Remote de‑energisation",463639.00000000006,523875.48599999998,null,null,null,null,null,41030,45953.99,0,0,0,0,0]
[null,"Isolation of supply or reconnection, excluding HV (single)",null,null,{"$f":"'Forecast charges BH'!P34+'Forecast charges AH'!P32","v":182493.34365705983},{"$f":"'Forecast charges BH'!Q34+'Forecast charges AH'!Q32","v":188603.01237248661},{"$f":"'Forecast charges BH'!R34+'Forecast charges AH'!R32","v":188603.01237248661},{"$f":"'Forecast charges BH'!S34+'Forecast charges AH'!S32","v":188603.01237248661},{"$f":"'Forecast charges BH'!T34+'Forecast charges AH'!T32","v":188603.01237248661},null,null,{"$f":"'Forecast charges BH'!J34+'Forecast charges AH'!J32","v":550.66046668921206},{"$f":"'Forecast charges BH'!K34+'Forecast charges AH'!K32","v":550.66046668921206},{"$f":"'Forecast charges BH'!L34+'Forecast charges AH'!L32","v":550.66046668921206},{"$f":"'Forecast charges BH'!M34+'Forecast charges AH'!M32","v":550.66046668921206},{"$f":"'Forecast charges BH'!N34+'Forecast charges AH'!N32","v":550.66046668921206}]
[null,"Isolation of supply and reconnection after isolation, excluding HV (same day)",null,null,{"$f":"'Forecast charges BH'!P35","v":50487.706795800674},{"$f":"'Forecast charges BH'!Q35","v":51745.052355698164},{"$f":"'Forecast charges BH'!R35","v":51745.052355698164},{"$f":"'Forecast charges BH'!S35","v":51745.052355698164},{"$f":"'Forecast charges BH'!T35","v":51745.052355698164},null,null,{"$f":"'Forecast charges BH'!J35","v":86.18802840716944},{"$f":"'Forecast charges BH'!K35","v":86.18802840716944},{"$f":"'Forecast charges BH'!L35","v":86.18802840716944},{"$f":"'Forecast charges BH'!M35","v":86.18802840716944},{"$f":"'Forecast charges BH'!N35","v":86.18802840716944}]
[null,"Standard alteration, <60 minutes",null,null,{"$f":"'Forecast charges BH'!P36+'Forecast charges AH'!P34","v":810314.60030890617},{"$f":"'Forecast charges BH'!Q36+'Forecast charges AH'!Q34","v":837615.54722090194},{"$f":"'Forecast charges BH'!R36+'Forecast charges AH'!R34","v":837615.54722090194},{"$f":"'Forecast charges BH'!S36+'Forecast charges AH'!S34","v":837615.54722090194},{"$f":"'Forecast charges BH'!T36+'Forecast charges AH'!T34","v":837615.54722090194},null,null,{"$f":"'Forecast charges BH'!J36+'Forecast charges AH'!J34","v":1413.501521812648},{"$f":"'Forecast charges BH'!K36+'Forecast charges AH'!K34","v":1413.501521812648},{"$f":"'Forecast charges BH'!L36+'Forecast charges AH'!L34","v":1413.501521812648},{"$f":"'Forecast charges BH'!M36+'Forecast charges AH'!M34","v":1413.501521812648},{"$f":"'Forecast charges BH'!N36+'Forecast charges AH'!N34","v":1413.501521812648}]
[null,"Complex alteration, > 60 minutes",null,null,{"$f":"'Forecast charges BH'!P37+'Forecast charges AH'!P35","v":127298.75161692947},{"$f":"'Forecast charges BH'!Q37+'Forecast charges AH'!Q35","v":132933.71008370799},{"$f":"'Forecast charges BH'!R37+'Forecast charges AH'!R35","v":132933.71008370799},{"$f":"'Forecast charges BH'!S37+'Forecast charges AH'!S35","v":132933.71008370799},{"$f":"'Forecast charges BH'!T37+'Forecast charges AH'!T35","v":132933.71008370799},null,null,{"$f":"'Forecast charges BH'!J37+'Forecast charges AH'!J35","v":169.64998309097058},{"$f":"'Forecast charges BH'!K37+'Forecast charges AH'!K35","v":169.64998309097058},{"$f":"'Forecast charges BH'!L37+'Forecast charges AH'!L35","v":169.64998309097058},{"$f":"'Forecast charges BH'!M37+'Forecast charges AH'!M35","v":169.64998309097058},{"$f":"'Forecast charges BH'!N37+'Forecast charges AH'!N35","v":169.64998309097058}]
[null,"Failed field visit (unable to perform customer requested task) ",null,null,{"$f":"'Forecast charges AH'!P36+'Forecast charges BH'!P38","v":194881.92909155117},{"$f":"'Forecast charges AH'!Q36+'Forecast charges BH'!Q38","v":194881.92909155117},{"$f":"'Forecast charges AH'!R36+'Forecast charges BH'!R38","v":194881.92909155117},{"$f":"'Forecast charges AH'!S36+'Forecast charges BH'!S38","v":194881.92909155117},{"$f":"'Forecast charges AH'!T36+'Forecast charges BH'!T38","v":194881.92909155117},null,null,{"$f":"'Forecast charges BH'!J38+'Forecast charges AH'!J36","v":577},{"$f":"'Forecast charges BH'!K38+'Forecast charges AH'!K36","v":577},{"$f":"'Forecast charges BH'!L38+'Forecast charges AH'!L36","v":577},{"$f":"'Forecast charges BH'!M38+'Forecast charges AH'!M36","v":577},{"$f":"'Forecast charges BH'!N38+'Forecast charges AH'!N36","v":577}]

{"sheet":"Quoted services RIN","index":6,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,1,5,2],[8,1,9,1],[8,2,8,8],[8,9,8,15]]}
[null,"REGULATORY REPORTING STATEMENT"]
[null,"United Energy"]
[null,"2021-22 to 2025-26"]
[null,"4.4 ANCILLARY SERVICES - QUOTED SERVICES"]
[]
[null,"There are TWO tables on this worksheet. The COLUMNS representing each table have been 'grouped' for easy navigation. See the Instructions sheet on how to group or ungroup data."]
[]
[null,"4.4.1 - COST METRICS FOR QUOTED SERVICES"]
[null,"SERVICE SUBCATEGORY","EXPENDITURE \n($0's, real June 2021)",null,null,null,null,null,null,"VOLUMES (0's)"]
[null,null,"2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[null,"Connection services",12737.744999999999,12928.811174999997,null,null,null,null,null,57,57]
[null,"Ancillary services",1533310.5514499999,1563976.762479,null,null,null,null,null,680,680]
[null,"Audit design and construction",null,null,619789.69171646913,619789.69171646913,619789.69171646913,619789.69171646913,619789.69171646913,null,null,305,305,305,305,305]
[null,"Specification and design enquiry",null,null,746040.46251009672,746040.46251009672,746040.46251009672,746040.46251009672,746040.46251009672,null,null,313,313,313,313,313]
[null,"High load escorts–surveying and  lifting overhead lines",null,null,32833.822650302973,32833.822650302973,32833.822650302973,32833.822650302973,32833.822650302973,null,null,25,25,25,25,25]
[null,"No-go zone safety-related services  ",null,null,94579.166846248307,94579.166846248307,94579.166846248307,94579.166846248307,94579.166846248307,null,null,54,54,54,54,54]
[null,"Elective undergrounding ",null,null,64937.358560351706,64937.358560351706,64937.358560351706,64937.358560351706,64937.358560351706,null,null,36,36,36,36,36]
[null,"Reserve feeder maintenance",null,null,5796.260195531202,5796.260195531202,5796.260195531202,5796.260195531202,5796.260195531202,null,null,4,4,4,4,4]