{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["名簿","印刷帳表","ラベルの設定例"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["通し番号","組","番号","氏名","国語","数学","英語","合計","順位"]
[1,"A",1,"小矢部　翔",85,56,86,{"$f":"SUM(E2:G2)","v":227},3]
[2,"A",2,"庄川　武士",42,21,69,{"$f":"SUM(E3:G3)","v":132},14]
[3,"A",3,"神通　怜奈",92,50,81,223,4]
[4,"A",4,"常願寺　幸子",20,46,66,132,14]
[5,"A",5,"早月　さゆり",79,31,99,209,5]
[6,"A",6,"片貝　修吾",69,97,82,248,1]
[7,"A",7,"黒部　駿司",92,31,21,144,13]
[8,"B",1,"木水田　文子",89,41,68,198,7]
[9,"B",2,"増野　壽司",34,78,63,175,9]
[10,"B",3,"保多留　伊香子",80,71,93,244,2]
[11,"C",1,"富田　摩耶",27,42,61,130,16]
[12,"C",2,"屋薪　志郎",45,57,43,145,12]
[13,"C",3,"増子　昭博",32,99,47,178,8]
[14,"C",4,"鰤田　友代",46,62,94,202,6]
[15,"C",5,"楽川　太朗",82,25,21,128,17]
[16,"C",6,"月野　陽子",46,28,88,162,11]
[17,"C",7,"栗原　広美子",88,56,31,175,9]

{"sheet":"印刷帳表","index":1,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,null,null,null,null,null,null,"・・・マクロで数値が変わるセル（初期設定）"]
[null,null,null,null,null,null,null,null,null,null,null,"・・・ワークシート関数が入力されているセル"]
[null,{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,1))","v":"A"},"組",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,2))","v":1},"番",null,"氏名",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,3))","v":"小矢部　翔"}]
[]
[null,null,null,null,null,"教科","得点",null,null,null,null,"ボタンを押すと「印刷」が開始されます"]
[null,null,null,null,null,"国語",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,4))","v":85}]
[null,null,null,null,null,"数学",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,5))","v":56},null,null,null,null,null,"初期設定では1～6"]
[null,null,null,null,null,"英語",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,6))","v":86}]
[]
[null,null,null,null,null,"合計",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,7))","v":227},null,null,null,null,null,"初期設定では1～6"]
[]
[null,null,null,null,null,"学年順位",{"$f":"IF($A$1=\"\",\"\",INDEX(名簿!$B:$I,$A$1+1,8))","v":3}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"※「名簿」シートの氏名をデータ数の基準にしています"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"マクロの確認は[Alt]キー + [F11]キー"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Excel Tips for Learners"]

{"sheet":"ラベルの設定例","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,null,null,null,null,"数値入力するセル　数値に応じてラベルの番号が変更されます"]
[null,null,null,null,null,null,null,null,null,"ワークシート関数が入力されているセル"]
[null,"ラベル",{"$f":"IF($A$1=\"\",\"\",($A$1-1)*6+1)","v":1},null,"ラベル",{"$f":"IF($C$3=\"\",\"\",$C$3+1)","v":2}]
[]
[]
[null,"ラベル",{"$f":"IF($C$3=\"\",\"\",$C$3+2)","v":3},null,"ラベル",{"$f":"IF($C$3=\"\",\"\",$C$3+3)","v":4}]
[]
[]
[null,"ラベル",{"$f":"IF($C$3=\"\",\"\",$C$3+4)","v":5},null,"ラベル",{"$f":"IF($C$3=\"\",\"\",$C$3+5)","v":6}]