Skip to main content
11-Garnet
May 8, 2016
Solved

Multiple cases analysis

  • May 8, 2016
  • 1 reply
  • 2954 views

HI.

Good day.

Any one can  help me simply the program I had made for a member analysis. I want to see the attached data in one Array, Matrix or Table.  Some data used as a readexel  from  the exel file I attached,

This case also

And also this case

Best answer by LucMeekes

Would this help?

I built this in Mathcad (no Prime) that's why the last statement throws an error, because Mathcad doesn't allow mixed units in a vector or matrix.

You should be able to build this in Prime and have it work. That is, the Result matrix should have a fisrt column with the CASE values, a second column with the Delta values, etc.

Note that I use the match() function to find the row index of each delta value in the delta matrix in the correct column, then take the first found result (that's the index ORIGIN) to get the row index for the profile and Zx vectors.

Success!
Luc

1 reply

LucMeekes23-Emerald IVAnswer
23-Emerald IV
May 8, 2016

Would this help?

I built this in Mathcad (no Prime) that's why the last statement throws an error, because Mathcad doesn't allow mixed units in a vector or matrix.

You should be able to build this in Prime and have it work. That is, the Result matrix should have a fisrt column with the CASE values, a second column with the Delta values, etc.

Note that I use the match() function to find the row index of each delta value in the delta matrix in the correct column, then take the first found result (that's the index ORIGIN) to get the row index for the profile and Zx vectors.

Success!
Luc

23-Emerald IV
May 8, 2016

You could build the Result matrix in one pass:

Here too Mathcad throws an error because of mixed units. In Prime this should work.

Luc