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

sums of the even and odd digits separated from pick 4

Topic closed. 13 replies. Last post 2 years ago by dr san.

Page 1 of 1
4.52
PrintE-mailLink
Avatar
bgonçalves
Brasil
Member #92564
June 9, 2010
2123 Posts
Offline
Posted: November 3, 2014, 5:48 am - IP Logged

Sums of the even and odd digits separated from pick4
  instance
4583 = odd sum = 5.3 = 4.8 = 8 pairs odd sum = 12 8, and 12 pair
Now need to see positions, finding the correct positions facilitates
You can do the sums separately from biaco / high. Inside? out etc.
Example = 8639 = odd = 39 = 12 = 86 = 14 pair, low high = 3 = 23 etc ...

    Avatar
    bgonçalves
    Brasil
    Member #92564
    June 9, 2010
    2123 Posts
    Offline
    Posted: November 3, 2014, 5:59 am - IP Logged

    Sums of the even and odd digits separated from pick4
      instance
    4583 = odd sum = 5.3 = 4.8 = 8 pairs odd sum = 12 8, and 12 pair
    Now need to see positions, finding the correct positions facilitates
    You can do the sums separately from biaco / high. Inside? out etc.
    Example = 8639 = odd = 39 = 12 = 86 = 14 pair, low high = 3 = 23 etc ...

    The problem or challenge is knowing the quantities of odd and even, high or low
    And in that position !!
      Example 6 = sum pair himself or 5 + 1 = 6

      Avatar
      backwoods ga
      United States
      Member #155844
      May 31, 2014
      1890 Posts
      Offline
      Posted: November 3, 2014, 7:28 am - IP Logged

      Thanks   another good filter idea

        Avatar
        bgonçalves
        Brasil
        Member #92564
        June 9, 2010
        2123 Posts
        Offline
        Posted: November 3, 2014, 8:50 am - IP Logged

        Hello.lildarry, that would make all possible sums of the even and odd (table) as is done in the overall sum. Hitting the amount of odd and even, greatly facilitates
        Example 1567 = odd sum = 13 and 6 par amount of imparea is three digits = 1,5,7 Par = one digit 6 Another example
        8694 = quantity of pairs three digits 6,8,4 = 18 odd sum = 9

          Igamble's avatar - spider
          nj
          United States
          Member #145657
          August 10, 2013
          974 Posts
          Online
          Posted: November 3, 2014, 8:59 am - IP Logged

          Nice idea ! And you explained it better on this topic; this time your english was easier  to understand..

            Avatar
            backwoods ga
            United States
            Member #155844
            May 31, 2014
            1890 Posts
            Offline
            Posted: November 3, 2014, 10:02 am - IP Logged

            You can do low sum and high sum also

            In sum and out sum

             

            Example 

            0488

            Low4

            High 16

             

            Or 3854

            In 12

            Out 8

             

            They hardly repeat one draw to amother

              Avatar
              bgonçalves
              Brasil
              Member #92564
              June 9, 2010
              2123 Posts
              Offline
              Posted: November 3, 2014, 12:59 pm - IP Logged

              Hello. Well, you have 5 conditions in pick4
              odd Couple
              4 0
              3 1
              2 2
              1 3
              4 0
              Example 1 2.2 = 4596 = 5671 = 1x3 other
              We also have 2 positions in the 5 standards
              3 In 2x2 have six positions = 1.2 1.3 1.4 2.4 2.3 3.4
              In 3x1 = 4 1,2,3 1,2,4 2,3,4
              5 So you positionally located odd and even, in there too low / high and others, we need someone who knows excel 2010 or higher to see these patterns in each vertical position, what matters is setting the standard, then unfolds, or or this is not the standard

                CARBOB's avatar - FL LOTTERY_LOGO.png
                ORLANDO, FLORIDA
                United States
                Member #4924
                June 3, 2004
                5901 Posts
                Offline
                Posted: November 3, 2014, 3:41 pm - IP Logged

                Excel formulas, for sums, that will work on Cash 3, Play 4, Lexi and Last digits. Just change the ranges.

                 

                EVEN =SUMPRODUCT(--(MOD($C20:$E20,2)=0),$C20:$E20)

                ODD   =SUMPRODUCT(MOD($C20:$E20,2),$C20:$E20)

                HIGH  =SUMIF($C20:$E20,">=5")

                LOW    =SUMIF($C20:$E20,"<5")

                IN        =SUMPRODUCT(--($C20:$E20>=3),--($C20:$E20<=7),$C20:$E20)

                OUT      =SUMPRODUCT(($C20:$E20<2)+($C20:$E20>7),$C20:$E20) 

                 

                 

                EOHLIO
                021210129
                  Avatar
                  bgonçalves
                  Brasil
                  Member #92564
                  June 9, 2010
                  2123 Posts
                  Offline
                  Posted: November 3, 2014, 5:47 pm - IP Logged

                  Hello carbon, perfect, congratulations !!!, now you can see patterns emerging digits then or not then the patterns, very good job.

                    Avatar
                    bgonçalves
                    Brasil
                    Member #92564
                    June 9, 2010
                    2123 Posts
                    Offline
                    Posted: November 3, 2014, 9:35 pm - IP Logged

                    pick4

                    draws

                    E

                    O

                    H

                    L

                    I

                    O

                    4

                    5

                    8

                    3

                    12

                    8

                    13

                    7

                    12

                    8

                    0

                    8

                    6

                    9

                    14

                    9

                    23

                    0

                    6

                    17

                    9

                    8

                    9

                    0

                    8

                    18

                    26

                    0

                    0

                    26

                    8

                    8

                    1

                    0

                    ?

                    ?

                    ?

                    ?

                    3

                    5

                    6

                    3

                    ?

                    ?

                    ?

                      CARBOB's avatar - FL LOTTERY_LOGO.png
                      ORLANDO, FLORIDA
                      United States
                      Member #4924
                      June 3, 2004
                      5901 Posts
                      Offline
                      Posted: November 4, 2014, 5:34 am - IP Logged

                      Excel formulas, for sums, that will work on Cash 3, Play 4, Lexi and Last digits. Just change the ranges.

                       

                      EVEN =SUMPRODUCT(--(MOD($C20:$E20,2)=0),$C20:$E20)

                      ODD   =SUMPRODUCT(MOD($C20:$E20,2),$C20:$E20)

                      HIGH  =SUMIF($C20:$E20,">=5")

                      LOW    =SUMIF($C20:$E20,"<5")

                      IN        =SUMPRODUCT(--($C20:$E20>=3),--($C20:$E20<=7),$C20:$E20)

                      OUT      =SUMPRODUCT(($C20:$E20<2)+($C20:$E20>7),$C20:$E20) 

                       

                       

                      EOHLIO
                      021210129

                      The Out formula is wrong, if you use digits 0,1,2,8,9 as the Out digits, change the formula to

                      OUT      =SUMPRODUCT(($C20:$E20<3)+($C20:$E20>7),$C20:$E20) 

                      I had it set for Sedertrees 60/40.

                      Sorry, if I confused you.

                      Now if you wish to track those sums as LDS and Roots.

                      LDS= MOD(H2,10) will be your Sum cell

                      Root=IF(H2>0,1+MOD(H2-1,9),0) same as above

                        Avatar
                        bgonçalves
                        Brasil
                        Member #92564
                        June 9, 2010
                        2123 Posts
                        Offline
                        Posted: November 4, 2014, 5:55 am - IP Logged

                        ok.CARBOB, PREFECT,thank you!!

                          CARBOB's avatar - FL LOTTERY_LOGO.png
                          ORLANDO, FLORIDA
                          United States
                          Member #4924
                          June 3, 2004
                          5901 Posts
                          Offline
                          Posted: November 4, 2014, 6:45 am - IP Logged

                          The Out formula is wrong, if you use digits 0,1,2,8,9 as the Out digits, change the formula to

                          OUT      =SUMPRODUCT(($C20:$E20<3)+($C20:$E20>7),$C20:$E20) 

                          I had it set for Sedertrees 60/40.

                          Sorry, if I confused you.

                          Now if you wish to track those sums as LDS and Roots.

                          LDS= MOD(H2,10) will be your Sum cell

                          Root=IF(H2>0,1+MOD(H2-1,9),0) same as above

                          Be aware the LDS and Roots combos will be very uneven!!

                            Avatar
                            bgonçalves
                            Brasil
                            Member #92564
                            June 9, 2010
                            2123 Posts
                            Offline
                            Posted: November 4, 2014, 6:53 am - IP Logged

                            ok , thank you,CARBOB