{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INSTRUÇÕES","Instruções PDF meio fisico","TEXTO PARA INSERIR NO DAE","MENU INICIAL DRT","DRT","LISTA SUSPENSA","Banco de dados envio SEF","VALOR UFFEMG"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUÇÕES","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"DECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO - ITCD (Causa Mortis)"]
[]
[null,null,"Planilha Auxiliar para preechimento do da DRT (Declaração de Responsável Tributário)"]
[]
[null,"1 -","Essa planilha se presta a auxiliar o preenchimento da DRT, em caráter de contigência, para somente óbitos anteriores a 30/03/2004, pois para óbitos a partir desta data, as responsáveis tributárias deverão utilizar o modelo disponibilizado na Internet, https://www2.fazenda.mg.gov.br/sol/, de acordo com o § 1o do artigo 35-A do Decreto 43.981/2005.\nAtravés dela são gerados os seguintes documentos/relatórios:"]
[]
[null,null,"a) Arquivo formato Excel para envio à SEF/MG; "]
[]
[]
[null,"2 - ","Após o envio da declaração, DRT, a Repartição Fazendária realizará o cálculo e retornará o Documento de Arrecadação Estadual -DAE. Se necessário, a Reparticão Fazendária, poderá solicitará documentos adicionais para realizar este cálculo."]
[]
[]
[null,"3 -","Atualização dos Dados "]
[]
[null,null,"a)Todos os campos PARTICIPANTE, CPF VÁLIDO, DATA ÓBITO e DATA DO AVISO deverão ser preenchidos. (mensagem \"Completa\")"]
[null,null,"b) Foram disponbilizados campos para a inserção de até 4 contratos por beneficiário, em caso de necessidade de um maior número de campos, os dados deverão ser inseridos novamente na linha imediatamente posterior, e os valores somandos ao final. Esta soma que deverá ser utilizada para gerar o único DAE para o CPF do falecido. O número do DAE deverá ser preenchido em ambos os campos que pertencerem ao mesmo Participante. "]
[]
[]
[null,"4 -","Email para SEF/MG"]
[null,null,"a) O arquivo do referido formulário deverá ser encaminhado à SEF/MG no email: dgfoutrasreceitas@fazenda.mg.gov.br"]
[]
[null,null,"Observações:"]
[]
[null,null,"a) O vencimento da obrigação de entrega da DRT e pagamento do ITCD, ocorrerá no dia 20 do mês subsequente à comunicação;"]
[null,null,"b)Nos casos em que a DRT for entregue após o vencimento da responsável tributária, dia 20 do mês subsequentes,  irá aparecer no Tipo de Declaração, a informações de que essa DRT se trata de um documento: \"Complementar\" ou \"Em atraso\". "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"* Para que os botões funcionem é necessário que o arquivo seja salvo no formato Excel Macros, XLMS."]

{"sheet":"Instruções PDF meio fisico","index":1,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[null,"Instruções criação e impressão de PDF em meio físico"]
[null,"No menu \"Arquivo\", escolher a opção, \"Exportar\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"a) Na opção \"Exportar\", escolher \"Criar Documento PDF/XPS;"]
[null,"b) Escolher uma pasta qualquer do computador para gravação em PDF;"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"a) No tipo escolher a opção PDF; "]
[null,"b) Clicar em publicar."]

{"sheet":"TEXTO PARA INSERIR NO DAE","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,3,1,9]]}
[]
[null,null,null,"TEXTO PARA INSERIR NO DAE"]
[null,1,"Participante:",{"$f":"VLOOKUP(B3,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B3,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B3,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B3,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,2,"Participante:",{"$f":"VLOOKUP(B4,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B4,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B4,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B4,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,3,"Participante:",{"$f":"VLOOKUP(B5,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B5,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B5,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B5,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,4,"Participante:",{"$f":"VLOOKUP(B6,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B6,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B6,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B6,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,5,"Participante:",{"$f":"VLOOKUP(B7,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B7,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B7,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B7,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,6,"Participante:",{"$f":"VLOOKUP(B8,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B8,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B8,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B8,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,7,"Participante:",{"$f":"VLOOKUP(B9,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B9,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B9,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B9,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,8,"Participante:",{"$f":"VLOOKUP(B10,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B10,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B10,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B10,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,9,"Participante:",{"$f":"VLOOKUP(B11,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B11,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B11,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B11,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,10,"Participante:",{"$f":"VLOOKUP(B12,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B12,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B12,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B12,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,11,"Participante:",{"$f":"VLOOKUP(B13,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B13,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B13,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B13,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,12,"Participante:",{"$f":"VLOOKUP(B14,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B14,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B14,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B14,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,13,"Participante:",{"$f":"VLOOKUP(B15,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B15,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B15,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B15,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,14,"Participante:",{"$f":"VLOOKUP(B16,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B16,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B16,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B16,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,15,"Participante:",{"$f":"VLOOKUP(B17,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B17,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B17,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B17,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,16,"Participante:",{"$f":"VLOOKUP(B18,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B18,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B18,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B18,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,17,"Participante:",{"$f":"VLOOKUP(B19,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B19,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B19,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B19,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,18,"Participante:",{"$f":"VLOOKUP(B20,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B20,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B20,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B20,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,19,"Participante:",{"$f":"VLOOKUP(B21,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B21,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B21,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B21,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,20,"Participante:",{"$f":"VLOOKUP(B22,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B22,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B22,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B22,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,21,"Participante:",{"$f":"VLOOKUP(B23,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B23,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B23,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B23,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,22,"Participante:",{"$f":"VLOOKUP(B24,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B24,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B24,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B24,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,23,"Participante:",{"$f":"VLOOKUP(B25,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B25,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B25,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B25,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,24,"Participante:",{"$f":"VLOOKUP(B26,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B26,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B26,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B26,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,25,"Participante:",{"$f":"VLOOKUP(B27,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B27,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B27,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B27,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,26,"Participante:",{"$f":"VLOOKUP(B28,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B28,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B28,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B28,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,27,"Participante:",{"$f":"VLOOKUP(B29,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B29,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B29,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B29,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,28,"Participante:",{"$f":"VLOOKUP(B30,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B30,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B30,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B30,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,29,"Participante:",{"$f":"VLOOKUP(B31,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B31,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B31,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B31,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]
[null,30,"Participante:",{"$f":"VLOOKUP(B32,DRT!$C$20:$N$49,2,FALSE)","v":0},"CPF:",{"$f":"VLOOKUP(B32,DRT!$C$20:$N$49,6,FALSE)","v":0},"Data Óbito:",{"$f":"VLOOKUP(B32,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},"Data Aviso:",{"$f":"VLOOKUP(B32,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"}]

{"sheet":"MENU INICIAL DRT","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[1,1,2,1],[13,1,14,4]]}
[]
[null,null,"MENU PRINCIPAL - DRT "]
[null,null,"DECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO - ITCD (Causa Mortis)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ATENÇÃO: Após preenchimento,  enviar arquivo como anexo para: dgfoutrasreceitas@fazenda.mg.gov.br\nAssunto: ITCD - Declaração de Responsável Tributário - CNPJ XX.XXX.XXX/XXXX-XX"]

{"sheet":"DRT","index":4,"n_rows":590,"n_cols":20,"rows_kept":590,"cut":false,"hidden":true,"merged":[[583,15,588,15],[329,2,329,13],[337,15,342,15],[354,15,359,15],[371,15,376,15],[388,15,393,15],[405,15,410,15],[418,2,418,13],[426,15,431,15],[443,15,448,15],[460,15,465,15],[477,15,482,15],[494,15,499,15],[507,2,507,13],[515,15,520,15],[532,15,537,15],[549,15,554,15],[566,15,571,15],[537,6,537,11],[554,6,554,11],[571,6,571,11],[588,6,588,11],[330,2,330,5],[330,8,330,9],[330,10,330,11],[330,12,330,13],[337,2,337,5],[337,8,337,9],[337,10,337,11],[337,12,337,13],[338,2,338,5],[338,8,338,9],[70,15,75,15],[87,15,92,15],[104,15,109,15],[121,15,126,15],[138,15,143,15],[159,15,164,15],[151,2,151,13],[176,15,181,15],[193,15,198,15],[210,15,215,15],[227,15,232,15],[240,2,240,13],[248,15,253,15],[265,15,270,15],[282,15,287,15],[299,15,304,15],[316,15,321,15],[253,6,253,11],[270,6,270,11],[287,6,287,11],[304,6,304,11],[321,6,321,11],[109,6,109,11],[126,6,126,11],[143,6,143,11],[239,8,239,9],[239,10,239,11],[238,2,238,11],[223,2,223,5],[223,8,223,9],[223,10,223,11],[223,12,223,13],[325,2,325,4],[325,5,325,11],[325,12,325,13],[342,6,342,11],[359,6,359,11],[376,6,376,11],[393,6,393,11],[410,6,410,11],[414,2,414,4],[414,5,414,11],[414,12,414,13],[431,6,431,11],[448,6,448,11],[465,6,465,11],[482,6,482,11],[499,6,499,11],[503,2,503,4],[503,5,503,11],[503,12,503,13],[331,2,331,5],[331,8,331,9],[331,10,331,11],[331,12,331,13],[332,2,332,5],[332,8,332,9],[332,10,332,11],[332,12,332,13],[333,2,333,5],[333,8,333,9],[333,10,333,11],[333,12,333,13],[328,12,328,13],[58,2,58,4],[58,12,58,13],[58,5,58,11],[147,2,147,4],[147,5,147,11],[147,12,147,13],[164,6,164,11],[181,6,181,11],[198,6,198,11],[215,6,215,11],[232,6,232,11],[236,2,236,4],[236,5,236,11],[236,12,236,13],[155,2,155,5],[155,8,155,9],[155,10,155,11],[231,8,231,9],[231,10,231,11],[210,2,210,5],[210,8,210,9],[210,10,210,11],[205,2,205,5],[205,8,205,9],[92,6,92,11],[184,10,184,11],[201,8,201,9],[201,10,201,11],[218,8,218,9],[218,10,218,11],[222,10,222,11],[222,12,222,13],[220,2,220,5],[220,8,220,9],[228,2,228,5],[220,12,220,13],[229,2,229,5],[229,8,229,9],[238,12,238,13],[161,8,161,9],[161,10,161,11],[161,12,161,13],[156,2,156,5],[156,8,156,9],[232,2,232,5],[232,12,232,13],[230,2,230,5],[230,8,230,9],[230,10,230,11],[230,12,230,13],[231,2,231,5],[228,8,228,9],[228,10,228,11],[228,12,228,13],[220,10,220,11],[217,2,217,11],[217,12,217,13],[166,2,166,11],[166,12,166,13],[183,2,183,11],[183,12,183,13],[231,12,231,13],[221,2,221,5],[221,8,221,9],[256,8,256,9],[256,10,256,11],[273,8,273,9],[273,10,273,11],[290,8,290,9],[290,10,290,11],[307,8,307,9],[307,10,307,11],[328,8,328,9],[328,10,328,11],[248,8,248,9],[248,10,248,11],[248,12,248,13],[249,2,249,5],[249,8,249,9],[272,2,272,11],[272,12,272,13],[289,2,289,11],[289,12,289,13],[306,2,306,11],[306,12,306,13],[327,2,327,11],[327,12,327,13],[249,10,249,11],[249,12,249,13],[250,2,250,5],[250,8,250,9],[250,10,250,11],[250,12,250,13],[262,2,262,5],[262,8,262,9],[262,10,262,11],[262,12,262,13],[263,2,263,5],[263,8,263,9],[263,10,263,11],[263,12,263,13],[264,2,264,5],[264,8,264,9],[264,10,264,11],[264,12,264,13],[251,2,251,5],[251,8,251,9],[251,10,251,11],[251,12,251,13],[252,2,252,5],[252,8,252,9],[252,10,252,11],[252,12,252,13],[259,2,259,5],[259,8,259,9],[259,10,259,11],[259,12,259,13],[260,2,260,5],[260,8,260,9],[260,10,260,11],[260,12,260,13],[261,2,261,5],[261,8,261,9],[261,10,261,11],[261,12,261,13],[255,2,255,11],[255,12,255,13],[253,2,253,5],[221,10,221,11],[221,12,221,13],[222,2,222,5],[222,8,222,9],[224,8,224,9],[224,10,224,11],[224,12,224,13],[225,2,225,5],[225,8,225,9],[225,10,225,11],[225,12,225,13],[226,2,226,5],[226,8,226,9],[226,10,226,11],[226,12,226,13],[227,2,227,5],[227,8,227,9],[227,10,227,11],[227,12,227,13],[248,2,248,5],[155,12,155,13],[156,10,156,11],[156,12,156,13],[157,2,157,5],[157,8,157,9],[157,10,157,11],[157,12,157,13],[158,2,158,5],[123,2,123,5],[123,8,123,9],[123,10,123,11],[123,12,123,13],[124,2,124,5],[124,8,124,9],[124,10,124,11],[124,12,124,13],[149,2,149,11],[149,12,149,13],[143,2,143,5],[143,12,143,13],[142,2,142,5],[142,8,142,9],[142,10,142,11],[142,12,142,13],[154,2,154,5],[154,8,154,9],[154,10,154,11],[154,12,154,13],[229,10,229,11],[229,12,229,13],[224,2,224,5],[60,12,60,13],[60,2,60,11],[77,2,77,11],[77,12,77,13],[94,2,94,11],[94,12,94,13],[111,2,111,11],[111,12,111,13],[128,2,128,11],[128,12,128,13],[200,2,200,11],[200,12,200,13],[158,8,158,9],[158,10,158,11],[158,12,158,13],[180,2,180,5],[180,8,180,9],[180,10,180,11],[180,12,180,13],[181,12,181,13],[170,2,170,5],[170,8,170,9],[170,10,170,11],[170,12,170,13],[198,2,198,5],[198,12,198,13],[188,2,188,5],[188,8,188,9],[188,10,188,11],[188,12,188,13],[189,2,189,5],[189,8,189,9],[210,12,210,13],[211,2,211,5],[211,8,211,9],[211,10,211,11],[211,12,211,13],[212,2,212,5],[212,8,212,9],[212,10,212,11],[212,12,212,13],[218,12,218,13],[219,2,219,13],[213,2,213,5],[213,8,213,9],[213,10,213,11],[213,12,213,13],[214,2,214,5],[214,8,214,9],[214,10,214,11],[214,12,214,13],[215,2,215,5],[215,12,215,13],[205,10,205,11],[205,12,205,13],[206,2,206,5],[206,8,206,9],[206,10,206,11],[206,12,206,13],[207,2,207,5],[207,8,207,9],[207,10,207,11],[207,12,207,13],[208,2,208,5],[208,8,208,9],[208,10,208,11],[208,12,208,13],[209,2,209,5],[209,8,209,9],[209,10,209,11],[209,12,209,13],[203,2,203,5],[203,8,203,9],[203,10,203,11],[203,12,203,13],[201,12,201,13],[202,2,202,13],[204,2,204,5],[204,8,204,9],[204,10,204,11],[204,12,204,13],[193,2,193,5],[193,8,193,9],[193,10,193,11],[193,12,193,13],[194,2,194,5],[194,8,194,9],[194,10,194,11],[194,12,194,13],[195,2,195,5],[195,8,195,9],[195,10,195,11],[195,12,195,13],[196,2,196,5],[196,8,196,9],[196,10,196,11],[196,12,196,13],[197,2,197,5],[197,8,197,9],[197,10,197,11],[197,12,197,13],[189,10,189,11],[189,12,189,13],[190,2,190,5],[190,8,190,9],[190,10,190,11],[190,12,190,13],[191,2,191,5],[191,8,191,9],[191,10,191,11],[191,12,191,13],[192,2,192,5],[192,8,192,9],[192,10,192,11],[192,12,192,13],[186,2,186,5],[186,8,186,9],[186,10,186,11],[186,12,186,13],[184,12,184,13],[185,2,185,13],[187,2,187,5],[187,8,187,9],[187,10,187,11],[187,12,187,13],[181,2,181,5],[175,2,175,5],[175,8,175,9],[175,10,175,11],[175,12,175,13],[176,2,176,5],[176,8,176,9],[176,10,176,11],[176,12,176,13],[177,2,177,5],[177,8,177,9],[177,10,177,11],[177,12,177,13],[178,2,178,5],[178,8,178,9],[178,10,178,11],[178,12,178,13],[179,2,179,5],[179,8,179,9],[179,10,179,11],[179,12,179,13],[184,8,184,9],[171,2,171,5],[171,8,171,9],[171,10,171,11],[171,12,171,13],[172,2,172,5],[172,8,172,9],[172,10,172,11],[172,12,172,13],[173,2,173,5],[173,8,173,9],[173,10,173,11],[173,12,173,13],[174,2,174,5],[174,8,174,9],[174,10,174,11],[174,12,174,13],[169,2,169,5],[169,8,169,9],[169,10,169,11],[169,12,169,13],[162,2,162,5],[162,8,162,9],[162,10,162,11],[162,12,162,13],[163,2,163,5],[163,8,163,9],[163,10,163,11],[163,12,163,13],[167,12,167,13],[164,2,164,5],[164,12,164,13],[161,2,161,5],[152,2,152,5],[152,8,152,9],[152,10,152,11],[152,12,152,13],[159,2,159,5],[159,8,159,9],[159,10,159,11],[159,12,159,13],[160,2,160,5],[160,8,160,9],[160,10,160,11],[160,12,160,13],[167,8,167,9],[167,10,167,11],[153,2,153,5],[153,8,153,9],[153,10,153,11],[153,12,153,13],[150,12,150,13],[150,8,150,9],[150,10,150,11],[129,12,129,13],[130,2,130,13],[139,2,139,5],[139,8,139,9],[139,10,139,11],[139,12,139,13],[133,2,133,5],[133,8,133,9],[133,10,133,11],[133,12,133,13],[134,2,134,5],[134,8,134,9],[134,10,134,11],[134,12,134,13],[135,2,135,5],[135,8,135,9],[135,10,135,11],[135,12,135,13],[131,2,131,5],[131,8,131,9],[131,10,131,11],[131,12,131,13],[132,2,132,5],[132,8,132,9],[132,10,132,11],[132,12,132,13],[129,8,129,9],[129,10,129,11],[140,2,140,5],[140,8,140,9],[140,10,140,11],[140,12,140,13],[141,2,141,5],[141,8,141,9],[141,10,141,11],[141,12,141,13],[136,2,136,5],[136,8,136,9],[136,10,136,11],[136,12,136,13],[137,2,137,5],[137,8,137,9],[137,10,137,11],[137,12,137,13],[138,2,138,5],[138,8,138,9],[138,10,138,11],[138,12,138,13],[125,2,125,5],[125,8,125,9],[125,10,125,11],[125,12,125,13],[126,2,126,5],[126,12,126,13],[118,2,118,5],[118,8,118,9],[118,10,118,11],[118,12,118,13],[119,2,119,5],[119,8,119,9],[119,10,119,11],[119,12,119,13],[120,2,120,5],[120,8,120,9],[120,10,120,11],[120,12,120,13],[121,2,121,5],[121,8,121,9],[121,10,121,11],[121,12,121,13],[122,2,122,5],[122,8,122,9],[122,10,122,11],[122,12,122,13],[112,12,112,13],[113,2,113,13],[114,2,114,5],[114,8,114,9],[114,10,114,11],[114,12,114,13],[115,2,115,5],[115,8,115,9],[115,10,115,11],[115,12,115,13],[116,2,116,5],[116,8,116,9],[116,10,116,11],[116,12,116,13],[117,2,117,5],[117,8,117,9],[117,10,117,11],[117,12,117,13],[112,8,112,9],[112,10,112,11],[106,2,106,5],[106,8,106,9],[106,10,106,11],[106,12,106,13],[107,2,107,5],[107,8,107,9],[107,10,107,11],[107,12,107,13],[108,2,108,5],[108,8,108,9],[108,10,108,11],[108,12,108,13],[109,2,109,5],[109,12,109,13],[101,2,101,5],[101,8,101,9],[101,10,101,11],[101,12,101,13],[102,2,102,5],[102,8,102,9],[102,10,102,11],[102,12,102,13],[103,2,103,5],[103,8,103,9],[103,10,103,11],[103,12,103,13],[104,2,104,5],[104,8,104,9],[104,10,104,11],[104,12,104,13],[105,2,105,5],[105,8,105,9],[105,10,105,11],[105,12,105,13],[95,12,95,13],[96,2,96,13],[97,2,97,5],[97,8,97,9],[97,10,97,11],[97,12,97,13],[98,2,98,5],[98,8,98,9],[98,10,98,11],[98,12,98,13],[99,2,99,5],[99,8,99,9],[99,10,99,11],[99,12,99,13],[100,2,100,5],[100,8,100,9],[100,10,100,11],[100,12,100,13],[95,8,95,9],[95,10,95,11],[89,2,89,5],[89,8,89,9],[89,10,89,11],[89,12,89,13],[90,2,90,5],[90,8,90,9],[90,10,90,11],[90,12,90,13],[91,2,91,5],[91,8,91,9],[91,10,91,11],[91,12,91,13],[92,2,92,5],[92,12,92,13],[84,2,84,5],[84,8,84,9],[84,10,84,11],[84,12,84,13],[85,2,85,5],[85,8,85,9],[85,10,85,11],[85,12,85,13],[86,2,86,5],[86,8,86,9],[86,10,86,11],[86,12,86,13],[87,2,87,5],[87,8,87,9],[87,10,87,11],[87,12,87,13],[88,2,88,5],[88,8,88,9],[88,10,88,11],[88,12,88,13],[80,2,80,5],[80,8,80,9],[80,10,80,11],[80,12,80,13],[81,2,81,5],[81,8,81,9],[81,10,81,11],[81,12,81,13],[82,2,82,5],[82,8,82,9],[82,10,82,11],[82,12,82,13],[83,2,83,5],[83,8,83,9],[83,10,83,11],[83,12,83,13],[66,8,66,9],[67,8,67,9],[61,12,61,13],[63,2,63,5],[65,2,65,5],[66,2,66,5],[67,2,67,5],[63,10,63,11],[64,10,64,11],[64,12,64,13],[65,10,65,11],[78,12,78,13],[69,12,69,13],[70,10,70,11],[70,12,70,13],[72,10,72,11],[72,12,72,13],[74,12,74,13],[75,12,75,13],[68,8,68,9],[69,8,69,9],[68,10,68,11],[68,12,68,13],[69,10,69,11],[78,8,78,9],[78,10,78,11],[75,6,75,11],[46,8,46,9],[46,10,46,11],[46,12,46,13],[71,8,71,9],[71,10,71,11],[54,6,54,12],[70,2,70,5],[72,2,72,5],[73,2,73,5],[74,2,74,5],[75,2,75,5],[70,8,70,9],[72,8,72,9],[73,8,73,9],[48,12,48,13],[54,3,54,4],[65,12,65,13],[66,10,66,11],[66,12,66,13],[67,10,67,11],[67,12,67,13],[63,12,63,13],[68,2,68,5],[69,2,69,5],[64,2,64,5],[73,10,73,11],[73,12,73,13],[74,8,74,9],[74,10,74,11],[63,8,63,9],[64,8,64,9],[65,8,65,9],[47,12,47,13],[20,10,20,11],[21,10,21,11],[22,10,22,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[41,10,41,11],[42,10,42,11],[40,10,40,11],[40,12,40,13],[47,10,47,11],[35,10,35,11],[35,12,35,13],[36,10,36,11],[36,12,36,13],[37,10,37,11],[37,12,37,13],[32,10,32,11],[32,12,32,13],[33,10,33,11],[33,12,33,13],[34,10,34,11],[34,12,34,13],[2,2,6,4],[53,3,53,4],[51,2,51,13],[11,2,11,3],[9,4,9,13],[10,4,10,13],[11,4,11,13],[14,4,14,6],[14,7,14,13],[2,12,6,13],[13,12,13,13],[13,4,13,5],[13,7,13,8],[12,12,12,13],[9,2,9,3],[8,3,8,13],[12,2,12,3],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[41,8,41,9],[48,10,48,11],[20,12,20,13],[21,12,21,13],[38,8,38,9],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[2,5,2,11],[3,5,3,11],[4,5,4,11],[5,5,5,11],[6,5,6,11],[29,12,29,13],[30,12,30,13],[31,12,31,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[35,8,35,9],[36,8,36,9],[37,8,37,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[15,8,15,9],[12,6,12,7],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[16,8,16,9],[15,10,15,13],[16,10,16,13],[14,2,14,3],[13,2,13,3],[71,2,71,5],[71,12,71,13],[45,8,45,9],[47,8,47,9],[48,8,48,9],[23,10,23,11],[26,8,26,9],[38,10,38,11],[38,12,38,13],[39,8,39,9],[39,10,39,11],[39,12,39,13],[40,8,40,9],[18,12,18,13],[43,10,43,11],[44,10,44,11],[45,10,45,11],[19,10,19,11],[18,10,18,11],[19,12,19,13],[23,12,23,13],[18,3,18,6],[50,2,50,13],[42,8,42,9],[43,8,43,9],[44,8,44,9],[22,12,22,13],[61,8,61,9],[61,10,61,11],[15,2,16,6],[245,2,245,5],[245,8,245,9],[245,10,245,11],[245,12,245,13],[246,2,246,5],[246,8,246,9],[246,10,246,11],[246,12,246,13],[247,2,247,5],[247,8,247,9],[247,10,247,11],[247,12,247,13],[242,2,242,5],[242,8,242,9],[242,10,242,11],[242,12,242,13],[243,2,243,5],[243,8,243,9],[243,10,243,11],[243,12,243,13],[244,2,244,5],[244,8,244,9],[244,10,244,11],[244,12,244,13],[268,2,268,5],[268,8,268,9],[268,10,268,11],[268,12,268,13],[269,2,269,5],[269,8,269,9],[269,10,269,11],[269,12,269,13],[270,2,270,5],[270,12,270,13],[265,2,265,5],[265,8,265,9],[265,10,265,11],[265,12,265,13],[266,2,266,5],[266,8,266,9],[266,10,266,11],[266,12,266,13],[267,2,267,5],[267,8,267,9],[267,10,267,11],[267,12,267,13],[279,2,279,5],[279,8,279,9],[279,10,279,11],[279,12,279,13],[280,2,280,5],[280,8,280,9],[280,10,280,11],[280,12,280,13],[281,2,281,5],[281,8,281,9],[281,10,281,11],[281,12,281,13],[276,2,276,5],[276,8,276,9],[276,10,276,11],[276,12,276,13],[277,2,277,5],[277,8,277,9],[277,10,277,11],[277,12,277,13],[278,2,278,5],[278,8,278,9],[278,10,278,11],[278,12,278,13],[285,2,285,5],[285,8,285,9],[285,10,285,11],[285,12,285,13],[286,2,286,5],[286,8,286,9],[286,10,286,11],[286,12,286,13],[282,2,282,5],[282,8,282,9],[282,10,282,11],[282,12,282,13],[283,2,283,5],[283,8,283,9],[283,10,283,11],[283,12,283,13],[284,2,284,5],[284,8,284,9],[284,10,284,11],[284,12,284,13],[301,8,301,9],[301,10,301,11],[301,12,301,13],[296,2,296,5],[296,8,296,9],[296,10,296,11],[296,12,296,13],[297,2,297,5],[297,8,297,9],[297,10,297,11],[297,12,297,13],[298,2,298,5],[298,8,298,9],[298,10,298,11],[298,12,298,13],[293,2,293,5],[293,8,293,9],[293,10,293,11],[293,12,293,13],[294,2,294,5],[294,8,294,9],[294,10,294,11],[294,12,294,13],[295,2,295,5],[295,8,295,9],[295,10,295,11],[295,12,295,13],[258,12,258,13],[304,2,304,5],[313,2,313,5],[313,8,313,9],[313,10,313,11],[313,12,313,13],[314,2,314,5],[314,8,314,9],[314,10,314,11],[314,12,314,13],[315,2,315,5],[315,8,315,9],[315,10,315,11],[315,12,315,13],[310,2,310,5],[310,8,310,9],[310,10,310,11],[310,12,310,13],[311,2,311,5],[311,8,311,9],[311,10,311,11],[311,12,311,13],[312,2,312,5],[312,8,312,9],[312,10,312,11],[312,12,312,13]],"merged_total":1878,"flags":["merged_cut"]}
[]
[]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\" ",null,null,null,null,null,null,null,null,null,null,null,null,"Vigência Lei 14.941/2003","2004-03-30"]
[null,null,null,null,null,"DECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO",null,null,null,null,null,null,null,null,null,null,null,null,"Limite Fim Data óbito e aviso",{"$f":"TODAY()","v":"2019-09-30"}]
[null,null,null,null,null,"INSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR   "]
[null,null,null,null,null,"IMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO -  ITCD  "]
[null,null,null,null,null,"(LEI Nº 14.941/2003 REGULAMENTADA PELO DECRETO Nº 43.981/2005)"]
[]
[null,null,1,"  DADOS DA INSTITUIÇÃO FINANCEIRA"]
[null,null,"NOME "]
[null,null,"RAZÃO SOCIAL"]
[null,null,"CNPJ"]
[null,null,"ENDEREÇO       (Rua, Av. Praça etc.)",null,"Tipo",null,null,null,"Nº",null,"COMPLEMENTO"]
[null,null,"BAIRRO",null,null,null,"Município",null,null,"UF",null,"CEP"]
[null,null,"FONE/FAX"]
[null,null,"Mês/ano do aviso ou comunicação de ocorrência de fato gerador do ITCD",null,null,null,null,"Mês-Ano","TIPO",null,"Vencimento Responsável"]
[null,null,null,null,null,null,null,null,{"$f":"IF(TODAY()>K17,\"Complementar    /Em atraso\",\"Normal\")","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(H17,'LISTA SUSPENSA'!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Nome do Participante",null,null,null,"CPF","Data do Óbito",null,"Data do Aviso",null,"Data do resgate",null,null,null,"Validar CPF"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D20=0,H20=0,I20=0,K20=0),\"Incompleto ou Vazio\",IF(Q20,\"Completo\",\"Incompleto ou Vazio\"))","v":"Incompleto ou Vazio"},{"$f":"lfValidaCPF(H20)","v":true},{"$f":"SUMIF($H$20:$H$49,H20,$S$20:$S$49)","v":0},1]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D21=0,H21=0,I21=0,K21=0),\"Incompleto ou Vazio\",IF(Q21,\"Completo\",\"Incompleto ou Vazio\"))","v":"Incompleto ou Vazio"},{"$f":"lfValidaCPF(H21)","v":true},0,1]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio",true,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null," RESPONSÁVEL PELA DECLARAÇÃO"]
[null,null,"  Declaro serem verdadeiras as informações aqui prestadas, sob pena das sanções legais. "]
[]
[]
[null,null,null,"Data",null,null,"ASSINATURA DO RESPONSÁVEL PELA DECLARAÇÃO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20=0,D21=0,D22=0,D23=0,D24=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20=0,D21=0,D22=0,D23=0,D24=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\"\nDECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO\nINSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR\nIMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO - ITCD\n(LEI Nº 14.941/2003 REGULAMENTADA PELO DECRETO Nº 43.981/2005)",null,null,null,null,null,null,"Anexo I",null,null,null,null,{"$f":"IF(AND(D20=0,D21=0,D22=0,D23=0,D24=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20=0,D21=0,D22=0,D23=0,D24=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$20,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C20","v":1},{"$f":"VLOOKUP(C62,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C62,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$20,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G65:L65)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G66:L66)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G67:L67)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G68:L68)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G65-G66-G67-G68-G69","v":0},{"$f":"H65-H66-H67-H68-H69","v":0},{"$f":"I65-I66-I67-I68-I69","v":0},null,{"$f":"K65-K66-K67-K68-K69","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M62,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M72=\"N/A\",\"\",IF(R20>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M70/M71,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M62,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M75,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M62,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M73*M72),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M62,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M62,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M62,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M62,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M74*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$21,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C21","v":2},{"$f":"VLOOKUP(C79,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C79,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$21,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G82:L82)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G83:L83)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G84:L84)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G85:L85)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G82-G83-G84-G85-G86","v":0},{"$f":"H82-H83-H84-H85-H86","v":0},{"$f":"I82-I83-I84-I85-I86","v":0},null,{"$f":"K82-K83-K84-K85-K86","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M79,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M89=\"N/A\",\"\",IF(R21>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M87/M88,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M79,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M92,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M79,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M90*M89),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M79,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M79,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M79,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M79,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M91*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$22,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C22","v":3},{"$f":"VLOOKUP(C96,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C96,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$22,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G99:L99)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G100:L100)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G101:L101)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G102:L102)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G99-G100-G101-G102-G103","v":0},{"$f":"H99-H100-H101-H102-H103","v":0},{"$f":"I99-I100-I101-I102-I103","v":0},null,{"$f":"K99-K100-K101-K102-K103","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M96,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M106=\"N/A\",\"\",IF(R22>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M104/M105,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M96,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M109,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M96,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M107*M106),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M96,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M96,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M96,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M96,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M108*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$23,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C23","v":4},{"$f":"VLOOKUP(C113,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C113,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$23,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G116:L116)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G117:L117)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G118:L118)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G119:L119)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G116-G117-G118-G119-G120","v":0},{"$f":"H116-H117-H118-H119-H120","v":0},{"$f":"I116-I117-I118-I119-I120","v":0},null,{"$f":"K116-K117-K118-K119-K120","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M113,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M123=\"N/A\",\"\",IF(R23>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M121/M122,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M113,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M126,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M113,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M124*M123),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M113,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M113,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M113,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M113,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M125*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$24,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C24","v":5},{"$f":"VLOOKUP(C130,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C130,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$24,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G133:L133)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G134:L134)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G135:L135)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G136:L136)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G133-G134-G135-G136-G137","v":0},{"$f":"H133-H134-H135-H136-H137","v":0},{"$f":"I133-I134-I135-I136-I137","v":0},null,{"$f":"K133-K134-K135-K136-K137","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M130,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M140=\"N/A\",\"\",IF(R24>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M138/M139,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M130,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M143,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M130,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M141*M140),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M130,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M130,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M130,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M130,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M142*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D25=0,D26=0,D27=0,D28=0,D29=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D25=0,D26=0,D27=0,D28=0,D29=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\"\nDECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO\nINSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR\nIMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO ITCD\n(INSTITUÍDA PELA LEI Nº 14.941/2003 E REGULAMENTADA PELO DECRETO Nº 43.981/2005)",null,null,null,null,null,null,"Anexo II",null,null,null,null,{"$f":"IF(AND(D25=0,D26=0,D27=0,D28=0,D29=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D25=0,D26=0,D27=0,D28=0,D29=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$25,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C25","v":6},{"$f":"VLOOKUP(C151,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C151,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$25,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G154:L154)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G155:L155)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G156:L156)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G157:L157)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G154-G155-G156-G157-G158","v":0},{"$f":"H154-H155-H156-H157-H158","v":0},{"$f":"I154-I155-I156-I157-I158","v":0},null,{"$f":"K154-K155-K156-K157-K158","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M151,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M161=\"N/A\",\"\",IF(R25>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M159/M160,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M151,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M164,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M151,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M162*M161),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M151,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M151,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M151,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M151,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M163*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$26,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C26","v":7},{"$f":"VLOOKUP(C168,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C168,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$26,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G171:L171)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G172:L172)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G173:L173)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G174:L174)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G171-G172-G173-G174-G175","v":0},{"$f":"H171-H172-H173-H174-H175","v":0},{"$f":"I171-I172-I173-I174-I175","v":0},null,{"$f":"K171-K172-K173-K174-K175","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M168,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M178=\"N/A\",\"\",IF(R26>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M176/M177,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M168,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M181,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M168,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M179*M178),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M168,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M168,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M168,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M168,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M180*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$27,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C27","v":8},{"$f":"VLOOKUP(C185,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C185,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$27,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G188:L188)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G189:L189)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G190:L190)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G191:L191)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G188-G189-G190-G191-G192","v":0},{"$f":"H188-H189-H190-H191-H192","v":0},{"$f":"I188-I189-I190-I191-I192","v":0},null,{"$f":"K188-K189-K190-K191-K192","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M185,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M195=\"N/A\",\"\",IF(R27>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M193/M194,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M185,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M198,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M185,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M196*M195),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M185,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M185,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M185,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M185,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M197*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$28,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C28","v":9},{"$f":"VLOOKUP(C202,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C202,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$28,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G205:L205)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G206:L206)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G207:L207)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G208:L208)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G205-G206-G207-G208-G209","v":0},{"$f":"H205-H206-H207-H208-H209","v":0},{"$f":"I205-I206-I207-I208-I209","v":0},null,{"$f":"K205-K206-K207-K208-K209","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M202,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M212=\"N/A\",\"\",IF(R28>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M210/M211,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M202,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M215,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M202,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M213*M212),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M202,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M202,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M202,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M202,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M214*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$29,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C29","v":10},{"$f":"VLOOKUP(C219,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C219,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$29,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G222:L222)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G223:L223)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G224:L224)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G225:L225)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G222-G223-G224-G225-G226","v":0},{"$f":"H222-H223-H224-H225-H226","v":0},{"$f":"I222-I223-I224-I225-I226","v":0},null,{"$f":"K222-K223-K224-K225-K226","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M219,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M229=\"N/A\",\"\",IF(R29>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M227/M228,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M219,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M232,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M219,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M230*M229),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M219,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M219,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M219,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M219,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M231*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$30=0,$D$31=0,$D$32=0,$D$33=0,$D$34=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$30=0,$D$31=0,$D$32=0,$D$33=0,$D$34=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\"\nDECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO\nINSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR\nIMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO ITCD\n(INSTITUÍDA PELA LEI Nº 14.941/2003 E REGULAMENTADA PELO DECRETO Nº 43.981/2005)",null,null,null,null,null,null,"Anexo III",null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$30,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C30","v":11},{"$f":"VLOOKUP(C240,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C240,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$30,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G243:L243)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G244:L244)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G245:L245)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G246:L246)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G243-G244-G245-G246-G247","v":0},{"$f":"H243-H244-H245-H246-H247","v":0},{"$f":"I243-I244-I245-I246-I247","v":0},null,{"$f":"K243-K244-K245-K246-K247","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M240,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M250=\"N/A\",\"\",IF(R30>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M248/M249,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M240,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M253,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M240,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M251*M250),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M240,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M240,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M240,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M240,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M252*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$31,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C31","v":12},{"$f":"VLOOKUP(C257,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C257,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$31,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G260:L260)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G261:L261)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G262:L262)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G263:L263)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G260-G261-G262-G263-G264","v":0},{"$f":"H260-H261-H262-H263-H264","v":0},{"$f":"I260-I261-I262-I263-I264","v":0},null,{"$f":"K260-K261-K262-K263-K264","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M257,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M267=\"N/A\",\"\",IF(R31>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M265/M266,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M257,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M270,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M257,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M268*M267),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M257,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M257,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M257,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M257,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M269*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$32,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C32","v":13},{"$f":"VLOOKUP(C274,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C274,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$32,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G277:L277)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G278:L278)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G279:L279)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G280:L280)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G277-G278-G279-G280-G281","v":0},{"$f":"H277-H278-H279-H280-H281","v":0},{"$f":"I277-I278-I279-I280-I281","v":0},null,{"$f":"K277-K278-K279-K280-K281","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M274,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M284=\"N/A\",\"\",IF(R32>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M282/M283,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M274,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M287,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M274,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M285*M284),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M274,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M274,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M274,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M274,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M286*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$33,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C33","v":14},{"$f":"VLOOKUP(C291,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C291,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$33,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G294:L294)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G295:L295)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G296:L296)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G297:L297)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G294-G295-G296-G297-G298","v":0},{"$f":"H294-H295-H296-H297-H298","v":0},{"$f":"I294-I295-I296-I297-I298","v":0},null,{"$f":"K294-K295-K296-K297-K298","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M291,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M301=\"N/A\",\"\",IF(R33>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M299/M300,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M291,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M304,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M291,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M302*M301),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M291,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M291,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M291,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M291,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M303*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$34,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C34","v":15},{"$f":"VLOOKUP(C308,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C308,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$34,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G311:L311)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G312:L312)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G313:L313)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G314:L314)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G311-G312-G313-G314-G315","v":0},{"$f":"H311-H312-H313-H314-H315","v":0},{"$f":"I311-I312-I313-I314-I315","v":0},null,{"$f":"K311-K312-K313-K314-K315","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M308,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M318=\"N/A\",\"\",IF(R34>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M316/M317,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M308,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M321,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M308,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M319*M318),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M308,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M308,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M308,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M308,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M320*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$35=0,$D$36=0,$D$37=0,$D$38=0,$D$39=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$35=0,$D$36=0,$D$37=0,$D$38=0,$D$39=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\"\nDECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO\nINSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR\nIMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO ITCD\n(INSTITUÍDA PELA LEI Nº 14.941/2003 E REGULAMENTADA PELO DECRETO Nº 43.981/2005)",null,null,null,null,null,null,"Anexo IV",null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$35,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C35","v":16},{"$f":"VLOOKUP(C329,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C329,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$35,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G332:L332)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G333:L333)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G334:L334)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G335:L335)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G332-G333-G334-G335-G336","v":0},{"$f":"H332-H333-H334-H335-H336","v":0},{"$f":"I332-I333-I334-I335-I336","v":0},null,{"$f":"K332-K333-K334-K335-K336","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M329,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M339=\"N/A\",\"\",IF(R35>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M337/M338,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M329,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M342,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M329,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M340*M339),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M329,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M329,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M329,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M329,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M341*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$36,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C36","v":17},{"$f":"VLOOKUP(C346,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C346,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$36,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G349:L349)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G350:L350)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G351:L351)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G352:L352)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G349-G350-G351-G352-G353","v":0},{"$f":"H349-H350-H351-H352-H353","v":0},{"$f":"I349-I350-I351-I352-I353","v":0},null,{"$f":"K349-K350-K351-K352-K353","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M346,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M356=\"N/A\",\"\",IF(R36>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M354/M355,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M346,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M359,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M346,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M357*M356),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M346,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M346,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M346,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M346,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M358*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$37,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C37","v":18},{"$f":"VLOOKUP(C363,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C363,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$37,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G366:L366)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G367:L367)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G368:L368)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G369:L369)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G366-G367-G368-G369-G370","v":0},{"$f":"H366-H367-H368-H369-H370","v":0},{"$f":"I366-I367-I368-I369-I370","v":0},null,{"$f":"K366-K367-K368-K369-K370","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M363,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M373=\"N/A\",\"\",IF(R37>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M371/M372,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M363,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M376,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M363,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M374*M373),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M363,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M363,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M363,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M363,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M375*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$38,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C38","v":19},{"$f":"VLOOKUP(C380,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C380,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$38,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G383:L383)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G384:L384)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G385:L385)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G386:L386)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G383-G384-G385-G386-G387","v":0},{"$f":"H383-H384-H385-H386-H387","v":0},{"$f":"I383-I384-I385-I386-I387","v":0},null,{"$f":"K383-K384-K385-K386-K387","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M380,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M390=\"N/A\",\"\",IF(R38>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M388/M389,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M380,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M393,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M380,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M391*M390),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M380,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M380,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M380,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M380,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M392*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$39,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C39","v":20},{"$f":"VLOOKUP(C397,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C397,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$39,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G400:L400)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G401:L401)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G402:L402)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G403:L403)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G400-G401-G402-G403-G404","v":0},{"$f":"H400-H401-H402-H403-H404","v":0},{"$f":"I400-I401-I402-I403-I404","v":0},null,{"$f":"K400-K401-K402-K403-K404","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M397,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M407=\"N/A\",\"\",IF(R39>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M405/M406,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M397,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M410,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M397,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M408*M407),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M397,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M397,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M397,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M397,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M409*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$40=0,$D$41=0,$D$42=0,$D$43=0,$D$44=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$40=0,$D$41=0,$D$42=0,$D$43=0,$D$44=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\"\nDECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO\nINSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR\nIMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO ITCD\n(INSTITUÍDA PELA LEI Nº 14.941/2003 E REGULAMENTADA PELO DECRETO Nº 43.981/2005)",null,null,null,null,null,null,"Anexo V",null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$40,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C40","v":21},{"$f":"VLOOKUP(C418,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C418,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$40,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G421:L421)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G422:L422)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G423:L423)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G424:L424)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G421-G422-G423-G424-G425","v":0},{"$f":"H421-H422-H423-H424-H425","v":0},{"$f":"I421-I422-I423-I424-I425","v":0},null,{"$f":"K421-K422-K423-K424-K425","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M418,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M428=\"N/A\",\"\",IF(R40>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M426/M427,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M418,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M431,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M418,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M429*M428),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M418,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M418,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M418,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M418,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M430*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$41,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C41","v":22},{"$f":"VLOOKUP(C435,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C435,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$41,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G438:L438)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G439:L439)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G440:L440)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G441:L441)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G438-G439-G440-G441-G442","v":0},{"$f":"H438-H439-H440-H441-H442","v":0},{"$f":"I438-I439-I440-I441-I442","v":0},null,{"$f":"K438-K439-K440-K441-K442","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M435,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M445=\"N/A\",\"\",IF(R41>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M443/M444,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M435,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M448,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M435,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M446*M445),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M435,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M435,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M435,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M435,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M447*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$42,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C42","v":23},{"$f":"VLOOKUP(C452,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C452,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$42,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G455:L455)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G456:L456)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G457:L457)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G458:L458)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G455-G456-G457-G458-G459","v":0},{"$f":"H455-H456-H457-H458-H459","v":0},{"$f":"I455-I456-I457-I458-I459","v":0},null,{"$f":"K455-K456-K457-K458-K459","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M452,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M462=\"N/A\",\"\",IF(R42>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M460/M461,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M452,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M465,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M452,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M463*M462),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M452,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M452,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M452,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M452,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M464*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$43,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C43","v":24},{"$f":"VLOOKUP(C469,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C469,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$43,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G472:L472)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G473:L473)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G474:L474)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G475:L475)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G472-G473-G474-G475-G476","v":0},{"$f":"H472-H473-H474-H475-H476","v":0},{"$f":"I472-I473-I474-I475-I476","v":0},null,{"$f":"K472-K473-K474-K475-K476","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M469,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M479=\"N/A\",\"\",IF(R43>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M477/M478,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M469,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M482,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M469,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M480*M479),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M469,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M469,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M469,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M469,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M481*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$44,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C44","v":25},{"$f":"VLOOKUP(C486,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C486,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$44,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G489:L489)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G490:L490)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G491:L491)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G492:L492)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G489-G490-G491-G492-G493","v":0},{"$f":"H489-H490-H491-H492-H493","v":0},{"$f":"I489-I490-I491-I492-I493","v":0},null,{"$f":"K489-K490-K491-K492-K493","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M486,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M496=\"N/A\",\"\",IF(R44>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M494/M495,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M486,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M499,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M486,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M497*M496),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M486,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M486,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M486,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M486,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M498*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$45=0,$D$46=0,$D$47=0,$D$48=0,$D$49=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D465=0,D466=0,D467=0,D468=0,D469=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,"ITCD - \"CAUSA MORTIS\"\nDECLARAÇÃO DE RESPONSÁVEL TRIBUTÁRIO\nINSTITUIÇÕES DE PREVIDÊNCIA COMPLEMENTAR\nIMPOSTO SOBRE TRANSMISSÃO \"CAUSA MORTIS\" E DOAÇÃO ITCD\n(INSTITUÍDA PELA LEI Nº 14.941/2003 E REGULAMENTADA PELO DECRETO Nº 43.981/2005)",null,null,null,null,null,null,"Anexo VI",null,null,null,null,{"$f":"IF(AND(D465=0,D466=0,D467=0,D468=0,D469=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D465=0,D466=0,D467=0,D468=0,D469=0),\"Incompleto ou Vazio\",\"Completo \")","v":"Incompleto ou Vazio"}]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$45,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C45","v":26},{"$f":"VLOOKUP(C507,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C507,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$45,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G510:L510)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G511:L511)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G512:L512)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G513:L513)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G510-G511-G512-G513-G514","v":0},{"$f":"H510-H511-H512-H513-H514","v":0},{"$f":"I510-I511-I512-I513-I514","v":0},null,{"$f":"K510-K511-K512-K513-K514","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M507,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M517=\"N/A\",\"\",IF(R45>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M515/M516,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M507,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M520,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M507,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M518*M517),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M507,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M507,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M507,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M507,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M519*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$46,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C46","v":27},{"$f":"VLOOKUP(C524,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C524,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$46,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G527:L527)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G528:L528)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G529:L529)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G530:L530)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G527-G528-G529-G530-G531","v":0},{"$f":"H527-H528-H529-H530-H531","v":0},{"$f":"I527-I528-I529-I530-I531","v":0},null,{"$f":"K527-K528-K529-K530-K531","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M524,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M534=\"N/A\",\"\",IF(R46>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M532/M533,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M524,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M537,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M524,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M535*M534),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M524,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M524,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M524,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M524,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M536*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$47,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C47","v":28},{"$f":"VLOOKUP(C541,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C541,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$47,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G544:L544)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G545:L545)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G546:L546)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G547:L547)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G544-G545-G546-G547-G548","v":0},{"$f":"H544-H545-H546-H547-H548","v":0},{"$f":"I544-I545-I546-I547-I548","v":0},null,{"$f":"K544-K545-K546-K547-K548","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M541,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M551=\"N/A\",\"\",IF(R47>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M549/M550,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M541,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M554,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M541,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M552*M551),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M541,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M541,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M541,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M541,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M553*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$48,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C48","v":29},{"$f":"VLOOKUP(C558,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C558,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$48,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G561:L561)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G562:L562)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G563:L563)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G564:L564)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G561-G562-G563-G564-G565","v":0},{"$f":"H561-H562-H563-H564-H565","v":0},{"$f":"I561-I562-I563-I564-I565","v":0},null,{"$f":"K561-K562-K563-K564-K565","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M558,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M568=\"N/A\",\"\",IF(R48>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M566/M567,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M558,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M571,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M558,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M569*M568),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M558,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M558,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M558,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M558,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M570*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"  CÁLCULO DO ITCD-RESPONSÁVEL TRIBUTÁRIO-PREV",null,null,null,null,null,null,null,null,null,"CPF:",null,null,null,null,{"$f":"VLOOKUP($P$49,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,{"$f":"C49","v":30},{"$f":"VLOOKUP(C575,$C$20:$N$49,2,FALSE)","v":0},null,null,"Contrato 1","Contrato 2","Contrato 3",null,"Contrato 4",null,{"$f":"VLOOKUP(C575,$C$20:$H$49,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP($P$49,$P$20:$P$49,1,FALSE)","v":"Incompleto ou Vazio"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Número Contrato Plano Previdência",null,null,null,null,null,null,null,null,null,"TOTAIS",null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da Previdência",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G578:L578)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Deduções",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G579:L579)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Carregamento",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G580:L580)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Assistência financeira",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G581:L581)","v":0},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( - ) Imposto de renda",null,null,null,null,null,null,null,null,null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) Saldo da Previdência",null,null,null,{"$f":"G578-G579-G580-G581-G582","v":0},{"$f":"H578-H579-H580-H581-H582","v":0},{"$f":"I578-I579-I580-I581-I582","v":0},null,{"$f":"K578-K579-K580-K581-K582","v":0},null,0,null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor da UFEMG - Data do Óbito",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(M575,$H$19:$N$49,2,FALSE),'VALOR UFFEMG'!B:E,4,TRUE),\"N/A\")","v":"N/A"},null,null,{"$f":"IF(M585=\"N/A\",\"\",IF(R49>1,\"ANTES DE GERAR O DAE, SOMAR TODOS OS ITCD DESTE CPF QUE ESTÁ DECLARADO EM MAIS DE UM ITEM. GERAR O DAE COM O VALOR DESTA SOMA.\",\"\"))","v":""},null,"Incompleto ou Vazio"]
[null,null,"Saldo da Previdência em UFEMG - Data do Óbito ",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M583/M584,\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Valor UFEMG Data do Vencimento",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M575,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M588,'VALOR UFFEMG'!B:E,4,TRUE)),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = )BC (Saldo em UFEMG * UFEMG vencimento)",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M575,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",M586*M585),\"N/A\")","v":"N/A"},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"Vencimento (180 Dias após o óbito)",null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(M575,$H$20:$L$49,2,FALSE) < T$3,\"N/A\",VLOOKUP(M575,$H$20:$L$49,2,FALSE)+180)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,"( = ) ITCD DEVIDO (5% da BC) no Vencimento",null,null,null,{"$f":"IF(VLOOKUP(M575,$H$20:$L$49,2,FALSE) < T$3,\"    Óbito anterior a 30/03/2004, o cálculo será realizado pela Repartição Fazendário,\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(VLOOKUP(M575,$H$20:$L$49,2,FALSE) < T$3,\"após o envio desta DRT.\",M587*0.05)","v":{"$error":"#N/A"}},null,null,null,null,"Incompleto ou Vazio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incompleto ou Vazio"]

{"sheet":"LISTA SUSPENSA","index":5,"n_rows":84,"n_cols":2,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["mês/ano","vencimento"]
["2019-02-01","2019-03-20"]
["2019-03-01","2019-04-20"]
["2019-04-01","2019-05-20"]
["2019-05-01","2019-06-20"]
["2019-06-01","2019-07-20"]
["2019-07-01","2019-08-20"]
["2019-08-01","2019-09-20"]
["2019-09-01","2019-10-20"]
["2019-10-01","2019-11-20"]
["2019-11-01","2019-12-20"]
["2019-12-01","2020-01-20"]
["2020-01-01","2020-02-20"]
["2020-02-01","2020-03-20"]
["2020-03-01","2020-04-20"]
["2020-04-01","2020-05-20"]
["2020-05-01","2020-06-20"]
["2020-06-01","2020-07-20"]
["2020-07-01","2020-08-20"]
["2020-08-01","2020-09-20"]
["2020-09-01","2020-10-20"]
["2020-10-01","2020-11-20"]
["2020-11-01","2020-12-20"]
["2020-12-01","2021-01-20"]
["2021-01-01","2021-02-20"]
["2021-02-01","2021-03-20"]
["2021-03-01","2021-04-20"]
["2021-04-01","2021-05-20"]
["2021-05-01","2021-06-20"]
["2021-06-01","2021-07-20"]
["2021-07-01","2021-08-20"]
["2021-08-01","2021-09-20"]
["2021-09-01","2021-10-20"]
["2021-10-01","2021-11-20"]
["2021-11-01","2021-12-20"]
["2021-12-01","2022-01-20"]
["2022-01-01","2022-02-20"]
["2022-02-01","2022-03-20"]
["2022-03-01","2022-04-20"]
["2022-04-01","2022-05-20"]
["2022-05-01","2022-06-20"]
["2022-06-01","2022-07-20"]
["2022-07-01","2022-08-20"]
["2022-08-01","2022-09-20"]
["2022-09-01","2022-10-20"]
["2022-10-01","2022-11-20"]
["2022-11-01","2022-12-20"]
["2022-12-01","2023-01-20"]
["2023-01-01","2023-02-20"]
["2023-02-01","2023-03-20"]
["2023-03-01","2023-04-20"]
["2023-04-01","2023-05-20"]
["2023-05-01","2023-06-20"]
["2023-06-01","2023-07-20"]
["2023-07-01","2023-08-20"]
["2023-08-01","2023-09-20"]
["2023-09-01","2023-10-20"]
["2023-10-01","2023-11-20"]
["2023-11-01","2023-12-20"]
["2023-12-01","2024-01-20"]
["2024-01-01","2024-02-20"]
["2024-02-01","2024-03-20"]
["2024-03-01","2024-04-20"]
["2024-04-01","2024-05-20"]
["2024-05-01","2024-06-20"]
["2024-06-01","2024-07-20"]
["2024-07-01","2024-08-20"]
["2024-08-01","2024-09-20"]
["2024-09-01","2024-10-20"]
["2024-10-01","2024-11-20"]
["2024-11-01","2024-12-20"]
["2024-12-01","2025-01-20"]
["2025-01-01","2025-02-20"]
["2025-02-01","2025-03-20"]
["2025-03-01","2025-04-20"]
["2025-04-01","2025-05-20"]
["2025-05-01","2025-06-20"]
["2025-06-01","2025-07-20"]
["2025-07-01","2025-08-20"]
["2025-08-01","2025-09-20"]
["2025-09-01","2025-10-20"]
["2025-10-01","2025-11-20"]
["2025-11-01","2025-12-20"]
["2025-12-01","2026-01-20"]

{"sheet":"Banco de dados envio SEF","index":6,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":true,"merged":[[10,9,10,11],[5,1,5,2],[6,1,6,2],[8,1,8,3],[9,1,9,2],[16,9,16,11],[3,1,3,2],[8,4,8,11],[1,2,1,11],[2,1,2,2],[2,3,2,11],[3,3,3,11],[4,1,4,2],[4,3,4,11],[5,5,5,6],[6,3,6,4],[6,6,6,7],[7,1,7,2],[7,3,7,5],[7,6,7,11],[9,9,9,11],[11,9,11,11],[12,9,12,11],[13,9,13,11],[14,9,14,11],[15,9,15,11],[17,9,17,11],[18,9,18,11],[19,9,19,11],[20,9,20,11],[21,9,21,11],[22,9,22,11],[23,9,23,11],[24,9,24,11],[25,9,25,11],[26,9,26,11],[27,9,27,11],[28,9,28,11],[29,9,29,11],[30,9,30,11],[31,9,31,11],[37,9,37,11],[38,9,38,11],[39,9,39,11],[32,9,32,11],[33,9,33,11],[34,9,34,11],[35,9,35,11],[36,9,36,11]]}
[]
[null,{"$f":"DRT!C9","v":1},{"$f":"DRT!D9","v":"  DADOS DA INSTITUIÇÃO FINANCEIRA"},{"$f":"DRT!E9","v":0},{"$f":"DRT!F9","v":0},{"$f":"DRT!G9","v":0},{"$f":"DRT!H9","v":0},{"$f":"DRT!I9","v":0},{"$f":"DRT!J9","v":0},{"$f":"DRT!K9","v":0},{"$f":"DRT!L9","v":0},{"$f":"DRT!M9","v":0}]
[null,{"$f":"DRT!C10","v":"NOME "},null,{"$f":"DRT!E10","v":0},{"$f":"DRT!F10","v":0},{"$f":"DRT!G10","v":0},{"$f":"DRT!H10","v":0},{"$f":"DRT!I10","v":0},{"$f":"DRT!J10","v":0},{"$f":"DRT!K10","v":0},{"$f":"DRT!L10","v":0},{"$f":"DRT!M10","v":0}]
[null,{"$f":"DRT!C11","v":"RAZÃO SOCIAL"},null,{"$f":"DRT!E11","v":0},{"$f":"DRT!F11","v":0},{"$f":"DRT!G11","v":0},{"$f":"DRT!H11","v":0},{"$f":"DRT!I11","v":0},{"$f":"DRT!J11","v":0},{"$f":"DRT!K11","v":0},{"$f":"DRT!L11","v":0},{"$f":"DRT!M11","v":0}]
[null,{"$f":"DRT!C12","v":"CNPJ"},{"$f":"DRT!D12","v":0},{"$f":"DRT!E12","v":0},{"$f":"DRT!F12","v":0},{"$f":"DRT!G12","v":0},{"$f":"DRT!H12","v":0},{"$f":"DRT!I12","v":0},{"$f":"DRT!J12","v":0},{"$f":"DRT!K12","v":0},{"$f":"DRT!L12","v":0},{"$f":"DRT!M12","v":0}]
[null,{"$f":"DRT!C13","v":"ENDEREÇO       (Rua, Av. Praça etc.)"},{"$f":"DRT!D13","v":0},{"$f":"DRT!E13","v":"Tipo"},{"$f":"DRT!F13","v":0},{"$f":"DRT!G13","v":0},{"$f":"DRT!H13","v":0},{"$f":"DRT!I13","v":"Nº"},{"$f":"DRT!J13","v":0},{"$f":"DRT!K13","v":"COMPLEMENTO"},{"$f":"DRT!L13","v":0},{"$f":"DRT!M13","v":0}]
[null,{"$f":"DRT!C14","v":"BAIRRO"},{"$f":"DRT!D14","v":0},{"$f":"DRT!E14","v":0},{"$f":"DRT!F14","v":0},{"$f":"DRT!G14","v":"Município"},{"$f":"DRT!H14","v":0},{"$f":"DRT!I14","v":0},{"$f":"DRT!J14","v":"UF"},{"$f":"DRT!K14","v":0},{"$f":"DRT!L14","v":"CEP"},{"$f":"DRT!M14","v":0}]
[null,{"$f":"DRT!C15","v":"FONE/FAX"},{"$f":"DRT!D15","v":0},{"$f":"DRT!E15","v":0},{"$f":"DRT!F15","v":0},{"$f":"DRT!G15","v":0},{"$f":"DRT!H15","v":0},{"$f":"DRT!I15","v":0},{"$f":"DRT!J15","v":0},{"$f":"DRT!K15","v":0},{"$f":"DRT!L15","v":0},{"$f":"DRT!M15","v":0}]
[null,"ATICMS - Atualização do ICMS vencido",null,null,"Informações Complementares DAE"]
["ORDEM","Data de vencimento",null,"Valor do ICMS (ITCD)","Nome Participante","CPF","Data do óbito","Data do aviso","Número do DAE"]
[1,{"$f":"DRT!M75","v":{"$error":"#N/A"}},null,{"$f":"DRT!M76","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A11,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A11,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A11,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A11,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A11,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[2,{"$f":"DRT!M92","v":{"$error":"#N/A"}},null,{"$f":"DRT!M93","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A12,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A12,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A12,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A12,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A12,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[3,{"$f":"DRT!M109","v":{"$error":"#N/A"}},null,{"$f":"DRT!M110","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A13,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A13,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A13,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A13,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A13,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[4,{"$f":"DRT!M126","v":{"$error":"#N/A"}},null,{"$f":"DRT!M127","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A14,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A14,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A14,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A14,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A14,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[5,{"$f":"DRT!M143","v":{"$error":"#N/A"}},null,{"$f":"DRT!M144","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A15,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A15,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A15,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A15,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A15,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[6,{"$f":"DRT!M164","v":{"$error":"#N/A"}},null,{"$f":"DRT!M165","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A16,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A16,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A16,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A16,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A16,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[7,{"$f":"DRT!M181","v":{"$error":"#N/A"}},null,{"$f":"DRT!M182","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A17,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A17,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A17,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A17,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A17,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[8,{"$f":"DRT!M198","v":{"$error":"#N/A"}},null,{"$f":"DRT!M199","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A18,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A18,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A18,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A18,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A18,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[9,{"$f":"DRT!M215","v":{"$error":"#N/A"}},null,{"$f":"DRT!M216","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A19,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A19,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A19,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A19,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A19,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[10,{"$f":"DRT!M232","v":{"$error":"#N/A"}},null,{"$f":"DRT!M233","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A20,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A20,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A20,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A20,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A20,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[11,{"$f":"DRT!M253","v":{"$error":"#N/A"}},null,{"$f":"DRT!M254","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A21,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A21,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A21,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A21,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A21,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[12,{"$f":"DRT!M270","v":{"$error":"#N/A"}},null,{"$f":"DRT!M271","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A22,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A22,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A22,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A22,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A22,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[13,{"$f":"DRT!M287","v":{"$error":"#N/A"}},null,{"$f":"DRT!M288","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A23,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A23,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A23,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A23,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A23,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[14,{"$f":"DRT!M304","v":{"$error":"#N/A"}},null,{"$f":"DRT!M305","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A24,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A24,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A24,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A24,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A24,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[15,{"$f":"DRT!M321","v":{"$error":"#N/A"}},null,{"$f":"DRT!M322","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A25,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A25,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A25,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A25,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A25,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[16,{"$f":"DRT!M342","v":{"$error":"#N/A"}},null,{"$f":"DRT!M343","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A26,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A26,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A26,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A26,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A26,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[17,{"$f":"DRT!M359","v":{"$error":"#N/A"}},null,{"$f":"DRT!M360","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A27,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A27,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A27,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A27,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A27,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[18,{"$f":"DRT!M376","v":{"$error":"#N/A"}},null,{"$f":"DRT!M377","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A28,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A28,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A28,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A28,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A28,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[19,{"$f":"DRT!M393","v":{"$error":"#N/A"}},null,{"$f":"DRT!M394","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A29,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A29,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A29,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A29,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A29,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[20,{"$f":"DRT!M410","v":{"$error":"#N/A"}},null,{"$f":"DRT!M411","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A30,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A30,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A30,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A30,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A30,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[21,{"$f":"DRT!M431","v":{"$error":"#N/A"}},null,{"$f":"DRT!M432","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A31,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A31,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A31,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A31,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A31,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[22,{"$f":"DRT!M448","v":{"$error":"#N/A"}},null,{"$f":"DRT!M449","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A32,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A32,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A32,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A32,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A32,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[23,{"$f":"DRT!M465","v":{"$error":"#N/A"}},null,{"$f":"DRT!M466","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A33,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A33,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A33,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A33,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A33,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[24,{"$f":"DRT!M482","v":{"$error":"#N/A"}},null,{"$f":"DRT!M483","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A34,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A34,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A34,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A34,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A34,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[25,{"$f":"DRT!M499","v":{"$error":"#N/A"}},null,{"$f":"DRT!M500","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A35,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A35,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A35,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A35,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A35,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[26,{"$f":"DRT!M520","v":{"$error":"#N/A"}},null,{"$f":"DRT!M521","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A36,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A36,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A36,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A36,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A36,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[27,{"$f":"DRT!M537","v":{"$error":"#N/A"}},null,{"$f":"DRT!M538","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A37,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A37,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A37,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A37,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A37,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[28,{"$f":"DRT!M554","v":{"$error":"#N/A"}},null,{"$f":"DRT!M555","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A38,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A38,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A38,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A38,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A38,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[29,{"$f":"DRT!M571","v":{"$error":"#N/A"}},null,{"$f":"DRT!M572","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A39,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A39,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A39,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A39,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A39,DRT!$C$20:$N$49,11,FALSE)","v":0}]
[30,{"$f":"DRT!M588","v":{"$error":"#N/A"}},null,{"$f":"DRT!M589","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A40,DRT!$C$20:$N$49,2,FALSE)","v":0},{"$f":"VLOOKUP(A40,DRT!$C$20:$N$49,6,FALSE)","v":0},{"$f":"VLOOKUP(A40,DRT!$C$20:$N$49,7,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A40,DRT!$C$20:$N$49,9,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP(A40,DRT!$C$20:$N$49,11,FALSE)","v":0}]

{"sheet":"VALOR UFFEMG","index":7,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["RESOLUÇÃO","PERÍODO INICIAL","PERÍODO FINAL","ANO","UFEMG"]
["3.303/2002","2003-01-01","2003-12-31",2003,1.2490000000000001]
["3.486/2003","2004-01-01","2004-12-31",2004,1.4460999999999999]
["3.603/2004","2005-01-01","2005-12-31",2005,1.6174999999999999]
["3.722/2005","2006-01-01","2006-12-31",2006,1.6528]
["3.837/2006","2007-01-01","2007-12-31",2007,1.708]
["3.934/2007","2008-01-01","2008-12-31",2008,1.8122]
["4.045/2008","2009-01-01","2009-12-31",2009,2.0348999999999999]
["4.169/2009","2010-01-01","2010-12-31",2010,1.9991000000000001]
["4.270/2010","2011-01-01","2011-12-31",2011,2.1812999999999998]
["4.375/2011","2012-01-01","2012-12-31",2012,2.3290999999999999]
["4.499/2012","2013-01-01","2013-12-31",2013,2.5015999999999998]
["4.618/2013","2014-01-01","2014-12-31",2014,2.6381999999999999]
["4.723/2014","2015-01-01","2015-12-31",2015,2.7229000000000001]
["4.841/2015","2016-01-01","2016-12-31",2016,3.0108999999999999]
["4.952/2016","2017-01-01","2017-12-31",2017,3.2513999999999998]
["5.073/2017","2018-01-01","2018-12-31",2018,3.2513999999999998]
["5.200/2018","2019-01-01","2019-12-31",2019,3.5931999999999999]