{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Form","Sheet1","Funding Approver List","Data Validation","Pay Framework","Email list"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":"Form","index":0,"n_rows":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[[38,1,38,3],[38,5,38,6],[39,1,39,3],[39,5,39,6],[24,0,24,5],[24,6,24,7],[35,0,35,8],[36,0,36,7],[37,1,37,3],[37,5,37,6],[32,8,32,12],[36,8,36,11],[42,0,42,8],[46,0,46,8],[12,0,12,2],[50,1,50,4],[19,0,19,1],[20,0,20,2],[44,0,44,1],[44,2,44,4],[44,5,44,6],[44,7,44,8],[45,0,45,8],[19,2,19,8],[41,0,41,8],[43,0,43,8],[33,0,33,2],[33,3,33,7],[14,0,14,8],[16,0,16,1],[17,0,17,1],[17,4,17,5],[17,6,17,7],[15,3,15,6],[16,4,16,6],[17,8,17,10],[59,0,59,8],[60,0,60,8],[67,1,67,4],[18,1,18,4],[30,0,30,8],[21,0,21,8],[22,0,22,2],[22,3,22,7],[25,0,25,8],[26,0,26,8],[28,0,28,1],[28,2,28,4],[28,5,28,6],[28,7,28,8],[27,0,27,2],[29,0,29,1],[18,5,18,7],[20,4,20,8],[22,8,22,12],[31,8,31,12],[33,8,33,12],[29,2,29,4],[29,5,29,6],[29,7,29,8],[27,3,27,6],[27,7,27,8],[31,0,31,2],[31,3,31,7],[23,0,23,3],[23,4,23,7],[32,0,32,2],[32,3,32,7],[47,0,47,1],[51,0,51,8],[48,0,48,8],[49,6,49,8],[50,6,50,8],[47,8,47,9],[49,1,49,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click here for Payroll Deadlines",null,null,null,null,null,null,"Click here for HR's A to Z of useful documents"]
[]
["Employee Details (please enter the details of the employee to whom these changes apply)"]
["Title",null,"First Name",null,null,null,null,"Surname"]
["Employee ID",null,null,"Post ID",null,null,null,"Job Title"]
["Salary Band",null,null,"Step",null,null,"Job Family"]
["Area","Choose an item",null,null,null,"Employee sponsored under Tier 2/5?",null,null,"Select"]
["Forwarding address"]
["Is this employee a line manager?",null,null,"Select","not blank"]
["Reason for Leaving"]
["Reason for Leaving",null,null,"Choose an item",null,null,null,null,"not blank"]
["Is this employee an E-recruitment champion?",null,null,null,"Choose an item",null,null,null,"Select"]
["Will this employee become an Emeritus Professor upon retirement?\n(applies to full Professors only)",null,null,null,null,null,"Choose an item",null,"Select"]
["For Internal movers"]
["New Job Details"]
["Last Day at current role",null,null,null,null,null,null,"not blank"]
["New Job Title",null,null,null,null,"Start Date"]
["New Area",null,"Choose an item",null,null,"New Line Manager"]
["For External movers"]
["Last working day",null,null,null,null,null,null,null,"Select"]
["End of Contract",null,null,null,null,null,null,null,"Select"]
["Last Day of Service",null,null,null,null,null,null,null,"not blank"]
[]
["Final payments/deductions"]
["Is this a terminination where pay in Lieu of Notice (PILON) is to be processed?",null,null,null,null,null,null,null,"Choose an item"]
["Budget code",null,null,null,"%",null,null,"Amount"]
["Budget code",null,null,null,"%",null,null,"Amount"]
["Budget code",null,null,null,"%",null,null,"Amount"]
[]
["Email accounts and Security ID"]
["Employee email accounts will automatically close on the employees' last day of service unless you contact IMT to retain access.  ID cards will cease to work at 23:59 on the employees' last day of service."]
["Destination on leaving for HESA purposes, applies to ALL Staff"]
["Destination",null,null,null,null,"Location"]
["Annual leave"]
["Please ensure that all annual leave is updated on MyView"]
["Untaken annual leave",null,null,"Type",null,"Amount",null,"is not blank","Click here for MyView"]
["Line Manager Authorisation"]
["Name",null,null,null,null,"Job Title"]
["Email",null,null,null,null,"Date"]
["In completing and sending this form I confirm that I am authorised to make these changes."]
[]
[]
[]
[]
[]
[]
[]
["HR Team office use only"]
["HR checklist"]
[null,"Visa status checked"]
[null,"If Tier 2 or 5 check with Compliance team before implementing"]
[null,"Create letter"]
[null,"Resourcelink input"]
[]
["Completed by:"]
["Name",null,null,null,null,"Date"]
[]
["Payroll Team checklist"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Funding Approver List","index":2,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":true,"merged":[[2,0,3,0]]}
[]
["Funding Approvers"]
["Return to form"]
[]
["Area","Establishment","Other Posts/Alternative Contact"]
[null,"Funding Approver","Funding Approver"]
["Academic and Professional Development (APD)","Chris McDermott"]
["Academic Partnerships","Laura Gilbert"]
["Academic Registrar's Division (ARD)","Emma Herbert"]
["Accounting","Ioannis Tsolkas","Chris McDermott"]
["Anthropology","Ioannis Tsolkas","Laura Gilbert"]
["Business Improvement Unit","Emma Herbert"]
["Communications","Oliver Baden"]
["Conferences",null,"Laura Gilbert"]
["Directorate","Oliver Baden"]
["Economic History","Ioannis Tsolkas","Chris McDermott"]
["Centre for Macroeconomics ",null,"Research Division"]
["Economics","Ioannis Tsolkas","Chris McDermott"]
["EDI","Victoria Ellah"]
["Educational Strategy Unit (ESU)","Chris McDermott"]
["Estates & Security","Ellen Fraser"]
["European Institute","Ioannis Tsolkas","Chris McDermott"]
["Executive Programs",null,"Chris McDermott"]
["Finance ","Ioannis Tsolkas","Chris McDermott"]
["Finance Division","Naomi Richardson"]
["Gender Institute","Ioannis Tsolkas","Chris McDermott"]
["Geography & Environment ","Ioannis Tsolkas","Chris McDermott"]
["Government","Ioannis Tsolkas","Chris McDermott"]
["Health Policy","Ioannis Tsolkas","Chris McDermott"]
["HEFCE and other grants",null,"Ellen Fraser"]
["HEIF, IAA",null,"Research Division"]
["Human Resources","Ioannis Tsolkas"]
["IGA and Centres",null,"Chris McDermott"]
["IGC",null,"Emma Herbert"]
["Information Management Technology","Emma Herbert"]
["International Development ","Ioannis Tsolkas","Chris McDermott"]
["International History","Ioannis Tsolkas","Chris McDermott"]
["International Inequalities Institute (inc Atlantic Fellows Programme)",null,"Chris McDermott"]
["International Relations","Ioannis Tsolkas","Chris McDermott"]
["Language Centre","Chris McDermott"]
["Law","Ioannis Tsolkas","Chris McDermott"]
["Library","Emma Herbert"]
["LSE 100","Chris McDermott"]
["LSE Advancement","Chris McDermott"]
["LSE Careers ","Oliver Baden"]
["LSE Life","Chris McDermott"]
["LSEE",null,"Laura Gilbert"]
["Management","Ioannis Tsolkas","Chris McDermott"]
["Marshall Institute",null,"Chris McDermott"]
["Mathematics","Ioannis Tsolkas","Chris McDermott"]
["Media & Communications","Ioannis Tsolkas","Laura Gilbert"]
["Methodology ","Ioannis Tsolkas","Laura Gilbert"]
["Nursery","Oliver Baden"]
["PhD Academy","Chris McDermott"]
["Philosophy, Logic and Scientific Method","Ioannis Tsolkas","Laura Gilbert"]
["Planning Unit","Oliver Baden"]
["Psychological and Behavioural Science","Ioannis Tsolkas","Laura Gilbert"]
["Publications",null,"Laura Gilbert"]
["Research Centres",null,"Research Division"]
["Research Division","Emma Herbert"]
["Research Grants and Contracts",null,"Research Division"]
["Residential & Catering Services Division (RCSD)","Laura Gilbert","Sandra Daly (Analyst)"]
["Risk and Compliance Unit","Oliver Baden"]
["Scholarships",null,"Emma Herbert"]
["School of Public Policy","Ioannis Tsolkas","Chris McDermott"]
["Secretary's Division","Oliver Baden"]
["Social Policy (inc Education Research Group)","Ioannis Tsolkas","Chris McDermott"]
["Sociology ","Ioannis Tsolkas","Laura Gilbert"]
["Staff Research Accounts (AXY-B*)",null,"Ellen Fraser"]
["Statistics ","Ioannis Tsolkas","Laura Gilbert"]
["Summer School",null,"Laura Gilbert"]
["TLC Division","Chris McDermott"]
["TRIUM",null,"Laura Gilbert"]
["University of London International Programmes (ULIP)",null,"Laura Gilbert"]

{"sheet":"Data Validation","index":3,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
["Reason for Leaving","Job Family","Contract Type","Reason for Contract Extension","Contract Type 2","Area"]
["Choose an item","Choose an item","Choose an item","Choose an item","Choose an item","Choose an item"]
["Internal Mover","Academic","Fixed Term","Covering staff absence","Fixed Term","Academic and Professional Development"]
["End of Funding","Research Band 6+","Open Ended Subject to Funding","Limited project with specialist expertise","Open Ended Subject to Funding","Academic Partnerships Office"]
["End of Fixed term contract","Professional Services/Research Band 5",null,"LSE Fellow","Permanent","Academic Registrar's Division"]
["Resignation","LSE Fellow and Tutorial",null,"Other (Please specify)",null,"Accounting"]
["Retirement",null,null,null,null,"Anthropology"]
[null,"Work/Final payments",null,null,null,"Business Improvement Unit"]
[null,"Select",null,null,null,"Centre for Analysis of Risk & Regulation"]
[null,"Yes",null,null,null,"Centre for Analysis of Social Exclusion"]
[null,"No",null,null,null,"Centre for Analysis of Time Series"]
[null,null,null,null,null,"Centre for Economic Performance"]
[null,null,null,null,null,"Centre for Macroeconomics"]
[null,null,null,null,null,"CPNSS"]
[null,null,null,null,null,"Directorate and Support Team"]
[null,null,null,null,null,"Economic History"]
[null,"Annual leave",null,null,null,"Economics"]
[null,"Select",null,null,null,"Equity, Diversity and Inclusion"]
[null,"Days",null,null,null,"Estates Division"]
["Visa/E-recruitment champion","Hours",null,null,null,"Ethnography of Advice"]
["Choose an item",null,null,null,null,"European Institute"]
["Yes",null,null,null,null,"Faith Centre"]
["No",null,null,null,null,"Finance"]
[null,null,null,null,null,"Finance Division"]
[null,null,null,null,null,"Financial Markets Group"]
[null,null,null,null,null,"Gender Studies"]
[null,null,null,null,null,"Geography & Environment"]
[null,null,null,null,null,"Government"]
[null,null,null,null,null,"Grantham Research Institute"]
[null,null,null,null,null,"Health Policy"]
[null,null,null,null,null,"Hellenic Observatory"]
[null,null,null,null,null,"Human Resources"]
[null,null,null,null,null,"IGA: Centre for Women Peace and Security"]
[null,null,null,null,null,"IGA: Firoz Lalji Centre for Africa"]
[null,null,null,null,null,"IGA: Latin America and Caribbean Centre"]
[null,null,null,null,null,"IGA: LSE IDEAS"]
[null,null,null,null,null,"IGA: Saw Swee Hock Southeast Asia Centre"]
[null,null,null,null,null,"IGA: South Asia Centre"]
[null,null,null,null,null,"IGA: United States Centre"]
[null,null,null,null,null,"India Observatory"]
[null,null,null,null,null,"Information Management & Technology"]
[null,null,null,null,null,"Institute of Global Affairs"]
[null,null,null,null,null,"International Development"]
[null,null,null,null,null,"International Growth Centre"]
[null,null,null,null,null,"International History"]
[null,null,null,null,null,"International Inequalities Institute"]
[null,null,null,null,null,"International Relations"]
[null,null,null,null,null,"Law"]
[null,null,null,null,null,"Library Services"]
[null,null,null,null,null,"LSE Advancement"]
[null,null,null,null,null,"LSE Careers"]
[null,null,null,null,null,"LSE Cities"]
[null,null,null,null,null,"LSE Communications"]
[null,null,null,null,null,"LSE Health"]
[null,null,null,null,null,"LSE Housing & Communities"]
[null,null,null,null,null,"LSE Human Rights"]
[null,null,null,null,null,"LSE London"]
[null,null,null,null,null,"LSEE - Research on South Eastern Europe"]
[null,null,null,null,null,"Management"]
[null,null,null,null,null,"Marshall Ins for Philanthropy & Soc Entr"]
[null,null,null,null,null,"Mathematics"]
[null,null,null,null,null,"Media and Communications"]
[null,null,null,null,null,"Methodology"]
[null,null,null,null,null,"Middle East Centre"]
[null,null,null,null,null,"Personal Social Services Research Unit"]
[null,null,null,null,null,"PhD Academy"]
[null,null,null,null,null,"Philosophy, Logic & Scientific Method"]
[null,null,null,null,null,"Planning Unit"]
[null,null,null,null,null,"Psychological and Behavioural Science"]
[null,null,null,null,null,"Research Division"]
[null,null,null,null,null,"Residential & Catering Services Division"]
[null,null,null,null,null,"Risk and Compliance Unit"]
[null,null,null,null,null,"School of Public Policy"]
[null,null,null,null,null,"Secretary's Division"]
[null,null,null,null,null,"Social Policy"]
[null,null,null,null,null,"Sociology"]
[null,null,null,null,null,"Spatial Economics Research Centre"]
[null,null,null,null,null,"Statistics"]
[null,null,null,null,null,"STICERD"]
[null,null,null,null,null,"Summer School, Exec. & Intl Programmes"]
[null,null,null,null,null,"Systemic Risk Centre"]
[null,null,null,null,null,"TRIUM"]
[null,null,null,null,null,"What Works Centre"]

{"sheet":"Pay Framework","index":4,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":true,"merged":[[0,0,3,0]]}
["Salary Band/Spine Point Table","1","2","3","4","5","6","7","8","9","10","SBA1","SBA2","SBA3","Select",null,null,"Hourly rate"]
[null,"Select","Select","Select","Select","Select","Select","Select","Select","Select","Select","Select","Select","Select","Select"]
[null,1,4.5,8.5,13.5,18,24.5,32.5,38.5,44,48.5,39.5,45.5,55.5]
[null,1.5,5,9,14,18.5,25,33,39,44.5,49,40,46,56]
[null,2,5.5,9.5,14.5,19,25.5,33.5,39.5,45,49.5,40.5,46.5,56.5]
[null,2.5,6,10,15,19.5,26,34,40,45.5,50,41,47,57]
[null,3,6.5,10.5,15.5,20,26.5,34.5,40.5,46,50.5,41.5,47.5,57.5]
[null,3.5,7,11,16,20.5,27,35,41,46.5,51,42,48,58]
[null,4,7.5,11.5,16.5,21,27.5,35.5,41.5,47,51.5,42.5,48.5,58.5]
[null,null,8,12,17,21.5,28,36,42,47.5,52,43,49,59]
[null,null,8.5,12.5,17.5,22,28.5,36.5,42.5,48,52.5,43.5,49.5,59.5]
[null,null,9,13,18,22.5,29,37,43,48.5,53,44,50,60]
[null,null,9.5,13.5,18.5,23,29.5,37.5,43.5,49,53.5,44.5,50.5,60.5]
[null,null,null,14,19,23.5,30,38,44,49.5,54,45,51,61]
[null,null,null,14.5,19.5,24,30.5,38.5,44.5,50,54.5,45.5,51.5,61.5]
[null,null,null,15,20,24.5,31,39,45,50.5,55,46,52,62]
[null,null,null,null,null,25,31.5,39.5,45.5,51,55.5,46.5,52.5,62.5]
[null,null,null,null,null,25.5,32,40,46,51.5,56,null,53,63]
[null,null,null,null,null,null,32.5,40.5,46.5,52,56.5,null,53.5,63.5]
[null,null,null,null,null,null,33,41,47,52.5,57,null,54,64]
[null,null,null,null,null,null,33.5,41.5,null,null,57.5,null,54.5,64.5]
[null,null,null,null,null,null,null,null,null,null,58,null,55,65]
[null,null,null,null,null,null,null,null,null,null,58.5,null,55.5,65.5]
[null,null,null,null,null,null,null,null,null,null,59,null,56,66]
[null,null,null,null,null,null,null,null,null,null,59.5,null,56.5,66.5]
[null,null,null,null,null,null,null,null,null,null,60,null,57,67]
[null,null,null,null,null,null,null,null,null,null,60.5,null,57.5,67.5]
[null,null,null,null,null,null,null,null,null,null,61,null,58,68]
[null,null,null,null,null,null,null,null,null,null,61.5,null,58.5,68.5]
[null,null,null,null,null,null,null,null,null,null,62,null,null,69]
[null,null,null,null,null,null,null,null,null,null,62.5,null,null,69.5]
[null,null,null,null,null,null,null,null,null,null,63,null,null,70]
[null,null,null,null,null,null,null,null,null,null,63.5,null,null,70.5]
[null,null,null,null,null,null,null,null,null,null,64,null,null,71]
[null,null,null,null,null,null,null,null,null,null,64.5,null,null,71.5]
[null,null,null,null,null,null,null,null,null,null,65,null,null,72]
[null,null,null,null,null,null,null,null,null,null,65.5,null,null,72.5]
[null,null,null,null,null,null,null,null,null,null,66,null,null,73]
[null,null,null,null,null,null,null,null,null,null,66.5,null,null,73.5]
[null,null,null,null,null,null,null,null,null,null,67,null,null,74]
[null,null,null,null,null,null,null,null,null,null,67.5,null,null,74.5]
[null,null,null,null,null,null,null,null,null,null,68,null,null,75]
[null,null,null,null,null,null,null,null,null,null,68.5,null,null,75.5]
[null,null,null,null,null,null,null,null,null,null,69,null,null,76]
[null,null,null,null,null,null,null,null,null,null,69.5,null,null,76.5]
[null,null,null,null,null,null,null,null,null,null,70,null,null,77]
[null,null,null,null,null,null,null,null,null,null,70.5,null,null,77.5]
[null,null,null,null,null,null,null,null,null,null,71,null,null,78]
[null,null,null,null,null,null,null,null,null,null,71.5,null,null,78.5]
[null,null,null,null,null,null,null,null,null,null,72,null,null,79]
[null,null,null,null,null,null,null,null,null,null,72.5,null,null,79.5]
[null,null,null,null,null,null,null,null,null,null,73,null,null,80]
[null,null,null,null,null,null,null,null,null,null,73.5,null,null,80.5]
[null,null,null,null,null,null,null,null,null,null,74,null,null,81]
[null,null,null,null,null,null,null,null,null,null,74.5,null,null,81.5]
[null,null,null,null,null,null,null,null,null,null,75,null,null,82]
[null,null,null,null,null,null,null,null,null,null,75.5]
[null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,76.5]
[null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,77.5]
[null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,78.5]
[null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,79.5]
[null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,80.5]
[null,null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,81.5]
[null,null,null,null,null,null,null,null,null,null,82]

{"sheet":"Email list","index":5,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Funding Approver List","Email"]
["Please Select"]
["Research Division","researchdivision@lse.ac.uk"]
["Ellen Fraser","e.fraser@lse.ac.uk"]
["Emma Herbert","e.herbert@lse.ac.uk"]
["Oliver Baden","O.Baden@lse.ac.uk"]
["Ioannis Tsolkas","i.tsolkas@lse.ac.uk"]
["Laura Gilbert","l.c.gilbert@lse.ac.uk"]
[]
["Victoria Ellah","v.a.ellah@lse.ac.uk"]
["Chris McDermott","C.McDermott1@lse.ac.uk"]
["Naomi Richardson","N.Richardson@lse.ac.uk"]
[]
[]
[]
["Email 1",{"$f":"IFERROR(VLOOKUP(Form!#REF!,'Email list'!$A$3:$B$15,2,0),\"\")","v":""}]
["Email 2",{"$f":"IFERROR(VLOOKUP(Form!#REF!,'Email list'!$A$3:$B$10,2,0),\"\")","v":""}]