AFL Injury Update 23/04/2014

[ScottH]

SYDNEY SWANS
AFL Injury Update, Official Injury List AFL - AFL.com.au (http://www.afl.com.au/news/injury-news/injury-list)
*Placed on the club's long-term injury list

Player|Injury|19-03-14|Injury|26-03-14|Injury|02-04-14|Injury|08-04-14|Injury|15-04-14|Injury|22-04-14
Adam Goodes|Knee|4-5 weeks|Knee|3-4 weeks|Knee|2-3 weeks|Knee|1-2 weeks|Knee|1 week|Knee|Test
Kieren Jack|Back|Test|Back|Test||||||||
Alex Johnson|Knee|Season|Knee|Season|Knee|Season|Knee|S eason|Knee|Season|Knee|Season
Lewis Roberts-Thomson|Groin|Test|Groin|Test|Groin|Test||||||
Kurt Tippett|Knee|2-3 weeks|Knee|2-3 weeks|Knee|1-2 weeks|Knee|1-2 weeks|Knee|Test|Rib|1-2 weeks
Tommy Walsh*|Hamstring|4-5 weeks|Hamstring|3-4 weeks|Hamstring|2-3 weeks|Hamstring|1-2 weeks|Hamstring|1-2 weeks|Hamstring|Test
Gary Rohan|||||Knee|Test||||||
Craig Bird|||||||Calf|Test||||
Sam Reid|||||||Achilles|TBC|Achilles|TBC|Achilles|Test
Sam Naismith|||||||||||Knee|3-5 weeks

[swanwolf]

I like the table but by round 23 I'm gonna need a wider screen!

[Ludwig]

Scott, is your injury list an embedded Excel spreadsheet?

How do you do that? It's really useful because of the formatting.

[ScottH]

I like the table but by round 23 I'm gonna need a wider screen!
I get a kick bag from the Wide Monitor Store. ;)

I'll worry about the width when we cross that right border.


Scott, is your injury list an embedded Excel spreadsheet?

How do you do that? It's really useful because of the formatting.

I'm a bloody Genius!!!!

I have it in XL, and have a sheet that automatically builds a BBcode table for me. (Told you I was a genius)
Then I just paste it in.

[Ludwig]

I'm a bloody Genius!!!!

I have it in XL, and have a sheet that automatically builds a BBcode table for me. (Told you I was a genius)
Then I just paste it in.

Do you do it with VBA code?

If so, could you share some of your genius with the rest of us? It's for the sake of beautifying RWO.

[ScottH]

Do you do it with VBA code?

If so, could you share some of your genius with the rest of us? It's for the sake of beautifying RWO.

No VBA, just using the available functions (Concatenate) to build the bbcode.
The main thing you have to know is how to to the BBcode table.



Player|Injury|19-03-14|Injury|26-03-14|Injury|02-04-14|Injury|08-04-14|Injury|15-04-14|Injury|22-04-14
Adam Goodes|Knee|4-5 weeks|Knee|3-4 weeks|Knee|2-3 weeks|Knee|1-2 weeks|Knee|1 week|Knee|Test
Kieren Jack|Back|Test|Back|Test||||||||
Alex Johnson|Knee|Season|Knee|Season|Knee|Season|Knee|S eason|Knee|Season|Knee|Season
Lewis Roberts-Thomson|Groin|Test|Groin|Test|Groin|Test||||||
Kurt Tippett|Knee|2-3 weeks|Knee|2-3 weeks|Knee|1-2 weeks|Knee|1-2 weeks|Knee|Test|Rib|1-2 weeks
Tommy Walsh*|Hamstring|4-5 weeks|Hamstring|3-4 weeks|Hamstring|2-3 weeks|Hamstring|1-2 weeks|Hamstring|1-2 weeks|Hamstring|Test
Gary Rohan|||||Knee|Test||||||
Craig Bird|||||||Calf|Test||||
Sam Reid|||||||Achilles|TBC|Achilles|TBC|Achilles|Test
Sam Naismith|||||||||||Knee|3-5 weeks


A pipe (|) distinguishes each column and you need equal columns per row, whether they are empty or not.

[AnnieH]

nerds

[Ludwig]

No VBA, just using the available functions (Concatenate) to build the bbcode.
The main thing you have to know is how to to the BBcode table..

Thanks Scott. Much appreciated.

[Dosser]

All I heard was "blah, blah, blah..."

[Matimbo]

Scott, nice table, very useful. But on my screen it has already cut off the last couple of columns on the right hand side. Can I suggest you swap the rows for the columns (i.e. players names across the top) if that's possible (and not heaps more work)? ... that way it will grow longer vertically, not wider, over the season and the whole table will remain visible. (I have faith our injury list will max out at current, touch wood!). Cheers.