Statistics Spreadsheet (For those that love Moneyball)

[Fmplaya]

Introduction

Hi everyone, this is my first contribution to the FM community and I am very proud to introduce my Statistics Spreadsheet for FM22!

First of all, I would to say a big thank you to Zealand, @Rashidi and @Cult of Football Manager 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 (excluding goalkeeper statistics, unfortunately). 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.

First of all, I will provide you with 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 filter them to 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 Centre Backs, Full Backs, Midfielders, Wingers and Strikers
• If you want to use this spreadsheet for a smaller, comparative group of players, 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 the January transfer window or at the end of the season as that is when you are most likely to make transfers - I have provided filters for those managing in the Big 5, however, this is not exclusive to those managing in the big 5 leagues. They can be tweaked to whatever your setup is. Big 5 Leagues Jan 1 FM22. fmfBig 5 Leagues End of Season FM22.fmf

They need to be placed in the following folder:

• Similarly I have made custom views which NEED to be used for the spreadsheet to work - Statistics Shortlist View FM22.fmfStatistics Player Search View FM22.fmfStatistics Squad View FM22.fmf

They need to be placed in this folder:

• You must ensure that the filters and, most importantly, the views have been imported correctly to proceed

 

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. Below I have chosen Strikers

 

1. 

 

2)  Select all players and press CTRL+P on your keyboard and print it as a web page. Save the name as you would like.

 

3) Go to the location where you saved the extracted players and open the saved web page

4) On the web page, press CTRL+A to select all players and copy this

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

6) Go to column AK (Dist/90), select it and press CTRL+H. Enter the find what 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!

 

Raw Data Table

 

Percentiles Table

 

Statistics Profile

 

I have included a name search function which can be accessed by clicking on the downwards arrow next to the name of the player and searching for the player you want to view.

 

I am aware that this search function does not work with Libre Office and I have made a version of the spreadsheet which has a dropdown list, however, the name search function does not work .

 

Player Profile

 

If you do not wish to view this sheet as you don't want to see the attributes, you can simply hide the sheet by right-clicking on the name of the sheet 

 

Possession Stats

 

This is where the fun begins . If you do not wish to use possession-adjusted stats, you can simply leave the table blank, hide the sheet by right-clicking on the name of the sheet and skip this section. 

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

 

 

Feel free to share any mistakes or troubles you have using the spreadsheet. I will try to help you but I am currently busy doing work for school and writing my UCAS application, so please do be patient .

Thanks.

Download File:

FM22 Statistics Spreadsheet .zip

Edited October 30, 2022 by Fmplaya

[ta11zx]

I have read this twice and I still don't understand what this does.

[fc.cadoni]

Nice!

Thank you for sharing @Fmplaya!

[Fmplaya]

On 06/08/2022 at 02:55, ta11zx said:

I have read this twice and I still don't understand what this does.

@ta11zx This spreadsheet uses statistics from the game and creates the following statistics (all per 90 minutes):

• Goals 
• Non-penalty Goals
• Non-penalty xG
• Non-penalty goals - Non-penalty xG - this is a measure of how well the player outperforms his xG and is an indicator of quality finishing
• Shots
• Shots on Target
• Shot on Target Ratio
• Non-penalty Goals per Shot - this is a measure of how often a player scores per shot. A higher value can be a subtle indicator of good finishing
• Non-penalty xG per Shot - this measures the quality of shot the player takes on average. This can be an indicator of quality movement
• Dribbles
• Fouls Won
• Assists
• Goal Contributions (Goals + Assists)
• Pass Attempts
• Passes Completed
• Pass Completion Ratio
• Key Passes - a key pass is the final pass by a teammate which leads to a goal attempt that does not lead to a goal
• Clear Cut Chances Created
• Cross Attempts
• Cross Completion Ratio
• Defensive Actions - this includes Tackles, Interceptions, Headers Won and Clearances 
• Tackles Won
• Interceptions
• Clearances
• Headers Attempted/Aerial Duels Contested
• Headers Won/ Aerial Duels Won
• Headers Won Ratio
• Fouls Committed
• Yellow/Red Cards
• Offsides
• Minutes per Game
• Distance Travelled 

To get a better reflection on how the player compares to players of the same level and same position, I have included percentile ranks. Percentiles range from the 0th to the 100th percentile and they provide a reflection of how a specific value of data compares to a larger pool of data. 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.

