1. Anyone know how to use excel to generate all "8 element" arrangements of 3 symbols (has duplicates). Example: use aaaabbcc as a seed and get all possible arrangements.
2. Rank those arrangements. rank(aaaabbcc) = 1,
... rank(aaaaccbb) = 5 ...
3. unrank(234) = aacbacba (I don't know what it really is or how to do it?)
Last edited by rohed; 03-12-2007 at 01:10 AM.
Hi,
I am not sure to understand your question ...
If you are looking for permutations ...
http://j-walk.com/ss/excel/tips/tip46.htm
Hello Rohed,
This type of problem involves both permutations and combinations of numbers. Several years ago I developed an algorithm that used some of the same problems you are facing. This website help me" Math Forum - Ask Dr. Math". The explainations are simple and examples of the steps involved are given. Here is a link that explains your problem in detail.
http://mathforum.org/library/drmath/view/63330.html
SIncerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks