OCUK Silverpaw Prediction League - 25/26 August

I've now got a spreadsheet sorted for this year. Much better than last year's. Last year I had to work out the outcomes and scorelines for each prediction manually, before handing over to the spreadsheet. On this year's I simply enter the predictions and the match results, and the spreadsheet does all the rest.

Very useful having three weeks' results to try it out on. It's sorted out all the problems in the spreadsheet (I hope), but has also found just a few problems in the results so far, as follows:

week 1

DaveMarg: 2 scorelines, not 1. 11 points and winner for the week.
DAVEM: 4 outcomes, not 3. 10 points.
el_dazza: 8 outcomes, not 7. 8 points.
mysticsniper: 5 outcomes, not 3. 8 points.
johnyccc: 4 outcomes, not 3. 7 points.
weringo: 5 outcomes, not 4. 5 points.
Ciba missing. 10/4/0/4

week 2

Grouch: 4 outcomes, not 3. Total for week 7.
Chrisss: 2 outcomes and 1 scoreline, rather than 3 and 0. Total for week 5.
Rotty: (I was tempted to keep quiet about this one :) ) 1 scoreline as well as the two outcomes. Total for week 5.
Drawoh Tesremos: 4 outcomes, not 3. Total for week 4.

week 3

Nursie: 7 outcomes, not 6. Total for week 10.
Drawoh Tesremos: 2 scorelines, not 3. Total for week 7.
ScarySquirrel: 1 scoreline and 4 outcomes, rather than 0/5. Total for week 7.
JodieG: 3 outcomes, not 2. Total for week 3.
One More Solo: 9 predictions, not 10.

season totals

All of the above knock onto the season totals,
Also:
Matrix: Weekly scores add up to 29/10/2/16
Loki missing from list. Should be 20/6/3/15


Well done for getting them so close, dazza. I had far more mistakes when I started doing them. :)
 
Miguél said:
Any chance you could post the season totals that have come out from your spreadsheet now Drawoh Tesremos ? Cheers :D
Click to expand...
Ok. Not a lot different from those already posted by dazza.

I'm quite prepared to be shot down in flames for any mistakes :)

name predictions / outcomes / scorelines / points

moody 30 / 11 / 6 / 29
cturns 30 / 9 / 6 / 27
JohnnyG 30 / 12 / 5 / 27
mcdermos 30 / 15 / 4 / 27
NokkonWud 30 / 12 / 5 / 27
Ciba 30 / 11 / 5 / 26
johnno93 30 / 8 / 6 / 26
el_dazza 30 / 15 / 3 / 24
Nzyme 30 / 9 / 5 / 24
Confusion 30 / 8 / 5 / 23
mad_allan 30 / 8 / 5 / 23
TallyHo 30 / 14 / 3 / 23
CliffyG 30 / 10 / 4 / 22
Mark Lawrenson 30 / 10 / 4 / 22
Marvt74 30 / 10 / 4 / 22
Pigeon_Killer 30 / 13 / 3 / 22
fozzy 30 / 12 / 3 / 21
mysticsniper 30 / 12 / 3 / 21
SoliD 30 / 12 / 3 / 21
BaZ87 30 / 11 / 3 / 20
Cobra-UK 30 / 8 / 4 / 20
daz.wallace 30 / 8 / 4 / 20
Ex-RoNiN 30 / 14 / 2 / 20
gumbald 30 / 11 / 3 / 20
Linoge 30 / 8 / 4 / 20
Stoddy 29 / 11 / 3 / 20
cheets64 30 / 10 / 3 / 19
Miguél 30 / 10 / 3 / 19
Rotty 30 / 10 / 3 / 19
talkshowhost 30 / 13 / 2 / 19
bungler 30 / 12 / 2 / 18
Nursie 30 / 12 / 2 / 18
SacrySquirrel 30 / 9 / 3 / 18
weringo 30 / 11 / 2 / 17
[ASSE]Hinchy 30 / 13 / 1 / 16
Andybtsn 30 / 13 / 1 / 16
Matrix 29 / 10 / 2 / 16
One More Solo 29 / 13 / 1 / 16
Ripper 30 / 10 / 2 / 16
Drawoh Tesremos 30 / 9 / 2 / 15
Loki 20 / 6 / 3 / 15
Nazca 30 / 11 / 1 / 14
Big Kev 30 / 13 / 0 / 13
Chrisss 20 / 7 / 2 / 13
DavidMarg 10 / 5 / 2 / 11
Grouch 20 / 8 / 1 / 11
JodieG 30 / 11 / 0 / 11
johnyccc 20 / 8 / 1 / 11
lemonkettaz 20 / 8 / 1 / 11
Morba 19 / 8 / 1 / 11
Stag 20 / 5 / 2 / 11
DAVEM 10 / 4 / 2 / 10
ONESHOTKILL 30 / 7 / 1 / 10
mattbrown91 10 / 6 / 1 / 9
Anders0n 20 / 5 / 1 / 8
jesta 10 / 5 / 1 / 8
Tom84 10 / 2 / 2 / 8
HangTime 10 / 4 / 1 / 7
rdizzle 20 / 7 / 0 / 7
Dan7 10 / 6 / 0 / 6
Deluxe1 9 / 3 / 1 / 6
Chong Warrier 10 / 4 / 0 / 4
Greenlizard0 10 / 3 / 0 / 3
Murzo 10 / 3 / 0 / 3
Tom0 10 / 3 / 0 / 3
CaSh_MoNeY 10 / 1 / 0 / 1
 
Thanks howard, I agree, it's not easy doing so many, by the time you've done 20 you tend to scan them and miss a few :p
 
I've just realised I'm above Rotty, result :)

And well done to all those above Lawrenson, that's my sole objective for the season :p
 
You must log in or register to reply here.
Back
Top Bottom