{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget summary","Budget details"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget summary","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"merged":[[0,1,0,5],[1,1,1,5],[3,1,3,3],[3,4,3,5],[18,1,18,5],[29,1,29,3],[29,4,29,5]]}
[null,"WEDDING BUDGET"]
[null,"Sara Steale & Davide Milano",{"$nulls":4}," "]
[]
[null,"Total Wedding Budget",null,null,{"v":20000,"d":"$20,000"}]
[]
[null,"EXPENSES","Allocation \n%","Allocated budget","Estimated \ncosts","Actual \ncosts"]
[null,"Reception",{"v":0.5,"d":"$1"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C7","v":{"v":10000,"d":"$10,000"}},{"$f":"Table_Reception[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_Reception[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Attire",{"v":0.1,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C8","v":{"v":2000,"d":"$2,000"}},{"$f":"Table_Attire[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_Attire[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Flowers and decorations",{"v":0.1,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C9","v":{"v":2000,"d":"$2,000"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Music",{"v":0.1,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C10","v":{"v":2000,"d":"$2,000"}},{"$f":"Table_Music[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_Music[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Photographs and video",{"v":0.1,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C11","v":{"v":2000,"d":"$2,000"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Favors and gifts",{"v":0.03,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C12","v":{"v":600,"d":"$600"}},{"$f":"Table_FavorsAndGifts[[#Totals],[Estimated Costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_FavorsAndGifts[[#Totals],[Actual Costs]]","v":{"v":0,"d":"$0"}}]
[null,"Ceremony",{"v":0.02,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C13","v":{"v":400,"d":"$400"}},{"$f":"Table_Ceremony[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_Ceremony[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Stationery",{"v":0.02,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C14","v":{"v":400,"d":"$400"}},{"$f":"Table_Stationery[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_Stationery[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Wedding rings",{"v":0.02,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C15","v":{"v":400,"d":"$400"}},{"$f":"Table_WeddingRings[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_WeddingRings[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Transportation",{"v":0.01,"d":"$0"},{"$f":"Total_Wedding_Budget*'Budget summary'!$C16","v":{"v":200,"d":"$200"}},{"$f":"Table_Transportation[[#Totals],[Estimated costs]]","v":{"v":0,"d":"$0"}},{"$f":"Table_Transportation[[#Totals],[Actual costs]]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUM(C7:C16)","v":{"v":1,"d":"$1"}},{"$f":"SUM(D7:D16)","v":{"v":20000,"d":"$20,000"}},{"$f":"SUM(E7:E16)","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table13[Actual \ncosts])","v":{"v":0,"d":"$0"}}]
[]
[null,"Contributions"]
[]
[null,"SOURCE OF FUNDS","Contribution"]
[null,"Savings",{"v":10000,"d":"$10,000"}]
[null,"Mom & Dad of Partner 1",{"v":4000,"d":"$4,000"}]
[null,"Grandparents of Partner 1",{"v":2000,"d":"$2,000"}]
[null,"Mom & Dad of Partner 2",{"v":4000,"d":"$4,000"}]
[null,"Grandparents of Partner 2",{"v":4000,"d":"$4,000"}]
[null,"Other contributions",{"v":2000,"d":"$2,000"}]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Contributions[Contribution])","v":{"v":26000,"d":"$26,000"}}]
[]
[null,{"$f":"IF(Table_Contributions[[#Totals],[Contribution]]<Total_Wedding_Budget,\"Difference to make up\",\"Available extra funds\")","v":"Available extra funds"},null,null,{"$f":"IF(Table_Contributions[[#Totals],[Contribution]]<Total_Wedding_Budget,Total_Wedding_Budget-Table_Contributions[[#Totals],[Contribution]],Table_Contributions[[#Totals],[Contribution]]-Total_Wedding_Budget)","v":{"v":6000,"d":"$6,000"}}]

{"sheet":"Budget details","index":1,"n_rows":82,"n_cols":4,"rows_kept":82,"merged":[[0,1,0,3]]}
[null,"BUDGET SUMMARY"]
[]
[]
[null,"RECEPTION","Estimated costs","Actual costs"]
[null,"Venue and rentals"]
[null,"Food and service"]
[null,"Beverages"]
[null,"Cake"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Reception[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_Reception[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"ATTIRE","Estimated costs","Actual costs"]
[null,"Tux, suit, and/or dresses"]
[null,"Alterations"]
[null,"Headpiece and veil"]
[null,"Accessories"]
[null,"Hair and makeup"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Attire[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_Attire[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"FLOWERS AND DECORATIONS","Estimated costs","Actual costs"]
[null,"Floral arrangements for ceremony"]
[null,"Flower girl’s buds and basket"]
[null,"Ring pillow"]
[null,"Bouquets"]
[null,"Boutonnieres"]
[null,"Corsages"]
[null,"Reception decorations"]
[null,"Lighting"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"MUSIC","Estimated costs","Actual costs"]
[null,"Ceremony musicians"]
[null,"Cocktail-hour musicians"]
[null,"Reception band, deejay, or entertainment"]
[null,"Sound-system or dance-floor rental"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Music[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_Music[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"PHOTOGRAPHS AND VIDEO","Estimated costs","Actual costs"]
[null,"Photography"]
[null,"Videography"]
[null,"Additional prints and albums"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(105,Table_PhotographsAndVideo[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"FAVORS AND GIFTS","Estimated Costs","Actual Costs"]
[null,"Welcome gifts"]
[null,"Party gifts"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[Estimated Costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[Actual Costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"CEREMONY","Estimated costs","Actual costs"]
[null,"Site fee"]
[null,"Officiant fee or church donation"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Ceremony[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_Ceremony[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"STATIONERY","Estimated costs","Actual costs"]
[null,"Save-the-date cards"]
[null,"Invitations and RSVPs"]
[null,"Programs"]
[null,"Seating and place cards"]
[null,"Menu cards"]
[null,"Thank-you notes"]
[null,"Postage"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Stationery[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_Stationery[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"WEDDING RINGS","Estimated costs","Actual costs"]
[null,"Wedding rings"]
[null,"Ring accessories"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_WeddingRings[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_WeddingRings[Actual costs])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"TRANSPORTATION","Estimated costs","Actual costs"]
[null,"Main car rental"]
[null,"Guests car rental"]
[null,"Transportation for out-of-town guests"]
[null,"Valet parking"]
[null,"Miscellaneous fees"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Transportation[Estimated costs])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table_Transportation[Actual costs])","v":{"v":0,"d":"$0.00"}}]