Sponsor Message:
Aviation Technical / Operations Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Specific Range And Fuel Consumption  
User currently offlineB2707SST From United States of America, joined Apr 2003, 1386 posts, RR: 58
Posted (12 years 2 weeks 22 hours ago) and read 13644 times:

A question for all you aerodynamicists out there:

I'm working on a project which entails converting several aircraft performance manuals into Excel. The goal is to allow a user to enter the desired payload and range in a spreadsheet automatically calculates the appropriate takeoff weight, fuel consumption, and flight time. For takeoff, departure, climb, descent, and landing, this isn't a problem, as fuel consumption, time, and distance are presented graphically. I pick several representative points and have Excel give me a quadratic equation for the curve.

For the cruise segment, specific range curves relating specific range (nm/kg) and Mach number for a given cruising altitude are the only data presented. Time and distance can be calculated with the selected cruise Mach number, distance to top of descent, and ISA values for Mach 1. To calculate fuel consumption:

SR = Nm. / Gal. * [1/hr] / [1/hr] = [nm/hr] / [gal/hr]

Given the calculated true airspeed (assuming zero wind), rearranging to solve for gal/hr gives a point estimate of fuel flow at a particular weight. However, the aircraft's weight is changing constantly, so I can't just multiply by the hours spent at cruise.

The specific range curves are only given at discrete weights. I'd like to find a continuous function that describes fuel consumption as a function of weight, altitude, and Mach number. Is there a way to do this? Specifically, I'm trying to find a way to interpolate between the various SR curves, but am not having much luck. Any suggestions?

Another manual shows specific range versus aircraft weight at a given Mach number, which is much easier to work with!



PS - This is not for a real airline, so absolute accuracy is not required.

Keynes is dead and we are living in his long run.
3 replies: All unread, jump to last
User currently offlineQantasA332 From Australia, joined Dec 2003, 1500 posts, RR: 23
Reply 1, posted (12 years 2 weeks 18 hours ago) and read 13500 times:

In my studies, I haven't come across any functions that directly relate fuel consumption to weight/altitude/Mach number, now that I think about it! Perhaps a fellow 'A.net aerodynamicist' knows of them, if they do indeed exist...


User currently offlineAUAE From United States of America, joined Apr 2004, 296 posts, RR: 3
Reply 2, posted (12 years 2 weeks 16 hours ago) and read 13425 times:

I wish I had my Mattingly book here at work! Without reference material, I am nothing! Seems like you need a few more parameters for a range equation though. Thrust and drag???

Air transport is just a glorified bus operation. -Michael O'Leary, Ryanair's chief executive
User currently offlinePhollingsworth From United Kingdom, joined Mar 2004, 825 posts, RR: 4
Reply 3, posted (12 years 2 weeks 14 hours ago) and read 13417 times:

You want is an engine map. SFC won't change with weight, but will with Mach and altitude. The problem is the engine will be operated off design. I don't have Mattingly in-front of me. But with SFC you can use the cruise-climb Breguet range equation. For cruise, Thrust=Drag, the equation becomes:

Wfuel/Wstart = 1 - exp[-(SFC * Range)/(V * L/D)]

where L/D is the lift to drag ratio. If you use the SR and the starting weight you can back out the SFC and L/D it the points you are given. This should get you your engine deck. Make sure your units are consistent.

As for getting a simple equation out of this, you will need to perform a multiple linear regression. You may need to use another tool as it seems Excel only does single regression. Multiple is not all the difficult and there are probably a number of references on the web. I could also do the regression for you if you sent me the data table.

[Edited 2004-04-22 15:15:43]

Top Of Page
Forum Index

Reply To This Topic Specific Range And Fuel Consumption
No username? Sign up now!

Forgot Password? Be reminded.
Remember me on this computer (uses cookies)
  • Tech/Ops related posts only!
  • Not Tech/Ops related? Use the other forums
  • No adverts of any kind. This includes web pages.
  • No hostile language or criticizing of others.
  • Do not post copyright protected material.
  • Use relevant and describing topics.
  • Check if your post already been discussed.
  • Check your spelling!
Add Images Add SmiliesPosting Help

Please check your spelling (press "Check Spelling" above)

Similar topics:More similar topics...
Summer Temperatures And Fuel And Range posted Fri Jul 21 2006 11:00:09 by Oly720man
Thrust Specific Fuel Consumption (B737 & CFM56-7) posted Wed Jul 5 2006 11:58:51 by Kaddyuk
DC-9 And MD-8 Fuel Consumption posted Thu Feb 23 2006 06:04:22 by Rottamo
Specific Fuel Consumption Of Jet Engines posted Sun Jun 16 2002 23:11:43 by YoungDon
Total Fuel Consumption For Two Segments? posted Sun Nov 12 2006 23:32:08 by WestWing
B767-200 Fuel Consumption Question posted Sun Nov 12 2006 07:06:31 by Jetline
Range And Payload posted Sun May 28 2006 12:54:58 by Newagebird
Fuel Consumption As Aircraft Ages posted Thu May 11 2006 02:01:13 by AirplaneCrazy
Passenger Airplane Fuel Consumption posted Thu May 4 2006 04:42:38 by PropilotJW
Fuel Consumption To Cruising Altittute posted Sun Feb 19 2006 19:16:27 by Ultrapig

Sponsor Message:
Printer friendly format