Welcome Guest
Log In | Register )
You last visited January 22, 2017, 7:07 am
All times shown are
Eastern Time (GMT-5:00)

Excel and Lotto Math

Topic closed. 8 replies. Last post 6 years ago by Best Picks.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: August 20, 2010, 8:44 pm - IP Logged

How does one formulate lotto math in excel?

Say I want to add 079 plus 444

In real math you get 523

in lotto math you get 413

Is there an Excel formula on can use to automatically get the 413?

Your help and expertice is greatly appreciated!

We are all Lucky... just some of us don't realize it!

    Rakster's avatar - praying hands.jpg
    Saskatchewan
    Canada
    Member #19992
    August 9, 2005
    2867 Posts
    Offline
    Posted: August 21, 2010, 11:40 am - IP Logged

    How does one formulate lotto math in excel?

    Say I want to add 079 plus 444

    In real math you get 523

    in lotto math you get 413

    Is there an Excel formula on can use to automatically get the 413?

    Your help and expertice is greatly appreciated!

    I figured it out..

    We are all Lucky... just some of us don't realize it!

      Raven62's avatar - binary
      New Jersey
      United States
      Member #17843
      June 28, 2005
      51178 Posts
      Offline
      Posted: August 21, 2010, 2:09 pm - IP Logged

      I figured it out..

      That's Good: How did you do it?

      A mind once stretched by a new idea never returns to its original dimensions!

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        Member #19992
        August 9, 2005
        2867 Posts
        Offline
        Posted: August 21, 2010, 2:37 pm - IP Logged

        That's Good: How did you do it?

        refered back to an excel program i had created a long time ago and them tinkered around with different things until it gave me whay i was looking for.... very hard on the head after a while...lol

        We are all Lucky... just some of us don't realize it!

          Raven62's avatar - binary
          New Jersey
          United States
          Member #17843
          June 28, 2005
          51178 Posts
          Offline
          Posted: August 21, 2010, 6:31 pm - IP Logged

          refered back to an excel program i had created a long time ago and them tinkered around with different things until it gave me whay i was looking for.... very hard on the head after a while...lol

          What was the Formula you came up with?

          A mind once stretched by a new idea never returns to its original dimensions!

            Avatar
            Michigan
            United States
            Member #53679
            July 16, 2007
            71 Posts
            Offline
            Posted: August 22, 2010, 10:32 am - IP Logged

            Yes, please.  What was the formula you came up with.  I am trying to do the same thing myself.

             

            Thanks for your help.

              Avatar

              United States
              Member #83701
              December 13, 2009
              225 Posts
              Offline
              Posted: August 29, 2010, 8:02 pm - IP Logged

              Yes, please.  What was the formula you came up with.  I am trying to do the same thing myself.

               

              Thanks for your help.

              Just treat each digit separately and take a modulus 10 of the sum.   It isn't really 079 and 444 but each digit is a separate number so it's 0-7-9 and 4-4-4 hence the "lotto math" result would in real math be (0+4)%10 - (7+4)%10 - (9+4)%10   In Excel, the modulus function is mod(num,divisor) hence if A1 B1 C1 was 079 and A2 B2 C2 was 444 then you would have A3=mod((A1+A2),10) B3=mod((B1+B2),10) and C3=mod((C1+C2),10)

              This is certainly not a stumper.   Just grade school stuff from as soon as you learned how to do fractions and knew what a remainder was.

              Of course, they're not even numbers, they're balls that are drawn.   No one in their right mind would try to add them lotto math or real math.   If you can't substitute in symbols like circles, squares, and triangles in instead of numbers and have your system still work then what you're doing has no relevance to the actual draw.   In reality you add a pick three draw of 079 with a pick three draw of 444, you get six balls labeled 079444.


                United States
                Member #93947
                July 10, 2010
                2180 Posts
                Offline
                Posted: August 31, 2010, 10:59 am - IP Logged

                Just treat each digit separately and take a modulus 10 of the sum.   It isn't really 079 and 444 but each digit is a separate number so it's 0-7-9 and 4-4-4 hence the "lotto math" result would in real math be (0+4)%10 - (7+4)%10 - (9+4)%10   In Excel, the modulus function is mod(num,divisor) hence if A1 B1 C1 was 079 and A2 B2 C2 was 444 then you would have A3=mod((A1+A2),10) B3=mod((B1+B2),10) and C3=mod((C1+C2),10)

                This is certainly not a stumper.   Just grade school stuff from as soon as you learned how to do fractions and knew what a remainder was.

                Of course, they're not even numbers, they're balls that are drawn.   No one in their right mind would try to add them lotto math or real math.   If you can't substitute in symbols like circles, squares, and triangles in instead of numbers and have your system still work then what you're doing has no relevance to the actual draw.   In reality you add a pick three draw of 079 with a pick three draw of 444, you get six balls labeled 079444.

                I think LotteryPost might benefit from adding a Facebook "Like" button.  It would save bandwidth and disk space.

                In the case of your post above:

                Like!

                  Best Picks's avatar - Lottery-036.jpg
                  Eastern Missouri
                  United States
                  Member #841
                  November 7, 2002
                  2430 Posts
                  Offline
                  Posted: September 11, 2010, 7:10 pm - IP Logged

                  Just treat each digit separately and take a modulus 10 of the sum.   It isn't really 079 and 444 but each digit is a separate number so it's 0-7-9 and 4-4-4 hence the "lotto math" result would in real math be (0+4)%10 - (7+4)%10 - (9+4)%10   In Excel, the modulus function is mod(num,divisor) hence if A1 B1 C1 was 079 and A2 B2 C2 was 444 then you would have A3=mod((A1+A2),10) B3=mod((B1+B2),10) and C3=mod((C1+C2),10)

                  This is certainly not a stumper.   Just grade school stuff from as soon as you learned how to do fractions and knew what a remainder was.

                  Of course, they're not even numbers, they're balls that are drawn.   No one in their right mind would try to add them lotto math or real math.   If you can't substitute in symbols like circles, squares, and triangles in instead of numbers and have your system still work then what you're doing has no relevance to the actual draw.   In reality you add a pick three draw of 079 with a pick three draw of 444, you get six balls labeled 079444.

                  thank you, this is just what i was looking for

                  Numbers.