Lotto Forums
How To Win

Go Back   Lotto Forums > Lotto Forums Players Toolbox > Lotto Tips & Strategies

Lotto Tips & Strategies Methods and Systems for Winning the Jackpot.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2009, 03:47 PM
Gandalf's Avatar
Gandalf Gandalf is offline
Registered User
 
Join Date: Feb 2009
Location: Netherlands
Posts: 8
6 winning numbers in combination 37/36

Hello everyone ! ( i am brand new here )

I discovered something in the last 100 draws lotto 6/42 and i am searching for a
generator or an another way to find all 37 draws with 36 numbers in the last 100.

I give you an example : Lotto Belgium on 17 january
In the last100 draws before 17 january there is one combination of 37
draws with 36 numbers.

9 13 16 26 27 42
2 14 35 39 41 42
17 18 20 25 30 37
2 30 33 38 39 40
13 15 31 35 37 38
1 14 16 23 34 38
9 15 19 20 34 35
16 23 30 35 38 39
5 6 13 14 20 39
3 16 23 24 39 41
3 9 11 26 40 41
4 5 13 18 25 38
1 11 23 24 31 35
1 3 4 9 22 31
6 11 14 15 25 35
2 4 5 7 17 38
2 5 6 9 11 13
1 2 22 24 29 35
9 19 23 26 29 42
11 13 14 18 37 42
2 11 14 27 29 33
1 4 23 27 29 37
7 16 18 22 34 39
7 18 33 35 38 39
1 11 17 33 34 39
15 18 20 23 24 31
3 4 20 22 27 42
1 4 9 10 27 42
13 23 27 29 33 40
7 19 23 27 35 37
3 5 11 26 33 39
4 19 22 24 27 41
9 23 26 33 34 35
2 6 7 11 24 33
7 23 27 31 33 38
6 19 22 24 33 34
6 17 22 24 38 39

The missing numbers are : 8 - 12 – 21 – 28 – 32 – 36

Lotto results on january 17 2009 are : 8 – 12 – 21 – 28 – 32 – 36

Ofcourse there are too many combinations 37/100 ; but the very most will be 37/42 and then 37/41 and then 37/40 and then 37/39 and then 37/38 and then 37/37

How to get/find (if it possible) all 37/36 combinations in the last 100. ???
The results 37/36 are showing very offently

Feed back would be nice
Gandalf
Reply With Quote
  #2  
Old 02-04-2009, 07:45 AM
GameBelgium GameBelgium is offline
Registered User
 
Join Date: Oct 2007
Posts: 88
I don't know exactly how to do this, but anyway:

Welcome to the 649 forums Gandalf! (Of moet ik zeggen: welkom Noorderbuur)
Reply With Quote
  #3  
Old 02-04-2009, 09:41 AM
Gandalf's Avatar
Gandalf Gandalf is offline
Registered User
 
Join Date: Feb 2009
Location: Netherlands
Posts: 8
40 lines with the 36 numbers

Thank you GameBelgium for feed back !

Lotto results 31 01 09 gives a combination 40/36 with missing
the 6 winning numbers. 40/36 is i think extreme . So there
will be ofcourse somemore 37/36 with the missing 6 winning numbers.

Let's have a look.
(lotto 6/42 is played twice a week )

In the last 100 lines/draws i found this :

20-02-2008 6 8 11 12 27 40
27-02-2008 1 3 16 17 22 28
19-03-2008 2 7 21 26 29 40
26-03-2008 2 30 33 38 39 40
29-03-2008 13 15 31 35 37 38
02-04-2008 4 10 12 14 29 33
05-04-2008 8 11 13 21 27 39
12-04-2008 3 7 8 21 28 32
23-04-2008 1 8 10 22 39 40
17-05-2008 8 13 24 28 30 41
21-05-2008 16 23 30 35 38 39
31-05-2008 3 16 23 24 39 41
04-06-2008 3 9 11 26 40 41
11-06-2008 4 12 23 35 38 40
14-06-2008 1 11 23 24 31 35
21-06-2008 1 3 4 9 22 31
25-06-2008 6 11 14 15 25 35
02-07-2008 8 10 11 12 33 38
09-07-2008 1 2 22 24 29 35
26-07-2008 7 16 21 27 30 31
02-08-2008 2 11 14 27 29 33
06-08-2008 1 4 23 27 29 37
16-08-2008 6 7 16 21 26 31
30-08-2008 2 3 8 16 19 32
03-09-2008 1 12 17 25 37 38
27-09-2008 13 23 27 29 33 40
04-10-2008 7 10 12 16 40 41
08-10-2008 7 19 23 27 35 37
25-10-2008 7 8 11 16 28 30
01-11-2008 4 19 22 24 27 41
12-11-2008 2 6 7 11 24 33
15-11-2008 3 9 10 14 21 29
19-11-2008 10 16 19 26 32 37
29-11-2008 7 23 27 31 33 38
03-12-2008 3 10 24 25 28 31
17-12-2008 6 10 21 22 29 39
27-12-2008 7 8 11 12 19 25
07-01-2009 13 16 19 28 30 37
10-01-2009 6 17 22 24 38 39
14-01-2009 7 11 12 14 21 24

