The cursor is a spinning blue ring of death, and the fans on the workstation are screaming at a pitch I haven’t heard since 2006. Diane is leaning over my shoulder, her breath smelling faintly of peppermint and anxiety, as she points to cell AN456. “Don’t touch that,” she whispers, as if the formula is a sleeping predator. It’s a nested IF statement that spans 16 lines when you expand the formula bar. It’s the logic that determines the global distribution of raw materials for 46 different manufacturing sites. If it breaks, we don’t just lose data; we lose the ability to fulfill orders for 36 days.

I spent the morning cleaning my phone screen with a microfiber cloth-polishing it until every fingerprint vanished, only to realize I was just procrastinating looking at this file. There’s something deeply unsettling about a multi-million dollar operation hinging on a file named ‘Master File v47_FINAL_ACTUAL.xlsx’. It’s a shadow kingdom. It’s the architecture of necessity built over 26 years of software solutions that didn’t actually solve the problem. I’ve noticed that the more expensive the official software is, the more likely there is a Diane in a corner office with a spreadsheet that actually runs the company.

The Visceral Texture of Process

Hans L.-A. enters the room. He’s the lead fragrance evaluator, a man who can identify 106 different notes in a single whiff of bergamot, yet he’s currently baffled by a pivot table. He hates the spreadsheet. To him, it lacks the ‘visceral texture’ of a real process. He relies on his own system-a leather-bound notebook that he later translates into a different spreadsheet, one with 56 hidden tabs. We are a company held together by the digital equivalent of duct tape and prayers. Hans once told me that a scent has a ‘spine,’ and this spreadsheet has a scoliosis of logic. It bends where it should break, and it breaks where it should be flexible.

Diane has only been on vacation twice in 6 years. Both times, the office felt like it was holding its breath. In March, when she caught COVID and was out for 16 days, the conditional formatting in column CF6 broke. Nobody knew why. The cells turned a violent shade of magenta, and suddenly, the priority shipping logic reversed itself. We sent premium orders to the wrong hemisphere for 46 hours before anyone noticed. We lost $676,466 in shipping corrections alone because nobody understood the business rule encoded in that specific shade of pink.

The core frustration isn’t that Diane is indispensable. It’s that her macro-laden masterpiece is the only thing that understands the ‘real’ world. The official software-the one the IT department spent $1,000,006 on-can’t handle the fact that Customer X always gets a 6% discount on Tuesdays if the weather in Chicago is below 46 degrees. Diane’s spreadsheet can. Shadow systems aren’t a rebellion; they are a survival mechanism. They are what happens when the ‘official’ way of doing things is too rigid to breathe. I often think we overcomplicate the idea of ‘digital transformation’ when what we really need is to stop punishing people for finding the most efficient way to survive a bad UI.

The Hostage Situation of Tribal Knowledge

I once tried to audit the VBA code in one of her older workbooks. It was like looking at a diary written in a language that died 116 years ago. There were comments in the code that weren’t technical; they were emotional.

‘Do not change this or the inventory will lie to you.’

Another simply said, ‘God help us if the tax rate changes.’ It’s a heroic individual effort disguised as operational efficiency. When you have a single point of failure that can also calculate the EBITDA of a mid-sized country, you don’t have a system. You have a hostage situation where the hostage is also the navigator.

We talk about ‘single sources of truth’ in boardrooms as if truth is something you can buy off a shelf and install. But truth in business is often messy. It’s Hans L.-A. knowing that the jasmine shipment from last week smells 16% more like wet hay than usual, and Diane adjusting the supply chain priority in her ‘Final_Actual’ file to compensate. The ERP doesn’t have a field for ‘wet hay.’ It only has fields for SKU and Quantity. And so, the spreadsheet grows.

I remember one afternoon where I spent 26 minutes trying to figure out why the total at the bottom of the sheet was off by 6 cents. It wasn’t a rounding error. It was a manual override Diane had put in back in 2016 because a client in Marseille had been overcharged for a sample of lavender oil. She never took it out. She just… remembered it. That 6-cent ghost had been haunting the balance sheet for 106 months. When I asked her about it, she just sighed and said, ‘It’s there to remind me that we’re human.’ That’s the problem with shadow systems. They possess the humanity that our enterprise software lacks, but that humanity is also our greatest risk.

The Call for Visibility

When companies finally decide to move away from these fragmented manual processes, they usually do it for the wrong reasons. They do it because they’re afraid of the ‘Diane Risk’-the risk of her retiring or winning the lottery and moving to a cabin with 6 dogs. But they should do it because the data shouldn’t require a priestess to interpret it. Transitioning to something like

OneBusiness ERP isn’t just about replacing a file; it’s about externalizing that tribal knowledge so that the ‘spine’ of the company is visible to everyone, not just those with the password to the macro-enabled workbook.

Hans L.-A. walked past my desk again just now. He’s holding a vial of something that smells like burnt sugar and ozone. He looks at my screen-I’ve opened Diane’s file to look at the March error-and he makes a face. ‘It smells like cold copper,’ he says. I know what he means. It’s the smell of a machine that’s been running too hot for too long. My phone screen is still clean, but my mind feels cluttered with Diane’s logic. I can feel the weight of those 16-line IF statements pressing against my temples.

We once had a meeting about ‘Operational Resilience.’ It lasted 46 minutes. We discussed server redundancy, off-site backups, and cybersecurity protocols. Not once did anyone mention that the entire logistics chain would collapse if Diane’s ‘Personal’ folder was accidentally deleted. We backup the servers every 6 hours, but we don’t backup Diane’s brain. We trust the hardware, but we rely on the shadow software. It’s a contradiction that most managers are too tired to address. They see the reports coming in on time and they don’t want to know about the 16 VLOOKUPs it took to get there.

There’s a specific kind of vertigo that comes from realizing how much of the world is run by people like Diane. It’s not just our company. It’s the local government, it’s the hospital down the street, it’s the logistics firm that handles 36% of the world’s shipping. They all have a Diane. They all have a file that ‘cannot be touched.’ And every day, those files get bigger. Every day, the macros get more complex. We are building a civilization on top of Excel 97-2003 Compatibility Mode. It’s a miracle it hasn’t all crashed already.

Fixing the Fragile Normal

I keep thinking about the conditional formatting error. The magenta cells. It was such a beautiful, violent color. It was the system screaming for help. It was the only way the spreadsheet knew how to say ‘I don’t understand this anymore.’ We fixed it, of course. Diane came back, typed in a string of 6 characters, and the magenta vanished. Everything went back to ‘normal.’ But it’s a fragile normal. It’s a normal that depends on one person’s health and one person’s memory.

In the end, we decided to start the migration. It will take 56 weeks. We’re going to map out every macro, every hidden tab, and every 6-cent manual override. Diane is nervous. She feels like we’re taking away her power, but I think, deep down, she’s relieved. She might finally be able to take a vacation for more than 6 days without checking her email. She might finally be able to look at a spreadsheet and not see a ghost. And maybe, just maybe, Hans L.-A. will find a system that actually has a ‘spine’ he can respect.

I just finished cleaning my phone screen again. It’s 10:06 AM. The sun is hitting the dust on Diane’s monitor in a way that makes the screen look like a starry night, or maybe just a very messy data set. I realize now that the goal isn’t to eliminate the shadow systems-they’ll always exist in some form-but to make sure they aren’t the only thing keeping us from the dark. Logic should be a tool we use, not a secret we keep.