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 !!

That's worth another beer.

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.

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

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 !

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 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

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

After 3 games ...

Bump for vince

Oh bugger hadn’t found it so sorry
UTC

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

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

Last years thread

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


UTC

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

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

UTC

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

Completes the weekend.
UTC

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

We'll soon be past Watford!

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

Last years thread


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

UTC

2017-2018 thread

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

UTC

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

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

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

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

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

Current.

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

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.

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

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).

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

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

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

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.

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

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

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.

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

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

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

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

As we stand.

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

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

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

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

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

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.

After todays games.