{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Accueil","RJ","Filtrage RJ","ERDS","Filtrage ERDS"],"not_rendered":{"images":1,"macros":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":29,"n_cols":32,"rows_kept":29}
["ER/DS","Entité déclarante","Date de transmission au responsable LCB-FT (ER)","Date de validation du responsable LCB-FT (ER)","Date de transmission au responsable LCB-FT (DS)","Date de validation du responsable LCB-FT (DS)","Nom et prénom du demandeur","Direction","Réseau / Apporteur","Source / mode de saisie","Personne en charge","Date de prise en charge","Nom du client","Prénom du client","Numéro de contrat","Dénomination contrat","Indicateur de suivi client","Type d'opération","Montant","Motif de l'ER","Motif de la DS : au titre du chiffre 1","Motif de la DS : au titre du chiffre 2","Motif de la DS : au titre du chiffre 1 et 2","Motif CDS","Motif de la DS FT","Fait générateur ","Date du fait générateur","Date de clôture","Délai de déclaration","Ouvert / Clos","N°AR Tracfin","Commentaire de clôture"]
["ER","Abeille Vie","2022-06-15","2022-06-17",{"$nulls":4},"CLC International Assurance","Remontée par la DJ","Anthony GIOVANNOLI ","2022-06-15","BARIMBOIM ","Lucienne",9880008397,"Norwich libre choix","N/A","Règlement de capital décès",{"v":46000,"d":"46,000 €"},"Soupçon d'abus de faiblesse",{"$nulls":8},0,"Clos",null,"DS avec droit d'opposition "]
["DS","Abeille Vie",null,null,"2022-06-17","2022-06-17",null,null,"CLC International Assurance","Remontée par la DJ","Anthony GIOVANNOLI ","2022-06-17","BARIMBOIM ","Lucienne",9880008397,"Norwich libre choix","N/A","Règlement de capital décès",{"v":46000,"d":"46,000 €"},null,"X",{"$nulls":4},"Sollicitation de la DJ","2022-06-14","2022-06-17",3,"Ouvert ",null,"DS avec droit d'opposition pour abus de faiblesse"]
[]
[]
[]
[]
[]
[7,"Client Suivi LCBFT","Client Suivi","2022-08-09",null,"CORLAY","herve",null,"28/03/1982",123456,654321,"Abeille Vie",10000,"Oui","15/08/2021",null,null,"Oui","Anthony GIOVANNOLI","blabla2"]
[8,null,null,"2022-08-11",null,"toto","tatz"]
[10,null,null,"2022-08-11",null,"tets","test"]
[]
[12,null,null,"2022-08-11","2000-08-01","caca","D'oie",null,"2000-01-09"]
[1,"Client Suivi LCBFT",null,"2022-09-08",null,"frdfrd","frdf"]
[14,null,null,"2022-08-11",null,"TIDJANI","SARAH"]
[15,null,null,"2022-08-11",null,"toto","tata"]
[16,null,null,"2022-08-11",null,"deded","dede"]
[]
[]
[19,null,null,"2022-08-11"]
[20,"Réquisition Judicaire","Client Suivi","2022-08-11","2022-08-01","test","test",{"$nulls":7},"2021-09-01"]
[]
[22,null,null,"2022-08-11",null,"toto","tata"]
[23,null,null,"2022-08-11",null,"tete","tete"]
[24,null,null,"2022-08-11",null,"toto","tutu"]
[25,null,null,"2022-08-11",null,"toto","toto"]
[26,"Client Suivi LCBFT","Client Suivi","2022-08-12","2022-08-11","LE CLOWN","BENZO",null,"1990-01-01",321,321,"ALPIDAC",135,"Oui","2000-08-01",null,"2021-09-01","Oui","Sarah TIDJANI","commentaire"]
[]
[28,null,null,"2022-08-12",null,"SANFAMY","REMI"]

