{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1","2 Letter Front","3 Contract Details","4 Confirmation of Funding"],"not_rendered":{"charts":0,"images":4,"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":"1","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[3,0,3,1],[5,0,5,1],[1,0,1,1],[2,0,2,1],[7,0,7,1],[8,0,8,1],[6,0,6,1],[4,0,4,1]]}
[null,"Human Resources Division                                                                                           Graduate Teaching Assistants and Guest Teacher Contract                                                                                        (1 August 2023 - 31 July 2024)"]
["This Excel workbook should be used to create new and additional contracts for new Graduate Teaching Assistants and Guest Teachers, using the 2023/24 payment system."]
["Creating the Contract Details:\nSelect tab 3, 'Contract Details'. \nComplete all the input boxes on the worksheet, using [TAB] to move between them. \nFollow the instructions which appear in message boxes as you [TAB] through. \nOnce you have entered all the required information, the appropriate rates of pay will be calculated automatically."]
["When requesting an hourly-paid contract you will need to provide information about the individual’s Right to Work.  \n\n1. Does the appointee have the right to work in the UK (y/n)?  \nYou will need to ask the appointee whether they have the right to work in the UK already. UK nationals, Irish Nationals and EEA nationals currently in the UK with pre-settled or settled status have the right to work in the UK without restriction.\n\n2.  If yes, what is their current immigration status?\nPlease select the relevant category from the drop down list. This will help to flag up the individual’s immigration status to identify whether their current status will permit them to work in this role\n\n3. What is the expiry date of their visa (select n/a if not applicable)\nIf the individual needs a visa to work in the UK, ask them what the expiry date of their visa is and put that in the field.  The contract will be issued until this date and they will not be able to have an extension unless they have renewed their visa.  If the individual does not need a visa to work, or their visa has no expiry date, please put N/A in the field."]
["Now select tab 4 'Confirmation of Funding'. The appropriate contract details will be copied into the form. Now [TAB] through to fill in the expected hours per week and the funding details - up to two budget codes can be input to allow for split-funded posts. "]
["Until completed, each mandatory field on tabs 2 and 3 will appear as an orange shaded box. As you complete the required fields, these will change to white. Only when the contract is complete will the ERROR message disappear.  Please note that Human Resources are unable to accept incomplete contracts and will return incomplete contracts to departments as soon as possible.\n\n(NB signed hard copies are no longer required.)"]
["Once you have finished, please save the contract using the following format 'Surname,Name_GT/GTA contract_Start date'.  Please make sure that you use the most up to date version of the template as available on the Human Resources website. "]
["Please email the completed contract template to HR.Pay.Hourly@lse.ac.uk. Please ensure that the email of the contract to Human Resources is copied to both the manager and the budget/grant holder."]
["If you have any problems with or questions about this template, please email HR.Pay.Hourly@lse.ac.uk."]
["Version History:\n"]
[1,"Academic Session, 2023-24"]
[1.01,"Employers NI and USS contribution updated"]

