{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Januari","Februari","Maart","April","Mei","Juni","Juli","Augustus","September","Oktober","November","December","Werknemersnamen"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"Januari","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,"Afwezigheidsplanning Werknemers "]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[{"$nulls":33},"Voer het jaar in:"]
[null,"Januari","Afwezigheidsdatums",{"$nulls":30},2019]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,1),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,2),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,3),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,4),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,5),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,6),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,7),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,8),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,9),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,10),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,11),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,12),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,13),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,14),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,15),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,16),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,17),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,18),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,19),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,20),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,21),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,22),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,23),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,24),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,25),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,26),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,27),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,28),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,29),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,30),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,1,31),1),\"aaa\")","v":"do"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",null,null,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},{"$f":"COUNTA(Januari!$C7:$AG7)","v":5}]
[null,"Werknemer 2",{"$nulls":4},"Z","Z",{"$nulls":4},"P",{"$nulls":8},"Z",{"$nulls":4},"V","V","V",{"$nulls":4},{"$f":"COUNTA(Januari!$C8:$AG8)","v":7}]
[null,"Werknemer 3",null,null,"P",{"$nulls":10},"Z",{"$nulls":14},"Z",null,null,{"$f":"COUNTA(Januari!$C9:$AG9)","v":3}]
[null,"Werknemer 4",{"$nulls":6},"P",{"$nulls":11},"V","V","V",{"$nulls":10},{"$f":"COUNTA(Januari!$C10:$AG10)","v":4}]
[null,"Werknemer 5",{"$nulls":3},"Z","V","V",{"$nulls":10},"Z",{"$nulls":6},"Z",{"$nulls":6},"V",{"$f":"COUNTA(Januari!$C11:$AG11)","v":6}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Januari Totaal"},{"$f":"SUBTOTAL(103,Januari!$C$7:$C$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$D$7:$D$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$E$7:$E$11)","v":2},{"$f":"SUBTOTAL(103,Januari!$F$7:$F$11)","v":2},{"$f":"SUBTOTAL(103,Januari!$G$7:$G$11)","v":3},{"$f":"SUBTOTAL(103,Januari!$H$7:$H$11)","v":3},{"$f":"SUBTOTAL(103,Januari!$I$7:$I$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$J$7:$J$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$K$7:$K$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$L$7:$L$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$M$7:$M$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$N$7:$N$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$O$7:$O$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$P$7:$P$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$Q$7:$Q$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$R$7:$R$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$S$7:$S$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$T$7:$T$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$U$7:$U$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$V$7:$V$11)","v":2},{"$f":"SUBTOTAL(103,Januari!$W$7:$W$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$X$7:$X$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$Y$7:$Y$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$Z$7:$Z$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AA$7:$AA$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AB$7:$AB$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AC$7:$AC$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AD$7:$AD$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$AE$7:$AE$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AF$7:$AF$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$AG$7:$AG$11)","v":1},{"$f":"SUBTOTAL(109,Januari[Totaal aantal dagen])","v":25}]

{"sheet":"Februari","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Februari","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,1),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,2),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,3),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,4),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,5),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,6),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,7),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,8),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,9),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,10),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,11),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,12),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,13),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,14),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,15),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,16),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,17),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,18),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,19),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,20),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,21),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,22),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,23),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,24),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,25),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,26),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,27),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,28),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,2,29),1),\"aaa\")","v":"vr"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29"," ","  ","Totaal aantal dagen"]
[null,"Werknemer 1",null,null,"V","V","V","V",{"$nulls":6},"V",{"$nulls":18},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":5}]
[null,"Werknemer 2",{"$nulls":4},"Z","Z",{"$nulls":4},"P",{"$nulls":8},"Z",{"$nulls":4},"V","V","V",{"$nulls":4},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":7}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":0}]
[null,"Werknemer 4",null,null,"Z",{"$nulls":10},"Z",{"$nulls":3},"P",{"$nulls":9},"Z",{"$nulls":3},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":4}]
[null,"Werknemer 5",{"$nulls":7},"V","V","V","V",{"$nulls":12},"Z",{"$nulls":7},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Februari Totaal"},{"$f":"SUBTOTAL(103,Februari[1])","v":0},{"$f":"SUBTOTAL(103,Februari[2])","v":0},{"$f":"SUBTOTAL(103,Februari[3])","v":2},{"$f":"SUBTOTAL(103,Februari[4])","v":1},{"$f":"SUBTOTAL(103,Februari[5])","v":2},{"$f":"SUBTOTAL(103,Februari[6])","v":2},{"$f":"SUBTOTAL(103,Februari[7])","v":0},{"$f":"SUBTOTAL(103,Februari[8])","v":1},{"$f":"SUBTOTAL(103,Februari[9])","v":1},{"$f":"SUBTOTAL(103,Februari[10])","v":1},{"$f":"SUBTOTAL(103,Februari[11])","v":2},{"$f":"SUBTOTAL(103,Februari[12])","v":0},{"$f":"SUBTOTAL(103,Februari[13])","v":1},{"$f":"SUBTOTAL(103,Februari[14])","v":1},{"$f":"SUBTOTAL(103,Februari[15])","v":0},{"$f":"SUBTOTAL(103,Februari[16])","v":0},{"$f":"SUBTOTAL(103,Februari[17])","v":0},{"$f":"SUBTOTAL(103,Februari[18])","v":1},{"$f":"SUBTOTAL(103,Februari[19])","v":0},{"$f":"SUBTOTAL(103,Februari[20])","v":1},{"$f":"SUBTOTAL(103,Februari[21])","v":0},{"$f":"SUBTOTAL(103,Februari[22])","v":0},{"$f":"SUBTOTAL(103,Februari[23])","v":0},{"$f":"SUBTOTAL(103,Februari[24])","v":1},{"$f":"SUBTOTAL(103,Februari[25])","v":1},{"$f":"SUBTOTAL(103,Februari[26])","v":1},{"$f":"SUBTOTAL(103,Februari[27])","v":1},{"$f":"SUBTOTAL(103,Februari[28])","v":1},{"$f":"SUBTOTAL(103,Februari[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Februari[Totaal aantal dagen])","v":21}]

{"sheet":"Maart","index":2,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Maart","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,1),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,2),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,3),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,4),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,5),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,6),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,7),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,8),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,9),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,10),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,11),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,12),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,13),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,14),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,15),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,16),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,17),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,18),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,19),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,20),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,21),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,22),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,23),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,24),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,25),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,26),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,27),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,28),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,29),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,30),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,3,31),1),\"aaa\")","v":"zo"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(Maart[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(Maart[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Maart[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(Maart[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(Maart[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Maart Totaal"},{"$f":"SUBTOTAL(103,Maart[1])","v":0},{"$f":"SUBTOTAL(103,Maart[2])","v":0},{"$f":"SUBTOTAL(103,Maart[3])","v":0},{"$f":"SUBTOTAL(103,Maart[4])","v":0},{"$f":"SUBTOTAL(103,Maart[5])","v":0},{"$f":"SUBTOTAL(103,Maart[6])","v":0},{"$f":"SUBTOTAL(103,Maart[7])","v":0},{"$f":"SUBTOTAL(103,Maart[8])","v":0},{"$f":"SUBTOTAL(103,Maart[9])","v":0},{"$f":"SUBTOTAL(103,Maart[10])","v":0},{"$f":"SUBTOTAL(103,Maart[11])","v":0},{"$f":"SUBTOTAL(103,Maart[12])","v":0},{"$f":"SUBTOTAL(103,Maart[13])","v":0},{"$f":"SUBTOTAL(103,Maart[14])","v":0},{"$f":"SUBTOTAL(103,Maart[15])","v":0},{"$f":"SUBTOTAL(103,Maart[16])","v":0},{"$f":"SUBTOTAL(103,Maart[17])","v":0},{"$f":"SUBTOTAL(103,Maart[18])","v":0},{"$f":"SUBTOTAL(103,Maart[19])","v":0},{"$f":"SUBTOTAL(103,Maart[20])","v":0},{"$f":"SUBTOTAL(103,Maart[21])","v":0},{"$f":"SUBTOTAL(103,Maart[22])","v":0},{"$f":"SUBTOTAL(103,Maart[23])","v":0},{"$f":"SUBTOTAL(103,Maart[24])","v":0},{"$f":"SUBTOTAL(103,Maart[25])","v":0},{"$f":"SUBTOTAL(103,Maart[26])","v":0},{"$f":"SUBTOTAL(103,Maart[27])","v":0},{"$f":"SUBTOTAL(103,Maart[28])","v":0},{"$f":"SUBTOTAL(103,Maart[29])","v":0},{"$f":"SUBTOTAL(103,Maart[30])","v":0},{"$f":"SUBTOTAL(103,Maart[31])","v":0},{"$f":"SUBTOTAL(109,Maart[Totaal aantal dagen])","v":0}]

{"sheet":"April","index":3,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"April","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,1),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,2),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,3),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,4),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,5),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,6),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,7),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,8),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,9),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,10),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,11),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,12),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,13),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,14),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,15),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,16),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,17),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,18),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,19),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,20),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,21),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,22),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,23),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,24),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,25),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,26),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,27),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,28),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,29),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,4,30),1),\"aaa\")","v":"di"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"April Totaal"},{"$f":"SUBTOTAL(103,April[1])","v":0},{"$f":"SUBTOTAL(103,April[2])","v":0},{"$f":"SUBTOTAL(103,April[3])","v":0},{"$f":"SUBTOTAL(103,April[4])","v":0},{"$f":"SUBTOTAL(103,April[5])","v":0},{"$f":"SUBTOTAL(103,April[6])","v":0},{"$f":"SUBTOTAL(103,April[7])","v":0},{"$f":"SUBTOTAL(103,April[8])","v":0},{"$f":"SUBTOTAL(103,April[9])","v":0},{"$f":"SUBTOTAL(103,April[10])","v":0},{"$f":"SUBTOTAL(103,April[11])","v":0},{"$f":"SUBTOTAL(103,April[12])","v":0},{"$f":"SUBTOTAL(103,April[13])","v":0},{"$f":"SUBTOTAL(103,April[14])","v":0},{"$f":"SUBTOTAL(103,April[15])","v":0},{"$f":"SUBTOTAL(103,April[16])","v":0},{"$f":"SUBTOTAL(103,April[17])","v":0},{"$f":"SUBTOTAL(103,April[18])","v":0},{"$f":"SUBTOTAL(103,April[19])","v":0},{"$f":"SUBTOTAL(103,April[20])","v":0},{"$f":"SUBTOTAL(103,April[21])","v":0},{"$f":"SUBTOTAL(103,April[22])","v":0},{"$f":"SUBTOTAL(103,April[23])","v":0},{"$f":"SUBTOTAL(103,April[24])","v":0},{"$f":"SUBTOTAL(103,April[25])","v":0},{"$f":"SUBTOTAL(103,April[26])","v":0},{"$f":"SUBTOTAL(103,April[27])","v":0},{"$f":"SUBTOTAL(103,April[28])","v":0},{"$f":"SUBTOTAL(103,April[29])","v":0},{"$f":"SUBTOTAL(103,April[30])","v":0},{"$f":"SUBTOTAL(103,April[30])","v":0},{"$f":"SUBTOTAL(109,April[Totaal aantal dagen])","v":0}]

{"sheet":"Mei","index":4,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Mei","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,1),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,2),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,3),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,4),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,5),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,6),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,7),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,8),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,9),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,10),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,11),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,12),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,13),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,14),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,15),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,16),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,17),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,18),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,19),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,20),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,21),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,22),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,23),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,24),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,25),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,26),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,27),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,28),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,29),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,30),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,5,31),1),\"aaa\")","v":"vr"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Mei Totaal"},{"$f":"SUBTOTAL(103,Mei[1])","v":0},{"$f":"SUBTOTAL(103,Mei[2])","v":0},{"$f":"SUBTOTAL(103,Mei[3])","v":0},{"$f":"SUBTOTAL(103,Mei[4])","v":0},{"$f":"SUBTOTAL(103,Mei[5])","v":0},{"$f":"SUBTOTAL(103,Mei[6])","v":0},{"$f":"SUBTOTAL(103,Mei[7])","v":0},{"$f":"SUBTOTAL(103,Mei[8])","v":0},{"$f":"SUBTOTAL(103,Mei[9])","v":0},{"$f":"SUBTOTAL(103,Mei[10])","v":0},{"$f":"SUBTOTAL(103,Mei[11])","v":0},{"$f":"SUBTOTAL(103,Mei[12])","v":0},{"$f":"SUBTOTAL(103,Mei[13])","v":0},{"$f":"SUBTOTAL(103,Mei[14])","v":0},{"$f":"SUBTOTAL(103,Mei[15])","v":0},{"$f":"SUBTOTAL(103,Mei[16])","v":0},{"$f":"SUBTOTAL(103,Mei[17])","v":0},{"$f":"SUBTOTAL(103,Mei[18])","v":0},{"$f":"SUBTOTAL(103,Mei[19])","v":0},{"$f":"SUBTOTAL(103,Mei[20])","v":0},{"$f":"SUBTOTAL(103,Mei[21])","v":0},{"$f":"SUBTOTAL(103,Mei[22])","v":0},{"$f":"SUBTOTAL(103,Mei[23])","v":0},{"$f":"SUBTOTAL(103,Mei[24])","v":0},{"$f":"SUBTOTAL(103,Mei[25])","v":0},{"$f":"SUBTOTAL(103,Mei[26])","v":0},{"$f":"SUBTOTAL(103,Mei[27])","v":0},{"$f":"SUBTOTAL(103,Mei[28])","v":0},{"$f":"SUBTOTAL(103,Mei[29])","v":0},{"$f":"SUBTOTAL(103,Mei[30])","v":0},{"$f":"SUBTOTAL(103,Mei[31])","v":0},{"$f":"SUBTOTAL(109,Mei[Totaal aantal dagen])","v":0}]

