{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["大学生の生活費","収入と支出","計算"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"大学生の生活費","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[1,2,1,9]]}
["このワークシートに大学の予算を作成します。\n次のヒントはセル A4 にあります。"]
[null,null,"大学生の生活費"]
[]
["収入と支出のワークシートにデータを入力します。\nこのシートの計算はすべて自動的にカウントされます。\n次のヒントはセル A8 にあります。","残りの収入",{"v":637.5,"d":"¥638"}]
[null,"収入に占める支出の割合",{"v":0.7681818181818182,"d":"¥1"}]
[]
[null,"1 か月の純収入",{"$f":"毎月_収入[[#Totals],[金額]]","v":{"v":2750,"d":"¥2,750"}}]
["1 か月の純支出には、学期の支出を学期の長さで割ったもの (月) が含まれます。","1 か月の純支出",{"$f":"毎月_支出[[#Totals],[金額]]+学期_支出[[#Totals],[1 か月あたり]]","v":{"v":2112.5,"d":"¥2,113"}}]

{"sheet":"収入と支出","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"merged":[[1,1,1,2],[1,4,1,5],[1,7,1,9],[3,7,3,8]]}
["このシートの表に、収入と支出のすべてを入力します。\n学期の長さ (月) をセル J4 に入力します。"]
[null,"1 か月の収入",null,null,"1 か月の支出",null,null,"学期の支出"]
[]
[null,"項目","金額",null,"項目","金額",null,"学期の長さ (月) を入力します:",null,4]
[null,"固定収入",{"v":1500,"d":"¥1,500"},null,"家賃",{"v":350,"d":"¥350"}]
[null,"学資援助",{"v":500,"d":"¥500"},null,"水道光熱費",{"v":50,"d":"¥50"},null,"項目","金額","1 か月あたり"]
[null,"ローン",{"v":500,"d":"¥500"},null,"携帯電話",{"v":75,"d":"¥75"},null,"授業料",{"v":750,"d":"¥750"},{"$f":"学期_支出[[#This Row],[金額]]/学期_内_月","v":{"v":187.5,"d":"¥188"}}]
[null,"その他の収入",{"v":250,"d":"¥250"},null,"食料品",{"v":250,"d":"¥250"},null,"実習料",{"v":300,"d":"¥300"},{"$f":"学期_支出[[#This Row],[金額]]/学期_内_月","v":{"v":75,"d":"¥75"}}]
[null,"集計",{"$f":"SUBTOTAL(109,毎月_収入[金額])","v":{"v":2750,"d":"¥2,750"}},null,"自動車関連費用",{"v":50,"d":"¥50"},null,"書籍",{"v":500,"d":"¥500"},{"$f":"学期_支出[[#This Row],[金額]]/学期_内_月","v":{"v":125,"d":"¥125"}}]
[{"$nulls":4},"学生ローン",{"v":500,"d":"¥500"},null,"預金",{"v":0,"d":"¥0"},{"$f":"学期_支出[[#This Row],[金額]]/学期_内_月","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"クレジット カードの支払い",{"v":275,"d":"¥275"},null,"交通費",{"v":0,"d":"¥0"},{"$f":"学期_支出[[#This Row],[金額]]/学期_内_月","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"保険料",{"v":125,"d":"¥125"},null,"その他の費用",{"v":0,"d":"¥0"},{"$f":"学期_支出[[#This Row],[金額]]/学期_内_月","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"整髪代",{"v":50,"d":"¥50"},null,"集計",{"$f":"SUBTOTAL(109,学期_支出[金額])","v":{"v":1550,"d":"¥1,550"}},{"$f":"SUBTOTAL(109,学期_支出[1 か月あたり])","v":{"v":387.5,"d":"¥388"}}]
[{"$nulls":4},"娯楽",{"v":0,"d":"¥0"}]
[{"$nulls":4},"雑費",{"v":0,"d":"¥0"}]
[{"$nulls":4},"集計",{"$f":"SUBTOTAL(109,毎月_支出[金額])","v":{"v":1725,"d":"¥1,725"}}]

{"sheet":"計算","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["収入",{"$f":"大学生の生活費!C7","v":{"v":2750,"d":"¥2,750"}}]
["支出",{"$f":"大学生の生活費!C8","v":{"v":2112.5,"d":"¥2,113"}}]