Jump to content

Criando Matriz pelo método rotação


BigMax

Recommended Posts

Como criar uma matriz pelo metodo de rotação.

Exemplo de criação da matriz 20,8,4,7=10 
chave 01-02-03-04-01-02-03-04

1) No excel crie uma linha de 01 a 20 ( veja fig. 01 destacado em verde)
2) Orientando pela chave, vá descendo os números na linha abaixo da linha mestre, posicionando na primeira coluna o número com diferença de 01 (em azul na fig. 01)
3) Na terceira linha desça os números com diferença de 2 do número da primeira coluna (segunda linha destacado em azul)Criando matriz 
4) Proceder assim até o limite ( não exceder o número limite nesse caso o 20)
5) As linhas que correspondem a matriz 20,8,4,7 estão na vertical, portanto copia-las e colar usando a opção transpor do Excel. (Veja Fig. 02)
6) Elimine as linhas duplicadas resultando as 10 linhas da Fig 03
7) Construída a matriz 20,8,4,7=10 (100%)

Vide no post abaixo as chaves correspondentes a algumas matrizes.

Caso interesse veja um software ( Crea sistemi a rotazione con Chiave) disponível em:

https://wheels.forumcommunity.net/?t=59533847#entry422726187

 

image.png.08f0db6b59d6dafbba1f720664efb691.png

 

image.png.eca0581e2959ac5f9fcd70a1dac8815f.png

 

image.png.8ca4edff905dfc8f308eae976f6efc0e.png

  • Like 3
Link to comment
Share on other sites


------------------------------ Formazione 03
chiave 02-02-02 > sistema 06,03,02,03 = colonne 02
chiave 03-03-03 > sistema 09,03,02,04 = colonne 03
chiave 04-04-04 > sistema 12,03,02,05 = colonne 04
chiave 05-05-05 > sistema 15,03,02,06 = colonne 05
chiave 06-06-06 > sistema 18,03,02,07 = colonne 06
chiave 07-07-07 > sistema 21,03,02,08 = colonne 07
chiave 08-08-08 > sistema 24,03,02,09 = colonne 08
chiave 09-09-09 > sistema 27,03,02,10 = colonne 09
chiave 10-10-10 > sistema 30,03,02,11 = colonne 10
chiave 11-11-11 > sistema 33,03,02,12 = colonne 11
chiave 12-12-12 > sistema 36,03,02,13 = colonne 12
chiave 13-13-13 > sistema 39,03,02,14 = colonne 13
chiave 14-14-14 > sistema 42,03,02,15 = colonne 14
chiave 15-15-15 > sistema 45,03,02,16 = colonne 15
chiave 16-16-16 > sistema 48,03,02,17 = colonne 16
chiave 17-17-17 > sistema 51,03,02,18 = colonne 17
chiave 18-18-18 > sistema 54,03,02,19 = colonne 18
chiave 19-19-19 > sistema 57,03,02,20 = colonne 19
********************************************
Chiave 01-01-02 > sistema 04,03,03,03= colonne 04
Chiave 01-02-03 > sistema 06,03,03,04= colonne 06
chiave 01-03-04 > sistema 08,03,03,05= colonne 08
chiave 01-04-05 > sistema 10,03,03,06= colonne 10
chiave 01-05-06 > sistema 12,03,03,07= colonne 12
chiave 01-06-07 > sistema 14,03,03,08= colonne 14
chiave 01-07-08 > sistema 16,03,03,09= colonne 16
chiave 01-08-09 > sistema 18,03,03,10= colonne 18
chiave 01-09-10 > sistema 20,03,03,11= colonne 20
chiave 01-10-11 > sistema 22,03,03,12= colonne 22
chiave 01-11-12 > sistema 24,03,03,13= colonne 24
chiave 01-12-13 > sistema 26,03,03,14= colonne 26
chiave 01-13-14 > sistema 28,03,03,15= colonne 28
chiave 01-14-15 > sistema 30,03,03,16= colonne 30
chiave 01-15-16 > sistema 32,03,03,17= colonne 32
chiave 01-16-17 > sistema 34,03,03,18= colonne 34
chiave 01-17-18 > sistema 36,03,03,19= colonne 36
Chiave 01-18-19 > sistema 38,03,03,20= colonne 38

