{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["开始","婚礼预算","服装-宴会-音乐-图片","装饰-花卉-礼品-旅行"],"not_rendered":{"charts":1,"defined_names":22},"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":19,"n_cols":6,"rows_kept":19,"merged":[[2,2,4,5],[18,2,42,5]]}
["使用该工作表创建婚礼预算。在“服装-宴会-音乐-图片”工作表和“装饰-花卉-礼品-旅行”工作表的表格中输入详细信息，以更新当前工作表中的摘要和图表。有关如何使用此工作表的有用说明位于此列的单元格中。婚礼日期标签位于单元格 C1。",null,"婚礼日期:"]
["在 C2 单元格中输入婚礼日期。剩余天数在单元格 E2 中自动进行计算。",null,{"$f":"TODAY()+365","v":"2019-12-04"},"剩余天数:",{"$f":"C2-TODAY()","v":365}]
["此工作表的标题位于单元格 C3 中。下一条说明位于单元格 A6 中。",null,"婚礼预算摘要"]
[]
[]
["从单元格 C6 开始的预算汇总表将自动更新。下一条说明位于单元格 A19 中。",null,"类别","预估费用","实际费用","超出/不足"]
[null,null,"服装",{"$f":"服装预估总计","v":{"v":9490,"d":"9,490.00"}},{"$f":"服装实际总计","v":{"v":9770,"d":"9,770.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":-280,"d":"-280.00"}}]
[null,null,"宴会",{"$f":"宴会预估总计","v":{"v":1050,"d":"1,050.00"}},{"$f":"宴会实际总计","v":{"v":928,"d":"928.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":122,"d":"122.00"}}]
[null,null,"音乐",{"$f":"音乐娱乐预估总计","v":{"v":600,"d":"600.00"}},{"$f":"音乐娱乐实际总计","v":{"v":400,"d":"400.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":200,"d":"200.00"}}]
[null,null,"印刷",{"$f":"印刷纸品预估总计","v":{"v":935,"d":"935.00"}},{"$f":"印刷纸品实际总计","v":{"v":870,"d":"870.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":65,"d":"65.00"}}]
[null,null,"摄影",{"$f":"摄影预估总计","v":{"v":1625,"d":"1,625.00"}},{"$f":"摄影实际总计","v":{"v":1575,"d":"1,575.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":50,"d":"50.00"}}]
[null,null,"装饰",{"$f":"装饰预估总计","v":{"v":700,"d":"700.00"}},{"$f":"装饰实际总计","v":{"v":720,"d":"720.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":-20,"d":"-20.00"}}]
[null,null,"花卉",{"$f":"花卉预估总计","v":{"v":900,"d":"900.00"}},{"$f":"花卉实际总计","v":{"v":850,"d":"850.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":50,"d":"50.00"}}]
[null,null,"礼品",{"$f":"礼品预估总计","v":{"v":1345,"d":"1,345.00"}},{"$f":"礼品实际总计","v":{"v":1075,"d":"1,075.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":270,"d":"270.00"}}]
[null,null,"旅行",{"$f":"旅行交通预估总计","v":{"v":100,"d":"100.00"}},{"$f":"旅行交通实际总计","v":{"v":165,"d":"165.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":-65,"d":"-65.00"}}]
[null,null,"其他",{"$f":"其他费用预估总计","v":{"v":885,"d":"885.00"}},{"$f":"其他费用实际总计","v":{"v":1021,"d":"1,021.00"}},{"$f":"预算汇总[[#This Row],[预估费用]]-预算汇总[[#This Row],[实际费用]]","v":{"v":-136,"d":"-136.00"}}]
[null,null,"总支出",{"$f":"SUBTOTAL(109,预算汇总[预估费用])","v":{"v":17630,"d":"17,630.00"}},{"$f":"SUBTOTAL(109,预算汇总[实际费用])","v":{"v":17374,"d":"17,374.00"}},{"$f":"SUBTOTAL(109,预算汇总[超出/不足])","v":{"v":256,"d":"256.00"}}]
[]
["单元格 C19 中的饼图将自动更新。",null,"显示各类别费用百分比的饼图位于此单元格中。"]

