It's in the Box, Hit pick 3 with only 6-8 NumbersPrev Topic Next Topic

New Topic New Poll

winsumloosesum

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

Jul 2, 2018, 2:50 pm

I created Excel files for using eekem6078 Pick 3 System

Instructions:

1>Create a new folder and name it whatever you like. Example, Pick 3 System 198

2>Download and unzip the 2 Excel files to the new folder created in step 1 above

Download link:

https://my.pcloud.com/publink/show?code=XZDzRB7Zw9fAR8ECPTJN1y6HDUyuRYK1c4ck

3> I also created a video and uploaded to Youtube:

https://youtu.be/QK_SEiD3RIg

Or download the video from the link below: (57MB)

https://my.pcloud.com/publink/show?code=XZ3zRB7ZB49DpWRc31uPPPppJnHYa0zprtv7

4>There 2 Excel files you need to use. "P3DrawsCopy.xlsm" and "System198.xlsm"

These Excel files were created using Excel version 2010. These 2 Excel files should work in 2007, 2010, 2016.

5>I explain in the video how to use the 2 Excel files.

a>Make sure both Excel files are in the same folder. See Step 1 above.

b>Open the Excel file "P3DrawsCopy.xlsm" 1st.

c>Once the "P3DrawsCopy.xlsm" is open go to the Main Menu and select > File > Open and browse to the folder where you saved the 2 Excel files and open the 2nd Excel file "System198.xlsm". This will the the Excel file you will use to create your Pick 3 Wheels, Sets, and check future draws for winners.
winsumloosesum

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

Jul 2, 2018, 3:01 pm

Quote: Originally posted by winsumloosesum on Jul 2, 2018
I created Excel files for using eekem6078 Pick 3 System

Instructions:

1>Create a new folder and name it whatever you like. Example, Pick 3 System 198

2>Download and unzip the 2 Excel files to the new folder created in step 1 above

Download link:

https://my.pcloud.com/publink/show?code=XZDzRB7Zw9fAR8ECPTJN1y6HDUyuRYK1c4ck

3> I also created a video and uploaded to Youtube:

https://youtu.be/QK_SEiD3RIg

Or download the video from the link below: (57MB)

https://my.pcloud.com/publink/show?code=XZ3zRB7ZB49DpWRc31uPPPppJnHYa0zprtv7

4>There 2 Excel files you need to use. "P3DrawsCopy.xlsm" and "System198.xlsm"

These Excel files were created using Excel version 2010. These 2 Excel files should work in 2007, 2010, 2016.

5>I explain in the video how to use the 2 Excel files.

a>Make sure both Excel files are in the same folder. See Step 1 above.

b>Open the Excel file "P3DrawsCopy.xlsm" 1st.

c>Once the "P3DrawsCopy.xlsm" is open go to the Main Menu and select > File > Open and browse to the folder where you saved the 2 Excel files and open the 2nd Excel file "System198.xlsm". This will the the Excel file you will use to create your Pick 3 Wheels, Sets, and check future draws for winners.

Excel file "System198.xlsm"

1> Click the tab at the bottom labeled "System"

2> Cell E10 (Screen Shot above) select the most recent Friday drawing. Since today is Monday July 2, 2018 the previous Friday drawing date was Friday, June 29, 2018.

Click cell E10. To the right of cell E10 you should see a drop-down arrow. Click the drop-down arrow and select the most recent "Friday" date. You can see that I already selected June 29, 2018

3> Click Cell E15. This is where we select the Pick 3 game you want to create the sets (wheel sets). Click cell E15 and to the right click the drop-down arrow and select the Pick 3 game from the drop-down listing. In the screen shot above I select Pennsylvania Pick 3 Evening game.
winsumloosesum

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

Jul 2, 2018, 3:20 pm

Quote: Originally posted by winsumloosesum on Jul 2, 2018
Excel file "System198.xlsm"

1> Click the tab at the bottom labeled "System"

2> Cell E10 (Screen Shot above) select the most recent Friday drawing. Since today is Monday July 2, 2018 the previous Friday drawing date was Friday, June 29, 2018.

