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

Nice Pick-3 pair system

Topic closed. 89 replies. Last post 3 years ago by tonyg.

Page 3 of 6
4.36
PrintE-mailLink

United States
Member #128790
June 2, 2012
5431 Posts
Offline
Posted: May 1, 2013, 1:30 pm - IP Logged

Here is the final version: https://www.dropbox.com/s/zgei5s94nuk96nd/NicePair.xlsx

 

You might see some duplicate results, just ignore them.

Thanks so so much.


    United States
    Member #128790
    June 2, 2012
    5431 Posts
    Offline
    Posted: May 1, 2013, 1:32 pm - IP Logged

    Where do I enter the numbers? No entry box. Thanks.

      helpmewin's avatar - dandy
      u$a
      United States
      Member #106665
      February 22, 2011
      19752 Posts
      Offline
      Posted: May 1, 2013, 1:55 pm - IP Logged

      Where do I enter the numbers? No entry box. Thanks.

      LOL


        United States
        Member #128790
        June 2, 2012
        5431 Posts
        Offline
        Posted: May 1, 2013, 2:20 pm - IP Logged

        LOL

        You naughty girl you. Big Grin

         

        Banana

          ranman17's avatar - jzy6nr
          New York
          United States
          Member #83026
          November 27, 2009
          2132 Posts
          Offline
          Posted: May 1, 2013, 2:28 pm - IP Logged

          Where do I enter the numbers? No entry box. Thanks.

          I just downloaded it from the link I provided and it is working fine.

          Be kind, because everyone you meet is fighting a great battle.

          An Unruly Evil


            United States
            Member #128790
            June 2, 2012
            5431 Posts
            Offline
            Posted: May 1, 2013, 2:35 pm - IP Logged

            I just downloaded it from the link I provided and it is working fine.

            Your inbox is full.

            I tried it again and there was an entry box at line 11 but it says cells protected when i try entering a number.

              ranman17's avatar - jzy6nr
              New York
              United States
              Member #83026
              November 27, 2009
              2132 Posts
              Offline
              Posted: May 1, 2013, 2:41 pm - IP Logged

              I am confused, the entry box is at D2

              Be kind, because everyone you meet is fighting a great battle.

              An Unruly Evil

                ranman17's avatar - jzy6nr
                New York
                United States
                Member #83026
                November 27, 2009
                2132 Posts
                Offline
                Posted: May 1, 2013, 2:42 pm - IP Logged

                Enter#              587           Root 6      Sets 155  177                 

                                                                            158  176                 

                                                                            157  575                 

                                                                            156  578                 

                                                                            175  577                 

                                                                            178  576                 

                Be kind, because everyone you meet is fighting a great battle.

                An Unruly Evil


                  United States
                  Member #128790
                  June 2, 2012
                  5431 Posts
                  Offline
                  Posted: May 1, 2013, 2:58 pm - IP Logged

                  I see the entry location now, thanks, i was looking for a rectangular box..lol


                    United States
                    Member #128790
                    June 2, 2012
                    5431 Posts
                    Offline
                    Posted: May 1, 2013, 3:08 pm - IP Logged

                    Something isn't correct.

                    example, 438

                    438=528---52-58-28

                     

                    combos:524-523-528

                                584-583-588

                                284-283-288

                               

                     

                     

                    You have,

                     

                    Enter#438Root2Sets514588
                    513582
                    518184
                    512183
                    584188
                    583182
                      ranman17's avatar - jzy6nr
                      New York
                      United States
                      Member #83026
                      November 27, 2009
                      2132 Posts
                      Offline
                      Posted: May 1, 2013, 3:45 pm - IP Logged

                      Something isn't correct.

                      example, 438

                      438=528---52-58-28

                       

                      combos:524-523-528

                                  584-583-588

                                  284-283-288

                                 

                       

                       

                      You have,

                       

                      Enter#438Root2Sets514588
                      513582
                      518184
                      512183
                      584188
                      583182

                      OK, I found the problem, the 51X numbers were the result of adding the 38 instead of using the root sum, but instead of fixing it I just added what you wanted and left everything else alone, it still only gives 18 numbers.

                       

                      https://www.dropbox.com/s/zgei5s94nuk96nd/NicePair.xlsx

                      Be kind, because everyone you meet is fighting a great battle.

                      An Unruly Evil


                        United States
                        Member #128790
                        June 2, 2012
                        5431 Posts
                        Offline
                        Posted: May 1, 2013, 7:21 pm - IP Logged

                        OK, I found the problem, the 51X numbers were the result of adding the 38 instead of using the root sum, but instead of fixing it I just added what you wanted and left everything else alone, it still only gives 18 numbers.

                         

                        https://www.dropbox.com/s/zgei5s94nuk96nd/NicePair.xlsx

                        Thanks bud.


                          United States
                          Member #128790
                          June 2, 2012
                          5431 Posts
                          Offline
                          Posted: May 1, 2013, 8:11 pm - IP Logged

                          OK, I found the problem, the 51X numbers were the result of adding the 38 instead of using the root sum, but instead of fixing it I just added what you wanted and left everything else alone, it still only gives 18 numbers.

                           

                          https://www.dropbox.com/s/zgei5s94nuk96nd/NicePair.xlsx

                          Just curious, how did the program choose these numbers when you input 829?

                           

                          Enter#829Root2Sets318399
                          312392
                          319198
                          312192
                          398199
                          392192
                          328298
                          322292
                          329299

                           

                           

                           

                          When it should be,

                          829

                          9-2=7     9+2=11=2     Last number of original number 9

                           

                          729--pairs:72-79-29

                           

                          Combos: 728-722-729

                                        798-792-799

                                        298-292-299

                            ranman17's avatar - jzy6nr
                            New York
                            United States
                            Member #83026
                            November 27, 2009
                            2132 Posts
                            Offline
                            Posted: May 1, 2013, 9:24 pm - IP Logged

                            Just curious, how did the program choose these numbers when you input 829?

                             

                            Enter#829Root2Sets318399
                            312392
                            319198
                            312192
                            398199
                            392192
                            328298
                            322292
                            329299

                             

                             

                             

                            When it should be,

                            829

                            9-2=7     9+2=11=2     Last number of original number 9

                             

                            729--pairs:72-79-29

                             

                            Combos: 728-722-729

                                          798-792-799

                                          298-292-299

                            Because it is minusing 9 from 2 instead of 2 from 9.  I don't know if I can figure out how to tell excel to choose to subtract the lower from the higher number.  Maybe CarliG can help or winsumloosesum.

                            Be kind, because everyone you meet is fighting a great battle.

                            An Unruly Evil

                              Avatar
                              Florida
                              United States
                              Member #66575
                              October 30, 2008
                              3549 Posts
                              Offline
                              Posted: May 1, 2013, 9:49 pm - IP Logged

                              Because it is minusing 9 from 2 instead of 2 from 9.  I don't know if I can figure out how to tell excel to choose to subtract the lower from the higher number.  Maybe CarliG can help or winsumloosesum.

                              I have a formula for the higher lower subraction thing but can we alter to add the Lottery math part to it  lol

                              Array Formula

                              =MAX(D5:E5)-MIN(IF(D5:E5>0,D5:E5,""))