Original Blog Entry: Today's challenge... integrate the remaining vector data...

hypersoniq — Tue, 17 Sep 2024 12:59:55 GMT

Angles are in place. They sit beside the normal draw history. Today adding the line lengths that are a part of the vectors. (Vector = angle and line length).

The distribution will differ from the angles as there are 19 possible angles (counting negatives) but only 10 possible line lengths, as these are positive only. And though they are equal in number to the actual digits, they are predicted to have a more logarithmic distribution than the raw draw data, as they maintain a many to many relationship like the angles do...

Length of 1 could be any repeat, for example.

Hopefully this makes it possible to narrow down a pick to the cumulative score on the distribution lists that do not exceed the constraints.

The process is time consuming, but not very difficult. For the pick 3...

1. Add 3 columns that will hold the new data

2. Add a column to the lookup table beside the angles

3. Enter a formula in the new columns that will look up the line lengths

4. Prepare the data on a new worksheet by paste special_values only

5. Export this hybrid worksheet to a .csv file.

Since I have decided to skip the pick 2 and pick 4, this only involves modifying and updating 4 sheets. P3 Mid and Eve and P5 Mid and Eve.

The follower script does not even need a single modification, as it is flexible in how it reads the data.

It is more a prep for future development, but also falls into that category of at least I tried everything I could think of.... [ More ]