Excel Assistance

Reply #37

time*treat — Sun, 16 Oct 2011 17:12:52 GMT

New games don't give you much option, but I think a good dataset size to backtest on needs to be at least a few hundred data points.

Reply #36

RJOh — Sun, 16 Oct 2011 16:55:55 GMT

Can I assume you no longer think you can win a pick5 game only spending $12,000.00

Reply #35

thinktank — Tue, 11 Oct 2011 00:26:54 GMT

Thanks for reading and I took your advice back testing even more and I found out that it's not consistant with every 20 games so I still have to find a way to trap the most used vowels, I will keep u guys posted

Reply #34

RJOh — Mon, 10 Oct 2011 21:14:47 GMT

excel is telling me I would had to buy $600 worth of tickets per game, to win the 5 out of 5 jackpot. so $600 x 20games = $12,000.

Are you saying, your excel calculations are showing your odds of matching 5of5 in a pick5 using your system are 1:12,000? Sounds like it time to start making some predictions and earning some bragging rights.

Reply #33

Seachelle — Sun, 09 Oct 2011 10:56:36 GMT

Hi Thinktank,

I would say you are making progress! You may have to test your program some more. When you can change the maybe to on average the jackpot would hit within 20 games then you have yourself a program! Don't let the number of games or the cost discourage you! Thanks for sharing your idea!

I almost forgot to ask on average, how many of your vowels hit per game?

Seachelle

Reply #32

thinktank — Sun, 09 Oct 2011 05:13:03 GMT

Well good news/bad news, the bad news is I wish I had a better extraction method. The good news is I have my handful of vowels, and I back tested them. I don't know if this is success or not, but I will let you guys tell me. It seems that the common vowels hit maybe once out of 20 game with a 5 out of 5 jackpot ticket, but the vowels are so general, that excel is telling me I would had to buy $600 worth of tickets per game, to win the 5 out of 5 jackpot. so $600 x 20games = $12,000. That's too s... [ More ]

Reply #31

thinktank — Sat, 08 Oct 2011 14:03:04 GMT

hmm.. how do you even go about organinzing a chaotic table? I've never done one before, but it may shed some light

Reply #30

dr san — Sat, 08 Oct 2011 11:45:20 GMT

Hello, think, you could also organize a chaotic table, with rows and columns In order to see patterns of letters with consonants and vowels, would be a table of 20 columns With the BJECTIVES to find patterns, likely to play, the problem is how to tie

Reply #29

thinktank — Thu, 06 Oct 2011 00:18:07 GMT

also, what makes this unique is that if a vowel doesn't fit in a paragraph (game) then, the vowels will warn me not to play a game, thus saving money! So that you guys know, I really don't play the lotto, but I love the challenge of figuring it out! It keeps me sharp in my professional carreer

Reply #28

thinktank — Thu, 06 Oct 2011 00:09:12 GMT

Well guys, good news! I sat back and rethought my position! I have come to a new way of coding this concept, but it's still slow, but feasible! I have to work out a lot of bugs, due to early development; however, from the beta coding, their seem to be some kind of relationship among the vowels. So far I have discovered, that the vowels are closley related to the last 5 games played, and they play in harmony, i.e. game 1 being the current, game 2 is previous game, etc. The relationship of vowels... [ More ]

Reply #27

RJOh — Tue, 04 Oct 2011 23:30:01 GMT

If it works it won't be for sale.

Reply #26

billbo45 — Tue, 04 Oct 2011 23:10:48 GMT

I will speak for a lot of people out of my pay grade :) good luck if it works i will buy it

Reply #25

time*treat — Tue, 04 Oct 2011 23:00:31 GMT

If you have some old sets of these strings, ones that you already know work , it would be possible to see if some code can be written that would forward calculate in a reasonable amount of time.

Also --- The lottery is in no danger of being bankrupted; its payout rules prevent that.

Reply #24

thinktank — Sat, 01 Oct 2011 13:14:52 GMT

Yea, and the problem is that each game played is a paragraph, or term paper if you will! Also remember that if a number hit in a game, say the number 30 in, i.e. 10-20-30-33-36. Lets say the number 30 is the vowel letters, t,u,RT , remember the letter RT counts as one letter. Now say the number 30 hits in this game with winning numbers,i.e.: 2-16-30-38-39. Now the number 30 uses, vowels, x,l,m . Now these vowels, (t,u,RT) is vowel set one, (x,l,m) is vowel set two. A lottery game may have up to

Reply #23

dr san — Sat, 01 Oct 2011 12:59:18 GMT

Hello, think, the problem of foreign language, but continue with the project, then we will see your progress and make improvements ok

Reply #22

thinktank — Sat, 01 Oct 2011 00:38:52 GMT

Dr.San, can u please elaborate on what u are saying, I'm not following you

Reply #21

dr san — Fri, 30 Sep 2011 22:18:17 GMT

