{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["rolcontainers","doos1","doos2","doos3","doos4","doos5","printblad"],"not_rendered":{"images":45,"macros":1,"defined_names":37},"read":"whole","date_system":"1900"}

{"sheet":"rolcontainers","index":0,"n_rows":16,"n_cols":24,"rows_kept":16,"merged":[[2,2,2,4],[2,5,2,9],[3,2,3,4],[3,5,3,9],[3,13,7,13],[3,14,7,14],[3,15,7,15],[3,16,7,16],[6,3,6,5],[6,7,6,8],[8,4,8,5],[9,4,9,5],[9,6,10,6],[10,4,10,5],[11,4,11,5],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,16,12,16],[18,6,19,6]]}
[{"$nulls":23},{"$f":"REPLACE(LEFT(CELL(\"filename\"),SEARCH(\"]\",CELL(\"filename\"))-1),1,SEARCH(\"[\",CELL(\"filename\")),\"\")","v":"vb_rolcontainers_gl.xlsm"}]
[]
[null,null,"Kandidaatnaam:",{"$nulls":12},"gewicht","temperatuur"]
[null,null,"Kandidaatnummer:",{"$nulls":10},1,{"$f":"HYPERLINK(\"[\"&$X$1&\"]doos1!A1\",IF(doos1!inhoudklopt=\"ü\",\"inhoud correct\",IF(doos1!inhoudkloptniet=\"ü\",\"inhoud niet correct\",\"controleer inhoud\")))","v":"controleer inhoud"},"licht",{"$f":"IF(INDIRECT(\"doos\"&$N4&\"!gekoeld\")=\"ü\",\"gekoeld\",IF(INDIRECT(\"doos\"&$N4&\"!nietgekoeld\")=\"ü\",\"ongekoeld\",\"\"))","v":""}]
[]
[]
[{"$nulls":3},"koelcel",{"$nulls":3},"magazijn"]
[]
[{"$nulls":13},2,{"$f":"HYPERLINK(\"[\"&$X$1&\"]doos2!A1\",IF(doos2!inhoudklopt=\"ü\",\"inhoud correct\",IF(doos2!inhoudkloptniet=\"ü\",\"inhoud niet correct\",\"controleer inhoud\")))","v":"controleer inhoud"},"zwaar",{"$f":"IF(INDIRECT(\"doos\"&$N9&\"!gekoeld\")=\"ü\",\"gekoeld\",IF(INDIRECT(\"doos\"&$N9&\"!nietgekoeld\")=\"ü\",\"ongekoeld\",\"\"))","v":""}]
[{"$nulls":13},3,{"$f":"HYPERLINK(\"[\"&$X$1&\"]doos3!A1\",IF(doos3!inhoudklopt=\"ü\",\"inhoud correct\",IF(doos3!inhoudkloptniet=\"ü\",\"inhoud niet correct\",\"controleer inhoud\")))","v":"controleer inhoud"},"zwaar",{"$f":"IF(INDIRECT(\"doos\"&$N10&\"!gekoeld\")=\"ü\",\"gekoeld\",IF(INDIRECT(\"doos\"&$N10&\"!nietgekoeld\")=\"ü\",\"ongekoeld\",\"\"))","v":""}]
[{"$nulls":13},4,{"$f":"HYPERLINK(\"[\"&$X$1&\"]doos4!A1\",IF(doos4!inhoudklopt=\"ü\",\"inhoud correct\",IF(doos4!inhoudkloptniet=\"ü\",\"inhoud niet correct\",\"controleer inhoud\")))","v":"controleer inhoud"},"licht",{"$f":"IF(INDIRECT(\"doos\"&$N11&\"!gekoeld\")=\"ü\",\"gekoeld\",IF(INDIRECT(\"doos\"&$N11&\"!nietgekoeld\")=\"ü\",\"ongekoeld\",\"\"))","v":""}]
[{"$nulls":13},5,{"$f":"HYPERLINK(\"[\"&$X$1&\"]doos5!A1\",IF(doos5!inhoudklopt=\"ü\",\"inhoud correct\",IF(doos5!inhoudkloptniet=\"ü\",\"inhoud niet correct\",\"controleer inhoud\")))","v":"controleer inhoud"},"zwaar",{"$f":"IF(INDIRECT(\"doos\"&$N12&\"!gekoeld\")=\"ü\",\"gekoeld\",IF(INDIRECT(\"doos\"&$N12&\"!nietgekoeld\")=\"ü\",\"ongekoeld\",\"\"))","v":""}]
[]
[{"$nulls":13},6,"inhoud correct","zwaar","gekoeld"]
[{"$nulls":13},7,"inhoud correct","zwaar","ongekoeld"]
[{"$nulls":13},8,"inhoud correct","licht","ongekoeld"]

