https://www.dropbox.com/s/5eeqzdwpflrc5my/AllStatesDraws.xlsm?dl=0
Pick 3 "All States" Excel file
Instructions:
1> Update Draws to LP Tab (Copy and Paste)
2 > Click tab labeled "AllStatesDraws". Change the date in cell D16 to the date of the drawings you are updating
3> Click the Toolbar(s) that correspond to what days' drawings you are updating. For example, today is Saturday, Feb 13, 2016. I would click the toolbar labeled "Click to Add Monday - Saturday Midday Drawings" 1st (cell range H2:N4)
I would click the toolbar labeled "Click to Add Monday - Saturday Evening Drawings" 2nd (cell range H7:N9)
4> Click tab labeled 1000Sets
> Click cell C1 > Select "NM" or "D" "NM" = 6-way sets, "D" = Doubles, "T" = Triples
Example> I selected "NM" for 6-way "No-Match" sets to filter
I click cell J1 and select the 20 highest values at the bottom of the list. These are the 6-way sets that have not hit or the longes out.
Note: These sets are based on using the entire draw histories of most Pick 3 Morning, Midday, Evening, Nite games in the order/time of day they are actually draws. So for example, the longest out 6-way is 128 at 5867 skips.
The 128 was drawn Missouri midday Nov 17 2015 and has not hit since. Which is approximately 87 days.
These "6-way" straight sets would be to 20 longest out:
6-way skip
013 4035
052 4632
127 4936
128 5867
135 3726
157 3469
174 3526
213 3849
291 3450
390 4086
516 5406
582 4061
589 3868
625 4275
627 3767
783 3780
786 4205
816 3443
910 5020
921 3470
5> After all the Morning/Midday draws are completed you can see what numbers hit. Copy and paste the draws to the LP tab then re-calculate again using the steps above but only clicking the Midday toolbar for Monday - Saturday.
Good Luck!!