The Empty Spreadsheet at 2:47 AM: Football Analysis and the Addiction to Filling the Void with Fiction

The Empty Spreadsheet at 2:47 AM

The clock in my studio ticked over to 2:47 AM on June 18, 2026. In front of me sat a spreadsheet with forty cells. Thirty-eight of them were empty. The coffee had gone cold hours earlier. My only note read: Germany lost to Mexico 0-1. The show went live at seven. My editor texted: "I need twelve minutes. Throw in whatever numbers you have."

I almost made them up. I opened the data provider's dashboard, typed in both team names, stared at the empty boxes waiting to be filled, and a complete sentence was already forming in my head, ready to be read into a microphone. I had no source for it. I nearly wrote it anyway.

That moment taught me something about the trade I have worked in since 2026: football analysis cannot tolerate silence. It can survive without money, without sources, without sleep. It cannot survive without one line of data to read on air.

Three minutes of filming on the Luzhniki stands that night drew twelve million views on Weibo within twenty-four hours. Germany went out in the group stage, the first time in seventy-two years. All of Moscow called me a prophet.

But I know what actually happened in that studio. I overlooked Joshua Kimmich and Leon Goretzka, two players good enough to carry that team forward. I let the emotion of a single match carry me into an absolute claim. The lesson was not that I got it right. The lesson was that I nearly filled thirty-eight empty cells with things I could not verify.

An industry built so that there is always something to say

Professional football now runs on data. Opta, StatsBomb, Wyscout and dozens of other providers log every pass, every duel, every metre run. A single match in a top European league can generate thousands of data points before the final whistle.

Alongside that sits a media ecosystem designed to fill every gap. Twelve minutes on air. Three headlines. Five posts. Four graphics. Nobody pays for a pause, and nobody pays for the sentence "there is not enough data to conclude anything."

In 2026 I graduated from the Journalism Academy and started writing for Báo Bóng đá, while also working as a correspondent for Báo Thể thao Thế giới in Madrid. Back then reporters wrote with their eyes. We sat in the stands, took notes, and typed them up afterwards. If we saw nothing worth writing, we wrote nothing. That was an accepted form of waste.

Now it is different. Reporters write from a dashboard. And a dashboard always has something to display, even when a match has nothing to tell.

In 2026, aged forty-four, I left Guangzhou television after fifteen years to launch the podcast "Offside Trap". In the first episode I made a claim: the Guangzhou Evergrande dynasty was over. At that moment Evergrande had just been eliminated by Shanghai SIPG in the AFC Champions League semi-final. The two legs finished level at 5-5 on aggregate, and Evergrande collapsed 4-5 on penalties.

I backed the claim with a run of numbers. In their last six meetings, Evergrande had lost four. Their average possession against SIPG had fallen to forty-eight per cent, unusually low for a side that imposed itself on every match in Asia.

Social media called me a traitor. I enjoyed being opposed. I answered every hostile comment, debating on livestream until two in the morning. By November that year Evergrande had officially lost the title after seven consecutive championships. My claim became a prophecy in many people's eyes.

But in the same year I got three statistics wrong. Social media exposed every one of them. Since then I have checked numbers twice before publishing, while keeping the provocation in the headline. Here is what I tell young people entering this trade: a wrong number does not make a piece weaker, it turns the piece into a lie with an attractive layout.

The heat map has become the new astrology

The heat map is the easiest thing to sell in this industry. It looks scientific, it has colour, it coats the screen in a layer of professionalism. And it says almost nothing about what a player actually does.

A left-sided midfielder in a back-three system leaves a footprint that closely resembles a wing-back in a back-four. On the heat map the two look like the same position. On the pitch their jobs are so different they cannot be compared. One has to cover the left centre-back when the team loses the ball. The other has to push high to create width when the team attacks.

I have watched many sports shows use a heat map to prove that a player is lazy. That conclusion was read off an image, not off data. I call that kind of argument a perfect offside trap: the reader sprints forward to argue before the ball has even been played. A heat map cannot measure intent. It only measures footprints.

During the pandemic, those cloud parties taught me that football lives inside every argument people have about it. We met on screens, with no match footage, only memory and disagreement. And in those sessions the most discussed things were the things we could not see: a player making a run to open space for someone else, a defender shouting to drop the line. The heat map has no cell for any of that.

Gegenpressing has been decoded

PPDA, the number of opponent passes allowed per defensive action, was once the measure of modernity. Between 2026 and 2026, a low PPDA marked a progressive team. Fans memorised the metric. Coaching staffs used it to prove a philosophy.

In the current regular season the story has changed. Mid-table teams have learned to escape the press deliberately. They accept long balls, they field two strikers, they drop the midfield line deeper so the space behind the opposition defence disappears. The high press has lost its favourite meal.

