{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Projectoverzicht","Taakgegevens"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Projectoverzicht","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Projectoverzicht"]
[]
[null,"Project","  ","Voortgang"," Begin"," Einde","Opmerkingen"]
[null,"Vakantie plannen",{"$f":"IFERROR((SUMIFS(Taken[Gereed],Taken[Project],Projecten[[#This Row],[Project]])/COUNTIFS(Taken[Project],Projecten[[#This Row],[Project]]))+0.0001,0.0001)","v":0.50009999999999999},{"$f":"REPT(\"|\",Projecten[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[Begin]))","v":"2011-10-01"},{"$f":"MAX(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[[Begin]:[Einde]]))","v":"2011-12-31"},"We gaan naar Belize!"]
[null,"Surpriseparty voor Sandra plannen",{"$f":"IFERROR((SUMIFS(Taken[Gereed],Taken[Project],Projecten[[#This Row],[Project]])/COUNTIFS(Taken[Project],Projecten[[#This Row],[Project]]))+0.0001,0.0001)","v":1.0001},{"$f":"REPT(\"|\",Projecten[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[Begin]))","v":"2011-09-10"},{"$f":"MAX(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[[Begin]:[Einde]]))","v":"2011-10-03"}]
[null,"Trainen voor marathon",{"$f":"IFERROR((SUMIFS(Taken[Gereed],Taken[Project],Projecten[[#This Row],[Project]])/COUNTIFS(Taken[Project],Projecten[[#This Row],[Project]]))+0.0001,0.0001)","v":0.28581428571428569},{"$f":"REPT(\"|\",Projecten[[  ]]*175)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[Begin]))","v":"2011-09-01"},{"$f":"MAX(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[[Begin]:[Einde]]))","v":"2012-04-18"},"Mijn record verbeteren op 18 april"]
[null,"Sandra inschrijven voor zwemles",{"$f":"IFERROR((SUMIFS(Taken[Gereed],Taken[Project],Projecten[[#This Row],[Project]])/COUNTIFS(Taken[Project],Projecten[[#This Row],[Project]]))+0.0001,0.0001)","v":1E-4},{"$f":"REPT(\"|\",Projecten[[  ]]*175)","v":""},{"$f":"MIN(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[Begin]))","v":"2011-10-01"},{"$f":"MAX(IF((Taken[Project]=Projecten[[#This Row],[Project]])*(Taken[Begin]>0),Taken[[Begin]:[Einde]]))","v":"2011-10-15"}]

{"sheet":"Taakgegevens","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Taakgegevens"]
[]
[null,"Begin","Einde","Project","Taak","Gereed","Opmerkingen"]
[null,"2011-10-01","2011-10-15","Vakantie plannen","Kiezen tussen tropisch & gematigd",1,"Heb gekozen voor tropisch.  Belize we komen eraan!"]
[null,"2011-10-15","2011-12-31","Vakantie plannen","Kosten van online vliegtickets in de lente in de gaten houden"]
[null,"2011-10-15",null,"Vakantie plannen","Geschiedenis en cultuur van Belize bestuderen"]
[null,"2011-10-15","2011-10-20","Vakantie plannen","Hotelbeoordelingen doorlezen",1]
[null,"2011-10-20",null,"Vakantie plannen","Hotel reserveren",1,"10 april tot en met 30 april"]
[null,"2011-10-20","2011-11-15","Vakantie plannen","Paspoort voor iedereen in het gezin aanvragen",null,"Spoedoptie bekijken…"]
[null,"2011-09-01","2011-09-30","Trainen voor marathon","10 kilometer per dag",1,"Wedstrijd is op 18 april"]
[null,"2011-10-01","2011-10-31","Trainen voor marathon","12 kilometer per dag",1]
[null,"2011-11-01","2011-11-30","Trainen voor marathon","14 kilometer per dag"]
[null,"2011-12-01","2012-04-15","Trainen voor marathon","15 kilometer per dag"]
[null,"2012-04-16",null,"Trainen voor marathon","Reizen naar marathon"]
[null,"2012-04-16","2012-04-17","Trainen voor marathon","Cursus controleren",null,"10 kilometer joggen per dag"]
[null,"2012-04-18",null,"Trainen voor marathon","Over de finish in minder dan 3 uur!",null,"Nu gaan we naar Belize!"]
[null,"2011-09-10",null,"Surpriseparty voor Sandra plannen","Uitnodigingen versturen",1,"Surpriseparty op 3 oktober"]
[null,"2011-09-20",null,"Surpriseparty voor Sandra plannen","Catering bestellen",1]
[null,"2011-09-22",null,"Surpriseparty voor Sandra plannen","Optreden boeken",1]
[null,"2011-10-03",null,"Surpriseparty voor Sandra plannen","Dag van het feestje!",1,"Het was geweldig. Het kwam voor haar als een complete verrassing!"]
[null,"2011-10-01","2011-10-15","Sandra inschrijven voor zwemles","Prijzen bij buurthuis vergelijken"]