I've written an Excel Worksheet that serves as a logbook for multiple drones.  One sheet records all the aircraft data; serial numbers, purchase information, etc.  The main log requires manual entry of the flightrecord from your smartphone.  Standard stuff, location, GPS coordinates, time of flight, duration of flight, distance flown, max altitude, notes, etc,  It also tracks maintenance, repairs, total hours and distances flown for each drone on record.  Anyone interesteded?  Willing to share if you are.  Send a private email request to baykayakr@gmail.com   If you need to track your flights, might be helpful to you.

If it's your own work feel free to upload to the forum (attachments supports compressed archives), it will remain here for everyone's benefit.

Thanks for sharing

Thanks for sharing.

OK, Thanks.  I have attached a compressed file containing the UAS Flight Log.  

This workbook contains locked spreadsheets to prevent accidental loss of the format and/or formulae used.  All cells requiring input are unlocked.  The workbook does not contain any macros.  I believe the workbook is self explanatory, and I've included example entries that you should erase before you begin using it for your own purposes.

One note; flight time must be entered as minutes and seconds.  This format allows for quicker entry than having to include separator symbol.  Please use whole integers for both as decimals result in erroneous calculations.  The two columns are concatenated for visual purposes.

If you have comments, please let me know.  If you would like to see additional information incorporated into the workbook, I would like to know that also.

Best,
Dave

What did I do wrong?  I do not see the attachment.

I went to Advanced and thought I uploaded a zip file containing the log.  

Please advise.

OK, I think that got it.

I overlooked the fact that some of us use the metric system as opposed to imperial units.  This version allows you to set your preference for which system to use.

Thanks. I see a small bug. Your link to pilot information (Owner information) does not match the tab name. i fixed that on my copy.

GaryDoug Posted at 8-5 20:12
Thanks. I see a small bug. Your link to pilot information (Owner information) does not match the tab name. i fixed that on my copy.

Thanks Gary.  I've uploaded a revision with the repaired link.  This version also includes a slot that allows the pilot to record his Remote Pilot Certification Nr if he has his 107.

I've updated the Flight Logbook.  After a few comments, and some bug fixes, I'm uploading the latest version; 1.81.

Again, if you find the log useful, please let me know.  If you have any suggestions for improvements, or additional information, let me know.

Dave

Pretty cool idea Dave.  Thanks for sharing!  

TonyPHX Posted at 9-5 10:01
Pretty cool idea Dave.  Thanks for sharing!

Thank you.  I think we're all going to be keeping detailed logs in the near future.

TonyPHX Posted at 9-5 10:01
Pretty cool idea Dave.  Thanks for sharing!

TonyPHX,

How can I delete my previous upload?  Or can you delete the post with version 1.81?  It contains a few bugs that have since been fixed, and a print macro that does not work properly.

Any help is appreciated.

Excellent logbook thank you so much for sharing!

nate22007 Posted at 10-4 10:08
Excellent logbook thank you so much for sharing!

Thanks for the comment Nate.  If you downloaded version 1.81 let me know and I'll send an updated version.  1.81 had a few glitches and Admin didn't tell mw how to replace it.