{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CALCULATOR","Lookup_Salary Plan","Lookup_Others","BE_Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"CALCULATOR","index":0,"n_rows":105,"n_cols":23,"rows_kept":105,"cut":false,"hidden":false,"merged":[[7,1,7,7],[8,1,8,7],[65,1,65,8],[66,1,66,8],[77,1,77,8],[102,1,102,8],[103,1,103,8],[93,1,93,8],[74,1,74,8],[67,1,67,8],[73,1,73,8],[70,1,70,8]]}
[null,"Salary Admin Plan Code ",{"$f":"IF(C$13=\"Agreed Salary\",\"Agreed Salary\",VLOOKUP($C$14,BE_Lookup!$K$12:$L$16,2,FALSE))","v":{"$error":"#N/A"}},null,"year",12,6]
[null,"FTE",{"$f":"ROUND(C22/(36.75*2),6)","v":0}]
[]
[null,"Redundancy Calculator 2023 - Redundancy Payment Estimate"]
[]
[]
[]
[null,"This calculator is designed to assist continuing staff members who are interested in expressing interest in the University of Adelaide Voluntary Separation Scheme 2020 to calculate the approximate dollar value for a gross redundancy payment in accordance with Clause 6.7 of the University of Adelaide Enterprise Agreement 2017 – 2021."]
[null,"The approximate entitlement calculation contained herein is provided without prejudice and is an estimate only. A formal quote, by Human Resources, will apply in the case of an actual redundancy payment, and a variation between a formal quote and the estimate contained in this calculator cannot be used to dispute the accuracy of a formal quote."]
[]
[null,"Please select the salary plan,  input the work hours per fortnight,  the years of completed service and date of birth."]
[]
[null,"Academic / Professional/ Agreed Salary"]
[null,"Sub-type"]
[null,"Classification"]
[null,"Salary Step"]
[]
[null,"Clinical Loading:"]
[null,"ELT Allowance:"]
[]
[null,"Agreed Salary Amount"]
[null,"Hours per fortnight"]
[null,"Full-time hours per fortnight are 73.5. Your current hours per fortnight appears as \"units\" on your payslip."]
[]
[null,"Separation Date"]
[null,"This is for modelling purposes only. The actual redundancy date will be determined by the University."]
[]
[null,{"$f":"\"Years of Completed Service at \"&TEXT($C$25,\"DD MMM YYYY\")","v":"Years of Completed Service at 00 Jan 1900"},null,"Refer notes below for further information about years of completed service."]
[]
[null,"Date of Birth"]
[null,{"$f":"\"Age at \"&TEXT($C$25,\"DD MMM YYYY\")","v":"Age at 00 Jan 1900"},{"$f":"IF(C30=\"\",\"\",YEARFRAC(C30,C25))","v":""}]
[null,"Reached Preservation Age?",{"$f":"IF(DOB=\"\",\"\", IF(AND(DOB<U87,AGE>W87),\"Y\",IF(AND(AND(DOB>=U87,DOB<U88),AGE>=W88),\"Y\",IF(AND(AND(DOB>=U88,DOB<U89),AGE>=W89),\"Y\",IF(AND(AND(DOB>=U89,DOB<U90),AGE>=W90),\"Y\",IF(AND(AND(DOB>=U90,DOB<U91),AGE>=W91),\"Y\",IF(AND(DOB>=U91,AGE>=W92),\"Y\",\"N\")))))))","v":""},"Refer notes below for further information about preservation age."]
[null,"Pension Age?",{"$f":"IF(DOB=\"\",\"\", IF(AND(DOB<U97, AGE>=W96),\"Y\", IF( AND(AND(DOB>=U97,DOB<U98),AGE>=W97),\"Y\",IF(AND(AND(DOB>=U98,DOB<U99),AGE>=W98),\"Y\",IF(AND(AND(DOB>=U99,DOB<U100),AGE>=W99),\"Y\", IF(AND(DOB>=U100, AGE>=W100),\"Y\",\"N\"))))))","v":""},"Refer notes below for further information about pension age."]
[]
[null,"Salary Details","Annual","Fortnightly","Weekly"]
[null,"Salary",{"$f":"IFERROR( VLOOKUP( $C$1&\"_\"&$C$15&\"_\"&$C$16,Lookup_Salary_Plan, $F$1, FALSE)*$C$2,\"\")","v":""},{"$f":"IFERROR(C36/26,\"\")","v":""},{"$f":"IFERROR(D36/2,\"\")","v":""}]
[null,{"$f":"IF(AND($C$18=\"\",$C$19=\"\"),\"\",IF($C$18<>\"\",$C$18,IF($C$19<>\"\",$C$19)))","v":""},{"$f":"IF($B37=\"\",\"\",IF($C$18<>\"\",VLOOKUP($B37,ACA_LOADINGS,$G$1,FALSE)*$C$2,IF($C$19<>\"\",VLOOKUP($B37,ELT_Allowance,$G$1,FALSE)*$C$2)))","v":""},{"$f":"IFERROR(C37/26,\"\")","v":""},{"$f":"IFERROR(D37/2,\"\")","v":""}]
[null,"Current Salary",{"$f":"SUM(C36:C37)","v":0},0,0]
[]
[]
[null,"Redundancy payment estimate"]
[null,{"$f":"\"assuming employment end date of \"&TEXT($C$25,\"DD MMM YYYY\")","v":"assuming employment end date of 00 Jan 1900"}]
[]
[null,"Estimated Entitlement in weeks"]
[null,"Transition Period",8]
[null,"Entitlement Period",{"$f":"IF($C$31=\"\",\"\",(IF($C$31<40,18,IF(AND($C$31>=40, $C$31<45),20, IF($C$31>=45,22)))))","v":""}]
[null,"Severance Pay (capped at 56 weeks)",{"$f":"IF($C$28=\"\", \"\", IF(($C$28*3)>56,56, ($C$28*3)))","v":""}]
[null,"Total weeks (capped at 82 wks)",{"$f":"IF(SUM($C$45:$C$47)>82,82,SUM($C$45:$C$47))","v":8}]
[]
[null,"Package Details"]
[null,"Approximated Entitlement",null,{"$f":"$C$48*$E$38","v":0}]
[null,"(weekly salary x Estimated Entitlement in weeks)"]
[]
[null,"Tax free Component",null,{"$f":"IF($C$28=\"\",\"\",IF($C33=\"Y\", 0, TFC_Base +(( TFC_eachYOS)*$C$28)))","v":""}]
[null,"Taxable Amount",null,{"$f":"IFERROR(IF($D$51-$D$54<0, 0, $D$51-$D$54),\"\")","v":""}]
[null,"Tax Rate (up to $235K)",{"$f":"IFERROR(IF($D$55=\"\", \"\", VLOOKUP($C$32,TAXABLE_RATE,3,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF($D$55>=Taxable_Threshold, Taxable_Threshold*$C56,$D$55*$C56),\"\")","v":""}]
[null,"Tax Rate (after the first $235K)",{"$f":"IFERROR(IF($D$55=\"\", \"\", IF($D$55<Taxable_Threshold, \"-\", IF($D$55>=Taxable_Threshold,\"47%\",VLOOKUP($C$32,TAXABLE_RATE,3,FALSE)))),\"\")","v":""},{"$f":"IFERROR(IF($D$55>=Taxable_Threshold,($D$55-Taxable_Threshold)*$C57,0),\"\")","v":""}]
[null,"Tax Amount",null,{"$f":"SUM($D$56:$D$57)","v":0}]
[]
[null,"Net Estimated Amount",null,{"$f":"IFERROR($D$51-$D$58,\"\")","v":0}," Excludes payment of leave entitlements. See below for information about calculating gross leave payment. "]
[]
[]
[null,"NOTES / DEFINITIONS"]
[]
[null,"Years of Completed Service"]
[null,"- Please round down to the whole number. Eg if you have completed 5.5 years with the University, your number of completed years is 5."]
[null,"- Service with other organisations will not be taken into consideration when calculating length of service for redundancy entitlements."]
[null,"- Any period of leave without pay greater than 21 days will have an impact on length of service for redundancy purposes and therefore on the redundancy payment calculation. This simple calculator is unable to take leave without pay into account."]
[]
[null,"Hours per Fortnight"]
[null,"- Where a staff member has worked varied fractions during their employment (for example, periods of full time and part time employment), the redundancy payment calculation will be proportionate to such periods of service. This simple calculator is unable to take varied employment fractions into account."]
[]
[null,"Estimated Entitlement "]
[null,"- The severance pay component of a redundancy calculation is capped at 56 weeks under the Enterprise Agreement. The calculation of severance pay (C45) is automatically capped at 56 weeks."]
[null,"- The maximum redundancy payment entitlement is 82 weeks under the Enterprise Agreement. The calculation of the total redunancy payment (C46) is automatically capped at 82 weeks."]
[]
[null,"Preservation Age"]
[null,"- Preservation age is the age you can access your superannuation if you are retired (or start a transition to retirement income stream).  Once preservation age is reached the taxable component of the redundancy payment is taxed at a lower rate of 17% for amounts up to $235,000 and 47% on any amount over $235,000. Please see tables below for preservation age (dependent on birth date) and taxation treatment for those under and over preservation age."]
[null,"Date of birth","Preservation age",null,"Age as at 30 June ","Rate of tax 2023/24"]
[null,"Before 1 July 1960",{"$f":"W87","v":55},null,"Under Preservation age","30% up to $235,000"]
[null,"1 July 1960 to 30 June 1961",56,null,null,"45% on excess over $235,000"]
[null,"1 July 1961 to 30 June 1962",57,null,"Preservation age or older","15% up to $235,000"]
[null,"1 July 1962 to 30 June 1963",58,null,null,"45% on excess over $235,000"]
[null,"1 July 1963 to 30 June 1964",59]
[null,"From 1 July 1964",60]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1960-07-01","1961-06-30",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1961-07-01","1962-06-30",56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1962-07-01","1963-06-30",57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1963-07-01","1964-06-30",58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1964-07-01",null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,"Pension Age"]
[null,"- If you have reached pension age or older on the date that employment terminates by way of redundancy, then the tax treatment of the redundancy payment differs from that above.  The whole redundancy payment (not just the taxable amount) is taxed at 17% for amounts up to $235,000 and 47% on any amount over $235,000."]
[null,"Date of Birth","Qualifying Pension Age"]
[null,"Before 1 July 1952","65 yrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1952-07-01",65]
[null,"1 July 1952 to 31 December 1953","65 yrs and 6 mths",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1952-07-01","1953-12-31",65.5]
[null,"1 January 1954 to 30 June 1955","66 yrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1954-01-01","1955-06-30",66]
[null,"1 July 1955 to 31 December 1956","66 yrs and 6 mths",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1955-07-01","1956-12-31",66.5]
[null,"On or after 1 January 1957","67 yrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1957-01-01",null,67]
[]
[null,"Accrued Leave Entitlements"]
[null,"- Any long service leave and annual leave entitlements due and accrued up to your final day will be paid with your final payment. These are not included in the calculation above."]
[null,{"$f":"\"- Please log onto Staff Services Online (SSO) to check your current leave balances. To forecast the leave balances as of \"&TEXT($C$25,\"DD MMM YYYY\")&\" and the gross leave payment, multiply the number of hours by your hourly rate. \"","v":"- Please log onto Staff Services Online (SSO) to check your current leave balances. To forecast the leave balances as of 00 Jan 1900 and the gross leave payment, multiply the number of hours by your hourly rate. "}]
[null,"You can find your salary expressed as an hourly rate on your payslip (see Rate in the Base Pay line of the Payment Details section of your payslip) which is also available on SSO."]

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

{"sheet":"Lookup_Others","index":2,"n_rows":112,"n_cols":13,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Salary Admin Plan Code ","Salary Grade Code ","Salary Grade ","Step ",null,null,null,null,"Seperation Date"]
[null,null,null,"ACA","211","Level E","1"]
[null,null,null,"ACA","221","Level D","1"]
[null,null,null,"ACA","221","Level D","2"]
[null,null,null,"ACA","221","Level D","3"]
[null,null,null,"ACA","221","Level D","4"]
[null,null,null,"ACA","231","Level C","1"]
[null,null,null,"ACA","231","Level C","2"]
[null,null,null,"ACA","231","Level C","3"]
[null,null,null,"ACA","231","Level C","4"]
[null,null,null,"ACA","231","Level C","5"]
[null,null,null,"ACA","231","Level C","6"]
[null,null,null,"ACA","241","Level B","1"]
[null,null,null,"ACA","241","Level B","2"]
[null,null,null,"ACA","241","Level B","3"]
[null,null,null,"ACA","241","Level B","4"]
[null,null,null,"ACA","241","Level B","5"]
[null,null,null,"ACA","241","Level B","6"]
[null,null,null,"ACA","251","Level A","1"]
[null,null,null,"ACA","251","Level A","2"]
[null,null,null,"ACA","251","Level A","3"]
[null,null,null,"ACA","251","Level A","4"]
[null,null,null,"ACA","251","Level A","5"]
[null,null,null,"ACA","251","Level A","6"]
[null,null,null,"ACA","251","Level A","7"]
[null,null,null,"ACA","251","Level A","8"]
[null,null,null,"ELT","102","English Language Teachers A-C","3"]
[null,null,null,"ELT","102","English Language Teachers A-C","8"]
[null,null,null,"ELT","102","English Language Teachers A-C","11"]
[null,null,null,"ELT","102","English Language Teachers A-C","12"]
[null,null,null,"HEO","020","HEO Level 2","4"]
[null,null,null,"HEO","020","HEO Level 2","6"]
[null,null,null,"HEO","020","HEO Level 2","7"]
[null,null,null,"HEO","030","HEO Level 3","4"]
[null,null,null,"HEO","030","HEO Level 3","5"]
[null,null,null,"HEO","030","HEO Level 3","6"]
[null,null,null,"HEO","030","HEO Level 3","7"]
[null,null,null,"HEO","030","HEO Level 3","8"]
[null,null,null,"HEO","035","Security Staff (HEO2)","3"]
[null,null,null,"HEO","037","Security Staff (HEO3)","3"]
[null,null,null,"HEO","040","HEO Level 4","1"]
[null,null,null,"HEO","040","HEO Level 4","2"]
[null,null,null,"HEO","040","HEO Level 4","3"]
[null,null,null,"HEO","040","HEO Level 4","4"]
[null,null,null,"HEO","050","HEO Level 5","1"]
[null,null,null,"HEO","050","HEO Level 5","2"]
[null,null,null,"HEO","050","HEO Level 5","3"]
[null,null,null,"HEO","050","HEO Level 5","4"]
[null,null,null,"HEO","054","HEO Level 5/6","2"]
[null,null,null,"HEO","054","HEO Level 5/6","7"]
[null,null,null,"HEO","060","HEO Level 6","1"]
[null,null,null,"HEO","060","HEO Level 6","2"]
[null,null,null,"HEO","060","HEO Level 6","3"]
[null,null,null,"HEO","060","HEO Level 6","4"]
[null,null,null,"HEO","070","HEO Level 7","1"]
[null,null,null,"HEO","070","HEO Level 7","2"]
[null,null,null,"HEO","070","HEO Level 7","3"]
[null,null,null,"HEO","070","HEO Level 7","4"]
[null,null,null,"HEO","070","HEO Level 7","5"]
[null,null,null,"HEO","080","HEO Level 8","1"]
[null,null,null,"HEO","080","HEO Level 8","2"]
[null,null,null,"HEO","080","HEO Level 8","3"]
[null,null,null,"HEO","080","HEO Level 8","4"]
[null,null,null,"HEO","080","HEO Level 8","5"]
[null,null,null,"HEO","091","HEO Level 9","1"]
[null,null,null,"HEO","091","HEO Level 9","2"]
[null,null,null,"HEO","091","HEO Level 9","3"]
[null,null,null,"HEO","100","HEO Level 10","1"]
[null,null,null,"HEO","100","HEO Level 10","2"]
[null,null,null,"HEO","100","HEO Level 10","3"]
[null,null,null,"SNR","100","Senior Manager 1","1",null,null,null,null,"2021-01-15"]
[null,null,null,"SNR","200","Senior Manager 2","1",null,null,null,null,"2021-02-12"]
[null,null,null,"STF","LVA","Scholarly Teaching Fellow A","6"]
[null,null,null,"STF","LVB","Scholarly Teaching Fellow B","1"]
[null,null,null,"STF","LVB","Scholarly Teaching Fellow B","3"]
[null,null,null,"STF","LVB","Scholarly Teaching Fellow B","4"]
[null,null,null,"STF","LVB","Scholarly Teaching Fellow B","5"]
[null,null,null,"STF","LVB","Scholarly Teaching Fellow B","6"]
[null,null,null,"UNK","UNK","Unknown","0"]
[]
[]
[]
[]
[]
[]
[null,null,null,"ACA","LEVEL A",1]
[null,null,null,"HEO","LEVEL B",2,null,null,null,null,null,"RESP LDG AMT","Responsibility Loading Amount"]
[null,null,null,"SNR","LEVEL C",3,null,null,null,null,null,"PERF BONUS"]
[null,null,null,"ELT","LEVEL D",4,null,null,null,null,null,"FRGN INCM TX"]
[null,null,null,null,"LEVEL E",5,null,null,null,null,null,"ATT/RET AMT","Attraction/Retention Amount"]
[null,null,null,null,"HEO Level 1",6,null,null,null,null,null,"HDA FLAT AMT"]
[null,null,null,null,"HEO Level 2",7,null,null,null,null,null,"PRE-RET LDG","Pre-Retirement Loading LDG"]
[null,null,null,null,"HEO Level 3",8,null,null,null,null,null,"HOS ALL","Head of School Allowance ALL"]
[null,null,null,null,"HEO Level 4",9,null,null,null,null,null,"DEANS ALL","Deans Allowance ALL"]
[null,null,null,null,"HEO Level 5",10,null,null,null,null,null,"ACCOM ALL","Accommodation Allowance ALL"]
[null,null,null,null,"HEO Level 5/6",11,null,null,null,null,null,"NH&MRC LDG","NH&MRC Loading LDG"]
[null,null,null,null,"HEO Level 6",12]
[null,null,null,null,"HEO Level 7",null,null,null,null,null,null,null,"Co-ordination Allowance"]
[null,null,null,null,"HEO Level 8",null,null,null,null,null,null,null,"Higher Duties ALL"]
[null,null,null,null,"HEO Level 9",null,null,null,null,null,null,null,"ARC Level"]
[null,null,null,null,"HEO Level 10",null,null,null,null,null,null,null,"Dental Attraction/Retention"]
[null,null,null,null,"Senior Manager 1",null,null,null,null,null,null,null,"Health Insurance Loading LDG"]
[null,null,null,null,"Senior Manager 2",null,null,null,null,null,null,null,"Att/Ret Diff between levels"]
[null,null,null,null,"Senior Manager 3"]
[null,null,null,null,"English Language Teachers A-C"]
[null,null,null,null,"Scholarly Teaching Fellow A"]
[null,null,null,null,"Scholarly Teaching Fellow B"]
[null,null,null,null,"Agreed Salary"]

{"sheet":"BE_Lookup","index":3,"n_rows":124,"n_cols":13,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Tax Free Component",null,null,null,null,null,null,null,null,"Academic","Professional"]
[null,"As at","2023/243",null,null,null,null,null,null,null,"Academic","HEO"]
["TFC_Base","Base Limit",11985,null,null,null,null,null,null,null,"Scholarly Teaching Fellow","Senior Manager"]
["TFC_eachYOS","For each complete year of service",5994,null,null,null,null,null,null,null,null,"English Language Teacher"]
[]
[]
[]
[null,"Age as at 30 June ","Rate of tax 2023/24"]
[null,null,"UP TO","OVER",null,null,null,null,null,null,"Academic","ACA"]
["TAXABLE_THRESHOLD","TAXABLE_THRESHOLD",235000,null,null,null,null,null,null,null,"Scholarly Teaching Fellow","STF"]
["N","Under Preservation age",0.32,0.45,null,null,null,null,null,null,"HEO","HEO"]
["Y","Preservation age or older",0.15,0.45,null,null,null,null,null,null,"Senior Manager","SNR"]
[null,null,null,null,null,null,null,null,null,null,"English Language Teacher","ELT"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"LVA","Scholarly Teaching Fellow A"]
[null,null,null,null,null,null,null,null,null,null,"LVB","Scholarly Teaching Fellow B"]
[null,"Date of birth","Preservation age","2021-02-12"]
["1960-07-01","Before 1 July 1960",55,{"$f":"YEARFRAC(A23,D22)","v":60.613888888888887}]
[null,"1 July 1960 to 30June 1961",56,{"$f":"YEARFRAC(A24,D23)","v":0.16388888888888889}]
[null,"1 July 1961 to 30June 1962",57,0]
[null,"1 July 1962 to 30June 1963",58,0]
[null,"1 July 1963 to 30June 1964",59,0]
[null,"From 1 July 1964",60,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Director of Studies",1]
[null,null,null,null,null,null,null,null,null,null,null,"Director of Studies",2]
[null,null,null,null,null,null,null,null,null,null,null,"Director of Studies",3]
[null,null,null,null,null,null,null,null,null,null,null,"Director of Studies",4]
[null,null,null,null,null,null,null,null,null,null,null,null,"ELT Allowance 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ELT Allowance 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ELT Allowance 3"]