Welcome Guest
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
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 ...

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

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

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

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..

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

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

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)

 E O H L I O 0 21 21 0 12 9
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.

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 ? ? ?
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)

 E O H L I O 0 21 21 0 12 9

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

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!!

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!!

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

ok , thank you,CARBOB

 Page 1 of 1