{"sheet":"2 Letter Front","index":1,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,0,7,6],[10,0,10,6],[16,0,16,6],[1,5,1,6],[2,0,2,6],[3,0,3,6],[5,0,5,6],[6,0,6,6],[9,0,9,6],[14,0,14,16383],[8,0,8,6],[12,0,12,6],[13,0,13,6],[11,0,11,16383]]}
[]
[{"$f":"IF(ISBLANK('3 Contract Details'!D3),\"\",\"Dear\"&\" \"&'3 Contract Details'!D3&\" \"&'3 Contract Details'!F3&\",\")","v":""}]
[{"$f":"IF(OR(ISBLANK('3 Contract Details'!B3),ISBLANK('3 Contract Details'!F15)),\"\",\"On behalf of the London School of Economics and Political Science, I am very pleased to offer you an appointment as a \"&'3 Contract Details'!F15&\". This contract is issued subject to the right to work clarifications expressed.\")","v":""}]
["On the next page, you will find more details regarding your contract of employment. Please read both this and the next pages thoroughly before proceeding to sign."]
["Right to Work"]
["This offer is made subject to you having the right to work in the UK and your start date is subject to you being able to present proof of your right to work before you undertake any work for LSE.\n\nYou are required to provide proof of your right to work as soon as possible after receiving this letter and no later than 9:30am on your start date, in accordance with the current Home Office guidelines for acceptable right to work documents.  Please refer to Annex A for the full list of accepted documents.  \n\nFrom 1 October 2022, if you are a UK or Irish national, or a non-UK national arriving in the UK with a vignette (visa sticker) in your passport, you will need to go to the HR division in person with your original documents for a right to work check before you start work. \n\nIf you are a non-UK national with an eVisa or BRP card, you can attend a virtual right to work check before you start work. The HR Operations team will contact you before your start date to arrange this.\n\nIn the event that you are unable to provide proof of your right to work by 9:30am on your first day, or that the documents that you have presented do not meet the current Home Office guidelines (as listed in Annex 2) you will not be allowed to start work. Your start date will be deferred until your right to work status is formally confirmed by the HR Operations team. Your salary, continuous service and other such related benefits will start from your new start date. Salary cannot be backdated.  The School reserves the right not to pay an individual for any work undertaken before a satisfactory right to work check is completed.\n\nYou are required to demonstrate that you have the right to work for the duration of your contract. If you have a visa with an expiry date, it is your responsibility to ensure that you have taken appropriate steps to renew your visa or switch to another immigration category before your visa expires. You will be required to present evidence to the HR Division of an application in progress so that further checks can be made before your visa expires.\n\nIf you are unable to provide evidence that you have submitted an application to renew your visa or change to another visa category before your visa expires, your employment may be at risk and you will be required to stop work on the expiry date of your visa. If you are required to stop work your salary, continuous service and other such related benefits will cease until you are able to provide evidence of your right to work status."]
["Renewing your visa \nYou are required to demonstrate that you have the right to work for the duration of your contract.  If you have a visa with an expiry date, it is your responsibility to ensure that you have taken appropriate steps to renew your visa, or switch to another immigration category before your visa expires.  You will be required to present evidence to the HR Division of an application in progress so that further checks can be made before your visa expires.\n\nIf you are unable to provide evidence that you have submitted an application to renew your visa, or change to another visa category before your visa expires, your employment will be at risk and you will be required to stop work on the expiry date of your visa.  If you are required to stop work your salary, continuous service and other such related benefits will cease until you are able to provide evidence of your right to work status.  \n"]
["Pension"]
["You may apply to join one of the School's pension schemes (SAUL for staff in bands 1-5; USS for bands 6 and above), please contact the Pensions Team for further information HR.Pensions@LSE.ac.uk. The School must enrol staff that earn over £833 per month (2023/2024), are aged 22 or over and are under state pension age. The School will assess this criteria each month but, in order to smooth the automatic enrolment duty in respect of employees with rare spikes in earnings, automatic enrolment may be postponed up to three months from the first day of employment or the date at which an employee first becomes an ‘eligible jobholder’.  Employees who meet the qualifying criteria will receive e-mail confirmation of automatic enrolment.  Employees who do not meet the criteria can ask to join the scheme at any point.  \n\nExisting members of either SAUL or USS will be automatically placed into the appropriate scheme upon commencement of a new eligible post. If you decide not to join the pension scheme on your additional post, you can opt out by filling out the forms on the scheme website and returning them to the HR pension team, this must be done on or after your first day. You will be re-assessed broadly every three years from the date at which the School first had to follow the new pension laws, to determine whether you still qualify at that time.  This process is known as re-enrolment.\n\nPlease ensure you read the additional pensions document attached to your email from HR."]
["Next steps\nIf you wish to accept this offer please come to the HR Division as soon as possible and no later than the start date of your contract bringing with you your original Right to Work documents. In addition please sign and return one copy of this contract, together with (if relevant) the enclosed 'Bank/Building Society Details', 'Employee Details' and 'P45' forms. Please let us know if your details change.  If you are unable to take up this offer of engagement, please contact the manager/supervisor named above immediately.\n\n\n"]
["\nIf you wish to accept this offer please provide your Right to Work documents to the HR Division (LRB 5.01) as soon as possible and no later than the start date of your contract. In addition please sign and return one copy of this contract, together with (if relevant) the enclosed 'Bank/Building Society Details', 'Employee Details' and 'P45' forms. Please let us know if your details change.  If you are unable to take up this offer of engagement, please contact the manager/supervisor named above immediately.\n"]
["Safe working and wellbeing "]
["The School is committed to the safe working and wellbeing of all our staff. If you believe that you may be at higher risk due your personal health or any ongoing disability, please do let your line manager know so that we can arrange an individual risk assessment for you and make any necessary work adjustments.\nPlease download the form here:\n"]
["https://info.lse.ac.uk/staff/divisions/Human-Resources/Assets/Documents/Forms/LSE-Individual-Risk-Assessment-All-Staff-at-LSE-March-2023-latest-approved.doc  "]
["If you wish to accept this contract. Please indicate so by signing at the bottom of either page of your contract and returning it by email to HR.Pay.Hourly@lse.ac.uk. "]
["Yours sincerely,"]
[]
["Human Resources"]

