Tag: Spreadsheet

Circular Column Analysis and Design spreadsheet

Circular Column Analysis and Design spreadsheet

Circular Column is an Excel Spreadsheet template for the design of Circular columns using BS8110. Because of its shape, all columns are considered as subjected to uniaxial bending.
When it is required to consider a column with bi-axial bending, the two eccentricities can be combined to make it a column having one eccentricity moment. RoundCol can hold design information for up to 200 columns. Using a pull down combo box, the design information for any column can be retrieved, amended and re-saved for design use as and when necessary. Each Column in RoundCol can have up to 6 Loading Cases.
Although the design results are displayed for one load case at a time, Circular Column checks the design for all 6 loading cases in one step. If a column fails the design checks for any of its load cases, the Fail-Code is shown indicating the failure. Detailed results for any load case can be displayed by the click of its radio button and also printed as and when required.

[su_button url=”https://drive.google.com/open?id=18cbKBJ0XtqZlEChQwrgl4RyNmmgtPq79″ size=”7″ center=”yes”] Download Link[/su_button]

 

Concrete Box Culvert analysis and Design Spreadsheet

Concrete Box Culvert analysis and Design Spreadsheet

 

A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction.

Typically embedded so as to be surrounded by soil, a culvert may be made from a pipe, reinforced concrete or other material.

It’s a structure that carries water above land is known as an aqueduct.

Download Link

Crack Width Calculation Spreadsheet

Crack Width Calculation Spreadsheet

 

The crack width of a flexural member is calculated to satisfy a limit state of serviceability.
Among prestressed concrete members, there is cracking under service loads only for
Type 3 members. Hence the calculation of crack width is relevant only for Type 3
members. The crack width is calculated for the cracks due to bending which occur at
the bottom or top surfaces of a flexural member.
The flexural cracks start from the tension face and propagate perpendicular to the axis
of the member. This type of cracks is illustrated in Section 5.1, Analysis for Shear.
If these cracks are wide, it leads to corrosion of the reinforcing bars and prestressed
tendons. Also, the cracks tend to widen under sustained load or cyclic load. To limit
the crack width, Type 3 members have regular reinforcing bars in the tension zone
close to the surface, in addition to the prestressed tendons.

Download Link

Slope stability by the Simplified Bishop method

Slope stability by the Simplified Bishop method

 

Slope stability  spreadsheet currently supports analysis by the Simplified Bishop method.

Circular surfaces, 6 soil layers, pseudostatic seismic analysis, external uniformly distributed vertical loads, user defined piezometric line (including water level above the surface) and grid search with variable radia.

 

Download Link

Excel Sheet to Design Flat Slab According to Eurocode

Excel Sheet to Design Flat Slab According to Eurocode

Common practice of design and construction is to support the slabs by beams and support the beams by columns. This may be called as beam-slab construction.

The beams reduce the available net clear ceiling height. Hence in warehouses, offices and public halls some times beams are avoided and slabs are directly supported by columns.

 

This types of construction is aesthetically appealing also. These slabs which are directly supported by columns are called Flat Slabs.

 

Download Link

 

error: Content is protected !!
Exit mobile version