Disney Information Station Logo

Go Back   The DIS Discussion Forums - DISboards.com > Disney Trip Planning Forums > Disney Restaurants > Disney Dining Plan
Find Hotel Specials & DIScounts
 
facebooktwitterpinterestgoogle plusyoutubeDIS UpdatesDIS email updates
Register Chat FAQ Tickers Search Today's Posts Mark Forums Read





Reply
 
Thread Tools Rate Thread Display Modes
Old 07-31-2012, 11:29 PM   #46
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by Kathymford View Post
I have to add to the praise!

I had been using this other spreadsheet that I found on the other board that let you compare one dining plan against OOP or TiW, and that was working ok for deciding on dining plan at all. But THIS is beyond my wildest dreams!

Question, although I think it's obvious I will ask anyway. The meal details are per person right? So if I am entering data in Meal 1 for Artist Point for 2 people, I should add up the totals for both adults? It doesn't multiply the meal details by the number of people?

Thanks again!
Thanks , just wait to see what's coming in the not too distant future . (Unfortuantely, that was pretty mean of me to tease that in, since it's not even ready to share screenshots of yet...)

You are correct with the meal details. The only "multiply by number of people" that goes on is the credit related stuff and the dining plan costs themselves. The individual pieces of the meals and such should be added together. After all, you're probably not likely to order the same exact thing .

