{"text_format":"1","workbook":"xlsx","n_sheets":8,"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":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["A","あ"]
["B","い"]
["C","う"]
["D","え"]
["E","お"]
["F","か"]
["G","き"]
["H","く"]
["I","け"]
["H","こ"]

{"sheet":"合計と平均","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["名前","得点","得点","計算補助用"]
["A",100,100,{"$f":"IF(C2>=60,C2,\"\")","v":100}]
["B",90,90,90]
["C",89,"欠","欠"]
["D",80,80,80]
["E",79,79,79]
["G",70,"欠","欠"]
["H",69,69,69]
["I",60,60,60]
["J",59,59,""]
["K",50,50,""]
["L",30,"欠","欠"]
["M",0,0,""]
[]
["人数"]
["合計"]
["平均"]
[]
[]
["人数（関数）",{"$f":"COUNT(B2:B13)","v":12},{"$f":"COUNT(C2:C13)","v":9},{"$f":"COUNT(D2:D13)","v":6}]
["合計（関数）",{"$f":"SUM(B2:B13)","v":776},{"$f":"SUM(C2:C13)","v":587},{"$f":"SUM(D2:D13)","v":478}]
["平均（関数）",{"$f":"AVERAGE(B2:B13)","v":64.666666666666671},{"$f":"AVERAGE(C2:C13)","v":65.222222222222229},{"$f":"AVERAGE(D2:D13)","v":79.666666666666671}]
[]
[null,null,{"$f":"COUNTIF(C2:C13,\">=60\")","v":6}]
[null,null,{"$f":"SUMIF(C2:C13,\">=60\")","v":478}]
[null,null,{"$f":"AVERAGEIF(C2:C13,\">=60\")","v":79.666666666666671}]

{"sheet":"最大と最小","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["名前","得点",null,null,null,"得点"]
["A",29]
["B",58]
["C",44]
["D",67]
["E",98]
["F",14]
["G",75]
["H",98]
["I",32]
["J",61]
["K",87]
["L",90]
["M",86]
["N",80]
[null,null,"名前↓"]
["最小"]
["最大"]
[]
["最小（関数使用）",{"$f":"MIN(B2:B15)","v":14},{"$f":"MIN(F2:F15)","v":0}]
["最大（関数使用）",{"$f":"MAX(B2:B15)","v":98},{"$f":"MAX(F2:F15)","v":0}]

{"sheet":"名前詰め","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["名前","名前（空白なし）"]
["青木"]
["井口"]
["宇野"]
["江藤"]
[]
["加藤"]
["木村"]
[]
["監物"]
["小泉"]
["佐藤"]
["清水"]
[]
["世良"]
["園田"]
["田中"]
[]
["津田"]
["手島"]
[]
["中村"]
[]
["額田"]
["根津"]
["野田"]

{"sheet":"班分け","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["名前","班1","班2"]
["A"]
["B"]
["C"]
["D",null,1]
["E"]
["F"]
["G",null,1]
["H"]
["I"]
["J"]
["K"]
["L",null,1]
["M"]
["N"]

{"sheet":"模様","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"並べ替え","index":6,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["なまえ",null,null,"1班","2班","3班","4班"]
["青木"]
["井口"]
["宇野"]
["江藤"]
["岡本"]
["加藤"]
["木村"]
["工藤"]
["監物"]
["小泉"]
["佐藤"]
["清水"]
["須藤"]
["世良"]
["園田"]
["田中"]
["千田"]
["津田"]
["手島"]
["戸田"]
["中村"]
["新田"]
["額田"]
["根津"]
["野田"]

{"sheet":"カレンダー","index":7,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["日","月","火","水","木","金","土"]