Lottery Wheel Math - Using Excel, How Many Ticket'sPrev TopicNext Topic

• TooTallLuke

  

  Ontario
  Canada
  Member #137,280
  December 31, 2012
  106 Posts
  Offline
  Jan 20, 2014, 2:54 pm

  ▲▼

  Anyone know formula I could use in Excel to calculate how many tickets I would need if I wanted to create a full wheel using various number of tickets with various win guarantee's?

  Example:

  using 30 numbers, guarantee 3 match if 3 selected

  using 30 numbers, guarantee 4 match if 4 selected

  As well, if using 30 numbers, and 4 are selected, how many 3 match would I end up with?
• RJOh

  

  100

  mid-Ohio
  United States
  Member #9
  March 24, 2001
  20,272 Posts
  Offline
  Jan 20, 2014, 6:07 pm

  ▲▼

  A FULL Wheel contains every possible combination in the number pool, you want an abbreviated wheel.  You can use CoverMaster to come up with different abbreviated wheels with different guarantees.

   * you don't need to buy every combination, just the winning ones * 

         
  
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  Jan 20, 2014, 6:24 pm

  ▲▼
  In response to TooTallLuke

  Quote: Originally posted by TooTallLuke on Jan 20, 2014

  Anyone know formula I could use in Excel to calculate how many tickets I would need if I wanted to create a full wheel using various number of tickets with various win guarantee's?

  Example:

  using 30 numbers, guarantee 3 match if 3 selected

  using 30 numbers, guarantee 4 match if 4 selected

  As well, if using 30 numbers, and 4 are selected, how many 3 match would I end up with?

  You really need to limit your numbers to about 20, use a power number, and consolidate your skips.

  Dont forget to pray.