The Spreadsheet Smokescreen: When Fiction Becomes the Forecast

The Spreadsheet Smokescreen: When Fiction Becomes the Forecast

‘); background-size: 200px; opacity: 0.8; pointer-events: none; z-index: 0;”>

Dry air usually signals a coming storm, but in the boardroom on the 19th floor, it just signaled that the HVAC had finally given up on the 49 people trapped inside. I watched my manager’s index finger hover over the mouse. He was looking at a deal in our CRM-a massive account we had been chasing for 9 months. The current probability was set at 19%, which was the honest assessment. The client hadn’t returned a call in 29 days. But the board meeting was in 9 minutes, and the ‘Expected Revenue’ column was looking dangerously thin. With a click that sounded like a dry twig snapping, he changed the 19% to 89%. Suddenly, the dashboard turned a lush, grassy green. The collective sigh of relief in the room was audible, a soft hiss of escaping tension that masked the terrifying reality: we had just committed to a lie.

We live in an era obsessed with the ‘Predictable Revenue’ model, a concept so seductive that it has become the bedrock of modern corporate theology. We want the world to behave like a Swiss watch, where every turn of the marketing gear leads to a precise movement of the sales hand. We demand that our employees forecast their output for the next quarter with 95%-pardon me, let’s say 89%-accuracy, despite living in a global economy that fluctuates every 9 seconds. It is a demand for mathematical certainty in a world governed by the messy, irrational, and wonderfully unpredictable nature of human beings. And because we demand the impossible, we have forced our workforce to become masters of fiction.

Data Precision

Human Variable

Fiction’s Cost

I recently spent 19 hours attempting to explain the nuances of decentralized finance and cryptocurrency to my uncle. It was an exercise in frustration because he wanted to know the ‘guaranteed’ return. He kept asking for a spreadsheet that would show him exactly what his wallet would look like in 29 months. I tried to explain that crypto is a consensus-driven reality, much like our modern corporate forecasts. It only works as long as everyone agrees to believe in the same set of numbers, regardless of what the underlying assets are actually doing. In the corporate world, our ‘assets’ are the relationships we build, but we treat them like fixed code in a smart contract. We forget that people change their minds, budgets get frozen by 9 different committees, and global pandemics can shut down entire industries in 99 hours.

The Game of Predictability

Simon P.-A. understands this better than most, though he doesn’t work in sales. Simon is a video game difficulty balancer, a man whose entire career is spent at the intersection of math and frustration. He once told me about a level he designed where a boss character had 199 health points. In testing, 79% of players would quit the game at that exact moment. On paper, the math was perfect. The player had the tools to win. But the ‘human variable’-the fatigue, the sweat on the controller, the 29 preceding minutes of tension-meant that the players weren’t behaving like the variables in his spreadsheet. Simon P.-A. had to learn that to make the game feel ‘fair’ and ‘predictable,’ he had to intentionally build in buffers for human error and irrationality. Corporate forecasting does the exact opposite. It removes the buffers and assumes every salesperson is a perfectly optimized bot running 29 hours a day without a break.

Friction

19%

Likelihood of Failure

vs

Automation

89%

Projected Success

This obsession creates a peculiar kind of psychological rot. When you are forced to forecast with 89% accuracy, and you know you can’t, you don’t work harder-you just learn to hide the truth better. You start ‘sandbagging’ deals, hiding them in your pocket until you need them to cover a gap. You inflate the value of a contract by $9,999 just to hit a threshold. You spend 39% of your week managing the perception of your work rather than doing the work itself. We have created environments where the map is more important than the territory. If the map says we are going to hit our targets, we celebrate, even as we walk off a cliff because the territory has shifted under our feet.

99%

Unpredictability

The Map vs. The Territory

“The spreadsheet is not the business; it is a map of our collective anxieties.”

I’ve made this mistake myself, more times than I care to admit. I once spent 9 weeks building a model that I swore would predict our lead flow with a variance of only 9%. I felt like a god of data. I had accounted for seasonality, for the 29 different channels we were using, and even for the average coffee consumption of our SDRs. Then, a competitor launched a surprise feature on a Tuesday morning, and my lead flow dropped by 69% overnight. My model was beautiful, elegant, and completely useless. I had focused on the precision of the numbers rather than the resilience of the system. I had fallen in love with the fiction of control.

This is where most consulting firms fail. They come in with a 159-slide deck and tell you that if you just follow their ‘proprietary 9-step framework,’ your revenue will become a straight line pointing toward the heavens. They sell the dream of the ‘unbreakable’ forecast. But the reality is that the more you try to force predictability, the more unpredictable your environment becomes. People become stressed, the quality of the data degrades as everyone starts ‘massaging’ their numbers, and the culture shifts from one of curiosity to one of fear. You end up with a company that is technically hitting its ‘forecasted’ milestones but is actually hollowing out from the inside.

