HobbyKing.com New Products Flash Sale
Reply
Thread Tools
Old Mar 19, 2010, 07:12 PM
Launchpad McQuack
Prop-er's Avatar
Netherlands, Moordrecht
Joined Sep 2004
1,130 Posts
Download
Bagged wing layup spreadsheet

Ever wondered how much layers of fiberglass, carbon or Kevlar your bagged wings really need?

The answer to this question is probably yes. If you’re an inexperienced builder, the solution will most likely be to look and ask what other builders with comparable models have used. Other than that, there’s the wonderful “Wing Layup calcs” spreadsheet by Joe Wurts. Joe’s sheet (Excel says the Author’s name is “David F. Taggart”) does have it’s limitations, and can sometimes be hard to grasp.

Enter Jay Decker who published results from his own developed Excel spreadsheet. (http://www.rcgroups.com/forums/showthread.php?t=451571)

Jay was contacted to ask for a copy of his sheet, as the results he showed looked very promising. It turned out that Bill Osberg was busy modifying Jay’s sheet, because data input at that time was quite basic and time consuming. Bill send me a copy of what he had at that time.

After several months of hard work, the sheet has been transformed to provide a user friendly interface, with all of the composite material specifications included. The sheet calculates the wings basic aerodynamic properties, Cl- and lift distribution, bending moments resulting from hard turning or winch starting, wing stresses from up to four different kind of skins, stresses of up to two darts, tube spars, square spars and capped spars. Wing bending slope and deflection is calculated. The weight and cost of each component is calculated too. It even tells you how much layers of reinforcement the wing’s top layer needs at the servo bay cut into the bottom surface of the wing. The sheet is available in a version with imperial units, and a version with metric units.

Read the supplied manual for more information.

Currently the spreadsheet is a Beta version, meaning it can contain mistakes that can lead to inaccurate results. It is advised to always double check the spreadsheet results by looking at what other comparable model planes use for their wing construction!

Best regards,

Vincent
Prop-er is offline Find More Posts by Prop-er
Last edited by Prop-er; Nov 25, 2011 at 01:51 AM.
Reply With Quote
Sign up now
to remove ads between posts
Old Mar 21, 2010, 06:58 PM
Launchpad McQuack
Prop-er's Avatar
Netherlands, Moordrecht
Joined Sep 2004
1,130 Posts
It seems that adding the torsional stiffness of the wing is not that hard, BUT...

First, I really should include CLT into the sheet, which makes results much more accurate (and makes the calculation a lot more complex). Currently the EI of the (up to 4) skins are simply summed up, basically treating them as separate layers, instead of treating them as a bonded set of different layers with their specific properties according to the CLT.

From the R&G Handbook:

CLT

The classical laminate theory (CLT) is a method for conducting calculations on multi-ply inhomogeneous laminate lay-ups. It includes a thorough deformation and stress analysis based on the specific stress conditions in fibre composite laminates and specific failure hypotheses.

Deformation and stress analysis
Using the classical laminate theory (CLT) to conduct a deformation analysis on laminates yields a solution to a statically indeterminate system which has to take into account not only the equilibrium conditions, but also additional constitutive equations as well as stacking assumptions.
The analysis assumes the following:

The ply is the smallest calculation unit in the laminate. The properties of the inhomogeneous ply are “smeared” over the ply, and so “homogenised”.
For the calculations on the laminate, the plies are “stacked” and firmly glued to each other to form the laminate (stacking assumptions).

Whereas the full CLT also considers bulges, twists, and bends that arise as soon as coplanar forces are applied to non-orthotropic laminate lay-ups, the method of treating the laminate as a plane considers coplanar stresses and deformations only.
Prop-er is offline Find More Posts by Prop-er
Reply With Quote
Old Mar 21, 2010, 10:23 PM
Just fly it!
wyowindworks's Avatar
Cody, WY
Joined Nov 2007
6,915 Posts
Vincent, thanks for posting and working on the spreadsheet. I've downloaded it, but haven't had time to open it up and take a look. I look forward to giving it a wing.

Thanks for the work.

Adam
wyowindworks is offline Find More Posts by wyowindworks
Reply With Quote
Old Mar 22, 2010, 12:11 AM
working to the closest cm
jirvin_4505's Avatar
brisbane australia
Joined Nov 2002
2,121 Posts
Example files

Quote:
Originally Posted by wyowindworks View Post
Vincent, thanks for posting and working on the spreadsheet. I've downloaded it, but haven't had time to open it up and take a look. I look forward to giving it a wing.

Thanks for the work.

Adam

Same here

Gratitude for your efforts.

Still have to explore the spreadsheet - will have to get xls working.

Anyway that example wings can be saved for the RCG community to view.

I was thinking if the SuperGee11 was loaded we would have a standard to go from. Same with Taboo, Zone and Edge??

As I say this may already be there - just thinking out loud.

cheers jeff
jirvin_4505 is offline Find More Posts by jirvin_4505
Reply With Quote
Old Mar 22, 2010, 03:42 AM
Launchpad McQuack
Prop-er's Avatar
Netherlands, Moordrecht
Joined Sep 2004
1,130 Posts
Appreciate your replies! I had anticipated that it takes time to get reactions on the sheet, as one typically only dives into it the night before you plan cutting cores.

On CLT:
I must say that Jay's original calculation only had one skin, and now I understand why. Even Joe's calculation doesn't show results from the two skins combined.

@Jeff: good suggestion. We might create a simple database/table with the results from a number of well known designs. That way you can set yourself design goals for a certain torsional stiffness or wing deflection.

Posting the results here as a saved .xls file will allow me to make that database, and eventually include it in the calculation.
Prop-er is offline Find More Posts by Prop-er
Reply With Quote
Old Mar 25, 2010, 04:51 PM
Registered User
United States, OR, Tualatin
Joined Apr 2005
2,436 Posts
Great stuff!
TomFlyer is offline Find More Posts by TomFlyer
Reply With Quote
Old Apr 07, 2010, 05:48 AM
Launchpad McQuack
Prop-er's Avatar
Netherlands, Moordrecht
Joined Sep 2004
1,130 Posts
Good news. I have included CLT and torsional rigidity in the sheet, and have received permission to use part of the Lamicens code!

Still working on implementing the changes to the Imperial unit version.
Expect this soon.
Prop-er is offline Find More Posts by Prop-er
Reply With Quote
Old Apr 07, 2010, 07:39 AM
Registered User
Leesburg, Fl
Joined Jan 2005
24 Posts
Thanks for posting!
Red6 is offline Find More Posts by Red6
Reply With Quote
Old Apr 07, 2010, 10:52 AM
Registered User
cn0rris's Avatar
USA, CA, San Diego
Joined Aug 2008
658 Posts
Subscribed! Very much looking forward to this.
cn0rris is offline Find More Posts by cn0rris
Reply With Quote
Old Apr 08, 2010, 07:55 AM
Red Merle ALES
Curtis Suter's Avatar
United States, Mt, Helena
Joined Apr 2002
5,322 Posts
Vincent,

This is great stuff! Thanks so much for providing this to the Worldwide modeling community.

Curtis
www.TailwindGliders.com
Curtis Suter is offline Find More Posts by Curtis Suter
RCG Plus Member
Reply With Quote
Old Apr 08, 2010, 08:21 AM
Launchpad McQuack
Prop-er's Avatar
Netherlands, Moordrecht
Joined Sep 2004
1,130 Posts
Hi Curtis,

Thanks. I really appreciate your great calculations too!
Prop-er is offline Find More Posts by Prop-er
Reply With Quote
Old Apr 08, 2010, 10:29 AM
Registered User
Tenerife,Canary Islands
Joined May 2004
1,667 Posts
Thanks for developing such tool ,I will try to contribute if something arise.

A note in the gliders and high perf. forums may atract a lot of talkers

chichisport is offline Find More Posts by chichisport
Reply With Quote
Old Apr 08, 2010, 07:03 PM
Composites guy
North OC, Ca.
Joined Jun 2005
1,176 Posts
Can you tell me where you got the material property data from? I looked at the r-g catalog of properties and something doesn't seem to make sense.

The mechanical properties look high in the spreadsheet. The E11 values on a bias fabric may not make sense. ( more like E12 IIRC).
I also see no mention of resin properties in the sheets I looked over. they did assume 50 % Fiber volume ( not resin content, there is a difference).

It is critical that the properties be what you can get with a wet lay-up laminate under a vac. bag. Foam cores will not stand much post cure and so the resin modulus and hence resin to fiber load transfer will suffer.

Let's see if we can get the material properties to agree with actual fabrication processess.

Scott
sarmoby is offline Find More Posts by sarmoby
Reply With Quote
Old Apr 09, 2010, 06:26 AM
Launchpad McQuack
Prop-er's Avatar
Netherlands, Moordrecht
Joined Sep 2004
1,130 Posts
Hello Scott,

The material properties in the current spreadsheet version are taken from the free CLT software "Lamicens".

The software prescribes a Fiber volume fraction, which I didn't change.

For instance:
Fiberglass cloth 25 g/m² is calculated with a Vf of 25%
Fiberglass cloth 163 g/m² is calculated with a Vf of 37%

To me these values look achievable in wet layup vacbag setup.
In the still to be published new spreadsheet version 0.8 you can specify your own Vf.

The E11 values on a bias fabric are also a direct result from the Lamicens software. For a Carbonfibre cloth 160g/m² the E11, E22 and G12 are displayed here:



Notice the dramatic impact of bias orientation.

The resin properties in the current spreadsheet are:
E_resin: 3400 MPa
G_Resin: 1019 MPa

In the new version, resin properties can be manually changed.
It would be nice to include properties of some well known resins.

Vincent
Prop-er is offline Find More Posts by Prop-er
Reply With Quote
Old Apr 09, 2010, 01:39 PM
Composites guy
North OC, Ca.
Joined Jun 2005
1,176 Posts
Hi Vincent-

when I opened the Beta version( english) I noted the 3k twill laminate was 12.5 mils thick. Multiple sources ( albeit probably autoclaved and normalized to nominal CPT) put the thickness at "PLY THICKNESS: 0.0074-0.0085 in."- source http://snebulos.mit.edu/projects/ref...HDBK-17-2F.pdf
Mil handbook 17. Vac bag wet-lay-up is a bit thicker but that is alot thicker.
I have not yet been able to reference the link but I will check it later. Your resin properties are similar to the west systems physical properties (RT cure , no post cure)so that is good.
My main issue is the beta test spreadsheet properties, I assume the properties are the calculated output of the rule of mixtures E11= E11resin(1-Vf(fiber))+ E11fiber Vf(fiber).

My German limits my ability to use the lamicens software......

Scott
sarmoby is offline Find More Posts by sarmoby
Reply With Quote
Reply


Thread Tools

Similar Threads
Category Thread Thread Starter Forum Replies Last Post
Discussion Blistering on bagged wing jfinch Composites Fabrication 25 Jun 06, 2010 02:22 AM
Question best/fast/quick way to repair a bagged wing grfcon Slope 4 Jan 14, 2010 06:54 PM
Discussion What are your thoughts on a cf skinned bagged wing? GaryO Hand Launch 43 Dec 29, 2009 06:58 AM
Discussion Removing permanent marker from a bagged wing Neil Walker Slope 28 Dec 19, 2009 03:32 AM