{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Blad1","index":0,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,5,32,14],[35,5,35,14],[15,6,24,11],[26,2,26,14],[29,5,29,14]]}
["2023-01-01",null,{"$f":"NOW()","v":"2023-02-23T10:12:59.160"},null,null,null,null,{"$f":"DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))","v":"2024-01-01"}]
[]
[]
[null,null,{"$f":"IF(N4=\"\",\"\",N4)","v":"2022-12-31"},{"$f":"IF(N4=\"\",\"\",IF(N4<$A$1,ROUND(ABS($C$1-$A$1),)& \" dagen verlopen\",\"\"))","v":"53 dagen verlopen"},{"$f":"IF(O4=\"\",\"\",O4)","v":"2022-05-01"},null,{"$f":"IF(AND($C4>=$A$1,$C4<$H$1),1,IF($C4<=$A$1,2,0))","v":2},{"$f":"IF(AND($E4>=$A$1,$E4<$H$1),1,IF($E4<=$A$1,2,0))","v":2},null,null,{"$f":"COUNTIF($G4:$H4,1)","v":0},{"$f":"COUNTIF($G4:$H4,2)","v":2},null,"2022-12-31","2022-05-01"]
[null,null,{"$f":"IF(N5=\"\",\"\",N5)","v":"2023-04-01"},{"$f":"IF(N5=\"\",\"\",IF(N5<$A$1,ROUND(ABS($C$1-$A$1),)& \" dagen verlopen\",\"\"))","v":""},{"$f":"IF(O5=\"\",\"\",O5)","v":" "},null,{"$f":"IF(AND($C5>=$A$1,$C5<$H$1),1,IF($C5<=$A$1,2,0))","v":1},{"$f":"IF(AND($E5>=$A$1,$E5<$H$1),1,IF($E5<=$A$1,2,0))","v":0},null,null,{"$f":"COUNTIF($G5:$H5,1)","v":1},{"$f":"COUNTIF($G5:$H5,2)","v":0},null,"2023-04-01"," "]
[null,null,{"$f":"IF(N6=\"\",\"\",N6)","v":"2022-04-15"},"53 dagen verlopen"," ",null,2,0,null,null,0,1,null,"2022-04-15"," "]
[null,null,{"$f":"IF(N7=\"\",\"\",N7)","v":""},""," ",null,0,0,null,null,0,0,null,null," "]
[null,null,{"$f":"IF(N8=\"\",\"\",N8)","v":""},""," ",null,0,0,null,null,0,0,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"De cellen zijn allemaal beveiligd d.m.v. de optie \"Rechter muisknop\", \"Celeigenschappen\", \"Bescherming\" en \"Geblokkeerd\".\nOm het werkblad vrij te geven en de formules te bekijken selecteer het Tabbald \"Controleren\", klik daarna op \"Blad beveiligen\" en tik als wachtwoord in \"Rob\".\nOp dezelfde manier beveilig je ook het blad weer. Zorg er wel voor de het vinkje bij \"Vergrendelde cellen selecteren\" uit staat zodat alleen de vrij gegeven cellen bereikbaar zijn."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Eventueel nog een optie voor verlopen opleidingen!"]
[]
[null,null,{"$f":"IF(N29=\"\",\"\",N29)","v":"2022-12-31"},null,null,null,{"$f":"IF(AND($C29>=$A$1,$C29<$H$1),1,IF($C29<=$A$1,2,0))","v":2},{"$f":"IF(AND($E29>=$A$1,$E29<$H$1),1,IF($E29<=$A$1,2,0))","v":2},null,null,{"$f":"COUNTIF($G29:$H29,1)","v":0},{"$f":"COUNTIF($G29:$H29,2)","v":2},null,"2022-12-31"," "]
[null,null,{"$f":"IF(N29=\"\",\"\",IF(N29<$A$1,ROUND(ABS($C$1-$A$1),)& \" dagen verlopen\",\"\"))","v":"53 dagen verlopen"},null,{"$f":"IF(N29<$A$1,ROUND(($C$1-$A$1),0),\"\")","v":53},"<= Deze berekening kijkt naar aftest datum en 1e dag van huidig jaar. Als aftest ouder is dan 1e dag van het jaar wordt het verschil van de huidige dag met 1e dag van het jaar berekend."]
[]
[null,null,{"$f":"IF(N32=\"\",\"\",N32)","v":"2022-12-01"},null,null,null,{"$f":"IF(AND($C32>=$A$1,$C32<$H$1),1,IF($C32<=$A$1,2,0))","v":2},{"$f":"IF(AND($E32>=$A$1,$E32<$H$1),1,IF($E32<=$A$1,2,0))","v":2},null,null,{"$f":"COUNTIF($G32:$H32,1)","v":0},{"$f":"COUNTIF($G32:$H32,2)","v":2},null,"2022-12-01"," "]
[null,null,{"$f":"IF(N32=\"\",\"\",IF(N32<$A$1,ROUND(ABS($C$1-$N$32),)& \" dagen verlopen\",\"\"))","v":"84 dagen verlopen"},null,{"$f":"IF(N32<$A$1,ROUND(($C$1-$N$32),0),\"\")","v":84},"<= Deze berekening kijkt naar aftest datum en 1e dag van huidig jaar. Als aftest ouder is dan 1e dag van het jaar wordt het verschil van de huidige dag met de ingevoerde aftest datum berekend."]
[]
[null,null,{"$f":"IF(N35=\"\",\"\",N35)","v":"2022-12-01"},null,null,null,{"$f":"IF(AND($C35>=$A$1,$C35<$H$1),1,IF($C35<=$A$1,2,0))","v":2},{"$f":"IF(AND($E35>=$A$1,$E35<$H$1),1,IF($E35<=$A$1,2,0))","v":2},null,null,{"$f":"COUNTIF($G35:$H35,1)","v":0},{"$f":"COUNTIF($G35:$H35,2)","v":2},null,"2022-12-01"," "]
[null,null,{"$f":"IF(N35=\"\",\"\",IF(N35<$A$1,ROUND(ABS($C$1-$N$32),)& \" dagen verlopen\",\"\"))","v":"84 dagen verlopen"},null,{"$f":"IF(N35<$A$1,ROUND(($C$1-$N$32),0),\"\")","v":84},"<= Deze berekening kijkt naar aftest datum en 1e dag van huidig jaar. Als aftest ouder is dan 1e dag van het jaar wordt het verschil van de huidige dag met de ingevoerde aftest datum berekend."]