How to Train Your Excel File to Play the Lottery

Reply #65

garyo1954 — Fri, 30 Aug 2019 06:30:29 GMT

LOL! I miss all the good stuff.

Synopsis of 1000 arguments on LP:

You can't predict the lottery.

Might.

No, you can't!

Prove it can't be done.

Its IMPOSSIBLE! I tried!!!!!

Ok, you can't predict the lottery.

Glad we agree.

eye roll.... Uh.....what? Oh.....yeah....yeah......we......uh....agree YOU can't predict the lottery.

Allen, it would be enjoyable to have a discussion on thoughts, process, ideas, etc. And people should be aware that such a post and discu... [ More ]

Reply #64

Cmoore50 — Fri, 30 Aug 2019 04:57:23 GMT

C'mon AllenB. What's goin on with you.? snip !! I m having a hard enough time doing my own thing. I said I was interested in your scoring system. I have no idea how it works. Plus I also asked you, if you were still working on the gap theory? Remember that thread I started about Igors book. Who took over that thread and posted about Gap Theory . That's right, it was you. Did I say anything. Not a frickin peep. So stop the nonsense about This is what I'm doing quote . Most on this board don't und... [ More ]

Reply #63

AllenB — Fri, 30 Aug 2019 03:40:37 GMT

You must have been itching for someone to correct. Might I suggest that the static is the Past?

I will never again make up a quote for you, even if it does say the same thing as your Corrected Version.

Take your time, You were better than that.

Welcome Back to the Box

Reply #62

Tucker Black — Fri, 30 Aug 2019 01:58:51 GMT

Hi I'm back. Glad to see that people still remember me. :)

The correct statement is not there is no connection between the static and the future . That makes no sense. What is the static ?

The correct statement is past results do not predict future results .

You can analyze a million draws and it still won't help.

Playing the lottery recreationally is okay (not too much given the very high house edge), but please don't waste your money on books and don't waste your time creating thes... [ More ]

Reply #61

AllenB — Thu, 29 Aug 2019 23:09:27 GMT

I don t get it. I offer to share my scoring system with you privately and get no response. Just another exchange of This is what I am doing . I got a little bored with the forum and decided to update my Topic and included an idea for Filtering Jumps or Deltas. I only used the Scoring System as an Example of how to Filter the Deltas (Up Down or Same).

It is as if there are 2 Different Cmoore50s. One that is Private and One that is Public (On LP). The Private one seems to ignore questions and

Reply #60

Cmoore50 — Thu, 29 Aug 2019 21:59:45 GMT

Hey Allen...Could you give a detailed example on your scoring system.

Reply #59

AllenB — Thu, 29 Aug 2019 01:00:36 GMT

Thanks all for the Happy Birthdays.

I was deep into Training at the time and to be honest, so much has changed that I can't remember what I was running over and over back then. Some where in the process It became obvious that I was Training the Un Trainable. Could be because I am now Over 70 (by 19 Days). In the End, I found a couple of surprise Floaters but mostly Rocks (they don't float).

I realized that it was I that needed Training. So, I did what I always do and went back into the Dat... [ More ]

Reply #58

Stack47 — Sat, 10 Aug 2019 03:49:14 GMT

Happy Birthday

Reply #57

garyo1954 — Sat, 10 Aug 2019 01:35:45 GMT

AllenB, the pretests numbers are up.....

08/09/2019 Test# 1 N* A6* O A7 9 - 3 - 32 - 27 - 35

Test# 2 N* A6* O A7 25 - 22 - 31 - 29 - 15

Test# 3 N* A6* O A7 1 - 22 - 15 - 14 - 7

Test# 4 N* A6* O A7 31 - 18 - 35 - 6 - 1

8:35PM

Reply #56

AllenB — Fri, 09 Aug 2019 23:59:10 GMT

OK, Crickets, if you want to live come with me.

Everyone Else Sans Dr Jack (You see how i did that?) should follow.

This land is no longer safe for your brain.

It's all Yours Now Jack

Reply #55

dr san — Fri, 09 Aug 2019 23:26:49 GMT

hello, there's a way to reduce 7,770 by 64 apean patterns by 100%

where

pair = 1

odd = 2

example = 05 16 28 = 121211

You have to separate the triads from 02 to 38 from the draw register. Convert to 64 odd / even patterns and filter, so your fight now is the 64 trio patterns, you will win !!!

111111

111112

111121

111122

111211

111212

111221

111222

112111

112112

112121

112122

112211

112212

112221

112222

121111

121112

121121... [ More ]

