Magic Numbers 2019-20 ...

Clarets4me · Post by **Clarets4me** » Sat Aug 10, 2019 9:04 pm

Here we go again, very early days .....

https://docs.google.com/spreadsheets/d/ ... =267725110

Just as a point of interest, we are currently 39 League places above Blackburn Rovers ! Trebles all round !!

FactualFrank · Post by **FactualFrank** » Sat Aug 10, 2019 9:05 pm

That's worth another beer.

aggi · Post by **aggi** » Sat Aug 10, 2019 10:29 pm

Seems to be working pretty well given I haven't touched it from last season.

Think I just need to fix the form section but that doesn't come into play yet anyway.

Bosscat · Post by **Bosscat** » Sat Aug 10, 2019 10:47 pm

Clarets4me wrote:Here we go again, very early days .....

https://docs.google.com/spreadsheets/d/ ... =267725110

Just as a point of interest, we are currently 39 League places above Blackburn Rovers ! Trebles all round !!

. .......team .... p W D L GD Pts
22 Reading ... . .2 0 0 2 -3 0
23 Stoke ......... .2 0 0 2 -3 0
24 Blackburn ....2 0 0 2 -3 0
Last updated 10th August 2019 at 17:00

Dont'cha just lurve Football

Clarets4me · Post by **Clarets4me** » Sat Aug 10, 2019 11:39 pm

Bosscat wrote:. .......team .... p W D L GD Pts
22 Reading ... . .2 0 0 2 -3 0
23 Stoke ......... .2 0 0 2 -3 0
24 Blackburn ....2 0 0 2 -3 0
Last updated 10th August 2019 at 17:00

Dont'cha just lurve Football

As I've mentioned elsewhere, their next four fixtures are Boro ( H ), Hull ( A ), Cardiff ( H ) & West Brom ( A ) ... not that we've got it easy, mind !

aggi · Post by **aggi** » Wed Aug 14, 2019 11:14 am

I've cleaned the magic numbers spreadsheet up a bit. All seems fine.

Easy to view link is here:
https://docs.google.com/spreadsheets/d/ ... ingle=true" onclick="window.open(this.href);return false;

Link to the full spreadsheet is here:
https://docs.google.com/spreadsheets/d/ ... sp=sharing" onclick="window.open(this.href);return false;

It also seems the Blackburn one I did a few seasons ago is still going if anyone is interested:
https://docs.google.com/spreadsheets/d/ ... ingle=true" onclick="window.open(this.href);return false;

Clarets4me · Post by **Clarets4me** » Sun Aug 18, 2019 7:21 pm

Clarets4me wrote:Here we go again, very early days .....

https://docs.google.com/spreadsheets/d/ ... =267725110

Just as a point of interest, we are currently 39 League places above Blackburn Rovers ! Trebles all round !!

Oops, we're now only 28 places above them ...

https://docs.google.com/spreadsheets/d/ ... =267725110

Clarets4me · Post by **Clarets4me** » Sun Aug 25, 2019 11:29 pm

https://docs.google.com/spreadsheets/d/ ... ingle=true

After 3 games ...

aggi · Post by **aggi** » Sun Sep 22, 2019 1:12 pm

Bump for vince

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 1:16 pm

Oh bugger hadn’t found it so sorry
UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 1:17 pm

This is last year after 7 matches

W/E 05/10/2018
Match day 7

Man City.............106
Liverpool ...........106
Chelsea .............104
Tottenham .........102
Arsenal .............102
Watford .............100
Bournemouth ......100
Leicester ............99
Wolves ...............99
Man Utd .............97
Everton ..............96
Burnley
Palace ...............94
West Ham ...........94
Brighton .............92
Southampton .......92
Fulham...............92
Newcastle ...........89
Cardiff ...............89
Huddersfield ........89

Would be nice to see at least another 3 teams under 90 after Saturday
UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 1:19 pm

This season after 5/6 matches

W/E. 21/22 September

Liverpool.........115......-8.....107
Man City....................-13....102
Leicester...................-15.....100
Bournemouth..............-16.....99
Tottenham.................-18.....97
Man Utd....................-15.....100
Burnley
Sheffield Utd..............-18.....97
Chelsea.....................-15.....100
Arsenal.....................-15.....100
West Ham..................-15.....100
Southampton..............-19.....96
Crystal Palace.............-16.....99
Everton.....................-19.....96
Brighton....................-20.....95
Norwich....................-20.....95
Newcastle..................-21.....94
Aston Villa.................-19.....96
Wolves......................-20.....95
Watford....................-24......91

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 1:21 pm