missing numbers are 5 - 18 - 20 - 34 - 36 - 42

The winning numbers at line/draw 101 are

31-01-2009 5 18 20 34 36 42

There are no secrets, there is only information that you don't have yet.

Gandalf
Reply With Quote
  #4  
Old 02-04-2009, 11:57 AM
heminen's Avatar
heminen heminen is offline
Registered User
 
Join Date: Nov 2006
Location: France
Posts: 64
bonsoir

Comment fais tu ce calcul, j'ai du mal à cerner
Apparement sur ta liste, il y a des tirages en moins (?!)

Peux tu extrapoler au nouveau loto FR avec 5/49
Fais un exemple pour mon loto, merci

cdt
Reply With Quote
  #5  
Old 02-04-2009, 10:38 PM
GillesD's Avatar
GillesD GillesD is offline
Registered User
 
Join Date: Oct 1999
Location: Montréal
Posts: 715
Missing numbers

Gandalf,

I am not sure this is exactly what you want, but I found your approach interesting, so I developped the following Excel macro to tell me how many draws it took to cover all numbers except for the number of balls drawn (or in a 6/49 lottery, how many draws did it take to get at least one occurence for 43 of the 49 numbers).

A - Set-up of database
Line #1 contains labels: first "Draw #", then "N1" to "N6". Then starting on line #2 and down, results of all draws with the draw number in column A and from column B to G, the individual numbers for all winning combinations.

B - Output of the macro
For a 6/49 lottery, running the macro will display a message in the form "43 balls present in the last xx draws, leaving balls x1 x2 x3 x4 x5 x6 out", meaning that in the last xx draws all numbers except x1, x2, x3, x4, x5 and x6 appeared at least once.

Note 1: it can happen that 44 numbers are listed the numbers of balls goes from 42 to 44 with the last draw covered.
Note 2: the macro runs fine for a 6/49 lottery, but changing the values for variables nBalls and nOut near the top of the listing should make it work for another lottery.

C - Listing of the macro

Option Explicit

Dim I As Byte, sMess As String, sBalls As String, sRep As String, bNumb() As Boolean
Dim nBalls As Byte, nOut As Byte, nDiff As Byte, nDraw As Byte

Sub PastDraws()
Application.ScreenUpdating = False
Range("A1").Select
Selection.End(xlDown).Select
nBalls = 49 ' number of balls in lottery
nOut = 6 ' number of balls drawn
nDiff = 0
nDraw = 0
ReDim bNumb(nBalls)
For I = 1 To nBalls
bNumb(I) = False
Next I
Do Until nDiff >= nBalls - nOut
For I = 1 To nOut
If bNumb(ActiveCell.Offset(0, I).Value) = False Then
bNumb(ActiveCell.Offset(0, I).Value) = True
nDiff = nDiff + 1
End If
Next I
nDraw = nDraw + 1
ActiveCell.Offset(-1, 0).Select
Loop
sBalls = ""
For I = 1 To nBalls
If bNumb(I) = False Then
sBalls = sBalls & WorksheetFunction.Text(I, "0 ")
End If
Next I
sMess = WorksheetFunction.Text(nDiff, "0") & " balls present in the last "
sMess = sMess & WorksheetFunction.Text(nDraw, "0") & " draws,"
sMess = sMess & vbCrLf & vbCrLf & "leaving balls " & sBalls & " out"
sRep = MsgBox(sMess, vbInformation)
Application.ScreenUpdating = True
End Sub
Reply With Quote
  #6  
Old 02-05-2009, 12:28 AM
bloubul's Avatar
bloubul bloubul is offline
Registered User
 
