Earn cash as you plan. Get a $20 gift card for every 200 points with The Knot Rewards
June 2012 Weddings
Kfudge0714
member
Guest list Speadsheet?
I'm am not very good with excel but my current method for my guest list is NOT working. Does anyone have a sample shreadsheet they will share?
TIA
TIA
This discussion has been closed.
Re: Guest list Speadsheet?
[QUOTE]what isn't working? I just typed in all our guests alphabetically....
Posted by Ash61612[/QUOTE]
I did this as well..... I have one tab with just names and number of guests per household (so I know how many invitations I need). Then I have a tab with full names and addresses, and still have the number of adults and kids next to it so I can sum it and make sure it matches tab 1 so I am not missing anyone!
PM me your email address and I will send you mine.
First Look
My Blog
Here is my format:
Tab 1
Names # of Adults # of kids
Tab 2
Names and Addresses # of adults # of kids
I have both tabs subtotaled at the bottom to be sure that both are exactly the same. HTH!
[QUOTE]I also added a column for RSVP's and gifts
Posted by Ash61612[/QUOTE]
I did this too. I created an entire wedding planner on a spreadsheet within Google Docs. The guest list tab has columns for the gift they gave and one for me to mark when I've mailed a thank you card.<div>
</div><div><strong>Highly suggested: </strong>I created a column immeditely next to the names for the RSVP number. I'll add this number to the RSVP card, so just in case someone forgets to write their name I'll be able to match it up with the master list.</div><div>
</div><div>Here are the templates from Goole:</div><div><a href="http://www.google.com/weddings/plan.html#docs" rel="nofollow">http://www.google.com/weddings/plan.html#docs</a> </div>
June 2012 Siggy Challenge - Wedding Rings
[QUOTE]In Response to Re: Guest list Speadsheet? : I did this too. I created an entire wedding planner on a spreadsheet within Google Docs. The guest list tab has columns for the gift they gave and one for me to mark when I've mailed a thank you card. <strong>Highly suggested: I created a column immeditely next to the names for the RSVP number. I'll add this number to the RSVP card, so just in case someone forgets to write their name I'll be able to match it up with the master list.</strong> Here are the templates from Goole: <a href="http://www.google.com/weddings/plan.html#docs" rel="nofollow">http://www.google.com/weddings/plan.html#docs</a>
Posted by BrooklynNovia[/QUOTE]
I am doing this as well!!! A friend of mine got married last summer and did this and she said that it saved her so much time because she got like 40 cards back that people forgot to write their name on!!!
PS. peachykeen-- YGPM!
***My Planning Bio***
[QUOTE]Thanks Ladies!! I just have a bunch of pieces of paper with names crossed out (meaning that I sent STD) its a mess!! I need to get more organized! and I never thought of doing a RSVP column. PS. peachykeen-- YGPM! =)
Posted by Kfudge0714[/QUOTE]
I sent you the email. :)
First Look
Planning Bio: Updated January 25
My Blog
Last name
First name
+1's Last name
+1's first name
# of people invited under that guest (+1's, children) --this is totaled at the bottom
Address
City
State
Zip Code
Then I have many different tabs with all of the above with an extra column for each reason:
STD's sent
Shower invitations sent
Shower gift and another column for TY sent
# of people attending and 4 columns for each meal choice (totaled at the bottom)
Wedding gift and another column for TY sent
Hope that helps!