{"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.使用する一般的な採点システムに対応するようグレード/GPA テーブルを調整します。"]
[null,"3.セル G7 から順に、課題またはテスト名、およびそれぞれがどのパーセンテージ (\"最終\"、\"50%\" など) に該当するかを入力します。 "]
[null,"4.課題またはテストごとに、各学生のスコアを入力します。[スコア]、[レター グレード]、[GPA] の各列は自動的に計算されますが、必要に応じて上書きできます。グレードの計算方法によれば、すべてのスコアが入力されるまでは、平均と最終的なグレードは不完全です。"]
[null,"印刷する領域を変更する場合は、[ページ レイアウト] メニューの [印刷範囲] コマンドを使用します。"]
[null,"すべてのテストと課題が完了するまで、[スコア]、[レター グレード]、[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,"学生の名前","学生 ID","スコア","レター グレード","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},"","","","","","","","","","","","","","","","",""]