how to use transposition of rows and columns in lottery matrix?Prev Topic Next Topic

dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 16, 2021, 3:55 pm

how to use transposition of rows and columns in lottery matrix? transposition is the exchange of row and column assembling small groups

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jul 16, 2021, 4:17 pm

Transpo(n|s)e(result as Range). Table values: score(row i as Range, column j as Range) as Integer.

--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	3	1	1	1	1	2	3	2	3	4	2	3	4	1	6	6	5	1	6	4
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	7	2	5	2	2	5	7	5	5	6	6	10	6	3	7	10	12	3	15	7
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	10	5	12	4	8	9	8	9	7	14	12	13	10	6	8	13	13	8	17	11
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	13	6	19	7	13	10	10	11	8	18	13	16	18	10	9	14	15	13	18	12
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	18	7	20	10	16	11	15	12	9	22	17	19	20	15	12	15	16	14	22	15
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	32	11	22	14	17	13	18	14	11	23	20	24	23	22	15	20	17	15	29	19
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	36	14	26	19	18	15	23	16	14	26	29	25	32	23	24	21	19	17	32	23
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	38	17	27	21	19	18	30	17	18	27	30	26	34	24	25	24	22	27	35	28
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	43	18	30	30	22	26	32	18	24	30	31	33	36	28	29	26	26	30	39	30
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	48	20	32	32	23	28	35	19	27	31	32	35	37	32	30	33	28	31	42	31
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	51	22	38	35	26	34	42	22	30	34	33	47	45	34	34	37	30	35	45	37
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	57	25	41	36	36	40	45	28	33	36	36	53	46	37	38	44	33	36	49	41
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	59	28	42	37	41	41	46	32	34	38	40	55	50	38	39	45	49	41	52	43
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	60	35	46	43	50	47	48	46	37	39	50	57	52	39	43	47	51	48	53	44
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	61	37	53	47	53	48	49	55	43	40	53	59	55	43	48	48	53	49	57	50
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	65	39	56	50	54	54	56	59	45	47	54	61	57	54	49	54	54	50	60	52
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	66	43	60	52	56	58	64	60	46	48	56	64	58	55	54	58	60	52	61	55
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	67	51	61	56	60	61	65	67	49	51	57	65	59	61	57	61	65	53	62	56
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	68	59	63	63	62	62	67	69	63	54	59	67	66	63	64	63	66	63	66	57
--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	70	67	69	68	66	68	69	70	68	64	64	70	67	67	68	65	70	70	70	59
ID	#DATE#	N1	N2	N3	N4	N5	N6	N7	N8	N9	N10	N11	N12	N13	N14	N15	N16	N17	N18	N19	N20	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--	--
4271	25/06/2021	3	7	10	13	18	32	36	38	43	48	51	57	59	60	61	65	66	67	68	70	20	6	4	6	5	6	8	6	5	5	5	9	8	7	6	5	6	5	7	4
4272	26/06/2021	1	2	5	6	7	11	14	17	18	20	22	25	28	35	37	39	43	51	59	67	6	20	4	7	5	5	4	10	7	6	5	4	6	8	5	4	5	4	6	6
4273	27/06/2021	1	5	12	19	20	22	26	27	30	32	38	41	42	46	53	56	60	61	63	69	4	4	20	6	8	4	6	8	5	5	6	4	3	6	3	4	8	6	6	5
4274	28/06/2021	1	2	4	7	10	14	19	21	30	32	35	36	37	43	47	50	52	56	63	68	6	7	6	20	6	4	6	4	7	5	6	4	7	6	4	6	2	8	3	9
4275	29/06/2021	1	2	8	13	16	17	18	19	22	23	26	36	41	50	53	54	56	60	62	66	5	5	8	6	20	7	4	7	2	6	8	5	5	4	2	3	10	8	7	5
4276	30/06/2021	2	5	9	10	11	13	15	18	26	28	34	40	41	47	48	54	58	61	62	68	6	5	4	4	7	20	4	6	6	7	4	5	4	6	6	9	6	4	4	4
4277	1/07/2021	3	7	8	10	15	18	23	30	32	35	42	45	46	48	49	56	64	65	67	69	8	4	6	6	4	4	20	5	8	5	4	6	7	6	7	5	4	7	7	5
4278	2/07/2021	2	5	9	11	12	14	16	17	18	19	22	28	32	46	55	59	60	67	69	70	6	10	8	4	7	6	5	20	6	3	5	6	6	5	2	1	9	3	6	6
4279	3/07/2021	3	5	7	8	9	11	14	18	24	27	30	33	34	37	43	45	46	49	63	68	5	7	5	7	2	6	8	6	20	5	2	3	5	6	9	6	4	7	3	5
4280	4/07/2021	4	6	14	18	22	23	26	27	30	31	34	36	38	39	40	47	48	51	54	64	5	6	5	5	6	7	5	3	5	20	7	3	6	7	8	6	5	6	4	4
4281	5/07/2021	2	6	12	13	17	20	29	30	31	32	33	36	40	50	53	54	56	57	59	64	5	5	6	6	8	4	4	5	2	7	20	6	7	3	7	5	7	7	6	7
4282	6/07/2021	3	10	13	16	19	24	25	26	33	35	47	53	55	57	59	61	64	65	67	70	9	4	4	4	5	5	6	6	3	3	6	20	5	6	4	8	8	5	5	4
4283	7/07/2021	4	6	10	18	20	23	32	34	36	37	45	46	50	52	55	57	58	59	66	67	8	6	3	7	5	4	7	6	5	6	7	5	20	8	3	6	1	3	7	8
4284	8/07/2021	1	3	6	10	15	22	23	24	28	32	34	37	38	39	43	54	55	61	63	67	7	8	6	6	4	6	6	5	6	7	3	6	8	20	8	8	4	4	6	6
4285	9/07/2021	6	7	8	9	12	15	24	25	29	30	34	38	39	43	48	49	54	57	64	68	6	5	3	4	2	6	7	2	9	8	7	4	3	8	20	5	5	5	6	6
4286	10/07/2021	6	10	13	14	15	20	21	24	26	33	37	44	45	47	48	54	58	61	63	65	5	4	4	6	3	9	5	1	6	6	5	8	6	8	5	20	6	5	4	3
4287	11/07/2021	5	12	13	15	16	17	19	22	26	28	30	33	49	51	53	54	60	65	66	70	6	5	8	2	10	6	4	9	4	5	7	8	1	4	5	6	20	7	8	5
4288	12/07/2021	1	3	8	13	14	15	17	27	30	31	35	36	41	48	49	50	52	53	63	70	5	4	6	8	8	4	7	3	7	6	7	5	3	4	5	5	7	20	7	6
4289	13/07/2021	6	15	17	18	22	29	32	35	39	42	45	49	52	53	57	60	61	62	66	70	7	6	6	3	7	4	7	6	3	4	6	5	7	6	6	4	8	7	20	3
4290	14/07/2021	4	7	11	12	15	19	23	28	30	31	37	41	43	44	50	52	55	56	57	59	4	6	5	9	5	4	5	6	5	4	7	4	8	6	6	3	5	6	3	20

Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jul 16, 2021, 4:34 pm

