Tools to track your team performance

[MiddleEarth]

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...