| Forum » FAQ & Tutorials » "How to calculate the progression of your players" | Date | |
|---|---|---|
|
Username
227 msgs.
Substitute
|
Edited by ofillodolobato? 10-06-2011 19:53 |
30/04/2011 21:08 |
| ☢ Salvaterra - Div3/Gr5 | ||
|
Username
1 msgs.
Ball boy
|
@shengli said: Thank you  everybody will find this extremely useful! |
01/05/2011 23:46 |
| - Div/Gr | ||
|
425 msgs.
First-team player
|
This document seems to be set as private. I've requested access, but still no dice. What are the key formulas should we want to calculate it out ourselves? | 10/06/2011 19:01 |
| - Div/Gr | ||
|
Username
227 msgs.
Substitute
|
https://spreadsheets.google.com/spreadsheet/ccc?key=0Am8rtLJ5DlmodDYtMTdwTGtJTHBNTkt5UTI0Ry1MOHc&hl=en_GB&authkey=CPTS__UB made by: jaybee3. (Edited & Working) |
10/06/2011 19:43 |
| ☢ Salvaterra - Div3/Gr5 | ||
|
Username
26 msgs.
Child's coach
|
Following on the great work of ofillodolobato and shengli, I added a few columns to sheet2 to figure out what is the best training activity for your team based on overall benefits. Of course, even though organising midfielders might be the best activity if you need to improve defense forget about it. The first average column is just assuming that every position is covered in the team by only one player (that would make "organise midfielders, ball control and running the best 3 types of training). Because the previous count of players per position is very unlikely, I have also added several columns that will be modified according to your team structure. So if your team has 10 defenders or 14 midfielders it will modify the averages accordingly. And I have also divided them in goalkeeper, defenders, midfielders and forwards in case you decide to focus on one particular field area. Once again, this assumes that the percentages provided for each position and each type of training are correct. Not sure why there is two input areas for player motivation in sheet1 calculator for individual positions. https://spreadsheets.google.com/spreadsheet/ccc?key=0AuBYn1darVj0dFJ4Z3BhU1dMM0hDUjdreXJhX2dFakE&hl=en_US&authkey=COLinpwN |
12/06/2011 16:02 |
| - Div/Gr | ||
|
Username
6 msgs.
Cadet
|
my championship is over. when i can start another season ? amin i play just 3 matches in this season and the board told to me.. it's over  |
16/06/2011 00:33 |
| - Div/Gr | ||
|
Username
1 msgs.
Ball boy
|
great stuff Edited by asnippe 16-06-2011 01:44 |
16/06/2011 01:20 |
| - Div/Gr | ||
|
39 msgs.
Child's coach
|
Hi all, I have seen various iterations of the training calculator spreadsheet flying around and was also told of the back calculation that can be done to work out your player's progression %. Armed with this information, I decided to have a go at making a spreadsheet myself to work out the progression % and used the training effectiveness tables from the existing spreadsheets. The spreadsheet now works as intended but a lot of the progression % figures turn out to be unrealistic because some of the training effectiveness %'s seem to be wrong, often giving 1% when it should be much more. Is there a definitive / reliable table of training effects anywhere that I could plug into this spreadsheet and make it useful? Cheers, Mik |
20/06/2011 15:54 |
| - Div/Gr | ||
|
Username
9 msgs.
Cadet
|
Dude it doesn't work! I can't open the file! | 22/06/2011 17:59 |
| - Div/Gr | ||
|
Username
26 msgs.
Child's coach
|
You have to copy the whole link. It is shared with anyone https://spreadsheets.google.com/spreadsheet/ccc?key=0AuBYn1darVj0dFJ4Z3BhU1dMM0hDUjdreXJhX2dFakE&hl=en_US&authkey=COLinpwN |
22/06/2011 22:56 |
| - Div/Gr | ||
2
