RickG Pick 3 Wheel - Excel FilesPrev TopicNext Topic

• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 11, 2013, 11:07 am

  ▲▼

  A member asked me if I could create Excel files from this post from RickG back on July 6 2010:

  https://www.lotterypost.com/thread/216933

  Instructions:

  1. Create a new folder and name it whatever you wish.  Example RickG Pick 3 Wheel

  2. Download the 2 Excel files below into your new folder created in step 1 above:

  https://app.box.com/s/9bhb4hif42ool3vw0s0d

  https://app.box.com/s/ck7p53sw8kck8pnld15w

  I will try and post a video explaining how to use the Excel files.

  If someone could verify what RickG uses as a determing factor for digit placement.  Is it total hits from last 12 draws, skips, etc.

  Thanks!!
• pima54

  

  Florida
  United States
  Member #22,508
  September 26, 2005
  107 Posts
  Offline
  Aug 11, 2013, 11:28 am

  ▲▼

  Thanks for sharing this. 
• CARBOB

  

  COLUMBUS,GA.
  United States
  Member #4,924
  June 3, 2004
  6,719 Posts
  Offline
  Aug 11, 2013, 5:59 pm

  ▲▼

  I think RickG mentioned in the thread, he used 10- 12 draws, trying to limit the ties. I'm thinking total hits, unless you want to test by position.

  His memory lives on!!!!! Thanks RickG!!!
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 11, 2013, 7:41 pm

  ▲▼

  I'm in the process of uploading a Youtube video with instructions on how to use the 2 Excel files.

  I updated the RickGWheelingSystem Excel file.

  Here are the new links:

  https://app.box.com/s/9bhb4hif42ool3vw0s0d

  https://app.box.com/s/ck7p53sw8kck8pnld15w
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 11, 2013, 8:15 pm

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Aug 11, 2013

  I'm in the process of uploading a Youtube video with instructions on how to use the 2 Excel files.

  I updated the RickGWheelingSystem Excel file.

  Here are the new links:

  https://app.box.com/s/9bhb4hif42ool3vw0s0d

  https://app.box.com/s/ck7p53sw8kck8pnld15w

  Here is the Youtube Video:

  http://www.youtube.com/watch?v=3r2Gp2CJq6A
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 12, 2013, 9:10 am

  ▲▼

  For those who downloaded the Excel files before 9 am est today Monday August 12 2013, I updated the P3StateDraws Excel file and also corrected a couple errors in the RickGPick3Wheeling Excel file.

  Here are the new links:  You can delete the older files that you have.

  https://app.box.com/s/9bhb4hif42ool3vw0s0d

  https://app.box.com/s/gq5l9jhpufx4gg0n7j48

  Let me know if any errors or suggestions.

  Thanks!!
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 25, 2013, 6:02 pm

  ▲▼

  Hey guys I added a method that RickG presented in an older thread.  It's called the 2 digit repeat by position.  That is locate 2 digits that repeat starting with the most current drawing and going backwards.  Take position 1 and look for the 1st 2 digits that repeat, then do the same for Position 2 and Position 3.  Take the 2 digits by position and wheel into 8 sets.

  I'll post a video later this evening.

  Here is the download link to the Excel files:

  Select the Excel files for your version.

  .xls 1997 - 2003

  .xlsm 2007 & 2010

  https://app.box.com/s/3ynfxj9pjtheeql8wsyu
• Feisty1

  

  Las Vegas, NV
  United States
  Member #44,840
  August 9, 2006
  1,803 Posts
  Offline
  Aug 25, 2013, 6:50 pm

  ▲▼

  Thank you!
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 25, 2013, 10:25 pm

  ▲▼

  I updated the Excel files at 10:15 this evening eastern time.

  Here is the download link for all the files for your version of Excel

  Here is the link:

  https://app.box.com/s/3ynfxj9pjtheeql8wsyu
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 26, 2013, 8:39 am

  ▲▼

  Here is a video on how to use the "2 Digit Repeat"

  http://www.youtube.com/watch?v=EsI6GHHogQ0
• germaira

  

  Cincinnati, OH
  United States
  Member #128,761
  June 2, 2012
  10 Posts
  Offline
  Aug 31, 2013, 11:29 am

  ▲▼

  You mentioned in your video that you provided the link to update the draws, but I don't see it anywhere.  I am looking for the Ohio Pick 3 mid and eve results file.  I loaded the Pick3 draw file along with the RickG file but it only has 1 Ohio Pick 3 draw in it.
• JAP69

  

  South Carolina
  United States
  Member #6
  November 4, 2001
  8,966 Posts
  Online
  Aug 31, 2013, 11:50 am

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Aug 11, 2013

  A member asked me if I could create Excel files from this post from RickG back on July 6 2010:

  https://www.lotterypost.com/thread/216933

  Instructions:

  1. Create a new folder and name it whatever you wish.  Example RickG Pick 3 Wheel

  2. Download the 2 Excel files below into your new folder created in step 1 above:

  https://app.box.com/s/9bhb4hif42ool3vw0s0d

  https://app.box.com/s/ck7p53sw8kck8pnld15w

  I will try and post a video explaining how to use the Excel files.

  If someone could verify what RickG uses as a determing factor for digit placement.  Is it total hits from last 12 draws, skips, etc.

  Thanks!!

  Rick G explains about digits here.

  I think this is what you are looking for.

  https://www.lotterypost.com/thread/93568

  Numbers are where you find them.
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Aug 31, 2013, 6:06 pm

  ▲▼
  In response to germaira

  Quote: Originally posted by germaira on Aug 31, 2013

  You mentioned in your video that you provided the link to update the draws, but I don't see it anywhere.  I am looking for the Ohio Pick 3 mid and eve results file.  I loaded the Pick3 draw file along with the RickG file but it only has 1 Ohio Pick 3 draw in it.

  Open the P3StateDraws (.xlsm or .xls) file first.

  The go to the main menu at the top and click File > Open than browse to the folder where you downloaded your files and locate the RickG Excel file.

  When the RickG Excel file opens click the very 1st tab at the bottom "States".  Click cell J8.  You should see a drop-down arrow appear to the right of the cell.  Click the drop-down arrow and a list will appear with all the Pick 3 states. Click the up/down arrow until you find Ohio_Midday, Ohio_Evening, or Ohio_Combined.  Select 1 of the 3.
• emilyg

  

  50

  United States
  Member #14
  November 9, 2001
  31,614 Posts
  Offline
  Aug 31, 2013, 6:55 pm

  ▲▼

  I miss Rick.

  love to nibble those micey feet.

   

                               
• sully16

  

  25

  Ringleader

  Michigan
  United States
  Member #81,738
  October 28, 2009
  128,052 Posts
  Offline
  Sep 2, 2013, 7:22 pm

  ▲▼
  In response to emilyg

  Quote: Originally posted by emilyg on Aug 31, 2013

  I miss Rick.

  So do I