Identifying 'string' and other repeating patterns on EXCEL - all lotteries

Reply #13

JosephusMinimus — Sat, 26 Mar 2011 15:11:15 GMT

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

Reply #12

JosephusMinimus — Thu, 24 Mar 2011 00:18:15 GMT

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

Reply #11

CARBOB — Wed, 23 Mar 2011 23:06:10 GMT

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

Reply #10

JosephusMinimus — Wed, 23 Mar 2011 23:05:14 GMT

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.

Reply #9

CARBOB — Wed, 23 Mar 2011 22:34:09 GMT

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

Reply #8

JosephusMinimus — Wed, 23 Mar 2011 22:15:48 GMT

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.

Reply #7

JosephusMinimus — Wed, 23 Mar 2011 19:55:59 GMT

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 j... [ More ]

Reply #6

CARBOB — Wed, 23 Mar 2011 18:54:14 GMT

I would like to see some of your countif formulas

Reply #5

JosephusMinimus — Wed, 23 Mar 2011 18:52:22 GMT

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 se... [ More ]

Reply #4

ameriken — Wed, 23 Mar 2011 16:40:33 GMT

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... [ More ]

Reply #3

JosephusMinimus — Wed, 23 Mar 2011 16:33:00 GMT

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 a... [ More ]

Reply #2

Kia69 — Wed, 23 Mar 2011 16:29:13 GMT

I will like to learn too

Reply #1

ameriken — Wed, 23 Mar 2011 16:00:16 GMT

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

Identifying 'string' and other repeating patterns on EXCEL - all lotteries

JosephusMinimus — Wed, 23 Mar 2011 14:07:24 GMT

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 p... [ More ]