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

My Pick-4 Work Out 1 2 3 1

Topic closed. 48 replies. Last post 13 years ago by kekmaklu.

Page 3 of 4
PrintE-mailLink
emilyg's avatar - cat anm.gif

United States
Member #14
November 9, 2001
31347 Posts
Offline
Posted: December 22, 2003, 6:02 pm - IP Logged

let us know.

love to nibble those micey feet.

 

                             

    hypersoniq's avatar - 8ball
    Pennsylvania
    United States
    Member #1340
    April 6, 2003
    2450 Posts
    Offline
    Posted: December 22, 2003, 10:26 pm - IP Logged

    emilyg... here's what I have figured for pick 3, I still need to mod it for pick 4...

    (Thanks to ERAE for the help & inspiration, formula sharing is cool! hope you like my mods)

    =IF(S2=(($D3*100)+($E3*10)+$F3),"S",IF(S2=(($D3*100)+($F3*10)+$E3),"B",IF(S2=(($F3*100)+($E3*10)+$D3),"B",IF(S2=(($F3*100)+($D3*10)+$E3),"B",IF(S2=(($E3*100)+($D3*10)+$F3),"B",IF(S2=(($E3*100)+($F3*10)+$D3),"B"," "))))))

    Assumes S2 contains the first result of your workdown

    Assumes D3, E3 and F3 contain the next day's results by digit drawn (separated into 3 columns), therefore D3 is 1st, E3 is 2nd and F3 is 3rd.

    place this formula into cell AC3 (IF S2 thru AB2 contain 10 workout steps), then just autofill to AL3... box hits are clearly indicated with a B, straights with an S and misses with blank space.

    at the bottom of the list, simply use

    =countif(AC2:AC<end of your list>,"=S")

    then drag this across the bottom of each of the 10 columns, not only counts straight hits but also shows clustering!

    and below that, add

    =countif(AC2:AC<end of your list>,"=B")

    this counts the boxes (autofill this 10 over too)

    then simply SUM each of the countif rows to get a total number of boxes and straights for ANY system, provided you list the rundown results...

    Playing more than one ticket per game is betting against yourself.

      emilyg's avatar - cat anm.gif

      United States
      Member #14
      November 9, 2001
      31347 Posts
      Offline
      Posted: December 22, 2003, 10:31 pm - IP Logged

      thanks.

      love to nibble those micey feet.

       

                                   

        hypersoniq's avatar - 8ball
        Pennsylvania
        United States
        Member #1340
        April 6, 2003
        2450 Posts
        Offline
        Posted: December 23, 2003, 10:35 am - IP Logged

        ABCD-ABDC-ACBD-ACDB-ADBC-ADCB

        BACD-BADC-BCAD-BCDA-BDAC-BDCA

        CABD-CADB-CBAD-CBDA-CDAB-CDBA

        DABC-DACB-DBAC-DBCA-DCAB-DCBA

        that should cover the 1 straight + 23 box possibilities for pick 4, right?

        I'll convert to a formula later...

        Playing more than one ticket per game is betting against yourself.

          Avatar
          chicago illinois
          United States
          Member #1199
          February 26, 2003
          377 Posts
          Offline
          Posted: December 23, 2003, 2:13 pm - IP Logged

          I tried your system in chicago today on yesterday midday and feel real close; 5877.1231,=6008,7239.8460.9691.0822.1053.2284,3415,4646 5877results 6840 hit , THANKS for sharing this

            hypersoniq's avatar - 8ball
            Pennsylvania
            United States
            Member #1340
            April 6, 2003
            2450 Posts
            Offline
            Posted: December 24, 2003, 9:33 am - IP Logged

            this should do the trick for checking straight and boxes for pick 4... again it is ONLY for backtesting, assumes columns D E F and G contain drawn digits 1 thru 4... if number was 6518...

            this checks for 1 straight hit and the 23 possible box combinations that remain AFTER the straight hit (24 combos total)

            D   E   F  G

            6 | 5 | 1 | 8

            Also assumes your workout numbers start in column S...

            I will test this out with 1111 and 1231 over the holidays on the PA data I have...

            ----------------------------------begin copy below this line------------------------------------

            =IF(S2=(($D3*1000)+($E3*100)+($F3*10)+G3),"S",IF(S2=((($D3*1000)+($E3*100)+($G3*10)+F3),"B",

            IF(S2=(($D3*1000)+($F3*100)+($E3*10)+G3),"B",IF(S2=((($D3*1000)+($F3*100)+($G3*10)+E3),"B",I

            F(S2=(($D3*1000)+($G3*100)+($E3*10)+F3),"B",IF(S2=(($D3*1000)+($G3*100)+($F3*10)+E3),"B","

            "=IF(S2=(($E3*1000)+($D3*100)+($F3*10)+G3),"B",IF(S2=(($E3*1000)+($D3*100)+($G3*10)+F3),"B",

            IF(S2=(($E3*1000)+($F3*100)+($D3*10)+G3),"B",IF(S2=(($E3*1000)+($F3*100)+($G3*10)+D3),"B",IF

            (S2=(($E3*1000)+($G3*100)+($D3*10)+F3),"B",IF(S2=(($E3*1000)+($G3*100)+($F3*10)+D3),"B","

            "=IF(S2=(($F3*1000)+($D3*100)+($E3*10)+G3),"B",IF(S2=(($F3*1000)+($D3*100)+($G3*10)+E3),"B",

            IF(S2=(($F3*1000)+($E3*100)+($D3*10)+G3),"B",IF(S2=(($F3*1000)+($E3*100)+($G3*10)+D3),"B",IF

            (S2=(($F3*1000)+($G3*100)+($D3*10)+E3),"B",IF(S2=(($F3*1000)+($G3*100)+($E3*10)+D3),"B","

            "=IF(S2=(($G3*1000)+($D3*100)+($E3*10)+F3),"B",IF(S2=(($G3*1000)+($D3*100)+($F3*10)+E3),"B",

            IF(S2=(($G3*1000)+($E3*100)+($D3*10)+F3),"B",IF(S2=(($D3*1000)+($E3*100)+($F3*10)+D3),"B",IF

            (S2=(($G3*1000)+($F3*100)+($D3*10)+E3),"B",IF(S2=(($G3*1000)+($F3*100)+($E3*10)+D3),"B","

            "))))))))))))))))))))))))

            --------------------------------- end copy above this line-----remove any formatting if applied by post-------

            Playing more than one ticket per game is betting against yourself.

              hypersoniq's avatar - 8ball
              Pennsylvania
              United States
              Member #1340
              April 6, 2003
              2450 Posts
              Offline
              Posted: December 24, 2003, 10:12 am - IP Logged

              now that we can backtest, maybe we can develop some sort of "Rundown Calendar" using an overlay of the hits of certain rundowns, sort of like an entire system "skip/hit" chart?

              maybe 1111 and 1231 have certain on-again off-again intervals that can be interlaced?

              the sky is the limit, right?

              good luck to all!

              Playing more than one ticket per game is betting against yourself.

                hypersoniq's avatar - 8ball
                Pennsylvania
                United States
                Member #1340
                April 6, 2003
                2450 Posts
                Offline
                Posted: December 24, 2003, 10:13 am - IP Logged
                Quote: Originally posted by emilyg on December 23, 2003


                thanks.


                Sure, anytime... I'm glad I finally have something to share, even if it isn't winning numbers... yet...

                Playing more than one ticket per game is betting against yourself.

                  emilyg's avatar - cat anm.gif

                  United States
                  Member #14
                  November 9, 2001
                  31347 Posts
                  Offline
                  Posted: December 24, 2003, 10:47 am - IP Logged

                  you've put in a lot of work on this and i greatly appreciate it. happy holidays.

                  love to nibble those micey feet.

                   

                                               

                    hypersoniq's avatar - 8ball
                    Pennsylvania
                    United States
                    Member #1340
                    April 6, 2003
                    2450 Posts
                    Offline
                    Posted: December 24, 2003, 10:49 am - IP Logged

                    Happy Holidays to you too!

                    Playing more than one ticket per game is betting against yourself.

                      luckycat's avatar - animaniacs24

                      United States
                      Member #1687
                      June 16, 2003
                      1047 Posts
                      Offline
                      Posted: December 24, 2003, 11:59 am - IP Logged

                      hypersonig, thanks for all ur work outs.

                      big bucks to u/ and thanks for shareing

                       

                      keep us posted

                       

                          luckycat        >>>>>>>    purr-purr--purrfect                           

                        hypersoniq's avatar - 8ball
                        Pennsylvania
                        United States
                        Member #1340
                        April 6, 2003
                        2450 Posts
                        Offline
                        Posted: December 26, 2003, 3:16 pm - IP Logged

                        I redid the sheet, leaving one cell that I can plug any number into and automatically perform the rundowns and count straight and box hits, I fixed one or two errors with the formula and I apologize to anyone who tried to copy the formula and was greeted with the "formula is too large" error. The trick is to break it down into four subsections... the first will check for straight and 5 box combos, and the other 3 each check for 6 box combos. A simple countif at the end for S's and B's will tell the tale easily, and a single column check for the same will give the distribution...

                        First 10 columns AFTER the rundown (enter in 1st and autofill)
                        =IF(V2=(($D3*1000)+($E3*100)+($F3*10)+$G3),"S",IF(V2=(($D3*1000)+($E3*100)+($G3*10)+$F3),"B",IF(V2=(($D3*1000)+($F3*100)+($E3*10)+$G3),"B",IF(V2=(($D3*1000)+($F3*100)+($G3*10)+$E3),"B",IF(V2=(($D3*1000)+($G3*100)+($E3*10)+$F3),"B",IF(V2=(($D3*1000)+($G3*100)+($F3*10)+$E3),"B"," "))))))


                        Second 10 columns (enter in 1st and autofill)
                        =IF(V2=(($E3*1000)+($D3*100)+($F3*10)+$G3),"B",IF(V2=(($E3*1000)+($D3*100)+($G3*10)+$F3),"B",IF(V2=(($E3*1000)+($F3*100)+($D3*10)+$G3),"B",IF(V2=(($E3*1000)+($F3*100)+($G3*10)+$D3),"B",IF(V2=(($E3*1000)+($G3*100)+($D3*10)+$F3),"B",IF(V2=(($E3*1000)+($G3*100)+($F3*10)+$D3),"B"," "))))))

                         

                        third ten columns (enter in 1st and autofill)
                        =IF(V2=(($F3*1000)+($D3*100)+($E3*10)+$G3),"B",IF(V2=(($F3*1000)+($D3*100)+($G3*10)+$E3),"B",IF(V2=(($F3*1000)+($E3*100)+($D3*10)+$G3),"B",IF(V2=(($F3*1000)+($E3*100)+($G3*10)+$D3),"B",IF(V2=(($F3*1000)+($G3*100)+($D3*10)+$E3),"B",IF(V2=(($F3*1000)+($G3*100)+($E3*10)+$D3),"B"," "))))))

                        fourth ten columns (enter in 1st and autofill)
                        =IF(V2=(($G3*1000)+($D3*100)+($E3*10)+$F3),"B",IF(V2=(($G3*1000)+($D3*100)+($F3*10)+$E3),"B",IF(V2=(($G3*1000)+($E3*100)+($D3*10)+$F3),"B",IF(V2=(($D3*1000)+($E3*100)+($F3*10)+$D3),"B",IF(V2=(($G3*1000)+($F3*100)+($D3*10)+$E3),"B",IF(V2=(($G3*1000)+($F3*100)+($E3*10)+$D3),"B"," "))))))


                        all assume V starts your rundown, that you are using 10 rundown steps and that the individual fraw numbers are in columns D thru G...


                        As it stands (with new formula corrections)...
                        in 6,635 draws...

                        Adding 1111 = 6 straight hits and 22 box hits
                        adding 1231 = 8 straight hits and 32 box hits

                        nothing recently for either...

                        other numbers of possible interest....

                        Adding 2222 =  7 straight hits and 41 box hits
                        Adding 3333 =  8 straight hits and 27 box hits
                        Adding 4444 =  8 straight hits and 36 box hits
                        Adding 5555 =  6 straight hits and 29 box hits
                        Adding 6666 = 10 straight hits and 38 box hits
                        Adding 7777 = 11 straight hits and 36 box hits
                        Adding 8888 = 11 straight hits and 27 box hits
                        Adding 9999 =  7 straight hits and 24 box hits

                        Again, sorry for any inconvenience... it works now though... Since the file is now MASSIVE, it would be probably easier for me to plug in a number (like 1111 or 1231) and give back results than to e-mail the entire sheet (36 Megs uncompressed, COMPRESSED size is getting over 5 megs!)

                        Playing more than one ticket per game is betting against yourself.

                          emilyg's avatar - cat anm.gif

                          United States
                          Member #14
                          November 9, 2001
                          31347 Posts
                          Offline
                          Posted: December 26, 2003, 6:16 pm - IP Logged

                          thanks for update. will try.

                          love to nibble those micey feet.

                           

                                                       

                            mswiz777's avatar - Lottery-061.jpg
                            Va Beach
                            United States
                            Member #532
                            August 2, 2002
                            17719 Posts
                            Offline
                            Posted: January 1, 2004, 8:02 am - IP Logged

                            THANKS ALL FOR POSTING.

                              LARRY G's avatar - hiro dolphin_neg.jpg
                              Chicago
                              United States
                              Member #121
                              February 21, 2002
                              1453 Posts
                              Offline
                              Posted: January 1, 2004, 9:03 am - IP Logged

                              Happy Holidays...!....

                              You had another routine you used a couple of years ago...I think we all will enjoy again...Thanks for always sharing....

                              Larry G.