{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Input a Class List","Random Name Generator"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input a Class List","index":1,"n_rows":63,"n_cols":29,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,17]]}
["For each class you have, type the names of the students in the corresponding column. Give each class a name."]
[]
[]
[null,"Class 1",null,null,"Class 2",null,null,"Class 3",null,null,"Class 4",null,null,"Class 5",null,null,"Class 6",null,null,"Class 7",null,null,"Class 8",null,null,"Class 9",null,null,"Class 10"]
[null,"Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name"]
[1,"Simon",null,1,"Sean",null,1,"Lily",null,1,"Jack",null,1,"Tom",null,1,"Rose",null,1,"Paul",null,1,"James",null,1,"Dawn",null,1,"Pete"]
[{"$f":"A6+1","v":2},"Kylie",null,{"$f":"D6+1","v":2},"Billy",null,{"$f":"G6+1","v":2},"James",null,{"$f":"J6+1","v":2},"Hugh",null,{"$f":"M6+1","v":2},"Amelia",null,{"$f":"P6+1","v":2},"Mat",null,{"$f":"S6+1","v":2},"Dave",null,{"$f":"V6+1","v":2},"Joan",null,{"$f":"Y6+1","v":2},"Chris T",null,{"$f":"AB6+1","v":2},"George"]
[{"$f":"A7+1","v":3},"Cheryl",null,{"$f":"D7+1","v":3},"Sophia",null,{"$f":"G7+1","v":3},"Sam R",null,{"$f":"J7+1","v":3},"Emma",null,{"$f":"M7+1","v":3},"Esther",null,{"$f":"P7+1","v":3},"Gillian",null,{"$f":"S7+1","v":3},"Jessica",null,{"$f":"V7+1","v":3},"Kim",null,{"$f":"Y7+1","v":3},"Jon",null,{"$f":"AB7+1","v":3},"Pauline"]
[4,"Stephen",null,4,"Joseline",null,4,"Samantha",null,4,"William",null,4,"Keith",null,4,"Patrick",null,4,"Jessie",null,4,"Bethany",null,4,"Clive",null,4,"Kate"]
[5,"James",null,5,"Edward",null,5,"Tim",null,5,"Godfrey",null,5,"Jack",null,5,null,null,5,"Kevin",null,5,"Izzy",null,5,"Jane",null,5,"Kirsty"]
[6,"Tom F",null,6,null,null,6,"Dan",null,6,"Isabel",null,6,"Steve",null,6,null,null,6,"Julie",null,6,"Catriona",null,6,"Chris G",null,6,"Elaine"]
[7,"Jamie",null,7,null,null,7,"Sam P",null,7,"Joan",null,7,null,null,7,null,null,7,null,null,7,"Johnny",null,7,null,null,7,"Georgie"]
[8,"Tom T",null,8,null,null,8,null,null,8,"Bob",null,8,null,null,8,null,null,8,null,null,8,"William",null,8,null,null,8,"Janet"]
[9,null,null,9,null,null,9,null,null,9,"Janice",null,9,null,null,9,null,null,9,null,null,9,null,null,9,null,null,9,"Sarah"]
[10,null,null,10,null,null,10,null,null,10,null,null,10,null,null,10,null,null,10,null,null,10,null,null,10,null,null,10]
[11,null,null,11,null,null,11,null,null,11,null,null,11,null,null,11,null,null,11,null,null,11,null,null,11,null,null,11]
[12,null,null,12,null,null,12,null,null,12,null,null,12,null,null,12,null,null,12,null,null,12,null,null,12,null,null,12]
[13,null,null,13,null,null,13,null,null,13,null,null,13,null,null,13,null,null,13,null,null,13,null,null,13,null,null,13]
[14,null,null,14,null,null,14,null,null,14,null,null,14,null,null,14,null,null,14,null,null,14,null,null,14,null,null,14]
[15,null,null,15,null,null,15,null,null,15,null,null,15,null,null,15,null,null,15,null,null,15,null,null,15,null,null,15]
[16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16]
[17,null,null,17,null,null,17,null,null,17,null,null,17,null,null,17,null,null,17,null,null,17,null,null,17,null,null,17]
[18,null,null,18,null,null,18,null,null,18,null,null,18,null,null,18,null,null,18,null,null,18,null,null,18,null,null,18]
[19,null,null,19,null,null,19,null,null,19,null,null,19,null,null,19,null,null,19,null,null,19,null,null,19,null,null,19]
[20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20]
[21,null,null,21,null,null,21,null,null,21,null,null,21,null,null,21,null,null,21,null,null,21,null,null,21,null,null,21]
[22,null,null,22,null,null,22,null,null,22,null,null,22,null,null,22,null,null,22,null,null,22,null,null,22,null,null,22]
[23,null,null,23,null,null,23,null,null,23,null,null,23,null,null,23,null,null,23,null,null,23,null,null,23,null,null,23]
[24,null,null,24,null,null,24,null,null,24,null,null,24,null,null,24,null,null,24,null,null,24,null,null,24,null,null,24]
[25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25]
[26,null,null,26,null,null,26,null,null,26,null,null,26,null,null,26,null,null,26,null,null,26,null,null,26,null,null,26]
[27,null,null,27,null,null,27,null,null,27,null,null,27,null,null,27,null,null,27,null,null,27,null,null,27,null,null,27]
[28,null,null,28,null,null,28,null,null,28,null,null,28,null,null,28,null,null,28,null,null,28,null,null,28,null,null,28]
[29,null,null,29,null,null,29,null,null,29,null,null,29,null,null,29,null,null,29,null,null,29,null,null,29,null,null,29]
[30,null,null,30,null,null,30,null,null,30,null,null,30,null,null,30,null,null,30,null,null,30,null,null,30,null,null,30]
[31,null,null,31,null,null,31,null,null,31,null,null,31,null,null,31,null,null,31,null,null,31,null,null,31,null,null,31]
[32,null,null,32,null,null,32,null,null,32,null,null,32,null,null,32,null,null,32,null,null,32,null,null,32,null,null,32]
[33,null,null,33,null,null,33,null,null,33,null,null,33,null,null,33,null,null,33,null,null,33,null,null,33,null,null,33]
[34,null,null,34,null,null,34,null,null,34,null,null,34,null,null,34,null,null,34,null,null,34,null,null,34,null,null,34]
[35,null,null,35,null,null,35,null,null,35,null,null,35,null,null,35,null,null,35,null,null,35,null,null,35,null,null,35]
[36,null,null,36,null,null,36,null,null,36,null,null,36,null,null,36,null,null,36,null,null,36,null,null,36,null,null,36]
[37,null,null,37,null,null,37,null,null,37,null,null,37,null,null,37,null,null,37,null,null,37,null,null,37,null,null,37]
[38,null,null,38,null,null,38,null,null,38,null,null,38,null,null,38,null,null,38,null,null,38,null,null,38,null,null,38]
[39,null,null,39,null,null,39,null,null,39,null,null,39,null,null,39,null,null,39,null,null,39,null,null,39,null,null,39]
[40,null,null,40,null,null,40,null,null,40,null,null,40,null,null,40,null,null,40,null,null,40,null,null,40,null,null,40]
[{"$f":"INT(RAND()*(A47)+1)","v":1},{"$f":"VLOOKUP(A46,A6:B45,2)","v":"Simon"},null,{"$f":"INT(RAND()*(D47)+1)","v":4},{"$f":"VLOOKUP(D46,D6:E45,2)","v":"Joseline"},null,{"$f":"INT(RAND()*(G47)+1)","v":3},{"$f":"VLOOKUP(G46,G6:H45,2)","v":"Sam R"},null,{"$f":"INT(RAND()*(J47)+1)","v":6},{"$f":"VLOOKUP(J46,J6:K45,2)","v":"Isabel"},null,{"$f":"INT(RAND()*(M47)+1)","v":4},{"$f":"VLOOKUP(M46,M6:N45,2)","v":"Keith"},null,{"$f":"INT(RAND()*(P47)+1)","v":2},{"$f":"VLOOKUP(P46,P6:Q45,2)","v":"Mat"},null,{"$f":"INT(RAND()*(S47)+1)","v":6},{"$f":"VLOOKUP(S46,S6:T45,2)","v":"Julie"},null,{"$f":"INT(RAND()*(V47)+1)","v":7},{"$f":"VLOOKUP(V46,V6:W45,2)","v":"Johnny"},null,{"$f":"INT(RAND()*(Y47)+1)","v":5},{"$f":"VLOOKUP(Y46,Y6:Z45,2)","v":"Jane"},null,{"$f":"INT(RAND()*(AB47)+1)","v":6},{"$f":"VLOOKUP(AB46,AB6:AC45,2)","v":"Elaine"}]
[{"$f":"COUNTA(B6:B45)","v":8},null,null,{"$f":"COUNTA(E6:E45)","v":5},null,null,{"$f":"COUNTA(H6:H45)","v":7},null,null,{"$f":"COUNTA(K6:K45)","v":9},null,null,{"$f":"COUNTA(N6:N45)","v":6},null,null,{"$f":"COUNTA(Q6:Q45)","v":4},null,null,{"$f":"COUNTA(T6:T45)","v":6},null,null,{"$f":"COUNTA(W6:W45)","v":8},null,null,{"$f":"COUNTA(Z6:Z45)","v":6},null,null,{"$f":"COUNTA(AC6:AC45)","v":9}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B4","v":"Class 1"}]
[null,{"$f":"E4","v":"Class 2"}]
[null,{"$f":"H4","v":"Class 3"}]
[null,{"$f":"K4","v":"Class 4"}]
[null,{"$f":"N4","v":"Class 5"}]
[null,{"$f":"Q4","v":"Class 6"}]
[null,{"$f":"T4","v":"Class 7"}]
[null,{"$f":"W4","v":"Class 8"}]
[null,{"$f":"Z4","v":"Class 9"}]
[null,{"$f":"AC4","v":"Class 10"}]

{"sheet":"Random Name Generator","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,3,0,10]]}
[null,null,null,{"$f":"L14","v":"Simon"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1]
[]
[null,null,null,{"$f":"'Input a Class List'!B46","v":"Simon"}]
[null,null,null,{"$f":"'Input a Class List'!E46","v":"Joseline"},null,null,null,null,null,null,null,{"$f":"IF($D$11=1,D13,IF($D$11=2,D14,IF($D$11=3,D15,IF($D$11=4,D16,IF($D$11=5,D17,IF($D$11=6,D18,IF($D$11=7,D19,IF($D$11=8,D20,IF($D$11=9,D21,IF($D$11=10,D22))))))))))","v":"Simon"}]
[null,null,null,{"$f":"'Input a Class List'!H46","v":"Sam R"}]
[null,null,null,{"$f":"'Input a Class List'!K46","v":"Isabel"}]
[null,null,null,{"$f":"'Input a Class List'!N46","v":"Keith"}]
[null,null,null,{"$f":"'Input a Class List'!Q46","v":"Mat"}]
[null,null,null,{"$f":"'Input a Class List'!T46","v":"Julie"}]
[null,null,null,{"$f":"'Input a Class List'!W46","v":"Johnny"}]
[null,null,null,{"$f":"'Input a Class List'!Z46","v":"Jane"}]
[null,null,null,{"$f":"'Input a Class List'!AC46","v":"Elaine"}]