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

Complex Subtraction problem advice

Topic closed. 37 replies. Last post 7 years ago by Todd.

Page 1 of 3
51
PrintE-mailLink
WIN  D's avatar - q05Q0
Stone Mountain*Georgia
United States
Member #828
November 2, 2002
10491 Posts
Offline
Posted: May 16, 2009, 6:24 pm - IP Logged

  Here is a list of 317 numbers.  The list will change almost everyday ...based on the last Pick -3 Single numbers draw.  

 018, 019, 028, 029, 038, 039, 048, 049, 058, 059, 061, 062, 063, 064, 065, 067, 068, 069, 078, 079, 091, 092, 093, 094, 095, 097, 098, 108, 109, 128, 129, 138, 139, 148, 149, 158, 159, 160, 162, 163, 164, 165, 167, 168, 169, 178, 179, 190, 192, 193, 194, 195, 197, 198, 208, 209, 218, 219, 238, 239, 248, 249, 258, 259, 260, 261, 263, 264, 265, 267, 268, 269, 278, 279, 290, 291, 293, 294, 295, 297, 298, 308, 309, 318, 319, 328, 329, 348, 349, 358, 359, 360, 361, 362, 364, 365, 367, 368, 369, 378, 379, 390, 391, 392, 394, 395, 397, 398, 408, 409, 418, 419, 428, 429, 438, 439, 458, 459, 460, 461, 462, 463, 465, 467, 468, 469, 478, 479, 490, 491, 492, 493, 495, 497, 498, 508, 509, 518, 519, 528, 529, 538, 539, 548, 549, 560, 561, 562, 563, 564, 567, 568, 569, 578, 579, 590, 591, 592, 593, 594, 597, 598, 601, 602, 603, 604, 605, 607, 608, 609, 610, 612, 613, 614, 615, 617, 618, 619, 620, 621, 623, 624, 625, 627, 628, 629, 630, 631, 632, 634, 635, 637, 638, 639, 640, 641, 642, 643, 645, 647, 648, 649, 650, 651, 652, 653, 654, 657, 658, 659, 670, 671, 672, 673, 674, 675, 678, 679, 690, 691, 692, 693, 694, 695, 697, 698, 708, 709, 718, 719, 728, 729, 738, 739, 748, 749, 758, 759, 760, 761, 762, 763, 764, 765, 768, 769, 790, 791, 792, 793, 794, 795, 798, 801, 802, 803, 804, 805, 807, 809, 810, 812, 813, 814, 815, 817, 819, 820, 821, 823, 824, 825, 827, 829, 830, 831, 832, 834, 835, 837, 839, 840, 841, 842, 843, 845, 847, 849, 850, 851, 852, 853, 854, 857, 859, 860, 861, 862, 863, 864, 865, 867, 869, 870, 871, 872, 873, 874, 875, 879, 890, 891, 892, 893, 894, 895, 897

 

  How may we easily subtract ,,,, a states past history results from this list for the last year ...or two ...leaving only unhit straights in the 317 list?

      Thanks for any help or suggestions

 

 

