|
Post by Razzle Dazzle on Oct 31, 2020 13:04:00 GMT 1
Saturday 31st October A9 Sheff Utd v Man City 12.30 A7 Burnley v Chelsea H10 Liverpool v West Ham 5.30 A5 Aston Villa v Southampton sun 12pm A6 Newcastle v Everton sun 2pm H1 Man Utd v Arsenal sun 4.30 A2 Bristol City v Norwich 12.30 A3 Luton v Brentford H8 Millwall v Huddersfield H4 Wycombe v Sheff Wed
|
|
|
Post by wonderwall on Oct 31, 2020 15:18:31 GMT 1
Results Saturday 31st October A Sheff Utd v Man City 12.30 A Burnley v Chelsea H Liverpool v West Ham 5.30 A Aston Villa v Southampton sun 12pm H Newcaslte v Everton sun 2pm A Man Utd v Arsenal sun 4.30 A Bristol City v Norwich 12.30 A Luton v Brentford A Millwall v Huddersfield H Wycombe v Sheff Wed
|
|
|
Post by wonderwall on Oct 31, 2020 15:19:02 GMT 1
Weekly table 5/5 1 Daz 385 2 Wonderwall 374 3 Suedehead 319 4 Earl Purple 286 = Raliverpool 286 5 Frag 275 6 Smokey b 264 7 Shireblogger 253 8 Robin 187
|
|
|
Post by wonderwall on Oct 31, 2020 15:19:30 GMT 1
Monthly table 5/5 1 Raliverpool 1232 2 Earl purple 1111 3 Daz 1079 4 Robin 1056 5 Frag 1024 6 Wonderwall 1023 7 Smokey b 970 8 Suedehead 935 9 Shireblogger 862
|
|
|
Post by wonderwall on Nov 1, 2020 21:26:45 GMT 1
Overall table September- November 1 Raliverpool 2134 2 Frag 1892 3 Robin 1891 4 Daz 1882 5 Wonderwall 1848 6 Earl purple 1826 7 Smokey b 1784 8 Shireblogger 1599 9 Suedehead 1537
|
|
|
Post by wonderwall on Nov 2, 2020 14:33:43 GMT 1
Saturday 7th/8th November Everton v Man Utd 12.30 C Palace v Leeds Chelsea v Sheff Utd 5.30 West Ham v Fulham 8pm West Brom v Spurs Sun 12pm Leicester v Wolves sun 2pm Man City v Liverpool sun 4.30 Reading V Stoke Sat 12.30 Norwich V Swansea Sheff Wed v Millwall
|
|
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,083
|
Post by frag on Nov 5, 2020 10:28:36 GMT 1
Hey, I noticed a weird 1-point gap in the monthly results, dug in and found a few wrong scores... September1 Raliverpool 902 2 frag 868 --> 869 3 Robin 835 --> 836 4 Wonderwall 825 5 Smokey b 814 6 Daz 803 7 Shireblogger 737 8 Earl Purple 715 9 Suedehead 602 --> 605 October1 Raliverpool 1232 2 Daz 1079 --> 1144 3 Earl purple 1111 4 Robin 1056 5 Frag 1024 --> 1023 (cancelling out my one point from September ) 6 Wonderwall 1023 7 Smokey b 970 --> 979 8 Suedehead 935 9 Shireblogger 862 --> 869 Season so far1 Raliverpool 2134 4 -> 2 Daz 1882 --> 1947 2 -> 3= Frag 1892 3 -> 3= Robin 1891 --> 1892 5 Wonderwall 1848 6 Earl purple 1826 7 Smokey b 1784 --> 1793 8 Shireblogger 1599 --> 1606 9 Suedehead 1537 --> 1540
|
|
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,083
|
Post by frag on Nov 5, 2020 10:31:55 GMT 1
By the way, if you want a quick way to verify if a score looks legit, remember that the scores must be a multiple of 11 (unless there's a postponement or someone is late).
To tell if a 3-digit number is a multiple of 11, add up the first and last digits and subtract the middle one - the result should be 0 or 11. For 4-digit numbers, add up the first and third, and subtract the second and fourth (result should be 11, 0, or -11).
|
|
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,083
|
Post by frag on Nov 5, 2020 10:41:39 GMT 1
Everton v Man Utd 12.30 HW 2 C Palace v Leeds D 4 Chelsea v Sheff Utd 5.30 HW 10 West Ham v Fulham 8pm HW 8 West Brom v Spurs Sun 12pm AW 9 Leicester v Wolves sun 2pm HW 7 Man City v Liverpool sun 4.30 HW 1 Reading V Stoke Sat 12.30 HW 6 Norwich V Swansea D 3 Sheff Wed v Millwall AW 5
|
|
|
Post by Earl Purple on Nov 5, 2020 11:18:13 GMT 1
I have pulled out my spreadsheet I used. This is an example week (where I did dismally)
|
| Wonderwall | Andy | Razzle Dazzle | smokeyb | Earl Purple | raliverpool | Robin | suedehead | Tom |
|
| 242 | 154 | 121 | 121 | 77 | 198 | 121 | 154 | 231 | H | Chelsea vs Stoke City | H10 | H10 | H10 | H10 | H10 | H10 | H10 | H9 | H10 | D | Huddersfield vs Burnley | D7 | D5 | H4 | A7 | A4 | D2 | A5 | D3 | D4 | D | Man United vs Southampton | H9 | H7 | H9 | H9 | H9 | H9 | H9 | H10 | H9 | D | Newcastle vs Brighton | H6 | H6 | H5 | H3 | H5 | H6 | H1 | D7 | D6 | A | Watford vs Swansea | H8 | H9 | H8 | H6 | H8 | H8 | H7 | D5 | H7 | D | Barnsley vs Reading | D3 | D4 | H1 | D1 | D2 | D1 | A4 | A1 | A3 | H | Brentford vs Sheff Wed | H2 | D3 | H6 | H5 | D1 | H7 | H6 | A6 | H5 | A | Bristol City vs Wolves | A1 | D2 | H7 | D2 | D3 | A3 | D2 | D2 | D2 | D | Hull vs Fulham | D4 | A1 | A2 | A4 | A7 | A4 | A3 | H4 | D1 | A | Nottingham Forest vs Sunderland | H5 | H8 | H3 | H8 | H6 | H5 | H8 | H8 | H8 |
|
| 100 | 100 | 100 | 100 | 100 | 100 | 100 | 90 | 100 |
|
| 70 | 50 | -4 | -7 | -4 | 20 | -5 | 30 | 40 |
|
| -9 | -7 | -9 | -9 | -9 | -9 | -9 | -10 | -9 |
|
| -6 | -6 | -5 | -3 | -5 | -6 | -1 | 70 | 60 |
|
| -8 | -9 | -8 | -6 | -8 | -8 | -7 | -5 | -7 |
|
| 30 | 40 | -1 | 10 | 20 | 10 | -4 | -1 | -3 |
|
| 20 | -3 | 60 | 50 | -1 | 70 | 60 | -6 | 50 |
|
| 10 | -2 | -7 | -2 | -3 | 30 | -2 | -2 | -2 |
|
| 40 | -1 | -2 | -4 | -7 | -4 | -3 | -4 | 10 |
|
| -5 | -8 | -3 | -8 | -6 | -5 | -8 | -8 | -8 |
The left column has the actual results, the second column the fixtures, the top row has the names, and the top part of the matrix the predictions which must be in that format (H A or D followed by the number)
The formula in cell C13 is =IF( LEFT(C3,1)=$A3, RIGHT(C3,LEN(C3)-1)*10, -RIGHT(C3,LEN(C3)-1))
The formula in cell C3 is =SUM(C13:C22)
You can then copy rows B and C where from players and values are and paste them transposed in a different worksheet and sort by value descending.
|
|
|
Post by raliverpool on Nov 5, 2020 17:17:43 GMT 1
Saturday 7th/8th November
D2 Everton v Man Utd 12.30 H3 C Palace v Leeds H9 Chelsea v Sheff Utd 5.30 H8 West Ham v Fulham 8pm A10 West Brom v Spurs Sun 12pm H7 Leicester v Wolves sun 2pm H6 Man City v Liverpool sun 4.30 H5 Reading V Stoke Sat 12.30 H4 Norwich V Swansea D1 Sheff Wed v Millwall
|
|
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,083
|
Post by frag on Nov 5, 2020 17:46:11 GMT 1
I have pulled out my spreadsheet I used. The left column has the actual results, the second column the fixtures, the top row has the names, and the top part of the matrix the predictions which must be in that format (H A or D followed by the number)
The formula in cell C13 is =IF( LEFT(C3,1)=$A3, RIGHT(C3,LEN(C3)-1)*10, -RIGHT(C3,LEN(C3)-1))
The formula in cell C3 is =SUM(C13:C22)
You can then copy rows B and C where from players and values are and paste them transposed in a different worksheet and sort by value descending.
Yep similar to mine, except I split the predictions into different columns which makes the formulae slightly easier: =IF($B50=D50, 10*E50, -E50)
|
|
|
Post by smokeyb on Nov 5, 2020 21:24:11 GMT 1
H2 Everton v Man Utd 12.30 A3 C Palace v Leeds H10 Chelsea v Sheff Utd 5.30 H7 West Ham v Fulham 8pm A9 West Brom v Spurs Sun 12pm H5 Leicester v Wolves sun 2pm D1 Man City v Liverpool sun 4.30 H8 Reading V Stoke Sat 12.30 H4 Norwich V Swansea A6 Sheff Wed v Millwall
|
|
|
Post by wonderwall on Nov 5, 2020 21:25:00 GMT 1
I do everything on my phone don't have a computer lol
|
|
|
Post by Earl Purple on Nov 5, 2020 21:28:01 GMT 1
Saturday 7th/8th November
D1 Everton v Man Utd 12.30 A7 C Palace v Leeds H9 Chelsea v Sheff Utd 5.30 H8 West Ham v Fulham 8pm A10 West Brom v Spurs Sun 12pm H4 Leicester v Wolves sun 2pm D2 Man City v Liverpool sun 4.30 A3 Reading V Stoke Sat 12.30 H6 Norwich V Swansea A5 Sheff Wed v Millwall
|
|
|
Post by Shireblogger on Nov 6, 2020 14:10:04 GMT 1
Saturday 7th/8th November H4 : Everton v Man Utd 12.30 H2 : C Palace v Leeds H10 : Chelsea v Sheff Utd 5.30 H8 : West Ham v Fulham 8pm A6 : West Brom v Spurs Sun 12pm H5 : Leicester v Wolves sun 2pm H1 : Man City v Liverpool sun 4.30 H9 : Reading V Stoke Sat 12.30 H7 : Norwich V Swansea H3 : Sheff Wed v Millwall
|
|
|
Post by Razzle Dazzle on Nov 6, 2020 15:13:46 GMT 1
Saturday 7th/8th November
H5 Everton v Man Utd 12.30 H4 C Palace v Leeds H10 Chelsea v Sheff Utd 5.30 H9 West Ham v Fulham 8pm A8 West Brom v Spurs Sun 12pm H7 Leicester v Wolves sun 2pm H6 Man City v Liverpool sun 4.30 H2 Reading V Stoke Sat 12.30 H3 Norwich V Swansea D1 Sheff Wed v Millwall
|
|
|
Post by Robin on Nov 6, 2020 18:20:14 GMT 1
Saturday 7th/8th November
HW6 Everton v Man Utd 12.30 AW3 C Palace v Leeds HW9 Chelsea v Sheff Utd 5.30 HW8 West Ham v Fulham 8pm AW10 West Brom v Spurs Sun 12pm D4 Leicester v Wolves sun 2pm D5 Man City v Liverpool sun 4.30 HW1 Reading V Stoke Sat 12.30 HW7 Norwich V Swansea AW2 Sheff Wed v Millwall
|
|
|
Post by wonderwall on Nov 6, 2020 19:40:02 GMT 1
Saturday 7th/8th November D4 Everton v Man Utd 12.30 D3 C Palace v Leeds H10 Chelsea v Sheff Utd 5.30 H8 West Ham v Fulham 8pm A9 West Brom v Spurs Sun 12pm H2 Leicester v Wolves sun 2pm H1 Man City v Liverpool sun 4.30 H7 Reading V Stoke Sat 12.30 H6 Norwich V Swansea A5 Sheff Wed v Millwall
|
|
|
Post by suedehead on Nov 7, 2020 11:15:58 GMT 1
Saturday 7th/8th November
A3 Everton v Man Utd 12.30 A7 C Palace v Leeds H10 Chelsea v Sheff Utd 5.30 H6 West Ham v Fulham 8pm A1 West Brom v Spurs Sun 12pm H9 Leicester v Wolves sun 2pm H2 Man City v Liverpool sun 4.30 H8 Reading V Stoke Sat 12.30 H5 Norwich V Swansea H4 Sheff Wed v Millwall
|
|