Blackapple Pick 3 ToolshedPrev Topic Next Topic

New Topic New Poll

winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 27, 2015, 10:27 am

I'm going to upload some Excel files based on Blackapples posts:

The name of the folder to create is called Pick3ToolShed on your computer.

Download the following zip file and place it in the above folder.

https://copy.com/FDRlU4oO2eioklHr

Inside the zip file are 4 Excel files

P3StateDraws.xlsm and 3 additional Excel files.

Open the P3StateDraws.xlsm file first and keep open. This has all the Pick 3 draw histories of each state including Canadian Pick 3 draws. The draws are updated through Wednesday, August 26, 2015. You will see a pop-up window to change the date. Click "X" to exit the date window. You may also be prompted to enable macros or enable content. You will need to enable both if you want to use these Excel files.

Always keep this file open.

Next, from the Main Menu (Top) select File > Open and browse to the Pick3ToolShed folder and open any of the remaining Excel files. For example, open the Excel file "Pick3BoxedPairsSystem4.xlsm".

Click the tab labeled "States"

In cell J25 click the cell and select your state of just use the state I have wich in this case is Pennsylvania Midday

Click the tab labeled "220SetsBoxed"

The calculations are based on Blackapples post:

Taking past draws and removing pairs that have hit until you end up with 28 pairs. No doubles. (see column K)

Take the 4 digits with the longest out skip All Positions (see column J)

Take the 4 LDR Sums longest out skips (see column L)

Use only "6-way" sets (see column A)

Each column is filtered by clicking the "down arrows" in cell range A1 through L1

Total Sets = cell M1

Longest Out Digits = Cell range T1 through AC1. The 1st 4 are the longest out in all 3 Positions

Longest Out Pairs (No Doubles) = Cell range AF1 through BG1 The longest out Pair starts in cell AF1.

Longest Out LDR Sums = Cell range BJ1 through BS1. The 4 longest out appear in cell range BJ through BM.

42 Filtered Sets - PA Midday Draw Thursday, August 27, 2015

012
016
018
025
027
029
034
036
038
045
047
049
056
058
067
089
124
126
128
135
137
139
146
148
157
179
234
238
245
247
278
289
346
368
458
467
469
478
489
568
678
689

I will explain how to use the other Excel files when I get home later today.

Close this file when you finished.

You can open 1 of the other 2 Excel files (Other than the P3StateDraws.xlsm) and check them out.

More later......
Blackapple

25

Wyncote,Pa
United States
Member #3,206
January 3, 2004
83,380 Posts
Offline

Aug 27, 2015, 11:18 am

Thanks Winsum
kreative1

NE PA
United States
Member #127,832
May 10, 2012
1,392 Posts
Offline

Aug 27, 2015, 11:55 am

Not sure if this helps but red plays are front pairs that haven't hit this year for str8
It might filter it too much...have to see

Thanks winsum and black apple!

012
016
018
025
027
029
034
036
038
045
047
049
056 -650
058
067
089
124
126 -162
128
135
137 -173
139
146 -164
148
157 -175
179
234 -423
238
245 -425
247 -427-472
278
289
346
368
458
467 -476
469
478
489
568-658
678
689
Makenmo

United States
Member #147,784
October 13, 2013
2,196 Posts
Offline

Aug 27, 2015, 12:01 pm

Quote: Originally posted by Blackapple on Aug 27, 2015
Thanks Winsum

Nice Work Winsum!!!

1.61803398875
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 27, 2015, 1:09 pm

Add this Excel file to the Tool Shed

https://copy.com/9q1dQs2ulfKqvvxh

Place it in the same folder.

This Excel file calculates all the state draws to find out what states currently have an All Odd and All Even VTRAC out more than 5 draws.

Remember to open the P3StateDraws.xlsm open 1st before opening this Excel file.
Makenmo

United States
Member #147,784
October 13, 2013
2,196 Posts
Offline

Aug 27, 2015, 1:54 pm

Quote: Originally posted by winsumloosesum on Aug 27, 2015
Add this Excel file to the Tool Shed

https://copy.com/9q1dQs2ulfKqvvxh

Place it in the same folder.

This Excel file calculates all the state draws to find out what states currently have an All Odd and All Even VTRAC out more than 5 draws.

Remember to open the P3StateDraws.xlsm open 1st before opening this Excel file.

Thank you again and again Steve, I know how much work you did with Lotsoft. Totally appreciate how long you kept that alive... Last heard, I believe Lotsoft is still a manual update for states...

Didn't see anything about updates for this file. I think this is a manual update file(s).. If so,

I wonder/would be awesome, if Todd could come up with a way to make an update happen from LP.

You Rock my friend!

1.61803398875
Claret

Galloway, Ohio
United States
Member #163,248
January 24, 2015
483 Posts
Offline

Aug 27, 2015, 2:39 pm

Not all sure how this works but so appreciate the time and effort you have put forth here. So far your instructions are very clear. Thank you!
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,884 Posts
Offline

Aug 27, 2015, 9:25 pm

Quote: Originally posted by Makenmo on Aug 27, 2015
Thank you again and again Steve, I know how much work you did with Lotsoft. Totally appreciate how long you kept that alive... Last heard, I believe Lotsoft is still a manual update for states...

Didn't see anything about updates for this file. I think this is a manual update file(s).. If so,

I wonder/would be awesome, if Todd could come up with a way to make an update happen from LP.

You Rock my friend!

You Have To Update The Pick3StateDraws File Only.

Once That's Updated,The Other Files Will Update Automatically.

Watch This Video To Update The State Draw Files

https://www.youtube.com/watch?v=9C2ypxFFWUM
LottoBux

25

Ontario
Canada
Member #109,238
April 9, 2011
60,884 Posts
Offline

Aug 27, 2015, 9:42 pm

Quote: Originally posted by winsumloosesum on Aug 27, 2015
I'm going to upload some Excel files based on Blackapples posts:

The name of the folder to create is called Pick3ToolShed on your computer.

Download the following zip file and place it in the above folder.

https://copy.com/FDRlU4oO2eioklHr

Inside the zip file are 4 Excel files

P3StateDraws.xlsm and 3 additional Excel files.

Open the P3StateDraws.xlsm file first and keep open. This has all the Pick 3 draw histories of each state including Canadian Pick 3 draws. The draws are updated through Wednesday, August 26, 2015. You will see a pop-up window to change the date. Click "X" to exit the date window. You may also be prompted to enable macros or enable content. You will need to enable both if you want to use these Excel files.

Always keep this file open.

Next, from the Main Menu (Top) select File > Open and browse to the Pick3ToolShed folder and open any of the remaining Excel files. For example, open the Excel file "Pick3BoxedPairsSystem4.xlsm".

Click the tab labeled "States"

In cell J25 click the cell and select your state of just use the state I have wich in this case is Pennsylvania Midday

Click the tab labeled "220SetsBoxed"

The calculations are based on Blackapples post:

Taking past draws and removing pairs that have hit until you end up with 28 pairs. No doubles. (see column K)

Take the 4 digits with the longest out skip All Positions (see column J)

Take the 4 LDR Sums longest out skips (see column L)

Use only "6-way" sets (see column A)

Each column is filtered by clicking the "down arrows" in cell range A1 through L1

Total Sets = cell M1

Longest Out Digits = Cell range T1 through AC1. The 1st 4 are the longest out in all 3 Positions

Longest Out Pairs (No Doubles) = Cell range AF1 through BG1 The longest out Pair starts in cell AF1.

Longest Out LDR Sums = Cell range BJ1 through BS1. The 4 longest out appear in cell range BJ through BM.

42 Filtered Sets - PA Midday Draw Thursday, August 27, 2015

012
016
018
025
027
029
034
036
038
045
047
049
056
058
067
089
124
126
128
135
137
139
146
148
157
179
234
238
245
247
278
289
346
368
458
467
469
478
489
568
678
689

I will explain how to use the other Excel files when I get home later today.

Close this file when you finished.

You can open 1 of the other 2 Excel files (Other than the P3StateDraws.xlsm) and check them out.

More later......

