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

New Year's Pick-3 System

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

Page 4 of 5
PrintE-mailLink

United States
Member #128784
June 2, 2012
5431 Posts
Offline

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 #41845
    June 23, 2006
    674 Posts
    Offline

    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
      6114 Posts
      Offline

      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 - Monogram3
        New York
        United States
        Member #83024
        November 27, 2009
        2252 Posts
        Offline

        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 #128784
          June 2, 2012
          5431 Posts
          Offline

          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 - Monogram3
            New York
            United States
            Member #83024
            November 27, 2009
            2252 Posts
            Offline
            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 #41845
              June 23, 2006
              674 Posts
              Offline

              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 - Monogram3
                New York
                United States
                Member #83024
                November 27, 2009
                2252 Posts
                Offline

                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 #161062
                  November 15, 2014
                  59 Posts
                  Offline

                  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 - Monogram3
                    New York
                    United States
                    Member #83024
                    November 27, 2009
                    2252 Posts
                    Offline

                    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
                      3952 Posts
                      Offline

                      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 #127832
                        May 10, 2012
                        1393 Posts
                        Offline

                        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
                          3952 Posts
                          Offline

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

                            CARBOB's avatar - ga lottery.png.gif
                            COLUMBUS,GA.
                            United States
                            Member #4924
                            June 3, 2004
                            6703 Posts
                            Offline

                            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
                              3952 Posts
                              Offline

                              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.