Pick 3 Digit Strings Excel Files

Reply #4

winsumloosesum — Fri, 04 Sep 2015 17:46:49 GMT

Download link with corrected Excel file:

https://copy.com/yq0SFRlwaSTqfFWw

Delete the previous version.

Reply #3

winsumloosesum — Fri, 04 Sep 2015 17:41:47 GMT

See Notes from screen shot below

Reply #2

winsumloosesum — Fri, 04 Sep 2015 17:33:09 GMT

Next, keep the P3StateDraws.xlsm Excel file open and from the Main Menu select the 3rd Excel StringsAnalysisPart2.xlsm

Note: I found a couple errors in the Excel file so I uploaded the corrected version.

Click the Tab labeled States

Click cell B15 and to the right you should see a drop-down arrow. Click the drop-down arrow and in this example, select Pennsylvania_Combined

See screen shot below:

Next, follow Steps 1 through 3 from the screen shot below:

The numbe... [ More ]

Reply #1

winsumloosesum — Fri, 04 Sep 2015 16:58:09 GMT

If you wish to only calculate the 5-Digit and 6-Digit Strings for a particular state(s) here is what you need to do:

Click the Tab at the bottom labeled States .

Click cell B19 and to the right you should see a drop-down arrow. Click the drop-down arrow and change the A (All) to C (Custom)

Next, click cell B15 and to the right you should see a drop-down arrow. Click the drop-down arrow and select the Pick 3 game you want to calculate.

For example, I'll select Pennsylvania_Combined dr... [ More ]

Pick 3 Digit Strings Excel Files

winsumloosesum — Fri, 04 Sep 2015 16:28:11 GMT

Updated the Pick 3 5-Digit and 6-Digit Strings Excel files.

Download link to the zip file:

https://copy.com/jmO1lZ4OJufGBElU

Instructions:

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