cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Stripping a matrix

SOLVED
Alexandrite

Stripping a matrix

Hi All,

 

In the attached (MCP3) I am trying to define a matrix based on an existing one. 

 

I have a series of matrixes with different index values. When I split each column to a single matrix this works but when I try to do the same for an element of a wider matrix it seems to not work. Is there a way of doing this with a snazzy programme or similar?

 

Andy

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Stripping a matrix

Requires programming

View solution in original post

10 REPLIES 10

Re: Stripping a matrix

Its not clear to me what you are trying to do.

The way you have defined S is that S is a 1x1 matrix containing a 4x2 matrix. Was this done on purpose and why?

In which way should the program you demand "split" a matrix (or a nested matrix)?

What exactly would be the input, and what should be the output?

 

Re: Stripping a matrix

Are you trying to create a nested matrix?

Something like this?

Capture.PNG

Re: Stripping a matrix

Sorry, perhaps the attached makes more sense.

Re: Stripping a matrix

If MJGs guess is correct, this could be the program you are asking for:

bild.PNG

Re: Stripping a matrix

Requires programming

View solution in original post

Re: Stripping a matrix

OK, here are some ways to do what you want. It helps to write a small function which changes the signs in the first column of a matrix and call this function multiple times.

Bild1.PNG

Its less work using a range variable

Bild2.PNG

and if you need the same procedure multiple times, it seems to be the best idea to create a function which handles a nested matrix the way you need it to be done

Bild3.PNG

 

Re: Stripping a matrix

Thanks Fred. Basically I need to start programming more/ learn programming!

Re: Stripping a matrix

Is this a bug in Prime 3 which was fixed in P4?

When I open your sheet, I see superfluous units "m"

Bild4.PNG

after recalculation its correct

Bild5.PNG

Re: Stripping a matrix

I just noticed that too, how strange! When I called up S again the double units disappear?

Announcements