Tn United States Member #54963 September 4, 2007 1150 Posts Offline

Posted: January 8, 2013, 6:11 am - IP Logged

Quote: Originally posted by winsumloosesum on January 7, 2013

I changed the program from a "Boxed" system to a "Straight" system.

I'll try to explain as much as possible on how to use it.

1. The 1st Tab labeled "DM2" Draw Manager. This is where you enter new drawings for each day using the Toolbar "Add New Draw". You can also delete the most current drawing also but clicking the "Delete Last Draw" Toolbar.

Column H has the 10 digit Binary for each Pick 3 draw.

Columns I through S is the breakdown of the Binary from column H into 10 individual rows.

The values are either a 1 or 0. 1 = Hit, 0 = Miss

Over to cell columns AG through AQ. Notice the "B"'s and "x"'s. The "B"'s represent a BLOCK and the "x"'s represent "HITS"

The "B"'s and "x"'s are using the columns I through S. So a "0" = "B" Block and a "1" = "x"

For example,

The Monday NJ Midday drawing was 200.

The Binary was 0-0-1-1-0-0-1-0-0-0

The "B" / "x" = B-B-x-x-B-B-x-B-B-B

Next, click the Tab labeled "Stakes Workout Straights"

Cell column A is the list of all 1000 Pick 3 combinations

Cell columns E through O contain the "B"'s and "x"'s

Cell column P is the concated set for each Pick 3

I split the 1000 Pick 3 numbers into 63 matrices. There are 62 matrices with 16 total numbers and the last matrix #63 only has 8 numbers

Notice in cell columns E through J, Matrix #1 has the same "B"'s and "x"s, Marix #2 has the same "B"'s and "x"'s, etc., etc, all the way down to Matrix 63.

Here is the thing, we need to ask questions on what Matrix Set to Play. Look at column U. There is the listing with 4 Sets A, B, C, and D.

The 1st question we need to ask is this, should we use Sets "A" and "B" or use Sets "C" and "D"?

For example, suppose we decide to use Sets "A", and "B". What we are saying is that the binary position 1 will not hit. Notice all the "B"'s = Block in cell colum V6 through V38. Of course making this decision should be based on our analysis of past drawings. If you go back and click the tab labeled "DM2" and look at cell column AG20 through AG29. There are 8 "B"''s and only 2 "x"s'. So you can see that the "B" have a pretty good run going on right now. In addition you can see that the "B"'s and "x"'s normaly will repeat.

Click the Tab again labeled "StakesWorkoutStraight". So we decided to use the "B" for Position 1. So for now we have Matrix Set A and Matrix Set "B"

2nd question we need to ask is this, will Position 2 be a "B" or an "x". To make that decision we need to click the DM2 Tab again. Look at cell range AH20 through AH29. You can see that a "B" just hit the Midday drawing but before that there was a run of "x"'s. So if we keep to our thinking of repeating "B"'s and "x"'s, suppose we go with the "B" (Block) to hit next drawing.

So let's recap.

Position 1 we will be using a "B" = Block

Position 2 we will be using a "B" = Block

Click the Tab again labeled "StakesWorkoutStraight". The only set that has a "B" in Position 1 and a "B" in Position 2 is Set "A".

So Set "A" is in play. Set "A" contains the Matrices 1 through 16.

Questions 3 through 6 are what will be the "B" / "x" selections for Positions 7 through 10.

We just need to select either a "A" or "x" for these 4 postions.

We would enter our "B"'s and "x"'s in cell range AC2, AD2, AE2, AF2

Once we finish entering our selections in cell range AC2 through AF2 we can see the Straight Pick 3 selections in cell range AN6 through AN21.

We can play all 36 numbers straight or continue to filter using Sums, Root Sums (aka Left Digit Sums), or we can High/Low and Odd/Even LDR Sums.

So all in all there are 6 questions to answer correctly to pick the Straight Pick 3. There 3 additional optional questions using Sums and LDR Sums.

