## Plates

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.
Description:
Calculation Preview

A very simple set of calculations to establish the maximum stress and deflection in flat plates under a variety of support and loading condtions. The calculations allow very convenient initial estimates of plates strengths to be carried out. (14 plate arrangements are included)

Purpose of Calculation
Calculation of maximum stress and deflection in thin plates under a variety of support and loading conditions

Roymech.co.uk.  http://www.roymech.co.uk/Useful_Tables/Mechanics/Plates.html

Calculation Validation
The various calculations have been checked against other methods of calculating the  values (see my webpage)

Introduction

This page includes simple formula for the calculation of the maximum stress and deflection for thin flat plates under a variety of support and loading conditons.
The equations are only valid if the deflection is small compared to the plate thickness.equations are also only reasonably accurate if the thickness is less than 10% of the diameter.
The loading scenario for the simply supported rectangular plates assume that the upper edges of the loaded surface are restrained from lifting such that all of the edges are in contact during the the loading condition.

List Of Calcs

1) Circular Plate ,Simply supported under uniform distributed load  p
2) Circular Plate ,Clamped under uniform distributed load  p
3) Circular Plate ,Simply Supported under central Force  P
4) Circular Plate ,Clamped under central Force  P
5) Rectangular Plate  , Simply supported, Uniform Load .
6) Rectangular Plate  , Clamped, Uniform Load .
7) Rectangular Plate  , Simply supported, Concentrate load over small area
8) Rectangular Plate  , Clamped, Concentrate load over small area
9) Circular Plate with Central Hole , Simply supported,Central Load
10) Circular Plate with Central Hole , Simply supported, Uniform Load Over Plate
11) Circular Plate with Central Hole , Clamped, Uniform Load Over Plate
12) Circular Plate with Central Hole ,Outer Edge Clampld, Uniform Load Over Plate

Calculation Reference
Mechanical Engineers Data Handbook Carvill Butterworth Hieneman

Roarks Formulas for stress and strain

Formulas for Stress, Strain, and Structural Matrice

Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
22 Aug 2016
Submitted By:
roymech1
File Date:
22 Aug 2016
File Author:
Roy Beardmore
File Version:
2.1
File Size:
267.93 Kb
File Type:
xlsx
XLC:
This download requires the XLC Add-in for Excel to be installed.
Downloads:
403
Rating:
Total Votes:7
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

#### Comments

#4 JohnDoyle[Admin] 2016-08-22 06:32
BHT thank you for reporting in this error. Sadly Roy Beardmore, the file author has died. I have examined the equations for case 7 and I believe that you are indeed correct. In fact case 8 has made the same mistake. I have corrected them both and uploaded a new calculation version 2.1. I notice that when Roy has used the lower case "p" it is a pressure but an upper case "P" is a force. I have extended your XLC Pro subscription by 1 month as a way of saying thanks for taking the time to report this in.

#3 BHT 2016-08-19 01:06
Hello,

Just a query regarding equation 7 on this spreadsheet. Should central Load P be input in N not N/mm2 as shown?

#2 JohnDoyle[Admin] 2014-06-05 15:08
The spreadsheet uses the XLC add-in so You will need to install this first [see FAQ's].

#1 smeatho 2014-06-05 13:26
Using Plates spreadsheet and as soon as I input any figures the stress results change to #Name?

Please sign in or register to add a comment.

We have 8 guests and 49 members online
Contact Us
Email (preferred method of contact)
US +1 617 5008224
EU +44 113 8152220
Our Feeds