Sum excel help. (Jade)

Reply #14

lakerben — Sun, 10 Sep 2017 23:06:57 GMT

Nm

886

Sum 22

2 (5)+1=11

11. 12. 13

66. 67. 68

Reply #13

lakerben — Sun, 27 Aug 2017 01:45:42 GMT

It's working thanks

Reply #12

lakerben — Fri, 04 Aug 2017 21:49:04 GMT

It looks like so far so good on the sum program. The dates are not correct.

nm p3

1 7/26/2017 0 0 7 41 42 43 44 96 97 98 99

2 7/27/2017 0 4 5 37 38 39 40 82 83 84 95

3 7/28/2017 5 2 8 25 26 27 28 70 71 72 73

4 7/29/2017 6 7 8 13 14 15 16 68 69 60 61

5 7/30/2017 4 0 3 41 42 43 44 96 97 98 99

6 7/31/2017 4 6 8 19 20 21 22 64 75 76 77

7 8/1/2017 7 3 8 19 20 21 22 64 75 76 77

8 8/2/2017 9 0 3 31 32 33 34 86 87 88 89

9 8/3/2017 4 6 5 25 26 27 28 70... [ More ]

Reply #11

JADELottery — Thu, 03 Aug 2017 13:51:36 GMT

good to see you're trying a different calcx.

it might be helpful to discover all possible outcomes.

that would give a wider perspective on the possibilities.

Reply #10

lakerben — Wed, 02 Aug 2017 17:03:24 GMT

I'm even using the sum squared to get pairs 13 gave me 169. Last night 106.

Tweek.

Reply #9

JADELottery — Thu, 27 Jul 2017 04:45:45 GMT

Reply #8

lakerben — Thu, 27 Jul 2017 01:12:54 GMT

048

Reply #7

JADELottery — Wed, 26 Jul 2017 23:25:39 GMT

thanks for the tip.

we'll have to watch for now.

Reply #6

lakerben — Wed, 26 Jul 2017 21:56:12 GMT

Your state MN.

0 9 9 19 20 21 22 64 75 76 77

3 7 2 31 32 33 34 86 87 88 89

9 8 6 09 10 11 12 54 65 66 67

5 9 3 21 22 23 24 76 77 78 79

3 8 9 15 16 17 18 60 61 62 63

The last draw with the draw,the mirror,and the total.

0 9 9 19 20 21 22 64 75 76 77

5 4 4 29 30 31 32 74 85 86 87

9 0 0 37 38 39 40 82 83 84 95

Reply #5

lakerben — Wed, 26 Jul 2017 21:44:07 GMT

It works great!

I used the previous draw 816 and it hit yesterdays 018. I use the draw,the mirror,and the total.

8 1 6 25 26 27 28 70 71 72 73

3 6 1 35 36 37 38 80 81 82 83

1 8 3 31 32 33 34 86 87 88 89

For tonight:

0 4 8 31 32 33 34 86 87 88 89

5 9 3 21 22 23 24 76 77 78 79

9 5 1 25 26 27 28 70 71 72 73

Reply #4

lakerben — Wed, 26 Jul 2017 21:25:03 GMT

thanks

Reply #3

JADELottery — Wed, 26 Jul 2017 21:19:24 GMT

Simple setup

http://www.jadexcode.com/Files/Excel/LB-27-SUM-00.xlsx

or

ftp://www.jadexcode.com/Excel/LB-27-SUM-00.xlsx

Reply #2

lakerben — Wed, 26 Jul 2017 19:42:10 GMT

I'll try and cut/paste these formulas.

Thanks

Reply #1

ithastobesaid — Wed, 26 Jul 2017 17:26:04 GMT

Put your #'s in cells A1,B1,C1 (the 0,1,8)

List 0-9 in A4:A13 and the mirrors in B4:B13

in E1:E4 put the following formulas:

=2*(27-SUM(A1:C1))+1

=E1+1

=E2+1

=E3+1

In F1:F4 put the following formulas:

=INT(LOOKUP(INT(LEFT(TEXT(E1, 00 ),1)),$A$4:$A$13,$B$4:$B$13) LOOKUP(INT(RIGHT(TEXT(E1, 00 ),1)),$A$4:$A$13,$B$4:$B$13))

=INT(LOOKUP(INT(LEFT(TEXT(E2, 00 ),1)),$A$4:$A$13,$B$4:$B$13) LOOKUP(INT(RIGHT(TEXT(E2, 00 ),1)),$A$4:$A$13,$B$4:$B$13))

=INT... [ More ]

Sum excel help. (Jade)

lakerben — Wed, 26 Jul 2017 17:14:23 GMT

Jade can you program this for upload?

2n+1

N=27-sum

018

Sum 9

N=27-9=18.

2 (18)+1

37. 38 39 40. Then mirror.

82. 83 84. 95

Or use the sum instead of 27 minus.