{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["预算摘要","每月收入","每月支出","学期费用"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"预算摘要","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,4,9,4],[3,1,3,2]]}
[null,"我的大学预算"]
[null,"收支百分比",null,null,"此单元格中包含簇状柱形图，用于比较每月收入和支出。"]
[null,{"$f":"每月净支出/每月净收入","v":{"v":0.6436363636363637,"d":"¥1"}}]
[null,{"$f":"每月净支出","v":1770}]
[null,"每月净收入"]
[null,{"$f":"每月总收入","v":{"v":2750,"d":"¥2,750"}}]
[null,"每月净支出"]
[null,{"$f":"每月总支出+学期总费用","v":{"v":1770,"d":"¥1,770"}}]
[null,"余额"]
[null,{"$f":"每月净收入-每月净支出","v":{"v":980,"d":"¥980"}}]

{"sheet":"每月收入","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,4]]}
[null,{"$f":"工作簿标题","v":"我的大学预算"}]
[null,"每月收入"]
[null,"项目​​","金额"]
[null,"固定收入",{"v":1500,"d":"¥1,500"}]
[null,"助学金",{"v":500,"d":"¥500"}]
[null,"贷款",{"v":500,"d":"¥500"}]
[null,"其他收入",{"v":250,"d":"¥250"}]
[null,"汇总",{"$f":"SUBTOTAL(109,每月收入[金额])","v":{"v":2750,"d":"¥2,750"}}]

{"sheet":"每月支出","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,{"$f":"工作簿标题","v":"我的大学预算"}]
[null,"每月支出"]
[null,"项目​​","金额"]
[null,"租金",{"v":20,"d":"¥20"}]
[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"}]
[null,"杂项",{"v":0,"d":"¥0"}]
[null,"汇总",{"$f":"SUBTOTAL(109,每月支出[金额])","v":{"v":1395,"d":"¥1,395"}}]

{"sheet":"学期费用","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,5],[10,1,10,2]]}
[null,{"$f":"工作簿标题","v":"我的大学预算"}]
[null,"学期费用*"]
[null,"项目​​","金额","每月"]
[null,"学费",{"v":750,"d":"¥750"},{"$f":"IFERROR(学期费用[[#This Row],[金额]]/4, \"\")","v":{"v":187.5,"d":"¥188"}}]
[null,"实验室费用",{"v":250,"d":"¥250"},{"$f":"IFERROR(学期费用[[#This Row],[金额]]/4, \"\")","v":{"v":62.5,"d":"¥63"}}]
[null,"图书",{"v":500,"d":"¥500"},{"$f":"IFERROR(学期费用[[#This Row],[金额]]/4, \"\")","v":{"v":125,"d":"¥125"}}]
[null,"存款",{"v":0,"d":"¥0"},{"$f":"IFERROR(学期费用[[#This Row],[金额]]/4, \"\")","v":{"v":0,"d":"¥0"}}]
[null,"交通费",{"v":0,"d":"¥0"},{"$f":"IFERROR(学期费用[[#This Row],[金额]]/4, \"\")","v":{"v":0,"d":"¥0"}}]
[null,"其他费用",{"v":0,"d":"¥0"},{"$f":"IFERROR(学期费用[[#This Row],[金额]]/4, \"\")","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,学期费用[金额])","v":{"v":1500,"d":"¥1,500"}},{"$f":"SUBTOTAL(109,学期费用[每月])","v":{"v":375,"d":"¥375"}}]
[null,"* 基于包含 4 个月的学期"]