Empecemos.
Wedding & Event Planner 100 Pro — Getting Started & Help Guide
Wedding & Event Planner 100 Pro — Getting Started & Help Guide
Thank you for your purchase! This guide will walk you through everything you need to know to get the most out of your Wedding & Event Planner 100 Pro.
No spreadsheet experience required. If you can fill in a table and pick from a dropdown, you can run every client's event from this planner.
1. Before You Begin
What You Need
- Microsoft Excel 365 or Excel 2024 for Windows (the desktop app)
Opening the File
- Download the file from your Etsy Purchases page (etsy.com/your/purchases).
- If the download is a .zip, unzip/extract the .xlsx file first.
- Open it in Excel. If you see a yellow "Protected View" bar, click "Enable Editing."
Activate Your Planner
The planner unlocks with your Etsy order number. Until it's activated, you'll see a message saying "This product has expired" and the views stay locked. This is normal. Go to the Help tab and follow the 3 steps:
- Step 1 — Enter your Etsy order number in the box next to "1. Enter your Etsy order number."
- Step 2 — Click "Click here to get an Activation Code." Your browser opens our activation page with your order number already filled in. Copy the code it gives you.
- Step 3 — Paste the code in the box next to "3. Enter your activation code." The status changes to Activated, and every view unlocks.
Stuck? Click "Click here for Activation Help" on the Help tab, or visit bobcatplanners.com/activation.
Make a Backup First
Before you start entering your events, save a clean copy of the original file somewhere safe. That way, if anything goes wrong, you can always start fresh.
2. Quick Start — Be Up and Running in 10 Minutes
Follow these 5 steps in order and you'll have a working planner quickly. The file comes with a sample wedding (Emma & Noah Wedding) so you can see how everything fits together. Overwrite it with your own event when you're ready.
- Step 1 — Help tab. Activate the planner with your Etsy order number (see Section 1).
- Step 2 — Settings tab. Under Team, list everyone who works on your events: your planners, assistants, day-of coordinators and the vendors you book (florist, photographer, caterer, DJ). These names fill the "Assigned To" and "Lead Planner" dropdowns.
- Step 3 — Manage tab. Give each event a name, start and end dates, a timeline color and a lead planner. Add the client's details, the venue and guest count, the client's event budget, any budget changes and your planner fee.
- Step 4 — Event sheets (Event 1, Event 2…). Click the ➤ arrow next to an event on the Manage tab to jump to its sheet. List the tasks with their status, priority, stage, dates, team member or vendor, budget and actual cost.
- Step 5 — Overview tab. Select an event from the dropdown at the top. Your dashboard now shows its progress, schedule and budget.
As you book vendors, add them on the Vendors tab with their contract, deposit and due dates. Add invitations and RSVPs on the Guest List tab. Closer to the day, build the schedule on the Run of Show tab.
That's it! The rest of this guide explains every feature in detail.
3. Sheet-by-Sheet Guide
3A. Settings Tab
The Settings tab is where you personalize the planner. You'll mostly visit it during setup.
Team (column B, from row 10)
- Your master list of people: planners, assistants, day-of coordinators, vendors, even the client.
- These names appear as dropdowns in each event sheet's "Assigned To" column and in Manage's "Lead Planner" column.
- Room for up to 100 names. Leave no blank rows in the middle of the list, or the dropdown may show gaps.
- Example entries: Olivia, Grace, Mia, Bloom & Vine Florals, Golden Hour Photo, Savor Catering, Client.
Status (column D) and Priority (column F)
- The default statuses are Not started, In progress, On hold, Blocked, Canceled and Completed. The default priorities are P1 to P4.
- You can customize them, but the colors and the Kanban Preferences below are built around the defaults, so we recommend keeping them.
Kanban Preferences (columns H and J)
- Yes/No switches for how tasks are highlighted, for example "Set Late tasks font to red" or "Highlight Blocked tasks in red."
General (columns L and N)
- Date regional format: the language used for dates.
- Calculate completion by status or progress: "Status" counts a task as done when it's Completed. "Progress" uses the % in each task's Progress column.
- Timeline starting year: the year the Timeline and Task Timeline start from (January 1).
- Highlight weekends on Timeline, Show only Active tasks on Timeline and Show only Active tasks on Calendar: Yes/No switches.
Status board Card and Stage board Card
- Choose which task details appear on each board card, and in what order, by matching column header names (for example Task, End Date, Late, Progress, Priority, Assigned To, Labels).
3B. Manage Tab
The Manage tab is your list of all 100 events. Each row belongs to one event sheet.
- HARDCODED NAME (column B, hidden): The planner's internal key for the event sheet this row belongs to: Project 1 is the Event 1 tab, Project 2 is Event 2, and so on. Don't change this column.
- EVENT NAME (column C): The name you want to see everywhere, e.g. "Harper & Liam Wedding" or "Brightline Holiday Gala." Up to 31 characters.
- LINK (column D): Click the ➤ arrow to jump straight to that event's sheet.
- START DATE and END DATE (columns E and F): When planning starts and the day of the event (or wrap-up). They drive the Timeline and the "Days left" and "Timeline Progress" figures.
- TIMELINE COLOR (column G): Pick the color for this event's bar on the Timeline.
- LEAD PLANNER (column H): Select from the dropdown (your Team list from Settings). It appears on the event sheet and the Overview as "Lead planner."
- EVENT BUDGET (column I): The client's total budget for the event.
- BUDGET CHANGES (column J): Increases or cuts the client approves along the way. Use a negative number for a cut.
- PAID TO VENDORS (column K): Fills in by itself: it adds up the "Paid to Date" of every vendor for this event on the Vendors tab. If you'd rather not use the Vendors tab, type a total over it.
- CLIENT, CLIENT PHONE and CLIENT EMAIL (columns L to N): Who you're planning for and how to reach them.
- VENUE and GUESTS (columns O and P): They appear at the top of the event's Run of Show.
- PLANNER FEE and FEE PAID (columns Q and R): Your own fee for the event and what the client has paid you so far. The three tiles next to the Events card add them up across all events: your fees, fees received and fees still owed to you.
Leave the budget columns blank for events you don't want to track money for. Everything else still works.
3C. Event Sheets (Event 1 to Event 100)
Each event has its own sheet with a task table of up to 96 tasks. The header shows the event's lead planner and dates from the Manage tab, and an Event Notes box holds anything you want to write down.
- TASK (column B): What needs doing, e.g. "Venue tours & booking" or "Final vendor confirmations."
- STATUS (column C): Select from the dropdown. See Section 5.
- PRIORITY (column D): P1 (most urgent) to P4.
- STAGE (column E): The planning stage the task belongs to, e.g. Vendor booking or Final details. See Section 7.
- START DATE and END DATE (columns F and G): When the task starts and when it's due.
- ASSIGNED TO (column H): Who's doing it: a team member or a vendor. Select from your Team list.
- BUDGET (column I): What this item is expected to cost, e.g. the florist's quote.
- ACTUAL COST (column J): What it actually costs. Update it as invoices come in.
- PROGRESS (column K): How far along the task is, from 0% to 100%.
- LABELS (column L): Optional free-text tags, e.g. "Venue," "Florals," "Catering."
- NOTES (column M): Optional notes for your reference.
- LATE (column N — calculated automatically): You do NOT type in this column. It shows ⚠ when the end date has passed and the task isn't Completed or Canceled.
3D. Overview Tab (Your Dashboard)
The Overview tab is your command center. Everything here is calculated automatically. The only thing you choose is which event to view.
The Event Selector (the dropdown at the top)
- Pick any event and every tile, chart and progress ring updates instantly.
- Click the ➤ button next to it to jump straight to that event's sheet.
Welcome and Total counts (left side) — today's date plus counts across all your events: active events, completed events, late events, events with at least 1 task, the budgets you manage across all events, and what's left to pay across all events.
The event panel (top middle) — for the selected event: lead planner and dates, overall progress, total tasks, active tasks, days left, high-priority tasks, a count per status, the total budget against the total spent, and how far through its timeline the event is.
Event budget (bottom middle) — for the selected event:
- Total event budget: the event budget plus budget changes.
- Budget remaining, with the % left.
- Left to pay: what hasn't been paid to vendors yet.
- Budget vs actual by stage: a bar chart comparing what was budgeted with what's been spent, stage by stage.
See Section 4 for exactly how these are calculated.
Task list (right side) — the selected event's tasks with their status and priority colors.
Timeline (bottom) — every event's bar against the calendar, with today highlighted.
3E. Timeline and Task Timeline Tabs
Timeline — a Gantt chart of all your events, one row per event, using the dates and colors from the Manage tab.
- Select Timeframe: Daily, Monthly or Quarterly.
- The timeline starts on January 1 of the "Timeline starting year" in Settings.
Task Timeline — a Gantt chart of individual tasks, with bars that fill based on task progress.
- Select Timeframe: Daily, Monthly or Quarterly.
- Select Team member: show everyone, or just one person's or vendor's tasks.
- Select Event: show one event, or "All" to see every task from every event.
- The panel at the top shows the task count, progress, days left and late tasks for your selection.
3F. Taskline Tab
The Taskline shows every task from all 100 events in one clean list: task, event, status, priority, stage, dates, team member, budget, actual cost, progress, labels and late flag.
- Use the filters above the list to show certain statuses only, or one team member's tasks.
- Click the ➤ arrow on any row to jump to that task's event sheet.
- The Taskline is read-only. Edit tasks on their event sheet, and the Taskline updates automatically.
3G. Status Board and Stage Board Tabs
Both boards show your tasks as cards in columns, like a kanban board.
Status Board — one column per status (Not started, In progress, On hold, Blocked, Canceled, Completed).
- Select Team member and Select Event (or "All") filter the cards. The ➤ button jumps to the selected event's sheet.
Stage Board — one column per planning stage, from Discovery & contract to Event day & wrap-up.
- Status filter, Select Team member and Select Event filter the cards.
Both boards show a summary at the top (task count, progress, days left, late tasks). Choose what each card shows on the Settings tab (see 3A).
3H. Calendar Tab
The Calendar shows your tasks month by month.
- Select Month and Select Year choose the month to show.
- Select Team member and Select Event (or "All") filter the tasks. Handy for planning one coordinator's busy season.
- Set "Show only Active tasks on Calendar" in Settings to hide finished work.
3I. Vendors Tab
One table for the vendors of all your events. Add a row for each vendor you book.
- You enter: the Event (dropdown), Vendor, Category (dropdown), Contact, Phone, Email, Contract (the total agreed), Deposit, Deposit Due, Final Due, Paid to Date and any Notes.
- The planner works out: Still to Pay, the Next Due date (the deposit's date until the deposit is paid, then the final due date), the Amount Due on that date, Days Left and a Status.
- Status: Paid (nothing left to pay), Due soon (the next payment is due within 14 days), Overdue (its due date has passed) or Scheduled.
- The tiles at the top show Contracted, Paid, Still to pay, Due in 30 days, Overdue and the number of vendors. They follow the table's filter: filter the Event column to one event, or the Status column to Overdue, and the tiles show just those rows.
- Each event's Paid to Vendors on the Manage tab adds up this table, so a payment is entered once.
- Add more rows by typing in the row just below the table: it grows by itself and keeps its formulas and dropdowns.
3J. Run of Show Tab
Your day-of schedule for any event, ready to print or share with vendors.
- Select Event: pick an event and the schedule on the left shows its items, sorted by day and start time, with the length of each. The tiles at the top show the event day, venue, guests and client from the Manage tab.
- Adding items: use the table on the right (one table for all events). Pick the Event, enter the Start and End times (for example 3:30 PM), the Item, Details, Location, Who and a Contact number.
- Day: leave it blank for the event day (the event's End Date on the Manage tab). Enter a date for anything on another day, such as the rehearsal the evening before.
- Printing: the print area is set to the schedule on the left, in landscape, one page wide. Choose File > Print.
3K. Guest List Tab
Invitations, RSVPs, meals and tables for every event, in one table.
- One row per invitation: pick the Event, then enter the Guest (a person, a couple or a family), a Group (such as the couple's families, friends or work) and how many people are Invited.
- RSVP: choose Attending, Awaiting or Declined. A blank RSVP counts as awaiting a reply. If fewer people are coming than were invited, enter the number in Coming; leave it blank when everyone is coming.
- Seats: calculated. It's the number coming for an Attending invitation and 0 otherwise.
- Meal, Dietary Needs and Table: pick the meal from the list or type your own menu's choice, note any allergies or dietary needs, and enter the table number or name.
- The totals at the top: invitations, guests invited, attending, awaiting reply, declined and seated. They follow the table's filter, so filter the Event column to see one event. Filter Meal as well to get the caterer's count for each meal, or filter Table to see who sits where and how many seats each table has.
3L. Panorama, Home, Whiteboard and Studio Tabs
Panorama — a bird's-eye view of all your events: how many are active, completed and not started, your most active events and busiest team member, plus automatic Insights and Warnings (late events, events over budget, blockers, upcoming due dates).
Home — a menu of every view. Click a tile to go there. Every sheet also has a menu bar at the top for moving between views.
Whiteboard — a free space for sketches, floor plans and notes. Use Excel's Draw tab for pen tools, or the Insert tab for shapes and text boxes.
Studio — optional. Export your event data to Bobcat Studio (studio.bobcatplanners.com) to build dashboards and timelines in your browser, then save them as images. Follow the 3 steps on the tab.
4. Understanding Event Budgets
Event budgets use the three budget columns on the Manage tab (Event Budget, Budget Changes, Paid to Vendors) plus the Budget and Actual Cost of every task on the event sheet. Here's exactly how each figure is calculated:
- TOTAL EVENT BUDGET: What the client has to spend, including approved changes.
- FORECAST COST: What the event is expected to cost by the end. Completed and Canceled tasks count at their actual cost. Open tasks count at their budget, or at their actual cost once that's higher (so an over-budget item is never under-counted).
- BUDGET REMAINING: What's left after everything planned is paid for.
- % LEFT: Budget remaining as a percentage of the total event budget.
- LEFT TO PAY: What hasn't been paid to vendors yet.
Tip: give every vendor task a budget as soon as you have a quote. Tasks with no budget and no actual cost count as $0 and make the budget remaining look higher than it is.
5. Understanding Statuses & Priorities
Every task has a status you choose from the dropdown. The boards, dashboard and colors all follow it.
- ⚪ NOT STARTED: Planned but not begun.
- 🔵 IN PROGRESS: Work is underway.
- 🟡 ON HOLD: Paused, e.g. waiting on the client's color choice or a vendor's quote.
- 🔴 BLOCKED: Can't continue until something is fixed, e.g. the hotel needs a final room count. Blockers are flagged on the Panorama tab.
- 🟤 CANCELED: Dropped from the event. It counts at its actual cost in the budget and is never marked late.
- 🟢 COMPLETED: Done. It counts at its actual cost in the budget.
Priorities
- 🔴 P1: Most urgent, e.g. contracts and venue booking that everything else depends on.
- 🟠 P2: High.
- 🔵 P3: Normal.
- 🟣 P4: Low, e.g. nice-to-haves.
Late ⚠ is automatic: any task past its end date that isn't Completed or Canceled.
6. Switching Between Events
Most views have a "Select Event" dropdown. It's the most important control in the planner.
How to use it
- Click the cell with the dropdown (Overview, Status Board, Stage Board, Task Timeline or Calendar).
- Choose any event name to see just that event.
- Choose "All" (where offered) to see every event at once.
- Many views also have a "Select Team member" dropdown, so you can see one person's or vendor's work.
What changes when you switch
- Every number, card and bar in that view updates for the selected event.
What stays the same
- All your data. Switching events never changes any of your entries. It only changes what's displayed.
Practical uses
- Pick an event on the Overview before a client meeting to see its progress, budget remaining and what's left to pay.
- Pick a coordinator on the Calendar to plan their weekend.
- Pick "All" on the Status Board for a Monday-morning look at everything that's blocked or on hold.
7. Planning Stages
Stages group an event's tasks into the steps of planning it. The planner comes with 7:
Where stages show up
- The Stage column on every event sheet (a dropdown).
- The Stage Board, with one column of cards per stage.
- The "Budget vs actual by stage" chart on the Overview.
Renaming a stage
- Go to the Stage Board tab.
- Type the new name over the stage's column header (e.g. change "Guests & logistics" to "Travel & logistics").
- The new name flows through to the dropdowns and the chart automatically.
Tasks you haven't given a stage yet are treated as backlog: work that isn't assigned to a stage.
8. Tips & Best Practices
- ✨ Set up your team and vendors first: The Assigned To and Lead Planner dropdowns come from the Team list on Settings. Add your planners and regular vendors before you enter tasks.
- ✨ Budget every vendor task: Enter the quote as the task's budget as soon as you have it. Budget remaining and the budget-vs-actual chart are only as good as the budgets you enter.
- ✨ Update actual costs and payments weekly: Enter invoices as actual costs, and add every deposit or installment to Paid to Vendors on the Manage tab.
- ✨ Log budget changes right away: Add them to the Budget Changes column on Manage the day the client approves them, so the total and the remaining budget are always right.
- ✨ Use stages consistently: Give every task a stage. The Stage Board and the budget-by-stage chart then show exactly where each event stands.
- ✨ Don't delete finished tasks: Mark them Completed instead. They keep counting toward the event's actual cost and progress.
- ✨ Start a new year: Change the "Timeline starting year" in Settings so the timelines start in the right year.
9. Frequently Asked Questions (FAQ)
Setup & Getting Started
Q: I opened the file and it says "This product has expired." Is it broken?
A: Not at all. The planner just hasn't been activated yet. Go to the Help tab and follow the 3 activation steps in Section 1. It takes about a minute.
Q: Some cells show zeros or are empty. Is that normal?
A: Yes. The formulas are waiting for your data. Once you add events on the Manage tab and tasks on the event sheets, the dashboards fill in.
Q: Is there a guest list, RSVP or seating chart?
A: Yes, there's a guest list with RSVPs: the Guest List tab holds every event's invitations, RSVPs, meals, dietary needs and tables (see 3K). Seating is by table number. There's no drag-and-drop seating chart, but filtering the Table column shows who sits at each table and how many seats it has.
Q: Can I rename the tabs?
A: Yes, an event sheet's tab can carry the event's name. Use exactly the name from the Event Name column on the Manage tab (for example "Emma & Noah Wedding"), and every ➤ link in the planner will still take you there. The calculations don't depend on tab names. Leave the other tabs (Manage, Overview, Vendors and so on) as they are.
Q: Can I add more rows to an event?
A: Each event sheet holds up to 96 tasks, which covers even large weddings. Please don't extend the tables, because the boards, timelines and Taskline expect that size. If you genuinely need more, split the event into two (e.g. "Chen Wedding – Ceremony" and "Chen Wedding – Reception") or contact us.
Q: Can I add new columns or sheets?
A: You can add new sheets for your own notes without any issue. Adding columns inside the existing tables is not recommended, as it may shift formula references.
Q: I plan more than 100 events a year. What do I do?
A: Reuse the rows of finished events: once an event is wrapped up and paid, save a copy of the file as your archive, then clear that event's tasks and give the row a new event.
Data Entry
Q: The Assigned To or Lead Planner dropdown is empty. What do I do?
A: Add your team and vendors on the Settings tab first (Team, column B). The names then appear in the dropdowns automatically.
Q: Where do I enter the client's budget and vendor payments?
A: On the Manage tab: Event Budget for the client's total, Budget Changes for approved increases or cuts, and Paid to Vendors for everything paid so far. Each vendor's quote and invoice go on the event sheet as that task's Budget and Actual Cost.
Q: Can I track my own planning fee?
A: The budget section tracks the client's event budget. To keep an eye on your fee, add a task such as "Planning fee – final payment" with its due date, so it shows on your timelines and calendar.
Q: What currency does the planner use?
A: Amounts are shown with a $ sign, but the math works the same in any currency. Just enter all your amounts in the currency you work in.
Q: How do I remove a task?
A: Select the task's cells in the table and press Delete to clear them. If the task was dropped from the event, you can mark it Canceled instead to keep a record.
Calculations & Numbers
Q: Why is the budget remaining lower than budget minus what's been spent?
A: Because it also counts the budget of every task that's still open. That's what the event is still going to cost. See Section 4.
Q: The budget remaining looks too high.
A: Check that every vendor task has a budget. Tasks with no budget and no actual cost count as $0. Also check that Budget Changes on the Manage tab only holds approved changes.
Q: The event's progress doesn't match what I expected.
A: Check the "Calculate completion by status or progress" setting on the Settings tab. With "Status," only Completed tasks count as done. With "Progress," the % in each task's Progress column is used.
Q: An event doesn't show on the Timeline.
A: Make sure it has a start and end date on the Manage tab, and that those dates fall within the Timeline's year (set by "Timeline starting year" in Settings). If "Show only Active tasks on Timeline" is set to Yes, finished work is hidden.
Technical Questions
Q: Excel is slow when I choose "All."
A: Showing every task from every event is a lot of work for Excel. Filter to one event or one team member, and close other large workbooks while you use the planner.
Q: Can I use this on my phone or tablet?
A: The planner is designed for a widescreen laptop or desktop with Excel for Windows. The Excel mobile apps haven't been tested, so use a computer for the best experience.
Q: Can my assistant and I both use it?
A: Yes, within your business. We recommend one person editing at a time: keep the file in a shared folder (e.g. OneDrive) and close it when you're done so the next person gets your changes.
Q: Is my data private? Does anything get sent anywhere?
A: Your events, tasks, budgets and client details stay in the file on your computer. We have no access to them. The only thing the planner sends is a licence check: your Etsy order number, the product name and its version go to bobcatplanners.com to confirm your activation. Studio only receives data if you choose to copy it there yourself.
Q: Will this file work in Google Sheets, Apple Numbers or LibreOffice?
A: No. These applications don't support the advanced Excel functions (LET, LAMBDA, MAP, VSTACK) used in this planner, so most views won't work.
Purchases & Updates
Q: I bought this. Can I share it with my team or other planners?
A: Your purchase is licensed for use within your own business. Please do not distribute, resell, or share it publicly. It takes a lot of work to build and maintain these tools.
Q: Will I get updates if you improve the planner?
A: If significant improvements are made, we'll release an updated version. Etsy doesn't automatically push updates, but we'll note major updates in the listing. Feel free to message us through Etsy if you have questions about the latest version.
Q: Something isn't working as expected. How do I get help?
A: Send us a message through Etsy with a description of the issue. Include which tab you're on, what you entered, and what you expected to see versus what you're seeing. We're happy to help.
Q: Can you add a feature I'd like?
A: We love feedback! Send us a message with your idea. While we can't promise every request, customer suggestions directly influence what we build in future versions.
Thank you for using the Wedding & Event Planner 100 Pro. We hope it helps you plan every event and track every budget.