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!