{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Studentenlijst","Rooster","Details studenten"],"not_rendered":{"images":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Studentenlijst","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[1,2,2,3],[1,4,1,11],[2,4,2,11],[6,12,8,16]]}
[]
[null,null,"Studentenlijst",null,"GA NAAR ROOSTER"]
[{"$nulls":4},"GA NAAR DETAILS STUDENTEN"]
[null,null,"NAAM STUDENT","E-MAIL","TELEFOON THUIS","MOBIELE TELEFOON","GEBOORTEDATUM","CONTACTPERSOON IN NOODGEVALLEN","TELEFOONNUMMER VOOR NOODGEVALLEN","ARTS","TELEFOONNUMMER ARTS","  "]
[null,null,"Naam 1","E-mailadres","Vaste telefoon","Mobiele telefoon","Datum","Contactpersoon 1","Telefoonnummer voor noodgevallen","Arts 1","Telefoonnummer arts"]
[null,null,"Naam 2","E-mailadres","Vaste telefoon","Mobiele telefoon","Datum","Contactpersoon 2","Telefoonnummer voor noodgevallen","Arts 2","Telefoonnummer arts"]
[null,null,"Naam 3","E-mailadres","Vaste telefoon","Mobiele telefoon","Datum","Contactpersoon 3","Telefoonnummer voor noodgevallen","Arts 3","Telefoonnummer arts",null,"Tip: als u meer studenten wilt toevoegen, drukt u in de laatste cel van de tabel op Tab."]
[null,null,"Naam 4","E-mailadres","Vaste telefoon","Mobiele telefoon","Datum","Contactpersoon 4","Telefoonnummer voor noodgevallen","Arts 4","Telefoonnummer arts"]

{"sheet":"Rooster","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[1,2,2,2],[1,3,2,3],[1,4,1,6],[2,4,2,6]]}
[]
[null,null,"Klassenrooster","Instituut voor grafisch ontwerpen","GA NAAR STUDENTENLIJST"]
[{"$nulls":4},"GA NAAR DETAILS STUDENTEN"]
[null,null,"CURSUS","Naam cursus","BEGINDATUM","Datum"]
[null,null,"DOCENT","Docent 1","EINDDATUM","Datum"]
[null,null,"GEREGISTREERDE STUDENTEN",{"$f":"COUNTA(StudentRoster[NAAM STUDENT])","v":4}]
[]
[null,null,"NAAM STUDENT","E-MAIL","TELEFOON THUIS","MOBIELE TELEFOON","  "]
[null,null,"Naam 1",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],2),\"\")","v":"E-mailadres"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],3),\"\")","v":"Vaste telefoon"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],4),\"\")","v":"Mobiele telefoon"}]
[null,null,"Naam 2",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],2),\"\")","v":"E-mailadres"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],3),\"\")","v":"Vaste telefoon"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],4),\"\")","v":"Mobiele telefoon"}]
[null,null,"Naam 3",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],2),\"\")","v":"E-mailadres"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],3),\"\")","v":"Vaste telefoon"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],4),\"\")","v":"Mobiele telefoon"}]
[null,null,"Naam 4",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],2),\"\")","v":"E-mailadres"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],3),\"\")","v":"Vaste telefoon"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[NAAM STUDENT]],Studenten[],4),\"\")","v":"Mobiele telefoon"}]

{"sheet":"Details studenten","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[1,2,2,2],[1,3,1,4],[2,3,2,4],[3,2,3,3]]}
[]
[null,null,"Details studenten","GA NAAR STUDENTENLIJST"]
[{"$nulls":3},"GA NAAR ROOSTER"]
[null,null,"TIP: SELECTEER EEN STUDENT IN DE VERVOLGKEUZELIJST IN CEL D5 OM DE DETAILS VAN DE STUDENT BIJ TE WERKEN"]
[null,null,"NAAM STUDENT","Naam 1"]
[null,null,"E-MAIL",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],2,FALSE),\"\")","v":"E-mailadres"}]
[null,null,"TELEFOON THUIS",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],3,FALSE),\"\")","v":"Vaste telefoon"}]
[null,null,"MOBIELE TELEFOON",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],4,FALSE),\"\")","v":"Mobiele telefoon"}]
[null,null,"GEBOORTEDATUM",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],5,FALSE),\"\")","v":"Datum"}]
[null,null,"CONTACTPERSOON IN NOODGEVALLEN",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],6,FALSE),\"\")","v":"Contactpersoon 1"}]
[null,null,"TELEFOONNUMMER VOOR NOODGEVALLEN",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],7,FALSE),\"\")","v":"Telefoonnummer voor noodgevallen"}]
[null,null,"ARTS",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],8,FALSE),\"\")","v":"Arts 1"}]
[null,null,"TELEFOONNUMMER ARTS",{"$f":"IFERROR(VLOOKUP(StudentName,Studenten[],9,FALSE),\"\")","v":"Telefoonnummer arts"}]