Does anyone have Excel Logbook that they can share with me?

[blessing786]

Hi All,

Does anyone have an Excel Logbook they can share with me? I just started my PPL and logging it on the Pooleys hardcopy but would like an electronic backup to do calculations. Not after anything fancy but exactly how the Pooleys laid out just with auto calculations on hours, landings etc.

I have found Logbook.aero to be closest to what I am after although their Facebook page has not been updated since 2018 so unsure if I buy a licence and then it goes bust in the future, I know they have the function to download data as you go and back it up to Dropbox and Google Drive. It would be more reassuring to know I have an excel backup stored locally or on a cloud.

Sorry if I have posted this thread in the wrong section but I am doing PPL H so I thought Rotorheads was the best place to start.

[cats_five]

It's simple to do your own, just make sure to use the correct formula where you are totalling the hours so that 25 hours is 25 hours, not a day and an hour. You need '[hh]:mm'.

[Maoraigh1]

Even simpler is to use decimals of an hour.

[Genghis the Engineer]

Originally Posted by Maoraigh1

Even simpler is to use decimals of an hour.

I log to the nearest minute (because I'm anal) working to three decimal places of an hour accomodates that fine. It's easy to accomodate whatever you want in Excel with some basic skills.

G

[BobD]

You could use this free program.
https://www.flylogio.com/pilot-logbook
Apart from an annoying nag to buy the upgraded version, the free program meets my needs for an electronic backup of my logbook, and it has some built in useful reports & analysis of your hours.

[Sam Rutherford]

I have an excel sheet, that I made myself.

Covers, totals (and separates) fixed wing and rotary hours, actual, sim, dual etc. You'll have to make some rearrangement to fit Pooleys I expect.

Simple but works - send me an email if you'd like a copy. sam AT prepare 2 go dot com

Or, as others have suggested, build your own.

Cheers, Sam.

[OzCountryFlyer]

There is "EXCEl pilot log book".. about $50 has all the bells and whistles, New Zealander who worte it, but for Australian record keeping.

[blessing786]

Thanks people, I will give a crack at making my own and looking at the suggestions you have posted.

[cats_five]

Think about how to use sheets within the workbook. For example you could use a sheet to duplicate a page in your paper logbook.

[MFC_Fly]

If you know Excel then creating the 'log book' is a pretty simple task. The pain comes when you have to enter all your previously accumulated hours.

[n5296s]

I had a fairly complex Excel spreadsheet for a long time, but I recently switched to myflightbook.com. Seems very adequate so far.

[PapaEchoIndia]

Any idea how to write the formula for night hours?

[sealo0]

Hi

MrExcel.com has an excellent message board (forum) all questions answered very quickly.

hope that helps.
Mike

[pilotmike]

Originally Posted by PapaEchoIndia

Any idea how to write the formula for night hours?

Yes, but I'm going to keep you in the dark.

[rarelyathome]

Logbook.aero is very good and has been around for many years. Responses to queries from the developer are really helpful. I wouldn’t worry about longevity.

[barefootpilot]

Hi there if you want I can send you a good logbook but it is on google sheet, not on excel.
If you are interested just send me a message