{"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.填入學校名稱、課程資訊、學生姓名和學生學號 (選填)。   "]
[null,"2.將 [成績與 GPA] 表格調整為您一般使用的計分系統。"]
[null,"3.填入作業名稱(如「測驗 1」)，並在 [成績簿] 工作表的儲存格 H7 開始填入成績，想填幾個都可以。「平均分數」、「等級分數」、「GPA」和「缺交」會自動計算，但您可以依需要覆寫這些值。「缺交」欄表示學生未得到成績的作業數。"]
[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]]}
[]
[null,"學校名稱",null,null,"學年/學期/學季",null,null,"平均分數",{"v":0,"d":"0.00"},{"v":0.6,"d":"0.60"},0.63,0.67,{"v":0.7,"d":"0.70"},0.73,0.77,{"v":0.8,"d":"0.80"},0.83,0.87,{"v":0.9,"d":"0.90"},0.93,0.97]
[{"$nulls":4},"課程/專案",null,null,"等級分數","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":4},"教師姓名",null,null,"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[null,"學生姓名","學生學號","平均分數","成績","GPA","缺交","作業 1","作業 2","測驗 1","測驗 2","考試 1","作業 3","作業 4","測驗 3","考試 2","欄10","欄11","欄12","欄13","欄14"]
[null,"姓名 1",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(_xlfn.SINGLE(資料[[#This Row],[平均分數]]),成績平均,成績字母)","v":"A-"},{"$f":"LOOKUP(_xlfn.SINGLE(資料[[#This Row],[平均分數]]),成績平均,成績GPA)","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,"姓名 2",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(_xlfn.SINGLE(資料[[#This Row],[平均分數]]),成績平均,成績字母)","v":"C-"},{"$f":"LOOKUP(_xlfn.SINGLE(資料[[#This Row],[平均分數]]),成績平均,成績GPA)","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,"姓名 3",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(_xlfn.SINGLE(資料[[#This Row],[平均分數]]),成績平均,成績字母)","v":"C+"},{"$f":"LOOKUP(_xlfn.SINGLE(資料[[#This Row],[平均分數]]),成績平均,成績GPA)","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]