Public Function keno_score(rg_a As range, rg_b As range) As Integer
Dim a, b
keno_score = 0
For a = 1 To rg_a.Cells.count
For b = 1 To rg_b.Cells.count
If rg_a.Cells(a) = rg_b.Cells(b) Then keno_score = keno_score + 1: Exit For
Next b
Next a
End Function

'Can be written differently, but this one works.

RG A RG B

1 0

2 3

3 5

4 9

5 12

2 -

=keno_score(RG_A;RG_B)
justadream

united states
United States
Member #212,945
January 21, 2021
477 Posts
Online

Jul 16, 2021, 8:07 pm

I haven't a clue what you did or why....but I"m impressed . lol
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 1:58 am

ok speller. great job , one of my lotteries is lottomania uses 100 numbers and is drawn 20 or 100/20
ex= draws 100/20
06 11 14 16 21 22 25 32 33 34 46 61 70 73 78 88 89 90 95 00
08 11 14 17 18 24 29 37 44 49 51 55 62 63 64 76 82 84 93 97
08 10 11 17 20 22 28 34 45 47 48 54 55 57 67 74 79 85 91 99
05 12 14 25 30 35 39 41 44 49 51 55 60 63 64 67 78 83 93 98
08 17 20 28 32 39 42 43 51 54 59 65 69 71 73 87 92 98 99 00
12 13 17 20 24 27 30 33 35 42 47 48 58 72 73 74 75 76 80 93
03 06 18 19 23 36 39 45 46 50 56 59 64 70 73 85 92 94 97 99
05 07 10 11 19 26 33 41 47 53 57 59 65 74 75 83 84 94 99 00
01 03 07 09 10 17 21 22 29 30 32 36 60 67 69 70 73 77 98 00
08 09 25 28 34 38 41 42 47 51 55 60 63 65 79 81 86 87 95 98
08 14 16 24 34 35 46 51 53 54 58 64 71 74 78 79 83 87 93 94
05 10 16 20 21 22 28 32 36 37 39 43 49 52 56 63 65 81 88 89
02 03 06 32 35 42 47 56 58 59 66 68 75 76 79 82 84 88 91 00
03 04 11 13 18 29 30 36 37 40 43 52 55 59 76 81 83 85 86 97
04 05 12 13 14 15 19 22 26 29 31 38 41 48 54 65 73 92 94 97
01 10 11 12 13 16 22 29 45 46 48 49 51 57 59 63 73 78 91 94
01 13 19 22 29 30 31 37 38 39 43 47 59 61 78 79 92 96 97 98
05 16 32 34 40 46 47 59 60 69 70 76 78 79 85 91 92 96 97 00
08 10 11 13 18 21 25 31 33 36 48 53 67 77 82 86 94 98 99 00
20 26 30 31 42 43 51 55 59 60 61 65 70 71 72 75 84 90 93 97
02 07 08 16 26 29 38 41 45 54 59 67 71 73 75 77 89 92 97 99
05 11 13 23 29 33 37 38 41 42 45 49 56 79 84 85 93 94 95 00
04 17 18 19 24 25 26 28 31 32 37 40 41 53 60 64 77 78 89 99
01 11 13 23 32 41 42 43 45 46 48 49 50 51 59 66 75 86 94 95
05 19 21 31 45 46 47 48 49 59 64 73 82 85 88 92 93 94 95 98
03 04 05 13 15 19 27 30 32 33 42 48 49 51 53 66 78 81 88 92
01 03 06 16 19 21 31 32 39 56 58 59 61 71 75 82 84 86 91 98
05 24 33 37 41 44 45 49 54 56 57 60 64 65 67 68 73 85 89 96
01 02 05 09 11 27 29 42 53 61 68 69 74 78 84 85 86 87 93 96
05 15 22 23 24 29 33 34 36 40 42 43 49 60 61 71 72 79 97 00
01 07 08 10 13 14 15 24 35 43 44 48 52 53 64 68 73 79 94 00
05 12 17 20 23 28 29 39 41 42 49 66 67 76 79 80 83 92 94 95
06 11 12 13 14 23 28 33 34 39 49 52 56 60 71 76 82 86 90 93
02 09 12 14 19 20 23 24 28 44 45 51 54 58 61 66 77 79 82 89
04 08 11 12 14 22 23 28 36 42 47 48 49 53 54 60 67 85 88 99
05 09 16 17 43 50 51 55 56 57 58 65 69 71 76 78 85 86 88 89
01 03 06 09 17 20 21 35 38 43 44 50 52 55 73 74 82 97 98 99
02 04 11 12 20 23 30 35 36 49 53 55 56 57 58 61 66 83 98 99
02 05 09 11 17 18 24 26 30 33 38 44 52 57 70 72 78 81 84 00
winsumloosesum

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