The result is a different sport. Average kilometres run across the league have gone up, but clear chances have not risen with them. Teams run more to create less. When the press has been decoded, the team that runs more is no longer the better team. It is only the more tired one.

I once sat in a meeting room in Guangzhou while a coach presented his pressing plan for an entire season. He had eighteen pages of data. Page nineteen, the only page covering what to do when the press fails, contained two lines. That was the season they were relegated.

Scouting networks and lottery tickets with real people behind them

In developing football markets, scouting networks operate in a way few people want to describe plainly. They find geniuses. They also create lottery tickets, and behind every ticket stands a family.

A fourteen-year-old leaves home for Europe on a contract he cannot read. The academy pays for food, lodging and schooling, and in return holds priority on a professional deal once he comes of age. If he succeeds, the whole village knows his name. If he fails at eighteen, he goes home with a knee injury and no qualifications.

The success rate of this model is very low, and that is the most important point. A system can only be called successful if it takes responsibility for those who fail. Right now it takes responsibility only for those who succeed.

I followed one such case for four years. A boy from Southeast Asia was taken to a Nordic academy at fifteen. At eighteen he was released after a ligament injury. The club sent his family a letter wishing them luck. No one in the recruitment department was held accountable, and that is precisely the problem.

Referees, VAR, and the place where data meets emotion

In the regular season, refereeing controversy is where data and emotion collide hardest. An offside call overturned by VAR can change the table, and within two hours thirty analysis pieces are published.

Most of them cite a frozen frame without stating when that frame was taken. The error involved in projecting three dimensions onto a flat plane is a dry technical subject, and it gets skipped because nobody wants to read it.

I am not defending referees. I am saying that a conclusion built from a single frame, with no timestamp and no margin of error, is a conclusion without a source. And my trade is producing those conclusions at industrial speed.

The rule I set for myself: without enough information, say there is not enough information

Back to the spreadsheet at 2:47 AM. That night I chose differently. I went on air for twelve minutes, and four of those minutes were spent saying plainly that I did not have running data to compare the two teams, and that any conclusion about fitness in that match would be guesswork.

The audience split. Half sent messages of thanks. Half sent messages saying I was lazy. I accepted both.

My rule is now simple. If a dimension of analysis lacks sufficient information, the correct answer is "insufficient information, cannot assess". This industry treats that as weakness. I treat it as discipline.

Silence is not a lack of opinion. Silence is the data telling you there is nothing yet to say.

I apply the rule to small things too. A match I did not watch, I do not comment on. A player I have not tracked for at least five consecutive games, I do not judge. A competition whose regulations I have not read, I do not discuss sanctions for.

This sounds obvious. It is not remotely obvious in an industry that rewards speed and punishes slowness.

The Evergrande collapse and the mirror of the transfer market

When Evergrande collapsed, I was not sad that they lost money. I was sad that they forgot how to play.

That club was once a model of a serious football project. Their academy produced players other clubs had to buy back. Then the money arrived faster than the plan, and money always arrives faster than the plan. When you can buy anyone, youth development becomes decoration. When you can win every match, analysis becomes paperwork.

The transfer market is a mirror: the rich see prestige, the clever see the trap.

In the regular season I follow the smaller deals far more closely than the big ones. A twenty-three-year-old full-back signed for a modest fee who starts thirty games tells you more about a club's philosophy than a record signing does.

Where I could be wrong

There is one counter-argument I have to face whenever I defend this position. It is partly right, and I need to say it out loud.

The person who can say "insufficient information to assess" is someone with a large enough audience not to be fired for saying it. A twenty-three-year-old reporter at a provincial newsroom does not have that right. They have to file. They have to have numbers. If they stay silent they lose the job, and whoever replaces them will make things up.

The problem sits in the structure, not in individual ethics. I do not want to turn my own rule into a yardstick for young people fighting a deadline.

The second counter-argument is more uncomfortable. Emptiness in the data is itself a signal. When a match generates no notable data point, that means two teams cancelled each other out successfully. Ignoring that signal is also a form of invention, just pointed in the opposite direction.

And the third, the one I think about most. My prophecy in Moscow in 2026 was luck wearing the coat of analysis. If Germany had beaten Mexico that day, nobody would remember me. All of Moscow had never heard anyone speak as bluntly as I did, so they called it prophecy.

What I am watching for in the rest of the season

Better to be a lone crank in a studio than a voice reading someone else's script. But a crank still has to offer something checkable.

My prediction for the second half of the regular season: at least one mid-table team will finish above a high-pressing team, while that pressing team runs at least eight kilometres more per match. If that happens, the fitness story will have to give way to the structural one.

And if I am wrong, I will go on air and admit it. But I will admit it with a full spreadsheet, not one with thirty-eight empty cells.