The Empty Spreadsheet and the First Question: Format, Entity and Time-Sensitivity in Cricket Analysis

The Empty Spreadsheet and the First Question: Format, Entity and Time-Sensitivity in Cricket Analysis

Opening the file took four seconds. Understanding it took four minutes. In May 2026, when I was sixteen and sitting ten kilometres from the MCA ground in Pune, I re-plotted forty-three overs of field placements from that IPL final in Hyderabad into a school notebook. Rising Pune Supergiant finished 128 for 8; Mumbai Indians reached 129 for 8; the match was lost by one run. That notebook had every ring, every gap, every bowler's release angle. Back then I thought preparation meant a filled page.

Eight years later, in February 2026, the page in front of me was completely empty. Stage Two of a cricket analytics package: eight dimensions, prepared tables, headers, sub-headers, a risk matrix, confidence tags, and N/A in every cell. The one part on which everything else rests was blank: the information-points list. No title, no source, no article type beyond "Unclassified". No team, no player, no board. No format. A single domain label was attached — cricket_world — which established only that the subject was cricket.

That was the actual story. And it is not a story about a match, a series or an auction. It is a story about the routine we call cricket analysis, and about the fact that the weakest component in that routine is never the number. It is the format token.

Context: Eight Dimensions, One Door

The skeleton of any cricket analysis has eight parts. First, format and match nature. Second, player technique and data. Third, team landscape and rankings. Fourth, league and commercial ecosystem. Fifth, rules and governance. Sixth, risk. Seventh, public narrative and expectation. Eighth, industry transmission.

The door to every one of those dimensions opens from the format. Test, ODI, T20 — these are not three different sports, they are three different rulebooks. Their metrics are not interchangeable. In T20, strike rate is the question you ask; in Test cricket, batting average is the question you ask. Both are answers, but they are not answers to the same question.

I still read that 2026 school notebook in three layers. The first layer is what any broadcast shows you — 128 against 129, a one-run gap. The second is what the scoreboard never writes down — the over in which the required rate crossed the line where wicket risk becomes more expensive than run benefit. The third is what no statistics table contains — the over in which the field map tells you the bowling side already knew where the next ball was going.

I keep a field map for the moments the scoreboard forgets. That is not a hobby; it is a discipline. And that discipline becomes worthless the moment you cannot establish which format the match belonged to.

In December 2026, in Adelaide, India's second innings ended at 36 all out in 21.2 overs. Josh Hazlewood took 5 for 8; Pat Cummins took 4 for 21. That day I did not write a reaction. I logged dismissals — delivery type, length, the batter's trigger movement. Campus was shut, I was home, I was nineteen. There was no mood in that list, only ball 14, ball 31, ball 47.

This is the discipline that demands a format. Adelaide's 36 all out is a red-ball event: the seam of the new ball, the drying pitch, the session structure and the follow-on rule all count. Anyone reading that same event through a T20 clock — powerplay, death overs, economy — is not analysing; they are painting one game's colour onto another game's photograph.

That is exactly what was missing from the empty file. And its absence closed all eight dimensions at once.

Core: A Filled Template Is Not an Analysis

Start with what the empty package did contain. A populated table. Fifteen to twenty rows. Each row with a dimension, an assessment, a note. And in every cell, the same three words: "N/A — insufficient information." No dimension was called low risk, or strong, or weak, because there was no basis to say so. That was not humility. That was correct method.

In cricket analysis, the most violated rule is this: absence of evidence is not evidence of absence. If I do not have a team's injury list, I cannot write that injury risk is low. I can only write that the risk is unassessable. The difference looks small. The difference changes the credibility of the entire report.

The second thing the package contained — and its greatest weakness — was the domain label. cricket_world. That word is not enough to open a single dimension, but it is enough to create an illusion. And that illusion is the central problem of today's cricket-media pipeline. A filled template reads like an analysis. Strong headers, clean columns, space for numbers, tags. A downstream reader — sometimes a downstream editor — treats it as low-signal but valid analysis, when in fact it contains zero content. No conclusion in such a report can be challenged, because there are no conclusions. And a conclusion that cannot be challenged is not analysis; it is assertion.

The third point is technical, but its effect on the sport is direct. The package carried no format token. Which means that if a partial extraction had succeeded tomorrow — a score, a player name — the danger would remain: cross-format contamination. A Test batting average sitting in the same column as a T20 strike rate. That is the error that never shows up in a report, because reports show numbers, not their passports.

I have a live example. February 2026, the Under-19 World Cup in New Zealand. India beat Australia by eight wickets at Mount Maunganui, and eighteen-year-old Shubman Gill finished the tournament with 372 runs and the Player of the Tournament award. I logged his scoring zones by hand across seven matches, then rebuilt the sheet in Excel after starting a BSc in Sports Science at Savitribai Phule Pune University that July.

One thing stood out in that sheet: Gill's cover drive was governed by where the ball pitched, not by where the fielders stood. That is a format-dependent conclusion. It belongs to the white-ball game. Anyone carrying that conclusion to the red ball without re-testing it is not building a Test XI from Under-19 data — they are treating two pitches as one map.

That is why the empty package's posture was right and its format was wrong. It was right not to write a conclusion without a format. It was wrong to look like a conclusion without one.

Context Rules: One Variable, and Its Failure Mode

I never file a tactical piece without one variable I can defend. Pitch length, release point, scoring zone — one of them. It makes my copy slower and harder to argue with. Editors send me the eye-test disputes for precisely this reason.

But a single variable has a side effect: it hardens into a verdict. A dot-ball rate, or one purse figure, becomes the whole causal story. The cure is one line — name the variable's failure mode, the condition in which this metric lies.

