Excel Wheels

Reply #5

plnwebguy — Wed, 17 Mar 2004 05:59:54 GMT

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 filte... [ More ]

Reply #4

plnwebguy — Sun, 14 Mar 2004 20:34:06 GMT

Quote: Originally posted by hypersoniq on March 14, 2004Thanks!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

Reply #3

plnwebguy — Sun, 14 Mar 2004 20:25:19 GMT

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... [ More ]

Reply #2

goose — Sun, 14 Mar 2004 14:37:11 GMT

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

Reply #1

hypersoniq — Sun, 14 Mar 2004 14:11:24 GMT

Thanks

Excel Wheels

plnwebguy — Sun, 14 Mar 2004 13:55:21 GMT

I used Excel to put together some wheel spreadsheets for personal use but thought I'd share them with the group for anyone who wants to download and use them as well. Some of you probably already use Excel to do the same thing, but if you don't here are some files to help you out. I use them for Powerball, Mega Millions, and Hot Lotto, so they cover wheeling 5 white balls in groups of 6 through 20. To make things run faster, I divided them into 3 spreadsheets - 6-10, 11-15, and 16-20 - and I... [ More ]