{"sheet":"3 Contract Details","index":2,"n_rows":251,"n_cols":20,"rows_kept":251,"cut":false,"hidden":false,"merged":[[40,0,40,12],[25,5,25,12],[2,5,2,6],[2,8,2,12],[27,5,27,7],[28,5,28,7],[3,8,3,12],[7,5,10,12],[4,6,4,12],[5,6,5,12],[20,5,20,12],[21,5,21,12],[22,5,22,12],[13,5,13,12],[14,5,14,12],[16,5,16,12],[30,5,30,7],[39,0,39,12],[29,5,29,7],[5,1,5,2],[26,5,26,7],[19,5,19,12],[18,5,18,12],[15,5,15,12],[17,5,17,12],[0,2,0,3],[47,0,47,12],[61,1,62,6],[39,13,39,25],[23,5,23,12],[24,5,24,12],[44,0,44,12],[43,0,43,12],[55,0,55,12],[41,0,41,12],[35,1,35,2],[46,0,46,11],[45,0,45,11],[36,1,36,2],[37,1,37,2],[42,0,42,12]]}
[null,null,"(Teacher contract 23/24 v1.01)"]
[]
["To:                                                       Title: ",null,"First name:",null,"Surname:",null,null,"Address (line 1):"]
[null,null,null,null,null,null,null,"Address (line 2):"]
["Employee Number:",null,null,null,null,"     Date of birth:"]
["Post Number:",null,null,null,null,"                Email:"]
[]
["Dear Colleague,",null,null,null,null,{"$f":"IF(OR(ISERROR(F21),ISERROR(F22),ISERROR(F24),B3=\"\",D3=\"\",F3=\"\",I3=\"\",I4=\"\",B5=\"\",B6=\"\",G5=\"\",G6=\"\",F14=\"\",F15=\"\",F18=\"\",F20=\"\",F21=\"\",F22=\"\",F23=\"\",F24=\"\", F25=\"\",F27=\"\",A33=\"\",B33=\"\",C33=\"\",D33=\"\"),\"ERROR: invalid contract. Please ensure all orange boxes are complete and the correct Excel add-ins are loaded so that formulae work correctly (see notes on Tab 1).\",\"\")","v":"ERROR: invalid contract. Please ensure all orange boxes are complete and the correct Excel add-ins are loaded so that formulae work correctly (see notes on Tab 1)."}]
[]
["TEACHER APPOINTMENT"]
[]
["I have pleasure in offering you an appointment, as follows:"]
[]
["Name of Department/Institute:"]
["Job Title:"]
["Working for:"]
["Departmental Contact (full name & email address):"]
["GTA - LSE course on which the student is registered (if applicable):"]
["GT - Non LSE Course on which the student is registered (if applicable)"]
["Terms:"]
["Teaching Start Date:",null,null,null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F$20,Terms_Table,2,FALSE))","v":""}]
["Teaching End Date:",null,null,null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F$20,Terms_Table,3,FALSE))","v":""}]
["Salary Band and Step:"]
[{"$f":"IF(F15<>\"Emeritus Teacher\",\"Contract End Date if fixed-term appointment (last working day):\",\"End date of this post-retirement contract:\")","v":"Contract End Date if fixed-term appointment (last working day):"},null,null,null,null,{"$f":"$F$22","v":""}]
["Reason for fixed-term appointment (if applicable):",null,null,null,null,{"$f":"IF(F15=\"Graduate Teaching Assistant\",\"GTA Scheme\",IF(F15=\"Emeritus Teacher\",\"Not applicable\",IF(AND(F15=\"Guest Teacher\",F24=\"Not applicable\"),\"Not applicable\",\"\")))","v":""}]
[]
["Does the appointee have the right to work in the UK?"]
[{"$f":"IF($F$27=\"Yes\",\"What is their current immigration status?\",\"\")","v":""}]
[{"$f":"IF($F$27=\"Yes\",\"What is the start date of their visa?\",\"\")","v":""}]
[{"$f":"IF($F$27=\"Yes\",\"What is the expiry date of their visa?\",\"\")","v":""}]
["What type of student are they?",null,null,null,null,"4th Year PhD Student (Final year fulltime)"]
["Course Number, Title, Undergraduate(Ug) or Masters level (MSc) ","Term","Weeks","Number of groups","Contact hours ","Preparation (hours)","Lecture and Meeting Attendance (hours)","Office Hours","Items to be marked","Items marked per hour","Marking (hours)","Unit (full=1.0; half=0.5)","Administration (hours)","Line Total"]
[null,null,null,null,{"$f":"C33*D33","v":0},{"$f":"C33*2","v":0},{"$f":"C33","v":0},{"$f":"ROUNDUP(D33/3,0)*C33","v":0},{"$f":"D33*15*4","v":0},3,{"$f":"I33/J33","v":0},1,{"$f":"D33*15*0.5*L33","v":0},{"$f":"E33+F33+G33+H33+K33+M33","v":0}]
[]
[]
["From","To",null,"Holiday Entitlement (hours)","Total Hours (inc holiday)","Hours per Week (inc holiday)","FTE (inc holiday)","Monthly Salary",null,null,"Total Pay",null,null,"Total hours (excl. holiday)",{"$f":"SUM(N33:N34)","v":0},"Salary","1st Month Frac","Mid-months","Last Month Frac"]
[{"$f":"IF($F$20=\"\",\"\",IF($F$20=\"Specified Dates - see below\",F21,VLOOKUP($F$20,Terms_Table,2,FALSE)))","v":""},{"$f":"IF($F$20=\"\",\"\",IF($F$20=\"Specified Dates - see below\",F22,VLOOKUP($F$20,Terms_Table,5,FALSE)))","v":""},null,{"$f":"O37","v":0},{"$f":"P38","v":0},{"$f":"IF(E37=0,\"\",ROUND(E37/(NETWORKDAYS(A37,B37)/5),2))","v":""},{"$f":"IF(E37=0,\"\",F37/35)","v":""},{"$f":"IF(E37=0,\"\",P37/12)","v":""},null,null,{"$f":"IF(E37=0,\"\",ROUND(Q37*H37,2)+ROUND(R37*H37,2)+ROUND(S37*H37,2))","v":""},null,null,"Holidays hours",{"$f":"O36*0.1864","v":0},{"$f":"ROUND((F37/35)*(VLOOKUP(F23,A78:C235,2,\"FALSE\")),2)","v":{"$error":"#VALUE!"}},{"$f":"(DAY(EOMONTH(A37,0))-DAY(A37)+1)/DAY(EOMONTH(A37,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(YEAR(A37)=YEAR(B37),MONTH(B37)-MONTH(A37)-1,MONTH(B37)+12-MONTH(A37)-1)","v":{"$error":"#VALUE!"}},{"$f":"DAY(B37)/DAY(EOMONTH(B37,0))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total hours (incl. holiday)",{"$f":"SUM(O36:O37)","v":0},null,{"$f":"IF(A38=\"\",\"\",(DAY(EOMONTH(A38,0))-DAY(A38)+1)/DAY(EOMONTH(A38,0)))","v":""},{"$f":"IF(A38=\"\",\"\",IF(YEAR(A38)=YEAR(B38),MONTH(B38)-MONTH(A38)-1,MONTH(B38)+12-MONTH(A38)-1))","v":""},{"$f":"IF(A38=\"\",\"\",DAY(B38)/DAY(EOMONTH(B38,0)))","v":""}]
[]
[{"$f":"IF(F15=\"Graduate Teaching Assistant\",N40,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"This post is offered on a fixed-term basis as it is a career development post.  The purpose of such posts is to enable post holders to gain the experience necessary to move on to other positions. The post has a fixed term to allow it to become vacant for others to also gain such experience in the future."]
["Your place of work will be the Houghton Street site.  Your continuous service with the School began on [Human Resources to complete]. The other terms and conditions relating to this appointment are set out in the document enclosed."]
["Please note that the salary quoted on this contract reflects the 1 August 2023 payscales."]
[]
[]
[]
["This appointment is subject to the course and/or classes running as set out above. Should the course and/or classes be cancelled or varied, the School reserves the right to withdraw or amend the contract without a notice payment being made."]
["Dependant on meeting statutory criteria, you may be automatically enrolled into one of the School's pensions schemes (SAUL for band 5 staff; USS for band 6 and above), please contact the Pensions Manager on x7093 if you have any pension queries. You are advised to read your Terms and Conditions carefully when considering your options. "]
["IMPORTANT: Tier 4 students can only work maximum of 20 hours per week during term time. This includes paid and unpaid work. If you are a Tier 4 student and you sign this contract you are also declaring that you will not work more than the restricted hours."]
["I confirm that I have permission from my research supervisor to undertake the teaching duties set out in this contract."]
["Yours sincerely,"]
[]
[]
[]
["Human Resources Division"]
[]
[{"$f":"IF(F15=\"Graduate Teaching Assistant\",A49,\"\")","v":""}]
["I accept the above offer of appointment on the terms set out."]
[]
[]
["Appointee's Signature …………………………………………………………………………",null,null,null,null,null,null,null,null,null,"Date ………………………………"]
[]
["FUNDING DETAILS"]
["(Tick one)"]
[]
[null,"Teaching Start","Teaching End","Contract End","Hours End 1",null,null,"AT"]
["Autumn Term 2023","2023-09-25","2023-12-08","2023-12-08","2023-12-08",null,null,"WT"]
["Winter Term 2024","2024-01-15","2024-03-28","2024-03-28","2024-03-28",null,null,"ST"]
["Summer Term 2024","2024-04-29","2024-06-14","2024-06-14","2024-06-14",null,null,"AT&WT"]
["Autumn and Winter Terms 2023/24","2023-09-25","2024-03-28","2024-03-28","2024-03-28",null,null,"WT&ST"]
["Winter and Summer Terms 2024","2024-01-15","2024-06-14","2024-06-14","2024-06-14",null,null,"AT&WT&ST"]
["Academic Year 2023/24","2023-09-25","2024-06-14","2024-09-29","2024-06-14",null,null,"Vacation"]
["Summer Vacation 2024","2024-06-15","2024-09-29","2024-09-29","2024-09-29"]
["Specified Dates - see below","!!! ENTER DATE HERE !!!","!!! ENTER DATE HERE !!!","!!! ENTER DATE HERE !!!"]
["Graduate Teaching Assistant","Covering staff absence"]
["Guest Teacher","Limited project where specialist expertise or skills needed"]
["Emeritus Teacher"]
["1 February 2023 scale","Annual salary"]
["Salary Band 5 Step 18.0",33558]
["Salary Band 5 Step 18.5",34018]
["Salary Band 5 Step 19.0",34486]
["Salary Band 5 Step 19.5",34959]
["Salary Band 5 Step 20.0",35441]
["Salary Band 5 Step 20.5",35927]
["Salary Band 5 Step 21.0",36421]
["Salary Band 5 Step 21.5",36939]
["Salary Band 5 Step 22.0",37464]
["Salary Band 5 Step 22.5",37999]
["Salary Band 5 Step 23.0",38541]
["Salary Band 5 Step 23.5*",39094]
["Salary Band 5 Step 24.0*",39653]
["Salary Band 5 Step 24.5*",40229]
["Salary Band 5 Step 25.0*",40802]
["Salary Band 5 Step 25.5*",41404]
["Salary Band 6 Step 24.5",40229]
["Salary Band 6 Step 25.0",40802]
["Salary Band 6 Step 25.5",41404]
["Salary Band 6 Step 26.0",42015]
["Salary Band 6 Step 26.5",42614]
["Salary Band 6 Step 27.0",43220]
["Salary Band 6 Step 27.5",43835]
["Salary Band 6 Step 28.0",44461]
["Salary Band 6 Step 28.5",45094]
["Salary Band 6 Step 29.0",45736]
["Salary Band 6 Step 29.5",46395]
["Salary Band 6 Step 30.0",47073]
["Salary Band 6 Step 30.5",47759]
["Salary Band 6 Step 31.0",48456]
["Salary Band 6 Step 31.5*",49161]
["Salary Band 6 Step 32.0*",49879]
["Salary Band 6 Step 32.5*",50606]
["Salary Band 6 Step 33.0*",51345]
["Salary Band 6 Step 33.5*",52095]
["Salary Band 7 Step 32.5",50606]
["Salary Band 7 Step 33.0",51345]
["Salary Band 7 Step 33.5",52095]
["Salary Band 7 Step 34.0",52856]
["Salary Band 7 Step 34.5",53628]
["Salary Band 7 Step 35.0",54411]
["Salary Band 7 Step 35.5",55206]
["Salary Band 7 Step 36.0",56012]
["Salary Band 7 Step 36.5",56831]
["Salary Band 7 Step 37.0",57662]
["Salary Band 7 Step 37.5",58505]
["Salary Band 7 Step 38.0*",58802]
["Salary Band 7 Step 38.5*",59670]
["Salary Band 7 Step 39.0*",60551]
["Salary Band 7 Step 39.5*",61446]
["Salary Band 7 Step 40.0*",62352]
["Salary Band 7 Step 40.5*",63274]
["Salary Band 7 Step 41.0*",64208]
["Salary Band 7 Step 41.5*",65157]
["Salary Band 8 Step 38.5",59670]
["Salary Band 8 Step 39.0",60551]
["Salary Band 8 Step 39.5",61446]
["Salary Band 8 Step 40.0",62352]
["Salary Band 8 Step 40.5",63274]
["Salary Band 8 Step 41.0",64208]
["Salary Band 8 Step 41.5",65157]
["Salary Band 8 Step 42.0",66120]
["Salary Band 8 Step 42.5",67095]
["Salary Band 8 Step 43.0",68086]
["Salary Band 8 Step 43.5",69092]
["Salary Band 8 Step 44.0*",70113]
["Salary Band 8 Step 44.5*",71149]
["Salary Band 8 Step 45.0*",72199]
["Salary Band 8 Step 45.5*",73267]
["Salary Band 8 Step 46.0*",74349]
["Salary Band 8 Step 46.5*",75446]
["Salary Band 8 Step 47.0*",76562]
["Salary Band 9 Step 44.0*",70113]
["Salary Band 9 Step 44.5*",71149]
["Salary Band 9 Step 45.0*",72199]
["Salary Band 9 Step 45.5*",73267]
["Salary Band 9 Step 46.0*",74349]
["Salary Band 9 Step 46.5*",75446]
["Salary Band 9 Step 47.0*",76562]
["Salary Band 9 Step 47.5*",77692]
["Salary Band 9 Step 48.0*",78841]
["Salary Band 9 Step 48.5*",80006]
["Salary Band 9 Step 49.0*",81189]
["Salary Band 9 Step 49.5*",82388]
["Salary Band 9 Step 50.0*",83606]
["Salary Band 9 Step 50.5*",84842]
["Salary Band 9 Step 51.0*",86095]
["Salary Band 9 Step 51.5*",87368]
["Salary Band 9 Step 52.0*",88658]
["Salary Band 9 Step 52.5*",89969]
["Salary Band 10 Step 48.5*",80006]
["Salary Band 10 Step 49.0*",81189]
["Salary Band 10 Step 49.5*",82388]
["Salary Band 10 Step 50.0*",83606]
["Salary Band 10 Step 50.5*",84842]
["Salary Band 10 Step 51.0*",86095]
["Salary Band 10 Step 51.5*",87368]
["Salary Band 10 Step 52.0*",88658]
["Salary Band 10 Step 52.5*",89969]
["Salary Band 10 Step 53.0*",91300]
["Salary Band 10 Step 53.5*",92647]
["Salary Band 10 Step 54.0*",94017]
["Salary Band 10 Step 54.5*",95408]
["Salary Band 10 Step 55.0*",96818]
["Salary Band 10 Step 55.5*",98250]
["Salary Band 10 Step 56.0*",99702]
["Salary Band 10 Step 56.5*",101151]
["Salary Band 10 Step 57.0*",102604]
["Salary Band 10 Step 57.5*",104053]
["Salary Band 10 Step 58.0*",105504]
["Salary Band 10 Step 58.5*",106955]
["Salary Band 10 Step 59.0*",108407]
["Salary Band 10 Step 59.5*",109858]
["Salary Band 10 Step 60.0*",111309]
["Salary Band 10 Step 60.5*",112758]
["Salary Band 10 Step 61.0*",114210]
["Salary Band 10 Step 61.5*",115662]
["Salary Band 10 Step 62.0*",117111]
["Salary Band 10 Step 62.5*",118564]
["Salary Band 10 Step 63.0*",120013]
["Salary Band 10 Step 63.5*",121464]
["Salary Band 10 Step 64.0*",122916]
["Salary Band 10 Step 64.5*",124366]
["Salary Band 10 Step 65.0*",125818]
["Salary Band 10 Step 65.5*",127270]
["Salary Band 10 Step 66.0*",128718]
["Salary Band 10 Step 66.5*",130170]
["Salary Band 10 Step 67.0*",131622]
["Salary Band 10 Step 67.5*",133071]
["Salary Band 10 Step 68.0*",134524]
["Salary Band 10 Step 68.5*",135973]
["Salary Band 10 Step 69.0*",137426]
["Salary Band 10 Step 69.5*",138876]
["Salary Band 10 Step 70.0*",140326]
["Salary Band 10 Step 70.5*",141778]
["Salary Band 10 Step 71.0*",143230]
["Salary Band 10 Step 71.5*",144677]
["Salary Band 10 Step 72.0*",146126,null,null,null,null,"Yes","UK/Irish National",null,"Undergraduate",null,null,"Academic and Professional Development"]
["Salary Band 10 Step 72.5*",147575,null,null,null,null,"No","EEA National (pre-settled/settled status in UK)",null,"1 Year Masters Student",null,null,"Academic Partnerships Office"]
["Salary Band 10 Step 73.0*",149024,null,null,null,null,null,"Tier 1/Global Talent",null,"2 Year Masters Student",null,null,"Academic Registrar's Division"]
["Salary Band 10 Step 73.5*",150473,null,null,null,null,null,"Tier 2/Skilled Worker Visa",null,"1st Year PhD Student ",null,null,"Accounting"]
["Salary Band 10 Step 74.0*",151922,null,null,null,null,null,"Tier 4/Student",null,"2nd Year PhD Student ",null,null,"Anthropology"]
["Salary Band 10 Step 74.5*",153371,null,null,null,null,null,"Tier 4 (Doctoral Extension Scheme)",null,"3rd Year PhD Student ",null,null,"Centre for Analysis of Time Series"]
["Salary Band 10 Step 75.0*",154820,null,null,null,null,null,"Tier 5",null,"4th Year PhD Student (Final year fulltime)",null,null,"Data Science Institute"]
["Salary Band 10 Step 75.5*",156269,null,null,null,null,null,"UK Ancestry",null,"5th Year PhD Student ",null,null,"Data Technology Services"]
["Salary Band 10 Step 76.0*",157718,null,null,null,null,null,"Indefinite Leave to Remain",null,"6th Year PhD Student (Final year part-time)",null,null,"Economic History"]
["Salary Band 10 Step 76.5*",159167,null,null,null,null,null,"Dependant",null,"7th Year PhD Student (Final year part-time)",null,null,"Economics"]
["Salary Band 10 Step 77.0*",160616,null,null,null,null,null,"Leave to Remain",null,"PhD completed",null,null,"European Institute"]
["Salary Band 10 Step 77.5*",162065,null,null,null,null,null,"PVN",null,"Not Applicable",null,null,"Finance"]
["Salary Band 10 Step 78.0*",163514,null,null,null,null,null,"Graduate Visa",null,null,null,null,"Gender Studies"]
["Salary Band 10 Step 78.5*",164963,null,null,null,null,null,"High Potential Individual",null,null,null,null,"Geography & Environment"]
["Salary Band 10 Step 79.0*",166412,null,null,null,null,null,null,null,null,null,null,"Government"]
["Salary Band 10 Step 79.5*",167862,null,null,null,null,null,null,null,null,null,null,"Health Policy"]
["Salary Band 10 Step 80.0*",169310,null,null,null,null,null,null,null,null,null,null,"International Development"]
["Salary Band 10 Step 80.5*",170760,null,null,null,null,null,null,null,null,null,null,"International History"]
["Salary Band 10 Step 21.0*",172209,null,null,null,null,null,null,null,null,null,null,"International Relations"]
["Salary Band 10 Step 81.5*",173657,null,null,null,null,null,null,null,null,null,null,"Language Centre"]
["Salary Band 10 Step 82.0*",175107,null,null,null,null,null,null,null,null,null,null,"Law School"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LSE Careers"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LSE Cities"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LSE Communications"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LSE IDEAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Marshall Ins for Philanthropy & Soc Entr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mathematics"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Media and Communications"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Methodology"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Philosophy, Logic & Scientific Method"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Psychological and Behavioural Science"]
[null,null,null,null,null,null,null,null,null,null,null,null,"School of Public Policy"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Social Policy"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sociology"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Statistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summer School, Exec. & Intl Programmes"]

{"sheet":"4 Confirmation of Funding","index":3,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[49,0,49,1],[38,0,38,1]]}
["TEACHER APPOINTMENT"]
["CONFIRMATION OF FUNDING"]
["NB You DO NOT need to complete this form if the appointment is funded from CSB."]
[]
["Contract Details:"]
["Name of Appointee:",{"$f":"IF('3 Contract Details'!B3=\"\",\"\",'3 Contract Details'!B3&\" \"&'3 Contract Details'!D3&\" \"&'3 Contract Details'!F3)","v":""}]
["Name of Department / Institute / Research Centre:",{"$f":"IF('3 Contract Details'!F14<>\"\",'3 Contract Details'!F14,\"\")","v":""}]
["Job Title:",{"$f":"IF('3 Contract Details'!F15<>\"\",'3 Contract Details'!F15,\"\")","v":""}]
["Teaching Start Date:",{"$f":"IF('3 Contract Details'!F21<>\"\",'3 Contract Details'!F21,\"\")","v":""}]
["Teaching End Date:",{"$f":"IF('3 Contract Details'!F22<>\"\",'3 Contract Details'!F22,\"\")","v":""}]
["Salary Band and Step:",{"$f":"IF('3 Contract Details'!F23<>\"\",'3 Contract Details'!F23,\"\")","v":""}]
["Total Payment for this Work:",{"$f":"IF('3 Contract Details'!K37<>\"\",SUM('3 Contract Details'!K37:M37),0)","v":0}]
["NB Employers' National Insurance contributions may be payable on this contract."]
["Estimated cost of Employers NI:",{"$f":"IF(B12=\"\",\"\",B12*0.143)","v":0}]
[null,{"$f":"LEFT(B11,14)","v":""}]
[{"$f":"IF(B15=\"Salary Band 5 \",\"Employers Pension contributions at 21%\", \"Employers Pension contributions at 14.5%\")","v":"Employers Pension contributions at 14.5%"},{"$f":"IF(B15=\"Salary Band 5 \",B12*0.21, B12*0.145)","v":0}]
["Estimated total cost of Appointment",{"$f":"B12+B14+B16","v":0}]
["Funding details:"]
["Name of Budget/Grant 1:"]
["OneFinance Code for General Ledger:"]
["Percentage:"]
[]
["Name of Budget/Grant 2:"]
["OneFinance Code for General Ledger:"]
["Percentage:"]
[]
["Name of Budget/Grant 1:"]
["OneFinance Code for Project Ledger:"]
["Percentage:"]
[]
["Name of Budget/Grant 2:"]
["OneFinance Code for Project Ledger:"]
["Percentage:"]
[]
[]
["Name","…………………………………………"]
[]
["Date","…………………………………………"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'3 Contract Details'!#REF!","v":{"$error":"#REF!"}}]
["New appointment"]
["Extension of appointment"]