{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["fevereiro","março","abril","maio","junho","julho","Feriados"],"not_rendered":{"images":1,"macros":1,"defined_names":105,"comments":6},"read":"whole","date_system":"1900"}

{"sheet":"fevereiro","index":0,"n_rows":131,"n_cols":27,"rows_kept":131,"merged":[[1,7,2,7],[1,16,3,16],[4,1,4,2],[5,20,6,21],[5,23,5,26],[6,1,6,2],[16,20,16,21],[19,20,19,21],[41,12,41,13]]}
[{"$nulls":4},{"$f":"CHOOSE(MONTH($W$117),\"Janeiro\",\"Fevereiro\",\"Março\",\"Abril\",\"Maio\",\"Junho\",\"Julho\",\"Agosto\",\"Setembro\",\"Outubro\",\"Novembro\",\"Dezembro\")","v":"Janeiro"}]
[{"$nulls":5},"Ajuste o nome da aba"]
[{"$nulls":5},"na célula E1"]
[]
[]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Horas Noturnas","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":21},"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":8},{"$f":"inicio","v":"2024-01-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"feriado"},"F",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"$f":"IF(B8=\"\",\"\",ROUND(M8-L8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\",G8=\"\",H8=\"\"),0,IF(AND(G8=\"\",H8=\"\"),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8)),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8))+MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(J8/7*8)-J8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",J8+K8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((Y8-X8)+(AA8-Z8),1)+K8)","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$V$16,VLOOKUP(A8,jornada,3)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",N8>M8),N8-M8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(M8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(M8<N8,N8-M8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(N8=0,0,MAX(0,M8-N8)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(N8=0,M8,0))","v":"09:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"08: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":"18: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"},"A",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"$f":"IF(B9=\"\",\"\",ROUND(M9-L9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(J9/7*8)-J9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",J9+K9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((Y9-X9)+(AA9-Z9),1)+K9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",N9>M9),N9-M9,\"\"))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(M9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(M9<N9,N9-M9,\"\"))))","v":""},{"$f":"IF(B9=\"\",\"\",IF(N9=0,0,MAX(0,M9-N9)))","v":"00:00:00"},"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"}]
[4,{"$f":"B9+1","v":"2024-01-03"},"2024-01-03","A",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"04:00:00.288","00:00:00","00:00:00","00:00:00","04:00:00","07:20:00","03:20:00","","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"08:00:00","12:00:00","00:00:00","00:00:00"]
[5,{"$f":"B10+1","v":"2024-01-04"},"2024-01-04",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},"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,4,"Quarta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00"]
[6,{"$f":"B11+1","v":"2024-01-05"},"2024-01-05",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},"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",null,5,"Quinta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","16:00:00"]
[7,{"$f":"B12+1","v":"2024-01-06"},"2024-01-06",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2000,"d":"20:00"},"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",null,6,"Sexta-feira","07:20:00",null,"10:00:00","14:00:00","15:30:00","20:00:00"]
[1,"2024-01-07","2024-01-07",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},"09:00:00","00:15:00","00:02:08.571","00:17:08.571","09:17:08.571","07:20:00","","","01:57:08.571","00:00:00",null,7,"Sábado","07:20:00",null,"12:00:00","16:00:00","17:00:00","22:15:00"]
[2,"2024-01-08","2024-01-08","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-09","2024-01-09",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1445,"d":"14:45"},{"v":1730,"d":"17:30"},"06:45:00","00:00:00","00:00:00","00:00:00","06:45:00","07:20:00","","00:35:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"10:00:00","14:00:00","14:45:00","17:30:00"]
[4,"2024-01-10","2024-01-10",null,{"v":1100,"d":"11:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},"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,"HORÁRIO NOTURNO",null,null,"11:00:00","16:00:00","17:00:00","20:00:00"]
[5,"2024-01-11","2024-01-11",null,{"v":1900,"d":"19:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":500,"d":"05:00"},"01:59:59.712","07:00:00","01:00:00","08:00:00","10:00:00","07:20:00","","","02:40:00","00:00:00",null,null,"Início","22:00:00",null,"19:00:00","21:00:00","22:00:00","05:00:00"]
[6,"2024-01-12","2024-01-12","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[7,"2024-01-13","2024-01-13",null,{"v":500,"d":"05:00"},{"v":800,"d":"08:00"},{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","07:20:00","","01:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"05:00:00","08:00:00","09:00:00","12:00:00"]
[1,"2024-01-14","2024-01-14",null,{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":500,"d":"05:00"},"01:59:59.712","06:00:00","00:51:25.714","06:51:25.714","08:51:25.714","07:20:00","","","01:31:25.714","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"20:00:00","22:00:00","23:00:00","05:00:00"]
[2,"2024-01-15","2024-01-15",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},"06:00:00","02:00:00","00:17:08.571","02:17:08.571","08:17:08.571","07:20:00","","","00:57:08.571","00:00:00",null,null,"Selecione o ano :",2024,null,"15:00:00","19:00:00","20:00:00","00:00:00"]
[3,"2024-01-16","2024-01-16",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",null,null,"Selecione o mês :",1,null,"15:00:00","19:00:00","20:00:00","01:00:00"]
[4,"2024-01-17","2024-01-17",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[5,"2024-01-18","2024-01-18",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"04:59:59.712","05:00:00","00:42:51.429","05:42:51.429","10:42:51.429","07:20:00","","","03:22:51.429","00:00:00",null,null,"Adicional Noturno:",{"$f":"L39","v":2.3928571428571432},null,"16:00:00","19:00:00","20:00:00","03:00:00"]
[6,"2024-01-19","2024-01-19","F",{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":400,"d":"04:00"},"04:59:59.712","06:00:00","00:51:25.714","06:51:25.714","11:51:25.714","00:00:00","","","00:00:00","11:51:25.714",null,null,"Horas Trabalhadas:",{"$f":"M39","v":7.5491071428571415},null,"16:00:00","19:00:00","20:00:00","04:00:00"]
[7,"2024-01-20","2024-01-20",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},"04:59:59.712","00:00:00","00:00:00","00:00:00","05:00:00","07:20:00","","02:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"O39","v":0.4880952380952381},null,"16:00:00","19:00:00","20:00:00","22:00:00"]
[1,"2024-01-21","2024-01-21",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},{"v":500,"d":"05:00"},"03:00:00","05:00:00","00:42:51.429","05:42:51.429","08:42:51.429","07:20:00","","","01:22:51.429","00:00:00",null,null,"Horas Compensadas:",{"$f":"P39","v":2.3586309523809526},null,"17:00:00","20:00:00","00:00:00","05:00:00"]
[2,"2024-01-22","2024-01-22",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"01:59:59.712","00:00:00","00:00:00","00:00:00","02:00:00","07:20:00","","05:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"Q39","v":0.9990079365079367},null,"17:00:00","19:00:00","00:00:00","00:00:00"]
[3,"2024-01-23","2024-01-23",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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":"R39","v":1.4523809523809523},null,"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"},null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:00:00.288","01:00:00","00:08:34.286","01:08:34.286","05:08:34.286","07:20:00","","02:11:25.714","00:00:00","00:00:00",{"$nulls":5},"17:00:00","19:00:00","20:00:00","23:00:00"]
[5,"2024-01-25","2024-01-25","F",{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":700,"d":"07:00"},"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","00:00:00","","","00:00:00","14:00:00",null,null,{"$f":"IF(V28-V29=0,0,(IF(V28-V29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(V28-V29<0,(V28*-1)-(V29*-1),V28-V29)","v":1.3596230158730158},null,"17:00:00","19:00:00","20:00:00","07:00:00"]
[6,"2024-01-26","2024-01-26",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[7,"2024-01-27","2024-01-27","A",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"04:00:00.288","02:00:00","00:17:08.571","02:17:08.571","06:17:08.571","07:20:00","01:02:51.429","","00:00:00","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","01:00:00"]
[1,"2024-01-28","2024-01-28",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":900,"d":"09:00"},"07:59:59.712","06:00:00","00:51:25.714","06:51:25.714","14:51:25.714","07:20:00","","","07:31:25.714","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","09:00:00"]
[2,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2024-01-29"},"2024-01-29",{"$nulls":5},"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"]
[3,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2024-01-30"},"2024-01-30",{"$nulls":5},"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"]
[4,{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":"2024-01-31"},"2024-01-31",{"$nulls":5},"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"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis","repousos","dsr","Total:",{"$f":"SUM(L8:L38)","v":2.3928571428571432},{"$f":"SUM(M8:M38)","v":7.5491071428571415},"Total:",{"$f":"SUM(O8:O38)","v":0.4880952380952381},{"$f":"SUM(P7:P38)","v":2.3586309523809526},{"$f":"SUM(Q7:Q38)","v":0.9990079365079367},{"$f":"SUM(R8:R38)","v":1.4523809523809523}]
[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-I40","v":26},{"$f":"E40+F40","v":5},{"$f":"H40&\"/\"&I40","v":"26/5"},"Decimal:",{"$f":"L39*24","v":{"v":57.42857142857144,"d":"57.43"}},{"$f":"M39*24","v":{"v":181.1785714285714,"d":"181.18"}},"Decimal:",{"$f":"O39*24","v":{"v":11.714285714285714,"d":"11.71"}},{"v":56.60714285714286,"d":"56.61"},{"$f":"Q39*24","v":{"v":23.97619047619048,"d":"23.98"}},{"$f":"R39*24","v":{"v":34.857142857142854,"d":"34.86"}}]
[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":""},{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&I41)","v":""},"Dsr:",{"$f":"L40/$H$40*$I$40","v":{"v":11.043956043956044,"d":"11.04"}}]
[{"$nulls":10},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",L40/H41*I41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",Q40/$H$41*$I$41)","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$I$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2024-01-01"},"Data de início:"]
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($V$22,mês_p,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":"março","index":1,"n_rows":131,"n_cols":27,"rows_kept":131,"merged":[[1,7,2,7],[1,16,3,16],[4,1,4,2],[5,20,6,21],[5,23,5,26],[6,1,6,2],[16,20,16,21],[19,20,19,21],[41,12,41,13]]}
[{"$nulls":4},"março"]
[]
[]
[]
[]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Horas Noturnas","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":13},{"$f":"IF(fevereiro!U32=\"Horas Compensadas\",fevereiro!V32,0)","v":1.3596230158730158},{"$f":"IF(fevereiro!U32=\"Horas Extras\",fevereiro!V32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":5},{"$f":"inicio","v":"2018-03-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2018-03-01"},null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"$f":"IF(B8=\"\",\"\",ROUND(M8-L8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\",G8=\"\",H8=\"\"),0,IF(AND(G8=\"\",H8=\"\"),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8)),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8))+MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(J8/7*8)-J8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",J8+K8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((Y8-X8)+(AA8-Z8),1)+K8)","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$V$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",N8>M8),N8-M8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(M8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(M8<N8,N8-M8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(N8=0,0,MAX(0,M8-N8)))","v":"01:40:00"},{"$f":"IF(B8=\"\",\"\",IF(N8=0,M8,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":"08: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":"18:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":6},{"$f":"B8+1","v":"2018-03-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2018-03-02"},null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"$f":"IF(B9=\"\",\"\",ROUND(M9-L9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(J9/7*8)-J9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",J9+K9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((Y9-X9)+(AA9-Z9),1)+K9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",N9>M9),N9-M9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(M9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(M9<N9,N9-M9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(N9=0,0,MAX(0,M9-N9)))","v":"00:00:00"},"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"}]
[7,{"$f":"B9+1","v":"2018-03-03"},"2018-03-03",null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"04:00:00.288","00:00:00","00:00:00","00:00:00","04:00:00","07:20:00","","03:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"08:00:00","12:00:00","00:00:00","00:00:00"]
[1,{"$f":"B10+1","v":"2018-03-04"},"2018-03-04","F",{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},"07:59:59.712","00:00:00","00:00:00","00:00:00","08:00:00","00:00:00","","","00:00:00","08:00:00",null,4,"Quarta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00"]
[2,{"$f":"B11+1","v":"2018-03-05"},"2018-03-05",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},"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",null,5,"Quinta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","16:00:00"]
[3,{"$f":"B12+1","v":"2018-03-06"},"2018-03-06",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2000,"d":"20:00"},"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",null,6,"Sexta-feira","07:20:00",null,"10:00:00","14:00:00","15:30:00","20:00:00"]
[4,"2018-03-07","2018-03-07",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},"09:00:00","00:15:00","00:02:08.571","00:17:08.571","09:17:08.571","07:20:00","","","01:57:08.571","00:00:00",null,7,"Sábado","07:20:00",null,"12:00:00","16:00:00","17:00:00","22:15:00"]
[5,"2018-03-08","2018-03-08","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2018-03-09","2018-03-09",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1445,"d":"14:45"},{"v":1730,"d":"17:30"},"06:45:00","00:00:00","00:00:00","00:00:00","06:45:00","07:20:00","","00:35:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"10:00:00","14:00:00","14:45:00","17:30:00"]
[7,"2018-03-10","2018-03-10",null,{"v":1100,"d":"11:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},"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,"HORÁRIO NOTURNO",null,null,"11:00:00","16:00:00","17:00:00","20:00:00"]
[1,"2018-03-11","2018-03-11",null,{"v":1900,"d":"19:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":500,"d":"05:00"},"01:59:59.712","07:00:00","01:00:00","08:00:00","10:00:00","07:20:00","","","02:40:00","00:00:00",null,null,"Início","22:00:00",null,"19:00:00","21:00:00","22:00:00","05:00:00"]
[2,"2018-03-12","2018-03-12","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[3,"2018-03-13","2018-03-13",null,{"v":500,"d":"05:00"},{"v":800,"d":"08:00"},{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","07:20:00","","01:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"05:00:00","08:00:00","09:00:00","12:00:00"]
[4,"2018-03-14","2018-03-14",null,{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":500,"d":"05:00"},"01:59:59.712","06:00:00","00:51:25.714","06:51:25.714","08:51:25.714","07:20:00","","","01:31:25.714","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"20:00:00","22:00:00","23:00:00","05:00:00"]
[5,"2018-03-15","2018-03-15",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},"06:00:00","02:00:00","00:17:08.571","02:17:08.571","08:17:08.571","07:20:00","","","00:57:08.571","00:00:00",null,null,"Selecione o ano :",2018,null,"15:00:00","19:00:00","20:00:00","00:00:00"]
[6,"2018-03-16","2018-03-16",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",null,null,"Selecione o mês :",3,null,"15:00:00","19:00:00","20:00:00","01:00:00"]
[7,"2018-03-17","2018-03-17",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"06:00:00","05:00:00","00:42:51.429","05:42:51.429","11:42:51.429","07:20:00","","","04:22:51.429","00:00:00",{"$nulls":5},"15:00:00","19:00:00","20:00:00","03:00:00"]
[1,"2018-03-18","2018-03-18",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"04:59:59.712","05:00:00","00:42:51.429","05:42:51.429","10:42:51.429","07:20:00","","","03:22:51.429","00:00:00",null,null,"Adicional Noturno:",{"$f":"L39","v":3.8095238095238098},null,"16:00:00","19:00:00","20:00:00","03:00:00"]
[2,"2018-03-19","2018-03-19","F",{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":400,"d":"04:00"},"04:59:59.712","06:00:00","00:51:25.714","06:51:25.714","11:51:25.714","00:00:00","","","00:00:00","11:51:25.714",null,null,"Horas Trabalhadas:",{"$f":"M39","v":10.278273809523807},null,"16:00:00","19:00:00","20:00:00","04:00:00"]
[3,"2018-03-20","2018-03-20",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},"04:59:59.712","00:00:00","00:00:00","00:00:00","05:00:00","07:20:00","","02:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"O39","v":0},null,"16:00:00","19:00:00","20:00:00","22:00:00"]
[4,"2018-03-21","2018-03-21",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},{"v":500,"d":"05:00"},"03:00:00","05:00:00","00:42:51.429","05:42:51.429","08:42:51.429","07:20:00","","","01:22:51.429","00:00:00",null,null,"Horas Compensadas:",{"$f":"P39","v":2.3730158730158735},null,"17:00:00","20:00:00","00:00:00","05:00:00"]
[5,"2018-03-22","2018-03-22",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"01:59:59.712","00:00:00","00:00:00","00:00:00","02:00:00","07:20:00","","05:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"Q39","v":1.617063492063492},null,"17:00:00","19:00:00","00:00:00","00:00:00"]
[6,"2018-03-23","2018-03-23",null,{"v":1730,"d":"17:30"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":200,"d":"02:00"},"03:29:59.712","04:00:00","00:34:17.143","04:34:17.143","08:04:17.143","07:20:00","","","00:44:17.143","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"R39","v":2.0357142857142856},null,"17:30:00","19:00:00","20:00:00","02:00:00"]
[7,"2018-03-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2018-03-24"},null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:00:00.288","01:00:00","00:08:34.286","01:08:34.286","05:08:34.286","07:20:00","","02:11:25.714","00:00:00","00:00:00",{"$nulls":5},"17:00:00","19:00:00","20:00:00","23:00:00"]
[1,"2018-03-25","2018-03-25","F",{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":700,"d":"07:00"},"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","00:00:00","","","00:00:00","14:00:00",null,null,{"$f":"IF(V28-V29=0,0,(IF(V28-V29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(V28-V29<0,(V28*-1)-(V29*-1),V28-V29)","v":0.7559523809523814},null,"17:00:00","19:00:00","20:00:00","07:00:00"]
[2,"2018-03-26","2018-03-26",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",{"$nulls":5},"15:00:00","19:00:00","20:00:00","01:00:00"]
[3,"2018-03-27","2018-03-27",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"04:00:00.288","02:00:00","00:17:08.571","02:17:08.571","06:17:08.571","07:20:00","","01:02:51.429","00:00:00","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","01:00:00"]
[4,"2018-03-28","2018-03-28",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":700,"d":"07:00"},"06:00:00","06:00:00","00:51:25.714","06:51:25.714","12:51:25.714","07:20:00","","","05:31:25.714","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","07:00:00"]
[5,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2018-03-29"},"2018-03-29",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2215,"d":"22:15"},{"v":800,"d":"08:00"},"07:00:00.288","06:45:00","00:57:51.429","07:42:51.429","14:42:51.429","07:20:00","","","07:22:51.429","00:00:00",{"$nulls":5},"18:00:00","22:00:00","22:15:00","08:00:00"]
[6,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2018-03-30"},"2018-03-30","F",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2200,"d":"22:00"},{"v":800,"d":"08:00"},"07:00:00.288","07:00:00","01:00:00","08:00:00","15:00:00","00:00:00","","","00:00:00","15:00:00",{"$nulls":5},"18:00:00","22:00:00","22:00:00","08:00:00"]
[7,{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":"2018-03-31"},"2018-03-31",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2100,"d":"21:00"},{"v":200,"d":"02:00"},"04:00:00.288","04:00:00","00:34:17.143","04:34:17.143","08:34:17.143","07:20:00","","","01:14:17.143","00:00:00",{"$nulls":5},"17:00:00","20:00:00","21:00:00","02:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis","repousos","dsr","Total:",{"$f":"SUM(L8:L38)","v":3.8095238095238098},{"$f":"SUM(M8:M38)","v":10.278273809523807},"Total:",{"$f":"SUM(O8:O38)","v":0},{"$f":"SUM(P7:P38)","v":2.3730158730158735},{"$f":"SUM(Q7:Q38)","v":1.617063492063492},{"$f":"SUM(R8:R38)","v":2.0357142857142856}]
[null,{"$f":"B8","v":"2018-03-01"},{"$f":"MAX(B8:B38)","v":"2018-03-31"},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":31},{"$f":"G40-I40","v":27},{"$f":"E40+F40","v":4},{"$f":"H40&\"/\"&I40","v":"27/4"},"Decimal:",{"$f":"L39*24","v":{"v":91.42857142857143,"d":"91.43"}},{"$f":"M39*24","v":{"v":246.67857142857136,"d":"246.68"}},"Decimal:",{"$f":"O39*24","v":{"v":0,"d":"0.00"}},{"v":56.95238095238096,"d":"56.95"},{"$f":"Q39*24","v":{"v":38.80952380952381,"d":"38.81"}},{"$f":"R39*24","v":{"v":48.857142857142854,"d":"48.86"}}]
[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":""},{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&I41)","v":""},"Dsr:",{"$f":"L40/$H$40*$I$40","v":{"v":13.544973544973546,"d":"13.54"}}]
[{"$nulls":10},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",L40/H41*I41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",Q40/$H$41*$I$41)","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$I$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2018-03-01"},"Data de início:"]
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($V$22,mês_p,dia_f)))","v":"2018-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":"abril","index":2,"n_rows":131,"n_cols":27,"rows_kept":131,"merged":[[1,7,2,7],[1,16,3,16],[4,1,4,2],[5,20,6,21],[5,23,5,26],[6,1,6,2],[16,20,16,21],[19,20,19,21],[41,12,41,13]]}
[{"$nulls":4},"abril"]
[]
[]
[]
[]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Horas Noturnas","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":13},{"$f":"IF(março!U32=\"Horas Compensadas\",março!V32,0)","v":0.7559523809523814},{"$f":"IF(março!U32=\"Horas Extras\",março!V32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":1},{"$f":"inicio","v":"2018-04-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2018-04-01"},"F",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"$f":"IF(B8=\"\",\"\",ROUND(M8-L8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\",G8=\"\",H8=\"\"),0,IF(AND(G8=\"\",H8=\"\"),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8)),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8))+MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(J8/7*8)-J8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",J8+K8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((Y8-X8)+(AA8-Z8),1)+K8)","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$V$16,VLOOKUP(A8,jornada,3)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",N8>M8),N8-M8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(M8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(M8<N8,N8-M8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(N8=0,0,MAX(0,M8-N8)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(N8=0,M8,0))","v":"09:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"08: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":"18:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":2},{"$f":"B8+1","v":"2018-04-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2018-04-02"},"A",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"$f":"IF(B9=\"\",\"\",ROUND(M9-L9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(J9/7*8)-J9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",J9+K9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((Y9-X9)+(AA9-Z9),1)+K9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",N9>M9),N9-M9,\"\"))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(AND(M9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(M9<N9,N9-M9,\"\"))))","v":""},{"$f":"IF(B9=\"\",\"\",IF(N9=0,0,MAX(0,M9-N9)))","v":"00:00:00"},"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"}]
[3,{"$f":"B9+1","v":"2018-04-03"},"2018-04-03",null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"04:00:00.288","00:00:00","00:00:00","00:00:00","04:00:00","07:20:00","","03:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"08:00:00","12:00:00","00:00:00","00:00:00"]
[4,{"$f":"B10+1","v":"2018-04-04"},"2018-04-04",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},"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,4,"Quarta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00"]
[5,{"$f":"B11+1","v":"2018-04-05"},"2018-04-05",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},"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",null,5,"Quinta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","16:00:00"]
[6,{"$f":"B12+1","v":"2018-04-06"},"2018-04-06",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2000,"d":"20:00"},"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",null,6,"Sexta-feira","07:20:00",null,"10:00:00","14:00:00","15:30:00","20:00:00"]
[7,"2018-04-07","2018-04-07",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},"09:00:00","00:15:00","00:02:08.571","00:17:08.571","09:17:08.571","07:20:00","","","01:57:08.571","00:00:00",null,7,"Sábado","07:20:00",null,"12:00:00","16:00:00","17:00:00","22:15:00"]
[1,"2018-04-08","2018-04-08","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2018-04-09","2018-04-09",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1445,"d":"14:45"},{"v":1730,"d":"17:30"},"06:45:00","00:00:00","00:00:00","00:00:00","06:45:00","07:20:00","","00:35:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"10:00:00","14:00:00","14:45:00","17:30:00"]
[3,"2018-04-10","2018-04-10",null,{"v":1100,"d":"11:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},"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,"HORÁRIO NOTURNO",null,null,"11:00:00","16:00:00","17:00:00","20:00:00"]
[4,"2018-04-11","2018-04-11",null,{"v":1900,"d":"19:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":500,"d":"05:00"},"01:59:59.712","07:00:00","01:00:00","08:00:00","10:00:00","07:20:00","","","02:40:00","00:00:00",null,null,"Início","22:00:00",null,"19:00:00","21:00:00","22:00:00","05:00:00"]
[5,"2018-04-12","2018-04-12","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[6,"2018-04-13","2018-04-13",null,{"v":500,"d":"05:00"},{"v":800,"d":"08:00"},{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","07:20:00","","01:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"05:00:00","08:00:00","09:00:00","12:00:00"]
[7,"2018-04-14","2018-04-14",null,{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":500,"d":"05:00"},"01:59:59.712","06:00:00","00:51:25.714","06:51:25.714","08:51:25.714","07:20:00","","","01:31:25.714","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"20:00:00","22:00:00","23:00:00","05:00:00"]
[1,"2018-04-15","2018-04-15",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},"06:00:00","02:00:00","00:17:08.571","02:17:08.571","08:17:08.571","07:20:00","","","00:57:08.571","00:00:00",null,null,"Selecione o ano :",2018,null,"15:00:00","19:00:00","20:00:00","00:00:00"]
[2,"2018-04-16","2018-04-16",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",null,null,"Selecione o mês :",4,null,"15:00:00","19:00:00","20:00:00","01:00:00"]
[3,"2018-04-17","2018-04-17",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[4,"2018-04-18","2018-04-18",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"04:59:59.712","05:00:00","00:42:51.429","05:42:51.429","10:42:51.429","07:20:00","","","03:22:51.429","00:00:00",null,null,"Adicional Noturno:",{"$f":"L39","v":3.2380952380952386},null,"16:00:00","19:00:00","20:00:00","03:00:00"]
[5,"2018-04-19","2018-04-19","F",{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":400,"d":"04:00"},"04:59:59.712","06:00:00","00:51:25.714","06:51:25.714","11:51:25.714","00:00:00","","","00:00:00","11:51:25.714",null,null,"Horas Trabalhadas:",{"$f":"M39","v":9.186011904761903},null,"16:00:00","19:00:00","20:00:00","04:00:00"]
[6,"2018-04-20","2018-04-20",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:59:59.712","01:00:00","00:08:34.286","01:08:34.286","06:08:34.286","07:20:00","","01:11:25.714","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"O39","v":0.3055555555555555},null,"16:00:00","19:00:00","20:00:00","23:00:00"]
[7,"2018-04-21","2018-04-21",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},{"v":500,"d":"05:00"},"03:00:00","05:00:00","00:42:51.429","05:42:51.429","08:42:51.429","07:20:00","","","01:22:51.429","00:00:00",null,null,"Horas Compensadas:",{"$f":"P39","v":2.027281746031747},null,"17:00:00","20:00:00","00:00:00","05:00:00"]
[1,"2018-04-22","2018-04-22",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"01:59:59.712","00:00:00","00:00:00","00:00:00","02:00:00","07:20:00","","05:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"Q39","v":1.35218253968254},null,"17:00:00","19:00:00","00:00:00","00:00:00"]
[2,"2018-04-23","2018-04-23",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"04:59:59.712","03:00:00","00:25:42.857","03:25:42.857","08:25:42.857","07:20:00","","","01:05:42.857","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"R39","v":2.0773809523809526},null,"16:00:00","19:00:00","20:00:00","01:00:00"]
[3,"2018-04-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2018-04-24"},null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:00:00.288","01:00:00","00:08:34.286","01:08:34.286","05:08:34.286","07:20:00","","02:11:25.714","00:00:00","00:00:00",{"$nulls":5},"17:00:00","19:00:00","20:00:00","23:00:00"]
[4,"2018-04-25","2018-04-25","F",{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":700,"d":"07:00"},"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","00:00:00","","","00:00:00","14:00:00",null,null,{"$f":"IF(V28-V29=0,0,(IF(V28-V29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(V28-V29<0,(V28*-1)-(V29*-1),V28-V29)","v":0.675099206349207},null,"17:00:00","19:00:00","20:00:00","07:00:00"]
[5,"2018-04-26","2018-04-26",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[6,"2018-04-27","2018-04-27",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"04:00:00.288","02:00:00","00:17:08.571","02:17:08.571","06:17:08.571","07:20:00","","01:02:51.429","00:00:00","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","01:00:00"]
[7,"2018-04-28","2018-04-28",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":900,"d":"09:00"},"07:59:59.712","06:00:00","00:51:25.714","06:51:25.714","14:51:25.714","07:20:00","","","07:31:25.714","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","09:00:00"]
[1,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2018-04-29"},"2018-04-29",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2215,"d":"22:15"},{"v":800,"d":"08:00"},"07:00:00.288","06:45:00","00:57:51.429","07:42:51.429","14:42:51.429","07:20:00","","","07:22:51.429","00:00:00",{"$nulls":5},"18:00:00","22:00:00","22:15:00","08:00:00"]
[2,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2018-04-30"},"2018-04-30","F",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2200,"d":"22:00"},{"v":800,"d":"08:00"},"07:00:00.288","07:00:00","01:00:00","08:00:00","15:00:00","00:00:00","","","00:00:00","15:00:00",{"$nulls":5},"18:00:00","22:00:00","22:00:00","08:00:00"]
["",{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":""},"",{"$nulls":5},"","","","","","","","","","",{"$nulls":5},"","","",""]
[null,"Início","Término",null,"fer","dom","mês","dias úteis","repousos","dsr","Total:",{"$f":"SUM(L8:L38)","v":3.2380952380952386},{"$f":"SUM(M8:M38)","v":9.186011904761903},"Total:",{"$f":"SUM(O8:O38)","v":0.3055555555555555},{"$f":"SUM(P7:P38)","v":2.027281746031747},{"$f":"SUM(Q7:Q38)","v":1.35218253968254},{"$f":"SUM(R8:R38)","v":2.0773809523809526}]
[null,{"$f":"B8","v":"2018-04-01"},{"$f":"MAX(B8:B38)","v":"2018-04-30"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":0},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":5},{"$f":"C40-B40+1","v":30},{"$f":"G40-I40","v":25},{"$f":"E40+F40","v":5},{"$f":"H40&\"/\"&I40","v":"25/5"},"Decimal:",{"$f":"L39*24","v":{"v":77.71428571428572,"d":"77.71"}},{"$f":"M39*24","v":{"v":220.46428571428567,"d":"220.46"}},"Decimal:",{"$f":"O39*24","v":{"v":7.333333333333332,"d":"7.33"}},{"v":48.654761904761926,"d":"48.65"},{"$f":"Q39*24","v":{"v":32.45238095238096,"d":"32.45"}},{"$f":"R39*24","v":{"v":49.85714285714286,"d":"49.86"}}]
[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":""},{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&I41)","v":""},"Dsr:",{"$f":"L40/$H$40*$I$40","v":{"v":15.542857142857144,"d":"15.54"}}]
[{"$nulls":10},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",L40/H41*I41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",Q40/$H$41*$I$41)","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$I$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2018-04-01"},"Data de início:"]
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($V$22,mês_p,dia_f)))","v":"2018-04-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":"maio","index":3,"n_rows":131,"n_cols":27,"rows_kept":131,"merged":[[1,7,2,7],[1,16,3,16],[4,1,4,2],[5,20,6,21],[5,23,5,26],[6,1,6,2],[16,20,16,21],[19,20,19,21],[41,12,41,13]]}
[{"$nulls":4},"maio"]
[]
[]
[]
[]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Horas Noturnas","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":13},{"$f":"IF(abril!U32=\"Horas Compensadas\",abril!V32,0)","v":0.675099206349207},{"$f":"IF(abril!U32=\"Horas Extras\",abril!V32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":3},{"$f":"inicio","v":"2018-05-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2018-05-01"},"F",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"$f":"IF(B8=\"\",\"\",ROUND(M8-L8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\",G8=\"\",H8=\"\"),0,IF(AND(G8=\"\",H8=\"\"),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8)),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8))+MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(J8/7*8)-J8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",J8+K8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((Y8-X8)+(AA8-Z8),1)+K8)","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$V$16,VLOOKUP(A8,jornada,3)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",N8>M8),N8-M8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(M8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(M8<N8,N8-M8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(N8=0,0,MAX(0,M8-N8)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(N8=0,M8,0))","v":"09:00:00"},null,1,"domingo","07:20:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"08: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":"18:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":4},{"$f":"B8+1","v":"2018-05-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2018-05-02"},null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":2000,"d":"20:00"},{"$f":"IF(B9=\"\",\"\",ROUND(M9-L9,5))","v":"10:59:59.712"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(J9/7*8)-J9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",J9+K9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((Y9-X9)+(AA9-Z9),1)+K9)","v":"11:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",N9>M9),N9-M9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(M9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(M9<N9,N9-M9,\"\"))))","v":""},{"$f":"IF(B9=\"\",\"\",IF(N9=0,0,MAX(0,M9-N9)))","v":"03:40:00"},"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":"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":"20:00:00"}]
[5,{"$f":"B9+1","v":"2018-05-03"},"2018-05-03",null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1930,"d":"19:30"},"10:30:00","00:00:00","00:00:00","00:00:00","10:30:00","07:20:00","","","03:10:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"08:00:00","12:00:00","13:00:00","19:30:00"]
[6,{"$f":"B10+1","v":"2018-05-04"},"2018-05-04",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},"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,4,"Quarta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00"]
[7,{"$f":"B11+1","v":"2018-05-05"},"2018-05-05",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},"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",null,5,"Quinta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","16:00:00"]
[1,{"$f":"B12+1","v":"2018-05-06"},"2018-05-06","F",{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2000,"d":"20:00"},"08:30:00.288","00:00:00","00:00:00","00:00:00","08:30:00","00:00:00","","","00:00:00","08:30:00",null,6,"Sexta-feira","07:20:00",null,"10:00:00","14:00:00","15:30:00","20:00:00"]
[2,"2018-05-07","2018-05-07",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},"09:00:00","00:15:00","00:02:08.571","00:17:08.571","09:17:08.571","07:20:00","","","01:57:08.571","00:00:00",null,7,"Sábado","07:20:00",null,"12:00:00","16:00:00","17:00:00","22:15:00"]
[3,"2018-05-08","2018-05-08",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[4,"2018-05-09","2018-05-09",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1445,"d":"14:45"},{"v":1730,"d":"17:30"},"06:45:00","00:00:00","00:00:00","00:00:00","06:45:00","07:20:00","","00:35:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"10:00:00","14:00:00","14:45:00","17:30:00"]
[5,"2018-05-10","2018-05-10",null,{"v":1100,"d":"11:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},"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,"HORÁRIO NOTURNO",null,null,"11:00:00","16:00:00","17:00:00","20:00:00"]
[6,"2018-05-11","2018-05-11",null,{"v":1900,"d":"19:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":500,"d":"05:00"},"01:59:59.712","07:00:00","01:00:00","08:00:00","10:00:00","07:20:00","","","02:40:00","00:00:00",null,null,"Início","22:00:00",null,"19:00:00","21:00:00","22:00:00","05:00:00"]
[7,"2018-05-12","2018-05-12","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[1,"2018-05-13","2018-05-13",null,{"v":500,"d":"05:00"},{"v":800,"d":"08:00"},{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","07:20:00","","01:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"05:00:00","08:00:00","09:00:00","12:00:00"]
[2,"2018-05-14","2018-05-14",null,{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":500,"d":"05:00"},"01:59:59.712","06:00:00","00:51:25.714","06:51:25.714","08:51:25.714","07:20:00","","","01:31:25.714","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"20:00:00","22:00:00","23:00:00","05:00:00"]
[3,"2018-05-15","2018-05-15",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},"06:00:00","02:00:00","00:17:08.571","02:17:08.571","08:17:08.571","07:20:00","","","00:57:08.571","00:00:00",null,null,"Selecione o ano :",2018,null,"15:00:00","19:00:00","20:00:00","00:00:00"]
[4,"2018-05-16","2018-05-16",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",null,null,"Selecione o mês :",5,null,"15:00:00","19:00:00","20:00:00","01:00:00"]
[5,"2018-05-17","2018-05-17",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2330,"d":"23:30"},"06:00:00","01:30:00","00:12:51.429","01:42:51.429","07:42:51.429","07:20:00","","","00:22:51.429","00:00:00",{"$nulls":5},"15:00:00","19:00:00","20:00:00","23:30:00"]
[6,"2018-05-18","2018-05-18",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"04:59:59.712","05:00:00","00:42:51.429","05:42:51.429","10:42:51.429","07:20:00","","","03:22:51.429","00:00:00",null,null,"Adicional Noturno:",{"$f":"L39","v":3.4047619047619055},null,"16:00:00","19:00:00","20:00:00","03:00:00"]
[7,"2018-05-19","2018-05-19","F",{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":400,"d":"04:00"},"04:59:59.712","06:00:00","00:51:25.714","06:51:25.714","11:51:25.714","00:00:00","","","00:00:00","11:51:25.714",null,null,"Horas Trabalhadas:",{"$f":"M39","v":10.29017857142857},null,"16:00:00","19:00:00","20:00:00","04:00:00"]
[1,"2018-05-20","2018-05-20",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},"04:59:59.712","00:00:00","00:00:00","00:00:00","05:00:00","07:20:00","","02:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"O39","v":0.04365079365079372},null,"16:00:00","19:00:00","20:00:00","22:00:00"]
[2,"2018-05-21","2018-05-21",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},{"v":500,"d":"05:00"},"03:00:00","05:00:00","00:42:51.429","05:42:51.429","08:42:51.429","07:20:00","","","01:22:51.429","00:00:00",null,null,"Horas Compensadas:",{"$f":"P39","v":2.117063492063493},null,"17:00:00","20:00:00","00:00:00","05:00:00"]
[3,"2018-05-22","2018-05-22",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"01:59:59.712","00:00:00","00:00:00","00:00:00","02:00:00","07:20:00","","05:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"Q39","v":1.5585317460317463},null,"17:00:00","19:00:00","00:00:00","00:00:00"]
[4,"2018-05-23","2018-05-23",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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":"R39","v":2.8839285714285716},null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2018-05-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2018-05-24"},null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:00:00.288","01:00:00","00:08:34.286","01:08:34.286","05:08:34.286","07:20:00","","02:11:25.714","00:00:00","00:00:00",{"$nulls":5},"17:00:00","19:00:00","20:00:00","23:00:00"]
[6,"2018-05-25","2018-05-25","F",{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":700,"d":"07:00"},"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","00:00:00","","","00:00:00","14:00:00",null,null,{"$f":"IF(V28-V29=0,0,(IF(V28-V29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(V28-V29<0,(V28*-1)-(V29*-1),V28-V29)","v":0.5585317460317467},null,"17:00:00","19:00:00","20:00:00","07:00:00"]
[7,"2018-05-26","2018-05-26",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[1,"2018-05-27","2018-05-27","A",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"04:00:00.288","02:00:00","00:17:08.571","02:17:08.571","06:17:08.571","07:20:00","01:02:51.429","","00:00:00","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","01:00:00"]
[2,"2018-05-28","2018-05-28",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":900,"d":"09:00"},"07:59:59.712","06:00:00","00:51:25.714","06:51:25.714","14:51:25.714","07:20:00","","","07:31:25.714","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","09:00:00"]
[3,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2018-05-29"},"2018-05-29",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2215,"d":"22:15"},{"v":800,"d":"08:00"},"07:00:00.288","06:45:00","00:57:51.429","07:42:51.429","14:42:51.429","07:20:00","","","07:22:51.429","00:00:00",{"$nulls":5},"18:00:00","22:00:00","22:15:00","08:00:00"]
[4,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2018-05-30"},"2018-05-30","F",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2200,"d":"22:00"},{"v":800,"d":"08:00"},"07:00:00.288","07:00:00","01:00:00","08:00:00","15:00:00","00:00:00","","","00:00:00","15:00:00",{"$nulls":5},"18:00:00","22:00:00","22:00:00","08:00:00"]
[5,{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":"2018-05-31"},"2018-05-31","F",{"v":1700,"d":"17:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":400,"d":"04:00"},"04:00:00.288","06:00:00","00:51:25.714","06:51:25.714","10:51:25.714","00:00:00","","","00:00:00","10:51:25.714",{"$nulls":5},"17:00:00","21:00:00","22:00:00","04:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis","repousos","dsr","Total:",{"$f":"SUM(L8:L38)","v":3.4047619047619055},{"$f":"SUM(M8:M38)","v":10.29017857142857},"Total:",{"$f":"SUM(O8:O38)","v":0.04365079365079372},{"$f":"SUM(P7:P38)","v":2.117063492063493},{"$f":"SUM(Q7:Q38)","v":1.5585317460317463},{"$f":"SUM(R8:R38)","v":2.8839285714285716}]
[null,{"$f":"B8","v":"2018-05-01"},{"$f":"MAX(B8:B38)","v":"2018-05-31"},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":31},{"$f":"G40-I40","v":27},{"$f":"E40+F40","v":4},{"$f":"H40&\"/\"&I40","v":"27/4"},"Decimal:",{"$f":"L39*24","v":{"v":81.71428571428574,"d":"81.71"}},{"$f":"M39*24","v":{"v":246.96428571428567,"d":"246.96"}},"Decimal:",{"$f":"O39*24","v":{"v":1.0476190476190492,"d":"1.05"}},{"v":50.80952380952383,"d":"50.81"},{"$f":"Q39*24","v":{"v":37.40476190476191,"d":"37.40"}},{"$f":"R39*24","v":{"v":69.21428571428572,"d":"69.21"}}]
[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":""},{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&I41)","v":""},"Dsr:",{"$f":"L40/$H$40*$I$40","v":{"v":12.10582010582011,"d":"12.11"}}]
[{"$nulls":10},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",L40/H41*I41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",Q40/$H$41*$I$41)","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$I$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2018-05-01"},"Data de início:"]
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($V$22,mês_p,dia_f)))","v":"2018-05-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":"junho","index":4,"n_rows":131,"n_cols":27,"rows_kept":131,"merged":[[1,7,2,7],[1,16,3,16],[4,1,4,2],[5,20,6,21],[5,23,5,26],[6,1,6,2],[16,20,16,21],[19,20,19,21],[41,12,41,13]]}
[{"$nulls":4},"junho"]
[]
[]
[]
[]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Horas Noturnas","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":13},{"$f":"IF(maio!U32=\"Horas Compensadas\",maio!V32,0)","v":0.5585317460317467},{"$f":"IF(maio!U32=\"Horas Extras\",maio!V32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":6},{"$f":"inicio","v":"2018-06-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2018-06-01"},null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"$f":"IF(B8=\"\",\"\",ROUND(M8-L8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\",G8=\"\",H8=\"\"),0,IF(AND(G8=\"\",H8=\"\"),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8)),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8))+MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(J8/7*8)-J8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",J8+K8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((Y8-X8)+(AA8-Z8),1)+K8)","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$V$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",N8>M8),N8-M8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(M8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(M8<N8,N8-M8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(N8=0,0,MAX(0,M8-N8)))","v":"01:40:00"},{"$f":"IF(B8=\"\",\"\",IF(N8=0,M8,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":"08: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":"18:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":7},{"$f":"B8+1","v":"2018-06-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2018-06-02"},null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"$f":"IF(B9=\"\",\"\",ROUND(M9-L9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(J9/7*8)-J9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",J9+K9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((Y9-X9)+(AA9-Z9),1)+K9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",N9>M9),N9-M9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(M9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(M9<N9,N9-M9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(N9=0,0,MAX(0,M9-N9)))","v":"00:00:00"},"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"}]
[1,{"$f":"B9+1","v":"2018-06-03"},"2018-06-03","F",{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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",null,3,"Terça-feira","07:20:00",null,"08:00:00","12:00:00","00:00:00","00:00:00"]
[2,{"$f":"B10+1","v":"2018-06-04"},"2018-06-04",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},"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,4,"Quarta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00"]
[3,{"$f":"B11+1","v":"2018-06-05"},"2018-06-05",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},"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",null,5,"Quinta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","16:00:00"]
[4,{"$f":"B12+1","v":"2018-06-06"},"2018-06-06","A",{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"04:00:00.288","00:00:00","00:00:00","00:00:00","04:00:00","07:20:00","03:20:00","","00:00:00","00:00:00",null,6,"Sexta-feira","07:20:00",null,"10:00:00","14:00:00","00:00:00","00:00:00"]
[5,"2018-06-07","2018-06-07",null,{"v":1200,"d":"12:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2215,"d":"22:15"},"09:00:00","00:15:00","00:02:08.571","00:17:08.571","09:17:08.571","07:20:00","","","01:57:08.571","00:00:00",null,7,"Sábado","07:20:00",null,"12:00:00","16:00:00","17:00:00","22:15:00"]
[6,"2018-06-08","2018-06-08","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2018-06-09","2018-06-09",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1445,"d":"14:45"},{"v":1730,"d":"17:30"},"06:45:00","00:00:00","00:00:00","00:00:00","06:45:00","07:20:00","","00:35:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"10:00:00","14:00:00","14:45:00","17:30:00"]
[1,"2018-06-10","2018-06-10",null,{"v":1100,"d":"11:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},"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,"HORÁRIO NOTURNO",null,null,"11:00:00","16:00:00","17:00:00","20:00:00"]
[2,"2018-06-11","2018-06-11",null,{"v":1900,"d":"19:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":500,"d":"05:00"},"01:59:59.712","07:00:00","01:00:00","08:00:00","10:00:00","07:20:00","","","02:40:00","00:00:00",null,null,"Início","22:00:00",null,"19:00:00","21:00:00","22:00:00","05:00:00"]
[3,"2018-06-12","2018-06-12","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[4,"2018-06-13","2018-06-13",null,{"v":500,"d":"05:00"},{"v":800,"d":"08:00"},{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","07:20:00","","01:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"05:00:00","08:00:00","09:00:00","12:00:00"]
[5,"2018-06-14","2018-06-14",null,{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":500,"d":"05:00"},"01:59:59.712","06:00:00","00:51:25.714","06:51:25.714","08:51:25.714","07:20:00","","","01:31:25.714","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"20:00:00","22:00:00","23:00:00","05:00:00"]
[6,"2018-06-15","2018-06-15","A",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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,"Selecione o ano :",2018,null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2018-06-16","2018-06-16",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",null,null,"Selecione o mês :",6,null,"15:00:00","19:00:00","20:00:00","01:00:00"]
[1,"2018-06-17","2018-06-17",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[2,"2018-06-18","2018-06-18",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"04:59:59.712","05:00:00","00:42:51.429","05:42:51.429","10:42:51.429","07:20:00","","","03:22:51.429","00:00:00",null,null,"Adicional Noturno:",{"$f":"L39","v":2.9523809523809526},null,"16:00:00","19:00:00","20:00:00","03:00:00"]
[3,"2018-06-19","2018-06-19","F",{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":400,"d":"04:00"},"04:59:59.712","06:00:00","00:51:25.714","06:51:25.714","11:51:25.714","00:00:00","","","00:00:00","11:51:25.714",null,null,"Horas Trabalhadas:",{"$f":"M39","v":8.254464285714285},null,"16:00:00","19:00:00","20:00:00","04:00:00"]
[4,"2018-06-20","2018-06-20",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},"04:59:59.712","00:00:00","00:00:00","00:00:00","05:00:00","07:20:00","","02:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"O39","v":0.4880952380952381},null,"16:00:00","19:00:00","20:00:00","22:00:00"]
[5,"2018-06-21","2018-06-21",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},{"v":500,"d":"05:00"},"03:00:00","05:00:00","00:42:51.429","05:42:51.429","08:42:51.429","07:20:00","","","01:22:51.429","00:00:00",null,null,"Horas Compensadas:",{"$f":"P39","v":2.3060515873015883},null,"17:00:00","20:00:00","00:00:00","05:00:00"]
[6,"2018-06-22","2018-06-22",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"01:59:59.712","00:00:00","00:00:00","00:00:00","02:00:00","07:20:00","","05:20:00","00:00:00","00:00:00",null,null,"Horas Extras:",{"$f":"Q39","v":1.287698412698413},null,"17:00:00","19:00:00","00:00:00","00:00:00"]
[7,"2018-06-23","2018-06-23",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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":"R39","v":1.869047619047619},null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2018-06-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2018-06-24"},null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:00:00.288","01:00:00","00:08:34.286","01:08:34.286","05:08:34.286","07:20:00","","02:11:25.714","00:00:00","00:00:00",{"$nulls":5},"17:00:00","19:00:00","20:00:00","23:00:00"]
[2,"2018-06-25","2018-06-25","F",{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":700,"d":"07:00"},"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","00:00:00","","","00:00:00","14:00:00",null,null,{"$f":"IF(V28-V29=0,0,(IF(V28-V29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(V28-V29<0,(V28*-1)-(V29*-1),V28-V29)","v":1.0183531746031753},null,"17:00:00","19:00:00","20:00:00","07:00:00"]
[3,"2018-06-26","2018-06-26",null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[4,"2018-06-27","2018-06-27","A",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"04:00:00.288","02:00:00","00:17:08.571","02:17:08.571","06:17:08.571","07:20:00","01:02:51.429","","00:00:00","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","01:00:00"]
[5,"2018-06-28","2018-06-28",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":900,"d":"09:00"},"07:59:59.712","06:00:00","00:51:25.714","06:51:25.714","14:51:25.714","07:20:00","","","07:31:25.714","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","09:00:00"]
[6,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2018-06-29"},"2018-06-29",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2215,"d":"22:15"},{"v":800,"d":"08:00"},"07:00:00.288","06:45:00","00:57:51.429","07:42:51.429","14:42:51.429","07:20:00","","","07:22:51.429","00:00:00",{"$nulls":5},"18:00:00","22:00:00","22:15:00","08:00:00"]
[7,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2018-06-30"},"2018-06-30","F",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2200,"d":"22:00"},{"v":800,"d":"08:00"},"07:00:00.288","07:00:00","01:00:00","08:00:00","15:00:00","00:00:00","","","00:00:00","15:00:00",{"$nulls":5},"18:00:00","22:00:00","22:00:00","08:00:00"]
["",{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":""},"",{"$nulls":5},"","","","","","","","","","",{"$nulls":5},"","","",""]
[null,"Início","Término",null,"fer","dom","mês","dias úteis","repousos","dsr","Total:",{"$f":"SUM(L8:L38)","v":2.9523809523809526},{"$f":"SUM(M8:M38)","v":8.254464285714285},"Total:",{"$f":"SUM(O8:O38)","v":0.4880952380952381},{"$f":"SUM(P7:P38)","v":2.3060515873015883},{"$f":"SUM(Q7:Q38)","v":1.287698412698413},{"$f":"SUM(R8:R38)","v":1.869047619047619}]
[null,{"$f":"B8","v":"2018-06-01"},{"$f":"MAX(B8:B38)","v":"2018-06-30"},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":30},{"$f":"G40-I40","v":26},{"$f":"E40+F40","v":4},{"$f":"H40&\"/\"&I40","v":"26/4"},"Decimal:",{"$f":"L39*24","v":{"v":70.85714285714286,"d":"70.86"}},{"$f":"M39*24","v":{"v":198.10714285714283,"d":"198.11"}},"Decimal:",{"$f":"O39*24","v":{"v":11.714285714285714,"d":"11.71"}},{"v":55.345238095238116,"d":"55.35"},{"$f":"Q39*24","v":{"v":30.904761904761912,"d":"30.90"}},{"$f":"R39*24","v":{"v":44.85714285714286,"d":"44.86"}}]
[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":""},{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&I41)","v":""},"Dsr:",{"$f":"L40/$H$40*$I$40","v":{"v":10.901098901098901,"d":"10.90"}}]
[{"$nulls":10},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",L40/H41*I41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",Q40/$H$41*$I$41)","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$I$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2018-06-01"},"Data de início:"]
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($V$22,mês_p,dia_f)))","v":"2018-06-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":"julho","index":5,"n_rows":131,"n_cols":27,"rows_kept":131,"merged":[[1,7,2,7],[1,16,3,16],[4,1,4,2],[5,20,6,21],[5,23,5,26],[6,1,6,2],[16,20,16,21],[19,20,19,21],[41,12,41,13]]}
[{"$nulls":4},"julho"]
[]
[]
[]
[]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Horas Noturnas","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":13},{"$f":"IF(junho!U32=\"Horas Compensadas\",junho!V32,0)","v":1.0183531746031753},{"$f":"IF(junho!U32=\"Horas Extras\",junho!V32,0)","v":0},{"$nulls":6},"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":1},{"$f":"inicio","v":"2018-07-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"2018-07-01"},null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},{"$f":"IF(B8=\"\",\"\",ROUND(M8-L8,5))","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\",G8=\"\",H8=\"\"),0,IF(AND(G8=\"\",H8=\"\"),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8)),MAX(ININOT,MIN(FIMNOT+1,Y8+(X8>Y8)))-MAX(ININOT,X8)+(MIN(FIMNOT,Y8+(X8>Y8))-MIN(FIMNOT,X8))+MAX(ININOT,MIN(FIMNOT+1,AA8+(Z8>AA8)))-MAX(ININOT,Z8)+(MIN(FIMNOT,AA8+(Z8>AA8))-MIN(FIMNOT,Z8)))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",(J8/7*8)-J8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",J8+K8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((Y8-X8)+(AA8-Z8),1)+K8)","v":"09:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$V$16,VLOOKUP(A8,jornada,3)))","v":"07:20:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",N8>M8),N8-M8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(M8>0,D8=\"F\"),\"\",IF(D8=\"A\",\"\",IF(M8<N8,N8-M8,\"\"))))","v":""},{"$f":"IF(B8=\"\",\"\",IF(N8=0,0,MAX(0,M8-N8)))","v":"01:40:00"},{"$f":"IF(B8=\"\",\"\",IF(N8=0,M8,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":"08: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":"18:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":2},{"$f":"B8+1","v":"2018-07-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2018-07-02"},null,{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"$f":"IF(B9=\"\",\"\",ROUND(M9-L9,5))","v":"00:00:00"},"00:00:00",{"$f":"IF(B9=\"\",\"\",(J9/7*8)-J9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",J9+K9)","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",MOD((Y9-X9)+(AA9-Z9),1)+K9)","v":"00:00:00"},"07:20:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",N9>M9),N9-M9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(M9>0,D9=\"F\"),\"\",IF(D9=\"A\",\"\",IF(M9<N9,N9-M9,\"\"))))","v":"07:20:00"},{"$f":"IF(B9=\"\",\"\",IF(N9=0,0,MAX(0,M9-N9)))","v":"00:00:00"},"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"}]
[3,{"$f":"B9+1","v":"2018-07-03"},"2018-07-03",null,{"v":800,"d":"08:00"},{"v":1200,"d":"12:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"04:00:00.288","00:00:00","00:00:00","00:00:00","04:00:00","07:20:00","","03:20:00","00:00:00","00:00:00",null,3,"Terça-feira","07:20:00",null,"08:00:00","12:00:00","00:00:00","00:00:00"]
[4,{"$f":"B10+1","v":"2018-07-04"},"2018-07-04",null,{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},{"v":1300,"d":"13:00"},{"v":1800,"d":"18:00"},"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,4,"Quarta-feira","07:20:00",null,"09:00:00","12:00:00","13:00:00","18:00:00"]
[5,{"$f":"B11+1","v":"2018-07-05"},"2018-07-05",null,{"v":900,"d":"09:00"},{"v":1300,"d":"13:00"},{"v":1330,"d":"13:30"},{"v":1600,"d":"16:00"},"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",null,5,"Quinta-feira","07:20:00",null,"09:00:00","13:00:00","13:30:00","16:00:00"]
[6,{"$f":"B12+1","v":"2018-07-06"},"2018-07-06","F",{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1530,"d":"15:30"},{"v":2000,"d":"20:00"},"08:30:00.288","00:00:00","00:00:00","00:00:00","08:30:00","00:00:00","","","00:00:00","08:30:00",null,6,"Sexta-feira","07:20:00",null,"10:00:00","14:00:00","15:30:00","20:00:00"]
[7,"2018-07-07","2018-07-07","A",{"v":1200,"d":"12:00"},{"v":1700,"d":"17:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"04:59:59.712","00:00:00","00:00:00","00:00:00","05:00:00","07:20:00","02:20:00","","00:00:00","00:00:00",null,7,"Sábado","07:20:00",null,"12:00:00","17:00:00","00:00:00","00:00:00"]
[1,"2018-07-08","2018-07-08","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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","07:20:00",null,"00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2018-07-09","2018-07-09",null,{"v":1000,"d":"10:00"},{"v":1400,"d":"14:00"},{"v":1445,"d":"14:45"},{"v":1730,"d":"17:30"},"06:45:00","00:00:00","00:00:00","00:00:00","06:45:00","07:20:00","","00:35:00","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"10:00:00","14:00:00","14:45:00","17:30:00"]
[3,"2018-07-10","2018-07-10",null,{"v":1100,"d":"11:00"},{"v":1600,"d":"16:00"},{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},"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,"HORÁRIO NOTURNO",null,null,"11:00:00","16:00:00","17:00:00","20:00:00"]
[4,"2018-07-11","2018-07-11",null,{"v":1900,"d":"19:00"},{"v":2100,"d":"21:00"},{"v":2200,"d":"22:00"},{"v":500,"d":"05:00"},"01:59:59.712","07:00:00","01:00:00","08:00:00","10:00:00","07:20:00","","","02:40:00","00:00:00",null,null,"Início","22:00:00",null,"19:00:00","21:00:00","22:00:00","05:00:00"]
[5,"2018-07-12","2018-07-12","F",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[6,"2018-07-13","2018-07-13",null,{"v":500,"d":"05:00"},{"v":800,"d":"08:00"},{"v":900,"d":"09:00"},{"v":1200,"d":"12:00"},"06:00:00","00:00:00","00:00:00","00:00:00","06:00:00","07:20:00","","01:20:00","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"05:00:00","08:00:00","09:00:00","12:00:00"]
[7,"2018-07-14","2018-07-14",null,{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":500,"d":"05:00"},"01:59:59.712","06:00:00","00:51:25.714","06:51:25.714","08:51:25.714","07:20:00","","","01:31:25.714","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"20:00:00","22:00:00","23:00:00","05:00:00"]
[1,"2018-07-15","2018-07-15",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},"06:00:00","02:00:00","00:17:08.571","02:17:08.571","08:17:08.571","07:20:00","","","00:57:08.571","00:00:00",null,null,"Selecione o ano :",2018,null,"15:00:00","19:00:00","20:00:00","00:00:00"]
[2,"2018-07-16","2018-07-16",null,{"v":1500,"d":"15:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":100,"d":"01:00"},"06:00:00","03:00:00","00:25:42.857","03:25:42.857","09:25:42.857","07:20:00","","","02:05:42.857","00:00:00",null,null,"Selecione o mês :",7,null,"15:00:00","19:00:00","20:00:00","01:00:00"]
[3,"2018-07-17","2018-07-17",null,{"v":1400,"d":"14:00"},{"v":1800,"d":"18:00"},{"v":1830,"d":"18:30"},{"v":200,"d":"02:00"},"07:30:00","04:00:00","00:34:17.143","04:34:17.143","12:04:17.143","07:20:00","","","04:44:17.143","00:00:00",{"$nulls":5},"14:00:00","18:00:00","18:30:00","02:00:00"]
[4,"2018-07-18","2018-07-18",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":300,"d":"03:00"},"04:59:59.712","05:00:00","00:42:51.429","05:42:51.429","10:42:51.429","07:20:00","","","03:22:51.429","00:00:00",null,null,"Adicional Noturno:",{"$f":"L39","v":4.0357142857142865},null,"16:00:00","19:00:00","20:00:00","03:00:00"]
[5,"2018-07-19","2018-07-19","F",{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":400,"d":"04:00"},"04:59:59.712","06:00:00","00:51:25.714","06:51:25.714","11:51:25.714","00:00:00","","","00:00:00","11:51:25.714",null,null,"Horas Trabalhadas:",{"$f":"M39","v":10.250992063492061},null,"16:00:00","19:00:00","20:00:00","04:00:00"]
[6,"2018-07-20","2018-07-20",null,{"v":1600,"d":"16:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2200,"d":"22:00"},"04:59:59.712","00:00:00","00:00:00","00:00:00","05:00:00","07:20:00","","02:20:00","00:00:00","00:00:00",null,null,"Ausências Injustificadas:",{"$f":"O39","v":0.4027777777777777},null,"16:00:00","19:00:00","20:00:00","22:00:00"]
[7,"2018-07-21","2018-07-21",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2400,"d":"24:00"},{"v":500,"d":"05:00"},"03:00:00","05:00:00","00:42:51.429","05:42:51.429","08:42:51.429","07:20:00","","","01:22:51.429","00:00:00",null,null,"Horas Compensadas:",{"$f":"P39","v":1.8095238095238106},null,"17:00:00","20:00:00","00:00:00","05:00:00"]
[1,"2018-07-22","2018-07-22",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":1945,"d":"19:45"},{"v":400,"d":"04:00"},"04:14:59.712","06:00:00","00:51:25.714","06:51:25.714","11:06:25.714","07:20:00","","","03:46:25.714","00:00:00",null,null,"Horas Extras:",{"$f":"Q39","v":1.7495039682539684},null,"17:00:00","19:00:00","19:45:00","04:00:00"]
[2,"2018-07-23","2018-07-23",null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":1935,"d":"19:35"},{"v":400,"d":"04:00"},"04:25:00.192","06:00:00","00:51:25.714","06:51:25.714","11:16:25.714","07:20:00","","","03:56:25.714","00:00:00",null,null,"Folgas Trabalhadas:",{"$f":"R39","v":2.056547619047619},null,"17:00:00","19:00:00","19:35:00","04:00:00"]
[3,"2018-07-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2018-07-24"},null,{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":2300,"d":"23:00"},"04:00:00.288","01:00:00","00:08:34.286","01:08:34.286","05:08:34.286","07:20:00","","02:11:25.714","00:00:00","00:00:00",{"$nulls":5},"17:00:00","19:00:00","20:00:00","23:00:00"]
[4,"2018-07-25","2018-07-25","F",{"v":1700,"d":"17:00"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":700,"d":"07:00"},"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","00:00:00","","","00:00:00","14:00:00",null,null,{"$f":"IF(V28-V29=0,0,(IF(V28-V29<0,\"Horas Extras\",\"Horas Compensadas\")))","v":"Horas Compensadas"},{"$f":"IF(V28-V29<0,(V28*-1)-(V29*-1),V28-V29)","v":0.06001984126984228},null,"17:00:00","19:00:00","20:00:00","07:00:00"]
[5,"2018-07-26","2018-07-26",null,{"v":1715,"d":"17:15"},{"v":1900,"d":"19:00"},{"v":2000,"d":"20:00"},{"v":630,"d":"06:30"},"05:15:00","07:00:00","01:00:00","08:00:00","13:15:00","07:20:00","","","05:55:00","00:00:00",{"$nulls":5},"17:15:00","19:00:00","20:00:00","06:30:00"]
[6,"2018-07-27","2018-07-27",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2300,"d":"23:00"},{"v":100,"d":"01:00"},"04:00:00.288","02:00:00","00:17:08.571","02:17:08.571","06:17:08.571","07:20:00","","01:02:51.429","00:00:00","00:00:00",{"$nulls":5},"18:00:00","22:00:00","23:00:00","01:00:00"]
[7,"2018-07-28","2018-07-28","A",{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},{"v":0,"d":"00:00"},"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"]
[1,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2018-07-29"},"2018-07-29",null,{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2215,"d":"22:15"},{"v":800,"d":"08:00"},"07:00:00.288","06:45:00","00:57:51.429","07:42:51.429","14:42:51.429","07:20:00","","","07:22:51.429","00:00:00",{"$nulls":5},"18:00:00","22:00:00","22:15:00","08:00:00"]
[2,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2018-07-30"},"2018-07-30","F",{"v":1800,"d":"18:00"},{"v":2200,"d":"22:00"},{"v":2200,"d":"22:00"},{"v":800,"d":"08:00"},"07:00:00.288","07:00:00","01:00:00","08:00:00","15:00:00","00:00:00","","","00:00:00","15:00:00",{"$nulls":5},"18:00:00","22:00:00","22:00:00","08:00:00"]
[3,{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":"2018-07-31"},"2018-07-31",null,{"v":1700,"d":"17:00"},{"v":2000,"d":"20:00"},{"v":2100,"d":"21:00"},{"v":200,"d":"02:00"},"04:00:00.288","04:00:00","00:34:17.143","04:34:17.143","08:34:17.143","07:20:00","","","01:14:17.143","00:00:00",{"$nulls":5},"17:00:00","20:00:00","21:00:00","02:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis","repousos","dsr","Total:",{"$f":"SUM(L8:L38)","v":4.0357142857142865},{"$f":"SUM(M8:M38)","v":10.250992063492061},"Total:",{"$f":"SUM(O8:O38)","v":0.4027777777777777},{"$f":"SUM(P7:P38)","v":1.8095238095238106},{"$f":"SUM(Q7:Q38)","v":1.7495039682539684},{"$f":"SUM(R8:R38)","v":2.056547619047619}]
[null,{"$f":"B8","v":"2018-07-01"},{"$f":"MAX(B8:B38)","v":"2018-07-31"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":0},{"$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-I40","v":26},{"$f":"E40+F40","v":5},{"$f":"H40&\"/\"&I40","v":"26/5"},"Decimal:",{"$f":"L39*24","v":{"v":96.85714285714288,"d":"96.86"}},{"$f":"M39*24","v":{"v":246.02380952380946,"d":"246.02"}},"Decimal:",{"$f":"O39*24","v":{"v":9.666666666666664,"d":"9.67"}},{"v":43.42857142857146,"d":"43.43"},{"$f":"Q39*24","v":{"v":41.98809523809524,"d":"41.99"}},{"$f":"R39*24","v":{"v":49.35714285714286,"d":"49.36"}}]
[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":""},{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&I41)","v":""},"Dsr:",{"$f":"L40/$H$40*$I$40","v":{"v":18.626373626373628,"d":"18.63"}}]
[{"$nulls":10},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",L40/H41*I41)","v":""},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$nulls":3},{"$f":"IF(B41=\"\",\"\",Q40/$H$41*$I$41)","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$I$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p,1),DATE(ano_p,mês_p-1,dia_f+1))","v":"2018-07-01"},"Data de início:"]
[{"$nulls":20},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($V$22,mês_p,dia_f)))","v":"2018-07-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":2024},{"$f":"ROUND(DATE($B$2,4,MOD(234-11*MOD($B$2,19),30))/7,)*7-6","v":"2024-03-31"},"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":"2023-01-01"},{"$f":"IF($B$5=\"X\",DATE($B$2,1,1),DATE(1905,1,1))","v":"2024-01-01"},{"$f":"IF($B$5=\"X\",DATE($B$2+1,1,1),DATE(1905,1,1))","v":"2025-01-01"},{"$f":"ROUND(DATE($B$2-1,4,MOD(234-11*MOD($B$2-1,19),30))/7,)*7-6","v":"2023-04-09"},{"$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":"2023-04-21"},{"$f":"IF($B$6=\"X\",DATE($B$2,4,21),DATE(1905,1,1))","v":"2024-04-21"},{"$f":"IF($B$6=\"X\",DATE($B$2+1,4,21),DATE(1905,1,1))","v":"2025-04-21"},{"$f":"ROUND(DATE($B$2+1,4,MOD(234-11*MOD($B$2+1,19),30))/7,)*7-6","v":"2025-04-20"},{"$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":"2023-05-01"},{"$f":"IF($B$7=\"X\",DATE($B$2,5,1),DATE(1905,1,1))","v":"2024-05-01"},{"$f":"IF($B$7=\"X\",DATE($B$2+1,5,1),DATE(1905,1,1))","v":"2025-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":"2023-09-07"},{"$f":"IF($B$8=\"X\",DATE($B$2,9,7),DATE(1905,1,1))","v":"2024-09-07"},{"$f":"IF($B$8=\"X\",DATE($B$2+1,9,7),DATE(1905,1,1))","v":"2025-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":"2023-10-12"},{"$f":"IF($B$9=\"X\",DATE($B$2,10,12),DATE(1905,1,1))","v":"2024-10-12"},{"$f":"IF($B$9=\"X\",DATE($B$2+1,10,12),DATE(1905,1,1))","v":"2025-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":"2023-11-02"},{"$f":"IF($B$10=\"X\",DATE($B$2,11,2),DATE(1905,1,1))","v":"2024-11-02"},{"$f":"IF($B$10=\"X\",DATE($B$2+1,11,2),DATE(1905,1,1))","v":"2025-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":"2023-11-15"},{"$f":"IF($B$11=\"X\",DATE($B$2,11,15),DATE(1905,1,1))","v":"2024-11-15"},{"$f":"IF($B$11=\"X\",DATE($B$2+1,11,15),DATE(1905,1,1))","v":"2025-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":"2023-11-20"},{"$f":"IF($B$12=\"X\",DATE($B$2,11,20),DATE(1905,1,1))","v":"2024-11-20"},{"$f":"IF($B$12=\"X\",DATE($B$2+1,11,20),DATE(1905,1,1))","v":"2025-11-20"}]
[null,"x","Natal",{"$f":"IF($B$13=\"X\",DATE($B$2-1,12,25),DATE(1905,1,1))","v":"2023-12-25"},{"$f":"IF($B$13=\"X\",DATE($B$2,12,25),DATE(1905,1,1))","v":"2024-12-25"},{"$f":"IF($B$13=\"X\",DATE($B$2+1,12,25),DATE(1905,1,1))","v":"2025-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":"2023-04-07"},{"$f":"IF($B$14=\"X\",páscoa-2,DATE(1905,1,1))","v":"2024-03-29"},{"$f":"IF($B$14=\"X\",$G$6-2,DATE(1905,1,1))","v":"2025-04-18"},{"$nulls":15},9,9]
[null,"x","Corpus Christi",{"$f":"IF($B$15=\"X\",$G$5+60,DATE(1905,1,1))","v":"2023-06-08"},{"$f":"IF($B$15=\"X\",páscoa+60,DATE(1905,1,1))","v":"2024-05-30"},{"$f":"IF($B$15=\"X\",$G$6+60,DATE(1905,1,1))","v":"2025-06-19"},{"$nulls":15},10,10]
[null,"x","Terça-Feira de Carnaval",{"$f":"IF($B$16=\"X\",$G$5-47,DATE(1905,1,1))","v":"2023-02-21"},{"$f":"IF($B$16=\"X\",páscoa-47,DATE(1905,1,1))","v":"2024-02-13"},{"$f":"IF($B$16=\"X\",$G$6-47,DATE(1905,1,1))","v":"2025-03-04"},"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":"2023-06-10"},{"$f":"IF($B$17=\"X\",DATE($B$2,$H$17,$G$17),DATE(1905,1,1))","v":"2024-06-10"},{"$f":"IF($B$17=\"X\",DATE($B$2+1,$H$17,$G$17),DATE(1905,1,1))","v":"2025-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":"2023-06-24"},{"$f":"IF($B$18=\"X\",DATE($B$2,H18,G18),DATE(1905,1,1))","v":"2024-06-24"},{"$f":"IF($B$18=\"X\",DATE($B$2+1,H18,G18),DATE(1905,1,1))","v":"2025-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]