Hello, think this concept will work, when we find a refence (a base) Then it does not repeat when you combine the positions, pieces of letters such as defined Reference example of the group took four or five basic formations ab, cd na, the group of 20 numbers Then it does not match the same positions equivalent to each group of letters, but lotteries have repetitions and delays of the numbers we have to reconcile these factors is to collect pieces into the group 20 and match but not in the same

Reply #20

thinktank — Fri, 30 Sep 2011 14:22:19 GMT

The beauty of analyzing the entire history of a state 5/39 game is the macro would give me the constant strings used, if it could calculate fast enough. There may be over 60, 20 length constant strings used in an entire history of a game, but If I played those 60 strings every time I play the lottery, then I would hit the jackpot every time, of course I wouldn't want to bankrupt the system, by abusing its use.

Think of it like this, when you write a paragraph or term paper, most likely you w... [ More ]

Reply #19

thinktank — Fri, 30 Sep 2011 13:58:08 GMT

I obtain the twenty set from the relative past 5 lottery 5/39 games! It could be any state game because they all obey the same concept. The macro looks at each game and gives letters for there 5/39 game. It's really in-depth, and to understand it would contradict any mathmatics we have learned in school, so that's why it's hard to explain because it goes against our basic laws. But it works, that's all I know! But to be honest you could use the whole history of any state game, and usually they w... [ More ]

Reply #18

winsumloosesum — Fri, 30 Sep 2011 10:59:50 GMT

This sounds very interesting. What calculations do you use to determine the 20 cell set?

Or should I ask where do the 20 cell set(s) come from

Reply #17

thinktank — Thu, 29 Sep 2011 14:09:37 GMT

yea you are right about option A, I believe I will have to come up with another method because, although i can cut a 20x20 game down to a 8x7 game, applying this cut down method on 20 sections of 20cell per section is still too many calculations (the average benefit is it cuts it down by making a 20^20 power= 1x10^26 calculations, down to a 12^20 power=3.83x10^21 calculations, and so the process will still take too long). The sad thing is that, this method I have really does crack the lottery, a... [ More ]

Reply #16

time*treat — Wed, 28 Sep 2011 21:22:09 GMT

Other folks may chime in if you add some (simplified) have-this-input/want-that-output charts.

From what I'm gathering, it looks you could do most of the work with nested, dynamic-sized do/for-loops.

In your example sets, Set A has letters A,C,D,E,G,O,T, Set B has letters V, Z, AE, AF,AJ,AK, AL, AM

20 X 20 pairs has been reduced to 7 X 8 pairs. The ratio gets even better as you scale up. Three 20-letter sets will be way less than 8,000 combinations to check.

Of course, if you are cer... [ More ]

Reply #15

thinktank — Wed, 28 Sep 2011 14:43:01 GMT

Here is where I m going with this project. I have a 20 set of 20cells per set line up. A 20 cell set column represents one letter. However, in the 20 cell set, the number 1 is written in some cells indicating a designated sub-letter. It s confusing but let me explain further.

In my excel program, I have twenty, 20 cell sets.

So in reality 20x20 = 400 cells maximum per word, assuming each had a number 1 written in it's cell, but the most I counted was about 200 cells with the number 1... [ More ]

Reply #14

time*treat — Wed, 28 Sep 2011 13:54:25 GMT

You could do it that way, but it would be a little bit more coding.

I was thinking you were looking for the string to be a contiguous set of characters.

e.g. if target = 1,4,1 then

1,2,5,6,1,4,1 = pass

but

1,2,5,4,6,1,1 = fail

Reply #13

thinktank — Wed, 28 Sep 2011 12:41:45 GMT

I see we are on the same page, just to clarify one more thing. It's imperative to realize that according to your example the order of arrangement of strings are not important, ie: like your first 3 set of string, 141.

if the macro sees a 1,4,1 in line#2, then it's suppose to consider that string found in line#2. It doesn't matter if the string is found in exact order as it is written, or if it find letters 1,4,1 scattered throughout the line, but as long as it finds the letters 1,4,1 in a lin... [ More ]

Reply #12

time*treat — Wed, 28 Sep 2011 00:21:53 GMT

I'll help out where I can. This might illustrate better, too (very, very simplified).

Let's say I'm looking for 3-digit repeats and this is my list:

25 chars per line, 16 lines

Line #01: 1415926535897932384626433

Line #02: 8327950288419716939937510

Line #03: 5820974944592307816406286

Line #04: 2089986280348253421170679

Line #05: 8214808651328230664709384

Line #06: 4609550582231725359408128

Line #07: 4811174502841027019385211

Line #08: 0555964462294895493038196... [ More ]

Reply #11

thinktank — Tue, 27 Sep 2011 23:35:34 GMT

Thanks time*treat for your thorough input, and to be honest one word is over 300 letters long, but I really see where you are going with your example, as I will try to write such a scheme in a macro. Feel free if you want to help develop this algorythm. My original program was already allocated such that each word/ 300 letters were placed in their own cell in excel. This made things easier to decipher. My only issue was how do I choose the specific 20 letters out of the 300 letters to do the sea... [ More ]

