Hi, everybody!
I would like to request some assistance for the following: each weekend me and a group of friends play a football match, and we always have trouble when making the starting lineups, so I want to create a formula or a macro that can create random, balanced teams based on the player's positions and skills.
Initially I have 3 columns: player name, position (GK - goalkeeper, DF - defender, MF - midfielder and AT - attacker) and skill (from 1 to 5).
I have to fill a lineup that deploys 2 teams with 1 GK, 4 DF, 4 MF and 2 AT each, trying that each squad is balanced (skill) and the players play in their preferred position. For example, avoid assigning too many AT to one team.
If we have extra people playing on that day, let's say 24, we select 20 starters, and the other 4 will play one half each (so each team has a sub). It would be very interesting to find a way to add this consideration into the lineup generator.
Thank you in advance!
I would like to request some assistance for the following: each weekend me and a group of friends play a football match, and we always have trouble when making the starting lineups, so I want to create a formula or a macro that can create random, balanced teams based on the player's positions and skills.
Initially I have 3 columns: player name, position (GK - goalkeeper, DF - defender, MF - midfielder and AT - attacker) and skill (from 1 to 5).
I have to fill a lineup that deploys 2 teams with 1 GK, 4 DF, 4 MF and 2 AT each, trying that each squad is balanced (skill) and the players play in their preferred position. For example, avoid assigning too many AT to one team.
If we have extra people playing on that day, let's say 24, we select 20 starters, and the other 4 will play one half each (so each team has a sub). It would be very interesting to find a way to add this consideration into the lineup generator.
Thank you in advance!