Welcome Guest
Log In | Register )
You last visited September 25, 2017, 3:57 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 1 of 3
PrintE-mailLink
TasBob's avatar - 4NJ9EUA
Thread Starter
Bowling Green ,Florida
United States
Member #108735
March 30, 2011
4481 Posts
Offline
Posted: May 11, 2015, 11:13 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

Procrastination Stops Progress ⇒Σ

    Tialuvslotto's avatar - Jailin
    Texas
    United States
    Member #150797
    December 31, 2013
    824 Posts
    Offline
    Posted: May 11, 2015, 11:31 am - IP Logged

    I'm looking for something similar. 

    I have the digits sorted by frequency (1-10 or A-J).  I would like to see the hits by ranked position -- i.e. if 5=highest frequency then I would like to report that hit as "1" or "A".

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

    ~Robert A. Heinlein

      theo1946's avatar - spherewall
      Bakersfield, Ca
      United States
      Member #89877
      April 17, 2010
      211 Posts
      Offline
      Posted: May 11, 2015, 12:34 pm - 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

      Is this what you are looking for. The settings can be changed on page 2.

      https://www.dropbox.com/s/9ul19nhc7nh29yn/work%20in%20progress.xlsx?dl=0

        TasBob's avatar - 4NJ9EUA
        Thread Starter
        Bowling Green ,Florida
        United States
        Member #108735
        March 30, 2011
        4481 Posts
        Offline
        Posted: May 11, 2015, 1:07 pm - IP Logged

        Is this what you are looking for. The settings can be changed on page 2.

        https://www.dropbox.com/s/9ul19nhc7nh29yn/work%20in%20progress.xlsx?dl=0

        Thank You .... But not what I'm looking for..

        Procrastination Stops Progress ⇒Σ

          Tialuvslotto's avatar - Jailin
          Texas
          United States
          Member #150797
          December 31, 2013
          824 Posts
          Offline
          Posted: May 11, 2015, 1:11 pm - IP Logged

          Thanks, Theo1946.  Nice use of Excel to build combinations from current pairs, but nothing to do with the request.  Perhaps you linked to a different spreadsheet?

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

          ~Robert A. Heinlein

            TasBob's avatar - 4NJ9EUA
            Thread Starter
            Bowling Green ,Florida
            United States
            Member #108735
            March 30, 2011
            4481 Posts
            Offline
            Posted: May 11, 2015, 1:12 pm - IP Logged

            I'm looking for something similar. 

            I have the digits sorted by frequency (1-10 or A-J).  I would like to see the hits by ranked position -- i.e. if 5=highest frequency then I would like to report that hit as "1" or "A".

            The sorter sounds nice...  I'm looking for ABC Patterns, for Straight hits..

            Doing it my hand now but it's a pain. Maybe Some one will help.

            Procrastination Stops Progress ⇒Σ

              lakerben's avatar - Lottery-019.jpg
              New Mexico
              United States
              Member #86099
              January 29, 2010
              11853 Posts
              Offline
              Posted: May 11, 2015, 1:24 pm - IP Logged

              Is this what you are looking for. The settings can be changed on page 2.

              https://www.dropbox.com/s/9ul19nhc7nh29yn/work%20in%20progress.xlsx?dl=0

              Nice Theo!

              Lurking

              SHOW YOUR WORK TO MAKE IT EASY TO UNDERSTAND YOUR POSTS.

                Harve$t Moon's avatar - 5str

                United States
                Member #76986
                July 10, 2009
                8244 Posts
                Offline
                Posted: May 11, 2015, 1:28 pm - IP Logged

                Is this what you are looking for. The settings can be changed on page 2.

                https://www.dropbox.com/s/9ul19nhc7nh29yn/work%20in%20progress.xlsx?dl=0

                May we have Pick 4 added this sheet, theo1946? Thanks!

                Image result for thanks

                  SergeM's avatar - slow icon.png
                  Economy class
                  Belgium
                  Member #123700
                  February 27, 2012
                  4035 Posts
                  Offline
                  Posted: May 11, 2015, 2:01 pm - 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

                  0 = 0, 1 = 1 ... A = 10, B = 11 ...

                  Create a look-up-table. Put it somewhere in your Excel workbook. Give it a name.
                  For conversion, use a look up function like vertical look up.
                  I gave a VBA code in a thread, look it up.

                    TasBob's avatar - 4NJ9EUA
                    Thread Starter
                    Bowling Green ,Florida
                    United States
                    Member #108735
                    March 30, 2011
                    4481 Posts
                    Offline
                    Posted: May 11, 2015, 2:39 pm - IP Logged

                    0 = 0, 1 = 1 ... A = 10, B = 11 ...

                    Create a look-up-table. Put it somewhere in your Excel workbook. Give it a name.
                    For conversion, use a look up function like vertical look up.
                    I gave a VBA code in a thread, look it up.

                    Ok Tks

                    Procrastination Stops Progress ⇒Σ

                      Tialuvslotto's avatar - Jailin
                      Texas
                      United States
                      Member #150797
                      December 31, 2013
                      824 Posts
                      Offline
                      Posted: May 11, 2015, 3:04 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

                      "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 #15034
                        May 8, 2005
                        71 Posts
                        Offline
                        Posted: May 11, 2015, 3:13 pm - IP Logged

                        lotto buster 2010 does this and more .

                          theo1946's avatar - spherewall
                          Bakersfield, Ca
                          United States
                          Member #89877
                          April 17, 2010
                          211 Posts
                          Offline
                          Posted: May 11, 2015, 3:34 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

                          Maybe this will help.

                          https://www.dropbox.com/s/yhl6w086c0velxu/carlig%20formula.xlsx?dl=0

                            TasBob's avatar - 4NJ9EUA
                            Thread Starter
                            Bowling Green ,Florida
                            United States
                            Member #108735
                            March 30, 2011
                            4481 Posts
                            Offline
                            Posted: May 11, 2015, 3:52 pm - IP Logged

                            lotto buster 2010 does this and more .

                            Tks      But what i need is a one page excel sheet to convert letters to numbers or numbers to letters

                            Procrastination Stops Progress ⇒Σ

                              TasBob's avatar - 4NJ9EUA
                              Thread Starter
                              Bowling Green ,Florida
                              United States
                              Member #108735
                              March 30, 2011
                              4481 Posts
                              Offline
                              Posted: May 11, 2015, 3:58 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

                              Not sure maybe this will Help

                               

                                                                 http://www.lotterypost.com/thread/288243/4066219

                              Procrastination Stops Progress ⇒Σ