PPRuNe Forums

PPRuNe Forums (https://www.pprune.org/)
-   Private Flying (https://www.pprune.org/private-flying-63/)
-   -   Does anyone have Excel Logbook that they can share with me? (https://www.pprune.org/private-flying/627836-does-anyone-have-excel-logbook-they-can-share-me.html)

blessing786 8th Dec 2019 10:54

Does anyone have Excel Logbook that they can share with me?
 
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.
https://cimg2.ibsrv.net/gimg/pprune....4b2484c105.jpg
https://cimg3.ibsrv.net/gimg/pprune....a833aeeb99.jpg



cats_five 8th Dec 2019 16:06

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 8th Dec 2019 18:46

Even simpler is to use decimals of an hour.

Genghis the Engineer 8th Dec 2019 20:34


Originally Posted by Maoraigh1 (Post 10635064)
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 9th Dec 2019 07:31

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 9th Dec 2019 08:37

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 9th Dec 2019 09:14

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 9th Dec 2019 20:50

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

cats_five 10th Dec 2019 07:40

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 18th Dec 2019 18:11

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 19th Dec 2019 06:04

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

PapaEchoIndia 5th May 2022 07:47

Any idea how to write the formula for night hours?

sealo0 5th May 2022 10:01

Hi

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

hope that helps.
Mike

pilotmike 5th May 2022 22:25


Originally Posted by PapaEchoIndia (Post 11225339)
Any idea how to write the formula for night hours?

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

rarelyathome 5th May 2022 23:16

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 23rd May 2022 06:08

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


All times are GMT. The time now is 01:55.


Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.