Couple tips for non brits: Make sure the days and months are going to the correct columns in the age_in_days sheet and make sure that all full dates on the sheet are in the same format. On the all positions sheet, if you aren't seeing the value for any players, make sure that the high values are being taken on the skd sheet I was having trouble with the extraction of the high values because Im from the us and the symbols were, of course, the dollar sign and not the pound symbol. I had no clue what the code was for that column, and so i replaced it with: =iferror(index(split(t#, "- $"),2)," ") where the # is the row number. If using a money sign that's not $ just swap it in this line.
Thanks for this, it's a truly exceptional video. The last time I played FM before 2024 was in 2012 where I played Wrexham and took them to the prem (played them before they were cool, a real hipster) cos they had the biggest stadium in the lower leagues, I always wondered if this was why they got bought out! The only other video of yours I've seen was the original roles/player scoring video and it's helped me immensely. I'm playing as my hometown club Leicester and have just won a prem/FA cup double in 2026 and a prem/FA/league cup triple in 2027 without scumming so I'm delighted. The board have announced a new stadium and this will help me keep the finances on track while aiming for the next goal - a champions league trophy (only gotten to ro16 so far). It took a bit of value fiddling in excel as I play a different style of football (lots of wing play, target forward, big lads for set pieces and lots of set piece routines/goals - set pieces seem brokenly good, Lorenzo Lucca is my 25+ goal a season wonder, Harry Souttar gets 15 goals a season!) and the roles don't line up, but just having the spreadsheets and role scores as a baseline is incredible, thank you so much.
Thanks squirrel. I was certainly puzzled by how you created the trajectory until the end. I'm on my first ever Pentagon challenge and only just qualified for the first continental champions league after 3 consecutive league wins in Japan using your principles to find players. Not using your tactics though, so I've had to adapt.
Can you do more of these videos with the present database? I don’t even play FM but I love watching it and your data driven approach is so interesting you could even do 5 year saves where you take underperforming / ageing squads and turn it into one of the best ITW, even better if you experimented more with formations to get some variety and adapt your methods to other systems / team playstyles to go even further you could upload those saves for channel supporters
Can see plenty of people are adapting the spreadsheet to their own save / tactic - I've just posted a thread on twitter @playingsquirrel with tips on how to do that. Good luck!
So you are saying I need a twitter account? 😦 Do you think you will be able to produce another site or modify the previous, which has the trajectory capability? I'm using IFB-D, BWM-D, AP-S, IF-A, AM-S so I've been trying to understand the technical aspects to modify to suit. Suppose it gets you more views though... 😂
@@mabozar15 What I've done myself is that I've created a list of all the players of the top 5 leagues, put it into the scoring system, exported that and then filtered for each position by age and took the best 50 players per age group and took the average of those to create my thresholds. For goalkeepers, I exported an extra list with all gks in the database as those of the top 5 leagues are too small of a sample size to create thresholds by age group.
@seromg1175 yeah, I may do something like that, but possibly just go on holiday for a year and take the progression rates for those selected players. Cheers
Really interesting video! Quick question: How did you create the trajectories for the positions? I would like to do the same myself for the tactic I use.
@@squirrel_plays_fof4318 Thanks! Did you use the existing PL players from the beginning of the game as a benchmark, or are the averages solely based off of the development of the batch of players you followed?
@@broedblings Just the guys I followed. I'm keeping an eye on my current save to see if it makes sense, and I'm pretty sure it does. But all comments welcomed of course
is there a miscalculation with the BPD? strikers and wingers with no defence are getting highest results for me, and Pelaez is your best BPD on the original
Great video as usual. Would be interesting to see how different star ratings of potential, combined with your app's rating of a players ability at a particular age, affects the end point of a player's development. I imagine on your pen and paper graph, you'd see different gradients for different potential abilities. That's if star potential ratings can be trusted of course...
Yeah I have no idea how much to trust the star ratings even after doing all this. Certainly not entirely. The sort of rigour one would need to test that out strays into EBFM territory. For now I'm still trying to use the star ratings and this together
Excellent video as usual! I downloaded the views, however, the DOB & Nationality ones are not showing on my FM. I'm on FM23 not sure if that has anything to do with it.
Hmm dunno...I haven't tried to do it on FM23. If you make a really simple view with the date of birth as the fourth column over it ought to work - that's all the spreadsheet really needs to see (column D). If you add nationality in columns E and F (fifth and sixth) it will look to see if UK and Ireland, that's only if you care about that - I do as signing 'domestic' (=UK + Ireland) under 18s is allowed but not foreign for an English club
Hi squirrel, thanks for the great work! I have tried to use your spreadsheet, but I always get the wrong age in the "all positions" sheet. In the "age in days" sheet everything is still correct, but after that it is not transferred correctly. So players who are actually 18 are shown as 16 year olds. Do you know what the problem could be?
I copy the data as shown in the video into the "From Scoring" and "DOB view" sheets. Then I go to "age in days" and change the date to the one in my save. All of the ages for the players are correct but when I go to "all positions" the ages for the players are wrong. For example in my save I am on the 29th of Nov 2029, and Tariq Fosu is 34 years old but in "all positions" it tells me that hes 18.5 years old. I go to "age in days" and it says "age by days" is 34.6, "age to use" is 34.6, lower bound is 34, and upper bound is 35. So I'm not sure where 18.5 comes from
I've got a question about the trajectory sheet: is it normal for the percentages to fluctuate? Like I signed a Czech wonderkid, who was on like 110 %. Half a year later, he's only on 99 %. Did he develop badly within six months or have I maybe don't something wrong with pasting the data and such? But that sheet, as well as your app, has been a game changer for me. I uncovered a lot of gems on this year's FM and had lots of fun with it. Thank you!
Hmm I don't think I've seen that much fluctuation. Would be good if it did - player development in FM is a bit too linear to my mind. Might simply be a typo
i know this is an older video, just a random question. Do you play every game? or sim/holiday some? I'm amazed at how many seasons you have progressed through
I play the games while I'm seeing what I've got at the start of the season / what adjustments to make and then often instant result from there, playing the games for more important matches only. The skin I use (TCS) makes that really easy. In the case of this Arsenal save once I got the squad in good shape the premier league fixtures I could instant result and I would focus on the champions league until I won it
Hey. This looks brilliant. I play on the xbox version and annoyingly the downloadable views (all attributes/dob etc) cannot be imported (to my knowledge). Is it possible to provide a list of the required attributes/columns and i could create the views from scratch in my save manually? I could then try to save the data and try out your app. Please let me know. 😊
@@squirrel_plays_fof4318 hi. Thanks for responding. I was able to manually create your views in my Xbox cloud save but yes as you say, it seems impossible to export the data from the game. Such a disappointment MS don't have this feature for this version.
I'm not going to do all positions - it's a lot of work. But if you look at the spreadsheet you'll see the trajectories for the forward line positions (afa and inside forward) are quite similar to each other and that all the other outfield player positions (i.e. the midfielders and the defenders) are a step lower and similar to each other also. So if you simply said 'attackers', 'other outfield players' and 'goalkeepers' and just used those three curves I think it would work well enough to be useful. Hopefully its fairly clear how you might tweak the spreadsheet to make it do that
@@squirrel_plays_fof4318 Yes, but I still don't know what difference there would be between let's say SVa and DMs which I need. Or between WBs and FBa. Maybe where do you have the ratings for your positions from? So that I can use that as a source/starting point.
Unfortunately I've noticed since playing FM for years now, in FM24 the attributes and stats don't seem to be as accurate as in the past. For me it's how they play in game which determines there value to my team.
I play the games early on to see enough of how good the team is / players are and then I'm all about the instant result button except for the CL knockout games
Hi mate, having trouble getting this to work, copied your spreadsheet to make my own but when I copy fm data in I don’t get any results. Am I doing something stupid? Is there an easier way to copy your spreadsheet?
In google sheets go to File > Make a copy then that will get you your own version of the spreadsheet. Then follow the vid from 23:47 onwards. Good luck with it
I can only get trajectories for the roles in your system even though in the 'from scoring system' tab I have my roles. How do you change them to fit other player roles?
You can tweak the spreadsheet - if you do I think a three-way split of 'forwards', 'other outfield players' and 'goalkeepers' will make enough sense. In the work I did forwards have slightly higher scores than other outfield players as you'll see in the numbers
Hi loving the videos and have actually now started to use this approach to FM. On this one following steps it’s not pulling through the correct age. So play downloaded and copied is 21 on the filter comes up at 28. Any ideas?
Check to make sure dates are taken correctly on the age in days sheet. I'm from the US and my sheet was swapping the days and months because of how its displayed in game.
It’s off, yeah. But if you have masking on it will still work - it will take the middle of the various ranges you can see in game. So I would then use it to direct the scouts at the most interesting prospects and then recalc it once they have been scouted
@@squirrel_plays_fof4318 Nice! Was just checking. Great video. I use the app all the time (especially when I move clubs in game to give me that initial baseline). Currently at Roma on a Journeyman with little to no money so this could really help ramp up the trading. Thanks!
Hmm. Not sure why that would happen. Working ok here. Have a go at saving a fresh version of the spreadsheet from the link - make sure you're playing the game in the english language and in £
@@squirrel_plays_fof4318 Thanks for replying - appreciate your time. I've followed the issue further through (I have downloaded to use in Excel as am on Windows)... on the 'age_in_days tab, column B, C, D and E don't update. When I put my squad in, I'm still left with the dates of your Arsenal squad (and your about 15 years ahead which is what caused the issue above!) Not sure if this is an issue with my excel or if you'd just recommend using Sheets? I could manually input it I suppose
I am new to the game and I have a hard time understanding on how to know which players to add to a shortlist. I have some scouting results in the Scouting - players - scouting players section, but your filter is for a shortlist. How would I determ on adding which person to a shortlist? If someone could explain this to me, that would be highly appreciated.
There's the player search screen and then there's the shortlist screen, but they are different from each other. Generally filters are for the player search screen and the idea is you're filtering down from all the players your club knows about to a list of players with some specific characteristics you're looking for. You can also filter within a shortlist IYSWIM
If there's a range it will take the middle of the range. If it's not known it will take zero - so players who are more scouted will have higher numbers. Genie scout is different in that it looks at CA and PA which this doesn't...this only looks at stuff you can see for yourself in game and goes from there
How long would you say it would take to implement this data driven style to an existing save that’s let’s say roughly 9/10 years in? I am managing in Poland and after a good couple of UCL runs I thought buying the hear and now £10m-£15m players was the way to go but I have tanked the finances and these players are leaving for 60% less the following season as my rep is still 3.5*
Time to implement fully = around the typical contract length at the level you're at, as that's how long it takes to churn an entire squad. In English football that's 4-5 years at premier league level, 2-3 years at championship level, 1-2 years at League 1 to conference level, 1 year below that. Bear in mind player value in the game depends on club reputation. If you sell young players to bigger clubs make sure you've got % of profit clauses that you can monetise later. If managing in Poland I'd be reading the foreign player rules for the league closely and going from there. Probably have half the squad ending up as cheap Paraguayans and Bolivians lol. If you ping me on twitter @playingsquirrel I'd be up for taking your save file and seeing what I would do with it and maybe making a video based on that - ? Suggesting some players to sign etc. Would be fun
Obvs if you prefer geniescout go for it, but for me I prefer to only use stuff that I can see from the game - this spreadsheet just does a re-calc based on stuff I can see so not CA and PA
Remember ability score outside of striker does not calculate ACC & Pace. This is what is wrong with CA/PA and Star ratings. Fm Arena and the Chinse Devs have covered this. The Chinese test was in a tactic with 0 Strikers and 0 players trained at striker because their CA/PA does calculate Acc/Pace but for example your Ball Player wont calculate speed at all. And we all know speed is the highest weighted metric at every position. Now if Money is no object typically the best wonderkids that cost the most money already have high physicals. But say for central defender all you really need is Acc/Pace/Jumping just those 3. So low league or Low nation you can go find those cheap gems that get you like 90% of a UCL player that costs >100 million and you bought him for like 500k. Plus once you deep dive how FM creates players it is completely unbalanced. You will notice the elite strikers can basically play any position on the pitch at the elite level. It is just how the game generates them. They will have high physicals and either having Jumping or not. IF they have Jumping that can play Ball Player Defender better then any newgen defender can. Positioning Marking and Tackling dont mean that much in the match engine. So if you retrain a Striker who has all 17s for physicals and maybe 14 jumping he will also have high everything else except those 3 "defense" attributes but he will be WorldClass and the best defender in the game.
Good Q, thanks. I should have included this in the video. No they don't - you need 3 years at the club between 15 and 21 to get 'home grown at club' status and in a 25-man champions league squad there are four slots only for players with that status. If you sign non-UK under 18 players as an English club they will only sign after their 17th birthday (I think) and they will only join the club on their 18th birthday. If you leave them at the club for three years they will get to 'home-grown at club' at or around their 21st birthday. But of course you don't get the benefits of loaning them out. In my save I've been ensuring at all times I have four 'home grown at club' guys - typically through the academy - but having a few signed guys that I don't send out on loan until they are older than 21 to ensure we've got a healthy stock of them in the pipeline, IYSWIM
Good spot! Yes it is. When I did the original views for this I left out the communication attribute in error. Seeing as it has had lots of downloads I've left it like that to avoid having it break for people...my keepers have done fine without it being included but yes strictly speaking it should be in there, with a weighting of 1
@@squirrel_plays_fof4318 Is this something that could be easily added to the app? No worries if not, I recognize that it won't have a big impact on the goalkeeper scores. Although I do like to give communication a weighting of 3 in my scoring rather than 1 :)
LOL the app I won't change as it has thousands of users already...if you want to be super-precise you could just go back to my early vids, get the underlying code and then amend that as you want to
is any one else having issues getting the spreadsheet working, im not getting any trajectory values on the all positions sheet, also how do you input your own squad data
One immediate thought - make sure you save your own version of the spreadsheet before you try to edit it as it's locked as view-only in the version I shared. Failing that have a go at following the instructions in the latter part of the video and if you get something that doesn't work do have a go at describing the problem here please and I'll see if I can help with it, cheers
@@squirrel_plays_fof4318 i got it working it was an error on my side forgot to change the positions in the scoring app, working perfectly now. Amazing work as always thanks
I'm having the same issue with the trajectory values. Can see the current % but not trajectory. If I figure it out I'll reply again to this comment. To get values for your own squad, do the "all attributes squad" view and upload it on the webpage and copy the results to the spreadsheet the same way you did for the shortlist view, then do the "date of birth and nationality squad" view and put it in the relevant spreadsheet tab
Hello again, I've got it working! Here are the steps I went through to get it working: 1. Must go through the tabs in order! I originally had the DOB shortlist view in age of days, so the recommended tab messed everything up 2. Some players in the age_of_days tab did not have values for anything between "age_of_days" and "% of new year". I don't know why they didn't, they show on shortlist, I redid the upload a few times, etc. Some just didn't have values. Players MUST HAVE values for at least age of days and age to use to produce trajectory values. Filling in the other age related values gives you a more precise trajectory value. 3. It only shows position trajectories for the positions squirrel uses. If you did not have any positions selected when you uploaded the file, or have different positions, it won't give values for any position - but you will still get a max trajectory for their highest role score. If you want trajectories for your own roles, you'll have to alter the trajectory tab in the spreadsheet with your own values - can't give advice here, this will be whatever you deem important. Hope this helps!
I noticed a bug in the scoring system app, sorting by wage only takes the first number and not the entire value (so 1,000 is next to 100,000 followed by 2,000 and so on) is there a way to fix that?
Couple tips for non brits: Make sure the days and months are going to the correct columns in the age_in_days sheet and make sure that all full dates on the sheet are in the same format.
On the all positions sheet, if you aren't seeing the value for any players, make sure that the high values are being taken on the skd sheet
I was having trouble with the extraction of the high values because Im from the us and the symbols were, of course, the dollar sign and not the pound symbol. I had no clue what the code was for that column, and so i replaced it with:
=iferror(index(split(t#, "- $"),2)," ") where the # is the row number. If using a money sign that's not $ just swap it in this line.
Nicely figured out - yes this is right you need it UK-way round for dates (dd/mm/yyyy) and in £. Thanks for posting it up for others
@@squirrel_plays_fof4318 I'm not getting the low or high in your spreadsheet and I'm using £😩
Felt ages since last video, welcome back mate
Thank you for transforming my FM for this year! Amazing work! Hopefully more of the same coming our way.
Thanks for this, it's a truly exceptional video. The last time I played FM before 2024 was in 2012 where I played Wrexham and took them to the prem (played them before they were cool, a real hipster) cos they had the biggest stadium in the lower leagues, I always wondered if this was why they got bought out!
The only other video of yours I've seen was the original roles/player scoring video and it's helped me immensely. I'm playing as my hometown club Leicester and have just won a prem/FA cup double in 2026 and a prem/FA/league cup triple in 2027 without scumming so I'm delighted. The board have announced a new stadium and this will help me keep the finances on track while aiming for the next goal - a champions league trophy (only gotten to ro16 so far).
It took a bit of value fiddling in excel as I play a different style of football (lots of wing play, target forward, big lads for set pieces and lots of set piece routines/goals - set pieces seem brokenly good, Lorenzo Lucca is my 25+ goal a season wonder, Harry Souttar gets 15 goals a season!) and the roles don't line up, but just having the spreadsheets and role scores as a baseline is incredible, thank you so much.
hi squirrel, i've been using your app for the past few months and it's just awesome. Thanks for the work you're doing!
No worries mate, glad you enjoy using it
Love your stuff. I think this sort of stuff just adds another layer to narrowing in on which players to invest in
Even though I play on console I still watched this fascinated by the process and detail. Amazing work
Thanks squirrel. I was certainly puzzled by how you created the trajectory until the end. I'm on my first ever Pentagon challenge and only just qualified for the first continental champions league after 3 consecutive league wins in Japan using your principles to find players. Not using your tactics though, so I've had to adapt.
Been a while, glad you're giving us more wisdom
Most interesting FM vid I've seen in ages
Really really good stuff. Cheers
Can you do more of these videos with the present database? I don’t even play FM but I love watching it and your data driven approach is so interesting
you could even do 5 year saves where you take underperforming / ageing squads and turn it into one of the best ITW, even better if you experimented more with formations to get some variety and adapt your methods to other systems / team playstyles
to go even further you could upload those saves for channel supporters
Cool ideas, thanks
Nice, you are back 🎉🎉🎉
Can see plenty of people are adapting the spreadsheet to their own save / tactic - I've just posted a thread on twitter @playingsquirrel with tips on how to do that. Good luck!
So you are saying I need a twitter account? 😦 Do you think you will be able to produce another site or modify the previous, which has the trajectory capability? I'm using IFB-D, BWM-D, AP-S, IF-A, AM-S so I've been trying to understand the technical aspects to modify to suit. Suppose it gets you more views though... 😂
@@mabozar15 What I've done myself is that I've created a list of all the players of the top 5 leagues, put it into the scoring system, exported that and then filtered for each position by age and took the best 50 players per age group and took the average of those to create my thresholds. For goalkeepers, I exported an extra list with all gks in the database as those of the top 5 leagues are too small of a sample size to create thresholds by age group.
@seromg1175 yeah, I may do something like that, but possibly just go on holiday for a year and take the progression rates for those selected players. Cheers
Inspirational work
Really interesting video! Quick question: How did you create the trajectories for the positions? I would like to do the same myself for the tactic I use.
I studied 4000 newgens and calc'd from there - see this vid: ua-cam.com/video/xwMRimb1Jlo/v-deo.html
@@squirrel_plays_fof4318 Thanks! Did you use the existing PL players from the beginning of the game as a benchmark, or are the averages solely based off of the development of the batch of players you followed?
@@broedblings solely the newgens...it's not pin-sharp accurate but it's plenty close enough to be useful in my experience
@@broedblings Just the guys I followed. I'm keeping an eye on my current save to see if it makes sense, and I'm pretty sure it does. But all comments welcomed of course
is there a miscalculation with the BPD? strikers and wingers with no defence are getting highest results for me, and Pelaez is your best BPD on the original
Not that I can easily see - it's working for me - can you point to an example?
The messiah returns
Great video as usual. Would be interesting to see how different star ratings of potential, combined with your app's rating of a players ability at a particular age, affects the end point of a player's development.
I imagine on your pen and paper graph, you'd see different gradients for different potential abilities.
That's if star potential ratings can be trusted of course...
Yeah I have no idea how much to trust the star ratings even after doing all this. Certainly not entirely. The sort of rigour one would need to test that out strays into EBFM territory. For now I'm still trying to use the star ratings and this together
Excellent video as usual! I downloaded the views, however, the DOB & Nationality ones are not showing on my FM. I'm on FM23 not sure if that has anything to do with it.
Hmm dunno...I haven't tried to do it on FM23. If you make a really simple view with the date of birth as the fourth column over it ought to work - that's all the spreadsheet really needs to see (column D). If you add nationality in columns E and F (fifth and sixth) it will look to see if UK and Ireland, that's only if you care about that - I do as signing 'domestic' (=UK + Ireland) under 18s is allowed but not foreign for an English club
Hi squirrel, thanks for the great work!
I have tried to use your spreadsheet, but I always get the wrong age in the "all positions" sheet. In the "age in days" sheet everything is still correct, but after that it is not transferred correctly. So players who are actually 18 are shown as 16 year olds. Do you know what the problem could be?
I'm having the same issue lmk if you figure it out
Hey. Not sure I follow you here - can you be a bit more specific please?
I copy the data as shown in the video into the "From Scoring" and "DOB view" sheets. Then I go to "age in days" and change the date to the one in my save. All of the ages for the players are correct but when I go to "all positions" the ages for the players are wrong. For example in my save I am on the 29th of Nov 2029, and Tariq Fosu is 34 years old but in "all positions" it tells me that hes 18.5 years old. I go to "age in days" and it says "age by days" is 34.6, "age to use" is 34.6, lower bound is 34, and upper bound is 35. So I'm not sure where 18.5 comes from
@@dre595 Hmm me neither. Try saving a fresh one from the link and trying again. Also check you're playing FM in the English language and in £
I found the solution. I had the format of my date set as month/day/year so I had to switch it to day/month/year and now it works perfectly
I've got a question about the trajectory sheet: is it normal for the percentages to fluctuate? Like I signed a Czech wonderkid, who was on like 110 %. Half a year later, he's only on 99 %. Did he develop badly within six months or have I maybe don't something wrong with pasting the data and such?
But that sheet, as well as your app, has been a game changer for me. I uncovered a lot of gems on this year's FM and had lots of fun with it. Thank you!
Hmm I don't think I've seen that much fluctuation. Would be good if it did - player development in FM is a bit too linear to my mind. Might simply be a typo
Could you do the trajectory points of all the positions? I know it would be a lot of work but it would help a lot! 🙏
i know this is an older video, just a random question. Do you play every game? or sim/holiday some? I'm amazed at how many seasons you have progressed through
I play the games while I'm seeing what I've got at the start of the season / what adjustments to make and then often instant result from there, playing the games for more important matches only. The skin I use (TCS) makes that really easy. In the case of this Arsenal save once I got the squad in good shape the premier league fixtures I could instant result and I would focus on the champions league until I won it
The spreadsheet is view only ??
Hey. This looks brilliant. I play on the xbox version and annoyingly the downloadable views (all attributes/dob etc) cannot be imported (to my knowledge). Is it possible to provide a list of the required attributes/columns and i could create the views from scratch in my save manually? I could then try to save the data and try out your app. Please let me know. 😊
Afraid I think there was someone in the comments who tried and failed to make this work on xbox
@@squirrel_plays_fof4318 hi. Thanks for responding. I was able to manually create your views in my Xbox cloud save but yes as you say, it seems impossible to export the data from the game. Such a disappointment MS don't have this feature for this version.
Great video once again, thanks for that. One question - is it possible to add trajectory ratings for other positions as well please?
I'm not going to do all positions - it's a lot of work. But if you look at the spreadsheet you'll see the trajectories for the forward line positions (afa and inside forward) are quite similar to each other and that all the other outfield player positions (i.e. the midfielders and the defenders) are a step lower and similar to each other also. So if you simply said 'attackers', 'other outfield players' and 'goalkeepers' and just used those three curves I think it would work well enough to be useful. Hopefully its fairly clear how you might tweak the spreadsheet to make it do that
@@squirrel_plays_fof4318 Yes, but I still don't know what difference there would be between let's say SVa and DMs which I need. Or between WBs and FBa. Maybe where do you have the ratings for your positions from? So that I can use that as a source/starting point.
Have a look at the 'trajectory' tab in the spreadsheet and this video: ua-cam.com/video/xwMRimb1Jlo/v-deo.html
Wonder how you use the Data Hub then, I felt that is a sort of black box, but someone understanding it could have a big advantage.
I don't much - but perhaps I should
Unfortunately I've noticed since playing FM for years now, in FM24 the attributes and stats don't seem to be as accurate as in the past. For me it's how they play in game which determines there value to my team.
2044 is crazy, do you play every game of sim the seasons?
I play the games early on to see enough of how good the team is / players are and then I'm all about the instant result button except for the CL knockout games
I wish SI gave us the ability to create "meta columns", in which we could do calculations like these in game...
Great idea
how does the spreadsheet work out the trajectory for each player? What criteria is it using to analyse that?
Have a look here - I tracked 4,000 newgens to see what their careers looked like and went from there ua-cam.com/video/xwMRimb1Jlo/v-deo.html
how do i change from view only ?
How do i add positions according to my tactic in the all positions tab?
If you look at my twitter feed I posted a thread with thoughts on how to do that
Hi mate, having trouble getting this to work, copied your spreadsheet to make my own but when I copy fm data in I don’t get any results. Am I doing something stupid? Is there an easier way to copy your spreadsheet?
In google sheets go to File > Make a copy then that will get you your own version of the spreadsheet. Then follow the vid from 23:47 onwards. Good luck with it
I can only get trajectories for the roles in your system even though in the 'from scoring system' tab I have my roles. How do you change them to fit other player roles?
You can tweak the spreadsheet - if you do I think a three-way split of 'forwards', 'other outfield players' and 'goalkeepers' will make enough sense. In the work I did forwards have slightly higher scores than other outfield players as you'll see in the numbers
@@squirrel_plays_fof4318 Super, thanks!
Hi loving the videos and have actually now started to use this approach to FM. On this one following steps it’s not pulling through the correct age. So play downloaded and copied is 21 on the filter comes up at 28. Any ideas?
Hmm not immediately. Others have found saving another fresh version from the link, do 'make a copy' again and run it again works for them
@@squirrel_plays_fof4318 will give it a try, also please more content love this side of it 🙏
Check to make sure dates are taken correctly on the age in days sheet. I'm from the US and my sheet was swapping the days and months because of how its displayed in game.
@@bogus1896 will have a check, haven’t been on yet this week.
Can you put the dob and nationality view for download
www.mediafire.com/file/3xzg1top0gqrrl4/All_attributes_and_DoB_views.zip/file
@@squirrel_plays_fof4318 Thank you!
So do you play with attribute masking off or is this once scouted?
It’s off, yeah. But if you have masking on it will still work - it will take the middle of the various ranges you can see in game. So I would then use it to direct the scouts at the most interesting prospects and then recalc it once they have been scouted
@@squirrel_plays_fof4318 Nice! Was just checking. Great video. I use the app all the time (especially when I move clubs in game to give me that initial baseline). Currently at Roma on a Journeyman with little to no money so this could really help ramp up the trading. Thanks!
@@squirrel_plays_fof4318 Changing the date to 29/10/2029 in mine is causing the positions tabs to stop picking up The Bench Low score in column Q.
Hmm. Not sure why that would happen. Working ok here. Have a go at saving a fresh version of the spreadsheet from the link - make sure you're playing the game in the english language and in £
@@squirrel_plays_fof4318 Thanks for replying - appreciate your time. I've followed the issue further through (I have downloaded to use in Excel as am on Windows)... on the 'age_in_days tab, column B, C, D and E don't update. When I put my squad in, I'm still left with the dates of your Arsenal squad (and your about 15 years ahead which is what caused the issue above!) Not sure if this is an issue with my excel or if you'd just recommend using Sheets? I could manually input it I suppose
I am new to the game and I have a hard time understanding on how to know which players to add to a shortlist. I have some scouting results in the Scouting - players - scouting players section, but your filter is for a shortlist. How would I determ on adding which person to a shortlist?
If someone could explain this to me, that would be highly appreciated.
There's the player search screen and then there's the shortlist screen, but they are different from each other.
Generally filters are for the player search screen and the idea is you're filtering down from all the players your club knows about to a list of players with some specific characteristics you're looking for.
You can also filter within a shortlist IYSWIM
What if the attributes are hidden?? Can we use this with genie scout??
If there's a range it will take the middle of the range. If it's not known it will take zero - so players who are more scouted will have higher numbers. Genie scout is different in that it looks at CA and PA which this doesn't...this only looks at stuff you can see for yourself in game and goes from there
How long would you say it would take to implement this data driven style to an existing save that’s let’s say roughly 9/10 years in?
I am managing in Poland and after a good couple of UCL runs I thought buying the hear and now £10m-£15m players was the way to go but I have tanked the finances and these players are leaving for 60% less the following season as my rep is still 3.5*
Time to implement fully = around the typical contract length at the level you're at, as that's how long it takes to churn an entire squad.
In English football that's 4-5 years at premier league level, 2-3 years at championship level, 1-2 years at League 1 to conference level, 1 year below that.
Bear in mind player value in the game depends on club reputation. If you sell young players to bigger clubs make sure you've got % of profit clauses that you can monetise later.
If managing in Poland I'd be reading the foreign player rules for the league closely and going from there. Probably have half the squad ending up as cheap Paraguayans and Bolivians lol.
If you ping me on twitter @playingsquirrel I'd be up for taking your save file and seeing what I would do with it and maybe making a video based on that - ? Suggesting some players to sign etc. Would be fun
also what is the diffrence between using player trajectory and just using an app like geniescount to just buy all the highest PA wonderkids
Obvs if you prefer geniescout go for it, but for me I prefer to only use stuff that I can see from the game - this spreadsheet just does a re-calc based on stuff I can see so not CA and PA
Remember ability score outside of striker does not calculate ACC & Pace. This is what is wrong with CA/PA and Star ratings. Fm Arena and the Chinse Devs have covered this. The Chinese test was in a tactic with 0 Strikers and 0 players trained at striker because their CA/PA does calculate Acc/Pace but for example your Ball Player wont calculate speed at all. And we all know speed is the highest weighted metric at every position.
Now if Money is no object typically the best wonderkids that cost the most money already have high physicals. But say for central defender all you really need is Acc/Pace/Jumping just those 3. So low league or Low nation you can go find those cheap gems that get you like 90% of a UCL player that costs >100 million and you bought him for like 500k.
Plus once you deep dive how FM creates players it is completely unbalanced. You will notice the elite strikers can basically play any position on the pitch at the elite level. It is just how the game generates them. They will have high physicals and either having Jumping or not. IF they have Jumping that can play Ball Player Defender better then any newgen defender can. Positioning Marking and Tackling dont mean that much in the match engine. So if you retrain a Striker who has all 17s for physicals and maybe 14 jumping he will also have high everything else except those 3 "defense" attributes but he will be WorldClass and the best defender in the game.
Do youngsters you sign then immediately loan out get the trained at club status?
Good Q, thanks. I should have included this in the video.
No they don't - you need 3 years at the club between 15 and 21 to get 'home grown at club' status and in a 25-man champions league squad there are four slots only for players with that status.
If you sign non-UK under 18 players as an English club they will only sign after their 17th birthday (I think) and they will only join the club on their 18th birthday.
If you leave them at the club for three years they will get to 'home-grown at club' at or around their 21st birthday. But of course you don't get the benefits of loaning them out.
In my save I've been ensuring at all times I have four 'home grown at club' guys - typically through the academy - but having a few signed guys that I don't send out on loan until they are older than 21 to ensure we've got a healthy stock of them in the pipeline, IYSWIM
I tried editing the goalkeeper role in the Player Scoring app but I can't find the Communication attribute. Is this a bug?
Good spot! Yes it is. When I did the original views for this I left out the communication attribute in error. Seeing as it has had lots of downloads I've left it like that to avoid having it break for people...my keepers have done fine without it being included but yes strictly speaking it should be in there, with a weighting of 1
@@squirrel_plays_fof4318 Is this something that could be easily added to the app? No worries if not, I recognize that it won't have a big impact on the goalkeeper scores. Although I do like to give communication a weighting of 3 in my scoring rather than 1 :)
LOL the app I won't change as it has thousands of users already...if you want to be super-precise you could just go back to my early vids, get the underlying code and then amend that as you want to
is any one else having issues getting the spreadsheet working, im not getting any trajectory values on the all positions sheet, also how do you input your own squad data
One immediate thought - make sure you save your own version of the spreadsheet before you try to edit it as it's locked as view-only in the version I shared.
Failing that have a go at following the instructions in the latter part of the video and if you get something that doesn't work do have a go at describing the problem here please and I'll see if I can help with it, cheers
@@squirrel_plays_fof4318 i got it working it was an error on my side forgot to change the positions in the scoring app, working perfectly now. Amazing work as always thanks
I'm having the same issue with the trajectory values. Can see the current % but not trajectory. If I figure it out I'll reply again to this comment.
To get values for your own squad, do the "all attributes squad" view and upload it on the webpage and copy the results to the spreadsheet the same way you did for the shortlist view, then do the "date of birth and nationality squad" view and put it in the relevant spreadsheet tab
@@squirrel_plays_fof4318 Thanks mate got it working it was my mistake wrong positions in the score calculator, Great work like all ways
Hello again, I've got it working! Here are the steps I went through to get it working:
1. Must go through the tabs in order! I originally had the DOB shortlist view in age of days, so the recommended tab messed everything up
2. Some players in the age_of_days tab did not have values for anything between "age_of_days" and "% of new year". I don't know why they didn't, they show on shortlist, I redid the upload a few times, etc. Some just didn't have values. Players MUST HAVE values for at least age of days and age to use to produce trajectory values. Filling in the other age related values gives you a more precise trajectory value.
3. It only shows position trajectories for the positions squirrel uses. If you did not have any positions selected when you uploaded the file, or have different positions, it won't give values for any position - but you will still get a max trajectory for their highest role score. If you want trajectories for your own roles, you'll have to alter the trajectory tab in the spreadsheet with your own values - can't give advice here, this will be whatever you deem important.
Hope this helps!
'promosm' 🤔
Професионален cheat, т.е. пълен некадърник.
Isn't that cheating? 😅
Homie they call it 'analytics' LOL
I noticed a bug in the scoring system app, sorting by wage only takes the first number and not the entire value (so 1,000 is next to 100,000 followed by 2,000 and so on) is there a way to fix that?
...not straightforwardly...it isn't designed to be sortable by wage I'm afraid