A Five-Game Spreadsheet Autopsy: How Trustworthy Are Arsenal and Chelsea's Depth Charts

Chelsea's arithmetic hits you at once. In a single transfer window, thirteen came in and thirty-nine went out — twenty-two of them on loan. Arsenal's is almost the inverse: four attackers departed, and exactly one arrived. Same window, same league, but the two numbers speak different languages. One speaks the confidence of standing still; the other speaks speed and instability. I open the spreadsheet only after the broadcast ends; where the broadcast stops, the xG autopsy begins. And the first uncomfortable truth arrives immediately: inside the depth analysis circulating about these two clubs there is no xG, no PPDA, no minute load, no goal tally. There is only a list of names and a confident guess. Where a piece carries no measure, its argument carries no measure either — that is my first reading.

The season is five games old. The transfer window is closed, and before 1 January no one new can arrive — only the free-agent door stays open. Those two sentences contain the entire risk architecture of the season. Five games means an insufficient sample; a closed window means every gap becomes a three-month structural liability, because there is no mid-season purchase of a fix from outside. I have said it many times: a closed window turns every gap into a dated debt. You cannot hand out a title on five games of form; you can, however, sketch January's crisis from five games of gaps. Arsenal and Chelsea — two philosophies, one constraint.

Arsenal play 4-2-3-1, possession-based. Chelsea play 3-4-2-1, a back-three structure, in a new coach's hands. Both are current top-tier conventions — nothing novel. Creativity sits in two places for the two teams: at Ødegaard's feet for Arsenal, in the Palmer-Rogers pair for Chelsea. That resemblance is the loudest signal — both teams carry the same single-point dependency, only the location differs.

A methodological confession is required here. The depth chart I am analysing has an unspecified source, a truncated final sentence, and multiple player-club links that conflict with documented reality. Some names align with the summer 2026 window; some do not. The name the source shows as Chelsea's coach also conflicts with documented reality. In other words, this is not verified reporting but a speculative depth projection. So every conclusion I draw carries a condition: it is the model's proposal, not final truth. I treat circumstance as a discount rate, not an acquittal — the less information, the larger the discount. Where the context is weak, restraint is the best investment.

Arsenal's sharpest signal is their asymmetry. The right side — Saka, Madueke, Dowman — is more complete than the left. On the left, Tzolis is the sole specialist; Eze and Madueke are stop-gaps. The problem: pull them centrally and the cover thins elsewhere — especially for the injury-prone Ødegaard. This is the classic structural thinness of the left flank. In the congested weeks of the season, this thinness will become visible quickly. A left-side specialist is not merely an alternative; he protects the balance of the right, because the opponent is then forced to split attention across both flanks.

The double pivot (Rice + Guimarães) is deep on paper, role-overloaded in practice. Zubimendi is off form, Merino off fitness — so the pivot's depth is nominal. Depth is a dangerous word here, because a name on a list and a body ready on the pitch are not the same thing. I run the PPDA twice; the match has already confessed before that. A midfield that tells a story of depth should be stress-tested for press-resistance every match — and there, Zubimendi and Merino are currently an open question.

Another crack sits centrally. Havertz's early form made the striker selection easy, while Gyökeres fights to regain his place. The problem is not form but expectation. When a peak-age striker sits on the bench carrying an "expensive flop" label, morale decays fast. Where did the label come from? There is no goals-per-90, no xG-per-shot. The label is media-made, not data-made. And a label built without data can be erased with data — the question is only how many minutes will be granted.

Arsenal's academy pathway deserves attention too. Nwaneri's loan to Dortmund and Dowman's emergence show the pipeline works. But a pipeline is a future asset, not a present loan. If the academy fills the gap left by four attacking exits, the strategy succeeds; if not, the left-side thinness will tug all season.

Chelsea's 3-4-2-1 loads the creative burden onto two advanced playmakers (Palmer + Rogers) behind a lone No. 9. That means if an opponent neutralises one of the two, the system turns creativity-less. There is no second creator of equivalent profile on the bench — Estêvão and Gittens are wide forwards, a different role. This single-point dependency mirrors Arsenal's Ødegaard dependency. Two teams, one structural weakness — only the shirt differs.

Chelsea's real problem is not talent but cohesion. The analysis concedes directly that, despite many options, the numbers have not turned into solidity. Full-backs can switch sides or slot into the back three — but the structure has not settled. Between thirteen arrivals and thirty-nine exits, continuity has been lost; very few players have had time to put down roots. Cohesion is a slow variable — it cannot be bought, it must be given time, and time is the one asset this model invests least in.

The 39-exit, 22-loan model is really an amortisation-management engine. The loan army here is less a development pipeline than a balance-sheet tool — fees, wage reduction, residual value. Across modern Europe, this model sets transfer-market prices. So what Chelsea is doing is not only squad-building; it is financial engineering. A transfer is not a story; it is a vector with fees.

