Hello to everyone this lovely Thursday night. I've been utilizing Lottostatistics.xls by Nick Koutras for the last number of years and my question concerns the Error 6(overflow) in procedure Do-Hit-Frequency of module 6 when I run the Hit/Skip function. It works fine when I analyze the can649 database but is very hit and miss when I analyze data bases derived from my own grouping strategies. And if it does work with out error I generally have to narrow the draw range to such an extent that the endeavor is useless at providing any useful information. I'm just curious if others ran into a similar issue utilizing this software and if they found a fix for it? Thank you for your time.
Error 6(overflow) explanation needed
- Thread starter cdrake
- Start date
Hi cdrake,
It sounds like the error only occurs when you try and import your own data.
Basically, an overflow error results when you try to make an assignment that exceeds the limitations of the target of the assignment.
One reason could be that the variable it is using is of an Integer type, and that particular variable only caters for a maximum value of 32,767. If you can get into the code try and track down where the Dim statement is and change that variable to Long.
Basically, the data type conversion is too large to be represented within the range of values allowed for that type of variable, so assign the value to a variable of a type that can hold a larger range of values i.e. Long.
Another reason could be that it is trying to divide by ZERO, which doesn't sound like that is the issue in this particular case.
You could go to debugging mode and run through the code to find where the error occurs.
I hope this helps or at least gives you an insight on where to start to correct it.
You could also of course email or get hold of Nick!
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.
I don't actually use it myself but from reading your post I thought I might be able to give you a couple of ideas on how to track down the error and resolve it, I hope you don't mind?cdrake said:
It sounds like the error only occurs when you try and import your own data.
Basically, an overflow error results when you try to make an assignment that exceeds the limitations of the target of the assignment.
One reason could be that the variable it is using is of an Integer type, and that particular variable only caters for a maximum value of 32,767. If you can get into the code try and track down where the Dim statement is and change that variable to Long.
Basically, the data type conversion is too large to be represented within the range of values allowed for that type of variable, so assign the value to a variable of a type that can hold a larger range of values i.e. Long.
Another reason could be that it is trying to divide by ZERO, which doesn't sound like that is the issue in this particular case.
You could go to debugging mode and run through the code to find where the error occurs.
I hope this helps or at least gives you an insight on where to start to correct it.
You could also of course email or get hold of Nick!
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.
Thanks PAB for your quick reply. I tried what you suggested and I got the error "Project is unviewable." I came to the conclusion that since I'm still using excel 97 that the original program was probably developed in something more recent and locked. So I don't believe I'll be able to access the code. I'll try sending Nick an email to see how I might remedy this and if that doesn't work then I'll have to look at some other software that will allow me to track the skips of my particular databases. Thanks for your help.
No problems cdrake,
Have you not thought about using Excel to track the skips of your particular databases?
There are numerous posts on this forum about tracking skips.
If that doesn't help then I am sure we can come up with something for you.
Out of interest, what Lotto are you tracking?
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.
Have you not thought about using Excel to track the skips of your particular databases?
There are numerous posts on this forum about tracking skips.
If that doesn't help then I am sure we can come up with something for you.
Out of interest, what Lotto are you tracking?
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.
Hi BlouBul,
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.
This makes total sense and substantiates what I said in my initial reply to cdrake.bloubul said:
Regards,
PAB
-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.
Thank you bloubul for your reply. Like I told PAB I can do the skips on the CAN649/LOTTOMAX databases fine. The problem arises when I look at the databases which were obtained from my grouping strategies. Most of my grouping strategies involve breaking down the data into 10 groups and then sub groups. When I log the numbers I always insure that I use single digit or two digit numbers only as Lottostatistics doesn't handle three digit numbers. I can generate a skip chart on these groupings in Lottostatsistics but I have keep the range of draws used to 15 or less or I'll encounter the overflow error. This few number of draws just doesn't reveal a lot of useful information. I think if I could access the code, like PAB suggested, then the problem could be rectified. I know there are other ways of obtaining the skips but its so handy just to do it with Lottostatistics as it is primarily the only program I'm utilizing right now. Once again I'd like to thank you all for your quick replies.
No I haven't yet bloubul. I've been very busy at work and all I've been able to do lately is just to keep collecting data and updating my files without doing really any analysis. I've got some holidays coming up at the end of June and I hope that I can spend some time on this issue. Worst case scenario, is that, I utilize another utility to generate the skips that I'm after and just work between the two programs...tedious.