{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Beginscherm","Woonzorgcentra","School 1","School 2","aanwezig per afdeling"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Beginscherm","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["2015-09-01","Scholen",null,"Woonzorgcentra"]
[]
[null,{"$f":"'School 1'!B3","v":"School 1"},null,null,"rusthuis 1"]
[]
[null,{"$f":"'School 2'!B3","v":"School 2"},null,null,"Rusthuis 2"]
[]
[null,null,null,null,"Rusthuis 3"]
[]
[null,null,null,null,"Rusthuis 4"]

{"sheet":"Woonzorgcentra","index":1,"n_rows":152,"n_cols":11,"rows_kept":152,"cut":false,"hidden":false,"merged":[[68,8,68,11],[49,1,49,2],[49,4,49,5],[49,7,49,8],[18,1,18,2],[18,4,18,5],[18,7,18,8],[18,10,18,11],[82,7,82,8],[82,10,82,11],[85,1,85,2],[85,4,85,5],[85,7,85,8],[85,10,85,11],[148,1,148,2],[148,4,148,5],[148,7,148,8],[151,1,151,2],[151,4,151,5],[151,7,151,8],[0,1,0,4],[34,1,34,4],[67,1,67,4],[100,1,100,4],[133,1,133,4],[118,1,118,2],[118,4,118,5],[115,1,115,2],[115,4,115,5],[82,1,82,2],[82,4,82,5],[52,1,52,2],[52,4,52,5],[15,1,15,2],[15,4,15,5],[0,8,0,11],[1,8,1,11],[34,8,34,11],[35,8,35,11],[67,8,67,11],[52,7,52,8],[15,7,15,8],[15,10,15,11],[105,0,110,0],[134,1,134,4],[135,2,135,3],[100,8,100,11],[101,8,101,11],[133,8,133,11],[134,8,134,11],[118,7,118,8],[115,7,115,8],[1,1,1,4],[2,2,2,3],[35,1,35,4],[36,2,36,3],[39,0,44,0],[138,0,143,0],[4,1,4,6],[38,1,38,6],[71,1,71,6],[104,1,104,6],[137,1,137,6],[21,0,21,1],[54,0,54,1],[88,0,88,1],[120,0,120,1],[5,0,10,0],[68,1,68,4],[69,2,69,3],[72,0,77,0],[101,1,101,4],[102,2,102,3]]}
["Rusthuis","WOONZORGCENTRUM 1",null,null,null,null,null,"Email:"]
["Adres",null,null,null,null,null,null,"Website:"]
[]
["Tel.:"]
["Diensthoofd:"]
["Info"]
[]
[]
[]
[]
[]
[]
["Aantal bedden:",128]
["Aantal afdelingen:",4]
[]
[null,"1e afdeling",null,null,"2e afdeling",null,null,"3e afdeling",null,null,"4e afdeling"]
["Optimaal aantal stagairs:",2,null,null,2,null,null,3,null,null,4]
["Minimaal aantal stagairs:",1,null,null,1,null,null,1,null,null,2]
["Hoofdverpleger","Mark",null,null,"Frans",null,null,"Ellen",null,null,"Peter "]
[]
[]
["Naar Beginscherm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rusthuis","WOONZORGCENTRUM 2",null,null,null,null,null,"Email:"]
["Adres",null,null,null,null,null,null,"Website:"]
[]
["Tel.:"]
["Diensthoofd:"]
["Info"]
[]
[]
[]
[]
[]
[]
["Aantal bedden:",80]
["Aantal afdelingen:",3]
[]
[null,"1e afdeling",null,null,"2e afdeling",null,null,"3e afdeling"]
["Optimaal aantal stagairs:",2,null,null,2,null,null,3]
["Minimaal aantal stagairs:",1,null,null,1,null,null,1]
["Hoofdverpleger","Mark",null,null,"Frans",null,null,"Ellen"]
[]
["Naar Beginscherm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rusthuis","WOONZORGCENTRUM  3",null,null,null,null,null,"Email:"]
["Adres",null,null,null,null,null,null,"Website:"]
[]
["Tel.:"]
["Diensthoofd:"]
["Info"]
[]
[]
[]
[]
[]
[]
["Aantal bedden:",127]
["Aantal afdelingen:",4]
[]
[null,"1e afdeling",null,null,"2e afdeling",null,null,"3e afdeling",null,null,"4e afdeling"]
["Optimaal aantal stagairs:",2,null,null,2,null,null,3,null,null,4]
["Minimaal aantal stagairs:",1,null,null,1,null,null,1,null,null,2]
["Hoofdverpleger","Mark",null,null,"Frans",null,null,"Ellen",null,null,"Peter "]
[]
[]
["Naar Beginscherm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rusthuis","WOONZORGCENTRUM 4",null,null,null,null,null,"Email:"]
["Adres",null,null,null,null,null,null,"Website:"]
[]
["Tel.:"]
["Diensthoofd:"]
["Info"]
[]
[]
[]
[]
[]
[]
["Aantal bedden:",96]
["Aantal afdelingen:",3]
[]
[null,"1e afdeling",null,null,"2e afdeling",null,null,"3e afdeling"]
["Optimaal aantal stagairs:",2,null,null,2,null,null,3]
["Minimaal aantal stagairs:",1,null,null,1,null,null,1]
["Hoofdverpleger","Mark",null,null,"Frans",null,null,"Ellen"]
[]
["Naar Beginscherm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rusthuis","WOONZORGCENTRUM 5",null,null,null,null,null,"Email:"]
["Adres",null,null,null,null,null,null,"Website:"]
[]
["Tel.:"]
["Diensthoofd:"]
["Info"]
[]
[]
[]
[]
[]
[]
["Aantal bedden:",90]
["Aantal afdelingen:",3]
[]
[null,"1e afdeling",null,null,"2e afdeling",null,null,"3e afdeling"]
["Optimaal aantal stagairs:",2,null,null,2,null,null,3]
["Minimaal aantal stagairs:",1,null,null,1,null,null,1]
["Hoofdverpleger","Mark",null,null,"Frans",null,null,"Ellen"]

{"sheet":"School 1","index":2,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,1,3,3],[2,3,2,4],[3,5,3,8],[0,0,0,1],[2,6,2,7]]}
["Naar Beginscherm"]
[]
["School:","School 1","Adres:","Moerlandstraat 1",null,9100,"Sint-Niklaas",null,null,"Evaluatoren"]
["Contact:",null,null,null,"Email:",null,null,null,null,"Dirk"]
[null,null,null,null,null,null,null,null,null,"Danny"]
[null,"Naam","Voornaam","Niveau","Klas","Begindatum","Einddatum","Week","Evaluator","Fons"]
["Leerling 1","De Graeve","Lieve","gevorderd","1ste","2015-09-07","2015-09-11",{"$f":"IF(F7=\"\",\"\",(F7-WEEKDAY(F7-1)+4-(TRUNC(DATE(YEAR(F7-WEEKDAY(F7-1)+4),1,2)/7)*7-2))/7)","v":37},"Dirk","Frans"]
["Leerling 2","Van Hove","Peter ","begin","2de","2015-09-14","2015-09-19",{"$f":"IF(F8=\"\",\"\",(F8-WEEKDAY(F8-1)+4-(TRUNC(DATE(YEAR(F8-WEEKDAY(F8-1)+4),1,2)/7)*7-2))/7)","v":38},"Fons","Peter"]
["Leerling 3","Gaudaen","Gwendoline","gevorderd","2de","2015-09-07","2015-09-11",{"$f":"IF(F9=\"\",\"\",(F9-WEEKDAY(F9-1)+4-(TRUNC(DATE(YEAR(F9-WEEKDAY(F9-1)+4),1,2)/7)*7-2))/7)","v":37},"Danny","Jan"]
["Leerling 4","De Maere ","Sophie","begin","1ste","2015-09-07","2015-09-11",37,"Peter","Donny"]
["Leerling 5","De Beul","Lieke","begin","1ste","2015-09-14","2015-09-19",38,"Donny","Elga"]
["Leerling 6","Castelein","Lisa","gevorderd","3de","2015-09-07","2015-09-11",37,"Frederick","Annabel"]
["Leerling 7","De Borgher","Britt","gevorderd","3de","2015-09-01","2015-09-04",36,"Elga","Frederick"]
["Leerling 8","Van Aarle","Amy","begin","2de","2015-10-05","2015-10-09",{"$f":"IF(F14=\"\",\"\",(F14-WEEKDAY(F14-1)+4-(TRUNC(DATE(YEAR(F14-WEEKDAY(F14-1)+4),1,2)/7)*7-2))/7)","v":41},"Danny"]
["Leerling 9","Aendenboom","Fleur","gevorderd","3de","2015-09-01","2015-09-04",36,"Frans"]
["Leerling 10","De Freville","Amber","gevorderd","3de","2015-09-01","2015-09-04",36,"Peter"]
["Leerling 11","Schellingerhout","Eva","begin","1ste","2015-09-14","2015-09-19",38,"Frans"]
["Leerling 12","Schietaert","Julia","begin","1ste","2015-09-07","2015-09-11",37,"Danny"]
["Leerling 13",null,null,null,null,null,null,""]
["Leerling 14",null,null,null,null,null,null,""]
["Leerling 15",null,null,null,null,null,null,""]
["Leerling 16",null,null,null,null,null,null,""]
["Leerling 17",null,null,null,null,null,null,""]
["Leerling 18",null,null,null,null,null,null,""]
["Leerling 19",null,null,null,null,null,null,""]
["Leerling 20",null,null,null,null,null,null,""]
["Leerling 21",null,null,null,null,null,null,""]
["Leerling 22",null,null,null,null,null,null,""]
["Leerling 23",null,null,null,null,null,null,""]
["Leerling 24",null,null,null,null,null,null,""]
["Leerling 25",null,null,null,null,null,null,""]
["Leerling 26",null,null,null,null,null,null,""]
["Leerling 27",null,null,null,null,null,null,""]
["Leerling 28",null,null,null,null,null,null,""]
["Leerling 29",null,null,null,null,null,null,""]
["Leerling 30",null,null,null,null,null,null,""]
["Aantal",{"$f":"SUMPRODUCT(--(B7:B36<>\"\"))","v":12},null,"Niveau",{"$f":"Beginscherm!A1","v":"2015-09-01"},{"$f":"(E37-WEEKDAY(E37-1)+4-(TRUNC(DATE(YEAR(E37-WEEKDAY(E37-1)+4),1,2)/7)*7-2))/7","v":36},"Week 1",{"$f":"SUMIF(H7:H36,36,H7:H36)/36","v":3}]
["Per Niveau",null,"Gevorderd",{"$f":"COUNTIF(D7:D36,\"gevorderd\")","v":6},null,null,"Week 2",{"$f":"SUMIF(H7:H36,37,H7:H36)/37","v":5}]
[null,null,"Begin",{"$f":"COUNTIF(D7:D36,\"begin\")","v":6},null,null,"Week 3",{"$f":"SUMIF(H7:H36,38,H7:H36)/38","v":3}]
[null,null,null,null,null,null,"Week 4",{"$f":"SUMIF(H7:H36,39,H7:H36)/39","v":0}]

