Popular Post Fmplaya Posted August 5, 2022 Popular Post Share Posted August 5, 2022 (edited) 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 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 17 Link to post Share on other sites More sharing options...
ta11zx Posted August 6, 2022 Share Posted August 6, 2022 I have read this twice and I still don't understand what this does. 7 Link to post Share on other sites More sharing options...
fc.cadoni Posted August 6, 2022 Share Posted August 6, 2022 Nice! Thank you for sharing @Fmplaya! 1 Link to post Share on other sites More sharing options...
Fmplaya Posted August 7, 2022 Author Share Posted August 7, 2022 (edited) 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 3 Link to post Share on other sites More sharing options...
Fmplaya Posted August 7, 2022 Author Share Posted August 7, 2022 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! 1 Link to post Share on other sites More sharing options...
Yorki Posted August 8, 2022 Share Posted August 8, 2022 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/ 1 Link to post Share on other sites More sharing options...
Fmplaya Posted August 9, 2022 Author Share Posted August 9, 2022 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! Link to post Share on other sites More sharing options...
SI Staff Jack Sarahs Posted August 9, 2022 SI Staff Share Posted August 9, 2022 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! 2 Link to post Share on other sites More sharing options...
Fmplaya Posted August 9, 2022 Author Share Posted August 9, 2022 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. 1 Link to post Share on other sites More sharing options...
bosque Posted August 9, 2022 Share Posted August 9, 2022 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? Link to post Share on other sites More sharing options...
Fmplaya Posted August 9, 2022 Author Share Posted August 9, 2022 (edited) 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 2 Link to post Share on other sites More sharing options...
Paulo191 Posted October 24, 2022 Share Posted October 24, 2022 Well, now THIS is Moneyball. Great work! I'll surely give it a try. Link to post Share on other sites More sharing options...
Fmplaya Posted October 26, 2022 Author Share Posted October 26, 2022 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 Link to post Share on other sites More sharing options...
allaneh22 Posted October 27, 2022 Share Posted October 27, 2022 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? Link to post Share on other sites More sharing options...
DarJ Posted October 27, 2022 Share Posted October 27, 2022 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 2 Link to post Share on other sites More sharing options...
allaneh22 Posted October 27, 2022 Share Posted October 27, 2022 1 hora atrás, DarJ disse: When you select the players make sure you scroll down and up. That might fix it THX! Worked. 2 Link to post Share on other sites More sharing options...
cmason84 Posted October 27, 2022 Share Posted October 27, 2022 @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 1 Link to post Share on other sites More sharing options...
Fmplaya Posted October 27, 2022 Author Share Posted October 27, 2022 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. Link to post Share on other sites More sharing options...
Pepsi91 Posted October 27, 2022 Share Posted October 27, 2022 (edited) 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 Link to post Share on other sites More sharing options...
Fmplaya Posted October 27, 2022 Author Share Posted October 27, 2022 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 1 Link to post Share on other sites More sharing options...
Pepsi91 Posted October 27, 2022 Share Posted October 27, 2022 It does, thank you very much! Czech use comma as decimal separator, so that was the problem. Link to post Share on other sites More sharing options...
Fmplaya Posted October 27, 2022 Author Share Posted October 27, 2022 1 minute ago, Pepsi91 said: It does, thank you very much! Czech use comma as decimal separator, so that was the problem. No problem! Link to post Share on other sites More sharing options...
ta11zx Posted October 28, 2022 Share Posted October 28, 2022 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? Link to post Share on other sites More sharing options...
Fmplaya Posted October 28, 2022 Author Share Posted October 28, 2022 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. Link to post Share on other sites More sharing options...
thebuildupplay Posted October 30, 2022 Share Posted October 30, 2022 Great Work! There was only a problem if a player scored 10+ goals, then Goals/90 minutes is not displayed Link to post Share on other sites More sharing options...
Fmplaya Posted October 30, 2022 Author Share Posted October 30, 2022 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. Link to post Share on other sites More sharing options...
thebuildupplay Posted October 30, 2022 Share Posted October 30, 2022 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 Link to post Share on other sites More sharing options...
Fmplaya Posted October 30, 2022 Author Share Posted October 30, 2022 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? 1 Link to post Share on other sites More sharing options...
thebuildupplay Posted October 30, 2022 Share Posted October 30, 2022 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 Link to post Share on other sites More sharing options...
Fmplaya Posted October 30, 2022 Author Share Posted October 30, 2022 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? Link to post Share on other sites More sharing options...
thebuildupplay Posted October 30, 2022 Share Posted October 30, 2022 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? Link to post Share on other sites More sharing options...
Fmplaya Posted October 30, 2022 Author Share Posted October 30, 2022 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 Link to post Share on other sites More sharing options...
chrisdarwen Posted November 3, 2022 Share Posted November 3, 2022 This is insanely good... Link to post Share on other sites More sharing options...
Marinho Posted November 3, 2022 Share Posted November 3, 2022 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) Link to post Share on other sites More sharing options...
Marinho Posted November 3, 2022 Share Posted November 3, 2022 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? Link to post Share on other sites More sharing options...
Fmplaya Posted November 3, 2022 Author Share Posted November 3, 2022 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. 1 Link to post Share on other sites More sharing options...
canhsatgiaothong Posted December 16, 2022 Share Posted December 16, 2022 (edited) 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 Link to post Share on other sites More sharing options...
Fmplaya Posted December 17, 2022 Author Share Posted December 17, 2022 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 Link to post Share on other sites More sharing options...
canhsatgiaothong Posted December 17, 2022 Share Posted December 17, 2022 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? Link to post Share on other sites More sharing options...
canhsatgiaothong Posted December 19, 2022 Share Posted December 19, 2022 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. Link to post Share on other sites More sharing options...
fc.cadoni Posted December 26, 2022 Share Posted December 26, 2022 @Fmplaya take a look here for inspiration: https://www.football-observatory.com/IMG/sites/mr/mr81/en/ Link to post Share on other sites More sharing options...
ta11zx Posted December 26, 2022 Share Posted December 26, 2022 Any fm21 spreadsheet available? Link to post Share on other sites More sharing options...
the__mranderson Posted January 12, 2023 Share Posted January 12, 2023 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 Link to post Share on other sites More sharing options...
phnompenhandy Posted January 13, 2023 Share Posted January 13, 2023 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? 1 Link to post Share on other sites More sharing options...
Synchronized Posted February 28, 2023 Share Posted February 28, 2023 My drop down list is not working, the button is there but when i press it nothing happens, what could be causing it? Link to post Share on other sites More sharing options...
Fmplaya Posted June 27, 2023 Author Share Posted June 27, 2023 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 Link to post Share on other sites More sharing options...
Fmplaya Posted June 27, 2023 Author Share Posted June 27, 2023 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 1 Link to post Share on other sites More sharing options...
jimmysizzurp Posted August 30, 2023 Share Posted August 30, 2023 Have a few stats (Pressures completed, Progressive passes, Crosses etc) intentionally been excluded from the Spreadsheet/Views? Link to post Share on other sites More sharing options...
milenec11 Posted August 31, 2023 Share Posted August 31, 2023 Clearly a very excellent stats cvs but what about GKs stats ? Why is this role so underestimate? Link to post Share on other sites More sharing options...
Fmplaya Posted August 31, 2023 Author Share Posted August 31, 2023 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 Link to post Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now