{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Hoe gebruikt u deze sjabloon ","Studentenlijst","Augustus","September","Oktober","November","December","Januari","Februari","Maart","April","Mei","Juni","Juli","Aanwezigheidsrapport student"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Hoe gebruikt u deze sjabloon ","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[3,2,3,12],[4,4,4,12],[5,4,5,12],[6,4,6,12],[7,4,7,12],[8,4,8,7],[11,2,11,12],[12,4,12,12],[13,4,13,12],[14,4,14,12],[17,2,17,12],[18,4,18,12],[19,4,19,12],[20,4,20,12],[21,4,21,12],[24,2,24,12]]}
["HOE GEBRUIKT U DEZE SJABLOON?"]
[]
[null,"WAAR MOET IK BEGINNEN?"]
[null,null,"Voordat u de aanwezigheid van studenten kunt bijhouden, moet u de volgende stappen uitvoeren:"]
[{"$nulls":3},"1.","Voeg de studenten toe: Voer op het blad Studentenlijst de gegevens van elke student in, zoals de namen van de ouders of voogd en de contactgegevens. De student-id is belangrijk. Deze id is een unieke identificatiecode voor elke student, die in de hele werkmap wordt gebruikt om de gegevensinvoer te vereenvoudigen via de vervolgkeuzelijst Student-id. De gegevens die u op het blad Studentenlijst invoert, worden ook op andere bladen gebruikt, bijvoorbeeld op het blad Aanwezigheidsrapport student en op de bladen met demaandelijkse aanwezigheidsoverzichten."]
[{"$nulls":3},"2.","Wijzig het studiejaar: Ga naar het blad Augustus, klik op het ringveld in de rechterbovenhoek van de tabel om het studiejaar bij te werken. Hierdoor wordt de koptekst van de aanwezigheidsoverzichten van alle maanden in de werkmap bijgewerkt. (Het ringveld wordt niet afgedrukt.)"]
[{"$nulls":3},"3.","(Optioneel) Wijzig de kleuren in de werkmap:  Navigeer naar het laatste blad, Aanwezigheidsrapport student. Ga vervolgens naar het tabblad Controleren en klik in de groep Wijzigingen op Beveiliging blad opheffen. Ga vervolgens naar het tabblad Pagina-indeling, klik in de groep Thema's op Kleuren en selecteer een andere themakleurenset in de kleurengalerie. Nadat u de kleuren hebt gewijzigd en eventuele andere themawijzigingen hebt aangebracht, gaat u terug naar het blad Aanwezigheidsrapport student. Ga vervolgens naar het tabblad Controleren, klik in de groep Wijzigingen op Blad beveiligen en klik op OK."]
[{"$nulls":4},"Tip: Maak een aangepaste themakleurenset die past bij de kleuren van de onderwijsinstelling. Ga naar het tabblad Pagina-indeling, klik in de groep Thema's op Kleuren en klik vervolgens onder aan de kleurengalerie op Nieuwe themakleuren maken. Zie het volgende Help-onderwerp voor meer informatie over het maken van een aangepaste kleurenset: "]
[{"$nulls":4},"Een documentthema aanpassen"]
[]
[null,"IK HEB DE STUDENTEN TOEGEVOEGD, WAT MOET IK NU DOEN?"]
[null,null,"Nadat u uw studenten hebt ingevoerd op het blad Studentenlijst, kunt u hun aanwezigheid bijhouden voor het studiejaar. Ga als volgt te werk:"]
[{"$nulls":3},"1.","Voeg een student aan een aanwezigheidsoverzicht toe door in een cel onder de kolom Student-id te klikken en een id in de lijst te selecteren. De naam van de student wordt automatisch weergegeven als u een id selecteert. "]
[{"$nulls":4},"Tip: U kunt de gegevensinvoer vereenvoudigen. Nadat u de studenten voor een bepaalde maand hebt toegevoegd, selecteert u de ingevoerde student-id's, kopieert u ze en plakt u ze in de kolom Student-id voor de resterende maanden. "]
[{"$nulls":3},"2.","Voer vervolgens de aanwezigheidsgegevens voor elke dag van de maand in met behulp van de aanwezigheidstypen zoals vermeld bij de kleurcodes. De aanwezigheidsgegevens voor elke student worden automatisch berekend per aanwezigheidstype in de totaalkolom. De totale afwezigheidsgegevens voor elke dag worden automatisch berekend in de totaalrij onder aan de tabel."]
[]
[null,"HOE KAN IK MEER STUDENTEN TOEVOEGEN AAN HET AANWEZIGHEIDSOVERZICHT VOOR EEN BEPAALDE MAAND?"]
[null,null,"De bladen met de maandelijkse aanwezigheidsoverzichten en de studentenlijst zijn Excel-tabellen. Ga op een van de volgende manieren te werk om nieuwe rijen aan een Excel-tabel toe te voegen:"]
[{"$nulls":3},"● ","Als de tabel geen totaalrij heeft, typt u gegevens onder de tabel. Als u op Enter of Tab drukt, wordt de tabel automatisch uitgebreid."]
[{"$nulls":3},"● ","Plaats de celaanwijzer in de laatste cel boven de totaalrij, zoals de cel Totaal aantal dagen afwezig voor de laatste student, en druk vervolgens op Tab."]
[{"$nulls":3},"● ","Klik met de rechtermuisknop in de tabel, wijs in het snelmenu Invoegen aan en klik vervolgens op Tabelrijen boven of Tabelrijen onder. "]
[{"$nulls":3},"● ","Plaats de muisaanwijzer op de tabelformaatgreep in de rechterbenedenhoek van de tabel en sleep omlaag om het aantal beschikbare tabelrijen te vergroten."]
[]
[null,"KAN IK DE AANWEZIGHEID VAN EEN STUDENT VOOR HET HELE STUDIEJAAR WEERGEVEN?"]
[null,null,"Op het laatste blad in deze werkmap, Aanwezigheidsrapport student, wordt de aanwezigheid voor het jaar tot heden bijgehouden. Als u een rapport voor een bepaalde student wilt weergeven, klikt u in de cel onder Student-id en selecteert u een id in de vervolgkeuzelijst. De gegevens die u eerder voor de geselecteerde student hebt ingevoerd op het blad Studentenlijst, worden automatisch weergegeven. De eerste keer dat u het aanwezigheidsrapport voor een student gebruikt, moet u de onderwijsinstelling, het jaar, de docent en het lokaal invoeren. Deze gegevens blijven ongewijzigd als u een andere student selecteert. "]

{"sheet":"Studentenlijst","index":1,"n_rows":8,"n_cols":19,"rows_kept":8}
["STUDENTENLIJST"]
[]
[null,"Student-id","Voornaam student","Achternaam student","Geslacht","Geboortedatum","Ouder of voogd 1","Relatie ouder/voogd 1","Telefoonnummer werk ouder/voogd 1","Telefoonnummer privé ouder/voogd 1","Ouder/voogd 2","Relatie ouder/voogd 2","Telefoonnummer werk ouder/voogd 2","Telefoonnummer privé ouder/voogd 2","Contactpersoon bij noodgeval","Relatie contactpersoon bij noodgeval","Telefoonnummer werk contactpersoon bij noodgeval","Telefoonnummer privé contactpersoon bij noodgeval","Volledige naam student"]
[null,"S001","Ties","Arts","M","1997-03-28","Pascaline Arts","Moeder",1235550134,2345550134,"Richard Arts","Vader",1235550134,2345550134,"Jeroen Cool","Grootvader",7895550189,7895550134,{"$f":"Studentenlijst!$C4&\" \"&Studentenlijst!$D4","v":"Ties Arts"}]
[null,"S002","Student",2,{"$nulls":14},{"$f":"Studentenlijst!$C5&\" \"&Studentenlijst!$D5","v":"Student 2"}]
[null,"S003","Student",3,{"$nulls":14},{"$f":"Studentenlijst!$C6&\" \"&Studentenlijst!$D6","v":"Student 3"}]
[null,"S004","Student",4,{"$nulls":14},{"$f":"Studentenlijst!$C7&\" \"&Studentenlijst!$D7","v":"Student 4"}]
[null,"S005","Student",5,{"$nulls":14},{"$f":"Studentenlijst!$C8&\" \"&Studentenlijst!$D8","v":"Student 5"}]

{"sheet":"Augustus","index":2,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",2012]
[]
[null,null,"VERKLARING KLEUREN ","T","Te laat",null,null,"G","Geoorloofd",null,null,"O","Ongeoorloofd",null,null,"A","Aanwezig",null,null,"L","Lesvrij"]
[]
[null,{"$f":"DATE(Kalenderjaar,8,1)","v":"2012-08-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,1),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,2),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,3),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,4),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,5),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,6),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,7),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,8),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,9),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,10),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,11),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,12),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,13),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,14),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,15),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,16),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,17),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,18),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,19),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,20),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,21),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,22),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,23),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,24),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,25),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,26),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,27),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,28),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,29),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,30),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,8,31),1),\"aaa\")","v":"vr"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,"S001",{"$f":"IFERROR(VLOOKUP(AanwezigheidAugustus[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":"Ties Arts"},"A","A","T","T","A","L","L","A","A","G","A","A","L","L","A","A","A","A","A","L","L","A","A","A","A","A","L","L","A","A","A",{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code1)","v":2},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code2)","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code4)","v":20},{"$f":"SUM(AanwezigheidAugustus[[#This Row],[G]:[O]])","v":1}]
[null,"S002",{"$f":"IFERROR(VLOOKUP(AanwezigheidAugustus[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":"Student 2"},"A","O","A","A","A","L","L","A","G","G","G","G","L","L","A","A","A","A","A","L","L","A","A","A","T","T","L","L","A","A","A",{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code1)","v":2},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code2)","v":4},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code3)","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code4)","v":16},{"$f":"SUM(AanwezigheidAugustus[[#This Row],[G]:[O]])","v":5}]
[null,"S003",{"$f":"IFERROR(VLOOKUP(AanwezigheidAugustus[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":"Student 3"},"A","G","A","A","A","L","L","A","A","O","A","A","L","L","A","A","A","A","A","L","L","A","A","G","G","A","L","L","A","A","A",{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code2)","v":3},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code3)","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code4)","v":19},{"$f":"SUM(AanwezigheidAugustus[[#This Row],[G]:[O]])","v":4}]
[null,"S004",{"$f":"IFERROR(VLOOKUP(AanwezigheidAugustus[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":"Student 4"},"A","A","A","A","A","L","L","A","A","A","A","A","L","L","A","A","A","A","A","L","L","A","O","A","A","G","L","L","A","G","A",{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code2)","v":2},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code3)","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code4)","v":20},{"$f":"SUM(AanwezigheidAugustus[[#This Row],[G]:[O]])","v":3}]
[null,"S005",{"$f":"IFERROR(VLOOKUP(AanwezigheidAugustus[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":"Student 5"},"A","A","A","A","A","L","L","A","A","A","A","A","L","L","A","A","A","A","A","L","L","A","A","A","A","A","L","L","A","A","A",{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[[#This Row],[1]:[31]],Code4)","v":23},{"$f":"SUM(AanwezigheidAugustus[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidAugustus[1],\"O\")+COUNTIF(AanwezigheidAugustus[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[2],\"O\")+COUNTIF(AanwezigheidAugustus[2],\"G\")","v":2},{"$f":"COUNTIF(AanwezigheidAugustus[3],\"O\")+COUNTIF(AanwezigheidAugustus[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[4],\"O\")+COUNTIF(AanwezigheidAugustus[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[5],\"O\")+COUNTIF(AanwezigheidAugustus[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[6],\"O\")+COUNTIF(AanwezigheidAugustus[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[7],\"O\")+COUNTIF(AanwezigheidAugustus[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[8],\"O\")+COUNTIF(AanwezigheidAugustus[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[9],\"O\")+COUNTIF(AanwezigheidAugustus[9],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[10],\"O\")+COUNTIF(AanwezigheidAugustus[10],\"G\")","v":3},{"$f":"COUNTIF(AanwezigheidAugustus[11],\"O\")+COUNTIF(AanwezigheidAugustus[11],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[12],\"O\")+COUNTIF(AanwezigheidAugustus[12],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[13],\"O\")+COUNTIF(AanwezigheidAugustus[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[14],\"O\")+COUNTIF(AanwezigheidAugustus[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[15],\"O\")+COUNTIF(AanwezigheidAugustus[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[16],\"O\")+COUNTIF(AanwezigheidAugustus[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[17],\"O\")+COUNTIF(AanwezigheidAugustus[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[18],\"O\")+COUNTIF(AanwezigheidAugustus[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[19],\"O\")+COUNTIF(AanwezigheidAugustus[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[20],\"O\")+COUNTIF(AanwezigheidAugustus[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[21],\"O\")+COUNTIF(AanwezigheidAugustus[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[22],\"O\")+COUNTIF(AanwezigheidAugustus[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[23],\"O\")+COUNTIF(AanwezigheidAugustus[23],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[24],\"O\")+COUNTIF(AanwezigheidAugustus[24],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[25],\"O\")+COUNTIF(AanwezigheidAugustus[25],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[26],\"O\")+COUNTIF(AanwezigheidAugustus[26],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[27],\"O\")+COUNTIF(AanwezigheidAugustus[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[28],\"O\")+COUNTIF(AanwezigheidAugustus[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[29],\"O\")+COUNTIF(AanwezigheidAugustus[29],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidAugustus[30],\"O\")+COUNTIF(AanwezigheidAugustus[30],\"G\")","v":1},{"$f":"COUNTIF(AanwezigheidAugustus[31],\"O\")+COUNTIF(AanwezigheidAugustus[31],\"G\")","v":0},{"$f":"SUBTOTAL(109,AanwezigheidAugustus[T])","v":4},{"$f":"SUBTOTAL(109,AanwezigheidAugustus[G])","v":10},{"$f":"SUBTOTAL(109,AanwezigheidAugustus[O])","v":3},{"$f":"SUBTOTAL(109,AanwezigheidAugustus[A])","v":98},{"$f":"SUBTOTAL(109,AanwezigheidAugustus[Dagen afwezig])","v":13}]

{"sheet":"September","index":3,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar,9,1)","v":"2012-09-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,1),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,2),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,3),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,4),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,5),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,6),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,7),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,8),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,9),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,10),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,11),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,12),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,13),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,14),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,15),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,16),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,17),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,18),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,19),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,20),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,21),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,22),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,23),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,24),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,25),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,26),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,27),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,28),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,29),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,9,30),1),\"aaa\")","v":"zo"},null,"Totalen"]
[null,"Student-id","Naam student","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"," ","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidSeptember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidSeptember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidSeptember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidSeptember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidSeptember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidSeptember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidSeptember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidSeptember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidSeptember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidSeptember[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidSeptember[1],\"O\")+COUNTIF(AanwezigheidSeptember[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[2],\"O\")+COUNTIF(AanwezigheidSeptember[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[3],\"O\")+COUNTIF(AanwezigheidSeptember[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[4],\"O\")+COUNTIF(AanwezigheidSeptember[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[5],\"O\")+COUNTIF(AanwezigheidSeptember[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[6],\"O\")+COUNTIF(AanwezigheidSeptember[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[7],\"O\")+COUNTIF(AanwezigheidSeptember[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[8],\"O\")+COUNTIF(AanwezigheidSeptember[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[9],\"O\")+COUNTIF(AanwezigheidSeptember[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[10],\"O\")+COUNTIF(AanwezigheidSeptember[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[11],\"O\")+COUNTIF(AanwezigheidSeptember[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[12],\"O\")+COUNTIF(AanwezigheidSeptember[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[13],\"O\")+COUNTIF(AanwezigheidSeptember[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[14],\"O\")+COUNTIF(AanwezigheidSeptember[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[15],\"O\")+COUNTIF(AanwezigheidSeptember[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[16],\"O\")+COUNTIF(AanwezigheidSeptember[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[17],\"O\")+COUNTIF(AanwezigheidSeptember[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[18],\"O\")+COUNTIF(AanwezigheidSeptember[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[19],\"O\")+COUNTIF(AanwezigheidSeptember[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[20],\"O\")+COUNTIF(AanwezigheidSeptember[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[21],\"O\")+COUNTIF(AanwezigheidSeptember[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[22],\"O\")+COUNTIF(AanwezigheidSeptember[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[23],\"O\")+COUNTIF(AanwezigheidSeptember[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[24],\"O\")+COUNTIF(AanwezigheidSeptember[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[25],\"O\")+COUNTIF(AanwezigheidSeptember[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[26],\"O\")+COUNTIF(AanwezigheidSeptember[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[27],\"O\")+COUNTIF(AanwezigheidSeptember[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[28],\"O\")+COUNTIF(AanwezigheidSeptember[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[29],\"O\")+COUNTIF(AanwezigheidSeptember[29],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[30],\"O\")+COUNTIF(AanwezigheidSeptember[30],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidSeptember[[ ]],\"O\")+COUNTIF(AanwezigheidSeptember[[ ]],\"G\")","v":0},{"$f":"SUBTOTAL(109,AanwezigheidSeptember[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidSeptember[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidSeptember[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidSeptember[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidSeptember[Dagen afwezig])","v":0}]

