{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Outubro","Novembro","Dezembro","Janeiro","Fevereiro","Março","Feriados"],"not_rendered":{"images":1,"macros":1,"defined_names":21,"comments":6},"read":"whole","date_system":"1900"}

{"sheet":"Outubro","index":0,"n_rows":131,"n_cols":31,"rows_kept":131,"merged":[[1,7,2,7],[1,18,3,18],[4,1,4,2],[4,22,5,23],[5,25,5,30],[6,1,6,2],[16,22,16,23],[19,22,19,23],[41,14,41,15]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH($W$117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Outubro"}]
[]
[]
[]
[null,"Empregado :",null,"Alexandre José de Souza Silva",{"$nulls":4},"Setor :",{"$nulls":5},"Unidade  :",{"$nulls":7},"JORNADA CONTRATUAL"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências In-justificadas","Compen-sadas","H. Extras","HE 100%",{"$nulls":5},"CARTÃO PONTO ESPELHO"]
[null,"Saldo anterior",{"$nulls":20},"Dia da Semana","Jornada",null,"Entrada","Saída","Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":1},{"$f":"inicio","v":"2023-10-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2023-10-01"},{"$nulls":7},{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))+IF(AND(G8=\"\",H8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC8+(AB8>AC8)))-MAX(ININOT,AB8)+(MIN(FIMNOT,AC8+(AB8>AC8))-MIN(FIMNOT,AB8)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE8+(AD8>AE8)))-MAX(ININOT,AD8)+(MIN(FIMNOT,AE8+(AD8>AE8))-MIN(FIMNOT,AD8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((AA8-Z8)+(AC8-AB8)+(AE8-AD8),1)+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$X$16,VLOOKUP(A8,jornada,3)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(O8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(O8<P8,P8-O8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),MAX(0,O8-P8),IF(P8=0,0,MAX(0,O8-P8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),0,IF(P8=0,O8,0)))","v":"00:00:00"},null,1,"domingo","00:00:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":2},{"$f":"B8+1","v":"2023-10-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2023-10-02"},null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1600,"d":"16:00"},{"v":1630,"d":"16:30"},{"v":1930,"d":"19:30"},{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"10:00:00.288"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((AA9-Z9)+(AC9-AB9)+(AE9-AD9),1)+M9)","v":"10:00:00"},"08:48:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(O9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(O9<P9,P9-O9,\"\"))))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"01:12:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","08:48:00",null,{"$f":"IF(B9=\"\",\"\",IF($E9=\"\",0,TIME(INT(E9/100),MOD(E9,100),0)))","v":"08:00:00"},{"$f":"IF(B9=\"\",\"\",IF($F9=\"\",0,TIME(INT(F9/100),MOD(F9,100),0)))","v":"12:00:00"},{"$f":"IF(B9=\"\",\"\",IF($G9=\"\",0,TIME(INT(G9/100),MOD(G9,100),0)))","v":"13:00:00"},{"$f":"IF(B9=\"\",\"\",IF($H9=\"\",0,TIME(INT(H9/100),MOD(H9,100),0)))","v":"16:00:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"16:30:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"19:30:00"}]
[3,{"$f":"B9+1","v":"2023-10-03"},"2023-10-03",null,{"v":2200,"d":"22:00"},{"v":200,"d":"02:00"},{"v":200,"d":"02:00"},{"v":500,"d":"05:00"},null,null,"00:00:00","07:00:00","01:00:00","08:00:00","08:00:00","08:48:00","","00:48:00",{"$f":"IF(B10=\"\",\"\",IF(AND(WEEKDAY(B10,1)=7,P10=0,D10<>\"F\"),MAX(0,O10-P10),IF(P10=0,0,MAX(0,O10-P10))))","v":"00:00:00"},"00:00:00",null,3,"Terça-feira","08:48:00",null,"22:00:00","02:00:00","02:00:00","05:00:00","00:00:00","00:00:00"]
[4,{"$f":"B10+1","v":"2023-10-04"},"2023-10-04",null,{"v":1200,"d":"12:00"},{"v":1800,"d":"18:00"},{"v":1900,"d":"19:00"},{"v":2300,"d":"23:00"},null,null,"09:00:00","01:00:00","00:08:34.286","01:08:34.286","10:08:34.286","08:48:00","","","01:20:34.286","00:00:00",null,4,"Quarta-feira","08:48:00",null,"12:00:00","18:00:00","19:00:00","23:00:00","00:00:00","00:00:00"]
[5,{"$f":"B11+1","v":"2023-10-05"},"2023-10-05",null,{"v":1200,"d":"12:00"},{"v":1800,"d":"18:00"},{"$nulls":4},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","08:48:00","","02:48:00","00:00:00","00:00:00",null,5,"Quinta-feira","08:48:00",null,"12:00:00","18:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,{"$f":"B12+1","v":"2023-10-06"},"2023-10-06",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,6,"Sexta-feira","08:48:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-10-07","2023-10-07",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,7,"Sábado","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2023-10-08","2023-10-08",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,8,"Feriados","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2023-10-09","2023-10-09",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2023-10-10","2023-10-10",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2023-10-11","2023-10-11",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Início","22:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[8,"2023-10-12","feriado",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,null,"Término","05:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-10-13","2023-10-13",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-10-14","2023-10-14",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2023-10-15","2023-10-15",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,null,"Selecione o ano :",2023,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2023-10-16","2023-10-16",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Selecione o mês :",10,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2023-10-17","2023-10-17",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2023-10-18","2023-10-18",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Adicional Noturno:",{"$f":"N39","v":0.38095238095238104},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2023-10-19","2023-10-19",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Horas Trabalhadas:",{"$f":"O39","v":1.422619047619048},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-10-20","2023-10-20",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"Q39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-10-21","2023-10-21",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,null,"Horas Compensadas:",{"$f":"R39","v":6.383333333333336},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2023-10-22","2023-10-22",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"S39","v":0.10595238095238102},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2023-10-23","2023-10-23",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"T39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2023-10-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2023-10-24"},{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2023-10-25","2023-10-25",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",null,null,{"$f":"IF(X28-X29=0,0,(IF(X28-X29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(X28-X29<0,(X28*-1)-(X29*-1),X28-X29)","v":6.277380952380955},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2023-10-26","2023-10-26",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-10-27","2023-10-27",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-10-28","2023-10-28",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2023-10-29"},"2023-10-29",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2023-10-30"},"2023-10-30",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:48:00","","08:48:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":"2023-10-31"},"2023-10-31",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(B38=\"\",\"\",MOD((AA38-Z38)+(AC38-AB38)+(AE38-AD38),1)+M38)","v":"00:00:00"},"08:48:00","","08:48:00",{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38<>\"F\"),MAX(0,O38-P38),IF(P38=0,0,MAX(0,O38-P38))))","v":"00:00:00"},{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38=\"F\"),0,IF(P38=0,O38,0)))","v":"00:00:00"},{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":0.38095238095238104},{"$f":"SUM(O8:O38)","v":1.422619047619048},"Total:",{"$f":"SUM(Q8:Q38)","v":0},{"$f":"SUM(R7:R38)","v":6.383333333333336},{"$f":"SUM(S7:S38)","v":0.10595238095238102},{"$f":"SUM(T8:T38)","v":0}]
[null,{"$f":"B8","v":"2023-10-01"},{"$f":"MAX(B8:B38)","v":"2023-10-31"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":1},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":5},{"$f":"C40-B40+1","v":31},{"$f":"G40-K40","v":25},null,null,{"$f":"E40+F40","v":6},{"$f":"H40&\"/\"&K40","v":"25/6"},"Decimal:",{"$f":"N39*24","v":{"v":9.142857142857146,"d":"9.14"}},{"$f":"O39*24","v":{"v":34.14285714285715,"d":"34.14"}},"Decimal:",{"$f":"Q39*24","v":{"v":0,"d":"0.00"}},{"v":153.20000000000007,"d":"153.20"},{"$f":"S39*24","v":{"v":2.5428571428571445,"d":"2.54"}},{"$f":"T39*24","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(ano_p,mês_p,1))","v":""},{"$f":"IF(dia_f=\"\",\"\",DATE(ano_p,mês_p+1,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":2.194285714285715,"d":"2.19"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",T40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":22},{"$f":"IF(OR(dia_f=\"\",dia_f=1),DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2023-10-01"},"Data de início:"]
[{"$nulls":22},{"$f":"IF(OR(dia_f=\"\",dia_f=1),DATE(ano_p,mês_p+1,0),(DATE($X$22,mês_p,dia_f)))","v":"2023-10-31"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2020]
[{"$nulls":3},2,null,2021]
[{"$nulls":3},3,null,2022]
[{"$nulls":3},4,null,2023]
[{"$nulls":3},5,null,2024]
[{"$nulls":3},6,null,2025]
[{"$nulls":3},7,null,2026]
[{"$nulls":3},8,null,2027]
[{"$nulls":3},9,null,2028]
[{"$nulls":3},10,null,2029]
[{"$nulls":3},11,null,2030]
[{"$nulls":3},12,null,2031]

{"sheet":"Novembro","index":1,"n_rows":131,"n_cols":31,"rows_kept":131,"merged":[[1,7,2,7],[1,18,3,18],[4,1,4,2],[5,22,6,23],[5,25,5,30],[6,1,6,2],[16,22,16,23],[19,22,19,23],[41,14,41,15]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH(W117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Novembro"}]
[]
[]
[]
[null,"Empregado :",null,{"$f":"Outubro!D5","v":"Alexandre José de Souza Silva"},{"$nulls":4},"Setor :",{"$nulls":5},"Unidade  :"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências In-justificadas","Compen-sadas","H. Extras","HE 100%",null,null,"JORNADA CONTRATUAL",null,null,"CARTÃO PONTO ESPELHO"]
[null,"Saldo anterior",{"$nulls":15},{"$f":"IF(Outubro!W32=\"Horas Compensadas\",Outubro!X32,0)","v":6.277380952380955},{"$f":"IF(Outubro!W32=\"Horas Extras\",Outubro!X32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":4},{"$f":"EDATE(inicio,1)","v":"2023-11-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2023-11-01"},null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1900,"d":"19:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))+IF(AND(G8=\"\",H8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC8+(AB8>AC8)))-MAX(ININOT,AB8)+(MIN(FIMNOT,AC8+(AB8>AC8))-MIN(FIMNOT,AB8)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE8+(AD8>AE8)))-MAX(ININOT,AD8)+(MIN(FIMNOT,AE8+(AD8>AE8))-MIN(FIMNOT,AD8))))","v":"01:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"00:08:34.286"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"01:08:34.286"},{"$f":"IF(B8=\"\",\"\",MOD((AA8-Z8)+(AC8-AB8)+(AE8-AD8),1)+M8)","v":"10:08:34.286"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$X$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(O8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(O8<P8,P8-O8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),MAX(0,O8-P8),IF(P8=0,0,MAX(0,O8-P8))))","v":"02:48:34.286"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),0,IF(P8=0,O8,0)))","v":"00:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"12:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"13:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"19:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"22:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"23:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":8},{"$f":"B8+1","v":"2023-11-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"feriado"},null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2400,"d":"24:00"},{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"10:00:00.288"},"02:00:00",{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:17:08.571"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"02:17:08.571"},{"$f":"IF(B9=\"\",\"\",MOD((AA9-Z9)+(AC9-AB9)+(AE9-AD9),1)+M9)","v":"12:17:08.571"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(O9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(O9<P9,P9-O9,\"\"))))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"04:57:08.571"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","07:20:00",null,{"$f":"IF(B9=\"\",\"\",IF($E9=\"\",0,TIME(INT(E9/100),MOD(E9,100),0)))","v":"09:00:00"},{"$f":"IF(B9=\"\",\"\",IF($F9=\"\",0,TIME(INT(F9/100),MOD(F9,100),0)))","v":"12:00:00"},{"$f":"IF(B9=\"\",\"\",IF($G9=\"\",0,TIME(INT(G9/100),MOD(G9,100),0)))","v":"13:00:00"},{"$f":"IF(B9=\"\",\"\",IF($H9=\"\",0,TIME(INT(H9/100),MOD(H9,100),0)))","v":"20:00:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"22:00:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"00:00:00"}]
[6,{"$f":"B9+1","v":"2023-11-03"},"2023-11-03","F",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,{"$f":"B10+1","v":"2023-11-04"},"2023-11-04","A",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":2200,"d":"22:00"},{"v":100,"d":"01:00"},"04:00:00.288","03:00:00","00:25:42.857","03:25:42.857","07:25:42.857","07:20:00","","","00:05:42.857","00:00:00",null,4,"Quarta-feira","07:20:00",null,"08:00:00","12:00:00","00:00:00","00:00:00","22:00:00","01:00:00"]
[1,{"$f":"B11+1","v":"2023-11-05"},"2023-11-05",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":200,"d":"02:00"},"07:59:59.712","04:00:00","00:34:17.143","04:34:17.143","12:34:17.143","07:20:00","","","05:14:17.143","00:00:00",null,5,"Quinta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00","22:00:00","02:00:00"]
[2,{"$f":"B12+1","v":"2023-11-06"},"2023-11-06",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":2300,"d":"23:00"},{"v":2300,"d":"23:00"},{"v":200,"d":"02:00"},"12:29:59.712","04:00:00","00:34:17.143","04:34:17.143","17:04:17.143","07:20:00","","","09:44:17.143","00:00:00",null,6,"Sexta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","23:00:00","23:00:00","02:00:00"]
[3,"2023-11-07","2023-11-07",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":2200,"d":"22:00"},{"v":200,"d":"02:00"},{"v":200,"d":"02:00"},{"v":500,"d":"05:00"},"04:00:00.288","07:00:00","01:00:00","08:00:00","12:00:00","07:20:00","","","04:40:00","00:00:00",null,7,"Sábado","07:20:00",null,"10:00:00","14:00:00","22:00:00","02:00:00","02:00:00","05:00:00"]
[4,"2023-11-08","2023-11-08",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},{"v":2215,"d":"22:15"},{"v":200,"d":"02:00"},"09:00:00","04:00:00","00:34:17.143","04:34:17.143","13:34:17.143","07:20:00","","","06:14:17.143","00:00:00",null,8,"Feriados","07:20:00",null,"12:00:00","16:00:00","17:00:00","22:15:00","22:15:00","02:00:00"]
[5,"2023-11-09","2023-11-09","F",{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},"10:59:59.712","02:00:00","00:17:08.571","02:17:08.571","13:17:08.571","00:00:00","","","00:00:00","13:17:08.571",null,null,"Folgas","00:00:00",null,"09:00:00","12:00:00","13:00:00","19:00:00","20:00:00","00:00:00"]
[6,"2023-11-10","2023-11-10",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":2300,"d":"23:00"},{"v":2400,"d":"24:00"},{"v":130,"d":"01:30"},"12:00:00","02:30:00","00:21:25.714","02:51:25.714","14:51:25.714","07:20:00","","","07:31:25.714","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"09:00:00","12:00:00","13:00:00","23:00:00","00:00:00","01:30:00"]
[7,"2023-11-11","2023-11-11",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":2300,"d":"23:00"},{"v":2300,"d":"23:00"},{"v":230,"d":"02:30"},"12:00:00","04:30:00","00:38:34.286","05:08:34.286","17:08:34.286","07:20:00","","","09:48:34.286","00:00:00",null,null,"Início",{"$f":"ININOT","v":"22:00:00"},null,"09:00:00","12:00:00","13:00:00","23:00:00","23:00:00","02:30:00"]
[1,"2023-11-12","2023-11-12",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"v":2300,"d":"23:00"},{"v":2300,"d":"23:00"},{"v":600,"d":"06:00"},"09:00:00","07:00:00","01:00:00","08:00:00","17:00:00","07:20:00","","","09:40:00","00:00:00",null,null,"Término",{"$f":"FIMNOT","v":"05:00:00"},null,"09:00:00","13:00:00","18:00:00","23:00:00","23:00:00","06:00:00"]
[2,"2023-11-13","2023-11-13",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2300,"d":"23:00"},{"v":2300,"d":"23:00"},{"v":200,"d":"02:00"},"10:30:00","04:00:00","00:34:17.143","04:34:17.143","15:04:17.143","07:20:00","","","07:44:17.143","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"10:00:00","14:00:00","15:30:00","23:00:00","23:00:00","02:00:00"]
[3,"2023-11-14","2023-11-14",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},{"v":2315,"d":"23:15"},{"v":215,"d":"02:15"},"09:00:00","03:15:00","00:27:51.429","03:42:51.429","12:42:51.429","07:20:00","","","05:22:51.429","00:00:00",null,null,"Dia do fechamento do ponto:",{"$f":"IF(dia_f=\"\",\"\",dia_f)","v":""},null,"12:00:00","16:00:00","17:00:00","22:15:00","23:15:00","02:15:00"]
[8,"2023-11-15","feriado",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":2230,"d":"22:30"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"12:00:00","02:30:00","00:21:25.714","02:51:25.714","14:51:25.714","07:20:00","","","07:31:25.714","00:00:00",{"$nulls":5},"09:00:00","12:00:00","13:00:00","22:30:00","23:00:00","01:00:00"]
[5,"2023-11-16","2023-11-16",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":2400,"d":"24:00"},null,null,"12:00:00","02:00:00","00:17:08.571","02:17:08.571","14:17:08.571","07:20:00","","","06:57:08.571","00:00:00",{"$nulls":5},"09:00:00","12:00:00","13:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-11-17","2023-11-17","F",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"$nulls":4},"04:00:00.288","00:00:00","00:00:00","00:00:00","04:00:00","00:00:00","","","00:00:00","04:00:00",{"$nulls":5},"08:00:00","12:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-11-18","2023-11-18",null,{"v":400,"d":"04:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},null,null,"12:00:00","01:00:00","00:08:34.286","01:08:34.286","13:08:34.286","07:20:00","","","05:48:34.286","00:00:00",null,null,"Adicional Noturno:",{"$f":"N39","v":3.432539682539683},null,"04:00:00","12:00:00","13:00:00","18:00:00","00:00:00","00:00:00"]
[1,"2023-11-19","2023-11-19",null,{"v":430,"d":"04:30"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},null,null,"10:30:00","00:30:00","00:04:17.143","00:34:17.143","11:04:17.143","07:20:00","","","03:44:17.143","00:00:00",null,null,"Horas Trabalhadas:",{"$f":"O39","v":14.224206349206352},null,"04:30:00","13:00:00","13:30:00","16:00:00","00:00:00","00:00:00"]
[8,"2023-11-20","feriado",null,{"v":430,"d":"04:30"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":1800,"d":"18:00"},{"v":1900,"d":"19:00"},{"v":2300,"d":"23:00"},"14:30:00.288","01:30:00","00:12:51.429","01:42:51.429","16:12:51.429","07:20:00","","","08:52:51.429","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"Q39","v":0},null,"04:30:00","14:00:00","15:30:00","18:00:00","19:00:00","23:00:00"]
[3,"2023-11-21","2023-11-21",null,{"v":400,"d":"04:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2200,"d":"22:00"},{"v":2200,"d":"22:00"},{"v":400,"d":"04:00"},"16:00:00.288","07:00:00","01:00:00","08:00:00",1,"07:20:00","","","16:40:00","00:00:00",null,null,"Horas Compensadas:",{"$f":"R39","v":6.923214285714288},null,"04:00:00","16:00:00","17:00:00","22:00:00","22:00:00","04:00:00"]
[4,"2023-11-22","2023-11-22",null,{"v":300,"d":"03:00"},{"v":600,"d":"06:00"},{"v":1000,"d":"10:00"},{"v":2300,"d":"23:00"},null,null,"13:00:00.288","03:00:00","00:25:42.857","03:25:42.857","16:25:42.857","07:20:00","","","09:05:42.857","00:00:00",null,null,"Horas Extras:",{"$f":"S39","v":6.014880952380954},null,"03:00:00","06:00:00","10:00:00","23:00:00","00:00:00","00:00:00"]
[5,"2023-11-23","2023-11-23",null,{"v":330,"d":"03:30"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1900,"d":"19:00"},null,null,"13:00:00.288","01:30:00","00:12:51.429","01:42:51.429","14:42:51.429","07:20:00","","","07:22:51.429","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"T39","v":0.9107142857142857},null,"03:30:00","12:00:00","13:00:00","19:00:00","00:00:00","00:00:00"]
[6,"2023-11-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2023-11-24"},"F",{"$nulls":4},{"v":2200,"d":"22:00"},{"v":200,"d":"02:00"},"00:00:00","04:00:00","00:34:17.143","04:34:17.143","04:34:17.143","00:00:00","","","00:00:00","04:34:17.143",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","22:00:00","02:00:00"]
[7,"2023-11-25","2023-11-25",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},null,null,"07:59:59.712","00:00:00","00:00:00","00:00:00","08:00:00","07:20:00","","","00:40:00","00:00:00",null,null,{"$f":"IF(X28-X29=0,0,(IF(X28-X29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(X28-X29<0,(X28*-1)-(X29*-1),X28-X29)","v":0.9083333333333341},null,"09:00:00","12:00:00","13:00:00","18:00:00","00:00:00","00:00:00"]
[1,"2023-11-26","2023-11-26",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},null,null,"06:29:59.712","00:00:00","00:00:00","00:00:00","06:30:00","07:20:00","","00:50:00","00:00:00","00:00:00",{"$nulls":5},"09:00:00","13:00:00","13:30:00","16:00:00","00:00:00","00:00:00"]
[2,"2023-11-27","2023-11-27",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2000,"d":"20:00"},null,null,"08:30:00.288","00:00:00","00:00:00","00:00:00","08:30:00","07:20:00","","","01:10:00","00:00:00",{"$nulls":5},"10:00:00","14:00:00","15:30:00","20:00:00","00:00:00","00:00:00"]
[3,"2023-11-28","2023-11-28",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2250,"d":"22:50"},null,null,"09:00:00","00:50:00","00:07:08.571","00:57:08.571","09:57:08.571","07:20:00","","","02:37:08.571","00:00:00",{"$nulls":5},"12:00:00","16:00:00","17:00:00","22:50:00","00:00:00","00:00:00"]
[4,{"$f":"IF(B35=\"\",\"\",IF(B35>=W117,\"\",B35+1))","v":"2023-11-29"},"2023-11-29",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,{"$f":"IF(B36=\"\",\"\",IF(B36>=W117,\"\",B36+1))","v":"2023-11-30"},"2023-11-30",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["",{"$f":"IF(B37=\"\",\"\",IF(B37>=W117,\"\",B37+1))","v":""},"",{"$nulls":7},"","","","",{"$f":"IF(B38=\"\",\"\",MOD((AA38-Z38)+(AC38-AB38)+(AE38-AD38),1)+M38)","v":""},"","","",{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38<>\"F\"),MAX(0,O38-P38),IF(P38=0,0,MAX(0,O38-P38))))","v":""},{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38=\"F\"),0,IF(P38=0,O38,0)))","v":""},{"$nulls":5},"","","","","",""]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":3.432539682539683},{"$f":"SUM(O8:O38)","v":14.224206349206352},"Total:",{"$f":"SUM(Q8:Q38)","v":0},{"$f":"SUM(R7:R38)","v":6.923214285714288},{"$f":"SUM(S7:S38)","v":6.014880952380954},{"$f":"SUM(T8:T38)","v":0.9107142857142857}]
[null,{"$f":"B8","v":"2023-11-01"},{"$f":"MAX(B8:B38)","v":"2023-11-30"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":3},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":4},{"$f":"C40-B40+1","v":30},{"$f":"G40-K40","v":23},null,null,{"$f":"E40+F40","v":7},{"$f":"H40&\"/\"&K40","v":"23/7"},"Decimal:",{"$f":"N39*24","v":{"v":82.38095238095238,"d":"82.38"}},{"$f":"O39*24","v":{"v":341.3809523809524,"d":"341.38"}},"Decimal:",{"$f":"Q39*24","v":{"v":0,"d":"0.00"}},{"v":166.15714285714293,"d":"166.16"},{"$f":"S39*24","v":{"v":144.3571428571429,"d":"144.36"}},{"$f":"T39*24","v":{"v":21.857142857142858,"d":"21.86"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(YEAR(W117),MONTH(W117),1))","v":""},{"$f":"IF(dia_f=\"\",\"\",EOMONTH(B41,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":25.07246376811594,"d":"25.07"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",T40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":22},{"$f":"$B$8","v":"2023-11-01"},"Data de início:"]
[{"$nulls":22},{"$f":"IF(DAY(B8)=1,EOMONTH(B8,0),DATE(YEAR(B8),MONTH(B8)+1,dia_f))","v":"2023-11-30"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2020]
[{"$nulls":3},2,null,2021]
[{"$nulls":3},3,null,2022]
[{"$nulls":3},4,null,2023]
[{"$nulls":3},5,null,2024]
[{"$nulls":3},6,null,2025]
[{"$nulls":3},7,null,2026]
[{"$nulls":3},8,null,2027]
[{"$nulls":3},9,null,2028]
[{"$nulls":3},10,null,2029]
[{"$nulls":3},11,null,2030]
[{"$nulls":3},12,null,2031]

{"sheet":"Dezembro","index":2,"n_rows":131,"n_cols":31,"rows_kept":131,"merged":[[1,7,2,7],[1,18,3,18],[4,1,4,2],[5,22,6,23],[5,25,5,30],[6,1,6,2],[16,22,16,23],[19,22,19,23],[41,14,41,15]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH(W117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Dezembro"}]
[]
[]
[]
[null,"Empregado :",null,{"$f":"Outubro!D5","v":"Alexandre José de Souza Silva"},{"$nulls":4},"Setor :",{"$nulls":5},"Unidade  :"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências In-justificadas","Compen-sadas","H. Extras","HE 100%",null,null,"JORNADA CONTRATUAL",null,null,"CARTÃO PONTO ESPELHO"]
[null,"Saldo anterior",{"$nulls":15},{"$f":"IF(Novembro!W32=\"Horas Compensadas\",Novembro!X32,0)","v":0.9083333333333341},{"$f":"IF(Novembro!W32=\"Horas Extras\",Novembro!X32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":6},{"$f":"EDATE(inicio,2)","v":"2023-12-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2023-12-01"},{"$nulls":7},{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))+IF(AND(G8=\"\",H8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC8+(AB8>AC8)))-MAX(ININOT,AB8)+(MIN(FIMNOT,AC8+(AB8>AC8))-MIN(FIMNOT,AB8)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE8+(AD8>AE8)))-MAX(ININOT,AD8)+(MIN(FIMNOT,AE8+(AD8>AE8))-MIN(FIMNOT,AD8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((AA8-Z8)+(AC8-AB8)+(AE8-AD8),1)+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$X$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(O8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(O8<P8,P8-O8,\"\"))))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),MAX(0,O8-P8),IF(P8=0,0,MAX(0,O8-P8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),0,IF(P8=0,O8,0)))","v":"00:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":7},{"$f":"B8+1","v":"2023-12-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2023-12-02"},{"$nulls":7},{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((AA9-Z9)+(AC9-AB9)+(AE9-AD9),1)+M9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(O9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(O9<P9,P9-O9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","07:20:00",null,{"$f":"IF(B9=\"\",\"\",IF($E9=\"\",0,TIME(INT(E9/100),MOD(E9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($F9=\"\",0,TIME(INT(F9/100),MOD(F9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($G9=\"\",0,TIME(INT(G9/100),MOD(G9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($H9=\"\",0,TIME(INT(H9/100),MOD(H9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"00:00:00"}]
[1,{"$f":"B9+1","v":"2023-12-03"},"2023-12-03",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,{"$f":"B10+1","v":"2023-12-04"},"2023-12-04",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,4,"Quarta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,{"$f":"B11+1","v":"2023-12-05"},"2023-12-05",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,5,"Quinta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,{"$f":"B12+1","v":"2023-12-06"},"2023-12-06",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,6,"Sexta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2023-12-07","2023-12-07",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,7,"Sábado","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-12-08","2023-12-08",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,8,"Feriados","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-12-09","2023-12-09",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2023-12-10","2023-12-10",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2023-12-11","2023-12-11",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Início",{"$f":"ININOT","v":"22:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2023-12-12","2023-12-12",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Término",{"$f":"FIMNOT","v":"05:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2023-12-13","2023-12-13",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2023-12-14","2023-12-14",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Dia do fechamento do ponto:",{"$f":"IF(dia_f=\"\",\"\",dia_f)","v":""},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-12-15","2023-12-15",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-12-16","2023-12-16",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2023-12-17","2023-12-17",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2023-12-18","2023-12-18",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Adicional Noturno:",{"$f":"N39","v":"00:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2023-12-19","2023-12-19",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Trabalhadas:",{"$f":"O39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2023-12-20","2023-12-20",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"Q39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2023-12-21","2023-12-21",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Compensadas:",{"$f":"R39","v":10.380555555555551},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2023-12-22","2023-12-22",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"S39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2023-12-23","2023-12-23",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"T39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2023-12-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2023-12-24"},{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[8,"2023-12-25","feriado",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,{"$f":"IF(X28-X29=0,0,(IF(X28-X29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(X28-X29<0,(X28*-1)-(X29*-1),X28-X29)","v":10.380555555555551},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2023-12-26","2023-12-26",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2023-12-27","2023-12-27",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2023-12-28","2023-12-28",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,{"$f":"IF(B35=\"\",\"\",IF(B35>=W117,\"\",B35+1))","v":"2023-12-29"},"2023-12-29",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,{"$f":"IF(B36=\"\",\"\",IF(B36>=W117,\"\",B36+1))","v":"2023-12-30"},"2023-12-30",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,{"$f":"IF(B37=\"\",\"\",IF(B37>=W117,\"\",B37+1))","v":"2023-12-31"},"2023-12-31",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(B38=\"\",\"\",MOD((AA38-Z38)+(AC38-AB38)+(AE38-AD38),1)+M38)","v":"00:00:00"},"07:20:00","","07:20:00",{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38<>\"F\"),MAX(0,O38-P38),IF(P38=0,0,MAX(0,O38-P38))))","v":"00:00:00"},{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38=\"F\"),0,IF(P38=0,O38,0)))","v":"00:00:00"},{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":0},{"$f":"SUM(O8:O38)","v":0},"Total:",{"$f":"SUM(Q8:Q38)","v":0},{"$f":"SUM(R7:R38)","v":10.380555555555551},{"$f":"SUM(S7:S38)","v":0},{"$f":"SUM(T8:T38)","v":0}]
[null,{"$f":"B8","v":"2023-12-01"},{"$f":"MAX(B8:B38)","v":"2023-12-31"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":1},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":5},{"$f":"C40-B40+1","v":31},{"$f":"G40-K40","v":25},null,null,{"$f":"E40+F40","v":6},{"$f":"H40&\"/\"&K40","v":"25/6"},"Decimal:",{"$f":"N39*24","v":{"v":0,"d":"0.00"}},{"$f":"O39*24","v":{"v":0,"d":"0.00"}},"Decimal:",{"$f":"Q39*24","v":{"v":0,"d":"0.00"}},{"v":249.1333333333332,"d":"249.13"},{"$f":"S39*24","v":{"v":0,"d":"0.00"}},{"$f":"T39*24","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(YEAR(W117),MONTH(W117),1))","v":""},{"$f":"IF(dia_f=\"\",\"\",EOMONTH(B41,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",T40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":22},{"$f":"B8","v":"2023-12-01"},"Data de início:"]
[{"$nulls":22},{"$f":"IF(DAY(B8)=1,EOMONTH(B8,0),DATE(YEAR(B8),MONTH(B8)+1,dia_f))","v":"2023-12-31"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2020]
[{"$nulls":3},2,null,2021]
[{"$nulls":3},3,null,2022]
[{"$nulls":3},4,null,2023]
[{"$nulls":3},5,null,2024]
[{"$nulls":3},6,null,2025]
[{"$nulls":3},7,null,2026]
[{"$nulls":3},8,null,2027]
[{"$nulls":3},9,null,2028]
[{"$nulls":3},10,null,2029]
[{"$nulls":3},11,null,2030]
[{"$nulls":3},12,null,2031]

{"sheet":"Janeiro","index":3,"n_rows":131,"n_cols":31,"rows_kept":131,"merged":[[1,7,2,7],[1,18,3,18],[4,1,4,2],[5,22,6,23],[5,25,5,30],[6,1,6,2],[16,22,16,23],[19,22,19,23],[41,14,41,15]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH(W117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Janeiro"}]
[]
[]
[]
[null,"Empregado :",null,{"$f":"Outubro!D5","v":"Alexandre José de Souza Silva"},{"$nulls":4},"Setor :",{"$nulls":5},"Unidade  :"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências In-justificadas","Compen-sadas","H. Extras","HE 100%",null,null,"JORNADA CONTRATUAL",null,null,"CARTÃO PONTO ESPELHO"]
[null,"Saldo anterior",{"$nulls":15},{"$f":"IF(Dezembro!W32=\"Horas Compensadas\",Dezembro!X32,0)","v":10.380555555555551},{"$f":"IF(Dezembro!W32=\"Horas Extras\",Dezembro!X32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":8},{"$f":"EDATE(inicio,3)","v":"2024-01-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"feriado"},{"$nulls":7},{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8)))-MIN(FIMNOT,Z8))+IF(AND(G8=\"\",H8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC8+(AB8>AC8)))-MAX(ININOT,AB8)+(MIN(FIMNOT,AC8+(AB8>AC8))-MIN(FIMNOT,AB8)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE8+(AD8>AE8)))-MAX(ININOT,AD8)+(MIN(FIMNOT,AE8+(AD8>AE8))-MIN(FIMNOT,AD8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((AA8-Z8)+(AC8-AB8)+(AE8-AD8),1)+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$X$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(O8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(O8<P8,P8-O8,\"\"))))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),MAX(0,O8-P8),IF(P8=0,0,MAX(0,O8-P8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),0,IF(P8=0,O8,0)))","v":"00:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":3},{"$f":"B8+1","v":"2024-01-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2024-01-02"},{"$nulls":7},{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((AA9-Z9)+(AC9-AB9)+(AE9-AD9),1)+M9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(O9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(O9<P9,P9-O9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","07:20:00",null,{"$f":"IF(B9=\"\",\"\",IF($E9=\"\",0,TIME(INT(E9/100),MOD(E9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($F9=\"\",0,TIME(INT(F9/100),MOD(F9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($G9=\"\",0,TIME(INT(G9/100),MOD(G9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($H9=\"\",0,TIME(INT(H9/100),MOD(H9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"00:00:00"}]
[4,{"$f":"B9+1","v":"2024-01-03"},"2024-01-03",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,{"$f":"B10+1","v":"2024-01-04"},"2024-01-04",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,4,"Quarta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,{"$f":"B11+1","v":"2024-01-05"},"2024-01-05",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,5,"Quinta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,{"$f":"B12+1","v":"2024-01-06"},"2024-01-06",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,6,"Sexta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-07","2024-01-07",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,7,"Sábado","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-08","2024-01-08",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,8,"Feriados","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-09","2024-01-09",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-10","2024-01-10",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-11","2024-01-11",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Início",{"$f":"ININOT","v":"22:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-12","2024-01-12",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Término",{"$f":"FIMNOT","v":"05:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-13","2024-01-13",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-14","2024-01-14",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Dia do fechamento do ponto:",{"$f":"IF(dia_f=\"\",\"\",dia_f)","v":""},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-15","2024-01-15",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-16","2024-01-16",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-17","2024-01-17",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-18","2024-01-18",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Adicional Noturno:",{"$f":"N39","v":"00:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-19","2024-01-19",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Trabalhadas:",{"$f":"O39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-20","2024-01-20",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"Q39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-21","2024-01-21",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Compensadas:",{"$f":"R39","v":19.85277777777779},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-22","2024-01-22",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"S39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-23","2024-01-23",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"T39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2024-01-24"},{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-25","2024-01-25",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,{"$f":"IF(X28-X29=0,0,(IF(X28-X29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(X28-X29<0,(X28*-1)-(X29*-1),X28-X29)","v":19.85277777777779},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-26","2024-01-26",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-27","2024-01-27",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-28","2024-01-28",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,{"$f":"IF(B35=\"\",\"\",IF(B35>=W117,\"\",B35+1))","v":"2024-01-29"},"2024-01-29",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,{"$f":"IF(B36=\"\",\"\",IF(B36>=W117,\"\",B36+1))","v":"2024-01-30"},"2024-01-30",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,{"$f":"IF(B37=\"\",\"\",IF(B37>=W117,\"\",B37+1))","v":"2024-01-31"},"2024-01-31",{"$nulls":7},"00:00:00",{"$f":"IF(B38=\"\",\"\",IF(AND(E38=\"\",F38=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA38+(Z38>AA38)))-MAX(ININOT,Z38)+(MIN(FIMNOT,AA38+(Z38>AA38))-MIN(FIMNOT,Z38)))+IF(AND(G38=\"\",H38=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC38+(AB38>AC38)))-MAX(ININOT,AB38)+(MIN(FIMNOT,AC38+(AB38>AC38))-MIN(FIMNOT,AB38)))+IF(AND(I38=\"\",J38=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE38+(AD38>AE38)))-MAX(ININOT,AD38)+(MIN(FIMNOT,AE38+(AD38>AE38))-MIN(FIMNOT,AD38))))","v":"00:00:00"},"00:00:00","00:00:00",{"$f":"IF(B38=\"\",\"\",MOD((AA38-Z38)+(AC38-AB38)+(AE38-AD38),1)+M38)","v":"00:00:00"},"07:20:00","","07:20:00",{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38<>\"F\"),MAX(0,O38-P38),IF(P38=0,0,MAX(0,O38-P38))))","v":"00:00:00"},{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38=\"F\"),0,IF(P38=0,O38,0)))","v":"00:00:00"},{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":0},{"$f":"SUM(O8:O38)","v":0},"Total:",{"$f":"SUM(Q8:Q38)","v":0},{"$f":"SUM(R7:R38)","v":19.85277777777779},{"$f":"SUM(S7:S38)","v":0},{"$f":"SUM(T8:T38)","v":0}]
[null,{"$f":"B8","v":"2024-01-01"},{"$f":"MAX(B8:B38)","v":"2024-01-31"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":1},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":4},{"$f":"C40-B40+1","v":31},{"$f":"G40-K40","v":26},null,null,{"$f":"E40+F40","v":5},{"$f":"H40&\"/\"&K40","v":"26/5"},"Decimal:",{"$f":"N39*24","v":{"v":0,"d":"0.00"}},{"$f":"O39*24","v":{"v":0,"d":"0.00"}},"Decimal:",{"$f":"Q39*24","v":{"v":0,"d":"0.00"}},{"v":476.4666666666669,"d":"476.47"},{"$f":"S39*24","v":{"v":0,"d":"0.00"}},{"$f":"T39*24","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(YEAR(W117),MONTH(W117),1))","v":""},{"$f":"IF(dia_f=\"\",\"\",EOMONTH(B41,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",T40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":22},{"$f":"B8","v":"2024-01-01"},"Data de início:"]
[{"$nulls":22},{"$f":"IF(DAY(B8)=1,EOMONTH(B8,0),DATE(YEAR(B8),MONTH(B8)+1,dia_f))","v":"2024-01-31"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2020]
[{"$nulls":3},2,null,2021]
[{"$nulls":3},3,null,2022]
[{"$nulls":3},4,null,2023]
[{"$nulls":3},5,null,2024]
[{"$nulls":3},6,null,2025]
[{"$nulls":3},7,null,2026]
[{"$nulls":3},8,null,2027]
[{"$nulls":3},9,null,2028]
[{"$nulls":3},10,null,2029]
[{"$nulls":3},11,null,2030]
[{"$nulls":3},12,null,2031]

{"sheet":"Fevereiro","index":4,"n_rows":131,"n_cols":31,"rows_kept":131,"merged":[[1,7,2,7],[1,18,3,18],[4,1,4,2],[5,22,6,23],[5,25,5,30],[6,1,6,2],[16,22,16,23],[19,22,19,23],[41,14,41,15]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH(W117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Fevereiro"}]
[]
[]
[]
[null,"Empregado :",null,{"$f":"Outubro!D5","v":"Alexandre José de Souza Silva"},{"$nulls":4},"Setor :",{"$nulls":5},"Unidade  :"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências In-justificadas","Compen-sadas","H. Extras","HE 100%",null,null,"JORNADA CONTRATUAL",null,null,"CARTÃO PONTO ESPELHO"]
[null,"Saldo anterior",{"$nulls":15},{"$f":"IF(Janeiro!W32=\"Horas Compensadas\",Janeiro!X32,0)","v":19.85277777777779},{"$f":"IF(Janeiro!W32=\"Horas Extras\",Janeiro!X32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":5},{"$f":"EDATE(inicio,4)","v":"2024-02-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2024-02-01"},{"$nulls":7},{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))+IF(AND(G8=\"\",H8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC8+(AB8>AC8)))-MAX(ININOT,AB8)+(MIN(FIMNOT,AC8+(AB8>AC8))-MIN(FIMNOT,AB8)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE8+(AD8>AE8)))-MAX(ININOT,AD8)+(MIN(FIMNOT,AE8+(AD8>AE8))-MIN(FIMNOT,AD8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((AA8-Z8)+(AC8-AB8)+(AE8-AD8),1)+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$X$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(O8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(O8<P8,P8-O8,\"\"))))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),MAX(0,O8-P8),IF(P8=0,0,MAX(0,O8-P8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),0,IF(P8=0,O8,0)))","v":"00:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":6},{"$f":"B8+1","v":"2024-02-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2024-02-02"},{"$nulls":7},{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((AA9-Z9)+(AC9-AB9)+(AE9-AD9),1)+M9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(O9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(O9<P9,P9-O9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","07:20:00",null,{"$f":"IF(B9=\"\",\"\",IF($E9=\"\",0,TIME(INT(E9/100),MOD(E9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($F9=\"\",0,TIME(INT(F9/100),MOD(F9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($G9=\"\",0,TIME(INT(G9/100),MOD(G9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($H9=\"\",0,TIME(INT(H9/100),MOD(H9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"00:00:00"}]
[7,{"$f":"B9+1","v":"2024-02-03"},"2024-02-03",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,{"$f":"B10+1","v":"2024-02-04"},"2024-02-04",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,4,"Quarta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,{"$f":"B11+1","v":"2024-02-05"},"2024-02-05",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,5,"Quinta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,{"$f":"B12+1","v":"2024-02-06"},"2024-02-06",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,6,"Sexta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-02-07","2024-02-07",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,7,"Sábado","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-02-08","2024-02-08",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,8,"Feriados","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-02-09","2024-02-09",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-02-10","2024-02-10",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-02-11","2024-02-11",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Início",{"$f":"ININOT","v":"22:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-02-12","2024-02-12",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Término",{"$f":"FIMNOT","v":"05:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-02-13","2024-02-13",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-02-14","2024-02-14",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Dia do fechamento do ponto:",{"$f":"IF(dia_f=\"\",\"\",dia_f)","v":""},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-02-15","2024-02-15",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-02-16","2024-02-16",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-02-17","2024-02-17",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-02-18","2024-02-18",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Adicional Noturno:",{"$f":"N39","v":"00:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-02-19","2024-02-19",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Trabalhadas:",{"$f":"O39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-02-20","2024-02-20",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"Q39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-02-21","2024-02-21",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Compensadas:",{"$f":"R39","v":28.713888888888945},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-02-22","2024-02-22",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"S39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-02-23","2024-02-23",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"T39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-02-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2024-02-24"},{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-02-25","2024-02-25",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,{"$f":"IF(X28-X29=0,0,(IF(X28-X29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(X28-X29<0,(X28*-1)-(X29*-1),X28-X29)","v":28.713888888888945},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-02-26","2024-02-26",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-02-27","2024-02-27",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-02-28","2024-02-28",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,{"$f":"IF(B35=\"\",\"\",IF(B35>=W117,\"\",B35+1))","v":"2024-02-29"},"2024-02-29",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["",{"$f":"IF(B36=\"\",\"\",IF(B36>=W117,\"\",B36+1))","v":""},"",{"$nulls":7},"","","","","","","","","","",{"$nulls":5},"","","","","",""]
["",{"$f":"IF(B37=\"\",\"\",IF(B37>=W117,\"\",B37+1))","v":""},"",{"$nulls":7},"","","","",{"$f":"IF(B38=\"\",\"\",MOD((AA38-Z38)+(AC38-AB38)+(AE38-AD38),1)+M38)","v":""},"","","",{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38<>\"F\"),MAX(0,O38-P38),IF(P38=0,0,MAX(0,O38-P38))))","v":""},{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38=\"F\"),0,IF(P38=0,O38,0)))","v":""},{"$nulls":5},"","","","","",""]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":0},{"$f":"SUM(O8:O38)","v":0},"Total:",{"$f":"SUM(Q8:Q38)","v":0},{"$f":"SUM(R7:R38)","v":28.713888888888945},{"$f":"SUM(S7:S38)","v":0},{"$f":"SUM(T8:T38)","v":0}]
[null,{"$f":"B8","v":"2024-02-01"},{"$f":"MAX(B8:B38)","v":"2024-02-29"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":0},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":4},{"$f":"C40-B40+1","v":29},{"$f":"G40-K40","v":25},null,null,{"$f":"E40+F40","v":4},{"$f":"H40&\"/\"&K40","v":"25/4"},"Decimal:",{"$f":"N39*24","v":{"v":0,"d":"0.00"}},{"$f":"O39*24","v":{"v":0,"d":"0.00"}},"Decimal:",{"$f":"Q39*24","v":{"v":0,"d":"0.00"}},{"v":689.1333333333347,"d":"689.13"},{"$f":"S39*24","v":{"v":0,"d":"0.00"}},{"$f":"T39*24","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(YEAR(W117),MONTH(W117),1))","v":""},{"$f":"IF(dia_f=\"\",\"\",EOMONTH(B41,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",T40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":22},{"$f":"B8","v":"2024-02-01"},"Data de início:"]
[{"$nulls":22},{"$f":"IF(DAY(B8)=1,EOMONTH(B8,0),DATE(YEAR(B8),MONTH(B8)+1,dia_f))","v":"2024-02-29"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2020]
[{"$nulls":3},2,null,2021]
[{"$nulls":3},3,null,2022]
[{"$nulls":3},4,null,2023]
[{"$nulls":3},5,null,2024]
[{"$nulls":3},6,null,2025]
[{"$nulls":3},7,null,2026]
[{"$nulls":3},8,null,2027]
[{"$nulls":3},9,null,2028]
[{"$nulls":3},10,null,2029]
[{"$nulls":3},11,null,2030]
[{"$nulls":3},12,null,2031]

{"sheet":"Março","index":5,"n_rows":131,"n_cols":31,"rows_kept":131,"merged":[[1,7,2,7],[1,18,3,18],[4,1,4,2],[5,22,6,23],[5,25,5,30],[6,1,6,2],[16,22,16,23],[19,22,19,23],[41,14,41,15]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH(W117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Março"}]
[]
[]
[]
[null,"Empregado :",null,{"$f":"Outubro!D5","v":"Alexandre José de Souza Silva"},{"$nulls":4},"Setor :",{"$nulls":5},"Unidade  :"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências In-justificadas","Compen-sadas","H. Extras","HE 100%",null,null,"JORNADA CONTRATUAL",null,null,"CARTÃO PONTO ESPELHO"]
[null,"Saldo anterior",{"$nulls":15},{"$f":"IF(Fevereiro!W32=\"Horas Compensadas\",Fevereiro!X32,0)","v":28.713888888888945},{"$f":"IF(Fevereiro!W32=\"Horas Extras\",Fevereiro!X32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":6},{"$f":"EDATE(inicio,5)","v":"2024-03-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2024-03-01"},{"$nulls":7},{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))+IF(AND(G8=\"\",H8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC8+(AB8>AC8)))-MAX(ININOT,AB8)+(MIN(FIMNOT,AC8+(AB8>AC8))-MIN(FIMNOT,AB8)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE8+(AD8>AE8)))-MAX(ININOT,AD8)+(MIN(FIMNOT,AE8+(AD8>AE8))-MIN(FIMNOT,AD8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((AA8-Z8)+(AC8-AB8)+(AE8-AD8),1)+M8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$X$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(O8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(O8<P8,P8-O8,\"\"))))","v":"07:20:00"},"=SE(B8=\"\";\"\";SE(E(DIA.DA.SEMANA(B8;1)=7;P8=0;D8<>\"F\");MÁXIMO(0;O8-P8);SE(P8=0;0;MÁXIMO(0;O8-P8))))","=SE(B8=\"\";\"\";SE(E(DIA.DA.SEMANA(B8;1)=7;P8=0;D8<>\"F\");0;SE(P8=0;O8;0)))",null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":7},{"$f":"B8+1","v":"2024-03-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2024-03-02"},{"$nulls":7},{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(E9=\"\",F9=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AA9+(Z9>AA9)))-MAX(ININOT,Z9)+(MIN(FIMNOT,AA9+(Z9>AA9))-MIN(FIMNOT,Z9)))+IF(AND(G9=\"\",H9=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AC9+(AB9>AC9)))-MAX(ININOT,AB9)+(MIN(FIMNOT,AC9+(AB9>AC9))-MIN(FIMNOT,AB9)))+IF(AND(I9=\"\",J9=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,AE9+(AD9>AE9)))-MAX(ININOT,AD9)+(MIN(FIMNOT,AE9+(AD9>AE9))-MIN(FIMNOT,AD9))))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((AA9-Z9)+(AC9-AB9)+(AE9-AD9),1)+M9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(O9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(O9<P9,P9-O9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","07:20:00",null,{"$f":"IF(B9=\"\",\"\",IF($E9=\"\",0,TIME(INT(E9/100),MOD(E9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($F9=\"\",0,TIME(INT(F9/100),MOD(F9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($G9=\"\",0,TIME(INT(G9/100),MOD(G9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($H9=\"\",0,TIME(INT(H9/100),MOD(H9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"00:00:00"}]
[1,{"$f":"B9+1","v":"2024-03-03"},"2024-03-03",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,{"$f":"B10+1","v":"2024-03-04"},"2024-03-04",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,4,"Quarta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,{"$f":"B11+1","v":"2024-03-05"},"2024-03-05",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,5,"Quinta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,{"$f":"B12+1","v":"2024-03-06"},"2024-03-06",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,6,"Sexta-feira","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-03-07","2024-03-07",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,7,"Sábado","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-03-08","2024-03-08",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,8,"Feriados","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-03-09","2024-03-09",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-03-10","2024-03-10",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-03-11","2024-03-11",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Início",{"$f":"ININOT","v":"22:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-03-12","2024-03-12",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Término",{"$f":"FIMNOT","v":"05:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-03-13","2024-03-13",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-03-14","2024-03-14",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Dia do fechamento do ponto:",{"$f":"IF(dia_f=\"\",\"\",dia_f)","v":""},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-03-15","2024-03-15",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-03-16","2024-03-16",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-03-17","2024-03-17",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-03-18","2024-03-18",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Adicional Noturno:",{"$f":"N39","v":"00:00:00"},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-03-19","2024-03-19",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Trabalhadas:",{"$f":"O39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-03-20","2024-03-20",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"Q39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-03-21","2024-03-21",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Compensadas:",{"$f":"R39","v":38.18611111111122},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-03-22","2024-03-22",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"S39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-03-23","2024-03-23",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"T39","v":0},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-03-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2024-03-24"},{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-03-25","2024-03-25",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",null,null,{"$f":"IF(X28-X29=0,0,(IF(X28-X29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(X28-X29<0,(X28*-1)-(X29*-1),X28-X29)","v":38.18611111111122},null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-03-26","2024-03-26",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-03-27","2024-03-27",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-03-28","2024-03-28",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[8,{"$f":"IF(B35=\"\",\"\",IF(B35>=W117,\"\",B35+1))","v":"2024-03-29"},"feriado",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,{"$f":"IF(B36=\"\",\"\",IF(B36>=W117,\"\",B36+1))","v":"2024-03-30"},"2024-03-30",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","07:20:00","","07:20:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,{"$f":"IF(B37=\"\",\"\",IF(B37>=W117,\"\",B37+1))","v":"2024-03-31"},"2024-03-31",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(B38=\"\",\"\",MOD((AA38-Z38)+(AC38-AB38)+(AE38-AD38),1)+M38)","v":"00:00:00"},"07:20:00","","07:20:00",{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38<>\"F\"),MAX(0,O38-P38),IF(P38=0,0,MAX(0,O38-P38))))","v":"00:00:00"},{"$f":"IF(B38=\"\",\"\",IF(AND(WEEKDAY(B38,1)=7,P38=0,D38=\"F\"),0,IF(P38=0,O38,0)))","v":"00:00:00"},{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":0},{"$f":"SUM(O8:O38)","v":0},"Total:",{"$f":"SUM(Q8:Q38)","v":0},{"$f":"SUM(R7:R38)","v":38.18611111111122},{"$f":"SUM(S7:S38)","v":0},{"$f":"SUM(T8:T38)","v":0}]
[null,{"$f":"B8","v":"2024-03-01"},{"$f":"MAX(B8:B38)","v":"2024-03-31"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":1},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":5},{"$f":"C40-B40+1","v":31},{"$f":"G40-K40","v":25},null,null,{"$f":"E40+F40","v":6},{"$f":"H40&\"/\"&K40","v":"25/6"},"Decimal:",{"$f":"N39*24","v":{"v":0,"d":"0.00"}},{"$f":"O39*24","v":{"v":0,"d":"0.00"}},"Decimal:",{"$f":"Q39*24","v":{"v":0,"d":"0.00"}},{"v":916.4666666666692,"d":"916.47"},{"$f":"S39*24","v":{"v":0,"d":"0.00"}},{"$f":"T39*24","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(YEAR(W117),MONTH(W117),1))","v":""},{"$f":"IF(dia_f=\"\",\"\",EOMONTH(B41,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":0,"d":"0.00"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",T40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":22},{"$f":"B8","v":"2024-03-01"},"Data de início:"]
[{"$nulls":22},{"$f":"IF(DAY(B8)=1,EOMONTH(B8,0),DATE(YEAR(B8),MONTH(B8)+1,dia_f))","v":"2024-03-31"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2020]
[{"$nulls":3},2,null,2021]
[{"$nulls":3},3,null,2022]
[{"$nulls":3},4,null,2023]
[{"$nulls":3},5,null,2024]
[{"$nulls":3},6,null,2025]
[{"$nulls":3},7,null,2026]
[{"$nulls":3},8,null,2027]
[{"$nulls":3},9,null,2028]
[{"$nulls":3},10,null,2029]
[{"$nulls":3},11,null,2030]
[{"$nulls":3},12,null,2031]

{"sheet":"Feriados","index":6,"n_rows":36,"n_cols":24,"rows_kept":36,"merged":[[0,0,0,1],[0,3,0,4],[3,0,3,5],[4,0,12,0],[13,0,15,0],[16,0,19,0]]}
["Ano",null,"Páscoa","Horário Noturno"]
[null,{"$f":"ano_p","v":2023},{"$f":"ROUND(DATE($B$2,4,MOD(234-11*MOD($B$2,19),30))/7,)*7-6","v":"2023-04-09"},"Início:",{"$f":"ININOT","v":"22:00:00"}]
[{"$nulls":3},"Fim:",{"$f":"FIMNOT","v":"05:00:00"}]
["Feriados Nacionais, Municipais e Estadual"]
["Feriados Nacionais","x","Ano Novo",{"$f":"IF($B$5=\"X\",DATE($B$2-1,1,1),DATE(1905,1,1))","v":"2022-01-01"},{"$f":"IF($B$5=\"X\",DATE($B$2,1,1),DATE(1905,1,1))","v":"2023-01-01"},{"$f":"IF($B$5=\"X\",DATE($B$2+1,1,1),DATE(1905,1,1))","v":"2024-01-01"},{"$f":"ROUND(DATE($B$2-1,4,MOD(234-11*MOD($B$2-1,19),30))/7,)*7-6","v":"2022-04-17"},{"$nulls":14},1,1,{"$f":"DATE(1905,1,1)","v":"1905-01-01"}]
[null,"x","Tiradentes",{"$f":"IF($B$6=\"X\",DATE($B$2-1,4,21),DATE(1905,1,1))","v":"2022-04-21"},{"$f":"IF($B$6=\"X\",DATE($B$2,4,21),DATE(1905,1,1))","v":"2023-04-21"},{"$f":"IF($B$6=\"X\",DATE($B$2+1,4,21),DATE(1905,1,1))","v":"2024-04-21"},{"$f":"ROUND(DATE($B$2+1,4,MOD(234-11*MOD($B$2+1,19),30))/7,)*7-6","v":"2024-03-31"},{"$nulls":14},2,2]
[null,"x","Dia do Trabalho",{"$f":"IF($B$7=\"X\",DATE($B$2-1,5,1),DATE(1905,1,1))","v":"2022-05-01"},{"$f":"IF($B$7=\"X\",DATE($B$2,5,1),DATE(1905,1,1))","v":"2023-05-01"},{"$f":"IF($B$7=\"X\",DATE($B$2+1,5,1),DATE(1905,1,1))","v":"2024-05-01"},{"$nulls":15},3,3]
[null,"x","Independência",{"$f":"IF($B$8=\"X\",DATE($B$2-1,9,7),DATE(1905,1,1))","v":"2022-09-07"},{"$f":"IF($B$8=\"X\",DATE($B$2,9,7),DATE(1905,1,1))","v":"2023-09-07"},{"$f":"IF($B$8=\"X\",DATE($B$2+1,9,7),DATE(1905,1,1))","v":"2024-09-07"},{"$nulls":15},4,4]
[null,"x","Padroeira do Brasil",{"$f":"IF($B$9=\"X\",DATE($B$2-1,10,12),DATE(1905,1,1))","v":"2022-10-12"},{"$f":"IF($B$9=\"X\",DATE($B$2,10,12),DATE(1905,1,1))","v":"2023-10-12"},{"$f":"IF($B$9=\"X\",DATE($B$2+1,10,12),DATE(1905,1,1))","v":"2024-10-12"},{"$nulls":15},5,5]
[null,"x","Finados",{"$f":"IF($B$10=\"X\",DATE($B$2-1,11,2),DATE(1905,1,1))","v":"2022-11-02"},{"$f":"IF($B$10=\"X\",DATE($B$2,11,2),DATE(1905,1,1))","v":"2023-11-02"},{"$f":"IF($B$10=\"X\",DATE($B$2+1,11,2),DATE(1905,1,1))","v":"2024-11-02"},{"$nulls":15},6,6]
[null,"x","Proclamação da República",{"$f":"IF($B$11=\"X\",DATE($B$2-1,11,15),DATE(1905,1,1))","v":"2022-11-15"},{"$f":"IF($B$11=\"X\",DATE($B$2,11,15),DATE(1905,1,1))","v":"2023-11-15"},{"$f":"IF($B$11=\"X\",DATE($B$2+1,11,15),DATE(1905,1,1))","v":"2024-11-15"},{"$nulls":15},7,7]
[null,"x","Zumbi e Consciência Negra",{"$f":"IF($B$12=\"X\",DATE($B$2-1,11,20),DATE(1905,1,1))","v":"2022-11-20"},{"$f":"IF($B$12=\"X\",DATE($B$2,11,20),DATE(1905,1,1))","v":"2023-11-20"},{"$f":"IF($B$12=\"X\",DATE($B$2+1,11,20),DATE(1905,1,1))","v":"2024-11-20"}]
[null,"x","Natal",{"$f":"IF($B$13=\"X\",DATE($B$2-1,12,25),DATE(1905,1,1))","v":"2022-12-25"},{"$f":"IF($B$13=\"X\",DATE($B$2,12,25),DATE(1905,1,1))","v":"2023-12-25"},{"$f":"IF($B$13=\"X\",DATE($B$2+1,12,25),DATE(1905,1,1))","v":"2024-12-25"},{"$nulls":15},8,8]
["Móveis","x","Sexta-Feira Santa",{"$f":"IF($B$14=\"X\",$G$5-2,DATE(1905,1,1))","v":"2022-04-15"},{"$f":"IF($B$14=\"X\",páscoa-2,DATE(1905,1,1))","v":"2023-04-07"},{"$f":"IF($B$14=\"X\",$G$6-2,DATE(1905,1,1))","v":"2024-03-29"},{"$nulls":15},9,9]
[null,"x","Corpus Christi",{"$f":"IF($B$15=\"X\",$G$5+60,DATE(1905,1,1))","v":"2022-06-16"},{"$f":"IF($B$15=\"X\",páscoa+60,DATE(1905,1,1))","v":"2023-06-08"},{"$f":"IF($B$15=\"X\",$G$6+60,DATE(1905,1,1))","v":"2024-05-30"},{"$nulls":15},10,10]
[null,null,"Terça-Feira de Carnaval",{"$f":"IF($B$16=\"X\",$G$5-47,DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$16=\"X\",páscoa-47,DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$16=\"X\",$G$6-47,DATE(1905,1,1))","v":"1905-01-01"},"DIA","MÊS",{"$nulls":13},11,11]
["Fixos","x","Feriado 1",{"$f":"IF($B$17=\"X\",DATE($B$2-1,$H$17,$G$17),DATE(1905,1,1))","v":"2022-06-10"},{"$f":"IF($B$17=\"X\",DATE($B$2,$H$17,$G$17),DATE(1905,1,1))","v":"2023-06-10"},{"$f":"IF($B$17=\"X\",DATE($B$2+1,$H$17,$G$17),DATE(1905,1,1))","v":"2024-06-10"},10,6,{"$nulls":13},12,12]
[null,"x","Feriado 2",{"$f":"IF($B$18=\"X\",DATE($B$2-1,H18,G18),DATE(1905,1,1))","v":"2022-06-24"},{"$f":"IF($B$18=\"X\",DATE($B$2,H18,G18),DATE(1905,1,1))","v":"2023-06-24"},{"$f":"IF($B$18=\"X\",DATE($B$2+1,H18,G18),DATE(1905,1,1))","v":"2024-06-24"},24,6,{"$nulls":14},13]
[null,null,"Feriado 3",{"$f":"IF($B$19=\"X\",DATE($B$2-1,H19,G19),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$19=\"X\",DATE($B$2,H19,G19),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$19=\"X\",DATE($B$2,H19,G19),DATE(1905,1,1))","v":"1905-01-01"},5,8,{"$nulls":14},14]
[null,null,"Feriado 4",{"$f":"IF($B$20=\"X\",DATE($B$2-1,H20,G20),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$20=\"X\",DATE($B$2,H20,G20),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$20=\"X\",DATE($B$2+1,H20,G20),DATE(1905,1,1))","v":"1905-01-01"},10,5,{"$nulls":14},15]
[{"$nulls":22},16]
[{"$nulls":22},17]
[{"$nulls":22},18]
[{"$nulls":22},19]
[{"$nulls":22},20]
[{"$nulls":22},21]
[{"$nulls":22},22]
[{"$nulls":22},23]
[{"$nulls":22},24]
[{"$nulls":22},25]
[{"$nulls":22},26]
[{"$nulls":22},27]
[{"$nulls":22},28]
[{"$nulls":22},29]
[{"$nulls":22},30]
[{"$nulls":22},31]