{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["学生选择器"],"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":"学生选择器","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,9,4,10],[3,9,3,10]]}
["学生随机发生器"]
["说明：\n\n在单元格 B4:E4 的“名称”表中键入课程名称。\n\n在单元格 B5:E19 的“名称”表中键入学生姓名。\n\n若要向课程添加更多学生，请从单元格 B20 中姓氏下方的单元格开始键入。表将自动扩展以包含新行。\n\n若要向表添加课程，请在单元格 F8 中最后一个表列右侧的单元格中键入课程名称。表将自动扩展以包含新列。"]
["课程\n\n如果要添加更多课程，可以拖动单元格 H8 中“汇总”表右下角的箭头向下展开，或者只是在最后一行下面的行中键入。","“姓名”表",null,null,null,null,"汇总表",null,null,"课程选择"]
["选择课程\n\n单击“课程”下的单元格 J4，单击向下箭头，选择所需的课程，然后在单元格 J9 中输入所需的学生人数。随机发生器将从单元格 J13 开始为您构建一个随机学生列表。","英语","数学","科学","美术",null,"课程","学生人数",null,"课程：",null,"最大学生人数："]
[null,"Emma","Joe","Emily","Dan",null,{"$f":"_xlfn.SINGLE(IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(_xlfn.SINGLE(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"英语"},{"$f":"SUM(N(ClassNames[#Headers]=G5)*N(ClassNames[]>0))","v":15},null,"英语",null,{"$f":"VLOOKUP(ClassChoice,课程[#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(\"address\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"数学"},{"$f":"SUM(N(ClassNames[#Headers]=G6)*N(ClassNames[]>0))","v":5}]
[null,"Ava","Mike","Kyle","Hugo",null,{"$f":"_xlfn.SINGLE(IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(_xlfn.SINGLE(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"科学"},{"$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(\"address\",INDEX(ClassNames[#All],1,ROW()+1-_xlfn.SINGLE(ROW(ClassSelection))))))))","v":"美术"},{"$f":"SUM(N(ClassNames[#Headers]=G8)*N(ClassNames[]>0))","v":3},null,"要选择多少名学生？"]
[null,"Tim","Ricky",null,null,null,null,null,null,8]
[null,"Tom"]
[null,"Jane"]
[null,"Sally",null,null,null,null,null,null,null,"随机发生器"]
[null,"Steve",null,null,null,null,null,null,null,"编号","姓名"]
[null,"George",null,null,null,null,null,null,null,1,"Steve"]
[null,"Billy",null,null,null,null,null,null,null,2,"Billy"]
[null,"Carl",null,null,null,null,null,null,null,3,"Frank"]
[null,"Frank",null,null,null,null,null,null,null,4,"Emma"]
[null,"Jason",null,null,null,null,null,null,null,5,"Ava"]
[null,"John",null,null,null,null,null,null,null,6,"Carl"]
[null,null,null,null,null,null,null,null,null,7,"Tom"]
[null,null,null,null,null,null,null,null,null,8,"Sally"]