Go Back  PPRuNe Forums > Non-Airline Forums > Private Flying
Reload this Page >

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

Private Flying LAA/BMAA/BGA/BPA The sheer pleasure of flight.

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

Old 8th Dec 2019, 10:54
  #1 (permalink)  
Thread Starter
 
Join Date: May 2019
Location: Cambridgeshire
Posts: 15
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.




blessing786 is offline  
Old 8th Dec 2019, 16:06
  #2 (permalink)  
 
Join Date: Jan 2008
Location: UK
Posts: 1,459
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'.
cats_five is offline  
Old 8th Dec 2019, 18:46
  #3 (permalink)  
 
Join Date: Oct 2007
Location: Moray,Scotland,U.K.
Posts: 1,694
Even simpler is to use decimals of an hour.
Maoraigh1 is offline  
Old 8th Dec 2019, 20:34
  #4 (permalink)  
 
Join Date: Feb 2000
Location: UK
Posts: 14,004
Originally Posted by Maoraigh1 View Post
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
Genghis the Engineer is offline  
Old 9th Dec 2019, 07:31
  #5 (permalink)  
 
Join Date: Dec 2010
Location: Sheffield
Posts: 110
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.

BobD is offline  
Old 9th Dec 2019, 08:37
  #6 (permalink)  
 
Join Date: Oct 2007
Location: Here
Posts: 1,842
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.
Sam Rutherford is offline  
Old 9th Dec 2019, 09:14
  #7 (permalink)  
 
Join Date: Aug 2019
Location: Albury
Posts: 2
There is "EXCEl pilot log book".. about $50 has all the bells and whistles, New Zealander who worte it, but for Australian record keeping.
OzCountryFlyer is offline  
Old 9th Dec 2019, 20:50
  #8 (permalink)  
Thread Starter
 
Join Date: May 2019
Location: Cambridgeshire
Posts: 15
Thanks people, I will give a crack at making my own and looking at the suggestions you have posted.
blessing786 is offline  
Old 10th Dec 2019, 07:40
  #9 (permalink)  
 
Join Date: Jan 2008
Location: UK
Posts: 1,459
Think about how to use sheets within the workbook. For example you could use a sheet to duplicate a page in your paper logbook.
cats_five is offline  
Old 18th Dec 2019, 18:11
  #10 (permalink)  
 
Join Date: Oct 2009
Location: Right here, right now
Posts: 265
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.
MFC_Fly is offline  
Old 19th Dec 2019, 06:04
  #11 (permalink)  
 
Join Date: Jun 2003
Location: LFBZ (for a while)
Posts: 740
I had a fairly complex Excel spreadsheet for a long time, but I recently switched to myflightbook.com. Seems very adequate so far.
n5296s is offline  
Old 5th May 2022, 07:47
  #12 (permalink)  
 
Join Date: Oct 2016
Location: Gusting49
Posts: 31
Any idea how to write the formula for night hours?
PapaEchoIndia is offline  
Old 5th May 2022, 10:01
  #13 (permalink)  
 
Join Date: Mar 2018
Location: Bournemouth
Posts: 22
Hi

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

hope that helps.
Mike
sealo0 is offline  
Old 5th May 2022, 22:25
  #14 (permalink)  
 
Join Date: Nov 2004
Location: UK
Posts: 447
Originally Posted by PapaEchoIndia View Post
Any idea how to write the formula for night hours?
Yes, but I'm going to keep you in the dark.
pilotmike is offline  
Old 5th May 2022, 23:16
  #15 (permalink)  
 
Join Date: Nov 2005
Location: Temporarily Unsure!
Posts: 246
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.
rarelyathome is offline  
Old 23rd May 2022, 06:08
  #16 (permalink)  
 
Join Date: May 2022
Location: Belgium
Posts: 3
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
barefootpilot is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

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