如何找到这种排列的公式？ [英] How To Find The Formula of This Permutations?

问题描述

大家好朋友嗨

我的一个朋友给了我：

1）。一张包含350行x 284列表格的纸张，每个单元格包含0到9之间的单个数字。此表格尚未输入.xls文件。它就像文件Enigma-2.xls的第5页上的表格一样。从这里我不能附加.xls文件，我把它放在Mediafire.com（文件托管服务）名称Enigma-2.xls：
http://www.mediafire.com/?sharekey=b...4e75f6e8ebb871


2）。文件名为Enigma.xls，如文件Enigma-2.xls的表1,2,3,4所示。他在那张纸上重新制作了350行×284列的表格：


列 - >表的数量（列1->表1，列2->表2，列3->表3，......，列284->表284）。

Cell条目索引，列中的0到9 - >每张新表10行（0,1,2行，9行）。

行 - >原始表中存在行索引的单元格条目的升序列表，其列对应于此转换表索引。


但是他将原始表重新映射为40行。我们懒得手动输入原始表格到.xls文件，所以我想像我在5页文件Enigma-2.xls上那样进行转换，但它没有用。？

有人可以帮我解决这个问题吗？


现在我再次手动重新映射到原始表的每一行，如文件Enigma-2.xls的第6页所示：


行 - >表格的数量（第1行和第1行，表1，第2行>表2，第3行>表3，......，第40行 - >表40）。

Cell行中的条目索引，0到9 - >每张新表10行（0,1,2行，9行）。

行 - >原始表中存在列索引的单元格条目的升序列表，其中行对应于此转换表索引


表1,5,9,13,17 / 41,45,49 ，表格1文件Enigma-2上的53,57 / 21,25,29,33,37 / 61,65,69,73,77。 xls让我们相信这些无限的表格不是随机生成的，并且有一些排列模式可以将它扩展到下一个更大的数字41,42,43，依此类推，因为我在第6页上填写了空白表格？

有人可以帮我这个吗？

希望我的英语足以解释这个。

Thx。

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, I put it at Mediafire.com (a file hosting service) name Enigma-2.xls:
http://www.mediafire.com/?sharekey=b...4e75f6e8ebb871

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.

推荐答案

我昨晚读了你的问题，今天早上我读了它（在我喝了浓缩咖啡后），但我从你的问题和你的Excel表中了解到了zilch。请尝试不同的解释和你的问题的表述。


如果我没有弄错，在Sun Java论坛中提出同样的问题;没人设法弄明白你的意思;对吧？


亲切的问候，


Jos

I''ve read your question last night and I''ve read it this morning (after I took my espresso coffee) but I understand zilch from your question and your Excel sheets. Please try a different explanation and formulation of your question.

If I''m not mistaken this same question was asked in the Sun Java forums; nobody managed to figure out what you meant; right?

kind regards,

Jos

亲爱的 Jos ，

现在假设我给你一个包含350行x 284列的表，每个单元格包含0到9之间的单个数字。通过找到它的模式，我需要你的帮助才能将该表扩展到填充细胞行351,352,353等。

然后你会做什么？

如果你需要看那张桌子，我的朋友也把它放在其他论坛上，但它只有350行×20列。我们懒得为其他列输入它。它应该像第5页文件中的Enigma-2.xls一样。

通过查看该表，我们很难看到模式。这就是为什么我的朋友重新映射那个表格 - COLUMNS ，就像他在文件Enigma-2.xls的表1,2,3,4中所做的那样：
列 - >表的数量（列1->表1，列2->表2，列3->表3，......，列284->表284）。

单元格条目索引，列中的0到9 - >每张新表10行（0,1,2行，9行）。

行 - >原始表中存在行索引的单元格条目的升序列表，其列对应于此转换表索引。


通过这样做，他在表格的命名下面的文件Enigma-2.xls的第0页上写下了他的意见。


然后我再次重新映射该表 - ROWS ，就像我在文件Enigma-2.xls的第6页上所做的那样：
行 - >表格的数量（第1行和第1行，表1，第2行>表2，第3行>表3，......，第40行 - >表40）。

Cell Entries Index，0到9 in Row - >每张新表10行（0,1,2行，9行）。

行 - >原始表中存在列索引的单元格条目的升序列表，其行对应于此转换表索引


我可以看到它的模式，因为我写的是 注意： 位于第6页的下方。

但是最大的问题是我们不知道如何将数字加扰到这样的结果。

我需要帮助扩展空白表41,42,43等，正如我在文件Enigma-2.xls的第6页上给出的那样。它将与你为行351,352,353等扩展原始表格相同。

现在你能理解整个问题吗？如果你这样做，或许你也可以帮助我用英语重新写这个帖子，所以其他人都能理解它。我会非常感谢你，因为我们的英语不是太优秀了。

Thx Jos ，关注你。

Dear Jos,
Supposed now I give you a table with 350 rows x 284 columns, which each cell contains of a single number from 0 to 9. By finding its patterns, I need your help to extend that table to fill the cells for the rows 351,352,353,etc.
Then what would you do?
If you need to see that table, my friend also had put it on other forum, but it was only 350 rows x 20 columns. We were so lazy to type it for the rest of other columns. It?s supposed to be like on sheet 5 file Enigma-2.xls if it has.
By seeing that table, it was very difficult for us to see the patterns. That?s why my friend remapped that table per-COLUMNS as he did on sheet 1,2,3,4 of file Enigma-2.xls 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.

By doing this, he found the patterns as he wrote on his opinion on sheet 0 of file Enigma-2.xls beneath NOMENCLATURE OF THE TABLES.

Then I remapped that table again per-ROWS as I did it on sheet 6 of file Enigma-2.xls with:
Row -> 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

I can see its patterns as I wrote as the Note: on below of sheet 6.
But the big problem is we don?t know how to scramble numbers to result like that.
I need help to extend the blank tables 41,42,43,etc as I gave on sheet 6 of file Enigma-2.xls. It will be the same as you extend the original table for the rows 351,352,353,etc.
Now can you understand the whole problems? If you do, perhaps you can also help me to re-write again this thread in English, so everybody else can understand it. I?ll be great thank to you, because our English isn?t too excellent for it.
Thx Jos, for your attentions.

你对你正在处理什么类型的模式有任何线索吗？

您的原始表用于计算单元格的公式是什么，或者这是您要查找的内容？

您能否使用随机数？


我的感觉是这个问题并不适合这类论坛。

Do you have any clue as to what type of pattern you are dealing with?
What formula is your original table using to calculate cells, or is this what you''re trying to find?
Can you not use random numbers?

My feeling is that this question is not really suitable for this type of forum.

这篇关于如何找到这种排列的公式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！