The Quiet Rebellion: Agency Over Automation

Three weeks into using it, Cameron went back to a spreadsheet he built in 2002. Why? Because the PLM tool required him to click through five different menus just to change the quantity of floorboards. In his spreadsheet, he just types a number and hits enter. The ‘official’ system was a cage. The spreadsheet was a tool. Cameron realized that his creativity was being stifled by the very system designed to manage it. He needed the flexibility to change his mind, to experiment, and to see the entire landscape of his data at once, not through the narrow keyhole of a ‘user-friendly’ interface that treats the user like a child who can’t be trusted with a formula.

This isn’t just about software; it’s about the human need for agency. When we export data to a spreadsheet, we are reclaiming our right to see the raw materials of our work. A database is a black box; a spreadsheet is a pile of clay. You can shape it, you can break it, and you can see where the seams are. The ‘single source of truth’ is a myth because ‘truth’ in business is rarely a static number. It’s a conversation. It’s a context. By the time the data reaches the dashboard, it has been sterilized, aggregated, and stripped of the very nuances that make it useful for decision-making.

“I hated the software more than I feared the error. The software was an adversary. The spreadsheet, despite its lack of ‘security features’ and ‘audit trails,’ was my only ally.”

I once made a mistake-a real, stomach-churning error. I was trying to upload a 62MB CSV file into our ‘robust’ enterprise system. The system didn’t like a comma in row 4,202. Instead of telling me which row was broken, it simply crashed, wiped the previous four hours of my work, and sent an automated email to my supervisor suggesting I needed ‘additional training.’ I sat there in the silence of my office, listening to the hum of the HVAC system, and realized that I hated the software more than I feared the error. The software was an adversary. The spreadsheet, despite its lack of ‘security features’ and ‘audit trails,’ was my only ally.

The Need to See the Horizon

We crave environments that let us breathe, whether they are digital or physical. This is where the irony of our corporate lives becomes most apparent. We spend millions on rigid digital systems that box us in, while we simultaneously realize that our physical productivity depends on openness and intuition. Unlike the suffocating walls of a rigid database, a well-designed physical environment-like those found through Sola Spaces-actually understands human movement and the need for clarity. There is a reason people want to work in sunrooms rather than windowless cubicles; it’s the same reason they want a spreadsheet instead of a locked-down ERP. We need to see the horizon. We need to feel like we aren’t being processed by the machine we are supposed to be operating.

The spreadsheet is the ‘shadow IT’ of the soul. It is where the real work happens-the messy, unformatted, ‘vlookup’ dependent work that keeps the company running while the official reports sit unread in a manager’s inbox. I’ve seen spreadsheets that have been passed down through generations of employees like ancient family recipes. They are full of ‘if’ statements that no one quite understands anymore, but they work. They are resilient in a way that expensive software never is. If the server goes down, the spreadsheet is still there, on your desktop, waiting for you.

The Death of Spontaneity

Management views this as a problem to be solved. They see ‘unstructured data’ as a risk. They want everything captured, tagged, and categorized. But they forget that categorization is the death of spontaneity. If Cameron H. had to tag every creative impulse he had while building a dollhouse, he would never finish a single room. The spreadsheet allows for the ‘etcetera’ of life. It allows for the notes in the margin, the highlighted cells that mean ‘look at this later,’ and the quick calculations that don’t need to be saved for eternity.

We are currently in a cycle where we keep trying to build ‘Excel-killers.’ Every year, a new startup raises $32 million to build a platform that is ‘as flexible as a spreadsheet but with the power of a database.’ They never succeed. They can’t. Because as soon as you add the ‘power’ of a database-the permissions, the schemas, the validation rules-you kill the flexibility. You can’t have a sandbox that is also a bank vault. People will always choose the sandbox because that’s where you can actually build something.

So, I do what I always do. I find the ‘Export’ button. I click it. I wait 22 seconds for the download to finish. I open the file in Excel. And suddenly, I can see. The rows make sense. The columns are where I want them. I can write a formula that actually works. I feel a sense of relief that is almost physical, a loosening of the tension in my shoulders that has been building since I logged in this morning.

Is it a failure of technology? Or is it a triumph of human pragmatism? We spend so much time trying to automate the ‘human element’ out of our systems, only to find that the human element is the only thing that actually makes the systems work. The spreadsheet is the bridge between the digital void and the human brain. It is the tool of the person who just wants to get the job done and go home to see their family at 5:02 PM.

We will keep buying the million-dollar software. We will keep attending the training sessions where we are told how much more ‘efficient’ we are going to be. We will nod our heads and take our notes. And then, we will go back to our desks, open our laptops, and click ‘Export to CSV.’ The rebellion will continue, one cell at a time, until the people who build the systems finally realize that we don’t want a single source of truth. We want a tool that lets us discover the truth for ourselves.

I look back at the loading spinner. It’s still going. I think about force-quitting it for the 18th time, but I decide to just close the laptop instead. There is a limit to how much penance one can do in a single day. Tomorrow, I’ll probably just start with the spreadsheet and skip the dashboard entirely. It’s quieter that way. It’s more honest. It’s just me, a grid of empty cells, and the $222,000 problem I have to solve before lunch. And honestly? I wouldn’t have it any other way.