Flight Log XL - VFR easy planner

When the executable file, called FlightLogXL.exe, is opened, a form is shown where you'll be prompted to specify the position where the program will be saved on your computer (the default path 'C:\' is supplied).

Clicking the 'Unzip' button, a directory named FlightLog XL will be created and filled with the following files:

FlightLogXL.xls It's the Excel® worksheet containing the actual program

Wmm.cof It's the geomagnetic model file

FlXL_Help_ita.htm It's the Italian-language Help file

FlXL_Help_eng.htm It's the English-language Help file (the one you are reading)

These files represent the complete distribution of the program and must not be distributed separately. Please see the paragraphs Introduction and License agreement.

To start FlightLog XL just open the file ‘FlightLogXL.xls’ (double click). Microsoft Excel® is launched and the program executed.

Depending on your Excel settings, you could be asked whether or not activating Macros. For FlightLog XL to work it's absolutely necessary that Macros be activated.

The starting screen shows a brief disclaimer that can be viewed in Italian or English language. The language you select at this point will be retained for program execution and determines the language for the error messages that FlightLog XL can generate and for the Help the program will show.

When you close the disclaimer window by clicking the OK button the Flight Log is ready for filling in.

Quick start

Note:

user can input data on green cells and shouldn't write on all other cells.

1) Input the date of flight on the upper left side of the sheet

2) Input the ground speed you want the log to be computed for. FlightLog XL takes into account of climb and descent performance of the airplane computing some default parameters that depend on the selected speed. If you wish to modify these parameters, introducing those specific for your aircraft, click on the “Aircraft …” button.

3) Move the cursor on the first row of the log (row no. 6 of the Excel sheet) clicking on column A. Click the arrow on the Waypoint list box and choose from the dropdown list the waypoint you want to start the navigation from. The list will only show the type of Waypoints selected by the corresponding option button: simple waypoints (geographical points), airports or radio aids (VOR or NDB).

4) Click on the arrow inside VOR and NDB list boxes, selecting the radio aids useful for the navigation on that point. The program calculates on which VOR/NDB radial the waypoint lies. Input the altitude to be kept over that point.

5) Enter the altitude in feet to be kept over that point.

6) Select the next row and start again from point 3).

The program computes the magnetic bearing to be kept on the directional gyro to get to the point, the distance to the point in nautical miles and the time needed to reach the point at the chosen ground speed.

Here follow, in detail, the instructions related to the different parts and functions of FlightLog XL.

Introduction

FlightLog XL was born 'for fun' as a simple program to plan a VFR flight without having to manually gather the route and distance information from the geographical chart and manually write them down on a paper log to keep in the cockpit during flight.

The FlightLog XL printout is a paper report of the flight log substantially identical to what you should obtain filling out manually the traditional planning form.

The purpose to avoid the manual phase of the flight planning is to eliminate the possible mistakes while collecting and rewriting heading and distance data, as well as avoiding the boredom to read information on the chart.

The FlightLog XL working relies on a database of waypoints that can be either simple geographical points of known coordinates or airfields or VOR/NDB radio stations.

Of all of these points, FlightLog XL must know the geographical coordinates and possibly other suitable information like radio frequencies for airports and radio aids or the field elevation and so on.

Any added information on airports ad radio aids used in the log of a particular flight is automatically printed on the log itself, in order to supply the pilot with all (or nearly all!) the planning information he needs.

The pilot will only have to input, once for all, the data concerning any single point that he'll be able to re-use any other time.

FlightLog XL is distributed by the author under the GNU/GPL license. It is allowed to copy and redistribute the program, provided it is transferred on its entireness and not partially.

It's important to understand that the use of FlightLog XL does not relieve the pilot from the responsibility to check all the data on the log; both the ones already available inside the program, like waypoint lists, and the ones generated by the program through calculations. It is clear that a mistake entering a waypoint coordinate would affect calculations related to the track from and to that point, and the pilot should become aware of that before flying, by checking the sense of what printed.

The author doesn't supply any warranty and doesn't assume any responsibility on data retrieved using FlightLog XL.

Please refer to the License agreement section of this manual for copyright and distribution information.

The date of flight

