ABCDEFGHIJKLMNOPQRSTUVW
1
2
Disney Tiered Tickets - Possible Savings By Shifting Start DateLast Date with a Ticket Price:12/30/1899
3
PLEASE BE AWARE I NOTICE I HAVE SOME INCORRECT TICKET PRICES WITH THE NEW UPDATE, I HOPE TO FIX SOON
4
Ticket Start DateTier Price Color CodeNotes
5
StartEndSub ValueThis is a first attempt at working with the new tiered ticket prices directly from Disney. You can enter info in the RED CELLS at left.
*Be sure to enter the first date you intend to actually use your tickets.*

For comparison below you will see the total ticket cost for your selected date as well as what the cost would be if you started on surrounding start dates.

The green bar shows you the use window for the days you can use your tickets from the starting date you entered. (That window size now changes depending on how many days your tickets are for.) The orange bar shows you the potential use window for the maximum amount you could shift your start date back and still have enough days in your window to use all days on your ticket without actually changing your travel days.

In some cases you might save some money by selecting a start date earlier than the first day you actually intend to use your park tickets. The amount you might save (or lose) depends on when during the year you are traveling since ticket prices rely upon the pricing tiers of the days within your use window.
(Negative) amounts in the (Savings)/Loss row are the amount you would save if you shifted your start date to that day. Positive amounts means it that shift would cost you more.
*All amounts include taxes.*
6
3/4/20213/7/2021Value
7
Regular
8
Ticket Type
Park DaysWindowPeak
9
Base47Super Peak
10
11
Tickets NeededSee the Quick Reference tab below for basic info on using the sheet.
12
AdultChild
13
40
14
15
16
Furthest Date Disney Tickets Prices Available:12/30/1899
17
Selected DateWDW Tickets
18
19
Trip Day:-5-4-3-2-11234567891011121314
20
DateNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo DataNo Data
21
Total Ticket(s) Cost#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
22
(Savings)/Loss By Shifting
23
24
Use Window
25
26
From Selected Start Date
27
28
From Earliest Possible Date
29
30
Disney Total Ticket Cost for Party
31
Additional cost to add this number of park days to tickets for selected start dateUsing Start Date
32
123456789BasePHPH+
33
#N/A#N/A#N/A#N/A#N/A#N/A #N/A#N/A#N/A
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
This section used for conditional formatting dates above - Google Sheets won't let you format based on values in another sheet, Rassin Frassin Sheets.
49
Tier for Dates Above
#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
50
51
52
53
54
55
BELOW IS IN TESTING - for 1 ADULT ONLY
SOMETHING NEEDS FIXING BELOW - NOT DONE YET
56
Below is Copy of info aboveCost to Add this number of park days using Selected Date & Park Days Above
57
Start
Ticket Type
Park Days
58
3/4/2021Base4123456789
59
#N/A#N/A#N/A#N/A#N/A#N/AOver MaxOver MaxOver Max
60
61
Increase Cost Before Tiering:
$16$27$37$48$59$69
62
(This bottom part only looks up tix of increasing to 4 days or greater because I did not track 1 or 2 days tix before tiers)
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80