|
Post by wonderwall on Jul 31, 2018 12:45:11 GMT 1
Sorry yes deleted it by accident I can put first 3 weeks fixtures up if you want.I can do fixtures but might not be able to do results every week.will do results this coming week then 18 th August results if someone can do 11th August.
|
|
|
Post by wonderwall on Jul 31, 2018 12:56:32 GMT 1
Saturday 11th August Newcastle v Spurs 12.30 Bournemouth V Cardiff Fulham v C. Palace Huddersfield v Chelsea Watford v Brighton Blackburn v Millwall Notts Forest v Reading Swansea v Preston Luton Town v Sunderland Cambridge v Notts county
|
|
|
Post by wonderwall on Jul 31, 2018 13:02:27 GMT 1
Saturday 18th August Cardiff V Newcastle 12.30 Burnley v Watford Everton v Southampton Leicester v Wolves Spurs v Fulham West Ham V Bournemouth Chelsea V Arsenal 5.30 Ipswich V Aston Villa Leeds v Rotherham Coventry v Plymouth
|
|
|
Post by o on Jul 31, 2018 13:29:40 GMT 1
|
|
|
Post by Earl Purple on Jul 31, 2018 20:08:21 GMT 1
It's only Tuesday... H5 Birmingham v Norwich City H9 Brentford v Rotherham A3 Bristol City v Notts Forest A4 Ipswich v Blackburn A2 Millwall v Middlesbrough H8 Preston v Qpr H10 West Brom v Bolton H6 Wigan v Sheff Wed H7 Burton Albion v Rochdale D1 Stevenage v Tranmere
|
|
|
Post by o on Aug 1, 2018 13:13:23 GMT 1
And you hadn't been in the thread to say you were going to play, it was just a helpful reminder, know not to bother in future.
|
|
|
Post by suedehead on Aug 2, 2018 17:26:49 GMT 1
H2 Birmingham v Norwich City H7 Brentford v Rotherham A3 Bristol City v Notts Forest H1 Ipswich v Blackburn A10 Millwall v Middlesbrough H9 Preston v Qpr H8 West Brom v Bolton D4 Wigan v Sheff Wed H5 Burton Albion v Rochdale H6 Stevenage v Tranmere
|
|
|
Post by raliverpool on Aug 2, 2018 18:43:18 GMT 1
Saturday August 4th
H5 Birmingham v Norwich City H10 Brentford v Rotherham A4 Bristol City v Notts Forest D1 Ipswich v Blackburn A3 Millwall v Middlesbrough H8 Preston v QPR H9 West Brom v Bolton H6 Wigan v Sheff Wed H7 Burton Albion v Rochdale D2 Stevenage v Tranmere
|
|
frag
Member
*Paranoid Android*
I have no idea what you're talking about, so here's a bunny with a pancake on its head.
Posts: 25,042
|
Post by frag on Aug 3, 2018 8:47:43 GMT 1
Birmingham v Norwich City AW 4 Brentford v Rotherham HW 9 Bristol City v Notts Forest D 2 Ipswich v Blackburn AW 5 Millwall v Middlesbrough AW 8 Preston v QPR HW 10 West Brom v Bolton HW 6 Wigan v Sheff Wed AW 3 Burton Albion v Rochdale D 1 Stevenage v Tranmere HW 7
|
|
|
Post by wonderwall on Aug 4, 2018 17:21:40 GMT 1
Results Saturday 4th August D Birmingham v Norwich H Brentford v Rotherham D Bristol City v Notts Forest D Ipswich v Blackburn D Millwall v Middlesbrough H Preston v Qpr A West Brom v Bolton H Wigan v Sheff Wed A Burton v Rochdale D Stevenage v Tranmere
|
|
|
Post by wonderwall on Aug 4, 2018 17:31:27 GMT 1
Results 1/4 Weekly and Monthly 1 Raliverpool 242 =Andy 242 2= Wonderwall 209 = Earl purple 209 = Sam 209 3 Frag 176 4 Shireblogger 154 5 Suedehead 121 5= Daz 121 6 Smokey b 110 7 paddy 66 8 Robin 55
|
|
|
Post by o on Aug 5, 2018 11:28:15 GMT 1
Woo Hoo, Top, can we end it now, before I do my usual fall away and finish 8th! Oh and Sam would like to just say that only his parents and grandparents call him Samuel, so he'd like you to edit it please.
|
|
|
Post by o on Aug 5, 2018 11:30:33 GMT 1
Saturday 11th August A6 Newcastle v Spurs 12.30 D5 Bournemouth V Cardiff H4 Fulham v C. Palace A10 Huddersfield v Chelsea H3 Watford v Brighton H2 Blackburn v Millwall H9 Notts Forest v Reading H1 Swansea v Preston A8 Luton Town v Sunderland A7 Cambridge v Notts county
|
|
|
Post by wonderwall on Aug 5, 2018 12:20:54 GMT 1
If someone could do the scoring next weekend as I’m working I’ll do the week after.
|
|
|
Post by o on Aug 5, 2018 16:26:56 GMT 1
I'm away as well, so cant do it either...
|
|
|
Post by Earl Purple on Aug 5, 2018 17:29:00 GMT 1
Results 1/4 Weekly and Monthly 1 Andy 242 2 Raliverpool 222 3 Sam 209 = Wonderwall 209 = Earl purple 209 4 frag 176 5 Shireblogger 154 6 Suedehead 121 7 Daz 112 8 Smokey b 110 9 Robin 55 10 Paddy -6 Several of those look wrong, all scores are normally divisible by 11, unless someone missed a fixture and joined late or a game was abandoned and I can't see that happened at all.
So Raliverpool, Daz and Paddy's scores cannot be right.
I have a formula you can put in Excel that helps.
|
|
|
Post by Earl Purple on Aug 5, 2018 17:32:00 GMT 1
Copy this formula into cell C13 =IF( LEFT(C3,1)=$A3, RIGHT(C3,LEN(C3)-1)*10, -RIGHT(C3,LEN(C3)-1)) Put the players names into C1 to the right, so if there are 12 of us, C1 to N1 Put the score W, D or L into column A to the left of the fixture Put the fixture into column B. Put everyone's predictions below their name using the pattern H1 D3 A10 etc.
Copy the formula from C13 to the whole range up to N22
Into C2 copy this formula:
=SUM(C13:C22)
Copy that from C2 up to N2
Now you have everyone and their score but you can copy them, paste somewhere by value transposed and sort by value downward.
|
|
|
Post by wonderwall on Aug 5, 2018 17:33:48 GMT 1
I’ll double check now
|
|
Paddy
Member
*Pick up a P..P...P.. Paddy*
Best newcomer 2009
Posts: 19,292
|
Post by Paddy on Aug 7, 2018 15:37:04 GMT 1
Saturday 11th August H1 Newcastle v Spurs 12.30 D2 Bournemouth V Cardiff D3 Fulham v C. Palace H4 Huddersfield v Chelsea H5 Watford v Brighton D6 Blackburn v Millwall H7 Notts Forest v Reading D8 Swansea v Preston A10Luton Town v Sunderland A9 Cambridge v Notts county
|
|
|
Post by Razzle Dazzle on Aug 7, 2018 17:19:26 GMT 1
easily done
Saturday 11th August A8 Newcastle v Spurs 12.30 H7 Bournemouth V Cardiff H3 Fulham v C. Palace A9 Huddersfield v Chelsea H1 Watford v Brighton H4 Blackburn v Millwall H10 Notts Forest v Reading H6 Swansea v Preston D2 Luton Town v Sunderland A5 Cambridge v Notts county
|
|