Search the Community
Showing results for tags 'attribute tracking'.
Found 1 result
Hi All, Being relatively new to FM, I've been looking for some tools/ideas to help me track player development. Now, either my search-fu has failed me, or there really isn't a lot out there. I myself am more of a visual type of person, but then that only works if you remember to go and look every so often to see whats changed amongst your players attributes. Yes, a colored arrow moving up or down is nice, but it's not to detailed, And while this is a nice presntation of information: trying to use it to track one player at a time is annoying. Luckily, there's Excel. Here's what I do. First, you set up an 'Attributes' view in squad. Like this: Then under the FM menu, you're going to select "Print Screen", and save as a webpage. I have a reminder set up for the first of each month, so I save the file as 'MonthYear', ie 'May2023' Open excel, drag the recently exported html file in, and after a little editing, you will get something like this: NOTE: IT IS VERY IMPORTANT THAT THE ATTRIBUTE COLUMNS IN YOUR SPREADSHEET REMAIN IN THE SAME ORDER FROM TAB TO TAB. Why yes, I did learn this the hard way. So, the above is a screenshot of my roster from May, 2021. This a screenshot of my roster from May, 2023: Take a look at the guy at the very bottom, Zeca Gomes. In May of 2021 he was a 16 year old D(L). Some tutoring and first team playing time later, he's really improved. I can tell by the amount and gradations of green, and lack of orange and red. The key to this is Conditional Formatting. First, you highlight your attribute data. I usually go a few lines more because you can add or lose players, and your roster size will always change. In my case, I go from C2:AL98 Once highlighted, you go to Home ->Conditional Formatting -> New Rule. This equation is the basis for all your formatting: =C2<(VLOOKUP($A2,'May2023'!$A$2:$AL$82,COLUMN(),0)-1) What this is saying, in laymans terms, is look at the value of the cell in C2. If the value of the cell in C2 associated with the name in A2 (on the sheet names May 2023 in the data contained within A2:AL82, and while your at it also compare all the other values in the columns associated with the name in A2 as well), minus 1, is less than the value in C2, format the cell in this color. It should look like this: You use the formatting option to choose your color/fill/font schema. The rest of the changes are just variation on the first formula. =C2<VLOOKUP($A2,'May2023'!$A$2:$AL$82,COLUMN(),0) will return results that are 1 less than the number being looked at. =C2>VLOOKUP($A2,'May2023'!$A$2:$AL$82,COLUMN(),0) will return results that are 1 more than the number being looked at. =C2>(VLOOKUP($A2,'May2023'!$A$2:$AL$82,COLUMN(),0)+1) will return results that are 2 more than the number being looked at. The only other thing I do is make sure the formulas are in the following order: So, going back to the above, if you look at Zeca Gomes, in two years his Cor, Cro, Dri, Fin, Fre and Hea have all gone up by +1, while his Lon has gone up by +2 And the nice thing is about this formatting is that if a persons name isn't found, it's not going to screw anything up. If I were to remove Zeca Gomes from my May2021 tab, in May 2023 he would have no color changes. I've found this handy in that if I am training a specific attribute, once it raises by +1 or even +2, I can immediately stop training it and move onto a different attribute. It also let me know that if after three months of training a particular attribute, if it doesn't change it probably won't, so don't waste any more time training on it. You can add as many columns to the right as you want, i'm looking at adding the training columns and a column for tutoring myself, in addition to personality. If you think this is something you can use, I've attached a basic version of the spreadsheet. Play around with it, use it, add to it if you have improvements. If you've got a method you use, by all means lets share. Thanks for looking and commenting, Jellico73 SquadAttributesTestSheets.xlsx