Skip to main content
MM_107359978-Gravel
8-Gravel
July 12, 2023
Solved

interpolation of table

@TudorMarin @Werner_E how can I make interpolated value of X2 for a specific value of C in Mathcad from given excel or from a mathcad table?

 

 

 

 

PerezAnswer
14-Alexandrite
July 12, 2023

The propose solution below should work for you. It keeps the original data as is without adding extra rows. For any value less than or equal to 0.45, the value of X2 should be 0.75 and for any value equal or more than 0.7, the value of X2 should be 1:

EP_10515634_0-1689174433848.png

 

EP_10515634_1-1689174445769.png

EP_10515634_2-1689174457544.png

EP_10515634_3-1689174474857.png

EP_10515634_4-1689174484529.png

EP_10515634_5-1689174499728.png

EP_10515634_6-1689174510392.png

EP_10515634_7-1689174525337.png

EP_10515634_1-1689176660038.png

 

View in thread

5 replies

Fred_Kohlhepp23-Emerald I
23-Emerald I
July 12, 2023

The function is Linterp!

Fred_Kohlhepp_0-1689162360396.png

 

Translate
    MM_107359978-GravelAuthor
    8-Gravel
    July 12, 2023

    thank you for suggesting that function, but what if i have to get only value of 0.75, for value any less than 0.45 of CB and similarly to get value of 1.0 for X2 for any value of CB more than 0.7

    Translate
    LucMeekes23-Emerald IV
    23-Emerald IV
    July 12, 2023

    Linterp will extrapolate from the last two points. That's what Fred shows. If you add 0.75 for 0.4 (or 0) of CB, and 1 for 0.75 (or 1) of CB you should get your straight horizontal lines.

     

    Success!

    Luc

    Translate
    Terms & ConditionsAccessibility statement