{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["目次","1 相対・絶対","2 条件付書式","3 効率的な作業範囲の移動","4 ボタン類の配置","5 ボタンで連続変化","6 条件つけて平均等","7 閾値弁別","8 漸増閾値","9 AAAB→4","10 評定分布表","11 連続印刷"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," 本日の研修メニュー"]
[]
[null,1,"相対参照と絶対参照それぞれの利点と活用法",null,"基本技能"]
[null,2,"条件に合ったセルを強調することで、間違いを防ぐ方法",null,"基本技能"]
[null,3,"効率的に入力しつつセル間を移動する方法",null,"基本技能"]
[null,4,"ボタンやスイッチをシートに配置して特定のセルに関連付ける方法",null,"基本技能"]
[null,5,"連続的にセルの値を変化させ、表示内容を変えていく方法",null,"教材提示"]
[null,6,"転入生などがあっても行を挿入したりせず、条件を指定することで平均点を出す方法",null,"成績処理"]
[null,7,"設定したハードルで評価を分ける方法 　３５点以上はＡ　など",null,"成績処理"]
[null,8,"一度設定したハードルを連続的に変化させつつ評価・評定の分布を見直す方法",null,"成績処理"]
[null,9,"AAAB → 4　のように評定を出す方法",null,"成績処理"]
[null,10,"評定分布表の作り方",null,"成績処理"]
[null,11,"連続印刷の仕方　基本と応用",null,"成績処理"]
[null,null,"1-6は午前開催、7-11は午後に開催します。当日の人数によってはこの限りではありません。"]

{"sheet":"1 相対・絶対","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[" "]
[null,"相対参照と絶対参照"]
[]
[null,"回→",1,2,3,4,5,"合計"]
[null,"比重",10,5,15,5,5]
[null,"Aさん",5,6,7,4,6,{"$f":"C6*C5+D6*D5+E6*E5+F6*F5+G6*G5","v":235}]
[null,"Bさん",1,7,3,9,2]
[null,"Cさん",9,8,7,8,9,null,"下にコピー"]
[null,"Dさん",1,4,5,3,5]
[]
[]
[]
[null,"回→",1,2,3,4,5,"合計"]
[null,"比重",10,5,15,5,5,null,null,"RANK"]
[null,"Aさん",5,6,7,4,6,{"$f":"C15*$C$14+D15*$D$14+E15*$E$14+F15*$F$14+G15*$G$14","v":235},null,{"$f":"RANK(H15,H15:H18)","v":1}]
[null,"Bさん",1,7,3,9,2]
[null,"Cさん",9,8,7,8,9,null,"下にコピー"]
[null,"Dさん",1,4,5,3,5]

{"sheet":"2 条件付書式","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"入力した素点がおかしい"]
[null,"回",1,2,3,4,5,"合計"]
[null,"配点",8,10,10,10,10,{"$f":"SUM(C3:G3)","v":48}]
[null,"Aさん",5,6,7,4,6,{"$f":"SUM(C4:G4)","v":28}]
[null,"Bさん",1,7,3,9,2,{"$f":"SUM(C5:G5)","v":22}]
[null,"Cさん",7,8,7,8,9,{"$f":"SUM(C6:G6)","v":39}]
[null,"Dさん",1,4,5,3,5,{"$f":"SUM(C7:G7)","v":18}]
[]
[]
[null,"平均点より1点以上低い"]
[null,"回",1,2,3,4,5,"合計"]
[null,"配点",10,10,10,10,10,{"$f":"SUM(C12:G12)","v":50}]
[null,"平均点",{"$f":"AVERAGE(C14:C17)","v":5.5},{"$f":"AVERAGE(D14:D17)","v":7},5.5,8.25,6.75,33]
[null,"Aさん",5,6,7,8,6,{"$f":"SUM(C14:G14)","v":32}]
[null,"Bさん",3,7,3,9,6,{"$f":"SUM(C15:G15)","v":28}]
[null,"Cさん",9,8,7,8,9,{"$f":"SUM(C16:G16)","v":41}]
[null,"Dさん",5,7,5,8,6,{"$f":"SUM(C17:G17)","v":31}]
[]
[" "]
[null,"回",1,2,3,4,5,"合計"]
[null,"配点",10,10,10,10,10,{"$f":"SUM(C21:G21)","v":50}]
[true,"平均点",{"$f":"AVERAGE(C23:C26)","v":5.5},{"$f":"AVERAGE(D23:D26)","v":7},{"$f":"AVERAGE(E23:E26)","v":5.5},{"$f":"AVERAGE(F23:F26)","v":8.25},{"$f":"AVERAGE(G23:G26)","v":6.75},{"$f":"AVERAGE(H23:H26)","v":33}]
[null,"Aさん",5,6,7,8,6,{"$f":"SUM(C23:G23)","v":32}]
[null,"Bさん",3,7,3,9,6,{"$f":"SUM(C24:G24)","v":28}]
[null,"Cさん",9,8,7,8,9,{"$f":"SUM(C25:G25)","v":41}]
[null,"Dさん",5,7,5,8,6,{"$f":"SUM(C26:G26)","v":31}]
["=AND(C26<C$15-1,$A$24=TRUE) を条件として埋め込む"]

{"sheet":"3 効率的な作業範囲の移動","index":3,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"セル間は、Tabキーで移動、Enterで改行・確定",null,null,null,null,null,null,null,null,null,null,"範囲指定とセル間の移動"]
[null,null,"国語","社会","数学","理科","英語","合計"]
[null,"A",33,55,44,66,22,{"$f":"SUM(C4:G4)","v":220},null,null,null,null,1,1,1,1,1,1,1,1,1]
[null,"B",null,null,null,null,null,{"$f":"SUM(C5:G5)","v":0},null,null,null,null,1,null,null,null,1,null,null,null,1]
[null,"C",null,null,null,null,null,0,null,null,null,null,1,null,null,null,1,null,null,null,1]
[null,"D",null,null,null,null,null,0,null,null,null,null,1,null,null,null,1,null,null,null,1]
[null,"E",null,null,null,null,null,0,null,null,null,null,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,1,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,1,null,null,null,1]
[null,null,"国語","社会","数学","理科","英語","合計","COUNT関数",null,null,null,1,null,null,null,1,null,null,null,1]
[null,"F",7,null,null,5,null,{"$f":"IF(I12=0,\"\",SUM(C12:G12))","v":12},{"$f":"COUNT(C12:G12)","v":2},null,null,null,1,1,1,1,1,1,1,1,1]
[null,"G",null,null,null,null,null,"",0]
[null,"H",null,null,null,null,null,"",0,null,null,null,"Ctrl キーの活用"]
[null,"I",null,null,null,null,null,"",0,null,null,null,null,"香車の動き"]
[null,"J",null,null,null,null,null,"",0]
[null,"K",null,null,null,null,null,"",0,null,null,null,"Shift キーの活用"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"範囲指定"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"逆方向の動き"]
[null,null,"国語","社会","数学","理科","英語","合計",null,null,null,null,null,null,"Tab"]
[null,"L",7,null,null,5,null,{"$f":"IF(COUNT(C21:G21)=0,\"\",SUM(C21:G21))","v":12},"=IF(COUNT(C21:G21)=0,\"\",SUM(C21:G21))",null,null,null,null,null,"Enter"]
[null,"M",null,null,null,null,null,{"$f":"IF(COUNT(C22:G22)=0,\"\",SUM(C22:G22))","v":""}]
[null,"N",null,null,null,null,null,""]
[null,"O",null,null,null,null,null,""]
[null,"P",null,null,null,null,null,""]
[null,"Q",null,null,null,null,null,""]

{"sheet":"4 ボタン類の配置","index":4,"n_rows":30,"n_cols":31,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,4,27,7],[13,20,25,27],[2,5,4,15],[6,5,9,15],[11,5,14,15]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[2]
[3,null,null,null,null,"Sub ボタン1_Click()\n    Range(\"6:6\").Select\nEnd Sub"]
[4]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"行","列",null,null,null,null,null,null,"列の読み替え"]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,19,null,null,null,null,null,null,"A",1]
[7,null,null,null,null,"Sub 縦を指定()\n    Range(\"Q:Q\").Select\nEnd Sub",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",2]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",3]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",4]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",5]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",6]
[12,null,null,null,null,"Sub 指定のセル()\n    Range(\"H11\").Select\nEnd Sub",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",7]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",8]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub 円楕円2_Click()\n    \n    Dim AAA As Integer\n    Dim BBB As Integer\n    \n    AAA = Range(\"V6\").Value\n    BBB = Range(\"W6\").Value\n    \n    Cells(AAA, BBB).Select\n    \nEnd Sub\n",null,null,null,null,null,null,null,null,"I",9]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",10]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",11]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",12]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",13]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",14]
[20,null,7,"年",13,"組",15,"番",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O",15]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P",16]
[22,false,null,null,null,null,null,null,{"$f":"IF(B22=TRUE,\"チェックがONです\",\"チェックされていません\")","v":"チェックされていません"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q",17]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",18]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",19]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T",20]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U",21]
[27,null,null,null,72]
[28]
[29]
[30]

