Search

In The Spirit of Sharing : PowerballReply
The above method I have expanded upon to change the statistic in question, usingArithmetic Mean =INT(AVERAGE(C2:C101))Median =INT(MEDIAN(C2:C101))Geometric Mean =INT(GEOMEAN(C2:C101))Harmonic Mean =INT(HARMEAN(C2:C101))Note the use of the INT function, this is to ensure we remain working with only Whole Numbers (Integers)... you won't find 35.6 on any bet slip for the PB! We didn't need it above because MODE only returns values in the list, which are already whole numbers.
Dec 7, 2003, 12:27 pm - hypersoniq - Jackpot Games Forum

Power Mega Balls with Three Sum MathReply
My fault for not checking further. These files already have the new CombNexus and DisimulateNexus functions. http://www.jadexcode.com/files/excel/threesums-02.xlsm or ftp://www.jadexcode.com/excel/threesums-02.xlsm However, we need to change the Powerball Unbounded CombNexus usage from CombNexus(59, 5, C, N0, N1) to CombNexus(69, 5, C, N0, N1) and CombNexus(35, 1, C, N0, N1) to CombNexus(26, 1, C, N0, N1) then remake the frequency chart.
Jan 8, 2016, 2:32 pm - JADELottery - Mathematics Forum

Use of Excel by a newbie learning Gail Howard's system
Hello folks, I just joined LP and have read a lot of fascinating stuff on the forums. I'd like to make life easier analyzing lotto data while using Gail Howard's software and books, and hoped Excel would help. I would appreciate any suggestions on how to do that. I'm currently using a one page paper worksheet I put together. But Excel should help me analyze stuff like frequency of skips, etc ., and maybe do my worksheet too. Any suggestions and comments will be appreciated. Good luck t
Nov 19, 2010, 12:52 pm - chilibill - Lottery Systems Forum

help with Excel!
can anyone help me with 2 problems 1) if cell A has 638 which formula can I use to sort it (368) 2) how would you figure out longest day out for a number in excel. (not frequency how many time it was drawn) but how long has it been since last drawn. thanks Jim
May 3, 2009, 1:45 am - jm6256 - Lottery Systems Forum

(Poll) Converting numbers from the web to ExcelReply
Quote: Originally posted by Just6ntlc on July 9, 2006 Rip Snorter, my vote is yes. I think you can convert numbers into Excel. I have some lotto history from CA SLP, Washington Lotto Plus, Texas Lotto with Bonus Ball, Powerball, and Mega Millions in my word document. I have their frequency recorded on Excel. Sounds as though you might be on a similar track to one that's intrigued me, on and off. Those bonus balls surely do some wierd things, eh? You've just given me an idea I don't beli
Jul 9, 2006, 6:54 am - Rip Snorter - Lottery Discussion Forum

Open Discussion: Define/Refine PredictionReply
Quote: Originally posted by WIN D on November 30, 2003 Hyper....wish you would describe this some more ....sounds interesting.ok, start off with your entire history in columns (1st ball, 2nd ball, 3rd ball)beneath the list, I put the excel formula=MODE(A2:A9100) ' for example... A2 because of the header row and 9100 represents the end of the history listnow just autofill left and you have the mode for each position. I keep the number side by side in 2 formats, one is each number in posi
Nov 30, 2003, 2:30 pm - hypersoniq - Pick 3 Forum

New Excel Spreadsheet for Pick3!Reply
ok,Well let's see if I can answer your questions. First this notion that this is in some ways cashos system.Not it in no way resembles a hot sheet rather it takes a statisical aat pick3 patterns..Basicly I went at it with the following approach then you guys can decide as 1 member mentioned he's right you cannot properly protect an excel file...the so called security features inside excel are very limited and anyone with a good knowledge can crack them...Ok..first we all know there are 1000 comb
May 26, 2003, 8:01 pm - troyn - Pick 3 Forum

Lottery Game PercentagesReply
hello=hyper= ### **Explanatory Diagram Cash4Life 5/60 Strategy** #### **1 Game Matrix (structural basis)** * Create a 5x60 matrix (5 positions 60 numbers). * Each position represents the order of the drawn numbers (Position 1 Position 5). * Insert historical results (minimum 100 200 draws). ``` P1 | P2 | P3 | P4 | P5 ----------------------- 12 | 18 | 25 | 37 | 42 03 | 09 | 22 | 34 | 56 ... ``` --- #### **2 Calculation of percentages per position*
Nov 12, 2025, 5:21 am - dr san - Lottery Discussion Forum

What are some of the systems players are using?Reply
I develop my own systems. Yet to find a consistent one. I started over 20 years ago with Excel spreadsheets and have since moved on to Python scripts. The most important thing I do with systems is also create a strict budget. I also only play one combo per game. @$14 per week, that means either day and night pick 3, day and night pick 5 or PA Match 6 (all cost $2 per day). I looked at darn near everything over the years. Right now I have shifted from individual numbers into analyzing frequen
Nov 18, 2025, 1:50 pm - hypersoniq - Lottery Systems Forum

Lottery Analysis Tools .Reply
@hypersoniq Thanks for breaking down the sample sizes like that, just what I was looking for. 150 draws for pick 3 seems reasonable. I also think you're right about not over complicating things. I'm definitely more of an Excel guy, but I have another project that I am working on that requires PostgreSQL, so I am already working with it. And since I play lotto, I thought this would be a good way to learn. @dr san For now i'm just focusing on tracking frequency and delays in
Sep 7, 2025, 4:49 pm - LottoVibes - Lottery Discussion Forum