I gang

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.

Evner: Excel VBA

Se mere: combination generator excel, 4 digit number combination generator, combination calculator, number combination generator 5 digit, generate all possible combinations of a set of characters, lottery combination generator, 3 digit number combinations generator, combination generator without repetition, vb5 enter click button, enter java chat invisible nick, customize msn chat contact button code, flash as3 keyboard enter button action, live chat button design support, bypass yahoo captcha enter chat room, flash as3 focus field enable enter button, button effects wordpress match main site, gif enter button, enter button animated gif, enter fullscreen button flash, forms submit button click keystroke enter

Om arbejdsgiveren:
( 1 bedømmelse ) Luoyang, China

Projekt ID: #19790413

Tildelt til:


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 Flere

$25 USD på 1 dag
(2 bedømmelser)

2 freelancere byder i gennemsnit $23 på dette job


Hello, sir! I am happy to put my bid on your project. I have a full of experience in data processing using Excel VBA. I have finished many projects like this. I promise I will do your project with high quality. Working Flere

$20 USD på 1 dag
(0 bedømmelser)