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

Reference Box Improved

Topic closed. 72 replies. Last post 1 year ago by TasBob.

Page 1 of 5
53
PrintE-mailLink
TasBob's avatar - 4NJ9EUA
Bowling Green ,Florida
United States
Member #108735
March 30, 2011
4091 Posts
Offline
Posted: October 6, 2015, 9:46 am - IP Logged

I know a Ton of people use the Reference Box

              www.lotterypost/thread/227727

My Question is has anyone improved on this and willing to share?

And please no smart remarks. Just something that cross my mind.

Would be very interesting Subject.

Procrastination Stops Progress ⇒Σ

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49643 Posts
    Online
    Posted: October 6, 2015, 10:39 am - IP Logged

    I know a Ton of people use the Reference Box

                  www.lotterypost/thread/227727

    My Question is has anyone improved on this and willing to share?

    And please no smart remarks. Just something that cross my mind.

    Would be very interesting Subject.

    The link doesn't work as posted! Here is the corrected link: https://www.lotterypost.com/thread/227727

    A mind once stretched by a new idea never returns to its original dimensions!

      TasBob's avatar - 4NJ9EUA
      Bowling Green ,Florida
      United States
      Member #108735
      March 30, 2011
      4091 Posts
      Offline
      Posted: October 6, 2015, 11:02 am - IP Logged

      The link doesn't work as posted! Here is the corrected link: https://www.lotterypost.com/thread/227727

      Ok Tks

      Procrastination Stops Progress ⇒Σ

        Avatar
        Krypton
        United States
        Member #140102
        March 11, 2013
        891 Posts
        Offline
        Posted: October 6, 2015, 5:45 pm - IP Logged

        I know a Ton of people use the Reference Box

                      www.lotterypost/thread/227727

        My Question is has anyone improved on this and willing to share?

        And please no smart remarks. Just something that cross my mind.

        Would be very interesting Subject.

        What I do know is Tony (Anthony) would be the one to ask. He has quite a bit of books and a web site now he charges for folks to use   If you email him I'm sure he will reply and answer your questions   We've exchanged several emails   Good Luck!

        Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?

          TasBob's avatar - 4NJ9EUA
          Bowling Green ,Florida
          United States
          Member #108735
          March 30, 2011
          4091 Posts
          Offline
          Posted: October 6, 2015, 6:27 pm - IP Logged

          What I do know is Tony (Anthony) would be the one to ask. He has quite a bit of books and a web site now he charges for folks to use   If you email him I'm sure he will reply and answer your questions   We've exchanged several emails   Good Luck!

          Yes I know all about him and his site..I wanted to see if anyone here at Lp has come up with a better Rb box.

          Procrastination Stops Progress ⇒Σ

            kreative1's avatar - flower2
            NE PA
            United States
            Member #127838
            May 10, 2012
            1230 Posts
            Offline
            Posted: October 6, 2015, 6:51 pm - IP Logged

            This is it in excel in case someone wants to check it out

            https://app.box.com/s/dd34d3854af6211a8057/9/43280913/3940176620/1

            PA mid draw front pairs did not show in 2015,2016
            17x,21x,49x,552,93x (4)

            PA eve draw front pairs for str8 plays 2016 that haven't hit yet
            17x,28x (2)
            common front both draws 17x

            singles that haven't hit in either draw yet 
            017,123,234 
            doubles
            002,220,221,
            557,662,775,991,992,994,996

              Avatar
              Lincoln, California
              United States
              Member #167130
              June 27, 2015
              256 Posts
              Offline
              Posted: October 6, 2015, 8:48 pm - IP Logged

              Reading the thread and learning about Reference Boxes was a refreshing change from chasing formula histories to predict numbers.

               

              I applied the system to the CA Daily 4. 

               

              The setup in excel to create the Box is fairly simple but takes a little time to do. 

               

              In cell [B18]

              First import or create the Game Data for you Game. Setup as follows:

              Cell [B18] Game Number;   [C18] 1st N1;   [D18] 2nd N2;  [E18]  3rd  N3;  [F18] 4th N4

              Use the negative value of the game Number so that the Vertical Lookup VLOOKUP function can find selected games in the formulas to be created.

               

              In Cell [I1] enter any number (20).  Highlight this cell.  This cell will become the trigger to change the number of games back you want to go.

              In Cell [I3] enter any number (30).  Highlight this cell.  This cell will become the trigger to Set the Number of Games you want to go back to set the Base Game for the Box.  The number entered is the number of games to go back for the Base Game.

              In cells [I5:I14] enter 0 thru 9 in increasing order.

              In cells [J5] enter this formula:  =COUNTIF(INDIRECT(“C”&$I$2+ROW($B$17)):INDIRECT(“C”&$I$1+$I$1+ROW($B$17)),I5)   Copy this formula in cells [J6:J14]

              In cells [M5] enter this formula:  =COUNTIF(INDIRECT(“D”&$I$2+ROW($B$17)):INDIRECT(“D”&$I$1+$I$1+ROW($B$17)),I5)   Copy this formula in cells [M6:M14]

              In cells [R5] enter this formula:  ECOUNTIF(INDIRECT(“E”&$I$2+ROW($B$17)):INDIRECT(“C”&$I$1+$I$1+ROW($B$17)),I5)   Copy this formula in cells [R6:R14]

              In cells [V5] enter this formula: =COUNTIF(INDIRECT(“F”&$I$2+ROW($B$17)):INDIRECT(“F”&$I$1+$I$1+ROW($B$17)),I5)   Copy this formula in cells [V6:V14]

              In Cell [C4] type Game,  In cell [F4] type Games

              In cell [D4] enter this formula: =INDIRECT(“B”&ROW($B$18)+I2)*-1

              In cell [E4] enter this formula: =$I$1

              In cell [C5] enter this formula: =I5 Copy this formula in cells [C6:C8]

              In cell [D5} enter this formula: =M5 Copy this formula in cells [D6:D8]

              In cell [E5} enter this formula: =Q5 Copy this formula in cells [E6:E8]

              In cell [F5} enter this formula: =U5 Copy this formula in cells [F6:F8]

               

              To create a Reference Box enter the Number of games and Games Back in the trigger cells. [I1] Games included  [I2] Games back for Base Game.

              Sort each of the column pairs:

              [I5:J14]  Sort in descending order in column J and by increasing order in column I

              [M5:N14]  Sort in descending order in column N and by increasing order in column M

              [Q:R14]  Sort in descending order in column R and by increasing order in column Q

              [U5:V14]  Sort in descending order in column V and by increasing order in column U

              If you do the time you will be able to calculate as many Reference Boxes as you want. 

              By the way.  I only ran one test with a Game Base 30 back and a Block of 20 games for CA Daily 4. The resulting Box had 192 possible combinations to play (maintaining positions in the columns).  The hits are as follows:  2667, 2688, 2670, 2671, 2676, 2680,  2684, 2686, 2689, and 2690 all hit Boxes.  10 out of 30 Games.

              Looks like it might be worth the effort. 

              From this basic worksheet you can create workbooks for any Pick 4 game.  You can modify it to a Pic 3 by not using the N4 column and N4 Count column or by erasing them.  Do not delete any columns.  It might wreck things.

              From this Basic Worksheet you can go further and set up tables that instantly show how any Reference Box has performed over the next games after the Base Game.

                Avatar
                Krypton
                United States
                Member #140102
                March 11, 2013
                891 Posts
                Offline
                Posted: October 6, 2015, 8:59 pm - IP Logged

                This is it in excel in case someone wants to check it out

                https://app.box.com/s/dd34d3854af6211a8057/9/43280913/3940176620/1

                Dead link

                Stay In The Vortex, you'll be happy you did ..... Random? Seriously? You want me to believe that?

                  Blackapple's avatar - nw rogue2.jpg
                  Wyncote,Pa
                  United States
                  Member #3206
                  January 3, 2004
                  60714 Posts
                  Offline
                  Posted: October 7, 2015, 3:46 am - IP Logged
                  I have not explored its use
                  However here's a test
                   
                   last 20 results of Michigan state before 10/6…..BOTH midday and evening COMBINED.
                   
                   
                   526 116 180 263 497 937 739 743 372 404
                   008 150 273 067 790 892 944 035 074 177
                   
                   
                  This is the Reference Box for Oct 6 for Michigan:
                   
                  077
                  130
                  793
                  204
                   
                   
                   
                  034 037 073 074 093 094 097 103 104 107
                  130 134 137 170 173 174 190 193 194 197
                  203 204 207 230 234 237 270 273 274 290
                  293 294 297Bx 703 704 730 734 790 793 794
                  003 004 007 030 033 070 077 090 100 133
                  177 200 233 277 700 707 733 737 770 773
                       774 797
                  ___________________________________________
                  We see Top key Digits:0,3,7
                  We see Top Root sum:5
                  We see Top pair:07x
                  ****************************
                  Tue, Oct 6, 20157-2-9
                    Blackapple's avatar - nw rogue2.jpg
                    Wyncote,Pa
                    United States
                    Member #3206
                    January 3, 2004
                    60714 Posts
                    Offline
                    Posted: October 7, 2015, 4:08 am - IP Logged

                    034 037 073 074 093 094 097 103 104 107
                    130 134 137 170 173 174 190 193 194 197
                    203 204 207 230 234 237 270 273 274 290
                    293 294 297Bx 703 704 730 734 790 793 794
                    003 004 007 030 033 070 077 090 100 133
                    177 200 233 277 700 707 733 737 770 773
                          774 797

                    I will interface these results above with my various findings

                     

                    How will Digit 1 or 5 serve Mich.
                     
                     
                     
                    034 037 073 074 093 094 097 103 104 107
                    130 134 137 170 173 174 190 193 194 197
                    203 204 207 230 234 237 270 273 274 290
                    293 294 297 703 704 730 734 790 793 794
                    003 004 007 030 033 070 077 090 100 133
                    177 200 233 277 700 707 733 737 770 773
                          774 797
                     
                    _______________________________________________________________________________
                     
                     
                     
                    How will Digit 1 or 5 serve us
                    ***********************************
                    Digit 1 or 5  creates  Root sum 3,5 or 9
                      012 057 129 138 147 156 345 579 255 588 111
                      014 059 149 158 167 257 356 005 113 122 455 599
                      018 045 126 135 189 459 567 117 225 144 558
                     
                    or
                     
                    Digit 1 or 5  creates  Root sum 1 or 5
                    019 127 136 145 235 568 001 118 055 559 577 199
                    014 059 149 158 167 257 356 005 113 122 455 599
                     
                      Blackapple's avatar - nw rogue2.jpg
                      Wyncote,Pa
                      United States
                      Member #3206
                      January 3, 2004
                      60714 Posts
                      Offline
                      Posted: October 7, 2015, 4:10 am - IP Logged
                      Digit 0 or 3  are ironclad to fall
                       *********************************
                       
                      Everything stated here will be done by 6/9
                      034 037 073 074 093 094 097 103 104 107
                      130 134 137 170 173 174 190 193 194 197
                      203 204 207 230 234 237 270 273 274 290
                      293 294 297 703 704 730 734 790 793 794
                      003 004 007 030 033 070 077 090 100 133
                      177 200 233 277 700 707 733 737 770 773
                              774 797
                        Blackapple's avatar - nw rogue2.jpg
                        Wyncote,Pa
                        United States
                        Member #3206
                        January 3, 2004
                        60714 Posts
                        Offline
                        Posted: October 7, 2015, 4:17 am - IP Logged
                        Watch these pairs...23x--78x--05x..69x
                        One of these  falls
                        034 037 073 074 093 094 097 103 104 107
                        130 134 137 170 173 174 190 193 194 197
                        203 204 207 230 234 237 270 273 274 290
                        293 294 297 703 704 730 734 790 793 794
                        003 004 007 030 033 070 077 090 100 133
                        177 200 233 277 700 707 733 737 770 773
                                 774 797
                          Blackapple's avatar - nw rogue2.jpg
                          Wyncote,Pa
                          United States
                          Member #3206
                          January 3, 2004
                          60714 Posts
                          Offline
                          Posted: October 7, 2015, 4:25 am - IP Logged
                          A
                          Watch these pairs...67x--99x--14x.
                                                         69x..17x..49x
                          One of them falls
                          ________________________________
                          B.
                          Watch these pairs...23x--58x--30x.
                                                       28x..00x..05x
                           
                           
                           
                          034 037 073 074 093 094 097 103 104 107
                          130 134 137 170 173 174 190 193 194 197
                          203 204 207 230 234 237 270 273 274 290
                          293 294 297 703 704 730 734 790 793 794
                          003 004 007 030 033 070 077 090 100 133
                          177 200 233 277 700 707 733 737 770 773
                                  774 797
                            Blackapple's avatar - nw rogue2.jpg
                            Wyncote,Pa
                            United States
                            Member #3206
                            January 3, 2004
                            60714 Posts
                            Offline
                            Posted: October 7, 2015, 4:27 am - IP Logged
                            This is the Reference Box for Oct 6 for Michigan:
                             
                            077
                            130
                            793
                            204
                            The rest of the post
                              Blackapple's avatar - nw rogue2.jpg
                              Wyncote,Pa
                              United States
                              Member #3206
                              January 3, 2004
                              60714 Posts
                              Offline
                              Posted: October 7, 2015, 6:08 am - IP Logged
                               
                               
                               Reference Box and my pairs coinciding
                              Should bring Digit 0..  at some point
                               
                              03..07..00
                               
                               
                               
                               
                              034 037 073 093 103 130 203 230 703 730 003 030 033
                              094 194 294 794
                              104 134 174 194
                              107 137 170 173 174 197 177
                              203 230 234 237 273 293 233
                              003 004 007 030 070 090 100 200 700
                               
                              Reduction
                               
                              034 037 073 093 103 130 203 230 703 730 003 030 033
                              094 794
                              104 134 174
                              107 137 170 173 197 177
                              234 237 273 293 233
                              004 007  070 090 100 200 700