Fighter Aircraft Turn Performance -- Degrees Per Second

[hawker111]

I'm trying to create a spreadsheet formula that will calculate the following:

 

Punch in a particular G, say 7 G's, and punch in a particular airspeed, say 450 KTAS, and get the Degrees Per Second.

 

Could anyone help me with this? I would really appreciate the help very much.

 

Thanks,

 

Hawker111

[jeanba]

g = v*v/R/9.81, with v in m/s, v(m/s) = v(knots) * 1.852/3.6 => R = v*v/9.81/g

Turn rate : 

w (degres /s) = v/R*180/pi()

[hawker111]

Thank you . . .

 

Would you be able to write out the formula to paste into an Excel spreadsheet cell?
 

[jeanba]

Thank you . . .

 

Would you be able to write out the formula to paste into an Excel spreadsheet cell?

 

It would be tricky because I am using a french version of excel, and french and english versions are not very friendly (decimal point or comma)

Edited July 16, 2015 by jeanba

[BlueCaneCorso]

Couldn't upload the spreadsheet but here's a screen shot and the formula text in the cells.  To be super accurate you would need some aerodynamic coefficients specific to individual aircraft but this seems pretty reasonable.

 

in cell D3: =B3*0.5144

in cell E3: =(D3*(D3/9.81))/A3

in cell A7: =(D3/E3)*H2

 

 

[jeanba]

No, no need, it is just simple kinematic

[hawker111]

 

Thank you, BlueCaneCorso!

 

I entered the formulas into Excel. This is really fantastic. It is something that I wanted to do for a long time.

 

Just one thing I would like to ask about.

 

Take a look at these DPS numbers that someone else calculated (I can't get in touch with the author of the document containing these numbers, so I can't ask him about the formula he used):

-------------------------------------------

DPS numbers calculated by someone else

299 9 33.0

396 9 25.0

513 8 17.1

292 3.7 13.3

284 3 11.0

256 2.3 9.0

-------------------------------------------

 

Now here are the DPS numbers using your formula:

-------------------------------------------

DPS numbers calculated using BlueCaneCorso's formula

32.9

24.8

17.0

13.8

11.5

9.8

-------------------------------------------

 

As you can see, for some reason, his lower DPS numbers are lower than the numbers calculated using your formula.

 

If I wanted to adjust the formula slightly to make it match the formula that the other man was using, what would the adjustment be?

 

Thanks very much,

 

Hawker111