{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["开始","每月预算报表","每月支出","其他数据"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"模板简介"]
[null,"使用此工作簿跟踪支出和创建家庭预算。"]
[null,"在“每月预算报表”工作表中输入不同来源的预计和实际收入金额，在“每月支出”工作表中输入各类别的预计和实际支出金额。"]
[null,"“每月预算报表”工作表中将自动计算“预计和实际余额和差额”并更新“预算摘要”和“预算概览”图表。"]
[null,"可在“其他数据”工作表的表格中修改已有类别或输入新类别。"]
[null,"注： "]
[null,"“每月预算报表”工作表的列 A、“每月支出”和“其他数据”工作表的单元格 A1 中提供了更多说明信息。此文本已被有意隐藏。要删除文本，请选择列 A 或单元格 A1，然后选择“删除”。要取消隐藏文本，请选择列 A 或单元格 A1，然后更改字体颜色。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift+F10，选择“表格”选项，然后选择“替换文本”。对于数据透视表，请在表格内按 SHIFT+F10，选择“数据透视表”选项，然后选择“替换文本”选项卡。"]

{"sheet":"每月预算报表","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,13],[1,9,5,13],[2,2,2,5],[3,2,3,5],[4,2,4,5],[7,1,10,1],[7,5,10,5],[7,6,10,6],[8,9,31,9],[12,1,16,1],[12,5,16,5],[12,6,16,6],[19,1,34,6]]}
["在此工作表中创建每月预算报表。此工作表的标题位于右侧单元格中，副标题位于单元格 J1 中。选择单元格 F1 导航到“每月支出”工作表。有关此工作表使用方法的其他帮助性说明位于此列的单元格中。","预算概览",{"$nulls":3},"每月支出",{"$nulls":3},"预算摘要",null,null,"单根绿色麦秆位于此单元格。"]
["余额标签位于右侧单元格中。数据透视表切片器用于筛选表数据，位于单元格 J2 到 N6 中。若要选择多个类别，请按住 Ctrl 键进行选择。","余额",{"$nulls":7},"用于按所选类别筛选下方数据透视表的类别切片器位于此单元格。"]
["“预计余额”标签位于右侧单元格中。单元格 G3 中自动计算预计余额。","预计余额","（预计值减支出）",{"$nulls":3},{"$f":"D17-SUM(BudgetDetails[预计成本])","v":{"v":1585,"d":"¥1,585"}}]
["“实际余额”标签位于右侧单元格中。单元格 G4 中自动计算实际余额。","实际余额 ","（实际值减支出）",{"$nulls":3},{"$f":"D11-SUM(BudgetDetails[实际成本])","v":{"v":1740,"d":"¥1,740"}}]
["“差额”标签位于右侧单元格中。单元格 G5 中自动计算差额。下一条说明位于单元格 A7 中。","差额","（实际值减预计值）",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"¥155"}}]
[]
["“收入”标签位于右侧单元格，“支出”标签位于单元格 F7 中，预算摘要提示位于单元格 J7 中。","收入",{"$nulls":3},"支出",{"$nulls":3},"选择下方数据透视表，然后选择“分析”选项卡中的“刷新”进行更新。"]
["“实际收入”标签位于右侧单元格中，“实际支出”标签位于单元格 F8 中。在单元格 D8 中输入收入 1。单元格 G8 中会自动计算实际支出。","实际","收入 1",{"v":5800,"d":"¥5,800"},null,"实际",{"$f":"SUM(BudgetDetails[实际成本])","v":{"v":7860,"d":"¥7,860"}}]
["在单元格 D9 中输入收入 2。图像位于单元格 J9。数据透视表的起始单元格为 K9。若要更新数据透视表，请在“分析”选项卡中选择“刷新”。",null,"收入 2",{"v":2300,"d":"¥2,300"},{"$nulls":5},"此单元格中是图片。","类别","预计成本 ","实际成本 ","差额 "]
["在单元格 D10 中输入额外收入。",null,"额外收入",{"v":1500,"d":"¥1,500"},{"$nulls":6},"育儿",{"v":140,"d":"¥140"},{"v":140,"d":"¥140"},{"v":0,"d":"¥0"}]
["“总收入”标签位于单元格 C11 中，单元格 D11 中会自动计算总收入。下一条说明位于单元格 A13 中。",null,"总收益",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"¥9,600"}}]
[{"$nulls":10},"娱乐",{"v":400,"d":"¥400"},{"v":358,"d":"¥358"},{"v":42,"d":"¥42"}]
["“预计收入”标签位于右侧单元格中，“预计支出”标签位于单元格 F13 中。单元格 G13 中会自动计算预计支出。","预计",{"$nulls":3},"预计",{"$f":"SUM(BudgetDetails[预计成本])","v":{"v":7915,"d":"¥7,915"}}]
["在单元格 D14 中输入预计收入 1。",null,"收入 1",{"v":6000,"d":"¥6,000"},{"$nulls":6},"食物",{"v":1100,"d":"¥1,100"},{"v":1320,"d":"¥1,320"},{"v":-220,"d":"(¥220)"}]
["在单元格 D15 中输入预计收入 2。",null,"收入 2",{"v":1000,"d":"¥1,000"}]
["在单元格 D16 中输入额外收入。",null,"额外收入",{"v":2500,"d":"¥2,500"},{"$nulls":6},"礼品和捐赠",{"v":100,"d":"¥100"},{"v":125,"d":"¥125"},{"v":-25,"d":"(¥25)"}]
["“总收入”标签位于单元格 C17 中，单元格 D17 中会自动计算总收入。下一条说明位于单元格 A20 中。",null,"总收益",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"¥9,500"}}]
[{"$nulls":10},"住房",{"v":2830,"d":"¥2,830"},{"v":2702,"d":"¥2,702"},{"v":128,"d":"¥128"}]
[]
["右侧单元格中显示了按类别的支出百分比饼图。","此单元格中显示了按类别的支出百分比饼图。",{"$nulls":8},"保险",{"v":900,"d":"¥900"},{"v":900,"d":"¥900"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"贷款",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"个人护理",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"v":10,"d":"¥10"}]
[]
[{"$nulls":10},"宠物",{"v":170,"d":"¥170"},{"v":100,"d":"¥100"},{"v":70,"d":"¥70"}]
[]
[{"$nulls":10},"存款或投资",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"税费",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"v":0,"d":"¥0"}]
[]
[{"$nulls":10},"交通",{"v":1425,"d":"¥1,425"},{"v":1375,"d":"¥1,375"},{"v":50,"d":"¥50"}]
[]
[{"$nulls":10},"总计",{"v":7915,"d":"¥7,915"},{"v":7860,"d":"¥7,860"},{"v":55,"d":"¥55"}]

