B2707SST
Topic Author
Posts: 1262
Joined: Wed Apr 23, 2003 5:25 am

### Specific Range And Fuel Consumption

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!

Thanks,

--B2707SST

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.

QantasA332
Posts: 1473
Joined: Sat Dec 13, 2003 5:47 pm

### RE: Specific Range And Fuel Consumption

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

Cheers,
QantasA332

AUAE
Posts: 292
Joined: Fri Apr 09, 2004 4:41 am

### RE: Specific Range And Fuel Consumption

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

phollingsworth
Posts: 635
Joined: Sat Mar 06, 2004 6:05 am

### RE: Specific Range And Fuel Consumption

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]

### Who is online

Users browsing this forum: AF1565, jarheadk5, N415XJ and 2 guests

### Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos