Free digital logbook and duty times program - UPDATED
Thread Starter
Free digital logbook and duty times program - UPDATED
Hi,
People are always asking me for a copy of my logbook and flight times calculator for excel so i've decided to rewrite it and make it available for anyone who is interested free of charge. Compared to every other one i've seen its quite complex and detailed so I hope it provides others with as much benefit it has me.
Basic features:
- A standard logbook
- A duty times calculator
- Maintains your currency and recency for night, IFR and all approaches.
- Keeps detailed statistical records, eg flying in last 7 days, month, year etc.
- Dynamic charts with user selection negating the need to ever manually edit a formula again.
- Logbook summary page that breaks down all your hours by a/c type & configuration. Day/night, command/dual, IF time etc. Keeps track of time to IFR and medical renewals. Very useful for filling out job applications.
- Conducts predictive analysis on your logbook to give you projected totals for things like 500 multi, 100 night, etc.
- Charts time in each callsign, and breaks down how much you've flown with other people.
Once you've input the backlog of your data, day to day inputs are quite limited. The sheet gets all its calculation data from you inputting your duty start and end times, flight time and then your normal log book entry. It really doesn't take long at all.
Click here to download it.
Note: There is already some data in the sheet to serve as an illustrative example, just delete it and replace it with your own data.
Note: For those who know how to use Excel already, the worksheets are protected, to remove that protection for editing, the password is 'pprune'
UPDATE 18/8/2008.
This is an entirely new version of the software, v3.0. It incorporates many new features and has several major bugfixes. A general list;
- Approach recency fixed, 90 days VOR,NDB etc, 35 ILS.
- IFR recency fixed, specific calculation of I.F time on ground and inflight
- Duty times now adhere to a fixed 2 week period. User input allows you to designate what day is the nominated beginning of this period.
- Multi pilot copilot added
- User changeable times for the projected totals. Find out what date you're going to achieve various goals, useful for ATPL etc.
- More conditional formatting to help you identify when you're close to duty and flight time limits re CAO 48.1.
- General tidying up and graphical fixes.
- User tooltips pop up to help you with filling out various fields.
It should be very easy to copy your existing data into this sheet, so happy logging Its much easier to use now.
People are always asking me for a copy of my logbook and flight times calculator for excel so i've decided to rewrite it and make it available for anyone who is interested free of charge. Compared to every other one i've seen its quite complex and detailed so I hope it provides others with as much benefit it has me.
Basic features:
- A standard logbook
- A duty times calculator
- Maintains your currency and recency for night, IFR and all approaches.
- Keeps detailed statistical records, eg flying in last 7 days, month, year etc.
- Dynamic charts with user selection negating the need to ever manually edit a formula again.
- Logbook summary page that breaks down all your hours by a/c type & configuration. Day/night, command/dual, IF time etc. Keeps track of time to IFR and medical renewals. Very useful for filling out job applications.
- Conducts predictive analysis on your logbook to give you projected totals for things like 500 multi, 100 night, etc.
- Charts time in each callsign, and breaks down how much you've flown with other people.
Once you've input the backlog of your data, day to day inputs are quite limited. The sheet gets all its calculation data from you inputting your duty start and end times, flight time and then your normal log book entry. It really doesn't take long at all.
Click here to download it.
Note: There is already some data in the sheet to serve as an illustrative example, just delete it and replace it with your own data.
Note: For those who know how to use Excel already, the worksheets are protected, to remove that protection for editing, the password is 'pprune'
UPDATE 18/8/2008.
This is an entirely new version of the software, v3.0. It incorporates many new features and has several major bugfixes. A general list;
- Approach recency fixed, 90 days VOR,NDB etc, 35 ILS.
- IFR recency fixed, specific calculation of I.F time on ground and inflight
- Duty times now adhere to a fixed 2 week period. User input allows you to designate what day is the nominated beginning of this period.
- Multi pilot copilot added
- User changeable times for the projected totals. Find out what date you're going to achieve various goals, useful for ATPL etc.
- More conditional formatting to help you identify when you're close to duty and flight time limits re CAO 48.1.
- General tidying up and graphical fixes.
- User tooltips pop up to help you with filling out various fields.
It should be very easy to copy your existing data into this sheet, so happy logging Its much easier to use now.
Last edited by das Uber Soldat; 18th Aug 2008 at 13:03.
That is absolutely awesome mate!!!
Thank you so much for your efforts and making it available to everyone.
Sorry I'm not familiar with Excel. How do you remove the protection with the password?? I would like to add some new column titles in the logbook page when I get it all setup.
Do I need to "program" it so it will then add those totals to the summary pages etc???
Thanks for your help.
Thank you so much for your efforts and making it available to everyone.
Sorry I'm not familiar with Excel. How do you remove the protection with the password?? I would like to add some new column titles in the logbook page when I get it all setup.
Do I need to "program" it so it will then add those totals to the summary pages etc???
Thanks for your help.
Thread Starter
Just worked for me then, that said i'll upload it to a couple of other places to provide more options.
edit: Extra download source added to original post.
edit: Extra download source added to original post.
Guest
Posts: n/a
question
Hey uber, thanks for that! Here's one I've been using, the logbook page is quite similar, your graphs and stuff seem a lot cooler!
4shared.com - online file sharing and storage - download E170 Logbook 2002 Duties V3 7.xls
When I tried to copy my numbers into the description and PIC columns of your sheet though, I get duplication in columns E/F and H/I, for some reason there are two columns for one piece of info. Any particular reason, any idea how I can avoid that?
4shared.com - online file sharing and storage - download E170 Logbook 2002 Duties V3 7.xls
When I tried to copy my numbers into the description and PIC columns of your sheet though, I get duplication in columns E/F and H/I, for some reason there are two columns for one piece of info. Any particular reason, any idea how I can avoid that?
Thread Starter
PLankbender. I had a look at the sheet you are using, i'm sorry but I cant make head or tails of that.
If you paste in details and you get splitting columns like you say, you need to manually highlight the columns and hit the merge column button (after unprotecting the worksheet.. tools --> Protection --> Unprotect worksheet, enter password pprune).
I've experienced this when i've tried to paste in data in multi column groups. I've found if I paste in the names from JUST the 1 column, ie PIC, then I dont get that problem.
Good luck.
If you paste in details and you get splitting columns like you say, you need to manually highlight the columns and hit the merge column button (after unprotecting the worksheet.. tools --> Protection --> Unprotect worksheet, enter password pprune).
I've experienced this when i've tried to paste in data in multi column groups. I've found if I paste in the names from JUST the 1 column, ie PIC, then I dont get that problem.
Good luck.
Moderator
We'll stickie this thread for a few days as the Log Book program may be very useful to pilots.
PPRuNe is not associated with the Log Book in any way and accepts no responsibility for the program accuracy or whether it is acceptable to CASA.
PPRuNe is not associated with the Log Book in any way and accepts no responsibility for the program accuracy or whether it is acceptable to CASA.
Guest
Posts: n/a
The other sheet
I had a look at the sheet you are using, i'm sorry but I cant make head or tails of that.
For more customized summarization, use the "Specialist/Instructor" columns. I add up Cross Country PIC/Instrument and Low Level times, for example, by simply duplicating the time entered on that line in one of the three columns, they are then automatically added up on the summary page.
P.S.: It's "der Soldat" not "das Soldat", and "Ueber" or U-Umlaut (the U with the two dots", not "Uber". PB aka smartare
Last edited by PlankBlender; 27th Jun 2008 at 06:55. Reason: PS
Moderator
Google tells me it is: das Uber Soldat
Besides, I guess he/she knows his own PPRuNe name?
Interestingly, when I Googled "das Uber Soldat" this thread came up!!
Besides, I guess he/she knows his own PPRuNe name?
Interestingly, when I Googled "das Uber Soldat" this thread came up!!
Interestingly, when I Googled "das Uber Soldat" this thread came up!!
Excellent work and thanks for sharing