{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Shift Schedule","Overtime","Attendance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Shift Schedule","index":1,"n_rows":21,"n_cols":34,"rows_kept":21,"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," 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"]
[41,"Test41",8,0,0,8,8,8,25,25,0,0,25,25,25,25,25,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,{"$f":"COUNTIF($C8:$AG8,0)","v":10}]
[83,"Test83",8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,8,8,8,8,8,0,0,10]
[85,"Test85",6,0,0,14,14,14,14,0,0,18,22,22,22,22,18,0,0,14,14,14,14,6,0,0,14,14,14,14,0,0,6,10]
[209,"Test209",6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,18,22,22,22,22,18,0,0,22,22,22,22,18,0,0,10]
[533,"Test533",22,0,0,14,14,14,14,14,0,0,6,6,6,6,6,0,0,22,22,22,22,22,0,0,14,14,14,14,14,0,0,10]
[542,"Test542",18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,{"$f":"COUNTIF($C13:$AG13,0)","v":10}]
[544,"Test544",6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,10]
[567,"Test567",0,0,6,6,6,6,6,6,0,0,6,6,6,6,6,0,0,6,6,6,6,0,0,6,6,6,6,6,6,0,0,10]
[704,"Test704",0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,10]
[884,"Test884",18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,10]
[1293,"Test1293",6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,10]
[1302,"Test1302",6,0,0,22,22,22,22,22,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,10]
[1309,"Test1309",0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,10]
[1315,"Test1315",0,0,6,6,6,6,6,6,0,0,22,22,22,22,18,0,0,14,14,14,14,0,0,6,6,6,6,6,6,0,0,10]

{"sheet":"Overtime","index":2,"n_rows":22,"n_cols":42,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,29,21,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," Mixing ",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,null,null,{"$f":"MAX(AH11:AH21)","v":88},"Operation Manager"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Approval                          Operation Manager"]
[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"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO1>79,AP2,AP1)","v":"Approval                          Operation Manager"}]
[]
["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"]
[41,"Test41",null,null,8,null,null,null,null,null,null,8,null,null,null,null,null,null,8,null,null,null,null,null,null,8,2,null,null,null,null,null,8,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":42}]
[83,"Test83",4,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,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":4}]
[85,"Test85",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,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":0}]
[209,"Test209",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,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":0}]
[533,"Test533",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,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":0}]
[542,"Test542",null,12,null,null,null,null,null,4,null,12,null,null,null,null,4,12,null,null,null,null,null,null,12,4,null,12,null,null,null,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":72}]
[544,"Test544",null,12,4,null,null,null,null,4,null,12,null,null,null,null,4,12,null,null,null,null,null,null,12,4,null,null,null,null,null,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":64}]
[567,"Test567",4,12,null,null,null,null,null,null,12,4,null,null,null,null,4,null,12,null,null,null,null,4,12,null,null,null,null,8,12,null,4,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":88}]
[704,"Test704",4,null,12,null,null,null,null,4,null,null,null,null,null,null,null,null,4,null,null,null,null,4,null,12,null,null,null,null,4,12,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":56}]
[884,"Test884",4,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,4,null,12,null,null,null,null,4,12,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":52}]
[1293,"Test1293",null,12,4,null,null,null,null,4,null,8,null,null,null,null,4,12,null,null,null,null,null,null,12,4,null,null,null,null,4,null,12,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":76}]
[1302,"Test1302",null,null,4,null,null,null,null,4,null,12,null,null,null,null,4,12,null,8,null,null,null,null,8,4,null,null,null,null,null,null,12,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":68}]
[1309,"Test1309",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,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":0}]
[1315,"Test1315",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,null,null,{"$f":"SUM(HR_2[[#This Row],[1]:[31]])","v":0}]
[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:AH21)","v":522}]

{"sheet":"Attendance","index":3,"n_rows":21,"n_cols":33,"rows_kept":21,"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," 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"]
[41,"Test41",1,2,3,1,1,1,7,7,2,3,7,7,7,7,7,2,3,1,1,1,1,4,2,3,1,1,1,1,1,2,3]
[83,"Test83",1,3,2,1,1,1,1,1,3,2,1,1,1,1,1,2,3,1,1,1,1,1,3,2,1,1,1,1,1,3,2]
[85,"Test85",1,2,3,1,1,1,1,2,3,4,1,1,1,1,1,3,2,5,1,1,1,1,2,3,1,1,1,1,2,3,1]
[209,"Test209"]
[533,"Test533"]
[542,"Test542"]
[544,"Test544"]
[567,"Test567"]
[704,"Test704"]
[884,"Test884"]
[1293,"Test1293"]
[1302,"Test1302"]
[1309,"Test1309"]
[1315,"Test1315"]