RES - Reserve fuel rule, selectable between Turbine (30 min final reserve fuel), Piston (45 min final reserve fuel) or Isolated Aerodrome (2 hrs final reserve fuel).

The WIND DIR - SPD per waypoint overrules the WINDS ALOFT table.įuel is automatically calculated, the only editable cells are:

WINDS ALOFT, winds can either be entered separately per waypoint or in the WINDS ALOFT table.

Optimum altitude based on trip distance (50% of flight time climbing / descending, 50% of flight time in cruise) is shown below cruise performance section.

Surface condition (selectable from list).

General flight information is added to the OFP as below:įor departure, destination and alternate: on the last line of the trip area and diversion.

WIND DIR / SPD - Wind Direction and Speed can be entered per waypoint or it can be left blank and the WINDS ALOFT table can be used (explained later).ĭon’t forget to enter track, distance etc.

GRID MORA - The GRID MORA or MSA on the repective leg.

DIST INT - The interval distance, in other words the distance to that waypoint.

When planning an IFR flight all tracks are already magnetic → use MAG. For example, when planning a VFR flight and measuring tracks on a chart against the local meridian → use TRUE. TRUE / MAG TRACK - Ability to switch between TRUE and MAGnetic depending on whether the tracks entered are referenced to True North or Magnetic North.VAR - Magnetic variation (East = positive, West = negative).AWY - The airway, departure / arrival route etc.In total the Operational Flightplan can display up to 42 waypoints including Top of Climb and Top if Descent (automatically calculated). Macros need to be enabled for the loadsheet to automatically rescale the CG envelope!

If anyone wants to modify my file however, go ahead, password is “fs2020”. It isn’t necessary to unprotect sheets during normal use as all relevant cells are editable. Most of the sheets are password protected merely to prevent inadvertently overwriting formulas in certain cells.

This tool still requires to go through the POH performance pages for take-off / landing performance, cruise TAS and fuel consumption, climb fuel, entering track, distance and wind per waypoint etc.Įxactly how we used this tool in real world training environment, the basic VFR part was solely by hand to get the student familiar with manual flight preparation after which we switched to the excel based flight planning tool. Its not as advanced as SimBrief obviously but ideal for someone who knows already how to manually prepare a flight (use of flight computer, wind correction, manual calculations etc.) to have some of the time consuming tasks automated, or to crosscheck ones own flight preparation.

Free project planning tools excel