{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Feuil2","Feuil1","ListesVracPF","ListesContenant","ListesFermeture","ListeSurbouchage","ListeEmballage","ListeAgresHab"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":56,"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":"Feuil2","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["CONTENANT","Bouteille Verre",null,null,null,"userform2","ok",null,null,"typems","AGRES"]
["CONTENANT","Bouteille PET",null,null,null,"userform2","ok",null,"ok","userform1","CONTENANT"]
["CONTENANT","Outre",null,null,null,"userform3","ok",null,null,null,"EMBALLAGE"]
["CONTENANT","Cubis",null,null,null,"userform4","ok",null,null,null,"FERMETURE"]
["CONTENANT","Pouch 4",null,null,null,"userform5","ok",null,null,null,"HABILLAGE"]
["CONTENANT","Pouch 6",null,null,null,"userform5","ok",null,null,null,"SURBOUCHAGE"]
["CONTENANT","Tetra Prisma",null,null,null,"userform6","ok"]
["CONTENANT","Tetra Baseline",null,null,null,"userform6","ok"]
["FERMETURE","Bouchon",null,null,null,"userform7","ok"]
["FERMETURE","Capsule a vis",null,null,null,"userform8","ok"]
["FERMETURE","Opercule",null,null,null,"userform8","ok"]
["FERMETURE","Cap Stream",null,null,null,"userform9","ok"]
["SURBOUCHAGE","Capsule",null,null,null,"userform10","ok"]
["SURBOUCHAGE","Pion Fiscal",null,null,null,"userform11","ok"]
["EMBALLAGE","Carton Bouteille",null,null,null,"userform12","ok"]
["EMBALLAGE","Caisse Bois",null,null,null,"userform13","ok"]
["EMBALLAGE","Regroupement",null,null,null,"userform14","ok"]
["EMBALLAGE","Aplat BIB",null,null,null,"userform15","ok"]
["EMBALLAGE","Box",null,null,null,"userform16","ok"]
["EMBALLAGE","Bac Presentoir",null,null,null,"userform17","ok"]
["EMBALLAGE","Croisillon",null,null,null,"userform18","ok"]
["EMBALLAGE","Alveole",null,null,null,"userform18","ok"]
["EMBALLAGE","Plaque",null,null,null,"userform18","ok"]
["EMBALLAGE","Guillotine",null,null,null,"userform18","ok"]
["EMBALLAGE","Film",null,null,null,"userform18","ok"]
["AGRES","Palette",null,null,null,"userform19","ok"]
["AGRES","Emballages",null,null,null,"userform19","ok"]
["AGRES","Intercalaires",null,null,null,"userform19","ok"]
["HABILLAGE","Etiquette",null,null,null,"userform20","ok"]
["HABILLAGE","Contre Etiquette",null,null,null,"userform20","ok"]
["HABILLAGE","Collerette",null,null,null,"userform20","ok"]
["HABILLAGE","Medaille",null,null,null,"userform20","ok"]
["HABILLAGE","Sticker",null,null,null,"userform21","ok"]
["HABILLAGE","Affichette",null,null,null,"userform21","ok"]
["HABILLAGE","Paille",null,null,null,"userform21","ok"]
["HABILLAGE","Pendeloque",null,null,null,"userform22","ok"]

{"sheet":"Feuil1","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null," "]

{"sheet":"ListesVracPF","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Degre",6.5]
["degre",7]
[null,7.5]
[null,8]
[null,8.5]
[null,9]
[null,9.5]
[null,10]
[null,10.5]
[null,11]
[null,11.5]
[null,12]
[null,12.5]
[null,13]
[null,13.5]
[null,14]
[null,14.5]
[null,15]
[null,15.5]

{"sheet":"ListesContenant","index":3,"n_rows":89,"n_cols":18,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CONTENANT",null,null,null,null,"Type MS","Famille","Couleur","Centilisation","Bouchage","Libre (18)",null,null,null,"Code",null,"Nombre de caractère"]
[null,null,null,null,null,null,"CONTENANT","Cubis","MARRON","500","BVS",null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H3,$C$4:$D$89,2,),\" \",VLOOKUP(I3,$C$4:$D$89,2,),VLOOKUP(J3,$C$4:$D$89,2,),\" \",VLOOKUP(K3,$C$4:$D$89,2,),\" \",L3)","v":"CU MA500 BVS "},null,{"$f":"LEN(P3)","v":13}]
[null,"Famille","Bouteille Verre","BV",null,null,null,null,null,null,null,{"$f":"IF(LEN(L3)>18,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"fambt","Bouteilles PET","BP"]
[null,null,"Cubis","CU",null,null,"Type MS","Famille","Matière","Forme","Robinet","Centilisation","Bouchage","Libre (8)",null,"Code",null,"Nombre de caractère"]
[null,null,"Outre","OU",null,null,"CONTENANT","Outre","PEH","RECTANGULAIRE","VTC","500","VTOP LONG",null,null,{"$f":"CONCATENATE(VLOOKUP(H7,$C$4:$D$89,2,),\" \",VLOOKUP(I7,$C$4:$D$89,2,),VLOOKUP(J7,$C$4:$D$89,2,),\" \",VLOOKUP(K7,$C$4:$D$89,2,),VLOOKUP(L7,$C$4:$D$89,2,),\" \",VLOOKUP(M7,$C$4:$D$89,2,),\" \",N7)","v":"OU PEHREC VTC500 VTL "},null,{"$f":"LEN(P7)","v":21}]
[null,"fampouch","Pouch 6","P6",null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(N7)>8,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"Pouch 4","P4"]
[null,"famtetra","Tetra Baseline","TB",null,null,"Type MS","Famille","Centilisation","Bouchage","Libre (19)",null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"Tetra Prisma","TP",null,null,"CONTENANT","Tetra Baseline","100","UNITAP","JFD",null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H11,$C$4:$D$89,2,),\" \",VLOOKUP(I11,$C$4:$D$89,2,),\" \",VLOOKUP(J11,$C$4:$D$89,2,),\" \",K11)","v":"TB 100 UNI JFD"},null,{"$f":"LEN(P11)","v":14}]
[null,"Type","Bordelaise","X",null,null,null,null,null,null,{"$f":"IF(LEN(K11)>19,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"typebt","Bourguignone","G"]
[null,null,"Regionale","R",null,null,"Type MS","Famille","Type","Modele","Couleur","Centilisation","Bouchage","Libre (12)",null,"Code",null,"Nombre de caractère"]
[null,null,"Speciale","S",null,null,"CONTENANT","Bouteille Verre","Bourguignone","CARACTERE","FEUILLE MORTE","75","CETIE","JFD",null,{"$f":"CONCATENATE(VLOOKUP(H15,$C$4:$D$89,2,),VLOOKUP(I15,$C$4:$D$89,2,),VLOOKUP(J15,$C$4:$D$89,2,),\" \",VLOOKUP(K15,$C$4:$D$89,2,),VLOOKUP(L15,$C$4:$D$89,2,),\" \",VLOOKUP(M15,$C$4:$D$89,2,),\" \",N15)","v":"BVGCAR FM75 CET JFD"},null,{"$f":"LEN(P15)","v":19}]
[null,"Modele","AUTHENTIQ","AUT",null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(N15)>12,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"modelebt","AZUR","AZU"]
[null,null,"BG","BG",null,null,"Type MS","Famille","Centilisation","Libre (21)",null,null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"BOULIDOU","BOU",null,null,"CONTENANT","Pouch 6","300","JFD",null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H19,$C$4:$D$89,2,),\" \",VLOOKUP(I19,$C$4:$D$89,2,),\" \",J19)","v":"P6 300 JFD"},null,{"$f":"LEN(P19)","v":10}]
[null,null,"CALIFORN","CAL",null,null,null,null,null,{"$f":"IF(LEN(J19)>21,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"CARACTERE","CAR"]
[null,null,"CARAFE","CAF"]
[null,null,"CLARA","CLA"]
[null,null,"DISTINCTI","DIS"]
[null,null,"ECO 2","ECO"]
[null,null,"EVOL SATI","EVS"]
[null,null,"EVOLUTION","EVO"]
[null,null,"FLUTE EVO","FLU"]
[null,null,"FLUTE OPTIMA","FLU"]
[null,null,"GDE TRAD","GDE"]
[null,null,"HELIX","HEL"]
[null,null,"LANGUEDOC","LAN"]
[null,null,"LITRE","LIT"]
[null,null,"LITRE HOLL","LHO"]
[null,null,"LITRE VT","LVT"]
[null,null,"LUX NATURA","LUX"]
[null,null,"MAESTRIA","MAE"]
[null,null,"MAGNUM","MAG"]
[null,null,"MEDIUM","MED"]
[null,null,"NATURA","NAT"]
[null,null,"NIMOISE","NIM"]
[null,null,"NOVIMPAK","NOV"]
[null,null,"OPTIMA","OPT"]
[null,null,"PRIVILEGE","PRI"]
[null,null,"PROVENCE","PRO"]
[null,null,"SABINE","SAB"]
[null,null,"SARMENAC","SAR"]
[null,null,"SEDDUCCION","SED"]
[null,null,"SEDUCTION","SED"]
[null,null,"SENSATION","SEN"]
[null,null,"SPIRALE","SPI"]
[null,null,"TENDANCE","TEN"]
[null,null,"TRADITION","TRA"]
[null,null,"TUCCITANE","TUC"]
[null,null,"UCCOAR","UCC"]
[null,null,"VERONIQUE","VER"]
[null,"Couleur","CHAMPAGNE","CH"]
[null,"coulcont","CANNELLE","CAN"]
[null,null,"EXTRA BLANC","EB"]
[null,null,"FEUILLE MORTE","FM"]
[null,null,"MI BLANC","MB"]
[null,null,"MARRON","MA"]
[null,null,"SPECIALE","SP"]
[null,"Centilisation","20","20"]
[null,"centilcont","25","25"]
[null,null,"37,5","37"]
[null,null,"50","50"]
[null,null,"75","75"]
[null,null,"100","100"]
[null,null,"150","150"]
[null,null,"225","225"]
[null,null,"300","300"]
[null,null,"500","500"]
[null,null,"1000","1000"]
[null,null,"2000","2000"]
[null,"Bouchage","CETIE","CET"]
[null,"bouchagecont","BVS","BVS"]
[null,null,"SPECIALE","SPE"]
[null,"bouchagebib","VTOP LONG","VTL"]
[null,null,"VTOP COURT","VTC"]
[null,"bouchagetetra","UNITAP","UNI"]
[null,null,"ASEPTIQUE","ASE"]
[null,"Matiere","ALU","ALU"]
[null,"matcont","PEH","PEH"]
[null,null,"PET","PET"]
[null,"Robinet","VTC","VTC"]
[null,"robcont","VTL","VTL"]
[null,"Forme","CARRE","CAR"]
[null,"formcont","RECTANGULAIRE","REC"]

{"sheet":"ListesFermeture","index":4,"n_rows":114,"n_cols":18,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FERMETURE"]
[null,null,null,null,null,null,"Type MS","Famille","Nature","Diametre","\"X\" ","Longueur","Qualite","Decor (15)",null,"Code",null,"Nombre de caractère"]
[null,"Famille","Bouchon","BO",null,null,"FERMETURE","Bouchon","LIEGE NATUREL","24","X","44","3eme","BRISE DE France",null,{"$f":"CONCATENATE(VLOOKUP(H4,$C$4:$D$84,2,),\" \",VLOOKUP(I4,$C$4:$D$84,2,),\" \",J4,K4,L4,\" \",VLOOKUP(M4,$C$4:$D$84,2,),\" \",N4)","v":"BO LN 24X44 3 BRISE DE France"},null,{"$f":"LEN(P4)","v":29}]
[null,"famcpvop","Capsule a vis","CV",null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(N4)>15,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"Opercule","OP"]
[null,null,"Cap Stream","CS",null,null,"Type MS","Famille","Nature","Dimensions","CRD/Centil","Couleur","Decor (8)",null,null,"Code",null,"Nombre de caractère"]
[null,"Nature","LIEGE NATUREL","LN",null,null,"FERMETURE","Capsule a vis","ALU","30H60","LDV37,5","Coquelicot","BONNE NOUVELLE",null,null,{"$f":"CONCATENATE(VLOOKUP(H8,$C$4:$D$84,2,),\" \",VLOOKUP(I8,$C$4:$D$84,2,),\" \",J8,\" \",VLOOKUP(K8,$C$4:$D$84,2,),\" \",VLOOKUP(L8,$C$4:$D$84,2,),\" \",VLOOKUP(M8,$C$4:$D$84,2,))","v":"CV AL 30H60 LV37 COQ BON NOUV"},null,{"$f":"LEN(P8)","v":29}]
[null,"naturebouch","LIEGE COLMATE","LC",null,null,null,null,null,null,null,null,{"$f":"IF(R8>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"AGGLO","AG"]
[null,null,"TECHNIQUE","TE",null,null,"Type MS","Famille ","Nature","Dimensions","Couleur","Decor (8)",null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"SYNTHETIQUE","SY",null,null,"FERMETURE","Cap Stream","ALU","30H60","Coquelicot","BONNE NOUVELLE",null,null,null,{"$f":"CONCATENATE(VLOOKUP(H12,$C$4:$D$84,2,),\" \",VLOOKUP(I12,$C$4:$D$84,2,),\" \",J12,\" \",VLOOKUP(K12,$C$4:$D$84,2,),\" \",VLOOKUP(L12,$C$4:$D$84,2,))","v":"CS AL 30H60 COQ BON NOUV"},null,{"$f":"LEN(P12)","v":24}]
[null,"naturecpvope","ALU","AL",null,null,null,null,null,null,null,{"$f":"IF(R12>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"PEHD","PH"]
[null,null,"PVC","PV"]
[null,null,"PE","PE"]
[null,"Qualite/Couleur","Fleur","FLE"]
[null,"qualbouch","Superieure","SUP"]
[null,null,"1ere","1"]
[null,null,"2eme","2"]
[null,null,"3eme","3"]
[null,null,"4eme","4"]
[null,null,"5eme","5"]
[null,null,"6eme","6"]
[null,null,"Rien"]
[null,"coulferm","Or","OR"]
[null,null,"Argent","ARG"]
[null,null,"Bronze","BRO"]
[null,null,"Noire","NOI"]
[null,null,"Rouge","RGE"]
[null,null,"Bordeaux","BDX"]
[null,null,"Marron","MAR"]
[null,null,"Bleu","BLE"]
[null,null,"Vert","VER"]
[null,null,"Jaune","JAU"]
[null,null,"Orange","ORA"]
[null,null,"Violet","VIO"]
[null,null,"Blanc","BLC"]
[null,null,"Creme","CRM"]
[null,null,"Cristal","CST"]
[null,null,"Coquelicot","COQ"]
[null,null,"Safran","SAF"]
[null,null,"Rose","RSE"]
[null,"CRD/Centil","Sans"]
[null,"crdcentil","NF","NF"]
[null,null,"NF25","NF25"]
[null,null,"NF37,5","NF37"]
[null,null,"NF50","NF50"]
[null,null,"TB25","TB25"]
[null,null,"TB37,5","TB37"]
[null,null,"TB50","TB50"]
[null,null,"TB75","TB75"]
[null,null,"TB100","TB100"]
[null,null,"TB150","TB150"]
[null,null,"TV25","TV25"]
[null,null,"TV37,5","TV37"]
[null,null,"TV50","TV50"]
[null,null,"TV75","TV75"]
[null,null,"TV100","TV100"]
[null,null,"TV150","TV150"]
[null,null,"LDV25","LV25"]
[null,null,"LDV37,5","LV37"]
[null,null,"LDV50","LV50"]
[null,null,"LDV75","LV75"]
[null,null,"LDV100","LV100"]
[null,null,"LDV150","LV150"]
[null,"Decor Fermeture","Sans"]
[null,"decorferm","BONNE NOUVELLE","BON NOUV"]
[null,null,"CAP SOLEIL","CAP SOLE"]
[null,null,"YUKO","YUKO"]
[null,null,"P201C","P201C"]
[null,null,"Liseré simple","LISS"]
[null,null,"Liseré double","LISD"]
[null,null,"Blason","BLAS"]
[null,"Decor Bouchon","Sans"]
[null,"decorbouch","MEB CHAIS","MEB CHAI"]
[null,null,"Propriété","MEB PROPRIETE"]
[null,null,"Château","MEB CHÂTEAU"]
[null,null,"LIDL","LIDL"]
[null,null,"METRO","METRO"]
[null,null,"RIBEAUPIERRE","RIBEAUPIERRE"]
[null,null,"BRISE DE France","BRISE DE France"]
[null,null,"AVANT-GARDE","AVANT-GARDE"]
[null,null,"ROCHE D'ARJAC","ROCHE D'ARJAC"]
[]
[]
[]
[null,"Dimensions CPV","22H30"]
[null,"dimcpsope","25H43"]
[null,null,"30H45"]
[null,null,"30H50"]
[null,null,"30H60"]
[null,null,"36H18"]
[null,null,"36H52"]
[]
[null,"Hauteur BO","36"]
[null,"longbouch","37"]
[null,null,"38"]
[null,null,"42"]
[null,null,"43"]
[null,null,"44"]
[null,null,"49"]
[]
[null,"Diametre BO","22"]
[null,"diambouch","22,5"]
[null,null,"23"]
[null,null,"23,5"]
[null,null,"24"]
[null,null,"24,5"]
[null,null,"25"]
[]
[]
[null,"Dimensions CAP STREAM","31H16"]
[null,"dimcap","30H15"]

{"sheet":"ListeSurbouchage","index":5,"n_rows":108,"n_cols":18,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,null,"cppf"]
[null,null,"Capsule","CP"]
[null,"SURBOUCHAGE","Pion Fiscal","VI",null,null,"Type MS","Type SRB","Nature","CRD/Centil","Diametre","Hauteur","Couleur","Decor (7)",null,"Code",null,"Nombre de caractère"]
[null,null,null,null,null,null,"SURBOUCHAGE","Capsule","COMPLEXE","LDV500","30",55,"Coquelicot",null,null,{"$f":"CONCATENATE(VLOOKUP(H4,$C$2:$D$108,2,),\" \",VLOOKUP(I4,$C$4:$D$108,2,),\" \",VLOOKUP(J4,$C$4:$D$108,2,),\" \",K4,\"X\",L4,\" \",VLOOKUP(M4,$C$4:$D$108,2,),\" \",N4)","v":"CP CPX LV500 30X55 COQ "},null,{"$f":"LEN(P4)","v":23}]
[null,"Nature","COMPLEXE","CPX",null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(N4)>7,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"naturesrb","PVC","PVC"]
[null,"naturepion","PET","PET",null,null,"Type MS","Type SRB","Nature","CRD/Centil","Diametre",null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"ALU","ALU",null,null,"SURBOUCHAGE","Pion Fiscal","PVC","LDV2000",16,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H8,$C$2:$D$108,2,),\" \",VLOOKUP(I8,$C$4:$D$108,2,),\" \",VLOOKUP(J8,$C$4:$D$108,2,),\" \",K8,)","v":"VI PVC LV2000 16"},null,{"$f":"LEN(P8)","v":16}]
[null,null,"ETAIN","ETA"]
[null,"CRD/Centil","NF","NF"]
[null,"crdcentilsrb","NF25","NF25"]
[null,null,"NF37,5","NF37"]
[null,null,"NF50","NF50"]
[null,null,"NF300","NF300"]
[null,null,"TB25","TB25"]
[null,null,"TB37,5","TB37"]
[null,null,"TB50","TB50"]
[null,null,"TB75","TB75"]
[null,null,"TB100","TB100"]
[null,null,"TB150","TB150"]
[null,null,"TB225","TB225"]
[null,null,"TB300","TB300"]
[null,null,"TB500","TB500"]
[null,null,"TV25","TV25"]
[null,null,"TV37,5","TV37"]
[null,null,"TV50","TV50"]
[null,null,"TV75","TV75"]
[null,null,"TV100","TV100"]
[null,null,"TV150","TV150"]
[null,null,"TV225","TV225"]
[null,null,"TV300","TV300"]
[null,null,"TV500","TV500"]
[null,null,"LDV25","LV25"]
[null,null,"LDV37,5","LV37"]
[null,null,"LDV50","LV50"]
[null,null,"LDV75","LV75"]
[null,null,"LDV100","LV100"]
[null,null,"LDV150","LV150"]
[null,null,"LDV225","LV225"]
[null,null,"LDV300","LV300"]
[null,null,"LDV500","LV500"]
[null,"Couleur","Or","OR"]
[null,"coulsrb","Argent","ARG"]
[null,null,"Bronze","BRO"]
[null,null,"Noire","NOI"]
[null,null,"Rouge","RGE"]
[null,null,"Bordeaux","BDX"]
[null,null,"Marron","MAR"]
[null,null,"Bleu","BLE"]
[null,null,"Vert","VER"]
[null,null,"Jaune","JAU"]
[null,null,"Orange","ORA"]
[null,null,"Violet","VIO"]
[null,null,"Blanc","BLC"]
[null,null,"Creme","CRM"]
[null,null,"Cristal","CST"]
[null,null,"Coquelicot","COQ"]
[null,null,"Safran","SAF"]
[null,null,"Rose","RSE"]
[null,"Decor","Liseré simple","LISS"]
[null,null,"Liseré double","LISD"]
[null,null,"Blason","BLAS"]
[]
[]
[null,"Diametre SRB","29,5"]
[null,"diamsrb","30"]
[null,null,"30,5"]
[null,null,"31"]
[null,null,"31,5"]
[null,null,"33"]
[null,null,"34"]
[null,null,"36"]
[null,null,"37"]
[]
[null,"Hauteur SRB",40]
[null,"hautsrb",45]
[null,null,50]
[null,null,55]
[null,null,60]
[null,null,65]
[null,null,70]
[]
[]
[null,"Centil BIB/Tetra","TB25","TB25"]
[null,"crdcentilbib","TB100","TB100"]
[null,null,"TB225","TB225"]
[null,null,"TB300","TB300"]
[null,null,"TB500","TB500"]
[null,null,"TB1000","TB1000"]
[null,null,"TB2000","TB2000"]
[null,null,"TV25","TV25"]
[null,null,"TV100","TV100"]
[null,null,"TV225","TV225"]
[null,null,"TV300","TV300"]
[null,null,"TV500","TV500"]
[null,null,"TV1000","TV1000"]
[null,null,"TV2000","TV2000"]
[null,null,"LDV25","LV25"]
[null,null,"LDV100","LV100"]
[null,null,"LDV225","LV225"]
[null,null,"LDV300","LV300"]
[null,null,"LDV500","LV500"]
[null,null,"LDV1000","LV1000"]
[null,null,"LDV2000","LV2000"]
[]
[null,"Diam PION",16]
[null,"diampf",30]
[null,null,40]

{"sheet":"ListeEmballage","index":6,"n_rows":115,"n_cols":20,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EMBALLAGE"]
[null,null,null,null,null,null,"Type MS","Nature","Type","Capacité","Contenant","Modele","Centilisation","Decor","Finition","Libre (5)",null,"Code",null,"Nombre de caractère"]
[null,"Nature","Carton Bouteille","CAR",null,null,"EMBALLAGE","CARTON BOUTEILLE","Debout","12","BX","AUTHENTIQ","75","FLEXO","Predecoupe","AUCHAN",null,{"$f":"CONCATENATE(VLOOKUP(H4,$C$4:$D$108,2,),\" \",VLOOKUP(I4,$C$4:$D$108,2,),VLOOKUP(J4,$C$4:$D$108,2,),\" \",VLOOKUP(K4,$C$4:$D$108,2,),VLOOKUP(L4,$C$4:$D$108,2,),\" \",VLOOKUP(M4,$C$4:$D$108,2,),\" \",VLOOKUP(N4,$C$4:$D$108,2,),VLOOKUP(O4,$C$4:$D$108,2,),\" \",P4)","v":"CAR D12 BXAUT 75 FLEP AUCHAN"},null,{"$f":"LEN(R4)","v":28}]
[null,null,"Aplat BIB","BIB",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T4>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"Caisse Bois","CAI"]
[null,null,"Box","BOX",null,null,"Type MS","Nature","Type","Capacité","Contenant","Modele","Centilisation","Finition","Libre (10)",null,null,"Code",null,"Nombre de caractère"]
[null,null,"Regroupement","REG",null,null,"EMBALLAGE","CAISSE BOIS","Debout","12","BX","AUTHENTIQ","75","Guillotine","AUCHAN",null,null,{"$f":"CONCATENATE(VLOOKUP(H8,$C$4:$D$108,2,),\" \",VLOOKUP(I8,$C$4:$D$108,2,),VLOOKUP(J8,$C$4:$D$108,2,),\" \",VLOOKUP(K8,$C$4:$D$108,2,),VLOOKUP(L8,$C$4:$D$108,2,),\" \",VLOOKUP(M8,$C$4:$D$108,2,),\" \",VLOOKUP(N8,$C$4:$D$108,2,),\" \",O8)","v":"CAI D12 BXAUT 75 GUI AUCHAN"},null,{"$f":"LEN(R8)","v":27}]
[null,null,"Bac Presentoir","BAC",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T8>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"natureemb","Croisillon","CRO"]
[null,null,"Alveole","ALV",null,null,"Type MS","Nature","Capacité","Contenant","Modele","Centilisation","Decor","Libre (8)",null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"Plaque","PLA",null,null,"EMBALLAGE","REGROUPEMENT","12","BX","AUTHENTIQ","75","FLEXO","LIDL",null,null,null,{"$f":"CONCATENATE(VLOOKUP(H12,$C$4:$D$108,2,),\" \",VLOOKUP(I12,$C$4:$D$108,2,),VLOOKUP(J12,$C$4:$D$108,2,),\" \",VLOOKUP(K12,$C$4:$D$108,2,),VLOOKUP(L12,$C$4:$D$108,2,),\" \",VLOOKUP(M12,$C$4:$D$108,2,),,\" \",N12)","v":"REG 12BX AUT75 FLE LIDL"},null,{"$f":"LEN(R12)","v":23}]
[null,null,"Guillotine","GUI",null,null,null,null,null,null,null,null,null,{"$f":"IF(T12>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"Film","FLM"]
[null,"Type","Debout","D",null,null,"Type MS","Nature","Centilisation","Type BIB","Libre (19)",null,null,null,null,null,null,"Code",null,"Nombre de caractère"]
[null,"typeemb","Couché","C",null,null,"EMBALLAGE","APLAT BIB","1000","Rectangulaire","decor papa",null,null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H16,$C$4:$D$108,2,),\" \",VLOOKUP(I16,$C$4:$D$108,2,),VLOOKUP(J16,$C$4:$D$108,2,),\" \",K16)","v":"BIB 1000R decor papa"},null,{"$f":"LEN(R16)","v":20}]
[null,"Capacité","1","1",null,null,null,null,null,null,{"$f":"IF(LEN(K16)>19,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"capaemb","2","2"]
[null,null,"3","3",null,null,"Type MS","Nature","Capacité","Type box","Centilisation","Decor","Libre (11)",null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"4","4",null,null,"EMBALLAGE","BOX","108","Bouteille","75","FLEXO","super decor",null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H20,$C$4:$D$108,2,),VLOOKUP(I20,$C$4:$D$108,2,),\" \",VLOOKUP(J20,$C$4:$D$108,2,),VLOOKUP(K20,$C$4:$D$108,2,),\" \",VLOOKUP(L20,$C$4:$D$108,2,),\" \",M20)","v":"BOX108 BOU75 FLE super decor"},null,{"$f":"LEN(R20)","v":28}]
[null,null,"6","6",null,null,null,null,null,null,null,null,{"$f":"IF(J23>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères trop grand"}]
[null,null,"10","10"]
[null,null,"12","12",null,null,"Type MS","Nature","Trous ?","Nb de trous","Decor","Libre (18)",null,null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"24","24",null,null,"EMBALLAGE","BAC PRESENTOIR","Avec Trous","65","FLEXO","special client vip",null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H24,$C$4:$D$108,2,),VLOOKUP(I24,$C$4:$D$108,2,),\" \",VLOOKUP(J24,$C$4:$D$108,2,),\" \",VLOOKUP(K24,$C$4:$D$108,2,),\" \",L24)","v":"BACT 65 FLE special client vip"},null,{"$f":"LEN(R24)","v":30}]
[null,null,"48","48",null,null,null,null,null,null,null,{"$f":"IF(LEN(L24)>18,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"54","54"]
[null,null,"65","65",null,null,"Type MS","Nature","Capacité","Type",null,null,null,null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"80","80",null,null,"EMBALLAGE","GUILLOTINE","6","SARMENAC",null,null,null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(H28,$C$4:$D$108,2,),\" \",VLOOKUP(I28,$C$4:$D$108,2,),\" \",VLOOKUP(J28,$C$4:$D$108,2,))","v":"GUI 6 SAR"},null,{"$f":"LEN(R28)","v":9}]
[null,null,"108","108"]
[null,"Contenant","BX","BX"]
[null,"contemb","BG","BG"]
[null,null,"SPE","SPE"]
[null,null,"BIB","BIB"]
[null,null,"TETRA","TET"]
[null,"Modele","Rien"]
[null,"modelecontemb","AUTHENTIQ","AUT"]
[null,null,"AZUR","AZU"]
[null,null,"BG","BG"]
[null,null,"BOULIDOU","BOU"]
[null,null,"CALIFORN","CAL"]
[null,null,"CARACTERE","CAR"]
[null,null,"CARAFE","CAF"]
[null,null,"CLARA","CLA"]
[null,null,"DISTINCTI","DIS"]
[null,null,"ECO 2","ECO"]
[null,null,"EVOL SATI","EVS"]
[null,null,"EVOLUTION","EVO"]
[null,null,"FLUTE EVO","FLU"]
[null,null,"FLUTE OPTIMA","FLU"]
[null,null,"GDE TRAD","GDE"]
[null,null,"HELIX","HEL"]
[null,null,"LANGUEDOC","LAN"]
[null,null,"LITRE","LIT"]
[null,null,"LITRE HOLL","LHO"]
[null,null,"LITRE VT","LVT"]
[null,null,"LUX NATURA","LUX"]
[null,null,"MAESTRIA","MAE"]
[null,null,"MAGNUM","MAG"]
[null,null,"MEDIUM","MED"]
[null,null,"NATURA","NAT"]
[null,null,"NIMOISE","NIM"]
[null,null,"OPTIMA","OPT"]
[null,null,"PRIVILEGE","PRI"]
[null,null,"PROVENCE","PRO"]
[null,null,"SABINE","SAB"]
[null,null,"SARMENAC","SAR"]
[null,null,"SEDDUCCION","SED"]
[null,null,"SEDUCTION","SED"]
[null,null,"SENSATION","SEN"]
[null,null,"SPIRALE","SPI"]
[null,null,"TENDANCE","TEN"]
[null,null,"TRADITION","TRA"]
[null,null,"TUCCITANE","TUC"]
[null,null,"UCCOAR","UCC"]
[null,"Centilisation","20","20"]
[null,"centilemb","25","25"]
[null,null,"37,5","37"]
[null,null,"50","50"]
[null,null,"75","75"]
[null,null,"100","100"]
[null,null,"150","150"]
[null,null,"225","225"]
[null,null,"300","300"]
[null,null,"500","500"]
[null,null,"1000","1000"]
[null,null,"2000","2000"]
[null,"Decor","Ecru","ECR"]
[null,"decoremb","Blanc","BLC"]
[null,null,"FLEXO","FLE"]
[null,null,"OFFSET","OFF"]
[null,null,"HI FLEX","HIF"]
[null,"Finition","Standard"]
[null,"finitionemb","Predecoupe","P"]
[null,null,"Ouverture","O"]
[null,null,"Croisillon","C"]
[null,null,"Guillotine","G"]
[null,null,"Alveole","A"]
[null,"Type BIB","Carré","C"]
[null,"typebib","Rectangulaire","R"]
[null,"Box","BIB","BIB"]
[null,"typebox","Bouteille","BOU"]
[null,null,"Cubis","CUB"]
[null,"Bac","Avec Trous","T"]
[null,"typebac","Sans Trous"]
[null,"Nb trous","27","27"]
[null,"nbtrous","45","45"]
[null,null,"54","54"]
[null,null,"65","65"]
[null,"Type int","BX 150","BX 150"]
[null,"typeint","BG 150","BG 150"]
[null,null,"BX/BG 75","BX/BG 75"]
[null,null,"LITRE","LITRE"]
[null,null,"CUBIS","CUBIS"]
[null,null,"TETRA","TETRA"]
[null,null,"SARMENAC","SARMENAC"]

{"sheet":"ListeAgresHab","index":7,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"HABILLAGE",null,null,null,"AGRES",null,null,null,"Type MS","Famille","Nature","Longueur","Largeur","Libre",null,null,null,"Code",null,"Nombre de caractère"]
[null,null,null,null,null,null,null,null,null,"AGRES","Palette","EUR","1000","1200","NIMP15",null,null,null,{"$f":"CONCATENATE(VLOOKUP(K4,$G$5:$H$30,2,),\" \",VLOOKUP(L4,$G$5:$H$30,2,),\" \",M4,\"x\",N4,,\" \",O4)","v":"PAL EUR 1000x1200 NIMP15"},null,{"$f":"LEN(S4)","v":24}]
[null,"Famille","Etiquette","ETI",null,"Famille","Palette","PAL",null,null,null,null,null,null,{"$f":"IF(U4>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"famhab","Contre Etiquette","CET",null,"famagr","Emballages","EMB"]
[null,null,"Collerette","COL",null,null,"Intercalaires","INT",null,"Type MS","Famille","Nature","Hauteur","Largeur","Degré","Mill","Libre",null,"Code",null,"Nombre de caractère"]
[null,null,"Medaille","MED",null,"Nature","EUR","EUR",null,"HABILLAGE","Contre Etiquette","Traditionnel",120,90,15.5,16,"papa",null,{"$f":"CONCATENATE(VLOOKUP(K8,$C$5:$D$30,2,),VLOOKUP(L8,$C$5:$D$30,2,),\" \",M8,\"x\",N8,,\" \",O8,\" \",P8,\" \",Q8)","v":"CETT 120x90 15,5 16 papa"},null,{"$f":"LEN(S8)","v":24}]
[null,"famsti","Sticker","STK",null,"natureagr","CHEP","CHP",null,null,null,null,{"$f":"IF(LEN(M8)>3,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},{"$f":"IF(LEN(N8)>3,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},null,{"$f":"IF(LEN(P8)>2,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},{"$f":"IF(U8>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,"Affichette","AFF",null,null,"VMF","VMF"]
[null,null,"Paille","PAI",null,null,"AUTRES","DIV",null,"Type MS","Famille","Nature","Hauteur","Largeur","Libre",null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"Pendeloque","PEN",null,null,"FILM","FIL",null,"HABILLAGE","Pendeloque","Pyramide",120,90,"papa",null,null,null,{"$f":"CONCATENATE(VLOOKUP(K12,$C$5:$D$30,2,),VLOOKUP(L12,$C$5:$D$30,2,),\" \",M12,\"x\",N12,,\" \",O12)","v":"PENP  120x90 papa"},null,{"$f":"LEN(S12)","v":17}]
[null,"Nature","Traditionnel","T",null,null,"HOUSSE","HOU",null,null,null,null,{"$f":"IF(LEN(M12)>3,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},{"$f":"IF(LEN(N12)>3,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},{"$f":"IF(U12>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,"naturehab","Adhesif","A",null,null,"ANTI GLISSE","PAG"]
[null,"naturepend","Pyramide","P ",null,null,"AQUILUX","AQU",null,"Type MS","Famille","Hauteur","Largeur","Libre",null,null,null,null,"Code",null,"Nombre de caractère"]
[null,null,"Leaflet","L",null,null,null,null,null,"HABILLAGE","Sticker",120,90,"papa",null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(K16,$C$5:$D$30,2,),\" \",L16,\"x\",M16,,\" \",N16)","v":"STK 120x90 papa"},null,{"$f":"LEN(S16)","v":15}]
[null,null,null,null,null,"Dimensions","",null,null,null,null,{"$f":"IF(LEN(L16)>3,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},{"$f":"IF(LEN(M16)>3,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"},{"$f":"IF(U16>30,\"Nombre de caractères trop grand\",\"Nombre de caractères ok\")","v":"Nombre de caractères ok"}]
[null,null,null,null,null,"dimagr","400"]
[null,null,null,null,null,null,"600"]
[null,null,null,null,null,null,"800"]
[null,null,null,null,null,null,"1000"]
[null,null,null,null,null,null,"1200"]