Excel Sheet Plan Sketch for drawing simple Floor
A spreadsheet for drawing simple Floor Plan Sketeches.
Tag: Excel Sheet
RETWALL – Retaining Wall Under Earth Pressure and Other Loads
RETWALL – Retaining Wall Under Earth Pressure and Other Loads
RetWall is an Excel Spreadsheet for the analysis of Retaining Walls subjected to lateral and vertical loads. Using its analysis results, the wall stem and its base can be sized to have adequate stability and strength for resisting applied loads.
RetWall helps save design time by avoiding cumbersome hand calculations. It does not aim to predict the real behaviour which may differ from that generally assumed in routiine calculations.
RetWall is therefore a tool to complement the design steps for sizing and detailing such structures.
Soil Arching – Braced Excavation Excel Sheet
Soil Arching – Braced Excavation Excel Sheet
This 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
Excel Sheet Culvert Box calculation and drawing
Excel Sheet Culvert Box calculation and drawing
A culvert box is an essential component of any roadway infrastructure. It is a type of drainage structure designed to channel water under a roadway or other transportation facility.
Culvert boxes are typically constructed from reinforced concrete and are available in a variety of shapes and sizes, including circular, oval, and rectangular. They are a critical element in maintaining safe and reliable transportation systems, preventing flooding and erosion, and protecting the environment.
Suggested Read:
Reinforced Concrete Box Culvert Calculation Spreadsheet
Standard DWG Autocad Drawing For Box Cell Culvert
Pipe Culvert Wing Wall CAD template DWG
Culvert General Plan and Sections Details CAD Template DWG
Box Culvert Curved Concrete Layout CAD Template DWG
Box Culvert Concrete Reinforcement Details CAD Template DWG
Culvert Concrete Reinforcement Details CAD Template DWG
Box Culvert Design and Calculation Spreadsheet
Cantilever Retaining Wall Analysis Excel Sheet
Cantilever Retaining Wall Analysis Excel Sheet
Purpose of calculation: The details of a cantilever retaining wall are shown below, is the design of the wall satisfactory?
Calculation Reference: Craig Soil Mechanics. R.F. Craig
Calculation Validation: Check against a worked example in the reference above.
Calculation Parameters :
- Surcharge Pressure
- Thickness of the Stem
- Thickness of the Base
- Length of Backfill
- Height of Wall from the Base
- Width of the Base
- Characteristics of Backfill
- Drained (effective stress) Shear Strength Parameter
- Unit Weight of the backfill
- Drained (effective stress) Shear Strength Parameter
- Characteristics of Concrete
- Unit Weight of Concrete
- Angle of friction between the base and the foundation soil is
- Active earth pressure coefficient
- Horizontal Forces
- Sum of Horizontal Forces
- Vertical Forces
- Sum of Vertical Forces
- Lever
- Moments
- Lever arm of base resultant
- FoS against overturning
- Eccentricity of base reaction
- Maximum and minimum base pressures
- FoS against sliding
Calculation Reference
Geotechnics
Bored Piles For The Analysis of Layered Soil Excel Sheet
Bored Pile Design Foundation Excel Sheet
Bored Pile Design Foundation Excel Sheet
Pile design following methods in Foundation Design 2nd Edt’n by Donald Coduto coverin:
- Timber Piles
- Pipe Piles
- Bored Piles
Calculation Reference
Foundation Design 2nd Edt’n by Donald Coduto
Bore Pile Design BS 8004 Excel Sheet
Bore Pile Design BS 8004 Excel Sheet
Spreadsheet to calculate pile bearing capacity of drilled shaft foundation – bore pile according to BS 8004. For preliminary design purposes, BS 8004 gives presumed bearing values which are the pressures which would normally result in an adequate factor of safety against shear failure for particular soil types, but without consideration of settlement.
| Category | Types of rocks and soils | Presumed bearing value |
| Non-cohesive soils | Dense gravel or dense sand and gravel | >600 kN/m² |
| Medium dense gravel, or medium dense sand and gravel |
<200 to 600 kN/m² | |
| Loose gravel, or loose sand and gravel | <200 kN/m² | |
| Compact sand | >300 kN/m² | |
| Medium dense sand | 100 to 300 kN/m² | |
| Loose sand | <100 kN/m² depends on degree of looseness |
|
| Cohesive soils | Very stiff bolder clays & hard clays | 300 to 600 kN/m² |
| Stiff clays | 150 to 300 kN/m² | |
| Firm clay | 75 to 150 kN/m² | |
| Soft clays and silts | < 75 kN/m² | |
| Very soft clay | Not applicable | |
| Peat | Not applicable | |
| Made ground | Not applicable |
Calculation Reference
Reinforced Concrete Design
Axial and Lateral Load Piles Excel Sheet
Axial and Lateral Load Piles Excel Sheet
AXIAL AND LATERAL LOAD PILES ( FEM )
- axial load
- moment load
- horizontal load
- deflections diagrams
- forces diagrams
- lateral capacity
- axial capacity
- rc design
(winkler soil model and FEM)
Calculation Reference
Geotechnics
Design of Precast Prestressed Composite Beams Excel Sheet
Design of Precast Prestressed Composite Beams Excel Sheet
The precast prestressed concrete units are erected first and can be used to support the formwork needed for the cast in situ slab without additional scaffolding (or shoring).
In addition to its contribution to the strength and stiffness of the composite member, the cast in situ slab provides an effective means to distribute loads in the lateral direction.
The cast in situ slab can be poured continuously over the supports of precast units placed in series, thus providing continuity to a simple span system.Pre-tensioning in plant is more cost-effective than post-tensioning on site.
Because the precast 4 prestressed concrete element is factory-produced and contains the bulk of reinforcement, rigorous quality control and higher mechanical properties can be achieved at relatively low cost. The cast in situ concrete slab does not need to have high mechanical properties and thus is suitable to field conditions.