Newer blog post
more in Blog
Older blog post
Newer blog post by Mrs. Stiletto
more by Mrs. Stiletto (oldest)
Older blog post by Mrs. Stiletto
Mrs. Stiletto's Picture
Mrs. Stiletto, Chicago Age and Occupation: 26, Non-Profit/Fundraising Fiance's Age and Occupation: 26, Engineer and Photographer Engagement Date: March 2, 2008 Wedding Date: September 2009 Venue: The 19th Century Club About Me: My fiance and I love living in the city of Chicago with our cats Basil and Linus, and vow to never move to the suburbs if we can possibly avoid it! We’ve poured ourselves into planning a wedding that reflects our personal style - modern and high contrast with a vintage twist. Blogging keeps me creative, baking keeps me happy, and grande nonfat no foam sugar free vanilla lattes keep me sane.
About Mrs. Stiletto

My Love Affair with Excel

February 13th, 2009 @ 10:31 am by Mrs. Stiletto

I’ll admit it, I have just the slightest addiction to Excel. It all started with a job where I claimed to have a little more Excel knowledge than I actually did. Hmm. But the white lie got me in the door and I soon became entranced with tracking everything with spreadsheets.

So just days after Mr. Stiletto and I got engaged, it came as no surprise that we already had a spreadsheet going for creating our guest list and managing details about possible reception venues. However, there was a slight twist to our spreadsheet happiness - Google Docs. While we easily maneuver within Google Docs because we have Gmail accounts, those of you who don’t can simply set up a Google account and you’ll be ready to spreadsheet.

Mr. S and I share our spreadsheets with each other, so we can both have access to them anytime, anywhere… and even at the same time! There’s even a chat feature within the document so we can chit chat back and forth as we make changes to the document. Genius!

Things started off innocently, at first. The document was simply called “Wedding Budget”. And yes, it started off that way, but it has quickly ballooned from there to a whopping 12 worksheets. Ahh!

My Love Affair with Excel :  wedding budget resources S1 s1


Snapshot of our “budget”… but not a true one, just a mish mosh of what my parents are paying for broken down into scenarios of 110 and 120 people… my and Mr. Stiletto’s budget is hidden. I’m not divulging too much information here. :)

To share with all of you planning brides, here’s a list of the worksheets I’m maintaining and accessing each and every day:

  1. Current Budget
  2. Vendor Contacts
  3. Registry Ideas
  4. Songs (reception & ceremony)
  5. Ways to Involve My Mom in Planning
  6. Quotes (from different vendors)
  7. Dates (sending invitations, RSVPs due, etc)
  8. Hotel Block Information
  9. Needs - Detail (each item of ceremony and reception that needs purchasing)
  10. Reception Timeline
  11. Random Numbers (I have no clue what this is, but it’s on there!)
  12. Vendor Payments (schedule of what is owed to whom and when)

A tad obsessive? Possibly. But it keeps things in order and maintains my sanity to some degree. It’s also great, as when we’re looking for rehearsal dinner locations I can throw a link and price quote into the spreadsheet, along with the preferred contact at that location, and I don’t have to search for the information later on.

As I’ve mentioned, I also have a spreadsheet for our wedding guest list, but we keep that separate so that we can share it with my MOH, easily providing her with contact information for everyone to be invited to the bridal shower. When we’re ready to send out save the dates and the invitations, we can easily download the document and run a merge!

Anyone else out there find a good way to manage information as they continue to plan?

Tags: budget, Resources |
advertisement below
Newer blog post
more in Blog
Older blog post
Newer blog post by Mrs. Stiletto
more by Mrs. Stiletto (oldest)
Older blog post by Mrs. Stiletto

38 Responses to “My Love Affair with Excel”

1 2 

1.
Bee Icon
Bee
Miss Piglet (message)  1,045 posts, Bumble bee

Like you, Miss S, I’m in love with Google spreadsheets. We started off using an Excel file, but quickly encountered the version control issues. We even use Google Docs as our contract repository. :)

 
2.
Bee Icon
Bee
Miss D'orsay (message)  2,272 posts, Buzzing bee

We rock out with google docs as well :)

 
3.
Guest Icon
Guest
ali

i heart Excel! but what is this about google docs!? i can’t believe i’ve been missing out!

 
4.
Member Icon
Member
lavenderpug (message)  284 posts, Helper bee

my sheets don’t look nearly as organized and neat as yours, but yes, loving the google docs. thanks for the helpful suggestions for more sheets i can add!
has anyone used the google docs template for wedding planning?

 
5.
Bee Icon
Bee
Miss Bruschetta (message)  5,565 posts, Bee Keeper

Mr. MagPie and I share a Gmail account for wedding planning purposes, and have a TON of Gdocs — everything from the dreaded budget to must-play songs!

 
6.
Member Icon
Member
West Coast Bride (message)  708 posts, Busy bee

