for an excel macro/program that produces the an optimized set of numbers whose combinations have notPrev TopicNext Topic

• dr san

  

  bgonçalves
  Brasil
  Member #92,560
  June 9, 2010
  3,781 Posts
  Offline
  Jul 20, 2018, 7:09 am

  ▲▼

  for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations. 
  Lottery Basics:
  7 numbers from 31. Order does not matter. 
  03 05 08 09 19 21 30
  08 11 12 14 20 21 28
  11 12 21 24 25 28 29
  06 07 13 15 18 19 29
  02 08 09 17 19 24 28
  01 11 18 19 26 30 31
  02 05 06 14 20 24 25
  01 04 13 21 22 24 27
  03 10 13 18 19 23 24
  06 10 13 18 19 20 30
  07 13 16 19 20 27 31
  02 03 07 12 17 21 22
  01 04 07 09 20 21 26
  01 08 16 20 21 26 31
  08 11 13 16 26 28 29
  01 02 07 12 16 20 25
  09 11 13 14 19 20 22
  04 07 08 14 21 27 31
  03 04 09 12 14 28 29
  06 12 17 21 26 29 31
  02 08 10 11 12 18 31
  02 04 05 12 18 22 27
  09 10 17 19 25 27 28
  07 08 12 15 16 18 30
  01 10 13 17 21 25 29
• dr san

  

  bgonçalves
  Brasil
  Member #92,560
  June 9, 2010
  3,781 Posts
  Offline
  Jul 20, 2018, 7:11 am

  ▲▼

  note = every week will be placed
    new raffles, and the macro has to include
    in the new calculation
• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,803 Posts
  Online
  Jul 20, 2018, 7:33 am

  ▲▼
  In response to dr san

  Quote: Originally posted by dr san on Jul 20, 2018

  for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations. 
  Lottery Basics:
  7 numbers from 31. Order does not matter. 
  03 05 08 09 19 21 30
  08 11 12 14 20 21 28
  11 12 21 24 25 28 29
  06 07 13 15 18 19 29
  02 08 09 17 19 24 28
  01 11 18 19 26 30 31
  02 05 06 14 20 24 25
  01 04 13 21 22 24 27
  03 10 13 18 19 23 24
  06 10 13 18 19 20 30
  07 13 16 19 20 27 31
  02 03 07 12 17 21 22
  01 04 07 09 20 21 26
  01 08 16 20 21 26 31
  08 11 13 16 26 28 29
  01 02 07 12 16 20 25
  09 11 13 14 19 20 22
  04 07 08 14 21 27 31
  03 04 09 12 14 28 29
  06 12 17 21 26 29 31
  02 08 10 11 12 18 31
  02 04 05 12 18 22 27
  09 10 17 19 25 27 28
  07 08 12 15 16 18 30
  01 10 13 17 21 25 29

  It would be easy to create a list for a 7/31 game.

  Optimized:

  What factors will you use? Sums, Odd/Even, etc.

  How many previous drawings do you have?

  A 7/31 game has 2,629,575 sets????

  A possible suggestion may be to take all the previous winning draws and calculate the Lexi's

  Take the Lexi's and see where most of the sets fall.
• dr san

  

  bgonçalves
  Brasil
  Member #92,560
  June 9, 2010
  3,781 Posts
  Offline
  Jul 20, 2018, 8:00 am

  ▲▼

  Hello, winsun, ok, thanks for replying the post, until this week we have 26 draws
  The basis, the criteria, would be repeating last and missing digits, even and odd,
  Winsum this precise criterion of your help = are the 5 doubles of the endings or last digit
  1,6   5,0   2,7   3,8   4,9
  The macro when generating formations, can not have the endings of the pair together
    Example = on the double 2.7, or digit 2 or 7 num 2,7 together
    Ex = 12,22,07,27, this can not be because it has the double 2.7 together, it must be only one digit of each pair, and thus with the other 4 doubles, plus the criterion of not repeating past formation
    Please! thank you
• dr san

  

  bgonçalves
  Brasil
  Member #92,560
  June 9, 2010
  3,781 Posts
  Offline
  Jul 20, 2018, 8:04 am

  ▲▼

  hello=WINSUM Last digit repeat and absent always from last to next draw.
  this criterion of being drawn only one of the digits of the double of the endings or last, in the generation of games sometimes appears one of the 5 doubles, no problem