{"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":2,"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","Powercor","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,184.60919917804253,-7.1877237088523005E-2,0.85,-6.109565152524455E-2]
["Technical specialist",171.34,199.83993047062248,-0.14261379296672705,0,0]
["Engineer",150.33000000000001,178.2025882165224,-0.15640955889291697,0,0]
["Senior engineer",196.58,270.45579051952222,-0.27315292594628204,0,0]
[null,null,null,null,"Preliminary adjustment factor",{"$f":"SUM(F4:F8)","v":-8.8094380070438016E-2}]
[null,null,null,null,"Labour composition",0.9]
[null,null,null,null,"Fee-based price adjustment",{"$f":"F9*F10","v":-7.9284942063394218E-2}]
[]
["AFTER HOURS ADJUSTMENTS"]
[null,"Labour rates for 2020-21 ($June 021)"]
[null,"Marsden Jacob","Powercor","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},218.66907775343876,{"$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},245.69159162035407,{"$f":"IF(C18<=C6*1.75,0,C6*1.75/C18-1)","v":0},0,0]
["Engineer",{"$f":"B7*1.75","v":263.07750000000004},238.71615283802956,{"$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},311.70200001519925,{"$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]]}
["Powercor 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":15207091.588319078},{"$f":"SUM('Forecast charges BH'!Q6:Q8,'Forecast charges BH'!Q10:Q12)+SUM('Forecast charges AH'!Q6:Q8,'Forecast charges AH'!Q10:Q12)","v":15028981.361001687},{"$f":"SUM('Forecast charges BH'!R6:R8,'Forecast charges BH'!R10:R12)+SUM('Forecast charges AH'!R6:R8,'Forecast charges AH'!R10:R12)","v":15138662.861126613},{"$f":"SUM('Forecast charges BH'!S6:S8,'Forecast charges BH'!S10:S12)+SUM('Forecast charges AH'!S6:S8,'Forecast charges AH'!S10:S12)","v":15137336.089654282},{"$f":"SUM('Forecast charges BH'!T6:T8,'Forecast charges BH'!T10:T12)+SUM('Forecast charges AH'!T6:T8,'Forecast charges AH'!T10:T12)","v":15179406.161545817}]
["Metering and network ancilliary services fixed fee",{"$f":"'Forecast charges BH'!P38+'Forecast charges AH'!P36-B4","v":7699640.9902672507},{"$f":"'Forecast charges BH'!Q38+'Forecast charges AH'!Q36-C4","v":8037999.2626746316},{"$f":"'Forecast charges BH'!R38+'Forecast charges AH'!R36-D4","v":8090576.343390882},{"$f":"'Forecast charges BH'!S38+'Forecast charges AH'!S36-E4","v":8144204.9657214507},{"$f":"'Forecast charges BH'!T38+'Forecast charges AH'!T36-F4","v":8198906.1604986303}]
["Quoted services",{"$f":"SUM('Quoted services RIN'!E11:E16)","v":6910710.387844583},{"$f":"SUM('Quoted services RIN'!F11:F16)","v":6911277.8634327361},{"$f":"SUM('Quoted services RIN'!G11:G16)","v":6911854.4269184293},{"$f":"SUM('Quoted services RIN'!H11:H16)","v":6912374.4052390121},{"$f":"SUM('Quoted services RIN'!I11:I16)","v":6912850.6978637949}]
["Total",{"$f":"SUM(B4:B6)","v":29817442.96643091},{"$f":"SUM(C4:C6)","v":29978258.487109054},{"$f":"SUM(D4:D6)","v":30141093.631435923},{"$f":"SUM(E4:E6)","v":30193915.460614745},{"$f":"SUM(F4:F6)","v":30291163.019908242}]

