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

4/7 Technique - Pick 4 - With Excel Sheet

Topic closed. 32 replies. Last post 8 years ago by WolverineX.

Page 1 of 3
51
PrintE-mailLink
diamondpalace's avatar - Untitled 2.jpg
Dallas, TX
United States
Member #60284
April 12, 2008
3856 Posts
Offline
Posted: December 21, 2008, 11:10 am - IP Logged

I've been using this method and it brings in the money few times a week.

Here's how.

Download the basic excel sheet for this exercise:

    *  Enable Macro when open for the sheet to work.
    *  Customize the sheet how you like; colors, font, etc...
    *  Save the original copy and make few duplicates for eve/mid play
    *  Input all the numbers. The sheet will automatically recognize the numbers as SINGLE or DOUBLE, if it's a tripple or double-double it's going to list as DOUBLE.
    *  After all the numbers are in place, hit on the sort button for descendend to see the 7 HOT numbers.
    *  There are two sheets within this file "1-2-3-4 Format" and "Wheels".
    *  Use the variety of wheels after Sort Descend (for the hot & cold numbers placements). Some wheel type works better for certain states.
    *  Copy and Paste the wheels into notepad to use them. If your notepad gives you boxes and grids along with the numbers, select your notepad "Make Plain Text" option just to view the numbers itself, or you can write them down...
    *   You can wheel any numbers you like simply input the numbers in the box and it will create the wheel for you. New draw number input will reset the wheel according to the "Freq" hits ascending/descending. If you are going to manually inputting numbers to wheel, doing it on another copy of the sheet is advised.

If the "Sort Descend" button don't work, then you will have to do this manually. Only works on some Excel version. If this is the case, select all the box within the "Freq" and "P-4#'s" and select in your top menu bar "DATA" then "Sort..." and select "Descend" and hit ok. Don't forget to do this before looking at the Top 7 hot numbers along with cold numbers.

The Top 7 hot and cold, that section are results from the numbers you entered. It is a general view of all the numbers and its current frequent hits.

All this data will give you a clear view on how to apply it for 4/7, here comes the technique.



Play Style: SINGLE or DOUBLE

SINGLE Play:

    •    Make another copy of the original sheet and use this to generate your numbers.
    •    Enter only the last 10 singles draws.
    •    Look at the TOP 7 Hot numbers, ignore this and wheel only TOP 7 cold numbers. Because the hot numbers are already used up within the last 10 draws.
    •    Backtesting: You would need 10 previous draw to put up against the next day result.
    •    This method require playing all 35 numbers. You may filter it out some numbers after inspecting pick 4 in your state within 30 days to see what types of numbers frequent. Filtering out all high numbers and all low numbers along with all even and all odd, these type are uncommon in pick 4 as there are so few numbers within these range to be worth including in the 35 provided numbers.
    •    Once you have your numbers play them BOX.
    •    Your cost would be $8.75 for all 35 numbers for one state with $0.25/ ticket (online play), or $17.50 with $0.50 (retail play).
    •    The Excel sheet will let you see the SINGLE and DOUBLE that comes, look for pattern it create often a SINGLE will hit 3 - 5 times in a row before it switch to DOUBLE, and see how long the DOUBLE last before switching out. When there are consecutive SINGLE/DOUBLE the opposite is expected to hit the next draw. If DOUBLE has been hitting for 4 days in a row, I would apply this method, select my numbers and bet for the 5th day.
    •    Avoid playing daily. Track first, test, and play.

DOUBLE Play:

    * Apply the same steps as for SINGLE play.
    * This time instead of recording the DOUBLES as 0-0-1-2 just input 1-2, leaving out the double (00-99). This way you are getting a true frequent reading on the pairs that comes with the double, since doubles are included there is no need to check for its frequency.
    *  These are the pairs needed to match up with the doubles. Remember, no triples or double-double.


01/­?02/­03/­04/­05/­06/­07/­08/­09/­12/­13/­14/­15/­16/­17/­18/­19/­23/­24/­25/­26/­27/­28/­29/­34/­35/­36/­37/­38/­39/­45/­46/­47/­48/­49/­56/­57/­58/­59/­67/­68/­69/­78/­79/­89

   
    * Each pair with the doubles (00-99) will produce 8 tickets. If I select 01 as a pair to combined, these are the numbers I would get:
