pilot logbooking medium, excel logbooking question
Thread Starter
Joined: May 2010
Posts: 36
Likes: 0
From: Between that rock, and that hard place
pilot logbooking medium, excel logbooking question
Anyone have a good excel for logbooking? I am getting tired of changing logbook mediums. I like paper, but I also like a digital backup in case the house burns down or something happens to them. I am tired of the apps that require a subscription service, or apps that up and go out of business. I feel like a basic excel is the way to go, but I don't really know how to make one of these. Any suggestions? Thanks folks.
Joined: Dec 2005
Aviation Qualifications: ATPL
Posts: 4,973
Likes: 326
From: Hong Kong
Excel is great when you know how it works: you learn by doing. The advantage is that you have the 'raw data' which means you can make it to you whatever you want.
Start by setting the columns out how you like them (follow your paper logbook for guidance) then googling the various functions available in excel.
Most of it can be done with IF and SUM initially but you can go as advanced as you like with tick boxes, date functions etc which will tell you if you're in currency etc.
If you use the free online version on OneDrive and send me a link I'll have a look at what you've got and give you some pointers.
Start by setting the columns out how you like them (follow your paper logbook for guidance) then googling the various functions available in excel.
Most of it can be done with IF and SUM initially but you can go as advanced as you like with tick boxes, date functions etc which will tell you if you're in currency etc.
If you use the free online version on OneDrive and send me a link I'll have a look at what you've got and give you some pointers.
Joined: Jan 2013
Posts: 52
Likes: 0
From: europe
Give this one a try https://excelpilotlogbook.com/
I like it
I like it
Thread Starter
Joined: May 2010
Posts: 36
Likes: 0
From: Between that rock, and that hard place
ah ha! Thank you both for the help. I'll consider both of these options. I really do need to learn excel at some point in my life, however the lazy $45 method is appealing=)
Joined: Sep 2002
Aviation Qualifications: CPL
Posts: 4,721
Likes: 636
From: Great South East, tired and retired
But your Hobbs ticks over in decimals. Maintenance logs are in decimals. And minutes are a pain to add up on a calculator, though Excel can probably cope with them.
I was extremely glad when, in the early 70s, our air force switched to decimals and my secondary job of keeping the training records of the Bograts in the squadron became much easier.
I was extremely glad when, in the early 70s, our air force switched to decimals and my secondary job of keeping the training records of the Bograts in the squadron became much easier.
Guest
Posts: n/a
Give this one a try https://excelpilotlogbook.com/
I like it
I like it
Would you mind sharing a few screenshots (in a PM, if you like)?
