Bored Piles Wall and Ground Anchors spreadsheet

 

Contiguous piling is a highly effective method of creating a retaining wall before excavations even begin. An ideal solution for earth retention where existing structures are close to site boundaries and excavations where ground water is present, piled walls create a temporary or permanent retaining structure enabling safe excavation to take place after installation of the piles. This download will help you design them.

 

Download Link

Bearning Capacity for 2006 International Building Code spreadsheet

 

For evaluating net allowable bearing capacity of shallow foundations on granular soils based on 2006 International Building Code:

Calculation Reference
2006 International Building Code

 

Download Link

Anchor Bolt Anchorage ACI 318 spreadsheet

 

“Anchor Bolt.xls” is a MS-Excel spreadsheet workbook for the analysis of anchor bolt anchorage per the ACI 318-05, Appendix D. The spreadsheet is designed to find the strength of a determined anchor bolt or bolts within certain concrete parameters. Tables and figures have been given adjacent to the required data cells in an attempt to self contain the calculations within the worksheet. The spreadsheet is protected but with no password required.

Calculation Reference
ACI 318-05

 

Download Link

Bridge moment and shear envelopes spreadsheet

 

Moving truck (up to 20 axles) analysis for bridges with simple or continuous spans (up to 5). Envelopes (M & V) and support reactions.

Program

2 to 20 axles and 1 to 5 spans with El constant throughout. Truck will move from left to right with the first axle in front. Critical values of shears (absolute values) and moments will be computed on each division point. Total number of divisions must be less then 500. Results and graphs are displayed on Results, MEnvelope and VEnvelope worksheets.

Tips and Tricks

Reverse the truck geometry to simulate moving from right to left. Instead of axle loads, use wheel loads multiplied by impact and lateral distributions factors to obtain quickly design moments, shears and support reactions. Use q(uniform load) to simulate lane load. Dead load or any other uniform load may be simulated by using zero axle loads. For a simple span, for example. AASHTO users may simulate lane load by choosing 2 axles with the 2nd axle weight set to 0. 0.

 

Download Link

Influence line diagrams spreadsheet

 

 

Influence line diagrams spreadsheet calculates influence line diagrams for bending moments in a single span or continuous multi-span beam using the moment distribution method.

INSTRUCTIONS

1. Enter data in the yellow cells only.
2. Enter the Span Length for each span. Any number of spans may be analysed up to a maximum of 10. Any of the 10 spans not used will be removed when the “Calculate Critical Points” button is clicked . (Note: The print-out for more than 8 spans requires the paper orientaton to be set to ‘Landscape’).
3. Enter Modulus of Elasticity (E) multiplied by the Second Moment of Area (I) for each span. Relative values of EI may be used, for example, if the beam is of the same material and cross section throughout then a value of 1 may be entered for EI for each span.
4. Select the End Support Conditions (Fixed or Pinned) by clicking the option buttons.
5. Click the “Calculate Critical Points” button to analyse the beam to determinine the position of the maximum sagging moment in each span and the position of the load to give the maximum hogging moments at each supprt. The results are displayed in a drop-down menu labelled “Moments”.
6. Select the position of the Influence Line you require from the drop-down menu which will be displayed on the graph below. If you require an Influence Line for any other position on the beam then select “User Defined” from the menu and enter the distance of the required position from the left hand end of the beam.
7. The ‘Areas’ shown are the individual areas of the influence line diagram numbered in sequence from left to right as shown:
8. If a value of the influence line diagram is required at a specific distance along the structure then click the ‘Find Value’ button. The distance is measured from the left hand end of span 1.

* Influence Line Diagrams download link provides freeware version of the software.

 

Download Link