Last years thread

http://www.uptheclarets.com/messageboar ... 018%2F2019" onclick="window.open(this.href);return false;

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 2:15 pm

Season 2017/2018 ( The year we qualified for Europe!! ).

http://www.uptheclarets.com/messageboar ... =2&t=20589" onclick="window.open(this.href);return false;

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 4:21 pm

Man Utd.....-3....97
Palace.......-2....97
Wolves......-2.....93

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Sep 22, 2019 7:59 pm

Chelsea........-3...97
Aston Villa.....-3...93

Completes the weekend.
UTC

Vince Fontaine · Post by **Vince Fontaine** » Sat Sep 28, 2019 5:27 pm

Matchday 7
W/E 28/29 September

Villa 2-2 Burnley

Liverpool...........-1.......106
Man City............-1.......101
West Ham..........-3........97
Tottenham.........-1........97
Leicester...........-1........99
Chelsea............-1.........96
Bournemouth.....-3.........96
Arsenal.............-1........99
Crystal Palace.....-1........96
Burnley
Man Utd............-1........96
Sheffield Utd......-4........93
Wolves..............-1........92
Southampton......-4........92
Everton.............-4........92
Brighton............-4........91
Norwich............-4.........91
Aston Villa.........-3........90
Newcastle..........-4........89
Watford.............-4........87

Still some to play but coming down nicely
UTC

box_of_frogs · Post by **box_of_frogs** » Sat Sep 28, 2019 5:32 pm

We'll soon be past Watford!

Vince Fontaine · Post by **Vince Fontaine** » Sat Oct 05, 2019 7:37 pm

Matchday 8
W/E 5/6 October

Burnley 2-0 Everton

Liverpool..........-3.......103
Man City...........-3........98
Leicester..........-6........93
Palace.............-3........93
Burnley
Arsenal............-3........96
West Ham.........-6........91
Tottenham........-6........91
Chelsea............-3.......93
Bournemouth.....-6.......90
Man Utd...........-6.......90
Sheffield Utd.....-5.......88
Brighton...........-3.......88
Aston Villa........-3.......87
Wolves.............-3.......89
Southampton.....-6.......86
Everton............-6.......86
Norwich............-6......85
Newcastle.........-3.......87
Watford............-5.......82

Edited the magic numbers but not the positions
Dropping nicely
UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Oct 06, 2019 12:52 pm

Last years thread

http://www.uptheclarets.com/messageboar ... ey+Numbers" onclick="window.open(this.href);return false;

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Oct 06, 2019 12:54 pm

2017-2018 thread

http://www.uptheclarets.com/messageboar ... =2&t=20589" onclick="window.open(this.href);return false;

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sat Oct 26, 2019 2:44 pm

Match day 9
W/E. 19/20 Oct

Leicester 2-1 Burnley

Liverpool.......-2......101
Man City..................95
Leicester.................93
Chelsea...................93
Arsenal..........-3.......91
Palace...........-3.......90
Tottenham......-2.......88
Burnley
Sheffield Utd.............88
Bournemouth...-2.......88
West Ham.......-3........88
Wolves...........-2........87
Villa........................87
Man Utd.........-2........86
Everton....................86
Brighton.........-3........85
Southampton...-2........84
Newcastle.......-3........84
Norwich.........-2........81
Watford..........-2........80

UTC

Vince Fontaine · Post by **Vince Fontaine** » Fri Nov 01, 2019 10:23 pm

Matchday 10

W/E 25/26 October

Burnley 2-4 Chelsea

Liverpool...................101
Man City.....................95
Leicester....................93
Chelsea......................93
Arsenal............-2........89
Palace.............-2........88
Man Utd.....................86
Sheffield Utd....-2.........86
Bournemouth....-2.........86
West Ham........-2.........86
Tottenham.......-3.........85
Wolves............-2.........85
Burnley
Brighton.....................85
Villa................-3.......84
Everton............-3.......83
Newcastle.........-2.......82
Southampton......-3......81
Norwich............-3......80
Watford............-2......78

UTC

Vince Fontaine · Post by **Vince Fontaine** » Fri Nov 08, 2019 11:43 am

Matchday 11

W/E 2/3 November

