Topic: RAWK Premier League Predictions 2020/21 Chat / Tables and Scores thread

[Barneylfc∗]

I was going to update another round or 2 but got distracted by the coverage of the election so I've jibbed it off and updated the tables after round 4 

Premier League
https://docs.google.com/spreadsheets/d/12b3vtxycQWBvYknc1kzZwo5Yk0k8H9ZYavF4m7Eho2Q/edit#gid=1638831760

Championship
https://docs.google.com/spreadsheets/d/1IFe6V1vbHehlI_ljh9LP9CX2ZV239bja6fEkLT3rSb0/edit#gid=1638831760

League One
https://docs.google.com/spreadsheets/d/1hrEFHHVq0cWBfubZjt9PQPwrr2cW4BektW2-Q1joueE/edit#gid=672500623


Those at the bottom of league one will be kicked out once I'm up to date if they haven't posted in any of the other rounds.

[Grobbelrevell]

Lawro handily placed 

[Barneylfc∗]

Lawro handily placed 

Hopefully this week is the start of his downfall. He has predicted us to lose for the first time since May 2016.

[Prof]

Thanks Barney.

So for the first four rounds, I've lost all my head to heads, three of which by a single point 

[LanceLink!!!!!]

Barney, I've missed the last two weeks of this, please take me out of it, sorry for wasting your time.

[Barneylfc∗]

Barney, I've missed the last two weeks of this, please take me out of it, sorry for wasting your time.

No worries mate, although you might still be high enough up the table if you want to change your mind. You'll find out this afternoon 

[Barneylfc∗]

Might need an excel whizz in the near future. Dropped my laptop last night so fair chance it will get wiped when I leave it in for repair meaning the program I use to count the scores will be gone.

[BoRed]

Might need an excel whizz in the near future. Dropped my laptop last night so fair chance it will get wiped when I leave it in for repair meaning the program I use to count the scores will be gone.

What program do you use and where did you get it from?

I do all my scoring manually except the PL where I first have to type in all the entries into Excel, which is probably even less efficient.

[Barneylfc∗]

What program do you use and where did you get it from?

I do all my scoring manually except the PL where I first have to type in all the entries into Excel, which is probably even less efficient.

Someone sent me it a few years ago when I first took over. Its just called ScoreCalculator. I'll maybe see if I can hook it up to my TV and save it onto a disc as manually doing these would be a whole lot more time consuming.

[BoRed]

Someone sent me it a few years ago when I first took over. Its just called ScoreCalculator. I'll maybe see if I can hook it up to my TV and save it onto a disc as manually doing these would be a whole lot more time consuming.

I think Phil M ran this before you, maybe he sent it to you? In which case, he might still have it.

[Barneylfc∗]

I think Phil M ran this before you, maybe he sent it to you? In which case, he might still have it.

Was one of the players. I did look last year but the link I was sent no longer works. I was trying to send it to one of the other guys to do a cup competition but because its a .exe file it wouldn't send.
Phil used an excel formula that someone else made for him.

[BoRed]

Was one of the players. I did look last year but the link I was sent no longer works. I was trying to send it to one of the other guys to do a cup competition but because its a .exe file it wouldn't send.
Phil used an excel formula that someone else made for him.

But to use an excel formula you first have to enter everyone's predictions into excel. Seems quicker to count everyone's score on your fingers.

[Barneylfc∗]

But to use an excel formula you first have to enter everyone's predictions into excel. Seems quicker to count everyone's score on your fingers.

Yeah, was hoping that I could just copy and paste into excel like I did with this other thing.

Hopefully I can just save it to a disk and reinstall it if it gets wiped from my laptop. Will see how awkward it is later on tonight to do an update if I can see the screen through the TV 
I'm not even 100% certain the insurance covers it anymore as I think I got an email recently to say they will stop providing support for Windows 7 devices.

[Prof]

Yeah, was hoping that I could just copy and paste into excel like I did with this other thing.

Hopefully I can just save it to a disk and reinstall it if it gets wiped from my laptop. Will see how awkward it is later on tonight to do an update if I can see the screen through the TV 
I'm not even 100% certain the insurance covers it anymore as I think I got an email recently to say they will stop providing support for Windows 7 devices.

I assumed you used a data scraping programme to pick up all the predictions.  There should be a way to do that and put the data into a set of tables for exporting the scores you need.

[Barneylfc∗]

Great news. Was able to save it to a USB drive and install it on my lads computer. Now to get him to allow me on it to do updates 
First 10 games don't count anyway.

[RivaGe]

Someone sent me it a few years ago when I first took over. Its just called ScoreCalculator. I'll maybe see if I can hook it up to my TV and save it onto a disc as manually doing these would be a whole lot more time consuming.

Hey I paid someone to create that program a long time ago on fiverr and I still have it, here you go https://www.dropbox.com/s/c4010hxlcn3h7r5/ScoreCalculator.exe?dl=0