{"sheet":"Oktober","index":4,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar,10,1)","v":"2012-10-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,1),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,2),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,3),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,4),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,5),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,6),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,7),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,8),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,9),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,10),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,11),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,12),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,13),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,14),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,15),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,16),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,17),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,18),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,19),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,20),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,21),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,22),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,23),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,24),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,25),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,26),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,27),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,28),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,29),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,30),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,10,31),1),\"aaa\")","v":"wo"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidOktober[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidOktober[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidOktober[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidOktober[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidOktober[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidOktober[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidOktober[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidOktober[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidOktober[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidOktober[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidOktober[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidOktober[1],\"O\")+COUNTIF(AanwezigheidOktober[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[2],\"O\")+COUNTIF(AanwezigheidOktober[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[3],\"O\")+COUNTIF(AanwezigheidOktober[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[4],\"O\")+COUNTIF(AanwezigheidOktober[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[5],\"O\")+COUNTIF(AanwezigheidOktober[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[6],\"O\")+COUNTIF(AanwezigheidOktober[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[7],\"O\")+COUNTIF(AanwezigheidOktober[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[8],\"O\")+COUNTIF(AanwezigheidOktober[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[9],\"O\")+COUNTIF(AanwezigheidOktober[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[10],\"O\")+COUNTIF(AanwezigheidOktober[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[11],\"O\")+COUNTIF(AanwezigheidOktober[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[12],\"O\")+COUNTIF(AanwezigheidOktober[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[13],\"O\")+COUNTIF(AanwezigheidOktober[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[14],\"O\")+COUNTIF(AanwezigheidOktober[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[15],\"O\")+COUNTIF(AanwezigheidOktober[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[16],\"O\")+COUNTIF(AanwezigheidOktober[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[17],\"O\")+COUNTIF(AanwezigheidOktober[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[18],\"O\")+COUNTIF(AanwezigheidOktober[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[19],\"O\")+COUNTIF(AanwezigheidOktober[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[20],\"O\")+COUNTIF(AanwezigheidOktober[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[21],\"O\")+COUNTIF(AanwezigheidOktober[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[22],\"O\")+COUNTIF(AanwezigheidOktober[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[23],\"O\")+COUNTIF(AanwezigheidOktober[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[24],\"O\")+COUNTIF(AanwezigheidOktober[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[25],\"O\")+COUNTIF(AanwezigheidOktober[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[26],\"O\")+COUNTIF(AanwezigheidOktober[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[27],\"O\")+COUNTIF(AanwezigheidOktober[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[28],\"O\")+COUNTIF(AanwezigheidOktober[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[29],\"O\")+COUNTIF(AanwezigheidOktober[29],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[30],\"O\")+COUNTIF(AanwezigheidOktober[30],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidOktober[31],\"O\")+COUNTIF(AanwezigheidOktober[31],\"G\")","v":0},{"$f":"SUBTOTAL(109,AanwezigheidOktober[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidOktober[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidOktober[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidOktober[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidOktober[Dagen afwezig])","v":0}]

{"sheet":"November","index":5,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar,11,1)","v":"2012-11-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,1),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,2),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,3),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,4),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,5),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,6),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,7),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,8),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,9),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,10),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,11),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,12),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,13),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,14),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,15),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,16),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,17),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,18),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,19),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,20),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,21),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,22),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,23),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,24),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,25),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,26),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,27),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,28),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,29),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,11,30),1),\"aaa\")","v":"vr"},null,"Totalen"]
[null,"Student-id","Naam student","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"," ","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidNovember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidNovember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidNovember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidNovember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidNovember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidNovember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidNovember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidNovember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidNovember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidNovember[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidNovember[1],\"O\")+COUNTIF(AanwezigheidNovember[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[2],\"O\")+COUNTIF(AanwezigheidNovember[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[3],\"O\")+COUNTIF(AanwezigheidNovember[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[4],\"O\")+COUNTIF(AanwezigheidNovember[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[5],\"O\")+COUNTIF(AanwezigheidNovember[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[6],\"O\")+COUNTIF(AanwezigheidNovember[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[7],\"O\")+COUNTIF(AanwezigheidNovember[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[8],\"O\")+COUNTIF(AanwezigheidNovember[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[9],\"O\")+COUNTIF(AanwezigheidNovember[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[10],\"O\")+COUNTIF(AanwezigheidNovember[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[11],\"O\")+COUNTIF(AanwezigheidNovember[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[12],\"O\")+COUNTIF(AanwezigheidNovember[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[13],\"O\")+COUNTIF(AanwezigheidNovember[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[14],\"O\")+COUNTIF(AanwezigheidNovember[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[15],\"O\")+COUNTIF(AanwezigheidNovember[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[16],\"O\")+COUNTIF(AanwezigheidNovember[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[17],\"O\")+COUNTIF(AanwezigheidNovember[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[18],\"O\")+COUNTIF(AanwezigheidNovember[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[19],\"O\")+COUNTIF(AanwezigheidNovember[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[20],\"O\")+COUNTIF(AanwezigheidNovember[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[21],\"O\")+COUNTIF(AanwezigheidNovember[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[22],\"O\")+COUNTIF(AanwezigheidNovember[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[23],\"O\")+COUNTIF(AanwezigheidNovember[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[24],\"O\")+COUNTIF(AanwezigheidNovember[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[25],\"O\")+COUNTIF(AanwezigheidNovember[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[26],\"O\")+COUNTIF(AanwezigheidNovember[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[27],\"O\")+COUNTIF(AanwezigheidNovember[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[28],\"O\")+COUNTIF(AanwezigheidNovember[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[29],\"O\")+COUNTIF(AanwezigheidNovember[29],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[30],\"O\")+COUNTIF(AanwezigheidNovember[30],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidNovember[[ ]],\"O\")+COUNTIF(AanwezigheidNovember[[ ]],\"G\")","v":0},{"$f":"SUBTOTAL(109,AanwezigheidNovember[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidNovember[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidNovember[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidNovember[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidNovember[Dagen afwezig])","v":0}]