The Sums filtering can be used if you enter a range of Sums in cell AU1 and AU2. AU1 is the starting or lower range Sum and AU2 is the higher range Sum. Notice I have the Sum range 11 as the Low Range and 17 as the High Range. Notice there are only 5 Sums highlighted in Blue that meet the 11 through 17 range. So we can play the 5 Pick 3 numbers 048,080,160,176,240

There additional HitSkip tabs for Positions, Pairs, Trips, and Quads. If you click cell F2 you will see a drop-down arrow. You can select one of the values.

For example, click the Tab labeled "SkipHitChartBinaryPairs.

Click cell F2. You have 3 choices. G & H, H & I, and I & J. Select G & H. The Skip/Hit information below is for Position 7 & 8 of the Binary.

I think most of the decisions for selecting the "B"'s and "x"'s can be accomplished by looking at the Tab lableled DM2.

Let me know if there are any questions or additional ideas that you might come up with!!

Good Luck.

If anyone would like an Excel file for their state let me know.

I would like to thank JimJ. JimJ was responsible for coming up with this idea at the Lottoguys forum so I applied JimJ's idea to the Pick 3.

The other person is RL for creating the Pick 3 and Pick 4 programs with the binary calculations.

Hey winsum glad youve got new stuff!! Could I please get a file for the Tn pick3 it would be great to fool with Thanks in advance!! The Boot......

Pennsylvania United States Member #2218 September 1, 2003 5309 Posts Offline

Posted: January 8, 2013, 8:53 am - IP Logged

Quote: Originally posted by CarliG on January 8, 2013

okay, I decided on set "B"

but where am I entering the "We just need to select either a "A" or "x" for these 4 postions."

Isnt it supposed to be "B" or " X" ?

CG

Carlig,

Your correct it is either a "B" or "x"

Click the worksheet labeled "StakesWorkoutStarights"

Go to the cell range AC2 through AF2. This is where you enter the "B"'s and "x"'s

Sorry for the error.

So here is the system in a nutshell.

1. Go to the Tab labeled DM2. Go to cell range AG20 through AG29 (Position 1). Most current draw is a AG20. Decide if the next draw will be a "B" or "x". If you choose "B", the Pick 3 number will fall between 000 and 511. If you select "x", the Pick 3 number will fall between 512 and 999.

Write down your selection "B" or "x". No need to enter it anywhere

2. Go to the Tab labeled DM2 again. Go to cell range AH20 through AH29 (Position 2). Most current draw is a AH20. Decide if the next draw will be a "B" or "x".

Set A) If you choose "B" Pick 3 from step 1 and "B" from this Step 2 the numbers will be between 000 and 255

or

Set B) If you choose "B" Pick 3 from step 1 and "x" from this Step 2 the numbers will be between 256 and 511

or

Set C) If you choose "x" Pick 3 from step 1 and "B" from this Step 2 the numbers will be between 512 and 767

or

Set D) If you choose "x" Pick 3 from step 1 and "x" from this Step 2 the numbers will be between 768 and 999

Now write down the Set you selected (Set A, Set B, Set C, or Set D)

3. Click the Tab labeled "StakesWorkoutStraights". In cell column U you should see the 4 possible Sets A, B, C, D

4. Now this will be the hardest part. Selecting the "B"'s and "x"'s for Positions 7, 8, 9, 10

Click the tab labeled DM2 and scroll over to cell range columns AN20 through AQ20. Look at the last 10 draws or more and make your selections:

Position 7: Select B or x

Position 8: Select B or x

Position 9: Select B or x

Position 10: Select B or x

Write down your choices on a piece of paper.

For example, looking at the Florida Pick 3 game I would select the following:

Position 7: x

Position 8: x

Position 9: B

Position 10: B

Now my selections for Position 1 and Position 2 are:

Position 1: B

Position 2: x

So based on my analysis this would be Set B. Pick 3 numbers 256 through 511

Next, I would enter Position 7 through 10 selections by going to the tab labeled "StakesWorkoutStraights"

