AUTOMATIC VFR NAVIGATION LOG (FLIGHT SIDE) T/O PX ALT: 29920 AUTOMATIC VFR NAVIGATION LOG (PRE-FLIGHT SIDE)
X ALT: 29920 AUTOMATIC VFR NAVIGATION LOG (PRE-FLIGHT SIDE) LAND PX ALT: 29920
AIRCRAFT NUMBER: Notes: CLIMB DATA KIAS: FPM: TIME: FUEL: STT FUEL: 1.5 TOTAL: 1.5
DEPARTURE: ATIS: GND: TWR: DEP/APCH: CTAF CRUISE DATA PRESS ALT: -25420 RPM: BHP: KTAS: CRUISE ALT: 4500 GPH: 8.0
ARRIVAL: ATIS: GND: TWR: DEP/APCH: CTAF DESC DATA KIAS: FPM: TIME: #DIV/0! DISTANCE #DIV/0! ALT LOSS 3500
36 USEABLE OTHER INFO T/O ELEV. T/O ALTIM. LAND ELEV. LAND ALTIM.
VORs DIST. GND SPD TAKE OFF TIME GPH GPM WIND TRUE GND SPD
VFR CHECKPOINTS LEG TIME TOTAL TIME MAG
RADIAL COURSE LEG EST. 12:30 AM 8 0.133 1 HEADING 1 LEG TIME IN HEADWIND NAUTICAL
(VOR FIXES) EXPECT DIR VEL HEADING
FREQ. HEADING ALTITUDE REM. ACTUAL EST. EST. EST. ARRIVE FUEL FUEL KCAS COURSE WCA - EAST CH AIRSPEED DECIMAL X/W COMP TAILWIND MILES A
MINUTES COMP
0 ACTUAL ACTUAL ACTUAL REMAIN REMAIN TEMP + WEST +/- DEV MINUTE
0 0 00:00 0:00:00 12:30 AM 1.5 1.5 0° 0°
0° 2250 0 0° 0° 0 0.0 0.0 0.0 0.00
0 83 08:00 0:08:00 12:38 AM 34.5 34.5 0° 0°
TOP OF CLIMB
0 Err:502 Err:502 Err:502 0.6 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 139 03:53 Err:502 12:41 AM 33.9 ### 0° 0°
0 Err:502 Err:502 Err:502 1.3 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 143 08:49 Err:502 12:50 AM 32.6 ### 0° 0°
0 Err:502 Err:502 Err:502 1.1 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 145 07:02 Err:502 12:57 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 143 06:42 Err:502 1:04 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 13:00 Err:502 1:17 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 17:00 Err:502 1:34 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 13:00 Err:502 1:47 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 24:00 Err:502 2:11 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 12:00 Err:502 2:23 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 21:00 Err:502 2:44 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 18:00 Err:502 3:02 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 17:00 Err:502 3:19 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 10:00 Err:502 3:29 AM 31.5 ### 0° 0°
0 Err:502 Err:502 Err:502 ### #DIV/0! #DIV/0!
#DIV/0! 4500 0 #DIV/0! ### 0 Err:502 0.0 0.0 0.00
0 04:40 Err:502 3:34 AM 31.5 ### 0° 0°
TOTAL: 0 TOTAL: 4.5 Err:502 © 2025 Free Pilot Training
STEP
1
2
3
6
7
8
9
10
11
12
13
14
BTW
INSTRUCTIONS
SAVE A BLANK COPY OF THIS BEFORE YOU MAKE ANY CHANGES SO YOU CAN KEEP THE FOR
FILL OUT ALL THE BLUE FIELDS AT THE TOP OF THE NAVLOG (ON THE PRE-FLIGHT SIDE) USING WEAT
USE THE AIRCRAFT POH TO FILL IN CLIMB AND CRUISE PERFORMANCE DATA AT THE TOP OF THE NAV
INSERT YOUR DESCENT DATA BASED ON YOUR PREFERENCES. 500 FEET PER MINUTE AT 120 KIAS IS
CHOOSE VFR CHECKPOINTS THAT ARE APPROXIMATELY 10-30 MILES APART AND FILL IN ON THE FLIGH
THE EXCEL DOCUMENT WILL AUTOMATICALLY FILL IN YOUR TOP OF CLIMB (TOC) DATA BASED ON YOU
BE SURE YOUR FIRST WAYPOINT IS PAST YOUR TOP OF CLIMB (TOC)
BE SURE TO PUT A TOP OF DESCENT PRIOR TO YOUR FINAL DESTINATION
FOR EACH WAYPOINT, PLOT THE DISTANCE ON EACH LEG AND INPUT ON THE FLIGHT SIDE OF THE NA
FOR THE TOP OF DISTANCE LEG, YOU CAN FIND THAT DISTANCE ON THE TOP OF THE PRE-FLIGHT SIDE
FOR EACH WAYPOINT, PLOT THE TRUE COURSE ON EACH LEG AND INPUT ON THE PRE-FLIGHT SIDE OF
FOR EACH WAYPOINT, FIND THE WINDS ALOFT DATA FROM [Link] AND FILL I
FOR EACH WAYPOINT, INPUT THE MAGNETIC VARIATION ON THE PRE-FLIGHT SIDE OF THE NAVLOG
FOR EACH WAYPOINT, INPUT THE MAGNETIC DEVIATION FROM YOUR AIRCRAFTS DEVIATION CHART O
FOR EACH WAYPOINT, THE ALTITUDE SHOULD AUTOMATICALLY BE ADDED FROM YOUR CRUISE DATA.
TRUE AIRSPEED FOR THE CLIMB AND EXPECTED KCAS ARE NOT GOING TO BE PERFECT. YOU CAN USE
BUT THE SPEEDS IN LIGHT RED ARE GOING TO BE FAIRLY ACCURATE IF YOU JUST NEED A QUICK PROD
INSERT YOUR DESIRED TAKEOFF TIME INTO THE FLIGHT SIDE OF THE NAVLOG (IF DESIRED) IF YOU DO
DELETE ALL THE DATA BELOW YOUR FINAL DESTINATION
PRINT THE NAVLOG AND FOLD TO FIT ON YOUR KNEEBOARD. YOU SHOULD NOT NEED THE
BY THE WAY…
THE BLANK SPACES ON THE FLIGHT SIDE ARE FOR YOUR IN-FLIGHT CALCULATIONS. THERE ARE FORM
PRACTICE AND RUN NUMBERS ON THE GROUND
EMAIL ME AT FREEPILOTTRAINING1@[Link] IF YOU HAVE SUGGESTIONS ON HOW TO MAKE THIS
USEFUL WEBSITE LINKS:
[Link]
[Link]
[Link]
COURSE HEADING
ALTITUDE
DISTANCE
GROUNDSPEED
TIME
TOTAL TIME
FUEL
EXPECTED KCAS
USEABLE FUEL
WINDS
WIND CORRECTION ANGLE
TRUE HEADING
VARIATION
MAG HEADING
DEVIATION
COMPASS HEADING
TRUE AIRSPEED
DECIMAL MINUTES
CROSSWIND COMPONENT
HEADWIND/TAILWIND COMPONENT
GND SPEED NAUTICAL MILES PER MIN
TAKEOFF PRESSURE ALTITUDE
LAND PRESSURE ALTITUDE
CLIMB DATA (TOP OF THE PREFLIGHT SIDE)
CRUISE DATA (TOP OF THE PREFLIGHT SIDE)
DESCENT DATA (TOP OF THE PREFLIGHT SIDE)
DESCENT DATA (TOP OF THE PREFLIGHT SIDE)
DESCENT DATA (TOP OF THE PREFLIGHT SIDE)
OTHER INFO
Your Examiner could potent
THIS FORMULA STARTS WITH THE TRUE COURSE AND ACCOUNTS FOR WINDS ALOFT, VARIATION, AND
THE ALTITUDE IS POPULATED FROM THE PRE-FLIGHT SIDE OF THE NAV LOG. THE CLIMB LEG TAKES HA
INPUT BY THE PILOT
THESE CALCULATIONS ARE MADE BY A COMPLICATED FOMULA WHICH TAKES =SQRT(KTAS^2 + X/W
TOC TIME IS POPULATED BY THE CLIMB DATA. OTHER TIMES ARE TAKEN BY THE DISTANCE BY THE GR
TOTAL TIME ADDS THE CURRENT LEG TIME FROM THE PREVIOUS TOTAL TIME
CLIMB FUEL IS DIRECTLY POPULATED BY THE CLIMB DATA. THE OTHER LEGS ARE TAKE THE CRUIZE F
THIS IS NOT AN ACCURATE FORMULA. IT IS A ROUGH ESTIMATE OF THE KCAS BASED ON THE FACT TH
INPUT BY THE PILOT BASED ON THE USEABLE FUEL NOTED IN THE POH
INPUT BY THE PILOT (USE WINDS ALOFT DATA FROM [Link]
THESE CALCULATIONS ARE MADE BY A COMPLICATED FOMULA WHICH TAKES =DEGREES(ASIN(SIN(
TRUE HEADING TAKES THE TRUE COURSE AND ADDS OR SUBTRACTS THE WIND CORRECTION ANGLE
INPUT BY THE PILOT
MAG HEADING TAKES THE TRUE HEADING AND ADDS OR SUBTRACTS THE VARIATION
INPUT BY THE PILOT
COMPASS HEADING TAKES THE MAGNETIC HEADING AND ADDS OR SUBTRACTS THE DEVIATION
TRUE AIRSPEED FOR THE CLIMB TAKES THE KIAS AND CONVERTS IT USING THE CALCULATION CENTER
THIS CELL SIMPLY TAKES THE LEG TIME AND CONVERTS IT INTO A DECIMAL FORMAT FOR MINUTES FO
THESE CALCULATIONS ARE MADE BY A COMPLICATED FOMULA WHICH TAKES =P11*SIN(RADIANS(W
THESE CALCULATIONS ARE MADE BY A COMPLICATED FOMULA WHICH TAKES =P11*COS(RADIANS(
TAKES THE COMPLEX GROUNDSPEED CALCULATION AND DIVIDES IT BY 60 TO GIVE YOU GROUNDSPE
ASSUMES THAT PRESSURE ALTITUDE DROPS 1" OF MERCURY EVERY 1,000 FEET OF ALTITUDE INCREA
ASSUMES THAT PRESSURE ALTITUDE DROPS 1" OF MERCURY EVERY 1,000 FEET OF ALTITUDE INCREA
MOSTLY INPUT BY THE PILOT USING THE AIRCRAFT POH. THE TOTAL FUEL TAKES THE CLIMB FUEL AN
MOSTLY INPUT BY THE PILOT USING THE AIRCRAFT POH. THE PRESSURE ALTITUDE AT CRUISE ASSUME
MOSTLY INPUT BY THE PILOT USING PERSONAL PREFERENCE FOR THE DESCENT. ALT LOSS CALCULAT
DESCENT TIME IS CALCULATED BY DIVIDING YOUR ALTITUDE TO LOSE BY THE DESIRED DESCENT RAT
DESCENT DISTANCE IS CALCULATED BY DIVIDING THE DESCENT TIME BY YOUR INDICATED AIRSPEED
INPUT BY THE PILOT
AUTOMATIC VFR NAVIGATION LOG (FLIGHT SIDE) T/O PX ALT: 1008 AUTOMATIC VFR NAVIGATION LOG (PRE-FLIGHT SIDE) LAND PX ALT: 1321
AIRCRAFT NUMBER: N3148X Notes: open flight plan with Columbia Radio 122.6 CLIMB DATA KIAS: 73 FPM: 550 TIME: 07:00 FUEL: 1.5 STT FUEL: 1.4 TOTAL: 2.9
DEPARTURE: ATIS: 120.85 GND: 121.6 TWR: 119.8 DEP/APCH: 128.6 CTAF 119.8 CRUISE DATA PRESS ALT: 5470 RPM: 2,500 BHP: 65% KTAS: 114 CRUISE ALT: 5500 GPH: 9.0
ARRIVAL: ATIS: 118.975 GND: TWR: DEP/APCH: 121.1 CTAF 122.8 DESC DATA KIAS: 120 FPM: 1000 TIME: 3.2 DISTANCE 6.4 ALT LOSS 3179
53 USEABLE OTHER INFO T/O ELEV. 978 T/O ALTIM. 29.89 LAND ELEV. 1321 LAND ALTIM. 29.92
VORs DIST. GND SPD TAKE OFF TIME GPH GPM WIND TRUE GND SPD
VFR CHECKPOINTS LEG TIME TOTAL TIME MAG
RADIAL COURSE LEG EST. 9:30 AM 9 0.150 1 HEADING 1 LEG TIME IN HEADWIND NAUTICAL
(VOR FIXES) EXPECT DIR VEL HEADING
FREQ. HEADING ALTITUDE REM. ACTUAL EST. EST. EST. ARRIVE FUEL FUEL KCAS COURSE WCA - EAST CH AIRSPEED DECIMAL X/W COMP TAILWIND MILES A
MINUTES COMP
93 125 ACTUAL ACTUAL ACTUAL REMAIN REMAIN TEMP + WEST +/- DEV MINUTE
JOPLIN (KJLN)
11 93 07:00 0:07:00 9:37 AM 2.9 2.9 190° 29 90° 89°
91° 2750 73 71° 19° 91° 77 7.0 25.4 -14.1 1.56
82 83 08:00 0:08:00 9:38 AM 50.1 50.1 24 -1° 2°
TOP OF CLIMB
9 146 03:41 0:10:41 9:40 AM 0.6 0.6 220° 41 82° 81°
83° 5500 101 71° 11° 83° 114 3.7 21.1 -35.1 2.44
73 139 03:53 0:14:34 9:41 AM 49.5 49.5 14 -1° 2°
FIRST WINDMILL
21 146 08:36 0:19:17 9:49 AM 1.3 1.3 220° 41 82° 81°
83° 5500 101 71° 11° 83° 114 8.6 21.1 -35.1 2.44
52 143 08:49 0:28:06 9:50 AM 48.2 48.3 14 -1° 2°
HIGHWAY 160
17 146 06:57 0:26:15 9:56 AM 1.1 1.0 220° 41 82° 81°
83° 5500 101 71° 11° 83° 114 7.0 21.1 -35.1 2.44
DIVIDED HIGHWAY 353 35 145 07:02 0:33:17 9:57 AM 47.1 47.2 14 -1° 2°
/SPEEDWAY 116.9 16 146 06:33 0:32:48 10:02 AM 1.0 220° 41 82° 81°
83° 5500 101 71° 11° 83° 114 6.6 21.1 -35.1 2.44
19 143 06:42 0:39:30 10:04 AM 47.1 46.2 14 -1° 2°
BUFFALO AIRPORT (LEFT)
13 146 05:19 0:38:07 10:08 AM 0.8 220° 41 82° 81°
83° 5500 101 71° 11° 83° 114 5.3 21.1 -35.1 2.44
6 13:00 0:51:07 10:17 AM 47.1 45.4 14 -1° 2°
TOP OF DESCENT
6 130 02:46 0:40:54 10:10 AM 0.4 190° 29 84° 83°
85° 5500 101 71° 13° 85° 114 2.8 25.4 -14.1 2.16
0 17:00 0:57:54 10:34 AM 47.1 45.0 27 -1° 2°
LEBANON (KLBO)
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 13:00 0:53:54 10:47 AM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 24:00 1:04:54 11:11 AM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 12:00 0:52:54 11:23 AM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 21:00 1:01:54 11:44 AM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 18:00 0:58:54 12:02 PM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 17:00 0:57:54 12:19 PM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 10:00 0:50:54 12:29 PM 47.1 45.0 0°
114 00:00 0:40:54 10:10 AM 0.0 0° 0°
0° 5500 101 0° 0° 114 0.0 0.0 0.0 1.90
0 04:40 0:45:34 12:34 PM 47.1 45.0 0°
TOTAL: 93 TOTAL: 5.9 8.0 © 2025 Free Pilot Training