Reply #54

cottoneyedjoe — Fri, 09 Aug 2019 23:10:09 GMT

God snippedy snip snip it! Someone get the spray bottle.

Reply #53

dr san — Fri, 09 Aug 2019 23:06:34 GMT

ok so who plays 39/5,

got a lottery from 02 to 38

to 7,770, much better than 575 ..... of the 5 numbers

you can use many filters to get to 5% of

central threes

a filter does not play the central draw trio former use a bim pick3 system

to filter the last of the trio

example 05 16 27 = last = 5,6,7 = pick 5,6,7

put in the RL system another filter

one repeated digit of the last and two remaining missing

Reply #52

Mr-B 216 — Fri, 09 Aug 2019 23:05:28 GMT

Happy Birthday Allen

Reply #51

Mr-B 216 — Fri, 09 Aug 2019 23:04:25 GMT

LOL! Good one garyo

Reply #50

garyo1954 — Fri, 09 Aug 2019 23:02:04 GMT

See what you did?

I mean, that's like calling 911 on yourself and begging for some police brutality!

G

Reply #49

dr san — Fri, 09 Aug 2019 22:57:57 GMT

ok the lottery is random but there are

its start and middle and end characteristics of a sequence of numbers drawn, and has positions

The following example is for playing 39/5. good use!!!

1st let's see the central trio from 02 to 38 = total

7,770 trios at 100% because the number 01 can never be from 2nd position and 39 from 4th position

so we have 7,770 central threes

01 xxx 39

you just need to filter the triplets, and then put the numbers on both ends

trio example = 08... [ More ]

Reply #48

garyo1954 — Fri, 09 Aug 2019 22:38:51 GMT

Nah, that makes too much sense to be mango comparito (except for the two misspelled words By instead of Buy and to instead of two ). Of course, it's 97 and snowing here which is my excuse for the misspellings.

I should have translated from Chinese to Czech to Comanche then to Hungarian.

Reply #47

cottoneyedjoe — Fri, 09 Aug 2019 22:07:02 GMT

dr san is that you

Reply #46

garyo1954 — Fri, 09 Aug 2019 21:39:45 GMT

The reason you feel that way is called The Random Taco Paradox. Here's how it works:

Ever notice that a Taco Bell taco always looks and tastes like a Taco Bell taco?

You never get a Taco Bell taco that looks or tastes any difference than the last 85047 you ate last week!

Yet, assembling that taco from all the different ingredients, everything being random, should mean each taco has its own texture, look, and taste.

If lottery people who claim everything is random made tacos... [ More ]

Reply #45

AllenB — Fri, 09 Aug 2019 17:49:24 GMT

I feel the same as I did in my 20-30 until I get up from a Chair, or climb in my truck.

The Big Real comes from the Fact that in another week and a half, I will have an Eleven Year Old Granddaughter.

Thanks Cmoore50

Reply #44

Cmoore50 — Fri, 09 Aug 2019 17:32:27 GMT

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

Reply #43

AllenB — Fri, 09 Aug 2019 16:13:56 GMT

Thank You Harvest Moon and Garyo

It's the Big 7 0

I celebrated last night. A bit Slow Today.

Reply #42

garyo1954 — Fri, 09 Aug 2019 15:50:15 GMT

Happy Birthday

Reply #41

Harve$t Moon — Fri, 09 Aug 2019 15:03:11 GMT

Happy Birthday, AllenB

Reply #40

Mr-B 216 — Thu, 08 Aug 2019 20:42:38 GMT

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.

Reply #39

garyo1954 — Thu, 08 Aug 2019 18:41:05 GMT

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

Reply #38

Mr-B 216 — Wed, 07 Aug 2019 23:46:06 GMT

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

Reply #37

garyo1954 — Wed, 07 Aug 2019 23:30:39 GMT

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

Reply #36

AllenB — Wed, 07 Aug 2019 19:57:54 GMT

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

Reply #35

garyo1954 — Wed, 07 Aug 2019 19:08:46 GMT

Read email.

Agreed.

Responded.

Your work. Your call.

G

Reply #34

AllenB — Wed, 07 Aug 2019 18:29:58 GMT

Check your Email

Reply #33

garyo1954 — Wed, 07 Aug 2019 18:26:20 GMT

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

Reply #32

AllenB — Wed, 07 Aug 2019 17:46:27 GMT

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

Reply #31

AllenB — Wed, 07 Aug 2019 17:18:59 GMT

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

Reply #30

garyo1954 — Wed, 07 Aug 2019 05:07:59 GMT

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

