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.
Hi Good Day!
A serious freelancer here.
I've done a lot of work like this as a Project Management Officer. If I can do it using formula only, I can use VBA macro to completed this. I can create you an automatic combination or team generator. Please consider my bid.
With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel.
I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients.
Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!