even though these need to be updated regularly I think they should be in here too
pick 3 and 4 thanksgiving treat
Pick 3 History based on skips of all 1000 numbers.
This is an All States draw history in the order the draws occurred by time of day and state.
Here is the download link to the folder containing 2 Excel files:
https://app.box.com/s/0ztiy7irn6nwgd4yjt62
Instructions:
Excel Versions 2007, 2010, 2013
Create a new folder and name the folder anything you want. Example, Pick3AllStates
Download the 2 Excel files into the new folder
Open the Excel file P3StateDrawsLS.xlsm
You should see a window open asking you to change the date. Just close the window.
This Excel file has all the draw histories of each Pick 3 game by state.
I will update this Excel file each day and upload it to the same download folder listed above.
With the P3StateDrawsLS.xlsm Excel file open, click File > Open and browse to the folder you created above and select the 2nd Excel file Pick3LastHit.xlsm
Click the Tab at the bottom labeled "1000Sets"
In this tab you can filter the sets by skips. Currently I have it set in column T to give me the Minimum skip of all 1000 sets by Triple, Double, and No-Match
For example, notice the 6-way 034 which consists of 034, 043, 304, 340, 403, 430
The minimum skip in column T is currently at 1055 or 1055 draws ago. It last hit in Missouri Midday 340 on November 11, 2014
This is the list that I filtered using a min of 1000 skips:
444
555
666
366 636 663
558 585 855
799 979 997
019 091 109 190 901 910
034 043 304 340 403 430
The triple 666 is the longest out trip last hitting in Kansas evening on October 21 , 2014
The doubles sets of 558 which includes 585 and 855 have not hit since November 10 2014 in South Carolina Evening
The no-match 034 (see above)
If you just want to sort by longest out skip use only column U.
The longest out Pick 3 numbers are 450 (7268 skips) last drawn on August 11 2014 Texas Midday and 708 last drawn on August 13, 2014 Tennessee Midday
OK Guys and Gals,
Here is the Pick 4 version similar to the Pick 3 posted a couple days ago.
Download link to the folder containing 3 Excel files:
https://app.box.com/s/b2zqz3yn42b2vzhcpkhk
Instead of writing instructions I will put together a video on how to use the 3 Excel files.
Place all 3 Excel files into a new folder. Name the folder anything you want.
Here are the top 15 longest out sets:
0000
2222
3333
4444
5555
6666
9999
0999 9099 9909 9990
1888 8188 8818 8881
2333 3233 3323 3332
3777 7377 7737 7773
4446 4464 4644 6444
6667 6676 6766 7666
0055 0505 0550 5005 5050 5500
5588 5858 5885 8558 8585 8855
Next time I will take the longest out from the following:
Quads (3)
Double-Double (3)
Trips (3)
Doubles (3)
No-Match (24 way) (3)