Subject: Sokker player list

Hello :)

I put here a series of excel files where you can find a list of all players of sokker. Cliek on the following link to open the page

http://bit.ly/2voIe2U

Now what you need is to know your country ID. You can find it here looking on the number inside the square brackets near the national team that you're interested to. For instance, Italy is 10. Then, download the file that has got the name that include that number. Italian players, for instance, are included into the file 10-29.xlsx.
Download and open the file with excel. I've prepared the file ready to use for NT coaches and U21 coaches that are looking for players that are not in their national team database but that could be useful. You have only to click on the downward arrow near country_ID on the top left side of the spreadsheet and select your country ID. U21 coach has got to do the same on the column "AGE" in the top middle side and select all the numbers under 22.

Thats all! I have to make a big thanks to Imann that develop a software that creates the database from which I've extracted these lists and prepared the spreadsheet.

Hope that could be useful for all.

Regards
(edited)
(edited)
(edited)

Thank you

great job! :)

+1

You're welcome :) Just a little disclaimer... the files are stored on my personal home NAS, rarely could be turned off for many reasons. If the link is offline, please wait a little bit, if it's online for a long time, for instance, one day, write to me. Anyway I don't expect an intensive use of these file, once you download, you are ok.
(edited)

Any chance to add spaces in the excel file after the url of the players? :)
Makes going to the player and sending a mail to the owner so much easier :)

this is great!
I was happy and sad to see that, I didn't miss any player in my country with a top 50 value U21 age.
It is good that I did my job great, but bad, that I couldn't find any new amazing player ://
Is it programmed to refresh time to time?
One more time, great job! For coaches with huge player database like Romania or Poland this is just unbelievable :)

I can do it sometimes, I don't think that it should be useful more than one scan every season

Any chance to add spaces in the excel file after the url of the players? :)
Makes going to the player and sending a mail to the owner so much easier :)

I can try it but how can you take advantage from one space after the player link?

Thanks for sharing this dataset! I will probably play around with that in python. For starters please appreciate the beautiful shape of the BMI-distribution



Also, here's a plot for players younger than 40, value more than 10 000 $ and Teamwork greater than 6 (values chosen to represent players, that still play actively on a decent level)




The shape of the form graph looks interesting and seems to confirm the tendency towards extreme values (0 and 18). However the censored dataset might not represent active players yet.

because then it becomes an anctual link you can click :)

nicee

Wow what an awesome tool. Imagine how good this would have been when sokker was at it's best.

Still, very useful, especially for small teams who even one extra player missed, could make a huge difference to their NT or U21 team

and still serves as a parameter to evaluate how much your player is in relation to the others of the same generation.

nice job, ThankU!

Thank you all :)

I've made a little update. I've converted the excel file into a .ods file (open document spreadsheet) in order that the files could be opened with free open source software, as open office or libre office. I've modified the link.

Any chance to add spaces in the excel file after the url of the players? :)

I tried to do it but it's an auto complete feature, if I try to put a space after the link on csv file, excel will import it without any link format.


Going forward, I appreciate the analysis of MatzeG. Very interesting. It's clear that the form is not random, otherwise the graph should have a shape of a horizontal line

now that player's age and salaries are updated, can you please run an update on your spreadsheet?

much appreciated!