Leeds Weekly 20191202

For everything Leeds United related and everything not - Have your say... the Marching on Together way!
Forum rules
Please be sure you are acquainted with the forum rules outlined within our FAQs.

Help support the site by using our Amazon Affiliate link when making any purchases from Amazon.
Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Leeds Weekly 20191202

Post by Norm » Mon Dec 02, 2019 10:30 pm

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

User avatar
gessa
Superstar
Superstar
Posts: 21654
Joined: Fri Feb 29, 2008 7:40 pm

Re: Leeds Weekly 20191202

Post by gessa » Mon Dec 02, 2019 10:39 pm

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

User avatar
1964white
Moderator
Moderator
Posts: 75347
Joined: Tue Mar 30, 2010 8:46 am
Twitter: @1964white

Re: Leeds Weekly 20191202

Post by 1964white » Mon Dec 02, 2019 10:40 pm

Good idea Norm :tup:

User avatar
gessa
Superstar
Superstar
Posts: 21654
Joined: Fri Feb 29, 2008 7:40 pm

Re: Leeds Weekly 20191202

Post by gessa » Mon Dec 02, 2019 10:42 pm

Prefer the date in the proper format ;-)

Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Mon Dec 02, 2019 10:43 pm

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
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Mon Dec 02, 2019 11:00 pm

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. :tup:

User avatar
rab_rant
Manager
Manager
Posts: 4140
Joined: Tue Jan 27, 2004 2:13 pm
Location: Helsinki Finland

Re: Leeds Weekly 20191202

Post by rab_rant » Tue Dec 03, 2019 5:50 am

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 - to surround the text.

Sent from my SM-G903F using Tapatalk

Scottish Steel and Irish Fire that's the weapon I desire.

User avatar
1964white
Moderator
Moderator
Posts: 75347
Joined: Tue Mar 30, 2010 8:46 am
Twitter: @1964white

Re: Leeds Weekly 20191202

Post by 1964white » Tue Dec 03, 2019 6:54 am

rab_rant wrote:
Tue Dec 03, 2019 5:50 am
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 - 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

User avatar
rab_rant
Manager
Manager
Posts: 4140
Joined: Tue Jan 27, 2004 2:13 pm
Location: Helsinki Finland

Re: Leeds Weekly 20191202

Post by rab_rant » Tue Dec 03, 2019 7:04 am

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


Scottish Steel and Irish Fire that's the weapon I desire.

User avatar
1964white
Moderator
Moderator
Posts: 75347
Joined: Tue Mar 30, 2010 8:46 am
Twitter: @1964white

Re: Leeds Weekly 20191202

Post by 1964white » Tue Dec 03, 2019 7:46 am

rab_rant wrote:
Tue Dec 03, 2019 7:04 am
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 :tup:

User avatar
hector
Moderator
Moderator
Posts: 6244
Joined: Mon Jul 30, 2012 5:57 am
Location: Salisbury

Re: Leeds Weekly 20191202

Post by hector » Tue Dec 03, 2019 8:18 am

what do the colums FT and AT mean?
Sent from my bog standard Pc using my fingers.................



:) :)

User avatar
rab_rant
Manager
Manager
Posts: 4140
Joined: Tue Jan 27, 2004 2:13 pm
Location: Helsinki Finland

Re: Leeds Weekly 20191202

Post by rab_rant » Tue Dec 03, 2019 8:53 am

hector wrote:
Tue Dec 03, 2019 8:18 am
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
Scottish Steel and Irish Fire that's the weapon I desire.

Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Tue Dec 03, 2019 2:58 pm

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.

User avatar
rab_rant
Manager
Manager
Posts: 4140
Joined: Tue Jan 27, 2004 2:13 pm
Location: Helsinki Finland

Re: Leeds Weekly 20191202

Post by rab_rant » Tue Dec 03, 2019 3:49 pm

Norm wrote: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

Scottish Steel and Irish Fire that's the weapon I desire.

Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Tue Dec 03, 2019 10:07 pm

ELC-02-12-2019.png
ELC-02-12-2019.png

Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Tue Dec 03, 2019 10:08 pm

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

User avatar
1964white
Moderator
Moderator
Posts: 75347
Joined: Tue Mar 30, 2010 8:46 am
Twitter: @1964white

Re: Leeds Weekly 20191202

Post by 1964white » Tue Dec 03, 2019 10:20 pm

Norm wrote:
Tue Dec 03, 2019 10:08 pm
I don't know how the heck I got that in twice but I'm not messing with it!
Well done Norm :tup:

User avatar
gessa
Superstar
Superstar
Posts: 21654
Joined: Fri Feb 29, 2008 7:40 pm

Re: Leeds Weekly 20191202

Post by gessa » Tue Dec 03, 2019 10:33 pm

Norm wrote:
Tue Dec 03, 2019 10:08 pm
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. :tup:

Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Wed Dec 04, 2019 2:51 am

ELC-02-12-2019.png
Attachments
ELC-02-12-2019.png

Norm
Superstar
Superstar
Posts: 5663
Joined: Tue May 27, 2003 2:51 am
Location: SW Missouri USA

Re: Leeds Weekly 20191202

Post by Norm » Wed Dec 04, 2019 3:25 am

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

Post Reply

Advertisment