{"sheet":"服装-宴会-音乐-图片","index":2,"n_rows":56,"n_cols":6,"rows_kept":56,"merged":[[16,1,16,4],[28,1,28,4],[29,1,29,4],[35,1,35,4],[48,1,48,4]]}
["在此工作表的相应表中输入每个类别的预估费用和实际费用。超出或不足将自动计算。服装标签位于右侧单元格中。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头开始了解。","服装",{"$nulls":3}," "]
[" 从右侧单元格开始，在“服装”表格中输入详细信息。下一条说明位于单元格 A18 中。","类别","预估费用","实际费用","超出/不足"," "]
[null,"订婚戒指",{"v":1500,"d":"1,500.00"},{"v":1500,"d":"1,500.00"},{"$f":"'服装-宴会-音乐-图片'!$C3-'服装-宴会-音乐-图片'!$D3","v":{"v":0,"d":"0.00"}}]
[null,"准配偶 1 婚戒",{"v":2000,"d":"2,000.00"},{"v":2300,"d":"2,300.00"},{"$f":"'服装-宴会-音乐-图片'!$C4-'服装-宴会-音乐-图片'!$D4","v":{"v":-300,"d":"(300.00)"}}]
[null,"准配偶 1 礼服/无尾晚礼服",{"v":3000,"d":"3,000.00"},{"v":2750,"d":"2,750.00"},{"$f":"'服装-宴会-音乐-图片'!$C5-'服装-宴会-音乐-图片'!$D5","v":{"v":250,"d":"250.00"}}]
[null,"准配偶 1 面纱/头巾",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"'服装-宴会-音乐-图片'!$C6-'服装-宴会-音乐-图片'!$D6","v":{"v":0,"d":"0.00"}}]
[null,"准配偶 1 鞋",{"v":350,"d":"350.00"},{"v":300,"d":"300.00"},{"$f":"'服装-宴会-音乐-图片'!$C7-'服装-宴会-音乐-图片'!$D7","v":{"v":50,"d":"50.00"}}]
[null,"准配偶 1 首饰",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"'服装-宴会-音乐-图片'!$C8-'服装-宴会-音乐-图片'!$D8","v":{"v":-150,"d":"(150.00)"}}]
[null,"准配偶 1 袜子",{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"$f":"'服装-宴会-音乐-图片'!$C9-'服装-宴会-音乐-图片'!$D9","v":{"v":0,"d":"0.00"}}]
[null,"准配偶 2 婚戒",{"v":300,"d":"300.00"},{"v":250,"d":"250.00"},{"$f":"'服装-宴会-音乐-图片'!$C10-'服装-宴会-音乐-图片'!$D10","v":{"v":50,"d":"50.00"}}]
[null,"准配偶 2 礼服/无尾晚礼服",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"$f":"'服装-宴会-音乐-图片'!$C11-'服装-宴会-音乐-图片'!$D11","v":{"v":-50,"d":"(50.00)"}}]
[null,"准配偶 2 面纱/头巾",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"'服装-宴会-音乐-图片'!$C12-'服装-宴会-音乐-图片'!$D12","v":{"v":0,"d":"0.00"}}]
[null,"准配偶 2 鞋",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"'服装-宴会-音乐-图片'!$C13-'服装-宴会-音乐-图片'!$D13","v":{"v":25,"d":"25.00"}}]
[null,"准配偶 2 首饰",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"'服装-宴会-音乐-图片'!$C14-'服装-宴会-音乐-图片'!$D14","v":{"v":-150,"d":"(150.00)"}}]
[null,"准配偶 2 袜子",{"v":20,"d":"20.00"},{"v":25,"d":"25.00"},{"$f":"'服装-宴会-音乐-图片'!$C15-'服装-宴会-音乐-图片'!$D15","v":{"v":-5,"d":"(5.00)"}}]
[null,"服装总计",{"$f":"SUBTOTAL(109,服装[预估费用])","v":{"v":9490,"d":"9,490.00"}},{"$f":"SUBTOTAL(109,服装[实际费用])","v":{"v":9770,"d":"9,770.00"}},{"$f":"SUBTOTAL(109,服装[超出/不足])","v":{"v":-280,"d":"(280.00)"}}]
[]
["宴会标签位于右侧单元格中。","宴会*"]
["从右侧单元格开始，在表格中输入宴会费用（不含娱乐和装饰费用）。下一条说明位于单元格 A31 中。","类别","预估费用","实际费用","超出/不足"]
[null,"房间/大厅费用",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"'服装-宴会-音乐-图片'!$C20-'服装-宴会-音乐-图片'!$D20","v":{"v":50,"d":"50.00"}}]
[null,"桌椅",{"v":100,"d":"100.00"},{"v":50,"d":"50.00"},{"$f":"'服装-宴会-音乐-图片'!$C21-'服装-宴会-音乐-图片'!$D21","v":{"v":50,"d":"50.00"}}]
[null,"食物",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C22-'服装-宴会-音乐-图片'!$D22","v":{"v":0,"d":"0.00"}}]
[null,"饮料",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C23-'服装-宴会-音乐-图片'!$D23","v":{"v":0,"d":"0.00"}}]
[null,"亚麻布",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C24-'服装-宴会-音乐-图片'!$D24","v":{"v":0,"d":"0.00"}}]
[null,"蛋糕",{"v":700,"d":"700.00"},{"v":700,"d":"700.00"},{"$f":"'服装-宴会-音乐-图片'!$C25-'服装-宴会-音乐-图片'!$D25","v":{"v":0,"d":"0.00"}}]
[null,"惠赠",{"v":50,"d":"50.00"},{"v":28,"d":"28.00"},{"$f":"'服装-宴会-音乐-图片'!$C26-'服装-宴会-音乐-图片'!$D26","v":{"v":22,"d":"22.00"}}]
[null,"服务人员和小费",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C27-'服装-宴会-音乐-图片'!$D27","v":{"v":0,"d":"0.00"}}]
[null,"宴会总计",{"$f":"SUBTOTAL(109,宴会[预估费用])","v":{"v":1050,"d":"1,050.00"}},{"$f":"SUBTOTAL(109,宴会[实际费用])","v":{"v":928,"d":"928.00"}},{"$f":"SUBTOTAL(109,宴会[超出/不足])","v":{"v":122,"d":"122.00"}}]
[null,"*不包括娱乐和装饰"]
[]
["音乐或娱乐标签位于右侧单元格中。","音乐/娱乐"]
["从右侧单元格开始，在“音乐”表格中输入详细信息。下一条说明位于单元格 A37 中。","类别","预估费用","实际费用","超出/不足"]
[null,"宴会歌手",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"'服装-宴会-音乐-图片'!$C33-'服装-宴会-音乐-图片'!$D33","v":{"v":0,"d":"0.00"}}]
[null,"宴会乐队/DJ",{"v":200,"d":"200.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C34-'服装-宴会-音乐-图片'!$D34","v":{"v":200,"d":"200.00"}}]
[null,"音乐/娱乐总计",{"$f":"SUBTOTAL(109,音乐[预估费用])","v":{"v":600,"d":"600.00"}},{"$f":"SUBTOTAL(109,音乐[实际费用])","v":{"v":400,"d":"400.00"}},{"$f":"SUBTOTAL(109,音乐[超出/不足])","v":{"v":200,"d":"200.00"}}]
[]
["印刷或纸品标签位于右侧单元格中。","印刷/纸品"]
["从右侧单元格开始，在“印刷”表格中输入详细信息。下一条说明位于单元格 A50 中。","类别","预估费用","实际费用","超出/不足"]
[null,"喜帖",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"'服装-宴会-音乐-图片'!$C39-'服装-宴会-音乐-图片'!$D39","v":{"v":50,"d":"50.00"}}]
[null,"公告",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"'服装-宴会-音乐-图片'!$C40-'服装-宴会-音乐-图片'!$D40","v":{"v":25,"d":"25.00"}}]
[null,"感谢卡片",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"'服装-宴会-音乐-图片'!$C41-'服装-宴会-音乐-图片'!$D41","v":{"v":0,"d":"0.00"}}]
[null,"个人便条",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C42-'服装-宴会-音乐-图片'!$D42","v":{"v":0,"d":"0.00"}}]
[null,"来宾簿",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"'服装-宴会-音乐-图片'!$C43-'服装-宴会-音乐-图片'!$D43","v":{"v":0,"d":"0.00"}}]
[null,"节目单",{"v":75,"d":"75.00"},{"v":80,"d":"80.00"},{"$f":"'服装-宴会-音乐-图片'!$C44-'服装-宴会-音乐-图片'!$D44","v":{"v":-5,"d":"(5.00)"}}]
[null,"宴会纸巾",{"v":35,"d":"35.00"},{"v":40,"d":"40.00"},{"$f":"'服装-宴会-音乐-图片'!$C45-'服装-宴会-音乐-图片'!$D45","v":{"v":-5,"d":"(5.00)"}}]
[null,"喜糖盒",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C46-'服装-宴会-音乐-图片'!$D46","v":{"v":0,"d":"0.00"}}]
[null,"艺术书法",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'服装-宴会-音乐-图片'!$C47-'服装-宴会-音乐-图片'!$D47","v":{"v":0,"d":"0.00"}}]
[null,"印刷/纸品总计",{"$f":"SUBTOTAL(109,印刷[预估费用])","v":{"v":935,"d":"935.00"}},{"$f":"SUBTOTAL(109,印刷[实际费用])","v":{"v":870,"d":"870.00"}},{"$f":"SUBTOTAL(109,印刷[超出/不足])","v":{"v":65,"d":"65.00"}}]
[]
["摄影标签位于右侧单元格中。","摄影"]
["从右侧单元格开始，在“摄影”表格中输入详细信息。","类别","预估费用","实际费用","超出/不足"]
[null,"正式拍摄",{"v":1300,"d":"1,300.00"},{"v":1300,"d":"1,300.00"},{"$f":"'服装-宴会-音乐-图片'!$C52-'服装-宴会-音乐-图片'!$D52","v":{"v":0,"d":"0.00"}}]
[null,"加洗",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"'服装-宴会-音乐-图片'!$C53-'服装-宴会-音乐-图片'!$D53","v":{"v":0,"d":"0.00"}}]
[null,"相册",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"'服装-宴会-音乐-图片'!$C54-'服装-宴会-音乐-图片'!$D54","v":{"v":0,"d":"0.00"}}]
[null,"摄像",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"'服装-宴会-音乐-图片'!$C55-'服装-宴会-音乐-图片'!$D55","v":{"v":50,"d":"50.00"}}]
[null,"摄影总计",{"$f":"SUBTOTAL(109,摄影[预估费用])","v":{"v":1625,"d":"1,625.00"}},{"$f":"SUBTOTAL(109,摄影[实际费用])","v":{"v":1575,"d":"1,575.00"}},{"$f":"SUBTOTAL(109,摄影[超出/不足])","v":{"v":50,"d":"50.00"}}]

