ATPL & Excel logbook question

[AV8R]

Can you have "yearly" totals in an excel logbook to send to TC for your ATPL?

Or would it be more excepted to use monthly totals on each line? Just don't want to spend 100 hours typing it up.

[AuxBatOn]

I assume they want something in accordance with their regs...

401.08

(1) Every applicant for, and every holder of, a flight crew permit, licence or rating shall maintain a personal log in accordance with subsection (2) and with the personnel licensing standards for the documentation of

....(a) experience acquired in respect of the issuance of the flight crew permit, licence or rating; and
(amended 2001/03/01; previous version)

....(b) recency.

(2) A personal log that is maintained for the purposes referred to in paragraphs (1)(a) and (b) shall contain the holder's name and the following information in respect of each flight:

....(a) the date of the flight;

....(b) the type of aircraft and its registration mark;

....(c) the flight crew position in which the holder acted;

....(d) the flight conditions with respect to day, night, VFR and IFR;

....(e) in the case of a flight in a aeroplane or helicopter, the place of departure and the place of arrival;

....(f) in the case of a flight in an aeroplane, all of the intermediate take-offs and landings;

....(g) the flight time;

....(h) in the case of a flight in a glider, the method of launch used for the flight; and

....(i) in the case of a flight in a balloon, the method of inflation used for the flight.

(3) No person shall make an entry in a personal log unless the person

....(a) is the holder of the log; or

....(b) has been authorized to make the entry by the holder of the log.

[Snowgoose]

=sumif("range of dates of flights",month you want,"range of flight time entries")

it's all in the help menu. Sumif,countif,vlookup,hlookup,match and index. With these funtions you can make your excel spreadsheet do anything.

It's shouldn't take 100 hours. More like 20 minutes.

[AV8R]

thanks

[kevinsky18]

I'm curious, is the Excel log book the only log book your submitting? Or do you have a standard log book as well and you're just adding in an excel spreadsheet to double confirm your number counts.

[AV8R]

I have standard logbooks; I would only submit the excel logbook as I heard you can.

[sakism]

I'm curious, is the Excel log book the only log book your submitting? Or do you have a standard log book as well and you're just adding in an excel spreadsheet to double confirm your number counts.

I only have an Excel logbook - haven't used a paper one in 6 years. Submitted a print out of it for my ATPL and had it signed off in less than 24 hours.