{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Takenlijst","Instellingen en berekeningen"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Takenlijst","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,6]]}
[{"$nulls":7}," "]
[null,"Takenlijst van project"]
[]
[null,"Te voltooien door:",null,null,"Deadline:",null,"Activiteiten markeren"]
[null,"Kim Abercrombie",null,null,{"$f":"TODAY()+95","v":"2024-07-14"},null,"Geen markering"]
[null,"Project 1"]
[null,"Activiteit","Einddatum","Budget","Gereed","Voortgang","Notities"," "]
[null,"Planning",{"$f":"TODAY()-90","v":"2024-01-11"},{"v":476,"d":"€ 476.00"},null,{"v":0.25,"d":"25%"}]
[null,"Voorbereiding",{"$f":"TODAY()-2","v":"2024-04-08"},{"v":301,"d":"€ 301.00"},null,{"v":0.1,"d":"10%"}]
[null,"Taak A",{"$f":"TODAY()-7","v":"2024-04-03"},{"v":429,"d":"€ 429.00"},null,{"v":0,"d":"0%"}]
[null,"Taak B",{"$f":"TODAY()+20","v":"2024-04-30"},{"v":332,"d":"€ 332.00"},null,{"v":0.7,"d":"70%"}]
[null,"Taak C",{"$f":"TODAY()+40","v":"2024-05-20"},{"v":471,"d":"€ 471.00"},null,{"v":0.1,"d":"10%"}]
[null,"Taak D",{"$f":"TODAY()+45","v":"2024-05-25"},{"v":418,"d":"€ 418.00"},"JA",{"v":1,"d":"100%"}]
[null,"Papierwerk",{"$f":"TODAY()+55","v":"2024-06-04"},{"v":150,"d":"€ 150.00"},null,{"v":0,"d":"0%"},"Starten nadat taak B is voltooid"]
[null,"Overdracht",{"$f":"TODAY()+70","v":"2024-06-19"},{"v":330,"d":"€ 330.00"},null,{"v":0.25,"d":"25%"}]
[null,"Opvolgen",{"$f":"TODAY()+90","v":"2024-07-09"},{"v":353,"d":"€ 353.00"},null,{"v":0.5,"d":"50%"}]

{"sheet":"Instellingen en berekeningen","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[1,1,1,4],[3,1,3,4]]}
[{"$nulls":5}," "]
[null,"Markeringsinstellingen"]
[]
[null,"De onderstaande tabellen bevatten instellingen en berekeningen voor de vervolgkeuzelijst Activiteiten markeren.\nWijzigingen kunnen leiden tot fouten of verlies van functionaliteit."]
[null,"Geen markering",null,null,{"$f":"B5","v":"Geen markering"}]
[null,"Interval:","Begin:","Einde:","Einddatum:"]
[null,"Deze week",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2024-04-08"},{"$f":"C7+6","v":"2024-04-14"},{"$f":"B7&\" [\"&TEXT(C7,\"d mmm\")&\" - \"&TEXT(D7,\"d mmm\")&\"]\"","v":"Deze week [8 apr - 14 apr]"}]
[null,"Deze maand",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2024-04-01"},{"$f":"EDATE(C8,1)-1","v":"2024-04-30"},{"$f":"B8&\" [\"&TEXT(C8,\"d\")&\" - \"&TEXT(D8,\"d, mmm\")&\"]\"","v":"Deze maand [1 - 30, apr]"}]
[null,"Dit kwartaal",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2024-02-01"},{"$f":"EDATE(C9,4)-1","v":"2024-05-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"Dit kwartaal [1 feb - 31 mei]"}]
[null,"Dit jaar",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2024-01-01"},{"$f":"EDATE(C10,12)-1","v":"2024-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"jjjj\")&\"]\"","v":"Dit jaar [2024]"}]
[null,"Interval:",null,null,{"$f":"B11","v":"Interval:"}]
[null,"Afgelopen week",{"$f":"C7-7","v":"2024-04-01"},{"$f":"C12+6","v":"2024-04-07"},{"$f":"B12&\" [\"&TEXT(C12,\"d mmm\")&\" - \"&TEXT(D12,\"d mmm\")&\"]\"","v":"Afgelopen week [1 apr - 7 apr]"}]
[null,"Afgelopen maand",{"$f":"EDATE(C8,-1)","v":"2024-03-01"},{"$f":"EDATE(C13,1)-1","v":"2024-03-31"},{"$f":"B13&\" [\"&TEXT(C13,\"d\")&\" - \"&TEXT(D13,\"d, mmm\")&\"]\"","v":"Afgelopen maand [1 - 31, mrt]"}]
[null,"Afgelopen kwartaal",{"$f":"EDATE(C9,-3)","v":"2023-11-01"},{"$f":"EDATE(C14,3)-1","v":"2024-01-31"},{"$f":"B14&\" [\"&TEXT(C14,\"d mmm\")&\" - \"&TEXT(D14,\"d mmm\")&\"]\"","v":"Afgelopen kwartaal [1 nov - 31 jan]"}]
[null,"Afgelopen jaar",{"$f":"EDATE(C10,-12)","v":"2023-01-01"},{"$f":"EDATE(C15,12)-1","v":"2023-12-31"},{"$f":"B15","v":"Afgelopen jaar"}]
[null,"Geselecteerde markering:",{"$f":"IFERROR(MATCH(Activiteiten_markeren,lstToDoHighlights,0),\"\")","v":1},{"$f":"Activiteiten_markeren","v":"Geen markering"},{"$f":"ISNUMBER(INDEX($C$5:$C$15,C16))","v":false}]
[null,"Begin markeren",{"$f":"IFERROR(IF(C16=1,\"\",IF(E16,INDEX($C$5:$C$15,$C$16),\"\")),\"\")","v":""}]
[null,"Einde markeren",{"$f":"IFERROR(IF(C16=1,\"\",IF(E16,INDEX($D$5:$D$15,$C$16),\"\")),\"\")","v":""}]