{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Starter form","Import"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Starter form","index":0,"n_rows":115,"n_cols":15,"rows_kept":115,"cut":false,"hidden":false,"merged":[[111,2,111,5],[112,2,112,5],[2,1,2,2],[1,1,1,3],[1,4,1,5],[19,1,19,3],[20,1,20,2],[21,1,21,2],[6,1,6,3],[11,1,11,3],[8,1,8,2],[10,1,10,2],[84,1,84,3],[9,1,9,2],[18,1,18,2],[7,1,7,2],[67,1,67,3],[75,1,75,3],[28,1,28,3],[24,1,24,2],[25,1,25,2],[23,1,23,2],[12,1,12,2],[13,1,13,3],[14,1,14,2],[15,1,15,3],[16,1,16,2],[17,1,17,3]]}
["Row look up","Guide"]
[1,"Please complete the information USING EXCEL. Start by opening the master and then save this with the name:",null,null,"Starter Form - {Employee name}"]
[null,"Please answer ALL items marked in orange"]
[2,"After completion:"]
[3,"Print for employee signing and retain  a signed copy on your files"]
[4,"E mail the Excel form to ",null,null,"chris@completeaccounts.co.uk"]
[5,{"$f":"D9&\" -NEW EMPLOYEE STARTER PACK\"&\" - \"&D31&\" \"&D33","v":" -NEW EMPLOYEE STARTER PACK -  "},null,null,"Items that must be completed for payroll bureau","Information retained by payroll bureau",{"$nulls":6},"Check - essential information","Import Field","Import - Value"]
[6,"DATE ( dd/mm/yy):",null,null,"*",{"$nulls":7},{"$f":"IF(D8=\"\",1,0)","v":1}]
[7,"COMPANY NAME:",null,null,"*",{"$nulls":7},{"$f":"IF(D9=\"\",1,0)","v":1}]
[8,"Data Protection Statements"]
[9,"Confidentiality"]
[10,"All the information that you enter on this form remains confidential and is only shared with our Payroll Bureau         ( the data processor ) who only use the information for processing the wages and for no other purpose"]
[11,"Access to your data"]
[12,"You can request access to the data held by the bureau  at any time by e mailing them direct using the contact details below. You must quote your name and date you started your employment here for identification purposes"]
[13,"Retention of the data"]
[14,"We will only hold your data for as long is necessary to administer your payroll"]
[15,"Security of your data"]
[16,"The payroll bureau will hold your data on a computer whose access is password protected and contains an internet firewall to prevent unauthorised access. Payslip e mails are generated by the payroll bureau but the payslips are not sent password protected unless you specifically request that this service is provided by following the instructions below"]
[17,"E mailing payslips"]
[18,"The most secure way to have payslips e mailed is to use password protected encryption. In order to do this the payroll bureau will need your e mail address and also your chosen password. Please complete the items below."]
[19,"Your e mail address",null,"Please send an e mail to the payroll bureau using the information below. In the subject header enter your name and the name of your employer. This will give me your e mail address and also allow the payroll bureau's systems to recognise your e mail address."]
[20,"Your password",null,"Enter your chosen password below. You will need to enter this to open the payslip"]
[21,{"$nulls":12},"Password",{"$f":"D23","v":0}]
[22,"Our payroll bureau details"]
[23,"Name",null,"Complete Accounts Limited"]
[24,"Contact",null,"chris@completeaccounts.co.uk"]
[25,"Their Data Protection and Security notice",null,"www.completeaccounts.co.uk/wp-content/uploads/2018/05/Data-protection-and-security-policy-vMay-2018.pdf"]
[26,"Their Privacy Notice",null,"www.completeaccounts.co.uk/wp-content/uploads/2018/05/Privacy-Notice-vMay-2018.pdf"]
[27,"PERSONAL DETAILS:",null,null,null,"Information retained by payroll bureau"]
[28,null,"Title (Mr / Mrs / Miss / Ms / Other)",null,"*","y",{"$nulls":6},{"$f":"IF(D30=\"\",1,0)","v":1},{"$f":"IF(E30=\"*\",C30,\"\")","v":"Title (Mr / Mrs / Miss / Ms / Other)"},{"$f":"IF(E30=\"*\",D30,\"\")","v":0}]
[29,null,"First Name",null,"*","y",{"$nulls":6},{"$f":"IF(D31=\"\",1,0)","v":1},{"$f":"IF(E31=\"*\",C31,\"\")","v":"First Name"},{"$f":"IF(E31=\"*\",D31,\"\")","v":0}]
[30,null,"Middle Name",null,null,"Y",{"$nulls":7},{"$f":"C32","v":"Middle Name"},{"$f":"D32","v":0}]
[31,null,"Surname",null,"*","y",{"$nulls":6},{"$f":"IF(D33=\"\",1,0)","v":1},"Surname",0]
[32,null,"Address 1 - House number and road",null,"*","y",{"$nulls":6},1,"Address 1 - House number and road",0]
[33,null,"Address 2 - District",null,null,"y",{"$nulls":6},1,"",""]
[34,null,"Address 3 - Town / City",null,"*","Y",{"$nulls":6},1,"Address 3 - Town / City",0]
[35,null,"Post Code",null,"*","y",{"$nulls":6},1,"Post Code",0]
[36,null,"Date of Birth ( dd/mm/yyyy)",null,"*","y",{"$nulls":6},1,"Date of Birth ( dd/mm/yyyy)","00:00:00"]
[39,null,"Marital Status (enter \"S\" or \"M\")",null,"*","y",{"$nulls":6},1,"Marital Status (enter \"S\" or \"M\")",0]
[40,null,"NI Number",null,"*","y",{"$nulls":6},1,"NI Number",0]
[41,null,"Phone Number (mobile)",{"$nulls":10},"",""]
[42,null,"Phone Number (landline)",{"$nulls":10},"",""]
[43,null,"Email Address",null,null,"y",{"$nulls":7},"",""]
[44,null,"Next of Kin",{"$nulls":10},"",""]
[45,null,"Relationship to Next of Kin",{"$nulls":10},"",""]
[46,null,"Next of Kin Phone Number (mobile)",{"$nulls":10},"",""]
[47,null,"Next of Kin Phone Number (landline)",{"$nulls":10},"",""]
[48,null,"Relevant Health Details (allergies, any ongoing conditions or medications, previous injuries etc.)  - enter \"None\" if there are no items",{"$nulls":10},"",""]
[49,null,"Student loans",{"$nulls":10},"",""]
[50,{"$f":"IF(D50=\"\",\"*\",\"\")","v":"*"},"Do you have an outstanding student loan? (enter  \"y\" or \"n\")",null,"*","y",{"$nulls":6},{"$f":"IF(D50=\"\",1,0)","v":1},"Do you have an outstanding student loan? (enter  \"y\" or \"n\")",0]
[51,null,"If you have a student loan enter the plan number ( 1,2….etc )",null,{"$f":"IF(D50=\"y\",\"*\",\"\")","v":""},"y",{"$nulls":6},{"$f":"IF(D50=\"Y\",IF(D51=\"\",1,0),0)","v":0},{"$f":"IF(E51=\"*\",\"Plan Number\",\"\")","v":""},""]
[52,null,null,{"$f":"IF(AND(D50=\"\",D51=\"\"),\" * Please complete the two boxes above regarding student loans. If there are no loans, leave plan type blank\",\"\")","v":" * Please complete the two boxes above regarding student loans. If there are no loans, leave plan type blank"},{"$nulls":9},{"$f":"IF(E52=\"*\",C52,\"\")","v":""},{"$f":"IF(E52=\"*\",D52,\"\")","v":""}]
[53,{"$nulls":12},"",""]
[54,"BANK ACCOUNT DETAILS:",null,"The details are only needed if you are paid direct to your bank",{"$nulls":9},"",""]
[55,null,"Account Name",null,null,"y",{"$nulls":7},"",""]
[56,null,"Account Number",null,null,"y",{"$nulls":7},"",""]
[57,null,"Sort Code",null,null,"y",{"$nulls":7},"",""]
[{"$nulls":13},"",""]
[null,"ONLY COMPLETE THE FOLLOWING QUESTION IF YOU ARE NOT UK RESIDENT",{"$nulls":11},"",""]
[null,"EMPLOYEE COMING FROM ABROAD",null,"This is important to ensure correct National Insurance contributions",{"$nulls":9},{"$f":"IF(E60=\"*\",C60,\"\")","v":""},{"$f":"IF(E60=\"*\",D60,\"\")","v":""}]
[{"$nulls":13},"",""]
[null,null,"In which country are you resident normally?",null,null,"Y",{"$nulls":7},"",""]
[{"$nulls":13},"",""]
[null,null,null,"Enter YES or NO - if Yes then enclose a copy of the form",{"$nulls":9},"",""]
[null,null,"If you are from EEA or Switzerland, do you have a valid Portable Document A1 ( or E101 )",null,null,"Y",{"$nulls":7},"",""]
[{"$nulls":13},"",""]
[58,{"$nulls":12},"",""]
[59,"Employee declaration - please select ONE of the statements below ( enter \"y\" in the ONE box that applies to you )",null,null,null,"Information retained by payroll bureau",{"$nulls":7},"",""]
[]
[60,"A","This is my first job since last 6th April and I have not been receiving taxable Jobseekers allowance, Employment and Support Allowance, taxable Incapacity Benefit, state pension or occupational pension.","y",{"$f":"IF(AND($D$70=\"\",$D$71=\"\",$D$72=\"\"),\"*\",\"\")","v":""},"y",{"$nulls":7},{"$f":"IF(D70=\"\",\"\",C70)","v":"This is my first job since last 6th April and I have not been receiving taxable Jobseekers allowance, Employment and Support Allowance, taxable Incapacity Benefit, state pension or occupational pension."},{"$f":"IF(D70=\"\",\"\",\"A\")","v":"A"}]
[61,"B","This is my only job, but since last 6 April I have had another job, or have received taxable Jobseekers allowance, Employment and Support Allowance or taxable Incapacity Benefit. I do not receive state or occupational pension.",null,{"$f":"IF(AND($D$70=\"\",$D$71=\"\",$D$72=\"\"),\"*\",\"\")","v":""},"y",{"$nulls":7},{"$f":"IF(D71=\"\",\"\",C71)","v":""},{"$f":"IF(D71=\"\",\"\",\"B\")","v":""}]
[63,"C","I have another job or receive state or occupational pension",null,{"$f":"IF(AND($D$70=\"\",$D$71=\"\",$D$72=\"\"),\"*\",\"\")","v":""},"y",{"$nulls":7},"",{"$f":"IF(D72=\"\",\"\",\"C\")","v":""}]
[64,null,null,{"$f":"IF(AND(D70=\"\",D71=\"\",D72=\"\"),\"Please complete at least one statement from A, B or C above\",\"\")","v":""},{"$f":"IF(AND(D70=\"\",D71=\"\",D72=\"\"),\"*\",\"\")","v":""},{"$nulls":7},{"$f":"IF(D73<>\"\",1,0)","v":0},"",""]
[null,null,null,{"$f":"IF(D71=\"Y\",\"You entered yes to the box B above -  please also provide your P45 from the previous job\",\"\")","v":""}]
[null,null,null,{"$f":"COUNTIF(D70:D72,\"<>\")","v":1}]
[65,"Employee signing",{"$nulls":11},"",""]
[66,{"$nulls":12},"",""]
[67,null,"Employee declaration",{"$nulls":10},"",""]
[68,null,"All of the above information is provided for the purposes of processing my payslips and calculating the correct deductions for tax, national insurance and student loan deductions.\n\nIt is accurate to the best of my knowledge and belief","Employee to sign here after printing:",{"$nulls":9},"",""]
[69,null,"Date",{"$f":"D8","v":"00:00:00"},{"$nulls":9},"",""]
[70,{"$nulls":12},"",""]
[71,null,"An excel version of this form can be e mailed direct to the payroll bureau",{"$f":"D26","v":"chris@completeaccounts.co.uk"},{"$nulls":9},"",""]
[72,{"$nulls":12},"",""]
[73,{"$nulls":12},"",""]
[74,"Internal - to be completed by the employer",{"$nulls":11},"",""]
[75,null,"Start Date",null,"*","y",{"$nulls":6},{"$f":"IF(D86=\"\",1,0)","v":1},"Start Date","00:00:00"]
[76,null,"Normal work days ","Please enter \"y\" in work days below or enter \"Y\" in blue cell below"]
[77,null,"Monday","n","*","y",{"$nulls":7},{"$f":"IF(E88=\"*\",C88,\"\")","v":"Monday"},{"$f":"D88","v":"n"}]
[78,null,"Tuesday","n","*","y",{"$nulls":7},"Tuesday",{"$f":"IF(E89=\"*\",D89,\"\")","v":"n"}]
[79,null,"Wednesday","n","*","y",{"$nulls":7},"Wednesday","n"]
[80,null,"Thursday","n","*","y",{"$nulls":7},"Thursday","n"]
[81,null,"Friday","n","*","y",{"$nulls":7},"Friday","n"]
[82,null,"Saturday","n","*","y",{"$nulls":7},"Saturday","n"]
[83,null,"Sunday","n","*","y",{"$nulls":7},"Sunday","n"]
[84,null,"No normal work days ( Irrgular Payments )","n","*","y",{"$nulls":7},{"$f":"IF(E95=\"*\",C95,\"\")","v":"No normal work days ( Irrgular Payments )"},{"$f":"IF(E95=\"*\",D95,\"\")","v":"n"}]
[85,null,null,{"$f":"IF(AND($D$88=\"n\",$D$89=\"n\",$D$90=\"n\",$D$91=\"n\",$D$92=\"n\",$D$93=\"n\",$D$94=\"n\",D95=\"n\"),\"Please complete at least one day above\",\"\")","v":"Please complete at least one day above"},{"$nulls":9},"",""]
[null,null,null,{"$f":"COUNTIF(D88:D95,\"y\")","v":0},{"$nulls":8},{"$f":"IF(D97=0,1,0)","v":1},"Not entered days worked",""]
[86,null,"Normal contracted hours per week ",null,"*","y",{"$nulls":6},{"$f":"IF(D98=\"\",1,0)","v":1},"Normal contracted hours per week ",{"$f":"IF(D98<16,\"Less than 16 hours\",D98)","v":"Less than 16 hours"}]
[87,null,"Enter \"y\" if there are irregular payments",null,"*","y",{"$nulls":7},"Enter \"y\" if there are irregular payments",0]
[88,null,"Hourly pay rate at start",null,"*","y",{"$nulls":6},1,{"$f":"IF(E100=\"*\",C100,\"\")","v":"Hourly pay rate at start"},{"$f":"IF(E100=\"*\",D100,\"\")","v":0}]
[89,{"$nulls":12},"",""]
[90,{"$nulls":12},"",""]
[91,null,"Auto Enrolment",{"$nulls":10},"",""]
[92,null,"If this employee qualifies to be auto enroled now, do you want to:","Please answer the question below",null,"y",{"$nulls":7},"",""]
[93,"A","Enrol now",null,"*","y",{"$nulls":6},{"$f":"IF(AND($D$105=\"\",$D$106=\"\"),1,0)","v":1},"Enrol now",0]
[94,"B","Pospone for 3 months",null,"*","y",{"$nulls":6},{"$f":"IF(AND($D$105=\"\",$D$106=\"\"),1,0)","v":1},"Pospone for 3 months",0]
[95,null,null,{"$f":"IF(AND($D$105=\"\",$D$106=\"\"),\"Please complete at least one option from A or B above\",\"\")","v":"Please complete at least one option from A or B above"}]
[null,null,null,{"$f":"COUNTIF(D105:D106,\"y\")","v":0}]
[96,null,"ID Checked (Passport / Driving Licence / Birth Certificate)",{"$nulls":10},"",""]
[97,{"$nulls":12},"",""]
[98,{"$nulls":11},{"$f":"SUM(M8:M110)","v":19},"",""]
[99,{"$f":"IF(M111>0,\"ERROR\",\"\")","v":"ERROR"},{"$f":"IF(M111>0,\"There is essential information missing - please complete items marked\"& \" * \"&\" before e mailing the form to\"&\" \"&D82,\" \")","v":"There is essential information missing - please complete items marked *  before e mailing the form to chris@completeaccounts.co.uk"},{"$nulls":10},"E mail","lindsey@petresort.co.uk"]
[null,null,{"$f":"IF(M111<>0,\"There are \"&M111&\" items not answered above\",\" \")","v":"There are 19 items not answered above"},{"$nulls":10},"Gender",{"$f":"IF(D30=\"Mr\",\"M\",\"F\")","v":"F"}]
[]
[null,null,"After Completing this form in Excel please e mail to:","chris@completeaccounts.co.uk"]

{"sheet":"Import","index":1,"n_rows":10,"n_cols":26,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Import Row",28,29,30,31,40,51,36,38,75,32,33,34,35,84,88,86,39,77,78,79,80,81,82,83]
[null,"Title","Name","Middle name","Surname","National Insurance Number","Student Loan deduction plan","Date of birth","Gender","Start date","Address line 1","Address line 2","Address line 3","Postcode","Is irregular payment pattern","Hourly Rate","Contracted hours per week","Marital Stus","Typical Work day - Monday","Typical Work day - Tuesday","Typical Work day - Wednesday","Typical Work day - Thursday","Typical Work day - Friday","Typical Work day - Saturday","Typical Work day - Sunday","Starter Form"]
[null,{"$f":"IF(INDEX(Lookup_response,MATCH(B1,main_lookup,0))=\"\",\"\",INDEX(Lookup_response,MATCH(B1,main_lookup,0)))","v":""},"","","","","","",{"$error":"#N/A"},"","","","","","n","","","","n","n","n","n","n","n","n",{"$f":"F10","v":"A"}]
[]
[]
[null,"Starter form"]
[null,null,60,61,63,"Answer"]
[null,null,"Signed A","Signed B","Signed C"]
[null,"Response",{"$f":"IF(INDEX(Lookup_response,MATCH(C7,main_lookup,0))=\"\",\"\",INDEX(Lookup_response,MATCH(C7,main_lookup,0)))","v":"y"},{"$f":"IF(INDEX(Lookup_response,MATCH(D7,main_lookup,0))=\"\",\"\",INDEX(Lookup_response,MATCH(D7,main_lookup,0)))","v":""},{"$f":"IF(INDEX(Lookup_response,MATCH(E7,main_lookup,0))=\"\",\"\",INDEX(Lookup_response,MATCH(E7,main_lookup,0)))","v":""},"Y"]
[null,"Answer","A","B","C",{"$f":"IF(AND(C9=\"\",D9=\"\",E9=\"\"),\"\",INDEX(LOAN_ANSWER,,MATCH(F9,LOAN_RESPONSE,0)))","v":"A"}]