{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["目次とシートコピー","集計","ランダムコード設定","QR一覧","点検シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,14,3,16],[4,14,4,16]]}
[]
[null,"No.","目次",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,"10月"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ランダムコードを作ってから！"]
[null,null,null,null,"年度",2023,null,"集計月",null,null,null,null,null,null,"最後のシートをコピーします"]
[null,null,null,null,null,null,null,"10月"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　非表示列：I (アイ), J、K,L,M　コピーあるいは集計する日にちを変更する時表示"]
[null,null,null,null,null,null,null,"書き込み列"]
[null,null,null,null,null,null,null,"D",null,null,null,null,null,"←　「集計」シートで書き込む左端の列"]
[]
[null,null,null,null,null,null,null,"ノートの種類数"]
[null,null,null,null,null,null,null,{"$f":"ノートの種類数","v":3},null,null,null,null,null,"←　ここでは変えずに「QR一覧」シートで変える"]
[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,"4月",5,30,5,30,{"$f":"IF(OR(K15<J15, M15<L15),\"←開始日終了日にエラーがあります.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"5月",1,31,1,31,{"$f":"IF(OR(K16<J16, M16<L16),\"←開始日終了日にエラーがあります.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"6月",1,30,1,30,""]
[null,null,null,null,null,null,null,null,"7月",1,31,1,31,""]
[null,null,null,null,null,null,null,null,"8月",20,31,20,31,""]
[null,null,null,null,null,null,null,null,"9月",20,30,20,21,""]
[null,null,null,null,null,null,null,null,"10月",1,31,16,17,""]
[null,null,null,null,null,null,null,null,"11月",1,30,1,30,""]
[null,null,null,null,null,null,null,null,"12月",1,25,1,25,""]
[null,null,null,null,null,null,null,null,"1月",6,31,6,31,""]
[null,null,null,null,null,null,null,null,"2月",1,{"$f":"IF(DAY(DATE(年度+1,2,29))=29,29,28)","v":29},1,{"$f":"IF(DAY(DATE(年度+1,2,29))=29,29,28)","v":29},""]
[null,null,null,null,null,null,null,null,"3月",1,20,1,20,""]
[]
[null,null,null,null,null,null,null,null,"2月は関数で28か29を判断"]
[null,null,null,null,null,null,null,null,"=IF(DAY(DATE(年度+1,2,29))=29,29,28)"]

{"sheet":"集計","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["日数","未提出日数",null,"2日間中",null,null,{"$f":"クラス人数*集計日数","v":8},null,{"$f":"SUM(D4:D44)","v":7}]
[2,"3-Z",{"$f":"COUNTA(C4:C44)","v":4},"漢字ド","日記","プリント1"]
["↑","番号","提出率→",{"$f":"(クラス人数*集計日数-SUM(D4:D44))/(クラス人数*集計日数)","v":0.125},{"$f":"(クラス人数*集計日数-SUM(E4:E44))/(クラス人数*集計日数)","v":0.375},{"$f":"(クラス人数*集計日数-SUM(F4:F44))/(クラス人数*集計日数)","v":0.625}]
[null,1,"青森　海斗",2,0,2]
[null,2,"秋田　翔",2,2,0]
[null,3,"伊藤　望結",2,2,0]
[null,4,"茨城　愛美",1,1,1]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]

{"sheet":"ランダムコード設定","index":2,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ランダムコードの文字","123456789bcdfghjkmnpqrstvwxyzBCDFGHJKLMNPRSTVWXYZ","ランダムコード桁数",8,null,"ノート1","ノート2","ノート3","ノート4","ノート5"]
[null,"↑",null,null,"つける\n接頭辞","Nt1","Nt2","Nt3","Nt4","Nt5"]
[null,"aAiI ・・の母音と（0とOとQまぎらわしい）などは抜いている"]

{"sheet":"QR一覧","index":3,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,9,34,10]]}
[]
[null,"列数",null,"行数",null,"A列のデータ数",null,"ノートの種類数",null,null,null,"種類1","種類2","種類3","種類4","種類5"]
[null,4,null,34,null,{"$f":"COUNTA($A5:A$59)","v":3},null,{"$f":"COUNTA(L3:P3)","v":3},null,"←","自動で入る　　　点検するノートの種類を入力⇒","漢字ド","日記","プリント1"]
[null,"↑　変更不可",null,"↑変更指示が出た時変更　",null,null,null,null,null,null,null,null,null,null,null,"　非表示列⇒","C","E","G"]
["Nt12kRgWLjH",null,"Nt16ZNykS2W",null,"Nt1tKdnySbF",null,"Nt12M93HJr3"]
[null,"3-Z_青森　海斗_漢字ド",null,"3-Z_秋田　翔_漢字ド",null,"3-Z_伊藤　望結_漢字ド",null,"3-Z_茨城　愛美_漢字ド"]
["Nt2KTrf83pN",null,"Nt2Yp8hhBJV",null,"Nt2PJBXHDRg",null,"Nt2KGqwB5cH"]
[null,"3-Z_青森　海斗_日記",null,"3-Z_秋田　翔_日記",null,"3-Z_伊藤　望結_日記",null,"3-Z_茨城　愛美_日記",null,null,"QR削除はこのシート上の全てのQRが消去"]
["Nt3nyPXyX8M",null,"Nt3JtVPCnBv",null,"Nt3Tcxt4GZg",null,"Nt3DBH5ZSt9"]
[null,"3-Z_青森　海斗_プリント1",null,"3-Z_秋田　翔_プリント1",null,"3-Z_伊藤　望結_プリント1",null,"3-Z_茨城　愛美_プリント1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"転入用  空白行(連続行)の用意\n一人ひとり\nコード作成以外は手作業で"]

{"sheet":"点検シート","index":4,"n_rows":44,"n_cols":25,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,9,0,10],[0,12,0,13],[0,15,0,16],[0,18,0,19]]}
[null,null,null,"3-Z",{"$f":"COUNTA(E3:E43)","v":4},"通常この列は非表示",{"$f":"IF(QR一覧!L3<>\"\",QR一覧!L3,\"\")","v":"漢字ド"},null,"通常この列は非表示",{"$f":"IF(QR一覧!M3<>\"\",QR一覧!M3,\"\")","v":"日記"},null,"通常この列は非表示",{"$f":"IF(QR一覧!N3<>\"\",QR一覧!N3,\"\")","v":"プリント1"},null,"通常この列は非表示",{"$f":"IF(QR一覧!O3<>\"\",QR一覧!O3,\"\")","v":""},null,"通常この列は非表示",{"$f":"IF(QR一覧!P3<>\"\",QR一覧!P3,\"\")","v":""},null,"←前のシートから自動で入る",null,"漢字ド"]
[null,"予備","回収数","番号","名前\n転出も抜かない",null,"提出","日時",null,"提出","日時",null,"提出","日時",null,"提出","日時",null,"提出","日時",{"$f":"TODAY()","v":"2023-10-12"}]
[null,{"$f":"IFERROR(AVERAGEIF(G3:BF3,\"<=100\",G3:BF3),\"\")","v":""},{"$f":"COUNTIF(G3:T3,\"〇\")","v":0},1,"青森　海斗","Nt12kRgWLjH",null,null,"Nt2KTrf83pN",null,null,"Nt3nyPXyX8M",null,null,null,null,null,null,null,null,null,null,null,{"$f":"G1","v":"漢字ド"}]
[null,"",{"$f":"SUMIF(G4:BF4,\"<=100\",G4:BF4)","v":0},2,"秋田　翔","Nt16ZNykS2W",null,null,"Nt2Yp8hhBJV",null,null,"Nt3JtVPCnBv",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J1<>\"\",J1,\"\")","v":"日記"}]
[null,"",0,3,"伊藤　望結","Nt1tKdnySbF",null,null,"Nt2PJBXHDRg",null,null,"Nt3Tcxt4GZg",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M1<>\"\",M1,\"\")","v":"プリント1"},"　←間違って押したときは　0　を押してください！"]
[null,"",0,4,"茨城　愛美","Nt12M93HJr3",null,null,"Nt2KGqwB5cH",null,null,"Nt3DBH5ZSt9",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P1<>\"\",P1,\"\")","v":""}]
[null,"",0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S1<>\"\",S1,\"\")","v":""}]
[null,"",0,6]
[null,"",0,7]
[null,"",0,8]
[null,"",0,9]
[null,"",0,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"非表示列"]
[null,"",0,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,"",0,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,"",0,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F"]
[null,"",0,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I"]
[null,"",0,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[null,"",0,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O"]
[null,"",0,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R"]
[null,"",0,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[null,"",0,19]
[null,"",0,20]
[null,"",null,21]
[null,"",null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,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]
[null,null,null,41]
[null,null,null,null,"合計",null,{"$f":"COUNTA(G3:G43)","v":0},null,null,{"$f":"COUNTA(J3:J43)","v":0},null,null,{"$f":"COUNTA(M3:M43)","v":0},null,null,{"$f":"COUNTA(P3:P43)","v":0},null,null,{"$f":"COUNTA(S3:S43)","v":0}]