{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Calendário","Feriados","Quinto dia útil"],"not_rendered":{"images":3,"macros":1,"defined_names":29},"read":"whole","date_system":"1900"}

{"sheet":"Calendário","index":0,"n_rows":106,"n_cols":37,"rows_kept":106,"merged":[[2,11,2,13],[5,30,6,30],[5,31,6,31],[5,33,6,33],[5,34,6,34],[14,25,15,32],[16,25,17,25],[16,26,17,26],[16,27,17,27],[16,28,17,28],[16,29,17,29],[16,30,17,30],[16,31,17,31],[16,32,17,32],[97,4,97,7],[99,4,99,7],[101,4,101,7],[103,4,103,7],[105,4,105,7]]}
[]
[]
[{"$nulls":11},2024]
[]
[null,{"$f":"DATE(aa,1,1)","v":"2024-01-01"},{"$nulls":7},{"$f":"DATE(aa,2,1)","v":"2024-02-01"},{"$nulls":7},{"$f":"DATE(aa,3,1)","v":"2024-03-01"}]
[null,"Janeiro",{"$nulls":7},"Fevereiro",{"$nulls":7},"Março"]
[null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",95,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb"]
[null,{"$f":"IF( WEEKDAY(jan_1) = MOD(COLUMN()-1,8), jan_1, 0 )","v":"00:00:00"},{"$f":"IF( B8>0, B8+1, IF( WEEKDAY(jan_1)=MOD(COLUMN()-1,8), jan_1, 0) )","v":"2024-01-01"},"2024-01-02","2024-01-03","2024-01-04","2024-01-05","2024-01-06",null,{"$f":"IF( WEEKDAY(fev_1) = MOD(COLUMN()-1,8), fev_1, 0 )","v":"00:00:00"},{"$f":"IF( J8>0, J8+1, IF( WEEKDAY(fev_1)=MOD(COLUMN()-1,8), fev_1, 0) )","v":"00:00:00"},"00:00:00","00:00:00","2024-02-01","2024-02-02","2024-02-03",null,{"$f":"IF( WEEKDAY(mar_1) = MOD(COLUMN()-1,8), mar_1, 0 )","v":"00:00:00"},{"$f":"IF( R8>0, R8+1, IF( WEEKDAY(mar_1)=MOD(COLUMN()-1,8), mar_1, 0) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","2024-03-01","2024-03-02"]
[null,{"$f":"H8+1","v":"2024-01-07"},{"$f":"B9+1","v":"2024-01-08"},"2024-01-09","2024-01-10","2024-01-11","2024-01-12","2024-01-13",null,{"$f":"P8+1","v":"2024-02-04"},{"$f":"J9+1","v":"2024-02-05"},"2024-02-06","2024-02-07","2024-02-08","2024-02-09","2024-02-10",null,{"$f":"X8+1","v":"2024-03-03"},{"$f":"R9+1","v":"2024-03-04"},"2024-03-05","2024-03-06","2024-03-07","2024-03-08","2024-03-09",{"$nulls":12},{"$f":"WEEKDAY(AF9)","v":7}]
[null,{"$f":"H9+1","v":"2024-01-14"},"2024-01-15","2024-01-16","2024-01-17","2024-01-18","2024-01-19","2024-01-20",null,{"$f":"P9+1","v":"2024-02-11"},"2024-02-12","2024-02-13","2024-02-14","2024-02-15","2024-02-16","2024-02-17",null,{"$f":"X9+1","v":"2024-03-10"},"2024-03-11","2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16",{"$nulls":12},7]
[null,{"$f":"H10+1","v":"2024-01-21"},"2024-01-22","2024-01-23","2024-01-24","2024-01-25","2024-01-26","2024-01-27",null,{"$f":"P10+1","v":"2024-02-18"},"2024-02-19","2024-02-20","2024-02-21","2024-02-22","2024-02-23","2024-02-24",null,{"$f":"X10+1","v":"2024-03-17"},"2024-03-18","2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23",{"$nulls":12},7]
[null,{"$f":"IF( MONTH(H11+1) = MONTH(jan_1), H11+1, 0 )","v":"2024-01-28"},{"$f":"IF( B12=0, 0, IF( MONTH(B12+1) = MONTH(jan_1), B12+1, 0 ) )","v":"2024-01-29"},"2024-01-30","2024-01-31","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( MONTH(P11+1) = MONTH(fev_1), P11+1, 0 )","v":"2024-02-25"},{"$f":"IF( J12=0, 0, IF( MONTH(J12+1) = MONTH(fev_1), J12+1, 0 ) )","v":"2024-02-26"},"2024-02-27","2024-02-28","2024-02-29","00:00:00","00:00:00",null,{"$f":"IF( MONTH(X11+1) = MONTH(mar_1), X11+1, 0 )","v":"2024-03-24"},{"$f":"IF( R12=0, 0, IF( MONTH(R12+1) = MONTH(mar_1), R12+1, 0 ) )","v":"2024-03-25"},"2024-03-26","2024-03-27","2024-03-28","2024-03-29","2024-03-30",{"$nulls":12},7]
[null,{"$f":"IF( H12=0, 0, IF( MONTH(H12+1) = MONTH(jan_1), H12+1, 0 ) )","v":"00:00:00"},{"$f":"IF(B13=0, 0, IF( MONTH(B13+1) = MONTH(jan_1), B13+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( P12=0, 0, IF( MONTH(P12+1) = MONTH(fev_1), P12+1, 0 ) )","v":"00:00:00"},{"$f":"IF(J13=0, 0, IF( MONTH(J13+1) = MONTH(fev_1), J13+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( X12=0, 0, IF( MONTH(X12+1) = MONTH(mar_1), X12+1, 0 ) )","v":"2024-03-31"},{"$f":"IF(R13=0, 0, IF( MONTH(R13+1) = MONTH(mar_1), R13+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$nulls":3}," tabela feriados",{"$nulls":8},7]
[null,"01-Confraternização Universal",{"$nulls":7},{"$f":"IF(MONTH(páscoa-48)=2,CONCATENATE(TEXT(DAY(páscoa-48),\"dd\"),\" - \",\"Segunda-feira de Carnaval\"),\"\")","v":"12 - Segunda-feira de Carnaval"},{"$nulls":7},{"$f":"IF(MONTH(páscoa-48)=3,CONCATENATE(TEXT(DAY(páscoa-48),\"dd\"),\" - \",\"Seg de Carnaval\"),\"\")","v":""},{"$nulls":3},{"$f":"IF(MONTH(páscoa-2)=3,CONCATENATE(TEXT(DAY(páscoa-2),\"dd\"),\" - \",\"Sexta-feira Santa\"),\"\")","v":"29 - Sexta-feira Santa"},{"$nulls":14},7]
[null,"28 - Dia do Auditor Fiscal do Trabalho",{"$nulls":7},{"$f":"IF(MONTH(páscoa-47)=2,CONCATENATE(TEXT(DAY(páscoa-47),\"dd\"),\" - \",\"Terça-feira de Carnaval\"),\"\")","v":"13 - Terça-feira de Carnaval"},{"$nulls":7},{"$f":"IF(MONTH(páscoa-47)=3,CONCATENATE(TEXT(DAY(páscoa-47),\"dd\"),\" - \",\"Ter de Carnaval\"),\"\")","v":""},{"$nulls":3},{"$f":"IF(MONTH(páscoa)=3,CONCATENATE(TEXT(DAY(páscoa),\"dd\"),\" - \",\"Páscoa\"),\"\")","v":"31 - Páscoa"},{"$nulls":3},"REPOUSOS SEMANAIS",{"$nulls":10},7]
[null,{"$f":"DATE(aa,4,1)","v":"2024-04-01"},{"$nulls":7},{"$f":"DATE(aa,5,1)","v":"2024-05-01"},{"$nulls":7},{"$f":"DATE(aa,6,1)","v":"2024-06-01"},{"$nulls":18},7]
[null,"Abril",{"$nulls":7},"Maio",{"$nulls":7},"Junho",{"$nulls":7},{"$f":"aa","v":2024},"Qte. Seg a Sab","Domingos","Qte. Fer não Dom","Repousos","Dias Úteis","Verificação","REP/DU",{"$nulls":3},{"$error":"#VALUE!"}]
[null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",{"$nulls":12},7]
[null,{"$f":"IF( WEEKDAY(abr_1) = MOD(COLUMN()-1,8), abr_1, 0 )","v":"00:00:00"},{"$f":"IF( B19>0, B19+1, IF( WEEKDAY(abr_1)=MOD(COLUMN()-1,8), abr_1, 0) )","v":"2024-04-01"},"2024-04-02","2024-04-03","2024-04-04","2024-04-05","2024-04-06",null,{"$f":"IF( WEEKDAY(mai_1) = MOD(COLUMN()-1,8), mai_1, 0 )","v":"00:00:00"},{"$f":"IF( J19>0, J19+1, IF( WEEKDAY(mai_1)=MOD(COLUMN()-1,8), mai_1, 0) )","v":"00:00:00"},"00:00:00","2024-05-01","2024-05-02","2024-05-03","2024-05-04",null,{"$f":"IF( WEEKDAY(jun_1) = MOD(COLUMN()-1,8), jun_1, 0 )","v":"00:00:00"},{"$f":"IF( R19>0, R19+1, IF( WEEKDAY(jun_1)=MOD(COLUMN()-1,8), jun_1, 0) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","2024-06-01",null,{"$f":"DATE(aa,1,1)","v":"2024-01-01"},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z19&\":\"&DATE(aa,MONTH(Z19)+1,0))))>1)*1)","v":27},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z19&\":\"&DATE(aa,MONTH(Z19)+1,0))))=1)*1)","v":4},{"$f":"SUMPRODUCT(((WEEKDAY(fer_1)>1))*(fer_1>=Z19)*(fer_1<=DATE(aa,MONTH(Z19)+1,)))","v":1},{"$f":"SUM(AB19+AC19)","v":5},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z19&\":\"&DATE(aa,MONTH(Z19)+1,))))>1)*1)-SUMPRODUCT(((WEEKDAY(fer_1)>1))*(fer_1>=Z19)*(fer_1<=EOMONTH(Z19,0)))","v":26},{"$f":"SUM(AD19+AE19)","v":31},{"$f":"AD19&\"/\"&AE19","v":"5/26"},{"$nulls":3},3]
[null,{"$f":"H19+1","v":"2024-04-07"},{"$f":"B20+1","v":"2024-04-08"},"2024-04-09","2024-04-10","2024-04-11","2024-04-12","2024-04-13",null,{"$f":"P19+1","v":"2024-05-05"},{"$f":"J20+1","v":"2024-05-06"},"2024-05-07","2024-05-08","2024-05-09","2024-05-10","2024-05-11",null,{"$f":"X19+1","v":"2024-06-02"},{"$f":"R20+1","v":"2024-06-03"},"2024-06-04","2024-06-05","2024-06-06","2024-06-07","2024-06-08",null,{"$f":"DATE(aa,2,1)","v":"2024-02-01"},25,4,0,{"$f":"SUM(AB20+AC20)","v":4},25,{"$f":"SUM(AD20+AE20)","v":29},{"$f":"AD20&\"/\"&AE20","v":"4/25"},{"$nulls":3},1]
[null,{"$f":"H20+1","v":"2024-04-14"},"2024-04-15","2024-04-16","2024-04-17","2024-04-18","2024-04-19","2024-04-20",null,{"$f":"P20+1","v":"2024-05-12"},"2024-05-13","2024-05-14","2024-05-15","2024-05-16","2024-05-17","2024-05-18",null,{"$f":"X20+1","v":"2024-06-09"},"2024-06-10","2024-06-11","2024-06-12","2024-06-13","2024-06-14","2024-06-15",null,{"$f":"DATE(aa,3,1)","v":"2024-03-01"},26,5,1,6,25,31,"6/25",{"$nulls":3},3]
[null,{"$f":"H21+1","v":"2024-04-21"},"2024-04-22","2024-04-23","2024-04-24","2024-04-25","2024-04-26","2024-04-27",null,{"$f":"P21+1","v":"2024-05-19"},"2024-05-20","2024-05-21","2024-05-22","2024-05-23","2024-05-24","2024-05-25",null,{"$f":"X21+1","v":"2024-06-16"},"2024-06-17","2024-06-18","2024-06-19","2024-06-20","2024-06-21","2024-06-22",null,{"$f":"DATE(aa,4,1)","v":"2024-04-01"},26,4,0,4,26,30,"4/26"]
[null,{"$f":"IF( MONTH(H22+1) = MONTH(abr_1), H22+1, 0 )","v":"2024-04-28"},{"$f":"IF( B23=0, 0, IF( MONTH(B23+1) = MONTH(abr_1), B23+1, 0 ) )","v":"2024-04-29"},"2024-04-30","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( MONTH(P22+1) = MONTH(mai_1), P22+1, 0 )","v":"2024-05-26"},{"$f":"IF( J23=0, 0, IF( MONTH(J23+1) = MONTH(mai_1), J23+1, 0 ) )","v":"2024-05-27"},"2024-05-28","2024-05-29","2024-05-30","2024-05-31","00:00:00",null,{"$f":"IF( MONTH(X22+1) = MONTH(jun_1), X22+1, 0 )","v":"2024-06-23"},{"$f":"IF( R23=0, 0, IF( MONTH(R23+1) = MONTH(jun_1), R23+1, 0 ) )","v":"2024-06-24"},"2024-06-25","2024-06-26","2024-06-27","2024-06-28","2024-06-29",null,{"$f":"DATE(aa,5,1)","v":"2024-05-01"},27,4,2,6,25,31,"6/25"]
[null,{"$f":"IF( H23=0, 0, IF( MONTH(H23+1) = MONTH(abr_1), H23+1, 0 ) )","v":"00:00:00"},{"$f":"IF(B24=0, 0, IF( MONTH(B24+1) = MONTH(abr_1), B24+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( P23=0, 0, IF( MONTH(P23+1) = MONTH(mai_1), P23+1, 0 ) )","v":"00:00:00"},{"$f":"IF(J24=0, 0, IF( MONTH(J24+1) = MONTH(mai_1), J24+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( X23=0, 0, IF( MONTH(X23+1) = MONTH(jun_1), X23+1, 0 ) )","v":"2024-06-30"},{"$f":"IF(R24=0, 0, IF( MONTH(R24+1) = MONTH(jun_1), R24+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"DATE(aa,6,1)","v":"2024-06-01"},25,5,1,6,24,30,"6/24"]
[null,"21 - Tiradentes",null,null,{"$f":"IF(MONTH(páscoa-2)=4,CONCATENATE(TEXT(DAY(páscoa-2),\"dd\"),\" - \",\"Sexta-feira Santa\"),\"\")","v":""},{"$nulls":4},"01-Trabalho",{"$nulls":3},{"$f":"CONCATENATE(TEXT(DAY(d_mães),\"dd\"),\" - \",\"Dia das Mães\")","v":"12 - Dia das Mães"},{"$nulls":3},"10 - Aniversário de Foz",{"$nulls":3},"24 - Padroeiro Foz",{"$nulls":3},{"$f":"DATE(aa,7,1)","v":"2024-07-01"},27,4,0,4,27,31,"4/27"]
[null,{"$f":"IF(MONTH(páscoa)=4,CONCATENATE(TEXT(DAY(páscoa),\"dd\"),\" - \",\"Páscoa\"),\"\")","v":""},{"$nulls":7},{"$f":"IF(MONTH(páscoa+60)=5,CONCATENATE(TEXT(DAY(páscoa+60),\"dd\"),\" - \",\"Corpus Christi\"),\"\")","v":"30 - Corpus Christi"},{"$nulls":7},{"$f":"IF(MONTH(páscoa+60)=6,CONCATENATE(TEXT(DAY(páscoa+60),\"dd\"),\" - \",\"Corpus Christi\"),\"\")","v":""},{"$nulls":7},{"$f":"DATE(aa,8,1)","v":"2024-08-01"},27,4,0,4,27,31,"4/27"]
[null,{"$f":"DATE(aa,7,1)","v":"2024-07-01"},{"$nulls":7},{"$f":"DATE(aa,8,1)","v":"2024-08-01"},{"$nulls":7},{"$f":"DATE(aa,9,1)","v":"2024-09-01"},{"$nulls":7},{"$f":"DATE(aa,9,1)","v":"2024-09-01"},25,5,1,6,24,30,"6/24"]
[null,"Julho",{"$nulls":7},"Agosto",{"$nulls":7},"Setembro",{"$nulls":7},{"$f":"DATE(aa,10,1)","v":"2024-10-01"},27,4,2,6,25,31,"6/25"]
[null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,{"$f":"DATE(aa,11,1)","v":"2024-11-01"},26,4,3,7,23,30,"7/23"]
[null,{"$f":"IF( WEEKDAY(jul_1) = MOD(COLUMN()-1,8), jul_1, 0 )","v":"00:00:00"},{"$f":"IF( B30>0, B30+1, IF( WEEKDAY(jul_1)=MOD(COLUMN()-1,8), jul_1, 0) )","v":"2024-07-01"},"2024-07-02","2024-07-03","2024-07-04","2024-07-05","2024-07-06",null,{"$f":"IF( WEEKDAY(ago_1) = MOD(COLUMN()-1,8), ago_1, 0 )","v":"00:00:00"},{"$f":"IF( J30>0, J30+1, IF( WEEKDAY(ago_1)=MOD(COLUMN()-1,8), ago_1, 0) )","v":"00:00:00"},"00:00:00","00:00:00","2024-08-01","2024-08-02","2024-08-03",null,{"$f":"IF( WEEKDAY(set_1) = MOD(COLUMN()-1,8), set_1, 0 )","v":"2024-09-01"},{"$f":"IF( R30>0, R30+1, IF( WEEKDAY(set_1)=MOD(COLUMN()-1,8), set_1, 0) )","v":"2024-09-02"},"2024-09-03","2024-09-04","2024-09-05","2024-09-06","2024-09-07",null,{"$f":"DATE(aa,12,1)","v":"2024-12-01"},26,5,1,6,25,31,"6/25"]
[null,{"$f":"H30+1","v":"2024-07-07"},{"$f":"B31+1","v":"2024-07-08"},"2024-07-09","2024-07-10","2024-07-11","2024-07-12","2024-07-13",null,{"$f":"P30+1","v":"2024-08-04"},{"$f":"J31+1","v":"2024-08-05"},"2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10",null,{"$f":"X30+1","v":"2024-09-08"},{"$f":"R31+1","v":"2024-09-09"},"2024-09-10","2024-09-11","2024-09-12","2024-09-13","2024-09-14",null,"Início","Fim"]
[null,{"$f":"H31+1","v":"2024-07-14"},"2024-07-15","2024-07-16","2024-07-17","2024-07-18","2024-07-19","2024-07-20",null,{"$f":"P31+1","v":"2024-08-11"},"2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17",null,{"$f":"X31+1","v":"2024-09-15"},"2024-09-16","2024-09-17","2024-09-18","2024-09-19","2024-09-20","2024-09-21",null,{"$f":"DATE(aa,1,1)","v":"2024-01-01"},{"$f":"DATE(aa,12,31)","v":"2024-12-31"}]
[null,{"$f":"H32+1","v":"2024-07-21"},"2024-07-22","2024-07-23","2024-07-24","2024-07-25","2024-07-26","2024-07-27",null,{"$f":"P32+1","v":"2024-08-18"},"2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24",null,{"$f":"X32+1","v":"2024-09-22"},"2024-09-23","2024-09-24","2024-09-25","2024-09-26","2024-09-27","2024-09-28",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)),2)>5)+((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)),2)<6)*COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))>0))","v":113},"total de sábados, domingos e feriados no ano"]
[null,{"$f":"IF( MONTH(H33+1) = MONTH(jul_1), H33+1, 0 )","v":"2024-07-28"},{"$f":"IF( B34=0, 0, IF( MONTH(B34+1) = MONTH(jul_1), B34+1, 0 ) )","v":"2024-07-29"},"2024-07-30","2024-07-31","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( MONTH(P33+1) = MONTH(ago_1), P33+1, 0 )","v":"2024-08-25"},{"$f":"IF( J34=0, 0, IF( MONTH(J34+1) = MONTH(ago_1), J34+1, 0 ) )","v":"2024-08-26"},"2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31",null,{"$f":"IF( MONTH(X33+1) = MONTH(set_1), X33+1, 0 )","v":"2024-09-29"},{"$f":"IF( R34=0, 0, IF( MONTH(R34+1) = MONTH(set_1), R34+1, 0 ) )","v":"2024-09-30"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)),2)>5)*1)","v":104},"total de sábados e domingos no ano"]
[null,{"$f":"IF( H34=0, 0, IF( MONTH(H34+1) = MONTH(jul_1), H34+1, 0 ) )","v":"00:00:00"},{"$f":"IF(B35=0, 0, IF( MONTH(B35+1) = MONTH(jul_1), B35+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( P34=0, 0, IF( MONTH(P34+1) = MONTH(ago_1), P34+1, 0 ) )","v":"00:00:00"},{"$f":"IF(J35=0, 0, IF( MONTH(J35+1) = MONTH(ago_1), J35+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( X34=0, 0, IF( MONTH(X34+1) = MONTH(set_1), X34+1, 0 ) )","v":"00:00:00"},{"$f":"IF(R35=0, 0, IF( MONTH(R35+1) = MONTH(set_1), R35+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z$32&\":\"&AA$32)),2)=6)*1)","v":52},"quantidade de sábados no ano"]
[{"$nulls":9},{"$f":"CONCATENATE(TEXT(DAY(d_pais),\"dd\"),\" - \",\"Dia dos Pais\")","v":"11 - Dia dos Pais"},{"$nulls":7},"07-Independência",{"$nulls":8},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z$32&\":\"&AA$32)),2)=7)*1)","v":52},"quantidade de domingos no ano"]
[{"$nulls":26},{"$f":"SUMPRODUCT(((COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32))))>0)*1)","v":13},"quantidade de feriados"]
[null,{"$f":"DATE(aa,10,1)","v":"2024-10-01"},{"$nulls":7},{"$f":"DATE(aa,11,2)","v":"2024-11-02"},{"$nulls":7},{"$f":"DATE(aa,12,1)","v":"2024-12-01"},{"$nulls":8},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)))=1)+((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)))>1)*COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))>0))","v":64},"domingos ou feriados = total de repousos no ano"]
[null,"Outubro",{"$nulls":7},"Novembro",{"$nulls":7},"Dezembro",{"$nulls":8},{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)),2)>5)*(COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))=0))","v":100},"quantidade  de sábados e domingos que não são feriados"]
[null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,"Dom","Seg","Ter","Qua","Qui","Sex","Sáb",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)))=1)*(COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))=0))","v":51},"quantidade de domingos que não são feriados"]
[null,{"$f":"IF( WEEKDAY(out_1) = MOD(COLUMN()-1,8), out_1, 0 )","v":"00:00:00"},{"$f":"IF( B41>0, B41+1, IF( WEEKDAY(out_1)=MOD(COLUMN()-1,8), out_1, 0) )","v":"00:00:00"},"2024-10-01","2024-10-02","2024-10-03","2024-10-04","2024-10-05",null,{"$f":"IF( WEEKDAY(nov_1) = MOD(COLUMN()-1,8), nov_1, 0 )","v":"00:00:00"},{"$f":"IF( J41>0, J41+1, IF( WEEKDAY(nov_1)=MOD(COLUMN()-1,8), nov_1, 0) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","2024-11-02",null,{"$f":"IF( WEEKDAY(dez_1) = MOD(COLUMN()-1,8), dez_1, 0 )","v":"2024-12-01"},{"$f":"IF( R41>0, R41+1, IF( WEEKDAY(dez_1)=MOD(COLUMN()-1,8), dez_1, 0) )","v":"2024-12-02"},"2024-12-03","2024-12-04","2024-12-05","2024-12-06","2024-12-07",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)))>1)*(COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))>0))","v":12},"quantidade de feriados que não caem em domingo"]
[null,{"$f":"H41+1","v":"2024-10-06"},{"$f":"B42+1","v":"2024-10-07"},"2024-10-08","2024-10-09","2024-10-10","2024-10-11","2024-10-12",null,{"$f":"P41+1","v":"2024-11-03"},{"$f":"J42+1","v":"2024-11-04"},"2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09",null,{"$f":"X41+1","v":"2024-12-08"},{"$f":"R42+1","v":"2024-12-09"},"2024-12-10","2024-12-11","2024-12-12","2024-12-13","2024-12-14",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)))=1)*(COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))>0))","v":1},"quantidade de feriados que caem em domingo"]
[null,{"$f":"H42+1","v":"2024-10-13"},"2024-10-14","2024-10-15","2024-10-16","2024-10-17","2024-10-18","2024-10-19",null,{"$f":"P42+1","v":"2024-11-10"},"2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16",null,{"$f":"X42+1","v":"2024-12-15"},"2024-12-16","2024-12-17","2024-12-18","2024-12-19","2024-12-20","2024-12-21",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)),2)<6)*(COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))=0))","v":253},"quantidade de dias desconsiderando sábados, domingos e feriados"]
[null,{"$f":"H43+1","v":"2024-10-20"},"2024-10-21","2024-10-22","2024-10-23","2024-10-24","2024-10-25","2024-10-26",null,{"$f":"P43+1","v":"2024-11-17"},"2024-11-18","2024-11-19","2024-11-20","2024-11-21","2024-11-22","2024-11-23",null,{"$f":"X43+1","v":"2024-12-22"},"2024-12-23","2024-12-24","2024-12-25","2024-12-26","2024-12-27","2024-12-28",null,null,{"$f":"SUMPRODUCT((WEEKDAY(ROW(INDIRECT(Z32&\":\"&AA32)))>1)*(COUNTIF(fer_1,ROW(INDIRECT(Z32&\":\"&AA32)))=0))","v":302},"quantidade de dias úteis (sem domingos e feriados)"]
[null,{"$f":"IF( MONTH(H44+1) = MONTH(out_1), H44+1, 0 )","v":"2024-10-27"},{"$f":"IF( B45=0, 0, IF( MONTH(B45+1) = MONTH(out_1), B45+1, 0 ) )","v":"2024-10-28"},"2024-10-29","2024-10-30","2024-10-31","00:00:00","00:00:00",null,{"$f":"IF( MONTH(P44+1) = MONTH(nov_1), P44+1, 0 )","v":"2024-11-24"},{"$f":"IF( J45=0, 0, IF( MONTH(J45+1) = MONTH(nov_1), J45+1, 0 ) )","v":"2024-11-25"},"2024-11-26","2024-11-27","2024-11-28","2024-11-29","2024-11-30",null,{"$f":"IF( MONTH(X44+1) = MONTH(dez_1), X44+1, 0 )","v":"2024-12-29"},{"$f":"IF( R45=0, 0, IF( MONTH(R45+1) = MONTH(dez_1), R45+1, 0 ) )","v":"2024-12-30"},"2024-12-31","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,{"$f":"IF( H45=0, 0, IF( MONTH(H45+1) = MONTH(out_1), H45+1, 0 ) )","v":"00:00:00"},{"$f":"IF(B46=0, 0, IF( MONTH(B46+1) = MONTH(out_1), B46+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( P45=0, 0, IF( MONTH(P45+1) = MONTH(nov_1), P45+1, 0 ) )","v":"00:00:00"},{"$f":"IF(J46=0, 0, IF( MONTH(J46+1) = MONTH(nov_1), J46+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"IF( X45=0, 0, IF( MONTH(X45+1) = MONTH(dez_1), X45+1, 0 ) )","v":"00:00:00"},{"$f":"IF(R46=0, 0, IF( MONTH(R46+1) = MONTH(dez_1), R46+1, 0 ) )","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,"12 - Padroeira Brasil",{"$nulls":7},"02 - Finados",{"$nulls":7},"25-Natal"]
[null,"28 - Dia do Servidor Público",{"$nulls":7},"15 - Proclamação da República"]
[{"$nulls":9},"20 - Dia Nacional de Zumbi e da Consciência Negra"]
[]
[]
[null,{"$f":"aa","v":2024},"Jan","Fev","Mar","Abr","Mai","Jun","Jul","Ago","Set","Out","Nov","Dez"]
[null,"DU",{"$f":"AE19","v":26},{"$f":"AE20","v":25},{"$f":"AE21","v":25},{"$f":"AE22","v":26},{"$f":"AE23","v":25},{"$f":"AE24","v":24},{"$f":"AE25","v":27},{"$f":"AE26","v":27},{"$f":"AE27","v":24},{"$f":"AE28","v":25},{"$f":"AE29","v":23},{"$f":"AE30","v":25}]
[null,"Rep",{"$f":"AD19","v":5},{"$f":"AD20","v":4},{"$f":"AD21","v":6},{"$f":"AD22","v":4},{"$f":"AD23","v":6},{"$f":"AD24","v":6},{"$f":"AD25","v":4},{"$f":"AD26","v":4},{"$f":"AD27","v":6},{"$f":"AD28","v":6},{"$f":"AD29","v":7},{"$f":"AD30","v":6}]
[]
[]
[]
[]
[]
[]
[null,"SD\nDU",{"$f":"C54+C55&\"/\"&31-(C54+C55)","v":"5/26"},{"$f":"D54+D55&\"/\"&IF(MOD(C5,4)=0,29,28)-(D54+D55)","v":"4/25"},{"$f":"E54+E55&\"/\"&31-(E54+E55)","v":"6/25"},{"$f":"F54+F55&\"/\"&30-(F54+F55)","v":"4/26"},{"$f":"G54+G55&\"/\"&31-(G54+G55)","v":"6/25"},{"$f":"H54+H55&\"/\"&30-(H54+H55)","v":"6/24"},{"$f":"I54+I55&\"/\"&31-(I54+I55)","v":"4/27"},{"$f":"J54+J55&\"/\"&31-(J54+J55)","v":"4/27"},{"$f":"K54+K55&\"/\"&30-(K54+K55)","v":"6/24"},{"$f":"L54+L55&\"/\"&31-(L54+L55)","v":"6/25"},{"$f":"M54+M55&\"/\"&30-(M54+M55)","v":"7/23"},{"$f":"N54+N55&\"/\"&31-(N54+N55)","v":"6/25"},null,"Sábados e Domingos / Dias Úteis"]
[null,"SDF\nDU",{"$f":"C54+C55+C56-C57-C58&\"/\"&31-(C54+C55+C56-C57-C58)","v":"5/26"},{"$f":"D54+D55+D56&\"/\"&IF(MOD(C5,4)=0,29,28)-(D54+D55+D56)","v":"4/25"},{"$f":"E54+E55+E56&\"/\"&31-(E54+E55+E56)","v":"6/25"},{"$f":"F54+F55+F56-F57-F58&\"/\"&30-(F54+F55+F56-F57-F58)","v":"4/26"},{"$f":"G54+G55+G56-G57-G58&\"/\"&31-(G54+G55+G56-G57-G58)","v":"6/25"},{"$f":"H54+H55+H56&\"/\"&30-(H54+H55+H56)","v":"6/24"},{"$f":"I54+I55+I56&\"/\"&31-(I54+I55+I56)","v":"4/27"},{"$f":"J54+J55+J56&\"/\"&31-(J54+J55+J56)","v":"4/27"},{"$f":"K54+K55+K56-K57-K58&\"/\"&30-(K54+K55+K56-K57-K58)","v":"6/24"},{"$f":"L54+L55+L56-L57-L58&\"/\"&31-(L54+L55+L56-L57-L58)","v":"6/25"},{"$f":"M54+M55+M56-M57-M58&\"/\"&30-(M54+M55+M56-M57-M58)","v":"7/23"},{"$f":"N54+N55+N56-N57-N58&\"/\"&31-(N54+N55+N56-N57-N58)","v":"6/25"},null,"Sábados, Domingos e Feriados / Dias Úteis"]
{"$rows_empty":28}
[null,null,"Jan","Abr","Jul","Out",{"$nulls":4},"Fev","Mai","Ago","Nov",{"$nulls":3},"Mar","Jun","Set","Dez"]
[null,"2011-01-01",{"$f":"\"1/1/\" &L3","v":"1/1/2024"},{"$f":"R92+31","v":"2024-04-01"},{"$f":"S92+30","v":"2024-07-01"},{"$f":"T92+30","v":"2024-10-01"},{"$nulls":3},{"$f":"IF(OR((AND(MOD(YEAR(C92),4)=0,MOD(YEAR(C92),100)<>0)), (MOD(YEAR(C92),400)=0)), 29,28)","v":29},{"$f":"C92+31","v":"2024-02-01"},{"$f":"D92+30","v":"2024-05-01"},{"$f":"E92+31","v":"2024-08-01"},{"$f":"F92+31","v":"2024-11-01"},{"$nulls":3},{"$f":"K92+J92","v":"2024-03-01"},{"$f":"L92+31","v":"2024-06-01"},{"$f":"M92+31","v":"2024-09-01"},{"$f":"N92+30","v":"2024-12-01"}]
["Jan",{"$f":"IF(WEEKDAY($C$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($C$92)=2,1,0)","v":1},{"$f":"IF(WEEKDAY($C$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($C$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($C$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($C$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($C$92)=7,1,0)","v":0},"Fev",{"$f":"IF(WEEKDAY($K$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($K$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($K$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($K$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($K$92)=5,1,0)","v":1},{"$f":"IF(WEEKDAY($K$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($K$92)=7,1,0)","v":0},"Mar",{"$f":"IF(WEEKDAY($R$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($R$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($R$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($R$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($R$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($R$92)=6,1,0)","v":1},{"$f":"IF(WEEKDAY($R$92)=7,1,0)","v":0}]
["Abr",{"$f":"IF(WEEKDAY($D$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($D$92)=2,1,0)","v":1},{"$f":"IF(WEEKDAY($D$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($D$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($D$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($D$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($D$92)=7,1,0)","v":0},"Mai",{"$f":"IF(WEEKDAY($L$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($L$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($L$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($L$92)=4,1,0)","v":1},{"$f":"IF(WEEKDAY($L$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($L$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($L$92)=7,1,0)","v":0},"Jun",{"$f":"IF(WEEKDAY($S$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($S$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($S$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($S$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($S$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($S$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($S$92)=7,1,0)","v":1}]
["Jul",{"$f":"IF(WEEKDAY($E$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($E$92)=2,1,0)","v":1},{"$f":"IF(WEEKDAY($E$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($E$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($E$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($E$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($E$92)=7,1,0)","v":0},"Ago",{"$f":"IF(WEEKDAY($M$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($M$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($M$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($M$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($M$92)=5,1,0)","v":1},{"$f":"IF(WEEKDAY($M$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($M$92)=7,1,0)","v":0},"Set",{"$f":"IF(WEEKDAY($T$92)=1,1,0)","v":1},{"$f":"IF(WEEKDAY($T$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($T$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($T$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($T$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($T$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($T$92)=7,1,0)","v":0}]
["Out",{"$f":"IF(WEEKDAY($F$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($F$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($F$92)=3,1,0)","v":1},{"$f":"IF(WEEKDAY($F$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($F$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($F$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($F$92)=7,1,0)","v":0},"Nov",{"$f":"IF(WEEKDAY($N$92)=1,1,0)","v":0},{"$f":"IF(WEEKDAY($N$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($N$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($N$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($N$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($N$92)=6,1,0)","v":1},{"$f":"IF(WEEKDAY($N$92)=7,1,0)","v":0},"Dez",{"$f":"IF(WEEKDAY($U$92)=1,1,0)","v":1},{"$f":"IF(WEEKDAY($U$92)=2,1,0)","v":0},{"$f":"IF(WEEKDAY($U$92)=3,1,0)","v":0},{"$f":"IF(WEEKDAY($U$92)=4,1,0)","v":0},{"$f":"IF(WEEKDAY($U$92)=5,1,0)","v":0},{"$f":"IF(WEEKDAY($U$92)=6,1,0)","v":0},{"$f":"IF(WEEKDAY($U$92)=7,1,0)","v":0}]
[]
[{"$nulls":4},"Feriados:",{"$nulls":3},false,null,{"$f":"IF(I98=TRUE,1,2)","v":2}]
[]
[{"$nulls":4},"Quinto Dia Útil:",{"$nulls":3},false,null,{"$f":"IF(I100=TRUE,1,2)","v":2}]
[]
[]
[]
[{"$nulls":4},"Dia das Mães:",{"$nulls":3},{"$f":"DATE(aa,5,1)+IF(1<WEEKDAY(DATE(aa,5,1)),7-WEEKDAY(DATE(aa,5,1))+1,1-WEEKDAY(DATE(aa,5,1)))+(2-1)*7","v":"2024-05-12"}]
[]
[{"$nulls":4},"Dia dos Pais:",{"$nulls":3},{"$f":"DATE(aa,8,1)+IF(1<WEEKDAY(DATE(aa,8,1)),7-WEEKDAY(DATE(aa,8,1))+1,1-WEEKDAY(DATE(aa,8,1)))+(2-1)*7","v":"2024-08-11"}]

{"sheet":"Feriados","index":1,"n_rows":38,"n_cols":24,"rows_kept":38,"merged":[[2,0,2,5],[3,0,11,0],[12,0,14,0],[15,0,18,0]]}
[null,"ANO","PÁSCOA:"]
[null,{"$f":"aa","v":2024},{"$f":"ROUND(DATE($B$2,4,MOD(234-11*MOD($B$2,19),30))/7,)*7-6","v":"2024-03-31"}]
["Feriados Nacionais, Municipais e Estadual"]
["Feriados Nacionais","x","Ano Novo",{"$f":"IF($B$4=\"X\",DATE($B$2-1,1,1),DATE(1905,1,1))","v":"2023-01-01"},{"$f":"IF($B$4=\"X\",DATE($B$2,1,1),DATE(1905,1,1))","v":"2024-01-01"},{"$f":"IF($B$4=\"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"}]
[null,"x","Tiradentes",{"$f":"IF($B$5=\"X\",DATE($B$2-1,4,21),DATE(1905,1,1))","v":"2023-04-21"},{"$f":"IF($B$5=\"X\",DATE($B$2,4,21),DATE(1905,1,1))","v":"2024-04-21"},{"$f":"IF($B$5=\"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"}]
[null,"x","Dia do Trabalho",{"$f":"IF($B$6=\"X\",DATE($B$2-1,5,1),DATE(1905,1,1))","v":"2023-05-01"},{"$f":"IF($B$6=\"X\",DATE($B$2,5,1),DATE(1905,1,1))","v":"2024-05-01"},{"$f":"IF($B$6=\"X\",DATE($B$2+1,5,1),DATE(1905,1,1))","v":"2025-05-01"}]
[null,"x","Independência",{"$f":"IF($B$7=\"X\",DATE($B$2-1,9,7),DATE(1905,1,1))","v":"2023-09-07"},{"$f":"IF($B$7=\"X\",DATE($B$2,9,7),DATE(1905,1,1))","v":"2024-09-07"},{"$f":"IF($B$7=\"X\",DATE($B$2+1,9,7),DATE(1905,1,1))","v":"2025-09-07"},{"$nulls":16},1,1]
[null,"x","Padroeira do Brasil",{"$f":"IF($B$8=\"X\",DATE($B$2-1,10,12),DATE(1905,1,1))","v":"2023-10-12"},{"$f":"IF($B$8=\"X\",DATE($B$2,10,12),DATE(1905,1,1))","v":"2024-10-12"},{"$f":"IF($B$8=\"X\",DATE($B$2+1,10,12),DATE(1905,1,1))","v":"2025-10-12"},{"$nulls":16},2,2]
[null,"x","Finados",{"$f":"IF($B$9=\"X\",DATE($B$2-1,11,1),DATE(1905,1,1))","v":"2023-11-01"},{"$f":"IF($B$9=\"X\",DATE($B$2,11,2),DATE(1905,1,1))","v":"2024-11-02"},{"$f":"IF($B$9=\"X\",DATE($B$2+1,11,2),DATE(1905,1,1))","v":"2025-11-02"},{"$nulls":16},3,3]
[null,"x","Proclamação da República",{"$f":"IF($B$10=\"X\",DATE($B$2-1,11,15),DATE(1905,1,1))","v":"2023-11-15"},{"$f":"IF($B$10=\"X\",DATE($B$2,11,15),DATE(1905,1,1))","v":"2024-11-15"},{"$f":"IF($B$10=\"X\",DATE($B$2+1,11,15),DATE(1905,1,1))","v":"2025-11-15"},{"$nulls":16},4,4]
[null,"x","Zumbi e Consciência Negra",{"$f":"IF(AND($B$11=\"X\",YEAR($D$4)>2023),DATE($B$2-1,11,20),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF(AND($B$11=\"X\",YEAR($E$4)>2023),DATE($B$2,11,20),DATE(1905,1,1))","v":"2024-11-20"},{"$f":"IF(AND($B$11=\"X\",YEAR($F$4)>2023),DATE($B$2+1,11,20),DATE(1905,1,1))","v":"2025-11-20"}]
[null,"x","Natal",{"$f":"IF($B$12=\"X\",DATE($B$2-1,12,25),DATE(1905,1,1))","v":"2023-12-25"},{"$f":"IF($B$12=\"X\",DATE($B$2,12,25),DATE(1905,1,1))","v":"2024-12-25"},{"$f":"IF($B$12=\"X\",DATE($B$2+1,12,25),DATE(1905,1,1))","v":"2025-12-25"},{"$nulls":16},5,5]
["Móveis","x","Sexta-Feira Santa",{"$f":"IF($B$13=\"X\",$G$4-2,DATE(1905,1,1))","v":"2023-04-07"},{"$f":"IF($B$13=\"X\",páscoa-2,DATE(1905,1,1))","v":"2024-03-29"},{"$f":"IF($B$13=\"X\",$G$5-2,DATE(1905,1,1))","v":"2025-04-18"},{"$nulls":16},6,6]
[null,"x","Corpus Christi",{"$f":"IF($B$14=\"X\",$G$4+60,DATE(1905,1,1))","v":"2023-06-08"},{"$f":"IF($B$14=\"X\",páscoa+60,DATE(1905,1,1))","v":"2024-05-30"},{"$f":"IF($B$14=\"X\",$G$5+60,DATE(1905,1,1))","v":"2025-06-19"},{"$nulls":16},7,7]
[null,null,"Terça-Feira de Carnaval",{"$f":"IF($B$15=\"X\",$G$4-47,DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$15=\"X\",páscoa-47,DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$15=\"X\",$G$5-47,DATE(1905,1,1))","v":"1905-01-01"},"DIA","MÊS",{"$nulls":14},8,8]
["Fixos","x","Feriado local 1",{"$f":"IF($B$16=\"X\",DATE($B$2-1,$H$16,$G$16),DATE(1905,1,1))","v":"2023-06-18"},{"$f":"IF($B$16=\"X\",DATE($B$2,$H$16,$G$16),DATE(1905,1,1))","v":"2024-06-18"},{"$f":"IF($B$16=\"X\",DATE($B$2+1,$H$16,$G$16),DATE(1905,1,1))","v":"2025-06-18"},18,6,{"$nulls":14},9,9]
[null,"x","Feriado local 2",{"$f":"IF($B$17=\"X\",DATE($B$2-1,$H$17,$G$17),DATE(1905,1,1))","v":"2023-10-24"},{"$f":"IF($B$17=\"X\",DATE($B$2,$H$17,$G$17),DATE(1905,1,1))","v":"2024-10-24"},{"$f":"IF($B$17=\"X\",DATE($B$2+1,$H$17,$G$17),DATE(1905,1,1))","v":"2025-10-24"},24,10,{"$nulls":14},10,10]
[null,null,"Feriado local 3",{"$f":"IF($B$18=\"X\",DATE($B$2-1,$H$18,$G$18),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$18=\"X\",DATE($B$2,$H$18,$G$18),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$18=\"X\",DATE($B$2+1,$H$18,$G$18),DATE(1905,1,1))","v":"1905-01-01"},5,9,{"$nulls":14},11,11]
[null,null,"Feriado local 4",{"$f":"IF($B$19=\"X\",DATE($B$2-1,$H$19,$G$19),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$19=\"X\",DATE($B$2,$H$19,$G$19),DATE(1905,1,1))","v":"1905-01-01"},{"$f":"IF($B$19=\"X\",DATE($B$2+1,$H$19,$G$19),DATE(1905,1,1))","v":"1905-01-01"},10,3,{"$nulls":14},12,12]
[{"$nulls":22},13]
[{"$nulls":22},14]
[null,null,"Calendário",{"$nulls":19},15]
[{"$nulls":22},16]
[null,null,"Quinto dia útil",{"$nulls":19},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]

{"sheet":"Quinto dia útil","index":2,"n_rows":11,"n_cols":13,"rows_kept":11}
["Dias",{"$f":"DATE(aa,1,1)","v":"2024-01-01"},{"$f":"DATE(aa,2,1)","v":"2024-02-01"},{"$f":"DATE(aa,3,1)","v":"2024-03-01"},{"$f":"DATE(aa,4,1)","v":"2024-04-01"},{"$f":"DATE(aa,5,1)","v":"2024-05-01"},{"$f":"DATE(aa,6,1)","v":"2024-06-01"},{"$f":"DATE(aa,7,1)","v":"2024-07-01"},{"$f":"DATE(aa,8,1)","v":"2024-08-01"},{"$f":"DATE(aa,9,1)","v":"2024-09-01"},{"$f":"DATE(aa,10,1)","v":"2024-10-01"},{"$f":"DATE(aa,11,1)","v":"2024-11-01"},{"$f":"DATE(aa,12,1)","v":"2024-12-01"}]
[1,{"$f":"WORKDAY.INTL($B$1-1,A2,11,fer_1)","v":"2024-01-02"},{"$f":"WORKDAY.INTL($C$1-1,A2,11,fer_1)","v":"2024-02-01"},{"$f":"WORKDAY.INTL($D$1-1,A2,11,fer_1)","v":"2024-03-01"},{"$f":"WORKDAY.INTL($E$1-1,A2,11,fer_1)","v":"2024-04-01"},{"$f":"WORKDAY.INTL($F$1-1,A2,11,fer_1)","v":"2024-05-02"},{"$f":"WORKDAY.INTL($G$1-1,A2,11,fer_1)","v":"2024-06-01"},{"$f":"WORKDAY.INTL($H$1-1,A2,11,fer_1)","v":"2024-07-01"},{"$f":"WORKDAY.INTL($I$1-1,A2,11,fer_1)","v":"2024-08-01"},{"$f":"WORKDAY.INTL($J$1-1,A2,11,fer_1)","v":"2024-09-02"},{"$f":"WORKDAY.INTL($K$1-1,A2,11,fer_1)","v":"2024-10-01"},{"$f":"WORKDAY.INTL($L$1-1,A2,11,fer_1)","v":"2024-11-01"},{"$f":"WORKDAY.INTL($M$1-1,A2,11,fer_1)","v":"2024-12-02"}]
[2,{"$f":"WORKDAY.INTL($B$1-1,A3,11,fer_1)","v":"2024-01-03"},{"$f":"WORKDAY.INTL($C$1-1,A3,11,fer_1)","v":"2024-02-02"},{"$f":"WORKDAY.INTL($D$1-1,A3,11,fer_1)","v":"2024-03-02"},{"$f":"WORKDAY.INTL($E$1-1,A3,11,fer_1)","v":"2024-04-02"},{"$f":"WORKDAY.INTL($F$1-1,A3,11,fer_1)","v":"2024-05-03"},{"$f":"WORKDAY.INTL($G$1-1,A3,11,fer_1)","v":"2024-06-03"},{"$f":"WORKDAY.INTL($H$1-1,A3,11,fer_1)","v":"2024-07-02"},{"$f":"WORKDAY.INTL($I$1-1,A3,11,fer_1)","v":"2024-08-02"},{"$f":"WORKDAY.INTL($J$1-1,A3,11,fer_1)","v":"2024-09-03"},{"$f":"WORKDAY.INTL($K$1-1,A3,11,fer_1)","v":"2024-10-02"},{"$f":"WORKDAY.INTL($L$1-1,A3,11,fer_1)","v":"2024-11-04"},{"$f":"WORKDAY.INTL($M$1-1,A3,11,fer_1)","v":"2024-12-03"}]
[3,{"$f":"WORKDAY.INTL($B$1-1,A4,11,fer_1)","v":"2024-01-04"},{"$f":"WORKDAY.INTL($C$1-1,A4,11,fer_1)","v":"2024-02-03"},{"$f":"WORKDAY.INTL($D$1-1,A4,11,fer_1)","v":"2024-03-04"},{"$f":"WORKDAY.INTL($E$1-1,A4,11,fer_1)","v":"2024-04-03"},{"$f":"WORKDAY.INTL($F$1-1,A4,11,fer_1)","v":"2024-05-04"},{"$f":"WORKDAY.INTL($G$1-1,A4,11,fer_1)","v":"2024-06-04"},{"$f":"WORKDAY.INTL($H$1-1,A4,11,fer_1)","v":"2024-07-03"},{"$f":"WORKDAY.INTL($I$1-1,A4,11,fer_1)","v":"2024-08-03"},{"$f":"WORKDAY.INTL($J$1-1,A4,11,fer_1)","v":"2024-09-04"},{"$f":"WORKDAY.INTL($K$1-1,A4,11,fer_1)","v":"2024-10-03"},{"$f":"WORKDAY.INTL($L$1-1,A4,11,fer_1)","v":"2024-11-05"},{"$f":"WORKDAY.INTL($M$1-1,A4,11,fer_1)","v":"2024-12-04"}]
[4,{"$f":"WORKDAY.INTL($B$1-1,A5,11,fer_1)","v":"2024-01-05"},{"$f":"WORKDAY.INTL($C$1-1,A5,11,fer_1)","v":"2024-02-05"},{"$f":"WORKDAY.INTL($D$1-1,A5,11,fer_1)","v":"2024-03-05"},{"$f":"WORKDAY.INTL($E$1-1,A5,11,fer_1)","v":"2024-04-04"},{"$f":"WORKDAY.INTL($F$1-1,A5,11,fer_1)","v":"2024-05-06"},{"$f":"WORKDAY.INTL($G$1-1,A5,11,fer_1)","v":"2024-06-05"},{"$f":"WORKDAY.INTL($H$1-1,A5,11,fer_1)","v":"2024-07-04"},{"$f":"WORKDAY.INTL($I$1-1,A5,11,fer_1)","v":"2024-08-05"},{"$f":"WORKDAY.INTL($J$1-1,A5,11,fer_1)","v":"2024-09-05"},{"$f":"WORKDAY.INTL($K$1-1,A5,11,fer_1)","v":"2024-10-04"},{"$f":"WORKDAY.INTL($L$1-1,A5,11,fer_1)","v":"2024-11-06"},{"$f":"WORKDAY.INTL($M$1-1,A5,11,fer_1)","v":"2024-12-05"}]
[5,{"$f":"WORKDAY.INTL($B$1-1,A6,11,fer_1)","v":"2024-01-06"},{"$f":"WORKDAY.INTL($C$1-1,A6,11,fer_1)","v":"2024-02-06"},{"$f":"WORKDAY.INTL($D$1-1,A6,11,fer_1)","v":"2024-03-06"},{"$f":"WORKDAY.INTL($E$1-1,A6,11,fer_1)","v":"2024-04-05"},{"$f":"WORKDAY.INTL($F$1-1,A6,11,fer_1)","v":"2024-05-07"},{"$f":"WORKDAY.INTL($G$1-1,A6,11,fer_1)","v":"2024-06-06"},{"$f":"WORKDAY.INTL($H$1-1,A6,11,fer_1)","v":"2024-07-05"},{"$f":"WORKDAY.INTL($I$1-1,A6,11,fer_1)","v":"2024-08-06"},{"$f":"WORKDAY.INTL($J$1-1,A6,11,fer_1)","v":"2024-09-06"},{"$f":"WORKDAY.INTL($K$1-1,A6,11,fer_1)","v":"2024-10-05"},{"$f":"WORKDAY.INTL($L$1-1,A6,11,fer_1)","v":"2024-11-07"},{"$f":"WORKDAY.INTL($M$1-1,A6,11,fer_1)","v":"2024-12-06"}]
[]
[]
[{"$nulls":3},"Calendário"]
[]
[{"$nulls":3},"Tabela de feriados"]