{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["JEN changes","Index","Input|Setup","Input|Escalations","Input|Indirect Cost Rates","Input|Labour Rates","Calc|Labour Rates","Output|Labour Rates","MJ- hays categories_Rates","Model Validation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":97,"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":"JEN changes","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["JEN changes"]
[]
["Input/Escalations","cells G43-M43"]
["Calc/Labour rates","D18"]
["MK-hays categories_Rates","row 16"]

{"sheet":"Index","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"JEN 2026-27 - Labour Rates"]
[null,{"$f":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255),\"\")","v":"Index"},"Overall Check:",{"$f":"'Model Validation'!C4","v":0}]
[]
[]
[null,"Worksheet summary"]
[]
[null,"Worksheet name","Check:",null,null,"Input required?",null,"Description"]
[]
[null,{"$f":"'Output|Labour Rates'!B2","v":"Output|Labour Rates"},"NA",null,null,"N",null,"Contains the caclulated price for labour rates."]
[null,"Input | Setup"]
[null,{"$f":"'Input|Labour Rates'!B2","v":"Input|Labour Rates"},{"$f":"'Input|Labour Rates'!G1","v":0},null,null,"Y",null,"Input for labour cost components."]
[null,{"$f":"'Input|Escalations'!B2","v":"Input|Escalations"},{"$f":"'Input|Escalations'!G1","v":0},null,null,"Y",null,"Sets up the inflation and labour escalations."]
[null,{"$f":"'Input|Indirect Cost Rates'!B2","v":"Input|Indirect Cost Rates"},{"$f":"'Input|Indirect Cost Rates'!G1","v":"NA"},null,null,"Y",null,"Input for indirect cost rates."]
[null,{"$f":"'Calc|Labour Rates'!B2","v":"Calc|Labour Rates"},"NA",null,null,"N",null,"Calculation tables for labour rates."]
[null,{"$f":"'Model Validation'!B2","v":"Model Validation"},{"$f":"'Model Validation'!C14","v":"NA"},null,null,"N",null,"Checks and traces possible input errors."]
[]
[]
[null,"Table summary"]
[]
[null,"Name","Tab",null,null,"Input required?",null,"Description"]
[null,{"$f":"'Output|Labour Rates'!$B$4","v":"1.1 Labour Rates for 2026-27"},{"$f":"B9","v":"Output|Labour Rates"}]
[null,{"$f":"'Input|Setup'!A5 & \" \" & 'Input|Setup'!B5","v":"2.1 Years setup"},{"$f":"B10","v":"Input | Setup"},null,null,"Y",null,"Contains the cummary of calculate labour rates used to provide services for 2024-25."]
[null,{"$f":"'Input|Setup'!A10 & \" \" & 'Input|Setup'!B10","v":"2.2 Current regulatory period"},{"$f":"$B$10","v":"Input | Setup"},null,null,"Y",null,"Contains the regulatory years of the current regulatory control period."]
[null,{"$f":"'Input|Setup'!D10 & \" \" & 'Input|Setup'!E10","v":"2.3 Forecast regulatory period"},"Input | Setup",null,null,"Y",null,"Contains the regulatory years of the forthcoming regulatory control period."]
[null,{"$f":"'Input|Setup'!A19& \" \" & 'Input|Setup'!B19","v":"2.4 Hours"},"Input | Setup",null,null,"Y",null,"Please enter time periods that would result in different rates applied for the same service or labour type (e.g. business hours, after hours)."]
[null,{"$f":"'Input|Setup'!D19 & \" \" & 'Input|Setup'!E19","v":" "},"Input | Setup",null,null,"Y",null,"Please list the assumptions factored into this model, for calculating the final labour rate."]
[null,{"$f":"'Input|Setup'!A25& \" \" & 'Input|Setup'!B25","v":"2.5 Labour type"},"Input | Setup",null,null,"Y",null,"Please enter the specific labour types used to provide fee based and quoted services."]
[null,{"$f":"'Input|Setup'!D25 & \" \" & 'Input|Setup'!E25","v":"2.6 Expense Type"},"Input | Setup",null,null,"Y",null,"Please enter distributor-specific categories for fee-based services, if required."]
[null,{"$f":"'Input|Setup'!G25 & \" \" & 'Input|Setup'!H25","v":"2.7 Control Mechanism"},"Input | Setup",null,null,"Y",null,"Please enter distributor-specific categories for fee-based services, if required."]
[null,{"$f":"'Input|Labour Rates'!A5 & \" \" & 'Input|Labour Rates'!B5","v":"3.1 Labour Rates"},{"$f":"$B$11","v":"Input|Labour Rates"},null,null,"Y",null,"Please enter required information regarding labour rates (in base year dollar terms) used to provide ANS. For on-cost and overhead rates, please use formulas to reference tables 5.1 and 5.2, respectively."]
[null,{"$f":" 'Input|Labour Rates'!J5","v":"3.2 Notes and sources "},{"$f":"$B$11","v":"Input|Labour Rates"},null,null,"Y",null,"Please describe \"Other costs\" used to derive total labour rates, where appropriate, and provide sources."]
[null,{"$f":"'Input|Labour Rates'!A21 & \" \" & 'Input|Labour Rates'!B21","v":"3.3 Assumptions"},{"$f":"$B$11","v":"Input|Labour Rates"},null,null,"Y",null,"Please describe assumptions used to derive total labour rates, where appropriate, and provide sources."]
[null,{"$f":" 'Input|Labour Rates'!J21","v":"3.4 Notes and sources"},{"$f":"$B$11","v":"Input|Labour Rates"},null,null,"Y",null,"Please describe \"Other costs\" used to derive total labour rates, where appropriate, and provide sources."]
[null,{"$f":"'Input|Escalations'!A5 & \" \" & 'Input|Escalations'!B5","v":"4.1 Escalation setup"},{"$f":"$B$12","v":"Input|Escalations"},null,null,"Y",null,"Please enter ABS index, all groups CPI inflation series A2325846C, up to latest available December. Please enter forecast CPI, including source, for other years."]
[null,{"$f":"'Input|Escalations'!A13 & \" \" & 'Input|Escalations'!B13","v":"4.2 Inflation"},{"$f":"$B$12","v":"Input|Escalations"},null,null,"Y",null,"Calculates X factor (real wage price escalation). Other real escalators are set to equal X factor by default, but can be amended by distributors."]
[null,{"$f":"'Input|Escalations'!A34 & \" \" & 'Input|Escalations'!B34","v":"4.3.1 Real wage price escalation"},{"$f":"$B$12","v":"Input|Escalations"},null,null,"Y",null,"Please enter sources and forecasts for real wage price escalation, including weightings for each source, in the green input cells. Grey cells will calculate the forecast real wage price escalation."]
[null,{"$f":"'Input|Indirect Cost Rates'!A5 & \" \" & 'Input|Indirect Cost Rates'!B5","v":"5.1 On costs"},{"$f":"$B$13","v":"Input|Indirect Cost Rates"},null,null,"Y",null,"Please enter relevant on-cost rates. Distributors may enter a total on-cost rate only. Alternatively, disaggregated on-cost rates may be provided with the total on-cost rate calculated in row 19, as required."]
[null,{"$f":"'Input|Indirect Cost Rates'!A22 & \" \" & 'Input|Indirect Cost Rates'!B22","v":"5.2 Overheads"},{"$f":"$B$13","v":"Input|Indirect Cost Rates"},null,null,"Y",null,"Please enter rates for network overhead and corporate overhead. Where relevant, distributors may enter other overhead rates (e.g. a total overhead rate)."]
[null,{"$f":"'Input|Indirect Cost Rates'!A32 & \" \" & 'Input|Indirect Cost Rates'!B32","v":"5.3 Vehicle Allowance"},{"$f":"$B$13","v":"Input|Indirect Cost Rates"},null,null,"N",null,"Please enter base vehicle allowance, if required."]
[null,{"$f":"'Calc|Labour Rates'!A5 & \" \" & 'Calc|Labour Rates'!B5","v":"6.1 Labour Rates ($2024-25)"},{"$f":"$B$14","v":"Calc|Labour Rates"},null,null,"N",null,"Please enter required information regarding labour rates (in base year dollar terms) used to provide ACS. For on-cost and overhead rates, please use formulas to reference tables 5.1 and 5.2, respectively."]
[null,{"$f":"'Calc|Labour Rates'!G5","v":"6.2 Labour Rates Build up, $'s ($2026-27)"},{"$f":"$B$14","v":"Calc|Labour Rates"},null,null,"N",null,"Calculates the base labour rates and factors in overheads, on costs, vehcle allowances, etc."]

{"sheet":"Input|Setup","index":2,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR(Index!$B$1,0)","v":"JEN 2026-27 - Labour Rates"},null,null,"Key:","Input",null,"Sheet Validation",0]
[null,{"$f":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255),\"\")","v":"Input|Setup"},null,null,null,"Formula"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For AER only"]
[2.1,"Years setup",null,null,"Year",{"$f":"IF(COUNTA(E6:E7)=0,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,"Years"]
[null,"First year of forecast regulatory control period",null,null,"2026-27",null,null,null,null,null,null,null,null,null,null,null,"2016-17"]
[null,"Base year for inputs",null,null,"2024-25",null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(Q6,4)+1&\"-\"&RIGHT(Q6,2)+1","v":"2017-18"}]
[null,"Base year for outputs",null,null,{"$f":"E6","v":"2026-27"},null,null,null,null,null,null,null,null,null,null,null,"2018-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-20"]
[2.2000000000000002,"Current regulatory period",null,2.2999999999999998,"Forecast regulatory period",null,null,null,null,null,null,null,null,null,null,null,"2020-21"]
[1,{"$f":"LEFT(B12,4)-1&\"-\"&RIGHT(B12,2)-1","v":"2021-22"},null,1,{"$f":"E6","v":"2026-27"},null,null,null,null,null,null,null,null,null,null,null,"2021-22"]
[{"$f":"A11+1","v":2},{"$f":"LEFT(B13,4)-1&\"-\"&RIGHT(B13,2)-1","v":"2022-23"},null,{"$f":"D11+1","v":2},{"$f":"LEFT(E11,4)+1&\"-\"&RIGHT(E11,2)+1","v":"2027-28"},null,null,null,null,null,null,null,null,null,null,null,"2022-23"]
[{"$f":"A12+1","v":3},{"$f":"LEFT(B14,4)-1&\"-\"&RIGHT(B14,2)-1","v":"2023-24"},null,{"$f":"D12+1","v":3},{"$f":"LEFT(E12,4)+1&\"-\"&RIGHT(E12,2)+1","v":"2028-29"},null,null,null,null,null,null,null,null,null,null,null,"2023-24"]
[{"$f":"A13+1","v":4},{"$f":"LEFT(B15,4)-1&\"-\"&RIGHT(B15,2)-1","v":"2024-25"},null,{"$f":"D13+1","v":4},{"$f":"LEFT(E13,4)+1&\"-\"&RIGHT(E13,2)+1","v":"2029-30"},null,null,null,null,null,null,null,null,null,null,null,"2024-25"]
[{"$f":"A14+1","v":5},{"$f":"LEFT(E11,4)-1&\"-\"&RIGHT(E11,2)-1","v":"2025-26"},null,{"$f":"D14+1","v":5},{"$f":"LEFT(E14,4)+1&\"-\"&RIGHT(E14,2)+1","v":"2030-31"},null,null,null,null,null,null,null,null,null,null,null,"2025-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2028-29"]
[2.4,"Hours",{"$f":"IF(COUNTA(B20:B22)=0,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"2034-35"]
[null,"Business Hours"]
[null,"After Hours"]
[null,"Not Applicable"]
[]
[]
[2.5,"Labour type",{"$f":"IF(COUNTA(B26:B31)=0,1,0)","v":0},2.6,"Expense Type",{"$f":"IF(COUNTA(E26:E31)=0,1,0)","v":0},2.7,"Control Mechanism",{"$f":"IF(COUNTA(H26:H31)=0,1,0)","v":0}]
[1,"Administrative Officer",null,null,"Capex",null,null,"Fee Based"]
[{"$f":"A26+1","v":2},"Field Worker",null,null,"Opex"]
[{"$f":"A27+1","v":3},"Technical Specialist"]
[{"$f":"A28+1","v":4},"Engineer"]
[{"$f":"A29+1","v":5},"Senior Engineer"]
[{"$f":"A30+1","v":6}]

{"sheet":"Input|Escalations","index":3,"n_rows":74,"n_cols":14,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR([1]Index!B1,\"\")","v":"Jemena Electricity Networks – Alternative Control Services Forecast model"},"Key: ","Input",null,"Sheet Validation ",{"$f":"'[1]Model Validation'!C11","v":0}]
[null,{"$f":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255),\"\")","v":"Input|Escalations"},null,"Formula"]
[]
[]
[4.0999999999999996,"Escalation setup"]
[]
[null,null,"Year"]
[null,"First year of forecast regulatory control period",{"$f":"'[1]Input|Setup'!E6","v":"2026-27"}]
[null,"Base year for inputs",{"$f":"'[1]Input|Setup'!E7","v":"2024-25"}]
[null,"Base year for outputs",{"$f":"'[1]Input|Setup'!E8","v":"2026-27"}]
[]
[]
[4.2,"Inflation",null,"Current regulatory period",null,null,null,null,"Forecast regulatory period"]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E15,4)-1&IF(MID(E15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E15,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F15,4)-1&IF(MID(F15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F15,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G15,4)-1&IF(MID(G15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G15,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H15,4)-1&IF(MID(H15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H15,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I15,4)-1&IF(MID(I15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I15,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I15,4)+1&IF(MID(I15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I15,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J15,4)+1&IF(MID(J15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J15,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K15,4)+1&IF(MID(K15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K15,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L15,4)+1&IF(MID(L15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L15,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"CPI year on year change (%) - lagged one year (actual/estimate)",null,8.6058519793459354E-3,{"$f":"IFERROR(E20/D20-1,0)","v":3.4982935153583528E-2},7.8318219291014124E-2,4.0519877675840865E-2,2.4246877296105973E-2,2.6000000000000023E-2,2.5800000000000045E-2,2.5500000000000078E-2,2.53000000000001E-2,2.4999999999999911E-2]
[null,"Cumulative Inflation Index ",null,1,{"$f":"IFERROR(D17*(1+E16),\"\")","v":1.0349829351535835},{"$f":"E17*(1+F16)","v":1.1160409556313993},1.1612627986348121,1.189419795221843,1.220344709897611,1.2518296034129694,1.2837512583000004,1.3162301651349906,1.3491359192633652]
[null,{"$f":"IFERROR(\"Real \"&C9 &\" \"&LEFT(D9,9)&\" to \"& \"Real \"&C10 &\" \"&LEFT(D10,9),\"\")","v":"Real 2024-25  to Real 2026-27 "},null,null,{"$f":"I17/E17","v":1.1790964550700744},{"$f":"I17/F17","v":1.0934587155963305},{"$f":"I17/G17","v":1.0508772961058048},null,{"$f":"I$17/INDEX($D$15:$M$17,3, MATCH($C$9,$D$15:$M$15,0))","v":1.0508772961058048}]
[null,"ABS index, all groups CPI inflation series A2325846C, weighted average for the eight capital cities",null,"Dec-20","Dec-21","Dec-22","Dec-23","Dec-24","Dec-25","Dec-26","Dec-27","Dec-28","Dec-29"]
[null,null,null,117.2,121.3,130.80000000000001,136.1,139.4,{"$f":"H20*(1+I21)","v":143.02440000000001},{"$f":"I20*(1+J21)","v":146.71442952000001},{"$f":"J20*(1+K21)","v":150.45564747276003},{"$f":"K20*(1+L21)","v":154.26217535382088},{"$f":"L20*(1+M21)","v":158.1187297376664},{"$f":"IF(COUNTA(D20:M20)=0,1,0)","v":0}]
[null,"Source (forecasts): RBA, Statement on Monetary Policy, Economic Outlook, Nov 2024",null,null,null,null,null,null,2.5999999999999999E-2,2.58E-2,2.5499999999999998E-2,2.53E-2,2.5000000000000001E-2,{"$f":"IF(COUNTA(G21:M21)=0,1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"G17/E17","v":1.1220115416323164}]
[]
[4.3,"Real price escalation",null,"Current regulatory period",null,null,null,null,"Forecast regulatory period"]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E26,4)-1&IF(MID(E26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E26,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F26,4)-1&IF(MID(F26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F26,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G26,4)-1&IF(MID(G26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G26,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H26,4)-1&IF(MID(H26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H26,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I26,4)-1&IF(MID(I26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I26,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I26,4)+1&IF(MID(I26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I26,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J26,4)+1&IF(MID(J26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J26,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K26,4)+1&IF(MID(K26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K26,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L26,4)+1&IF(MID(L26,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L26,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"X-factor (real wage price escalation)",null,{"$f":"-D37","v":2.8120407869096802E-2},3.8748358757266073E-2,8.8043290719790369E-3,-1.8251668270074514E-2,-1.2760766141320486E-2,-8.1208180725738932E-3,-9.5505821675600684E-3,-1.1199334904118818E-2,-1.2274361918209287E-2,-1.2025416152939058E-2]
[null,"Materials",null,0,0,0,0,0,0,0,0,0,0]
[null,"Contracts",null,0,0,0,0,0,0,0,0,0,0]
[null,"Vehicles",null,0,0,0,0,0,0,0,0,0,0]
[null,"Other",null,0,0,0,0,0,0,0,0,0,0]
[]
[]
["4.3.1","Real wage price escalation",null,"Current regulatory period",null,null,null,null,"Forecast regulatory period"]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E36,4)-1&IF(MID(E36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E36,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F36,4)-1&IF(MID(F36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F36,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G36,4)-1&IF(MID(G36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G36,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H36,4)-1&IF(MID(H36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H36,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I36,4)-1&IF(MID(I36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I36,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I36,4)+1&IF(MID(I36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I36,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J36,4)+1&IF(MID(J36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J36,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K36,4)+1&IF(MID(K36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K36,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L36,4)+1&IF(MID(L36,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L36,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"Labour - Real wage price growth",null,{"$f":"SUM((D42*D48),(D43*D49)+D44)","v":-2.8120407869096802E-2},-3.8748358757266073E-2,-8.8043290719790369E-3,1.8251668270074514E-2,1.2760766141320486E-2,8.1208180725738932E-3,9.5505821675600684E-3,1.1199334904118818E-2,1.2274361918209287E-2,1.2025416152939058E-2]
[null,"Cumulative Labour - Wage price growth index",null,{"$f":"1+D37","v":0.97187959213090325},{"$f":"IFERROR(D38*(1+E37),\"\")","v":0.93422085302614954},0.92599566521020238,0.94289663091114584,0.9549287143136419,0.96268351667485985,0.97187770470221879,0.98276208860302527,0.99482486615803412,1.0067880491728762]
[null,{"$f":"\"Escalate from base year to \" & C8","v":"Escalate from base year to 2026-27"},null,null,{"$f":"I38/E38","v":1.0304667398040981},{"$f":"I38/F38","v":1.0396198954736244},{"$f":"I38/G38","v":1.0209852120741947},null,{"$f":"I38/INDEX($D$36:$M$38,3,MATCH($C$9,$D$36:$M$36,0))","v":1.0209852120741947}]
[null,null,null,null,null,null,{"$f":"G38/E38","v":1.0092866455045331}]
[null,"Forecast/Source",null,{"$f":"IFERROR((LEFT(E41,4)-1&IF(MID(E41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E41,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F41,4)-1&IF(MID(F41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F41,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G41,4)-1&IF(MID(G41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G41,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H41,4)-1&IF(MID(H41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H41,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I41,4)-1&IF(MID(I41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I41,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I41,4)+1&IF(MID(I41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I41,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J41,4)+1&IF(MID(J41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J41,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K41,4)+1&IF(MID(K41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K41,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L41,4)+1&IF(MID(L41,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L41,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"},{"$f":"IF(COUNTA(B42:M45)=0,1,0)","v":0}]
[null,"WPI - Real labour price growth - Deloitte WPI",null,null,null,-1.2515048324812428E-2,1.1960765272050367E-2,6.7749431604970933E-3,6.6742534384085506E-3,9.1898693689420607E-3,1.0844237001720769E-2,1.0677567182329151E-2,1.0220337553900727E-2]
[null,"WPI - Oxford Economics actual and forecast October 2024",null,-2.8120407869096802E-2,-4.374835875726607E-2,-1.5093609819145648E-2,{"$f":"'[2]Input| Prices'!K40","v":1.4542571268098659E-2},{"$f":"'[2]Input| Prices'!L40","v":8.7465891221438774E-3},{"$f":"'[2]Input| Prices'!M40","v":9.5673827067392376E-3},{"$f":"'[2]Input| Prices'!N40","v":9.9112949661780761E-3},{"$f":"'[2]Input| Prices'!O40","v":1.1554432806516867E-2},{"$f":"'[2]Input| Prices'!P40","v":1.3871156654089422E-2},{"$f":"'[2]Input| Prices'!Q40","v":1.3830494751977387E-2}]
[null,"Real Labour Price Growth - Super Guarantee",null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3]
[]
[]
[null,"Weights (per cent)",null,{"$f":"IFERROR((LEFT(E47,4)-1&IF(MID(E47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E47,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F47,4)-1&IF(MID(F47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F47,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G47,4)-1&IF(MID(G47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G47,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H47,4)-1&IF(MID(H47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H47,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I47,4)-1&IF(MID(I47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I47,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I47,4)+1&IF(MID(I47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I47,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J47,4)+1&IF(MID(J47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J47,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K47,4)+1&IF(MID(K47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K47,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L47,4)+1&IF(MID(L47,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L47,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"},{"$f":"IF(COUNTA(D48:M51)=0,1,0)","v":0}]
[null,{"$f":"B42","v":"WPI - Real labour price growth - Deloitte WPI"},null,null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,{"$f":"B43","v":"WPI - Oxford Economics actual and forecast October 2024"},null,1,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,{"$f":"B44","v":"Real Labour Price Growth - Super Guarantee"}]
[null,{"$f":"B45","v":0}]
[null,null,null,{"$f":"IF(OR(SUM(D48:D51)=0,SUM(D48:D51)=1),0,1)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(D52:M52)=0,0,1)","v":0}]
[]
["4.3.2","Real price escalation (non-wage)",null,"Current regulatory period",null,null,null,null,"Forecast regulatory period"]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E56,4)-1&IF(MID(E56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E56,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F56,4)-1&IF(MID(F56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F56,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G56,4)-1&IF(MID(G56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G56,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H56,4)-1&IF(MID(H56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H56,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I56,4)-1&IF(MID(I56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I56,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I56,4)+1&IF(MID(I56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I56,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J56,4)+1&IF(MID(J56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J56,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K56,4)+1&IF(MID(K56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K56,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L56,4)+1&IF(MID(L56,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L56,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"Materials - Real price growth",null,{"$f":"-D$28","v":0},0,0,0,0,0,0,0,0,0]
[null,"Cumulative Labour - Wage price growth index",null,{"$f":"1+D57","v":1},{"$f":"IFERROR(D58*(1+E57),\"\")","v":1},1,1,1,1,1,1,1,1]
[null,{"$f":"\"Escalate from base year to \" & C28","v":"Escalate from base year to "},null,null,null,null,null,null,{"$f":"I58/INDEX($D$56:$M$58,3,MATCH($C$9,$D$56:$M$56,0))","v":1}]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E61,4)-1&IF(MID(E61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E61,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F61,4)-1&IF(MID(F61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F61,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G61,4)-1&IF(MID(G61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G61,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H61,4)-1&IF(MID(H61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H61,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I61,4)-1&IF(MID(I61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I61,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I61,4)+1&IF(MID(I61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I61,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J61,4)+1&IF(MID(J61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J61,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K61,4)+1&IF(MID(K61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K61,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L61,4)+1&IF(MID(L61,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L61,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"Contracts - Real price growth",null,{"$f":"-D$29","v":0},0,0,0,0,0,0,0,0,0]
[null,"Cumulative Labour - Wage price growth index",null,{"$f":"1+D62","v":1},{"$f":"IFERROR(D63*(1+E62),\"\")","v":1},1,1,1,1,1,1,1,1]
[null,{"$f":"\"Escalate from base year to \" & C33","v":"Escalate from base year to "},null,null,null,null,null,null,{"$f":"I63/INDEX($D$61:$M$63,3,MATCH($C$9,$D$61:$M$61,0))","v":1}]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E66,4)-1&IF(MID(E66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E66,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F66,4)-1&IF(MID(F66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F66,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G66,4)-1&IF(MID(G66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G66,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H66,4)-1&IF(MID(H66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H66,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I66,4)-1&IF(MID(I66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I66,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I66,4)+1&IF(MID(I66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I66,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J66,4)+1&IF(MID(J66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J66,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K66,4)+1&IF(MID(K66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K66,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L66,4)+1&IF(MID(L66,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L66,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"Vehicles - Real price growth",null,{"$f":"-D$30","v":0},0,0,0,0,0,0,0,0,0]
[null,"Cumulative Labour - Wage price growth index",null,{"$f":"1+D67","v":1},{"$f":"IFERROR(D68*(1+E67),\"\")","v":1},1,1,1,1,1,1,1,1]
[null,{"$f":"\"Escalate from base year to \" & C38","v":"Escalate from base year to "},null,null,null,null,null,null,{"$f":"I68/INDEX($D$66:$M$68,3,MATCH($C$9,$D$66:$M$66,0))","v":1}]
[]
[null,null,null,{"$f":"IFERROR((LEFT(E71,4)-1&IF(MID(E71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(E71,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(F71,4)-1&IF(MID(F71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F71,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(G71,4)-1&IF(MID(G71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G71,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(H71,4)-1&IF(MID(H71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H71,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(I71,4)-1&IF(MID(I71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I71,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(I71,4)+1&IF(MID(I71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I71,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(J71,4)+1&IF(MID(J71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J71,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(K71,4)+1&IF(MID(K71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K71,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(L71,4)+1&IF(MID(L71,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L71,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"Other - Real price growth",null,{"$f":"-D$31","v":0},0,0,0,0,0,0,0,0,0]
[null,"Cumulative Labour - Wage price growth index",null,{"$f":"1+D72","v":1},{"$f":"IFERROR(D73*(1+E72),\"\")","v":1},1,1,1,1,1,1,1,1]
[null,{"$f":"\"Escalate from base year to \" & C43","v":"Escalate from base year to "},null,null,null,null,null,null,{"$f":"I73/INDEX($D$71:$M$73,3,MATCH($C$9,$D$71:$M$71,0))","v":1}]

{"sheet":"Input|Indirect Cost Rates","index":4,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[28,5,28,9],[34,2,34,3]]}
[null,{"$f":"'Input|Setup'!$B$1","v":"JEN 2026-27 - Labour Rates"},"Key:","Input",null,"Sheet Validation","NA"]
[null,{"$f":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255),\"\")","v":"Input|Indirect Cost Rates"},null,"Formula"]
[]
[]
[5.0999999999999996,"On costs"]
[]
[null,"On cost drivers","Unit","Administrative Officer (BH)","Field Worker (BH)","Technical Specialist (BH)","Senior Engineer (BH)","Engineer (BH)","Field Worker (AH)","Notes"]
[null,"Standard leave (annual leave, sick leave, public holidays)","Per cent",0.17150000000000001,0.18779999999999999,0.17150000000000001,0.17150000000000001,0.17150000000000001,0,"Source: Sections 17, 20 and 26 of Jemena Asset Management Enterprise Agreement (Vic) 2021"]
[null,"Superannuation","Per cent",0.12,0.12,0.12,0.12,0.12,0.12,"Source: Section 19(2) of the Superannuation Guarantee (Administration) Act 1992."]
[null,"Workcover Insurance","Per cent",6.5100000000000002E-3,6.5100000000000002E-3,6.5100000000000002E-3,6.5100000000000002E-3,6.5100000000000002E-3,6.5100000000000002E-3,"Source: Workcover Premiums Order No.32 2024/25"]
[null,"Payroll tax","Per cent",5.8500000000000003E-2,5.8500000000000003E-2,5.8500000000000003E-2,5.8500000000000003E-2,5.8500000000000003E-2,5.8500000000000003E-2,"Source: State Revenue Office https://www.sro.vic.gov.au/payroll-tax"]
[null,"Annual leave loading","Per cent",0.02,0.02,0.02,0.02,0.02,0,"Source: Section 17.7 of Jemena Asset Management Enterprise Agreement (Vic) 2021"]
[null,"Long Service leave allowance","Per cent",2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,0,"Source: Section 19.1 of Jemena Asset Management Enterprise Agreement (Vic) 2021"]
[null,"Non-chargeable time","Per cent",0,0,0,0,0,0]
[null,"Other","Per cent",0,0,0,0,0,0]
[null,"Allowances","Per cent",0,7.0000000000000001E-3,0,0,0,0,"Source: Section 36 of Jemena Asset Management Enterprise Agreement (Vic) 2021"]
[null,"Training & Development","Per cent",0,0,7.571406071948044E-3,7.571406071948044E-3,7.571406071948044E-3,0,"Source: Section 39 of Jemena Asset Management Enterprise Agreement (Vic) 2021"]
[null,"Safety Meetings/Toolbox Talks","Per cent"]
[null,"Compounded on cost factor","Per cent",{"$f":"PRODUCT(1+D8:D17)-1","v":0.46148145609559954},{"$f":"PRODUCT(1+E8:E17)-1","v":0.4921889093172902},{"$f":"PRODUCT(1+F8:F17)-1","v":0.47254692566632128},{"$f":"PRODUCT(1+G8:G17)-1","v":0.47254692566632128},{"$f":"PRODUCT(1+H8:H17)-1","v":0.47254692566632128},{"$f":"PRODUCT(1+I8:I17)-1","v":0.19323773520000009}]
[]
[]
[5.2,"Overheads"]
[]
[null,"Type of Overhead","Unit","Input","Type","Notes"]
[null,"Network Overhead","Per cent",0.20932904037438799,"Capex","Marden Jacob Associates, Review of ancillary network services: CitiPower, Powercor, United Energy, Jemena and AusNet, Advice to the Australian Energy Regulator, 30 Jun 2020"]
[null,"Network Overhead","Per cent",0.2093290403743884,"Opex","Marden Jacob Associates, Review of ancillary network services: CitiPower, Powercor, United Energy, Jemena and AusNet, Advice to the Australian Energy Regulator, 30 Jun 2020"]
[null,"Corporate Overhead","Per cent",0.40097153765012611,"Capex","Marden Jacob Associates, Review of ancillary network services: CitiPower, Powercor, United Energy, Jemena and AusNet, Advice to the Australian Energy Regulator, 30 Jun 2020"]
[null,"Corporate Overhead","Per cent",0.40097153765012611,"Opex","Marden Jacob Associates, Review of ancillary network services: CitiPower, Powercor, United Energy, Jemena and AusNet, Advice to the Australian Energy Regulator, 30 Jun 2020"]
[null,null,"Per cent"]
[]
[]
[5.3,"Vehicle Allowance",null,"",null,null,{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""}]
[]
[null,"Vehicle costs","Notes",null,null,null," ($Jan21-Jun21)",{"$f":"'Input|Escalations'!$G$15","v":"2024-25"}]
[null,"Vehicle allowance for Fleet Worker","Marden Jacob Associates, Review of ancillary network services: CitiPower, Powercor, United Energy, Jemena and AusNet, Advice to the Australian Energy Regulator, 30 Jun 2020",null,null,null,20,22.440230832646332]

{"sheet":"Input|Labour Rates","index":5,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR(Index!B1,\"\")","v":"JEN 2026-27 - Labour Rates"},null,"Key:","Input","Sheet Validation",{"$f":"SUM(I8:I18)+SUM(K8:K18)+SUM(K24:K30)","v":0}]
[null,{"$f":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255),\"\")","v":"Input|Labour Rates"},null,null,"Formula"]
[]
[]
[3.1,"Labour Rates",null,null,null,null,null,null,null,"3.2 Notes and sources "]
[]
[null,"Labour category","Hours",{"$f":"\"Base labour rate ($\" & 'Input|Setup'!E7 & \")\"","v":"Base labour rate ($2024-25)"},{"$f":"'Input|Indirect Cost Rates'!$B$5 &\"\n(%)\"","v":"On costs\n(%)"},{"$f":"'Input|Indirect Cost Rates'!$B$22 & \"\n(%)\"","v":"Overheads\n(%)"}]
[1,"Administrative Officer","Business hours",{"$f":"'Calc|Labour Rates'!D8/'Input|Labour Rates'!C29/'Input|Labour Rates'!C28","v":45.424262612803581},{"$f":"'Input|Indirect Cost Rates'!$D$19","v":0.46148145609559954},{"$f":"SUM('Input|Indirect Cost Rates'!D26,'Input|Indirect Cost Rates'!D28)","v":0.61030057802451454},null,null,null,"AER Att 11-04 ACS Fee based and quoted services model-Draft Decision"]
[{"$f":"A8+1","v":2},"Field Worker","Business hours",{"$f":"'Calc|Labour Rates'!D9/'Input|Labour Rates'!C29/'Input|Labour Rates'!C28","v":76.016674870542317},{"$f":"'Input|Indirect Cost Rates'!$E$19","v":0.4921889093172902},{"$f":"$F$8","v":0.61030057802451454},null,null,null,"Base labour rates are taken from Hays Salary Guide 2022-23 (escalated to $2024-25) for Vic-Melbourne and applying the AER's labour rate methodology"]
[3,"Technical Specialist","Business hours",{"$f":"'Calc|Labour Rates'!D10/'Input|Labour Rates'!C29/'Input|Labour Rates'!C28","v":76.016674870542317},{"$f":"'Input|Indirect Cost Rates'!$F$19","v":0.47254692566632128},{"$f":"$F$8","v":0.61030057802451454},null,null,null,"Base labour rates are taken from Hays Salary Guide 2022-23 (escalated to $2024-25) for Vic-Melbourne and applying the AER's labour rate methodology"]
[4,"Engineer","Business hours",{"$f":"'Calc|Labour Rates'!D11/'Input|Labour Rates'!C29/'Input|Labour Rates'!C28","v":100.9428058062302},{"$f":"'Input|Indirect Cost Rates'!$H$19","v":0.47254692566632128},{"$f":"$F$8","v":0.61030057802451454},null,null,null,"AER Att 11-04 ACS Fee based and quoted services model-Draft Decision"]
[5,"Senior Engineer","Business hours",{"$f":"'Calc|Labour Rates'!D12/'Input|Labour Rates'!C29/'Input|Labour Rates'!C28","v":121.13136696747624},{"$f":"'Input|Indirect Cost Rates'!$G$19","v":0.47254692566632128},{"$f":"$F$8","v":0.61030057802451454},null,null,null,"AER Att 11-04 ACS Fee based and quoted services model-Draft Decision"]
[6,"Administrative Officer","After Hours",0,0,0,null,null,null,"Base labour rates are taken from Hays Salary Guide 2024-25 for Vic-Melbourne and applying the AER\"s labour rate methodology"]
[7,"Field Worker*","After Hours",{"$f":"'Calc|Labour Rates'!D13/'Input|Labour Rates'!C29/'Input|Labour Rates'!C28","v":187.65912519033992},{"$f":"'Input|Indirect Cost Rates'!$I$19","v":0.19323773520000009},{"$f":"$F$8","v":0.61030057802451454},null,null,null,"Base labour rates are taken from Hays Salary Guide 2022-23 (escalated to $2024-25) for Vic-Melbourne and applying the AER's labour rate methodology"]
[8,"Technical Specialist","After Hours",0,0,0]
[9,"Engineer","After Hours",0,0,0]
[10,"Senior Engineer","After Hours",0,0,0]
[11]
[null,null,null,null,null,null,null,null,null,"AER Att 11-04 ACS Fee based and quoted services model-Draft Decision"]
[]
[3.3,"Assumptions",null,null,null,null,null,null,null,"3.4 Notes and sources"]
[]
[null,null,"Administrative officer,Technical Specialist,Engineer, Senior Engineer","Field Worker (BH)","Field Worker (AH)"]
[null,"Overhead rate ",{"$f":"SUM('Input|Indirect Cost Rates'!D26:D27)","v":0.61030057802451454},{"$f":"$C$24","v":0.61030057802451454},{"$f":"$C$24","v":0.61030057802451454},null,null,null,null,"Based on Network and Corporate overhead percentages in the Input|Indirect Cost Rates tab"]
[null,"On-costs",{"$f":"'Input|Indirect Cost Rates'!D19","v":0.46148145609559954},{"$f":"'Input|Indirect Cost Rates'!E19","v":0.4921889093172902},{"$f":"'Input|Indirect Cost Rates'!I19","v":0.19323773520000009},null,null,null,null,"Based on cost percentages in the Input|Indirect Cost Rates tab"]
[]
[]
[null,"Weeks",52.14,null,null,null,null,null,null,"Review of ancillary network service: CitiPower, Poweror, Imoted Energy, Jemen and Ausnet - Advice to AER 30 Jun 2020. A Mardson Jacob Report"]
[null,"Hours per week",38,null,null,null,null,null,null,"Review of ancillary network service: CitiPower, Poweror, Imoted Energy, Jemen and Ausnet - Advice to AER 30 Jun 2020. A Mardson Jacob Report"]
[null,"Wage Measure Stickiness",2.5000000000000001E-2,null,null,null,null,null,null,"Review of ancillary network service: CitiPower, Poweror, Imoted Energy, Jemen and Ausnet - Advice to AER 30 Jun 2020. A Mardson Jacob Report"]

{"sheet":"Calc|Labour Rates","index":6,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR(Index!B1,\"\")","v":"JEN 2026-27 - Labour Rates"},"Key:","Input",null,null,"Sheet Validation","NA"]
[null,{"$f":"IFERROR(MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255),\"\")","v":"Calc|Labour Rates"},null,"Formula"]
[]
[]
[6.1,{"$f":"\"Labour Rates ($\" & 'Input|Setup'!E7 & \")\"","v":"Labour Rates ($2024-25)"},null,"",null,null,{"$f":"\"6.2 Labour Rates Build up, $'s ($2026-27)\"","v":"6.2 Labour Rates Build up, $'s ($2026-27)"},null,{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""},{"$f":"IFERROR(\"9.2 Year 1 labour rates build up, $'s ($\"&#REF!&\")\",\"\")","v":""}]
[]
[null,{"$f":"'Input|Labour Rates'!B7","v":"Labour category"},{"$f":"'Input|Labour Rates'!C7","v":"Hours"},{"$f":"\"Base labour rate\"","v":"Base labour rate"},"TOTAL LABOUR RATE (incl. On Costs & Overheads)",null,"BASE LABOUR RATE\n($/hour)","On costs","STANDARD LABOUR RATE (EXCL OVERHEADS)","Overhead","STANDARD LABOUR RATE (INCL OVERHEADS)","Wage Measure Stickiness","Vehicle and Other costs"]
[1,"Administrative Officer",{"$f":"IF(ISBLANK('Input|Labour Rates'!C8),\"\",'Input|Labour Rates'!C8)","v":"Business hours"},{"$f":"'MJ- hays categories_Rates'!E8*10^3","v":90000},{"$f":"G8+H8+J8+L8+M8","v":117.56646786655396},null,{"$f":"'Input|Labour Rates'!D8*'Input|Escalations'!G18*'Input|Escalations'!G39","v":48.737062217394822},{"$f":"IFERROR(G8*('Input|Labour Rates'!E8),\"\")","v":22.49125043790519},{"$f":"SUM(G8:H8)","v":71.228312655300016},{"$f":"IFERROR(I8*'Input|Labour Rates'!F8,0)","v":43.470680385240442},{"$f":"SUM(I8:J8)","v":114.69899304054046},{"$f":"K8*'Input|Labour Rates'!$C$30","v":2.8674748260135114}]
[{"$f":"A8+1","v":2},"Field Worker",{"$f":"IF(ISBLANK('Input|Labour Rates'!C9),\"\",'Input|Labour Rates'!C9)","v":"Business hours"},{"$f":"D18*'Input|Escalations'!G22*'Input|Escalations'!G40","v":150613.35825450291},224.95599243835682,null,{"$f":"'Input|Labour Rates'!D9*'Input|Escalations'!G18*'Input|Escalations'!G39","v":81.56058457800539},{"$f":"IFERROR(G9*('Input|Labour Rates'!E9),0)","v":40.143215166729071},121.70379974473445,{"$f":"IFERROR(I9*'Input|Labour Rates'!F9,0)","v":74.275899331991198},195.97969907672564,{"$f":"K9*'Input|Labour Rates'!$C$30","v":4.8994924769181409},{"$f":"'Input|Indirect Cost Rates'!$H$35*'Input|Escalations'!G18*'Input|Escalations'!G39","v":24.076800884713027}]
[3,"Technical Specialist",{"$f":"IF(ISBLANK('Input|Labour Rates'!C10),\"\",'Input|Labour Rates'!C10)","v":"Business hours"},{"$f":"D19*'Input|Escalations'!G22*'Input|Escalations'!G40","v":150613.35825450291},222.31177911410575,null,{"$f":"'Input|Labour Rates'!D10*'Input|Escalations'!G18*'Input|Escalations'!G39","v":81.56058457800539},{"$f":"IFERROR(G10*('Input|Labour Rates'!E10),0)","v":38.541203497884425},120.10178807588981,{"$f":"IFERROR(I10*'Input|Labour Rates'!F10,0)","v":73.298190684493306},193.39997876038314,{"$f":"K10*'Input|Labour Rates'!$C$30","v":4.8349994690095786},{"$f":"'Input|Indirect Cost Rates'!$H$35*'Input|Escalations'!G18*'Input|Escalations'!G39","v":24.076800884713027}]
[4,"Engineer",{"$f":"IF(ISBLANK('Input|Labour Rates'!C11),\"\",'Input|Labour Rates'!C11)","v":"Business hours"},{"$f":"'MJ- hays categories_Rates'!E6*10^3","v":200000},263.23691407825851,null,{"$f":"'Input|Labour Rates'!D11*'Input|Escalations'!G18*'Input|Escalations'!G39","v":108.30458270532185},{"$f":"IFERROR(G11*('Input|Labour Rates'!E11),0)","v":51.178997592973673},159.48358029829552,{"$f":"IFERROR(I11*'Input|Labour Rates'!F11,0)","v":97.332921241468839},256.81650153976437,{"$f":"K11*'Input|Labour Rates'!$C$30","v":6.4204125384941095}]
[5,"Senior Engineer*",{"$f":"IF(ISBLANK('Input|Labour Rates'!C12),\"\",'Input|Labour Rates'!C12)","v":"Business hours"},{"$f":"D11*1.2","v":240000},315.88429689391023,null,{"$f":"'Input|Labour Rates'!D12*'Input|Escalations'!G18*'Input|Escalations'!G39","v":129.96549924638623},{"$f":"IFERROR(G12*('Input|Labour Rates'!E12),0)","v":61.414797111568411},191.38029635795465,{"$f":"IFERROR(I12*'Input|Labour Rates'!F12,0)","v":116.79950548976262},308.17980184771727,{"$f":"K12*'Input|Labour Rates'!$C$30","v":7.7044950461929318}]
[6,"Field Worker",{"$f":"IF(ISBLANK('Input|Labour Rates'!C14),\"\",'Input|Labour Rates'!C14)","v":"After Hours"},{"$f":"((((E9*1.75)-M13)/((1+'Input|Labour Rates'!F14)*(1+'Input|Labour Rates'!C30)))/(1+'Input|Labour Rates'!E14))*'Input|Labour Rates'!$C$28*'Input|Labour Rates'!$C$29","v":371812.77792212431},420.62770277179476,null,{"$f":"'Input|Labour Rates'!D14*'Input|Escalations'!G18*'Input|Escalations'!G39","v":201.34513878681088},{"$f":"IFERROR(G13*('Input|Labour Rates'!E14),0)","v":38.907478612693026},240.25261739950389,{"$f":"IFERROR(I13*'Input|Labour Rates'!F14,0)","v":146.62631127081977},386.87892867032366,{"$f":"K13*'Input|Labour Rates'!$C$30","v":9.6719732167580919},{"$f":"'Input|Indirect Cost Rates'!$H$35*'Input|Escalations'!G18*'Input|Escalations'!G39","v":24.076800884713027}]
[7]
[null,"*Used the AER's approach and applied a 20% uplift for engineer salary"]
[]
[null,"Labour category",null,"BASE LABOUR RATE\n($2022-23)",null,null,"BASE LABOUR RATE\n($/hour) ($2022-23)"]
[null,"Field Worker",null,133000,null,null,{"$f":"D18/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":67.126965861143077}]
[null,"Technical Specialist",null,{"$f":"'MJ- hays categories_Rates'!E15*10^3","v":133000},null,null,{"$f":"D19/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":67.126965861143077}]

{"sheet":"Output|Labour Rates","index":7,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!B1","v":"JEN 2026-27 - Labour Rates"},null,null,"Key:","Input",null,"Sheet Validation","NA"]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Output|Labour Rates"},null,null,null,"Formula"]
[]
[null,"1.1 Labour Rates for 2026-27"]
[]
[null,"Labour category","Hours [List]","Labour Rate \n$2026-27","AER DD Labour Rate \n$2026-27"]
[1,{"$f":"'Input|Labour Rates'!B8","v":"Administrative Officer"},{"$f":"'Input|Labour Rates'!C8","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E8","v":117.56646786655396},{"$f":"'[1]Output|Quoted'!D12","v":120.34000000000002},{"$f":"D7/E7-1","v":-2.3047466623284496E-2}]
[2,{"$f":"'Input|Labour Rates'!B9","v":"Field Worker"},{"$f":"'Input|Labour Rates'!C9","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E9","v":224.95599243835682},{"$f":"'[1]Output|Quoted'!D13","v":205.11899850759139},9.6709685963249692E-2]
[3,{"$f":"'Input|Labour Rates'!B10","v":"Technical Specialist"},{"$f":"'Input|Labour Rates'!C10","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E10","v":222.31177911410575},{"$f":"'[1]Output|Quoted'!D14","v":218.84404072940907},1.584570625336057E-2]
[4,{"$f":"'Input|Labour Rates'!B11","v":"Engineer"},{"$f":"'Input|Labour Rates'!C11","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E11","v":263.23691407825851},{"$f":"'[1]Output|Quoted'!D15","v":253.35000000000014},3.9024724998059535E-2]
[5,{"$f":"'Input|Labour Rates'!B12","v":"Senior Engineer"},{"$f":"'Input|Labour Rates'!C12","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E12","v":315.88429689391023},{"$f":"'[1]Output|Quoted'!D16","v":304.02000000000004},3.9024724998059979E-2]
[6,{"$f":"'Input|Labour Rates'!B14","v":"Field Worker*"},{"$f":"'Input|Labour Rates'!C14","v":"After Hours"},{"$f":"'Calc|Labour Rates'!E13","v":420.62770277179476},{"$f":"'[1]Output|Quoted'!$D$18","v":359.75099693567529},0.16921900524157385]
[7]

{"sheet":"MJ- hays categories_Rates","index":8,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,3,4],[11,0,11,4]]}
["Hays categories included in Marsden Jacob analysis - Melbourne ($'000 pa)"]
[]
[null,null,null,null,null,"Source"]
["Hays 2024-25 salary guide Vic Melbourne ($'000 pa)",null,null,null,null,"Hays Salary Guide FY24-25"]
["Energy Sector","Category","Title","Low","High"]
["Engineer","Energy-Design Engineering","Power systems engineer",120,200,"Power systems engineer"]
["Senior Engineer","Energy-Design Engineering","Power systems engineer",170,200,"uplift by 20%"]
["Admin","Office Support","Project coordinator",80,90]
[]
[]
[]
["Hays 2022-23 salary guide Vic Melbourne ($'000 pa)",null,null,null,null,"Hays Salary Guide FY22-23"]
["Energy Sector","Category","Title","Low","High"]
["Field worker","Energy O&M","Electrician",92,122]
["Techical Specialist","Energy Project Development ","Planner/Scheduler",107,133]
["Field worker","Energy O&M","G&B lines worker",87,133]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Model Validation","index":9,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!B1","v":"JEN 2026-27 - Labour Rates"}]
[null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Model Validation"}]
[]
[null,"Overall Model Check",{"$f":"IF(SUM(C9:C13)=0,0,1)","v":0}]
[]
[null,{"$f":"Index!B7","v":"Worksheet name"}]
[]
[null,{"$f":"Index!B9","v":"Output|Labour Rates"}]
[null,{"$f":"Index!B10","v":"Input | Setup"},{"$f":"'Input|Labour Rates'!G1","v":0}]
[null,{"$f":"Index!B11","v":"Input|Labour Rates"},{"$f":"'Input|Indirect Cost Rates'!G1","v":"NA"}]
[null,{"$f":"Index!B12","v":"Input|Escalations"},{"$f":"'Input|Escalations'!G1","v":0}]
[null,{"$f":"Index!B13","v":"Input|Indirect Cost Rates"},{"$f":"'Calc|Labour Rates'!H1","v":"NA"}]
[null,{"$f":"Index!B14","v":"Calc|Labour Rates"},{"$f":"'Output|Labour Rates'!I1","v":"NA"}]
[null,{"$f":"Index!B15","v":"Model Validation"},"NA"]
[]
[null,{"$f":"B8","v":"Output|Labour Rates"}]
[null,{"$f":"Index!$B$21","v":"1.1 Labour Rates for 2026-27"}]
[]
[null,{"$f":"B9","v":"Input | Setup"}]
[null,{"$f":"Index!B22","v":"2.1 Years setup"},{"$f":"SUM('Input|Labour Rates'!$I$8:$I$18)","v":0}]
[null,{"$f":"Index!B23","v":"2.2 Current regulatory period"}]
[null,{"$f":"Index!B24","v":"2.3 Forecast regulatory period"}]
[null,{"$f":"Index!B25","v":"2.4 Hours"}]
[null,{"$f":"Index!B26","v":" "}]
[null,{"$f":"Index!B27","v":"2.5 Labour type"}]
[null,{"$f":"Index!B28","v":"2.6 Expense Type"}]
[null,{"$f":"Index!B29","v":"2.7 Control Mechanism"}]
[]
[null,{"$f":"B10","v":"Input|Labour Rates"}]
[null,{"$f":"Index!B30","v":"3.1 Labour Rates"},"NA"]
[null,{"$f":"Index!B31","v":"3.2 Notes and sources "},"NA"]
[null,{"$f":"Index!B32","v":"3.3 Assumptions"}]
[null,{"$f":"Index!B33","v":"3.4 Notes and sources"}]
[]
[null,{"$f":"B11","v":"Input|Escalations"}]
[null,{"$f":"Index!B34","v":"4.1 Escalation setup"},"NA"]
[null,{"$f":"Index!B35","v":"4.2 Inflation"}]
[]
[null,{"$f":"B12","v":"Input|Indirect Cost Rates"}]
[null,{"$f":"Index!B37","v":"5.1 On costs"},"NA"]
[null,{"$f":"Index!B38","v":"5.2 Overheads"}]
[null,{"$f":"Index!B39","v":"5.3 Vehicle Allowance"}]
[]
[null,{"$f":"B13","v":"Calc|Labour Rates"}]
[null,{"$f":"Index!B40","v":"6.1 Labour Rates ($2024-25)"},"NA"]