{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EDIT","BDD"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"EDIT","index":0,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["PRODUIT","QUANTITE","CARTON","DERNIER CARTON","PALETTE COMPLETE","CARTON RESTANT"]
["Produit 1",1600,{"$f":"ROUNDUP(B2/QC_1,0)","v":100},{"$f":"IF(B2=\"\",\"\",IF(MOD(B2,QC_1)=0,\"cartons complets\",MOD(B2,QC_1)))","v":"cartons complets"},{"$f":"INT(C2/QP_1)","v":2},{"$f":"C2-E2*QP_1","v":20}]
["Produit 2",2200,{"$f":"ROUNDUP(B3/QC_1,0)","v":138},{"$f":"IF(B3=\"\",\"\",IF(MOD(B3,QC_1)=0,\"cartons complets\",MOD(B3,QC_1)))","v":8},{"$f":"INT(C3/QP_1)","v":3},{"$f":"C3-E3*QP_1","v":18}]
["Produit 3",120,{"$f":"ROUNDUP(B4/QC_1,0)","v":8},{"$f":"IF(B4=\"\",\"\",IF(MOD(B4,QC_1)=0,\"cartons complets\",MOD(B4,QC_1)))","v":8},{"$f":"INT(C4/QP_1)","v":0},{"$f":"C4-E4*QP_1","v":8}]
["Produit 4",35,{"$f":"ROUNDUP(B5/QC_1,0)","v":3},{"$f":"IF(B5=\"\",\"\",IF(MOD(B5,QC_1)=0,\"cartons complets\",MOD(B5,QC_1)))","v":3},{"$f":"INT(C5/QP_1)","v":0},{"$f":"C5-E5*QP_1","v":3}]
["Produit 5",3200,{"$f":"ROUNDUP(B6/QC_1,0)","v":200},{"$f":"IF(B6=\"\",\"\",IF(MOD(B6,QC_1)=0,\"cartons complets\",MOD(B6,QC_1)))","v":"cartons complets"},{"$f":"INT(C6/QP_1)","v":5},{"$f":"C6-E6*QP_1","v":0}]
["Produit 6",45,{"$f":"ROUNDUP(B7/QC_1,0)","v":3},{"$f":"IF(B7=\"\",\"\",IF(MOD(B7,QC_1)=0,\"cartons complets\",MOD(B7,QC_1)))","v":13},{"$f":"INT(C7/QP_1)","v":0},{"$f":"C7-E7*QP_1","v":3}]
["Produit 7",4500,{"$f":"ROUNDUP(B8/QC_1,0)","v":282},{"$f":"IF(B8=\"\",\"\",IF(MOD(B8,QC_1)=0,\"cartons complets\",MOD(B8,QC_1)))","v":4},{"$f":"INT(C8/QP_1)","v":7},{"$f":"C8-E8*QP_1","v":2},null,null,null,null,null,null,false]
["Produit 8",25,{"$f":"ROUNDUP(B9/QC_1,0)","v":2},{"$f":"IF(B9=\"\",\"\",IF(MOD(B9,QC_1)=0,\"cartons complets\",MOD(B9,QC_1)))","v":9},{"$f":"INT(C9/QP_1)","v":0},{"$f":"C9-E9*QP_1","v":2}]
["Produit 9",null,{"$f":"ROUNDUP(B10/QC_1,0)","v":0},{"$f":"IF(B10=\"\",\"\",IF(MOD(B10,QC_1)=0,\"cartons complets\",MOD(B10,QC_1)))","v":""},{"$f":"INT(C10/QP_1)","v":0},{"$f":"C10-E10*QP_1","v":0}]
["Produit 10",null,{"$f":"ROUNDUP(B11/QC_1,0)","v":0},{"$f":"IF(B11=\"\",\"\",IF(MOD(B11,QC_1)=0,\"cartons complets\",MOD(B11,QC_1)))","v":""},{"$f":"INT(C11/QP_1)","v":0},{"$f":"C11-E11*QP_1","v":0}]
["Produit 11",null,{"$f":"ROUNDUP(B12/QC_1,0)","v":0},{"$f":"IF(B12=\"\",\"\",IF(MOD(B12,QC_1)=0,\"cartons complets\",MOD(B12,QC_1)))","v":""},{"$f":"INT(C12/QP_1)","v":0},{"$f":"C12-E12*QP_1","v":0}]
["Produit 12",null,{"$f":"ROUNDUP(B13/QC_1,0)","v":0},{"$f":"IF(B13=\"\",\"\",IF(MOD(B13,QC_1)=0,\"cartons complets\",MOD(B13,QC_1)))","v":""},{"$f":"INT(C13/QP_1)","v":0},{"$f":"C13-E13*QP_1","v":0}]
["Produit 13",null,{"$f":"ROUNDUP(B14/QC_1,0)","v":0},{"$f":"IF(B14=\"\",\"\",IF(MOD(B14,QC_1)=0,\"cartons complets\",MOD(B14,QC_1)))","v":""},{"$f":"INT(C14/QP_1)","v":0},{"$f":"C14-E14*QP_1","v":0}]
[]
[]
[]
[null,"En colonne C, le dernier carton peut être incomplet si le nombre d'unités n'est pas divisble par 16"]
[null,"la quantité dans le dernier carton est indiquée en colonne D"]
[null,"voir références en feuille BDD"]

{"sheet":"BDD","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Contenance carton",16,"< champ nommé QC_1"]
["Contenance palette",40,"< Champ nommé QP_1"]
[]
[]
[null,null,"Nommer un  champ: sélectionner la cellule, entrer le nom choisi dans la case à gauche de la barre de fprmule et Enter"]
[null,null,"Voir la liste des noms: Ruban / Onglet formule / gestionnaire de noms"]