The date when the flight is going to take place must be entered in the green cell on the upper left corner in the format DD/MM/YY.

It's an important piece of information because it allows the program to calculate the magnetic declination, which varies with time, to determine the magnetic heading starting from the geographical one.

Dates preceding the current date won't be accepted.

The Ground Speed

FlightLog XL calculates the log for a given ground speed that the pilot issues.

In this version the program disregards wind effects.

The Ground Speed the program uses for planning calculations is supposed to be constant during the level flight, while a decrease is calculated for climb and descent phases. The Ground Speed of the airplane in level flight must be entered in the specific green cell on the top of the log.

The active row

Information related to the selected waypoints or radio aids are shown on the row that is active at the moment.

To make a row active you must click on the first column of the row itself, or move the cursor on it using the arrow keys.

A red border surrounding it marks the active row. Any selection or modification made will reflect on this row only.

Waypoint types

It is possible to enter and recall four different kinds of waypoints on the first column of FlightLog XL.

1) Simple Waypoints:

these are geographical points like cities or reporting points and no other information is associated to them except geographical coordinates.

It's possible to select them by activating the option button 'Waypoint' and clicking the arrow inside the listbox in the first column. A dropdown list will appear from which you'll be able to select the desired waypoint.

If the waypoint is not in the list yet, just enter it by clicking the 'Waypoints …' button. The Waypoint Manager form will be displayed and the entered data will be saved in the Waypoints sheet.

2) Airfields:

these are either airports or airfields.

It's possible to select them by activating the option button 'Airfield' and clicking the arrow inside the listbox in the first column. A dropdown list will appear from which you'll be able to select the desired airfield.

In addition to coordinates (to be found on Jeppesen charts or Bottlang), some more information has to be entered which are the ICAO identifier, the type of air traffic control to establish contact with on the radio (AFIS, TWR, …), the radio frequency, the available runways and the field elevation in feet.

The additional information on the airports selected for a particular flight will be printed in a specific box on the log to be available during flight. See 'Airfield Info'.

Airfield data are entered through the Waypoint Manager form shown by clicking the 'Waypoints…' button and saved into the Airfields sheet.

3) VOR:

see below …

4) NDB:

see below …

VOR radio aids

VORs are the VHF radio beacons. It's possible to use them as waypoints that it's easy to point to with the help of instruments by selecting them in the waypoints column or use them as stations from which to get a magnetic bearing to check the flight progression.

In the first case select them from the waypoints list clicking the down-arrow of the listbox in the log's first column, after selecting the 'VOR' option button among the others placed above the listbox itself.

In the latter case select them on the active row in the VOR column clicking on the proper listbox and choosing from the dropdown list.

QDR:

The value shown in bold by the program in the ‘radial’ column, is the magnetic VOR radial the airplane is on when overflying the waypoint shown on the selected row (magnetic bearing FROM the station or QDR).

Setting the instrument OBS on this value you'll get the index centred when overflying the waypoint.

DME: (from rel.5.0.0)

The value written in the lower part of the ‘radial’ column, preceded by a D, is the DME distance of the waypoint from the DME station co-located with the selected VOR (VORDME).

The DME distance is the ‘slant’ distance in nautic miles shown by the DME receiver (Distance Measuring Equipment), when available on board.

To calculate the DME distance the program needs to know the flight level of the airplane, to be entered in the ‘Alt’ column, and the VOR elevation, that is its height above ground, to be entered among the VOR data in the waypoint manager.

If either of these piece of information is missing, the DME-distance box shows a small red triangle with a short comment that explains the error.

VORs have the following information associated, retrievable from Jeppesen charts, in addition to coordinates:

3-letter code (Ident), Morse code, radio frequency, elevation (height above terrain).

The additional information on the radio beacons selected for a particular flight will be printed in a specific box on the log to be available during flight. See 'VOR Info'.

VOR data are entered through the Waypoint Manager form shown by clicking the 'Waypoints…' button and saved into the VOR sheet.

Starting from FlightLog XL version 2.2, it is possible to show a second VOR column, thus relying for navigation on two VORs and one NDB for each waypoint of the route. This function is particularly helpful on aircraft provided with two NAV receivers and so two VOR indicators.

