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

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]

 

Light Gage Truss Design Based on AISI 2001 & ER-4943P

 

The most complex component designed in light gauge framed residential structures are Roof trusses.

In the design of light gauge cold formed metal trusses, the designer is meant to adhere to the requirements of Loading standards and steel design standards.

Designers need to ensure that all the loads and load combinations stipulated in NASH Standard Residential and Low-rise Steel Framing Part 1 Design Crieteria and AS 4055 are checked and that the support, restraint conditions are accurately considered in the analysis.Various loads, load combinations, wind pressure coefficients, restraint and support conditions will be discussed in this paper.

In the design of truss members, the requirement of AS/NZS 4600 should be strictly adhered. Effective length criteria for truss members is also discussed in this paper.

This paper provides an illustrative example fo truss design using light gauge cold formed steel members.

 

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