How To Find The Formula of This Permutations?

  • Context: Graduate 
  • Thread starter Thread starter fera
  • Start date Start date
  • Tags Tags
    Formula Permutations
Click For Summary
SUMMARY

This discussion centers on the challenge of converting a large table of numbers (350 rows x 284 columns) into a structured format using Excel, specifically within the context of the Enigma-2.xls file. Users are attempting to remap the original table into a new format but are encountering difficulties in achieving the desired output. A Java program was shared as a potential solution, but it has not produced the expected results. The conversation highlights the need for effective methods to identify patterns in the data and automate the remapping process.

PREREQUISITES
  • Understanding of Excel functions and data manipulation
  • Familiarity with Java programming, specifically data structures like Vector
  • Knowledge of permutations and combinatorial mathematics
  • Experience with file hosting services for sharing data
NEXT STEPS
  • Investigate advanced Excel techniques for data transformation and mapping
  • Learn about Java Collections Framework, focusing on Vector and its applications
  • Explore algorithms for detecting patterns in large datasets
  • Research best practices for file sharing and collaboration on data projects
USEFUL FOR

Data analysts, software developers, and mathematicians interested in data transformation, pattern recognition, and automation of data processing tasks.

fera
Messages
2
Reaction score
0
Hi to all of you guys here…
A friend of mine gave me:
1). A paper with a table of 350 rows x 284 columns, which each cell contains of a single number from 0 to 9. This table didn’t typed yet into .xls file. It will be like table on sheet 5 of file Enigma-2.xls if it has. Since here I can’t attach .xls file more than 100.0 KB, I put it at Mediafire.com (a file hosting service) name Enigma-2.xls:
http://www.mediafire.com/?sharekey=bab4488f6ad122b3312dbd5f2bdc5062e04e75f6e8ebb871

2). A file name Enigma.xls like on sheet 1,2,3,4 of file Enigma-2.xls. He has remapped the table of 350 rows x 284 columns on that paper with:

Column -> number of table (column 1->Table 1, column 2->Table 2, column 3->Table 3,...,column 284->Table 284).
Cell Entries Index, 0 thru 9 in Column -> 10 Rows per new table (Rows 0,1,2,...9).
Row -> Ascending list of cell entries where the row index exists in the original table whose column corresponds to this translated tables index.

But he remapped the original table for 40 rows only. We were so lazy to type the original table manually to .xls file, so I want to convert it as I did on sheet 5 file Enigma-2.xls, but it didn’t work..?
Can somebody help me about this?

Now I’ve remapped it manually again per rows of that original table as on sheet 6 of file Enigma-2.xls with:

Rows -> number of table (row 1->Table 1, row 2->Table 2, row 3->Table 3,...,row 40->Table 40).
Cell Entries Index, 0 thru 9 in Row -> 10 Rows per new table (Rows 0,1,2,...9).
Row -> Ascending list of cell entries where the column index exists in the original table whose row corresponds to this translated tables index

Tables 1,5,9,13,17 / 41,45,49,53,57 / 21,25,29,33,37 / 61,65,69,73,77 on sheet 1 file Enigma-2. xls made us believe this infinite tables aren't random generated and have some patterns of permutations for extending it for the next larger numbers 41,42,43,and so on, as I gave the blank tables on sheet 6 to be filled in…
Can somebody help me about this too?
Hope my English is good enough for explaining this.
Thx.
 
Mathematics news on Phys.org
Someone has made a program in Java like this:

import java.util.*;
public class Table {
static Scanner console = new Scanner(System.in);
public static void main (String[] args)
{

String list = "010509131741454953572125293337616569737702030406070810111214" +
"151618192022232426272830313234353638394042434446474850515254" +
"5556585960626364666768707172747576787980818283848586878889909192";
String number;
int counter = 0;
int randomNumber = 0;
int rowPlacement = 0;


Vector row_0 = new Vector();
Vector row_1 = new Vector();
Vector row_2 = new Vector();
Vector row_3 = new Vector();
Vector row_4 = new Vector();
Vector row_5 = new Vector();
Vector row_6 = new Vector();
Vector row_7 = new Vector();
Vector row_8 = new Vector();
Vector row_9 = new Vector();

for (counter=0; counter<184; counter = counter + 2)
{
number = list.substring(counter, counter + 2);

//-------------------------------------------------------------------
if (counter == 10 || counter == 20 || counter == 30 || counter >= 40)
{
rowPlacement = 0;
}
//-------------------------------------------------------------------
do
{
randomNumber = (int) ( 10 * Math.random() );
}
while (rowPlacement > randomNumber);
//-------------------------------------------------------------------

if (randomNumber == 0)
{
row_0.addElement(number);
rowPlacement = 0;
}

else if (randomNumber == 1)
{
row_1.addElement(number);
rowPlacement = 1;
}

else if (randomNumber == 2)
{
row_2.addElement(number);
rowPlacement = 2;
}

else if (randomNumber == 3)
{
row_3.addElement(number);
rowPlacement = 3;
}

else if (randomNumber == 4)
{
row_4.addElement(number);
rowPlacement = 4;
}

else if (randomNumber == 5)
{
row_5.addElement(number);
rowPlacement = 5;
}

else if (randomNumber == 6)
{
row_6.addElement(number);
rowPlacement = 6;
}

else if (randomNumber == 7)
{
row_7.addElement(number);
rowPlacement = 7;
}

else if (randomNumber == 8)
{
row_8.addElement(number);
rowPlacement = 8;
}

else if (randomNumber == 9)
{
row_9.addElement(number);
rowPlacement = 9;
}

}
System.out.println(row_0);
System.out.println(row_1);
System.out.println(row_2);
System.out.println(row_3);
System.out.println(row_4);
System.out.println(row_5);
System.out.println(row_6);
System.out.println(row_7);
System.out.println(row_8);
System.out.println(row_9);
}
}

But it didn't work correctly yet in order to result tables like I put at Mediafire.com (a file hosting service) name Enigma.xls:
http://www.mediafire.com/?sharekey=12a93ace84ea3ab56b21be4093fab7ace04e75f6e8ebb871
:)
 

Similar threads

Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 4 ·
Replies
4
Views
5K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 23 ·
Replies
23
Views
6K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 2 ·
Replies
2
Views
4K