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

{"sheet":"家庭月度预算","index":0,"n_rows":68,"n_cols":9,"rows_kept":68,"merged":[[0,0,0,8],[2,5,2,6],[8,5,8,6]]}
["家庭月度预算"]
[]
[null,"计划支出总额","实际支出总额","总差额",null,"计划月收入"]
[null,{"$f":"SUM(B19,B29,B36,B41,B52,B59,B68,G39,G47,G52,G57,G62,G68)","v":{"v":1195,"d":"￥1,195"}},{"$f":"SUM(C19,C29,C36,C41,C52,C59,C68,H39,H47,H52,H57,H62,H68)","v":{"v":1236,"d":"￥1,236"}},{"$f":"SUM(D19,D29,D36,D41,D52,D59,D68,I39,I47,I52,I57,I62,I68)","v":{"v":-41,"d":"￥-41"}},null,"固定收入 1",{"v":4000,"d":"￥4,000"}]
[{"$nulls":5},"固定收入 2",{"v":1300,"d":"￥1,300"}]
[null,"计划开支","实际开支","差额",null,"额外收入",{"v":300,"d":"￥300"}]
["住房",{"$nulls":4},"月收入总额",{"$f":"SUM(G4:G6)","v":{"v":5600,"d":"￥5,600"}}]
["购房贷款或租金 1",{"v":1000,"d":"￥1,000"},{"v":1000,"d":"￥1,000"},{"$f":"B8-C8","v":{"v":0,"d":"￥0"}}]
["购房贷款或租金 2",{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},{"$f":"B9-C9","v":{"v":0,"d":"￥0"}},null,"实际月收入"]
["电话费",{"v":54,"d":"￥54"},{"v":100,"d":"￥100"},{"v":-46,"d":"￥-46"},null,"固定收入 1",{"v":4000,"d":"￥4,000"}]
["电费",{"v":44,"d":"￥44"},{"v":56,"d":"￥56"},{"v":-12,"d":"￥-12"},null,"固定收入 2",{"v":1300,"d":"￥1,300"}]
["燃气费",{"v":22,"d":"￥22"},{"v":28,"d":"￥28"},{"v":-6,"d":"￥-6"},null,"额外收入",{"v":300,"d":"￥300"}]
["水费",{"v":8,"d":"￥8"},{"v":8,"d":"￥8"},{"v":0,"d":"￥0"},null,"月收入总额",{"$f":"SUM(G10:G12)","v":{"v":5600,"d":"￥5,600"}}]
["有线电视收视费",{"v":34,"d":"￥34"},{"v":34,"d":"￥34"},{"v":0,"d":"￥0"}]
["物业费",{"v":10,"d":"￥10"},{"v":10,"d":"￥10"},{"v":0,"d":"￥0"},null,"计划结余（计划收入-计划支出）",{"$f":"G7-B4","v":{"v":4405,"d":"￥4,405"}}]
["维修费",{"v":23,"d":"￥23"},{"v":0,"d":"￥0"},{"v":23,"d":"￥23"}]
["装修费",{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},null,"实际结余（实际收入-实际支出）",{"$f":"G13-C4","v":{"v":4364,"d":"￥4,364"}}]
["其他",{"v":0,"d":"￥0"},{"v":0,"d":"￥0"},{"v":0,"d":"￥0"}]
["小计",{"$f":"SUM(B8:B18)","v":{"v":1195,"d":"￥1,195"}},{"$f":"SUM(C8:C18)","v":{"v":1236,"d":"￥1,236"}},{"$f":"SUM(D8:D18)","v":{"v":-41,"d":"￥-41"}},null,"差额（实际结余-计划结余）",{"$f":"G17-G15","v":{"v":-41,"d":"￥-41"}}]
["交通"]
["购车贷款 1",null,null,{"v":0,"d":"￥0"}]
["购车贷款 2",null,null,{"v":0,"d":"￥0"}]
["公共交通费用",null,null,{"v":0,"d":"￥0"}]
["汽车保险",null,null,{"v":0,"d":"￥0"}]
["验车费",null,null,{"v":0,"d":"￥0"}]
["汽油费",null,null,{"v":0,"d":"￥0"}]
["维修费",null,null,{"v":0,"d":"￥0"}]
["其他",null,null,{"v":0,"d":"￥0"}]
["小计",{"$f":"SUM(B21:B28)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(C21:C28)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D21:D28)","v":{"v":0,"d":"￥0"}},null,null,"计划开支","实际开支","差额"]
["保险"]
["养老保险",null,null,{"v":0,"d":"￥0"},null,"娱乐"]
["医疗保险",null,null,{"v":0,"d":"￥0"},null,"音像制品",null,null,{"$f":"G32-H32","v":{"v":0,"d":"￥0"}}]
["工伤保险",null,null,{"v":0,"d":"￥0"},null,"报刊杂志",null,null,{"$f":"G33-H33","v":{"v":0,"d":"￥0"}}]
["失业保险",null,null,{"v":0,"d":"￥0"},null,"电影",null,null,{"$f":"G34-H34","v":{"v":0,"d":"￥0"}}]
["其他",null,null,{"v":0,"d":"￥0"},null,"音乐会",null,null,{"$f":"G35-H35","v":{"v":0,"d":"￥0"}}]
["小计",{"$f":"SUM(B31:B35)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(C31:C35)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D31:D35)","v":{"v":0,"d":"￥0"}},null,"体育比赛",null,null,{"$f":"G36-H36","v":{"v":0,"d":"￥0"}}]
["饮食",{"$nulls":4},"图书",null,null,{"$f":"G37-H37","v":{"v":0,"d":"￥0"}}]
["食品购买",null,null,{"v":0,"d":"￥0"},null,"其他",null,null,{"v":0,"d":"￥0"}]
["外出就餐",null,null,{"v":0,"d":"￥0"},null,"小计",{"$f":"SUM(G32:G38)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(H32:H38)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I32:I38)","v":{"v":0,"d":"￥0"}}]
["其他",null,null,{"v":0,"d":"￥0"},null,"贷款"]
["小计",{"$f":"SUM(B38:B40)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(C38:C40)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D38:D40)","v":{"v":0,"d":"￥0"}},null,"私人贷款",null,null,{"v":0,"d":"￥0"}]
["子女",{"$nulls":4},"教育贷款",null,null,{"v":0,"d":"￥0"}]
["医疗",null,null,{"v":0,"d":"￥0"},null,"信用卡",null,null,{"v":0,"d":"￥0"}]
["服装",null,null,{"v":0,"d":"￥0"},null,"信用卡",null,null,{"v":0,"d":"￥0"}]
["学费",null,null,{"v":0,"d":"￥0"},null,"信用卡",null,null,{"v":0,"d":"￥0"}]
["书费",null,null,{"v":0,"d":"￥0"},null,"其他",null,null,{"v":0,"d":"￥0"}]
["辅导班",null,null,{"v":0,"d":"￥0"},null,"小计",{"$f":"SUM(G41:G46)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(H41:H46)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I41:I46)","v":{"v":0,"d":"￥0"}}]
["午餐费",null,null,{"v":0,"d":"￥0"},null,"税款"]
["家教",null,null,{"v":0,"d":"￥0"},null,"个人所得税",null,null,{"v":0,"d":"￥0"}]
["玩具/游戏",null,null,{"v":0,"d":"￥0"},null,"车船使用税",null,null,{"v":0,"d":"￥0"}]
["其他",null,null,{"v":0,"d":"￥0"},null,"其他",null,null,{"v":0,"d":"￥0"}]
["小计",{"$f":"SUM(B43:B51)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(C43:C51)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D43:D51)","v":{"v":0,"d":"￥0"}},null,"小计",{"$f":"SUM(G49:G51)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(H49:H51)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I49:I51)","v":{"v":0,"d":"￥0"}}]
["宠物",{"$nulls":4},"储蓄或投资"]
["食物",null,null,{"v":0,"d":"￥0"},null,"储蓄帐户",null,null,{"v":0,"d":"￥0"}]
["医疗",null,null,{"v":0,"d":"￥0"},null,"投资帐户",null,null,{"v":0,"d":"￥0"}]
["清洁",null,null,{"v":0,"d":"￥0"},null,"其他",null,null,{"v":0,"d":"￥0"}]
["玩具",null,null,{"v":0,"d":"￥0"},null,"小计",{"$f":"SUM(G54:G56)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(H54:H56)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I54:I56)","v":{"v":0,"d":"￥0"}}]
["其他",null,null,{"v":0,"d":"￥0"},null,"社交和慈善活动"]
["小计",{"$f":"SUM(B54:B58)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(C54:C58)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D54:D58)","v":{"v":0,"d":"￥0"}},null,"社交",null,null,{"v":0,"d":"￥0"}]
["个人护理",{"$nulls":4},"慈善活动",null,null,{"v":0,"d":"￥0"}]
["医疗",null,null,{"v":0,"d":"￥0"},null,"其他",null,null,{"v":0,"d":"￥0"}]
["理发/美容",null,null,{"v":0,"d":"￥0"},null,"小计",{"$f":"SUM(G59:G61)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(H59:H61)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I59:I61)","v":{"v":0,"d":"￥0"}}]
["服装",null,null,{"v":0,"d":"￥0"},null,"其他"]
["洗衣",null,null,{"v":0,"d":"￥0"},null,"咨询费",null,null,{"v":0,"d":"￥0"}]
["健身",null,null,{"v":0,"d":"￥0"},null,"赡养费",null,null,{"v":0,"d":"￥0"}]
["俱乐部会员费",null,null,{"v":0,"d":"￥0"},null,"法律诉讼费",null,null,{"v":0,"d":"￥0"}]
["其他",null,null,{"v":0,"d":"￥0"},null,"其他",null,null,{"v":0,"d":"￥0"}]
["小计",{"$f":"SUM(B61:B67)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(C61:C67)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(D61:D67)","v":{"v":0,"d":"￥0"}},null,"小计",{"$f":"SUM(G64:G67)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(H64:H67)","v":{"v":0,"d":"￥0"}},{"$f":"SUM(I64:I67)","v":{"v":0,"d":"￥0"}}]