Design & CG Excel Spread Sheet  
View related threads: (in this forum | in all forums)

Tower Hobbies
Enter up to 4 keywords or Tower stock numbers
Logged in as Guest



Users viewing this topic: none
  Printable Version
       


Avonds F-15 RTF - RTF
Seller:  BAGOSTIX
Details:   $4,200.00   |  11/17/2008   |  Classified Ad
We will rotate YOUR AD in this spot if you select "Forum Featured" when placing or editing your ad!

All Forums >> RC Airplanes >> Aerodynamics >> Design & CG Excel Spread Sheet
Page: [1]

Login
Message << Older Topic   Newer Topic >>
Design & CG Excel Spread Sheet - 7/9/2003 12:40:05 AM   
Wizardofflight


 

Posts: 20
Joined: 11/19/2002
From: Covington, WA,
Status: offline 		This is the beta version and first public release of this RC design spread sheet.

http://www.angelfire.com/scifi2/wizardofflight/images/RC_Aircraft_Design.zip

It is divided into 4 separate pages:
1. Gliders
2. Power
3. Canards
4. Flying Wings

The basis for this spread sheet comes from a CG program that published in “Soar Tech” (don’t remember the issue). Plus information from a number of other various sources. It started out mainly as a CG calculator and has expanded to calculate other basic parameters. Such as Tail Volume Coefficients, MAC, static margin, Aerodynamic Center, also it give a conversion from a standard tail configuration to a V-Tail.

To use the sheet fill in the gray areas with the aircraft’s data (all units are in inches). The yellow fields will reflect the calculations based on that data. While the blue fields will then show the suggested minimums, (NOTE: this data is presented for comparison purposes only.)

Suggestions and constructive criticisms are always welcome.

Alan Sinclair
[email]wizardofflight@hotmail.com[/email]
       Post #: 1

Thanks Alan - 7/9/2003 1:50:58 AM   
Dave_Gherardini


 

Posts: 113
Joined: 1/25/2003
From: Central, IL, USA
Status: offline 		Ha Alan. Thanks for the spread sheet. This will come in very handy.
Thanks agin..

Dave G

(in reply to Wizardofflight)
       Post #: 2

Design & CG Excel Spread Sheet - 7/9/2003 2:03:23 AM   
hattend



Posts: 2059
Joined: 11/29/2001
From: Redding, CA, USA
Status: offline 		Looks good, can't wait to put it to use.

Don

(in reply to Wizardofflight)
       Post #: 3

Design & CG Excel Spread Sheet - 7/9/2003 5:28:55 AM   
Tall Paul



Posts: 4692
Joined: 6/23/2002
From: Palmdale, CA, USA
Status: offline 		Can the c.g. for the flying wing be changed?
And what is it right now?

(in reply to Wizardofflight)
       Post #: 4

Design & CG Excel Spread Sheet - 7/10/2003 6:45:17 AM   
glidaguy28


 

Posts: 16
Joined: 10/23/2002
From: napier, NEW ZEALAND
Status: offline 		hi Alan cant access your web page......can you help me....or e-mail me your program...thanks Glidaguy

(in reply to Wizardofflight)
       Post #: 5

Design & CG Excel Spread Sheet - 7/10/2003 10:24:03 AM   
Wizardofflight


 

Posts: 20
Joined: 11/19/2002
From: Covington, WA,
Status: offline 		for the flying wing change the areas in gray with your data and it should do the rest.

If not let me know and I'll fix it.

I have gone over my bandwidth limit today.

I've attached it.

Alan
[email]wizardofflight@hotmail.com[/email]

Attachments
Click to see the file in new window.Attachment.zip


< Message edited by Wizardofflight -- Jul 10 2003 3:22PM >

(in reply to Wizardofflight)
       Post #: 6

Design & CG Excel Spread Sheet - 7/10/2003 10:03:20 PM   
Tall Paul



Posts: 4692
Joined: 6/23/2002
From: Palmdale, CA, USA
Status: offline 		Well, there's a typo in the Area heading in the grey area also.
Easy fix.
It does look like a good tool. The numbers I've worked so far agree with other sources.
I do like to know what the c.g. the sheets use, in case I want to change it.
Usually I set in a straight wing of 10" chord and see what the c.g. computes to, but it's a nicety to see where square one is.

(in reply to Wizardofflight)
       Post #: 7

Design & CG Excel Spread Sheet - 7/11/2003 2:29:43 AM   
Wizardofflight


 

Posts: 20
Joined: 11/19/2002
From: Covington, WA,
Status: offline 		Tall Paul

Sorry, I guess I’m not understanding the question, “… what the c.g. the sheets use, …” Is this referring to the formula?

I’ll can to dig up where I got the data from. I have had this spread sheet sitting around for awhile and the memory is a bit fuzzy.

Alan

(in reply to Wizardofflight)
       Post #: 8

Design & CG Excel Spread Sheet - 7/11/2003 2:37:14 AM   
hattend



Posts: 2059
Joined: 11/29/2001
From: Redding, CA, USA
Status: offline 		I think he wants to know what the CG percentage is so if he wanted to change the parameter, which cell would he have to go into to change it.

