Cafeen
DIS Veteran
- Joined
- Jul 24, 2009
- Messages
- 4,852
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...
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
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...)
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...)