Hello all,
The excel files(.xls and .xslx) in the attached .zip document are an offline alternative based on the website laan made, it uses the same calculations to decide player role and duty.
I often use the website myself, but since it is now unavailable, I decided to create this excel file, which should perform the same.
Not all roles/duties are included, this was created for my 4-3-3 system and am sharing this with you.
You will have to manually input all attribute values of the player you want to calculate, if a value is greater then 20, that field will be highlighted in red.
When all fields are filled in, the score will be put next to the role/duty, the highest score(s) will be highlighted in green.
For an example, please see attached .jpg file.
There is no guarantee that your player will play at his best potential, it is a guideline, players need time to adapt to tactics and personal instructions!
There are 2 files included, .xls and .xlsx (both should work the same)
I have not put a protection password on any of the excel files, be careful not to mess it up
Tip: if you are calculating a new player, it is smart to copy the "Framework" onto a new tab/sheet and name it after the player you are calculating, this will save you time if you want to update the player in another season. It also allows you to keep a little database of your own calculated players, all in 1 file!
More role/duties might be added depending on how well people like this (very basic) version and the demand is there to add more role/duties.
Feedback and suggestions are always welcome.
I hope you like it!
The excel files(.xls and .xslx) in the attached .zip document are an offline alternative based on the website laan made, it uses the same calculations to decide player role and duty.
I often use the website myself, but since it is now unavailable, I decided to create this excel file, which should perform the same.
Not all roles/duties are included, this was created for my 4-3-3 system and am sharing this with you.
You will have to manually input all attribute values of the player you want to calculate, if a value is greater then 20, that field will be highlighted in red.
When all fields are filled in, the score will be put next to the role/duty, the highest score(s) will be highlighted in green.
For an example, please see attached .jpg file.
There is no guarantee that your player will play at his best potential, it is a guideline, players need time to adapt to tactics and personal instructions!
There are 2 files included, .xls and .xlsx (both should work the same)
I have not put a protection password on any of the excel files, be careful not to mess it up
Tip: if you are calculating a new player, it is smart to copy the "Framework" onto a new tab/sheet and name it after the player you are calculating, this will save you time if you want to update the player in another season. It also allows you to keep a little database of your own calculated players, all in 1 file!
More role/duties might be added depending on how well people like this (very basic) version and the demand is there to add more role/duties.
Feedback and suggestions are always welcome.
I hope you like it!
Last edited: