Engineering with the spreadsheet : structural engineering templates using Excel

 Content: Worksheet --
 Editing in Excel --
 Math and editing --
 Symbols --
 Drawing in Excel --
 Pictures: importing AutoCAD drawings and pictures --
 Graphing --
 Application basics --
 Absolute and relative references --
 Circular reference --
 Logic: Boolean algebra and the ''If'' statement --
 Database --
 Regression analysis --
 Takedown --
 Embedded pole: an example of the shooting method --
 Numerical integration --
 Matrix math --
 Retirement home exhaust stack --
 Seismic calculation '97 UBC --
 Wind --
 Vortex shedding in tall stacks and vessels --
 Bolt patterns --
 Bolt threads: threads versus strength of bolt --
 Bolt group pullout --
 Roark flat plates --
 Foundation loading --
 Foundation design --
 Reinforced concrete beam --
 Concrete shear --
 Stack drawings --
 Elevated storage tank --
 Seismic calculations --
 Seismic calculations: ASCE/SEI 7-05 --
 Celerity: wave action --
 Load resistance factor design --
 Pile foundation --
 Two-way slab loading --
 Concrete biaxial column --
 Concrete biaxial column: composite circular column --
 Concrete biaxial column: partial shell --
 Concrete biaxial column: photographs --
 Concrete shear --
 Column deck interface --
 Slab-column moment shear transfer --
 Embed --
 LN2 bulk storage tank: test measurements --
 Reference Materials --
 LRFD compared to working strength loads --
 Acceleration --
 Quadratic and cubic equations --
 AutoCAD 2000 LISP routines --
 Units conversion --
 Notation.
 Abstract:             
              Introduces basic spreadsheet techniques and advanced applications. This book and CD-ROM present more than 50 actual templates in Microsoft Excel that demonstrate the techniques and specific applications for concrete, wind and seismic issues, foundation soil loading, the vortex shedding of tall stacks, and other engineering issues.                 Read more...