Guest viewing is currently limited
Install the app
How to install the app on iOS

Follow along with the video below to see how to install our site as a web app on your home screen.

Note: This feature may not be available in some browsers.

Excel Experts?

Status
Not open for further replies.
bicycleheader

bicycleheader

Pieces Of A Man
Forum Supporter
I've been trying for a while to build a random team generator for football tournaments that I do every couple months, that allows you to put in several weightings for each player and pulls out even teams

I've had so many guys in the group that are good at apps, programming, excel etc, tell me they can do it easy, but nobody seems able to. Even tried CHATGPT

Anybody here got any suggestions or possibly could do this easily?

Example:
40 players with a rating from 1 to 10 for

Attack
Defense
Stamina
Tactical
Overall

We want to be able to define how many players per team (in this example 5 per team, 8 teams) and let it pull out a balance across the teams

Have been using keamk.com which does the trick up to a point, but only allowing one basic rating from one to five

Any help would be appreciated!
 

bicycleheader said:
I've been trying for a while to build a random team generator for football tournaments that I do every couple months, that allows you to put in several weightings for each player and pulls out even teams

I've had so many guys in the group that are good at apps, programming, excel etc, tell me they can do it easy, but nobody seems able to. Even tried CHATGPT

Anybody here got any suggestions or possibly could do this easily?

Example:
40 players with a rating from 1 to 10 for

Attack
Defense
Stamina
Tactical
Overall

We want to be able to define how many players per team (in this example 5 per team, 8 teams) and let it pull out a balance across the teams

Have been using keamk.com which does the trick up to a point, but only allowing one basic rating from one to five

Any help would be appreciated!
Click to expand...
Go old skool!

5 hats. One for Attack/Defence/etc

Draw the names out, much more fun.
 
Pootsy said:
Go old skool!

5 hats. One for Attack/Defence/etc

Draw the names out, much more fun.
Click to expand...

Did it by hand for years, well mainly just between a small group of us. Always ended up with people complaining their team wasn’t fair. Last year or so using that one web page there hasn’t been a peep out of anybody, even the ones who lost all their games. So it works, if the rating you put in is decent……just want to make it more precise
 
bicycleheader said:
I've been trying for a while to build a random team generator for football tournaments that I do every couple months, that allows you to put in several weightings for each player and pulls out even teams

I've had so many guys in the group that are good at apps, programming, excel etc, tell me they can do it easy, but nobody seems able to. Even tried CHATGPT

Anybody here got any suggestions or possibly could do this easily?

Example:
40 players with a rating from 1 to 10 for

Attack
Defense
Stamina
Tactical
Overall

We want to be able to define how many players per team (in this example 5 per team, 8 teams) and let it pull out a balance across the teams

Have been using keamk.com which does the trick up to a point, but only allowing one basic rating from one to five

Any help would be appreciated!
Click to expand...

I haven't given this much thought, but if I understand you correctly you want to have randomly picked teams that are roughly fair in terms of player ratings. In thinking about this, the poorest team would consist of 5 players of rating 1, so their total rating sums to 5. The best team would have 5 players of rating 10, so their total rating sums to 50. Maybe you could have a simple rule that picks 5 random players under the constraint that the total players ratings (across all five randomly picked players) sums to >25 and <30 or something. Sorry if this doesn't make sense.
 
bicycleheader said:
I've been trying for a while to build a random team generator for football tournaments that I do every couple months, that allows you to put in several weightings for each player and pulls out even teams

I've had so many guys in the group that are good at apps, programming, excel etc, tell me they can do it easy, but nobody seems able to. Even tried CHATGPT

Anybody here got any suggestions or possibly could do this easily?

Example:
40 players with a rating from 1 to 10 for

Attack
Defense
Stamina
Tactical
Overall

We want to be able to define how many players per team (in this example 5 per team, 8 teams) and let it pull out a balance across the teams

Have been using keamk.com which does the trick up to a point, but only allowing one basic rating from one to five

Any help would be appreciated!
Click to expand...
Ok Sean.
 

verreauxi said:
I haven't given this much thought, but if I understand you correctly you want to have randomly picked teams that are roughly fair in terms of player ratings. In thinking about this, the poorest team would consist of 5 players of rating 1, so their total rating sums to 5. The best team would have 5 players of rating 10, so their total rating sums to 50. Maybe you could have a simple rule that picks 5 random players under the constraint that the total players ratings (across all five randomly picked players) sums to >25 and <30 or something. Sorry if this doesn't make sense.
Click to expand...

That does make sense! Now I have to think about how to do this in excel, but that at least would sort a way to do this with an overall rating per player of 10. Which would be enough of a start for this weekends tournament.

Including more variations is more a nice to have

Thanks!
 
bicycleheader said:
I've been trying for a while to build a random team generator for football tournaments that I do every couple months, that allows you to put in several weightings for each player and pulls out even teams

I've had so many guys in the group that are good at apps, programming, excel etc, tell me they can do it easy, but nobody seems able to. Even tried CHATGPT

Anybody here got any suggestions or possibly could do this easily?

Example:
40 players with a rating from 1 to 10 for

Attack
Defense
Stamina
Tactical
Overall

We want to be able to define how many players per team (in this example 5 per team, 8 teams) and let it pull out a balance across the teams

Have been using keamk.com which does the trick up to a point, but only allowing one basic rating from one to five

Any help would be appreciated!
Click to expand...

No expert but it sounds like something you might have to structure over a whole Excel book using VB code that references diff sheets of info.

DISCLAIMER: I'm likely wrong and/or it's not a very efficient method.
 
Tipp blue said:
View attachment 236182
Not sure if you want the overall randomised in this case I just added the other ratings together.
Click to expand...
Thank you.!

So the ratings will be set values picked by a group of us, no randomising needed there

If we forgot about the 4 individual sets of values for now and just gave each an overall rating 1-10 the question is how to create 8 groups of 5 names without repeating a name, and as @verreauxi said making each team total rating be in the mid range…

Although I was thinking mid range may not actually be between a team of 5 players ranked as 1 and 5 ranked as 10, but perhaps needs to be specific to the total actual ratings of the top 5 and Bottom 5 players. As such the best possible team from my ratings would be 42 and worst would be 15….so midrange 28.5…..so all teams to have a total rating of between 26-31
 

Status
Not open for further replies.

Welcome to GrandOldTeam

Get involved. Registration is simple and free.

Register
Back
Top