{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ALL","Shift Schedule","Overtime","Attendance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"ALL","index":0,"n_rows":7,"n_cols":33,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,5,1],[0,8,1,26],[2,1,3,7],[2,8,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,27]]}
[null,null,null,null,null,null,null,null,"Ne  Mixing"]
[]
[null,"ALL",null,null,null,null,null,null,{"$f":"C5","v":"2019-08-20"},null,null,null,null,null,null,null,null,"TO",null,"19-",null,{"$f":"I3+20","v":"2019-09-09"}]
[]
["ID","NAME","2019-08-20",{"$f":"C5+1","v":"2019-08-21"},{"$f":"D5+1","v":"2019-08-22"},"2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
[null,null,{"$f":"C5","v":"2019-08-20"},{"$f":"D5","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
["ID","NAME","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"]

{"sheet":"Shift Schedule","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,33,5,33],[4,1,5,1],[4,0,5,0],[0,8,1,26],[2,1,3,7],[2,8,2,16],[2,19,2,20],[2,21,2,27],[2,17,2,18]]}
[null,null,null,null,null,null,null,null,"Ne  Mixing"]
[]
[null,"Shift Schedule",null,null,null,null,null,null,{"$f":"C5","v":"2019-08-20"},null,null,null,null,null,null,null,null,"TO",null,"19-",null,{"$f":"I3+20","v":"2019-09-09"}]
[]
["ID","NAME","2019-08-20",{"$f":"C5+1","v":"2019-08-21"},{"$f":"D5+1","v":"2019-08-22"},"2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19","OFF DAYS"]
[null,null,{"$f":"C5","v":"2019-08-20"},{"$f":"D5","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
["ID","NAME","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","OFF"]
[439,"TEST1",7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,{"$f":"COUNTIF($C8:$AG8,0)","v":10}]
[654,"TEST 2",7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,7,7,7,7,7,0,0,10]
[660,"TEST 3",0,0,19,23,23,23,23,0,0,19,23,23,23,23,0,0,19,19,19,19,19,0,0,19,19,19,19,19,0,0,19,10]
[1002,"TEST4",0,0,19,23,23,23,23,0,0,19,23,23,23,23,0,0,19,19,19,19,19,0,0,19,19,19,19,19,0,0,19,10]
[1004,"TEST5",19,0,0,15,15,15,15,19,0,0,15,15,15,15,15,0,0,7,7,7,7,19,0,0,7,7,7,7,19,0,0,10]

{"sheet":"Overtime","index":2,"n_rows":13,"n_cols":34,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,29,12,32],[4,1,5,1],[4,0,5,0],[4,33,5,33],[0,8,1,26],[2,1,3,7],[2,8,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,27]]}
[null,null,null,null,null,null,null,null,"Ne  Mixing"]
[]
[null,"Overtime",null,null,null,null,null,null,{"$f":"C5","v":"2019-08-20"},null,null,null,null,null,null,null,null,"TO",null,"19-",null,{"$f":"I3+20","v":"2019-09-09"}]
[]
["ID","NAME","2019-08-20",{"$f":"C5+1","v":"2019-08-21"},{"$f":"D5+1","v":"2019-08-22"},"2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19","Total"]
[null,null,{"$f":"C5","v":"2019-08-20"},{"$f":"D5","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
["0","NAME","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Total"]
[439,"TEST1",null,null,8,null,null,null,4,null,null,8,4,4,null,null,null,null,8,null,null,null,null,null,null,12,null,null,null,null,4,null,8,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":60}]
[654,"TEST 2",4,12,null,null,null,null,null,4,12,null,null,null,null,null,4,12,null,4,4,4,4,4,12,null,4,4,4,4,4,12,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":112}]
[660,"TEST 3",4,null,12,null,null,null,4,4,null,12,4,4,null,null,4,null,12,4,null,4,4,4,null,12,null,4,4,4,4,null,12,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":116}]
[1002,"TEST4",null,8,4,null,null,null,4,null,8,null,null,null,null,null,null,8,4,4,4,4,4,null,null,4,4,4,4,4,null,12,4,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":88}]
[1004,"TEST5",null,12,4,null,null,null,4,null,12,4,null,null,null,null,null,12,4,4,4,4,4,null,12,4,4,4,4,4,null,12,4,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":116}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUBTOTAL(109,AH$8:AH12)","v":492}]

{"sheet":"Attendance","index":3,"n_rows":12,"n_cols":33,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,1,5,1],[4,0,5,0],[0,8,1,26],[2,1,3,7],[2,8,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,27]]}
[null,null,null,null,null,null,null,null,"Ne  Mixing"]
[]
[null,"Attendance",null,null,null,null,null,null,{"$f":"C5","v":"2019-08-20"},null,null,null,null,null,null,null,null,"TO",null,"19-",null,{"$f":"I3+20","v":"2019-09-09"}]
[]
["ID","NAME","2019-08-20",{"$f":"C5+1","v":"2019-08-21"},{"$f":"D5+1","v":"2019-08-22"},"2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
[null,null,{"$f":"C5","v":"2019-08-20"},{"$f":"D5","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
["ID","NAME","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"]
[439,"TEST1",1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3]
[654,"TEST 2",1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3]
[660,"TEST 3",1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3]
[1002,"TEST4",1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3]
[1004,"TEST5",1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3,1,1,1,1,1,2,3]