{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["試験への割当","名簿"],"not_rendered":{"charts":0,"images":0,"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":"試験への割当","index":0,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,1,7,1]]}
["このシートは、VLOOKUP関数の使用例です。見つけた値に応じて、隣のセルの内容を取り出すことができます。"]
["黄色のセルには、関数で取り出した値が入ります。"]
[null,"科目","割当１","氏名１","割当２","氏名２","割当３","氏名３","割当４","氏名４","割当５","氏名５"]
[null,"数学",1001,{"$f":"VLOOKUP(C4,名簿!$B$4:$C$12,2,FALSE)","v":"西田"},1002,{"$f":"VLOOKUP(E4,名簿!$B$4:$C$12,2,FALSE)","v":"浦田"},1003,{"$f":"VLOOKUP(G4,名簿!$B$4:$C$12,2,FALSE)","v":"本田"}," ",{"$f":"VLOOKUP(I4,名簿!$B$4:$C$12,2,FALSE)","v":" "}," ",{"$f":"VLOOKUP(K4,名簿!$B$4:$C$12,2,FALSE)","v":" "},{"$f":"COUNTIF(C4:L4,\"<>\"&\" \")/2","v":3}]
[null,"理科",1002,{"$f":"VLOOKUP(C5,名簿!$B$4:$C$12,2,FALSE)","v":"浦田"},1003,{"$f":"VLOOKUP(E5,名簿!$B$4:$C$12,2,FALSE)","v":"本田"},1004,{"$f":"VLOOKUP(G5,名簿!$B$4:$C$12,2,FALSE)","v":"池田"},1005,{"$f":"VLOOKUP(I5,名簿!$B$4:$C$12,2,FALSE)","v":"長田"}," ",{"$f":"VLOOKUP(K5,名簿!$B$4:$C$12,2,FALSE)","v":" "},{"$f":"COUNTIF(C5:L5,\"<>\"&\" \")/2","v":4}]
[null,"英語",1003,{"$f":"VLOOKUP(C6,名簿!$B$4:$C$12,2,FALSE)","v":"本田"},1004,{"$f":"VLOOKUP(E6,名簿!$B$4:$C$12,2,FALSE)","v":"池田"},1005,{"$f":"VLOOKUP(G6,名簿!$B$4:$C$12,2,FALSE)","v":"長田"}," ",{"$f":"VLOOKUP(I6,名簿!$B$4:$C$12,2,FALSE)","v":" "}," ",{"$f":"VLOOKUP(K6,名簿!$B$4:$C$12,2,FALSE)","v":" "},{"$f":"COUNTIF(C6:L6,\"<>\"&\" \")/2","v":3}]
[null,"現代国語",1001,{"$f":"VLOOKUP(C7,名簿!$B$4:$C$12,2,FALSE)","v":"西田"},1002,{"$f":"VLOOKUP(E7,名簿!$B$4:$C$12,2,FALSE)","v":"浦田"},1003,{"$f":"VLOOKUP(G7,名簿!$B$4:$C$12,2,FALSE)","v":"本田"},1004,{"$f":"VLOOKUP(I7,名簿!$B$4:$C$12,2,FALSE)","v":"池田"},1005,{"$f":"VLOOKUP(K7,名簿!$B$4:$C$12,2,FALSE)","v":"長田"},{"$f":"COUNTIF(C7:L7,\"<>\"&\" \")/2","v":5}]
[null,null,1006,{"$f":"VLOOKUP(C8,名簿!$B$4:$C$12,2,FALSE)","v":"上田"}," ",{"$f":"VLOOKUP(E8,名簿!$B$4:$C$12,2,FALSE)","v":" "}," ",{"$f":"VLOOKUP(G8,名簿!$B$4:$C$12,2,FALSE)","v":" "}," ",{"$f":"VLOOKUP(I8,名簿!$B$4:$C$12,2,FALSE)","v":" "}," ",{"$f":"VLOOKUP(K8,名簿!$B$4:$C$12,2,FALSE)","v":" "},{"$f":"COUNTIF(C8:L8,\"<>\"&\" \")/2","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M4:M8)","v":16}]

{"sheet":"名簿","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["このシートは、VnLOOKUP関数の使用例です。VLOOKUPとほぼ同じ動作をしますが、n番目にみつけた値で動作します。"]
["黄色のセルには、関数で取り出した値が入ります。"]
[null,"学籍番号","名前","研究室","担当科目１","担当科目２","担当科目３","担当科目４"]
[null,1001,"西田","情報・上島",{"$f":"vnlookup($B4,試験への割当!$B$4:$L$8,1,1)","v":"数学"},{"$f":"vnlookup($B4,試験への割当!$B$4:$L$8,1,2)","v":"現代国語"},{"$f":"vnlookup($B4,試験への割当!$B$4:$L$8,1,3)","v":" "},{"$f":"vnlookup($B4,試験への割当!$B$4:$L$8,1,4)","v":" "},{"$f":"COUNTIF(E4:H4,\"<>\"&\" \")","v":2}]
[null,1002,"浦田","数理・長島",{"$f":"vnlookup($B5,試験への割当!$B$4:$L$8,1,1)","v":"数学"},{"$f":"vnlookup($B5,試験への割当!$B$4:$L$8,1,2)","v":"理科"},{"$f":"vnlookup($B5,試験への割当!$B$4:$L$8,1,3)","v":"現代国語"},{"$f":"vnlookup($B5,試験への割当!$B$4:$L$8,1,4)","v":" "},3]
[null,1003,"本田","生命・大島",{"$f":"vnlookup($B6,試験への割当!$B$4:$L$8,1,1)","v":"数学"},{"$f":"vnlookup($B6,試験への割当!$B$4:$L$8,1,2)","v":"理科"},{"$f":"vnlookup($B6,試験への割当!$B$4:$L$8,1,3)","v":"英語"},{"$f":"vnlookup($B6,試験への割当!$B$4:$L$8,1,4)","v":"現代国語"},4]
[null,1004,"池田","環境・小島",{"$f":"vnlookup($B7,試験への割当!$B$4:$L$8,1,1)","v":"理科"},{"$f":"vnlookup($B7,試験への割当!$B$4:$L$8,1,2)","v":"英語"},{"$f":"vnlookup($B7,試験への割当!$B$4:$L$8,1,3)","v":"現代国語"},{"$f":"vnlookup($B7,試験への割当!$B$4:$L$8,1,4)","v":" "},3]
[null,1005,"長田","物理・中島",{"$f":"vnlookup($B8,試験への割当!$B$4:$L$8,1,1)","v":"理科"},{"$f":"vnlookup($B8,試験への割当!$B$4:$L$8,1,2)","v":"英語"},{"$f":"vnlookup($B8,試験への割当!$B$4:$L$8,1,3)","v":"現代国語"},{"$f":"vnlookup($B8,試験への割当!$B$4:$L$8,1,4)","v":" "},3]
[null,1006,"上田","人間・西島",{"$f":"vnlookup($B9,試験への割当!$B$4:$L$8,1,1)","v":"現代国語"},{"$f":"vnlookup($B9,試験への割当!$B$4:$L$8,1,2)","v":" "},{"$f":"vnlookup($B9,試験への割当!$B$4:$L$8,1,3)","v":" "},{"$f":"vnlookup($B9,試験への割当!$B$4:$L$8,1,4)","v":" "},1]
[null," "," ",null,null,null,null,null,{"$f":"SUM(I4:I9)","v":16}]