Digital Flight Planner – Version 2!

I’ve made some improvements to my flight planning spreadsheet, and I’m please to announce that version two has now been released!

Not only does it include the solution to the Triangle of Velocities to allow automatic calculation of heading and groundspeed based on the given wind forecast, but it now also calculates your track and distance using the Rhumb line between your waypoints.

Flight planning has never been so easy!

Flight Planner – Version 3!

Compiling a flight log is a prerequisite to making a cross-country flight. It is used to record the calculations and measurements made in the briefing room, and provides a plan to follow on your knee-board during the actual flight.

The flight log allows you to calculate the heading correction required to achieve a certain track given the forecast wind velocity, and also to estimate your ground speed and thus the time and fuel required for the flight. These calculations are usually done by hand using an E-6B or similar flight computer. This is fine until you realise you’ve made a mistake and need to go back and correct everything. Or maybe you want to set up your flight log the night before, and want to just plug in the wind forecast on the day without having to waste valuable time using the whiz-wheel.

It is much more efficient to use a PC for these simple, but repetitive, calculations. This MS Excel spreadsheet does just that.

Flight Plan

Flight Plan

The spreadsheet contains a lookup table of waypoints that can be easily updated with the latitude and longitude of your own airports and private landing sites. Then simply select the waypoint codes of your departure point and destination on the flight plan, and your required track and distance are calculated automatically. Given the forecast wind velocity, the spreadsheet then calculates the heading you require, your ground speed, and your estimated time enroute.

If you would like more information on the wind calculations done by the flight log, have a look here at the solution to the triangle of velocities. The track and distance are calculated based on the Rhumb line (or loxodrome) between your two coordinates.

The flight log also contains some useful mnemonics for various procedures, and also the available manifold pressure requirements for limited-power operations in the Robinson R22 helicopter. These can all be easily changed to your own needs.

The spreadsheet requires Microsoft Excel 2003 or later.

Please feel free to leave any comments or suggestions on how the Flight Planner could be improved.

  Flight Planner v3.01 (9.7 KiB, 2,036 hits)

Legal Stuff

All files and tools on this page are provided “as is” with no express or implied warranty for accuracy or accessibility. Use at your own risk. All calculations should be checked against the relevant pilot’s operating hand book before being relied upon for flight planning purposes.