The Night of the Empty Spreadsheet: Football's Nine Dimensions of Analysis

Two in the morning. A spreadsheet open on a laptop screen in a London flat — fourteen columns, twenty-six rows, every cell empty. The match finished four hours ago. The moment the final whistle blew, the twenty thousand subscribers to my newsletter started waiting for a take. But I had no data. Only a trending hashtag, three clips I'd filmed on my phone, and a story I wanted to tell, already forming in my head.

That night I made a decision that permanently changed how I work. I will not build a narrative out of an empty cell.

Football analysis is really a workbook — nine separate sheets, nine separate dimensions. Most pundits, most talking heads, most social-media influencers collapse all nine sheets into one. They decide the story first, then hunt for the data to back it. I learned to walk the other way. Data first. Story second. And when there is no data, admit it plainly — no information, therefore no analysis.

This piece is about those nine dimensions. And about why an empty sheet may be your most valuable asset.

Context: When the Balance Sheet Talks, Not the Scoreline

August 2026. I was working night shifts in London as a betting-market analyst. When news broke of Neymar's €222m move to PSG, the whole football world said the same thing in unison — this is football inflation, this is madness. I wrote a 2,400-word piece arguing the opposite: that €222m was not an outlier, it was the rational purchase of the last unclaimed global brand, priced like a broadcast-rights deal. Three national podcasters mocked me on air that week. Within a season, PSG's commercial income climbed past €300m, and my piece was quoted in two finance newsletters. Four months later I quit my job.

That first take stood on a balance sheet, not a scoreline. Since then, every take of mine has to pass an economics test first. I started opening pieces with a number — a fee, a wage bill, a revenue line. I stopped writing match recaps.

But money and incentives are not the whole picture. The transfer market, tactics, public opinion, rules, the dressing room — these are separate layers. To analyse a match or a tournament you have to open nine separate sheets. This piece opens those nine sheets, and shows why an empty sheet should never be filled with a lie.

Core Analysis: Nine Sheets, Nine Dimensions

1. Tactical and Technical Dimension

The first tactical question is never \"who won\". It is \"what was the process\". Two metrics are unavoidable here — xG (expected goals, the probability a given shot becomes a goal) and PPDA (passes allowed per defensive action; the lower the number, the more aggressive the press).

I used to think the set piece was a phase, a fashion that came and went within a match. Twenty-six days in Russia in 2026, watching eleven matches myself, broke that idea. In Nizhny Novgorod, England beat Panama 6-1, and five of the six goals came from dead balls. Two days later I filed \"The World Cup Is Now a Set-Piece Sport\". England finished with 12 goals, nine of them from dead balls. I called Croatia as finalists before the quarter-finals. The piece was shared more than 90,000 times.

From that trip a rule hardened: a tactical claim must never rest on one match's feeling; it needs at least a season-long sample. Watching now, I film twenty-second clips from the stands — formation versus in-game shape, pressing scheme, transition profile. These are my primary evidence, not a pundit's quote.

But here is the first trap. The set-piece thesis was so powerful that I almost started ignoring open-play data. If a team scores from corners, it looks good — but is it sustainable? If the opponent abandons zonal marking for man-marking, the whole calculation changes. So every tactical claim now runs through three questions: what does the open-play data say, what is the opponent's adjustment, and how large is the sample.

2. Club Finance and the Transfer Market

Four columns are unavoidable on the finance sheet — broadcasting revenue, commercial revenue, wage bill, net debt. FFP (UEFA's Financial Fair Play) and PSR (the Premier League's Profit and Sustainability Rules) define how much a club can lose and spend.

I used to think the €222m was an outlier. Then the whole market copied it. Over the following windows the fee ceiling rose so fast that Neymar's price no longer looks abnormal. That is the market's lesson — a transfer does not just buy a player, it sets a valuation benchmark that an entire league imitates.

The most useful signal on this sheet is the \"panic premium\" — the above-fair price paid under deadline-day or public-opinion pressure. To catch it you need at least two things: a fee and a comparable-deal anchor. Without the comparison, calling a price \"too high\" is mere feeling.

Another thing I love to write about is the contract year, often tied to form swings or renewal brinkmanship. When a player enters the final year of a deal, you have to read the performance data and the negotiation data together, or you see only half the picture.

3. Results and the Public-Opinion Cycle

Results and process do not always move together. A team can lead on xG and still lose, or win on low xG. Where the gap between process and results is wide, it is either luck or volatility — and both are temporary.

My biggest error happened here. On 16 May 2026 the Bundesliga returned behind closed doors. Within 72 hours of the first full round I filed \"Home Advantage Was Never About the Crowd\" — home sides had won just two of nine matches. My claim was that this was permanent, and that clubs should reprice season tickets.

