Magic Numbers 2017/2018
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Magic Numbers 2017/2018
I know it's early but some teams Magic numbers have been affected by 19 points and that's after just four matches. I was just wondering if aggi or one of the other techy people on here could do one of those spreadsheet thingies.
UTC
UTC
These 2 users liked this post: Goddy dougcollins
-
- Posts: 5163
- Joined: Wed Feb 17, 2016 1:18 pm
- Been Liked: 2105 times
- Has Liked: 416 times
- Location: Burnley
Re: Magic Numbers 2017/2018
I've been waiting for this too .... Come on guys - work your magic......numbers.
This user liked this post: Goddy
-
- Posts: 678
- Joined: Thu Jan 21, 2016 11:31 am
- Been Liked: 192 times
- Has Liked: 694 times
- Location: Nottingham
Re: Magic Numbers 2017/2018
So. everyone's magic number at the start of the season is 114 (i.e. 38 games x 3 points per game and no-one with any points on the board).
Interesting that, even at this very early stage of the season, the magic numbers for B'mouth and Palace have dropped to 95....that's a massive (almost) 5 points per game. Even those currently with 3 points - Leicester and now WHU - have seen their magic number decrease to 98 i.e. 4 points per game. (I'm assuming we'll have better goal difference than these teams...otherwise, add an extra point onto their magic numbers)
On average, from memory, last season, the magic numbers were dropping at a little over 3 points per game. At the current rate (if only it could be sustained...maybe it can??), we'd be safe after around game 29!!!!!! I think all that puts it into perspective just what an outstanding start to the season this has been.
UTC
Interesting that, even at this very early stage of the season, the magic numbers for B'mouth and Palace have dropped to 95....that's a massive (almost) 5 points per game. Even those currently with 3 points - Leicester and now WHU - have seen their magic number decrease to 98 i.e. 4 points per game. (I'm assuming we'll have better goal difference than these teams...otherwise, add an extra point onto their magic numbers)
On average, from memory, last season, the magic numbers were dropping at a little over 3 points per game. At the current rate (if only it could be sustained...maybe it can??), we'd be safe after around game 29!!!!!! I think all that puts it into perspective just what an outstanding start to the season this has been.
UTC
This user liked this post: bfccrazy
-
- Posts: 21464
- Joined: Thu Jan 21, 2016 9:59 pm
- Been Liked: 8585 times
- Has Liked: 11285 times
Re: Magic Numbers 2017/2018
Can someone explain this in laymans terms?
I know it means points left available to win. But I dont know how you work this formula out, especially given the fixtures against each other etc which is probably relevant?
I am usually good with maths but its monday!
I know it means points left available to win. But I dont know how you work this formula out, especially given the fixtures against each other etc which is probably relevant?
I am usually good with maths but its monday!
-
- Posts: 5163
- Joined: Wed Feb 17, 2016 1:18 pm
- Been Liked: 2105 times
- Has Liked: 416 times
- Location: Burnley
Re: Magic Numbers 2017/2018
At the start of the season - every team could potentially finish 114 points above us .... As the season progresses each team loses points.cricketfieldclarets wrote:Can someone explain this in laymans terms?
I know it means points left available to win. But I dont know how you work this formula out, especially given the fixtures against each other etc which is probably relevant?
I am usually good with maths but its monday!
Every team plays each other so each week 1 team HAS to lose points - the "Magic Number" is how many points above us each team can finish at that point of the season if we lose every game and they win every remaining game.
Try and follow the magic number til it hits 0 for teams which means they can no longer finish above us ....
So tonight West Ham gained 3 points but Hudds magic number would have fallen by 3 as that got beat and no longer have the WHU match to add any points.
If it was a draw then they would have both dropped 2 points ...if we beat a team though then they lose 6 points as we have gained 3 by beating them and they have a match less to pick up those 3 points and vice versa.
These 2 users liked this post: cricketfieldclarets Foshiznik
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
Re: Magic Numbers 2017/2018
https://docs.google.com/spreadsheets/d/ ... =267725110
As of posting, this does not include West Ham v Huddersfield..
As of posting, this does not include West Ham v Huddersfield..
This user liked this post: bfccrazy
Re: Magic Numbers 2017/2018
Way ahead of you Vince, I'm surprised you waited this longVince Fontaine wrote:I know it's early but some teams Magic numbers have been affected by 19 points and that's after just four matches. I was just wondering if aggi or one of the other techy people on here could do one of those spreadsheet thingies.
UTC
http://www.uptheclarets.com/messageboar ... 49#p486149" onclick="window.open(this.href);return false;
https://docs.google.com/spreadsheets/d/ ... sp=sharing" onclick="window.open(this.href);return false;
Same deal as last year, it should update automatically. I may copy the spreadsheet every 5 weeks (if I remember or someone reminds me). There are various snapshots from last season on there.
These 2 users liked this post: Goddy evensteadiereddie
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Here's how the bottom 5 stand
Stoke -22...............93
Liecester. -23..........92
West Ham -23.........92
Bournemouth -24......91
Crystal palace -27.....88
This is while the Brighton match is in play (they lead 1-0) as I write this.
With one team under 90 I think we are doing ok
UTC
Stoke -22...............93
Liecester. -23..........92
West Ham -23.........92
Bournemouth -24......91
Crystal palace -27.....88
This is while the Brighton match is in play (they lead 1-0) as I write this.
With one team under 90 I think we are doing ok
UTC
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Thanks aggi
I love magic numbers.
Hopefully next weekend will see at least 2 more clubs drop below 90
UTC
I love magic numbers.
Hopefully next weekend will see at least 2 more clubs drop below 90
UTC
-
- Posts: 3748
- Joined: Mon Mar 20, 2017 9:49 am
- Been Liked: 927 times
- Has Liked: 716 times
Re: Magic Numbers 2017/2018
It doesn't take account of matches between teams.cricketfieldclarets wrote:Can someone explain this in laymans terms?
I know it means points left available to win. But I dont know how you work this formula out, especially given the fixtures against each other etc which is probably relevant?
I am usually good with maths but its monday!
-
- Posts: 678
- Joined: Thu Jan 21, 2016 11:31 am
- Been Liked: 192 times
- Has Liked: 694 times
- Location: Nottingham
Re: Magic Numbers 2017/2018
The magic numbers continue to drop at about 4 points per game. Still on for safety after game 29 (which is Everton at home, for those that are interested).............
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
-
- Posts: 216
- Joined: Mon May 15, 2017 11:16 am
- Been Liked: 126 times
- Has Liked: 328 times
Re: Magic Numbers 2017/2018
Err...I thought I was starting to understand it a little bit until I read this.Clarets4me wrote:After week 6, all sides played the same...
https://docs.google.com/spreadsheets/d/ ... =267725110
Re: Magic Numbers 2017/2018
Chip, this is how I see it
Points available = total number of points a team can get from the remaining games left (not including current points)
Max available = total number of points a team can get from the remaining games left
Magic number = The points Burnley would need to get to guarantee finishing above that team
Extrapolated points = Number of projected points based on season form as an average
Extrapolated points (last 6) = Number of projected points based on the last 6 games form as an average
Position is only relevant when teams have games in hand, but this is the projected final position.
Points available = total number of points a team can get from the remaining games left (not including current points)
Max available = total number of points a team can get from the remaining games left
Magic number = The points Burnley would need to get to guarantee finishing above that team
Extrapolated points = Number of projected points based on season form as an average
Extrapolated points (last 6) = Number of projected points based on the last 6 games form as an average
Position is only relevant when teams have games in hand, but this is the projected final position.
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
Re: Magic Numbers 2017/2018
click on the post 13 link, for an update, all having played 7 games.....
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Bottom 6
Sorry 7
All under 90
After 7 matches
Brighton -6............89
West Ham -3...........89
Everton-6...............89
Leicester -5............87
Swansea-6..............87
Bournemouth -5.......86
Crystal palace -6......82
UTC
Sorry 7
All under 90
After 7 matches
Brighton -6............89
West Ham -3...........89
Everton-6...............89
Leicester -5............87
Swansea-6..............87
Bournemouth -5.......86
Crystal palace -6......82
UTC
Last edited by Vince Fontaine on Fri Dec 15, 2017 11:37 pm, edited 1 time in total.
-
- Posts: 1351
- Joined: Wed Jan 20, 2016 5:50 pm
- Been Liked: 392 times
- Has Liked: 514 times
Re: Magic Numbers 2017/2018
That's a tough extrapolated season for Palace
Re: Magic Numbers 2017/2018
So Palace won't be able to catch us in 14 matches!
-
- Posts: 678
- Joined: Thu Jan 21, 2016 11:31 am
- Been Liked: 192 times
- Has Liked: 694 times
- Location: Nottingham
Re: Magic Numbers 2017/2018
Magic numbers dropping by 4 points (or more) for the bottom 4 teams. At this rate, safety should be somewhere around game 28 or 29.
This user liked this post: evensteadiereddie
-
- Posts: 5548
- Joined: Mon Jan 25, 2016 10:40 pm
- Been Liked: 1448 times
- Has Liked: 1229 times
- Location: Ferkham Hall
Re: Magic Numbers 2017/2018
https://docs.google.com/spreadsheets/d/ ... sp=sharing" onclick="window.open(this.href);return false;
I've copied this in because some of the links higher up took me to last season.
I've just learned if I lightly click the link it goes to last season.
If I hold it down and click on "open in new tab" it is the live table.
I've copied this in because some of the links higher up took me to last season.
I've just learned if I lightly click the link it goes to last season.
If I hold it down and click on "open in new tab" it is the live table.
Re: Magic Numbers 2017/2018
Weird, I'm not sure how that is happening.
There isn't a last season spreadsheet, this is the same one that's just carried on updating.
There isn't a last season spreadsheet, this is the same one that's just carried on updating.
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Vince Fontaine wrote:Bottom 6
Sorry 7
All under 90
Brighton -6............89
West Ham -3...........89
Everton-6...............89
Leicester -5............87
Swansea-6..............87
Bournemouth -5.......86
Crystal palace -6......82
UTC
Just been looking at the next 3 fixtures, which will take us to 10 games.
Palace
Chelsea home
Newcastle away
West Ham home
Bournemouth
Tottenham away
Stoke away
Chelsea home
Swansea
Huddersfield home
Leicester home
Arsenal away
Leicester
West brom home
Swansea away
Everton home
Everton
Brighton away
Arsenal home
Leicester away
West Ham
Burnley away
Brighton home
Palace away
Brighton
Everton home
West Ham away
Southampton home
Wth one or two of these bottom sides playing one another we can look forward to a couple of them being under 80 after 10 matches.
Utc
-
- Posts: 5548
- Joined: Mon Jan 25, 2016 10:40 pm
- Been Liked: 1448 times
- Has Liked: 1229 times
- Location: Ferkham Hall
Re: Magic Numbers 2017/2018
I was on my tab and it was, probably, taking me to a saved copy from the last time I opened it. Which on the tab was last season. Whereas the new window opened the updated numbers.aggi wrote:Weird, I'm not sure how that is happening.
There isn't a last season spreadsheet, this is the same one that's just carried on updating.
EDIT. Just found that the "week 6". tab is current, all the others are last season.
Last edited by piston broke on Thu Oct 05, 2017 11:25 pm, edited 1 time in total.
-
- Posts: 5548
- Joined: Mon Jan 25, 2016 10:40 pm
- Been Liked: 1448 times
- Has Liked: 1229 times
- Location: Ferkham Hall
Re: Magic Numbers 2017/2018
With three wins for Seans mighty Clarets they'll all be under 80.Vince Fontaine wrote: Wth one or two of these bottom sides playing one another we can look forward to a couple of them being under 80 after 10 matches.
Utc
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
Re: Magic Numbers 2017/2018
This user liked this post: evensteadiereddie
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Here is a comparison of last season after 10 matches and this season after 8 matches.
2016/17 (after 10 matches)
Burnley 11 points
Middlesboro points 10 Magic number 83
West brom ..points 10 Magic number 83
West Ham ...points 10 Magic number 83
Hull ............points 7 Magic number 80
Swansea...... points 5 Magic number 78
Sunderland.....points 2 Magic number 75
2017/18 (after 8 matches)
Burnley 13 points
Swansea........points 8 Magic number 86
Brighton........points 8 Magic number 86
West Ham......points 8 Magic number 86
Everton.........points 8 Magic number 86
Stoke............points 8 Magic number 86
Leicester........points 6 Magic number 84
Bournemouth ..points 4 Magic number 82
Palace...........points 3 Magic number 81
UTC
2016/17 (after 10 matches)
Burnley 11 points
Middlesboro points 10 Magic number 83
West brom ..points 10 Magic number 83
West Ham ...points 10 Magic number 83
Hull ............points 7 Magic number 80
Swansea...... points 5 Magic number 78
Sunderland.....points 2 Magic number 75
2017/18 (after 8 matches)
Burnley 13 points
Swansea........points 8 Magic number 86
Brighton........points 8 Magic number 86
West Ham......points 8 Magic number 86
Everton.........points 8 Magic number 86
Stoke............points 8 Magic number 86
Leicester........points 6 Magic number 84
Bournemouth ..points 4 Magic number 82
Palace...........points 3 Magic number 81
UTC
-
- Posts: 3748
- Joined: Mon Mar 20, 2017 9:49 am
- Been Liked: 927 times
- Has Liked: 716 times
Re: Magic Numbers 2017/2018
That's numberwang.
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Is numberwang good?
UTC
UTC
-
- Posts: 17108
- Joined: Wed Mar 29, 2017 8:12 pm
- Been Liked: 4384 times
- Has Liked: 15117 times
Re: Magic Numbers 2017/2018
I thought bingo was mind numbing.
-
- Posts: 3748
- Joined: Mon Mar 20, 2017 9:49 am
- Been Liked: 927 times
- Has Liked: 716 times
Re: Magic Numbers 2017/2018
That's wordwang!Vince Fontaine wrote:Is numberwang good?
UTC
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
-
- Posts: 25445
- Joined: Sat Mar 26, 2016 12:46 am
- Been Liked: 6930 times
- Has Liked: 11660 times
- Location: Leeds
Re: Magic Numbers 2017/2018
Let's aim for 86 points. We'll be ok then.Vince Fontaine wrote:Here is a comparison of last season after 10 matches and this season after 8 matches.
2016/17 (after 10 matches)
Burnley 11 points
Middlesboro points 10 Magic number 83
West brom ..points 10 Magic number 83
West Ham ...points 10 Magic number 83
Hull ............points 7 Magic number 80
Swansea...... points 5 Magic number 78
Sunderland.....points 2 Magic number 75
2017/18 (after 8 matches)
Burnley 13 points
Swansea........points 8 Magic number 86
Brighton........points 8 Magic number 86
West Ham......points 8 Magic number 86
Everton.........points 8 Magic number 86
Stoke............points 8 Magic number 86
Leicester........points 6 Magic number 84
Bournemouth ..points 4 Magic number 82
Palace...........points 3 Magic number 81
UTC
Re: Magic Numbers 2017/2018
Why can I only see week 6?
-
- Posts: 4153
- Joined: Fri Jan 22, 2016 10:39 pm
- Been Liked: 698 times
- Has Liked: 608 times
- Location: Wexford, Ireland. via Nelson.
Re: Magic Numbers 2017/2018
Don't like that puts Geordies 5th at end of season, not good for next game!
Re: Magic Numbers 2017/2018
Are you looking at the wrong tab. There is a snapshot at week 6 but the leftmost tab should be the current position.Jel wrote:Why can I only see week 6?
-
- Posts: 678
- Joined: Thu Jan 21, 2016 11:31 am
- Been Liked: 192 times
- Has Liked: 694 times
- Location: Nottingham
Re: Magic Numbers 2017/2018
Unless Everton come storming back with 20 mins to go (as I write), the magic numbers are looking like this....before we play Newcastle!!! If we get any points from the Newcastle game knock those off the magic numbers, below, for the up to date picture after Round 10 matches have been completed.
Swansea 80
Everton 80
B'mouth 79
Palace 76
Swansea 80
Everton 80
B'mouth 79
Palace 76
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
Re: Magic Numbers 2017/2018
After all teams have played 10 games.....
https://docs.google.com/spreadsheets/d/ ... =267725110
Happy days !!
https://docs.google.com/spreadsheets/d/ ... =267725110
Happy days !!
-
- Posts: 4153
- Joined: Fri Jan 22, 2016 10:39 pm
- Been Liked: 698 times
- Has Liked: 608 times
- Location: Wexford, Ireland. via Nelson.
Re: Magic Numbers 2017/2018
Good result for us tonight, Geordies can go and extrapolateCnBtruntru wrote:Don't like that puts Geordies 5th at end of season, not good for next game!
Re: Magic Numbers 2017/2018
I've snapshotted it at Week 10. For those who want to compare:
2016-17 2017-18
2016-17 2017-18
-
- Posts: 5548
- Joined: Mon Jan 25, 2016 10:40 pm
- Been Liked: 1448 times
- Has Liked: 1229 times
- Location: Ferkham Hall
Re: Magic Numbers 2017/2018
Far too early for this I know but the 7th place this year means there are more clubs below us playing each other every week. 6 wins & 6 draws, from 28 matches, gives us 40 points, that'll do for me
-
- Posts: 519
- Joined: Wed Feb 03, 2016 9:41 pm
- Been Liked: 177 times
- Has Liked: 41 times
- Location: Colne
Re: Magic Numbers 2017/2018
Next 5 matches
West Ham (78)
Liverpool home
Watford away
Leicester home
Everton away
Man city away
Swansea (77)
Brighton home
Burnley away
Bournemouth home
Chelsea away
Stoke away
Everton (77)
Watford home
Palace away
Southampton away
West ham home
Huddersfield home
Bournemouth (76)
Newcastle away
Huddersfield home
Swansea away
Burnley home
Southampton home
Palace (73)
Spurs away
Everton home
Stoke home
Brighton away
West Bromwich away
Once again a couple of the bottom sides play each other plus we can affect a couple of the sides directly.
Some teams could be under 60 by the time we've played 15 matches.
Happy times
UTC
West Ham (78)
Liverpool home
Watford away
Leicester home
Everton away
Man city away
Swansea (77)
Brighton home
Burnley away
Bournemouth home
Chelsea away
Stoke away
Everton (77)
Watford home
Palace away
Southampton away
West ham home
Huddersfield home
Bournemouth (76)
Newcastle away
Huddersfield home
Swansea away
Burnley home
Southampton home
Palace (73)
Spurs away
Everton home
Stoke home
Brighton away
West Bromwich away
Once again a couple of the bottom sides play each other plus we can affect a couple of the sides directly.
Some teams could be under 60 by the time we've played 15 matches.
Happy times
UTC
-
- Posts: 5548
- Joined: Mon Jan 25, 2016 10:40 pm
- Been Liked: 1448 times
- Has Liked: 1229 times
- Location: Ferkham Hall
Re: Magic Numbers 2017/2018
I've said from the beginning we need to be safe before any player gets a world cup head on.
Amazingly we might well be safe early.
Amazingly we might well be safe early.
-
- Posts: 678
- Joined: Thu Jan 21, 2016 11:31 am
- Been Liked: 192 times
- Has Liked: 694 times
- Location: Nottingham
Re: Magic Numbers 2017/2018
So we are reducing the magic numbers by around 3.7 points per game (against the current third bottom club in the table).
At this rate safety should be around game 30-31.
At this rate safety should be around game 30-31.
-
- Posts: 25445
- Joined: Sat Mar 26, 2016 12:46 am
- Been Liked: 6930 times
- Has Liked: 11660 times
- Location: Leeds
Re: Magic Numbers 2017/2018
Looking at the league table, I bet you'd have got good odds at the start of the season on a Palace, Bournemouth, Everton bottom three after 10 games.
Re: Magic Numbers 2017/2018
Palace on 70 now.
Could be 67 later today.
Could be 67 later today.
-
- Posts: 30736
- Joined: Fri Jan 22, 2016 4:00 am
- Been Liked: 11063 times
- Has Liked: 5668 times
- Location: clue is in the title
Re: Magic Numbers 2017/2018
that's insane !Goddy wrote:So we are reducing the magic numbers by around 3.7 points per game (against the current third bottom club in the table).
At this rate safety should be around game 30-31.
-
- Posts: 4980
- Joined: Thu Jan 28, 2016 9:31 pm
- Been Liked: 2341 times
- Has Liked: 1041 times
- Location: Ightenhill,Burnley
-
- Posts: 9603
- Joined: Thu Jan 21, 2016 9:45 pm
- Been Liked: 3150 times
- Has Liked: 10263 times
- Location: Staffordshire
Re: Magic Numbers 2017/2018
That makes excellent reading.
-
- Posts: 3013
- Joined: Thu Jan 21, 2016 9:20 am
- Been Liked: 1050 times
- Has Liked: 996 times
- Location: The Moon, Outer Space.
Re: Magic Numbers 2017/2018
Like the fact, based on the last six results, we will finish above Manchester Utd.