If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > How To Analyze These Tables?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-10-09, 02:00
dini dini is offline
Registered User
 
Join Date: Mar 2009
Posts: 1
How To Analyze These Tables?

Hi to all of you guys…
I'm new here, but here is my story, a friend of my husband gave him:

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, I put it at Mediafire.com (a file hosting service) name Enigma-2.xls:
Free File Hosting Made Simple - MediaFire

2).A file name Enigma.xls just 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 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

Firstly we thought this was random generated, but 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 could have some patterns that could be found to extend the table for the next larger numbers 41,42,43,44, and so on…
Hope my English is good enough for explaining this.
Thx.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On