{"sheet":"5 ボタンで連続変化","index":5,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,4,18,4],[15,4,16,4],[20,4,21,4],[22,4,23,4]]}
[]
[null,null,null,1,2,3,4,5]
[null,1,2,3,4,5,6,7]
[]
[]
[null,null,null,"形容詞","形容動詞","動詞(カ行五段)","動詞(下一段)","動詞(上一段)"]
[null,null,null,"うつくしい","静かだ","歩く","当てる","染みる"]
[null,1,"未然形","かろ","だろ","か・こ","あて","しみ"]
[null,2,"連用形","かっ・く・う","だっ・で・に","き","あて","しみ"]
[null,3,"終止形","い","だ","く","あてる","しみる"]
[null,4,"連体形","い","な","け","あてる","しみる"]
[null,5,"仮定形","けれ","なら","け","あてれ","しみれ"]
[null,6,"命令形","○","○","こ","あてろ","しみろ"]
[]
[]
[null,null,null,null,{"$f":"HLOOKUP($A$17,$D$2:$H$6,5)","v":"形容詞"}]
[1]
[null,null,null,null,{"$f":"HLOOKUP($A$17,$D$2:$H$7,6)","v":"うつくしい"}]
[]
[null,null,null,null,"↓"]
[3,null,null,null,{"$f":"VLOOKUP($A$21,$B$8:$H$13,2)","v":"終止形"}]
[]
[null,null,null,null,{"$f":"VLOOKUP($A$21,$B$8:$H$13,$A$17+2)","v":"い"}]

