I wrote this article last year on something at the time I called The Football Philosophy Index, while playing FM19. It was originally on my site FMStag.com and was picked up by a couple of community sites. Ridiculous title aside, I thought I’d bring it back with some updated advice. I know we all have our different ways of doing this, but this is how I export FM attribute data to Excel in order to drive immersion in my saves, and ultimately be better at the game.
The second advantage is admittedly unlikely. I’ve always been unashamedly bang average. A bit mid table. A tad two and a half stars. Basically Danny Drinkwater.
The incredible depth of football analysis available nowadays and the rise of brilliant content like Tifo Football’s WhiteboardFootball® Tactics Explained series, led me to consider adopting a very specific footballing philosophy and tactical strategy, depending on which team I managed in a save. In even more detail than usual.
Could it be Sarriball? Simeone’s aggressive counter? Tiki taka? The idea of choosing my own philosophy and sticking to it when considering who to buy and who to sell also increased my fixation with multiple saves and therefore their longevity. I think that nothing is more satisfying than building a legacy at a football club with a trademark tactical style.
Now that Football Manager includes these terms of reference and some neat descriptions, I thought there must be a way to get a clearer picture of just how well your players or targets would fit into your system.
So my Football Philosophy Index was born.
FYI – Any FM or Excel screenshots will open up full size if you click on them.
What is it?
Those who are not avid FM fans have often dubbed it ‘spreadsheet manager,’ an unkind nod to the vast amount of attributes and statistics in the game.
It gave me a thought though, which in itself is a dangerous event. What if FM allowed me to harness the data in a way that helped me better analyse my current squad and identify transfer targets to fit my system?
For the rest of this article and my example Football Philosophy Index, I’ll refer to my save as Catania in Serie C in Italy as an example.
Tactically, Italy is historically well known for its narrow, defensively rigid Catenaccio systems. What I wanted to do though, is to adopt this defensively solid and narrow concept, but with the Pep-esque philosophy of ‘take the ball, pass the ball,’ so I thought I’d try it.
Having picked a bold 5-2-3 (or is it 4-1-2-3? Or even 2-3-2-2-1? Who really knows?!), I set about defining the tactic in closer detail, before moving on to look at personnel. Will it work? If it doesn’t, I’ll blame VAR. Or the match engine. (/s)
The idea of this system is to remain very central and compact on the pitch, valuing keeping the ball from the opposition at all costs.
All four of the wide players cut inside to support the centre of the park. When the wingbacks cut inside to support the central midfield, the two Mezzalas can push forward to become a ‘front five’ with the inside forwards and number 9. The half-back becomes a third centre half and you have an even split of five players playing in lovely little triangles at both ends of the pitch. That’s the idea anyway.
What about me?
The next part is entirely down to your system and which attributes you feel would best fit what you are tactically trying to achieve. For me, I identified that the most important elements of offensive and defensive play in my system would be:
Offensive = First touch, passing, agility, balance, anticipation, composure, decisions, vision
Defensive = Strength, jumping, marking, tackling, first touch, passing, anticipation, composure, decisions, positioning
These attributes form the basis of my Football Philosophy Index, for this team.
If my forward players (the two Mezzalas, both Inside Forwards and the lone striker) can play a short passing system where technically they can move the ball quickly and accurately (first touch and passing), comfortably and calmly keep the ball, but move it forward when the timing is right (anticipation, composure, decisions, vision) and physically twist and turn in tight spaces given how narrow our system is (agility, balance) then usually eye-catching high attributes for dribbling, work rate, acceleration etc, are secondary to what I really need. How many times have you spent your entire budget on a player with that sweet, sweet 17 pace and 16 finishing, only to find that he’s like a lost dog when you’re not playing a direct, aggressive counter-attacking 442, because he has the tactical awareness of Mamadou Sakho?
The logic for my defensive players (centre-backs, defensive midfielder and the inverted wingbacks) was that if they can primarily be traditionally good defenders (strength, jumping, marking and tackling) then the other attributes that are important for my forward players are key here too. Basically I’d prefer someone with jumping and tackling 12, if it meant they could anticipate situations and play composed short passes into the midfield, over someone with jumping and tackling in the 15+ bracket who is mentally weaker.
The idea is that if my players have a high average value across these key attributes specifically, then they will better fit my philosophy and tactic, therefore performing better and ensuring my team become invincibles and conquer world football. Or I get bored, have a sandwich and start a new save…
How do I make my own Football Philosophy Index?
An underrated feature on FM is the ability to export any page of data into Excel, where anyone with a basic knowledge of spreadsheets can have lots of fun ranking their players and fulfilling their dream of creating their own Football Philosophy Index*.
*Admittedly very few have ever dreamt of this, if anyone.
Firstly, on your squad page, select an attributes view that best displays some of the attributes you consider key to your system. For me, I started with Mental, but your philosophy might be to build a team of tall, strong and quick players, so starting with the Physical attributes view would definitely be quicker.
Then right click on the headings and insert columns for any of the missing key attributes you are looking for, and you are half-way there.
You now have all your lovely and most important attributes on your squad screen. Next, hit the FM button in the top right and Print Screen. Make sure you print as a ‘web page,’ because for some reason, Microsoft Excel loves a good webpage.
It’s a kind of (spreadsheet) magic
Next, open this file in Excel and add new columns to the right of all the rows of attribute numbers, these are where your magic numbers will appear.
For me, I have two columns, one for the ‘Offensive Philosophy Value’ and another for ‘Defensive Philosophy Value.’
As mentioned earlier, what I then need is for a value (out of 20) to appear in these columns telling me just how suitable each player is in terms of how they best fit my system. Bear in mind that this will only analyse the attributes you’ve picked as key. For all the usual fun stuff, like making sure he’s not injury prone or dreads playing big matches (which is the kiss of death on any scout report in my opinion) keep doing it however you like to do it with scouting inside Football Manager.
The next bit will only make sense if you have at least a wee bit of experience using Excel.
For the Offensive Philosophy Value column, you want the sum of the relevant attributes for each player divided by how many of them there are.
So for my offensive philosophy, I decided earlier that first touch, passing, agility, balance, anticipation, composure, decision and vision were key. Remember that? Of course you do, if you’ve made it this far in this article you’ve got a memory for specifics like Mike from Suits.
In the column, I therefore need the following formula.
=SUM(value 1, value 2, value 3, value 4, value 5, value 6, value 7, value 8)/8
This then gives me a value, which is quite literally adding the key offensive attribute values for this player together, dividing them by how many of them there are, and giving me a number out of 20.
If you drag down from the bottom right of this cell to the bottom of your list of players after putting in the first formula, it will calculate this value for all of your players. That is a free Excel life hack you can impress your friends, co-workers, family and pets with.
Repeat for the key defensive attributes and you have two magic values for each player, how best (out of 20) they fit your footballing philosophy.
You can then jazz it up with some Conditional Formatting. I set it so that values 12+ show in yellow but values less than 10 show in bold “sell this useless player” red. A paint colour name I expect to be rejected by Dulux when I email their marketing team with it.
For me, my Catania spreadsheet tells me that other than Andrea Esposito, who has a ‘Defensive Philosophy Value’ of 13.5, I don’t really have any other defensive players that fit my system that well. There are a lot of players with an 11 point something rating, so maybe all is not lost.
What it also tells me is that my main striker Davis Curiale is decent for my system (bang on 12). My other two number 9s (Fran Brodic, 10.5 and Michele Camuti, 6.0) are far from suitable. So this is somewhere I’ll focus on recruiting for, in the upcoming January window.
So now we know how suitable (or not) our current crop of employees are at kicking a bag of air across the grass in a way that makes my virtual, dugout-dwelling alter ego weak at the knees.
The next step is to take this concept and apply it to players that you may wish to buy to replace your team of duds (Michele Camuti, I am looking at you mate).
All you have to do is create the exact same list of attributes you made on your squad screen. On the Player Search screen instead. Due to Football Manager not allowing you to import custom views created on one screen onto another (because reasons), you need to do it manually.
Select an attribute view, right click and add any missing attributes from your outrageously wonderful new football philosophy. Again, once you have your list of potential targets on screen, print screen as web page, open in Excel, add your Philosophy Value column(s) and woosh, you are now analysing the transfer market, with available players ranked from most suitable to most useless, specifically in relation to which attributes you have decided are important to how you wish for your team to play.
For me, as the Catania manager with no money, Samed Yesil and Gaetano Monachello are looking like fine additions to bolster my strike force. Time to get a scout report on both I think and see how best to choose between them.
So now you know
There is no guarantee that players with a higher Football Philosophy Index value are better footballers who will bring you more success. If you love analysing the game, however, to try and find round pins for round holes, are wholeheartedly set in your team in your save playing in a particular fashion, or just love Alt-Tabbing between FM and Excel for hours instead of actually playing the game, this just be something that floats your boat.
Thanks for reading. Let us know how you recruit wisely when you are working towards your very own tactical DNA, or if you have created your own Football Philosophy Index yourself. Tweet us @DictateTheGame or to me @FM_Stag.
If you liked the article you can find some more below, and our podcast on anchor and other platforms.
Also, please join FM Stag and the rest of the team on our new Discord server, open to all!
- Total Football Journeyman: Swiss Army Knife Method to FM Tactics
- From Kingston to Kirkcudbright | PART THREE | Acclimatising Nicely
- Total Football Journeyman: Le Carré Magique
- Recreating Guardiola’s Tactics in FM21
- The Five Channels: Attacking movement on Football Manager