{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SAISIE_RECAP","Banques","FOURNISSEURS","BORDEREAU","Agents"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":8,"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":"SAISIE_RECAP","index":0,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[11]
[]
[]
[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 ","BANQUES","N° Chèque","Montant € "]
[{"$f":"ROW()","v":11},"2019-02-01","loulou","2019-02-25","fifi ",19976989824554,"B10",{"$f":"VLOOKUP(G11,FOURNISSEURS!A5:E76,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]
[{"$f":"ROW()","v":12}]
[{"$f":"ROW()","v":13}]
[{"$f":"ROW()","v":14}]
[{"$f":"ROW()","v":15}]
[{"$f":"ROW()","v":16}]
[{"$f":"ROW()","v":17}]

{"sheet":"Banques","index":1,"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"]
[]
[null,"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":"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":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[34,13,34,14],[34,15,34,16],[34,1,34,2],[34,3,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[32,13,32,14],[32,15,32,16],[33,1,33,2],[33,3,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[32,1,32,2],[32,3,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[30,13,30,14],[30,15,30,16],[31,1,31,2],[31,3,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[30,1,30,2],[30,3,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[28,13,28,14],[28,15,28,16],[29,1,29,2],[29,3,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[28,1,28,2],[28,3,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[26,13,26,14],[26,15,26,16],[27,1,27,2],[27,3,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[27,15,27,16],[26,1,26,2],[26,3,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[24,13,24,14],[24,15,24,16],[25,1,25,2],[25,3,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[24,1,24,2],[24,3,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[2,8,2,15],[22,3,22,6],[23,3,23,6],[6,4,6,7],[5,4,5,7],[6,13,6,15],[23,15,23,16],[23,11,23,12],[23,13,23,14],[3,8,3,15],[22,11,22,12],[22,13,22,14],[22,15,22,16],[22,1,22,2],[23,1,23,2],[5,1,5,3],[23,7,23,8],[23,9,23,10],[22,7,22,8],[22,9,22,10]]}
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(T4,SAISIE_RECAP!11:30,8,0)),\"erreur\")","v":"AAA001"}]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(I3,FOURNISSEURS!B5:E74,4,0)","v":"001 avenue_des_Champs_Elysées \nPARIS 75001"},null,null,null,null,null,null,null,null,null,null,{"$f":"SAISIE_RECAP!A7","v":11}]
[]
[null,"Interlocuteur :",null,null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,3,0)","v":"loulou"}]
[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-01"}]
[null,"Mail :",null,null,{"$f":"VLOOKUP(E6,Agents!A10:C30,3,0)","v":"loulou@test.fr"}]
[]
[null,"Objet: ","Bordereau d'accompagnement de(s) chèque(s)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 €"]
[null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,4,0)","v":"2019-02-25"},null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,11,0)","v":"durant-dupont dominique-michelle "},null,null,null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,6,0)","v":19976989824554},null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,15,0)","v":"Agence en ligne de BNP Paribas"},null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,14,0)","v":"durant-dupont dominique-michelle "},null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,16,0)","v":780251960},null,{"$f":"VLOOKUP(T4,SAISIE_RECAP!A11:R30,17,0)","v":99999}]

{"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"]