{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["工作表 1","预算概览","预算摘要","每月支出","其他数据"],"not_rendered":{"charts":1,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"工作表 1","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"hidden":true}
["计算字段"]
["求解次序","字段","公式"]
[]
["计算项"]
["求解次序","项目","公式"]
[]
[]
["注释：","当一个单元格可由多个公式更新时，"]
[null,"该值由具有最后求解次序的公式得出。"]
[]
[null,"若要更改多个计算项或字段的求解次序，"]
[null,"请在“选项”选项卡上的“计算”组中，单击“字段”、“项目”和“集合”，然后单击“求解次序”。"]

{"sheet":"预算概览","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[null,"预算概览",{"$nulls":5}," "]
[null,"余额"]
[]
[null,"预计结余",null,{"$f":"预计收入-预计支出","v":{"v":1585,"d":"¥1,585"}},null,"预计值减支出"]
[null,"实际余额 ",null,{"$f":"实际收入-实际支出","v":{"v":1740,"d":"¥1,740"}},null,"实际值减支出"]
[null,"差额",null,{"$f":"D5-D4","v":{"v":155,"d":"¥155"}},null,"实际值减预计值"]
[]
[null,"收入",{"$nulls":3},"支出"]
[]
[null,null,"预计","实际",null,"预计","实际"]
[null,"收入 1",{"v":6000,"d":"¥6,000"},{"v":5800,"d":"¥5,800"},null,{"$f":"SUM(Monthly_Expenses_Table[预计费用])","v":{"v":7915,"d":"¥7,915"}},{"$f":"SUM(Monthly_Expenses_Table[实际费用])","v":{"v":7860,"d":"¥7,860"}}]
[null,"收入 2",{"v":1000,"d":"¥1,000"},{"v":2300,"d":"¥2,300"}]
[null,"额外收入",{"v":2500,"d":"¥2,500"},{"v":1500,"d":"¥1,500"}]
[null,"总收入",{"$f":"SUM(C11:C13)","v":{"v":9500,"d":"¥9,500"}},{"$f":"SUM(D11:D13)","v":{"v":9600,"d":"¥9,600"}}]
[]
[null,"实际费用明细"]

{"sheet":"预算摘要","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"merged":[[0,1,0,4]]}
[null,"预算汇总",{"$nulls":4}," "]
[]
[null,"类别","预计费用 ","实际费用 ","差额 "]
[null,"育儿",{"v":140,"d":"¥140"},{"v":140,"d":"¥140"},{"v":0,"d":"¥0"}]
[null,"课外活动",{"v":40,"d":"¥40"},{"v":40,"d":"¥40"},{"v":0,"d":"¥0"}]
[null,"学费",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"v":0,"d":"¥0"}]
[null,"学习用品",null,null,{"v":0,"d":"¥0"}]
[null,"医疗",null,null,{"v":0,"d":"¥0"}]
[]
[null,"娱乐",{"v":400,"d":"¥400"},{"v":358,"d":"¥358"},{"v":42,"d":"¥42"}]
[null,"电影",{"v":50,"d":"¥50"},{"v":28,"d":"¥28"},{"v":22,"d":"¥22"}]
[null,"视频/DVD（购买）",{"v":20,"d":"¥20"},{"v":50,"d":"¥50"},{"v":-30,"d":"(¥30)"}]
[null,"视频/DVD（租赁）",{"v":30,"d":"¥30"},{"v":20,"d":"¥20"},{"v":10,"d":"¥10"}]
[null,"体育活动",{"v":0,"d":"¥0"},{"v":40,"d":"¥40"},{"v":-40,"d":"(¥40)"}]
[null,"现场演出",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"v":50,"d":"¥50"}]
[null,"音乐（CD、下载内容等）",{"v":50,"d":"¥50"},{"v":30,"d":"¥30"},{"v":20,"d":"¥20"}]
[null,"音乐会",{"v":50,"d":"¥50"},{"v":40,"d":"¥40"},{"v":10,"d":"¥10"}]
[]
[null,"食品",{"v":1100,"d":"¥1,100"},{"v":1320,"d":"¥1,320"},{"v":-220,"d":"(¥220)"}]
[]
[null,"礼品和捐赠",{"v":100,"d":"¥100"},{"v":125,"d":"¥125"},{"v":-25,"d":"(¥25)"}]
[null,"捐赠 1",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"},{"v":-25,"d":"(¥25)"}]
[null,"捐赠 2",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"v":0,"d":"¥0"}]
[null,"礼品 1",null,null,{"v":0,"d":"¥0"}]
[null,"礼品 2",null,null,{"v":0,"d":"¥0"}]
[]
[null,"住房",{"v":2830,"d":"¥2,830"},{"v":2702,"d":"¥2,702"},{"v":-72,"d":"(¥72)"}]
[]
[null,"保险",{"v":900,"d":"¥900"},{"v":900,"d":"¥900"},{"v":0,"d":"¥0"}]
[]
[null,"贷款",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[]
[null,"个人护理",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"v":10,"d":"¥10"}]
[]
[null,"宠物",{"v":170,"d":"¥170"},{"v":100,"d":"¥100"},{"v":70,"d":"¥70"}]
[]
[null,"税费",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"v":0,"d":"¥0"}]
[]
[null,"交通",{"v":1425,"d":"¥1,425"},{"v":1375,"d":"¥1,375"},{"v":50,"d":"¥50"}]
[]
[null,"存款",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[null,"投资帐户",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[null,"养老金帐户",null,null,{"v":0,"d":"¥0"}]
[]
[null,"Grand Total",{"v":7915,"d":"¥7,915"},{"v":7860,"d":"¥7,860"},{"v":-145,"d":"(¥145)"}]

{"sheet":"每月支出","index":3,"n_rows":61,"n_cols":8,"rows_kept":61}
[null,"每月费用",{"$nulls":5}," "]
[null,"说明","类别","预计费用","实际费用","差额","实际费用概览"]
[null,"课外活动","育儿",{"v":40,"d":"¥40"},{"v":40,"d":"¥40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":40}]
[null,"医疗","育儿",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"学习用品","育儿",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"学费","育儿",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":100}]
[null,"音乐会","娱乐",{"v":50,"d":"¥50"},{"v":40,"d":"¥40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":10,"d":"¥10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":40}]
[null,"现场演出","娱乐",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":150}]
[null,"电影","娱乐",{"v":50,"d":"¥50"},{"v":28,"d":"¥28"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":22,"d":"¥22"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":28}]
[null,"音乐（CD、下载内容等）","娱乐",{"v":50,"d":"¥50"},{"v":30,"d":"¥30"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":20,"d":"¥20"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":30}]
[null,"体育活动","娱乐",{"v":0,"d":"¥0"},{"v":40,"d":"¥40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-40,"d":"(¥40)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":40}]
[null,"视频/DVD（购买）","娱乐",{"v":20,"d":"¥20"},{"v":50,"d":"¥50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-30,"d":"(¥30)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":50}]
[null,"视频/DVD（租赁）","娱乐",{"v":30,"d":"¥30"},{"v":20,"d":"¥20"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":10,"d":"¥10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":20}]
[null,"外出就餐","食品",{"v":1000,"d":"¥1,000"},{"v":1200,"d":"¥1,200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-200,"d":"(¥200)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":1200}]
[null,"日用杂货","食品",{"v":100,"d":"¥100"},{"v":120,"d":"¥120"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-20,"d":"(¥20)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":120}]
[null,"捐赠 1","礼品和捐赠",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-25,"d":"(¥25)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":100}]
[null,"捐赠 2","礼品和捐赠",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":25}]
[null,"礼品 1","礼品和捐赠",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"礼品 2","礼品和捐赠",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"有线电视/卫星电视","住房",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":100}]
[null,"电费","住房",{"v":45,"d":"¥45"},{"v":50,"d":"¥50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-5,"d":"(¥5)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":50}]
[null,"燃气","住房",{"v":300,"d":"¥300"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-100,"d":"(¥100)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":400}]
[null,"房屋清洁服务","住房",{"v":200,"d":"¥200"},null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"维护","住房",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":150}]
[null,"按揭付款或租金","住房",{"v":1700,"d":"¥1,700"},{"v":1700,"d":"¥1,700"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":1700}]
[null,"天燃气/燃油","住房",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"Internet 服务","住房",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":100}]
[null,"移动电话","住房",{"v":60,"d":"¥60"},{"v":60,"d":"¥60"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":60}]
[null,"住宅电话","住房",{"v":35,"d":"¥35"},{"v":39,"d":"¥39"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-4,"d":"(¥4)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":39}]
[null,"日用品","住房",{"v":40,"d":"¥40"},{"v":55,"d":"¥55"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-15,"d":"(¥15)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":55}]
[null,"垃圾处理和回收","住房",{"v":25,"d":"¥25"},{"v":22,"d":"¥22"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":3,"d":"¥3"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":22}]
[null,"用水和排污","住房",{"v":25,"d":"¥25"},{"v":26,"d":"¥26"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-1,"d":"(¥1)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":26}]
[null,"健康","保险",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":400}]
[null,"房屋","保险",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":400}]
[null,"人寿","保险",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":100}]
[null,"信用卡 1","贷款",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":200}]
[null,"信用卡 2","贷款",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"信用卡 3","贷款",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"个人","贷款",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"学生","贷款",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"服装费","个人护理",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":10,"d":"¥10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":140}]
[null,"干洗","个人护理",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"美发/美甲","个人护理",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"健康俱乐部","个人护理",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"医疗","个人护理",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"食物","宠物",{"v":150,"d":"¥150"},{"v":75,"d":"¥75"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":75,"d":"¥75"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":75}]
[null,"修饰","宠物",{"v":20,"d":"¥20"},{"v":25,"d":"¥25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-5,"d":"(¥5)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":25}]
[null,"医疗","宠物",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"玩具","宠物",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"投资帐户","存款",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":200}]
[null,"养老金帐户","存款",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"国税","税费",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":300}]
[null,"本地","税费",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"省/直辖市/自治区","税费",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"公共汽车或拼车","交通",{"v":100,"d":"¥100"},{"v":150,"d":"¥150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":-50,"d":"(¥50)"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":150}]
[null,"燃料","交通",{"v":450,"d":"¥450"},{"v":400,"d":"¥400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":400}]
[null,"保险","交通",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":300}]
[null,"牌照 ","交通",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":25}]
[null,"维护","交通",{"v":100,"d":"¥100"},{"v":50,"d":"¥50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":50,"d":"¥50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":50}]
[null,"停车费","交通",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":0}]
[null,"汽车还款","交通",{"v":450,"d":"¥450"},{"v":450,"d":"¥450"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[预计费用]]=\"\",Monthly_Expenses_Table[[#This Row],[实际费用]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[预计费用]]-Monthly_Expenses_Table[[#This Row],[实际费用]])","v":{"v":0,"d":"¥0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[实际费用]]","v":450}]

{"sheet":"其他数据","index":4,"n_rows":17,"n_cols":9,"rows_kept":17}
[null,"其他数据",{"$nulls":3}," "]
[null,"预算图表的数据透视表",null,null,"类别清单"]
[]
[null,"类别","费用 ",null,"若要添加类别，请在下面键入内容",{"$nulls":3},"`"]
[null,"宠物",{"v":100,"d":"¥100"},null,"育儿"]
[null,"礼品和捐赠",{"v":125,"d":"¥125"},null,"娱乐"]
[null,"育儿",{"v":140,"d":"¥140"},null,"食品"]
[null,"个人护理",{"v":140,"d":"¥140"},null,"礼品和捐赠"]
[null,"存款",{"v":200,"d":"¥200"},null,"住房"]
[null,"贷款",{"v":200,"d":"¥200"},null,"保险"]
[null,"税费",{"v":300,"d":"¥300"},null,"贷款"]
[null,"娱乐",{"v":358,"d":"¥358"},null,"个人护理"]
[null,"保险",{"v":900,"d":"¥900"},null,"宠物"]
[null,"食品",{"v":1320,"d":"¥1,320"},null,"存款"]
[null,"交通",{"v":1375,"d":"¥1,375"},null,"税费"]
[null,"住房",{"v":2702,"d":"¥2,702"},null,"交通"]
[null,"Grand Total",{"v":7860,"d":"¥7,860"}]