<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 10"><meta name="Originator" content="Microsoft Word 10"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cgatsu-8%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><link rel="Edit-Time-Data" href="file:///C:%5CDOCUME%7E1%5Cgatsu-8%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_editdata.mso"><!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> Hi again to all of you guys here…
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-1.xls if it has. Since here I can’t attach the file, I put it at Mediafire.com (a file hosting service) name Enigma-1.xls:
http://www.mediafire.com/?hrldz3xmmgm
2).A file Enigma.xls like on sheet 1,2,3,4 of file Enigma-1.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-1.xls, and to re-map again per rows of the original table as on sheet 6 with:<o
></o>
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<o></o>
But it didn’t work..?
Can somebody help me about this?<!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" alt="" style='width:12pt; height:15.75pt'> <v:imagedata src="file:///C:\DOCUME~1\gatsu-8\LOCALS~1\Temp\msohtml1\01\clip_image001.gif" o:href="http://www.excelforum.com/images/smilies/confused.gif"/> </v:shape><![endif]--><!--[if !vml]--><!--[endif]-->
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-1. 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…
<!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75" alt="" style='width:12pt;height:12pt'> <v:imagedata src="file:///C:\DOCUME~1\gatsu-8\LOCALS~1\Temp\msohtml1\01\clip_image002.gif" o:href="http://www.excelforum.com/images/smilies/smile.gif"/> </v:shape><![endif]--><!--[if !vml]--><!--[endif]-->
Hope my English is good enough for explaining this.
Thx.
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-1.xls if it has. Since here I can’t attach the file, I put it at Mediafire.com (a file hosting service) name Enigma-1.xls:
http://www.mediafire.com/?hrldz3xmmgm
2).A file Enigma.xls like on sheet 1,2,3,4 of file Enigma-1.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-1.xls, and to re-map again per rows of the original table as on sheet 6 with:<o
></o>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<o
></o>But it didn’t work..?
Can somebody help me about this?<!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" alt="" style='width:12pt; height:15.75pt'> <v:imagedata src="file:///C:\DOCUME~1\gatsu-8\LOCALS~1\Temp\msohtml1\01\clip_image001.gif" o:href="http://www.excelforum.com/images/smilies/confused.gif"/> </v:shape><![endif]--><!--[if !vml]--><!--[endif]-->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-1. 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…
<!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75" alt="" style='width:12pt;height:12pt'> <v:imagedata src="file:///C:\DOCUME~1\gatsu-8\LOCALS~1\Temp\msohtml1\01\clip_image002.gif" o:href="http://www.excelforum.com/images/smilies/smile.gif"/> </v:shape><![endif]--><!--[if !vml]--><!--[endif]-->Hope my English is good enough for explaining this.
Thx.