{"sheet":"6 条件つけて平均等","index":6,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"学級別平均点",null,"(IFERROR関数)"]
[null,null,null,"AVERAGEIF関数",null,"ROUND関数","ネストした式","0に対応"]
[null,1,{"$f":"COUNTIF($B$12:$B$32,B4)","v":4},{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$B4,D$12:D$32),\"分布に問題あり\")","v":53.25},"→",{"$f":"ROUND(D4,1)","v":53.3},{"$f":"ROUND(AVERAGEIF($B$12:$B$32,$B4,$D$12:$D$32),1)","v":53.3},{"$f":"IF(C4=0,\"\",ROUND(AVERAGEIF($B$12:$B$32,$B4,$D$12:$D$32),1))","v":53.3}]
[null,2,{"$f":"COUNTIF($B$12:$B$32,B5)","v":3},{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$B5,D$12:D$32),\"分布に問題あり\")","v":64.666666666666671},"→",{"$f":"ROUND(D5,1)","v":64.7},{"$f":"ROUND(AVERAGEIF($B$12:$B$32,$B5,$D$12:$D$32),1)","v":64.7},{"$f":"IF(C5=0,\"\",ROUND(AVERAGEIF($B$12:$B$32,$B5,$D$12:$D$32),1))","v":64.7}]
[null,3,{"$f":"COUNTIF($B$12:$B$32,B6)","v":4},{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$B6,D$12:D$32),\"分布に問題あり\")","v":60.25},"→",60.3,{"$f":"ROUND(AVERAGEIF($B$12:$B$32,$B6,$D$12:$D$32),1)","v":60.3},{"$f":"IF(C6=0,\"\",ROUND(AVERAGEIF($B$12:$B$32,$B6,$D$12:$D$32),1))","v":60.3}]
[null,4,8,{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$B7,D$12:D$32),\"分布に問題あり\")","v":42.5},"→",42.5,{"$f":"ROUND(AVERAGEIF($B$12:$B$32,$B7,$D$12:$D$32),1)","v":42.5},{"$f":"IF(C7=0,\"\",ROUND(AVERAGEIF($B$12:$B$32,$B7,$D$12:$D$32),1))","v":42.5}]
[null,5,0,{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$B8,D$12:D$32),\"分布に問題あり\")","v":"分布に問題あり"},"→",{"$error":"#VALUE!"},{"$f":"ROUND(AVERAGEIF($B$12:$B$32,$B8,$D$12:$D$32),1)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C8=0,\"\",ROUND(AVERAGEIF($B$12:$B$32,$B8,$D$12:$D$32),1))","v":""}]
[null,null,"全体",{"$f":"AVERAGE(D12:D32)","v":52},"→",52]
[null,null,"最高点",{"$f":"MAX(D12:D32)","v":87}]
[null,"クラス","氏名","得点"]
[null,1,"A",44]
[null,1,"B",84]
[null,1,"C",26]
[null,1,"D",59]
[null,2,"E",48]
[null,2,"F",87]
[null,2,"G",59]
[null,3,"H",62]
[null,3,"I",45]
[null,3,"J",78]
[null,3,"K",56]
[null,4,"L",84]
[null,4,"M",15]
[null,4,"N",48]
[null,4,"O",59]
[null,4,"P",26]
[null,4,"Q",18]
[null,4,"R",79]
[null,4,"S",11]

