{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["如何使用此工作簿","成绩册"],"not_rendered":{"defined_names":7},"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. 从单元格 H8 开始填写作业、测验或测试名称（如“测验 1”）以及每个作业所值的绩点。 "]
[null,"4. 填写每个写生每次作业或测试的得分。“平均分”、“得分”、“LTR 等级”和“学分”列将会自动计算，但是，可以视需要覆盖它们。若要奖励额外加分，只需在为相应作业所列出的满分上赋予某个作业更高分。"]
[null,"如果需要，可使用“页面布局”菜单上的“打印区域”命令更改打印区域。"]
[null,"学分得分基于行 8 和 9 中指定的总点数的标准百分比率。将每个作业或测试调整至所需的点数，然后调整百分比及相应的分数。覆盖得分单元格，以手动进行更改。"]
[null,"在单元格 H8 到 X9 中输入每个作业、测验或测试以及所值的点数。"]

{"sheet":"成绩册","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[1,1,2,6],[3,1,3,6],[4,1,6,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[11,4,11,6],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4]]}
[null,"学校名称"]
[null,"教师姓名"]
[{"$nulls":7},"得分",{"$f":"I4*TotalPoints","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"课堂/科目",{"$nulls":5},"所占百分比",{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.728333333333333,"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%"}]
[null,"年份/学期/季度",{"$nulls":5},"LTR 等级","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":7},"学分",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"作业或测试名称",null,null,"HW1","HW2","Q1"]
[{"$nulls":4},"总分",null,null,50,50,100]
[]
[{"$nulls":4},"作业和测试总数：",null,null,{"$f":"COUNTA(H8:AH8)","v":3}]
[{"$nulls":4},"总点数：",null,null,{"$f":"SUM(H9:AH9)","v":200}]
[]
[null,"学生姓名","学生 ID","平均分","得分","LTR 等级","学分","列 6","列 7","列 8","列 9","列 10","列 11","列 12","列 13","列 14","列 15","列 16","列 17","列 18","列 19","列 20","列 21","列 22"]
[null,"学生编号 1",null,{"$f":"IFERROR(IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]])/TotalPoints),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]]))","v":182},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,3),\"\"),0)","v":"A-"},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,4),\"\"),0)","v":3.67},45,45,92]
[null,"学生总数",null,{"$f":"IFERROR(IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]])/TotalPoints),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]]))","v":200},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,3),\"\"),0)","v":"A+"},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]]))","v":""},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]]))","v":""},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(成绩[[#This Row],[列 6]:[列 22]])=0,\"\",SUM(成绩[[#This Row],[列 6]:[列 22]]))","v":""},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(成绩[[#This Row],[平均分]]<>\"\",HLOOKUP(成绩[[#This Row],[平均分]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[]
[null,"班级汇总",null,"平均分",null,"LTR 等级","学分","","","","","","","","","","",""]
[null," 平均分",null,{"$f":"IFERROR(AVERAGE(成绩[[#All],[平均分]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*TotalPoints,GradeTable,3),\"\")","v":"A"},{"$f":"IFERROR(AVERAGE(成绩[[#All],[学分]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," 最高分",null,{"$f":"IFERROR(MAX(成绩[[#All],[平均分]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*TotalPoints,GradeTable,3),\"\")","v":"A+"},{"$f":"IFERROR(MAX(成绩[[#All],[学分]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," 最低分",null,{"$f":"IFERROR(MIN(成绩[[#All],[平均分]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*TotalPoints,GradeTable,3),\"\")","v":"A-"},{"$f":"IFERROR(MIN(成绩[[#All],[学分]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]