I have created a macro excel 2010 that counts Frequency and counts skips on keno and other lottery's ,,
Question do they work ?
Well did some testing on past numbers and seems to work ok only if you focus on 1 and 2 skips.
Going to test this out this week playing 5 numbers 0n 20/80 keno and i will keep you posted on the outcomes.
Also I Cant share the .xls on this post as its says I cant share links ? must be for new members ??
Excel sheet looks like this,
sheet 1 looks like this
note: i couldn't post all 80 number on this page so 1 to 13 as an example
ball_1 |
ball_2 |
ball_3 |
ball_4 |
ball_5 |
ball_6 |
ball_7 |
ball_8 |
ball_9 |
ball_10 |
ball_11 |
ball_12 |
ball_13 |
1 |
2 |
4 |
7 |
9 |
11 |
12 |
13 |
17 |
27 |
33 |
35 |
40 |
1 |
4 |
8 |
16 |
17 |
20 |
32 |
40 |
41 |
44 |
45 |
51 |
52 |
2 |
7 |
10 |
17 |
20 |
25 |
35 |
37 |
38 |
40 |
41 |
44 |
48 |
10 |
14 |
15 |
17 |
19 |
20 |
24 |
26 |
27 |
34 |
35 |
38 |
39 |
7 |
8 |
15 |
16 |
26 |
28 |
41 |
43 |
53 |
55 |
60 |
61 |
62 |
6 |
10 |
16 |
20 |
21 |
22 |
27 |
29 |
33 |
34 |
38 |
39 |
40 |
3 |
5 |
11 |
12 |
13 |
14 |
15 |
21 |
35 |
38 |
40 |
47 |
49 |
3 |
4 |
7 |
8 |
10 |
11 |
12 |
20 |
22 |
28 |
33 |
36 |
37 |
10 |
11 |
20 |
22 |
23 |
27 |
28 |
30 |
34 |
35 |
37 |
38 |
39 |
2 |
7 |
9 |
10 |
16 |
24 |
28 |
33 |
39 |
44 |
47 |
49 |
55 |
4 |
9 |
19 |
23 |
25 |
35 |
38 |
39 |
42 |
50 |
54 |
55 |
58 |
3 |
4 |
6 |
11 |
17 |
21 |
25 |
26 |
27 |
28 |
29 |
31 |
32 |
6 |
12 |
16 |
17 |
19 |
26 |
27 |
29 |
48 |
50 |
51 |
52 |
55 |
On the Frequency sheet Click the Keno Macro and it will count number of hits each number come up with a 1 from sheet 1 like this :
note: i couldn't post all number on this page so 1 to 13 as an example
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
1 |
1 |
0 |
1 |
0 |
0 |
1 |
0 |
1 |
0 |
1 |
1 |
1 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
1 |
0 |
0 |
1 |
1 |
0 |
0 |
1 |
1 |
0 |
1 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
On the Frequency sheet Click the Frequency Macro and it will count how many skips each number from sheet 1 like this
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
1 |
1 |
0 |
1 |
0 |
0 |
1 |
0 |
1 |
0 |
1 |
1 |
1 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
6 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
7 |
0 |
7 |
0 |
0 |
0 |
0 |
0 |
6 |
6 |
6 |
0 |
0 |
1 |
6 |
0 |
0 |
3 |
3 |
0 |
2 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
0 |
0 |
0 |
7 |
0 |
0 |
0 |
0 |
2 |
0 |
9 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
3 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
4 |
1 |
0 |
6 |
0 |
0 |
0 |
0 |
3 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
5 |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
4 |
0 |
3 |
0 |
2 |
0 |
0 |
13 |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
1 |
2 |
0 |