Forty-One Columns and Empty Cells: The Silent Failure Inside Football's Data Rooms

On the second floor of a training centre, a stack of A3 sheets lay face down on the table. I picked one up. Forty-one columns. Every header printed cleanly, numbered, with a source note in the footer: burst index after long passes, passes allowed per defensive action, duel-win rate in the final third. Beneath each header was white space. Not a single value had been entered.

The meeting still ran forty minutes. The head coach nodded at the thirtieth minute, an assistant took notes, the match plan was approved, and the whiteboard in the dressing room gained three new arrows.

The pitch does not lie — but people do. And in that room, the only thing lying was a sheet of paper that looked finished.

I stayed twenty minutes after everyone left and counted again. Forty-one headers, zero values. What stayed with me was not the blank space but the confidence of the room. Nobody asked the one question that mattered: where is the data.

In fifteen years following teams, I have watched analysis departments move from a single spreadsheet kept next to a kettle to subscription systems with dedicated bandwidth and an administrator on call. That change is real and mostly an improvement. Clubs now know exactly how many high-intensity metres their full-back covers in a second half, which side an opposing striker shoots toward when forced onto his weaker foot, how many senior minutes a nineteen-year-old accumulated before signing his first professional contract.

But every system has a chain. The scout's note is uploaded. The tagger classifies each phase. The model computes. The dashboard renders. The coach reads and decides. That chain can break at any link, and a single empty mesh turns everything downstream into a ritual. When the chain breaks, it does not make a sound. It goes quiet.

In the summer of 2026 in Moscow, through a German technical assistant I had known from my Beijing years, I sat in a room with a large screen showing the xG model for the Germany national team. The model identified a clear point of failure: when opponents countered quickly, the gap between the two centre-backs stretched, and the shot quality generated in that zone ran well above the tournament average. The warning was drawn. It was printed. Joachim Löw read it and ignored it.

On 27 June 2026, in Kazan, South Korea beat Germany 2–0. Kim Young-gwon beat Manuel Neuer in the third minute of stoppage time after a scrambled phase, and Son Heung-min finished into an empty net in the sixth, after Neuer had abandoned his goal to join the attack. Germany went out in the group stage for the first time in eighty years. I wrote through the night, shirt soaked with sweat, with the feeling of having been handed both evidence and a warning.

That story gets retold often, and often retold in the wrong place. It is used to say that the data was right and the people were wrong. That is true, but it is only the first half of a longer story. Because in football today there is a second kind of failure, far quieter, and almost never reported.

A report with a complete frame and an empty interior is more dangerous than a visible error. An error makes noise. An error makes someone argue, makes an assistant raise a hand, makes a meeting run an extra half hour. Blank space makes no noise. It sits there, tidy, correctly formatted, and gets read as confirmation.

Take the tactical layer. A sheet has a column labelled PPDA — passes allowed per defensive action, the measure of pressing intensity, lower meaning more aggressive — and the value cell is empty. The coach looks at the sheet, sees no red flag, and understands that his team's pressure is fine. In fact nobody measured. The team walks out on an assumption that was never tested, and that assumption tends to lean optimistic, because nobody builds a sheet to find bad news.

The same mechanism repeats in recruitment. A record has every row for transfer fee, contract length, wage, sell-on clause, release clause, and is missing exactly one cell: the player's wage relative to the top earner in the dressing room. Without that cell, the amortisation of the fee across the contract becomes a beautiful number in a context that does not exist. Every contract is a promise with an expiry date, and a sell-on clause is only worth something if a buyer exists in the future.

Then compliance. Clubs can lose points for breaching profit and sustainability rules — Everton and Nottingham Forest have both been docked points in the Premier League, Manchester City face more than a hundred charges, Juventus have been through their own case in Italy. In every one of those situations the signal was not silent; it was loud for years. But inside an internal report, an empty "compliance status" cell is read as "no problem yet". No data is entirely different from no risk. They are two different states, and only one of them deserves to be called safe.

At the results layer, the most valuable test is comparing the results series with the process series. A team that wins four of five with a conversion rate double the average, an xG below its opponent in three of those five, and a goalkeeper saving above expectation is living on borrowed money. The table does not lie, but it does not tell the whole story either. If the xG column is left blank, nobody notices the loan until it comes due.

At the table-and-landscape layer, the gap is harder to see. A smaller club can live inside a dark-horse window — the brief competitive peak before its core is pulled away by bigger clubs. That window is measured by squad value, contract length remaining, and the age curve. Drop those three variables from the sheet and people still feel the peak without knowing how long they can stand on it. Meanwhile multi-club ownership structures — City Football Group, the Red Bull network, Eagle Football — change both resource access and competition eligibility. A sheet with no ownership row will never surface a conflict of interest until a governing body surfaces it instead.

I have lived with teams to understand why they lose. In the sense of sitting long enough at training grounds, long enough in hotel corridors, long enough on benches during friendlies nobody bothers to record. And what I learned about dressing rooms is this: they are never read through silence. In a team hotel, silence is also an official statement — but only when someone records that the silence occurred, at what hour, in which corridor. An empty sheet about squad status is not a calm dressing room. It is an unobserved one.

The same logic applies to contracts and age. A player entering his final contract year tends to produce a breakout season, and a squad with more than half its core past thirty tends to collapse in the run-in. Both patterns only appear when the sheet carries two columns: contract length remaining and age. Without them, people still feel the team is strong, and that feeling holds right up until matchday thirty.

And here is where I want to linger longest. Across the entire risk catalogue of a club — sporting, financial, personnel, rules, public opinion, systemic — exactly one risk can be flagged with certainty when everything else is blank: information-integrity risk. A report that looks complete but is empty creates the impression that analysis is finished. That impression is worse than a clear error, because it triggers no checking mechanism at all. Nobody fixes something that looks correct.

In the narrative layer, this mechanism is twice as dangerous. A story about a player or a coach follows a curve: emergence, acceleration, climax, backlash. A source-tiered report separates a confirmed report by an authoritative journalist from a tabloid fabrication. Remove the tiering and those two weigh the same — meaning nothing. And with no underlying data, any story can be pushed to the peak and slammed down, because there is nothing to check it against.

I still keep the habit from the night Beijing Guoan lost 1–2 to Shanghai SIPG at the Workers' Stadium on 22 October 2026, a match in which they had 63 percent possession and still lost. I did not write immediately. I stayed up until two in the morning cross-checking pass counts by zone, the location of duels, even pitch temperature. The conclusion was not in the possession. It was in the left flank left open when the team pushed up, and a right-back withdrawn in the twenty-fifth minute. My editor was surprised by the precision of the numbers. But what actually let me write that piece was not the numbers. It was knowing exactly which cells I did not have.

They remember the goals — I remember the sigh after the whistle. That sigh is in no spreadsheet. It also does not contradict the spreadsheet. It only shows that the sheet was incomplete, and that another layer of observation is always required.

The counterintuitive part sits here: football fears fabricated numbers, and that fear is justified. But the greater damage comes from blank cells dressed in confidence. An analyst who reads "no warning" when the truth is "no data" has not committed the sin of inventing figures. He has confused unobserved with stable. Those two states are exactly one transfer decision, one injury, one season apart.

The more sophisticated the system, the more authority the gap carries. A scout's notebook with coffee stains and bad handwriting is more honest than a clean dashboard, because the reader sees the hole immediately. A dashboard hides the hole behind layout. It is designed to run without error, and a completely empty report is still a run without error. Uptime is not accuracy. The absence of an error message is not proof that the calculation was right.

That is why I keep the three-source rule for every judgement, and a second rule less often stated: always mark clearly which cells you do not have. My writing is a few hours slower than my colleagues'. In exchange, when I write that a team has a problem on the left flank, the reader knows I counted rather than guessed.

Data keeps the beat — emotion is the one who sings. But an orchestra with no beat will fall apart no matter how good the song. And the listener cannot tell the silence of a rest from the silence of a broken instrument.

The season was empty, but the bench still holds the dent where someone sat. I have seen benches like that at a training centre where the analysis sheet was printed with every column and not one number. The following season nobody remembered the sheet. People only remembered that the team lost.

Next time you hold a report with forty-one columns, count the empty cells before reading the conclusions. And if someone in the room asks why it takes two more hours to fill those cells, remember that two hours is far cheaper than a season built on blank space. The only question left is this: in your club's meeting room, who is the one whose job is to raise a hand?