I just finished my paper log-book, and decided it's time to move into the 21st century, so I created the attached spreadsheet. Feel free to download and use it. It should be self-explanatory but let me know if you have any questions.







1. After downloading it, change the headings to suit the flying you do (e.g. I have helicopter and sea-plane columns which you might want to relpace with something useful to you). Also, I included a few rows of my own flights, just so you can see how it works. Obviously, you can over-write with your own.


2. Enter your current "AMT FORWARDED" in row 3, just like you would on a new page of a paper logook.


3. You can simply fill out the normal logbook entries, (don't forget "Control :" enters today's date). 


4. However, if, like me, you tend to fly mostly one aircraft, then the little calculator in columns X and Y allows you just to enter current Hobbs time (1st entry), and thereafter all you have to do after each flight is enter your return Hobbs time (I usually just take a photo of the Hobbs with my phone, because I'm too idle to write it down. All the other cells for that row will then auto-populate. Just enter the date (Cntrl:), maybe some notes, and you are good to go.


Note that the autopopulate uses my home airport and aircraft number; have a look in the formulae for the cells, and you will see this and you can change it to your own data.


5. Finally, when you have personalized it to your liking, I strongly suggest protecting the sheet (Home-Cells-Format-Lock Sheet, and use default settings). This will protect all the locked cells in the top few rows so you cannot later inadvertantly over-write your time carried forward or a total time.


Happy flying,


Seb Dewhurst

Views: 6506


Reply to This

Replies to This Discussion

beatifull Log Book !!!!!



New from Zenith:

Zenith Planes For Sale 

Classified listing for buying or selling your Zenith building or flying related stuff...

Custom Instrument Panels
for your Zenith

Custom instrument panels are now available directly from Zenith Aircraft Company exclusively for Zenith builders and owners. Pre-cut panel, power distribution panel, Approach Fast Stack harnesses, Dynon and Garmin avionics, and more.

Custom Upholstery Kits for your Zenith Aircraft:

Zenith Vinyl Upholstery Kits

Zenith Apparel from EAA:

Zenair Floats

Flying On Your Own Wings:
A Complete Guide to Understanding Light Airplane Design, by Chris Heintz

Builder & Pilot Supplies:

How to videos from HomebuiltHELP.com

Developed specifically for Zenith builders (by a builder) these videos on DVD are a great help in building your own kit plane by providing practical hands-on construction information. Visit HomebuiltHelp.com for the latest DVD titles.

Aircraft Insurance:


West Coast USA:

Pro Builder Assistance:


Transition training:

Golden Eagle Aviation

Pianosa Flying Farm

Aircraft Spruce & Specialty for all your building and pilot supplies!

© 2020   Created by Zenith.Aero.   Powered by

Badges  |  Report an Issue  |  Terms of Service