{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Welcome","Validation Format Example","Allowances","Benefits","Bonuses","Deductions","Loans","Pensions","Subscriptions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":7,"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":"Welcome","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Welcome to the Advanced HR Data Migration Templates."]
[]
[null,"Before populating your templates, please read our Data Migration Template overview and best practice Guide for more information."]

{"sheet":"Validation Format Example","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Character","Logic","Date","Numeric","Notes"]
[5,"TRUE/FALSE","DD/MM/YYYY","5,2",8000]
["Header","Header","Header","Header","Header"]
["a",true]
["aa",false,"01/01/1989","123.12"]
["bbb",null,"01/05/1920",".235"]
["cccccc",null,"1st Feb"]
[]
[null,null,null,null,"This line, has commas, that need, to be, removed"]

{"sheet":"Allowances","index":2,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Character","Numeric","Character","Logic","Character"]
[8,35,35,25,"DD/MM/YYYY","DD/MM/YYYY",7,"9,2",3,"TRUE/FALSE",8000]
["Employee ID","Surname","Forename","Type","Start Date","End Date","Frequency","Amount","Currency","Do Not Send to Payroll","Notes"]
["00000001",null,null,null,"DD/MM/YYYY","DD/MM/YYYY","Weekly"]
[null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,"Yearly"]

{"sheet":"Benefits","index":3,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Character","Character","Character","Character","Numeric","Character","Numeric","Numeric","Logic","Character"]
[8,35,35,25,"DD/MM/YYYY","DD/MM/YYYY",25,20,40,7,"9,2",3,"5,2","9,2"]
["Employee ID","Surname","Forename","Type","Start Date","End Date","Provider","Level of Cover","Reference Number","Frequency","Cost","Currency","Percentage to Employer","Annual Cost to Employer","Do not Send to Payroll","Notes"]
["00000001",null,null,null,"DD/MM/YYYY",null,null,null,null,"Weekly"]
[null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,"Yearly"]

{"sheet":"Bonuses","index":4,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Numeric","Numeric","Character","Logic","Character"]
[8,35,35,25,"DD/MM/YYYY","5,2","9,2",3]
["Employee ID","Surname","Forename","Type","Bonus Date","Percentage","Amount","Currency","Do not send to payroll","Notes"]
["00000001"]

{"sheet":"Deductions","index":5,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Character","Numeric","Character","Character","Logic","Character"]
[8,35,35,25,"DD/MM/YYYY","DD/MM/YYYY",7,"9,2",3,40]
["Employee ID","Surname","Forename","Type","Start Date","End Date","Frequency","Amount","Currency","Reference","Do not send to payroll","Notes"]
["00000001",null,null,null,"DD/MM/YYYY","DD/MM/YYYY","Weekly"]
[null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,"Yearly"]

{"sheet":"Loans","index":6,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Numeric","Date","Integer","Character","Character"]
[8,35,35,15,"DD/MM/YYYY","9,2","DD/MM/YYYY",null,3]
["Employee ID","Surname","Forename","Type","Date of Loan","Amount","First Repayment Due","Number of Repayments","Currency","Notes"]
["00000001",null,null,null,"DD/MM/YYYY",null,"DD/MM/YYYY"]

{"sheet":"Pensions","index":7,"n_rows":5,"n_cols":18,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Date","Date","Logic","Numeric","Character","Numeric","Character","Numeric","Character","Character","Character","Logic","Character"]
[8,35,35,30,40,"DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","9,2",1,"9,2",1,"9,2",1,3]
["Employee ID","Surname","Forename","Scheme","Policy Number Reference","Contribution Start Date","Contribution End Date","Left Scheme","Employee Contribution","Employee Contribution Type","Employer Contribution","Employer Contribution Type","AVC Contribution","AVC Contribution Type","Currency","Web Address","Do not send to payroll","Notes"]
["00000001",null,null,null,null,"DD/MM/YYYY","DD/MM/YYYY",true,null,"A",null,"A",null,"A"]
[null,null,null,null,null,null,null,false,null,"P",null,"P",null,"P"]

{"sheet":"Subscriptions","index":8,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Character","Character","Character","Numeric","Character","Numeric","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY",60,25,25,"9,2",11,"4,0"]
["Employee ID","Surname","Forename","Start Date","End Date","Professional Body","Membership Level","Membership Number","Cost","Frequency","Budget Year","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY",null,null,null,null,"Weekly"]
[null,null,null,null,null,null,null,null,null,"Fortnightly"]
[null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,"Bi-monthly"]
[null,null,null,null,null,null,null,null,null,"Quarterly"]
[null,null,null,null,null,null,null,null,null,"Half-yearly"]
[null,null,null,null,null,null,null,null,null,"Annually"]