Calculate interior values between key values,

[SFares]

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

[MikeArmstrong]

Two questions:

1. What are you trying to calculate?

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

[SFares]

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!

[MikeArmstrong]

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?

[SFares]

the value for c=a/.8 or a=0.8c

[MikeArmstrong]

I tried interpolating between the values to determine c and have done so, as the relationship seems to be linear, well for the first set of data anyway. However, when C is calculated the values are not an exact match as the data for C is not linear.

[MikeArmstrong]

I suppose it's how accurate you want the data.

take it you could just manually type out the data?

[SFares]

Hello Mike, i have a follow up question about the same sheet regarding the table. the question is inside my sheet

[SFares]

i forgot to attch the sheet.

[MikeArmstrong]

I cannot see where C.na is defined?

[MikeArmstrong]

Have a look at the attached. I believe that is what you are after.

[MikeArmstrong · Accepted solution]

I see you have used the linear interpolation method