{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","Type livraison","Produits","Clients"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Feuil1","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[16,2,16,4],[48,8,48,9],[10,2,10,4],[14,2,14,4],[21,2,21,4],[14,7,14,9],[16,7,16,9],[18,7,18,9],[20,7,20,9],[21,7,21,9],[22,7,22,9],[20,2,20,4],[18,2,18,4],[19,2,19,4],[17,7,17,9],[19,7,19,9],[22,2,22,4],[35,2,35,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[34,2,34,6],[50,2,50,4],[36,2,36,6],[37,2,37,6],[38,2,38,6],[47,2,47,4],[48,2,48,4],[49,2,49,4],[42,2,42,4]]}
[]
[]
[]
[]
[null,"Formulaire de commande"]
[]
[null,null,null,null,null,null,"115-117 rue de Genève",null,"+41 (0) 76 61 64 111"]
[null,null,null,null,null,null,"1226 Thônex",null,"+41 (0) 22 738 25 73"]
[]
[]
[null,"Date de commande",{"$f":"TODAY()","v":"2016-10-19"},null,null,null,"Date de livraison :",null," Heure de livraison :"]
[]
[null,"Commandé par ",null,"n° client",0,null,"Adresse de livraison","      Idem",1,{"$f":"VLOOKUP(I13,'Type livraison'!B4:D7,2,FALSE)","v":"Sur place"}]
[]
[null,"Société :",{"$f":"VLOOKUP(E13,Clients!A4:M15,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Société :",{"$f":"VLOOKUP(E13,Clients!A4:M15,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"Adresse  :",{"$f":"VLOOKUP(E13,Clients!A4:M15,5,FALSE)","v":{"$error":"#N/A"}},"N° rue :  ",{"$f":"VLOOKUP(E13,Clients!A4:M15,6,FALSE)","v":{"$error":"#N/A"}},null,"Adresse  :",{"$f":"VLOOKUP(E13,Clients!A4:M15,5,FALSE)","v":{"$error":"#N/A"}},"N° rue :  ",{"$f":"VLOOKUP(E13,Clients!A4:M15,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"Complément Adresse  :",{"$f":"VLOOKUP(E13,Clients!A4:M15,7,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Code Postal  :",{"$f":"VLOOKUP(E13,Clients!A4:M15,7,FALSE)","v":{"$error":"#N/A"}}]
[null,"Code Postal  :",{"$f":"VLOOKUP(E13,Clients!A4:M16,8,FALSE)","v":{"$error":"#N/A"}},"Ville",{"$f":"VLOOKUP(E13,Clients!A4:M15,9,FALSE)","v":{"$error":"#N/A"}},null,"Ville",{"$f":"VLOOKUP(E13,Clients!A4:M15,8,FALSE)","v":{"$error":"#N/A"}}]
[null,"État / Province  :",{"$f":"VLOOKUP(E13,Clients!A4:M15,9,FALSE)","v":{"$error":"#N/A"}},null,null,null,"État / Province  :",{"$f":"VLOOKUP(E13,Clients!A4:M15,9,FALSE)","v":{"$error":"#N/A"}}]
[null,"Pays :",{"$f":"VLOOKUP(E13,Clients!A4:M15,10,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Pays :",{"$f":"VLOOKUP(E13,Clients!A4:M15,10,FALSE)","v":{"$error":"#N/A"}}]
[null,"Téléphone : ",{"$f":"VLOOKUP(E13,Clients!A4:M15,11,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Téléphone : ",{"$f":"VLOOKUP(E13,Clients!A4:M15,11,FALSE)","v":{"$error":"#N/A"}}]
[null,"E-mail :",{"$f":"VLOOKUP(E13,Clients!A4:M15,13,FALSE)","v":{"$error":"#N/A"}},null,null,null,"E-mail :",{"$f":"VLOOKUP(E13,Clients!A4:M15,13,FALSE)","v":{"$error":"#N/A"}}]
[null,"Nom du contact :",{"$f":"VLOOKUP(E13,Clients!A4:M15,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Nom du contact :",{"$f":"VLOOKUP(E13,Clients!A4:M15,4,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"N°Article","Description",null,null,null,null,"Quantité","Prix Unitaire","Montant"]
[null,4,{"$f":"VLOOKUP(B27,Produits!A5:C16,2,FALSE)","v":"Sandwitch"},null,null,null,null,5,{"$f":"VLOOKUP(B27,Produits!A5:C16,3,FALSE)","v":5},{"$f":"H27*I27","v":25}]
[null,1,{"$f":"VLOOKUP(B28,Produits!A5:C16,2,FALSE)","v":"Tartare"},null,null,null,null,3,{"$f":"VLOOKUP(B28,Produits!A5:C16,3,FALSE)","v":15},{"$f":"H28*I28","v":45}]
[null,3,{"$f":"VLOOKUP(B29,Produits!A5:C16,2,FALSE)","v":"Hamburger"},null,null,null,null,1,{"$f":"VLOOKUP(B29,Produits!A5:C16,3,FALSE)","v":8},{"$f":"H29*I29","v":8}]
[null,null,{"$f":"VLOOKUP(B30,Produits!A5:C16,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B30,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B31,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B31,Produits!A5:C16,3,FALSE)","v":0},{"$f":"H31*I31","v":0}]
[null,null,{"$f":"VLOOKUP(B32,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B32,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B33,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B33,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B34,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B34,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B35,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B35,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B36,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B36,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B37,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B37,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B38,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B38,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,{"$f":"VLOOKUP(B39,Produits!A5:C17,2,FALSE)","v":0},null,null,null,null,null,{"$f":"VLOOKUP(B39,Produits!A5:C16,3,FALSE)","v":0},0]
[null,null,null,null,null,null,null,null,"Sous-total",{"$f":"J27+J28+J29+J30+J31","v":78}]
[null,null,null,null,null,null,null,null,"TVA      8%",{"$f":"J40*0.08","v":6.24}]
[null,"Règlement  Comptant",null,null,null,null,null,null,"Frais de livraison",{"$f":"VLOOKUP(I13,'Type livraison'!B4:D6,3,FALSE)","v":0}]
[null,"Transfert bancaire          Crédit Suisse - Genève","IBAN :                                                  ",null,null,"Swift/Bic :",null,null,"Total global",{"$f":"J40+J41+J42","v":84.24}]
[null,"Carte de crédit"]
[null,"       American Express"]
[null,"       Master Card"]
[null,"       Visa"]
[null,"Numéro de carte :"]
[null,"Date d'expiration :",null,null,null,null,null,null,"Usage interne uniquement"]
[null,"Code de sécurité :"]
[null,"Nom du titulaire :",null,null,null,null,null,null,"Commande terminée :"]
[null,null,null,null,null,null,null,null,"Date     d'expédition :"]
[null,null,"Les données ne sont pas sécurisées"]

{"sheet":"Type livraison","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Choix","Livraison","Prix"]
[null,1,"Sur place",0]
[null,2,"A l'emporter",30]
[null,3,"Hors Genève",50]
[null,4,"Livraison France","A convenir"]

{"sheet":"Produits","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["Offre commercial"]
[]
["N°Article","Description","Prix Unitaire"]
[0,null,0]
[1,"Tartare",15]
[2,"Vin Rouge",8]
[3,"Hamburger",8]
[4,"Sandwitch",5]
[5,"Salade",3]
[6,"Pain",3]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Clients","index":3,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Clients"]
[]
["Numéro client","Société","Civilité","Prénom ","Adresse","N° rue","Complément d'adresse","Code Postal","Ville","État / Province","Pays","Téléphone","Email"]
[1,"Copy Services","Mr","Renato  Martori"," rue de Genève","115-117","Aucun",1226,"Thônex","Genève","Suisse",227382570,"info@copy-services.com"]
[2,"ASC Event","Mme","Margalith Chocron"," rue de Genève","115-117","Aucun",1226,"Thônex","Genève","Suisse",227382573,"info@asc-event.com"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]