FM24 Statistics Spreadsheet (For those that love Moneyball)

[Fmplaya]

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. However for statistics such as Possession Lost/90 the lower 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/rtaxuq2x2k1xhjw/FM24_FMSS_Spreadsheet_v2.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

 

 

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.

 

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

 

 

Edited March 13 by Fmplaya

[klaasjan]

does this work without player attribute masking disabled?

[Fmplaya]

5 hours ago, klaasjan said:

does this work without player attribute masking disabled?

The raw data table and the percentiles should work fine, but the scout report and the attribute bars will only work if the exact attribute of the player is visible. So for players that haven't been scouted, the scout report and the attribute bars will not work.

[BL1TZ_GT]

Can I use this with my squad? I've been looking all over for a spreadsheet that I can extract my squad to. I prefer to assess my squad via a spreadsheet to help me know best players for my tactic & players to sell.

[Fmplaya]

9 hours ago, BL1TZ_GT said:

Can I use this with my squad? I've been looking all over for a spreadsheet that I can extract my squad to. I prefer to assess my squad via a spreadsheet to help me know best players for my tactic & players to sell.

Yes, you can. You can do this by using the squad view to extract the players from your squad.

[milenec11]

Is for all positions?

is room to this excel to add custom stats through combination such as xGOT?

[Gene]

Excellent work! I'll put this to good use. 

[Fmplaya]

3 hours ago, milenec11 said:

Is for all positions?

is room to this excel to add custom stats through combination such as xGOT?

Yes, the spreadsheet works for all positions.

Unfortunately, it is not possible as xGOT also takes into account the goalmouth location as well as where the shot has been taken. FM does not have a statistic that measures it.

 

1 hour ago, Gene said:

Excellent work! I'll put this to good use. 

Thank you very much and I hope it is useful to you!

[BL1TZ_GT]

I found the download ;-)

However in Statistics Profile & Player Profile I get the drop down box for the name.

I select the name but no other boxes get filled in. 

[Fmplaya]

2 hours ago, BL1TZ_GT said:

I found the download ;-)

However in Statistics Profile & Player Profile I get the drop down box for the name.

I select the name but no other boxes get filled in. 

Hi, I'm not entirely sure why this is occurring as this works perfectly fine for me. Do you use Excel?

[BL1TZ_GT]

15 hours ago, Fmplaya said:

Hi, I'm not entirely sure why this is occurring as this works perfectly fine for me. Do you use Excel?

Yeah i'm using excel, when I select the name it stays blank. The player picked is my main striker.

Edited December 6, 2023 by BL1TZ_GT

[Fmplaya]

1 hour ago, BL1TZ_GT said:

Yeah i'm using excel, when I select the name it stays blank. The player picked is my main striker.

Can you send me the excel file so I can check it?

[BL1TZ_GT]

6 hours ago, Fmplaya said:

Can you send me the excel file so I can check it?

Yeah no bother. I have sent the original final, also sent the file with my squad pasted into it.

FM24 FMSS Statistics Spreadsheet - With My Squad.zip FM24 FMSS Statistics Spreadsheet.zip

[Fmplaya]

1 hour ago, BL1TZ_GT said:

Yeah no bother. I have sent the original final, also sent the file with my squad pasted into it.

FM24 FMSS Statistics Spreadsheet - With My Squad.zip 4.82 MB · 0 downloads FM24 FMSS Statistics Spreadsheet.zip 4.73 MB · 0 downloads

I have had a look and it works completely fine for me.

 

 

Have you made sure to select the player from the dropdown list instead of just typing their name?

[BL1TZ_GT]

12 hours ago, Fmplaya said:

I have had a look and it works completely fine for me.

 

 

Have you made sure to select the player from the dropdown list instead of just typing their name?

Yeah, I click the drop down arrow, get a bunch of zero's, scroll up to the names click 1 & then blank.

But if works for you so it's something to do with my excel I guess, so I'll figure that out. Thanks for your help though.

[Fmplaya]

39 minutes ago, BL1TZ_GT said:

Yeah, I click the drop down arrow, get a bunch of zero's, scroll up to the names click 1 & then blank.

But if works for you so it's something to do with my excel I guess, so I'll figure that out. Thanks for your help though.

It could also be due to having an older version of Excel? And no problem mate 

[Jacob Palsgaard]

Hi FmPlaya, 

I have really tried to make this spreadsheet work, but I can´t seem to get it right. I have been following your steps, but when I enter the Raw data table the values does not seem right? 

[Fmplaya]

5 minutes ago, Jacob Palsgaard said:

Hi FmPlaya, 

I have really tried to make this spreadsheet work, but I can´t seem to get it right. I have been following your steps, but when I enter the Raw data table the values does not seem right? 

Hi, This could be an issue with your thousands and decimal separators not being the same as the ones used in FM.  The steps below should help.

On 19/11/2023 at 17:07, Fmplaya said:

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 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

 

[Jacob Palsgaard]

Thanks @Fmplaya, that did it

Only thing missing now is that I can´t get any data on player profiles or statistics profile even though I am using the drop down menu with player names. Do you have any clue why ?

And thanks for a really nice tool that adds value to the game!  
 

[BL1TZ_GT]

On 07/12/2023 at 09:36, Fmplaya said:

It could also be due to having an older version of Excel? And no problem mate 

Yeah it was my version. Upgraded from 2016 to 2021 & it now works in 2021. Cheers for fixing it.

[Fmplaya]

1 hour ago, Jacob Palsgaard said:

Thanks @Fmplaya, that did it

Only thing missing now is that I can´t get any data on player profiles or statistics profile even though I am using the drop down menu with player names. Do you have any clue why ?

And thanks for a really nice tool that adds value to the game!  
 

Thank you and no problem! 

That is really weird as @BL1TZ_GT has had the same problem and I tried it with his Excel sheet and had no problems. This could possibly be due to the version of Excel you are using?

[Fmplaya]

1 minute ago, BL1TZ_GT said:

Yeah it was my version. Upgraded from 2016 to 2021 & it now works in 2021. Cheers for fixing it.

Ah, that's brilliant and I'm glad it's working now 

 

@Jacob Palsgaard Looks like you may need to upgrade your version of Excel 

[milenec11]

Despite the fact that I have excel 19 I didn’t manage to work it.

But I would like to suggest some crucial stats that help us to valuation a player those stats are combination of in game stats.

1) Poss Rt = PossWon /PossLost 

is the quality of the player possession 

2) Tackle Quality = Tackles Attempts/ Fouls made 

self explanation yes I tackle but how efficient 

3) Chance Quality = xAss/OPkP

self explanation 

4)GAA(Goals Allowed Avarage ) = (Goals Allowed*90)/Actual playing minutes.

this is more crucial from the SV%  “Goals against average is one of the top indicators of success between the pipes, no matter the level. It’s a very important scouting metric for goalies and is one of the three most important stats there is in goaltending.”

Of course those are only suggestions and perhaps some help to others that want to play with stats according FIFA’s scouting level and knowledge which can extend the games data .

I will to apologize from @Fmplaya for using his work to add this  .

Edited December 8, 2023 by milenec11

[Maxim26]

Hi. I'm a complete newcomer to the topic of moneyball. I have a question. How do I choose a football player for my team? What metrics to look at depending on the role and tactics? Is there any general universal indicator of the player's suitability for the role and how much he will be good there?

[Dr Naysay]

13 hours ago, Maxim26 said:

Hi. I'm a complete newcomer to the topic of moneyball. I have a question. How do I choose a football player for my team? What metrics to look at depending on the role and tactics? Is there any general universal indicator of the player's suitability for the role and how much he will be good there?

It depends on what you're trying to achieve for each role. For instance in previous iterations my two fullbacks were a key part of the attacking phase so I would set up my stats tracking around the attacking elements that I wanted from my fullback. Key passes/90, cross competition%, kms completed per 90(to find players used to covering a lot of ground), dribbles completed per 90 and stuff like that. Then only as a secondary option would I look at defensive stats as a sort of tie breaker. 

My lone striker is the primary goal scorer who plays as a complete forward so I would be looking at strikers who outperformed xg but who were also relatively comfortable as creators and able to dribble effectively. There is no universal indicator because if I wanted a Target man striker who holds the ball up and play other attackers in I would look at a completely different set of stats.

[dzek]

On 08/12/2023 at 13:12, milenec11 said:

2) Tackle Quality = Tackles Attempts/ Fouls made

4)GAA(Goals Allowed Average) = (Goals Allowed*90)/Actual playing minutes.

At the beginning I want to say that most of it is in the game. As far as tackles and the equation you use, I don't think they tell the whole story. "Tackles Won Ratio" is the best stat here compared to "Tackles Attempted per 90 mins".

Also for number 4 can you give me an example? Because usually the "per 90 mins" stats are small and in decimal format, while the playing minutes are in the hundreds or even thousands. So for example if we have a number for the first one e.g. 2,3 GAA/90 and 1000 minutes of playing minutes then the result would be 0,0023.

A more correct formula here would be to do the total goals conceded by the goalkeeper by dividing them by the amount of playing minutes and then multiplying the number by 90.

For example: (80 goals allowed / 2500 playing minutes) * 90 = 2,88 per 90 mins