{"sheet":"December","index":6,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar,12,1)","v":"2012-12-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,1),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,2),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,3),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,4),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,5),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,6),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,7),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,8),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,9),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,10),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,11),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,12),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,13),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,14),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,15),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,16),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,17),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,18),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,19),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,20),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,21),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,22),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,23),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,24),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,25),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,26),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,27),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,28),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,29),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,30),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar,12,31),1),\"aaa\")","v":"ma"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidDecember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidDecember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidDecember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidDecember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidDecember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidDecember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidDecember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidDecember[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidDecember[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidDecember[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidDecember[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidDecember[1],\"O\")+COUNTIF(AanwezigheidDecember[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[2],\"O\")+COUNTIF(AanwezigheidDecember[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[3],\"O\")+COUNTIF(AanwezigheidDecember[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[4],\"O\")+COUNTIF(AanwezigheidDecember[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[5],\"O\")+COUNTIF(AanwezigheidDecember[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[6],\"O\")+COUNTIF(AanwezigheidDecember[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[7],\"O\")+COUNTIF(AanwezigheidDecember[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[8],\"O\")+COUNTIF(AanwezigheidDecember[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[9],\"O\")+COUNTIF(AanwezigheidDecember[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[10],\"O\")+COUNTIF(AanwezigheidDecember[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[11],\"O\")+COUNTIF(AanwezigheidDecember[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[12],\"O\")+COUNTIF(AanwezigheidDecember[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[13],\"O\")+COUNTIF(AanwezigheidDecember[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[14],\"O\")+COUNTIF(AanwezigheidDecember[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[15],\"O\")+COUNTIF(AanwezigheidDecember[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[16],\"O\")+COUNTIF(AanwezigheidDecember[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[17],\"O\")+COUNTIF(AanwezigheidDecember[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[18],\"O\")+COUNTIF(AanwezigheidDecember[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[19],\"O\")+COUNTIF(AanwezigheidDecember[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[20],\"O\")+COUNTIF(AanwezigheidDecember[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[21],\"O\")+COUNTIF(AanwezigheidDecember[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[22],\"O\")+COUNTIF(AanwezigheidDecember[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[23],\"O\")+COUNTIF(AanwezigheidDecember[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[24],\"O\")+COUNTIF(AanwezigheidDecember[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[25],\"O\")+COUNTIF(AanwezigheidDecember[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[26],\"O\")+COUNTIF(AanwezigheidDecember[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[27],\"O\")+COUNTIF(AanwezigheidDecember[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[28],\"O\")+COUNTIF(AanwezigheidDecember[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[29],\"O\")+COUNTIF(AanwezigheidDecember[29],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[30],\"O\")+COUNTIF(AanwezigheidDecember[30],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidDecember[31],\"O\")+COUNTIF(AanwezigheidDecember[31],\"G\")","v":0},{"$f":"SUBTOTAL(109,AanwezigheidDecember[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidDecember[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidDecember[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidDecember[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidDecember[Dagen afwezig])","v":0}]

{"sheet":"Januari","index":7,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,1,1)","v":"2013-01-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,1),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,2),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,3),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,4),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,5),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,6),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,7),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,8),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,9),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,10),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,11),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,12),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,13),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,14),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,15),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,16),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,17),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,18),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,19),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,20),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,21),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,22),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,23),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,24),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,25),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,26),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,27),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,28),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,29),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,30),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,1,31),1),\"aaa\")","v":"do"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJanuari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJanuari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJanuari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJanuari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJanuari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJanuari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJanuari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJanuari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJanuari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJanuari[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidJanuari[1],\"O\")+COUNTIF(AanwezigheidJanuari[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[2],\"O\")+COUNTIF(AanwezigheidJanuari[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[3],\"O\")+COUNTIF(AanwezigheidJanuari[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[4],\"O\")+COUNTIF(AanwezigheidJanuari[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[5],\"O\")+COUNTIF(AanwezigheidJanuari[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[6],\"O\")+COUNTIF(AanwezigheidJanuari[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[7],\"O\")+COUNTIF(AanwezigheidJanuari[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[8],\"O\")+COUNTIF(AanwezigheidJanuari[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[9],\"O\")+COUNTIF(AanwezigheidJanuari[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[10],\"O\")+COUNTIF(AanwezigheidJanuari[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[11],\"O\")+COUNTIF(AanwezigheidJanuari[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[12],\"O\")+COUNTIF(AanwezigheidJanuari[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[13],\"O\")+COUNTIF(AanwezigheidJanuari[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[14],\"O\")+COUNTIF(AanwezigheidJanuari[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[15],\"O\")+COUNTIF(AanwezigheidJanuari[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[16],\"O\")+COUNTIF(AanwezigheidJanuari[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[17],\"O\")+COUNTIF(AanwezigheidJanuari[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[18],\"O\")+COUNTIF(AanwezigheidJanuari[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[19],\"O\")+COUNTIF(AanwezigheidJanuari[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[20],\"O\")+COUNTIF(AanwezigheidJanuari[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[21],\"O\")+COUNTIF(AanwezigheidJanuari[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[22],\"O\")+COUNTIF(AanwezigheidJanuari[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[23],\"O\")+COUNTIF(AanwezigheidJanuari[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[24],\"O\")+COUNTIF(AanwezigheidJanuari[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[25],\"O\")+COUNTIF(AanwezigheidJanuari[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[26],\"O\")+COUNTIF(AanwezigheidJanuari[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[27],\"O\")+COUNTIF(AanwezigheidJanuari[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[28],\"O\")+COUNTIF(AanwezigheidJanuari[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJanuari[29],\"O\")+COUNTIF(AanwezigheidJanuari[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidJanuari[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJanuari[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJanuari[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJanuari[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJanuari[Dagen afwezig])","v":0}]

{"sheet":"Februari","index":8,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,2,1)","v":"2013-02-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,1),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,2),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,3),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,4),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,5),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,6),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,7),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,8),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,9),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,10),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,11),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,12),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,13),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,14),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,15),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,16),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,17),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,18),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,19),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,20),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,21),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,22),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,23),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,24),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,25),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,26),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,27),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,28),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,2,29),1),\"aaa\")","v":"vr"},null,null,"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidFebruari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidFebruari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidFebruari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidFebruari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidFebruari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidFebruari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidFebruari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidFebruari[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidFebruari[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidFebruari[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidFebruari[1],\"O\")+COUNTIF(AanwezigheidFebruari[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[2],\"O\")+COUNTIF(AanwezigheidFebruari[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[3],\"O\")+COUNTIF(AanwezigheidFebruari[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[4],\"O\")+COUNTIF(AanwezigheidFebruari[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[5],\"O\")+COUNTIF(AanwezigheidFebruari[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[6],\"O\")+COUNTIF(AanwezigheidFebruari[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[7],\"O\")+COUNTIF(AanwezigheidFebruari[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[8],\"O\")+COUNTIF(AanwezigheidFebruari[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[9],\"O\")+COUNTIF(AanwezigheidFebruari[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[10],\"O\")+COUNTIF(AanwezigheidFebruari[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[11],\"O\")+COUNTIF(AanwezigheidFebruari[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[12],\"O\")+COUNTIF(AanwezigheidFebruari[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[13],\"O\")+COUNTIF(AanwezigheidFebruari[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[14],\"O\")+COUNTIF(AanwezigheidFebruari[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[15],\"O\")+COUNTIF(AanwezigheidFebruari[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[16],\"O\")+COUNTIF(AanwezigheidFebruari[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[17],\"O\")+COUNTIF(AanwezigheidFebruari[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[18],\"O\")+COUNTIF(AanwezigheidFebruari[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[19],\"O\")+COUNTIF(AanwezigheidFebruari[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[20],\"O\")+COUNTIF(AanwezigheidFebruari[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[21],\"O\")+COUNTIF(AanwezigheidFebruari[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[22],\"O\")+COUNTIF(AanwezigheidFebruari[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[23],\"O\")+COUNTIF(AanwezigheidFebruari[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[24],\"O\")+COUNTIF(AanwezigheidFebruari[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[25],\"O\")+COUNTIF(AanwezigheidFebruari[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[26],\"O\")+COUNTIF(AanwezigheidFebruari[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[27],\"O\")+COUNTIF(AanwezigheidFebruari[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[28],\"O\")+COUNTIF(AanwezigheidFebruari[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidFebruari[29],\"O\")+COUNTIF(AanwezigheidFebruari[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidFebruari[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidFebruari[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidFebruari[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidFebruari[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidFebruari[Dagen afwezig])","v":0}]