By early 2026, home win rates had reverted almost exactly to pre-pandemic levels. My correction video out-performed the original claim.

That shock taught me two habits. First, every prediction now carries a timestamp and an expiry date, plus a short line — \"how this breaks\". Second, I sped up, filing within hours of full-time rather than days, accepting that some calls would age badly in exchange for being first into the argument.

4. League Landscape and Team Positioning

A league is really a food chain — title contenders, European spots, mid-table, relegation zone. Where a team sits is set by its squad market value, financial power and academy output.

On this sheet I always look for \"talent-flow signals\" — how high the risk of core players being poached, and what tier the recruitment targets are. If a club keeps selling its best players, then no matter how high its table position, the real vector points down.

5. Rules and Governance

Behind every club story sits a rule system — FFP, transfer registration, sanctions, competition eligibility. This sheet tracks three scenarios: worst case, central case, optimistic case.

A warning is essential here. I do not reach a conclusion before an alleged breach is even raised, because modelling a sanction requires at least one regulatory hook — financial, transfer, or disciplinary. Without one, the conclusion becomes guesswork.

6. Management and the Dressing Room

How safe the coach's chair is, how patient the owner, how good the recruitment decisions — none of this is written on paper, but all of it shows up in results.

Three signals measure dressing-room health: leadership structure, manager–player relations, generational transition. This is where two lenses apply — the \"new-manager bounce\" (a short-term results improvement after a coaching change) and the \"contract-year breakout\".

7. Risk Profile

Risk comes in six kinds — sporting, financial, personnel, rules, public opinion, systemic. Each needs its likelihood and impact assessed separately.

Here I must mention a meta-risk almost nobody writes about: when an empty or incomplete dataset is treated downstream as valid, the analysis turns into fiction. That is my biggest fear now, because bad information does far more damage than a bad decision.

8. Media Narrative and Expectation

A narrative has a life cycle — emergence, climax, backlash. How long a story lasts depends on its fundamental support and its sample size. The ratio between social-media heat and on-pitch reality is the real signal.

In my own work, the most durable takes come from the expectation gap. On 11 June 2026, hours after Italy beat Turkey 3-0 in the Euro 2026 opener, I named Italy champions while the rest of the coverage was busy with France and Belgium. The reason was Roberto Mancini's 28-match unbeaten run and a settled eleven with nobody over 34 in a fixed role. Italy reached the final at Wembley on 11 July and won on penalties.

9. Football Industry Transmission

The last sheet is the widest view — upstream the academy and talent supply, midstream clubs and competitions, downstream broadcasting, commercial and derivative markets. A transfer, a sanction, a retirement — any single event transmits through this chain.

I often see the link between these two dimensions in the crossover between football and esports. In both fields a meta-shift — a new style of play — restructures the whole ecosystem, and those stuck in the old meta are left behind.

The Contrarian Angle: Where This Framework Breaks

If I now interrogate my own argument, three gaps are clear.

First, the nine dimensions cannot always be measured at once. In some matches finance and rules are entirely irrelevant — only tactics and process speak. Forcing every sheet to be filled is not analysis, it is manufactured completeness.

Second, data is itself a narrative. What a model of xG actually counts depends on its definition of shot quality. Two models can give different numbers for the same match. Data does not mean truth — data means a measurement whose limits you must know.

Third, speed and accuracy never arrive together. A call written within hours of the final whistle will sometimes be wrong. On 22 November 2026, six hours after Argentina lost 2-1 to Saudi Arabia in Lusail, I wrote \"Argentina Will Still Win This World Cup\". The reason was a 36-match unbeaten run before the tournament and Messi's managed minutes. On 18 December Argentina lifted the trophy, beating France on penalties. The piece passed 600,000 views.

But that success is my biggest trap. \"Buy the dip\" — picking a fallen favourite within six hours of a shock result — became my core format. And it made me impatient with patient, balanced analysis. I know how many failed calls are buried behind each successful \"buy the dip\", even if I have never counted them myself.

Takeaway: A Testable Prediction for 2026

The 2026 World Cup is coming with 48 teams and 104 matches. My prediction: the most frequent analytical error at this tournament will be about squad depth, because the expanded format will turn heat, travel and the five-substitute rule into a separate game in the final twenty minutes. The teams arriving with deep squads will look mediocre in the group stage but survive the knockouts. The teams arriving with only a star-narrative will not understand where they suddenly vanished.

If my subscribers learn one thing, let it be this — when you have an empty spreadsheet at two in the morning, that is the biggest test. Filling the cells with a lie is easy. But the truth is, the best analysis is never the one that answers every question — the best analysis is the one that can honestly say which cell is still empty.

Which cell have you left empty?