Share

sums of the even and odd digits separated from pick 4

Avatar

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
In response to dr san

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

Thanks   another good filter idea

Avatar

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

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

Avatar

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

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 - ga lottery.png.gif

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

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

Avatar

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 - ga lottery.png.gif
In response to CARBOB

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

ok.CARBOB, PREFECT,thank you!!

CARBOB's avatar - ga lottery.png.gif
In response to CARBOB

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

Avatar

ok , thank you,CARBOB

TopEnd of thread (1 page)

Welcome Guest

Your last visit: Sun, Sep 19, 2021, 3:02 pm

Log In

Log InCancel

Forgot your username?

Forgot your password?