Pick 3 - "Runaway Pairs"
I posted this back in 2016 in the following thread:
https://www.lotterypost.com/thread/301001
Links to Excel files: Updated drawings through Thursday, August 2, 2018
(3) Excel files (Version 2010)
(1) P3StateDraws.xlsm
https://my.pcloud.com/publink/show?code=XZRqBW7ZvHAMp1vMhDJlPdWI9ABSbSTPYFV7
(2) Step1.xlsm
https://my.pcloud.com/publink/show?code=XZuqBW7ZMB053AHM91Vt6Qm1m5Rweun33gEy
(3) Step2.xlsm
https://my.pcloud.com/publink/show?code=XZ2qBW7ZFaRuVmyUrhuBgW5sst4zDLNBBfS7
Optional Program:
This is Paurths (Ricky) small program used to create Pick 3 sets from Pairs.
1>Create a new folder and name the folder whatever you like.
2>Download the following zip file and save it to the folder created above
https://my.pcloud.com/publink/show?code=XZztBW7Znw7rOdIAMaVsV4horhDR67e8uIOk
3>Unzip the exe file into your new folder.
I posted instructions on how to use this program in the thread at the beginning of the BLOG.
Note: The only Excel file you really need is Step2xlsm which contains all the final "Pairs" calculations.
The Excel file Step2.xlsm calculates all Pick 3 games looking for "6-way" (No-Match) sets. Each Pick 3 set of course has 3 pairs (Front, Back, and Side).
The calculations check each set and see if any of the 1 of 3 Pairs have hit since the Pick 3 set was initially drawn.