{"sheet":"Forecast charges BH","index":2,"n_rows":38,"n_cols":20,"rows_kept":38,"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","Powercor 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",550.40227191916915,{"$f":"B6*(1+'AER adjustments'!$F$11)","v":506.76365967849728},{"$f":"C6","v":506.76365967849728},506.76365967849728,506.76365967849728,506.76365967849728,null,null,23129.777251767486,22858.867142108717,23025.688325641149,23023.665776468526,23087.649760023287,null,{"$f":"J6*C6","v":11721330.567654146},11584043.169039566,11668582.08251836,11667557.128097761,11699981.88576478]
["Multi-phase DC",681.65266249735373,{"$f":"B7*(1+'AER adjustments'!$F$11)","v":627.60787064389262},627.60787064389262,627.60787064389262,627.60787064389262,627.60787064389262,null,null,3919.2722186411902,3873.3673033029536,3901.6346585387046,3901.2919435744911,3912.1338399946135,null,2459766.0916151623,2430955.8054476432,2448696.6200758875,2448481.5294669596,2455285.9889929341]
["Multi-phase CT",2668.9683708915895,{"$f":"B8*(1+'AER adjustments'!$F$11)","v":2457.359368236418},2457.359368236418,2457.359368236418,2457.359368236418,2457.359368236418,null,null,391.25264833251117,386.67005781681803,389.49192804689307,389.45771553755674,390.54003910445363,null,961448.36072720506,950187.28899267514,957121.63823849754,957037.56580816908,959697.22376474622]
["New connection where we are not the metering coordinator"]
["Single phase",514.80914020225157,{"$f":"B10*(1+'AER adjustments'!$F$11)","v":473.99252734761029},{"$f":"C10","v":473.99252734761029},473.99252734761029,473.99252734761029,473.99252734761029,null,null,0,0,0,0,0,null,{"$f":"J10*C10","v":0},0,0,0,0]
["Multi-phase DC",646.04805282760935,{"$f":"B11*(1+'AER adjustments'!$F$11)","v":594.82617038900366},594.82617038900366,594.82617038900366,594.82617038900366,594.82617038900366,null,null,0,0,0,0,0,null,0,0,0,0,0]
["Multi-phase CT",2282.6663905418395,{"$f":"B12*(1+'AER adjustments'!$F$11)","v":2101.6853180176727},2101.6853180176727,2101.6853180176727,2101.6853180176727,2101.6853180176727,null,null,0,0,0,0,0,null,0,0,0,0,0]
[]
["Metering and network ancillary services","Powercor 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",436.04742790251362,{"$f":"B15*(1+'AER adjustments'!$F$11)","v":401.47543284437074},{"$f":"C15","v":401.47543284437074},401.47543284437074,401.47543284437074,401.47543284437074,null,null,3964,4043.28,4124.1455999999998,4206.6285120000002,4290.7610822400002,null,{"$f":"J15*C15","v":1591448.6157950857},1623277.5881109873,1655743.1398732071,1688858.0026706713,1722635.1627240847]
["Meter accuracy test",502.49,{"$f":"B16*(1+'AER adjustments'!$F$11)","v":462.65010946256507},462.65010946256507,462.65010946256507,462.65010946256507,462.65010946256507,null,null,100,100,100,100,100,null,46265.010946256509,46265.010946256509,46265.010946256509,46265.010946256509,46265.010946256509]
["Meter accuracy test - additional meters","N/A","To be proposed by Powercor."]
["Special reading",50.51447039218116,{"$f":"B18*(1+'AER adjustments'!$F$11)","v":46.509433533774036},46.509433533774036,46.509433533774036,46.509433533774036,46.509433533774036,null,null,667.91684572410827,681.27518263859042,694.90068629136226,708.7987000171895,722.97467401753329,null,31064.434142293419,31685.722825139288,32319.437281642076,32965.826027274918,33625.142547820418]
["Service truck visit (Metering)","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"]
["Wasted truck visit (Metering)","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 meter reconfiguration",59.880479899115905,{"$f":"B21*(1+'AER adjustments'!$F$11)","v":55.132859519586262},{"$f":"C21","v":55.132859519586262},{"$f":"D21","v":55.132859519586262},{"$f":"E21","v":55.132859519586262},{"$f":"F21","v":55.132859519586262},null,null,16729.485206671499,{"$f":"J21","v":16729.485206671499},{"$f":"K21","v":16729.485206671499},{"$f":"L21","v":16729.485206671499},{"$f":"M21","v":16729.485206671499},null,{"$f":"J21*C21","v":922344.35773441626},{"$f":"K21*D21","v":922344.35773441626},{"$f":"L21*E21","v":922344.35773441626},{"$f":"M21*F21","v":922344.35773441626},{"$f":"N21*G21","v":922344.35773441626}]
["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"]
["Acces to meter data","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)",57.52749956955509,{"$f":"B25*(1+'AER adjustments'!$F$11)","v":52.966435099130983},{"$f":"C25","v":52.966435099130983},52.966435099130983,52.966435099130983,52.966435099130983,null,null,10962.96447675844,11182.223766293608,11405.868241619481,11633.98560645187,11866.665318580908,null,{"$f":"J25*C25","v":580669.14645230433},592282.52938135038,604128.17996897746,616210.74356835696,628534.95843972417]
["Manual re-energisation (same day)",93.751918691964477,{"$f":"B26*(1+'AER adjustments'!$F$11)","v":86.318803250140036},86.318803250140036,86.318803250140036,86.318803250140036,86.318803250140036,null,null,1682.5501035964712,1716.2011056684007,1750.5251277817688,1785.5356303374042,1821.2463429441523,null,145235.71135084654,148140.42557786347,151103.23408942076,154125.29877120917,157207.80474663334]
["Manual de-energisation",61.154532662926883,{"$f":"B27*(1+'AER adjustments'!$F$11)","v":56.305899083832777},56.305899083832777,56.305899083832777,56.305899083832777,56.305899083832777,null,null,4065.1152762172524,4146.4175817415971,4229.3459333764295,4313.9328520439585,4400.2115090848374,null,228889.97050683561,233467.76991697232,238137.12531531177,242899.86782161804,247757.86517805039]
["Service truck visit (Servicing)",687.08173418458455,{"$f":"B28*(1+'AER adjustments'!$F$11)","v":632.60649869694339},"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 truck visit (Servicing)",377.93455273877504,{"$f":"B29*(1+'AER adjustments'!$F$11)","v":347.97003362112645},"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":46.509433533774036},{"$f":"C30","v":46.509433533774036},46.509433533774036,46.509433533774036,46.509433533774036]
["Isolation of supply or reconnection, excluding HV (single)",{"$f":"'New charges calc'!$C$27","v":399.98331371199345},{"$f":"B31*(1+'AER adjustments'!$F$11)","v":368.27065985801363},{"$f":"'New charges calc'!D27","v":399.98331371199345},{"$f":"'New charges calc'!E27","v":399.98331371199345},{"$f":"'New charges calc'!F27","v":399.98331371199345},{"$f":"'New charges calc'!G27","v":399.98331371199345},null,null,{"$f":"'New charges calc'!C8","v":689.8418674698795},{"$f":"'New charges calc'!D8","v":689.8418674698795},{"$f":"'New charges calc'!E8","v":689.8418674698795},{"$f":"'New charges calc'!F8","v":689.8418674698795},{"$f":"'New charges calc'!G8","v":689.8418674698795},null,{"$f":"J31*C31","v":254048.51973081692},275925.23608787224,275925.23608787224,275925.23608787224,275925.23608787224]
["Isolation of supply and reconnection after isolation, excluding HV (same day)",{"$f":"'New charges calc'!$C$29","v":735.88469774481621},{"$f":"B32*(1+'AER adjustments'!$F$11)","v":677.54012211878012},{"$f":"'New charges calc'!D29","v":735.88469774481621},{"$f":"'New charges calc'!E29","v":735.88469774481621},{"$f":"'New charges calc'!F29","v":735.88469774481621},{"$f":"'New charges calc'!G29","v":735.88469774481621},null,null,{"$f":"'New charges calc'!C10","v":325.09789156626505},{"$f":"'New charges calc'!D10","v":325.09789156626505},{"$f":"'New charges calc'!E10","v":325.09789156626505},{"$f":"'New charges calc'!F10","v":325.09789156626505},{"$f":"'New charges calc'!G10","v":325.09789156626505},null,220266.86515236515,239234.56367271798,239234.56367271798,239234.56367271798,239234.56367271798]
["Standard alteration, <60 minutes",{"$f":"'New charges calc'!$C$28","v":691.1865161040198},{"$f":"B33*(1+'AER adjustments'!$F$11)","v":636.38583321971328},{"$f":"'New charges calc'!D$28","v":691.1865161040198},{"$f":"'New charges calc'!E$28","v":691.1865161040198},{"$f":"'New charges calc'!F$28","v":691.1865161040198},{"$f":"'New charges calc'!G$28","v":691.1865161040198},null,null,{"$f":"'New charges calc'!C9","v":3268.8196536144578},{"$f":"'New charges calc'!D9","v":3268.8196536144578},{"$f":"'New charges calc'!E9","v":3268.8196536144578},{"$f":"'New charges calc'!F9","v":3268.8196536144578},{"$f":"'New charges calc'!G9","v":3268.8196536144578},null,2080230.5189104113,2259364.0681541259,2259364.0681541259,2259364.0681541259,2259364.0681541259]
["Complex alteration, > 60 minutes",{"$f":"'New charges calc'!$C$30","v":859.07724714505946},{"$f":"B34*(1+'AER adjustments'!$F$11)","v":790.96535737718318},{"$f":"'New charges calc'!D$30","v":859.07724714505946},{"$f":"'New charges calc'!E$30","v":859.07724714505946},{"$f":"'New charges calc'!F$30","v":859.07724714505946},{"$f":"'New charges calc'!G$30","v":859.07724714505946},null,null,{"$f":"'New charges calc'!C11","v":981.24058734939763},{"$f":"'New charges calc'!D11","v":981.24058734939763},{"$f":"'New charges calc'!E11","v":981.24058734939763},{"$f":"'New charges calc'!F11","v":981.24058734939763},{"$f":"'New charges calc'!G11","v":981.24058734939763},null,{"$f":"J34*C34","v":776127.31184581341},842961.46256712172,842961.46256712172,842961.46256712172,842961.46256712172]
["Failed field visit (unable to perform customer requested task) - complex tasks",{"$f":"$B$29","v":377.93455273877504},{"$f":"B35*(1+'AER adjustments'!$F$11)","v":347.97003362112645},{"$f":"C35","v":347.97003362112645},{"$f":"D35","v":347.97003362112645},{"$f":"E35","v":347.97003362112645},{"$f":"F35","v":347.97003362112645},null,null,2041.3119704720086,2041.3119704720086,2041.3119704720086,2041.3119704720086,2041.3119704720086,null,710315.39499635273,710315.39499635273,710315.39499635273,710315.39499635273,710315.39499635273]
[]
["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(P25:P35,P15:P24,P6:P12)","v":22729450.87756031},{"$f":"SUM(Q25:Q35,Q15:Q24,Q6:Q12)","v":22890450.393451061},{"$f":"SUM(R25:R35,R15:R24,R6:R12)","v":23052241.551520169},{"$f":"SUM(S25:S35,S15:S24,S6:S12)","v":23104546.056390885},{"$f":"SUM(T25:T35,T15:T24,T6:T12)","v":23201136.126317635}]

