TE20 training calculator

[Arphaxad]

Still trying to figure out how I can set it up. I think I've solved the GK problem, but the other part is still difficult to solve.

For example, the drill DEFENDING CROSSES targets 4 skills. If we train a ML/AML, the drill contains 1 white skill and 3 grey skills. Lets say that the current drill average quality is 100 and we want to train it to 110, then the white skill needs to gain 16 and the grey skills need to gain 8 respectibely (x3). So out of 40 additional skill points, the white skill increases 16 (40 %) and the grey skills increases 8 respectively (20 % + 20 % + 20 %).

But if we want to train the drill from 100 to 112,5, then the white skill needs to gain 18 and the grey skills need to gain 10,67 respectively (x3). So out of 50 additonal skill points, the white skill increases 18 (36 %) and the grey skills increases 10,67 respectively (21,4 % + 21,4 % + 21,4 %).

The ratio differs depending on number of total skill points gained, the amount of targeted skills and the share of white and grey skills. I need to set up a formula that takes all three factors into account so I can put that ratio into the calculations. Basically, I need to set up an equation that states that if there are white skills, they need to increase 2x the rate of grey skills while the sum of all gains is equal to the difference between the current average drill quality and the desired average drill quality. Then I need to put all these conditions into a formula for each targeted skill (maximum of 5 since no drill trains more than 5 skills). At this point, I'm not sure it's possible as the equation has two unknowns and thus is unsolvable, but I'll give it some more thought.

Another option might be to set up calculations for all combinations possible. I haven't gone that route yet, but I might need to try it if I can't find a formula that takes all factors into account.