sums of the even and odd digits separated from pick 4

Reply #13

dr san — Tue, 04 Nov 2014 11:53:51 GMT

ok , thank you,CARBOB

Reply #12

CARBOB — Tue, 04 Nov 2014 11:45:29 GMT

Be aware the LDS and Roots combos will be very uneven

Reply #11

dr san — Tue, 04 Nov 2014 10:55:58 GMT

ok.CARBOB, PREFECT,thank you

Reply #10

CARBOB — Tue, 04 Nov 2014 10:34:52 GMT

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

Reply #9

dr san — Tue, 04 Nov 2014 02:35:02 GMT

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

Reply #8

dr san — Mon, 03 Nov 2014 22:47:56 GMT

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

Reply #7

CARBOB — Mon, 03 Nov 2014 20:41:52 GMT

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

Reply #6

dr san — Mon, 03 Nov 2014 17:59:47 GMT

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 unfold... [ More ]

Reply #5

Lildarryl — Mon, 03 Nov 2014 15:02:50 GMT

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

Reply #4

Igamble — Mon, 03 Nov 2014 13:59:28 GMT

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

Reply #3

dr san — Mon, 03 Nov 2014 13:50:14 GMT

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

Reply #2

Lildarryl — Mon, 03 Nov 2014 12:28:09 GMT

Thanks another good filter idea

Reply #1

dr san — Mon, 03 Nov 2014 10:59:47 GMT

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

sums of the even and odd digits separated from pick 4

dr san — Mon, 03 Nov 2014 10:48:02 GMT

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