Mechanics of Materials : With Applications in Excel book cover
1st Edition

Mechanics of Materials
With Applications in Excel

ISBN 9781466570719
Published June 21, 2016 by CRC Press
723 Pages 1057 Color Illustrations

SAVE ~ $33.00
was $165.00
USD $132.00

Prices & shipping based on shipping country


Book Description

Mechanics of Materials: With Applications in Excel® covers the fundamentals of the mechanics of materials—or strength of materials—in a clear and easily understandable way. Each chapter explains the theory of the underlying principles and the applicable mathematical relations, offering examples that illustrate the application of the mathematical relations to physical situations. Then, homework problems—arranged from the simplest to the most demanding—are presented, along with a number of challenging review problems, to ensure comprehension of key concepts.

What makes this book unique is that it also instills practical skills for developing Microsoft Excel applications to solve mechanics of materials problems using numerical techniques. Mechanics of Materials: With Applications in Excel® provides editable Excel spreadsheets representing all the examples featured in the text, PowerPoint lecture slides, multimedia simulations, graphics files, and a solutions manual with qualifying course adoption.

Table of Contents

Axial Loads
Internal Axial Force
Normal and Shearing Stresses
Normal Strain and Stress–Strain Diagrams
Load-Deformation Relations
Statically Indeterminate Members
Stress Concentration
Impact Loading
Review Problems

Torsional Loads
Internal Torque
Stresses and Deformations in Circular Shafts
Statically Indeterminate Shafts
Design of Power-Transmission Shafts
Stresses under Combined Loads
Stress Concentration
Impact Loading
Shafts of Noncircular Cross Sections
Elastoplastic Behavior
Review Problems

Bending Loads: Stresses
Internal Shear and Moment
Load, Shear, and Moment Relationships
Bending Stresses under Symmetric Loading
Shearing Stresses under Symmetric Loading
Stresses under Combined Loads
Allowable-Stress Design
Stress Concentration
Review Problems

Bending Loads: Additional Stress Topics
Beams of Two or Three Materials Loaded Symmetrically
Bending Stresses under Unsymmetric Loading
Thin-Walled Open Sections: Shear Center
Curved Beams
Elastoplastic Behavior: Plastic Hinge
Review Problems

Bending Loads: Deflections under Symmetric Loading
Moment–Curvature Relationship
Deflection: Two Successive Integrations
Derivatives of the Deflection Function
Deflection: Superposition
Deflection: Area–Moment
Statically Indeterminate Beams: Two Successive Integrations
Statically Indeterminate Beams: Superposition
Statically Indeterminate Beams: Area–Moment
Review Problems

Bending Loads: Additional Deflection Topics
Deflection: Singularity Functions
Deflection: Castigliano’s Second Theorem
Deflection: Unsymmetric Bending Loads
Statically Indeterminate Beams: Singularity Functions
Statically Indeterminate Beams: Castigliano’s Second Theorem
Impact Loading
Review Problems

Analysis of Stress
Stress at a Point
Components of Stress
Plane-Stress Transformation Equations
Mohr’s Circle for Plane Stress
Three-Dimensional Stress Systems
Thin-Walled Pressure Vessels
Thick-Walled Cylindrical Pressure Vessels
Theories of Failure
Review Problems

Analysis of Strain
Strain at a Point: Components of Strain
Plane-Strain Transformation Equations
Mohr’s Circle for Plane Strain
Three-Dimensional Hooke’s Law
Mohr’s Circle for Three-Dimensional Strain Systems
Strain Measurements: Strain Rosettes
Review Problems

Stability of Equilibrium
Euler’s Ideal-Column Theory
Effect of End Conditions
Secant Formula
Design of Centrically Loaded Columns
Design of Eccentrically Loaded Columns
Review Problems

Excel® Spreadsheet Applications
Spreadsheet Applications Concepts and Techniques
Example 1: Drawing Shear and Moment Diagrams
Example 2: Drawing Mohr’s Circle
Example 3: Principal Stresses in Three-Dimensional Stress Elements
Example 4: Computation of Combined Stresses
Excel Spreadsheet Application Projects

Answers to Even-Numbered Problems

Appendix A: SI Units

Appendix B: Selected References

Appendix C: Properties of Plane Areas

Appendix D: Typical Physical and Mechanical Properties of Selected Materials (U.S. Units and SI Units)

Appendix E: Design Properties for Selected Wide-Flange (W Shapes) Structural Steel Sections (U.S. Units and SI Units)

Appendix F: Design Properties for Selected Structural Wood Sections (U.S. Units and SI Units)

Appendix G: Beam Slopes and Deflections for Selected Cases

Appendix H: Two-Dimensional Supports and Connections

View More



Bichara B. Muvdi is a professor emeritus of the Department of Civil Engineering and Construction at Bradley University, Peoria, Illinois, USA. He received his B.M.E. and M.M.E. from Syracuse University, New York, USA, and his Ph.D. from the University of Illinois, Urbana-Champaign, Illinois, USA.

Souhail Elhouar is a professor and the chairman of the Department of Civil Engineering and Construction at Bradley University, Peoria, Illinois, USA. He received his B.Sc. from the National Engineering School of Tunis, University of Tunis - El Manar, Tunis, Tunisia, and his M.Sc. and Ph.D. from the University of Oklahoma, Norman, Oklahoma, USA.


"A distinguishing and very helpful feature of this textbook is that, in addition to the printed textbook and the companion solutions manual, the authors provide an electronic enhancement component that includes a chapter on the use of Microsoft® Excel® spreadsheets in mechanics of materials applications, … a multimedia-enhanced electronic version of some of the main concepts, … a textbook website, and model PowerPoint® presentations."
—Mahmoud Farag, The American University in Cairo, Egypt

"At an early stage of undergraduate education, it is important to educate and motivate students to use computers for scientific calculations. This book is a useful source for students who would like to take this path by using one of the most common and user-friendly software, Excel. Starting from basic strength of materials computations will allow them to make a smooth transition to the fascinating world of computational mechanics."
—Erkan Oterkus, University of Strathclyde, Glasgow, Scotland

"This book makes one of the subjects dreaded by mechanical and civil engineering students an enjoyable one. The theory is explained in a straightforward manner, the figures are there to supplement the text explanations, and the example problems help clarify many of the theoretical aspects. The spreadsheet applications not only add more understanding to the subject of the mechanics of materials, but also enhance students’ knowledge in numerical analysis and programming."
—Amara Loulizi, National Engineering School of Tunis, University of Tunis - El Manar

"… an excellent resource for undergraduate engineering students. … provides adequate theoretical backgrounds and illustrative examples. … can be adopted as a textbook for undergraduate engineering students for teaching them the fundamental concepts of the mechanics of materials."
—K.M. Liew, City University of Hong Kong, Kowloon