In cell range AC2, AD2, AE2, and AF2 I would enter the following based on my analysis:

AC2 = x

AD2 = x

AE2 = B

AF2 = B

5. Next, we are still in the "StakesWorkoutStraights" tab. Go to cell range AN23 through AN38. The following 16 Pick 3 "Straight" sets will be our numbers to play for Midday today:

6. Now these are optional steps if you don't want to play all 16 sets for Midday today.

In cell range AO23 through AO38 you can eliminate any Doubles or Triples. Such as 300, 332, and 444

or

Suppose you want to play only Pick 3 numbers within a certain Sum range. For example, Sums 11 through 17. In cell AU1 and AU2 notice I have entered AU1 = 11 and AU2 = 17. So I want to highlight any Pick 3 numbers that fall within this Sum range. You can change these values to anything you want between 0 and 27. So minimum Sum value for AU1 = 0, maximum Sum value for AU2 = 27. In cell range AU23 through AU 38 you can see the Sums highlighted in blue that qualify for the 11 through 17 Sum range which are 268,284,347,364,380,428,444,476,492,508

or

Supose you want to filter using the Left Digit Sums. See cell range AV23 through AV38.

You can go to cell range AW23 through AW38 and select any Left Digit Sums that are Low (0,1,2,3,4) or select any Left Digit Sums that are High (5,6,7,8,9) High = Red, Low = Blue

If we selected the "Low" (Blue) Left Digit Sums our Pick 3 numbers would be: 284,300,316,364,380,428,444,460,505

If we selected the "High" (Red) Left Digit Sums our Pick 3 numbers would be: 268,332,348,396,412,476,492

or

Suppose we like using the Even / Odd for the Left Digit Sums. Then we would look at cell range AX23 through AX38 for any Left Digit Sums that are Even or Odd. Even = Blue, Odd = Red

The last cell range to look at is cell range AZ23 through AZ38. Notice in cell AZ38 there is "NP" or No Play for Pick 3 number 508. The reason it is a no play is that the 5,0,8 have not hit in the last 3 draws in either Position 1, Position 2, or Position 3. The remaining Pick 3 numbers have a "P" for Play which means that at least 1 number from the last 3 draws are included in the Pick 3 sets to play.

You can see the last 3 draws in cell range AZ2 through BB4.

Remember I'm using the Florida Pick 3 game as the example here above.

If you have any additional comments or suggestions let me know.

Florida United States Member #66575 October 30, 2008 3549 Posts Offline

Posted: January 8, 2013, 11:49 am - IP Logged

Quote: Originally posted by winsumloosesum on January 8, 2013

Carlig,

Your correct it is either a "B" or "x"

Click the worksheet labeled "StakesWorkoutStarights"

Go to the cell range AC2 through AF2. This is where you enter the "B"'s and "x"'s

Sorry for the error.

So here is the system in a nutshell.

1. Go to the Tab labeled DM2. Go to cell range AG20 through AG29 (Position 1). Most current draw is a AG20. Decide if the next draw will be a "B" or "x". If you choose "B", the Pick 3 number will fall between 000 and 511. If you select "x", the Pick 3 number will fall between 512 and 999.

Write down your selection "B" or "x". No need to enter it anywhere

2. Go to the Tab labeled DM2 again. Go to cell range AH20 through AH29 (Position 2). Most current draw is a AH20. Decide if the next draw will be a "B" or "x".

Set A) If you choose "B" Pick 3 from step 1 and "B" from this Step 2 the numbers will be between 000 and 255

or

Set B) If you choose "B" Pick 3 from step 1 and "x" from this Step 2 the numbers will be between 256 and 511

or

Set C) If you choose "x" Pick 3 from step 1 and "B" from this Step 2 the numbers will be between 512 and 767

or

Set D) If you choose "x" Pick 3 from step 1 and "x" from this Step 2 the numbers will be between 768 and 999

Now write down the Set you selected (Set A, Set B, Set C, or Set D)

