pilot logbooking medium, excel logbooking question
Thread Starter
Join Date: May 2010
Location: Between that rock, and that hard place
Posts: 36
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Join Date: Jan 2013
Location: europe
Age: 38
Posts: 52
Likes: 0
Received 0 Likes
on
0 Posts
Give this one a try https://excelpilotlogbook.com/
I like it
I like it
Thread Starter
Join Date: May 2010
Location: Between that rock, and that hard place
Posts: 36
Likes: 0
Received 0 Likes
on
0 Posts
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=)
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)?