{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["如何使用此工作簿","成绩簿"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"如何使用此工作簿","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[]
[null,"当所有作业对最终成绩的贡献相同时，可使用此成绩簿来计算成绩。"]
[null,"说明：请务必保存成绩单副本，以防万一。"]
[null,"1. 填写学校名称、班级信息、学生姓名和学生 ID（可选）。   "]
[null,"2. 调整成绩与学分表格，使其与你使用的典型计分系统匹配。"]
[null,"3. 在成绩簿工作表中从单元格 H7 开始填入作业名称（例如“测验 1”）和成绩，可根据需要一直向右填入内容。“平均分”、“字母成绩”、“学分绩点”和“缺失”列将会自动计算，但是，可以视需要覆盖它们。“缺失”列显示学生尚未获得成绩的作业数量。"]
[null,"注意：打印区域是动态的，不会显示成绩表和作业区域。如果要更改打印区域，可使用“页面布局”选项卡上的“打印区域”命令。 "]

{"sheet":"成绩簿","index":1,"n_rows":9,"n_cols":21,"rows_kept":9,"merged":[[1,1,3,3],[1,4,1,6],[2,4,2,6],[3,4,3,6]]}
[{"$nulls":7},"第 1 列","列 2","列3","列 4","列 5","列 6","列 7","列 8","列 9","列 10","列 11","列 12","列 13","列 14"]
[null,"Rowan Vista 高中",null,null,"2022年/秋季/第二季度",null,null,"平均水平",0,0.6,0.63,0.67,0.7,0.73,0.77,0.8,0.83,0.87,0.9,0.93,0.97]
[{"$nulls":4},"社交研究/高级项目",null,null,"字母成绩","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":4},"讲师：Vishakha Ranade",null,null,"学分绩点",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[null,"学生姓名","学生 ID","平均水平","成绩","学分绩点","缺失","任务 1","任务 2","测验 1","测验 2","测试 1","任务 3","作业 4","测验 3","测试 2","列 10","列 11","列 12","列 13","列 1"]
[null,"Jozi Kos",1234,{"$f":"IFERROR(AVERAGE(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers]))),\"\")","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"LOOKUP(数据[[#This Row],[平均水平]],GradeAvg,GradeLetter)","v":"A-"},{"$f":"LOOKUP(数据[[#This Row],[平均水平]],GradeAvg,GradeGPA)","v":3.67},{"$f":"IF(COUNTA(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers])))=0,\"\",COUNTA(数据[[#Headers],[任务 1]]:INDEX(数据[#Headers],1,COUNTA(数据[#Headers])))-COUNTA(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers]))))","v":11},0.88,0.95,0.92]
[null,"Guy Oz",5678,{"$f":"IFERROR(AVERAGE(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers]))),\"\")","v":{"v":0.7133333333333334,"d":"0.71"}},{"$f":"LOOKUP(数据[[#This Row],[平均水平]],GradeAvg,GradeLetter)","v":"C-"},{"$f":"LOOKUP(数据[[#This Row],[平均水平]],GradeAvg,GradeGPA)","v":1.67},{"$f":"IF(COUNTA(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers])))=0,\"\",COUNTA(数据[[#Headers],[任务 1]]:INDEX(数据[#Headers],1,COUNTA(数据[#Headers])))-COUNTA(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers]))))","v":11},0.75,0.71,0.68]
[null,"Henry Ross",9876,{"$f":"IFERROR(AVERAGE(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers]))),\"\")","v":{"v":0.7933333333333333,"d":"0.79"}},{"$f":"LOOKUP(数据[[#This Row],[平均水平]],GradeAvg,GradeLetter)","v":"C+"},{"$f":"LOOKUP(数据[[#This Row],[平均水平]],GradeAvg,GradeGPA)","v":2.33},{"$f":"IF(COUNTA(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers])))=0,\"\",COUNTA(数据[[#Headers],[任务 1]]:INDEX(数据[#Headers],1,COUNTA(数据[#Headers])))-COUNTA(数据[[#This Row],[任务 1]]:INDEX(数据[],ROW(数据[[#This Row],[任务 1]])-ROW(数据[[#Headers],[平均水平]]),COUNTA(数据[#Headers]))))","v":11},0.72,0.81,0.85]