« Various Tech Tricks and Tips | Main | Long Time No Blog »

December 22, 2004

Wedding Planning? Use our spreadsheet as a starter.

WeddingPlannerExample.xls

The info in the Locations and Visits tabs alone will save you days of phone calls if you are planning a Chicago downtown wedding. Contacts, contact info, capacity, price, etc. Visits tab will guide you through the standard set of questions and compute the low and high spread out-the-door total price for a given number of guests.

I generated the Guests tab by exporting my Outlook contact book, which is sync'd with my cell. If your MS Outlook installation doesn't have the Export feature installed (Rebecca's didn't), just display your contacts folder with the "Phone List" grid-like view and right click the column labels to use the Field Chooser to get what fields you need. Shift-select all contacts, Ctrl-C, and you can paste that into Excel.

I already had a lot of people's home addresses and recent contact info because Plaxo rocks and it is not spam. And it's not annoying, Alex. :)

The Guests tab:
- Displays guest count for each side by priority groupings
- Categorize friends for later table assignment
- Displays running guestcount so you can sort them by group, then priority, and see who you can afford to invite
- Can adjust for people who you will invite but have varying chances of attending for accurate estimating

Also has a checklist tab with information from a very popular wedding site.

I'm sure as we get further along in this process more tabs will get added. I know it's geek, but I think it's kind of practical-overpowers-geeknees.

Posted by Jeff at December 22, 2004 07:03 AM

Comments

I ought to get you a subscription to "Nerdular Nerdence". :)

Posted by: Kim at December 24, 2004 12:13 PM

if i am able to attain one thing in my life, it is to equal your ability to create useful pivot tables.

Posted by: blake at January 8, 2005 12:04 PM

Two comments:

1) Plaxo *is* spam (and thus by definition, annoying).

2) The spreadsheet does seem useful, but a) I hope to never need such a thing and if I did, b) I doubt it would work in Open Office, so c) I'd have to write my own solution (in python, of course).

Posted by: Alex at January 9, 2005 11:55 PM

Thanks for the spreadsheet bud. It saved me from killing my fiance.

Posted by: Matt at May 11, 2007 07:34 PM

Post a comment




Remember Me?