Pick 4 Skips Calculation Using VBA

[Winalot2007]

To all Excel experts here:

I created a Pick 3 draw history for every Pick 4 game.

Draw history consists o 50,000 + drawings.

Download link to the text file below:

https://app.box.com/s/yi333l0joba8wqe24e95

The current calculation using Excel for 50,000 plus draws calculating the current "skip" for each set 0000 through 9999 is painfully slow unless you have a super fast computer.

My question is this:

Any way to make the calculation process faster using VBA?

Thanks

 

[Icewynd]

Sorry I can't help with the VBA, Winalot. I have no expertise whatever there.

Why are you calculating the skips? Generally, I would imagine that they are rather long, given 10,000 numbers. Are you looking for a pattern where a recently hit number will pop up again in a short while?

Good luck!

 

[Winalot2007]

Thanks.
I figured it out.