{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["macro uitvoer","juiste uitvoer","Voorwaarden","origineel"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"macro uitvoer","index":0,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Nr","2020-05-06","21:00:00","tekst","opdracht",6]
["Nr","2020-05-06","21:30:00","tekst","opdracht"]
["Nr","2020-05-06","22:00:00","tekst","opdracht"]
["Nr","2020-05-06","23:59:00","tekst","opdracht"]
["Nr","2020-05-14","00:15:00","tekst","opdracht"]
["Nr","2020-05-14","00:30:00","tekst","opdracht"]
["Nr","2020-05-14","21:00:00","tekst","opdracht",10]
["Nr","2020-05-14","21:00:00","tekst","opdracht"]
["Nr","2020-05-14","21:30:00","tekst","opdracht"]
["Nr","2020-05-14","23:59:00","tekst","opdracht"]
["Nr","2020-05-15","00:15:00","tekst","opdracht"]
["Nr","2020-05-15","00:30:00","tekst","opdracht"]
["Nr","2020-05-15","00:45:00","tekst","opdracht"]
["Nr","2020-05-15","01:00:00","tekst","opdracht"]
["Nr","2020-05-15","01:15:00","tekst","opdracht"]
["Nr","2020-05-15","01:30:00","tekst","opdracht"]
["Nr","2020-05-16","01:00:00","tekst","opdracht",11]
["Nr","2020-05-16","01:15:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","21:00:00","tekst","opdracht"]
["Nr","2020-05-18","21:30:00","tekst","opdracht"]
["Nr","2020-05-18","22:00:00","tekst","opdracht"]
["Nr","2020-05-18","23:59:00","tekst","opdracht"]
["Nr","2020-05-19","00:15:00","tekst","opdracht"]
["Nr","2020-05-19","00:45:00","tekst","opdracht"]
["Nr","2020-05-19","21:00:00","tekst","opdracht",8]
["Nr","2020-05-19","21:30:00","tekst","opdracht"]
["Nr","2020-05-19","23:59:00","tekst","opdracht"]
["Nr","2020-05-20","00:15:00","tekst","opdracht"]
["Nr","2020-05-20","00:30:00","tekst","opdracht"]
["Nr","2020-05-20","00:45:00","tekst","opdracht"]
["Nr","2020-05-20","01:00:00","tekst","opdracht"]
["Nr","2020-05-20","01:15:00","tekst","opdracht"]
["Nr","2020-05-25","21:00:00","tekst","opdracht",5]
["Nr","2020-05-25","23:59:00","tekst","opdracht"]
["Nr","2020-05-26","00:15:00","tekst","opdracht"]
["Nr","2020-05-26","00:30:00","tekst","opdracht"]
["Nr","2020-05-26","00:45:00","tekst","opdracht"]
["Nr","2020-05-26","21:00:00","tekst","opdracht",7]
["Nr","2020-05-26","21:30:00","tekst","opdracht"]
["Nr","2020-05-26","23:59:00","tekst","opdracht"]
["Nr","2020-05-27","00:15:00","tekst","opdracht"]
["Nr","2020-05-27","00:30:00","tekst","opdracht"]
["Nr","2020-05-27","00:45:00","tekst","opdracht"]
["Nr","2020-05-27","01:00:00","tekst","opdracht"]
["Nr","2020-05-27","21:00:00","tekst","opdracht",6]
["Nr","2020-05-27","23:59:00","tekst","opdracht"]
["Nr","2020-05-28","00:15:00","tekst","opdracht"]
["Nr","2020-05-28","00:30:00","tekst","opdracht"]
["Nr","2020-05-28","00:45:00","tekst","opdracht"]
["Nr","2020-05-28","01:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:00:00","tekst","opdracht",9]
["Nr","2020-05-28","21:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:30:00","tekst","opdracht"]
["Nr","2020-05-28","22:00:00","tekst","opdracht"]
["Nr","2020-05-28","23:59:00","tekst","opdracht"]
["Nr","2020-05-29","00:15:00","tekst","opdracht"]
["Nr","2020-05-29","00:30:00","tekst","opdracht"]
["Nr","2020-05-29","00:45:00","tekst","opdracht"]
["Nr","2020-05-29","01:00:00","tekst","opdracht"]

{"sheet":"juiste uitvoer","index":1,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Nr","2020-05-06","21:00:00","tekst","opdracht",4]
["Nr","2020-05-06","21:30:00","tekst","opdracht"]
["Nr","2020-05-06","22:00:00","tekst","opdracht"]
["Nr","2020-05-06","23:59:00","tekst","opdracht"]
["Nr","2020-05-14","00:15:00","tekst","opdracht",2]
["Nr","2020-05-14","00:30:00","tekst","opdracht"]
["Nr","2020-05-14","21:00:00","tekst","opdracht",10]
["Nr","2020-05-14","21:00:00","tekst","opdracht"]
["Nr","2020-05-14","21:30:00","tekst","opdracht"]
["Nr","2020-05-14","23:59:00","tekst","opdracht"]
["Nr","2020-05-15","00:15:00","tekst","opdracht"]
["Nr","2020-05-15","00:30:00","tekst","opdracht"]
["Nr","2020-05-15","00:45:00","tekst","opdracht"]
["Nr","2020-05-15","01:00:00","tekst","opdracht"]
["Nr","2020-05-15","01:15:00","tekst","opdracht"]
["Nr","2020-05-15","01:30:00","tekst","opdracht"]
["Nr","2020-05-16","01:00:00","tekst","opdracht",2]
["Nr","2020-05-16","01:15:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht",3]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","21:00:00","tekst","opdracht",6]
["Nr","2020-05-18","21:30:00","tekst","opdracht"]
["Nr","2020-05-18","22:00:00","tekst","opdracht"]
["Nr","2020-05-18","23:59:00","tekst","opdracht"]
["Nr","2020-05-19","00:15:00","tekst","opdracht"]
["Nr","2020-05-19","00:45:00","tekst","opdracht"]
["Nr","2020-05-19","21:00:00","tekst","opdracht",8]
["Nr","2020-05-19","21:30:00","tekst","opdracht"]
["Nr","2020-05-19","23:59:00","tekst","opdracht"]
["Nr","2020-05-20","00:15:00","tekst","opdracht"]
["Nr","2020-05-20","00:30:00","tekst","opdracht"]
["Nr","2020-05-20","00:45:00","tekst","opdracht"]
["Nr","2020-05-20","01:00:00","tekst","opdracht"]
["Nr","2020-05-20","01:15:00","tekst","opdracht"]
["Nr","2020-05-25","21:00:00","tekst","opdracht",5]
["Nr","2020-05-25","23:59:00","tekst","opdracht"]
["Nr","2020-05-26","00:15:00","tekst","opdracht"]
["Nr","2020-05-26","00:30:00","tekst","opdracht"]
["Nr","2020-05-26","00:45:00","tekst","opdracht"]
["Nr","2020-05-26","21:00:00","tekst","opdracht",7]
["Nr","2020-05-26","21:30:00","tekst","opdracht"]
["Nr","2020-05-26","23:59:00","tekst","opdracht"]
["Nr","2020-05-27","00:15:00","tekst","opdracht"]
["Nr","2020-05-27","00:30:00","tekst","opdracht"]
["Nr","2020-05-27","00:45:00","tekst","opdracht"]
["Nr","2020-05-27","01:00:00","tekst","opdracht"]
["Nr","2020-05-27","21:00:00","tekst","opdracht",6]
["Nr","2020-05-27","23:59:00","tekst","opdracht"]
["Nr","2020-05-28","00:15:00","tekst","opdracht"]
["Nr","2020-05-28","00:30:00","tekst","opdracht"]
["Nr","2020-05-28","00:45:00","tekst","opdracht"]
["Nr","2020-05-28","01:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:00:00","tekst","opdracht",9]
["Nr","2020-05-28","21:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:30:00","tekst","opdracht"]
["Nr","2020-05-28","22:00:00","tekst","opdracht"]
["Nr","2020-05-28","23:59:00","tekst","opdracht"]
["Nr","2020-05-29","00:15:00","tekst","opdracht"]
["Nr","2020-05-29","00:30:00","tekst","opdracht"]
["Nr","2020-05-29","00:45:00","tekst","opdracht"]
["Nr","2020-05-29","01:00:00","tekst","opdracht"]

{"sheet":"Voorwaarden","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"maandag","2020-02-03","21:00:00","23:59:00",null,"rood"]
[null,null,"dinsdag","2020-02-04","00:00:00","07:00:00",null,"rood"]
[]
[null,null,"dinsdag","2020-02-04","21:00:00","23:59:00",null,"geel"]
[null,null,"woensdag","2020-02-05","00:00:00","07:00:00",null,"geel"]
[]
[null,null,"woensdag","2020-02-05","21:00:00","23:59:00",null,"rood"]
[null,null,"donderdag","2020-02-06","00:00:00","07:00:00",null,"rood"]
[]
[null,null,"donderdag","2020-02-06","21:00:00","23:59:00",null,"geel"]
[null,null,"vrijdag","2020-02-07","00:00:00","07:00:00",null,"geel"]
[]
[null,null,"zaterdag","altijd",null,null,null,"wit"]
[null,null,"zondag","altijd",null,null,null,"wit"]
[]
[null,null,"elke dag",null,"08:00:00","20:59:00",null,"groen"]

{"sheet":"origineel","index":3,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["Nr","2020-05-06","21:00:00","tekst","opdracht"]
["Nr","2020-05-06","21:30:00","tekst","opdracht"]
["Nr","2020-05-06","22:00:00","tekst","opdracht"]
["Nr","2020-05-06","23:59:00","tekst","opdracht"]
["Nr","2020-05-07","00:15:00","tekst","opdracht"]
["Nr","2020-05-07","00:30:00","tekst","opdracht"]
["Nr","2020-05-07","21:00:00","tekst","opdracht"]
["Nr","2020-05-07","21:30:00","tekst","opdracht"]
["Nr","2020-05-07","22:00:00","tekst","opdracht"]
["Nr","2020-05-07","23:59:00","tekst","opdracht"]
["Nr","2020-05-08","00:15:00","tekst","opdracht"]
["Nr","2020-05-08","00:45:00","tekst","opdracht"]
["Nr","2020-05-08","05:00:00","tekst","opdracht"]
["Nr","2020-05-11","21:00:00","tekst","opdracht"]
["Nr","2020-05-11","23:59:00","tekst","opdracht"]
["Nr","2020-05-12","00:15:00","tekst","opdracht"]
["Nr","2020-05-12","00:30:00","tekst","opdracht"]
["Nr","2020-05-12","21:00:00","tekst","opdracht"]
["Nr","2020-05-12","22:00:00","tekst","opdracht"]
["Nr","2020-05-12","22:30:00","tekst","opdracht"]
["Nr","2020-05-12","23:00:00","tekst","opdracht"]
["Nr","2020-05-12","23:59:00","tekst","opdracht"]
["Nr","2020-05-13","00:15:00","tekst","opdracht"]
["Nr","2020-05-13",null,"tekst","opdracht"]
["Nr","2020-05-14","00:15:00","tekst","opdracht"]
["Nr","2020-05-14","00:30:00","tekst","opdracht"]
["Nr","2020-05-14","21:00:00","tekst","opdracht"]
["Nr","2020-05-14","21:00:00","tekst","opdracht"]
["Nr","2020-05-14","21:30:00","tekst","opdracht"]
["Nr","2020-05-14","23:59:00","tekst","opdracht"]
["Nr","2020-05-15","00:15:00","tekst","opdracht"]
["Nr","2020-05-15","00:30:00","tekst","opdracht"]
["Nr","2020-05-15","00:45:00","tekst","opdracht"]
["Nr","2020-05-15","01:00:00","tekst","opdracht"]
["Nr","2020-05-15","01:15:00","tekst","opdracht"]
["Nr","2020-05-15","01:30:00","tekst","opdracht"]
["Nr","2020-05-16","01:00:00","tekst","opdracht"]
["Nr","2020-05-16","01:15:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","08:00:00","tekst","opdracht"]
["Nr","2020-05-18","21:00:00","tekst","opdracht"]
["Nr","2020-05-18","21:30:00","tekst","opdracht"]
["Nr","2020-05-18","22:00:00","tekst","opdracht"]
["Nr","2020-05-18","23:59:00","tekst","opdracht"]
["Nr","2020-05-19","00:15:00","tekst","opdracht"]
["Nr","2020-05-19","00:45:00","tekst","opdracht"]
["Nr","2020-05-19","21:00:00","tekst","opdracht"]
["Nr","2020-05-19","21:30:00","tekst","opdracht"]
["Nr","2020-05-19","23:59:00","tekst","opdracht"]
["Nr","2020-05-20","00:15:00","tekst","opdracht"]
["Nr","2020-05-20","00:30:00","tekst","opdracht"]
["Nr","2020-05-20","00:45:00","tekst","opdracht"]
["Nr","2020-05-20","01:00:00","tekst","opdracht"]
["Nr","2020-05-20","01:15:00","tekst","opdracht"]
["Nr","2020-05-25","21:00:00","tekst","opdracht"]
["Nr","2020-05-25","23:59:00","tekst","opdracht"]
["Nr","2020-05-26","00:15:00","tekst","opdracht"]
["Nr","2020-05-26","00:30:00","tekst","opdracht"]
["Nr","2020-05-26","00:45:00","tekst","opdracht"]
["Nr","2020-05-26","21:00:00","tekst","opdracht"]
["Nr","2020-05-26","21:30:00","tekst","opdracht"]
["Nr","2020-05-26","23:59:00","tekst","opdracht"]
["Nr","2020-05-27","00:15:00","tekst","opdracht"]
["Nr","2020-05-27","00:30:00","tekst","opdracht"]
["Nr","2020-05-27","00:45:00","tekst","opdracht"]
["Nr","2020-05-27","01:00:00","tekst","opdracht"]
["Nr","2020-05-27","21:00:00","tekst","opdracht"]
["Nr","2020-05-27","23:59:00","tekst","opdracht"]
["Nr","2020-05-28","00:15:00","tekst","opdracht"]
["Nr","2020-05-28","00:30:00","tekst","opdracht"]
["Nr","2020-05-28","00:45:00","tekst","opdracht"]
["Nr","2020-05-28","01:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:00:00","tekst","opdracht"]
["Nr","2020-05-28","21:30:00","tekst","opdracht"]
["Nr","2020-05-28","22:00:00","tekst","opdracht"]
["Nr","2020-05-28","23:59:00","tekst","opdracht"]
["Nr","2020-05-29","00:15:00","tekst","opdracht"]
["Nr","2020-05-29","00:30:00","tekst","opdracht"]
["Nr","2020-05-29","00:45:00","tekst","opdracht"]
["Nr","2020-05-29","01:00:00","tekst","opdracht"]