{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["学生一覧","クラスの名簿","学生の詳細"],"not_rendered":{"images":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"学生一覧","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[1,2,2,3],[1,4,1,11],[2,4,2,11],[6,12,8,16]]}
[]
[null,null,"学生リスト",null,"クラスの名簿を表示"]
[{"$nulls":4},"学生の詳細を表示"]
[null,null,"学生の名前","メール","自宅電話","携帯電話","DOB","緊急連絡先","緊急電話番号","医師","医師の電話番号","  "]
[null,null,"名前 1","メール アドレス","自宅電話番号","携帯電話","日付","連絡先 1","緊急電話番号","医師 1","医師の電話番号"]
[null,null,"名前 2","メール アドレス","自宅電話番号","携帯電話","日付","連絡先 2","緊急電話番号","医師 2","医師の電話番号"]
[null,null,"名前 3","メール アドレス","自宅電話番号","携帯電話","日付","連絡先 3","緊急電話番号","医師 3","医師の電話番号",null,"ヒント: 他の学生を追加するには、テーブルの最後のセル内で Tab キーを押します。"]
[null,null,"名前 4","メール アドレス","自宅電話番号","携帯電話","日付","連絡先 4","緊急電話番号","医師 4","医師の電話番号"]

{"sheet":"クラスの名簿","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[1,2,2,2],[1,3,2,3],[1,4,1,6],[2,4,2,6]]}
[]
[null,null,"クラスの名簿","Graphic Design Institute","学生リストを表示"]
[{"$nulls":4},"学生の詳細を表示"]
[null,null,"科目","コース名","開始日","日付"]
[null,null,"講師","講師 1","終了日","日付"]
[null,null,"登録した学生",{"$f":"COUNTA(StudentRoster[学生の名前])","v":4}]
[]
[null,null,"学生の名前","メール","自宅電話","携帯電話","  "]
[null,null,"名前 1",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],2),\"\")","v":"メール アドレス"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],3),\"\")","v":"自宅電話番号"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],4),\"\")","v":"携帯電話"}]
[null,null,"名前 2",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],2),\"\")","v":"メール アドレス"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],3),\"\")","v":"自宅電話番号"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],4),\"\")","v":"携帯電話"}]
[null,null,"名前 3",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],2),\"\")","v":"メール アドレス"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],3),\"\")","v":"自宅電話番号"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],4),\"\")","v":"携帯電話"}]
[null,null,"名前 4",{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],2),\"\")","v":"メール アドレス"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],3),\"\")","v":"自宅電話番号"},{"$f":"IFERROR(VLOOKUP(StudentRoster[[#This Row],[学生の名前]],学生[],4),\"\")","v":"携帯電話"}]

{"sheet":"学生の詳細","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[1,2,2,2],[1,3,1,4],[2,3,2,4],[3,2,3,3]]}
[]
[null,null,"学生の詳細","学生リストを表示"]
[{"$nulls":3},"クラスの名簿を表示"]
[null,null,"ヒント:セル D5 で、ドロップ ダウン リストから学生を選択し、学生の詳細を更新します。"]
[null,null,"学生の名前","名前 1"]
[null,null,"メール",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],2,FALSE),\"\")","v":"メール アドレス"}]
[null,null,"自宅電話",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],3,FALSE),\"\")","v":"自宅電話番号"}]
[null,null,"携帯電話",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],4,FALSE),\"\")","v":"携帯電話"}]
[null,null,"DOB",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],5,FALSE),\"\")","v":"日付"}]
[null,null,"緊急連絡先",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],6,FALSE),\"\")","v":"連絡先 1"}]
[null,null,"緊急電話番号",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],7,FALSE),\"\")","v":"緊急電話番号"}]
[null,null,"医師",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],8,FALSE),\"\")","v":"医師 1"}]
[null,null,"医師の電話番号",{"$f":"IFERROR(VLOOKUP(StudentName,学生[],9,FALSE),\"\")","v":"医師の電話番号"}]