Also, can you explain the basis for the weightings? I'm wondering why tactical knowledge is as important as JCA and JPA for a scout. Didn't realize it mattered that much. What's up with that? Expand The weights I have in the sheets are from within the game and give an overall picture of each role's ability.
'Tactical Knowledge' if you pay attention to the other roles too is important because it is contained in many aspects in the game but somewhat hidden. In Scout role, this attribute will help them more to give you a more accurate analysis of what parts of the game the player is good at. To Assistant Managers, it will help them give you better in-game and pre-game instructions on your tactical approach against a particular opponent etc.
Could you tweak the spreadsheet so it doesn't just stick to someone's preferred job? Like, if someone's top pick is 'Director of Football', they could still be a good fit for a 'Scout', right? But right now, the spreadsheet won't show how good they are for the scout job if their preferred job is different. It'd be cool if the spreadsheet could give us ratings for different roles, no matter what job they prefer.
Thanks! Expand I will add it soon. For now, you can change the role listed in the preferred job column from e.g. “Director of Football” to “Scout” and it will show the ratings of that staff as Scout.
** UPDATE ** - Players Ratings and related view added in the link of the OP.
@Delicious it turned out to be faster than I thought because I had already set it up for FM22. It needed some updates and general fixes and now I think I can share it more widely.
bwig said: wow! Thanks for the effort. Looking great! Expand Thank you! Have you used any of them so far?
Delicious said: Did you made one for the players as well? Really interested about that.
Would like to define literally how the stats are "impactful" on the game. Like to me stats like passing are like after 10 are 0.3 (example number). Don't know if that's make sense to you Expand You mean attributes or stats? If you mean stats it's a bit weird because there are stats in the game that are measured differently than reality. An example is OPPDA which in reality is 60% of the pitch starting from opposition goal until little further of halfway line, but in the game is the opposite area. Also playing with just the stats I really haven't seen any success.
Now if you speak about attributes i will create an excel file about this as well but when I have time because I will need more time for this.
Your saved game file will update too. The only changes need a new save are those related to database(new transfers, upgrades/downgrades of players abilities etc).
There is another sheet called "ROLES (FMRTE) & POSITIONAL RATINGS (FMRTE)" which its a little bit more complicated to export them but I will update this thread step by step to do it on yours. Also I've uploaded another excel file to the link in the original post that calculates the coaches ratings for each category of training.
I have created some excel spreadsheets that measure players and staff ratings. Before I go into further detail I'd like to say that there are several other tools that do these, so I thought I'd create one of my own with slightly different formulas.
Before you begin These spreadsheets analyze exported data from FM using prepared views. You need to use these exact views to make these spreadsheets work correctly.
How to export players/staff members from FM24? 1. Download views and excel files from here.
2. Put files into Documents\Sports Interactive\Football Manager 2024\views so it will be easier for you to import them after inside the game. (Optional)
4. Select one of these views and then click Load. - ROLES (FM24) - TRAINING (FM24) - RATINGS (FM24)
5. Now use the imported views.
6. Select all rows by pressing CTRL + A (if you don't do this, it will export around ~200 rows only) then export file by pressing CTRL + P (Print popup) and select Web Page > Ok and then Save.
7. Open the file from Documents\Sports Interactive\Football Manager 2024 in a browser of your choice and then select all rows by pressing CTRL + A again.
8. Open the excel file and make sure that you are in the correct sheet (ROLES or TRAINING or RATINGS - depends of what you exported - staff or players) and then click on "A1" cell.
9. Next you click on the down arrow where is 'Paste' and you click the right icon as it shows in the screenshot below.
10. And voila! Now you can sort the orange headers by what you are searching for with the highest number to be on top, which means better rating.
@Zippo sorry to bother you again about this, but I think if you implement in the tactics sharing section, when someone wants to share a new tactic, the 5 screenshots to be as "required", then we won't have this kind of new issues again. I think it's a simple step so that everyone has to upload those 5 screenshots without having to have someone post the rules on how to do it every time.
An example is on the SI forum where is bug tracker. There it asks for some files(.pkm/save files/screenshots etc) as "mandatory" to support your report.
An updated version of Achilles Heel V1.1. Balanced --> Attacking Added: Focus Play Removed: Pass Into Space, Distribute To Centre-Backs, Distribute Quickly, Step Up More W -> IF VOL -> DM
Send me your exported file from within the game to check it on my end.
Also, can you explain the basis for the weightings? I'm wondering why tactical knowledge is as important as JCA and JPA for a scout. Didn't realize it mattered that much. What's up with that?
The weights I have in the sheets are from within the game and give an overall picture of each role's ability.
'Tactical Knowledge' if you pay attention to the other roles too is important because it is contained in many aspects in the game but somewhat hidden. In Scout role, this attribute will help them more to give you a more accurate analysis of what parts of the game the player is good at. To Assistant Managers, it will help them give you better in-game and pre-game instructions on your tactical approach against a particular opponent etc.
Could you tweak the spreadsheet so it doesn't just stick to someone's preferred job? Like, if someone's top pick is 'Director of Football', they could still be a good fit for a 'Scout', right? But right now, the spreadsheet won't show how good they are for the scout job if their preferred job is different. It'd be cool if the spreadsheet could give us ratings for different roles, no matter what job they prefer.
Thanks!
I will add it soon. For now, you can change the role listed in the preferred job column from e.g. “Director of Football” to “Scout” and it will show the ratings of that staff as Scout.
- Players Ratings and related view added in the link of the OP.
@Delicious it turned out to be faster than I thought because I had already set it up for FM22. It needed some updates and general fixes and now I think I can share it more widely.
Thank you! Have you used any of them so far?
Delicious said: Did you made one for the players as well? Really interested about that.
Would like to define literally how the stats are "impactful" on the game. Like to me stats like passing are like after 10 are 0.3 (example number). Don't know if that's make sense to you
You mean attributes or stats? If you mean stats it's a bit weird because there are stats in the game that are measured differently than reality. An example is OPPDA which in reality is 60% of the pitch starting from opposition goal until little further of halfway line, but in the game is the opposite area. Also playing with just the stats I really haven't seen any success.
Now if you speak about attributes i will create an excel file about this as well but when I have time because I will need more time for this.
Your saved game file will update too. The only changes need a new save are those related to database(new transfers, upgrades/downgrades of players abilities etc).
I have created some excel spreadsheets that measure players and staff ratings. Before I go into further detail I'd like to say that there are several other tools that do these, so I thought I'd create one of my own with slightly different formulas.
Before you begin
These spreadsheets analyze exported data from FM using prepared views. You need to use these exact views to make these spreadsheets work correctly.
How to export players/staff members from FM24?
1. Download views and excel files from here.
2. Put files into Documents\Sports Interactive\Football Manager 2024\views so it will be easier for you to import them after inside the game. (Optional)
3. Import views into:
- Staff > Staff Search (ROLES & TRAINING)
- Scouting > Players > Players in Range (RATINGS)
4. Select one of these views and then click Load.
- ROLES (FM24)
- TRAINING (FM24)
- RATINGS (FM24)
5. Now use the imported views.
6. Select all rows by pressing CTRL + A (if you don't do this, it will export around ~200 rows only) then export file by pressing CTRL + P (Print popup) and select Web Page > Ok and then Save.
7. Open the file from Documents\Sports Interactive\Football Manager 2024 in a browser of your choice and then select all rows by pressing CTRL + A again.
8. Open the excel file and make sure that you are in the correct sheet (ROLES or TRAINING or RATINGS - depends of what you exported - staff or players) and then click on "A1" cell.
9. Next you click on the down arrow where is 'Paste' and you click the right icon as it shows in the screenshot below.
10. And voila! Now you can sort the orange headers by what you are searching for with the highest number to be on top, which means better rating.
You can search them through FM PreGame Editor
An example is on the SI forum where is bug tracker. There it asks for some files(.pkm/save files/screenshots etc) as "mandatory" to support your report.
Balanced --> Attacking
Added: Focus Play
Removed: Pass Into Space, Distribute To Centre-Backs, Distribute Quickly, Step Up More
W -> IF
VOL -> DM
Added 'Pass Into Space'
Removed: Distribute To Centre-Backs, Slow Pace Down
Tweaks on PIs.
Is there any chance of making the website mobile friendly?
Thank you
Can you post some results of these set-pieces routines?
IF -> IW
Removed: Pass Into Space, Focus Play, Distribute Quickly, Get Stuck In