Ben Mayhew

11.6K posts

Ben Mayhew banner
Ben Mayhew

Ben Mayhew

@experimental361

Football analysis & visualisations with an @EFL bias. Former Head of Data Analysis @PA. Lapsed astrophysicist. @TUFC1899 fan.

United Kingdom Katılım Haziran 2011
858 Takip Edilen39.3K Takipçiler
Sabitlenmiş Tweet
Ben Mayhew
Ben Mayhew@experimental361·
Trying out another new template: recalculating the league table after each minute of play to show when teams performed relatively well (and not so well). Each mini-chart highlights an interesting cut-off for a team. Full explanation via the link: experimental361.com/p/minute-by-mi…
Ben Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet media
English
3
16
89
35.5K
Ben Mayhew
Ben Mayhew@experimental361·
Stoke weren't able to end their wait, although they'll get another chance if their game with Sheff Wed goes ahead. I've written something on the longest waits for a team to sit top and bottom of a table here, and the latter is even more interesting: experimental361.com/p/which-club-h…
English
0
0
6
5.4K
Ben Mayhew
Ben Mayhew@experimental361·
By my reckoning if @stokecity are still top of the @SkyBetChamp at the end of today, it'll be the first time since 27 April 2008 that they've ended a day top of a league table. At 17 years 3 months 12 days it's the longest such drought among any of the current PL and EFL teams.
Ben Mayhew tweet media
English
4
6
38
17.8K
Ben Mayhew
Ben Mayhew@experimental361·
I've created squad retention charts at the top European leagues (Italy, Spain, Germany, France, Netherlands & Portugal): experimental361.substack.com/p/squad-retent… I thought there was a bug when I saw Alverca's profile, but it turns out they have only one player left from last season.
Ben Mayhew tweet media
English
1
0
13
6.4K
Ben Mayhew
Ben Mayhew@experimental361·
@JheriMr Not just off these numbers, no. I guess the quality of recruitment (and perhaps how early you get it done) is a bigger factor. I have a deeper dive into this data on my "to do" list to see if there's anything interesting in subsets of it.
English
0
0
1
52
Ben Mayhew
Ben Mayhew@experimental361·
I am continuing to refresh the squad retention graphics on a weekly-ish basis: experimental361.com/p/squad-retent… Leyton Orient now without 7 of their 8 most-used players from last season.
Ben Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet media
English
3
16
77
32K
Ben Mayhew
Ben Mayhew@experimental361·
@OdelBet Yes I'll add it as a link to the post. I didn't include it initially as I wanted to get some early season lineup data to help me catch anyone that I missed.
English
0
0
0
36
Ødël Triv
Ødël Triv@OdelBet·
@experimental361 Hi Ben, will you upload the squad churn Excel file like in the last few seasons? Thank you, you're doing an amazing job. 👏
English
1
0
0
57
Ben Mayhew
Ben Mayhew@experimental361·
As the new EFL season is almost here, I've updated the fixture difficulty grids as promised: experimental361.com/p/analysing-th… The PL version will also get a refresh in early August.
Ben Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet media
English
0
2
4
8.1K
Ben Mayhew
Ben Mayhew@experimental361·
@Marco4J Yes it feels like some combination of squad depth, fitness and game management would explain a lot of these. By the time I use these again next season I'll hopefully have enough reports running to pinpoint exactly what's up with each team (e.g. sub usage).
English
0
0
0
305
Marco4J
Marco4J@Marco4J·
@experimental361 Do we conclude that the teams that tail off have weaker benches, and thus squads whereas those that improve (Bolton, notably) perhaps need to put more into their first XI and keep less quality in reserve?
English
1
0
0
704
Ben Mayhew
Ben Mayhew@experimental361·
Trying out another new template: recalculating the league table after each minute of play to show when teams performed relatively well (and not so well). Each mini-chart highlights an interesting cut-off for a team. Full explanation via the link: experimental361.com/p/minute-by-mi…
Ben Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet media
English
3
16
89
35.5K
Ben Mayhew
Ben Mayhew@experimental361·
I've started tracking squad retention for every Premier League and EFL club - this page will be refreshed regularly during the transfer window: open.substack.com/pub/experiment…
Ben Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet media
English
0
7
22
10.5K
Ben Mayhew
Ben Mayhew@experimental361·
@AshleySLawrence I figured out what happened - some of Man City's odds are skewed by the potential FFP punishment e.g. their relegation odds are around 20/1 (compared to 300/1 for Newcastle). Annoyed at myself as I caught this last season!
English
0
0
1
647
Ben Mayhew
Ben Mayhew@experimental361·
@AshleySLawrence Thanks for spotting that - not sure how it happened! Some quirk in how my code aggregated the various outright markets I think. Fixed in the post now.
English
1
0
1
796
Ben Mayhew
Ben Mayhew@experimental361·
Added a batch of post-season visuals to the site today, including scatter graphics, game states, league table footprints and a reworked set of squad age profiles (all available via this link): experimental361.com/p/plans-for-20… More to follow over the coming weeks.
Ben Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet mediaBen Mayhew tweet media
English
0
6
28
20.9K
Ben Mayhew
Ben Mayhew@experimental361·
@Sam29403527 @secondtierpod I just had a look at Southampton and I think the difference is that I've not included play-off games (2 wins and a draw in their case).
English
0
0
0
43
Roppick
Roppick@Roppick·
@experimental361 Love those Viz', fantastic work 🤩 (and also wish there was one for french Ligue 1 😅)
English
1
0
0
56
Ben Mayhew
Ben Mayhew@experimental361·
@PhilLUFC @thehuwdavies @NTT20Pod I've "unravelled" them into straight lines before, so like what you've shown but with the slices still in the same order from 0-100. I guess there's always a trade-off with these choices e.g. your version brings out the percentages more and is easier to re-size / scale.
English
1
0
2
89
Phil Braithwaite
Phil Braithwaite@PhilLUFC·
@experimental361 @thehuwdavies @NTT20Pod Actually, a further bit of feedback... The pie charts work really well individually but for a full division it gets quite cluttered, have you considered trying alternatives? Something like this for example (though that would make it harder to see exactly where a player fits)
Phil Braithwaite tweet media
English
1
0
1
97