VFR Flight Planner

For any student VFR Pilots needing to complete an old fashioned VFR Flight Plan, here's a useful Excel version of this flight planning tool.

Many years back I received my Private Pilot's License and in the process spent some time trying to find a decent cross country flight planning tool. I failed, and so created one of my own. Here's some of the highlights of the tool:

  1. Works on Excel for Windows and Excel for Mac (Excel 2013 or later required)

  2. Planning check list

  3. Weight, balance and fuel calculations.

  4. Weather Log and FAA Flight Plan Form

  5. Navigation Log

  6. Weight, balance and fuel considerations

  7. Extensive automation, including a shared aircraft and airport database.

  8. No manual input of intermediary calculations. Where ever a figure or item can be calculated or looked up, it will be. No need for your calculator or E6B!

The basic layout of the navigation log is similar to the Jeppesen form, but takes it much further. Click on the image above for an example (this was the navigation log for my FAA check ride by the way).

Of course nowadays everyone's using Foreflight, but for those of you that prefer the traditional approach, this tool is for you!

Follow the instructions on the Installation tab to install (don't try and use the download file directly). Requires Excel 2013 or later

If you find this VFR Flight Planner tool useful, please make a small donation.

Some screen shots

Check List

Navigation Log

Weather Briefing and Flight Plan

Ribbon Bar

Nick's Training Notes

This document is a collection of various bits of information that I accumulated during my private pilot ground and flight training work, which I found difficult to commit to memory and therefore felt the need for somewhere to put it all down on paper. These are my ‘Cliff Notes’ for private pilot training.

Click on an icon to open the notes in PDF or Word format

VFR Flight Planner Release History

February 2020 - Version 3.42 

A couple of bug fixes to maintain compatibility with the latest version of Excel for Mac.

March 2019 - Version 3.41 

Fixed bug in calculation of remaining fuel on Navigation Log pages (thanks Scott Stratmoen for reporting).

July 2018 - Version 3.40 
Upgraded to work with the latest version of Office on Windows and Mac. Both the Windows and Mac version now use a custom ribbon bar for navigation. This version will only work with Excel 2013 or later for Windows or Mac.

Mac users please note - Due to limitations with the recent versions of Excel for Mac, the shared Airport / Aircraft database will be stored in this location: ~/Library/Containers/com.microsoft.Excel/Data/Documents (where ~ is your home folder). If you have a database from an earlier version, just copy it to this location.


April 2016 - Version 3.13
Bug fixes

  • Weather Briefing shows correct total time enroute when using the second page of the nav log.

 

October 2015 - Version 3.12
Bug fixes

  • Calculation of total distance

  • Correct carry over of distance and fuel to second page of planner log

 

July 2015 - Version 3.1
This is a minor release, which includes:

  • Corrected Total flight time and fuel consumption formulas on Navigation Log (formula missed two of the way points).

  • Changed formatting in Airport Database so that runways (e.g. "08-27") are not reformatted into a date.

  • Added a second page to the Navigation Log for longer trips.

  • Improved the formatting of the document.

April 2013 - Version 3
I've just uploaded a new version. Key highlights include:

  • Full support for Excel 2011 for Mac including all automation and custom Flight Planner menu.

  • New VFR Flight Planner ribbon in Excel 2007 / 2010 / 2013 for Windows

  • Improved database management - aircraft and airports automatically synchronised with the shared database (so that you can share airport and aircraft data with fellow students).

  • Formatting improvements and Bug fixes

©2018 by ElseyWorld.