To show the second VOR column just select the “Show VOR2” checkbox located on the VOR1 column (see figure above).

To make the selection of radioaids quicker, from version 2.2 the button “As Previous” is available on VOR and NDB columns, which allows to select on the current row the radioaid already selected for the previous row.

NDB radio aids

NDBs are the non-directional radio beacons. It's possible to use them as waypoints that it's easy to point to with the help of instruments by selecting them in the waypoints column or use them as stations from which to get a magnetic bearing to check the flight progression.

In the first case select them from the waypoints list clicking the down-arrow of the listbox in the log's first column, after selecting the 'NDB' option button among the others placed above the listbox itself.

In the latter case select them on the active row in the NDB column clicking on the proper listbox and choosing from the dropdown list.

The value calculated by the program in the '(QDR)' column is the bearing FROM the station that the airplane gets when it overflies the waypoint shown on the selected row. Turning the instrument knob so that the airplane actual heading value is on the 12 hours, the indicator's TAIL will show the value printed on the log in this column. This is also true if an RMI or HIS is available, with the obvious difference that no manual setting will be needed.

NDBs have the following information associated, retrievable from Jeppesen charts, in addition to coordinates:

3-letter code (Ident), Morse code and, obviously, radio frequency.

The additional information on the radio beacons selected for a particular flight will be printed in a specific box on the log to be available during flight. See 'NDB Info'.

NDB data are entered through the Waypoint Manager form shown by clicking the 'Waypoints…' button and saved into the NDB sheet.

Altitude

In the 'Alt' column you'll have to enter the altitude in feet to be kept over the waypoint.

If the point is an airport, it will be helpful entering here the traffic circuit altitude.

FlightLog XL also uses altitude in the magnetic declination computing and for climb and descent performance calculations. See 'Declination Computing and Geomagnetic model' for any further information about this subject.

Magnetic heading

It's the heading to be kept on the directional gyro or on the compass to get to the selected waypoint coming from the previous one (disregarding wind effect).

It is calculated algebraically subtracting the magnetic declination from the true heading (geographical).

It is worth pointing out that FlighLogXL calculates the heading by ‘great circle’ formulae, that is considering an ‘orthodromic’ path, which is the shortest. The heading shown is the initial outgoing heading from the starting Waypoint which is not constant, as in the case of a loxodromic path. Nevertheless, considering the short distances between two Waypoints in a route, it is possible to disregard the error and consider the heading constant all along the route with very good approximation. Calculating the loxodromic path instead, would have made the program inaccurate getting next to the poles.

The formulae used for geodetic calculations are the Ed Williams’ work http://www.best.com/~williams/avform.htm, and we want to thank him.

Along track distance

It is the distance, expressed in nautical miles, which separates the considered waypoint from the previous one. As the magnetic heading, it's calculated by the same set of geodetic formulae.

In the distance column header (Leg Dst) the total distance of the flight is shown (TOT DST).

Track time

It's the time, in minutes, that the airplane will take to cover the Along Track Distance, disregarding the wind effect and flying at the speed entered in the 'Estimated ground speed' cell. During climb and descent, the program calculates a proper ground speed decrease.

In the time column header (Leg Time) the total flight time is shown (TOT TIME).

Check column

This column is not compiled by the program and remains blank for the pilot to check waypoints during the flight. It's also helpful to mark, during flight, the future reporting points that the traffic control asks for, in such a way that the pilot doesn't forget them.

ETO, RETO, ATO

These are the Estimated Time Over, the Rectified Estimated Time Over and the Actual Time Over a particular waypoint.

These columns are left blank by the program for the pilot to fill them in during flight as in a traditional manual flight log.

The Airfield Info box

This box contains information on the selected airports, entered by the user in the Waypoint Manager form shown by clicking on the 'Waypoints …' button, that can be retrieved from Bottlang.

The information is the ICAO identifier of the airport, the air traffic control to be contacted (AFIS, TWR, Radio …), the radio frequency of the airport, the runway or runways available and the field elevation on the sea level expressed in feet.

This box is printed on the paper log so that the information related to all of the airfields touched during the flight is quickly available for the pilot.

The ‘ATS Info’ box

