{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["ESSAI DE BON DE LIVRAISON EFC COMPRENANT EMPLACEMENTS LIBRE AGIS"]
[null,null,null,null,null,null,null,null,"DEPLACER SUR AUTRE FEUILLE"]
[]
["CODE PRODUIT","VALEUR","PRODUIT","SSCC","CODE BARRE","EMPLACEMENT","C",null,null,null,null,"LISTE PALETTES EFC"]
[993431,{"$f":"VLOOKUP(A5,$L$5:M38,2,0)","v":1},"BARQUETTE 1M",3.36676100173099E+16,{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D5)","v":"ÍÈ3,ÇDc]Â1>ÇÈE+16#Î"},"009 043 EA 001 00",{"$f":"VLOOKUP(F5,I3:J333,2,0)","v":1},null,"009 043 EA 001 00",1,null,993431,1]
[988878,{"$f":"VLOOKUP(A6,$L$5:M39,2,0)","v":1},null,null,null,"009 043 EA 001 02",1,null,"009 043 EA 001 01",2,null,988878,1]
[988878,{"$f":"VLOOKUP(A7,$L$5:M40,2,0)","v":1},null,null,null,"009 043 EA 001 01",2,null,"009 043 EA 001 02",1,null,996998,2]
[971488,{"$f":"VLOOKUP(A8,$L$5:M41,2,0)","v":1},null,null,null,"009 043 ED 001 04",2,null,"009 043 EA 001 03",1,null,971488,1]
[993431,{"$f":"VLOOKUP(A9,$L$5:M42,2,0)","v":1},null,null,null,"009 043 EB 001 04",2,null,"009 043 EA 001 04",2]
[971488,{"$f":"VLOOKUP(A10,$L$5:M43,2,0)","v":1},null,null,null,null,{"$error":"#N/A"},null,"009 043 EB 001 00",1,null,"etc …."]
[996998,{"$f":"VLOOKUP(A11,$L$5:M44,2,0)","v":2},"BARQUETTE 2L",null,null,"009 043 EC 001 01",1,null,"009 043 EB 001 01",1]
[996998,{"$f":"VLOOKUP(A12,$L$5:M45,2,0)","v":2},null,null,null,null,{"$error":"#N/A"},null,"009 043 EB 001 02",1]
[null,null,null,null,null,null,null,null,"009 043 EB 001 03",1]
[null,null,null,null,null,null,null,null,"009 043 EB 001 04",2]
["voilà l'avancement, j'essaie maintenant de faire en sorte que les valeurs 1 produits aillent avec une valeur 1 emplacement.",null,null,null,null,null,null,null,"009 043 EC 001 00",1]
[null,null,null,null,null,null,null,null,"009 043 EC 001 01",1]
["Ici la colone code produit et emplacement seront actualisés tous les jours.",null,null,null,null,null,null,null,"009 043 EC 001 02",1]
["Seul les valeurs dans le cadre a coté, que je placerais sur une autre feuille, seront contante avec les valeures constante.",null,null,null,null,null,null,null,"009 043 EC 001 03",1]
[null,null,null,null,null,null,null,null,"009 043 EC 001 04",2]
["Bien sur, j'aimerais qu'un emplacement soit attribué qu'une fois",null,null,null,null,null,null,null,"009 043 ED 001 00",1]
[null,null,null,null,null,null,null,null,"009 043 ED 001 01",1]
[null,null,null,null,null,null,null,null,"009 043 ED 001 02",1]
[null,null,null,null,null,null,null,null,"009 043 ED 001 03",1]
[null,null,null,null,null,null,null,null,"009 043 ED 001 04",2]
[null,null,null,null,null,null,null,null,"009 043 EE 001 00"]
[null,null,null,null,null,null,null,null,"009 043 EE 001 01"]
[null,null,null,null,null,null,null,null,"009 043 EE 001 02"]
[null,null,null,null,null,null,null,null,"009 043 EE 001 03"]
[null,null,null,null,null,null,null,null,"009 043 EE 001 04"]
[null,null,null,null,null,null,null,null,"009 043 EF 001 00"]
[null,null,null,null,null,null,null,null,"009 043 EF 001 01"]
[null,null,null,null,null,null,null,null,"009 043 EF 001 02"]
[null,null,null,null,null,null,null,null,"009 043 EF 001 03"]
[null,null,null,null,null,null,null,null,"009 043 EF 001 04"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 00"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 01"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 02"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 03"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 04"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 00"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 01"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 02"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 03"]
[null,null,null,null,null,null,null,null,"009 043 EG 001 04"]
[null,null,null,null,null,null,null,null,"009 043 EH 001 00"]
[null,null,null,null,null,null,null,null,"009 043 EH 001 01"]
[null,null,null,null,null,null,null,null,"009 043 EH 001 02"]
[null,null,null,null,null,null,null,null,"009 043 EH 001 03"]
[null,null,null,null,null,null,null,null,"009 043 EH 001 04"]
[null,null,null,null,null,null,null,null,"009 043 EI 001 00"]
[null,null,null,null,null,null,null,null,"009 043 EI 001 01"]
[null,null,null,null,null,null,null,null,"009 043 EI 001 02"]
[null,null,null,null,null,null,null,null,"009 043 EI 001 03"]