Rate of Climb in Rise-of-Flight - charted data

[TX-Gunslinger]

Thought you all might find this useful.  King had completed a similar chart before.




S~

Gunny

[TX-Kingsnake]

 

[TX-Kingsnake]

Wait a sec. This is a bit misleading in that the ceilings are not correct. In the Gunnyshpere the ceiling makes a big difference. Trim the lines at the ceiling.  They must have changed the N17 time to climb because I had a very different looking line and yours looks more realistic. What we need now is a weighted rate of turn graph and we will have a sufficient compare chart for RoF.

[TX-Gunslinger]

Thanks for pointing out the N17 error King - replotting now.

S~

Gunny

[TX-Kingsnake]

I'd like the excel file. I sat around trying to do that in excel like a caveman. I'm starting to wonder what happened to the higher functioning part of my brain. 

[TX-Gunslinger]

King,

Here's the spreadsheet in it's current version:

https://webspace.utexas.edu/joem/ROF-releaseable/ROF%20Compare%21.xls

I had started a second chart (with sheets) to provide metric (versus imperial) calibration, however I did not finish it.  The first chart and "imperial" spreadsheets are completely functional.

Enjoy,

S~

Gunny

[TX-Kingsnake]

You are having the same problem I was having, the lines are extending beyond the plotted points. In this case it is the maximum service ceiling. Except you probably know how to fix that while I had to draft a graph. Nice work buddy. 

[TX-Gunslinger]

yeah - the "connect" lines to data points only give you the trends when there is enough data...

The way I did it was to invoke curve fitting routines built ino excel.  I found Polynomial to be the best fit for what I was looking for - i.e. reasonable extrapolation of existing points into areas where measurement was not available.

I wanted a good guess for the areas of "no data" in summary...

S~

Gunny

[GOZR]

lets do a spreadsheet about sound..  that could help the dev.. transfering Sound into graphic graph would be cool..