All the Things: Organization by Spreadsheet

Well hello again, hive! So, we’ve covered a few organizational things—The Schedule, The Packet, and the Card. I hope they’ve been helpful in planning! Today I’m writing about The Spreadsheet—which, in a fit of melodrama, I named All The Things. :)

In the beginning, my wedding planning was almost derailed by Pinterest—I wanted every single detail that I saw. Toasting flutes, engraved cake forks, chair signs, paper lanterns, tissue poofs”¦all the things! As McGlovin and I started to form a wedding vision, though, it became easier to edit ideas. Once I returned to a rational state of being, I started a Google spreadsheet where I could keep track of all of these ideas, so I could pick and choose what we wanted at our wedding.

all-the-things1

Pretty much, I labeled each column with a different aspect of the wedding (Rehearsal, Bride’s Look, Ceremony, Reception Décor, etc.) and started a running list of things that I might want for each portion. Many, many things got thrown out (Hershey’s Kisses, poinsettias, paper lanterns, matchbooks), and when they did, I shaded that block red. Anything that we for sure wanted got shaded green. Things that we didn’t feel strongly about either way were usually discarded, but optional if we had time/money closer to the wedding.

all-the-things-monthly1

Another important spreadsheet was a monthly schedule. In the first month of planning, I took my list of vendors and assigned each a month for completion. Finding a ceremony location and finding a reception venue were allotted a month each”¦after that, there were two or three vendors a month to choose, and I also started adding major tasks such a ordering invitations and taking engagement photos. This spreadsheet was really helpful in making sure that all of the big tasks got done, and was also color coordinated according to where we were in completing them.

all-the-things-10-weeks

Much closer to the date, I created a 10-week schedule with tasks assigned to each week, and then a two weeks schedule with tasks assigned to each day. Although I was definitely in charge of managing the schedules, they really helped me to delegate when people asked what they could do to help. McGlovin had an entire afternoon off? Excellent, he could track all of the RSVPs in our guest-list spreadsheet. My sweet sister had two weeks off from school, and volunteered to create strands upon strands of twinkle lights.

all-the-things-reception1

I also had a list of items specifically for my reception décor. There are so many tables that needed to happen: entrance table, DJ table, bar, gift table, guestbook table, cocoa bar, escort cards, cake, head table, and guest tables. I don’t know why, but I had the absolute most difficult time organizing what needed to be on each of these tables, so it got its own spreadsheet.

So, ladies—what else did you guys spreadsheet? Or did you just make lists upon lists on Post-its? Or did you just hand a list to your coordinator and sit back with a glass (bottle?) of wine? God, I sometimes wish I had done that. :)

BLOGGER

Mrs. Gloves

Location:
Columbus, Ohio
Wedding Date:
January 2013
Add a comment

comments

  1. Member
    lovelyduckie 756 posts, Busy bee @ 1:25 pm

    They have some decent phone apps for wedding planning. The one I used was the android one.

  2. Member
    dommiebatsch 52 posts, Worker bee @ 1:38 pm

    Just let me say i LOVE your spreadsheet, there’s nothing better than a good spreadsheet, and I’m in total excel heaven looking at yours, amazing! I’m not as organised as I’d like at the moment (still 14 months out) so was hoping to steal your idea, if that’s ok? :)

  3. Member
    mkelove 666 posts, Busy bee @ 2:24 pm

    love LOVE the spreadsheets! I am spreadsheet happy and put everything possible into one!

  4. Member
    papercrafter 399 posts, Helper bee @ 4:39 pm

    Your posts are by far some of my favourite posts! LOVE all your organizing ideas. None of mine are this organized:( To be honest my biggest fear is that we’ll get closer and nothing will be done! These will help for sure!

    Also love the “all the things” spreadsheet! When I started too I wanted every single detail, until I was speaking with someone who told me they went to a wedding where it looked like pinterest threw up lol! Definitely don’t want that :)

  5. Member
    sarahblais 120 posts, Blushing bee @ 4:42 pm

    Love the idea of the spreadsheets for the decor items for the different tables! I’m in DIY project mode and this would be nice to have for my list of projects, all materials needed vs what I have, and if the project is not started, in progress, or completed. Assigning things with different priorities is a great idea too in case I run out of the time, I’ll have my most important decor DIYs done!

  6. Member
    misscomicbook 2679 posts, Sugar bee @ 5:45 pm

    Do you have templates for all of your spreadsheets?! I am insanely in love with them and started using Google Drive because of your suggestion, but this one is far more complex than my rudimentary skills can handle, lol.

  7. Member
    iwinatcookie 55 posts, Worker bee @ 7:11 pm

    This is a great idea! I have some of the phone app to-do lists, but this would help me better plan out how long I need to schedule for getting certain things done. Brilliant!

  8. Member
    DBS5127 220 posts, Helper bee @ 7:30 pm

    Posts like this make me super excited to plan – I love lists and organizing! Thanks for the ideas!

  9. Member
    thebestisyettocome 57 posts, Worker bee @ 8:47 pm

    All the things!!! this is what I needed! Just last week I wrote all my wants in a notebook and thought, “so . . . now what?”. I will definitely be using that idea!!

  10. Member
    MrHT 40 posts, Newbee @ 9:44 pm

    This is a great idea!

  11. Member
    blonde17jess 1290 posts, Bumble bee @ 4:38 am

    I love your spreadsheets, Mrs. Gloves! (Have I expressed that enough yet?) I think they’re really helpful, and even though I’m pretty darn organized, you thought of things that I just haven’t thought of! Thanks! :)

  12. Member
    mrscvsomeday 162 posts, Blushing bee @ 8:22 am

    Love, love, love. :)

  13. Member
    mssquirrel 276 posts, Helper bee @ 9:38 am

    Mrs. Gloves. I just set up my list :) Thank you a million. Now my brain doesn’t have to work so hard to remember everything!

  14. Member
    msmongoose 264 posts, Helper bee @ 12:16 pm

    Excellent idea! I love how organized you were and your spreadsheets are rocking my world.

  15. Member
    futuremrsguerra 50 posts, Worker bee @ 7:21 am

    Can I just say you are my heroine! I learned many new excel skills just by planning the wedding and I have a ‘masterpiece’ where I have my budget calculated and separated by tabs so that if one thing changes, the total will reflect that etc….

    I have been slacking on the schedule/timeline part of the planning process and now that my wedding is 99 days away, I figured I should START…. Thank YOU Thank YOU for making these available for us to use as a guide for our own planning…

    *CLAPS* to you! :)

  16. Member
    annabelle_lee 192 posts, Blushing bee @ 2:48 pm

    Faint… this is so beyond great! Just WOW!

  17. Member
    kotadaylebw 9 posts, Newbee @ 1:26 pm

    This is wonderful!
    I have 2 months to plan my wedding and I was really in need of more organization.

    Other spreadsheets that I suggest:
    - spreadsheet for the DIY projects that includes columns-
    grouping (ceremony, reception, food, etc),
    project title,
    supplies need to complete project,
    projected expenses,
    completion (Y/N), and
    Notes (maybe you have a specific place that you needed to store it that you want to note, or if you need a bridesmaid or someone to help out with that particular project).

    - Guest list spreadsheet. keep track of addresses, who is attending or not, gift received, and thank you note sent.

    Happy Planning!!!

  18. Member
    Mike_KC 1 posts, Wannabee @ 10:34 am

    Could you please check the link. I am having trouble getting the Rapidshare link to do anything, I even created an account. Trying to help my daughter get organized!!

    Thanks,
    Mike

add a comment

Find Amazing Vendors