Jump to content
Sports Interactive Community
AJetsOf

9.3.0 Coach Formula

Recommended Posts

hmm

Wait like 5 minutes. I'll translate it here and upload an english version ;)

I made it with Excel 2007, but with compatibility mode for excel 2003 (most people use this version).

brb. :)

Share this post


Link to post
Share on other sites

Still won't open - it says something about the name again - being too long or something (I've no idea really!) - looks like I'm destined not to get this - bugger!

Share this post


Link to post
Share on other sites

You sure you have MS excel installed, right?

I know lots of people who downloaded it and it's working just fine :(

What error message are you getting?

Share this post


Link to post
Share on other sites

Just hired a bunch of 7 star coaches in my network game so I am dreading to see what they have turned out to be now!!

With all this (un-needed) change, does this mean its goin to be harder to get players trained to their PA. With 7 star coaches few and far between it surely means no-one will be as good as when the old system was in play??

Anyone else think this?

Share this post


Link to post
Share on other sites

It's just called - Microsoft Works Spreadsheet - i have vista premium (don't know if that changes anything!)

Share this post


Link to post
Share on other sites

I also have vista, so it can't be it.

Really got me confused now :(

Share this post


Link to post
Share on other sites

When I got the laptop I didn't install anything - I think it was already done - having said that I haven't used the spreadsheet programme before!

Share this post


Link to post
Share on other sites

You probably don't have Microsoft Office (that includes Excel) installed :(

You need MS Excel to open this spreadsheet :S

Share this post


Link to post
Share on other sites

The thing is, how realistic was it to have so many 7 star coaches before? Surely the 2 or 3 that there are in each position is much more realistic and representative of reality, just as there are so few genuinely world beating players (Ronaldo, Messi)...

Share this post


Link to post
Share on other sites

So it's a nice filtering hell now to find good coaches. :(

Could we get some improved filtering then at least? Meaning a filter like "stat1 + stat2 + stat3 = at least: x".

Share this post


Link to post
Share on other sites

There should be at least one for each category imo, one to benchmark others by. As it is in my game the only defense coach that would get 6 stars is John Terry who's still playing for Chelsea at the age of 40. Similar with attacking and shooting coaches, there are one or two that are borderline 6 stars but none more than a few points over the total needed. No one even remotely close to 7. If motivating, determination and discipline is regarded this highly then there should at least be a couple of coaches that actually fit under the criteria. Finding one with double figures in each three and remotely useful in technical areas is difficult to say the least.

Also, has the attribute fluctuation pattern had a change as well? All my players seem to go up and down every couple of months instead of improving steadily as before. Annoying a bit as they often lose a point in an important area and then gain one in something they don't actually need - getting worse as a player in result when their ability points total remains the same.

Share this post


Link to post
Share on other sites

If anyone has found any 6 or 7 star Attacking or Defending Coaches can you please post their names?

Thanks!

Share this post


Link to post
Share on other sites
So it's a nice filtering hell now to find good coaches. :(

Could we get some improved filtering then at least? Meaning a filter like "stat1 + stat2 + stat3 = at least: x".

Yeah, I was wondering whether that could be done too. If a combined DDM column could be added using a custom skin, it'd speed things up immeasurably.

Share this post


Link to post
Share on other sites

Great job AJetsOf!

But what about physios?

I'm playing AC Milan and on 9.2.0 my physios could exactly predict the time of reviving from injuries but on 9.3.0 they can only tell an approximate time - they say "3 or maybe even 4 weeks" etc. so I'm pretty sure it's because of low "DDM" attributes.

Could someone please find a formula which will point to a good physio who can tell the exact time of reviving from an injury?

My best physio at this time is Lieven Maesschalk who has Determination = 14, Dicipline = 1, Motivation = 16 and Physical = 20.

Share this post


Link to post
Share on other sites
If anyone has found any 6 or 7 star Attacking or Defending Coaches can you please post their names?

Thanks!

Just having a quick play with genie. In my game there are no 7* attack coaches and only 1 6* coach.

There's no 7* defence coaches either. There's 5 6* defending coaches. 4 of those are assistant managers and one is a goalkeeping coach.

I'm really hoping this situation will improve with regen coaches.

Share this post


Link to post
Share on other sites

It makes sense now, but im still a bit peeved that "Mental Coaching" is not utilized more often. I think like ddm it should be a universal stat because it has to do with every aspect of training.

Share this post


Link to post
Share on other sites

I'm really hoping this situation will improve with regen coaches.

It won't really, no regen coahces have double figures in all three important mental attributes either so there are virtually no 7 star ones. For a 7 star defensive coach for example all five important stats (defense, tactics, determination, discipline, motivation) need to be 18+. Not likely to happen is it.

Basically I fully understand why the system was changed and it's better this way, but the requirements for 7 stars (especially in defense and attack categories) need to come down considerably. There's no point in having a scale of 7 if the highest range is not realistically reachable.

Share this post


Link to post
Share on other sites
It won't really, no regen coahces have double figures in all three important mental attributes either so there are virtually no 7 star ones. For a 7 star defensive coach for example all five important stats (defense, tactics, determination, discipline, motivation) need to be 18+. Not likely to happen is it.

Basically I fully understand why the system was changed and it's better this way, but the requirements for 7 stars (especially in defense and attack categories) need to come down considerably. There's no point in having a scale of 7 if the highest range is not realistically reachable.

I'd be interested to see what the regen coaches/retired players stats look like.

Anybody started a new game with 9.3.0 and played 3 seasons??

Can you post some regen coaches pictures???

Share this post


Link to post
Share on other sites
I'd be interested to see what the regen coaches/retired players stats look like.

Anybody started a new game with 9.3.0 and played 3 seasons??

Can you post some regen coaches pictures???

1, 2, 3

That's the general pattern, high stats in some key areas, lots of 1-s and 3-s in others. It's a save started on 9.1.0 and played through 9.2.0 now updated to 9.3.0 though, but I'd be extremely surprised if anything regarding this has been changed in 9.3.0.

Share this post


Link to post
Share on other sites
1, 2, 3

That's the general pattern, high stats in some key areas, lots of 1-s and 3-s in others. It's a save started on 9.1.0 and played through 9.2.0 now updated to 9.3.0 though, but I'd be extremely surprised if anything regarding this has been changed in 9.3.0.

Cheers for the pics mate.

Interesting one.

I find it a bit odd that the coaching system has been changed but none of the coaching attributes have been altered at all.

My post above shows it's impossible on my current game to get 6* coaching in some areas let alone 7* unless you're playing with a world class club.

Maybe regen coaches discipline/motivating/mental attributes improve over time???

Share this post


Link to post
Share on other sites

I'm really struggling with this!

More by luck than any (literally any) judgement I have stumbled across Milton Nienow who is a Brazilian GK coach at Vasco. His stats may be random, but second season in he appears to be a 7* fitness coach.

Share this post


Link to post
Share on other sites
I'm really struggling with this!

More by luck than any (literally any) judgement I have stumbled across Milton Nienow who is a Brazilian GK coach at Vasco. His stats may be random, but second season in he appears to be a 7* fitness coach.

Got my head around this now, this really is an excellent post, thank you!

Share this post


Link to post
Share on other sites
Cheers for the pics mate.

Interesting one.

I find it a bit odd that the coaching system has been changed but none of the coaching attributes have been altered at all.

My post above shows it's impossible on my current game to get 6* coaching in some areas let alone 7* unless you're playing with a world class club.

Maybe regen coaches discipline/motivating/mental attributes improve over time???

I agree, seems that's the whole thing's been left half-way a bit. And as I said earlier, what I really want now is an IMPROVED FILTERING SYSTEM!! Is it really a good thing that you have to "micro manage" with the current filtering system for ages to be able to find coaches with needed attributes?? I've always hated that part of starting a new game, when you have to search for decent staff members (especially coaches), and now it's 10 times the job that it was before. Sigh.

As for the regen coaches, yes I think that their stats improve over time.

Share this post


Link to post
Share on other sites
It won't really, no regen coahces have double figures in all three important mental attributes either so there are virtually no 7 star ones. For a 7 star defensive coach for example all five important stats (defense, tactics, determination, discipline, motivation) need to be 18+. Not likely to happen is it.

Basically I fully understand why the system was changed and it's better this way, but the requirements for 7 stars (especially in defense and attack categories) need to come down considerably. There's no point in having a scale of 7 if the highest range is not realistically reachable.

I agree that there is no point having a scale of 7 if it can't be reached but you can have just as much success with 4, 5, and 6 star coaches so i don't think it matters too much that there aint a lot of 7 star coaches about.

Share this post


Link to post
Share on other sites
I agree, seems that's the whole thing's been left half-way a bit. And as I said earlier, what I really want now is an IMPROVED FILTERING SYSTEM!! Is it really a good thing that you have to "micro manage" with the current filtering system for ages to be able to find coaches with needed attributes?? I've always hated that part of starting a new game, when you have to search for decent staff members (especially coaches), and now it's 10 times the job that it was before. Sigh.

As for the regen coaches, yes I think that their stats improve over time.

Just download the newest version of Genie Scout. It allows you to find 7 star coaches. It's great.

Share this post


Link to post
Share on other sites
Great job AJetsOf!

But what about physios?

I'm playing AC Milan and on 9.2.0 my physios could exactly predict the time of reviving from injuries but on 9.3.0 they can only tell an approximate time - they say "3 or maybe even 4 weeks" etc. so I'm pretty sure it's because of low "DDM" attributes.

Could someone please find a formula which will point to a good physio who can tell the exact time of reviving from an injury?

My best physio at this time is Lieven Maesschalk who has Determination = 14, Dicipline = 1, Motivation = 16 and Physical = 20.

I just did some analysis. See my post

http://community.sigames.com/showthread.php?t=108548

Share this post


Link to post
Share on other sites
tell u guys wad, hire 2 coaches per area. bound to get 7 stars

Is this possible? Instead of finding one coach giving you a 7 star training according to the above formula (which is quite impossible), can you then just find 2 coaches covering each their aspect (for instance, one coach have the mental stats, the other coach the coaching abilities)? Because it must be a bit easier to achieve the 7 star training this way...

Share this post


Link to post
Share on other sites
Is this possible? Instead of finding one coach giving you a 7 star training according to the above formula (which is quite impossible), can you then just find 2 coaches covering each their aspect (for instance, one coach have the mental stats, the other coach the coaching abilities)? Because it must be a bit easier to achieve the 7 star training this way...

Doesn't work like that. I have 4 coaches on some areas (had to have all of them on long contracts due to the disappearing staff bug in 9.2, now I can't get rid) and it still only counts the best one.

