(Closed) Spreadsheet KWEEN

posted 5 years ago in Technology
Post # 3
Member
529 posts
Busy bee
  • Wedding: January 2013

@chronicwhimsy:  I’m also doing a spreadsheet for the guest list and the budget. My spreadsheet on the budget has helped me a lot. On it I have how much I owe and how much I have spent. It’s vety helpful.

Post # 4
Member
3769 posts
Honey bee
  • Wedding: February 2013

My FI is the spreadsheet king, and we have one for guest list, budget vs actual costs, and one that calculates how much booze we need based on guest count. I love him.

Post # 5
Member
993 posts
Busy bee
  • Wedding: May 2013

I get you!  I’m a project manager, so I started spreadsheeting and scheduling my wedding like it was a construction project.  Same principles…

Just be careful because reality and spreadsheets do not always coincide.  I feel like I wasted some of my time.  I understand feeling the need to get on it though!  Its great to have pictures of dresses you like, and decor, colours etc.  I would work on this.  Sometimes you can’t find what you want so its a bit disappointing.  As far as budget – until you actually start booking and talking to vendors you don’t have a ton to work with.  I think its great, and fun, but just a word of warning that I didn’t look at my spreadsheets and completely re-did everything a couple weeks into shopping and booking things.

What you might do is make a list of everything you need broken down to the tiny details, then start planning the order to do things in and how you’re going to attack once you get going.

Have fun!

Post # 6
Member
2273 posts
Buzzing bee

Can’t say I’ve started this stuff yet. I still need to worry about moving out and becoming independent (Besides we’ve got 2 years)

However, I’m posting here so I can follow along. I LOVE spreadsheets. It’s how I kept track of my individual grades and total GPA in college. How I keep track of my to-do lists, and generally how I keep track of LIFE.

Go you fellow spreadsheet kween! 

Also, I’d love some ideas on how you’re organizing the spreadsheets. I get the guestlist one but I don’t even know how to decide on a budget. I’ve never done anything like that before.

Sooo.. I’ll be lurking through here trying to figure that out! 

Post # 8
Member
141 posts
Blushing bee
  • Wedding: September 2013

I downloaded several spreadsheets from Google weddings and am also using an Access database.  Google Weddings has a great feature where you can make an email form for people you plan to invite and when they fill it out the information goes right into your spreadsheet. I love it.  They also have great budgeting templates. 

The caution of course is to find one tool you like, whether it’s an iPhone or androidAndroid app, database or spreadsheet workbook and use it exclusively so your data isn’t spread out all over the place. Lots of wedding websites have cloud planning tools as well which is great because both you and your FI can access them and you don’t have to worry about losing the data if your device crashes. 

Post # 9
Member
10456 posts
Sugar Beekeeper
  • Wedding: February 2014

@chronicwhimsy:  ooooh I had so many spreadsheets when I started! I freaking love Excel. 

Post # 10
Member
1375 posts
Bumble bee
  • Wedding: September 2012

I had a master google doc spreadsheet to manage guests, gifts, responses, etc.  I had separate columns for:

Guest # (we gave each household a number to track their response in case of illegible responses)

Guest names

Address

Shower invite y/n

Party total

Names as they appeard on response card (for escort card purposes)

Rehearsal dinner total

Wedding gift (which I bolded once the thank you was sent)

Post # 11
Member
1030 posts
Bumble bee

Oh my god I’m the spreadsheet QUEEN! I am just commenting now so I can come back to this tomorrow when i’m on my computer. I have LOTS of tips! Woo!

Post # 13
Member
11242 posts
Sugar Beekeeper
  • Wedding: August 2013

@futuremrsfitz18:  YES. 

I have two set up in Google Docs (accessible from anywhere, even my phone, and it autosaves): one for a guestlist, one for cost.

Guestlist:
Name(s)
Address
Invite # (will be written on the RSVP card)
# Invited
# RSVP
Gift (for thank you cards) 

Then I have a column that adds up the total number invited, total number RSVP, and the total number of kids invited/kids RSVP.

My cost sheet isn’t very involved. I have a column for each expense, the total cost, how much has been paid, and then how much is left. Subtotal column is for the running total, and then the total is how much FI and I are paying. I also have a breakdown of the payment schedule for the reception venue.

The topic ‘Spreadsheet KWEEN’ is closed to new replies.

Get our weekly roundup of the best of Weddingbee.
I agree to receive emails from the site. I can withdraw my consent at any time by unsubscribing.

Find Amazing Vendors