Jump to content

Fmplaya

Members+
  • Posts

    130
  • Joined

  • Last visited

Everything posted by Fmplaya

  1. If you go to File, then Options and click Regional Format Settings, you can set it to your country. Hopefully this helps
  2. 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?
  3. 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
  4. 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
  5. 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:
  6. Sorry to hear that you're still having problems using the spreadsheet. Unfortunately, I do not know how to fix this.
  7. 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
  8. Ah, have you tried clearing cache and reloading the skin then restarting the game?
  9. I think this might be due to the skin. My best solution is to clear cache, reload the skin and restart the game.
  10. It is not mandatory but it is recommended if you want the statistics to be as accurate as possible
  11. Yes, this should work with any league in the game provided there are statistics available for them.
  12. 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
  13. I'm glad it's now working for you. Thank you for the feedback, it's very much appreciated
  14. You have used the incorrect views. You have to use the view FM24 'FMSS Squad View' for the spreadsheet to work.
  15. Hi, the maximum number of players it can handle is supposed to be 2000. Can you send your Excel file so I can see where the problem is?
  16. Are you using the latest version of Excel? Yeah I completely agree, it is very frustrating having to flick through multiple Excel sheets to keep a record of player data when it can be done by the game.
  17. Hi! Thanks for pointing that out, I hadn't realised I had forgotten to unlock those columns. I have posted a link for the updated version of the spreadsheet which allows you to sort the tables. https://www.mediafire.com/file/rtaxuq2x2k1xhjw/FM24_FMSS_Spreadsheet_v2.zip/file
  18. Hi, the problem is that the minutes column uses a point instead of a comma for the thousands separator. If that doesn't work, you can select the whole column AP and press CTRL + H, and replace the dot with a comma.
×
×
  • Create New...