{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","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":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["CODE PRODUIT","VALEUR produit","PRODUIT","SSCC","CODE BARRE","EMPLACEMENT","valeur emplacement","Colonne1"]
[996998,{"$f":"VLOOKUP(A5,Feuil3!A11:B47,2,0)","v":6},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D5)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 ED 004 04",{"$f":"VLOOKUP(F5,Feuil2!A160:B338,2,0)","v":6},{"$f":"Code39(F5)","v":"*009 043 ED 004 04*"}]
[971488,{"$f":"VLOOKUP(A6,Feuil3!A5:B41,2,0)","v":5},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D6)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EC 004 03",{"$f":"VLOOKUP(F6,Feuil2!A154:B332,2,0)","v":3},{"$f":"Code39(F6)","v":"*009 043 EC 004 03*"}]
[971488,{"$f":"VLOOKUP(A7,Feuil3!A7:B43,2,0)","v":5},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D7)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 ED 004 00",{"$f":"VLOOKUP(F7,Feuil2!A156:B334,2,0)","v":0},{"$f":"Code39(F7)","v":"*009 043 ED 004 00*"}]
[996998,{"$f":"VLOOKUP(A8,Feuil3!A8:B44,2,0)","v":5},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D8)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 ED 004 01",{"$f":"VLOOKUP(F8,Feuil2!A157:B335,2,0)","v":5},{"$f":"Code39(F8)","v":"*009 043 ED 004 01*"}]
[996998,{"$f":"VLOOKUP(A9,Feuil3!A9:B45,2,0)","v":5},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D9)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 ED 004 02",{"$f":"VLOOKUP(F9,Feuil2!A158:B336,2,0)","v":5},{"$f":"Code39(F9)","v":"*009 043 ED 004 02*"}]
[996998,{"$f":"VLOOKUP(A10,Feuil3!A13:B49,2,0)","v":3},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D10)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EE 004 01",{"$f":"VLOOKUP(F10,Feuil2!A162:B340,2,0)","v":5},{"$f":"Code39(F10)","v":"*009 043 EE 004 01*"}]
[971488,{"$f":"VLOOKUP(A11,Feuil3!A10:B46,2,0)","v":2},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D11)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 ED 004 03",{"$f":"VLOOKUP(F11,Feuil2!A159:B337,2,0)","v":5},{"$f":"Code39(F11)","v":"*009 043 ED 004 03*"}]
[993431,{"$f":"VLOOKUP(A12,Feuil3!A2:B38,2,0)","v":1},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D12)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EC 004 00",{"$f":"VLOOKUP(F12,Feuil2!A151:B329,2,0)","v":0},{"$f":"Code39(F12)","v":"*009 043 EC 004 00*"}]
[993431,{"$f":"VLOOKUP(A13,Feuil3!A6:B42,2,0)","v":1},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D13)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EC 004 04",{"$f":"VLOOKUP(F13,Feuil2!A155:B333,2,0)","v":4},{"$f":"Code39(F13)","v":"*009 043 EC 004 04*"}]
[988878,{"$f":"VLOOKUP(A14,Feuil3!A12:B48,2,0)","v":1},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D14)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EE 004 00",{"$f":"VLOOKUP(F14,Feuil2!A161:B339,2,0)","v":0},{"$f":"Code39(F14)","v":"*009 043 EE 004 00*"}]
[988878,{"$f":"VLOOKUP(A15,Feuil3!A3:B39,2,0)","v":0},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D15)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EC 004 01",{"$f":"VLOOKUP(F15,Feuil2!A152:B330,2,0)","v":3},{"$f":"Code39(F15)","v":"*009 043 EC 004 01*"}]
[988878,{"$f":"VLOOKUP(A16,Feuil3!A4:B40,2,0)","v":0},null,"33667610017304875",{"$f":"_xll.IDAutomationWordExcelAddin.FontEncoder.Code128(D16)","v":"ÍAbl*!i$wÈ5BÎ"},"009 043 EC 004 02",{"$f":"VLOOKUP(F16,Feuil2!A153:B331,2,0)","v":3},{"$f":"Code39(F16)","v":"*009 043 EC 004 02*"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Colonne A = liste des codes interne des produits que je copie colle depuis un autre fichier que je recois."]
["Colonne B = fonction recherchev qui va aller trouver la \"valeur\" du code dans la liste des produits en feuille 3"]
["Colonne C = le descriptif du produit ( a voir, peut etre une fonction recherche v ou juste un copié collé de la liste recu"]
["Conne D = le code sscc du produit, également importé de la iste recu."]
["Colonne E = scripte VBA permettant de transformer mon code SSCC en code barre."]
["Colonne F emplacement libre ( collé depuis la liste des emplacements libre donnés par le logiciel interne"]
["Colonne G = Valeur de l'emplacement ( recherchev sur la feuille 2 )"]
["Je voudrais du coup que la colonne B et la colonne G soient de la même valeur, qu'un produit de valeur 1 aille dans un emplacement de valeur 1"]
["Colonne H = scripte code 3 de 9 transformant mon emplacement en code barre pour lecture alphanumérique"]

{"sheet":"Feuil2","index":1,"n_rows":200,"n_cols":2,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["009 043 EA 001 00",0]
["009 043 EA 001 01",2]
["009 043 EA 001 02",1]
["009 043 EA 001 03",1]
["009 043 EA 001 04",2]
["009 043 EB 001 00",0]
["009 043 EB 001 01",1]
["009 043 EB 001 02",1]
["009 043 EB 001 03",1]
["009 043 EB 001 04",2]
["009 043 EC 001 00",0]
["009 043 EC 001 01",3]
["009 043 EC 001 02",3]
["009 043 EC 001 03",3]
["009 043 EC 001 04",4]
["009 043 ED 001 00",0]
["009 043 ED 001 01",5]
["009 043 ED 001 02",5]
["009 043 ED 001 03",5]
["009 043 ED 001 04",6]
["009 043 EE 001 00",0]
["009 043 EE 001 01",5]
["009 043 EE 001 02",5]
["009 043 EE 001 03",5]
["009 043 EE 001 04",6]
["009 043 EF 001 00",0]
["009 043 EF 001 01",5]
["009 043 EF 001 02",5]
["009 043 EF 001 03",5]
["009 043 EF 001 04",6]
["009 043 EG 001 00",7]
["009 043 EG 001 01",7]
["009 043 EG 001 02",7]
["009 043 EG 001 03",7]
["009 043 EG 001 04",8]
["009 043 EG 001 00",7]
["009 043 EG 001 01",7]
["009 043 EG 001 02",7]
["009 043 EG 001 03",7]
["009 043 EG 001 04",8]
["009 043 EH 001 00",7]
["009 043 EH 001 01",7]
["009 043 EH 001 02",7]
["009 043 EH 001 03",7]
["009 043 EH 001 04",8]
["009 043 EI 001 00",9]
["009 043 EI 001 01",9]
["009 043 EI 001 02",9]
["009 043 EI 001 03",9]
["009 043 EA 002 00",0]
["009 043 EA 002 01",2]
["009 043 EA 002 02",1]
["009 043 EA 002 03",1]
["009 043 EA 002 04",2]
["009 043 EB 002 00",0]
["009 043 EB 002 01",1]
["009 043 EB 002 02",1]
["009 043 EB 002 03",1]
["009 043 EB 002 04",2]
["009 043 EC 002 00",0]
["009 043 EC 002 01",3]
["009 043 EC 002 02",3]
["009 043 EC 002 03",3]
["009 043 EC 002 04",4]
["009 043 ED 002 00",0]
["009 043 ED 002 01",5]
["009 043 ED 002 02",5]
["009 043 ED 002 03",5]
["009 043 ED 002 04",6]
["009 043 EE 002 00",0]
["009 043 EE 002 01",5]
["009 043 EE 002 02",5]
["009 043 EE 002 03",5]
["009 043 EE 002 04",6]
["009 043 EF 002 00",0]
["009 043 EF 002 01",5]
["009 043 EF 002 02",5]
["009 043 EF 002 03",5]
["009 043 EF 002 04",6]
["009 043 EG 002 00",7]
["009 043 EG 002 01",7]
["009 043 EG 002 02",7]
["009 043 EG 002 03",7]
["009 043 EG 002 04",8]
["009 043 EG 002 00",7]
["009 043 EG 002 01",7]
["009 043 EG 002 02",7]
["009 043 EG 002 03",7]
["009 043 EG 002 04",8]
["009 043 EH 002 00",7]
["009 043 EH 002 01",7]
["009 043 EH 002 02",7]
["009 043 EH 002 03",7]
["009 043 EH 002 04",8]
["009 043 EI 002 00",9]
["009 043 EI 002 01",9]
["009 043 EI 002 02",9]
["009 043 EI 002 03",9]
["009 043 EA 003 00",0]
["009 043 EA 003 01",2]
["009 043 EA 003 02",1]
["009 043 EA 003 03",1]
["009 043 EA 003 04",2]
["009 043 EB 003 00",0]
["009 043 EB 003 01",1]
["009 043 EB 003 02",1]
["009 043 EB 003 03",1]
["009 043 EB 003 04",2]
["009 043 EC 003 00",0]
["009 043 EC 003 01",3]
["009 043 EC 003 02",3]
["009 043 EC 003 03",3]
["009 043 EC 003 04",4]
["009 043 ED 003 00",0]
["009 043 ED 003 01",5]
["009 043 ED 003 02",5]
["009 043 ED 003 03",5]
["009 043 ED 003 04",6]
["009 043 EE 003 00",0]
["009 043 EE 003 01",5]
["009 043 EE 003 02",5]
["009 043 EE 003 03",5]
["009 043 EE 003 04",6]
["009 043 EF 003 00",0]
["009 043 EF 003 01",5]
["009 043 EF 003 02",5]
["009 043 EF 003 03",5]
["009 043 EF 003 04",6]
["009 043 EG 003 00",7]
["009 043 EG 003 01",7]
["009 043 EG 003 02",7]
["009 043 EG 003 03",7]
["009 043 EG 003 04",8]
["009 043 EG 003 00",7]
["009 043 EG 003 01",7]
["009 043 EG 003 02",7]
["009 043 EG 003 03",7]
["009 043 EG 003 04",8]
["009 043 EH 003 00",7]
["009 043 EH 003 01",7]
["009 043 EH 003 02",7]
["009 043 EH 003 03",7]
["009 043 EH 003 04",8]
["009 043 EI 003 00",9]
["009 043 EI 003 01",9]
["009 043 EI 003 02",9]
["009 043 EI 003 03",9]
["009 043 EA 004 00",0]
["009 043 EA 004 01",2]
["009 043 EA 004 02",1]
["009 043 EA 004 03",1]
["009 043 EA 004 04",2]
["009 043 EB 004 00",0]
["009 043 EB 004 01",1]
["009 043 EB 004 02",1]
["009 043 EB 004 03",1]
["009 043 EB 004 04",2]
["009 043 EC 004 00",0]
["009 043 EC 004 01",3]
["009 043 EC 004 02",3]
["009 043 EC 004 03",3]
["009 043 EC 004 04",4]
["009 043 ED 004 00",0]
["009 043 ED 004 01",5]
["009 043 ED 004 02",5]
["009 043 ED 004 03",5]
["009 043 ED 004 04",6]
["009 043 EE 004 00",0]
["009 043 EE 004 01",5]
["009 043 EE 004 02",5]
["009 043 EE 004 03",5]
["009 043 EE 004 04",6]
["009 043 EF 004 00",0]
["009 043 EF 004 01",5]
["009 043 EF 004 02",5]
["009 043 EF 004 03",5]
["009 043 EF 004 04",6]
["009 043 EG 004 00",7]
["009 043 EG 004 01",7]
["009 043 EG 004 02",7]
["009 043 EG 004 03",7]
["009 043 EG 004 04",8]
["009 043 EG 005 00",7]
["009 043 EG 005 01",7]
["009 043 EG 005 02",7]
["009 043 EG 005 03",7]
["009 043 EG 005 04",8]
["009 043 EH 002 00",7]
["009 043 EH 002 01",7]
["009 043 EH 002 02",7]
["009 043 EH 002 03",7]
["009 043 EH 002 04",8]
["009 043 EI 002 00",9]
["009 043 EI 002 01",9]
["009 043 EI 002 02",9]
["009 043 EI 002 03",9]

{"sheet":"Feuil3","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[993431,1]
[988878,0]
[988878,2]
[971488,5]
[993431,1]
[971488,2]
[996998,5]
[996998,6]
[971488,2]
[996998,3]
[988878,1]
[996998,2]