Welcome Guest
You last visited December 7, 2016, 9:19 am
All times shown are
Eastern Time (GMT-5:00)

# Looking for ABCDEFGHIJKL converter to Digits Program or Excel

Topic closed. 38 replies. Last post 2 years ago by TasBob.

 Page 2 of 3
Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: May 11, 2015, 5:36 pm - IP Logged

That's the simple part, Serge.  The difficult part is having Excel look up the rank position of each digit that hit.

For example:

Ranks, from highest to lowest (based on frequency):

 4 6 5 9 0 1 7 3 2 8

Current result: 329  Formula should return 8,9,4  which could then be translated into H,I,D

Use Rank(). Break it down in steps, not all in one trick.

0 -> 9, with frequency. The amount of most frequent and less frequent numbers changes. Don't force a big square in a small round box.

You don't need to sort them. Use a look up function. They just post threads to piss you off.

Bowling Green ,Florida
United States
Member #108735
March 30, 2011
4091 Posts
Offline
 Posted: May 11, 2015, 5:36 pm - IP Logged

Code                A B C D E F G H I J     CODE
CODE NUMBER 1 2 3 4 5 6 7 8 9 0                  STR    BX
290                  8 4 7 2 6 9 0 5 3 1                467     467  BOX= LOWEST NUMBER FIRST
476                  2 0 5 1 3 7 6 4 8 9                 867    678

This is basic idea I'm looking for...After looking at this I see I may not be able to put in all

string numbers in , that's ok ..Just put in the winning number in the right position excel can do the rest.

Tks

Procrastination Stops Progress ⇒Σ

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: May 11, 2015, 5:53 pm - IP Logged

Try this:

 Digit 0 1 2 3 4 5 6 7 8 9 Count 5 5 4 3 2 9 10 1 0 10 Rank 4 4 6 7 8 3 1 9 10 1 1 - - - - - - 6 - - 9 2 - - - - - - - - - - 3 - - - - - 5 - - - - 4 0 1 - - - - - - - - 5 - - - - - - - - - - 6 - - 2 - - - - - - - 7 - - - 3 - - - - - - 8 - - - - 4 - - - - - 9 - - - - - - - 7 - - 10 - - - - - - - - 8 -

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: May 11, 2015, 6:01 pm - IP Logged

Extend the chart with what you like:

 Digit 0 1 2 3 4 5 6 7 8 9 . Count 5 5 4 3 2 9 10 1 0 10 . Rank 4 4 6 7 8 3 1 9 10 1 Count 1 - - - - - - 6 - - 9 2 2 - - - - - - - - - - 0 3 - - - - - 5 - - - - 1 4 0 1 - - - - - - - - 2 5 - - - - - - - - - - 0 6 - - 2 - - - - - - - 1 7 - - - 3 - - - - - - 1 8 - - - - 4 - - - - - 1 9 - - - - - - - 7 - - 1 10 - - - - - - - - 8 - 1

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: May 11, 2015, 6:17 pm - IP Logged
 Digit 0 1 2 3 4 5 6 7 8 9 . . . . . . . . Count 5 5 4 3 2 9 10 1 0 10 . . . . . . . . Rank 4 4 6 7 8 3 1 9 10 1 Count 1 2 3 4 5 … . 1 - - - - - - 6 - - 9 2 6 9 . . . . . 2 - - - - - - - - - - 0 . . . . . . . 3 - - - - - 5 - - - - 1 5 . . . . . . 4 0 1 - - - - - - - - 2 0 1 . . . . . 5 - - - - - - - - - - 0 . . . . . . . 6 - - 2 - - - - - - - 1 2 . . . . . . 7 - - - 3 - - - - - - 1 3 . . . . . . 8 - - - - 4 - - - - - 1 4 . . . . . . 9 - - - - - - - 7 - - 1 7 . . . . . . 10 - - - - - - - - 8 - 1 8 . . . . . .

You are never stuck like this.

