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-15-2012, 01:11 PM   #16
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by wetiger View Post
Great job Cafeen! We're going in late April - early May 2013 so I used your spreadsheet (application, really) utilizing the new dining plan prices to see if it confirmed what I was thinking. It sure did but I was surprised at the degree to which the DxDP is a bad deal for my family.

Bit of background - we're a family of 4: 2 adults, 1 10yo Disney adult, and 1 5yo child. We eat a lot and enjoy eating good food, so I was planning on the DxDP before the 2013 rates were released. We'll be staying 8 nights and I figured we'd use 17-18 of our meals at TS restaurants, with only 1 or 2 of those at signatures.

With the significantly increased DxDP rates for 2013, it seemed to me we'd be spending an additional $45-$50 per day on the DxDP, so I had already figured it might make much more sense for me to invest a little extra up front for an AP and a TIW card for me. Boy, was I right!

In filling out the sheet and calculating each meal, I tended to estimate fairly high for alcoholic beverages to try to account for the non-meal times when my wife and I would prefer a drink to an ice cream snack. I also estimated our food choices on the high end but tried to be fairly realistic. Here's what I came up with:

If we paid OOP for what I've estimated, we'd wind up spending $3,000. On the DxDP at 2013 prices, we actually lose money - $3,375 total once the OOP items and gratuities are factored in. By using TIW, however, we spend less than $2,000 - a savings of $1,000 from OOP and almost $1,400 from the DxDP! I know the cost to us will be a little higher since we won't receive a TIW discount at our non-TS meals and the spreadsheet doesn't account for that but it's still an eye-opener for me!
I <3 glowing praise... *basks for a bit*

Ahem..

Glad to hear you found out what works best . While I'm a big proponent of the plans (well, DDP and DxDDP...and that's changing with the hikes), I'm an even bigger proponent of figuring out what's best for your trip, hence the size and scope of the sheet.

I'm also more seriously looking into bringing this to a web-based platform. All the math is figured out, so it's just a matter of coding it all (which won't be too difficult, I can do that too ). I think the UI is really what's holding me back on it and have to think of something that works for it. Besides, if I do that, then when someone finds a bug or an issue (e.g. the inability to select TiW on/off for specific TS/QS meals), I can fix it and their stuff will just have the updates applied (yep, I'm going to have the ability to "save" an itinerary in the web-form as well).
__________________
-- 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 07-15-2012, 02:16 PM   #17
wetiger
Earning My Ears
 
Join Date: Jun 2012
Posts: 5

Quote:
Originally Posted by Cafeen View Post
I <3 glowing praise... *basks for a bit*

Ahem..

Glad to hear you found out what works best . While I'm a big proponent of the plans (well, DDP and DxDDP...and that's changing with the hikes), I'm an even bigger proponent of figuring out what's best for your trip, hence the size and scope of the sheet.

I'm also more seriously looking into bringing this to a web-based platform. All the math is figured out, so it's just a matter of coding it all (which won't be too difficult, I can do that too ). I think the UI is really what's holding me back on it and have to think of something that works for it. Besides, if I do that, then when someone finds a bug or an issue (e.g. the inability to select TiW on/off for specific TS/QS meals), I can fix it and their stuff will just have the updates applied (yep, I'm going to have the ability to "save" an itinerary in the web-form as well).
What I like about what you've done is that it forces you to account for all of the OOP expenses you'd have on a dining plan. It's very easy to underestimate those costs if you don't go through things systematically. Plus, under this year's prices, I figured the DxDP would be about a break-even proposition for us which is exactly what it turned out to be when I plugged in the 2012 prices. I like the idea of the DP and the intrinsic value of knowing most things are already paid for. But for 2013, Disney has more or less made the DxDP a sucker bet. It might still make sense for shorter visits but for anyone staying 5 days or more, you can get everything you'd get on the DxDP and more for a lot less money.
wetiger is offline   Reply With Quote
|
The DIS
Register to remove

Join Date: 1997
Location: Orlando, FL
Posts: 1,000,000
Old 07-16-2012, 06:23 AM   #18
mousefan73
DIS Veteran
 
Join Date: May 2012
Posts: 629

Best thing about this spreadsheet is that its so professional. I can play around with it at work and to passerbys, it looks like I am really working!!!
mousefan73 is offline   Reply With Quote
Old 07-16-2012, 12:07 PM   #19
geckodani
DIS Veteran
 
geckodani's Avatar
 
Join Date: Sep 2011
Posts: 695

Wow. Your spreadsheet makes my spreadsheet looks like an early attempt at cave painting.

Thank you so much for sharing this!!!
geckodani is offline   Reply With Quote
Old 07-16-2012, 12:13 PM   #20
mbforbes
Earning My Ears
 
Join Date: Oct 2010
Location: virginia
Posts: 73

Love this!
__________________
Michele

late 70's and 80's contemporary (2X) and golf resort
1999 off site,2003 Orange Lake CC off site
2005 Fort Wilderness,2008 Fort Wilderness
2010 Fort Wilderness, Aug. 2011 SSR, next up the poly Nov 2011!!!
mbforbes is offline   Reply With Quote
Old 07-16-2012, 01:42 PM   #21
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by wetiger View Post
What I like about what you've done is that it forces you to account for all of the OOP expenses you'd have on a dining plan. It's very easy to underestimate those costs if you don't go through things systematically. Plus, under this year's prices, I figured the DxDP would be about a break-even proposition for us which is exactly what it turned out to be when I plugged in the 2012 prices. I like the idea of the DP and the intrinsic value of knowing most things are already paid for. But for 2013, Disney has more or less made the DxDP a sucker bet. It might still make sense for shorter visits but for anyone staying 5 days or more, you can get everything you'd get on the DxDP and more for a lot less money.
Yep, when I created it I was keen on figuring out exactly what I'd be spending, including all the "hidden" extras. While it kinda ballooned out from the original intentions, I think the cost and credit analysis part of it is one of the strongest aspects.

Quote:
Originally Posted by mousefan73 View Post
Best thing about this spreadsheet is that its so professional. I can play around with it at work and to passerbys, it looks like I am really working!!!
I can develop it at work too! (Not that I ever would... no ... never...)

Quote:
Originally Posted by geckodani View Post
Wow. Your spreadsheet makes my spreadsheet looks like an early attempt at cave painting.

Thank you so much for sharing this!!!
Thanks!

Heh, if you worked on your spreadsheet off and on for ~3 years, I'm sure it'd be just as fancy and have all sorts of funky stuff. Unfortunately, I think I'm pretty much at the cap of Excel functionality on this thing (well, beyond putting the TiW "switch" in there to say Yes/No to using it per restaurant...I gotta do that real soon) so it's either going to sit as (almost) is, or migrate itself over to the web. (I've started on the back-end for the web version, but the scope is getting away from me again...)

Quote:
Originally Posted by mbforbes View Post
Love this!
Thanks!
__________________
-- 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 07-16-2012, 11:33 PM   #22
Tinetine
Earning My Ears
 
Tinetine's Avatar
 
Join Date: Jan 2012
Location: Quebec, Canada
Posts: 70

Do you know how good you are going to make me look ?! I am planning a trip for a friend and his family. A TA told them they could not do Disney under 10,000$ ! For 5 people ! So I'm going to present them with this chart to justify them food costs and the choices I'm making. They'll be blown away ! Thanks so much !
Oh, and i'll give you full credit , of course !
__________________
[
Tinetine is offline   Reply With Quote
Old 07-17-2012, 06:46 AM   #23
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by Tinetine View Post
Do you know how good you are going to make me look ?! I am planning a trip for a friend and his family. A TA told them they could not do Disney under 10,000$ ! For 5 people ! So I'm going to present them with this chart to justify them food costs and the choices I'm making. They'll be blown away ! Thanks so much !
Oh, and i'll give you full credit , of course !
Glad I could help. Not sure what that TA was on, unless it was sniffing out a high commission? $10k for a trip for 5 seems awfully steep...

If you're good with Excel, you may want to simply add a tab at the start to outline rooms, tickets, and flights too. Keeping information all in one place in a nice, easy to read list will go far. Especially with the breakdowns spelled out for them . If you're not good with Excel, then...well...just do what you were going to do in the first place .
__________________
-- 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 07-17-2012, 10:37 AM   #24
denise5374
Dares to say CRUISE out loud
Don't go back to lurking
 
denise5374's Avatar
 
Join Date: Sep 2003
Location: suburban Phila, PA
Posts: 1,199

I also want to thank you for this spreadsheet I am a complete novice with excel so I was using a calculator and paper (the horrors!!) to figure it out.

You are my hero
__________________
First trip-1975, Contemporary-1982, off site-1986
Port Orleans-1997, Port Orleans/Wonder-2002, First 7-day cruise-Magic Eastern-8/2004 Saratoga Springs 6/05, CBR-8/07, 8/09, 8/12, 3/13 POR-8/13

denise5374 is offline   Reply With Quote
Old 07-20-2012, 11:58 AM   #25
PrinceOfPeace
Mouseketeer
 
PrinceOfPeace's Avatar
 
Join Date: May 2011
Posts: 126

Quote:
Originally Posted by Cafeen View Post
It's because I'm an idiot and completely forgot to actually upload the files.

You know, the whole basis for everything...

Minor details.

Both sheets are uploaded and I actually tried the download links this time to make sure they work.
Cafeen...you are the King! You are so sweet for putting such hard work and time into this and sharing it with complete strangers! Thank you! I look forward to using it....however I have open office....will it work?

[UPDATE: after downloading your spreadsheet....I realized you were not a 'queen' but a 'king'...lol...and I opened the spreadsheet into Open Office and it worked!]
__________________
"Someday my Prince of Peace will come, Some day we'll meet again, And away to His castle we'll go, To be happy forever I know..."
[hubby and I] + [5yr ds] + [3yr dd] + [1yr ds] =

Last edited by PrinceOfPeace; 07-20-2012 at 12:26 PM.
PrinceOfPeace is offline   Reply With Quote
Old 07-20-2012, 12:44 PM   #26
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by denise5374 View Post
I also want to thank you for this spreadsheet I am a complete novice with excel so I was using a calculator and paper (the horrors!!) to figure it out.

You are my hero
You're very welcome. I like getting praise! That's why I wro...erm...nm that

Quote:
Originally Posted by PrinceOfPeace View Post
Cafeen...you are the King! You are so sweet for putting such hard work and time into this and sharing it with complete strangers! Thank you! I look forward to using it....however I have open office....will it work?

[UPDATE: after downloading your spreadsheet....I realized you were not a 'queen' but a 'king'...lol...and I opened the spreadsheet into Open Office and it worked!]
Heh, I was going to say something when I saw the email notification, but you fixed it so it's all good .

I have no idea if it's fully functional in Open Office. It SHOULD be, as it was originally designed in "Calc", but I've since picked up MS Office on my home computer (for other stuff) and haven't looked at Open in awhile so I can't guarantee that any of the recent changes are compatible (there's no reason they wouldn't be, I just haven't tested it yet... then again, it IS "beta" so that's not my job! )

As a note, I actually have started developing a web-based version of this sheet (for real this time, not just some flat html mockup and then leave by the side of the road that I did before!) so the Excel-based version may come to end of life sooner rather than later. But, given my normal development time, expect it sometime before the year 2038...maybe, unless I get delayed.
__________________
-- 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 07-20-2012, 07:19 PM   #27
ilovepete
DIS Veteran
 
ilovepete's Avatar
 
Join Date: Aug 2010
Location: Not far above The World
Posts: 1,866

This is really awesome! Thank you!
__________________
Me, wife to DH and mama to DD5 and DS7
DD's favorite character is Pete, so that is where the screen name comes in!
ilovepete is offline   Reply With Quote
Old 07-20-2012, 08:05 PM   #28
Steakgoddess
Mouseketeer
 
Steakgoddess's Avatar
 
Join Date: Mar 2008
Posts: 187

Cafeen, thank you SO much for putting all the time and effort into this! It was fun to go through and plug in numbers and watch the savings add up. You are the best!
__________________
Steakgoddess is offline   Reply With Quote
Old 07-20-2012, 09:11 PM   #29
Sheaboys
DIS Veteran
 
Sheaboys's Avatar
 
Join Date: Jan 2005
Location: Brimfield, Massachusetts
Posts: 607

Ok so I downloaded it, began filling in the resort section, we have 2 rooms, since we are a family of 7, will this matter?
__________________
Our August 2012 Free Dining Review. http://www.disboards.com/showthread.php?t=2990330

Mom to 5 little boys
WDW-various days during the 70's and 80's as a child. DisneyLand-July 1991, DisneyWorld-April 1992 offsite
Caribbean Beach-June 1995 honeymoon, All Stars Sports-December 1998, All Star Movies- November 2000 (me, my mom and the 2 boys) DTD Hotel - May 2001, All Star Movies-September 2001 (me, the 2 boys and my girlfriend), Disneyland-December 2003 (us and the 3 boys), POR-October 2nd-8th 2005 (us and the 3 boys)Caribbean Beach-August 25, 2012-September 2,2012
POR-August 2014 (16th-26th)

(dh43) (me 42) (15)(13)(11)(7) (5)
Sheaboys is offline   Reply With Quote
Old 07-20-2012, 09:32 PM   #30
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Quote:
Originally Posted by ilovepete View Post
This is really awesome! Thank you!
Thank you and you're welcome too!

Quote:
Originally Posted by Steakgoddess View Post
Cafeen, thank you SO much for putting all the time and effort into this! It was fun to go through and plug in numbers and watch the savings add up. You are the best!
Thanks and you're welcome. I totally agree about watching the numbers add up. It's one of the things I'm struggling with on my web-based version (deciding between an "AJAX" analysis that triggers off of each field, or a simple calculate button... button is easier and less traffic... AJAX (basically, the panel would update automatically without refreshing the page) is more fun but much more difficult and tedious to program...DECISIONS!)

Quote:
Originally Posted by Sheaboys View Post
Ok so I downloaded it, began filling in the resort section, we have 2 rooms, since we are a family of 7, will this matter?
Nope, shouldn't matter. If the rooms are the same cost/available discount, just add them together. If they are not for whatever reason, then use the "Fixed Resort Price" field (or whatever I called it). If you're not using it to compare FD stuff, then it doesn't matter one bit...for now!

Now, if I ever get that web-version up and running, it might...it has a cap of 198 people (99 adults, 99 children), so if you're crazy or a leader of a Tour Group or that TV fakality overgrown family (Duggers is it? I don't watch that crap...it's mostly H2 for me these days, or Breaking Bad...), you may be out of luck! (However, it also allows for up to 99 nights (can you tell that I limited the database fields to 2 digits ), so if you want to move there for about 1/3 of the year while on the dining plan, you're set!)
__________________
-- 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
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 05:13 PM.

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: