End Of Season Predictions

This Forum is the main messageboard to discuss all things Claret and Blue and beyond
Post Reply
Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 8:51 pm

Hello All

I have created a predictor spreadsheet. It is basically based of PPG. The simple formula is (Points/Games) *46 The league table is as follows

C Sheffield United 100
P Norwich 96
3 Reading 88
4 Burnley 75
5 Blackburn[/b] 75
6 QPR 75
7 Wigan Athletic 74
8 Watford 71
9 Sunderland 67
10 Luton 67
11 Rotherham 64
12 Swansea 63
13 Bristol City 59
14 Preston 54
15 Millwall 54
16 Birmingham City 54
17 Cardiff 50
18 Stoke City 50
19 Hull City 46
20 Blackpool 46
21 West Brom 42
22 Middlesbrough 42
23 Coventry City 35
24 Huddersfield 32

UTC

Woodleyclaret
Posts: 6887
Joined: Fri Jan 22, 2016 4:25 pm
Been Liked: 1468 times
Has Liked: 1839 times

Re: End Of Season Predictions

Post by Woodleyclaret » Sun Oct 02, 2022 9:01 pm

I expect us to finish top.Huddersfield, Boro and Rotherham to go down

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 9:10 pm

This is just based off PPG at this point.

Bosscat
Posts: 25361
Joined: Mon Oct 01, 2018 9:51 am
Been Liked: 8426 times
Has Liked: 18095 times

Re: End Of Season Predictions

Post by Bosscat » Sun Oct 02, 2022 9:14 pm

Hurstwood_Claret wrote:
Sun Oct 02, 2022 9:10 pm
This is just based off PPG at this point.
Have a look at previous seasons and see how reliable your PPG idea is then get back to us 😉

jen1066
Posts: 782
Joined: Sun Aug 07, 2022 9:43 am
Been Liked: 176 times
Has Liked: 1238 times

Re: End Of Season Predictions

Post by jen1066 » Sun Oct 02, 2022 9:15 pm

Woodleyclaret wrote:
Sun Oct 02, 2022 9:01 pm
I expect us to finish top.Huddersfield, Boro and Rotherham to go down
That level of positivity will not be accepted on this forum.
This user liked this post: Woodleyclaret

BurnleyFC
Posts: 5058
Joined: Thu Jan 21, 2016 11:51 am
Been Liked: 1596 times
Has Liked: 888 times

Re: End Of Season Predictions

Post by BurnleyFC » Sun Oct 02, 2022 9:20 pm

We’ll finish third, behind Sheffield United and Norwich.

I wouldn’t expect Reading or Blackburn to make the play offs, either.

Nonayforever
Posts: 3271
Joined: Fri Jan 22, 2016 8:15 pm
Been Liked: 690 times
Has Liked: 172 times

Re: End Of Season Predictions

Post by Nonayforever » Sun Oct 02, 2022 9:22 pm

BurnleyFC wrote:
Sun Oct 02, 2022 9:20 pm
We’ll finish third, behind Sheffield United and Norwich.

I wouldn’t expect Reading or Blackburn to make the play offs, either.
Imagine a Burnley v Blackburn play off final 😳

EarbyClaret
Posts: 1376
Joined: Thu Jan 21, 2016 9:48 am
Been Liked: 498 times

Re: End Of Season Predictions

Post by EarbyClaret » Sun Oct 02, 2022 9:25 pm

Blackpool and Hull both got off to decent starts. Their recent results are probably a better reflection of their level. Both are in trouble

Whilst Boro and West Brom might not be in the promotion mix as expected pre-season no way either will be in a relegation scrap

Teams managed by Paul Ince tend to fade after a good start. Impressive from Reading so far but will be a surprise if they can sustain it

Feels about right as far as we are concerned

Longsider
Posts: 2270
Joined: Fri Jan 22, 2016 6:03 pm
Been Liked: 761 times
Has Liked: 722 times

Re: End Of Season Predictions

Post by Longsider » Sun Oct 02, 2022 9:47 pm

I am going to stick my neck on the line but I don't think we will get relegated
These 2 users liked this post: Bosscat boatshed bill

Billyblah
Posts: 596
Joined: Sat Jan 23, 2016 2:33 pm
Been Liked: 165 times
Has Liked: 29 times

Re: End Of Season Predictions

Post by Billyblah » Sun Oct 02, 2022 9:52 pm

Nonayforever wrote:
Sun Oct 02, 2022 9:22 pm
Imagine a Burnley v Blackburn play off final 😳
Well on current from we wouldn't win it. We crack under any sort of pressure.

dougcollins
Posts: 6586
Joined: Sat Jan 23, 2016 12:23 am
Been Liked: 1778 times
Has Liked: 1773 times
Location: Yarkshire

Re: End Of Season Predictions

Post by dougcollins » Sun Oct 02, 2022 9:59 pm

Billyblah wrote:
Sun Oct 02, 2022 9:52 pm
Well on current from we wouldn't win it. We crack under any sort of pressure.
We go a goal up, looking unbeatable, and lose 2-1.

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 10:12 pm

Bosscat wrote:
Sun Oct 02, 2022 9:14 pm
Have a look at previous seasons and see how reliable your PPG idea is then get back to us 😉
Will do. Currently working on 19/20 & 20/21 seasons to prove my theories
This user liked this post: Bosscat

Devils_Advocate
Posts: 12345
Joined: Sun Oct 30, 2016 2:43 pm
Been Liked: 5202 times
Has Liked: 920 times

Re: End Of Season Predictions

Post by Devils_Advocate » Sun Oct 02, 2022 10:25 pm

Fascinating stats provided by the OP who I suspect is a specialist in this area. I've emailed my bookie to see what odds I can get for getting all 24 teams in the right order so I'll see what they say.

I decided not to go for the exact number of points because even though I have 100% confidence in Hurstwoods calculations and methodology being spot on it doesn't take much for it to go wrong and lose the bet.

If anyone else is interested let me know and I'll pass you the bookies details and the odds they are offering me

Joe14
Posts: 1181
Joined: Thu Jan 21, 2016 11:43 pm
Been Liked: 249 times
Has Liked: 49 times
Location: Burnley

Re: End Of Season Predictions

Post by Joe14 » Sun Oct 02, 2022 10:25 pm

Rovers mid table at best

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 10:54 pm

Devils_Advocate wrote:
Sun Oct 02, 2022 10:25 pm
Fascinating stats provided by the OP who I suspect is a specialist in this area. I've emailed my bookie to see what odds I can get for getting all 24 teams in the right order so I'll see what they say.

I decided not to go for the exact number of points because even though I have 100% confidence in Hurstwoods calculations and methodology being spot on it doesn't take much for it to go wrong and lose the bet.

If anyone else is interested let me know and I'll pass you the bookies details and the odds they are offering me
Thanks.

Although it may seem true, I’m not really a mathematician. Believe it or not, I’m just a self taught excel expert.
The only real ‘Maths’ that I have done it testing my formula on paper, then testing the excel functions to make sure they work.
Last edited by Hurstwood_Claret on Sun Oct 02, 2022 10:56 pm, edited 1 time in total.

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 10:56 pm

Bosscat wrote:
Sun Oct 02, 2022 9:14 pm
Have a look at previous seasons and see how reliable your PPG idea is then get back to us 😉

You need to imagine this like a funnel. For instance, MW1 is the widest part. At this stage, you have some teams going up on 138 pts, some mid table with 46, some going down with 0 points. As the season goes on, the predictions should be more accurate.

Bosscat
Posts: 25361
Joined: Mon Oct 01, 2018 9:51 am
Been Liked: 8426 times
Has Liked: 18095 times

Re: End Of Season Predictions

Post by Bosscat » Sun Oct 02, 2022 11:19 pm

Hurstwood_Claret wrote:
Sun Oct 02, 2022 10:56 pm
You need to imagine this like a funnel. For instance, MW1 is the widest part. At this stage, you have some teams going up on 138 pts, some mid table with 46, some going down with 0 points. As the season goes on, the predictions should be more accurate.
🤣🤣🤣 so its not the most acurate of predictors at this stage of the season then 😉

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 11:22 pm

Not really. It’s more accurate week by week

boatshed bill
Posts: 15107
Joined: Thu Jan 21, 2016 10:47 am
Been Liked: 3137 times
Has Liked: 6682 times

Re: End Of Season Predictions

Post by boatshed bill » Sun Oct 02, 2022 11:25 pm

Hurstwood_Claret wrote:
Sun Oct 02, 2022 11:22 pm
Not really. It’s more accurate week by week
I bet it's almost perfect by week 44 ;)

Devils_Advocate
Posts: 12345
Joined: Sun Oct 30, 2016 2:43 pm
Been Liked: 5202 times
Has Liked: 920 times

Re: End Of Season Predictions

Post by Devils_Advocate » Sun Oct 02, 2022 11:29 pm

Hurstwood_Claret wrote:
Sun Oct 02, 2022 11:22 pm
Not really. It’s more accurate week by week
Do you know big Dave who works in the William Hill bookies down Vicar Lane in Leeds?

Rileybobs
Posts: 16684
Joined: Fri Jan 22, 2016 4:37 pm
Been Liked: 6893 times
Has Liked: 1471 times
Location: Leeds

Re: End Of Season Predictions

Post by Rileybobs » Sun Oct 02, 2022 11:39 pm

I’ve just compared this to the current league table and it’s remarkable how similar the end of season standings will be if each team continues on the same form.

taio
Posts: 11520
Joined: Thu Jan 21, 2016 9:17 am
Been Liked: 3220 times
Has Liked: 340 times

Re: End Of Season Predictions

Post by taio » Sun Oct 02, 2022 11:40 pm

Struggle to get my head around sophisticated modelling so will have to just rely on the current league table which coincidentally happens to be very similar in terms of the ordering of the teams.
This user liked this post: Duffer_

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Sun Oct 02, 2022 11:44 pm

Devils_Advocate wrote:
Sun Oct 02, 2022 11:29 pm
Do you know big Dave who works in the William Hill bookies down Vicar Lane in Leeds?

No
These 2 users liked this post: Duffer_ RVclaret

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Mon Oct 03, 2022 7:49 am

boatshed bill wrote:
Sun Oct 02, 2022 11:25 pm
I bet it's almost perfect by week 44 ;)
It will be most accurate by 2:59 on the 6th May.

Zlatan
Posts: 5458
Joined: Wed Jun 08, 2016 2:06 pm
Been Liked: 2229 times
Has Liked: 5739 times

Re: End Of Season Predictions

Post by Zlatan » Mon Oct 03, 2022 8:08 am

I'm not sure who is trolling who on this thread. For info, to clarify. Take a look at the current league table. That is all.

mdd2
Posts: 6012
Joined: Thu Jan 14, 2016 8:47 pm
Been Liked: 1665 times
Has Liked: 700 times

Re: End Of Season Predictions

Post by mdd2 » Mon Oct 03, 2022 8:58 am

Lose 1-0 to Sheffield United at Wembley denied at least one clear penalty and have a player sent off- Karma

SalisburyClaret
Posts: 4077
Joined: Fri Jan 22, 2016 1:32 pm
Been Liked: 1104 times
Has Liked: 709 times

Re: End Of Season Predictions

Post by SalisburyClaret » Mon Oct 03, 2022 9:09 am

Well it was worth a try Hurstwood

Devils_Advocate
Posts: 12345
Joined: Sun Oct 30, 2016 2:43 pm
Been Liked: 5202 times
Has Liked: 920 times

Re: End Of Season Predictions

Post by Devils_Advocate » Mon Oct 03, 2022 9:19 am

Hurstwood_Claret wrote:
Sun Oct 02, 2022 11:44 pm
No
Ok thats strange cos I messaged him last night to get him to look in to what odds Id get for predicting the order of all 24 teams and (knowing Im a Burnley fan) he asked me if Im mates with that stats genius who does this every season. I told him I wasnt but got the tip from a random on a Burnley forum but he was having none of it and said no way are we giving you odd if the workings come from the Burnley Nemesis (thinks thats the nickname all the bookies have given you).

Anyway to cut a long story short it sounds like you are a bit more of an expert than I first thought and that you are blacklisted by a lot of the bookies. Anyone else thinking of placing a bet on the back of these predictions keep where you got the advice to yourself if I was you.

conyoviejo
Posts: 5829
Joined: Thu Jan 21, 2016 12:38 pm
Been Liked: 2491 times
Has Liked: 1477 times
Location: On the high seas chasing Pirates

Re: End Of Season Predictions

Post by conyoviejo » Mon Oct 03, 2022 9:23 am

mdd2 wrote:
Mon Oct 03, 2022 8:58 am
Lose 1-0 to Sheffield United at Wembley denied at least one clear penalty and have a player sent off- Karma
Aye,good old Mike Dean.😁

Hurstwood_Claret
Posts: 400
Joined: Mon Jul 25, 2022 6:49 pm
Been Liked: 53 times
Has Liked: 2 times

Re: End Of Season Predictions

Post by Hurstwood_Claret » Mon Oct 03, 2022 4:08 pm

Devils_Advocate wrote:
Mon Oct 03, 2022 9:19 am
Ok thats strange cos I messaged him last night to get him to look in to what odds Id get for predicting the order of all 24 teams and (knowing Im a Burnley fan) he asked me if Im mates with that stats genius who does this every season. I told him I wasnt but got the tip from a random on a Burnley forum but he was having none of it and said no way are we giving you odd if the workings come from the Burnley Nemesis (thinks thats the nickname all the bookies have given you).

Anyway to cut a long story short it sounds like you are a bit more of an expert than I first thought and that you are blacklisted by a lot of the bookies. Anyone else thinking of placing a bet on the back of these predictions keep where you got the advice to yourself if I was you.
This is the first iteration of my predictor. I’m not old enough to place bets, so I’m okay with being blacklisted

Zlatan
Posts: 5458
Joined: Wed Jun 08, 2016 2:06 pm
Been Liked: 2229 times
Has Liked: 5739 times

Re: End Of Season Predictions

Post by Zlatan » Tue Oct 04, 2022 9:25 am

Hurstwood_Claret wrote:
Mon Oct 03, 2022 4:08 pm
This is the first iteration of my predictor. I’m not old enough to place bets, so I’m okay with being blacklisted
from the sounds of it you appear to be using newly learnt tools on Excel to extrapolate data, which is fine, however just using points per game is very simplistic and will reflect the current league table (what it can't do is allow for variances in number of games played for each team which is why it isn't totally correct).

What you could look to do next in your spreadsheet is look at the variances in team form perhaps and a good place to learn what you could possibly achieve would be the magic numbers link from previous seasons - which is and has been a fantastic tool for some of us to monitor the form of the team.

Good luck, and enjoy learning with Excel

Post Reply