{"sheet":"Maart","index":9,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,3,1)","v":"2013-03-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,1),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,2),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,3),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,4),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,5),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,6),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,7),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,8),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,9),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,10),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,11),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,12),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,13),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,14),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,15),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,16),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,17),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,18),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,19),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,20),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,21),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,22),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,23),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,24),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,25),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,26),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,27),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,28),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,29),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,30),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,3,31),1),\"aaa\")","v":"zo"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMaart[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMaart[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMaart[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMaart[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMaart[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMaart[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMaart[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMaart[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMaart[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMaart[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMaart[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidMaart[1],\"O\")+COUNTIF(AanwezigheidMaart[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[2],\"O\")+COUNTIF(AanwezigheidMaart[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[3],\"O\")+COUNTIF(AanwezigheidMaart[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[4],\"O\")+COUNTIF(AanwezigheidMaart[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[5],\"O\")+COUNTIF(AanwezigheidMaart[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[6],\"O\")+COUNTIF(AanwezigheidMaart[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[7],\"O\")+COUNTIF(AanwezigheidMaart[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[8],\"O\")+COUNTIF(AanwezigheidMaart[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[9],\"O\")+COUNTIF(AanwezigheidMaart[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[10],\"O\")+COUNTIF(AanwezigheidMaart[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[11],\"O\")+COUNTIF(AanwezigheidMaart[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[12],\"O\")+COUNTIF(AanwezigheidMaart[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[13],\"O\")+COUNTIF(AanwezigheidMaart[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[14],\"O\")+COUNTIF(AanwezigheidMaart[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[15],\"O\")+COUNTIF(AanwezigheidMaart[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[16],\"O\")+COUNTIF(AanwezigheidMaart[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[17],\"O\")+COUNTIF(AanwezigheidMaart[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[18],\"O\")+COUNTIF(AanwezigheidMaart[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[19],\"O\")+COUNTIF(AanwezigheidMaart[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[20],\"O\")+COUNTIF(AanwezigheidMaart[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[21],\"O\")+COUNTIF(AanwezigheidMaart[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[22],\"O\")+COUNTIF(AanwezigheidMaart[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[23],\"O\")+COUNTIF(AanwezigheidMaart[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[24],\"O\")+COUNTIF(AanwezigheidMaart[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[25],\"O\")+COUNTIF(AanwezigheidMaart[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[26],\"O\")+COUNTIF(AanwezigheidMaart[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[27],\"O\")+COUNTIF(AanwezigheidMaart[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[28],\"O\")+COUNTIF(AanwezigheidMaart[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMaart[29],\"O\")+COUNTIF(AanwezigheidMaart[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidMaart[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMaart[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMaart[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMaart[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMaart[Dagen afwezig])","v":0}]

{"sheet":"April","index":10,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,4,1)","v":"2013-04-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,1),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,2),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,3),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,4),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,5),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,6),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,7),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,8),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,9),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,10),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,11),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,12),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,13),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,14),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,15),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,16),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,17),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,18),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,19),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,20),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,21),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,22),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,23),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,24),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,25),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,26),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,27),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,28),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,29),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,4,30),1),\"aaa\")","v":"di"},null,"Totalen"]
[null,"Student-id","Naam student","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"," ","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidApril[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidApril[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidApril[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidApril[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidApril[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidApril[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidApril[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidApril[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidApril[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidApril[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidApril[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidApril[1],\"O\")+COUNTIF(AanwezigheidApril[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[2],\"O\")+COUNTIF(AanwezigheidApril[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[3],\"O\")+COUNTIF(AanwezigheidApril[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[4],\"O\")+COUNTIF(AanwezigheidApril[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[5],\"O\")+COUNTIF(AanwezigheidApril[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[6],\"O\")+COUNTIF(AanwezigheidApril[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[7],\"O\")+COUNTIF(AanwezigheidApril[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[8],\"O\")+COUNTIF(AanwezigheidApril[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[9],\"O\")+COUNTIF(AanwezigheidApril[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[10],\"O\")+COUNTIF(AanwezigheidApril[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[11],\"O\")+COUNTIF(AanwezigheidApril[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[12],\"O\")+COUNTIF(AanwezigheidApril[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[13],\"O\")+COUNTIF(AanwezigheidApril[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[14],\"O\")+COUNTIF(AanwezigheidApril[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[15],\"O\")+COUNTIF(AanwezigheidApril[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[16],\"O\")+COUNTIF(AanwezigheidApril[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[17],\"O\")+COUNTIF(AanwezigheidApril[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[18],\"O\")+COUNTIF(AanwezigheidApril[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[19],\"O\")+COUNTIF(AanwezigheidApril[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[20],\"O\")+COUNTIF(AanwezigheidApril[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[21],\"O\")+COUNTIF(AanwezigheidApril[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[22],\"O\")+COUNTIF(AanwezigheidApril[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[23],\"O\")+COUNTIF(AanwezigheidApril[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[24],\"O\")+COUNTIF(AanwezigheidApril[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[25],\"O\")+COUNTIF(AanwezigheidApril[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[26],\"O\")+COUNTIF(AanwezigheidApril[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[27],\"O\")+COUNTIF(AanwezigheidApril[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[28],\"O\")+COUNTIF(AanwezigheidApril[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidApril[29],\"O\")+COUNTIF(AanwezigheidApril[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidApril[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidApril[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidApril[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidApril[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidApril[Dagen afwezig])","v":0}]

