Welcome Guest
Log In | Register )
You last visited January 20, 2017, 7:00 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 3 Substitution System - Texas Pick 3

Topic closed. 21 replies. Last post 3 years ago by winsumloosesum.

Page 1 of 2
41
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
Posted: August 14, 2013, 2:04 pm - IP Logged

This system was created for member Bobby623 for the Texas Pick 3 drawings.

If your interested in downloading the Excel files you will need to do the following:

1.  Create a new folder and name the folder: Texas Pick 3 (or whatever you want)

Download the following Excel files and place them into the new folder

The Excel files below are for anyone using Excel version 1997 through 2003

https://app.box.com/s/egv7v9gdpz5j9ce15ni4

https://app.box.com/s/9c9i95kra59p3ksdeajb

https://app.box.com/s/8bsw48xmsffwhdzxzjl3

https://app.box.com/s/te0rmaml1z9tdeug82xw

https://app.box.com/s/rbkihsc8tfwi2vz6vgk5

 

The Excel files below are for anyone using Excel Version 2007 or 2010.  I don't have Excel 2013 so I don't know if their might be any issues for these files will work:

https://app.box.com/s/8mzaoet9ui7x12zkedf6

https://app.box.com/s/vs8cyxvih0vk457acz0y

https://app.box.com/s/ssphlfmc2iroq19gkx6j

https://app.box.com/s/rgurnwjyl4fihs4lvlf9

https://app.box.com/s/9sj7fyay0cjvtsznigxh

https://app.box.com/s/ew36esxty4c085zc51qr

 

The Excel file you need to open 1st is called TexasPick3V6 (.xls or .xlsm)

This is the Excel file that needs to always remain open.

Once the TexasPick3V6 Excel file opens you can select from the Main Menu File > Open then browse to the folder where you downloaded the other Excel files and open any 1.

I will need to reveiw all the Excel files below later tonight.  It's been a few months since I used them.  The draw files are updated to yesterday Tuesday August 13, 2013.

Bobb623 will be adding some comments after this has been posted.

