Mechanics of Materials: With Applications in Excel, 1st Edition (Hardback) book cover

Mechanics of Materials

With Applications in Excel, 1st Edition

By Bichara B. Muvdi, Souhail Elhouar

CRC Press

707 pages | 1057 Color Illus.

Purchasing Options:$ = USD
Hardback: 9781466570719
pub: 2016-06-21
eBook (VitalSource) : 9781315374314
pub: 2016-09-19
from $28.98

FREE Standard Shipping!


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.


"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

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

About the Authors

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.

Subject Categories

BISAC Subject Codes/Headings:
SCIENCE / Mechanics / General