{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["个人月度预算"],"read":"whole","date_system":"1900"}

{"sheet":"个人月度预算","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[1,1,1,9],[2,1,2,9],[4,1,6,1],[4,2,4,3],[4,6,5,8],[4,9,5,9],[5,2,5,3],[6,2,6,3],[6,6,7,8],[6,9,7,9],[7,1,9,1],[7,2,7,3],[8,2,8,3],[8,6,9,8],[8,9,9,9],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9]]}
[]
[null,"个人月度预算"]
[]
[]
[null,"预计月度收入","收入 1",null,{"v":2500,"d":"¥2,500"},null,"预计余额（预计收入减预计支出）",null,null,{"$f":"E7-J59","v":{"v":940,"d":"¥940"}}]
[null,null,"额外收入",null,{"v":500,"d":"¥500"}]
[null,null,"月度总收入",null,{"$f":"SUM(E5:E6)","v":{"v":3000,"d":"¥3,000"}},null,"实际余额（实际收入减实际支出）",null,null,{"$f":"E10-J61","v":{"v":960,"d":"¥960"}}]
[null,"实际月度收入","收入 1",null,{"v":2500,"d":"¥2,500"}]
[null,null,"额外收入",null,{"v":500,"d":"¥500"},null,"差额（实际值减预计值）",null,null,{"$f":"J7-J5","v":{"v":20,"d":"¥20"}}]
[null,null,"月度总收入",null,{"$f":"SUM(E8:E9)","v":{"v":3000,"d":"¥3,000"}}]
[]
[null,"住房","预计支出","实际成本","差额",null,"娱乐","预计支出","实际成本","差额"]
[null,"抵押贷款或租金",{"v":1500,"d":"¥1,500"},{"v":1400,"d":"¥1,400"},{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":100,"d":"¥100"}},null,"视频/DVD",{"v":0,"d":"¥0"},{"v":50,"d":"¥50"},{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":-50,"d":"¥-50"}}]
[null,"电话",{"v":60,"d":"¥60"},{"v":100,"d":"¥100"},{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":-40,"d":"¥-40"}},null,"CD",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"电费",{"v":50,"d":"¥50"},{"v":60,"d":"¥60"},{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":-10,"d":"¥-10"}},null,"电影",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"燃气",{"v":200,"d":"¥200"},{"v":180,"d":"¥180"},{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":20,"d":"¥20"}},null,"音乐会",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"用水和排污",null,null,{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"体育活动",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"有线电视费",null,null,{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"现场",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"垃圾处理",null,null,{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"保养或修理",null,null,{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"日用品",null,null,{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"表2[[#This Row],[预计支出]]-表2[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"表1[[#This Row],[预计支出]]-表1[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,表2[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表2[实际成本])","v":{"v":50,"d":"¥50"}},{"$f":"SUBTOTAL(109,表2[差额])","v":{"v":-50,"d":"¥-50"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表1[预计支出])","v":{"v":1810,"d":"¥1,810"}},{"$f":"SUBTOTAL(109,表1[实际成本])","v":{"v":1740,"d":"¥1,740"}},{"$f":"SUBTOTAL(109,表1[差额])","v":{"v":70,"d":"¥70"}}]
[{"$nulls":6},"贷款","预计支出","实际成本","差额"]
[null,"交通","预计支出","实际成本","差额",null,"个人",null,null,{"$f":"表8[[#This Row],[预计支出]]-表8[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"汽车还款",{"v":250,"d":"¥250"},{"v":250,"d":"¥250"},{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"学生",null,null,{"$f":"表8[[#This Row],[预计支出]]-表8[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"公交/出租车费",null,null,{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"信用卡",null,null,{"$f":"表8[[#This Row],[预计支出]]-表8[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"保险",null,null,{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"信用卡",null,null,{"$f":"表8[[#This Row],[预计支出]]-表8[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"牌照",null,null,{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"信用卡",null,null,{"$f":"表8[[#This Row],[预计支出]]-表8[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"燃油",null,null,{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"表8[[#This Row],[预计支出]]-表8[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"维护",null,null,{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,表8[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表8[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表8[差额])","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"表3[[#This Row],[预计支出]]-表3[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表3[预计支出])","v":{"v":250,"d":"¥250"}},{"$f":"SUBTOTAL(109,表3[实际成本])","v":{"v":250,"d":"¥250"}},{"$f":"SUBTOTAL(109,表3[差额])","v":{"v":0,"d":"¥0"}},null,"税款","预计支出","实际成本","差额"]
[{"$nulls":6},"国税",null,null,{"$f":"表9[[#This Row],[预计支出]]-表9[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"保险","预计支出","实际成本","差额",null,"省/市/自治区税",null,null,{"$f":"表9[[#This Row],[预计支出]]-表9[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"住房",null,null,{"$f":"表4[[#This Row],[预计支出]]-表4[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"地税",null,null,{"$f":"表9[[#This Row],[预计支出]]-表9[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"健康",null,null,{"$f":"表4[[#This Row],[预计支出]]-表4[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"表9[[#This Row],[预计支出]]-表9[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"人寿",null,null,{"$f":"表4[[#This Row],[预计支出]]-表4[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,表9[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表9[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表9[差额])","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"表4[[#This Row],[预计支出]]-表4[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表4[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表4[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表4[差额])","v":{"v":0,"d":"¥0"}},null,"存款或投资","预计支出","实际成本","差额"]
[{"$nulls":6},"养老金帐户",null,null,{"$f":"表10[[#This Row],[预计支出]]-表10[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"食品","预计支出","实际成本","差额",null,"投资帐户",null,null,{"$f":"表10[[#This Row],[预计支出]]-表10[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"日用杂货",null,null,{"$f":"表5[[#This Row],[预计支出]]-表5[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"表10[[#This Row],[预计支出]]-表10[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"外出就餐",null,null,{"$f":"表5[[#This Row],[预计支出]]-表5[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,表10[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表10[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表10[差额])","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"表5[[#This Row],[预计支出]]-表5[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表5[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表5[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表5[差额])","v":{"v":0,"d":"¥0"}},null,"礼品和捐赠","预计支出","实际成本","差额"]
[{"$nulls":6},"慈善 1",null,null,{"$f":"表11[[#This Row],[预计支出]]-表11[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"宠物","预计支出","实际成本","差额",null,"慈善 2",null,null,{"$f":"表11[[#This Row],[预计支出]]-表11[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"食品",null,null,{"$f":"表6[[#This Row],[预计支出]]-表6[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"慈善 3",null,null,{"$f":"表11[[#This Row],[预计支出]]-表11[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"医疗",null,null,{"$f":"表6[[#This Row],[预计支出]]-表6[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,表11[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表11[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表11[差额])","v":{"v":0,"d":"¥0"}}]
[null,"美容",null,null,{"$f":"表6[[#This Row],[预计支出]]-表6[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"玩具",null,null,{"$f":"表6[[#This Row],[预计支出]]-表6[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"法务","预计支出","实际成本","差额"]
[null,"其他",null,null,{"$f":"表6[[#This Row],[预计支出]]-表6[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"律师",null,null,{"$f":"表12[[#This Row],[预计支出]]-表12[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表6[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表6[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表6[差额])","v":{"v":0,"d":"¥0"}},null,"赡养费",null,null,{"$f":"表12[[#This Row],[预计支出]]-表12[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"抵押或判决付款",null,null,{"$f":"表12[[#This Row],[预计支出]]-表12[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"个人护理","预计支出","实际成本","差额",null,"其他",null,null,{"$f":"表12[[#This Row],[预计支出]]-表12[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"医疗",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,表12[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表12[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表12[差额])","v":{"v":0,"d":"¥0"}}]
[null,"美发/美甲",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"服装",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"预计总支出",null,null,{"$f":"SUM(C23,C33,C40,C46,C54,C64,H22,H31,H38,H44,H50,H57)","v":{"v":2060,"d":"¥2,060"}}]
[null,"干洗",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"健康俱乐部",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"实际总支出",null,null,{"$f":"SUM(D23,D33,D40,D46,D54,D64,I22,I31,I38,I44,I50,I57)","v":{"v":2040,"d":"¥2,040"}}]
[null,"组织费",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"表7[[#This Row],[预计支出]]-表7[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},null,"总差额",null,null,{"$f":"SUM(E23,E33,E40,E46,E54,E64,J22,J31,J38,J44,J50,J57)","v":{"v":20,"d":"¥20"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表7[预计支出])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表7[实际成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,表7[差额])","v":{"v":0,"d":"¥0"}}]