{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blad1","beschikbaar en uren per cat."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Blad1","index":0,"n_rows":29,"n_cols":190,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-23",{"$f":"M1+7","v":"2020-08-30"},{"$f":"N1+7","v":"2020-09-06"},"2020-09-13","2020-09-20","2020-09-27","2020-10-04","2020-10-11","2020-10-18","2020-10-25","2020-11-01","2020-11-08","2020-11-15","2020-11-22","2020-11-29","2020-12-06","2020-12-13","2020-12-20","2020-12-27","2021-01-03","2021-01-10","2021-01-17","2021-01-24","2021-01-31","2021-02-07","2021-02-14","2021-02-21","2021-02-28","2021-03-07","2021-03-14","2021-03-21","2021-03-28","2021-04-04","2021-04-11","2021-04-18","2021-04-25","2021-05-02","2021-05-09","2021-05-16","2021-05-23","2021-05-30","2021-06-06","2021-06-13","2021-06-20","2021-06-27","2021-07-04","2021-07-11","2021-07-18","2021-07-25","2021-08-01","2021-08-08","2021-08-15","2021-08-22","2021-08-29","2021-09-05","2021-09-12","2021-09-19","2021-09-26","2021-10-03","2021-10-10","2021-10-17","2021-10-24","2021-10-31","2021-11-07","2021-11-14","2021-11-21",{"$f":"BZ1+7","v":"2021-11-28"},"2021-12-05",{"$f":"CB1+7","v":"2021-12-12"},"2021-12-19","2021-12-26","2022-01-02","2022-01-09","2022-01-16","2022-01-23","2022-01-30","2022-02-06","2022-02-13","2022-02-20","2022-02-27","2022-03-06","2022-03-13","2022-03-20","2022-03-27","2022-04-03","2022-04-10","2022-04-17","2022-04-24","2022-05-01","2022-05-08","2022-05-15","2022-05-22","2022-05-29","2022-06-05","2022-06-12","2022-06-19","2022-06-26","2022-07-03","2022-07-10","2022-07-17","2022-07-24","2022-07-31","2022-08-07","2022-08-14","2022-08-21","2022-08-28","2022-09-04","2022-09-11","2022-09-18","2022-09-25","2022-10-02","2022-10-09","2022-10-16","2022-10-23","2022-10-30","2022-11-06","2022-11-13","2022-11-20","2022-11-27","2022-12-04","2022-12-11","2022-12-18","2022-12-25","2023-01-01","2023-01-08","2023-01-15","2023-01-22","2023-01-29","2023-02-05","2023-02-12","2023-02-19","2023-02-26",{"$f":"EN1+7","v":"2023-03-05"},"2023-03-12","2023-03-19","2023-03-26","2023-04-02","2023-04-09","2023-04-16","2023-04-23","2023-04-30","2023-05-07","2023-05-14","2023-05-21","2023-05-28","2023-06-04","2023-06-11","2023-06-18","2023-06-25","2023-07-02","2023-07-09","2023-07-16","2023-07-23","2023-07-30","2023-08-06","2023-08-13","2023-08-20","2023-08-27","2023-09-03","2023-09-10","2023-09-17","2023-09-24","2023-10-01","2023-10-08","2023-10-15","2023-10-22","2023-10-29","2023-11-05","2023-11-12","2023-11-19","2023-11-26","2023-12-03","2023-12-10","2023-12-17",{"$f":"GD1+7","v":"2023-12-24"},"2023-12-31","2024-01-07","2024-01-14"]
[]
["Dossiernr.","Datum ingediend","Start eve.","Einde eve.","tussenstap 1","tussenstap 2","1 ste wk workload Week en Jaar","Beh. ambtenaar","Omschrijving","Categorie","Uren benodigd per cat",null,"35-2020","36-2020","37-2020","38-2020","39-2020","40-2020","41-2020","42-2020","43-2020","44-2020","45-2020","46-2020","47-2020","48-2020","49-2020","50-2020","51-2020","52-2020","53-2020","2-2021","3-2021","4-2021","5-2021","6-2021","7-2021","8-2021","9-2021","10-2021","11-2021","12-2021","13-2021","14-2021","15-2021","16-2021","17-2021","18-2021","19-2021","20-2021","21-2021","22-2021","23-2021","24-2021","25-2021","26-2021","27-2021","28-2021","29-2021","30-2021","31-2021","32-2021","33-2021","34-2021","35-2021","36-2021","37-2021","38-2021","39-2021","40-2021","41-2021","42-2021","43-2021","44-2021","45-2021","46-2021","47-2021","48-2021","49-2021","50-2021","51-2021","52-2021","53-2021","2-2022","3-2022","4-2022","5-2022","6-2022","7-2022","8-2022","9-2022","10-2022","11-2022","12-2022","13-2022","14-2022","15-2022","16-2022","17-2022","18-2022","19-2022","20-2022","21-2022","22-2022","23-2022","24-2022","25-2022","26-2022","27-2022","28-2022","29-2022","30-2022","31-2022","32-2022","33-2022","34-2022","35-2022","36-2022","37-2022","38-2022","39-2022","40-2022","41-2022","42-2022","43-2022","44-2022","45-2022","46-2022","47-2022","48-2022","49-2022","50-2022","51-2022","52-2022","53-2022","1-2023","2-2023","3-2023","4-2023","5-2023","6-2023","7-2023","8-2023","9-2023","10-2023","11-2023","12-2023","13-2023","14-2023","15-2023","16-2023","17-2023","18-2023","19-2023","20-2023","21-2023","22-2023","23-2023","24-2023","25-2023","26-2023","27-2023","28-2023","29-2023","30-2023","31-2023","32-2023","33-2023","34-2023","35-2023","36-2023","37-2023","38-2023","39-2023","40-2023","41-2023","42-2023","43-2023","44-2023","45-2023","46-2023","47-2023","48-2023","49-2023","50-2023","51-2023","52-2023","53-2023","2-2024","3-2024"]
[11042054,null,"01-01-2021","01-01-2021","2020-08-28",{"$f":"IF(J4=\"\",0,IF(J4=\"C\",18*7,IF(J4=\"B\",17*7,IF(J4=\"K\",4*7,IF(J4=\"A\",16*7,\"\")))))","v":126},{"$f":"WEEKNUM(E4)&\"-\"&YEAR(E4)","v":"35-2020"},"Piet","Nieuwjaarsduik Noordersingel","C",{"$f":"IF(J4=0,\"\",VLOOKUP(J4,uren,2,FALSE))","v":44}]
[11042024,null,"13-02-2021","2021-02-21",{"$f":"DATEVALUE(C5)-F5","v":"2020-10-24"},{"$f":"IF(J5=\"\",0,IF(J5=\"C\",18*7,IF(J5=\"B\",17*7,IF(J5=\"K\",4*7,IF(J5=\"A\",16*7,\"\")))))","v":112},{"$f":"WEEKNUM(E5)&\"-\"&YEAR(E5)","v":"43-2020"},"Piet","Sint Piter","A",20]
[11042617,null,"13-02-2022","2021-03-13","2021-10-24",112,"44-2021","Piet","Media Art Festival","A",20]
[11040187,null,"13-02-2023","2021-03-06","2022-10-17",119,"43-2022","Piet","LUNA","B",33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,3,3,3,3,3,3,3]
[11042849,null,"13-02-2024","18-04-2021","2023-10-17",119,"42-2023","Piet","Lunato kermis","B",33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,3,3,3,3,3,3,3]
[11042087,null,"15-04-2021","15-04-2021","2020-12-17",119,"51-2020","Piet","Herdenking Bevrijding Leeuwarden en Fryslan (2021)","B",33]
[11042092,null,"15-04-2021","17-04-2021","2020-12-17",119,"51-2020","Piet","Theater TOL","B",33]
[11041038,null,"26-04-2021","27-04-2021","2020-12-28",119,"53-2020","Piet","Koningsdag en -nacht","B",33]
[11042063,null,"26-04-2021","26-04-2021","2020-12-28",119,"53-2020","Kees","Kingsnight","B",33]
[11040996,null,"27-04-2021","27-04-2021","2020-12-29",119,"53-2020","Kees","Koningsdag de Markies","B",33]
[11041143,null,"27-04-2021","27-04-2021","2021-01-05",112,"2-2021","Kees","Koningsdagconcert","A",20]
[11041461,null,"27-04-2021","27-04-2021","2020-12-29",119,"53-2020","Kees","Koningsdag Mukkes","B",33]
[11042055,null,"27-04-2021","27-04-2021","2020-12-29",119,"53-2020","Kees","Koningsdag commerciele markt","B",33]
[11042061,null,"27-04-2021","27-04-2021","2020-12-29",119,"53-2020","Kees","Kingsday Outdoor","B",33]
[11040717,null,"01-05-2021","01-05-2021","2021-01-02",119,"1-2021","Kees","Wapendropping wandel-beleeftocht","B",33]
[11042090,null,"04-05-2021","04-05-2021","2021-01-12",112,"3-2021","Klaas","Herdenking 4 mei","A",20]
[11042100,null,"04-05-2021","04-05-2021","2021-01-12",112,"3-2021","Klaas","4 mei herdenking","A",20]
[11042030,null,"05-05-2021","05-05-2021","2020-12-30",126,{"$f":"WEEKNUM(E21)&\"-\"&YEAR(E21)","v":"53-2020"},"Klaas","Bevrijdingsfestival Fryslân","C",44]
[11042093,null,"07-05-2021","09-05-2021","2021-01-15",112,"3-2021","Klaas","Opening Watersportseizoen","A",20]
[11042062,null,"08-05-2021","08-05-2021","2021-01-16",112,"3-2021","Klaas","Schransspektakel","A",20]
[11041465,null,"11-05-2021","15-05-2021","2021-01-19",112,"4-2021","Klaas","11-Stedenwandeltocht","A",20]
[11041160,null,"13-05-2021","13-05-2021","2021-01-21",112,"4-2021","Jan","Hemelvaartconcert","A",20]
[11041340,null,"13-05-2021","15-05-2021","2021-01-14",119,"3-2021","Jan","Hemels & 90's XXL","B",33]
[11041379,null,"13-05-2021","15-05-2021","2021-01-21",112,"4-2021","Jan","Dorpsfeest Hijum/Finkum","A",20]
[11041470,null,"13-05-2021","13-05-2021","2021-04-15",28,"16-2021","Jan","Openluchtdienst Hemelvaartsdag","K",10]
[11042058,null,"13-05-2021","13-05-2021","2021-01-14",119,"3-2021","Jan","Bloemenmarkt","B",33]

{"sheet":"beschikbaar en uren per cat.","index":1,"n_rows":29,"n_cols":67,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,15,0,66],[8,15,8,66]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beschikbaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-2021","2-2021","3-2021","4-2021","5-2021","6-2021","7-2021","8-2021","9-2021","10-2021","11-2021","12-2021","13-2021","14-2021","15-2021","16-2021","17-2021","18-2021","19-2021","20-2021","21-2021","22-2021","23-2021","24-2021","25-2021","26-2021","27-2021","28-2021","29-2021","30-2021","31-2021","32-2021","33-2021","34-2021","35-2021","36-2021","37-2021","38-2021","39-2021","40-2021","41-2021","42-2021","43-2021","44-2021","45-2021","46-2021","47-2021","48-2021","49-2021","50-2021","51-2021","52-2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piet",16,{"$f":"P3","v":16},{"$f":"Q3","v":16},16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kees",36,{"$f":"P4","v":36},36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Klaas ",24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jan",16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16,16]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-2021","2-2021","3-2021","4-2021","5-2021","6-2021","7-2021","8-2021","9-2021","10-2021","11-2021","12-2021","13-2021","14-2021","15-2021","16-2021","17-2021","18-2021","19-2021","20-2021","21-2021","22-2021","23-2021","24-2021","25-2021","26-2021","27-2021","28-2021","29-2021","30-2021","31-2021","32-2021","33-2021","34-2021","35-2021","36-2021","37-2021","38-2021","39-2021","40-2021","41-2021","42-2021","43-2021","44-2021","45-2021","46-2021","47-2021","48-2021","49-2021","50-2021","51-2021","52-2021"]
["K",{"$f":"SUM(B19:M19)","v":10},null,null,null,null,null,null,null,null,null,null,null,null,"Piet"]
["A",{"$f":"SUM(B20:M20)","v":20},null,null,null,null,null,null,null,null,null,null,null,null,"Kees"]
["B",33,null,null,null,null,null,null,null,null,null,null,null,null,"Klaas "]
["C",44,null,null,null,null,null,null,null,null,null,null,null,null,"Jan"]
[]
[]
[]
[null,-2,-1,1,2,3,4,5,6,7,8,9,10]
["K",null,null,1,1,1,1,1,1,1,1,1,1]
["A",null,null,2,2,2,2,2,2,2,2,2,2]
["B",null,3,3,3,3,3,3,3,3,3,3,3]
["C",2,2,4,4,4,4,4,4,4,4,4,4]
[]
[]
[]
["K",3,1,1,1,1,1,1,1,1,1,1,0]
["A",2,2,2,2,2,2,2,2,2,2,0,0]
["B",3,3,3,3,3,3,3,3,3,3,3,0]
["C",2,2,4,4,4,4,4,4,4,4,4,4]