{"sheet":"RJ","index":1,"n_rows":31,"n_cols":20,"rows_kept":31}
["Référence","Typologie de l'opération","Nature de l'opération","Date de l'opération ","Date de Saisie","Nom","Prénom","Nom/Prénom","Date de naissance","Numéro de client","Numéro de contrat ","Réseau","Valeur du contrat à ce jour","Rattachement BAR","Date Rattachement","Surveillance Rattachement","Date Détachement","Examen Renforcé","Analyste","Commentaires"]
["A",{"$nulls":14},{"$f":"IF(O2=\"\",\"\",TODAY()-O2)","v":""}]
[1,"Client Suivi LCBFT","Client Suivi","2022-08-12","2022-08-01","CORLAY","Thomas",{"$f":"IF(F3=\"\",\"\",IF(I3=\"\",CONCATENATE(F3,\" / \",G3),CONCATENATE(F3,\" / \",G3,\" - \",TEXT(I3,\"jj/mm/aaaa\"))))","v":"CORLAY / Thomas - 28/03/1982"},"1982-03-28",123456,654321,"Abeille Vie",10000,"Oui","2021-08-15",{"$f":"IF(O3=\"\",\"\",TODAY()-O3)","v":362},null,"Oui","Anthony GIOVANNOLI","blablabla"]
[2,"Client Suivi LCBFT","Client Suivi","2022-08-11","1999-09-09","SPARROW","Jack",{"$f":"IF(F4=\"\",\"\",IF(I4=\"\",CONCATENATE(F4,\" / \",G4),CONCATENATE(F4,\" / \",G4,\" - \",TEXT(I4,\"jj/mm/aaaa\"))))","v":"SPARROW / Jack - 03/09/1978"},"1978-09-03",12345,54321,"Abeille Vie",{"v":5000,"d":"5,000.00 €"},"Oui","2020-08-01",{"$f":"IF(O4=\"\",\"\",TODAY()-O4)","v":741},"2021-09-01","Oui","Stéphane SEBELOUE","blabla2"]
[3,"Client Suivi LCBFT","Client Suivi","2022-10-08","2022-08-01","CORLAY MARA A","Silas","CORLAY MARA A / Silas - 09/11/2016","2016-11-09",123,321,"Abeille Retraite Professionnelle",{"v":10000,"d":"10,000.00 €"},"Oui","2021-09-08",338,null,"Oui","Mona FOUDA","bla bla bla"]
[4,"Réquisition Judicaire","Enquête Préliminaire","2022-08-11","2022-08-01","BOULE","HENRI","BOULE / HENRI - 01/08/2000","2000-08-01",654321,123456,"Abeille Epargne Retraite",{"v":15000,"d":"15,000.00 €"},"Oui","2020-08-01",741,"2021-09-01","Non","Anthony GIOVANNOLI","azerty"]
[5,"Client Suivi LCBFT","Enquête Préliminaire","2022-10-08","2022-01-08","CORLAY MARA","NAEL","CORLAY MARA / NAEL - 24/06/2019","24/06/2019",123,123,"ALPIDAC",{"v":99999999,"d":"99,999,999.00 €"},"Non",null,"",null,"Non","Sarah TIDJANI","hop hop hop"]
[7,"Réquisition Judicaire","Enquête Préliminaire","2022-11-08","2019-01-08","DURANT","JEAN","DURANT / JEAN - 19/09/1959","19/09/1959",123,321,"Abeille Epargne Retraite",{"v":1000000,"d":"1,000,000.00 €"},"Non",null,"",null,"Oui","Mona FOUDA","tototototo"]
[8,"Réquisition Judicaire","Enquête Préliminaire","2022-08-11","2022-08-01","MARA","Samia","MARA / Samia - 01/09/1980","1980-09-01",321,654,"Abeille Vie",{"v":10000,"d":"10,000.00 €"},"Non",null,"",null,"Oui","Stéphane SEBELOUE","Comment"]
[9,null,null,"2022-11-08","28/03/2000","test","test","test / test - 09/01/2000","2000-01-09",{"$nulls":6},""]
[10,null,null,"2022-08-11",null,"toto","tata","toto / tata",{"$nulls":7},""]
[11,"Client Suivi LCBFT","Client Suivi","2022-08-11","2022-08-01","RICARDO","Sébastien","RICARDO / Sébastien - 01/08/2000","2000-08-01",null,null,"ALPIDAC",null,"Non",null,""]
[12,"Client Suivi LCBFT","Client Suivi","2022-08-11","2000-09-01","caca","dwa","caca / dwa - 08/01/2000","2000-01-08",{"$nulls":6},""]
[13,"Réquisition Judicaire","Enquête Préliminaire","2022-08-11","2022-09-01","Tortue","NINJA","Tortue / NINJA - 28/07/1955","1955-07-28",4321,1234,"Abeille Retraite Professionnelle",{"v":10000,"d":"10,000.00 €"},"Oui","2022-11-08",-88,null,"Non","Sarah TIDJANI","COMM"]
[14,null,null,"2022-08-11",null,"toto","tata","toto / tata",{"$nulls":7},""]
[15,null,null,"2022-08-11",null,"fromage","gruyere","fromage / gruyere",{"$nulls":7},"",{"$nulls":3},"camembert"]
[16,"Réquisition Judicaire","Enquête Préliminaire","2022-08-11","2000-08-01","NEYMARD","JEAN","NEYMARD / JEAN - 01/09/2000","2000-09-01",null,null,"Abeille Vie",{"v":12000,"d":"12,000.00 €"},"Oui","2020-09-01",710,"2021-08-01"]
[17,"Réquisition Judicaire","Enquête Préliminaire","2022-08-11","2022-01-08","TANGUY","Guillaume","TANGUY / Guillaume - 09/01/2000","2000-01-09",{"$nulls":3},{"v":1000,"d":"1,000.00 €"},"Non","2000-01-08",null,"2000-01-09","Non"]
[18,"Réquisition Judicaire","Enquête Préliminaire","2022-08-11","2022-08-01","CHARPENTIER","Christophe","CHARPENTIER / Christophe - 01/09/2000","2000-09-01",123,123,"Abeille Epargne Retraite",{"v":10000,"d":"10,000.00 €"},"Oui","2000-08-01",null,"2000-09-01","Non","Anthony GIOVANNOLI","tutu"]
[19,null,null,"2022-08-11",{"$nulls":3},""]
[20,null,null,"2022-08-11",null,"test","test","test / test"]
[21,"Client Suivi LCBFT","Enquête Préliminaire","2022-08-11",null,"LARVOR","JAMES","LARVOR / JAMES - 01/08/2000","2000-08-01",{"$nulls":5},"2020-09-01"]
[22,null,null,"2022-08-11",null,"toto","tata","toto / tata"]
[23,null,null,"2022-08-11",null,"tetet","tete","tetet / tete"]
[24,null,null,"2022-08-11",null,"toto ","tutu","toto  / tutu"]
[25,null,null,"2022-08-11",null,"toto","toto","toto / toto"]
[26,null,null,"2022-08-12",null,"remi","remi","remi / remi",{"$nulls":7},{"$f":"IF(O27=\"\",\"\",TODAY()-O27)","v":""}]
[27,"Client Suivi LCBFT","Client Suivi","2022-08-12","2022-08-01","LE CLOWN","BENZO","LE CLOWN / BENZO",null,123,321,"Abeille Vie",{"v":135,"d":"135.00 €"},"Oui","2021-08-01",376,"2022-09-01","Oui","Sarah TIDJANI","commentaire"]
[28,null,null,"2022-08-12",null,"SANFAMY","Rémi","SANFAMY / Rémi",{"$nulls":7},""]
[29,"Réquisition Judicaire","Enquête Préliminaire","2022-08-12","2022-08-01","LECITADAIN","Isidor","LECITADAIN / Isidor - 01/09/1956","1956-09-01",54321,12345,"Abeille Epargne Retraite",{"v":5000,"d":"5,000.00 €"},"Oui","2022-01-01",223,null,"Oui","Stéphane SEBELOUE","com"]
[{"$nulls":7},"",{"$nulls":7},""]

{"sheet":"Filtrage RJ","index":2,"n_rows":2,"n_cols":27,"rows_kept":2}
["Référence","Typologie de l'opération","Nature de l'opération","Date de l'opération ","Date de Saisie","Nom","Prénom","Nom/Prénom","Date de naissance","Numéro de client","Numéro de contrat ","Réseau","Valeur du contrat à ce jour","Rattachement BAR","Date Rattachement","Surveillance Rattachement","Date Détachement","Examen Renforcé","Analyste","Commentaires",{"$nulls":6},"Nom"]
[15,null,null,"2022-08-11",null,"fromage","gruyere","fromage / gruyere - ",{"$nulls":7},"",{"$nulls":3},"camembert",{"$nulls":6},"f"]

{"sheet":"ERDS","index":3,"n_rows":7,"n_cols":29,"rows_kept":7}
["ER/DS","Entité déclarante","Date de transmission au responsable LCB-FT (ER)","Date de validation du responsable LCB-FT (ER)","Nom  demandeur","Prénom demandeur","Direction","Réseau / Apporteur","Source / mode de saisie","Personne en charge","Date de prise en charge","Nom du client","Prénom du client","Numéro de contrat","Dénomination contrat","Indicateur de suivi client","Type d'opération","Montant","Motif de l'ER","Motif de la DS : au titre du chiffre 1","Motif CDS","Motif de la DS FT","Fait générateur ","Date du fait générateur","Date de clôture","Délai de déclaration","Ouvert / Clos","N°AR Tracfin","Commentaire de clôture"]
["ER","Abeille Vie","2022-06-15","2022-06-17",{"$nulls":3},"CLC International Assurance","Remontée par la DJ","Anthony GIOVANNOLI ","2022-06-15","BARIMBOIM ","Lucienne",9880008397,"Norwich libre choix","N/A","Règlement de capital décès",{"v":46000,"d":"46,000 €"},"Soupçon d'abus de faiblesse",{"$nulls":6},0,"Clos",null,"DS avec droit d'opposition "]
["DS","Abeille Vie",{"$nulls":5},"CLC International Assurance","Remontée par la DJ","Anthony GIOVANNOLI ","2022-06-17","BARIMBOIM ","Lucienne",9880008397,"Norwich libre choix","N/A","Règlement de capital décès",{"v":46000,"d":"46,000 €"},null,"X",null,null,"Sollicitation de la DJ","2022-06-14","2022-06-17",3,"Ouvert ",null,"DS avec droit d'opposition pour abus de faiblesse"]
["DECLARATION DE SOUPCON","Abeille Vie","dat trans","dat val","coco","toto","DSC","Réseau1",null,"Anthony ","2022-08-08","NOM","prn","contrat","deno contrat","IBI","Règlement de capital décès","montant","Soupçon d'abus de faiblesse","Motif de la DS : au titre du chiffre 1",null,null,"Sollicitation de la DJ","date fait","dat clot",null,"Ouvert"]
["DECLARATION DE SOUPCON","Abeille Vie",{"$nulls":4},"DSC","Réseau1",null,"Anthony ","2022-08-08",{"$nulls":4},"N/A","Règlement de capital décès",{"$nulls":5},"Sollicitation de la DJ",{"$nulls":3},"Ouvert","trac","commm"]
["DECLARATION DE SOUPCON","Abeille Vie",{"$nulls":4},"DSC","Réseau1",null,"Anthony ","2022-08-08",{"$nulls":4},"N/A","Règlement de capital décès",{"$nulls":5},"Sollicitation de la DJ",{"$nulls":3},"Ouvert",null,"ggig"]
[{"$nulls":10},"2022-08-08",{"$nulls":17},"gogo"]

