{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["grondstoffen","e-mail","data"],"not_rendered":{"macros":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"grondstoffen","index":0,"n_rows":40,"n_cols":27,"rows_kept":40,"merged":[[2,2,2,3],[2,4,2,7],[3,2,3,3],[3,4,3,7],[5,5,5,7],[7,2,7,7],[9,5,9,7],[10,3,10,4],[10,5,10,7],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[17,3,17,4],[18,3,18,4],[22,2,22,7],[25,5,25,7],[26,2,27,2],[26,3,27,4],[26,5,27,6],[26,7,27,7],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4]]}
[{"$nulls":26},"maak een keuze"]
[{"$nulls":26},{"$f":"data!B2","v":"aardappelen"}]
[null,null,"Kandidaatnaam:",{"$nulls":23},{"$f":"data!B3","v":"aardbeien"}]
[null,null,"Kandidaatnummer:",{"$nulls":23},{"$f":"data!B4","v":"halfvolle melk"}]
[{"$nulls":26},{"$f":"data!B5","v":"halfvolle yoghurt"}]
[{"$nulls":4},"kies een grondstof:","maak een keuze",{"$nulls":20},{"$f":"data!B6","v":"kipfilet"}]
[{"$nulls":26},{"$f":"data!B7","v":"kruidenroomkaas"}]
[null,null,"grondstoffenkaart",{"$nulls":23},{"$f":"data!B8","v":"peren"}]
[{"$nulls":26},{"$f":"data!B9","v":"uien"}]
[null,null,"artikelnr.","omschrijving",null,"naam leverancier",{"$nulls":20},{"$f":"data!B10","v":"vanillevla"}]
[null,null,{"$f":"IFERROR(IF(INDEX(data!A:A,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!A:A,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IF(OR(F6=\"maak een keuze\",F6=\"\"),\"\",F6)","v":""},null,"Organics Groothandel",{"$nulls":20},{"$f":"data!B11","v":"verse knoflook"}]
[{"$nulls":5},"eenheid: ",null,{"$f":"IFERROR(IF(INDEX(data!D:D,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!D:D,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$nulls":18},{"$f":"data!B12","v":"winterwortels"}]
[{"$nulls":5},"besteleenheid: ",null,{"$f":"IFERROR(IF(INDEX(data!C:C,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!C:C,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$nulls":18},{"$f":"data!B13","v":"zonnebloemolie"}]
[{"$nulls":5},"maximumvoorraad: ",null,{"$f":"IFERROR(IF(INDEX(data!E:E,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!E:E,MATCH($F$6,data!$B:$B,0))),\"\")","v":""}]
[{"$nulls":5},"minimumvoorraad: ",null,{"$f":"IFERROR(IF(INDEX(data!F:F,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!F:F,MATCH($F$6,data!$B:$B,0))),\"\")","v":""}]
[]
[null,null,"datum","omschrijving",null,"bij  ","af","saldo"]
[null,null,{"$f":"IFERROR(IF(INDEX(data!G:G,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!G:G,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(data!H:H,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!H:H,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(data!I:I,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!I:I,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(data!J:J,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!J:J,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(data!K:K,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!K:K,MATCH($F$6,data!$B:$B,0))),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(INDEX(data!L:L,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!L:L,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(data!M:M,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!M:M,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},null,{"$f":"IFERROR(IF(INDEX(data!N:N,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!N:N,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(data!O:O,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!O:O,MATCH($F$6,data!$B:$B,0))),\"\")","v":""},{"$f":"IFERROR(IF(INDEX(data!P:P,MATCH($F$6,data!$B:$B,0))=\"\",\"\",INDEX(data!P:P,MATCH($F$6,data!$B:$B,0))),\"\")","v":""}]
[]
[]
[]
[null,null,"intern bestelformulier"]
[{"$nulls":5},""]
[{"$nulls":6},"datum: ",{"$f":"NOW()","v":"2017-09-04T16:12:39.210"}]
[]
[null,null,"artikelnr.","omschrijving",null,"besteleenheid",null,"aantal te bestellen eenheden"]
[]
[null,null,{"$f":"data!A2","v":"12.21.231"},{"$f":"data!B2","v":"aardappelen"},null,{"$f":"data!C2","v":1},{"$f":"data!D2","v":"kilo"}]
[null,null,{"$f":"data!A3","v":"17.11.011"},{"$f":"data!B3","v":"aardbeien"},null,{"$f":"data!C3","v":1},{"$f":"data!D3","v":"kilo"}]
[null,null,{"$f":"data!A4","v":"14.22.454"},{"$f":"data!B4","v":"halfvolle melk"},null,{"$f":"data!C4","v":1},{"$f":"data!D4","v":"liter"}]
[null,null,{"$f":"data!A5","v":"14.23.666"},{"$f":"data!B5","v":"halfvolle yoghurt"},null,{"$f":"data!C5","v":1},{"$f":"data!D5","v":"liter"}]
[null,null,{"$f":"data!A6","v":"16.12.054"},{"$f":"data!B6","v":"kipfilet"},null,{"$f":"data!C6","v":1},{"$f":"data!D6","v":"kilo"}]
[null,null,{"$f":"data!A7","v":"14.12.128"},{"$f":"data!B7","v":"kruidenroomkaas"},null,{"$f":"data!C7","v":1},{"$f":"data!D7","v":"kilo"}]
[null,null,{"$f":"data!A8","v":"12.15.701"},{"$f":"data!B8","v":"peren"},null,{"$f":"data!C8","v":1},{"$f":"data!D8","v":"kilo"}]
[null,null,{"$f":"data!A9","v":"12.11.331"},{"$f":"data!B9","v":"uien"},null,{"$f":"data!C9","v":1},{"$f":"data!D9","v":"kilo"}]
[null,null,{"$f":"data!A10","v":"14.25.641"},{"$f":"data!B10","v":"vanillevla"},null,{"$f":"data!C10","v":1},{"$f":"data!D10","v":"liter"}]
[null,null,{"$f":"data!A11","v":"12.12.276"},{"$f":"data!B11","v":"verse knoflook"},null,{"$f":"data!C11","v":1},{"$f":"data!D11","v":"kilo"}]
[null,null,{"$f":"data!A12","v":"12.11.488"},{"$f":"data!B12","v":"winterwortels"},null,{"$f":"data!C12","v":1},{"$f":"data!D12","v":"kilo"}]
[null,null,{"$f":"data!A13","v":"18.12.202"},{"$f":"data!B13","v":"zonnebloemolie"},null,{"$f":"data!C13","v":1},{"$f":"data!D13","v":"liter"}]

{"sheet":"e-mail","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"merged":[[5,2,5,3]]}
[]
[]
[null,null,"Kandidaatnaam:",{"$f":"grondstoffen!E3","v":0}]
[null,null,"Kandidaatnummer:",{"$f":"grondstoffen!E4","v":0}]
[]
[null,null,"e-mail"]
[]
[null,null,"Aan:"]
[null,null,"CC:"]
[null,null,"Onderwerp:"]
[]
[null,null,"Bericht:"]

{"sheet":"data","index":2,"n_rows":13,"n_cols":16,"rows_kept":13,"hidden":true}
["artikelnr.","omschrijving","besteleenheid","eenheid","maximumvoorraad","minimumvoorraad","datum1","omschrijving1","bij1","af1","saldo1","datum2","omschrijving2","bij2","af2","saldo2"]
["12.21.231","aardappelen",1,"kilo",40,20,{"$f":"NOW()-14","v":"2017-08-21T16:12:39.210"},"voorraad",null,null,38,{"$f":"NOW()-5","v":"2017-08-30T16:12:39.210"},"gebruikt",null,10,{"$f":"K2+N2-O2","v":28}]
["17.11.011","aardbeien",1,"kilo",8,4,{"$f":"NOW()-4","v":"2017-08-31T16:12:39.210"},"voorraad",null,null,7,{"$f":"NOW()-1","v":"2017-09-03T16:12:39.210"},"gebruikt",null,1,6]
["14.22.454","halfvolle melk",1,"liter",40,20,{"$f":"NOW()-7","v":"2017-08-28T16:12:39.210"},"voorraad",null,null,40,{"$f":"NOW()-3","v":"2017-09-01T16:12:39.210"},"gebruikt",null,8,32]
["14.23.666","halfvolle yoghurt",1,"liter",40,20,{"$f":"NOW()-9","v":"2017-08-26T16:12:39.210"},"voorraad",null,null,27,{"$f":"NOW()-4","v":"2017-08-31T16:12:39.210"},"gebruikt",null,9,18]
["16.12.054","kipfilet",1,"kilo",20,14,{"$f":"NOW()-12","v":"2017-08-23T16:12:39.210"},"voorraad",null,null,27,{"$f":"NOW()-6","v":"2017-08-29T16:12:39.210"},"gebruikt",null,11,16]
["14.12.128","kruidenroomkaas",1,"kilo",8,4,{"$f":"NOW()-14","v":"2017-08-21T16:12:39.210"},"voorraad",null,null,7,{"$f":"NOW()-5","v":"2017-08-30T16:12:39.210"},"gebruikt",null,1,6]
["12.15.701","peren",1,"kilo",120,60,{"$f":"NOW()-10","v":"2017-08-25T16:12:39.210"},"voorraad",null,null,82,{"$f":"NOW()-5","v":"2017-08-30T16:12:39.210"},"gebruikt",null,27,55]
["12.11.331","uien",1,"kilo",16,8,{"$f":"NOW()-30","v":"2017-08-05T16:12:39.210"},"voorraad",null,null,15,{"$f":"NOW()-12","v":"2017-08-23T16:12:39.210"},"gebruikt",null,3,12]
["14.25.641","vanillevla",1,"liter",40,20,{"$f":"NOW()-11","v":"2017-08-24T16:12:39.210"},"voorraad",null,null,22,{"$f":"NOW()-4","v":"2017-08-31T16:12:39.210"},"gebruikt",null,8,14]
["12.12.276","verse knoflook",1,"kilo",1.6,0.8,{"$f":"NOW()-17","v":"2017-08-18T16:12:39.210"},"voorraad",null,null,1.5,{"$f":"NOW()-11","v":"2017-08-24T16:12:39.210"},"gebruikt",null,0.1,1.4]
["12.11.488","winterwortels",1,"kilo",48,24,{"$f":"NOW()-20","v":"2017-08-15T16:12:39.210"},"voorraad",null,null,44,{"$f":"NOW()-8","v":"2017-08-27T16:12:39.210"},"gebruikt",null,14,30]
["18.12.202","zonnebloemolie",1,"liter",5,2,{"$f":"NOW()-40","v":"2017-07-26T16:12:39.210"},"voorraad",null,null,5,{"$f":"NOW()-9","v":"2017-08-26T16:12:39.210"},"gebruikt",null,1,4]