Jump to content

Table Conversions- Footy Discussion

H_T
H_T
in Forum Help

Featured Replies

Posted

<TABLE border="1">

<CAPTION><EM>List Comparisons - MFC, GFC, StKFC</EM></CAPTION>

<TR>

<TH rowspan="1"><TH colspan="5">Melbourne<TD><TD>

<TH rowspan="1"><TH colspan="5">St. Kilda<TD><TD>

<TH rowspan="1"><TH colspan="5">Geelong

<TR>

<TH rowspan="1"><TH colspan="1">Player

<TH rowspan="1"><TH colspan="1">Age

<TH rowspan="1"><TH colspan="1">Games

<TH rowspan="1"><TH colspan="1">

<TH rowspan="1"><TH colspan="1">Player

<TH rowspan="1"><TH colspan="1">Age

<TH rowspan="1"><TH colspan="1">Games

<TH rowspan="1"><TH colspan="1">

<TH rowspan="1"><TH colspan="1">Player

<TH rowspan="1"><TH colspan="1">Age

<TH rowspan="1"><TH colspan="1">Games

<TH rowspan="1"><TH colspan="1">

<TR>

<TD><TD>J.Grimes <TD><TD>20 <TD><TD>9

<TD><TD><TD><TD>L.Hayes <TD><TD>29 <TD><TD>205

<TD><TD><TD><TD>J.Selwood <TD><TD>21 <TD><TD>59

<TR>

<TD><TD>B.McLean <TD><TD>23 <TD><TD>89

<TD><TD><TD><TD>L.Montagna <TD><TD>25 <TD><TD>112

<TD><TD><TD><TD>J.Bartel <TD><TD> 25<TD><TD> 147

<TR>

<TD><TD>B.Moloney <TD><TD>25 <TD><TD>83

<TD><TD><TD><TD>L.Ball <TD><TD>25 <TD><TD>136

<TD><TD><TD><TD>P.Chapman <TD><TD>27 <TD><TD>167

<TR>

<TD><TD>B.Green <TD><TD>28 <TD><TD>196

<TD><TD><TD><TD>N.Dal Santo <TD><TD>25 <TD><TD>158

<TD><TD><TD><TD>G.Ablett <TD><TD>25 <TD><TD>158

<TR>

<TD><TD>C.Bruce <TD><TD>29 <TD><TD>198

<TD><TD><TD><TD>B.Goddard <TD><TD>24 <TD><TD>127

<TD><TD><TD><TD>J.Corey <TD><TD>27 <TD><TD>188

<TR>

<TD><TD>A.Davey <TD><TD>26 <TD><TD>111

<TD><TD><TD><TD>A.McQualter <TD><TD>23 <TD><TD>49

<TD><TD><TD><TD>A.Mackie <TD><TD>24 <TD><TD>96

<TR>

<TD><TD>N.Jones <TD><TD>21 <TD><TD>63

<TD><TD><TD><TD>F.Ray <TD><TD>23 <TD><TD>89

<TD><TD><TD><TD>M.Stokes <TD><TD>24 <TD><TD>62

<TR>

<TD><TD>C.Sylvia <TD><TD>23 <TD><TD>83

<TD><TD><TD><TD>J.Gram <TD><TD>25 <TD><TD>90

<TD><TD><TD><TD>J.Kelly <TD><TD>25 <TD><TD>143

<TR>

<TD><TD>C.Morton <TD><TD>19 <TD><TD>33

<TD><TD><TD><TD>S.Gilbert <TD><TD>22 <TD><TD>52

<TD><TD><TD><TD>C.Enright <TD><TD>27 <TD><TD>164

<TR>

<TD><TD>J.Rivers <TD><TD>25 <TD><TD>83

<TD><TD><TD><TD>J.Blake <TD><TD>28 <TD><TD>150

<TD><TD><TD><TD>T.Harley <TD><TD>30 <TD><TD>190

<TR>

<TD><TD>J.McDonald <TD><TD>33 <TD><TD>227

<TD><TD><TD><TD>C.Jones <TD><TD>25 <TD><TD>40

<TD><TD><TD><TD>C.Ling <TD><TD>28 <TD><TD>194

<TR>

<TD><TD>J.Frawley <TD><TD>20 <TD><TD>33

<TD><TD><TD><TD>S.Fisher <TD><TD>27 <TD><TD>110

