{"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.填入學校名稱、課程資訊、學生姓名和學生學號 (選填)。   "]
[null,"2.將 [成績與 GPA] 表格調整為您一般使用的計分系統。"]
[null,"3.從儲存格 G7 開始填入作業或考試名稱，以及每項作業或考試應得的百分比分數 (如「期末考」和 \"50%\")。 "]
[null,"4.在每項作業或考試中，填入每位學生得到的分數。「分數」、「等級分數」和「GPA」會自動計算，但您可以依需要覆寫這些值。輸入成績後，工作表才會計算成績，並完成平均分數和最後成績。"]
[null,"如果想變更列印範圍，可使用 [版面配置] 功能表上的 [列印範圍] 命令。"]
[null,"在考試和作業 100% 完成後，「分數」、「等級分數」和「GPA」才有效。 "]
[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],[15,1,15,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},"等級分數","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"教師姓名"]
[null,"課程/專案",null,null,"作業或考試名稱"]
[null,"學年/學期/學季",null,null,"百分比 (總計應為 100%)"]
[{"$nulls":4},{"$f":"\"總百分比: \"&SUM(G8:W8)*100&\"%\"","v":"總百分比: 0%"}]
[null,"學生姓名","學生學號","分數","等級分數","GPA","欄6","欄7","欄8","欄9","欄10","欄11","欄12","欄13","欄14","欄15","欄16","欄17","欄18","欄19","欄20","欄21","欄22"]
[{"$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":""}]
[{"$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":""}]
[{"$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,"分數","等級分數","GPA","","","","","","","","","","",""]
[null," 平均分數",null,{"$f":"IFERROR(AVERAGE(成績[[#All],[分數]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,成績表,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(成績[[#All],[GPA]]),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],[GPA]]),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],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]