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

The GELE Filter - P3

Topic closed. 15 replies. Last post 7 years ago by retxx.

Page 1 of 2
PrintE-mailLink
Avatar

United States
Member #7437
October 3, 2004
383 Posts
Offline
Posted: February 24, 2010, 1:04 pm - IP Logged

Hi Everyone:

Here's another filter for your toolbox. It's called the GELE filter, (GE = greater than or equal to, LE = less than or equal to).

Here's how it works: Let the digits of an arbitrary draw be A, B and C. We get a set of stats over a set of N past draws. The stats tell us how many times A GE B, B GE A , etc. In addition, we get a set of GELE stats for the pairs, AB, AC, and BC, i.e, how many time AB GE BC, BC GE AC, etc. Over the long haul the numbers in the GELE comparisons should be close to equal, but for the short term there are often noticeable trends. This filter can be very useful, for example in playing sums. If you find from the stats, for example, that B GE A has not been happening as often as expected, by only considering plays where A GE B can reduce the number of straight plays by one half.

Here's how to get started. Go to the link

 

http://cid-53e66599b04974a6.skydrive.live.com/browse.aspx/GELE%5E_P3

and download geleStats.exe to a working direcrory. Prepare a past draw text file called drawsP3.txt and place it in the same directory. The drawsP3.txt file should contain only one entry per line. No spaces or extra characters, latest draw on top and oldest draw on bottom. Also the text file should be ASCII encoded.

Click on the geleStats.exe icon and you'll see a pop up window asking you how many past draws you want stats on.  Pick a large number , say 100 or more, for long term trends and a smaller amount for short term trends. The stats are written to the console, and after exiting, you'll find the same output written to a file called p3Stats4GELE.txt.

Here's an example from the NY Midday P3 using a past draw file containing 100 entries. We started from Jan. 1, 2010 going back 100 draws. Here are the stats for those 100 draws:

*************GELE Digit Stats***********
A GE B - 59
B GE A - 53
A GE C - 57
C GE A - 47
B GE C - 60
C GE B - 50

*************GELE Pair Stats***********
AB GE BC - 56
BC GE AC - 53
AC GE BC - 59
BC GE AC - 53
AB GE AC - 60
AC GE AB - 50

For the pairs and the digits the 60 is a stick out (B GE C and AB GE AC), because we should be expecting a number closer to 50.

Below are the next 5 days worth of draws for the NY P3 Midday.  Let's see how many draws showed a reversal(C GE B or AC GE AB)

                    A B C

Jan 6 '10    3 7 8   
Jan 5 '10    2 3 0   
Jan 4 '10    7 6 8   
Jan 3 '10    0 2 8   
Jan 2 '10    1 5 6

 

On Jan2, 3, 4, and 6  C came out GE B. On Jan 2, 3, 4 and 6 AC came out GE AB. 

WINSUMLOOSESUM : In case you are listening to this thread, this would be very easy to implement in EXCEL.

Try this filter out on your circuit. It looks promising.

 

