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

need excel program

Topic closed. 12 replies. Last post 11 years ago by hypersoniq.

Page 1 of 1
PrintE-mailLink
retxx's avatar - mrthumbs
BOSTON
United States
Member #48
September 9, 2001
3583 Posts
Offline
Posted: December 15, 2005, 10:42 pm - IP Logged

I need an excel program that will help me with my pick 4 Mass. past draws that I have starting in april 10th of 1975 to oct of 2005. any help would be appreciated. If anyone would like to work with the list  to experiment I would be happy to e-mail it to them. Maybe a bunch of heads are better than just one. Let me know. thanks

    Avatar
    Central Pa.
    United States
    Member #4076
    March 19, 2004
    32 Posts
    Offline
    Posted: December 22, 2005, 10:59 pm - IP Logged
     

    What kind of help are you looking for / Changing numbers to even odd? Changing numbers to high low? Counting how many times a certain number has come up in the last 5,10,20 or 50 draws...its endless of what you want excel to do for you

      retxx's avatar - mrthumbs
      BOSTON
      United States
      Member #48
      September 9, 2001
      3583 Posts
      Offline
      Posted: December 22, 2005, 11:17 pm - IP Logged

      I would like to run filters such as best o/e best hi/lo etc. most due based on past 100 draws.

        powerplayer's avatar - Lottery-022.jpg

        United States
        Member #17834
        June 28, 2005
        2083 Posts
        Offline
        Posted: December 22, 2005, 11:58 pm - IP Logged

        I would like to run filters such as best o/e best hi/lo etc. most due based on past 100 draws.

        Retxx,

        You can do all that and more with the tools on LP as a member.

        Check into it.

        If I can be of help let me know.

        I would like to see the sheet that you have...might beable to do something with it.

        PP

        Good luck to everyone!!!

          retxx's avatar - mrthumbs
          BOSTON
          United States
          Member #48
          September 9, 2001
          3583 Posts
          Offline
          Posted: December 23, 2005, 9:03 am - IP Logged

          powerplayer send me your e-mail and I will send you my list. Would like to see things like hot/cold hi/low odd/even etc.

            Avatar
            Central Pa.
            United States
            Member #4076
            March 19, 2004
            32 Posts
            Offline
            Posted: December 27, 2005, 1:14 am - IP Logged

            can be real easy to do..tell me what you want ...hot cold for the 1st,2ed,3ed number or for the group of numbers..or both..how do you want me to set up the hot cold pattern..last 5 draws,last 10 draws etc. want me to include a button macro to shift formulas up or down ..need some input of what you want

            bob



            ops was talking as if you wanted it to play pick 3..if something else tell me your game
              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3583 Posts
              Offline
              Posted: December 27, 2005, 10:50 am - IP Logged

              thanks wd would like to work with last 1 yr of draws. how about  h/ll l/hh-o/ee e/oo-c/hh h/cc non repeating numbers- in each positions 1 2 3 4. list top 10 numbers to play. I will send you my draw list after i have your e-mail.

                hypersoniq's avatar - 8ball
                Pennsylvania
                United States
                Member #1340
                April 6, 2003
                2450 Posts
                Offline
                Posted: December 30, 2005, 8:28 pm - IP Logged

                good news retxx!

                I am about halfway (5,000 draws) calculated in the SoniQ BOOM pick 4 system with MASS data (it takes a LOOOONG time to recalculate after each couple of hundred draws)

                I am STILL waiting on a recalc, but the last one I ran at 2,800 draws produced 6 straight hits!

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

                  hypersoniq's avatar - 8ball
                  Pennsylvania
                  United States
                  Member #1340
                  April 6, 2003
                  2450 Posts
                  Offline
                  Posted: December 30, 2005, 9:38 pm - IP Logged

                  only added 1 hit getting to #5000, still more than 5,000 to go

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

                    Sandy K's avatar - graphic pub.jpg
                    Clarkston, Michigan
                    United States
                    Member #76
                    January 6, 2002
                    8528 Posts
                    Offline
                    Posted: December 31, 2005, 9:57 am - IP Logged

                    This is why I love LP.....so many people willing to help.  Thank you to Hypersoniq & to WSLS especially who has helped me so much in the past and to the others who step up to the plate when someone needs help.

                    Wtg....and hopefully you get back what you give and you all get your share of the pie. 

                    Sandy

                      hypersoniq's avatar - 8ball
                      Pennsylvania
                      United States
                      Member #1340
                      April 6, 2003
                      2450 Posts
                      Offline
                      Posted: December 31, 2005, 12:55 pm - IP Logged

                      retxx... file is done! (finally) it is available on my website (7.25MB)

                      I put it there so anyone from MASS can check it out

                      13 straight hits over 29 years... you will have to figure out if it was worth it because mass. numbers game is pari-mutuel, also, I think they play for match 3 in that also, I didn't test for that.

                      good luck!

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

                        retxx's avatar - mrthumbs
                        BOSTON
                        United States
                        Member #48
                        September 9, 2001
                        3583 Posts
                        Offline
                        Posted: December 31, 2005, 9:48 pm - IP Logged

                        wow o k. thanks hyper. will download it now and what is great about the program that the initial investment is so minimal that I can stop playing 10 numbers a day and fool around with just one. what great work and support you give to this site. Is it possible to create another column that would show the same results for the first 3 as we payoff on that also.

                        kudos to you for your expertise in this field. can't thank you enough. Anyone playing in Mass. should work with this system.

                          hypersoniq's avatar - 8ball
                          Pennsylvania
                          United States
                          Member #1340
                          April 6, 2003
                          2450 Posts
                          Offline
                          Posted: January 1, 2006, 4:55 pm - IP Logged

                          first 3? I could do that easily...

                          86 times the first 3 matched

                          you can do it easily too..

                          the sheet I gave you, in cell BY3 enter

                          =COUNTIF(BT3:BV3,"x")

                          autofill this to the last draw down the BY column

                          you will see where I have the count of pick4 matches in cell BZ10141

                          in cell BZ10140 enter

                          =COUNTIF(BY3:BY10141,3)

                          it's that easy ;-)

                           

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