Raw data in spreadsheet form

[Cerpin Taxt]

Hey guys,
I'm going to try a few things with Excel to value players for next year, but I'm limited to the end data that most websites provide. To do what I want, I need every player's score for every game. If someone can direct me to this, I'd greatly appreciate it (and will send you a complete copy when I've finished what I'm after).

I should have a "ranking" of players from best to worst, considering their 2008 average and variability, previous years games played, and a value of which discrete group I think they belong to.

 

[Benno_900]

Not sure what you want but you try FanFooty?

 

[Colin D'Cops]

Fanfooty would be the best place buddy.

 

[Cerpin Taxt]

Fanfooty gives the information I want, but not in a format that's manageable. I know some people have this (pretty sure it's what's used to update FFgenie).

 

[Virgil]

Fanfooty gives the information I want, but not in a format that's manageable. I know some people have this (pretty sure it's what's used to update FFgenie).

Something like this (click a player, then click the 'games' tab, has a list of all stats for every player every game)?

http://www.footywire.com/afl/footy/ft_players.

 

[Cerpin Taxt]

Something like this: http://www.fanfooty.com.au/players/year.php?firstname=Nathan&surname=van Berlo&year=2008

Except in Excel form.

Alternatively, if there is a site that shows the standard deviation of each player, that is all I need!

 

[Virgil]

Something like this: http://www.fanfooty.com.au/players/year.php?firstname=Nathan&surname=van Berlo&year=2008

Except in Excel form.

Alternatively, if there is a site that shows the standard deviation of each player, that is all I need!

I don't understand those stats at all. Does that say he laid 16.9 tackles for the year?

 

[Cerpin Taxt]

That's the FanFooty scoring system. I only need the DT column.

Doing it manually so far, my first three rankings are:

C.Cornes: 1.21
Ablett: 1.045
Bartel: 0.978

I'm trying make the function indicate what the true value of these players could be for 2009. So by this method Cornes has an average of 103, Bartel 110, Ablett 116. I'm happy with that.

 

[SkankDanker]

That's the FanFooty scoring system. I only need the DT column.

Doing it manually so far, my first three rankings are:

C.Cornes: 1.21
Ablett: 1.045
Bartel: 0.978

I'm trying make the function indicate what the true value of these players could be for 2009. So by this method Cornes has an average of 103, Bartel 110, Ablett 116. I'm happy with that.

Depends how much time you want to set aside. I have penicilled in half a day to grab stats form the AFL site. Takes for ever but you just cut and paste to your spreadsheet and calc the DT score. Easy but time consuming.

I used to do it every round progressively but the live scoring has made me lazy.

Not sure what whizz bang formula you have concocted for the rankings....

 

[Colin D'Cops]

Fanfooty gives the information I want, but not in a format that's manageable. I know some people have this (pretty sure it's what's used to update FFgenie).

Oh ok, sorry I couldn't help you out there bud. Maybe try PMing grimlock, I'm pretty sure he is the creator of the ffgenie, and may provide you with some answers you require.

 

[Budgie63]

Oh ok, sorry I couldn't help you out there bud. Maybe try PMing grimlock, I'm pretty sure he is the creator of the ffgenie, and may provide you with some answers you require.

FFgenie is the way to go. Just select all the players, CNTL C and then paste into Excel.

 

[m0nty]

Tell me how you want it and I'll put a file up somewhere.

 

[catsdynasty]

Yeah just read the thread I think FFgenie's the way to go sorry if repetitive just trying to help.

 

[Cerpin Taxt]

Tell me how you want it and I'll put a file up somewhere.

Awesome m0nty.

I'm thinking a row for each player, and a column for each round.

 

[grimlock]

The FFGenie files (http://drop.io/ffgenie) are in CSV format, meaning it's loadable into Excel. Only problem is the names don't come up, I use an ID, you will have to match them up.

But if Standard dev. is all you need, that's a column in FFgenie.

 

[Cerpin Taxt]

The FFGenie files (http://drop.io/ffgenie) are in CSV format, meaning it's loadable into Excel. Only problem is the names don't come up, I use an ID, you will have to match them up.

But if Standard dev. is all you need, that's a column in FFgenie.

This is exactly what I'm after. I'll go through and get the player names I'm after. Thanks a tonne, hopefully I'll come back with something useful now.

 

[grimlock]

As someone said earlier, you can use select all (ctrl A) in FFgenie, copy (ctrl C) and paste into excel and the columns will fall into place.

 

[brent-83]

Tell me how you want it and I'll put a file up somewhere.

How hard would it be for you to provide a file that indicated each players scores or averages against each team for the last two years?

Seriously thinking of using this as a basis of who to pick. i.e Amount of times he plays high / low scoring teams and when in the year he plays them.