2201
3301
4401
5501
6601
7701
8801
9901
   
    * Cost $2 (online), $4 (retail) to cover 1 pair. You can play more than 1 pair if desired.
    * The pair are determined by the Frequent hits (after sorting descend) to get 7 TOP Hot/Cold. Focus on the cold or mix with hot and cold to get your pairs. Look at the previous 10 draws to get your freq hits order.
    * Use the inspect tools on this site and look within the 30 days and select all DOUBLES and inspect again, and look for the due pairs as clues what to consider.

Depending on the frequent of Singles or Double that appear in a state, for an example, this month GA has more SINGLE hits than DOUBLES, so I use the SINGLE method for SINGLE days, vice versa.

Back test it starting in October to see how often you get its using the Top 7 Cold numbers SINGLE/DOUBLE within the last 10 draws, before putting it up against the next result.

If you have questions or concern you can post them in this thread, or message me.

I would like to thank the following members for helping me with the Excel sheet coding: budward & Mark J

    diamondpalace's avatar - Untitled 2.jpg
    Dallas, TX
    United States
    Member #60284
    April 12, 2008
    3856 Posts
    Offline
    Posted: December 21, 2008, 11:27 am - IP Logged

    New Excel Sheet Download.

      Avatar
      atlanta ga
      United States
      Member #66652
      November 2, 2008
      34 Posts
      Offline
      Posted: December 21, 2008, 12:28 pm - IP Logged

      Hi, diamondpalace, sorry I'm still learning how to use lottery post, but anyway i was saying i download the new excel sheet but i need 4 u 2 help me undrestand one thing , the numbers I'm putting on the spread sheet are the dec. # that already hit 4 this months,thanks 4 sending me the The New Excel programHyper

        diamondpalace's avatar - Untitled 2.jpg
        Dallas, TX
        United States
        Member #60284
        April 12, 2008
        3856 Posts
        Offline
        Posted: December 21, 2008, 2:27 pm - IP Logged

        Hi, diamondpalace, sorry I'm still learning how to use lottery post, but anyway i was saying i download the new excel sheet but i need 4 u 2 help me undrestand one thing , the numbers I'm putting on the spread sheet are the dec. # that already hit 4 this months,thanks 4 sending me the The New Excel programHyper

        Sondra,

        The sheets needs to be from today counting 30 days back. Today is the 21st of Dec, I would start placing the numbers in from the 21st of Nov till now. Keeping mid day seperate, same with evening. Then, for Single/Double you can color code them for easy viewing in one glimpse. Remember to keep the original untouched version, this way you can start a different anaylsis for the 10 previous results for Single/Double to test/pick your numbers.

        :)

          Avatar
          chicago illinois
          United States
          Member #1199
          February 26, 2003
          377 Posts
          Offline
          Posted: December 21, 2008, 9:12 pm - IP Logged

          I tried to download do I need to pay keep getting just download nothing happens.

            diamondpalace's avatar - Untitled 2.jpg
            Dallas, TX
            United States
            Member #60284
            April 12, 2008
            3856 Posts
            Offline
            Posted: December 22, 2008, 10:20 am - IP Logged

            I tried to download do I need to pay keep getting just download nothing happens.

            No need to pay. Simply click on the "Free" button and it will take you to the download page.

              Raven62's avatar - binary
              New Jersey
              United States
              Member #17843
              June 28, 2005
              49835 Posts
              Offline
              Posted: December 22, 2008, 2:54 pm - IP Logged

              No need to pay. Simply click on the "Free" button and it will take you to the download page.

              Sounds Easy: But it doesn't seem to work.

              It goes thru the 10 second count down: Then says sending file wait 10 seconds: But nothing.

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

                diamondpalace's avatar - Untitled 2.jpg
                Dallas, TX
                United States
                Member #60284
                April 12, 2008
                3856 Posts
                Offline
                Posted: December 22, 2008, 5:31 pm - IP Logged

                Sounds Easy: But it doesn't seem to work.

                It goes thru the 10 second count down: Then says sending file wait 10 seconds: But nothing.

                It's very easy. :P

                I know what you are saying. In the same space that the 10 second count down appeared, it will show the box to enter code (validating that you are human) after the 10 sec has passed. If you don't see it, in your case, hit refresh button on your browser, if you don't see it again, then hit refresh again. Do this few times then the enter code box will appear for you to enter the given code next to the box for validation, then hit the "Download" button next to it. :)

                During rush hours multiple refreshes should get the download button appeared.

                  Raven62's avatar - binary
                  New Jersey
                  United States
                  Member #17843
                  June 28, 2005
                  49835 Posts
                  Offline
                  Posted: December 22, 2008, 9:39 pm - IP Logged

                  It's very easy. :P

                  I know what you are saying. In the same space that the 10 second count down appeared, it will show the box to enter code (validating that you are human) after the 10 sec has passed. If you don't see it, in your case, hit refresh button on your browser, if you don't see it again, then hit refresh again. Do this few times then the enter code box will appear for you to enter the given code next to the box for validation, then hit the "Download" button next to it. :)

                  During rush hours multiple refreshes should get the download button appeared.

                  It's very easy if it works: IT DOESN'T WORK!

                  Didn't see any validation code box in previous attempts.

                  This time saw the validation code box a few times during a couple dozen attempts. Entered the code, selected download: got sending file: then nothing.

                  Files such as this can also be uploaded to your Lottery Post web space for download.

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

                    diamondpalace's avatar - Untitled 2.jpg
                    Dallas, TX
                    United States
                    Member #60284
                    April 12, 2008
                    3856 Posts
                    Offline
                    Posted: December 22, 2008, 10:18 pm - IP Logged

                    Newest version uploaded.

                    Tripples/quad/double/single identification, and color coded.

                    This type of file cannot be uploaded to LP webspace.

                    Hope this works for Raven.

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Online
                      Posted: December 22, 2008, 10:18 pm - IP Logged

                      It's very easy if it works: IT DOESN'T WORK!

                      Didn't see any validation code box in previous attempts.

                      This time saw the validation code box a few times during a couple dozen attempts. Entered the code, selected download: got sending file: then nothing.

                      Files such as this can also be uploaded to your Lottery Post web space for download.

                      Uploaded to Mediafire

                      Hope this works better:

                      http://www.mediafire.com/?yb1zcnntjoi

                        Raven62's avatar - binary
                        New Jersey
                        United States
                        Member #17843
                        June 28, 2005
                        49835 Posts
                        Offline
                        Posted: December 22, 2008, 11:45 pm - IP Logged

                        Uploaded to Mediafire

                        Hope this works better:

                        http://www.mediafire.com/?yb1zcnntjoi

                        Worked like a champ!

                        Thanks,

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

                          Raven62's avatar - binary
                          New Jersey
                          United States
                          Member #17843
                          June 28, 2005
                          49835 Posts
                          Offline
                          Posted: December 23, 2008, 12:11 am - IP Logged

                          Newest version uploaded.

                          Tripples/quad/double/single identification, and color coded.

                          This type of file cannot be uploaded to LP webspace.

                          Hope this works for Raven.

                          This one worked too.

                          Thanks,

                          PS: I guess the ability to upload to your member webspace never got fixed!

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

                            Avatar
                            chicago illinois
                            United States
                            Member #1199
                            February 26, 2003
                            377 Posts
                            Offline
                            Posted: December 25, 2008, 8:58 am - IP Logged

                            What happen;I downloaded on my old computer yesterday and decided to put this program on my new computer, on my old computer my state came in Illinois and today same download site gave me georgia.

                              diamondpalace's avatar - Untitled 2.jpg
                              Dallas, TX
                              United States
                              Member #60284
                              April 12, 2008
                              3856 Posts
                              Offline
                              Posted: December 25, 2008, 6:30 pm - IP Logged

                              What happen;I downloaded on my old computer yesterday and decided to put this program on my new computer, on my old computer my state came in Illinois and today same download site gave me georgia.

                              Those are the sample states. The first one you downloaded was the previous version of the sheet, when you downloaded a new one it has updated.