[BoRed]

Just got six points extra thanks to VAR.

[CornerFlag]

So is the deadline tomorrow (Sat) now, after the postponement of Villa-Newcastle?

[Ycuzz]

[...]
First 10 games don't count anyway.

All I read - and all I focus on..

[Barneylfc∗]

Laptop returned.

7 rounds to update. Must be some sort of record.

RPLP League Cup has been scrapped due to the Covid unless Trend wants to organise it?

[BoRed]

due to the Covid

I guess any excuse will do.

[Barneylfc∗]

I guess any excuse will do.

No point in me trying to organise it when I cant guarantee doing an update every week 

[Barneylfc∗]

Might do a new League Cup format.

Treble round at Christmas.
Top 16 overall scorers across all the rounds and leagues go through to knockout rounds.

This round in January that is split over 2 midweeks is going to be a bit of a mess though. WIll see what the craic is closer to the time for that one.

[Barneylfc∗]

Been a busy night 

WEEK 5 HEAD TO HEAD RESULTS

PREMIER LEAGUE

bryanod 4 v 6 thush
Cape_Tear 2 v 5 bobinhood
CornerFlag 4 v 2 Prof
Jsteve 2 v 7 Youngest Son of Skittle
KeegansPerm 4 v 3 Barneylfc
redforlife 7 v 6 Amir87
ShatnersBasson 6 v 7 RJH
The G in Gerrard 6 v 5 Grobbellrevell
Trendisdestiny 6 v 6 Ycuzz
WillG.LFC 6 v 3 BoRed

CHAMPIONSHIP

gary75 3 v 4 Shelts
Gerry Attrick 9 v 5 Emerald Red
LanceLink 2 v 5 nayia2002
LovelyCushionedHeader 4 v 5 vivabobbygraham
matty c 6 v 7 Carllfc
Ollyfrom.tv 1 v 2 Black Bull Nova
RivaGe 6 v 7 Rhino
Sami 5 v 4 Lee-87
Skittle 3 v 2 Vishwa Atma
tommyLFC 5 v 5 fowlerisgod4eva

LEAGUE ONE

5   Mark Lawrenson
2   bradders1011
4   mickitez
6   GreatEx
5   Port_Vale_Lad
5   Haaaank
2   kloppagetime
7   v15kop
1   AmanShah21

[Barneylfc∗]

WEEK 6 HEAD TO HEAD RESULTS

PREMIER LEAGUE

Amir87 5 v 4 KeegansPerm*
Barneylfc 3 v 5 Jsteve
bobinhood 5 v 4 WillG.LFC
BoRed 6 v 7 Trendisdestiny
Grobbellrevell 7 v 3 Cape_Tear
Prof 8 v 6 The G in Gerrard
RJH 7 v 6 bryanod
thush 4 v 5 CornerFlag**
Ycuzz 4 v 1 redforlife
Youngest Son of Skittle 5 v 6 ShatnersBasson**

*Both players posted late - No head to head points awarded
**Thush and Youngest Son of Skittle posted late but both lost their head to head anyway

CHAMPIONSHIP

Black Bull Nova 6 v 3 matty c
Carllfc 6 v 5 LovelyCushionedHeader*
Emerald Red 3 v 2 tommyLFC
fowlerisgod4eva 2 v 6 Skittle*
Lee-87 3 v 5 Gerry Attrick
nayia2002 3 v 3 Sami
Rhino 7 v 3 gary75
Shelts 4 v 3 LanceLink
Vishwa Atma 6 v 4 Ollyfrom.tv*
vivabobbygraham 5 v 6 RivaGe

*Carllfc, Skittle and Ollyfrom.tv posted late - Head to head points awarded to their opponents

LEAGUE ONE

10   Mark Lawrenson
7   bradders1011
4   mickitez
1   GreatEx*
0   Port_Vale_Lad**
0   Haaaank
6   kloppagetime
0   v15kop
0   AmanShah21

*GreatEx scored 4 - 3 point penalty for posting late
**Port_Vale_Lad scored 3 - 3 point penalty for posting late

[Barneylfc∗]

WEEK 7 HEAD TO HEAD RESULTS

PREMIER LEAGUE

Barneylfc 8 v 6 thush*
BoRed 8 v 11 bryanod
Grobbellrevell 6 v 7 WillG.LFC
Jsteve 6 v 6 KeegansPerm
Prof 8 v 8 Ycuzz
RJH 5 v 7 Amir87
ShatnersBasson 7 v 5 CornerFlag
The G in Gerrard 9 v 5 redforlife
Trendisdestiny 6 v 8 bobinhood
Youngest Son of Skittle 12 v 12 Cape_Tear

*Thush posted late but lost his head to head anyway

CHAMPIONSHIP

