Cheat Sheet: Worth it to Upgrade to AP?

…Well, now I see Boardwalk’s prices dropped back down after a jump earlier this week too. Hmm, fixing my spreadsheet.

Do you know if tickets tend to be cheaper at different times of the year? We are not going until the end of October. So, we have time to wait if tickets have better sell dates at different times.

I’ve thought about going back through all of my sheet’s revisions and seeing if there were any pattern to the prices, but that will take some work and I just haven’t had the time.

From my general feeling after updating this sheet for 18 months or more: Most of the time the prices for each vendor tend to swing up and down only a few dollars over the course of a month or two.

Not sure if it is their supply/demand or just trying to out-maneuver each other. (Probably both.)

Once in a while there is a special sale that can pop up, but they are few and far between. Last year or so was one from UT where they got hold of a bunch of older non-expire tickets and sold them at a super discount. But, that only lasted a day or so before they sold out.

If you keep an eye on the TP chat, usually one of us will post a message if something good appears. Alsom sign up for the resellers’ mailing lists if they have one.

When I bought ours for our August trip last year I held out until my FPP day arrived and then bought the tix. IMHO doesn’t hurt to wait at this point unless Disney is planning a mid-year increase (which may happen if they start tiering all of the tickets), but that’s speculation.

And usually the resellers have a lag time where their prices don’t jump up until a week or more after Disney jumps.

This is a whole different animal than just finding good ticket prices, but if you haven’t looked into it already, you can try to save more money by using credit card travel reimbursements -

I wrote a whole post on using BarclayCard sign on bonus rewards to get $1200 in savings for our tickets last year. The good news is that Undercover Tourist tickets code as travel and you can use the reimbursements on them. The name of that post is Pre Trip Report or How I Embraced Credit Card Rewards and Learned to Love Them

1 Like

Thanks so much for all the great information. You have been extremely helpful

1 Like

Quick note to the Worth It to Upgrade to AP? spreadsheet: I’ve finally gotten around to adding the vendor Get Away Today to the ticket prices in it.

Get Away Today was already in my Maximum Savings sheet, but because changing conditional formatting ranges in Google Sheets is fairly tedious (and named ranges do weird things), I put off doing it over here.

Doesn’t really mean too much of a difference here except some slight variation in what the sheet thinks the best ticket prices may be if GAT has the lowest, but… onward and upward!

Thank you so much for sharing this. So unbelievably helpful. Question though…I am planning 1 short, short trip with just a 2 day park ticket. Is there a reason you don’t include a 2 day option? Is it just because you have to buy those tickets directly from Disney? Or have I missed something on how to figure in that type of trip?

You are welcome!

I don’t include them because 1 and 2 day tix are normally not discounted at all, plus you have to worry about the tiered pricing based on the date. (Originally because I created all of this logic in my Maximum AP sheet and just haven’t changed it here.)

It hasn’t come up too often since most people seem to do get at least 3 day tix and to be honest I didn’t want to have to bother with the whole tiering logic thing. :wink:

But, with the rumor that The Disney is going to tier all tickets soon, I’ll probably just have to take it all into account soon anyway.

In any case, I just added something to the sheet that should help you: Next to the ticket price column in the sheet now is a “Tix Price Override” column. If you enter an amount on any of those lines, the sheet will use that override amount, no matter what number of park days or ticket type you enter on the left.

Let me know if that works for you! Below is a screen shot:

1 Like

Wow! Double thank you. This is a perfect solution.

Hey @JJT, just ran some numbers on this. It is showing advance purchase of Memory maker as $339. Am I doing something wrong?

Nope, not doing anything wrong!

Check out my Notes box on the right side: “If you choose a Memory Maker purchase option that cost will be counted once for EACH trip you enter below.”

The idea is if you are people who normally buy MM, then it assumes you’d buy it each trip.

If you trying out the sheet with multiple trips, but only expect to buy MM one time, you could just select “No” for MM and add $169 to your overall savings.

(Awhile back I toyed with putting a MM selector on each trip line, but the more bells and whistles you add, the more confusing it makes things.)

Ah, well that makes sense! Thanks for clarifying!

Someone on another thread was looking to figure out their possible AP savings if just buying the AP directly from Disney, and I realized my sheet had some issues that didn’t make that scenario easy to do.

So… UPDATE time. I made some changes as outlined below (duplicate info from the other thread if you were reading that one as well.)

Think I really need to make a YouTube going over this sheet so people understand all of the bells and whistles.

