{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Shift Schedule","HR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Shift Schedule","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,33,5,33],[0,2,1,23],[2,1,3,7],[2,8,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,27]]}
[null,null,"TEST HR"]
[]
[null,"Shift Schedule",null,null,null,null,null,null,{"$f":"C5","v":"2020-08-20"},null,null,null,null,null,null,null,null,"TO",null,"19-",null,{"$f":"I3+20","v":"2020-09-09"}]
[]
["ID","NAME","2020-08-20",{"$f":"C5+1","v":"2020-08-21"},{"$f":"D5+1","v":"2020-08-22"},"2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","OFF DAYS"]
[null,null,{"$f":"C5","v":"2020-08-20"},{"$f":"D5","v":"2020-08-21"},"2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-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"]
[1122,"First employee",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,7,7,7,7,7,0,{"$f":"COUNTIF(C8:AG8,0)","v":9}]
[1133,"Second employee",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,8,8,8,8,8,0,9]
[1144,"Third employee",9,9,0,0,9,9,9,9,9,0,0,9,9,9,9,9,0,0,9,9,9,9,9,0,0,9,9,9,9,9,0,{"$f":"COUNTIF(C10:AG10,0)","v":9}]
[1155,"Fourth employee",10,10,0,0,10,10,10,10,10,0,0,10,10,10,10,10,0,0,10,10,10,10,10,0,0,10,10,10,10,10,0,{"$f":"COUNTIF(C11:AG11,0)","v":9}]
[1166,"Fifth employee",15,15,0,0,15,15,15,15,15,0,0,15,15,15,15,15,0,0,15,15,15,15,15,0,0,15,15,15,15,15,0,{"$f":"COUNTIF(C12:AG12,0)","v":9}]

{"sheet":"HR","index":1,"n_rows":22,"n_cols":34,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,5,1],[4,33,5,33],[0,2,1,23],[2,1,3,7],[2,8,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,27]]}
[{"$f":"B3&\" - \"&TEXT(V3,\"mmmm-yyyy\")&\" - \"&A8","v":"Shift Schedule - September-2020 - "},null,{"$f":"'Shift Schedule'!C1","v":"TEST HR"}]
[]
[null,"Shift Schedule",null,null,null,null,null,null,{"$f":"C5","v":"2020-08-20"},null,null,null,null,null,null,null,null,"TO",null,"19-",null,{"$f":"I3+20","v":"2020-09-09"}]
[]
["ID","NAME",{"$f":"'Shift Schedule'!C5","v":"2020-08-20"},{"$f":"C5+1","v":"2020-08-21"},{"$f":"D5+1","v":"2020-08-22"},"2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","OFF DAYS"]
[null,null,{"$f":"C5","v":"2020-08-20"},{"$f":"D5","v":"2020-08-21"},"2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19"]
["02002","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"]
[null,{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(B$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(C$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(D$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(E$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(F$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(G$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(H$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(I$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(J$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(K$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(L$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(M$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(N$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(O$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(P$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(Q$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(R$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(S$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(T$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(U$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(V$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(W$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(X$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(Y$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(Z$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AA$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AB$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AC$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AD$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AE$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AF$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Shift Schedule'!$A$5:$AG$12,MATCH($A8,'Shift Schedule'!$A$5:$A$12,0),MATCH(AG$5,'Shift Schedule'!$A$5:$AG$5,0))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Test@test.com"]