{"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":2,"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":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[12,0,12,1],[5,0,5,1],[8,0,8,1],[7,0,7,1],[3,0,3,1],[4,0,4,1],[10,0,10,1],[11,0,11,1],[9,0,9,1],[6,0,6,1]]}
[]
["Human Resources Division                                                                   \nGTA and Guest/Emeritus Teacher Contract                                             Session 2018-19 (version 1.0)"]
[]
["This Excel workbook should be used to create new and additional contracts for new Graduate Teaching Assistants and Guest/Emeritus Teachers, using the 2018/19 payment system."]
["What you need to do:\n\nYou will need to create the contract details using the tabs at the bottom of the screen. To do this, you should select worksheet 3 'Contract Details'. You should then complete all the input boxes on the worksheet, always using [TAB] to move between them. Follow the instructions which appear in message boxes as you [TAB] through. Once you have entered all the required information, the appropriate salary details will be calculated automatically."]
["Right to Work:\n\nWhen requesting a teaching 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 start/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 start and expiry date of their visa is and fill out the relevant fields.  The contract will be issued for no further than this date and they will not be able to have an extension unless they have renewed their visa.  If the individual’s visa has no expiry date, please use 31/12/2099 as the date.\n"]
["Funding:\n\nIf the appointment is funded using Minimum Staffing Levels (MSLs), no confirmation of funds form is required. If the appointment is funded from any other source, select worksheet 3 'Confirmation of Funds'. The contract details will be copied automatically into this form. Now [TAB] through to the fill in the funding details - up to two budget codes can be input to allow for split-funded posts.\n\nIf the total cost is over £10000.00, please make sure funding is confirmed by the Finanace Division before sending the template through to HR."]
["Saving and sending your document:\n\nOnce everything is complete, save the template in the following format: \nDDCI, Surname, Contract Type, Date \n\nYou can then email your document to hr.pay.hourly@lse.ac.uk.  \n\n(NB signed hard copies are no longer required.)"]
["HR will send an email to the GTA/teacher telling them there is a contract awaiting collection. If a fund check is required, please copy the relevant fund checker into your email. "]
["Error messages: \nA common problem is that some calculation fields show error messages, typically #NAME?. This is usually because a required function is not available in your version of Excel. To correct this, from the menu select TOOLS >> ADD-INS - tick the top box (Analysis ToolPak) and click OK. The error messages should disappear and be replaced by the correct calculated fields. However you may need to save the document, exit and re-open Excel for the changes to take effect."]
["If problems persist, please contact the HR Operations Team in the first instance - although we may need to refer you to your IT Support team. NB Any incomplete boxes missing mandatory information or error messages will be shaded orange until information is complete. Please do not send HR contracts with error messages/orange boxes - they cannot be processed and will be returned for correction."]
["If you have any problems with or questions about this template or contractual queries, please email hr.pay.hourly@lse.ac.uk."]
["Version History:\n1.0 Academic Session, 2018-19"]

