{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1","2 Letter Front","3 Contract Details (new system)","4 Confirmation of Funding"],"not_rendered":{"charts":0,"images":1,"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":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,0,8,1],[9,0,9,1],[7,0,7,1],[4,0,4,1],[10,0,10,1],[3,0,3,1],[6,0,6,1],[5,0,5,1],[1,0,1,1],[2,0,2,1]]}
[null,"Human Resources Division                                                                                           Graduate Teaching Assistants and Guest Contract                                                                                        (1 August 2019 - 31 July 2020)"]
["This Excel workbook should be used to create new and additional contracts for new Graduate Teaching Assistants and Guest Teachers, using the 2019/20 payment system."]
["Creating the Contract Details:\nSelect tab 3, 'Contract Template'. \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 and EEA nationals 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.\n"]
["Now select worksheet 3 '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 Sheets 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 immediately.\n\n(NB signed hard copies are no longer required.)"]
["Before completing Sheets 2 and 3, you may wish to use Sheet 4 'Hours calculator' to work out the average hours a week for a contract if you have a defined budget or a defined number of hours for a contract. You do not have to do this - and Human Resources do not need a print-out of this sheet."]
["Once you have finished, you can save the contract with any file name in any location.  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 and confirmation of funding form 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, 2019-20"]
[1.01,"Updated Macros for insert line to work correctly; added PhD completed in Type of student field menu"]
[1.2,"Update for August 2019 (Pay Award), updated new format for OneFinance budget code"]

{"sheet":"2 Letter Front","index":1,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,0,7,6],[10,0,10,6],[13,0,13,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],[11,0,11,16383],[8,0,8,6]]}
[]
[{"$f":"IF(ISBLANK('3 Contract Details (new system)'!B3),\"\",\"Dear \"&'3 Contract Details (new system)'!B3)","v":""}]
[{"$f":"IF(OR(ISBLANK('3 Contract Details (new system)'!B3),ISBLANK('3 Contract Details (new system)'!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 (new system)'!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 on the understanding that you have the right to work in the UK and your start date is subject to you being able to demonstrate proof of your right to work before you start work.\n\nYou are required to come to the HR Division in person and present original documentation confirming your right to work, 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\nPlease come to the HR Division with your original documents as soon as possible after receiving this letter and no later than 9:30am on your start date.  No work of any kind should be undertaken prior to the completion of an approved Right to Work check, verified by the Human Resources Division. \n\nIf you have an application in progress with the Home Office, LSE is required to conduct further checks.  Please contact the HR Division immediately to discuss your situation so that appropriate checks can be made before you start work.  Please note that you will not be allowed to start work until these checks have been made and if necessary, your start date will be postponed until the checks are completed.  You are required to keep the HR Division informed of the progress of your application, and you are required to bring evidence of your new visa when you receive it.\n\nIn the event that you are unable to provide evidence of your right to work by 9:30am on your start date, or the documents that you have presented do not meet the current Home Office guidelines (see Annex B in this letter) you will not be allowed to start work.  Your start date will then be deferred until your right to work status is formally confirmed by the HR Division.  Your salary, continuous service and other such related benefits will start from your new start date.  Salary cannot be backdated.\n\nThe School reserves the right not to pay an individual for any work undertaken before a satisfactory right to work check is completed or in cases where the documents presented do not meet with current Home Office guidelines.\n"]
["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 (2019/2020), 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 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"]
["If you wish to accept this contract. Please indicate so by signing at the bottom of either page of your contract and returning it digitally to your contact in Human Resources."]
["Yours sincerely,"]
[]
["Human Resources"]

{"sheet":"3 Contract Details (new system)","index":2,"n_rows":234,"n_cols":20,"rows_kept":234,"cut":false,"hidden":false,"merged":[[46,0,46,12],[60,1,61,6],[38,13,38,25],[22,5,22,12],[23,5,23,12],[43,0,43,12],[42,0,42,12],[54,0,54,12],[40,0,40,12],[34,1,34,2],[45,0,45,11],[44,0,44,11],[35,1,35,2],[36,1,36,2],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[39,0,39,12],[41,0,41,12],[29,5,29,7],[38,0,38,12],[7,5,10,12],[2,1,2,4],[2,6,2,12],[3,6,3,12],[4,6,4,12],[5,6,5,12],[5,1,5,4],[19,5,19,12],[20,5,20,12],[21,5,21,12],[13,5,13,12],[14,5,14,12],[15,5,15,12],[16,5,16,12],[18,5,18,12],[17,5,17,12]]}
[null,null,null,"(Teacher contract 19/20 v1.20 - Aug 2019 Pay ward)"]
[]
["To:",null,null,null,null,"Address:"]
[]
[]
["Date of birth:",null,null,null,null,"Email:"]
[]
["Dear Colleague,",null,null,null,null,{"$f":"IF(OR(ISERROR(F20),ISERROR(F21),ISERROR(F23),B3=\"\",G6=\"\",F14=\"\",F15=\"\",F17=\"\",F19=\"\",F20=\"\",F21=\"\",F22=\"\",F23=\"\", F24=\"\",F26=\"\",A32=\"\",B32=\"\",C32=\"\",D32=\"\"),\"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:"]
["Departmental Contact"]
["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(F19=\"\",\"\",VLOOKUP(F$19,Terms_Table,2,FALSE))","v":""}]
["Teaching End Date:",null,null,null,null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F$19,Terms_Table,3,FALSE))","v":""}]
["Salary Band and Step:"]
[{"$f":"IF(F15<>\"Emeritus Teacher\",\"Contract End Date if fixed-term appointment:\",\"End date of this post-retirement contract:\")","v":"Contract End Date if fixed-term appointment:"},null,null,null,null,{"$f":"$F$21","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\",F22=\"Not applicable\"),\"Not applicable\",\"\")))","v":""}]
[]
["Does the appointee have the right to work in the UK?"]
[{"$f":"IF($F$26=\"Yes\",\"What is their current immigration status?\",\"\")","v":""}]
[{"$f":"IF($F$26=\"Yes\",\"What is the start date of their visa?\",\"\")","v":""}]
[{"$f":"IF($F$26=\"Yes\",\"What is the expiry date of their visa?\",\"\")","v":""}]
[{"$f":"IF(F27=\"Tier 4 (Student)\", \"What kind of student is the employee?\", \"\")","v":""},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":"C32*D32","v":0},{"$f":"C32*2","v":0},{"$f":"C32","v":0},{"$f":"ROUNDUP(D32/3,0)*C32","v":0},{"$f":"D32*15*4","v":0},3,{"$f":"I32/J32","v":0},1,{"$f":"D32*15*0.5*L32","v":0},{"$f":"E32+F32+G32+H32+K32+M32","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(N32:N33)","v":0},"Salary","1st Month Frac","Mid-months","Last Month Frac"]
[{"$f":"IF($F$19=\"\",\"\",IF($F$19=\"Specified Dates - see below\",F20,VLOOKUP($F$19,Terms_Table,2,FALSE)))","v":""},{"$f":"IF($F$19=\"\",\"\",IF($F$19=\"Specified Dates - see below\",F21,VLOOKUP($F$19,Terms_Table,5,FALSE)))","v":""},null,{"$f":"O36","v":0},{"$f":"P37","v":0},{"$f":"IF(E36=0,\"\",ROUND(E36/(NETWORKDAYS(A36,B36)/5),2))","v":""},{"$f":"IF(E36=0,\"\",F36/35)","v":""},{"$f":"IF(E36=0,\"\",P36/12)","v":""},null,null,{"$f":"IF(E36=0,\"\",ROUND(Q36*H36,2)+ROUND(R36*H36,2)+ROUND(S36*H36,2))","v":""},null,null,"Holidays hours",{"$f":"O35*0.1864","v":0},{"$f":"ROUND((F36/35)*(VLOOKUP(F22,A77:C234,2,\"FALSE\")),2)","v":{"$error":"#VALUE!"}},{"$f":"(DAY(EOMONTH(A36,0))-DAY(A36)+1)/DAY(EOMONTH(A36,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(YEAR(A36)=YEAR(B36),MONTH(B36)-MONTH(A36)-1,MONTH(B36)+12-MONTH(A36)-1)","v":{"$error":"#VALUE!"}},{"$f":"DAY(B36)/DAY(EOMONTH(B36,0))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total hours (incl. holiday)",{"$f":"SUM(O35:O36)","v":0},null,{"$f":"IF(A37=\"\",\"\",(DAY(EOMONTH(A37,0))-DAY(A37)+1)/DAY(EOMONTH(A37,0)))","v":""},{"$f":"IF(A37=\"\",\"\",IF(YEAR(A37)=YEAR(B37),MONTH(B37)-MONTH(A37)-1,MONTH(B37)+12-MONTH(A37)-1))","v":""},{"$f":"IF(A37=\"\",\"\",DAY(B37)/DAY(EOMONTH(B37,0)))","v":""}]
[]
[{"$f":"IF(F15=\"Graduate Teaching Assistant\",N39,\"\")","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 2019 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\",A48,\"\")","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",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K36<>\"\",CONCATENATE(\"MSLs: \",ROUND((K36+#REF!)*1.128/865,2)),\"\")","v":""}]
["(Tick one)"]
[]
[null,"Teaching Start","Teaching End","Contract End","Hours End 1",null,null,"MT"]
["Michaelmas Term 2019","2019-09-30","2019-12-13","2019-12-13","2019-12-13",null,null,"LT"]
["Lent Term 2020","2020-01-20","2020-04-03","2020-04-03","2020-04-03",null,null,"ST"]
["Summer Term 2020","2020-05-05","2020-06-19","2020-06-19","2020-06-19",null,null,"MT&LT"]
["Michaelmas and Lent Terms 2019/20","2019-09-30","2020-04-03","2020-04-03","2020-04-03",null,null,"LT&ST"]
["Lent and Summer Terms 2019/20","2020-01-20","2020-06-19","2020-06-19","2020-06-19",null,null,"MT&LT&ST"]
["Academic Year 2019/20","2019-09-30","2020-06-19","2020-09-29","2020-06-19",null,null,"Vacation"]
["Summer Vacation 2020","2020-06-20","2020-09-29","2020-09-29","2020-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"]
[]
["1 August 2019 scale","Annual salary"]
["Salary Band 5 Step 18.0",30570]
["Salary Band 5 Step 18.5",30989]
["Salary Band 5 Step 19.0",31414]
["Salary Band 5 Step 19.5",31846]
["Salary Band 5 Step 20.0",32284]
["Salary Band 5 Step 20.5",32728]
["Salary Band 5 Step 21.0",33177]
["Salary Band 5 Step 21.5",33650]
["Salary Band 5 Step 22.0",34128]
["Salary Band 5 Step 22.5",34614]
["Salary Band 5 Step 23.0",35108]
["Salary Band 5 Step 23.5*",35612]
["Salary Band 5 Step 24.0*",36122]
["Salary Band 5 Step 24.5*",36647]
["Salary Band 5 Step 25.0*",37169]
["Salary Band 5 Step 25.5*",37717]
["Salary Band 6 Step 24.5",36647]
["Salary Band 6 Step 25.0",37169]
["Salary Band 6 Step 25.5",37717]
["Salary Band 6 Step 26.0",38273]
["Salary Band 6 Step 26.5",38818]
["Salary Band 6 Step 27.0",39371]
["Salary Band 6 Step 27.5",39932]
["Salary Band 6 Step 28.0",40501]
["Salary Band 6 Step 28.5",41078]
["Salary Band 6 Step 29.0",41664]
["Salary Band 6 Step 29.5",42264]
["Salary Band 6 Step 30.0",42881]
["Salary Band 6 Step 30.5",43506]
["Salary Band 6 Step 31.0",44140]
["Salary Band 6 Step 31.5*",44784]
["Salary Band 6 Step 32.0*",45437]
["Salary Band 6 Step 32.5*",46100]
["Salary Band 6 Step 33.0*",46773]
["Salary Band 6 Step 33.5*",47456]
["Salary Band 7 Step 32.5",46100]
["Salary Band 7 Step 33.0",46773]
["Salary Band 7 Step 33.5",47456]
["Salary Band 7 Step 34.0",48148]
["Salary Band 7 Step 34.5",48852]
["Salary Band 7 Step 35.0",49565]
["Salary Band 7 Step 35.5",50289]
["Salary Band 7 Step 36.0",51024]
["Salary Band 7 Step 36.5",51770]
["Salary Band 7 Step 37.0",52527]
["Salary Band 7 Step 37.5",53295]
["Salary Band 7 Step 38.0*",53565]
["Salary Band 7 Step 38.5*",54356]
["Salary Band 7 Step 39.0*",55159]
["Salary Band 7 Step 39.5*",55974]
["Salary Band 7 Step 40.0*",56800]
["Salary Band 7 Step 40.5*",57639]
["Salary Band 7 Step 41.0*",58490]
["Salary Band 7 Step 41.5*",59354]
["Salary Band 8 Step 38.5",54356]
["Salary Band 8 Step 39.0",55159]
["Salary Band 8 Step 39.5",55974]
["Salary Band 8 Step 40.0",56800]
["Salary Band 8 Step 40.5",57639]
["Salary Band 8 Step 41.0",58490]
["Salary Band 8 Step 41.5",59354]
["Salary Band 8 Step 42.0",60231]
["Salary Band 8 Step 42.5",61121]
["Salary Band 8 Step 43.0",62023]
["Salary Band 8 Step 43.5",62939]
["Salary Band 8 Step 44.0*",63869]
["Salary Band 8 Step 44.5*",64813]
["Salary Band 8 Step 45.0*",65770]
["Salary Band 8 Step 45.5*",66742]
["Salary Band 8 Step 46.0*",67728]
["Salary Band 8 Step 46.5*",68728]
["Salary Band 8 Step 47.0*",69744]
["Salary Band 9 Step 44.0*",63869]
["Salary Band 9 Step 44.5*",64813]
["Salary Band 9 Step 45.0*",65770]
["Salary Band 9 Step 45.5*",66742]
["Salary Band 9 Step 46.0*",67728]
["Salary Band 9 Step 46.5*",68728]
["Salary Band 9 Step 47.0*",69744]
["Salary Band 9 Step 47.5*",70774]
["Salary Band 9 Step 48.0*",71821]
["Salary Band 9 Step 48.5*",72882]
["Salary Band 9 Step 49.0*",73959]
["Salary Band 9 Step 49.5*",75052]
["Salary Band 9 Step 50.0*",76161]
["Salary Band 9 Step 50.5*",77287]
["Salary Band 9 Step 51.0*",78429]
["Salary Band 9 Step 51.5*",79588]
["Salary Band 9 Step 52.0*",80764]
["Salary Band 9 Step 52.5*",81958]
["Salary Band 10 Step 48.5*",72882]
["Salary Band 10 Step 49.0*",73959]
["Salary Band 10 Step 49.5*",75052]
["Salary Band 10 Step 50.0*",76161]
["Salary Band 10 Step 50.5*",77287]
["Salary Band 10 Step 51.0*",78429]
["Salary Band 10 Step 51.5*",79588]
["Salary Band 10 Step 52.0*",80764]
["Salary Band 10 Step 52.5*",81958]
["Salary Band 10 Step 53.0*",83170]
["Salary Band 10 Step 53.5*",84399]
["Salary Band 10 Step 54.0*",85646]
["Salary Band 10 Step 54.5*",86913]
["Salary Band 10 Step 55.0*",88197]
["Salary Band 10 Step 55.5*",89502]
["Salary Band 10 Step 56.0*",90824]
["Salary Band 10 Step 56.5*",92145]
["Salary Band 10 Step 57.0*",93467]
["Salary Band 10 Step 57.5*",94789]
["Salary Band 10 Step 58.0*",96110]
["Salary Band 10 Step 58.5*",97432]
["Salary Band 10 Step 59.0*",98754]
["Salary Band 10 Step 59.5*",100076]
["Salary Band 10 Step 60.0*",101398]
["Salary Band 10 Step 60.5*",102719]
["Salary Band 10 Step 61.0*",104041]
["Salary Band 10 Step 61.5*",105363]
["Salary Band 10 Step 62.0*",106684]
["Salary Band 10 Step 62.5*",108007]
["Salary Band 10 Step 63.0*",109328]
["Salary Band 10 Step 63.5*",110649]
["Salary Band 10 Step 64.0*",111972]
["Salary Band 10 Step 64.5*",113293]
["Salary Band 10 Step 65.0*",114615]
["Salary Band 10 Step 65.5*",115937]
["Salary Band 10 Step 66.0*",117258]
["Salary Band 10 Step 66.5*",118581]
["Salary Band 10 Step 67.0*",119902]
["Salary Band 10 Step 67.5*",121223]
["Salary Band 10 Step 68.0*",122546]
["Salary Band 10 Step 68.5*",123867]
["Salary Band 10 Step 69.0*",125190]
["Salary Band 10 Step 69.5*",126511]
["Salary Band 10 Step 70.0*",127832]
["Salary Band 10 Step 70.5*",129155]
["Salary Band 10 Step 71.0*",130476]
["Salary Band 10 Step 71.5*",131796]
["Salary Band 10 Step 72.0*",133116,null,null,null,null,"Yes","UK/EEA National",null,"Undergraduate"]
["Salary Band 10 Step 72.5*",134436,null,null,null,null,"No","Tier 1",null,"1 Year Masters Student"]
["Salary Band 10 Step 73.0*",135756,null,null,null,null,null,"Tier 2",null,"2 Year Masters Student"]
["Salary Band 10 Step 73.5*",137076,null,null,null,null,null,"Tier 4 (Student)",null,"1st Year PhD Student "]
["Salary Band 10 Step 74.0*",138396,null,null,null,null,null,"Tier 4 (Doctoral Exchange Scheme)",null,"2nd Year PhD Student "]
["Salary Band 10 Step 74.5*",139716,null,null,null,null,null,"Tier 5",null,"3rd Year PhD Student "]
["Salary Band 10 Step 75.0*",141036,null,null,null,null,null,"UK Ancestry",null,"4th Year PhD Student (Final year fulltime)"]
["Salary Band 10 Step 75.5*",142356,null,null,null,null,null,"EEA Residence Permit",null,"5th Year PhD Student "]
["Salary Band 10 Step 76.0*",143676,null,null,null,null,null,"Indefinite Leave to Remain",null,"6th Year PhD Student (Final year part-time)"]
["Salary Band 10 Step 76.5*",144996,null,null,null,null,null,"Spouse/Dependent",null,"7th Year PhD Student (Final year part-time)"]
["Salary Band 10 Step 77.0*",146316,null,null,null,null,null,null,null,"PhD completed"]
["Salary Band 10 Step 77.5*",147636]
["Salary Band 10 Step 78.0*",148956]
["Salary Band 10 Step 78.5*",150276]
["Salary Band 10 Step 79.0*",151596]
["Salary Band 10 Step 79.5*",152917]
["Salary Band 10 Step 80.0*",154236]
["Salary Band 10 Step 80.5*",155557]
["Salary Band 10 Step 21.0*",156877]
["Salary Band 10 Step 81.5*",158196]
["Salary Band 10 Step 82.0*",159517]

{"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 (new system)'!B3:D3=\"\",\"\",'3 Contract Details (new system)'!B3:D3)","v":""}]
["Name of Department / Institute / Research Centre:",{"$f":"IF('3 Contract Details (new system)'!F14<>\"\",'3 Contract Details (new system)'!F14,\"\")","v":""}]
["Job Title:",{"$f":"IF('3 Contract Details (new system)'!F15<>\"\",'3 Contract Details (new system)'!F15,\"\")","v":""}]
["Teaching Start Date:",{"$f":"IF('3 Contract Details (new system)'!F20<>\"\",'3 Contract Details (new system)'!F20,\"\")","v":""}]
["Teaching End Date:",{"$f":"IF('3 Contract Details (new system)'!F21<>\"\",'3 Contract Details (new system)'!F21,\"\")","v":""}]
["Salary Band and Step:",{"$f":"IF('3 Contract Details (new system)'!F22<>\"\",'3 Contract Details (new system)'!F22,\"\")","v":""}]
["Total Payment for this Work:",{"$f":"IF('3 Contract Details (new system)'!K36<>\"\",SUM('3 Contract Details (new system)'!K36:M36),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 16%\", \"Employers Pension contributions at 19.5%\")","v":"Employers Pension contributions at 19.5%"},{"$f":"IF(B15=\"Salary Band 5 \",B12*0.16, B12*0.195)","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 (new system)'!#REF!","v":{"$error":"#REF!"}}]
["New appointment"]
["Extension of appointment"]