Edited December 11, 2023 by dzek

[milenec11]

Those formulas do not came by my mind but through scouting books 

the example that you gave above is that a GK have play 27 matches and conceded 80 goals 

so if I calculate 80 goals * 90 minutes the result is 80*90= 7200 if I divide with 2500plying minutes the result is 7200/2500= 2,88

as you can see is the same with your calculation

Edited December 11, 2023 by milenec11

[dzek]

9 minutes ago, milenec11 said:

Those formulas do not came by my mind but through scouting books 

Ρε δεν στο είπα για να μαλώσουμε.

Στο 4 μετά είδα ότι έβαλες πολλαπλασιασμό, δηλαδή "Goals Allowed * 90". Άρα το ίδιο λέμε εδώ. Όσον αφορά τα τάκλιν δεν ξέρω αλλά πιθανόν το κάθε βιβλίο να μετρά διαφορετικά την "επιτυχία" για κάποιο στατιστικό. Εκτός κι αν συμφωνούν όλα σε αυτό.

Edited December 11, 2023 by dzek

[milenec11]

Ρε Έλληνας είσαι ? Χαχαχαχ

στα τάκλιν η αξια εδώ είναι πως ναι μεν κάνω 5 τάκλιν αλλά ποσό αποτελεσματικά είναι δλδ ποσες φορές έκανα την μπάλα δικη μου 

ειναι διαφορετικό από το KEY TCKL γιατί αυτό βάση ορισμού αναφέρετε ποσα τάκλιν έκανα που αν δεν ήταν επιτυχία η κατάληξη του επιθετικού θα ήταν γκολ

[dzek]

6 minutes ago, milenec11 said:

Ρε Έλληνας είσαι ? Χαχαχαχ

στα τάκλιν η αξια εδώ είναι πως ναι μεν κάνω 5 τάκλιν αλλά ποσό αποτελεσματικά είναι δλδ ποσες φορές έκανα την μπάλα δικη μου 

ειναι διαφορετικό από το KEY TCKL γιατί αυτό βάση ορισμού αναφέρετε ποσα τάκλιν έκανα που αν δεν ήταν επιτυχία η κατάληξη του επιθετικού θα ήταν γκολ

Χαχαχ ναι ρε

Σίγουρα υπάρχει η λογική που λες κι εγώ αυτό πιστεύω. Όμως το θέμα είναι πως μετριέται στο παιχνίδι κτλ.

[milenec11]

Μόνο με excel φιλε μου , τα υπόλοιπα με pm γιατί θα προγκιξουν που μιλάμε στην γλωσσα μας 

[Craigoh1]

This is brilliant. I've been wanting to get my toes wet in exporting data from FM and play around in excel and tableau. You have a made a perfect little tool for me to dig straight away. Thanks!

[Fmplaya]

2 hours ago, Craigoh1 said:

This is brilliant. I've been wanting to get my toes wet in exporting data from FM and play around in excel and tableau. You have a made a perfect little tool for me to dig straight away. Thanks!

Thank you very much, I hope you enjoy using it!

[gpassosbh]

Hello @Fmplaya,

I tried to import the data from my save, but I don't know what I do wrong. Can you tell me why Raw Table isn't showing all the data?

Thanks

FM24 FMSS Statistics Spreadsheet.zip

[Fmplaya]

23 hours ago, gpassosbh said:

Hello @Fmplaya,

I tried to import the data from my save, but I don't know what I do wrong. Can you tell me why Raw Table isn't showing all the data?

Thanks

FM24 FMSS Statistics Spreadsheet.zip 4.83 MB · 0 downloads

Hi, the problem is that the minutes column uses a point instead of a comma for the thousands separator.

On 19/11/2023 at 17:07, Fmplaya said:

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

If that doesn't work, you can select the whole column AP and press CTRL + H, and replace the dot with a comma.

[KellettAKill]

Hi! If i want to sort the columns, it doesn't let me because it says it's a locked column. What's the fix for this?

[Fmplaya]

On 12/01/2024 at 21:45, KellettAKill said:

Hi! If i want to sort the columns, it doesn't let me because it says it's a locked column. What's the fix for this?

Hi! Thanks for pointing that out, I hadn't realised I had forgotten to unlock those columns. I have posted a link for the updated version of the spreadsheet which allows you to sort the tables.

https://www.mediafire.com/file/rtaxuq2x2k1xhjw/FM24_FMSS_Spreadsheet_v2.zip/file

Edited January 14 by Fmplaya

[Shaun Howard]

When i do the spreadsheet, for some reason all the per/90 stats are all blacked out and not showing. What is going wrong?

[ceefax the cat]

It'd be really helpful to have a list of season end dates by country for this, so you can look at data from past seasons. It's pretty annoying that FM scrubs all stats at the end of each season and makes it impossible to scout by performance.

Even with a list of season end dates, you're looking at exporting from FM quite a few times each season to get complete data. Madness

Edited January 24 by ceefax the cat

[Fmplaya]

On 23/01/2024 at 20:08, Shaun Howard said:

When i do the spreadsheet, for some reason all the per/90 stats are all blacked out and not showing. What is going wrong?

Are you using the latest version of Excel?

21 hours ago, ceefax the cat said:

It'd be really helpful to have a list of season end dates by country for this, so you can look at data from past seasons. It's pretty annoying that FM scrubs all stats at the end of each season and makes it impossible to scout by performance.

Even with a list of season end dates, you're looking at exporting from FM quite a few times each season to get complete data. Madness

Yeah I completely agree, it is very frustrating having to flick through multiple Excel sheets to keep a record of player data when it can be done by the game.

[elfleo]

Hi everyone, just a quick question, maybe someone can help: When printing the data as a web page, some data are entirely missing on the web page. I have several columns missing entirely that are used in the Excel sheet and therefore the copied data into the Excel sheet do not match at all. If I copy all the data from the web page the Excel sheet has only data until the column "DO", while the spreadsheet ends at column "EZ". And because of that the imported data do not match. Seems like while printing the data as web page some data are missing, although I use the filter and more importantly the "FM24 FM"" Player Search View" view. Any idea maybe?

Edited January 27 by elfleo

[Fmplaya]

16 hours ago, elfleo said:

Hi everyone, just a quick question, maybe someone can help: When printing the data as a web page, some data are entirely missing on the web page. I have several columns missing entirely that are used in the Excel sheet and therefore the copied data into the Excel sheet do not match at all. If I copy all the data from the web page the Excel sheet has only data until the column "DO", while the spreadsheet ends at column "EZ". And because of that the imported data do not match. Seems like while printing the data as web page some data are missing, although I use the filter and more importantly the "FM24 FM"" Player Search View" view. Any idea maybe?

I think the steps below might help you

On 19/11/2023 at 17:07, Fmplaya said:

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.

 

[elfleo]

vor 2 Stunden schrieb Fmplaya:

I think the steps below might help you

 

Hi, thanks for the reply first of all. I appreciate it!  Unfortunately that didnt help. It really seems like the view in the game is, for some reason, not showing all the columns I need to print for the Excel Sheet.  For example my view in the game does not have Columns like "Clearances", "Key Headers", "Blks" and more. Therefore my view is lacking data to print and then to export in Excel. I deleted the view and loaded it again, but unfortunately it had the same result :/ Attached are the las few columns in my view for instance. I attached some Screenshots, maybe it helps to understand what I mean. Anyways, thank you for reply again! Have a great Sunday evening

Edited January 28 by elfleo

[oliverbrowne626]

Hi, great spreadsheet it works great, all the data is filled in perfectly, but the coloring / formatting of the data inst working, so I cant view whether the players are better or worse unless i look through each cell, do you know why this could be ? Thanks. 

[Fmplaya]

18 hours ago, oliverbrowne626 said:

Hi, great spreadsheet it works great, all the data is filled in perfectly, but the coloring / formatting of the data inst working, so I cant view whether the players are better or worse unless i look through each cell, do you know why this could be ? Thanks. 

@oliverbrowne626 Hi, can you send the excel file?

[James8973]

Hey mate. When loading players into the spreadsheet. Is there a maximum number of players before it can't handle it.

Also, have black boxes for almost everyone under line 104. Also from that line player names are "0" Any reason why? Happy to send the file. Only issue I can't attach the file due to its size

[Fmplaya]

On 02/02/2024 at 10:54, James8973 said:

Hey mate. When loading players into the spreadsheet. Is there a maximum number of players before it can't handle it.

Also, have black boxes for almost everyone under line 104. Also from that line player names are "0" Any reason why? Happy to send the file. Only issue I can't attach the file due to its size

Hi, the maximum number of players it can handle is supposed to be 2000. Can you send your Excel file so I can see where the problem is?

[Sortibak]

This happens when I try to import the view, its the same in scouting. Anyone has any idea why?

[Fmplaya]

16 hours ago, Sortibak said:

This happens when I try to import the view, its the same in scouting. Anyone has any idea why?

You have used the incorrect views. You have to use the view FM24 'FMSS Squad View' for the spreadsheet to work.

[Lazija1389]

How do I fix this type of numbers and my average ratings are dates for example 7, july etc.

Edited February 16 by Lazija1389