Jump to content

Table Conversions- Footy Discussion

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

    • NON-MFC: Round 13

      Follow all the action from every Round 13 clash excluding the Dees as the 2025 AFL Premiership Season rolls on. With Melbourne playing in the final match of the round on King's Birthday, all eyes turn to the rest of the competition. Who are you tipping to win? And more importantly, which results best serve the Demons’ finals aspirations? Join the discussion and keep track of the matches that could shape the ladder and impact our run to September.

        • Clap
        • Like
      • 133 replies
      Demonland

    • PREVIEW: Collingwood

      Having convincingly defeated last year’s premier and decisively outplayed the runner-up with 8.2 in the final quarter, nothing epitomized the Melbourne Football Club’s performance more than its 1.12 final half, particularly the eight consecutive behinds in the last term, against a struggling St Kilda team in the midst of a dismal losing streak. Just when stability and consistency were anticipated within the Demon ranks, they delivered a quintessential performance marked by instability and ill-conceived decisions, with the most striking aspect being their inaccuracy in kicking for goal, which suggested a lack of preparation (instead of sleeping in their hotel in Alice, were they having a night on the turps) rather than a well-rested team. Let’s face it - this kicking disease that makes them look like raw amateurs is becoming a millstone around the team’s neck.

        • Like
      • 1 reply
      Demonland

    • CASEY: Sydney

      The Casey Demons were always expected to emerge victorious in their matchup against the lowly-ranked Sydney Swans at picturesque Tramway Oval, situated in the shadows of the SCG in Moore Park. They dominated the proceedings in the opening two and a half quarters of the game but had little to show for it. This was primarily due to their own sloppy errors in a low-standard game that produced a number of crowded mauls reminiscent of the rugby game popular in old Sydney Town. However, when the Swans tired, as teams often do when they turn games into ugly defensive contests, Casey lifted the standard of its own play and … it was off to the races. Not to nearby Randwick but to a different race with an objective of piling on goal after goal on the way to a mammoth victory. At the 25-minute mark of the third quarter, the Demons held a slender 14-point lead over the Swans, who are ahead on the ladder of only the previous week's opposition, the ailing Bullants. Forty minutes later, they had more than fully compensated for the sloppiness of their earlier play with a decisive 94-point victory, that culminated in a rousing finish which yielded thirteen unanswered goals. Kicks hit their targets, the ball found itself going through the middle and every player made a contribution.

        • Like
      • 1 reply
      Demonland

    • REPORT: St. Kilda

      Hands up if you thought, like me, at half-time in yesterday’s game at TIO Traeger Park, Alice Springs that Melbourne’s disposal around the ground and, in particular, its kicking inaccuracy in front of the goals couldn’t get any worse. Well, it did. And what’s even more damning for the Melbourne Football Club is that the game against St Kilda and its resurgence from the bottomless pit of its miserable start to the season wasn’t just lost through poor conversion for goal but rather in the 15 minutes when the entire team went into a slumber and was mugged by the out-of-form Saints. Their six goals two behinds (one goal less than the Demons managed for the whole game) weaved a path of destruction from which they were unable to recover. Ross Lyon’s astute use of pressure to contain the situation once they had asserted their grip on the game, and Melbourne’s self-destructive wastefulness, assured that outcome. The old adage about the insanity of repeatedly doing something and expecting a different result, was out there. Two years ago, the score line in Melbourne’s loss to the Giants at this same ground was 5 goals 15 behinds - a ratio of one goal per four scoring shots - was perfectly replicated with yesterday’s 7 goals 21 behinds. 
      This has been going on for a while and opens up a number of questions. I’ll put forward a few that come to mind from this performance. The obvious first question is whether the club can find a suitable coach to instruct players on proper kicking techniques or is this a skill that can no longer be developed at this stage of the development of our playing group? Another concern is the team's ability to counter an opponent's dominance during a run on as exemplified by the Saints in the first quarter. Did the Demons underestimate their opponents, considering St Kilda's goals during this period were scored by relatively unknown forwards? Furthermore, given the modest attendance of 6,721 at TIO Traeger Park and the team's poor past performances at this venue, is it prudent to prioritize financial gain over potentially sacrificing valuable premiership points by relinquishing home ground advantage, notwithstanding the cultural significance of the team's connection to the Red Centre? 

        • Like
      • 4 replies
      Demonland

    • PREGAME: Collingwood

      After a disappointing loss in Alice Springs the Demons return to the MCG to take on the Magpies in the annual King's Birthday Big Freeze for MND game. Who comes in and who goes out?

        • Like
      • 405 replies
      Demonland

    • PODCAST: St. Kilda

      The Demonland Podcast will air LIVE on Monday, 2nd June @ 8:00pm. Join Binman, George & I as we have a chat with former Demon ruckman Jeff White about his YouTube channel First Use where he dissects ruck setups and contests. We'll then discuss the Dees disappointing loss to the Saints in Alice Springs.
      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.
      Listen LIVE: https://demonland.com/

        • Thanks
        • Like
      • 47 replies
      Demonland
    View All