BigMax Posted January 18, 2019 Share Posted January 18, 2019 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 3 Quote Link to comment Share on other sites More sharing options...
BigMax Posted January 18, 2019 Author Share Posted January 18, 2019 ------------------------------ 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 2 Quote Link to comment Share on other sites More sharing options...
abedospassos Posted January 18, 2019 Share Posted January 18, 2019 Olá pessoal; Alguém pode indicar software ou planilha excel que cruza coluna x linhas, por exemplo, Col. A,B,C sendo que as condições é: Col. A= 8-5-5-5=56 Quote Link to comment Share on other sites More sharing options...
kracatoa Posted January 18, 2019 Share Posted January 18, 2019 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.