{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始","个人月度预算"],"not_rendered":{"images":1},"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":66,"n_cols":10,"rows_kept":66,"merged":[[3,1,3,2],[3,4,4,6],[3,7,4,7],[5,4,6,6],[5,7,6,7],[7,4,8,6],[7,7,8,7],[8,1,8,2],[24,6,24,9],[25,1,25,4],[33,6,33,9],[35,1,35,4],[40,6,40,9],[42,1,42,4],[46,6,46,9],[48,1,48,4],[52,6,52,9],[56,1,56,4],[59,6,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,6,65,8],[64,9,65,9],[66,1,66,4]]}
["在此工作表中创建个人月度预算。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头以开始了解。"]
["此工作表的标题位于右侧单元格中。下一条说明位于单元格 A5 中。",null,"个人月度预算"]
[]
["预计每月收入标签位于右侧单元格中。分别在单元格 C5 和 C6 中输入收入 1 和额外收入，用于计算 C7 中的每月总收入。下一条指示位于单元格 A7 中。","预计每月收入",null,null,"预计余额\n（预计收入减预计支出）",null,null,{"$f":"C7-J61","v":{"v":3405,"d":"¥3,405.00"}}]
[null,"收入 1",{"v":4300,"d":"¥4,300.00"}]
[null,"额外收入",{"v":300,"d":"¥300.00"},null,"实际余额\n（实际收入减实际支出）",null,null,{"$f":"C12-J63","v":{"v":3064,"d":"¥3,064.00"}}]
["预计余额、实际余额和差额分别在单元格 H4、H6 和 H8 中自动进行计算。下一条指示位于单元格 A9 中。","每月总收入",{"$f":"SUM(C5:C6)","v":{"v":4600,"d":"¥4,600.00"}}]
[{"$nulls":4},"差额\n（实际值减预计值）",null,null,{"$f":"H6-H4","v":{"v":-341,"d":"(¥341.00)"}}]
["实际每月收入标签位于右侧单元格中。分别在单元格 C10 和 C11 中输入收入 1 和额外收入，用于计算 C12 中的每月总收入。下一条指示位于单元格 A14 中。","实际每月收入"]
[null,"收入 1",{"v":4000,"d":"¥4,000.00"}]
[null,"额外收入",{"v":300,"d":"¥300.00"}]
[null,"每月总收入",{"$f":"SUM(C10:C11)","v":{"v":4300,"d":"¥4,300.00"}}]
[]
["在“住房”表中从右侧单元格开始输入详细信息，在“娱乐”表中从单元格 G14 开始输入详细信息。下一条说明位于单元格 A27 中。","住房","预计成本","实际成本","差额",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},"贷款","预计成本","实际成本","差额"]
["在“交通”表中从右侧单元格开始输入详细信息，在“贷款”表中从单元格 G26 开始输入详细信息。下一条指示位于单元格 A37 中。","交通","预计成本","实际成本","差额",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"}}]
["在“保险”表中从右侧单元格开始输入详细信息，在“税款”表中从单元格 G35 开始输入详细信息。下一条指示位于单元格 A44 中。","保险","预计成本","实际成本","差额",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"}}]
["在“食品”表中从右侧单元格开始输入详细信息，在“存款”表中从单元格 G42 开始输入详细信息。下一条指示位于单元格 A50 中。","食品","预计成本","实际成本","差额",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"}}]
["在“宠物”表中从右侧单元格开始输入详细信息，在“礼品”表中从单元格 G48 开始输入详细信息。下一条指示位于单元格 A58 中。","宠物","预计成本","实际成本","差额",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"}}]
["在“个人护理”表中从右侧单元格开始输入详细信息，在“法务”表中从单元格 G54 开始输入详细信息。下一条指示位于单元格 A61 中。","个人护理","预计成本","实际成本","差额",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"}}]
["总预计支出、总实际支出和总差额分别在单元格 J61、J63 和 J65 中自动进行计算。","服装",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":"J61-J63","v":{"v":-41,"d":"(¥41.00)"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,个人护理[差额])","v":{"v":0,"d":"¥0.00"}}]