-

Elastic Analysis of Reinforced and Prestressed Sections Spreadsheet

The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis:

For a cross section with any applied axial load at eccentricity e, measured from the compression face, and depth of the neutral axis X below the compression face:

INA = QNA(X + e)

Where QNA and INA are the first and second moments of area about the neutral axis.

To illustrate this relationship the value of INA has been plotted for a range of neutral axis positions for a typical precast bridge beam, shown below, and compared with the value QNA(X + e) for 5 different values of e.

The intersection of the INA and QNA(X + e) lines gives the depth of the neutral axis for the corresponding value of load eccentricity, e. This is illustrated in the second graph, where the value of (INA – QNA(X + e)) is plotted against the depth of the neutral axis, X, for a load eccentricity of 1 metre above the compression face.

The intersection of this line with the X axis gives the depth of the neutral axis for the specified load eccentricity.

Note: Another calculation file ULS Design Functions.zip contains User Defined Functions (UDF’s) that will find the ultimate bending capacity of any reinforced or prestressed concrete section

Download Link

Single span beam analysis spreadsheet

Single span beam analysis spreadsheet is a MS-Excel spreadsheet workbook for the analysis of single-span beams (simple, propped, fixed, or cantilever) and continuous beams of up to 5 spans.

The user may apply point, uniform, and varying loads, as well as applied moments. Shear, moment, slope (rotation), and deflection are computed as well as the end reactions. Shear and moment diagrams are also plotted.

There is an addtional worksheet for single-span beams that also performs AISC 9th Edition Code checks for strong-axis bending (only) as well as shear.
All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.

Download Link

Aluminium design capacity spreadsheet

Aluminium design capacity spreadsheet will help you design structural and architectural pipe on your building construction whether it is residential, commercial & plant projects. It optimizes the pipe design so that designer can attain the effective, efficient, safe and economical sizes of aluminum pipe.

Calculation Reference
Strength of Aluminium

Download Link

AIC318-08 RC Beam spreadsheet

Analysis and design of RC beam as per ACI318-08.

Calculation Reference
Reinforced Concrete

Download Link

AASHTO LRFD Concrete Slab and Wall design spreadsheet

AASHTO 2004 LRFD SLAB DESIGN: This spreadsheet was created to aid in the rapid design and/or checking of Bridge Decks or Reinforced Concrete Boxes in accordance with AASHTO 2004 LRFD. The 2nd Bar layer is particularly handy for different bar sizes used in the same layer, such as in Bridge Deck Cantilevers.

Calculation Reference
AASHTO LRFD

Download Link

Method of jetgrouting spreadsheet

Drilling is typically performed using rotary drilling techniques and an external water flush with special drill rods and bits. Upon completion of the advancement of the drill rods to the design depth, the jet grouting process commences. The grout is injected through radial nozzles at high pressure and velocity, destroying the soil matrix and forming structural elements.

Many structures and geometries can be achieved by altering the parameters of the jetting procedure. The illustrated procedure details the creation of a jet grout column by continuous rotation of the drill string and controlled pre-set lifting increments.

Calculation Reference
Jet Grouting

Download Link

Reinforced Retaining Walls Design Spreadsheet

Retaining walls must be reinforced in order to be effective. Too many forces are at work against a retaining wall that could cause it to tumble over if it is not reinforced correctly.

Calculation Reference
Reinforced Concrete

Download Link

Simple Geotechnics Calculations spreadsheet

Purpose of calculation: In its natural condition a soil sample has a mass of 2290g and a volume of 1.15 x 10ˉ³m³. After being completely dried in an oven the mass of the sample is 2035g. Determine the bulk density, unit weight, water content, void ratio, porosity, degree of saturation and air content.

Calculation Reference: Craig Soil Mechanics. R.F. Craig

Calculation Validation: Check against a worked example in the reference above.

Calculation Reference
Geotechnics

Download Link

Soil Arching Effect for Braced Excavations Spreadsheet

Soil Arching Effect for Braced Excavations Spreadsheet will calculate the horizontal earth pressure exerted on a braced excavation using Soil Arching Theory as proposed by Richard L. Handy (1985).

Calculation Reference
Soil Mechanics

Download Link

Column Shear Capacity spreadsheet

Column shear capacity spreadsheet calculates shear capacity and confinement reinforcement of circular and oblong shape reinforced concrete columns in compliance with seismic provisions of AASHTO 17th edition and and AASHTO LRFD.

The spreadsheet design is based on interpretation of design methodology. As much as the authors have tried to achieve an accurate product, the codes rely upon interpretation as well as decisions drawn from engineering judgment. There are no guarantees or express warranties implied in the use or output of these programs that assures accuracy other than the efforts of the programmers’ intent to achieve perfection.

Download Link