Overview
PILOTLOG is an AddIn for Microsoft Excel. It enables the use of a flight log for pilots according to EASA standards seamlessly integrated into Excel with additional helpful functions including:
- Ability to store aircraft and to auto-complete aircraft-related entries
- Auto-Completion of ICAO airport codes
- Automatic flight-time and night-time calculation
- Default offsetting of on-block and off-block times
- One-click entry of additional times
- Automatic flight-time consistency checking
- Generation of various statistical reports
- Generation of an EASA-compliant print / PDF version
Basics
When you open Excel and open or create a workbook, you should see the “PILOTLOG” ribbon in the menu bar. Click on it to use the functions of PILOTLOG.
Ribbon Controls
- If you are using PILOTLOG for the first time, press "Init Pilot Log" to initialize the four sheets of PILOTLOG (Flightlog, Simlog, Aircraft, Pilots).
- Buttons to Add/Edit/Delete flights, sim-flights, aircraft or pilots.
- Press "Unprotect" to manually edit the sheets. The cells that you are now able to edit are colored white. Some cells stay protected to ensure the logs integrity (e.g.prevent duplicate entries). To re-protect the sheets after you have manually edited them, just press Protect.
- To switch the sort order of the log you may press "Switch Order".
- If you want to export or print your PILOTLOG according to EASA standards press "FCL-Compliant Log". To create various statistical reports, press "Reports" to chose from different reports.
- To use certain PILOTLOG features, you must be logged in and have a valid subscription. To log In, create an account or to buy a license press this button.
- If you need help just press this button to come here again.
Add/Edit/Delete
To add, edit or delete a flight, sim-session, aircraft or pilot select the respective sheet and press the corresponding button.
Add
In the Add dialogs, the required data must simply be entered into the corresponding fields. Some parameters are always calculated automatically, while others can be automatically populated by pressing a "Set" button. Some options are also mutually exclusive due to previous entries, preventing incorrect entries. It is also not possible to make the same entry twice. In the "Add Flight dialog," the aircraft and pilots stored in the "Aircraft" and "Pilots" sheets can be selected using dropdown menus.
Edit
In the edit dialogs, the respective entry can be selected by selecting certain key parameters, which are also suggested in dropdowns after selecting the first one. A second dialog then opens, similar in structure to the add dialog. The fields are prefilled with the existing parameters and can be modified as desired. Here, as with the add dialog, it is not possible to change the parameters of a flight so that it resembles an existing one.
Delete
Both visually and functionally, the delete dialogs are similar to the corresponding edit dialogs. The process for selecting the desired entry follows the same principle. Using the delete button is the only way to completely delete entries from the PILOTLOG.
Reports
By clicking the report button, you can select a report. Once created, the report can be saved as a PDF or Excel file, if desired.