You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

Composite Panel Calculations.xlsx
This location is for Registered Users Only.
Perhaps you need to login or register.


Purpose of calculation:
Simply Supported Plate - width (b) greater than 1/3 of length (a). Because plate theory is more involved than beam theory, some 'charts' have been provided to give multipliers/coefficients (k1, k2, k3a & k3b) for use with plates simply supported on all four sides.

Calculation Reference

Calculation Validation

Reproduced result published in manual.

Calculation Procedure

1) Determine Panel Properties

  • Thickness of face material and core
  • Young's modulus of face and core
  • Shear modulus of core
  • Core allowable shear stress
  • Core Cell size
  • Poisson's ratio of face
  • Limiting stress in face
  • Buckling Safety Factor
  • Poisson's ratio term
  • Core shear modulus ratio
  • Distance between face centres
  • Critical intracell buckling stress
  • Critical face wrinkling stress

2) Panel Loading Assessment
  • Dimensions of panel
  • Panel pressure load
  • Panel deflection term
  • Lookup values from graphs (encoded on 'K1' worksheet)
  • Deflection of panel
  • Lookup values from graphs (encoded on 'K2' worksheet)
  • Max face stress
  • Lookup values from graphs (encoded on 'k3a' worksheet)
  • Core shear stress - a direction (W direction)
  • Lookup values from graphs (encoded on 'k3b' worksheet)
  • Core shear stress - b direction (L direction)

  • Epoxy UD CARBON tape (0°) 60% volume fraction
  • Epoxy UD GLASS tape (0°) 55% volume fraction
  • Epoxy WOVEN CARBON (G793-5HS) 55% volume fraction
  • Epoxy WOVEN ARAMID (285K-4HS) 60% volume fraction
  • Epoxy WOVEN GLASS (7781-8HS) 50% volume fraction
  • Phenolic WOVEN GLASS (7781-8HS) 55% volume fraction
  • ALUMINIUM Alloy 2024 T3
  • ALUMINIUM Alloy 5251 H24
  • ALUMINIUM Alloy 6061 T6
  • STEEL carbon 1006
  • STEEL carbon 1017
  • Exterior PLYWOOD Fir
  • Tempered HARDWOOD Teak

  • 3003 Aluminium  29kg/m³
  • 3003 Aluminium  37kg/m³
  • 3003 Aluminium  42kg/m³
  • 3003 Aluminium  54kg/m³
  • 3003 Aluminium  59kg/m³
  • 3003 Aluminium  83kg/m³
  • 5052 Aluminium  37kg/m³
  • 5052 Aluminium  50kg/m³
  • 5052 Aluminium  54kg/m³
  • 5052 Aluminium  72kg/m³
  • 5052 Aluminium  83kg/m³
  • 5052 Aluminium  127kg/m³
  • 5052 Aluminium  130kg/m³
  • 5056 Aluminium  37kg/m³
  • 5056 Aluminium  50kg/m³
  • 5056 Aluminium  50kg/m³
  • 5056 Aluminium  72kg/m³
  • HRH10 Nomex (Aramid) 29kg/m³
  • HRH10 Nomex (Aramid) 32kg/m³
  • HRH10 Nomex (Aramid) 32kg/m³
  • HRH10 Nomex (Aramid) 48kg/m³
  • HRH10 Nomex (Aramid) 48kg/m³
  • HRH10 Nomex (Aramid) 64kg/m³
  • HRH10 Nomex (Aramid) 64kg/m³
  • HRH10 Nomex (Aramid) 80kg/m³
  • HRH10 Nomex (Aramid) 96kg/m³
  • HRH10 Nomex (Aramid) 123kg/m³
  • HRH10 Nomex (Aramid) 144kg/m³
  • HRH10 Nomex (Aramid) 29kg/m³
  • HRH10 Nomex (Aramid) 48kg/m³

Calculation Reference
Composites Design
Composite Materials
Composite structures

Submitted By:
John Doyle (JohnDoyle[Admin])
Submitted On:
19 Feb 2010
File Size:
189.45 Kb
File Version:
File Author:
John Doyle
Total Votes:7
Comments: 3
JohnDoyle[Admin] 5 years ago
As the description says XLC must be installed for this calculation to work. XLC works with all versions of Excel including Excel 2013. I have downloaded this file and it loaded without error when XLC is installed. To check that XLC is installed and working correctly perhaps you could type the following formula into a cell"=OVD(1)/UND(2)" If you get a #NAME error then XLC is not installed.
The error you describe is [url=]#VALUE[/url] which does not suggest that the problem is with XLC. Follow the link to try to diagnose your problem.
RAMULUS 5 years ago

I have some issues with the mutipliers/coefficients.They appear as #Value at I9 and I19,etc... . I have already installed the XLC ribbon and the XLC toolbar. Do you have any idea of the problem?

Thank you

P.S. I have the 2013 office edition
dreamctr 6 years ago
I'm interested in buying 'Composite Panel Calculations.xlsx'. I wonder if I can put in my own material properties and select the pre-loaded material properties as well.

Let me please know your thoughts.

We have 303 guests and 5 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.