This window shows the frequencies of the Air Traffic Services (ATS) affected by the route.

The ATS frequencies are picked up from the information associated to the Waypoints as, for any single Waypoint, it is possible to specify the airspace it belongs to. See The ‘ATS Information’ section of the Waypoint Manager for further information on this subject.

VOR Info and NDB Info boxes

These boxes contain information on VOR and NDB radio aids selected in the flight log, entered by the user in the Waypoint Manager form shown by clicking on the 'Waypoints …' button, that can be retrieved from Jeppesen charts.

The information is the station 3-letter identifier, the Morse code (automatically generated by the program) and the station transmission frequency.

This box is printed on the paper log so that the information related to all of the radio aids selected for the flight is quickly available for the pilot.

Aeronautical ephemeris

In the upper-right box next to the Ground Speed cell, the pilot can write down TakeOff and Landing time.

In the same box the program shows the aeronautical sunrise/sunset time considering sunrise on the first waypoint of the log (supposed to be the one where takeoff takes place) and sunset on the last airport selected on the log (supposed to be the landing airport).

Ephemeris are recalculated upon variation of the 'date of flight' issued.

Caution: UTC time is used (i.e. referred to the Greenwich time zone); the pilot has to take into account the time-zone difference at his location and possibly the daylight-saving time.

The 'Aircraft…' button, climb and descent parameters

From version 3.0, FlightLog XL takes into account climb and descent performance of the airplane for a more accurate computing of times.

Climb and descent parameters are automatically calculated by the program whenever the planning speed (Ground Speed) is modified, using default values reasonable for the average general aviation low-performance planes.

It is however possible, other than advisable for a better planning, to personalize climb and descent parameters entering them into the “aircraft data & parameters” mask (figure below), shown by clicking on the “Aircraft…” button.

Units of measurement:

Although aeronautics should be the world of standards, getting aboard an airplane, even if identical to another we are accustomed to, it’s unfortunately very common running up against instruments calibrated using plenty different measures, for reasons that spread from installation at different times, to the original registration of the aircraft in a foreign country. Thus we happen to get by radio a QNH in hectopascal and to have an altimeter calibrated in “inches of mercury” (!), or to have a checklist in knots but to read an anemometer in mph. Or we happen to pilot an airglider where all the unit of measurement are metric (hurrah!). All this stuff is in shameful contrast with the need for standardization and safety in aeronautics but, that’s it: “the good thing about standards is that everyone can choose the one he likes most”!

In FlightLog XL the main parameter that calculations are based upon is the Ground Speed which is, for clarity, always expressed in knots on the main sheet.

To make pilots’ life easier, anyway, in this mask for flight parameters it is possible to use different units of measurement, by selecting them in the boxes on the top separately for horizontal speeds and for climb and descent rates.

Switching from one unit to another, FlightLog XL makes the proper conversions.

The cruising speed:

For our purposes, and disregarding wind effect, it coincides with the Ground Speed of the airplane in level flight, used to plan the flight and written on the main sheet.

The ground speed, in this mask, is expressed in the unit selected above but, on the main sheet, it is always converted and printed in knots.

The climb and descent speeds:

Climb Speed: it is the cruising climb speed (airspeed) of the airplane during climbing phases. Generally it is slightly higher than Vy.

If not differently specified, FlightLog XL sets the Climb Speed to be 85% of the cruising speed.

Descent Speed: it is the cruising descent speed (airspeed) of the airplane during the descending phases. Generally it is slightly lesser than the cruising speed.

If not differently specified, FlightLog XL sets the Descend Speed to equal to the cruising speed, taking for granted that the descent occurs reducing power without modifying the trim setting.

The climb and descent rates:

They are the vertical speeds (those read on the variometer) assumed by the aircraft during climb (Climb Rate) and descent (Descent Rate).

If not differently specified, FlightLog XL sets both rates to the prudential value of 500 feet-per-minute.

Note that FlightLog XL considers the climb rate constant throughout the whole climb, disregarding the actual decrease it suffers with the increase of the flight level. Thus, when you enter the climb rate of your airplane, it is advisable to use a value related to an intermediate flight-level among those reached during that specific flight.

The “Reset Defaults” button:

