Excel Sheets to create Teams

I have some work, in an Excel spreadsheet. I want to appoint freelancer to draft an excel file where there are any number of players list The conditions are as below :- to Create Team by picking Max 11 players as per the following combinations (P1,P2,P3 P4) within a budget of 100 credits. Step 2: Create your Team Select players for team from all 4 of the categories mentioned below: WK - Wicket-keeper (1) BAT - Batsmen( min 3 & max 5) AR - All-rounders( min 1 & max 3) BWL - Bowlers( min 3 & max 5) So there can be numerous combinations(depending upon the No of players provided every time) for the team which could be created at one click Once all the combinations are created.. we need to check which teams credits sum to 100 credits or less The input will be any number of players players and the credits required and the points earned so far. After that from the shortlisted teams can auto create an combinations of Captain & vice captain for each team & each player. This will be separate sheet where I will enter the players team. The combinations of Captain and vice Captain should output in next excel.