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.
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
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
Reply With Quote