Please log in or register. Registered visitors get fewer ads.
Forum index | Previous Thread | Next thread
robith's 21/22 Promotion/Relegation Index Thread 16:29 - Nov 4 with 26032 viewsrobith

Hello Fellow Rs,

Some of you may remember from years gone by I have run a thread where we track our chances of making promotion, and inevitably how many points we need to avoid relegation.

I had to stop making it just before COVID, as I had my laptop stolen which had the valuable excel sheet stuck on it.

Well, what I can tell you is OneDrive is a magical thing. It has been in the cloud all this time!

I have fixed it up and updated it for the season to date, so prepare to join me on the journey!

Historical Precedent

The average points needed to make the playoffs over the last 7 years is 75
The average points needed to avoid relegation over the last 7 years is 46

Handily the median for both is also 75 and 46, meaning there isn't one season warping our numbers

Plays offs there fore = 1.57 points per game
Survival = 0.97 points per game

Our current trajectory is 1.562 PPG, with a forecast points total of 72

If we convert this to an index, where 1 is hitting the target needed

Play Off Index 0.99
Survival Index 1.61

We are in an around the PPG total we need, but our current points trajectory only gets us to the play offs once in the last 7 years.

Now obviously we need a real world comparison too. Usually around the half way point of the season when the table is a bit more fixed, I'll start to compare each week vs the team in 6th and 21st and their trajectory.



Bossing last season, though obviously we had a pretty rough 1st half of the season



This shows our forecast points based on PPG by week and where it would've got us last season. As you can see historically we'd need to get just a little better to get over 75 to be in with a shot



TL;DR - we're in the mix for sure, but at the 5/6th marker rather than guaranteed play offs.

I'll update weekly(ish)
[Post edited 8 Nov 2021 10:32]
21
robith's 21/22 Promotion/Relegation Index Thread on 14:21 - Apr 11 with 2111 viewsTheChef

robith's 21/22 Promotion/Relegation Index Thread on 14:18 - Apr 11 by robith

I've been keeping it up to date but haven't wanted to depress anyone further

I added a polynomial trend line and...



We're safe!!!

Poll: How old is everyone on here?

0
robith's 21/22 Promotion/Relegation Index Thread on 09:34 - Apr 19 with 1812 viewsrobith

Didn't think I'd need to meaningfully update this thread again this season

Looks like meat's back on the menu boys.

It looks like this might be a real outlier for a low total to make the play offs.



3-5 look wrapped up, but there's a real bun fight on for 6th, which currently is tracking as low as 70 points to hit. We're currently tracking on a PPG measure at 67.

So win the final 3, and we're in with a real shot of nipping in. The Sheff Utd game could be absolutely huge
0
robith's 21/22 Promotion/Relegation Index Thread on 19:56 - Apr 19 with 1616 viewsOldPedro

robith's 21/22 Promotion/Relegation Index Thread on 09:34 - Apr 19 by robith

Didn't think I'd need to meaningfully update this thread again this season

Looks like meat's back on the menu boys.

It looks like this might be a real outlier for a low total to make the play offs.



3-5 look wrapped up, but there's a real bun fight on for 6th, which currently is tracking as low as 70 points to hit. We're currently tracking on a PPG measure at 67.

So win the final 3, and we're in with a real shot of nipping in. The Sheff Utd game could be absolutely huge


Sheff Utd game could be huge - which cr@p ref will the EFL appoint? My guess is Keith Stroud

Extra mature cheddar......a simple cheese for a simple man

0
robith's 21/22 Promotion/Relegation Index Thread on 00:15 - Apr 20 with 1456 viewsHooparoo

Here comes Mr Hope to kill us all again 🤷🏼‍♂️

Poll: Where will we finish up next season?

2
robith's 21/22 Promotion/Relegation Index Thread on 09:40 - Apr 20 with 1323 viewsrobith

robith's 21/22 Promotion/Relegation Index Thread on 00:15 - Apr 20 by Hooparoo

Here comes Mr Hope to kill us all again 🤷🏼‍♂️


feeble draw with Stoke inbound.

Though this is the longest in the season this thread has been required since we guaranteed surivival vs Forest a few years ago
1
robith's 21/22 Promotion/Relegation Index Thread on 09:45 - May 9 with 1104 viewsrobith

Forgive me, I'm a completionist

Vs the historical trends


Our Points per game and where we'd have finished last season


Week on week vs last season


How we flexed in real time


I loved this chart but take on board it makes it look like you're in the play offs so might switch to lines next season

Overall, thanks to everyone who contributed to the journey, gutted it didn't turn out like it looks like it could've. Thanks for all the comments, it's been fun (until it wasn't)
3
About Us Contact Us Terms & Conditions Privacy Cookies Advertising
© FansNetwork 2024