{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overzicht_ingevoerde_artikelen","STD","Menublad","Rapport","Records","BerekendControle"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"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":"Overzicht_ingevoerde_artikelen","index":0,"n_rows":8,"n_cols":53,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Overzicht berekende meelbestanddelen"]
[" Algemeen",null,null,null," Meelbestanddelen"]
[]
["RecNr","productnaam","art.nr","datum","Graan 1","% graan 1","Graan 2","% graan 2","Graan 3","% graan 3","Graan 4","% graan 4","Graan 5","% graan 5","Graan 6","% graan 6","Graan 7","% graan 7","Graan 8","% graan 8","Graan 9","% graan 9","Graan 10","% graan 10","Graan 11","% graan 11","Graan 12","% graan 12","Graan 13","% graan 13","Graan 14","% graan 14","Graan 15","% graan 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benaming"]
[200608140724,"NBC Deelrecept 3","Meergranenbrood","2020-06-08","tarwe",50,"spelt",28.703703703703702,"rogge",19.444444444444446,"haver",1.8518518518518516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tarwespeltroggebrood of meergranenbrood"]
[200608140447,"NBC Deelrecept 2",456789,"2020-06-08","tarwe",49.090909090909093,"spelt",37.272727272727273,"gerst/gort",6.3636363636363633,"rogge",5.4545454545454541,"haver",1.8181818181818181,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"meergranenbrood"]
[200518065705,"NBC Deelrecept 1","Voorbeeldrecept webinar","2020-06-08","tarwe",95.101071564786466,"gerst/gort",2.2304612270366944,"haver",2.2237226734806921,"rogge",0.44474453469613845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bepaal een goede beschrijvende benaming"]

{"sheet":"STD","index":1,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Standaard graansoorten in PullDown:",null,null,null,null,"Bedrijfsgegevens:",null,null,null,null,null,"Gereserveerde benamingen:"]
["Nr","graansoorten",null,null,null,"Naam","Nederlands Bakkerij Centrum"]
[1,"tarwe",null,null,null,"Adres","Agro Business Park 75-83",null,null,null,null,"De relatieve percentages van de bijbehorende graansoorten in het deelrecept zijn van groot naar klein gesorteerd."]
[2,"spelt",null,null,null,"Postcode","6708PV",null,null,null,null,"Daarna wordt onderstaande flow toegepast:"]
[3,"khorasan",null,null,null,"Plaats","Wageningen"]
[4,"emmer",null,null,null,"Telefoon","+31317471212"]
[5,"farro",null,null,null,"KVK","",null,null,null,null,null,"Voorwaarden:","Gereserveerde Benaming:","Controle in recept tabblad Overzicht_ingevoerde_artikelen"]
[6,"eenkoorn"]
[7,"durum",null,null,null,null,null,null,null,null,null,"1e graansoort","1e graansoort % >=98%","[1e graansoort]brood","1e graansoort % >= 98"]
[8,"rijst"]
[9,"rogge"]
[10,"gerst/gort"]
[11,"maïs",null,null,null,null,null,null,null,null,null,"1e twee graansoorten","1e twee graansoorten % >= 98%","[1e graansoort][2e graansoort]brood","Som van 1e en 2e graansoort % >=98"]
[12,"haver",null,null,null,null,null,null,null,null,null,null,"elke soort minimaal 5%",null,"zowel 1e en 2e graansoort % >= 5"]
[13,"gierst/millet"]
[14,"sorghum"]
[15,"teff"]
[16,"triticale",null,null,null,null,null,null,null,null,null,"1e drie graansoorten","1e drie graansoorten % >= 98%","[1e graansoort][2e graansoort][3e graansoort]brood","Som van 1e drie graansoort % >=98"]
[17,"kanariezaad",null,null,null,null,null,null,null,null,null,null,"elke soort minimaal 5%",null,"zowel 1e, 2e en 3e graansoort % >= 5"]
[18,"jobstranen"]
[19,"fonio"]
[20,"tritordeum"]
[21,"boekweit",null,null,null,null,null,null,null,null,null,null,"Meer graansoorten","1e graansoort % <=90%","meergranenbrood","1e graansoort % <=90"]
[22,"quinoa",null,null,null,null,null,null,null,null,null,null,null,"minimaal 3 graansoorten",null,"minimaal 3 graansoorten aanwezig"]
[23,"amarant"]
[24,"wilde rijst"]

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

{"sheet":"Rapport","index":3,"n_rows":179,"n_cols":8,"rows_kept":179,"cut":false,"hidden":false,"merged":[[158,1,159,3],[158,5,159,7],[13,1,14,3],[13,5,14,7],[38,1,39,3],[38,5,39,7],[34,2,34,3],[34,6,34,7],[35,2,35,3],[35,6,35,7],[36,2,36,3],[36,6,36,7],[37,2,37,3],[37,6,37,7],[69,2,69,3],[69,6,69,7],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[70,2,70,3],[70,6,70,7],[71,2,71,3],[71,6,71,7],[72,2,72,3],[72,6,72,7],[94,2,94,3],[94,6,94,7],[73,1,74,3],[73,5,74,7],[95,2,95,3],[95,6,95,7],[96,2,96,3],[96,6,96,7],[97,2,97,3],[97,6,97,7],[129,2,129,3],[129,6,129,7],[130,2,130,3],[130,6,130,7],[98,1,99,3],[98,5,99,7],[131,2,131,3],[131,6,131,7],[132,2,132,3],[132,6,132,7],[157,2,157,3],[157,6,157,7],[154,2,154,3],[154,6,154,7],[155,2,155,3],[155,6,155,7],[156,2,156,3],[156,6,156,7],[133,1,134,3],[133,5,134,7]]}
[]
[null,"Meelbestanddelen berekening"]
[]
[null,"Bedrijfsnaam",{"$f":"STD!$G$5","v":"Nederlands Bakkerij Centrum"}]
[null,"Adres",{"$f":"STD!$G$6","v":"Agro Business Park 75-83"}]
[null,"Postcode Plaats",{"$f":"STD!$G$7&\" \"&STD!$G$8","v":"6708PV Wageningen"}]
[]
[]
[]
[null,"RecNr",200529113620,null,null,"RecNr",200518065705]
[null,"Productnaam","4 mouten volkoren",null,null,"Productnaam","NBC Deelrecept"]
[null,"Artikel omschrijving","bruin meergranenbrood",null,null,"Artikel omschrijving","Voorbeeld deelrecept"]
[null,"Datum","2020-06-05",null,null,"Datum","2020-06-05"]
[null,"meergranenbrood",null,null,null,"Bepaal een goede beschrijvende benaming"]
[]
[null,"tarwe",87.529691211401428,{"$f":"IF(C16>0,\"%\",\"\")","v":"%"},null,"tarwe",95.101071564786466,{"$f":"IF(G16>0,\"%\",\"\")","v":"%"}]
[null,"rogge",5.3444180522565317,{"$f":"IF(C17>0,\"%\",\"\")","v":"%"},null,"gerst/gort",2.2304612270366944,{"$f":"IF(G17>0,\"%\",\"\")","v":"%"}]
[null,"spelt",4.9485352335708628,"%",null,"haver",2.2237226734806921,"%"]
[null,"gerst/gort",2.1773555027711797,"%",null,"rogge",0.44474453469613845,"%"]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,"RecNr",null,null,null,"RecNr"]
[null,"Productnaam",null,null,null,"Productnaam"]
[null,"Artikel omschrijving",null,null,null,"Artikel omschrijving"]
[null,"Datum",null,null,null,"Datum"]
[]
[]
[null,null,null,{"$f":"IF(C41>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G41>0,\"%\",\"\")","v":""}]
[null,null,null,{"$f":"IF(C42>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G42>0,\"%\",\"\")","v":""}]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[]
[]
[null,"Meelbestanddelen berekening"]
[]
[null,"Bedrijfsnaam",{"$f":"STD!$G$5","v":"Nederlands Bakkerij Centrum"}]
[null,"Adres",{"$f":"STD!$G$6","v":"Agro Business Park 75-83"}]
[null,"Postcode Plaats",{"$f":"STD!$G$7&\" \"&STD!$G$8","v":"6708PV Wageningen"}]
[]
[]
[]
[null,"RecNr",null,null,null,"RecNr"]
[null,"Productnaam",null,null,null,"Productnaam"]
[null,"Artikel omschrijving",null,null,null,"Artikel omschrijving"]
[null,"Datum",null,null,null,"Datum"]
[]
[]
[null,null,null,{"$f":"IF(C76>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G76>0,\"%\",\"\")","v":""}]
[null,null,null,{"$f":"IF(C77>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G77>0,\"%\",\"\")","v":""}]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,"RecNr",null,null,null,"RecNr"]
[null,"Productnaam",null,null,null,"Productnaam"]
[null,"Artikel omschrijving",null,null,null,"Artikel omschrijving"]
[null,"Datum",null,null,null,"Datum"]
[]
[]
[null,null,null,{"$f":"IF(C101>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G101>0,\"%\",\"\")","v":""}]
[null,null,null,{"$f":"IF(C102>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G102>0,\"%\",\"\")","v":""}]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[]
[]
[null,"Meelbestanddelen berekening"]
[]
[null,"Bedrijfsnaam",{"$f":"STD!$G$5","v":"Nederlands Bakkerij Centrum"}]
[null,"Adres",{"$f":"STD!$G$6","v":"Agro Business Park 75-83"}]
[null,"Postcode Plaats",{"$f":"STD!$G$7&\" \"&STD!$G$8","v":"6708PV Wageningen"}]
[]
[]
[]
[null,"RecNr",null,null,null,"RecNr"]
[null,"Productnaam",null,null,null,"Productnaam"]
[null,"Artikel omschrijving",null,null,null,"Artikel omschrijving"]
[null,"Datum",null,null,null,"Datum"]
[]
[]
[null,null,null,{"$f":"IF(C136>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G136>0,\"%\",\"\")","v":""}]
[null,null,null,{"$f":"IF(C137>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G137>0,\"%\",\"\")","v":""}]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,"RecNr",null,null,null,"RecNr"]
[null,"Productnaam",null,null,null,"Productnaam"]
[null,"Artikel omschrijving",null,null,null,"Artikel omschrijving"]
[null,"Datum",null,null,null,"Datum"]
[]
[]
[null,null,null,{"$f":"IF(C161>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G161>0,\"%\",\"\")","v":""}]
[null,null,null,{"$f":"IF(C162>0,\"%\",\"\")","v":""},null,null,null,{"$f":"IF(G162>0,\"%\",\"\")","v":""}]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]
[null,null,null,"",null,null,null,""]

{"sheet":"Records","index":4,"n_rows":8,"n_cols":100,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Berekening meelbestanddeel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Berekeningen"]
[" Algemeen",null,null,null," Meelbestanddelen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mix-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,null,null,null,"Mix-2"]
[]
["RecNr","productnaam","art.nr","datum","Meel-%","Graan 1","% graan 1","Type graan 1","Graan 2","% graan 2","Type graan 2","Graan 3","% graan 3","Type graan 3","Graan 4","% graan 4","Type graan 4","Graan 5","% graan 5","Type graan 5","Graan 6","% graan 6","Type graan 6","Graan 7","% graan 7","Type graan 7","Graan 8","% graan 8","Type graan 8","Graan 9","% graan 9","Type graan 9","Graan 10","% graan 10","Type graan 10","Mix-1%","productnaam Mix-1","bestanddeel\nMix1-1","aandeel\n%Mix1-1","type graan\nMix1-1","bestanddeel\nMix1-2","aandeel\n%Mix1-2","type graan\nMix1-2","bestanddeel\nMix1-3","aandeel\n%Mix1-3","type graan\nMix1-3","bestanddeel\nMix1-4","aandeel\n%Mix1-4","type graan\nMix1-4","bestanddeel\nMix1-5","aandeel\n%Mix1-5","type graan\nMix1-5","bestanddeel\nMix1-6","aandeel\n%Mix1-6","type graan\nMix1-6","bestanddeel\nMix1-7","aandeel\n%Mix1-7","type graan\nMix1-7","bestanddeel\nMix1-8","aandeel\n%Mix1-8","type graan\nMix1-8","bestanddeel\nMix1-9","aandeel\n%Mix1-9","type graan\nMix1-9","bestanddeel\nMix1-10","aandeel\n%Mix1-10","type graan\nMix1-10","Mix-2%","productnaam Mix-2","bestanddeel\nMix2-1","aandeel\n%Mix2-1","type graan\n Mix2-1","bestanddeel\nMix2-2","aandeel\n%Mix2-2","type graan\n Mix2-2","bestanddeel\nMix2-3","aandeel\n%Mix2-3","type graan\n Mix2-3","bestanddeel\nMix2-4","aandeel\n%Mix2-4","type graan\n Mix2-4","bestanddeel\nMix2-5","aandeel\n%Mix2-5","type graan\n Mix2-5","bestanddeel\nMix2-6","aandeel\n%Mix2-6","type graan\n Mix2-6","bestanddeel\nMix2-7","aandeel\n%Mix2-7","type graan\n Mix2-7","bestanddeel\nMix2-8","aandeel\n%Mix2-8","type graan\n Mix2-8","bestanddeel\nMix2-9","aandeel\n%Mix2-9","type graan\n Mix2-9","bestanddeel\nMix2-10","aandeel\n%Mix2-10","type graan\n Mix2-10","Totaal relatief aandeel"]
[200608140724,"NBC Deelrecept 3","Meergranenbrood","2020-06-08",100,"Tarwebloem",50,"tarwe","Speltbloem",30,"spelt","Roggemeel",15,"rogge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Kleinbroodpoeder","Tarwebloem",20,"tarwe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Meergranenmix","Haverkorrels",10,"haver","Speltvlokken",5,"spelt","Roggemeel",30,"rogge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108]
[200608140447,"NBC Deelrecept 2",456789,"2020-06-08",100,"Tarwebloem",50,"tarwe","Speltmeel",40,"spelt","Gerstemoutmeel",7,"gerst/gort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Kleinbroodpoeder","Tarwebloem",20,"tarwe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Meergranenmix","Haverkorrels",10,"haver","Speltvlokken",5,"spelt","Roggemeel",30,"rogge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110]
[200518065705,"NBC Deelrecept 1","Voorbeeldrecept webinar","2020-06-08",67,"volkorentarwemeel","95,44","tarwe","gerstemoutmeel","0,5","gerst/gort","moutmeel tarwe","0,03","tarwe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"Mix","volkorentarwemeel",20,"tarwe","haverkorrels",5,"haver","gerstemoutmeel",4,"gerst/gort","zuurdesem rogge",1,"rogge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.1999]

{"sheet":"BerekendControle","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Productnaam",null,"NBC Deelrecept 2"]
[null,"totaal percentage graanbestanddelen (% granen)",null,null,{"$f":"SUM($E$11:$E$100)","v":100}]
[null,"gereserveerde aanduiding",null,"meergranenbrood"]
[]
[]
[null,"Totalen van:","% samenstelling grondstoffen","relatief aandeel granen in meelbestanddeel\n (= meel en mix)","% granen in meelbestanddeel\n (= meel en mix)"]
[]
[null,"tarwe",70,54,49.090909090909093]
[null,"spelt",45,41,37.272727272727273]
[null,"gerst/gort",7,7,6.3636363636363633]
[null,"rogge",30,6,5.4545454545454541]
[null,"haver",10,2,1.8181818181818181]