{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["汇总","每月收入","每月支出","每月存款","图表数据"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"汇总","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"个人预算"]
[null,"收支百分比","汇总"]
[null,{"$f":"Percentage_of_Income_Spent","v":{"v":0.6229333333333333,"d":"62%"}},"每月收入总额","显示每月收入和每月支出总额的柱状图位于此单元格。"]
[null,null,{"$f":"SUM(每月收入[[#All],[金额]])","v":{"v":3750,"d":"¥3,750"}}]
[null,null,"每月支出总额"]
[null,null,{"$f":"SUM(每月支出[[#All],[金额]])","v":{"v":2336,"d":"¥2,336"}}]
[null,null,"每月存款总额"]
[null,null,{"$f":"SUM(存款[[#All],[金额]])","v":{"v":550,"d":"¥550"}}]
[null,null,"现金余额"]
[null,null,{"$f":"每月总收入-每月总支出-每月总存款","v":{"v":864,"d":"¥864"}}]

{"sheet":"每月收入","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"预算标题","v":"个人预算"}]
[null,"每月收入"]
[null,"项目","金额"]
[null,"收入来源 1",{"v":2500,"d":"¥2,500.00"}]
[null,"收入来源 2",{"v":1000,"d":"¥1,000.00"}]
[null,"其他",{"v":250,"d":"¥250.00"}]

{"sheet":"每月支出","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"预算标题","v":"个人预算"}]
[null,"每月支出"]
[null,"项目","截止日期","金额"]
[null,"租金/抵押贷款","日期",{"v":800,"d":"¥800.00"}]
[null,"用电","日期",{"v":120,"d":"¥120.00"}]
[null,"燃气","日期",{"v":50,"d":"¥50.00"}]
[null,"移动电话","日期",{"v":45,"d":"¥45.00"}]
[null,"日用杂货","日期",{"v":500,"d":"¥500.00"}]
[null,"车贷","日期",{"v":273,"d":"¥273.00"}]
[null,"汽车开支","日期",{"v":120,"d":"¥120.00"}]
[null,"学生贷款","日期",{"v":50,"d":"¥50.00"}]
[null,"信用卡","日期",{"v":100,"d":"¥100.00"}]
[null,"车险","日期",{"v":78,"d":"¥78.00"}]
[null,"个人护理","日期",{"v":50,"d":"¥50.00"}]
[null,"娱乐","日期",{"v":100,"d":"¥100.00"}]
[null,"杂项","日期",{"v":50,"d":"¥50.00"}]

{"sheet":"每月存款","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"预算标题","v":"个人预算"}]
[null,"每月存款"]
[null,"日期","金额"]
[null,"日期",{"v":200,"d":"¥200.00"}]
[null,"日期",{"v":250,"d":"¥250.00"}]
[null,"日期",{"v":100,"d":"¥100.00"}]

{"sheet":"图表数据","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"图表数据"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(每月总支出/每月总收入,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(每月总支出/每月总收入)>1","v":false}]