{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Eff Jul 23 - Continuing FT","Eff Jul 23 - Casual","Ref (9.5) eff Jul 21 - FT Con ","BE_Salary Plan","BE_Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"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":"Eff Jul 23 - Continuing FT","index":0,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[[7,1,7,6],[8,1,8,6],[10,1,10,6],[11,1,11,6],[16,1,16,6]]}
[null,null,"Column to look up the Salary Plan Year",null,12,"Version","2020-11-11"]
[null,null,"Salary Admin Plan Code",null,{"$f":"IF($E21=\"Agreed Salary\",\"Agreed Salary\",IF($E$21=\"Director of Studies\",$E$21&\"__\"&E24,VLOOKUP($E$22,BE_Lookup!$E$4:$F$8,2,FALSE)))","v":{"$error":"#N/A"}}]
[null,null,"Salary Step Lookup",null,{"$f":"VLOOKUP($E$2&\"_\"&$E$23, BE_Lookup!$E$19:$F$42, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Salary Plan Lookup",null,{"$f":"$E$2&\"_\"&$E$23&\"_\"&$E$24","v":{"$error":"#N/A"}}]
[null,null,"FTE"]
[null,null,"Annual Leave Loading Cap","HEO_HEO Level 9_1",{"$f":"VLOOKUP($D$6, Lookup_SalaryPlan, $E$1, FALSE)","v":123881},{"$f":"AnnualLeaveLoadingCap*1.31%","v":1622.8411000000001}]
[]
[null,"THE UNIVERSITY OF ADELAIDE"]
[null,"SALARY ONCOST CALCULATION SCHEDULE for Continuing and Fixed Term"]
[]
[null,"The following table can be used for grant applications and general salary cost estimates for both "]
[null,"Academic and Professional staff \n(with salary rate effective 1 July 2023 and superannuation rate increases to 17% for Fixed Term Contract with effect from July 2022):"]
[]
[null,"Quick Total Cost calculation : Where no additional Loadings, use :"]
[null,null,2020,null,null,"((A) + (B)) * (1 + 18.61%)"]
[null,null,"With effect from July 2023",null,null,"((A) + (B)) * (1 + 27.0462%)"]
[]
[null,"To use this table, please select / enter annual salary / percentages / fixed value in the red box"]
[]
[null,null,"Salary Plan Year",null,2023]
[null,null,"Academic / Professional/ Agreed Salary"]
[null,null,"Sub-type"]
[null,null,"Classification"]
[null,null,"Salary Step"]
[]
[null,null,"Clinical Loading:"]
[null,null,"ELT Allowance:"]
[null,null,"Agreed Salary Amount :\n   Note: Future increases for agreed salary are not taken into consideration in the calculation."]
[null,null,"FTE"]
[null,null,"[FTE should be >0 and <1]"]
[]
[]
[]
[null,null,null,null,null,"Continuing / "]
[null,null,null,null,null,"Fixed Term Contract"]
[]
[null,{"$f":"\"Annual salary at \"&TEXT(E20,\"0\")&\" rate (A)\"","v":"Annual salary at 2023 rate (A)"},null,"(A) ",null,{"$f":"IFERROR(VLOOKUP($E4,Lookup_SalaryPlan,$E$1,FALSE)*$E$29,\"\")","v":""}]
[]
[null,null,"Annual Leave Loading","(B) ",{"$f":"17.5%/52*4","v":1.3461538461538461E-2},{"$f":"IFERROR(IF(F$37=\"\", 0, IF(F$37>AnnualLeaveLoadingCap, AnnualLeaveLoadingCap*E39, F$37*E39)),\"\")","v":0}]
[null,null,{"$f":"\"[calculated on Current Annual Salary capped at HEO9 step 1 (\" & TEXT(AnnualLeaveLoadingCap, \"$0,000.00\")&\") for \" & TEXT(E20,\"0\") & \"]\"","v":"[calculated on Current Annual Salary capped at HEO9 step 1 ($123,881.00) for 2023]"}]
[]
[null,null,"Loadings","(C) "]
[null,null,{"$f":"IF(AND($E$26=\"\", $E$27=\"\"), \"\", IF($E$26<>\"\", $E$26, $E$27))","v":""},null,null,{"$f":"IFERROR(IF($C43=\"No Loading\", 0, VLOOKUP((\"__\"&$C43), Lookup_SalaryPlan, $E1, FALSE)*$E$29),0)","v":0}]
[null,null,"Non-superannuable Discretionary Loadings",null,null,{"$f":"IF(E44=\"\",0, E44)","v":0}]
[null,null,"[for example, attraction / retention and responsibility loadings]"]
[null,"Estimated Annual Salary",null,null,null,{"$f":"IFERROR(F$37+F$39+F$43+F$44,\"\")","v":""}]
[]
[null,"Oncosts"]
[null,null,"Long Service Leave Provision","(D)",3.2500000000000001E-2,{"$f":"IFERROR(+(F$46-F$39)*E49,\"\")","v":""}]
[null,null,"[calculated on 'Estimated Annual Salary' less 'Annual Leave Loading']"]
[]
[null,null,"Superannuation","(E) ",{"$f":"IFERROR(VLOOKUP($E20, Lookup_SuperRate, 2, FALSE),\"\")","v":0.17},{"$f":"IFERROR((F$46-F$44-F$39)*E52,\"\")","v":""}]
[null,null,"[calculated on 'Estimated Annual Salary' less non-superannuable discretionary loading']"]
[]
[null,null,"Payroll Tax","(F) ",4.9500000000000002E-2,{"$f":"IFERROR((F$46+F$52)*E55,\"\")","v":""}]
[null,null,"[calculated on 'Estimated Annual Salary' plus 'Superannuation']"]
[]
[null,null,"Workers Compensation","(G) ",5.0000000000000001E-3,{"$f":"IFERROR((F$46+F52)*E58,\"\")","v":""}]
[null,null,"[calculated on 'Estimated Annual Salary plus Superannuation'']"]
[]
[null,null,"Total Oncosts",null,null,{"$f":"SUM(F$49,F$52,F$55,F$58)","v":0}]
[]
[null,"TOTAL ESTIMATED SALARY & ONCOSTS",null,null,null,{"$f":"IFERROR(F$46+F$61,\"\")","v":""}]

{"sheet":"Eff Jul 23 - Casual","index":1,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[7,1,7,6],[8,1,8,6],[10,1,10,6],[11,1,11,6]]}
[null,null,"Column to look up the Salary Plan Year",null,{"$f":"HLOOKUP($E$20, Lookup_SalaryYr, 3, FALSE)","v":12},"Version",{"$f":"'Eff Jul 23 - Continuing FT'!$G$1","v":"2020-11-11"}]
[null,null,"Salary Admin Plan Code",null,{"$f":"IF($E21=\"Agreed Salary\",\"Agreed Salary\",IF($E$21=\"Director of Studies\",$E$21&\"__\"&E24,VLOOKUP($E$22,BE_Lookup!$E$4:$F$8,2,FALSE)))","v":{"$error":"#N/A"}}]
[null,null,"Salary Step Lookup",null,{"$f":"VLOOKUP($E$2&\"_\"&$E$23, BE_Lookup!$E$19:$F$42, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,null,"Salary Plan Lookup",null,{"$f":"$E$2&\"_\"&$E$23&\"_\"&$E$24","v":{"$error":"#N/A"}}]
[null,null,"FTE"]
[null,null,"Annual Leave Loading Cap","HEO_HEO Level 9_1",{"$f":"VLOOKUP($D$6, Lookup_SalaryPlan, $E$1, FALSE)","v":123881},{"$f":"AnnualLeaveLoadingCap*1.31%","v":1622.8411000000001}]
[]
[null,"THE UNIVERSITY OF ADELAIDE"]
[null,"SALARY ONCOST CALCULATION SCHEDULE for CASUAL"]
[]
[null,"The following table can be used for grant applications and general salary cost estimates for both "]
[null,"Academic and Professional staff\n(with superannuation rate increases to 10.5% for casual with effect from July 2022):"]
[]
[null,"Quick Total Cost calculation : Where no additional Loadings, use :"]
[null,null,2020,null,null,"((A) + (B)) * (1 + 15.42%)"]
[null,null,"With effect from July 2023",null,null,"((A) + (B)) * (1 + 15.945%)"]
[]
[null,"To use this table, please select / enter annual salary / percentages / fixed value in the red box"]
[]
[null,null,"Salary Plan Year",null,2023]
[null,null,"Academic / Professional/ Agreed Salary"]
[null,null,"Sub-type"]
[null,null,"Classification"]
[null,null,"Salary Step"]
[]
[null,null,"Clinical Loading:"]
[null,null,"ELT Allowance:"]
[null,null,"Agreed Salary Amount: "]
[null,null,"FTE"]
[]
[]
[]
[]
[null,null,null,null,null,"Casuals"]
[]
[]
[null,{"$f":"\"Annual salary at \"& TEXT(E20,\"0\") &\" rate (A)\"","v":"Annual salary at 2023 rate (A)"},null,"(A) "]
[]
[null,null,"Casual loading in lieu of paid leave","(B) ",0.25,{"$f":"IFERROR(F$37*E39,\"\")","v":0}]
[null,null,{"$f":"IF(AND($E$26=\"\", $E$27=\"\"), \"\", IF($E$26<>\"\", $E$26, $E$27))","v":""},null,null,{"$f":"IF(E40=\"\",0, E40)","v":0}]
[null,null,"Other Loadings ",null,null,{"$f":"IF(E41=\"\",0, E41)","v":0}]
[null,null,"[for example, attraction / retention and responsibility loadings]"]
[null,"Estimated Annual Salary",null,null,null,{"$f":"IFERROR(F$37+F$39,\"\")","v":0}]
[]
[null,"Oncosts"]
[]
[null,null,"Superannuation","(C) ",{"$f":"IFERROR(VLOOKUP($E20, Lookup_SuperRate, 4, FALSE),\"\")","v":0.11},{"$f":"IFERROR(F$43*E47,\"\")","v":0}]
[null,null,"[calculated on 'Estimated Annual Salary' ]"]
[]
[null,null,"Payroll Tax","(D)",4.9500000000000002E-2,{"$f":"IFERROR((F$43+F$47)*E50,\"\")","v":0}]
[null,null,"[calculated on 'Estimated Annual Salary' plus 'Superannuation']"]
[]
[null,null,"Workers Compensation","(E) ",5.0000000000000001E-3,{"$f":"IFERROR((F$43+F47)*E53,\"\")","v":0}]
[null,null,"[calculated on 'Estimated Annual Salary plus superannuation']"]
[]
[null,null,"Total Oncosts",null,null,{"$f":"SUM(F$47,F$50,F$53)","v":0}]
[]
[null,"TOTAL ESTIMATED SALARY & ONCOSTS",null,null,null,{"$f":"IFERROR(F$43+F$56,\"\")","v":0}]