------------------------------ Formazione 04
chiave 02-02-02-02 > sistema 08,04,02,03 = colonne 02
chiave 03-03-03-03 > sistema 12,04,02,04 = colonne 03
chiave 04-04-04-04 > sistema 16,04,02,05 = colonne 04
chiave 05-05-05-05 > sistema 20,04,02,06 = colonne 05
chiave 06-06-06-06 > sistema 24,04,02,07 = colonne 06
chiave 07-07-07-07 > sistema 28,04,02,08 = colonne 07
chiave 08-08-08-08 > sistema 32,04,02,09 = colonne 08
chiave 09-09-09-09 > sistema 36,04,02,10 = colonne 09
chiave 10-10-10-10 > sistema 40,04,02,11 = colonne 10
chiave 11-11-11-11 > sistema 44,04,02,12 = colonne 11
chiave 12-12-12-12 > sistema 48,04,02,13 = colonne 12
chiave 13-13-13-13 > sistema 52,04,02,14 = colonne 13
chiave 14-14-14-14 > sistema 56,04,02,15 = colonne 14
chiave 15-15-15-15 > sistema 60,04,02,16 = colonne 15
chiave 16-16-16-16 > sistema 64,04,02,17 = colonne 16
chiave 17-17-17-17 > sistema 68,04,02,18 = colonne 17
chiave 18-18-18-18 > sistema 72,04,02,19 = colonne 18
chiave 19-19-19-19 > sistema 76,04,02,20 = colonne 19
************************************************
chiave 01-01-02-02 > sistema 06,04,03,03 = colonne 06
chiave 01-02-03-03 > sistema 09,04,03,04 = colonne 09
chiave 01-03-04-04 > sistema 12,04,03,05 = colonne 12
chiave 01-04-05-05 > sistema 15,04,03,06 = colonne 15
chiave 01-05-06-06 > sistema 18,04,03,07 = colonne 18
chiave 01-06-07-07 > sistema 21,04,03,08 = colonne 21
chiave 01-07-08-08 > sistema 24,04,03,09 = colonne 24
chiave 01-08-09-09 > sistema 27,04,03,10 = colonne 27
chiave 01-09-10-10 > sistema 30,04,03,11 = colonne 30
chiave 01-10-11-11 > sistema 33,04,03,12 = colonne 33
chiave 01-11-12-12 > sistema 36,04,03,13 = colonne 36
chiave 01-12-13-13 > sistema 39,04,03,14 = colonne 39
chiave 01-13-14-14 > sistema 42,04,03,15 = colonne 42
chiave 01-14-15-15 > sistema 45,04,03,16 = colonne 45
chiave 01-15-16-16 > sistema 48,04,03,17 = colonne 48
chiave 01-16-17-17 > sistema 51,04,03,18 = colonne 51
chiave 01-17-18-18 > sistema 54,04,03,19 = colonne 54
chiave 01-18-19-19 > sistema 57,04,03,20 = colonne 57
************************************************
chiave 01-01-02-03- > sistema 07,04,04,05= colonne 07
chiave 01-02-03-04- > sistema 10,04,04,07= colonne 10
*************************************************

