This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Calculation Preview

A spreadsheet to calculate the displacements and stresses in an open ended cylindrical shell subject to a radial temperature gradient across its thickness.

This spreadsheet calculates the deflection and stresses in an open ended cylindrical shell wall subject to a radial temperature gradient through its wall thickness, along its entire length. The calculation assumes that the mean temperature, ₸, of the shell is zero. For a non zero mean temperature the radial displacement will simply increase by αR₸ whilst the stresses remain unchanged for an unrestrained shell. The open and free end of the cylindrical shell is assumed to be remote from any restraint that might affect the radial displacements and stresses produced by the radial temperature gradient.

Shell behaviour
At the free edge of the cylindrical shell wall the radial temperature gradient introduces bending and maximum deflection, whilst at a distance remote from the free end there is no radial deflection for the assumed zero mean temperature. The maximum radial deflection at the free end induces maximum hoop membrane stresses which in combination with bending stress produces the maximum surface stress in the cylinder wall. Away from the free end of the cylinder wall stresses tend towards a constant value.

Radial stresses are assumed to be negligible along the cylindrical shell wall in comparison to induced hoop and axial stress components.

The method was obtained from Timoshenko and Woinowsy, Theory of Plates and Shells.

Named ranges are used throughout so that cell formulae can be easily discerned.

The system of units can be chosen in reference to units of length. Other units have been chosen to
be consistent with that unit of length. No conversion of units is used in the spreadsheet.

The results from the example given compare with finite element results using the Abaqus software

Calculation Reference
Timoshenko and Woinowsy, Theory of Plates and Shells
| Find on | Find on | Find on | Find on | Find on |
Thermal Stress Analysis
| Find on | Find on | Find on | Find on | Find on |
Pressure Vessel Design
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. 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:
26 Jan 2015
Submitted By:
File Date:
24 Jan 2015
File Author:
David Backhouse
File Version:
File Size:
155.00 Kb
File Type:
stars/5.gifTotal Votes:1
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.


#1 JohnDoyle[Admin] 2015-01-26 10:42
Another great spreadsheet Dave. Thank you once again.

Please sign in or register to add a comment.

We have 9 guests and 41 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics