{"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 中","利润位于左侧",{"$f":"每月净收入-每月净支出","v":{"v":637.5,"d":"¥638"}}]
[null,"收入支出百分比",{"$f":"每月净支出/每月净收入","v":{"v":0.7681818181818182,"d":"¥1"}}]
[]
[null,"每月净收入",{"$f":"每月收入[[#Totals],[金额]]","v":{"v":2750,"d":"¥2,750"}}]
["每月净费用包括学期费用除以学期长度（按月计）","每月净支出",{"$f":"每月支出[[#Totals],[金额]]+学期费用[[#Totals],[每月]]","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,"每月收入",null,null,"每月支出",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,"项目​​","金额","每月"]
[null,"贷款",{"v":500,"d":"¥500"},null,"移动电话",{"v":75,"d":"¥75"},null,"学费",{"v":750,"d":"¥750"},{"$f":"学期费用[[#This Row],[金额]]/Months_in_semester","v":{"v":187.5,"d":"¥188"}}]
[null,"其他收入",{"v":250,"d":"¥250"},null,"日用杂货",{"v":250,"d":"¥250"},null,"实验室费用",{"v":300,"d":"¥300"},{"$f":"学期费用[[#This Row],[金额]]/Months_in_semester","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],[金额]]/Months_in_semester","v":{"v":125,"d":"¥125"}}]
[{"$nulls":4},"学生贷款",{"v":500,"d":"¥500"},null,"存款",{"v":0,"d":"¥0"},{"$f":"学期费用[[#This Row],[金额]]/Months_in_semester","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"信用卡",{"v":275,"d":"¥275"},null,"交通费",{"v":0,"d":"¥0"},{"$f":"学期费用[[#This Row],[金额]]/Months_in_semester","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"保险",{"v":125,"d":"¥125"},null,"其他费用",{"v":0,"d":"¥0"},{"$f":"学期费用[[#This Row],[金额]]/Months_in_semester","v":{"v":0,"d":"¥0"}}]
[{"$nulls":4},"理发",{"v":50,"d":"¥50"},null,"汇总",{"$f":"SUBTOTAL(109,学期费用[金额])","v":{"v":1550,"d":"¥1,550"}},{"$f":"SUBTOTAL(109,学期费用[每月])","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"}}]