In the previous article in what might become an entire series, I described how you could use a customised squad view FMF-file and an Excel sheet to generate graphics that showed you how many minutes a player had contributed to a campaign as well as his age.
The article included a comprehensive guide on how to install the FMF-file, extract the data and import them into Excel, as well as a brief example on how to interpret the graphic. If you missed the previous article, don’t worry, I included a link below.
This time, I have gone for a file that shows you the Scoring Points for each player and the Scoring Points per 90 minutes. A player’s Scoring Points is the sum of the player’s goals and assists. I nicked this idea from hockey to show the offensive contribution of a player. The end result looks like this
To start off, you need two files for this to work.
- The Excel file; to actually create the graphic;
- The squad view; to extract the raw data.
For your convenience, I have zipped both files into a single download (Excel). You can download this file here. These files are free. I still feel obliged to add that bit, as it’s apparently not done to use Patreon or any other means to gain support for your content.
Using them means following the same steps as with the other file. I will not go into great detail this time, instead just listing the steps.
- Import the FMF view file into FM;
- Print the data from the FMF view file to a webpage;
- Open the webpage;
- Copy the data;
- Open Excel;
- Paste the data;
- Tidy up your graphic if needed;
- Sort out the aesthetics where needed;
- Screenshot or export the graphic.
Interpreting the data is another beast entirely. I fully understand that Scoring Points alone are a very simplistic way to determine the offensive value of a player but it is a decent start and can be used to weed out players worth scouting or players who are underperforming. In other worths, it has indicative value.
The graphics above are from two seasons ago, in my save with Khabarovsk. It is clear who my main offensive outlets are. Arkady Spirin has been instrumental to our success, contributing 44 points to the cause. Our shadow strikers Sasha and Lobov did well enough. We can also see that our right flank with Eze and Smirnov has been underwhelming compared to Spirin on the left.
This indicated some sort of problem on the right flank. Either the players were not good enough or there was something in the interaction between the roles in the tactic that was not working as I wanted it.
The scoring points per 90 minutes graphic also gave me a heads up that perhaps African wunderkind Magique Konan was ready for more playing time in the coming seasons. While he only contributed five points in fifteen appearances, he was mostly used as a substitute. When his contributions are compared to the number of minutes he played, Konan contributed 1,4 scoring points per 90 minutes.
Now again, these are far from complete offensive profiles of a specific player but they are indicative of certain patterns. Either certain problems are highlighted or opportunities are identified. In theory, you could use these systems to scout interesting players as well, if you scout certain teams/leagues enough to get a full read-out of their statistics.