The Empty Spreadsheet and the Discipline of Silence in Table Tennis Analysis

At 2:47 a.m. in Shenzhen, on the third day of a WTT Champions event, I opened my spreadsheet and found it empty. Not a single row. The scraping bot had finished at 1:12 a.m., returning exactly the column structure I had designed: player name, point-win rate, serve efficiency, PPDA index, number of balls into the final third. Match title: none. Source: none. Article type: none. The list of information points: completely empty.

I sat still for a long while. The screen stayed bright, the coffee had gone cold somewhere along the way. In the trade of sports data analysis, an empty sheet is not rare. What is rare is the reaction of the person sitting in front of it. There is a version of me at 25 who would immediately start filling the blanks with guesses, with the memory of a similar match, with the feeling that this match was probably like that one. Tonight I want to talk about why that version of me was wrong, and why staying silent is sometimes the hardest work in this profession.

I have worked in transfer-market data management and table tennis analysis for five years, on top of seventeen years observing the industry. The daily job sounds simple: read a source, break it into core events, then build a multi-dimensional analysis on top. But "break it into core events" is where the difficulty lives. In my pipeline, the first stage does one thing only: it turns an article into a set of information points and core viewpoints. Without that step, there is nothing to analyse. The second stage — the part I sat down to do tonight — is where I stack nine layers of professional analysis: technique and tactics, player data and head-to-head records, event systems and points rules, the competitive landscape, rules and governance, coaching staff and talent pipeline, the risk surface, the public narrative, and the transmission chain of the entire table tennis industry.

The crux lies here: if stage one returns empty, stage two has nothing to hold onto. Those nine analytical layers are like nine floors of a building, and stage one is the foundation. Without a foundation, I can draw nine beautiful floors on paper, but the whole building collapses the moment someone walks in to inspect it.

There is one distinction I must make clear, because it is the root of everything that follows. A genuinely empty source — an article that truly contains no information — is one thing. A broken pipeline, a source blocked behind a paywall, a data object passed incorrectly — is another. Both produce the same result on screen: an empty sheet. But the handling is entirely opposite. With a genuinely empty source, the correct answer is to state plainly that there is nothing to analyse. With a broken pipeline, the correct answer is to fix the pipe and re-run. Confusing these two cases is the fastest way for an analyst to deceive himself.

I will walk through those nine layers, not to show off the framework, but to show what an empty sheet took away from me.

The first layer is technique, tactics and equipment. For a table tennis match I need to know the playing style, execution efficiency, physical fit, and any equipment changes. The sport has a library of reforms that anyone doing analysis must know by heart. In 2026, the ITTF increased the ball from 38mm to 40mm, reducing speed and spin and lengthening rallies. In 2026, the rules moved from 21 points to 11 points per game, making every point heavier and narrowing the gap for the weaker player. In 2026, the hidden-serve rule arrived — the ball must be visible from the toss — stripping away the weapon of an entire generation of deceptive servers. In 2026, speed glue containing organic solvents was banned, forcing players to rediscover spin through technique rather than chemistry. And around 2026, the celluloid ball was replaced by the plastic ball, once again altering trajectory and bounce. Each reform rewrites how a playing style operates. Without equipment data on a player, I cannot know which physics their strokes are running on.

The second layer is player data and head-to-head records. This is where I live. The WTT ranking operates on a rolling 52-week mechanism — points won at an event expire after exactly one year. This gives rise to a concept I call points-defence pressure: a player may rank high while actually standing on points about to evaporate, and a single event off form can send them tumbling. Alongside that sit head-to-head records, the win rate against foreign opponents, and the ability to perform in a deciding game. In table tennis, the "nemesis" is a real concept — some lower-ranked players beat a top player repeatedly because their styles lock each other down. To know that, I need head-to-head data over specific periods, not a single aggregated figure. An empty sheet gives me no name at all.

The third layer is the event system and points rules. Table tennis has a clear hierarchy: the Olympic Games, the World Championships, the World Cup, then the WTT tiers from Grand Smash down through Champions, Star Contender and Contender. Each tier carries different value in points and prize money, and a position in the Olympic cycle determines how people pick events. A year before the Olympics, people accumulate points. Six months before, they test tactics. Three months before, they lock the line-up. Without knowing which event is under way, I cannot place it in the right slot of the cycle, let alone analyse the draw or schedule density.

The fourth layer is the competitive landscape, especially the balance between China and the rest of the world. I keep tracking seats in the world top 10, titles at the last five editions of the three majors, and the depth of the under-21 generation. In the men's game the field is far more open than in the women's game, where China has held the top tightly for years. Behind the numbers is a question of sustainability: is an emerging rival the product of a development system, or just an outstanding individual who flares and fades? That question needs years of data, not a single match.

The fifth layer is rules and governance. I keep a reform library in my head: bigger ball, shorter games, hidden-serve ban, toxic-glue ban, ball material change. Every change creates winners and losers, and by reading that I can guess which direction the ITTF or WTT wants to push the sport. The bigger ball and the shorter game serve one goal together: making matches easier to follow on television. But to apply that library to a specific situation, I need to know what dispute is under way. An empty sheet cannot tell me.