Click cell E10. To the right of cell E10 you should see a drop-down arrow. Click the drop-down arrow and select the most recent "Friday" date. You can see that I already selected June 29, 2018

3> Click Cell E15. This is where we select the Pick 3 game you want to create the sets (wheel sets). Click cell E15 and to the right click the drop-down arrow and select the Pick 3 game from the drop-down listing. In the screen shot above I select Pennsylvania Pick 3 Evening game.

Excel file "System198.xlsm" Part 2:

In the screen shot below notice the Pennsylvania Pick 3 evening drawing in cell O20 (355)

In cell range Q20 through S21 are the calculations using 198.

1-9-8

3-5-5

4-4-3

1> Select the Alpha settings in cell range V2 through X2 for your 1st set to wheel.

In the example below:

A = 3 (Cell Q20)

B = 5 (Cell R20)

C = 5 (Cell S20)

D = 4 (Cell Q21)

E = 4 (Cell R21)

F = 3 (Cell (S21)

Notice in cell range V2 through X8 I created a total of 7 sets using the letters A through F.

Below starting in cell V19 through X19 are where the actual sets are created.
winsumloosesum

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

Jul 2, 2018, 3:30 pm

Excel file "System198.xlsm" Part 3:

Wheeled sets vs. actual winning drawings from last 2 days.

If there are any winning sets (straight or boxed) the sets will be highlighted in Green.

Note: Do not enter any drawings into any of the cells.

The only selections you need to make are cell E10 (Select most recent Friday date), select your Pick 3 game in cell E15.

Enter the letters A through F in cell range V2 through X11. You can create up to 10 sets.
winsumloosesum

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

Jul 2, 2018, 3:38 pm

Excel file "System198.xlsm" Part 4: Back-testing previous weeks:

In the screen shot below I changed the date in cell E10 to Friday June 22, 2018.

Notice the 405 hit straight on Monday, June 25, 2018
ekem6078

TN
United States
Member #88,773
March 23, 2010
2,462 Posts
Offline

Jul 4, 2018, 8:42 am

Quote: Originally posted by winsumloosesum on Jul 2, 2018
Excel file "System198.xlsm" Part 4: Back-testing previous weeks:

In the screen shot below I changed the date in cell E10 to Friday June 22, 2018.

Notice the 405 hit straight on Monday, June 25, 2018

Thanks winsumloosesum for putting my system in excel for everyone to use. I don't have excel, but I hope this help other out. Thanks again.
ekem6078

TN
United States
Member #88,773
March 23, 2010
2,462 Posts
Offline

Jul 4, 2018, 8:44 am

Can anyone tell me how do I get Excel. I don't know if I have it or not lol.
winsumloosesum

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

Jul 4, 2018, 10:30 am

Quote: Originally posted by ekem6078 on Jul 4, 2018
Can anyone tell me how do I get Excel. I don't know if I have it or not lol.

1>When did you purchase your computer?

2>Depending on when you purchased your computer it may already be installed

3>Click the "Start" icon or Windows icon on your Taskbar (Lower left hand corner)

4>Select Programs or Apps depending on what version of Windows you have installed (Windows 10, 8, 7, etc.)

5>Look for Excel or Microsoft Office, Office 365, etc.

Or

Do a search on your computer and enter Excel.

Some of the newer computers may have Office 365 or Office 2016 which may be offered as a 30 day trial period.

An option is purchasing a monthly subscription to Office 365 which I think is $10 per month. You can cancel at any time.

Personally I tried Excel 2016 (Office 365) and never liked it. I'm still using Excel 2010.

Excel 2010 runs faster on my Windows XP machine than my Windows 10.
winsumloosesum

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

Jul 4, 2018, 10:39 am

I'm almost finished an updated version of the Excel files.

I don't want to post them here in this thread but will post them in my Blog.

The new Excel files will give you the option of selecting "+"/"-" and select whatever values such as 1 - 9 - 8

So if you like using 1-9-8 as your values the settings would be 1-9-8 "+/+/+"

Again these will be in the new version of of Excel files.

I found some errors in the Excel files I posted here which will be corrected in the new version. The errors were related to the "Combined" draws game(s)
lakerben

50

New Mexico
United States
Member #86,096
January 29, 2010
24,950 Posts
Offline

Jul 5, 2018, 12:19 am

Quote: Originally posted by winsumloosesum on Jul 4, 2018
I'm almost finished an updated version of the Excel files.

I don't want to post them here in this thread but will post them in my Blog.

The new Excel files will give you the option of selecting "+"/"-" and select whatever values such as 1 - 9 - 8

So if you like using 1-9-8 as your values the settings would be 1-9-8 "+/+/+"

Again these will be in the new version of of Excel files.

I found some errors in the Excel files I posted here which will be corrected in the new version. The errors were related to the "Combined" draws game(s)

Thanks!!!!

Say hey!
LottoBux

25

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

Jul 12, 2018, 11:01 am

Quote: Originally posted by winsumloosesum on Jul 4, 2018
I'm almost finished an updated version of the Excel files.

I don't want to post them here in this thread but will post them in my Blog.

The new Excel files will give you the option of selecting "+"/"-" and select whatever values such as 1 - 9 - 8

So if you like using 1-9-8 as your values the settings would be 1-9-8 "+/+/+"

Again these will be in the new version of of Excel files.

I found some errors in the Excel files I posted here which will be corrected in the new version. The errors were related to the "Combined" draws game(s)

Hi Steve,

Have You Updated The Files?

I Didn't See Anything In Your Blog.

Also,Is There A Way To Update The P3AllDraws File?
ekem6078

TN
United States
Member #88,773
March 23, 2010
2,462 Posts
Offline

Jul 13, 2018, 11:08 pm

Quote: Originally posted by winsumloosesum on Jul 4, 2018
1>When did you purchase your computer?

2>Depending on when you purchased your computer it may already be installed

3>Click the "Start" icon or Windows icon on your Taskbar (Lower left hand corner)

4>Select Programs or Apps depending on what version of Windows you have installed (Windows 10, 8, 7, etc.)

5>Look for Excel or Microsoft Office, Office 365, etc.

Or

Do a search on your computer and enter Excel.

Some of the newer computers may have Office 365 or Office 2016 which may be offered as a 30 day trial period.

An option is purchasing a monthly subscription to Office 365 which I think is $10 per month. You can cancel at any time.

Personally I tried Excel 2016 (Office 365) and never liked it. I'm still using Excel 2010.

Excel 2010 runs faster on my Windows XP machine than my Windows 10.

Thanks winsumloosesum I got the excel app, but It told me my subscription has expired. Got to renew it.
mimi50

United States
Member #110,755
May 11, 2011
14 Posts
Offline

Jul 24, 2018, 3:44 am

What are the box numbers for 430?? I don't understand where the box numbers come from?
LottoBux

25

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

Jul 24, 2018, 2:09 pm

Quote: Originally posted by mimi50 on Jul 24, 2018
What are the box numbers for 430?? I don't understand where the box numbers come from?

example 430, you'll have to play only 8#

Add 198 To 430

198

430

528 Your small box would be 430

528 Your numbers to play would be.

345, 452, 523, 234, 032, 328, 280, and 803 for 7 days or until your next Fridays play.

1-Start In The Top Center 3 Go Left To 4 Then Down To 5(345)

2-Now Move To The 4 Go Down To The 5 Then Right To 2(452)

3-Now Start With 5,Go Right To 2 Then Up To 3(523)

4-Then Start With 2,Move Up To 3 And Left To 4(234)

Now Start Over From The 0 In The Top Right Corner

Follow The Same Pattern As Steps 1-2-3-4 Above To Get 032-328-280-803
ekem6078

TN
United States
Member #88,773
March 23, 2010
2,462 Posts
Offline

Aug 14, 2018, 11:23 pm

TN 8-15 Morn, Mid, Even, 898, 897, 287, 087, 072, 280, 788 Good Luck

New Topic New Poll

Subscribe to this topic

It's in the Box, Hit pick 3 with only 6-8 NumbersPrev TopicNext Topic

It's in the Box, Hit pick 3 with only 6-8 NumbersPrev Topic Next Topic