Mechanics of Materials With Applications in Excel

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 LoadsIntroductionInternal Axial ForceNormal and Shearing StressesNormal Strain and Stress–Strain DiagramsLoad-Deformation RelationsStatically Indeterminate MembersStress ConcentrationImpact LoadingReview Problems Torsional LoadsIntroductionInternal TorqueStresses and Deformations in Circular ShaftsStatically Indeterminate ShaftsDesign of Power-Transmission ShaftsStresses under Combined LoadsStress ConcentrationImpact LoadingShafts of Noncircular Cross SectionsElastoplastic BehaviorReview Problems Bending Loads: StressesIntroductionInternal Shear and MomentLoad, Shear, and Moment RelationshipsBending Stresses under Symmetric LoadingShearing Stresses under Symmetric LoadingStresses under Combined LoadsAllowable-Stress DesignStress ConcentrationReview Problems Bending Loads: Additional Stress TopicsIntroductionBeams of Two or Three Materials Loaded SymmetricallyBending Stresses under Unsymmetric LoadingThin-Walled Open Sections: Shear CenterCurved BeamsElastoplastic Behavior: Plastic HingeFatigueReview Problems Bending Loads: Deflections under Symmetric LoadingIntroductionMoment–Curvature RelationshipDeflection: Two Successive IntegrationsDerivatives of the Deflection FunctionDeflection: SuperpositionDeflection: Area–MomentStatically Indeterminate Beams: Two Successive IntegrationsStatically Indeterminate Beams: SuperpositionStatically Indeterminate Beams: Area–MomentReview Problems Bending Loads: Additional Deflection TopicsIntroductionDeflection: Singularity FunctionsDeflection: Castigliano’s Second TheoremDeflection: Unsymmetric Bending LoadsStatically Indeterminate Beams: Singularity FunctionsStatically Indeterminate Beams: Castigliano’s Second TheoremImpact LoadingReview Problems Analysis of StressIntroductionStress at a PointComponents of StressPlane-Stress Transformation EquationsMohr’s Circle for Plane StressThree-Dimensional Stress SystemsThin-Walled Pressure VesselsThick-Walled Cylindrical Pressure VesselsTheories of FailureReview Problems Analysis of StrainIntroductionStrain at a Point: Components of StrainPlane-Strain Transformation EquationsMohr’s Circle for Plane StrainThree-Dimensional Hooke’s LawMohr’s Circle for Three-Dimensional Strain SystemsStrain Measurements: Strain RosettesReview Problems ColumnsIntroductionStability of EquilibriumEuler’s Ideal-Column TheoryEffect of End ConditionsSecant FormulaDesign of Centrically Loaded ColumnsDesign of Eccentrically Loaded ColumnsReview Problems Excel® Spreadsheet ApplicationsIntroductionSpreadsheet Applications Concepts and TechniquesExample 1: Drawing Shear and Moment DiagramsExample 2: Drawing Mohr’s CircleExample 3: Principal Stresses in Three-Dimensional Stress ElementsExample 4: Computation of Combined StressesExcel 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.