The Knee Spreadsheet: A 27-Crore Paddle, a Torn ACL, and Cricket's Missing Medical Column

On the auction stage in Jeddah, on the evening of 24 November 2026, the number kept climbing — 18 crore, 20 crore, 23 crore, 25 crore. A wicketkeeper-batter was on the block. Back home in Mymensingh I had a second column open, one nobody on that stage was reading: 30 December 2026, a road accident near Roorkee, a torn anterior cruciate ligament in the right knee.

The paddle stopped at 27 crore rupees. Rishabh Pant, Lucknow Super Giants — the most expensive cricketer in IPL history, 23 months after the crash.

I opened a blank spreadsheet because destiny had too many missing values. The question was not complicated: what exactly did Lucknow buy for 27 crore?

The easy explanation offered that evening was that budgets had grown, so prices had grown. True, and incomplete. An IPL auction is not a football transfer window. In football a club negotiates, then puts the player on a table and scans him; a bad report can void the deal. Cricket does not have that gate. The paddle goes up first, and there is no single, public, mandatory medical protocol that can stop the price. Every transfer rumour is a data point until the medical is done — a line I write about football, while my own sport does not even keep that safeguard.

Consider the structure of the 2026 mega auction. Ten franchises, a purse of 120 crore rupees each, and the Right to Match card abolished outright. In 2026 the purse was 90 crore with the same ten teams; in three years the league's auction capacity grew by roughly a third, and a protective gate disappeared at the same time. With RTM, a franchise could wait, let the market set a price, then match it. Remove the card and that threat evaporates; the ceiling floats. Cricketers did not suddenly become better. The market got bigger.

My habit of counting began earlier. In 2026, during the World Cup semi-final, I built a spreadsheet on Croatia — every progressive pass under pressure, Modric's 13.1 kilometres, Croatia's 2.3 expected goals against England's 1.4. From that night, xG became the spine of my match previews, and I needed a metric before I was allowed to type the word "destiny".

The empty-stadium work in 2026 taught me something else: home advantage is a column I had never questioned. In grounds without crowds, home attacking output fell and away pressing intensified. I carry the same suspicion into the auction hall. Everyone is watching the scoreboard; the price is being built somewhere else.

Add three columns and 27 crore falls out: market structure, scarcity bonus, and on-field output. The output column carries the least weight of the three; IPL prices rise from scarcity, not from performance.

The arithmetic of structure is simple. In December 2026, Sam Curran cost 18.5 crore, then a record. In December 2026, Mitchell Starc went for 24.75 crore and Pat Cummins for 20.5 crore. In November 2026, Pant went for 27 crore, Shreyas Iyer for 26.75 crore, Venkatesh Iyer for 23.75 crore. Across two auction cycles the record price rose 46 per cent. Did anyone genuinely believe cricketers improved 46 per cent in two years?

The scarcity column is harsher still. Ten franchises each need a wicketkeeper who can bat in the top three, and ideally captain. Sanju Samson, KL Rahul, Ishan Kishan, Jitesh Sharma, Dhruv Jurel, Rishabh Pant — the names fit on one hand. An IPL XI can field only four overseas players, so Indian quality is the binding constraint. Demand from ten teams; supply of a handful.

Then comes the column nobody opened. My kinesiology training says nine to twelve months is a normal return window after ACL reconstruction, but the six to nine months after returning is the most dangerous stretch — the graft is not yet fully trustworthy, and the body wants to return faster than the mind. Whether the reconstruction used a patellar or hamstring graft matters, because the two behave differently when a keeper squats. A keeper's job is a squat, a landing, a lateral dive, repeated.

Twenty-three months is a comfortable timeline. But where, inside a 27-crore valuation, did the uncertainty about that knee go? Nowhere — because the column does not exist on the form. In football the medical is a blocking gate inside the deal. In a cricket auction it is a polite assumption delegated to the buyer's conscience.

With a returning keeper I count three things, not for comfort but for decisions. Dives per over in either direction, because a keeper who distrusts a knee moves his feet early and produces half-dives. Squat depth at the stumps, because an uncertain knee lowers the thigh less and the gloves arrive late to low catches. And the first five metres between the wickets — not speed, acceleration, the cruellest test of controlled deceleration. The eye test is a feature, not the whole model, but those three features do much of a scan's work when there is no scan.

The Impact Player rule changed the arithmetic of scarcity, and the price sheet has not fully absorbed it. Since 2026 a substitute means an XI no longer has to be balanced the old way; a specialist batter or a specialist bowler can be slotted in. The premium paid for a two-skill all-rounder is therefore driven more by narrative than by the field. Venkatesh Iyer's 23.75 crore is a receipt for that mismatch.

Football fans know this error well: a goalkeeper who can kick it long gets a fee bump while the fundamentals of shot-stopping quietly decline. Cricket has a mirror version. When a side demands a "three-dimensional" player, the extra money goes to the secondary skill, while matches are won by the primary one.

One more missing column is the venue. Batting at Chinnaswamy or Wankhede is not batting at Chepauk or the Ekana Stadium — same player, same shot, different numbers, because boundary dimensions and pitch pace differ. Pricing a player off a raw strike rate is an attempt to fit two realities into one frame. My sheet carries a home-adjusted strike rate, and it breaks a lot of stories.

Take December 2026. Travis Head cost 6.8 crore rupees — almost nothing beside Starc's 24.75. That season his top-order destruction became the chassis of Sunrisers' batting. The market called Head cheap because no mega-buyer fought for him, because Starc's name led the auction headlines. Price and value are not the same thing: price is made in the auction room, value on the field.

Now let me push against my own argument, otherwise this is just a pleasant story. In the 2026 auction the two costliest buys were Starc at 24.75 crore and Cummins at 20.5 crore. That season ended with a Kolkata Knight Riders versus Sunrisers final, and Kolkata won. The market could and did pat itself on the back.

A year later the picture inverted. Pant's Lucknow missed the playoffs; Shreyas Iyer, at 26.75 crore, dragged Punjab Kings into the final. Two seasons, opposite outcomes, identical logic. Price is not a forecast; it is a lagging indicator. Correlation is not causation — a magnifying glass makes letters look bigger, but they are not bigger.

The real differentiator was the retention core, which never trends. The 2026 champions took the heaviest pre-auction criticism; pundits called the squad unbalanced and the bowling thin. They won because the spine had already been held back — Virat Kohli, Rajat Patidar, Yash Dayal — names priced by the retention sheet, not the bidding war. A big buy is a bet; a retention is architecture.

One honest caveat: my evidence is two years old. Two mega auctions without RTM, two finals. Building a rule on two samples is exactly the error I flag in other people's auction analysis. A decision tree is just a disciplined argument with branches you can audit, and one branch must always read: not enough information yet. A knee does not live in a spreadsheet; only its output does. That is the limit of my model, and knowing it is part of the job.

Three signals to watch next cycle: whether cricket's auction system ever installs a mandatory, public medical gate; whether bidding reform moves toward closed or blind bids to stop price spirals; and whether India's wicketkeeper-batter scarcity is diluted by new names, which would test how durable the old records really are.

And what you will not see: the next time a player returns from knee reconstruction in fourteen months, the market will not discount him. The column required for a discount has never been opened. The market moves first; my model just keeps a receipt — and the bigger this cycle's receipt, the more expensive the next cycle's correction.