{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DOF_LIMPO_EXCECAO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"DOF_LIMPO_EXCECAO","index":0,"n_rows":15,"n_cols":134,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,30,4,35],[4,45,4,50],[4,25,4,29],[3,25,3,37],[4,36,5,36],[4,37,5,37],[4,99,4,107],[4,86,4,88],[3,41,3,51],[3,94,3,98],[4,81,4,85],[4,94,4,97],[4,41,4,44],[4,55,4,58],[4,59,4,76],[3,55,3,76],[3,81,3,90]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angélica","SIM","Deve estar no GRID",4.65E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MANTER","MANTER","MANTER","MANTER",null,null,null,null,null,null,"MANTER","MANTER","MANTER","MANTER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Claudia","NÃO","NÃO deve estar no GRID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCULTO","OCULTO","OCULTO","OCULTO",null,null,null,null,null,null,"OCULTO","OCULTO","OCULTO","OCULTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Claudinei"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIS / COFINS / CSLL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRRF",null,null,null,null,null,null,null,null,null,null,null,null,null,"INSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISS",null,null,null,null,null,null,null,null,null,null,null,null,"INSS PATRONAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Débora"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regra Geral PCC",null,null,null,null,"EXCEÇÕES PCC",null,null,null,null,null,"Comentários","Exceções PCC",null,null,null,"Regra Geral IRRF",null,null,null,"EXCEÇÕES IRRF",null,null,null,null,null,null,null,null,null,"Regra Geral - INSS",null,null,null,"EXCEÇÕES INSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regra Geral - ISS",null,null,null,null,"EXCEÇÕES ISS",null,null,null,null,null,null,null,"Regra Geral - INSS Patronal",null,null,null,null,"TESTES FINAIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diego"]
["INFORMANTE_EST_CODIGO","INFORMANTE_RAZAO_SOCIAL","INFORMANTE_CNPJ_CPF","INFORMANTE_MUNICIPIO","REMETENTE_PFJ_CODIGO","REMETENTE_RAZAO_SOCIAL","REMETENTE_CNPJ_CPF","REMENTE_MUNICIPIO","DOCNUM","NUMERO_NF","DATA_EMISSAO","DATA_FATO_GERADOR","SERVICO_CODIGO","SERVICO_DESCRICAO","PRECO_TOTAL","CONCATENAR","BASE_PCC_CAPA","PCC_CAPA","BASE_PCC","ALIQ_PIS","VALOR_PIS","ALIQ_COFINS","VALOR_COFINS","ALIQ_CSLL","VALOR_CSLL","PCC_RETENÇÃO ","PCC_INCIDÊNCIA ","PCC_ALÍQUOTA","PCC_TRIBUTAÇÃO ","PCC_STATUS","REGRA 1 PCC","Vendors sujeito ao PCC","REGRA 2 PCC","Vendors não sujeito ao PCC (EXCLUDE)","REGRA 3 PCC","Vendors sujeito ao PCC incluindo redução alíquota",null,null,"BASE_IRRF","ALIQ_IRRF","VALOR_IRRF","IRRF_INCIDÊNCIA ","IRRF_ALÍQUOTA ","IRRF_TRIBUTAÇÃO ","IRRF_STATUS ","REGRA 1 IRRF","Vendors sujeito ao IRRF","REGRA 2 IRRF","Vendors não sujeito ao IRRF (EXCLUDE)","REGRA 3 IRRF","Vendors sujeito ao IRRF incluindo redução alíquota","Comentários","BASE_INSS","ALIQ_INSS","VALOR_INSS","INSS_INCIDÊNCIA ","INSS_ALÍQUOTA ","INSS_TRIBUTAÇÃO ","INSS_STATUS ","REGRA 1 INSS","Vendors sujeito ao INSS","Status Base INSS","Status Alíquota INSS","Base DOF INSS","Aliquota DOF INSS","Base BRF+ INSS","Aliquota BRF+ INSS","REGRA 2 INSS","Vendors não sujeito ao INSS (EXCLUDE)","REGRA 3 INSS","Vendors sujeito ao INSS incluindo redução alíquota","Status Base INSS","Status Alíquota INSS","Base DOF INSS","Aliquota DOF INSS","Base BRF+ INSS","Aliquota BRF+ INSS","Comentários","BASE_ISS","ALIQ_ISS","VALOR_ISS","ISS_COLUNA_WHT","ISS_INCIDÊNCIA ","ISS_ALÍQUOTA ","ISS_TRIBUTAÇÃO ","ISS_STATUS ","REGRA 1 ISS","Vendors não sujeito ao ISS (EXCLUDE)","SIMPLES","Comentários","Guia Avulsa","BASE_INSS_PATR","ALIQ_INSS_PATR","VALOR_INSS_PATR","INSS_PATR_INCIDÊNCIA ","INSS_PATR_TRIBUTAÇÃO ","INSS_PATR_ALÍQUOTA ","INSS_PATR_STATUS ","Comentários","AUTOMÁTICO OU MANUAL ","MIRO","DOC CONTÁBIL ","WITH_ITEM","VERIFICAR ","ALTERAÇÃO ","ANALISTA","SYNCHRO","CIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ezequiel"]
["31B011E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0001-57","Sao Paulo",1992540,"EVERY AD MEDIA GROUP PUBLICIDADE DIGITAL LTDA","14.840.437/0001-48","Sao Paulo",2689909,620,"2017-12-07","2018-01-05","01.01","Analise e desenvolvimento de sistemas",91000,"199254001.01",0,0,0,0,0,0,0,0,0,0,"SIM",4.65E-2,4231.5,"VERIFICAR",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Verificar",null,0,0,0,"SIM",1.4999999999999999E-2,1365,"VERIFICAR",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Verificar",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,47,{"$f":"VLOOKUP(M7,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.05,4550,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Géssica"]
["31B011E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0001-57","Sao Paulo",1266459,"SYNCHRO SISTEMAS DE INFORMACAO LTDA","67.185.306/0001-30","Sao Paulo",2689355,29003,"2017-12-12","2018-01-04","01.01","Analise e desenvolvimento de sistemas",21367.88,"126645901.01",21367.88,993.6,0,0,0,0,0,0,0,993.6,"SIM",4.65E-2,6.420000000048276E-3,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",null,21367.88,1.5,320.52,"SIM",1.4999999999999999E-2,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,47,{"$f":"VLOOKUP(M8,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.05,1068.394,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guadalupe"]
["31B011E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0001-57","Jacarei",1266459,"SYNCHRO SISTEMAS DE INFORMACAO LTDA","67.185.306/0001-30","Sao Paulo",2711791,29004,"2017-12-12","2018-02-07","01.01","Analise e desenvolvimento de sistemas",28370.75,"126645901.01",28370.75,1319.24,0,0,0,0,0,0,0,1319.24,"SIM",4.65E-2,-1.2500000002546585E-4,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",null,28370.75,1.5,425.56,"SIM",1.4999999999999999E-2,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,47,{"$f":"VLOOKUP(M9,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.05,1418.5375000000001,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]
["31B011E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0001-57","Sao Paulo",1266459,"SYNCHRO SISTEMAS DE INFORMACAO LTDA","67.185.306/0001-30","Sao Paulo",2713701,29272,"2018-01-16","2018-02-09","01.01","Analise e desenvolvimento de sistemas",21367.87,"126645901.01",0,0,0,0,0,0,0,0,0,0,"SIM",4.65E-2,993.60595499999999,"VERIFICAR",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Verificar",null,21367.87,1.5,320.52,"SIM",1.4999999999999999E-2,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,47,{"$f":"VLOOKUP(M10,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.05,1068.3934999999999,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]
["31B011E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0001-57","Sao Paulo",2046196,"RESOURCE TEC E INFO LTDA","04.947.601/0001-67","Sao Paulo",2730448,35013,"2018-02-08","2018-02-28","01.01","Analise e desenvolvimento de sistemas",3471,"204619601.01",0,0,0,0,0,0,0,0,0,0,"SIM",4.65E-2,161.4015,"VERIFICAR",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Verificar",null,3471,1.5,52.06,"SIM",1.4999999999999999E-2,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,47,{"$f":"VLOOKUP(M11,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.05,173.55,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]
["4083B002E","ROHM AND HAAS QUIMICA LTDA Jacareí, Brasil","00.310.651/0003-40","Jacarei",1046113,"IUS NATURA LTDA EPP","26.265.371/0001-99","Nova Lima",2713874,4908,"2018-01-02","2018-02-11","01.02","Programacao",655,"104611301.02",655,30.46,0,0,0,0,0,0,0,30.46,"SIM",4.65E-2,-2.500000000001279E-3,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",null,655,1.5,9.83,"SIM",1.4999999999999999E-2,-0.01,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,27,{"$f":"VLOOKUP(M12,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.03,19.649999999999999,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]
["4083B002E","ROHM AND HAAS QUIMICA LTDA Jacareí, Brasil","00.310.651/0003-40","Jacarei",1046113,"IUS NATURA LTDA EPP","26.265.371/0001-99","Nova Lima",2717851,5418,"2018-02-05","2018-02-17","01.02","Programacao",655,"104611301.02",655,30.46,0,0,0,0,0,0,0,30.46,"SIM",4.65E-2,-2.500000000001279E-3,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",null,655,1.5,9.83,"SIM",1.4999999999999999E-2,-0.01,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,27,{"$f":"VLOOKUP(M13,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.03,19.649999999999999,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]
["31B007E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0005-80","Pindamonhangaba",1046113,"IUS NATURA LTDA EPP","26.265.371/0001-99","Nova Lima",2712518,5010,"2018-01-08","2018-02-08","01.02","Programacao",655,"104611301.02",0,0,0,0,0,0,0,0,0,0,"SIM",4.65E-2,30.4575,"VERIFICAR",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Verificar",null,655,1.5,0,"SIM",1.4999999999999999E-2,9.83,"VERIFICAR",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"Verificar",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,41,{"$f":"VLOOKUP(M14,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.02,13.1,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]
["31B011E","Dow Brasil Industria e Comercio de Produtos Quimicos LTDA","60.435.351/0001-57","Guaruja",1046113,"IUS NATURA LTDA EPP","26.265.371/0001-99","Nova Lima",2710774,4905,"2018-01-02","2018-02-05","01.02","Programacao",655,"104611301.02",655,30.46,0,0,0,0,0,0,0,30.46,"SIM",4.65E-2,-2.500000000001279E-3,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",null,655,1.5,9.83,"SIM",1.4999999999999999E-2,-0.01,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,"NÃO",0,0,"OK",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,{"$error":"#N/A"},{"$error":"#N/A"},"OK",0,0,0,47,{"$f":"VLOOKUP(M15,'[1]ISS WITHHOLDING'!$B:$D,3,0)","v":"NÃO"},0.05,32.75,"OK",{"$error":"#N/A"},{"$error":"#N/A"},"NÃO","OK",null,0,0,0,"NÃO",0,0,"OK"]