Sheffield Utd 3-0 Burnley

Liverpool.......................101
Man City.........................95
Leicester........................93
Chelsea..........................93
Arsenal..................-2......87
Sheffield Utd...................86
Bournemouth...................86
Brighton.........................85
Palace....................-3.....85
Man Utd..................-3.....83
Tottenham...............-2.....83
Wolves....................-2.....83
West Ham................-3.....83
Burnley
Newcastle.......................82
Villa.......................-3.....81
Everton...................-2.....81
Southampton.............-3....78
Norwich...................-3....77
Watford...................-3....75

Norwich v Watford tonight.
Draw please

UTC

Vince Fontaine · Post by **Vince Fontaine** » Fri Nov 08, 2019 11:48 am

Southampton v Everton
Wolves v Villa

They can’t all win so a definite drop in magic numbers for at least two of the bottom 4

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Nov 10, 2019 9:41 am

Next four fixtures

Burnley
Watford away
Palace home
Man City home
Tottenham away

Watford
Burnley home
Southampton away
Leicester away
Palace home

Southampton
Arsenal away
Watford home
Norwich away
Newcastle home

Norwich
Everton away
Arsenal home
Southampton away
Sheffield Utd home

Some magic numbers could be decimated over these four matches.

UTC

Tricky Trevor · Post by **Tricky Trevor** » Sun Nov 10, 2019 12:04 pm

Current.

: 243FA678-ACCC-402F-95C0-A8EAE7AF9B47.jpeg (243.51 KiB) Viewed 8497 times

Paul Waine · Post by **Paul Waine** » Sun Nov 10, 2019 1:35 pm

Vince Fontaine wrote:Next four fixtures

Burnley
Watford away
Palace home
Man City home
Tottenham away

Watford
Burnley home
Southampton away
Leicester away
Palace home

Southampton
Arsenal away
Watford home
Norwich away
Newcastle home

Norwich
Everton away
Arsenal home
Southampton away
Sheffield Utd home

Some magic numbers could be decimated over these four matches.
UTC

Hi Vince, why those 3 teams fixtures? What about the teams around the Clarets? OK, we play Palace and Spurs, currently 10th and 12th. What do we need to do to be ahead of Brighton (8th), Bournemouth (7th) and Sheff Utd (5th) before Xmas?

UTC

bfcmik · Post by **bfcmik** » Sun Nov 10, 2019 1:40 pm

10/11/19

1 Liverpool 98
2 Leicester 90
3 Chelsea 90
4 Man City 89
5 Sheff Utd 81
6 Arsenal 81
7 Bournemouth 80
8 Man Utd 80
9 Wolves 80
10 Burnley
11 Brighton 79
12 C Palace 79
13 Newcastle 79
14 Spurs 78
15 Everton 78
16 West Ham 77
17 Aston Villa 75
18 Watford 72
19 Southampton 72
20 Norwich 71

After all clubs have played 12 games.

Vince Fontaine · Post by **Vince Fontaine** » Sun Nov 10, 2019 3:53 pm

Paul Waine wrote:Hi Vince, why those 3 teams fixtures? What about the teams around the Clarets? OK, we play Palace and Spurs, currently 10th and 12th. What do we need to do to be ahead of Brighton (8th), Bournemouth (7th) and Sheff Utd (5th) before Xmas?

UTC

Hi Paul,

Bottom three. Get 3 teams magic numbers to zero and we are safe. This must be our first goal in any premier league season.
UTC

harryharryharry · Post by **harryharryharry** » Sun Nov 10, 2019 5:35 pm

bfcmik wrote:09/11/19

1 Liverpool 98*
2 Leicester 90
3 Chelsea 90
4 Man City 92*
5 Sheff Utd 81
6 Arsenal 81
7 Bournemouth 80
8 Man Utd 80
9 Wolves 80
10 Burnley
11 Brighton 79
12 C Palace 79
13 Newcastle 79
14 Spurs 78
15 Everton 78
16 West Ham 77
17 Aston Villa 75
18 Watford 72
19 Southampton 72
20 Norwich 71

* = still to play this weekend

That's the Premier League table with everybody given an extra 64 points (+3 extra for Liverpool/City).

bfcmik · Post by **bfcmik** » Sun Nov 10, 2019 5:58 pm

harryharryharry wrote:That's the Premier League table with everybody given an extra 64 points (+3 extra for Liverpool/City).

