Excel & Macros

Excel Users Share Their Formulas and Macros for Lotto Analysis.
J
generate 60 formations, but filtered from a minimum of zero and a maximum of 2 numbers from each of the trios in the list
Replies
11
Views
2K
jack
J
J
separate from each sweepstakes line only triples with six distinct digits
Replies
5
Views
1K
jack
J
J
separate the initial digits 0,1,2, and see the amount that was drawn in each formation
Replies
6
Views
1K
jack
J
J
generate all formations of each of the 64 pick3 patterns
Replies
2
Views
1K
jack
J
J
separate the last digit and classify the 6 patterns and add the amount
Replies
2
Views
1K
jack
J
J
statistical background To figure out how the next number is structured into high/low and even/odd, first of all you need to realize that most of the t
Replies
1
Views
1K
jack
J
J
spreadsheet to automatically update draws of the 6 lotteries.
Replies
3
Views
1K
jack
J
R
Formula to count draws ago a pair of numbers were drawn together
Replies
5
Views
2K
roberto
R
J
create a generator for three digits from 0 to 9 (pick3), but linked to the previous pick3 draw.
Replies
3
Views
1K
jack
J
bloubul
Missing Numbers
Replies
6
Views
2K
bloubul
bloubul
J
detect at each position if the digit is small, large or medium.
Replies
0
Views
968
jack
J
J
DETECT IN THE FOUR TYPES OF DOUBLES PRESENT IN PICK 3. SOMETIMES PICK3 HAS A DOUBLE, Occasionally TWO DOUBLES FROM THE LIST.
Replies
0
Views
1K
jack
J
J
detect the doubles of twins in pick 3 will be to place many draws
Replies
14
Views
2K
jack
J
J
detect delays and frequencies of the two sectors of the mini quadrants.
Replies
0
Views
908
jack
J
J
detect in each mini quadrant the corresponding color and letter.
Replies
12
Views
2K
jack
J
J
just thank frank!!!
Replies
1
Views
985
Frank
Frank
J
detect the three patterns at each pick3 position
Replies
0
Views
1K
jack
J
J
split into 3 pairs and then split the pairs of the column where you have these three pairs.
Replies
3
Views
1K
jack
J
J
convert pick3 to crescent , detect in each quadrant that it is a color.
Replies
8
Views
2K
jack
J
W
Excel Count Unique Digits from 2 Ranges
Replies
1
Views
1K
Frank
Frank
You must log in or register to post here.

Sidebar

Top