History not updated since 4/21...

Published:

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.

Entry #309

Comments

Avatar hypersoniq -
#1
Spreadsheets done! Updates done!
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...

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register