Your spreadsheet has a set CG point calculated by the formulas, which cell would he have to change to move the CG forward or back from the point calculated now?

That about right, Tall Paul?

I could be out to lunch
Don

(in reply to Wizardofflight)
       Post #: 9

Design & CG Excel Spread Sheet - 7/11/2003 2:52:50 AM   
DICKEYBIRD



Posts: 2671
Joined: 4/8/2002
From: Collierville, TN, USA
Status: offline 		Hi Alan, great tool....thanks very much!

Question: I'm working with a friend on his variable CG canard project (Don't ask! :rolleyes and am wondering if your program will compute the CG for a canard just by entering negative numbers into the "Distance from leading edge wing to leading edge tailplane and Distance from AC of wing to AC of stab" fields, if not, how?

_____________________________

"He who dies with the most good Cox engines wins!"

(in reply to Wizardofflight)
       Post #: 10

Design & CG Excel Spread Sheet - 7/11/2003 3:41:52 AM   
glidaguy28


 

Posts: 16
Joined: 10/23/2002
From: napier, NEW ZEALAND
Status: offline 		thanks Wizard...glidaguy

(in reply to Wizardofflight)
       Post #: 11

Design & CG Excel Spread Sheet - 7/11/2003 5:48:41 AM   
Tall Paul



Posts: 4692
Joined: 6/23/2002
From: Palmdale, CA, USA
Status: offline 		[QUOTE]Originally posted by hattend
I think he wants to know what the CG percentage is so if he wanted to change the parameter, which cell would he have to go into to change it.

Your spreadsheet has a set CG point calculated by the formulas, which cell would he have to change to move the CG forward or back from the point calculated now?

That about right, Tall Paul?

I could be out to lunch
Don [/QUOTE]
.
Close... I like to know what the fixed values are in addition to which of them are variable.
The c.g. in the "wing" section is 18%.
12.3% (negative) for the "canard" section..
40% in the "power" section
and 37% in "glider"..
but apparently the option to change isn't part of the sheet.
I'd prefer that option.

(in reply to Wizardofflight)
       Post #: 12

Design & CG Excel Spread Sheet - 7/11/2003 5:47:01 PM   
DICKEYBIRD



Posts: 2671
Joined: 4/8/2002
From: Collierville, TN, USA
Status: offline 		Oops, sorry Alan....I failed to heed Paul's favorite warning: "RTFB." I read your instructions and saw that you have canards covered.

Thanks again for a great little program!

_____________________________

"He who dies with the most good Cox engines wins!"

(in reply to Wizardofflight)
       Post #: 13

Design & CG Excel Spread Sheet - 7/11/2003 7:30:43 PM   
Wizardofflight


 

Posts: 20
Joined: 11/19/2002
From: Covington, WA,
Status: offline 		Tall Paul

I'll dig up the reference material and my notes this week end and let you know.

Have a great day.

Alan

(in reply to Wizardofflight)
       Post #: 14

Design & CG Excel Spread Sheet - 7/12/2003 10:33:11 AM   
Wizardofflight


 

Posts: 20
Joined: 11/19/2002
From: Covington, WA,
Status: offline 		[QUOTE]Originally posted by Tall Paul
.
Close... I like to know what the fixed values are in addition to which of them are variable.
The c.g. in the "wing" section is 18%.
12.3% (negative) for the "canard" section..
40% in the "power" section
and 37% in "glider"..
but apparently the option to change isn't part of the sheet.
I'd prefer that option. [/QUOTE]

Tall Paul

Here are the equations that are used to calculate the CG for the flying wing. They were derived from equations published originally by Ron Van Putte, June1980, Model Aviation and then they were used in a Basic program printed in Soar Tech.

CG = P + ACw

P = (R^2 + (R X T) + T^2)/(15(T + R))

R = Wing Root Chord
T = Wing Tip Chord

The CG in % MACw is calculated for each combination of variables.

I hope this helps.

Alan

< Message edited by Wizardofflight -- Jul 12 2003 5:57AM >

(in reply to Wizardofflight)
       Post #: 15

Design & CG Excel Spread Sheet - 7/12/2003 9:46:15 PM   
Tall Paul



Posts: 4692
Joined: 6/23/2002
From: Palmdale, CA, USA
Status: offline 		Thanks... it calculates where the c.g. should be...

(in reply to Wizardofflight)
       Post #: 16

RE: Design & CG Excel Spread Sheet - 9/15/2003 9:18:09 PM   
RRW_SOAR


 

Posts: 80
Joined: 1/3/2003
From: Lost Andes, CHILE
Status: offline 		Hey! This is what I've been looking for, although I don't understand all the terms.

Will you please give a hand? I'd like to know what they mean or if there is a link where I can find more info.

Here I go:

1. Leading edge sweep offset (LESO): I thought that Root_chord = Tip_chord + LESO but I'm wrong...

2. Static margin?

3. P?

4. DIH angle and the related in this frame (wing loc. etc.)

Thanks in advance.

_____________________________

Ricardo,
Chile, South America

(in reply to Wizardofflight)
     &nb