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.