{"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":"IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-ROW(クラスの選択)))))","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":"IF(COLUMNS(ClassNames[#Data])>COUNTA(ClassNames[#Headers]),\"\",INDIRECT(CELL(\"address\",INDEX(ClassNames[#All],1,ROW()+1-ROW(クラスの選択)))))","v":"数学"},{"$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(クラスの選択)))))","v":"理科"},{"$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(クラスの選択)))))","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,"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"]