Need pick4 excel sheet

Reply #9

lakerben — Thu, 27 Feb 2020 03:48:00 GMT

Thanks steve

Reply #8

winsumloosesum — Thu, 27 Feb 2020 03:37:55 GMT

Here you go LB

https://app.box.com/s/7h48gjy5fnd0e2w7yiashrkpp8sz35z1

Reply #7

Gwoof — Wed, 26 Feb 2020 19:01:37 GMT

Same formula only it's for last 10 games.

LAST 10 GAMES

POS 1 POS 2 POS 3 POS 4

Freq P-4 #'s Freq P-4 #'s Freq P-4 #'s Freq P-4 #'s

3 5 1 3 1 1 4 0 1 3 8 1

2 9 2 2 8 2 3 7 2 2 3 2

1 2 3 2 6 3 1 2 3 1 4 3

1 6 4 1 9 4 1 5 4 1 0 4

1 4 5 1 0 5 1 4 5 1 9 5

1 7 6 1 4 6 0 6 6 1 2 6

1 0 7 0 2 7 0 3 7 1 5 7

0 3 8 0 5 8 0 8 8 0 7 8

0 8 9 0 7 9 0 9 9 0 6 9

0 1 10 0 3 10 0 1 10 0 1 10

GW

Reply #6

Gwoof — Wed, 26 Feb 2020 18:52:11 GMT

The above counts how many times 0 to 9 hits in each position for me for last 20 games.

Just change the 20 to 25 for 25 games.

POS 1

Freq P-4 #'s

3 6 1

3 4 2

3 5 3

3 9 4

2 3 5

2 2 6

2 7 7

1 8 8

1 0 9

0 1 10

POS 2

Freq P-4 #'s

5 1 1

3 7 2

3 6 3

2 0 4

2 9 5

2 8 6

2 4 7

1 5 8

0 2 9

0 3 10

POS 3

Freq P-4 #'s

5 7 1

5 0 2

3 2 3

3 5 4... [ More ]

Reply #5

lakerben — Wed, 26 Feb 2020 18:01:01 GMT

I'm still waiting.

Reply #4

db101 — Wed, 26 Feb 2020 06:35:20 GMT

I have used Boyd French's free sheets for Pick 3/4, they have lots of unlocked formulas for tracking and manipulating numbers. Even if they are not exactly what you need, if you know some Excel you can copy and paste the formulas into your own workbooks and tweak them as necessary. https://boydfrench.blogspot.com

Reply #3

Gwoof — Tue, 25 Feb 2020 23:03:50 GMT

I don't know much about excel but maybe this might help..

Taken this from Pick 4 Excel by DiamondPalace

Separate your 4 digit number to columns B,C,D,E

Paste this in column I 5 to I 14

=COUNTIF($B$1:$B$20,H5)

Do the same for C,D,E in columns M,R W or select your own columns.

Change the B to C,D E in their pasted columns (M,R,W)

Hope it works for you

GW

Reply #2

lakerben — Tue, 25 Feb 2020 14:01:33 GMT

Alot of his links are disabled.

The reason I posted is to get a sheet like I requested.

Reply #1

Gwoof — Mon, 24 Feb 2020 22:15:36 GMT

Look-up

Pick 4 Excel by DiamondPalace

I believe that may have what your looking for.

GW

Need pick4 excel sheet

lakerben — Mon, 24 Feb 2020 21:42:23 GMT

I'd like it be able to input the last 25 draws. And be able to see how many times each number 0 to 9 has hit in each postion.

Output

P1 P2 P3 P4

0 2 1 2 0

1 3 0 0 1

2 1 3 0 0

3 4 2 1 0

4

5

6

7

8

9