27 replies to this topic

[pandamonk]

If you've ever seen my posts, you will realise how much of a stats geek I am. Anyway, I've been gradually building a couple of databases of footballers eligible for the Scottish national squad. They're FAR from complete, but I thought I'd post them here for everyone's benefit when it comes to team selections, etc. I'm also allowing everyone to edit them so they can be expanded and updated.

This is the database for general players (my favoured players are darker)

and this is the database for scoring rates (for players with 15% and above)

Club stats are from soccerbase.com and international stats from wikipedia if you're going to contribute to editing/updating.


Edit 25/05/2011:

I've just spent a few hours merging and updating my two databases.
You can find it here.

[craig]

I have made this topic a sticky

[jaybee1978]

Nice one Panda.

[PaulBand]

I'd happily help out and add to this

[?apester]

pandamonk said:

If you've ever seen my posts, you will realise how much of a stats geek I am. Anyway, I've been gradually building a couple of databases of footballers eligible for the Scottish national squad. They're FAR from complete, but I thought I'd post them here for everyone's benefit when it comes to team selections, etc. I'm also allowing everyone to edit them so they can be expanded and updated.

This is the database for general players (my favoured players are darker)

and this is the database for scoring rates (for players with 15% and above)

Club stats are from soccerbase.com and international stats from wikipedia if you're going to contribute to editing/updating.

Does that mean you prefer your favourite players to have a nice tan Panda

[pandamonk]

?apester said:

pandamonk said:

If you've ever seen my posts, you will realise how much of a stats geek I am. Anyway, I've been gradually building a couple of databases of footballers eligible for the Scottish national squad. They're FAR from complete, but I thought I'd post them here for everyone's benefit when it comes to team selections, etc. I'm also allowing everyone to edit them so they can be expanded and updated.

This is the database for general players (my favoured players are darker)

and this is the database for scoring rates (for players with 15% and above)

Club stats are from soccerbase.com and international stats from wikipedia if you're going to contribute to editing/updating.

Does that mean you prefer your favourite players to have a nice tan Panda

Haha, nah I haven't even included Iwelumo and Miller's tan is fake anyway.

[jaybee1978]

Why is he not included?

[Oisín]

'cause he's shite ?

[pandamonk]

Oisín said:

jaybee1978 said:

Why is he not included?

'cause he's shite ?

Aye pretty much :P He's coming up 33 and has a 24.2% scoring rate. He's not the worst player available, but he's not gonna get any better. I think 30-32 is the maximum age for a striker to be considered. Generally the only way is down after that. Kenny Miller is just on the brink, in my opinion. The only reason he hasn't been replaced is that no-one has really shone through yet and he's had a good season.

[jaybee1978]

If you are creating a database of Scottish players it should surely include those who are capped and still playing?

[pandamonk]

jaybee1978 said:

If you are creating a database of Scottish players it should surely include those who are capped and still playing?

It was a database for myself so I could make a more informed decision on team selections etc. I wouldn't pick him to play and already know enough about him to know why. My database. My rules :P

Feel free to add him if you'd like though ;)

[jaybee1978]

I can't see it on my phone for some reason.

I will need to wait till I'm on laptop or pc.

[pandamonk]

I've just spent a few hours merging and updating my two databases.
You can find it here.

[jaybee1978]

Other players for list are David Marshall, Ryan Jack, Fraser Fyvie, Scott Allan and Stuart Armstrong.

[pandamonk]

jaybee1978 said:

Other players for list are David Marshall, Ryan Jack, Fraser Fyvie, Scott Allan and Stuart Armstrong.

Added. I'll update all the stats and look for more players soon.

[jaybee1978]

If I think of any more I will let you know.

[Elchappy]

Good work Panda lad. Nae telly in your hoose?

[pandamonk]

Elchappy said:

Good work Panda lad. Nae telly in your hoose?

Telly's boring, spreadsheets are where it's at :roll: haha

[pandamonk]

I've updated the database so all the teams and stats should now be correct. You can see this database here. Players in black would be my first choice, in dark grey 2nd choice, light grey 3rd choice/under 23, and light blue 4th choice/under 21. Players with yellow background are players yet to be capped who I think deserve a chance soon.

[jaybee1978]

Nice one Panda, any new players been added?