{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["預算摘要","預算詳細資料"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"預算摘要","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"總婚禮預算",{"v":20000,"d":"NT$20,000"}]
[]
[null,"支出","費用分配\n%","配置的預算","預估\n費用","實際\n費用"]
[null,"接待處",{"v":0.5,"d":"50%"},{"$f":"Total_Wedding_Budget*預算摘要!$C6","v":{"v":10000,"d":"NT$10,000"}},{"$f":"Table_Reception[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_Reception[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"服裝",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*預算摘要!$C7","v":{"v":2000,"d":"NT$2,000"}},{"$f":"Table_Attire[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_Attire[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"花與佈置裝飾",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*預算摘要!$C8","v":{"v":2000,"d":"NT$2,000"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"音樂",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*預算摘要!$C9","v":{"v":2000,"d":"NT$2,000"}},{"$f":"Table_Music[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_Music[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"相片和影片",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*預算摘要!$C10","v":{"v":2000,"d":"NT$2,000"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"回禮和禮物",{"v":0.03,"d":"3%"},{"$f":"Total_Wedding_Budget*預算摘要!$C11","v":{"v":600,"d":"NT$600"}},{"$f":"Table_FavorsAndGifts[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_FavorsAndGifts[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"典禮",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*預算摘要!$C12","v":{"v":400,"d":"NT$400"}},{"$f":"Table_Ceremony[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_Ceremony[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"信箋",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*預算摘要!$C13","v":{"v":400,"d":"NT$400"}},{"$f":"Table_Stationery[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_Stationery[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"結婚戒指",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*預算摘要!$C14","v":{"v":400,"d":"NT$400"}},{"$f":"Table_WeddingRings[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_WeddingRings[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"交通",{"v":0.01,"d":"1%"},{"$f":"Total_Wedding_Budget*預算摘要!$C15","v":{"v":200,"d":"NT$200"}},{"$f":"Table_Transportation[[#Totals],[預估費用]]","v":{"v":0,"d":"NT$0"}},{"$f":"Table_Transportation[[#Totals],[實際費用]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"NT$20,000"}},{"v":0,"d":"NT$0"},{"v":0,"d":"NT$0"}]
[]
[null,"餽贈"]
[null,"資金來源","餽贈"]
[null,"儲蓄",{"v":10000,"d":"NT$10,000"}]
[null,"伴侶 1 的父母",{"v":4000,"d":"NT$4,000"}]
[null,"伴侶 1 的祖父母",{"v":2000,"d":"NT$2,000"}]
[null,"伴侶 2 的父母",{"v":4000,"d":"NT$4,000"}]
[null,"伴侶 2 的祖父母",{"v":4000,"d":"NT$4,000"}]
[null,"其他餽贈",{"v":2000,"d":"NT$2,000"}]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Contributions[餽贈])","v":{"v":26000,"d":"NT$26,000"}}]
[]
[null,{"$f":"IF(Table_Contributions[[#Totals],[餽贈]]<Total_Wedding_Budget,\"要組成的差異\",\"可用的額外資金\")","v":"可用的額外資金"},{"$f":"IF(Table_Contributions[[#Totals],[餽贈]]<Total_Wedding_Budget,Total_Wedding_Budget-Table_Contributions[[#Totals],[餽贈]],Table_Contributions[[#Totals],[餽贈]]-Total_Wedding_Budget)","v":{"v":6000,"d":"NT$6,000"}}]

{"sheet":"預算詳細資料","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"接待處","預估費用","實際費用"]
[null,"場地和租金"]
[null,"餐點和服務"]
[null,"飲料"]
[null,"蛋糕"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Reception[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_Reception[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"服裝","預估費用","實際費用"]
[null,"西裝和/或禮服"]
[null,"更換"]
[null,"頭飾和頭紗"]
[null,"首飾"]
[null,"妝髮"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Attire[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_Attire[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"花與佈置裝飾","預估費用","實際費用"]
[null,"典禮花卉佈置"]
[null,"花童的花環和花籃"]
[null,"戒枕"]
[null,"花束"]
[null,"襟花"]
[null,"胸花"]
[null,"接待處佈置裝飾"]
[null,"燈光"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"音樂","預估費用","實際費用"]
[null,"典禮樂手"]
[null,"雞尾酒時間樂手"]
[null,"接待處樂團、DJ 或娛樂"]
[null,"音響系統或舞池租借"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Music[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_Music[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"相片和影片","預估費用","實際費用"]
[null,"攝影"]
[null,"錄影"]
[null,"其他印刷品和相簿"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"回禮和禮物","預估費用","實際費用"]
[null,"歡迎禮"]
[null,"派對禮"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"典禮","預估費用","實際費用"]
[null,"場地費用"]
[null,"主婚人費用或教堂捐贈"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Ceremony[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_Ceremony[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"信箋","預估費用","實際費用"]
[null,"喜帖"]
[null,"邀請和與會者"]
[null,"流程手冊"]
[null,"座位表和座位卡"]
[null,"菜單"]
[null,"謝卡"]
[null,"郵資"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Stationery[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_Stationery[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"結婚戒指","預估費用","實際費用"]
[null,"結婚戒指"]
[null,"戒指配件"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_WeddingRings[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_WeddingRings[實際費用])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"交通","預估費用","實際費用"]
[null,"主車租借"]
[null,"來賓車輛租借"]
[null,"外地來賓交通"]
[null,"代客停車"]
[null,"雜項"]
[null,"合計",{"$f":"SUBTOTAL(109,Table_Transportation[預估費用])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Table_Transportation[實際費用])","v":{"v":0,"d":"NT$0.00"}}]