Free digital logbook and duty times program - UPDATED
Join Date: May 2003
Location: Far Away
Posts: 20
Likes: 0
Received 0 Likes
on
0 Posts
Thanks Uber
Can you tell me what format to use for time. It accepts whole hours, but when I try to add minutes is won't accept them. Can you also give me you protection pass word as some of the colums are to narrow and I cannot read them clearly.
Cheers
Can you tell me what format to use for time. It accepts whole hours, but when I try to add minutes is won't accept them. Can you also give me you protection pass word as some of the colums are to narrow and I cannot read them clearly.
Cheers
Thread Starter
As stated in the first post, the worksheet password is 'pprune'
You'll have to change the format for time yourself, not sure what to. I've always used decimal based entries in my logbook. I'm sure you could convert it to minutes etc by select the cells and pressing Control - 1 to format them.
good luck
You'll have to change the format for time yourself, not sure what to. I've always used decimal based entries in my logbook. I'm sure you could convert it to minutes etc by select the cells and pressing Control - 1 to format them.
good luck
Thread Starter
might, thought the formatting would be a little whack.
As I was discussing with someone in a PM, as you have to manually enter your total flight time per day on teh duty sheet, I have found a way to automatically calculate this by changing the G4 cell to this formula and changing the logbook B column to date format.
=SUM((OFFSET((INDIRECT(ADDRESS(MATCH(B561,Logbook!B:B,0),12, 1,TRUE,"Logbook"))),0,0,(COUNTIF(Logbook!B:B,B4)),10)))
However, it adds considerably to calculation time so unless you're running a rather top end computer, i'd leave it to manual entry.
As I was discussing with someone in a PM, as you have to manually enter your total flight time per day on teh duty sheet, I have found a way to automatically calculate this by changing the G4 cell to this formula and changing the logbook B column to date format.
=SUM((OFFSET((INDIRECT(ADDRESS(MATCH(B561,Logbook!B:B,0),12, 1,TRUE,"Logbook"))),0,0,(COUNTIF(Logbook!B:B,B4)),10)))
However, it adds considerably to calculation time so unless you're running a rather top end computer, i'd leave it to manual entry.
Join Date: Feb 2000
Location: Third Barstool on the left
Posts: 449
Likes: 0
Received 0 Likes
on
0 Posts
Las
That assumes you do roughly the same duty every day - if you are close to 90 and at, say, 12 days, another big one will push you over.
I took the (gender-neutral) Super-Soldier's spreadsheet (nice work, DUS) and re-worked the formula to give myself a "reset" of the cumulative duty times every 15th day.
If you employer needs the flexibility of the "true" interpretation of CAO 48 and you are doing something else, questions will be asked.
Also, employees should be mindful that their Ops Manual will describe a FDT system and many operations have their own systems, exemptions, etc. Be careful that you're not putting your employer/CP in a difficult position when CASA next do an audit!
I took the (gender-neutral) Super-Soldier's spreadsheet (nice work, DUS) and re-worked the formula to give myself a "reset" of the cumulative duty times every 15th day.
If you employer needs the flexibility of the "true" interpretation of CAO 48 and you are doing something else, questions will be asked.
Also, employees should be mindful that their Ops Manual will describe a FDT system and many operations have their own systems, exemptions, etc. Be careful that you're not putting your employer/CP in a difficult position when CASA next do an audit!
Nice Work DUS, certainly better than my efforts at producing such software over the years.
One suggestion though for the next version, include say 7 columns for the flight description so for a flight from ML-SY-BN-DN you enter in cell F YMML cell G YSSY cell H YBBN cell I YPDN etc.
Then you can tally up 1. your total landings and 2. the number of times you have landed at a particular aerodrome.
Not a groundbreaking piece of information, but seeing you have the data you may as well have access to it.
Thanks again
CS
One suggestion though for the next version, include say 7 columns for the flight description so for a flight from ML-SY-BN-DN you enter in cell F YMML cell G YSSY cell H YBBN cell I YPDN etc.
Then you can tally up 1. your total landings and 2. the number of times you have landed at a particular aerodrome.
Not a groundbreaking piece of information, but seeing you have the data you may as well have access to it.
Thanks again
CS
Join Date: Apr 2007
Location: Cairns
Posts: 181
Likes: 0
Received 0 Likes
on
0 Posts
I am far from current on Excel , how do I add MultiEngine CoPilot. I am up to putting the backlog in and have come to this. I have the password , however the traits of excel pass me by.
Thread Starter
thanks mig3.
Myshoutcaptain. Its going to be a fairly involved process im afraid. you'll have to add the columns in the logbook page, then adjust the logbook summary page to reflect the new data etc. Bit of reading might be in order.
Myshoutcaptain. Its going to be a fairly involved process im afraid. you'll have to add the columns in the logbook page, then adjust the logbook summary page to reflect the new data etc. Bit of reading might be in order.
Thread Starter
New version released poeples, lots of fixes and feature additions. Please refer the first post of this thread to see the new additions and find a download link.
Thanks to all who provided suggestions and pointed out bugs in the first version
Thanks to all who provided suggestions and pointed out bugs in the first version
Join Date: May 2008
Location: australia
Posts: 1
Likes: 0
Received 0 Likes
on
0 Posts
Appreciated
Hi, thanks for thinking of us but tried down load and appears the file is corrupted as several graphs fail to respond to log book input and one has overlaid word on bottom of graph?
Any chance of getting working copy
much appreciated
Any chance of getting working copy
much appreciated
Join Date: Jul 2011
Location: Oz
Posts: 1
Likes: 0
Received 0 Likes
on
0 Posts
Hello all,
Long time reader, first time poster.
I'm sure i am missing something here as when i click on the download link it takes me to a rapidshare site that lists the file but seems to want a subscription.
Do i need to subscribe to be able to download this flight and duty calculator through rapidshare?
Thanks in advance.
Cheers
Long time reader, first time poster.
I'm sure i am missing something here as when i click on the download link it takes me to a rapidshare site that lists the file but seems to want a subscription.
Do i need to subscribe to be able to download this flight and duty calculator through rapidshare?
Thanks in advance.
Cheers
Join Date: Mar 2011
Location: East
Posts: 186
Likes: 0
Received 0 Likes
on
0 Posts
Heliplease in the bottom right of the rapid share page you should see 'FREE-DOWNLOAD'
Click that, close the subscribe window that pops up, wait a few more seconds and then it changes to the download link.
It is an awesome piece of work.
Thats for all the effort involved in creating this
Click that, close the subscribe window that pops up, wait a few more seconds and then it changes to the download link.
It is an awesome piece of work.
Thats for all the effort involved in creating this
Join Date: Aug 1998
Location: ...second left, past the lights.
Posts: 1,101
Likes: 0
Received 1 Like
on
1 Post
Join Date: Jun 2011
Location: Next door to the wrong neighbours
Posts: 243
Received 0 Likes
on
0 Posts
Everyone is full of praise for your work and generosity dAS and I thank you in advance, but when I click on the link to MegaUpload I do not understand what I am looking at or where to download it. Anyone care to educate me please?
Edit: As you were. I worked it out after all. For others a bit challenged like me, just click on 'Regular Download'.
Many thanks dAS.
Edit: As you were. I worked it out after all. For others a bit challenged like me, just click on 'Regular Download'.
Many thanks dAS.
Last edited by truthinbeer; 21st Jul 2011 at 03:03. Reason: I figured it out after all.