The lottery has 14 numbers from 01 to 14 .

jack

Member
The lottery has 14 numbers from 01 to 14
* 6 numbers are drawn so I need to guarantee 100% 14/6/6
in 100%
Ex =
02 05 09 11 12 14
03 06 ...
 

Frank

Member
The lottery has 14 numbers from 01 to 14
* 6 numbers are drawn so I need to guarantee 100% 14/6/6
in 100%
Ex =
02 05 09 11 12 14 (tel:02 05 09 11 12 14)
03 06 ...
Sounds like you need to write down ALL the =COMBIN(14,6) =3003 combinations then ?
 

Frank

Member
Okay, that's correct, thank you, Frank.

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
Sorry I dont do wheels, not my area of expertise. There is specialist wheel software around to do stuff like that.
 

jack

Member
Okay, thank you, frank, the goal is to get the redial
* from the latest draw for the next soccer lottery
these repetitions vary from 3, to 7 repetitions, when the soccer lottery is converted into numbers from 01 to 42
The problem is to know which marches will repeat
 

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.

123456
123478
123578
123678
124567
124568
134567
134568
145678
234578
234678
235678

These can be mapped to match your actual selections (numbered 1 to 14) ball for ball in their order left to right.
 

jack

Member
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
 

jack

Member
Hello. in the spreadsheet we have the list of draws from 01 to 42 in 14 positions to the left of the analyzes
http://www.mediafire.com/file/jea8x28lfrl2dh3/dois_setores_par_e_impar.xlsx
 

Frank

Member
Hello. in the spreadsheet we have the list of draws from 01 to 42 in 14 positions to the left of the analyzes
http://www.mediafire.com/file/jea8x28lfrl2dh3/dois_setores_par_e_impar.xlsx

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.
 

Sidebar

Top