It allows to reset the values that FlightLog XL sets by default:

Climb Speed = 85% of the Cruising Speed, Descent Speed = Cruising Speed, Climb Rate = Descent Rate = 500fpm.

The “OK” button:

It closes the mask saving values on the “Aircraft” sheet.

The 'Waypoints' button, Waypoint manager

All data regarding waypoints, airports and radio aids are saved on different sheets of the Microsoft Excel® Workbook.

To enter or modify these data, the user can't directly write to the corresponding sheet and must use the 'Waypoints …' button, which displays the following form called the “Waypoint Manager”:

§ Entering a new Waypoint:

To enter a new Waypoint you have to select its type in the Wpt Type frame on the left side and fill in the relevant text boxes starting from the name to be given to the Waypoint itself.

The input boxes in this form are enabled or disabled by the program depending upon the type of waypoint to be entered. For example, when the user selects a simple waypoint, all the input boxes not significant for a waypoint are disabled (see figure above).

When moving the mouse pointer on input boxes and buttons, a brief help text is shown to assist in the data input.

When finished just click the ‘Add/Modify WPT’ button, or press ‘CLOSE’ to quit the current input.

§ Modifying an existing Waypoint:

To modify a Waypoint you have to select it from the dropdown list shown by clicking on the down arrow in the Name box. The list will contain only Waypoints of the type selected in the frame on the left: that is, it will only contain simple Waypoints or only Airfields or only VOR or NDB radiobeacons.

Once you have selected the desired Waypoint it is possible to modify its fields (except for the name) and then to save it clicking ‘Add/Modify WPT’.

Please note that the name of a Waypoint identifies it in the list and so, if you modify the name, a new Waypoint will be saved instead of the selected one modified.

The only way to modify the name of a Waypoint is to select it, change its name and save it, and later delete from the list the Waypoint with the old name (see below).

§ Deleting a single Waypoint:

Recall the Waypoint to be deleted selecting it from the dropdown list shown by clicking the down arrow in the Name box. The list will contain only Waypoints of the type selected in the frame on the left: that is, it will only contain simple Waypoints or only Airfields or only VOR or NDB radiobeacons.

Once selected, click the “DEL Wpt …” button to cancel it from the list.

§ Deleting all the Waypoints of a given type:

The button “Erase Wpt List …” allows you to cancel the whole Waypoints list of the type selected in the Wpt Type frame on the left. It will then be possible to erase in a single shot all the geographical Waypoints or all the Airfields or all the VORs or NDBs.

NDB.

§ Exporting and Importing a list of Waypoints:

FlightLogXL allows, starting from release 2.0, to export on a file the Waypoints previously entered or to import them from a file which has formerly been created through the Export functionality.

In this way the user can save his own personal lists of Waypoints / Airfields / Radioaids and re-import them in future versions of the program, or make his lists available to other FlightLog XL users (see below).

The “Export Wpt List …” button allows to save on a file the list of Waypoint of the type selected in the Wpt Type frame. The program asks for a file name to save the list that can be freely chosen by the user. The only mandatory part of the name is the file extension (the three letters following the dot) which must correspond to the following scheme:

Extension Type of exported Waypoints

.wpt simple waypoints (that is geographical points)

.afd Airfields

.vor Vor radiobeacons

.ndb Ndb radiobeacons

The “Import Wpt List …” button allows the user to import a list of Waypoints previously exported from FlightLogXL. In this case the extension of the selected file will identify the type of Waypoints to load. Selecting a file with the .afd extension means to import Airfields, aside from the type selected in the Wpt Type frame.

The “Import Wpt List …” button also allows, from version 4.1.0, to import waypoints in GPX format (see below).

§ Importing Waypoints in GPX format:

Starting from version 4.1.0 FlightLogXL allows to import waypoints in GPX format generated by other programs or downloaded from some Internet sites.

The GPX (GPS eXchange format) is an XML file used by many commercial and freeware software including Garmin Mapsource and EasyGPS.

There are also Internet sites which give the opportunity to download waypoint collections in GPX format, as the great GPX Aviation Waypoint Generator by Paul Tomblin which can generate a GPX waypoint archive related to a specific area.

