{"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]]}
[{"$nulls":6}," "]
[null,"雅婷 + 家豪\n結婚"]
[{"$nulls":7}," "]
[]
[null,"類別","預估花費","實際花費","差異","預算 %",{"$nulls":3},"未排序","預估費用","實際費用","預估費用 - 排名值","排名","#","已排序"]
[null,{"$f":"P6","v":"接待處"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"NT$14,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"NT$12,800"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":{"v":1700,"d":"NT$1,700"}},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"接待處",{"$f":"TBL_Reception[[#Totals],[預估]]","v":14500},{"$f":"TBL_Reception[[#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_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"NT$4,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"NT$2,900"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":{"v":1100,"d":"NT$1,100"}},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"服裝",{"$f":"TBL_Attire[[#Totals],[預估]]","v":4000},{"$f":"TBL_Attire[[#Totals],[實際]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"服裝"]
[null,"花與佈置裝飾",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"NT$3,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"花與佈置裝飾",{"$f":"TBL_FlowersAndDecor[[#Totals],[預估]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[實際]]","v":0},2999.97,3,3,"花與佈置裝飾"]
[null,"相片和影片",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"NT$2,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"音樂",{"$f":"TBL_Music[[#Totals],[預估]]","v":1800},{"$f":"TBL_Music[[#Totals],[實際]]","v":0},1799.96,5,4,"相片和影片"]
[null,"音樂",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"NT$1,800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"相片和影片",{"$f":"TBL_PhotographsAndVideo[[#Totals],[預估]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[實際]]","v":0},2499.95,4,5,"音樂"]
[null,"回禮和禮物",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"NT$1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"回禮和禮物",{"$f":"TBL_FavorsAndGifts[[#Totals],[預估]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[實際]]","v":0},1099.94,6,6,"回禮和禮物"]
[null,{"$f":"P12","v":"結婚戒指"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"NT$1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"典禮",{"$f":"TBL_Ceremony[[#Totals],[預估]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[實際]]","v":0},799.93,8,7,"結婚戒指"]
[null,"典禮",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"NT$800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"信箋",{"$f":"TBL_Stationery[[#Totals],[預估]]","v":500},{"$f":"TBL_Stationery[[#Totals],[實際]]","v":0},499.92,9,8,"典禮"]
[null,"信箋",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"NT$500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"結婚戒指",{"$f":"TBL_WeddingRings[[#Totals],[預估]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[實際]]","v":0},1099.91,7,9,"信箋"]
[null,"交通",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"NT$450"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[類別]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[預估花費]]=\"\",TBL_Summary[[#This Row],[實際花費]]=\"\"),\"\",TBL_Summary[[#This Row],[預估花費]]-TBL_Summary[[#This Row],[實際花費]])","v":""},{"$f":"TBL_Summary[[#This Row],[預估花費]]/SUM(TBL_Summary[預估花費])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"交通",{"$f":"TBL_Transportation[[#Totals],[預估]]","v":450},{"$f":"TBL_Transportation[[#Totals],[實際]]","v":0},449.9,10,10,"交通"]
[null,"合計",{"$f":"SUBTOTAL(109,TBL_Summary[預估花費])","v":{"v":29750,"d":"NT$29,750"}},{"$f":"SUBTOTAL(109,TBL_Summary[實際花費])","v":{"v":15700,"d":"NT$15,700"}},{"$f":"TBL_Summary[[#Totals],[預估花費]]-TBL_Summary[[#Totals],[實際花費]]","v":{"v":14050,"d":"NT$14,050"}},{"$f":"SUBTOTAL(109,TBL_Summary[預算 %])","v":{"v":1,"d":"100%"}}]

{"sheet":"預算詳細資料","index":1,"n_rows":91,"n_cols":6,"rows_kept":91}
[{"$nulls":5}," "]
[null,"預算詳細資料"]
[]
[null,"接待處","預估","實際","差異"]
[null,"場地和租金",{"v":8000,"d":"NT$8,000.00"},{"v":7800,"d":"NT$7,800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[預估]]=\"\",TBL_Reception[[#This Row],[實際]]=\"\"),\"\",TBL_Reception[[#This Row],[預估]]-TBL_Reception[[#This Row],[實際]])","v":{"v":200,"d":"NT$200.00"}}]
[null,"餐點和服務",{"v":4000,"d":"NT$4,000.00"},{"v":4200,"d":"NT$4,200.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[預估]]=\"\",TBL_Reception[[#This Row],[實際]]=\"\"),\"\",TBL_Reception[[#This Row],[預估]]-TBL_Reception[[#This Row],[實際]])","v":{"v":-200,"d":"(NT$200.00)"}}]
[null,"飲料",{"v":1000,"d":"NT$1,000.00"},{"v":800,"d":"NT$800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[預估]]=\"\",TBL_Reception[[#This Row],[實際]]=\"\"),\"\",TBL_Reception[[#This Row],[預估]]-TBL_Reception[[#This Row],[實際]])","v":{"v":200,"d":"NT$200.00"}}]
[null,"蛋糕",{"v":1000,"d":"NT$1,000.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[預估]]=\"\",TBL_Reception[[#This Row],[實際]]=\"\"),\"\",TBL_Reception[[#This Row],[預估]]-TBL_Reception[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":500,"d":"NT$500.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[預估]]=\"\",TBL_Reception[[#This Row],[實際]]=\"\"),\"\",TBL_Reception[[#This Row],[預估]]-TBL_Reception[[#This Row],[實際]])","v":""}]
[null,"婚宴總計",{"$f":"SUBTOTAL(109,TBL_Reception[預估])","v":{"v":14500,"d":"NT$14,500.00"}},{"$f":"SUBTOTAL(109,TBL_Reception[實際])","v":{"v":12800,"d":"NT$12,800.00"}},{"$f":"TBL_Reception[[#Totals],[預估]]-TBL_Reception[[#Totals],[實際]]","v":{"v":1700,"d":"NT$1,700.00"}}]
[]
[]
[null,"服裝","預估","實際","差異"]
[null,"西裝和/或禮服",{"v":3000,"d":"NT$3,000.00"},{"v":2900,"d":"NT$2,900.00"},{"$f":"IF(OR(TBL_Attire[[#This Row],[預估]]=\"\",TBL_Attire[[#This Row],[實際]]=\"\"),\"\",TBL_Attire[[#This Row],[預估]]-TBL_Attire[[#This Row],[實際]])","v":{"v":100,"d":"NT$100.00"}}]
[null,"更換",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[預估]]=\"\",TBL_Attire[[#This Row],[實際]]=\"\"),\"\",TBL_Attire[[#This Row],[預估]]-TBL_Attire[[#This Row],[實際]])","v":""}]
[null,"頭飾和頭紗",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[預估]]=\"\",TBL_Attire[[#This Row],[實際]]=\"\"),\"\",TBL_Attire[[#This Row],[預估]]-TBL_Attire[[#This Row],[實際]])","v":""}]
[null,"首飾",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[預估]]=\"\",TBL_Attire[[#This Row],[實際]]=\"\"),\"\",TBL_Attire[[#This Row],[預估]]-TBL_Attire[[#This Row],[實際]])","v":""}]
[null,"妝髮",{"v":500,"d":"NT$500.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[預估]]=\"\",TBL_Attire[[#This Row],[實際]]=\"\"),\"\",TBL_Attire[[#This Row],[預估]]-TBL_Attire[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[預估]]=\"\",TBL_Attire[[#This Row],[實際]]=\"\"),\"\",TBL_Attire[[#This Row],[預估]]-TBL_Attire[[#This Row],[實際]])","v":""}]
[null,"服裝總計",{"$f":"SUBTOTAL(109,TBL_Attire[預估])","v":{"v":4000,"d":"NT$4,000.00"}},{"$f":"SUBTOTAL(109,TBL_Attire[實際])","v":{"v":2900,"d":"NT$2,900.00"}},{"$f":"TBL_Attire[[#Totals],[預估]]-TBL_Attire[[#Totals],[實際]]","v":{"v":1100,"d":"NT$1,100.00"}}]
[]
[]
[null,"花卉與佈置","預估","實際","差異"]
[null,"婚禮花卉佈置",{"v":1000,"d":"NT$1,000.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"花童的花環和花籃",{"v":500,"d":"NT$500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"戒枕",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"花束",{"v":500,"d":"NT$500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"襟花",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"胸花",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"接待處佈置裝飾",{"v":300,"d":"NT$300.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"燈光",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[預估]]=\"\",TBL_FlowersAndDecor[[#This Row],[實際]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[預估]]-TBL_FlowersAndDecor[[#This Row],[實際]])","v":""}]
[null,"花卉與佈置總計",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[預估])","v":{"v":3000,"d":"NT$3,000.00"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[預估]]-TBL_FlowersAndDecor[[#Totals],[實際]]","v":{"v":3000,"d":"NT$3,000.00"}}]
[]
[]
[null,"音樂","預估","實際","差異"]
[null,"典禮樂手",{"v":700,"d":"NT$700.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[預估]]=\"\",TBL_Music[[#This Row],[實際]]=\"\"),\"\",TBL_Music[[#This Row],[預估]]-TBL_Music[[#This Row],[實際]])","v":""}]
[null,"雞尾酒時間樂手",{"v":300,"d":"NT$300.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[預估]]=\"\",TBL_Music[[#This Row],[實際]]=\"\"),\"\",TBL_Music[[#This Row],[預估]]-TBL_Music[[#This Row],[實際]])","v":""}]
[null,"接待處樂團、DJ 或娛樂",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[預估]]=\"\",TBL_Music[[#This Row],[實際]]=\"\"),\"\",TBL_Music[[#This Row],[預估]]-TBL_Music[[#This Row],[實際]])","v":""}]
[null,"音響系統或舞池租借",{"v":400,"d":"NT$400.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[預估]]=\"\",TBL_Music[[#This Row],[實際]]=\"\"),\"\",TBL_Music[[#This Row],[預估]]-TBL_Music[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[預估]]=\"\",TBL_Music[[#This Row],[實際]]=\"\"),\"\",TBL_Music[[#This Row],[預估]]-TBL_Music[[#This Row],[實際]])","v":""}]
[null,"音樂總計",{"$f":"SUBTOTAL(109,TBL_Music[預估])","v":{"v":1800,"d":"NT$1,800.00"}},{"$f":"SUBTOTAL(109,TBL_Music[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_Music[[#Totals],[預估]]-TBL_Music[[#Totals],[實際]]","v":{"v":1800,"d":"NT$1,800.00"}}]
[]
[]
[null,"攝影與錄影","預估","實際","差異"]
[null,"攝影",{"v":1000,"d":"NT$1,000.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[預估]]=\"\",TBL_PhotographsAndVideo[[#This Row],[實際]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[預估]]-TBL_PhotographsAndVideo[[#This Row],[實際]])","v":""}]
[null,"錄影",{"v":800,"d":"NT$800.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[預估]]=\"\",TBL_PhotographsAndVideo[[#This Row],[實際]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[預估]]-TBL_PhotographsAndVideo[[#This Row],[實際]])","v":""}]
[null,"其他印刷品和相簿",{"v":500,"d":"NT$500.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[預估]]=\"\",TBL_PhotographsAndVideo[[#This Row],[實際]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[預估]]-TBL_PhotographsAndVideo[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[預估]]=\"\",TBL_PhotographsAndVideo[[#This Row],[實際]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[預估]]-TBL_PhotographsAndVideo[[#This Row],[實際]])","v":""}]
[null,"攝影與錄影總計",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[預估])","v":{"v":2500,"d":"NT$2,500.00"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[預估]]-TBL_PhotographsAndVideo[[#Totals],[實際]]","v":{"v":2500,"d":"NT$2,500.00"}}]
[]
[]
[null,"回禮與贈禮","預估","實際","差異"]
[null,"歡迎禮",{"v":700,"d":"NT$700.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[預估]]=\"\",TBL_FavorsAndGifts[[#This Row],[實際]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[預估]]-TBL_FavorsAndGifts[[#This Row],[實際]])","v":""}]
[null,"派對禮",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[預估]]=\"\",TBL_FavorsAndGifts[[#This Row],[實際]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[預估]]-TBL_FavorsAndGifts[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[預估]]=\"\",TBL_FavorsAndGifts[[#This Row],[實際]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[預估]]-TBL_FavorsAndGifts[[#This Row],[實際]])","v":""}]
[null,"回禮與贈禮總計",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[預估])","v":{"v":1100,"d":"NT$1,100.00"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[預估]]-TBL_FavorsAndGifts[[#Totals],[實際]]","v":{"v":1100,"d":"NT$1,100.00"}}]
[]
[]
[null,"典禮","預估","實際","差異"]
[null,"場地費用",{"v":500,"d":"NT$500.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[預估]]=\"\",TBL_Ceremony[[#This Row],[實際]]=\"\"),\"\",TBL_Ceremony[[#This Row],[預估]]-TBL_Ceremony[[#This Row],[實際]])","v":""}]
[null,"主婚人費用或教堂捐贈",{"v":200,"d":"NT$200.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[預估]]=\"\",TBL_Ceremony[[#This Row],[實際]]=\"\"),\"\",TBL_Ceremony[[#This Row],[預估]]-TBL_Ceremony[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[預估]]=\"\",TBL_Ceremony[[#This Row],[實際]]=\"\"),\"\",TBL_Ceremony[[#This Row],[預估]]-TBL_Ceremony[[#This Row],[實際]])","v":""}]
[null,"典禮總計",{"$f":"SUBTOTAL(109,TBL_Ceremony[預估])","v":{"v":800,"d":"NT$800.00"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_Ceremony[[#Totals],[預估]]-TBL_Ceremony[[#Totals],[實際]]","v":{"v":800,"d":"NT$800.00"}}]
[]
[]
[null,"文具信箋","預估","實際","差異"]
[null,"喜帖",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"邀請和與會者",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"流程手冊",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"座位表和座位卡",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"菜單",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"謝卡",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"郵資",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[預估]]=\"\",TBL_Stationery[[#This Row],[實際]]=\"\"),\"\",TBL_Stationery[[#This Row],[預估]]-TBL_Stationery[[#This Row],[實際]])","v":""}]
[null,"文具信箋總計",{"$f":"SUBTOTAL(109,TBL_Stationery[預估])","v":{"v":500,"d":"NT$500.00"}},{"$f":"SUBTOTAL(109,TBL_Stationery[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_Stationery[[#Totals],[預估]]-TBL_Stationery[[#Totals],[實際]]","v":{"v":500,"d":"NT$500.00"}}]
[]
[]
[null,"結婚戒指","預估","實際","差異"]
[null,"結婚戒指",{"v":1000,"d":"NT$1,000.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[預估]]=\"\",TBL_WeddingRings[[#This Row],[實際]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[預估]]-TBL_WeddingRings[[#This Row],[實際]])","v":""}]
[null,"戒指配飾",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[預估]]=\"\",TBL_WeddingRings[[#This Row],[實際]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[預估]]-TBL_WeddingRings[[#This Row],[實際]])","v":""}]
[null,"結婚戒指總計",{"$f":"SUBTOTAL(109,TBL_WeddingRings[預估])","v":{"v":1100,"d":"NT$1,100.00"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_WeddingRings[[#Totals],[預估]]-TBL_WeddingRings[[#Totals],[實際]]","v":{"v":1100,"d":"NT$1,100.00"}}]
[]
[]
[null,"交通  ","預估","實際","差異"]
[null,"主車租借",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[預估]]=\"\",TBL_Transportation[[#This Row],[實際]]=\"\"),\"\",TBL_Transportation[[#This Row],[預估]]-TBL_Transportation[[#This Row],[實際]])","v":""}]
[null,"來賓車輛租借",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[預估]]=\"\",TBL_Transportation[[#This Row],[實際]]=\"\"),\"\",TBL_Transportation[[#This Row],[預估]]-TBL_Transportation[[#This Row],[實際]])","v":""}]
[null,"外地來賓交通",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[預估]]=\"\",TBL_Transportation[[#This Row],[實際]]=\"\"),\"\",TBL_Transportation[[#This Row],[預估]]-TBL_Transportation[[#This Row],[實際]])","v":""}]
[null,"代客停車",{"v":50,"d":"NT$50.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[預估]]=\"\",TBL_Transportation[[#This Row],[實際]]=\"\"),\"\",TBL_Transportation[[#This Row],[預估]]-TBL_Transportation[[#This Row],[實際]])","v":""}]
[null,"雜項費用",{"v":100,"d":"NT$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[預估]]=\"\",TBL_Transportation[[#This Row],[實際]]=\"\"),\"\",TBL_Transportation[[#This Row],[預估]]-TBL_Transportation[[#This Row],[實際]])","v":""}]
[null,"交通總計",{"$f":"SUBTOTAL(109,TBL_Transportation[預估])","v":{"v":450,"d":"NT$450.00"}},{"$f":"SUBTOTAL(109,TBL_Transportation[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"TBL_Transportation[[#Totals],[預估]]-TBL_Transportation[[#Totals],[實際]]","v":{"v":450,"d":"NT$450.00"}}]