Constant Cells

Published:

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.

Entry #20

Comments

Avatar phileight -
#1
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?
Avatar GASMETERGUY -
#2
Not quite.
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, one of the drawn numbers could be found in one of the Constant Cells.
Avatar CARBOB -
#3
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?

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register