Search

Excel VBA - Generate Pairs & Trips to a Text File
1. Create a new folder on your C: Drive and name it Lotto543 (c:\Lotto543) 2. Open Excel and right-click any Tab at the bottom and select ViewCode 3. When the Window opens go to the top Main Menu and select Insert Module 4. Copy and paste the following code into the right workspace where you see the blinking cursor. Sub Generate43C2() Open c:\Lotto543\L543.txt For Output As #1...
Aug 10, 2010, 12:14 pm - winsumloosesum

Excel Sheet: POWERBALL
PowerBall Excel Sheet by DiamondPalace...
Feb 20, 2009, 11:20 pm - diamondpalace

Sure shot system for pick 3 players - Part 2
Continue from the previous post... Ok, there are interests in this system. I'll go into details on how you can make $100 - $200 a month on Pick 3 playing online. Taking real results from GA pick 3, mid eve for the demostrations....
Jan 28, 2009, 3:47 pm - diamondpalace

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

Adding complexity to gain insight
The next round of script modifications will do the following... 1. Create a new function for the last run (the followers of followers level) that does the same thing as the main analysis function, but also writes the statistics and distribution tables to a csv file. Once that works, 2. Nest the entire script inside of a larger function that can be called sequentially on different input csv files. This step is mandatory if I want to do limited back testing...
Dec 3, 2023, 6:25 am - hypersoniq

Tightening the follower skips
Perhaps the skips 1, 2, 3, 7, 14, 21, 28 should be changed to 1, 2, 3, 4, 5, 6, 7. Much like Excel, it is easy in Python to make a copy to experiment with changes. The quick alteration is as simple as changing 144 lines of code using the find/replace 8 times. Will it make a difference? Who knows... As for the future, apparently there exists libraries that can apply time series analysis to string data. That is interesting! I had mentioned that...
Sep 29, 2023, 11:35 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

Update 3-24-2023
Flights through the Twilight Zone sounds Crazy, I know. I might be the first Crazy Person to Dream this up. I think my Excel Addiction got carried away Looping and IFing as I dove into these so called Flight Plans. But something else was happening. Each Flight pro...
Mar 24, 2023, 3:16 pm - AllenB

Mission Completed...R' Main One One...
...AFTER PUNCHING OUT...DETERMINED TO WIN R' BOAT MONEY BACK!!!!!! WE WILL BE DEMONSTRATING SOON...SOME KICK ASS NUMBERS!!!!!!!!!...
Apr 5, 2021, 7:06 am - JENNY8675309lol

Excel Files - Big Game Lotteries - Mega Millions & Power Ball
I created an Excel file (Version 2010) for the Mega Millions Power Ball games. 1 Contains the draw histories of the current matrices for both games 2 Calculates Hits Skips for both the White balls and Bonus balls 3 Sorts Hits, Skips, Digits using the Toolbars https://my.pcloud.com/publink/show?code=XZt7WM7...
Nov 3, 2018, 6:45 am - winsumloosesum