Share this post


Link to post
Share on other sites
Is this possible? Instead of finding one coach giving you a 7 star training according to the above formula (which is quite impossible), can you then just find 2 coaches covering each their aspect (for instance, one coach have the mental stats, the other coach the coaching abilities)? Because it must be a bit easier to achieve the 7 star training this way...

I haven't tried 9.3 yet, but in previous incarnations this wouldn't work. The quality of coaching doesn't improve if you simply hire two or more coaches for each area - the workload for the coaches in each area is simply decreased.

Share this post


Link to post
Share on other sites
;2796332']Just a little remark:

Defensive:

def * 8 + (tac + ddm) * 3 => 11:3

Attack:

att * 6 + tac * 3 + ddm * 2 => 9:2

In the most categories the proportion of special attribute training to general training ability is 9:2

Why is the general training ability in the defense category gentrified? Wouldn't it make more sense to set it the same proportion as the Attack category? (Or the other way round)

Just quoted myself once again. Anyone who shares my idea?

And another question: Is this formula linear? e.g. Defensive sum >=240 4 stars, >=200 3 stars, >=160 2 stars and so on? Or will the gaps increase a little bit?

Share this post


Link to post
Share on other sites
I was pretty embarassed by the amount of people who understood and i didnt because i unreal at maths at school lol

I'm guessing you weren't unreal at English?

Share this post


Link to post
Share on other sites

Am I right in assuming that, like players, any coach with a decent/high PA will improve his stats as time goes by? This hopefully would then increase the amount of 7 star coaches.

Share this post


Link to post
Share on other sites

Coaches CA/PA move unlike players'. A coaches CA will increase rather quickly (less than a month) to match his PA. After that, relatively small, and apparently random, changes occur to his PA, with his CA quickly adjusting up and down as dictated.

Personally, I believe, especially in light of the recent change (even though the change didn't effect coach development), that a coaches mental stats should slowly increase over time, as they gain experience. But this is most decidedly NOT the case.

Certainly, coach progression is something that needs an overhaul. But what? Slow progression to their eventual max? That would mean every 30ish coach would be terrible, and most would be at their best by age, what, 55-sh, 60ish, and then retire. How happy would everyone be if they finally got solid 6-star staff, only to have to turn over a staff of coaches every 3, 4, years? No thanks, not fun. But something's gotta be better than what we have now.

Share this post


Link to post
Share on other sites

I have a question about this. I have a coach who gets 206 for Stength/Aerobic and 218 for Attacking. In the coaching section for my team if I tick Strength or Aerobic or both and hover over the rating it's says "Good" rating. If I untick them and then tick Attacking the rating says "Decent". Should'nt it be a better rating based on this formula or does the rating on the coaching screen mean something else?

Share this post


Link to post
Share on other sites

By the way the other option for those without excel is to upload the excel file to google docs which works nicely too.

Share this post


Link to post
Share on other sites

I still don't get it on these star ratings system, open editor of Meulensteen and still cant find it.

Share this post


Link to post
Share on other sites

thanks this is a big help.

For those who don't want to do the maths then download the latest genie scout. You can filter the staff stats to see who will give you the required stars

Share this post


Link to post
Share on other sites
I got a couple of 6 star coaches and they have dropped back to 5 star, including Moniz

Does anyone have reasons why coaching stats drop?

just like players attributes sometimes drop.

Share this post


Link to post
Share on other sites

This is completed stupid that everything has changed.

Question. Youth Stats has no baring on youth development? Correct or Myth? Because on another thread people were saying it had no baring.

Oh by the way I had to completely sack and rehire my entire coaching staff to get 7 stars after the 9.0.3. patch release.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×