Edited August 7, 2022 by Fmplaya

[Fmplaya]

On 06/08/2022 at 06:37, fc.cadoni said:

Nice!

Thank you for sharing @Fmplaya!

@fc.cadoni Your feedback is very much appreciated. Just trying to help out the community!

[Yorki]

Thanks for the inspiration. I didn't know you could export these like this  

I did use it for different purpose - for stars calculation: https://community.sigames.com/forums/topic/567031-coach-calculatorcomparison/

 

[Fmplaya]

9 hours ago, Yorki said:

Thanks for the inspiration. I didn't know you could export these like this  

I did use it for different purpose - for stars calculation: https://community.sigames.com/forums/topic/567031-coach-calculatorcomparison/

 

No problem . Have checked out your work and it looks great. Will use it in my next save!

[Jack Sarahs]

Hi @Fmplaya

 

Thanks for the shout out! Apologies I only just saw this as I don't use my old account anymore.

 

Great thread thanks for putting this together. Everyone has their preferences of exactly what spreadsheets to use and how to use them, but the process is mostly always the same. I highly recommend this type of save for people if you haven't given it a try. 

 

If this type of thing seems too complicated or too difficult to understand but it interests you, always feel free to reach out to people in the community and ask for help if needed. I don't want to speak for Fmplaya, but people generally that put effort into putting these sorts of things together tend to be very willing to help others out if they require it!

[Fmplaya]

3 hours ago, Jack Sarahs said:

Hi @Fmplaya

 

Thanks for the shout out! Apologies I only just saw this as I don't use my old account anymore.

 

Great thread thanks for putting this together. Everyone has their preferences of exactly what spreadsheets to use and how to use them, but the process is mostly always the same. I highly recommend this type of save for people if you haven't given it a try. 

 

If this type of thing seems too complicated or too difficult to understand but it interests you, always feel free to reach out to people in the community and ask for help if needed. I don't want to speak for Fmplaya, but people generally that put effort into putting these sorts of things together tend to be very willing to help others out if they require it!

Hi @Jack Sarahs,

Thanks a lot, I had wondered why you were inactive on your old account and forgot you worked with SI . I have watched your Moneyball series with Barnsley on YouTube and it is fantastic, especially how you navigate transfers and find players to sign. It has been a massive inspiration and very eye-opening.

Moneyball can be very difficult to understand but people in the community like myself are very willing to help others.

[bosque]

Wow, this is incredible. I want to read more about how to use the stats for transfers and analysing players. But this tool looks very helpful. Just a question, is there a way to have Key Passes not from set pieces?

[Fmplaya]

15 hours ago, bosque said:

Wow, this is incredible. I want to read more about how to use the stats for transfers and analysing players. But this tool looks very helpful. Just a question, is there a way to have Key Passes not from set pieces?

@bosqueThank you very much, very much appreciated.

As far as I am concerned there is no set piece stat in the game apart from penalties, so unfortunately there is no way to have key passes without the set pieces.

To read more on using stats for transfers and player analysis, I could easily recommend watching Tifo Football's sensible transfers videos and the Tifo IRL channel. Also, I would recommend following @Rashidi's Palermo save on YouTube and he also has a thread here where he explains his Moneyball strategies https://community.sigames.com/forums/topic/566668-the-art-of-numbers-not-attributes-a-journey-extracting-the-best-out-of-my-players/ , as well as @Jack SarahsBarnsley Save on YouTube https://www.youtube.com/c/TheCultofFM.

Edited August 10, 2022 by Fmplaya

[Paulo191]

Well, now THIS is Moneyball. Great work! I'll surely give it a try.

[Fmplaya]

With the upcoming release of FM23 and the introduction of new statistics in the new game, I have made an update to this spreadsheet. I have attached all the necessary files and the instructions remain the same as the previous version of the spreadsheet. Enjoy! 

Statistics Profile

Player Profile

FMSS Player Search View.fmf FMSS Squad View.fmf FMSS Big 5 Filter.fmf FM23 Statistics Spreadsheet.zip

[allaneh22]

For some reason I'm having the same problem with all spraedsheets.
The names don't appear on the side, even though I pressed CTRL+P correctly

 

Do you know why this happens?

 

[DarJ]

30 minutes ago, allaneh22 said:

For some reason I'm having the same problem with all spraedsheets.
The names don't appear on the side, even though I pressed CTRL+P correctly

 

Do you know why this happens?

 

 

