Results 1 to 10 of 15
Like Tree12Likes

Thread: Drills spreadsheet

Threaded View

Duncton Drills spreadsheet 03-26-2016, 07:23 PM
nikolgiorgos very good job Duncton (I 'll... 03-27-2016, 04:43 PM
Duncton Sure, you can share it. :) ... 03-27-2016, 06:14 PM
nikolgiorgos yea, that's what I was... 03-28-2016, 05:25 PM
Sweed Mind Thanx Duncton gives a much... 03-31-2016, 02:49 PM
Duncton Updated first post with... 04-02-2016, 12:20 PM
Darren Power id agree 100 % with that,if... 04-03-2016, 01:52 AM
Sweed Mind The drill sheet shows the... 04-03-2016, 02:00 PM
Duncton This is what I'm using at the... 05-03-2016, 08:29 PM
nikolgiorgos The thing is that in Defense... 05-03-2016, 08:39 PM
madflo19 I am using those 2 sets of... 05-03-2016, 11:15 PM
Duncton Good point. At the moment it... 05-04-2016, 03:36 PM
keta Am I the only one to whom the... 08-09-2017, 06:04 PM
nikolgiorgos don't know this works for me... 08-10-2017, 06:13 PM
keta I finally managed to open it... 08-12-2017, 01:26 PM
Previous Post Previous Post   Next Post Next Post
  1. #1
    Dreamer
    Join Date
    Aug 2015
    Location
    Netherlands
    Posts
    347

    Drills spreadsheet

    After Pavinha opened his topic (Meet all drills), I was able to finish this.

    https://docs.google.com/spreadsheets...ub?output=xlsx

    UPDATE: spreadsheet taking into account intensity of each drill.
    https://docs.google.com/spreadsheets...ub?output=xlsx

    It's a spreadsheet of all drills and which specific skills they train. With this, it should be possible to construct training sessions which specifically train those areas in which you want your players to progress (defense, attack, physical or goalkeeper).

    Note that it doesn't tell you anything about how 'perfect' a training session is (i.e. if it will fully fill all bars).

    Column Z includes the total number of skills trained. Note for example that GK skill Punching is only trained by one drill (Wing Play). Column AA is a training session I build myself (listed here: http://forum.topeleven.com/top-eleve...tml#post394810), looking for balance but mostly aiming towards defense and attack. Column AB lists Pavinha's 525 XP training session. It's leaning towards attack and physical, but all in all is pretty balanced.

    I don't feel like I'm finished yet:
    1. As it is, it isn't easy to work with. You have to manually look through all drills and select them by adding up the appropriate columns. I'd like it to be more natural to work with, but I'm afraid that will include either using MS Access or programming, and I don't know a lot about both.
    2. I didn't take into account the Intensity of each drill. Condition loss builds up from 0.75% for very easy drills to 3.75% for very hard ones. That would mean a player would gain progress 5x quicker in a very hard drill than in a very easy one? I'd like to hear your opinions on that.
    Last edited by Duncton; 04-02-2016 at 12:10 PM.