{"sheet":"Mei","index":11,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,5,1)","v":"2013-05-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,1),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,2),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,3),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,4),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,5),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,6),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,7),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,8),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,9),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,10),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,11),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,12),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,13),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,14),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,15),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,16),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,17),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,18),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,19),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,20),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,21),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,22),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,23),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,24),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,25),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,26),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,27),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,28),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,29),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,30),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,5,31),1),\"aaa\")","v":"vr"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMei[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMei[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMei[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMei[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMei[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMei[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMei[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMei[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidMei[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidMei[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidMei[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidMei[1],\"O\")+COUNTIF(AanwezigheidMei[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[2],\"O\")+COUNTIF(AanwezigheidMei[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[3],\"O\")+COUNTIF(AanwezigheidMei[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[4],\"O\")+COUNTIF(AanwezigheidMei[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[5],\"O\")+COUNTIF(AanwezigheidMei[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[6],\"O\")+COUNTIF(AanwezigheidMei[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[7],\"O\")+COUNTIF(AanwezigheidMei[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[8],\"O\")+COUNTIF(AanwezigheidMei[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[9],\"O\")+COUNTIF(AanwezigheidMei[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[10],\"O\")+COUNTIF(AanwezigheidMei[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[11],\"O\")+COUNTIF(AanwezigheidMei[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[12],\"O\")+COUNTIF(AanwezigheidMei[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[13],\"O\")+COUNTIF(AanwezigheidMei[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[14],\"O\")+COUNTIF(AanwezigheidMei[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[15],\"O\")+COUNTIF(AanwezigheidMei[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[16],\"O\")+COUNTIF(AanwezigheidMei[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[17],\"O\")+COUNTIF(AanwezigheidMei[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[18],\"O\")+COUNTIF(AanwezigheidMei[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[19],\"O\")+COUNTIF(AanwezigheidMei[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[20],\"O\")+COUNTIF(AanwezigheidMei[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[21],\"O\")+COUNTIF(AanwezigheidMei[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[22],\"O\")+COUNTIF(AanwezigheidMei[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[23],\"O\")+COUNTIF(AanwezigheidMei[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[24],\"O\")+COUNTIF(AanwezigheidMei[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[25],\"O\")+COUNTIF(AanwezigheidMei[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[26],\"O\")+COUNTIF(AanwezigheidMei[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[27],\"O\")+COUNTIF(AanwezigheidMei[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[28],\"O\")+COUNTIF(AanwezigheidMei[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidMei[29],\"O\")+COUNTIF(AanwezigheidMei[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidMei[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMei[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMei[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMei[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidMei[Dagen afwezig])","v":0}]

{"sheet":"Juni","index":12,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,6,1)","v":"2013-06-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,1),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,2),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,3),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,4),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,5),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,6),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,7),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,8),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,9),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,10),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,11),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,12),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,13),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,14),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,15),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,16),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,17),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,18),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,19),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,20),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,21),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,22),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,23),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,24),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,25),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,26),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,27),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,28),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,29),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,6,30),1),\"aaa\")","v":"zo"},null,"Totalen"]
[null,"Student-id","Naam student","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"," ","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuni[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuni[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuni[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuni[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuni[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuni[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuni[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuni[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuni[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuni[[#This Row],[1]:[ ]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuni[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidJuni[1],\"O\")+COUNTIF(AanwezigheidJuni[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[2],\"O\")+COUNTIF(AanwezigheidJuni[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[3],\"O\")+COUNTIF(AanwezigheidJuni[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[4],\"O\")+COUNTIF(AanwezigheidJuni[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[5],\"O\")+COUNTIF(AanwezigheidJuni[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[6],\"O\")+COUNTIF(AanwezigheidJuni[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[7],\"O\")+COUNTIF(AanwezigheidJuni[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[8],\"O\")+COUNTIF(AanwezigheidJuni[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[9],\"O\")+COUNTIF(AanwezigheidJuni[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[10],\"O\")+COUNTIF(AanwezigheidJuni[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[11],\"O\")+COUNTIF(AanwezigheidJuni[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[12],\"O\")+COUNTIF(AanwezigheidJuni[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[13],\"O\")+COUNTIF(AanwezigheidJuni[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[14],\"O\")+COUNTIF(AanwezigheidJuni[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[15],\"O\")+COUNTIF(AanwezigheidJuni[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[16],\"O\")+COUNTIF(AanwezigheidJuni[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[17],\"O\")+COUNTIF(AanwezigheidJuni[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[18],\"O\")+COUNTIF(AanwezigheidJuni[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[19],\"O\")+COUNTIF(AanwezigheidJuni[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[20],\"O\")+COUNTIF(AanwezigheidJuni[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[21],\"O\")+COUNTIF(AanwezigheidJuni[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[22],\"O\")+COUNTIF(AanwezigheidJuni[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[23],\"O\")+COUNTIF(AanwezigheidJuni[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[24],\"O\")+COUNTIF(AanwezigheidJuni[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[25],\"O\")+COUNTIF(AanwezigheidJuni[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[26],\"O\")+COUNTIF(AanwezigheidJuni[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[27],\"O\")+COUNTIF(AanwezigheidJuni[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[28],\"O\")+COUNTIF(AanwezigheidJuni[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuni[29],\"O\")+COUNTIF(AanwezigheidJuni[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidJuni[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuni[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuni[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuni[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuni[Dagen afwezig])","v":0}]