{"sheet":"School 2","index":3,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,3,2,4],[2,6,2,7],[3,1,3,3],[3,5,3,8]]}
["Naar Beginscherm"]
[]
["School:","School 2","Adres:","Moerlandstraat 1",null,9100,"Sint-Niklaas",null,null,"Evaluatoren"]
["Contact:",null,null,null,"Email:",null,null,null,null,"Dirk"]
[null,null,null,null,null,null,null,null,null,"Danny"]
[null,"Naam","Voornaam","Niveau","Klas","Begindatum","Einddatum","Week","Evaluator","Fons"]
["Leerling 1","De Graeve","Lieve","gevorderd","1ste","2015-09-07","2015-09-11",{"$f":"IF(F7=\"\",\"\",(F7-WEEKDAY(F7-1)+4-(TRUNC(DATE(YEAR(F7-WEEKDAY(F7-1)+4),1,2)/7)*7-2))/7)","v":37},"Dirk","Frans"]
["Leerling 2","Van Hove","Peter ","begin","2de","2015-09-14","2015-09-19",{"$f":"IF(F8=\"\",\"\",(F8-WEEKDAY(F8-1)+4-(TRUNC(DATE(YEAR(F8-WEEKDAY(F8-1)+4),1,2)/7)*7-2))/7)","v":38},"Fons","Peter"]
["Leerling 3","Gaudaen","Gwendoline","gevorderd","2de","2015-09-07","2015-09-11",{"$f":"IF(F9=\"\",\"\",(F9-WEEKDAY(F9-1)+4-(TRUNC(DATE(YEAR(F9-WEEKDAY(F9-1)+4),1,2)/7)*7-2))/7)","v":37},"Danny","Jan"]
["Leerling 4","De Maere ","Sophie","begin","1ste","2015-09-07","2015-09-11",37,"Peter","Donny"]
["Leerling 5","De Beul","Lieke","begin","1ste","2015-09-14","2015-09-19",38,"Donny","Elga"]
["Leerling 6","Castelein","Lisa","gevorderd","3de","2015-09-07","2015-09-11",37,"Frederick","Annabel"]
["Leerling 7","De Borgher","Britt","gevorderd","3de","2015-09-01","2015-09-04",36,"Elga","Frederick"]
["Leerling 8","Van Aarle","Amy","begin","2de","2015-10-05","2015-10-09",{"$f":"IF(F14=\"\",\"\",(F14-WEEKDAY(F14-1)+4-(TRUNC(DATE(YEAR(F14-WEEKDAY(F14-1)+4),1,2)/7)*7-2))/7)","v":41},"Danny"]
["Leerling 9","Aendenboom","Fleur","gevorderd","3de","2015-09-01","2015-09-04",36,"Frans"]
["Leerling 10","De Freville","Amber","gevorderd","3de","2015-09-01","2015-09-04",36,"Peter"]
["Leerling 11","Schellingerhout","Eva","begin","1ste","2015-09-14","2015-09-19",38,"Frans"]
["Leerling 12","Schietaert","Julia","begin","1ste","2015-09-07","2015-09-11",37,"Danny"]
["Leerling 13",null,null,null,null,null,null,""]
["Leerling 14",null,null,null,null,null,null,""]
["Leerling 15",null,null,null,null,null,null,""]
["Leerling 16",null,null,null,null,null,null,""]
["Leerling 17",null,null,null,null,null,null,""]
["Leerling 18",null,null,null,null,null,null,""]
["Leerling 19",null,null,null,null,null,null,""]
["Leerling 20",null,null,null,null,null,null,""]
["Leerling 21",null,null,null,null,null,null,""]
["Leerling 22",null,null,null,null,null,null,""]
["Leerling 23",null,null,null,null,null,null,""]
["Leerling 24",null,null,null,null,null,null,""]
["Leerling 25",null,null,null,null,null,null,""]
["Leerling 26",null,null,null,null,null,null,""]
["Leerling 27",null,null,null,null,null,null,""]
["Leerling 28",null,null,null,null,null,null,""]
["Leerling 29",null,null,null,null,null,null,""]
["Leerling 30",null,null,null,null,null,null,""]
["Aantal",{"$f":"SUMPRODUCT(--(B7:B36<>\"\"))","v":12},null,"Niveau",{"$f":"Beginscherm!A1","v":"2015-09-01"},{"$f":"(E37-WEEKDAY(E37-1)+4-(TRUNC(DATE(YEAR(E37-WEEKDAY(E37-1)+4),1,2)/7)*7-2))/7","v":36},"Week 1",{"$f":"SUMIF(H7:H36,36,H7:H36)/36","v":3}]
["Per Niveau",null,"Gevorderd",{"$f":"COUNTIF(D7:D36,\"gevorderd\")","v":6},null,null,"Week 2",{"$f":"SUMIF(H7:H36,37,H7:H36)/37","v":5}]
[null,null,"Begin",{"$f":"COUNTIF(D7:D36,\"begin\")","v":6},null,null,"Week 3",{"$f":"SUMIF(H7:H36,38,H7:H36)/38","v":3}]
[null,null,null,null,null,null,"Week 4",{"$f":"SUMIF(H7:H36,39,H7:H36)/39","v":0}]

{"sheet":"aanwezig per afdeling","index":4,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,4,0,5],[0,6,0,7]]}
[null,{"$f":"Woonzorgcentra!B1","v":"WOONZORGCENTRUM 1"},null,null,"Inplanning in september",null,"Week 36",null,"Week 37",null,"Week 38",null,"Week 39"]
[null,{"$f":"Woonzorgcentra!B16","v":"1e afdeling"},null,null,"School",{"$f":"'School 1'!B3","v":"School 1"},null,"Niveau",null,"Niveau",null,"Niveau",null,"Niveau"]
[null,{"$f":"Woonzorgcentra!A17","v":"Optimaal aantal stagairs:"},{"$f":"Woonzorgcentra!B17","v":2},null,"Week 36"]
[null,{"$f":"Woonzorgcentra!A19","v":"Hoofdverpleger"},{"$f":"Woonzorgcentra!B19","v":"Mark"},null,null,null,null,null,{"$f":"'School 1'!D9","v":"gevorderd"}]
[null,null,null,null,null,null,null,null,{"$f":"'School 1'!D10","v":"begin"}]
[null,null,null,null,null,null,null,null,{"$f":"'School 1'!D12","v":"gevorderd"}]