Leeds Weekly 20191202

[Norm]

I'm trying to provide data for interest and possible help with competitions and I'm thinking of submitting this after each Leeds league game.

It will include the ELC table, but the traditional one which shows total, home and away segments like they all used to be shown.

Also, it will have a segment with each championship team and their sequences of Wins, Draws and Losses per round of games.

Next it will show all Leeds games this season for home and away results and crowds in chronological order.

Lastly it will give a list of scorers for Leeds, with League, Cup and All totals.

Please bear with me whilst I manage to format this to fit MOT's proportional font - once I get it right I'll have cracked it and can use it much more quickly.

I hope it proves to be useful and I would appreciate feedback after anyone has used it.

Thanks, N

[gessa]

Great idea Norm, always preferred the home-away format of the league tables.

[1964white]

Good idea Norm

[gessa]

Prefer the date in the proper format

[Norm]

20191202 --- ----------Total---------- ---------Home-------- ---------Away---------
2019-2020 GP W D L FT AT W D L F A W D L F A GD P

LeedsUnited 19 12 4 3 28 10 6 2 1 13 4 6 2 2 15 6 18 40
WestBromA 19 12 6 1 36 19 5 4 0 23 14 7 2 1 13 5 17 42
Fulham____ 19 10 5 4 31 19 6 2 2 20 11 4 3 2 11 8 12 35
NottsForest 18 9 5 4 24 14 4 1 3 9 6 5 4 1 15 8 10 32
BristolCity_ 19 8 8 3 31 27 4 4 1 15 10 4 4 2 16 17 4 32
PrestonNE__ 19 9 4 6 31 23 7 2 1 25 11 2 2 5 6 12 8 31
Brentford__ 19 9 3 7 29 14 4 3 2 16 6 5 0 5 13 8 15 30
SwanseaCity 19 8 6 5 24 20 4 1 5 12 13 4 5 0 12 7 4 30
SheffWeds__ 19 8 5 6 26 18 4 4 1 10 6 4 1 5 16 12 8 29
CardiffCity__ 19 7 7 5 27 25 6 2 1 15 7 1 5 4 12 18 2 28
BlackburnR_ 19 8 3 8 26 27 5 3 2 14 10 3 0 6 12 17 -1 27
HullCity____ 19 7 5 7 30 26 4 2 4 16 13 3 3 3 14 13 4 26
Millwall____ 19 6 8 5 23 25 5 3 1 14 9 1 5 4 9 16 -2 26
DerbyCnty- 19 6 7 6 20 25 5 4 1 13 7 1 3 5 7 18 -5 25
Birminghm 19 7 4 8 19 24 5 2 2 11 7 2 2 6 8 17 -5 25
QueensPR-- 19 7 4 8 28 37 3 3 4 17 22 4 1 4 11 15 -9 25
CharltonAth 19 6 5 8 26 26 4 2 4 13 11 2 3 4 13 15 0 23
Reading____ 18 6 3 9 22 23 4 0 5 12 13 2 3 4 10 10 -1 21
Huddersfld_ 19 4 6 9 22 31 2 4 4 10 12 2 2 5 12 19 -9 18
Middlesbro' 19 3 8 8 16 27 3 4 3 8 10 0 4 5 8 17 -11 17
LutonTown_ 19 5 2 12 25 40 3 2 4 14 15 2 0 8 11 25 -15 17
WiganAthlet 19 4 4 11 17 31 4 1 4 9 12 0 3 7 8 19 -14 16
StokeCity___ 19 4 2 13 20 33 2 1 7 11 18 2 1 6 9 15 -13 14
Barnsley____ 19 2 6 11 21 38 2 4 4 15 20 0 2 7 6 18 -17 12

[Norm]

Ges, I've got a problem with dates. In the US my spreadsheet is formatted 'mmddyyyy' so I can't use that and have to think of alternatives.
Also, I can't establish a non-proportional font on MOT so tables have to be jiggled to keep columns in even a loose sense of line.

