Sum excel help. (Jade)Prev TopicNext Topic

• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Jul 26, 2017, 1:14 pm

  ▲▼

  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.

  Say hey!

   

  
• ithastobesaid

  

  United States
  Member #123,194
  February 15, 2012
  54 Posts
  Offline
  Jul 26, 2017, 1:26 pm

  ▲▼

  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(LOOKUP(INT(LEFT(TEXT(E3,"00"),1)),$A$4:$A$13,$B$4:$B$13)&LOOKUP(INT(RIGHT(TEXT(E3,"00"),1)),$A$4:$A$13,$B$4:$B$13))

  =INT(LOOKUP(INT(LEFT(TEXT(E4,"00"),1)),$A$4:$A$13,$B$4:$B$13)&LOOKUP(INT(RIGHT(TEXT(E4,"00"),1)),$A$4:$A$13,$B$4:$B$13))
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Jul 26, 2017, 3:42 pm

  ▲▼
  In response to ithastobesaid

  Quote: Originally posted by ithastobesaid on Jul 26, 2017

  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(LOOKUP(INT(LEFT(TEXT(E3,"00"),1)),$A$4:$A$13,$B$4:$B$13)&LOOKUP(INT(RIGHT(TEXT(E3,"00"),1)),$A$4:$A$13,$B$4:$B$13))

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

  I'll try and cut/paste these formulas.

  Thanks!

  Say hey!

   

  
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Jul 26, 2017, 5:19 pm

  ▲▼

  Simple setup

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

  or

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

  The One Over None
  I Know...
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Jul 26, 2017, 5:25 pm

  ▲▼
  In response to JADELottery

  Quote: Originally posted by JADELottery on Jul 26, 2017

  Simple setup

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

  or

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

  thanks!!!!!

   

  

  Say hey!

   

  
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Jul 26, 2017, 5:44 pm

  ▲▼
  In response to JADELottery

  Quote: Originally posted by JADELottery on Jul 26, 2017

  Simple setup

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

  or

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

  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

  Say hey!

   

  
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Jul 26, 2017, 5:56 pm

  ▲▼

  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

  Say hey!

   

  
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Jul 26, 2017, 7:25 pm

  ▲▼
  In response to lakerben

  Quote: Originally posted by lakerben on Jul 26, 2017

  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

  thanks for the tip.

  we'll have to watch for now.

  The One Over None
  I Know...
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Jul 26, 2017, 9:12 pm

  ▲▼
  In response to lakerben

  Quote: Originally posted by lakerben on Jul 26, 2017

  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

  048!

   

  

  Say hey!

   

  
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Jul 27, 2017, 12:45 am

  ▲▼
  In response to lakerben

  Quote: Originally posted by lakerben on Jul 26, 2017

  048!

   

  

  

  The One Over None
  I Know...
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Aug 2, 2017, 1:03 pm

  ▲▼

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

  Tweek.

  

  Say hey!

   

  
• JADELottery

  

  Native American Eagle Sun

  MN
  United States
  Member #21
  December 7, 2001
  4,812 Posts
  Offline
  Aug 3, 2017, 9:51 am

  ▲▼
  In response to lakerben

  Quote: Originally posted by lakerben on Aug 2, 2017

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

  Tweek.

  

  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.

  The One Over None
  I Know...
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Aug 4, 2017, 5:49 pm

  ▲▼
  In response to JADELottery

  Quote: Originally posted by JADELottery on Aug 3, 2017

  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.

  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	71	72	73
  10	8/4/2017	0	1	8		37	38	39	40		82	83	84	95

  Say hey!

   

  
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Aug 26, 2017, 9:45 pm

  ▲▼

  It's working thanks!

  Say hey!

   

  
• lakerben

  

  50

  New Mexico
  United States
  Member #86,096
  January 29, 2010
  25,043 Posts
  Offline
  Sep 10, 2017, 7:06 pm

  ▲▼

  Nm

  886

  Sum 22

  2 (5)+1=11

   

  11. 12. 13

  66. 67. 68

  Say hey!