{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FICHE DE MODIFICATION","BDD","Imp","Data","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":"FICHE DE MODIFICATION","index":0,"n_rows":21,"n_cols":31,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,"FICHE DE MODIFICATION ARTICLE",null,null,null,"N° FICHE :",{"$f":"CONCATENATE(VLOOKUP(B3,BDD!F3:I26,4,),F3)","v":"GDID180516"}]
[]
["EMETTEUR :","Isabelle DUPUIS","Service :",{"$f":"VLOOKUP(B3,BDD!$F$3:$G$60,2,)","v":"Commercial France GD "},"Date :",180516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
[]
["Site de production :","UCCOAR",null,"Motif de la demande :",null,"Changement de degré"]
[null,null,null,"Date d'effet de la demande :"]
[]
["Article à modifier :"]
[]
["Nouveau Millésime :",null,null,"Nouveau degré :"]
[]
[]
["Nombre d'unités : ",600,null,"Nombre de plans : ",5]
[]
["Type composant :","Surbouchage",null,"Composant :","Capsule",null,"Equivalent ligne nomenclature :",null,null,{"$f":"VLOOKUP(E17,BDD!$B$1:$C$30,2,)","v":34}]
[]
["Type composant :","Contenant",null,"Composant :","Outre",null,"Equivalent ligne nomenclature :",null,null,{"$f":"VLOOKUP(E19,BDD!$B$1:$C$30,2,)","v":20}]
[]
["Type composant :","Habillage",null,"Composant :","Contre Etiquette",null,"Equivalent ligne nomenclature :",null,null,{"$f":"VLOOKUP(E21,BDD!$B$1:$C$30,2,)","v":42}]

{"sheet":"BDD","index":1,"n_rows":50,"n_cols":34,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Liquide","Liquide",10,null,null,"A completer"]
["Contenant","Bouteille",20,null,null,"LISTE PERSONNES","SERVICE","Code P","Code S+P",null,null,"SERVICE","Code S",null,"SITE",null,null,"Type de modification",null,null,null,null,null,null,null,"Liste degres",null,"Liste Mill",null,"Nb de plans",null,"Nb total unites",null,"Type de composant"]
["Contenant","Outre",20,null,null,"Jocelyne KRITICOS","Direction","JK",{"$f":"CONCATENATE(VLOOKUP(G3,$L$3:$M$9,2,),H3)","v":"DIRJK"},null,null,"Direction","DIR",null,"UCCOAR",null,null,"Changement de millésime",null,null,null,null,null,null,null,6,null,2015,null,2,null,30,null,"Liquide"]
["Contenant","Cubi",20,null,null,"Marianne FAUQUE","Commercial Export","MF",{"$f":"CONCATENATE(VLOOKUP(G4,$L$3:$M$9,2,),H4)","v":"EXPMF"},null,null,"Commercial Export","EXP",null,"TRILLES",null,null,"Changement de degré",null,null,null,null,null,null,null,6.5,null,2016,null,3,4,48,null,"Contenant"]
["Contenant","Tetra",20,null,null,"Nathalie DAUNIS","Commercial Export","ND","EXPND",null,null,"Commercial France GD ","GD",null,"VIM",null,null,"Modification/Changement d’un composant de la nomenclature",null,null,null,null,null,null,null,7,null,2017,null,4,null,72,null,"Fermeture"]
["Contenant","Pouch",20,null,null,"Régine RAYNAUD","Commercial Export","RR","EXPRR",null,null,"Commercial CHR","CHR",null,null,null,null,"Duplication d’un article existant avec modification d’un ou plusieurs composants de la nomenclature",null,null,null,null,null,null,null,7.5,null,2018,null,5,null,108,null,"Surbouchage"]
["Fermeture","Bouchon",30,null,null,"Caroline BOYER","Commercial Export","CB","EXPCB",null,null,"Marketing","MKT",null,null,null,null,"Modification du plan de palettisation",null,null,null,null,null,null,null,8,null,2019,null,6,null,120,null,"Habillage"]
["Fermeture","Capsule à vis",30,null,null,"Isabelle DUPUIS","Commercial France GD ","ID","GDID",null,null,"Administration des Ventes","ADV",null,null,null,null,"Duplication d’un article existant avec changement de gencod",null,null,null,null,null,null,null,8.5,null,2020,null,7,null,128,null,"Emballage"]
["Fermeture","Opercule",30,null,null,"Peggy ANDRIEU","Commercial France GD ","PA","GDPA",null,null,"Autre service : à préciser","DIV",null,null,null,null,null,null,null,null,null,null,null,null,9,null,2021,null,8,null,144,null,"Agrès"]
["Fermeture","Cap Stream",30,null,null,"Djamal MIROUH","Commercial CHR","DM","CHRDM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5,null,2022,null,9,null,160]
["Surbouchage","Capsule",34,null,null,"Annick PRIAT","Administration des Ventes","AP","ADVAP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,2023,null,10,null,168]
["Surbouchage","Pion Fiscal",36,null,null,"Martine MARTINEZ","Commercial France GD ","MM","GDMM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5,null,2024,null,11,null,192]
["Habillage","Etiquette",40,null,null,"Jocelyne CAZAUX","Commercial Export","JC","EXPJC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,2025,null,12,null,200]
["Habillage","Contre Etiquette",42,null,null,"Sandrine JAUMOT","Commercial France GD ","SJ","GDSJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.5,null,2026,null,13,null,208]
["Habillage","Collerette",44,null,null,"Britta HANNEBERT","Commercial Export","BH","EXPBH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,14,null,210]
["Habillage","Medaille",46,null,null,"Laurence NIEL","Administration des Ventes","LN","ADVLN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.5,null,null,null,15,null,220]
["Habillage","Pendeloque",48,null,null,"Marijke CHAVANETTE","Commercial Export","MC","EXPMC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,240]
["Habillage","Sticker",50,null,null,"Christelle BOUTY","Commercial Export","CB","EXPCB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.5,null,null,null,null,null,252]
["Habillage","Affichette carton",52,null,null,"Perrine LANGUET","Autre service : à préciser","PL","DIVPL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,336]
["Emballage","Carton",60,null,null,"France AUGER","Marketing","FA","MKTFA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.5,null,null,null,null,null,432]
["Emballage","Aplat BIB",70,null,null,"Valérie MOLINIER","Marketing","VM","MKTVM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,450]
["Emballage","Regroupement",74,null,null,"Estelle LAURENT","Marketing","EL","MKTEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,null,null,null,null,480]
["Emballage","Box",60,null,null,"Mélissa ICHE","Marketing","MI","MKTMI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,504]
["Emballage","Caisse bois",60,null,null,"Qiwen GU","Commercial Export","QG","EXPQG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,510]
["Emballage","Croisillon/Alvéole",68,null,null,"Yang Bresson","Commercial Export","YB","EXPYB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,520]
["Emballage","Poignée",72,null,null,"Pu Chen","Commercial Export","PC","EXPPC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540]
["Agrès","Palette",80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,570]
["Agrès","Intercalaire",82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,576]
["Agrès","Housse/Film",84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,594]
["Agrès","Affichette palette",90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,624]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,630]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,756]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,810]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,840]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,960]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1080]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2304]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2592]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2880]

{"sheet":"Imp","index":2,"n_rows":25,"n_cols":31,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"FICHE DE MODIFICATION"]
[]
["Emetteur",null,null,null,"Date création",230516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Service",null,null,null,"N° Fiche",230516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Site de production",null,null,null,"Date d'effet de la demande",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
["Article à modifier"]
["Motif de la demande","Modification/Changement d’un composant de la nomenclature"]
[]
["Nouveau Millesime",null,null,null,"Nouveau degre"]
[]
["Nombre d'unites",null,null,null,"Nombre de plans"]
[]
["Type de composant","bdfs<gs<","Composant","edgs<s","Commentaire"]
[null,null,null,null,"Equivalent ligne Nomenclature :",{"$error":"#VALUE!"}]
["Type de composant",null,"Composant",null,"Commentaire"]
[null,null,null,null,"Equivalent ligne Nomenclature :"]
["Type de composant",null,"Composant",null,"Commentaire"]
[null,null,null,null,"Equivalent ligne Nomenclature :"]
["Type de composant",null,"Composant",null,"Commentaire"]
[null,null,null,null,"Equivalent ligne Nomenclature :"]
["Nouveau gencod bouteille",null,"Nouveau gencod carton",null,"Nouveau gencod palette"]
[]
["Nouveau gencod bouteille",null,"Nouveau gencod carton",null,"Nouveau gencod palette"]

{"sheet":"Data","index":3,"n_rows":4,"n_cols":31,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["C1","T1","T2","T3","C2","T4","T5","C3","C4","C5","C6","C7","C8","C9","T6","C11","C10","T7","C13","C12","T8","C14","C15","T9","T10","T11","T12","T13","T14","T15","Numero"]
["Emetteur","Service","Date création","N° Fiche","Site de production","Date d'effet de la demande","Article à modifier","Motif de la demande","Nouveau Millesime","Nouveau degre","Nombre d'unites","Nombre de plans","Type de composant","Composant","Commentaire","Type de composant","Composant","Commentaire","Type de composant","Composant","Commentaire","Type de composant","Composant","Commentaire","Nouveau gencod bouteille","Nouveau gencod carton","Nouveau gencod palette","Nouveau gencod palette","Nouveau gencod bouteille","Nouveau gencod carton","N° Fiche"]
["Caroline BOYER","Commercial Export",220516,"EXPCB220516",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,230516,230516,null,null,null,"Modification/Changement d’un composant de la nomenclature",null,null,null,null,null,null,null,null,null,null,null,null,null,"bdfs<gs<","edgs<s",null,null,null,null,null,null,null,4]

{"sheet":"Feuil3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}