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:
268,284,300,316,332,348,364,380,396,412,428,444,460,476,492,508
"Optional Filtering"
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.
0=0, 1=1, 2=2, 3=3, 4=4, 5=5, 6=6, 7=7, 8=8, 9=9, 10=0, 11=1, 12=2, 13=3, 14=4, 15=5, 16=6, 17=7, 18=8, 19=9, 20=0, 21=1, 22=2, 23=3, 24=4, 25=5, 26=6, 27=7
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!!