{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","liste","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[14,4,14,8],[15,4,15,8],[17,3,19,8],[3,6,3,8],[4,6,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[10,4,10,8],[7,3,7,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[11,4,11,8],[12,4,12,8],[13,5,13,6],[1,6,1,8],[2,6,2,8],[1,3,1,4],[2,3,2,4],[3,3,3,4]]}
[null,null,null,"Adresse de livraison",null,null," Adresse de facturation"]
[null,null,null,"Nom"]
[null,null,null,"N° client de livraison : xxx",null,null,"N° client de facturation : xxx"]
[null,null,null,"RUE  ",null,null,"RUE"]
[null,null,null,"BP ",null,null,"BP "]
[null,null,null,"Ville ",null,null,"Ville"]
[null,null,null,"Tel.: ",null,null,"Tel.: "]
[null,null,null,"Fax: ",null,null,"Fax: "]
[]
[null,null,null,"Bon de Commande"]
[null,null,null,"Fournisseur","xxx"]
[null,null,null,"N° client ",111111]
[null,null,null,"Tel. / Fax ","xxxxxxxx / xxxxxxx"]
[null,null,null,"Référence ","wwx","émise par "]
[null,null,null,"Date ","2018-03-24"]
[null,null,null,"Service(s) concerné(s) ","xxxxxxxx / xxxxxxx"]
[]
[null,null,null,"Commentaire :"]
[]
[]
[]
[]
[null,null,"nom","Ref","cdt","Tarif","qté","prix HT","Prix TTC"]
[null,null,"a","aA1","x50",10,null,0,{"$f":"H24*1.2","v":0}]
[null,null,"b","aA2","x10",2.5,null,{"$f":"G25*F25","v":0},{"$f":"H25*1.2","v":0}]
[null,null,"c","aA3","x10",4.2,null,0,0]
[null,null,"d","aA4","x1",3.4,null,0,0]
[null,null,"e","aA5","x2",2.4,null,0,0]
[null,null,"g","aA6","x3",3.2,null,0,0]
[null,null,"h","aA7","x4",1,null,{"$f":"G30*F30","v":0},0]
[null,null,"i","aA8","x5",10,null,0,0]
[null,null,"j","aA9","x6",2.5,null,0,0]
[null,null,"k","aA10","x7",4.2,null,0,0]
[null,null,"l","aA11","x8",3.4,null,0,0]
[null,null,"m","aA12","x9",2.4,null,0,0]
[null,null,"n","aA13","x10",3.2,null,0,0]
[null,null,"o","aA14","x11",2,null,0,0]
[null,null,"p","aA15","x12",4,null,0,0]
[null,null,"q","aA16","x13",4,null,0,0]
[null,null,"r","aA17","x14",4,null,0,0]
[null,null,null,null,null,null,1]
[null,null,"total ht Produit",null,null,null,1,null,{"$f":"SUM(H24:H40)","v":0}]
["Calcul des frais de port",null,"TVA 20%",null,null,null,1,null,{"$f":"I42*0.2","v":0}]
[null,null,"frais de port",null,null,null,1,null,{"$f":"IF(I42>=A47,B47,IF(I42>=A46,B46,IF(I42>=A45,B45)))","v":69}]
[0,69,"TVA frais de port",null,null,null,1,null,{"$f":"I44*1.2","v":82.8}]
[100,30,"TVA totale",null,null,null,1,null,{"$f":"I45+I43","v":82.8}]
[200,0,"Total TTC",null,null,null,1,null,{"$f":"I42+I46","v":82.8}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,1]

{"sheet":"liste","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Demandeur"]
["Pierre"]
["Paul "]
["Jacques"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}