Flight/Ground Ops, Crewing and Dispatch A forum for the people who are engaged in operational control/flight dispatch/crewing and their colleagues airside in ramp dispatch, load control and ground handling, to discuss issues directly related to keeping their aircrew and aircraft operational.

EXCEL Loadsheet approved by CAA?

Old 8th Jul 2016, 15:23
  #1 (permalink)  
Thread Starter
 
Join Date: May 2006
Location: Expat in BUD
Posts: 43
EXCEL Loadsheet approved by CAA?

Hi there,

Im in a small operator where the crews are doing all paperwork, FPL, ATC, mass and Balance, permits.... and till now we was using Excel to produce Loadsheets for all the fleets, DA42, Cheyenne and Beechjet.

After last EASA audit, we were told that EXCEL is not allowed for that. So, we went back to basically.... copy the one in the plane manual and draw lines.

Do they think this is more accurate?

Now the CAA is studiying the case to see if they can allow the excel sheets, but they are reaaaally slow with this stuff. (forbidding is easy)

Anyone has experiences with EXCEL sheets and CAA? Anyone uses a house made one and havent any problem with CAA?

Thanks for your feedback.
Griffon_PMI is offline  
Old 9th Jul 2016, 03:05
  #2 (permalink)  
 
Join Date: Dec 2013
Location: Norfolk
Age: 66
Posts: 1
Plenty of electronic flight assistant devices are used on aircraft and I'm pretty certain a lot of them use Excel or similar programs.

Perhaps it is the way you are using the Excel spreadsheet? What safety checks are written in to constrain errors? Is the correct aircraft type displayed? Are the correct formulae inserted for each type of aircraft and suitably protected from being overwritten or altered accidently?

Anyone can write a simple spreadsheet to do load and balance calculations for multiple aircraft. Not everyone can write a speadsheet that protects the user from selecting the wrong aircraft type, errors in data entry or errors in the program itself. You need two or more independent checks (or calculation paths) built into the program to highlight any data entry or calculation errors.

I suspect the CAA are concerned that using a single spreadsheet to cover multiple aircraft introduces too many risks, and not that you can't produce loading sheets electronically. You just can't do it the way you have been doing it up to now because of some identified risk in the procedure they inspected.
G0ULI is offline  
Old 16th Jul 2016, 09:22
  #3 (permalink)  
Thread Starter
 
Join Date: May 2006
Location: Expat in BUD
Posts: 43
Well, the thing is that they didnt mention about the consistency of the system or any kind of safety checks... they just said "Excel is not good".

I am sure if we just buy a system from a software provider they will be happy... but that is not the point.
Of course the spreadsheets were protected so you can modify only the fields that are variable. You dont see formulas, and actually, almost everything is built on "dropdown list" kind of: select pax type in this seat: male, female, child. So, you dont even need to introduce a weight. (but it could be override for special passengers or actual weights)

My loadsheets have a color system to show when the limits are exceded or data is not correct....
we have a different spreadsheet for every fleet, and selecting registration it change the BEW and arms of that specific plane...

What do you mean about 2 independent calculation paths?
I would appreciate a lot if you have any reference on regulation or guidance material about what is needed regarding "compliance".

Thanks!
Griffon_PMI is offline  
Old 19th Jul 2016, 13:37
  #4 (permalink)  
 
Join Date: Jul 2009
Location: South England
Age: 60
Posts: 11
You could always talk to Libra Aviation Services. They use the HP DPlan/Libra system and provide it as a service to multiple customers.
Bowser99 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.