How To Find The Formula Of This Permutations?

[phillip1882]

excel in python

[thinker]

Ok, I've found it.

I put a file at Mediafire.com (a file hosting service) name Enigma-1.xls:

Free File Hosting Made Simple - MediaFire

 

This file is a conversion of file Enigma.xls, which on sheet #1 contains tables of:

Number 1, Number 5, Number 9, Number 13, Number 17,

Number 21, Number 25, Number 29, Number 33, Number 37,

Number 41, Number 45, Number 49, Number 53, Number 57,

Number 61, Number 65, Number 69, Number 73, Number 77.

 

On row 0 table Number 1, you’ll see numbers 2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,21,23,24,25,26,27,28,29,30,31,32,33,36,38.

 

On row 1 of same table you’ll see numbers

1,4,5,11,20,22,34,35,37,39,40.

 

It means on file Enigma.xls,

1 is on row 0 on Tables: 2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,21,23,24,25,26,27,28,29,30,31,32,33,36,38.

 

And 1 is on row 1 on Tables: 1,4,5,11,20,22,34,35,37,39,40.

 

It will be the same way for other tables, also for other sheets of file Enigma-1.xls.

 

Here’s my observations of file Enigma-1.xls:

 

• In each table, numbers gather around only in a couple of rows (meanwhile the black & green numbers of file Enigma.xls spread almost into all rows).
  
• Numbers look moving down from row 0 from table Number 1 to table Number 5 to table Number 9 to table Number 13 to table Number 17, and from table Number 41 to table Number 45 to table Number 49 to table Number 53 to table Number 57.
  
• Numbers look moving down toward row 9 from table Number 21 to table Number 25 to table Number 29 to table Number 33 to table Number 37, and from table Number 61 to table Number 65 to table Number 69 to table Number 73 to table Number 77.
  
• So many numbers have difference = 12 as numbers in circles. (It means on file Enigma.xls, one Table should have a correlation to its next twelve Table..?).
  

Well, I don’t know how to say about the gray areas:

All of numbers in row 0 of table Number 5 (gray areas) are also in (the same row) table Number 1.

and all of numbers in row 0 of table Number 45 (gray areas) are also in (the same row) table Number 41.

 

All of numbers in row 9 of table Number 33 (gray areas) are also in (the same row) table Number 37, and all of numbers in row 9 of table Number 73 (gray areas) are also in (the same row) table Number 77.

 

Thx.

[thinker]

I've installed Python 2.4.1 and can run your code already.

Thx.

[phillip1882]

based on your results it looks like my code needs some tweaking.

for example, my code implicitly assumes that 21 will not be on a higher row than 17, but does so in several tables. i could modify my code to better reflect to probability distribution if you wish, though it may take a few days, and i would need the tables for the remaining numbers.

[phillip1882]

i was looking at your results, and i think the grey numbers are a false lead. according to your first series relationship post, 5 has to be either on the same row or below row 1, and the same relationship applies to 41 and 45. so its no surprise that all the number 5 row 1 table is also on number 1 row 1 table. the same thing applies to 33, 37 as well. since 37 has to be either on or below the same row as 33, it should have all the same table numbers as row 9 number 33. i'm not quite sure what you mean by the difference of 12 thing. the numbers look fairly random to me.

[thinker]

i was looking at your results,...

Which results did you mean? If you meant file Enigma-1.xls, then you could have a wrong perception. As I said, file Enigma-1.xls is a conversion of file Enigma.xls.

 

On sheet 1 file Enigma-1.xls, row 0 table Number 1, you’ll see numbers 2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,21,23,24,25 ,26,27,28,29,30,31,32,33,36,38.

 

It means on file Enigma.xls,

1 is on row 0 on Tables: 2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,21,23,24,25 ,26,27,28,29,30,31,32,33,36,38.

 

Your code was good already, and if I run it for 40 times, it supposed resulting 1 on row 0 on the 2nd run, 3rd run, 6th run, 7th run and 8th,9,10,12,13,14,15,16,17,18,19,21,23,24,25 ,26,27,28,29,30,31,32,33,36,38th run.

Thx.

[thinker]

Dear phillip1882,

would you mind taking a look files

1-2.psd.jpg

2-3.psd.jpg

and its explanations at the same thread HERE?

Thx.

[phillip1882]

i guess my question is what exactly is it your looking for? sometimes patterns just aren't there. you have my code, you have the code posted in the other forum, what more do you want?

[thinker]

i guess my question is what exactly is it your looking for? sometimes patterns just aren't there. you have my code, you have the code posted in the other forum, what more do you want?

I'm so sorry phillip1882, I thought by seeing files 1-2.psd.jpg & 2-3.psd.jpg you could have any idea how numbers 81-92 work.

Thx.

[phillip1882]

no need to apologize. it just that two table relationships do not a pattern make. even if there is a pattern it should be fairly easy to modify my code or post the pattern you see so i can modify it.

[thinker]

excel in python

In order to seek the sort of patterns, first I need to read the file Enigma.xls by using python. I’ve tried the address you gave above, but I couldn’t do that because no examples there.

Oh I’m so dummy in computer… :hihi:

[thinker]

phillip1882, how to modify your code if inside each table is numbers 1 to 20 only like file New.xls that I put at :

mediafire.com or

rapidshare.com ?

Thanks.