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

New Year's Pick-3 System

Topic closed. 70 replies. Last post 2 years ago by retxx.

Page 3 of 5
37
PrintE-mailLink
ranman17's avatar - jzy6nr
New York
United States
Member #83026
November 27, 2009
2132 Posts
Offline
Posted: December 30, 2014, 8:41 pm - IP Logged

Something is not right. I got this,

Last 2 Drws940
Lowest here53
   
Play Sets417
  317
  517
  407
  427
  416
  418

 

It should be 887, (53+887=940)

787-687

877-897

886-889

Try this: https://www.dropbox.com/s/wxvxrkf0920r4gm/New%20Years%20P3.xlsx?dl=0

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

An Unruly Evil

    retxx's avatar - mrthumbs
    BOSTON
    United States
    Member #48
    September 9, 2001
    3584 Posts
    Offline
    Posted: December 30, 2014, 8:44 pm - IP Logged

    hi ranman. can you post this link to download without going thru dropbox? I cannot download it. It keeps reloading again and again.Thanks

      ranman17's avatar - jzy6nr
      New York
      United States
      Member #83026
      November 27, 2009
      2132 Posts
      Offline
      Posted: December 30, 2014, 9:13 pm - IP Logged

      hi ranman. can you post this link to download without going thru dropbox? I cannot download it. It keeps reloading again and again.Thanks

      Sorry, that's the site I use for file sharing.

      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: December 30, 2014, 11:17 pm - IP Logged

        Appreciate it, thanks.


          United States
          Member #128790
          June 2, 2012
          5431 Posts
          Offline
          Posted: December 30, 2014, 11:28 pm - IP Logged

          Appreciate it, thanks.

          I hate to keep complaining, but it's still not right.

          I got this,

          Last 2 Drws247
          Lowest here969
             
          Play Sets388
            288
            488
            378
            398
            387
            389

           

          The workout number is 278, not 388. 969+278=1247

          Also, the lowest number does not go on the bottom. Whatever the numbers are despite them being higher or lower is used in that fashion. I'm not looking for the difference between the two winning numbers per se, I'm adding upwards.

            ranman17's avatar - jzy6nr
            New York
            United States
            Member #83026
            November 27, 2009
            2132 Posts
            Offline
            Posted: December 31, 2014, 7:55 pm - IP Logged

            Sorry Onlymoney...I don't have the head for it.  I can get it to work one way or the other but because you must put the most recent draw on top and you are never sure if it is the higher or lower number.  I can make it so that after you do the math you enter you trigger number and it will give you your play set(s) but if that's not what you want I suggest you ask CarliG or Winsum.

             

            Happy New Year Everyone!

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

            An Unruly Evil

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

              hi ranman. any thoughts as to how to fix dropbox that keep loading again again. Thanks

                Avatar

                United States
                Member #41846
                June 23, 2006
                459 Posts
                Offline
                Posted: December 31, 2014, 9:55 pm - IP Logged

                Sorry Onlymoney...I don't have the head for it.  I can get it to work one way or the other but because you must put the most recent draw on top and you are never sure if it is the higher or lower number.  I can make it so that after you do the math you enter you trigger number and it will give you your play set(s) but if that's not what you want I suggest you ask CarliG or Winsum.

                 

                Happy New Year Everyone!

                Ranman 

                in col C2   =if(b2<b3,(b2+1000),b2

                in col c4      =c2-b3

                 

                change your formulas to reference this result

                  ranman17's avatar - jzy6nr
                  New York
                  United States
                  Member #83026
                  November 27, 2009
                  2132 Posts
                  Offline
                  Posted: January 1, 2015, 8:42 am - IP Logged

                  Ranman 

                  in col C2   =if(b2<b3,(b2+1000),b2

                  in col c4      =c2-b3

                   

                  change your formulas to reference this result

                  This one should work thanks to phileight.

                   

                  https://www.dropbox.com/s/3nznnqlh331knv0/OnlyMoneys%20New%20Years%20P3.xlsx?dl=0

                  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: January 1, 2015, 12:23 pm - IP Logged

                    Ranman 

                    in col C2   =if(b2<b3,(b2+1000),b2

                    in col c4      =c2-b3

                     

                    change your formulas to reference this result

                    phileight,

                     

                    Maybe you could help with this also.  This is something I have struggled with in the past. If you enter the following:

                    490

                    483

                    you get:

                    007

                    but excel does not recognize the 00 so you get bad results. If you need I can send you the spreadsheet unprotected.

                     

                    Thanks,

                    Ranman

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

                    An Unruly Evil

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

                      hi ranman maybe if you send it to me that way also it might just work. What do you think? worth a try.Banana

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

                        I noticed when I downloaded it says untitled as it loads again and again. Would this have anything to do with it. Thanks to anyone who help with this mess.

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

                          Let's wait and see if phileight is able to help with this last little bit and then I will email it to you.

                          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: January 1, 2015, 4:37 pm - IP Logged

                            Thanks ranmam and phileight.

                            Just one question, the sets below the 1/up and down, how did you get those? I like them.


                              United States
                              Member #128790
                              June 2, 2012
                              5431 Posts
                              Offline
                              Posted: January 1, 2015, 4:54 pm - IP Logged

                              Two items:

                              The first thing I noticed is that this works better when the top number is lower than the bottom number. This should cut down cost of play. Only play when this situation arises.

                              Example,

                              274

                              502

                               

                              The second thing I noticed was the sets below my one up/down sets. I don't know how ranman came up with those sets, but at least 60 to 70% of the time, If I do a 1 up/down on those, there will be a straight hit within 3 days.