{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Student Selector"],"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":"Student Selector","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,9,4,10],[3,9,3,10]]}
["Student Randomiser"]
["Instructions: \n\nType class names in the Name table in cell B4:E4.\n\nType Student names in the Name table in cells B5:E19.\n\nTo add more students to a class, start typing in a cell below the surname in cell B20. The table will automatically expand to include a new row. \n\nTo add a class to the table, type the class name in the cell to the right of the last table column in cell F8. The table will automatically expand to include a new column."]
["Classes\n\nIf you want to add more classes, you can drag the arrow in the bottom-right corner of the Summary table in cell H8 to expand it downward, or just start typing in the row beneath the last row.","Name Table",null,null,null,null,"Summary Table",null,null,"Class selection"]
["Select a class\n\nClick on cell J4 under Class, click the down arrow, select the class you want, then enter the number of students you want in cell J9. The Randomiser will then build a random list of students for you starting in cell J13.","English","Maths","Science","Art",null,"Classes","No. of students",null,"Class:",null,"Maximum students:"]
[null,"Emma","Joe","Emily","Dan",null,{"$f":"IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-ROW(ClassSelection)))))","v":"English"},{"$f":"SUM(N(ClassNames[#Headers]=G5)*N(ClassNames[]>0))","v":15},null,"English",null,{"$f":"VLOOKUP(ClassChoice,Classes[#All],2,FALSE)","v":15}]
[null,"Olivia","Frank","Bob","Hillary",null,{"$f":"IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-ROW(ClassSelection)))))","v":"Maths"},{"$f":"SUM(N(ClassNames[#Headers]=G6)*N(ClassNames[]>0))","v":5}]
[null,"Ava","Mike","Kyle","Hugo",null,{"$f":"IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-ROW(ClassSelection)))))","v":"Science"},{"$f":"SUM(N(ClassNames[#Headers]=G7)*N(ClassNames[]>0))","v":4}]
[null,"Isabella","Jim","Vanessa",null,null,{"$f":"IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-ROW(ClassSelection)))))","v":"Art"},{"$f":"SUM(N(ClassNames[#Headers]=G8)*N(ClassNames[]>0))","v":3},null,"How many students do you want to select?"]
[null,"Tim","Ricky",null,null,null,null,null,null,8]
[null,"Tom"]
[null,"Jane"]
[null,"Sally",null,null,null,null,null,null,null,"Randomiser"]
[null,"Steve",null,null,null,null,null,null,null,"No.","Name"]
[null,"George",null,null,null,null,null,null,null,1,"Olivia"]
[null,"Billy",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,"John",null,null,null,null,null,null,null,6,"Frank"]
[null,null,null,null,null,null,null,null,null,7,"Billy"]
[null,null,null,null,null,null,null,null,null,8,"Sally"]