The Empty Spreadsheet and the Silent Trap of Sports Analytics

In 2026, at the age of twenty-seven, I sat in the Surabaya United office until two in the morning staring at a spreadsheet that was almost too beautiful to be true. No empty cells, no formatting errors, no unfinished rows. Every metric sat in the right column, in the right format, exported cleanly from the match-tracking software. And because it looked that clean, I trusted it.

Three days later, we lost 0-3 to Persib Bandung at home.

What I remember most from that night is not the three goals conceded. It is the moment I reopened the spreadsheet and realised it was not wrong. It was simply empty. The column for the opponent's pressure events had never been filled in. The column for ball-recovery positions in the opponent's half had been skipped because our tracking provider had not yet updated. The sheet was still tidy, still complete in appearance, still exportable as a full report. It was just missing the one thing that decided the match.

I call that a silent failure. No error was flagged. No red warning appeared. No line of text said this report was missing data. It simply looked fine. The Surabaya mistake taught me to question data, not to trust it.

I wrote a ten-page self-critique, sent it to the coaching staff, and proposed a cross-check process before every match. Three independent data sources. Three rounds of reconciliation. Never a conclusion built on a single table, no matter how clean. Since then, the first question I ask of any report has shifted from "what does this table say" to "where did this table come from, and what is missing here".

After more than twenty years observing this industry and nearly a decade as a club data consultant, I have come to see that the silent failure extends far beyond one piece of software. It is a sickness of the entire analytics profession. And every time the market enters its noisiest phase, that sickness flares up hardest.

The current transfer window is the clearest example.

Silence has never been proof of calm

During a transfer window, noise drowns out signal. Every day brings hundreds of rumours, thousands of posts, dozens of "sources close to the deal" who appear and vanish. Fans are submerged. The real danger lies in the fact that, amid that ocean of noise, silence is also read incorrectly.

A club that issues no statement is understood to be doing nothing. A player absent from transfer bulletins is understood to be staying. A team that publishes no injury update is understood to have a full squad. In data, silence has never been proof of calm. Silence is usually just proof that nobody went out to collect.

I once sat in a coaching-staff meeting where an assistant presented a tidy transfer summary for the entire league. The table had three colours: green for completed targets, yellow for ongoing negotiations, white for targets with no progress. The room nodded along. Nobody asked why some clubs had sat in the white zone for three straight weeks. To most people in the room, white meant "they have no plan". To me, white meant "we have no data".

Those two readings lead to completely different actions. If the opponent has no plan, you stand still. If you lack data, you must send someone to watch their closed friendly, call the agent, check the wage bill. One is confidence. The other is initiative. Choose the wrong one and you lose the negotiation before it starts.

That is why I always tell the clubs I advise: during a transfer window, the most important thing is not knowing who is arriving. It is knowing what you do not yet know.

Patch and meta: the thing that changes before you notice

In esports, every patch is a blood transfusion. A champion stat tweak, a weapon damage change, a map geometry adjustment — a single small number can overturn an entire hierarchy. The inexperienced analyst looks at win rates and concludes. The experienced analyst looks at the patch release date before trusting any win rate at all.

I once watched a team get called finished after two early-season losses. Both matches fell in the first week of a major patch. The team was still playing the old way, and the only thing they lacked was time. Three weeks later they won seven straight with the same people. The win-rate table had not changed a single character. The reading of the table had.

In football, the "patch" goes by other names. Semi-automated offside. Five substitutions. VAR. Every rule change creates a new data layer and invalidates part of the old one. While following the 2026 World Cup, I found something the scoreboard never showed: France's tactical fouls in midfield averaged fourteen per match, the highest figure of the tournament. The press at the time was criticising the French defence, but the defensive data painted the opposite picture.

I published "Mbappé did not win alone: the efficient football of Deschamps" before the final whistle. It reached two million views in twelve hours, and a young coach in Vietnam shared it and invited me to collaborate. That surge taught me one thing: the 2026 World Cup lifted the trophy on tackles nobody remembers.

But precisely because I wrote that piece, I understand the risk of reading only the metrics table. A high tactical-foul count is not automatically good. It is good when the line drops at the right moment, when the spacing between units keeps the right rhythm, when the opponent is funnelled into an unwanted corridor. Remove those three variables and the number fourteen becomes meaningless.

Format decides the value of every number

Competition format is the most underrated variable in any analysis. A knockout match is nothing like a group-stage match. A single game differs from a best-of-five. A Swiss system differs from a single round-robin. Yet when people look at a win-rate table, they usually forget this.

I have followed many tournaments where a team with a prettier win-rate was in truth the weaker side. They faced only weak opponents, or were lucky enough to land in the easy half of the bracket, or were granted more rest days. Flattening all of that into one ranking table is the fastest way to misread an entire event.

The Swiss system has a feature few people mention: it rewards fast adaptation, but punishes slow starters. A team that loses its first two matches can still advance, but it must then face opponents from the same loss bracket, and every subsequent match is sudden death. Format does not create strength. It simply decides who gets the time to show theirs.

Football sees the same effect in cup competitions. A side that plays well all season but draws a hard opponent in round one can go out, while a weaker side travels far thanks to a kind bracket. When you analyse a club purely on cup results, you are measuring luck more than ability.

Roster, money, and buried signals

In roster analysis, I separate two concepts that the media usually merge: competitive value and commercial value. A player can bring a huge fanbase, sell shirts, attract sponsors, and still fail to improve the position on the pitch. Another can be unknown and still be the hinge that makes the whole system work.

I built a rule of my own: count the number of changes to the spine of the starting eleven in one transfer window. Three or more changes down the vertical axis is usually a rebuild, not reinforcement. A rebuild has a price, and that price is usually paid in the first three months of the season, before the links form. Many coaches are sacked during that phase even though their plan was right.

Behind the roster lies cash flow. Here I made another mistake. In 2026, the pandemic halted every competition and I fell into a crisis because there were no matches to analyse. I was then a data consultant for a club in Jakarta. Instead of waiting, I built a "football without crowds" dataset from forty closed friendly matches across Southeast Asian teams. The results showed that without crowd pressure, sideways passing rose eighteen per cent and long-range shots fell nine per cent.

I sent the report to the board and proposed changing the pressing scheme even when the opponent sat deep. After the league returned, my club went seven matches unbeaten. But what I kept was not the record. It was the lesson about context variables: home ground, crowd, weather, schedule. Remove those and every model turns into dogma.

Money at club level leaves traces that financial statements do not mention. Unpaid wages. Terminated contracts. Clubs selling their competition slots. These signals appear long before bad news breaks, yet they rarely enter analysis because they generate no attractive headline. In a transfer window, a club that signs nobody often does so not because it does not want to, but because it cannot.

Rules and governance: the variable outside the touchline

Governance is the layer I screen before form. At the top level, rules on transfers, player registration, employment contracts and youth protection create a frame every club must obey. Breaching that frame can bring a transfer ban, a points deduction, or worse.

In esports the story is more tangled because rule systems stack on top of one another: publisher rules, organiser rules, and the national law of the country hosting the event. Conduct valid in one league can be a violation in another. An analyst who does not understand this layer will very easily reach a wrong conclusion about a deal.

There are three governance risks I always check before assessing any team. The first is competitive integrity, including match-fixing and cheating. The second is contract compliance, where clauses that bind too tightly can turn a player into a hostage of their own agreement. The third is the protection of minors, the field where mistakes leave the longest shadow.

When a club has good news, I still screen all three layers. That habit comes from a professional principle: risk always arrives before good news. The absence of a violation signal does not mean there is no violation. It only means nobody has gone to check yet.

Risk always arrives before good news

Whenever I take on an analysis request, I start with the risk list, not the strengths list. This reflex comes from the Surabaya failure: when you only look for strengths, you will always find them, because data is always wide enough to prove whatever you want.

In a transfer window the risk list has four groups. The first is injury: a player returning from a long layoff may need a whole season to find rhythm again. The second is contract: a player with one year left holds entirely different negotiating power. The third is personnel: a coach change mid-window usually upends the entire plan. The fourth is finance: one sponsor withdrawing can collapse three deals in a week.

