Go Back  PPRuNe Forums > Non-Airline Forums > Private Flying
Reload this Page >

Do I need a logbook ?

Private Flying LAA/BMAA/BGA/BPA The sheer pleasure of flight.

Do I need a logbook ?

Old 29th Jun 2019, 16:44
  #21 (permalink)  
 
Join Date: Feb 2000
Location: UK
Posts: 13,805
Originally Posted by 18greens View Post
I've started! Any tips on structure, column headings etc....How to accommodate Sim time.
Well I'll tell you how I've done it; whether that is good or bad I'm unsure - but it works for me.

The main spreadsheet has three pages: logbook, calculations, and summary.

Logbook page looks, well, rather like a logbook. First columns are Date (hidden column turning that into a digital date), type, reg, generic type (useful as I'm not interested in hours in C172Ns, but I am interested in time in C172s), PiC, Other seat, from, to, details, take-offs, landings, approaches, departure time (hh:mm format), arrival time (ditto), hidden column calculating flight time as a decimal, visible columns showing hours and minutes separately (just works better that way in Excel), Then I have multiple columns for the usual totals - and in Excel you can obviously have as many as you want, rather than the limitations of your paper logbook. In my case, my paper logbook has 12 columns but my electronic logbook has 20 - it's useful to keep track of things like FAA X-country and high performance time, but no need to clutter up my main logbook with it.

I find that having values in the columns as hours to 3 decimal places works well as you get no rounding errors, totals are all automated at the top of the page with a simple formula to turn that n.nnn hours to hours and minutes. Select all of that as a formatted "print area" to make it easy to print out. To the right I have various automated columns that keep track of things like Cessna hours, single seat hours, vintage taildragger hours as I occasionally get asked these things and it doesn't need to be visible in the main body.

Second page is calculations - it works out things like hours on each generic type, approaches in the last 182 days for my FAA IR, take-offs and landings in the last 90 days... That isn't visible to anybody but me and is happily scruffy but functional.

Third page is formatted as a 1 page of A4 to be printed out as a full logbook summary. From it you have "at a glance" hours in my main types, classes, and roles (e.g. instructor, tailwheel, single seaters, Piper singles), Separate FAA and EASA totals as they reckon things differently, dates of my medical, CofV, BFRs, rating expiries, visa and vaccination expiries with it automated to turn dates running out in the next 3 months orange, and expired red. A couple of boxes with manually updated / entered information like aeroplanes I've flown first flights on, licence numbers and ratings, dates of exam passes, ejector seat time - stuff that belongs in a flying CV (which in effect that page is) but not in the main tabulated logbook part. Essentially everything there

Thing is, create something simple that works, start populating it, then start complicating it with the stuff that matters to you. But a good robust basic structure from the start helps a lot. Use Excel's automation as much as you can.so that ideally you just enter data and it all ripples through - and can tweak the code from time to time when you want it to work out something new.

G
Genghis the Engineer is online now  
Old 19th Aug 2019, 11:58
  #22 (permalink)  
 
Join Date: Jun 2001
Location: England
Posts: 1,003
Originally Posted by Genghis the Engineer View Post
I have a paper logbook as primary, and electronic (written by me in Excel as none of the commercial products suited my personal needs) as secondary. When I need to send anything to the CAA, they get a printout of the Excel logbook (printed on A3 it works out about 100hrs per side of paper), with my signature on the first and last pages stating "I certify that this is a true copy of my original logbook". I then shred the printout once they've sent it back with my licence.

They've always accepted it. The Excel logbook is backed up to two different places automatically as part of my normal data backup.

G
When you send it off to the CAA do you print subtotals on every page or just rely on the grand total at the top of the first page?
18greens is offline  
Old 19th Aug 2019, 16:28
  #23 (permalink)  
 
Join Date: Feb 2000
Location: UK
Posts: 13,805
Originally Posted by 18greens View Post
When you send it off to the CAA do you print subtotals on every page or just rely on the grand total at the top of the first page?
Grand Total, plus I send them the broken down summary 1-pager.

G
Genghis the Engineer is online now  
Old 15th Sep 2019, 21:18
  #24 (permalink)  
 
Join Date: Jun 2001
Location: England
Posts: 1,003
Originally Posted by Genghis the Engineer View Post
Grand Total, plus I send them the broken down summary 1-pager.

G

Well , it took 2 months. Now it's done, just about to send it off to the CAA to test your theory...

As you say it was a satisfying experience and going forward I'm tempted just to stick with Excel. The paper logbook seems quite dated by comparison. Thanks for the tips.
18greens is offline  
Old 16th Sep 2019, 07:25
  #25 (permalink)  
 
Join Date: Feb 2000
Location: UK
Posts: 13,805
Personally I'm very happy to keep running the two in parallel.

Glad I was able to help.

G
Genghis the Engineer is online now  
Old 28th Oct 2019, 16:14
  #26 (permalink)  
 
Join Date: Jun 2001
Location: England
Posts: 1,003
Originally Posted by Genghis the Engineer View Post
Personally I'm very happy to keep running the two in parallel.

Glad I was able to help.

G
Sending off the Excel worked. The odd thing was that they didn't send it back, just the new licence.Don't know if that was an oversight.
18greens is offline  
Old 18th Oct 2020, 11:27
  #27 (permalink)  
 
Join Date: Apr 2009
Location: A place in the sun
Age: 79
Posts: 929
Not only is it a legal requirement, but it is useful in later life. I have been writing, in my old age, stories about various aviation experiences and have found old log books invaluable to jog the memory. Unfortunately, after several house moves and between countries too, I have lost two of them and miss most dreadfully the dates, times and notes therein.
Bergerie1 is offline  
Old 18th Oct 2020, 22:43
  #28 (permalink)  
 
Join Date: Dec 2004
Location: Under the clag EGKA
Posts: 985
My pa gave me a logbook at the age of 7 when he sent me up in an Auster for a flip. The pilot signed it with exercises noted.
effortless 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.