{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Parâmetros","controle de ponto","Feriados"],"not_rendered":{"images":1,"macros":1,"defined_names":23,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Parâmetros","index":0,"n_rows":126,"n_cols":13,"rows_kept":126,"merged":[[5,1,5,2],[5,4,5,5],[5,10,5,12],[10,4,10,5],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[16,1,16,2],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,1,19,2],[19,7,19,9],[20,7,20,9],[21,1,21,2],[21,7,21,9],[22,7,22,9],[23,1,23,2],[23,7,23,9]]}
[]
[]
[]
[]
[]
[null,"JORNADA CONTRATUAL",null,null,"FECHAMENTO DO PONTO",null,null,"HORA EXTRA","ADIC. NOTURNO","INTER. INTRA","DIVISOR"]
[null,"Dia da Semana","Limite",null,"Dia Fechamento:",{"$nulls":5},"Limite 44h","6 dias",220]
[1,"Domingo","00:00:00",null,"Selecione o ano:",2024,{"$nulls":4},"Limite 40h","6 dias",200]
[2,"Segunda-feira","08:00:00",null,"Selecione o mês",1,null,50,20,50,"Limite 36h","6 dias",180]
[3,"Terça-feira","08:00:00",{"$nulls":4},"Hora Extra","Adic. Noturno","H. Intervalares","Limite 30h","6 dias",150]
[4,"Quarta-feira","08:00:00",null,"INTERVALO INTRAJORNADA",null,null,{"$f":"(1+(H9/100))","v":1.5},{"$f":"I9/100","v":0.2},{"$f":"(1+(J9/100))","v":1.5},"Limite 24h","6 dias",120]
[5,"Quinta-feira","08:00:00"]
[6,"Sexta-feira","08:00:00",{"$nulls":4},"Controle de Ponto",null,null,{"$f":"DATE(ano_cp,mes_cp,1)","v":"2024-01-01"}]
[7,"Sábado","04:00:00",{"$nulls":4},"Dias Úteis no Período",null,null,{"$f":"dias_úteis","v":{"v":26,"d":"26 dias"}}]
[8,"Feriado","00:00:00",{"$nulls":4},"Descanso Semanal Rem. - Dom / Feriados",null,null,{"$f":"repousos","v":{"v":5,"d":"5 dias"}}]
[null,"Folgas","00:00:00",{"$nulls":4},"Fechamento do Ponto",null,null,{"$f":"CONCATENATE(TEXT(início,\"dd/mmm/aaaa\")&\"  a  \"&TEXT(fim,\"dd/mmm/aaaa\"))","v":"01/jan/2024  a  31/jan/2024"}]
[null,"HORÁRIO NOTURNO",{"$nulls":5},"Trabalho Urbano, Rural ou Urbano sem red. Jornada?",null,null,{"$f":"IF(trab_=1,\"Urbano\",IF(trab_=2,\"Rural\",\"Trabalho Urbano sem Reduçao das Horas Noturnas\"))","v":"Urbano"}]
[null,"Início:","22:00:00",{"$nulls":4},"Prorrogação do horário noturno?",null,null,{"$f":"IF(sum_60=TRUE,\"Sim\",\"Não\")","v":"Sim"}]
[null,"Término:","05:00:00",{"$nulls":4},"Aplicar tolerância no Intervalo?",null,null,{"$f":"IF(intra_t=1,\"Não\",IF(intra_t=2,\"Sim, 00:05 min de tolerância\",\"Sim, 00:10 min de tolerância\"))","v":"Não"}]
[null,"PRORROGAÇÃO H. NOTURNO",{"$nulls":5},"Aplicar tolerância na Jornada?",null,null,{"$f":"IF(jorn_t=1,\"Não\",\"Sim, 00:10 min de tolerância\")","v":"Sim, 00:10 min de tolerância"}]
[{"$nulls":7},"Adicional Noturno:",null,null,{"$f":"CONCATENATE(\"Adicional de \"&I9&\"%\")","v":"Adicional de 20%"}]
[null,"LIMITE PARA A PRORROGAÇÃO",{"$nulls":5},"Adicional de Horas Extras - dias úteis:",null,null,{"$f":"CONCATENATE(\"Adicional de \"&H9&\"%\")","v":"Adicional de 50%"}]
[null,"Início até:","23:00:00",{"$nulls":4},"Adicional de Horas Extras - Folgas e Feriados:",null,null,{"$f":"\"Adicional de \"&100&\"%\"","v":"Adicional de 100%"}]
[null,"TRABALHO URBANO OU RURAL",{"$nulls":5},"Horas Intervalares:",null,null,{"$f":"CONCATENATE(\"Adicional de \"&J9&\"%\")","v":"Adicional de 50%"}]
{"$rows_empty":22}
[{"$nulls":9},50]
{"$rows_empty":52}
[null,null,2019]
[null,null,2020]
[null,null,2021]
[null,null,2022]
[null,null,2023]
[null,null,2024]
[null,null,2025]
[null,null,2026]
[null,null,2027]
[null,null,2028]
[null,null,2029]
[null,null,2030]
[null,null,2031]
[null,null,2032]
[]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]

