Welcome Guest
Log In | Register )
You last visited December 8, 2016, 2:47 am
All times shown are
Eastern Time (GMT-5:00)

Lottery Wheel Math - Using Excel, How Many Ticket's

Topic closed. 2 replies. Last post 3 years ago by LottoBoner.

Page 1 of 1
PrintE-mailLink
TooTallLuke's avatar - img 8jc7G2.jpg
Ontario
Canada
Member #137286
December 31, 2012
93 Posts
Offline
Posted: January 20, 2014, 2:54 pm - IP Logged

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's avatar - chipmunk
    mid-Ohio
    United States
    Member #9
    March 24, 2001
    19828 Posts
    Offline
    Posted: January 20, 2014, 6:07 pm - IP Logged

    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 more tickets, just buy a winning ticket * 
       
                 Evil Looking       


      United States
      Member #124493
      March 14, 2012
      7023 Posts
      Offline
      Posted: January 20, 2014, 6:24 pm - IP Logged

      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.