{"sheet":"Forecast charges AH","index":3,"n_rows":36,"n_cols":20,"rows_kept":36,"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","Powercor 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",616.87109674105523,{"$f":"B6*(1+'AER adjustments'!$F$23)","v":616.87109674105523},{"$f":"C6","v":616.87109674105523},616.87109674105523,616.87109674105523,616.87109674105523,null,null,24.435905271526877,24.151415022410706,24.328370960995528,24.327366210484335,24.395963295306622,null,{"$f":"J6*C6","v":15073.803684707318},14898.30987272289,15007.468876632551,15006.84907508276,15049.164634030323]
["Multi-phase DC",748.1100093664129,{"$f":"B7*(1+'AER adjustments'!$F$23)","v":748.1100093664129},748.1100093664129,748.1100093664129,748.1100093664129,748.1100093664129,null,null,6.6436726714087992,6.5663250113841993,6.6144360725524276,6.6141628993902879,6.6328131835810353,null,4970.1980244350179,4912.333465769545,4948.325832190736,4948.1214686138492,4962.0739328944755]
["Multi-phase CT",3310.1727276261504,{"$f":"B8*(1+'AER adjustments'!$F$23)","v":3310.1727276261504},3310.1727276261504,3310.1727276261504,3310.1727276261504,3310.1727276261504,null,null,13.444182607756256,13.287661340516751,13.385019221283841,13.38446642615726,13.422207272033972,null,44502.566613420575,43984.454183310881,44306.725585045584,44304.895737693609,44429.824456432245]
["New connection where we are not the metering coordinator"]
["Single phase",575.06839254466286,{"$f":"B10*(1+'AER adjustments'!$F$23)","v":575.06839254466286},{"$f":"C10","v":575.06839254466286},575.06839254466286,575.06839254466286,575.06839254466286,null,null,0,0,0,0,0,null,{"$f":"J10*C10","v":0},0,0,0,0]
["Multi-phase DC",706.30730517002041,{"$f":"B11*(1+'AER adjustments'!$F$23)","v":706.30730517002041},706.30730517002041,706.30730517002041,706.30730517002041,706.30730517002041,null,null,0,0,0,0,0,null,0,0,0,0,0]
["Multi-phase CT",2589.6442389033227,{"$f":"B12*(1+'AER adjustments'!$F$23)","v":2589.6442389033227},2589.6442389033227,2589.6442389033227,2589.6442389033227,2589.6442389033227,null,null,0,0,0,0,0,null,0,0,0,0,0]
[]
["Metering and network ancillary services","Powercor 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",499.54346294217424,{"$f":"B15*(1+'AER adjustments'!$F$23)","v":499.54346294217424},{"$f":"C15","v":499.54346294217424},499.54346294217424,499.54346294217424,499.54346294217424,null,null,0,0,0,0,0,null,{"$f":"J15*C15","v":0},{"$f":"K15*D15","v":0},{"$f":"L15*E15","v":0},{"$f":"M15*F15","v":0},{"$f":"N15*G15","v":0}]
["Meter accuracy test",577.61,{"$f":"B16*(1+'AER adjustments'!$F$23)","v":577.61},577.61,577.61,577.61,577.61,null,null,0,0,0,0,0,null,{"$f":"J16*C16","v":0},{"$f":"K16*D16","v":0},{"$f":"L16*E16","v":0},{"$f":"M16*F16","v":0},{"$f":"N16*G16","v":0}]
["Special reading","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 visit (Metering)","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"]
["Wasted truck visit (Metering)","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 meter reconfiguration","N/A",{"$f":"B20","v":"N/A"},{"$f":"C20","v":"N/A"},{"$f":"D20","v":"N/A"},{"$f":"E20","v":"N/A"},{"$f":"F20","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"]
["Access to meter data","N/A",{"$f":"B23","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"]
["Manual re-energisation (incl customer transfer)","N/A",{"$f":"B24","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"]
["Manual re-energisation (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"]
["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 visit (Servicing)",825.72392638343831,"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 truck visit (Servicing)",436.67871530800545,"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":509.03630216031405},{"$f":"B29*(1+'AER adjustments'!$F$23)","v":509.03630216031405},{"$f":"'New charges calc'!D57","v":509.03630216031405},{"$f":"'New charges calc'!E57","v":509.03630216031405},{"$f":"'New charges calc'!F57","v":509.03630216031405},{"$f":"'New charges calc'!G57","v":509.03630216031405},null,null,{"$f":"'New charges calc'!C38","v":33.170731707317074},{"$f":"'New charges calc'!D38","v":33.170731707317074},{"$f":"'New charges calc'!E38","v":33.170731707317074},{"$f":"'New charges calc'!F38","v":33.170731707317074},{"$f":"'New charges calc'!G38","v":33.170731707317074},null,{"$f":"J29*C29","v":16885.106608244565},{"$f":"K29*D29","v":16885.106608244565},{"$f":"L29*E29","v":16885.106608244565},{"$f":"M29*F29","v":16885.106608244565},{"$f":"N29*G29","v":16885.106608244565}]
["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":879.63426522837665},{"$f":"B31*(1+'AER adjustments'!$F$23)","v":879.63426522837665},{"$f":"'New charges calc'!D$58","v":879.63426522837665},{"$f":"'New charges calc'!E$58","v":879.63426522837665},{"$f":"'New charges calc'!F$58","v":879.63426522837665},{"$f":"'New charges calc'!G$58","v":879.63426522837665},null,null,{"$f":"'New charges calc'!C39","v":79.609756097560975},{"$f":"'New charges calc'!D39","v":79.609756097560975},{"$f":"'New charges calc'!E39","v":79.609756097560975},{"$f":"'New charges calc'!F39","v":79.609756097560975},{"$f":"'New charges calc'!G39","v":79.609756097560975},null,{"$f":"J31*C31","v":70027.469309888329},70027.469309888329,70027.469309888329,70027.469309888329,70027.469309888329]
["Complex alteration, > 60 minutes",{"$f":"'New charges calc'!$C$60","v":1093.2993706623988},{"$f":"B32*(1+'AER adjustments'!$F$23)","v":1093.2993706623988},{"$f":"'New charges calc'!D$60","v":1093.2993706623988},{"$f":"'New charges calc'!E$60","v":1093.2993706623988},{"$f":"'New charges calc'!F$60","v":1093.2993706623988},{"$f":"'New charges calc'!G$60","v":1093.2993706623988},null,null,{"$f":"'New charges calc'!C41","v":23.219512195121954},{"$f":"'New charges calc'!D41","v":23.219512195121954},{"$f":"'New charges calc'!E41","v":23.219512195121954},{"$f":"'New charges calc'!F41","v":23.219512195121954},{"$f":"'New charges calc'!G41","v":23.219512195121954},null,25385.878070014725,25385.878070014725,25385.878070014725,25385.878070014725,25385.878070014725]
["Failed field visit (unable to perform customer requested task) ",{"$f":"$B$28","v":436.67871530800545},{"$f":"B33*(1+'AER adjustments'!$F$23)","v":436.67871530800545},{"$f":"C33","v":436.67871530800545},{"$f":"D33","v":436.67871530800545},{"$f":"E33","v":436.67871530800545},{"$f":"F33","v":436.67871530800545},null,null,1,1,1,1,1,null,436.67871530800545,436.67871530800545,436.67871530800545,436.67871530800545,436.67871530800545]
[]
["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(P24:P33,P15:P23,P6:P12)","v":177281.70102601853},{"$f":"SUM(Q24:Q33,Q15:Q23,Q6:Q12)","v":176530.23022525894},{"$f":"SUM(R24:R33,R15:R23,R6:R12)","v":176997.65299732451},{"$f":"SUM(S24:S33,S15:S23,S6:S12)","v":176994.99898484585},{"$f":"SUM(T24:T33,T15:T23,T6:T12)","v":177176.19572681267}]

