Skip to main content
S
SFares14-Alexandrite
14-Alexandrite
July 2, 2014
Solved

Calculate interior values between key values,

  • July 2, 2014
  • 1 reply
  • 3151 views

Hello,

please scroll down in my sheet until you see the red arrow, where i placed my question. i will calculate the main or key values, but i also need to calcuate these values at incremental values in between as shown in screen shot of an excel sheet inside Mathcad sheet

Best answer by MikeArmstrong

I see you have used the linear interpolation method

1 reply

M
MikeArmstrong1-Visitor
1-Visitor
July 2, 2014

Two questions:

1. What are you trying to calculate?

2. Do you have the data in a live format?

S
SFares14-AlexandriteAuthor
14-Alexandrite
July 2, 2014

Hello Mike,

In my sheet , i calculated the highligted values for (a,c,C,..), just to show you how to produce these main values which must be calculated first, then you build the table around it. if you look at value in mathcad with same highlight color as excel both values are equal. So i need to calculate the values for the other values in between. the values in between are at the increments i described in my sheet.

i dont have the data in live format in excel. Thanks!

M
MikeArmstrong1-Visitor
1-Visitor
July 2, 2014

The problem I see is that all your formulas are dependant on c, which is a non-consistent formula. Were have the formulas for c come from?

Terms & ConditionsAccessibility statement