# LottoStatisticsXL

#### Nick Koutras

##### Member
Re: keep up the good work ... or just keep up

That's the kind of board this is, just take a quick look at the Winhunter section ... you ain't seen nothin' yet!!

I do not mind the questions.

Believe it or not
I do learn from all these questions.
I do not know all the possibilities that
the program can generate.

What I whish is for order,
so that I can see them all and answer them as required.

##### Member
Nick,

I was going to suggest it earlier but this may be a better time. Could ask LT to dedicate a section for LottoStatistics, like WH, considering the interest/traffic it has generated.
Then you could split things up into categories to suit your needs, what do you think?

#### Irvin

##### Member

Hey Nick I have got 2 excellent performing sets in my test results.

1 lot got 2 x 4 number and 1 x 5 number hit in the last 5 draws.

The other has got a 5+b hit.

Regards,

Irvin

#### hot4

##### Member
Nick Koutras said:
You can change that number to suite
your computer speed and time you have
available.

1000 is the default value I use
You can change it as rep your requirements.

I know that Nick.

Regarding groups of 12 numbers in 6/49 lotto, there are 92,263,734,836 possible combinations. What I'd like to know is:

does LottoStatisticsXL tests only 1000 groups of 12 numbers when I configurate Trials=1000 or does it test more than 1000 groups of 12 numbers?

This question seems important to me, so that we can be aware of how much representative is our sample of trials (10,000; 100,000...).

Frank

#### Nick Koutras

##### Member
hot4 said:
I know that Nick.

Regarding groups of 12 numbers in 6/49 lotto, there are 92,263,734,836 possible combinations. What I'd like to know is:

does LottoStatisticsXL tests only 1000 groups of 12 numbers when I configurate Trials=1000 or does it test more than 1000 groups of 12 numbers?

This question seems important to me, so that we can be aware of how much representative is our sample of trials (10,000; 100,000...).

Frank

The function, (as it is working now) tests
by far more combinations of such n groups of numbers out of the total.

Out of the Duration, starts with the most
frequent number and builts on that, number by number, comparing the Categories range.

The algorithm, as it is now, is not that efficient, but the new version (on which I'm working on will be 50+ times faster and more accurate).

#### hot4

##### Member
Nick Koutras said:
The function, (as it is working now) tests
by far more combinations of such n groups of numbers out of the total.
<snip>

Very Good.

So, Trials= 1000 can test an amount of combinations +- equal to all possible 12of49! A very representative sample.

Frank

#### stakar

##### Member
Unit Sums

Nick
I m back again
Im using your excel program LottoStattisticsXL and i have to admit that it is very powerfull!!
I wanted to ask you for a favor
At the point Hit-Skips i wanted to know if you are on to put someting new.
Im asking about The Unit Sums (You remember the senario of that kind of combinations*Its the sum of each number e.g. the unit sum "1" including the 1-10-19-28-37-46 the "2" the 2-20-29-38-47 etc till the unit sum "9").
So, Im asking if you are up to something new include this in your program, because you have the code ready of using the LD hit-skip senario!!

That all Nick

#### Nick Koutras

##### Member
Re: Unit Sums

stakar said:
Nick
I m back again
Im using your excel program LottoStattisticsXL and i have to admit that it is very powerfull!!
I wanted to ask you for a favor
At the point Hit-Skips i wanted to know if you are on to put someting new.
Im asking about The Unit Sums (You remember the senario of that kind of combinations*Its the sum of each number e.g. the unit sum "1" including the 1-10-19-28-37-46 the "2" the 2-20-29-38-47 etc till the unit sum "9").
So, Im asking if you are up to something new include this in your program, because you have the code ready of using the LD hit-skip senario!!

That all Nick

Yes,

Give me some time.

I do have a great collection of new
ideas to implement.

At the moment I'm working on LottoSelectorXL

#### stakar

##### Member
Nick,
i have a problem with the LottostatistcsXL
I m trying to import a txt file that has 1227 record (Greek lotto)
and it cannt load it, but the file of Greek Joker (5 of 45) that has 649 raws, it works just fine.
If i cut raws from the Greek lotto file from 1227 records to 850 the programm is loading !!!

Best regards
Stathis

#### thornc

##### Member
Stathis

I have used LottoStatistics with the Rome Lotto history which is a 5/90 with well behond 3000draws and it works... aside from losing the header descriptions....

Perhaps there's some problem with the file itself? black lines, bad formatting...

#### stakar

##### Member
Re: Stathis

thornc said:
I have used LottoStatistics with the Rome Lotto history which is a 5/90 with well behond 3000draws and it works... aside from losing the header descriptions....

Perhaps there's some problem with the file itself? black lines, bad formatting...

No, the file its checked!!
Nicks's programm It loads everything but the headers as u said, so without them i cant go on with the other functions, because when i push the 'apply defaults' button i get null cells.
Also when i was tryied to save the database after it was loaded it saved me only a part of it.!!!

#### thornc

##### Member
Re: Re: Stathis

That's easy to solve... do as I do, enter them by hand in the database window!
The No of draws, the name, the pool size and the draw size... that's all that is needed!

stakar said:
No, the file its checked!!
Nicks's programm It loads everything but the headers as u said, so without them i cant go on with the other functions, because when i push the 'apply defaults' button i get null cells.
Also when i was tryied to save the database after it was loaded it saved me only a part of it.!!!

#### stakar

##### Member

thornc said:
That's easy to solve... do as I do, enter them by hand in the database window!
The No of draws, the name, the pool size and the draw size... that's all that is needed!

Thanks Thornc
That the way!!
I Hope in the furure Nick fix it!!

#### stakar

##### Member
Hi there!!
A question about "The Since Last Appeared"
How the Intersect works?
I tried a lot to figure it out but with no result.

Thanks a lot
Stathis

#### Nick Koutras

##### Member
stakar said:
Hi there!!
A question about "The Since Last Appeared"
How the Intersect works?
I tried a lot to figure it out but with no result.

Thanks a lot
Stathis

Hi Stathis,

"SinceLastAppeared" is a very nice function
since it can display the called "Hot/Warm.../Cold" numbers
for all the positions or of any 1 position.

Lets first Define the Terms I used;

Appeared=Is used to Identify How many "Cycles" to use.
By "Cycle" I mean when any number Hit from Once to "Appeared" times.

pS=Indicates the Starting position ie:1st to 6th on a 6/49 game
pF=Inticates the Final position

Intersect=Indicated How many First numbers to include, so that
can we finalize a Frequency Distribution.

Still all these definitions may not make sense to many
but I'll provide some live examples to explain the procedure.

Let say we wish to identify the 10 "Hot" numbers of a 6/49 game
that have hit "at most" 5 times the last n Draws.

The parameters to use are:
Appeared=5
pS=1
pF=6
intersect=10

With these parameters the Function will display the following:
1) When each Number came Once to 5 times each
2) At the very right a Frequency Distribution that includes
the 10 top numbers at each of these 5 distributions.
3) At the position Under "Frq"=5 Displays the numbers that are located
in the First 10 (If any exists) = The HOT ones.

