Go Back  Airline Pilot Central Forums > Career Builder > Military
Excel spreadsheet for logbook? >

Excel spreadsheet for logbook?

Search

Notices
Military Military Aviation

Excel spreadsheet for logbook?

Thread Tools
 
Search this Thread
 
Old 12-05-2006, 04:45 PM
  #1  
Line Holder
Thread Starter
 
Joined APC: Mar 2006
Position: Herk
Posts: 47
Default Excel spreadsheet for logbook?

I am a guard guy about to leave for UPT. I have heard through the grapevine that it may be wise to convert you AF printouts to electronic logbook every month or so. If this is the truth, does anyone have a excel program they would not mind sharing?
duece123 is offline  
Old 12-05-2006, 05:04 PM
  #2  
Chief Jeppesen Updater
 
FlyerJosh's Avatar
 
Joined APC: Oct 2005
Position: Executive Transport Driver
Posts: 3,080
Default

PM me with your email and I can send you a copy of the excel sheet I use...
FlyerJosh is offline  
Old 12-05-2006, 08:31 PM
  #3  
China Visa Applicant
 
Joined APC: Oct 2006
Position: Midfield downwind
Posts: 1,928
Default

Originally Posted by duece123
I am a guard guy about to leave for UPT. I have heard through the grapevine that it may be wise to convert you AF printouts to electronic logbook every month or so. If this is the truth, does anyone have a excel program they would not mind sharing?
The AF will not keep a detailed log of your SUPT sorties in your AFORMS record -- it will all end up as a single line item of "student" time in your flight records. It won't include any breakouts for actual instrument time or cross-country time.

If it's important to you to remember tail numbers you flew, IPs you flew with, or need to add X-C or instrument time to your logbook, it's worth keeping your own record of the sortie details.

I originally kept a paper long through SUPT and follow on training, but based on some poop I got from a guy in my squadron who retired (and said that all the airlines would care about was my AFORMS printout), I stopped keeping my own log. A year or so ago I converted to Excel and consolidated all my military and civil time...it was a b*tch to go back and reconstruct the time from AFORMS and many other sources.

The reason I changed my mind on keeping my own log was doing a thorough AFORMS record scrub and finding several -- several -- errors in the "official" record.

Here's the format I used. I still use this logbook and quarterly bounce it against the AFORMS print out.

Hacker15e is offline  
Old 12-06-2006, 06:26 AM
  #4  
Line Holder
Thread Starter
 
Joined APC: Mar 2006
Position: Herk
Posts: 47
Default

for some reason I cant PM anyone. So Flyerjosh, if you could send it to bradljr@yahoo. com, it would be much appreciated.
duece123 is offline  
Old 12-06-2006, 08:20 AM
  #5  
Line Holder
 
MayFly135s's Avatar
 
Joined APC: Oct 2006
Position: B747 FO
Posts: 61
Default

I couldn't agree with Hacker more...you'd be surprised how many sorties go missing in the paperless AF and ARMs! As a tanker driver making the transition to Mr (S), I wish I had kept my own expanded log book with additional info (PIC, SIC, # of landings, approaches, etc). Definitely just use something...
MayFly135s is offline  
Old 12-06-2006, 10:18 AM
  #6  
Line Holder
Thread Starter
 
Joined APC: Mar 2006
Position: Herk
Posts: 47
Default

thanks for the replys. I know i am still a youngster/wanna be, but I figure it is always good to be ahead of the game.
duece123 is offline  
Old 12-06-2006, 01:19 PM
  #7  
China Visa Applicant
 
Joined APC: Oct 2006
Position: Midfield downwind
Posts: 1,928
Default

Originally Posted by duece123
thanks for the replys. I know i am still a youngster/wanna be, but I figure it is always good to be ahead of the game.
Never too early to start.

The big picture with SUPT time is that 200 hours of "student" jet time really doesn't mean anything. The airlines don't really consider it when you are applying for a job, and as mentioned the AF only lumps it into your "total time" summary.

Most active duty military guys -- fighter or heavy -- will get enough time during their ADSC to meet the mins at the majors without having to count any SUPT time. It's possible that reserve bubbas might have to nut-cut every little hour, depending on when they wanna apply.

For me, keeping the personal logbook allows me to look back on specific sorties during my career and recall details that are lost in the AFORMS tacking system (in addition to fact checking the AFORMS stuff, as mentioned earlier). It is interesting to look back at who I flew with and what I did during UPT...
Hacker15e is offline  
Old 12-07-2006, 09:57 PM
  #8  
New Hire
 
Joined APC: Sep 2006
Posts: 4
Default

FlyerJosh, I am in the same situation as duece123, any chance you can send the sheet to [email protected].

Thanks
ejoachim is offline  
Old 12-08-2006, 07:15 AM
  #9  
Line Holder
Thread Starter
 
Joined APC: Mar 2006
Position: Herk
Posts: 47
Default

yeah I know that my UPT time will not be worth crap, but what the hell. Like you, I want to remeber who I flew with and what I was doing (messing up more than likely) at the time. I would assume that you can count your solo time as PIC, seeing that you are the only person in the plane?
duece123 is offline  
Old 12-08-2006, 05:28 PM
  #10  
Gets Weekends Off
 
Joined APC: Oct 2005
Posts: 900
Default

Yes, solo time can be counted towards PIC. UPT time is not necessarily worth "crap", since it is actual turbine/multi-engine time. Most, if not all companies require a certain amount of turbine and/or multiengine time and your UPT time will count.
TankerDriver is offline  
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Pilot41
Hangar Talk
3
07-27-2006 09:32 AM
ultradrvr
Corporate
0
06-22-2006 06:39 PM

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 On
Pingbacks are On
Refbacks are On



Your Privacy Choices