Entering time and date is fine - but what I do in mine is then work in 3 places past the decimal in all the calculations (so 1.5 = an hour and a half for example), then wrote a simple algorithm to turn that into hours and minutes in two columns wherever I need totals outputs to that level of accuracy. The biggest problem with Excel, and its a pretty trivial one, is that it doesn't handle minutes well in calculations. You're welcome to a copy of mine to play with it you want to drop me a PM with your email address, but I'm sure that one is as good as mine, and with either, as it's in Excel you can just muck about with it to tailor it to your own exact requirements. I don't plan to stop using my paper logbook and it's a moot point which is backing which up, but I find Excel an excellent tool for the task. Unsurprisingly perhaps, it's extremely similar to the one at that link - as presumably he and I were both trying to solve basically the same problems with the same tool. Once you have entered your Night flying manually in the Logbook, the Dashboard will indeed calculate the TOTAL Night flight time from all of your flights - as the Dashboard does with every other category/type of flying.I wrote and use my own logbook in Excel.
You'll need to enter the amount of Night time you want to log (per flight) manually - as you would do with any other type of hours (Cross Country, Multi-Engine etc). Neither of these downfalls are good for performance & usability. However, it is very resource-heavy and results in a much larger file size (because the file has to store every single airport latitude/longitude data). Of course, it is possible to formulate an algorithm to do this, based off your on/ff blocks times to/from different airport locations around the world. Excel Pilot Logbook WILL calculate the Total Time to be 4 hours but it will not calculate the Night portion to be 2 hours.
To elaborate, it will not calculate the Night PORTION of a flight between, for example, 16:00 and 20:00 when sunset is at 18:00. Unfortunately, our Excel Pilot Logbook spreadsheet does not automatically calculate the Night PORTION of your flights (based on your Off Blocks / On Blocks times) - as some other apps can do.
0 kommentar(er)
