{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Wedding budget","Expenses"],"not_rendered":{"charts":1,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"Wedding budget","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Wedding Budget"]
[null,"Wedding Date:",null,"Days Remaining:"]
[null,{"$f":"TODAY()+365","v":"2024-02-23"},null,{"$f":"B4-TODAY()","v":365}]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Apparel",{"$f":"Apparel_Total_est","v":{"v":9490,"d":"9,490.00"}},{"$f":"Apparel_Total_act","v":{"v":9770,"d":"9,770.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":-280,"d":"-280.00"}}]
[null,"Reception",{"$f":"Reception_Total_est","v":{"v":1050,"d":"1,050.00"}},{"$f":"Reception_Total_act","v":{"v":928,"d":"928.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":122,"d":"122.00"}}]
[null,"Music",{"$f":"Music_Entertainment_Total_est","v":{"v":600,"d":"600.00"}},{"$f":"Music_Entertainment_Total_act","v":{"v":400,"d":"400.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":200,"d":"200.00"}}]
[null,"Printing",{"$f":"Printing__Stationery_Total_est","v":{"v":935,"d":"935.00"}},{"$f":"Printing__Stationery_Total_act","v":{"v":870,"d":"870.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":65,"d":"65.00"}}]
[null,"Photography",{"$f":"Photography_Total_est","v":{"v":1625,"d":"1,625.00"}},{"$f":"Photography_Total_act","v":{"v":1575,"d":"1,575.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":50,"d":"50.00"}}]
[null,"Decorations",{"$f":"Decorations_Total_est","v":{"v":700,"d":"700.00"}},{"$f":"Decorations_Total_act","v":{"v":720,"d":"720.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":-20,"d":"-20.00"}}]
[null,"Flowers",{"$f":"Flowers_Total_est","v":{"v":900,"d":"900.00"}},{"$f":"Flowers_Total_act","v":{"v":850,"d":"850.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":50,"d":"50.00"}}]
[null,"Gifts",{"$f":"Gifts_Total_est","v":{"v":1345,"d":"1,345.00"}},{"$f":"Gifts_Total_act","v":{"v":1075,"d":"1,075.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":270,"d":"270.00"}}]
[null,"Travel",{"$f":"Travel_Transportation_Total_est","v":{"v":100,"d":"100.00"}},{"$f":"Travel_Transportation_Total_act","v":{"v":165,"d":"165.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":-65,"d":"-65.00"}}]
[null,"Other",{"$f":"Other_Expenses_Total_est","v":{"v":885,"d":"885.00"}},{"$f":"Other_Expenses_Total_act","v":{"v":1021,"d":"1,021.00"}},{"$f":"BudgetSummary[[#This Row],[ESTIMATED]]-BudgetSummary[[#This Row],[ACTUAL]]","v":{"v":-136,"d":"-136.00"}}]
[null,"Total expenses",{"$f":"SUBTOTAL(109,BudgetSummary[ESTIMATED])","v":{"v":17630,"d":"17,630.00"}},{"$f":"SUBTOTAL(109,BudgetSummary[ACTUAL])","v":{"v":17374,"d":"17,374.00"}},{"$f":"SUBTOTAL(109,BudgetSummary[OVER/UNDER])","v":{"v":256,"d":"256.00"}}]

{"sheet":"Expenses","index":1,"n_rows":98,"n_cols":6,"rows_kept":98,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[18,1,18,4],[30,1,30,4],[35,1,35,4],[47,1,47,4],[54,1,54,4],[63,1,63,4],[71,1,71,4],[79,1,79,4],[85,1,85,4],[98,1,98,4]]}
[]
[null,"Expenses"]
[null,"APPAREL "]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"," "]
[null,"Engagement ring(s)",{"v":1500,"d":"1,500.00"},{"v":1500,"d":"1,500.00"},{"$f":"Expenses!$C5-Expenses!$D5","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 1 ring",{"v":2000,"d":"2,000.00"},{"v":2300,"d":"2,300.00"},{"$f":"Expenses!$C6-Expenses!$D6","v":{"v":-300,"d":"(300.00)"}}]
[null,"Spouse-to-be 1 gown/tuxedo",{"v":3000,"d":"3,000.00"},{"v":2750,"d":"2,750.00"},{"$f":"Expenses!$C7-Expenses!$D7","v":{"v":250,"d":"250.00"}}]
[null,"Spouse-to-be 1 veil/headpiece",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"Expenses!$C8-Expenses!$D8","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 1 shoes",{"v":350,"d":"350.00"},{"v":300,"d":"300.00"},{"$f":"Expenses!$C9-Expenses!$D9","v":{"v":50,"d":"50.00"}}]
[null,"Spouse-to-be 1 jewelry",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"Expenses!$C10-Expenses!$D10","v":{"v":-150,"d":"(150.00)"}}]
[null,"Spouse-to-be 1 hosiery",{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"$f":"Expenses!$C11-Expenses!$D11","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 2 ring",{"v":300,"d":"300.00"},{"v":250,"d":"250.00"},{"$f":"Expenses!$C12-Expenses!$D12","v":{"v":50,"d":"50.00"}}]
[null,"Spouse-to-be 2 gown/tuxedo",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"$f":"Expenses!$C13-Expenses!$D13","v":{"v":-50,"d":"(50.00)"}}]
[null,"Spouse-to-be 2 veil/headpiece",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"Expenses!$C14-Expenses!$D14","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 2 shoes",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"Expenses!$C15-Expenses!$D15","v":{"v":25,"d":"25.00"}}]
[null,"Spouse-to-be 2 jewelry",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"Expenses!$C16-Expenses!$D16","v":{"v":-150,"d":"(150.00)"}}]
[null,"Spouse-to-be 2 hosiery",{"v":20,"d":"20.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C17-Expenses!$D17","v":{"v":-5,"d":"(5.00)"}}]
[null,"Apparel total",{"$f":"SUBTOTAL(109,Apparel[ESTIMATED])","v":{"v":9490,"d":"9,490.00"}},{"$f":"SUBTOTAL(109,Apparel[ACTUAL])","v":{"v":9770,"d":"9,770.00"}},{"$f":"SUBTOTAL(109,Apparel[OVER/UNDER])","v":{"v":-280,"d":"(280.00)"}}]
[null,"RECEPTION*"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Room/hall fees",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"Expenses!$C21-Expenses!$D21","v":{"v":50,"d":"50.00"}}]
[null,"Tables and chairs",{"v":100,"d":"100.00"},{"v":50,"d":"50.00"},{"$f":"Expenses!$C22-Expenses!$D22","v":{"v":50,"d":"50.00"}}]
[null,"Food",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C23-Expenses!$D23","v":{"v":0,"d":"0.00"}}]
[null,"Drinks",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C24-Expenses!$D24","v":{"v":0,"d":"0.00"}}]
[null,"Linens",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C25-Expenses!$D25","v":{"v":0,"d":"0.00"}}]
[null,"Cake",{"v":700,"d":"700.00"},{"v":700,"d":"700.00"},{"$f":"Expenses!$C26-Expenses!$D26","v":{"v":0,"d":"0.00"}}]
[null,"Favors",{"v":50,"d":"50.00"},{"v":28,"d":"28.00"},{"$f":"Expenses!$C27-Expenses!$D27","v":{"v":22,"d":"22.00"}}]
[null,"Staff and gratuities",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C28-Expenses!$D28","v":{"v":0,"d":"0.00"}}]
[null,"Reception total",{"$f":"SUBTOTAL(109,Reception[ESTIMATED])","v":{"v":1050,"d":"1,050.00"}},{"$f":"SUBTOTAL(109,Reception[ACTUAL])","v":{"v":928,"d":"928.00"}},{"$f":"SUBTOTAL(109,Reception[OVER/UNDER])","v":{"v":122,"d":"122.00"}}]
[null,"* Excludes entertainment and decorations"]
[null,"MUSIC/ENTERTAINMENT"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Musicians for ceremony",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C33-Expenses!$D33","v":{"v":0,"d":"0.00"}}]
[null,"Band/DJ for reception",{"v":200,"d":"200.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C34-Expenses!$D34","v":{"v":200,"d":"200.00"}}]
[null,"Music/entertainment total",{"$f":"SUBTOTAL(109,Music[ESTIMATED])","v":{"v":600,"d":"600.00"}},{"$f":"SUBTOTAL(109,Music[ACTUAL])","v":{"v":400,"d":"400.00"}},{"$f":"SUBTOTAL(109,Music[OVER/UNDER])","v":{"v":200,"d":"200.00"}}]
[null,"PAINTING/STATIONERY"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Invitations",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"Expenses!$C38-Expenses!$D38","v":{"v":50,"d":"50.00"}}]
[null,"Announcements",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"Expenses!$C39-Expenses!$D39","v":{"v":25,"d":"25.00"}}]
[null,"Thank-You cards",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"Expenses!$C40-Expenses!$D40","v":{"v":0,"d":"0.00"}}]
[null,"Personal stationery",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C41-Expenses!$D41","v":{"v":0,"d":"0.00"}}]
[null,"Guest book",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C42-Expenses!$D42","v":{"v":0,"d":"0.00"}}]
[null,"Programs",{"v":75,"d":"75.00"},{"v":80,"d":"80.00"},{"$f":"Expenses!$C43-Expenses!$D43","v":{"v":-5,"d":"(5.00)"}}]
[null,"Reception napkins",{"v":35,"d":"35.00"},{"v":40,"d":"40.00"},{"$f":"Expenses!$C44-Expenses!$D44","v":{"v":-5,"d":"(5.00)"}}]
[null,"Matchbooks",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C45-Expenses!$D45","v":{"v":0,"d":"0.00"}}]
[null,"Calligraphy",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C46-Expenses!$D46","v":{"v":0,"d":"0.00"}}]
[null,"Printing /stationery total",{"$f":"SUBTOTAL(109,Printing[ESTIMATED])","v":{"v":935,"d":"935.00"}},{"$f":"SUBTOTAL(109,Printing[ACTUAL])","v":{"v":870,"d":"870.00"}},{"$f":"SUBTOTAL(109,Printing[OVER/UNDER])","v":{"v":65,"d":"65.00"}}]
[null,"PHOTOGRAPHY"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Formals",{"v":1300,"d":"1,300.00"},{"v":1300,"d":"1,300.00"},{"$f":"Expenses!$C50-Expenses!$D50","v":{"v":0,"d":"0.00"}}]
[null,"Extra prints",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C51-Expenses!$D51","v":{"v":0,"d":"0.00"}}]
[null,"Photo albums",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"Expenses!$C52-Expenses!$D52","v":{"v":0,"d":"0.00"}}]
[null,"Videography",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"Expenses!$C53-Expenses!$D53","v":{"v":50,"d":"50.00"}}]
[null,"Photography total",{"$f":"SUBTOTAL(109,Photography[ESTIMATED])","v":{"v":1625,"d":"1,625.00"}},{"$f":"SUBTOTAL(109,Photography[ACTUAL])","v":{"v":1575,"d":"1,575.00"}},{"$f":"SUBTOTAL(109,Photography[OVER/UNDER])","v":{"v":50,"d":"50.00"}}]
[null,"DECORATIONS*"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Bows for seating",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C57-Expenses!$D57","v":{"v":0,"d":"0.00"}}]
[null,"Centerpieces",{"v":300,"d":"300.00"},{"v":320,"d":"320.00"},{"$f":"Expenses!$C58-Expenses!$D58","v":{"v":-20,"d":"(20.00)"}}]
[null,"Candles",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"Expenses!$C59-Expenses!$D59","v":{"v":25,"d":"25.00"}}]
[null,"Lighting",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"Expenses!$C60-Expenses!$D60","v":{"v":25,"d":"25.00"}}]
[null,"Balloons",{"v":200,"d":"200.00"},{"v":250,"d":"250.00"},{"$f":"Expenses!$C61-Expenses!$D61","v":{"v":-50,"d":"(50.00)"}}]
[null,"Decorations total",{"$f":"SUBTOTAL(109,Decorations[ESTIMATED])","v":{"v":700,"d":"700.00"}},{"$f":"SUBTOTAL(109,Decorations[ACTUAL])","v":{"v":720,"d":"720.00"}},{"$f":"SUBTOTAL(109,Decorations[OVER/UNDER])","v":{"v":-20,"d":"(20.00)"}}]
[null,"*Excludes flowers"]
[null,"FLOWERS"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Bouquets",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"Expenses!$C66-Expenses!$D66","v":{"v":50,"d":"50.00"}}]
[null,"Boutonnières",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C67-Expenses!$D67","v":{"v":0,"d":"0.00"}}]
[null,"Corsages",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C68-Expenses!$D68","v":{"v":0,"d":"0.00"}}]
[null,"Ceremony",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C69-Expenses!$D69","v":{"v":0,"d":"0.00"}}]
[null,"Reception",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C70-Expenses!$D70","v":{"v":0,"d":"0.00"}}]
[null,"Flowers total",{"$f":"SUBTOTAL(109,Flowers[ESTIMATED])","v":{"v":900,"d":"900.00"}},{"$f":"SUBTOTAL(109,Flowers[ACTUAL])","v":{"v":850,"d":"850.00"}},{"$f":"SUBTOTAL(109,Flowers[OVER/UNDER])","v":{"v":50,"d":"50.00"}}]
[null,"GIFTS"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Attendants",{"v":1000,"d":"1,000.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C74-Expenses!$D74","v":{"v":600,"d":"600.00"}}]
[null,"Spouse-to-be 1",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"Expenses!$C75-Expenses!$D75","v":{"v":-50,"d":"(50.00)"}}]
[null,"Spouse-to-be 2",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"Expenses!$C76-Expenses!$D76","v":{"v":-50,"d":"(50.00)"}}]
[null,"Parents",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C77-Expenses!$D77","v":{"v":0,"d":"0.00"}}]
[null,"Readers/other participants",{"v":20,"d":"20.00"},{"v":250,"d":"250.00"},{"$f":"Expenses!$C78-Expenses!$D78","v":{"v":-230,"d":"(230.00)"}}]
[null,"Gifts total",{"$f":"SUBTOTAL(109,Gifts[ESTIMATED])","v":{"v":1345,"d":"1,345.00"}},{"$f":"SUBTOTAL(109,Gifts[ACTUAL])","v":{"v":1075,"d":"1,075.00"}},{"$f":"SUBTOTAL(109,Gifts[OVER/UNDER])","v":{"v":270,"d":"270.00"}}]
[null,"TRAVEL/TRANSPORTATION"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Limousines/trolleys",{"v":100,"d":"100.00"},{"v":125,"d":"125.00"},{"$f":"Expenses!$C82-Expenses!$D82","v":{"v":-25,"d":"(25.00)"}}]
[null,"Parking",{"v":0,"d":"0.00"},{"v":40,"d":"40.00"},{"$f":"Expenses!$C83-Expenses!$D83","v":{"v":-40,"d":"(40.00)"}}]
[null,"Taxis",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C84-Expenses!$D84","v":{"v":0,"d":"0.00"}}]
[null,"Travel/transportation total",{"$f":"SUBTOTAL(109,Travel[ESTIMATED])","v":{"v":100,"d":"100.00"}},{"$f":"SUBTOTAL(109,Travel[ACTUAL])","v":{"v":165,"d":"165.00"}},{"$f":"SUBTOTAL(109,Travel[OVER/UNDER])","v":{"v":-65,"d":"(65.00)"}}]
[null,"OTHER EXPENSES"]
[null,"CATEGORY","ESTIMATED","ACTUAL","OVER/UNDER"]
[null,"Officiant",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C88-Expenses!$D88","v":{"v":0,"d":"0.00"}}]
[null,"Church/ceremony site fee",{"v":40,"d":"40.00"},{"v":55,"d":"55.00"},{"$f":"Expenses!$C89-Expenses!$D89","v":{"v":-15,"d":"(15.00)"}}]
[null,"Wedding coordinator",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C90-Expenses!$D90","v":{"v":0,"d":"0.00"}}]
[null,"Rehearsal dinner",{"v":450,"d":"450.00"},{"v":450,"d":"450.00"},{"$f":"Expenses!$C91-Expenses!$D91","v":{"v":0,"d":"0.00"}}]
[null,"Engagement party",{"v":20,"d":"20.00"},{"v":50,"d":"50.00"},{"$f":"Expenses!$C92-Expenses!$D92","v":{"v":-30,"d":"(30.00)"}}]
[null,"Showers",{"v":30,"d":"30.00"},{"v":20,"d":"20.00"},{"$f":"Expenses!$C93-Expenses!$D93","v":{"v":10,"d":"10.00"}}]
[null,"Salon appointments",{"v":45,"d":"45.00"},{"v":46,"d":"46.00"},{"$f":"Expenses!$C94-Expenses!$D94","v":{"v":-1,"d":"(1.00)"}}]
[null,"Bachelor/ette parties",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C95-Expenses!$D95","v":{"v":0,"d":"0.00"}}]
[null,"Brunch",{"v":300,"d":"300.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C96-Expenses!$D96","v":{"v":-100,"d":"(100.00)"}}]
[null,"Hotel rooms",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C97-Expenses!$D97","v":{"v":0,"d":"0.00"}}]
[null,"Other expenses total",{"$f":"SUBTOTAL(109,OtherExpenses[ESTIMATED])","v":{"v":885,"d":"885.00"}},{"$f":"SUBTOTAL(109,OtherExpenses[ACTUAL])","v":{"v":1021,"d":"1,021.00"}},{"$f":"SUBTOTAL(109,OtherExpenses[OVER/UNDER])","v":{"v":-136,"d":"(136.00)"}}]