• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cricket team combinations generator

Status
Not open for further replies.

Sekhar073

New Member
In a cricket match we'ld be having 11 players a side and total of 22 (WK, Batsmen, Bowlers and All-Rounders). I want to generate all possible valid combinations (11 players team) with 22 players. Attached sample file for reference.

Rules:
MinMax
WK
1​
4​
BAT
3​
6​
BOW
3​
6​
All
1​
4​
Players from each team
4​
7​
Credits <=100
 

Attachments

  • Book1.xlsx
    9.9 KB · Views: 1,459
Hi, Please find attached files with few combinations.
To run Generator you will be a computer like a supercomputer having more than 200GB ram with the latest processors.

But I can give you excel every time on your demand of best 22 players for the below-mentioned combinations for credits till 100.
WKT: 1, BAT: 3, ALL: 2, BOWL: 5
WKT: 1, BAT: 3, ALL: 3, BOWL: 4
WKT: 1, BAT: 3, ALL: 4, BOWL: 3
WKT: 1, BAT: 4, ALL: 1, BOWL: 5
WKT: 1, BAT: 4, ALL: 2, BOWL: 4
WKT: 1, BAT: 4, ALL: 3, BOWL: 3
WKT: 1, BAT: 5, ALL: 1, BOWL: 4
WKT: 1, BAT: 5, ALL: 2, BOWL: 3
WKT: 2, BAT: 3, ALL: 1, BOWL: 5
WKT: 2, BAT: 3, ALL: 2, BOWL: 4
WKT: 2, BAT: 3, ALL: 3, BOWL: 3
WKT: 2, BAT: 4, ALL: 1, BOWL: 4
WKT: 2, BAT: 4, ALL: 2, BOWL: 3
WKT: 2, BAT: 5, ALL: 1, BOWL: 3
WKT: 3, BAT: 3, ALL: 1, BOWL: 4
WKT: 3, BAT: 3, ALL: 2, BOWL: 3
WKT: 3, BAT: 4, ALL: 1, BOWL: 3

for these two also

WKT: 1, BAT: 3, ALL: 1, BOWL: 6
WKT: 1, BAT: 6, ALL: 1, BOWL: 3
TEAMA MIN 4 MAX 7
TEAMB MIN 4 MAX 7
 

Attachments

  • Combinationsold.csv
    876.6 KB · Views: 968
To run Generator you will be a computer like a supercomputer having more than 200GB ram with the latest processors.

:DDo_O

That will rule out practically everyone here from running it, then ...
 
Ya Maybe, that's why I wrote, I can give files on demand.
Generally, Excel has only 10 lac rows...
The generator will generate multiples CSV files of approx 300-350 MB files.
 
If you got the generator could you please send me @Pankajcr7 @d11crea
I have generator if u need generator msz me on whatsapp 9@4@1@8@2@4@5@3@7@1

Moderator Note:
Pankajcr7
As You've read from Forum Rules
  • Please Don't post your Phone Number or Address and be careful posting your email address. Spam robots do trawl forums collecting this info.
    • or You could get a lot of messages to Your given number.
 
Last edited by a moderator:
Ya Maybe, that's why I wrote, I can give files on demand.
Generally, Excel has only 10 lac rows...
The generator will generate multiples CSV files of approx 300-350 MB files.
Hi, Please find attached files with few combinations.
To run Generator you will be a computer like a supercomputer having more than 200GB ram with the latest processors.

But I can give you excel every time on your demand of best 22 players for the below-mentioned combinations for credits till 100.
WKT: 1, BAT: 3, ALL: 2, BOWL: 5
WKT: 1, BAT: 3, ALL: 3, BOWL: 4
WKT: 1, BAT: 3, ALL: 4, BOWL: 3
WKT: 1, BAT: 4, ALL: 1, BOWL: 5
WKT: 1, BAT: 4, ALL: 2, BOWL: 4
WKT: 1, BAT: 4, ALL: 3, BOWL: 3
WKT: 1, BAT: 5, ALL: 1, BOWL: 4
WKT: 1, BAT: 5, ALL: 2, BOWL: 3

WKT: 2, BAT: 3, ALL: 1, BOWL: 5
WKT: 2, BAT: 3, ALL: 2, BOWL: 4
WKT: 2, BAT: 3, ALL: 3, BOWL: 3
WKT: 2, BAT: 4, ALL: 1, BOWL: 4
WKT: 2, BAT: 4, ALL: 2, BOWL: 3
WKT: 2, BAT: 5, ALL: 1, BOWL: 3
WKT: 3, BAT: 3, ALL: 1, BOWL: 4
WKT: 3, BAT: 3, ALL: 2, BOWL: 3
WKT: 3, BAT: 4, ALL: 1, BOWL: 3

for these two also

WKT: 1, BAT: 3, ALL: 1, BOWL: 6
WKT: 1, BAT: 6, ALL: 1, BOWL: 3
TEAMA MIN 4 MAX 7
TEAMB MIN 4 MAX 7
Hey dear could you please tell me where I can edit the players
 
Status
Not open for further replies.
Back
Top