TE20 training calculator

[Arphaxad]

UPDATE 2020.06.25
- Fixed a formatting issue with copied PLANNER sheets. Thought it was fixed in yesterday's version, but apparently it wasnt. Fixed now.

[Arphaxad]

UPDATE 2020.06.26
A couple of improvements have been made.
- On popular demand there's now an option to choose if you want to display the progression of your player as a total outcome or as incremental gain for the chosen drill.

- Inspired by Kwal, I've further improved the initial FOCUS ON ATTRIBUTE table. This feature is now not only linked to the DRILL table highlighting relevant drills based on the specific attribute you want to focus on, but you now have the option to select and combine several attributes. The table will automatically identify relevant drills based on your choice(s).

- Improved the progress table to better highlight progression.

- Deleted table IDENTIFY WHITE SKILL as it didn't add anything substantial to the power training of players.

DOWNLOAD the latest version here https://www.mediafire.com/file/uo6r5...6.26.xlsm/file

[Kwal]

UPDATE 2020.06.26
A couple of improvements have been made.
- On popular demand there's now an option to choose if you want to display the progression of your player as a total outcome or as incremental gain for the chosen drill.

- Inspired by Kwal, I've further improved the initial FOCUS ON ATTRIBUTE table. This feature is now not only linked to the DRILL table highlighting relevant drills based on the specific attribute you want to focus on, but you now have the option to select and combine several attributes. The table will automatically identify relevant drills based on your choice(s).

- Improved the progress table to better highlight progression.

- Deleted table IDENTIFY WHITE SKILL as it didn't add anything substantial to the power training of players.

DOWNLOAD the latest version here https://www.mediafire.com/file/uo6r5...6.26.xlsm/file

Thanks for the mention. It looks very neat. I like it that you took the focus skill option even further. I wonder though if it would be better to mark all the trainings with 1 of the selected skills instead of the combination, but I guess that depends on the user his wishes.
Also I think it is good you remove the identify white skill. It was a bit double.
The possiblity to change the output of the progression is very sweet. Good job on that one! I think it will make things more easy for the users.

It seems that the selection of the positions in the input data sheet isn't working properly. Check it out and maybe adjust the file if needed.

[whizzy @lacosta]

#008059 looking for a challenge

Sent from my SM-G532F using Tapatalk

[Arphaxad]

Thanks for the mention. It looks very neat. I like it that you took the focus skill option even further. I wonder though if it would be better to mark all the trainings with 1 of the selected skills instead of the combination, but I guess that depends on the user his wishes.
Also I think it is good you remove the identify white skill. It was a bit double.
The possiblity to change the output of the progression is very sweet. Good job on that one! I think it will make things more easy for the users.

It seems that the selection of the positions in the input data sheet isn't working properly. Check it out and maybe adjust the file if needed.

Thanks mate, appreciate your input.

Not sure I understood what you meant with the focus skill but to attain what I think you mean, you could select only one skill at a time. Selecting multiple choices gives you the opportunity to focus on a drill that targets more than one skill you want to train. But maybe that wasn't what you meant?

Thanks for seeing that error. Just uploaded a new version. It should work now.

Skickat från min VOG-L29 via Tapatalk

[Arphaxad]

UPDATE 2020.07.01
- Fixed the coding for the FOCUS TRAINING table. Nothing changed when it comes to functionality, it woked perfectly fine before. Just added a finesse where you can't make a choice in cell 2-5 if you don't make a choice in the prior cell.

- Added a column to the right of overall quality that displays the share of white skills (%). This lets you keep count of the share of relevant skills for the particular player/position throughout the training regime. This is an indicator of actual player quality. The higher the share, the more quality you're adding to the individual player through training. A decreasing ratio means you're adding quantity.

Download latest version here https://www.mediafire.com/file/9e66a...7.01.xlsm/file

[Arphaxad]

UPDATE 2020.07.03
- The "share of white skills (%) didn't count corrently for GKs. Fixed that.

[MikeDenvers]

Ty for power training calculator, I am newbie and it would be helpful at the start

[Arphaxad]

Ty for power training calculator, I am newbie and it would be helpful at the start

You're welcome. Hope you enjoy it and don't hesitate to ask if you have any questions.

Also, for your information, I'm uploading an updated version with a new feature in the coming days. It'll allow managers to compare the outcome of different training sessions through a radar chart. I think it'll be very helpful to quickly determine the most effective training session for a given player without having to browse through multiple sheets and keep the values in your head or copy and paste them and calculate the difference. The new feature will help you with all of that.

Skickat från min VOG-L29 via Tapatalk

[Arphaxad]

UPDATE 2020.07.09
- Added a COMPARATOR table which includes a radar chart. This feature allows you to compare different training sessions for a player. Default is a comparison between input and estimated values. If you wish to compare training sessions, begin by setting up a session under the DRILL ORDER table. Click COMPARE to save the initial session. The estimated outcome and drill order will be saved under the radar chart under the COMPARATOR table. Set up a second training session. The COMPARATOR will compare the two sessions. Click DELETE to delete the initial session that is saved under the radar chart. In that case, the COMPARATOR will go back to compare input and estimated values. Click RE-USE to copy the initial training session to the DRILL ORDER table to re-use it. Read further instructions under the "read.me" tab in the file.

- Added color to the “white skills” column within the DRILL table. If you’ve utilized the drill in your training session, the color turns green, otherwise it’s red. This idea I took from @Kwal.