Welcome Guest
Log In | Register )
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
PrintE-mailLink
SergeM's avatar - slow icon.png
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): 

4659017328

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.

    TasBob's avatar - 4NJ9EUA
    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.

    Help Please

                         Tks

    Procrastination Stops Progress ⇒Σ

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: May 11, 2015, 5:53 pm - IP Logged

      Try this:

      Digit0123456789
      Count554329101010
      Rank44678319101
      1------6--9
      2----------
      3-----5----
      401--------
      5----------
      6--2-------
      7---3------
      8----4-----
      9-------7--
      10--------8-

        SergeM's avatar - slow icon.png
        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:

        Digit0123456789.
        Count554329101010.
        Rank44678319101Count
        1------6--92
        2----------0
        3-----5----1
        401--------2
        5----------0
        6--2-------1
        7---3------1
        8----4-----1
        9-------7--1
        10--------8-1

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: May 11, 2015, 6:17 pm - IP Logged
          Digit0123456789........
          Count554329101010........
          Rank44678319101Count12345.
          1------6--9269.....
          2----------0.......
          3-----5----15......
          401--------201.....
          5----------0.......
          6--2-------12......
          7---3------13......
          8----4-----14......
          9-------7--17......
          10--------8-18......

          You are never stuck like this.

            TasBob's avatar - 4NJ9EUA
            Bowling Green ,Florida
            United States
            Member #108735
            March 30, 2011
            4091 Posts
            Offline
            Posted: May 11, 2015, 9:01 pm - IP Logged
            Digit0123456789........
            Count554329101010........
            Rank44678319101Count12345.
            1------6--9269.....
            2----------0.......
            3-----5----15......
            401--------201.....
            5----------0.......
            6--2-------12......
            7---3------13......
            8----4-----14......
            9-------7--17......
            10--------8-18......

            You are never stuck like this.

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

            Procrastination Stops Progress ⇒Σ

              Avatar

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

               

              #'sFreqRankResult329
              05=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)
              14=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)
              21=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A4+1),$B$2:$B$11,0))
              32=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A5+1),$B$2:$B$11,0))
              49=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A6+1),$B$2:$B$11,0))
              57=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A7+1),$B$2:$B$11,0))
              68=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A8+1),$B$2:$B$11,0))
              73=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A9+1),$B$2:$B$11,0))
              80=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A10+1),$B$2:$B$11,0))
              96=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A11+1),$B$2:$B$11,0))
                TasBob's avatar - 4NJ9EUA
                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)).

                 

                #'sFreqRankResult329
                05=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)
                14=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)
                21=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A4+1),$B$2:$B$11,0))
                32=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A5+1),$B$2:$B$11,0))
                49=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A6+1),$B$2:$B$11,0))
                57=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A7+1),$B$2:$B$11,0))
                68=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A8+1),$B$2:$B$11,0))
                73=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A9+1),$B$2:$B$11,0))
                80=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A10+1),$B$2:$B$11,0))
                96=INDEX($A$2:$A$11,MATCH(LARGE($B$2:$B$11,A11+1),$B$2:$B$11,0))

                ok Tks

                Procrastination Stops Progress ⇒Σ

                  Tialuvslotto's avatar - Jailin
                  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

                    Avatar

                    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?

                      Tialuvslotto's avatar - Jailin
                      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. 

                      Again, thanks for your help!

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

                      ~Robert A. Heinlein

                        lakerben's avatar - spherewall
                        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

                        How about them cowboys!

                         

                         

                        US Flag

                          SergeM's avatar - slow icon.png
                          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.

                            TasBob's avatar - 4NJ9EUA
                            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 ⇒Σ

                              RJOh's avatar - chipmunk
                              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 * 
                                 
                                           Evil Looking