+ Reply to Thread
Results 1 to 1 of 1

How to interpolate chart data from three parameters.

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    How to interpolate chart data from three parameters.

    This is so above my head it's not funny. I have an aircraft Takeoff Distance Table that specifies the resulting takeoff distance after computing:
    1. Takeoff weight
    2. Temperature
    3. Field elevation, ie, Altitude.
    For example:
    6,144 lbs takeoff weight
    80ºF
    1548 field elevation (Altitude on the chart)
    The resulting takeoff distance should be interpolated as 3,497 ft. from the Takeoff Distance Table if my math is correct, which is frequently not.
    My dilemma is, from this chart, interpolate Takeoff Weight, interpolate Altitude, and interpolate Outside Air Temperature, to get the interpolated actual takeoff distance.
    I've tried different variations of VLOOKUP, triangulation, all kinds of nested formulas that don't even come close to my calculated takeoff distance.
    Any help in pointing me in the right direction would be most appreciated.
    Attached Files Attached Files
    Last edited by cslaton; 08-17-2012 at 10:37 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1