The only real failure .....is the failure to try.                               

                              Luck is a very rare thing....... Odds not so much. 

                              Odds never change .....but probability does. 

                                                                                       Win d    

    Avatar

    United States
    Member #41846
    June 23, 2006
    458 Posts
    Offline
    Posted: May 16, 2009, 6:48 pm - IP Logged

    Win D

    if I can assume that your history file and this group of numbers are in Excel, then a VBA program would be fairly easy, a couple of loops and compare. stick this # in a third column if not found in previous history, number of days to check could be user specified.  if interested in a VBA solution tell me what column or columns different data is in and where do you want the results to go.  will there always be 317 numbers?

    p8

      WIN  D's avatar - q05Q0
      Stone Mountain*Georgia
      United States
      Member #828
      November 2, 2002
      10491 Posts
      Offline
      Posted: May 16, 2009, 7:49 pm - IP Logged

      Very nice of you phileight.....thank you.

       Sounds good to me.....  A VBA program would be great. 

       Column A .... Could be the state History ...or Historical list of Straights ...which could be 365 or 1000 of the past draws. ( so this Column list will be variable) 

        Column B ...could be the 317 ....which will almost always be the same amount each day.  Perhaps we should set that array for 500 numbers ....just in case we need it in the future.

        Column C ....  will assume to be the still standing results of the un-hit numbers on the 317 list we wanted to see.   

       

           So happy that you replied phileight ......and look forward to seeing this in action. 

       

             Regards

       

       

      The only real failure .....is the failure to try.                               

                                    Luck is a very rare thing....... Odds not so much. 

                                    Odds never change .....but probability does. 

                                                                                             Win d    

        LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
        Tx
        United States
        Member #4570
        May 4, 2004
        5180 Posts
        Offline
        Posted: May 16, 2009, 8:30 pm - IP Logged

        Ricky could easily add that option to his LotSoft wheeler if He wanted to, but it would have to be the one on the commercial version, not on the freeone, as that-one does not have a past draws database, it could be done also on that one, but with more trouble, the past winning numbers would need to be copied and pasted.

        There is already another way, but for that one you need to talk to MikeK about it.

        BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

        "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

          Avatar

          United States
          Member #41846
          June 23, 2006
          458 Posts
          Offline
          Posted: May 16, 2009, 8:48 pm - IP Logged

          Win D

          i assume you know where to put this and how to start it. if not let me know

          assumptions user input, how many history #'s to use

          history file in A

          test #'s in B max of 500

          results of no match in C

          p8

           

           

          Sub compare()
          ' history file in col a
          '#'s to test in col b
          ' if col b not found in a then display in c


          c2 = Application.InputBox("how many", "history #'s", Type:=1)
          Z = 1 'keeps track where to put no match data

          ' set up loop to get #'s to test
          For x = 1 To 500
          a = Cells(x, 2) ' row x col b or 2
          If a = "" Then GoTo done ' out of numbers so terminate
          GoSub hist 'see if this # is in history file
          Next x

          Exit Sub

          hist:
          d = c2
          Match = 0
          For y = 1 To d
          b = Cells(y, 1)
          If b = "" Then GoTo done
          If a = b Then Match = 1: y = d
          Next y
          If Match = 0 Then Cells(Z, 3) = a: Z = Z + 1 ' no match put target number in row z col 3 or C
          Return

            WIN  D's avatar - q05Q0
            Stone Mountain*Georgia
            United States
            Member #828
            November 2, 2002
            10491 Posts
            Offline
            Posted: May 16, 2009, 8:52 pm - IP Logged

            Thanks Lantern.....

               I don't think I explained this method to Ricky very well several months ago ....because we did end up with a Lotsoft history filter tool.....that could be used in a limited way but not this way.  It didn't include doubles filters or other needed filters needed to pull this off. Subtracting from the 317 using specific state history.... and doing it with POSTIONAL filters at the same time.  Ideal would be a combination of postional filters along with the "Short Sums " chart tool and history. 

             I sure am glad that you .....the filter expert ...has seen this.  I'm sure you see the killer apt that this brings to the table.  Most of the time....  anyway.  It is after all based on ..... Most Draws and won't be an every day winner in the face of doubles etc.   With straights.... once in awhile is enough right?   LOL

             

             

            The only real failure .....is the failure to try.                               

                                          Luck is a very rare thing....... Odds not so much. 

                                          Odds never change .....but probability does. 

                                                                                                   Win d    

              Avatar

              United States
              Member #41846
              June 23, 2006
              458 Posts
              Offline
              Posted: May 16, 2009, 8:57 pm - IP Logged

              Win D

              there are two lines missing from my previos post  add these at the end

               

              done:

              end sub

                WIN  D's avatar - q05Q0
                Stone Mountain*Georgia
                United States
                Member #828
                November 2, 2002
                10491 Posts
                Offline
                Posted: May 16, 2009, 9:02 pm - IP Logged

                 Thank you phileight !  Will try to plug this in and let you know

                 

                 

                The only real failure .....is the failure to try.                               

                                              Luck is a very rare thing....... Odds not so much. 

                                              Odds never change .....but probability does. 

                                                                                                       Win d    

                  LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                  Tx
                  United States
                  Member #4570
                  May 4, 2004
                  5180 Posts
                  Offline
                  Posted: May 16, 2009, 9:29 pm - IP Logged

                  Thanks Lantern.....

                     I don't think I explained this method to Ricky very well several months ago ....because we did end up with a Lotsoft history filter tool.....that could be used in a limited way but not this way.  It didn't include doubles filters or other needed filters needed to pull this off. Subtracting from the 317 using specific state history.... and doing it with POSTIONAL filters at the same time.  Ideal would be a combination of postional filters along with the "Short Sums " chart tool and history. 

                   I sure am glad that you .....the filter expert ...has seen this.  I'm sure you see the killer apt that this brings to the table.  Most of the time....  anyway.  It is after all based on ..... Most Draws and won't be an every day winner in the face of doubles etc.   With straights.... once in awhile is enough right?   LOL

                  It has been a very long time since I have used the Crunch, by MikeK so I am not sure if it can do as you want or not, maybe the first original Crunch can do the substraction and the second one has some good filters on it, but as I am not sure if it can really do as you need, a better bet is to talk to Ricky again and have him update whatever it was that he did for you before.

                  Now, let me very slowly read your posts here on this thread and see what is here.

                  And then I will post a reply.

                  BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                  "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                    LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                    Tx
                    United States
                    Member #4570
                    May 4, 2004
                    5180 Posts
                    Offline
                    Posted: May 16, 2009, 9:37 pm - IP Logged

                    It has been a very long time since I have used the Crunch, by MikeK so I am not sure if it can do as you want or not, maybe the first original Crunch can do the substraction and the second one has some good filters on it, but as I am not sure if it can really do as you need, a better bet is to talk to Ricky again and have him update whatever it was that he did for you before.

                    Now, let me very slowly read your posts here on this thread and see what is here.

                    And then I will post a reply.

                    As an after thought.

                    P34 Lotto can substract the past history of numbers also, it is up to you how many draws you want to substract, but I can't remember if it lets you load your own picks into it or not, to use them as source numbers, last I used many years ago.

                    Another possible program for this might be the LottoMatrix3 program, I think, but it has been so many years, that I can't recal for sure.

                    Now let me reread this and the other thread were you posted about this technique.

                    BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                    "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                      LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                      Tx
                      United States
                      Member #4570
                      May 4, 2004
                      5180 Posts
                      Offline
                      Posted: May 16, 2009, 9:49 pm - IP Logged

                      Let us start with P34 Lotto

                      It has a box-option on top, it is called "Lines", click on it, then go to the "Import Lines" option.

                      It will let you import pick 3 numbers into the program to be used as a "Source of numbers" then you can apply filters to it.

                      Go to the "Filters" box-option on top, then click on it, then click on "Past Draws" then put a check mark on "Draw" then on the "Don't allow draws from past........... number of draws" enter the number of past draws to not allow.

                      That is all for the P34Lotto program.

                      More next in a few more minutes.

                      BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                      "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                        LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                        Tx
                        United States
                        Member #4570
                        May 4, 2004
                        5180 Posts
                        Offline
                        Posted: May 16, 2009, 9:58 pm - IP Logged

                        Original Crunch program:

                        Selections/Reductions: In this field you can enter (or paste using the Windows feature Control-V) any PICK 3 numbers from any source you like to use. You can copy numbers from other systems, Excel sheets, Forum messages and other sources. The only requirement is that the numbers are PICK 3 numbers. If other text is included you can leave it in. The system will filter it out and accept almost any kind of input. The system can handle styles such as 2-3-4, 2 4 5, or 3,4,5 with or without separators.

                        --------------------

                        /-L/
                        This commands tells the program that the following list of PICK 3 numbers should be subtracted from all of the previous lists. You can you use to get rid of all numbers that where already drawn within the last 30 days, by simple enter the command /-L/ followed by a list of the last 30 draws of your favorite lottery.

                        ----------------

                        As seen the original Crunch can also do the substraction.

                        Any amount can be substrated not just 30 numbers, even 1000 or more if you want to.

                        That takes care of the Crunch.

                        BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                        "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                          LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                          Tx
                          United States
                          Member #4570
                          May 4, 2004
                          5180 Posts
                          Offline
                          Posted: May 16, 2009, 10:16 pm - IP Logged

                          The second more advanced Crunch (Crunch 2) can also do it.

                          On the left were it says "Commands" pick <AddList:

                          Then on the right were it says "Filter selections" pick Numbers>

                          You now will have: <AddList:Numbers>

                          Now there PASTE your list of 300 + or 500 or what ever amount of source numbers.

                          Next:

                          On "Commands" pick:

                          <SubtractList:

                          Now on "Filter Selections" pick:

                          Numbers>

                          Now you will have:

                          <SubtractList:Numbers>

                          Now enter, that is paste the history of numbers that you want to substract from the source that you pasted first.

                          Next:

                          Click on the red box that says "Crunch"

                          That is all for that one.

                          --------

                          <AddList:Numbers>
                          (List of source of numbers)

                          <SubtractList:Numbers>
                          (List of past winning numbers)

                          -----

                          Now hit "Crunch"

                          BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                          "Ten measures of beauty descended to the world, nine were taken by Jerusalem."

                            Avatar
                            New Member
                            Lilburn
                            United States
                            Member #63182
                            July 21, 2008
                            1 Posts
                            Offline
                            Posted: May 16, 2009, 10:26 pm - IP Logged

                            Win D

                            there are two lines missing from my previos post  add these at the end

                             

                            done:

                            end sub

                            Hi phileight,

                            It is so great the way peope are willing to help others on this forum.  Thanks for writing the oode for this.

                            Since I am not very informed on VBA, could you help me with understanding what I'm seeing or if I messed up with the sequence order.

                             

                            Column A --Took the draws for Georgia Evening game from Jan. 1, 2008 thru today.  This gave me 504 rows in Column A.

                            Column B - Took 225 numbers and placed them in Column B.

                            Executed the macro.  Placed 225 into input window.

                            Column C - This is where I am somewhat lost.  The results in Column C consisted of 225 numbers. 

                            Is the amount of numbers in Column C the first 225 that have not hit in the last 504 draws or are they the ones that have hit.  Some numbers are repeated in Column C.  Does this mean they have hit more than once?

                            or

                            are the numbers in Column B , starting with 226....those that do not have any adjecant info in Column C, the numbers that have not hit.  I am unsure which is the correct numbers to look at for the results.

                            Is the value placed in the input window always going to be the amout of numbers shown in Column C?

                            I know I've asked alot of questions, but any help would be greatly appreciated.  Since I asking questions, let me ask one more.  Win D showed a list of 317 numbers.  Is there anyway to cut and paste them into excel and then use some feature or functions to convert them into a single column for use in Excel?

                            Thanks again for taking the time to share this with us.

                            Perdicto

                              LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                              Tx
                              United States
                              Member #4570
                              May 4, 2004
                              5180 Posts
                              Offline
                              Posted: May 16, 2009, 10:28 pm - IP Logged

                              The LottoMatrix3 program

                              Click on where it say "Picks" then on "Load Picks" (import them).

                              Then on "Filters" pick the "Repeat Filters" then on "Straight from Last.." Enter here from 100 past numbers up-to the complete history of picks.

                              That is all for it.

                              Now let me read the original Thread about this technique (A few more minutes)

                              BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                              "Ten measures of beauty descended to the world, nine were taken by Jerusalem."