Introduction
Hi everyone! With the recent release of FM24 and the introduction of new statistics in the game, I am releasing the 3rd edition of my Statistics Spreadsheet.
Firstly, I would like to say a big thank you to Zealand, @Rashidi , @GIMN, @_Ben_, @Jack Sarahs, @FMStag and @MattyLewis11 for the inspiration. This whole project wouldn't have come to fruition without all of you.
I have created a spreadsheet which automatically calculates statistics and percentiles for up to 2000 players in a similar style to FBref. And for those who are willing to go the extra mile, I have added a way to have possession-adjusted defensive stats. I will explain how you can do so later.
It is important to note that this spreadsheet is not some sort of hack which will automatically find the best players in each position for you. It is a tool which can be used to help you with player performance analysis or during recruitment to see if a player's numbers fit your playing style or if they are undervalued compared to their output.
Why are percentiles useful?
Looking at football statistics in isolation without a relevant context does not have any useful value. Percentile ranks offer a solution to get a better reflection on how the player's performance level compares to players around the same level and same position. Percentiles range from the 1st to the 99th percentile and they provide a rank for how that specific value (in this case the statistics) compares to the rest of the values in the given data set. E.g a player who is in the 97th percentile for Goals/90 is in the top 3% of players in the data set. Effectively, the higher the percentile rank, the better the player is performing.
Some pointers before using my spreadsheet:
I would advise that you use a large pool of players (this is specifically if you want to use the percentiles) of about the same standard of football and sort them into specific positions - e.g For my Newcastle save, I have chosen my database of players from the Big 5 leagues and I have sorted my positions into Goalkeepers, Centre Backs, Full Backs, Midfielders, Wingers and Strikers
If you want to use this spreadsheet for a smaller, comparative group of players (such as your team), you can use the Raw Data Table in the spreadsheet
I would advise that you use the 2 leagues above and below in reputation of the league you are managing in or if you are managing in one of the Big 5 leagues, you could simply use my filter I will provide later - e.g If I was managing in the Eredivisie I would select Liga Portugal Bwin, FavBet Liha, Tipico, Bundesliga and Spor Toto Super Lig alongside the Eredivise (However, this is only a recommendation you can use my spreadsheet however you please)
I would advise using my spreadsheet during transfer windows as that is when you are most likely to make transfers or at the end of the season as this is before the data resets for the upcoming season
Setting up
Download the zip file from the link: https://www.mediafire.com/file/hwytmyi3xis70e4/FM24_FMSS_Statistics_Spreadsheet_v3.1.zip/file and extract the contents
The FM24 FMSS Player Search View.fmf and the FM24 FMSS Squad View.fmf need to be placed in this location:
The FM24 FMSS Top 5 Leagues Filter.fmf and FM24 FMSS Most Top Leagues Filter.fmf
If the filters and views folders are missing, you can create them
Make sure you import the views and filters to your game
Before using the spreadsheet, it is important that you are using Excel 2021 as some people have had problems with the statistics and player profiles on older versions of Excel.
Extracting The Players
1) If you choose to use the player search function, you must ensure that you have the filter of choice (unless you decide to choose it manually) loaded correctly which a group of positions selected. In this case, I have selected the Top 5 leagues Filter and selected to look at strikers only
2) Select all players by left clicking and dragging it all the way down to the last player. Then scroll all the way up to the top player without deselecting any players.
3) Press CTRL+P on your keyboard and print it as a web page. Save the name as you would like.
4) Go to the location where you saved the extracted players and open the saved web page
5) On the web page, press CTRL+A to select all players and copy this
6) Go to the spreadsheet and paste the selection into cell A1 of Sheet Paste Here (When reusing make sure that you do not clear the header of the table)
7) Go to column AK (Dist/90), select it and press CTRL+H. Enter the 'find what' based on the units that use you for distance (as shown below) and press Replace All. It is very important you do this step
8) Go to column BH (Wage), select it and press CTRL+H. Enter the 'find what' as shown below.
There you have it. You have now extracted all the players into the database and can view the calculated statistics!
For those of you who use languages different to English, it is important to ensure that your thousands and decimal separators are set correctly on Excel as this can cause issues with the spreadsheet
Follow these steps:
1) Click File > Options
2) Go to the Advanced tab and uncheck Use system separators
3) You should set the decimal and thousands separator to match with the ones in your FM23 settings
Raw Data Table
Percentiles Table
Statistics Profile
Player Profile
As far as I am aware the dropdown lists for the Statistics Profile and the Player Profile are searchable for Excel users. However, this may not be the case for users of Libre Office for example.
Filter
Possession Stats:
This is where the fun begins
If you want to understand why having possession-adjusted defensive stats provides a more accurate reflection of a player's defensive contribution, you can read the following articles:
https://www.ladumaanalytics.co.za/2021/02/19/possession-adjusted-stats/#:~:text=Possession-adjusted or PAdj statistics,the value of defensive contributions.
https://dataglossary.wyscout.com/p_adj/
This is the fastest way I have found to extract possession stats out of the game and if you do find a faster method, please do share it in the replies .
1) You will need a cropping tool - for Windows, you can use the snipping tool
2) On FM, go to the screen shown below of the league of choice
3) Use the cropping tool to take a screenshot ONLY including the name and average possession of the team as shown below. Do this for each league you are using. You may have to take multiple screenshots of each league
4) You will need to use an image-to-Excel converter. I recommend using https://www.table-reader.com/image-to-excel as it is reliable and quick, it can merge up to 5 images and it separates the team and possession stats into individual cells. Do not change any settings and add up to 5 images.
5) Download the Excel book and copy the team and possession stats it provides. You should get a result similar to below
6) You are not done yet as my formula does not accept it in the form of percentages. You will need to select column B and press CTRL+H and enter the following below
7) You will get a result similar to as shown below and now you should have possession-adjusted statistics!
I have written a post on how to create data visualisations using Tableau which can be found here - https://community.sigames.com/forums/topic/567013-statistics-spreadsheet-for-those-that-love-moneyball/#comment-14071645
Feel free to share any problems or troubles you have using the spreadsheet. I will try to help you as far as my busy university schedule allows.
Thanks