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-12-2012, 08:55 PM   #1
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

Cafeen's Disney Dining Plan Cost Analysis Spreadsheet - Reborn

I shared this once, ages ago. But then I fell by the wayside and all was lost. Well, all but the mega sheet itself. And yes, the title of the sheet signifies just how long it is .

Since planning for my 2011 and 2012 trips, I have tweaked the sheet considerably and added some new features (and pulled Excel 97 and Open Office "support").

This is really more than a spreadsheet, it's essentially an application that runs in Excel now. It's huge. I'm warning you here, it's a big big sheet. It's tedious as hell to fill out, but it'll give you a fairly accurate estimation on the best bet for your trip. I still have future plans for this, so I'm still calling this beta (yup, it's been a "beta" for about 2 1/2 years now). As such, I offer no guarantees or anything, because if I did, then that'd be pretty silly of me to do so! "As-is" is the name of the game. It's also free, of course.

--Download Page with Instructions and Such--

Features
The sheet offers several features that you'll probably find somewhere else as well...
  • Free Dining Cost Comparison - Just how much is your free dining costing you? Are you better off with a room discount?
  • Multiple Itinerary Support - You wouldn't REALLY get all those desserts if you were paying OOP right? Let's compare apples to apples here. The sheet offers different itineraries for 5 scenarios including all 3 of the major dining plans (DxDDP, DDP, QSDP), Tables in Wonderland, and Out of Pocket
  • Sortable Value per Credit Analysis - Oops, you went over on your credits and need to know which meal you're getting the least value for? Don't worry, there's a whole tab on there for it.
  • Various Cost and Credit Metrics - How much are you actually paying for all this? How much would this cost if it were fully OOP? How much are my servers expected to get? How much value per credit am I receiving? Answer these questions and more!

I've also included an example sheet (it's my actual one for my 2012 trip, in fact) on the download page if you'd like to get a visual of how it's all filled out.

Some Tips and Other Notes
  • It's big. The sheet is huge. It's overwhelming at first! However, that's mostly the calculations and all that stuff that you don't need to worry about. Really, the only tabs you even need to look are are the first 4 (Summary, Days 1-7, Days 8-14, Sortable Price Data), and if you're set with your credit count, you don't even need the 4th! And on the "Days" pages, you only need to enter the data there, all the calculations (totals, added tax, added tips, etc) are all done for you.
  • The credit numbers per meal are for the restaurant. It will calculate the total credits used by multiplying that number and the number of people you specify. Since restaurants at Disney are (currently) either 1 or 2 credits, only 0, 1, and 2 are allowed in this field.
  • TiW section needs some work. Right now it applies the discount if it's a TS location and not if it's a QS location. There is absolutely no way for the sheet (currently) to recognize the restaurant and inherently know if TiW is applicable there (this is out of scope for the spreadsheet). There will, eventually, at least be a way to specify whether or not to use TiW at the meal, outside of the QS/TS switch. That'll be coming in the next version!

Screenshots




You are 100% free to tweak this sheet to fit your own needs, as well as convert it to other formats if you please. If you add features and all that fancy stuff to it, and then share it yourself, I ask of you two simple things. Credit for the stuff I did, and a cut if you sell it! (JK, well, unless you actually do sell it...and are willing... I won't turn it down )

As you can see, I really take myself seriously (sarcasm! ). But in all honesty, I've put roughly 100+ hours into creating, testing, tweaking, formatting, etc this sheet. It's far from perfect, but it should suit most everyone's needs for now (at least, until stuff changes again...)
__________________
-- 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)

Last edited by Cafeen; 07-15-2012 at 11:26 AM.
Cafeen is offline   Reply With Quote
Old 07-12-2012, 09:26 PM   #2
CantHardlyWait1981
Earning My Ears
 
CantHardlyWait1981's Avatar
 
Join Date: Jun 2012
Location: Rhode Island
Posts: 25

Not sure what I am doing wrong, but when I try to download it it is telling me "Sorry, but you are looking for something that isn't here."
__________________
Upcoming trip: 11/28-12/4 CSR
Over 20 previous trips!

CantHardlyWait1981 is offline   Reply With Quote
|
The DIS
Register to remove

Join Date: 1997
Location: Orlando, FL
Posts: 1,000,000
Old 07-12-2012, 09:38 PM   #3
Cafeen
DIS Veteran
 
Cafeen's Avatar
 
Join Date: Jul 2009
Location: Mobile, Alabama
Posts: 4,853

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.
__________________
-- 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-12-2012, 09:48 PM   #4
CantHardlyWait1981
Earning My Ears
 
CantHardlyWait1981's Avatar
 
Join Date: Jun 2012
Location: Rhode Island
Posts: 25

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.
Thank You!!!!!!
__________________
Upcoming trip: 11/28-12/4 CSR
Over 20 previous trips!

CantHardlyWait1981 is offline   Reply With Quote
Old 07-12-2012, 10:04 PM   #5
virge
Mouseketeer
 
Join Date: Jul 2011
Location: Virginia
Posts: 86

Thanks for sharing! You put a great deal of work into creating this & I appreciate your efforts!
virge is offline   Reply With Quote
Old 07-20-2012, 12:58 PM   #6
PrinceOfPeace
Mouseketeer
 
PrinceOfPeace's Avatar
 
Join Date: May 2011
Posts: 129

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 01:26 PM.
PrinceOfPeace is offline   Reply With Quote
Old 07-20-2012, 01:44 PM   #7
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-14-2012, 12:34 AM   #8
tpettie
What"s a tag and why do you want one?
 
tpettie's Avatar
 
Join Date: Feb 2008
Location: Canada
Posts: 1,196

Thanks Cafeen I just have to see if I'm skilled enough to add two more day into the spreadsheet without messing up the formulas .... I love you spreadsheet and have used it faithfully for the last 3 trips 2012 will be our forth year tanks for all your hours of work! We are going for 16 days this year
__________________



All Stars Movies December 2008 (First Trip)
All Stars Movies December 2009 (Return with more kids)
POR Nov 28 - Dec 05 2010 (Adult Only Trip)
ASMusic Sept 29 - Oct6 2011 (let go trip)
Sequel Trip AofA Resort Nov/Dec 2012
POP Sept 7-12 with Disney Dream 3 Night Cruise Sept 12-15
tpettie is offline   Reply With Quote
Old 07-14-2012, 11:16 AM   #9
mmouse50
DIS Veteran
 
Join Date: Feb 2010
Posts: 963

Thank you so much for all the work - I have uploaded it and looking towards next year since this year is with Free Dining.
mmouse50 is offline   Reply With Quote
Old 07-14-2012, 11:40 AM   #10
phillymummer
DIS Veteran
 
phillymummer's Avatar
 
Join Date: Jun 2012
Location: New Jersey
Posts: 693

That is pretty awesome but my head spins just looking at!

I don't know if I know enough abouut the dining plan and other costs to fill that out!
__________________
April 1987, April 1990- Off-site, with family.
May 1993 Off-site, Senior Class Trip!
Oct 2010 POR- First trip as an adult

Oct 2012 POFQ- First trip planned all by myself (and with plenty of help from The Dis!)
Next trip- Nov 2015 to MK and Universal!
phillymummer is offline   Reply With Quote
Old 07-14-2012, 11:52 AM   #11
oceanwave
Mouseketeer
 
oceanwave's Avatar
 
Join Date: Aug 2011
Posts: 203

Thanks for sharing this

Can't wait to play around with it!
__________________
ME DH

September 2012 - POFQ
September 2011 - Coronado Springs

Sep/Oct PTR
oceanwave is offline   Reply With Quote
Old 07-14-2012, 12:00 PM   #12
phillymummer
DIS Veteran
 
phillymummer's Avatar
 
Join Date: Jun 2012
Location: New Jersey
Posts: 693

I downloaded the program and I noticed your information is in both files. Obviously I should change the information about number of nights and people, and the room rack rate but can I keep the DP prices?

We are going in Oct of 2012 and have the free DDP (staying at POFQ)
__________________
April 1987, April 1990- Off-site, with family.
May 1993 Off-site, Senior Class Trip!
Oct 2010 POR- First trip as an adult

Oct 2012 POFQ- First trip planned all by myself (and with plenty of help from The Dis!)
Next trip- Nov 2015 to MK and Universal!
phillymummer is offline   Reply With Quote
Old 07-16-2012, 01:13 PM   #13
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, 02:42 PM   #14
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-17-2012, 12:33 AM   #15
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
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:37 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: