{"text_format":"2","workbook":"xls","n_sheets":11,"sheets":["Note for Input","Sample related Data","Federal State","Legend Type of Sample","Legend QS-Type of Production","Legend Products","Legend Name of Research Method","Legend Location of Sampling","Legend Type of Cult","Legend Type DKHV","Impressum"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Note for Input","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["For each sampled Location one line has to be entered."]
["Each product gets tested by the intended examination method of the obligatory Control Plan. Optionale/ additional examination methods can be entered."]
["If several agents are found in one method, each agent has to be entered in a new line."]
[]
[]
[]
["QS-ID, Location Number and Sample-ID have to be edited as a description field, otherwise the data import could fail."]

{"sheet":"Sample related Data","index":1,"n_rows":3,"n_cols":32,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Sample-ID","Type_of_Sample","QS-Standortnummer","Type_of_Production","Name_of_Principal","QSID_Laboratory","Sampler","Product_No","Product__Name","Variety","Test_Spectrum","Date_of_Sampling","Time_of_Sampling","Sample_Quantity","Unit_of_Sample_Quantity","State_of_Origin","Federal_State_ID","Name_of_Federal_State","State_of_Determination","Location_of_Sampling","Place_of_Sampling","Producer","Distributor","Discharger","Article_Number","Type_of_Cultivating","Identification_of_Pallets","Batch_Number","Specials","Bio","QS_Sample","DKHV_Sample"]
["GH00000XXX-42924639",1,"GH00000XXX",83,"Company XYZ",null,"Sample:Paul","250144/02",null,null,"101:113","2007-09-26","09:00:00",2,"kg",276,null,null,276,1234,2,2345,3456,2345,"Article 1",2]
["The first part of the Sample-ID is the Location Number of the tested Location. The second part is an 8-digit alphanumeric Number. This can be remitted individually, but it has to be explicit and it gets tested on Uploads. If nobody enters the second part, the number will be remitted automatically by the application.","Possible Values See Key Type of Sample","Location Number (Free Text) of the tested Location. Plausibility Test on Uploads.","QS-Type of Production (See Key Type of Production)","Data Item for Sampler","QS-ID of Laboratory (Free Text). Plausibility Test on Uploads.","UserID (Login) Sampler.","See Key Product_No.","Free Text","Free Text","Method Codes are separated by : (See Key Method Codes)","Date Format dd.mm.jjjj","Time Format ss:mm","Number separated by Comma","Unit (Free Text)","Iso Code of State (276 for Germany)\nMore Codes can be found by:\nhttp://www.aufenthaltstitel.de/staaten/schluessel.html","Possible Values See Key Federal State.","Information Array for the Download. On Uploads this array is empty or the Information can be ignored.","Iso State Code (276 for Germany)","QS- Location Number of the Test Location (Plausibility Test on Uploads)","Possible Values See Key Location of Sampling","Qs- Location Number of the Producer Location (Plausibility Test on Uploads)","Qs- Location Number of the Distributor (Plausibility Test on Uploads)","Free Text","Free Text","Possible Values see Key Type of Cultivating","Free Text","Free Text"," Free Text","This column is optional. It must exist as a column if a differentiation is to be made between a QS sample and a DKHV sample. However, this only applies to the stage wholesale and only applies to potato and onion products. If nothing is entered in this column, then it is not an organic product. ","This column is optional. It must exist if a differentiation is made between a QS sample and a DKHV sample. However, this only applies to the stage wholesale and only applies to potato and onion products. If something is entered in this column, it is a QS sample. If nothing is entered in this column, then it is not a QS sample.","This column is optional. However, it must exist if a distinction is made between a QS sample and a DKHV sample. However, this only applies to the stage wholesale and only applies to potato and onion products. If something is entered in this column, it is a DKHV sample. In the case of potato samples, a distinction is made between ripening groups (for possible values, see the DKHV ripening group legend). If nothing is entered in this column, then it is not a DKHV sample."]

{"sheet":"Federal State","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Federal State ID","Federal State"]
["01 "," Schleswig-Holstein"]
["02 "," Hamburg"]
["03 "," Niedersachsen"]
["04 "," Bremen"]
["06 "," Hessen"]
["07 "," Rheinland-Pfalz"]
["08 "," Baden-Wuerttemberg"]
["09 "," Bayern"]
["10 "," Saarland"]
["12 "," Brandenburg"]
["13 "," Mecklenburg-Vorpommern"]
["14 "," Sachsen"]
["15 "," Sachsen-Anhalt"]
["16 "," Thueringen"]

{"sheet":"Legend Type of Sample","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Type of Sample","No."]
[]
["Regular Sample",1]
["Optional Sample",2]
["Open Sample",3]
["pre-harvest Sample",4]
["Follow-up Sample",5]

{"sheet":"Legend QS-Type of Production","index":4,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["QS-Type of Production","No."]
[]
["wholesale fruit, vegetables, potatoes (first-line merchant)",81]
["wholesale fruit, vegetables, potatoes (trading partner)",82]
["Logistics fruit, vegetables, potatoes",84]
["Preparation/Processing Fruit, Vegetables, Potatoes",85]
["agencies fruit, vegetables, potatoes (first-line merchant)",801]
["agencies fruit, vegetables, potatoes (trading partner)",802]
["fruit production (outdoor)",4001]
["fruit production (covered)",4002]
["fruit production (outdoor) + fruit production (covered)",4003]
["vegetable production (outdoor)",4004]
["fruit production (outdoor) + vegetable production (outdoor)",4005]
["fruit production (covered) + vegetable production (outdoor)",4006]
["fruit production (outdoor) + fruit production (covered) + vegetable production (outdoor)",4007]
["vegetable production (covered)",4008]
["fruit production (outdoor) + vegetable production (covered)",4009]
["fruit production (covered) + vegetable production (covered)",4010]
["fruit production (outdoor) + fruit production (covered) + vegetable production (covered)",4011]
["vegetable production (outdoor) + vegetable production (covered)",4012]
["fruit production (outdoor) + vegetable production (outdoor) + vegetable production (covered)",4013]
["fruit production (covered) + vegetable production (outdoor) + vegetable production (covered)",4014]
["fruit production (outdoor) + fruit production (covered) + vegetable production (outdoor) + vegetable",4015]
["food potato production",5001]
["food retail (fruit, vegetables and potatoes)",6002]
["retail food (meat an meat products, fruit, vegetables and potatoes)",6003]

{"sheet":"Legend Products","index":5,"n_rows":213,"n_cols":3,"rows_kept":213,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Products","Code No."]
["almond",120010]
["apple",130010]
["apricot",140010]
["artichoke",270050]
["aubergine",231030]
["avocado",163010]
["baby leaf",251080]
["bamboo graft",270080]
["banana",163020]
["basil",256080]
["bay leaves",256090]
["beans - dried",300010]
["beans (with pods)",260010]
["beans (without pods)",260020]
["beetroot",213010]
["blackberry",153010]
["blue table grape","151010/2"]
["brazil nut",120020]
["bread fruit; jackfruit",163090]
["broccoli",241010]
["brussels sprouts",242010]
["capsicum",231020]
["carambola",161050]
["caraway","256030/5"]
["carrot (bulk goods)","213020/1"]
["carrot (bunch)",213020]
["cashew nut",120030]
["cassava (dasheen, eddoe (japanese taro), tannia, manioc)",212010]
["cauliflower (romanesco)",241020]
["celeriac",213030]
["celery",270030]
["celery leaves; sorrel","256030/2"]
["chard",252030]
["cherimoya; rambutan",163060]
["chervil",256010]
["chestnut",120040]
["chicory",255000]
["chili peppers","231020/1"]
["chinese cabbage (indian (chinese) mustard, pak choi)",243010]
["chive",256020]
["coconut",120050]
["coloured lettuce (lollo, leaf-oak, batavia) (greenhouse)",251000]
["coloured lettuce (lollo, leaf-oak, batavia) (outdoor)","0251000/1"]
["coriander","256030/3"]
["corn (popcorn corn)",234001,"new since 01.01.2022"]
["corn (sweet corn)",234000,"new name"]
["courgette",232030]
["cowberry","154010/1"]
["craneberry",154020]
["cucumber",232010]
["cultivated blueberry",154010]
["cultivated fungi (common mushroom, oyster mushroom, shi-take)",280010]
["currant (red, black, white)",154030]
["date",161010]
["dewberry (loganberry)",153020]
["dill","256030/1"]
["durian",163100]
["edible flowers",631000]
["elderberries (wild rowan berry)",154080]
["fennel",270040]
["fig",161020]
["garden cress",251040]
["garlic",220010]
["garlic (fresh)","220010/1","new since 01.01.2021"]
["gherkin",232020]
["ginger","213040/1","new since 01.01.2022"]
["glassworts","252020/1","new since 01.01.2021"]
["gooseberry",154040]
["grapefruit (shaddocks, pomelos, sweeties, tangelo, ugli and other hybrids)",110010]
["green asparagus","270010/2"]
["green table grape","151010/1"]
["guava",163070]
["hazelnut",120060]
["head lettuce (greenhouse)","251020/1"]
["head lettuce (outdoor)",251020]
["horseradish",213040]
["iceberg lettuce (greenhouse)","251020/3"]
["iceberg lettuce (outdoor)","251020/2"]
["josta berry","154010/2"]
["kaki; japanese persimmons",161060]
["kale",243020]
["kiwi",162010]
["kiwi berry","151010/3"]
["kohlrabi (greenhouse)","244000/1"]
["kohlrabi (outdoor)",244000]
["kohlrabi leaves","243020/1"]
["kumquat",161040]
["lamb's lettuce (greenjouse)","251010/1"]
["lamb's lettuce (outdoor)",251010]
["leek",270060]
["lemon",110030]
["lentil (dried)",300020]
["lettuce (romaine; outdoor)","251020/8"]
["lime",110040]
["litchi",162020]
["loquat",130050]
["lovage","256030/4"]
["macadamia",120070]
["mandarins (clementine, tangerine and other hybrids)",110050]
["mango",163030]
["maracuja; passionfruit (granadilla)",162030]
["marjoram","256070/1"]
["medlar",130040]
["melissa","256990/2"]
["melon (muskmelon, kiwano)",233010]
["Microgreens",251041,"new since 01.01.2022"]
["mint","256080/1"]
["mizuna (leaves and sprouts of brassica spp)","251080/1"]
["morello cherry","140020/1"]
["mulberry",154060]
["nashi pear","130020/1"]
["nectarine",140030]
["okra",231040]
["olive",161030]
["onion",220020]
["onions (silverskin onions)","220020/1"]
["orange",110020]
["oregano","256070/2"]
["other fresh herbs",256990]
["other leavy brassica",243990]
["other lettuces, other salad plants incl. brassicacea",251990]
["other nuts (shelled/unshelled)",120990]
["other pulses - fresh",260990]
["other spinach and similar leaves",252990]
["other sprouts and shoots","251080/9"]
["other stem vegetables (fresh)",270990]
["others bulb vegetables",220990]
["others cane fruits",153990]
["others citrus fruit",110990]
["others cultiveted fungi",280990]
["others curcubits - edible peel",232990]
["others curcubits - inedible peel",233990]
["others flowering brassica",241990]
["others head brassica",242990]
["others mescellaneous fruits - edible peel",161990]
["others other root and tuber vegetables except sugar beet",213990]
["others other small fruit and berries",154990]
["others pome fruits",130990]
["others pulses - dried",300990]
["others small fruits - inedible peel",162990]
["others solanaceae",231990]
["others stone fruits",140990]
["others tropical root and tuber vegetables",212990]
["others, large fruits - inedible peel",163990]
["papaya; tamarillo",163040]
["parsley",256040]
["parsley (pot)","256040/1"]
["parsley root",213070]
["parsnip",213060]
["pea (with pods)",260030]
["pea (without pods)",260040]
["peach","140030/1"]
["peanut",401020]
["pear",130020]
["peas - dried",300030]
["pecan",120080]
["physalis/cape gooseberry","231010/1"]
["pieplant",270070]
["pine nuts",120090]
["pineapple",163080]
["pistachio",120100]
["plum",140040]
["pointed cabbage","242020/4"]
["pomegranate",163050]
["potato",211000]
["preparation",999999]
["prickly pear; cactus fruit; pitaya",162040]
["pseudocereals (Amaranth, Buckwheat, Chia seeds, Quinoa)",500020,"new since 01.01.2021"]
["Calabash (e.g. Calabash)","232030/002","new since 21.02.2023"]
["Squashes (e.g. Spaghetti squash, Halloween squash, Pattypan squash)","232030/008","new since 21.02.2023"]
["Musky gourd (e.g. Butternut)","233020/001","new since 21.02.2023"]
["Pumpkin (giant) (e.g. Hokkaido)","233020/003","new since 21.02.2023"]
["Pumpkin (others)","233020/1","new since 21.02.2023"]
["purslane (winter purslane (miner’s lettuce)",252020]
["quince",130030]
["radish (greenhouse)","213080/1"]
["radish (outdoor)",213080]
["raspberry",153030]
["red cabbage",242020]
["roquette",251060]
["rose hip",154050]
["rosemary",256060]
["sage",256050]
["savoy cabbage","242020/2"]
["scarole (radiccio, endivie, ...)",251030]
["shallots",22030]
["small radish (greenhouse)","213080/3"]
["small radish (outdoor)","213080/2"]
["spinach",252010]
["spring onion",220040]
["strawberry (greenhouse)","152000/1"]
["strawberry (outdoor)",152000]
["summer savory","256990/1"]
["sweet cherry",140020]
["sweet potato",212020]
["terragon",256100]
["thyme",256070]
["tomato",231010]
["topinambur",213050]
["turnip greens","252010/1"]
["vine leaf",253000]
["viper's grass",213090]
["walnut",120110]
["water cress (water convolvulus, water clovers, water mimosas)",254000]
["watermelon",233030]
["wheat germ bud",250214]
["white asparagus","270010/1"]
["white cabbage","242020/3"]
["white turnip; turnip; swedes",213110]
["wild fungi (morels, chanterelle)",280020]
["wood garlic","256990/3"]
["yams",212030]

{"sheet":"Legend Name of Research Method","index":6,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Name of Research Method","Code","Comment"]
["Mulitmethode GC",101]
["Phenoxyalkancarbonsäure",103]
["Maleeinsäurehydrazid  (QuPPe-Method)",104]
["Chlormequat/Mepiquat  (QuPPe-Method)",105]
["Ethephon (QuPPe-Methode)",107]
["Nitrate",108]
["Amitraz - Single method",109]
["Anorganisches Gesamtbromid  (QuPPe-Method)",110]
["Dithiocarbomate",112]
["Multimethode LC",113]
["Dithianon",114]
["Organozinnverbindungen",115]
["Schwefeldioxid (SO2)",116]
["Schwermetalle ",117]
["Glyphosat (QuPPe-Method)",118]
["Quaternäre Ammoniumverbindungen (QAC)",119]
["Perchlorat (QuPPe-Method)",120]
["Chlorat (QuPPe-Method)",121]
["Modifizierte Multimethode ",122]
["Haloxyfop – Single method",123]
["Fluazifop-p-butyl - Single method",124]
["Fenbutatinoxid - Single method",125]
["Morpholin (inkl. Diethanolamin, Triethanolamin) -   ",126]
["Phosphonat/Fosetyl (QuPPe-Method)",127]
["Sulfit",128]
["Chlorid",129]
["Matrine - Single method",130]
["Diquat/Paraquat",136,"new since 01.01.2021"]
["Sondermethode GC",201]
["Sondermethode LC",213]
["Zusatz-1 (QuPPe-Method)",220]
["Zusatz-2 (QuPPe-Method)",221]
["Zusatz-3 (QuPPe-Method)",222]
["Zusatz-4 (QuPPe-Method)",223]
["Zusatz-5 (QuPPe-Method)",224]

{"sheet":"Legend Location of Sampling","index":7,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Location of Sampling","No."]
[]
["Field",1]
["Inventory",2]
["Goods Receipt",3]
["Goods Issue",4]

{"sheet":"Legend Type of Cult","index":8,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Type of Cultivating","No."]
[]
["Greenhouse culture",1]
["Greenhouse/cut production",2]
["Grennhouse/pot production",3]
["Field grown culture",4]
["Field grown/cut production",5]
["Field grown/pot production",6]
["Type of cultivation unknown",10]

{"sheet":"Legend Type DKHV","index":9,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Ripening groups without 1,4-Sight application","No."]
[]
["no information on the ripening group, without 1,4-Sight application",0]
["very early variety, without 1,4-Sight application",1]
["early variety, without 1,4-Sight application",2]
["medium early variety, without 1,4-Sight application",3]
["medium late to very late variety, without 1,4-Sight application",4]
[]
["Ripening groups with 1,4-Sight application"]
[]
["no information on the ripening group, with 1,4-Sight application",10]
["very early variety, with 1,4-Sight application",11]
["early variety, with 1,4-Sight application",12]
["medium early variety, with 1,4-Sight application",13]
["medium late to very late variety, with 1,4-Sight application",14]

{"sheet":"Impressum","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}