Carllfc 5 v 8 Shelts*
fowlerisgod4eva 6 v 7 gary75*
Lee-87 5 v 7 tommyLFC
LovelyCushionedHeader 7 v 6 matty c
nayia2002 0 v 9 Vishwa Atma
Rhino 5 v 5 Black Bull Nova
RivaGe 10 v 0 LanceLink
Sami 4 v 14 Ollyfrom.tv
Skittle 6 v 10 Emerald Red
vivabobbygraham 9 v 6 Gerry Attrick

*Carllfc and fowlerisgod4eva posted late but lost their head to head anyway

LEAGUE ONE

11   Mark Lawrenson
6   bradders1011
6   mickitez
7   GreatEx
11   Port_Vale_Lad
0   Haaaank
5   kloppagetime
0   v15kop
0   AmanShah21

[Barneylfc∗]

WEEK 8 HEAD TO HEAD RESULTS

PREMIER LEAGUE

Amir87 5 v 5 Barneylfc
bobinhood 3 v 5 BoRed
bryanod 7 v 5 The G in Gerrard
Cape_Tear 6 v 13 Jsteve
CornerFlag 7 v 7 RJH
KeegansPerm 5 v 5 Youngest Son of Skittle
redforlife 5 v 11 Prof*
thush 7 v 5 ShatnersBasson**
WillG.LFC 6 v 3 Trendisdestiny**
Ycuzz 5 v 8 Grobbellrevell**

*Prof posted late - Head to head points awarded to redforlife
**ShatnersBassoon, Trendisdestiny and Ycuzz posted late but lost their head to head anyway

CHAMPIONSHIP

Black Bull Nova 5 v 7 Carllfc
Emerald Red 8 v 13 fowlerisgod4eva*
gary75 11 v 4 Sami
Gerry Attrick 5 v 6 LovelyCushionedHeader**
LanceLink 0 v 6 Rhino***
matty c 6 v 6 vivabobbygraham
Ollyfrom.tv 0 v 11 nayia2002
Shelts 5 v 6 RivaGe
tommyLFC 11 v 5 Skittle
Vishwa Atma 5 v 6 Lee-87*

*fowlerisgod4eva and Lee-87 posted late - Head to head points awarded to their opponents
**Gerry Attrick posted late but lost his head to head anyway
***Rhino posted late - No head to head points awarded

LEAGUE ONE

4   Mark Lawrenson
7   bradders1011
6   mickitez
5   GreatEx
3   Port_Vale_Lad*
8   Haaaank
4   kloppagetime
0   v15kop
0   AmanShah21

*Port_Vale_Lad scored 6 - 3 point penalty for posting late

[Barneylfc∗]

WEEK 9 HEAD TO HEAD RESULTS

PREMIER LEAGUE

Barneylfc 9 v 3 bobinhood
BoRed 6 v 8 Cape_Tear
Grobbellrevell 8 v 3 CornerFlag
Jsteve 4 v 6 Amir87
Prof 6 v 10 KeegansPerm
RJH 9 v 4 WillG.LFC
ShatnersBasson 5 v 0 bryanod
The G in Gerrard 4 v 9 Ycuzz
Trendisdestiny 6 v 6 redforlife
Youngest Son of Skittle 4 v 7 thush

CHAMPIONSHIP

Carllfc 4 v 7 Emerald Red
fowlerisgod4eva 11 v 7 Gerry Attrick
Lee-87 3 v 0 LanceLink*
LovelyCushionedHeader 7 v 6 Black Bull Nova
nayia2002 11 v 11 matty c
Rhino 3 v 5 tommyLFC
RivaGe 6 v 11 gary75
Sami 7 v 5 Vishwa Atma
Skittle 8 v 5 Ollyfrom.tv
vivabobbygraham 7 v 7 Shelts

*Lee-87 posted late - No head to head points awarded

LEAGUE ONE

6   Mark Lawrenson
6   bradders1011
12   mickitez
7   GreatEx
0   Port_Vale_Lad*
7   Haaaank
4   kloppagetime
0   v15kop
0   AmanShah21

*Port_Vale_Lad scored 3 - 3 point penalty for posting late

[Barneylfc∗]

WEEK 10 HEAD TO HEAD RESULTS

PREMIER LEAGUE

Amir87 3 v 2 Youngest Son of Skittle
bobinhood 7 v 2 Prof
bryanod 6 v 1 Trendisdestiny
Cape_Tear 4 v 2 ShatnersBasson
CornerFlag 6 v 2 Jsteve
KeegansPerm 6 v 5 Grobbellrevell*
redforlife 2 v 4 BoRed
thush 2 v 6 RJH**
WillG.LFC 5 v 1 The G in Gerrard
Ycuzz 7 v 7 Barneylfc

*KeegansPerm posted late - Head to head points awarded to Grobellrevell
**Thush posted late but lost his head to head anyway

