{"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":36,"n_cols":27,"rows_kept":36,"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]]}
[{"$nulls":26},"maak een keuze"]
[{"$nulls":26},{"$f":"data!B2","v":"aardappelen"}]
[null,null,"Kandidaatnaam:",{"$nulls":23},{"$f":"data!B3","v":"appels"}]
[null,null,"Kandidaatnummer:",{"$nulls":23},{"$f":"data!B4","v":"halfvolle melk"}]
[{"$nulls":26},{"$f":"data!B5","v":"kipfilet"}]
[{"$nulls":4},"kies een grondstof:","maak een keuze",{"$nulls":20},{"$f":"data!B6","v":"kruidenroomkaas"}]
[{"$nulls":26},{"$f":"data!B7","v":"spinazie"}]
[null,null,"grondstoffenkaart",{"$nulls":23},{"$f":"data!B8","v":"verse knoflook"}]
[{"$nulls":26},{"$f":"data!B9","v":"zonnebloemolie"}]
[null,null,"artikelnr.","omschrijving",null,"naam leverancier"]
[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":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":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":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":"2023-11-02T14:32:55.370"}]
[]
[null,null,"artikelnr.","omschrijving",null,"bestel-eenheid",null,"aantal te bestellen eenheden"]
[]
[null,null,{"$f":"data!A2","v":"12.21.231"},{"$f":"data!B2","v":"aardappelen"},null,{"$f":"data!C2","v":5},{"$f":"data!D2","v":"kilo"}]
[null,null,{"$f":"data!A3","v":"12.11.011"},{"$f":"data!B3","v":"appels"},null,{"$f":"data!C3","v":30},{"$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":5},{"$f":"data!D4","v":"liter"}]
[null,null,{"$f":"data!A5","v":"16.12.054"},{"$f":"data!B5","v":"kipfilet"},null,{"$f":"data!C5","v":4},{"$f":"data!D5","v":"kilo"}]
[null,null,{"$f":"data!A6","v":"14.12.128"},{"$f":"data!B6","v":"kruidenroomkaas"},null,{"$f":"data!C6","v":1},{"$f":"data!D6","v":"kilo"}]
[null,null,{"$f":"data!A7","v":"12.11.488"},{"$f":"data!B7","v":"spinazie"},null,{"$f":"data!C7","v":10},{"$f":"data!D7","v":"kilo"}]
[null,null,{"$f":"data!A8","v":"12.12.276"},{"$f":"data!B8","v":"verse knoflook"},null,{"$f":"data!C8","v":1},{"$f":"data!D8","v":"kilo"}]
[null,null,{"$f":"data!A9","v":"18.12.202"},{"$f":"data!B9","v":"zonnebloemolie"},null,{"$f":"data!C9","v":3},{"$f":"data!D9","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":9,"n_cols":16,"rows_kept":9,"hidden":true}
["artikelnr.","omschrijving","besteleenheid","eenheid","maximumvoorraad","minimumvoorraad","datum1","omschrijving1","bij1","af1","saldo1","datum2","omschrijving2","bij2","af2","saldo2"]
["12.21.231","aardappelen",5,"kilo",40,20,{"$f":"NOW()-14","v":"2023-10-19T14:32:55.370"},"voorraad",null,null,38,{"$f":"NOW()-5","v":"2023-10-28T14:32:55.370"},"gebruikt",null,10,{"$f":"K2+N2-O2","v":28}]
["12.11.011","appels",30,"kilo",120,60,{"$f":"NOW()-10","v":"2023-10-23T14:32:55.370"},"voorraad",null,null,109,{"$f":"NOW()-5","v":"2023-10-28T14:32:55.370"},"gebruikt",null,29,{"$f":"K3+N3-O3","v":80}]
["14.22.454","halfvolle melk",5,"liter",40,20,{"$f":"NOW()-7","v":"2023-10-26T14:32:55.370"},"voorraad",null,null,23,{"$f":"NOW()-3","v":"2023-10-30T14:32:55.370"},"gebruikt",null,8,15]
["16.12.054","kipfilet",4,"kilo",20,14,{"$f":"NOW()-12","v":"2023-10-21T14:32:55.370"},"voorraad",null,null,19,{"$f":"NOW()-6","v":"2023-10-27T14:32:55.370"},"gebruikt",null,11,8]
["14.12.128","kruidenroomkaas",1,"kilo",8,4,{"$f":"NOW()-14","v":"2023-10-19T14:32:55.370"},"voorraad",null,null,7,{"$f":"NOW()-5","v":"2023-10-28T14:32:55.370"},"gebruikt",null,1,6]
["12.11.488","spinazie",10,"kilo",60,30,{"$f":"NOW()-5","v":"2023-10-28T14:32:55.370"},"voorraad",null,null,33,{"$f":"NOW()-4","v":"2023-10-29T14:32:55.370"},"gebruikt",null,13,20]
["12.12.276","verse knoflook",1,"kilo",1.6,0.8,{"$f":"NOW()-17","v":"2023-10-16T14:32:55.370"},"voorraad",null,null,1.5,{"$f":"NOW()-11","v":"2023-10-22T14:32:55.370"},"gebruikt",null,0.1,1.4]
["18.12.202","zonnebloemolie",3,"liter",5,2,{"$f":"NOW()-40","v":"2023-09-23T14:32:55.370"},"voorraad",null,null,5,{"$f":"NOW()-9","v":"2023-10-24T14:32:55.370"},"gebruikt",null,1,4]