Macro to separate the digits = 0,1,2,3 .other associations of digitios ID TD, DOD.... etc

[jorel]

Macro to separate the digits =0, 1,2,3 in each draw of the pick5
*And also on a topic other associations of digitios ID TD, DOD. ETC below

The Digit System
Some Definitions first
ID = Independent digits. Digits 0-9 counted only once regardless of
times within a set.
TD = Total digits. Number of all digits within a set but does not
include leading zero's
DOD = Double odd digits. Numbers made from two odd digits
DEV = Double even digit. Numbers made from two even digits
MDN = Mixed digit numbers. Numbers made from 1-odd and 1-even digit
Below are the last 3 draws for MO. show me cash-5
FRI 05/28/10 04 16 23 24 39
THU 05/27/10 03 08 21 24 28
WED 05/26/10 14 18 20 27 33
I would like you to look at the last 3 draws of show me cash.
These draws are typical and at first glance nothing special. look again
draw # 1, is made up of the digits "1-2-3-4-6-9"
draw # 2, is made up of the digits "1-2-3-4-8"
draw # 3, is made up of the digits "0-1-2-3-4-7-8"
notice all the draws have digits "1-2-3-4" and two of the draws have the
digit "8" in common.
You might think this is a fluke, Check the drawings below
MO. lotto
05/26/10, "10 12 16 32 33 44" "0,1,2,3,4,6"
Fl. fantasy 5 05/27/10, "14 23 27 29 32" "1-2-3-4-7-9"
IL. little lotto 05/28/10, "18-26-32-33-39" "1-2-3-6-8-9"
TN. Pick 5 05/28/10, "08-12-15-18-34" "1-2-3-4-5-8"

"1-2-3" in a large percentage of draws with many of those having more then
one of at least 2 of the "1-2-3" base digits within it.
Next consider that the largest percent of draws contain at least one
number that consist of only one digit, "number below 10" and many
sets contain two single digit numbers. In a 5 number draw the maximum
TD possible is ten
Step #1
compile a list of at least 30 drawings. They can be a random sample.
A current day to day drawing list is no better then a random sample
I for years believed that the patterns I found would repeat until I
discovered that the patterns were also random. All roads will
intersect with another if they run far enough. That being said,
go through each drawing on your list and mark how many TD, ID, DOD,
DEV, MDN digits are in each draw, When writing down the sets, arrange
them in 10 columns, the numbers 12 18 22 35 39 would look like this
include leading zero's in this list
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | TD | ID | DOD | DEV | MDN
|___|___|___|___|___|___|___|___|___|____|____|___ _|_____|_____|____
| | | | | | | | | | | | | | |
| 1 | 2 | 1 | 8 | 2 | 2 | 3 | 5 | 3 | 9 | 10 | 6 | 2 | 1 | 2
|___|___|___|___|___|___|___|___|___|____|____|___ _|_____|_____|____
| | | | | | | | | | | | | | |
place them down the page so they can be easy to read from top to bottom.
feel free to copy and paste this to use as a template you can print.
Step #2
On another sheet of paper add the number of digits in each of
the 10 columns of digits, count the padded "0" digits in this step.
Dig | 0's | 1's | 2's | 3's | 4's | 5's | 6's | 7's | 8's | 9's
_________|_____|_____|_____|_____|_____|_____|____ _|_____|_____|____
col [#1] | | | | | | | | | |
_________|_____|_____|_____|_____|_____|_____|____ _|_____|_____|____
col [#2] | | | | | | | | | |
_________|_____|_____|_____|_____|_____|_____|____ _|_____|_____|____
col [#3] | | | | | | | | | |
_________|_____|_____|_____|_____|_____|_____|____ _|_____|_____|____
continue to col [10]
Step #3
On another sheet of paper convert the number sets to digits, do not
include the padded "0" in this list. "08-12-15-18-34" to "1-2-3-4-5-8"
each digit is counted only once and then to the right of this place the
digits that were not in the draw
Draw set Digits hit Digits out
08-12-15-18-34 1-2-3-4-5-8 6-7-9-0
Step #4
Study the list you have made and trends will begin to appear. I say trends
not patterns. A trend is like a pattern but it is not a pattern. All lotteries
most often for that column and write them down. On a new sheet of paper draw
10 lines, one for each digit. ___ ___ ___ ___ ___ ___ ___ ___ ___ ___
make a list of the best ID, TD, DOD, DEV, MDN, values that hit most often.
now using the information gleamed from the data sheets fill in the best digit
for each place on the line. Next look at the digits and see if all the data
from ID,TD,DOD,DEV,MDN fits your selection. if not then repeat the process.
do not be concerned with how your numbers appear on the lines as they may not
be in any order. Keep your data sheets for reuse or make several different
ones and play a set or two from each.

allows a range of settings for each value + wildcards then generates all
possible combo's then filters them and then finally wheels them down to 10

[jorel]

This is where digit selection comes in. You now need to select 6 of the 10
digits to build your number sets. For this example I will select digits 1-2-5-7-8-0.
PB-5/59
ID=6 using Digits 1-2-5-7-8-0 = 4111 unfiltered sets
4111 / 5,006,386 = .00082 in ony 2 steps.
Next lets say that the number set 12-25-28-50-57 is drawn, of the 4111 sets
344 sets have 3 matching numbers
34 sets have 4 matching numbers
1 set has 5 matching numbers
Of the 4111 sets 379 have 3 or more matching numbers. 4111 / 379 = 10.8
This means that on average 1 out of every 10.8 sets has at least 3 of the winning numbers.
For PB the odds of a 3 of 5 hit are 1 in 291.
Selecting The digits.
Here is a method that I use that allows me to correctly select the digits on a regular basic.
First using the last 30 or more draws, make a list for the 10 digits like the one below. I
always add the current draw to the top of my database but this can be reversed.
The set 12-25-28-50-57 = digits 1-2-5-7-8-0, remember that the digit "0" is not counted when
it is to the left of a digit, ie. numbers less than 10
1 2 5 7 8 0
=1 1 0 0 1 0 1 1 0 1
You don't have to use 1's or 0's, use whatever looks good to you.
another examle
1 2 5 7 8 0
=h h - - h - h h - h
DG1-2-3-4-5-6-7-8-9-0
## A B C D E F G H I J
01 1 0 0 1 1 1 0 1 0 1
02 1 1 1 1 1 0 0 0 0 1
03 0 0 1 1 0 1 1 1 0 0
04 1 1 1 0 1 0 1 1 0 1
05 1 0 1 1 1 0 1 1 0 1
06 1 0 1 1 1 0 0 0 1 1
07 1 1 1 0 0 1 0 1 1 0
08 1 1 1 0 1 0 0 1 1 0
09 1 1 1 1 0 0 1 0 1 0
10 1 0 1 1 1 0 0 1 1 1
11 1 0 1 1 0 0 0 0 1 0
12 1 1 1 1 0 0 0 1 0 0
13 1 1 1 0 0 1 0 0 0 1
14 1 1 0 1 1 0 1 0 1 1
15 0 1 0 0 1 0 1 1 1 0
16 1 1 1 0 1 1 0 1 0 0
17 1 1 1 0 1 0 1 1 0 0
18 1 1 1 1 1 0 1 0 0 0
19 1 0 1 1 1 0 1 0 0 1

[jorel]

second digits
1-7-2-3-4 OOEOE LHLLL
3-1-4-8-2 OOEEE LLLHL
5-6-2-4-9 OEEEO HHLLH
7-2-3-4-2 OEOEE HLLLL
O = odd "1-3-5-7-9"
E = even "0-2-4-6-8"
L = low "0-1-2-3-4"
H = hi "5-6-7-8-9"
The first information encoded is odd - even digits and the second is hi - low digits
You may be thinking how can this help. Simple, let's say you are looking for a digit to
use as the first number's second digit. you have a 0 to 9 choice or a odd - even choice.
A 50/50 or a 1 in 10. Lets say you choose odd and low based on data gleamed from your
list as the best choice for this digit. You now have digits "0-2-4" to select from.
repeat this for all five second digits keeping a TD and ID count. Don't be tempted to
stretch the selections above the 5 or 6 ID's. Stay on track play smart, play fewe

[jorel]

https://www.excelforum.com/attachmen...1&d=1511088017

[jorel]

hello please!!