{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ponto"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Ponto","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,5,5,6],[5,7,5,8]]}
[]
[null,"ANO",2021,null,null,null,null,"      Carga Horária",null,"08:00:00"]
[null,"MÊS",6,null,null,null,null,null,"Sábado","04:00:00"]
[null,"INÍCIO",1]
[]
[null,null,null,null,null,"Primeiro turno",null,"Segundo turno"]
[null,"Data","Dia Semana","FOLGAS","Feriados","Entrada","Saída","Entrada","Saída","H. Trab.","H. Normais","H. Extras"]
[null,{"$f":"DATE(C2,C3,C4)","v":"2021-06-01"},{"$f":"IF(B8=\"\",\"\",TEXT(B8,\"dddd\"))","v":"terça-feira"},{"$f":"IF(C8=\"domingo\",\"FOLGA\",\"\")","v":""},{"$f":"IF(B8=\"\",\"\",IF(VerificaSeFeriado(B8),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(B8=\"\",\"\",(I8-H8)+(G8-F8))","v":"00:00:00"},{"$f":"IF(E8=\"FERIADO\",0,IF(B8=\"\",\"\",IF(WEEKDAY(B8)=1,0,IF(WEEKDAY(B8)=7,MIN($J$3,J8),MIN($J$2,J8)))))","v":"00:00:00"},{"$f":"IF(E8=\"FERIADO\",J8,IF(B8=\"\",\"\",IF(WEEKDAY(B8)=1,J8,IF(WEEKDAY(B8)=7,MAX(0,J8-$J$3),MAX(0,J8-$J$2)))))","v":"00:00:00"}]
[null,{"$f":"B8+1","v":"2021-06-02"},{"$f":"IF(B9=\"\",\"\",TEXT(B9,\"dddd\"))","v":"quarta-feira"},{"$f":"IF(C9=\"domingo\",\"FOLGA\",\"\")","v":""},{"$f":"IF(B9=\"\",\"\",IF(VerificaSeFeriado(B9),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(B9=\"\",\"\",(I9-H9)+(G9-F9))","v":"00:00:00"},{"$f":"IF(E9=\"FERIADO\",0,IF(B9=\"\",\"\",IF(WEEKDAY(B9)=1,0,IF(WEEKDAY(B9)=7,MIN($J$3,J9),MIN($J$2,J9)))))","v":"00:00:00"},{"$f":"IF(E9=\"FERIADO\",J9,IF(B9=\"\",\"\",IF(WEEKDAY(B9)=1,J9,IF(WEEKDAY(B9)=7,MAX(0,J9-$J$3),MAX(0,J9-$J$2)))))","v":"00:00:00"}]
[null,{"$f":"B9+1","v":"2021-06-03"},"quinta-feira","",{"$f":"IF(B10=\"\",\"\",IF(VerificaSeFeriado(B10),\"FERIADO\",\"\"))","v":"FERIADO"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(E10=\"FERIADO\",J10,IF(B10=\"\",\"\",IF(WEEKDAY(B10)=1,J10,IF(WEEKDAY(B10)=7,MAX(0,J10-$J$3),MAX(0,J10-$J$2)))))","v":"00:00:00"}]
[null,"2021-06-04","sexta-feira","",{"$f":"IF(B11=\"\",\"\",IF(VerificaSeFeriado(B11),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-05","sábado","",{"$f":"IF(B12=\"\",\"\",IF(VerificaSeFeriado(B12),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-06","domingo","FOLGA",{"$f":"IF(B13=\"\",\"\",IF(VerificaSeFeriado(B13),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-07","segunda-feira","",{"$f":"IF(B14=\"\",\"\",IF(VerificaSeFeriado(B14),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-08","terça-feira","",{"$f":"IF(B15=\"\",\"\",IF(VerificaSeFeriado(B15),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-09","quarta-feira","",{"$f":"IF(B16=\"\",\"\",IF(VerificaSeFeriado(B16),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-10","quinta-feira","",{"$f":"IF(B17=\"\",\"\",IF(VerificaSeFeriado(B17),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-11","sexta-feira","",{"$f":"IF(B18=\"\",\"\",IF(VerificaSeFeriado(B18),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-12","sábado","",{"$f":"IF(B19=\"\",\"\",IF(VerificaSeFeriado(B19),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-13","domingo","FOLGA",{"$f":"IF(B20=\"\",\"\",IF(VerificaSeFeriado(B20),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-14","segunda-feira","",{"$f":"IF(B21=\"\",\"\",IF(VerificaSeFeriado(B21),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-15","terça-feira","",{"$f":"IF(B22=\"\",\"\",IF(VerificaSeFeriado(B22),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-16","quarta-feira","",{"$f":"IF(B23=\"\",\"\",IF(VerificaSeFeriado(B23),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-17","quinta-feira","",{"$f":"IF(B24=\"\",\"\",IF(VerificaSeFeriado(B24),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-18","sexta-feira","",{"$f":"IF(B25=\"\",\"\",IF(VerificaSeFeriado(B25),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-19","sábado","",{"$f":"IF(B26=\"\",\"\",IF(VerificaSeFeriado(B26),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-20","domingo","FOLGA",{"$f":"IF(B27=\"\",\"\",IF(VerificaSeFeriado(B27),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-21","segunda-feira","",{"$f":"IF(B28=\"\",\"\",IF(VerificaSeFeriado(B28),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-22","terça-feira","",{"$f":"IF(B29=\"\",\"\",IF(VerificaSeFeriado(B29),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-23","quarta-feira","",{"$f":"IF(B30=\"\",\"\",IF(VerificaSeFeriado(B30),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-24","quinta-feira","",{"$f":"IF(B31=\"\",\"\",IF(VerificaSeFeriado(B31),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-25","sexta-feira","",{"$f":"IF(B32=\"\",\"\",IF(VerificaSeFeriado(B32),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-26","sábado","",{"$f":"IF(B33=\"\",\"\",IF(VerificaSeFeriado(B33),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-27","domingo","FOLGA",{"$f":"IF(B34=\"\",\"\",IF(VerificaSeFeriado(B34),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"2021-06-28","segunda-feira","",{"$f":"IF(B35=\"\",\"\",IF(VerificaSeFeriado(B35),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,{"$f":"IF(B35=\"\",\"\",IF(MONTH(B35+1)<>MONTH(B35),\"\",B35+1))","v":"2021-06-29"},{"$f":"IF(B36=\"\",\"\",TEXT(B36,\"dddd\"))","v":"terça-feira"},"",{"$f":"IF(B36=\"\",\"\",IF(VerificaSeFeriado(B36),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,{"$f":"IF(B36=\"\",\"\",IF(MONTH(B36+1)<>MONTH(B36),\"\",B36+1))","v":"2021-06-30"},"quarta-feira","",{"$f":"IF(B37=\"\",\"\",IF(VerificaSeFeriado(B37),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,{"$f":"IF(B37=\"\",\"\",IF(MONTH(B37+1)<>MONTH(B37),\"\",B37+1))","v":""},"","",{"$f":"IF(B38=\"\",\"\",IF(VerificaSeFeriado(B38),\"FERIADO\",\"\"))","v":""},"00:00:00","00:00:00","00:00:00","00:00:00","","",""]