Irin997
DIS Veteran
- Joined
- Jul 11, 2007
- Messages
- 1,637
After nosing around this Codes & Rates sub-forum and trying to plan my own trip, I developed an Excel spreadsheet that will help to compare the potential and/or available promotions.
Here is where to download the file:
http://sites.google.com/site/wdwplanningworksheets/promotion-package-comparison
A few notes and tips on this spreadsheet:
1) Please note that there are multiple tabs/worksheets named as the time periods that I am considering. Each is titled with the number of days and the time frame I am looking to go. There are worksheets for both 10 and 7 day trips as well as a summary of savings page to see an overview of how much you are actually saving with a promotion.
2) The only cells that need to be changed are the top cells:
a) Underneath "Week of" input your dates as a range.
b) Underneath "# of Nights" input the number of nights your will be staying.
c) Next to "Rack Room Rates" enter the total room only reservation rate for your specific time frame. As you know this can be found by going to the Disney Vacation website and searching for a room only rate.
d) Next to "Total Ticket Rate" enter the total ticket price for your time frame. Be sure to include the total price including Park Hopper and Water Parks & More price in the total price if that is part of your plan.
e) Next to each individual dining plan section, enter the total PER DAY dining rate for your party, NOT the total dining plan price for your stay. The formulas for the promotions utilize the PER DAY price.
Please let me know if you have any other suggestions, tips, etc. Thanks and again, Happy WDW Planning!
Here is where to download the file:
http://sites.google.com/site/wdwplanningworksheets/promotion-package-comparison
A few notes and tips on this spreadsheet:
1) Please note that there are multiple tabs/worksheets named as the time periods that I am considering. Each is titled with the number of days and the time frame I am looking to go. There are worksheets for both 10 and 7 day trips as well as a summary of savings page to see an overview of how much you are actually saving with a promotion.
2) The only cells that need to be changed are the top cells:
a) Underneath "Week of" input your dates as a range.
b) Underneath "# of Nights" input the number of nights your will be staying.
c) Next to "Rack Room Rates" enter the total room only reservation rate for your specific time frame. As you know this can be found by going to the Disney Vacation website and searching for a room only rate.
d) Next to "Total Ticket Rate" enter the total ticket price for your time frame. Be sure to include the total price including Park Hopper and Water Parks & More price in the total price if that is part of your plan.
e) Next to each individual dining plan section, enter the total PER DAY dining rate for your party, NOT the total dining plan price for your stay. The formulas for the promotions utilize the PER DAY price.
Please let me know if you have any other suggestions, tips, etc. Thanks and again, Happy WDW Planning!