Jump to content
Sports Interactive Community

Search the Community

Showing results for tags 'attribute tracking'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Football Manager General Discussion Forums
    • Football Manager General Discussion
    • Football Manager Touch General Discussion
    • Football Manager Mobile General Discussion
  • Football Manager Technical Help and Bugs Forum
    • Football Manager 2019 Bugs Forum
    • Football Manager 2019 Touch Bugs Forum
    • Football Manager Mobile Technical Help and Bugs Forum
    • FMdB Bugs Forum
    • Football Manager Previous Versions Technical Issues
    • Public Beta Forum
  • Football Manager - Help Us Make FM Even Better
    • Football Manager Feature Requests
  • Football Manager Game Help Forums
    • Tactics, Training & Strategies Discussion
    • Good Player & Team Guide
    • Editors Hideaway
    • Skinning Hideout
  • Football Manager Specific Playing Styles
    • FM Career Updates
    • Challenges, Sign-Ups & Experiments
    • FM Online
    • FM Stories
  • Football Manager Local Language Forums
    • Football Manager Chinese Language Discussion
    • Football Manager - Deutschsprachiges Forum
  • Eastside Hockey Manager
    • General Questions for Eastside Hockey Manager
    • Eastside Hockey Manager Bugs Forum
    • Eastside Hockey Manager FAQ and Knowledgebase
  • The Community
    • Football Manager Fansites and Community Links
  • Non SI/Football Manager Related
  • House Rules and Forum Guidelines
  • Forum Software Issues
  • Reference

Categories

  • Articles
  • Other Football Game
    • More football stuff

Categories

  • Football Manager 2019
    • Getting Started
    • How To
    • Technical Support
    • Pre-Release Beta Specific Questions
  • Football Manager 2019 Touch
    • iOS
    • Android
    • Cross-Sync
    • Store and Unlockables
    • Nintendo Switch
  • Football Manager 2019 Mobile
    • Android
    • iOS
  • Football Manager 2018
    • Getting Started
    • How To
    • Technical Support
    • Gameplay
    • Pre-Release Beta Specific Questions
  • Football Manager Touch 2018
    • iOS
    • Android
    • Nintendo Switch
    • Cross-Sync
    • Store and Unlockables
  • Football Manager Mobile 2018
    • iOS
    • Android
  • Football Manager 2017
    • Getting Started
    • Pre-Release Beta Specific Questions
    • How To
    • Gameplay
    • Technical Support
  • Football Manager Touch 2017
    • iOS
    • Android
    • Cross-Save
    • Store & Unlockables
    • Compatible Devices
  • Football Manager Mobile 2017
  • Football Manager 2016
  • Football Manager Touch 2016
  • Football Manager Mobile 2016

Categories

  • Football Manager 2019
  • Football Manager 2019 (FR)
  • Football Manager 2019 (DE)
  • Football Manager 2019 (IT)
  • Football Manager 2019 (ES)
  • Football Manager 2019 Touch
  • Football Manager 2019 Touch (FR)
  • Football Manager 2019 Touch (DE)
  • Football Manager 2019 Touch (IT)
  • Football Manager 2019 Touch (ES)
  • Football Manager Mobile 2019
  • Football Manager 2018
  • Football Manager 2018 (FR)
  • Football Manager 2018 (IT)
  • Football Manager 2018 (ES)
  • Football Manager Touch 2018
  • Football Manager Touch 2018 (FR)
  • Football Manager Touch 2018 (IT)
  • Football Manager Touch 2018 (ES)
  • Football Manager Touch 2018 (Console)
  • Football Manager Mobile 2018
  • Football Manager 2017
  • Football Manager Touch 2017
  • Football Manager 2017 (FR)
  • Football Manager 2017 (IT)
  • Football Manager 2017 (ES)
  • Football Manager Touch 2017 (FR)
  • Football Manager Touch 2017 (IT)
  • Football Manager Touch 2017 (ES)
  • Football Manager Mobile 2017

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Biography


About Me


Interests


Favourite Team


Currently Managing

Found 1 result

  1. 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
×
×
  • Create New...