Page 1 of 3 123 LastLast
Results 1 to 10 of 22
Like Tree27Likes

Thread: Tools to track your team performance

  1. #1
    Spanish Forum Moderator khris's Avatar
    Join Date
    Jun 2013
    Posts
    13,393

    Tools to track your team performance

    This is the question, what tools you use? if you have something interesting to share with the comunity to make the job easy, you can share it here.


  2. #2
    VIP talisman's Avatar
    Join Date
    Feb 2014
    Location
    Clevedon, UK
    Posts
    3,689
    Excel spreadsheet - screen shot of an older version (pre-decimal ratings) - I've refined it a little bit, I'll post a copy of that later...

    Tools to track your team performance-pc-player-spreadsheet.png
    Any formation or tactics advice given is based purely on experience with my teams...


  3. #3
    VIP talisman's Avatar
    Join Date
    Feb 2014
    Location
    Clevedon, UK
    Posts
    3,689
    The spreadsheet I use has two components, a Performances sheet, of which there is one for each season, and an Appearances sheet, which is copied at the end of each season to the appropriate Performances sheet and reinitialised for the new season. It only takes about 3-5 minutes after each match to put in the figures and update.

    Tools to track your team performance-spreadsheet-performances-sheet.jpg

    Tools to track your team performance-spreadsheet-appearances-sheet.jpg
    Last edited by talisman; 05-10-2017 at 10:29 PM.
    Any formation or tactics advice given is based purely on experience with my teams...


  4. #4
    Dreamer motrin's Avatar
    Join Date
    Feb 2016
    Posts
    439
    I do something similar. I enter the ratings for each match and select the competition. A script will calculate the average per competition. It will change the color of the name based on which form of competition they perform best. Not sure if players perform better in specific competitions, but I made this when I suspected they did. It also does an overall average of ratings and has a sparkline I can quickly see there players overall trend. I don't keep long term stats. So I reset this spreadsheet every season.

    Edit: I use Google sheets for all my t11 spreadsheets so I can access it from anywhere on my phone. If I export this to excel, the scripts won't transfer and the sheet is useless. And I'm not about to recreate this in excel. Additionally, I found no benefit from tracking the way this sheet does.

    Sent from my SAMSUNG-SM-G900A using Tapatalk
    Last edited by motrin; 05-21-2017 at 12:10 AM.
    Kerem and LarryC like this.

  5. #5
    Apprentice
    Join Date
    Jan 2017
    Location
    127.0.0.1
    Posts
    151
    Hello,
    you can share the fils excel with us ?
    I would like to track my team thank you
    Club: Valhalla
    Purpose : to be football manager and lead my national team

  6. #6
    Pro Awe Imoleayo Peter's Avatar
    Join Date
    Jan 2016
    Posts
    988
    Quote Originally Posted by Amoun View Post
    Hello,
    you can share the fils excel with us ?
    I would like to track my team thank you
    Been a while

  7. #7
    Newbie
    Join Date
    Mar 2017
    Posts
    5
    where can i find those tools?

  8. #8
    Rookie
    Join Date
    Dec 2016
    Posts
    83
    This thread gave me some ideas, and indeed I track now the players ratings (back to the beginning of the season).

    I use LibreOffice to make a few charts

    - XY chart of past ratings on each played match, with moving average (green) and polynomial (red) 4-points trend lines
    Tools to track your team performance-ratings1.png

    - ratings frequency distribution, to see how often each rating value is obtained.
    Tools to track your team performance-ratings2.png


    I also have an adjusted rating XY charts, in which I give a penalty to ratings gotten against weaker teams, and a bonus to those against stronger teams, so as to smooth the opponent's strength differences.
    In my mind, playing against a weaker team should always give you somewhat higher ratings (and the other way around).

    I found this quite helpful to select my starting 11 and in the decision of replacing a player.

    Many thanks to Khris for starting the discussion.
    FC Dacia Terra likes this.

  9. #9
    Apprentice
    Join Date
    Nov 2015
    Posts
    275
    Seems that some of you track the performance of the team, but are you able to predict what rating will have a player in upcoming match?
    missing T11 old form

  10. #10
    Rookie
    Join Date
    Dec 2016
    Posts
    83
    Quote Originally Posted by ronnymvc View Post
    Seems that some of you track the performance of the team, but are you able to predict what rating will have a player in upcoming match?
    Not realistic of course.
    But you can still assess where the player is on his form curve and make some decisions accordingly.
    ronnymvc likes this.

Page 1 of 3 123 LastLast