How to generate sports betting possibility for 13 teams

[jamoo]

Hello Excel lent people

My challenge is i would like to generate all betting possibility in a 13 Matches,with 2 games each ,with usual outcomes of 1,X.2
such that there will be 3^13 outcomes -1594323 results,

I dont know much about Excel/VBA formulas but i would really like to have a combinations generator .kindly assist/advise

jamoo

 

[footoo]

If 13 teams play each other twice, each team plays 24 matches.
The total number of matches is therefore 312 (13 times 24).
The total number of possible results is therefore 936 (312 times 3).

How do you want to get to the number of results you require?

 

[footoo]

Perhaps that should be :

If 13 teams play each other twice, each team plays 24 matches.
The total number of matches is therefore 156 (13 times 24 divided by 2).
The total number of possible results is therefore 438 (156 times 3).

 

[jamoo]

Perhaps that should be :

If 13 teams play each other twice, each team plays 24 matches.
The total number of matches is therefore 156 (13 times 24 divided by 2).
The total number of possible results is therefore 438 (156 times 3).

Hello,im sorry i wasnt very clear..its 13 matches,with 26 teams...i e 2 teams playing against each other...this is a 13 matches jackpot bet.

with possible outcome of 1,x,2 win,draw,loss...hence 3^13.=.1,594,323 .outcomes
How can i generate a code in excel to compute all those combinations?
Hope i am clearer now

Thanks

 

[footoo]

Why do you need to generate all possible combinations? How will the info be used?

 

[jamoo]

Evening,excel,
The info will form the basis,of my undergraduate dessertation in university on probability & permutations in sports betting,since betting has hit the youth of my country kenya.
The negative social economic impact it has can only be illustrated by figures.
kindly support me to drive my point home

Rgds

 

[footoo]

How is actually generating all combinations going to help your dissertation?
What do intend to do - include a workbook with a list of 1,594,323 rows? Why would anyone want to look at it?
Is it not sufficient to point out that there are 1,594,323 combinations?

 

[footoo]

Here's a macro.
Taken from here : https://www.ozgrid.com/forum/forum/...-outcome-combinations-for-50-football-matches

Sub stuff2()
Const v& = 13
     
Dim z, y() As String, q(), u&, g&
Dim a&, b&, c&, d&, p&, MaxRow&
MaxRow = Rows.Count
z = Array("H", "D", "A")
u = UBound(z) + 1
ReDim y(1 To u ^ v, 1 To 1)
     
For a = 1 To v
    For b = 1 To u ^ v Step u ^ a
        For c = b To b + u ^ (a - 1) - 1
            For d = 1 To u
                y(c + u ^ (a - 1) * (d - 1), 1) = _
                    z(d - 1) & y(c + u ^ (a - 1) * (d - 1), 1)
            Next d
        Next c
    Next b
Next a


For a = 1 To u ^ v Step MaxRow
ReDim q(1 To MaxRow, 1 To 1)
    g = 0: p = p + 1
    For b = 1 To MaxRow
        If a + b > u ^ v + 1 Then Exit For
        q(b, 1) = y(a + b - 1, 1)
        g = g + 1
    Next b
Cells(p).Resize(g) = q
Next a


ActiveSheet.UsedRange.EntireColumn.AutoFit
End Sub

 

[jamoo]

Thanks ,well recieved....let me try it out

 

[jamoo]

Hello Mr Excel n team,

I run the maros/vba on excel and worked in terms of generating 13..i,e ''v&=13''combinations,but there is a challenge as some combinations starting with ADADA........cant be foound .Kindly advise
Otherwise i am very grateful for your helpfulness allways.

kindest regards