Performance Calculator
Thread Starter
Joined: Nov 2000
Posts: 9
Likes: 0
Performance Calculator
Anyone out there have any information on how to create an Excel calculator from the RFM graphs? I'm trying to build a simple calculator to input PA & OAT to extract MAUM for Helipad.
Regards,
L#cky Strike
Regards,
L#cky Strike
Joined: Sep 2007
Posts: 3
Likes: 0
From: UK
I don't personally ... but I know a man who can. Pete Rowlinson has developed "a powerful planning tool, allowing the detailed analysis of range, payload and performance of an aircraft with realistic AUWs and accurate performance data for all operating conditions. By bringing together real loading data and comprehensive performance information, 'What if?' scenarios can be run in seconds, with answers displayed immediately in e********'s easy to understand graphical format."
Try http://www.aerotechuk.com/easyweigh.html
Try http://www.aerotechuk.com/easyweigh.html
Joined: Nov 2003
Posts: 567
Likes: 4
From: Hereford UK
If you go onto www.mrexcel.com and either join and pose your own question or don't join, do a search and hope!
Either way somebody will come up with the solution. I found the site superb and very friendly.
Either way somebody will come up with the solution. I found the site superb and very friendly.
Joined: Feb 2003
Posts: 14
Likes: 0
From: England
L#cky Strike
If I think I know what you're trying to do you'll want to use the EXCEL functions "MATCH", "INDEX" and "TREND" to perform linear extrapolation. What variables (and how many) are you dealing with? I assume 3; OAT, Hp and AuM and what format is the data in? i.e. is it columns of AuM varying with Hp for a fixed OAT etc?
I've used this method on a 3 variable calculation - Ng acceleration for a given Hp and OAT and it works fine.
LHB
If I think I know what you're trying to do you'll want to use the EXCEL functions "MATCH", "INDEX" and "TREND" to perform linear extrapolation. What variables (and how many) are you dealing with? I assume 3; OAT, Hp and AuM and what format is the data in? i.e. is it columns of AuM varying with Hp for a fixed OAT etc?
I've used this method on a 3 variable calculation - Ng acceleration for a given Hp and OAT and it works fine.
LHB
Joined: Feb 2003
Posts: 14
Likes: 0
From: England
L#cky Strike
Just a word of caution (and apologies, if as I suspect, you've already considered this). Whatever method you come up with for your performance calcs, unless the method has been approved by the manufacturer of your helicopter / certifying authorities and shown to have no errors it can only be used as a guide and should not replace the approved charts. Obviously, as you develop your calculator there will be plenty of cross checking against the RFM so you'll have a good degree of confidence in its accuracy.
LHB
Just a word of caution (and apologies, if as I suspect, you've already considered this). Whatever method you come up with for your performance calcs, unless the method has been approved by the manufacturer of your helicopter / certifying authorities and shown to have no errors it can only be used as a guide and should not replace the approved charts. Obviously, as you develop your calculator there will be plenty of cross checking against the RFM so you'll have a good degree of confidence in its accuracy.
LHB
