Skip to main content
1-Visitor
December 18, 2012
Solved

Interpolation on Non-Ascending data

  • December 18, 2012
  • 2 replies
  • 1343 views

Dear Experts,

Appreciate your expertise on highlighting me where i did wrong.

I have a set of data tabulated in the notepad which later on will be use in the mathcad sheet.

However after defining the data according to the row, i need to perform an interpolation within each value to a desire spacing. This where the msg error pop up state that the vector must be in ascending.

Hope to hear from you guys soon

Thanx in advance

Best answer by RogerYeh

I think there's a typo in profile2.txt.

Untitled.png

If you change the '100' in the highlighted row to 1000, then the first column will be in ascending order, and the worksheet works fine. If the 100 is NOT a typo, then you will need to sort your data with CSORT:

Untitled1.png

2 replies

RogerYeh1-VisitorAnswer
1-Visitor
December 18, 2012

I think there's a typo in profile2.txt.

Untitled.png

If you change the '100' in the highlighted row to 1000, then the first column will be in ascending order, and the worksheet works fine. If the 100 is NOT a typo, then you will need to sort your data with CSORT:

Untitled1.png

1-Visitor
December 18, 2012

Dear Roger,

Thank you for highlighting my mistake. Really appreciate it.

Regards