{"sheet":"7 閾値弁別","index":7,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"学級別平均点"]
[null,null,null,"平均点"]
[null,null,1,{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$C4,D$12:D$32),\"分布に問題あり\")","v":48},0,"E"]
[null,null,2,{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$C5,D$12:D$32),\"分布に問題あり\")","v":69.2},20,"D"]
[null,null,3,45,40,"C"]
[null,null,4,61.166666666666664,60,"B"]
[null,null,5,41.75,80,"A"]
[null,null,"全体",{"$f":"AVERAGE(D12:D32)","v":57.235294117647058}]
[null,null,"最高点",{"$f":"MAX(D12:D32)","v":99}]
[null,"クラス","氏名","得点","素","改","順位","順位改"]
[null,5,"A",45,{"$f":"VLOOKUP($D12,$E$4:$F$8,2)","v":"C"},{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,$E$4:$F$8,2))","v":"C"},{"$f":"RANK(D12,$D$12:$D$29)","v":13},{"$f":"IF(D12=\"\",\"\",RANK(D12,$D$12:$D$29))","v":13}]
[null,4,"B",84,"A","A",3,{"$f":"IF(D13=\"\",\"\",RANK(D13,$D$12:$D$29))","v":3}]
[null,4,"C",99,"A","A",1,1]
[null,2,"D",59,"C","C",7,7]
[null,1,"E",48,"C","C",11,11]
[null,2,"F",87,"A","A",2,2]
[null,2,"G",59,"C","C",7,7]
[null,2,"H",62,"B","B",6,6]
[null,3,"I",45,"C","C",13,13]
[null,4,"J",null,"E","",{"$error":"#N/A"},""]
[null,4,"K",56,"C","C",10,10]
[null,4,"L",84,"A","A",3,3]
[null,5,"M",15,"E","E",17,17]
[null,5,"N",48,"C","C",11,11]
[null,5,"O",59,"C","C",7,7]
[null,4,"P",26,"D","D",15,15]
[null,4,"Q",18,"E","E",16,16]
[null,2,"R",79,"B","B",5,5]
[null,null,null,null,"E","",{"$error":"#N/A"},""]
[null,null,null,null,"E","",{"$error":"#N/A"},""]
[null,null,null,null,"E","",{"$error":"#N/A"},""]