💡

Vulnerability

⚙️

Robust Systems

⚖️

Reality over Hope

There is a better way, though it requires a level of vulnerability that most C-suite executives find terrifying. It involves admitting that we don’t know everything. It involves building systems that prioritize reality over projections. This is the philosophy embraced by b2b marketing experts, who understand that genuine predictability doesn’t come from forcing employees to lie on a spreadsheet. It comes from building a robust, transparent engine that acknowledges the volatility of the market. It’s about creating a ‘system of record’ that actually reflects what is happening on the ground, rather than a ‘system of hope’ that reflects what the board wants to see in their Q3 report.

Empathy in Numbers

Simon P.-A. often says that the hardest part of his job isn’t the math-it’s the empathy. He has to put himself in the shoes of a frustrated player who has failed 19 times in a row. He has to understand the emotional reality of the person behind the screen. Business leaders need to do the same. When we look at a sales rep who is struggling to hit an arbitrary 89% accuracy target, we shouldn’t just see a failing variable. We should see a person trying to navigate an increasingly complex and chaotic marketplace. We should ask what the data is actually telling us about the world, rather than what we want the world to tell us about our data.

2020

Project Started

2023

Major Milestone

2024

Honesty Introduced

I remember one specific QBR-Quarterly Business Review-where I decided to be honest. I was 29 years old and far too confident for my own good. I stood up and told the room that our forecast for the next 9 months was essentially a work of speculative fiction. I pointed out that 49% of our ‘committed’ deals had no clear path to closing based on current market trends. The silence in the room lasted for what felt like 59 minutes, though it was probably only 9 seconds. My boss looked like he wanted to vanish. But then, the CEO did something unexpected. He laughed. He admitted that he had known it was a fiction all along, but he didn’t know how to stop the cycle. That one moment of honesty allowed us to actually fix the underlying issues in our sales process rather than just continuing to paint over the cracks.

The Psychology of Lies

We have to stop treating the spreadsheet as a holy relic. It is a tool, and a blunt one at that. When we demand 89% accuracy in an unpredictable world, we aren’t being ‘data-driven.’ We are being ‘delusion-driven.’ We are creating a culture where the truth is a liability and the lie is a survival strategy. The psychological toll of this is immense. It leads to burnout, to a lack of trust between departments, and to a general sense of cynicism that can take 9 years to wash away. We are essentially asking our employees to live in a state of cognitive dissonance, where they see the reality of the market but are forced to report the fantasy of the forecast.

Truth Reporting

19%

19%

Forecasted Accuracy

89%

89%

Consider the way we talk about ‘pipelines.’ We use the language of plumbing, as if revenue is something that just flows through a pipe if you apply enough pressure. But a pipeline doesn’t have feelings. A pipeline doesn’t get nervous when it has to ask for $499,000 in the middle of a recession. A pipeline doesn’t have a child who stayed up all night with a fever. By using this industrial language, we dehumanize the process and make it easier to demand the impossible. We forget that every ‘lead’ is a person and every ‘deal’ is a decision made by a human heart, not just a human brain.

The Path to Resilient Reality

If we want real predictability, we have to start by valuing the truth. Even the ugly truth. Especially the ugly truth. We need to reward the salesperson who admits a deal is at 19% risk, rather than the one who lies and says it’s at 89%. We need to build systems that are flexible enough to handle the 29% variance that is inherent in any human endeavor. We need to stop chasing the ghost of ‘absolute certainty’ and start building for ‘resilient reality.’

🌱

Value Truth

🔄

Flexible Systems

🌳

Resilient Reality

I still catch myself looking at my own projects and wanting to round the numbers up. I want to believe that the 199 people who signed up for my newsletter will all become loyal readers. I want to believe that my 9-step plan for the week will go off without a hitch. But then I remember Simon P.-A. and his boss character with the 199 health points. I remember that the human element is the only thing that actually matters. The numbers are just the shadows cast by the people we serve. If the shadows look distorted, it’s not because the math is wrong-it’s because we are standing in the wrong light.

Embracing the Unpredictable

As I look back on that afternoon on the 19th floor, I realize that the green dashboard didn’t save us. We missed our targets that quarter by 39%. The lie didn’t change the outcome; it only changed how we felt until the moment of impact. We could have used those 9 weeks to pivot, to find new markets, or to support our team. Instead, we used them to polish a fiction. We are so afraid of the unpredictable that we choose a predictable failure over a chaotic opportunity. It is time to put down the red pen, stop trying to turn the 19% into 89%, and finally start dealing with the world as it actually is, in all its messy, 99-percent-unpredictable glory.

99%

Unpredictable Glory