{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Weekplanning","Info uitzendburo","Verlof","Jaaroverzicht"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":6,"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":"Weekplanning","index":0,"n_rows":119,"n_cols":21,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"PLANNING","2019-12-20",null,null,null,null,null,"1900-01-21"]
[null,{"$f":"WEEKNUM(E2) & \"/\" & YEAR(E2)","v":"51/2019"},null,{"$f":"WEEKDAY(E2)","v":"1900-01-01"},"2019-12-15",{"$f":"\"Week nr.\" & WEEKNUM(E2)","v":"Week nr.51"},{"$f":"WEEKDAY(H2)","v":"1900-01-02"},"2019-12-16",{"$f":"\"Week nr.\" & WEEKNUM(H2)","v":"Week nr.51"},{"$f":"WEEKDAY(K2)","v":"1900-01-03"},"2019-12-17",{"$f":"\"Week nr.\" & WEEKNUM(K2)","v":"Week nr.51"},{"$f":"WEEKDAY(N2)","v":"1900-01-04"},"2019-12-18",{"$f":"\"Week nr.\" & WEEKNUM(N2)","v":"Week nr.51"},{"$f":"WEEKDAY(Q2)","v":"1900-01-05"},"2019-12-19",{"$f":"\"Week nr.\" & WEEKNUM(Q2)","v":"Week nr.51"},{"$f":"WEEKDAY(T2)","v":"1900-01-06"},"2019-12-20",{"$f":"\"Week nr.\" & WEEKNUM(T2)","v":"Week nr.51"}]
["Afdeling","Verlof","FTE","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht"]
["AFV",null,null,"06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
["SCHM",null,"WERKTIIJDEN","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1,null,null,"Marjolein achternaam1","Rachid achternaam14","Patrick achternaam29","Marjolein achternaam33","Rachid achternaam46","Patrick achternaam61","Marjolein achternaam65","Rachid achternaam78","Patrick achternaam93",null,"Kevin achternaam100",null,null,"Patrick achternaam123"]
[null,null,2,null,null,"Piet achternaam2","Evans achternaam15","Rolinka achternaam30","Roy achternaam34","Evans achternaam47","Rolinka achternaam62","Roy achternaam66","Evans achternaam79","Rolinka achternaam94",null,"Patrick achternaam109",null,null,"Marjolein achternaam124"]
[null,null,3,null,null,"Roy achternaam3","Kevin achternaam16","Erik achternaam31","Piet achternaam35","Kevin achternaam48","Erik achternaam63","Piet achternaam67","Kevin achternaam80","Erik achternaam95",null,"Rolinka achternaam110",null,null,"Rolinka achternaam125"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kevin achternaam126"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roy achternaam127"]
[null,null,6]
[null,null,7]
[null,null,8]
["HAS",null,"WERKTIIJDEN","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
["LCR",null,null,"06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
["ABB",null,null,{"$f":"IF(WEEKDAY(E2)=7,\"08:00/21:00 \",IF(WEEKDAY(E2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"08:00/14:45"},{"$f":"IF(WEEKDAY(E2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"13:45/22:30"},{"$f":"IF(OR(WEEKDAY(E2)=7,WEEKDAY(E2)=1),\" \",\"22:00/06:45\")","v":" "},{"$f":"IF(WEEKDAY(H2)=7,\"08:00/21:00 \",IF(WEEKDAY(H2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(H2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(H2)=7,WEEKDAY(H2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(K2)=7,\"08:00/21:00 \",IF(WEEKDAY(K2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(K2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(K2)=7,WEEKDAY(K2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(N2)=7,\"08:00/21:00 \",IF(WEEKDAY(N2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(N2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(N2)=7,WEEKDAY(N2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(Q2)=7,\"08:00/21:00 \",IF(WEEKDAY(Q2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(Q2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(Q2)=7,WEEKDAY(Q2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(T2)=7,\"08:00/21:00 \",IF(WEEKDAY(T2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(T2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(T2)=7,WEEKDAY(T2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"}]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
["MEP",null,null,"06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"WEEKDAY(E75)","v":"1900-01-07"},"2019-11-30",{"$f":"\"Week nr.\" & WEEKNUM(E75)","v":"Week nr.48"}]
[null,null,null,"Vroeg","Laat","Nacht"]
[null,null,null,"06:00/14:45","14:45/23:30","22:00/06:45"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"06:00/14:45","14:45/23:30","22:00/06:45"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"06:00/14:45","13:45/22:30","22:00/06:45"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"06:00/14:45","14:45/23:30","22:00/06:45"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(WEEKDAY(E75)=7,\"08:00/21:00 \",IF(WEEKDAY(E75)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"08:00/21:00 "},{"$f":"IF(WEEKDAY(E75)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(E75)=7,WEEKDAY(E75)=1),\" \",\"22:00/06:45\")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"06:00/14:45","14:45/23:30","22:00/06:45"]

{"sheet":"Info uitzendburo","index":1,"n_rows":137,"n_cols":20,"rows_kept":137,"cut":false,"hidden":false,"merged":[]}
[1,"Functie","Starttijd","Eindtijd","Voornaam","Achternaam",null,null,1,null,"Mijn afdelingen","Planning afdeling ",null,"NIET mijn afdelingen",null,null,null,null,"personeel"]
["2019-12-15","SCHM",43814.999305555553,43815.364583333336,"Marjolein","achternaam1",null,null,null,null,"ABB weekenddienst","ABB",null,"PALL HAS",null,null,null,null,"Flavi Achternaam1","ABB weekenddienst"]
["2019-12-15","SCHM",43814.999305555553,43815.364583333336,"Piet","achternaam2",null,null,null,null,"ABB middag","ABB",null,"PALL MEP",null,null,null,null,"Baki Achternaam2","ABB middag"]
["2019-12-15","SCHM",43814.999305555553,43815.364583333336,"Roy","achternaam3",null,null,null,null,"ABB ochtend ","ABB",null,"PALL Rweg",null,null,null,null,"Rolinka Achternaam3","SCHM"]
["2019-12-16","ABB",43815.25,43815.614583333336,"Flavi","achternaam4",null,null,null,null,null,null,null,"Reserve ochtend",null,null,null,null,"Erik Achternaam4","SCHM"]
["2019-12-16","ABB",43815.25,43815.614583333336,"Ilker","achternaam5",null,null,null,null,"AFV MEP","MEP",null,"Reserve middag",null,null,null,null,"Norbert Achternaam6","AFV HAS"]
["2019-12-16","AFV",43815.25,43815.614583333336,"Bile","achternaam6",null,null,null,null,null,null,null,null,null,null,null,null,"Houcin Achternaam7","AFV MEP"]
["2019-12-16","AFV",43815.25,43815.614583333336,"Baki","achternaam7",null,null,null,null,"SCHM AFV","AFV",null,null,null,null,null,null,"Wolter Achternaam8","LCR ochtend"]
["2019-12-16","AFV",43815.25,43815.614583333336,"Miquel","achternaam8",null,null,null,null,null,null,null,null,null,null,null,null,"Rachid Achternaam34","SCHM"]
["2019-12-16","AFV",43815.25,43815.614583333336,"Sebastiaan","achternaam9",null,null,null,null,"SCHM","SCHM",null,"In de planning ",null,null,null,null,"Evans Achternaam35","SCHM"]
["2019-12-16","AFV",43815.25,43815.614583333336,"Paul","achternaam10",null,null,null,null,null,null,null,"06:00/14:45","14:45/23:30",null,null,null,"Kevin Achternaam36","SCHM"]
["2019-12-16","HAS",43815.25,43815.40625,"Norbert","achternaam11",null,null,null,null,"AFV HAS","HAS",null,"Voornaam + achternaam","Voornaam + achternaam",null,null,null,"Ilker Achternaam38","SCHM AFV"]
["2019-12-16","LCR",43815.25,43815.614583333336,"Klaas","achternaam12",null,null,null,null,"SCHM HAS","HAS",null,null,null,null,null,null,"Miquel Achternaam39","SCHM AFV"]
["2019-12-16","LCR",43815.25,43815.614583333336,"Wolter","achternaam13",null,null,null,null,null,null,null,null,null,null,null,null,"Klaas Achternaam40","SCHM AFV"]
["2019-12-16","SCHM",43815.25,43815.614583333336,"Rachid","achternaam14",null,null,null,null,"LCR middag","LCR",null,null,null,null,null,null,"Sebastiaan Achternaam41","SCHM AFV"]
["2019-12-16","SCHM",43815.25,43815.614583333336,"Evans","achternaam15",null,null,null,null,"LCR ochtend","LCR",null,null,null,null,null,null,"Rudolf Achternaam44","AFV MEP"]
["2019-12-16","SCHM",43815.25,43815.614583333336,"Kevin","achternaam16",null,null,null,null,null,null,null,null,null,null,null,null,"Trienko Achternaam48","ABB middag"]
["2019-12-16","MEP",43815.291666666664,43815.65625,"Rijk","achternaam17",null,null,null,null,null,null,null,null,null,null,null,null,"Paul Achternaam49","AFV HAS"]
["2019-12-16","MEP",43815.291666666664,43815.65625,"Houcin","achternaam18",null,null,null,null,null,null,null,null,null,null,null,null,"Rijk Achternaam50","AFV MEP"]
["2019-12-16","HAS",43815.40625,43815.614583333336,"Norbert","achternaam19",null,null,null,null,null,null,null,null,null,null,null,null,"Christiaan Achternaam51","LCR middag"]
["2019-12-16","ABB",43815.572916666664,43815.9375,"Trienko","achternaam20",null,null,null,null,null,null,null,null,null,null,null,null,"Marjolein Achternaam76","SCHM"]
["2019-12-16","MEP",43815.572916666664,43815.9375,"Rudolf","achternaam21",null,null,null,null,null,null,null,null,null,null,null,null,"Roy Achternaam77","SCHM"]
["2019-12-16","HAS",43815.572916666664,43815.697916666664,"Paul","achternaam22",null,null,null,null,null,null,null,null,null,null,null,null,"Piet Achternaam78","SCHM"]
["2019-12-16","LCR",43815.572916666664,43815.9375,"Christiaan","achternaam23",null,null,null,null,null,null,null,null,null,null,null,null,"Jan Achternaam79","SCHM AFV"]
["2019-12-16","AFV",43815.614583333336,43815.979166666664,"Jan","achternaam24",null,null,null,null,null,null,null,null,null,null,null,null,"Boyan Achternaam80","SCHM AFV"]
["2019-12-16","AFV",43815.614583333336,43815.979166666664,"Boyan","achternaam25",null,null,null,null,null,null,null,null,null,null,null,null,"Sami Achternaam81","SCHM AFV"]
["2019-12-16","AFV",43815.614583333336,43815.979166666664,"Sami","achternaam26",null,null,null,null,null,null,null,null,null,null,null,null,"Henri Achternaam82","SCHM AFV"]
["2019-12-16","AFV",43815.614583333336,43815.979166666664,"Henri","achternaam27",null,null,null,null,null,null,null,null,null,null,null,null,"Michel Achternaam83","SCHM AFV"]
["2019-12-16","AFV",43815.614583333336,43815.979166666664,"Michel","achternaam28",null,null,null,null,null,null,null,null,null,null,null,null,"Patrick Achternaam88","SCHM"]
["2019-12-16","SCHM",43815.614583333336,43815.979166666664,"Patrick","achternaam29",null,null,null,null,null,null,null,null,null,null,null,null,"Arkan Achternaam455","ABB weekenddienst"]
["2019-12-16","SCHM",43815.614583333336,43815.979166666664,"Rolinka","achternaam30",null,null,null,null,null,null,null,null,null,null,null,null,"Bile Achternaam508","ABB middag"]
["2019-12-16","SCHM",43815.614583333336,43815.979166666664,"Erik","achternaam31",null,null,null,null,null,null,null,null,null,null,null,null,"Niek Achternaam937","ABB weekenddienst"]
["2019-12-16","HAS",43815.697916666664,43815.9375,"Paul","achternaam32"]
["2019-12-16","SCHM",43815.916666666664,43816.28125,"Marjolein","achternaam33"]
["2019-12-16","SCHM",43815.916666666664,43816.28125,"Roy","achternaam34"]
["2019-12-16","SCHM",43815.916666666664,43816.28125,"Piet","achternaam35"]
["2019-12-17","ABB",43816.25,43816.614583333336,"Flavi","achternaam36"]
["2019-12-17","ABB",43816.25,43816.614583333336,"Ilker","achternaam37"]
["2019-12-17","AFV",43816.25,43816.614583333336,"Bile","achternaam38"]
["2019-12-17","AFV",43816.25,43816.614583333336,"Baki","achternaam39"]
["2019-12-17","AFV",43816.25,43816.614583333336,"Miquel","achternaam40"]
["2019-12-17","AFV",43816.25,43816.614583333336,"Sebastiaan","achternaam41"]
["2019-12-17","AFV",43816.25,43816.614583333336,"Paul","achternaam42"]
["2019-12-17","HAS",43816.25,43816.40625,"Norbert","achternaam43"]
["2019-12-17","LCR",43816.25,43816.614583333336,"Klaas","achternaam44"]
["2019-12-17","LCR",43816.25,43816.614583333336,"Wolter","achternaam45"]
["2019-12-17","SCHM",43816.25,43816.614583333336,"Rachid","achternaam46"]
["2019-12-17","SCHM",43816.25,43816.614583333336,"Evans","achternaam47"]
["2019-12-17","SCHM",43816.25,43816.614583333336,"Kevin","achternaam48"]
["2019-12-17","MEP",43816.291666666664,43816.65625,"Rijk","achternaam49"]
["2019-12-17","MEP",43816.291666666664,43816.65625,"Houcin","achternaam50"]
["2019-12-17","HAS",43816.40625,43816.614583333336,"Norbert","achternaam51"]
["2019-12-17","ABB",43816.572916666664,43816.9375,"Trienko","achternaam52"]
["2019-12-17","MEP",43816.572916666664,43816.9375,"Rudolf","achternaam53"]
["2019-12-17","HAS",43816.572916666664,43816.697916666664,"Paul","achternaam54"]
["2019-12-17","LCR",43816.572916666664,43816.9375,"Christiaan","achternaam55"]
["2019-12-17","AFV",43816.614583333336,43816.979166666664,"Jan","achternaam56"]
["2019-12-17","AFV",43816.614583333336,43816.979166666664,"Boyan","achternaam57"]
["2019-12-17","AFV",43816.614583333336,43816.979166666664,"Sami","achternaam58"]
["2019-12-17","AFV",43816.614583333336,43816.979166666664,"Henri","achternaam59"]
["2019-12-17","AFV",43816.614583333336,43816.979166666664,"Michel","achternaam60"]
["2019-12-17","SCHM",43816.614583333336,43816.979166666664,"Patrick","achternaam61"]
["2019-12-17","SCHM",43816.614583333336,43816.979166666664,"Rolinka","achternaam62"]
["2019-12-17","SCHM",43816.614583333336,43816.979166666664,"Erik","achternaam63"]
["2019-12-17","HAS",43816.697916666664,43816.9375,"Paul","achternaam64"]
["2019-12-17","SCHM",43816.916666666664,43817.28125,"Marjolein","achternaam65"]
["2019-12-17","SCHM",43816.916666666664,43817.28125,"Roy","achternaam66"]
["2019-12-17","SCHM",43816.916666666664,43817.28125,"Piet","achternaam67"]
["2019-12-18","ABB",43817.25,43817.614583333336,"Flavi","achternaam68"]
["2019-12-18","ABB",43817.25,43817.614583333336,"Ilker","achternaam69"]
["2019-12-18","AFV",43817.25,43817.614583333336,"Bile","achternaam70"]
["2019-12-18","AFV",43817.25,43817.614583333336,"Baki","achternaam71"]
["2019-12-18","AFV",43817.25,43817.614583333336,"Miquel","achternaam72"]
["2019-12-18","AFV",43817.25,43817.614583333336,"Sebastiaan","achternaam73"]
["2019-12-18","AFV",43817.25,43817.614583333336,"Paul","achternaam74"]
["2019-12-18","HAS",43817.25,43817.40625,"Norbert","achternaam75"]
["2019-12-18","LCR",43817.25,43817.614583333336,"Klaas","achternaam76"]
["2019-12-18","LCR",43817.25,43817.614583333336,"Wolter","achternaam77"]
["2019-12-18","SCHM",43817.25,43817.614583333336,"Rachid","achternaam78"]
["2019-12-18","SCHM",43817.25,43817.614583333336,"Evans","achternaam79"]
["2019-12-18","SCHM",43817.25,43817.614583333336,"Kevin","achternaam80"]
["2019-12-18","MEP",43817.291666666664,43817.65625,"Rijk","achternaam81"]
["2019-12-18","MEP",43817.291666666664,43817.65625,"Houcin","achternaam82"]
["2019-12-18","HAS",43817.40625,43817.614583333336,"Norbert","achternaam83"]
["2019-12-18","ABB",43817.572916666664,43817.9375,"Trienko","achternaam84"]
["2019-12-18","MEP",43817.572916666664,43817.9375,"Rudolf","achternaam85"]
["2019-12-18","HAS",43817.572916666664,43817.697916666664,"Paul","achternaam86"]
["2019-12-18","LCR",43817.572916666664,43817.9375,"Christiaan","achternaam87"]
["2019-12-18","AFV",43817.614583333336,43817.979166666664,"Jan","achternaam88"]
["2019-12-18","AFV",43817.614583333336,43817.979166666664,"Boyan","achternaam89"]
["2019-12-18","AFV",43817.614583333336,43817.979166666664,"Sami","achternaam90"]
["2019-12-18","AFV",43817.614583333336,43817.979166666664,"Henri","achternaam91"]
["2019-12-18","AFV",43817.614583333336,43817.979166666664,"Michel","achternaam92"]
["2019-12-18","SCHM",43817.614583333336,43817.979166666664,"Patrick","achternaam93"]
["2019-12-18","SCHM",43817.614583333336,43817.979166666664,"Rolinka","achternaam94"]
["2019-12-18","SCHM",43817.614583333336,43817.979166666664,"Erik","achternaam95"]
["2019-12-18","HAS",43817.697916666664,43817.9375,"Paul","achternaam96"]
["2019-12-19","ABB",43818.25,43818.614583333336,"Flavi","achternaam97"]
["2019-12-19","ABB",43818.25,43818.614583333336,"Ilker","achternaam98"]
["2019-12-19","HAS",43818.25,43818.40625,"Norbert","achternaam99"]
["2019-12-19","SCHM",43818.25,43818.614583333336,"Kevin","achternaam100"]
["2019-12-19","MEP",43818.291666666664,43818.65625,"Rijk","achternaam101"]
["2019-12-19","MEP",43818.291666666664,43818.65625,"Houcin","achternaam102"]
["2019-12-19","MEP",43818.291666666664,43818.65625,"Rudolf","achternaam103"]
["2019-12-19","MEP",43818.333333333336,43818.65625,"Henri","achternaam104"]
["2019-12-19","AFV",43818.333333333336,43818.614583333336,"Baki","achternaam105"]
["2019-12-19","AFV",43818.333333333336,43818.614583333336,"Boyan","achternaam106"]
["2019-12-19","AFV",43818.333333333336,43818.614583333336,"Michel","achternaam107"]
["2019-12-19","HAS",43818.333333333336,43818.40625,"Paul","achternaam108"]
["2019-12-19","SCHM",43818.333333333336,43818.614583333336,"Patrick","achternaam109"]
["2019-12-19","SCHM",43818.333333333336,43818.614583333336,"Rolinka","achternaam110"]
["2019-12-19","HAS",43818.40625,43818.614583333336,"Paul","achternaam111"]
["2019-12-19","HAS",43818.40625,43818.614583333336,"Norbert","achternaam112"]
["2019-12-19","ABB",43818.572916666664,43818.9375,"Trienko","achternaam113"]
["2019-12-19","ABB",43818.572916666664,43818.9375,"Wolter","achternaam114"]
["2019-12-20","ABB",43819.25,43819.614583333336,"Flavi","achternaam115"]
["2019-12-20","ABB",43819.25,43819.614583333336,"Ilker","achternaam116"]
["2019-12-20","AFV",43819.25,43819.614583333336,"Baki","achternaam117"]
["2019-12-20","AFV",43819.25,43819.614583333336,"Jan","achternaam118"]
["2019-12-20","AFV",43819.25,43819.614583333336,"Boyan","achternaam119"]
["2019-12-20","AFV",43819.25,43819.614583333336,"Michel","achternaam120"]
["2019-12-20","HAS",43819.25,43819.40625,"Paul","achternaam121"]
["2019-12-20","HAS",43819.25,43819.40625,"Norbert","achternaam122"]
["2019-12-20","SCHM",43819.25,43819.614583333336,"Patrick","achternaam123"]
["2019-12-20","SCHM",43819.25,43819.614583333336,"Marjolein","achternaam124"]
["2019-12-20","SCHM",43819.25,43819.614583333336,"Rolinka","achternaam125"]
["2019-12-20","SCHM",43819.25,43819.614583333336,"Kevin","achternaam126"]
["2019-12-20","SCHM",43819.25,43819.614583333336,"Roy","achternaam127"]
["2019-12-20","MEP",43819.291666666664,43819.65625,"Rijk","achternaam128"]
["2019-12-20","MEP",43819.291666666664,43819.65625,"Houcin","achternaam129"]
["2019-12-20","MEP",43819.291666666664,43819.65625,"Henri","achternaam130"]
["2019-12-20","MEP",43819.291666666664,43819.65625,"Rudolf","achternaam131"]
["2019-12-20","HAS",43819.40625,43819.614583333336,"Paul","achternaam132"]
["2019-12-20","HAS",43819.40625,43819.614583333336,"Norbert","achternaam133"]
["2019-12-20","ABB",43819.572916666664,43819.9375,"Trienko","achternaam134"]
["2019-12-20","ABB",43819.572916666664,43819.9375,"Wolter","achternaam135"]
["2019-12-21","Abbott ",43820.333333333336,43820.875,"Arkan","achternaam136"]

{"sheet":"Verlof","index":2,"n_rows":234,"n_cols":6,"rows_kept":234,"cut":false,"hidden":false,"merged":[]}
["Weeknummer","Datum","Naam","Afdeling","aantal dagen","Goedgekeurd/ afgekeurd (reden)"]
[{"$f":"IF(B2<>\"\",WEEKNUM(B2),\"\")","v":48},"2019-11-30","Flavi Achternaam1",{"$f":"IF(C2<>\"\",VLOOKUP(C2,verlof,2,0),\"\")","v":"ABB weekenddienst"},20,"goedgekeurd"]
[49,"2019-12-01","Baki Achternaam2","ABB middag",15,"afgekeurd, teveel verlof"]
[49,"2019-12-01","Rolinka Achternaam3","SCHM",10,"afgekeurd, werkt te traag"]
[49,"2019-12-01","Erik Achternaam4","SCHM",3,"goedgekeurd"]
[48,"2019-11-24","Wolter Achternaam8","LCR ochtend",5,"goedgekeurd"]
[51,"2019-12-15","Rolinka Achternaam3","SCHM",8]
[46,"2019-11-16","Norbert Achternaam6","AFV HAS",2,"afgekeurd, teveel verlof"]
[51,"2019-12-18","Baki Achternaam2","ABB middag",2,"goedgekeurd"]
[51,"2019-12-20","Rolinka Achternaam3","SCHM",2]
[{"$f":"IF(B11<>\"\",WEEKNUM(B11),\"\")","v":51},"2019-12-15","Rolinka Achternaam3",{"$f":"IF(C11<>\"\",VLOOKUP(C11,verlof,2,0),\"\")","v":"SCHM"},3]
["",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,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,""]
["",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,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
[{"$f":"IF(B62<>\"\",WEEKNUM(B62),\"\")","v":""},null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,{"$f":"IF(C66<>\"\",VLOOKUP(C66,verlof,2,0),\"\")","v":""}]
["",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,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,""]
["",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,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,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
[{"$f":"IF(B126<>\"\",WEEKNUM(B126),\"\")","v":""},null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,{"$f":"IF(C130<>\"\",VLOOKUP(C130,verlof,2,0),\"\")","v":""}]
["",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,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,""]
["",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,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,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
[{"$f":"IF(B190<>\"\",WEEKNUM(B190),\"\")","v":""},null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,""]
["",null,null,{"$f":"IF(C194<>\"\",VLOOKUP(C194,verlof,2,0),\"\")","v":""}]
["",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,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,""]
["",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,null,""]
["",null,null,""]
["",null,null,""]

{"sheet":"Jaaroverzicht","index":3,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"JAARPLANNING"]
[null,null,null,{"$f":"WEEKDAY(E2)","v":"1900-01-01"},"2019-12-01",{"$f":"\"Week nr.\" & WEEKNUM(E2)","v":"Week nr.49"},{"$f":"WEEKDAY(H2)","v":"1900-01-02"},"2019-12-02",{"$f":"\"Week nr.\" & WEEKNUM(H2)","v":"Week nr.49"},{"$f":"WEEKDAY(K2)","v":"1900-01-03"},"2019-12-03",{"$f":"\"Week nr.\" & WEEKNUM(K2)","v":"Week nr.49"},{"$f":"WEEKDAY(N2)","v":"1900-01-04"},"2019-12-04",{"$f":"\"Week nr.\" & WEEKNUM(N2)","v":"Week nr.49"},{"$f":"WEEKDAY(Q2)","v":"1900-01-05"},"2019-12-05",{"$f":"\"Week nr.\" & WEEKNUM(Q2)","v":"Week nr.49"},{"$f":"WEEKDAY(T2)","v":"1900-01-06"},"2019-12-06",{"$f":"\"Week nr.\" & WEEKNUM(T2)","v":"Week nr.49"},{"$f":"WEEKDAY(W2)","v":"1900-01-07"},"2019-12-07",{"$f":"\"Week nr.\" & WEEKNUM(W2)","v":"Week nr.49"}]
["Afdeling","Verlof","FTE","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht","Vroeg","Laat","Nacht"]
["AFV",null,null,"06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1,null,null,null,"Baki Achternaam2","Jan Achternaam79",null,"Baki Achternaam2","Jan Achternaam79",null,"Baki Achternaam2","Jan Achternaam79",null,"Baki Achternaam2","Jan Achternaam79",null,"Baki Achternaam2","Jan Achternaam79"]
[null,null,2,null,null,null,"Ilker Achternaam38","Boyan Achternaam80",null,"Ilker Achternaam38","Boyan Achternaam80",null,"Ilker Achternaam38","Boyan Achternaam80",null,"Ilker Achternaam38","Boyan Achternaam80",null,"Ilker Achternaam38","Boyan Achternaam80"]
[null,null,3,null,null,null,"Miquel Achternaam39","Sami Achternaam81",null,"Miquel Achternaam39","Sami Achternaam81",null,"Miquel Achternaam39","Sami Achternaam81",null,"Miquel Achternaam39","Sami Achternaam81",null,"Miquel Achternaam39","Sami Achternaam81"]
[null,null,4,null,null,null,null,"Henri Achternaam82",null,"Klaas Achternaam40","Henri Achternaam82",null,"Klaas Achternaam40","Henri Achternaam82",null,"Klaas Achternaam40","Henri Achternaam82",null,"Klaas Achternaam40","Henri Achternaam82"]
[null,null,5,null,null,null,null,"Michel Achternaam83",null,null,"Michel Achternaam83",null,null,"Michel Achternaam83",null,null,"Michel Achternaam83",null,null,"Michel Achternaam83"]
[null,null,6]
[null,null,7]
[null,null,8]
["SCHM",null,"WERKTIIJDEN","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1,null,null,"Rolinka Achternaam3","Rachid Achternaam34","Marjolein Achternaam76","Patrick Achternaam88","Rachid Achternaam34","Marjolein Achternaam76","Patrick Achternaam88","Rachid Achternaam34","Marjolein Achternaam76","Patrick Achternaam88","Rachid Achternaam34","Roy Achternaam77","Patrick Achternaam88","Rachid Achternaam34","Roy Achternaam77"]
[null,null,2,null,null,"Erik Achternaam4","Evans Achternaam35","Roy Achternaam77","Rolinka Achternaam3","Evans Achternaam35","Roy Achternaam77","Rolinka Achternaam3","Evans Achternaam35","Roy Achternaam77","Rolinka Achternaam3","Evans Achternaam35",null,"Rolinka Achternaam3","Evans Achternaam35","Piet Achternaam78"]
[null,null,3,null,null,null,"Kevin Achternaam36","Piet Achternaam78","Erik Achternaam4","Kevin Achternaam36","Piet Achternaam78","Erik Achternaam4","Kevin Achternaam36","Piet Achternaam78","Erik Achternaam4","Kevin Achternaam36",null,"Erik Achternaam4","Kevin Achternaam36"]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
["HAS",null,"WERKTIIJDEN","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45","06:00/14:45","13:45/22:30","22:00/06:45"]
[null,null,1,null,null,null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49"]
[null,null,2,null,null,null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49",null,"Norbert Achternaam6","Paul Achternaam49"]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
["LCR",null,null,"06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1,null,null,null,"Wolter Achternaam8","Christiaan Achternaam51",null,"Wolter Achternaam8","Christiaan Achternaam51",null,"Wolter Achternaam8","Christiaan Achternaam51",null,"Wolter Achternaam8","Christiaan Achternaam51",null,"Wolter Achternaam8","Christiaan Achternaam51"]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
["ABB",null,null,{"$f":"IF(WEEKDAY(E2)=7,\"08:00/21:00 \",IF(WEEKDAY(E2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"08:00/14:45"},{"$f":"IF(WEEKDAY(E2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"13:45/22:30"},{"$f":"IF(OR(WEEKDAY(E2)=7,WEEKDAY(E2)=1),\" \",\"22:00/06:45\")","v":" "},{"$f":"IF(WEEKDAY(H2)=7,\"08:00/21:00 \",IF(WEEKDAY(H2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(H2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(H2)=7,WEEKDAY(H2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(K2)=7,\"08:00/21:00 \",IF(WEEKDAY(K2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(K2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(K2)=7,WEEKDAY(K2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(N2)=7,\"08:00/21:00 \",IF(WEEKDAY(N2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(N2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(N2)=7,WEEKDAY(N2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(Q2)=7,\"08:00/21:00 \",IF(WEEKDAY(Q2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(Q2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(Q2)=7,WEEKDAY(Q2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(T2)=7,\"08:00/21:00 \",IF(WEEKDAY(T2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"06:00/14:45"},{"$f":"IF(WEEKDAY(T2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(T2)=7,WEEKDAY(T2)=1),\" \",\"22:00/06:45\")","v":"22:00/06:45"},{"$f":"IF(WEEKDAY(W2)=7,\"08:00/21:00 \",IF(WEEKDAY(W2)=1,\"08:00/14:45\",\"06:00/14:45\"))","v":"08:00/21:00 "},{"$f":"IF(WEEKDAY(W2)=1,\"13:45/22:30\",\"14:45/23:30\")","v":"14:45/23:30"},{"$f":"IF(OR(WEEKDAY(W2)=7,WEEKDAY(W2)=1),\" \",\"22:00/06:45\")","v":" "}]
[null,"Flavi Achternaam1",1,"Flavi Achternaam1","Baki Achternaam2",null,"Flavi Achternaam1","Trienko Achternaam48",null,"Flavi Achternaam1","Trienko Achternaam48",null,"Flavi Achternaam1","Trienko Achternaam48",null,"Flavi Achternaam1","Trienko Achternaam48",null,"Flavi Achternaam1","Trienko Achternaam48",null,"Arkan Achternaam455"]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
["MEP",null,null,"06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45","06:00/14:45","14:45/23:30","22:00/06:45"]
[null,null,1,null,null,null,"Houcin Achternaam7","Rijk Achternaam50",null,"Houcin Achternaam7","Rijk Achternaam50",null,"Houcin Achternaam7","Rijk Achternaam50",null,"Houcin Achternaam7","Rijk Achternaam50",null,"Houcin Achternaam7","Rijk Achternaam50"]
[null,null,2,null,null,null,"Rudolf Achternaam44",null,null,"Rudolf Achternaam44",null,null,"Rudolf Achternaam44",null,null,"Rudolf Achternaam44",null,null,"Rudolf Achternaam44"]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]