TE20 training calculator

[Kwal]

Hi Kwal,
Thank you. Yours looks like a comprehensive tool as well. Good job. I was actually planning to add something similar for the coming season as many managers power train their players by the start of the season. I've started the work but haven't finished anything yet. Your tool might give me some ideas in terms of layout.

Thanks. That’s exactly the reason why i made it for myself. I’m happy that it gives you some ideas.

One question though, how does it decide the best training order? Wouldn't that be a function of which skills the manager want to develop (most) depending on position(s)? Would be interesting to hear your thoughts and understand how it works. I've contemplated doing something similar but ended up with the conviction that the best order is a subjective matter

The definition of the best training order is indeed very subjective. There are different opinions like:
- Some skills are hard to maintain after power training. In example for a RB or LB it is hard to keep up Aggression over the years. So it might be smart to push these skills to the max first.
- There are players that think certain white skills are more important over others. In example they say that for a ST finishing and shooting are more important and need to be maxed out first.
- Others believe there needs to be a certain balance. This differs from a balance in the maxing of white skills, a balance in all skills (whites and greys) and to a balance / relation in the total percentages of Defence, Attack and Physical & Mental
- To get the maximum value for your green packs > max skill points per condition loss. Basically first maxing out all 100% white skill drills and then go on to the 2nd best.

There are probably more opinions that I didn’t mention, but the point I wanted to make is that there is a big variety in opinions and that we can’t decide for others what the best training order is.

IIn my sheet I’ve tried to give the maximum flexibility to all these individual opinions, without making the sheet too complex or too static to use. Basically the user can decide his or her own best order.
What I would like to add to the sheet are some pre-sets, with the outcome presented next to the users input, so that a comparison can be made easily.
How my sheet works is that, after filling in the whites cells (most of them are dropdown lists) like age, positions and the base maximum average for the drills, it calculates how many points of the trained skills can be gained until the drill reaches its maximum set average. It then stops and starts the next training in order and so on.
The maximum average for each drill can be manually adjusted in the green fields on the left. So if a user values certain skills higher than others, her or she can put the drills that train these skills first in order and subsequently adjust the maximum average for these drills.
Also it takes in consideration at which age you want to stat the power training. If you buy an 18 old and plan to train him when he’s 21, it will adjust the calculations.

As for your questions, sorry, I can't be of any help. One would also have to add the decrease in development capacity with age and the decrease of gain for each star gained for a drill. I'm not sure there's any conclusive data of that. Another factor would be level of training. I'm willing to develop a calculator for it, but I'm afraid the data required isnt present.

Too bad, I hope someone else has the data.
I’m aware of these different factors. Since this season I’m logging my players development to be able to make tables for these factors. It’s very time consuming though and unfortunately I have a busy life and thus it will take me some time to gather all this data.