Popular Post CAE82 Posted January 27 Popular Post Share Posted January 27 Hi all, I've created a spreadsheet tool that allows you see the ability of your players in different positions/roles/duties. It uses the attribute weights from the pre-game editor along with all the key/preferred attributes for the different roles. An algorithm will then suggest which individual training focus to use to address weaknesses in the attributes key to that position and role/duty. In the example below, we can see that the tool has suggested that Gvardiol should be trained in crossing if he was playing full-back as a CWB(A). It also shows he has an average attribute value of 13.4 which translates to an effective current ability of 147. This can be useful to compare players in your squad and see who is the most suitable player for a particular role in your tactic. The accompanying FM24 squad view can be used to easily export your squad as a HTML page which can then be imported into the sheet. You can then easily select a player from the drop-down. - Import the .ods file into Google Sheets (or it may open in Excel, haven't tested though) - Place the .fmf view in your 'views' FM24 directory - Go to your squad in the game, import the view, then print to webpage/HTML (ctrl + P) - Import the .html file into the 'Squad' tab in the spreadsheet - Go to the 'Player' tab, select the player in the drop-down as well as the position and role they play. The calculator will then suggest which training to use. - You can also select different positions and roles to see their effective current ability (more accurate than the 5 star in-game rating) - More information in the 'About' tab. A link to a public copy in Google Sheets is below which you could use to make a copy into your own Google acount. https://docs.google.com/spreadsheets/d/1RI7FDbFriR1isHUFuRagLJAKw7j92xmUpBVxCG0f5RM/edit?usp=sharing The calculations and algorithms are based on the work presented here: https://www.fmscout.com/a-guide-to-current-ability-in-football-manager.html https://www.fmscout.com/a-guide-to-player-role-abilities-in-football-manager.html Feedback welcome. Enjoy. CAE_Training_Attributes.fmf FM24_Training_and_Role_Ability_Calculator_by_CAE.ods 8 Link to post Share on other sites More sharing options...
Arijit Posted January 27 Share Posted January 27 Kudos for making it freely available and in .ods format. Respect! I will definitely try this one. Link to post Share on other sites More sharing options...
Bahnzo Posted January 27 Share Posted January 27 (edited) Wow, very cool! Thanks for sharing! Edited January 27 by Bahnzo Link to post Share on other sites More sharing options...
Andros Posted January 28 Share Posted January 28 (edited) Nice work! I am on FM23 so I couldn't get the view to work - I don't know if that is an issue with me or the game ;). Here is one for FM23 if anyone is interested. (if anyone sees anything wrong just let me know): 2023 View for Calculator.fmf Something to consider: I see on other websites they say that Pace and Acceleration are by far the 2 most important attributes for any player, maybe consider that for an impact on training focus? Edited January 28 by Andros Renamed file Link to post Share on other sites More sharing options...
CAE82 Posted January 28 Author Share Posted January 28 2 hours ago, Andros said: Here is one for FM23 if anyone is interested. (if anyone sees anything wrong just let me know): Thanks for making this! Presumably you looked at the City squad example and put the columns in the same order? If so, then it should work fine. All the ‘default’ attribute weights (including Pace and Acceleration) are taken into account by the algorithm. Total Weight = Position Weight + Role Weight * 5 The role weight is 1 for a blue preferred attribute and 2 for a green key attribute. The position weights are typically in the range 1-10, so a green attribute will be +10 and a blue attribute +5 compared to the standard position weight. If you have a slow player playing AMRL as a W(A) then I suspect it would suggest quickness training (assuming their crossing isn’t even more of a weakness). If you come across any training suggestions that seem very counter intuitive then please let me know and I can investigate the algorithm. Link to post Share on other sites More sharing options...
CAE82 Posted January 28 Author Share Posted January 28 11 hours ago, Arijit said: Kudos for making it freely available and in .ods format. Respect! I will definitely try this one. Thanks, please post any feedback! Link to post Share on other sites More sharing options...
CAE82 Posted January 28 Author Share Posted January 28 10 hours ago, Bahnzo said: Wow, very cool! Thanks for sharing! Thanks, please post any feedback! Link to post Share on other sites More sharing options...
Arijit Posted January 28 Share Posted January 28 I am playing with St. Pauli in Bulli-2. I have setup my training based on spreadsheet suggestion. I will keep an eye of the progress of the players. Few of the players are in early-20s, I am excited to see them improve a lot. Link to post Share on other sites More sharing options...
Andros Posted January 29 Share Posted January 29 20 hours ago, CAE82 said: Thanks for making this! Presumably you looked at the City squad example and put the columns in the same order? If so, then it should work fine. All the ‘default’ attribute weights (including Pace and Acceleration) are taken into account by the algorithm. Total Weight = Position Weight + Role Weight * 5 The role weight is 1 for a blue preferred attribute and 2 for a green key attribute. The position weights are typically in the range 1-10, so a green attribute will be +10 and a blue attribute +5 compared to the standard position weight. If you have a slow player playing AMRL as a W(A) then I suspect it would suggest quickness training (assuming their crossing isn’t even more of a weakness). If you come across any training suggestions that seem very counter intuitive then please let me know and I can investigate the algorithm. Perhaps consider having a look at: https://fm-arena.com/table/26-player-attributes-testing/ https://fm-arena.com/thread/8249-fm24-meta-player-attributes/ TLDR: Speed (Pace and acceleration) affect results the most of any attribute. Now, their testing is not perfect, but worth discussing. I also wonder if age should have more of an affect on training, eg younger players focus more on physical attributes and older players less. Let me give you an example: I am using Liverpool on FM23. Ben Doak is 17 (IIRC) and the spreadsheet suggests this: I would suggest focusing on stamina would be of more use. Anyway, I guess the obvious answer is make my own decisions as I am the manager! Just a thought though if you are interested Link to post Share on other sites More sharing options...
CAE82 Posted January 29 Author Share Posted January 29 3 hours ago, Andros said: I also wonder if age should have more of an affect on training, eg younger players focus more on physical attributes and older players less. Let me give you an example: Good idea, will consider it! Are you using Excel by the way? The image has some errors (no blue cells and crossing showing as 100%). Some of the Google Sheet equations are not compatible with Excel it seems. Maybe I will make an Excel version today. Link to post Share on other sites More sharing options...
CAE82 Posted January 29 Author Share Posted January 29 Excel version attached. FM24_Training_and_Role_Ability_Calculator_by_CAE.xlsx 1 Link to post Share on other sites More sharing options...
Andros Posted January 29 Share Posted January 29 2 hours ago, CAE82 said: Good idea, will consider it! Are you using Excel by the way? The image has some errors (no blue cells and crossing showing as 100%). Some of the Google Sheet equations are not compatible with Excel it seems. Maybe I will make an Excel version today. Yes I was using excel. Also remember that i was using FM23 so there is a chance I have screwed things up when making my own view! Thanks for the update. Link to post Share on other sites More sharing options...
CAE82 Posted January 29 Author Share Posted January 29 You wouldn't have messed anything up. Excel isn't compatiable with the ISERROR function so when you open the .ods version the 'weakness rating' vales don't update. Should do with the .xlxs version above. I'm looking forward to the upcoming Excel update that integrates Python - should open a whole load of new possibilties with FM. Link to post Share on other sites More sharing options...
mellman Posted January 29 Share Posted January 29 Thanks for sharing, just used it to setup my individual training. Look forward to seeing how it pans out. Also, do people utilise individual positional training in addition to the individual focus? Or is it better to use one OR the other? Link to post Share on other sites More sharing options...
CAE82 Posted January 30 Author Share Posted January 30 Good luck @mellman. I personally use both in general. However, presumably that means each attribute will get less attention. So if a player has a serious flaw, then I may focus on that with no position training. Or if a player needs a rest then you can lighten the load by just using one. It is also worth paying attention to training units. I often use SV(A). DM players usually start off in the Defensive Units, so I’ll move someone playing and training as a Segundo Volante to the attacking unit. Link to post Share on other sites More sharing options...
MadCatPT Posted March 19 Share Posted March 19 Was looking for something like that! The Google sheet has some reference errors. I'm not an expert, but it seem there are tabs missing? Link to post Share on other sites More sharing options...
MadCatPT Posted March 19 Share Posted March 19 The ODS file was working, great work. Link to post Share on other sites More sharing options...
CAE82 Posted March 20 Author Share Posted March 20 Great, let me know how it works out. I think the Google Sheet version is messed up. Didn’t know how to share without giving edit access so think someone has messed it up by accident. Link to post Share on other sites More sharing options...
blakecarterrr Posted March 20 Share Posted March 20 Hi @CAE82 - Loving the spreadsheet. If the public one has gone wrong you can cycle back through previous versions to find the one that works. If you then lock the sheet you can share, but set people to View Only. Then, if anyone wants to edit - they will have to download a copy to their own Google Drive. Works much better and keeps your work safe! Link to post Share on other sites More sharing options...
CAE82 Posted March 20 Author Share Posted March 20 Thanks for the tip @blakecarterrr! Have you tried changing the position/role weight when you use it? I’ve started to make that number higher so give more weight to the role as found DM usually suggested defensive positioning but that felt ‘wrong’ in some cases for SV(A). Link to post Share on other sites More sharing options...
Abaddon879 Posted May 24 Share Posted May 24 This is a fantastic tool - great work! I've always had to ignore the coaches suggestions as they seemed rubbish, so I will definitely be using this and adding it to my variety of squad building spreadsheets (I have ones for squad planning, position/role suitability, wage structure, and now one for training suggestions!) As a suggestion, it could be useful to also consider a club DNA, rather than solely relying on the in-game attributes for the default roles. Maybe allowing for 4-5 attributes to be given added weighting to suit your play style. These DNA attributes could be given a 0.5 boost or something to make them higher on the priority list and address any weaknesses in regards to the team style of play. For example if you play a high energy Gegenpressing style you might want to prioritise a weakness in Endurance if their Stamina and Workrate were comparatively low. 1 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