Prem Predicto 2018/19 Leaderboard Updated! Final Round Starts and Ends Sunday! - The Bear and Badger

hylian_elf

Do we have an updated table yet?

acemuzzy

Nope but...

The Daddy wrote:

New And Improved Spreadsheet Of Prediction Score Processing Happiness (TM) is nearly done!

... He's quite the tease

The Daddy

Today’s testing during a year 11 mock exam revealed a strange quirk in the away win scoring. Dunno what I’ve done but it serves me right for cobbling it together the way I have. If one of my 6th form computing pupils handed this code in they’d be getting a sound bollocking.

The good news is everything else is working well and looking good, so updates will be swift and sexy once I fix things.

acemuzzy

acemuzzy wrote:

... He's quite the tease

The Daddy

It’s working!
I did A Silly Thing with an if statement which meant away wins were being ignored if the home team score was correct. FFS!
Anyway, I’m just copying scores across now and we should have an update sometime before the end of the season.

acemuzzy

acemuzzy wrote:

acemuzzy wrote:

... He's quite the tease

The Daddy

Ah balls it’s not working.

hylian_elf

Hmmmm. I’m losing interest without knowing how I’m doing.

The Daddy

It will be fixed this aft. Worth the wait. Hang in there!

hylian_elf

Yasss

The Daddy

Right, I’ve got to do some actual work so I’m gonna have to leave it for now. I think it’s all working as intended. Here’s last week’s scores if anyone wants to check. I’ve done the full table but just want to check I’ve not missed anything (like last goal bonus) before I post it.

Paul the sparky

Saturday 27 October 2018
15:00 Brighton v Wolves 0-2
15:00 Fulham v Bournemouth 0-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 1-0
Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 2-1
Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 90

The Daddy

Here's what you've been waiting for folks, just over one month in the making, courtesy of a badly cobbled together set of VBA macros and an Excel document that's so badly formatted it'd make Bob's posts look like the delicately written prose of an angel. After 9 weeks of intense Premier League men-on-men action here's what the main table's looking like:

1 - Paul the sparky 83
2 - Skade 78
2 - The Daddy 78
4 - hylian_elf 73
4 - Olimite 73
4 - WorKid 73*
7 - Gamermike 69
8 - Stopharage 65
9 - regmcfly 63
10 - acemuzzy 54
11 - krs 40

*Includes 7 (seven) Last Goal Time bonus points.

Current LGT bonus sits at 2 points.

hylian_elf

Workid is a cheater.

acemuzzy

This can't be right

WorKid

Oh man I've been asterisked.

hylian_elf

You’re a marked man.

Gamermike

Saturday 27 October 2018
15:00 Brighton v Wolves 1-2
15:00 Fulham v Bournemouth 1-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 0-0
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 2-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 0-1
13:30 Crystal Palace v Arsenal 0-1
16:00 Man Utd v Everton 2-0

Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 85

Olimite

]Saturday 27 October 2018
15:00 Brighton v Wolves 1-1
15:00 Fulham v Bournemouth 2-3
15:00 Liverpool v Cardiff 3-1
15:00 Southampton v Newcastle 0-0
15:00 Watford v Huddersfield 3-0
17:30 Leicester v West Ham 2-2

Sunday 28 October 2018
13:30 Burnley v Chelsea 1-3
13:30 Crystal Palace v Arsenal 0-4
16:00 Man Utd v Everton 3-2

Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 64

Diluted Dante

Saturday 27 October 2018
15:00 Brighton v Wolves 1-2
15:00 Fulham v Bournemouth 1-1
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 1-0
Sunday 28 October 2018
13:30 Burnley v Chelsea 1-3
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 1-1
Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 78

The Daddy

He’s back! (Which actually breaks my spreadsheet)

The Daddy

Updates for Dante’s return:

1 - Paul the sparky 83
2 - Skade 78
2 - The Daddy 78
4 - hylian_elf 73
4 - Olimite 73
4 - WorKid 73*
7 - Gamermike 69
8 - Stopharage 65
9 - regmcfly 63
10 - acemuzzy 54
11 - krs 40
12 - Dante 18

The Daddy

Saturday 27 October 2018
15:00 Brighton v Wolves 1-2
15:00 Fulham v Bournemouth 1-2
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 1-1
15:00 Watford v Huddersfield 2-0
17:30 Leicester v West Ham 1-0
Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 1-0
Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 76

acemuzzy

Saturday 27 October 2018
15:00 Brighton v Wolves 0-0
15:00 Fulham v Bournemouth 2-1
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 1-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 1-1

Monday 29 October 2018
20:00 Tottenham v Man City 2-2

Last Goal Time (Tottenham v Man City): 90+2

hylian_elf

Saturday 27 October 2018
15:00 Brighton v Wolves 2-2
15:00 Fulham v Bournemouth 0-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 2-1
15:00 Watford v Huddersfield 2-0
17:30 Leicester v West Ham 2-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 0-1
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 2-0

Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 84

The Daddy

krs wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 1-1
15:00 Fulham v Bournemouth 0-0
15:00 Liverpool v Cardiff 2-2
15:00 Southampton v Newcastle 0-3
15:00 Watford v Huddersfield 1-1
17:30 Leicester v West Ham 1-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 4-1
13:30 Crystal Palace v Arsenal 1-0
16:00 Man Utd v Everton 1-0