{"sheet":"New charges calc","index":4,"n_rows":60,"n_cols":10,"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'!B28","v":3617485.3304818375},{"$f":"C5","v":3617485.3304818375},{"$f":"D5","v":3617485.3304818375},{"$f":"E5","v":3617485.3304818375},{"$f":"F5","v":3617485.3304818375}]
[]
["Volumes break-down",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","Number",689.8418674698795,{"$f":"C8","v":689.8418674698795},689.8418674698795,689.8418674698795,689.8418674698795]
["Standard alteration, <60 minutes","Number",3268.8196536144578,3268.8196536144578,3268.8196536144578,3268.8196536144578,3268.8196536144578]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","Number",325.09789156626505,325.09789156626505,325.09789156626505,325.09789156626505,325.09789156626505]
["Complex alteration, > 60 minutes","Number",981.24058734939763,981.24058734939763,981.24058734939763,981.24058734939763,981.24058734939763]
["Total","Number",5265,5265,5265,5265,5265]
[]
["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":689.8418674698795},{"$f":"C15","v":689.8418674698795},689.8418674698795,689.8418674698795,689.8418674698795,null,null,1]
["Standard alteration, <60 minutes","$2021",{"$f":"C9*J16","v":5648.6458077123016},5648.6458077123016,5648.6458077123016,5648.6458077123016,5648.6458077123016,null,null,1.7280383766251466]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C10*J17","v":598.11135982782014},598.11135982782014,598.11135982782014,598.11135982782014,598.11135982782014,null,null,1.8397884924636814]
["Complex alteration, > 60 minutes","$2021",{"$f":"C11*J18","v":2107.4915719461565},2107.4915719461565,2107.4915719461565,2107.4915719461565,2107.4915719461565,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":275925.23608787224},{"$f":"C21","v":275925.23608787224},275925.23608787224,275925.23608787224,275925.23608787224]
["Standard alteration, <60 minutes","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C16","v":2259364.0681541259},2259364.0681541259,2259364.0681541259,2259364.0681541259,2259364.0681541259]
["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":239234.56367271798},239234.56367271798,239234.56367271798,239234.56367271798,239234.56367271798]
["Complex alteration, > 60 minutes","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C18","v":842961.46256712172},842961.46256712172,842961.46256712172,842961.46256712172,842961.46256712172]
[]
["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":399.98331371199345},{"$f":"C27","v":399.98331371199345},399.98331371199345,399.98331371199345,399.98331371199345]
["Standard alteration, <60 minutes","$2021",{"$f":"C22/C9","v":691.1865161040198},691.1865161040198,691.1865161040198,691.1865161040198,691.1865161040198]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C23/C10","v":735.88469774481621},735.88469774481621,735.88469774481621,735.88469774481621,735.88469774481621]
["Complex alteration, > 60 minutes","$2021",{"$f":"C24/C11","v":859.07724714505946},859.07724714505946,859.07724714505946,859.07724714505946,859.07724714505946]
[]
["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'!B27","v":112298.45398814761},{"$f":"C35","v":112298.45398814761},{"$f":"D35","v":112298.45398814761},{"$f":"E35","v":112298.45398814761},{"$f":"F35","v":112298.45398814761}]
[]
["Volumes break-down",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","Number",33.170731707317074,{"$f":"C38","v":33.170731707317074},33.170731707317074,33.170731707317074,33.170731707317074]
["Standard alteration, <60 minutes","Number",79.609756097560975,79.609756097560975,79.609756097560975,79.609756097560975,79.609756097560975]
["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",23.219512195121954,23.219512195121954,23.219512195121954,23.219512195121954,23.219512195121954]
["Total","Number",136,136,136,136,136]
[]
["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":33.170731707317074},{"$f":"C45","v":33.170731707317074},33.170731707317074,33.170731707317074,33.170731707317074,null,null,1]
["Standard alteration, <60 minutes","$2021",{"$f":"C39*J46","v":137.56871369035312},137.56871369035312,137.56871369035312,137.56871369035312,137.56871369035312,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":49.870466924026552},49.870466924026552,49.870466924026552,49.870466924026552,49.870466924026552,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":16885.106608244565},{"$f":"C51","v":16885.106608244565},16885.106608244565,16885.106608244565,16885.106608244565]
["Standard alteration, <60 minutes","$2021",{"$f":"C$35/(C$45+C$46+C$48)*C46","v":70027.469309888329},70027.469309888329,70027.469309888329,70027.469309888329,70027.469309888329]
["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":25385.878070014729},25385.878070014729,25385.878070014729,25385.878070014729,25385.878070014729]
[]
["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":509.03630216031405},{"$f":"C57","v":509.03630216031405},509.03630216031405,509.03630216031405,509.03630216031405]
["Standard alteration, <60 minutes","$2021",{"$f":"C52/C39","v":879.63426522837665},879.63426522837665,879.63426522837665,879.63426522837665,879.63426522837665]
["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":1093.2993706623988},1093.2993706623988,1093.2993706623988,1093.2993706623988,1093.2993706623988]

{"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,"CitiPower"]
[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",235084.05459554718,240313.26430597052,{"$f":"SUM('Forecast charges BH'!P27)","v":228889.97050683561},{"$f":"SUM('Forecast charges BH'!Q27)","v":233467.76991697232},{"$f":"SUM('Forecast charges BH'!R27)","v":238137.12531531177},{"$f":"SUM('Forecast charges BH'!S27)","v":242899.86782161804},{"$f":"SUM('Forecast charges BH'!T27)","v":247757.86517805039},3907.2618956336528,3985.4071335463259,{"$f":"'Forecast charges BH'!J27","v":4065.1152762172524},{"$f":"'Forecast charges BH'!K27","v":4146.4175817415971},{"$f":"'Forecast charges BH'!L27","v":4229.3459333764295},{"$f":"'Forecast charges BH'!M27","v":4313.9328520439585},{"$f":"'Forecast charges BH'!N27","v":4400.2115090848374}]
[null,"Re-energisation",687913.22667134344,703215.16848542076,{"$f":"SUM('Forecast charges BH'!P25:P26)","v":725904.8578031509},{"$f":"SUM('Forecast charges BH'!Q25:Q26)","v":740422.95495921385},{"$f":"SUM('Forecast charges BH'!R25:R26)","v":755231.41405839822},{"$f":"SUM('Forecast charges BH'!S25:S26)","v":770336.04233956616},{"$f":"SUM('Forecast charges BH'!T25:T26)","v":785742.76318635745},12154,12398,{"$f":"SUM('Forecast charges BH'!J25:J26)","v":12645.514580354911},{"$f":"SUM('Forecast charges BH'!K25:K26)","v":12898.424871962008},{"$f":"SUM('Forecast charges BH'!L25:L26)","v":13156.393369401248},{"$f":"SUM('Forecast charges BH'!M25:M26)","v":13419.521236789275},{"$f":"SUM('Forecast charges BH'!N25:N26)","v":13687.91166152506}]
[null,"MISCELLANEOUS FEE-BASED SERVICES"]
[null,"Meter/NMI /site investigation",1642067.4039952857,1677256.4314270185,{"$f":"'Forecast charges BH'!P15","v":1591448.6157950857},{"$f":"'Forecast charges BH'!Q15","v":1623277.5881109873},{"$f":"'Forecast charges BH'!R15","v":1655743.1398732071},{"$f":"'Forecast charges BH'!S15","v":1688858.0026706713},{"$f":"'Forecast charges BH'!T15","v":1722635.1627240847},3865,3925,{"$f":"'Forecast charges BH'!J15","v":3964},{"$f":"'Forecast charges BH'!K15","v":4043.28},{"$f":"'Forecast charges BH'!L15","v":4124.1455999999998},{"$f":"'Forecast charges BH'!M15","v":4206.6285120000002},{"$f":"'Forecast charges BH'!N15","v":4290.7610822400002}]
[null,"Meter accuracy test",47363.73305993923,47467.9332726711,{"$f":"'Forecast charges BH'!P16","v":46265.010946256509},{"$f":"'Forecast charges BH'!Q16","v":46265.010946256509},{"$f":"'Forecast charges BH'!R16","v":46265.010946256509},{"$f":"'Forecast charges BH'!S16","v":46265.010946256509},{"$f":"'Forecast charges BH'!T16","v":46265.010946256509},100,100,{"$f":"'Forecast charges BH'!J16","v":100},{"$f":"'Forecast charges BH'!K16","v":100},{"$f":"'Forecast charges BH'!L16","v":100},{"$f":"'Forecast charges BH'!M16","v":100},{"$f":"'Forecast charges BH'!N16","v":100}]
[null,"Special reading",33194.046648662603,33267.073551289657,{"$f":"'Forecast charges BH'!P18","v":31064.434142293419},{"$f":"'Forecast charges BH'!Q18","v":31685.722825139288},{"$f":"'Forecast charges BH'!R18","v":32319.437281642076},{"$f":"'Forecast charges BH'!S18","v":32965.826027274918},{"$f":"'Forecast charges BH'!T18","v":33625.142547820418},667.91684572410827,667.91684572410827,{"$f":"'Forecast charges BH'!J18","v":667.91684572410827},{"$f":"'Forecast charges BH'!K18","v":681.27518263859042},{"$f":"'Forecast charges BH'!L18","v":694.90068629136226},{"$f":"'Forecast charges BH'!M18","v":708.7987000171895},{"$f":"'Forecast charges BH'!N18","v":722.97467401753329}]
[null,"Service truck visit",3678178,3696970,0,0,0,0,0,5207,5207,0,0,0,0,0]
[null,"Wasted truck visit",247940,795990,0,0,0,0,0,644,2041,0,0,0,0,0]
[null,"Remote meter reconfiguration",962071.62252231047,981705.73726766382,{"$f":"'Forecast charges BH'!P21","v":922344.35773441626},{"$f":"'Forecast charges BH'!Q21","v":922344.35773441626},{"$f":"'Forecast charges BH'!R21","v":922344.35773441626},{"$f":"'Forecast charges BH'!S21","v":922344.35773441626},{"$f":"'Forecast charges BH'!T21","v":922344.35773441626},16729,16729,{"$f":"'Forecast charges BH'!J21","v":16729.485206671499},{"$f":"'Forecast charges BH'!K21","v":16729.485206671499},{"$f":"'Forecast charges BH'!L21","v":16729.485206671499},{"$f":"'Forecast charges BH'!M21","v":16729.485206671499},{"$f":"'Forecast charges BH'!N21","v":16729.485206671499}]
[null,"Remote re‑energisation",778287.52867666015,858282.8137632279,0,0,0,0,0,70042,77071.619542619548,0,0,0,0,0]
[null,"Remote de‑energisation",645824.64027606533,757619.56300881016,null,null,null,null,null,58121,68032.314968814986,0,0,0,0,0]
[null,"Isolation of supply or reconnection, excluding HV (single)",null,null,{"$f":"'Forecast charges BH'!P31+'Forecast charges AH'!P29","v":270933.62633906148},{"$f":"'Forecast charges BH'!Q31+'Forecast charges AH'!Q29","v":292810.34269611683},{"$f":"'Forecast charges BH'!R31+'Forecast charges AH'!R29","v":292810.34269611683},{"$f":"'Forecast charges BH'!S31+'Forecast charges AH'!S29","v":292810.34269611683},{"$f":"'Forecast charges BH'!T31+'Forecast charges AH'!T29","v":292810.34269611683},null,null,{"$f":"'Forecast charges BH'!J31+'Forecast charges AH'!J29","v":723.01259917719653},{"$f":"'Forecast charges BH'!K31+'Forecast charges AH'!K29","v":723.01259917719653},{"$f":"'Forecast charges BH'!L31+'Forecast charges AH'!L29","v":723.01259917719653},{"$f":"'Forecast charges BH'!M31+'Forecast charges AH'!M29","v":723.01259917719653},{"$f":"'Forecast charges BH'!N31+'Forecast charges AH'!N29","v":723.01259917719653}]
[null,"Isolation of supply and reconnection after isolation, excluding HV (same day)",null,null,{"$f":"'Forecast charges BH'!P32","v":220266.86515236515},{"$f":"'Forecast charges BH'!Q32","v":239234.56367271798},{"$f":"'Forecast charges BH'!R32","v":239234.56367271798},{"$f":"'Forecast charges BH'!S32","v":239234.56367271798},{"$f":"'Forecast charges BH'!T32","v":239234.56367271798},null,null,{"$f":"'Forecast charges BH'!J32","v":325.09789156626505},{"$f":"'Forecast charges BH'!K32","v":325.09789156626505},{"$f":"'Forecast charges BH'!L32","v":325.09789156626505},{"$f":"'Forecast charges BH'!M32","v":325.09789156626505},{"$f":"'Forecast charges BH'!N32","v":325.09789156626505}]
[null,"Standard alteration, <60 minutes",null,null,{"$f":"'Forecast charges BH'!P33+'Forecast charges AH'!P31","v":2150257.9882202996},{"$f":"'Forecast charges BH'!Q33+'Forecast charges AH'!Q31","v":2329391.5374640143},{"$f":"'Forecast charges BH'!R33+'Forecast charges AH'!R31","v":2329391.5374640143},{"$f":"'Forecast charges BH'!S33+'Forecast charges AH'!S31","v":2329391.5374640143},{"$f":"'Forecast charges BH'!T33+'Forecast charges AH'!T31","v":2329391.5374640143},null,null,{"$f":"'Forecast charges BH'!J33+'Forecast charges AH'!J31","v":3348.4294097120187},{"$f":"'Forecast charges BH'!K33+'Forecast charges AH'!K31","v":3348.4294097120187},{"$f":"'Forecast charges BH'!L33+'Forecast charges AH'!L31","v":3348.4294097120187},{"$f":"'Forecast charges BH'!M33+'Forecast charges AH'!M31","v":3348.4294097120187},{"$f":"'Forecast charges BH'!N33+'Forecast charges AH'!N31","v":3348.4294097120187}]
[null,"Complex alteration, > 60 minutes",null,null,{"$f":"'Forecast charges BH'!P34+'Forecast charges AH'!P32","v":801513.18991582817},{"$f":"'Forecast charges BH'!Q34+'Forecast charges AH'!Q32","v":868347.34063713648},{"$f":"'Forecast charges BH'!R34+'Forecast charges AH'!R32","v":868347.34063713648},{"$f":"'Forecast charges BH'!S34+'Forecast charges AH'!S32","v":868347.34063713648},{"$f":"'Forecast charges BH'!T34+'Forecast charges AH'!T32","v":868347.34063713648},null,null,{"$f":"'Forecast charges BH'!J34+'Forecast charges AH'!J32","v":1004.4600995445196},{"$f":"'Forecast charges BH'!K34+'Forecast charges AH'!K32","v":1004.4600995445196},{"$f":"'Forecast charges BH'!L34+'Forecast charges AH'!L32","v":1004.4600995445196},{"$f":"'Forecast charges BH'!M34+'Forecast charges AH'!M32","v":1004.4600995445196},{"$f":"'Forecast charges BH'!N34+'Forecast charges AH'!N32","v":1004.4600995445196}]
[null,"Failed field visit (unable to perform customer requested task) ",null,null,{"$f":"'Forecast charges AH'!P33+'Forecast charges BH'!P35","v":710752.07371166069},{"$f":"'Forecast charges AH'!Q33+'Forecast charges BH'!Q35","v":710752.07371166069},{"$f":"'Forecast charges AH'!R33+'Forecast charges BH'!R35","v":710752.07371166069},{"$f":"'Forecast charges AH'!S33+'Forecast charges BH'!S35","v":710752.07371166069},{"$f":"'Forecast charges AH'!T33+'Forecast charges BH'!T35","v":710752.07371166069},null,null,{"$f":"'Forecast charges BH'!J35+'Forecast charges AH'!J33","v":2042.3119704720086},{"$f":"'Forecast charges BH'!K35+'Forecast charges AH'!K33","v":2042.3119704720086},{"$f":"'Forecast charges BH'!L35+'Forecast charges AH'!L33","v":2042.3119704720086},{"$f":"'Forecast charges BH'!M35+'Forecast charges AH'!M33","v":2042.3119704720086},{"$f":"'Forecast charges BH'!N35+'Forecast charges AH'!N33","v":2042.3119704720086}]

{"sheet":"Quoted services RIN","index":6,"n_rows":16,"n_cols":16,"rows_kept":16,"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,"Powercor"]
[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,"Audit design and construction",2641732.832833298,2738447.9927097415,2738447.9927097415,2738447.9927097415,2738447.9927097415,2738447.9927097415,2738447.9927097415,1279,1279,1279,1279,1279,1279,1279]
[null,"Specification and design enquiry",3179852.1511013582,3296268.1282792543,3296268.1282792543,3296268.1282792543,3296268.1282792543,3296268.1282792543,3296268.1282792543,436,436,436,436,436,436,436]
[null,"High load escorts–surveying and  lifting overhead lines",139947.77338505737,145071.33134257101,145071.33134257101,145071.33134257101,145071.33134257101,145071.33134257101,145071.33134257101,30,30,30,30,30,30,30]
[null,"No-go zone safety-related services  ",403125.2757169946,417883.89362363162,417883.89362363162,417883.89362363162,417883.89362363162,417883.89362363162,417883.89362363162,248,248,248,248,248,248,248]
[null,"Elective undergrounding ",276782.84179147985,286916.00002088683,286916.00002088683,286916.00002088683,286916.00002088683,286916.00002088683,286916.00002088683,74,74,74,74,74,74,74]
[null,"Reserve feeder maintenance",24705.430036716847,25609.90818307607,26123.041868497708,26690.517456651054,27267.080942343608,27787.059262926541,28263.351887709548,4,4,4,4,4,4,4]