Bowling Green ,Florida
United States
Member #108735
March 30, 2011
4091 Posts
Offline
 Posted: May 11, 2015, 9:01 pm - IP Logged
 Digit 0 1 2 3 4 5 6 7 8 9 . . . . . . . . Count 5 5 4 3 2 9 10 1 0 10 . . . . . . . . Rank 4 4 6 7 8 3 1 9 10 1 Count 1 2 3 4 5 … . 1 - - - - - - 6 - - 9 2 6 9 . . . . . 2 - - - - - - - - - - 0 . . . . . . . 3 - - - - - 5 - - - - 1 5 . . . . . . 4 0 1 - - - - - - - - 2 0 1 . . . . . 5 - - - - - - - - - - 0 . . . . . . . 6 - - 2 - - - - - - - 1 2 . . . . . . 7 - - - 3 - - - - - - 1 3 . . . . . . 8 - - - - 4 - - - - - 1 4 . . . . . . 9 - - - - - - - 7 - - 1 7 . . . . . . 10 - - - - - - - - 8 - 1 8 . . . . . .

You are never stuck like this.

ok Tks I'll take a closer look at it...

Procrastination Stops Progress ⇒Σ

United States
Member #123200
February 15, 2012
52 Posts
Offline
 Posted: May 12, 2015, 12:54 pm - IP Logged

These formulas will do what you want. (NOTE: The "#'s" is in Cell A1 of the spreadsheet (copy and paste would not show column/row headers)).

 #'s Freq Rank Result 3 2 9 0 5 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A2+1),\$B\$2:\$B\$11,0)) Rank =MATCH(E1,\$C2:\$C11,0) =MATCH(F1,\$C2:\$C11,0) =MATCH(G1,\$C2:\$C11,0) 1 4 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A3+1),\$B\$2:\$B\$11,0)) Letters =CHAR(64+E2) =CHAR(64+F2) =CHAR(64+G2) 2 1 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A4+1),\$B\$2:\$B\$11,0)) 3 2 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A5+1),\$B\$2:\$B\$11,0)) 4 9 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A6+1),\$B\$2:\$B\$11,0)) 5 7 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A7+1),\$B\$2:\$B\$11,0)) 6 8 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A8+1),\$B\$2:\$B\$11,0)) 7 3 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A9+1),\$B\$2:\$B\$11,0)) 8 0 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A10+1),\$B\$2:\$B\$11,0)) 9 6 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A11+1),\$B\$2:\$B\$11,0))
Bowling Green ,Florida
United States
Member #108735
March 30, 2011
4091 Posts
Offline
 Posted: May 12, 2015, 3:02 pm - IP Logged

These formulas will do what you want. (NOTE: The "#'s" is in Cell A1 of the spreadsheet (copy and paste would not show column/row headers)).

 #'s Freq Rank Result 3 2 9 0 5 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A2+1),\$B\$2:\$B\$11,0)) Rank =MATCH(E1,\$C2:\$C11,0) =MATCH(F1,\$C2:\$C11,0) =MATCH(G1,\$C2:\$C11,0) 1 4 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A3+1),\$B\$2:\$B\$11,0)) Letters =CHAR(64+E2) =CHAR(64+F2) =CHAR(64+G2) 2 1 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A4+1),\$B\$2:\$B\$11,0)) 3 2 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A5+1),\$B\$2:\$B\$11,0)) 4 9 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A6+1),\$B\$2:\$B\$11,0)) 5 7 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A7+1),\$B\$2:\$B\$11,0)) 6 8 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A8+1),\$B\$2:\$B\$11,0)) 7 3 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A9+1),\$B\$2:\$B\$11,0)) 8 0 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A10+1),\$B\$2:\$B\$11,0)) 9 6 =INDEX(\$A\$2:\$A\$11,MATCH(LARGE(\$B\$2:\$B\$11,A11+1),\$B\$2:\$B\$11,0))

ok Tks

Procrastination Stops Progress ⇒Σ

Texas
United States
Member #150797
December 31, 2013
815 Posts
Offline
 Posted: May 12, 2015, 3:57 pm - IP Logged

