Deterministic Shallow Foundation Design Using SPT Data Spreadsheet
Tag: Excel Sheet
Spears Lab Spreadsheet
Universal Soil Loss Equation Spreadsheet
Universal Soil Loss Equation Spreadsheet
The Universal Soil Loss Equation predicts soil loss from sheet and rill types of water erosion based on site characteristics and management inputs. The USLE predicts if erosion will exceed a “tolerable” rate. Conservation hints and explanations of equation factors help users understand soil erosion processes and thier control.
Forces due to torsion moment distributions on walls and columns Spreadsheet
Jetty Design and calculation Spreadsheet
Design of Prestressed Double Tee Beams Spreadsheet
Design of Prestressed Double Tee Beams Spreadsheet
This spreadsheet related to the design of double tee(DT) prestressed beams, with reference to PCI & ACI 318-07.
Calculation Reference
Prestressed Beam
Composed Column Calculation Spreadsheet
Concrete Special Structural Wall ACI 318-08 Spreadsheet
Concrete Special Structural Wall ACI 318-08 Spreadsheet
The International Building Code (IBC) requires all concrete walls in seismic category D, E, and F, must be designed as a Special Reinforced Concrete Shear Wall. Basically all concrete walls in the West Coast of the US must be designed as a special wall.
The calcs in this spreadsheet are transparent unlike the typical blackbox calculations.
Also the figure of the wall in the spreadsheet changes with the input parameters.
The spreadsheet checks essentially all of the applicable codes in the ACI 318-08. The spreadsheet contains extensive boolean programming to address the convoluted nature of the code provisions for special concrete structural walls.
Anyone who has designed a special concrete structural wall knows how extremely complicated it can be, and will surely appreciate how easy to use and how thorough this spreadsheet is.
IMPORTANT: If upon opening this file, a warning message about circular referencing appears, DO NOT CLICK OK. You must CLICK CANCEL, click on Tools -> Options -> Calculation tab and enable Iteration as shown in the picture to the right. or the spreadsheet will not work properly. The reason for iteration: A vertical axial load P applied eccentrically on the wall will induce a deflection in the wall. The axial load P applied eccentrially on a wall that is deflected will cause it to deflect more. If this iteration was to be calculated by hand, it will take multiple iterations before the numbers converge to an acceptable level.
Calculation Reference
Reinforced Concrete