------------------------------ Formazione 05
chiave 02-02-02-02-02 > sistema 10,05,02,03 = colonne 02
chiave 03-03-03-03-03 > sistema 15,05,02,04 = colonne 03
chiave 04-04-04-04-04 > sistema 20,05,02,05 = colonne 04
chiave 05-05-05-05-05 > sistema 25,05,02,06 = colonne 05
chiave 06-06-06-06-06 > sistema 30,05,02,07 = colonne 06
chiave 07-07-07-07-07 > sistema 35,05,02,08 = colonne 07
chiave 08-08-08-08-08 > sistema 40,05,02,09 = colonne 08
chiave 09-09-09-09-09 > sistema 45,05,02,10 = colonne 09
chiave 10-10-10-10-10 > sistema 50,05,02,11 = colonne 10
chiave 11-11-11-11-11 > sistema 55,05,02,12 = colonne 11
chiave 12-12-12-12-12 > sistema 60,05,02,13 = colonne 12
chiave 13-13-13-13-13 > sistema 65,05,02,14 = colonne 13
chiave 14-14-14-14-14 > sistema 70,05,02,15 = colonne 14
chiave 15-15-15-15-15 > sistema 75,05,02,16 = colonne 15
chiave 16-16-16-16-16 > sistema 80,05,02,17 = colonne 16
chiave 17-17-17-17-17 > sistema 85,05,02,18 = colonne 17
chiave 18-18-18-18-18 > sistema 90,05,02,19 = colonne 18
**************************************************
chiave 01-01-02-02-02 > sistema 08,05,03,03 = colonne 08
chiave 01-02-03-03-03 > sistema 12,05,03,04 = colonne 12
chiave 01-03-04-04-04 > sistema 16,05,03,05 = colonne 16
chiave 01-04-05-05-05 > sistema 20,05,03,06 = colonne 20
chiave 01-05-06-06-06 > sistema 24,05,03,07 = colonne 24
chiave 01-06-07-07-07 > sistema 28,05,03,08 = colonne 28
chiave 01-07-08-08-08 > sistema 32,05,03,09 = colonne 32
chiave 01-08-09-09-09 > sistema 36,05,03,10 = colonne 36
chiave 01-09-10-10-10 > sistema 40,05,03,11 = colonne 40
chiave 01-10-11-11-11 > sistema 44,05,03,12 = colonne 44
chiave 01-11-12-12-12 > sistema 48,05,03,13 = colonne 48
chiave 01-12-13-13-13 > sistema 52,05,03,14 = colonne 52
chiave 01-13-14-14-14 > sistema 56,05,03,15 = colonne 56
chiave 01-14-15-15-15 > sistema 60,05,03,16 = colonne 60
chiave 01-15-16-16-16 > sistema 64,05,03,17 = colonne 64
chiave 01-16-17-17-17 > sistema 68,05,03,18 = colonne 68
chiave 01-17-18-18-18 > sistema 72,05,03,19 = colonne 72
chiave 01-18-19-19-19 > sistema 76,05,03,20 = colonne 76
***************************************************
chiave 01-03-01-02-04 > sistema 11,05,04,06 = colonne 11
chiave 01-02-01-04-05 > sistema 13,05,04,07 = colonne 13
***************************************************
------------------------------ Formazione 06
chiave 02-02-02-02-02-02 > sistema 12,06,02,03 = colonne 02
chiave 03-03-03-03-03-03 > sistema 18,06,02,04 = colonne 03
chiave 04-04-04-04-04-04 > sistema 24,06,02,05 = colonne 04
chiave 05-05-05-05-05-05 > sistema 30,06,02,06 = colonne 05
chiave 06-06-06-06-06-06 > sistema 36,06,02,07 = colonne 06
chiave 07-07-07-07-07-07 > sistema 42,06,02,08 = colonne 07
chiave 08-08-08-08-08-08 > sistema 48,06,02,09 = colonne 08
chiave 09-09-09-09-09-09 > sistema 54,06,02,10 = colonne 09
chiave 10-10-10-10-10-10 > sistema 60,06,02,11 = colonne 10
chiave 11-11-11-11-11-11 > sistema 66,06,02,12 = colonne 11
chiave 12-12-12-12-12-12 > sistema 72,06,02,13 = colonne 12
chiave 13-13-13-13-13-13 > sistema 78,06,02,14 = colonne 13
chiave 14-14-14-14-14-14 > sistema 84,06,02,15 = colonne 14
chiave 15-15-15-15-15-15 > sistema 90,06,02,16 = colonne 15
*****************************************************
Chiave 01-01-02-01-01-02 > sistema 08,06,03,03= colonne 04
Chiave 01-02-03-01-02-03 > sistema 12,06,03,04= colonne 06
Chiave 01-02-04-01-02-04 > sistema 14,06,03,05= colonne 07
chiave 01-03-04-01-03-04 > sistema 16,06,03,05= colonne 08
chiave 01-04-05-01-04-05 > sistema 20,06,03,06= colonne 10
chiave 01-05-06-01-05-06 > sistema 24,06,03,07= colonne 12
chiave 01-04-08-01-04-08 > sistema 26,06,03,08= colonne 13
chiave 01-06-07-01-06-07 > sistema 28,06,03,08= colonne 14
chiave 01-07-08-01-07-08 > sistema 32,06,03,09= colonne 16
chiave 01-08-09-01-08-09 > sistema 36,06,03,10= colonne 18
chiave 01-09-10-01-09-10 > sistema 40,06,03,11= colonne 20
chiave 01-10-11-01-10-11 > sistema 44,06,03,12= colonne 22
chiave 01-11-12-01-11-12 > sistema 48,06,03,13= colonne 24
chiave 01-12-13-01-12-13 > sistema 52,06,03,14= colonne 26
chiave 01-13-14-01-13-14 > sistema 56,06,03,15= colonne 28
chiave 01-14-15-01-14-15 > sistema 60,06,03,16= colonne 30
chiave 01-15-16-01-15-16 > sistema 64,06,03,17= colonne 32
chiave 01-16-17-01-16-17 > sistema 68,06,03,18= colonne 34
chiave 01-17-18-01-17-18 > sistema 72,06,03,19= colonne 36
Chiave 01-18-19-01-18-19 > sistema 76,06,03,20= colonne 38
*****************************************************
Chiave 01-01-03-03-02-04 > sistema 14,06,04,06= colonne 14
Chiave 01-02-04-01-02-04 > sistema 14,06,05,09= colonne 07

