{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fichier général","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":"Fichier général","index":0,"n_rows":40,"n_cols":64,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["HYBRID           2011-2012","GROWER NAME","CONTRACT NUMBER","Growing Area","HA","Harvested Acreage (Ha)","Moisture (%)","Récolté","Received Raw Qty screen Kg","SAP RAW BATCH","SAP                               RAW\nMaterial","SAP                                                         RAW\nProces order","dif",55,"Size Name","Minisizing Bottom Screen","Minisizing Top Screen","Minisizing %","Minisizing Est. Thousand Seed Weight","Plan Week for Completion","Sizing Bottom Screen","Sizing Top Screen ","Received Quantity Ready Finish(Kg)","Official RDY Lot Number","Vendor RDY Lot Number","SAP                RDY\nBATCH"," SAP          RDY              \nMaterial"," SAP                                            RDY\nProces  Order","Dif","SAP         RDY      (Enter Qty )","Germination Value%","Moisture Content %","Thousand seed weight (g)","Specific Purity %","Naked Seeds %","Nb of Sclerotes per KG","Nb of sticks per KG","NB of Foreign Seeds","10-Electro Gen Purity%","11-Electro Selfs%","12-Electro Outcross%","02-Germination Value%","03-Moisture Content %","04-Thousand Seed Weight (g)","05-Specific Purity %","06-Naked Seeds %","07-Nb of Sclerotes per KG","08-Nb of sticks per KG","09-NB of Foreign Seeds","UD","# UNITS1"," BAG WEIGHT1 (KG)","# UNITS2"," BAG WEIGHT2 (KG)","Total Number Of bags","Total Quantiy Packed (kg)","SAP                             RDY  BG  Material"," SAP                                              RDY BG                                                   Proces  Order","SAP                       RDY  BG                    BATCH","SAP                           RDY BG                           (Enter Qté )","Dif","Echantillons RAW","Echantillons ready","info micro"]
["NK brio","lucie",1,null,41,234,3536,24556,4156,45,561,13241,4156,45,"M",null,null,null,null,null,null,null,545,null,null,455,5617,59456415,null,"ju",455,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,563,57,null,null,null,"ds",4147,564465,null,457,null,"df",1]
["NK brio","lucie",1,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,12345,null,null,4442]
["NK brio","lucie",25,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,2]
["NK brio","lucie",25,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,35798]
["NK brio","pierre",2,null,42,12345,23456,345678,543,1,5,24,543,"rf","M",null,null,null,null,null,null,null,11,null,null,5,685,12,null,125,542,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,78,589,null,null,null,"fdg",456,1,"tyui",null,"15 juin","2013-06-18",1]
["NK brio","pierre",2,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,31]
["NK brio","jean",3,null,43,35,35,35355,6354,21,1,5,5,545,"M",null,null,null,null,null,null,null,122,null,null,41,4,2121,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,"v",135,3157,null,null,null,"18 juin"]
["NK brio","jean",3,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,12]
["NK brio","damien",4,null,44,25,8,4564,3,5,571,56,6354,4555664,"M",null,null,null,null,null,1234,456,450,null,null,0,413,21,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,"fdg",1735,53,null,null,"2013-06-16"]
["NK brio","raph",5,null,45,null,null,null,3654,65,5,4,3,"test","M",null,null,null,null,null,null,null,null,null,null,10,13,12,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,"vf",4135,15]
["NK brio","suzan",6,null,46,null,null,null,3,456,1,54,3654,"erfez","M",null,null,null,null,null,null,null,null,null,null,20,24,54,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,"svf",17,867,null,null,"23 JUIN"]
["NK brio","elsa",7,null,47,null,null,null,6,71,2,32,3,456879,"M",null,null,null,null,null,"SUT","FFHF",null,null,null,15,987,78,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,"cfsd",5317,8]
["NK brio","elsa",7,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,5765]
["NK brio","erick",8,null,48,null,null,null,354,57,124,1,null,"grytrf","M",null,null,null,null,null,null,null,null,null,null,4,4,45,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,"dwsw",68,13]
["NK brio","anne",9,null,49,null,null,null,3,185,null,321,6,"dsgffd","M",null,null,null,null,null,null,null,null,null,null,5,1236,21,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,"s",718,86]
["NK brio","anne",9,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,354]
["NK brio","marie",10,null,50,null,null,null,345,715,7,32,null,"hfg","M",null,null,null,null,null,"e","r",null,null,null,1114,7,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,"dwsw",7,7]
["NK brio","jessica",11,null,51,null,null,null,3543,71,4,123,null,null,"M",null,null,null,null,null,null,null,null,null,null,5405,351,354,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,"c",45,643]
["NK brio","jessica",11,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,735]
["NK Neoma","perrine",12,null,52,null,null,null,31,671,23,1,null,null,"M",null,null,null,null,null,null,null,null,null,null,432,3,2,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,"dwsw",1,46]
["NK Neoma","laura",13,null,53,null,null,null,3,67,1,231,354,null,"M",null,null,null,null,null,null,null,432,null,null,43414,7,1,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,"<",796,8]
["NK Neoma","laura",13,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,86541]
["NK Neoma","gabriel",14,null,54,null,null,null,1561476,6817,327,null,3,456,"M",null,null,null,null,null,null,null,1,null,null,34,68541,702,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,"dfs",761,735]
["NK Neoma","elodie",15,null,55,null,null,null,456,857,56,null,null,null,"M",null,null,null,null,null,null,null,354,null,null,53,4654,357,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,"fd",6987,4]
["NK Neoma","claire ",16,null,56,null,null,null,56,1687,32,null,null,3455,"M",null,null,null,null,null,145,789,32,null,null,1435,46,7,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,"dsc",671,84]
["NK Neoma","sylvie",17,null,57,null,null,null,45,1671,4,null,345,null,"M",null,null,null,null,null,null,null,456,null,null,145,763,68,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,"s",687,367]
["Delfi","jules ",18,null,58,null,null,null,345678,856,50,null,null,null,"M",null,null,null,null,null,null,null,74,null,null,31435,4534,42,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,"cqd",6917,5]
["Delfi","jules ",18,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,7864]
["Delfi","dorothée",19,null,59,null,null,null,"SDGG",718,2,null,null,null,"M",null,null,null,null,null,null,null,354,null,null,145,200,135,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,"d",68,4135]
["Delfi","mathieu",20,null,60,null,null,null,"ffgdfhrt",718,null,null,null,4,"M",null,null,null,null,null,null,null,35,null,null,145,32,7,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,"sc",7469,5346]
["Delfi","mathieu",20,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,5767]
["Delfi","dominique",21,null,61,null,null,null,4564,71,null,null,3543,null,"M",null,null,null,null,null,null,null,153,null,null,341,6,351,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,"dcf",81796,5456]
["Delfi","patrick",22,null,62,null,null,null,4589,817,null,null,null,null,"M",null,null,null,null,null,null,null,768,null,null,53,4,5,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,"sd",6817,4352]
["Delfi","michele ",23,null,63,null,null,null,"qeds",817,null,null,31,null,"M",null,null,null,null,null,null,null,465,null,null,435,1,73,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,"scf",61,4352]
["Delfi","Luc",24,null,64,null,null,null,452667,8,null,null,3,null,"M",null,null,null,null,null,null,null,7,null,null,41,357,456,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,"sd",76,534]
["Delfi","damien",27,null,null,"qde",null,null,12345,17,null,null,null,null,"M",null,null,null,null,null,null,null,null,null,null,4654]
["Delfi","damien",27,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,641]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,22,23,24,25,26]

{"sheet":"Feuil1","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"lucieaup - 14 août 2013 à 11:42 "]
[null,null,"Bonjour,"]
[null,null,"Merci pour votre aide. je vais essayer d'expliquer clairement."]
[null,null,"En colonne B j'ai le nom de mes agriculteurs qui est saisi, en colonne C j'ai leur numéro de contrat. \nIl se peut qu'un agriculteur ait plusieurs contrats. Durant le process, avec un numéro de contrat, on peut être amené à faire plusieurs calibres nommés M ou L et saisis dans la colonne O. J'ai déjà fait une macro qui ajoute une ligne en cas de deux calibres, le nomme et recopie le nom de l'agri, et son numéro de contrat."]
[null,null,"Ce que je voudrais aujourd'hui, c'est que lorsque l'utilisateur va vouloir saisir son poid final, il appuie sur un bouton, un formulaire apparait avec deux première combobox,\n il peut saisir le nom de l'agri dans la première combo dans ce cas, la deuxième s'alimente avec le ou les numéros de contrat correspondant ou le numéro de contrat directement dans la deuxième et la remière s'alimente avec le nom de l'agri. En dessous, il y a une troisième combobox qui apparait avec le choix du calibre s'il y en a deux ou le calibre unique qui s'affiche. Une text box se remplie alors automatiquement avec le numéro de série (colonne Z) puis l'utilisateur saisi le poids. Ce poids doit se recopier colonne W sur la bonne ligne c'est a dire définie par l'agriculteur, le numéro de contrat et le calibre."]
[]
[null,null,"Une partie du code est déjà crée pour alimenter la première combobox et le formulaire aussi pour mieux comprendre. Tout est dans le fichier ci joint."]
[]
[null,null,"http://cjoint.com/?CHnjoTKvWDT"]
[]
[null,null,"Encore une fois, merci beaucoup"]