{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Banques","SAISIE_RECAP","FOURNISSEURS","BORDEREAU","Agents"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Banques","index":0,"n_rows":75,"n_cols":2,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["https://www.droit-compte.com/liste-des-banques-francaises.html","Mise a jour le 30/01/2019"]
[]
["Colonne1","Nom des Banques"]
["Banques en ligne","Agence en ligne de BNP Paribas"]
["Banques de réseau en France","Allianz Banque"]
["Banques privées","Allianz Gestion Privée (Allianz)"]
["Banques de réseau en France","AXA Banque"]
["Banques privées","Axa Wealth Management (AXA)"]
["Banques de réseau en France","Banque Casino"]
["Banques de réseau en France","Banque de Savoie"]
["Banques privées","Banque Delubac & Compagnie"]
["Banques de réseau en France","Banque des Antilles françaises (BDAF)"]
["Banques privées","Banque d'Orsay (Oddo et Cie)"]
["Banques de réseau en France","Banque Fédérale Mutualiste"]
["Banques privées","Banque Hottinguer"]
["Banques privées","Banque Lazard"]
["Banques privées","Banque Martin Maurel"]
["Banques privées","Banque Neuflize OBC (ABN AMRO)"]
["Banques privées","Banque Palatine (BPCE)"]
["Banques privées","Banque Privée 1818 (BPCE)"]
["Banques privées","Banque Transatlantique (Groupe Crédit Mutuel - CM11)"]
["Banques privées","Banque Wormser Frères"]
["Banques de réseau en France","Barclays"]
["Banques privées","Barclays"]
["Banques en ligne","BForBank"]
["Banques privées","BforBank (Crédit agricole)"]
["Banques de réseau en France","BNP Paribas"]
["Banques privées","BNP Paribas Banque Privée (BNP Paribas)"]
["Banques en ligne","Boursorama Banque"]
["Banques privées","BPE (groupe la Banque Postale)"]
["Banques de réseau en France","BRED (Banque populaire)"]
["Banques privées","Bred Banque Privée (BPCE)"]
["Banques de réseau en France","Caisse d'Epargne"]
["Banques de réseau en France","Cetelem"]
["Banques de réseau en France","CIC"]
["Banques privées","CIC Banque Privée"]
["Banques en ligne","Cortal Consors"]
["Banques de réseau en France","Crédit agricole"]
["Banques privées","Crédit Agricole Banque Privée (Crédit agricole)"]
["Banques de réseau en France","Crédit coopératif"]
["Banques de réseau en France","Crédit du nord"]
["Banques privées","Crédit du Nord Banque Privée"]
["Banques de réseau en France","Crédit Foncier"]
["Banques de réseau en France","Crédit mutuel"]
["Banques en ligne","e.LCL"]
["Banques privées","Edmond de Rothschild"]
["Banques privées","EFG Banque Privée"]
["Banques de réseau en France","Fortis Banque"]
["Banques en ligne","Fortuneo"]
["Banques de réseau en France","Groupama Banque"]
["Banques privées","Groupama Banque Privée"]
["Banques en ligne","Hello bank!"]
["Banques de réseau en France","HSBC"]
["Banques privées","HSBC Private Bank"]
["Banques privées","Indosuez Wealth Management (Crédit Agricole)"]
["Banques en ligne","ING Direct"]
["Banques privées","KBL Richelieu (KBL epb)"]
["Banques de réseau en France","La Banque Postale"]
["Banques privées","La Banque postale Gestion Privée"]
["Banques de réseau en France","La Nef (coopérative financière)"]
["Banques en ligne","L'agence directe"]
["Banques de réseau en France","LCL"]
["Banques privées","LCL Banque Privée (Crédit agricole)"]
["Banques privées","Meeschaert Gestion Privée"]
["Banques en ligne","MonaBanq"]
["Banques privées","Oddo et Cie"]
["Banques de réseau en France","Oney"]
["Banques en ligne","PSA Banque"]
["Banques privées","Quilvest"]
["Banques de réseau en France","RCI Banque"]
["Banques de réseau en France","Société Générale"]
["Banques privées","Société Générale Private Banking"]
["Banques privées","Swisslife Banque Privée"]
["Banques privées","UBS"]
["Banques de réseau en France","VTB Bank"]

{"sheet":"SAISIE_RECAP","index":1,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Date traitement\nenregistrer\nenvoyer","Nom Agent responsable ","Date\nintervention\nTIP ","Nom Agent Intervention ","N°client","ID fournisseurs","FOURNISSEURS","Nom client (contrat) ","Prénom client (contrat) ","Nom prénom (contra) concatener ","Nom Emetteur du chèque","Prénom Emetteur du chèque ","Nom prénom (contra) concatener 2","BANQUES","N° Chèque","Montant € "]
[null,"2019-02-01","loulou","2019-02-25","fifi ",19976989824554,"B10",{"$f":"VLOOKUP(G11,FOURNISSEURS!$A$5:$E$76,2,0)","v":"AAA001"},"durant-dupont","dominique-michelle ",{"$f":"CONCATENATE(I11,\" \",J11)","v":"durant-dupont dominique-michelle "},"durant-dupont","dominique-michelle ",{"$f":"CONCATENATE(L11,\" \",M11)","v":"durant-dupont dominique-michelle "},"Agence en ligne de BNP Paribas",780251960,99999]

{"sheet":"FOURNISSEURS","index":2,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["ID fournisseur","FOURNISSEURS NOM ","Adresse envoi des chèques","ville","adresse complette "]
["B10","AAA001","001 avenue_des_Champs_Elysées \n","PARIS 75001",{"$f":"CONCATENATE(C5,\"\",D5)","v":"001 avenue_des_Champs_Elysées \nPARIS 75001"}]
["B11","AAA002","2 avenue_des_Champs_Elysées \n","PARIS 75002",{"$f":"CONCATENATE(C6,\"\",D6)","v":"2 avenue_des_Champs_Elysées \nPARIS 75002"}]
["B12","AAA003","3 avenue_des_Champs_Elysées \n","PARIS 75003","3 avenue_des_Champs_Elysées \nPARIS 75003"]
["B13","AAA004","4 avenue_des_Champs_Elysées \n","PARIS 75004","4 avenue_des_Champs_Elysées \nPARIS 75004"]
["B14","AAA005","5 avenue_des_Champs_Elysées \n","PARIS 75005","5 avenue_des_Champs_Elysées \nPARIS 75005"]
["B15","AAA006","6 avenue_des_Champs_Elysées \n","PARIS 75006","6 avenue_des_Champs_Elysées \nPARIS 75006"]
["B16","AAA007","7 avenue_des_Champs_Elysées \n","PARIS 75007","7 avenue_des_Champs_Elysées \nPARIS 75007"]
["B17","AAA008","8 avenue_des_Champs_Elysées \n","PARIS 75008","8 avenue_des_Champs_Elysées \nPARIS 75008"]
["B18","AAA009","9 avenue_des_Champs_Elysées \n","PARIS 75009","9 avenue_des_Champs_Elysées \nPARIS 75009"]
["B19","AAA010","10 avenue_des_Champs_Elysées \n","PARIS 75010","10 avenue_des_Champs_Elysées \nPARIS 75010"]
["B20","AAA011","11 avenue_des_Champs_Elysées \n","PARIS 75011","11 avenue_des_Champs_Elysées \nPARIS 75011"]
["B21","AAA012","12 avenue_des_Champs_Elysées \n","PARIS 75012","12 avenue_des_Champs_Elysées \nPARIS 75012"]
["B22","AAA013","13 avenue_des_Champs_Elysées \n","PARIS 75013","13 avenue_des_Champs_Elysées \nPARIS 75013"]
["B23","AAA014","14 avenue_des_Champs_Elysées \n","PARIS 75014","14 avenue_des_Champs_Elysées \nPARIS 75014"]
["B24","AAA015","15 avenue_des_Champs_Elysées \n","PARIS 75015","15 avenue_des_Champs_Elysées \nPARIS 75015"]
["B25","AAA016","16 avenue_des_Champs_Elysées \n","PARIS 75016","16 avenue_des_Champs_Elysées \nPARIS 75016"]
["B26","AAA017","17 avenue_des_Champs_Elysées \n","PARIS 75017","17 avenue_des_Champs_Elysées \nPARIS 75017"]
["B27","AAA018","18 avenue_des_Champs_Elysées \n","PARIS 75018","18 avenue_des_Champs_Elysées \nPARIS 75018"]
["B28","AAA019","19 avenue_des_Champs_Elysées \n","PARIS 75019","19 avenue_des_Champs_Elysées \nPARIS 75019"]
["B29","AAA020","20 avenue_des_Champs_Elysées \n","PARIS 75020","20 avenue_des_Champs_Elysées \nPARIS 75020"]
["B30","AAA021","21 avenue_des_Champs_Elysées \n","PARIS 75021","21 avenue_des_Champs_Elysées \nPARIS 75021"]
["B31","AAA022","22 avenue_des_Champs_Elysées \n","PARIS 75022","22 avenue_des_Champs_Elysées \nPARIS 75022"]
["B32","AAA023","23 avenue_des_Champs_Elysées \n","PARIS 75023","23 avenue_des_Champs_Elysées \nPARIS 75023"]
["B33","AAA024","24 avenue_des_Champs_Elysées \n","PARIS 75024","24 avenue_des_Champs_Elysées \nPARIS 75024"]
["B34","AAA025","25 avenue_des_Champs_Elysées \n","PARIS 75025","25 avenue_des_Champs_Elysées \nPARIS 75025"]
["B35","AAA026","26 avenue_des_Champs_Elysées \n","PARIS 75026","26 avenue_des_Champs_Elysées \nPARIS 75026"]
["B36","AAA027","27 avenue_des_Champs_Elysées \n","PARIS 75027","27 avenue_des_Champs_Elysées \nPARIS 75027"]
["B37","AAA028","28 avenue_des_Champs_Elysées \n","PARIS 75028","28 avenue_des_Champs_Elysées \nPARIS 75028"]
["B38","AAA029","29 avenue_des_Champs_Elysées \n","PARIS 75029","29 avenue_des_Champs_Elysées \nPARIS 75029"]
["B39","AAA030","30 avenue_des_Champs_Elysées \n","PARIS 75030","30 avenue_des_Champs_Elysées \nPARIS 75030"]
["B40","AAA031","31 avenue_des_Champs_Elysées \n","PARIS 75031","31 avenue_des_Champs_Elysées \nPARIS 75031"]
["B41","AAA032","32 avenue_des_Champs_Elysées \n","PARIS 75032","32 avenue_des_Champs_Elysées \nPARIS 75032"]
["B42","AAA033","33 avenue_des_Champs_Elysées \n","PARIS 75033","33 avenue_des_Champs_Elysées \nPARIS 75033"]
["B43","AAA034","34 avenue_des_Champs_Elysées \n","PARIS 75034","34 avenue_des_Champs_Elysées \nPARIS 75034"]
["B44","AAA035","35 avenue_des_Champs_Elysées \n","PARIS 75035","35 avenue_des_Champs_Elysées \nPARIS 75035"]
["B45","AAA036","36 avenue_des_Champs_Elysées \n","PARIS 75036","36 avenue_des_Champs_Elysées \nPARIS 75036"]
["B46","AAA037","37 avenue_des_Champs_Elysées \n","PARIS 75037","37 avenue_des_Champs_Elysées \nPARIS 75037"]
["B47","AAA038","38 avenue_des_Champs_Elysées \n","PARIS 75038","38 avenue_des_Champs_Elysées \nPARIS 75038"]
["B48","AAA039","39 avenue_des_Champs_Elysées \n","PARIS 75039","39 avenue_des_Champs_Elysées \nPARIS 75039"]
["B49","AAA040","40 avenue_des_Champs_Elysées \n","PARIS 75040","40 avenue_des_Champs_Elysées \nPARIS 75040"]
["B50","AAA041","41 avenue_des_Champs_Elysées \n","PARIS 75041","41 avenue_des_Champs_Elysées \nPARIS 75041"]
["B51","AAA042","42 avenue_des_Champs_Elysées \n","PARIS 75042","42 avenue_des_Champs_Elysées \nPARIS 75042"]
["B52","AAA043","43 avenue_des_Champs_Elysées \n","PARIS 75043","43 avenue_des_Champs_Elysées \nPARIS 75043"]
["B53","AAA044","44 avenue_des_Champs_Elysées \n","PARIS 75044","44 avenue_des_Champs_Elysées \nPARIS 75044"]
["B54","AAA045","45 avenue_des_Champs_Elysées \n","PARIS 75045","45 avenue_des_Champs_Elysées \nPARIS 75045"]
["B55","AAA046","46 avenue_des_Champs_Elysées \n","PARIS 75046","46 avenue_des_Champs_Elysées \nPARIS 75046"]
["B56","AAA047","47 avenue_des_Champs_Elysées \n","PARIS 75047","47 avenue_des_Champs_Elysées \nPARIS 75047"]
["B57","AAA048","48 avenue_des_Champs_Elysées \n","PARIS 75048","48 avenue_des_Champs_Elysées \nPARIS 75048"]
["B58","AAA049","49 avenue_des_Champs_Elysées \n","PARIS 75049","49 avenue_des_Champs_Elysées \nPARIS 75049"]
["B59","AAA050","50 avenue_des_Champs_Elysées \n","PARIS 75050","50 avenue_des_Champs_Elysées \nPARIS 75050"]
["B60","AAA051","51 avenue_des_Champs_Elysées \n","PARIS 75051","51 avenue_des_Champs_Elysées \nPARIS 75051"]
["B61","AAA052","52 avenue_des_Champs_Elysées \n","PARIS 75052","52 avenue_des_Champs_Elysées \nPARIS 75052"]
["B62","AAA053","53 avenue_des_Champs_Elysées \n","PARIS 75053","53 avenue_des_Champs_Elysées \nPARIS 75053"]
["B63","AAA054","54 avenue_des_Champs_Elysées \n","PARIS 75054","54 avenue_des_Champs_Elysées \nPARIS 75054"]
["B64","AAA055","55 avenue_des_Champs_Elysées \n","PARIS 75055","55 avenue_des_Champs_Elysées \nPARIS 75055"]
["B65","AAA056","56 avenue_des_Champs_Elysées \n","PARIS 75056","56 avenue_des_Champs_Elysées \nPARIS 75056"]
["B66","AAA057","57 avenue_des_Champs_Elysées \n","PARIS 75057","57 avenue_des_Champs_Elysées \nPARIS 75057"]
["B67","AAA058","58 avenue_des_Champs_Elysées \n","PARIS 75058","58 avenue_des_Champs_Elysées \nPARIS 75058"]
["B68","AAA059","59 avenue_des_Champs_Elysées \n","PARIS 75059","59 avenue_des_Champs_Elysées \nPARIS 75059"]
["B69","AAA060","60 avenue_des_Champs_Elysées \n","PARIS 75060","60 avenue_des_Champs_Elysées \nPARIS 75060"]
["B70","AAA061","61 avenue_des_Champs_Elysées \n","PARIS 75061","61 avenue_des_Champs_Elysées \nPARIS 75061"]
["B71","AAA062","62 avenue_des_Champs_Elysées \n","PARIS 75062","62 avenue_des_Champs_Elysées \nPARIS 75062"]
["B72","AAA063","63 avenue_des_Champs_Elysées \n","PARIS 75063","63 avenue_des_Champs_Elysées \nPARIS 75063"]
["B73","AAA064","Non communiquée","PARIS 75064","Non communiquéePARIS 75064"]
["B74","AAA065","Non communiquée","PARIS 75065","Non communiquéePARIS 75065"]
["B75","AAA066","Non communiquée","PARIS 75066",{"$f":"CONCATENATE(C70,\"\",D70)","v":"Non communiquéePARIS 75066"}]
["B76","AAA067","Non communiquée","PARIS 75067","Non communiquéePARIS 75067"]
["B77","AAA068","Non communiquée","PARIS 75068","Non communiquéePARIS 75068"]
["B78","AAA069","Non communiquée","PARIS 75069","Non communiquéePARIS 75069"]
["B79","AAA070","Non communiquée","PARIS 75070","Non communiquéePARIS 75070"]

{"sheet":"BORDEREAU","index":3,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,5,3],[21,7,21,8],[21,9,21,10],[20,7,20,8],[20,9,20,10],[7,4,7,7],[18,1,18,5],[18,6,18,7],[18,10,18,12],[18,8,18,9],[2,8,2,15],[20,3,20,6],[21,3,21,6],[6,4,6,7],[5,4,5,7],[6,13,6,15],[21,15,21,16],[21,11,21,12],[21,13,21,14],[3,8,3,15],[20,11,20,12],[20,13,20,14],[20,15,20,16],[11,1,16,16],[20,1,20,2],[21,1,21,2]]}
[]
[]
[null,null,null,null,null,null,null,null,"AAA070"]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(I3,FOURNISSEURS!B5:E74,4,0)","v":"Non communiquéePARIS 75070"}]
[]
[null,"Interlocuteur :",null,null,"fifi "]
[null,"Tél. :",null,null,{"$f":"VLOOKUP(E6,Agents!A11:C30,2,0)","v":474747474},null,null,null,null,null,null,null,"Le, ",{"$f":"TODAY()","v":"2019-02-04"}]
[null,"Mail :",null,null,{"$f":"VLOOKUP(E6,Agents!A10:C30,3,0)","v":"fifi @test.fr"}]
[]
[null,"Objet: ","Bordereau d'accompagnement de(s) chèque(s)"]
[]
[null,"Madame, Monsieur,\n\nVeuillez trouver ci-joint suivant la liste susvisée le(s) Chèque(s) remis à nos agents pour votre compte de fournisseur. \n\nJe vous prie de croire, Madame, Monsieur, en l'expression de nos salutations distinguées."]
[]
[]
[]
[]
[]
[]
[null,"Chèques du :",null,null,null,null,null,null,"au :"]
[]
[null,"Date de l'interv. technique.",null,"Nom Prénom du client ",null,null,null,"N° client",null,"Banque",null,"Nom Prénom  du Chéque",null,"n° du chèque",null,"montant €"]

{"sheet":"Agents","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Agent Prénom Nom ","Tel ","Mail "]
["loulou",474747474,{"$f":"CONCATENATE(A11,\"@test.fr\")","v":"loulou@test.fr"}]
["fifi ",474747474,{"$f":"CONCATENATE(A12,\"@test.fr\")","v":"fifi @test.fr"}]
["riri ",474747474,"riri @test.fr"]
["tintin ",474747474,"tintin @test.fr"]