{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Macro Support","Welcome Page","Staff Changes Form","Payroll Use Only","Admin Use Only","Lists"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":18,"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":"Macro Support","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[14,1,24,1],[5,0,6,0],[25,0,30,0],[18,0,19,0],[31,0,31,1]]}
[null,"Please ensure that you have enabled Macros before proceeding.\n Details on how to do this are below"]
[]
["Excel 2007"]
[]
[]
["Click here to Open Welcome Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Excel 2013+"]
[]
[]
["Click here to Open Welcome Page"]
[]
[]
[]
[]
[]
[]
["N.B. If you do not see the screenshots above then please follow these instruction to adjust the macros security level","1. Click the Microsoft Office/File Button"]
[null,"2. Click Excel Option"]
[null,"3. In the Trust Centre Category, click Trust Centre Settings"]
[null,"4. Click the Macro Setting Category"]
[null,"5. Select the 'Disable All macros (with notification)' option and press OK"]
[null,"Excel will need to be closed down and reopened for this change to take effect"]
["v1.1.5"]

{"sheet":"Welcome Page","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,20,2],[9,5,15,5],[9,6,15,6],[18,0,18,6],[15,3,15,4],[15,0,15,2],[13,0,13,2],[16,0,16,6],[17,0,17,6],[11,0,11,2],[12,0,12,2],[11,3,11,4],[14,0,14,2],[12,3,12,4],[14,3,14,4],[13,3,13,4],[9,3,9,4],[10,3,10,4],[7,3,7,4],[0,0,0,5],[1,0,3,6],[4,0,4,2],[4,3,4,6],[5,0,5,2],[5,5,8,5],[5,6,8,6],[6,0,6,2],[8,3,8,4],[7,0,7,2],[5,3,5,4],[6,3,6,4]]}
[]
["    To proceed to the Instruction Form:                                                                "]
[]
[]
["This form can be used for:",null,null,"This form cannot be used for:"]
["● Change of Base - EXPENSES ONLY",null,null,"● Employment of New Starters (Via Trac)",null,"Once Pre-Employment Checks are completed, an electronic New Appointment Form will automatically be sent to the recruiting manager","Click Here for Guidance\n"]
["● Professional Registration Received",null,null,"● Internal Appointments"]
["● Change of post due to:",null,null,"● Enrolment of External New Bank Starters  "]
["~ Temporary change of Grade not via Trac"]
["~ Re-evaluation",null,null,"● Increasing/Decreasing Contractual Hours",null,"This should be completed via ESR Supervisor/Manager Self Service ","Click Here for Guidance"]
["~ Redeployment/Organisational Change",null,null,"● Change of Manager"]
["● Appointing to Bank (Internal Staff Only) ",null,null,"● Terminations"]
["● Employment Break",null,null,"● Change of Personal Details "]
["● Return to Work from Employment Break",null,null,"● Extension to Contract"]
["● Return to Work from Maternity/Adoption/Shared Parental Leave",null,null,"● Change of Bank Details "]
["● Annex 21",null,null,"● Close Sickness Periods "]
["Support Details:"]
["          To view support with Macros or technical support with this form: "]
["If you have any other queries or require further advice:"]
[]
[null,"Click Here to Email",null,null,null,"02920 903908"]

{"sheet":"Staff Changes Form","index":2,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,0,77,2],[77,3,77,6],[78,0,78,1],[79,0,79,2],[81,0,81,2],[82,0,82,6],[59,2,59,3],[59,5,59,7],[60,0,60,7],[64,0,64,7],[73,4,73,7],[74,0,75,7],[77,7,81,7],[76,0,76,6],[71,0,71,1],[71,2,71,3],[71,4,71,5],[71,6,71,7],[72,0,72,1],[72,2,72,3],[72,4,72,5],[72,6,72,7],[73,0,73,2],[68,0,68,1],[68,2,68,3],[68,4,68,5],[68,6,68,7],[69,0,69,1],[69,2,69,3],[69,4,69,5],[69,6,69,7],[70,0,70,1],[70,2,70,3],[70,4,70,5],[70,6,70,7],[65,0,65,1],[65,2,65,3],[65,4,65,5],[65,6,65,7],[66,0,66,1],[66,2,66,3],[66,4,66,5],[66,6,66,7],[67,0,67,1],[67,2,67,3],[67,4,67,5],[67,6,67,7],[59,0,59,1],[63,4,63,5],[63,6,63,7],[58,0,58,7],[48,0,49,4],[50,0,50,7],[51,0,53,4],[26,0,26,2],[27,0,27,6],[29,0,29,2],[56,0,56,1],[51,5,53,5],[54,0,54,7],[55,0,55,1],[29,3,29,7],[31,0,31,5],[26,3,26,7],[22,3,22,7],[23,0,23,6],[33,0,33,7],[35,0,35,2],[47,4,47,5],[47,0,47,2],[41,0,41,7],[42,0,42,7],[43,0,43,7],[38,0,38,6],[39,0,39,6],[44,0,46,4],[44,5,46,5],[30,0,30,6],[32,0,32,5],[35,3,35,7],[34,0,34,7],[36,0,36,4],[36,5,36,7],[32,6,32,7],[28,0,28,2],[28,3,28,7],[19,3,19,4],[22,0,22,2],[25,0,25,6],[15,0,15,1],[14,6,14,7],[9,0,9,6],[6,0,6,1],[7,0,7,1],[8,0,8,1],[6,2,6,4],[16,6,16,7],[13,0,13,6],[7,2,7,4],[8,2,8,4],[17,6,17,7],[20,0,20,5],[20,6,20,7],[21,3,21,7],[21,0,21,2],[19,6,19,7],[19,0,19,2],[15,6,15,7],[24,0,24,6],[17,0,17,5],[14,2,14,4],[15,2,15,4],[11,5,11,7],[11,0,11,4],[37,0,37,6],[0,0,0,7],[3,0,3,7],[5,0,5,1],[4,2,4,4],[5,2,5,4],[4,6,4,7],[5,6,5,7],[1,0,1,7],[2,0,2,7],[4,0,4,1],[10,0,10,3],[10,4,10,7],[18,0,18,5],[18,6,18,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[12,0,12,6],[14,0,14,1]]}
[]
["Note: If the member of staff is moving to  a new department, please arrange to transfer their personal file inclusive of sickness information you may hold to the new line manager."]
["ALL FIELDS MARKED * Are Mandatory."]
["Section 1 - Current Details for Employee"]
["Forename(s)*",null,null,null,null,"Surname:*"]
["Assignment Number*",null,null,null,null,"Grade/Band*"]
["Directorate*",null,null,null,null,"Department*"]
["Position Number*",null,null,null,null,"Current Hours/Sessions*"]
["Current Manager*",null,null,null,null,"Managers Email*"]
["Effective Date of Change(s)  i.e. Date the contractual change starts*"]
["Please select reason for submission:*",null,null,null,"Please Select"]
["Please indicate reason",null,null,null,null,"Please Select"]
["Is there a change to Contracted Hours?",null,null,null,null,null,null,"Please Select"]
["New Hours/Sessions"]
["New Position Number*",null,null,null,null,"New Position Title*"]
["New Directorate*",null,null,null,null,"New Department*"]
["New Grade/ Band*"]
["Frequency Hours/Sessions*",null,null,null,null,null,"Please Select"]
["Is this subject to Long/Short Term Protection?",null,null,null,null,null,"Please Select"]
["In addition to current post or replacing current post?",null,null,"Please Select",null,"Contract Type","Please select"]
["Will the Supervisor/Manager be changing?",null,null,null,null,null,"Please Select"]
["New Supervisor/Manager Name"]
["New Supervisor/Manager Staff Number"]
["End date of Temporary Move*"]
["Will the Employee be returning to their Substantive Post?",null,null,null,null,null,null,"Please Select"]
["Is there a change to Base?",null,null,null,null,null,null,"Please Select"]
["New Base*"]
["If this member of staff claims expenses will the SEL Authoriser be changing?",null,null,null,null,null,null,"Please Select"]
["SEL Authorisers Name"]
["SEL Authorisers Staff Number"]
["Is Excess Mileage to be paid?"]
["Return to Work (Maternity/Adoption/Shared Parental/Employment Break)",null,null,null,null,null,"Reason:","Please Select"]
["Pension Contributions to be continued*",null,null,null,null,null,"Please Select"]
["Change to Contractual Hours"]
["Please note that only changes of hours to employees who are Term Time or Annualised hours can be adjusted on this form.  Any other changes should be actioned through Manager Self Service on ESR via the following link:  https://my.esr.nhs.uk"]
["Please indicate reason*",null,null,"Please Select"]
["If Term Time, please indicate if inset days will be worked*",null,null,null,null,"Please Select"]
["Term Time Weekly Working Hours* (Worked hours per week not paid Hours)"]
["Please confirm Service Length for Annual Leave Purposes*",null,null,null,null,null,null,"Please Select"]
["Please confirm the Percentage Rate*"]
[]
["Additional Comments"]
[]
["Manager Authorisation"]
["Please click the box to sign the form this will act as your electronic signature*",null,null,null,null,null,"Nadex:"]
[null,null,null,null,null,null,"Dated:"]
[null,null,null,null,null,null,"Name:",{"$f":"IF(H45=0,\"\",Get_LDAP_User_Properties(\"USER\",\"SamAccountName\",H45,\"DisplayName\"))","v":""}]
["All changes need to be authorised by your Budget Holder please provide their name and Email Address here:*",null,null,"Name:*",null,null,"Email:*"]
["Data Protection Disclaimer: Ensure the Budget Holders email address is entered correctly including any identifying numbers as you are emailing personal information.                                     Click Here to submit the form.",null,null,null,null,null,"Submitted by:"]
[null,null,null,null,null,null,"Submitted on:"]
["Budget Holder Authorisation"]
["Please tick the box to sign the form this will act as your electronic signature",null,null,null,null,null,"Nadex:"]
[null,null,null,null,null,null,"Dated:"]
[null,null,null,null,null,null,"Name:",{"$f":"IF(H52=0,\"\",Get_LDAP_User_Properties(\"USER\",\"SamAccountName\",H52,\"DisplayName\"))","v":""}]
[]
["Submitted by:",null,{"$f":"IF(C58>0,Get_LDAP_User_Properties(\"user\",\"SamAccountName\",C58,\"DisplayName\"),\"\")","v":""}]
["Submitted on:"]
["This line for admin use only, do not amend"]
["PAYROLL ONLY"]
["Assignment Number:",null,{"$f":"C6","v":0},null,"Name:",{"$f":"C5&\" \" &G5","v":" "}]
[]
["DATE TRACK","CURRENT HOURS","NEW HOURS","†PAYSCALE","SALARY","INCREMENT DATE","PENSION TIER"]
[{"$f":"H10","v":"00:00:00"},{"$f":"G8","v":0}]
[]
["CALCULATION "]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments"]
[]
[]
[]
["PAY PERIOD",null,null,null,null,null,null,"Once signed an email is sent to the Manager informing them that the Payroll Instruction Form has been processed."]
["ACTIONED BY:",null,null,null,{"$f":"IF(D79=0,\"\",Get_LDAP_User_Properties(\"User\",\"SamAccountName\",D79,\"DisplayName\"))","v":""}]
["DATE ACTIONED"]
["CHECKED BY",null,null,null,{"$f":"IF(D81=0,\"\",Get_LDAP_User_Properties(\"User\",\"SamAccountName\",D81,\"DisplayName\"))","v":""}]
["DATE ACTIONED"]

{"sheet":"Payroll Use Only","index":3,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":true,"merged":[[68,0,68,6],[40,6,40,7],[41,6,41,7],[42,6,42,7],[40,8,40,9],[41,8,41,9],[42,8,42,9],[40,10,40,11],[41,10,41,11],[42,10,42,11],[59,0,59,3],[58,4,58,11],[59,4,59,11],[63,3,63,4],[61,0,61,2],[62,0,62,1],[58,0,58,3],[55,4,55,11],[62,4,62,6],[61,7,65,11],[53,4,53,11],[54,4,54,11],[56,0,56,3],[61,3,61,6],[16,0,16,7],[18,0,18,1],[19,0,19,1],[22,0,22,1],[17,0,17,11],[18,4,18,5],[19,4,19,9],[22,4,22,9],[21,0,21,1],[20,4,20,9],[25,4,25,6],[28,5,28,11],[19,10,22,11],[23,0,23,1],[18,2,25,3],[23,4,23,6],[23,7,25,11],[26,0,26,11],[27,0,27,4],[28,0,28,4],[27,5,27,11],[15,0,15,11],[12,0,12,3],[4,8,4,9],[4,10,4,11],[2,0,2,1],[0,0,0,11],[2,6,2,7],[2,8,2,11],[2,2,2,5],[4,0,4,1],[4,4,4,5],[4,6,4,7],[1,0,1,11],[3,0,3,11],[11,0,11,11],[5,8,5,9],[6,8,6,9],[10,8,10,9],[5,10,5,11],[6,10,6,11],[10,10,10,11],[14,4,14,11],[12,7,12,11],[5,6,5,7],[6,6,6,7],[10,6,10,7],[9,4,9,5],[7,6,7,7],[8,6,8,7],[9,6,9,7],[9,8,9,9],[7,10,7,11],[8,10,8,11],[9,10,9,11],[7,4,7,5],[8,4,8,5],[5,4,5,5],[7,8,7,9],[8,8,8,9],[5,0,5,1],[6,0,6,1],[6,4,6,5],[46,8,46,9],[47,0,47,2],[51,4,51,11],[10,0,10,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,4,10,5],[37,4,37,7],[48,0,50,11],[18,6,18,11],[21,4,21,9],[12,4,12,6],[20,0,20,1],[14,0,14,3],[13,0,13,11],[35,2,35,3],[34,4,35,5],[30,0,30,2],[16,8,16,11],[30,3,30,11],[41,2,41,3],[42,2,42,3],[40,4,40,5],[41,4,41,5],[42,4,42,5],[35,0,35,1],[36,0,36,11],[38,0,38,11],[29,0,29,11],[31,0,31,11],[32,0,32,4],[32,5,32,11],[33,0,33,11],[34,0,34,1],[34,2,34,3],[34,6,34,9],[34,10,34,11],[35,6,35,11],[24,0,24,1],[25,0,25,1],[24,4,24,6],[39,8,39,9],[43,8,43,9],[53,0,53,3],[54,0,54,3],[46,4,46,5],[52,0,52,3],[45,8,45,9],[52,4,52,11],[47,3,47,11],[45,4,45,5],[46,0,46,1],[46,2,46,3],[39,10,39,11],[40,0,40,1],[41,0,41,1],[42,0,42,1],[40,2,40,3],[44,10,44,11],[45,10,45,11],[46,10,46,11],[60,0,60,6],[43,10,43,11],[57,4,57,11],[51,0,51,3],[44,8,44,9],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[37,0,37,3],[67,0,67,2],[67,3,67,6],[66,4,66,6],[66,0,66,2],[65,0,65,2],[63,0,63,2],[65,3,65,4],[64,4,64,6],[39,0,39,1],[39,2,39,3],[39,4,39,5],[45,0,45,1],[45,2,45,3],[44,0,44,1],[44,2,44,3],[44,4,44,5],[43,0,43,1],[43,2,43,3],[43,4,43,5],[57,0,57,3],[39,6,39,7],[55,0,55,3],[56,4,56,11]]}
["AMENDMENTS TO PAY AND ALLOWANCES"]
[]
["Assignment Number:",null,{"$f":"'Staff Changes Form'!C6 & \"\"","v":""},null,null,null,"Name:",null,{"$f":"'Staff Changes Form'!C5 & \" \" & 'Staff Changes Form'!G5","v":" "}]
[]
["DATE TRACK",null,"CURRENT HOURS","HEW HOURS","†PAYSCALE",null,"SALARY",null,"INCREMENT DATE",null,"PENSION TIER"]
[{"$f":"'Staff Changes Form'!H10","v":"00:00:00"},null,{"$f":"'Staff Changes Form'!G8 & \"\"","v":""},{"$f":"'Staff Changes Form'!H14 & \"\"","v":""}]
[]
[]
[]
[]
[]
[]
["*Additional Posts",null,null,null,"Please Select"]
[]
["Diary Reminder"]
[]
["†Earned date if Enh/OT etc. not paid in month of promotion"]
[]
["DATE TRACK",null,null,null,"ELEMENT"]
[{"$f":"'Staff Changes Form'!H10","v":"00:00:00"}]
[]
[]
[]
["DATE TRACK",null,null,null,"POSITION NUMBER"]
[{"$f":"'Staff Changes Form'!H10","v":"00:00:00"},null,null,null,{"$f":"'Staff Changes Form'!C24 &\"\"","v":""}]
[]
[]
["SEL EXPENSES AUTHORISER NAME:",null,null,null,null,{"$f":"IF('Staff Changes Form'!D29=0,\"\",'Staff Changes Form'!D29)","v":""}]
["SEL EXPENSES AUTHORISER ASSIGNMENT NUMBER:",null,null,null,null,{"$f":"IF('Staff Changes Form'!D30=0,\"\",'Staff Changes Form'!D30)","v":""}]
[]
["PAYSLIP DELIVERY ADDRESS:"]
[]
["LOCATION AS OF DATE OF CHANGE"]
[]
["CSD 3 MONTHS",null,null,null,null,null,"* Pension Interface assignment",null,null,null,"Please Select"]
["CSD 12 MONTHS"]
[]
["ADJUSTMENT CALCULATION",null,null,null,"PLEASE SELECT"]
["CALCULATION "]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments"]
[]
[]
[]
["Date of Position Number Change:",null,null,null,{"$f":"'Staff Changes Form'!H10&\"\"","v":""}]
["New Position Number:",null,null,null,{"$f":"'Staff Changes Form'!C15 & \"\"","v":""}]
["Salary as at date of Change:"]
["Hours as at date of Change:"]
["Increment date as at date of Change:"]
["Location prior to change:"]
["Change of Manager:"]
["Date input into ESR:"]
["Additional Post Updated:"]
[]
["PAY PERIOD",null,null,null,null,null,null,"Once signed an email is sent to the Manager informing them that the Payroll Instruction Form has been processed."]
["ACTIONED BY:",null,null,null,{"$f":"IF(D63=0,\"\",Get_LDAP_User_Properties(\"User\",\"SamAccountName\",D63,\"DisplayName\"))","v":""}]
["DATE ACTIONED"]
["CHECKED BY",null,null,null,{"$f":"IF(D65=0,\"\",Get_LDAP_User_Properties(\"User\",\"SamAccountName\",D65,\"DisplayName\"))","v":""}]
["DATE ACTIONED"]
["PAYSLIP CHECKED",null,null,null,{"$f":"IF(D67=0,\"\",Get_LDAP_User_Properties(\"User\",\"SamAccountName\",D67,\"DisplayName\"))","v":""}]
["DATE ACTIONED"]

{"sheet":"Admin Use Only","index":4,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Please Select",null,"Please Select",null,"Please Select","Managers Email Address"]
["Yes",null,"Redeployment",null,"Term Time",{"$f":"'Staff Changes Form'!G9","v":0},"Keep F2 Free"]
["No",null,"Organisational Change",null,"Annualised Hours","Budget Holders Email Address"]
[null,"<------KEEP THIS CELL BLANK FOR ADMIN PURPOSES",null,null,null,{"$f":"'Staff Changes Form'!H48","v":0},"Keep F4 Free"]

{"sheet":"Lists","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
["Reason For Change",null,"Frequency","AddReplace","Protection","AnnualLeave"]
["Please Select",null,"Please Select","Please Select","Please Select","Please Select"]
["Appointment to New Post",null,"Hours","Addition","No","0-4 years"]
["Professional Registration Received",null,"Sessions","Replacing","Long Term Protection","5-9 years"]
["Change of Base - EXPENSES ONLY",null,null,null,"Short Term Protection","10 years +"]
["Commencement of Employment Break",null,null,null,"Both"]
["Change of Contractual Hours (Term Time/Annualised Hours only)"]
["Return to Work (Maternity/Adoption/Shared Parental/Employment Break)",null,"Contract Type",null,"Mileage"]
["Annex 21",null,"Please select",null,"Please Select"]
[null,null,"Permanent",null,"No"]
[null,null,"Fixed Term",null,"Yes - Monthly"]
[null,null,"Bank ",null,"Yes - 2 Year Lump Sum"]
[null,null,"Locum"]
[]
[]
[]
[null,null,"YesNo",null,"RTW"]
["Sub Reason",null,"Please Select",null,"Please Select"]
["Please Select",null,"Yes",null,"Maternity Leave"]
["Re Evaluation",null,"No",null,"Adoption Leave"]
["Temporary Move to Higher Grade/Post",null,null,null,"Shared Parental Leave"]
["Redeployment/Organisational Change",null,null,null,"Employment Break"]
["Internal Bank Post Appointment (Internal Staff Only)"]
["Completed Adaptation Programme"]
["Internal Appointment-TRAC"]