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

{"sheet":"如何使用此工作簿","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"说明"]
[null,"使用该“成绩册”工作表来计算成绩，其中每项作业都有一定分值。 "]
[null,"说明：请务必保存成绩单副本。"]
[null,"1.填写学校名称、班级信息、学生姓名和学生 ID（可选）。   "]
[null,"2.调整成绩与学分表格，使其与你使用的典型计分系统匹配。"]
[null,"3.从单元格 G7 开始填写作业或测试名称，以及各自对应的百分比（如“期终”和“50%”）。 "]
[null,"4.填写每个写生每次作业或测试的得分。“得分”、“LTR 等级”和“学分”列将会自动计算，但是，可以视需要覆盖它们。在所有得分填写完毕之前，计算成绩的方式、平均分和最终成绩是不完整的。"]
[null,"如果需要，可使用“页面布局”菜单上的“打印区域”命令更改打印区域。"]
[null,"在所有测试和作业填写完整之前，得分、LTR 等级和学分无效。 "]
[null,"在单元格 G7 到 W8 中输入每次作业或测试及其占总成绩的百分比。"]

{"sheet":"成绩册","index":1,"n_rows":20,"n_cols":23,"rows_kept":20,"merged":[[5,1,5,5],[6,1,6,3],[6,4,6,5],[7,1,8,3],[7,4,7,5],[8,4,8,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"上塔尔博特高中"]
[]
[{"$nulls":6},"得分",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[{"$nulls":6},"LTR 等级","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"学分",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Ayano Harada"]
[null,"世界历史 II",null,null,"作业"]
[null,"2023 年春季学期",null,null,"百分比（总和应为 100%）"]
[{"$nulls":4},{"$f":"\"总百分比: \"&SUM(G8:BZ8)*100&\"%\"","v":"总百分比: 0%"}]
[null,"学生姓名","学生 ID","得分","LTR 等级","学分","列 6","列 7","列 8","列 9","列 10","列 11","列 12","列 13","列 14","列 15","列 16","列 17","列 18","列 19","列 20","列 21","列 22"]
[null,"Gianni Castiglione",654987,{"$f":"(IF(SUM(成绩[[#This Row],[列 6]:[列 22]]),ROUND(SUMPRODUCT($G$8:$W$8,成绩[[#This Row],[列 6]:[列 22]]),2),\"\"))","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,2),\"\")","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,3),\"\")","v":""}]
[null,"Nat Rattanakoson",134698,{"$f":"(IF(SUM(成绩[[#This Row],[列 6]:[列 22]]),ROUND(SUMPRODUCT($G$8:$W$8,成绩[[#This Row],[列 6]:[列 22]]),2),\"\"))","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,2),\"\")","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,3),\"\")","v":""}]
[null,"Juan Morgan",613467,{"$f":"(IF(SUM(成绩[[#This Row],[列 6]:[列 22]]),ROUND(SUMPRODUCT($G$8:$W$8,成绩[[#This Row],[列 6]:[列 22]]),2),\"\"))","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,2),\"\")","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(成绩[[#This Row],[列 6]:[列 22]]),ROUND(SUMPRODUCT($G$8:$W$8,成绩[[#This Row],[列 6]:[列 22]]),2),\"\"))","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,2),\"\")","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(成绩[[#This Row],[列 6]:[列 22]]),ROUND(SUMPRODUCT($G$8:$W$8,成绩[[#This Row],[列 6]:[列 22]]),2),\"\"))","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,2),\"\")","v":""},{"$f":"IF(成绩[[#This Row],[得分]]<>\"\",HLOOKUP(成绩[[#This Row],[得分]],成绩表,3),\"\")","v":""}]
[]
[null,"班级汇总",null,"得分","LTR 等级","学分","","","","","","","","","","",""]
[null," 平均分",null,{"$f":"IFERROR(AVERAGE(成绩[[#All],[得分]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,成绩表,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(成绩[[#All],[学分]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," 最高分",null,{"$f":"IFERROR(MAX(成绩[[#All],[得分]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,成绩表,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(成绩[[#All],[学分]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," 最低分",null,{"$f":"IFERROR(MIN(成绩[[#All],[得分]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,成绩表,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(成绩[[#All],[学分]]),0)","v":0},"","","","","","","","","","","","","","","","",""]