All
I have seen a number of posts where users have wanted to view stats in a spreadsheet, so i thought i would share my spreadsheet and data for users wanting to see one in action. The data for this game is from October 2013 and I am using a database of 40000 players. The sheet is fairly self explanatory, just select the player from the drop down and the report tab will display their suitability as a % based upon their attributes and the role requirements. You can also get a 'user defined score' based upon the attributes you select (upto 20) for the player.
I use this a rough guide only for assessing players for suitable positions. You still require to do some scouting yourself, this just makes assessing players that much easier (rather than trusting your backroom staff).
This file is a macro enabled excel book. If you dont trust the content, dont download. I am not in the habbit of writing malicious code.
https://drive.google.com/file/d/0B0GMTjaDFH_FLTJDLWk0X0s3SDQ/edit?usp=sharing
If you have any constructive feedback on how to make this better please leave in a comment below. If i get enough interest, i may create a version with all players in the game... This will make the file much larger though.
I have seen a number of posts where users have wanted to view stats in a spreadsheet, so i thought i would share my spreadsheet and data for users wanting to see one in action. The data for this game is from October 2013 and I am using a database of 40000 players. The sheet is fairly self explanatory, just select the player from the drop down and the report tab will display their suitability as a % based upon their attributes and the role requirements. You can also get a 'user defined score' based upon the attributes you select (upto 20) for the player.
I use this a rough guide only for assessing players for suitable positions. You still require to do some scouting yourself, this just makes assessing players that much easier (rather than trusting your backroom staff).
This file is a macro enabled excel book. If you dont trust the content, dont download. I am not in the habbit of writing malicious code.
https://drive.google.com/file/d/0B0GMTjaDFH_FLTJDLWk0X0s3SDQ/edit?usp=sharing
If you have any constructive feedback on how to make this better please leave in a comment below. If i get enough interest, i may create a version with all players in the game... This will make the file much larger though.