Join Date: Oct 2004
Location: South Africa
Posts: 854
GillesD

Comme toujours une très bonne macro. Mes compliments, monsieur

BlouBul
Reply With Quote
  #7  
Old 02-05-2009, 01:19 AM
GameBelgium GameBelgium is offline
Registered User
 
Join Date: Oct 2007
Posts: 88
Good feedback Gilles, thanks for the macro.

The one thing that would make it even better is to be able to retrieve the information wanted without knowing the numbers drawn. I had figured out myself how to determine how many drawings within the latest X-100 games did not contain the numbers of drawing X. But in this scenario, the numbers drawn are a given.

The real challenge is to determine how many of these combinations of 6 numbers within the latest X-100 games can be isolated for drawing X+1. And that's a lot more challenging (for me at least ).
Reply With Quote
  #8  
Old 02-05-2009, 01:24 AM
bloubul's Avatar
bloubul bloubul is offline
Registered User
 
Join Date: Oct 2004
Location: South Africa
Posts: 854
Hi GameBelgium

"I had figured out myself how to determine how many drawings within the latest X-100 games did not contain the numbers of drawing X."
Will you please be more direct, I'm very interested.

Thanks

BlouBul
Reply With Quote
  #9  
Old 02-05-2009, 02:24 AM
GameBelgium GameBelgium is offline
Registered User
 
Join Date: Oct 2007
Posts: 88
Just use Excel to determine this: suppose the latest 101 lotto results are in the cells A1-F101. That would mean that the latest 6 numbers drawn are in cells A101-F101.

In cell G1, enter this formula:
=SUM(COUNTIF(A1:F1;A$101);COUNTIF(A1:F1;B$101);COU NTIF(A1:F1;C$101);COUNTIF(A1:F1;D$101);COUNTIF(A1: F1;E$101);COUNTIF(A1:F1;F$101))
and copy this formula to cells G2-G100.

Then, in any free cell, enter this formula:
=COUNTIF(G1:G100;"=0")
which will give you the amount of drawings within the latest 100 drawings which did not contain any of the numbers drawn in drawing 101.

Alternatively, you can change "=0" to "=1" to determine the amount of drawings withing the latest 100 drawings which contained only one of the numbers drawn in drawing 101, etc...

I hope I translated the function names correctly as I work with a Dutch version of Excel.

BTW: I'm not an Excel expert at all, I kind of learned the program by self-study, there may be easier ways to do this.
Reply With Quote
  #10  
Old 02-05-2009, 03:48 AM
Gandalf's Avatar
Gandalf Gandalf is offline
Registered User
 
Join Date: Feb 2009
Location: Netherlands
Posts: 8
The search for the missing numbers...

Thanks all for the feed back !

I shall explain The Challenge – The Puzzle – The Mission
further here.

We all have seen now that there are lines (lotto draws/results ) in the last 100
lines with (6) numbers that do not repeat in line/draw 101.
It’s a simple conclusion, because it’s not possible that every line in the last 100 can have a number(s) from from line 101.

The numbers of line 101 gives offently a result of missing in 37 lines with 36 numbers in de 100 lines before. (by lotto 6/42)

37/100 gives in excel
Combinations (100;37)=3420029547493940000000000000

The most of this combinations will be 37 lines with 42 numbers.

But the search in excel is to find all combinations 37 lines with 36 numbers.
How many 37 lines with 36 numbers(37/36) are there in the last 100 ????

I am study this , not only with excel.
Example : a patron in repeats (or no repeats) from a lotto/draw with 6 numbers result(s) in the last 100 in line 101.

Anyway … I know(sure) that if I look to the last 100 lines on screen in excel that the answer (6 winning numbers) is there. ….a lot of lines/draws with the missing numbers. Many people are always looking for a patron(s) of the winning numbers, I am looking for the missing numbers.

The are no secrets, only information that you don't have yet.

Gandalf
Reply With Quote
  #11  
Old 02-05-2009, 06:43 AM
GillesD's Avatar
GillesD GillesD is offline
Registered User
 
Join Date: Oct 1999
Location: Montréal
Posts: 715
Formulas

Your formulas worked fine (after I translated them into the French version of Excel), except for a minor detail. There should be no space in the third COUNTIF function when the formula listed is copied into Excel.

Thanks for providing this information.

My macro was really not an answer to your needs but it made me look for a way to identify the last 6 numbers that have yet to come out in the last draws.

