Welcome Guest
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

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.

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

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

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.

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.

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: December 23, 2003, 10:35 am - IP Logged

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.

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

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

 Page 3 of 4