{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始","个人月度预算"],"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"关于此模板"]
[null,"使用此“个人月度预算”工作表来跟踪预计和实际每月收入以及预计和实际支出​​。"]
[null,"在各表中输入不同类别发生的费用。"]
[null,"预计余额、实际余额和差额将自动进行计算。"]
[null,"备注： "]
[null,"“个人月度预算”工作表的 A 列中提供了附加说明。此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关该工作表中各表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"个人月度预算","index":1,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[3,1,5,1],[3,2,3,3],[3,6,4,8],[3,9,4,9],[4,2,4,3],[5,2,5,3],[5,6,6,8],[5,9,6,9],[7,1,9,1],[7,2,7,3],[7,6,8,8],[7,9,8,9],[8,2,8,3],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,1,64,4]]}
["在此工作表中创建个人月度预算。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头以开始了解。"]
["此工作表的标题位于右侧单元格中。下一条指示位于单元格 A4 中。","个人月度预算"]
[]
["预计每月收入标签位于右侧单元格中。在单元格 E4 中输入收入 1，在 E5 中输入额外收入以在 E6 中计算月度总收入。下一条指示位于单元格 A6 中。","预计月度收入","收入 1",null,{"v":4300,"d":"¥4,300.00"},null,"预计余额\n（预计收入减预计支出）",null,null,{"$f":"E6-J59","v":{"v":3405,"d":"¥3,405.00"}}]
[null,null,"额外收入",null,{"v":300,"d":"¥300.00"}]
["预计余额、实际余额和差额分别在单元格 J4、J6 和 J8 中自动进行计算。下一条指示位于单元格 A8 中。",null,"月度总收入",null,{"$f":"SUM(E4:E5)","v":{"v":4600,"d":"¥4,600.00"}},null,"实际余额\n（实际收入减实际支出）",null,null,{"$f":"E10-J61","v":{"v":3064,"d":"¥3,064.00"}}]
[]
["实际每月收入标签位于右侧单元格中。在单元格 E8 中输入收入 1，在 E9 中输入额外收入以在 E10 中计算月度总收入。下一条指示位于单元格 A12 中。","实际月度收入","收入 1",null,{"v":4000,"d":"¥4,000.00"},null,"差额\n（实际值减预计值）",null,null,{"$f":"J6-J4","v":{"v":-341,"d":"(¥341.00)"}}]
[null,null,"额外收入",null,{"v":300,"d":"¥300.00"}]
[null,null,"月度总收入",null,{"$f":"SUM(E8:E9)","v":{"v":4300,"d":"¥4,300.00"}}]
[]
["在“住房”表中从右侧单元格开始输入详细信息，在“娱乐”表中从单元格 G12 开始输入。下一条指示位于单元格 A25 中。","住房","预计支出","实际成本","差额",null,"娱乐","预计支出","实际成本","差额"]
[null,"抵押贷款或租金",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"视频/DVD",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"电话",{"v":54,"d":"¥54.00"},{"v":100,"d":"¥100.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":-46,"d":"¥-46.00"}},null,"CD",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"电费",{"v":44,"d":"¥44.00"},{"v":56,"d":"¥56.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":-12,"d":"¥-12.00"}},null,"电影",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"燃气",{"v":22,"d":"¥22.00"},{"v":28,"d":"¥28.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":-6,"d":"¥-6.00"}},null,"音乐会",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"用水和排污",{"v":8,"d":"¥8.00"},{"v":8,"d":"¥8.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"体育活动",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"有线电视费",{"v":34,"d":"¥34.00"},{"v":34,"d":"¥34.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"现场",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"垃圾处理",{"v":10,"d":"¥10.00"},{"v":10,"d":"¥10.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"其他",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"保养或修理",{"v":23,"d":"¥23.00"},{"v":0,"d":"¥0.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":23,"d":"¥23.00"}},null,"其他",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"日用品",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"其他",null,null,{"$f":"娱乐[[#This Row],[预计支出]]-娱乐[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"其他",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$f":"住房[[#This Row],[预计支出]]-住房[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"小计",null,null,{"$f":"SUBTOTAL(109,娱乐[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,住房[差额])","v":{"v":-41,"d":"¥-41.00"}}]
[{"$nulls":6},"贷款","预计成本","实际成本","差额"]
["在“交通”表中从右侧单元格开始输入详细信息，在“贷款”表中从单元格 G24 开始输入。下一条指示位于单元格 A35 中。","交通","预计成本","实际成本","差额",null,"个人",null,null,{"$f":"贷款[[#This Row],[预计成本]]-贷款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"汽车还款",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"学生",null,null,{"$f":"贷款[[#This Row],[预计成本]]-贷款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"公交/出租车费",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"信用卡",null,null,{"$f":"贷款[[#This Row],[预计成本]]-贷款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"保险",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"信用卡",null,null,{"$f":"贷款[[#This Row],[预计成本]]-贷款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"牌照",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"信用卡",null,null,{"$f":"贷款[[#This Row],[预计成本]]-贷款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"燃油",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"其他",null,null,{"$f":"贷款[[#This Row],[预计成本]]-贷款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"维护",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"小计",null,null,{"$f":"SUBTOTAL(109,贷款[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他",null,null,{"$f":"交通[[#This Row],[预计成本]]-交通[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,交通[差额])","v":{"v":0,"d":"¥0.00"}},null,"税款","预计成本","实际成本","差额"]
[{"$nulls":6},"国税",null,null,{"$f":"税款[[#This Row],[预计成本]]-税款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
["在“保险”表中从右侧单元格开始输入详细信息，在“税款”表中从单元格 G33 开始输入。下一条指示位于单元格 A42 中。","保险","预计成本","实际成本","差额",null,"省/市/自治区税",null,null,{"$f":"税款[[#This Row],[预计成本]]-税款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"住房",null,null,{"$f":"保险[[#This Row],[预计成本]]-保险[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"地税",null,null,{"$f":"税款[[#This Row],[预计成本]]-税款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"健康",null,null,{"$f":"保险[[#This Row],[预计成本]]-保险[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"其他",null,null,{"$f":"税款[[#This Row],[预计成本]]-税款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"人寿",null,null,{"$f":"保险[[#This Row],[预计成本]]-保险[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"小计",null,null,{"$f":"SUBTOTAL(109,税款[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他",null,null,{"$f":"保险[[#This Row],[预计成本]]-保险[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,保险[差额])","v":{"v":0,"d":"¥0.00"}},null,"存款或投资","预计成本","实际成本","差额"]
[{"$nulls":6},"养老金帐户",null,null,{"$f":"存款[[#This Row],[预计成本]]-存款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
["在“食品”表中从右侧单元格开始输入详细信息，在“存款”表中从单元格 G40 开始输入。下一条指示位于单元格 A48 中。","食品","预计成本","实际成本","差额",null,"投资帐户",null,null,{"$f":"存款[[#This Row],[预计成本]]-存款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"日用杂货",null,null,{"$f":"食品[[#This Row],[预计成本]]-食品[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"其他",null,null,{"$f":"存款[[#This Row],[预计成本]]-存款[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"外出就餐",null,null,{"$f":"食品[[#This Row],[预计成本]]-食品[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"小计",null,null,{"$f":"SUBTOTAL(109,存款[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他",null,null,{"$f":"食品[[#This Row],[预计成本]]-食品[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,食品[差额])","v":{"v":0,"d":"¥0.00"}},null,"礼品和捐赠","预计成本","实际成本","差额"]
[{"$nulls":6},"慈善 1",null,null,{"$f":"礼品[[#This Row],[预计成本]]-礼品[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
["在“宠物”表中从右侧单元格开始输入详细信息，在“礼品”表中从单元格 G46 开始输入。下一条指示位于单元格 A56 中。","宠物","预计成本","实际成本","差额",null,"慈善 2",null,null,{"$f":"礼品[[#This Row],[预计成本]]-礼品[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"食品",null,null,{"$f":"宠物[[#This Row],[预计成本]]-宠物[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"慈善 3",null,null,{"$f":"礼品[[#This Row],[预计成本]]-礼品[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"医疗",null,null,{"$f":"宠物[[#This Row],[预计成本]]-宠物[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"小计",null,null,{"$f":"SUBTOTAL(109,礼品[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"美容",null,null,{"$f":"宠物[[#This Row],[预计成本]]-宠物[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"玩具",null,null,{"$f":"宠物[[#This Row],[预计成本]]-宠物[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"法务","预计成本","实际成本","差额"]
[null,"其他",null,null,{"$f":"宠物[[#This Row],[预计成本]]-宠物[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"律师",null,null,{"$f":"法务[[#This Row],[预计成本]]-法务[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,宠物[差额])","v":{"v":0,"d":"¥0.00"}},null,"赡养费",null,null,{"$f":"法务[[#This Row],[预计成本]]-法务[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":6},"抵押或判决付款",null,null,{"$f":"法务[[#This Row],[预计成本]]-法务[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
["在“个人护理”表中从右侧单元格开始输入详细信息，在“法务”表中从单元格 G52 开始输入。下一条指示位于单元格 A59 中。","个人护理","预计成本","实际成本","差额",null,"其他",null,null,{"$f":"法务[[#This Row],[预计成本]]-法务[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"医疗",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"小计",null,null,{"$f":"SUBTOTAL(109,法务[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"美发/美甲",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
["总预计支出、总实际支出和总差额分别在单元格 J59、J61 和 J63 中自动进行计算。","服装",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"预计总支出",null,null,{"$f":"SUBTOTAL(109,住房[预计支出],交通[预计成本],保险[预计成本],食品[预计成本],宠物[预计成本],个人护理[预计成本],娱乐[预计支出],贷款[预计成本],税款[预计成本],存款[预计成本],礼品[预计成本],法务[预计成本])","v":{"v":1195,"d":"¥1,195.00"}}]
[null,"干洗",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"健康俱乐部",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"实际总支出",null,null,{"$f":"SUBTOTAL(109,住房[实际成本],交通[实际成本],保险[实际成本],食品[实际成本],宠物[实际成本],个人护理[实际成本],娱乐[实际成本],贷款[实际成本],税款[实际成本],存款[实际成本],礼品[实际成本],法务[实际成本])","v":{"v":1236,"d":"¥1,236.00"}}]
[null,"组织费",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"其他",null,null,{"$f":"个人护理[[#This Row],[预计成本]]-个人护理[[#This Row],[实际成本]]","v":{"v":0,"d":"¥0.00"}},null,"总差额",null,null,{"$f":"J59-J61","v":{"v":-41,"d":"(¥41.00)"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,个人护理[差额])","v":{"v":0,"d":"¥0.00"}}]