Thanks Winsum For Everything .

Hope You Had A Great B'Day Yesterday

LottoBux
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 27, 2015, 10:24 pm

I'll update the P3StateDraws.xlsm Excel file each morning and post the link in this thread.
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Aug 28, 2015, 7:51 am

P3StateDraws.xlsm Excel file download link:

https://copy.com/ayKLOjd2EIoaRk0j

Draws updated through Thursday, Ausgust 27, 2015

Place this Excel file in your Balcakapple Tool Shed folder.
Claret

Galloway, Ohio
United States
Member #163,248
January 24, 2015
483 Posts
Offline

Aug 28, 2015, 11:05 am

Could you help me understand the file? Some items I know about but is there a post regardidng how BA discarded the pairs as you referred to in your instructions? Wonderful information just need help deciphering it.
Makenmo

United States
Member #147,784
October 13, 2013
2,196 Posts
Offline

Aug 28, 2015, 12:49 pm

Quote: Originally posted by Claret on Aug 28, 2015
Could you help me understand the file? Some items I know about but is there a post regardidng how BA discarded the pairs as you referred to in your instructions? Wonderful information just need help deciphering it.

Claret, if I understand you correctly,,, you can try Secrets of the 3 digits out system

Also BA uses other methods like these

F17 system which he references here.

Straight System For Pick 3

Hope this helps

1.61803398875
Claret

Galloway, Ohio
United States
Member #163,248
January 24, 2015
483 Posts
Offline

Aug 28, 2015, 1:54 pm

Exactly - thanks for the help!
Makenmo

United States
Member #147,784
October 13, 2013
2,196 Posts
Offline

Aug 28, 2015, 1:55 pm

Quote: Originally posted by Makenmo on Aug 28, 2015
Claret, if I understand you correctly,,, you can try Secrets of the 3 digits out system

Also BA uses other methods like these

F17 system which he references here.

Straight System For Pick 3

Hope this helps

Claret.... I am learning as well so let's see if I get this correct. Please Correct Me

Winsum said "The calculations are based on Blackapples post:"

Winsum Placed letters A through I, within to correspond to the following

A. Double Odd Vtracs** - 205-127-805-627 etc
B. Double Even Vtracs - 961-583-216-138 etc
C. All even or All odd combos -208-468-824-357-977-319 etc
D. The trough pairs - 00-01-08-09-11-18-19-88-99-89-
E. The 0 or 1 combos- 920-123-057-187 etc
F. Sums 12-16 -457-348-518-319-167-841 etc
G. A six-way mirror combo- 167-561-530-835-207 etc.
H. A consecutive pair
I. 2 Digit Return

I believe the following is done for you

Taking past draws and removing pairs that have hit until you end up with 28 pairs. No doubles. (see column K)

Take the 4 digits with the longest out skip All Positions (see column J)

Take the 4 LDR Sums longest out skips (see column L)

Use only "6-way" sets (see column A)

Each column is filtered by clicking the "down arrows" in cell range A1 through L1

Total Sets = cell M1

I believe the following are results of BA's Work (above) & done for you

Longest Out Digits = Cell range T1 through AC1. The 1st 4 are the longest out in all 3 Positions

You can see them 4 in CELL AD1

Longest Out Pairs (No Doubles) = Cell range AF1 through BG1 The longest out Pair starts in cell AF1.

You can see the PAIRS in CELL BH1

Longest Out LDR Sums = Cell range BJ1 through BS1. The 4 longest out appear in cell range BJ through BM.

You can see them 4 in CELL BT1

You then filter based on the given "out 5 days or more" scenario A Through I you find---- Like Winsum's 42 Filtered Sets

From what I see, Winsum has completely done most of the work.

For instance, if the Dominant LDR in a work out from Secrets of the 3 Digits out Method is say, 1, then you can reduce by only the pairs that help LDR achieve it such as 38, 29, 47...etc

Hope this helps

1.61803398875

New Topic New Poll

Subscribe to this topic

Blackapple Pick 3 ToolshedPrev TopicNext Topic

Blackapple Pick 3 ToolshedPrev Topic Next Topic