Sort of. It works as if every team takes 3 points from every game + 1 extra point for potential goal difference. That number will decrease for each team as the season goes on until, hopefully, 3 teams move to 0 or below which means that they cannot attain the number of points Burnley have gained at that time so we cannot be relegated. The more teams that we see at 0 or below the higher we finish at the end of the season

Paul Waine · Post by **Paul Waine** » Sun Nov 10, 2019 7:04 pm

Vince Fontaine wrote:Hi Paul,

Bottom three. Get 3 teams magic numbers to zero and we are safe. This must be our first goal in any premier league season.
UTC

Of course, you are correct, Vince. I'm getting ahead of myself. Clarets in 10th after 12 games with 15 points. But, it's tight between Sheff Utd on 17 points in 5th and relegation places on 7 and 8 points.

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Nov 10, 2019 7:32 pm

Matchday 12

W/E 9/10 November

Burnley 3-0 West Ham

Liverpool..............-3........98
Leicester..............-3........90
Chelsea................-3........90
Man City...............-6........89
Sheffield Utd.........-5........81
Arsenal................-6........81
Man Utd...............-3........80
Wolves.................-3........80
Bournemouth.........-6........80
Burnley
Brighton...............-6........79
Palace.................-6........79
Newcastle.............-3.......79
Tottenham............-5........78
Everton................-3........78
West Ham..............-6.......77
Villa.....................-6.......75
Watford................-3.......72
Southampton..........-6.......72
Norwich................-6.......71

Every team under 100 and the ones at the bottom falling nicely

UTC

harryharryharry · Post by **harryharryharry** » Sun Nov 10, 2019 7:45 pm

bfcmik wrote:Sort of. It works as if every team takes 3 points from every game + 1 extra point for potential goal difference. That number will decrease for each team as the season goes on until, hopefully, 3 teams move to 0 or below which means that they cannot attain the number of points Burnley have gained at that time so we cannot be relegated. The more teams that we see at 0 or below the higher we finish at the end of the season

I understand how it works. I just don't understand how it tells anyone what the table doesn't.

Vince Fontaine · Post by **Vince Fontaine** » Sun Nov 10, 2019 9:54 pm

harryharryharry wrote:I understand how it works. I just don't understand how it tells anyone what the table doesn't.

If you read through the threads from the last two years it will help you understand how the magic numbers show the progress throughout the season and how we are safe well before you would normally think we are. As long as we survive

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Nov 10, 2019 10:05 pm

Over the last four matches we’ve affected the magic numbers of all teams by 3 yet the bottom four have dropped by

Villa...............-12
Watford..........-10
Southampton....-14
Norwich..........-14

UTC

aggi · Post by **aggi** » Mon Nov 11, 2019 6:59 am

harryharryharry wrote:That's the Premier League table with everybody given an extra 64 points (+3 extra for Liverpool/City).

Technically it's the maximum number of points a team can get over the remainder of the season minus the number of points that Burnley have plus one.

You can of course get that from the league table but it saves having to do the calculation, particularly later on in the season when teams have games in hand.

aggi · Post by **aggi** » Mon Nov 11, 2019 7:03 am

For those who are interested I've added back the columns showing extrapolated positions based on the last 6 and 10 games form.

Vince Fontaine · Post by **Vince Fontaine** » Tue Nov 26, 2019 3:02 pm

Matchday 13

W/E 23/24 November

Watford 0-3 Burnley

Liverpool...........-3......95
Leicester...........-3......87
Man City............-3......86
Chelsea.............-6......84
Wolves..............-3......77
Sheffield Utd......-5......76
Burnley
Arsenal.............-5......76
Man Utd............-5......75
Tottenham.........-3......75
Bournemouth......-6......74
Brighton............-6......73
Palace..............-6......73
Newcastle..........-6......73
Villa.................-3......72
Everton.............-6......72
West Ham..........-6......71
Norwich............-3......68
Southampton......-5......67
Watford.............-6.....66

UTC

Dark Cloud · Post by **Dark Cloud** » Tue Nov 26, 2019 3:35 pm

Nobody on zero yet??? Send me an alert when somebody reaches it!! (As long as it's not us!!

)

Vince Fontaine · Post by **Vince Fontaine** » Sun Dec 15, 2019 12:21 pm

Matchday 14

W/E 30 Nov 1 Dec

Burnley 0-2 Crystal Palace

