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

    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.

    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


    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