TE20 training calculator

[Arphaxad]

UPDATE 2020.07.16
- Fixed formatting issues with saved sheets when you click the SAVE button.

Download most recent version here https://www.mediafire.com/file/8dyzu...7.16.xlsm/file

[Arphaxad]

UPDATE 2020.07.21
- Fixed issue with radar chart for copied sheets under the COMPARATOR table. Upon saving, the values in the radar chart were fixed. This is fixed now so that the radar chart in the copied PLANNER sheets works just as well as in the initial PLANNER sheet.
- Fixed the calculation for 'Effectiveness' under the COMPARATOR table. The calculation was absolute. It's relative now measuring the difference between initial and current training session in per cent. This will make it easier for you to draw conclusions.
- Found an error in the estimation for HOLD THE LINE drill which I fixed.

Download most recent version here https://www.mediafire.com/file/x7inx...7.21.xlsm/file

[Eric Perromat]

Hi and great job !
One question ... I have some player vith negative (I can calculate this value with another team) value and i can't enter this value as input paramter ... Is it possible to fix thix ?
Thanks a lot if is it possible

[Arphaxad]

Hi and great job !
One question ... I have some player vith negative (I can calculate this value with another team) value and i can't enter this value as input paramter ... Is it possible to fix thix ?
Thanks a lot if is it possible

Hello Eric and thanks for your kind words.

As to your question, where exactly are you intending to insert negative values? In the INPUT DATA sheet? I'm not sure the estimations in the PLANNER sheet will be correct with negative values as I haven't tested it yet. May I know what the aim is? If I understand what the problem is I might be able to offer a better solution.

In my mind, at least initially, this shouldn't be an issue. If your intent is to power train players, just use the attributes that are shown from the correct account. This will give you the estimated values in a correct way. Then just subtract 20 for each level above the correct account. Or am I missing something? Thanks.

Skickat från min VOG-L29 via Tapatalk

[Eric Perromat]

Hello Arphaxad,
When I mean negative value it is in the input sheat .... When you have a player with negative skill like -3% or -25% ... In the game all aplayer vith negative skill are writed with 1% but the are not really 1% they hav negative skill ... After the season begening all player loose 20% on each skealpoints so i my player have 15% on creativity, when he loose 20% ... Creativity becomes -5% but in the game creativity is 1% ...
thanks for your reply and sorry for my french english ;-)

[Arphaxad]

Hello Arphaxad,
When I mean negative value it is in the input sheat .... When you have a player with negative skill like -3% or -25% ... In the game all aplayer vith negative skill are writed with 1% but the are not really 1% they hav negative skill ... After the season begening all player loose 20% on each skealpoints so i my player have 15% on creativity, when he loose 20% ... Creativity becomes -5% but in the game creativity is 1% ...
thanks for your reply and sorry for my french english ;-)

Thanks for clarifying. I can open up to allow for negative values if you wish. I'll do it tomorrow or tonight hopefully and upload it.

But I'm trying to understand how the game interprets negative values. For example, if Tackling is 15 % and Marking 199 % next season they will be 1 % and 179 %. When training HOLD THE LINE, will the average be 90 (1+179=180/2=90) or will it be 87 (179-5=174/2=87)? If it's the former, you shouldn't put negative values in the INPUT DATA sheet because the calculations will be wrong then.

Skickat från min VOG-L29 via Tapatalk

[Eric Perromat]

For me ... When i train a player with a negative value for example -5% in creativity .... I train my play with 6 Drill videos analysis, if my player gain 2% of creativity, it is still 1% for the game ... But for me my player is -3% (it gains 2%) ... I see the really %player from another team ...

Thanks for your reply

[RaiKo]

But I'm trying to understand how the game interprets negative values. For example, if Tackling is 15 % and Marking 199 % next season they will be 1 % and 179 %. When training HOLD THE LINE, will the average be 90 (1+179=180/2=90) or will it be 87 (179-5=174/2=87)?

Hi Arphaxad, AvQ of hold the line drill is 87% in your e.g. I would remind you to allow users inputting of minus attributes of a player as well. So you need to update it.

[Arphaxad]

UPDATE 2020-07-29
- Allowed negative values into the INPUT DATA sheet.
- Allowed for negative average quality in the PLANNER sheet as a result of the above.

Download most recent version here https://www.mediafire.com/file/wg7a3...7.29.xlsm/file

[Arphaxad]

Hi Arphaxad, AvQ of hold the line drill is 87% in your e.g. I would remind you to allow users inputting of minus attributes of a player as well. So you need to update it.

I've uploaded a new version which allows for negative input values and negative average drill quality. Thanks for notifying me.

If the case is that values can indeed become negative, how can I identify the real values of my players which have attributes at 1 %? I don't have another account to cross check.