{"sheet":"Ref (9.5) eff Jul 21 - FT Con ","index":2,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"SALARY COST CALCULATION REFERENCE SHEET"]
[null,"SALARY",null,"[example below based on permanent staff appointment at HEO10 step 1, FTE = 1 in 2021.]"]
[]
[null,"Annual salary","(A)",128731,"Obtained from \"Salary Scales\" schedule provide by Human Resources on web."]
[null,null,null,null,"It does not include annual leave loading. "]
[]
[null,"Gross salary including EB","b",{"$f":"D4*1.02","v":131305.62},"calculated by a x 1.02"]
[null,null,null,null,"As an example, this assumes an increase of 2% on current salary scales."]
[]
[null,"48 weeks","h",{"$f":"D4*48/52","v":118828.61538461539},"calculated by b x 48/52"]
[null,null,null,null,"Calculated by 48/52 x Gross excl A/L/L, incl EB."]
[]
[]
[null,"Annual Leave Loading","(B)",{"$f":"IF(D$4>AnnualLeaveLoadingCap, AnnualLeaveLoadingCap*1.35%, D$4*1.35%)","v":1672.3935000000001},"calculated by (A) x 1.35% capped at HEO9 step 1 of the respective year"]
[null,null,null,null,"As per EA 4.1.4.1 A staff member will be entitled to payment of an annual leave loading of\n17.5% of four (4) weeks of their salary that will be capped at the Higher\nEducation Officer Level 9 step 1 except where shift and penalty rates would\nbe greater."]
[null,null,null,null,"1.35% is calculated based on 17%/52*4"]
[null,null,null,null,"Annual leave loading is paid to all staff in first pay in December."]
[]
[null,"Loadings ","(C) ",null,"Superannuable loadings:- Academic Loadings, English Language Teacher (ELT) Allowances"]
[null,null,null,null,"Non Superannuable loadings - Any discretionary loadings (eg. attraction / retention and responsibility loadings) when a staff receives full super at 17%"]
[null,"ONCOSTS"]
[]
[null,"Annual Leave Provision",null,{"$f":"D4*0.1143","v":14713.953299999999},"calculated by h x 11.43%"]
[null,null,null,null,"Annual leave is 4 weeks per year = 7.69% of 52 weeks[4/52]; A/L/L is 1.3% for budget purposes; a total of 8.99%."]
[null,null,null,null,"However the oncost will be calculated on the 48 weeks and so increase to 8.99 X 52/48  = 9.7392%"]
[null,null,null,null,"but since annual leave is usually taken after it accumulates, at a higher salary, an 'inflation' factor of 2% increases the provision to 9.93% [9.7392 x 1.02]."]
[null,null,null,null,"All salary oncosts are charged to the Provision account when leave is taken; therefore the annual leave provision must include oncosts."]
[null,null,null,null,"AL andLSL oncosts are already loaded and so superannuation, payroll tax & workers' compensation oncosts for 4 weeks is averaged at 1.5% due to different super rates."]
[null,null,null,null,"(max = [[17%+4.95%+0.5%]/52]X4=1.8%; min [[9.5%+4.95%+0.5%]/52]X4=1.2%)"]
[]
[null,"Long Service Leave Provision","(D)",{"$f":"D10*0.0325","v":3861.9300000000003},"calculated by (A) x 3.25%"]
[null,null,null,null,"Long service leave is 6.5 week days per year = 6.5/261 = 2.49%"]
[null,null,null,null,"however the oncost will be charged on the 48 weeks and so increase to 2.49 X 52/48 = 2.70%"]
[null,null,null,null,"Since long service leave is usually taken well after it accumulates, at a higher salary, an 'inflation' factor of 30% increases the provision to 3.25% [2.49% x 1.3]."]
[]
[null,"Superannuation","(E) ",{"$f":"SUM(D4,D14,D19)*17%","v":22168.576895000002},"calculated by (Sum of (A), (B), ( C ) excluding non-superannuable loadings)x 17%"]
[null,null,null,null,"For 2022, 17% for continuing and fixed term staff and Superannuation Guarantee Levy (SGL)10.5% for casual staff."]
[null,null,null,null,"The budget exercise assumes all State Super and Scheme A staff are charged at either the 10.5% or the 17%"]
[null,null,null,null,"Approx. 20 people are non UniSuper scheme which is 12% + 3% = 15%; but for budget purposes will be calculated at 17% "]
[null,null,null,null,"SGL is 10.5%."]
[null,null,null,null,"Superannuation is also applicable to leave loading (SGR 2009/2) "]
[null,null,null,null,"With effect from July 2022, superannuation will be 17% for both continuing and fixed term contract; 10.5% for casual staff."]
[]
[null,"Payroll Tax","(F)",{"$f":"(D4+D36+D14)*0.0495","v":7552.3125345525013},"calculated by (Sum of (A), (B), ( C ) and superannuation)x 4.95%"]
[null,null,null,null,"Payable on on all gross salaries plus Annual Leave Loading (A/L/L) + loadings/overtime + superannuation."]
[null,null,null,null,"Payable to and based on State Government payroll tax rate of 4.95%."]
[]
[null,"Workers Compensation","(G)",{"$f":"(D4+D14)*0.005","v":652.01696750000008},"calculated by (Sum of (A), (B), ( C ))x  0.5%"]
[null,null,null,null,"Payable on all staff including operating budgets which were previously exempt."]
[null,null,null,null,"Payable on on all gross salaries plus Annual Leave Loading (A/L/L) + loadings/overtime."]
[null,null,null,null,"0.5% is an internal calculation to provide appropriate funding to UniSure Pty Ltd ( a University self-insurance company)"]
[]
[null,"TOTAL COST",null,{"$f":"+D48+D44+D36+D31+D14+D4","v":164638.22989705252},"calculated by a+b+c+d+e+f+g "]
[]
[null,"Glossary of Terms"]
[null,"AL: annual leave"]
[null,"LSL: long service leave"]
[null,"A/L/L: annual leave loading"]
[null,"SGC: Superannuation Guarantee Charge"]
[null,"EB: refers to an increase approximating that established by the University's Enterprise Agreement"]

