|Posted: November 13, 2006, 4:55 pm - IP Logged|
Such can be written, but, it is huge and combersome. The Skip tracking spreadsheet I use for the 3 Jackpot games I track is over 20 meg in size.
The problem isn't the tracking ability, it's the fact you have to establish an individual grid for each and every number times how many numbers actually exist. In a pick 5 with 39 numbers, that would be 39 grids that you would need to create to track with.
This then would allow you to determine what follows what. The coding itself is relatively simple. The size of the grid is what makes it difficult. But, I think there are software packages out there that will do just that for you. I remember one that I tried would let you see how frequent various groups of numbers repeated. Replicating it in Excel would be a huge undertaking.