{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Planejador Anual","Compromissos","cálculos"],"not_rendered":{"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Planejador Anual","index":0,"n_rows":42,"n_cols":17,"rows_kept":42}
[null,{"$f":"AnoDeInício&\" - \"&AnoDeInício+1","v":"2022 - 2023"},{"$nulls":3},"CALENDÁRIO DO ANO UNIVERSITÁRIO"]
[]
[null,null,{"$f":"YEAR(TODAY())","v":2022}," Ano de Início",{"$nulls":12},"VISÃO GERAL DO DIA"]
[]
[null,null,{"$f":"CabeçalhosDoMês_Valores","v":"2022-09-01"},"2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01",null,null,{"$f":"TODAY()","v":"2022-08-03"}]
[null,{"$f":"cálculos!B7:B43","v":"SEG"},{"$f":"Compromissos","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(1,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":"10:00:00"},{"$f":"IFERROR(VLOOKUP(1,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":"Dentista"}]
[null,"TER",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(2,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":"21:00:00"},{"$f":"IFERROR(VLOOKUP(2,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":"Festa de aniversário da Lara"}]
[null,"QUA",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(3,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(3,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"QUI",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(4,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(4,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SEX",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(5,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(5,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SAB",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(6,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(6,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"DOM",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(7,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(7,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SEG",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(8,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(8,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"TER",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(9,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(9,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"QUA",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(10,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(10,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"QUI",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(11,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(11,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SEX",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(12,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(12,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SAB",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(13,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(13,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"DOM",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(14,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(14,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SEG",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(15,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(15,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"TER",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(16,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(16,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"QUA",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(17,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(17,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"QUI",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(18,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(18,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SEX",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(19,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(19,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"SAB",0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(VLOOKUP(20,CompromissosClassificadosDeHoje[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(20,CompromissosClassificadosDeHoje[],3,FALSE),\"\")","v":""}]
[null,"DOM",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SEG",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TER",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"QUA",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"QUI",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SEX",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SAB",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DOM",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SEG",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TER",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"QUA",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"QUI",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SEX",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SAB",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DOM",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SEG",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TER",0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Compromissos","index":1,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,"COMPROMISSOS"]
[]
[null,"COMPROMISSOS"]
[null,"DATA","HORA","DESCRIÇÃO"]
[null,{"$f":"TODAY()","v":"2022-08-03"},"10:00:00","Dentista"]
[null,{"$f":"TODAY()","v":"2022-08-03"},"21:00:00","Festa de aniversário da Lara"]
[null,{"$f":"TODAY()+1","v":"2022-08-04"},"16:00:00","Grupo de estudo"]
[null,{"$f":"TODAY()+2","v":"2022-08-05"},"21:00:00","Entrega de panfletos no centro juvenil"]
[null,{"$f":"TODAY()+3","v":"2022-08-06"},"10:00:00","Grupo de estudo"]
[null,{"$f":"TODAY()+4","v":"2022-08-07"},"13:00:00","Prova"]
[null,{"$f":"TODAY()+5","v":"2022-08-08"},"15:00:00","Prova"]
[null,{"$f":"TODAY()+7","v":"2022-08-10"},"18:00:00","Festa da universidade"]
[null,{"$f":"TODAY()+8","v":"2022-08-11"},"10:30:00","Encontrar o Davi na academia de ginástica"]
[null,{"$f":"TODAY()+9","v":"2022-08-12"},"10:00:00","Prova"]
[null,{"$f":"TODAY()+10","v":"2022-08-13"},"19:00:00","Grupo de estudo"]
[null,{"$f":"TODAY()+11","v":"2022-08-14"},"21:00:00","Trabalho Noturno"]

{"sheet":"cálculos","index":2,"n_rows":43,"n_cols":25,"rows_kept":43,"hidden":true}
[{"$nulls":15},"Data"]
[null,null,"Cálculos Ocultos",{"$nulls":12},{"$f":"TODAY()","v":"2022-08-03"},null,null,"Classificação automática de tarefas diárias, itens idênticos no mesmo dia"]
[{"$nulls":18},"funciona para até 20 compromissos em um único dia"]
[null,null,"***Esta planilha deve permanecer oculta***",{"$nulls":14},"Intervalo","CLASSIFICAR","Hora","Compromisso",null,"Classificação Selecionada","Hora","Compromisso"]
[{"$nulls":17},{"$f":"IFERROR(RANK(S5,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S5=cálculos!$S$5:$S$24),--(U5>cálculos!$U$5:$U$24)),\"\")","v":1},{"$f":"IFERROR(RANK($T5,cálculos!$T$5:$T$24,1),\"\")","v":1},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A1)),2),\"\")","v":"10:00:00"},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A1)),3),\"\")","v":"Dentista"},null,1,{"$f":"IFERROR(VLOOKUP(W5,ClassificarTabela[],3,FALSE),\"\")","v":"10:00:00"},{"$f":"IFERROR(VLOOKUP(W5,ClassificarTabela[],4,FALSE),\"\")","v":"Dentista"}]
[null,null,{"$f":"CabeçalhosDoMês_Valores","v":"2022-09-01"},"2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01",{"$nulls":3},{"$f":"IFERROR(RANK(S6,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S6=cálculos!$S$5:$S$24),--(U6>cálculos!$U$5:$U$24)),\"\")","v":2},{"$f":"IFERROR(RANK($T6,cálculos!$T$5:$T$24,1),\"\")","v":2},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A2)),2),\"\")","v":"21:00:00"},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A2)),3),\"\")","v":"Festa de aniversário da Lara"},null,2,{"$f":"IFERROR(VLOOKUP(W6,ClassificarTabela[],3,FALSE),\"\")","v":"21:00:00"},{"$f":"IFERROR(VLOOKUP(W6,ClassificarTabela[],4,FALSE),\"\")","v":"Festa de aniversário da Lara"}]
[null,"SEG",{"$f":"IF(MONTH(C6:N6-WEEKDAY(C6:N6,2)+ROW(1:50))=MONTH(C6:N6),C6:N6-WEEKDAY(C6:N6,2)+ROW(1:50),\"\")","v":""},"","","","","","","","2023-05-01","","","",{"$nulls":3},{"$f":"IFERROR(RANK(S7,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S7=cálculos!$S$5:$S$24),--(U7>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T7,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A3)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A3)),3),\"\")","v":""},null,3,{"$f":"IFERROR(VLOOKUP(W7,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W7,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"TER","","","2022-11-01","","","","","","2023-05-02","","","2023-08-01",{"$nulls":3},{"$f":"IFERROR(RANK(S8,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S8=cálculos!$S$5:$S$24),--(U8>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T8,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A4)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A4)),3),\"\")","v":""},null,4,{"$f":"IFERROR(VLOOKUP(W8,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W8,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"QUA","","","2022-11-02","","","2023-02-01","2023-03-01","","2023-05-03","","","2023-08-02",{"$nulls":3},{"$f":"IFERROR(RANK(S9,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S9=cálculos!$S$5:$S$24),--(U9>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T9,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A5)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A5)),3),\"\")","v":""},null,5,{"$f":"IFERROR(VLOOKUP(W9,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W9,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"QUI","2022-09-01","","2022-11-03","2022-12-01","","2023-02-02","2023-03-02","","2023-05-04","2023-06-01","","2023-08-03",{"$nulls":3},{"$f":"IFERROR(RANK(S10,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S10=cálculos!$S$5:$S$24),--(U10>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T10,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A6)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A6)),3),\"\")","v":""},null,6,{"$f":"IFERROR(VLOOKUP(W10,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W10,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SEX","2022-09-02","","2022-11-04","2022-12-02","","2023-02-03","2023-03-03","","2023-05-05","2023-06-02","","2023-08-04",{"$nulls":3},{"$f":"IFERROR(RANK(S11,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S11=cálculos!$S$5:$S$24),--(U11>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T11,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A7)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A7)),3),\"\")","v":""},null,7,{"$f":"IFERROR(VLOOKUP(W11,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W11,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SAB","2022-09-03","2022-10-01","2022-11-05","2022-12-03","","2023-02-04","2023-03-04","2023-04-01","2023-05-06","2023-06-03","2023-07-01","2023-08-05",{"$nulls":3},{"$f":"IFERROR(RANK(S12,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S12=cálculos!$S$5:$S$24),--(U12>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T12,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A8)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A8)),3),\"\")","v":""},null,8,{"$f":"IFERROR(VLOOKUP(W12,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W12,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"DOM","2022-09-04","2022-10-02","2022-11-06","2022-12-04","2023-01-01","2023-02-05","2023-03-05","2023-04-02","2023-05-07","2023-06-04","2023-07-02","2023-08-06",{"$nulls":3},{"$f":"IFERROR(RANK(S13,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S13=cálculos!$S$5:$S$24),--(U13>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T13,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A9)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A9)),3),\"\")","v":""},null,9,{"$f":"IFERROR(VLOOKUP(W13,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W13,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SEG","2022-09-05","2022-10-03","2022-11-07","2022-12-05","2023-01-02","2023-02-06","2023-03-06","2023-04-03","2023-05-08","2023-06-05","2023-07-03","2023-08-07",{"$nulls":3},{"$f":"IFERROR(RANK(S14,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S14=cálculos!$S$5:$S$24),--(U14>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T14,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A10)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A10)),3),\"\")","v":""},null,10,{"$f":"IFERROR(VLOOKUP(W14,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W14,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"TER","2022-09-06","2022-10-04","2022-11-08","2022-12-06","2023-01-03","2023-02-07","2023-03-07","2023-04-04","2023-05-09","2023-06-06","2023-07-04","2023-08-08",{"$nulls":3},{"$f":"IFERROR(RANK(S15,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S15=cálculos!$S$5:$S$24),--(U15>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T15,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A11)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A11)),3),\"\")","v":""},null,11,{"$f":"IFERROR(VLOOKUP(W15,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W15,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"QUA","2022-09-07","2022-10-05","2022-11-09","2022-12-07","2023-01-04","2023-02-08","2023-03-08","2023-04-05","2023-05-10","2023-06-07","2023-07-05","2023-08-09",{"$nulls":3},{"$f":"IFERROR(RANK(S16,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S16=cálculos!$S$5:$S$24),--(U16>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T16,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A12)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A12)),3),\"\")","v":""},null,12,{"$f":"IFERROR(VLOOKUP(W16,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W16,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"QUI","2022-09-08","2022-10-06","2022-11-10","2022-12-08","2023-01-05","2023-02-09","2023-03-09","2023-04-06","2023-05-11","2023-06-08","2023-07-06","2023-08-10",{"$nulls":3},{"$f":"IFERROR(RANK(S17,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S17=cálculos!$S$5:$S$24),--(U17>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T17,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A13)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A13)),3),\"\")","v":""},null,13,{"$f":"IFERROR(VLOOKUP(W17,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W17,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SEX","2022-09-09","2022-10-07","2022-11-11","2022-12-09","2023-01-06","2023-02-10","2023-03-10","2023-04-07","2023-05-12","2023-06-09","2023-07-07","2023-08-11",{"$nulls":3},{"$f":"IFERROR(RANK(S18,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S18=cálculos!$S$5:$S$24),--(U18>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T18,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A14)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A14)),3),\"\")","v":""},null,14,{"$f":"IFERROR(VLOOKUP(W18,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W18,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SAB","2022-09-10","2022-10-08","2022-11-12","2022-12-10","2023-01-07","2023-02-11","2023-03-11","2023-04-08","2023-05-13","2023-06-10","2023-07-08","2023-08-12",{"$nulls":3},{"$f":"IFERROR(RANK(S19,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S19=cálculos!$S$5:$S$24),--(U19>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T19,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A15)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A15)),3),\"\")","v":""},null,15,{"$f":"IFERROR(VLOOKUP(W19,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W19,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"DOM","2022-09-11","2022-10-09","2022-11-13","2022-12-11","2023-01-08","2023-02-12","2023-03-12","2023-04-09","2023-05-14","2023-06-11","2023-07-09","2023-08-13",{"$nulls":3},{"$f":"IFERROR(RANK(S20,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S20=cálculos!$S$5:$S$24),--(U20>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T20,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A16)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A16)),3),\"\")","v":""},null,16,{"$f":"IFERROR(VLOOKUP(W20,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W20,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SEG","2022-09-12","2022-10-10","2022-11-14","2022-12-12","2023-01-09","2023-02-13","2023-03-13","2023-04-10","2023-05-15","2023-06-12","2023-07-10","2023-08-14",{"$nulls":3},{"$f":"IFERROR(RANK(S21,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S21=cálculos!$S$5:$S$24),--(U21>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T21,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A17)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A17)),3),\"\")","v":""},null,17,{"$f":"IFERROR(VLOOKUP(W21,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W21,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"TER","2022-09-13","2022-10-11","2022-11-15","2022-12-13","2023-01-10","2023-02-14","2023-03-14","2023-04-11","2023-05-16","2023-06-13","2023-07-11","2023-08-15",{"$nulls":3},{"$f":"IFERROR(RANK(S22,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S22=cálculos!$S$5:$S$24),--(U22>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T22,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A18)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A18)),3),\"\")","v":""},null,18,{"$f":"IFERROR(VLOOKUP(W22,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W22,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"QUA","2022-09-14","2022-10-12","2022-11-16","2022-12-14","2023-01-11","2023-02-15","2023-03-15","2023-04-12","2023-05-17","2023-06-14","2023-07-12","2023-08-16",{"$nulls":3},{"$f":"IFERROR(RANK(S23,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S23=cálculos!$S$5:$S$24),--(U23>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T23,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A19)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A19)),3),\"\")","v":""},null,19,{"$f":"IFERROR(VLOOKUP(W23,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W23,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"QUI","2022-09-15","2022-10-13","2022-11-17","2022-12-15","2023-01-12","2023-02-16","2023-03-16","2023-04-13","2023-05-18","2023-06-15","2023-07-13","2023-08-17",{"$nulls":3},{"$f":"IFERROR(RANK(S24,cálculos!$S$5:$S$24,1)+SUMPRODUCT(--(S24=cálculos!$S$5:$S$24),--(U24>cálculos!$U$5:$U$24)),\"\")","v":""},{"$f":"IFERROR(RANK($T24,cálculos!$T$5:$T$24,1),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A20)),2),\"\")","v":""},{"$f":"IFERROR(INDEX(DetalhesDoCompromisso[],SMALL(IF(DetalhesDoCompromisso[DATA]=DataDeHoje,ROW(DetalhesDoCompromisso[DATA])-4),ROW(A20)),3),\"\")","v":""},null,20,{"$f":"IFERROR(VLOOKUP(W24,ClassificarTabela[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(W24,ClassificarTabela[],4,FALSE),\"\")","v":""}]
[null,"SEX","2022-09-16","2022-10-14","2022-11-18","2022-12-16","2023-01-13","2023-02-17","2023-03-17","2023-04-14","2023-05-19","2023-06-16","2023-07-14","2023-08-18"]
[null,"SAB","2022-09-17","2022-10-15","2022-11-19","2022-12-17","2023-01-14","2023-02-18","2023-03-18","2023-04-15","2023-05-20","2023-06-17","2023-07-15","2023-08-19"]
[null,"DOM","2022-09-18","2022-10-16","2022-11-20","2022-12-18","2023-01-15","2023-02-19","2023-03-19","2023-04-16","2023-05-21","2023-06-18","2023-07-16","2023-08-20"]
[null,"SEG","2022-09-19","2022-10-17","2022-11-21","2022-12-19","2023-01-16","2023-02-20","2023-03-20","2023-04-17","2023-05-22","2023-06-19","2023-07-17","2023-08-21"]
[null,"TER","2022-09-20","2022-10-18","2022-11-22","2022-12-20","2023-01-17","2023-02-21","2023-03-21","2023-04-18","2023-05-23","2023-06-20","2023-07-18","2023-08-22"]
[null,"QUA","2022-09-21","2022-10-19","2022-11-23","2022-12-21","2023-01-18","2023-02-22","2023-03-22","2023-04-19","2023-05-24","2023-06-21","2023-07-19","2023-08-23"]
[null,"QUI","2022-09-22","2022-10-20","2022-11-24","2022-12-22","2023-01-19","2023-02-23","2023-03-23","2023-04-20","2023-05-25","2023-06-22","2023-07-20","2023-08-24"]
[null,"SEX","2022-09-23","2022-10-21","2022-11-25","2022-12-23","2023-01-20","2023-02-24","2023-03-24","2023-04-21","2023-05-26","2023-06-23","2023-07-21","2023-08-25"]
[null,"SAB","2022-09-24","2022-10-22","2022-11-26","2022-12-24","2023-01-21","2023-02-25","2023-03-25","2023-04-22","2023-05-27","2023-06-24","2023-07-22","2023-08-26"]
[null,"DOM","2022-09-25","2022-10-23","2022-11-27","2022-12-25","2023-01-22","2023-02-26","2023-03-26","2023-04-23","2023-05-28","2023-06-25","2023-07-23","2023-08-27"]
[null,"SEG","2022-09-26","2022-10-24","2022-11-28","2022-12-26","2023-01-23","2023-02-27","2023-03-27","2023-04-24","2023-05-29","2023-06-26","2023-07-24","2023-08-28"]
[null,"TER","2022-09-27","2022-10-25","2022-11-29","2022-12-27","2023-01-24","2023-02-28","2023-03-28","2023-04-25","2023-05-30","2023-06-27","2023-07-25","2023-08-29"]
[null,"QUA","2022-09-28","2022-10-26","2022-11-30","2022-12-28","2023-01-25","","2023-03-29","2023-04-26","2023-05-31","2023-06-28","2023-07-26","2023-08-30"]
[null,"QUI","2022-09-29","2022-10-27","","2022-12-29","2023-01-26","","2023-03-30","2023-04-27","","2023-06-29","2023-07-27","2023-08-31"]
[null,"SEX","2022-09-30","2022-10-28","","2022-12-30","2023-01-27","","2023-03-31","2023-04-28","","2023-06-30","2023-07-28",""]
[null,"SAB","","2022-10-29","","2022-12-31","2023-01-28","","","2023-04-29","","","2023-07-29",""]
[null,"DOM","","2022-10-30","","","2023-01-29","","","2023-04-30","","","2023-07-30",""]
[null,"SEG","","2022-10-31","","","2023-01-30","","","","","","2023-07-31",""]
[null,"TER","","","","","2023-01-31","","","","","","",""]