Hello,
I may have bitten off more than i can chew here.
I'm trying to create a document that colleagues can use to interpolate takeoff masses from tables such as the picture attached based on wind and temperature
IMG_0037.jpg
So for instance a pilot would enter the 4 figures highlighted in Red (Mass) and the figures in Green (Temp & Wind)
We would then enter the current conditions and the document would interpolate the values to give an exact take off mass
There are 100's of these tables which get updated regularly so entering all the data behind the scenes wouldn't be practical.
The document would look something like this but im struggling with the formulas to interpolate
Screenshot 2024-03-19 221937.png
Any help would be much appreciated
Thanks
Bookmarks