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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

4-Participant

## Problems with interpolating data in Mathcad

Hi everyone,

I have a problem with interpolating data in Mathcad. Please see the attached file. In Excel, I have defined materials and temperatures. I want to replicate this in Mathcad so that when I select the material and temperature, the corresponding stress value is automatically displayed. Additionally, for temperatures ranging from 100 to 250, if I select a temperature like 120, the stress value should be determined through interpolation based on the material and temperature.

I have also attached my Mathcad file. I approached this in two ways: The first method works for standard temperatures like 100 and 150 but shows an error if I select a temperature like 120 that is not explicitly defined. The second method involves interpolation but only for one material. If I have multiple materials, I have to repeat the process for each one.

If anyone has encountered and solved this issue before, please let me know.

note - these materials and temperatures are not standard and are used only for demonstration purposes.

1 ACCEPTED SOLUTION

Accepted Solutions
24-Ruby V
(To:AK_10948685)

Simply use

The row selector choses row #a in the data matrix corresponding to the material selected via the drop down and the transpose operator turns the row vector into a column vector which is needed for "linterp" to work.

You may also bypass the definition of the variable "m" and use that expression directly in the "linterp" function:

5 REPLIES 5
24-Ruby V
(To:AK_10948685)

Simply use

The row selector choses row #a in the data matrix corresponding to the material selected via the drop down and the transpose operator turns the row vector into a column vector which is needed for "linterp" to work.

You may also bypass the definition of the variable "m" and use that expression directly in the "linterp" function:

4-Participant
(To:Werner_E)

Hi Werner,

Thanks for this solution. I made some changes, according to me. Please see the attached Mathcad file.

20-Turquoise
(To:AK_10948685)

4-Participant
(To:ttokoro)

Hi ttokoro,

This is a good idea. We can plot a graph. I will use this.

20-Turquoise
(To:AK_10948685)

f/ MPa for 2220 MPa line.

Announcements
Top Tags