{"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.   \n\nThe School must enrol staff that earn over £833 per month (2018/2019), 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"]
["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":233,"n_cols":20,"rows_kept":233,"cut":false,"hidden":false,"merged":[[45,0,45,12],[59,1,60,6],[37,13,37,25],[21,5,21,12],[22,5,22,12],[42,0,42,12],[41,0,41,12],[53,0,53,12],[39,0,39,12],[33,1,33,2],[44,0,44,11],[43,0,43,11],[34,1,34,2],[35,1,35,2],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[38,0,38,12],[40,0,40,12],[28,5,28,7],[37,0,37,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],[18,5,18,12],[19,5,19,12],[20,5,20,12],[13,5,13,12],[14,5,14,12],[15,5,15,12],[16,5,16,12],[17,5,17,12]]}
[null,null,null,"(Teacher contract 18/19 1.0)"]
[]
["To:",null,null,null,null,"Address:"]
[]
[]
["Date of birth:",null,null,null,null,"Email:"]
[]
["Dear Colleague,",null,null,null,null,{"$f":"IF(OR(ISERROR(F19),ISERROR(F20),ISERROR(F22),B3=\"\",G6=\"\",F14=\"\",F15=\"\",F17=\"\",F18=\"\",F19=\"\",F20=\"\",F21=\"\",F22=\"\", F23=\"\",F25=\"\",A31=\"\",B31=\"\",C31=\"\",D31=\"\"),\"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"]
["LSE course on which the student is registered (if applicable):"]
["Terms:"]
["Teaching Start Date:",null,null,null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F$18,Terms_Table,2,FALSE))","v":""}]
["Teaching End Date:",null,null,null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F$18,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$20","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\",F21=\"Not applicable\"),\"Not applicable\",\"\")))","v":""}]
[]
["Does the appointee have the right to work in the UK?"]
[{"$f":"IF($F$25=\"Yes\",\"What is their current immigration status?\",\"\")","v":""}]
[{"$f":"IF($F$25=\"Yes\",\"What is the start date of their visa?\",\"\")","v":""}]
[{"$f":"IF($F$25=\"Yes\",\"What is the expiry date of their visa?\",\"\")","v":""}]
[{"$f":"IF(F26=\"Tier 4 (Student)\", \"What kind of student is the employee?\", \"\")","v":""}]
["Course Number & Title","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":"C31*D31","v":0},{"$f":"C31*2","v":0},{"$f":"C31","v":0},{"$f":"ROUNDUP(D31/3,0)*C31","v":0},{"$f":"D31*15*4","v":0},3,{"$f":"I31/J31","v":0},1,{"$f":"D31*15*0.5*L31","v":0},{"$f":"E31+F31+G31+H31+K31+M31","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(N31:N32)","v":0},"Salary","1st Month Frac","Mid-months","Last Month Frac"]
[{"$f":"IF($F$18=\"\",\"\",IF($F$18=\"Specified Dates - see below\",F19,VLOOKUP($F$18,Terms_Table,2,FALSE)))","v":""},{"$f":"IF($F$18=\"\",\"\",IF($F$18=\"Specified Dates - see below\",F20,VLOOKUP($F$18,Terms_Table,5,FALSE)))","v":""},null,{"$f":"O35","v":0},{"$f":"P36","v":0},{"$f":"IF(E35=0,\"\",ROUND(E35/(NETWORKDAYS(A35,B35)/5),2))","v":""},{"$f":"IF(E35=0,\"\",F35/35)","v":""},{"$f":"IF(E35=0,\"\",P35/12)","v":""},null,null,{"$f":"IF(E35=0,\"\",ROUND(Q35*H35,2)+ROUND(R35*H35,2)+ROUND(S35*H35,2))","v":""},null,null,"Holidays hours",{"$f":"O34*0.1864","v":0},{"$f":"ROUND((F35/35)*(VLOOKUP(F21,A76:C233,2,\"FALSE\")),2)","v":{"$error":"#VALUE!"}},{"$f":"(DAY(EOMONTH(A35,0))-DAY(A35)+1)/DAY(EOMONTH(A35,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(YEAR(A35)=YEAR(B35),MONTH(B35)-MONTH(A35)-1,MONTH(B35)+12-MONTH(A35)-1)","v":{"$error":"#VALUE!"}},{"$f":"DAY(B35)/DAY(EOMONTH(B35,0))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total hours (incl. holiday)",{"$f":"SUM(O34:O35)","v":0},null,{"$f":"IF(A36=\"\",\"\",(DAY(EOMONTH(A36,0))-DAY(A36)+1)/DAY(EOMONTH(A36,0)))","v":""},{"$f":"IF(A36=\"\",\"\",IF(YEAR(A36)=YEAR(B36),MONTH(B36)-MONTH(A36)-1,MONTH(B36)+12-MONTH(A36)-1))","v":""},{"$f":"IF(A36=\"\",\"\",DAY(B36)/DAY(EOMONTH(B36,0)))","v":""}]
[]
[{"$f":"IF(F15=\"Graduate Teaching Assistant\",N38,\"\")","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 2017 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\",A47,\"\")","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(K35<>\"\",CONCATENATE(\"MSLs: \",ROUND((K35+#REF!)*1.128/865,2)),\"\")","v":""}]
["(Tick one)"]
[]
[null,"Teaching Start","Teaching End","Contract End","Hours End 1",null,null,"MT"]
["Michaelmas Term 2018","2018-09-27","2018-12-14","2018-12-14","2018-12-14",null,null,"LT"]
["Lent Term 2019","2019-01-14","2019-03-29","2019-03-29","2019-03-29",null,null,"ST"]
["Summer Term 2019","2019-04-29","2019-06-14","2019-06-14","2019-06-14",null,null,"MT&LT"]
["Michaelmas and Lent Terms 2018/19","2018-09-27","2019-03-29","2019-03-29","2019-03-29",null,null,"LT&ST"]
["Lent and Summer Terms 2018/19","2019-01-14","2019-06-14","2019-06-14","2019-06-14",null,null,"MT&LT&ST"]
["Academic Year 2018/19","2018-09-27","2019-06-14","2018-09-29","2019-06-14",null,null,"Vacation"]
["Summer Vacation 2019","2019-06-15","2019-09-29","2019-09-29","2019-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 2017 scale","Annual salary"]
["Salary Band 5 Step 18.0",28721]
["Salary Band 5 Step 18.5",29144]
["Salary Band 5 Step 19.0",29573]
["Salary Band 5 Step 19.5",30009]
["Salary Band 5 Step 20.0",30451]
["Salary Band 5 Step 20.5",30900]
["Salary Band 5 Step 21.0",31355]
["Salary Band 5 Step 21.5",31817]
["Salary Band 5 Step 22.0",32286]
["Salary Band 5 Step 22.5",32762]
["Salary Band 5 Step 23.0",33244]
["Salary Band 5 Step 23.5*",33734]
["Salary Band 5 Step 24.0*",34232]
["Salary Band 5 Step 24.5*",34736]
["Salary Band 5 Step 25.0*",35248]
["Salary Band 5 Step 25.5*",35768]
["Salary Band 6 Step 24.5",34736]
["Salary Band 6 Step 25.0",35248]
["Salary Band 6 Step 25.5",35768]
["Salary Band 6 Step 26.0",36296]
["Salary Band 6 Step 26.5",36831]
["Salary Band 6 Step 27.0",37374]
["Salary Band 6 Step 27.5",37925]
["Salary Band 6 Step 28.0",38484]
["Salary Band 6 Step 28.5",39052]
["Salary Band 6 Step 29.0",39628]
["Salary Band 6 Step 29.5",40213]
["Salary Band 6 Step 30.0",40806]
["Salary Band 6 Step 30.5",41408]
["Salary Band 6 Step 31.0",42019]
["Salary Band 6 Step 31.5*",42639]
["Salary Band 6 Step 32.0*",43268]
["Salary Band 6 Step 32.5*",43907]
["Salary Band 6 Step 33.0*",44555]
["Salary Band 6 Step 33.5*",45212]
["Salary Band 7 Step 32.5",43907]
["Salary Band 7 Step 33.0",44555]
["Salary Band 7 Step 33.5",45212]
["Salary Band 7 Step 34.0",45879]
["Salary Band 7 Step 34.5",46557]
["Salary Band 7 Step 35.0",47244]
["Salary Band 7 Step 35.5",47941]
["Salary Band 7 Step 36.0",48649]
["Salary Band 7 Step 36.5",49367]
["Salary Band 7 Step 37.0",50096]
["Salary Band 7 Step 37.5",50835]
["Salary Band 7 Step 38.0*",51586]
["Salary Band 7 Step 38.5*",52348]
["Salary Band 7 Step 39.0*",53121]
["Salary Band 7 Step 39.5*",53905]
["Salary Band 7 Step 40.0*",54701]
["Salary Band 7 Step 40.5*",55509]
["Salary Band 7 Step 41.0*",56329]
["Salary Band 7 Step 41.5*",57161]
["Salary Band 8 Step 38.5",52348]
["Salary Band 8 Step 39.0",53121]
["Salary Band 8 Step 39.5",53905]
["Salary Band 8 Step 40.0",54701]
["Salary Band 8 Step 40.5",55509]
["Salary Band 8 Step 41.0",56329]
["Salary Band 8 Step 41.5",57161]
["Salary Band 8 Step 42.0",58005]
["Salary Band 8 Step 42.5",58862]
["Salary Band 8 Step 43.0",59731]
["Salary Band 8 Step 43.5",60614]
["Salary Band 8 Step 44.0*",61509]
["Salary Band 8 Step 44.5*",62418]
["Salary Band 8 Step 45.0*",63340]
["Salary Band 8 Step 45.5*",64276]
["Salary Band 8 Step 46.0*",65225]
["Salary Band 8 Step 46.5*",66189]
["Salary Band 8 Step 47.0*",67167]
["Salary Band 9 Step 44.0*",61509]
["Salary Band 9 Step 44.5*",62418]
["Salary Band 9 Step 45.0*",63340]
["Salary Band 9 Step 45.5*",64276]
["Salary Band 9 Step 46.0*",65225]
["Salary Band 9 Step 46.5*",66189]
["Salary Band 9 Step 47.0*",67167]
["Salary Band 9 Step 47.5*",68160]
["Salary Band 9 Step 48.0*",69167]
["Salary Band 9 Step 48.5*",70189]
["Salary Band 9 Step 49.0*",71226]
["Salary Band 9 Step 49.5*",72279]
["Salary Band 9 Step 50.0*",73347]
["Salary Band 9 Step 50.5*",74431]
["Salary Band 9 Step 51.0*",75531]
["Salary Band 9 Step 51.5*",76647]
["Salary Band 9 Step 52.0*",77780]
["Salary Band 9 Step 52.5*",78930]
["Salary Band 10 Step 48.5*",70189]
["Salary Band 10 Step 49.0*",71226]
["Salary Band 10 Step 49.5*",72279]
["Salary Band 10 Step 50.0*",73347]
["Salary Band 10 Step 50.5*",74431]
["Salary Band 10 Step 51.0*",75531]
["Salary Band 10 Step 51.5*",76647]
["Salary Band 10 Step 52.0*",77780]
["Salary Band 10 Step 52.5*",78930]
["Salary Band 10 Step 53.0*",80097]
["Salary Band 10 Step 53.5*",81281]
["Salary Band 10 Step 54.0*",82482]
["Salary Band 10 Step 54.5*",83702]
["Salary Band 10 Step 55.0*",84939]
["Salary Band 10 Step 55.5*",86195]
["Salary Band 10 Step 56.0*",87468]
["Salary Band 10 Step 56.5*",88741]
["Salary Band 10 Step 57.0*",90014]
["Salary Band 10 Step 57.5*",91286]
["Salary Band 10 Step 58.0*",92559]
["Salary Band 10 Step 58.5*",93832]
["Salary Band 10 Step 59.0*",95105]
["Salary Band 10 Step 59.5*",96378]
["Salary Band 10 Step 60.0*",97651]
["Salary Band 10 Step 60.5*",98924]
["Salary Band 10 Step 61.0*",100197]
["Salary Band 10 Step 61.5*",101470]
["Salary Band 10 Step 62.0*",102743]
["Salary Band 10 Step 62.5*",104016]
["Salary Band 10 Step 63.0*",105289]
["Salary Band 10 Step 63.5*",106562]
["Salary Band 10 Step 64.0*",107835]
["Salary Band 10 Step 64.5*",109107]
["Salary Band 10 Step 65.0*",110380]
["Salary Band 10 Step 65.5*",111653]
["Salary Band 10 Step 66.0*",112926]
["Salary Band 10 Step 66.5*",114199]
["Salary Band 10 Step 67.0*",115472]
["Salary Band 10 Step 67.5*",116745]
["Salary Band 10 Step 68.0*",118018]
["Salary Band 10 Step 68.5*",119291]
["Salary Band 10 Step 69.0*",120564]
["Salary Band 10 Step 69.5*",121837]
["Salary Band 10 Step 70.0*",123110]
["Salary Band 10 Step 70.5*",124383]
["Salary Band 10 Step 71.0*",125656]
["Salary Band 10 Step 71.5*",126927]
["Salary Band 10 Step 72.0*",128198,null,null,null,null,"Yes","UK/EEA National",null,"Undergraduate"]
["Salary Band 10 Step 72.5*",129469,null,null,null,null,"No","Tier 1",null,"1 Year Masters Student"]
["Salary Band 10 Step 73.0*",130740,null,null,null,null,null,"Tier 2",null,"2 Year Masters Student"]
["Salary Band 10 Step 73.5*",132012,null,null,null,null,null,"Tier 4 (Student)",null,"PhD Student"]
["Salary Band 10 Step 74.0*",133283,null,null,null,null,null,"Tier 4 (Doctoral Exchange Scheme)"]
["Salary Band 10 Step 74.5*",134554,null,null,null,null,null,"Tier 5"]
["Salary Band 10 Step 75.0*",135825,null,null,null,null,null,"UK Ancestry"]
["Salary Band 10 Step 75.5*",137097,null,null,null,null,null,"EEA Residence Permit"]
["Salary Band 10 Step 76.0*",138368,null,null,null,null,null,"Indefinite Leave to Remain"]
["Salary Band 10 Step 76.5*",139639,null,null,null,null,null,"Spouse/Dependent"]
["Salary Band 10 Step 77.0*",140910]
["Salary Band 10 Step 77.5*",142182]
["Salary Band 10 Step 78.0*",143453]
["Salary Band 10 Step 78.5*",144724]
["Salary Band 10 Step 79.0*",145995]
["Salary Band 10 Step 79.5*",147267]
["Salary Band 10 Step 80.0*",148538]
["Salary Band 10 Step 80.5*",149809]
["Salary Band 10 Step 21.0*",151080]
["Salary Band 10 Step 81.5*",152352]
["Salary Band 10 Step 82.0*",153623]

{"sheet":"4 Confirmation of Funding","index":3,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[43,0,43,1],[32,0,32,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)'!F19<>\"\",'3 Contract Details (new system)'!F19,\"\")","v":""}]
["Teaching End Date:",{"$f":"IF('3 Contract Details (new system)'!F20<>\"\",'3 Contract Details (new system)'!F20,\"\")","v":""}]
["Salary Band and Step:",{"$f":"IF('3 Contract Details (new system)'!F21<>\"\",'3 Contract Details (new system)'!F21,\"\")","v":""}]
["Total Payment for this Work:",{"$f":"IF('3 Contract Details (new system)'!K35<>\"\",SUM('3 Contract Details (new system)'!K35:M35),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 18%\")","v":"Employers Pension contributions at 18%"},{"$f":"IF(B15=\"Salary Band 5 \",B12*0.16, B12*0.18)","v":0}]
["Estimated total cost of Appointment",{"$f":"B12+B14+B16","v":0}]
["Funding details:"]
["Name of Budget/Grant 1:"]
["APTOS Code:"]
["Percentage:"]
[]
["Name of Budget/Grant 2:"]
["APTOS Code:"]
["Percentage:"]
[]
[]
[]
[]
["Name","…………………………………………"]
[]
["Date","…………………………………………"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'3 Contract Details (new system)'!#REF!","v":{"$error":"#REF!"}}]
["New appointment"]
["Extension of appointment"]