Chat Creating a Role Suggester (Beta in Replies)

[TrueHiiro]

Hey everyone, I'm currently going through the progress of making a spreadsheet that gives your players a rating out of 20 at all roles in the game (purely based on the face attributes) Does anyone have any suggestions on things I should add such as weighted attributes (Some attributes are more important than others for a role) or should I just release the spreadsheet as is?

Just in case anyone was wondering how it would work, you simply input your players attributes and it auto generates the ratings for the roles and creates a radar graph (like the one in full FM) comparing parts of their game. You can do this with up to 2 players (but I could implement more if people want that functionality)

Edited May 28, 2020 by TrueHiiro
Screenshots of my spreadsheet and punctuation errors

[Don-x]

Nice you already covered the playing Roles, go ahead and release it. Or beta for testing.

[TrueHiiro]

Quote

Nice you already covered the playing Roles, go ahead and release it. Or beta for testing.

ok

Edited May 28, 2020 by TrueHiiro

[TrueHiiro]

Beta of the spreadsheet, make sure to let me know of any bugs. To edit the spreadsheet you will have to save a copy of your own. If you need further instructions and google can't help then I'll help as much as I can https://docs.google.com/spreadsheets/d/1v5J31ArsElFzhuDsEXZLaCfMoSkQ7bKGXX5gqy4cs_8/edit?usp=sharing

[gunnersaur]

Not the hero we deserve but the hero we needed...Great job man fair play for coming up with the idea to do it

[broodje kip]

Nice work man. This looks very helpful to me

[TrueHiiro]

Quick question, does anyone have any ideas on how to calculate potential attributes which would take personality and age into account? Also, if I weighted attributes should I make separate sections that prioritise certain parts of a players game, for example a more physical CB compared to a more technical one? 

Edited May 29, 2020 by TrueHiiro

[TrueHiiro]

10 hours ago, gunnersaur said:

Not the hero we deserve but the hero we needed...Great job man fair play for coming up with the idea to do it

I'm just surprised that no one has done it. It wasn't too hard to do what I've done so far. But future ideas will probably be much tougher

added 0 minutes later

8 hours ago, broodje kip said:

Nice work man. This looks very helpful to me

Thanks, it means a lot

[broodje kip]

8 minutes ago, TrueHiiro said:

Quick question, does anyone have any ideas on how to calculate potential attributes which would take personality and age into account? Also, if I weighted attributes should I make separate sections that prioritise certain parts of a players game, for example a more physical CB compared to a more technical one? 

Not sure as it really depends on how we train the player so we can’t really predict how their attributes will look like

[TrueHiiro]

Just now, broodje kip said:

Not sure as it really depends on how we train the player so we can’t really predict how their attributes will look like

ok, thanks, I'll stick to weighted attributes

[TrueHiiro]

Just started working on role suitability with physicals being more important than other attributes, I will probably release this today or tomorrow before rolling out technical and mental versions once  I'm more familiar with the SUM and SUMPRODUCT functions.

[Rob]

Fascinating concept. 

[C21GERMAIN]

Great job fair play to you🥳

 

[TrueHiiro]

Just started doing the first of the weighted attributes for physicality now that I've got my head around sum and sumproduct along with the vlookup function (yes that V is supposed to be there)

[C21GERMAIN]

Had to analyse the whole squad I created in My Club mode, although I was "blessed" with almost 50% of the squad having above 17 Technique and "cursed" with a large group of unprofessional players.

[TrueHiiro]

On 29/05/2020 at 20:10, C21GERMAIN said:

Great job fair play to you🥳

 

Thanks, it takes a while but it should be worth it

On 30/05/2020 at 17:23, C21GERMAIN said:

Had to analyse the whole squad I created in My Club mode, although I was "blessed" with almost 50% of the squad having above 17 Technique and "cursed" with a large group of unprofessional players.

and that looks rather tedious, I would never be able to do that

[C21GERMAIN]

7 hours ago, TrueHiiro said:

and that looks rather tedious, I would never be able to do that

at this time nothing seems to take long tbf😂