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

{"sheet":"Wedding Budget","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[{"$nulls":6}," "]
[null,"LISHA + DANIEL\nTIE THE KNOT"]
[{"$nulls":7}," "]
[]
[null,"CATEGORY","ESTIMATED COST","ACTUAL COST","VARIANCE","BUDGET %",{"$nulls":3},"Unsorted","Estimated Costs","Actual Costs","Estimated Cost - Rank Value","Rank","#","Sorted"]
[null,{"$f":"P6","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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":{"v":1700,"d":"£1,700"}},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Reception",{"$f":"TBL_Reception[[#Totals],[ESTIMATED]]","v":14500},{"$f":"TBL_Reception[[#Totals],[ACTUAL]]","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":"Reception"}]
[null,{"$f":"P7","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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":{"v":1100,"d":"£1,100"}},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Attire",{"$f":"TBL_Attire[[#Totals],[ESTIMATED]]","v":4000},{"$f":"TBL_Attire[[#Totals],[ACTUAL]]","v":2900},{"$f":"K7-O7/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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Flowers and decorations",{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMATED]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[ACTUAL]]","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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"Music",{"$f":"TBL_Music[[#Totals],[ESTIMATED]]","v":1800},{"$f":"TBL_Music[[#Totals],[ACTUAL]]","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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Photographs and video",{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMATED]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[ACTUAL]]","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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Favors and gifts",{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMATED]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[ACTUAL]]","v":0},1099.94,6,6,"Favors and gifts"]
[null,{"$f":"P12","v":"Wedding rings"},{"$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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Ceremony",{"$f":"TBL_Ceremony[[#Totals],[ESTIMATED]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[ACTUAL]]","v":0},799.93,8,7,"Wedding rings"]
[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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Stationery",{"$f":"TBL_Stationery[[#Totals],[ESTIMATED]]","v":500},{"$f":"TBL_Stationery[[#Totals],[ACTUAL]]","v":0},499.92,9,8,"Ceremony"]
[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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Wedding rings",{"$f":"TBL_WeddingRings[[#Totals],[ESTIMATED]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[ACTUAL]]","v":0},1099.91,7,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 COST]]=\"\",TBL_Summary[[#This Row],[ACTUAL COST]]=\"\"),\"\",TBL_Summary[[#This Row],[ESTIMATED COST]]-TBL_Summary[[#This Row],[ACTUAL COST]])","v":""},{"$f":"TBL_Summary[[#This Row],[ESTIMATED COST]]/SUM(TBL_Summary[ESTIMATED COST])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"Transportation",{"$f":"TBL_Transportation[[#Totals],[ESTIMATED]]","v":450},{"$f":"TBL_Transportation[[#Totals],[ACTUAL]]","v":0},449.9,10,10,"Transportation"]
[null,"Total",{"$f":"SUBTOTAL(109,TBL_Summary[ESTIMATED COST])","v":{"v":29750,"d":"£29,750"}},{"$f":"SUBTOTAL(109,TBL_Summary[ACTUAL COST])","v":{"v":15700,"d":"£15,700"}},{"$f":"TBL_Summary[[#Totals],[ESTIMATED COST]]-TBL_Summary[[#Totals],[ACTUAL COST]]","v":{"v":14050,"d":"£14,050"}},{"$f":"SUBTOTAL(109,TBL_Summary[BUDGET %])","v":{"v":1,"d":"100%"}}]

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