{"sheet":"每月支出","index":2,"n_rows":62,"n_cols":7,"rows_kept":62,"merged":[[0,1,0,4],[0,5,0,6]]}
["在此工作表中计算每月支出。此工作表的标题位于右侧单元格中。选择单元格 F1 导航到“每月预算报表”工作表。","每月支出",{"$nulls":3},"每月预算报表"]
[" 在“预算明细”表中输入数据，从右侧单元格开始输入。","说明","类别","预计成本","实际成本","差额","实际成本概览"]
[null,"课外活动","育儿",{"v":40,"d":"¥40"},{"v":40,"d":"¥40"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":40,"d":"¥40"}}]
[null,"医疗","育儿",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"学校用品","育儿",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"学费","育儿",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":100,"d":"¥100"}}]
[null,"音乐会","娱乐",{"v":50,"d":"¥50"},{"v":40,"d":"¥40"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":10,"d":"¥10"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":40,"d":"¥40"}}]
[null,"现场戏剧表演","娱乐",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":150,"d":"¥150"}}]
[null,"电影","娱乐",{"v":50,"d":"¥50"},{"v":28,"d":"¥28"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":22,"d":"¥22"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":28,"d":"¥28"}}]
[null,"音乐（CD、下载内容等）","娱乐",{"v":50,"d":"¥50"},{"v":30,"d":"¥30"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":20,"d":"¥20"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":30,"d":"¥30"}}]
[null,"体育活动","娱乐",{"v":0,"d":"¥0"},{"v":40,"d":"¥40"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-40,"d":"(¥40)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":40,"d":"¥40"}}]
[null,"视频/DVD（购买）","娱乐",{"v":20,"d":"¥20"},{"v":50,"d":"¥50"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-30,"d":"(¥30)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}}]
[null,"视频/DVD（租赁）","娱乐",{"v":30,"d":"¥30"},{"v":20,"d":"¥20"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":10,"d":"¥10"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":20,"d":"¥20"}}]
[null,"外出就餐","食物",{"v":1000,"d":"¥1,000"},{"v":1200,"d":"¥1,200"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-200,"d":"(¥200)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":1200,"d":"¥1,200"}}]
[null,"日用杂货","食物",{"v":100,"d":"¥100"},{"v":120,"d":"¥120"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-20,"d":"(¥20)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":120,"d":"¥120"}}]
[null,"捐赠 1","礼品和捐赠",{"v":75,"d":"¥75"},{"v":100,"d":"¥100"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-25,"d":"(¥25)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":100,"d":"¥100"}}]
[null,"捐赠 2","礼品和捐赠",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":25,"d":"¥25"}}]
[null,"礼品 1","礼品和捐赠",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"礼品 2","礼品和捐赠",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"有线电视/卫星电视费用","住房",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":100,"d":"¥100"}}]
[null,"电费","住房",{"v":45,"d":"¥45"},{"v":50,"d":"¥50"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-5,"d":"(¥5)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}}]
[null,"燃气","住房",{"v":300,"d":"¥300"},{"v":400,"d":"¥400"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-100,"d":"(¥100)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":400,"d":"¥400"}}]
[null,"房屋清洁服务","住房",{"v":200,"d":"¥200"},null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":200,"d":"¥200"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"维护","住房",{"v":200,"d":"¥200"},{"v":150,"d":"¥150"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":150,"d":"¥150"}}]
[null,"抵押贷款或租金","住房",{"v":1700,"d":"¥1,700"},{"v":1700,"d":"¥1,700"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":1700,"d":"¥1,700"}}]
[null,"天燃气/燃油","住房",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"联机/Internet 服务","住房",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":100,"d":"¥100"}}]
[null,"电话（移动）","住房",{"v":60,"d":"¥60"},{"v":60,"d":"¥60"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":60,"d":"¥60"}}]
[null,"电话（住宅）","住房",{"v":35,"d":"¥35"},{"v":39,"d":"¥39"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-4,"d":"(¥4)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":39,"d":"¥39"}}]
[null,"日用品","住房",{"v":40,"d":"¥40"},{"v":55,"d":"¥55"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-15,"d":"(¥15)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":55,"d":"¥55"}}]
[null,"垃圾处理和回收","住房",{"v":25,"d":"¥25"},{"v":22,"d":"¥22"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":3,"d":"¥3"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":22,"d":"¥22"}}]
[null,"用水和排污","住房",{"v":25,"d":"¥25"},{"v":26,"d":"¥26"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-1,"d":"(¥1)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":26,"d":"¥26"}}]
[null,"健康","保险",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":400,"d":"¥400"}}]
[null,"住房","保险",{"v":400,"d":"¥400"},{"v":400,"d":"¥400"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":400,"d":"¥400"}}]
[null,"人寿","保险",{"v":100,"d":"¥100"},{"v":100,"d":"¥100"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":100,"d":"¥100"}}]
[null,"信用卡 1","贷款",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":200,"d":"¥200"}}]
[null,"信用卡 2","贷款",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"信用卡 3","贷款",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"个人","贷款",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"学生","贷款",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"服装","个人护理",{"v":150,"d":"¥150"},{"v":140,"d":"¥140"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":10,"d":"¥10"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":140,"d":"¥140"}}]
[null,"干洗","个人护理",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"美发/美甲","个人护理",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"健康俱乐部","个人护理",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"医疗","个人护理",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"食物","宠物",{"v":150,"d":"¥150"},{"v":75,"d":"¥75"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":75,"d":"¥75"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":75,"d":"¥75"}}]
[null,"修饰","宠物",{"v":20,"d":"¥20"},{"v":25,"d":"¥25"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-5,"d":"(¥5)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":25,"d":"¥25"}}]
[null,"医疗","宠物",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"玩具","宠物",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"投资帐户","存款或投资",{"v":200,"d":"¥200"},{"v":200,"d":"¥200"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":200,"d":"¥200"}}]
[null,"养老金帐户","存款或投资",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"国税","税费",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":300,"d":"¥300"}}]
[null,"本地","税费",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"省/市/自治区税","税费",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"公交/出租车费","交通",{"v":100,"d":"¥100"},{"v":150,"d":"¥150"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":-50,"d":"(¥50)"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":150,"d":"¥150"}}]
[null,"燃油","交通",{"v":450,"d":"¥450"},{"v":400,"d":"¥400"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":400,"d":"¥400"}}]
[null,"保险","交通",{"v":300,"d":"¥300"},{"v":300,"d":"¥300"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":300,"d":"¥300"}}]
[null,"牌照 ","交通",{"v":25,"d":"¥25"},{"v":25,"d":"¥25"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":25,"d":"¥25"}}]
[null,"维护","交通",{"v":100,"d":"¥100"},{"v":50,"d":"¥50"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":50,"d":"¥50"}}]
[null,"停车费","交通",null,null,{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}}]
[null,"汽车还款","交通",{"v":450,"d":"¥450"},{"v":450,"d":"¥450"},{"$f":"BudgetDetails[[#This Row],[预计成本]]-BudgetDetails[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0"}},{"$f":"BudgetDetails[[#This Row],[实际成本]]","v":{"v":450,"d":"¥450"}}]
[null,"汇总",null,{"$f":"SUBTOTAL(109,BudgetDetails[预计成本])","v":{"v":7915,"d":"¥7,915"}},{"$f":"SUBTOTAL(109,BudgetDetails[实际成本])","v":{"v":7860,"d":"¥7,860"}},{"$f":"SUBTOTAL(109,BudgetDetails[差额])","v":{"v":55,"d":"¥55"}}]

{"sheet":"其他数据","index":3,"n_rows":15,"n_cols":5,"rows_kept":15}
["使用此工作表修改“每月支出”工作表“预算明细”表中的“类别”列下拉列表。为此，在“预算类别查找”表中修改已有类别或输入新类别，从单元格 E2 开始。链接到“每月预算报表”工作表中“预算概览”图表的数据透视表从单元格 B2 开始。","“预算概览”图表的数据透视表",null,null,"预算明细类别的查找列表"]
[null,"类别","费用",null,"预算类别查找"]
[null,"育儿",{"v":140,"d":"¥140"},null,"育儿"]
[null,"娱乐",{"v":358,"d":"¥358"},null,"娱乐"]
[null,"食物",{"v":1320,"d":"¥1,320"},null,"食物"]
[null,"礼品和捐赠",{"v":125,"d":"¥125"},null,"礼品和捐赠"]
[null,"住房",{"v":2702,"d":"¥2,702"},null,"住房"]
[null,"保险",{"v":900,"d":"¥900"},null,"保险"]
[null,"贷款",{"v":200,"d":"¥200"},null,"贷款"]
[null,"个人护理",{"v":140,"d":"¥140"},null,"个人护理"]
[null,"宠物",{"v":100,"d":"¥100"},null,"宠物"]
[null,"存款或投资",{"v":200,"d":"¥200"},null,"存款或投资"]
[null,"税费",{"v":300,"d":"¥300"},null,"税费"]
[null,"交通",{"v":1375,"d":"¥1,375"},null,"交通"]
[null,"总计",{"v":7860,"d":"¥7,860"}]