<TD><TD><TD><TD>H.Taylor <TD><TD>23 <TD><TD>34

<TR>

<TD><TD>R.Petterd <TD><TD>20 <TD><TD>22

<TD><TD><TD><TD>A.Schneider <TD><TD>25 <TD><TD>131

<TD><TD><TD><TD>M.Rooke <TD><TD>27 <TD><TD>125

<TR>

<TD><TD>P.Wheatley <TD><TD>28 <TD><TD>133

<TD><TD><TD><TD>R.Clarke <TD><TD>23 <TD><TD>46

<TD><TD><TD><TD>D.Milburn <TD><TD>32 <TD><TD>247

<TR>

<TD><TD>L.Jurrah <TD><TD>20 <TD><TD>3

<TD><TD><TD><TD>J.Koschitzke <TD><TD>26 <TD><TD>132

<TD><TD><TD><TD>C.Mooney <TD><TD>29 <TD><TD>181

<TR>

<TD><TD>M.Bate <TD><TD>21 <TD><TD>61

<TD><TD><TD><TD>N.Riewoldt <TD><TD>26 <TD><TD>172

<TD><TD><TD><TD>T.Hawkins <TD><TD>20 <TD><TD>32

<TR>

<TD><TD>R.Robertson <TD><TD>31 <TD><TD>223

<TD><TD><TD><TD>S.Milne <TD><TD>29 <TD><TD>177

<TD><TD><TD><TD>S.Byrnes <TD><TD>25 <TD><TD>65

<TR>

<TD><TD>M.Warnock <TD><TD>25 <TD><TD>34

<TD><TD><TD><TD>Z.Dawson <TD><TD>23 <TD><TD>28

<TD><TD><TD><TD>M.Scarlett <TD><TD>30 <TD><TD>220

<TR>

<TD><TD>J.Bennell <TD><TD>18 <TD><TD>12

<TD><TD><TD><TD>S.Baker <TD><TD>29 <TD><TD>168

<TD><TD><TD><TD>S.Hogan <TD><TD>20 <TD><TD>2

<TR>

<TD><TD>N.Jetta <TD><TD>18 <TD><TD>8

<TD><TD><TD><TD>J.Geary <TD><TD>21 <TD><TD>24

<TD><TD><TD><TD>T.Varcoe <TD><TD>21 <TD><TD>48

<TR>

<TD><TD>M.Jamar <TD><TD>26 <TD><TD>69

<TD><TD><TD><TD>M.Gardiner <TD><TD>30 <TD><TD>151

<TD><TD><TD><TD>M.Blake <TD><TD>23 <TD><TD>72

<TR>

<TD><TD>S.Martin <TD><TD>21 <TD><TD>20

<TD><TD><TD><TD>B.McEvoy <TD><TD>19 <TD><TD>6

<TD><TD><TD><TD>S.Mumford <TD><TD>23 <TD><TD>14

<TR>

<TH rowspan="1"><TH colspan="21"> ...

<TR>

<TH rowspan="1"><TH colspan="5">Melbourne<TD><TD>

<TH rowspan="1"><TH colspan="5">St. Kilda<TD><TD>

<TH rowspan="1"><TH colspan="5">Geelong

<TR>

<TH rowspan="1"><fontname=arial><TH colspan="1">Player

<TH rowspan="1"><TH colspan="1">Age

<TH rowspan="1"><TH colspan="1">Games

<TH rowspan="1"><TH colspan="1">

<TH rowspan="1"><TH colspan="1">Player

<TH rowspan="1"><TH colspan="1">Age

<TH rowspan="1"><TH colspan="1">Games

<TH rowspan="1"><TH colspan="1">

<TH rowspan="1"><TH colspan="1">Player

<TH rowspan="1"><TH colspan="1">Age

<TH rowspan="1"><TH colspan="1">Games

<TH rowspan="1"><TH colspan="1">

<TR>

<TD><TD>A.Wonaeamirri <TD><TD>20 <TD><TD>18

<TD><TD><TD><TD>X.Clarke <TD><TD>25 <TD><TD>105

<TD><TD><TD><TD>B.Ottens <TD><TD>29 <TD><TD>206

<TR>

<TD><TD>J.Meesen <TD><TD>21 <TD><TD>6

<TD><TD><TD><TD>S.King <TD><TD>30 <TD><TD>224

