One row per invitation: adults and kids, RSVP, meal, table, gift and thank-you. Invited, responded, coming, meals per choice and what's missing for each Yes are counted. Pro adds tables with free seats, a budget with cost per head, and a timeline of tasks with what's late. No macros.
150 rows with group, RSVP and meal dropdowns, ✓ for gift and thank-you. Coming (adults + kids for a Yes); Status — Awaiting, Maybe, Declined, Meal?, Table?, Ready — with row colours. Invitations, people, responded, awaiting, coming, kids, maybes, response rate, gifts to thank; count per meal.
Seats per table from Setup, coming people assigned, free seats (red when over), full %; coming with no table yet.
Twenty items: budget, quoted, paid, to pay, vs budget (red over, green under); per head coming and invited; paid so far.
Forty tasks with due and ✓; Late, Soon, Later; late count and progress.
Event date, as-of date, groups, RSVP words, meals, tables with seats.
Eight formulas explained.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Each invitation is a row — a couple with two kids is one row with 2 and 2 — and the sheet does the arithmetic: how many people were invited, how many responded, how many are coming (adults plus kids for a Yes), how many kids, how many maybes, meals per choice, and how many gifts still need a thank-you. The Status column says what’s missing for each Yes: a meal, then a table.
The RSVP column itself is the smallest drop-down there is — two items and a colour — and the counts above it are plain COUNTIFs over that column. If you want to build the same thing from scratch, or change what the answers are called, the Yes/No drop-down guide walks through the validation and the formulas that read it.
Tables reads seats per table from Setup and the assignments from the guest list, and shows free seats per table and who’s coming with no table yet. Budget holds each item’s budget, quote and payments, flags quotes that came in over, and gives the cost per head both for those coming and for everyone invited. Timeline is the list of things to do before the day, with Late and Soon flags against today.
The build recalculates both workbooks in LibreOffice and in a second, independent engine and compares fifty values — every count in the summary, meals, statuses on the sample rows, table assignments and free seats, budget totals and per-head cost, timeline statuses — against numbers computed outside Excel.
First release
A wedding budget by category — estimated, actual, paid — with what's still to pay, over or under, and the honest budget left. Pro adds vendors with quotes, contracts, deposits and balance-due flags that feed the actuals, and a timeline whose dates follow the wedding date. No macros.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.
A task list with a Gantt chart drawn entirely by conditional formatting — no shapes, no macros. Start and end dates make the bar, Done % fills it, Blocked turns it red, a line marks this week. Pro adds a 26-week timeline, a Dashboard, Milestones and a formulas walkthrough.