------------------------------ Formazione 08
chiave 02-02-02-02-02-02-02-02 > sistema 16,08,02,03 = colonne 02
chiave 03-03-03-03-03-03-03-03 > sistema 24,08,02,04 = colonne 03
chiave 04-04-04-04-04-04-04-04 > sistema 32,08,02,05 = colonne 04
chiave 05-05-05-05-05-05-05-05 > sistema 40,08,02,06 = colonne 05
chiave 06-06-06-06-06-06-06-06 > sistema 48,08,02,07 = colonne 06
chiave 07-07-07-07-07-07-07-07 > sistema 56,08,02,08 = colonne 07
chiave 08-08-08-08-08-08-08-08 > sistema 64,08,02,09 = colonne 08
chiave 09-09-09-09-09-09-09-09 > sistema 72,08,02,10 = colonne 09
chiave 10-10-10-10-10-10-10-10 > sistema 80,08,02,11 = colonne 10
chiave 11-11-11-11-11-11-11-11 > sistema 88,08,02,12 = colonne 11
**********************************************************
chiave 01-01-02-02-01-01-02-02 > sistema 12,08,03,03 = colonne 06
chiave 01-02-03-03-01-02-03-03 > sistema 18,08,03,04 = colonne 09
chiave 01-03-04-04-01-03-04-04 > sistema 24,08,03,05 = colonne 12
chiave 01-04-05-05-01-04-05-05 > sistema 30,08,03,06 = colonne 15
chiave 01-05-06-06-01-05-06-06 > sistema 36,08,03,07 = colonne 18
chiave 01-06-07-07-01-06-07-07 > sistema 42,08,03,08 = colonne 21
chiave 01-07-08-08-01-07-08-08 > sistema 48,08,03,09 = colonne 24
chiave 01-08-09-09-01-08-09-09 > sistema 54,08,03,10 = colonne 27
chiave 01-09-10-10-01-09-10-10 > sistema 60,08,03,11 = colonne 30
chiave 01-10-11-11-01-10-11-11 > sistema 66,08,03,12 = colonne 33
chiave 01-11-12-12-01-11-12-12 > sistema 72,08,03,13 = colonne 36
chiave 01-12-13-13-01-12-13-13 > sistema 78,08,03,14 = colonne 39
chiave 01-13-14-14-01-13-14-14 > sistema 84,08,03,15 = colonne 42
chiave 01-14-15-15-01-14-15-15 > sistema 90,08,03,16 = colonne 45
**********************************************************
chiave 01-01-02-03-01-01-02-03 > sistema 14,08,04,05= colonne 07
chiave 01-02-03-04-01-02-03-04 > sistema 20,08,04,07= colonne 10

