Using Excel to help select Lotto numbers.....

**farmerTom** · 04-17-2007, 12:32 AM

I live in Phoenix and occasionally loose money on the lottery.

Its not that I'm that bent on winning, I like to play because I believe that
I can greatly increase my odds by numerical analysis. Here's some programs I grabbed off the web that I'm using (they are free). Why I'm here I think using
Excel to perform conditional checks, search/compare functions, and create list of number/combinations/sets of numbers so I can narrow down the playing field. I play an Arizona game called Pick5; there are five numbers (columns) in a range of 1-35. Easy game, good odds to win. There are no wild card numbers... they make the game to complex. The game is played 6 times a week so a lot of numbers are cycled through quite quickly; that makes the game a little more interesting.

I'm interested in exchanging ideas and functions pertaining Excel in use for Lottery number selection. Below is a list of programs and where I got them from that I'm using for the more complex analytic functions. I then take the data I get from them and enter that into Excel to reduce that data into a five numbers a day for my ticket purchase.

I mainly use this program to point out numbers that are lagging, need to learn more about his filters.
MDIEditor And Lotto WE 4.0 WE:
http://www.download.com/Ion-Saliu/32...4-6271393.html
I've just started tonight to look at take the data from this program pertaining the number skips and will start to make some conditional filtering for my number selection.

I use this program to look at number trends and to generate lotto numbers I import into Excel to run conditional test on.
Giga 6.5 >>> at their main site you can get vers.# 7.3.1 > http://www.lottery-analyst.com/ <
http://www.download.com/Lottery-****...4-6278512.html
This program generates 100 numbers at a time that is run through some built in filters that are more likely to come up. What I'm doing with this is
generating several hundred numbers 100 per column and comparing the columns for matches. Thinking that the number sets that make it through more than once are "good ones".

Here's the function that does the column comparing:
=IF(COUNTIF($A$1:$A$100,B1)>0,B1,"")
I put 100 numbers in column A and 100 numbers in column B and this function in column C for 100 rows. If I add another 100 numbers in column D I then put
this function =IF(COUNTIF($A$1:$A$100,D1)>0,D1,"") in column E for 100 rows, and this function =IF(COUNTIF($B$1:$B$100,D1)>0,D1,"") in column F for 100 rows. etc. etc. etc...

I'll add to this as time goes on and will share more with anyone interested. Tonight was my first go at this using this software and Excel spreadsheet so my number selection wasn’t a real good one, but it at least I had a little control over my odds.

Tom

P.S.
Anyone in AZ that needs the number list for the past 180 days (that's all I have) tell me and I'll post them in a format that imports easily into these programs, and Excel of course!

**farmerTom** · 04-21-2007, 07:40 PM

Here' what I have so far. I need to fix the functions so they are bound by a placement not a cell. When I'm done this will be a very large .xls I still have a lot of ideas about number selection.
I will be adding an even/odd checker for the numbers columns (B,C,D,E,F) and think that a prime checker may be important as well, there are 12 primes between 1 & 35. Then I really need a section that "weighs" it all in [Ranking].

I didn't comment or title any of the functions as I plan on remaking this as time goes on and I add more conditional info gathering systems. Ask if you download and I'll tell ya what I'm "trying" to do. Any input would be great, and I am not making a commercial product.

Free to use and improve, if its used by someone in a commercial venture... remember me uploading this is considered "published". I think profits for the state lotteries should go to the states, they spend it well, I just want to win more often.

P.S. These numbers are current to 4/20/07.

This is an image of the decision struct I'm trying to make on a per column basis.
http://server6.theimagehosting.com/i...lottoCol01.jpg

**farmerTom** · 04-21-2007, 10:35 PM

Eventually I would like to be able to create enough filters and a ranking system so I could port the spread sheet through this program > http://www.xcelsius.com/index.html
then find someone to host it on the web.

The nice thing about this is you could a slider for each column to select a number with the greatest "potential" and the page would dynamically reflect that in real time.

**farmerTom** · 04-22-2007, 12:58 PM

Here are the conditions that make up my lotto number selection.....

1) Odd or Even nice pointer for final number selection.
2) Number of times drawn in this column. Local hits.
3) Total number of times drawn. Global hits.
4) Deviation from the columns average.
5) Skips...I use MDIEditor And Lotto WE to generate statistics for the numbers I enter. Skips is how many times that number hasn't been drawn. I want to eventually put this funtion in my spread sheet on a per column basis.
6) Steps is the sum of 2 consectuative columns.... [B1+C1 = ] [C1+D1 = ] [D1+E1 = ] [E1+F1 = ]this is a good way to look for clustering and a great pointer for finale number selection. I compare the number with the average to get a pointer where the next 2 numbers sums may be.
7) Range, average, popular range for each column.

I want to also include a prime number pointer that shows skips, and hits per column..... there are 12 primes in the range of 1-35... and only one is an even number.

Once I get all the conditions set, I want to "rank" or prioritize the various conditions so they return a value called "weight". The weight value will be assigned to a number then I'll sort all the possible numbers by the weight value. Then I'll be able to check the conditions of numbers I want to select using Crystal Xcelsius dynamic tools and charts..... with the dynamic sliders/charts/gauges/dials online anyone will be able to "test" their number selection for that particular lottery game. I think it'll work???????

**kmohan1962** · 07-24-2011, 10:10 AM

Hi Tom!

It's great to find you in this greatest excel forum! Yes! I do research in lotto games for more than a decade for 649 games specifically and for all lotto games in common. I've developed a simple spreadsheet for a novice lotto player to play the game smart! Just I've uploaded my file at http://free.lotto649.ws/LottoManiac6...-Canada649.zip. If you're interested it can be modified for your favourite game! Also, I've embeded this excel sheet with its full functionality at <iframe src="http://r.office.microsoft.com/r/rlidExcelEmbed?su=5455323543535607345&Fi=SD4BB533DBFB43DE31!107&AllowInteractivity=True" &AllowTyping=True&activecell=smartpick!a35"width="402" height="450" frameborder="0" scrolling="no. Hope, every smart lotto player find this one helpful.
Wish you goodluck!

**Cookstein2** · 07-25-2011, 02:49 PM

How does the lottery work in the US? a lottery is a lottery? surely the best advice kmohan gave you was the "Wish you goodluck!" at the end, because that's all it is....luck

the probability of getting 1,2,3,4,5,6 is as high as getting 6,12, 26, 28, 33,42....

**MrRichardD** · 10-15-2018, 05:09 AM

Hello to you all,Im glad to be here,And I realy like the work farmerTom had been doing,even thoe its out of date,as of the time of this Post,but im glad someone sees things in a different light,wish more people did,