{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dossier","Allemagne","France","EU","U.S","Connaissance","Identité","Contact, date de RDV, détail","BDD TOTALE","BDD DESTINATION","BDD PROVENANCE"],"not_rendered":{"charts":0,"images":2,"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":"Dossier","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,1,15,3],[9,10,10,11],[9,12,9,14],[10,12,10,14],[1,16,2,16],[21,17,21,18],[25,7,26,9],[25,10,26,10],[24,27,25,27],[1,2,2,13],[9,4,10,9],[11,4,11,9],[8,10,8,15],[8,1,8,3],[4,10,5,11],[4,12,4,14],[5,12,5,14],[4,1,4,2],[6,1,6,2],[14,4,15,14],[24,28,25,28],[24,29,25,29],[27,20,27,23],[27,24,27,25],[24,24,25,25],[24,26,25,26],[17,1,18,2],[17,3,18,4],[17,7,18,7],[17,8,18,12],[22,7,23,9],[28,7,29,9],[28,10,29,10],[27,17,27,18],[25,16,26,16],[22,10,23,10]]}
[]
[null,null,"Dossier"]
[]
[]
[null,"DOSSIER DEPOSE PAR",null,"MARTIN JEAN",null,null,null,"Nom","DUPONT",null,"la personne est elle adhérente ?",null,"NON"]
[null,null,null,null,null,null,null,"Prenom(s)","PIERRE",null,null,null,"Si non compléter le formulaire :"]
[]
[]
[]
[]
[]
[null,null,null,null,"NON"]
[]
[]
[null,"Description succinte"]
[]
[]
[null,"Entrant/Provenance\nSortant/Destination",null,"Provenance",null,null,null,"Pays","Allemagne"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Connaissance"]
[]
[]
[null,null,null,null,null,null,null,"Description détaillé"]
[]
[]
[null,null,null,null,null,null,null,"Identité"]

{"sheet":"Allemagne","index":1,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,30,3],[29,4,30,4],[22,14,22,18],[23,14,23,18],[20,14,21,18],[23,1,24,3],[23,4,24,4],[26,1,27,3],[26,4,27,4],[18,14,18,18],[19,14,19,18],[20,19,21,19],[20,20,21,20],[10,1,21,5],[10,7,21,12],[10,14,10,18],[11,14,11,18],[12,14,12,18],[13,14,13,18],[14,14,14,18],[15,14,15,18],[16,14,16,18],[17,14,17,18],[2,1,4,12],[6,1,6,12],[8,1,9,5],[8,7,9,12],[8,14,8,18],[9,14,9,18]]}
[]
[]
[null,"Allemagne"]
[]
[]
[]
[]
[]
[null,"JUSTIFICATIFS",null,null,null,null,null,"INFORMATIONS",null,null,null,null,null,null,"JUSTIFICATIFS",null,null,null,null,"Obtenu(s)","Doc(s) \"Manquant(s)\""]
[]
[null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,2,FALSE)","v":"ok"},null,null,null,null,null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,3,FALSE)","v":"ko"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Connaissance"]
[]
[]
[null,"Description détaillé"]
[]
[]
[null,"Identité"]

{"sheet":"France","index":2,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,30,3],[29,4,30,4],[22,14,22,18],[23,14,23,18],[20,14,21,18],[23,1,24,3],[23,4,24,4],[26,1,27,3],[26,4,27,4],[18,14,18,18],[19,14,19,18],[20,19,21,19],[20,20,21,20],[10,1,21,5],[10,7,21,12],[10,14,10,18],[11,14,11,18],[12,14,12,18],[13,14,13,18],[14,14,14,18],[15,14,15,18],[16,14,16,18],[17,14,17,18],[2,1,4,12],[6,1,6,12],[8,1,9,5],[8,7,9,12],[8,14,8,18],[9,14,9,18]]}
[]
[]
[null,"France"]
[]
[]
[]
[]
[]
[null,"JUSTIFICATIFS",null,null,null,null,null,"INFORMATIONS",null,null,null,null,null,null,"JUSTIFICATIFS",null,null,null,null,"Obtenu(s)","Doc(s) \"Manquant(s)\""]
[]
[null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,2,FALSE)","v":"ok"},null,null,null,null,null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,3,FALSE)","v":"ko"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Connaissance"]
[]
[]
[null,"Description détaillé"]
[]
[]
[null,"Identité"]

{"sheet":"EU","index":3,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,1,24,3],[23,4,24,4],[26,1,27,3],[26,4,27,4],[29,1,30,3],[29,4,30,4],[22,14,22,18],[23,14,23,18],[18,14,18,18],[19,14,19,18],[20,19,21,19],[20,20,21,20],[20,14,21,18],[10,1,21,5],[10,7,21,12],[10,14,10,18],[11,14,11,18],[12,14,12,18],[13,14,13,18],[14,14,14,18],[15,14,15,18],[16,14,16,18],[17,14,17,18],[2,1,4,12],[6,1,6,12],[8,1,9,5],[8,7,9,12],[8,14,8,18],[9,14,9,18]]}
[]
[]
[null,"EU"]
[]
[]
[]
[]
[]
[null,"JUSTIFICATIFS",null,null,null,null,null,"INFORMATIONS",null,null,null,null,null,null,"JUSTIFICATIFS",null,null,null,null,"Obtenu(s)","Doc(s) \"Manquant(s)\""]
[]
[null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,2,FALSE)","v":"ok"},null,null,null,null,null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,3,FALSE)","v":"ko"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Connaissance"]
[]
[]
[null,"Description détaillé"]
[]
[]
[null,"Identité"]

