{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始","假期预算规划表"],"not_rendered":{"defined_names":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":32,"n_cols":12,"rows_kept":32,"merged":[[1,1,5,4],[2,8,2,9],[3,8,3,9],[4,8,4,9],[6,1,6,4],[6,8,6,11],[15,1,15,4],[15,8,15,11],[25,1,25,4],[25,8,25,11]]}
["在此工作表的相应表中输入每个类别的预算和实际费用。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头以开始了解。 "]
["此工作表的标题位于右侧单元格中。","节日预算规划表"]
["单元格 K3 中自动计算“假期预算”。",{"$nulls":7},"假日预算",null,{"$f":"SUM(礼品[预算],包装[预算],(差旅[预算],(餐饮[预算],(娱乐[预算],其他[预算]))))","v":{"v":750,"d":"¥750.00"}}]
["单元格 K4 中自动计算“实际支出”。",{"$nulls":7},"实际支出",null,{"$f":"SUM((礼品[实际开支],(包装[实际开支],(差旅[实际开支],(餐饮[实际开支],(娱乐[实际开支],(其他[实际开支])))))))","v":{"v":820,"d":"¥820.00"}}]
["单元格 K5 中自动计算差额。下一步说明位于单元格 A7。",{"$nulls":7},"差额（超出/符合预算）",null,{"$f":"SUM(K3-K4)","v":{"v":-70,"d":"(¥70.00)"}}]
[]
["“礼品”标签位于右侧单元格，“假日餐饮”标签位于单元格 I7。","礼品",{"$nulls":6},"假日餐饮"]
["在“礼品”表中从右侧单元格开始输入费用，在“餐饮”表中从单元格 I8 开始输入费用。下一条说明位于单元格 A16 中。","项目​​","预算","实际开支","差额",{"$nulls":3},"项目​​","预算","实际开支","差额"]
[null,"家庭",{"v":500,"d":"¥500.00"},{"v":495,"d":"¥495.00"},{"$f":"礼品[[#This Row],[预算]]-礼品[[#This Row],[实际开支]]","v":{"v":5,"d":"¥5.00"}},{"$nulls":3},"日用杂货",null,null,{"$f":"餐饮[[#This Row],[预算]]-餐饮[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}}]
[null,"好友",{"v":250,"d":"¥250.00"},{"v":325,"d":"¥325.00"},{"$f":"礼品[[#This Row],[预算]]-礼品[[#This Row],[实际开支]]","v":{"v":-75,"d":"¥-75.00"}},{"$nulls":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"}},{"$nulls":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"}},{"$nulls":3},"其他（在此行的最后一列按 tab，添加行）",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"}},{"$nulls":3},"汇总",{"$f":"SUBTOTAL(109,餐饮[预算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,餐饮[实际开支])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,餐饮[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"其他（在此行的最后一列按 tab，添加行）",null,null,{"$f":"礼品[[#This Row],[预算]]-礼品[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,礼品[预算])","v":{"v":750,"d":"¥750.00"}},{"$f":"SUBTOTAL(109,礼品[实际开支])","v":{"v":820,"d":"¥820.00"}},{"$f":"SUBTOTAL(109,礼品[差额])","v":{"v":-70,"d":"¥-70.00"}}]
["“包装”标签位于右侧单元格，“娱乐”标签位于单元格 I16。","包装",{"$nulls":6},"娱乐"]
["在“包装”表中从右侧单元格开始输入费用，在“娱乐”表中从单元格 I17 开始输入费用。下一条说明位于单元格 A26 中。","项目​​","预算","实际开支","差额",{"$nulls":3},"项目​​","预算","实际开支","差额"]
[null,"礼品包装",null,null,{"$f":"包装[[#This Row],[预算]]-包装[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":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"}},{"$nulls":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"}},{"$nulls":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"}},{"$nulls":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"}},{"$nulls":3},"门票",null,null,{"$f":"娱乐[[#This Row],[预算]]-娱乐[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}}]
[null,"其他（在此行的最后一列按 tab，添加行）",null,null,{"$f":"包装[[#This Row],[预算]]-包装[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},"外出用餐",null,null,{"$f":"娱乐[[#This Row],[预算]]-娱乐[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,包装[预算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,包装[实际开支])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,包装[差额])","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},"其他（在此行的最后一列按 tab，添加行）",null,null,{"$f":"娱乐[[#This Row],[预算]]-娱乐[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":8},"汇总",{"$f":"SUBTOTAL(109,娱乐[预算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[实际开支])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[差额])","v":{"v":0,"d":"¥0.00"}}]
["“旅行”标签位于右侧单元格，“其他”标签位于单元格 I26。","差旅",{"$nulls":6},"其他"]
["在“旅行”表中从右侧单元格开始输入费用，在“其他”表中从单元格 I27 开始输入费用。","项目​​","预算","实际开支","差额",{"$nulls":3},"项目​​","预算","实际开支","差额"]
[null,"机票",null,null,{"$f":"差旅[[#This Row],[预算]]-差旅[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":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"}},{"$nulls":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"}},{"$nulls":3},"其他（在此行的最后一列按 tab，添加行）",null,null,{"$f":"其他[[#This Row],[预算]]-其他[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}}]
[null,"其他（在此行的最后一列按 tab，添加行）",null,null,{"$f":"差旅[[#This Row],[预算]]-差旅[[#This Row],[实际开支]]","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},"汇总",{"$f":"SUBTOTAL(109,其他[预算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,其他[实际开支])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,其他[差额])","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,差旅[预算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,差旅[实际开支])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,差旅[差额])","v":{"v":0,"d":"¥0.00"}}]