{"sheet":"controle de ponto","index":1,"n_rows":127,"n_cols":35,"rows_kept":127,"merged":[[1,7,2,7],[1,13,3,13],[2,3,2,4],[2,5,2,6],[4,1,4,2],[5,3,5,7],[5,20,5,21],[5,22,5,26],[5,28,5,33],[42,10,42,11],[44,0,45,3],[44,4,44,6],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,10,45,10],[44,11,45,11],[44,12,45,12],[44,13,45,13],[46,0,46,3],[48,2,48,3],[48,9,49,9],[48,10,49,10],[48,11,49,11],[48,12,49,12],[48,13,49,13],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[52,9,53,9],[52,10,53,10],[52,11,53,11],[52,12,53,12],[53,0,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3]]}
[{"$nulls":20},{"$f":"ROUNDDOWN(\"04:00:10\",5)","v":"04:00:09.792"},{"$f":"ROUNDDOWN(\"06:00:10\",5)","v":"06:00:09.504"},{"$f":"ROUNDDOWN(\"08:00:10\",5)","v":"08:00:09.216"},{"$f":"IF($U$4=1,$U$1,IF($U$4=2,$W$3,IF($U$4=3,$X$3,$Y$3)))","v":"04:10:09.408"},{"$f":"IF($U$4=1,$V$1,IF($U$4=2,$W$4,IF($U$4=3,$X$4,$Y$4)))","v":"06:10:09.984"}]
[{"$nulls":20},1,{"$f":"ROUNDDOWN(\"00:05:01\",5)","v":"00:05:00.672"},{"$f":"ROUNDDOWN(\"01:00:10\",5)","v":"01:00:09.792"}]
[{"$nulls":3},"Mês / Ano:",null,{"$f":"PROPER(TEXT(DATE(ano_cp,mes_cp,1),\"mmmm/aaaa\"))","v":"Janeiro/2024"},{"$nulls":14},1,{"$f":"ROUNDDOWN(\"00:10:01\",5)","v":"00:10:00.480"},{"$f":"ROUNDDOWN(\"04:10:10\",5)","v":"04:10:09.408"},{"$f":"ROUNDDOWN(\"04:15:10\",5)","v":"04:15:09.216"},{"$f":"ROUNDDOWN(\"04:30:10\",5)","v":"04:30:09.504"}]
[{"$nulls":20},2,{"$f":"ROUNDDOWN(\"00:15:01\",5)","v":"00:15:00.288"},{"$f":"ROUNDDOWN(\"06:10:10\",5)","v":"06:10:09.984"},{"$f":"ROUNDDOWN(\"06:15:10\",5)","v":"06:15:09.792"},{"$f":"ROUNDDOWN(\"06:30:10\",5)","v":"06:30:09.216"}]
[{"$nulls":20},true,{"$f":"ROUNDDOWN(\"00:30:01\",5)","v":"00:30:00.576"}]
[null,null,"Empregado :","Quadro de Horários",{"$nulls":6},"Unidade :",{"$nulls":9},"Intervalo Intrajornada",null,"SEM PRORROGAÇÃO",{"$nulls":5},"COM PRORROGAÇÃO"]
[null,"Data ","Dia Semana","Folgas","Ent 1","Saída 1","Ent 2 ","Saída 2","Horas Diurnas","Adicional Noturno","H. Trab.","H. Normais","Ausências Injustificadas","H. Extras","HE 100%","Intervalo Intrajornada",{"$nulls":4},"Pausa","Fixação Intervalo","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Extras","HE 100%","Hora Diurna Depois","Hora Diurna Antes","Adicional Noturno","Hora Diurna Depois","Horas Trab. c/pror.","He Total","HE 100%"]
[{"$f":"IF(B8=\"\",\"\",IF(C8<>\"feriado\",WEEKDAY(B8),8))","v":8},{"$f":"início","v":"2024-01-01"},{"$f":"IF(B8=\"\",\"\",IF(COUNTIF(fer,B8)>0,\"feriado\",B8))","v":"feriado"},{"$nulls":5},{"$f":"IF(B8=\"\",\"\",ROUND(K8-J8,5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND($U$5=TRUE,E8>Fimnot,E8<=lim_not),AE8+AF8,Y8))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND($U$5=TRUE,E8>Fimnot,E8<=lim_not),AG8,Z8))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",jor_folga,VLOOKUP(A8,_jornada,3)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",L8>K8),L8-K8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND($U$5=TRUE,E8>Fimnot,E8<=lim_not),AH8,AA8))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND($U$5=TRUE,E8>Fimnot,E8<=lim_not),AI8,AB8))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(OR(MOD(F8-E8,1)=K8,MOD(H8-G8,1)=K8),V8,IF(U8>V8,0,IF(AND(V8-U8<=$V$2,$U$3=2),0,IF(AND(V8-U8<=$V$3,$U$3=3),0,V8-U8)))))","v":"00:00:00"},{"$nulls":4},{"$f":"IF(B8=\"\",\"\",IF(OR(AND(E8=0,F8=0),AND(G8=0,H8=0)),0,ROUND(MOD(G8-F8,1),5)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(K8<=$X$1,0,IF(K8<=$Y$1,$V$4,$W$2)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(E8=\"\",F8=\"\"),0,MAX(Ininot,MIN(Fimnot+1,F8+(E8>F8)))-MAX(Ininot,E8)+(MIN(Fimnot,F8+(E8>F8))-MIN(Fimnot,E8)))+IF(AND(G8=\"\",H8=\"\"),0,MAX(Ininot,MIN(Fimnot+1,H8+(G8>H8)))-MAX(Ininot,G8)+(MIN(Fimnot,H8+(G8>H8))-MIN(Fimnot,G8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(OR($U$2=2,$U$2=3),0,(W8/7*8)-W8))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",W8+X8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",ROUND((MOD(F8+H8-E8-G8,1)+X8),5))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,L8=0,D8<>\"F\"),MAX(0,Z8-L8),IF(L8=0,0,MAX(0,Z8-L8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,L8=0,D8<>\"F\"),0,IF(L8=0,Z8,0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",ABS(ROUND((Z8-AE8-AD8)*24,10)/24))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF((Fimnot<=E8)*(E8<Ininot),MIN(Ininot,(F8+(E8>F8)))-MAX(Fimnot,E8)+IF((Fimnot<=(G8+(E8>G8)))*((G8+(E8>G8))<Ininot),MIN(Ininot,(H8+(E8>H8)))-MAX(Fimnot,G8+(E8>G8))),0))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",Y8)","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(X8=0,AC8,AC8*8/7))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",SUM(AD8:AF8))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,L8=0,D8<>\"F\"),MAX(0,AG8-L8),IF(L8=0,0,MAX(0,AG8-L8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,L8=0,D8<>\"F\"),0,IF(L8=0,AG8,0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":3},{"$f":"B8+1","v":"2024-01-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2024-01-02"},{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,{"$f":"B9+1","v":"2024-01-03"},"2024-01-03",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,{"$f":"B10+1","v":"2024-01-04"},"2024-01-04",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,{"$f":"B11+1","v":"2024-01-05"},"2024-01-05",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,{"$f":"B12+1","v":"2024-01-06"},"2024-01-06","F",{"$nulls":4},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-07","2024-01-07",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-08","2024-01-08",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-09","2024-01-09",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-10","2024-01-10",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-11","2024-01-11",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-12","2024-01-12",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-13","2024-01-13","f",{"$nulls":4},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-14","2024-01-14",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-15","2024-01-15",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-16","2024-01-16",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-17","2024-01-17",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-18","2024-01-18",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-19","2024-01-19",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-20","2024-01-20",{"$nulls":5},"00:00:00","00:00:00","00:00:00","04:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-21","2024-01-21",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-22","2024-01-22",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-23","2024-01-23",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2024-01-24"},"f",{"$nulls":4},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-25","2024-01-25",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-26","2024-01-26",{"$nulls":5},"00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-27","2024-01-27",{"$nulls":5},{"$f":"IF(B34=\"\",\"\",ROUND(K34-J34,5))","v":"00:00:00"},"00:00:00","00:00:00","04:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-28","2024-01-28",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00: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","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","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","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","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","08:00:00","","00:00:00","00:00:00","00:00:00",{"$nulls":4},"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:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[]
[null,"Início","Término","fer","dom","dias úteis","repousos","Total:",{"$f":"SUM(I8:I38)","v":0},{"$f":"SUM(J8:J38)","v":0},{"$f":"SUM(K8:K38)","v":0},null,{"$f":"SUM(M8:M38)","v":0},{"$f":"SUM(N8:N38)","v":0},{"$f":"SUM(O8:O38)","v":0},{"$f":"SUM(P8:P38)","v":0}]
[{"$f":"C41-B41+1","v":31},{"$f":"IF(dia_fp=\"\",B8,DATE(ano_cp,mes_cp,1))","v":"2024-01-01"},{"$f":"IF(dia_fp=\"\",MAX(B8:B38),DATE(ano_cp,mes_cp+1,0))","v":"2024-01-31"},{"$f":"COUNTIF(C8:C38,\"feriado\")","v":1},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*(COUNTIF(fer,ROW(INDIRECT($B41&\":\"&$C41)))=0))","v":4},{"$f":"A41-G41","v":26},{"$f":"D41+E41","v":5},"Decimal:",{"$f":"I40*24","v":{"v":0,"d":"0.00"}},{"$f":"J40*24","v":{"v":0,"d":"0.00"}},{"$f":"K40*24","v":{"v":0,"d":"0.00"}},null,{"$f":"M40*24","v":{"v":0,"d":"0.00"}},{"$f":"N40*24","v":{"v":0,"d":"0.00"}},{"$f":"O40*24","v":{"v":0,"d":"0.00"}},{"$f":"P40*24","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(B42=\"\",\"\",DAY(C42))","v":31},{"$f":"B8","v":"2024-01-01"},{"$f":"MAX(B8:B38)","v":"2024-01-31"},{"$f":"IF(B42=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B42)*(fer<=C42)))","v":1},{"$f":"IF(B42=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B42&\":\"&$C42)))=1)*1))","v":4},{"$f":"IF(B42=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B42&\":\"&C42)))>1)*(COUNTIF(fer,ROW(INDIRECT(B42&\":\"&C42)))=0)))","v":26},{"$f":"IF(B42=\"\",\"\",D42+E42)","v":5},"DSR:",null,{"$f":"J41/dias_úteis*repousos","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"N41/dias_úteis*repousos","v":{"v":0,"d":"0.00"}},{"$f":"O41/dias_úteis*repousos","v":{"v":0,"d":"0.00"}},0]
[]
[]
["Empregado:",{"$nulls":3},"Base de Cálculo",null,null,"Divisor","Salário-Hora ","Adicional Noturno","Hora Extra 1","Hora Extra 100% ","Intervalo Intrajornada","Ausências Injustificadas"]
[{"$nulls":4},"Salário","Adicional:","Total:"]
["Maria Aparecida dos Santos",{"$nulls":3},{"v":2000,"d":"2,000.00"},0,{"$f":"E47+F47","v":{"v":2000,"d":"2,000.00"}},220,{"$f":"IF(G47=\"\",\"\",G47/H47)","v":{"v":9.090909090909092,"d":"9.09"}},{"$f":"$J$40","v":0},{"$f":"$N$40","v":0},{"$f":"$O$40","v":0},{"$f":"$P$40","v":0},{"$f":"M40","v":0}]
{"$rows_empty":64}
[{"$nulls":17},{"$f":"IF(dia_fp=\"\",DATE(ano_cp,mes_cp,1),DATE(ano_cp,mes_cp-1,dia_fp+1))","v":"2024-01-01"},"Data de início:"]
[{"$nulls":17},{"$f":"IF(dia_fp=\"\",DATE(ano_cp,mes_cp+1,0),(DATE(ano_cp,mes_cp,dia_fp)))","v":"2024-01-31"},"Data final:"]
[]
[{"$nulls":3},"Meses",null,"Anos"]
[{"$nulls":3},1,null,2012,120,6]
[{"$nulls":3},2,null,2013,150]
[{"$nulls":3},3,null,2014,180]
[{"$nulls":3},4,null,2015,200]
[{"$nulls":3},5,null,2016,210]
[{"$nulls":3},6,null,2017,220]
[{"$nulls":3},7,null,2018]
[{"$nulls":3},8,null,2019]
[{"$nulls":3},9,null,2020]
[{"$nulls":3},10,null,2021]
[{"$nulls":3},11,null,2022]
[{"$nulls":3},12,null,2023]

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