Category: RESOURCES

Crack Width Calculation Spreadsheet

Crack Width Calculation Spreadsheet

 

The crack width of a flexural member is calculated to satisfy a limit state of serviceability.
Among prestressed concrete members, there is cracking under service loads only for
Type 3 members. Hence the calculation of crack width is relevant only for Type 3
members. The crack width is calculated for the cracks due to bending which occur at
the bottom or top surfaces of a flexural member.
The flexural cracks start from the tension face and propagate perpendicular to the axis
of the member. This type of cracks is illustrated in Section 5.1, Analysis for Shear.
If these cracks are wide, it leads to corrosion of the reinforcing bars and prestressed
tendons. Also, the cracks tend to widen under sustained load or cyclic load. To limit
the crack width, Type 3 members have regular reinforcing bars in the tension zone
close to the surface, in addition to the prestressed tendons.

Download Link

Prestressed Concrete Girder Design for Bridge Structure spreadsheet

Prestressed Concrete Girder Design for Bridge Structure spreadsheet

Post tensioned simply supported prestressed concrete (PC) I-girder bridges are
widely used bridge system for short to medium span (20m to 50m) highway bridges due to its moderate self weight, structural efficiency, ease of fabrication, low maintenance etc. In order to compete with steel bridge systems, the design of PC I-girder Bridge system must lead to the most economical use of materials. In this paper, cost optimization approach of a post-tensioned PC I-girder bridge system is presented. The objective is to minimize the total cost in the design process of the bridge system considering the cost of materials, fabrication and installation. For a particular girder span and bridge width, the design variables considered for the cost minimization of the bridge system, are girder spacing, various cross sectional dimensions of the girder, number of strands per tendon, number of tendons, tendons configuration, slab thickness and ordinary reinforcement for deck slab and girder.

Download Link

Stair Flight and Landing Design Spreadsheet

Stair Flight and Landing Design Spreadsheet

Stair Flight and Landing Design Spreadsheet with easy and simple method
STAIRCASE is the structural members which provide vertical movement (circulation) between floors of the building at different vertical levels.
The stairs of RC buildings may be designed by using various materials (wood, steel, RC, etc.).
The idealization of support conditions of the stairs may not be straightforward as in other parts of the building.Therefore, a careful assumption should be made. Different assumptions may lead to different design solutions for the same staircase.
Basic Definitions: flight of step,landing, step width, step height,stair width.

Download Link

Engineering Spreadsheets

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

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

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

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

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

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]

error: Content is protected !!
Exit mobile version