Liverpool...................95
Leicester....................87
Man City............-2......84
Chelsea............-3.......81
Tottenham..................75
Wolves.............-2.......75
Sheffield Utd.....-2.......74
Arsenal............-2.......74
Man Utd...........-2.......73
Burnley
Palace.......................73
Bournemouth.....-3.......71
West Ham...................71
Newcastle.........-2.......71
Villa................-2.......70
Brighton...........-3.......70
Everton............-3.......69
Southampton...............67
Norwich...........-2.......66
Watford...........-3.......63

UTC

Tricky Trevor · Post by **Tricky Trevor** » Sun Dec 15, 2019 12:47 pm

As we stand.

: 6B58BCF7-FDBB-4B11-BFAF-F012542DA575.jpeg (201.06 KiB) Viewed 6274 times

Vince Fontaine · Post by **Vince Fontaine** » Sun Dec 15, 2019 1:08 pm

Matchday 15

Mid week 3/4/5 December

Burnley 1-4 Man City

Liverpool................95
Leicester................87
Man City.................84
Chelsea..................81
Wolves...................75
Palace....................73
Man Utd..................73
Tottenham.........-3....72
Sheffield Utd......-3....71
Arsenal.............-3....71
Newcastle................71
Brighton..................70
Burnley
Bournemouth.....-3.....68
West Ham.........-3.....68
Villa................-3.....67
Southampton.............67
Everton............-3.....66
Norwich............-3....63
Watford ...........-3....60

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Dec 15, 2019 1:22 pm

Matchday 16

W/E 07/08 December

Tottenham 5-0 Burnley

Liverpool.................95
Leicester.................87
Man City.........-3.......81
Chelsea..........-3......78
Man Utd..................73
Wolves...........-2......73
Tottenham...............72
Sheffield Utd............71
Arsenal...................71
Palace............-2......71
Newcastle...............71
Brighton..........-2.....68
Burnley
Everton..................66
Bournemouth....-3.....65
West Ham........-3.....65
Villa...............-3....64
Southampton....-3....64
Norwich..........-3....60
Watford..........-2....58

UTC

Vince Fontaine · Post by **Vince Fontaine** » Sun Dec 15, 2019 1:39 pm

Once again over the last 4 matches we have affected the bottom teams magic numbers by just 3 yet some have dropped by double figures

West Ham.......-9
Everton.........-11
Villa.............-14
Southampton...-9
Norwich........-13
Watford........-14

UTC

Vince Fontaine · Post by **Vince Fontaine** » Mon Dec 16, 2019 9:51 pm

Matchday 17

W/E 14/15 December

Burnley 1-0 Newcastle

Liverpool............-3.......92
Leicester............-5........82
Man City.............-3........78
Chelsea..............-6.......72
Tottenham..........-3........69
Man Utd.............-5........68
Sheffield Utd.......-3........68
Wolves...............-6.......67
Palace...............-5........66
Arsenal..............-6........65
Newcastle..........-6........65
Burnley
Brighton............-5........63
Bournemouth......-3........62
West Ham..........-3........62
Everton.............-5........61
Villa.................-6........58
Southampton......-6........58
Norwich............-5.........55
Watford............-6.........52

UTC

Vince Fontaine · Post by **Vince Fontaine** » Wed Dec 18, 2019 5:25 pm

The next four matches

Burnley

Bournemouth a
Everton a
Man Utd h
Villa a

Villa

Southampton h
Norwich h
Watford a
Burnley a

Southampton

Villa a
Chelsea a
Palace h
Tottenham h

Norwich

Wolves h
Villa a
Tottenham a
Palace h

Watford

Man Utd h
Sheffield Utd a
Villa h
Wolves h

Looking at some of these fixtures we could see some big reductions regardless of our results.

UTC

Tricky Trevor · Post by **Tricky Trevor** » Wed Dec 18, 2019 5:50 pm

Vince Fontaine wrote: ↑
Wed Dec 18, 2019 5:25 pm
The next four matches

Burnley

Bournemouth a
Everton a
Man Utd h
Villa a

Villa h, Vince. You got it for Villas fixtures.

Tricky Trevor · Post by **Tricky Trevor** » Sat Dec 21, 2019 6:31 pm

After todays games.

: B6B341BA-F1A2-4994-8A4E-70D18D8B38B2.jpeg (192.75 KiB) Viewed 5759 times