Welcome Guest
Log In | Register )
You last visited December 5, 2016, 3:33 pm
All times shown are
Eastern Time (GMT-5:00)

excel users

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

Page 1 of 1
PrintE-mailLink
Avatar
modesto
United States
Member #3241
January 5, 2004
343 Posts
Offline
Posted: March 2, 2004, 9:28 pm - IP Logged

had a question for you excel users heard its a powerful

program and before I look for a class .Wanted to know if

first can you wheel with it?

second can after saving file open up to filter with customized

past history files .Which would be broke down as such (this is for

pick 5 games)

01/02/04    5  12 23 34 20 - 5 12 23. 5 12 34 (each draw would be broken

                                    down into 3 digit and 4 digit games on each line )

 than you would filter back as many days back as you wish asking

excel to delete all combos with 5 12 23  or 5 12 23 34  etc. in them

I believe to delete what wont happen vers's what might

if you check back in your draw history 3 digits from a past draw

usually stay out 20 to 30 days on average give or take a few days

and 4 digits are months out..so in your generated wheels

their could be a lot of wasted money..Just curious if it was possible??

to set up like this thanks for any reponse  chris

    plnwebguy's avatar - binary

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

    Paintbrush,

    You should be able to wheel and do some filtering.  For the wheeling you'd need to understand how to do what are called functions and formulas.  I'm not sure how much you can do with filtering based on what you want to do though.  You can filter manually using the filter command under Data.  You may be able to do what you want to do more efficiently using what are called macros and/or vba - so I would check those out with regards to your classes.  If you do a search on Google on something like Excel lottery wheels you'll find some examples that you can download and look at.

    plnwebguy

     

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: March 3, 2004, 6:16 pm - IP Logged

      I think Excel is limited in wheeling but it can be accomplished if you have the time.

      There are plenty of free wheeling software and pay software. 

      Chaeck out versabet.com for Intelli-Pick wheeling software.  I believe they have a demo to try.

      wsls

        Avatar
        modesto
        United States
        Member #3241
        January 5, 2004
        343 Posts
        Offline
        Posted: March 3, 2004, 9:43 pm - IP Logged

        Thanks winsum and plnwebguy

        I have all of versabet products,my problem

        is in the filtering I want to convert past history

        draws into 3 digit and 4 digit games on the same

        line.and open up the file and start deleting

        combinations for everydraw there is 10 combos

        of 3 digit numbers and for every history draw thats

        is 6300 combinations and a 20 number wheel is

        8500+ combinations and iam sure out of the 6300

        you would have a lot of over laping but i would

        like to see how many combo's are left do you

        see were am going? thanks agian chris

          plnwebguy's avatar - binary

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

          Paintbrush,

          Converting to 3 and 4 digits wouldn't be a problem, but I think filtering may be kind of tough.  It would take playing around with some of the built-in functions to get it to do what you want - I would say it would even require functions nested inside of functions.  Plus you would have to put it in a macro or write a vba to make it repeat the filter over several draws. 

          Instead of Excel, an option would be to use a database program like Access (or Filemaker if you use a Mac).  Access is more powerful than Excel when it comes to data manipulation but is not for the faint of heart to learn how to use.  But once you get queries down it's pretty powerful and that's basically what you would need to create to do what you want to do with the filtering.  I use Access to keep track of the drawings and then count the number of times a ball has been drawn via queries.

          plnwebguy