Generate all possible combinations - 8 games, 2 teams, 3 outcomes

Hi all,

I need to create a spreadsheet which will generate all possible combinations of 8 games of soccer consisting of two teams who can each win or come a draw (3 outcomes per game).

Note: For every game, there will be three outcomes however there are 8 different games therefore those three outcomes will need to be calculated again against the other 24 outcomes (3*8) to give me ALL possible outcomes without repeating (i.e Team A win, Team C Draw & Team C Draw & Team A win is the same outcome).

Not the best explanation sorry! I have attached an example which I have created manually which I hope helps however please note I require 8 games containing 16 different teams (2 per game). I've browsed through a few threads where people have mentioned MACROS & VBA which I've never used before.. I do need to be able to change the team names on a weekly basis.

Apparently there are 6561 possible outcomes.. I need details on exactly what they would be.

Thanks in advance,
Aravia

There's a workbook at https://app.box.com/s/f21e5iithnbg13alcqbt with formula- and vba-based methods to do that.

Row\Col	B	C	D	E	F	G	H	I
4	HW	HW	HW	HW	HW	HW	HW	HW
5	D	D	D	D	D	D	D	D
6	AW	AW	AW	AW	AW	AW	AW	AW
7
8	HW	HW	HW	HW	HW	HW	HW	HW
9	HW	HW	HW	HW	HW	HW	HW	D
10	HW	HW	HW	HW	HW	HW	HW	AW
11	HW	HW	HW	HW	HW	HW	D	HW
12	HW	HW	HW	HW	HW	HW	D	D
13	HW	HW	HW	HW	HW	HW	D	AW
14	HW	HW	HW	HW	HW	HW	AW	HW
15	HW	HW	HW	HW	HW	HW	AW	D
16	HW	HW	HW	HW	HW	HW	AW	AW
17	HW	HW	HW	HW	HW	D	HW	HW
18	HW	HW	HW	HW	HW	D	HW	D
19	HW	HW	HW	HW	HW	D	HW	AW
20	HW	HW	HW	HW	HW	D	D	HW
21	…	…	…	…	…	…	…	…

Hi Aravia

Someone else asked for something like your question for 5 games
I solved that in a much simpler way (less professional looking), easier to read for a newby

Besides it has the chance to select some games as "must be winer" so, no draw result is possible.
just put a mark( put a leter or a number) in the correspondent cell.

Start your spreadsheet like this image:

Captura.PNG

and run this code

Please Login or Register  to view this content.

hope it helps you

Hi @dymaster

check the attached file, it is ready for 10 games, but the table is prepared for 12 games and 24 teams
just increase 2 more "for next's loops" and complete the inner "g loop".

Take care about the time, the code will run for more than 30 seconds for the 10 games, and it will look like frozen...
just be patient and wait for the results.
If you go for 12 games, time will be much, much longer !!
Play a bit with it, and comment us how are you going on.

cheers

avido welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

avido welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Hey does your link still work kindly resend it to me via [email protected] please

Originally Posted by 0727490993

Hey does your link still work kindly resend it to me via [email protected] please

I have removed your email addy, it is never a good idea to post personal info in a public web site

Also, please read my posts above regarding posting on other member's threads

Welcome to the board.

That's 3^13 ~ 1.6 million possible outcomes. What would you do if you had them?

Please Login or Register  to view this content.

	A	B	C	D	E	F	G	H	I
2	1111111111111	1X11111111111	1211111111111	X111111111111	XX11111111111	X211111111111	2111111111111	2X11111111111	2211111111111
3	111111111111X	1X1111111111X	121111111111X	X11111111111X	XX1111111111X	X21111111111X	211111111111X	2X1111111111X	221111111111X
4	1111111111112	1X11111111112	1211111111112	X111111111112	XX11111111112	X211111111112	2111111111112	2X11111111112	2211111111112
5	11111111111X1	1X111111111X1	12111111111X1	X1111111111X1	XX111111111X1	X2111111111X1	21111111111X1	2X111111111X1	22111111111X1
6	11111111111XX	1X111111111XX	12111111111XX	X1111111111XX	XX111111111XX	X2111111111XX	21111111111XX	2X111111111XX	22111111111XX
7	11111111111X2	1X111111111X2	12111111111X2	X1111111111X2	XX111111111X2	X2111111111X2	21111111111X2	2X111111111X2	22111111111X2
177146	1122222222221	1X22222222221	1222222222221	X122222222221	XX22222222221	X222222222221	2122222222221	2X22222222221	2222222222221
177147	112222222222X	1X2222222222X	122222222222X	X12222222222X	XX2222222222X	X22222222222X	212222222222X	2X2222222222X	222222222222X
177148	1122222222222	1X22222222222	1222222222222	X122222222222	XX22222222222	X222222222222	2122222222222	2X22222222222	2222222222222

@shg...forum guru
It really solved my request to some extent. Thanks for your solution. Again thank you.
Is it possible for each single outcome/combination of 13 games to be placed in 13 cells eg A1 to A13 and next one on B1 to B13 instead of being placed in a single cell?

Copy one of those 9 columns to another sheet, select the new column > Data >Text to columns, Fixed width, ...

Originally Posted by Gacheru

Hi Experts
I wish to generate all possible outcome for 13games, 2 teams, 3 outcomes.
Anyone who can assist in modifying any of the excels within the thread.
Any assistance is highly appreciated.

Notwithstanding that your question is being answered, we prefer that you ask a new question in a new thread.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Welcome to the forum!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

@nkingi

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.