4/7 Technique - Pick 4 - With Excel SheetPrev Topic Next Topic

New Topic New Poll

diamondpalace

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 21, 2008, 11:10 am

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

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 21, 2008, 11:27 am

New Excel Sheet Download.
sondra

atlanta ga
United States
Member #66,650
November 2, 2008
34 Posts
Offline

Dec 21, 2008, 12:28 pm

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 program
diamondpalace

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 21, 2008, 2:27 pm

Quote: Originally posted by sondra on Dec 21, 2008
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 program

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.

:)
merdis salley

chicago illinois
United States
Member #1,199
February 26, 2003
382 Posts
Offline

Dec 21, 2008, 9:12 pm

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

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 22, 2008, 10:20 am

Quote: Originally posted by merdis salley on Dec 21, 2008
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

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Dec 22, 2008, 2:54 pm

Quote: Originally posted by diamondpalace on Dec 22, 2008
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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
diamondpalace

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 22, 2008, 5:31 pm

Quote: Originally posted by Raven62 on Dec 22, 2008
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

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Dec 22, 2008, 9:39 pm

Quote: Originally posted by diamondpalace on Dec 22, 2008
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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
diamondpalace

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 22, 2008, 10:18 pm

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

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Online

Dec 22, 2008, 10:18 pm

Quote: Originally posted by Raven62 on Dec 22, 2008
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

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Dec 22, 2008, 11:45 pm

Quote: Originally posted by winsumloosesum on Dec 22, 2008
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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
Raven62

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Dec 23, 2008, 12:11 am

Quote: Originally posted by diamondpalace on Dec 22, 2008
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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
merdis salley

chicago illinois
United States
Member #1,199
February 26, 2003
382 Posts
Offline

Dec 25, 2008, 8:58 am

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

United States
Member #60,282
April 12, 2008
3,857 Posts
Offline

Dec 25, 2008, 6:30 pm

Quote: Originally posted by merdis salley on Dec 25, 2008
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.

New Topic New Poll

Subscribe to this topic

4/7 Technique - Pick 4 - With Excel SheetPrev TopicNext Topic

4/7 Technique - Pick 4 - With Excel SheetPrev Topic Next Topic