{"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,6],[2,0,2,1],[2,5,2,6],[8,5,8,6],[18,0,18,3],[27,5,27,8],[29,0,29,3],[36,0,36,3],[37,5,37,8],[42,0,42,3],[44,5,44,8],[54,0,54,3],[54,5,54,8],[61,0,61,3],[62,5,62,8]]}
["家庭月度预算"]
[]
["总预计成本",null,"总实际成本","总差异",null,"预计月成本"]
[{"$nulls":5},"收入 1",{"v":4000,"d":"$4,000"}]
[{"$nulls":5},"收入 2",{"v":1200,"d":"$1,200"}]
["住房","预计成本","实际成本","差异",null,"额外收入",{"v":300,"d":"$300"}]
["抵押贷款或租金",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":0,"d":"$0"}},null,"总月收入",{"$f":"SUM(G4:G6)","v":{"v":5500,"d":"$5,500"}}]
["第二抵押贷款或租金",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":0,"d":"$0"}}]
["电话",{"v":62,"d":"$62"},{"v":100,"d":"$100"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":-38,"d":"($38)"}},null,"实际月收入"]
["电费",{"v":44,"d":"$44"},{"v":125,"d":"$125"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":-81,"d":"($81)"}},null,"收入 1",{"v":4000,"d":"$4,000"}]
["煤气",{"v":22,"d":"$22"},{"v":35,"d":"$35"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":-13,"d":"($13)"}},null,"收入 2",{"v":1200,"d":"$1,200"}]
["水和下水",{"v":8,"d":"$8"},{"v":8,"d":"$8"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":0,"d":"$0"}},null,"额外收入",{"v":300,"d":"$300"}]
["线缆",{"v":34,"d":"$34"},{"v":39,"d":"$39"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":-5,"d":"($5)"}},null,"总月收入",{"$f":"SUM(G10:G12)","v":{"v":5500,"d":"$5,500"}}]
["垃圾清理",{"v":10,"d":"$10"},{"v":10,"d":"$10"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":0,"d":"$0"}}]
["维护或维修",{"v":23,"d":"$23"},{"v":0,"d":"$0"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":23,"d":"$23"}},null,"预计结余\n",{"$f":"SUM(G7-B4)","v":{"v":5500,"d":"$5,500"}}]
["供应",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":0,"d":"$0"}},null,"实际结余",{"$f":"SUM(G13-C4)","v":{"v":5500,"d":"$5,500"}}]
["其他",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"住房[预计成本]-住房[实际成本]","v":{"v":0,"d":"$0"}},null,"差异",{"$f":"SUM(G16-G15)","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,住房[预计成本])","v":{"v":1203,"d":"$1,203"}},{"$f":"SUBTOTAL(109,住房[实际成本])","v":{"v":1317,"d":"$1,317"}},{"$f":"SUBTOTAL(109,住房[差异])","v":{"v":-114,"d":"($114)"}}]
[]
["运输","预计成本","实际成本","差异",null,"贷款","预计成本","实际成本","差异"]
["交通工具 1 付款",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"个人",null,null,{"$f":"贷款[预计成本]-贷款[实际成本]","v":{"v":0,"d":"$0"}}]
["交通工具 2 付款",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"学生",null,null,{"$f":"贷款[预计成本]-贷款[实际成本]","v":{"v":0,"d":"$0"}}]
["公交/出租车费",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"信用卡",null,null,{"$f":"贷款[预计成本]-贷款[实际成本]","v":{"v":0,"d":"$0"}}]
["保险",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"信用卡",null,null,{"$f":"贷款[预计成本]-贷款[实际成本]","v":{"v":0,"d":"$0"}}]
["执照",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"信用卡",null,null,{"$f":"贷款[预计成本]-贷款[实际成本]","v":{"v":0,"d":"$0"}}]
["燃料",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"其他",null,null,{"$f":"贷款[预计成本]-贷款[实际成本]","v":{"v":0,"d":"$0"}}]
["维护",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}},null,"总计",{"$f":"SUBTOTAL(109,贷款[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,贷款[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,贷款[差异])","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"运输[预计成本]-运输[实际成本]","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,运输[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,运输[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,运输[差异])","v":{"v":0,"d":"$0"}},null,"娱乐","预计成本","实际成本","差异"]
[{"$nulls":5},"视频/DVD",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
["保险","预计成本","实际成本","差异",null,"CD",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
["家",null,null,{"$f":"保险[预计成本]-保险[实际成本]","v":{"v":0,"d":"$0"}},null,"电影",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
["健康",null,null,{"$f":"保险[预计成本]-保险[实际成本]","v":{"v":0,"d":"$0"}},null,"音乐会",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
["生活",null,null,{"$f":"保险[预计成本]-保险[实际成本]","v":{"v":0,"d":"$0"}},null,"体育活动",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"保险[预计成本]-保险[实际成本]","v":{"v":0,"d":"$0"}},null,"动感影院",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,保险[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,保险[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,保险[差异])","v":{"v":0,"d":"$0"}},null,"其他",null,null,{"$f":"娱乐[预计成本]-娱乐[实际成本]","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"总计",{"$f":"SUBTOTAL(109,娱乐[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,娱乐[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,娱乐[差异])","v":{"v":0,"d":"$0"}}]
["食品","预计成本","实际成本","差异"]
["日用杂货",null,null,{"$f":"食品[预计成本]-食品[实际成本]","v":{"v":0,"d":"$0"}},null,"税费","预计成本","实际成本","差异"]
["外出就餐",null,null,{"$f":"食品[预计成本]-食品[实际成本]","v":{"v":0,"d":"$0"}},null,"国家",null,null,{"$f":"税费[预计成本]-税费[实际成本]","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"食品[预计成本]-食品[实际成本]","v":{"v":0,"d":"$0"}},null,"省/市/自治区",null,null,{"$f":"税费[预计成本]-税费[实际成本]","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,食品[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,食品[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,食品[差异])","v":{"v":0,"d":"$0"}},null,"地方",null,null,{"$f":"税费[预计成本]-税费[实际成本]","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"其他",null,null,{"$f":"税费[预计成本]-税费[实际成本]","v":{"v":0,"d":"$0"}}]
["儿童","预计成本","实际成本","差异",null,"总计",{"$f":"SUBTOTAL(109,税费[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,税费[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,税费[差异])","v":{"v":0,"d":"$0"}}]
["医疗",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}}]
["衣物",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"个人护理","预计成本","实际成本","差异"]
["学费",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"医疗",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["学校供应",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"头发/指甲",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["组织应付款或会费",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"衣物",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["午餐费",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"干洗",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["儿童护理",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"健康俱乐部",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["玩具/游戏",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"组织应付款/费用",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"儿童[预计成本]-儿童[实际成本]","v":{"v":0,"d":"$0"}},null,"其他",null,null,{"$f":"个人护理[预计成本]-个人护理[实际成本]","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,儿童[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,儿童[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,儿童[差异])","v":{"v":0,"d":"$0"}},null,"总计",{"$f":"SUBTOTAL(109,个人护理[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,个人护理[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,个人护理[差异])","v":{"v":0,"d":"$0"}}]
[]
["法律","预计成本","实际成本","差异",null,"宠物","预计成本","实际成本","差异"]
["律师",null,null,{"$f":"法律[预计成本]-法律[实际成本]","v":{"v":0,"d":"$0"}},null,"食品",null,null,{"$f":"宠物[预计成本]-宠物[实际成本]","v":{"v":0,"d":"$0"}}]
["赡养费",null,null,{"$f":"法律[预计成本]-法律[实际成本]","v":{"v":0,"d":"$0"}},null,"医疗",null,null,{"$f":"宠物[预计成本]-宠物[实际成本]","v":{"v":0,"d":"$0"}}]
["付款",null,null,{"$f":"法律[预计成本]-法律[实际成本]","v":{"v":0,"d":"$0"}},null,"装饰",null,null,{"$f":"宠物[预计成本]-宠物[实际成本]","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"法律[预计成本]-法律[实际成本]","v":{"v":0,"d":"$0"}},null,"玩具",null,null,{"$f":"宠物[预计成本]-宠物[实际成本]","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,法律[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,法律[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,法律[差异])","v":{"v":0,"d":"$0"}},null,"其他",null,null,{"$f":"宠物[预计成本]-宠物[实际成本]","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"总计",{"$f":"SUBTOTAL(109,宠物[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,宠物[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,宠物[差异])","v":{"v":0,"d":"$0"}}]
["储蓄/投资","预计成本","实际成本","差异"]
["退休帐户",null,null,{"$f":"储蓄[预计成本]-储蓄[实际成本]","v":{"v":0,"d":"$0"}},null,"礼物和捐款","预计成本","实际成本","差异"]
["投资帐户",null,null,{"$f":"储蓄[预计成本]-储蓄[实际成本]","v":{"v":0,"d":"$0"}},null,"慈善活动 1",null,null,{"$f":"礼物[预计成本]-礼物[实际成本]","v":{"v":0,"d":"$0"}}]
["大学",null,null,{"$f":"储蓄[预计成本]-储蓄[实际成本]","v":{"v":0,"d":"$0"}},null,"慈善活动 2",null,null,{"$f":"礼物[预计成本]-礼物[实际成本]","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"储蓄[预计成本]-储蓄[实际成本]","v":{"v":0,"d":"$0"}},null,"慈善活动 3",null,null,{"$f":"礼物[预计成本]-礼物[实际成本]","v":{"v":0,"d":"$0"}}]
["总计",{"$f":"SUBTOTAL(109,储蓄[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,储蓄[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,储蓄[差异])","v":{"v":0,"d":"$0"}},null,"总计",{"$f":"SUBTOTAL(109,礼物[预计成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,礼物[实际成本])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,礼物[差异])","v":{"v":0,"d":"$0"}}]