Elastic and inelastic thermal shock analysis for simple shapes subject to convective heat transfer and the use of spreadsheets to automate this analysis is described. The completed spreadsheet application serves as a design tool to quickly calculate the elastic thermal stress distribution at peak loading or the residual stress distribution for inelastic regime. Spreadsheets were developed for the heating and cooling of a flat plate or wall, a beam, solid cylinder, and disc. The design tool results for elastic behavior are in good agreement with numerical methods over a wide range of Biot number. Inelastic analysis assumes elastic perfectly plastic behavior, and an approximate method is used to model it. Design tool results for inelastic analysis are also in good agreement with the literature for moderate values of Biot number with constant yield strength. The inclusion of temperature dependent yield stress and comparison with numerical methods is shown to give fair agreement.
- Heat Transfer Division and Electronic and Photonic Packaging Division
Spreadsheet-Based Design Tool for the Analysis of Thermal Shock
- Views Icon Views
- Share Icon Share
- Search Site
Bull, JD, & Yee, RK. "Spreadsheet-Based Design Tool for the Analysis of Thermal Shock." Proceedings of the ASME 2005 Summer Heat Transfer Conference collocated with the ASME 2005 Pacific Rim Technical Conference and Exhibition on Integration and Packaging of MEMS, NEMS, and Electronic Systems. Heat Transfer: Volume 3. San Francisco, California, USA. July 17–22, 2005. pp. 787-793. ASME. https://doi.org/10.1115/HT2005-72736
Download citation file: