{"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","CitiPower","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,185.55083074905366,-7.6587265557829576E-2,0.85,-6.5099175724155134E-2]
["Technical specialist",171.34,200.85924905559898,-0.14696484824270095,0,0]
["Engineer",150.33000000000001,179.11154174564064,-0.16069060354867459,0,0]
["Senior engineer",196.58,271.8352976732819,-0.27684152248590987,0,0]
[null,null,null,null,"Preliminary adjustment factor",{"$f":"SUM(F4:F8)","v":-9.2097904269348607E-2}]
[null,null,null,null,"Labour composition",0.9]
[null,null,null,null,"Fee-based price adjustment",{"$f":"F9*F10","v":-8.2888113842413749E-2}]
[]
["AFTER HOURS ADJUSTMENTS"]
[null,"Labour rates for 2020-21 ($June 021)"]
[null,"Marsden Jacob","CitiPower","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},219.21123360803054,{"$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},246.30074558116763,{"$f":"IF(C18<=C6*1.75,0,C6*1.75/C18-1)","v":0},0,0]
["Engineer",{"$f":"B7*1.75","v":263.07750000000004},239.30801228691195,{"$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]]}
["CitiPower 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":5934512.620491975},{"$f":"SUM('Forecast charges BH'!Q6:Q8,'Forecast charges BH'!Q10:Q12)+SUM('Forecast charges AH'!Q6:Q8,'Forecast charges AH'!Q10:Q12)","v":5758815.295764151},{"$f":"SUM('Forecast charges BH'!R6:R8,'Forecast charges BH'!R10:R12)+SUM('Forecast charges AH'!R6:R8,'Forecast charges AH'!R10:R12)","v":5651345.7122942423},{"$f":"SUM('Forecast charges BH'!S6:S8,'Forecast charges BH'!S10:S12)+SUM('Forecast charges AH'!S6:S8,'Forecast charges AH'!S10:S12)","v":5539578.1739954613},{"$f":"SUM('Forecast charges BH'!T6:T8,'Forecast charges BH'!T10:T12)+SUM('Forecast charges AH'!T6:T8,'Forecast charges AH'!T10:T12)","v":5464086.8808497302}]
["Metering and network ancilliary services fixed fee",{"$f":"'Forecast charges BH'!P38+'Forecast charges AH'!P36-'Revenue forecast'!B4","v":3137852.3068836192},{"$f":"'Forecast charges BH'!Q38+'Forecast charges AH'!Q36-'Revenue forecast'!C4","v":3286776.6394264856},{"$f":"'Forecast charges BH'!R38+'Forecast charges AH'!R36-'Revenue forecast'!D4","v":3300382.1598259034},{"$f":"'Forecast charges BH'!S38+'Forecast charges AH'!S36-'Revenue forecast'!E4","v":3313631.3899413645},{"$f":"'Forecast charges BH'!T38+'Forecast charges AH'!T36-'Revenue forecast'!F4","v":3326621.9819868244}]
["Quoted services",{"$f":"SUM('Quoted services RIN'!E12:E16)","v":10134426.294201016},{"$f":"SUM('Quoted services RIN'!F12:F16)","v":10134426.294201016},{"$f":"SUM('Quoted services RIN'!G12:G16)","v":10134426.294201016},{"$f":"SUM('Quoted services RIN'!H12:H16)","v":10134426.294201016},{"$f":"SUM('Quoted services RIN'!I12:I16)","v":10134426.294201016}]
["Total",{"$f":"SUM(B4:B6)","v":19206791.221576609},{"$f":"SUM(C4:C6)","v":19180018.229391653},{"$f":"SUM(D4:D6)","v":19086154.166321162},{"$f":"SUM(E4:E6)","v":18987635.858137842},{"$f":"SUM(F4:F6)","v":18925135.157037571}]

{"sheet":"Forecast charges BH","index":2,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[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","CitiPower 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",549.08230734404981,{"$f":"B6*(1+'AER adjustments'!$F$11)","v":503.56991054406097},{"$f":"C6","v":503.56991054406097},503.56991054406097,503.56991054406097,503.56991054406097,null,null,5136.4950984495335,4966.6771444381711,4862.8038224534157,4754.7763683747153,4681.811245157618,null,{"$f":"J6*C6","v":2586584.3772362391},2501069.165325962,2448761.6858661845,2394362.3104794705,2357619.2699082005]
["Multi-phase DC",656.26343084375151,{"$f":"B7*(1+'AER adjustments'!$F$11)","v":601.86699287736155},601.86699287736155,601.86699287736155,601.86699287736155,601.86699287736155,null,null,1972.6492451467245,1907.4313772480493,1867.5392667180577,1826.0517793051336,1798.0298319504691,null,1187272.4691782563,1148019.9871442076,1124010.2425399902,1099040.2932487363,1082174.8080598165]
["Multi-phase CT",2744.5047784469061,{"$f":"B8*(1+'AER adjustments'!$F$11)","v":2517.0179539299502},2517.0179539299502,2517.0179539299502,2517.0179539299502,2517.0179539299502,null,null,612.02264047496953,591.78852545644975,579.41183209306928,566.54016641018131,557.84624058761233,null,1540471.9742871134,1489542.3435036154,1458389.984097701,1425991.7704768882,1404109.0030913467]
["New connection where we are not the metering coordinator"]
["Single phase",528.1120875288907,{"$f":"B10*(1+'AER adjustments'!$F$11)","v":484.33787269624122},{"$f":"C10","v":484.33787269624122},484.33787269624122,484.33787269624122,484.33787269624122,null,null,0,0,0,0,0,null,{"$f":"J10*C10","v":0},0,0,0,0]
["Multi-phase DC",635.29321102859228,{"$f":"B11*(1+'AER adjustments'!$F$11)","v":582.63495502954174},582.63495502954174,582.63495502954174,582.63495502954174,582.63495502954174,null,null,0,0,0,0,0,null,0,0,0,0,0]
["Multi-phase CT",2342.960076742731,{"$f":"B12*(1+'AER adjustments'!$F$11)","v":2148.7565351734488},2148.7565351734488,2148.7565351734488,2148.7565351734488,2148.7565351734488,null,null,0,0,0,0,0,null,0,0,0,0,0]
[]
["Metering services","CitiPower 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",388.8386079245447,{"$f":"B15*(1+'AER adjustments'!$F$11)","v":356.60850912456937},{"$f":"C15","v":356.60850912456937},356.60850912456937,356.60850912456937,356.60850912456937,null,null,1883.9768182791731,1921.8636056355906,1946.5813717240196,1970.1656824391948,1992.8890302090902,null,{"$f":"J15*C15","v":671842.16439178563},685352.91514647729,694167.48086016183,702577.84674303106,710681.18591357255]
["Meter accuracy test",448.65,{"$f":"B16*(1+'AER adjustments'!$F$11)","v":411.46224772460101},411.46224772460101,411.46224772460101,411.46224772460101,411.46224772460101,null,null,50,50,50,50,50,null,20573.112386230052,20573.112386230052,20573.112386230052,20573.112386230052,20573.112386230052]
["Meter accuracy test - additional meters","N/A","To be proposed by CitiPower."]
["Special reading",32.069400198989818,{"$f":"B18*(1+'AER adjustments'!$F$11)","v":29.411228104438024},29.411228104438024,29.411228104438024,29.411228104438024,29.411228104438024,null,null,450,454.5,459.04500000000002,463.63545000000005,468.27180450000003,null,13235.05264699711,13367.403173467083,13501.077205201753,13636.087977253772,13772.448857026309]
["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.593531078437763,{"$f":"B21*(1+'AER adjustments'!$F$11)","v":54.653935690136791},{"$f":"C21","v":54.653935690136791},{"$f":"D21","v":54.653935690136791},{"$f":"E21","v":54.653935690136791},{"$f":"F21","v":54.653935690136791},null,null,1443.4987206597657,{"$f":"J21","v":1443.4987206597657},{"$f":"K21","v":1443.4987206597657},{"$f":"L21","v":1443.4987206597657},{"$f":"M21","v":1443.4987206597657},null,{"$f":"J21*C21","v":78892.886247733564},{"$f":"K21*D21","v":78892.886247733564},{"$f":"L21*E21","v":78892.886247733564},{"$f":"M21*F21","v":78892.886247733564},{"$f":"N21*G21","v":78892.886247733564}]
["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)",38.990605753746735,{"$f":"B25*(1+'AER adjustments'!$F$11)","v":35.758747985245499},{"$f":"C25","v":35.758747985245499},35.758747985245499,35.758747985245499,35.758747985245499,null,null,6469,6533.6900000000005,6599.0269000000008,6665.0171690000006,6731.6673406900009,null,{"$f":"J25*C25","v":231323.34071655312},233636.57412371869,235972.93986495587,238332.66926360544,240715.9959562415]
["Manual re-energisation (same day)",50.066830231923255,{"$f":"B26*(1+'AER adjustments'!$F$11)","v":45.916885107930796},45.916885107930796,45.916885107930796,45.916885107930796,45.916885107930796,null,null,1420,1434.2,1448.5420000000001,1463.0274200000001,1477.6576942000002,null,65201.976853261731,65853.996621794344,66512.536588012299,67177.661953892413,67849.43857343134]
["Manual de-energisation",39.575981347930153,{"$f":"B27*(1+'AER adjustments'!$F$11)","v":36.295602900537673},36.295602900537673,36.295602900537673,36.295602900537673,36.295602900537673,null,null,4534.7525791700509,4580.1001049617516,4625.9011060113689,4672.160117071483,4718.8817182421981,null,164591.57886574519,166237.49465440266,167899.86960094667,169578.86829695615,171274.65697992573]
["Service truck visit (Servicing)",593.54789659633536,{"$f":"B28*(1+'AER adjustments'!$F$11)","v":544.34983097233305},"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)",372.03488498563235,{"$f":"B29*(1+'AER adjustments'!$F$11)","v":341.19761508559395},"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":29.411228104438024},{"$f":"C30","v":29.411228104438024},29.411228104438024,29.411228104438024,29.411228104438024]
["Isolation of supply or reconnection, excluding HV (single)",{"$f":"'New charges calc'!$C$27","v":345.53276956072568},{"$f":"B31*(1+'AER adjustments'!$F$11)","v":316.89221002109173},{"$f":"'New charges calc'!D27","v":345.53276956072568},{"$f":"'New charges calc'!E27","v":345.53276956072568},{"$f":"'New charges calc'!F27","v":345.53276956072568},{"$f":"'New charges calc'!G27","v":345.53276956072568},null,null,{"$f":"'New charges calc'!C8","v":348},{"$f":"'New charges calc'!D8","v":348},{"$f":"'New charges calc'!E8","v":348},{"$f":"'New charges calc'!F8","v":348},{"$f":"'New charges calc'!G8","v":348},null,{"$f":"J31*C31","v":110278.48908733993},120245.40380713253,120245.40380713253,120245.40380713253,120245.40380713253]
["Isolation of supply and reconnection after isolation, excluding HV (same day)",{"$f":"'New charges calc'!$C$29","v":635.70721320692803},{"$f":"B32*(1+'AER adjustments'!$F$11)","v":583.01464134818855},{"$f":"'New charges calc'!D29","v":635.70721320692803},{"$f":"'New charges calc'!E29","v":635.70721320692803},{"$f":"'New charges calc'!F29","v":635.70721320692803},{"$f":"'New charges calc'!G29","v":635.70721320692803},null,null,{"$f":"'New charges calc'!C10","v":164},{"$f":"'New charges calc'!D10","v":164},{"$f":"'New charges calc'!E10","v":164},{"$f":"'New charges calc'!F10","v":164},{"$f":"'New charges calc'!G10","v":164},null,95614.40118110292,104255.9829659362,104255.9829659362,104255.9829659362,104255.9829659362]
["Standard alteration, <60 minutes",{"$f":"'New charges calc'!$C$28","v":597.09388618250728},{"$f":"B33*(1+'AER adjustments'!$F$11)","v":547.6019001700023},{"$f":"'New charges calc'!D$28","v":597.09388618250728},{"$f":"'New charges calc'!E$28","v":597.09388618250728},{"$f":"'New charges calc'!F$28","v":597.09388618250728},{"$f":"'New charges calc'!G$28","v":597.09388618250728},null,null,{"$f":"'New charges calc'!C9","v":1649},{"$f":"'New charges calc'!D9","v":1649},{"$f":"'New charges calc'!E9","v":1649},{"$f":"'New charges calc'!F9","v":1649},{"$f":"'New charges calc'!G9","v":1649},null,902995.5333803338,984607.81831495452,984607.81831495452,984607.81831495452,984607.81831495452]
["Complex alteration, > 60 minutes",{"$f":"'New charges calc'!$C$30","v":742.12930964008797},{"$f":"B34*(1+'AER adjustments'!$F$11)","v":680.61561093684838},{"$f":"'New charges calc'!D$30","v":742.12930964008797},{"$f":"'New charges calc'!E$30","v":742.12930964008797},{"$f":"'New charges calc'!F$30","v":742.12930964008797},{"$f":"'New charges calc'!G$30","v":742.12930964008797},null,null,{"$f":"'New charges calc'!C11","v":495},{"$f":"'New charges calc'!D11","v":495},{"$f":"'New charges calc'!E11","v":495},{"$f":"'New charges calc'!F11","v":495},{"$f":"'New charges calc'!G11","v":495},null,{"$f":"J34*C34","v":336904.72741373995},367354.00827184354,367354.00827184354,367354.00827184354,367354.00827184354]
["Failed field visit (unable to perform customer requested task) - complex tasks",{"$f":"$B$29","v":372.03488498563235},{"$f":"B35*(1+'AER adjustments'!$F$11)","v":341.19761508559395},{"$f":"C35","v":341.19761508559395},{"$f":"D35","v":341.19761508559395},{"$f":"E35","v":341.19761508559395},{"$f":"F35","v":341.19761508559395},null,null,1013.5283918944544,1013.5283918944544,1013.5283918944544,1013.5283918944544,1013.5283918944544,null,345813.4701359251,345813.4701359251,345813.4701359251,345813.4701359251,345813.4701359251]
[]
["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":8351595.5540083563},{"$f":"SUM(Q25:Q35,Q15:Q24,Q6:Q12)","v":8324822.5618233997},{"$f":"SUM(R25:R35,R15:R24,R6:R12)","v":8230958.4987529088},{"$f":"SUM(S25:S35,S15:S24,S6:S12)","v":8132440.1905695889},{"$f":"SUM(T25:T35,T15:T24,T6:T12)","v":8069939.4894693168}]

{"sheet":"Forecast charges AH","index":3,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,1,2,6],[1,9,1,13],[1,15,1,19],[2,9,2,13],[2,15,2,19]]}
[]
["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","CitiPower 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",608.07898487547698,{"$f":"B6*(1-'AER adjustments'!$F$23)","v":608.07898487547698},{"$f":"C6","v":608.07898487547698},608.07898487547698,608.07898487547698,608.07898487547698,null,null,30.662360142825385,30.662360142825385,30.662360142825385,30.662360142825385,30.662360142825385,null,{"$f":"J6*C6","v":18645.136829535546},18645.136829535546,18645.136829535546,18645.136829535546,18645.136829535546]
["Multi-phase DC",715.2715863280057,{"$f":"B7*(1-'AER adjustments'!$F$23)","v":715.2715863280057},715.2715863280057,715.2715863280057,715.2715863280057,715.2715863280057,null,null,550.52754262820224,550.52754262820224,550.52754262820224,550.52754262820224,550.52754262820224,null,393776.70873293298,393776.70873293298,393776.70873293298,393776.70873293298,393776.70873293298]
["Multi-phase CT",3378.5124587588593,{"$f":"B8*(1-'AER adjustments'!$F$23)","v":3378.5124587588593},3378.5124587588593,3378.5124587588593,3378.5124587588593,3378.5124587588593,null,null,61.495097846767273,61.495097846767273,61.495097846767273,61.495097846767273,61.495097846767273,null,207761.95422789833,207761.95422789833,207761.95422789833,207761.95422789833,207761.95422789833]
["New connection where we are not the metering coordinator"]
["Single phase",583.45877606129159,{"$f":"B10*(1-'AER adjustments'!$F$23)","v":583.45877606129159},{"$f":"C10","v":583.45877606129159},583.45877606129159,583.45877606129159,583.45877606129159,null,null,0,0,0,0,0,null,{"$f":"J10*C10","v":0},0,0,0,0]
["Multi-phase DC",690.63989956099374,{"$f":"B11*(1-'AER adjustments'!$F$23)","v":690.63989956099374},690.63989956099374,690.63989956099374,690.63989956099374,690.63989956099374,null,null,0,0,0,0,0,null,0,0,0,0,0]
["Multi-phase CT",2660.5779873749598,{"$f":"B12*(1-'AER adjustments'!$F$23)","v":2660.5779873749598},2660.5779873749598,2660.5779873749598,2660.5779873749598,2660.5779873749598,null,null,0,0,0,0,0,null,0,0,0,0,0]
[]
["Metering and network ancillary services","CitiPower 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",444.17381850411863,{"$f":"B15*(1-'AER adjustments'!$F$23)","v":444.17381850411863},{"$f":"C15","v":444.17381850411863},444.17381850411863,444.17381850411863,444.17381850411863,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",514.45000000000005,{"$f":"B16*(1-'AER adjustments'!$F$23)","v":514.45000000000005},514.45000000000005,514.45000000000005,514.45000000000005,514.45000000000005,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)",715.78809420522634,"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)",429.79194361173001,"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","N/A",{"$f":"C24","v":"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)",715.78809420522634,"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)",429.79194361173001,"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":441.26385703810831},{"$f":"B29*(1-'AER adjustments'!$F$23)","v":441.26385703810831},{"$f":"'New charges calc'!D57","v":441.26385703810831},{"$f":"'New charges calc'!E57","v":441.26385703810831},{"$f":"'New charges calc'!F57","v":441.26385703810831},{"$f":"'New charges calc'!G57","v":441.26385703810831},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":"J29*C29","v":13237.915711143249},{"$f":"K29*D29","v":13237.915711143249},{"$f":"L29*E29","v":13237.915711143249},{"$f":"M29*F29","v":13237.915711143249},{"$f":"N29*G29","v":13237.915711143249}]
["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":762.52087917948347},{"$f":"B31*(1-'AER adjustments'!$F$23)","v":762.52087917948347},{"$f":"'New charges calc'!D$58","v":762.52087917948347},{"$f":"'New charges calc'!E$58","v":762.52087917948347},{"$f":"'New charges calc'!F$58","v":762.52087917948347},{"$f":"'New charges calc'!G$58","v":762.52087917948347},null,null,{"$f":"'New charges calc'!C39","v":72},{"$f":"'New charges calc'!D39","v":72},{"$f":"'New charges calc'!E39","v":72},{"$f":"'New charges calc'!F39","v":72},{"$f":"'New charges calc'!G39","v":72},null,{"$f":"J31*C31","v":54901.503300922806},54901.503300922806,54901.503300922806,54901.503300922806,54901.503300922806]
["Complex alteration, > 60 minutes",{"$f":"'New charges calc'!$C$60","v":947.73888453222855},{"$f":"B32*(1-'AER adjustments'!$F$23)","v":947.73888453222855},{"$f":"'New charges calc'!D$60","v":947.73888453222855},{"$f":"'New charges calc'!E$60","v":947.73888453222855},{"$f":"'New charges calc'!F$60","v":947.73888453222855},{"$f":"'New charges calc'!G$60","v":947.73888453222855},null,null,{"$f":"'New charges calc'!C41","v":21},{"$f":"'New charges calc'!D41","v":21},{"$f":"'New charges calc'!E41","v":21},{"$f":"'New charges calc'!F41","v":21},{"$f":"'New charges calc'!G41","v":21},null,19902.5165751768,19902.5165751768,19902.5165751768,19902.5165751768,19902.5165751768]
["Failed field visit (unable to perform customer requested task) ",{"$f":"$B$28","v":429.79194361173001},{"$f":"B33*(1-'AER adjustments'!$F$23)","v":429.79194361173001},{"$f":"C33","v":429.79194361173001},{"$f":"D33","v":429.79194361173001},{"$f":"E33","v":429.79194361173001},{"$f":"F33","v":429.79194361173001},null,null,29.185372541463344,29.185372541463344,29.185372541463344,29.185372541463344,29.185372541463344,null,12543.637989627947,12543.637989627947,12543.637989627947,12543.637989627947,12543.637989627947]
[]
["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":720769.37336723763},{"$f":"SUM(Q24:Q33,Q15:Q23,Q6:Q12)","v":720769.37336723763},{"$f":"SUM(R24:R33,R15:R23,R6:R12)","v":720769.37336723763},{"$f":"SUM(S24:S33,S15:S23,S6:S12)","v":720769.37336723763},{"$f":"SUM(T24:T33,T15:T23,T6:T12)","v":720769.37336723763}]

{"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":1576463.2133598668},{"$f":"C5","v":1576463.2133598668},{"$f":"D5","v":1576463.2133598668},{"$f":"E5","v":1576463.2133598668},{"$f":"F5","v":1576463.2133598668}]
[]
["Volumes break-down",null,"2021/22","2022/23","2023/24","2024/25","2025/26"]
["Isolation of supply or reconnection, excluding HV (single)","Number",348,{"$f":"C8","v":348},348,348,348]
["Standard alteration, <60 minutes","Number",1649,1649,1649,1649,1649]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","Number",164,164,164,164,164]
["Complex alteration, > 60 minutes","Number",495,495,495,495,495]
["Total","Number",{"$f":"SUM(C8:C11)","v":2656},2656,2656,2656,2656]
[]
["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":348},{"$f":"C15","v":348},348,348,348,null,null,1]
["Standard alteration, <60 minutes","$2021",{"$f":"C9*J16","v":2849.5352830548668},2849.5352830548668,2849.5352830548668,2849.5352830548668,2849.5352830548668,null,null,1.7280383766251466]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C10*J17","v":301.72531276404374},301.72531276404374,301.72531276404374,301.72531276404374,301.72531276404374,null,null,1.8397884924636814]
["Complex alteration, > 60 minutes","$2021",{"$f":"C11*J18","v":1063.1524435116794},1063.1524435116794,1063.1524435116794,1063.1524435116794,1063.1524435116794,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":120245.40380713253},{"$f":"C21","v":120245.40380713253},120245.40380713253,120245.40380713253,120245.40380713253]
["Standard alteration, <60 minutes","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C16","v":984607.81831495452},984607.81831495452,984607.81831495452,984607.81831495452,984607.81831495452]
["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":104255.9829659362},104255.9829659362,104255.9829659362,104255.9829659362,104255.9829659362]
["Complex alteration, > 60 minutes","$2021",{"$f":"C$5/(C$15+C$16+C$17+C$18)*C18","v":367354.00827184354},367354.00827184354,367354.00827184354,367354.00827184354,367354.00827184354]
[]
["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":345.53276956072568},{"$f":"C27","v":345.53276956072568},345.53276956072568,345.53276956072568,345.53276956072568]
["Standard alteration, <60 minutes","$2021",{"$f":"C22/C9","v":597.09388618250728},597.09388618250728,597.09388618250728,597.09388618250728,597.09388618250728]
["Isolation of supply and reconnection after isolation, excluding HV (same day)","$2021",{"$f":"C23/C10","v":635.70721320692803},635.70721320692803,635.70721320692803,635.70721320692803,635.70721320692803]
["Complex alteration, > 60 minutes","$2021",{"$f":"C24/C11","v":742.12930964008797},742.12930964008797,742.12930964008797,742.12930964008797,742.12930964008797]
[]
["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":88041.935587242842},{"$f":"C35","v":88041.935587242842},{"$f":"D35","v":88041.935587242842},{"$f":"E35","v":88041.935587242842},{"$f":"F35","v":88041.935587242842}]
[]
["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",72,72,72,72,72]
["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",21,21,21,21,21]
["Total","Number",{"$f":"SUM(C38:C41)","v":123},123,123,123,123]
[]
["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":124.41876311701056},124.41876311701056,124.41876311701056,124.41876311701056,124.41876311701056,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":45.103436997465181},45.103436997465181,45.103436997465181,45.103436997465181,45.103436997465181,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":13237.915711143249},{"$f":"C51","v":13237.915711143249},13237.915711143249,13237.915711143249,13237.915711143249]
["Standard alteration, <60 minutes","$2021",{"$f":"C$35/(C$45+C$46+C$48)*C46","v":54901.503300922806},54901.503300922806,54901.503300922806,54901.503300922806,54901.503300922806]
["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":19902.5165751768},19902.5165751768,19902.5165751768,19902.5165751768,19902.5165751768]
[]
["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":441.26385703810831},{"$f":"C57","v":441.26385703810831},441.26385703810831,441.26385703810831,441.26385703810831]
["Standard alteration, <60 minutes","$2021",{"$f":"C52/C39","v":762.52087917948347},762.52087917948347,762.52087917948347,762.52087917948347,762.52087917948347]
["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":947.73888453222855},947.73888453222855,947.73888453222855,947.73888453222855,947.73888453222855]

{"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",179266.87120370977,182852.20862778398,{"$f":"SUM('Forecast charges BH'!P27)","v":164591.57886574519},{"$f":"SUM('Forecast charges BH'!Q27)","v":166237.49465440266},{"$f":"SUM('Forecast charges BH'!R27)","v":167899.86960094667},{"$f":"SUM('Forecast charges BH'!S27)","v":169578.86829695615},{"$f":"SUM('Forecast charges BH'!T27)","v":171274.65697992573},4535,4535,{"$f":"'Forecast charges BH'!J27","v":4534.7525791700509},{"$f":"'Forecast charges BH'!K27","v":4580.1001049617516},{"$f":"'Forecast charges BH'!L27","v":4625.9011060113689},{"$f":"'Forecast charges BH'!M27","v":4672.160117071483},{"$f":"'Forecast charges BH'!N27","v":4718.8817182421981}]
[null,"Re-energisation",322946.44797478057,329405.3769342762,{"$f":"SUM('Forecast charges BH'!P25:P26)","v":296525.31756981486},{"$f":"SUM('Forecast charges BH'!Q25:Q26)","v":299490.57074551302},{"$f":"SUM('Forecast charges BH'!R25:R26)","v":302485.4764529682},{"$f":"SUM('Forecast charges BH'!S25:S26)","v":305510.33121749782},{"$f":"SUM('Forecast charges BH'!T25:T26)","v":308565.43452967284},7889,7889,{"$f":"SUM('Forecast charges BH'!J25:J26)","v":7889},{"$f":"SUM('Forecast charges BH'!K25:K26)","v":7967.89},{"$f":"SUM('Forecast charges BH'!L25:L26)","v":8047.5689000000011},{"$f":"SUM('Forecast charges BH'!M25:M26)","v":8128.044589000001},{"$f":"SUM('Forecast charges BH'!N25:N26)","v":8209.3250348900001}]
[null,"MISCELLANEOUS FEE-BASED SERVICES"]
[null,"Meter/NMI investigation test",695934.7772126972,697521.10553043382,{"$f":"'Forecast charges BH'!P15","v":671842.16439178563},{"$f":"'Forecast charges BH'!Q15","v":685352.91514647729},{"$f":"'Forecast charges BH'!R15","v":694167.48086016183},{"$f":"'Forecast charges BH'!S15","v":702577.84674303106},{"$f":"'Forecast charges BH'!T15","v":710681.18591357255},1802.0837723816305,1830.4669742856763,{"$f":"'Forecast charges BH'!J15","v":1883.9768182791731},{"$f":"'Forecast charges BH'!K15","v":1921.8636056355906},{"$f":"'Forecast charges BH'!L15","v":1946.5813717240196},{"$f":"'Forecast charges BH'!M15","v":1970.1656824391948},{"$f":"'Forecast charges BH'!N15","v":1992.8890302090902}]
[null,"Meter accuracy test",21348.855717633,21566.614045952858,{"$f":"'Forecast charges BH'!P16","v":20573.112386230052},{"$f":"'Forecast charges BH'!Q16","v":20573.112386230052},{"$f":"'Forecast charges BH'!R16","v":20573.112386230052},{"$f":"'Forecast charges BH'!S16","v":20573.112386230052},{"$f":"'Forecast charges BH'!T16","v":20573.112386230052},50,50,{"$f":"'Forecast charges BH'!J16","v":50},{"$f":"'Forecast charges BH'!K16","v":50},{"$f":"'Forecast charges BH'!L16","v":50},{"$f":"'Forecast charges BH'!M16","v":50},{"$f":"'Forecast charges BH'!N16","v":50}]
[null,"Special reading",14197.940437322462,14342.759429783153,{"$f":"'Forecast charges BH'!P18","v":13235.05264699711},{"$f":"'Forecast charges BH'!Q18","v":13367.403173467083},{"$f":"'Forecast charges BH'!R18","v":13501.077205201753},{"$f":"'Forecast charges BH'!S18","v":13636.087977253772},{"$f":"'Forecast charges BH'!T18","v":13772.448857026309},450,450,{"$f":"'Forecast charges BH'!J18","v":450},{"$f":"'Forecast charges BH'!K18","v":454.5},{"$f":"'Forecast charges BH'!L18","v":459.04500000000002},{"$f":"'Forecast charges BH'!M18","v":463.63545000000005},{"$f":"'Forecast charges BH'!N18","v":468.27180450000003}]
[null,"Service truck visit",1628740,1692500,0,0,0,0,0,2627,2708,0,0,0,0,0]
[null,"Wasted truck visit",379668,383313,0,0,0,0,0,1043,1043,0,0,0,0,0]
[null,"Remote meter reconfiguration",85265,85896,{"$f":"'Forecast charges BH'!P21","v":78892.886247733564},{"$f":"'Forecast charges BH'!Q21","v":78892.886247733564},{"$f":"'Forecast charges BH'!R21","v":78892.886247733564},{"$f":"'Forecast charges BH'!S21","v":78892.886247733564},{"$f":"'Forecast charges BH'!T21","v":78892.886247733564},1443,1443,{"$f":"'Forecast charges BH'!J21","v":1443.4987206597657},{"$f":"'Forecast charges BH'!K21","v":1443.4987206597657},{"$f":"'Forecast charges BH'!L21","v":1443.4987206597657},{"$f":"'Forecast charges BH'!M21","v":1443.4987206597657},{"$f":"'Forecast charges BH'!N21","v":1443.4987206597657}]
[null,"Remote re‑energisation",487030.82045176107,496394.3463094029,null,null,null,null,null,44054.2,44054.2,0,0,0,0,0]
[null,"Remote de‑energisation",440640.93083410623,449112.57693234156,null,null,null,null,null,39858.019,39858.019,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":123516.40479848317},{"$f":"'Forecast charges BH'!Q31+'Forecast charges AH'!Q29","v":133483.31951827579},{"$f":"'Forecast charges BH'!R31+'Forecast charges AH'!R29","v":133483.31951827579},{"$f":"'Forecast charges BH'!S31+'Forecast charges AH'!S29","v":133483.31951827579},{"$f":"'Forecast charges BH'!T31+'Forecast charges AH'!T29","v":133483.31951827579},null,null,{"$f":"'Forecast charges BH'!J31+'Forecast charges AH'!J29","v":378},{"$f":"'Forecast charges BH'!K31+'Forecast charges AH'!K29","v":378},{"$f":"'Forecast charges BH'!L31+'Forecast charges AH'!L29","v":378},{"$f":"'Forecast charges BH'!M31+'Forecast charges AH'!M29","v":378},{"$f":"'Forecast charges BH'!N31+'Forecast charges AH'!N29","v":378}]
[null,"Isolation of supply and reconnection after isolation, excluding HV (same day)",null,null,{"$f":"'Forecast charges BH'!P32","v":95614.40118110292},{"$f":"'Forecast charges BH'!Q32","v":104255.9829659362},{"$f":"'Forecast charges BH'!R32","v":104255.9829659362},{"$f":"'Forecast charges BH'!S32","v":104255.9829659362},{"$f":"'Forecast charges BH'!T32","v":104255.9829659362},null,null,{"$f":"'Forecast charges BH'!J32","v":164},{"$f":"'Forecast charges BH'!K32","v":164},{"$f":"'Forecast charges BH'!L32","v":164},{"$f":"'Forecast charges BH'!M32","v":164},{"$f":"'Forecast charges BH'!N32","v":164}]
[null,"Standard alteration, <60 minutes",null,null,{"$f":"'Forecast charges BH'!P33+'Forecast charges AH'!P31","v":957897.03668125661},{"$f":"'Forecast charges BH'!Q33+'Forecast charges AH'!Q31","v":1039509.3216158773},{"$f":"'Forecast charges BH'!R33+'Forecast charges AH'!R31","v":1039509.3216158773},{"$f":"'Forecast charges BH'!S33+'Forecast charges AH'!S31","v":1039509.3216158773},{"$f":"'Forecast charges BH'!T33+'Forecast charges AH'!T31","v":1039509.3216158773},null,null,{"$f":"'Forecast charges BH'!J33+'Forecast charges AH'!J31","v":1721},{"$f":"'Forecast charges BH'!K33+'Forecast charges AH'!K31","v":1721},{"$f":"'Forecast charges BH'!L33+'Forecast charges AH'!L31","v":1721},{"$f":"'Forecast charges BH'!M33+'Forecast charges AH'!M31","v":1721},{"$f":"'Forecast charges BH'!N33+'Forecast charges AH'!N31","v":1721}]
[null,"Complex alteration, > 60 minutes",null,null,{"$f":"'Forecast charges BH'!P34+'Forecast charges AH'!P32","v":356807.24398891674},{"$f":"'Forecast charges BH'!Q34+'Forecast charges AH'!Q32","v":387256.52484702034},{"$f":"'Forecast charges BH'!R34+'Forecast charges AH'!R32","v":387256.52484702034},{"$f":"'Forecast charges BH'!S34+'Forecast charges AH'!S32","v":387256.52484702034},{"$f":"'Forecast charges BH'!T34+'Forecast charges AH'!T32","v":387256.52484702034},null,null,{"$f":"'Forecast charges BH'!J34+'Forecast charges AH'!J32","v":516},{"$f":"'Forecast charges BH'!K34+'Forecast charges AH'!K32","v":516},{"$f":"'Forecast charges BH'!L34+'Forecast charges AH'!L32","v":516},{"$f":"'Forecast charges BH'!M34+'Forecast charges AH'!M32","v":516},{"$f":"'Forecast charges BH'!N34+'Forecast charges AH'!N32","v":516}]
[null,"Failed field visit (unable to perform customer requested task) ",null,null,{"$f":"'Forecast charges AH'!P33+'Forecast charges BH'!P35","v":358357.10812555306},{"$f":"'Forecast charges AH'!Q33+'Forecast charges BH'!Q35","v":358357.10812555306},{"$f":"'Forecast charges AH'!R33+'Forecast charges BH'!R35","v":358357.10812555306},{"$f":"'Forecast charges AH'!S33+'Forecast charges BH'!S35","v":358357.10812555306},{"$f":"'Forecast charges AH'!T33+'Forecast charges BH'!T35","v":358357.10812555306},null,null,{"$f":"'Forecast charges BH'!J35+'Forecast charges AH'!J33","v":1042.7137644359177},{"$f":"'Forecast charges BH'!K35+'Forecast charges AH'!K33","v":1042.7137644359177},{"$f":"'Forecast charges BH'!L35+'Forecast charges AH'!L33","v":1042.7137644359177},{"$f":"'Forecast charges BH'!M35+'Forecast charges AH'!M33","v":1042.7137644359177},{"$f":"'Forecast charges BH'!N35+'Forecast charges AH'!N33","v":1042.7137644359177}]

{"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,"CitiPower"]
[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",4587.6840197614156,4755.6414255668915,4755.6414255668915,4755.6414255668915,4755.6414255668915,4755.6414255668915,4755.6414255668915,2,2,2,2,2,2,2]
[null,"Specification and design enquiry",7272376.6829258958,7538622.0294761546,7538622.0294761546,7538622.0294761546,7538622.0294761546,7538622.0294761546,7538622.0294761546,1015,1015,1015,1015,1015,1015,1015]
[null,"High load escorts–surveying and  lifting overhead lines",77811.735449851243,80660.461990538024,80660.461990538024,80660.461990538024,80660.461990538024,80660.461990538024,80660.461990538024,0,0,9,9,9,9,9]
[null,"No-go zone safety-related services  ",1529467.0673732583,1585461.6214433268,1585461.6214433268,1585461.6214433268,1585461.6214433268,1585461.6214433268,1585461.6214433268,836,836,836,836,836,836,836]
[null,"Elective undergrounding ",830696.38272676303,861108.59264658112,861108.59264658112,861108.59264658112,861108.59264658112,861108.59264658112,861108.59264658112,139,139,139,139,139,139,139]
[null,"Reserve feeder maintenance",66151.740354177935,68573.588644414573,68573.588644414573,68573.588644414573,68573.588644414573,68573.588644414573,68573.588644414573,17,17,17,17,17,17,17]