

Do you find it hard to purchase the right player for your playing style, or find it difficult to approach squad analysis to learn which players are best suited for a particular role?
Thanks to The Female Football Manager aka TheFFM we would like to recommend a highly beneficial asset when assessing player development, squad depth and player role suitability.
Today we would like to turn your attention to the Player attribute analysis spreadsheet by TheFFM, which helps you analyze your squad and its players.
The player attributes analysis spreadsheet is updated for Football Manager 2020 and gives you an percentage value of a players most suited player role and duty. This tool is very easy to use and will help you in the long term planning of your squad as well, by giving you an insight to weaknesses within your squad, either for specific positions or roles which is essential for your tactic, but also the level of player attributes in a certain area of the game (e.g. technical abilities, teamwork or tactically skills).
About the Spreadsheet & How to Use it
Imagine you inherit a squad with 50 plus players (first team players and reserves) in additional to youth players. The time it would take to get a complete overview of the players; their strength and weaknesses in additional to their suitability for the player roles and duties for your tactic would take long. It would not only require lots of work to browse through your squad looking at all the individual players.
Thankfully we got Football Manager ‘geeks’ in the community which takes everything a step further, not only helping themselves to save time but also everyone else who loves Football Manager, by making their work publicly available.
The player attribute analysis spreadsheet will help you analyze your squad and its players in a quick and easy way.
The spreadsheet contains 3 different major categories, the base and overall view, an option to assess each position (from GK to strikers) and a top 3 page.
POSITIONS
If we look closer at the positions, you’ll get a complete overview of all the different player roles and duties within that strata, either it’s player roles in the AM strata or defensive positions (centre backs and fullbacks). Each positional area has its own sheet, which is broken down further into the relevant roles. Every squad player is given rating based on how suitable they are for that role. Highlighted in yellow are the top 3 players.
OVERALL
The overall view gives you an entire assessment of the players percentage suitability for all the roles in FM20. It let you discover whether or not Mohamed Salah is most suited for the inverted winger role or inside forward, and for which duty; attacking or support.
It can be looked as an additional way to view player role suitability. This is easier to view if you’re wanting a glance at where a certain player is most suitable. The yellow cell can be edited to any percentage based on your required levels and, in turn, any matching ratings will be highlighted in green.
To the right of the yellow cell, this row shows how many of your squad have over your chosen percentage so you can see where you have the best depth for that role. The column directly below the yellow cell shows how versatile a particular player is and how many roles, based on your percentage, they could comfortably play or be retrained in.
TOP 3
The final sheet gives you an ‘at a glance’ view of the top 3 players for each role, separated into sections based on the positional areas.
The top 3 function is a very valuable page addressing something similar to the squad depth report we’ve been accustomed to in Football Manager. Here you’ll get an insight to the top 3 players within each position and their most suited player roles and duties. Pressing the + and – signs will open and close the sections, ensuring you’re not overwhelmed with data. For some, this page is highly valuable when addressing long term squad planning.
Personally, I’ve found this tool highly valuable in order to spot the best players in a position and role. I feel you’ll get everything you need for a more successful campaign.
Useful Tips
Some useful tips is to either create a spreadsheet for each of your squads; first team, reserves and youth side which let’s you get an insight to the best players within the squads or simply filter the view by showing all the players at the club by ticking First Team, Reserves and Under-18, before printing the page and transferring the data over to your excel sheet.
How to Install
Zipped together in the download, you’ll find 2 files; the excel spreadsheet and a custom view. The FFM Analysis squad view is used to gather the data of the players (their attributes, natural position and preferred foot).
To get the custom view imported into Football Manager 2020 make sure you copy the file FFMAnalysis 1.5.fmf to:
Your Documents\Sports Interactive\Football Manager 2020\Views
- Open Football Manager 2020
- Click Squad > Import View..
- Load FFMAnalysis 2.0
Then open the excel spreadsheet. Once opened, you can go back to your FM squad and click: CTRL + P
By doing so you’ll be able to save a print of the page. Select print as Web Page which saves a HTML file on your computer. Remember the location of this file and open it.
Copy the content from it to the spreadsheet by highlighting all the data (except the top heading of attributes and SIGames link at the bottom) then press CTRL + C.
Return to the FFMAttributeAnalysis spreadsheet and select cell A3. Press CTRL + Alt + P, then select the ‘Values’ option.
Voila! All the data is transferred over and the file will look like this:
For further screenshots of how this work, please check out the FFM website.
Change log
v2.0
– DNA Analysis NEW!
– NEW Player Analysis
– Squad Notes
v1.5
– Updated formulas for more accurate ratings.
Credits
Thanks to The Female Football Manager for giving us permission to re-distribute this amazing work to our community.
Website: https://theffm.co.uk
Twitter: TheFFM