Jan 12, 2012, 12:40 AM
|
|
|
United States, CA, Huntington Beach
Joined Jun 2011
172 Posts
|
Review of Dan's CGCalc
Well Kevin,
This was a good opportunity to finally upgrade to Office for MAC:2011 that runs VB macros. Having done that I entered the same Orion geometry into Dan’s CGCalc v.1.05_03 and Suter’s CG Calc. The results are NOT within spitting distance as follows. Note that column 1 is Dan’s result using the actual Z position of the stab, column 2 is Suter’s result using 0.6 stab efficiency as he suggests and column 3 is Suter’s result using 0.9 stab efficiency that is NOT recommended. Distance shown is from wing root LE measured aft.
Neutral Point (in) 5.32 4.62 5.33
% of MAC N/A 43.4 52.5
CG Location (in) 4.9 4.2 4.9
% of MAC N/A 38.4 47.0
Static Margin (%) 5.3 5.0 5.5
It is possible that I completely screwed-up the data entry but… I’ll let you and Dan check that.
My Orion as earlier stated balanced at 105mm (4.1”) for first flight and very slowly pulled up from a 45 degree dive… perfect for me. To suggest a first flight with the CG moved aft 0.7” (to ~125mm) would be spooky at best and likely demonstrate a severe tuck in the dive test when trimmed for thermal flying. I will let some brave pilot do that test.
This is long winded and really off-topic for an Orion forum so will conclude my review of Dan’s CGCalc as follows:
The instructions are way out of date… 10/23/09.
He starts off on sheet one with this: “The coordinate system is shown above. It's set up this way for formatting reasons. It's not a proper "right-hand rule" system, but who cares. Deal with it.” I care, having mentored new hires straight from universities we all care. As a configuration designer for many years on full-size aircraft I don’t want to deal with it. Fix it!
Is that why the vertical stab has forward to the right? The convention is forward to the left.
Clicking around the “take action cells” I get lots of run time errors. Could be my MAC, however.
Suter’s spreadsheet uses no VISABLE coordinates, just plug-in the numbers (all positive) in the yellow cells on the graphical representation of the surface in question. Scary simple! No remembering to enter negative X values needed as in Dan’s spreadsheet.
He does not offer %MAC values for the numbers… very handy. Suter does.
He uses a Static Margin Wizard which is okay, but why?. Suter has all of this stuff on one sheet allowing YOUR desired CG location, Static Margin OR %MAC to be iterated with simple data entry and output… no macros or solving required.
He requires dihedral to be entered in degrees. Hey, I have this airplane sitting on the bench and I have a tape measure. That is all Suter wants and no Trig needed to calculate degrees. Suter calculates the degrees for us. Cool.
He uses decimals out to 6 or 8 places. Why? It makes the data hard to read and means nothing in the real world of models.
He states this: “I should also give the disclaimer that the entire spreadsheet, including the fuselage contribution, can be thought of as a first-order approximation. There are many things it doesn't take into account -- things which are usually not incredibly important -- in order to make the calculations tractable and reduce the need for detailed user input. It's not meant to replace flight testing, but it should help getting the CG close on the first try so there are no big surprises. However, if you have a model with some unusual features you should be careful using the spreadsheet.” Amen.
I never recommend products but will suggest Suter’s spreadsheet is worth a try. To suggest Dan’s spreadsheet is “simpler and faster” to use is a real stretch. To each his own. If you want a very sophisticated MODEL design and analysis tool that conforms to industry standards look at Blaine Rawdon’s Plane Geometry.
Dick
|
|
|
|
|