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.:confused:

Regards,

L#cky Strike

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

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.

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

Guys,

Thanks very much. I have indeed had experience of Easyweigh, which is great on a corporate budget, but I'm having a go at stripping the RFM graph down and it seems to be working!:D

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