{"sheet":"8 漸増閾値","index":8,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"学級別平均点"]
[null,null,null,"平均点"]
[null,null,1,{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$C4,D$12:D$32),\"分布に問題あり\")","v":1},0,"E",{"$f":"COUNTIF($F$12:$F$32,F4)","v":1}]
[null,null,2,{"$f":"IFERROR(AVERAGEIF($B$12:$B$32,$C5,D$12:D$32),\"分布に問題あり\")","v":69.2},11,"D",{"$f":"COUNTIF($F$12:$F$32,F5)","v":11}]
[null,null,3,45,65,"C",1]
[null,null,4,61.166666666666664,80,"B",3]
[null,null,5,41.75,90,"A",1]
[null,null,"全体",{"$f":"AVERAGE(D12:D32)","v":54.470588235294116}]
[null,null,"最高点",{"$f":"MAX(D12:D32)","v":99}]
[null,"クラス","氏名","得点","素","改","順位","順位改"]
[null,5,"A",45,{"$f":"VLOOKUP($D12,$E$4:$F$8,2)","v":"D"},{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,$E$4:$F$8,2))","v":"D"},{"$f":"RANK(D12,$D$12:$D$29)","v":12},{"$f":"IF(D12=\"\",\"\",RANK(D12,$D$12:$D$29))","v":12}]
[null,4,"B",84,"B","B",3,{"$f":"IF(D13=\"\",\"\",RANK(D13,$D$12:$D$29))","v":3}]
[null,4,"C",99,"A","A",1,1]
[null,2,"D",59,"D","D",7,7]
[null,1,"E",1,"E","E",17,17]
[null,2,"F",87,"B","B",2,2]
[null,2,"G",59,"D","D",7,7]
[null,2,"H",62,"D","D",6,6]
[null,3,"I",45,"D","D",12,12]
[null,4,"J",null,"E","",{"$error":"#N/A"},""]
[null,4,"K",56,"D","D",10,10]
[null,4,"L",84,"B","B",3,3]
[null,5,"M",15,"D","D",16,16]
[null,5,"N",48,"D","D",11,11]
[null,5,"O",59,"D","D",7,7]
[null,4,"P",26,"D","D",14,14]
[null,4,"Q",18,"D","D",15,15]
[null,2,"R",79,"C","C",5,5]
[null,null,null,null,"E","",{"$error":"#N/A"},""]
[null,null,null,null,"E","",{"$error":"#N/A"},""]
[null,null,null,null,"E","",{"$error":"#N/A"},""]

