-

Engineering Spreadsheets

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 to use 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 do basic 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 & Structural Engineers for structural design.

All spreadsheets that you can download are fully functional.

This collection includes following spreadsheets under following categories,

Geotechnical design
Structural R/F concrete
Structural steel design & detailing
Bridge design
Timber design
Structural dynamics
Wind load calculation
Hydraulics and HydrologyContent

Civil Engineering Spreadsheets

Abutment Column Design
ACI 318-08 Rec Sec. Mx -Q-Torsion Design
ACI 350 & ACI224R-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
ASCE71OW – 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 to AS1720
Calculator for assessment of cold formed steel structures to AS4600
Calculator for assessment of steel structures to AS4100
Calculation of Plane Truss
Cold Formed Steel Sheds Australia Height Span Limits of C-Sections
Composite Column
Concrete Beam Design (CSA A23.1-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 to Australian Codes
IBC 2006 Seismic Calculation
IBC2000E – Seismic loading analysis for buildings and various non building structures
IBC2003E – Seismic loading analysis for buildings and various non building structures
IBC2006E – Seismic loading analysis for buildings and various non building structures
IBC2009E – 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 B58110
Micropile Structural Capacity Calculation
PCI Stud Tension Breakout
Pile design
Prestressed Girder Design
RC Element Design to Indian Standards
RC Rectangular Section Design to BS811O Part 1 & 2
Re Bars
Re Bars (318 -05)
Re Bars (318-08)
Re Bars (318M-05)
Rectangular HSS & Box Shaped Members
Rectangular HSS & 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 Pad Footing AS3600 Compliant
Reinforced Concrete Rectangular Columns
Reinforced Concrete Sections to BS 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 v1
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
AC1318-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 & Slabs
Grating Aluminum Beam Design
Historic 1939 UK Steel Section Properties
Indian Steel Sections
Influence lines in continuous beam

Structural Details

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 & 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 RP2A – 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

Geotechnical Spreadsheets

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 En1997
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

Finite Element Method (FEM) Spreadsheets

- 2D Frame Analysis
- Beam Analysis with FEM
- Bolt Connection Analysis with FEM
- ExcelFEM_ 2D (for Excel 2003)
- Excel FEM_ 2D (for Excel 2007 & Excel 2010)
- Exc eIFEM_ 3D (for Excel 2003)
- ExceIFEM_3D (for Excel 2007 & Excel 2010)
- Truss Analysis with FEM

Download Link

Seismic design of reinforced concrete primary beams to Eurocode 8

This is a spreadsheet for the seismic design of primary reinforced concrete beams to EN1998-1

It performs the following resistance and ductility verifications:
5.4.1.2.1(2) Maximum beam eccentricity
5.4.1.2.1(3) Maximum beam width
5.4.3.1.1(1) Resistance in bending and shear
5.4.3.1.1(3) Effective flange width beff
5.4.3.1.2(1) Length of critical zones lcr
5.4.3.1.2(3) Curvature ductility factor – Cl. 5.2.3.4(3)
5.4.3.1.2(4) a) Minimum reinforcement at the compression zone
5.4.3.1.2(4) b) Maximum reinforcement ratio of the tension zone
5.4.3.1.2(5) Minimum reinforcement ratio of the tension zone
5.4.3.1.2(6) a) Minimum diameter of hoops within the critical regions
5.4.3.1.2(6) b) Maximum spacing of hoops within the critical regions
5.6.2.2(2) Anchorage of beam reinforcement – maximum bar diameter

Download Link

Source: https://www.linkedin.com/in/andresilvacorreia

Estimation of soil improvement by vibro replacement

A preliminary estimation of the effectiveness of soil improvement by vibro replacement with stone columns is performed classicaly by Priebe’s method, which has been implemented in several dedicated commercial softwares. However, this method is simple enough to incorporate in a simple spreadsheet, with no special programming. The method is described extensively in “Priebe, H.J. (1995) The design of Vibro Replacement, Ground Engineering (Dec), pp 31-37.”

An implementation of Priebe’s method for infinite loaded areas and for square footings has been added to the “Downloads” section of the website. This spreadsheet, is completely free and open-source and comments and suggestions for improvement are always welcome.

Download Link

Source: https://www.linkedin.com/in/andresilvacorreia

Analysis of laterally loaded piles on elasto-plastic springs

This is a spreadsheet for the analysis of laterally loaded single elastic piles. The pile-soil interaction is modelled with elasto-plastic springs defined by their stiffness and maximum force. Free or fixed conditions may be specified at the pile head.

This soil behaviour model provides excellent results and is usually sufficient to handle most of the buiding and bridge foundations design work. However, more advanced p-y or continuum models may be necessary for large rafts, high loads, offshore structures, unusual geotechnical conditions, cyclic loading, etc. As usual with any tool, proper engineering judgement is required.

An auxiliary worksheet is included in the file to demonstrate the calculation of spring properties. It presents an example that correlates CPT qc values with corrected SPT data and then proceeds to calculate springs’ stiffness and maximum passive forces.

The program allows the use of elastic piles of any shape, as the pile stiffness must be introduced directly and the soil springs properties input into the main worksheet already multiplied by their respective influence width.

Second order geometrically non-linear effects (P-Delta) are not taken into account in the analysis. Piles are assumed to remain elastic throughout the loading process.

The VBA module is, as usual, open source and the code is commented thoroughly.

Download Link

Source: https://www.linkedin.com/in/andresilvacorreia

Design of 2 and 4 piles caps by the Strut and Tie method

Two spreadsheets for the design of 2 and 4 piles caps by the Strut and Tie Method, taking into consideration the stress limits in EN1992-1-1.

The spreadsheet uses a combined model, allowing the use of the column reinforcement to reduce the compressive forces on the CCC(C) node at the column/cap connection. Only compressive axial forces in the column are considered.

Detailed handwritten notes of the model assumptions are also included in the files.

Download Links:

2 Piles cap

4 Piles cap

Slope stability by the Simplified Bishop method

Slope stability spreadsheet currently supports analysis by the Simplified Bishop method.

Circular surfaces, 6 soil layers, pseudostatic seismic analysis, external uniformly distributed vertical loads, user defined piezometric line (including water level above the surface) and grid search with variable radia.

Download Link

Method Statement Template for Civil Work

A work method statement sometimes called a “safe system of work”, is a document that details the way a work task or process is to be completed.

The method statement should outline the hazards involved and include a step by step guide on how to do the job safely.

[su_button url=”https://drive.google.com/open?id=1h3Ia-dmqrxS2tiRrOJUB7DtG9Zn5xVwj” size=”7″ center=”yes”] Download Link[/su_button]

Engineering with the Spreadsheets by ASCE

Today, the spreadsheet is an essential tool for engineers. Christy provides the tools needed to quickly apply the powerful analytic capability of Microsoft Excel to structural engineering applications. The book and CD-ROM present more than 50 ready-to-use Excel templates that demonstrate basic calculations and presentation techniques as well as advanced functions that may be unfamiliar to even experienced users. Applications include concrete, wind and seismic issues, foundation soil loading, the vortex shedding of tall stacks, and other engineering issues.Beneficial to professionals and college students alike, Engineering with the Spreadsheet is an indispensable resource for structural engineers.

Engineering_with_the_spreadsheets
10 Absolute Relative References.xls
11 Circular Reference.xls
12 Logic.xls
13 Database.xls
14 Regression Analysis.xls
15 Takedown.xls
16 Pole.xls
17 Numerical Integration.xls
18 Matrix Math.xls
19 Exhaust Stack Cover.xls
20 Seismic.xls
21 Wind.xls
23 Vortex Shedding.xls
24 Bolt Patterns.xls
25 Bolt Threads.xls
27 Bolt Group Pullout.xls
28 Roark Flat Plates.xls
30 Foundation Loading.xls
31 Foundation Design.xls
33 Concrete Beam.xls
34 Concrete Shear.xls
37 Tank Support Cover.xls
38 Seismic.xls
39 Seismic ASCE 7-02_05.xls
40 Celerity.xls
41 LRFD.xls
42 Pile Foundation.xls
43 Two Way Slab Loading.xls
45 Concrete Column.xls
46 Partial Shell.xls
47 Concrete Column Photos.xls
48 Concrete Shear.xls
49 Column Deck Interface.xls
50 Column Slab Moment Shear Transfer.xls
51 Bolt Group Pullout.xls
52 Embed.xls
53 Concrete Beam.xls
54 Tank Test Measurements.xls
56 LRFD Compared.xls
57 Acceleration.xls
58 Quadratic and Cubic Equations.xls
59 LISP.xls
60 Units.xls
61 Notation.xls
_2 Tips.xls
_2 Tipslinks.xls
_3 Worksheet_70.xls
_4 Editing in Excel.xls
_5 Math Editing.xls
_6 Symbols.xls
_7 Drawing in Excel.xls
_8 Pictures.xls
_9 Graphing.xls
Sample Header.xls

[su_button url=”https://drive.google.com/open?id=1VxADPlrYNG6nM2r4J79P8kQwRCi4q4NI” size=”7″ center=”yes”] Download Link[/su_button]

Excel Sheet to Design Basement Wall

This Excel sheet to design Concrete Basement Wall details strength design (durability and other considerations not included) for a new buried concrete basement wall in a single-story masonry building.

The example follows the provisions of ACI 318-11, Building Code Requirements for Structural Concrete. Throughout the example, discussion of the “in practice” decisions/situations the designer may encounter are included. Additionally, at the conclusion of the problem some “what-ifs” are evaluated.

ACI Committee E702, “Designing Concrete Structures Committee,” is part of the ACI Educational Committee structure.

Their mission is to develop educational programs and instructional materials within the area of design.

The committee has developed various design examples to illustrate the use of various ACI documents.

These examples provide step-by-step calculations with references to applicable code provisions for common member design problems, and may also include calculations for common concrete testing procedures, field data analysis, or evaluations.

[su_button url=” https://drive.google.com/open?id=1jals_5SHu1h6Lbyq1wACskjQog_-g6LT” size=”7″ center=”yes”] Download Link[/su_button]

Excel Sheet to Design Flat Slab According to Eurocode

Common practice of design and construction is to support the slabs by beams and support the beams by columns. This may be called as beam-slab construction.

The beams reduce the available net clear ceiling height. Hence in warehouses, offices and public halls some times beams are avoided and slabs are directly supported by columns.

This types of construction is aesthetically appealing also. These slabs which are directly supported by columns are called Flat Slabs.

Download Link