Bibliographic record and links to related information available from the Library of Congress catalog.
Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.
Table of Contents An asterisk (*) indicates chapters in the book but not on the CD-ROM. 1. Introduction* 1 Some History 0 Part 1: A Few of the Basics* 5 2. Tips 7 Using This Book and CD 0 Adjusting Excel for Ease of Use 0 Printing a Directory 0 Using Links 0 Removing Links 0 3. Worksheet 0 Headers 0 Date, Time, and File Stamps 0 Guide to Row Numbers 0 Notes 4. Editing in Excel 0 Subscripting and Superscripting 0 Editing Super/Subscripts and Other Characters 0 Formatting English Characters to Greek Math Characters 0 Make Your Own Math Operators 0 Adjustable Text 0 Conditional Formatting 0 Formatting a New Sheet or Tab 0 The Trace Command 0 5. Math and Editing 0 Overview 0 Boolean Algebra and the If Statement 0 Equation Editing 0 Adding Equations with Justify 0 Another Example of Park and Concatenate 0 Putting the Justify Button in the Toolbar 0 Range Names 0 Fill: Drag from Beginning Numbers to Get a Trend 0 Transpose: Column to Row, Row to Column 0 6. Symbols 0 Character Map 0 Characters To Be Copied 0 Greek Characters That Show as Range Names 0 Formatting Characters Used as Range Names 0 Keypad Entry Directly into the Spreadsheet Cell 0 7. Drawing in Excel 0 Getting Started 0 Example: Box 0 Example: Arc and Pointer 0 Drawing Lines 0 Example: Diagrams 0 8. Pictures: Importing AutoCAD Drawings and Pictures 0 AutoCAD Drawings 0 Diagrams with Background 0 Diagrams without Background 0 Photographs 0 9. Graphing 0 Graphing Rectangles 0 3D Array 0 3D Spiral 0 3D Box: Simple Projection 0 3D Box: Orthographic Projection 0 Part 2: Application Basics* 0 10. Absolute and Relative References 0 Overview 0 Moving an Entire Module That Includes Absolute References 0 Copying an Entire Module That Includes Absolute References 0 Alternative: Copy an Array or Module Back into the Same Template 0 11. Circular Reference 0 12. Logic: Boolean Algebra and the If Statement 0 Overview 0 Park and Concatenate 0 Park, Concatenate, and Justify 0 Range Names in Equations 0 Other Logic Functions 0 The Logic Sieve, Boolean Algebra, and Boolean Operators 0 13. Database 0 D Direct Database Functions 0 Sort the Sample Database 0 Filter the Sample Database 0 14. Regression Analysis 0 Getting Started 0 An Example 0 Straight Line Regression Analysis: Least Squares 0 LINEST Value 0 Multi-Straight Line Regression Analysis 0 The F Coefficient 0 Curvilinear Regression Analysis 0 15. Takedown 0 Kraft Pulping 0 16. Embedded Pole: An Example of the Shooting Method 0 Pole Foundation: Lateral Bearing Type Foundation 0 Notes 0 The Shooting Method 0 Worksheet 0 17. Numerical Integration 0 Overview 0 Footing Design 0 Numerical Integration for W8 x 31 0 Conditional Formatting 0 Numerical Integration for W8 x 31: For XY area 0 Summary of Results 0 AutoCAD Mass Properties 0 18. Matrix Math 0 Matrix Math 0 Matrix Solution 0 3x3 Matrix: Circuit Analysis, Longhand Matrix Solution 0 3x3 Matrix: MINVERSE and MMULT Excel Method 0 4x4 Matrix Model: Longhand Solution 0 4x4 Matrix Model: Using MDETERM 0 4x4 Matrix: MINVERSE and MMULT Excel Method 0 Part 3: Retirement Home Exhaust Stack* 0 Comments on Calculations and Drawings* 0 19. Title Page and Table of Contents 0 20. Seismic Calculation '97 UBC 0 Seismic Calculation Worksheet 0 Seismic Coefficient CA 0 Seismic Coefficient CV 0 Near-Source Factor Na 0 Near-Source Factor Nv 0 Near-Source Calculations 0 Seismic Calculation Worksheet 0 21. Wind 0 Wind '97 UBC 0 Wind Overturning: Incremental Moments 0 Verification of Table Values 0 22. Vortex Shedding in Tall Stacks and Vessels: Introduction* 0 23. Vortex Shedding in Tall Stacks and Vessels 0 Summary 0 Tank/Stack Design 0 Method of Superposition for Wind Deflection 0 Method of Superposition for Seismic Deflection 0 Natural Frequency of a Structure 0 Vortex Shedding and Forces on the Cylinder 0 Critical Wind Velocities 0 Overturning Moment with Foundation Magnification Factor 0 Cantilever Vibration 0 Deflection Calculated as Static Deflection 0 Allowable Shell Buckling Stress 0 Ovaling 0 Stiffener Design 0 Breeching 0 24. Bolt Patterns 0 Bolt Circle 0 Four Legs: Circular Base Plates with Four Bolts 0 25. Bolt Threads: Threads versus Strength of Bolt 0 Bolt Threads 0 Bolt Strength 0 Bolt Grade Values 0 Summary 0 Combined Loads for the Unity Equation 0 Bolt Threads 0 Bolt Grades 0 Steel Grades 0 Graphing Ranges 0 26. Bolt Group Pullout: Introduction* 0 27. Bolt Group Pullout 0 Shear Friction Connection: Punching Shear 0 Shear Friction Connection: Strength of Bolt 0 Shear Friction Connection: Base Plate Sliding / Shear Plate 0 Shear Friction Connection: Bearing against Anchor Plate 0 Anchorage to Concrete 0 28. Roark Flat Plates 0 Flat Circular Plates: Constant Thickness 0 29. Foundation Loading: Introduction* 0 Footing Configurations 30. Foundation Loading 0 Trapezoidal Soil Loading: All Edges Loaded Triangular Soil Loading for Rotation in X or Y only 31. Foundation Design 0 Concrete Design in Uplift 0 LRFD Factoring 0 Concrete Design in Bearing 0 32. Reinforced Concrete Beam: Introduction* 0 33. Reinforced Concrete Beam 0 Concrete Beam Design 0 Stress-Strain Relationships 0 Depth of Compression Block 0 Moment of Inertia 0 Effective Moment of Inertia 0 Creep vs. Time in Months 0 Verifying Graphs 0 34. Concrete Shear 0 Punching Shear 0 Beam Shear 0 35. Stack Drawings* 0 Part 4: Elevated Storage Tank* 0 36. Introduction* 0 37. Title Page and Table of Contents 0 38. Seismic Calculations 0 Seismic Calculation Worksheet 0 Seismic Coefficient CA 0 Seismic Coefficient Cv 0 Near-Source Factor Na 0 Near-Source Factor Nv 0 Near-Source Calculations 0 Seismic Calculation Worksheet (continued) 0 39. Seismic Calculations: SEI/ASCE 7-05 0 40. Celerity: Wave Action 0 Output Summary 0 Overturning Moment 0 Righting Moment 0 Approximations of API Tables 0 41. Load Resistance Factor Design 0 42. Pile Foundation 0 Summary for Tank and Foundation 0 Design Loads for Frame Analysis Program 0 Extended Piling Through Pile Cap to Deck 0 Loads to Deck Mid-Line Using ASCE 7-02 Strength Design 0 Loads to Deck Mid-Line Using ASCE 7-05 Strength Design 0 Generate ASD ASCE 7-02 Loads for Deflection Calculations 0 Generate ASD ASCE 7-05 Loads for Deflection Calculations 0 43. Two-Way Slab Loading 0 Column Strips 0 Two-Way Slab Loading 0 44. Concrete Biaxial Column: Introduction* 0 Flow Diagrams 0 Notations Calculations 45. Concrete Biaxial Column: Composite Circular Column 0 Concrete Circular Column Design 0 XX Column Lengths and Loads for Bending about the X-Axis 0 YY Column Lengths and Loads for Bending about the Y-Axis 0 Biaxial Column Summary 0 Column Slenderness and Moment Magnifier for the X-Axis 0 Column Slenderness and Moment Magnifier for the Y-Axis 0 Moment Magnifier Logic Sieve 0 Column Combined Loadings for Biaxial Analysis 0 Reinforcing Area and Layout 0 Plastic Centroid Inertia Calculations 0 Radius of Gyration 0 Plastic Centroid Strain Calculations 0 Es* Strain 0 Reinforcing Location Logic 0 Reinforcing Strain 0 Math for Rectangular Rotating Compression Block 0 Math for Semicircular Rotating Compression Block 0 46. Concrete Biaxial Column: Partial Shell 0 Partial Shell Math 0 Entire Shell Math 0 47. Concrete Biaxial Column: Photographs 0 48. Concrete Shear 0 Bearing on Concrete 0 Circular Punching Shear 0 Stirrup Reinforcing 0 Inclined Bar Reinforcing 0 Torsion 0 Beam Shear 0 For Members Subject to Shear and Flexure 0 Photographs 49. Column Deck Interface 0 Design for Moment Transfer Without the Shear Transfer Mechanism 0 Shear Stud Punching 0 Photographs 0 50. Slab-Column Moment Shear Transfer 0 51. Bolt Group Pullout 0 Anchorage to Concrete: Tension, Fully Encased Bolt 0 Anchorage to Concrete: Tension, Fully Encased Group of Bolts 0 Anchorage to Concrete: Shear, Fully Encased Bolt 0 52. Embed 0 Bar Development and Hooks 0 Tension Hook 0 Lap Splice with Tension 0 Lap Splice in Compression 0 Photograph 0 53. Reinforced Concrete Beam 0 Concrete Beam Design 0 Photographs 0 54. LN2 Bulk Storage Tank: Test Measurements 0 Summary 0 Laser Level Setup 0 Column Shortening 0 Part 5: Reference Materials* 0 55. LRFD Compared to Working Strength Loads: Introduction* 0 Allowable Stress Design versus Load Resistance Factor Design 56. LRFD Compared to Working Strength Loads 0 Load Factor Resistance Design 0 Foundation in Overturning: Trapezoidal Loading 0 Foundation in Overturning: Triangular Soil Loading 0 LRFD Factoring 0 57. Acceleration 0 Introduction 0 Jumping 0 Gravity and Thrust 0 Gyroscopic Precession 0 58. Quadratic and Cubic Equations 0 Y = mX + b 0 Quadratic Equation 0 Cubic Equation Algebraic and Trigonometric Solution 0 Cubic Equation Graphing 0 The Shooting Method 0 Curve Fitting with Excel Trendline 0 59. AutoCAD 2000 LISP Routines 0 Creating an ASCII File 0 Reading with the LISP Routine 0 60. Units Conversion 0 Units Conversion 0 Notation 0 61. Notation 0 General 0 Bolts 0 Celerity: Wave Action 0 Concrete Pullout 0 Concrete Foundation Design 0 Seismic 0 Statistics 0 Vortex 0 Wind 0 References 0 Index 0 About the Author 0
Library of Congress Subject Headings for this publication:
Engineering -- Data processing.
Microsoft Excel (Computer file).
Electronic spreadsheets.