hey everyone,

I'm looking for a good computer logbook, one that has lots of features and is geared towards Canadian licensing and rules. I saw one (I think it was posted on AVCANADA a while back) that documents they places you have visited and allows you to save pictures of those destinations with the logbook so you can have a picture scrap book of sorts with all your times etc. this is the one I'm looking for. if anybody knows it or can recomend a good one, let me know.

Thanks

http://www.forpilots.com/logbook/


this is a not a bad one if you don't want to spend alot

I currently use Log Book Pro - Good but FAA regs, a good Cnd one would be good.

Hello,

While I haven't gotten around to it (and probably won't anytime soon due to other projects) it would be quite feasible to implement the duty hour rules on an Excel spreadsheet. (I don't mind helping out though.)

Learn to use the date formats and Excel date serial number and you'll be in business.

Another, somewhat different possibility would be to set something up with a server-side script like ASP, but that's more difficult to implement and requires a bit more infrastructure.

Goodbye,

Louis

Yeah but I am lazy, someone lese should do it for me

I've been using this one for a while, it's pretty complete and it's Canadian.

http://www.JFOsoftware.com

I've got an Excel workbook set up that keeps track of your total time, etc. (in the same format as a paper book) plus columns to keep track of little things like turbine hours, seaplane time, etc. and customizable columns if you want to keep track of anything else in particular.

With a bit of programming (I will get around to it) it will give total time on type for each type of a/c you fly. It also keeps track of hours over the past x days - 30, 90, 365 etc. It's pretty neat, but then I did make it so I am a bit biased.

I spent many, many hours creating it because I was too cheap to buy a copy and never really thought others may be interested in "reimbursing" me for some of my time. Anyone interested in a copy? Make me an offer... 25 hours multi time? ha ha just kidding. I'll accept trinkets, non-perishable food, spare change... I *am* a pilot after all... spare change helps.

Still-in-YXL,

Would you mind showing me the last x days formula you used?

As for time on type, I could send you a copy of my own Excel logbook (PM me your e-mail) if you want to take a look, its basically a matter of using Sum.IFs checking the type column and adding the different hours columns.

I also have some bits of VBA that sort out and list: what airports you visited, what registrations appear and how many entries for each (I use AutoFilter with subtotals on another sheet to get hour per machine) as well as every person listed in the logbook.

Goodbye,

Louis

I've been workin away at tryin to get excel to calculate the last 360, 180, 90, 30 etc with no luck

As far as I could get it was =SUMIF(Logbook!B:B,">= (TODAY()-365)",Logbook!G:H) but for some reason it does'nt return a number (where Column B is the date of flight and G and H are flight times

Any Excel experts?

D5

You need to use an array formula. After you enter your formula hit CTRL+SHIFT+ENTER it will put curly braces around your formula and it should work.

Hmm, tried that and it still does'nt want to work, can I send you a copy of my work in progress so you can see for yourself? Thanks for the help so far.

D5

D5GRVTY,

Try replacing ">= (TODAY()-365)" by ">=" & (TODAY()-365)
I had the same problem while trying this a few minutes ago, and it turns out Excel has a tendency to turn these criteria into text strings...

Hiflyer, unless I missed something, my formula worked fine without using an array formula. Isn't by its very nature SUMIF made to handle value arrays?

Goodbye,

Louis

I think the SUMIF is supposed to handle the arrays but for some reason it didn't work for me so I used the array formulas with sum and if statements separately. The application that I actually used this in is finding my yearly totals. A2 is the year and the Hours.... are my logbook entries. This formula is on a different page from the rest of my logbook entries.

=SUM(IF(Hours!$A$6:$A$3001<=DATEVALUE("31/12/"&A2),Hours!$M$6:$V$3001,0))-SUM(IF(Hours!$A$6:$A$3001<DATEVALUE("1/1/"&A2),Hours!$M$6:$V$3001,0))

Hiflyer

Ah, that clears it up, functions not necessarily meant to handle cell ranges from the get go like require the array formula as you used it.

Perhaps you could have done something with a SUMIF evaluating whether the date was higher or equal to January 1st of a given year, and lower than January first of the next as well. Something like AND(">=" & 2005-01-01,"<" & 2006-01-01) might work. It would be shorter for sure, and perhaps a bit quicker to calculate if speed is an issue. (I am doing this off the top of my head, so syntax might not be totally correct.)

Louis

I had tried the other way with the sumif and AND statements but they didn't work. The formula that I posted was one that I found on an excel help website and it worked so I went with it.