1st Edition

# Mechanics of Materials With Applications in Excel

By Bichara B. Muvdi, Souhail Elhouar Copyright 2016
723 Pages 1057 Color Illustrations
by CRC Press

723 Pages 1057 Color Illustrations
by CRC Press

Also available as eBook on:

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.

Introduction
Internal Axial Force
Normal and Shearing Stresses
Normal Strain and Stress–Strain Diagrams
Statically Indeterminate Members
Stress Concentration
Review Problems

Introduction
Internal Torque
Stresses and Deformations in Circular Shafts
Statically Indeterminate Shafts
Design of Power-Transmission Shafts
Stress Concentration
Shafts of Noncircular Cross Sections
Elastoplastic Behavior
Review Problems

Introduction
Internal Shear and Moment
Allowable-Stress Design
Stress Concentration
Review Problems

Introduction
Beams of Two or Three Materials Loaded Symmetrically
Thin-Walled Open Sections: Shear Center
Curved Beams
Elastoplastic Behavior: Plastic Hinge
Fatigue
Review Problems

Introduction
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

Introduction
Deflection: Singularity Functions
Deflection: Castigliano’s Second Theorem
Statically Indeterminate Beams: Singularity Functions
Statically Indeterminate Beams: Castigliano’s Second Theorem
Review Problems

Analysis of Stress
Introduction
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
Introduction
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

Columns
Introduction
Stability of Equilibrium
Euler’s Ideal-Column Theory
Effect of End Conditions
Secant Formula
Review Problems

Introduction
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

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

### Biography

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