Welcome Guest
Log In | Register )
You last visited December 9, 2016, 9:55 pm
All times shown are
Eastern Time (GMT-5:00)

Need help with Excel formulas

Topic closed. 2 replies. Last post 4 years ago by bobby623.

Page 1 of 1
PrintE-mailLink
bobby623's avatar - abstract
San Angelo, Texas
United States
Member #1097
January 31, 2003
1394 Posts
Offline
Posted: October 10, 2012, 6:56 pm - IP Logged

Need help with Excel formula.

I have a paper and pencil lottery system where having current 'follower' information is critical to lottery number selection.

In a pick 3 game, there are 9 follower streams that I need help with to reduce the amount of time bringing the 'strings' up to date.

Each string is broken down into 'triples' and 'pairs'

There are nine fixed column headers for the triples and 3 for the pairs.

What I need is way to automate the process whereby each time I add a number to the main string, the formula recognizes what triple is formed and the appropriate column is updated by addition of the third digit.

As for the pairs, any time a digit is added to the string, the formula would recognize what the follower is and add the appropriate digit to the Pairs column.

There might be a better way to describe what I'm talking about, but I don't know what it is.

Here then is a completed string (1 of 3), the triples and the pairs for a lottery game I'm tracking.

A1 - 2313312313132212232312321122213221132133111222311331121 (3)

 

Triples                                              PAIRS

11 12 13 21 22 23 31 32 33                1 2 3
  2   3   3  2   1   1   3   2  1                 3 3 1
  3   2   1  1   3   1   2   3  1                 2 3 3
  1   3   2   3   2   2   3   1  1                3 2 1
  2   2   2   3   3   3   3   1   1               3 1 1
  3   2   2   3   1   2   2   1                    2 2 1
  2   1   3  (3)  2   1   1                         2  3 2
           3         3        1                         1 3 2
                                                           2 3 1
                                                           2 1  2
                                                            1 2 2
                                                            3 2 2
                                                            3 1 3
                                                            1 2 1
                                                            1 1 1
                                                            2 1 3
                                                            1 1 1
                                                            3 2
                                                            1 2
                                                            2 2
                                                          (3) 3
                                                               1

(Will line up on graph paper)
 

If the next number in the A1 string is a 3, a 3 would be added to the 21 column under Triples. A 3 would also be added to the 1 column under Pairs 

The Triples and Pair columns would be updated each time one or more digits (maximum of 3) is added to the A1 string.

How is the data used??

Briefly, the end of the string is 21. The question is - what's next??

Based on the entries in the 21 column, I might choose '2'

However, there are other considerations. This is not the place to describe the whole workout.

I just need some help with the logging.

Please note that since there is no math involved in a lottery drawing, there is no math required for any of the data strings.

I'd appreciate any offer to help.

    bobby623's avatar - abstract
    San Angelo, Texas
    United States
    Member #1097
    January 31, 2003
    1394 Posts
    Offline
    Posted: October 11, 2012, 1:18 pm - IP Logged

     I failed to mention that there is a third string with 4 numbers, 0 7 8 9.

    This string also has three parts.

     

    Here is the string for the first part, C1

     

    978009798008978897970007880979909009888808877870899889707798777700977

    The column headers are:

     

    00 07 08 09 70 77 78 79 80 87 88 89 90 97 98 99      0  7  8  9

    Hope this doesn't make helping with this more difficult than it strings having on 3 numbers,
    1.2.3 and 4.5.6

    Bobby623

      bobby623's avatar - abstract
      San Angelo, Texas
      United States
      Member #1097
      January 31, 2003
      1394 Posts
      Offline
      Posted: October 18, 2012, 8:03 pm - IP Logged

      I've been told that I would have to explain the source of the number strings before anyone would
      offer to help.

      While I'm no expert, I don't think putting together a couple of plug-ins would require additional data.

      I'm not prepared to explain the base workout, again.

      Therefore, I withdraw my request for assistance.

      I'm kind of surprised that the strings haven't generated any interest.

      I mean, how many lottery number strings have the repetitions shown here?
      Lottery drawings are random, therefore, there shouldn't be any repeats. Right?

      Beg to differ.