{"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":"¥20,000"}]
[]
[null,"支出","分配 %","预算分配","估计费用","实际费用"]
[null,"宴会",{"v":0.5,"d":"¥1"},{"$f":"婚礼_总_预算*预算摘要!$C6","v":{"v":10000,"d":"¥10,000"}},{"$f":"表格_宴会[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_宴会[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"服装",{"v":0.1,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C7","v":{"v":2000,"d":"¥2,000"}},{"$f":"表格_服装[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_服装[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"花卉和装饰",{"v":0.1,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C8","v":{"v":2000,"d":"¥2,000"}},{"$f":"表格_花卉和装饰[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_花卉和装饰[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"音乐",{"v":0.1,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C9","v":{"v":2000,"d":"¥2,000"}},{"$f":"表格_音乐[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_音乐[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"图片和视频",{"v":0.1,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C10","v":{"v":2000,"d":"¥2,000"}},{"$f":"表格_摄影和视频[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_摄影和视频[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"惠赠和礼物",{"v":0.03,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C11","v":{"v":600,"d":"¥600"}},{"$f":"表格_惠赠和礼品[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_惠赠和礼品[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"典礼",{"v":0.02,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C12","v":{"v":400,"d":"¥400"}},{"$f":"表格_典礼[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_典礼[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"纸品",{"v":0.02,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C13","v":{"v":400,"d":"¥400"}},{"$f":"表格_纸品[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_纸品[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"结婚戒指",{"v":0.02,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C14","v":{"v":400,"d":"¥400"}},{"$f":"表格_结婚戒指[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_结婚戒指[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"交通",{"v":0.01,"d":"¥0"},{"$f":"婚礼_总_预算*预算摘要!$C15","v":{"v":200,"d":"¥200"}},{"$f":"表格_交通[[#Totals],[估计费用]]","v":{"v":0,"d":"¥0"}},{"$f":"表格_交通[[#Totals],[实际费用]]","v":{"v":0,"d":"¥0"}}]
[null,"汇总",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"¥1"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"¥20,000"}},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"}]
[]
[null,"出资"]
[null,"资金来源","出资"]
[null,"存款",{"v":10000,"d":"¥10,000"}]
[null,"配偶 1 的父母",{"v":4000,"d":"¥4,000"}]
[null,"配偶 1 的祖父母",{"v":2000,"d":"¥2,000"}]
[null,"配偶 2 的父母",{"v":4000,"d":"¥4,000"}]
[null,"配偶 2 的祖父母",{"v":4000,"d":"¥4,000"}]
[null,"其他出资",{"v":2000,"d":"¥2,000"}]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_出资额[出资])","v":{"v":26000,"d":"¥26,000"}}]
[]
[null,{"$f":"IF(表格_出资额[[#Totals],[出资]]<婚礼_总_预算,\"弥补差异\",\"可用额外资金\")","v":"可用额外资金"},{"$f":"IF(表格_出资额[[#Totals],[出资]]<婚礼_总_预算,婚礼_总_预算-表格_出资额[[#Totals],[出资]],表格_出资额[[#Totals],[出资]]-婚礼_总_预算)","v":{"v":6000,"d":"¥6,000"}}]

{"sheet":"预算明细","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"宴会","估计费用","实际费用"]
[null,"场地和租金"]
[null,"餐费和服务"]
[null,"饮料"]
[null,"蛋糕"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_宴会[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_宴会[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"着装","估计费用","实际费用"]
[null,"礼服、西服和/或连衣裙"]
[null,"修改"]
[null,"头饰和面纱"]
[null,"配饰"]
[null,"头发和化妆"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_服装[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_服装[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"花卉和装饰","估计费用","实际费用"]
[null,"典礼的花卉安排"]
[null,"花童的花和篮子"]
[null,"环形枕头"]
[null,"花束"]
[null,"翻领纽扣孔胸花"]
[null,"襟花"]
[null,"宴会装饰"]
[null,"照明"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_花卉和装饰[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_花卉和装饰[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"音乐","估计费用","实际费用"]
[null,"典礼乐手"]
[null,"鸡尾酒会乐手"]
[null,"宴会乐队、主持或娱乐"]
[null,"音响系统或舞池租赁"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_音乐[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_音乐[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"图片和视频","估计费用","实际费用"]
[null,"摄影"]
[null,"摄像"]
[null,"其他打印和相册"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_摄影和视频[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_摄影和视频[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"惠赠和礼品","估计费用","实际费用"]
[null,"欢迎礼品"]
[null,"派对礼品"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_惠赠和礼品[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_惠赠和礼品[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"典礼","估计费用","实际费用"]
[null,"场地费"]
[null,"司仪费或教会捐献"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_典礼[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_典礼[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"纸品","估计费用","实际费用"]
[null,"按时出席卡"]
[null,"邀请函和 RSVP"]
[null,"节目单"]
[null,"席位卡"]
[null,"菜单卡"]
[null,"感谢便笺"]
[null,"邮费"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_纸品[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_纸品[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"结婚戒指","估计费用","实际费用"]
[null,"结婚戒指"]
[null,"戒指配饰"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_结婚戒指[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_结婚戒指[实际费用])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"交通","估计费用","实际费用"]
[null,"主汽车租赁"]
[null,"来宾汽车租赁"]
[null,"外地客人的交通费"]
[null,"泊车员停车费"]
[null,"杂项费用"]
[null,"汇总",{"$f":"SUBTOTAL(109,表格_交通[估计费用])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表格_交通[实际费用])","v":{"v":0,"d":"¥0.00"}}]