Welcome Guest
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
Ontario
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?

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 *

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.

 Page 1 of 1