Excel? How often do the bottom 5 short sums produce hits?Prev TopicNext Topic

• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  24,859 Posts
  Online
  Apr 19, 2011, 12:13 pm

  ▲▼

  Is this excel program available to download?  This would sure help in New Mexico. 

   

  
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Online
  May 14, 2011, 9:07 am

  ▲▼
  In response to lakerben

  Quote: Originally posted by lakerben on Apr 19, 2011

  Is this excel program available to download?  This would sure help in New Mexico. 

   

  

  Below is the download link to the Excel files (zip file)  Created using Excel 2002.

  1.  Create a new folder and name it whatever you like

  2.  Download the zip file from the the following link:

  http://www.box.net/shared/vlx3tbc3c0

  3.  Unzip the 2 Excel Files into the new folder you created in step 1.

  4.  I updated the drawings up to Friday May 13, 2011.

  5.  Open the Excel file "P3StateDraws.xls" then go to the Main Menu Bar at the very top and select File > Open then open the 2nd Excel file "ShortSumsLDR.xls".  You should have 2 Excel files open.

  6.  "ShortSumsLDR.xls click the first Tab at the bottom labeled "States".  At the very top you will see a Toolbat labeled "Click All".  Clicking this Toolbar will calculate every Pick 3 State Midday, Evening, and Combined drawing and create a chart showing the last 10 LDR and their skips.  For example, if you click the Tab at the bottom labeled "ShortSumsChartEvening", loacte the Quebec Pick 3 LDR stats on line 36.  Notice that Quebec Pick 3 has 2 LDR out 40 or more drawings.  The LDR 0 is out 48 drawings and the LDR 4 is out 40 draws.

  The question is will the Saturday drawing for May 14, 2011 contain the Pick 3 from the 200 numbers from LDR-0 or LDR-4?

  If anyon is interested in this Excel file post your comments.  You will also need to know how to update the drawings for each day.  I will need to add instructions for adding new drawings.  Is not hard to do.  Takes about 3 to 5 minutes.

  Good luck!!
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  24,859 Posts
  Online
  May 31, 2011, 11:33 am

  ▲▼

  thanks I'll give it a try.