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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Stripping a matrix

awibroe
14-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

Requires programming

View solution in original post

10 REPLIES 10

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?

 

awibroe
14-Alexandrite
(To:Werner_E)

Sorry, perhaps the attached makes more sense.

Requires programming

awibroe
14-Alexandrite
(To:Fred_Kohlhepp)

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

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

awibroe
14-Alexandrite
(To:Werner_E)

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


wrote:

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


At least that was the case when I recalcuated the worksheet in Prime 4.

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

 

MJG
18-Opal
18-Opal
(To:awibroe)

Are you trying to create a nested matrix?

Something like this?

Capture.PNG

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

bild.PNG

Top Tags