|Posted: September 4, 2015, 12:28 pm - IP Logged|
Updated the Pick 3 "5-Digit" and "6-Digit" Strings Excel files.
Download link to the zip file:
Create a new folder and name it whatever you like. Example, Pick3Strings
Download the zip file from the link above and unzip the 3 Excel files into your new folder.
Open the P3StateDraws.xlsm file 1st and leave open
Go to the Main Menu and select File > Open and browse to the folder where you unzipped the Excel files and open the Excel file
I already ran the calculations for Midday, Evening, and Combined draws. See screen shots below:
See Tabs "StringStatsMidday", "StringStatsEvening", "StringStatsCombined"
In the screen shot above for the Midday draws cell rows G & J contain the 2 longest running "6 Digit Strings" and in cell rows Q & T for the "5 Digit Strings".
For example, in cell G4 the "6-Digit String" of 1,2,4,5,7,9 has a value of 92 in cell H4. The 92 is how many consecutive drawing at least 1 digit from the string 1,2,4,5,7,9 has appeared in the Tennessee Morning Pick 3 drawings.
In cell J4 the "6-Digit String" of 0,2,6,7,8,9 has a value of 88 in cell K4. The 88 is how many consecutive drawing at least 1 digit from the string 0,2,6,7,8,9 has appeared in the Tennessee Morning Pick 3 drawings.
The "5-Digit String" calculations appear in cell rows Q,R and T,U.