An Empty Cell Is Also a Result: Auditing 'N/A' in Cricket Data

An Empty Cell Is Also a Result: Auditing 'N/A' in Cricket Data

On the third floor of a Koramangala office late on a Wednesday night, forty-three cells sat open on my screen. Twenty-nine of them carried the same two letters: N/A. Title N/A. Source N/A. Article type Unclassified. One-line summary blank. Author stance N/A. The information-points column completely bare. I closed the file three times and opened it three times. The first time I assumed the formula had broken. The second time I assumed I had loaded the wrong file. The third time it landed: what I was waiting for had never been delivered. The eight-dimension framework I had spent two days building had no fuel in it at all.

An empty cell in cricket does not carry a single meaning. Sometimes it means the ball was never bowled. Sometimes it means the ball was bowled and the scorer did not record it. And sometimes — the dangerous case — it means the ball was bowled, was recorded, but the system that was supposed to file the record never reached that ground. All three look identical on a sheet. All three require a different remedy.

The real question that night was not about numbers. It was about deciding which kind of zero I was looking at.

The framework I was running is an eight-dimension audit of cricket analysis: format and match nature, player technique and data, team landscape and ranking, league and commercial ecosystem, rules and governance, risk, public narrative, and industry transmission. Every dimension has its own gate, and the first gate is the most basic one — format. Test, ODI, T20 and The Hundred are four different games travelling under one name. Placing a T20 strike rate and a Test average on the same scale is like comparing a twenty-over total with a fifty-over total without mentioning the overs. In analytics that is not a stylistic preference; it is a structural constraint.

The second gate is entity: which player, which team, which board, which league. The third is a declared sample size. The fourth is source quality — byline or no byline, primary or secondary. If any one of these four is missing, the other seven dimensions stand on paper and do nothing in reality. This time all four were missing. Title N/A, source N/A, type 'Unclassified', not a single entry in the information-points list. The sheet that is supposed to sit beneath every conclusion was itself blank.

One distinction needs to be made here, because this is precisely where most analysis derails. Empty data comes in three kinds. The first is the measured null: we measured, the result was zero — a bowler taking no wickets in a format in which he actually bowled. The second is the unmeasured: we never measured at all. The third is the failed extraction: the process ran and the data did not come out. The first is a result. The second is a limitation. The third is a fault — and that fault sits upstream, not with me.

What came back was the third kind. That is not a guess. The return of 'Unclassified' is itself a signal: the pipeline did receive some input object, which is why it ruled on a type at all; had there been no input it would have thrown an error, not returned 'Unclassified'. So the source is probably not lost, only misrouted — a video page, a live-score widget, a paywalled stub, or a caption fragment entering an article-analysis stream. That is a medium-confidence hypothesis, not a finding.

In 2026 I was seventeen, living in Jayanagar, four kilometres from M. Chinnaswamy Stadium. That season I hand-coded all 3,360 legal deliveries of Royal Challengers Bangalore's fourteen IPL matches into a spreadsheet — phase, bowler, length, shot type — because the free stats sites offered no phase splits. The side finished last with three wins, with Virat Kohli and AB de Villiers in the squad. My sheet showed a death-overs economy of 12.1 runs per over, the worst in the league, with 61 percent of those runs conceded off full-length balls to the leg side. Three thousand three hundred and sixty balls later, that pattern had stopped being noise. I emailed a nine-page PDF to the franchise's general enquiries address. Nobody replied.

That was my first encounter with the gap I now call the measurement gap. The scoreboard recorded three wins and last place. It recorded nothing about a death economy of 12.1. The data existed and the system did not record it — and what is not recorded never turns up to testify in any cricket argument. I let the ledger speak before I trusted the scoreboard, because the ledger held evidence the scoreboard had never bothered to collect.

In 2026, midway through a statistics degree in Bengaluru, I took a remote coding internship with a data vendor through the IPL's UAE relocation — sixty matches across Dubai, Abu Dhabi and Sharjah, September to November, no spectators. Coding live, two things surfaced. In Dubai, after a powerplay wicket, the scoring rate of any side fell 1.4 runs per over between overs seven and fifteen. Sharjah's short boundaries inflated totals by roughly 19 percent. I wrote it up across forty pages. The outlet that commissioned it ran 900 words and cut the methodology entirely.

That was the moment I understood what a number becomes when it is detached from its derivation — a claim wearing the clothes of a conclusion. Nineteen percent alone is useless. Nineteen percent, with the note that it comes from a sample of six teams across four venues and is adjusted for boundary dimensions, can stand up in an argument. The empty stadium taught me that absence is also a variable — no crowd meant no pressure meant a different game between overs seven and fifteen. Yet the same lesson returned later from the opposite direction: absent data and absent methodology are both variables, and they are not handled the same way.

February 2026, the IPL mega auction in Bengaluru. Ten franchises, ninety-crore purses, six hundred names in the pool. I was twenty-two, finishing my degree, and built a rupee-per-win-share model off three seasons of phase data. My sheet put a valuation of 4.5 crore on an uncapped nineteen-year-old left-hander. Mumbai Indians bought Tilak Varma for 1.7 crore, and he made 397 runs that season. The franchise kept the sheet. I kept the lesson: a spreadsheet can hold ninety crore rupees and still miss the point.

All three stories share something, and it is not about numbers. It is about recording. The Chinnaswamy data existed and was never filed. The UAE pattern existed and its methodology was cut. The auction sheet was correct and went unused. India's cricket problem is almost never talent; it is almost always what the system can be bothered to record. The Women's Premier League launched in 2026 and India won a home World Cup in 2026, yet its data infrastructure remains thinner than the men's. The Ranji Trophy is close to invisible outside knockout rounds. The second XI is the hardest team in world sport to make today — not because there is no room, but because the route in is written down nowhere.

The empty Stage-1 I received is that same gap in miniature. The framework was not faulty; all eight dimensions stood in place. What was missing was the input — and a framework without input is a pitch without a ball: measurable, unplayable.

The greatest temptation here is filling the blank. In cricket media the blank is always filled by narrative, because narrative requires no verification. I see three concrete forms of that temptation. First, collapsing 'no risks identified' into 'risks unassessable.' If this report enters a briefing pack and is summarised as 'no risks found', that is a lie. The correct label is 'analysis not executed — input empty.' Second, inferring clean governance from silence. The absence of corruption-related information points does not mean governance is clean; it means we did not look. Third, small-sample enchantment. A twelve-ball spell will always supply a pattern. Set the threshold before running the query — and do not hide the threshold. I do not chase outliers; I interview them until they confess.

The only honest outcome of this exercise is that no cricket conclusion emerged. No player was rated, no team, no league, no risk. That is discipline, not failure. A ledger that only ever reports surprises is not a ledger — it is a column with a theme.

Six things are needed for the next round, and this is the signal list that matters most right now: the title, source and publication date; three to ten discrete information points, each with its own number; the format and nature of the match; named entities — players, roles, teams, boards, venues; a one-sentence summary of the piece with the author's stance and purpose; and every number present in the article, verbatim, with its format label attached. With those in hand, all eight dimensions run at full depth.

Be suspicious of any ledger that fills every time. The next time a scoreboard hands you a large number, ask one question — where is the sheet beneath it, and how many of its cells are empty?