The Empty Spreadsheet and the Trap of Believing Everything Is Fine

The coach slid the sheet across the table and asked exactly one question: "So what's the conclusion?" On the sheet was a table of nine rows, six columns, fifty-four cells, all of them blank. I had spent four hours pulling data from three different sources. All three came back with nothing: no player names, no point-win rates, no head-to-head records, no match dates, no citations. Just an empty file and a man waiting for me to say something useful.

My first reflex was not "I need more data." It was "what can I write from this that will still sound plausible." That is the moment I fear most in this job, and also the moment most worth writing about, because it forces an analyst to look straight at the thing the trade rarely teaches: how to read a blank space.

Table tennis at the analytical level lives in an era so saturated with data that people assume it is always there. Every event on the WTT calendar comes with a weekly-updated points table. Every major match comes with a heat map of where the ball landed. Every player carries a digital dossier thicker than their own medical file. And precisely because of that, a blank report is usually read as a technical glitch rather than as bad news. That is where the error begins.

In 2026, the ITTF increased the ball diameter from 38mm to 40mm. In 2026, the scoring system moved from 21 points to 11, with two serves per player instead of five. In 2026, the ban on hidden serves took effect. In 2026, speed glue was outlawed. In 2026, celluloid gave way to plastic. At each of those turns, one group of players lost an advantage they did not know they had, and another group grew up in silence. Neither group could read that from the following week's ranking list.

That is why I distrust any report that calls itself complete. A data table can run hundreds of rows deep and still be missing the one column that decides everything.

An analytical report passes through several layers. The first layer takes the text and extracts verifiable information units: who, which event, what score, what date, who said it. Only the later layer reads those units and draws conclusions about technique, about head-to-head, about form. When the first layer returns nothing, the later layer has nothing to read except the nothing itself. Every conclusion built on top of that is fabrication, and fabrication in a field as rumour-prone as table tennis is the most expensive mistake an analyst can make.

Across five years on the coaching bench, I learned that the hardest question a coach asks is not "who is stronger" but "what are we missing." The honest answer is usually far harder to hear than a beautiful report.

The WTT ranking runs on a rolling 52-week window. Points come from events inside the system, and old points fall away when they expire. That mechanism produces two kinds of distortion at once. A player who enters many small events, reaching a few rounds in each, can accumulate points faster than a higher-calibre player who appears only a few times a year. Conversely, a player from an association with few international entries is routinely ranked below their real level, sometimes far below.

A ranking measures how many events a player has entered more than it measures the ability to win the hardest matches.

The metric that separates those two things does not sit inside the ranking. It sits in the win rate against opponents from outside the national system, especially against players from strong associations. For Vietnamese table tennis the international sample is small, which makes this both the most important metric and the hardest one to collect. When I tried to build that kind of profile for the country's leading players — Nguyen Anh Tu and Dinh Quang Linh on the men's side, Mai Hoang My Trang on the women's side — most of the cells I needed were empty, not because they play little, but because the number of fully recorded international matches is far smaller than the number they have actually played.

The 52-week window creates a second pressure the audience rarely sees: points defence. Every good result in the past expires in the 52nd week after it was recorded. If the national calendar has no replacement event at the right moment, the ranking falls not because form fell, but because of the schedule. For associations with few entries, that is systemic risk rather than personal risk. A coach can prepare a player perfectly and still lose a seeding spot for administrative reasons.

Which is why I read the calendar before I read the technique. A serve improves in three weeks. An entry slot is lost for a season.

The bigger picture cannot be read from an empty file either. World table tennis splits into clear tiers: the leading group, the chasing group of Japan, South Korea, Germany, Sweden and France, the emerging forces of India, Brazil and Egypt, and everyone else. Judging whether that gap is closing or widening requires at least three indicators: seats in the world top ten, titles at the three biggest events over the last five editions, and depth in the under-21 group. None of those three is present in the material I have. In other words, I cannot say whether Asian table tennis is contracting or expanding, and I cannot say whether the women's field is more or less stratified than the men's — a distinction that always has to be made, because the men's game is systematically more open.

