|
Post by wonderwall on Aug 18, 2017 19:16:27 GMT 1
19th August H1 Burnley vs West Brom H2 Southampton vs West Ham H5 Tottenham vs Chelsea Sunday 4pm A10 Swansea vs man Utd 12.30 Sat H4 Notts forest v Middlesbrough A3 Qpr vs Hull city H8 Preston vs Reading A9 Oldham vs Wigan A7 Wycombe vs Notts county H6 Portsmouth vs Walsall
|
|
|
Post by smokeyb on Aug 18, 2017 21:54:56 GMT 1
D2 Burnley vs West Brom A3 Southampton vs West Ham H4 Tottenham vs Chelsea Sunday 4pm A10 Swansea vs man Utd 12.30 Sat D1 Notts forest v Middlesbrough H5 Qpr vs Hull city H6 Preston vs Reading A9 Oldham vs Wigan H7 Wycombe vs Notts county H8 Portsmouth vs Walsall
|
|
|
Post by suedehead on Aug 19, 2017 8:33:31 GMT 1
H6 Burnley vs West Brom H10 Southampton vs West Ham H5 Tottenham vs Chelsea Sunday 4pm A7 Swansea vs man Utd 12.30 Sat A2 Notts forest v Middlesbrough H3 Qpr vs Hull city A1 Preston vs Reading H8 Oldham vs Wigan H4 Wycombe vs Notts county H9 Portsmouth vs Walsall
|
|
Tom
Member
*Of Royal Blood*
Posts: 15,419
|
Post by Tom on Aug 19, 2017 12:40:29 GMT 1
19th August
D2 Burnley vs West Brom H5 Southampton vs West Ham D3 Tottenham vs Chelsea (Sunday 4pm ) A9 Swansea vs Man Utd (12.30 Sat ) D1 Nottm Forest v Middlesbrough A6 QPR vs Hull city H4 Preston vs Reading A7 Oldham vs Wigan H10 Portsmouth vs Walsall H8 Wycombe vs Notts County
|
|
|
Post by wonderwall on Aug 19, 2017 18:56:40 GMT 1
Looks like myself and earl purple have had good weeks one result to come then results up tommorrow evening.
|
|
|
Post by wonderwall on Aug 20, 2017 17:53:37 GMT 1
19th August Results AW Burnley vs West Brom HW Southampton vs West Ham AW Tottenham vs Chelsea Sunday 4pm AW Swansea vs man Utd 12.30 Sat HW Notts forest v Middlesbrough HW Qpr vs Hull city HW Preston vs Reading AW Oldham vs Wigan AW Wycombe vs Notts county D Portsmouth vs Walsall
|
|
|
Post by Shireblogger on Aug 20, 2017 18:31:07 GMT 1
Monthly leaderboard Earl purple now out on his own and a tie for second between razzle dazzle and smokey b 1 Earl purple 1056 2 Razzle dazzle 968 2 Smokey b 968 3 Robin 891 4 Wonderwall 880 5 Raliverpool 860 6 Andy 715 7 Tom 649 8 Rewardman 627 9 Suedehead 605 10 Mad Murrey 297 + Shireblogger 618 I know I'm not doing very well, but...
|
|
|
Post by wonderwall on Aug 20, 2017 18:58:16 GMT 1
Results 1 wonderwall 385 2 Earl purple 363 3 shireblogger 308 4 smokey b 275 5 Raliverpool 264 6 Razzle dazzle 242 7 Robin 231 8 Tom 220 9 Andy 187 10 Suedehead 165 Mad murrey N/A Rewardman N/A
|
|
|
Post by wonderwall on Aug 20, 2017 19:04:12 GMT 1
Monthly leaderboard Earl purple moves into the lead with a tie between Razzle daz and smokey b 1 Earl purple 1056 2 Razzle dazzle 968 2 smokey b 968 3 Robin 891 4 Wonderwall 880 5 Raliverpool 869 6 Andy 715 7 Tom 649 9 Rewardman 627 9 Shireblogger 627 10 Suedehead 605 11 mad murrey 297
|
|
|
Post by wonderwall on Aug 20, 2017 19:12:01 GMT 1
Fixtures August 26/27 Crystal Palace v Swansea Huddersfield v Southampton Newcastle v West Ham Liverpool v Arsenal sun 4pm Birmingham v Reading Brentford v Wolves Cardiff v QPR Millwall v Norwich Rotherham v Charlton Yeovil v Coventry
|
|
|
Post by o on Aug 20, 2017 20:05:13 GMT 1
Results 1 wonderwall 385 2 Earl purple 363 3 shireblogger 299 4 smokey b 275 5 Raliverpool 255 6 Razzle dazzle 242 7 Robin 231 8 Tom 220 9 Andy 187 10 Suedehead 165 Mad murrey N/A Rewardman N/A Shireblogger is 308, and raliverpool 264.
|
|
Tom
Member
*Of Royal Blood*
Posts: 15,419
|
Post by Tom on Aug 23, 2017 12:59:08 GMT 1
I'm willing to do the following week (Sep 2nd). I'll get the games up in the next 2 or 3 days, maybe a bit early but it's the best time for me to do it. It also allows time for any alterations if any games get called off for international call-ups.
|
|
|
Post by Earl Purple on Aug 23, 2017 15:05:13 GMT 1
If you want to make it easier to not make mistakes in adding up, I put a formula that I used for Excel in an early post here.
You then put the predictor's result in the format A8 / H10 / D3 etc. Put
Rows:
1. The user's name 2. A sum of rows 13-22 3-12. The predictions 13-22. The formula.
Columns:
A: The actual result of the game B: The fixture C onward: The predictions.
You then copy rows 1 and 2, columns C to whatever for the users In a new worksheet paste special, values and transposed Then sort down on the scores.
The formula for cell C13 should be:
=IF(LEFT(C3,1)=$A3, RIGHT(C3,LEN(C3)-1)*10, -RIGHT(C3,LEN(C3)-1))
Then copy and paste that into all the cells C to whatever column, rows 13-22
The formula for C2 should be:
=SUM(C13:C22) Copy and paste that into all the columns D to whatever. (So if there are 12 participants on a week, the last column used would be N)
|
|
|
Post by raliverpool on Aug 23, 2017 17:36:43 GMT 1
As I'm on holiday in September for a fortnight, I should hopefully be able to do 2 or 3 weeks of this (9th, 16th, 23rd) before I'm back to work.
|
|
|
Post by smokeyb on Aug 24, 2017 19:38:46 GMT 1
H6 Crystal Palace v Swansea D1 Huddersfield v Southampton D2 Newcastle v West Ham H5 Liverpool v Arsenal sun 4pm H4 Birmingham v Reading A10 Brentford v Wolves H9 Cardiff v QPR A3 Millwall v Norwich A7 Rotherham v Charlton A8 Yeovil v Coventry
|
|
|
Post by raliverpool on Aug 24, 2017 20:16:02 GMT 1
August 26/27
D1 Crystal Palace v Swansea D2 Huddersfield v Southampton D3 Newcastle v West Ham H5 Liverpool v Arsenal sun 4pm H6 Birmingham v Reading A10 Brentford v Wolves H8 Cardiff v QPR A4 Millwall v Norwich A7 Rotherham v Charlton A9 Yeovil v Coventry
|
|
|
Post by Earl Purple on Aug 25, 2017 15:13:30 GMT 1
All South-East London teams in this one. I don't like predicting my own team so the usual draw, and the same for the rivals. I want them to all be away wins though.
D3 Crystal Palace v Swansea H5 Huddersfield v Southampton H6 Newcastle v West Ham D4 Liverpool v Arsenal sun 4pm H8 Birmingham v Reading A9 Brentford v Wolves H10 Cardiff v QPR D2 Millwall v Norwich D1 Rotherham v Charlton A7 Yeovil v Coventry
|
|
|
Post by Robin on Aug 25, 2017 19:27:13 GMT 1
HW4 Crystal Palace v Swansea D3 Huddersfield v Southampton D2 Newcastle v West Ham HW8 Liverpool v Arsenal sun 4pm HW6 Birmingham v Reading AW7 Brentford v Wolves HW10 Cardiff v QPR AW9 Millwall v Norwich AW1 Rotherham v Charlton AW5 Yeovil v Coventry
|
|
|
Post by Razzle Dazzle on Aug 25, 2017 21:11:41 GMT 1
H6 Crystal Palace v Swansea A4 Huddersfield v Southampton A7 Newcastle v West Ham H8 Liverpool v Arsenal sun 4pm D2 Birmingham v Reading A10 Brentford v Wolves H9 Cardiff v QPR H5 Millwall v Norwich H1 Rotherham v Charlton A3 Yeovil v Coventry
|
|
rewardman
Member
*rock n roll juvenile*
Posts: 30,775
|
Post by rewardman on Aug 26, 2017 1:10:54 GMT 1
D2 Crystal Palace v Swansea D1 Huddersfield v Southampton H3 Newcastle v West Ham D4 Liverpool v Arsenal sun 4pm H5 Birmingham v Reading A10 Brentford v Wolves H8 Cardiff v QPR A6 Millwall v Norwich A9 Rotherham v Charlton A7 Yeovil v Coventry
|
|