Interchanging Row.

[lvl107]

Hi,

I really need help with following attachment file.

Regard,

Loi Le.

[MikeArmstrong]

Loi Le wrote:

Hi,

I really need help with following attachment file.

Regard,

Loi Le.

It's not clear from your worksheet exactly what your trying to do.

What does "Given Input Picture" mean?

Mike

[AlanStevens]

Does this help?

Alan

[MikeArmstrong]

Alan Stevens wrote:

Does this help?

Alan

Alan,

Have a look at the attached programmed method.

Mike

[AlanStevens]

Alan,

Have a look at the attached programmed method.

Mike

Mike,

Strictly speaking you haven't interchanged the rows, just moved the positions of the numbers 1, 2, 3 and 4. This might be perfectly acceptable, of course, if all the other terms in the matrix are identical (as they are in the example provided). Certainly a programmed method would be more flexible than my "handraulic" method.

Alan

[jeanGiraud]

Alan Stevens wrote:

Alan,

Have a look at the attached programmed method.

Mike

Mike,

Strictly speaking you haven't interchanged the rows, just moved the positions of the numbers 1, 2, 3 and 4. This might be perfectly acceptable, of course, if all the other terms in the matrix are identical (as they are in the example provided). Certainly a programmed method would be more flexible than my "handraulic" method.

Alan

Alan,

Did you visit: http://communities.ptc.com/message/152308#152308

[RichardJ · Accepted solution]

It usually best to start by defining some basic helper functions. Firstly because they are reusable for other tasks, and secondaly because the main program is then usually easier to write.

[MikeArmstrong]

Richard Jackson wrote:

It usually best to start by defining some basic helper functions. Firstly because they are reusable for other tasks, and secondaly because the main program is then usually easier to write.

Nice Richard,

I that your method.

Mike

[jeanGiraud]

Loi Le wrote:

Hi,

I really need help with following attachment file.

Regard,

Loi Le.

I have replied few days ago ... interchange row/col ... I think you were the visitor, but if you change thread for the same subject, that does not help !

jmG

[lvl107]

Thanks a lot.

[jeanGiraud]

Loi Le wrote:

Thanks a lot.

The kind of interchange looks a "rotation"

[Ninetrees]

I thought that I was a bit late ringing in on this, until I saw that the thread apparently began in 2008 😉 Here are some routines that I threw together in 2006 to help with some work I was doing...I think that the advantage over the other method is that the matrix is transposed but once at the beginning of the routine and once at the end...oops 😉 I confused the "postings since date" with the "post date"...

~R~