Reinforced concrete staircases spreadsheet
Tag: Spreadsheet
Pile Cap Design Spreadsheet to BS 8110:1997
Pile Cap Design Spreadsheet to BS 8110:1997
Pilecap Design is a spreadsheet for the design and detailing of reinforced concrete pilecaps. Caps for two, three, four, five and six pile groups are catered for standard reinforcement detail drawings can be printed and bar scheduling to BS 8666:2000 can be produced.
The spreadsheet has been created by Rod Webster, principal author of the Reinforced Concrete Council’s spreadsheets.
Welds in shear, bending, torsion and axial loading spreadsheet
Welds in shear, bending, torsion and axial loading spreadsheet
WeldCalc is an Excel Template for the design of weld groups having any configuration of multi-linear weld lengths in an x-y plane. It uses the elastic method to analyse weld groups subjected to simultaneous tension, compression, shear, bending and or torsion in x, y and z directions. If present, it takes into account the influence of unsymmetrical bending in its analysis.
WeldCalc analyses any configuration of multi-linear weld lengths in an X-Y plane. The loads can be shear, moment, torsion and axial applied simultaneously.
WeldCalc calculates the induced stress at each node and identifies the node most highly stressed. It also calculates the magnitude of load resisted by each length of weld in the x, y and z direction.
A weld group can have up to 30 Nodes or 29 weld lengths. The line of weld lengths can be continuous or discontinuous. Each continuous series of weld lengths is termed as a Part and it is given a reference number starting from 1 onwards. A weld group can have up to 15 parts connecting 30 nodes in any pattern.
WeldCalc is supplied as an Excel Template, having .XLT as its filename extension.
You can use WeldCalc by opening its file directly or copying it into the Microsoft Office folder for its Templates. Consult Microsoft Office documentation for the path to this folder.
AASHTO Steel Tunnel Liner Plate spreadsheet
AASHTO Steel Tunnel Liner Plate spreadsheet
Smooth-back tunnel liner plate in soft ground
Purpose:
To design an initial liner for a tunnel using steel liner plate.
Hoop thrust capacity of the liner is checked for a specified overburden pressure, hydrostatic pressure, and live load pressure, which consists of either AASHTO H-20 Truck Loading or Cooper E-80 Train Loading (Per AREMA).
Assumptions/Limitations:
- Surrounding ground consists of granular or cohesive soil (Not rock)
- Tunnel support is 2-flange or 4-flange, smooth-back liner plate.
- Liner plate joints (flanges) are non-compact (not slender)
Boring Logs spreadsheet
Boring Logs spreadsheet
Boring Logs spreadsheet is a sample spreadsheet for boring log which is very helpful for Geotechnical Engineers. Borehole logs are used to display the results of oil and gas, mining, geotechnical and environmental drilling and sampling. Logs can be used to display soil and rock samples.
Calculation Reference
Geotechnics
Immediate Pad Footing Settlement spreadsheet
Immediate Pad Footing Settlement spreadsheet
Immediate Pad Footing Settlement spreadsheet calculates the immediate settlement of a pad footing given size and soil modulus. Based on equations in “Bowles : Foundation Analysis and Design Fifth addition international,Foundation Settlements pg303 Immediate Settlement Computations”
Calculation Reference
Bowles : Foundation Analysis and Design
Bridge Design Assessment Spreadsheet
Bridge Design Assessment Spreadsheet
Bridge Design Assessment spreadsheet will guide you through to calculate various MEXE Analysis and bridge related calculations.
This spreadsheet has been specially organized in accordance with calculate the capacity of a masonry arch using the modified MEXE process.
INSTRUCTIONS FOR USE:
- Put data in the yellow cells only. Factors may also be selected from the factor description.
- Symbols and factors are as described in the DMRB Standard BA16/97 Chapter 3.
Beams on Elastic Foundation spreadsheet
Beams on Elastic Foundation spreadsheet
Beams on Elastic Foundation is a spreadsheet program written in MS-Excel for the purpose of analysis a finite length beam with free ends supported continuously on an elastic foundation.
This program is ideally suited for analyzing a soil supported beam, a combined footing, or a strip of a slab or a mat.
Specifically, the beam shear, moment, deflection, and soil bearing pressure are calculated for 100 equal beam segments, as well as the maximum values. Plots of both the shear, moment, and soil bearing pressure diagrams are produced, as well as a tabulation of the shear, moment, deflection, and bearing pressure for the beam. This program is a workbook consisting of three (3) worksheets, described as follows:
- Doc – documentation sheet
- Beam on Elastic Fdn. (English) – Beam on elastic foundation analysis (English units)
- Beam on Elastic Fdn. (metric) – Beam on elastic foundation analysis (metric units)
Analysis for Flat roof systems in structural steel spreadsheet
Analysis for Flat roof systems in structural steel spreadsheet
“PONDING9” is a spreadsheet program written in MS-Excel for the purpose of analysis for ponding for low slope or flat roof systems in structural steel per the AISC 9th Edition (ASD) Code, pages 5-83 to 5-84 and 5-175 to 5-179.
Specifically, simplified checks are performed for the steel members as well as the steel deck. A rigorous analysis, whether actually required or not, is also performed for the steel members.
This program is a workbook consisting of two (2) worksheets, described as follows:
- Doc – Documentation sheet
- Ponding – Ponding analysis per AISC 9th Edition (ASD) Manual
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.
Program Assumptions and Limitations:
1. This program utilizes the equations in AISC Code Sect. K2 to perform a simplified check on the primary and secondary members, as well as the steel roof deck.
2. This program also performs a rigorous analysis on the primary and secondary members utilizing the equations in AISC Code Commentary Sect. C-K2.
3. This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular “comment box”.)
Calculation Reference
AISC
Surcharge point loads spreadsheet
Surcharge point loads spreadsheet
Retaining walls are built in order to hold back earth which would otherwise move downwards. A surcharge load results from forces that are applied along the surface of the backfill behind the wall. These forces apply additional lateral forces along the back of the wall. This spreadsheet calculates the resulting pressure field acting on the retaining wall due to a point load at a given position behind the wall.
Calculation Reference
Surcharge Loads