I'm going to leave this mess until I can somehow present it in a more attractive light, because the ELC table I've submitted is crap atm.
In fact, I'm late for a few drinks with friends so I'll work with this tomorrow.

Talk to you later.

[rab_rant]

what about taking a screenshot of the table and using it so you can get around the formatting issues.

I have similar problems when posting lyrics and chords to a ukulele forum. I have to use a font like courier and also use the place holders -

Code: Select all

to surround the text.

Sent from my SM-G903F using Tapatalk

[1964white]

what about taking a screenshot of the table and using it so you can get around the formatting issues.

I have similar problems when posting lyrics and chords to a ukulele forum. I have to use a font like courier and also use the place holders -

Code: Select all

to surround the text.

Sent from my SM-G903F using Tapatalk

I use screenshots for my Leeds United Correct Score competition table, looks neat & tidy

[rab_rant]

I think if you used the courier font and also the CODE place holders you could get something like this
and not use those dashes to fill things out. Took me about 5 minutes to test the hypothesis that it would work.

Code: Select all

20191202       Total        Home       Away
2019-2020   GP W  D L FT AT W D L F   A W D L F  A GD P

LeedsUnited 19 12 4 3 28 10 6 2 1 13  4 6 2 2 15 6 18 40
WestBromA   19 12 6 1 36 19 5 4 0 23 14 7 2 1 13 5 17 42
Fulham      19 10 5 4 31 19 6 2 2 20 11 4 3 2 11 8 12 35

[1964white]

I think if you used the courier font and also the CODE place holders you could get something like this
and not use those dashes to fill things out. Took me about 5 minutes to test the hypothesis that it would work.

Code: Select all

20191202       Total        Home       Away
2019-2020   GP W  D L FT AT W D L F   A W D L F  A GD P

LeedsUnited 19 12 4 3 28 10 6 2 1 13  4 6 2 2 15 6 18 40
WestBromA   19 12 6 1 36 19 5 4 0 23 14 7 2 1 13 5 17 42
Fulham      19 10 5 4 31 19 6 2 2 20 11 4 3 2 11 8 12 35

Now that does look good

[hector]

what do the colums FT and AT mean?

[rab_rant]

what do the colums FT and AT mean?

Putting on my Sherlock hat my dear Watson I would surmise that
For Total = FT and Against Total = AT

[Norm]

OK - finally awake after imbibing last night.
Thanks for the suggestions Rab - very helpful and kind of you.

I've copied the data as a picture and have successfully pasted it into a WORD document to test it out but, as I have tried to paste the item into a thread on MOT without success so far (Ctrl+V), maybe there's something in the use of CODE which enables it.

[rab_rant]

OK - finally awake after imbibing last night.
Thanks for the suggestions Rab - very helpful and kind of you.

I've copied the data as a picture and have successfully pasted it into a WORD document to test it out but, as I have tried to paste the item into a thread on MOT without success so far (Ctrl+V), maybe there's something in the use of CODE which enables it.

You should ask Leon how he pastes his screenshots into the forum. I expect you would need to save the tables as a .jpeg or .ping or .gif

Regarding the CODE method you can just use plain text as long as the font is courier and you would just highlight it Ctrl-C to copy and Ctrl-C to paste it in between the Code blocks. You have to be in advanced mode to see the Code option.

Sent from my SM-G903F using Tapatalk

[Norm]

[Norm]

I don't know how the heck I got that in twice but I'm not messing with it!

[1964white]

I don't know how the heck I got that in twice but I'm not messing with it!

Well done Norm

[gessa]

I don't know how the heck I got that in twice but I'm not messing with it!

Got there in the end Norm.

[Norm]

[Norm]

Actually I couldn't replicate the other items so all I've done is get lucky once and then fail 4 times.
I've been at this now for 14 hours and I'm sick of this so I'm going to cancel my initial intention and forget the whole idea.
Leon thanks for the copy of the instructions but I think there's something lacking in them, because I followed them faithfully but couldn't get anywhere with them apart from the initial try.
Goodnight folks