Here you can download a macro-less spreadsheet for assistance with VFR Flight Planning and navigation logging.
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.
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.
Please leave a comment below if you find this useful or have any feedback!
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!
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"
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.
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.
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
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.