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

Need Help -- Is there a tool that...

Topic closed. 7 replies. Last post 6 years ago by PERDUE.

Page 1 of 1
51
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: November 6, 2010, 9:34 am - IP Logged

Is there a tool that can create a set of numbers from using pairs and only being pair specific?

It will be easier to explain by example...

Say I have pairs 01, 24, 39, 58, 59, 89

I want to make sets of numbers using only these pairs with NO other numbers other than 2 corresponding pairs from above....

So I want to create only sets of numbers between 2 of the pairs from above and only using this numbers from the pairs BUT they have to have a common number between the two pairs being used.

So there will be NO sets with 01 or 24 in it because none of the other pairs have a 0 or a 1 in it or a 2 or 4 in them, but there would be sets with 39, 58, 59, 89 because the 39 can match with 59 and 89 for 359 (both pairs 39 and 59 are in here) 389 (pairs 39/89) 589 (pairs 58/59) etc, but also want all possible 6 ways with them for str8 hits.  Is there a tool or can one be created to do this?

Thanks

We are all Lucky... just some of us don't realize it!

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5896 Posts
    Offline
    Posted: November 6, 2010, 11:02 am - IP Logged

    Is there a tool that can create a set of numbers from using pairs and only being pair specific?

    It will be easier to explain by example...

    Say I have pairs 01, 24, 39, 58, 59, 89

    I want to make sets of numbers using only these pairs with NO other numbers other than 2 corresponding pairs from above....

    So I want to create only sets of numbers between 2 of the pairs from above and only using this numbers from the pairs BUT they have to have a common number between the two pairs being used.

    So there will be NO sets with 01 or 24 in it because none of the other pairs have a 0 or a 1 in it or a 2 or 4 in them, but there would be sets with 39, 58, 59, 89 because the 39 can match with 59 and 89 for 359 (both pairs 39 and 59 are in here) 389 (pairs 39/89) 589 (pairs 58/59) etc, but also want all possible 6 ways with them for str8 hits.  Is there a tool or can one be created to do this?

    Thanks

    You mean this? Don't you use Lotsoft?

     

    Numbers created : 3
    359, 389, 589

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: November 6, 2010, 11:22 am - IP Logged

      You mean this? Don't you use Lotsoft?

       

      Numbers created : 3
      359, 389, 589

      I had the lotsoft program but computer crashed and I lost a lot of stuff

      Yes thats what I mean, but I want to place my pairs in one area, and have it only filter out "like" numbers to combine.

      So using the pairs 39, 59, 89 it puts them in order, but 01 or 24 do not qualify b/c they do not mactch up to the 39, 59 89 or each other.

      I also want it to generate all 6 winning possible combinations... I know its asking a lot.

      We are all Lucky... just some of us don't realize it!

        Raven62's avatar - binary
        New Jersey
        United States
        Member #17843
        June 28, 2005
        49699 Posts
        Offline
        Posted: November 6, 2010, 11:53 am - IP Logged

        I had the lotsoft program but computer crashed and I lost a lot of stuff

        Yes thats what I mean, but I want to place my pairs in one area, and have it only filter out "like" numbers to combine.

        So using the pairs 39, 59, 89 it puts them in order, but 01 or 24 do not qualify b/c they do not mactch up to the 39, 59 89 or each other.

        I also want it to generate all 6 winning possible combinations... I know its asking a lot.

        This dilemma can be avoided by doing backups of your programs/data.

        A mind once stretched by a new idea never returns to its original dimensions!

          Avatar

          United States
          Member #41846
          June 23, 2006
          459 Posts
          Offline
          Posted: November 7, 2010, 6:26 pm - IP Logged

          Rakster

          If you use macros this may help. as always try it in a new spreadsheet first

           

          Sub combo_tool()
           Range("c3:bb50").Select
              Selection.ClearContents
              Selection.Interior.ColorIndex = 0
                  Selection.ColumnWidth = 3
          Dim pt(10)
          pp = 50: t = 3: s = 3 ' # of possible pairs  t is row to start storing valid pairs
          'search list of possible pairs reject any that have no common #'s store good pairs in c,d
          'assumes pairs are in col a,b starting at line 3  blank cell is end of list
          Cells(1, 4) = "Filtered": Cells(2, 4) = "no common #" 'heading
          Cells(1, 10) = "combinations and variations"
          For x = 3 To pp ' possible list of pairs up to 50 or more by changing this #
          If Cells(x, 1) = "" Then GoTo done1 ' end of list quit checking
          For y = 1 To 2: a = Cells(x, y)
          pt(a) = pt(a) + 1
          Next y 'valid #'s will have a count greater than 1
          Next x
          done1:

          For x = 3 To pp ' possible list of pairs up to 50 or more by changing this #
          If Cells(3, 1) = "" Then GoTo done2 ' end of list quit checking
          a = Cells(x, 1): b = Cells(x, 2)
          If pt(a) > 1 Or pt(b) > 1 Then Cells(t, 4) = a: Cells(t, 5) = b: t = t + 1
          Next x
          ' col 4&5 has the valid pairs
          done2:

          For x = 3 To t - 1 '  t=# of valid pairs
          a = Cells(x, 4): b = Cells(x, 5)
          For z = x + 1 To t
          c = Cells(z, 4): d = Cells(z, 5)
          If c = a Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = d: s = s + 1
          If c = b Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = d: s = s + 1
          If d = a Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = c: s = s + 1
          If d = b Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = c: s = s + 1
          Next z
          Next x

          For x = 3 To pp ' start show all 6 variations
          If Cells(3, 8) = "" Then GoTo done3
          a = Cells(x, 8): b = Cells(x, 9): c = Cells(x, 10) 'variation 1
          Cells(x, 12) = a: Cells(x, 13) = c: Cells(x, 14) = b
          Cells(x, 16) = b: Cells(x, 17) = c: Cells(x, 18) = a
          Cells(x, 20) = b: Cells(x, 21) = a: Cells(x, 22) = c
          Cells(x, 24) = c: Cells(x, 25) = a: Cells(x, 26) = b
          Cells(x, 28) = c: Cells(x, 29) = b: Cells(x, 30) = a

          Next x
          done3:
          Range("A1").Select
          End Sub

            Rakster's avatar - praying hands.jpg
            Saskatchewan
            Canada
            Member #19992
            August 9, 2005
            2867 Posts
            Offline
            Posted: November 8, 2010, 4:32 pm - IP Logged

            Rakster

            If you use macros this may help. as always try it in a new spreadsheet first

             

            Sub combo_tool()
             Range("c3:bb50").Select
                Selection.ClearContents
                Selection.Interior.ColorIndex = 0
                    Selection.ColumnWidth = 3
            Dim pt(10)
            pp = 50: t = 3: s = 3 ' # of possible pairs  t is row to start storing valid pairs
            'search list of possible pairs reject any that have no common #'s store good pairs in c,d
            'assumes pairs are in col a,b starting at line 3  blank cell is end of list
            Cells(1, 4) = "Filtered": Cells(2, 4) = "no common #" 'heading
            Cells(1, 10) = "combinations and variations"
            For x = 3 To pp ' possible list of pairs up to 50 or more by changing this #
            If Cells(x, 1) = "" Then GoTo done1 ' end of list quit checking
            For y = 1 To 2: a = Cells(x, y)
            pt(a) = pt(a) + 1
            Next y 'valid #'s will have a count greater than 1
            Next x
            done1:

            For x = 3 To pp ' possible list of pairs up to 50 or more by changing this #
            If Cells(3, 1) = "" Then GoTo done2 ' end of list quit checking
            a = Cells(x, 1): b = Cells(x, 2)
            If pt(a) > 1 Or pt(b) > 1 Then Cells(t, 4) = a: Cells(t, 5) = b: t = t + 1
            Next x
            ' col 4&5 has the valid pairs
            done2:

            For x = 3 To t - 1 '  t=# of valid pairs
            a = Cells(x, 4): b = Cells(x, 5)
            For z = x + 1 To t
            c = Cells(z, 4): d = Cells(z, 5)
            If c = a Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = d: s = s + 1
            If c = b Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = d: s = s + 1
            If d = a Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = c: s = s + 1
            If d = b Then Cells(s, 8) = a: Cells(s, 9) = b: Cells(s, 10) = c: s = s + 1
            Next z
            Next x

            For x = 3 To pp ' start show all 6 variations
            If Cells(3, 8) = "" Then GoTo done3
            a = Cells(x, 8): b = Cells(x, 9): c = Cells(x, 10) 'variation 1
            Cells(x, 12) = a: Cells(x, 13) = c: Cells(x, 14) = b
            Cells(x, 16) = b: Cells(x, 17) = c: Cells(x, 18) = a
            Cells(x, 20) = b: Cells(x, 21) = a: Cells(x, 22) = c
            Cells(x, 24) = c: Cells(x, 25) = a: Cells(x, 26) = b
            Cells(x, 28) = c: Cells(x, 29) = b: Cells(x, 30) = a

            Next x
            done3:
            Range("A1").Select
            End Sub

            thanks...i appreciate your help... i never used macros before.  Is this for excel? thanks

            We are all Lucky... just some of us don't realize it!

              Avatar

              United States
              Member #41846
              June 23, 2006
              459 Posts
              Offline
              Posted: November 8, 2010, 7:40 pm - IP Logged

              yes for Excel.  anyone else trying to use this, there is a minor error. I won't bother posting the corrected version unless you need it.

                Avatar
                Monkey Butt, USA
                United States
                Member #54569
                August 23, 2007
                1124 Posts
                Offline
                Posted: November 8, 2010, 8:05 pm - IP Logged

                Is there a tool that can create a set of numbers from using pairs and only being pair specific?

                It will be easier to explain by example...

                Say I have pairs 01, 24, 39, 58, 59, 89

                I want to make sets of numbers using only these pairs with NO other numbers other than 2 corresponding pairs from above....

                So I want to create only sets of numbers between 2 of the pairs from above and only using this numbers from the pairs BUT they have to have a common number between the two pairs being used.

                So there will be NO sets with 01 or 24 in it because none of the other pairs have a 0 or a 1 in it or a 2 or 4 in them, but there would be sets with 39, 58, 59, 89 because the 39 can match with 59 and 89 for 359 (both pairs 39 and 59 are in here) 389 (pairs 39/89) 589 (pairs 58/59) etc, but also want all possible 6 ways with them for str8 hits.  Is there a tool or can one be created to do this?

                Thanks

                Yes we have that here at Lottery Post. You would have to upgrade your membership to use this tool but it is a blast.

                It is called the "Deflate 3 - Pick 3 Number Reduction System"

                It does High/Low- Sums - Root Sums - Pairs - Number Position - Singles, Doubles, Triples - Key Numbers- Odd/Even.

                I LUUUUUUUUUUUUUUUVVVVVVVVVVVV it!!!!!!!!