jayemmar   

    retxx's avatar - mrthumbs
    BOSTON
    United States
    Member #48
    September 9, 2001
    3594 Posts
    Offline
    Posted: February 24, 2010, 10:24 pm - IP Logged

    tried to download,got an error. can you help? hope someone writes this to excel. would be great.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: February 24, 2010, 11:26 pm - IP Logged

      tried to download,got an error. can you help? hope someone writes this to excel. would be great.

      Here is the Excel program for GELE.

      Create a new folder and unzip the 2 Excel files into your newly named folder.

      There is 1 Excel file with all the Pick 3 draws and the 2nd called Doubles that has the GE-LE Tab (3rd one form the left)

      You need to have both Excel files opened for this to work.   This is with Excel 2002 by the way.

      If you click the 1st Tab (Doubles.xls) you will see all the Tab labeled "Toolbars" that contains all the states (midday, evening, and combined)

      You can click any states' toolbar.  For example you can click NY3M for New York Midday Pick 3 only draws jsut like jayemmar's New York midday example.

      In the GE-LE Tab you can adjust the number of draws to show the hits for each GE-LE. In cell B1 and B2 you can change the 1 and 100 to whatever you wish.  For example B1 = 54 and B2 = 153.  This would give you the 100 past draws for New York Midday Pick 3 draws from Jan 1 2010 going back 100 draws.  This is the same calculations jayemmar used in the 1st  thread.

      Let me know if you have any questions.

      Here i the download link to the zip file.  Remember to create a new folder first.  Then unzip the 2 Excel files into this newly named folder.

      Have fun!!

      http://www.box.net/shared/ubn6a395t9

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: February 25, 2010, 7:27 am - IP Logged

        Update GELE Excel files download link:

        http://www.box.net/shared/pj0v7o1pf7

          Avatar

          United States
          Member #7437
          October 3, 2004
          383 Posts
          Offline
          Posted: February 25, 2010, 10:56 am - IP Logged

          Hi winsumloosesum:

           

          I'm going to leave this one for you, since everyone likes to work with EXCEL. Let's tackle the P4 with the GELE filter. Each P4 can be represented by ABCD, where A,B, C and D are between 0 and 9. So we need stats for:

          A GE B, B GE C,  C GE D etc. Also we need a set of stats for the pairs, AB, BC, AC, AD, BD, CD. In addition, we can add stats for the four triples, ABC, ABD, BCD, ACD(ABC GE BCD, etc.).

          This filter looks like it can be very valuable in the P3 and P4.

           

          jayemmar

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: February 25, 2010, 7:17 pm - IP Logged

            Hi winsumloosesum:

             

            I'm going to leave this one for you, since everyone likes to work with EXCEL. Let's tackle the P4 with the GELE filter. Each P4 can be represented by ABCD, where A,B, C and D are between 0 and 9. So we need stats for:

            A GE B, B GE C,  C GE D etc. Also we need a set of stats for the pairs, AB, BC, AC, AD, BD, CD. In addition, we can add stats for the four triples, ABC, ABD, BCD, ACD(ABC GE BCD, etc.).

            This filter looks like it can be very valuable in the P3 and P4.

             

            jayemmar

            This is the download link to GE LE Pick 4 Excel files.  Follow the same instructions as the Pick 3.

            Create a new folder.  Name it whatever you wish (example: Pick 4 GE LE)

            Download the zip file from this link:

            http://www.box.net/shared/g7x8mlq1c0

            Unzip the 2 Excel files from the zip file into your newly named folder (Pick 4 GE LE)

            Open the P4Draws.xls Excel file first and then open the GELE.xls Excel file 2nd.

            In the GELE Excel file, go to the Tab labeled "Toolbars" and you will see all the Toolbars for all the states (Midday, Evening, and Combined)

            Click your states Toolbar and the macro will transfer 1000 past draws to the Calculations Tab.

            Go to the GE-LE Tabs for "Digits", "Pairs", and "Trips"

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: February 26, 2010, 8:28 am - IP Logged

              Updated state drawings Excel files.

              Create a new folder on your desktop and name it "Draw Updates" (without quotes)

              1. Download link to Pick 3 & Pick 4 Excel files zip file.

              http://www.box.net/shared/rlpo4q0f0s

              2. Download the Zip (StateDraw Excel Files) to your "Draw Updates" folder on your Desktop

              3.  Open up the "Draw Updates" folder on your desktop

              4.  Unzip the contents of the Zip file (P3StateDraws.xls & P4StateDraws.xls) into the "Draw Updates" folder.

              5.  You should have 2 folders you created previously from the earlier posts.  "Pick 4 GELE" and "Pick 3 GELE" (or whatever folder name you created)

              6.  Copy and paste  the P3StateDraws.xls Excel file from the "Draw Updates" folder to the "Pick 3 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

              7.  Copy and paste  the P4StateDraws.xls Excel file from the "Draw Updates"folder to the "Pick 4 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

              8.  Now you have the most current Draing files in both folders.

              9.  Follow the instructions in the previous posts on how to run your states' calculations.

              Good Luck!!

                retxx's avatar - mrthumbs
                BOSTON
                United States
                Member #48
                September 9, 2001
                3594 Posts
                Offline
                Posted: February 26, 2010, 9:10 am - IP Logged

                when I opened doubles folder and clivk on f-48/49 i get runtime error"9" subscript out of range. what now?

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5387 Posts
                  Offline
                  Posted: February 26, 2010, 10:03 am - IP Logged

                  when I opened doubles folder and clivk on f-48/49 i get runtime error"9" subscript out of range. what now?

                  1.  Both the P3StateDraws.xls and the Doubles.xls Excel files should be in the same folder

                  2.  Open the P3StateDraws.xls file 1st

                  3.  When the P3StateDraws.xls file opens go to the top of the Main Menu and choose >File > Open.  Then open the second Excel file Doubles.xls in your Pick 3 GELE Folder (or whatever folder you named it)

                  4.  You should now have both Excel files opened.  You need both open for this to work

                  5.  Next, in the Doubles.xls Excel file go to the "States" Tab and select your states Toolbar.  So retxx, you would select Mass Midday, Evening, or Combined in cell rows 48 &49

                  You need both Excel files open for this to work.

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Offline
                    Posted: February 27, 2010, 11:54 am - IP Logged

                    Updated state drawings Excel files.

                    Create a new folder on your desktop and name it "Draw Updates" (without quotes)

                    1. Download link to Pick 3 & Pick 4 Excel files zip file.

                    http://www.box.net/shared/rlpo4q0f0s

                    2. Download the Zip (StateDraw Excel Files) to your "Draw Updates" folder on your Desktop

                    3.  Open up the "Draw Updates" folder on your desktop

                    4.  Unzip the contents of the Zip file (P3StateDraws.xls & P4StateDraws.xls) into the "Draw Updates" folder.

                    5.  You should have 2 folders you created previously from the earlier posts.  "Pick 4 GELE" and "Pick 3 GELE" (or whatever folder name you created)

                    6.  Copy and paste  the P3StateDraws.xls Excel file from the "Draw Updates" folder to the "Pick 3 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

                    7.  Copy and paste  the P4StateDraws.xls Excel file from the "Draw Updates"folder to the "Pick 4 GELE" folder.  You will be prompted to replace existing file.  Just accept and click "Yes"

                    8.  Now you have the most current Draing files in both folders.

                    9.  Follow the instructions in the previous posts on how to run your states' calculations.

                    Good Luck!!

                    Updated Draws Excel files for GELE download link:

                    http://www.box.net/shared/ndhsen22i2

                    Draws updated through Friday Feb 26 2010

                      retxx's avatar - mrthumbs
                      BOSTON
                      United States
                      Member #48
                      September 9, 2001
                      3594 Posts
                      Offline
                      Posted: February 28, 2010, 10:53 am - IP Logged

                      can you explain how you came up with those #'s from the 2nd to the 6th to play. Where would they be on which chart on doubles.? thanks

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: February 28, 2010, 11:03 am - IP Logged

                        What Jayemmar I beleive is looking for is high GELE (Greater Than Equal To or Less Than Equal T0) values based on "X" amount of past draws.  For example, read the 1st post.  If the GELE value for example for for Front Pairs is high for Great Than (GE) then look for a reversal of a lesser Pair.  Jayemmar was just showing the next few drawings after he ran the GELE program to show you how digits or pairs reversed because of the high GELE value.  Jayemmar can explain better than my explanation.

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5387 Posts
                          Offline
                          Posted: February 28, 2010, 11:11 am - IP Logged

                          Hi Everyone:

                          Here's another filter for your toolbox. It's called the GELE filter, (GE = greater than or equal to, LE = less than or equal to).

                          Here's how it works: Let the digits of an arbitrary draw be A, B and C. We get a set of stats over a set of N past draws. The stats tell us how many times A GE B, B GE A , etc. In addition, we get a set of GELE stats for the pairs, AB, AC, and BC, i.e, how many time AB GE BC, BC GE AC, etc. Over the long haul the numbers in the GELE comparisons should be close to equal, but for the short term there are often noticeable trends. This filter can be very useful, for example in playing sums. If you find from the stats, for example, that B GE A has not been happening as often as expected, by only considering plays where A GE B can reduce the number of straight plays by one half.

                          Here's how to get started. Go to the link

                           

                          http://cid-53e66599b04974a6.skydrive.live.com/browse.aspx/GELE%5E_P3

                          and download geleStats.exe to a working direcrory. Prepare a past draw text file called drawsP3.txt and place it in the same directory. The drawsP3.txt file should contain only one entry per line. No spaces or extra characters, latest draw on top and oldest draw on bottom. Also the text file should be ASCII encoded.

                          Click on the geleStats.exe icon and you'll see a pop up window asking you how many past draws you want stats on.  Pick a large number , say 100 or more, for long term trends and a smaller amount for short term trends. The stats are written to the console, and after exiting, you'll find the same output written to a file called p3Stats4GELE.txt.

                          Here's an example from the NY Midday P3 using a past draw file containing 100 entries. We started from Jan. 1, 2010 going back 100 draws. Here are the stats for those 100 draws:

                          *************GELE Digit Stats***********
                          A GE B - 59
                          B GE A - 53
                          A GE C - 57
                          C GE A - 47
                          B GE C - 60
                          C GE B - 50

                          *************GELE Pair Stats***********
                          AB GE BC - 56
                          BC GE AC - 53
                          AC GE BC - 59
                          BC GE AC - 53
                          AB GE AC - 60
                          AC GE AB - 50

                          For the pairs and the digits the 60 is a stick out (B GE C and AB GE AC), because we should be expecting a number closer to 50.

                          Below are the next 5 days worth of draws for the NY P3 Midday.  Let's see how many draws showed a reversal(C GE B or AC GE AB)

                                              A B C

                          Jan 6 '10    3 7 8   
                          Jan 5 '10    2 3 0   
                          Jan 4 '10    7 6 8   
                          Jan 3 '10    0 2 8   
                          Jan 2 '10    1 5 6

                           

                          On Jan2, 3, 4, and 6  C came out GE B. On Jan 2, 3, 4 and 6 AC came out GE AB. 

                          WINSUMLOOSESUM : In case you are listening to this thread, this would be very easy to implement in EXCEL.

                          Try this filter out on your circuit. It looks promising.

                           

                          jayemmar   

                          *************GELE Digit Stats***********
                          A GE B - 59
                          B GE A - 53
                          A GE C - 57
                          C GE A - 47
                          B GE C - 60
                          C GE B - 50

                          *************GELE Pair Stats***********
                          AB GE BC - 56
                          BC GE AC - 53
                          AC GE BC - 59
                          BC GE AC - 53
                          AB GE AC - 60
                          AC GE AB - 50

                          ====================================

                          In the "Digit Stats" above you see "B GE (Greater Than or Equal) to C - 60".  This means that the second position "B" has been greater than the 3rd position "C" 60 times in the last 100 draws.  So look for a reverse meaning B (2nd Position) now being LE (Less than or Equal To the 3rd Position)

                          Same goes for the "GELE" Pair Stats. "AB GE AC - 60"  The front pair AB is GE (Greater than or Equal to) the Side Pair AC in the last 100 draws 60 times.  So look for a reversal of the AB (front pair) being LE (less than or equal to) the side pair AC.

                            retxx's avatar - mrthumbs
                            BOSTON
                            United States
                            Member #48
                            September 9, 2001
                            3594 Posts
                            Offline
                            Posted: March 1, 2010, 10:58 am - IP Logged

                            DIGITS   (>=   GE)                              Index     Average
                            1ST     > =     2ND     A     GE     B     0.63     1.59
                            2ND     > =     1ST     B     GE     A     0.90     2.22
                            1ST     > =     3RD     A     GE     C     0.64     1.56
                            3RD     > =     1ST     C     GE     A     0.49     2.04
                            2ND     > =     3RD     B     GE     C     0.98     2.04
                            3RD     > =     2ND     C     GE     B     0.61     1.64

                                                               
                                                               
                                                               
                            PAIRS   (>=   GE)                              Index     Average
                            FRONT     > =     BACK     AB     GE     BC     0.59     1.69
                            BACK     > =     FRONT     BC     GE     AB     0.82     2.44
                            SIDE     > =     BACK     AC     GE     BC     0.63     1.59
                            BACK     > =     SIDE     BC     GE     AC     0.90     2.22
                            FRONT     > =     SIDE     AB     GE     AC     0.98     2.04
                            SIDE     > =     FRONT     AC     GE     AB     0.61     1.64
                            here are Mass #'s. what would you play for next days play?

                              retxx's avatar - mrthumbs
                              BOSTON
                              United States
                              Member #48
                              September 9, 2001
                              3594 Posts
                              Offline
                              Posted: March 1, 2010, 8:16 pm - IP Logged

                              can you walk me thru my example and step by step how to come up with plays. Thanks