When you select the players make sure you scroll down and up. That might fix it 

[allaneh22]

1 hora atrás, DarJ disse:

When you select the players make sure you scroll down and up. That might fix it 

THX! Worked.

[cmason84]

@Fmplaya you might be interested in the post/spreadsheet that @FMStag and I put together on using player data and player comparisons.

https://fmstag.com/player-comparison-visualiser/

It doesn't have the new data yet, but if I was a betting man, I would imagine that Stag would probably have already thought about and maybe even added in the extra data into his player search screen filters/views.

A FM Old Timer

[Fmplaya]

1 hour ago, cmason84 said:

@Fmplaya you might be interested in the post/spreadsheet that @FMStag and I put together on using player data and player comparisons.

https://fmstag.com/player-comparison-visualiser/

It doesn't have the new data yet, but if I was a betting man, I would imagine that Stag would probably have already thought about and maybe even added in the extra data into his player search screen filters/views.

A FM Old Timer

@cmason84 Your spreadsheet looks great! Once the FM23 version is available, I will definitely be having a look.

[Pepsi91]

I have a problem with number format in Excel spreadsheet as shown in the image below (Average rating, Goals/90,..). When I change the format, those numbers becom tottally different.

Edited October 27, 2022 by Pepsi91

[Fmplaya]

1 hour ago, Pepsi91 said:

I have a problem with number format in Excel spreadsheet as shown in the image below (Average rating, Goals/90,..). When I change the format, those numbers becom tottally different.

Hi @Pepsi91,

What are your FM23 decimal and thousands separator settings?

Before using my spreadsheet:

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 

Let me know if this works

 

[Pepsi91]

It does, thank you very much! Czech use comma as decimal separator, so that was the problem.

[Fmplaya]

1 minute ago, Pepsi91 said:

It does, thank you very much! Czech use comma as decimal separator, so that was the problem.

No problem! 

[ta11zx]

On 07/08/2022 at 13:10, Fmplaya said:

@ta11zx This spreadsheet uses statistics from the game and creates the following statistics (all per 90 minutes):

• Goals 
• Non-penalty Goals
• Non-penalty xG
• Non-penalty goals - Non-penalty xG - this is a measure of how well the player outperforms his xG and is an indicator of quality finishing
• Shots
• Shots on Target
• Shot on Target Ratio
• Non-penalty Goals per Shot - this is a measure of how often a player scores per shot. A higher value can be a subtle indicator of good finishing
• Non-penalty xG per Shot - this measures the quality of shot the player takes on average. This can be an indicator of quality movement
• Dribbles
• Fouls Won
• Assists
• Goal Contributions (Goals + Assists)
• Pass Attempts
• Passes Completed
• Pass Completion Ratio
• Key Passes - a key pass is the final pass by a teammate which leads to a goal attempt that does not lead to a goal
• Clear Cut Chances Created
• Cross Attempts
• Cross Completion Ratio
• Defensive Actions - this includes Tackles, Interceptions, Headers Won and Clearances 
• Tackles Won
• Interceptions
• Clearances
• Headers Attempted/Aerial Duels Contested
• Headers Won/ Aerial Duels Won
• Headers Won Ratio
• Fouls Committed
• Yellow/Red Cards
• Offsides
• Minutes per Game
• Distance Travelled 

To get a better reflection on how the player compares to players of the same level and same position, I have included percentile ranks. Percentiles range from the 0th to the 100th percentile and they provide a reflection of how a specific value of data compares to a larger pool of data. 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.

Do these files work for Fm21?

[Fmplaya]

2 hours ago, ta11zx said:

Do these files work for Fm21?

@ta11zx Unfortunately, it will only work for FM22 and FM23 as the views I have created only work with those games.

[thebuildupplay]

Great Work! There was only a problem if a player scored 10+ goals, then Goals/90 minutes is not displayed

[Fmplaya]

25 minutes ago, thebuildupplay said:

Great Work! There was only a problem if a player scored 10+ goals, then Goals/90 minutes is not displayed

@thebuildupplay Thanks for the feedback. Can you send a screenshot of your problem as this does not happen to me? Maybe download a fresh copy of the spreadsheet and try it again or you might've had a problem extracting the data.

[thebuildupplay]

3 minutes ago, Fmplaya said:

@thebuildupplay Thanks for the feedback. Can you send a screenshot of your problem as this does not happen to me? Maybe download a fresh copy of the spreadsheet and try it again or you might've had a problem extracting the data.

I checked on two tables specifically and on different devices. I assumed it might be a problem with importing data, but no. The result was the same for some reason

 

[Fmplaya]

27 minutes ago, thebuildupplay said:

I checked on two tables specifically and on different devices. I assumed it might be a problem with importing data, but no. The result was the same for some reason

 

Have you checked the Mins column in the Paste Here Sheet, it could be an issue with commas. If not could you please send me a saved copy of your spreadsheet?

[thebuildupplay]

8 minutes ago, Fmplaya said:

Have you checked the Mins column in the Paste Here Sheet, it could be an issue with commas. If not could you please send me a saved copy of your spreadsheet?

I checked it now. The minutes column displays the minutes in the format of 1,200. Without commas, dots, there is a space after thousands

[Fmplaya]

17 minutes ago, thebuildupplay said:

I checked it now. The minutes column displays the minutes in the format of 1,200. Without commas, dots, there is a space after thousands

Does this work now?

[thebuildupplay]

2 minutes ago, Fmplaya said:

Does this work now?

After I removed the spaces, then it worked. What should be the setting in the formats in the game itself, so as not to get such an error?

[Fmplaya]

3 hours ago, thebuildupplay said:

After I removed the spaces, then it worked. What should be the setting in the formats in the game itself, so as not to get such an error?

I don't think the problem comes from the game itself as it works for me using commas, you might want to check your thousands separator on excel following these instructions:

On 27/10/2022 at 16:43, Fmplaya said:

Before using my spreadsheet:

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 

Let me know if this works

 

Or worst-case scenario you can use the replace function by clicking CTRL+F to remove the commas from the minutes 

[chrisdarwen]

This is insanely good...

[Marinho]

sorry if i missed it but is there no way to manually choose the leagues? The options are greyed out and can't add any if i delete them. (FM23 Beta)

[Marinho]

On 27/10/2022 at 08:52, DarJ said:

When you select the players make sure you scroll down and up. That might fix it 

Also, could you or someone else please elaborate on this?

[Fmplaya]

9 hours ago, chrisdarwen said:

This is insanely good...

@chrisdarwen Thank you for the feedback!

 

41 minutes ago, Marinho said:

sorry if i missed it but is there no way to manually choose the leagues? The options are greyed out and can't add any if i delete them. (FM23 Beta)

@Marinho You can manually choose leagues by using the additional conditions and selecting Club > Division. I haven't found any problems with the filter, so it should work.

 

40 minutes ago, Marinho said:

Also, could you or someone else please elaborate on this?

When selecting the players, press on the top player and make sure you manually scroll from the top to the bottom player and scroll back up, then press CTRL+P.

[canhsatgiaothong]

Sorry if I missed anything but for some reason my defensive action is black. Do you know the reason? Here is the screenshot and both excel file and html file. 

FM Statistics Spreadsheet.xlsx lb search 2.0.html

Edited December 16, 2022 by canhsatgiaothong

[Fmplaya]

On 16/12/2022 at 19:49, canhsatgiaothong said:

Sorry if I missed anything but for some reason my defensive action is black. Do you know the reason? Here is the screenshot and both excel file and html file. 

FM Statistics Spreadsheet.xlsx 5.76 MB · 1 download lb search 2.0.html 36.69 kB · 1 download

@canhsatgiaothong I have looked at your saved copy of the spreadsheet and it works perfectly fine for me. This could be due to your decimal separator settings or etc. Have a look at this comment I made a while ago, hopefully it works.

 

On 27/10/2022 at 16:43, Fmplaya said:

Hi @Pepsi91,

What are your FM23 decimal and thousands separator settings?

Before using my spreadsheet:

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 

Let me know if this works

 

 

[canhsatgiaothong]

1 hour ago, Fmplaya said:

@canhsatgiaothong I have looked at your saved copy of the spreadsheet and it works perfectly fine for me. This could be due to your decimal separator settings or etc. Have a look at this comment I made a while ago, hopefully it works.

 

 

Can you tell me how you choose for your settings?

[canhsatgiaothong]

Still have the issues even though I have set the decimal as dot, the thousand as coma I still can't see the defense rows. I try to change the numbers into integer but it just doesn't show up in raw data table.

 

[fc.cadoni]

@Fmplaya take a look here for inspiration:  https://www.football-observatory.com/IMG/sites/mr/mr81/en/