A GPX file may contain geographic waypoints, airports and radioaids contemporarily.

To import a GPX file in FlightLogXL you just have to select in the Import form the GPX format, as shown below.

Caution:

The Waypoint lists belong to the Excel Workbook. All Waypoint additions or changes are then memorized along with the Excel sheet when it gets saved.

The program does not allow to cancel a single add/change operation but it is clear that exiting Excel without saving means to cancel all of the changes or additions made to the Waypoint lists.

§ The ‘ATS Information’ section:

Beginning from 4.0 release, the ‘Waypoint Manager’ mask contains a new section related to airspace information.

To show and hide the ‘ATS Information’ section, click on the ‘Show Airspace Info >>>’ button, well visible on the bottom part of the mask.

In this section it is possible to link the selected Waypoint to the proper airspace it belongs to; selecting the airspace on the ‘ATS Name’ box and saving the Waypoint by the ‘Add/Modify WPT’ button, the information associated with the Waypoint will include the pertaining ATS, whose frequency to be contacted during flight will be printed in the ‘ATS Info’ window.

The adding and managing of the ATS services take place like the corresponding functions relative to Waypoints.

See ahead for a brief explanation about any single control.

The ‘ATS Type’ box:

It allows to select the ATS type among the following:

- FIC (Flight Information Centre), the ATS which controls a FIR (Flight Information Region) airspace, for example ‘London Information’

- ACC (Area Control Centre), the ATS which controls a CTA (Control Area), an AWY (Airway) or a TMA (Terminal Area), for example ‘Alexander Control’

- APP (Approach Control Centre), the ATS which controls a CTR (Control Traffic Region), for example ‘Georgetown Approach’

The ‘ATS Name’ box:

It allows to enter the name of an ATS. The user will enter the complete name for the ATS, like ‘London Information’ for a FIC, ‘Georgetown Approach’ for an APP and so on.

The ‘ATS Freq’ box:

Enter here the radio frequency for the ATS. It will be displayed inside the ‘ATS Info’ window on the Log.

Flight Log XL - VFR easy planner

Copyright (C) 2001-2008 Andrea Moressi

ver. 5.1.0

go to: www.flightlogxl.com

Summary:

- Installing and starting the program

- Quick start

- Cooperate with FlightLog XL !

- Using FlightLog XL

- Geographical coordinates

- Declination computing & geomagnetic model

- FlightLogXL’s users survey

- License agreement

Flight Log XL - VFR easy planner

Installing and starting the program

Quick start

Introduction

The date of flight

The Ground Speed

The active row

Waypoint types

VOR radio aids

NDB radio aids

Altitude

Magnetic heading

Along track distance

Track time

Check column

ETO, RETO, ATO

The Airfield Info box

The ‘ATS Info’ box

VOR Info and NDB Info boxes

Aeronautical ephemeris

The 'Aircraft…' button, climb and descent parameters

Units of measurement:

The cruising speed:

The climb and descent speeds:

Climb Speed: it is the cruising climb speed (airspeed) of the airplane during climbing phases. Generally it is slightly higher than Vy.

If not differently specified, FlightLog XL sets the Climb Speed to be 85% of the cruising speed.

Descent Speed: it is the cruising descent speed (airspeed) of the airplane during the descending phases. Generally it is slightly lesser than the cruising speed.

If not differently specified, FlightLog XL sets the Descend Speed to equal to the cruising speed, taking for granted that the descent occurs reducing power without modifying the trim setting.

If not differently specified, FlightLog XL sets both rates to the prudential value of 500 feet-per-minute.

The “OK” button:

The 'Waypoints' button, Waypoint manager

§ Entering a new Waypoint:

§ Modifying an existing Waypoint:

§ Deleting a single Waypoint:

§ Deleting all the Waypoints of a given type:

§ Exporting and Importing a list of Waypoints:

Extension Type of exported Waypoints

§ Importing Waypoints in GPX format:

§ The ‘ATS Information’ section:

The ‘ATS Type’ box:

The ‘ATS Name’ box:

The ‘ATS Freq’ box:

The ‘Add/Modify ATS’, ‘DEL ATS’, ‘Import ATS List’ and ‘Export ATS List’ buttons: