Steve009 Posted February 17, 2011 Share Posted February 17, 2011 This is great!! I've just put all my team into the spreadsheet - on different pages of course - and my team played like a dream. Before i found this thread, my team were just rubbish - leaking goals left right and centre, never having any shots, no posession etc.... Since playing the players that i have in the positions that the spreadsheet advises, my team looks like a brand new outfit. Top marks Robzilla..........................A++++++ Link to post Share on other sites More sharing options...
garamasien Posted March 26, 2011 Share Posted March 26, 2011 link didn't work anymore :sad Link to post Share on other sites More sharing options...
robzilla Posted March 26, 2011 Author Share Posted March 26, 2011 Link now working again: FM2011 Player Position Calculator (xls format) Link to post Share on other sites More sharing options...
ShirazS Posted November 24, 2011 Share Posted November 24, 2011 Does this calculator need to be updated for use with FM12? Link to post Share on other sites More sharing options...
robzilla Posted November 24, 2011 Author Share Posted November 24, 2011 To be honest I gave it a quick look when the FM12 demo came out with a view to updating it for FM12 but I couldn't find any changes so I didn't bother, and I am still using this one for FM12. What is interesting, is that in a lot of cases this tool gives a different "best" role & duty combination to what the assistant manager says, but I put that down to the game weighting the different attributes for different roles and duties, whereas my spreadsheet applies no weighting. Link to post Share on other sites More sharing options...
ShirazS Posted November 24, 2011 Share Posted November 24, 2011 To be honest I gave it a quick look when the FM12 demo came out with a view to updating it for FM12 but I couldn't find any changes so I didn't bother, and I am still using this one for FM12.What is interesting, is that in a lot of cases this tool gives a different "best" role & duty combination to what the assistant manager says, but I put that down to the game weighting the different attributes for different roles and duties, whereas my spreadsheet applies no weighting. That is exactly the reason I asked, because my Assistant Manager was giving a different recommendation. Oh well, I like yours better Link to post Share on other sites More sharing options...
Cleon Posted November 24, 2011 Share Posted November 24, 2011 To be honest I gave it a quick look when the FM12 demo came out with a view to updating it for FM12 but I couldn't find any changes so I didn't bother, and I am still using this one for FM12.What is interesting, is that in a lot of cases this tool gives a different "best" role & duty combination to what the assistant manager says, but I put that down to the game weighting the different attributes for different roles and duties, whereas my spreadsheet applies no weighting. It depends how good the assistant is. Link to post Share on other sites More sharing options...
Guest avine Posted November 24, 2011 Share Posted November 24, 2011 It depends how good the assistant is. great info keep it up:thup: Link to post Share on other sites More sharing options...
Cleon Posted November 24, 2011 Share Posted November 24, 2011 great info keep it up:thup: I got inspiration from all the valuable threads and info you've posted Link to post Share on other sites More sharing options...
Guest avine Posted November 24, 2011 Share Posted November 24, 2011 I got inspiration from all the valuable threads and info you've posted lol . Link to post Share on other sites More sharing options...
Bierofka Posted November 26, 2013 Share Posted November 26, 2013 Hey that link is not working for me.it is taking to a 1-2-3 domain page.Please help Link to post Share on other sites More sharing options...
Cleon Posted November 26, 2013 Share Posted November 26, 2013 Hey that link is not working for me.it is taking to a 1-2-3 domain page.Please help The topic is over 3 years old, so I doubt they still have the link. Link to post Share on other sites More sharing options...
robzilla Posted November 26, 2013 Author Share Posted November 26, 2013 I still have a copy of the FM11/12/13 player role/duty calculator so if anyone wants it, just PM me your email address and I'll send it. I don't know if they've changed anything for FM14 as I haven't got it yet, not sure if I will. Link to post Share on other sites More sharing options...
Cleon Posted November 26, 2013 Share Posted November 26, 2013 I still have a copy of the FM11/12/13 player role/duty calculator so if anyone wants it, just PM me your email address and I'll send it.I don't know if they've changed anything for FM14 as I haven't got it yet, not sure if I will. Some duties got removed for some roles. Link to post Share on other sites More sharing options...
robzilla Posted November 26, 2013 Author Share Posted November 26, 2013 Some duties got removed for some roles. Well if anyone fancies taking over the development of this and making the necessary modifications, I'm happy to supply the latest version I have. Link to post Share on other sites More sharing options...
ShirazS Posted December 11, 2013 Share Posted December 11, 2013 Hi, If you send me the spreadsheet, I will update it with the new roles and duties. Regards Shiraz Link to post Share on other sites More sharing options...
robzilla Posted January 2, 2014 Author Share Posted January 2, 2014 Fully updated version for FM14 Sorry it took so long but I've only just got around to getting the game! Link to post Share on other sites More sharing options...
ShirazS Posted January 2, 2014 Share Posted January 2, 2014 Awesome, thanks! Link to post Share on other sites More sharing options...
phnompenhandy Posted January 2, 2014 Share Posted January 2, 2014 Great! Do you know how your weightings compare with ScoutGenie? Link to post Share on other sites More sharing options...
robzilla Posted January 2, 2014 Author Share Posted January 2, 2014 Mine does not have weightings, all attributes that are highlighted in-game for a particular role/duty combo are treated equally in the spreadsheet. Link to post Share on other sites More sharing options...
phnompenhandy Posted January 3, 2014 Share Posted January 3, 2014 Mine does not have weightings, all attributes that are highlighted in-game for a particular role/duty combo are treated equally in the spreadsheet. So does it come up with the same recommendations as one's assman? Link to post Share on other sites More sharing options...
robzilla Posted January 3, 2014 Author Share Posted January 3, 2014 So does it come up with the same recommendations as one's assman? No, because the AssMan's recommendation takes into account weightings (which are unknown to me) for each attribute in each role, whereas the spreadsheet treats all attributes equally. Also as Cleon said earlier in the thread, the AssMan's ability is taken into account as well. Obviously I have no idea of the internal workings of this part of it so I can't mimic it. Link to post Share on other sites More sharing options...
phnompenhandy Posted January 3, 2014 Share Posted January 3, 2014 Right, cheers - will give it a bash. Link to post Share on other sites More sharing options...
robzilla Posted January 3, 2014 Author Share Posted January 3, 2014 I've knocked this up as an explanation of what the spreadsheet is and what it can be used for. What is it? The calculator tells you a player's mean, median, high and low attribute values for each role & duty combination in the game. Why? 1. For determining a player's best role & duty combination. Each role and duty combination in the game has a subset of attributes that are considered important for a player to have to be able to perform well in it. The spreadsheet show you which role/duty combinations your player is most suited to by showing you the mean, median, high and low attribute values for each role & duty combination in the game. For example, if a player has an average of 15 in the attributes considered important for the role/duty combination Poacher/Attack then you should consider giving him that role. Simples. 2. For determining what attribute a player should be trained to improve. Let's say you have a player who has an average of 13 for the role/duty combo Poacher/Attack, but you notice that although he has 13s, 14s, 15s in most of the attributes, in one of the required attributes - finishing - he only has a 9. In this case I would focus his training on finishing to bring it up as high as possible and make him strong in all the attributes required for that position. 3. For determining whether a player should be re-trained to a new position. You have player who scores highly for full back and wing back roles but he has no positional ability in the FB or WB positions (happens more than you might think). You can still play him at FB or WB but he will not perform as well as he should because he will be penalised for not having any positional ability in those positions. The player should be considered a good candidate for re-training in the FB or WB positions. How do I use it? The spreadsheet contains one "Outfield Player" sheet and one "Goalkeeper" sheet. Make as many copies of the outfield player sheet as you have outfield players in your squad, same with goalkeepers. Fill in the name of the player at the top of each sheet (I also rename the sheet using the player's surname) and input their attributes. Voila! You will obviously have to update the sheets from time to time as your players' attributes change. I usually do this at the beginning of each season, and in January. Where do I get it? Here. Link to post Share on other sites More sharing options...
EvertonblokesMobile Posted January 3, 2014 Share Posted January 3, 2014 I cant seem to get the page to load, is it broken? Or am I being a div kid? Link to post Share on other sites More sharing options...
robzilla Posted January 3, 2014 Author Share Posted January 3, 2014 Div kid as far as I can tell The link works fine for me. PM me your email address and I'll send it direct mate. Link to post Share on other sites More sharing options...
furiousuk Posted January 3, 2014 Share Posted January 3, 2014 Link works fine for me too, try it again, or PM rob. Link to post Share on other sites More sharing options...
kilowatt44 Posted January 3, 2014 Share Posted January 3, 2014 I seem to have a problem opening it. I get an error with AA57 and other errors. Am I doing something wrong? Link to post Share on other sites More sharing options...
robzilla Posted January 3, 2014 Author Share Posted January 3, 2014 I seem to have a problem opening it. I get an error with AA57 and other errors. Am I doing something wrong? What are you trying to open it in? AA57 has nothing in it, what are the other errors? Link to post Share on other sites More sharing options...
Heldacarite Posted December 10, 2014 Share Posted December 10, 2014 Hi could you do 1 for FM 15? Thanks! Link to post Share on other sites More sharing options...
alinp Posted December 11, 2014 Share Posted December 11, 2014 have you hosted this anywhere where we don't have to sign up for a "free" trial? Link to post Share on other sites More sharing options...
Vanq69 Posted December 29, 2014 Share Posted December 29, 2014 Is there a 2015 version? The download link doesn't appear to be working for the 2014 one Link to post Share on other sites More sharing options...
robzilla Posted December 29, 2014 Author Share Posted December 29, 2014 Sorry there is no 2015 version because I haven't got FM15 yet If you PM your email address I can send you the 2014 version though. Link to post Share on other sites More sharing options...
robzilla Posted January 2, 2015 Author Share Posted January 2, 2015 All right you muddy funsters, enough of you have PM'd me asking for the old version that I've decided to take pity on you and I went and downloaded the FM15 demo and updated the spreadsheet for you: http://community.sigames.com/showthread.php/416320-Player-Role-amp-Duty-Calculator-updated-for-FM15! Edit: now with pretty colours! Link to post Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.