Prediction League Rocky Blue League Week 19-21

Another blitz of Tables - Weeks 16, 17 & 18 below plus the table covering the whole 3 games together.

Well done to @PleaseNotPoll for top score across 3 weeks closely followed by @audrey.s.thackeray and @Spurf - who achieved the rare full sweep of getting the result right across all games in week16 (albeit with only 9 played). Call out to @O.Spurcat who climbs into equal second with @remembercolinlee

Week16


Week17


Week18


Weeks 16-18


Next Fixtures (highly subject to change!)
Round 19
26.12
Liverpool Leeds
Wolves Watford
Burnley Everton
Man City Leicester
Norwich Arsenal
Tottenham Crystal Palace
West Ham Southampton
Aston Villa Chelsea
Brighton Brentford
27.12
Newcastle Man Utd

Round 20
28.12
Arsenal Wolves
Crystal Palace Norwich
Southampton Tottenham
Watford West Ham
Leeds Aston Villa
Leicester Liverpool
29.12
Chelsea Brighton
Brentford Man City
30.12
Everton Newcastle
Man Utd Burnley

Round 21
01.01
Arsenal Man City
Leicester Norwich
Watford Tottenham
Crystal Palace West Ham
02.01
Brentford Aston Villa
Everton Brighton
Leeds Burnley
Southampton Newcastle
Chelsea Liverpool
03.01.
Man Utd Wolves

 

Round 19
26.12
Liverpool Leeds - 3-0
Wolves Watford - 2-0
Burnley Everton - 1-1
Man City Leicester - 3-1
Norwich Arsenal - 0-2
Tottenham Crystal Palace - 2-0
West Ham Southampton - 2-1
Aston Villa Chelsea - 1-2
Brighton Brentford - 2-2
27.12
Newcastle Man Utd - 0-2

Round 20
28.12
Arsenal Wolves - 2-2
Crystal Palace Norwich - 2-1
Southampton Tottenham - 1-2
Watford West Ham - 1-2
Leeds Aston Villa - 2-1
Leicester Liverpool - 1-2
29.12
Chelsea Brighton - 2-0
Brentford Man City - 0-3
30.12
Everton Newcastle - 2-0
Man Utd Burnley - 2-0

Round 21
01.01
Arsenal Man City - 1-2
Leicester Norwich - 2-0
Watford Tottenham - 1-2
Crystal Palace West Ham - 1-1
02.01
Brentford Aston Villa - 1-1
Everton Brighton - 1-2
Leeds Burnley - 1-1
Southampton Newcastle - 2-1
Chelsea Liverpool - 2-2
03.01.
Man Utd Wolves - 2-2

 

Round 19
26.12
Liverpool Leeds 2-0
Wolves Watford 1-0
Burnley Everton 1-1
Man City Leicester 2-0
Norwich Arsenal 0-2
Tottenham Crystal Palace 1-0
West Ham Southampton 2-1
Aston Villa Chelsea 1-2
Brighton Brentford 1-0
27.12
Newcastle Man Utd 0-2

Round 20
28.12
Arsenal Wolves 1-1
Crystal Palace Norwich 1-0
Southampton Tottenham 1-2
Watford West Ham 1-1
Leeds Aston Villa 1-1
Leicester Liverpool 1-2
29.12
Chelsea Brighton 2-0
Brentford Man City 0-3
30.12
Everton Newcastle 0-0
Man Utd Burnley 2-0

Round 21
01.01
Arsenal Man City 0-3
Leicester Norwich 1-0
Watford Tottenham 0-1
Crystal Palace West Ham 1-1
02.01
Brentford Aston Villa 0-1
Everton Brighton 1-2
Leeds Burnley 0-0
Southampton Newcastle 1-1
Chelsea Liverpool 2-2
03.01.
Man Utd Wolves 1-1

 

It doesn't really matter because I think my total scores are right but in week 17 you have audrey in twice and one of those should be me....

 

Yes, noticed that. When 2 people tie, my =vlookup doesn't work (will change to =sumif actually, not sure why I didn't do that in the first place) and I have to manually amend. I saw I missed that one occasion and going back to the midpoint would take too long. But you are right, it doesn't affect your overall score, or in any of the other tables.

 

Actually, thinking about it, not that difficult

This is the corrected Week17

 

