Spreadsheets/Excel

Denise40 · February 2015

Does anyone have spreadsheets for their budget, guests info(addresses), RSVP that can share? I have no clue how to make them with the different formulas and such. I can add data but that's about it. TIA

JennyColada · February 2015

What kind of formals are you looking for? Like something that subtracts the cost and gives you a total amount of your buget that you have left to spend? =SUM([starting cell budget]-[selected cell]) or a percentage of your budget that you're using for a certain item? =SUM([selected cell amount]/[total budget $]*100

???

theartistformerlyknownas · February 2015

I have one set up that applies a formula that determines if guest 1 and guest 2 have the same last name, concatenate into "Mr and Mrs Guest One" otherwise defaults to "Ms Guest Two and Mr Guest One," then has a pivot table to track total RSVPs, meal selections, etc.

I'll try to find it and clean it up later and send you a Google Docs link.

JennyColada · February 2015

I am SO happy that I never had to deal with any of this.

Jesus christ.

twoleighs · February 2015

If you go to open a new workbook in Excel, go to Templates, you can search for templates, and they have some really good ones. That's what I did for our initial budget.

You can also look on Microsoft's website for templates, but I think they may only be for the latest version, not sure on that one.

Denise40 · February 2015

Thanks everyone. I wasn't looking for the formulas. I was looking to see if anyone already had them and cared to share. I'll look up templates in excel.

plainjane0415 · February 2015

twoleighs said:

If you go to open a new workbook in Excel, go to Templates, you can search for templates, and they have some really good ones. That's what I did for our initial budget. You can also look on Microsoft's website for templates, but I think they may only be for the latest version, not sure on that one.

This. Anything I've learned about excel I learned by googling and using available templates.

falsara · February 2015

Go to google docs, and look up thier wedding planning template. It has all the formulas for all the stuff already in the sheets, so you just fill in the blank. It has a guest list page, a budget page, an individual page for each vendor and ll kinds of other stuff. Here's the one I use Clicky

Denise40 · February 2015

Thanks @falsara‌

falsara · February 2015

Denise40 said:

Thanks @falsara‌

More than Welcome, hope it helps!!!

huskypuppy14 · February 2015

falsara said:

Go to google docs, and look up thier wedding planning template. It has all the formulas for all the stuff already in the sheets, so you just fill in the blank. It has a guest list page, a budget page, an individual page for each vendor and ll kinds of other stuff. Here's the one I use Clicky

Where were you when I was planning my wedding?