Jul 17, 2021, 9:36 am

What exactly are you transposing dr san?

Can you give an example of what you want to do?

You always ask for help but don't give enough information about what you want to accomplish.

Kind of leaves us scratching our heads.
winsumloosesum

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

Jul 17, 2021, 10:13 am

Quote: Originally posted by dr san on Jul 16, 2021
how to use transposition of rows and columns in lottery matrix? transposition is the exchange of row and column assembling small groups

Not sure if this is what you wanted:

https://u.pcloud.link/publink/show?code=XZiBuCXZn2YRlQtBIdBq57dnqso0f0C21Gry

dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 10:40 am

hello, winsum, ok

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 10:42 am

is an example for pick 3 where you can use the 5-digit string to filter one of the lines to have zero

dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 10:45 am

ex draws 876 pick3

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 10:49 am

note that in the example pick 876 we get a 5 digit red string to filter or exclude this row, we have the columns
goal and see empty lines or strings to filter
so in the example of 876 I only needed the line =
56789
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 10:59 am

ex= na pick3

172

0 1 2 3 4

5 6 7 8 9

0 2 4 6 8

1 3 5 7 9
dr san

bgonÃ§alves
Brasil
Member #92,560
June 9, 2010
3,779 Posts
Offline

Jul 17, 2021, 11:03 am

the transposition technique is still missing
simulate a lot! to catch the intersections
correct! the transposition technique can be used in any lottery, we have to find the paths
Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jul 17, 2021, 11:57 am

Your matrix-math is wrong.

Matrix A;

(A^t)^t=A

I didn't dwell long on this.
Speler

Belgium
Member #214,858
April 17, 2021
2,445 Posts
Offline

Jul 17, 2021, 12:01 pm

You will run into the legendary CRIBEDIS!

New Topic New Poll

Subscribe to this topic

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

RG A	RG B
1	0
2	3
3	5
4	9
5	12
2	-
=keno_score(RG_A;RG_B)

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

how to use transposition of rows and columns in lottery matrix?Prev TopicNext Topic

how to use transposition of rows and columns in lottery matrix?Prev Topic Next Topic

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9

0	1	2	3	4	5	6	7	8	9


	0	3	6	9	2
	1	4	7	0	3
	2	5	8	1	4

	5	8	1	4	7
	6	9	2	5	8
	7	0	3	6	9

	0	1	2	3	4
	5	6	7	8	9
	0	2	4	6	8
	1	3	5	7	9