Go Back  PPRuNe Forums > Aircrew Forums > Rotorheads
Reload this Page >

pilot logbooking medium, excel logbooking question

Rotorheads A haven for helicopter professionals to discuss the things that affect them

pilot logbooking medium, excel logbooking question

Old 13th Jan 2021, 16:10
  #1 (permalink)  
Thread Starter
 
Join Date: May 2010
Location: Between that rock, and that hard place
Posts: 36
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.
rabidcat is offline  
Old 13th Jan 2021, 16:21
  #2 (permalink)  
 
Join Date: Dec 2005
Location: Wherever I lay my hat
Age: 42
Posts: 450
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.
rudestuff is offline  
Old 13th Jan 2021, 16:32
  #3 (permalink)  
 
Join Date: Jan 2013
Location: europe
Age: 35
Posts: 48
Give this one a try https://excelpilotlogbook.com/
I like it
helimo is offline  
Old 14th Jan 2021, 03:05
  #4 (permalink)  
Thread Starter
 
Join Date: May 2010
Location: Between that rock, and that hard place
Posts: 36
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=)
rabidcat is offline  
Old 14th Jan 2021, 09:25
  #5 (permalink)  
 
Join Date: Apr 1999
Location: Everywhere
Posts: 84
And it's perfectly possible in Excel to have the times in "h:mm" format if you prefer that to decimal hours - which I hate.
Mushroom_2 is offline  
Old 15th Jan 2021, 07:50
  #6 (permalink)  
 
Join Date: Sep 2002
Location: Great South East, tired and retired
Posts: 3,187
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.
Ascend Charlie is offline  
Old 15th Jan 2021, 09:43
  #7 (permalink)  
 
Join Date: Apr 1999
Location: Everywhere
Posts: 84
All my airline and rotary flying in UK was in hours and minutes, but I am sure decimal is the future. Just an old dinosaur talking.
Mushroom_2 is offline  
Old 15th Jan 2021, 20:02
  #8 (permalink)  
 
Join Date: Jul 2011
Location: N/A
Age: 43
Posts: 40
Is it already allowed in the EASA world to log hours on anything else than paper? (Except for companies with an air operator certificate..)?
casper64 is offline  
Old 16th Jan 2021, 06:04
  #9 (permalink)  
 
Join Date: May 2008
Location: East of Africa
Age: 45
Posts: 915
Originally Posted by helimo View Post
Give this one a try https://excelpilotlogbook.com/
I like it
It actually looks fancy...

Would you mind sharing a few screenshots (in a PM, if you like)?
hueyracer is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.