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

{"sheet":"controle ponto","index":0,"n_rows":131,"n_cols":30,"rows_kept":131,"merged":[[1,5,2,7],[1,8,2,10],[1,17,3,17],[1,24,3,28],[4,1,4,2],[5,21,5,22],[5,24,5,29],[16,21,16,22],[19,21,19,22],[41,14,41,15]]}
[]
[{"$nulls":5},"CONTROLE DE PONTO: ",null,null,{"$f":"TEXT(B8,\"mmmm\")&\" de \"&ano_p","v":"janeiro de 2024"}]
[]
[]
[]
[null,null,"Empregado :",{"$nulls":6},"Setor :",{"$nulls":4},"Unidade :",{"$nulls":6},"JORNADA CONTRATUAL",null,null,"CARTÃO PONTO ESPELHO"]
[null,"Data ","Dia Semana","Folgas","Entrada","Saída","Entrada","Saída","Entrada","Saída","Horas Diurnas","H. Not. s/ red.","Hora Ficta","Adicional Noturno","H. Trab.","H. Normais","Ausências Injustificadas","H. Extras","HE 100%",null,null,"Dia da Semana","Limite",null,"Entrada","Saída","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"},null,0.3333333333333333,0.5,0.5416666666666666,0.875,0.9166666666666666,0.20833333333333334,{"$f":"IF(B8=\"\",\"\",ROUND(O8-N8,5))","v":"12: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)))+IF(AND(I8=\"\",J8=\"\"),0,MAX(ININOT,MIN(FIMNOT+1,J8+(I8>J8)))-MAX(ININOT,I8)+(MIN(FIMNOT,J8+(I8>J8))-MIN(FIMNOT,I8))))","v":"07:00:00"},{"$f":"IF(B8=\"\",\"\",(L8/7*8)-L8)","v":"01:00:00"},{"$f":"IF(B8=\"\",\"\",L8+M8)","v":"08:00:00"},{"$f":"IF(B8=\"\",\"\",MOD((F8-E8)+(H8-G8)+(J8-I8),1)+M8)","v":"20:00:00"},{"$f":"IF(B8=\"\",\"\",IF(D8=\"F\",$W$16,VLOOKUP(A8,jornada,3)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(D8=\"A\",P8>O8),P8-O8,\"\"))","v":""},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),MAX(0,O8-P8),IF(P8=0,0,MAX(0,O8-P8))))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF(AND(WEEKDAY(B8,1)=7,P8=0,D8<>\"F\"),0,IF(P8=0,O8,0)))","v":"20:00:00"},null,1,"domingo","00:00:00",null,{"$f":"IF(B8=\"\",\"\",IF($E8=\"\",0,TIME(INT(E8/100),MOD(E8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($F8=\"\",0,TIME(INT(F8/100),MOD(F8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($G8=\"\",0,TIME(INT(G8/100),MOD(G8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($H8=\"\",0,TIME(INT(H8/100),MOD(H8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($I8=\"\",0,TIME(INT(I8/100),MOD(I8,100),0)))","v":"00:00:00"},{"$f":"IF(B8=\"\",\"\",IF($J8=\"\",0,TIME(INT(J8/100),MOD(J8,100),0)))","v":"00:00:00"}]
[{"$f":"IF(B9=\"\",\"\",IF(C9<>\"feriado\",WEEKDAY(B9),8))","v":3},{"$f":"B8+1","v":"2024-01-02"},{"$f":"IF(B9=\"\",\"\",IF(COUNTIF(fer,B9)>0,\"feriado\",B9))","v":"2024-01-02"},null,0.3333333333333333,0.5,0.75,1,null,null,{"$f":"IF(B9=\"\",\"\",ROUND(O9-N9,5))","v":"07:59:59.712"},"02:00:00",{"$f":"IF(B9=\"\",\"\",(L9/7*8)-L9)","v":"00:17:08.571"},{"$f":"IF(B9=\"\",\"\",L9+M9)","v":"02:17:08.571"},{"$f":"IF(B9=\"\",\"\",MOD((F9-E9)+(H9-G9)+(J9-I9),1)+M9)","v":"10:17:08.571"},"08:00:00",{"$f":"IF(B9=\"\",\"\",IF(AND(D9=\"A\",P9>O9),P9-O9,\"\"))","v":""},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),MAX(0,O9-P9),IF(P9=0,0,MAX(0,O9-P9))))","v":"02:17:08.571"},{"$f":"IF(B9=\"\",\"\",IF(AND(WEEKDAY(B9,1)=7,P9=0,D9<>\"F\"),0,IF(P9=0,O9,0)))","v":"00:00:00"},null,2,"Segunda-feira","08:00: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:01:00"},{"$f":"IF(B9=\"\",\"\",IF($I9=\"\",0,TIME(INT(I9/100),MOD(I9,100),0)))","v":"00:00:00"},{"$f":"IF(B9=\"\",\"\",IF($J9=\"\",0,TIME(INT(J9/100),MOD(J9,100),0)))","v":"00:00:00"}]
[4,{"$f":"B9+1","v":"2024-01-03"},"2024-01-03","A",0.3333333333333333,0.5,null,null,0.9166666666666666,0.20833333333333334,"04:00:00.288","07:00:00","01:00:00","08:00:00","12:00:00","08:00:00","","04:00:00","00:00:00",null,3,"Terça-feira","08:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,{"$f":"B10+1","v":"2024-01-04"},"2024-01-04",null,0.3333333333333333,0.625,0.9166666666666666,0.20833333333333334,null,null,"07:00:00.288","07:00:00","01:00:00","08:00:00","15:00:00","08:00:00","","07:00:00","00:00:00",null,4,"Quarta-feira","08:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,{"$f":"B11+1","v":"2024-01-05"},"2024-01-05",null,0.9166666666666666,0.20833333333333334,0.25,0.5,null,null,"06:00:00","07:00:00","01:00:00","08:00:00","14:00:00","08:00:00","","06:00:00","00:00:00",null,5,"Quinta-feira","08:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,{"$f":"B12+1","v":"2024-01-06"},"2024-01-06","F",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00",null,6,"Sexta-feira","08:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-07","2024-01-07",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,"00:00:00","00:00:00",null,7,"Sábado","04:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-08","2024-01-08",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,8,"Feriados","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-09","2024-01-09",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,null,"Folgas","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-10","2024-01-10",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,null,"HORÁRIO NOTURNO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-11","2024-01-11",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,null,"Início","22:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-12","2024-01-12",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,null,"Término","05:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-13","2024-01-13","F",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00",null,null,"FECHAMENTO DO PONTO",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-14","2024-01-14","A",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00",null,null,"Dia do fechamento do ponto:",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-15","2024-01-15",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,null,"Selecione o ano :",2024,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-16","2024-01-16",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",null,null,"Selecione o mês :",1,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-17","2024-01-17",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-18","2024-01-18",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-19","2024-01-19",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-20","2024-01-20","F",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"IF(B27=\"\",\"\",MOD((F27-E27)+(H27-G27)+(J27-I27),1)+M27)","v":"00:00:00"},"00:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-21","2024-01-21",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,"2024-01-22","2024-01-22",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,"2024-01-23","2024-01-23","A",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","08:00:00","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,"2024-01-24",{"$f":"IF(B31=\"\",\"\",IF(COUNTIF(fer,B31)>0,\"feriado\",B31))","v":"2024-01-24"},{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[5,"2024-01-25","2024-01-25",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[6,"2024-01-26","2024-01-26",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[7,"2024-01-27","2024-01-27","F",{"$nulls":6},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[1,"2024-01-28","2024-01-28",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[2,{"$f":"IF(B35=\"\",\"\",IF(B35>=fim,\"\",B35+1))","v":"2024-01-29"},"2024-01-29",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[3,{"$f":"IF(B36=\"\",\"\",IF(B36>=fim,\"\",B36+1))","v":"2024-01-30"},"2024-01-30",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[4,{"$f":"IF(B37=\"\",\"\",IF(B37>=fim,\"\",B37+1))","v":"2024-01-31"},"2024-01-31",{"$nulls":7},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","08:00:00","","00:00:00","00:00:00",{"$nulls":5},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"Início","Término",null,"fer","dom","mês","dias úteis",null,null,"repousos","dsr","Total:",{"$f":"SUM(N8:N38)","v":1.4285714285714284},{"$f":"SUM(O8:O38)","v":2.9702380952380962},"Total:",{"$f":"SUM(Q8:Q38)","v":0.3333333333333333},{"$f":"SUM(R8:R38)","v":0.8035714285714293},{"$f":"SUM(S8:S38)","v":0.8333333333333335}]
[null,{"$f":"B8","v":"2024-01-01"},{"$f":"MAX(B8:B38)","v":"2024-01-31"},null,{"$f":"COUNTIF(C8:C38,\"feriado\")","v":1},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B40&\":\"&$C40)))=1)*(COUNTIF(fer,ROW(INDIRECT($B40&\":\"&$C40)))=0))","v":4},{"$f":"C40-B40+1","v":31},{"$f":"G40-K40","v":26},null,null,{"$f":"E40+F40","v":5},{"$f":"H40&\"/\"&K40","v":"26/5"},"Decimal:",{"$f":"N39*24","v":{"v":34.28571428571428,"d":"34.29"}},{"$f":"O39*24","v":{"v":71.2857142857143,"d":"71.29"}},"Decimal:",null,{"$f":"R39*24","v":{"v":19.285714285714302,"d":"19.29"}},{"$f":"S39*24","v":{"v":20.000000000000004,"d":"20.00"}}]
[null,{"$f":"IF(dia_f=\"\",\"\",DATE(ano_p,mês_p,1))","v":""},{"$f":"IF(dia_f=\"\",\"\",DATE(ano_p,mês_p+1,0))","v":""},null,{"$f":"IF(B41=\"\",\"\",SUMPRODUCT(((WEEKDAY(fer)>1))*(fer>=B41)*(fer<=C41)))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT($B41&\":\"&$C41)))=1)*1))","v":""},{"$f":"IF(B41=\"\",\"\",DAY(C41))","v":""},{"$f":"IF(B41=\"\",\"\",SUMPRODUCT((WEEKDAY(ROW(INDIRECT(B41&\":\"&C41)))>1)*(COUNTIF(fer,ROW(INDIRECT(B41&\":\"&C41)))=0)))","v":""},null,null,{"$f":"IF(B41=\"\",\"\",E41+F41)","v":""},{"$f":"IF(B41=\"\",\"\",H41&\"/\"&K41)","v":""},"Dsr:",{"$f":"N40/$H$40*$K$40","v":{"v":6.593406593406592,"d":"6.59"}},null,null,"Dsr:",{"$f":"R40/$H$40*$K$40","v":{"v":3.7087912087912125,"d":"3.71"}},{"$f":"S40/$H$40*$K$40","v":{"v":3.8461538461538467,"d":"3.85"}}]
[{"$nulls":12},{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",N40/H41*K41)","v":""},null,null,{"$f":"IF(B41=\"\",\"\",\"Dsr mês:\")","v":""},{"$f":"IF(B41=\"\",\"\",R40/$H$41*$K$41)","v":""},{"$f":"IF(B41=\"\",\"\",S40/$H$41*$K$41)","v":""}]
{"$rows_empty":73}
[{"$nulls":21},{"$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":21},{"$f":"IF(dia_f=\"\",DATE(ano_p,mês_p+1,0),(DATE($W$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":"Feriados","index":1,"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","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]