Robinb's and Tricia1972's DDP Planning Spreadsheets!

Discussion in 'Disney Dining Plan' started by robinb, May 28, 2009.

Thread Status:
Not open for further replies.
  1. robinb

    robinb DIS Veteran

    Joined:
    Aug 29, 1999
    Messages:
    31,488
    Hi everyone! I don't know if this is still in the sticky, but I came up with ae excel spreadsheet a while ago to help plan your TS/CS meals on the DDP. Sorry, but I cannot convert it to another type of spreadsheet ... my Excel program is pretty old.

    Here it is:
    http://personalpages.tds.net/~rb/DIS/MYW%20Dining/MYM-Dining-Planner.xls

    And of course, there is my "bang for your buck" Restaurant Ranking page which includes the top-25 TS and CS restaurants by price per credit:
    http://personalpages.tds.net/~rb/DIS/MYW%20Dining/2009/DisneyDiningRanking2009.htm

    I also host on my ISP another DDP planning spreadsheet by our very own Tricia1972 which helps you determine which is better: paying out of pocket or the DDP.

    http://personalpages.tds.net/~rb/DIS/MYW%20Dining/DisneyDining%20Template%202009.xls

    Enjoy and happy planning!
     
  2. Avatar

    Google AdSense Guest Advertisement


    to hide this advert.
  3. dolphinmatt

    dolphinmatt Earning My Ears

    Joined:
    Apr 21, 2009
    Messages:
    36
    Wow! This is amazingly helpful. Thank you for taking the time to do this. This is exactly what I needed to plan this trip out.
     
  4. B&WMickey

    B&WMickey DIS Veteran

    Joined:
    Dec 30, 2002
    Messages:
    533
    Incredible!!!! Great Work!!!!!!
     
  5. 2manypets

    2manypets DIS Veteran

    Joined:
    Jan 28, 2005
    Messages:
    2,234
    Ooohhhh, I love spreadsheets. :lovestruc Thanks for the hard work!
     
  6. bek1758

    bek1758 Mouseketeer

    Joined:
    Mar 12, 2009
    Messages:
    108
    I just downloaded your spreadsheets. They are awesome, thanks for taking the time to share with us!
     
  7. grumpysmrs

    grumpysmrs Mouseketeer

    Joined:
    Mar 24, 2007
    Messages:
    237
    :worship::worship::worship::worship:

    We have a last minute trip. This makes it sooo much easier.
     
  8. csmommy

    csmommy <font color=purple>DIS Veteran<br><font color=red>

    Joined:
    Jan 17, 2003
    Messages:
    1,785
    This is REALLY cool! But I must be thick :lmao:

    I get both of Robinb's sheets, but Tricia1972's has me confused. Am I supposed to enter in what we think we will be ordering? Sometime's I just need my hand held.................................:grouphug:
     
  9. CowboysButterfly

    CowboysButterfly Earning My Ears

    Joined:
    Aug 10, 2009
    Messages:
    21
    Thank you so much for this. I am planning our vaca for next June and my Mom and I are traveling with my sona and his friend, both teenagers, this will help me figure out which DDP, if any, are best for us.
     
  10. yooperfan

    yooperfan Hi HO, hi ho, it's off to work we go

    Joined:
    Jul 4, 2000
    Messages:
    2,250
    I'm a hands on kinda person and print everything I read (drives DH nuts!).
    When I try to print top Restaurants value per credit It will only print Table service and first line of counter service. The other 2 links just print out a gray sheet with nothing on it. Any suggestions?:confused3
     
  11. beroh2253

    beroh2253 Love Dixie Landings(POR)

    Joined:
    Mar 24, 2007
    Messages:
    2,830
    Great thanks we just booked restaurants for last week in Oct. today.
     
  12. MarkinNM

    MarkinNM NO SOUP FOR YOU!!!!

    Joined:
    May 28, 2003
    Messages:
    2,413
    WOW, those are pretty cool, THANKS!
     
  13. CMG1

    CMG1 Mouseketeer

    Joined:
    Apr 8, 2008
    Messages:
    87
    These have been so helpful in planning our meals for our trip in December! Thanks so much for sharing! :thumbsup2
     
  14. ktkerber

    ktkerber Mouseketeer

    Joined:
    May 1, 2004
    Messages:
    345
    I am having trouble printing the top 25 spreadsheet as well. Maybe because it is a .htm file type instead of .xls like the other 2.

    Thank you for sharing these with us.

    Kristen
     
  15. robinb

    robinb DIS Veteran

    Joined:
    Aug 29, 1999
    Messages:
    31,488
    You're right. When you print an HTML page you only print what is on the screen and not the whole page. You will have to scroll to the lower half of the page and print it out too to get the whole thing. Sorry!
     
  16. LBelle

    LBelle <font color=green>I'm soooo jealos<br><font color=

    Joined:
    Jul 7, 2006
    Messages:
    11,678
    This is fabulous, Robin! I'll be using for sure. Thanks so much for helping. :hug:
     
  17. bgsnmky

    bgsnmky DIS Veteran

    Joined:
    Dec 8, 2006
    Messages:
    868
    I am trying to figure this one out too...hopefully someone can help.

    It looks like it is calculating how much the dining plans would cost. But then do we add in what we think we would SPEND without the dining plan...at the top.


    But the snacks are not there.

    If I enter 8 CS meals at 13.00 a piece I get 124.00 but the QSDP costs 287, but that includes snacks and drink mug etc.
     
  18. Cherinva

    Cherinva Co-Host of the Va. DIS Meet and avid pin collector

    Joined:
    Oct 24, 2007
    Messages:
    5,968
    This is very helpful...many thanks.
     
  19. robinb

    robinb DIS Veteran

    Joined:
    Aug 29, 1999
    Messages:
    31,488
    Tricia does include the "snack value" in her calculations at $3 per snack. That's a pretty good average as some snacks are more and some are less.

    BTW, I found a bug in Tricia's spreadsheet. The QS plan does not calculate properly. I think that Tricia sent me a fix for it but it never got on my ISP. I'll fix it and post it later today :).
     
  20. robinb

    robinb DIS Veteran

    Joined:
    Aug 29, 1999
    Messages:
    31,488
    OK ... I have made the changes to Tricia's spreadsheet. Her initial analysis was to compare the DDP with the "Tables in Wonderland" (previously the "Disney Dining Experience") discount and that discount was calculated automatically. That skewed the calculations to favor paying OOP. I changed the spreadsheet to use a Y/N field to designate if you have the TiW discount (available to AP holders and FL residents). It can be found in the yellow fields above the "Grand Totals" section. If enter "Y" into the field a 20% TiW discount will be calculated for all TS meals/appeitizers. You may also hand-enter the TiW discount for the few CS restaurants where it is available (like at the Value resorts).

    Have fun and let me know if I messed something up!
     
  21. Donna3271

    Donna3271 DIS Veteran

    Joined:
    Jul 5, 2008
    Messages:
    1,325
    Robin,

    You are amazing!!! This is so awesome!! Thank you so much!
     
Thread Status:
Not open for further replies.

Share This Page