All righty, so long story not so short, I realized that after I told someone they could enter the Disney AP price in the override column of my sheet, a couple of formulas would not take into account the amount paid vs savings correctly.

After trying to fix them, my formula logic got complicated and I ran out of coffee. So I decided to just simplify:

There is now a box at the top marked “Buying Full Price AP Straight From Disney?” that you can set to “YES” and it will ignore any ticket bridging savings.

I should have thought of that earlier methinks, but didn’t have anyone mention that scenario and my brain didn’t thunk it. (Probably similar to my weird awareness thing that if something isn’t sitting in the usual place in our refrigerator or cupboard, my brain doesn’t see it. :smiley:)

Also, when fixing all of that, I also noticed an issue in how the sheet used the amounts in the ticket override boxes. I added those override boxes a little while back so people could enter actual prices they paid rather than have the sheet find the current highest discounted tickets.

Until today, if one used those override boxes the sheet didn’t look up the bridging savings properly and just used the maximum savings listed at the top of the sheet.

However, the sheet WAS using the total price paid correctly, so the difference in accuracy was likely only a small amount : the difference between the maximum savings at top and the actual savings if you entered an override ticket price. (Probably in the neighborhood of $20-$40 at most I’d guess.)

Below is a summary screen shot of this info which may make it more clearer.

I’ve made some updates to my Worth It to Upgrade to AP? spreadsheet: It now uses Disney online ticket prices instead of trying to find the cheapest reseller tickets to bridge.

(Maybe I’ll add that back when the process with new tickets is clearer.)

Google sheets now allows check boxes, so I took advantage & hopefully made the interface a bit cleaner to use. You can now select MM per trip, rather than have the sheet assume you are buying it all the time if you select it.

See the “How to Use This Sheet” tab at bottom for some step-by-steps on using it… here’s a screenshot for a quick peek.

All righty, since the tiered ticket pricing threw a sort of wrench into the mix last year, been awhile since I’ve updated some of my spreadsheets.

Today I modified one of my sheet to create a new AP Upgrade Bridging Estimator that works with the new tiered ticket price system. One modification I had to do was to require that users always enter the price they paid for their tickets, which isn’t too bad an thing to have to do.

(It became a full time job to keep up with all of the reseller ticket price deals since every day now had to follow a particular start date within a year.)

But, it still does what it used to - just enter your ticket type, days, start date, and how much you paid.
Enter the number of adult and child tickets you plan to upgrade.
If you already bought Memory Maker, select the type you purchased.

The sheet then creates a cheat sheet you can use to have as reference at Guest Seevices when upgrading to AP.

Some screen shots below, you can play with the sheet here.

1 Like

(I made some slight interface changes for clarity since those last screen shots. See the reference tab in the sheet for some newer notes.

I have a question on where you are pulling the Disney prices from. The spreadsheet price seems to be lower than the price I get when I add it to my cart direct at disney.com

Hi - Back when they created the tiers I took down Disney’s base prices for all of their posted days then figured out their method of calculating Base vs PH vs PH+.

Base tix for more than one day multiplies the 1 day price and then takes a particular % off for each number of days (took some playing around to figure that out.) But, PH and PH+ have been a simple additional amount added onto the base price.

PH was an additional even $75 added onto Base and PH+ was another $25 on top of that.

I just checked and saw the same few dollars difference you did as well: turns out they’ve suddenly started adding tax onto the $75 and $25 amounts. (In truth, not sure why they didn’t before!)

So, I’ve fixed my spreadsheet to reflect that new amount and should match the Disney site again. Thanks for the heads up!

2 Likes

After some discussion over on another thread, I added a bridging savings calculation back into this Worth It to Upgrade? sheet: If you enter what you paid at a reseller for your first trip’s tickets in the top box, it will calculate that savings again and take it into account for the bottom line savings/loss.

Note: If you enter a reseller price in the top box, you do NOT want to also enter an override ticket price in the row marked “Trip 1” or the amount saved will be off.) The bridging savings is calculated by subtracting the reseller amount you enter at top from the direct-from-Disney ticket price calculated in the “Ticket Cost” column for Trip 1.

I want to reiterate one note here: Since tiered pricing went into effect I have stopped using the Disney GATE price in bridging as it is not entirely clear to me that is still being used with any regularity. (If you are lucky and a CM does use gate price in bridging, it will mean an additional $21.30 in savings per ticket when bridging to AP.)

@JJT Thanks so much for this tool! Great work!

1 Like

Thank you!