Engineering Spreadsheets - A huge collection
A spreadsheet is a computer application that simulates a paper worksheet where becoming increasingly popular in
solving engineering related problems. Among the strong features of spreadsheets are their instinctive cell-based
structure and easy tuse capabilities. Excel, for example, is a powerful spreadsheet with VBA robust programming
capabilities that can be a powerful tool for teaching civil engineering concepts.
Spreadsheets can dbasic calculations such as cost estimates, schedule and cost control, and markup estimation, as
well as structural calculations of reactions, stresses, strains, deflections, and slopes. Spreadsheets can solve complex
problems, create charts and graphs, and generate useful reports. This paper highlights the use of Excel spreadsheet
and VBA in teaching civilengineering concepts and creating useful applications.
The Engineering Community provide Excel Spreadsheets for Civil St Structural Engineers for structural design.
All spreadsheets that you can download are fully functional.
This collection includes following spreadsheets under following categories,
Geotechnicaldesign
Structural R/F concrete
Structural steel design St detailing
Bridge design
Timberdesign
Structuraldynamics
Wind load calculation
Hydraulics and HydrologyContent
Civil Engineering Spreadsheets
Structural Details
Geotechnical Spreadsheets
Finite Element Method (FEM) Spreadsheets
1.12GB
Download
http://s15.alxa.net/001/007/Engineer...readsheets.zip
A spreadsheet is a computer application that simulates a paper worksheet where becoming increasingly popular in
solving engineering related problems. Among the strong features of spreadsheets are their instinctive cell-based
structure and easy tuse capabilities. Excel, for example, is a powerful spreadsheet with VBA robust programming
capabilities that can be a powerful tool for teaching civil engineering concepts.
Spreadsheets can dbasic calculations such as cost estimates, schedule and cost control, and markup estimation, as
well as structural calculations of reactions, stresses, strains, deflections, and slopes. Spreadsheets can solve complex
problems, create charts and graphs, and generate useful reports. This paper highlights the use of Excel spreadsheet
and VBA in teaching civilengineering concepts and creating useful applications.
The Engineering Community provide Excel Spreadsheets for Civil St Structural Engineers for structural design.
All spreadsheets that you can download are fully functional.
This collection includes following spreadsheets under following categories,
Geotechnicaldesign
Structural R/F concrete
Structural steel design St detailing
Bridge design
Timberdesign
Structuraldynamics
Wind load calculation
Hydraulics and HydrologyContent
Civil Engineering Spreadsheets
PHP Code:
Abutment Column Design
ACI 318-08 Rec Sect Mx -0-Torsion Design
ACI 350 8 ACl224R-01 Rectangular Section Flexural Crack Width Control
ACI 350.3-06 Seismic Loads for Liquid-Containing Rectangular RC Tank
AISC-ASD89 calculation for Beam-Column member
Analysis for Flat roof systems in structural steel
Analysis of Pile Groups with Rigid Caps
Anchor Reinforcement
Anchor Reinforcement Metric Version
Appendix D - Anchor Bolt Anchorage
Appendix D - Anchor Bolt Anchorage AC! 318
Application for Generation of Height Span Charts Gable Frame Sheds
ASCE 7-10 Load Combinations
ASCE710W - ASCE 7-10 Code Wind Analysis Program
Axial load capacities of single plates per AISC
Beam Investigation
Beaming Capacity for 2006 International Building Code
Bored Piles Wall and Ground Anchors
Bridge Concrete Deck Design
Bridge Design and Analysis
Calculator assessment of timber structures tAS1720
Calculator for assessment of cold formed steel structures tAS4600
Calculator for assessment of steel structures tAS4100
Calculation of Plane Truss
Cold Formed Steel Sheds Australia Height Span Limits of C-Sections
Composite Column
Concrete Beam Design (CSA A2311-94)
Concrete slabs on grade
Concrete Special Structural Wall ACI 318-08
Corbel
Corbel Design (CBDM)
Design of Prestressed Double Tee Beams
Design of RCC Trench
Earthquake Lateral Forces
Elastomeric Bearing Design
Foundation Support of a Tank
Gable Canopy tAustralian Codes
IBC 2006 Seismic Calculation
lBC2000E - Seismic loading analysis for buildings and various non building structures
lBC2003E - Seismic loading analysis for buildings and various non building structures
lBC2006E - Seismic loading analysis for buildings and various non building structures
lBC2009E - Seismic loading analysis for buildings and various non building structures
Loads Beam Slab and Spread Footing
Loads beneath Rigid Pile Caps or Rafts
Mast- Supporting Guyline
Member Design - Reinforced Concrete Beam B58il0
Micropile Structural Capacity Calculation
RCI Stud Tension Breakout
Pile design
Prestressed Girder Design
RC Element Design tIndian Standards
RC Rectangular Section Design tBS8l i 0 Part i 8 2
Re Bars
Re Bars (318 -05)
Re Bars (318-08)
Re Bars (3i8M-05)
Rectangular HSS 8 Box Shaped Members
Rectangular HSS 8 Box Shaped Members - Combined Bending Shear and Torsion
Rectangular Section Flexural Crack Width Control
Reinforced Concrete Staircase ACI-318-08
Reinforced Concrete Circular Columns
Reinforced Concrete Rad Footing AS3600 Compliant
Reinforced Concrete Rectangular Columns
Reinforced Concrete Sections tBS 8007
Retaining Wall Calculation
Retaining Wall Design
Retaining Walls
Roof Deck
Sheet Piling
Slab Design Base on BS Code
Snow Loading on FLat Roof
Soil Bearing Capacity Calculation
Standard hook bars in tension for AC! 318-08
Steel Roof and Floor Deck
Stresses Beneath Pads Under Eccentric Loads
UBC97 Earthquake Lateral Forces
US Steel Sheet Pile Design
X-bracing Design
All Structural Section Tables
Beam on Elastic Foundation Analysis
Concrete Design
Design of Structural Elements
Engineering with the spreadsheets
Footing Design
GoBeam
International Lateral Loads
Lateral Programs
Masonry Design
Misc Spreadsheets
Other Structural Spreadsheets
RC Stair design according to BS 8110
RC Spreadsheet vi
RC Spreadsheet v3
RC Spreadsheet v4a
Response Spectrum Workbook
Steel Design Spreadsheets
Structural Design Spreadsheets
Structural Tool Kit 3.37
UBC Seismic Calculations
WSBeam
AASHTO LRFD Slab
ACl3l8-08 RC Beam
Aluminum Capacity Design
Aluminum Rectangular Tube Design
Beam Analysis Spreadsheet
Beam Analysis Spreadsheet (Metric)
Beam Design Functions
Beam Reactions
Beam with stress
Beams
Beams on Elastic Foundation
BS 5950 Circular Hollow members
Built-in beam with 2 symmetric point loads
Checking Steel Members with Various Reinforcements
Continuous Beam Analysis (up to 4 spans)
Continuous Concrete Beams
Crane Design Guide to BS5950
Curved Beams
Design of Rectangular Column
EC3 Calculations
Enhanced Beam Analysis and Design
Flexure and Torsion of Single Angles
FRP Reinforcement of RC Beams Si Slabs
Grating Aluminum Beam Design
Historic 1939 UK Steel Section Properties
Indian Steel Sections
Influence lines in continuous beam
Structural Details
PHP Code:
AISC-LRFD HSS Bracing Punch Plate Connection
AISC-LRFD-HSS-Virendeel Connections
AISC-Weld calculation for built up beams
Analysis and Design of Steel Columns St Beams
Analysis of steel beam end connections using double clip an
Analysis of steel beams subject to concentrated loads
Analysis of Steel Column Base Plate
Anchor Bolt anchorage
Angle Seat Detail
Angle Section Properties
Angle type tension fitting
Base Plate analysis
Bolted Connection Angle Brace Tension
Bolted End Plate Splice Apex Connection of Portal Frame
Calculation for mixed concrete-wood floor
Channel type tension fitting
Check of Tubular Members as per API RPZA - LFRD Code
Beam Connections using clip angle
Coped W-Beam seat
Dayton-Shear-Reinforcement-System-For-Round-Columns
Dayton-Shear-Reinforcement-System-For-Square-Columns
Deck Slab
Design of anchorage for underground storage tanks
Design of Moment Connection
Design of Plate Elements
Design of Spread Footing
Embedment Strength of stud plate
Gusset Plate Connection for Truss
Load Combinations
Mast Design
Member Design - Steel Beam Column design to BS5950
Method of Jet Grouting
Monorail Design
Offshore Tubular Joints Punch Check as per API-WSD
Plates straps and rivets
Pole Foundation IBC 2003
Pre-Cast Column Connection Design
Precast Concrete Plank
Rectangular Spread Footing Analysis
Rectangular Steel Bar Design
Roof Purlin Design
Semi-Circular Tension Fitting
Shackle Calculations
Shear Friction ACI 318-02
Shear Lug Design
Simple Shear Connection Design AISC
Snap Fit Beam Calculator
Spread Footing_vl_04
Stair Stringer Design
Steel Beam Bearing Plate Design
Steel Beam End Connection Design
Steel Beam with Web Openings
Steel Reinforcing Platefor Masonry
Stress in a plate due to a point load
Two-Way Slab Design to BS 8110
PHP Code:
Account The Shear Size Of Bored Piles
Analysis of a sheet pile wall
Analysis of a slip on a long natural slope
Analysis of Gabions
Axial and Lateral Load Piles (FEM)
Bearing Capacity
Bore Pile Design BS 8004
Bored Pile Deep Foundation
Bored Piles For The Analysis of Layered Soil
Boring Log
Cantilever retaining wall analysis
Concrete Box Culvert analysis and Design
Drained Strip Foundation Enl997
Immediate Pad Footing Settlement
Lateral pressure against retaining wall due to surcharge loads
Pile Capacity Calculation
Reinforced Retaining Wall Design
Simple Geotechnics Calculations
Soil Arching - Braced Excavations
Surcharge Loads Tips - 2
Surcharge Loads types
Surcharge Point Loads
Tunnel Design - Initial Support with Steel Liner Plate
Wall Pressure Analysis
PHP Code:
20 Frame Analysis
Beam Analysis with FEM
Bolt Connection Analysis with FEM
ExcelFEM_ 20 (for Excel 2003)
Excel FEM_ 20 (for Excel 2007 Sl Excel 2010)
Exc elFEM_ 30 (for Excel 2003)
ExcelFEM_3D (for Excel 2007 & Excel 2010)
Truss Analysis with FEM
Download
http://s15.alxa.net/001/007/Engineer...readsheets.zip
