VFR Flight-Plan / Navigation log spreadsheet

Picture of VFR flightplan spreadsheet

What is here

Here you can download a macro-less spreadsheet for assistance with VFR Flight Planning and navigation logging.

Features

  • Simple, clear, single page format.
  • Automatic calculation of wind-corrected heading, ground speed and leg time.
  • Optional entry of destinations by longitude and latitude for automatic calculation of track and distance between two points.
  • Fuel consumption helper
  • Radio frequency table with Morse code shown for NAV aids.

Track and distance calculation

For the automatic track and distance calculation feature to work, you must enter each waypoint into the waypoint table. This can be found on the "Places" sheet. The initial heading and distance is calculated based on a rhumb line connecting the two points.

Disclaimer

This spreadsheet, accompanying programs and documentation are not guaranteed fit for any particular purpose. Their use for flight planning should always be backed up with other tools and techniques. Reliance on this spreadsheet alone is prohibited. I can't guarantee that it's free from errors or omissions. In other words, you use it at your own risk. Finally, a sound knowledge of VFR flight planning techniques is required to use this spreadsheet, remember Garbage In, Garbage Out.

Downloads

Please leave a comment below if you find this useful or have any feedback!


Leave a comment

Your email address will not be published.
CAPTCHACAPTCHA

Previous comments

  • Andrew posted 2016-12-18 21:44:01.974 (183)

    This is awesome....you just saved me DAYS of work with these calculations. Absolutely brilliant. I may tweak for personal use etc, but wow, you deserve to be commended sir- I am very impressed with your work!

  • PJR posted 2014-05-08 16:19:44.857479 (101)

    As a minor suggestion why not have box B2 as the name of the flight plan and say box B34 as "VFR FLIGHT PLAN - Version n.m"

  • PJR posted 2014-05-08 13:54:16.240717 (100)

    Brilliant, I thought this had to have been done by some one by now. It came up with the same answers as the one I did by hand - impressive! It would useful to have this on a tablet computer these days.

  • Peter posted 2013-07-18 09:04:00.0 (92)

    Great spreadsheet ! I love the 'places' concept. Minor problem is that it only works for Longitude (ºW). At the ºE side of the world is kind of annoying ;-) But by prefixing the values with a 'minus' sign, it seems to be OK. Anyway, thank you very much for sharing this with the rest of the world.

  • Paul Banks posted 2011-11-19 12:13:57.484908 (67)

    Hi Neil, I have updated the documentation and added 'pop up' comments to the headings on the spreadsheet which decode the acronyms! Good luck with your NPPL, I hope you're having as much fun as I did! Paul

  • Neil posted 2011-11-17 21:51:17.131454 (66)

    Hi, Great spreadsheet!! I have been using it as I work towards my NPPL. I'd be very grateful if you could tell me what the acronym 'Hdc' followed by the letter 'C' in a circle means? I have worked out the other acronym as follows: ETA: Estimated Time of Arrival RTA: Required Time of Arrival ATA: Actual Time of Arrival Many Thanks, Neil.