The lottery has 14 numbers from 01 to 14 .
- Thread starter jack
- Start date
Frank
Member
Sounds like you need to write down ALL the =COMBIN(14,6) =3003 combinations then ?
Frank
Member
You need sheet1 to have cols A to H , rows 1 ro 3003 all empty before running this macro.
Sub getcombs614()
Dim a, b, c, d, e, f, count As Integer
Dim combin(3003) As String
count = 0
For a = 1 To 9
For b = a + 1 To 10
For c = b + 1 To 11
For d = c + 1 To 12
For e = d + 1 To 13
For f = e + 1 To 14
count = count + 1
combin(count) = CStr(a) & "." & CStr(b) & "." & CStr(c) & "." & CStr(d) & "." & CStr(e) & "." & CStr(f)
Next
Next
Next
Next
Next
Next
Range("A1").Select
For count = 1 To 3003
ActiveCell.Offset(count - 1, 0) = combin(count)
Next
Columns("A:A").Select
Selection.Copy
Columns("C:C").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:=".", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, _
1), Array(6, 1)), TrailingMinusNumbers:=True
End Sub
Frank
Member
Whilst I don't do wheels and have no software to do any particular wheel, I think I've figured this one out using logic , commonsense and back testing against all 3003 possible results for 6/14.
The following 12 lines will guarantee at least one match 5 win provided that 5 of your 8 selections from 14 match any of the 6 in the results. A match 5 happens 11.19% of the time.
These can be mapped to match your actual selections (numbered 1 to 14) ball for ball in their order left to right.
The following 12 lines will guarantee at least one match 5 win provided that 5 of your 8 selections from 14 match any of the 6 in the results. A match 5 happens 11.19% of the time.
| 1 | 2 | 3 | 4 | 5 | 6 |
| 1 | 2 | 3 | 4 | 7 | 8 |
| 1 | 2 | 3 | 5 | 7 | 8 |
| 1 | 2 | 3 | 6 | 7 | 8 |
| 1 | 2 | 4 | 5 | 6 | 7 |
| 1 | 2 | 4 | 5 | 6 | 8 |
| 1 | 3 | 4 | 5 | 6 | 7 |
| 1 | 3 | 4 | 5 | 6 | 8 |
| 1 | 4 | 5 | 6 | 7 | 8 |
| 2 | 3 | 4 | 5 | 7 | 8 |
| 2 | 3 | 4 | 6 | 7 | 8 |
| 2 | 3 | 5 | 6 | 7 | 8 |
These can be mapped to match your actual selections (numbered 1 to 14) ball for ball in their order left to right.
Bahh! Frank, very good job, congratulations, thank you.
* FRANK = has converted soccer games into numbers
* We have 3 columns of 14 markings
01 02 03
04 05 06
07 08 09
10 11 12
13 14 15
16 17 18
19 20 21
22 23 24
25 26 27
28 29 30
31 32 33
34 35 36
37 38 39
40 41 42
Frank, on average repeats from 3 to 7 markings from last to next
* And this wheel you made will be of good use.
What I noticed is that hitting the quantities and where the repetitions go from the last to the next
* The rest do not need triples
* Ex = hit that will repeat 5 markings of the last draw, the other 10 does not have to be triple
* Only doubles is already 100%
Because if one of the 10 happens there enters the groups of 5, so you do not need the triples
* In the 10 remaining marazions, fanstastic, thank you frank
* FRANK = has converted soccer games into numbers
* We have 3 columns of 14 markings
01 02 03
04 05 06
07 08 09
10 11 12
13 14 15
16 17 18
19 20 21
22 23 24
25 26 27
28 29 30
31 32 33
34 35 36
37 38 39
40 41 42
Frank, on average repeats from 3 to 7 markings from last to next
* And this wheel you made will be of good use.
What I noticed is that hitting the quantities and where the repetitions go from the last to the next
* The rest do not need triples
* Ex = hit that will repeat 5 markings of the last draw, the other 10 does not have to be triple
* Only doubles is already 100%
Because if one of the 10 happens there enters the groups of 5, so you do not need the triples
* In the 10 remaining marazions, fanstastic, thank you frank
Frank
Member
Well I’m glad you can make use of it. Presumably you posted your spreadsheet for other readers who may be interested. It’s not something I will be getting involved with, so good luck to you.