The heat map is the tool I use most and distrust most. It tells you where the ball landed. It does not tell you why it landed there. A ball landing in the left corner may be the result of an aggressive spin, or the result of the other player being pushed out of position and forced into a long return. A heat map records the outcome of a decision, not the decision.

And it has one very specific blind spot: the person who created the gap. In table tennis a point is usually finished by the player who hits the last ball, but it is opened by the player who put the ball where the opponent had to choose wrong. The second player almost never appears on any heat map, because maps count landing points, not empty space.

A tactical wizard is not someone who sees more, but someone who looks where others forgot to look.

The first call from a woman nobody names on the coaching bench — she is usually the only person in the room asking who created the gap before asking who finished the point. If a report has no room for that question, it is not a report about table tennis. It is a report about a scoreboard.

In Croatia I learned that a midfield does not chase the ball, it chases space. Table tennis borrows that lesson wholesale across one and a half square metres. The player who wins the point is usually the one who occupied the corner of the table first, not the one who hit hardest. And Croatia had no Zidane, but it had an invisible web of passes — the teams of small table-tennis nations live on invisible passes too, except theirs are never written into any column.

Equipment is another example. A change of rubber or blade creates an adaptation period in which results usually dip before they recover. During that window every metric looks bad and every conclusion of the "form is declining" kind gets the cause wrong. At officiating level, every match also involves checks on rubber thickness, blade flatness and volatile-solvent residue — things that can erase a win from the record with no relation to technique whatsoever. None of that appears in the file, so I can neither rule it out nor confirm it.

Back to the blank sheet on the table. Six risk classes that any serious table-tennis report must screen: competitive risk, entry-slot risk, generational-gap risk, governance and public-opinion risk, systemic risk, and opponent risk. With an empty file, all six go unscreened. Here is the most dangerous part of the whole story: a cell reading "not assessed" in a risk matrix looks very much like a cell reading "checked, no issue." A reader skimming past sees a clean table. But a table that is clean because nobody checked is precisely a blind spot, and a blind spot in risk management is itself a risk.

Unknown must not be operationalised as low. A blank cell is not a safety certificate.

The only risk that could be labelled with certainty at that moment was information risk: the extraction layer returned nothing, and any decision built on it would be a blind decision. Severity high. Likelihood: already happened. Impact: high. The only correct remedy is to re-run the data-collection step before publishing anything at all.

The items sitting in the unscreened zone are worth listing, because they are the reason the whole framework exists: concealed injury, the slump that follows a technical overhaul, fluctuation while adapting to new equipment, a playing style decoded through video, overload from competing across multiple events, collapse under points defence, and the pressure of fan communities bearing down on a player's psychology. None of that appears in an empty file. But their absence from the file is not evidence that they are absent from reality.

By the same logic, I can say nothing about squad structure. A roster of veterans and a roster with a hole in the 23-to-26 band are two entirely different risks, and both require the exact age of every individual. I cannot assess the talent pipeline either, because the conversion rate from junior to senior level is a metric that needs at least three continuous seasons of data. Without it, every claim about "the next generation" is a feeling.

The most counter-intuitive thing I took from that day is this: the most dangerous report is not the incomplete one, but the one that looks complete. A blank cell forces people to stop. A fluent sentence does not. When I picked up the pen and drafted a line that sounded entirely reasonable — something like "this player tends to attack early in the third rally" — I realised I had just done the exact thing I criticise in others: filled a blank with an unverifiable hypothesis, then let that hypothesis survive every round of review because it read too smoothly.

There is a reverse reading worth considering. In table tennis, the absence of data about a player is sometimes itself data. It tells you that the player has never been extracted by the international video system, never been a studied subject, never made the list that strong associations build in preparation. That absence is a signal about standing, not about level. But it only has value when it is labelled as absence. The moment it gets filled with a plausible-sounding sentence, signal turns into noise, and noise spreads faster than data.

A blank cell labelled "unknown" is data. A blank cell filled with a plausible sentence is a weapon.

Next match, I will bring that sheet with me, keep the columns blank, and put it on the table before switching on the video. The stands are empty, but I can still hear the coach shouting instructions metre by metre. The question I want to carry into the analysis room this week is not who won, but which column is missing — and who in the room has the nerve to say so before somebody else fills it with a sentence that sounds very reasonable indeed.