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

interpolation of table

  • July 12, 2023
  • 2 replies
  • 2452 views

@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?

 

 

 

 

Best answer by Perez

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

 

2 replies

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

The function is Linterp!

Fred_Kohlhepp_0-1689162360396.png

 

    M
    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

    L
    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

    Terms & ConditionsCookie settingsAccessibility statement