<TD><TD><TD><TD>S.Johnson <TD><TD>26 <TD><TD>125

<TR>

<TD><TD>P.Johnson <TD><TD>23 <TD><TD>56

<TD><TD><TD><TD>J.Gwilt <TD><TD>22 <TD><TD>37

<TD><TD><TD><TD>D.Johnson <TD><TD>27 <TD><TD>77

<TR>

<TD><TD>D.Bell <TD><TD>23 <TD><TD>65

<TD><TD><TD><TD>M.Hudgton <TD><TD>32 <TD><TD>230

<TD><TD><TD><TD>T.Lonergan <TD><TD>25 <TD><TD>27

<TR>

<TD><TD>A.Maric <TD><TD>19 <TD><TD>11

<TD><TD><TD><TD>J.Allen <TD><TD>21 <TD><TD>4

<TD><TD><TD><TD>D.Wojcinski <TD><TD>28 <TD><TD>143

<TR>

<TD><TD>M.Newton <TD><TD>21 <TD><TD>18

<TD><TD><TD><TD>D.Armitage <TD><TD>21 <TD><TD>16

<TD><TD><TD><TD>J.Hunt <TD><TD>27 <TD><TD>122

<TR>

<TD><TD>L.Dunn <TD><TD>21 <TD><TD>45

<TD><TD><TD><TD>C.Begley <TD><TD>22 <TD><TD>29

<TD><TD><TD><TD>T.Allwright <TD><TD>19 <TD><TD>0

<TR>

<TD><TD>C.Bartram <TD><TD>21 <TD><TD>53

<TD><TD><TD><TD>S.Dempster <TD><TD>25 <TD><TD>73

<TD><TD><TD><TD>M.Brown <TD><TD>18 <TD><TD>0

<TR>

<TD><TD>B.Miller <TD><TD>25 <TD><TD>122

<TD><TD><TD><TD>R.Eddy <TD><TD>21 <TD><TD>15

<TD><TD><TD><TD>N.Djerrkura <TD><TD>20 <TD><TD>2

<TR>

<TD><TD>J.Strauss <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>L.Fisher <TD><TD>25 <TD><TD>55

<TD><TD><TD><TD>A.Donohue <TD><TD>19 <TD><TD>0

<TR>

<TD><TD>S.Blease <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>N.Heyne <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>R.E'wickrama <TD><TD>18 <TD><TD>0

<TR>

<TD><TD>M.Whelan <TD><TD>30 <TD><TD>146

<TD><TD><TD><TD>T.Lynch <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>M.Egan <TD><TD>26 <TD><TD>59

<TR>

<TD><TD>J.Watts <TD><TD>18 <TD><TD>3

<TD><TD><TD><TD>M.Maguire <TD><TD>25 <TD><TD>99

<TD><TD><TD><TD>R.Gamble <TD><TD>21 <TD><TD>19

<TR>

<TD><TD>T.McNamara <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>L.Miles <TD><TD>22 <TD><TD>0

<TD><TD><TD><TD>T.Gillies <TD><TD>19 <TD><TD>0

<TR>

<TD><TD>R.Bail <TD><TD>20 <TD><TD>0

<TD><TD><TD><TD>A.Smith <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>T.Hunt <TD><TD>18 <TD><TD>0

<TR>

<TD><TD>C.Garland <TD><TD>21 <TD><TD>20

<TD><TD><TD><TD>R.Stanley <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>J.Laidler <TD><TD>19 <TD><TD>0

<TR>

<TD><TD>K.Cheney <TD><TD>19 <TD><TD>6

<TD><TD><TD><TD>J.Steven <TD><TD>19 <TD><TD>0

<TD><TD><TD><TD>D.McKenna <TD><TD>20 <TD><TD>0

<TR>

<TD><TD>S.Valenti <TD><TD>23 <TD><TD>10

<TD><TD><TD><TD>P.Cahill <TD><TD>18 <TD><TD>0

<TD><TD><TD><TD>B.Moles <TD><TD>23 <TD><TD>0

<TR>

<TD><TD>S.Buckley <TD><TD>22 <TD><TD>21

<TD><TD><TD><TD>E.Connors <TD><TD>19 <TD><TD>0

<TD><TD><TD><TD>K.Tenace <TD><TD>24 <TD><TD>54

<TR>

<TD><TD>J.Spencer <TD><TD>19 <TD><TD>2

<TD><TD><TD><TD>Blank<TD><TD>-<TD><TD>-

<TD><TD><TD><TD>T.West <TD><TD>21 <TD><TD>7

</TABLE>

  • Quote
    •  
     
    • Author
    The above html generates:

    list1n.th.jpg

    list2.th.jpg

    Trident, see my post, I got them up, thanks. But before I put these in the thread (or replace them in the Comparisons thread) who the hell is Bob, Frank and Zeep? :lol:

    Also T.West - I need to get him over to the Geelong column.

    Appreciate the help, thanks.

    I tried going to image shack, no success for me.

    Can you tell me when you get to image shack, when you browse for file to configure to image, what do you save it as - html? how do you go about doing that?

  • Quote

    Probably not needed (having glanced at updated post) but;

    "Bob, Frank and Zeep?" ... oops :lol: Test cases for getting formatting right.

    I searched the forum as best I could looking for an entry on table creation (I'm SURE I've seen at least one) but didnt find it/anything.

    I had hoped that html would be recognised by the forum within posts hence my original effort changing your list to html. No go. Nor with converting the html to BBcode.

    Seeing as I had a nice html table of your data I simply decided to load into IE and screen capture it (ctrl + PrintScreen). Cut out the junk, saved it to a jpg. Once I had that, it was the file that I uploaded to imageshack for thumbnail links. Really, you could do the same (screen captures) with your excel sheets for upload.

    Looks like you solved T. West too.

  • Quote
    • 2 months later...

    • Author

    Goal Kicking Analysis (for argument's sake here's the entire list - 2009 - 37 players)

    * Taken from Mfc Player List on Melbournfc.com.au (Yes, they've already delisted Robbo, Wheatley, Whelan)

    *Doesn't include rookies*

    Player Total Goals Total Games Goals 2009 Games 2009 Goal/Game Avg. Goal Av '09

    R.Bail 0 1 0 1 0.0 0.0

    C.Bartram 12 59 1 15 0.2 0.1

    M.Bate 67 68 27 20 1.0 1.4

    D.Bell 1 66 0 3 0.0 0.0

    J.Bennell 2 16 2 16 0.1 0.1

    S.Blease 0 0 0 0 0.0 0.0

    C.Bruce 204 203 9 19 1.0 0.5

    S.Buckley 3 21 0 1 0.1 0.0

    K.Cheney 0 12 0 12 0.0 0.0

    A.Davey 139 119 9 22 1.2 0.4

    L.Dunn 36 52 8 13 0.7 0.6

    J.Frawley 1 40 1 20 0.0 0.1

    C.Garland 2 20 0 1 0.1 0.0

    B.Green 239 198 12 12 1.2 1.0

    J.Grimes 2 12 2 11 0.2 0.2

    M.Jamar 28 73 7 7 0.4 1.0

    N.Jetta 7 15 7 15 0.5 0.5

    P.Johnson 17 61 6 18 0.3 0.3

    N.Jones 29 70 8 20 0.4 0.4

    L.Jurrah 20 9 20 9 2.2 2.2

    A.Maric 7 11 5 6 0.6 0.8

    S.Martin 6 27 6 19 0.2 0.3

    J.McDonald 51 235 2 18 0.2 0.1

    B.McLean 39 94 7 19 0.4 0.4

    T.McNamara 1 3 1 3 0.3 0.3

    J.Meesen 0 6 0 4 0.0 0.0

    B.Miller 79 127 19 17 0.6 1.1

    B.Moloney 23 90 7 21 0.3 0.3

    C.Morton 21 40 9 21 0.5 0.4

    M.Newton 29 21 6 5 1.4 1.2

    R.Petterd 25 29 19 18 0.9 1.1

    J.Rivers 4 90 0 20 0.0 0.0

    J.Strauss 0 0 0 0 0.0 0.0

    C.Sylvia 64 87 17 17 0.7 1.0

    M.Warnock 1 38 0 17 0.0 0.0

    J.Watts 2 3 2 3 0.7 0.7

    A.Wonaeamirri 24 18 0 0 1.3 0.0

  • Quote
    ht3o.th.jpg

    ht3o.jpg

    Use insert image function with the direct link for the above full sized* display

    * Will be sized to fit if browser window is too small.

  • Quote
    •  
    • Author

    ht3o.jpg

    Got it.

    Worked this time, thanks. I was going to ask for your email to send you the spreadsheet. Ie. to get rid of the decimal points in the games and goals columns.

    I just might use this though. I think the sorted by goal avg. is better for what I need for the thread anyway. Clearer for readers.

    I also had in the spreadsheet file(html) the key forwards (for future - identification) in another colour (red).

  • Quote
    • 1 month later...

    Archived

    This topic is now archived and is closed to further replies.

    Go to topic listing

    Featured Content

    • GAMEDAY: Geelong

      It's Game Day, and reinforcements are finally arriving for the Demons—but will it be too little, too late? They're heading down the freeway to face a Cats side returning home to their fortress after two straight losses, desperate to reignite their own season. Can the Demons breathe new life into their campaign, or will it slip even further from their grasp?

        • Clap
      • 3 replies
      Demonland
      Demonland

    • PREVIEW: Geelong

      "It's officially time for some alarm bells. I'm concerned about the lack of impact from their best players." This comment about one of the teams contesting this Friday night’s game came earlier in the week from a so-called expert radio commentator by the name of Kane Cornes. He wasn’t referring to the Melbourne Football Club but rather, this week’s home side, Geelong.The Cats are purring along with 1 win and 2 defeats and a percentage of 126.2 (courtesy of a big win at GMHBA Stadium in Round 1 vs Fremantle) which is one win more than Melbourne and double the percentage so I guess that, in the case of the Demons, its not just alarm bells, but distress signals. But don’t rely on me. Listen to Cornes who said this week about Melbourne:- “They can’t run. If you can’t run at speed and get out of the contest then you’re in trouble.

        • Love
        • Thanks
        • Like
      • 1 reply
      Demonland
      Demonland

    • NON-MFC: Round 04

      Round 4 kicks off with a blockbuster on Thursday night as traditional rivals Collingwood and Carlton clash at the MCG, with the Magpies looking to assert themselves as early-season contenders and the Blues seeking their first win of the season. Saturday opens with Gold Coast hosting Adelaide, a key test for the Suns as they aim to back up their big win last week, while the Crows will be looking to keep their perfect record intact. Reigning wooden spooners Richmond have the daunting task of facing reigning premiers Brisbane at the ‘G and the Lions will be eager to reaffirm their premiership credentials after a patchy start. Saturday night sees North Melbourne take on Sydney at Marvel Stadium, with the Swans looking to build on their first win of the season last week against a rebuilding Roos outfit.
      Sunday’s action begins with GWS hosting West Coast at ENGIE Stadium, a game that could get ugly very early for the visitors. Port Adelaide vs St Kilda at Adelaide Oval looms as a interesting clash, with both clubs form being very hard to read. The round wraps up with Fremantle taking on the Western Bulldogs at Optus Stadium in what could be a fierce contest between two sides with top-eight ambitions. Who are you tipping this week and what are the best results for the Demons besides us winning?

        • Thanks
      • 144 replies
      Demonland
      Demonland

    • CASEY: Gold Coast

      For a brief period of time in the early afternoon of yesterday, the Casey Demons occupied top place on the Smithy’s VFL table. This was only made possible by virtue of the fact that the team was the only one in this crazy competition to have played twice and it’s 1½ wins gave it an unassailable lead on the other 20 teams, some of who had yet to play a game.

        • Clap
      • 0 replies
      Demonland
      Demonland

    • REPORT: Gold Coast

      In my all-time nightmare game, the team is so ill-disciplined that it concedes its first two goals with the courtesy of not one, but two, fifty metre penalties while opening its own scoring with four behinds in a row and losing a talented youngster with good decision-making skills and a lethal left foot kick, subbed off in the first quarter with what looks like a bad knee injury. 

        • Clap
        • Love
        • Thanks
      • 0 replies
      Demonland
      Demonland

    • PODCAST: Gold Coast

      The Demonland Podcast will air LIVE on Monday, 31st March @ the all new time of 8:00pm. Join Binman, George & I as we analyse the Demons loss at the MCG to the Suns in the Round 03. Your questions and comments are a huge part of our podcast so please post anything you want to ask or say below and we'll give you a shout out on the show. If you would like to leave us a voicemail please call 03 9016 3666 and don't worry no body answers so you don't have to talk to a human.

        • Clap
        • Thanks
      • 69 replies
      Demonland
      Demonland
    View All