Search

Search the Lottery Post blogs for the keyword(s) you specify

BlogsResults 1 - 10 of 15 for Excel + frequency. (0.01 seconds)

Basically 8 Days in Fantasy 5 Land-all at once-Going Back in Time
Basically, to its own Basic? The word basically is a great word, in my opinion. I believe that you should only use the word to describe a noun or with an adverb when de...
Jun 15, 2018, 7:54 pm - AllenB

new (to me) hypothesis...
Everything in nature is trying to find balance, from us as people to the cells inside of us to the atoms everywhere... I'm stuck on LoopRS development now, but the next one on the back burner will be based on the concept of Homeostasis perhaps instead of looking for the most frequent or least likely we should be seeing what draw results will tend to balance out the draw frequency... I didn't ditch PROfile, because there is much valuable data there tha...
Apr 10, 2007, 11:22 pm - hypersoniq

P3/P4 was fun, but...
May proving to be a tough month. Only hits so far are for $1 on Cash5 twice. June is shaping up to just include Cash5/Match6/Powerball only... Drops total test cost to $66 (Down from $186 to include the P3/P4 Mid/Eve)... But may is not over yet... TONS of testing done tonight... Definitely ruling out LoopRS in favor of LRS for ALL games. Next tests up for P3 will be the classic 111 workout, but only one number results and it's added to LRS pix, not straight draw history...
May 19, 2007, 12:17 am - hypersoniq

How I used an incorrect back test on followers...
My followers script itself is well over a year old. When I originally ran the first back test, it was 100% within Excel. The idea was simple, loop the script with each digit as the last draw so I would know the top follower of each digit in each position, put these into a lookup table, and count the number of straight hits. Of all possible replacement strategies, this one performed best, meaning at the time, it almost returned enough straight hits to make the i...
Jan 21, 2026, 7:52 am - hypersoniq

First Steps with a new system: Taking Notes...
As I delve back into Excel system creation, I am trying to get better results than the dozens of previous attempts by keeping track of more details. Thistime I am using dated Post-Draw notes to get in depth as to where things went right and wrong. Mostly it's a way to capture a copy of ideas before I forget them. Below is my first entry for the PROfile Powerball system I am working on... PRO-file Predictive Decision System Failure Analysis for 2/7/2007 (wed....
Feb 8, 2007, 8:03 pm - hypersoniq

Powerball stat hunt gearing up
My one pick system is an ever evolving nightmare of calculations and continuity challenges... there are now 3 worksheets in one excel workbook feeeding the final pick. The number is an averaged composite of 10 individual picks (Short term and Long term).... today I conquered the pesky backtest normulae only to be unimpressed with the results... I have generated error corrections like mad, don't know what stage to apply them... I am currently running 2 backtest scenarios side by side t...
Jun 13, 2004, 7:55 pm - hypersoniq

Working on the vector scripts today
The excel part is done, validated and correctly functioning. The visualization part has some work to go, and the follower script mods are finally launching, but I have to play the squash the bugs game. Since the data analysis part is what is needed to start testing I am focusing time there. Also tying in reading data from the PA Lottery RSS feed to automate updates, that one I might collaborate with AI to rapidly develop... Using time otherw...
Aug 17, 2024, 10:30 am - hypersoniq

Calibrating the new script with the pick 3
The process will be to generate picks for both the mid day and evening PA pick 3. This is paper play (no tickets bought) and the new draws will be the targets. Adjusting the number of recent draws to capture with the goal being the lowest number of draws needed to pick correctly. Box hits do not count, as if the numbers come up boxed, the result was still wrong. The draw databases will NOT be updated until the system is calibrated for today's results. This process may...
Aug 20, 2023, 10:04 am - hypersoniq

Merging visible trends?
in the white balls with my system, the last 6 draws, of the 30 white balls picked, only 5 were 10 or more off... 15 were within 4, and of those, 4 were off by one. what does it all mean? I don't know... my average is 6 away frm the right numbers (actually 5.7) powerball however is not doing as well... I miss the PB by an average of 13 (13.3) My charts may help... before, I was left with a blank row to guess the number... now I could use the generated pick as a possible...
Jul 1, 2004, 7:56 pm - hypersoniq

Some of the odder spreadsheets I have made
The one that jumps out first is the one that imagines the draw to draw differences by position onto a grid, measuring both the angle (positive or negative) and the line length to connect those points. I honestly had no idea what was going to be done next... but it was a valuable lesson in using the index/match formula. The angles and line lengths were pre calculated from every pair from 0-0 to 9-9. A lookup table was created, but instead of using Xlookup I went with index/match. Tur...
Nov 3, 2025, 9:41 am - hypersoniq

Page 1 of 2