Results 1 to 2 of 2

Random Team Generator

This is a discussion on Random Team Generator within the Excel Questions forums, part of the Question Forums category; I am trying to find a fair way to select my 5 a side football(Soccer) teams based on a player ...

  1. #1
    New Member
    Join Date
    Dec 2011
    Posts
    5

    Default Random Team Generator

    I am trying to find a fair way to select my 5 a side football(Soccer) teams based on a player rating between 1 - 5. In Col A i have the player name and Col B i have their rating, i.e. James Shaw - 4.

    I want to be able to select two teams out of the ten players available which wouldnt have all of the highest rated players on one side. Can this be done?

  2. #2
    New Member
    Join Date
    Jan 2012
    Posts
    33

    Default Re: Random Team Generator

    Hi Bertie. If you number your players 1 through to 10, then below is a list of all possible teams

    12345
    12346
    12347
    12348
    12349
    123410
    12356
    12357
    12358
    12359
    123510
    12367
    12368
    12369
    123610
    12378
    12379
    123710
    12389
    123810
    123910
    12456
    12457
    12458
    12459
    124510
    12467
    12468
    12469
    124610
    12478
    12479
    124710
    12489
    124810
    124910
    12567
    12568
    12569
    125610
    12578
    12579
    125710
    12589
    125810
    125910
    12678
    12679
    126710
    12689
    126810
    126910
    12789
    127810
    127910
    128910
    13456
    13457
    13458
    13459
    134510
    13467
    13468
    13469
    134610
    13478
    13479
    134710
    13489
    134810
    134910
    13567
    13568
    13569
    135610
    13578
    13579
    135710
    13589
    135810
    135910
    13678
    13679
    136710
    13689
    136810
    136910
    13789
    137810
    137910
    138910
    14567
    14568
    14569
    145610
    14578
    14579
    145710
    14589
    145810
    145910
    14678
    14679
    146710
    14689
    146810
    146910
    14789
    147810
    147910
    148910
    15678
    15679
    156710
    15689
    156810
    156910
    15789
    157810
    157910
    158910
    16789
    167810
    167910
    168910
    178910
    23456
    23457
    23458
    23459
    234510
    23467
    23468
    23469
    234610
    23478
    23479
    234710
    23489
    234810
    234910
    23567
    23568
    23569
    235610
    23578
    23579
    235710
    23589
    235810
    235910
    23678
    23679
    236710
    23689
    236810
    236910
    23789
    237810
    237910
    238910
    24567
    24568
    24569
    245610
    24578
    24579
    245710
    24589
    245810
    245910
    24678
    24679
    246710
    24689
    246810
    246910
    24789
    247810
    247910
    248910
    25678
    25679
    256710
    25689
    256810
    256910
    25789
    257810
    257910
    258910
    26789
    267810
    267910
    268910
    278910
    34567
    34568
    34569
    345610
    34578
    34579
    345710
    34589
    345810
    345910
    34678
    34679
    346710
    34689
    346810
    346910
    34789
    347810
    347910
    348910
    35678
    35679
    356710
    35689
    356810
    356910
    35789
    357810
    357910
    358910
    36789
    367810
    367910
    368910
    378910
    45678
    45679
    456710
    45689
    456810
    456910
    45789
    457810
    457910
    458910
    46789
    467810
    467910
    468910
    478910
    56789
    567810
    567910
    568910
    578910
    678910

    Calculate the total score for each possible team.

    Choose one with a total score equal to half the total score of all 10 players.
    This will give you you first team. The second team will be the remaining 5 players.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com