---
I think some stuff is off with the TiW calculations right now, it's a pretty buggy area so use it with care (especially the combination of dining plans and TiW). I started to fix it, but instead I'm getting work done on the web-based version (for which, I'm also having trouble with TiW calculations... who would have thought that a flat 20% off would be the more difficult to get right?) So, take TiW stuff with a grain of salt for now...preferably around the rim of a glass...and a lime....
__________________
-- Allan (Smugmug / Flickr)
(Completely redid smuggy collections, See the Shared with Disboards gallery for broken images in posts.)

Next Trip: NOT Solo... 10/17-10/27 @ Pop/CBR split. This time with Brother, Sister-in-Law, Nephew, and Mom (well, at least mostly not solo.)
TRs: Learning to NOT Photograph Fireworks Behind Trees (Sept 2012 PTR (no TR... yet?)
New Camera? Sounds like a perfect excuse for another Disney trip! (Sept 2011 PTR/TR)
Cafeen takes it slow in Sept... (Sept 2010) || Daddy for a week... - (Sept 2009)
Cafeen is offline   Reply With Quote
Old 08-01-2012, 02:53 PM   #47
greeneggs1082
Mouseketeer
 
Join Date: Apr 2009
Location: Orlando, FL
Posts: 168

Woohoo!

I finally figured this spreadsheet out! I wasn't multiplying each item by the number of people for each meal, lol. Once I did that, I show that by us using the DxDP this September, we'll save roughly 32%!! And looking at some of the costs of the meals we've got planned, I'll be glad to just hand over my KTTW card instead of my debit card! Thank you so much for the spreadsheet!
__________________
- Gina , DH , DS2 , DS6months , Behr , Trish , Phoebe , Jack
greeneggs1082 is offline   Reply With Quote
|
The DIS
Register to remove

Join Date: 1997
Location: Orlando, FL
Posts: 1,000,000
Old 08-01-2012, 03:33 PM   #48
WyldLynx
Crazy Disney Addict
 
WyldLynx's Avatar
 
Join Date: Sep 2009
Location: Middle Tennessee
Posts: 173

OMGs!!! THANK YOU THANK YOU THANK YOU

All the work you had to do for this. It has come in sooooooooooo handy. And the part where you can reconfigure for free dining!!! just THANK YOU so much!!
__________________


Sept 2010 - First Trip Ever (offsite), Sept 2013 Wilderness Lodge, Sept 2014 Wilderness Lodge CL
WyldLynx is offline   Reply With Quote
Old 08-01-2012, 04:05 PM   #49
Kathymford
A little obsessed is ok....right?
 
Kathymford's Avatar
 
Join Date: Jan 2011
Location: 25 miles from DLR
Posts: 1,676

I love seeing all the numbers this way, but I'm kind of torn. Because if I'm paying OOP, we won't eat the way we do on DxDP, so it's really hard to compare. If we eat like the DxDP, then obviously dining plan saves money. Decisions, decisions...

LOVE seeing the numbers like this though!
__________________
Kathymford is offline   Reply With Quote
Old 08-01-2012, 06:54 PM   #50
princessaloha
Mouseketeer
 
Join Date: Apr 2012
Posts: 270

Quote:
Originally Posted by Kathymford View Post
I love seeing all the numbers this way, but I'm kind of torn. Because if I'm paying OOP, we won't eat the way we do on DxDP, so it's really hard to compare. If we eat like the DxDP, then obviously dining plan saves money. Decisions, decisions...

LOVE seeing the numbers like this though!
Hope you don't mind me jumping in. I love Cafeen's spreadsheet!

I figured out and imputed what we would order on the DxDP, then went back and refigured what we would do if we paid OOP. There was about a $500 difference. That's the beauty of this spreadsheet, you can use different numbers. In the end, we still come out ahead with the DxDP. Who knew, until we saw the numbers.
princessaloha is offline   Reply With Quote
Old 08-01-2012, 07:47 PM   #51
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by greeneggs1082 View Post
I finally figured this spreadsheet out! I wasn't multiplying each item by the number of people for each meal, lol. Once I did that, I show that by us using the DxDP this September, we'll save roughly 32%!! And looking at some of the costs of the meals we've got planned, I'll be glad to just hand over my KTTW card instead of my debit card! Thank you so much for the spreadsheet!
Yep, adding the items together then inputting them in is the way to go . This method allows the most flexibility and simulated realism across what you may order.



Quote:
Originally Posted by WyldLynx View Post
OMGs!!! THANK YOU THANK YOU THANK YOU

All the work you had to do for this. It has come in sooooooooooo handy. And the part where you can reconfigure for free dining!!! just THANK YOU so much!!
Ahh, more praise. I love it!

In all reality, I made it mostly for myself and then shared it, so it really wasn't THAT big of a deal. The only part that I didn't really make for myself is the TiW section (which may explain why it's the buggiest ). Very seriously though, thank you

Quote:
Originally Posted by Kathymford View Post
I love seeing all the numbers this way, but I'm kind of torn. Because if I'm paying OOP, we won't eat the way we do on DxDP, so it's really hard to compare. If we eat like the DxDP, then obviously dining plan saves money. Decisions, decisions...

LOVE seeing the numbers like this though!
The different itineraries are made specifically with that in mind. Since, even at the most basic level, you may skip desserts at least at the CS locations if you're not on a plan, they aren't really savings by getting them. Now, if you want them, but wouldn't pay for them, that's a subjective decision to make and the sheet at least offers the knowledge of roughly what you'd be spending/saving by going with that.

DxDDP is a beast, I've done it twice so far (and the 3rd time coming up in less than 2 months! ) and for sure, you aren't going to eat like that when paying OOP. What I do, is compare the OOP cost with the cost on DxDDP and in my case, it's typically more with DxDDP. I then take a look at the difference and decide if the amount of increased experiences, food, etc is worth that increase. Lastly, I check the DxDDP savings to make sure that I'm not losing money by following that pattern.

So basically, as an example, my 2012 trip on Free Dining (this is the 2nd year I've used it in the past 4 yearly trips, since I normally travel solo), it'll cost me roughly $650 for the DxDDP itinerary. I can get away OOP for about $500. However, for that $150 increase, I am getting roughly $1,250 worth of food and experience. So, obviously for me, it's worth it. Even paid DxDDP it would be about a $500 difference, for roughly $750 worth of food and experience, and for me, I'd be prone to do that as well.

(As a note, since I'm solo, my raw dollars are less for both cost and savings, it's about 15% savings though, so it's still decent, and that's spending a couple credits at QS and leaving 4 credits sitting there doing nothing)

Quote:
Originally Posted by princessaloha View Post
Hope you don't mind me jumping in. I love Cafeen's spreadsheet!

I figured out and imputed what we would order on the DxDP, then went back and refigured what we would do if we paid OOP. There was about a $500 difference. That's the beauty of this spreadsheet, you can use different numbers. In the end, we still come out ahead with the DxDP. Who knew, until we saw the numbers.
Of course I mind!

JK

You are more than welcome to bring me more people to praise me....

I mean, spread your experience with the sheet to help people. Yup, that's it .
__________________
-- Allan (Smugmug / Flickr)
(Completely redid smuggy collections, See the Shared with Disboards gallery for broken images in posts.)

Next Trip: NOT Solo... 10/17-10/27 @ Pop/CBR split. This time with Brother, Sister-in-Law, Nephew, and Mom (well, at least mostly not solo.)
TRs: Learning to NOT Photograph Fireworks Behind Trees (Sept 2012 PTR (no TR... yet?)
New Camera? Sounds like a perfect excuse for another Disney trip! (Sept 2011 PTR/TR)
Cafeen takes it slow in Sept... (Sept 2010) || Daddy for a week... - (Sept 2009)
Cafeen is offline   Reply With Quote
Old 08-03-2012, 08:06 AM   #52
disneychristmasx3
Mouseketeer
 
disneychristmasx3's Avatar
 
Join Date: Oct 2010
Location: Durham, NC
Posts: 124

tax question

I just filled in my spread sheet (thanks - you are amazing!!!) but now I realize that allears has tax included in their prices, so it has kind of been added in twice. Do you get the actual menu prices from a different site you would like to recommend?
__________________
DH me DD(24)DS(22) DS(18)

disneychristmasx3 is offline   Reply With Quote
Old 08-03-2012, 12:35 PM   #53
Kathymford
A little obsessed is ok....right?
 
Kathymford's Avatar
 
Join Date: Jan 2011
Location: 25 miles from DLR
Posts: 1,676

Quote:
Originally Posted by disneychristmasx3 View Post
I just filled in my spread sheet (thanks - you are amazing!!!) but now I realize that allears has tax included in their prices, so it has kind of been added in twice. Do you get the actual menu prices from a different site you would like to recommend?
I never knew that about the all ears site!!
__________________
Kathymford is offline   Reply With Quote
Old 08-03-2012, 03:00 PM   #54
princessaloha
Mouseketeer
 
Join Date: Apr 2012
Posts: 270

Well, sigh, need to pass on this little tid bit. Better to download and save the spreadsheet to your computer instead of accidentally using the "view" feature and assuming because it needed to download then it automatically saves all your hard work when your computer does an auto restart for updates. Otherwise, you will have to start over.

Don't ask how I discovered this...
princessaloha is offline   Reply With Quote
Old 10-19-2012, 06:30 PM   #55
tasilva
Earning My Ears
 
tasilva's Avatar
 
Join Date: Jun 2010
Location: The Disneyland State
Posts: 10

Just wanting to add more praise and thanks for your awesome sheet! It did take a while to complete bit it was well worth it because in the end I end up saving 15% by doing the DDP (TIW is about the same for me, FYI, I'm just going with DDP to eliminate all decisions on cost).

The only thing I had to tweak at all (because the numbers weren't adding up and it was making me crazy) was that we have several ADR's that have tax included in the price (character breakfasts) so with the tax being added in again at the bottom of the sheet (totals by meal "type") it made the numbers off. Once I figured that out it all added up perfectly.

Thank you so much for your hard work on this! It is AMAZING!
__________________
tasilva is offline   Reply With Quote
Old 12-12-2012, 08:22 AM   #56
livibug
Mouseketeer
 
livibug's Avatar
 
Join Date: Jan 2009
Location: Cincinnati, Ohio
Posts: 255

now thats a spreadsheet! i started my own basic one to get values.. then I found this.. info overload, but it will tell you if ddp is worth it!

Great job!
__________________



Dolphin, CBR, ASM, POP
livibug is offline   Reply With Quote
Old 12-12-2012, 11:43 AM   #57
elaine amj
DIS Veteran
 
Join Date: Jan 2012
Posts: 1,518

wow - this is amazing. I will definitely use this on future trips instead of the basic spreadsheets I come up with myself. I thought I was a spreadsheet queen - but man I'm a raw amateur beside this work of art.
__________________
elaine amj is offline   Reply With Quote
Old 12-23-2012, 07:33 PM   #58
MrsSpfaff
Honeymooning in Disney
 
MrsSpfaff's Avatar
 
Join Date: Mar 2011
Location: missouri
Posts: 27

I need help!!!!!!!!

I want this spreadsheet!! I downloaded it but it says it wont open!! I NEED THIS!!! Please help. I have no idea what to do
MrsSpfaff is offline   Reply With Quote
Old 12-23-2012, 08:01 PM   #59
MrsSpfaff
Honeymooning in Disney
 
MrsSpfaff's Avatar
 
Join Date: Mar 2011
Location: missouri
Posts: 27

OK! I got it!!

I got it open now to figure out the spreadsheat lol
MrsSpfaff is offline   Reply With Quote
Old 05-06-2013, 04:16 PM   #60
SMorgan711
It all starts with a wish!
 
SMorgan711's Avatar
 
Join Date: Sep 2011
Location: the second star to the right *
Posts: 424

WOW! So I tried making my own spreadsheet, got a headache and decided to google it. I'm so glad I did!


THANK YOU THANK YOU THANK YOU!

You are the spreadsheet master!!
__________________
Samantha (28) DH (27) DMom DDad

1990 Poly | 1991 CB | 1994 POFQ | 1995 ASSp | Apr 1999 ASMu | Apr 2002 POR | 2004-2005 (New Years) WL | Oct 2008 SoG | Jan 2009 SoG | Sep 2009 POR | Feb 2011 AKL (JUST ENGAGED!) | Dec 2011 Poly | Oct 2012 BWI | Nov 2013 POFQ | Feb 2014 YC (DFTW!) | Sep 2014 POR |

SMorgan711 is online now   Reply With Quote
Reply



Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

facebooktwitterpinterestgoogle plusyoutubeDIS Updates
GET OUR DIS UPDATES DELIVERED BY EMAIL



All times are GMT -5. The time now is 08:58 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

Copyright © 1997-2014, Werner Technologies, LLC. All Rights Reserved.

You Rated this Thread: