Set 7
Hengy
ML12
BE11
LH40
MT02
SW11
SC21
SM02
AC11
LI12
NB20
RH21
SN11
WB21
AN12
WS11
Comment deleted by Site Moderator
Comment deleted by Site Moderator
comment by Galvin : Hand jobs for geckos (U10415)
posted 8 minutes ago
Which looks perfect........when in the preview box it was different....dunno?
Might be coz I c+p the fixtures too to save scrolling...
----------------------------------------------------------------------
No prob with that lot for the test.
comment by Penshawdave (U1894)
posted 2 hours, 27 minutes ago
comment by Sir Kenneth Bates (U8238)
posted 29 minutes ago
Dave
How are you noticing that people are putting the space? Obviously if someone points out missed points? Otherwise would it go unseen?
----------------------------------------------------------------------
Hi When I copy/paste I have to highlight the list of codes the CODE with an extra space shows up. EG here is one set received;
If you highlight them (as if copying) you will see what I mean. The blue area is wider because of the extra space.
ML11
BE13
LH52
MT12
SW11
SC02
SM12
AC22
LI21
NB30
RH21
SN12
WB11
AN02
WS12
The first code is and last code are Ok ... but you can see there is a wider space behind all the other codes. When I transfer to spreadsheet and apply the correct codes it MISSES the ones with the extra space as a NUMBER and puts it in as TEXT. I then have to manually correct the score.
BUT.. Everyones score is correct but it is a pain to have to correct the entry.
It is the only way I would run the game as it is simple to collect AND score as long as only 4 characters are used.
Hope that explains it.
----------------------------------------------------------------------
Wrap the cell formula with "=TRIM(A1)" that removes leading and trailing spaces
Comment deleted by Site Moderator
Comment deleted by Site Moderator
MFB
Set 7
ML11
BE12
LH31
MT01
SW00
SC12
SM02
AC21
LI21
NB20
RH21
SN21
WB10
AN12
WS11
Admin1. Will try that for all the cells that are to receive the pasted codes on my spreadsheet.
comment by Penshawdave (U1894)
posted 6 minutes ago
Admin1. Will try that for all the cells that are to receive the pasted codes on my spreadsheet.
----------------------------------------------------------------------
Obviously A1 should be whatever cell you want trimmed
ML ... Man Utd v Leicester (early KO)
BE ... Bournemouth v Everton
LH ... Liverpool v Hull
MT ... Middlesbrough v Tottenham
SW ... Stoke v West Brom
SC ... Sunderland v Crystal P
SM ... Swansea v Man City
AC ... Arsenal v Chelsea
LI ... Leeds v Ipswich
NB ... Norwich v Burton
RH ... Reading v Huddersfield
SN ... Sheff W v Nottm F
WB ... Wolves v Brentford
AN ... ** Aston V v Newcastle
WS ... West Ham v Southampton
Set 7
ML21
BE02
LH10
MT13
SW01
SC12
SM02
AC02
LI00
NB20
RH11
SN20
WB21
AN13
WS11
Admin. I would need to trim ALL the cells for each entry, normally 15 per player. I think it best that players enter just 4 characters as now ... most do anyway.
Thanks anyway.
olhos
SET 7
ML31
BE12
LH20
MT12
SW01
SC20
SM13
AC22
LI31
NB20
RH10
SN11
WB10
AN12
WS00
olhos
Set 7B
CT22
LF02
BA22
BS00
BL12
CD11
WW23
NN21
AB31
CM13
MZ20
HS10
comment by Penshawdave (U1894)
posted 6 minutes ago
Admin. I would need to trim ALL the cells for each entry, normally 15 per player. I think it best that players enter just 4 characters as now ... most do anyway.
Thanks anyway.
----------------------------------------------------------------------
Yeah, you should be able to drag the formula down. No worries.
Set7
Lily
ML11
BE12
LH30
SW21
SP01
SM02
AC11
LI21
NB31
RH10
WB21
AN13
WS32
ML ... Man Utd v Leicester (early KO)
BE ... Bournemouth v Everton
LH ... Liverpool v Hull
MT ... Middlesbrough v Tottenham
SW ... Stoke v West Brom
SC ... Sunderland v Crystal P
SM ... Swansea v Man City
AC ... Arsenal v Chelsea
LI ... Leeds v Ipswich
NB ... Norwich v Burton
RH ... Reading v Huddersfield
SN ... Sheff W v Nottm F
WB ... Wolves v Brentford
AN ... ** Aston V v Newcastle
WS ... West Ham v Southampton
Admin1
Set 7
ML10
BE01
LH10
MT01
SW10
SC01
SM10
AC21
LI10
NB10
RH01
SN12
WB10
AN02
WS12
Middlesex
Set 7
ML11
BE00
LH21
MT11
SW21
SC31
SM12
AC21
LI21
NB31
RH21
SN21
WB11
AN22
WS11
Cheers.
comment by lillywhite4ever(Sandro the boot) (U1090)
posted 32 minutes ago
Set7
Lily
ML11
BE12
LH30
SW21
SP01
SM02
AC11
LI21
NB31
RH10
WB21
AN13
WS32
----------------------------------------------------------------------
Lily please check your entry. Only 13 codes and one incorrect. I will put in SC01 for your SP01 but you still have 2 missing.
+++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++
ALL ENTERED TO HERE
++++++++++++++++++++++++++++++
Set 7
AJWWFC
ML21
BE02
LH31
MT01
SW02
SC02
SM03
AC22
LI01
NB21
RH01
SN21
WB01
AN02
WS12
AN ... ** Aston V v Newcastle
WS ... West Ham v Southampton
Tu Meke
Set 7
ML11
BE13
LH41
MT00
SW11
SC12
SM03
AC21
LI10
NB30
RH01
SN11
WB21
AN22
WS21
Ginolasmane
Set 7
ML11
BE12
LH30
MT02
SW22
SC21
SM02
AC32
LI11
NB30
RH20
SN11
WB10
AN22
WS11
Set 7
The Hague
ML11
BE21
LH31
MT11
SW21
SC21
SM12
AC21
LI21
NB10
RH11
SN21
WB11
AN21
WS21
Sign in if you want to comment
£450 King of Pundits Mk2: Fixtures
Page 34 of 166
35 | 36 | 37 | 38 | 39
posted on 23/9/16
Set 7
Hengy
ML12
BE11
LH40
MT02
SW11
SC21
SM02
AC11
LI12
NB20
RH21
SN11
WB21
AN12
WS11
posted on 23/9/16
Comment deleted by Site Moderator
posted on 23/9/16
No
posted on 23/9/16
Comment deleted by Site Moderator
posted on 23/9/16
comment by Galvin : Hand jobs for geckos (U10415)
posted 8 minutes ago
Which looks perfect........when in the preview box it was different....dunno?
Might be coz I c+p the fixtures too to save scrolling...
----------------------------------------------------------------------
No prob with that lot for the test.
posted on 23/9/16
comment by Penshawdave (U1894)
posted 2 hours, 27 minutes ago
comment by Sir Kenneth Bates (U8238)
posted 29 minutes ago
Dave
How are you noticing that people are putting the space? Obviously if someone points out missed points? Otherwise would it go unseen?
----------------------------------------------------------------------
Hi When I copy/paste I have to highlight the list of codes the CODE with an extra space shows up. EG here is one set received;
If you highlight them (as if copying) you will see what I mean. The blue area is wider because of the extra space.
ML11
BE13
LH52
MT12
SW11
SC02
SM12
AC22
LI21
NB30
RH21
SN12
WB11
AN02
WS12
The first code is and last code are Ok ... but you can see there is a wider space behind all the other codes. When I transfer to spreadsheet and apply the correct codes it MISSES the ones with the extra space as a NUMBER and puts it in as TEXT. I then have to manually correct the score.
BUT.. Everyones score is correct but it is a pain to have to correct the entry.
It is the only way I would run the game as it is simple to collect AND score as long as only 4 characters are used.
Hope that explains it.
----------------------------------------------------------------------
Wrap the cell formula with "=TRIM(A1)" that removes leading and trailing spaces
posted on 23/9/16
Comment deleted by Site Moderator
posted on 23/9/16
Comment deleted by Site Moderator
posted on 23/9/16
MFB
Set 7
ML11
BE12
LH31
MT01
SW00
SC12
SM02
AC21
LI21
NB20
RH21
SN21
WB10
AN12
WS11
posted on 23/9/16
Admin1. Will try that for all the cells that are to receive the pasted codes on my spreadsheet.
posted on 23/9/16
comment by Penshawdave (U1894)
posted 6 minutes ago
Admin1. Will try that for all the cells that are to receive the pasted codes on my spreadsheet.
----------------------------------------------------------------------
Obviously A1 should be whatever cell you want trimmed
posted on 23/9/16
ML ... Man Utd v Leicester (early KO)
BE ... Bournemouth v Everton
LH ... Liverpool v Hull
MT ... Middlesbrough v Tottenham
SW ... Stoke v West Brom
SC ... Sunderland v Crystal P
SM ... Swansea v Man City
AC ... Arsenal v Chelsea
LI ... Leeds v Ipswich
NB ... Norwich v Burton
RH ... Reading v Huddersfield
SN ... Sheff W v Nottm F
WB ... Wolves v Brentford
AN ... ** Aston V v Newcastle
WS ... West Ham v Southampton
Set 7
ML21
BE02
LH10
MT13
SW01
SC12
SM02
AC02
LI00
NB20
RH11
SN20
WB21
AN13
WS11
posted on 23/9/16
Admin. I would need to trim ALL the cells for each entry, normally 15 per player. I think it best that players enter just 4 characters as now ... most do anyway.
Thanks anyway.
posted on 23/9/16
olhos
SET 7
ML31
BE12
LH20
MT12
SW01
SC20
SM13
AC22
LI31
NB20
RH10
SN11
WB10
AN12
WS00
posted on 23/9/16
olhos
Set 7B
CT22
LF02
BA22
BS00
BL12
CD11
WW23
NN21
AB31
CM13
MZ20
HS10
posted on 23/9/16
comment by Penshawdave (U1894)
posted 6 minutes ago
Admin. I would need to trim ALL the cells for each entry, normally 15 per player. I think it best that players enter just 4 characters as now ... most do anyway.
Thanks anyway.
----------------------------------------------------------------------
Yeah, you should be able to drag the formula down. No worries.
posted on 23/9/16
Set7
Lily
ML11
BE12
LH30
SW21
SP01
SM02
AC11
LI21
NB31
RH10
WB21
AN13
WS32
posted on 23/9/16
ML ... Man Utd v Leicester (early KO)
BE ... Bournemouth v Everton
LH ... Liverpool v Hull
MT ... Middlesbrough v Tottenham
SW ... Stoke v West Brom
SC ... Sunderland v Crystal P
SM ... Swansea v Man City
AC ... Arsenal v Chelsea
LI ... Leeds v Ipswich
NB ... Norwich v Burton
RH ... Reading v Huddersfield
SN ... Sheff W v Nottm F
WB ... Wolves v Brentford
AN ... ** Aston V v Newcastle
WS ... West Ham v Southampton
Admin1
Set 7
ML10
BE01
LH10
MT01
SW10
SC01
SM10
AC21
LI10
NB10
RH01
SN12
WB10
AN02
WS12
posted on 23/9/16
Middlesex
Set 7
ML11
BE00
LH21
MT11
SW21
SC31
SM12
AC21
LI21
NB31
RH21
SN21
WB11
AN22
WS11
Cheers.
posted on 23/9/16
comment by lillywhite4ever(Sandro the boot) (U1090)
posted 32 minutes ago
Set7
Lily
ML11
BE12
LH30
SW21
SP01
SM02
AC11
LI21
NB31
RH10
WB21
AN13
WS32
----------------------------------------------------------------------
Lily please check your entry. Only 13 codes and one incorrect. I will put in SC01 for your SP01 but you still have 2 missing.
posted on 23/9/16
+++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++
ALL ENTERED TO HERE
++++++++++++++++++++++++++++++
posted on 23/9/16
Set 7
AJWWFC
ML21
BE02
LH31
MT01
SW02
SC02
SM03
AC22
LI01
NB21
RH01
SN21
WB01
AN02
WS12
posted on 23/9/16
AN ... ** Aston V v Newcastle
WS ... West Ham v Southampton
Tu Meke
Set 7
ML11
BE13
LH41
MT00
SW11
SC12
SM03
AC21
LI10
NB30
RH01
SN11
WB21
AN22
WS21
posted on 23/9/16
Ginolasmane
Set 7
ML11
BE12
LH30
MT02
SW22
SC21
SM02
AC32
LI11
NB30
RH20
SN11
WB10
AN22
WS11
posted on 24/9/16
Set 7
The Hague
ML11
BE21
LH31
MT11
SW21
SC21
SM12
AC21
LI21
NB10
RH11
SN21
WB11
AN21
WS21
Page 34 of 166
35 | 36 | 37 | 38 | 39