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. There are also coriolis and refraction tables along with motion of the observer and motion of the body correction tables from Pub 249. The performance data is from T.O. 1C-118A-1 C-118A Flight Manual. PMDG modeled their aircraft so well that the real tech data generally works. The spreadsheet is designed to offer period correct planning tools. In other words, you have to think and plan your route and performance factors. 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. It is focused on the USAF C-118 but works just as well for a DC-6B. Their are a lot of tabs so there are ample hyperlinks in the spreadsheet for navigation and a home page up front.
Some tips: Times are 24 hour clock and must be entered in hh:mm format. Any entry for latitude and longitude requires a minus sign for west and south while east and north are positive. Those cells are also formated that you would just type -730554 for W74° 05' 54'' as an example. On the electronic E6-B user entries are in the yellow highlighted cells. The sheets are protected so you can't acidentially delete the formulas. The elcetronic E6-B will even do your wind correction angles and degrees to parallel or intercept.
Don'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. I'll update this as I add new features or correct any errors in the formulas or formats.
Update 1.1 to correct formula error row 27 time to next way point on flight planning sheet
Update 1.2
1. Added hyperlinks for easier access between flight plan, celestial precomputation sheets and fuel planning
2. Added planned and actual fuel to the Flight plan. Fuel load and PPH must be entered on the flight plan heading section for this to work. Planned fuel at each navpoint is calculated and displayed for the route. Enter the actual fuel at each checkpoint if desired.
3. Formatted flight plan heading for more logical flow of entry
4. Placed ATA under ETA in the flight plan for more logical flow
5. Standardized look of user input cells and data output cells throughout the spreadsheet.
6. Formatted all precomputation sheets with Italian time format allowing formulas to perform most of the math functions in the precomputation sheets.
7. Added comments to each precomputaion input cell to show entry format
8. Added a printable template and instruction to modify an E6-B to calculate motion of the observer and motion of the body corrections.
9. Standardized fonts on precomputation, flight plan, and fuel planning to Times New Roman for easier reading
Do you have a suggestion for another program apart from excel to use this? In order to use it, I have to have office 365 which I'm trying to save on cash atm and can't pay the monthly price for it.
2 years ago
WhiteGinger3000
When I open it in LibreOffice, I get a message that "Airline Nav Log PW=connie BETA31.xlsm can not be loaded". Still evertything seems to work. Just so you know. 😊
3 years ago
That's odd. I was experimenting with a feature from another spreadsheet developed for the A2A Connie to see if it was worth contacting the author to request permission to modify it but I deleted it. I don't get that message in MS Office but I'll try to see if I can figure it out. There are no macros or imported data in this spreadsheet, just images, text and formulas doing math.
Edited: I installed libreoffice and got the same thing. Unfortunately, I can't seem to make it go away. It seems as though libre is looking for something that is no longer there when it first opens up but otherwise it works fine. If I find a solution to this I will fix it in the future. Thank you.
3 years ago
chague
Haddock
Brilliant.. Thankyou for figuring all this out...
3 years ago
NZedder
Thank you very many!😁
3 years ago
Bartul
So cool. Well done indeed - and many thanks too!
3 years ago
RHODI3