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

Three Digit's are easy

Topic closed. 90 replies. Last post 6 years ago by Todd.

Page 4 of 7
PrintE-mailLink
Avatar
Poway CA (San Diego County)
United States
Member #3489
January 25, 2004
14120 Posts
Offline
Posted: January 10, 2006, 9:13 pm - IP Logged

Can anyone help me with an Excel formula? What I am looking to do is create a 3-digit number from 3 1-digit numbers. This is what my spreadsheet looks like for example:

P1P2P33Digit#
139???
442???

What I want the B4 cell to do is write 139, and the B5 formula to be 442, etc.

=(b1*100)+(b2*10)+b3

 

    cps10's avatar - Lottery-004.jpg
    The Carolinas - Charlotte
    United States
    Member #21627
    September 12, 2005
    4138 Posts
    Offline
    Posted: January 10, 2006, 9:16 pm - IP Logged

    Thanks CD...I can't believe I didn't think of that. Sheesh!

      paurths's avatar - underground
      Switching between Fairfax, VA and Belgium
      Belgium
      Member #19287
      July 29, 2005
      2254 Posts
      Offline
      Posted: January 10, 2006, 9:17 pm - IP Logged

      will this work when the digit is 0?

        truecritic's avatar - PirateTreasure
        Michigan
        United States
        Member #22395
        September 24, 2005
        1583 Posts
        Offline
        Posted: January 10, 2006, 9:29 pm - IP Logged

        casiecoco

        You were just online 2 minutes ago!  Don't know if you are still online or not?  You come in here and basically light up the board with your very first visit.  Then you don't comment?  You don't offer anything more?  You can't do that!

        ...Well, you can, but...

          Avatar
          Poway CA (San Diego County)
          United States
          Member #3489
          January 25, 2004
          14120 Posts
          Offline
          Posted: January 10, 2006, 9:31 pm - IP Logged

          will this work when the digit is 0?

          Yes.  I use it for all my wheels.

           

            Avatar
            Poway CA (San Diego County)
            United States
            Member #3489
            January 25, 2004
            14120 Posts
            Offline
            Posted: January 10, 2006, 9:36 pm - IP Logged

            will this work when the digit is 0?

            Yes.  I use it for all my wheels.

             

            The cells have to be formatted as "numbers" (no decimal places, of course).  And if there is a leading zero, it will be missing because with numbers in the "real" world leading zeros are not needed.  I take the column and copy it and then "paste special" into a column that is formatted as "text".  You paste "special" then click values.  Sort the second column, then type in any numbers that have a missing zero.  If you put in the missing zeros then sort, it will be all messed up! 

              paurths's avatar - underground
              Switching between Fairfax, VA and Belgium
              Belgium
              Member #19287
              July 29, 2005
              2254 Posts
              Offline
              Posted: January 10, 2006, 9:37 pm - IP Logged

              Is excel different in the USA?

              Here the columns are A, B, C, ...

              And the rows are the numbers...

              here the formula would be
              =(A1*100)+(B1*10)+C1

                cps10's avatar - Lottery-004.jpg
                The Carolinas - Charlotte
                United States
                Member #21627
                September 12, 2005
                4138 Posts
                Offline
                Posted: January 10, 2006, 9:55 pm - IP Logged

                Yeah, you would have to format those cells as text and type in the missing zero or zeroes in the cell. I have now created a spreadsheet whereby you input the top 5 numbers, and it gives you the combinations for the best 3, best 4 and best 5. Pretty neat.

                  Avatar
                  Poway CA (San Diego County)
                  United States
                  Member #3489
                  January 25, 2004
                  14120 Posts
                  Offline
                  Posted: January 10, 2006, 9:58 pm - IP Logged

                  Is excel different in the USA?

                  Here the columns are A, B, C, ...

                  And the rows are the numbers...

                  here the formula would be
                  =(A1*100)+(B1*10)+C1

                  Yes, you are right. 

                    Avatar
                    Poway CA (San Diego County)
                    United States
                    Member #3489
                    January 25, 2004
                    14120 Posts
                    Offline
                    Posted: January 11, 2006, 12:12 am - IP Logged

                    Here are my results from tonight's draws (13 states):


                    CalifDude Delaware Play 3 3-Way Box 6-9-6 6-6-9 $80
                    CalifDude Illinois Daily 3 3-Way Box 8-4-8 4-8-8 $80

                     

                      paurths's avatar - underground
                      Switching between Fairfax, VA and Belgium
                      Belgium
                      Member #19287
                      July 29, 2005
                      2254 Posts
                      Offline
                      Posted: January 11, 2006, 2:30 pm - IP Logged

                       Using best 3 digits: 503, 550, 005, 553, 335, 330, 003

                      Using best 4 digits: 503, 506, 536, 036, 550, 005, 553, 335, 556, 665, 003, 330, 006, 660, 336, 663

                      Using best 5 digits: 503, 506, 504, 536, 534, 564, 036, 034, 064, 364, 550, 005, 553, 335, 556, 665, 554, 445, 003, 330, 006, 660, 004, 440, 336, 663, 334, 443, 664, 446

                      Midday:
                      01/09: 547
                      01/10: 282
                      01/11: 474

                      Result: still 0, perhaps they will come the second part of the week.

                        truecritic's avatar - PirateTreasure
                        Michigan
                        United States
                        Member #22395
                        September 24, 2005
                        1583 Posts
                        Offline
                        Posted: January 11, 2006, 3:47 pm - IP Logged

                        Just a note, to keep everyone on the same page...paurths results are for Michigan.

                          paurths's avatar - underground
                          Switching between Fairfax, VA and Belgium
                          Belgium
                          Member #19287
                          July 29, 2005
                          2254 Posts
                          Offline
                          Posted: January 11, 2006, 7:43 pm - IP Logged

                           Using best 3 digits: 503, 550, 005, 553, 335, 330, 003

                          Using best 4 digits: 503, 506, 536, 036, 550, 005, 553, 335, 556, 665, 003, 330, 006, 660, 336, 663

                          Using best 5 digits: 503, 506, 504, 536, 534, 564, 036, 034, 064, 364, 550, 005, 553, 335, 556, 665, 554, 445, 003, 330, 006, 660, 004, 440, 336, 663, 334, 443, 664, 446

                          Midday:
                          01/09: 547
                          01/10: 282
                          01/11: 474

                          Result: still 0, perhaps they will come the second part of the week.

                          Evening:
                          01/09: 339
                          01/10: 089
                          01/11: 988

                            Avatar
                            Flint mi
                            United States
                            Member #29772
                            January 6, 2006
                            33 Posts
                            Offline
                            Posted: January 11, 2006, 8:01 pm - IP Logged

                            I am going to predict 603,605,503,635 will fall in the Michigan 3 digit mid or eve on thursday or saturday

                              paurths's avatar - underground
                              Switching between Fairfax, VA and Belgium
                              Belgium
                              Member #19287
                              July 29, 2005
                              2254 Posts
                              Offline
                              Posted: January 11, 2006, 8:12 pm - IP Logged

                              Don't worry about it, casieoco.
                              It just happens now and then. For evening the worst digit from last week, 9, hits all the time.
                              Playing the 5 (or 3) coldest numbers would have this last double into your account.
                              For midday playing the 4 coldest digits would have got the 282 double.

                              It's not been backtested fully, but the few weeks i tested shows that this is an ok-system.