Fmplaya Posted February 16 Author Share Posted February 16 2 hours ago, Lazija1389 said: How do I fix this type of numbers and my average ratings are dates for example 7, july etc. Can you please send the excel file? 1 Link to post Share on other sites More sharing options...
Lazija1389 Posted February 17 Share Posted February 17 15 hours ago, Fmplaya said: Can you please send the excel file? I did manage to fix it in Excel files when I was change coma to dot it somehow changed it to 0, but thanks anyway. And thanks for puting your time and effort in making something like this uts great 1 Link to post Share on other sites More sharing options...
Fmplaya Posted February 19 Author Share Posted February 19 On 17/02/2024 at 10:53, Lazija1389 said: I did manage to fix it in Excel files when I was change coma to dot it somehow changed it to 0, but thanks anyway. And thanks for puting your time and effort in making something like this uts great I'm glad it's now working for you. Thank you for the feedback, it's very much appreciated Link to post Share on other sites More sharing options...
Bahnzo Posted February 24 Share Posted February 24 On 19/11/2023 at 10:07, Fmplaya said: 7) 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 Thanks for the work and sharing this. It might be helpful to specify here that depending on your settings, this might be something different. Instead of "km", I have "mi". Took a bit to figure that out, so could be helpful to others to mention that. Thanks again! 1 Link to post Share on other sites More sharing options...
Fmplaya Posted February 24 Author Share Posted February 24 18 hours ago, Bahnzo said: Thanks for the work and sharing this. It might be helpful to specify here that depending on your settings, this might be something different. Instead of "km", I have "mi". Took a bit to figure that out, so could be helpful to others to mention that. Thanks again! Thanks a lot, I have updated this now 1 Link to post Share on other sites More sharing options...
frogsplash Posted March 10 Share Posted March 10 (edited) Hi mate First of all on behalf of everyone can i say what a great bit of work this is It seems to be working fine for me apart from goalkeepers In the attached excel sheet the goalkeepers stats are their in the paste here tab, but they appear as zeros in both the raw data and percentiles tab - only save percentage works I have added in a column instead of clearances as the view didn't match the excel spreadsheet but the goalkeeper stats seem to be the only ones affected Sorry if i am doing something stupid and thanks again for the effort FM24 FMSS Statistics Spreadsheet v2.xlsx Untitled.html Edited March 10 by frogsplash Link to post Share on other sites More sharing options...
Ti Ago Posted March 13 Share Posted March 13 Hey 👋 Does this work with lower leagues ? Any league ? Or ONLY those top 5 and the other Next 5? Link to post Share on other sites More sharing options...
Fmplaya Posted March 13 Author Share Posted March 13 On 10/03/2024 at 16:27, frogsplash said: Hi mate First of all on behalf of everyone can i say what a great bit of work this is It seems to be working fine for me apart from goalkeepers In the attached excel sheet the goalkeepers stats are their in the paste here tab, but they appear as zeros in both the raw data and percentiles tab - only save percentage works I have added in a column instead of clearances as the view didn't match the excel spreadsheet but the goalkeeper stats seem to be the only ones affected Sorry if i am doing something stupid and thanks again for the effort FM24 FMSS Statistics Spreadsheet v2.xlsx Untitled.html 3.14 MB · 1 download Hi mate, I have had a look at this and there is not a problem in the formulas of my spreadsheet. It could possibly be due to your thousands and decimals separators in your FM or Excel settings or maybe you have accidentally tampered with the formulas by adding in a column. Maybe download a fresh copy of the spreadsheet or follow the instructions below. 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 Link to post Share on other sites More sharing options...
Fmplaya Posted March 13 Author Share Posted March 13 3 hours ago, Ti Ago said: Hey 👋 Does this work with lower leagues ? Any league ? Or ONLY those top 5 and the other Next 5? Yes, this should work with any league in the game provided there are statistics available for them. Link to post Share on other sites More sharing options...
Ti Ago Posted March 13 Share Posted March 13 1 hora atrás, Fmplaya disse: Yes, this should work with any league in the game provided there are statistics available for them. Full detail its mandatory ? Link to post Share on other sites More sharing options...
Fmplaya Posted March 15 Author Share Posted March 15 On 13/03/2024 at 13:56, Ti Ago said: Full detail its mandatory ? It is not mandatory but it is recommended if you want the statistics to be as accurate as possible Link to post Share on other sites More sharing options...
milenec11 Posted March 17 Share Posted March 17 (edited) regardless i have choosen some in game data the game does not exported as suppose to do any idea why Edited March 17 by milenec11 Link to post Share on other sites More sharing options...
Fmplaya Posted March 17 Author Share Posted March 17 7 hours ago, milenec11 said: regardless i have choosen some in game data the game does not exported as suppose to do any idea why I think this might be due to the skin. My best solution is to clear cache, reload the skin and restart the game. Link to post Share on other sites More sharing options...
milenec11 Posted March 17 Share Posted March 17 2 hours ago, Fmplaya said: I think this might be due to the skin. My best solution is to clear cache, reload the skin and restart the game. nope the same at any skin Link to post Share on other sites More sharing options...
Fmplaya Posted March 18 Author Share Posted March 18 22 hours ago, milenec11 said: nope the same at any skin Ah, have you tried clearing cache and reloading the skin then restarting the game? Link to post Share on other sites More sharing options...
milenec11 Posted March 18 Share Posted March 18 1 hour ago, Fmplaya said: Ah, have you tried clearing cache and reloading the skin then restarting the game? numerous time and i test it with many skins even the original i am desperate Link to post Share on other sites More sharing options...
SadBinder59 Posted April 1 Share Posted April 1 For me everything works fine except the statistic profile and player profile screen. Here is the dropbox link for my spreadsheet: https://www.dropbox.com/scl/fi/77ixstcbgj8prj68n0phk/Spielerauswahl_2024.xlsx?rlkey=i633fujwy9odfa7ab7qdllp1n&dl=0 i would be very happy if you can help me Link to post Share on other sites More sharing options...
Fmplaya Posted April 1 Author Share Posted April 1 2 hours ago, SadBinder59 said: For me everything works fine except the statistic profile and player profile screen. Here is the dropbox link for my spreadsheet: https://www.dropbox.com/scl/fi/77ixstcbgj8prj68n0phk/Spielerauswahl_2024.xlsx?rlkey=i633fujwy9odfa7ab7qdllp1n&dl=0 i would be very happy if you can help me Hi, I have had a look at your spreadsheet and it works perfectly fine for me. The problem might be because you need to use the latest version of Excel so you probably have to update your Excel. Let me know if this works Link to post Share on other sites More sharing options...
SadBinder59 Posted April 5 Share Posted April 5 Am 1.4.2024 um 22:52 schrieb Fmplaya: Hi, I have had a look at your spreadsheet and it works perfectly fine for me. The problem might be because you need to use the latest version of Excel so you probably have to update your Excel. Let me know if this works I updated Excel and it still doesn't work... I am using version 2403 Microsoft Office Professional Plus 2019 Link to post Share on other sites More sharing options...
Fmplaya Posted April 8 Author Share Posted April 8 On 05/04/2024 at 21:28, SadBinder59 said: I updated Excel and it still doesn't work... I am using version 2403 Microsoft Office Professional Plus 2019 Sorry to hear that you're still having problems using the spreadsheet. Unfortunately, I do not know how to fix this. Link to post Share on other sites More sharing options...
TheProdigy2108 Posted April 9 Share Posted April 9 Hey mate! hope you're well. I've downloaded the files/views and placed them in their folders but when I go to import them in game, the folders are empty. Any idea why? Link to post Share on other sites More sharing options...
Fmplaya Posted April 11 Author Share Posted April 11 On 09/04/2024 at 16:22, TheProdigy2108 said: Hey mate! hope you're well. I've downloaded the files/views and placed them in their folders but when I go to import them in game, the folders are empty. Any idea why? Check private message Link to post Share on other sites More sharing options...
yarsen_ Posted April 29 Share Posted April 29 Hi, The sheet is protected, so I can't change anything. Could I have the password? Thanks Yarsen Link to post Share on other sites More sharing options...
masharzy22 Posted May 10 Share Posted May 10 hey mate can u help me why my spreadsheet not showing all the data? Link to post Share on other sites More sharing options...
Fmplaya Posted May 10 Author Share Posted May 10 Just now, masharzy22 said: hey mate can u help me why my spreadsheet not showing all the data? Hi, can you send the spreadsheet? Link to post Share on other sites More sharing options...
masharzy22 Posted May 11 Share Posted May 11 17 hours ago, Fmplaya said: Hi, can you send the spreadsheet? the file larger than max total size to send mate Link to post Share on other sites More sharing options...
Fmplaya Posted May 17 Author Share Posted May 17 (edited) Hi everyone, the latest version of the spreadsheet is out now! This includes new features such as percentile scores for attacking, midfield and defensive playstyles added to the percentile table and the player profile screen. Also, a new sheet 'Filter' has been added which always you to filter players by percentile score on up to 10 metrics. Additionally, a new value 'Performance Score' has been introduced which provides a score based on a player's average rating and the relative strength of the league that they play in. I would like to give a big thanks to @GIMN for allowing me to add my own twist to the idea of the score system as he had used in his brilliant Moneyball Clinic series with Chelsea on his YouTube channel. I absolutely recommend his content for anyone who is interested. An example of how this value can be used is in conjugation with the new wage percentile to determine if a player's performance earn their wage (performance score percentile is similar to their wage percentile). If the performance score percentile is drastically underperforming the wage percentile then this could suggest the player is not playing to required standards. On the other hand, if the performance score percentile is drastically overperforming the wage percentile than this could be used to show a player is playing above the required standards. It is important to mention that the performance score will not be the most accurate measure of a player's actual performance level, so do not expect it to work perfectly. And more importantly, it will only be useful if you use the FMScout Real Names Fix as it will just be the player's average rating if not. For those downloading this version of the spreadsheet, be sure to read the instructions beforehand as there are new more things to do now. Hope you enjoy using the spreadsheet! https://www.mediafire.com/file/2wdtn89z405lj6b/FM24_FMSS_Statistics_Spreadsheet_v3.zip/file Updated Player Profile Page: Filter Page: Edited May 17 by Fmplaya Link to post Share on other sites More sharing options...
FMColl Posted May 23 Share Posted May 23 Hey mate love the spreadsheet but the new version is protected so there's no way to sort the columns, any chance you could link an unprotected version please? Link to post Share on other sites More sharing options...
Fmplaya Posted May 23 Author Share Posted May 23 Hi mate, I didn't realise I had forgotten to unlock the cells. Thanks for letting me know! This is the updated download link: https://www.mediafire.com/file/hwytmyi3xis70e4/FM24_FMSS_Statistics_Spreadsheet_v3.1.zip/file Link to post Share on other sites More sharing options...
anhtuanrip123 Posted June 15 Share Posted June 15 Can i Ask why sheet is limiting maximum 2001 player although i paste more than that in Paste sheet Link to post Share on other sites More sharing options...
Fmplaya Posted June 15 Author Share Posted June 15 10 hours ago, anhtuanrip123 said: Can i Ask why sheet is limiting maximum 2001 player although i paste more than that in Paste sheet This is because the spreadsheet supports up to 2000 players Link to post Share on other sites More sharing options...
anhtuanrip123 Posted June 18 Share Posted June 18 On 15/06/2024 at 20:42, Fmplaya said: This is because the spreadsheet supports up to 2000 players Do you have any other filter to reduce list cause with filter Most of league, total player is more than 3000 and I don't know which need to be removed Link to post Share on other sites More sharing options...
Fmplaya Posted June 18 Author Share Posted June 18 9 hours ago, anhtuanrip123 said: Do you have any other filter to reduce list cause with filter Most of league, total player is more than 3000 and I don't know which need to be removed You can try to edit the number of minutes on the filter, or you can pick specific positions you are looking at to reduce the total number Link to post Share on other sites More sharing options...
Strikerir1 Posted June 20 Share Posted June 20 I try to sort things and it asks for a password is there any issue there im using the browser excel Link to post Share on other sites More sharing options...
Fmplaya Posted June 20 Author Share Posted June 20 12 minutes ago, Strikerir1 said: I try to sort things and it asks for a password is there any issue there im using the browser excel I have had no problems with this so far. It could be due to using the browser version. Could you explain what exactly you can't sort? Link to post Share on other sites More sharing options...
Strikerir1 Posted June 21 Share Posted June 21 1 hora atrás, Fmplaya disse: I have had no problems with this so far. It could be due to using the browser version. Could you explain what exactly you can't sort? I've fixed it i found someone who had the file, unlocked so now im able to use it, now the only problem i have is some stats arent showing but i know why is due to the formats, the dot/comma etc, but i dont know how to change it on libre office or browser office Link to post Share on other sites More sharing options...
Fmplaya Posted June 23 Author Share Posted June 23 On 21/06/2024 at 01:33, Strikerir1 said: I've fixed it i found someone who had the file, unlocked so now im able to use it, now the only problem i have is some stats arent showing but i know why is due to the formats, the dot/comma etc, but i dont know how to change it on libre office or browser office If you go to File, then Options and click Regional Format Settings, you can set it to your country. Hopefully this helps Link to post Share on other sites More sharing options...
Kimain1 Posted July 20 Share Posted July 20 Hello FmPlaya, thanks for the great spreadsheet. Unfortunately my data in the spreadsheet are all very weird when i insert it (it seems to be that dates get generated automatically for example a 6.60 rating is created to 01.06.1960 but i can neither undo or deactivate this) Is there a way to stop the dates getting generated automatically? Heres the link to the spreadsheet if you need it. https://docs.google.com/spreadsheets/d/1GfnWlxP-qBL5L6XwozTgUUrM-MY1VQUq/edit?usp=drive_link&ouid=117475177117329917256&rtpof=true&sd=true Thank you Lennart Link to post Share on other sites More sharing options...
Strikerir1 Posted July 24 Share Posted July 24 Hi hello again i finally got excel, and ive got everything working, but there is one small problem , everytime i go to sort something out it turns everything 0 and deletes everything if i try sorting from smallest to largest and everything in between. Link to post Share on other sites More sharing options...
Fmplaya Posted August 1 Author Share Posted August 1 On 24/07/2024 at 21:50, Strikerir1 said: Hi hello again i finally got excel, and ive got everything working, but there is one small problem , everytime i go to sort something out it turns everything 0 and deletes everything if i try sorting from smallest to largest and everything in between. Hi, apologies for the late response. I have been busy as of recent. Could you ink the Excel file so I can have a look at it? On 20/07/2024 at 20:21, Kimain1 said: Hello FmPlaya, thanks for the great spreadsheet. Unfortunately my data in the spreadsheet are all very weird when i insert it (it seems to be that dates get generated automatically for example a 6.60 rating is created to 01.06.1960 but i can neither undo or deactivate this) Is there a way to stop the dates getting generated automatically? Heres the link to the spreadsheet if you need it. https://docs.google.com/spreadsheets/d/1GfnWlxP-qBL5L6XwozTgUUrM-MY1VQUq/edit?usp=drive_link&ouid=117475177117329917256&rtpof=true&sd=true Thank you Lennart I had a look at this and I'm afraid I'm not sure how to fix this problem. If possible I would suggest using Excel for the spreadsheet as it is where I created the spreadsheet 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