Null Results in Table Tennis Analysis: When the Spreadsheet Refuses to Speak

Three in the morning in Shenzhen. I open my spreadsheet and see a blank space. Not a formula error, not a corrupted file — just a null result, the thing that seventeen years in this trade taught me to fear more than an error term. The match-data column is empty. The point-by-point column is empty. The serve-position column is empty. In the last note row, where a conclusion should sit, there is a single word: insufficient information.

I sat for a long time in front of that screen. In sports analytics, people fear a wrong number, because a single error can push an entire conclusion off course. But those who have done this work for years fear something else: emptiness. A wrong number can be fixed. A blank space cannot — it simply sits there, silent, waiting for you to admit it. A null result is not the absence of a result — it is a reminder that the spreadsheet can fall silent, and that silence is itself a data point. Numbers do not lie; they only keep secrets.

In table tennis, the craft of reading numbers has a fairly clear architecture. A serious analytical session usually moves through nine layers: technique and tactics; individual data and head-to-head records; the tournament system and its points rules; the competitive landscape between China and the rest of the world; rules and governance; coaching staff and the talent pipeline; the risk surface; media narrative and expectations; and finally the transmission of the table tennis industry into the market.

Every layer needs the same thing: input data. Without it, all nine layers collapse in silence. What is striking is that the collapse is not loud. It does not throw an error. It does not flash red. It simply leaves a blank space, and a person sitting before it, wondering what he missed.

Today I am not telling the story of a specific match. I am telling the story of the moment the spreadsheet went blank, and of what the analytical trade must learn when it is forced to face its own limits. Because across seventeen years of watching table tennis, I have realised one thing: people prepare for error terms, but they rarely prepare for the absence of data.

The first layer, and the one everyone wants to stand on, is technique and tactics. You want to know where a player has improved, how effectively he executes, whether his physical profile fits his style, and what key metrics — service-point win rate, long-rally win rate — actually say. You want to know whether a backspin really troubles opponents or is only a feeling. You want to know how much a forehand loop has grown after each training cycle. But without data, all these questions become empty frames. No one is named, no style is present, no metric exists. When a technical claim cannot be verified, compared, or refuted, it stops being analysis — it becomes guesswork. And guesswork, in this trade, is just another form of illiteracy.

I learned this very early. We do not hunt for treasure; we hunt for the way to read the map. The treasure is the number, but the way of reading is the craft. An empty data column does not say the match had nothing worth saying; it says the reader has no map yet. At the technical layer, people also weigh equipment factors — a change of rubber or blade can trigger a whole adaptation period, and that period rarely shows up on the scoreboard. But without equipment records, nothing can be said about fit, and no risk can be identified. The page stays blank.

The second layer is individual data and head-to-head records. Here one examines world ranking, the pressure of defending points, the match between ranking and true strength, then goes deep into head-to-head — overall, over the last two years, and specifically at the three majors. One also looks at away-match win rate, consistency at major events, and performance at decisive points. This is the layer where patience pays off, because a head-to-head record only means something when the sample is large enough. A player beating an opponent twice says nothing. Beating him eight times in twelve meetings across the three majors is already a signal. But when no player is named and no ranking exists, every comparison is meaningless. No form cycle can be assessed, no selection conclusion drawn. The head-to-head table is just a blank grid.

The third layer is the tournament system and its points rules. This is the layer I consider the most underrated in the trade. Fans remember the name of a champion, but few remember how many points that title carried, or where the event sits in the Olympic cycle. The points system of international events does not merely record results — it shapes players' choices. A high-point event draws players who need to defend their ranking; a low-point event may be skipped to save energy for a bigger goal. So reading a draw without knowing the event's points value is reading only half. Without information on the event, its level, and its value, one cannot analyse the draw, cannot read participation strategy, and cannot say anything about the impact on the selection picture. Once again, the blank space wins.

The fourth layer is the competitive landscape between China and the rest of the world. This has been the great story of world table tennis for decades. People count the seats in the world top ten, the number of titles at the most recent majors, and the depth of the under-21 generation. They also identify the most threatening opponent, the nature of the threat, and the time window in which it could materialise. But even a picture that large needs data to be drawn. Without figures, one cannot compare the balance of power, cannot name the most dangerous opponent, cannot say what kind of threat it is or over what horizon. The dominance of a table tennis nation is not something to be felt; it is something to be counted.

In recent years, I have kept watching the generational shift at the top. Names such as Ma Long, Fan Zhendong, Wang Chuqin, and on the challenger side Tomokazu Harimoto, Truls Moregard, Hugo Calderano, Felix Lebrun — all are links in a landscape in motion. But I deliberately do not attach specific numbers to them without verified data. That is the discipline of the trade: you may name them, but you may not invent numbers. A piece that names players without figures can still be right in spirit, but it is not analysis. And in my trade, inspiration cannot replace evidence.

The fifth layer is rules and governance. Every time a tournament changes its format, a selection rule is tightened, or a disciplinary decision is issued, there are winners and losers. But to say who wins and who loses, one must cross-check against a specific document and a specific precedent. When no rule is cited and no governing body is named, any analysis of reform impact is imagination. And in this trade, imagination is the most dangerous thing, because it wears the clothes of a conclusion. A selection controversy, if one exists, must be weighed between quantified standards and human discretion. Without a scale, nothing can be weighed.

The sixth layer is coaching staff and the talent pipeline. Here one examines the head coach's competence and authority, the fit of personal coaches, the stability of the coaching staff, then the age structure of the main squad, the conversion efficiency of the young generation, and the handover between generations. This is the layer that determines a table tennis nation's long-term strength, because a golden generation can hide a pipeline that is running dry. But with no team named and no coach named, nothing can be assessed. A squad's internal ecology only becomes visible through selection data and match data, and when both are absent, all we have is an imaginary line-up.

The seventh layer is the risk surface. A decent risk surface must list competitive risk, selection risk, generational-gap risk, governance and public-opinion risk, systemic risk, and opponent risk. Each risk needs a level, a likelihood, an impact, and a mitigation. But with no data points at all, assigning an entire system a high or low risk rating is irresponsible. Worse, it can lead readers to mistake finding no risk for having no risk. That is the kind of mistake I fear most, because it leaves no trace.

The eighth layer is media narrative and expectations. This is where data and emotion meet. People measure the durability of a story, check the sample size behind it, and estimate how long it will last. They compare market expectations with objective assessment to find the gap. They look at fervour, the ratio of social-media heat to fundamentals, and the impact of fandom-isation. But with no story and no sentiment signal, analysis is just a blank page. And a blank page, at this layer, is the easiest to fill with rumour.

The ninth and final layer is the transmission of the table tennis industry. This is where sports analysis touches the economy. A small change on court can spread into the equipment market, the training base, the commercial ecosystem of an event, a player's commercial value, policy and capital flows, and the international ecosystem. Each transmission segment has a direction, a magnitude, and a time horizon. But to map that transmission, one must know which brands, sponsors, operators, and policies are involved. Without them, the transmission map is an empty frame. And an empty frame, filled with guesswork, produces false business conclusions.

Nine layers, nine blank spaces. And looking back at the whole picture, I understand why a null result is so frightening. It does not deny the existence of data — it shows that the data was never entered into the system. When the court is empty, the data sits and cries alone.

But here I want to go against myself a little, because that is the only way to be honest.

In analytics, people are often obsessed with finding the surprise. A counter-intuitive finding is always more attractive than an obvious truth. But that obsession creates a trap: when the data says nothing surprising, the inexperienced analyst tries to force it into a paradox for effect. And in the worst case — when the data is entirely absent — the trap becomes the temptation to fabricate. To invent a number, invent a match, invent a conclusion, just so the spreadsheet looks full.

I have asked myself for a long time whether a null result has any value. And my answer is yes, in a very particular way. An honest null result is worth more than a full conclusion built on fabrication. Because it points precisely to where the system is hollow, and that hollow is exactly what needs fixing. Data cannot save a match, but it points to why the match died. And a null result points out that there are matches never recorded, players never measured, questions never asked the right way.

That is also why I do not believe in assigning high or low risk to a system I have no data on. In my trade, seventeen years of experience does not give me the right to guess at random. It gives me the obligation to say I do not know when I truly do not know. A null result, presented decently, is a disciplined confession — and in an age when everyone wants an answer instantly, a disciplined confession is a rare thing.

There is one more paradox I want to state plainly. The more data people have, the more easily they believe they understand everything. But more data is not necessarily right data, and less data is not necessarily useless. What decides is not volume but honesty in reading. A good analyst is not the one who always has an answer, but the one who can tell a real trend from random noise. And to tell them apart, one first needs enough sample — something a null result does not give us.

So what do I take into the next round?

Do not ask the data what the future holds; ask what the past is reminding us of. With table tennis, the worthwhile task is not to fill every blank with guesswork, but to build a record-keeping system good enough that next time there is no blank at all. Every number is a recitation, every calculation a contemplation. And every null result, if we have the courage to face it, is a reminder that the craft of reading numbers begins with honesty, not with attractiveness.

Tomorrow I will open the spreadsheet again. And if it is still empty, I will write in the first row exactly one line: more data needed. That is not a failure. That is a starting point.