Excel Logbook

USMC-SSGT

USMC-SSGT

Well-Known Member
I can not add the attachment on this site because it will not let me but I made a logbook on excel that has all the columns you would need as a proffessional or student pilot and can be modified by you to fit your needs. It is self totalling with formulas so all you will have to do add in your times like a normal logbook and it will total the rest and add up your totals for you.

http://www.airlinepilotforums.com/showthread.php?t=5079

not to cross promote other sites by any means here, it is only because this site will not let me attach a .ZIP file. (sorry doug)

For those of you who want it, it is Excel so you have to have excel to use it.

There are many many many WAY better programs out there to use for a logbook but they are not all free and I was bored so I made my own.

For those flying typed aircraft you can just remove the complex,high performance or tailwheel categories and substitute Turbine PIC, > 12,500 etc. what the columns say will not affect the totals

All I ask is that if you do modify it let me and the others know what you did so we can all benefit from whatever improvements you might have made.

on a side note it looks all crazy in print preview mode but that is because I have it set up to print on one page in landscape format so that it doesnt take up three pages for one pages content.

Ok that is all! Good Day!
 
when i started filling out applications I found that adding up all the solo xcty at night in IMC etc. etc. became tedious so I created an Access database. Databases are much more versitile than excel as you can run queries on them. An example query would be:

"Show my all my flights that I logged Xcty on"
"of those flights show me all them I logged at night"
"of all those flights, show me all the ones I logged in aircraft NXXXXX".

Using an excel logbook is nice but I would wholeheartedly suggest a database driven logbook or similar over the excel. It does help in adding up the totals, but the whole idea of putting your logbook on the computer IMO is to make it easy to sort information.

I started out using an excel logbook and then quickly ran into its limits. play around with excel but keep an open mind to databases.
 
Wheelsup... you wouldn't want to... um... send me a copy of your Access Logbook would you? ;)

I used to know access up and down... but that was years ago... I recently got back into it and couldn't remember half of the statements to get what I wanted. I totally agree with you about Database format vs. spreadsheet format.

Any help would be appreciated!

Bob
 
A few weeks ago I posted a question on setting up a relational database with Access for a logbook. If you don't mind, Wheelsup, I'd like to see how you set up your tables and relationships so I can compare with what I have so far.
 
postgresql > mysql > access.

Raskolnikov, my design had tables for aircaft types, aircraft, and flight log.

The a/c type info on type designation, hp, complex, twin, turbine, etc. The aircraft table was just to define n numbers, assign a type and some other stuff i cant remember. The log was aircraft, total, night, xc, etc. The log didnt have type info/complex/multi/etc, since that was referenced through the a/c type table. there was more to my design that i cant remember off the top of my head and i never did finish it (lazy). my stuff was coded with postgres + php + ajax.
 
casey said:
postgresql > mysql > access.

Raskolnikov, my design had tables for aircaft types, aircraft, and flight log.

The a/c type info on type designation, hp, complex, twin, turbine, etc. The aircraft table was just to define n numbers, assign a type and some other stuff i cant remember. The log was aircraft, total, night, xc, etc. The log didnt have type info/complex/multi/etc, since that was referenced through the a/c type table. there was more to my design that i cant remember off the top of my head and i never did finish it (lazy). my stuff was coded with postgres + php + ajax.
Click to expand...

Thanks for the tip casey. I'm new to working with databases and access is what we use at work. The more I learn, the more it's becoming obvious that access is quite limited.
 
Captain_Bob said:
Wheelsup... you wouldn't want to... um... send me a copy of your Access Logbook would you? ;)

I used to know access up and down... but that was years ago... I recently got back into it and couldn't remember half of the statements to get what I wanted. I totally agree with you about Database format vs. spreadsheet format.

Any help would be appreciated!

Bob
Click to expand...

sorry it took so long to do this.

it's not the greatest but helped when I was filling out those applications on airlineapps asking all kinds of funky questions...(such as TT in each aircraft...etc.)

access logbook (zipped)

i haven't figured out how relational db's work (ie you put the aircraft type and it automatically knows its turbine, mel, etc.) so i just do it manually in this database.
 
what is the point if a electronic log book from exel, online logbook, etc? Is it easier to log time in than the paper logbook? why do we need it?
 
Fly777bigBIRD said:
what is the point if a electronic log book from exel, online logbook, etc? Is it easier to log time in than the paper logbook? why do we need it?
Click to expand...

It's called backup....

When you decide you need a backup, it will be too late.
 
Thanks for posting the logbook wheelsup. Yeah, you don't have a relational database going there since you only have one table. But it works. It does what you want it to. And that's the point in the end.

I won't go into EF Codd's rules for normalizing tables for relational databases... but if you had, for example, a table just for aircraft, you could "relate" that table (link it) to your main table. Then, once you select an N-number it would link up how many engines, or turbine, class, category...or whatever other info you had stored in that table about that aircraft.

And what you have there is easier to work with than excel because you can write queries, etc.

I'm still developing mine. Haven't had the time the past month or so because I've been busy with too many other things. Studying for my PPL mainly. This year, baby. This year!
 
Fly777bigBIRD said:
what is the point if a electronic log book from exel, online logbook, etc? Is it easier to log time in than the paper logbook? why do we need it?
Click to expand...

Good question. Download Logbook Pro www.logbookpro.com for the free trial version and you'll know. You can quickly lookup how many ME hours/night/actual IFR time you have. Or, you could query your database for the number of hours you have in a certain aircraft by N-number... Or you could quickly lookup how many multi duel given hours you have. etc.
 
You must log in or register to reply here.
Back
Top