{"sheet":"U.S","index":4,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,1,30,3],[29,4,30,4],[22,14,22,18],[23,14,23,18],[20,14,21,18],[23,1,24,3],[23,4,24,4],[26,1,27,3],[26,4,27,4],[18,14,18,18],[19,14,19,18],[20,19,21,19],[20,20,21,20],[10,1,21,5],[10,7,21,12],[10,14,10,18],[11,14,11,18],[12,14,12,18],[13,14,13,18],[14,14,14,18],[15,14,15,18],[16,14,16,18],[17,14,17,18],[2,1,4,12],[6,1,6,12],[8,1,9,5],[8,7,9,12],[8,14,8,18],[9,14,9,18]]}
[]
[]
[null,"U.S"]
[]
[]
[]
[]
[]
[null,"JUSTIFICATIFS",null,null,null,null,null,"INFORMATIONS",null,null,null,null,null,null,"JUSTIFICATIFS",null,null,null,null,"Obtenu(s)","Doc(s) \"Manquant(s)\""]
[]
[null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,2,FALSE)","v":"ok"},null,null,null,null,null,{"$f":"VLOOKUP(B3,'BDD TOTALE'!A2:C6,3,FALSE)","v":"ko"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Connaissance"]
[]
[]
[null,"Description détaillé"]
[]
[]
[null,"Identité"]

{"sheet":"Connaissance","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,2,2,12],[4,2,4,12],[5,2,5,12]]}
[]
[null,null,"LA « CONNAISSANCE »"]
[]
[]
[null,null,"Il s’agit d’un(e) adhérent(e) (nom, prénom, numéro d’adhérent(e))"]

{"sheet":"Identité","index":6,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[[17,3,17,5],[17,7,17,10],[17,11,17,16],[17,17,17,18],[18,3,18,5],[18,7,18,10],[18,11,18,16],[18,17,18,18],[19,3,19,5],[19,7,19,10],[19,11,19,16],[19,17,19,18],[14,7,14,10],[14,11,14,16],[14,17,14,18],[15,7,15,10],[15,11,15,16],[15,17,15,18],[16,3,16,5],[16,7,16,10],[16,11,16,16],[16,17,16,18],[15,3,15,5],[14,3,14,5],[10,17,10,18],[11,7,11,10],[11,11,11,16],[11,17,11,18],[12,3,12,5],[12,7,12,10],[12,11,12,16],[12,17,12,18],[10,11,10,16],[13,7,13,10],[13,11,13,16],[13,17,13,18],[1,3,2,17],[8,3,8,5],[8,7,8,10],[8,11,8,16],[8,17,8,18],[9,3,9,5],[9,7,9,10],[9,11,9,16],[9,17,9,18],[11,3,11,5],[13,3,13,5],[10,3,10,5],[10,7,10,10],[20,3,20,5],[20,7,20,10],[20,11,20,16],[20,17,20,18],[21,3,21,5],[21,7,21,10],[21,11,21,16],[21,17,21,18],[4,2,4,18],[7,3,7,5],[7,7,7,10],[7,11,7,16],[7,17,7,18],[5,3,5,5],[5,7,5,10],[5,11,5,16],[5,17,5,18],[6,3,6,5],[6,7,6,10],[6,11,6,16],[6,17,6,18]]}
[]
[null,null,null,"Formulaire à completer"]
[]
[]
[null,null,"IDENTITE"]
[null,null,"Civilité","Nom-Prénoms",null,null,"Date de naissance","Adresse postale",null,null,null,"Activité professionnelle",null,null,null,null,null,"Lieu de naissance"]

{"sheet":"Contact, date de RDV, détail","index":7,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,2,10],[21,1,26,5],[28,1,28,5],[29,1,34,5],[5,1,5,5],[5,7,5,11],[6,7,34,11],[6,1,18,5],[20,1,20,5]]}
[]
[null,null,"HISTORIQUE"]
[]
[]
[]
[null,"Historique",null,null,null,null,null,"Détails sur l'opération"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Explication sur la prise de contact"]
[]
[]
[]
[]
[]
[]
[]
[null,"Date des RDV"]

{"sheet":"BDD TOTALE","index":8,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["PROVENANCE","JUSTIFICATIFS","INFORMATIONS",null,"OUI/NON"]
["France","ok","ko",null,"OUI"]
["Allemagne","ok","ko",null,"NON"]
["DESTINATION","JUSTIFICATIFS","INFORMATIONS",null,"Partiellement"]
["U.S","ok","ko"]
["EU","ok","ko"]

{"sheet":"BDD DESTINATION","index":9,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["DESTINATION","JUSTIFICATIFS A JOINDRE","INFORMATIONS DEVANT APPARAITRE SUR LE JUSTIFICATIF"]
["U.S","- Devis datés, signés avec « bon pour accord »","- Nom et prénom du client\n- Dénomination de l’entreprise prestataire\n- Montant et nature des travaux"]
["EU","- Bon de commande du véhicule\n- Copie de la carte grise et de l’annonce (dans le cas d’un véhicule d’occasion)","- Date de la commande\n- Identification du vendeur (cas d’un vendeur professionnel)\n- Identification du véhicule\n- Prix de vente du véhicule"]

{"sheet":"BDD PROVENANCE","index":10,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["PROVENANCE","JUSTIFICATIFS","INFORMATIONS",null,"nature",null,"OUI/NON",null,"OUI/NON/partiellement"]
["France","ok","ko",null,"Provenance",null,"OUI",null,"OUI"]
["Allemagne","ok","ko",null,"Destination",null,"NON",null,"NON"]
[null,null,null,null,null,null,null,null,"Partiellement"]