I will most likely add a Pick 4 similar based on Bobby623 recent Texas D4 Substituion System (Pick 4)

    ram's avatar - Lottery-002.jpg

    United States
    Member #11
    December 6, 2001
    75 Posts
    Offline
    Posted: August 15, 2013, 8:45 am - IP Logged

    Thanks winsum! You always step up to the plate. Its appreciated.

      bobby623's avatar - abstract
      San Angelo, Texas
      United States
      Member #1097
      January 31, 2003
      1405 Posts
      Offline
      Posted: August 15, 2013, 10:03 pm - IP Logged

      I have other business to attend to.
      Not much free time for lottery.
      Will try to offer some demonstrations next week.

      As far as the workout itself, I going to recommend some significant changes.
      Trying to understand trends and identify useful clues with current layout is just too complicated.
      The data needs to be centralized.

      Stay tuned

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Offline
        Posted: August 23, 2013, 10:05 am - IP Logged

        I updated the Texas Pick 3 Excel files based on booby123 Math thread post.  I noticed I made a number of formula errors but hopefully they are correct.

        Here is the download link to all the Excel files:

        https://app.box.com/s/fy1ukcrmz8eqwxopiqsi

        1.  Create a new folder and name it whatever you want. Example, Texas Pick 3

        2.  Just download the following 3 Excel files for now:

        a. TexasPick3V6

        b. BookD

        c. BookDPart2

        Open the Excel file TexasPick3V6 first.

        Here is a video on how to update the Pick 3 Texas Drawings:

        http://www.youtube.com/watch?v=f1lqdemXzBI

        I'll post some additional videos.

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5396 Posts
          Offline
          Posted: August 23, 2013, 10:30 am - IP Logged

          Here is video 2 explaining the Pick 3 Substitution formulas:

          http://www.youtube.com/watch?v=tkqLgOjRQ40

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5396 Posts
            Offline
            Posted: August 23, 2013, 11:34 am - IP Logged

            Video 3:

            Overview of Excel file BookD

            http://www.youtube.com/watch?v=Lx7k-zflW58

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5396 Posts
              Offline
              Posted: August 23, 2013, 12:22 pm - IP Logged

              This is a question for bobby123:

              This was taken from your Math Thread "What's next?

              Example:

              The last three entries in the Alphabetical string, as of 0728N drawing are AAB.

              ***I think you meant the 7/27/2013 drawing which was a Saturday and Texas does not have draws on Sunday.

              ***July 27, 2013 Texas Pick 3 Evening Drawing (N) was: 887  AAB  2100

               


              The Follower digits are determined by the Active Cell concept which counts
              the unmarked cells between data already in the string (ABC or R) and the same
              data being added.

              The last active cell added is 'B'


              The last two Follower digits are 12.


              ****In the screenshot above the last drawing for July 27 2013, Evening Draw was 887 AAB (row 22, 21, 20)

              887 = 412 AAB 2100

              The last letter was a "B"(row 20)

              On the far right side arrows are pointing to the draws if the letter "B" appeared in previous draws example, A,C,R,B,R

              My question is this how you calculate the "B"??  And below you list how many times an A, B, C, and R appeared after the "B".  How many past draws are you using?  Are you going back to June 1, 2013??

              Answer the What's next question by analyzing the Alphabetical matrix.
              B = A 44 times, B 50 times, C 36 times, R 21 times. 


              The choice made is the first of three letters needed to obtain a Straight
              combination for the next drawing.

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5396 Posts
                Offline
                Posted: August 23, 2013, 12:28 pm - IP Logged

                My next question also concerning Pairs where you posted the following:

                ***How many past drawings are you using??

                The user then can refer to the Follower string.


                The last digit is 2


                From the matrix:
                2 - 1 31 times, 4 46 times, 3 34 times 4 20 times.


                This process is done three times to obtain three Follower digits.

                ***I tke it the 1st process is using the 2?

                Is process 2 and 3 using the other 2 digits 1 & 1.  Or just 1 since it was repeated in the drawing?

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5396 Posts
                  Offline
                  Posted: August 23, 2013, 12:38 pm - IP Logged

                  Here are recent additions to the strings you already have.

                  GA:  BACCBRRBRRCCCARCARBCCCCBAAB
                  F#:   123134212131143333441112412

                   

                  I have the same results as your post.

                    Avatar
                    FL
                    United States
                    Member #93841
                    July 8, 2010
                    576 Posts
                    Offline
                    Posted: August 23, 2013, 1:43 pm - IP Logged

                    nice work winsum....i tried to tackle this system in excel and couldnt get my head around putting it together lol

                    Very nice work!!!

                    "It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5396 Posts
                      Offline
                      Posted: August 23, 2013, 2:15 pm - IP Logged

                      Here is an alternate download link:

                      https://app.box.com/s/lasyla0zz3edprvm3l27

                      I don't think bobby123 will be back for some time from the PM he sent me.

                      After reading bobby123 posts in the Math thread I found many calculation steps I did were in error.

                      I corrected most of them (I hope).

                      I still have a number of questions still unanswered.

                        lottoburg's avatar - wiggle
                        NYC
                        United States
                        Member #54483
                        August 20, 2007
                        887 Posts
                        Offline
                        Posted: August 23, 2013, 5:29 pm - IP Logged

                        Here is an alternate download link:

                        https://app.box.com/s/lasyla0zz3edprvm3l27

                        I don't think bobby123 will be back for some time from the PM he sent me.

                        After reading bobby123 posts in the Math thread I found many calculation steps I did were in error.

                        I corrected most of them (I hope).

                        I still have a number of questions still unanswered.

                        Hi, Steve:

                        Great job! Thumbs Up

                        Have a nice weekend,

                        lb

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5396 Posts
                          Offline
                          Posted: August 25, 2013, 9:19 am - IP Logged

                          I updated the Excel files.  Important:  You need all 3 Excel files opened in the sequence described below. 

                          I updated all the files again around 9:15 am Eastern Time for those who may have downloaded them earlier this morning.

                          1.  Open the TexasPick3V6 file 1st

                          2.  Open the BookD file 2nd (Select File > Open from the TexasPick3V6 Excel file

                          3.  Open the BookDPart2 last (Select File > Open from the BookD Excel file

                          Here is the download link to all the Exel files: remember you just need the 3

                          https://app.box.com/s/lasyla0zz3edprvm3l27

                          The only 3 files you need are TexasPick3V3, BookD, and BookDPart2

                          The BookDPart2 has been updated.  After going through Bobby's posts on how he makes his selections I think I calculated the same numbers.

                          Excel file BookDPart2 is where you would answer the questions "What's Next??". 

                          Option 1: make your next selection based on the "Alpabetical Analysis" & "Follower Sting"

                          Option 2: make your selection based on the Pair Chart

                          Both options described below:

                          I still have a few unanswered questions on a couple calculations but will have to wait until Bobby returns. 

                          Here is Bobby's Math thread posting.  NOTE: I corrected the draw date from 7/27 to 7/28

                          Example:

                          The last three entries in the Alphabetical string, as of 07/27/2013 evening drawing are AAB.
                          The Follower digits are determined by the Active Cell concept which counts
                          the unmarked cells between data already in the string (ABC or R) and the same
                          data being added.

                          The last active cell added is 'B'
                          The last two Follower digits are 12.

                          The user has two options.
                          Answer the What's next question by analyzing the Alphabetical matrix.
                          B = A 44 times, B 50 times, C 36 times, R 21 times.
                          The choice made is the first of three letters needed to obtain a Straight
                          combination for the next drawing.

                          Sometimes, the Alphabetical analysis provides results that are
                          'too close to choose'.

                          The user then can refer to the Follower string.
                          The last digit is 2
                          From the matrix
                          2 - 1 31 times, 4 46 times, 3 34 times 4 20 times.
                          This process is done three times to obtain three Follower digits.

                          Or,

                          The user can refer to the Pair chart.
                          The last pair is 12
                          The secondary followers for Pair 12 are:
                          233214222433112423322311111331

                          What I do is evaluate the string and try to figure out (guess) what digit might
                          follow the last digit  - 1.

                          Examining the string, I note the following

                          1 - 4,1,2,1.1.1,1,1,3.

                          I think I would choose 1 as the next follower for pair 12.

                          I would refer to the Alphabetical string.
                          Beginning the count from the last entry B, I would count one active cell up the string, which would be a B, the first of the three letters I need for the alphabetical structure.

                          I would then have to repeat the procedure for Pair 21, and the next pair in order to
                          get three Alphabetical letters.

                          I usually go with the results from the Alphabetical string, using the Follower string as a backup.

                          Hope this makes sense??

                          What you are doing is coming up with a more precise, analytical method for finding
                          answers to the What's Next question for all of the 16 pair follower strings.

                          BTW

                          Here are recent additions to the strings you already have.

                          GA:  BACCBRRBRRCCCARCARBCCCCBAAB
                          F#:   123134212131143333441112412

                          Questions

                          The strings are getting longer and longer.
                          Should there be a cutoff at some point??
                          Just use the last 300, 400 or other?
                          However, even with the current total, the Pair follower strings are short.
                          Pair 22 is the leader with 45 followers.
                          Pair 24 has 18 followers.

                          What do you think??

                          Suggestion:  Because the sum for Pairs 12 and 21 is 3, wouldn't it be better to use
                          substitution and give each Pair a unique ID??? to facilitate tracking???

                          Your final product would be used for multiple lottery games.
                          A sort of Universal scheme could be helpful.

                          I'm still evaluating your presentation.

                          As for going vertical, I mentioned that because all of my working charts has data
                          in columns.

                          But, if the data is being created by a mathematical formula, algorithum or other
                          means, I guess it wouldn't matter.

                          Again, thanks for your hard work.

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5396 Posts
                            Offline
                            Posted: August 25, 2013, 2:39 pm - IP Logged

                            I updated the Excel files and also created 2 additional Excel files for "Pairs" both Alpha and Numerical ("F" String).

                            The charts will calculate the "next" single Alpha or Digit depending on what Excel file you have opened.

                            There is a Totals for what Alpha / Digit followed. 

                            Here is the link to the Youtube video with a better explanation.  The video also pertains to the Alpha Pairs Excel file also.

                            http://www.youtube.com/watch?v=RP-cPEIg3Xw

                             

                            The Excel files were updated at 2:30 Eastern Time.

                            https://app.box.com/s/lasyla0zz3edprvm3l27

                              bobby623's avatar - abstract
                              San Angelo, Texas
                              United States
                              Member #1097
                              January 31, 2003
                              1405 Posts
                              Offline
                              Posted: August 28, 2013, 12:53 pm - IP Logged

                              Substitute Lottery System

                              The Substitute Lottery System is a systematic workout  that presents a detailed picture of where a lottery game has been and where it might be headed in future.

                              It is based on the premise that a lottery game with fixed dimensions exhibit certain
                              trends that attentive players can identify and take advantage of.

                              The workout requires a User to establish and maintain a variety of  inventory (how many) and tracking charts (how often) having dedicated purposes for the game of interest.

                              It is NOT a prediction system, per se.
                              There are no features whereby a user can obtain ready to play combinations.

                              The User evaluates the trend lines for clues that aid the selection of specific lottery digits and/or numbers for play, and makes specific choices.

                              An important consideration is that the digits are OBJECTS having NO quantitative value. There are no roots, sums, VTRACS, highs, lows, odds, evens  or any other mathematical function.

                              The SLS workout has its own terminology which is not generally compatiable or applicable
                              to traditional workouts.

                              The SLS workout uses winning lottery digits to "trigger" certain actions, namely creation
                              of Base Foundation, which is used, in turn, to create various inventory and tracking
                              charts having multiple 'trend lines.'

                              Keep in mind that official lotteries use various and very effective methods to ensure that winning combinations are randomly generated.

                              There are no known private lottery workouts that can accurately generate combinations
                              that match the official winning numbers on a consistent basis.

                              This workout provides useful data but it's up to the User to employ  his/her experience,  intuition and other mental attributes to correctly choose (guess) winning combinations.

                              Whether or not combinations based on SLS workout will match winning combinations. of course,
                              is a matter of 'chance' and 'luck'.

                              Personally, I have used SLS for several years. While I have not won a jackpot, many
                              of my choices were correct often enough to make all the work worthwhile.

                              Thanks for your interest.