Originally Posted by
AC103
Hi folks,
Looking for a comment from the spread sheet gurus. I am building an SS I can use to XC my take off and landing performance calcs on aircraft that publish a table rather than a chart. IMO tables are laborious and introduce greater risk of human error.
Ideally a spread sheet would have fixed variables like Weight, Altitudes, Head/Tail Wind Component, Slope, Surface, Surface Wet/Dry and then a table to input the run and 50ft clearance numbers for 3 weights, 3 head winds and 3 altitudes.
Has anyone done this before or seen something I could build from on their travels?
A standard part of excel spreadsheets is an addon called solver- go to help and look it up and how to activate. It can handle multi variables via a number of different methods- so that if you input a few variables, it will calculate others.
May take an hour or two to get familiar and check certain examples