If you do plan to ever upload your logbook to one of the online versions, this can be relatively easily done by saving it as a. I still keep that logbook up, in addition to, and also in addition to a paper log. I do have a "dividing line/border" every 13 entries though, like the logbook pages.) (I highlight the appropriate entries and look at the total it calculates at the bottom of the screen. I can see where having your logbook add up the times for each page automatically would be nice. Looks very similar to yours, except no division of pages.
I don't know what the other version does, but I found it worked best to run across three sheets - one for the tabulated logbook, a second for the calculations, and a third which is the summary page for display and printing if anybody wants a logbook summary.I have been using a similar excel logbook since about 1995, also based on the Jeppesen logbook. 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.
0 kommentar(er)
