Player Role & Duty Calculator updated for FM15!

[robzilla]

I've done this for every version since FM11 but didn't get round to buying FM15 or even downloading the demo so up until now there hasn't been a version for the latest FM. I've been sending the old versions to people as and when they've asked for it but I had a spare couple of hours this morning so I've downloaded the demo and updated my player role & duty spreadsheet for FM15 and you can download it below.

For those who haven't seen or used it before, this is how it works:

1. Download the spreadsheet and you will find two template sheets - one for outfield players and one for goalkeepers. Duplicate the sheets as necessary (so you'll want 25 "outfield player" sheets if you have 25 outfield players in your first team and as many "goalkeeper" sheets as you have goalkeepers).

2. Rename each sheet with a player's name and fill in the player's name at the top of the sheet (I usually use just the surname as the sheet name, and the full name in the top row of the sheet).

3. For each player, enter their attributes in column B. Their most suitable role/duty combinations (henceforth referred to as "RDC") will be shown in the grid on the right. Simples.

4. At the top next to the player's name it will show their highest average attribute rating for any RDC (useful for quick comparisons or to get an overall idea of the quality of a player) and in the grid below it will highlight in varying shades of green and yellow how that player ranks for every RDC in the game.

The "mean" (average) column is the main one you'll be interested in but I have included median, high and low as these can give you a little more insight into the spread of attributes for a particular RDC, or if a player has a glaring weakness in one area which might be masked by a good average.

In the example sheets included I have entered Diego Costa's attributes in the Outfield Player sheet and IIRC I used Thibault Courtois' attributes for the Goalkeeper sheet. If you look at the Outfield Player sheet you'll see it shows Diego Costa has all the attributes for pretty much any attacking role, but in particular for being a good target man. Same goes for Courtois really for the goalkeeper roles. Maybe they weren't such great examples, but never mind.

As well as analysing your own squad, you can also use the tool to check out a player you might be thinking of signing. I usually keep a spare "scratch" sheet for dropping in the attributes of any player I want to compare to one of my own. So if you're looking for a replacement for an ageing member of your own squad, you can check out his potential replacements and see how good they look compared to your outgoing player.

-----------------------------------------

Bear in mind this is a blunt tool and it applies no weighting to any of the attributes, all are treated equally. I claim no insight into the inner workings of the ME or how it handles player attributes. All I have done is taken the "important attributes" shown within the game for each RDC and used them to rank the player's attributes against each RDC.

Well, I've gone on for long enough, any questions just ask

Here is the link: http://bit.ly/1I4gaLX

[rcolesworthy]

Do you think its possible to figure out how different attributes are weighted for roles an positions? I know that genie scout has on file the importance of different attributes for roles (i.e. a regista would have high vision multiplier), do you know of a way to figure this out?

[felley]

I'm really not sure if this is a good way to look at role allocation.

If you follow this line of thinking to it's conclusion, you will have a team full of players playing to their own personal strengths but perhaps to the detriment of the team as a whole.

As for weighting of attributes, it surely depends on what sort of football you want to see, rather than some arbitrary association with a role and the preconceptions of how it plays. Furthermore, does the spreadsheet take into account the fact that roles can be modified by TI's, PI's, mentality and team shape?

It is much better to view player roles as a general template that gives you an idea of what the player will concentrate on. Most are pretty adjustable save for the highly specialised ones.

[Masi`]

I think you should think about more of the lines of "I want to play like this, does this player have the attributes to fill that role" If he doesn't, you can see if he can do a job in another role or be trained to play their

[Maaka]

This still up?

Link seems to be broken..

[Sly419]

Bump, the link is broken, can you please re-upload?

[redkamuy]

re-upload plz!!