Reply #10

time*treat — Tue, 27 Sep 2011 17:54:31 GMT

Q: Lets say I need the macro to find me a 20 string length of common letters among 6,000 words, which are each 100 letter length.

I: 20 character string target, 100 characters per line, 6000 lines

(This will require 3 or 4 arrays, 2 or 3 counters, and judicious use of for-next loops)

set counter(s) to 0

A: grab chars 1~20 from line 1.

(this system will work much faster if the 20 characters are placed individually in an array of length 20, rather than a single string of 20 ch... [ More ]

Reply #9

thinktank — Fri, 23 Sep 2011 01:48:43 GMT

Thanks for your input phil, the only programming language I've done outside of macros, is C++ and that was like a decade ago in college..lol..Perhaps I should consider picking that software up and getting back to it

Reply #8

phileight — Fri, 23 Sep 2011 01:42:33 GMT

think tank

I did not bother to try to figure how many possible combinations you would have with just 1 line of 100 characters of which you are looking for twenty. given your question i would offer three choices

1 forget it 2. wait for much faster computers 3. change the question

change the question . what if you generated a 20 character string of random characters then searched your database of 6000 lines for this string. repeat as many times as you want or have time for.

a compiled

Reply #7

dr san — Fri, 23 Sep 2011 00:45:35 GMT

Hello, think, care, with the translation of google, have to see that perfect google Naoe think it is easy example of a lottery 49 / 6 01 13 15 21 32 45 A b c d e f Make the switch up to 24 letters, so they are 4 results All chosen from previous results. Choose several blocks of results (all the list of past results) After ab block combines well with a 2 cd pack, and get the idea DAPs pieces or segments and join previous results, if any other forum member Understand the macro can help ok

Reply #6

thinktank — Thu, 22 Sep 2011 17:27:47 GMT

dr. san thanks for your input, yet I'm still trying to grasp where you are going in your example! Please be patient with me, as I'm not quite the sharpest tool in the shed, so can you elaborate a bit more? With an example with using the actual numbers.

Reply #5

thinktank — Thu, 22 Sep 2011 17:20:27 GMT

Karinda thank you so much for your input, but I do wish it was so simple! When writing programs, it comes down to one scenario:

1) You must enter an input for the computer to calculate an output.

In your case your input variable was av*.* and windows explorer gave you your output results (what you needed), which was a program that started with av.

However, my input variable is more complex. It is as follows:

I have two inputs for my program. The first input is the minimum number... [ More ]

Reply #4

RJOh — Thu, 22 Sep 2011 11:25:04 GMT

If someone could help me with this problem in excel, then the lottery would be solved!

If it was that easy, it would have been done by now.

When I read earlier this month about the Michigan couple who traveled to Massachusetts to spend $150K exploiting its lottery rundown, it proved there are plenty of folks who are looking for ways to beat the lotteries and willing to spend the money and time to do it if it is at all possible.

Reply #3

dr san — Thu, 22 Sep 2011 00:04:50 GMT

Hello, think I can give a suggestion, an example of a lottery 49 / 6, get the list of results already passed and assign drive letters, so we have 6 positions, get 4 results, can not be followed here if you hit these intervals of 4 drawing, which will have to get halfway to success, then 4 6 letter will give results to 6x4 = 24 letters, doing so takes The factor that rarely repeats the numbers from previous draws 6 pieces but rather as pairs and trios. After doing this to give up to 6 letters 24

Reply #2

karinda — Wed, 21 Sep 2011 21:17:18 GMT

Thinktank,

Essentially, this is what a program like Windows Explorer does when a file search is done.

For example, yesterday, I wanted to find a program on my computer that began with av,

so I searched for av*.*. It found me what I needed. If I left the wildcard out, it found me more

than I needed. So there are programs that will do this and not take 800 years, even on my

machine. :) What I'm not sure about is what you're trying to accomplish. I don't know what

the file length... [ More ]

Reply #1

karinda — Wed, 21 Sep 2011 17:24:01 GMT

Hi thinktank,

I saw your post in another Forum and now I don't know where it is, so I'll just respond to you here. Todd just added a new tool for the Pick3 and the Pick4 that will isolate strings of numbers. If I understand your question correctly, it seems to me that you are looking to do something similar, but for the Cash-5. Good luck with your research. Hope this points you in the right direction. Here's the link to the discussion about the tool.

https://www.lotterypost.com/thread/2367... [ More ]

Excel Assistance

thinktank — Wed, 21 Sep 2011 14:44:20 GMT

If someone could help me with this problem in excel, then the lottery would be solved!

Look at the below example as this is as simple as I can explain it! Please don t over think this problem or you will get stuck like me!

Take the three words for example, Cake, Lace, Tape:

In the above three words, the common string letters in each word is ae

I am trying to develop a macro that can look at per say these three words for simplicity and find the common string letters am... [ More ]