{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ランダムコード設定","QR一覧","5-1","5-2","5-3","提出プリントsample"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":12,"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":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ランダムコードの文字","123456789bcdfghjkmnpqrstvwxyzBCDFGHJKLMNPRSTVWXYZ","ランダムコード桁数",12]
[null,"↑"]
[null,"aAiI ・・の母音と（0とOとQまぎらわしい）などは抜いている"]

{"sheet":"QR一覧","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,9,28,10]]}
[]
[null,"列数",null,"行数",null,"A列のデータ数",null,"シート番号　, で区切る"]
[null,4,null,30,null,{"$f":"COUNTA($A5:A$59)","v":13},null,"3,5"]
[null,"↑120(4×30)人以上の時、変更↑",null,null,null,null,null,"一クラスの時はシート番号を一つ"]
["t7SH3W93bkX3",null,"hRNyk2TJxCpT",null,"Cp93hpYSMwdy",null,"xNmZ7NbTPVnL"]
[null,"5-1 青森　海斗",null,"5-1 秋田　翔",null,"5-1 石田　愛美",null,"5-1 伊藤　望結",null,null,"QR削除は　上のボタンで"]
["PHt79LXK8vJf",null,"K6ByfNxczTTx",null,"rxCXFr5kKyWc",null,"tdKd4rycn31D"]
[null,"5-1 茨城　心",null,"5-1 岩手　空",null,"5-1 上戸　架純",null,"5-1 上村　工"]
["tzGGqHBcgGrN",null,"SwNPg9XMgfkW",null,"CYGDy7SMDLZ5",null,"RF7FZwGyGz3h"]
[null,"5-1 蛯原　結衣",null,"5-1 大阪　太郎",null,"5-1 大村　心",null,"5-1 大森　征悦"]
["FNfyhqV5Pmf4",null,"XDV1sCxRbmHg",null,"yMscwYVVLBFL",null,"gqk32hjJrc7y"]
[null,"5-1 織田　翼",null,"5-1 菅野　結菜",null,"5-1 木戸　くるみ",null,"5-1 群馬　愛莉"]
["DZY4f8z7KpJr",null,"MNqmdpmjFvLC",null,"jxkgmFM26C8P",null,"S6ckVbRdTSFd"]
[null,"5-1 西郷　聡太",null,"5-1 埼玉　真衣",null,"5-1 坂下　真敬",null,"5-1 真田　潤"]
["LZHH7Hqht8fW",null,"C61VZ1SSHvwR",null,"SGCcG6Jzk8jF",null,"PZpRt59Hzm6f"]
[null,"5-1 武田　隆之介",null,"5-1 千葉　優衣",null,"5-1 栃木　美羽",null,"5-1 福島　奈々子"]
["zvDb4cP9tx1M",null,"xZGC1brNS2Xs",null,"hqpf2SYNg6Yb",null,"J16CnB8pMcXm"]
[null,"5-1 北海　彩音",null,"5-1 宮城　 くるみ",null,"5-1 宮下　遥",null,"5-1 宮本　瑛大"]
["Y7PMrDfRsxWP",null,"NKMMwfTYRjjW",null,"t1Pw5WysDXVw",null,"SxTLcRs6p7M4"]
[null,"5-1 山形　陸",null,"5-1 山本　千夏",null,"5-1 若槻　咲　",null,"5-2 愛知　太郎"]
["HmJ58CjVLFpD",null,"d538rysX4wxP",null,"y5nSzCvzqcWz",null,"VWLZrXZdDP2p"]
[null,"5-2 石川　太一",null,"5-2 神奈川　健太",null,"5-2 木下　悠吾",null,"5-2 岐阜　雄太"]
["NyN3dSnHJPmG",null,"zsMz4y5pCBr7",null,"c2hXpnwC768G",null,"KTnPy1t6cf4g"]
[null,"5-2 国森　海斗",null,"5-2 熊田　涼太",null,"5-2 栗山　綾乃",null,"5-2 小池　優衣"]
["YV31SgpkrpSm",null,"FCFkkv7pg1hf",null,"RwKhS6vYX1yK",null,"5VZqvLLg8YPR"]
[null,"5-2 小森　健太",null,"5-3 岡山　陽菜",null,"5-3 京都　未来",null,"5-3 近藤　翔太"]
["DrqrWfmp5VJB",null,"2GFLcWHM6VsY",null,"LKrVkXd5NHmM",null,"xzqbXGJNPHst"]
[null,"5-3 佐藤　藍子",null,"5-3 滋賀　啓太",null,"5-3 篠原　翔",null,"5-3 柴咲　真理"]
["h7v8PbRMqK8m",null,"PNC1hZrwqr1M",null,"mqF84WmbZgvd",null,"tXKd3pGwthDq",null,null,"←ここから転入用 \n一人ひとり\nコード作成以外は手作業"]
[null,"5-3 島田　美優",null,"5-3 島根　豊",null,"5-3 瀬戸　真央",null,"5-2日本　花子"]

{"sheet":"5-1","index":2,"n_rows":42,"n_cols":54,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"5-1",{"$f":"COUNTA(E3:E42)","v":31},"B,C,F非表示列","G",null,"I",null,"K",null,"M","入列5-1","G"]
[null,"ノートAve","ノートSum","番号","名前","ランダムコード","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時"]
[null,{"$f":"IFERROR(AVERAGEIF(G3:BB3,\"<=100\",G3:BB3),\"\")","v":""},{"$f":"SUMIF(G3:BB3,\"<=100\",G3:BB3)","v":0},1,"青森　海斗","t7SH3W93bkX3"]
[null,{"$f":"IFERROR(AVERAGEIF(G4:BB4,\"<=100\",G4:BB4),\"\")","v":""},{"$f":"SUMIF(G4:BB4,\"<=100\",G4:BB4)","v":0},2,"秋田　翔","hRNyk2TJxCpT"]
[null,"",0,3,"石田　愛美","Cp93hpYSMwdy"]
[null,"",0,4,"伊藤　望結","xNmZ7NbTPVnL"]
[null,"",0,5,"茨城　心","PHt79LXK8vJf"]
[null,"",0,6,"岩手　空","K6ByfNxczTTx"]
[null,"",0,7,"上戸　架純","rxCXFr5kKyWc"]
[null,"",0,8,"上村　工","tdKd4rycn31D"]
[null,"",0,9,"蛯原　結衣","tzGGqHBcgGrN"]
[null,"",0,10,"大阪　太郎","SwNPg9XMgfkW"]
[null,"",0,11,"大村　心","CYGDy7SMDLZ5"]
[null,"",0,12,"大森　征悦","RF7FZwGyGz3h"]
[null,"",0,13,"織田　翼","FNfyhqV5Pmf4"]
[null,"",0,14,"菅野　結菜","XDV1sCxRbmHg"]
[null,"",0,15,"木戸　くるみ","yMscwYVVLBFL"]
[null,"",0,16,"群馬　愛莉","gqk32hjJrc7y"]
[null,"",0,17,"西郷　聡太","DZY4f8z7KpJr"]
[null,"",0,18,"埼玉　真衣","MNqmdpmjFvLC"]
[null,"",0,19,"坂下　真敬","jxkgmFM26C8P"]
[null,"",0,20,"真田　潤","S6ckVbRdTSFd"]
[null,"",0,21,"武田　隆之介","LZHH7Hqht8fW"]
[null,"",0,22,"千葉　優衣","C61VZ1SSHvwR"]
[null,"",0,23,"栃木　美羽","SGCcG6Jzk8jF"]
[null,"",0,24,"福島　奈々子","PZpRt59Hzm6f"]
[null,"",0,25,"北海　彩音","zvDb4cP9tx1M"]
[null,"",0,26,"宮城　 くるみ","xZGC1brNS2Xs"]
[null,"",0,27,"宮下　遥","hqpf2SYNg6Yb"]
[null,"",0,28,"宮本　瑛大","J16CnB8pMcXm"]
[null,"",0,29,"山形　陸","Y7PMrDfRsxWP"]
[null,"",0,30,"山本　千夏","NKMMwfTYRjjW"]
[null,"",0,31,"若槻　咲　","t1Pw5WysDXVw"]
[null,"",0,32]
[null,"",0,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]

{"sheet":"5-2","index":3,"n_rows":35,"n_cols":54,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"5-2",{"$f":"COUNTA($E$3:$E$42)","v":11},"非表示列,B,C,F",null,null,"I",null,"K",null,"M","入列5-2","G"]
[null,"ノートAve","ノートSum","番号","名前","ランダムコード","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時"]
[null,{"$f":"IFERROR(AVERAGEIF(G3:BB3,\"<=100\",G3:BB3),\"\")","v":""},{"$f":"SUMIF(G3:BB3,\"<=100\",G3:BB3)","v":0},1,"愛知　太郎","SxTLcRs6p7M4"]
[null,{"$f":"IFERROR(AVERAGEIF(G4:BB4,\"<=100\",G4:BB4),\"\")","v":""},{"$f":"SUMIF(G4:BB4,\"<=100\",G4:BB4)","v":0},2,"石川　太一","HmJ58CjVLFpD"]
[null,"",0,3,"神奈川　健太","d538rysX4wxP"]
[null,"",0,4,"木下　悠吾","y5nSzCvzqcWz"]
[null,"",0,5,"岐阜　雄太","VWLZrXZdDP2p"]
[null,"",0,6,"国森　海斗","NyN3dSnHJPmG"]
[null,"",0,7,"熊田　涼太","zsMz4y5pCBr7"]
[null,"",0,8,"栗山　綾乃","c2hXpnwC768G"]
[null,"",0,9,"小池　優衣","KTnPy1t6cf4g"]
[null,"",0,10,"小森　健太","YV31SgpkrpSm"]
[null,"",0,11,"日本　花子","tXKd3pGwthDq"]
[null,"",0,12]
[null,"",0,13]
[null,"",0,14]
[null,"",0,15]
[null,"",0,16]
[null,"",0,17]
[null,"",0,18]
[null,"",0,19]
[null,"",0,20]
[null,"",0,21]
[null,"",0,22]
[null,"",0,23]
[null,"",0,24]
[null,"",0,25]
[null,"",0,26]
[null,"",0,27]
[null,"",0,28]
[null,"",0,29]
[null,"",0,30]
[null,"",0,31]
[null,"",0,32]
[null,"",0]

{"sheet":"5-3","index":4,"n_rows":36,"n_cols":54,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"5-3",{"$f":"COUNTA(E3:E42)","v":10},"非表示列,B,C,F","G",null,"I",null,"K",null,"M","入列5-3","G",null,"Q"]
[null,"ノートAve","ノートSum","クラス","名前","ランダムコード","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時","点数","日時"]
[null,{"$f":"IFERROR(AVERAGEIF(G3:BB3,\"<=100\",G3:BB3),\"\")","v":""},{"$f":"SUMIF(G3:BB3,\"<=100\",G3:BB3)","v":0},1,"岡山　陽菜","FCFkkv7pg1hf"]
[null,{"$f":"IFERROR(AVERAGEIF(G4:BB4,\"<=100\",G4:BB4),\"\")","v":""},{"$f":"SUMIF(G4:BB4,\"<=100\",G4:BB4)","v":0},2,"京都　未来","RwKhS6vYX1yK"]
[null,"",0,3,"近藤　翔太","5VZqvLLg8YPR"]
[null,"",0,4,"佐藤　藍子","DrqrWfmp5VJB"]
[null,"",0,5,"滋賀　啓太","2GFLcWHM6VsY"]
[null,"",0,6,"篠原　翔","LKrVkXd5NHmM"]
[null,"",0,7,"柴咲　真理","xzqbXGJNPHst"]
[null,"",0,8,"島田　美優","h7v8PbRMqK8m"]
[null,"",0,9,"島根　豊","PNC1hZrwqr1M"]
[null,"",0,10,"瀬戸　真央","mqF84WmbZgvd"]
[null,"",0,11]
[null,"",0,12]
[null,"",0,13]
[null,"",0,14]
[null,"",0,15]
[null,"",0,16]
[null,"",0,17]
[null,"",0,18]
[null,"",0,19]
[null,"",0,20]
[null,"",0,21]
[null,"",0,22]
[null,"",0,23]
[null,"",0,24]
[null,"",0,25]
[null,"",0,26]
[null,"",0,27]
[null,"",0,28]
[null,"",0,29]
[null,"",0,30]
[null,"",0,31]
[null,"",0,32]
[null,"",0,33]
[null,null,null,34]

{"sheet":"提出プリントsample","index":5,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"5-2"]
[null,null,null,null,null,"熊田　涼太"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"印刷クラス"]
[null,null,null,null,null,null,null,null,"5-2"]
[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,"3,5,7"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"印刷ORプレビュー","プレビューのみ"]
[]
[null,null,null,null,null,null,null,null,"マクロでの「プレビュー」は上部しか見えない時があります"]