Welcome Guest
Log In | Register )
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
PrintE-mailLink
plnwebguy's avatar - binary

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

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 just pull up the spreadsheet I need at the time.  The download file though has all three spreadsheets in it.  To use them, open the appropriate file, enter the numbers and then go to the corresponding worksheet within the book.  For example, if you want to wheel 8 numbers, open the 6-10 file, enter the 8 numbers on the Numbers sheet, then you'll find the complete wheel on the worksheet labeled N8.  The sheets with the wheels are protected to avoid changes to the formulas, but it's not password protected so if for some reason you want to remove the protection you can.

Here's a direct link for the download (the file is about 1.5 mb in size)

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

plnwebguy

 

    hypersoniq's avatar - 8ball
    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

        plnwebguy's avatar - binary

        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

         

          plnwebguy's avatar - binary

          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

           

            plnwebguy's avatar - binary

            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