------------------------------ Formazione 09
chiave 02-02-02-02-02-02-02-02-02 > sistema 32,09,02,03 = colonne 02
chiave 03-03-03-03-03-03-03-03-03 > sistema 48,09,02,04 = colonne 03
chiave 04-04-04-04-04-04-04-04-04 > sistema 64,09,02,05 = colonne 04
chiave 05-05-05-05-05-05-05-05-05 > sistema 80,09,02,06 = colonne 05
*************************************************************
Chiave 01-01-02-01-01-02-01-01-02 > sistema 12,09,03,03= colonne 04
Chiave 01-02-03-01-02-03-01-02-03 > sistema 18,09,03,04= colonne 06
chiave 01-02-04-01-02-04-01-02-04 > sistema 21,09,03,05= colonne 07
chiave 01-03-04-01-03-04-01-03-04 > sistema 24,09,03,05= colonne 08
chiave 01-03-04-01-03-04-01-03-04 > sistema 24,09,05,11= colonne 08
chiave 01-04-05-01-04-05-01-04-05 > sistema 30,09,03,06= colonne 10
chiave 01-05-06-01-05-06-01-05-06 > sistema 36,09,03,07= colonne 12
chiave 01-04-08-01-04-08-01-04-08 > sistema 39,09,03,08= colonne 13
chiave 01-06-07-01-06-07-01-06-07 > sistema 42,09,03,08= colonne 14
chiave 01-07-08-01-07-08-01-07-08 > sistema 48,09,03,09= colonne 16
chiave 01-08-09-01-08-09-01-08-09 > sistema 54,09,03,10= colonne 18
chiave 01-09-10-01-09-10-01-09-10 > sistema 60,09,03,11= colonne 20
chiave 01-10-11-01-10-11-01-10-11 > sistema 66,09,03,12= colonne 22
chiave 01-11-12-01-11-12-01-11-12 > sistema 72,09,03,13= colonne 24
chiave 01-12-13-01-12-13-01-12-13 > sistema 78,09,03,14= colonne 26
chiave 01-13-14-01-13-14-01-13-14 > sistema 84,09,03,15= colonne 28
chiave 01-14-15-01-14-15-01-14-15 > sistema 90,09,03,16= colonne 30
*************************************************************
chiave 01-01-01-02-01-03-01-02-03 > sistema 15,09,05,06= colonne 15
Chiave 01-02-04-01-02-04-01-02-04 > sistema 21,09,05,09= colonne 07
*************************************************************
------------------------------ Formazione 10
chiave 01-01-02-02-02-01-01-02-02-02 > sistema 16,10,03,03 = colonne 08
chiave 01-02-03-03-03-01-02-03-03-03 > sistema 24,10,03,04 = colonne 12
chiave 01-03-04-04-04-01-03-04-04-04 > sistema 32,10,03,05 = colonne 16
chiave 01-04-05-05-05-01-04-05-05-05 > sistema 40,10,03,06 = colonne 20
chiave 01-05-06-06-06-01-05-06-06-06 > sistema 48,10,03,07 = colonne 24
chiave 01-06-07-07-07-01-06-07-07-07 > sistema 56,10,03,08 = colonne 28
chiave 01-07-08-08-08-01-07-08-08-08 > sistema 64,10,03,09 = colonne 32
chiave 01-08-09-09-09-01-08-09-09-09 > sistema 72,10,03,10 = colonne 36
chiave 01-09-10-10-10-01-09-10-10-10 > sistema 80,10,03,11 = colonne 40
chiave 01-10-11-11-11-01-10-11-11-11 > sistema 88,10,03,12 = colonne 44
****************************************************************
chiave 01-03-01-02-04-01-03-01-02-04 > sistema 22,10,04,06 = colonne 11
chiave 01-02-01-04-05-01-02-01-04-05 > sistema 26,10,04,07 = colonne 13
****************************************************************
chiave 01-01-01-01-01-01-03-01-02-04 > sistema 16,10,07,09 = colonne 16

------------------------------ Formazione 12
Chiave 01-01-02-01-01-02-01-01-02-01-01-02 > sistema 16,12,03,03= colonne 04
Chiave 01-02-03-01-02-03-01-02-03-01-02-03 > sistema 24,12,03,04= colonne 06
chiave 01-03-04-01-03-04-01-03-04-01-03-04 > sistema 32,12,03,05= colonne 08
chiave 01-04-05-01-04-05-01-04-05-01-04-05 > sistema 40,12,03,06= colonne 10
chiave 01-05-06-01-05-06-01-05-06-01-05-06 > sistema 48,12,03,07= colonne 12
chiave 01-06-07-01-06-07-01-06-07-01-06-07 > sistema 56,12,03,08= colonne 14
chiave 01-07-08-01-07-08-01-07-08-01-07-08 > sistema 64,12,03,09= colonne 16
chiave 01-08-09-01-08-09-01-08-09-01-08-09 > sistema 72,12,03,10= colonne 18
chiave 01-09-10-01-09-10-01-09-10-01-09-10 > sistema 80,12,03,11= colonne 20
chiave 01-10-11-01-10-11-01-10-11-01-10-11 > Sistema 88,12,03,12= colonne 22
*********************************************************************
Chiave 01-02-04-01-02-04-01-02-04-01-02-04 > sistema 28,12,05,09= colonne 07

 

  • Like 2
Link to comment
Share on other sites

Rotacionar é fazer todas dz se concidir dentro de uma amostragem. Exemplo; Rotação em sistema de linha

 

1  2  3    

4  5  6

 o 1  2  3 não mexe so rotaciona as linhas que vier abaixo:

 

1  2  3

6  4  5 

 

1  2  3 

5  6  4

Rotaciona quantas linhas desejar, ( esta é uma rotação por 1, pode rotacionar por 2 ou 3, ou seja em vez de ir mudando 1 dz muda de 2 ou 3 dz de uma vez.

Para fazer  no sistema coluna é a mesma cois so que invertido.

 

Kracatoa

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...