• About Us
  • Meet the Team
  • Write for Us
  • Join Discord
Passion for Football Manager - Wonderkids, Guides, Tactics & Downloads

Passion4FM

Master Football Manager | FM20 Wonderkids, Guides, Tactics & Downloads

  • FM21
  • FM20
  • Wonderkids
  • Tactics Talk
  • Guides
  • Resources
Home » Football Manager Downloads & Resources » Player Attribute Analysis Spreadsheet by TheFFM

Player Attribute Analysis Spreadsheet by TheFFM

Written by Espen on December 16, 2019
Last Updated June 5, 2020

Tweet0Share0Pin0
FM20 player attribute analysis spreadsheet

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.

player role attribute analysis positions

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.

player role attribute analysis top 3

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:

  1. Your Documents\Sports Interactive\Football Manager 2020\Views
  2. Open Football Manager 2020
  3. Click Squad > Import View..
  4. Load FFMAnalysis 2.0

fm20 leeds squad player attributes

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:

NB! Please follow the instructions within the readme installation guide to ensure you’ve completed the steps in the correct order. We won’t do support or help you solve problems that may arise with this. Instead we recommend to follow the installation guide to the point and contact the Female Football Manager via her website or Twitter page. Links can be found in Credits.

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.

DOWNLOAD
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

Tweet0Share0Pin0

Football Manager Downloads & Resources FM2020 Player Analysis Player Attributes Player Roles spreadsheet Squad Analysis

Written by Espen

Owner of Passion4FM since 2012. Football Manager content creator with a special love for tactics, wonderkids and player development. Also passionate about cooking and running. FC Barcelona and Tottenham supporter for over 20 years.
Website: https://www.passion4fm.com/

More Posts Like This...

Football Manager 2021 English Lower Leagues database
FM21 English Lower Leagues Level 11 Database
Football Manager 2021 Barcelona Tiki-Taka Tactics
Barcelona Tiki-Taka Tactics; Emulating Pep Guardiolas Positional Play in Football Manager 2021
FM21 United States lower league database
FM21 United States Lower League Database Feat. Promotion/Relegation to Level 9

Primary Sidebar

Passion4FM’s Top Articles

using loans to give young players match experience

Using Loans to Give Young Players Match Experience | FM21 Youth Development Guide

Football Manager Youth Development Guide; 11 Reasons Why your players wont develop

11 Reasons Why Your Players Won’t Develop in Football Manager

Playing out from the back tactical variations in Football Manager

Playing Out From the Back in Football Manager

how to find best wonderkids in Football Manager

How to Find the Best Hidden Gems: Wonderkids & Newgens

Expected goals model in Football Manager 2021

An Insight to Expected Goals Model (xG) in Football Manager 2021

Football Manager 2021 Barcelona Tiki-Taka Tactics

Barcelona Tiki-Taka Tactics; Emulating Pep Guardiolas Positional Play in Football Manager 2021

Custard Prophets Football Manager Creator Showcase

FM Essentials

  • FM21 Wonderkids
  • FM21 Best Young Talents U16
  • Real Names Fix Files
  • Backroom Staff Search Filter
  • Custom Views Megapack
  • FM21 Transfer Budgets
  • FM21 Best Free Agents
  • FM21 Best Ass.Man
  • Training Schedules Megapack
  • How To find The Best Coaches
  • How To find The Best Hidden Gems

Footer

Passion4FM - Master Football Manager 2019
  • About Us
  • Meet the Team
    • Join Team Passion4FM
  • Contact Us
  • Write for Us
  • Author Resources (Writers Only)
  • Login
  • Join Discord

Guides

  • Tactics Guides
  • Scouting
  • Training Guides
  • Finances
  • Tutorials & Tips
  • Troubleshooting Football Manager

Clubs & Leagues

  • Club Recommendations
  • Team Guides

Players & Staff

  • Wonderkids & Talents
  • Players | Recommendations & Reports
  • Player Reviews
  • Staff Roles & Recommendations

Downloads

  • Databases & Transfer Updates
  • Tactics
  • Shortlists & Filters

Latest Posts

  • FM21 English Lower Leagues Level 11 Database
  • Barcelona Tiki-Taka Tactics; Emulating Pep Guardiolas Positional Play in Football Manager 2021
  • FM21 United States Lower League Database Feat. Promotion/Relegation to Level 9
  • Using Loans to Give Young Players Match Experience | FM21 Youth Development Guide
  • 11 Reasons Why Your Players Won’t Develop in Football Manager

Football Manager, the Sports Interactive logo and generated in-game images are © Sports Interactive.

  • Home
  • Privacy Policy
  • Cookie Policy
  • Disclaimer
  • Archive
  • Sitemap
  • Partners
  • team Passion4FM
  • Log In
Copyright © 2021 • Passion4FM Media • All Rights Reserved
BACK TO TOP