{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Index","Input|Setup","Input|Labour Rates","Input|Escalations","Input|Indirect Cost Rates","Calc|Labour Rates","Output|Labour Rates","MJ- hays categories_Rates","Model Validation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":66,"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":"Index","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"JEN 2024-25 - 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 2024-25"},{"$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'!A20 & \" \" & 'Input|Escalations'!B20","v":"4.3 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 ($2024-25)"},{"$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":1,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR(Index!$B$1,0)","v":"JEN 2024-25 - 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,"2024-25",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|Labour Rates","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR(Index!B1,\"\")","v":"JEN 2024-25 - 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'!G8","v":45.424262612803588},{"$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,"Base labour rates are taken from Hays Salary Guide 2024-25 for Vic-Melbourne and applying the AER\"s labour rate methodology"]
[{"$f":"A8+1","v":2},"Field Worker","Business hours",{"$f":"'Calc|Labour Rates'!G9","v":68.489963436607113},{"$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'!G10","v":74.665288008760214},{"$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'!G11","v":100.94280580623018},{"$f":"'Input|Indirect Cost Rates'!$H$19","v":0.47254692566632128},{"$f":"$F$8","v":0.61030057802451454},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"]
[5,"Senior Engineer","Business hours",{"$f":"'Calc|Labour Rates'!G12","v":121.13136696747624},{"$f":"'Input|Indirect Cost Rates'!$G$19","v":0.47254692566632128},{"$f":"$F$8","v":0.61030057802451454},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"]
[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'!$G$13","v":158.80667934960499},{"$f":"'Input|Indirect Cost Rates'!$I$19","v":0.19323773520000009},{"$f":"$F$8","v":0.61030057802451454},null,null,null,"*Section 19.1 of the Fair Work Ombudsman, Electrical Power Industry Award 2020"]
[8,"Technical Specialist","After Hours",0,0,0]
[9,"Engineer","After Hours",0,0,0]
[10,"Senior Engineer","After Hours",0,0,0]
[11]
[]
[]
[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":"Input|Escalations","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input|Setup'!$B$1","v":"JEN 2024-25 - Labour Rates"},"Key: ","Input",null,"Sheet Validation ",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","2026-27"]
[null,"Base year for inputs","2024-25"]
[null,"Base year for outputs","2024-25"]
[]
[]
[4.2,"Inflation",null,null,"Current regulatory period",null,null,null,null,"Forecast regulatory period",null,null,null,null,{"$f":"IF(COUNTA(B14:N17)=0,1,0)","v":0}]
[]
[null,null,null,"Jan21-Jun21",{"$f":"IFERROR((LEFT(F15,4)-1&IF(MID(F15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F15,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(G15,4)-1&IF(MID(G15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G15,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(H15,4)-1&IF(MID(H15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H15,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(I15,4)-1&IF(MID(I15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I15,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(J15,4)-1&IF(MID(J15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J15,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(J15,4)+1&IF(MID(J15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J15,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(K15,4)+1&IF(MID(K15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K15,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(L15,4)+1&IF(MID(L15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L15,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(M15,4)+1&IF(MID(M15,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(M15,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"CPI year on year change (%) - lagged one year (actual/estimate)",null,1.2195121951219523E-2,8.6058519793459354E-3,3.4982935153583528E-2,7.8318219291014124E-2,4.0519877675840865E-2,2.5999999999999999E-2,2.4999999999999911E-2,2.4999999999999911E-2,2.4999999999999911E-2,2.4999999999999911E-2,2.4999999999999911E-2]
[null,"Cumulative Inflation Index ",null,null,null,1,{"$f":"IFERROR(F17*(1+G16),\"\")","v":1.0783182192910141},1.1220115416323166,1.1511838417147569,1.1799634377576256,1.2094625237015662,1.2396990867941051,1.2706915639639575,1.3024588530630563]
[]
[]
[4.3,"Real wage price escalation",null,null,"Current regulatory period",null,null,null,null,"Forecast regulatory period"]
[]
[null,null,null,{"$f":"$D$15","v":"Jan21-Jun21"},{"$f":"IFERROR((LEFT(F22,4)-1&IF(MID(F22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F22,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(G22,4)-1&IF(MID(G22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G22,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(H22,4)-1&IF(MID(H22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H22,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(I22,4)-1&IF(MID(I22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I22,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(J22,4)-1&IF(MID(J22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J22,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(J22,4)+1&IF(MID(J22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J22,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(K22,4)+1&IF(MID(K22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K22,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(L22,4)+1&IF(MID(L22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L22,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(M22,4)+1&IF(MID(M22,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(M22,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"}]
[null,"Labour - Real wage price growth",null,{"$f":"SUM((D28*D34),(D29*D35),(D30*D36),(D31*D37))","v":4.9431199881141948E-3},-2.8120407869096802E-2,-4.374835875726607E-2,{"$f":"SUM((G28*G34),(G29*G35),(G30*G36),(G31*G37))","v":-1.5093609819145648E-2},6.5363129067719239E-3,7.2010311340859889E-3,9.3135243940020672E-3,8.3583556288052887E-3,1.0254990531688098E-2,1.2240188084018007E-2,1.1482353043552641E-2]
[null,"Cumulative Labour - Wage price growth index",null,{"$f":"1+D23","v":1.0049431199881143},{"$f":"IFERROR(D24*(1+E23),\"\")","v":0.97668370956880579},{"$f":"1+F23","v":0.95625164124273399},0.94181835208089848,0.94797437153143949,0.95480076449515294,0.96369332470669045,0.97174821623169483,0.98171348498833555,0.9937298426892095,1.005140199572881]
[null,"Escalate from 2022-23 to 2024-25",null,null,null,null,{"$f":"G24/$F$24","v":0.98490639018085435},{"$f":"H24/$F$24","v":0.99134404653095554},0.99848274587461572,1.0077821392853092,1.016205540801814,1.0266267190009857,1.0391928231336358,1.0511252020091824]
[]
[null,"Forecast/Source",null,{"$f":"$D$15","v":"Jan21-Jun21"},{"$f":"IFERROR((LEFT(F27,4)-1&IF(MID(F27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F27,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(G27,4)-1&IF(MID(G27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G27,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(H27,4)-1&IF(MID(H27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H27,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(I27,4)-1&IF(MID(I27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I27,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(J27,4)-1&IF(MID(J27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J27,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(J27,4)+1&IF(MID(J27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J27,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(K27,4)+1&IF(MID(K27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K27,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(L27,4)+1&IF(MID(L27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L27,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(M27,4)+1&IF(MID(M27,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(M27,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"},{"$f":"IF(COUNTA(B28:N31)=0,1,0)","v":0}]
[null,"WPI - Oxford Economics actual and forecast October 2024",null,4.9431199881141948E-3,-2.8120407869096802E-2,-4.374835875726607E-2,-1.5093609819145648E-2,6.5363129067719239E-3,7.2010311340859889E-3]
[null,"WPI - DAE forecast (placeholder from Ergon Report) AUS",null,null,null,null,null,null,null,7.0000000000000001E-3,7.0000000000000001E-3,8.0000000000000002E-3,1.0999999999999999E-2,1.0999999999999999E-2]
[null,"WPI - Oxford Economics forecast October 2024",null,null,null,null,null,null,null,1.1627048788004135E-2,9.7167112576105781E-3,1.2509981063376197E-2,1.3480376168036013E-2,1.1964706087105283E-2]
[]
[]
[null,"Weights (per cent)",null,{"$f":"$D$15","v":"Jan21-Jun21"},{"$f":"IFERROR((LEFT(F33,4)-1&IF(MID(F33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(F33,6,2)-1,100),\"00\"))),\"\")","v":"2021-22"},{"$f":"IFERROR((LEFT(G33,4)-1&IF(MID(G33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(G33,6,2)-1,100),\"00\"))),\"\")","v":"2022-23"},{"$f":"IFERROR((LEFT(H33,4)-1&IF(MID(H33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(H33,6,2)-1,100),\"00\"))),\"\")","v":"2023-24"},{"$f":"IFERROR((LEFT(I33,4)-1&IF(MID(I33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(I33,6,2)-1,100),\"00\"))),\"\")","v":"2024-25"},{"$f":"IFERROR((LEFT(J33,4)-1&IF(MID(J33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J33,6,2)-1,100),\"00\"))),\"\")","v":"2025-26"},{"$f":"$C$8","v":"2026-27"},{"$f":"IFERROR((LEFT(J33,4)+1&IF(MID(J33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(J33,6,2)+1,100),\"00\"))),\"\")","v":"2027-28"},{"$f":"IFERROR((LEFT(K33,4)+1&IF(MID(K33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(K33,6,2)+1,100),\"00\"))),\"\")","v":"2028-29"},{"$f":"IFERROR((LEFT(L33,4)+1&IF(MID(L33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(L33,6,2)+1,100),\"00\"))),\"\")","v":"2029-30"},{"$f":"IFERROR((LEFT(M33,4)+1&IF(MID(M33,5,1)=\"\",\"\",\"-\"&TEXT(MOD(MID(M33,6,2)+1,100),\"00\"))),\"\")","v":"2030-31"},{"$f":"IF(COUNTA(E34:N37)=0,1,0)","v":0}]
[null,{"$f":"B28","v":"WPI - Oxford Economics actual and forecast October 2024"},null,1,1,1,1,1,1]
[null,{"$f":"B29","v":"WPI - DAE forecast (placeholder from Ergon Report) AUS"},null,null,null,null,null,null,null,0.5,0.5,0.5,0.5,0.5]
[null,{"$f":"B30","v":"WPI - Oxford Economics forecast October 2024"},null,null,null,null,null,null,null,0.5,0.5,0.5,0.5,0.5]
[null,{"$f":"B31","v":0}]
[null,null,null,{"$f":"IF(OR(SUM(D34:D37)=0,SUM(D34:D37)=1),0,1)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(SUM(E38:N38)=0,0,1)","v":0}]

{"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 2024-25 - 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 r costs","Notes",null,null,null," ($Jan21-Jun21)",{"$f":"'Input|Escalations'!E15","v":"2021-22"},{"$f":"'Input|Escalations'!F15","v":"2022-23"},{"$f":"'Input|Escalations'!G15","v":"2023-24"},{"$f":"'Input|Escalations'!H15","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,{"$f":"G35*(1+'Input|Escalations'!E16)","v":20.172117039586919},{"$f":"H35*(1+'Input|Escalations'!F16)","v":20.877796901893284},{"$f":"I35*(1+'Input|Escalations'!G16)","v":22.512908777969017},{"$f":"J35*(1+'Input|Escalations'!H16)","v":23.425129087779684}]

{"sheet":"Calc|Labour Rates","index":5,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IFERROR(Index!B1,\"\")","v":"JEN 2024-25 - 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 ($2024-25)\"","v":"6.2 Labour Rates Build up, $'s ($2024-25)"},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":109.57513374542386},null,{"$f":"D8/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":45.424262612803588},{"$f":"IFERROR(G8*('Input|Labour Rates'!E8),\"\")","v":20.962454852625502},{"$f":"SUM(G8:H8)","v":66.386717465429086},{"$f":"IFERROR(I8*'Input|Labour Rates'!F8,0)","v":40.515852042301503},{"$f":"SUM(I8:J8)","v":106.90256950773059},{"$f":"K8*'Input|Labour Rates'!$C$30","v":2.672564237693265}]
[{"$f":"A8+1","v":2},"Field Worker",{"$f":"IF(ISBLANK('Input|Labour Rates'!C9),\"\",'Input|Labour Rates'!C9)","v":"Business hours"},{"$f":"G9*'Input|Labour Rates'!$C$28*'Input|Labour Rates'!$C$29","v":135700.53435621841},192.11210645398245,null,{"$f":"G18*'Input|Escalations'!$H$17*'Input|Escalations'!$H$25","v":68.489963436607113},{"$f":"IFERROR(G9*('Input|Labour Rates'!E9),0)","v":33.710000403044738},102.19996383965184,{"$f":"IFERROR(I9*'Input|Labour Rates'!F9,0)","v":62.372697005424001},164.57266084507586,{"$f":"K9*'Input|Labour Rates'!$C$30","v":4.1143165211268968},{"$f":"'Input|Indirect Cost Rates'!$K$35","v":23.425129087779684}]
[3,"Technical Specialist",{"$f":"IF(ISBLANK('Input|Labour Rates'!C10),\"\",'Input|Labour Rates'!C10)","v":"Business hours"},{"$f":"G10*'Input|Labour Rates'!$C$28*'Input|Labour Rates'!$C$29","v":147935.82843751679},204.90092183117068,null,{"$f":"G19*'Input|Escalations'!$H$17*'Input|Escalations'!$H$25","v":74.665288008760214},{"$f":"IFERROR(G10*('Input|Labour Rates'!E10),0)","v":35.282852302530081},109.9481403112903,{"$f":"IFERROR(I10*'Input|Labour Rates'!F10,0)","v":67.101413584700893},177.04955389599121,{"$f":"K10*'Input|Labour Rates'!$C$30","v":4.4262388473997802},{"$f":"'Input|Indirect Cost Rates'!$K$35","v":23.425129087779684}]
[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},245.34393684088553,null,{"$f":"D11/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":100.94280580623018},{"$f":"IFERROR(G11*('Input|Labour Rates'!E11),0)","v":47.700212551866557},148.64301835809675,{"$f":"IFERROR(I11*'Input|Labour Rates'!F11,0)","v":90.716920023254971},239.35993838135172,{"$f":"K11*'Input|Labour Rates'!$C$30","v":5.9839984595337938}]
[5,"Senior Engineer*",{"$f":"IF(ISBLANK('Input|Labour Rates'!C12),\"\",'Input|Labour Rates'!C12)","v":"Business hours"},{"$f":"D11*1.2","v":240000},294.41272420906267,null,{"$f":"D12/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":121.13136696747624},{"$f":"IFERROR(G12*('Input|Labour Rates'!E12),0)","v":57.240255062239882},178.37162202971612,{"$f":"IFERROR(I12*'Input|Labour Rates'!F12,0)","v":108.86030402790598},287.2319260576221,{"$f":"K12*'Input|Labour Rates'!$C$30","v":7.1807981514405528}]
[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":314646.84992895939},336.19618629446921,null,{"$f":"D13/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":158.80667934960499},{"$f":"IFERROR(G13*('Input|Labour Rates'!E14),0)","v":30.687443052150293},189.49412240175528,{"$f":"IFERROR(I13*'Input|Labour Rates'!F14,0)","v":115.64837243403936},305.14249483579465,{"$f":"K13*'Input|Labour Rates'!$C$30","v":7.6285623708948664},{"$f":"'Input|Indirect Cost Rates'!$K$35","v":23.425129087779684}]
[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,{"$f":"'MJ- hays categories_Rates'!E14*10^3","v":122000},null,null,{"$f":"D18/'Input|Labour Rates'!$C$28/'Input|Labour Rates'!$C$29","v":61.57511154180041}]
[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":6,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!B1","v":"JEN 2024-25 - 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 2024-25"]
[]
[null,"Labour category","Hours [List]","Labour Rate \n$2024-25","AER Approved Labour Rate \n$2024-25"]
[1,{"$f":"'Input|Labour Rates'!B8","v":"Administrative Officer"},{"$f":"'Input|Labour Rates'!C8","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E8","v":109.57513374542386},109.26,{"$f":"D7/E7-1","v":2.8842554038426282E-3}]
[2,{"$f":"'Input|Labour Rates'!B9","v":"Field Worker"},{"$f":"'Input|Labour Rates'!C9","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E9","v":192.11210645398245},186.06,3.2527713930895708E-2]
[3,{"$f":"'Input|Labour Rates'!B10","v":"Technical Specialist"},{"$f":"'Input|Labour Rates'!C10","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E10","v":204.90092183117068},196.96,4.0317434155009435E-2]
[4,{"$f":"'Input|Labour Rates'!B11","v":"Engineer"},{"$f":"'Input|Labour Rates'!C11","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E11","v":245.34393684088553},181.43,0.35227876779411083]
[5,{"$f":"'Input|Labour Rates'!B12","v":"Senior Engineer"},{"$f":"'Input|Labour Rates'!C12","v":"Business hours"},{"$f":"'Calc|Labour Rates'!E12","v":294.41272420906267},237.25,0.24093877432692379]
[6,{"$f":"'Input|Labour Rates'!B14","v":"Field Worker*"},{"$f":"'Input|Labour Rates'!C14","v":"After Hours"},{"$f":"'Calc|Labour Rates'!E13","v":336.19618629446921},283.18,0.18721726920852189]
[7]

{"sheet":"MJ- hays categories_Rates","index":7,"n_rows":15,"n_cols":6,"rows_kept":15,"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",75,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]

{"sheet":"Model Validation","index":8,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"Index!B1","v":"JEN 2024-25 - 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 2024-25"}]
[]
[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"]