{"sheet":"Juni","index":5,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Juni","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,1),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,2),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,3),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,4),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,5),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,6),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,7),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,8),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,9),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,10),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,11),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,12),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,13),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,14),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,15),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,16),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,17),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,18),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,19),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,20),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,21),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,22),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,23),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,24),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,25),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,26),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,27),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,28),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,29),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,6,30),1),\"aaa\")","v":"zo"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Juni Totaal"},{"$f":"SUBTOTAL(103,Juni[1])","v":0},{"$f":"SUBTOTAL(103,Juni[2])","v":0},{"$f":"SUBTOTAL(103,Juni[3])","v":0},{"$f":"SUBTOTAL(103,Juni[4])","v":0},{"$f":"SUBTOTAL(103,Juni[5])","v":0},{"$f":"SUBTOTAL(103,Juni[6])","v":0},{"$f":"SUBTOTAL(103,Juni[7])","v":0},{"$f":"SUBTOTAL(103,Juni[8])","v":0},{"$f":"SUBTOTAL(103,Juni[9])","v":0},{"$f":"SUBTOTAL(103,Juni[10])","v":0},{"$f":"SUBTOTAL(103,Juni[11])","v":0},{"$f":"SUBTOTAL(103,Juni[12])","v":0},{"$f":"SUBTOTAL(103,Juni[13])","v":0},{"$f":"SUBTOTAL(103,Juni[14])","v":0},{"$f":"SUBTOTAL(103,Juni[15])","v":0},{"$f":"SUBTOTAL(103,Juni[16])","v":0},{"$f":"SUBTOTAL(103,Juni[17])","v":0},{"$f":"SUBTOTAL(103,Juni[18])","v":0},{"$f":"SUBTOTAL(103,Juni[19])","v":0},{"$f":"SUBTOTAL(103,Juni[20])","v":0},{"$f":"SUBTOTAL(103,Juni[21])","v":0},{"$f":"SUBTOTAL(103,Juni[22])","v":0},{"$f":"SUBTOTAL(103,Juni[23])","v":0},{"$f":"SUBTOTAL(103,Juni[24])","v":0},{"$f":"SUBTOTAL(103,Juni[25])","v":0},{"$f":"SUBTOTAL(103,Juni[26])","v":0},{"$f":"SUBTOTAL(103,Juni[27])","v":0},{"$f":"SUBTOTAL(103,Juni[28])","v":0},{"$f":"SUBTOTAL(103,Juni[29])","v":0},{"$f":"SUBTOTAL(103,Juni[30])","v":0},{"$f":"SUBTOTAL(103,Juni[[ ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Totaal aantal dagen])","v":0}]

{"sheet":"Juli","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Juli","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,1),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,2),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,3),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,4),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,5),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,6),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,7),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,8),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,9),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,10),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,11),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,12),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,13),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,14),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,15),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,16),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,17),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,18),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,19),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,20),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,21),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,22),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,23),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,24),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,25),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,26),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,27),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,28),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,29),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,30),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,7,31),1),\"aaa\")","v":"wo"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Juli Totaal"},{"$f":"SUBTOTAL(103,Juli[1])","v":0},{"$f":"SUBTOTAL(103,Juli[2])","v":0},{"$f":"SUBTOTAL(103,Juli[3])","v":0},{"$f":"SUBTOTAL(103,Juli[4])","v":0},{"$f":"SUBTOTAL(103,Juli[5])","v":0},{"$f":"SUBTOTAL(103,Juli[6])","v":0},{"$f":"SUBTOTAL(103,Juli[7])","v":0},{"$f":"SUBTOTAL(103,Juli[8])","v":0},{"$f":"SUBTOTAL(103,Juli[9])","v":0},{"$f":"SUBTOTAL(103,Juli[10])","v":0},{"$f":"SUBTOTAL(103,Juli[11])","v":0},{"$f":"SUBTOTAL(103,Juli[12])","v":0},{"$f":"SUBTOTAL(103,Juli[13])","v":0},{"$f":"SUBTOTAL(103,Juli[14])","v":0},{"$f":"SUBTOTAL(103,Juli[15])","v":0},{"$f":"SUBTOTAL(103,Juli[16])","v":0},{"$f":"SUBTOTAL(103,Juli[17])","v":0},{"$f":"SUBTOTAL(103,Juli[18])","v":0},{"$f":"SUBTOTAL(103,Juli[19])","v":0},{"$f":"SUBTOTAL(103,Juli[20])","v":0},{"$f":"SUBTOTAL(103,Juli[21])","v":0},{"$f":"SUBTOTAL(103,Juli[22])","v":0},{"$f":"SUBTOTAL(103,Juli[23])","v":0},{"$f":"SUBTOTAL(103,Juli[24])","v":0},{"$f":"SUBTOTAL(103,Juli[25])","v":0},{"$f":"SUBTOTAL(103,Juli[26])","v":0},{"$f":"SUBTOTAL(103,Juli[27])","v":0},{"$f":"SUBTOTAL(103,Juli[28])","v":0},{"$f":"SUBTOTAL(103,Juli[29])","v":0},{"$f":"SUBTOTAL(103,Juli[30])","v":0},{"$f":"SUBTOTAL(103,Juli[31])","v":0},{"$f":"SUBTOTAL(109,Juli[Totaal aantal dagen])","v":0}]

{"sheet":"Augustus","index":7,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Augustus","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,1),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,2),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,3),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,4),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,5),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,6),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,7),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,8),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,9),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,10),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,11),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,12),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,13),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,14),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,15),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,16),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,17),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,18),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,19),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,20),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,21),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,22),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,23),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,24),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,25),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,26),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,27),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,28),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,29),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,30),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,8,31),1),\"aaa\")","v":"za"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(Augustus[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(Augustus[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Augustus[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(Augustus[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(Augustus[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Augustus Totaal"},{"$f":"SUBTOTAL(103,Augustus[1])","v":0},{"$f":"SUBTOTAL(103,Augustus[2])","v":0},{"$f":"SUBTOTAL(103,Augustus[3])","v":0},{"$f":"SUBTOTAL(103,Augustus[4])","v":0},{"$f":"SUBTOTAL(103,Augustus[5])","v":0},{"$f":"SUBTOTAL(103,Augustus[6])","v":0},{"$f":"SUBTOTAL(103,Augustus[7])","v":0},{"$f":"SUBTOTAL(103,Augustus[8])","v":0},{"$f":"SUBTOTAL(103,Augustus[9])","v":0},{"$f":"SUBTOTAL(103,Augustus[10])","v":0},{"$f":"SUBTOTAL(103,Augustus[11])","v":0},{"$f":"SUBTOTAL(103,Augustus[12])","v":0},{"$f":"SUBTOTAL(103,Augustus[13])","v":0},{"$f":"SUBTOTAL(103,Augustus[14])","v":0},{"$f":"SUBTOTAL(103,Augustus[15])","v":0},{"$f":"SUBTOTAL(103,Augustus[16])","v":0},{"$f":"SUBTOTAL(103,Augustus[17])","v":0},{"$f":"SUBTOTAL(103,Augustus[18])","v":0},{"$f":"SUBTOTAL(103,Augustus[19])","v":0},{"$f":"SUBTOTAL(103,Augustus[20])","v":0},{"$f":"SUBTOTAL(103,Augustus[21])","v":0},{"$f":"SUBTOTAL(103,Augustus[22])","v":0},{"$f":"SUBTOTAL(103,Augustus[23])","v":0},{"$f":"SUBTOTAL(103,Augustus[24])","v":0},{"$f":"SUBTOTAL(103,Augustus[25])","v":0},{"$f":"SUBTOTAL(103,Augustus[26])","v":0},{"$f":"SUBTOTAL(103,Augustus[27])","v":0},{"$f":"SUBTOTAL(103,Augustus[28])","v":0},{"$f":"SUBTOTAL(103,Augustus[29])","v":0},{"$f":"SUBTOTAL(103,Augustus[30])","v":0},{"$f":"SUBTOTAL(103,Augustus[31])","v":0},{"$f":"SUBTOTAL(109,Augustus[Totaal aantal dagen])","v":0}]

{"sheet":"September","index":8,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"september","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,1),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,2),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,3),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,4),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,5),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,6),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,7),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,8),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,9),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,10),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,11),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,12),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,13),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,14),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,15),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,16),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,17),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,18),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,19),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,20),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,21),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,22),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,23),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,24),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,25),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,26),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,27),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,28),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,29),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,9,30),1),\"aaa\")","v":"ma"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"september Totaal"},{"$f":"SUBTOTAL(103,September[1])","v":0},{"$f":"SUBTOTAL(103,September[2])","v":0},{"$f":"SUBTOTAL(103,September[3])","v":0},{"$f":"SUBTOTAL(103,September[4])","v":0},{"$f":"SUBTOTAL(103,September[5])","v":0},{"$f":"SUBTOTAL(103,September[6])","v":0},{"$f":"SUBTOTAL(103,September[7])","v":0},{"$f":"SUBTOTAL(103,September[8])","v":0},{"$f":"SUBTOTAL(103,September[9])","v":0},{"$f":"SUBTOTAL(103,September[10])","v":0},{"$f":"SUBTOTAL(103,September[11])","v":0},{"$f":"SUBTOTAL(103,September[12])","v":0},{"$f":"SUBTOTAL(103,September[13])","v":0},{"$f":"SUBTOTAL(103,September[14])","v":0},{"$f":"SUBTOTAL(103,September[15])","v":0},{"$f":"SUBTOTAL(103,September[16])","v":0},{"$f":"SUBTOTAL(103,September[17])","v":0},{"$f":"SUBTOTAL(103,September[18])","v":0},{"$f":"SUBTOTAL(103,September[19])","v":0},{"$f":"SUBTOTAL(103,September[20])","v":0},{"$f":"SUBTOTAL(103,September[21])","v":0},{"$f":"SUBTOTAL(103,September[22])","v":0},{"$f":"SUBTOTAL(103,September[23])","v":0},{"$f":"SUBTOTAL(103,September[24])","v":0},{"$f":"SUBTOTAL(103,September[25])","v":0},{"$f":"SUBTOTAL(103,September[26])","v":0},{"$f":"SUBTOTAL(103,September[27])","v":0},{"$f":"SUBTOTAL(103,September[28])","v":0},{"$f":"SUBTOTAL(103,September[29])","v":0},{"$f":"SUBTOTAL(103,September[30])","v":0},{"$f":"SUBTOTAL(103,September[[ ]])","v":0},{"$f":"SUBTOTAL(109,September[Totaal aantal dagen])","v":0}]

{"sheet":"Oktober","index":9,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"Oktober","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,1),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,2),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,3),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,4),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,5),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,6),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,7),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,8),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,9),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,10),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,11),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,12),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,13),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,14),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,15),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,16),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,17),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,18),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,19),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,20),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,21),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,22),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,23),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,24),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,25),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,26),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,27),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,28),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,29),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,30),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,10,31),1),\"aaa\")","v":"do"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"Oktober Totaal"},{"$f":"SUBTOTAL(103,Oktober[1])","v":0},{"$f":"SUBTOTAL(103,Oktober[2])","v":0},{"$f":"SUBTOTAL(103,Oktober[3])","v":0},{"$f":"SUBTOTAL(103,Oktober[4])","v":0},{"$f":"SUBTOTAL(103,Oktober[5])","v":0},{"$f":"SUBTOTAL(103,Oktober[6])","v":0},{"$f":"SUBTOTAL(103,Oktober[7])","v":0},{"$f":"SUBTOTAL(103,Oktober[8])","v":0},{"$f":"SUBTOTAL(103,Oktober[9])","v":0},{"$f":"SUBTOTAL(103,Oktober[10])","v":0},{"$f":"SUBTOTAL(103,Oktober[11])","v":0},{"$f":"SUBTOTAL(103,Oktober[12])","v":0},{"$f":"SUBTOTAL(103,Oktober[13])","v":0},{"$f":"SUBTOTAL(103,Oktober[14])","v":0},{"$f":"SUBTOTAL(103,Oktober[15])","v":0},{"$f":"SUBTOTAL(103,Oktober[16])","v":0},{"$f":"SUBTOTAL(103,Oktober[17])","v":0},{"$f":"SUBTOTAL(103,Oktober[18])","v":0},{"$f":"SUBTOTAL(103,Oktober[19])","v":0},{"$f":"SUBTOTAL(103,Oktober[20])","v":0},{"$f":"SUBTOTAL(103,Oktober[21])","v":0},{"$f":"SUBTOTAL(103,Oktober[22])","v":0},{"$f":"SUBTOTAL(103,Oktober[23])","v":0},{"$f":"SUBTOTAL(103,Oktober[24])","v":0},{"$f":"SUBTOTAL(103,Oktober[25])","v":0},{"$f":"SUBTOTAL(103,Oktober[26])","v":0},{"$f":"SUBTOTAL(103,Oktober[27])","v":0},{"$f":"SUBTOTAL(103,Oktober[28])","v":0},{"$f":"SUBTOTAL(103,Oktober[29])","v":0},{"$f":"SUBTOTAL(103,Oktober[30])","v":0},{"$f":"SUBTOTAL(103,Oktober[31])","v":0},{"$f":"SUBTOTAL(109,Oktober[Totaal aantal dagen])","v":0}]

{"sheet":"November","index":10,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"November","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,1),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,2),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,3),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,4),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,5),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,6),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,7),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,8),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,9),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,10),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,11),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,12),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,13),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,14),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,15),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,16),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,17),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,18),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,19),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,20),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,21),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,22),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,23),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,24),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,25),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,26),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,27),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,28),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,29),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,11,30),1),\"aaa\")","v":"za"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"November Totaal"},{"$f":"SUBTOTAL(103,November[1])","v":0},{"$f":"SUBTOTAL(103,November[2])","v":0},{"$f":"SUBTOTAL(103,November[3])","v":0},{"$f":"SUBTOTAL(103,November[4])","v":0},{"$f":"SUBTOTAL(103,November[5])","v":0},{"$f":"SUBTOTAL(103,November[6])","v":0},{"$f":"SUBTOTAL(103,November[7])","v":0},{"$f":"SUBTOTAL(103,November[8])","v":0},{"$f":"SUBTOTAL(103,November[9])","v":0},{"$f":"SUBTOTAL(103,November[10])","v":0},{"$f":"SUBTOTAL(103,November[11])","v":0},{"$f":"SUBTOTAL(103,November[12])","v":0},{"$f":"SUBTOTAL(103,November[13])","v":0},{"$f":"SUBTOTAL(103,November[14])","v":0},{"$f":"SUBTOTAL(103,November[15])","v":0},{"$f":"SUBTOTAL(103,November[16])","v":0},{"$f":"SUBTOTAL(103,November[17])","v":0},{"$f":"SUBTOTAL(103,November[18])","v":0},{"$f":"SUBTOTAL(103,November[19])","v":0},{"$f":"SUBTOTAL(103,November[20])","v":0},{"$f":"SUBTOTAL(103,November[21])","v":0},{"$f":"SUBTOTAL(103,November[22])","v":0},{"$f":"SUBTOTAL(103,November[23])","v":0},{"$f":"SUBTOTAL(103,November[24])","v":0},{"$f":"SUBTOTAL(103,November[25])","v":0},{"$f":"SUBTOTAL(103,November[26])","v":0},{"$f":"SUBTOTAL(103,November[27])","v":0},{"$f":"SUBTOTAL(103,November[28])","v":0},{"$f":"SUBTOTAL(103,November[29])","v":0},{"$f":"SUBTOTAL(103,November[30])","v":0},{"$f":"SUBTOTAL(103,November[[ ]])","v":0},{"$f":"SUBTOTAL(109,November[Totaal aantal dagen])","v":0}]

{"sheet":"December","index":11,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Employee_Absence_Title","v":"Afwezigheidsplanning Werknemers "}]
[null,"Sleutel afwezigheidstype","V","Vakantie",null,null,"P","Persoonlijk",null,null,"Z","Ziek",null,null,"Aangepast 1",{"$nulls":3},"Aangepast 2"]
[]
[null,"December","Afwezigheidsdatums",{"$nulls":30},{"$f":"CalendarYear","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,1),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,2),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,3),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,4),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,5),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,6),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,7),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,8),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,9),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,10),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,11),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,12),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,13),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,14),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,15),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,16),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,17),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,18),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,19),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,20),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,21),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,22),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,23),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,24),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,25),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,26),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,27),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,28),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,29),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,30),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(CalendarYear,12,31),1),\"aaa\")","v":"di"}]
[null,"Naam van werknemer","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Totaal aantal dagen"]
[null,"Werknemer 1",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 2",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 3",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 4",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,"Werknemer 5",{"$nulls":31},{"$f":"COUNTA(December[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"MonthName&\" Totaal\"","v":"December Totaal"},{"$f":"SUBTOTAL(103,December[1])","v":0},{"$f":"SUBTOTAL(103,December[2])","v":0},{"$f":"SUBTOTAL(103,December[3])","v":0},{"$f":"SUBTOTAL(103,December[4])","v":0},{"$f":"SUBTOTAL(103,December[5])","v":0},{"$f":"SUBTOTAL(103,December[6])","v":0},{"$f":"SUBTOTAL(103,December[7])","v":0},{"$f":"SUBTOTAL(103,December[8])","v":0},{"$f":"SUBTOTAL(103,December[9])","v":0},{"$f":"SUBTOTAL(103,December[10])","v":0},{"$f":"SUBTOTAL(103,December[11])","v":0},{"$f":"SUBTOTAL(103,December[12])","v":0},{"$f":"SUBTOTAL(103,December[13])","v":0},{"$f":"SUBTOTAL(103,December[14])","v":0},{"$f":"SUBTOTAL(103,December[15])","v":0},{"$f":"SUBTOTAL(103,December[16])","v":0},{"$f":"SUBTOTAL(103,December[17])","v":0},{"$f":"SUBTOTAL(103,December[18])","v":0},{"$f":"SUBTOTAL(103,December[19])","v":0},{"$f":"SUBTOTAL(103,December[20])","v":0},{"$f":"SUBTOTAL(103,December[21])","v":0},{"$f":"SUBTOTAL(103,December[22])","v":0},{"$f":"SUBTOTAL(103,December[23])","v":0},{"$f":"SUBTOTAL(103,December[24])","v":0},{"$f":"SUBTOTAL(103,December[25])","v":0},{"$f":"SUBTOTAL(103,December[26])","v":0},{"$f":"SUBTOTAL(103,December[27])","v":0},{"$f":"SUBTOTAL(103,December[28])","v":0},{"$f":"SUBTOTAL(103,December[29])","v":0},{"$f":"SUBTOTAL(103,December[30])","v":0},{"$f":"SUBTOTAL(103,December[31])","v":0},{"$f":"SUBTOTAL(109,December[Totaal aantal dagen])","v":0}]

{"sheet":"Werknemersnamen","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Werknemersnamen"]
[]
[null,"Werknemersnamen"]
[null,"Werknemer 1"]
[null,"Werknemer 2"]
[null,"Werknemer 3"]
[null,"Werknemer 4"]
[null,"Werknemer 5"]