Design Spreadsheet

Discussion of aircraft design, new designs and designing your own

Moderators: John Dean, Moderator

Design Spreadsheet

Postby ian herdis » Fri Mar 18, 2011 12:57 pm

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
ian herdis
 
Posts: 104
Joined: Tue Jan 08, 2008 4:45 pm

Postby Ian Melville » Fri Mar 18, 2011 7:21 pm

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
Ian Melville
 
Posts: 863
Joined: Mon Feb 11, 2008 8:21 pm

Postby ian herdis » Sun Mar 20, 2011 6:52 pm

Maybe someone from Engineering could comment
ian herdis
 
Posts: 104
Joined: Tue Jan 08, 2008 4:45 pm

Postby Ian Melville » Sun Mar 20, 2011 8:20 pm

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.
Ian Melville
 
Posts: 863
Joined: Mon Feb 11, 2008 8:21 pm

Postby PennySharpe » Fri Mar 25, 2011 5:46 pm

Thank you for your comments - the spreadsheet has been re-issued.
PennySharpe
Site Admin
 
Posts: 42
Joined: Wed Jan 09, 2008 1:02 pm

Postby Ian Melville » Fri Mar 25, 2011 8:17 pm

Thanks Penny. I'll check it out this weekend
Ian Melville
 
Posts: 863
Joined: Mon Feb 11, 2008 8:21 pm

Postby ian herdis » Mon Mar 28, 2011 9:52 pm

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
ian herdis
 
Posts: 104
Joined: Tue Jan 08, 2008 4:45 pm


Return to Aircraft Design - General

Who is online

Users browsing this forum: No registered users and 1 guest

cron