{"sheet":"Filtrage ERDS","index":4,"n_rows":2,"n_cols":53,"rows_kept":2}
["ER/DS","Entité déclarante","Date de transmission au responsable LCB-FT (ER)","Date de validation du responsable LCB-FT (ER)","Nom  demandeur","Prénom demandeur","Direction","Réseau / Apporteur","Source / mode de saisie","Personne en charge","Date de prise en charge","Nom du client","Prénom du client","Numéro de contrat","Dénomination contrat","Indicateur de suivi client","Type d'opération","Montant","Motif de l'ER","Motif de la DS : au titre du chiffre 1","Motif CDS","Motif de la DS FT","Fait générateur ","Date du fait générateur","Date de clôture","Délai de déclaration","Ouvert / Clos","N°AR Tracfin","Commentaire de clôture",{"$nulls":23},"Nom  demandeur"]
["DECLARATION DE SOUPCON","Abeille Vie","dat trans","dat val","coco","toto","DSC","Réseau1",null,"Anthony ","2022-08-08","NOM","prn","contrat","deno contrat","IBI","Règlement de capital décès","montant","Soupçon d'abus de faiblesse","Motif de la DS : au titre du chiffre 1",null,null,"Sollicitation de la DJ","date fait","dat clot",null,"Ouvert",{"$nulls":25},"c"]