Identifying 'string' and other repeating patterns on EXCEL - all lotteriesPrev Topic Next Topic

New Topic New Poll

JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 10:07 am

Everyone who considers past draws significant might already be doing this, so I won't go into the minute details unless there's interest.

I've found that spreading the matrix horizontally alongside each draw offers a wide range of options in filtering by results groupings by date than I've been able to get otherwise. Breaking out the individual numbers in a long history of draws might be done some easier way but the EXCEL countifs function is the only one I've found. It allows filtering all past draws by date and groupings of specific number-hit combinations.

If anyone isn't already doing this, wishes to know how to do it, or knows a better way of doing it this is an invitation for discussion and exchanging information and/or methods.
ameriken

Denver, Co
United States
Member #103,042
December 29, 2010
547 Posts
Offline

Mar 23, 2011, 12:00 pm

I'm completely in the dark about these string and repeating patterns, and would love to learn more if you are willing.
Kia69

Brooklyn, New York
United States
Member #106,167
February 13, 2011
103 Posts
Offline

Mar 23, 2011, 12:29 pm

I will like to learn too!

kia
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 12:33 pm

Quote: Originally posted by ameriken on Mar 23, 2011
I'm completely in the dark about these string and repeating patterns, and would love to learn more if you are willing.

Hi ameriken. Thanks for the interest and reply. The pick 5 thread:

The Pick 5 Jackpot Winning Thread--Get Your Numbers!!

https://www.lotterypost.com/thread/226337 explains a part of the concept more throughly than I could.

Lottolaughs has gone to a lot of trouble to create a series of repeating patterns or groupings he calls strings.

But my intention here isn't to intrude on what he has established and sustains through constant work.

I don't know what method he uses to identify and test the strings.

But the concept of strings might well spill over into other uses. It does for me.

I can provide a method of producing or identifying similar patterns using countifs function. There might be an easier way of doing it. I'm not a power user of EXCEL.
ameriken

Denver, Co
United States
Member #103,042
December 29, 2010
547 Posts
Offline

Mar 23, 2011, 12:40 pm

I am a completely oblivious non-user of excel and don't even know what the countifs function is, so I may not be a big help. However, I did stay at a Holiday Inn Express.

Seriously, I do have other lottery software that can do quite a bit as far as analyzing and filtering, so I may be able to reproduce whatever it is that excel is doing.

I've seen the other thread, and while I appreciate what Lottolaughs is doing with providing those strings, I tend to like learning and discovering on my own so I can eventually do my own predictions.

Can you explain your understanding of strings?
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 2:52 pm

Quote: Originally posted by ameriken on Mar 23, 2011
I am a completely oblivious non-user of excel and don't even know what the countifs function is, so I may not be a big help. However, I did stay at a Holiday Inn Express.

Seriously, I do have other lottery software that can do quite a bit as far as analyzing and filtering, so I may be able to reproduce whatever it is that excel is doing.

I've seen the other thread, and while I appreciate what Lottolaughs is doing with providing those strings, I tend to like learning and discovering on my own so I can eventually do my own predictions.

Can you explain your understanding of strings?

Ameriken: I'd be out of my depth immediately if I attempted to superimpose my own understanding of repeated patterns and the patterns behind them, or groupings and the patterns of groupings. As nearly as I can tell every attempt to beat the odds printed on the back of a betslip by using some type of system relies completely on past draw results. Every one of them. Every thread on this forum.

The countifs function I mentioned just allows a different way of examining past draws in a way the sequences, timings, groupings can be interpreted.

I'm not an expert on lottery systems. I'm not a successful predictor anyone would wish to emulate. I'm just another of the thousands of people here attempting to understand the numbers events reflected in lottery draws. I do it for different reasons than most of the posters here, but we're all doing the same thing and the main difference between me and others here is that I don't lose any money doing it.

Thanks for the reply.
CARBOB

COLUMBUS,GA.
United States
Member #4,924
June 3, 2004
6,719 Posts
Offline

Mar 23, 2011, 2:54 pm

Quote: Originally posted by JosephusMinimus on Mar 23, 2011
Ameriken: I'd be out of my depth immediately if I attempted to superimpose my own understanding of repeated patterns and the patterns behind them, or groupings and the patterns of groupings. As nearly as I can tell every attempt to beat the odds printed on the back of a betslip by using some type of system relies completely on past draw results. Every one of them. Every thread on this forum.

The countifs function I mentioned just allows a different way of examining past draws in a way the sequences, timings, groupings can be interpreted.

I'm not an expert on lottery systems. I'm not a successful predictor anyone would wish to emulate. I'm just another of the thousands of people here attempting to understand the numbers events reflected in lottery draws. I do it for different reasons than most of the posters here, but we're all doing the same thing and the main difference between me and others here is that I don't lose any money doing it.

Thanks for the reply.

I would like to see some of your countif formulas!!!!
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 3:55 pm

Quote: Originally posted by CARBOB on Mar 23, 2011
I would like to see some of your countif formulas!!!!

Carbob: I'll try to cut and paste this from text. I'm not sure of any other way to do it:

=COUNTIFS($C2:$E2,G$1)

The top is frozen with the date, draw and individual numbers from the matrix running across.

Source date 1 2 3 4 5 6 7 8 9 10

The draw history goes below and everything to the right uses the cut and pasted formula with the dollar signs depicting the positions of constant cells.

AZ p3 3/15/2010 6 2 5 0 1 0 0 1 1 0 0 0 0

Nothing much to it. If the matrix changes just carry the numbers on the frozen cells to the right and modify the formula. If you have the RAM you can even use it for Keno games.

