Pilot Navigation Log & Flight Planner

A comprehensive flight planning and performance suite designed for student pilots, flight simulation enthusiasts (MSFS/VATSIM), and general aviation pilots. This tool digitizes the traditional paper navigation log, providing automated calculations for cross-country planning, weight and balance, and regulatory compliance.

🚀 Key Modules

• Weight & Balance: Automated CG envelope verification. Input your specific aircraft's empty weight and arms from your weight and balance records to ensure every flight is within gross weight and CG limits.
• Navigation Log: A complete VFR/IFR planning sheet. Calculates Magnetic Heading (MH), Compass Heading (CH), and Ground Speed (GS) based on wind correction angles and magnetic variation.
• Fuel Management: Built-in calculators for Trip, Taxi, and Alternate fuel. Includes automatic validation against FAA Reserve Requirements (14 CFR 91.151 / 91.167) for Day/Night VFR and IFR operations.
• Performance & Atmosphere: Pressure and Density Altitude calculators to determine actual aircraft performance based on current METAR/ATIS data (OAT and Altimeter settings).
• Preflight Checklist: Integrated IMSAFE (Personal Minimums) and ARROW (Required Documents) checklists to ensure both the pilot and aircraft are airworthy and legal for the flight.
• Pilot Logbook: A digital log to track flight hours (SEL/MEL, XC, Night, Instrument). Includes a JavaScript/OnlyOffice Macro to automatically archive "Current Flight" data into a permanent history log.

💻 Macro & Automation Setup

The LogFlight macro automates the process of moving your "Current Flight" data (Row 4) into your permanent "Flight History" (Row 6+).

A dedicated button is already created on the Pilot Log sheet for easy assignment.

🔵 OnlyOffice (Optimized)

1. Open the Macro Code sheet in the workbook and copy the JavaScript code.
2. Go to View > Macros > New Macro.
3. Paste the code and click Run.
4. To Assign: Right-click the "Log Flight" button shown above and select the macro you just created.

🟢 Google Sheets

1. Import the .xlsx file into Google Drive.
2. Go to Extensions > Apps Script.
3. Paste the Google Sheets compatible code found in the Macro Code sheet.
4. To Assign: Right-click the button image, click the three dots (top right of the image), select Assign script, and type the name of the function (e.g., logFlight).

🔴 Microsoft Excel

• Note: You will need a version of Excel that supports premium automation features (Office Scripts for Web or VBA for Desktop).
• Right-click the button to assign your specific VBA macro or Office Script.

📋 Flight Planning Workflow

1. Prep: Complete the IMSAFE and ARROW checks in the Preflight Checklist tab.
2. Weather: Input current conditions into the Weather & Flight Plan sheet to calculate your Density Altitude.
3. Loading: Verify your payload in the Weight & Balance tab.
4. Planning: Map your waypoints in the Navigation Log. Use the Fuel Required tab to ensure you have sufficient "Fuel on Board" for your ETE plus required reserves.
5. Log: After shutdown, use the Pilot Log to record your time and maneuvers.

⚖️ Disclaimer

This tool is for educational and supplemental planning purposes. It is the responsibility of the Pilot in Command (PIC) to ensure the accuracy of all data and to refer to the approved Airplane Flight Manual (AFM) or Pilot Operating Handbook (POH) for all flight operations.