{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Wedding Budget","Budget Details"],"not_rendered":{"charts":1,"images":3,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Wedding Budget","index":0,"n_rows":17,"n_cols":16,"rows_kept":17}
[{"$nulls":6}," "]
[null,"Wedding Budget"]
[]
[]
[]
[null,"Category","Estimated Costs","Actual Costs","Variance","Budget %",{"$nulls":3},"Unsorted","Estimated Costs","Actual Costs","Estimated Cost - Rank Value","Rank","#","Sorted"]
[null,{"$f":"P7","v":"Reception"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"$14,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"$12,800"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":{"v":1700,"d":"$1,700"}},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.49572649572649574,"d":"49.6%"}},{"$nulls":3},"Reception",{"$f":"TBL_Reception[[#Totals],[Estimated Costs]]","v":14500},{"$f":"TBL_Reception[[#Totals],[Actual Costs]]","v":12800},{"$f":"K7-O7/100","v":14499.99},{"$f":"_xlfn.RANK.AVG(M7,$M$7:$M$16)","v":1},1,{"$f":"INDEX(TBL_RankingData,MATCH(O7,$N$7:$N$16,0),1)","v":"Reception"}]
[null,{"$f":"P8","v":"Attire"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"$4,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"$2,900"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":{"v":1100,"d":"$1,100"}},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.13675213675213677,"d":"13.7%"}},{"$nulls":3},"Attire",{"$f":"TBL_Attire[[#Totals],[Estimated Costs]]","v":4000},{"$f":"TBL_Attire[[#Totals],[Actual Costs]]","v":2900},{"$f":"K8-O8/100","v":3999.98},2,2,"Attire"]
[null,"Flowers and Decorations",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"$3,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.10256410256410256,"d":"10.3%"}},{"$nulls":3},"Flowers and Decorations",{"$f":"TBL_FlowersAndDecor[[#Totals],[Estimated Costs]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[Actual Costs]]","v":0},2999.97,3,3,"Flowers and Decorations"]
[null,"Photographs and Video",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"$2,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.08547008547008547,"d":"8.5%"}},{"$nulls":3},"Music",{"$f":"TBL_Music[[#Totals],[Estimated Costs]]","v":1800},{"$f":"TBL_Music[[#Totals],[Actual Costs]]","v":0},1799.96,5,4,"Photographs and Video"]
[null,"Music",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"$1,800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.06153846153846154,"d":"6.2%"}},{"$nulls":3},"Photographs and Video",{"$f":"TBL_PhotographsAndVideo[[#Totals],[Estimated Costs]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[Actual Costs]]","v":0},2499.95,4,5,"Music"]
[null,"Favors and Gifts",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"$1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.037606837606837605,"d":"3.8%"}},{"$nulls":3},"Favors and Gifts",{"$f":"TBL_FavorsAndGifts[[#Totals],[Estimated Costs]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[Actual Costs]]","v":0},1099.94,6,6,"Favors and Gifts"]
[null,"Ceremony",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"$800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.02735042735042735,"d":"2.7%"}},{"$nulls":3},"Ceremony",{"$f":"TBL_Ceremony[[#Totals],[Estimated Costs]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[Actual Costs]]","v":0},799.93,7,7,"Ceremony"]
[null,"Wedding Rings",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":600,"d":"$600"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.020512820512820513,"d":"2.1%"}},{"$nulls":3},"Stationery",{"$f":"TBL_Stationery[[#Totals],[Estimated Costs]]","v":500},{"$f":"TBL_Stationery[[#Totals],[Actual Costs]]","v":0},499.92,9,8,"Wedding Rings"]
[null,"Stationery",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"$500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.017094017094017096,"d":"1.7%"}},{"$nulls":3},"Wedding Rings",{"$f":"TBL_WeddingRings[[#Totals],[Estimated Costs]]","v":600},{"$f":"TBL_WeddingRings[[#Totals],[Actual Costs]]","v":0},599.91,8,9,"Stationery"]
[null,"Transportation",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"$450"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[Category]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[Estimated Costs]]=\"\",TBL_Summary[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Summary[[#This Row],[Estimated Costs]]-TBL_Summary[[#This Row],[Actual Costs]])","v":""},{"$f":"TBL_Summary[[#This Row],[Estimated Costs]]/SUM(TBL_Summary[Estimated Costs])","v":{"v":0.015384615384615385,"d":"1.5%"}},{"$nulls":3},"Transportation",{"$f":"TBL_Transportation[[#Totals],[Estimated Costs]]","v":450},{"$f":"TBL_Transportation[[#Totals],[Actual Costs]]","v":0},449.9,10,10,"Transportation"]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Summary[Estimated Costs])","v":{"v":29250,"d":"$29,250"}},{"$f":"SUBTOTAL(109,TBL_Summary[Actual Costs])","v":{"v":15700,"d":"$15,700"}},{"$f":"TBL_Summary[[#Totals],[Estimated Costs]]-TBL_Summary[[#Totals],[Actual Costs]]","v":{"v":13550,"d":"$13,550"}},{"$f":"SUBTOTAL(109,TBL_Summary[Budget %])","v":{"v":1,"d":"100%"}}]

{"sheet":"Budget Details","index":1,"n_rows":82,"n_cols":6,"rows_kept":82}
[{"$nulls":5}," "]
[null,"Budget Details"]
[]
[null,"RECEPTION","Estimated Costs","Actual Costs","Variance"]
[null,"Venue and rentals",{"v":8000,"d":"$8,000.00"},{"v":7800,"d":"$7,800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[Estimated Costs]]=\"\",TBL_Reception[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Reception[[#This Row],[Estimated Costs]]-TBL_Reception[[#This Row],[Actual Costs]])","v":{"v":200,"d":"$200.00"}}]
[null,"Food and service",{"v":4000,"d":"$4,000.00"},{"v":4200,"d":"$4,200.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[Estimated Costs]]=\"\",TBL_Reception[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Reception[[#This Row],[Estimated Costs]]-TBL_Reception[[#This Row],[Actual Costs]])","v":{"v":-200,"d":"($200.00)"}}]
[null,"Beverages",{"v":1000,"d":"$1,000.00"},{"v":800,"d":"$800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[Estimated Costs]]=\"\",TBL_Reception[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Reception[[#This Row],[Estimated Costs]]-TBL_Reception[[#This Row],[Actual Costs]])","v":{"v":200,"d":"$200.00"}}]
[null,"Cake",{"v":1000,"d":"$1,000.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[Estimated Costs]]=\"\",TBL_Reception[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Reception[[#This Row],[Estimated Costs]]-TBL_Reception[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[Estimated Costs]]=\"\",TBL_Reception[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Reception[[#This Row],[Estimated Costs]]-TBL_Reception[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Reception[Estimated Costs])","v":{"v":14500,"d":"$14,500.00"}},{"$f":"SUBTOTAL(109,TBL_Reception[Actual Costs])","v":{"v":12800,"d":"$12,800.00"}},{"$f":"TBL_Reception[[#Totals],[Estimated Costs]]-TBL_Reception[[#Totals],[Actual Costs]]","v":{"v":1700,"d":"$1,700.00"}}]
[]
[null,"ATTIRE","Estimated Costs","Actual Costs","Variance"]
[null,"Tux, suit, and/or dresses",{"v":3000,"d":"$3,000.00"},{"v":2900,"d":"$2,900.00"},{"$f":"IF(OR(TBL_Attire[[#This Row],[Estimated Costs]]=\"\",TBL_Attire[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Attire[[#This Row],[Estimated Costs]]-TBL_Attire[[#This Row],[Actual Costs]])","v":{"v":100,"d":"$100.00"}}]
[null,"Alterations",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[Estimated Costs]]=\"\",TBL_Attire[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Attire[[#This Row],[Estimated Costs]]-TBL_Attire[[#This Row],[Actual Costs]])","v":""}]
[null,"Headpiece and veil",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[Estimated Costs]]=\"\",TBL_Attire[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Attire[[#This Row],[Estimated Costs]]-TBL_Attire[[#This Row],[Actual Costs]])","v":""}]
[null,"Accessories",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[Estimated Costs]]=\"\",TBL_Attire[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Attire[[#This Row],[Estimated Costs]]-TBL_Attire[[#This Row],[Actual Costs]])","v":""}]
[null,"Hair and makeup",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[Estimated Costs]]=\"\",TBL_Attire[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Attire[[#This Row],[Estimated Costs]]-TBL_Attire[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[Estimated Costs]]=\"\",TBL_Attire[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Attire[[#This Row],[Estimated Costs]]-TBL_Attire[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Attire[Estimated Costs])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TBL_Attire[Actual Costs])","v":{"v":2900,"d":"$2,900.00"}},{"$f":"TBL_Attire[[#Totals],[Estimated Costs]]-TBL_Attire[[#Totals],[Actual Costs]]","v":{"v":1100,"d":"$1,100.00"}}]
[]
[null,"FLOWERS AND DECORATIONS","Estimated Costs","Actual Costs","Variance"]
[null,"Floral arrangements for ceremony",{"v":1000,"d":"$1,000.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Flower girl’s buds and basket",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Ring pillow",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Bouquets",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Boutonnieres",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Corsages",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Reception decorations",{"v":300,"d":"$300.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Lighting",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]=\"\",TBL_FlowersAndDecor[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[Estimated Costs]]-TBL_FlowersAndDecor[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[Estimated Costs])","v":{"v":3000,"d":"$3,000.00"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[Estimated Costs]]-TBL_FlowersAndDecor[[#Totals],[Actual Costs]]","v":{"v":3000,"d":"$3,000.00"}}]
[]
[null,"MUSIC","Estimated Costs","Actual Costs","Variance"]
[null,"Ceremony musicians",{"v":700,"d":"$700.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[Estimated Costs]]=\"\",TBL_Music[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Music[[#This Row],[Estimated Costs]]-TBL_Music[[#This Row],[Actual Costs]])","v":""}]
[null,"Cocktail-hour musicians",{"v":300,"d":"$300.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[Estimated Costs]]=\"\",TBL_Music[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Music[[#This Row],[Estimated Costs]]-TBL_Music[[#This Row],[Actual Costs]])","v":""}]
[null,"Reception band, deejay, or entertainment",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[Estimated Costs]]=\"\",TBL_Music[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Music[[#This Row],[Estimated Costs]]-TBL_Music[[#This Row],[Actual Costs]])","v":""}]
[null,"Sound-system or dance-floor rental",{"v":400,"d":"$400.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[Estimated Costs]]=\"\",TBL_Music[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Music[[#This Row],[Estimated Costs]]-TBL_Music[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[Estimated Costs]]=\"\",TBL_Music[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Music[[#This Row],[Estimated Costs]]-TBL_Music[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Music[Estimated Costs])","v":{"v":1800,"d":"$1,800.00"}},{"$f":"SUBTOTAL(109,TBL_Music[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_Music[[#Totals],[Estimated Costs]]-TBL_Music[[#Totals],[Actual Costs]]","v":{"v":1800,"d":"$1,800.00"}}]
[]
[null,"PHOTOGRAPHS AND VIDEO","Estimated Costs","Actual Costs","Variance"]
[null,"Photography",{"v":1000,"d":"$1,000.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]=\"\",TBL_PhotographsAndVideo[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]-TBL_PhotographsAndVideo[[#This Row],[Actual Costs]])","v":""}]
[null,"Videography",{"v":800,"d":"$800.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]=\"\",TBL_PhotographsAndVideo[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]-TBL_PhotographsAndVideo[[#This Row],[Actual Costs]])","v":""}]
[null,"Additional prints and albums",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]=\"\",TBL_PhotographsAndVideo[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]-TBL_PhotographsAndVideo[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]=\"\",TBL_PhotographsAndVideo[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[Estimated Costs]]-TBL_PhotographsAndVideo[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[Estimated Costs])","v":{"v":2500,"d":"$2,500.00"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[Estimated Costs]]-TBL_PhotographsAndVideo[[#Totals],[Actual Costs]]","v":{"v":2500,"d":"$2,500.00"}}]
[]
[null,"FAVORS AND GIFTS","Estimated Costs","Actual Costs","Variance"]
[null,"Welcome gifts",{"v":700,"d":"$700.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[Estimated Costs]]=\"\",TBL_FavorsAndGifts[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[Estimated Costs]]-TBL_FavorsAndGifts[[#This Row],[Actual Costs]])","v":""}]
[null,"Party gifts",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[Estimated Costs]]=\"\",TBL_FavorsAndGifts[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[Estimated Costs]]-TBL_FavorsAndGifts[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[Estimated Costs]]=\"\",TBL_FavorsAndGifts[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[Estimated Costs]]-TBL_FavorsAndGifts[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[Estimated Costs])","v":{"v":1100,"d":"$1,100.00"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[Estimated Costs]]-TBL_FavorsAndGifts[[#Totals],[Actual Costs]]","v":{"v":1100,"d":"$1,100.00"}}]
[]
[null,"CEREMONY","Estimated Costs","Actual Costs","Variance"]
[null,"Site fee",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[Estimated Costs]]=\"\",TBL_Ceremony[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Ceremony[[#This Row],[Estimated Costs]]-TBL_Ceremony[[#This Row],[Actual Costs]])","v":""}]
[null,"Officiant fee or church donation",{"v":200,"d":"$200.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[Estimated Costs]]=\"\",TBL_Ceremony[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Ceremony[[#This Row],[Estimated Costs]]-TBL_Ceremony[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[Estimated Costs]]=\"\",TBL_Ceremony[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Ceremony[[#This Row],[Estimated Costs]]-TBL_Ceremony[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Ceremony[Estimated Costs])","v":{"v":800,"d":"$800.00"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_Ceremony[[#Totals],[Estimated Costs]]-TBL_Ceremony[[#Totals],[Actual Costs]]","v":{"v":800,"d":"$800.00"}}]
[]
[null,"STATIONERY","Estimated Costs","Actual Costs","Variance"]
[null,"Save-the-date cards",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Invitations and RSVPs",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Programs",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Seating and place cards",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Menu cards",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Thank-you notes",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Postage",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[Estimated Costs]]=\"\",TBL_Stationery[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Stationery[[#This Row],[Estimated Costs]]-TBL_Stationery[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Stationery[Estimated Costs])","v":{"v":500,"d":"$500.00"}},{"$f":"SUBTOTAL(109,TBL_Stationery[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_Stationery[[#Totals],[Estimated Costs]]-TBL_Stationery[[#Totals],[Actual Costs]]","v":{"v":500,"d":"$500.00"}}]
[]
[null,"WEDDING RINGS","Estimated Costs","Actual Costs","Variance"]
[null,"Wedding rings",{"v":500,"d":"$500.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[Estimated Costs]]=\"\",TBL_WeddingRings[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[Estimated Costs]]-TBL_WeddingRings[[#This Row],[Actual Costs]])","v":""}]
[null,"Ring accessories",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[Estimated Costs]]=\"\",TBL_WeddingRings[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[Estimated Costs]]-TBL_WeddingRings[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_WeddingRings[Estimated Costs])","v":{"v":600,"d":"$600.00"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_WeddingRings[[#Totals],[Estimated Costs]]-TBL_WeddingRings[[#Totals],[Actual Costs]]","v":{"v":600,"d":"$600.00"}}]
[]
[null,"TRANSPORTATION","Estimated Costs","Actual Costs","Variance"]
[null,"Main car rental",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[Estimated Costs]]=\"\",TBL_Transportation[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Transportation[[#This Row],[Estimated Costs]]-TBL_Transportation[[#This Row],[Actual Costs]])","v":""}]
[null,"Guests car rental",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[Estimated Costs]]=\"\",TBL_Transportation[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Transportation[[#This Row],[Estimated Costs]]-TBL_Transportation[[#This Row],[Actual Costs]])","v":""}]
[null,"Transportation for out-of-town guests",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[Estimated Costs]]=\"\",TBL_Transportation[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Transportation[[#This Row],[Estimated Costs]]-TBL_Transportation[[#This Row],[Actual Costs]])","v":""}]
[null,"Valet parking",{"v":50,"d":"$50.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[Estimated Costs]]=\"\",TBL_Transportation[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Transportation[[#This Row],[Estimated Costs]]-TBL_Transportation[[#This Row],[Actual Costs]])","v":""}]
[null,"Miscellaneous fees",{"v":100,"d":"$100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[Estimated Costs]]=\"\",TBL_Transportation[[#This Row],[Actual Costs]]=\"\"),\"\",TBL_Transportation[[#This Row],[Estimated Costs]]-TBL_Transportation[[#This Row],[Actual Costs]])","v":""}]
[null,"TOTAL",{"$f":"SUBTOTAL(109,TBL_Transportation[Estimated Costs])","v":{"v":450,"d":"$450.00"}},{"$f":"SUBTOTAL(109,TBL_Transportation[Actual Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"TBL_Transportation[[#Totals],[Estimated Costs]]-TBL_Transportation[[#Totals],[Actual Costs]]","v":{"v":450,"d":"$450.00"}}]