{"sheet":"doos1","index":1,"n_rows":52,"n_cols":27,"rows_kept":52,"merged":[[2,2,2,6],[4,2,4,6],[5,2,5,3],[5,4,5,6],[7,2,25,3],[7,5,7,6],[11,5,11,6],[26,2,26,3],[28,2,35,3],[28,5,28,6],[32,5,32,6],[36,2,36,3],[39,2,39,6],[40,3,40,6],[41,3,41,6],[43,2,43,6],[44,2,47,6],[49,2,49,6],[50,3,50,6],[51,3,51,6]]}
[{"$nulls":26},true]
[]
[null,null,"Inhoud doos 1"]
[]
[null,null,"Pakbon 01418"]
[null,null,"Udea\nDoornhoek 4040\n5465 TD Veghel",null,"Online eco shop\nEurostraat 91\n3141 JK Einderdorp"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":12}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[]
[null,null,"Klopt de inhoud van de doos met de pakbon?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]
[]
[null,null,"Toelichting:"]
[null,null,""]
[]
[]
[]
[]
[null,null,"Moet de doos gekoeld vervoerd worden?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]

{"sheet":"doos2","index":2,"n_rows":63,"n_cols":27,"rows_kept":63,"merged":[[2,2,2,6],[4,2,4,6],[5,2,5,3],[5,4,5,6],[7,2,13,3],[7,5,7,6],[11,5,11,6],[14,2,14,3],[16,2,23,3],[16,5,16,6],[20,5,20,6],[24,2,24,3],[26,2,32,3],[26,5,26,6],[30,5,30,6],[33,2,33,3],[35,2,46,3],[35,5,35,6],[39,5,39,6],[47,2,47,3],[50,2,50,6],[51,3,51,6],[52,3,52,6],[54,2,54,6],[55,2,58,6],[60,2,60,6],[61,3,61,6],[62,3,62,6]]}
[{"$nulls":26},true]
[]
[null,null,"Inhoud doos 2"]
[]
[null,null,"Pakbon 01317"]
[null,null,"Udea\nDoornhoek 4040\n5465 TD Veghel",null,"Eco shop Janssen\nDollarstraat 14\n1234 AB Westerdorp"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[]
[]
[]
[]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[]
[null,null,"Klopt de inhoud van de doos met de pakbon?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]
[]
[null,null,"Toelichting:"]
[null,null,""]
[]
[]
[]
[]
[null,null,"Moet de doos gekoeld vervoerd worden?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]

{"sheet":"doos3","index":3,"n_rows":57,"n_cols":27,"rows_kept":57,"merged":[[2,2,2,6],[4,2,4,6],[5,2,5,3],[5,4,5,6],[7,2,23,3],[7,5,7,6],[11,5,11,6],[24,2,24,3],[26,2,40,3],[26,5,26,6],[30,5,30,6],[41,2,41,3],[44,2,44,6],[45,3,45,6],[46,3,46,6],[48,2,48,6],[49,2,52,6],[54,2,54,6],[55,3,55,6],[56,3,56,6]]}
[{"$nulls":26},true]
[]
[null,null,"Inhoud doos 3"]
[]
[null,null,"Pakbon 01519"]
[null,null,"Udea\nDoornhoek 4040\n5465 TD Veghel",null,"Online eco shop\nEurostraat 91\n3141 JK Einderdorp"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":10}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":8}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[]
[null,null,"Klopt de inhoud van de doos met de pakbon?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]
[]
[null,null,"Toelichting:"]
[null,null,""]
[]
[]
[]
[]
[null,null,"Moet de doos gekoeld vervoerd worden?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]

{"sheet":"doos4","index":4,"n_rows":92,"n_cols":27,"rows_kept":92,"merged":[[2,2,2,6],[4,2,4,6],[5,2,5,3],[5,4,5,6],[7,2,13,3],[7,5,7,6],[11,5,11,6],[14,2,14,3],[16,2,37,3],[16,5,16,6],[20,5,20,6],[38,2,38,3],[40,2,63,3],[40,5,40,6],[44,5,44,6],[64,2,64,3],[66,2,75,3],[66,5,66,6],[70,5,70,6],[76,2,76,3],[79,2,79,6],[80,3,80,6],[81,3,81,6],[83,2,83,6],[84,2,87,6],[89,2,89,6],[90,3,90,6],[91,3,91,6]]}
[{"$nulls":26},true]
[]
[null,null,"Inhoud doos 4"]
[]
[null,null,"Pakbon 01216"]
[null,null,"Udea\nDoornhoek 4040\n5465 TD Veghel",null,"Groene super Harmsen\nMarkstraat 91\n1121 GH Zuiderdorp"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":15}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":17}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[]
[]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[]
[null,null,"Klopt de inhoud van de doos met de pakbon?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]
[]
[null,null,"Toelichting:"]
[null,null,""]
[]
[]
[]
[]
[null,null,"Moet de doos gekoeld vervoerd worden?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]

{"sheet":"doos5","index":5,"n_rows":77,"n_cols":27,"rows_kept":77,"merged":[[2,2,2,6],[4,2,4,6],[5,2,5,3],[5,4,5,6],[7,2,24,3],[7,5,7,6],[11,5,11,6],[25,2,25,3],[27,2,40,3],[27,5,27,6],[31,5,31,6],[41,2,41,3],[43,2,50,3],[43,5,43,6],[47,5,47,6],[51,2,51,3],[53,2,60,3],[53,5,53,6],[57,5,57,6],[61,2,61,3],[64,2,64,6],[65,3,65,6],[66,3,66,6],[68,2,68,6],[69,2,72,6],[74,2,74,6],[75,3,75,6],[76,3,76,6]]}
[{"$nulls":26},true]
[]
[null,null,"Inhoud doos 5"]
[]
[null,null,"Pakbon 01115"]
[null,null,"Udea\nDoornhoek 4040\n5465 TD Veghel",null,"Boerderijwinkel Pietersen\nLirestraat 91\n5678 CD Oosterdorp"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":11}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
{"$rows_empty":7}
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[{"$nulls":5},"Staat dit artikel op de pakbon?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[{"$nulls":5},"Is het aantal artikelen juist?"]
[{"$nulls":6},"ja"]
[{"$nulls":6},"nee"]
[]
[null,null,"klik op de afbeelding voor een vergroting"]
[]
[]
[null,null,"Klopt de inhoud van de doos met de pakbon?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]
[]
[null,null,"Toelichting:"]
[null,null,""]
[]
[]
[]
[]
[null,null,"Moet de doos gekoeld vervoerd worden?"]
[{"$nulls":3},"ja"]
[{"$nulls":3},"nee"]

{"sheet":"printblad","index":6,"n_rows":30,"n_cols":11,"rows_kept":30,"merged":[[2,2,2,3],[2,4,2,9],[3,2,3,3],[3,4,3,9],[6,2,6,6],[6,8,9,8],[6,9,9,9],[6,10,9,10],[7,2,7,4],[8,2,8,4],[9,2,9,6],[10,2,10,4],[10,8,13,8],[10,9,13,9],[10,10,13,10],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,6],[14,8,17,8],[14,9,17,9],[14,10,17,10],[15,2,15,4],[16,2,16,4],[17,2,17,6],[18,2,18,4],[18,8,21,8],[18,9,21,9],[18,10,21,10],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,6],[22,8,25,8],[22,9,25,9],[22,10,25,10],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[28,2,28,6],[29,2,29,3],[29,5,29,6]]}
[]
[]
[null,null,{"$f":"rolcontainers!C3","v":"Kandidaatnaam:"},null,{"$f":"rolcontainers!F3","v":0}]
[null,null,{"$f":"rolcontainers!C4","v":"Kandidaatnummer:"},null,{"$f":"rolcontainers!F4","v":0}]
[]
[{"$nulls":5},"op pakbon","aantal juist",null,null,"juist ingepakt","toelichting"]
[null,null,"doos 1",{"$nulls":5},"doos 1"]
[null,null,"gebraden kipfilet"]
[null,null,"brie"]
[null,null,"doos 2"]
[null,null,"karnemelk",{"$nulls":5},"doos 2"]
[null,null,"mini mozzarella"]
[null,null,"kruidenboter"]
[null,null,"achterham"]
[null,null,"doos 3",{"$nulls":5},"doos 3"]
[null,null,"aardappelen vastkokend"]
[null,null,"gemalen koffie Arabica"]
[null,null,"doos 4"]
[null,null,"knäckebröd",{"$nulls":5},"doos 4"]
[null,null,"meergranen beschuit"]
[null,null,"linzenwafels"]
[null,null,"chocoladereep puur"]
[null,null,"doos 5",{"$nulls":5},"doos 5"]
[null,null,"lasagne veggie"]
[null,null,"perensap"]
[null,null,"pruimen"]
[null,null,"biologische aardappeltjes"]
[]
[null,null,"indeling rolcontainers"]
[null,null,{"$f":"rolcontainers!D7","v":"koelcel"},null,null,{"$f":"rolcontainers!H7","v":"magazijn"}]