Interesting idea when displaying the pick 3 data...

Published:

Updated:

So, the concept is known as "multi-level" sorting. It is in spreadsheets under sort where you can apply a sort criteria, then apply a second sort criteria, such as the "then by" fields in Microsoft Excel.

As it stands now, my display is sorted by the digits 0 through 9, so I have to go back to the left column to see which digit the output is describing. These are buffered in a list so that when the function is done, it can display the rows side by side.

I would rather sort by multi level criteria, such that 

1. Data is sorted descending by frequency

Then

2. Sorted by draws out ascending.

The changes I have to make involve first including the digits 0 to 9 in the output columns instead of a stand alone header column. Then, multi level sorts are created backwards...

1. Sort by last draw out (ascending) 

2. Sort by frequency (descending)

This lines up the numbers first by frequency large to small, but where frequency is the same, they are sub sorted by number of draws out from small to large.

It is a pain to do that by hand on paper, and has to be done in multiple sheets to get it right on a spreadsheet... so why not build it directly into the code?

The goal... have each column going from Hots on top to colds on the bottom... the neutrals will line up in the middle and a whole row can be selected... one that lines up all neutrals...

If there are an odd number of rows that contain all neutrals, pick the one in the middle... if there are an even number of all neutral lines, pick between the two at the middle, using the lowest sum of last draw out.

Since it is paper play, the numbers selected using this method for the next 2 weeks (starting yesterday, when the list was written out, so they are current for the next 12 mid day and next 13 eve)

The picks for the next 12 draws are as follows...

PA mid day pick 3 = 690

PA evening pick 3 = 537

So, if those combos appear from today to Wednesday 10/8, then the paper pick test worked. Remember, there is a far greater chance that they appear because I am NOT playing them... but the budget has me on my 2nd week of 4 for the Match 6. That means for the better part of 3 weeks I have time to plan, test and implement these changes into the Pick N script.

I will NOT be paper playing the Match 6 however...

Entry #508

Comments

Avatar hypersoniq -
#1
Adding the draw digits to each column was easy, next session I will work on the multi level sorting part.

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