Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm building a spreadsheet to use for my own flight planning purposes. One
thing I have to calculate is landing distance which is based on two variables, temperature and altitude. Below is a table that comes from the plane manual: first column is airport elevation in thousands of feet, the other three columns are landing distances in feet for 10, 20, and 30 degrees Celsius. Alt. 10 C 20 C 30 C 000 695 755 810 1000 765 825 890 2000 840 910 980 3000 925 1000 1080 4000 1020 1100 1190 5000 1125 1215 1315 6000 1245 1345 1455 7000 1375 1490 1615 8000 1525 1655 1795 Basic Question: How in Excel, would I enter an expression that takes the altitude and current temperature input by me and look up the corresponding landing distance? In looking through the posts, it looks like an Index, Match, Match scenario, but I can't get it to work correctly. Advanced Question: How could I get Excel to interpolate data based on variables that aren't strictly listed in the table. For example, the airport elevation is 1134 feet with a temperature of 13 degrees? Any help with this would be greatly appreciated. Alan |