Round 19
26.12
Liverpool 3 1 Leeds
Wolves 1 0 Watford
Burnley 1 1 Everton
Man City 3 0 Leicester
Norwich 0 2 Arsenal
Tottenham 2 1 Crystal Palace
West Ham 2 0 Southampton
Aston Villa 1 2 Chelsea
Brighton 3 2 Brentford
27.12
Newcastle 1 3 Man Utd

Round 20
28.12
Arsenal 1 0 Wolves
Crystal Palace 3 0 Norwich
Southampton 1 3 Tottenham
Watford 1 1 West Ham
Leeds 2 1 Aston Villa
Leicester 1 3 Liverpool
29.12
Chelsea 2 0 Brighton
Brentford 2 4 Man City
30.12
Everton 2 2 Newcastle
Man Utd 3 1 Burnley

Round 21
01.01
Arsenal 1 3 Man City
Leicester 2 0 Norwich
Watford 1 2 Tottenham
Crystal Palace 2 1 West Ham
02.01
Brentford 2 1 Aston Villa
Everton 1 1 Brighton
Leeds 2 1 Burnley
Southampton 2 2 Newcastle
Chelsea 2 2 Liverpool
03.01.
Man Utd 1 0 Wolves

 

Thanks!

 

Round 19
26.12
Liverpool 5:0 Leeds
Wolves 2:1 Watford
Burnley 1:1 Everton
Man City 3:2 Leicester
Norwich 1:2 Arsenal
Tottenham 5:0 Crystal Palace
West Ham 2:1 Southampton
Aston Villa 2:2 Chelsea
Brighton 1:0 Brentford
27.12
Newcastle 1:0 Man Utd

Round 20
28.12
Arsenal 2:1 Wolves
Crystal Palace 2:2 Norwich
Southampton 1:2 Tottenham
Watford 1:2 West Ham
Leeds 1:2 Aston Villa
Leicester 2:1 Liverpool
29.12
Chelsea 2:1 Brighton
Brentford 1:1 Man City
30.12
Everton 1:1 Newcastle
Man Utd 2:2 Burnley

Round 21
01.01
Arsenal 0:2 Man City
Leicester 3:1 Norwich
Watford 1:2 Tottenham
Crystal Palace 2:2 West Ham
02.01
Brentford 2:0 Aston Villa
Everton 1:0 Brighton
Leeds 0:0 Burnley
Southampton 2:1 Newcastle
Chelsea 3:3 Liverpool
03.01.
Man Utd 2:1 Wolves

 

Round 19
26.12
Liverpool 3 - 1 Leeds
Wolves 2 - 1 Watford
Burnley 1 - 0 Everton
Man City 2 - 1 Leicester
Norwich 1 - 3 Arsenal
Tottenham 2 - 1 Crystal Palace
West Ham 2 - 0 Southampton
Aston Villa 1 - 2 Chelsea
Brighton 1 - 1 Brentford
27.12
Newcastle1 - 3 Man Utd

Round 20
28.12
Arsenal 1 - 1 Wolves
Crystal Palace 2 - 0 Norwich
Southampton 1 - 3 Tottenham
Watford 1 - 1 West Ham
Leeds 2 - 1 Aston Villa
Leicester 1 - 1 Liverpool
29.12
Chelsea 2 - 0 Brighton
Brentford 1 - 3 Man City
30.12
Everton 1 -0 Newcastle
Man Utd 1 - 0 Burnley

Round 21
01.01
Arsenal 1 - 1 Man City
Leicester 2 - 0 Norwich
Watford 1 - 2 Tottenham
Crystal Palace 2 - 3 West Ham
02.01
Brentford 2 - 1 Aston Villa
Everton 1 - 0 Brighton
Leeds 2 - 0 Burnley
Southampton 1 - 1 Newcastle
Chelsea 1 - 1 Liverpool
03.01.
Man Utd 2 - 0 Wolves

 

Man City 2-0 Leicester
Norwich 1-3 Arsenal
Tottenham 3-1 Crystal Palace
West Ham 1-1 Southampton
Aston Villa 1-1 Chelsea
Brighton 0-0 Brentford
Newcastle 1-4 Man Utd

Thank you

 

Round 19
26.12
Man City 3-1 Leicester
Norwich 0-3 Arsenal
Tottenham 2-1 Crystal Palace
West Ham 2-0 Southampton
Aston Villa 0-1 Chelsea
Brighton 1-0 Brentford
27.12
Newcastle 1-3 Man Utd

 

