[GET] SOCCER BETTING Generate all possible combinations EXCEL spreadsheet

[SHINOBI NINJA]

Combinations code:

How the software works:
a. Generate a list of 24 possible data outcomes (8 teams which can either Win, Lose, or Draw).
b. Take combinations of the 24 items 8 at one time.
c. If any team is duplicated in the result (occurs more than once), do not include that result in the final data. According to a table of combinations 24 items taken 8 at one time generates 735,471 combinations.
d. Each result that contains 8 different teams is output to the SpreadSheet.

See the attached file which contains the following code. I made the code specific to your problem, rather than generalized, in order to make it a little easier to understand the code.


a. how can I reduce it down to 6 games?
b. Can I get it to display the team in column C as a Win rather than their opponent as a loss?
See the attached file, which has options for:
a. The number of games to include (2 thru 12 inclusive)
b. Replacing 'Lose' with 'Win' for the winning team.
c. Including the names of both teams for a 'Draw'.


On my old Vista 32 bit computer running times were:
06 teams = 5 seconds
07 teams = 17 seconds
08 teams = 65 seconds
09 teams = 5 minutes
10 teams = 25 minutes
11 teams = 2 hours (estimate)
12 teams = 10 hours (estimate)


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.

https://www27.zippyshare.com/v/kKnGJQ4S/file.html

[wesley3]

Thanks for this curious share Shinobi Ninja. Let's see how it works. Max reps added.

[wesley3]

So how do I analyze the massive data generated?

[Expand]

Thanks for the share, reps added.

I'm a bit confused about how to work this spreadsheet, any chance of some instructions? Thanks.

[frankledges]

Can you send a video tutorial on how to use this software Sir? Rep given and have a great day.

[a n o n y m o u s]

(12-17-2018 08:22 PM)SHINOBI NINJA Wrote:  Combinations code:

How the software works:
a. Generate a list of 24 possible data outcomes (8 teams which can either Win, Lose, or Draw).
b. Take combinations of the 24 items 8 at one time.
c. If any team is duplicated in the result (occurs more than once), do not include that result in the final data. According to a table of combinations 24 items taken 8 at one time generates 735,471 combinations.
d. Each result that contains 8 different teams is output to the SpreadSheet.

See the attached file which contains the following code. I made the code specific to your problem, rather than generalized, in order to make it a little easier to understand the code.


a. how can I reduce it down to 6 games?
b. Can I get it to display the team in column C as a Win rather than their opponent as a loss?
See the attached file, which has options for:
a. The number of games to include (2 thru 12 inclusive)
b. Replacing 'Lose' with 'Win' for the winning team.
c. Including the names of both teams for a 'Draw'.


On my old Vista 32 bit computer running times were:
06 teams = 5 seconds
07 teams = 17 seconds
08 teams = 65 seconds
09 teams = 5 minutes
10 teams = 25 minutes
11 teams = 2 hours (estimate)
12 teams = 10 hours (estimate)


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.

https://www27.zippyshare.com/v/kKnGJQ4S/file.html

hi can you re-upload?

[tariqlanez77]

Can you reupload it and aside i have a good corner method which can be made into excel tool