Tom
Member
*Of Royal Blood*
Posts: 15,419
|
Post by Tom on Aug 5, 2017 12:47:00 GMT 1
D5 Burton Albion vs Cardiff City H2 Ipswich vs Birmingham A8 Preston vs Sheffield Wednesday D6 Wolves vs Middlesbrough D4 MK Dons vs Wigan A10 Oldham vs Oxford A3 Southend vs Blackburn H7 Accrington vs Colchester H9 Carlisle vs Swindon D1 Crawley vs Port Vale
|
|
|
Post by wonderwall on Aug 5, 2017 12:58:24 GMT 1
]Saturday 5 August 2017, 3pm kick-off
D9 Burton Albion vs Cardiff City D10 Ipswich vs Birmingham A5 Preston vs Sheffield Wednesday D7 Wolves vs Middlesbrough A8 MK Dons vs Wigan A4 Oldham vs Oxford A6 Southend vs Blackburn H3 Accrington vs Colchester H2 Carlisle vs Swindon D1 Crawley vs Port Vale
|
|
|
Post by o on Aug 5, 2017 17:38:26 GMT 1
My usual poor effort
|
|
|
Post by Earl Purple on Aug 5, 2017 22:39:49 GMT 1
I'll work out everybody's scores soon. I'll have to think of a good way to do this, using Excel isn't so easy.
The actual results were:
A Burton Albion vs Cardiff City H Ipswich vs Birmingham H Preston vs Sheffield Wednesday H Wolves vs Middlesbrough A MK Dons vs Wigan A Oldham vs Oxford H Southend vs Blackburn H Accrington vs Colchester A Carlisle vs Swindon A Crawley vs Port Vale
none of the games finished drawn.
|
|
|
Post by Earl Purple on Aug 5, 2017 22:56:44 GMT 1
Ok, already done, and it appears I came out on top in the first week too: Earl Purple | 341 | Razzle Dazzle | 341 | Robin | 308 | rewardman | 297 | Mad Murray | 297 | smokeyb | 275 | raliverpool | 264 | suedehead | 154 | Tom | 154 | Andy | 143 | wonderwall | 110 | Shireblogger | 33 |
|
|
|
Post by Earl Purple on Aug 5, 2017 22:58:10 GMT 1
This is the formula I used in Excel:
=IF( LEFT(C14,1)=$A14, RIGHT(C14,LEN(C14)-1)*10, -RIGHT(C14,LEN(C14)-1))
That is where the prediction is in cell C14 and the correct result is in cell A14 and the prediction is in the format like A8 and the result is like A or H or D
Note that it works for H10 too
|
|
|
Post by Razzle Dazzle on Aug 6, 2017 8:10:12 GMT 1
A8 Burton Albion vs Cardiff City H1 Ipswich vs Birmingham H2 Preston vs Sheffield Wednesday A9 Wolves vs Middlesbrough H3 MK Dons vs Wigan A4 Oldham vs Oxford H5 Southend vs Blackburn H10 Accrington vs Colchester H7 Carlisle vs Swindon A6 Crawley vs Port Vale Think you missed me bud
|
|
|
Post by Earl Purple on Aug 6, 2017 8:41:37 GMT 1
I make it your score is the same as mine, 341, so we came joint first.
|
|
|
Post by o on Aug 6, 2017 12:32:08 GMT 1
Someone check his score Glad to see I wasn't bottom, you can always work out that if I say there are lots of Draws, there wont be
|
|
|
Post by o on Aug 6, 2017 12:33:20 GMT 1
And thanks Earl P for doing it, over to Robin, who could post the next set of fixtures in the thread, and then Earl P, or Admin can edit them into the first post by Earl P.
|
|
|
Post by Earl Purple on Aug 6, 2017 12:53:06 GMT 1
As Robin is an admin he can edit the 2nd post.
|
|
|
Post by Earl Purple on Aug 6, 2017 12:54:21 GMT 1
From my spread-sheet:
Razzle Dazzle 341 A8 H1 H2 A9 H3 A4 H5 H10 H7 A6 80 10 20 -9 -3 40 50 100 -7 60
|
|
|
Post by Robin on Aug 7, 2017 22:03:54 GMT 1
Upcoming fixtures:
Crystal Palace v Huddersfield Town Everton v Stoke City Brighton v Man City Newcastle v Tottenham Man Utd v West Ham Brentford v Nottm Forest Derby County v Wolves Reading v Fulham Middlesbrough v Sheff Utd Norwich City v Sunderland
|
|
|
Post by Earl Purple on Aug 10, 2017 16:51:06 GMT 1
H5 Crystal Palace v Huddersfield Town H7 Everton v Stoke City A9 Brighton v Man City A8 Newcastle v Tottenham H10 Man Utd v West Ham H4 Brentford v Nottm Forest H1 Derby County v Wolves A2 Reading v Fulham H3 Middlesbrough v Sheff Utd H6 Norwich City v Sunderland
|
|
|
Post by smokeyb on Aug 10, 2017 19:17:57 GMT 1
H4 Crystal Palace v Huddersfield Town H6 Everton v Stoke City A10 Brighton v Man City A9 Newcastle v Tottenham H7 Man Utd v West Ham A5 Brentford v Nottm Forest A3 Derby County v Wolves D1 Reading v Fulham H2 Middlesbrough v Sheff Utd H8 Norwich City v Sunderland
|
|
|
Post by raliverpool on Aug 10, 2017 19:45:26 GMT 1
H6 Crystal Palace v Huddersfield Town H8 Everton v Stoke City A10 Brighton v Man City A7 Newcastle v Tottenham H9 Man Utd v West Ham H3 Brentford v Nottm Forest H1 Derby County v Wolves A4 Reading v Fulham H2 Middlesbrough v Sheff Utd H5 Norwich City v Sunderland
|
|
|
Post by suedehead on Aug 10, 2017 20:24:54 GMT 1
A1 Crystal Palace v Huddersfield Town H9 Everton v Stoke City D3 Brighton v Man City A5 Newcastle v Tottenham H6 Man Utd v West Ham D2 Brentford v Nottm Forest H8 Derby County v Wolves H4 Reading v Fulham H10 Middlesbrough v Sheff Utd H7 Norwich City v Sunderland
|
|
|
Post by Razzle Dazzle on Aug 10, 2017 21:27:49 GMT 1
H2 Crystal Palace v Huddersfield Town H9 Everton v Stoke City A10 Brighton v Man City A8 Newcastle v Tottenham H7 Man Utd v West Ham H3 Brentford v Nottm Forest H5 Derby County v Wolves H1 Reading v Fulham H6 Middlesbrough v Sheff Utd D4 Norwich City v Sunderland
|
|
|
Post by Robin on Aug 10, 2017 22:29:41 GMT 1
HW8 Crystal Palace v Huddersfield Town HW6 Everton v Stoke City AW10 Brighton v Man City AW5 Newcastle v Tottenham HW9 Man Utd v West Ham HW3 Brentford v Nottm Forest D1 Derby County v Wolves AW2 Reading v Fulham HW7 Middlesbrough v Sheff Utd HW4 Norwich City v Sunderland
|
|
|
Post by Shireblogger on Aug 11, 2017 8:57:13 GMT 1
H4 : Crystal Palace v Huddersfield Town H9 : Everton v Stoke City A5 : Brighton v Man City A1 : Newcastle v Tottenham H10 : Man Utd v West Ham H8 : Brentford v Nottm Forest H2 : Derby County v Wolves H7 : Reading v Fulham H6 : Middlesbrough v Sheff Utd H3 : Norwich City v Sunderland
|
|