Welcome Guest
You last visited January 18, 2017, 3:03 pm
All times shown are
Eastern Time (GMT-5:00)

# Excel Wheels

Topic closed. 5 replies. Last post 13 years ago by plnwebguy.

 Page 1 of 1

United States
Member #3680
February 11, 2004
187 Posts
Offline
 Posted: March 14, 2004, 8:55 am - IP Logged

http://www.popularlotterynumbers.com/wheels.zip

plnwebguy

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: March 14, 2004, 9:11 am - IP Logged

Thanks!

Playing more than one ticket per game is betting against yourself.

China
Member #3032
December 16, 2003
1081 Posts
Offline
 Posted: March 14, 2004, 9:37 am - IP Logged

I am having trouble in how to reduce all prediction draws less we could afford about 50 draws each time for any lotto game.It comes all about 48*12=500 draws.I will need to use excel a bit to selete some of useful picks.Any idear£¿

There are some function I also use as well,like freq,sum and so on.

goose

United States
Member #3680
February 11, 2004
187 Posts
Offline
 Posted: March 14, 2004, 3:25 pm - IP Logged

Goose,

If you have some sort of criteria in mind, then you can put an if/then statement in a column and let it flag those rows that meet your criteria.  Then use the AutoFilter feature to only show those rows that meet the flag statement.  For example, if you did a wheel and were looking to only show rows where a certain number was in that row, then you could use a find function in an if/then statement to leave a "flag" in that cell.  Then turn on AutoFilter and in the drop down at the top of the column choose your flag variable and only those rows will remain.  The main question is what you want to base your criteria on, which would then dictate what the if/then statement would look like.

plnwebguy

United States
Member #3680
February 11, 2004
187 Posts
Offline
 Posted: March 14, 2004, 3:34 pm - IP Logged
Quote: Originally posted by hypersoniq on March 14, 2004

Thanks!

You're welcome.  I plan on having the 6-10 part online one of these days -  a person fills in their numbers, click on submit, and the next page has the wheel.  It's pretty easy to do with a form page and an output page done in php.  I may do 11-15 as well, haven't decided yet because of the number of combinations.

plnwebguy

United States
Member #3680
February 11, 2004
187 Posts
Offline
 Posted: March 17, 2004, 12:59 am - IP Logged

Thought I'd add one more file to the mix.  I took the 10 wheel sheet and modified it to where you can enter one number of your wheel on the sheet and then it'll use the match formula within an if/then statement to find the lines that contain that number.  AutoFilter is also turned so you can filter out the lines that just contain that number.  It's helpful if you want to do a wheel but abbreviate it somewhat.  The same formula could be added to more columns over and then you could use auto filter to only show those lines that match up or I guess you could modify the if/then statement and make the false parts another if/then with a different number.  I just did it on the 10 sheet but it could be added to any of them.  Here's the direct link for the download:

http://www.popularlotterynumbers.com/wheel10.zip

plnwebguy

 Page 1 of 1