Combinations generation

I want to create 11 members teams from 22 players ( Two Different Teams) & Each team has 4 categories. Each player will have his own credits to choose the team below 100 credits. Total created team credits should not cross 100. Please see more details below. 1) Keeper :- Need to choose min 1, max 4 2) Batsman :- Need to choose from min 3, max 6 3) All Rounders :- Need to choose min 1, max 4 4) Bowlers :- Need to choose min 3, max 6 only. Need to generate all possible types of team formation with the above rules. Find the below exampels. Keeper Batting AR Bowling 1 5 1 4 2 3 3 3 3 3 2 3 4 3 1 3 1 6 1 3 1 3 1 6 1 3 4 3 Also we need to choose 7 players maximum 4 players minimum from each team. Also need to create captain & Vice Captain for each team from the created teams. Excel need to generate all possible 11 members teams from the given 22 players & Rules. Need to provide serach button to serach the teams from the created teams including captain and vice captain. After the match i will enter each player points, Excel should show the top scoring team in the excel. Captain will have x2 point, vice captain will have x1.5 points. All exampels & More details provided in the attached excel. Before accepting the project please have a look inot the excel, More details are there to understand better. Accpet this project if you can complete it. All team generation process should be complete in 2 horus including captain and vice captain. I will provide you the excel that i used previousley to generate the teams. if you have any doubts i can explain you through chat.