What I always remind myself is not to confuse "found no risk" with "there is no risk". These two sentences differ completely in consequence. The first leads to more checking. The second leads to standing still. In more than twenty years in this trade, I have seen far too many clubs stand still because they believed they had a clean result.

Narrative and expectation: a fragile line

Every team lives inside a story written by someone else. The rising side is called a new dynasty. The veteran side is called the sunset of a golden generation. The all-domestic roster is praised for national spirit. The failed superstar project is branded vanity.

I always test a narrative with two questions. First, does the underlying data support it. Second, is the observation sample large enough. A rookie shining across four matches has proved nothing beyond having had four good matches. That is different from proving he will shine all season.

When narrative runs ahead of data, the heat cycle is exactly like a game of chess forced into a bad line. It starts small, accelerates as media joins, peaks when everyone repeats it, then flips when expectation outruns reality. At the flip, the party hurt most is usually the club, not the people who created the story.

In a transfer window this cycle spins three times faster because every bulletin is a new link in the chain. A club can be labelled "transfer market champions" after three flashy signings, then face a wave of criticism four rounds later. Between those two moments, no new data has appeared beyond emotion.

The current that runs through an entire industry

Professional sport runs along a vertical current. Upstream sit game publishers, federations and regulators. Midstream sit clubs, tournament organisers and streaming platforms. Downstream sit sponsorship, derivative products, and the march of sport into the mainstream.

A small shift upstream can generate a wave downstream within months. When the calendar thickens, for example, the value of load-tolerant players jumps, and the influence of fitness specialists becomes clearer than that of any star. When broadcast slots change, a club's wage structure must change with them.

I once read an internal report showing that a platform's broadcasting policy had reordered the transfer priorities of three clubs in the same window. None of them publicly stated why. They simply bought people who fit the new time slots. Ignore this layer and a series of decisions looks irrational until you understand the current behind them.

In esports the upstream layer is far more powerful, because the publisher is simultaneously the lawmaker and the tournament organiser. A single patch decision can change an entire player's value overnight. An analyst who looks only at the game will always be chasing movements that originate from decisions made far away from the arena.

The contrarian angle: the cleanest spreadsheet is the most dangerous

In the internal training sessions I run for clubs, I always devote the final block to the risk of cleanliness. A complete dataset looks more trustworthy than one full of gaps. That is exactly why it is more dangerous.

A gap is a warning signal. When an analyst sees a gap, they are forced to ask. A sheet with no gaps at all, by contrast, sends the message that everything has been handled. That message may be true, but it may also be the result of a data-collection breach nobody noticed.

A common belief holds that data analysis belongs to machines while the feel of a match belongs to people. This belief drives both sides into error. The machine side trusts the number absolutely; the human side trusts intuition absolutely. Both overlook the core point: data only means something beside context, and intuition only has value once verified.

At Euro 2026, when Germany went out, I wrote about how they generated a very high expected-goals figure and still lost. A veteran journalist pushed back on a livestream, arguing that I worshipped numbers and despised the emotion of the match. I answered with heat maps and the shot positions of every player, showing the problem lay in finishing quality rather than luck. The debate ran two hours and the video reached 1.5 million views.

But had I stopped there, I would have committed exactly the error I am warning against. Expected goals only holds when context is fixed. It cannot explain why a knocked-out team still created so many chances. Nor can it answer the bigger question: if chances are many and goals are few, is the problem the players, the system, or both.

What I took from those two hours was not that I was right. It was that both sides were defending half of their own truth. Data needs a challenger. Emotion needs verification. Remove either and analysis becomes propaganda.

Signals for the next round

The current transfer window will keep producing beautiful spreadsheets. There will be clubs ranked top of the market before a ball is kicked. There will be players priced on their last three matches. There will be clubs silent for three weeks, read as having no plan.

For me, the signal most worth tracking in this phase is not in the deals already announced. It is in the white zones nobody has touched. The teams signing nobody, and why. The players unmentioned because of contracts or injuries. The reports with no empty cells, and the question that must be asked before believing them.

The Surabaya mistake taught me to question data, not to trust it. This transfer window will teach one more lesson: the most dangerous thing is not a wrong number, but a missing number presented as though it were complete. Those of us who work in analysis have a duty to point out that difference before somebody else writes the story for us.