{"sheet":"Juli","index":13,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["AANWEZIGHEIDSOVERZICHT STUDENTEN",{"$nulls":36},"Begin studiejaar:",{"$f":"Kalenderjaar","v":2012}]
[]
[null,null,{"$f":"TekstKleurcode","v":"VERKLARING KLEUREN "},{"$f":"Code1","v":"T"},{"$f":"TekstCode1","v":"Te laat"},null,null,{"$f":"Code2","v":"G"},{"$f":"TekstCode2","v":"Geoorloofd"},null,null,{"$f":"Code3","v":"O"},{"$f":"TekstCode3","v":"Ongeoorloofd"},null,null,{"$f":"Code4","v":"A"},{"$f":"TekstCode4","v":"Aanwezig"},null,null,{"$f":"Code5","v":"L"},{"$f":"TekstCode5","v":"Lesvrij"}]
[]
[null,{"$f":"DATE(Kalenderjaar+1,7,1)","v":"2013-07-01"},null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,1),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,2),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,3),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,4),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,5),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,6),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,7),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,8),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,9),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,10),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,11),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,12),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,13),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,14),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,15),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,16),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,17),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,18),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,19),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,20),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,21),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,22),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,23),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,24),1),\"aaa\")","v":"wo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,25),1),\"aaa\")","v":"do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,26),1),\"aaa\")","v":"vr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,27),1),\"aaa\")","v":"za"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,28),1),\"aaa\")","v":"zo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,29),1),\"aaa\")","v":"ma"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,30),1),\"aaa\")","v":"di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjaar+1,7,31),1),\"aaa\")","v":"wo"},"Totalen"]
[null,"Student-id","Naam student","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","T","G","O","A","Dagen afwezig"]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuli[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuli[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuli[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuli[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuli[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuli[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuli[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuli[[#This Row],[G]:[O]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(AanwezigheidJuli[[#This Row],[Student-id]],Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code1)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code2)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code3)","v":0},{"$f":"COUNTIF(AanwezigheidJuli[[#This Row],[1]:[31]],Code4)","v":0},{"$f":"SUM(AanwezigheidJuli[[#This Row],[G]:[O]])","v":0}]
[null,null,"Totaal aantal dagen afwezig",{"$f":"COUNTIF(AanwezigheidJuli[1],\"O\")+COUNTIF(AanwezigheidJuli[1],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[2],\"O\")+COUNTIF(AanwezigheidJuli[2],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[3],\"O\")+COUNTIF(AanwezigheidJuli[3],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[4],\"O\")+COUNTIF(AanwezigheidJuli[4],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[5],\"O\")+COUNTIF(AanwezigheidJuli[5],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[6],\"O\")+COUNTIF(AanwezigheidJuli[6],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[7],\"O\")+COUNTIF(AanwezigheidJuli[7],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[8],\"O\")+COUNTIF(AanwezigheidJuli[8],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[9],\"O\")+COUNTIF(AanwezigheidJuli[9],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[10],\"O\")+COUNTIF(AanwezigheidJuli[10],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[11],\"O\")+COUNTIF(AanwezigheidJuli[11],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[12],\"O\")+COUNTIF(AanwezigheidJuli[12],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[13],\"O\")+COUNTIF(AanwezigheidJuli[13],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[14],\"O\")+COUNTIF(AanwezigheidJuli[14],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[15],\"O\")+COUNTIF(AanwezigheidJuli[15],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[16],\"O\")+COUNTIF(AanwezigheidJuli[16],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[17],\"O\")+COUNTIF(AanwezigheidJuli[17],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[18],\"O\")+COUNTIF(AanwezigheidJuli[18],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[19],\"O\")+COUNTIF(AanwezigheidJuli[19],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[20],\"O\")+COUNTIF(AanwezigheidJuli[20],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[21],\"O\")+COUNTIF(AanwezigheidJuli[21],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[22],\"O\")+COUNTIF(AanwezigheidJuli[22],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[23],\"O\")+COUNTIF(AanwezigheidJuli[23],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[24],\"O\")+COUNTIF(AanwezigheidJuli[24],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[25],\"O\")+COUNTIF(AanwezigheidJuli[25],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[26],\"O\")+COUNTIF(AanwezigheidJuli[26],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[27],\"O\")+COUNTIF(AanwezigheidJuli[27],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[28],\"O\")+COUNTIF(AanwezigheidJuli[28],\"G\")","v":0},{"$f":"COUNTIF(AanwezigheidJuli[29],\"O\")+COUNTIF(AanwezigheidJuli[29],\"G\")","v":0},null,null,{"$f":"SUBTOTAL(109,AanwezigheidJuli[T])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuli[G])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuli[O])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuli[A])","v":0},{"$f":"SUBTOTAL(109,AanwezigheidJuli[Dagen afwezig])","v":0}]

{"sheet":"Aanwezigheidsrapport student","index":14,"n_rows":40,"n_cols":37,"rows_kept":40,"merged":[[2,3,2,14],[2,15,2,17],[2,18,2,21],[2,22,2,29],[2,30,2,31],[2,32,2,35],[3,1,3,2],[3,3,3,14],[3,15,3,17],[3,18,3,21],[3,22,3,29],[3,30,3,31],[3,32,3,35],[4,1,4,9],[4,10,4,21],[4,22,4,29],[4,30,4,36],[5,1,5,9],[5,10,5,21],[5,22,5,29],[5,30,5,36],[6,1,6,9],[6,10,6,21],[6,22,6,29],[6,30,6,36],[7,1,7,9],[7,10,7,21],[7,22,7,29],[7,30,7,36],[8,1,8,9],[8,10,8,21],[8,22,8,29],[8,30,8,36],[9,1,9,9],[9,10,9,21],[9,22,9,29],[9,30,9,36],[13,1,14,32],[13,33,13,36],[15,1,16,1],[15,33,16,33],[15,34,16,34],[15,35,16,35],[15,36,16,36],[17,1,18,1],[17,33,18,33],[17,34,18,34],[17,35,18,35],[17,36,18,36],[19,1,20,1],[19,33,20,33],[19,34,20,34],[19,35,20,35],[19,36,20,36],[21,1,22,1],[21,33,22,33],[21,34,22,34],[21,35,22,35],[21,36,22,36],[23,1,24,1],[23,33,24,33],[23,34,24,34],[23,35,24,35],[23,36,24,36],[25,1,26,1],[25,33,26,33],[25,34,26,34],[25,35,26,35],[25,36,26,36],[27,1,28,1],[27,33,28,33],[27,34,28,34],[27,35,28,35],[27,36,28,36],[29,1,30,1],[29,33,30,33],[29,34,30,34],[29,35,30,35],[29,36,30,36],[31,1,32,1],[31,33,32,33],[31,34,32,34],[31,35,32,35],[31,36,32,36],[33,1,34,1],[33,33,34,33],[33,34,34,34],[33,35,34,35],[33,36,34,36],[35,1,36,1],[35,33,36,33],[35,34,36,34],[35,35,36,35],[35,36,36,36],[37,1,38,1],[37,33,38,33],[37,34,38,34],[37,35,38,35],[37,36,38,36],[39,30,39,32]]}
[{"$f":"\"Aanwezigheidsoverzicht voor \"","v":"Aanwezigheidsoverzicht voor "},{"$nulls":7},{"$f":"D4","v":"Ties Arts"}]
[]
[null,"Student-id",null,"Naam student",{"$nulls":11},"Geslacht",null,null,"Geboortedatum",{"$nulls":3},"Onderwijsinstelling",{"$nulls":7},"Jaar",null,"Docent",{"$nulls":3},"Lokaal"]
[null,"S001",null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,18,FALSE),\"\")","v":"Ties Arts"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,4,FALSE),\"\")","v":"M"},null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,5,FALSE),\"\")","v":"1997-03-28"},{"$nulls":3},"Kunstacademie ",{"$nulls":7},7,null,"Dick Beekman",{"$nulls":3},123]
[null,"Naam ouder of voogd 1",{"$nulls":8},"Relatie",{"$nulls":11},"Telefoonnummer werk",{"$nulls":7},"Telefoonnummer privé"]
[null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,6,FALSE),\"\")","v":"Pascaline Arts"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,7,FALSE),\"\")","v":"Moeder"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,8,FALSE),\"\")","v":1235550134},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,9,FALSE),\"\")","v":2345550134}]
[null,"Naam ouder of voogd 2",{"$nulls":8},"Relatie",{"$nulls":11},"Telefoonnummer werk",{"$nulls":7},"Telefoonnummer privé"]
[null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,10,FALSE),\"\")","v":"Richard Arts"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,11,FALSE),\"\")","v":"Vader"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,12,FALSE),\"\")","v":1235550134},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,13,FALSE),\"\")","v":2345550134}]
[null,"Contactpersoon bij noodgeval",{"$nulls":8},"Relatie",{"$nulls":11},"Telefoonnummer werk",{"$nulls":7},"Telefoonnummer privé"]
[null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,14,FALSE),\"\")","v":"Jeroen Cool"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,15,FALSE),\"\")","v":"Grootvader"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,16,FALSE),\"\")","v":7895550189},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,Studentenlijst!$B$4:$S$8,17,FALSE),\"\")","v":7895550134}]
[]
[null,{"$f":"Augustus!C3","v":"VERKLARING KLEUREN "},{"$f":"Augustus!D3","v":"T"},{"$f":"Augustus!E3","v":"Te laat"},null,null,{"$f":"Augustus!H3","v":"G"},{"$f":"Augustus!I3","v":"Geoorloofd"},null,null,{"$f":"Augustus!L3","v":"O"},{"$f":"Augustus!M3","v":"Ongeoorloofd"},{"$nulls":3},{"$f":"Augustus!P3","v":"A"},{"$f":"Augustus!Q3","v":"Aanwezig"},null,null,{"$f":"Augustus!T3","v":"L"},{"$f":"Augustus!U3","v":"Lesvrij"}]
[]
[null,"Aanwezigheid",{"$nulls":31},"Totalen aanwezigheid"]
[{"$nulls":33},"T","G","O","A"]
[null,"Augustus",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,{"$f":"COUNTIF($D17:$AH17,Code1)","v":2},{"$f":"COUNTIF($D17:$AH17,Code2)","v":1},{"$f":"COUNTIF($D17:$AH17,Code3)","v":0},{"$f":"COUNTIF($D17:$AH17,Code4)","v":19}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],3,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],4,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],5,FALSE),\"\")","v":"T"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],6,FALSE),\"\")","v":"T"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],7,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],8,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],9,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],10,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],11,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],12,FALSE),\"\")","v":"G"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],13,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],14,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],15,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],16,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],17,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],18,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],19,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],20,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],21,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],22,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],23,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],24,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],25,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],26,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],27,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],28,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],29,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],30,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],31,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],32,FALSE),\"\")","v":"A"},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidAugustus[],33,FALSE),\"\")","v":"A"}]
[null,"September",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,null,{"$f":"COUNTIF($D19:$AH19,Code1)","v":0},{"$f":"COUNTIF($D19:$AH19,Code2)","v":0},{"$f":"COUNTIF($D19:$AH19,Code3)","v":0},{"$f":"COUNTIF($D19:$AH19,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidSeptember[],32,FALSE),\"\")","v":""}]
[null,"Oktober",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,{"$f":"COUNTIF($D21:$AH21,Code1)","v":0},{"$f":"COUNTIF($D21:$AH21,Code2)","v":0},{"$f":"COUNTIF($D21:$AH21,Code3)","v":0},{"$f":"COUNTIF($D21:$AH21,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidOktober[],33,FALSE),\"\")","v":""}]
[null,"November",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,null,{"$f":"COUNTIF($D23:$AH23,Code1)","v":0},{"$f":"COUNTIF($D23:$AH23,Code2)","v":0},{"$f":"COUNTIF($D23:$AH23,Code3)","v":0},{"$f":"COUNTIF($D23:$AH23,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidNovember[],32,FALSE),\"\")","v":""}]
[null,"December",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,{"$f":"COUNTIF($D25:$AH25,Code1)","v":0},{"$f":"COUNTIF($D25:$AH25,Code2)","v":0},{"$f":"COUNTIF($D25:$AH25,Code3)","v":0},{"$f":"COUNTIF($D25:$AH25,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidDecember[],33,FALSE),\"\")","v":""}]
[null,"Januari",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,{"$f":"COUNTIF($D27:$AH27,Code1)","v":0},{"$f":"COUNTIF($D27:$AH27,Code2)","v":0},{"$f":"COUNTIF($D27:$AH27,Code3)","v":0},{"$f":"COUNTIF($D27:$AH27,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJanuari[],33,FALSE),\"\")","v":""}]
[null,"Februari",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,null,null,{"$f":"COUNTIF($D29:$AH29,Code1)","v":0},{"$f":"COUNTIF($D29:$AH29,Code2)","v":0},{"$f":"COUNTIF($D29:$AH29,Code3)","v":0},{"$f":"COUNTIF($D29:$AH29,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidFebruari[],31,FALSE),\"\")","v":""}]
[null,"Maart",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,{"$f":"COUNTIF($D31:$AH31,Code1)","v":0},{"$f":"COUNTIF($D31:$AH31,Code2)","v":0},{"$f":"COUNTIF($D31:$AH31,Code3)","v":0},{"$f":"COUNTIF($D31:$AH31,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMaart[],33,FALSE),\"\")","v":""}]
[null,"April",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,null,{"$f":"COUNTIF($D33:$AH33,Code1)","v":0},{"$f":"COUNTIF($D33:$AH33,Code2)","v":0},{"$f":"COUNTIF($D33:$AH33,Code3)","v":0},{"$f":"COUNTIF($D33:$AH33,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidApril[],32,FALSE),\"\")","v":""}]
[null,"Mei",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,{"$f":"COUNTIF($D35:$AH35,Code1)","v":0},{"$f":"COUNTIF($D35:$AH35,Code2)","v":0},{"$f":"COUNTIF($D35:$AH35,Code3)","v":0},{"$f":"COUNTIF($D35:$AH35,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidMei[],33,FALSE),\"\")","v":""}]
[null,"Juni",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,null,{"$f":"COUNTIF($D37:$AH37,Code1)","v":0},{"$f":"COUNTIF($D37:$AH37,Code2)","v":0},{"$f":"COUNTIF($D37:$AH37,Code3)","v":0},{"$f":"COUNTIF($D37:$AH37,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuni[],32,FALSE),\"\")","v":""}]
[null,"Juli",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,{"$f":"COUNTIF($D39:$AH39,Code1)","v":0},{"$f":"COUNTIF($D39:$AH39,Code2)","v":0},{"$f":"COUNTIF($D39:$AH39,Code3)","v":0},{"$f":"COUNTIF($D39:$AH39,Code4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(StudentOpzoeken,AanwezigheidJuli[],33,FALSE),\"\")","v":""}]
[{"$nulls":30},"Totalen",null,null,{"$f":"SUM(AH16:AH39)","v":2},{"$f":"SUM(AI16:AI39)","v":1},{"$f":"SUM(AJ16:AJ39)","v":0},{"$f":"SUM(AK16:AK39)","v":19}]