Can Anyone create a program for pairs using excelPrev TopicNext Topic

• jackpotismine

  

  Kunming
  China
  Member #57,908
  January 23, 2008
  6,117 Posts
  Offline
  Mar 8, 2008, 9:56 pm

  ▲▼

  I don't know how to use excel formulas. I'm trying to get excel to give me pairs and three's and four's for each number drawn. It's for take 5 which has 22 numbers. So for instance 1 has been paired most with 18 and then 5 . My goal is to use these pairs and three's and four's with GH and wheel them using one of her power number system. Any help would be appreciated.

  I believe in Occam's razor:

  The Simplest Answer is Usually Correct.
• Pogo

  

  NC
  United States
  Member #29,377
  January 1, 2006
  592 Posts
  Offline
  Mar 8, 2008, 10:11 pm

  ▲▼

  PM or post a little example of what you want for your 5/22 game and I'll see what I can do for you. I'm assuming you want to enter like 8 numbers that your thinking about wheeling and the results will be the top 3 followers for each number if this is correct, I'll get started and see what I can do for you... Let me know - Pogo 
• GASMETERGUY

  

  NASHVILLE, TENN
  United States
  Member #33,371
  February 20, 2006
  1,044 Posts
  Offline
  Mar 11, 2008, 12:43 pm

  ▲▼
  In response to Pogo

  Quote: Originally posted by Pogo on Mar 8, 2008

  PM or post a little example of what you want for your 5/22 game and I'll see what I can do for you. I'm assuming you want to enter like 8 numbers that your thinking about wheeling and the results will be the top 3 followers for each number if this is correct, I'll get started and see what I can do for you... Let me know - Pogo 

  Pogo

  After you create this program, please post the code in your blog. 

  You will be helping a whole lot of people with some insight on how to create a VBA program in Excel.

  Thanks.
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Mar 12, 2008, 8:24 pm

  ▲▼
  In response to jackpotismine

  Quote: Originally posted by jackpotismine on Mar 8, 2008

  I don't know how to use excel formulas. I'm trying to get excel to give me pairs and three's and four's for each number drawn. It's for take 5 which has 22 numbers. So for instance 1 has been paired most with 18 and then 5 . My goal is to use these pairs and three's and four's with GH and wheel them using one of her power number system. Any help would be appreciated.

  Here is an Excel program that will track Pairs.

  I found the code on techonthenet.

  Made some modifications.

  1.  I used 5/22 Game.  (You will need to adjust the number of balls by changing the charts and drawing files)

  2.  Used 500 Random drawings for a 5/22 game (You can aadjust by adding/deleting or pasting your own draws in the appropriate Tab)

  Here is the download link:

  http://www.badongo.com/file/8255961 

  Have Fun!!

  Good Luck