{"sheet":"BE_Salary Plan","index":3,"n_rows":126,"n_cols":17,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
[null,"Lookup_SalaryPlan",null,null,null,null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[]
[null,"Conca","Salary Grade Code ","Salary Admin Plan Code ","Salary Grade ","STEP","Administrative  Increase\non 31 March 2017\n(3% increase)\n","Administrative  Increase\non 31 March 2018\n($2000 flat rate increase)\n","Administrative  Increase\non 31 March 2019\n(1.5% increase)\n","Administrative  Increase\non 31 March 2020\n(1.5% increase + $400 Flat Rate)\n","Administrative  Increase\non 31 March 2021\n(1.5% increase)\n","Administrative Increase effective 2 July 2022\n (2% increase)","Administrative Increase Effective 1 July 2023                      (4.2% Increase)"]
[null,{"$f":"D6&\"_\"&E6&\"_\"&F6","v":"ACA_LEVEL A_1"},"251","ACA","LEVEL A",1,65894,67894,68912,70346,71401,72829,75888]
[null,{"$f":"D7&\"_\"&E7&\"_\"&F7","v":"ACA_LEVEL A_2"},"251","ACA","LEVEL A",2,69662,71662,72737,74228,75341,76848,80076]
[null,"ACA_LEVEL A_3","251","ACA","LEVEL A",3,73423,75423,76554,78102,79274,80859,84255]
[null,"ACA_LEVEL A_4","251","ACA","LEVEL A",4,77187,79187,80375,81981,83211,84875,88440]
[null,"ACA_LEVEL A_5","251","ACA","LEVEL A",5,80246,82246,83480,85132,86409,88137,91839]
[null,"ACA_LEVEL A_6","251","ACA","LEVEL A",6,83307,85307,86587,88286,89610,91402,95241]
[null,"ACA_LEVEL A_7","251","ACA","LEVEL A",7,86368,88368,89694,91439,92811,94667,98643]
[null,"ACA_LEVEL A_8","251","ACA","LEVEL A",8,89425,91425,92796,94588,96007,97927,102040]
[null,"ACA_LEVEL B_1","241","ACA","LEVEL B",1,94135,96135,97577,99441,100933,102952,107276]
[null,"ACA_LEVEL B_2","241","ACA","LEVEL B",2,97666,99666,101161,103078,104624,106716,111198]
[null,"ACA_LEVEL B_3","241","ACA","LEVEL B",3,101190,103190,104738,106709,108310,110476,115116]
[null,"ACA_LEVEL B_4","241","ACA","LEVEL B",4,104724,106724,108325,110350,112005,114245,119043]
[null,"ACA_LEVEL B_5","241","ACA","LEVEL B",5,108251,110251,111905,113984,115694,118008,122964]
[null,"ACA_LEVEL B_6","241","ACA","LEVEL B",6,111788,113788,115495,117627,119391,121779,126894]
[null,"ACA_LEVEL C_1","231","ACA","LEVEL C",1,115310,117310,119070,121256,123075,125537,130810]
[null,"ACA_LEVEL C_2","231","ACA","LEVEL C",2,118843,120843,122656,124896,126769,129304,134735]
[null,"ACA_LEVEL C_3","231","ACA","LEVEL C",3,122370,124370,126236,128530,130458,133067,138656]
[null,"ACA_LEVEL C_4","231","ACA","LEVEL C",4,125899,127899,129817,132164,134146,136829,142576]
[null,"ACA_LEVEL C_5","231","ACA","LEVEL C",5,129429,131429,133400,135801,137838,140595,146500]
[null,"ACA_LEVEL C_6","231","ACA","LEVEL C",6,132966,134966,136990,139445,141537,144368,150431]
[null,"ACA_LEVEL D_1","221","ACA","LEVEL D",1,138845,140845,142958,145502,147685,150639,156966]
[null,"ACA_LEVEL D_2","221","ACA","LEVEL D",2,143549,145549,147732,150348,152603,155655,162193]
[null,"ACA_LEVEL D_3","221","ACA","LEVEL D",3,148263,150263,152517,155205,157533,160684,167433]
[null,"ACA_LEVEL D_4","221","ACA","LEVEL D",4,152965,154965,157289,160048,162449,165698,172657]
[null,"ACA_LEVEL E_1","211","ACA","LEVEL E",1,178851,180851,183564,186717,189518,193308,201427]
[null,"__Clinical",null,null,null,"Clinical",30957,31421,31892,32380,32866,33523,34931]
[null,"__Para-Clinical",null,null,null,"Para-Clinical",20672,20982,21297,21623,21947,22386,23326]
[null,"__Pre-Clinical",null,null,null,"Pre-Clinical",15503,15736,15972,16216,16459,16788,17493]
[null,"__Dental",null,null,null,"Dental",15503,15736,15972,16216,16459,16788,17493]
[null,"HEO_HEO Level 1_1","010","HEO","HEO Level 1",1,31998,33998,34508,35426,35957,36676,38216]
[null,"HEO_HEO Level 1_2","010","HEO","HEO Level 1",2,37026,39026,39611,40605,41214,42038,43804]
[null,"HEO_HEO Level 1_3","010","HEO","HEO Level 1",3,41598,43598,44252,45316,45996,46916,48886]
[null,"HEO_HEO Level 1_4","010","HEO","HEO Level 1",4,45712,47712,48428,49554,50297,51303,53458]
[null,"HEO_HEO Level 1_5","010","HEO","HEO Level 1",5,46227,48227,48950,50084,50835,51852,54030]
[null,"HEO_HEO Level 1_6","010","HEO","HEO Level 1",6,47006,49006,49741,50887,51650,52683,54896]
[null,"HEO_HEO Level 1_7","010","HEO","HEO Level 1",7,47784,49784,50531,51689,52464,53513,55761]
[null,"HEO_HEO Level 2_1","020","HEO","HEO Level 2",1,34539,36539,37087,38043,38614,39386,41040]
[null,"HEO_HEO Level 2_2","020","HEO","HEO Level 2",2,39969,41969,42599,43638,44293,45179,47077]
[null,"HEO_HEO Level 2_3","020","HEO","HEO Level 2",3,44902,46902,47606,48720,49451,50440,52558]
[null,"HEO_HEO Level 2_4","020","HEO","HEO Level 2",4,49342,51342,52112,53294,54093,55175,57492]
[null,"HEO_HEO Level 2_5","020","HEO","HEO Level 2",5,50383,52383,53169,54367,55183,56287,58651]
[null,"HEO_HEO Level 2_6","020","HEO","HEO Level 2",6,51422,53422,54223,55436,56268,57393,59804]
[null,"HEO_HEO Level 2_7","020","HEO","HEO Level 2",7,52457,54457,55274,56503,57351,58498,60955]
[null,"HEO_HEO Level 3_1","030","HEO","HEO Level 3",1,36359,38359,38934,39918,40517,41327,43063]
[null,"HEO_HEO Level 3_2","030","HEO","HEO Level 3",2,42072,44072,44733,45804,46491,47421,49413]
[null,"HEO_HEO Level 3_3","030","HEO","HEO Level 3",3,47266,49266,50005,51155,51922,52960,55184]
[null,"HEO_HEO Level 3_4","030","HEO","HEO Level 3",4,51941,53941,54750,55971,56811,57947,60381]
[null,"HEO_HEO Level 3_5","030","HEO","HEO Level 3",5,53757,55757,56593,57842,58710,59884,62399]
[null,"HEO_HEO Level 3_6","030","HEO","HEO Level 3",6,55580,57580,58444,59721,60617,61829,64426]
[null,"HEO_HEO Level 3_7","030","HEO","HEO Level 3",7,57397,59397,60288,61592,62516,63766,66444]
[null,"HEO_HEO Level 3_8","030","HEO","HEO Level 3",8,59214,61214,62132,63464,64416,65704,68464]
[null,"HEO_HEO Level 4_1","040","HEO","HEO Level 4",1,59735,61735,62661,64001,64961,66260,69043]
[null,"HEO_HEO Level 4_2","040","HEO","HEO Level 4",2,61546,63546,64499,65866,66854,68191,71055]
[null,"HEO_HEO Level 4_3","040","HEO","HEO Level 4",3,63625,65625,66609,68008,69028,70409,73366]
[null,"HEO_HEO Level 4_4","040","HEO","HEO Level 4",4,65704,67704,68720,70151,71203,72627,75677]
[null,"HEO_HEO Level 5_1","050","HEO","HEO Level 5",1,67262,69262,70301,71756,72832,74289,77409]
[null,"HEO_HEO Level 5_2","050","HEO","HEO Level 5",2,69598,71598,72672,74162,75274,76779,80004]
[null,"HEO_HEO Level 5_3","050","HEO","HEO Level 5",3,72199,74199,75312,76842,77995,79555,82896]
[null,"HEO_HEO Level 5_4","050","HEO","HEO Level 5",4,75057,77057,78213,79786,80983,82603,86072]
[null,"HEO_HEO Level 5/6_1","054","HEO","HEO Level 5/6",1,61808,63808,64765,66136,67128,68471,71347]
[null,"HEO_HEO Level 5/6_2","054","HEO","HEO Level 5/6",2,63370,65370,66351,67746,68762,70137,73083]
[null,"HEO_HEO Level 5/6_3","054","HEO","HEO Level 5/6",3,64925,66925,67929,69348,70388,71796,74811]
[null,"HEO_HEO Level 5/6_4","054","HEO","HEO Level 5/6",4,75316,77316,78476,80053,81254,82879,86360]
[null,"HEO_HEO Level 5/6_5","054","HEO","HEO Level 5/6",5,77393,79393,80584,82193,83426,85095,88669]
[null,"HEO_HEO Level 5/6_6","054","HEO","HEO Level 5/6",6,79473,81473,82695,84335,85600,87312,90979]
[null,{"$f":"D71&\"_\"&E71&\"_\"&F71","v":"HEO_HEO Level 5/6_7"},"054","HEO","HEO Level 5/6",7,81548,83548,84801,86473,87770,89525,93285]
[null,"HEO_HEO Level 6_1","060","HEO","HEO Level 6",1,75316,77316,78476,80053,81254,82879,86360]
[null,"HEO_HEO Level 6_2","060","HEO","HEO Level 6",2,77393,79393,80584,82193,83426,85095,88669]
[null,"HEO_HEO Level 6_3","060","HEO","HEO Level 6",3,79473,81473,82695,84335,85600,87312,90979]
[null,"HEO_HEO Level 6_4","060","HEO","HEO Level 6",4,81548,83548,84801,86473,87770,89525,93285]
[null,"HEO_HEO Level 7_1","070","HEO","HEO Level 7",1,83105,85105,86382,88078,89399,91187,95017]
[null,"HEO_HEO Level 7_2","070","HEO","HEO Level 7",2,85441,87441,88753,90484,91841,93678,97612]
[null,"HEO_HEO Level 7_3","070","HEO","HEO Level 7",3,88038,90038,91389,93160,94557,96448,100499]
[null,"HEO_HEO Level 7_4","070","HEO","HEO Level 7",4,90639,92639,94029,95839,97277,99223,103390]
[null,"HEO_HEO Level 7_5","070","HEO","HEO Level 7",5,93231,95231,96659,98509,99987,101987,106270]
[null,"HEO_HEO Level 8_1","080","HEO","HEO Level 8",1,93493,95493,96925,98779,100261,102266,106561]
[null,"HEO_HEO Level 8_2","080","HEO","HEO Level 8",2,96092,98092,99563,101456,102978,105038,109450]
[null,"HEO_HEO Level 8_3","080","HEO","HEO Level 8",3,98690,100690,102200,104133,105695,107809,112337]
[null,"HEO_HEO Level 8_4","080","HEO","HEO Level 8",4,101801,103801,105358,107338,108948,111127,115794]
[null,"HEO_HEO Level 8_5","080","HEO","HEO Level 8",5,105179,107179,108787,110819,112481,114731,119550]
[null,"HEO_HEO Level 9_1","091","HEO","HEO Level 9",1,109077,111077,112743,114834,116557,118888,123881]
[null,"HEO_HEO Level 9_2","091","HEO","HEO Level 9",2,112709,114709,116430,118576,120355,122762,127918]
[null,"HEO_HEO Level 9_3","091","HEO","HEO Level 9",3,116862,118862,120645,122855,124698,127192,132534]
[null,"HEO_HEO Level 10_1","100","HEO","HEO Level 10",1,120720,122720,124561,126829,128731,131306,136821]
[null,"HEO_HEO Level 10_2","100","HEO","HEO Level 10",2,124704,126704,128605,130934,132898,135556,141249]
[null,"HEO_HEO Level 10_3","100","HEO","HEO Level 10",3,128819,130819,132781,135173,137201,139945,145823]
[null,"SNR_Senior Manager 1_","100","SNR","Senior Manager 1",null,138446,140446,142553,145091,147267,150212,156521]
[null,"SNR_Senior Manager 2_","200","SNR","Senior Manager 2",null,155467,157467,159829,162626,165065,168366,175437]
[null,"SNR_Senior Manager 3_","300","SNR","Senior Manager 3",null,166099,168099,170620,173579,176183,179707,187255]
[null,"ELT_English Language Teachers A-C_1","102","ELT","English Language Teachers A-C",1,62177,64177,65140,66517,67515,68865,71757]
[null,"ELT_English Language Teachers A-C_2","102","ELT","English Language Teachers A-C",2,63336,65336,66316,67711,68727,70102,73046]
[null,"ELT_English Language Teachers A-C_3","102","ELT","English Language Teachers A-C",3,65656,67656,68671,70101,71153,72576,75624]
[null,"ELT_English Language Teachers A-C_4","102","ELT","English Language Teachers A-C",4,68029,70029,71079,72545,73633,75106,78260]
[null,"ELT_English Language Teachers A-C_5","102","ELT","English Language Teachers A-C",5,71725,73725,74831,76353,77498,79048,82368]
[null,"ELT_English Language Teachers A-C_6","102","ELT","English Language Teachers A-C",6,74188,76188,77331,78891,80074,81675,85105]
[null,"ELT_English Language Teachers A-C_7","102","ELT","English Language Teachers A-C",7,76651,78651,79831,81428,82649,84302,87843]
[null,"ELT_English Language Teachers A-C_8","102","ELT","English Language Teachers A-C",8,79114,81114,82331,83966,85225,86930,90581]
[null,"ELT_English Language Teachers A-C_9","102","ELT","English Language Teachers A-C",9,81826,83826,85083,86759,88060,89821,93593]
[null,"ELT_English Language Teachers A-C_10","102","ELT","English Language Teachers A-C",10,85013,87013,88318,90043,91394,93222,97137]
[null,"ELT_English Language Teachers A-C_11","102","ELT","English Language Teachers A-C",11,87984,89984,91334,93104,94501,96391,100439]
[null,"ELT_English Language Teachers A-C_12","102","ELT","English Language Teachers A-C",12,90600,92600,93989,95799,97236,99181,103347]
[null,"Director of Studies__1",null,"Director of Studies",null,1,96092,98092,99563,101456,102978,105038,109450]
[null,"Director of Studies__2",null,"Director of Studies",null,2,98690,100690,102200,104133,105695,107809,112337]
[null,"Director of Studies__3",null,"Director of Studies",null,3,101801,103801,105358,107338,108948,111127,115794]
[null,"Director of Studies__4",null,"Director of Studies",null,4,105179,107179,108787,110819,112481,114731,119550]
[null,"__ELT Allowance 1",null,null,null,"ELT Allowance 1",2570,2609,2648,2689,2729,2784,2901]
[null,"__ELT Allowance 2",null,null,null,"ELT Allowance 2",4313,4378,4444,4512,4580,4672,4868]
[null,"__ELT Allowance 3",null,null,null,"ELT Allowance 3",5920,6009,6099,6192,6285,6411,6680]
[null,"STF_Scholarly Teaching Fellow A_3",null,"STF","Scholarly Teaching Fellow A",3,73423,75423,76554,78102,79274,80859,82603.508000000002]
[null,"STF_Scholarly Teaching Fellow A_4",null,"STF","Scholarly Teaching Fellow A",4,77187,79187,80375,81981,83211,84875,86705.862000000008]
[null,"STF_Scholarly Teaching Fellow A_5",null,"STF","Scholarly Teaching Fellow A",5,80246,82246,83480,85132,86409,88137,90038.178]
[null,"STF_Scholarly Teaching Fellow A_6",null,"STF","Scholarly Teaching Fellow A",6,83307,85307,86587,88286,89610,91402,93373.62000000001]
[null,"STF_Scholarly Teaching Fellow A_7",null,"STF","Scholarly Teaching Fellow A",7,86368,88368,89694,91439,92811,94667,96709.062000000005]
[null,"STF_Scholarly Teaching Fellow A_8",null,"STF","Scholarly Teaching Fellow A",8,89425,91425,92796,94588,96007,97927,100039.29400000001]
[null,"STF_Scholarly Teaching Fellow B_1",null,"STF","Scholarly Teaching Fellow B",1,94135,96135,97577,99441,100933,102952,105172.186]
[null,"STF_Scholarly Teaching Fellow B_2",null,"STF","Scholarly Teaching Fellow B",2,97666,99666,101161,103078,104624,106716,109018.208]
[null,"STF_Scholarly Teaching Fellow B_3",null,"STF","Scholarly Teaching Fellow B",3,101190,103190,104738,106709,108310,110476,112859.02]
[null,"STF_Scholarly Teaching Fellow B_4",null,"STF","Scholarly Teaching Fellow B",4,104724,106724,108325,110350,112005,114245,116709.21]
[null,"STF_Scholarly Teaching Fellow B_5",null,"STF","Scholarly Teaching Fellow B",5,108251,110251,111905,113984,115694,118008,120553.148]
[null,"STF_Scholarly Teaching Fellow B_6",null,"STF","Scholarly Teaching Fellow B",6,111788,113788,115495,117627,119391,121779,124405.42200000001]
[null,"Agreed Salary__",null,"Agreed Salary",null,null,{"$f":"'Eff Jul 23 - Continuing FT'!$E$28","v":0},{"$f":"'Eff Jul 23 - Continuing FT'!$E$28","v":0},{"$f":"'Eff Jul 23 - Continuing FT'!$E$28","v":0},{"$f":"'Eff Jul 23 - Continuing FT'!$E$28","v":0},{"$f":"'Eff Jul 23 - Continuing FT'!$E$28","v":0},{"$f":"'Eff Jul 23 - Continuing FT'!$E$28","v":0}]

{"sheet":"BE_Lookup","index":4,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Drop Down Lookup"]
[null,null,null,null,null,null,null,"Category Lookup","Sub-type Lookup",null,"Classification Lookup"]
[null,null,null,null,"Salary Plan Code",null,null,"Category","Academic","Professional","List_ACA","List_HEO","List_Snr","List_ELT","List_STF","List_AgreedSal"]
[null,null,null,null,"Academic","ACA",null,"Academic","Academic","HEO","LEVEL A","HEO Level 1","Senior Manager 1","English Language Teachers A-C","Scholarly Teaching Fellow A","Agreed Salary"]
[null,null,null,null,"Scholarly Teaching Fellow","STF",null,"Professional","Scholarly Teaching Fellow","Senior Manager","LEVEL B","HEO Level 2","Senior Manager 2",null,"Scholarly Teaching Fellow B"]
[null,null,null,null,"HEO","HEO",null,"Agreed Salary",null,"English Language Teacher","LEVEL C","HEO Level 3","Senior Manager 3"]
[null,null,null,null,"Senior Manager","SNR",null,null,null,null,"LEVEL D","HEO Level 4"]
[null,null,null,null,"English Language Teacher","ELT",null,null,null,null,"LEVEL E","HEO Level 5"]
[null,null,null,null,null,null,null,null,null,null,null,"HEO Level 5/6"]
[null,null,null,null,null,null,null,null,null,null,null,"HEO Level 6"]
[null,null,null,null,null,null,null,null,null,null,null,"HEO Level 7"]
[null,null,null,null,null,null,null,null,null,null,null,"HEO Level 8"]
[null,null,null,null,null,null,null,null,null,null,null,"HEO Level 9"]
[null,null,null,null,null,null,null,null,null,null,null,"HEO Level 10"]
[]
[]
[null,null,null,null,"Salary Step Lookup",null,null,null,null,{"$f":"IF($G$15=BE_Lookup!$H$18, LU_LvlA, IF($G$15=BE_Lookup!$I$18, LU_LvlB, IF($G$15=BE_Lookup!$J$18, LU_LvlC, IF($G$15=BE_Lookup!$K$18, LU_LvlD, IF($G$15=BE_Lookup!$L$18, LU_LvlE, IF($G$15=BE_Lookup!$H$28, LU_Lvl1, IF($G$15=BE_Lookup!$I$28, LU_lvl2, IF($G$15=BE_Lookup!$J$28, LU_lvl3, IF($G$15=BE_Lookup!$K$28, LU_LVL4, IF($G$15=BE_Lookup!$L$28, LU_LVL5, IF($G$15=BE_Lookup!$M$28, LU_LVL56, IF($G$15=BE_Lookup!$N$28, LU_LVL6, IF($G$15=BE_Lookup!$O$28, LU_LVL7, IF($G$15=BE_Lookup!$P$28, LU_LVL8, IF($G$15=BE_Lookup!$Q$28, LU_LVL9, IF($G$15=BE_Lookup!$R$28, LU_LVL10, IF($G$15=BE_Lookup!$H$37, LU_ELT, IF($G$15=BE_Lookup!$I$37, LU_STF, IF($G$15=BE_Lookup!$K$37, LU_DS, \"\")))))))))))))))))))","v":""}]
[null,null,null,null,null,null,null,"LEVEL A","LEVEL B","LEVEL C","LEVEL D","LEVEL E"]
[null,null,null,null,"ACA_LEVEL A","LU_LVLA",null,1,1,1,1,1]
[null,null,null,null,"ACA_LEVEL B","LU_LVLB",null,2,2,2,2]
[null,null,null,null,"ACA_LEVEL C","LU_LVLC",null,3,3,3,3]
[null,null,null,null,"ACA_LEVEL D","LU_LVLD",null,4,4,4,4]
[null,null,null,null,"ACA_LEVEL E","LU_LVLE",null,5,5,5]
[null,null,null,null,"HEO_HEO Level 1","LU_LVL1",null,6,6,6]
[null,null,null,null,"HEO_HEO Level 2","LU_LVL2",null,7]
[null,null,null,null,"HEO_HEO Level 3","LU_LVL3",null,8]
[null,null,null,null,"HEO_HEO Level 4","LU_LVL4"]
[null,null,null,null,"HEO_HEO Level 5","LU_LVL5",null,"HEO Level 1","HEO Level 2","HEO Level 3","HEO Level 4","HEO Level 5","HEO Level 5/6","HEO Level 6","HEO Level 7","HEO Level 8","HEO Level 9","HEO Level 10"]
[null,null,null,null,"HEO_HEO Level 5/6","LU_LVL56",null,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"HEO_HEO Level 6","LU_LVL6",null,2,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,"HEO_HEO Level 7","LU_LVL7",null,3,3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,"HEO_HEO Level 8","LU_LVL8",null,4,4,4,4,4,4,4,4,4]
[null,null,null,null,"HEO_HEO Level 9","LU_LVL9",null,5,5,5,null,null,5,null,5,5]
[null,null,null,null,"HEO_HEO Level 10","LU_LVL10",null,6,6,6,null,null,6]
[null,null,null,null,"SNR_Senior Manager 1","LU_Snr",null,7,7,7,null,null,7]
[null,null,null,null,"SNR_Senior Manager 2","LU_Snr",null,null,null,8]
[null,null,null,null,"SNR_Senior Manager 3","LU_Snr",null,"English Language Teachers A-C","Scholarly Teaching Fellow A","Scholarly Teaching Fellow B","Director of Studies"]
[null,null,null,null,"ELT_English Language Teachers A-C","LU_ELT",null,1,3,1,1]
[null,null,null,null,"Director of Studies__","LU_DS",null,2,4,2,2]
[null,null,null,null,"STF_Scholarly Teaching Fellow A","LU_STFA",null,3,5,3,3]
[null,null,null,null,"STF_Scholarly Teaching Fellow B","LU_STFB",null,4,6,4,4]
[null,null,null,null,"Agreed Salary_",null,null,5,7,5]
[null,null,null,null,null,null,null,6,8,6]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,12]
[]
[]
[null,null,null,null,"Super Lookup"]
[null,null,null,null,"Year","< 2 Year","> 2 Year","Casuals"]
[null,null,null,null,2017,9.5000000000000001E-2,0.17,9.5000000000000001E-2]
[null,null,null,null,2018,9.5000000000000001E-2,0.17,9.5000000000000001E-2]
[null,null,null,null,2019,9.5000000000000001E-2,0.17,9.5000000000000001E-2]
[null,null,null,null,2020,9.5000000000000001E-2,0.17,9.5000000000000001E-2]
[null,null,null,null,2021,0.17,0.17,0.1]
[null,null,null,null,2022,0.17,0.17,0.105]
[null,null,null,null,2023,0.17,0.17,0.11]