and so on...

So the Hot Numbers for these parameters are Indicated on the TOP
and at the very BOTTOM the very COLD ones and all the others in between.

WE can use Different pS & pF parameters if you want to Identify other
than the 1-->6 positions, and other "Cycles"

Please change the parameters and then try to study the Distribution at the
top of the Output page to understand the Function.

#### stakar

##### Member
Nick Koutras said:
Hi Stathis,

Intersect=Indicated How many First numbers to include, so that
can we finalize a Frequency Distribution.

Still all these definitions may not make sense to many
but I'll provide some live examples to explain the procedure.

Let say we wish to identify the 10 "Hot" numbers of a 6/49 game
that have hit "at most" 5 times the last n Draws.

The parameters to use are:
Appeared=5
pS=1
pF=6
intersect=10

With these parameters the Function will display the following:
1) When each Number came Once to 5 times each
2) At the very right a Frequency Distribution that includes
the 10 top numbers at each of these 5 distributions.
3) At the position Under "Frq"=5 Displays the numbers that are located
in the First 10 (If any exists) = The HOT ones.

and so on...

So the Hot Numbers for these parameters are Indicated on the TOP
and at the very BOTTOM the very COLD ones and all the others in between.

WE can use Different pS & pF parameters if you want to Identify other
than the 1-->6 positions, and other "Cycles"

Please change the parameters and then try to study the Distribution at the
top of the Output page to understand the Function.

Nick,
still dont get it.
I dont understand the way u define the Hot,warm etc numbers.
With these parameters

Appeared=5
pS=1
pF=6
intersect=10

You can get the following results:

Numbers that have appeared from 1 to 5 times
In position 1 to 6
And the first 10 !! That's the question
The first 10 of what ?

Nick Koutras said:
At the very right a Frequency Distribution that includes
the 10 top numbers at each of these 5 distributions.
[/B]

Itried it out with my base and it doesnt match with your results.
If u were using your mind , a pencil and a piece of paper what u would do to calculate the above? Thats what i dont understand at all.

Stathis

#### farmer

##### Member

Nick,

I emailed you a while back, and posted a query on your forum with no reply.

I downloaded both the Excel files LottoStatisticsXL and SelectorXL last month from your web site. The Selector file works just fine on my system (Windows XP, SP2, Excel 2003), but for some reason there were no macros included in the LottoStatisticsXL file.

Did you disable the macros? If you did, fine-- just would like a response.

If anyone has the full file with the macros, is there someone who could email them to me?

farmer

Thanks