Thanks for the reply.
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 6:15 pm

I should have mentioned in the first post that some combinations within each matrix are surprisingly rare. One advantage a person might find to using some method of examining them similar to this one helps identify those.
CARBOB

COLUMBUS,GA.
United States
Member #4,924
June 3, 2004
6,719 Posts
Offline

Mar 23, 2011, 6:34 pm

Quote: Originally posted by JosephusMinimus on Mar 23, 2011
Carbob: I'll try to cut and paste this from text. I'm not sure of any other way to do it:

=COUNTIFS($C2:$E2,G$1)

The top is frozen with the date, draw and individual numbers from the matrix running across.

Source date 1 2 3 4 5 6 7 8 9 10

The draw history goes below and everything to the right uses the cut and pasted formula with the dollar signs depicting the positions of constant cells.

AZ p3 3/15/2010 6 2 5 0 1 0 0 1 1 0 0 0 0

Nothing much to it. If the matrix changes just carry the numbers on the frozen cells to the right and modify the formula. If you have the RAM you can even use it for Keno games.

Thanks for the reply.

Thanks for responding.What does the values in red represent?

AZ p3 3/15/2010 6 2 5 0 1 0 0 1 1 0 0 0 0

The data below is for Fla Mid. A 6-digit string that stands at 121 draws, after todays draw.

1,2,4,7,8,9

DIGITS 0

HITS 72

MED 9

MAX 120

AVG 14.43

CUR.SKIP 120
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 7:05 pm

Quote: Originally posted by CARBOB on Mar 23, 2011
Thanks for responding.What does the values in red represent?

AZ p3 3/15/2010 6 2 5 0 1 0 0 1 1 0 0 0 0

The data below is for Fla Mid. A 6-digit string that stands at 121 draws, after todays draw.

1,2,4,7,8,9

DIGITS 0

HITS 72

MED 9

MAX 120

AVG 14.43

CUR.SKIP 120

That's the product of the countifs. Immediately above would be the matrix horizontally in the top cells. It just means 2, 6 and 5 each hit once that draw. By filtering the numbers in the matrix cells you are able to filter up to a million individual draws for specific combinations. EXCEL won't allow more than a million draws, but most uses and draw histories wouldn't go beyond 15,000 anyway.

Thanks.
CARBOB

COLUMBUS,GA.
United States
Member #4,924
June 3, 2004
6,719 Posts
Offline

Mar 23, 2011, 7:06 pm

Quote: Originally posted by CARBOB on Mar 23, 2011
Thanks for responding.What does the values in red represent?

AZ p3 3/15/2010 6 2 5 0 1 0 0 1 1 0 0 0 0

The data below is for Fla Mid. A 6-digit string that stands at 121 draws, after todays draw.

1,2,4,7,8,9

DIGITS 0

HITS 72

MED 9

MAX 120

AVG 14.43

CUR.SKIP 120

In case anyone is interested, these are the straight combos, 64 of them, when the string breaks.

035, 036, 053, 056, 063, 065, 305, 306, 350, 356, 360, 365, 503, 506, 530, 536, 560, 563, 603, 605, 630, 635, 650, 653
003, 005, 006, 030, 033, 050, 055, 060, 066, 300, 303, 330, 335, 336, 353, 355, 363, 366, 500, 505, 533, 535, 550, 553, 556, 565, 566, 600, 606, 633, 636, 655, 656, 660, 663, 665
000, 333, 555, 666
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 23, 2011, 8:18 pm

Thanks Carbob. I don't get into examining single digit draws usually but I'll look this over.
JosephusMinimus

United States
Member #105,307
January 29, 2011
474 Posts
Offline

Mar 26, 2011, 11:11 am

Anyone with a preference for visual mapping of databases might find the countifs useful, as well. This map of a recent series of pick 4 draws is an example of such mapping.

The double helix patterns might eventually become boring, however.

-11-----2-
----2-11--
-1-1---11-
-1-1-1---1
--1-12----
--1-11-1--
-1--1-1--1
-1-2----1-
---11-1--1
---1-11---
---12---1-
-1-------3
-------121
---1--11-1
-1-111----
--1-111---
-11-1-1---
--21-----1
---1----11
--1--1----
------12-1
--11---1--
--1-111---
------11-2
--2-------
--1-1----2
--11-1---1
--1-----11
-2-1----1-
-1-----1-1
-11------1
-----1-111
--1-21----
---11--2--
----2-11--
---111----
--11---1-1
--1-1-11--
--21--1---
-----21-1-
--12----1-
--------12
-11----1--
--111----1
-2----1---
------1-2-
---121----
-1--1---11
----1---12
----1-----
--111-1---
-2-----1-1
-1------1-
-1--1-11--
------21-1
---2--2---
-1--2----1
--2-----11
--111----1
------11-2
----1----3
-1--1--1-1

New Topic New Poll

Subscribe to this topic

	1,2,4,7,8,9
DIGITS	0
HITS	72
MED	9
MAX	120
AVG	14.43
CUR.SKIP	120

	1,2,4,7,8,9
DIGITS	0
HITS	72
MED	9
MAX	120
AVG	14.43
CUR.SKIP	120

	1,2,4,7,8,9
DIGITS	0
HITS	72
MED	9
MAX	120
AVG	14.43
CUR.SKIP	120

Identifying 'string' and other repeating patterns on EXCEL - all lotteriesPrev TopicNext Topic

Identifying 'string' and other repeating patterns on EXCEL - all lotteriesPrev Topic Next Topic