Even if you’re an IFR pilot there are times you just feel like flying a trip as VFR. There are many ways to digitally plan such a flight — AOPA has a very nice online flight planner for members — but my preference is to do it the old school way: waypoints, courses and distances plotted out on a sectional. I feel that this method gets me more in touch with the details of the route than any of the online planners, and I’ve come to enjoy the map work.
But if you’re comfortably beyond your student-pilot days, the last thing you should be doing is using your E6B to figure wind correction angles and groundspeeds; it’s far too time consuming. If you really know you know how to do this, then there’s no point in wasting that time; let a computer do it. (And if you don’t feel that confidence, get some practice.)
Excel, well, excels at this kind of number crunching. My Excel-based VFR planner worksheet looks and acts a lot like the paper planners you’ve worked with, and prints beautifully on a regular sheet of paper. But unlike a paper planner, Excel takes care of all the math for you. You just supply the waypoint and distance information.
This planner is particularly elegant because once you fold it, it hides the nonessential information and presents you with only what you need at a glance to fly the route: altitude, compass heading, distance, timing information. Plus there’s a handy place to record departure and destination airport info, ATIS at both ends, and various important times. I’ve been using this planner for quite a while, putting improvements into it over many iterations. It’s become a truly handy little tool.
Instructions:
-
- Determine and plot your waypoints, courses and distances on a sectional like you normally would.
- Fill in the yellow-background cells of the spreadsheet. For this you’ll need your waypoint data, wind data from aviationweather.gov., and POH data such as “Cruise Performance” and “Time, Fuel and Distance to Climb”.
- White cells such as WCA (Wind Correction Angle) auto-populate for you. Note the MC column: it’s your Magnetic Course, useful for planning your altitude via the hemispheric rule.
- Fill in the Airport Info block for quick reference in flight. I also like to sketch the destination runway and traffic pattern in the blank area below that.
- Fold it twice so that the two big, bold vertical lines meet; I then like to tape the fold down. The Alt and CH columns meet and the interstitial columns are neatly tucked away. It’s now ready to be hole-punched for your binder or clipped to your kneeboard.
- Fill in the ATE (Actual Time Enroute) and other information en route.
Remember, garbage in, garbage out. The tool is only as useful and accurate as the data fed into it, not to mention the inevitable real-world variations that you’ll encounter. So keep in mind, predicted winds change, fuel consumption isn’t exact, and so on. Like any planning tool, its value only goes so far when compared with the real world.
I hope that you enjoy this tool. If you think of any ways I can improve it, please let me know.
Pingback: The best (and only) Excel-based VFR flight planner you’ll ever need (via I Have A Black Belt In Geek.) « Calgary Recreational and Ultralight Flying Club
Hi:
Great spreadsheet, the best I have found. I located one error in the fuel calculation. The formulas in column “R” are incorrect (total fuel). Let me know if you want the specifics.
Thanks again,
Jourdi
Jourdi, thank you for reporting the bug. You’re right, there was a math error in the fuel-remaining total — I corrected the sheet and uploaded it.
Chris P.
Hi:
Your sheet is really nice. I added some columns to automatically calculate pressure altitude, density altitude, and true air speed. If you want I can send it to you.
Brian
Hi
would love to have the added columns version of Brian.
Thanks
Marty
Could I get a copy of your spreadsheet with the presure altitude, density altitude and true air speed added? Many thanks. John
Hey Brian is there anyway i could get your download from you? Please
Brian
I would like to get a copy with pressure altitude, density ect. also
thanks
would love to have it too 😉
Cheers
Hi Brian, would you be able to share your added columns? Would be awesome and make life much more easier:)
Hi Brian – If you would please email me a copy of the planner with the columns that calc pressure & density altitude and true air speed, it would be appreciated.
Dave
Brian… Could you please send me the version with corrections for pressure and density altitude?
Hey Brian,
If you’re still sending out those versions with the extra columns I’d like one as well!
Thanks
Hi Brian, is it possible that you could mail me a copy of your EXCEL VFR Flightplanner? Please please.. I’m sick and tired of the simple but time consuming turn the disc calculator from Jeppesen, for my Nav flights I usually have 7-10 legs and maybe 2-3 different w/v. So it takes a bit of time.. My mail is. Klatremanden@hotmail.com
Happy landings. Regards. MIR / OY-IKA (Mustang 2)
Hi Brian if you could send me your version please
Just saw these requests for the first time. I posted the file to dropbox at
Hi Chris – this is a great sheet, thank for sharing it. Is there an easy way to have the time be in mm:ss format?
Hmm, I guess you could do this in Excel’s ‘format cells’ capability. But in actuality, are you planning your legs down to the second? I think that’s overkill.
I know this comment is almost 8 years old but if you’d like, I’ve formatted it so it reads in mm:ss. I’ve also eliminated enough of the rounding to be accurate enough to give you time on target. It ensured that the rest of the log retained its functionality.
Love the spreadsheet. There is an error in cell N18 which throws off the dist. rem.
Thanks for the heads-up… I’ve corrected the N18 glitch.
i think some of the WCA & TAS formulae are missing on the downloadable form. also – how about an extra column for Minimum Safe Altitude for each leg/sector? thanks, John Matthews, England
Pingback: Plantilla OPF (Operational Flight Plan)
Looks extremely wll thought-out. I’ll try it this weekend and let you know…
Greetings from Munich, Germany 🙂
Used this sheet for the first time. It is a real time saver! One question; today I flew from an island 20 miles offshore. I performed a circling ascent to gain the altitude I needed before heading offshore (in case I lose the engine). As a student I had difficulty figuring out how to enter that in the distance column. It took me 12 min to climb to 5000 but only put 3 miles between me and the airport. Is there a way to calculate that in this sheet? Thanks
Circling climb is a special case so I would just override the white values in the spreadsheet.
If you really want to keep the formulas in tact, you could plug in 3 miles for the leg and a ground speed of 15knots, which would give you 12 minutes for the leg, but you’d still have to work out ahead of time that it was going to take 12 minutes using your POH climb performance calcs.
2016 Jan 04 – I think some of the formuale are missing
It’s a great spreadsheet. However, I see a few comments that allude to some enhancements. Could someone please email me the “latest and greatest”?
Other folks have made customized it with their own alterations. My latest-and-greatest is still the one linked from the article.
Hoping this is still active. Have attempted to download via multiple browsers and host connectivity errors. Thank you.
Apologies, there was server maintenance at 4am last night, right about when you tried. Please try now.
Was able to get. Thank you.
Is there still a copy of this with the altitude calculations included? I’d love to get a copy of it if possible
Hi, quick question, why does the first Est. Gs and Fuel leg column not include the formula? Thanks! Great sheet btw!
Hello, can anyone still share the pressure altitude, density altitude and true air speed added columns please
Wow, excellent VFR Nav Log! Thank you for creating this! I’m wondering if there’s a way to incorporate a Climb Fuel Burn numbers as well into this document as well?
Just wanted to say this has saved me from so many 300 am wind spinning sessions.
For my program you must complete 4 paper navlogs to go on your cross countries and I’ve been doing for years by hand. So when I was this it brought tears to my eyes! Thanks for the extra sleep!
Pingback: Excel Flight Planner |
Thanks to the Formulas utilized within the sheet, I was able to Autofill the values for almost everything into my Primary Flight Schools Nav Log. This was a MAJOR time saver that in which I’ve never said Thank-YOU for. I was able to integrate a Winds&Temp Aloft sheet into the sheet to the point in which once a flight plan is set, I only have to update the Winds and Temps aloft right before the flight. The only update is on the Winds and Temp Sheet with the data from AviationWeather.gov. Sheet extrapolates the data for altitudes in-between, and NavLog sheet grabs the right cells data. Oh, and if you have to change the W&T data source (i.e RKS to SLC….), that’s a simple change to the cells being selected.
I’ve watched MANY students preparing for their Stage and Checkrides take HOURS to calculate this out, because they don’t understand how EASY it really can be! I even have multiple pages that link cells together for longer(more detailed) flight planning.
SuperCool. You have raised pilot productivity by several hundred percent globally 🙂
Doubt it, but thanks. 🙂
Thanks for putting this together and sharing but I’m stumped…
What happened to Column P? I can’t Unhide the column to see what’s going on.Unlocking isn’t the answer either.
I was attempting to display Column R as blank when the leg is blank but it uses Column Q to calculate.
Ha. Zero width was the issue. Never mind.
Great spreadsheet! I used this all the way through my PPL training. Instructor was impressed. A few mods that I did:
1) I didn’t offset the waypoints in Column A, B & C to the rest of the spreadsheet. Personal preference that I just like to know what waypoint I’m going to and how long it will take. I just leave the departure point out of the Checkpoint column.
2) Instead of using VOR Freqs and radials in Column C, I enter the side of the aircraft that my waypoint will be on and the distance. So, the Highway intersection that is my Check Point #4 is L (left) @ 1.5NM, etc.
3) Under the Airport Info on the right side, I added some basic information for Climbout and Descent (Elevation Change [Cruise Altitude – Departure Field elevations {opposite for the descent}]; Distance to Climb/Descend, Time to Climb/descend, Fuel Used to Climb/Descend). Pretty handy for helping to find where you are at the top of the climb and when you need to start descending.
4) Created an identical Spreadsheet in a second tab that deletes all calculations related to wind. I print one of these out in case my winds shift on me and I need to recalculate everything by hand at the airport. But, it keeps all of my distance information, etc.
5) Instead printing it on an 8.5″x11″ paper and folding it in half, I do the following:
a) Cut two pieces of 8.5″x11″ paper in half to make four pieces of 8.5″ x 5.5″ pieces of paper.
b) Print Columns A-L on one piece of small paper using the A5 paper setting on your printer.
c) Print Columns M-R on the back side of that first piece of paper flipped on the short edge so it’s upside down related to the Column A-L sheet.
d) Print Columns S-V on another small sheet of paper.
e) Viola! Kneeboard cards! I prefer to use card stock for mine, for what it’s worth.
It helps to copy Columns A, B & C and paste them just to the left of Column M so that all you really need to use for your in-flight navigation is the second page that you just printed. Keep that on top of your kneeboard and just flip that page up to see the back side of it, along with your ATIS, Airport and Climb info underneath.
One last thing: The person, Barry, asking for the mm:ss format for times is/was most likely in military training. In Navy NFO training, we used to have to plan these runs down to every 6 seconds. Time-on-top matters for dropping bombs. Also, it gives you a much more accurate fix on your current ground speed and future estimations without adding any real work. But, the formulas in this sheet do quite a bit of rounding so it really doesn’t work to format the cells.
Hi Tom!., could you send me a copy of your revised template? Thanks! – Steve
Hi Tom, I am just in my PPL training and would greatly appreciate if you could send me your version.
My email is pk@dolinsek-s.si
Thank you very much in advance!
Pavel
Hi Tom, this was really useful!
Can you please share your revised file by sending to michaelmikel@yahoo.com? I have
problem downloading the file…
Thanks a million!
Michael
I hope this excel sheet is still active. I have attempted to download, but could not. Thank you.
Hi. I just confirmed that the “Click here to download the planner” link works fine. Is it failing for you?
Thank you for prompt reply. I tried again, but I failed.
I’m sorry about that! I’ve relocated the file to Dropbox and updated the link above. Please try again?
This time, I got it. Thank you for your kindness.
Dear Chris,
Your spreadsheet is excellent.
It seems that O5, Q5, R5 and R6 cells do not reflect changes in other cells.
I would appreciate it if you would fix the cells to reflect changes in other cells.
Hi
Has anyone managed to get the sheet with the extra columns that Brian put together?
Thank you!!
In Brian’s last reply under his original comment his name is a link to the downloadable Dropbox version of the file with his additions.
Hello!
I’m writing an E6B program in C# for practice and I was really struggling to get some of the math for crosswind correction and ground speed right until I found your spreadsheet. This has been extremely helpful!
Perhaps I’ll even use the spreadsheet as an iPad backup 🙂
Thanks for your great work!
This is the best flight planner I have ever seen. Do you allow others to download a blank template of your planner. The reason that I ask is that when I choose to download it comes with all your sample data still input. I have never used excel, so I do not know if it is removable or even how to go about doing that.
Also an idea that I would love to see included is a mini time and distance chart for quick diversion calculations.
Thank you so very much
Very nice thanks. Looks like Freq and Radial tags are swapped vs the sample data
Hi, Amazing planner! Thank you for the work!
Do you happen to have an IFR version as well?
Pingback: cbpowell.wordpress.com excel login - loginband.com