AFL Injury Update 23/04/2014

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ScottH
    It's Goodes to cheer!!
    • Sep 2003
    • 23665

    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

  • swanwolf
    Warming the Bench
    • Apr 2013
    • 198

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

    Comment

    • Ludwig
      Veterans List
      • Apr 2007
      • 9359

      #3
      Scott, is your injury list an embedded Excel spreadsheet?

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

      Comment

      • ScottH
        It's Goodes to cheer!!
        • Sep 2003
        • 23665

        #4
        Originally posted by swanwolf
        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.

        Originally posted by Ludwig
        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.

        Comment

        • Ludwig
          Veterans List
          • Apr 2007
          • 9359

          #5
          Originally posted by ScottH
          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.

          Comment

          • ScottH
            It's Goodes to cheer!!
            • Sep 2003
            • 23665

            #6
            Originally posted by Ludwig
            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.

            Comment

            • AnnieH
              RWOs Black Sheep
              • Aug 2006
              • 11332

              #7
              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.

              Comment

              • Ludwig
                Veterans List
                • Apr 2007
                • 9359

                #8
                Originally posted by ScottH
                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.

                Comment

                • Dosser
                  Just wild about Harry
                  • Mar 2011
                  • 1833

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

                  Comment

                  • Matimbo
                    Warming the Bench
                    • Apr 2009
                    • 334

                    #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."

                    Comment

                    Working...