Added comments to each precomputaion input cell to show entry formatĨ. Formatted all precomputation sheets with Italian time format allowing formulas to perform most of the math functions in the precomputation sheets.ħ. Standardized look of user input cells and data output cells throughout the spreadsheet.Ħ. Placed ATA under ETA in the flight plan for more logical flowĥ. Formatted flight plan heading for more logical flow of entryĤ. Enter the actual fuel at each checkpoint if desired.ģ. Planned fuel at each navpoint is calculated and displayed for the route. Fuel load and PPH must be entered on the flight plan heading section for this to work. Added planned and actual fuel to the Flight plan. Added hyperlinks for easier access between flight plan, celestial precomputation sheets and fuel planningĢ. Update 1.1 to correct formula error row 27 time to next way point on flight planning sheetġ. I'll update this as I add new features or correct any errors in the formulas or formats. The elcetronic E6-B will even do your wind correction angles and degrees to parallel or intercept.ĭon't have or want the PMDG DC-6 but stil like Cel Nav and the rest of the stuff? Use the parts you like and enjoy. The sheets are protected so you can't acidentially delete the formulas.

On the electronic E6-B user entries are in the yellow highlighted cells. Those cells are also formated that you would just type -730554 for W74° 05' 54'' as an example. Any entry for latitude and longitude requires a minus sign for west and south while east and north are positive. Some tips: Times are 24 hour clock and must be entered in hh:mm format. Their are a lot of tabs so there are ample hyperlinks in the spreadsheet for navigation and a home page up front. It is focused on the USAF C-118 but works just as well for a DC-6B. The hard computations on the flight plan/log are automated but you still have to enter basic data like TC, Winds, Temp, Altituide, Planned IAS (hint, you can find that in the cruise performance charts), and magnetic variation. In other words, you have to think and plan your route and performance factors. The spreadsheet is designed to offer period correct planning tools. PMDG modeled their aircraft so well that the real tech data generally works. There are also coriolis and refraction tables along with motion of the observer and motion of the body correction tables from Pub 249. This spreadsheet inlcludes fuel planning, flight plan/navigation log, an electronic E6-B, take-off and landing speeds, cruise performance data, and celestial navigation precomputation sheets for Electron Volt's amazing MSFS Cel Nav addon.

Pmdg 777 fuel planner