Build an excel for permutations and combinations for dream11team
₹600-1500 INR
Ολοκληρώθηκε
Αναρτήθηκε πάνω από 5 χρόνια πριν
₹600-1500 INR
Πληρωμή κατά την παράδοση
I have some work, in an Excel spreadsheet. 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.
[Image [login to view URL]]
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.
Hi,
My name is Manu Lahariya. I have an MTech and BTech from IIT Kharagpur.
I have 2+ years of experience in VBA. I have worked on multiple excel based functionalities, including export, import, web scrapping and application based macros in VBA.
I can share my previously created macros and workbooks if required.
I am looking to diversify my portfolio using freelancing and would really appreciate the opportunity to work on this.
Please let me know if there are any questions.
-Regards
Manu
₹1.250 INR σε 1 ημέρα
1,0 (1 αξιολόγηση)
0,4
0,4
5 freelancers δίνουν μια μέση προσφορά ₹1.230 INR για αυτή τη δουλειά
Mai bahut achhe se ye aapka work karake de dunga
Relevant Skills and Experience
Brother mai abhi koi work kiya nahi hu but mai ise achhe se karane ki puri koshish karoonga