The Empty Spreadsheet: Donny van de Beek and the Hardest Discipline in Analysis

In March 2026, when the biggest football leagues on the planet froze one after another because of the pandemic, I sat in my apartment in Chengdu staring at an empty spreadsheet. At 37, I had spent nearly two decades in sports data analysis, but I had never seen a fixture list wiped clean like that. Colleagues called to ask whether I could calculate anything. I told them that without data, there was nothing to calculate. Then I realized the emptiness itself was a kind of data. It told me that every model built on the rhythm of a league season had lost its value within months. I decided to use the dead time to rebuild a tool from scratch, something I later called the Transfer Risk Index, or TRI. A few months later, I used TRI to score Donny van de Beek's move from Ajax to Manchester United for a fee of 35 million pounds. I gave it a risk score of 8.5 out of 10 and publicly advised against the purchase. In the 2026-2026 season, Van de Beek made only 4 Premier League starts, then was pushed to Everton on loan. Many people called it a prophecy. I do not think so. It was the result of a simple discipline: when the data is not enough, say plainly that it is not enough. Modern football has gone through more than fifteen years of a digital revolution. From counting only goals and assists, people began measuring xG, measuring PPDA, measuring distance covered, measuring sprint counts, measuring even the angle of a corner kick. Big clubs spend millions of pounds a year on analytics departments, hiring physicists and data scientists. A single match now generates millions of data points, so many that nobody reads them all. The common feeling is that data has become complete, that with enough numbers every question has an answer. I believed that too, until I realized the most dangerous thing in this profession is not wrong data, but missing data that nobody admits is missing. An empty cell in a spreadsheet is usually filled with an assumption, with reputation, with a feeling. And when an assumption is presented as a number, it wears a cloak of precision that nobody verifies. Numbers hide nothing; we simply have not arranged them in the right order, but before we can arrange them, we must admit what we are missing. The football data revolution started with modest metrics. In the 2000s, analytics firms counted passes, tackles, pass completion rates. By the mid-2010s, the xG model, expected goals, changed how people saw a chance. A shot from the edge of the box was no longer counted as a dangerous chance if the scoring probability was only 4%. PPDA, the metric measuring pressing intensity, allowed a team's style to be compared without watching the whole match. These metrics are not perfect, but they force people to quantify rather than rely on feeling. When I began hosting major broadcasts from 2026, I noticed the gap between numbers and stories. Fans remember a beautiful piece of play, while the data sheet only records it as a shot with an xG of 0.03. Both are right. My job is to connect them without letting one overwhelm the other. When the market panics, only metrics can keep the breathing rhythm, but when the market has calmed, metrics again need a story to mean something. What led me to TRI was a simple observation: clubs spend hundreds of millions of pounds each transfer window, yet very few have a tool to price player risk systematically. They have scouting reports, video, and the coach's intuition. They lack something colder: a number that can be compared across targets, and more importantly, a way to state how reliable that number is. My TRI has four components. The first is age and development trajectory, not just current age but position on the career curve. The second is injury history, coded by injury type, downtime, and recurrence frequency. The third is average distance covered over three years, used as an indicator of intensity and the ability to adapt to a new league. The fourth is the xG profile, which shows at what level a player creates and finishes chances relative to his position. Each component is normalized, then added together by weight. The final score from 1 to 10 expresses the level of risk. The scale does not say whether a player is good or bad. It says that if you buy this player at the market price, the probability he fails to meet expectations is such and such. This is the core difference between pricing risk and evaluating talent. They are two completely different questions, and the market often confuses them. When I applied TRI to Van de Beek, I went through each component. On age, he was 23 when he moved, the age usually considered ripe, but also the age when expectations are pushed highest. On injury, his record was clean, almost no worrying history. That was a major plus, and I recorded it honestly. On distance covered, Eredivisie data showed he ran less than the average attacking midfielder in the Premier League. The Dutch league has lower tempo and intensity, and its matches have fewer duels. His numbers were not bad, but the adaptation gap was real, and my model penalized him for it. On xG, his profile at Ajax was quite good: he was the type of midfielder who penetrates the box and finishes well inside the area. But when I placed that profile into Manchester United's structure, the problem appeared. United already had Bruno Fernandes in exactly that role. Football is a sport of space and time, and a player shines only when he has both. Van de Beek was at his best in the box, but that box was already occupied. His final TRI score was 8.5 out of 10. I publicly advised against buying at 35 million pounds. The reason was not that Van de Beek was weak. The reason was the mismatch between his ability profile and the team's structure, plus the league adaptation gap. The 2026-2026 results confirmed that mismatch: 4 Premier League starts, mostly on the bench, then a loan. But I must tell the rest of the story, the part few people quote. My TRI assessed the deal from the buyer club's angle, at a specific price, within a specific structure. It did not say Van de Beek would fail everywhere. If he had gone to a team that built its play around him, in a more suitable league, the result could have been different. A metric that is right in one context is not automatically right in another. That is the limit of data, and a professional must state that limit clearly before others draw their own conclusions. The Van de Beek story reminds me of the summer of 2026, when I followed the entire U20 World Cup in South Korea. I was 34 then, and I proposed to my newsroom that I travel to track every single match of a youth tournament few people noticed. I calculated U20 Venezuela's average PPDA and got a figure of 7.9, the lowest in the tournament. The lower the metric, the more a team presses high and effectively, the faster it wins the ball back. I wrote an article predicting Venezuela would reach the final, before the group stage even began. Colleagues laughed. A small South American team in the U20 World Cup final? But data does not know reputation. Venezuela reached the final, losing only 1-0 to U20 England in a match they deserved more from. From a youth tournament in South Korea, I read a pattern of how effective pressing works, and that pattern held true for years afterward. That was the first lesson that taught me real signals often lie where few people look. A year later, at the 2026 World Cup in Russia, I applied the same method to the biggest tournament. Before the group stage, I published a blunt article: Germany would be eliminated. My data base had two parts. First, Germany's average distance covered in recent friendlies was about 4.3 km per match lower than the teams in their group. Second, their xG differential was negative in the last three friendlies, meaning they created fewer chances than opponents and allowed opponents to create more. The article sparked fierce controversy. Germany were the reigning champions, a football machine. But that machine had slowed down while nobody wanted to look at the speedometer. The result: Germany lost 2-0 to South Korea, finished bottom of Group F, and were eliminated in the group stage. I became a pundit sought after by television stations. Russia 2026 taught me that the biggest risk is refusing to bet on data, even when data goes against the crowd's belief. But in the same tournament, I also predicted Brazil would win. Brazil fell in the quarterfinals to Belgium. I was wrong, and I left that error in my file. People usually remember only correct predictions. An honest analyst must remember the wrong ones too, because they teach us that data describes reality rather than divining the future. My model on Brazil was not structurally wrong, but it failed to account for one variable: a single match, over 90 minutes, can be decided by things no metric fully captures. From those three stories, Van de Beek, Germany 2026, and Brazil 2026, I drew a working principle. Every number in a spreadsheet must carry a confidence label. Certain data is labeled certain. Data needing more evidence is labeled clearly. Empty data is left empty, never filled with an assumption. This is the hardest discipline, because human instinct wants to fill the gap, wants an answer even without enough basis. In the transfer analysis profession, gaps appear everywhere. A player competing in a little-watched league lacks distance-covered data. A player just back from injury lacks stable form data. An emerging young talent lacks a sample to say anything. In all those cases, the wrong approach is to take a metric from another league, another season, or from reputation, and present it as if it were equivalent. I have watched clubs make exactly that mistake. They take a player's scoring record in a small league, multiply it by an arbitrary conversion factor, then conclude he will score that many goals in a bigger league. The factor sounds scientific but is usually just an assumption wearing a numeric label. When results disappoint, people blame the player, the coach, the weather, rarely the original assumption itself. The same happens with effort metrics. Distance covered and sprint counts are packaged as measures of effort and spirit. A player running 12 km a match is praised as tireless. But ineffective running also produces pretty numbers. A midfielder chasing the ball who never cuts out a pass, a full-back sprinting up and down who is always out of position, can both boast impressive distance covered. The number measures movement, not the meaning of movement. A professional must read the number alongside the position map, the team context, and the quality of the opponent. Another trap is load management. The term sounds very scientific: rotation, load reduction, volume management. But when you look at the real fixture list, key players still play almost every match, while summer commercial tours continue on schedule. Load management sometimes becomes a polite way of saying that room is being made for friendlies and commercial activity. Injuries rise, and people blame the crowded schedule, while that crowded schedule is partly created by the commercial machine itself. In that context, a metric like TRI is only valuable if it is honest about its own limits. It does not predict whether a player will succeed or fail. It estimates the probability of risk under a specific purchase condition. When I scored Van de Beek 8.5 out of 10, I was saying that in United's context, at that price, at that time, the risk was very high. Another club, in another structure, might score him 5 out of 10 and they might be right. Data has no universal ambition. It only has the ambition to be accurate within its scope. This is the point where I want to push back against my own professional environment. The current trend is to add metrics, add models, add data. Dozens of new advanced metrics are born each year, with increasingly complex names. Market pressure forces analysts to prove they are modern, to have their own model, their own algorithm. But more data does not automatically mean more understanding. Sometimes it only means more assumptions hidden behind an arithmetic shell. My counterintuitive view is this: in a market where everyone has data, competitive advantage lies not in having more data, but in knowing what you lack. An empty cell in a spreadsheet is often the most important signal, and the person brave enough to leave it empty avoids the mistakes the person who hastily fills it will make. The data arms race among the giants is like the brand arms race in transfers: both consume resources to defend position rather than necessarily to create new value. And real value usually lies where few people look. Small clubs, with limited budgets, are forced to seek players in markets the giants overlook. They have no money to buy stars, so they must buy right. Looking at transfer history, I find that the most valuable deals usually come from small clubs, where an unknown player is placed in the right role and shines. Meanwhile, the giants usually buy names already priced by the market, and they pay for reputation more than for untapped ability. Back to Van de Beek. That deal, seen from the small club's angle, is another story. Ajax trained him, placed him in the right role, and sold him at peak market value. It was a deal executed almost perfectly by the seller. The small club here is not the loser. They are the ones who best understood the real value of the player they owned, and they exited at the right time. The lesson I want to stress does not lie in who was right or wrong in a specific deal. It lies in how we handle gaps in information. At 43, I still hunt for the pieces the market has forgotten, but I have also learned that not every piece needs to be filled right away. Some empty cells must be left as they are until there is enough data to fill them, and that patience is sometimes worth more than a complex model. Football never follows emotion, but it always follows probability. That probability promises nothing certain. It only tells us what we are betting on, and with what level of confidence. A good analyst is not the one with the most correct predictions, but the one who states most clearly what he knows and does not know. Crisis is not for fear, but for rewriting the formula. When I look at the major tournament cycle approaching, what I track is not the already-famous stars. I track youth tournaments, the pressing metrics of little-known teams, the players whose data sheets still have many empty cells. It is in those empty cells that the signal of the next round is forming. And the question I set for myself is not who will win, but what, in this tournament's enormous pile of data, I am missing that nobody has yet admitted. If you work in analysis, try once leaving a few cells empty in your spreadsheet. Do not fill them with reputation, with feeling, or with a convenient conversion factor. Leave them empty, note clearly that there is not enough data, and wait. In an industry where everyone rushes to conclude, honesty about what you do not yet know may be the biggest advantage left.