Đã Đóng

Teams Creation with all possible combinations

I want to create 11 member teams from 22 players ( Two Different Teams) & Each team has 4 categories. Each player will have his own points. Total created team points should not cross 100. Please see more details below.

1) Keeper :- Need to choose only 1 keeper from 2 players from two teams.

2) Batsman :- Need to choose from 3 to 5 only.

3) All Rounders :- Need to choose from 1 to 3 only.

4) Bowlers :- Need to choose from 3 to 5 only.

Total we will have 7 types of team formation. Please look into the below table

Keeper Batting AR Bowling

1 5 1 4

1 5 2 3

1 4 1 5

1 3 2 5

1 3 3 4

1 4 3 3

Also we need to choose 7 players maximum from 1 team.

Also need to create captain & Vice Captain for each team from the created team. Excel need to generate all possible 11 members teams from the given 22 players with provided 22 players.

Kĩ năng: Excel VBA

Xem nhiều hơn: powerball possible combinations, possible combinations list excel, excel list possible combinations excel, excel all combinations of 6 columns, football combination calculator, how many combinations with 10 teams, combination calculator, excel all combinations of 4 columns, how many combinations with 8 teams, how many possible outcomes of 3 football matches, how many possible outcomes of 4 football matches, possible combinations calculator display spreadsheet, blackjack possible combinations cards, excel list possible combinations characters, possible combinations columns excel, possible combinations mp3, all possible combinations given a constraint, i m a freelancer for two different caterers, i need all philippain word translet in english, i need all physic programming

Về Bên Thuê:
( 0 nhận xét ) Luoyang, China

ID dự án: #19313380