Wedding Planner (WIP)

Wedding Tracker — System Overview

The Wedding Tracker has evolved into a multi‑module planning engine that handles guests, seating, budgeting, payments, and calendar automation. 

Each part now works together instead of living in isolated sheets.

Below is the full breakdown of what's been built so far.

*AI was used to create a list of fake names for use in testing and proof of concept.  This is the only time it was used in this project. 

1. People & Guest Management

- Automated PeopleList Builder

- Reads your invitation table (tblInvites)

- Splits invitees + their guests

- Normalizes names

- Assigns relationship tags

- Produces a clean, structured PeopleList table

-Automatic Table & Seat Assignment

- Reads table capacities

- Fills seats sequentially

- Writes Table # and Seat # back into PeopleList

- Ensures no table exceeds capacity

This gives you a fully structured guest → table → seat mapping.

2. Seating Layout Engine (CAD‑Style)

This is the biggest technical piece — and it’s now extremely powerful.

-Full rotation‑aware seating

Tables can be rotated at any angle, and seats rotate with them.

-Supports multiple table types

- Round

- Square

- Rectangle

- Oval

- Head tables

- Cocktail tables

- Venue objects (buffet, bar, DJ, dance floor, podium, etc.)

-Perimeter seating logic

- Even spacing

- Corner margin control

- Seat offset from table edge

- Rotation transforms for every seat

-Grouped shapes

Each table + seats + labels are grouped into a single movable object.

*There is also "permanent" venue options including: Archways, doors, exits, lights, pillars, plants, beams etc.

3. Payment & Due‑Date Tracking

-PayAndDates table now feeds directly into planning calendar.

-Automated Calendar Feed

- Reads items + due dates

- Only includes rows with real dates

- Writes them to Planning Calendar!U4:V…

- Auto‑sorts by date

- Updates with one click

-Correct column mapping

- Item name = column 1

- Date required = column 4

- PAID = column 3

4. Smart Conditional Formatting (Status Colours)

-Calendar feed now visually reflects urgency:

-Yellow → within advance window (e.g., 14 days)

-Orange → within 7 days

-Red → due today or overdue

-No colour → blank or outside the window

-Strikethrough → item marked PAID in the table

All rules ignore blanks and apply only when appropriate.

5. Clean, Modular VBA Architecture:

- A PeopleList builder

- A Table/Seat assignment engine

- A Full seating layout generator

- A Calendar updater

- A Date‑urgency colour system

Each module is isolated, clean, and easy to expand.

6. What This System Now Does as a Whole

The Wedding Tracker now:

- Manages guests

- Assigns seats

- Draws a full CAD‑style seating map

- Tracks payments

- Tracks due dates

- Highlights urgent tasks

- Syncs everything into a planning calendar

- Visually marks paid items

- Keeps everything sorted and clean