Constant Cells

Comment #3

CARBOB — Tue, 06 Sep 2011 10:17:30 GMT

Are you willing to share the VB code? If not, will you post an image of the ws. Are the random cells on different rows of the 50 draws?

Comment #2

GASMETERGUY — Sat, 18 Jun 2011 23:51:40 GMT

I keep a running track of every draw in the Georgia P5 game. What I did was go back to the last fifty draws and, starting at that point and not going below that point, selected randomly seven cells. Each cell contains only one of the drawn numbers. I then programmed Excel to compare the drawn numbers with the numbers in the Constant Cells. What I wanted to know was how many times were one of the drawn numbers found in one of the Constant Cells. The answer turned out to be 63% of the time, o... [ More ]

Comment #1

phileight — Sat, 18 Jun 2011 22:22:34 GMT

Interesting. I can't follow what you are doing. How do you define a constant cell? did you select 7 of the possible 35 # and check how many games 1 or more showed up?

Original Blog Entry: Constant Cells

GASMETERGUY — Sat, 18 Jun 2011 17:44:17 GMT

For those of you who like tracking patterns (as I like to do), here is one that rather gave me a surprise.

This would apply whether you play a P3, P4, or P5 game. Of course you should use Excel or some similiar spreadsheet and be able to program VBA. Life would be so much easier.

Somewhere within your history of past draws, select a number of cells at random. I play the P5 game exclusively so I selected seven (7) cells. The one criteria I insisted upon was that the seven cells had to be at least fifty draws back. Then I set about writing code to determine how often a drawn number appears within one of the Constant Cells.

I fully expected this pattern to result positive in about 10% of the cases. Much to my surprise the answer was closer to 63%.

I rearranged my Constant Cells several times over the last few days expecting to find one set that would result in a 10% positive hit. That was not to be. No matter where I put these seven cells, the answer I always achieved was 63% give or take a point or two.

... [ More ]