Results 1 to 10 of 10

Thread: AFL Injury Update 23/04/2014

  1. #1
    It's Goodes to cheer!! ScottH's Avatar
    Join Date
    Sep 2003
    Location
    Master of the house, keeper of the zoo
    Posts
    23,665
    Blog Entries
    2

    AFL Injury Update 23/04/2014

    SYDNEY SWANS
    AFL Injury Update, Official Injury List AFL - AFL.com.au
    *Placed on the club's long-term injury list

    PlayerInjury19-03-14Injury26-03-14Injury02-04-14Injury08-04-14Injury15-04-14Injury22-04-14
    Adam GoodesKnee4-5 weeksKnee3-4 weeksKnee2-3 weeksKnee1-2 weeksKnee1 weekKneeTest
    Kieren JackBackTestBackTest        
    Alex JohnsonKneeSeasonKneeSeasonKneeSeasonKneeSeasonKneeSeasonKneeSeason
    Lewis Roberts-ThomsonGroinTestGroinTestGroinTest      
    Kurt TippettKnee2-3 weeksKnee2-3 weeksKnee1-2 weeksKnee1-2 weeksKneeTestRib1-2 weeks
    Tommy Walsh*Hamstring4-5 weeksHamstring3-4 weeksHamstring2-3 weeksHamstring1-2 weeksHamstring1-2 weeksHamstringTest
    Gary Rohan    KneeTest      
    Craig Bird      CalfTest    
    Sam Reid      AchillesTBCAchillesTBCAchillesTest
    Sam Naismith          Knee3-5 weeks

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

  3. #3
    Veterans List Ludwig's Avatar
    Join Date
    Apr 2007
    Location
    Chiang Mai
    Posts
    9,310
    Scott, is your injury list an embedded Excel spreadsheet?

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

  4. #4
    It's Goodes to cheer!! ScottH's Avatar
    Join Date
    Sep 2003
    Location
    Master of the house, keeper of the zoo
    Posts
    23,665
    Blog Entries
    2
    Quote Originally Posted by swanwolf View Post
    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.

    Quote Originally Posted by Ludwig View Post
    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.

  5. #5
    Veterans List Ludwig's Avatar
    Join Date
    Apr 2007
    Location
    Chiang Mai
    Posts
    9,310
    Quote Originally Posted by ScottH View Post
    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.

  6. #6
    It's Goodes to cheer!! ScottH's Avatar
    Join Date
    Sep 2003
    Location
    Master of the house, keeper of the zoo
    Posts
    23,665
    Blog Entries
    2
    Quote Originally Posted by Ludwig View Post
    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.


    HTML Code:
    [table="head"]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|Season|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
    [/table]
    A pipe (|) distinguishes each column and you need equal columns per row, whether they are empty or not.

  7. #7
    RWOs Black Sheep AnnieH's Avatar
    Join Date
    Aug 2006
    Location
    At Goodesy's Place
    Posts
    11,332
    nerds
    Wild speculation, unsubstantiated rumours, silly jokes and opposition delight in another's failures is what makes an internet forum fun.
    Blessed are the cracked for they are the ones who let in the light.

  8. #8
    Veterans List Ludwig's Avatar
    Join Date
    Apr 2007
    Location
    Chiang Mai
    Posts
    9,310
    Quote Originally Posted by ScottH View Post
    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.

  9. #9
    Just wild about Harry
    Join Date
    Mar 2011
    Location
    Melbourne
    Posts
    1,833
    All I heard was "blah, blah, blah..."

  10. #10
    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.
    CIA Agent to Policeman: "Have you ever had anti-terrorist training?"
    Policeman: "Yes, I was married once."

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Single Sign On provided by vBSSO