Skip to main content
4-Participant
April 16, 2024
Solved

Linear interpolation from Table

  • April 16, 2024
  • 2 replies
  • 1588 views

Hi everyone,

I want to do a linear interpolation for k in MATHCAD from this table taken from EC2.

As you see, if the division c1/c2 is <= 0.5 the value must be 0.45 and if the division is greater than 3 k is equal to 0.8.

Tableau 6.1 EC2.png

How can i solve this. 

Nota: I'm new to MATHCAD.

Best answer by Werner_E

The easiest way IMHO without the need of any programming is to add values at both ends of the table with k-values equal to the end values and then just make use of the built-in "linterp" function to do the linear interpolation:

Werner_E_0-1713295396486.png

Prime 10 worksheet attached

 

2 replies

14-Alexandrite
April 16, 2024

Hello there,

Use the programming operator to create a function k(c_ratio) as shown below:

Perez_0-1713293826078.png

Perez_1-1713293836231.png

Perez_2-1713293878438.png

Perez_3-1713293892677.png

Perez_4-1713293909372.png

Perez_5-1713293919701.png

Perez_6-1713293934118.png

Perez_7-1713293943605.png

 

 

Perez_8-1713293958370.png

 

 

MHDINGBI4-ParticipantAuthor
4-Participant
April 17, 2024

Great Thanks.

Werner_E25-Diamond IAnswer
25-Diamond I
April 16, 2024

The easiest way IMHO without the need of any programming is to add values at both ends of the table with k-values equal to the end values and then just make use of the built-in "linterp" function to do the linear interpolation:

Werner_E_0-1713295396486.png

Prime 10 worksheet attached

 

MHDINGBI4-ParticipantAuthor
4-Participant
April 17, 2024

Thank you for your response.