hawker111 1 Posted July 16, 2015 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 Share this post Link to post Share on other sites
jeanba 1,915 Posted July 16, 2015 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() 1 Share this post Link to post Share on other sites
hawker111 1 Posted July 16, 2015 Thank you . . . Would you be able to write out the formula to paste into an Excel spreadsheet cell? Share this post Link to post Share on other sites
jeanba 1,915 Posted July 16, 2015 (edited) 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 Share this post Link to post Share on other sites
BlueCaneCorso 18 Posted July 16, 2015 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 Share this post Link to post Share on other sites
jeanba 1,915 Posted July 16, 2015 No, no need, it is just simple kinematic Share this post Link to post Share on other sites
hawker111 1 Posted July 17, 2015 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 Share this post Link to post Share on other sites
