All righty, so long story not so short, I realized that if you used my previous advice from last night 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. )
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’m also going to add this all to my Worth It? forum thread for posterity.