Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget of 100 credits. Step 2: Create your Team
Select players for your Dream11 team from all 4 of the categories mentioned below: WK - Wicket-keeper (1) BAT - Batsmen( min 3 & max 5) BWL - Bowlers( min 3 & max 5) AR - All-rounders( min 1 & max 3)
So there are 7 combinations for the team which could be created.
Once all the combinations are created.. we need to check which teams credits sum to 100 credits. The input will be 22 players and the credits required and the points earned so far. After that from the shortlisted teams create an combinations of Captain & vice captain for each team. This will be separate sheet where I will enter the 11 players team. The combinations of Captain and vice Captain should output in next excel.
10 pekerja bebas membida secara purata ₹698/jam untuk pekerjaan ini
Hello, I thoroughly read your project. it is combination of vba and probability and combination. I do have a strong command on both of the subjects. I can do your project easily.
I am experinced on data entry work. I request to give me the opportunity to work with you. I have very much confidence that I'll complete your work before deadline .
I have huge dataa base which is gonnaa help you alot. Trust me you won’t regret it. Plus I have around 100-400 authenticate mails. So you don’t have to worry about it