Please help! Going crazy! Need Disney Dining Plan Spreadsheet...

[addiedisney]

I have been looking for a spreadsheet for the last 45 minutes and my eyes are about to pop out of my head. I keep getting dead links or finding old spreadsheets. Surely there is one out there.

I found one here a couple of years ago that let you compare OOP vs DDP. Does anyone have one? Would you be willing to email it to me or send me a link?? Please..please, please..

email: china on my mind at gmail dot com, or maybe post a link?

Thanks for any help!!

 

[JimmyV]

In the 45 minutes that you spent looking, you could create your own model.
1. Figure out where you are likely to eat each day.
2. Go to allears.net and look up the menus and make a prediction as to what you and your family will order, more or less. Doesn't have to be scientific.
3. Add up everything you think you will buy, factoring in tax, and then compare it to the cost of a dining plan.

Should take you about 15 minutes to half an hour and will be far more exacting than someone else's spreadsheet.

If that doesn't help you, here is a link that I think is still good, courtesy of Cafeen.
http://www.allansanschagrin.com/disney-dining-plan-cost-analysis-spreadsheet/

 

[addiedisney]

Thank you for the link!! That is exactly what I was looking for.

 

[kdawg8762]

When we go on vacation, i always add 10% to what i think i would spend on the DDP and I also add 10% to what i would spend OOP, just because of flights of fancy, change in taste, etc...I tend to underestimate what i will try to eat on vacation and I tend to underestimate how much i will spend. Especially since my girls and my son are too young to go with us quite yet, i always tend to buy them more than i probably would if they were there with us. Of course, I always say i'm only going to get them one thing.

 

[JimmyV]

Thank you for the link!! That is exactly what I was looking for.

Please note that you might need to tweak it. Not sure how up to date it is or how it prices out the plans, or treats tips. Tips used to be included in the price of the plan but are now separate. It's a bit tricky because when you factor in the tip when paying OOP, you do so based on what you ordered. It is simple math, because you know the cost of what you bought. But when you calculate the tip when using the plan, you also base it off of what you ordered, but you might be ordering different things since you are on the plan. In other words, If you pay OOP, and buy an app and an entree and a drink, you tip on that. If you are on the plan and would then buy and entree and a dessert and a drink, then you tip on that. The two numbers won't match, (unless by coincidence). That said, it is a very minor variable which you can ignore if you want to.

 

[Cafeen]

Please note that you might need to tweak it. Not sure how up to date it is or how it prices out the plans, or treats tips. Tips used to be included in the price of the plan but are now separate. It's a bit tricky because when you factor in the tip when paying OOP, you do so based on what you ordered. It is simple math, because you know the cost of what you bought. But when you calculate the tip when using the plan, you also base it off of what you ordered, but you might be ordering different things since you are on the plan. In other words, If you pay OOP, and buy an app and an entree and a drink, you tip on that. If you are on the plan and would then buy and entree and a dessert and a drink, then you tip on that. The two numbers won't match, (unless by coincidence). That said, it is a very minor variable which you can ignore if you want to.

The dining plan prices are accurate for 2011, but do not include holiday pricing, but these fields are easily editable (it's right on the front).

Entitlements are properly handled via the use of different "itineraries" for each plan (it's based around the idea that you'd dine differently considering which plan you're on (if any at all)). An app under DxDDP is covered whereas DDP it is not, a TS meal under DDP or DxDDP is covered, whereas QSDP is it not. There's no capping on used credits though, but there is information as to your "over/under" so you can adjust them yourself. There's also a "Misc" field to enter whatever possible non-covered items that don't fit into the happy little boxes above .

Note that the #credits for the TS and QS locations is PER PERSON, so it's either 1 or 2 (or the option to not use a plan for that meal, which then ignores that selection).

Tips are calculated as a configurable percentage on the whole pre-tax, pre-ddpified bill (just like they really would be, it's a total of both covered and non-covered items). Tax is figured at 6.5%, so if considering All Stars or WWOS, non-covered items may be slightly more expensive.

Overall, it's very configurable if not a bit tedious.

And thanks Jimmy for the plug

 

[addiedisney]

Thanks Cafeen for all your hard work! This is a great spreadsheet!

 

[JimmyV]

And thanks Jimmy for the plug

Gotta give credit where credit is due!!

 

[fairytalelover]

Wow! What a great spreadsheet!! Thanks for all the detailed hard work Cafeen!