LottoSelectorXL v102

LottoSelectorXL v102 is ready to download.

http://www.geocities.com/socratiou/index.htm

I did not include on this release the Global Filters
and the Filters of each method.

The Global Statistics of each method can provide
statistical analysis of the success of each method
and can be used as a good indicator.
The function will be included on some later version.

I'll discuss these filters on the forum and upon request.


I'll explain briefly each of the 5 methods used
for selection of numbers for your Lotto game.

Method 1: Critical Binomial
This method is based on the CritBinom Function of MS Excel.
You adjust the Input parameters to suite your needs
and then you press the Critical Binomial button
The most important parameters are "useDraws" and
"confidence".

Method 2: 3-Bins Method.
This method divides the games' total numbers in 3 fields (bins)
by using some Lattice Design and then analyses the hits of
each Bin.
To provide different results, the spinner selection
will accomplish this task.
The input fields are straight forward.

Method 3: Random
This method is using 6 Random Number Generators.
The Input fields are straight forward.

Method 4: Announcers as Neural Net
This method is a modified method of the Announcers that
is discussed in the forum but instead of only the last
draw is using the last n draws that do cover the half
of the numbers of your game.
For example on a 49/6 game uses as many last draws
that will include 24+ numbers. Usually 4-5 last draws.
After that it works as standard announcers.
More answers will be posted upon some discussion on the
forum.
The slider provided is used to indicate the % of draws
to be used to teach the NeuralNet

Method 5: SynXronizer
This method synchronizes Random numbers of n Last Draws
and the displays the next Random Set, specified by the Pick
size.

One of the most important concepts of the program is the ability
to test each method for any "previous draw".
The Hits are always highlighted.

If I have missed something please post your questions to the forum.

I hope that the software will be of some help.

I'll appreciate any new ideas/ revisions/ additions.

Good Luck!!!

Nick Koutras
 

thornc

Member
Great Nick, I'm downloading it right now...

I'll post my comments about it soon!

edit:
download finished, on the first run I got a compiler error for module hidden module mHelp.... and every button I press I get a similar error!

I'm using excell 2000 sp3 on XP!
 

charles2

Member
Beaker said:
what do you have that no one else does?? :confused: :dizzy:

i don't know:notme: , like i said office 2002 - sp2
low security on macros
win xp pro up to date updates

i'm using the ontario 649 database supplied by nick on his web page. try downloading it and trying with that and see if it works. Don;t update the draws just use it to check 1st.

exactly what errors do you get? on all the buttons? even random? even on all default values?

i'm sure nick will sort it out soon enough

it's a slick excel program though, your gunna like it when you get it working u lotto junkies like me :lol:
 

Brad

Member
I have a solution ...

Let's rub out Charlie for being a smart ass and thumbing his nose at us :mad: .... :lol:
 

charles2

Member
Re: I have a solution ...

Brad said:
Let's rub out Charlie for being a smart ass and thumbing his nose at us :mad: .... :lol:

ya i'm enjoying this too much :lol:

seriously though, i'm sure it's something real simple.

download nicks ontario 649 file and use it exactly as is and then explain exactly what you do to get the error.
 

Beaker

Member
charles2 said:
<snip>
i'm using the ontario 649 database supplied by nick on his web page. try downloading it and trying with that and see if it works. Don;t update the draws just use it to check 1st.

exactly what errors do you get? on all the buttons? even random? even on all default values?

i'm sure nick will sort it out soon enough

it's a slick excel program though, your gunna like it when you get it working u lotto junkies like me :lol:
I'd like too get that db but nothing works

compile error: mHelp on opening

Goto Menu - OK

Press CriticalBinomial -> compile error: mCriticalBinomial

Goto Database - OK

Press LoadDatabase -> compile error: mDatabase

Every button gets the associated compile error.
Something is missing :dizzy:

It looks interesting though - can hardly wait to exercise it.
;)
 
It seems that the errors are because
of the References.

I'll clean the project and I'll post again.

I have to mention that I also use

XL2002 on XP pro.
 

charles2

Member
oh so Beaker you can't even load the database???

now that's strange, i'd say you got a corrupt lottoselector copy, but why i didn't i don't know cause i got it from nicks page to.

try deleting it and redownloading the program again

oh so nick i use the exact same win xp pro & excell 2002, mabye thats why it works for us?????
 

Beaker

Member
Nick Koutras said:
It seems that the errors are because
of the References.

I'll clean the project and I'll post again.

I have to mention that I also use

XL2002 on XP pro.
OK Nick - let us know.

At least we have a good selection of OS and XL SW to test :agree2:
 

Beaker

Member
Brad said:
no worries Brad - Nick is on it - our time will come :agree2:
Method 4: Announcers as Neural Net
This method is a modified method of the Announcers that
is discussed in the forum but instead of only the last
draw is using the last n draws that do cover the half
of the numbers of your game.
For example on a 49/6 game uses as many last draws
that will include 24+ numbers. Usually 4-5 last draws.
After that it works as standard announcers.
More answers will be posted upon some discussion on the
forum.
The slider provided is used to indicate the % of draws
to be used to teach the NeuralNet
This is the one I'm curious about :agree: I look at this also.
 

Sidebar

Top