Our excel-based wedding workbook is a god send to me too, although I don’t have quite as many spreadsheets as you….We have one that’s our main budget, and we just use separate columns to track the accepted quote, the amount paid to day and then we have a handy dandy column that I check almost every day called “wedding day balance” so at a glance I know how much I’m going to be kissing goodbye into vendor envelopes the night before the wedding. Our additional spreadsheets are so we can track the details of the expenses and purchases. For example, we’re renting a luxury B and B for family and the wedding party to stay in if they choose, and are asking them to kick in a small portion, so I have a spreadsheet tracking who’s confirmed as staying there, and who has paid. Sigh. I heart my spreadsheets

 
7.
purpleHaze79
Member
purpleHaze79 (message)  874 posts, Busy bee

Thank you for this post! I need to explore Google docs!!

 
8.
Bee Icon
Bee
Mrs. Pinot Noir (message)  799 posts, Busy bee

I heart google docs! It was a wedding lifesaver!

 
9.
Bee Icon
Bee
Miss Kitten (message)  868 posts, Busy bee

Our wedding website, Weddingwindow, has behind the scenes worksheets like this, so I’ve been using that. But we use Google docs for any non-wedding organizing!

 
10.
Guest Icon
Guest
IronMaiden

Ahhh Google Docs — I raved about them so much I converted my entire workplace to using them! FI and I use the calendar feature daily — we constantly update our schedules so we know when we’ve got things planned and never have to say “I have to check with him/her” before making plans. The FI loves that!

 
11.
Bee Icon
Bee
Miss Quiche (message)  3,157 posts, Sugar bee

Yep! Google Docs!! :)

 
12.
IronMaiden
Member
IronMaiden (message)  121 posts, Blushing bee

Crap I wasn’t signed it. Oh well. Go Google Docs!

 
13.
Bee Icon
Bee
Miss Peep Toe (message)  1,804 posts, Buzzing bee

Love me my excel, and now I think I should upload my sheets to google docs!

 
14.
LzzNYC
Member
LzzNYC (message)  882 posts, Busy bee

I love google and I love excel so I’m on your boat =)

 
15.
LatteLove
Hostess
LatteLove (message)  5,587 posts, Bee Keeper

I recently started a thread about how people keep track of money!

check it out here:
http://boards.weddingbee.com/topic/how-do-you-keep-track-of-your-moneybudget

 
16.
Mrs. Hydrangea
Bee
Mrs. Hydrangea (message)  414 posts, Helper bee

I swore by Excel and Google Docs for the wedding! I use Excel for everything now. Like you, my job forced me to learn Excel better and I’m so glad that it did!

 
17.
Bee Icon
Bee
Miss Duckling (message)  1,415 posts, Bumble bee

Google Docs are awesome, we use them all the time at work.

 
18.
Miss Burgundy
Hostess
Miss Burgundy (message)  1,426 posts, Bumble bee

omg Miss Stiletto, this is SO super helpful to me! I knew I had to make spreadsheets and this is a great way to organize so much wedding information together! Thank you for sharing this:)

 
19.
Bee Icon
Bee
Miss Oyster (message)  879 posts, Busy bee

This is awesome! I love my spreadsheets. So glad I’m not the only one!

 
20.
Guest Icon
Guest
notsojenny

yes, i’m a spreadsheet lover also… okay, maybe a spreadsheet compulsive. i love doing the timeline in excel… just plugging in one time and having everything else run backwards off of that

 
1 2 

Leave a Reply


You can also just...

Newer blog post
more in Blog
Older blog post
Newer blog post by Mrs. Stiletto
more by Mrs. Stiletto (oldest)
Older blog post by Mrs. Stiletto

Visit our sister sites eHarmony
Online Dating
eHarmony Advice
Dating Advice
Project Wedding
Wedding Songs
JustMommies
Pregnancy Calendar

Copyright 2004-2012, Weddingbee.com
 

Find your vendors on Weddingbee

Real reviews from brides in your area!

Favors by Weddingbee

  • Favors by season

Shop Now »

Mrs. Stiletto
Mrs. Stiletto

Mrs. Stiletto, Chicago Age and Occupation: 26, Non-Profit/Fundraising Fiance's Age and Occupation: 26, Engineer and Photographer Engagement Date: March 2, 2008 Wedding Date: September 2009 Venue: The 19th Century Club About Me: My fiance and I love living in the city of Chicago with our cats Basil and Linus, and vow to never move to the suburbs if we can possibly avoid it! We’ve poured ourselves into planning a wedding that reflects our personal style - modern and high contrast with a vintage twist. Blogging keeps me creative, baking keeps me happy, and grande nonfat no foam sugar free vanilla lattes keep me sane.

Boards
Classifieds

Blog Calendar
February 2012
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
26272829

Weddingbee Bios
Wiki
More