Your Inventory Spreadsheet Is Lying To You

Blog Site

Your Inventory Spreadsheet Is Lying To You

Information Architecture

Your Inventory Spreadsheet Is Lying To You

Why complexity is often a mask for a lack of trust-and how a single “muddy yellow” cell can break an agency.

In , two brothers named François and Joseph Blanc looked at the French optical telegraph system and they saw a hole. The telegraph used a series of mechanical arms on towers to send signals across the countryside and the messages were supposed to be for the government only. The brothers did not want to steal the messages but they wanted to send their own.

They bribed an operator at a station near Tours and they gave him a secret code. When a government message passed through his station he would add a small, unnecessary movement of the telegraph arms. This movement meant nothing to the government but it meant everything to the brothers in Bordeaux.

It told them which way the stock market was moving in Paris and they received the news days before the mail coach arrived. They turned a public infrastructure into a private vault and they did it by making the signal unreadable to anyone but themselves.

The Signal in the Glass Office

Today, in a glass office in the Dubai Marina, a different kind of signal is being manipulated. It is and the sun is coming through the windows and the air conditioning is fighting the heat. There are two agents sitting at a desk and they are staring at a screen.

The screen shows a spreadsheet. It is the master inventory for an off-plan project and it is a map of a tower that does not yet exist. The tower has 48 floors and 422 units. Each cell in the spreadsheet represents a home and a hope and a commission.

SOLD

AVAIL

BLOCK

1204

Unit 1204: A color that exists in the middle of a conflict-neither available nor sold, but held in the “Fatima System.”

Fatima is the inventory keeper and she is on a beach in the Maldives. Her phone is off and her out-of-office reply is active. The agents are looking at Unit 1204. The cell for Unit 1204 is shaded in a muddy yellow. It is not the bright yellow of a new listing and it is not the green of a sold unit.

One agent thinks it means the unit is on a soft hold for a client who promised a cheque three days ago. The other agent thinks it means the developer has blocked the unit for a VIP launch. They cannot agree and they cannot call Fatima.

A lead is waiting on WhatsApp. The lead is a doctor in London and he wants to buy Unit 1204 today. He has the deposit ready and he has the passport copy. But the agents do not move. They do not want to call the developer and look foolish and they do not want to promise a unit that is already gone. They wait for a signal that will not come.

The lead sees the “typing” bubble appear and disappear and he begins to look at a different project in a different tab. The spreadsheet is not just a document. It is a living record of every conversation Fatima has ever had and it is designed to be understood only by her.

This is not an accident of poor training. It is a structural defense. In a brokerage where information is the only currency, the person who controls the ledger controls the building. If the spreadsheet were clear, any agent could see the truth. If the truth were visible, the inventory keeper would be a clerk instead of a queen.

“When a system is ‘one-person deep,’ it is a hostage situation disguised as a workflow.”

— Thomas H.L.

I am thinking about that today as I sit with a cold compress on my foot because I stubbed my toe on a heavy oak chair this morning and the pain is making me impatient with inefficiency. Thomas is right. The muddy yellow cell in the spreadsheet is a ransom note.

The Mechanics of the Locked Ledger

This is how the document actually functions. To understand the “Fatima System,” you have to look at the “hidden” tabs. There is a tab titled “Old_Updates_DO_NOT_DELETE” and it contains conflicting data from four different developers.

There is a tab titled “Calculation_A” that uses a logic from a commission structure that was abolished in but is still used for certain “friends of the house.” The main sheet uses a VLOOKUP function that points to a file on Fatima’s personal desktop drive.

SYNCED

Live CRM

DELAYED

Fatima System

The Error is not a bug. It is a notification that she is needed.

If she does not sync her drive, the sheet displays an error. This error is not a bug to Fatima. It is a notification that she is needed. It is a recurring proof of her value.

The agency owner thinks he has a data problem but he actually has a power problem. He pays for the office and he pays for the marketing and he pays for the leads. But he does not own his inventory. The inventory is owned by the spreadsheet and the spreadsheet is owned by the ghost of Fatima’s memory.

Every time an agent has to ask permission to know the status of a unit, the agency loses momentum. In the Dubai real estate market, momentum is the only thing that overcomes the friction of a million competing offers.

Breaking the locked drawer

When you move your agency from a private, color-coded file to the best crm software in dubai, the dynamic of the office shifts. The information moves from a locked drawer to a shared table.

The “soft hold” is no longer a rumor whispered in the hallway. It is a timestamped event with a countdown. The “developer update” is no longer a PDF buried in a WhatsApp thread. It is a synchronized data point that updates the whole desk at once.

This transition is usually met with resistance. The gatekeepers will tell you that the project is too complex for a standard system. They will tell you that the developers are too erratic. They will tell you that “only I know the nuances of these deals.”

What they are actually saying is that they are afraid of being visible. I watched an agent lose a $65,000 commission last month because he waited two hours for a confirmation that never came.

UNIT RELEASED BY DEVELOPER

FATIMA UPDATES SHEET (TOO LATE)

-$65,000

The developer had released the unit at . Fatima saw the email but she was in a meeting. She didn’t update the sheet until .

By then, the unit had been sold by a rival brokerage that didn’t have a Fatima. They had a system that allowed the agent to see the stock in real-time and they acted while our agent was still staring at a yellow box and wondering what it meant.

The “Fatima System” persists because it feels safe in the short term. It feels like expertise. It feels like having a specialized person who “handles it.” But handling it is not the same as scaling it.

You cannot grow a brokerage if every deal has to pass through the bottleneck of one person’s intuition. You cannot build a brand on top of a VLOOKUP that breaks if someone goes on holiday.

We often talk about “institutional knowledge” as a positive thing. We think it means the wisdom that lives within a company. But knowledge that cannot be transferred is not an asset.

If your company’s success depends on the specific memory of one person, you do not have a company. You have a freelance operation with a lot of expensive overhead.

The agents in the Marina office are still staring at Unit 1204. The London doctor has stopped replying. He is now talking to an agent in a different tower who sent him a live link to the remaining units.

That agent did not have to check a spreadsheet. He did not have to wait for a keeper of the keys. He simply looked at his phone and he told the truth and the truth was enough to close the deal.

The Labyrinth of Indispensability

We like to think that we are smarter than the Blanc brothers in . We think that our fiber-optic cables and our cloud storage have made us immune to the manipulation of signals.

But the human heart has not changed. We still want to be indispensable. We still want to be the only ones who can read the code. We will build a labyrinth of Excel cells just to ensure that someone has to ask us for the way out.

If you are the owner of that agency, you have to decide if you are running a business or a court. You have to decide if your inventory belongs to your company or to a single employee’s hard drive.

The transition to a centralized source of truth is painful because it requires you to confront the people who have made themselves vital through obscurity. It requires you to tell Fatima that her spreadsheet is dead.

It is a hard conversation. It is a conversation about trust and about the future. But it is the only conversation that matters. Until the inventory is live and visible and shared, you are just a group of people sitting in a room, staring at colors, and guessing at the world.

The sun continues to rise over the Marina and the tower continues to be built and the commissions continue to flow to the people who can see the signal without a translator. My toe still hurts but the logic is clear. You have to break the spreadsheet before the spreadsheet breaks your agency.