Thanks, ithastobesaid!  This wasn't exactly what I needed, but it gave me the clues to make my system work.  Greatly appreciate your generosity.

"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

~Robert A. Heinlein

United States
Member #123200
February 15, 2012
52 Posts
Offline
 Posted: May 12, 2015, 9:40 pm - IP Logged

Hi.  Glad I could help.  I am curious, how are you using the letters?  Pattern recognition?

Texas
United States
Member #150797
December 31, 2013
815 Posts
Offline
 Posted: May 13, 2015, 7:56 am - IP Logged

Hi.  Glad I could help.  I am curious, how are you using the letters?  Pattern recognition?

Basically, yeah.  It started with Bob P's "Power Trails" (see Lotto-Logix site), but now its more looking for positions that have repeated too many times or haven't hit for a long time.  For example, the highest frequency postition "A" may be associated with different numbers, but if it repeats 3 times in a row, I will ignore it, or if it hasn't hit for 15 games I will start looking for it.

"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

~Robert A. Heinlein

New Mexico
United States
Member #86099
January 29, 2010
11119 Posts
Offline
 Posted: May 13, 2015, 11:20 am - IP Logged

I use 0 to 9 along side the draws and it gives clear pattern over time.  I color in the number that hits.

123         0 1 2 3 4 5 6 7 8 9

456         0 1 2 3 4  5 6 7 8 9

123

451

267

618

222

183

Etc

Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
 Posted: May 14, 2015, 5:19 am - IP Logged

I'm looking into tracking digits for Straight Does any  happen to have a program that Tracks

ABCDEFGIJKL Turns to numbers ..or the other way around.

Tks

if(cell = 0, "A", if(cell = 1, "B" ... )))))))

if(cell = "A", 0, if(cell = "B", 1 ... )))))))

That is what you should have done before asking.
If you used a text like 012, you first put the digits into separate cells.
You can join them again by concatenation.

I just wonder why you did not find.

Bowling Green ,Florida
United States
Member #108735
March 30, 2011
4091 Posts
Offline
 Posted: May 14, 2015, 6:40 am - IP Logged

That's easy to answer ,,,I now nothing about excel formulas .... I'm just getting my feet wet..

I'v been going to threads that talk about Excel..Trying to see what i can pick up.  I'v seen some of

your posts , your are advance in excel,that's not where I'm at.. Also going to youtube ,,picking up

a few things there,and doing searches on excel... Got a lot of help here.Thank you all  that help me ,on

my journey to learn excel.

Let me tell you about myself ...I am a paper and pen guy, I'm good at what I do, been doing this for years.

I love the game and working on systems...I'm at the point now,where I putting in to much time on paper and pen.

I do use the tools here,and a few programs that I like to get info that I need...

Please don't tell me to stick with paper and pen, I'll do that along with Excel...

Tks      Tas

Procrastination Stops Progress ⇒Σ

mid-Ohio
United States
Member #9
March 24, 2001
19826 Posts
Offline
 Posted: May 14, 2015, 7:25 am - IP Logged

That's easy to answer ,,,I now nothing about excel formulas .... I'm just getting my feet wet..

I'v been going to threads that talk about Excel..Trying to see what i can pick up.  I'v seen some of

your posts , your are advance in excel,that's not where I'm at.. Also going to youtube ,,picking up

a few things there,and doing searches on excel... Got a lot of help here.Thank you all  that help me ,on

my journey to learn excel.

Let me tell you about myself ...I am a paper and pen guy, I'm good at what I do, been doing this for years.

I love the game and working on systems...I'm at the point now,where I putting in to much time on paper and pen.

I do use the tools here,and a few programs that I like to get info that I need...

Please don't tell me to stick with paper and pen, I'll do that along with Excel...

Tks      Tas

"Please don't tell me to stick with paper and pen"

Some members like paper and pen, they claim it's faster and easier than learning Excel or how to program.

* you don't need to buy more tickets, just buy a winning ticket *

 Page 2 of 3