Monday 29 October 2018
20:00 Tottenham v Man City 1-0

Last Goal Time (Tottenham v Man City): 20

Skade wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 0-2
15:00 Fulham v Bournemouth 1-2
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 0-0
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 2-2
Sunday 28 October 2018
13:30 Burnley v Chelsea 1-3
13:30 Crystal Palace v Arsenal 2-3
16:00 Man Utd v Everton 1-1
Monday 29 October 2018
20:00 Tottenham v Man City 1-3

Last Goal Time (Tottenham v Man City): 82

WorKid wrote:

Saturday 27 October 2018
15:00 Brighton v Wolveapolis 1-0
15:00 Fulham v Bournemouth 2-2
15:00 Liverpool v Cardiff 5-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 2-1
17:30 Leicester v West Ham 2-1
Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-0
16:00 Man Utd v Everton 3-1
Monday 29 October 2018
20:00 Tottenham v Man City 0-2

Last Goal Time (Tottenham v Man City): 89

Stopharage wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 2-1
15:00 Fulham v Bournemouth 3-1
15:00 Liverpool v Cardiff 4-0
15:00 Southampton v Newcastle 2-1
15:00 Watford v Huddersfield 2-1
17:30 Leicester v West Ham 3-1
Sunday 28 October 2018
13:30 Burnley v Chelsea 1-2
13:30 Crystal Palace v Arsenal 2-1
16:00 Man Utd v Everton 2-1
Monday 29 October 2018
20:00 Tottenham v Man City 2-1

Last Goal Time (Tottenham v Man City): 69

regmcfly wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 0-1
15:00 Fulham v Bournemouth 1-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-1
17:30 Leicester v West Ham 2-1
Sunday 28 October 2018
13:30 Burnley v Chelsea 0-3
13:30 Crystal Palace v Arsenal 1-4
16:00 Man Utd v Everton 1-0
Monday 29 October 2018
20:00 Tottenham v Man City 0-2

Last Goal Time (Tottenham v Man City): 74

Paul the sparky wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 0-2
15:00 Fulham v Bournemouth 0-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 1-0
Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 2-1
Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 90

Gamermike wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 1-2
15:00 Fulham v Bournemouth 1-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 0-0
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 2-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 0-1
13:30 Crystal Palace v Arsenal 0-1
16:00 Man Utd v Everton 2-0

Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 85

Olimite wrote:

]Saturday 27 October 2018
15:00 Brighton v Wolves 1-1
15:00 Fulham v Bournemouth 2-3
15:00 Liverpool v Cardiff 3-1
15:00 Southampton v Newcastle 0-0
15:00 Watford v Huddersfield 3-0
17:30 Leicester v West Ham 2-2

Sunday 28 October 2018
13:30 Burnley v Chelsea 1-3
13:30 Crystal Palace v Arsenal 0-4
16:00 Man Utd v Everton 3-2

Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 64

Diluted Dante wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 1-2
15:00 Fulham v Bournemouth 1-1
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 1-0
Sunday 28 October 2018
13:30 Burnley v Chelsea 1-3
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 1-1
Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 78

The Daddy wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 1-2
15:00 Fulham v Bournemouth 1-2
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 1-1
15:00 Watford v Huddersfield 2-0
17:30 Leicester v West Ham 1-0
Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 1-0
Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 76

acemuzzy wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 0-0
15:00 Fulham v Bournemouth 2-1
15:00 Liverpool v Cardiff 3-0
15:00 Southampton v Newcastle 0-1
15:00 Watford v Huddersfield 1-0
17:30 Leicester v West Ham 1-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 0-2
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 1-1

Monday 29 October 2018
20:00 Tottenham v Man City 2-2

Last Goal Time (Tottenham v Man City): 90+2

hylian_elf wrote:

Saturday 27 October 2018
15:00 Brighton v Wolves 2-2
15:00 Fulham v Bournemouth 0-1
15:00 Liverpool v Cardiff 2-0
15:00 Southampton v Newcastle 2-1
15:00 Watford v Huddersfield 2-0
17:30 Leicester v West Ham 2-0

Sunday 28 October 2018
13:30 Burnley v Chelsea 0-1
13:30 Crystal Palace v Arsenal 1-2
16:00 Man Utd v Everton 2-0

Monday 29 October 2018
20:00 Tottenham v Man City 1-2

Last Goal Time (Tottenham v Man City): 84

The Daddy

Update after 3pm games:

acemuzzy

God I suck at this

The Daddy

Update after Sunday games:

The Daddy

Round 10 Update:

Surprisingly nobody had 6mins for the last goal on Monday so we now roll over to 4 bonus points in round 11.

Here's this week's final scores:

Olimite 12
Skade 9
Gamermike 8
Paul the sparky 8
WorKid 8
Stopharage 7
The Daddy 7
hylian_elf 6
Diluted Dante 4
regmcfly 4
acemuzzy 3
krs 1

And the overall table looks like this:

1.Paul the sparky 91
2.Skade 87
3.Olimite 85
3.The Daddy 85
5.WorKid 81
6.hylian_elf 79
7.Gamermike 77
8.Stopharage 72
9.regmcfly 67
10.acemuzzy 57
11.krs 41
12.Diluted Dante 22

Howdy, Stranger!

Categories