CHAMPIONSHIP

Black Bull Nova 2 v 4 vivabobbygraham*
Emerald Red 5 v 5 nayia2002
gary75 4 v 2 Skittle
Gerry Attrick 4 v 2 RivaGe
LanceLink 0 v 5 LovelyCushionedHeader**
matty c 4 v 4 Lee-87*
Ollyfrom.tv 6 v 3 fowlerisgod4eva
Shelts 5 v 3 Rhino
tommyLFC 6 v 2 Sami
Vishwa Atma 9 v 3 Carllfc***

*vivabobbygraham and Lee-87 posted late - Head to head points awarded to their opponents
**LovelyCushionedHeader posted late - No head to head points awarded
***Both players posted late - No head to head points awarded

LEAGUE ONE

5   Mark Lawrenson
6   bradders1011
2   mickitez
7   GreatEx
4   Port_Vale_Lad
2   Haaaank
0   kloppagetime
0   v15kop
0   AmanShah21

[Barneylfc∗]

WEEK 11 HEAD TO HEAD RESULTS

PREMIER LEAGUE

Barneylfc 10 v 6 ShatnersBasson
bobinhood 4 v 10 thush
BoRed 8 v 10 CornerFlag*
bryanod 11 v 13 Jsteve
Prof 13 v 8 Youngest Son of Skittle
redforlife 9 v 4 Grobbellrevell
The G in Gerrard 7 v 9 KeegansPerm
Trendisdestiny 4 v 10 Amir87
WillG.LFC 9 v 12 Cape_Tear
Ycuzz 10 v 10 RJH

*CornerFlag posted late - Head to head points awarded to BoRed

CHAMPIONSHIP

Carllfc 6 v 0 RivaGe
Emerald Red 13 v 6 Shelts
fowlerisgod4eva 11 v 0 LanceLink
gary75 11 v 4 LovelyCushionedHeader
nayia2002 0 v 8 vivabobbygraham
Ollyfrom.tv 5 v 6 Lee-87
Sami 8 v 11 matty c
Skittle 13 v 11 Black Bull Nova
tommyLFC 9 v 12 Gerry Attrick
Vishwa Atma 10 v 11 Rhino

LEAGUE ONE

13   Mark Lawrenson
8   bradders1011
8   mickitez
8   GreatEx
11   Port_Vale_Lad
8   Haaaank*
0   kloppagetime
0   v15kop
0   AmanShah21

*Haaaank scored 11 - 3 point penalty for posting late

[Barneylfc∗]

Thanks everyone for sticking with it despite the severe lack of updates.
Unfortunately LanceLink has left the building, and he will be joined this week by v15kop and AmanShah21 from League 1 who seemed to have stopped posting.

[Barneylfc∗]

After a long old night, I am delighted to say that the tables, scores, and fixtures have been updated after round 11 

Premier League
https://docs.google.com/spreadsheets/d/12b3vtxycQWBvYknc1kzZwo5Yk0k8H9ZYavF4m7Eho2Q/edit#gid=1638831760

Championship
https://docs.google.com/spreadsheets/d/1IFe6V1vbHehlI_ljh9LP9CX2ZV239bja6fEkLT3rSb0/edit#gid=1638831760

League One
https://docs.google.com/spreadsheets/d/1hrEFHHVq0cWBfubZjt9PQPwrr2cW4BektW2-Q1joueE/edit#gid=672500623


Thank you and goodnight

[BoRed]

Thank you and goodnight

No, thank you! What an effort, you now deserve another seven weeks off.

Can't believe I'm still in the mix after losing nearly all of the head to heads above. Got lucky with CornerFlag posting late and won one with just four points, but I'll take all the help I can get.

[Gerry Attrick]

Exceptional effort, Barney.

[Barneylfc∗]

No, thank you! What an effort, you now deserve another seven weeks off.

Can't believe I'm still in the mix after losing nearly all of the head to heads above. Got lucky with CornerFlag posting late and won one with just four points, but I'll take all the help I can get.

When doing the scores I was sure I'd be in the relegation zone or thereabouts. Happy with my position at this stage.

Lawrenson won't be eligible for promotion or included in the cups. Fucker is getting too many big scores 

[Thush]

Outstanding, Barney! An update for the ages.

Apologies for the late posting. I keep forgetting the Friday kick-offs. I'll post earlier going forward.

[Barneylfc∗]

Outstanding, Barney! An update for the ages.

Apologies for the late posting. I keep forgetting the Friday kick-offs. I'll post earlier going forward.

👍

[vivabobbygraham]

👏👏👏👏👏👏👏👏👏👏👏👏bravo barney

[WillG.LFC]

Cheers Barney

[Bobinhood]

Bloody hell. Second last.

Things are coming back to normal people!! Hope is just over the horizon.

Thanks Barney.