I should have used the output of my macro to choose the numbers for last night draw; three (yes 3) numbers (16-31-44) were in the winning numbers. It should not always be the case but it is an interesting point.
Reply With Quote
  #12  
Old 02-05-2009, 03:54 PM
lottoarchitect lottoarchitect is offline
Registered User
 
Join Date: Jul 2004
Location: Greece
Posts: 205
Get my program Lotto Architect to do this easily. You can extract that information with s simple process. First setup a draw filter that analyses the last x draws and then use the number statistics to determine the numbers that haven't appeared at all.

cheers
lottoarchitect
Reply With Quote
  #13  
Old 02-06-2009, 12:01 AM
taaroa's Avatar
taaroa taaroa is offline
Registered User
 
Join Date: Apr 2005
Location: Tahiti
Posts: 265
Quote:
Originally Posted by Gandalf
Thanks all for the feed back !

I shall explain The Challenge – The Puzzle – The Mission
further here.

We all have seen now that there are lines (lotto draws/results ) in the last 100
lines with (6) numbers that do not repeat in line/draw 101.
It’s a simple conclusion, because it’s not possible that every line in the last 100 can have a number(s) from from line 101.

The numbers of line 101 gives offently a result of missing in 37 lines with 36 numbers in de 100 lines before. (by lotto 6/42)

37/100 gives in excel
Combinations (100;37)=3420029547493940000000000000

The most of this combinations will be 37 lines with 42 numbers.

But the search in excel is to find all combinations 37 lines with 36 numbers.
How many 37 lines with 36 numbers(37/36) are there in the last 100 ????

I am study this , not only with excel.
Example : a patron in repeats (or no repeats) from a lotto/draw with 6 numbers result(s) in the last 100 in line 101.

Anyway … I know(sure) that if I look to the last 100 lines on screen in excel that the answer (6 winning numbers) is there. ….a lot of lines/draws with the missing numbers. Many people are always looking for a patron(s) of the winning numbers, I am looking for the missing numbers.

The are no secrets, only information that you don't have yet.

Gandalf

Hi,

That seem to be an interesting method. However, I don't yet got it.
I understand that you must search in the last 100 draws all 37 draws (37 draws x 6 numbers) that totalize only 36 numbers of the 42 numbers of that lotto. You can also say it another way : you search for all 37 draws where 6 numbers are missing, or eventually less numbers, 1 or 2 or 3 or 4 or 5.
Now, if you only want the 6 numbers missing for the next drawing i.e drawing 101, I suppose you want to get the last 37 draws with only 36 numbers.
Am i right?

Thank you.

taaroa
Reply With Quote
  #14  
Old 02-06-2009, 01:34 AM
GameBelgium GameBelgium is offline
Registered User
 
Join Date: Oct 2007
Posts: 88
Lotto Architect, that's not the information we're searching for in this forum thread. Missing numbers in the last x draws are easy to find, with or without software. What we're searching for is a lot more complex, but I'm not gonna repeat it here, take some time to read the posts.

Taaora, no, what you're saying is not the same. The 37 drawings can occur anywhere within the last 100 drawings, and that's not necessarily the last 37 drawings.
Reply With Quote
  #15  
Old 02-06-2009, 01:42 AM
heminen's Avatar
heminen heminen is offline
Registered User
 
Join Date: Nov 2006
Location: France
Posts: 64
Hello

is it possible to have a macro adapted to the new lotto game in France
from 6/10/2008 it's a new game with only 5/49
But at this date, there were only 53 draws

cdt
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hello; Another newbie here dfms Questions & Answers 5 10-20-2005 01:18 AM
Winning numbers how there are selected Glueckspilz Lotto 649 156 09-02-2005 02:21 PM
Free prediction forum winnerspost Lotto 649 1 04-23-2005 05:35 AM
6/49 Discussion For October 27, 2004 gsobier Lotto 649 127 10-29-2004 08:41 PM
Birthday Bets LT Lotto Tips & Strategies 1 08-14-2003 11:52 PM


All times are GMT -5. The time now is 06:41 PM.

Silver Lotto System
Silver Lotto System

 

Free Lottery Secrets Report
Free Lottery Secrets Report

 

Megamillions 125x125
NEW Lottosend

 


Get Your Best Bet Days

 

Lottosend  468x60

Powered by vBulletin
Copyright © 2000 - 2014 Jelsoft Enterprises Ltd.
Copyright © 1999 - 2014 LottoForums.com