Fmplaya

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

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

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. Thank you very much and I hope it is useful to you!

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

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.

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

Those stats are included in the FM23 version of the spreadsheet 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

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

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

Hi @Cleon, I am really enjoying the thread and it has been very insightful seeing your approach to tactical analysis using data. I am also doing a save with the same skin and one of the things that I have found most difficult is youth development. As you have played 10 seasons and have a greater experience, did you prioritise youth development at all and if so how did you go about doing so?

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

Thanks for the shoutout!

@chrisdarwen Thank you for the feedback! @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. 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.

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: Or worst-case scenario you can use the replace function by clicking CTRL+F to remove the commas from the minutes

Does this work now?

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

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

No problem!

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

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

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

I was able to add the star attributes to the Zealand skin without any skinning knowledge, just experimentation! I have attached it for those interested. FME_-_Zealand.rar

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

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.