![]() ![]() 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. Of course, you can change the format to suit your own countries layout, so, to make this whole process easier for yourself, it’s a great idea to have your own Paper Logbook next to you so that you can reference the correct layout and the heading names etc. 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. We’re going to make an electronic version based on the Jeppesen Pilot Logbook layout. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |