How to Train Your Excel File to Play the LotteryPrev Topic Next Topic

New Topic New Poll

garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,468 Posts
Offline

Aug 7, 2019, 1:07 am

I like the way you set up the Ducklings!

Lot of questions swirling around my head as I look at it and play with it. On the Picker menu I it says "Select something and let the dog hunt."
I select Texas. How do I make the Dog hunt?

Draws Chart I'm not sure I'm clear on the notation used for each position. I see how's its done. Left of the decimal is this draw. Right of the decimal is next draw.

The 35 X 35 matrix you used for the Count chart is GREAT! I should have used that in the program but as I said I likely over complicated the whole thing working with positions.

Not sure I understand the Ducklings(1) chart. You have rows 1 to 30 and columns 1 to 21? And I'm really confused on how the hit counts are tabulated. It looks like everything is defaulting to the heading number unless there is a count to display?

Ducklings(2), (3), (4), (5) are clean and clear. I'm getting the count to the left of the number and the ducklings to the right.

Impressive work! You made it much clearer and simpler than what I envisioned! Everything seems to be working properly. I do have to enable Macros each time I switch sheets, but that's not a big deal (to me).

I completely understand if you want to take this to private or email. It is a SUPER job and you did the work of jumping through the hoops to make it work.

You deserve the applause here!

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
AllenB

California
United States
Member #167,120
June 27, 2015
1,777 Posts
Offline

Aug 7, 2019, 1:18 pm

Quote: Originally posted by Cmoore50 on Aug 7, 2019
Check this out guys. This was the last powerball drawing..3-6-45-66-68. Scroll over to the right...it's 33333 pattern. I got this pattern idea from the book "Beat The Odds In The Lottery". But I expanded it..Any pattern higher than a 3. It shows it to the right of the original pattern..Four of the 3's in the 33333 pattern were 5566. Now go down to the second picture.

Scroll to the right...Look at line three (you use the previous line to play the next drawing)..there were only five 4's and four 5's..So those nine numbers would've been a 4 of 5 hit. Let's look at each number.

3 dropped off 31 drawings ago..So it stayed a 3(which means it's hit 3x in the last 30 drawings. If three didn't hit. It would've dropped to a 2. Six (5 hits to 6 hits)..45(4 to 5 hits..) 66 ( 5 to 6 hits)..68 (4 to 5 hits). A 55 hit in the same drawing has only come up 21 times..A 66 is only 4 times. This is probably the first time together..I could expand this to even more drawings back. This is a rolling 30 draws back. Each line represents 30 draws. This is why we do this. WOW!!!

Nice Setup Cmoore50.

As I Understand that Book (Still have not read it), a Round is the Number of Balls divided by the Number of Balls Selected. That would give you 69/5 = 13.8 Draws.

If You used 14 Draws your counts would be about half and the Code Numbers (Hit Counts in the Round) could be confined to 0,1,2,3. With 3 representing 3 or more hits in the Round.

I have a Fantasy 5 (5/39) Setup Based on 8 Game Counts. My Unread understanding of Igor's Method is that he includes the Current Draw in the Hit Counts. What that Means is that the Count for a Number that hits will be either 1,2 or 3 and the Codes Range from 11111 to 33333 with digits restricted to 1,2 or 3. Selection is accomplished by having a Parallel Numbers File that counts the Hits from the Previous 7 Draws and adds 1 giving you the code for a Number IF it hits in the Next Draw. Selection is done by Code Values for each position. One of the Thing I use is a Code Number that in this Game is a 3 Digit Number made by counting the 1,2,3 in the Code itself. It Gives you a way of Selecting a Group of Codes all with the same counts but in different positions. It is a good System, but It is still difficult to Get the Right Code and that is for a 5/39 Game.

Jumping to your Game, I don't suggest a different Round (14). In fact I like your 30 Game Counts. I would use Igor's Counting method (which includes the Current Draw). That way you can limit the code Values from 1 to 5 and get a 5 Digit Code from 11111 to 55555 with no digits over 5. Code Numbers would also be 5 Digits counting 1,2,3,4,5 in order. As with Fantasy 5 or any game, You need a Numbers Chart that Counts the Hits from the Previous (Round -1) Games. Adding 1 to those Counts gives you the Code Value for the Number IF it hits. This lets you Get the Numbers Options for each position from the 5 Digit Code or a Larger Group using the 5 Digit Code Number. Getting the Right Code gives you a list of numbers in each position to "Wheel" and results in a sizable set of Combinations that can be further reduced by applying different parameters like O/E, HML etc

You have all of the Data. You don't have to change a thing. The important thing is that you understand your Data. I only suggest that your counts include the Active Game because 0 is Eliminated as a Selecting Option.

Now it is Time to Set up a Training Sheet wherein you can apply some When/Then options and let the Big Dog Hunt. This is where the Rubber meet thin Air on the Random Road. Your Dog will need a Hover Board to move along the this road, unless you can figure out a way to get some traction from Thin Air. In the end you will find yourself standing on the Cliff, holding a bag of Options that you hope have produced a Winner.

Now Comes the Tail Chasing.

Good Training

Allen
AllenB

California
United States
Member #167,120
June 27, 2015
1,777 Posts
Offline

Aug 7, 2019, 1:46 pm

Quote: Originally posted by garyo1954 on Aug 7, 2019
I like the way you set up the Ducklings!

Lot of questions swirling around my head as I look at it and play with it. On the Picker menu I it says "Select something and let the dog hunt."
I select Texas. How do I make the Dog hunt?

Draws Chart I'm not sure I'm clear on the notation used for each position. I see how's its done. Left of the decimal is this draw. Right of the decimal is next draw.

The 35 X 35 matrix you used for the Count chart is GREAT! I should have used that in the program but as I said I likely over complicated the whole thing working with positions.

Not sure I understand the Ducklings(1) chart. You have rows 1 to 30 and columns 1 to 21? And I'm really confused on how the hit counts are tabulated. It looks like everything is defaulting to the heading number unless there is a count to display?

Ducklings(2), (3), (4), (5) are clean and clear. I'm getting the count to the left of the number and the ducklings to the right.

Impressive work! You made it much clearer and simpler than what I envisioned! Everything seems to be working properly. I do have to enable Macros each time I switch sheets, but that's not a big deal (to me).

I completely understand if you want to take this to private or email. It is a SUPER job and you did the work of jumping through the hoops to make it work.

You deserve the applause here!

G

Gary.

The Followers Setup was initiated by your Post. Given that it is being discussed here it suggests that the File should be shared. Your Call.

I will check out what I sent you. I will check the Ducklings (1) Tab to see if there is an Error. I only spent about an hour on this and did not proof it before sending.

Currently there are 3 Games to Play in the Files and only the Raw Data is in Place. Before the Big Dog can Hunt, we need to set up a Training Sheet with those unreliable When/Then Formulas. The Dog is going to have to find the winner while chasing its Tail, not an easy Find. I keep running Tests with Varied ideas for the Code Selection including Fixed Sets, Variable Sets based on Formulas that dive into the Hit counts and Change Observations. This is the Hard Part. So Far I have only found a few Lines from my 228 or Combinations thereof that have very small Gains over the 1000 Game Binges that I am now hooked on watching.

Baby Steps
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,468 Posts
Offline

Aug 7, 2019, 2:26 pm

Quote: Originally posted by AllenB on Aug 7, 2019
Gary.

The Followers Setup was initiated by your Post. Given that it is being discussed here it suggests that the File should be shared. Your Call.

I will check out what I sent you. I will check the Ducklings (1) Tab to see if there is an Error. I only spent about an hour on this and did not proof it before sending.

Currently there are 3 Games to Play in the Files and only the Raw Data is in Place. Before the Big Dog can Hunt, we need to set up a Training Sheet with those unreliable When/Then Formulas. The Dog is going to have to find the winner while chasing its Tail, not an easy Find. I keep running Tests with Varied ideas for the Code Selection including Fixed Sets, Variable Sets based on Formulas that dive into the Hit counts and Change Observations. This is the Hard Part. So Far I have only found a few Lines from my 228 or Combinations thereof that have very small Gains over the 1000 Game Binges that I am now hooked on watching.

Baby Steps

Now I feel relieved that the JRE is working property and that what I got is what I should have! Big load off my mind with there. Good answer.

Hmmm......

As much as I want everyone to have it, and planned on it at some future point, I have reservations about putting it out there until there are conclusions drawn based on the data produced. That's my MO with everything I post. Check, double-check and see if/what I missed before making a stupid post that needs to be retracted.

And the reservations outlined in the email.

Too, I'm working on alternate dependencies which may be "more" reliable? Not sure if that's the right descriptor at this point. Sifting through a wall of zeroes will cloud perception quickly.

All that said....

Its your spreadsheet and your work. You jumped through the hoops, you derived the best, easiest to understand data so far (and for that I'm grateful).

I know once its in the wild there will be copycats cranking out everything under the sun. And that bothers (a little).

No hard feelings since putting it out was the (eventual) intent of the idea just like most....no some....(more like only my best ones).

I'm there to help any way I can.

You did a (I don't say this a lot) helluva job with it and you deserve the credit.
Roll it out.

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
AllenB

California
United States
Member #167,120
June 27, 2015
1,777 Posts
Offline

Aug 7, 2019, 2:29 pm

Quote: Originally posted by garyo1954 on Aug 7, 2019
Now I feel relieved that the JRE is working property and that what I got is what I should have! Big load off my mind with there. Good answer.

Hmmm......

As much as I want everyone to have it, and planned on it at some future point, I have reservations about putting it out there until there are conclusions drawn based on the data produced. That's my MO with everything I post. Check, double-check and see if/what I missed before making a stupid post that needs to be retracted.

And the reservations outlined in the email.

Too, I'm working on alternate dependencies which may be "more" reliable? Not sure if that's the right descriptor at this point. Sifting through a wall of zeroes will cloud perception quickly.

All that said....

Its your spreadsheet and your work. You jumped through the hoops, you derived the best, easiest to understand data so far (and for that I'm grateful).

I know once its in the wild there will be copycats cranking out everything under the sun. And that bothers (a little).

No hard feelings since putting it out was the (eventual) intent of the idea just like most....no some....(more like only my best ones).

I'm there to help any way I can.

You did a (I don't say this a lot) helluva job with it and you deserve the credit.
Roll it out.

G

Check your Email
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,468 Posts
Offline

Aug 7, 2019, 3:08 pm

Quote: Originally posted by AllenB on Aug 7, 2019
Check your Email

Read email.
Agreed.
Responded.

Your work. Your call.

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
AllenB

California
United States
Member #167,120
June 27, 2015
1,777 Posts
Offline

Aug 7, 2019, 3:57 pm

I would like to thank Garyo, Mr-B and Cmoore for responding to this Topic. An unstated goal of the Topic was to find a few potential “Trainers” to collaborate with. I am hopeful that I have found a couple.

I am Ending my Input on the Topic. I am going to withhold any new Ideas for the Training Regiment until they are Tested and evaluated.

Thanks again to the 3 of you.

I hope the Silent Ones got something from this Topic
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,468 Posts
Offline

Aug 7, 2019, 7:30 pm

Quote: Originally posted by AllenB on Aug 7, 2019
I would like to thank Garyo, Mr-B and Cmoore for responding to this Topic. An unstated goal of the Topic was to find a few potential “Trainers” to collaborate with. I am hopeful that I have found a couple.

I am Ending my Input on the Topic. I am going to withhold any new Ideas for the Training Regiment until they are Tested and evaluated.

Thanks again to the 3 of you.

I hope the Silent Ones got something from this Topic

You are welcome!

Thank you for the interesting thread too! I would have like to see a bigger group tabling ideas, but it is what it is.

I may post on the Texas Cash 5 in a couple of days, and I'm thinking I'll adapt this to the Texas 2 Step. Two Step pays better than Cash 5. Right now 2 Step is at 1.375 million. And more data to work with!

Time for dinner before I continue.

Thanks!

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
Mr-B 216

Ohio
United States
Member #179,973
February 15, 2017
1,333 Posts
Offline

Aug 7, 2019, 7:46 pm

Quote: Originally posted by AllenB on Aug 7, 2019
I would like to thank Garyo, Mr-B and Cmoore for responding to this Topic. An unstated goal of the Topic was to find a few potential “Trainers” to collaborate with. I am hopeful that I have found a couple.

I am Ending my Input on the Topic. I am going to withhold any new Ideas for the Training Regiment until they are Tested and evaluated.

Thanks again to the 3 of you.

I hope the Silent Ones got something from this Topic

Sorry I couldn't add anything of relevance here Allen. I have about one more week to go until things slow down for me here.

I'm not familiar with the Ducklings and such, but I do applaud you for always thinking outside the box. I may not often follow what it is you are doing, but that doesn't mean I have no interest.

Best of Luck to you!

What goes around comes around.
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,468 Posts
Offline

Aug 8, 2019, 2:41 pm

Quote: Originally posted by Mr-B 216 on Aug 7, 2019
Sorry I couldn't add anything of relevance here Allen. I have about one more week to go until things slow down for me here.

I'm not familiar with the Ducklings and such, but I do applaud you for always thinking outside the box. I may not often follow what it is you are doing, but that doesn't mean I have no interest.

Best of Luck to you!

"I may not often follow what it is you are doing, but that doesn't mean I have no interest. "

You're not alone in that boat Mr. B. I'm a slow, step by step person whereas AllenB takes an idea and starts adding avenues I haven't seen on the GPS yet! Very quick mind!

G

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
Mr-B 216

Ohio
United States
Member #179,973
February 15, 2017
1,333 Posts
Offline

Aug 8, 2019, 4:42 pm

Quote: Originally posted by garyo1954 on Aug 8, 2019
"I may not often follow what it is you are doing, but that doesn't mean I have no interest. "

You're not alone in that boat Mr. B. I'm a slow, step by step person whereas AllenB takes an idea and starts adding avenues I haven't seen on the GPS yet! Very quick mind!

G

Glad to hear it's not just me garyo.

I have always been a "learn by visual" kind of guy. That's why I always try to include pictures along with words to explain what I am doing. Each of our own work is clear as day in our own minds (usually), but it's easy to forget how others may be lost with no idea of what is going on. That could explain Allen and his crickets.

No burn on you Allen, just one possibility of why you get so few responses.

What goes around comes around.
Harve$t Moon

United States
Member #76,982
July 10, 2009
11,000 Posts
Offline

Aug 9, 2019, 11:03 am

Happy Birthday, AllenB!

8♦K♠ HMBC KeyPad System ♥ Love Train Delay and Wait

Lottery Bible Log Lottery Bible Associate Numbers The Old Switcheroo

Lottery Bible Tips LB The Stars 2DR Notes

My curve ball approach Chat Trans Mission BD ?C
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,468 Posts
Offline

Aug 9, 2019, 11:50 am

Happy Birthday!

I'm probably here unless I'm not.
Dreaming would be a perfectly useless function if it's only purpose was to entertain.
AllenB

California
United States
Member #167,120
June 27, 2015
1,777 Posts
Offline

Aug 9, 2019, 12:13 pm

Thank You Harvest Moon and Garyo

It's the Big 7 0

I celebrated last night. A bit Slow Today.
Cmoore50

United States
Member #194,171
December 3, 2018
621 Posts
Offline

Aug 9, 2019, 1:32 pm

70...You’re only as old as you feel. 70 is the new 50.

New Topic New Poll

Subscribe to this topic

How to Train Your Excel File to Play the LotteryPrev TopicNext Topic

How to Train Your Excel File to Play the LotteryPrev Topic Next Topic