{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["婚礼预算表","预算明细"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"婚礼预算表","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"KAYLA 和 JACOB\n喜结连理"]
[]
[]
[null,"类别","估计成本","实际成本","差额","预算百分比",{"$nulls":3},"未排序","估计费用","实际费用","估计成本 - 排名值","排名","#","已排序"]
[null,{"$f":"P6","v":"宴会"},{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"¥14,500"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"¥12,800"}},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":{"v":1700,"d":"¥1,700"}},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"宴会",{"$f":"TBL_宴会[[#Totals],[估算金额]]","v":14500},{"$f":"TBL_宴会[[#Totals],[实际费用]]","v":12800},{"$f":"K6-O6/100","v":14499.99},{"$f":"_xlfn.RANK.AVG(M6,$M$6:$M$15)","v":1},1,{"$f":"INDEX(TBL_RankingData,MATCH(O6,$N$6:$N$15,0),1)","v":"宴会"}]
[null,{"$f":"P7","v":"着装"},{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"¥4,000"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"¥2,900"}},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":{"v":1100,"d":"¥1,100"}},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"着装",{"$f":"TBL_着装[[#Totals],[预估费用]]","v":4000},{"$f":"TBL_着装[[#Totals],[实际费用]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"着装"]
[null,"花卉和装饰",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"¥3,000"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"花卉和装饰",{"$f":"TBL_花卉和装饰[[#Totals],[预估费用]]","v":3000},{"$f":"TBL_花卉和装饰[[#Totals],[实际费用]]","v":0},2999.97,3,3,"花卉和装饰"]
[null,"图片和视频",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"¥2,500"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"音乐",{"$f":"TBL_音乐[[#Totals],[预估费用]]","v":1800},{"$f":"TBL_音乐[[#Totals],[实际费用]]","v":0},1799.96,5,4,"图片和视频"]
[null,"音乐",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"¥1,800"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"图片和视频",{"$f":"TBL_图片和视频[[#Totals],[预估费用]]","v":2500},{"$f":"TBL_图片和视频[[#Totals],[实际费用]]","v":0},2499.95,4,5,"音乐"]
[null,"惠赠和礼品",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"¥1,100"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"惠赠和礼品",{"$f":"TBL_惠赠和礼品[[#Totals],[预估费用]]","v":1100},{"$f":"TBL_惠赠和礼品[[#Totals],[实际费用]]","v":0},1099.94,6,6,"惠赠和礼品"]
[null,{"$f":"P12","v":"结婚戒指"},{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"¥1,100"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"典礼",{"$f":"TBL_典礼[[#Totals],[预估费用]]","v":800},{"$f":"TBL_典礼[[#Totals],[实际费用]]","v":0},799.93,8,7,"结婚戒指"]
[null,"典礼",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"¥800"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"纸品",{"$f":"TBL_纸品[[#Totals],[预估费用]]","v":500},{"$f":"TBL_纸品[[#Totals],[实际费用]]","v":0},499.92,9,8,"典礼"]
[null,"纸品",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"¥500"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"结婚戒指",{"$f":"TBL_结婚戒指[[#Totals],[预估费用]]","v":1100},{"$f":"TBL_结婚戒指[[#Totals],[实际费用]]","v":0},1099.91,7,9,"纸品"]
[null,"交通",{"$f":"VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"¥450"}},{"$f":"IF(VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_摘要[[#This Row],[类别]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_摘要[[#This Row],[估计成本]]=\"\",TBL_摘要[[#This Row],[实际成本]]=\"\"),\"\",TBL_摘要[[#This Row],[估计成本]]-TBL_摘要[[#This Row],[实际成本]])","v":""},{"$f":"TBL_摘要[[#This Row],[估计成本]]/SUM(TBL_摘要[估计成本])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"交通",{"$f":"TBL_交通[[#Totals],[预估费用]]","v":450},{"$f":"TBL_交通[[#Totals],[实际]]","v":0},449.9,10,10,"交通"]
[null,"汇总",{"$f":"SUBTOTAL(109,TBL_摘要[估计成本])","v":{"v":29750,"d":"¥29,750"}},{"$f":"SUBTOTAL(109,TBL_摘要[实际成本])","v":{"v":15700,"d":"¥15,700"}},{"$f":"TBL_摘要[[#Totals],[估计成本]]-TBL_摘要[[#Totals],[实际成本]]","v":{"v":14050,"d":"¥14,050"}},{"$f":"SUBTOTAL(109,TBL_摘要[预算百分比])","v":{"v":1,"d":"100%"}}]

{"sheet":"预算明细","index":1,"n_rows":91,"n_cols":5,"rows_kept":91}
[]
[null,"预算明细"]
[]
[null,"宴会","估算金额","实际费用","差额"]
[null,"场地和租金",{"v":8000,"d":"¥8,000.00"},{"v":7800,"d":"¥7,800.00"},{"$f":"IF(OR(TBL_宴会[[#This Row],[估算金额]]=\"\",TBL_宴会[[#This Row],[实际费用]]=\"\"),\"\",TBL_宴会[[#This Row],[估算金额]]-TBL_宴会[[#This Row],[实际费用]])","v":{"v":200,"d":"¥200.00"}}]
[null,"餐费和服务",{"v":4000,"d":"¥4,000.00"},{"v":4200,"d":"¥4,200.00"},{"$f":"IF(OR(TBL_宴会[[#This Row],[估算金额]]=\"\",TBL_宴会[[#This Row],[实际费用]]=\"\"),\"\",TBL_宴会[[#This Row],[估算金额]]-TBL_宴会[[#This Row],[实际费用]])","v":{"v":-200,"d":"(¥200.00)"}}]
[null,"饮料",{"v":1000,"d":"¥1,000.00"},{"v":800,"d":"¥800.00"},{"$f":"IF(OR(TBL_宴会[[#This Row],[估算金额]]=\"\",TBL_宴会[[#This Row],[实际费用]]=\"\"),\"\",TBL_宴会[[#This Row],[估算金额]]-TBL_宴会[[#This Row],[实际费用]])","v":{"v":200,"d":"¥200.00"}}]
[null,"蛋糕",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_宴会[[#This Row],[估算金额]]=\"\",TBL_宴会[[#This Row],[实际费用]]=\"\"),\"\",TBL_宴会[[#This Row],[估算金额]]-TBL_宴会[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_宴会[[#This Row],[估算金额]]=\"\",TBL_宴会[[#This Row],[实际费用]]=\"\"),\"\",TBL_宴会[[#This Row],[估算金额]]-TBL_宴会[[#This Row],[实际费用]])","v":""}]
[null,"宴会总计",{"$f":"SUBTOTAL(109,TBL_宴会[估算金额])","v":{"v":14500,"d":"¥14,500.00"}},{"$f":"SUBTOTAL(109,TBL_宴会[实际费用])","v":{"v":12800,"d":"¥12,800.00"}},{"$f":"TBL_宴会[[#Totals],[估算金额]]-TBL_宴会[[#Totals],[实际费用]]","v":{"v":1700,"d":"¥1,700.00"}}]
[]
[]
[null,"着装","预估费用","实际费用","差额"]
[null,"礼服、西服和/或连衣裙",{"v":3000,"d":"¥3,000.00"},{"v":2900,"d":"¥2,900.00"},{"$f":"IF(OR(TBL_着装[[#This Row],[预估费用]]=\"\",TBL_着装[[#This Row],[实际费用]]=\"\"),\"\",TBL_着装[[#This Row],[预估费用]]-TBL_着装[[#This Row],[实际费用]])","v":{"v":100,"d":"¥100.00"}}]
[null,"修改",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_着装[[#This Row],[预估费用]]=\"\",TBL_着装[[#This Row],[实际费用]]=\"\"),\"\",TBL_着装[[#This Row],[预估费用]]-TBL_着装[[#This Row],[实际费用]])","v":""}]
[null,"头饰和面纱",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_着装[[#This Row],[预估费用]]=\"\",TBL_着装[[#This Row],[实际费用]]=\"\"),\"\",TBL_着装[[#This Row],[预估费用]]-TBL_着装[[#This Row],[实际费用]])","v":""}]
[null,"配饰",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_着装[[#This Row],[预估费用]]=\"\",TBL_着装[[#This Row],[实际费用]]=\"\"),\"\",TBL_着装[[#This Row],[预估费用]]-TBL_着装[[#This Row],[实际费用]])","v":""}]
[null,"头发和化妆",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_着装[[#This Row],[预估费用]]=\"\",TBL_着装[[#This Row],[实际费用]]=\"\"),\"\",TBL_着装[[#This Row],[预估费用]]-TBL_着装[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_着装[[#This Row],[预估费用]]=\"\",TBL_着装[[#This Row],[实际费用]]=\"\"),\"\",TBL_着装[[#This Row],[预估费用]]-TBL_着装[[#This Row],[实际费用]])","v":""}]
[null,"着装总计",{"$f":"SUBTOTAL(109,TBL_着装[预估费用])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TBL_着装[实际费用])","v":{"v":2900,"d":"¥2,900.00"}},{"$f":"TBL_着装[[#Totals],[预估费用]]-TBL_着装[[#Totals],[实际费用]]","v":{"v":1100,"d":"¥1,100.00"}}]
[]
[]
[null,"花卉和装饰","预估费用","实际费用","差额"]
[null,"典礼的花卉安排",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"花童的花和篮子",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"环形枕头",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"花束",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"翻领纽扣孔胸花",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"襟花",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"宴会装饰",{"v":300,"d":"¥300.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"照明",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_花卉和装饰[[#This Row],[预估费用]]=\"\",TBL_花卉和装饰[[#This Row],[实际费用]]=\"\"),\"\",TBL_花卉和装饰[[#This Row],[预估费用]]-TBL_花卉和装饰[[#This Row],[实际费用]])","v":""}]
[null,"花卉和装饰总计",{"$f":"SUBTOTAL(109,TBL_花卉和装饰[预估费用])","v":{"v":3000,"d":"¥3,000.00"}},{"$f":"SUBTOTAL(109,TBL_花卉和装饰[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_花卉和装饰[[#Totals],[预估费用]]-TBL_花卉和装饰[[#Totals],[实际费用]]","v":{"v":3000,"d":"¥3,000.00"}}]
[]
[]
[null,"音乐","预估费用","实际费用","差额"]
[null,"典礼乐手",{"v":700,"d":"¥700.00"},null,{"$f":"IF(OR(TBL_音乐[[#This Row],[预估费用]]=\"\",TBL_音乐[[#This Row],[实际费用]]=\"\"),\"\",TBL_音乐[[#This Row],[预估费用]]-TBL_音乐[[#This Row],[实际费用]])","v":""}]
[null,"鸡尾酒会乐手",{"v":300,"d":"¥300.00"},null,{"$f":"IF(OR(TBL_音乐[[#This Row],[预估费用]]=\"\",TBL_音乐[[#This Row],[实际费用]]=\"\"),\"\",TBL_音乐[[#This Row],[预估费用]]-TBL_音乐[[#This Row],[实际费用]])","v":""}]
[null,"宴会乐队、主持或娱乐",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_音乐[[#This Row],[预估费用]]=\"\",TBL_音乐[[#This Row],[实际费用]]=\"\"),\"\",TBL_音乐[[#This Row],[预估费用]]-TBL_音乐[[#This Row],[实际费用]])","v":""}]
[null,"音响系统或舞池租赁",{"v":400,"d":"¥400.00"},null,{"$f":"IF(OR(TBL_音乐[[#This Row],[预估费用]]=\"\",TBL_音乐[[#This Row],[实际费用]]=\"\"),\"\",TBL_音乐[[#This Row],[预估费用]]-TBL_音乐[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_音乐[[#This Row],[预估费用]]=\"\",TBL_音乐[[#This Row],[实际费用]]=\"\"),\"\",TBL_音乐[[#This Row],[预估费用]]-TBL_音乐[[#This Row],[实际费用]])","v":""}]
[null,"音乐总计",{"$f":"SUBTOTAL(109,TBL_音乐[预估费用])","v":{"v":1800,"d":"¥1,800.00"}},{"$f":"SUBTOTAL(109,TBL_音乐[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_音乐[[#Totals],[预估费用]]-TBL_音乐[[#Totals],[实际费用]]","v":{"v":1800,"d":"¥1,800.00"}}]
[]
[]
[null,"摄影和视频","预估费用","实际费用","差额"]
[null,"摄影",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_图片和视频[[#This Row],[预估费用]]=\"\",TBL_图片和视频[[#This Row],[实际费用]]=\"\"),\"\",TBL_图片和视频[[#This Row],[预估费用]]-TBL_图片和视频[[#This Row],[实际费用]])","v":""}]
[null,"摄像",{"v":800,"d":"¥800.00"},null,{"$f":"IF(OR(TBL_图片和视频[[#This Row],[预估费用]]=\"\",TBL_图片和视频[[#This Row],[实际费用]]=\"\"),\"\",TBL_图片和视频[[#This Row],[预估费用]]-TBL_图片和视频[[#This Row],[实际费用]])","v":""}]
[null,"其他打印和相册",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_图片和视频[[#This Row],[预估费用]]=\"\",TBL_图片和视频[[#This Row],[实际费用]]=\"\"),\"\",TBL_图片和视频[[#This Row],[预估费用]]-TBL_图片和视频[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_图片和视频[[#This Row],[预估费用]]=\"\",TBL_图片和视频[[#This Row],[实际费用]]=\"\"),\"\",TBL_图片和视频[[#This Row],[预估费用]]-TBL_图片和视频[[#This Row],[实际费用]])","v":""}]
[null,"摄影和视频总计",{"$f":"SUBTOTAL(109,TBL_图片和视频[预估费用])","v":{"v":2500,"d":"¥2,500.00"}},{"$f":"SUBTOTAL(109,TBL_图片和视频[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_图片和视频[[#Totals],[预估费用]]-TBL_图片和视频[[#Totals],[实际费用]]","v":{"v":2500,"d":"¥2,500.00"}}]
[]
[]
[null,"惠赠和礼品","预估费用","实际费用","差额"]
[null,"欢迎礼品",{"v":700,"d":"¥700.00"},null,{"$f":"IF(OR(TBL_惠赠和礼品[[#This Row],[预估费用]]=\"\",TBL_惠赠和礼品[[#This Row],[实际费用]]=\"\"),\"\",TBL_惠赠和礼品[[#This Row],[预估费用]]-TBL_惠赠和礼品[[#This Row],[实际费用]])","v":""}]
[null,"派对礼品",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_惠赠和礼品[[#This Row],[预估费用]]=\"\",TBL_惠赠和礼品[[#This Row],[实际费用]]=\"\"),\"\",TBL_惠赠和礼品[[#This Row],[预估费用]]-TBL_惠赠和礼品[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_惠赠和礼品[[#This Row],[预估费用]]=\"\",TBL_惠赠和礼品[[#This Row],[实际费用]]=\"\"),\"\",TBL_惠赠和礼品[[#This Row],[预估费用]]-TBL_惠赠和礼品[[#This Row],[实际费用]])","v":""}]
[null,"惠赠和礼品总计",{"$f":"SUBTOTAL(109,TBL_惠赠和礼品[预估费用])","v":{"v":1100,"d":"¥1,100.00"}},{"$f":"SUBTOTAL(109,TBL_惠赠和礼品[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_惠赠和礼品[[#Totals],[预估费用]]-TBL_惠赠和礼品[[#Totals],[实际费用]]","v":{"v":1100,"d":"¥1,100.00"}}]
[]
[]
[null,"典礼","预估费用","实际费用","差额"]
[null,"场地费",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_典礼[[#This Row],[预估费用]]=\"\",TBL_典礼[[#This Row],[实际费用]]=\"\"),\"\",TBL_典礼[[#This Row],[预估费用]]-TBL_典礼[[#This Row],[实际费用]])","v":""}]
[null,"司仪费或教会捐献",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_典礼[[#This Row],[预估费用]]=\"\",TBL_典礼[[#This Row],[实际费用]]=\"\"),\"\",TBL_典礼[[#This Row],[预估费用]]-TBL_典礼[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_典礼[[#This Row],[预估费用]]=\"\",TBL_典礼[[#This Row],[实际费用]]=\"\"),\"\",TBL_典礼[[#This Row],[预估费用]]-TBL_典礼[[#This Row],[实际费用]])","v":""}]
[null,"典礼总计",{"$f":"SUBTOTAL(109,TBL_典礼[预估费用])","v":{"v":800,"d":"¥800.00"}},{"$f":"SUBTOTAL(109,TBL_典礼[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_典礼[[#Totals],[预估费用]]-TBL_典礼[[#Totals],[实际费用]]","v":{"v":800,"d":"¥800.00"}}]
[]
[]
[null,"文具","预估费用","实际费用","差额"]
[null,"按时出席卡",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"邀请函和 RSVP",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"节目单",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"席位卡",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"菜单卡",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"感谢便笺",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"邮费",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"杂项费用",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_纸品[[#This Row],[预估费用]]=\"\",TBL_纸品[[#This Row],[实际费用]]=\"\"),\"\",TBL_纸品[[#This Row],[预估费用]]-TBL_纸品[[#This Row],[实际费用]])","v":""}]
[null,"文具总计",{"$f":"SUBTOTAL(109,TBL_纸品[预估费用])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,TBL_纸品[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_纸品[[#Totals],[预估费用]]-TBL_纸品[[#Totals],[实际费用]]","v":{"v":500,"d":"¥500.00"}}]
[]
[]
[null,"结婚戒指","预估费用","实际费用","差额"]
[null,"结婚戒指",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_结婚戒指[[#This Row],[预估费用]]=\"\",TBL_结婚戒指[[#This Row],[实际费用]]=\"\"),\"\",TBL_结婚戒指[[#This Row],[预估费用]]-TBL_结婚戒指[[#This Row],[实际费用]])","v":""}]
[null,"戒指配饰",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_结婚戒指[[#This Row],[预估费用]]=\"\",TBL_结婚戒指[[#This Row],[实际费用]]=\"\"),\"\",TBL_结婚戒指[[#This Row],[预估费用]]-TBL_结婚戒指[[#This Row],[实际费用]])","v":""}]
[null,"结婚戒指总计",{"$f":"SUBTOTAL(109,TBL_结婚戒指[预估费用])","v":{"v":1100,"d":"¥1,100.00"}},{"$f":"SUBTOTAL(109,TBL_结婚戒指[实际费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_结婚戒指[[#Totals],[预估费用]]-TBL_结婚戒指[[#Totals],[实际费用]]","v":{"v":1100,"d":"¥1,100.00"}}]
[]
[]
[null,"交通  ","预估费用","实际","差额"]
[null,"主汽车租赁",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_交通[[#This Row],[预估费用]]=\"\",TBL_交通[[#This Row],[实际]]=\"\"),\"\",TBL_交通[[#This Row],[预估费用]]-TBL_交通[[#This Row],[实际]])","v":""}]
[null,"来宾汽车租赁",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_交通[[#This Row],[预估费用]]=\"\",TBL_交通[[#This Row],[实际]]=\"\"),\"\",TBL_交通[[#This Row],[预估费用]]-TBL_交通[[#This Row],[实际]])","v":""}]
[null,"外地客人的交通费",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_交通[[#This Row],[预估费用]]=\"\",TBL_交通[[#This Row],[实际]]=\"\"),\"\",TBL_交通[[#This Row],[预估费用]]-TBL_交通[[#This Row],[实际]])","v":""}]
[null,"泊车员停车费",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_交通[[#This Row],[预估费用]]=\"\",TBL_交通[[#This Row],[实际]]=\"\"),\"\",TBL_交通[[#This Row],[预估费用]]-TBL_交通[[#This Row],[实际]])","v":""}]
[null,"杂项费用",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_交通[[#This Row],[预估费用]]=\"\",TBL_交通[[#This Row],[实际]]=\"\"),\"\",TBL_交通[[#This Row],[预估费用]]-TBL_交通[[#This Row],[实际]])","v":""}]
[null,"宴会总计",{"$f":"SUBTOTAL(109,TBL_交通[预估费用])","v":{"v":450,"d":"¥450.00"}},{"$f":"SUBTOTAL(109,TBL_交通[实际])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_交通[[#Totals],[预估费用]]-TBL_交通[[#Totals],[实际]]","v":{"v":450,"d":"¥450.00"}}]