{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Welcome","Validation Format Example","Divison","Department","Location","Job Title Table","Grade","Cost Centre"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":6,"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":"Divison","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Character","Character"]
[40,4]
["Division","Payroll Code"]

{"sheet":"Department","index":3,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character"]
[40,4,250]
["Department","Payroll Code","Leave Representative email"]

{"sheet":"Location","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Character","Character"]
[40,9]
["Location","Payroll Code"]

{"sheet":"Job Title Table","index":5,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Logic","Numeric","Logic"]
[40,13,"TRUE/FALSE","6,2","TRUE/FALSE"]
["Job Title","Payroll Code","Is Managerial Role","Base Leave Entitlement","Is Restircted Role"]
[null,null,true,null,true]
[null,null,false,null,false]

{"sheet":"Grade","index":6,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Numeric","Numeric","Numeric"]
[6,40,"9,2","9,2","6,2"]
["Grade","Description","Salary from","Salary to","Base Entitlement"]

{"sheet":"Cost Centre","index":7,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Character","Character"]
[15,40]
["Cost Centre","Description"]