# Thread: Win Draw or Loss combinations by %

1. ## Win Draw or Loss combinations by %

Hello, for example (Win=1), (Draw=X) & (Loss=2) if we select all 3 options for each team then…14 teams will generate 3*3*3*3*3*3*3*3*3*3*3*3*3*3=4782969 combinations (3^14=4782969). And will be distributed 1, X or 2 in the equally with 33.33% for each options.

In this example I have selected 2 options for each teams in this case 2 options for team in this case 14 teams will generate 2*2*2*2*2*2*2*2*2*2*2*2*2*2=16384 combinations (2^14=16384). And will be distributed 1, X or 2 in the equally with 33.33% for each options.

What I want……

For example if I select for Team-1, In C6 (X=20%) and for team-2, In D6 (2=80%)
And complete choosing for all 14 Teams 2 option (either 1, X or 1, 2 or X, 2 as option to generate combination with 20%-80%) I believe this will generate fewer combinations.

Any how I want also VBA can give an option (how many combinations I need) for example I input 500 VBA generate 500 for Team-1 must have 500*20%=100 of X’s and 500*80%=400 of 2’s… and the same % for rest 13tn Teams as specified in the range b6:d19 for each 1, X or 2 %...

Hope this is explained if any question please let me know I will try to answer.

Regards,
Moti

2. ## Re: Win Draw or Loss combinations by %

Hello, the file below is attached with some code which generate combination very closely to % but not accurate as it should be. Please check inside the file there is instruction how the code work. Please help to improve for accurate %. Thank you

Regards,
Moti

3. ## Re: Win Draw or Loss combinations by %

Hello to all, master coders have a nice day, please someone has solution of my query to make code that generate combination with accurate % ... Regards, Moti

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•