Using Excel 2000</SPAN></SPAN>
Hi,</SPAN></SPAN>
Here I have a question how to reduce betting blokes that can guarantee max 1 incorrect, what I mean this, for example "Euromillions" playing 8 numbers direct we are playing 56 lines it cost 140€ "Formula=COMBIN(8,5)" if out of 8 numbers 5 numbers are correct we get the 1st price guarantee 100%. </SPAN></SPAN>
But instead 8 numbers direct if played in reduction we play only 5 lines it cost 12.50€ but it guarantee only 4 numbers can be correct if numbers drawn any 5 out of played 8. So far 1 number less. </SPAN></SPAN>
My question is about to play football reduction...it is difficult how do I explain it but here is my attempt...</SPAN></SPAN>
Say for in example1 there are 2 teams the can have the end result in a 9 different ways as shown in the cells C6:D14...I can bet all 9 but as it is a money question I want to play less combinations but ensuring 1 must be correct out of any 9 results if I bet 3 lines as shown in the cells H6:I8 there is minimum 1 correct and 1 wrong. </SPAN></SPAN>
Example1...</SPAN></SPAN>
Say for in example2 there are 3 teams the can have the end result in a 27 different ways as shown in the cells C6:E32...I can bet all 27 but as it is a money question I want to play less combinations but ensuring 1 must be correct out of any 27 results if I bet 6 lines as shown in the cells H6:J11 there is minimum 2 correct and one wrong.</SPAN></SPAN>
Example2...
</SPAN></SPAN>
The above result I have come up checking one by one it has took 2, 3 days to ensure. </SPAN></SPAN>
And I guess they are right but not sure 100%</SPAN></SPAN>
As the team increases lines increases...now I want to work out with 4 teams there would be 81 lines as per example3, is there any macro or VBA can extract only those lines out of 81 which has 3 correct and 1 wrong... manually I think it is not possible for me.</SPAN></SPAN>
Example3...
</SPAN></SPAN>
Thank you in advance</SPAN></SPAN>
Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>
Hi,</SPAN></SPAN>
Here I have a question how to reduce betting blokes that can guarantee max 1 incorrect, what I mean this, for example "Euromillions" playing 8 numbers direct we are playing 56 lines it cost 140€ "Formula=COMBIN(8,5)" if out of 8 numbers 5 numbers are correct we get the 1st price guarantee 100%. </SPAN></SPAN>
But instead 8 numbers direct if played in reduction we play only 5 lines it cost 12.50€ but it guarantee only 4 numbers can be correct if numbers drawn any 5 out of played 8. So far 1 number less. </SPAN></SPAN>
My question is about to play football reduction...it is difficult how do I explain it but here is my attempt...</SPAN></SPAN>
Say for in example1 there are 2 teams the can have the end result in a 9 different ways as shown in the cells C6:D14...I can bet all 9 but as it is a money question I want to play less combinations but ensuring 1 must be correct out of any 9 results if I bet 3 lines as shown in the cells H6:I8 there is minimum 1 correct and 1 wrong. </SPAN></SPAN>
Example1...</SPAN></SPAN>
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | |||||||||||||
2 | |||||||||||||
3 | |||||||||||||
4 | |||||||||||||
5 | Combi n | Team1 | Team2 | Combi n | Team1 | Team2 | |||||||
6 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
7 | 2 | 1 | X | 2 | X | X | |||||||
8 | 3 | 1 | 2 | 3 | 2 | 1 | |||||||
9 | 4 | X | 1 | ||||||||||
10 | 5 | X | X | ||||||||||
11 | 6 | X | 2 | ||||||||||
12 | 7 | 2 | 1 | ||||||||||
13 | 8 | 2 | X | ||||||||||
14 | 9 | 2 | 2 | ||||||||||
15 | |||||||||||||
16 | |||||||||||||
17 | |||||||||||||
18 | |||||||||||||
Sheet2 |
Say for in example2 there are 3 teams the can have the end result in a 27 different ways as shown in the cells C6:E32...I can bet all 27 but as it is a money question I want to play less combinations but ensuring 1 must be correct out of any 27 results if I bet 6 lines as shown in the cells H6:J11 there is minimum 2 correct and one wrong.</SPAN></SPAN>
Example2...
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | ||||||||||||||
2 | ||||||||||||||
3 | ||||||||||||||
4 | ||||||||||||||
5 | Combi n | Team1 | Team2 | Team3 | Combi n | Team1 | Team2 | Team3 | ||||||
6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
7 | 2 | 1 | 1 | X | 2 | X | X | X | ||||||
8 | 3 | 1 | 1 | 2 | 3 | 2 | 2 | 2 | ||||||
9 | 4 | 1 | X | 1 | 4 | X | 1 | 1 | ||||||
10 | 5 | 1 | X | X | 5 | 2 | 1 | 1 | ||||||
11 | 6 | 1 | X | 2 | 6 | 1 | X | X | ||||||
12 | 7 | 1 | 2 | 1 | ||||||||||
13 | 8 | 1 | 2 | X | ||||||||||
14 | 9 | 1 | 2 | 2 | ||||||||||
15 | 10 | X | 1 | 1 | ||||||||||
16 | 11 | X | 1 | X | ||||||||||
17 | 12 | X | 1 | 2 | ||||||||||
18 | 13 | X | X | 1 | ||||||||||
19 | 14 | X | X | X | ||||||||||
20 | 15 | X | X | 2 | ||||||||||
21 | 16 | X | 2 | 1 | ||||||||||
22 | 17 | X | 2 | X | ||||||||||
23 | 18 | X | 2 | 2 | ||||||||||
24 | 19 | 2 | 1 | 1 | ||||||||||
25 | 20 | 2 | 1 | X | ||||||||||
26 | 21 | 2 | 1 | 2 | ||||||||||
27 | 22 | 2 | X | 1 | ||||||||||
28 | 23 | 2 | X | X | ||||||||||
29 | 24 | 2 | X | 2 | ||||||||||
30 | 25 | 2 | 2 | 1 | ||||||||||
31 | 26 | 2 | 2 | X | ||||||||||
32 | 27 | 2 | 2 | 2 | ||||||||||
33 | ||||||||||||||
34 | ||||||||||||||
35 | ||||||||||||||
36 | ||||||||||||||
Sheet3 |
The above result I have come up checking one by one it has took 2, 3 days to ensure. </SPAN></SPAN>
And I guess they are right but not sure 100%</SPAN></SPAN>
As the team increases lines increases...now I want to work out with 4 teams there would be 81 lines as per example3, is there any macro or VBA can extract only those lines out of 81 which has 3 correct and 1 wrong... manually I think it is not possible for me.</SPAN></SPAN>
Example3...
Book1 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | |||||||||||||||||
2 | |||||||||||||||||
3 | |||||||||||||||||
4 | |||||||||||||||||
5 | Combi n | Team1 | Team2 | Team3 | Team4 | Combi n | Team1 | Team2 | Team3 | Team4 | |||||||
6 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
7 | 2 | 1 | 1 | 1 | X | ? | |||||||||||
8 | 3 | 1 | 1 | 1 | 2 | ? | |||||||||||
9 | 4 | 1 | 1 | X | 1 | ? | |||||||||||
10 | 5 | 1 | 1 | X | X | ? | |||||||||||
11 | 6 | 1 | 1 | X | 2 | ? | |||||||||||
12 | 7 | 1 | 1 | 2 | 1 | ? | |||||||||||
13 | 8 | 1 | 1 | 2 | X | ? | |||||||||||
14 | 9 | 1 | 1 | 2 | 2 | ? | |||||||||||
15 | 10 | 1 | X | 1 | 1 | ? | |||||||||||
16 | 11 | 1 | X | 1 | X | ? | |||||||||||
17 | 12 | 1 | X | 1 | 2 | ? | |||||||||||
18 | 13 | 1 | X | X | 1 | ? | |||||||||||
19 | 14 | 1 | X | X | X | ? | |||||||||||
20 | 15 | 1 | X | X | 2 | ||||||||||||
21 | 16 | 1 | X | 2 | 1 | ||||||||||||
22 | 17 | 1 | X | 2 | X | ||||||||||||
23 | 18 | 1 | X | 2 | 2 | ||||||||||||
24 | 19 | 1 | 2 | 1 | 1 | ||||||||||||
25 | 20 | 1 | 2 | 1 | X | ||||||||||||
26 | 21 | 1 | 2 | 1 | 2 | ||||||||||||
27 | 22 | 1 | 2 | X | 1 | ||||||||||||
28 | 23 | 1 | 2 | X | X | ||||||||||||
29 | 24 | 1 | 2 | X | 2 | ||||||||||||
30 | 25 | 1 | 2 | 2 | 1 | ||||||||||||
31 | 26 | 1 | 2 | 2 | X | ||||||||||||
32 | 27 | 1 | 2 | 2 | 2 | ||||||||||||
33 | 28 | X | 1 | 1 | 1 | ||||||||||||
34 | 29 | X | 1 | 1 | X | ||||||||||||
35 | 30 | X | 1 | 1 | 2 | ||||||||||||
36 | 31 | X | 1 | X | 1 | ||||||||||||
37 | 32 | X | 1 | X | X | ||||||||||||
38 | 33 | X | 1 | X | 2 | ||||||||||||
39 | 34 | X | 1 | 2 | 1 | ||||||||||||
40 | 35 | X | 1 | 2 | X | ||||||||||||
41 | 36 | X | 1 | 2 | 2 | ||||||||||||
42 | 37 | X | X | 1 | 1 | ||||||||||||
43 | 38 | X | X | 1 | X | ||||||||||||
44 | 39 | X | X | 1 | 2 | ||||||||||||
45 | 40 | X | X | X | 1 | ||||||||||||
46 | 41 | X | X | X | X | ||||||||||||
47 | 42 | X | X | X | 2 | ||||||||||||
48 | 43 | X | X | 2 | 1 | ||||||||||||
49 | 44 | X | X | 2 | X | ||||||||||||
50 | 45 | X | X | 2 | 2 | ||||||||||||
51 | 46 | X | 2 | 1 | 1 | ||||||||||||
52 | 47 | X | 2 | 1 | X | ||||||||||||
53 | 48 | X | 2 | 1 | 2 | ||||||||||||
54 | 49 | X | 2 | X | 1 | ||||||||||||
55 | 50 | X | 2 | X | X | ||||||||||||
56 | 51 | X | 2 | X | 2 | ||||||||||||
57 | 52 | X | 2 | 2 | 1 | ||||||||||||
58 | 53 | X | 2 | 2 | X | ||||||||||||
59 | 54 | X | 2 | 2 | 2 | ||||||||||||
60 | 55 | 2 | 1 | 1 | 1 | ||||||||||||
61 | 56 | 2 | 1 | 1 | X | ||||||||||||
62 | 57 | 2 | 1 | 1 | 2 | ||||||||||||
63 | 58 | 2 | 1 | X | 1 | ||||||||||||
64 | 59 | 2 | 1 | X | X | ||||||||||||
65 | 60 | 2 | 1 | X | 2 | ||||||||||||
66 | 61 | 2 | 1 | 2 | 1 | ||||||||||||
67 | 62 | 2 | 1 | 2 | X | ||||||||||||
68 | 63 | 2 | 1 | 2 | 2 | ||||||||||||
69 | 64 | 2 | X | 1 | 1 | ||||||||||||
70 | 65 | 2 | X | 1 | X | ||||||||||||
71 | 66 | 2 | X | 1 | 2 | ||||||||||||
72 | 67 | 2 | X | X | 1 | ||||||||||||
73 | 68 | 2 | X | X | X | ||||||||||||
74 | 69 | 2 | X | X | 2 | ||||||||||||
75 | 70 | 2 | X | 2 | 1 | ||||||||||||
76 | 71 | 2 | X | 2 | X | ||||||||||||
77 | 72 | 2 | X | 2 | 2 | ||||||||||||
78 | 73 | 2 | 2 | 1 | 1 | ||||||||||||
79 | 74 | 2 | 2 | 1 | X | ||||||||||||
80 | 75 | 2 | 2 | 1 | 2 | ||||||||||||
81 | 76 | 2 | 2 | X | 1 | ||||||||||||
82 | 77 | 2 | 2 | X | X | ||||||||||||
83 | 78 | 2 | 2 | X | 2 | ||||||||||||
84 | 79 | 2 | 2 | 2 | 1 | ||||||||||||
85 | 80 | 2 | 2 | 2 | X | ||||||||||||
86 | 81 | 2 | 2 | 2 | 2 | ||||||||||||
87 | |||||||||||||||||
88 | |||||||||||||||||
89 | |||||||||||||||||
90 | |||||||||||||||||
Sheet4 |
Thank you in advance</SPAN></SPAN>
Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>