Stripping a matrix

[awibroe]

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

[Werner_E]

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]

Sorry, perhaps the attached makes more sense.

[Fred_Kohlhepp · Accepted solution]

Requires programming

[awibroe]

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

[Werner_E]

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

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

after recalculation its correct

[awibroe]

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

[Werner_E]

---

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.

[Werner_E]

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.

Its less work using a range variable

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

[MJG]

Are you trying to create a nested matrix?

Something like this?

[Werner_E]

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