Page 9 of 13 FirstFirst ... 7891011 ... LastLast
Results 81 to 90 of 124
Like Tree40Likes

Thread: TE20 training calculator

  1. #81
    Addicted
    Join Date
    Apr 2020
    Posts
    619
    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
    Download my power training tool here https://forum.topeleven.com/tutorial...alculator.html

  2. #82
    Addicted
    Join Date
    Apr 2020
    Posts
    619
    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
    Last edited by Arphaxad; 07-21-2020 at 07:06 PM.
    Download my power training tool here https://forum.topeleven.com/tutorial...alculator.html

  3. #83
    Newbie
    Join Date
    Jan 2015
    Posts
    13
    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

  4. #84
    Addicted
    Join Date
    Apr 2020
    Posts
    619
    Quote Originally Posted by Eric Perromat View Post
    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
    Download my power training tool here https://forum.topeleven.com/tutorial...alculator.html

  5. #85
    Newbie
    Join Date
    Jan 2015
    Posts
    13
    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 ;-)

  6. #86
    Addicted
    Join Date
    Apr 2020
    Posts
    619
    Quote Originally Posted by Eric Perromat View Post
    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
    RaiKo likes this.
    Download my power training tool here https://forum.topeleven.com/tutorial...alculator.html

  7. #87
    Newbie
    Join Date
    Jan 2015
    Posts
    13
    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

  8. #88
    Addicted
    Join Date
    Aug 2019
    Posts
    666
    Quote Originally Posted by Arphaxad View Post
    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.

  9. #89
    Addicted
    Join Date
    Apr 2020
    Posts
    619
    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
    Download my power training tool here https://forum.topeleven.com/tutorial...alculator.html

  10. #90
    Addicted
    Join Date
    Apr 2020
    Posts
    619
    Quote Originally Posted by RaiKo View Post
    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.
    Download my power training tool here https://forum.topeleven.com/tutorial...alculator.html

Page 9 of 13 FirstFirst ... 7891011 ... LastLast