Page 1 of 1
Design Spreadsheet
Posted: Fri Mar 18, 2011 11:57 am
by ian herdis
Has anyone used the Aircraft Basic Design spreadsheet it makes a lot of calculations very simple.
What I cant understand is how it comes up with a figre for Fin Moment Arm you only enter the distance between root leading edges of wing and tailplane, no data you enter places the fin fore and aft on the fuselage so how can it come up with Fin Moment Arm.
Am I missing something? or does it make an assumption regarding the position of the fin
Ian Herdis
Posted: Fri Mar 18, 2011 6:21 pm
by Ian Melville
Ian you could be right,
Cell H60 makes reference to H56, which is a measurement relative to the Tailplane not the Fin. It could only be correct in one fin position (can't be asked to work that out)
I would have thought the formula in cell H60 should read...
XX-D52+I52
Where XX is the distance between wing LE and Fin LE
Posted: Sun Mar 20, 2011 5:52 pm
by ian herdis
Maybe someone from Engineering could comment
Posted: Sun Mar 20, 2011 7:20 pm
by Ian Melville
I don't think anyone from engineering lurks around this forum.
I have just tried to use the sheets for the CX4 project and get some figures that are not expected. The wing planform is neither a constant cord, nor a constant taper. Hence the wing area and aspect ratio are way out. If I fudge the tip cord I can get a match for area and ratio, the stability figures are in the sweet zone (using my amendment to the fin moment arm)
I cannot help noticing the mix of units across the three sheets. A lot of playing around with the calculator.
Posted: Fri Mar 25, 2011 4:46 pm
by PennySharpe
Thank you for your comments - the spreadsheet has been re-issued.
Posted: Fri Mar 25, 2011 7:17 pm
by Ian Melville
Thanks Penny. I'll check it out this weekend
Posted: Mon Mar 28, 2011 9:52 pm
by ian herdis
Hi, Penny
Please pass on my thanks to Engineering, now I can adjust the fin position and see the moment arm change, excellent !!!!
And thanks for your help.
Regards, Ian