Author Topic: mabye proof the 1.03 model was right?  (Read 1478 times)

Offline Zigrat

  • Nickel Member
  • ***
  • Posts: 792
mabye proof the 1.03 model was right?
« on: December 06, 2000, 01:17:00 AM »
i was bored today and wrote this excel sheet, just input simple test parametrs you can find from aces high into the worksheet, i think its pretty straight forward


i should have been doing my 401 lab but i made this, LOL

it seems to *me* to be fairly accurate, but there will be about a 5-10% margin of error because i used a generic prop efficiency curve

give it a try with your favorite AC and post the results.
 http://www.iit.edu/~buonmic/aircraft-test.xls


btw its an excel file  

post your test results versus worksheet results here


[This message has been edited by Zigrat (edited 12-06-2000).]

-towd_

  • Guest
mabye proof the 1.03 model was right?
« Reply #1 on: December 06, 2000, 09:49:00 AM »
zig i love ya , but could you give some explanation of you findings . i promis ill jump any that flame ya.


 

Offline Ripsnort

  • Radioactive Member
  • *******
  • Posts: 27260
mabye proof the 1.03 model was right?
« Reply #2 on: December 06, 2000, 10:11:00 AM »
Zig, you canceled your account, right? Why bother?

Offline Westy

  • Gold Member
  • *****
  • Posts: 2871
mabye proof the 1.03 model was right?
« Reply #3 on: December 06, 2000, 10:39:00 AM »
 And TOWD said he is too.  "Last month"

  -Westy

Offline Zigrat

  • Nickel Member
  • ***
  • Posts: 792
mabye proof the 1.03 model was right?
« Reply #4 on: December 06, 2000, 11:34:00 AM »
mabye because it isnt only good for aces high but any piston powered monoplane?

anyways try it out, it turns out that the models really are pretty accurate, which will make you cheerleaders happy ;D

Offline Maverick

  • Plutonium Member
  • *******
  • Posts: 13958
mabye proof the 1.03 model was right?
« Reply #5 on: December 06, 2000, 11:36:00 AM »
Excuse me,

I fail to see where a spread sheet is a definitive explanation of flight characteristics. I recall several engineers were able to show that a bumble bee could not fly on the basis of their mathematical extrapolations. Fortunately bees don't do math.  

Mav
DEFINITION OF A VETERAN
A Veteran - whether active duty, retired, national guard or reserve - is someone who, at one point in their life, wrote a check made payable to "The United States of America", for an amount of "up to and including my life."
Author Unknown

Offline Zigrat

  • Nickel Member
  • ***
  • Posts: 792
mabye proof the 1.03 model was right?
« Reply #6 on: December 06, 2000, 11:52:00 AM »
how do you think pyro makes flight models, he makes em up?

no he uses math  


Offline Pyro

  • Administrator
  • Administrator
  • *****
  • Posts: 4020
      • http://www.hitechcreations.com
mabye proof the 1.03 model was right?
« Reply #7 on: December 06, 2000, 12:08:00 PM »
The bumblebee story is usually regarded as an urban legend.
 http://quest.arc.nasa.gov/aero/team/fjournals/wellman/bumblebee.html

------------------
Doug "Pyro" Balmos
HiTech Creations

funked

  • Guest
mabye proof the 1.03 model was right?
« Reply #8 on: December 06, 2000, 12:11:00 PM »
 

Offline Zigrat

  • Nickel Member
  • ***
  • Posts: 792
mabye proof the 1.03 model was right?
« Reply #9 on: December 06, 2000, 12:23:00 PM »
btw i just did a little yak testing ..

in aces high, the yak can sustain a 4g turn at 1000 ft and 215 MPH with a sink rate of 3800 FPM, predicted by worksheet 3600 fpm sink rate for that turn..


the yak was also able to flat turn on the deck at 215 MPH 3 G, which was rpedicted by the worksheet, exactly almost  


so it works pretty well for the yak anyways...


so if you think a plane is *uber* or whatever, plug in its info and then test it and see if its close.. if you test it right (keep good corrdinated turns etcera) it should be very close...

anyways i verified the yak flight model (good job pyro   ) so all the nik whiners etcera can go try it out


Offline easymo

  • Parolee
  • Silver Member
  • ****
  • Posts: 1640
mabye proof the 1.03 model was right?
« Reply #10 on: December 06, 2000, 01:01:00 PM »
 I don't want to get into a "ours is good there,s is bad thing". But why are the FM,s so different in other sims? Arcade sims aside. There are sims claiming to have the most realistic FM. If it is just the math. why aren't the FM,s identical?

Offline tshred

  • Copper Member
  • **
  • Posts: 252
mabye proof the 1.03 model was right?
« Reply #11 on: December 06, 2000, 03:07:00 PM »
Bad equations and missing/excluded numbers Easy.

ts

Offline jedi

  • Zinc Member
  • *
  • Posts: 21
mabye proof the 1.03 model was right?
« Reply #12 on: December 06, 2000, 03:29:00 PM »
Cool spreadsheet, but it appears to be using a "generic" airfoil.  So it may only approximate values for some of the planes with more "exotic" airfoils.

The more factors the modeling system attempts to track, the more likely it is to provide accurate data, but also the more likely it is to have erroneous data input at some point.

Also, the closer you come to "max performing" the airplane, or flying it "at the edge," the less likely it is that any "smooth" equation system will accurately predict the real performance.

Which is probably why the turn performance is so hard to get just right, and why the "anecdotal evidence" often fails to match the sim performance...

--jedi


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


Offline easymo

  • Parolee
  • Silver Member
  • ****
  • Posts: 1640
mabye proof the 1.03 model was right?
« Reply #13 on: December 06, 2000, 06:31:00 PM »
 This is very interesting.

Again, not to start anything. But has anyone done a test of WB with this system. I would be curious how close they are.

Offline Zigrat

  • Nickel Member
  • ***
  • Posts: 792
mabye proof the 1.03 model was right?
« Reply #14 on: December 06, 2000, 07:09:00 PM »
well one thing easymo...

by climb rates for all aircraft i am testing are too high, but I am not sure why. It must be due to incorrect propeller efficiency curves but it is difficult to find good data on prop efficiency.