Spreadsheet on composites properties
Spreadsheet on composites properties
(OP)
Dear All,
First of all thank you for all the information this forum has provided me. This is my first post as I have just been graduated in Naval Architecture; so I am not a composites expert but can expect to design parts at some point.
It is very hard to find free spreadsheets on the internet to calculate laminate properties as it seems that everyone keeps its own. So I am happy to give this one, which is just basic for the moment but will hopefull grow with time (cores, outer skins, stresses at each ply, etc.). But before I go further, I would be happy if some of you could double-check the results obtained as I do not have a feel for all these numbers yet. No doubt this will come with experience.
So here is how it works:
- Page one is used to define the materials properties. So that it is pretty easy to make the spreadsheet evolve with time. I you don't think that have changes to make for the moment
- Page two is the calcultor itself. Just play with the yellow cells and see the results appear.
- Page three is the formulae references: very basic rules of mixture for the moment.
Sorry for my spelling mistakes but I am french. Thanks by advance for all your constructive comments.
Best regards, Vincent
First of all thank you for all the information this forum has provided me. This is my first post as I have just been graduated in Naval Architecture; so I am not a composites expert but can expect to design parts at some point.
It is very hard to find free spreadsheets on the internet to calculate laminate properties as it seems that everyone keeps its own. So I am happy to give this one, which is just basic for the moment but will hopefull grow with time (cores, outer skins, stresses at each ply, etc.). But before I go further, I would be happy if some of you could double-check the results obtained as I do not have a feel for all these numbers yet. No doubt this will come with experience.
So here is how it works:
- Page one is used to define the materials properties. So that it is pretty easy to make the spreadsheet evolve with time. I you don't think that have changes to make for the moment
- Page two is the calcultor itself. Just play with the yellow cells and see the results appear.
- Page three is the formulae references: very basic rules of mixture for the moment.
Sorry for my spelling mistakes but I am french. Thanks by advance for all your constructive comments.
Best regards, Vincent





RE: Spreadsheet on composites properties
Rob Stupplebeen
RE: Spreadsheet on composites properties
Is this the way I should go to take into account all the differences in orientation, fibre weight fraction fibre, matrix, stacking sequence? Or do you think there is a more approriate way to do this?
If someone has an example, I would be really grateful as this is quite a lot of work and I would like to make sure that I am in the right direction.
Thanks to all. Vincent
RE: Spreadsheet on composites properties
Also, with the woven roving you've taken the fibre/matrix property in the '0' direction to be the same as for UD, then also used this as the WR '90' modulus. If calculating the woven material's lamina properties from micromechanics you need to take account of the proportion of fibres in the 1- and 2-directions. Additionally, with woven material the fibre properties are not fully realised because of fibre crimp when in woven form. Roughly speaking, your micromechanics-calculated '0' and '90' moduluses should be halved, and an additional arbitrary knockdown of about 0.9 applied for crimp.
An option to enter the lamina properties without the micromechanics stage would help with this, as there is no easy way to calculate the crimp knockdown factor.
I haven't checked your calcs on ply directions yet.
(NB: you've tended to use '0°' to mean the direction of the fibres when calculating the lamina properties. It's more conventional to use the term '1-direction' for this, and reserve the terms '0°', etc., for the laminate.)
RE: Spreadsheet on composites properties
http:/
(DOT/FAA/AR-95/29 "Fiber Composite Analysis and Design: Composites Materials and Laminates, Volume 1".)