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

{"sheet":"每月家庭预算","index":0,"n_rows":67,"n_cols":10,"rows_kept":67}
[null,"每月家庭预算"]
[null,"汇总表","汇总\n预计成本","汇总\n实际成本","汇总\n差额",null,"每月预计收入来源","数量"]
[null,null,{"$f":"住宅[[#Totals],[预计\n成本]]+交通[[#Totals],[预计\n成本]]+保险[[#Totals],[预计\n成本]]+食物[[#Totals],[预计\n成本]]+育儿[[#Totals],[预计\n成本]]+法务[[#Totals],[预计\n成本]]+存款[[#Totals],[预计\n成本]]+贷款[[#Totals],[预计\n成本]]+娱乐[[#Totals],[预计\n成本]]+税款[[#Totals],[预计\n成本]]+个人护理[[#Totals],[预计\n成本]]+宠物[[#Totals],[预计\n成本]]+礼品[[#Totals],[预计\n成本]]","v":{"v":1203,"d":"¥1,203"}},{"$f":"住宅[[#Totals],[实际\n成本]]+交通[[#Totals],[实际\n成本]]+保险[[#Totals],[实际\n成本]]+食物[[#Totals],[实际\n成本]]+育儿[[#Totals],[实际\n成本]]+法务[[#Totals],[实际\n成本]]+存款[[#Totals],[实际\n成本]]+贷款[[#Totals],[实际\n成本]]+娱乐[[#Totals],[实际\n成本]]+税款[[#Totals],[实际\n成本]]+个人护理[[#Totals],[实际\n成本]]+宠物[[#Totals],[实际\n成本]]+礼品[[#Totals],[实际\n成本]]","v":{"v":1317,"d":"¥1,317"}},{"$f":"住宅[[#Totals],[差额]]+交通[[#Totals],[差额]]+保险[[#Totals],[差额]]+食物[[#Totals],[差额]]+育儿[[#Totals],[差额]]+法务[[#Totals],[差额]]+存款[[#Totals],[差额]]+贷款[[#Totals],[差额]]+娱乐[[#Totals],[差额]]+税款[[#Totals],[差额]]+个人护理[[#Totals],[差额]]+宠物[[#Totals],[差额]]+礼品[[#Totals],[差额]]","v":{"v":-114,"d":"(¥114)"}},null,"收入 1",{"v":4000,"d":"¥4,000"}]
[{"$nulls":6},"收入 2",{"v":1200,"d":"¥1,200"}]
[null,"住宅","预计\n成本","实际\n成本","差额",null,"外快",{"v":300,"d":"¥300"}]
[null,"抵押贷款或租金",{"v":1000,"d":"¥1,000"},{"v":1000,"d":"¥1,000"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"每月总收入",{"$f":"SUM(H3:H5)","v":{"v":5500,"d":"¥5,500"}}]
[null,"第二项抵押贷款或租金",{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"电话",{"v":62,"d":"¥62"},{"v":100,"d":"¥100"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":-38,"d":"(¥38)"}},null,"每月实际收入来源","数量"]
[null,"电费",{"v":44,"d":"¥44"},{"v":125,"d":"¥125"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":-81,"d":"(¥81)"}},null,"收入 1",{"v":4000,"d":"¥4,000"}]
[null,"燃气",{"v":22,"d":"¥22"},{"v":35,"d":"¥35"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":-13,"d":"(¥13)"}},null,"收入 2",{"v":1200,"d":"¥1,200"}]
[null,"用水和排污",{"v":8,"d":"¥8"},{"v":8,"d":"¥8"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"外快",{"v":300,"d":"¥300"}]
[null,"有线电视费",{"v":34,"d":"¥34"},{"v":39,"d":"¥39"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":-5,"d":"(¥5)"}},null,"每月总收入",{"$f":"SUM(H9:H11)","v":{"v":5500,"d":"¥5,500"}}]
[null,"垃圾处理",{"v":10,"d":"¥10"},{"v":10,"d":"¥10"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"保养或修理",{"v":23,"d":"¥23"},{"v":0,"d":"¥0"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":23,"d":"¥23"}},null,"结余","金额"]
[null,"日用品",{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"预计结余",{"$f":"SUM(H6-每月家庭预算!$C$3:$C$3)","v":{"v":4297,"d":"¥4,297"}}]
[null,"其他",{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"$f":"住宅[预计\n成本]-住宅[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"实际余额",{"$f":"SUM(H12-D3)","v":{"v":4183,"d":"¥4,183"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,住宅[预计\n成本])","v":{"v":1203,"d":"¥1,203"}},{"$f":"SUBTOTAL(109,住宅[实际\n成本])","v":{"v":1317,"d":"¥1,317"}},{"$f":"SUBTOTAL(109,住宅[差额])","v":{"v":-114,"d":"(¥114)"}},null,"差额",{"$f":"SUM(H16-H15)","v":{"v":-114,"d":"(¥114)"}}]
[]
[null,"交通费","预计\n成本","实际\n成本","差额",null,"贷款","预计\n成本","实际\n成本","差额"]
[null,"车辆 1 付款",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"个人",null,null,{"$f":"贷款[预计\n成本]-贷款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"车辆 2 付款",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"学生",null,null,{"$f":"贷款[预计\n成本]-贷款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"公交/出租车费",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"信用卡",null,null,{"$f":"贷款[预计\n成本]-贷款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"保险",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"信用卡",null,null,{"$f":"贷款[预计\n成本]-贷款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"牌照",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"信用卡",null,null,{"$f":"贷款[预计\n成本]-贷款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"燃油",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"贷款[预计\n成本]-贷款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"维护",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,贷款[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,贷款[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,贷款[差额])","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"交通[预计\n成本]-交通[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,交通[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,交通[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,交通[差额])","v":{"v":0,"d":"¥0"}},null,"娱乐","预计\n成本","实际\n成本","差额"]
[{"$nulls":6},"视频/DVD",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"保险","预计\n成本","实际\n成本","差额",null,"CD",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"住房",null,null,{"$f":"保险[预计\n成本]-保险[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"电影",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"健康",null,null,{"$f":"保险[预计\n成本]-保险[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"音乐会",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"人寿",null,null,{"$f":"保险[预计\n成本]-保险[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"体育活动",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"保险[预计\n成本]-保险[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"现场",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,保险[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,保险[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,保险[差额])","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"娱乐[预计\n成本]-娱乐[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"汇总",{"$f":"SUBTOTAL(109,娱乐[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,娱乐[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,娱乐[差额])","v":{"v":0,"d":"¥0"}}]
[null,"食品","预计\n成本","实际\n成本","差额"]
[null,"日用杂货",null,null,{"$f":"食物[预计\n成本]-食物[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"税款","预计\n成本","实际\n成本","差额"]
[null,"外出就餐",null,null,{"$f":"食物[预计\n成本]-食物[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"国税",null,null,{"$f":"税款[预计\n成本]-税款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"食物[预计\n成本]-食物[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"省/市/自治区税",null,null,{"$f":"税款[预计\n成本]-税款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,食物[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,食物[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,食物[差额])","v":{"v":0,"d":"¥0"}},null,"地税",null,null,{"$f":"税款[预计\n成本]-税款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"其他",null,null,{"$f":"税款[预计\n成本]-税款[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"育儿","预计\n成本","实际\n成本","差额",null,"汇总",{"$f":"SUBTOTAL(109,税款[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,税款[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,税款[差额])","v":{"v":0,"d":"¥0"}}]
[null,"医疗",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"服装",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"个人护理","预计\n成本","实际\n成本","差额"]
[null,"学费",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"医疗",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"学校用品",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"美发/美甲",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"组织费",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"服装",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"餐费",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"干洗",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"儿童保育",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"健康俱乐部",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"玩具/游戏",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"组织费",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"育儿[预计\n成本]-育儿[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"个人护理[预计\n成本]-个人护理[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,育儿[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,育儿[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,育儿[差额])","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,个人护理[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,个人护理[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,个人护理[差额])","v":{"v":0,"d":"¥0"}}]
[]
[null,"法律","预计\n成本","实际\n成本","差额",null,"宠物","预计\n成本","实际\n成本","差额"]
[null,"律师",null,null,{"$f":"法务[预计\n成本]-法务[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"食品",null,null,{"$f":"宠物[预计\n成本]-宠物[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"赡养费",null,null,{"$f":"法务[预计\n成本]-法务[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"医疗",null,null,{"$f":"宠物[预计\n成本]-宠物[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"还款",null,null,{"$f":"法务[预计\n成本]-法务[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"美容",null,null,{"$f":"宠物[预计\n成本]-宠物[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"法务[预计\n成本]-法务[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"玩具",null,null,{"$f":"宠物[预计\n成本]-宠物[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,法务[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,法务[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,法务[差额])","v":{"v":0,"d":"¥0"}},null,"其他",null,null,{"$f":"宠物[预计\n成本]-宠物[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[{"$nulls":6},"汇总",{"$f":"SUBTOTAL(109,宠物[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,宠物[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,宠物[差额])","v":{"v":0,"d":"¥0"}}]
[null,"存款/投资","预计\n成本","实际\n成本","差额"]
[null,"养老金帐户",null,null,{"$f":"存款[预计\n成本]-存款[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"礼品和捐赠","预计\n成本","实际\n成本","差额"]
[null,"投资帐户",null,null,{"$f":"存款[预计\n成本]-存款[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"慈善 1",null,null,{"$f":"礼品[预计\n成本]-礼品[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"大学",null,null,{"$f":"存款[预计\n成本]-存款[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"慈善 2",null,null,{"$f":"礼品[预计\n成本]-礼品[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"其他",null,null,{"$f":"存款[预计\n成本]-存款[实际\n成本]","v":{"v":0,"d":"¥0"}},null,"慈善 3",null,null,{"$f":"礼品[预计\n成本]-礼品[实际\n成本]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,存款[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,存款[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,存款[差额])","v":{"v":0,"d":"¥0"}},null,"汇总",{"$f":"SUBTOTAL(109,礼品[预计\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,礼品[实际\n成本])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,礼品[差额])","v":{"v":0,"d":"¥0"}}]