3. Click the Tab labeled "StakesWorkoutStraights". In cell column U you should see the 4 possible Sets A, B, C, D

4. Now this will be the hardest part. Selecting the "B"'s and "x"'s for Positions 7, 8, 9, 10

Click the tab labeled DM2 and scroll over to cell range columns AN20 through AQ20. Look at the last 10 draws or more and make your selections:

Position 7: Select B or x

Position 8: Select B or x

Position 9: Select B or x

Position 10: Select B or x

Write down your choices on a piece of paper.

For example, looking at the Florida Pick 3 game I would select the following:

Position 7: x

Position 8: x

Position 9: B

Position 10: B

Now my selections for Position 1 and Position 2 are:

Position 1: B

Position 2: x

So based on my analysis this would be Set B. Pick 3 numbers 256 through 511

Next, I would enter Position 7 through 10 selections by going to the tab labeled "StakesWorkoutStraights"

In cell range AC2, AD2, AE2, and AF2 I would enter the following based on my analysis:

AC2 = x

AD2 = x

AE2 = B

AF2 = B

5. Next, we are still in the "StakesWorkoutStraights" tab. Go to cell range AN23 through AN38. The following 16 Pick 3 "Straight" sets will be our numbers to play for Midday today:

6. Now these are optional steps if you don't want to play all 16 sets for Midday today.

In cell range AO23 through AO38 you can eliminate any Doubles or Triples. Such as 300, 332, and 444

or

Suppose you want to play only Pick 3 numbers within a certain Sum range. For example, Sums 11 through 17. In cell AU1 and AU2 notice I have entered AU1 = 11 and AU2 = 17. So I want to highlight any Pick 3 numbers that fall within this Sum range. You can change these values to anything you want between 0 and 27. So minimum Sum value for AU1 = 0, maximum Sum value for AU2 = 27. In cell range AU23 through AU 38 you can see the Sums highlighted in blue that qualify for the 11 through 17 Sum range which are 268,284,347,364,380,428,444,476,492,508

or

Supose you want to filter using the Left Digit Sums. See cell range AV23 through AV38.

You can go to cell range AW23 through AW38 and select any Left Digit Sums that are Low (0,1,2,3,4) or select any Left Digit Sums that are High (5,6,7,8,9) High = Red, Low = Blue

If we selected the "Low" (Blue) Left Digit Sums our Pick 3 numbers would be: 284,300,316,364,380,428,444,460,505

If we selected the "High" (Red) Left Digit Sums our Pick 3 numbers would be: 268,332,348,396,412,476,492

or

Suppose we like using the Even / Odd for the Left Digit Sums. Then we would look at cell range AX23 through AX38 for any Left Digit Sums that are Even or Odd. Even = Blue, Odd = Red

The last cell range to look at is cell range AZ23 through AZ38. Notice in cell AZ38 there is "NP" or No Play for Pick 3 number 508. The reason it is a no play is that the 5,0,8 have not hit in the last 3 draws in either Position 1, Position 2, or Position 3. The remaining Pick 3 numbers have a "P" for Play which means that at least 1 number from the last 3 draws are included in the Pick 3 sets to play.

You can see the last 3 draws in cell range AZ2 through BB4.

Remember I'm using the Florida Pick 3 game as the example here above.

If you have any additional comments or suggestions let me know.

Good Luck!!

Thanks Steve,

Thanks for the further explanation

Gonna be out most of the day, so will take a look tonight

Park City, UT United States Member #69864 January 18, 2009 991 Posts Offline

Posted: January 8, 2013, 7:34 pm - IP Logged

So if I understand correctly your first choice is basically making a decision on whether position 1 is either 0-5 or 5-9. Your second choice further refines position 1 to either 0-2, 2-5, 5-7, or 7-9.

The aspect that I don't necessarily like about the series of numbers is that they are +16 apart so inadvertently you are tying your 3rd digit to being either odd or even through your decision process. Thats just the nature of the beast of trying to map a base 2 system of 1024 numbers to a base 10 system of 1000 numbers.