T20 powerplay scoring rate is the cleanest example. The scoring rate across overs one to six is an independent analytical unit. But it is not a proxy for overall batting strength. On a flat home deck with short boundaries it flies; the same batter looks slow against the new ball in the first session. And in Test cricket there is no powerplay restriction at all — the rules change.

In the recent two-innings IPL structure, the meaning of the powerplay has shifted again, because losing two wickets inside the first six overs now costs you far more by the thirtieth. That is format engineering, and it invalidates any analysis built on over-by-over rules from two seasons ago. Which is why I keep my forecasts inside a six-month horizon. It is the furthest a model can honestly reach in this sport.

The Language of Numbers: Team, Squad and Market on One Sheet

The empty package had both team and league blank, which closed two dimensions: team landscape and commercial ecosystem. These are not separate. They are two columns of the same sheet.

Retention lists, mega-auction purses, bench composition — I read all three as resource-allocation problems. India's real selection crisis is not a shortage of talent. It is scarcity pricing: too many credible roles chasing too few slots. When one team has three wicketkeeper-batters who can all play at number five, selection stops being a question of ability and becomes a question of opportunity cost.

The package also left a second rule unopened: a high auction price is not international strength. Both attach to the same name, but they travel by different roads. International strength is measured in match situations — when the required rate climbs, when the pitch starts turning, when the new ball is shining. Auction price is measured by demand and supply. Both metrics are correct. They are not answers to the same question.

The same logic has a time-sensitive form: the NOC, the No Objection Certificate, the board's permission for a player to appear in an overseas league. When the league window and the national calendar collide, the fight is not about a player's loyalty. It is about dates. And dates are more powerful than sentiment now.

Franchise scouting has quietly taken over the pipeline work that zonal selectors once did. That is the privatisation of the pipeline, and it means the first filter of selection now runs in a franchise data room rather than on a ground.

Risk: Calling the Unassessable Low Is the Real Offence

The sixth dimension, risk, was fully closed in the empty package. N/A in every category. There is a subtle point here that most reports get wrong. Six risk classes were listed — sporting, personnel, commercial, rules and integrity, public opinion, systemic. None was rated low.

That was correct. Injury risk, schedule overload, cross-format transfer, positional drop-off, condition adaptation, league poaching, coaching turnover, valuation rollover — none can be scored without a name, a team, a date. And filling any of them in with "low risk" is the biggest mistake available, because absence of evidence is not evidence of absence.

On integrity my position is fixed: without a named party and an event, the category is not raised. Spot-fixing, pitch or weather manipulation, abnormal odds movement — these are real risks, but they are worth mentioning only when a party, an event, an allegation exists. Writing integrity fear onto empty space is not analysis; it is defamation preparation.

One risk was added to the package that normally never appears: analysis-process risk, the risk that an empty package is mistaken downstream for valid analysis. It was rated high, and I think that rating was right.

Contrarian: The Damage Is Not the Empty File, It Is the Template That Looks Full

I read an empty file not as a machine's fraud but as a machine's honesty. It did not write what it did not know. Filling N/A into every column looks like technical failure, but it is in fact the strongest link in the process.

What is more serious, and what this package exposed precisely, is this: the biggest threat in cricket analysis today is not incomplete information. The threat is that a fully filled table gets mistaken for evidence.

You can see the same error every day on a scorecard. Twenty endpoint-like metrics become available in a match — run rate, boundary percentage, dot-ball percentage, average against spin, death-over economy. Their existence is not their meaning. Just as thirty routes appearing on a system is not thirty vulnerabilities. A route's existence is not its exploitability. A metric's existence is not a conclusion.

The clearest example is the finals we rewrite as pressure stories. The Ahmedabad World Cup final of November 2026. The 2026 and 2026 World Test Championship finals. All three were narrated as temperament, nerves, brittleness. I have the over-by-over record. All three showed the same pattern: the over in which the required rate crossed the line where wicket risk becomes greater than run benefit — and the ten overs that followed.

Treating those three as fate is converting a spreadsheet into myth. A collapse is not fate; it is a sequence. Ball 14, ball 31, ball 47.

The second contrarian point: an unrecorded source is permanent damage. The package's source field was N/A, and that N/A was not merely today's problem — it was tomorrow's. Even if the content is later recovered, a medium whose name was never logged can never be graded for track record. That is a loss re-extraction cannot repair.

The third contrarian point works against my own discipline: the ninety-minute clock. T20 is the format where sequencing and clock are legible, so my instinct is to apply the same lens to Ranji and Test innings, where draw, follow-on and session context actually govern. My remedy is a habit: I state the format's rules of evidence at the top of the piece. If the clock metaphor does not survive a Day Three session, I drop it.

Transmission: Empty Upstream, Empty Downstream

The eighth dimension is industry transmission, and its structure is simple: upstream youth development and talent supply, midstream national teams and leagues, downstream broadcast and commercial markets.

Transmission analysis requires a triggering event — a rights deal, a star transfer, a league expansion, a governance ruling. The empty package had no trigger. So no path could be traced from top to bottom. This is not merely a data gap; it is the entire chain on which the sport's money flows going empty.

One clarification matters here. Betting and fantasy markets sit outside the scope of any advisory output. They are read strictly as one objective information signal — and here there was no signal at all. When the first link in the chain is empty, no forecast can be made about the last link.

Takeaway: The Next Time the Sheet Comes Back Empty

The spreadsheet was not the answer; it was the first question with cells. Over the next six months, cricket data desks face one direct test, and it will not be a test of scores but of process: when material arrives without a format token, does the desk publish, or does it stop?

Stopping is the analysis. An empty sheet is a result. Publishing it converts the result into myth.

In cricket I never carry my forecasts beyond six months, because no model in this sport can stay honest further out. But within six months one thing is settled — the next analysis that lands will not open with who won. It will open with which format the match belonged to.