RSVP Spreadsheet Tracker

Re: RSVP Spreadsheet Tracker

• lauren123455 member

  

  July 2012

  I just formatted my own.  We had columns titled: "Guest Name" "# Invited" "# Accepted" "# Decline" "# Steak" "# Fish" "# Veg" and "Entree Notes" (where we put Sally - steak; Jimmy - fish, etc).
  
  If you begin the column titles on Row 2, you can insert "sum" functions in row 1 to tally the column totals for the # invited, accepted, declined, each entree. That you can quickly see, for example, that you've invited 200 guests and have heard yes from 100 and no from 20 and quickly do the math to determine how many are outstanding.  HTH!

  

  Report0 Reply
• [Deleted User] member

  

  July 2012

  Thanks, Lauren, sounds like you're good with Excel! I'll have to do some work

  Report0 Reply
• lauren123455 member

  

  July 2012

  Ha, I'm not that good.  It's really easy once you figure it out.   Let's say you put the guests names in column A - i.e. Mr. and Mrs. Smith., so the # invited column is B.  B:1 will initially be empty, B:2 will have the title "# Invited" and B:3 on downward will have numerals filled in.  When you get done filling in how many people were invited from each family, let's say you're down to row 24.  In cell B:1 (above the title) type =Sum(B:3-B:24).  Once you hit enter, that will tell you the total number of guests you've entered. 
  
  If you do # Accepted in Column C, then the formula for the total would be =Sum(C:3-C:24), and so on for the other ones.  

  

  Report0 Reply
• emeejeeayen member

  

  July 2012 edited July 2012

  Use google docs if anyone else is helping. So much easier to keep track of. 

  
  

  I like to have a master list where I check off if someone is attending OR not attending, and then 2 other tabs/sheets (down at the bottom it usually says Sheet 1, Sheet 2, Sheet 3, when you start the doc, so rename them), one for ATTENDING; one for NOT ATTENDING. That way you can look at the entire guest list to see who has responded and who has not, or just look at the attending/not attending to get a quick sense of things. 

  
  

  When you create the excel, it's typically helpful to put phone numbers and emails in with the names so that you can make phone calls or emails if needed just from that sheet. Also, I would do a column for first name and a column for last name so that you can easily sort to find people. 

  
  

  Accross the top of the main guest list I would have the following headers (in A-Z order):

  -First

  -Last

  -# invited

  -Guest First (where applicable)

  -Guest Last (where applicable)

  -Phone

  -Email

  -# attending

  -# RSVP'd

  
  

  (So if they said YES for 2 people, I'd put "2" in attending and "2" in RSVP'd; if they said NO, I would put 0 in attending and 2 in RSVP'd.) 

  
  

  I also like to bold and highlight the header row in a different color so it stands out and is easy to see. Just me though. It also helps if you add grid lines but just for visibility.

  
  

  Like Lauren said, make sure you do sums down at the bottom.

  whatshouldwecallweddings.tumblr.com

  Report0 Reply
• AMISSA31

  

  July 2012

  I also formatted my own.  I had to get the hang of it but it's done!  I didn't trust TK because things are deleted/missing often. 

  

  Report0 Reply
• libby2483 member

  

  July 2012

  I formatted my own as well.  I have the following categories: 

  -last name

  -first name

  -household

  -guest name (if applicable)

  -address

  -yes/no attending

  -meal selection

  -gift

  -thank you sent.

  Report0 Reply