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

need excel for what a difference

Topic closed. 23 replies. Last post 12 years ago by retxx.

Page 2 of 2
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: January 26, 2005, 5:19 pm - IP Logged

Wow did thread get off the topic!!

I am almost finished "Bug's" System Excel worksheet.

There are a couple questions I wanted to ask:

1. How many past drawings do you use?

2. How do you determine if a Pair is "HOT", "DUE" or "PLAYED"?

Any additional info would be helpful!!

Once I get the rest of the info I will give it out to those that would like a copy.  If it is OK with BUG.

Thanks,

Winsum

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

    Back to the excel sheet ;-)

    I first must learn the system, but I have already made some progress in automation on sheet 2 of the original excel workbook. Right now it will...

    A. let you enter the numbers into the sheet for your state

    B. separate them into 3 new columns, e.g. you enter into column C 714, then column D will change to 7, E to 1 and F to 4... this step is key to automatic recalculation... Since it was set up using 2 months of draws, I left that the same.

    C. it now automatically calculates the front and back pair sums using BUG's conversion system, I adapted them into excel using the following....

     for SUM

    =IF((D7+E7>9),(D7+E7-10+1),(D7+E7))

    For Difference

    =IF((E7<D7),((E7+10)-D7),(E7-D7))

    D. it automatically counts the front/back sum and front/back differences, so when you change the input numbers, it automatically adjusts.

    E. it uses a rudimentary formula to determine extreme HOT and extreme DUE (MAX and MIN respectively) and alerts you to it... that was done with this formula...

    =IF((N5=MAX($N$5:$N$14)),"HOT",IF((N5=MIN($N$5:$N$14)),"DUE"," "))

     

    I need to understand where the rest of the numbers come from before I can go further... on sheet 2 is a section in gray with a note that says "need one of these as a back pair"... whare do these numbers come from? why are they needed from the back pair and where in the rest of the information were they calculated from?

    I'm not half bad with excel, I just don't follow the system 100% yet... but progress has indeed been made ;-) 

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

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: January 30, 2005, 3:48 pm - IP Logged

      Yes Hypersoniq you are pure genius material

      L ttaL   T


        United States
        Member #89
        January 18, 2002
        2092 Posts
        Offline
        Posted: January 30, 2005, 8:24 pm - IP Logged

        SirMetro,

        The website about "Fractal Geometry" impressed me quite well. I'm not of the 'nerd' persuasion nor am I a genius or scientist but I am quite aware of good information.

        Thank you,

        Teufellj... 

          retxx's avatar - mrthumbs
          BOSTON
          United States
          Member #48
          September 9, 2001
          3584 Posts
          Offline
          Posted: January 30, 2005, 9:26 pm - IP Logged

          wow wtg hyper for all your hard work here,we will all benefit I hope. With a couple more questions answered you might be able to finish down to the final cells needed to list probable numbers to play. Thanks

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

            quick Q.

            in the original file, second worksheet... I get that all the numbers below 04 use a +1+1 progression...

            (automated thusly...

            "04" is at M31... move the "0" to L31 and leave the 4 at M31, then in L32 put

            =IF((L31+1)<10,(L31+1),((L31-10)+1))

            drag this formula from L32 thru M40, this sets up your numbers to automatically add just one (even to a 9) regardless of the starting number.....

            )

            my question is where does the "04" come from originally?

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

              reddog's avatar - patch
              Greensboro, North Carolina
              United States
              Member #1616
              June 5, 2003
              1285 Posts
              Offline
              Posted: February 13, 2005, 10:38 am - IP Logged

              hyper, how is the project coming along?

              US Flag

                hypersoniq's avatar - 8ball
                Pennsylvania
                United States
                Member #1340
                April 6, 2003
                2450 Posts
                Offline
                Posted: February 13, 2005, 4:19 pm - IP Logged

                still trying to figure out the rest of the system...

                formula creation is the easy part for me, I have trouble figuring out exactly how the system ends up with the numbers it does, once I get that info, the rest is easy.

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

                  retxx's avatar - mrthumbs
                  BOSTON
                  United States
                  Member #48
                  September 9, 2001
                  3584 Posts
                  Offline
                  Posted: February 13, 2005, 9:10 pm - IP Logged

                  did you pm bug to get those answers?