Take-off / landing distance calculator in Excel
Thread Starter
Join Date: Aug 2007
Location: London
Age: 48
Posts: 42
Likes: 0
Received 0 Likes
on
0 Posts
Take-off / landing distance calculator in Excel
Evening all,
So Skydemon and other apps do a cracking job of W&B calculations but I have yet to find a way of digitising those take-off / landing distance charts.
And I lack the Excel skills to make one for myself - it looks quite complex.
Has anyone attempted this? And if so is it a template that could be adapted for different aircraft (I fly a Diamond DA40 TDI)? Or is there some amazing app I have yet to discover?
Thanks!
So Skydemon and other apps do a cracking job of W&B calculations but I have yet to find a way of digitising those take-off / landing distance charts.
And I lack the Excel skills to make one for myself - it looks quite complex.
Has anyone attempted this? And if so is it a template that could be adapted for different aircraft (I fly a Diamond DA40 TDI)? Or is there some amazing app I have yet to discover?
Thanks!
The maths surely is spectacularly simple, and all you're doing in Excel is putting the formulae in that you did in your PPL ground exams.
Not that there's any substitute for using the table/chart out of the POH and your simplest solution might be just to photograph that and store the image on your ithingy?
G
Not that there's any substitute for using the table/chart out of the POH and your simplest solution might be just to photograph that and store the image on your ithingy?
G
Join Date: Nov 2000
Location: Cambridge, England, EU
Posts: 3,443
Likes: 0
Received 1 Like
on
1 Post
For PPL stuff I find that the following works for me:
(1) Work out the distances for MAUW, zero wind, applying all the usual fudge factors. One for tarmac, one for grass.
(2) Use those for each flight.
(In other words, I've done the calculations once, ever.)
If a runway comes out looking too short I simply don't use it. I've never felt tempted to re-do the sums in order to try to shave a few percent off because there's a headwind, or I'm not fully loading the aircraft, or it's a cold day, or I know they've just cut the grass (honest guv). I personally would regard any such temptation as a danger sign!
(1) Work out the distances for MAUW, zero wind, applying all the usual fudge factors. One for tarmac, one for grass.
(2) Use those for each flight.
(In other words, I've done the calculations once, ever.)
If a runway comes out looking too short I simply don't use it. I've never felt tempted to re-do the sums in order to try to shave a few percent off because there's a headwind, or I'm not fully loading the aircraft, or it's a cold day, or I know they've just cut the grass (honest guv). I personally would regard any such temptation as a danger sign!
Join Date: Jul 2009
Location: London
Posts: 519
Likes: 0
Received 0 Likes
on
0 Posts
If you're trying to get into a short runway where this actually matters I think you'd be better off checking at your intended weight and balance on a long runway where you can work out the length of a particular section (to simulate the short strip) and then see if you can stay within that length. I wouldn't rely on the book figures.
Otherwise Gertrude's method is pretty much the norm.
Otherwise Gertrude's method is pretty much the norm.