Reply #29

Cmoore50 — Wed, 07 Aug 2019 04:30:09 GMT

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

Reply #28

AllenB — Tue, 06 Aug 2019 22:11:14 GMT

Thanks for the Head Slap Jethro. I needed it. No Need to even consider that Road.

Reply #27

garyo1954 — Tue, 06 Aug 2019 22:06:10 GMT

Good Deal!. I'll do that.

Biggest drawback of having a new game is the small data file. New games aren't stable anyway, and often you'll see the sums, E/O, front digit patterns and things along that nature change rapidly as it matures.

(And I apologize for not making it clear I had received the files. I wasn't sure if it was something I should mention by name)

Thanks!

G

Reply #26

garyo1954 — Tue, 06 Aug 2019 21:58:00 GMT

AllenB,

I have this great big box where everything that is unquantifiable goes. There are so many little things about the draw that comes down to milli-seconds, or even micro-seconds there is just no way we could ever have all the necessary data on every draw.

Did that ball touch the side going in?

Did that one hesitate?

That ball looks bigger/smaller than the others.

That ball was got a little cold setting the machine and was heavier. Or it got hotter and lighter.

Is the te... [ More ]

Reply #25

AllenB — Tue, 06 Aug 2019 21:39:29 GMT

Just go to the Draws File and Replace the Data. Keep the Same order and Paste the Data.

You may need to add more rows of calculations to the Draw Tab in Ducklings File. I might have cut it short for the small set of draw I had for Texas.

Reply #24

garyo1954 — Tue, 06 Aug 2019 21:24:14 GMT

No email?

Apparently I never hit send. My apologies. Both files open in read only mode. Ducklings looks interesting. And like you say without enabling the Macros it won't do anything. So......

Found the Java site and working on getting stuff to make it do stuff.

Actually looking at (Texas) Draws.xlsm thinking I want to update the whole file to include the pretests. I can flip the CSV in Excel so that the newest draw is on top. Is there a way I can replace all the data at once... [ More ]

Reply #23

AllenB — Tue, 06 Aug 2019 20:51:03 GMT

It surprises me, because I have never watched the Draw, That they begin with the Balls Stacked the Same Way before the Machine is turned on. If that is the case then the Next Question is how long does it take for each Ball to Find the Tube.

That would be something that would make for some interesting Data. I doubt that data exists and don't expect anyone to watch (if possible) a bunch of draws with a stop Watch.

I do like he Potential. If you decide to and want some help, I'll watch a few... [ More ]

Reply #22

AllenB — Tue, 06 Aug 2019 20:39:06 GMT

Do you think its possible to train Excel or a program to make better choices?

As I Run these Test Trials, I have added a Group that runs on a restricted Randbetween Formula.

In an earlier post or in a PM to you, I suggested that from the 228 Formulas there were often 15 Different Inventories coming out of the Formulas. What I soon found out (because I new something was wrong) is that within those Inventory sets there are often 6 or more different numbers. So I have been Running a Set that... [ More ]

Reply #21

AllenB — Tue, 06 Aug 2019 20:22:57 GMT

i assume you got that followers set up that I sent you. I don't know because you have not responded. Seams like I can only get responses when the Mic Is on.

Anyway, Ignore any Macros in the Files. I ginned up another file to get the Followers and did not delete the Macros.

About Macros. I do not know much about the languages. I am a Stepper placing and copying things in the process to build a new data set or count things as the game changes. That's why they take so long to run.

The Jav... [ More ]

Reply #20

garyo1954 — Tue, 06 Aug 2019 19:58:43 GMT

Welcome to the thread Cmoore50! Never really thought about that. Not even sure if the draws are televised here. Sad as it sounds, I'll buy a ticket, stick it in the visor and check a bunch at one time. Like one of those get a round tuit things). Here, a person would hear it word of mouth before getting a chance to check the ticket.

The goal was/is to find data that helps Excel (or a program) make intelligent decisions. Its a process of determination more than following the tried and true s... [ More ]

Reply #19

Cmoore50 — Tue, 06 Aug 2019 19:54:22 GMT

Correction..Balls are stacked in from bottom to top 1-14...15-28...29-42...43-56...57-69...So when you're looking at the drum before the balls are dropped. The bottom row would be 1,15,29,43 and 57...Top row would be 14,28,42,56 and 69..last column of balls is one less ball.

Reply #18

AllenB — Tue, 06 Aug 2019 19:37:12 GMT

Nice input Cmoore50. Draw Order is Reality. I Changed that from the Get Go. For simplicity sake, I am trying to get the Blind Squirrel to find the Numbers in Numerical Order. It does limit the numbers that can be in the Positions for a slight advantage. However, given the low success rate Maybe I will Change to Draw Order. I may put that off until I Try to apply the Little Fellow to Super Lotto Plus.

As I contemplate this I see all sorts of new things to track from the Order. Up/Downs, Differ... [ More ]

Reply #17

Cmoore50 — Tue, 06 Aug 2019 13:48:32 GMT

I ve always thought that the first digit that comes out of the drum can dictate what follows. Especially in the powerball drawing. It just seems that those balls mix the least out of all the mixing drums. Watch the mega millions compared to the powerball. Mega million balls seem to mix much more. If you have one column of balls drop just a half a millimeter quicker than the other columns. Just maybe those will get to the center of the drum quicker and be more prone to be drawn. The powerball dru... [ More ]

Reply #16

garyo1954 — Tue, 06 Aug 2019 01:52:31 GMT

Turned out the be a face-plop day. Wrote two different programs for front digit patterns and neither satisfied me. Either too little data, or the data was so spread out, it appeared to be nothing to see.

At this point its a late dinner, a quick shower and bed.

G

Reply #15

AllenB — Mon, 05 Aug 2019 20:42:27 GMT

MrB thanks for the Title. I do spend a lot of time with them but Master might be Stretching it.

Now all I need is a Shirt to put on so that I can Walk among the Crickets. Ever heard a Cricket Grunt? It's Terrifying, but their laugh is hilarious.

Now back to the Training. The Stands are packed with those little buggers. It's the hottest ticket in Cricketville.

Reply #14

Mr-B 216 — Mon, 05 Aug 2019 19:01:11 GMT

Cricket Master, I believe the reason there are no other contributors here may be due to the fact that most here do not use Excel, or even know what a macro is. When I say use I mean using Excel's formulas, formats, and / or macros.

As for me, I am following you here, just no time to compose a post with my thoughts and findings. I have yet to dig into the last PDF you sent me. I hope to have some free time in a couple of weeks, at which time I will look at what you have presented.

Keep doin... [ More ]

Reply #13

garyo1954 — Mon, 05 Aug 2019 16:41:05 GMT

Yes. It was a good talk too! Got some pointers and some ideas. Thanks!

Since 899 people have looked in, I'm guessing there may be only two people talking (on the forum) but plenty listening, taking notes, and watching to see where this goes.

We're stimulating brains as we speak!

G

Reply #12

AllenB — Mon, 05 Aug 2019 16:17:14 GMT

Garyo

Since this has turned into a public conversation between You and Me only, Perhaps we should continue by PM or Email.

No One Else here is interested enough to join the conversation.

Reply #11

AllenB — Mon, 05 Aug 2019 15:39:12 GMT

Pick a Row. Pick a Column.

Do that 5 Time Correct you get the GP.

I can't quite see what to make of the chart, but no matter. Just throw together some formulas for the Selection and Let her Rip.

I may have to rethink naming my System after such a good dog as Sally.

Considering Blind Squirrel

Reply #10

garyo1954 — Mon, 05 Aug 2019 15:11:24 GMT

BOOM! Way to go!

Like I said, you're an echelon above where I am. I went ahead with the idea we IM'ed about and face-plopped my way through several variations of data files until I came up with one I almost liked late last night.

1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

X1N1 33 30 19 15 12 17 13 14 10 10 8 7 3 1 3 3 2 0 4 0 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0

X1N2 0 0 9 11 14 7 15 20 11 14 12 9 12 12 11 10 5 11 6 6 2 5... [ More ]

Reply #9

AllenB — Sun, 04 Aug 2019 18:12:42 GMT

OMG That's Funny GARYO. Hoaxers will tell you that he did not really win, but I believe your version.

Interesting thing about the Inventory Filter, Turns out that there are Often less than 15 Formulas to worry about because many of then produce the same Number.

I just ran Sally through a 1000 Game test trial. Long Way to go. The Only thing I can say is the File Hummed. Unfortunately it made Sally chase her Tail and I saw for the first time what it is like for a dog to switch sides for the... [ More ]

Reply #8

garyo1954 — Sun, 04 Aug 2019 16:42:23 GMT

Oh my! I'm going to need a bigger Labrador!

33k into writing I now see WHY you have 228 formulas!

Baby Steps is good. At the moment I'm teetering to stand upright without face plopping. It appears what you are using is an echelon above the prediction program I wrote a couple of month's ago!

I suspect to face plop a few times before I get a working model.

One small step for lottomaniacs; one giant task to program. Or whatever Neil Armstrong said when won MegaMillions.

G... [ More ]

Reply #7

garyo1954 — Sun, 04 Aug 2019 02:19:21 GMT

Keeps happening.......18 2s in the last 38 draws.....

7 27 2019 2 4 29 31 32

7 27 2019 2 4 17 25 31

7 27 2019 2 12 16 29 35

7 27 2019 2 10 13 32 35

7 27 2019 1 10 20 21 22

7 27 2019 16 17 24 25 30

7 27 2019 8 10 18 24 29

7 27 2019 2 3 14 19 32

7 27 2019 2 7 23 24 27

7 29 2019 3 4 8 9 30

7 29 2019 2 11 15 18 20

7 29 2019 1 5 18 19 30

7 29 2019 2 4 7 10 35

7 29 2019 2 5 16 18 35

7 30 2019 5 12 15 24 34

7 30 2019

Reply #6

garyo1954 — Sun, 04 Aug 2019 01:11:00 GMT

At some point I'm going to have to quit playing around and do some serious work. Been pushing too much to the back burner thinking I'd get caught up and do it, but you know when you start something, it always seems to expand to fill the time you have to do it.

I use between 23 and 40 keys depending on what's happening. But there are a lot more in the program that pares the possibilities down. Doubt its near 228. And sometimes those are too much. And sometimes I wonder why I even bothered w... [ More ]

Reply #5

AllenB — Sat, 03 Aug 2019 22:59:17 GMT

I have been Instructing my Golden Retriever for about a Week. I have now got her up to 228 Commands. There are actually only about 12 Basic Formulas that I do +/- 0 to 10 making 20 iterations of a single formula. I have a 3000 Game History File that tells me when Each Formula Hit and the Formulas that the Hit paired With in the Other Position. The History is not impressive. Only 1 Formula was near break-even. One Formula hit a 5 Spot in Ohio on an Out of State training exercise.

These Formul... [ More ]

Reply #4

garyo1954 — Sat, 03 Aug 2019 21:46:53 GMT

Guilty!

I do the filter backtesting some, with the caveat that it includes a time frame or or draw period when the pattern occurred. Sometimes you discover this great pattern, only to learn it occurred 600 draws back and hasn't occurred since. Yet I'm not sure it would be considered filters. More like key values used to determine if a draw is in the norm or an aberration.

So yeah, I tend to be more concerned with recent patterns. And unless something really stands out, I don't pay at... [ More ]

Reply #3

AllenB — Sat, 03 Aug 2019 18:22:32 GMT

I did not start this Topic as a means of saying Look at Me and My New Golden Retriever. I did it to ask a Question of Members as to how they go from all of the Historical Data to actually picking combinations to play. It really does not matter what program you are running the same Question Applies. At some point you have to act on some statistic or combinations of same to make a selection.

How many of you Do Back Tests with Sets of Filter Values, be they fixed or derived from formulas? Train... [ More ]

Reply #2

AllenB — Thu, 01 Aug 2019 23:48:11 GMT

There are other Breeds just like Dogs.

The Point is to have a Standard Regime for Training.

I have Settled into a Training Regime that puts the Little Guy through a 60 Feature Obstacle Course. Many of those Commands produce the same Number. I keep Track of that. I do this for each Position (in the Macro). At the Same time I run a Filter Mixer using things that I observed when I run the Commands (Formulas) on Binge Watch. The Mixer can be programmed to combine filters based on several facto... [ More ]

Reply #1

garyo1954 — Thu, 01 Aug 2019 22:55:56 GMT

Great idea! I need to do it. I really miss Excel. I should just bite the bullet and get another computer for the CNC.

But I'm not getting a Dick Tracy watch either. Got a phone that stays in my pack most days, sometimes until it discharges. Coolest game on it is that one called Cal-Cu-La-Tor, but I like the pc version better.

Guess I need to set down and do lotto work. Haven't done much but update files in the last week or so.

G

How to Train Your Excel File to Play the Lottery

AllenB — Thu, 01 Aug 2019 19:38:40 GMT

It is not that hard to do but it takes a Macro. Just about any formula can be created and then checked back in the Static Data. You can also Track the Options by themselves in the Static Data but the Columns grow and So does the File Size, eventually becoming to large to function. That is where the Macro comes into use.

The Macro functions by bringing a Game from the history and playing a Value for a Filter Option to see if it hits. With a Positional System in a 5/39 Draw Game 5 Guesses are