Search

Help With Excel
Any Excel experts out there? How do you use vlookup to check if a day is a holiday? Thanks....
Oct 31, 2007, 5:25 am - Tinker

Finally figured out backtesting of PRO-File...
Going to backtest profile by making it a database in Access, then I can gather info by date-range and see if the stats available at the time before the next to the last draw indicated the winning number in any way... that will allow fine-tuning nad help point to the important metrics... hopefully. wonder if I can recall how to spit query outputs to an excel sheet for analysis......
Aug 10, 2007, 8:17 am - hypersoniq

PROfile out... LoopRS in...
Next system in full swing LoopRS= Latent out-of-position Repeating Sequences (or schedule, or any other S word that makes sense) What this does is hunts for repeats, even out-of-position ones. For example, 12 is WB1 in one draw then comes back as WB2 in the next draw. My old format excel programs would miss this. When I tire of LoopRS, I shall keep the engine and revisit my old stat systems with this new backtest ability. right now, I have a test sheet for Powerball, a...
Apr 6, 2007, 7:22 pm - hypersoniq

Dead_Aim's Plays P4
I just finished the singles part of the Pick 4 excel sheet I have been working on. I will include doubles at a later time if it looks like the charts are doing well. I will update all of the Pick 4 files tomorrow and then post in the evening hours. The header will be Dead_Aim's Plays P4 . Many winners to you....
Mar 3, 2007, 9:24 pm - Dead_Aim

Lottery Prediction method for 6/49
In my everquest searching for lottery prediction methods I came across an Excel sheet created by someone at another lottery message board. Visit this thread Haven't tested it. I need to alter it to make it work for a 6/48 lottery first....
Jan 6, 2007, 8:37 pm - MillionsWanted

Better Pasting from Excel
I have updated Lottery Post's rich text editor so that it handles tables much better. The biggest impact is much better support for pasting from Excel. The original cell colors, borders, and styles and maintained to a much better degree....
May 28, 2005, 12:35 am - Todd

Nel's Method
I have had a naive, yet novel idea over some months and need to let it off my chest. Since I began wondering how random numbers work, I decided to check them out. So, over many months' deliberating, I came to the conclusion that randomness may exist but since we have the databases available, then my idea would be to use these pseudo-random numbers to best estimate and predict my megamillion winners. Later on, I ventured into checking out other lotteries, with six and fivers....
Apr 16, 2014, 3:32 pm - nelson1

Learn Excel - Udemy FREE Course Limited Time
Excel 2007/2010/2013 For a limited time you can register at www.udemy.com for this free excel course today. Use this link: https://www.udemy.com/excela2z/ Over 112 lectures and 8.5 hours of content! An In-depth excel tutorial From basics of wri...
Feb 22, 2014, 10:04 am - winsumloosesum

Followers update
Working with Python has been a bit easier than trying monster excel formulas for sure. The current project gives me the entire list of followers for the last number drawn, including a count of the followers for that number, and the most recent 1% to allow a visual of recent trends. Then added a mode for the trends list to make a quick pick . Because I have always looked at the pick 3 as 3 separate games of 1 in 10, this lends itself to coding that is able to be used...
Aug 9, 2023, 12:01 pm - hypersoniq

RickG Pick 3 System Updated
By request. Updated the 2 Excel files from original post from 2013 https://1drv.ms/u/s!AifgvyqwTTMrh0bO5splu1tF72ZO Download zip Create new folder. Name it whatever you like. Example RickGPick3 Unzip 2 Excel files (2010) into new folder Watch video....
Sep 18, 2017, 10:36 pm - winsumloosesum