Opinion article based on Martin Soler’s linkedin post.
There is a common denominator among the elite tier of hospitality professionals, a shared trait that borders on the supernatural: I have never met a dumb revenue manager. These are people who can look at a digital wall of data and see the matrix, spotting a three-room-night trend in a secondary market before the local tourism board has even finished their coffee. But this high intelligence comes with a very specific, recurring side effect—the “Magic Formula” complex.
It always starts the same way. A brilliant revenue manager, tired of the limitations of the industry’s clunky legacy tools, decides to take matters into their own hands. They open a fresh Microsoft Excel workbook. At first, it’s just a few VLOOKUPs and some clever conditional formatting. But then, they find it. They discover the holy grail of yield—a proprietary, secret formula that perfectly balances occupancy and ADR. It is their masterpiece. It is their secret sauce. For a few glorious years, this revenue manager becomes a wizard, wielding a spreadsheet so complex that if they ever left the company, the entire department would likely collapse into a black hole of #REF errors.
But success is a double-edged sword. As our hero moves from managing one hotel to a cluster, then a region, the “Magic Formula” begins to groan under its own weight. The Excel document, once a nimble weapon of war, is now a bloated behemoth that takes twenty minutes to save and crashes if you look at it sideways. The very solution that made them a legend has become the enemy. It is holding back “Epic Scalability.”
This is the pivotal moment in the origin story of every Revenue Management System (RMS) on the market. The revenue manager looks at the wreckage of their CPU and says, “We shall build it. Something robust. Something real.”
They hire a development agency. They get a room full of coders to translate their Excel “mantra” into actual software. For a while, it’s a dream. The system is sleek, it’s fast, and it’s proprietary. But then the reality of software ownership sets in. Suddenly, you have four developers on the payroll, a mounting pile of server bills, and a desperate need for data analysts. The internal tool has become an expensive mouth to feed.
The only logical move? Monetize. You decide to package your secret sauce and sell it to the world. You aren’t just selling software; you’re selling a philosophy. You are the “Excel Killer,” the one who has finally solved the riddle of the market. You head into the world convinced that every other revenue manager is waiting for you to liberate them from their spreadsheets.
The problem, however, is that every other revenue manager is also a genius. And every single one of them has their own secret sauce.
When you walk into a meeting with your revolutionary system, you aren’t meeting a blank slate. You’re meeting someone who has spent fifteen years perfecting their own ritualistic Excel sheet. To them, your “Magic Formula” isn’t a solution—it’s an intrusion. Why would they adopt your religion when their own gods have served them so well? They look at your sleek interface and think, “That’s nice, but does it account for the third-Tuesday-of-the-month wedding market in East Yorkshire like my Macro does?”
This is the eternal stalemate of the industry. We are a field populated by prophets, each clutching a laptop and claiming to have the only true path to 100% RevPAR index. Every new software claims to be the death of the spreadsheet, yet Excel remains the most resilient cockroach in the tech stack.
In the end, most revenue managers don’t actually want an “Excel Killer.” They want a data-gathering tool that does the heavy lifting so they can export it all back into their own “secret” spreadsheet. We’re all just looking for automation that respects our individual genius. And honestly? With this many “perfect” formulas running at once, it’s a wonder there’s any money left on the table at all.
How’s your secret sauce tasting today? Is it time to build an app for it, or are you still adding “one last tab” to the workbook?
