Go Back  PPRuNe Forums > Aircrew Forums > Rotorheads
Reload this Page >

Component Time Spreadsheet

Rotorheads A haven for helicopter professionals to discuss the things that affect them

Component Time Spreadsheet

Old 28th Nov 2012, 05:52
  #1 (permalink)  
Thread Starter
 
Join Date: May 2011
Location: Boise
Age: 53
Posts: 10
Likes: 0
Received 0 Likes on 0 Posts
Component Time Spreadsheet

Hi guys, anyone have a simple program for tracking times? I know nothing about excel or I'd try to make one.... I wish there was an app:-) any help would be appreciated ! joe
joecub is offline  
Old 28th Nov 2012, 08:44
  #2 (permalink)  
 
Join Date: Jul 2004
Location: Home
Posts: 794
Received 0 Likes on 0 Posts
Grab yourself a college student, he will have finished it in no time.

Last edited by GoodGrief; 28th Nov 2012 at 10:01.
GoodGrief is offline  
Old 28th Nov 2012, 11:25
  #3 (permalink)  
 
Join Date: Jun 2006
Location: In the air with luck
Posts: 1,015
Received 0 Likes on 0 Posts
Could get locked up for that
500e is offline  
Old 28th Nov 2012, 11:31
  #4 (permalink)  
 
Join Date: Jul 2004
Location: Home
Posts: 794
Received 0 Likes on 0 Posts
...------
GoodGrief is offline  
Old 28th Nov 2012, 19:29
  #5 (permalink)  
 
Join Date: Jul 2010
Location: New Zealand
Posts: 23
Likes: 0
Received 0 Likes on 0 Posts
Hi Joe, PM me with your details...I think I can help.
Kiwi500 is offline  
Old 18th Feb 2016, 12:50
  #6 (permalink)  
 
Join Date: Jun 2015
Location: Brazil
Posts: 1
Likes: 0
Received 0 Likes on 0 Posts
I am trying to make a spreadsheet for one H130 T2, need help!

Originally Posted by Kiwi500 View Post
Hi Joe, PM me with your details...I think I can help.
Can you guys help me too ? I really appreciate! Thank you!
Joao_Acetrix is offline  
Old 19th Feb 2016, 07:59
  #7 (permalink)  
 
Join Date: Apr 2003
Location: U.K./nigeria
Posts: 113
Likes: 0
Received 0 Likes on 0 Posts
I've got a maintenance forecast that incorporates SLL items that I put on an Excel spreadsheet, I just put in the daily totals and it updates itself, I don't know anything about Excel either, but I haveit in hours and minute not decimal time, I have a problem I cant solve about times above 9999:59 hours, and I haven't managed coloured warnings yet either. Actually for something like this it isn't very difficult.
What aircraft is it that you want it for?
bluesafari is offline  
Old 19th Feb 2016, 18:06
  #8 (permalink)  
 
Join Date: Jun 2010
Location: Germany
Posts: 99
Likes: 0
Received 0 Likes on 0 Posts
Well, I don't know anything about component times (as I'm just a dumb pilot), but I do know a little bit on Excel.

So, at

https://www.dropbox.com/sh/4sooxglwy...9XFjLbnTa?dl=0

you'll find a little starter spreadsheet (developed in Excel 2016, but it should also work in Excel 2013, maybe even Excel 2010) I quickly developed with the basic functionality:
- A flightlog (add columns and calculations as you wish)
- A component's log incorporating the flown hours from the flightlog and issuing yellow or red warnings if the specified limits are reached (with the help of conditional formatting)
- A limit's page where you can set the limits for yellow and red warnings
- You can definitely not enter hour values greater than 9999:59, but you can calculate with bigger values and they will show up correctly. I demonstrated it here with the limiting hours of the components. So, a workaround to handle bigger hour values should be available

It's without programming (ie. no macros) and only with simple formula and formatting.

Feel free to download this sheet and extend it to your needs.

BUT: I take no risk and no warranty on anything. If you use it, you use it on your own risk!
Neither will I support it!

Possible additional columns in the flightlog sheet would be PICs and COs names, comments, purposes, applicable flight rules, ...
Possible additional columns in the component's sheet would be serial numbers, comments, other technical details, ...

Have fun

Thracian
Thracian is offline  
Old 20th Feb 2016, 10:06
  #9 (permalink)  
 
Join Date: Apr 2003
Location: U.K./nigeria
Posts: 113
Likes: 0
Received 0 Likes on 0 Posts
Thracian,
Thank you.
As you might imagine my spreadsheet is quite big, but you have given me a few ideas to incorporate tech log details directly into it. All my my cells are used in simple basic arithmetical formula, not clever enough (yet) for anything more sophisticated.
Bluesafari
bluesafari is offline  
Old 20th Feb 2016, 10:50
  #10 (permalink)  
 
Join Date: Jun 2010
Location: Germany
Posts: 99
Likes: 0
Received 0 Likes on 0 Posts
Well, that's been my basic idea: Giving you some ideas how to handle the big sheets with the real data. And my sample is only built for this.

Have fun

Thracian
Thracian is offline  
Old 22nd Feb 2016, 21:21
  #11 (permalink)  
 
Join Date: Sep 2008
Location: Sussex UK
Age: 66
Posts: 129
Likes: 0
Received 0 Likes on 0 Posts
Beware using 3rd party spreadsheets to forecaste components and maintenance
until you have thoroughly tested it and are completely happy with the answers. Not testing could leave you open to overflys etc and possible litigation with little comeback if the spreadsheet proves to be faulty in any way.

I am not putting down the time and effort of the authors of these sheets,as they do provide an inexpensive and efficient solution when properly written. They take a lot of thought/care and effort to get right.
Ainippe is offline  
Old 29th Feb 2016, 12:01
  #12 (permalink)  
 
Join Date: Apr 2008
Location: Europe
Posts: 121
Likes: 0
Received 0 Likes on 0 Posts
Stil in need?

Hi, If anyone is still interested, I can give you spreadsheets for tracking life limits and OH /S.I. and inspections for B-212, 412, 206, EC-135 with PN etc. already entered -could save you some time.
No liability accepted for its use, of course, as mentioned above.


regards,


hoistop
hoistop is offline  
Old 1st Mar 2016, 11:13
  #13 (permalink)  
 
Join Date: Apr 2003
Location: U.K./nigeria
Posts: 113
Likes: 0
Received 0 Likes on 0 Posts
Hoistop,

Would like to have a look at one of them, even though I'm looking after an A109E, you may have solved some problems that I am struggling with.

Bluesafari
bluesafari is offline  
Old 23rd Mar 2016, 16:40
  #14 (permalink)  
 
Join Date: Apr 2008
Location: Europe
Posts: 121
Likes: 0
Received 0 Likes on 0 Posts
Sorry for being late.
No problem, have an A-109E spreadsheets too. Please send a PM.
hoistop
hoistop 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 © 2022 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.