[ta11zx]

Any fm21 spreadsheet available?

[the__mranderson]

Hey, only just come acorss this, and have started using it on FM23! Do you have a small video to show us how best to use it regardless of the FM?

 

Thanks again mate

[phnompenhandy]

2 hours ago, the__mranderson said:

Hey, only just come acorss this, and have started using it on FM23! Do you have a small video to show us how best to use it regardless of the FM?

 

Thanks again mate

I was just watching episode 1 of a new Moneyball series on YouTube:

FM23 | Moneyball Series | No Attributes | Stats Only | Paris FC | E1 Introduction to Moneyball (you could watch his whole FM22 series with Barnsley if you want the complete picture)

He recommends FM Stag's blog. Here's a page:

Statistics – What does “good” look like in FM23?

[Synchronized]

 

My drop down list is not working, the button is there but when i press it nothing happens, what could be causing it?

[Fmplaya]

Hello everyone! With my exams now over and more time to spend on FM, I would like to present the latest update to the statistics spreadsheet with the inclusion of goalkeeper statistics. I also apologise for any unanswered queries during my absence, hoping such problems do not occur with the updated version. Feel free to ask any questions and let me know of any suggestions or improvements that can be made to the spreadsheet.

Download file:

FM23 Statistics Spreadsheet (Updated).rar

[Fmplaya]

How to create data visualisations using Tableau

 

Firstly, I'd like to thank @MattyLewis11 for the inspiration of using data visualisation techniques in Football Manager.

 

1) Import the players in the spreadsheet following the steps at the top of this thread

You should preferably save a new copy of the spreadsheet, renamed as you wish, with the database of players to avoid potential issues

 

2) Download and install Tableau or Tableau Public (free version) 

Link for Tableau Public - https://www.tableau.com/products/public/download

Skip this step if you have Tableau already installed

 

3) Open Tableau and on the left-hand side there should be a heading Connect as shown below

 

Select Microsoft Excel

 

4) Locate the saved copy of the spreadsheet with the collection of players and click Open

You should have a result similar to the picture below

 

5) Hold the Raw Data Table on the left-hand side and drag and drop it where it says Drag tables here

The result should look like the picture shown below

 

 

6) Select Sheet 1 at the bottom of the screen

The result should look like the picture below

 

 

7) Choose two statistics you want to compare under the heading Tables (e.g npG/90 and npxG/90) and drag one each into Columns and Rows at the top of the screen

The result should look like below

 

 

8) Right-click the statistic you have put in Columns and select Dimension

 

 

Repeat with Rows and you should get a result similar to below

 

 

8) We now have a data visualisation but we can add more data to it to make it more useful. To make it easier to identify players on the visualisation, we want to find Name on the left-hand side under the heading Tables and hold, drag then drop it to Label under the heading Marks. You can also do the same with Age

The end result should look like below

 

 

9) To make it more informative, we can set extra details. For example, this can be Height, Weight, Position etc. Under the heading Tables, select, drag and drop the selected detail on Details under the heading of Marks.

Repeat this with as many details as necessary

When you hover over a specific player the details should show up as shown below

 

 

10) Finally we can add average lines to know which players are performing above or below average in their position

At the top left of the screen select Analytics

 

 

Then select and drag Average Line and under the heading Summarize

 

 

Drop the selected Average Line on Table as shown in the picture below

 

 

The result should look like below

 

 

Now you have your data visualisation!

 

Do feel free to experiment and mess around with the visualisation and if you have any good ideas that I hadn't mentioned, please do let me know 

[jimmysizzurp]

Have a few stats (Pressures completed, Progressive passes, Crosses etc) intentionally been excluded from the Spreadsheet/Views?

[milenec11]

Clearly a very excellent stats cvs but what about GKs stats ? Why is this role so underestimate?

[Fmplaya]

On 30/08/2023 at 03:03, jimmysizzurp said:

Have a few stats (Pressures completed, Progressive passes, Crosses etc) intentionally been excluded from the Spreadsheet/Views?

Those stats are included in the FM23 version of the spreadsheet

 

2 hours ago, milenec11 said:

Clearly a very excellent stats cvs but what about GKs stats ? Why is this role so underestimate?

Unfortunately in the game, there is a lack of goalkeeper statistics. The ones that I have included in the latest version are the only goalkeeper statistics that I found useful for Moneyball purposes