Wedding Planning Bundle, Budget by Guest Count, Guest List and Dated Checklist, Excel

The budget, the guest list and the checklist in one workbook, so the guest list can feed the budget.

On the Setup tab, Guest count comes from has three choices. Typed number uses a guess while you plan. Confirmed uses the guests marked Yes on the Guests tab. Confirmed plus no reply adds everyone yet to answer. Pick one of the last two, and every per-guest, per-table and per-invitation line follows your replies.

Budget tabs: Budget has 27 starter lines and room for 60, with planned price, quoted price, minimum units, paid and next payment. Budget Summary shows the total, budget left, a table by category and the next 12 payments. Guest Count Compare shows every line at six guest counts you type.

Guest tabs: Guests holds 400 rows with household, side, RSVP, meal and table. Counts shows totals by side and meal. Seating lists names by table. No Reply lists who has not answered.

Checklist tabs: Checklist has 90 tasks dated from your wedding day. Due Soon lists what is late or next. Progress shows done and left by month, category and person.

Also included: the 11-page print PDF of the checklist, in US Letter and A4.

The Example file has a made-up wedding with all three parts filled in. The Blank file has starter lists, starter budget lines and the task list.

WHAT'S INCLUDED
- Wedding-Planning-Bundle-Example.xlsx, a made-up wedding
- Wedding-Planning-Bundle-Blank.xlsx, for your own
- Wedding-Checklist-Print-Letter.pdf, 11 pages
- Wedding-Checklist-Print-A4.pdf, 11 pages

Tabs in each workbook: Start Here, Setup, Budget Summary, Budget, Guest Count Compare, Guests, Counts, Seating, No Reply, Checklist, Due Soon, Progress. Digital download. Nothing is shipped.

COMPATIBILITY
An .xlsx workbook with ordinary formulas. No macros and no add-ins. A script recalculated it in LibreOffice 26.8 and compared the results with a separate Python calculation. Another script confirmed it uses no LAMBDA, LET, XLOOKUP or spill formulas. A script also opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation: every cell matched the values stored in the file, with no error cells. That test did not type new data into Excel or look at the screen. Excel for Windows and Google Sheets have not been tried, and the menu steps below have not been tried in Excel or Google Sheets. The PDFs are US Letter and A4. A script confirmed the fonts are embedded and the page links work, and that the ink stays at least 0.4 inches from the page edge. They have not been printed on a real printer yet.

QUESTIONS AND HOW-TO
How is this different from buying the three singly?
It is one workbook. The guest list's count can feed the budget, which the separate files can't do.

Which guest count should I use?
That is your call. Typed number suits early planning. Confirmed plus no reply shows the most you may pay for. Confirmed suits the final count.

Do invitations follow the guest list too?
Yes, once the count comes from Guests. Invitations then counts one for each household, and one for each guest with no household.

Does it include separate files for each part?
No. The three parts are tabs in one workbook. The PDF is the same one sold with the checklist.

Can two of us work in it?
In Google Sheets you can share your imported copy. Sharing there has not been tested yet. In Excel, keep one copy and pass it back and forth.

Using this file in Excel
Open the .xlsx file. If a yellow bar says Protected View, click Enable Editing.
Type only in the colored input cells. The other cells hold formulas and are locked so they don't get overwritten by accident.
The Example file has made-up entries so you can see how it fills in. Start your own work in the Blank file.
Before you type anything, use File > Save As and give the Blank file a new name. That keeps a clean copy for next time.
To change a locked cell, go to Review > Unprotect Sheet. There is no password. If you edit a formula, the totals may stop being right.

Copying this file to Google Sheets
Open Google Sheets in a browser and start a blank spreadsheet.
Go to File > Import, choose the Upload tab and select the .xlsx file.
Under Import location choose Replace spreadsheet, then click Import data.
Your copy now lives in your own Google Drive. Name it with File > Rename.
Sheets may not keep the locks from the Excel file, so type only in the colored input cells.

Print settings for this PDF
Open the PDF in Adobe Acrobat Reader or Preview, not in a browser tab. Browsers can change the scale without telling you.
In the print window, pick the paper size that matches the file name.
In Acrobat Reader, set Page Sizing to Actual Size. In Preview, set Scale to 100%. If the edges get cut off, switch to Fit in Acrobat Reader or Scale to Fit in Preview.
Print one page first and check it before you print the rest.
To print only some pages, type the numbers in the Pages box, for example 3-8.
For double-sided pages, choose flip on long edge for portrait pages.

A4 or US Letter
US Letter is 8.5 x 11 inches (216 x 279 mm). It is the usual paper in the United States and Canada.
A4 is 210 x 297 mm (8.3 x 11.7 inches). It is the usual paper in most other countries.
The paper size is in each file name. Print the one that matches the paper in your printer.
If you only have the other size, use Fit or Scale to Fit in the print window. The page will come out slightly smaller, with wider margins.

HOW AI WAS USED
AI helped write the listing text, the how-to text, the task lists and the code that builds these files. Scripts tested every part of the workbook, on 8 sets of test data, including the count coming from Typed number, Confirmed and Confirmed plus no reply, one more guest saying yes, and an empty guest list with vendor minimums still applying. A script also tested that the tasks are in both PDFs under the heading matching their timing, and that the PDFs are the same files as in the checklist listing. No person is claimed to have checked it unless stated here.

PLEASE NOTE
This file adds up what you type. Prices in the Example are made up and are not a guide to real costs. The dates are a starting point. This is a planning list, not legal advice, and it gives no financial advice. License: for your personal use only. No resale or sharing of this file.