User talk:Ecky
From Snoutslouts
(Difference between revisions)
(→Players Stats since 2002) |
|||
| (One intermediate revision not shown) | |||
| Line 9: | Line 9: | ||
Who played in every match and all their stats (15+ categories) from every match for both League and Reserves (just a few Reserves games from 03 and 04 where the game by game stats are missing) | Who played in every match and all their stats (15+ categories) from every match for both League and Reserves (just a few Reserves games from 03 and 04 where the game by game stats are missing) | ||
I can easily run queries that summarise this info. For example it took me 30 secs to copy paste this here | I can easily run queries that summarise this info. For example it took me 30 secs to copy paste this here | ||
| - | + | <pre> | |
League games, goals and behinds from 2003-2010 | League games, goals and behinds from 2003-2010 | ||
| Line 138: | Line 138: | ||
Redden, Thomas 1 0 0 | Redden, Thomas 1 0 0 | ||
MacFarlane, Peter 1 0 0 | MacFarlane, Peter 1 0 0 | ||
| - | + | </pre> | |
[[User:Ecky|Ecky]] 05:25, 1 September 2010 (UTC) | [[User:Ecky|Ecky]] 05:25, 1 September 2010 (UTC) | ||
| + | |||
| + | ::OK, so when for example we have some like Golding who played across the period,the POTB says he has 76 games and 18 goals, but obviously that stops at 2002. So if I add your figures above that (20 games, 19 goals) I would have his career tally? Plus of course we would like to have the last year he played (2004?) and the Bio data like date of birth and height/weight. | ||
| + | |||
| + | ::Oh and the cut'n'paste table thingo is at: http://excel2wiki.net/index.php .. .simply copy and paste from your spreadsheet, generate the code, copy that into the wiki where you are editing and BAM its done. | ||
| + | |||
| + | ::[[User:Ranga|Ranga]] 05:55, 1 September 2010 (UTC) | ||
| + | |||
| + | Yep, if you add the pre and post 2003 totals together they should be right (assuming POTB is right). And yes, I'll use that cut and paste thing next time! [[User:Ecky|Ecky]] 06:36, 1 September 2010 (UTC) | ||
Current revision as of 06:36, 1 September 2010
Players Stats since 2002
Hi Ecky and thanks for your recent updates/input on here.
Just wanted to flag to you that one area we struggle with is info for players post 2002. Up until then we can lift the stats that are in the POTB. I will try and catch you at football one day to have a chat about the best way to tackle this.
Ranga 05:18, 1 September 2010 (UTC)
Well luckily I have everything complete and checked from 2003 up until last weekend :) Who played in every match and all their stats (15+ categories) from every match for both League and Reserves (just a few Reserves games from 03 and 04 where the game by game stats are missing) I can easily run queries that summarise this info. For example it took me 30 secs to copy paste this here
League games, goals and behinds from 2003-2010 Name Games Goals Behinds Panozzo, Luke 145 55 56 Mules, Ben 142 23 12 Cranston, Trevor 134 17 10 Backwell, Brett 131 105 84 Sherwood, Paul 113 4 7 Allen, Ty 103 28 21 Kirkby, Ruory 98 147 64 Ruwoldt, Mark 97 78 76 Duldig, Matthew 94 163 100 Fisher, Adam 94 43 44 Moore, Ben 87 48 27 Kane, Ben 86 38 30 Kirk, Daniel 76 31 22 Hinge, John 75 32 37 Murphy, Byron 74 36 25 McConnell, Justin 73 160 94 Rudolph, Sam 64 11 7 Neely, Billy 58 19 26 Block, Lucas 58 15 25 Willoughby, Josh 56 44 27 Grima, Todd 55 141 62 Culpitt, Heath 55 51 43 Mitchell, David 54 85 60 Smith, Jeff 52 36 19 Bode, Matthew 51 60 34 Sellar, James 49 47 33 Statham, Craig 49 7 8 Cook, Sudjai 48 46 44 Button, Lachlan 40 8 6 Mills, Wayde 40 3 1 Holmes, Tom 39 24 13 Rogers, Aaron 35 37 22 Raidis, Damien 35 5 1 Horan, Jack 33 8 10 Adlington, Paul 33 4 5 Kane, Chris 32 11 9 Miller, James 31 5 5 Gibbs, Bryce 29 24 13 Douglas, Richard 25 43 22 Logan, Tom 25 41 27 Allison, Paul 25 28 16 Meyer, Daniel 25 15 13 Willits, Ryan 25 10 5 McEntee, Daniel 25 9 5 Vlatko, Jamie 24 23 11 Manfield, Matthew 23 10 12 Sugars, Brad 23 1 1 Salopek, Steven 22 28 18 Lally, Angus 22 10 8 Schuback, Jacob 21 32 20 Golding, Matthew 20 19 13 Nicholas, Simon 20 7 5 Butcher, Troy 20 5 8 Mahoney, Josh 19 27 11 Reavill, Matthew 19 22 13 Tenace, Kane 19 15 7 Krueger, Josh 18 8 6 Robinson, Craig 18 6 4 Griffiths, Michael 17 3 3 Kellock, Jarrod 17 2 3 Hall, Chris 15 8 9 Grima, Alex 14 20 23 Smith, Brad 14 11 9 Carr, Josh 14 8 3 Andrews, Rowan 14 1 0 Burdett, Marcus 14 0 0 Ah Mat, Ben 13 9 9 Brockman, Leigh 13 2 0 Woods, Nathan 12 17 4 Graham, Matthew 12 15 8 Koster, Kym 12 1 2 Bradley, Andrew 12 1 0 Parker, Aidan 12 0 0 Raidis, Michael 11 6 2 Bell, Nathan 11 4 4 Sundqvist, Jarrad 10 6 2 Liebelt, Michael 10 5 1 Morris, Carl 10 2 0 O'Grady, Richard 9 7 1 Tasborski, Craig 8 16 4 McGregor, Lachlan 8 4 8 Yeomans, Bradley 8 4 2 Higgins, Brett 8 3 4 Reavill, Daniel 7 10 5 Fosdike, Jack 7 6 9 Plant, Robert 7 4 5 Guilhaus, Sebastian 7 1 0 Herbert, Lucas 6 2 1 Bennett, Phil 6 2 1 Boak, Travis 6 2 0 Pearce, Josh 6 0 3 Snook, Shannon 5 5 5 Greenwood, Malcolm 5 0 1 Hardwick, Damien 5 0 0 Smyth, Ryan 4 7 3 Lewis, Scott 4 2 1 Vlatko, Jon 4 1 0 Doswell, Brett 4 1 0 Saunders, Lee 3 1 1 Day, Aaron 3 1 0 Cook, Adam 3 0 2 Cantwell, Sean 3 0 0 Milne, Jeremy 2 2 1 Clarke, Matthew 2 2 0 Scott-Collings, Daniel 2 1 1 Austin, Mark 2 1 0 Polley, Michael 2 1 0 Gamble, Ryan 2 1 0 Stephens, Brad 2 0 4 Shaw, Sam 2 0 1 Harkness, Tim 2 0 0 Saunders, Rick 2 0 0 Cornes, Chad 2 0 0 Yeomans, David 2 0 0 Joraslafsky, Matthew 2 0 0 Treloar, Tom 2 0 0 Hare, Michael 1 4 0 Hitchcock, Cameron 1 1 2 Trembath, Josh 1 1 1 Armfield, Darcy 1 0 3 Norman, Greg 1 0 2 McGinty, Warrick 1 0 0 Clayfield, Drew 1 0 0 Redden, Thomas 1 0 0 MacFarlane, Peter 1 0 0
Ecky 05:25, 1 September 2010 (UTC)
- OK, so when for example we have some like Golding who played across the period,the POTB says he has 76 games and 18 goals, but obviously that stops at 2002. So if I add your figures above that (20 games, 19 goals) I would have his career tally? Plus of course we would like to have the last year he played (2004?) and the Bio data like date of birth and height/weight.
- Oh and the cut'n'paste table thingo is at: http://excel2wiki.net/index.php .. .simply copy and paste from your spreadsheet, generate the code, copy that into the wiki where you are editing and BAM its done.
- Ranga 05:55, 1 September 2010 (UTC)
Yep, if you add the pre and post 2003 totals together they should be right (assuming POTB is right). And yes, I'll use that cut and paste thing next time! Ecky 06:36, 1 September 2010 (UTC)
