Search

excel for keno
looking for an excl type program to enter keno numbers and formulate winning pick draws. I fanyone has come across one please list your findings here. Would appreciate any info. thanks
Mar 20, 2006, 3:48 pm - retxx - Lottery Systems Forum

Short Cut System for Pick 6Reply
Thanks for the encouragement Blackapple! One thing I've noticed with this little system is that often a digit that is missing comes out in the winning#'s. In my workout, you notice there is no number 9. If I had thought to play 9 or 19, that would have been the jackpot! Oh well, I'll keep trying. I may try to backtest this using excel. Unfortunately I'm not very good or fast at excel, so it may take time.
Jan 30, 2006, 4:07 pm - dynodyno - Lottery Systems Forum

Excel Formula for Counting Skips
This formula will count the skips between digits. B col is pos 1 ; H col is going down; I col, going across.CarbobConfirmed with Shift+Ctrl+Enter =MATCH(TRUE,($B$11:$B$953=$H37)*($B$12:$B$954=I$36)>0,0)-1 POS 101234567890433549016793368532411771332622155657613478215271371536112362081101368380517219129483721404838460472011598658210554275116929642710135156645341112785743732938667108211435631691481704972852391943385088303191967010679571927371274102
Jan 28, 2006, 7:02 pm - CARBOB - Lottery Discussion Forum

January list- times hit & notReply
Tenaj, you probably have a program that does this (but it's not the same program) as I put this spreadsheet together myself using the =sum(countif(... feature in excel. I am becoming quite the wiz with excel. (not great, but I can make it do the simple things that I want
Jan 22, 2006, 10:04 pm - lottaloot - Pick 3 Forum

need help from the excel gurus...
I am trying to find some way of getting a line to draw on a worksheet connecting numbers in a range based on the results of a cellfor example,cell A1 contains 5... cells B1-L1 contain 0-9Cell A2 contains 8... Cells B2-L2 contain 0-9I want to insert a line that has one endpoint centered in the cell G1 and the other endpoint in the cell J2I would like to automate chief's bell curve concept by adding lines
Jan 22, 2006, 2:58 pm - hypersoniq - Lottery Systems Forum

Excel Help
I need a formula that I can put into a cell in a chart that will add +1 to any number. Can anyone help?
Jan 22, 2006, 2:06 pm - Littleoldlady - Lottery Discussion Forum

what does a prediction formula look like?Reply
I didn't know you could put AI modules in Excel or write one using Excel. I would have thought that rather than just being a sliding average it would have produced or suggested an action based on historical data.
Jan 19, 2006, 12:07 pm - RJOh - Mathematics Forum

need help with missouri pick 4Reply
First start out with a minimum of a 5 year history file of past drawings. You will want to see if you notice long term and short term trends. Put the history in excel. I have a few good strategies for picking straight numbers, but you need the data in excel first to get the clear picture. Are you familiar with the 3 digit sum chart and the ranges associated with it? Let me know if your not, I can email it to you.
Jan 17, 2006, 12:22 pm - megatron - Pick 4 Forum

Excel formula's....help neededReply
Hi time treat,What is the purpose of the ctrl +shift + enter sequence? Never used that one. Mainly it's for a array formula or from what I can see when you make formula on your own that is not in excel you have to hit these 3 keys to make excel accept it.Check out the link that was given it explain what it means.PP
Jan 15, 2006, 3:49 am - powerplayer - Lottery Discussion Forum

Need excel formula
I want to count how many times a digit fell......Cells B2,B3,B4 are the individual digits cellsthru Row 8preferable sorted with the most hit digits first..........Hypersoniq or WSLS help!!!!!!!The idea is to take 7 days of draws, which would be 42 digits and find out which ones hit the most in a sorted list.
Jan 14, 2006, 8:49 am - Sandy K - Lottery Discussion Forum