Sorting a result Matrix

Forum|Forum|1 year ago
July 15, 2024
3 replies
2529 views

I am sorting a result matrix with respect to 5th column.
If A is more than Asreq, i want to get only positive values of 5th column in a sorted way as an output.
If A is less than Asreq, the output matrix should contain only negative values in 5th column and they should be sorted in reverse order.
Is this possible in Mathcad?

1_BewOpt-Permutation-20240228.zip

Civil_Engineering

Best answer by LucMeekes

The function UpSort(e,5) should do what you want.

See attached worksheet. You may have to force recalculation.

Success!
Luc

W

Werner_E

25-Diamond I

First of all you always should tstae which version of Prime you are using, especially if you don't use the latest (P10 at this time). I guess you are using Prime 9.

Then its unclear to me what exactly you are trying to get.

Your program calculates a 66x6 matrix "Res".

Then you eliminate the first (all zeros) row of it.

And then you compare A.sreq with A (and you are missing the case when they are equal), But A is just the last value of the fifth column (column with index 4) in the 65th row, which happens to be 7.917 cm^2.

Because A.sreq is larger, the whole matrix is reverse sorted by the last columns values and then you return a subset of this matrix, consisting of no more than 31 rows !?

Thats what you have programmed and thats what you get.

Is it really intended to compare A.sreq just with the last calculated A value?

And what is your intended output if its not the 31x6 matrix you now get?

I am not sure what you mean by "If A is less than Asreq, the output matrix should contain only negative values in 5th column and they should be sorted in reverse order. ".

Does it mean that you expect the result you have now but without the first eight rows?

And how many rows? Still limited to 31?

Would this modification come near to what you are looking for:

Prime 9 sheet attached

1_WE_20240715_BewOpt-Permutation-20240228-2.zip

N

NM_10165576

Author

13-Aquamarine

The program compare A with Aserf in each iteration and stores in Res.
I just want to sort Res matrix based on 5th column.
5th column contains gqo values. if gqo is more than or equal to zero , the positive values of 5th column should be sorted in ascending order.
if gqo is less than zero , 5th column of matrix contains negative values, which should be sorted in descending order.
for example,

And positive values of column 5 should always come first.

M

MartinHanak

24-Ruby III

Hi,

my suggestion:

split the matrix into two
- 1st matrix ... positive values in 5th column
- 2nd matrix ... negative values in 5th column
sort 1st matrix
sort 2nd matrix
join 1st + 2nd matrix