{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Info","Rooster","Validatie"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"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":"Info","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Om de namen uit te printen voor een ganse week moet je aan 3 voorwaarden voldoen"]
[null,null,null,"• Je moet in een kolom van een Shift staan(C,D,E,F)"]
[null,null,null,"• In de geselecteerde cel moet in de rij ven kolom  B   ma staan"]
[null,null,null,"• In de geselecteerde cel moet in de rij ven kolom  A  een weeknummer staan"]
[]
[null,null,null,"Alleen dan zal de macroknop werken"]
[]
[]
[null,null,null,"• namen kunnen bijgevoegd worden tot max 7"]
[null,null,null,"• namen kunnen gewist worden in de lijst, deze  zal lege cellen automatisch verwijderen"]

{"sheet":"Rooster","index":1,"n_rows":72,"n_cols":28,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,null,"6h00 - 14h00","14h00 - 22h00","22h00 - 6h00","9h00 - 18h00","8h00 - 12h00","13h00 - 17h00"]
["Week ","Dag","Shift1","Shift2","Nacht","DagPost","DagPost1","DagPost2"]
[{"$f":"MAX($A$1:A2)+1","v":1},"ma","Klaas","Johan","JTvD","Els","Seppe","Pol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($A$1:AA2)+1","v":1},"ma"]
[null,null,"jan","Danny","Jaap","Truus"]
[null,null,"Piet","Gerrit","Koos","Flor"]
[null,null,null,null,"Hans","Valerie"]
[null,null,null,null,null,"Klaartje"]
[]
[]
[null,"di","Klaas","Johan","JTvD","Els","Seppe","Pol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"di"]
[null,null,"jan","Danny","Jaap","Truus"]
[null,null,"Piet","Gerrit","Koos","Flor"]
[null,null,null,null,"Hans","Valerie"]
[null,null,null,null,null,"Klaartje"]
[]
[]
[null,"wo","Klaas","Johan","JTvD","Els","Seppe","Pol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wo"]
[null,null,"jan","Danny","Jaap","Truus"]
[null,null,"Piet","Gerrit","Koos","Flor"]
[null,null,null,null,"Hans","Valerie"]
[null,null,null,null,null,"Klaartje"]
[]
[]
[null,"do","Klaas","Johan","JTvD","Els","Seppe","Pol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"do"]
[null,null,"jan","Danny","Jaap","Truus"]
[null,null,"Piet","Gerrit","Koos","Flor"]
[null,null,null,null,"Hans","Valerie"]
[null,null,null,null,null,"Klaartje"]
[]
[]
[null,"vr","Klaas","Johan","JTvD","Els","Seppe","Pol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vr"]
[null,null,"jan","Danny","Jaap","Truus"]
[null,null,"Piet","Gerrit","Koos","Flor"]
[null,null,null,null,"Hans","Valerie"]
[null,null,null,null,null,"Klaartje"]
[]
[{"$f":"A3","v":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,{"$f":"AA3","v":1}]
[{"$f":"MAX($A$1:A37)+1","v":2},"ma"]
[]
[]
[]
[]
[]
[]
[null,"di"]
[]
[]
[]
[]
[]
[]
[null,"wo"]
[]
[]
[]
[]
[]
[]
[null,"do"]
[]
[]
[]
[]
[]
[]
[null,"vr"]
[]
[]
[]
[]
[]
[{"$f":"A38","v":2}]

{"sheet":"Validatie","index":2,"n_rows":6,"n_cols":19,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,17,4,18]]}
["Shift1",null,"Shift2",null,"Nacht",null,"DagPost",null,"DagPost1",null,"DagPost2",null,"Week",1]
["Klaas",null,"Johan",null,"JTvD",null,"Els",null,"Seppe",null,"Pol",null,1,"Shift1","Shift2","Nacht","DagPost",{"$f":"IF(MOD($N$1,2)=0,\"DagPost2\",\"DagPost1\")","v":"DagPost1"},{"$f":"IF(MOD($N$1,2)=0,\"DagPost1\",\"DagPost2\")","v":"DagPost2"}]
["jan",null,"Danny",null,"Jaap",null,"Truus",null,null,null,null,null,2,"Shift2","Nacht","Shift1","DagPost",{"$f":"IF(MOD($N$1,2)=0,\"DagPost2\",\"DagPost1\")","v":"DagPost1"},{"$f":"IF(MOD($N$1,2)=0,\"DagPost1\",\"DagPost2\")","v":"DagPost2"}]
["Piet",null,"Gerrit",null,"Koos",null,"Flor",null,null,null,null,null,3,"Nacht","Shift1","Shift2","DagPost",{"$f":"IF(MOD($N$1,2)=0,\"DagPost2\",\"DagPost1\")","v":"DagPost1"},{"$f":"IF(MOD($N$1,2)=0,\"DagPost1\",\"DagPost2\")","v":"DagPost2"}]
[null,null,null,null,"Hans",null,"Valerie",null,null,null,null,null,"Wissel",null,"Om de 3 weken",null,"Niet","Om de 2 weken"]
[null,null,null,null,null,null,"Klaartje"]