Office Holiday Party & Gift Exchange System — Headcount Cost Planner, Secret Santa Tracker & Task Timeline Excel
Planning the office holiday party for December 2026? You have a headcount and a fixed budget. This system turns both into a full plan.
Type in your headcount, total budget, and party date. Per-person food and drink costs multiply out, due dates count back from the party date, and the gift exchange stays tracked in one place.
WHAT YOU GET
- office-holiday-party-system.xlsx — a working Excel workbook with real formulas. No macros. Works in Microsoft Excel and Google Sheets.
- office-holiday-party-system-guide.pdf — a 3-page printable guide: setup, sheet-by-sheet help, budget tips, gift exchange rules, and a day-of run sheet.
THE FIVE SHEETS
1. Start Here — four yellow input cells: headcount, total budget, party date, and gift cap. Quick answers update on the same page.
2. Cost Planner — 9 cost lines across venue, food, drinks, decor, and entertainment. Per-person lines use headcount × unit cost formulas (catered buffet $20.00 × 24 = $480.00). Flat lines charge once. SUMIF category subtotals, grand total, cost per person, and budget left.
3. Gift Exchange Organizer — 24 participants with draw status, giving-to pairing, gift cap, bought Y/N, and wrapped Y/N. % ready uses COUNTIF. This sheet tracks the draw — it does not draw names automatically. Run the draw on paper or with a free generator, then record pairings here.
4. Task Timeline — 12 tasks with owner, status, and due date computed as party date minus offset days. Book the room 28 days out, send invites 21 days out, clean up the day after.
5. Summary — one dashboard: headcount, party date, total cost, cost per person, budget, budget left, on-budget status, gift % ready, tasks % done, and the category breakdown. All cells are live formulas.
SAMPLE PRE-LOADED: 24 staff, $1,200 budget, party Friday, December 11, 2026, $25 gift cap → $1,129.00 total cost, $47.04 per person, $71.00 left, gift exchange 62.5% ready (15 of 24 bought). Change any input and every number updates.
WHY NOT A PRINTABLE? Printables give you blank totals to fill in by hand. This workbook multiplies per-person costs by your real headcount, re-dates every task when the party date moves, and counts gift readiness for you.
Instant download (.xlsx + .pdf). Digital product — no physical item ships. For one workplace party committee. Sample prices are example December 2026 US prices; type in your own quotes. Gift exchange gifts are paid by participants, not from the party budget.