Excel Log Book

WDD

WDD

Final Approach
PoA Supporter
Joined
Oct 16, 2019
Messages
6,166
Location
Atlanta / Marietta
Display Name
Display name:
Vintage Snazzy (so my adult children say)
Would anyone like a copy of this? I use it as a back up to my paper log book, and to keep track of meeting requirements, keeping current, etc. Has formulas, conditional formatting, and a few other goodies. Something you can take and tinker on to make your own.

upload_2023-2-19_18-37-44.png


upload_2023-2-19_18-38-21.png


upload_2023-2-19_18-39-57.png
 

Attachments

  • upload_2023-2-19_18-36-39.png
    upload_2023-2-19_18-36-39.png
    166.6 KB · Views: 11
  • upload_2023-2-19_18-36-39.png
    upload_2023-2-19_18-36-39.png
    166.6 KB · Views: 8
Nice job. I've been using an eLog for about 30 years now. Like yours, it started as a backup to paper and calculator. Big help for keeping track.

I still have it but stopped using mine after subscribing to MyFlightBook in 2006, now my "official" logbook.
 
MyFlightbook is way easier for me. It automatically generates backup files that Excel can read, but in the ~8 years I've used it I've never had a need to use a backup.
 
I couldn't resist... This was the flight entry screen in my homemade eLog. It started out in Paradox, a DOS database program and was eventually ported to MS-Access. It had a lot of functionality - queries, reports, etc - but Microsoft Access upgrades tended to studiously avoid being backward compatible. It hasn't been updated in at least 10 years - the last entry (picture) was in May, 2010 - so not even things like the forward and back buttons work anymore.
upload_2023-2-20_8-44-28.png
 
Mine prior to 1996 was in a Mac database program called Helix Express, from which I exported the data to Excel. It was the database I ran my gym on, prior to so many dedicated gym programs now in use.
 
Looks like there are a lot of sharp excel/ access people here!
 
midlifeflyer said:
I couldn't resist... This was the flight entry screen in my homemade eLog.
Click to expand...
OK, if we're showing off homemade logs, this was mine, written in Autoit. One goal was to make it look like a simple paper logbook, data saved in a .csv file. One unusual feature it had was being able to keep track of time in hours and minutes for those of us without a decimal Hobbs meter. I was working on merging it with a GPS track analyzer I also wrote, to automatically make log entries, but I lost interest in the logbook and kept working on the track analyzer.

upload_2023-2-20_14-5-46.png
 
WDD said:
Looks like there are a lot of sharp excel/ access people here!
Click to expand...

I've been immersed in the Office Suite and VBA for almost 30 years. The amount of code I've written...100,000 lines plus probably, maybe a quarter million??

I have the code written to find the great circle distance in VBA somewhere, and have been meaning to integrate it into my logbook, just to see how many nm miles I've flown. Of course that won't take into account a sightseeing flight with no other airports of landing.
 
schmookeeg said:
Am I the only one who logs in GSheets? :)
Click to expand...
I use Excel and GSheets depending on the "requirement." For my eLogs I use GSheets because it is readily available on phone, tablet, and PC.
 
L J Donelson said:
I use Excel and GSheets depending on the "requirement." For my eLogs I use GSheets because it is readily available on phone, tablet, and PC.
Click to expand...

Same. The oddball places where I've been asked to cough up some unique insurance requirement sort of makes it necessary.
 
A lot of work. :D

I use Safe Log Pro now. It syncs a copy to their cloud plus all of your devices. So I have 2x tablets, 2x computers, my phone and laptop. Including their cloud, 7 copies. :D Plus my hard copy logbook.

It automatically tracks things like HP, complex, retract, TW, etc based on N-number.
 
Pinecone said:
A lot of work. :D
Click to expand...
True. But there weren't other eLog options when I put it together. In my case, I'm a geek and it was fun to build and program. Same for my Excel flight planning spreadsheet which included an airport and VOR database (and a Colorado mountain pass database)

Now, I have all you have with MyFlightBook, except for the hard copy logbook. My last paper log entry for a non-dual flight was in 2013. For a dual flight, 2019.
 
I built mine on excel 15+ years ago. I futz with the currency formulas from time to time. Otherwise it’s been perfect for what I need
 
midlifeflyer said:
True. But there weren't other eLog options when I put it together. In my case, I'm a geek and it was fun to build and program. Same for my Excel flight planning spreadsheet which included an airport and VOR database (and a Colorado mountain pass database)
Click to expand...

I understand the geek factor. I have a number of Access databases and Excel spreadsheets for various things.

I was using AeroLog Pro from the late 80s or early 90s for electronic logs. My primary was paper though.

It bit me in the butt when my paper log book was lost in a crash, and I found out I was 2 years behind in putting flights in my electronic log book. NOW, electronic first (and synced to cloud and a couple of devices), then paper when I get around to it. And paper log book normally stays at home.
 
I use paper after the flight ends, put it in excel when I get home, and when each page is filled I scan it.
 
Do you carry your log book in the plane with you?

I do NOT do so, unless I am flying to somewhere I will be getting instruction and need it for the instructor to do their entries.
 
I do. I need to record the hours, destination, approach, number of landing, etc. someplace after I land. Anyway - if something happens when flying that the log book is destroyed, that paper copy of my flight history would be the least of my worries :) .
 
Pinecone said:
Do you carry your log book in the plane with you?

I do NOT do so, unless I am flying to somewhere I will be getting instruction and need it for the instructor to do their entries.
Click to expand...
Well, since it's 100% online and accessible through an app on my phone and tablet, it would be difficult not to carry it in the plane with me.

If I still used paper? No. There's no reason to have it with you unless you need someone to sign it or fall into one of the handful of categories in which having it is required.
 
WDD said:
I do. I need to record the hours, destination, approach, number of landing, etc. someplace after I land. Anyway - if something happens when flying that the log book is destroyed, that paper copy of my flight history would be the least of my worries :) .
Click to expand...

Having been in that situation, short term yes, but long term, maybe it is a problem. The problem is, you lose the log book in the post crash fire. And later, once you recover, you find you had not been so diligent in updating your electronic version, so you have no way of recovering those log entries.

Using Safe Log Pro, I can enter each flight in my phone or tablet, and immediately sync it to the cloud. Worse case, write things down on a piece of paper until you get home and then log them in your log book.

FYI, I carry a picture of my FR sign off, plus my other documents.
 
You must log in or register to reply here.
Back
Top