One policy correction stands out. Henderson (36), Welbeck (35), Martínez (34) — this influx of veterans is not accidental. It is an admission that the youth-heavy model lacked leadership. The dressing-room structure is now being bought from outside. It may work immediately, but within one or two seasons it creates another turnover cliff. Age is a specialist problem: experience arrives quickly, fitness leaves slowly.

The same reality applies to the young. Estêvão, Acheampong, Anselmino — potential is accumulating, but potential is not minutes on the pitch. Between stockpiled talent and converted talent lies the distance of a season. That distance defines Chelsea's position — not at the top, but at the junction.

Public pressure is a variable here too. Arsenal's pressure is internal — not crisis but surplus. Chelsea's is structural — the phrase "perpetual rebuild" is itself a self-fulfilling prophecy. The higher the expectation, the scarcer the stability. The Gyökeres storyline is the most volatile public-opinion variable in the piece, because it is explicitly tied to a morale threshold.

Fixture congestion and the weight of the international break are another invisible variable. As fixtures pile up, any squad's depth is tested — but this load is nowhere measured in the analysis. Fatigue and injury risk among players returning from international duty stay outside the model. A model that only counts names does not see this risk.

For readers meeting these terms for the first time, two definitions. xG (Expected Goals) is a probability metric — it measures how likely each shot is to become a goal; that is, it captures chance quality, not goal count. PPDA (Passes Per Defensive Action) measures pressing intensity; the lower the number, the more aggressive the press. Without these two metrics, the question "who played better" has only a guess for an answer.

And the window rule. Before 1 January, only free agents can be signed. Beyond that, Chelsea's 22-loan model engages international loan-limit rules — clubs cannot send more than a set number of players on foreign loan. The very existence of 22 loans is evidence that these rules are being actively managed.

A structural gap is also notable. The piece claims to cover "the six most-followed clubs," yet only two — Arsenal and Chelsea — are examined in depth. The other four are unnamed. So the league's overall balance of power cannot be measured. A map missing half its geography does not give the full picture.

And one more condition. The source claims Arsenal are "Premier League champions," which cannot be verified. If true, Arsenal's problem is not acquisition but defence — and the league's competitive centre of gravity shifts to North London, making Chelsea's rebuild a more uphill path. If false, one layer of the whole structure collapses. That single uncertainty shows why every conclusion must stay conditional.

Now the contrarian section, where the most caution is needed. First caution: correlation is not causation. "Chelsea's perpetual rebuild" and "Gyökeres the flop" spread quickly because they generate attention. But the faster a sentence spreads, the less testable it is. Without a metric, the word "flop" is unfalsifiable — and an unfalsifiable claim has no entry into my model.

Second caution: this kind of depth chart is really a commercial product. "The six most-followed clubs" — that framing prioritises audience numbers over competitive relevance. Where traffic is high, analytical depth is low. So such a piece is useful as a morale signal, but unreliable as a factual reference. From my thirty-nine years of watching, I can say: after hand-charting the PPDA of all 132 matches of the Bangladesh Premier League in Khulna in 2026, I understood — the eye of television and the eye of the spreadsheet are not the same. No crowd, no alibi; the model had to speak for itself.

Third caution — and the most counter-intuitive. Arsenal's problem is not crisis but surplus management. A title-grade squad with more quality than minutes. It sounds good, but history says this very surplus cracks dressing rooms during a title defence. Arteta's real test is not tactics but man-management. The task of "keeping certain players happy" is as hard as it sounds easy.

Fourth caution: circumstance must not become an excuse. In under-resourced football context matters, but context does not mean evasion. Budget, travel, pitch — these are a discount rate, not a release letter. For Arsenal and Chelsea the context is the closed window and a five-game sample; even so, structural decisions can be made, provided the conditions are written down.

And finally, the arithmetic of the closed window. Before 1 January there is no fix from outside. So Arsenal's left side, Ødegaard's availability, Saliba's fitness — each small question is a three-month structural liability. For Chelsea the same rule works differently: a lack of cohesion cannot be repaired by any single signature, and a closed window means that repair is postponed until January. A name on a list versus a role fulfilled on the pitch — that gap is the real risk.

The overall risk rating is medium-high. The difference is in nature: Arsenal's risk is concentrated (left side, Ødegaard, striker), Chelsea's is diffuse (cohesion, turnover). Both grow larger in a closed window. In a given week Arsenal can break on a single absence; Chelsea erodes slowly, window by window.

So what do I watch going forward? I do not predict finals; I audit the assumptions that made them possible. The watch-list is clear: how many matches Ødegaard plays, what share of matches Gyökeres starts, whether Chelsea's back-three structure settles, and who pushes the free-agent door in January. Each has a trigger and a likely outcome. The spreadsheet is a monastery; the whistle is its bell. When the bell rings I will return — because the match is over, but the model is still speaking.