Welcome Guest
Log In | Register )
You last visited December 3, 2016, 6:31 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 4 of 5
37
PrintE-mailLink

United States
Member #128790
June 2, 2012
5431 Posts
Offline
Posted: January 1, 2015, 5:02 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.

Have you tried uninstalling Open Office and reinstalling it?

    Avatar

    United States
    Member #41846
    June 23, 2006
    458 Posts
    Offline
    Posted: January 1, 2015, 5:03 pm - IP Logged

    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

    click the column(or columns) header to select  then right click and select format cells. select custom.  in the type box put three 000 if you want 3 digits (leading zero's) to always display

      txpolo's avatar - animaniacs16

      United States
      Member #173
      April 8, 2002
      6110 Posts
      Offline
      Posted: January 1, 2015, 5:06 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.

      onlymoney,

      could you do your workout on

      274

      502

      cuz I am lost  Wink

      Thanks

       BananaWTG all Winner$. Hyper

       

       

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

        click the column(or columns) header to select  then right click and select format cells. select custom.  in the type box put three 000 if you want 3 digits (leading zero's) to always display

        That's how it was formatted to begin with.  It does not recognize the 0's as numbers

        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, 5:09 pm - IP Logged

          onlymoney,

          could you do your workout on

          274

          502

          cuz I am lost  Wink

          Thanks

          Those two numbers, 274 and 502 were just an example. They are not from Florida's winning numbers.

          You don't have to do the workout anymore, thanks to ranman and phileight, they've automated it. Apache Open Office is free, just look it up on the net and download it.

          I'll do this one for you. The top sets are 1 up/down of 772. The bottom sets are from ranman. I don't know how he got those, but they are effective.

          Last 2 Drws274   
          Lowest here502   
                 
          Workout#772   
                 
          Play Sets672872 
            762782 
            771773 
                 
            172372 
            712732 
            776778 
                 
            ranman17's avatar - jzy6nr
            New York
            United States
            Member #83026
            November 27, 2009
            2132 Posts
            Offline
            Posted: January 1, 2015, 5:17 pm - IP Logged
            Last 2 Drws274   
            Lowest here502   
                   
            Workout#772   
                   
            Play Sets6728721st digit mirrored
              762782center digit mirrored
              771773Last digit mirrored
                   
              172372
              712732
              776778

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

            An Unruly Evil

              Avatar

              United States
              Member #41846
              June 23, 2006
              458 Posts
              Offline
              Posted: January 1, 2015, 5:21 pm - IP Logged

              That's how it was formatted to begin with.  It does not recognize the 0's as numbers

              after looking at your file   add val( )   to your left, right, and mid commands    ex  val(left(b2,1))  etc.

              excel treats the result of these commands as text sometimes  . adding the val  insures excel treats the result as a number

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

                after looking at your file   add val( )   to your left, right, and mid commands    ex  val(left(b2,1))  etc.

                excel treats the result of these commands as text sometimes  . adding the val  insures excel treats the result as a number

                I'll try it thanks.

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

                An Unruly Evil

                  lisette's avatar - chi

                  United States
                  Member #161069
                  November 15, 2014
                  57 Posts
                  Offline
                  Posted: January 1, 2015, 7:33 pm - IP Logged

                  thanks onlymoney and ranman!

                  I think because of how it's set up for the math you have to put larger draw on top

                  emilyg

                  717

                  286

                  531
                  431
                  631
                  521
                  541
                  530
                  532

                  Hi onlymoney,

                  This is brilliant work.  Thank you.  Just fyi...305 fell mid on 12/31. Don't know if this would help with tweaking the excel format.

                   

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

                    Hi onlymoney,

                    This is brilliant work.  Thank you.  Just fyi...305 fell mid on 12/31. Don't know if this would help with tweaking the excel format.

                    Here is the final product thanks to phileight.

                    https://www.dropbox.com/s/40eqcnqsmstwr49/OnlyMoneys%20New%20Years%20P3.xls?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
                      3582 Posts
                      Offline
                      Posted: January 1, 2015, 8:26 pm - IP Logged

                      Yes i did. even uninstalled dropbox.
                      Question; how do i download the link using open office?

                        kreative1's avatar - flower2
                        NE PA
                        United States
                        Member #127838
                        May 10, 2012
                        1230 Posts
                        Offline
                        Posted: January 1, 2015, 8:32 pm - IP Logged

                        Yes i did. even uninstalled dropbox.
                        Question; how do i download the link using open office?

                        download direct

                        at the bottom of screen it will then say

                        save or open

                        save to computer

                        then when it's done you will

                        open with office

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

                          the problem is when i hit direct it starts downloading again and again.

                            CARBOB's avatar - FL LOTTERY_LOGO.png
                            ORLANDO, FLORIDA
                            United States
                            Member #4924
                            June 3, 2004
                            5893 Posts
                            Offline
                            Posted: January 2, 2015, 11:40 am - IP Logged

                            the problem is when i hit direct it starts downloading again and again.

                            retxx,

                            I have no idea what is causing your problem. I installed Open Office, then downloaded the workbook direct. All works .

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

                              Thanks anyway. I guess i will need a genius to figure this one out.
                              Maybe someone can Do a step by step from square one to solve it. Thanks all.
                              Can we download it without using dropbox? maybe thats the answer.