{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Control","Config","Notes","Data","Errors"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"Control","index":0,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,5,3,12],[9,2,9,5],[12,2,12,5],[9,8,9,10],[10,8,10,10],[11,8,11,10]]}
[null,"Data Checking Toolkit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v0.1",null,{"$f":"NOW()","v":"2021-06-16T14:57:51.920"}]
[]
[]
[null,null,"Filename & Version:"]
[]
[null,null,"Number of Columns:",null,null,{"$f":"COUNTA(Data!1:1)","v":0},null,"Checked:",null,0,null,"Errors:",0]
[null,null,"Number of Rows:",null,null,{"$f":"COUNTA(Data!A:A)","v":0}]
[]
[null,null,"Options:"]
[null,null,"Check entire report",null,null,null,null,"Start:","00:00:00"]
[null,null,null,null,null,18,null,"End:","00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,"Complete full check"]
[]
[]
[null,null,{"$f":"Config!B1","v":"EMPLOYEE_NUMBER"},{"$f":"Config!C1","v":"AS_OF_DATE"},{"$f":"Config!D1","v":"SEQUENCE_"},{"$f":"Config!E1","v":"ENTRY_TYPE"},{"$f":"Config!F1","v":"ENTRY_REASON"},{"$f":"Config!G1","v":"STATUS"},{"$f":"Config!H1","v":"JOB_ROLE"},{"$f":"Config!I1","v":0},{"$f":"Config!J1","v":0},{"$f":"Config!K1","v":0},{"$f":"Config!L1","v":0},{"$f":"Config!M1","v":0},{"$f":"Config!N1","v":0},{"$f":"Config!O1","v":0},{"$f":"Config!P1","v":0},{"$f":"Config!Q1","v":0}]
[null,null,{"$f":"Config!R1","v":0},{"$f":"Config!S1","v":0},{"$f":"Config!T1","v":0},{"$f":"Config!U1","v":0},{"$f":"Config!V1","v":0},{"$f":"Config!W1","v":0},{"$f":"Config!X1","v":0},{"$f":"Config!Y1","v":0},{"$f":"Config!Z1","v":0},{"$f":"Config!AA1","v":0},{"$f":"Config!AB1","v":0},{"$f":"Config!AC1","v":0},{"$f":"Config!AD1","v":0},{"$f":"Config!AE1","v":0},{"$f":"Config!AF1","v":0},{"$f":"Config!AG1","v":0}]
[null,null,{"$f":"Config!AH1","v":0},{"$f":"Config!AI1","v":0},{"$f":"Config!AJ1","v":0},{"$f":"Config!AK1","v":0},{"$f":"Config!AL1","v":0},{"$f":"Config!AM1","v":0},{"$f":"Config!AN1","v":0},{"$f":"Config!AO1","v":0},{"$f":"Config!AP1","v":0},{"$f":"Config!AQ1","v":0},{"$f":"Config!AR1","v":0},{"$f":"Config!AS1","v":0},{"$f":"Config!AT1","v":0},{"$f":"Config!AU1","v":0},{"$f":"Config!AV1","v":0},{"$f":"Config!AW1","v":0}]
[null,null,{"$f":"Config!AX1","v":0},{"$f":"Config!AY1","v":0},{"$f":"Config!AZ1","v":0},{"$f":"Config!BA1","v":0},{"$f":"Config!BB1","v":0},{"$f":"Config!BC1","v":0},{"$f":"Config!BD1","v":0},{"$f":"Config!BE1","v":0},{"$f":"Config!BF1","v":0},{"$f":"Config!BG1","v":0},{"$f":"Config!BH1","v":0},{"$f":"Config!BI1","v":0},{"$f":"Config!BJ1","v":0},{"$f":"Config!BK1","v":0},{"$f":"Config!BL1","v":0},{"$f":"Config!BM1","v":0}]
[null,null,{"$f":"Config!BN1","v":0},{"$f":"Config!BO1","v":0},{"$f":"Config!BP1","v":0},{"$f":"Config!BQ1","v":0},{"$f":"Config!BR1","v":0},{"$f":"Config!BS1","v":0},{"$f":"Config!BT1","v":0},{"$f":"Config!BU1","v":0},{"$f":"Config!BV1","v":0},{"$f":"Config!BW1","v":0},{"$f":"Config!BX1","v":0},{"$f":"Config!BY1","v":0},{"$f":"Config!BZ1","v":0},{"$f":"Config!CA1","v":0},{"$f":"Config!CB1","v":0},{"$f":"Config!CC1","v":0}]
[null,null,{"$f":"Config!CD1","v":0},{"$f":"Config!CE1","v":0},{"$f":"Config!CF1","v":0},{"$f":"Config!CG1","v":0},{"$f":"Config!CH1","v":0},{"$f":"Config!CI1","v":0},{"$f":"Config!CJ1","v":0},{"$f":"Config!CK1","v":0},{"$f":"Config!CL1","v":0},{"$f":"Config!CM1","v":0},{"$f":"Config!CN1","v":0},{"$f":"Config!CO1","v":0},{"$f":"Config!CP1","v":0},{"$f":"Config!CQ1","v":0},{"$f":"Config!CR1","v":0},{"$f":"Config!CS1","v":0}]

{"sheet":"Config","index":1,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Field","EMPLOYEE_NUMBER","AS_OF_DATE","SEQUENCE_","ENTRY_TYPE","ENTRY_REASON","STATUS","JOB_ROLE"]
["Required?","Y","Y","Y","Y","N","Y","Y"]
["TYPE","Long","Date","LOV","LOV","LOV-Sub","LOV","LOV"]
["Notes",99999999,"yyyy-mm-dd",null,null,-1]
["Start row"]
["EndRow"]
["LOVs",null,null,0,"Promotion","Hourly to Hourly","Active","Customer Service Assistant"]
[null,null,null,1,"Promotion","Hourly to Salaried","Inactive","Assistant Manager"]
[null,null,null,2,"Promotion","Salaried to Salaried","Pending","Administrator"]
[null,null,null,3,"Demotion","Disciplinary Sanction - Hourly to Hourly",null,"Security"]
[null,null,null,4,"Demotion","Disciplinary Sanction - Salaried to Hourly",null,"Shift Leader"]
[null,null,null,null,"Demotion","Disciplinary Sanction - Salaried to Salaried",null,"Maintenance"]
[null,null,null,null,"Demotion","Employee Request - Hourly to Hourly\n",null,"Trainee Manager"]
[null,null,null,null,"Demotion","Employee Request - Salaried to Hourly\n",null,"Unit Manager"]
[null,null,null,null,"Demotion","Employee Request - Salaried to Salaried\n",null,"Regional Manager"]
[null,null,null,null,"Hire","New Hire",null,"Operations Director"]
[null,null,null,null,"Hire","Rehire",null,"VP Operations"]
[null,null,null,null,"Pay Change","Merit Rise",null,"Managing Director"]
[null,null,null,null,"Pay Change","Scale Change",null,"Senior Vice President"]
[null,null,null,null,"Pay Change","Annual Review",null,"Vice President"]
[null,null,null,null,"Pay Change","Change to Flexible Working",null,"Director"]
[null,null,null,null,"Pay Change","Salary Adjustment",null,"Head of Department"]
[null,null,null,null,"Change of Hours","New Minimum Hours Contract",null,"Manager"]
[null,null,null,null,"Change of Hours","Flexible Working",null,"Consultant"]
[null,null,null,null,"Leave of Absence","Adoption Leave",null,"Specialist"]
[null,null,null,null,"Leave of Absence","Bereavement Leave",null,"Analyst"]
[null,null,null,null,"Leave of Absence","Career Break",null,"Officer"]
[null,null,null,null,"Leave of Absence","Compassionate Leave",null,"Assistant"]
[null,null,null,null,"Leave of Absence","Jury Leave",null,"Co-ordinator"]
[null,null,null,null,"Leave of Absence","Long Term Sick",null,"Administrator"]
[null,null,null,null,"Leave of Absence","Maternity Leave",null,"Assistant Manager"]
[null,null,null,null,"Leave of Absence","Military Service",null,"Staff"]
[null,null,null,null,"Leave of Absence","Not eligible to work"]
[null,null,null,null,"Leave of Absence","Parental Leave"]
[null,null,null,null,"Leave of Absence","Paternity Leave"]
[null,null,null,null,"Leave of Absence","Personal Leave"]
[null,null,null,null,"Leave of Absence","Sabbatical"]
[null,null,null,null,"Leave of Absence","Shared Parental Leave"]
[null,null,null,null,"Return from Leave of Absence"]
[null,null,null,null,"Termination","Non-Starter"]
[null,null,null,null,"Termination","Resignation - Dissatisfaction"]
[null,null,null,null,"Termination","Resignation - Other"]
[null,null,null,null,"Termination","Dismissal"]
[null,null,null,null,"Termination","Health Reasons"]
[null,null,null,null,"Termination","Redundancy"]
[null,null,null,null,"Termination","Transfer to other organisation"]
[null,null,null,null,"Termination","Miscellaneous"]
[null,null,null,null,"Secondment"]
[null,null,null,null,"Transfer"]
[null,null,null,null,"Lateral Move"]
[null,null,null,null,"Contract Change"]

{"sheet":"Notes","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,"SubLOV - add a column ref no of columns left for offset"]
[null,"Check in data rec file"]

{"sheet":"Data","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Errors","index":4,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Ref","Employee No","Value","Description","Mandatory","Format / Limit"]