{"sheet":"9 AAAB→4","index":9,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"関","話","書","読","言"]
[null,"C","C","C","C","C",{"$f":"COUNTIF($B3:$F3,D$15)-COUNTIF($B3:$F3,D$17)","v":-5},1]
[null,"C","C","C","C","B",-4,2]
[null,"C","C","C","B","B",-3,2]
[null,"C","C","B","B","B",-2,3]
[null,"C","B","B","B","B",-1,3]
[null,"B","B","B","B","B",0,3]
[null,"B","B","B","B","A",1,3]
[null,"B","B","B","A","A",2,3]
[null,"B","B","A","A","A",3,4]
[null,"B","A","A","A","A",4,4]
[null,"A","A","A","A","A",5,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ネスト"]
[null,null,null,"A",1,null,null,null,"組","番","名前","関","話","書","読","言",null,"評定",null,"評定"]
[null,null,null,"B",0,null,null,null,1,1,"新井","B","B","B","C","C",{"$f":"COUNTIF($L16:$P16,D$15)-COUNTIF($L16:$P16,D$17)","v":-2},{"$f":"VLOOKUP($Q16,$G$3:$H$13,2)","v":3},null,{"$f":"VLOOKUP(COUNTIF($L16:$P16,D$15)-COUNTIF($L16:$P16,D$17),$G$3:$H$13,2)","v":3}]
[null,null,null,"C",-1,null,null,null,1,2,"石井","C","C","B","A","A",0,3,null,3]
[null,null,null,null,null,null,null,null,1,3,"臼井","C","C","A","A","C",-1,3,null,3]
[null,null,null,null,null,null,null,null,2,1,"江藤","B","B","A","A","A",3,4,null,4]
[null,null,null,null,null,null,null,null,2,2,"大木","A","C","B","C","A",0,3,null,3]
[null,null,null,null,null,null,null,null,2,3,"加藤","B","B","B","C","A",0,3,null,3]
[null,null,null,null,null,null,null,null,3,1,"工藤","A","B","B","C","A",1,3,null,3]
[null,null,null,null,null,null,null,null,3,2,"後藤","B","B","C","C","A",-1,3,null,3]
[null,null,null,null,null,null,null,null,3,3,"佐藤","B","C","C","C","A",-2,3,null,3]
[null,null,null,null,null,null,null,null,3,4,"鈴木","C","C","C","C","A",-3,2,null,2]

{"sheet":"10 評定分布表","index":10,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"関","話","書","読","言",null,null,null,null,null,"関","話","書","読","言"]
[null,"C","C","C","C","C",{"$f":"COUNTIF($B3:$F3,D$15)-COUNTIF($B3:$F3,D$17)","v":-5},1,null,null,"A",{"$f":"COUNTIF(L$16:L$25,$K3)","v":2},0,2,3,7]
[null,"C","C","C","C","B",-4,2,null,null,"B",4,4,4,0,0]
[null,"C","C","C","B","B",-3,2,null,null,"C",3,5,3,6,2]
[null,"C","C","B","B","B",-2,3]
[null,"C","B","B","B","B",-1,3,null,null,null,1,2,3,4,5]
[null,"B","B","B","B","B",0,3,null,null,1,{"$f":"COUNTIFS($I$16:$I$25,$K8,$R$16:$R$25,L$7)","v":0},0,3,0,0]
[null,"B","B","B","B","A",1,3,null,null,2,0,0,2,1,0]
[null,"B","B","B","A","A",2,3,null,null,3,0,1,3,0,0]
[null,"B","B","A","A","A",3,4,null,null,"合計",{"$f":"SUM(L8:L10)","v":0},{"$f":"SUM(M8:M10)","v":1},8,1,0]
[null,"B","A","A","A","A",4,4]
[null,"A","A","A","A","A",5,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ネスト"]
[null,null,null,"A",1,null,null,null,"組","番","名前","関","話","書","読","言",null,"評定","不能考慮","評定"]
[null,null,null,"B",0,null,null,1,1,1,"新井","B","B","B","C","C",{"$f":"COUNTIF($L16:$P16,D$15)-COUNTIF($L16:$P16,D$17)","v":-2},{"$f":"VLOOKUP($Q16,$G$3:$H$13,2)","v":3},{"$f":"IF(COUNTA(L16:P16)=0,\"\",R16)","v":3},{"$f":"IF(COUNTA(L16:P16)=0,\"\",VLOOKUP($Q16,$G$3:$H$13,2))","v":3}]
[null,null,null,"C",-1,null,null,2,1,2,"石井","C","C","B","A","A",0,3,{"$f":"IF(COUNTA(L17:P17)=0,\"\",R17)","v":3},3]
[null,null,null,null,null,null,null,3,1,3,"臼井","C","C","A","A","C",-1,3,3,3]
[null,null,null,null,null,null,null,4,2,1,"江藤","B","B","A","A","A",3,4,4,4]
[null,null,null,null,null,null,null,5,2,2,"大木","A","C","B","C","A",0,3,3,3]
[null,null,null,null,null,null,null,6,2,3,"加藤",null,null,null,null,null,0,3,"",""]
[null,null,null,null,null,null,null,7,3,1,"工藤","A","B","B","C","A",1,3,3,3]
[null,null,null,null,null,null,null,8,3,2,"後藤","B","B","C","C","A",-1,3,3,3]
[null,null,null,null,null,null,null,9,3,3,"佐藤","B","C","C","C","A",-2,3,3,3]
[null,null,null,null,null,null,null,10,3,4,"鈴木","C","C","C","C","A",-3,2,2,2]

{"sheet":"11 連続印刷","index":11,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"キーC",3,"→",{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,2)","v":1},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,3)","v":3},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,4)","v":"臼井"}]
[null,null,"キーA"]
[null,null,1,{"$f":"VLOOKUP(C5,'10 評定分布表'!$H$16:$K$25,2)","v":1},{"$f":"VLOOKUP(C5,'10 評定分布表'!$H$16:$K$25,3)","v":1},{"$f":"VLOOKUP(C5,'10 評定分布表'!$H$16:$K$25,4)","v":"新井"},null,"評定","関心","話す聞く","書く","読む","伝統文化"]
[null,null,"キーB",null,"から",null,null,{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,11)","v":3},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,5)","v":"C"},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,6)","v":"C"},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,7)","v":"A"},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,8)","v":"A"},{"$f":"VLOOKUP($F$3,'10 評定分布表'!$H$16:$T$25,9)","v":"C"}]
[null,null,3,{"$f":"VLOOKUP(C7,'10 評定分布表'!$H$16:$K$25,2)","v":1},{"$f":"VLOOKUP(C7,'10 評定分布表'!$H$16:$K$25,3)","v":3},{"$f":"VLOOKUP(C7,'10 評定分布表'!$H$16:$K$25,4)","v":"臼井"}]
[]
[]
[null,null,"キーC　に"]
[null,null,"キーA から　キーB　までの数字を順に入れては印刷を実行する。"]