The sixth layer is coaching staff and the talent pipeline. This is the layer where public data is weakest. I want to know the age structure of the main squad, the conversion efficiency from junior ranks to the national team, and who the nucleus is. But most of this surfaces only through internal practice matches, through the wording of coaches, through wildcard allocations. Once again, I need one piece of information to begin.

The seventh layer is the risk surface. I have a fixed risk matrix: competitive risk, selection risk, generational-gap risk, governance and public-opinion risk, systemic risk, opponent risk. For every injury, every technical overhaul, every equipment change, I mark level and likelihood. An empty sheet leaves all seven cells open, and leaving things open in risk analysis is more dangerous than marking them red, because readers will assume an empty cell means no risk.

The eighth layer is the public narrative. Each moment carries a narrative label: the Grand Slam chase, the rivalry between two stars, a rising prodigy, a dynasty to defend, a countdown to retirement. The narrative label determines public expectation, and the gap between that expectation and reality is where upsets happen. I measure that gap through odds, through media predictions, through fan polls. Without data, I do not know which label is dominant, and I will misread an approaching shock.

The ninth layer is the industry transmission chain. From upstream equipment, youth development and training, to midstream events, associations and clubs, then downstream broadcasting, commerce and derivative markets. A rising star can lift the sales of a racket line; a ball change can shift the price of ball holders across many markets. But that chain only opens when an event triggers it. Tonight, there is no event.

What I want to stress is this: an empty sheet is not a conclusion, it is a state that needs handling. This is the boundary between the analyst and the storyteller. The storyteller looks at an empty sheet and sees freedom — the freedom to invent a good story. The analyst looks at an empty sheet and sees a task: determine why it is empty, then decide whether to publish that emptiness.

This is where the paradox lies, and I need to say it plainly. The most dangerous kind of failure in my trade is not an empty sheet. An empty sheet is easy to spot. The most dangerous kind of failure is a full, beautiful analytical framework, with all nine layers, all the headings, all the tables, but with every cell inside reading "cannot be assessed due to insufficient information". At a glance it looks exactly like a real analysis. A skimming reader sees a tidy structure, sees the right terminology, assumes a professional has done serious work, and never realises the whole building has no foundation.

I call it silent failure. It is silent because it raises no error. It does not crash the program. It simply lets an empty analysis look like a real one, then drift along the information stream. And by the time someone uses it to make a decision — to place a bet, to write another article, to sign a player — the roots are already deep underground, and no one can trace them anymore.

The second danger of silent failure is that it conflates two different things. When I see a sheet full of "cannot be assessed", I do not know whether that is because the source is genuinely empty or because my data pipeline is clogged. A source blocked behind a paywall, a data object passed incorrectly, a parser error — all of them produce the same result. And all three demand different actions. An empty source means publishing the emptiness. A clogged pipeline means fixing it and re-running. But if I cannot tell them apart, I will choose the worst option: publishing an empty analysis as if it were the final result.

Numbers do not lie, they only keep secrets. But a spreadsheet full of cells reading "no data" does not keep secrets — it creates them. It makes people believe something was thoroughly checked, when in fact nothing was checked at all. And in an industry where speed is everything, an empty analysis that looks real enough will travel further than a confession that I have nothing in hand.

I have been on the other side of this lesson. In 2026, when the Bundesliga returned after the pandemic, my prediction model went badly wrong: the home-win rate fell from 45 per cent to 38 per cent across 26 matches without spectators. The "spectator" variable had never existed in my system, so five years of history became useless overnight. I delayed publishing the report for three weeks to polish it to perfection, forcing the editorial team to use the old version. The lesson was not to stop refining. The lesson is that emptiness and imperfection must be published at the same time, not one hiding the other.

When the stadium is empty, the data sits and cries alone. But there is something worse than crying alone: pretending the stadium is still full, that the stands are still roaring, that every number is still dancing on the board. A good data person is not someone who always has data. A good data person is someone who knows exactly when they have nothing.

Tonight, I will not publish an analysis of a match for which I do not have a single data point. Instead, I record what I do have: a report on the health of the data pipeline itself. Tomorrow, I will check the input packet again, verify the source, and if the source is genuinely empty, I will say so plainly. If the pipeline is broken, I will fix it. Data does not save the match, but it points to the reason it died. And sometimes, the reason it died lies with the person sitting in front of the screen, at nearly three in the morning, with an empty spreadsheet and a decision to make.

What I keep returning to is this: the value of a data person is not measured by how much they can explain, but by how much they refuse to explain without evidence. We do not hunt treasure, we hunt the way to read the map. And when the map is blank, the first correct act is to admit it is blank — before anyone draws a road on it that does not exist. What I ask myself, looking back at myself: in the information stream you consume each day, what percentage is real analysis, and what percentage is only a beautiful frame with empty cells inside?