The spreadsheet went together in about 10 minutes

Published:

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.

Entry #559

Comments

Avatar hypersoniq -
#1
As with any undertaking using windows, I have to descend into ODBC driver hell to make a simple connection for the LextEdit to perform SQL queries on excel sheets... Need to install drivers for version 16 Excel (O365) and the highest the system shows is version 12...
I still have plenty to explore in Excel as I recently installed power pivot and DAX (Data Analysis Expressions) integration.
Avatar hypersoniq -
#2
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.

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