Round 19
26.12
Liverpool p p Leeds
Wolves p p Watford
Burnley p p Everton
Man City 4 v 1 Leicester
Norwich 0 v 3 Arsenal
Tottenham 2 v 1 Crystal Palace
West Ham 2 v 2 Southampton
Aston Villa 1 v 1 Chelsea
Brighton 1 v 0 Brentford
27.12
Newcastle 2 v 3 Man Utd

Round 20
28.12
Arsenal 2 v 0 Wolves
Crystal Palace 2 v 0 Norwich
Southampton 1 v 2 Tottenham
Watford 1 v 2 West Ham
Leeds 1 v 3 Aston Villa
Leicester 0 v 2 Liverpool
29.12
Chelsea 3 v 0 Brighton
Brentford 1 v 4 Man City
30.12
Everton 1 v 2 Newcastle
Man Utd 2 v 0 Burnley

Round 21
01.01
Arsenal 1 v 1 Man City
Leicester 2 v 1 Norwich
Watford 1 v 1 Tottenham
Crystal Palace 1 v 1 West Ham
02.01
Brentford 2 v 2 Aston Villa
Everton 1 v 1 Brighton
Leeds 1 v 1 Burnley
Southampton 2 v 2 Newcastle
Chelsea 1 v 2 Liverpool
03.01.
Man Utd 2 v 0 Wolves

 

Liverpool P v P Leeds
Wolves P v P Watford
Burnley P v P Everton
Man City 3 v 1 Leicester
Norwich 0 v 2 Arsenal
Tottenham 2 v 1 Crystal Palace
West Ham 3 v 1 Southampton
Aston Villa 0 v 1 Chelsea
Brighton 1 v 1 Brentford
Monday 27th December
Newcastle 1 v 3 Man Utd

 

City 3 Leicester 1
Norwich 1 Arsenal 3
Spurs 2 Palace 1
West Ham 2 Soton 1
Villa 0 Chelsea 2
Brighton 1 Brentford 1
Newcastle 1 Utd 2

Games off, players out......well done SD for being a Trojan but you might as well roll dice at present

 

Round 19
26.12
Liverpool p-p Leeds
Wolves p-p Watford
Burnley p-p Everton
Man City 3-1 Leicester
Norwich 0-4 Arsenal
Tottenham 2-1 Crystal Palace
West Ham 2-0 Southampton
Aston Villa 2-2 Chelsea
Brighton 2-2 Brentford
27.12
Newcastle 1-2 Man Utd

Round 20
28.12
Arsenal 2-0 Wolves
Crystal Palace 2-1 Norwich
Southampton 1-1 Tottenham
Watford 1-2 West Ham
Leeds 2-2 Aston Villa
Leicester 2-3 Liverpool
29.12
Chelsea 3-0 Brighton
Brentford 1-4 Man City
30.12
Everton 2-0 Newcastle
Man Utd 2-1 Burnley

Round 21
01.01
Arsenal 2-2 Man City
Leicester 2-0 Norwich
Watford 1-2 Tottenham
Crystal Palace 2-2 West Ham
02.01
Brentford 1-2 Aston Villa
Everton 2-1 Brighton
Leeds 2-1 Burnley
Southampton 2-1 Newcastle
Chelsea 2-2 Liverpool
03.01.
Man Utd 1-1 Wolves

Thanks

 

Is there usually some better method?

 

Man City 2-0 Leicester
Norwich 1-1 Arsenal
Tottenham 2-0 Crystal Palace
West Ham 1-1 Southampton
Aston Villa 1-1Chelsea
Brighton 0-1 Brentford

Newcastle 1-1 Man Utd

 

Man City 4 Leicester 2
Norwich 0 Arsenal 3
Tottenham 2 Crystal Palace 1
West Ham 2 Southampton 0
Aston Villa 0 Chelsea 2
Brighton 2 Brentford 2

Newcastle 1 Man Utd 3

 

Man City 3 Leicester 1
Norwich 0 Arsenal 2
Spurs 2 Palace 0
West Ham 1 Southampton 0
Aston Villa 1 Chelsea 2
Brighton 1 Brentford 1
Newcastle 1 Man U 2