{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Takenlijst docent"," Overzicht gegevens"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Takenlijst docent","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,1,0,2],[0,4,0,8],[2,9,6,9]]}
[null,"Takenlijst docent",null,"Overzicht gegevens","Kleurenlegenda voor Status staat in deze cel: Niet gestart is standaardstijl, Wordt uitgevoerd is R=91 G=133 B=49, Einddatum vandaag is R=118 G=88 B=0, In bewaring is R=109 G=66 B=111, Voltooid is doorhalen, Geannuleerd is R=191 G=191 B=191 en Te laat is R=191 G=33 B=28."]
[null,"ITEM","CATEGORIE","BEGINDATUM","EINDDATUM","RESTERENDE DAGEN","STATUS","NOTITIES"]
[null,"Kasten reinigen","Kantoor",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,6)","v":"2018-04-06"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2018-04-16"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":""},"Voltooid",null,null,"Statusslicer staat in deze cel. Als u de lijst wilt filteren op Status, selecteert u een status in de slicer. Houd CTRL ingedrukt om meerdere opties te selecteren."]
[null,"Stickers bestellen","Benodigdheden",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,11)","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":""},"Voltooid"]
[null,"Vloeren gedweild en in de was gezet","Overig",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())-25)","v":"2018-04-14"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":""},"Voltooid"]
[null,"Naamlabels gemaakt","Benodigdheden",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2018-04-01"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":""},"In bewaring"]
[null,"Rapporten met kwartaalcijfers opgesteld","Beoordelingen",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"TODAY()-5","v":"2018-05-04"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":-5},"Te laat"]
[null,"Herinnering per e-mail voor machtigingsbonnen","Bellen",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-05-01"},{"$f":"TODAY()","v":"2018-05-09"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":""},"Geannuleerd"]
[null,"Mondelinge rapporten beoordelen","Kantoor",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),7)","v":"2018-05-07"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),17)","v":"2018-05-17"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":8},"Wordt uitgevoerd"]
[null,"Potloden slijpen","Benodigdheden",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),11)","v":"2018-05-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),10)","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(Lijst[[#This Row],[BEGINDATUM]]:Lijst[[#This Row],[EINDDATUM]])<>2,\"\",IF(OR(Lijst[[#This Row],[STATUS]]=\"Voltooid\",Lijst[[#This Row],[STATUS]]=\"Geannuleerd\",Lijst[[#This Row],[STATUS]]=\"In bewaring\"),\"\",Lijst[[#This Row],[EINDDATUM]]-TODAY())),\"\")","v":1},"Wordt uitgevoerd"]

{"sheet":" Overzicht gegevens","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
[null,"Overzicht gegevens","Takenlijst docent"]
[null,"Categorie"]
[null,"Kantoor"]
[null,"Benodigdheden"]
[null,"Aan te schaffen"]
[null,"Bellen"]
[null,"Nieuwe ideeën"]
[null,"Beoordelingen"]
[null,"Team"]
[null,"Acties"]
[null,"Computer"]
[null,"Persoonlijk"]
[null,"Overig"]