Share via

Please help me to get interpolated values in each cell for 110 mm (or for any value) of sounding in the first table as per the data available in the below chart in excel

Anonymous
2022-02-03T07:24:50+00:00
No.1A FUEL OIL TANK (PORT/STBD, FR.63 - FR.74)
Soundings in mm, Other Distances in Meters
Present Present Specific Weight LCG TCG VCG GML FSM ****
Sounding Volume Gravity MT **** **** **** **** **** ****
110
Sounding Volume Specific Weight Center Of Gravity GML FSM ****
mm m³ Gravity MT LCG TCG VCG **** **** ****
20 1.465 0.855 1.25 14.372 f 0.714 p 0.125 25.46 4.04
40 1.564 0.855 1.34 14.371 f 0.732 p 0.130 24.36 4.30
60 1.664 0.855 1.42 14.370 f 0.748 p 0.135 23.35 4.56
80 1.766 0.855 1.51 14.369 f 0.764 p 0.140 22.43 4.82
100 1.871 0.855 1.60 14.368 f 0.780 p 0.146 21.58 5.10
120 1.977 0.855 1.69 14.367 f 0.796 p 0.151 20.81 5.38
140 2.085 0.855 1.78 14.366 f 0.811 p 0.156 20.07 5.66
160 2.194 0.855 1.88 14.366 f 0.825 p 0.161 19.35 5.91
180 2.306 0.855 1.97 14.365 f 0.839 p 0.166 18.68 6.15
200 2.418 0.855 2.07 14.365 f 0.853 p 0.171 18.06 6.40
220 2.532 0.855 2.16 14.364 f 0.866 p 0.176 17.48 6.64
240 2.648 0.855 2.26 14.364 f 0.879 p 0.181 16.93 6.87
260 2.765 0.855 2.36 14.364 f 0.892 p 0.186 16.41 7.10
280 2.883 0.855 2.46 14.363 f 0.904 p 0.191 15.93 7.34
Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2022-02-03T08:15:04+00:00

Convert the values in E:F to real numbers.

At first we must determine the matching row(s)

K5: =IFERROR(MIN(13,MATCH(A5,A9:A22)),1)

B5: =FORECAST($A5,OFFSET(B$8,$K$5,0,2),OFFSET($A$8,$K$5,0,2))

drag to the right.

Andreas.

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-04T10:18:57+00:00

    Thank you

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-02-04T10:11:50+00:00

    Good evening,

    Thank you so much for your help. The formula is exactly which I expected. Working well with my requirement.

    Thank you

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-02-04T00:46:41+00:00

    Excel 365

    The only category that is not a simple straight line is GML.

    Andreas got it right with Forecast().

    Curve-fitted GML with formula.

    https://www.mediafire.com/file/rkp1gbcd17vlt2z/02_03_22.xlsx/file

    https://www.mediafire.com/file/pav6534dobfau2l/02_03_22.pdf/file

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-02-03T08:21:32+00:00

    Hi,

    Please clarify what does interpolated values mean?

    OR

    Please explain Your question in more detail.

    Please check whether the following solution is helpful:

    Formula in cell B5 is: =VLOOKUP($A5,$A$9:$I$22,COLUMN(),TRUE)

    NOTE

    1. In the above suggested formula, please change cell reference/ranges to suit Your requirement.

    2. Please drag the formula right to more columns.

    e.g.1) In cell A5 > if You write 75 > the formula above will return values for row#11 i.e. for Sounding 60.

    e.g.2) In cell A5 > if You write 165 > the formula above will return values for row#16 i.e. for Sounding 160.

    Please respond if You require further assistance. I will try My best to be of help.

    If I was able to help You, please mark My response as answer and helpful.

    Thank You!

    Was this answer helpful?

    0 comments