{"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":128,"n_cols":200,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"2020-08-24",{"$f":"L1+7","v":"2020-08-31"},{"$f":"M1+7","v":"2020-09-07"},"2020-09-14","2020-09-21","2020-09-28","2020-10-05","2020-10-12","2020-10-19","2020-10-26","2020-11-02","2020-11-09","2020-11-16","2020-11-23","2020-11-30","2020-12-07","2020-12-14","2020-12-21","2020-12-28","2021-01-04","2021-01-11","2021-01-18","2021-01-25","2021-02-01","2021-02-08","2021-02-15","2021-02-22","2021-03-01","2021-03-08","2021-03-15","2021-03-22","2021-03-29","2021-04-05","2021-04-12","2021-04-19","2021-04-26","2021-05-03","2021-05-10","2021-05-17","2021-05-24","2021-05-31","2021-06-07","2021-06-14","2021-06-21","2021-06-28","2021-07-05","2021-07-12","2021-07-19","2021-07-26","2021-08-02","2021-08-09","2021-08-16","2021-08-23","2021-08-30","2021-09-06","2021-09-13","2021-09-20","2021-09-27","2021-10-04","2021-10-11","2021-10-18","2021-10-25","2021-11-01","2021-11-08","2021-11-15","2021-11-22",{"$f":"BY1+7","v":"2021-11-29"},"2021-12-06",{"$f":"CA1+7","v":"2021-12-13"},"2021-12-20","2021-12-27","2022-01-03","2022-01-10","2022-01-17","2022-01-24","2022-01-31","2022-02-07","2022-02-14","2022-02-21","2022-02-28","2022-03-07","2022-03-14","2022-03-21","2022-03-28","2022-04-04","2022-04-11","2022-04-18","2022-04-25","2022-05-02","2022-05-09","2022-05-16","2022-05-23","2022-05-30","2022-06-06","2022-06-13","2022-06-20","2022-06-27","2022-07-04","2022-07-11","2022-07-18","2022-07-25","2022-08-01","2022-08-08","2022-08-15","2022-08-22","2022-08-29","2022-09-05","2022-09-12","2022-09-19","2022-09-26","2022-10-03","2022-10-10","2022-10-17","2022-10-24","2022-10-31","2022-11-07","2022-11-14","2022-11-21","2022-11-28","2022-12-05","2022-12-12","2022-12-19","2022-12-26","2023-01-02","2023-01-09","2023-01-16","2023-01-23","2023-01-30","2023-02-06","2023-02-13","2023-02-20","2023-02-27",{"$f":"EM1+7","v":"2023-03-06"},"2023-03-13","2023-03-20","2023-03-27","2023-04-03","2023-04-10","2023-04-17","2023-04-24","2023-05-01","2023-05-08","2023-05-15","2023-05-22","2023-05-29","2023-06-05","2023-06-12","2023-06-19","2023-06-26","2023-07-03","2023-07-10","2023-07-17","2023-07-24","2023-07-31","2023-08-07","2023-08-14","2023-08-21","2023-08-28","2023-09-04","2023-09-11","2023-09-18","2023-09-25","2023-10-02","2023-10-09","2023-10-16","2023-10-23","2023-10-30","2023-11-06","2023-11-13","2023-11-20","2023-11-27","2023-12-04","2023-12-11","2023-12-18",{"$f":"GC1+7","v":"2023-12-25"},"2024-01-01","2024-01-08","2024-01-15"]
[]
["Dossiernr.","Datum ingediend","Start eve.","Einde eve.","tussenstap 1","1 ste workload","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","1-2024","2-2024","3-2024"]
[11040187,null,"2021-01-01","2021-03-06",{"$f":"IF(AND(D4<>\"\",I4<>\"\"),C4-IF(I4=\"C\",18*7,IF(I4=\"B\",17*7,IF(I4=\"K\",4*7,IF(I4=\"A\",16*7)))),\"\")","v":"2020-08-28"},{"$f":"IF(D4<>\"\",WEEKNUM(E4)&\"-\"&YEAR(E4),\"\")","v":"35-2020"},"Piet","LUNA","c",{"$f":"IF(I4=0,\"\",VLOOKUP(I4,uren,2,FALSE))","v":44},null,2,2,4,4,4,4,4,4,4,4,4,4]
[11042054,null,"2021-01-01","01-01-2021","2020-09-04","36-2020","Piet","Nieuwjaarsduik Noordersingel","b",{"$f":"IF(I5=0,\"\",VLOOKUP(I5,uren,2,FALSE))","v":33},null,null,3,3,3,3,3,3,3,3,3,3,3,0]
[11042617,null,"2021-01-01","2021-03-13","2020-09-11","37-2020","Piet","Media Art Festival","a",{"$f":"IF(I6=0,\"\",VLOOKUP(I6,uren,2,FALSE))","v":20},null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11042024,null,"2021-01-01","2021-02-21","2020-12-04","49-2020","Piet","Sint Piter","k",{"$f":"IF(I7=0,\"\",VLOOKUP(I7,uren,2,FALSE))","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,1,1,1,1,1,1,1,1,1,0]
[11042087,null,"15-04-2021","15-04-2021","2020-12-17","51-2020","Piet","Herdenking Bevrijding Leeuwarden en Fryslan (2021)","B",{"$f":"IF(I8=0,\"\",VLOOKUP(I8,uren,2,FALSE))","v":33},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,3,0]
[11042092,null,"15-04-2021","17-04-2021","2020-12-17","51-2020","Piet","Theater TOL","B",{"$f":"IF(I9=0,\"\",VLOOKUP(I9,uren,2,FALSE))","v":33},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,3,0]
[11041038,null,"26-04-2021","27-04-2021","2020-12-28","53-2020","Piet","Koningsdag en -nacht","B",{"$f":"IF(I10=0,\"\",VLOOKUP(I10,uren,2,FALSE))","v":33},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,3,0]
[11042063,null,"26-04-2021","26-04-2021","2020-12-28","53-2020","Kees","Kingsnight","B",{"$f":"IF(I11=0,\"\",VLOOKUP(I11,uren,2,FALSE))","v":33},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,3,0]
[11040996,null,"27-04-2021","27-04-2021","2020-12-29","53-2020","Kees","Koningsdag de Markies","B",{"$f":"IF(I12=0,\"\",VLOOKUP(I12,uren,2,FALSE))","v":33},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,3,0]
[11041461,null,"27-04-2021","27-04-2021","2020-12-29","53-2020","Kees","Koningsdag Mukkes","B",{"$f":"IF(I13=0,\"\",VLOOKUP(I13,uren,2,FALSE))","v":33},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,3,0]
[11042055,null,"27-04-2021","27-04-2021","2020-12-29","53-2020","Kees","Koningsdag commerciele markt","B",{"$f":"IF(I14=0,\"\",VLOOKUP(I14,uren,2,FALSE))","v":33},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,3,0]
[11042061,null,"27-04-2021","27-04-2021","2020-12-29","53-2020","Kees","Kingsday Outdoor","B",{"$f":"IF(I15=0,\"\",VLOOKUP(I15,uren,2,FALSE))","v":33},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,3,0]
[11042030,null,"05-05-2021","05-05-2021","2020-12-30","53-2020","Klaas","Bevrijdingsfestival Fryslân","C",{"$f":"IF(I16=0,\"\",VLOOKUP(I16,uren,2,FALSE))","v":44},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,4,4,4,4,4,4,4,4,4,4]
[11040717,null,"01-05-2021","01-05-2021","2021-01-02","1-2021","Kees","Wapendropping wandel-beleeftocht","B",{"$f":"IF(I17=0,\"\",VLOOKUP(I17,uren,2,FALSE))","v":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,3,3,3,3,3,3,3,3,3,3,3,0]
[11041143,null,"27-04-2021","27-04-2021","2021-01-05","2-2021","Kees","Koningsdagconcert","A",{"$f":"IF(I18=0,\"\",VLOOKUP(I18,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11042090,null,"04-05-2021","04-05-2021","2021-01-12","3-2021","Klaas","Herdenking 4 mei","A",{"$f":"IF(I19=0,\"\",VLOOKUP(I19,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11042100,null,"04-05-2021","04-05-2021","2021-01-12","3-2021","Klaas","4 mei herdenking","A",{"$f":"IF(I20=0,\"\",VLOOKUP(I20,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11041340,null,"13-05-2021","15-05-2021","2021-01-14","3-2021","Jan","Hemels & 90's XXL","B",{"$f":"IF(I21=0,\"\",VLOOKUP(I21,uren,2,FALSE))","v":33},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,3,0]
[11042058,null,"13-05-2021","13-05-2021","2021-01-14","3-2021","Jan","Bloemenmarkt","B",{"$f":"IF(I22=0,\"\",VLOOKUP(I22,uren,2,FALSE))","v":33},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,3,0]
[11042093,null,"07-05-2021","09-05-2021","2021-01-15","3-2021","Klaas","Opening Watersportseizoen","A",{"$f":"IF(I23=0,\"\",VLOOKUP(I23,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11042062,null,"08-05-2021","08-05-2021","2021-01-16","3-2021","Klaas","Schransspektakel","A",{"$f":"IF(I24=0,\"\",VLOOKUP(I24,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11041465,null,"11-05-2021","15-05-2021","2021-01-19","4-2021","Klaas","11-Stedenwandeltocht","A",{"$f":"IF(I25=0,\"\",VLOOKUP(I25,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11041160,null,"13-05-2021","13-05-2021","2021-01-21","4-2021","Jan","Hemelvaartconcert","A",{"$f":"IF(I26=0,\"\",VLOOKUP(I26,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11041379,null,"13-05-2021","15-05-2021","2021-01-21","4-2021","Jan","Dorpsfeest Hijum/Finkum","A",{"$f":"IF(I27=0,\"\",VLOOKUP(I27,uren,2,FALSE))","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2,0,0]
[11041470,null,"13-05-2021","13-05-2021","2021-04-15","16-2021","Jan","Openluchtdienst Hemelvaartsdag","K",{"$f":"IF(I28=0,\"\",VLOOKUP(I28,uren,2,FALSE))","v":10},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,1,1,1,1,1,1,1,1,1,1,0]
[11042849,null,"13-02-2024","18-04-2021","2023-10-10","41-2023","Piet","Lunato kermis","c",{"$f":"IF(I29=0,\"\",VLOOKUP(I29,uren,2,FALSE))","v":44},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,2,2,4,4,4,4,4,4,4,4,4,4]
[11042849,null,"13-02-2024","2024-02-24","2023-10-24",{"$f":"IF(D30<>\"\",WEEKNUM(E30)&\"-\"&YEAR(E30),\"\")","v":"43-2023"},"Piet","Lunato kermis","a",{"$f":"IF(I30=0,\"\",VLOOKUP(I30,uren,2,FALSE))","v":20},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,null,2,2,2,2,2,2,2,2,2,2,0,0,null,1,1,1,1,1,1,1,1,1,1,0]
[null,null,null,null,"",{"$f":"IF(D31<>\"\",WEEKNUM(E31)&\"-\"&YEAR(E31),\"\")","v":""},null,null,null,{"$f":"IF(I31=0,\"\",VLOOKUP(I31,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I32=0,\"\",VLOOKUP(I32,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I33=0,\"\",VLOOKUP(I33,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I34=0,\"\",VLOOKUP(I34,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I35=0,\"\",VLOOKUP(I35,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I36=0,\"\",VLOOKUP(I36,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I37=0,\"\",VLOOKUP(I37,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I38=0,\"\",VLOOKUP(I38,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I39=0,\"\",VLOOKUP(I39,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I40=0,\"\",VLOOKUP(I40,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I41=0,\"\",VLOOKUP(I41,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I42=0,\"\",VLOOKUP(I42,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I43=0,\"\",VLOOKUP(I43,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I44=0,\"\",VLOOKUP(I44,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I45=0,\"\",VLOOKUP(I45,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I46=0,\"\",VLOOKUP(I46,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I47=0,\"\",VLOOKUP(I47,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I48=0,\"\",VLOOKUP(I48,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I49=0,\"\",VLOOKUP(I49,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I50=0,\"\",VLOOKUP(I50,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I51=0,\"\",VLOOKUP(I51,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I52=0,\"\",VLOOKUP(I52,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I53=0,\"\",VLOOKUP(I53,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I54=0,\"\",VLOOKUP(I54,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I55=0,\"\",VLOOKUP(I55,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I56=0,\"\",VLOOKUP(I56,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I57=0,\"\",VLOOKUP(I57,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I58=0,\"\",VLOOKUP(I58,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I59=0,\"\",VLOOKUP(I59,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I60=0,\"\",VLOOKUP(I60,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I61=0,\"\",VLOOKUP(I61,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I62=0,\"\",VLOOKUP(I62,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I63=0,\"\",VLOOKUP(I63,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I64=0,\"\",VLOOKUP(I64,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I65=0,\"\",VLOOKUP(I65,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I66=0,\"\",VLOOKUP(I66,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I67=0,\"\",VLOOKUP(I67,uren,2,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(AND(D68<>\"\",I68<>\"\"),C68-IF(I68=\"C\",18*7,IF(I68=\"B\",17*7,IF(I68=\"K\",4*7,IF(I68=\"A\",16*7)))),\"\")","v":""},"",null,null,null,{"$f":"IF(I68=0,\"\",VLOOKUP(I68,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I69=0,\"\",VLOOKUP(I69,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I70=0,\"\",VLOOKUP(I70,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I71=0,\"\",VLOOKUP(I71,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I72=0,\"\",VLOOKUP(I72,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I73=0,\"\",VLOOKUP(I73,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I74=0,\"\",VLOOKUP(I74,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I75=0,\"\",VLOOKUP(I75,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I76=0,\"\",VLOOKUP(I76,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I77=0,\"\",VLOOKUP(I77,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I78=0,\"\",VLOOKUP(I78,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I79=0,\"\",VLOOKUP(I79,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I80=0,\"\",VLOOKUP(I80,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I81=0,\"\",VLOOKUP(I81,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I82=0,\"\",VLOOKUP(I82,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I83=0,\"\",VLOOKUP(I83,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I84=0,\"\",VLOOKUP(I84,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I85=0,\"\",VLOOKUP(I85,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I86=0,\"\",VLOOKUP(I86,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I87=0,\"\",VLOOKUP(I87,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I88=0,\"\",VLOOKUP(I88,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I89=0,\"\",VLOOKUP(I89,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I90=0,\"\",VLOOKUP(I90,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I91=0,\"\",VLOOKUP(I91,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I92=0,\"\",VLOOKUP(I92,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I93=0,\"\",VLOOKUP(I93,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I94=0,\"\",VLOOKUP(I94,uren,2,FALSE))","v":""}]
[null,null,null,null,"",{"$f":"IF(D95<>\"\",WEEKNUM(E95)&\"-\"&YEAR(E95),\"\")","v":""},null,null,null,{"$f":"IF(I95=0,\"\",VLOOKUP(I95,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I96=0,\"\",VLOOKUP(I96,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I97=0,\"\",VLOOKUP(I97,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I98=0,\"\",VLOOKUP(I98,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I99=0,\"\",VLOOKUP(I99,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I100=0,\"\",VLOOKUP(I100,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I101=0,\"\",VLOOKUP(I101,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I102=0,\"\",VLOOKUP(I102,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I103=0,\"\",VLOOKUP(I103,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I104=0,\"\",VLOOKUP(I104,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I105=0,\"\",VLOOKUP(I105,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I106=0,\"\",VLOOKUP(I106,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I107=0,\"\",VLOOKUP(I107,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I108=0,\"\",VLOOKUP(I108,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I109=0,\"\",VLOOKUP(I109,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I110=0,\"\",VLOOKUP(I110,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I111=0,\"\",VLOOKUP(I111,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I112=0,\"\",VLOOKUP(I112,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I113=0,\"\",VLOOKUP(I113,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I114=0,\"\",VLOOKUP(I114,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I115=0,\"\",VLOOKUP(I115,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I116=0,\"\",VLOOKUP(I116,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I117=0,\"\",VLOOKUP(I117,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I118=0,\"\",VLOOKUP(I118,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I119=0,\"\",VLOOKUP(I119,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I120=0,\"\",VLOOKUP(I120,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I121=0,\"\",VLOOKUP(I121,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I122=0,\"\",VLOOKUP(I122,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I123=0,\"\",VLOOKUP(I123,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I124=0,\"\",VLOOKUP(I124,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I125=0,\"\",VLOOKUP(I125,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I126=0,\"\",VLOOKUP(I126,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I127=0,\"\",VLOOKUP(I127,uren,2,FALSE))","v":""}]
[null,null,null,null,"","",null,null,null,{"$f":"IF(I128=0,\"\",VLOOKUP(I128,uren,2,FALSE))","v":""}]

{"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]