{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["期間","単位","予算","1 か月の純支出","学期の支出","書籍"],"not_rendered":{"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"期間","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[2,3,2,4]]}
[null,"自分のクラスのスケジュール"]
[null,"秋学期"]
[null,null,"開始時刻","時間間隔",null,"年"]
[null,null,"09:00:00",60,"(分単位)"]
[null,"時刻 ","月","火","水","木","金","土","日"]
[null,{"$f":"StartTime+TIME(0,(ROW(A1)-1)*TimeInterval,0)","v":"09:00:00"},"朝食","朝食","朝食","朝食","朝食"]
[null,"10:00:00","ビジネス:講義 B 館、256 教室"]
[null,"11:00:00",{"$nulls":3},"物理学:実験\nJ 館、309 教室"]
[null,"12:00:00"]
[null,"13:00:00"]
[null,"14:00:00"]
[null,"15:00:00"]
[null,"16:00:00"]
[null,"17:00:00"]
[null,"18:00:00"]
[null,"19:00:00"]
[null,"20:00:00"]
[null,"21:00:00"]
[null,"22:00:00"]
[null,"23:00:00"]
[null,1]
[null,1.0416666666666665]
[null,1.0833333333333335]
[null,1.125]
[null,1.1666666666666665]
[null,1.2083333333333335]
[null,1.25]
[null,1.2916666666666665]
[null,1.3333333333333335]

{"sheet":"単位","index":1,"n_rows":17,"n_cols":8,"rows_kept":17}
[null,"大学"]
[null,"履修単位計画シート"]
[null,"学位名",{"$f":"年","v":"年"}]
[null,"全体の進行状況",null,"全体の進行状況"]
[null,{"$f":"AVERAGE(コース[成績])","v":3.5},{"$f":"IFERROR(TEXT(AVERAGEIF(コース[修了],\"はい\",コース[成績]),\"0.00\"),\"0.00\")&\" 現在の GPA\"","v":"3.50 現在の GPA"},{"$f":"COUNTIF(コース[修了],\"はい\")/COUNTA(コース[科目名])","v":0.6666666666666666},{"$f":"TEXT(COUNTIF(コース[修了],\"はい\")/COUNTA(コース[科目名]),\"0%\")&\" 完了\"","v":"67% 完了"}]
[null,"注:以下の履修単位要項は、下の [大学のコース] 表に入力すると自動的に表示されます"]
[null,"必修","合計履修単位","修得","残り"]
[null,"専攻",{"$f":"IF(SUMIF(コース[必修],単位!$B8,コース[単位])=0,\"0\",SUMIF(コース[必修],単位!$B8,コース[単位]))","v":4},{"$f":"SUMIFS(コース[単位],コース[必修],単位!$B8,コース[修了],\"はい\")","v":4},{"$f":"SUMIF(コース[必修],単位!$B8,コース[単位])-SUMIFS(コース[単位],コース[必修],単位!$B8,コース[修了],\"はい\")","v":0}]
[null,"副専攻",{"$f":"IF(SUMIF(コース[必修],単位!$B9,コース[単位])=0,\"0\",SUMIF(コース[必修],単位!$B9,コース[単位]))","v":3},{"$f":"SUMIFS(コース[単位],コース[必修],単位!$B9,コース[修了],\"はい\")","v":0},{"$f":"SUMIF(コース[必修],単位!$B9,コース[単位])-SUMIFS(コース[単位],コース[必修],単位!$B9,コース[修了],\"はい\")","v":3}]
[null,"選択科目",{"$f":"IF(SUMIF(コース[必修],単位!$B10,コース[単位])=0,\"0\",SUMIF(コース[必修],単位!$B10,コース[単位]))","v":2},{"$f":"SUMIFS(コース[単位],コース[必修],単位!$B10,コース[修了],\"はい\")","v":2},{"$f":"SUMIF(コース[必修],単位!$B10,コース[単位])-SUMIFS(コース[単位],コース[必修],単位!$B10,コース[修了],\"はい\")","v":0}]
[null,"一般教養",{"$f":"IF(SUMIF(コース[必修],単位!$B11,コース[単位])=0,\"0\",SUMIF(コース[必修],単位!$B11,コース[単位]))","v":"0"},{"$f":"SUMIFS(コース[単位],コース[必修],単位!$B11,コース[修了],\"はい\")","v":0},{"$f":"SUMIF(コース[必修],単位!$B11,コース[単位])-SUMIFS(コース[単位],コース[必修],単位!$B11,コース[修了],\"はい\")","v":0}]
[null,"合計",{"$f":"SUBTOTAL(109,単位!$C$8:$C$11)","v":9},{"$f":"SUBTOTAL(109,単位!$D$8:$D$11)","v":6},{"$f":"SUBTOTAL(109,単位!$E$8:$E$11)","v":3}]
[null,"コース"]
[null,"科目名","科目番号","必修","単位","修了","成績","学期"]
[null,"科目 1","番号","専攻",4,"はい",{"v":4,"d":"4.0"},"1 学期"]
[null,"科目 2","番号","副専攻",3,"いいえ",null,"1 学期"]
[null,"科目 3","番号","選択科目",2,"はい",{"v":3,"d":"3.0"},"1 学期"]

