{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Leerlingen kiezen"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Leerlingen kiezen","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,9,4,10],[3,9,3,10]]}
["Indelingsschema voor leerlingen"]
["Instructies: \n\nTyp de namen van de klassen in de cellen B4:E4 in de namentabel.\n\nTyp de namen van de leerlingen in de cellen B5:E19 in de namentabel.\n\nAls u meer leerlingen aan een klas wilt toevoegen, begint u met typen in een cel onder de laatste naam in cel B20. Er wordt automatisch een nieuwe rij aan de tabel toegevoegd. \n\nAls u een klas aan de tabel wilt toevoegen, typt u de naam van de klas in de cel rechts van de laatste kolom in cel F8. Er wordt automatisch een nieuwe kolom aan de tabel toegevoegd."]
["Lessen\n\nAls u meer klassen wilt toevoegen, kunt u de pijl in de rechteronderhoek van de overzichtstabel in cel H8 naar beneden slepen. U kunt ook beginnen met typen in de rij onder de laatste rij.","Namentabel",null,null,null,null,"Samenvattingstabel",null,null,"Klassenindeling"]
["Een klas selecteren\n\nKlik op cel J4 onder Klas en klik vervolgens op de pijl-omlaag. Selecteer de gewenste klas en voer vervolgens het gewenste aantal leerlingen in in cel J9. Er wordt dan automatisch een willekeurige lijst met leerlingen voor u gegenereerd vanaf cel J13.","Engels","Wiskunde","Natuurkunde","Tekenen",null,"Lessen","Aantal leerlingen",null,"Les:",null,"Maximumaantal leerlingen:"]
[null,"Emma","Joe","Emily","Dan",null,{"$f":"_xlfn.SINGLE(IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(_xlfn.SINGLE(CELL(\"adres\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"Engels"},{"$f":"SUM(N(ClassNames[#Headers]=G5)*N(ClassNames[]>0))","v":15},null,"Engels",null,{"$f":"VLOOKUP(ClassChoice,Lessen[#All],2,FALSE)","v":15}]
[null,"Olivia","Frank","Bob","Hillary",null,{"$f":"_xlfn.SINGLE(IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(_xlfn.SINGLE(CELL(\"adres\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"Wiskunde"},{"$f":"SUM(N(ClassNames[#Headers]=G6)*N(ClassNames[]>0))","v":5}]
[null,"Ava","Maarten","Kyle","Hugo",null,{"$f":"_xlfn.SINGLE(IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(_xlfn.SINGLE(CELL(\"adres\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"Natuurkunde"},{"$f":"SUM(N(ClassNames[#Headers]=G7)*N(ClassNames[]>0))","v":4}]
[null,"Isabella","Jim","Vanessa",null,null,{"$f":"_xlfn.SINGLE(IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(_xlfn.SINGLE(CELL(\"adres\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"Tekenen"},{"$f":"SUM(N(ClassNames[#Headers]=G8)*N(ClassNames[]>0))","v":3},null,"Hoeveel leerlingen wilt u indelen?"]
[null,"Tim","Ricky",null,null,null,null,null,null,8]
[null,"Tom"]
[null,"Jane"]
[null,"Luus",null,null,null,null,null,null,null,"Willekeurig indelen"]
[null,"Steve",null,null,null,null,null,null,null,"#","Naam"]
[null,"George",null,null,null,null,null,null,null,1,"Olivia"]
[null,"Hessel",null,null,null,null,null,null,null,2,"Ava"]
[null,"Carl",null,null,null,null,null,null,null,3,"Tim"]
[null,"Frank",null,null,null,null,null,null,null,4,"Jason"]
[null,"Jason",null,null,null,null,null,null,null,5,"George"]
[null,"Jan",null,null,null,null,null,null,null,6,"Frank"]
[null,null,null,null,null,null,null,null,null,7,"Hessel"]
[null,null,null,null,null,null,null,null,null,8,"Luus"]