Comment #2

hypersoniq — Sat, 13 Dec 2025 05:03:28 GMT

The combination of horizontal and vertical sums may be somewhat of a puzzle that will require frequency data as a part, but not the only component of a solution. This is looking to be a "calculate every day you play" type situation.

Comment #1

hypersoniq — Wed, 03 Dec 2025 22:14:54 GMT

I still have plenty to explore in Excel as I recently installed power pivot and DAX (Data Analysis Expressions) integration.

Original Blog Entry: The spreadsheet went together in about 10 minutes

hypersoniq — Wed, 03 Dec 2025 16:02:41 GMT

Starting as always with the pick 3 evening data. Interpretation will take MUCH longer. Having the plan in the previous post was helpful.

The summation of the vertical sum when compared to the lead in sum is a simple subtraction of the horizontal sum from the vertical sums, but it was kept in to see where the numbers come from.

Ranges:

Hsum is 0 to 27

Vsum in each column is also 0 to 27

Sum of vsums is 0 to 81

Lead in vsums are 0 to 18

Sum of lead in vsums is 0 to 54

There is much more to do, such as distribution and figuring it all out... but the concept for the current data was mere minutes to put together.

I am going to try some software called LextEdit, which allows running straight up SQL queries on data sources such as excel sheets and csv files... that could prove interesting at creating good views of the data with the full power of SQL.

It is definitely more of a back burner project as I continue to navigate the Python GUI world. The basic start at seeing if it is useful will to grab random sets of 4 consecutive draws and see if the data exists in the first 3 to arrive at the fourth. It may or may not... the randomness is still there.... [ More ]