{"sheet":"予算","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
[null,{"$f":"大学","v":"大学"}]
[null,"予算管理機能"]
[null,"自分の予算",{"$f":"年","v":"年"}]
[null,"収入に占める支出の割合"]
[null,{"v":0.7454545454545455,"d":"75%"}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"1 か月の純収入","1 か月の純支出","残高"]
[null,{"$f":"C10","v":{"v":2750,"d":"¥2,750"}},{"$f":"'1 か月の純支出'!C4+学期の支出!D4","v":{"v":2050,"d":"¥2,050"}},{"v":700,"d":"¥700"}]
[null,"学期内の月数",4]
[null,"1 か月の収入",{"$f":"SUM(MonthlyIncome[金額])","v":{"v":2750,"d":"¥2,750"}}]
[null,"項目","金額"]
[null,"固定収入",{"v":1500,"d":"¥1,500"}]
[null,"学資援助",{"v":500,"d":"¥500"}]
[null,"ローン",{"v":500,"d":"¥500"}]
[null,"その他の収入",{"v":250,"d":"¥250"}]

{"sheet":"1 か月の純支出","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"大学","v":"大学"}]
[null,"予算管理機能"]
[null,"1 か月の支出",{"$f":"年","v":"年"}]
[null,"1 か月の支出",{"$f":"SUM(MonthlyExpenses[金額])","v":{"v":1675,"d":"¥1,675"}}]
[null,"項目","金額"]
[null,"貸借料",{"v":300,"d":"¥300"}]
[null,"水道光熱費",{"v":50,"d":"¥50"}]
[null,"携帯電話",{"v":75,"d":"¥75"}]
[null,"食料品",{"v":250,"d":"¥250"}]
[null,"自動車関連費用",{"v":50,"d":"¥50"}]
[null,"学生ローン",{"v":500,"d":"¥500"}]
[null,"クレジット カードの支払い",{"v":275,"d":"¥275"}]
[null,"保険料",{"v":125,"d":"¥125"}]
[null,"娯楽",{"v":50,"d":"¥50"}]
[null,"雑費",{"v":0,"d":"¥0"}]

{"sheet":"学期の支出","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"大学","v":"大学"}]
[null,"予算管理機能"]
[null,"学期の支出",{"$f":"年","v":"年"}]
[null,"学期の支出 (合計/1 か月あたり)",{"$f":"SUM(TermExpenses[金額])","v":{"v":1500,"d":"¥1,500"}},{"$f":"SUM(TermExpenses[1 か月あたり])","v":{"v":375,"d":"¥375"}}]
[null,"項目","金額","1 か月あたり"]
[null,"授業料",{"v":750,"d":"¥750"},{"$f":"TermExpenses[[#This Row],[金額]]/学期中_の_月数","v":{"v":187.5,"d":"¥188"}}]
[null,"実習料",{"v":250,"d":"¥250"},{"$f":"TermExpenses[[#This Row],[金額]]/学期中_の_月数","v":{"v":62.5,"d":"¥63"}}]
[null,"書籍",{"v":500,"d":"¥500"},{"$f":"TermExpenses[[#This Row],[金額]]/学期中_の_月数","v":{"v":125,"d":"¥125"}}]
[null,"預金",{"v":0,"d":"¥0"},{"$f":"TermExpenses[[#This Row],[金額]]/学期中_の_月数","v":{"v":0,"d":"¥0"}}]
[null,"交通費",{"v":0,"d":"¥0"},{"$f":"TermExpenses[[#This Row],[金額]]/学期中_の_月数","v":{"v":0,"d":"¥0"}}]
[null,"その他の費用",{"v":0,"d":"¥0"},{"$f":"TermExpenses[[#This Row],[金額]]/学期中_の_月数","v":{"v":0,"d":"¥0"}}]

{"sheet":"書籍","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"大学","v":"大学"}]
[null,"書籍管理機能"]
[null,"書籍リスト"]
[null,"タイトル","著者","科目","購入先","ISBN","メモ"]
[null,"書名","著者","科目","場所","番号"]
[null,"書名","著者","科目","場所","番号"]
[null,"書名","著者","科目","場所","番号"]