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

{"sheet":"个人月度预算","index":0,"n_rows":66,"n_cols":10,"rows_kept":66,"merged":[[1,1,3,9],[4,1,4,3],[5,1,7,1],[5,2,5,3],[5,6,6,8],[5,9,6,9],[6,2,6,3],[7,2,7,3],[7,6,8,8],[7,9,8,9],[9,1,11,1],[9,2,9,3],[9,6,11,8],[9,9,11,9],[10,2,10,3],[11,2,11,3],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,6,65,8],[64,9,65,9]]}
[]
[null,"个人月度预算"]
[]
[]
[]
[null,"计划月收入","固定收入",null,{"v":4300,"d":"￥4,300"},null,"计划结余\n（计划收入-计划支出）",null,null,{"$f":"E8-J61","v":{"v":3405,"d":"￥3,405"}}]
[null,null,"额外收入",null,{"v":300,"d":"￥300"}]
[null,null,"月收入总额",null,{"$f":"SUM(E6:E7)","v":{"v":4600,"d":"￥4,600"}},null,"实际结余\n（实际收入-实际支出）",null,null,{"$f":"E12-J63","v":{"v":3064,"d":"￥3,064"}}]
[]
[null,"实际月收入","固定收入",null,{"v":4000,"d":"￥4,000"},null,"差额\n（实际结余-计划结余）",null,null,{"$f":"J8-J6","v":{"v":-341,"d":"(￥341)"}}]
[null,null,"额外收入",null,{"v":300,"d":"￥300"}]
[null,null,"月收入总额",null,{"$f":"SUM(E10:E11)","v":{"v":4300,"d":"￥4,300"}}]
[]
[null,"住房","计划支出","实际支出","差额",null,"娱乐","计划支出","实际支出","差额"]
[null,"购房贷款或房租",{"v":1000,"d":"￥1,000"},{"v":1000,"d":"￥1,000"},{"$f":"C15-D15","v":{"v":0,"d":"￥0"}},null,"VCD/DVD",null,null,{"$f":"H15-I15","v":{"v":0,"d":"￥0"}}]
[null,"电话费",{"v":54,"d":"￥54"},{"v":100,"d":"￥100"},{"v":-46,"d":"(￥46)"},null,"CD",null,null,{"v":0,"d":"￥0"}]
[null,"电费",{"v":44,"d":"￥44"},{"v":56,"d":"￥56"},{"v":-12,"d":"(￥12)"},null,"电影",null,null,{"v":0,"d":"￥0"}]
[null,"燃气费",{"v":22,"d":"￥22"},{"v":28,"d":"￥28"},{"v":-6,"d":"(￥6)"},null,"音乐会",null,null,{"v":0,"d":"￥0"}]
[null,"水费/管道疏通",{"v":8,"d":"￥8"},{"v":8,"d":"￥8"},{"v":0,"d":"￥0"},null,"球赛",null,null,{"v":0,"d":"￥0"}]
[null,"有线电视费",{"v":34,"d":"￥34"},{"v":34,"d":"￥34"},{"v":0,"d":"￥0"},null,"演出",null,null,{"v":0,"d":"￥0"}]
[null,"垃圾处理费",{"v":10,"d":"￥10"},{"v":10,"d":"￥10"},{"v":0,"d":"￥0"},null,"其他费用",null,null,{"v":0,"d":"￥0"}]
[null,"维修费",{"v":23,"d":"￥23"},{"v":0,"d":"￥0"},{"v":23,"d":"￥23"},null,"其他费用",null,null,{"v":0,"d":"￥0"}]
[null,"日用品",{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},null,"其他费用",null,null,{"v":0,"d":"￥0"}]
[null,"其他费用",{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},null,"小计",{"$f":"SUM(H15:H23)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I15:I23)","v":{"v":0,"d":"￥0"}},{"v":0,"d":"￥0"}]
[null,"小计",{"$f":"SUM(C15:C24)","v":{"v":1195,"d":"￥1,195"}},{"$f":"SUM(D15:D24)","v":{"v":1236,"d":"￥1,236"}},{"$f":"SUM(E15:E24)","v":{"v":-41,"d":"(￥41)"}}]
[{"$nulls":6},"贷款","计划支出","实际支出","差额"]
[null,"交通","计划支出","实际支出","差额",null,"个人贷款",null,null,{"$f":"H27-I27","v":{"v":0,"d":"￥0"}}]
[null,"购车贷款",null,null,{"$f":"C28-D28","v":{"v":0,"d":"￥0"}},null,"助学贷款",null,null,{"v":0,"d":"￥0"}]
[null,"公交/地铁/出租",null,null,{"v":0,"d":"￥0"},null,"信用卡",null,null,{"v":0,"d":"￥0"}]
[null,"汽车保险",null,null,{"v":0,"d":"￥0"},null,"信用卡",null,null,{"v":0,"d":"￥0"}]
[null,"牌照费",null,null,{"v":0,"d":"￥0"},null,"信用卡",null,null,{"v":0,"d":"￥0"}]
[null,"汽油费",null,null,{"v":0,"d":"￥0"},null,"其他费用",null,null,{"v":0,"d":"￥0"}]
[null,"维修费",null,null,{"v":0,"d":"￥0"},null,"小计",{"$f":"SUM(H27:H32)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I27:I32)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(J27:J32)","v":{"v":0,"d":"￥0"}}]
[null,"其他费用",null,null,{"v":0,"d":"￥0"}]
[null,"小计",{"$f":"SUM(C28:C34)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D28:D34)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(E28:E34)","v":{"v":0,"d":"￥0"}},null,"纳税","计划支出","实际支出","差额"]
[{"$nulls":6},"个人所得税",null,null,{"$f":"H36-I36","v":{"v":0,"d":"￥0"}}]
[null,"保险","计划支出","实际支出","差额",null,"车船使用税",null,null,{"$f":"H37-I37","v":{"v":0,"d":"￥0"}}]
[null,"失业保险",null,null,{"$f":"C38-D38","v":{"v":0,"d":"￥0"}},null,"房产税",null,null,{"$f":"H38-I38","v":{"v":0,"d":"￥0"}}]
[null,"医疗保险",null,null,{"$f":"C39-D39","v":{"v":0,"d":"￥0"}},null,"其他费用",null,null,{"$f":"H39-I39","v":{"v":0,"d":"￥0"}}]
[null,"养老保险",null,null,{"$f":"C40-D40","v":{"v":0,"d":"￥0"}},null,"小计",{"$f":"SUM(H36:H39)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I36:I39)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(J36:J39)","v":{"v":0,"d":"￥0"}}]
[null,"其他费用",null,null,{"$f":"C41-D41","v":{"v":0,"d":"￥0"}}]
[null,"小计",{"$f":"SUM(C38:C41)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D38:D41)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(E38:E41)","v":{"v":0,"d":"￥0"}},null,"储蓄及投资","计划支出","实际支出","差额"]
[{"$nulls":6},"储蓄帐户",null,null,{"$f":"H43-I43","v":{"v":0,"d":"￥0"}}]
[null,"饮食","计划支出","实际支出","差额",null,"投资帐户",null,null,{"$f":"H44-I44","v":{"v":0,"d":"￥0"}}]
[null,"购买食品",null,null,{"$f":"C45-D45","v":{"v":0,"d":"￥0"}},null,"其他费用",null,null,{"$f":"H45-I45","v":{"v":0,"d":"￥0"}}]
[null,"外出就餐",null,null,{"$f":"C46-D46","v":{"v":0,"d":"￥0"}},null,"小计",{"$f":"SUM(H43:H45)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I43:I45)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(J43:J45)","v":{"v":0,"d":"￥0"}}]
[null,"其他费用",null,null,{"$f":"C47-D47","v":{"v":0,"d":"￥0"}}]
[null,"小计",{"$f":"SUM(C45:C47)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D45:D47)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(E45:E47)","v":{"v":0,"d":"￥0"}},null,"社交及慈善活动","计划支出","实际支出","差额"]
[{"$nulls":6},"慈善活动 1",null,null,{"$f":"H49-I49","v":{"v":0,"d":"￥0"}}]
[null,"宠物","计划支出","实际支出","差额",null,"慈善活动 2",null,null,{"$f":"H50-I50","v":{"v":0,"d":"￥0"}}]
[null,"食品",null,null,{"$f":"C51-D51","v":{"v":0,"d":"￥0"}},null,"慈善活动 3",null,null,{"$f":"H51-I51","v":{"v":0,"d":"￥0"}}]
[null,"就医",null,null,{"$f":"C52-D52","v":{"v":0,"d":"￥0"}},null,"小计",{"$f":"SUM(H49:H51)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I49:I51)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(J49:J51)","v":{"v":0,"d":"￥0"}}]
[null,"清洁美容",null,null,{"$f":"C53-D53","v":{"v":0,"d":"￥0"}}]
[null,"玩具",null,null,{"$f":"C54-D54","v":{"v":0,"d":"￥0"}},null,"法律费用","计划支出","实际支出","差额"]
[null,"其他费用",null,null,{"$f":"C55-D55","v":{"v":0,"d":"￥0"}},null,"律师费",null,null,{"$f":"H55-I55","v":{"v":0,"d":"￥0"}}]
[null,"小计",{"$f":"SUM(C51:C55)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D51:D55)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(E51:E55)","v":{"v":0,"d":"￥0"}},null,"诉讼费",null,null,{"$f":"H56-I56","v":{"v":0,"d":"￥0"}}]
[{"$nulls":6},"赡养费",null,null,{"$f":"H57-I57","v":{"v":0,"d":"￥0"}}]
[null,"美容健身","计划支出","实际支出","差额",null,"其他费用",null,null,{"$f":"H58-I58","v":{"v":0,"d":"￥0"}}]
[null,"就医",null,null,{"$f":"C59-D59","v":{"v":0,"d":"￥0"}},null,"小计",{"$f":"SUM(H55:H58)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I55:I58)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(J55:J58)","v":{"v":0,"d":"￥0"}}]
[null,"美容/护发/美甲",null,null,{"v":0,"d":"￥0"}]
[null,"服装",null,null,{"v":0,"d":"￥0"},null,"计划支出总额",null,null,{"$f":"SUM(C25,C35,C42,C48,C56,C66,H24,H33,H40,H46,H52,H59)","v":{"v":1195,"d":"￥1,195"}}]
[null,"干洗",null,null,{"v":0,"d":"￥0"}]
[null,"健身",null,null,{"v":0,"d":"￥0"},null,"实际支出总额",null,null,{"$f":"SUM(D25,D35,D42,D48,D56,D66,I24,I33,I40,I46,I52,I59)","v":{"v":1236,"d":"￥1,236"}}]
[null,"俱乐部会员费",null,null,{"v":0,"d":"￥0"}]
[null,"其他费用",null,null,{"v":0,"d":"￥0"},null,"总差额",null,null,{"$f":"SUM(E25,E35,E42,E48,E56,E66,J24,J33,J40,J46,J52,J59)","v":{"v":-41,"d":"(￥41)"}}]
[null,"小计",{"$f":"SUM(C59:C65)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D59:D65)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(E59:E65)","v":{"v":0,"d":"￥0"}}]