/blogentry/185884 hypersoniq's Blog: History not updated since 4/21... en-us Lottery Post RSS Generator /blogentry/185884#c265483 /blogentry/185884#c265483 Sat, 03 Aug 2024 04:22:28 GMT hypersoniq Started modifying the python script and encountered an error with pandas accepting tuples as inputs, that is data in toe form of (1, 45). Should be able to fix that but ran out of time before the next work stretch...

]]> hypersoniq /blogentry/185884 /blogentry/185884 Fri, 02 Aug 2024 03:52:16 GMT hypersoniq Did not realize the hiatus was over 100 days! Last update on the data sets was April 21.

Spreadsheets are fully producing correct results and being updated. Funny how a typo on a lookup table can replicate like wildfire... with that correction the data validation (random sampling to detect the correct vector) is also complete.

During the development of the last spreadsheet for a system, I started making a text file that holds the more complex formulas for each sheet. That enabled reworking the sheets in just a few hours. (Validation is boring and long, but an absolute requirement)

Pre calculating the vectors in a lookup table reduced the complex INDEX formula to just one per sheet. Anchoring the lookup table reference allows this one formula to be populated with auto fill.

Should finish the updates by tomorrow and get a first look at what needs to be changed to run through the follower program to get vector distributions.... [ More ]

]]> Blog Entry hypersoniq https://www.lotterypost.com/blogentry/185884