Why More Data Won't Fix Your Biggest Decisions

You have the spreadsheet open. Options across the top, criteria down the side. Salary. Commute. Growth potential. Benefits package. Maybe a weighted column because you watched a YouTube video about decision matrices once.

You built this thing because you have two job offers and this is how you make good decisions. You gather information. You compare. You let the numbers point you toward the right answer, the same way they pointed you toward the right laptop and the right health insurance plan. The spreadsheet has worked before. It should work now.

But you've been staring at it for two weeks and you still can't pick. You keep adding columns. You keep adjusting the weights. You keep rereading the offer letters and running new salary calculators, because surely the problem is that you don't have enough data yet. One more variable and it will all click.

It won't. The spreadsheet is not broken. The approach is.

The Research on Why Analysis Fails for Complex Decisions

There is a well known study from the University of Amsterdam where researchers asked people to choose between apartments. One group was given time to carefully analyze the options. The other group was distracted with puzzles and then asked to choose based on gut feeling.

For simple decisions (apartments with one or two clear differences), the analytical group did fine. For complex decisions (apartments with many competing tradeoffs), the distracted group consistently chose the option they were happier with later.

The people who thought less made better complex decisions than the people who thought more.

This result has been replicated and debated for twenty years, but the core finding holds up: conscious analysis works well when variables are few and measurable. When you are comparing phone plans, spreadsheet away. But when the variables multiply and start to interact with your emotions, your values, your sense of who you are, the analytical brain loses its advantage.

Your brain's unconscious processing can weigh dozens of factors simultaneously in ways your conscious mind cannot track. The gut feeling you've been trained to distrust is often the product of more computation, not less. It's your brain telling you something it can't put into a spreadsheet column.

The decision matrix was designed for problems with clear inputs and measurable outputs. Choosing where to take your career is not that kind of problem.

What the Spreadsheet Is Actually Doing

Here's what is really happening when you build a decision matrix for a major life choice: you're converting an emotional question into a technical one because the technical question feels safer.

"Which job pays more?" has an answer you can research. "Which job will make me a different person in five years?" does not. The spreadsheet lets you spend hours on the first question so you never have to sit with the second one.

The spreadsheet is not a decision tool. It's an avoidance tool dressed in the language of responsibility.

And it works, for a while. You feel productive. You feel rigorous. You can point to the color coded cells and say "I'm being thoughtful about this." Nobody argues with a person holding data. Data looks like control.

But control is exactly what you don't have. You cannot predict whether the company will restructure next year. You cannot calculate whether you will still care about the same things in three years. You cannot assign a numerical weight to the feeling you get when you walk into an office and something in your chest says yes or says no.

The markers you're measuring (salary, title, commute) are real. They matter. But they are circumstances, not identity. A person can have the highest scoring job in the spreadsheet and still end up hollowed out by it. The spreadsheet measures the container. It tells you nothing about what will happen inside it.

The Comfortable Lie of Optimization Culture

This belief runs larger than one spreadsheet. It's the operating logic of an entire generation of professionals: if I gather enough information and process it correctly, I can eliminate risk from my life.

You see it in the person who spends six months researching the perfect mattress. In the couple who reads forty articles before choosing a preschool. In the employee who builds a pros and cons list for every job offer, weighting each factor to two decimal places, then agonizes for weeks anyway because the numbers keep coming out close.

More information does not produce more certainty. Past a point, it produces more doubt. Each new data point introduces a new variable to weigh, a new tradeoff to consider, a new reason to hesitate. You aren't getting closer to confidence. You are burying it under spreadsheet rows.

The optimization mindset promises that good outcomes are manufactured by good process. That the right inputs guarantee the right outputs. That life, at scale, is an engineering problem.

It isn't. The most important things that will happen to you will arrive through timing, through relationship, through accident, through the kind of knowing that lives in your body and not in a formula. No amount of analysis would have predicted which friendships would define your life, which job would change your direction, which Tuesday afternoon would turn into the memory you carry forever.

What Works Instead of More Analysis

You probably don't need more data. You probably need ten minutes of silence and an honest answer to a question you've been avoiding.

Try this: close the spreadsheet. Sit somewhere without your phone. Ask yourself the real question underneath the research. It usually sounds something like "Am I scared?" or "What am I afraid will happen if I choose poorly?" or "Do I actually want this, or do I want to want it?"

The answer that arrives in your body before your brain can intercept it is usually the one that matters.

This does not mean throw away all analysis. Check the commute. Verify the benefits. Make sure the company is solvent. Practical due diligence is real and useful. But once the practical questions are answered, notice whether you're still researching. If you are, you're probably not looking for information anymore. You're looking for permission. And no spreadsheet is going to give you that.

The permission to choose. The permission to be off by a mile. The permission to make a decision that cannot be optimized, only lived.

---

In Crushed Between, a man named John builds exactly this spreadsheet: a color coded decision matrix for apartment hunting with his girlfriend Rachel, neighborhoods ranked and weighted and scored, while the actual weight of what they're doing together goes unmeasured. In the same chapter, a stranger's last words suggest that every marker of control John is tracking can vanish, that the spreadsheet and the girlfriend and the Saturday apartment showings are circumstances he holds, not things he is.

The fiction follows that gap between the life you can measure and the life you actually live, into territory an article like this one can only point toward.