{"sheet":"装饰-花卉-礼品-旅行","index":3,"n_rows":48,"n_cols":5,"rows_kept":48,"merged":[[8,1,8,4],[9,1,9,4],[18,1,18,4],[27,1,27,4],[34,1,34,4]]}
["在此工作表的相应表中输入每个类别的预估费用和实际费用。超出或不足将自动计算。装饰标签位于右侧单元格中。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头开始了解。","装饰*"]
["从右侧单元格开始，在表格中输入装饰费用（不含花卉费用）。下一条说明位于单元格 A11 中。","类别","预估费用","实际费用","超出/不足"]
[null,"座位上的蝴蝶结",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C3-'装饰-花卉-礼品-旅行'!$D3","v":{"v":0,"d":"0.00"}}]
[null,"餐桌摆饰",{"v":300,"d":"300.00"},{"v":320,"d":"320.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C4-'装饰-花卉-礼品-旅行'!$D4","v":{"v":-20,"d":"(20.00)"}}]
[null,"蜡烛",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C5-'装饰-花卉-礼品-旅行'!$D5","v":{"v":25,"d":"25.00"}}]
[null,"照明",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C6-'装饰-花卉-礼品-旅行'!$D6","v":{"v":25,"d":"25.00"}}]
[null,"气球",{"v":200,"d":"200.00"},{"v":250,"d":"250.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C7-'装饰-花卉-礼品-旅行'!$D7","v":{"v":-50,"d":"(50.00)"}}]
[null,"装饰总计",{"$f":"SUBTOTAL(109,装饰[预估费用])","v":{"v":700,"d":"700.00"}},{"$f":"SUBTOTAL(109,装饰[实际费用])","v":{"v":720,"d":"720.00"}},{"$f":"SUBTOTAL(109,装饰[超出/不足])","v":{"v":-20,"d":"(20.00)"}}]
[null,"*不包括花卉"]
[]
["花卉标签位于右侧单元格中。","花卉"]
["从右侧单元格开始，在“花卉”表格中输入详细信息。下一条说明位于单元格 A20 中。","类别","预估费用","实际费用","超出/不足"]
[null,"花束",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C13-'装饰-花卉-礼品-旅行'!$D13","v":{"v":50,"d":"50.00"}}]
[null,"钮孔花",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C14-'装饰-花卉-礼品-旅行'!$D14","v":{"v":0,"d":"0.00"}}]
[null,"襟花",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C15-'装饰-花卉-礼品-旅行'!$D15","v":{"v":0,"d":"0.00"}}]
[null,"典礼",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C16-'装饰-花卉-礼品-旅行'!$D16","v":{"v":0,"d":"0.00"}}]
[null,"宴会",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C17-'装饰-花卉-礼品-旅行'!$D17","v":{"v":0,"d":"0.00"}}]
[null,"花卉总计",{"$f":"SUBTOTAL(109,花卉[预估费用])","v":{"v":900,"d":"900.00"}},{"$f":"SUBTOTAL(109,花卉[实际费用])","v":{"v":850,"d":"850.00"}},{"$f":"SUBTOTAL(109,花卉[超出/不足])","v":{"v":50,"d":"50.00"}}]
[]
["礼品标签位于右侧单元格中。","礼品"]
["从右侧单元格开始，在“礼品”表格中输入详细信息。下一条说明位于单元格 A29 中。","类别","预估费用","实际费用","超出/不足"]
[null,"出席人数",{"v":1000,"d":"1,000.00"},{"v":400,"d":"400.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C22-'装饰-花卉-礼品-旅行'!$D22","v":{"v":600,"d":"600.00"}}]
[null,"准配偶 1",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C23-'装饰-花卉-礼品-旅行'!$D23","v":{"v":-50,"d":"(50.00)"}}]
[null,"准配偶 2",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C24-'装饰-花卉-礼品-旅行'!$D24","v":{"v":-50,"d":"(50.00)"}}]
[null,"父母",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C25-'装饰-花卉-礼品-旅行'!$D25","v":{"v":0,"d":"0.00"}}]
[null,"牧师/其他参加者",{"v":20,"d":"20.00"},{"v":250,"d":"250.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C26-'装饰-花卉-礼品-旅行'!$D26","v":{"v":-230,"d":"(230.00)"}}]
[null,"礼品总计",{"$f":"SUBTOTAL(109,礼品[预估费用])","v":{"v":1345,"d":"1,345.00"}},{"$f":"SUBTOTAL(109,礼品[实际费用])","v":{"v":1075,"d":"1,075.00"}},{"$f":"SUBTOTAL(109,礼品[超出/不足])","v":{"v":270,"d":"270.00"}}]
[]
["旅行或交通标签位于右侧单元格中。","旅行/交通"]
["从右侧单元格开始，在“旅行”表格中输入详细信息。下一条说明位于单元格 A36 中。","类别","预估费用","实际费用","超出/不足"]
[null,"豪华轿车/有轨电车",{"v":100,"d":"100.00"},{"v":125,"d":"125.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C31-'装饰-花卉-礼品-旅行'!$D31","v":{"v":-25,"d":"(25.00)"}}]
[null,"停车",{"v":0,"d":"0.00"},{"v":40,"d":"40.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C32-'装饰-花卉-礼品-旅行'!$D32","v":{"v":-40,"d":"(40.00)"}}]
[null,"出租车",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C33-'装饰-花卉-礼品-旅行'!$D33","v":{"v":0,"d":"0.00"}}]
[null,"旅行/交通总计",{"$f":"SUBTOTAL(109,旅行[预估费用])","v":{"v":100,"d":"100.00"}},{"$f":"SUBTOTAL(109,旅行[实际费用])","v":{"v":165,"d":"165.00"}},{"$f":"SUBTOTAL(109,旅行[超出/不足])","v":{"v":-65,"d":"(65.00)"}}]
[]
["“其他费用”标签位于右侧单元格中。","其他费用"]
["从右侧单元格开始，在“其他费用”表格中输入详细信息。","类别","预估费用","实际费用","超出/不足"]
[null,"司仪",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C38-'装饰-花卉-礼品-旅行'!$D38","v":{"v":0,"d":"0.00"}}]
[null,"教堂/婚礼场所费用",{"v":40,"d":"40.00"},{"v":55,"d":"55.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C39-'装饰-花卉-礼品-旅行'!$D39","v":{"v":-15,"d":"(15.00)"}}]
[null,"婚礼协调员",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C40-'装饰-花卉-礼品-旅行'!$D40","v":{"v":0,"d":"0.00"}}]
[null,"预演晚宴",{"v":450,"d":"450.00"},{"v":450,"d":"450.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C41-'装饰-花卉-礼品-旅行'!$D41","v":{"v":0,"d":"0.00"}}]
[null,"订婚聚会",{"v":20,"d":"20.00"},{"v":50,"d":"50.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C42-'装饰-花卉-礼品-旅行'!$D42","v":{"v":-30,"d":"(30.00)"}}]
[null,"婚前单身派对",{"v":30,"d":"30.00"},{"v":20,"d":"20.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C43-'装饰-花卉-礼品-旅行'!$D43","v":{"v":10,"d":"10.00"}}]
[null,"沙龙约会",{"v":45,"d":"45.00"},{"v":46,"d":"46.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C44-'装饰-花卉-礼品-旅行'!$D44","v":{"v":-1,"d":"(1.00)"}}]
[null,"单身聚会",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C45-'装饰-花卉-礼品-旅行'!$D45","v":{"v":0,"d":"0.00"}}]
[null,"便餐",{"v":300,"d":"300.00"},{"v":400,"d":"400.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C46-'装饰-花卉-礼品-旅行'!$D46","v":{"v":-100,"d":"(100.00)"}}]
[null,"酒店房间",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'装饰-花卉-礼品-旅行'!$C47-'装饰-花卉-礼品-旅行'!$D47","v":{"v":0,"d":"0.00"}}]
[null,"其他费用总计",{"$f":"SUBTOTAL(109,其他费用[预估费用])","v":{"v":885,"d":"885.00"}},{"$f":"SUBTOTAL(109,其他费用[实际费用])","v":{"v":1021,"d":"1,021.00"}},{"$f":"SUBTOTAL(109,其他费用[超出/不足])","v":{"v":-136,"d":"(136.00)"}}]