Hello World!
I would like to have a program of sorts, that would analyse rows of numbers for me bringing out the top patterns.
As you might understand it is for lottery, yaay :D but it is a local lottery that is not world-wide format.
Let me explain what it is and what I need, maybe my needs are very simple and one can guide me to get the results needed.
Lottery itself consists of balls from 1-75.
The ticket you can create yourself, ie. pick numbers.
Conditions are:
Ticket field 5x5 = total 25 numbers
Colums and numbers -> 1st = 1-15 ; 2nd = 16-30 ; 3rd = 31-45 ; 4th = 46-60 ; 5th = 61-75
First 33 numbers will be drawn. After that 5 numbers and lastly as much numbers as needed for atleast one person to have filled all 25 fields on ticket. (on average it is about 13-15 numbers)
What I have is list of all the draws (currently 1300+ ). I have the numbers as full increasing lists and have them also separately to the 3 drawing sections (as in 3 rows left to right, 1 empty row, again 3 rows left to right, etc.)
What I need to have analysis on is:
- what numbers come together most often during the first 33 balls, condition is that only 2 numbers from each column are chosen. For example how many times together has been 1-2-16-17-31-32-46-47-61-62. I need like top 5 to top 10 to be listed for me with the occurence count.
- what numbers come together most often during the total balls drawn. This time condition is that 5 numbers from each column are chosen. For example how many times together has been 1-2-3-4-5+16-17-18-19-20+31-32-33-34-35+46-47-48-49-50+61-62-63-64-65. I need like top 5 to top 10 to be listed for me with the occurence count.
These would be the most needed factors to analyse.
Now what would I need to achieve it? What is the easiest programming language to use?
I think in excel these calculations would hang the MSExcel program.
Would somebody have enough time and knowledge to guide me through in creating a program for such calculations, in future I would like to add some different analysis.
I am quite far from programming, but I consider myself a quick learner and I want to learn to create.
If I finish this and the analysis program turns out helpful, I will post more about the lottery and how the program helped. :)
As for now, hopefully there is somebody willing to guide me through this :)