{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dégustation Cadeau Casse Perso","Action vierge","Action 1","tarifs suite à PQY","Tarif de base","formulaire"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"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":"Dégustation Cadeau Casse Perso","index":0,"n_rows":875,"n_cols":11,"rows_kept":875,"cut":false,"hidden":false,"merged":[[2,2,2,7]]}
[]
[]
[null,null,"Information Stock"]
[]
[]
[null,null,"Date","Mois","Action","Client","Désignation","Quantité"]
[null,null,"2018-10-01",{"$f":"IF(C7<>\"\",TEXT(C7,\"mmmm\"),\"\")","v":"octobre"}]
[null,null,"2018-11-01","novembre"]
[null,null,"2018-12-15","décembre",null,null,null,null,"X"]
[null,null,null,""]
[null,null,null,"",null,null,null,null,null,null,"Créer un bouton au bout de chaque ligne pour :  oter la protection / deverouiller la ligne / proteger la feuille"]
[null,null,null,"",null,null,null,null,null,null,"Créer des onglets en automatiques"]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C71<>\"\",TEXT(C71,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C135<>\"\",TEXT(C135,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C199<>\"\",TEXT(C199,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C263<>\"\",TEXT(C263,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C327<>\"\",TEXT(C327,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C391<>\"\",TEXT(C391,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C455<>\"\",TEXT(C455,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C519<>\"\",TEXT(C519,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C583<>\"\",TEXT(C583,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C647<>\"\",TEXT(C647,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C711<>\"\",TEXT(C711,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C775<>\"\",TEXT(C775,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,{"$f":"IF(C839<>\"\",TEXT(C839,\"mmmm\"),\"\")","v":""}]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"Action vierge","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,3,30,9],[16,3,16,4],[18,3,18,4],[21,8,21,9],[25,5,25,6],[25,7,25,8],[27,5,27,6],[27,7,27,9],[1,2,1,11],[3,7,3,9],[8,3,8,4],[10,3,10,4],[12,3,12,4],[14,3,14,4]]}
[]
[null,null,"Formulaire gestion des stocks"]
[]
[null,null,"Date  :",null,null,null,"Client :"]
[]
[null,null,"Action :"]
[]
[]
[null,null,"Désignation 1  :",null,null,null,"Quantité 1 :",null,null,"Total 1  :",{"$f":"IF(D9<>\"\",VLOOKUP(D9,'tarifs suite à PQY'!A:B,2,FALSE)*H9,\"\")","v":""}]
[]
[null,null,"Désignation 2  :",null,null,null,"Quantité 2 :",null,null,"Total 2  :",{"$f":"IF(D11<>\"\",VLOOKUP(D11,'tarifs suite à PQY'!A:B,2,FALSE)*H11,\"\")","v":""}]
[]
[null,null,"Désignation 3  :",null,null,null,"Quantité 3 :",null,null,"Total 3  :",{"$f":"IF(D13<>\"\",VLOOKUP(D13,'tarifs suite à PQY'!A:B,2,FALSE)*H13,\"\")","v":""}]
[]
[null,null,"Désignation 4  :",null,null,null,"Quantité 4 :",null,null,"Total 4  :",{"$f":"IF(D15<>\"\",VLOOKUP(D15,'tarifs suite à PQY'!A:B,2,FALSE)*H15,\"\")","v":""}]
[]
[null,null,"Désignation 5  :",null,null,null,"Quantité 5 :",null,null,"Total 5  :",{"$f":"IF(D17<>\"\",VLOOKUP(D17,'tarifs suite à PQY'!A:B,2,FALSE)*H17,\"\")","v":""}]
[]
[null,null,"Désignation 6  :",null,null,null,"Quantité 6 :",null,null,"Total 6  :",{"$f":"IF(D19<>\"\",VLOOKUP(D19,'tarifs suite à PQY'!A:B,2,FALSE)*H19,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,"Total dû :",null,{"$f":"SUM(K9:K19)","v":0}]
[]
[]
[]
[null,null,"Règlement CB  :",null,null,"Règlement espèces  :"]
[]
[null,null,"Règlement chèque :",null,null,"Vérification règlement : ",null,{"$f":"IF(K22>0,IF(K22-H26-D26-D28=0,\"Le règlement est OK\",\" Il manque  \"&K22-H26-D26-D28&\"  €\"),\"\")","v":""}]
[]
[null,null,"Observations  : "]

{"sheet":"Action 1","index":2,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,3,30,9],[27,5,27,6],[27,7,27,9],[1,2,1,11],[3,7,3,9],[8,3,8,4],[10,3,10,4],[12,3,12,4],[14,3,14,4],[16,3,16,4],[18,3,18,4],[21,8,21,9],[25,5,25,6],[25,7,25,8]]}
[]
[null,null,"Formulaire gestion des stocks"]
[]
[null,null,"Date  :","2018-10-17",null,null,"Client :","test1"]
[]
[null,null,"Action :","Vente"]
[]
[]
[null,null,"Désignation 1  :","A.O.C. Côtes de Bourg Rouge 1995 à 25 € ",null,null,"Quantité 1 :",6,null,"Total 1  :",{"$f":"IF(D9<>\"\",VLOOKUP(D9,'tarifs suite à PQY'!A:B,2,FALSE)*H9,\"\")","v":150}]
[]
[null,null,"Désignation 2  :","A.O.C. Côtes de Bourg Rouge 2007 à 5 € ",null,null,"Quantité 2 :",1,null,"Total 2  :",{"$f":"IF(D11<>\"\",VLOOKUP(D11,'tarifs suite à PQY'!A:B,2,FALSE)*H11,\"\")","v":5}]
[]
[null,null,"Désignation 3  :","Bordeaux Blanc 2015 à 4 € ",null,null,"Quantité 3 :",2,null,"Total 3  :",{"$f":"IF(D13<>\"\",VLOOKUP(D13,'tarifs suite à PQY'!A:B,2,FALSE)*H13,\"\")","v":8}]
[]
[null,null,"Désignation 4  :","Bordeaux Blanc 2016 à 4 € ",null,null,"Quantité 4 :",3,null,"Total 4  :",{"$f":"IF(D15<>\"\",VLOOKUP(D15,'tarifs suite à PQY'!A:B,2,FALSE)*H15,\"\")","v":12}]
[]
[null,null,"Désignation 5  :","Bordeaux Rosé 2015 à 5 € ",null,null,"Quantité 5 :",4,null,"Total 5  :",{"$f":"IF(D17<>\"\",VLOOKUP(D17,'tarifs suite à PQY'!A:B,2,FALSE)*H17,\"\")","v":20}]
[]
[null,null,"Désignation 6  :","A.O.C. Côtes de Bourg Rouge 2007 à 5 € ",null,null,"Quantité 6 :",5,null,"Total 6  :",{"$f":"IF(D19<>\"\",VLOOKUP(D19,'tarifs suite à PQY'!A:B,2,FALSE)*H19,\"\")","v":25}]
[]
[]
[null,null,null,null,null,null,null,null,"Total dû :",null,{"$f":"SUM(K9:K19)","v":220}]
[]
[]
[]
[null,null,"Règlement CB  :",200,null,"Règlement espèces  :",null,20]
[]
[null,null,"Règlement chèque :",3,null,"Vérification règlement : ",null,{"$f":"IF(K22>0,IF(K22-H26-D26-D28=0,\"Le règlement est OK\",\" Il manque  \"&K22-H26-D26-D28&\"  €\"),\"\")","v":" Il manque  -3  €"}]
[]
[null,null,"Observations  : ","test 1"]

{"sheet":"tarifs suite à PQY","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Tarifs","Colonne1"]
["A.O.C  Côtes de Bourg Rouge 2014 à 7 € ",7]
["A.O.C. Côtes de Bourg Rouge 1995 à 25 € ",25]
["A.O.C. Côtes de Bourg Rouge 2007 à 5 € ",5]
["A.O.C. Côtes de Bourg Rouge 2012 à 7 € ",7]
["Bag in Box Bordeaux 5L  Rouge 2016  à 20 € ",20]
["Bordeaux Blanc 2015 à 4 € ",4]
["Bordeaux Blanc 2016 à 4 € ",4]
["Bordeaux Rosé 2015 à 5 € ",5]
["Bordeaux Rosé 2017 à 5 € ",5]
["Clos Maine Gravereau Rouge 2014 à 4 € ",4]
["Rouge  2003(Fût de Chêne) à 6 € ",6]
["Rouge  2005 à 5 € ",5]
["Rouge  2005(Fût de Chêne) à 6 € ",6]

{"sheet":"Tarif de base","index":4,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Tarif de base",null,null,"Désignation avec tarif"]
[]
["Produit","Tarif",null,"Tarifs","Colonne1"]
["A.O.C. Côtes de Bourg Rouge 1995",25,null,{"$f":"A4&\" à \"&B4&\" € \"","v":"A.O.C. Côtes de Bourg Rouge 1995 à 25 € "},{"$f":"Tarif[[#This Row],[Tarif]]","v":25}]
["Rouge  2003(Fût de Chêne)",6,null,"Rouge  2003(Fût de Chêne) à 6 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":6}]
["Rouge  2005",5,null,"Rouge  2005 à 5 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":5}]
["Rouge 2005(Fût de Chêne)",6,null,"Rouge 2005(Fût de Chêne) à 6 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":6}]
["A.O.C. Côtes de Bourg Rouge 2007",5,null,"A.O.C. Côtes de Bourg Rouge 2007 à 5 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":5}]
["A.O.C. Côtes de Bourg Rouge 2012",7,null,"A.O.C. Côtes de Bourg Rouge 2012 à 7 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":7}]
["A.O.C  Côtes de Bourg Rouge 2014",7,null,"A.O.C  Côtes de Bourg Rouge 2014 à 7 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":7}]
["Bordeaux Blanc 2015",4,null,"Bordeaux Blanc 2015 à 4 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":4}]
["Bordeaux Blanc 2016",4,null,"Bordeaux Blanc 2016 à 4 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":4}]
["Bordeaux Rosé 2015",5,null,"Bordeaux Rosé 2015 à 5 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":5}]
["Bordeaux Rosé 2017",5,null,"Bordeaux Rosé 2017 à 5 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":5}]
["Clos Maine Gravereau Rouge 2014",4,null,"Clos Maine Gravereau Rouge 2014 à 4 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":4}]
["Bag in Box Bordeaux 5L  Rouge 2016 ",20,null,"Bag in Box Bordeaux 5L  Rouge 2016  à 20 € ",{"$f":"Tarif[[#This Row],[Tarif]]","v":20}]

{"sheet":"formulaire","index":5,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Action"]
[]
["Dégustation"]
["Cadeau"]
["Vente"]
["Casse"]
["Vol"]