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

{"sheet":"预算摘要","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[1,2,1,5],[2,2,2,5],[4,2,4,3],[4,4,4,5],[5,2,5,3]]}
[]
[null,null,"我的大学预算"]
[null,null,"收支百分比"]
[]
[null,null,{"$f":"每月净支出/每月净收入","v":{"v":0.6436363636363637,"d":"¥1"}},null,{"$f":"每月净支出","v":1770}]
[]
[null,null,"每月净收入"]
[null,null,{"$f":"每月总收入","v":{"v":2750,"d":"¥2,750"}}]
[null,null,"每月净支出"]
[null,null,{"$f":"每月总支出+学期总费用","v":{"v":1770,"d":"¥1,770"}}]
[null,null,"余额"]
[null,null,{"$f":"每月净收入-每月净支出","v":{"v":980,"d":"¥980"}}]

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

{"sheet":"每月支出","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[1,2,1,3],[2,2,2,3]]}
[]
[null,null,{"$f":"工作簿标题","v":"我的大学预算"}]
[null,null,"每月支出"]
[]
[null,null,"项","金额"]
[null,null,"租金",{"v":20,"d":"¥20"}]
[null,null,"水电费",{"v":50,"d":"¥50"}]
[null,null,"电话费",{"v":75,"d":"¥75"}]
[null,null,"日用杂货",{"v":250,"d":"¥250"}]
[null,null,"汽车开支",{"v":50,"d":"¥50"}]
[null,null,"学生贷款",{"v":500,"d":"¥500"}]
[null,null,"信用卡",{"v":275,"d":"¥275"}]
[null,null,"保险",{"v":125,"d":"¥125"}]
[null,null,"理发",{"v":50,"d":"¥50"}]
[null,null,"娱乐",{"v":0,"d":"¥0"}]
[null,null,"杂项",{"v":0,"d":"¥0"}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,每月支出[金额])","v":{"v":1395,"d":"¥1,395"}}]

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