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.
:D
Printable View
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.
:D
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...
Attachment 82062
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.
Attachment 82069
Attachment 82068
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. https://uploads.tapatalk-cdn.com/201...7550ca3784.jpg
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
Hello,
you can share the fils excel with us ?
I would like to track my team thank you
where can i find those tools?
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
Attachment 82434
- ratings frequency distribution, to see how often each rating value is obtained.
Attachment 82435
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.
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? :)
Looks very interesting, since T11 changed the training module, that also impacts performance of the players, however I can't find a way to relate training with performance, have you been able to do it?
Moved From Formations and Tactics, pending to be sticky.
Hi there,
with a new season around the corner, I've thought I would share my own calc-sheets to help you track your T11 seasons.
The two templates are entirely free of any ****ty macros, free of charge, as they've been created with Libreoffice and hopefully
free of any bugs...
Simply use those two templates at the beginning of each new season, by opening those and renaming them into some
name of your choice ending in .ods (odf spreadsheet).
The first of the two is the League.and.Competitions.templates.ots file.
In there, just fill out the Team.Setup sheet with all the
teams of the new season. Furthermore, as Nordeus isn't capable of maintaining a consistent league draw, you'll also have
to do some copy/paste of variables to reflect the league draw of Nordeus at the beginning of each season. More details are
visible from within the sheet itself.
The second one is a huge one. That would be file number two, called Player.and.season.stats.templates-Forum.version.ots
You'll have to fill in some team, level and season specific value within the Main sheet.
Within the Setup sheet, you just need to input your season opponents once the draws are made...
The rest is adjustable, but mostly not needed as almost all variations are already covered.
The most "manual" interaction is due within the Team sheet. In there, you'll have to adjust your team specific
details. Once filled in, the data gets populated into all forthcoming sheets. The opponents details and informations are
optional. Use them for the "big matches" or leave it, you're all free humans...
Just some changes are needed for the Skills.Matrix sheet. All field are selectable and clearly marked!
Select your actual level, including your training & drills levels, nothing more to do there...
Lastly, fill in all the data within the Fixtures sheet as the season progresses. I've made an initial entry to show
how it looks like. Do not edit the result field, as the links will be available once the corresponding match is played.
All other worksheets, will be populated once the season progresses and the matches are finished. You'll find the
following team related stat sheets;
- Team.summary
- Team.season.stats
- Team.stats.overall(locked to disable editing...)
The relevant player stats are within the following sheets;
- Player.stats.summary
- Player.Win.Loss.Stats
- Player.Ratings
- Player.individual.Stats
- Player.stats.overall(locked to disable editing and fumbling around...)
The template finishes off, with the match details of a maximum of 50 season matches (Match (1) - Match (50)).
Match Summary input fields:
- Select your own formation and the opponents formation
- select your first 11 including your bench 7
- optionally select the opponents first 11 and his bench 7
- select the minute of play and the corresponding action (actions and player are selectable from the list)
Over and done!!!
As those Libreoffice spreadsheets are free of charge, do not ask for a ****ing Microsoft proprietary Excel version,
there will never ever be one, as long as there is UNIX, the best Operating system on earth...
Moreover, I'm not your goddamn Nanny, do not ask stupid questions, I won't give Moron's support either!
Use it, or leave it! If you don't know how to use the templates, do not use them at all...
In the unlikelihood that you encounter some errors or something fishy, document the same, fill a change request
and I'll make a new revision according to my own change process.
I do hope, those who know there ****, will enjoy and find the templates useful, else, I don't care...
As I haven't been able to attach the files directly to this post, both have been made available for download
under the following links;
https://178.62.245.81/owncloud/index...Hq60tegv7UaVAc
https://178.62.245.81/owncloud/index...4fmW6P8h1yRS78
The code for the download is;
T11templates
I hope some mod can shed some light into the matter of how to attach the files directly (filesize limit for zipfiles; 97kb - WTF???)
Have fun...
Wooow, look nice.
The "Player.and.season.stats.templates-Forum.Version.ots" template has been updated.
The Match summary now includes the tactics used and some minor bug fixes for auto-calculating facts correctly.
Some other minor fixes within the locked sheet have been included as well. Those affect all other sheets within the template,
hence, it's a good idea to download the updated version.
The download link is valid until end of April. No downloads possible after that deadline.
https://178.62.245.81/owncloud/index...4fmW6P8h1yRS78
Download code is still the same: T11templates
Nordeus are using Berger Pairings to make fixture list, however they don't use standard methods because they want to avoid giving one team home advantage in first two games of the season. I have figured pattern for season 105 and I can PM you that if you want maybe it will make your first file less complicated. I will of course check if my theory is correct for season 106 once fixtures are out.
Wow... Impressive... But dont you think you guys taking this game too far?
Hi,
Any chance to get the file or a new link here?
Thanks.
I join the link request if someone has it to download :D
Waiting for a new link
Example how a team is oscillating during a season...
Attachment 126325