lurkingwithintent Posted December 1, 2009 Share Posted December 1, 2009 Enjoy Excel Spreadsheet Updated The Excel Spreadsheet now uses the new star rating!. Coaches are rated from 0-5 stars with 0.5 intervals as requested. Apologies for not getting it correct before. The downloadable program will be updated shortly. Download for Excel 2007 Download for Excel 2003 Bugs? Quite possibly! Just post here and I'll fix and change asap. FM Coach Stars Calculator Released! PLEASE SCAN! It should not have a virus, but please double check! It's not my fault if this screws your computer over. This program still uses the old way Star rating. This will be updated very shortly to the FM10 0-5 star rating system. For now, please use the Excel Spreadsheet Download. Windows only Any bugs please report back. Thanks Link to post Share on other sites More sharing options...
Tottiseiya Posted December 1, 2009 Share Posted December 1, 2009 Nice tool! Thanks! Link to post Share on other sites More sharing options...
Wonky Posted December 1, 2009 Share Posted December 1, 2009 Very cool. I just had a look at the formulas in the Excel version. So 'Determination', 'Discipline' and 'Motivation' are extremely important? Good to know. Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 1, 2009 Author Share Posted December 1, 2009 Thanks guys, to credit the author, I got the formula from here (although you can find them all over) http://www.theawaystand.co.uk/fm-encyclopedia/7-star-coaches/ Link to post Share on other sites More sharing options...
eaygin Posted December 2, 2009 Share Posted December 2, 2009 It's cool thanks This has 7 stars rating although FM2010 uses 5 (does it end up with 10 when including half stars). How can I convert this 7 to 5 or 10 star ranking? Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 2, 2009 Author Share Posted December 2, 2009 Hi eaygin, Not sure what you mean? If you can give me a bit more detail then I'll convert them over Link to post Share on other sites More sharing options...
taylorsmen Posted December 2, 2009 Share Posted December 2, 2009 I think what eaygin mean't was FM10 coach rating only goes up to 5 stars and not 7 stars,well at least i think that's what he meant. Great tool none the less. Link to post Share on other sites More sharing options...
rinso Posted December 2, 2009 Share Posted December 2, 2009 I think what he means is, the coaching categories on fm10 are rated out of 5 stars, not 7, and it appears your program gives the coaches ratings out of 7 stars, not 5 (if you see what I mean!) edit: damn, beat me to it! Link to post Share on other sites More sharing options...
Ty Posted December 2, 2009 Share Posted December 2, 2009 This is brilliant Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 2, 2009 Author Share Posted December 2, 2009 I think what he means is, the coaching categories on fm10 are rated out of 5 stars, not 7, and it appears your program gives the coaches ratings out of 7 stars, not 5 (if you see what I mean!)edit: damn, beat me to it! So all I need to do is change 7 stars to 5, 6 stars to 4 and 5 stars to 3? If so I'll do it asap. Thanks guys Link to post Share on other sites More sharing options...
Elmo Posted December 2, 2009 Share Posted December 2, 2009 That is excellent. Thank you muchly. Link to post Share on other sites More sharing options...
Fallenone Posted December 2, 2009 Share Posted December 2, 2009 How come when I press Get those stars it doesn't do anything... Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 2, 2009 Author Share Posted December 2, 2009 How come when I press Get those stars it doesn't do anything... If your coach does not have any stars nothing will appear in the box. Link to post Share on other sites More sharing options...
HunkOfJunk Posted December 2, 2009 Share Posted December 2, 2009 Not sure if this works FM rates Seydou Keita as a 4.5 star for Tactics yet this program rates him as no stars. Det 10 Dic 11 Mot 6 Fit 13 GK 4 Tac 20 Att 19 Def 6 Tec 14 Men 10 Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 2, 2009 Author Share Posted December 2, 2009 Hi HOJ, My program uses the 5,6,7 star rating from earlier FMs. I still have little idea how to convert to the new system If anyone could tell me how I'd be happy to do so. Link to post Share on other sites More sharing options...
BamBamBam Posted December 2, 2009 Share Posted December 2, 2009 So it doesn't work then. I use the FM10 coach calculatorv2. http://www.thedugout.tv/community/showthread.php?t=61551 Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 2, 2009 Author Share Posted December 2, 2009 Or you could tell me how to convert it and I can have a new one uploaded asap Link to post Share on other sites More sharing options...
HunkOfJunk Posted December 2, 2009 Share Posted December 2, 2009 Hi HOJ,My program uses the 5,6,7 star rating from earlier FMs. I still have little idea how to convert to the new system If anyone could tell me how I'd be happy to do so. I dont know where to begin to help, Was a great idea and a nice little tool. Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 2, 2009 Author Share Posted December 2, 2009 No prob HOJ, if someone can let me know I can update it really easily Link to post Share on other sites More sharing options...
0briang0 Posted December 3, 2009 Share Posted December 3, 2009 No prob HOJ, if someone can let me know I can update it really easily Does this help? For example, a coach with: DET: 12 DIS: 13 MOT: 14 FIT: 15 Has Str and Aer coaching skills given by: 9*FIT + 2*(DET+DIS+MOT) = 213 213/300 = 71% Each 10% gives half a star: 0-9% = 0.5 stars 10-19% = 1.0 20-29% = 1.5 etc So, 71% = 4 stars (but only if coaching ONE area only) But I have a question... In the example above, the coach gets 4 stars if he coaches in one area only, and his rating drops if he's coaching two or more areas. Does anyone know how the stars are calculated when coaching in multiple areas? Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 3, 2009 Author Share Posted December 3, 2009 Hey buddy, that's great. The formulae is exactly the same as previous FMs but the star rating is different. So it should be really easy to update, I'll get on that right away. Not sure how to implement the rating drop for +1 areas though, and no idea how it is calculated. Link to post Share on other sites More sharing options...
lurkingwithintent Posted December 3, 2009 Author Share Posted December 3, 2009 Excel Spreadsheet Updated The Excel Spreadsheet now uses the new star rating!. Coaches are rated from 0-5 stars with 0.5 intervals as requested. Apologies for not getting it correct before. The downloadable program will be updated shortly. Download for Excel 2007 Download for Excel 2003 Link to post Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.