It started because I almost booked a "deal" that was $99 a night but had a $45 resort fee I didnt notice untill checkout. My wife looked at me like I'd tried to pay for groceries with Monopoly money. So I did what any normal person does when they've lost trust in there own judgment: I built a spreadsheet and swore an oath to obey it.
What does a spreadsheet actually optimize for?
Cost-per-night after all fees, which is the number resorts hope you never calculate. My sheet had five columns: sticker price, number of nights, resort fee per night, presentation length, and a yes/no for whether breakfast was included. Then one formula spit out the real per-night cost. Suddenly a $149 Cancun all-inclusive looked like a screaming deal and a $89 "budget" motel looked like a trap, because the all-inclusive had no daily fees and the motel had three.
The results, ranked by my cold robot overlord
Here's what the spreadsheet chose across a month of me feeding it real listings. Notice it does not care about my feelings, the pool photos, or how much I wanted to go to the beach.
| Deal | Sticker | Nights | True $/night after fees |
|---|---|---|---|
| Vegas vacpack | $49 | 3 | $16 |
| MRG Orlando | $97 | 4 | $24 |
| Cancun all-inclusive | $149 | 3 | $50 |
| "Budget" motel + fees | $89 | 2 | $67 |
COST-PER-NIGHT AFTER FEES IS THE ONLY NUMBER
Why did the spreadsheet keep picking timeshare vacpacks?
Because their sticker price is artificially low in exchange for a presentation, which the spreadsheet treats as a fixed time cost rather than a money cost. Once I added a column for "presentation minutes" and mentally priced my time at a reasonable hourly rate, the vacpacks still won by a mile. A 90 minute presentation to save $200 on a stay is, in spreadsheet terms, one of the best hourly rates you'll ever earn. Even if you value the annoyance heavily, the math holds.
The fee column that changed everything
The resort-fee column is where trips are secretly won and lost. A daily resort fee of $35 to $50 quietly turns a great sticker price into a mediocre one, and it never shows up in the headline. My spreadsheet forced me to hunt for it every time. Sometimes I'd have to dig into the fine print, sometimes I'd just assume the worst and pad the number. Either way, once fees were in the formula, the rankings shuffled hard, and the deals that looked flashy fell to the bottom.
What the spreadsheet got wrong
It has no idea what a place is like. The sheet sent me to a technically-optimal stay that was next to a highway on-ramp, and it also nearly skipped a Gatlinburg cabin trip that turned out to be the best weekend of the year because the per-night math was "only okay." So I added one human column: a 1-to-5 "do I actually want this" score, and only let it break ties. Robots are great at cost. Their bad at joy. You need both.
Would I recommend letting a spreadsheet plan your trips?
Yes, if you use it as a filter and not a dictator. The spreadsheet's real gift wasnt the final pick, it was that it made every hidden cost visible before I paid. I now do a 60-second version in my head for every deal: nights, fees, presentation, is breakfast real. If you want to run your own experiment, the deals under $100 list and the 3-night packages page are a great data set to start ranking, and comparing them against rate recap numbers shows you how far below retail these actually sit.
The presentation column that changed how I value my time
The smartest thing I added was a column that converted the 90-to-120 minute presentation into a dollar figure, so I could compare it apples-to-apples with the savings. Heres how it works: if a vacpack saves me $200 versus booking the same room retail, and the presentation costs me 90 minutes, thats an effective hourly rate of over $130 an hour to sit in a chair and say no. I dont make $130 an hour doing anything else, so the spreadsheet flags every single one of these as "take it." The math is almost embarrassing once you see it written down. And it reframed the presentation entirely for me, its not an ordeal, its a paid task with the best hourly rate on my calendar.
The column also stopped me from overvaluing my own annoyance. I used to think "ugh, 90 minutes of sales pitch" and mentally price it like an hour of dental work. But when the number is right there next to the savings, the emotion drains out of it. Even if I pad the discomfort heavily, the vacpacks still win. That HGV Vegas deal, $249 against a retail rate near $915, works out to an hourly rate so high the spreadsheet basically drew a little celebration around it. Cold math turned a chore into a bargain, and me and my wife stopped dreading the presentations entirely.
My spreadsheet is now 340 rows long and I love it more than some relatives. If you want to feed yours some fresh inputs, go browse the current vacation deals and let cold, beautiful math tell you where to go.