{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Home","Collated Data"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":5,"n_cols":5,"rows_kept":5,"merged":[[4,4,5,14]]}
[]
[]
[]
[]
[{"$nulls":4},"Fully Automated Data Collator (VBA)"]

{"sheet":"Collated Data","index":1,"n_rows":41,"n_cols":12,"rows_kept":41}
["File Name","Employee ID","Employee Name","Gender","DOB","Country","City","DOJ","Supervisor","Department","Salary","Status"]
["File -1.xlsx",1,"Employee 1","Male","1994-01-19","India","City1","1992-12-09","Sup1","Training",27613,"Active"]
["File -1.xlsx",2,"Employee 2","Male","2013-04-29","India","City2","2002-07-04","Sup2","Training",61351,"Inactive"]
["File -1.xlsx",3,"Employee 3","Female","2017-11-26","India","City3","2003-08-08","Sup3","Training",26175,"Active"]
["File -1.xlsx",4,"Employee 4","Female","2005-06-15","Nepal","City4","2011-04-09","Sup4","Training",79840,"Active"]
["File -1.xlsx",5,"Employee 5","Male","2002-04-20","Pakistan","City5","1988-09-01","Sup5","Operation",32964,"Active"]
["File -1.xlsx",6,"Employee 6","Male","2015-10-13","Pakistan","City6","2015-04-03","Sup6","Operation",27808,"Inactive"]
["File -1.xlsx",7,"Employee 7","Female","2016-09-18","Pakistan","City7","2006-04-16","Sup7","Operation",63191,"Active"]
["File -1.xlsx",8,"Employee 8","Female","1997-12-27","Bhutan","City8","1996-08-03","Sup8","Operation",52877,"Active"]
["File -1.xlsx",9,"Employee 9","Male","2016-02-27","Bhutan","City9","2008-01-16","Sup9","Quality",52612,"Inactive"]
["File -1.xlsx",10,"Employee 10","Male","2007-11-01","China","City10","1998-10-09","Sup10","Research",33104,"Inactive"]
["File -2.xlsx",11,"Employee 11","Male","1994-01-19","India","City1","1992-12-09","Sup1","Training",27613,"Active"]
["File -2.xlsx",12,"Employee 12","Male","2013-04-29","India","City2","2002-07-04","Sup2","Training",61351,"Inactive"]
["File -2.xlsx",13,"Employee 13","Female","2017-11-26","India","City3","2003-08-08","Sup3","Training",26175,"Active"]
["File -2.xlsx",14,"Employee 14","Female","2005-06-15","Nepal","City4","2011-04-09","Sup4","Training",79840,"Active"]
["File -2.xlsx",15,"Employee 15","Male","2002-04-20","Pakistan","City5","1988-09-01","Sup5","Operation",32964,"Active"]
["File -2.xlsx",16,"Employee 16","Male","2015-10-13","Pakistan","City6","2015-04-03","Sup6","Operation",27808,"Inactive"]
["File -2.xlsx",17,"Employee 17","Female","2016-09-18","Pakistan","City7","2006-04-16","Sup7","Operation",63191,"Active"]
["File -2.xlsx",18,"Employee 18","Female","1997-12-27","Bhutan","City8","1996-08-03","Sup8","Operation",52877,"Active"]
["File -2.xlsx",19,"Employee 19","Male","2016-02-27","Bhutan","City9","2008-01-16","Sup9","Quality",52612,"Inactive"]
["File -2.xlsx",20,"Employee 20","Male","2007-11-01","China","City10","1998-10-09","Sup10","Research",33104,"Inactive"]
["File -3.xlsx",21,"Employee 21","Male","1994-01-19","India","City1","1992-12-09","Sup1","Training",27613,"Active"]
["File -3.xlsx",22,"Employee 22","Male","2013-04-29","India","City2","2002-07-04","Sup2","Training",61351,"Inactive"]
["File -3.xlsx",23,"Employee 23","Female","2017-11-26","India","City3","2003-08-08","Sup3","Training",26175,"Active"]
["File -3.xlsx",24,"Employee 24","Female","2005-06-15","Nepal","City4","2011-04-09","Sup4","Training",79840,"Active"]
["File -3.xlsx",25,"Employee 25","Male","2002-04-20","Pakistan","City5","1988-09-01","Sup5","Operation",32964,"Active"]
["File -3.xlsx",26,"Employee 26","Male","2015-10-13","Pakistan","City6","2015-04-03","Sup6","Operation",27808,"Inactive"]
["File -3.xlsx",27,"Employee 27","Female","2016-09-18","Pakistan","City7","2006-04-16","Sup7","Operation",63191,"Active"]
["File -3.xlsx",28,"Employee 28","Female","1997-12-27","Bhutan","City8","1996-08-03","Sup8","Operation",52877,"Active"]
["File -3.xlsx",29,"Employee 29","Male","2016-02-27","Bhutan","City9","2008-01-16","Sup9","Quality",52612,"Inactive"]
["File -3.xlsx",30,"Employee 30","Male","2007-11-01","China","City10","1998-10-09","Sup10","Research",33104,"Inactive"]
["File -4.xlsx",31,"Employee 31","Male","1994-01-19","India","City1","1992-12-09","Sup1","Training",27613,"Active"]
["File -4.xlsx",32,"Employee 32","Male","2013-04-29","India","City2","2002-07-04","Sup2","Training",61351,"Inactive"]
["File -4.xlsx",33,"Employee 33","Female","2017-11-26","India","City3","2003-08-08","Sup3","Training",26175,"Active"]
["File -4.xlsx",34,"Employee 34","Female","2005-06-15","Nepal","City4","2011-04-09","Sup4","Training",79840,"Active"]
["File -4.xlsx",35,"Employee 35","Male","2002-04-20","Pakistan","City5","1988-09-01","Sup5","Operation",32964,"Active"]
["File -4.xlsx",36,"Employee 36","Male","2015-10-13","Pakistan","City6","2015-04-03","Sup6","Operation",27808,"Inactive"]
["File -4.xlsx",37,"Employee 37","Female","2016-09-18","Pakistan","City7","2006-04-16","Sup7","Operation",63191,"Active"]
["File -4.xlsx",38,"Employee 38","Female","1997-12-27","Bhutan","City8","1996-08-03","Sup8","Operation",52877,"Active"]
["File -4.xlsx",39,"Employee 39","Male","2016-02-27","Bhutan","City9","2008-01-16","Sup9","Quality",52612,"Inactive"]
["File -4.xlsx",40,"Employee 40","Male","2007-11-01","China","City10","1998-10-09","Sup10","Research",33104,"Inactive"]